github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/xform/testdata/external/navicat (about) 1 exec-ddl 2 CREATE TABLE pg_class ( 3 oid oid PRIMARY KEY, 4 relname text NOT NULL, 5 relnamespace oid NOT NULL, 6 reltype oid NOT NULL, 7 relowner oid NOT NULL, 8 relam oid NOT NULL, 9 relfilenode oid NOT NULL, 10 reltablespace oid NOT NULL, 11 relpages bigint NOT NULL, 12 reltuples double precision NOT NULL, 13 relallvisible bigint NOT NULL, 14 reltoastrelid oid NOT NULL, 15 relhasindex boolean NOT NULL, 16 relisshared boolean NOT NULL, 17 relpersistence text NOT NULL, 18 relistemp boolean NOT NULL, 19 relkind text NOT NULL, 20 relnatts bigint NOT NULL, 21 relchecks bigint NOT NULL, 22 relhasoids boolean NOT NULL, 23 relhaspkey boolean NOT NULL, 24 relhasrules boolean NOT NULL, 25 relhastriggers boolean NOT NULL, 26 relhassubclass boolean NOT NULL, 27 relfrozenxid bigint NOT NULL, 28 relacl text[], 29 reloptions text[], 30 UNIQUE INDEX pg_class_relname_nsp_index (relname, relnamespace), 31 INDEX pg_class_tblspc_relfilenode_index (reltablespace, relfilenode) 32 ); 33 ---- 34 35 exec-ddl 36 CREATE TABLE pg_namespace ( 37 oid oid PRIMARY KEY, 38 nspname text NOT NULL, 39 nspowner oid NOT NULL, 40 nspacl text[], 41 UNIQUE INDEX pg_namespace_nspname_index (nspname) 42 ); 43 ---- 44 45 exec-ddl 46 CREATE TABLE pg_tablespace ( 47 oid oid PRIMARY KEY, 48 spcname text NOT NULL, 49 spcowner oid NOT NULL, 50 spclocation text NOT NULL, 51 spcacl text[], 52 spcoptions text[], 53 UNIQUE INDEX pg_tablespace_spcname_index (spcname) 54 ); 55 ---- 56 57 exec-ddl 58 CREATE TABLE pg_inherits ( 59 inhrelid oid NOT NULL, 60 inhparent oid NOT NULL, 61 inhseqno bigint NOT NULL, 62 PRIMARY KEY (inhrelid, inhseqno), 63 INDEX pg_inherits_parent_index (inhparent) 64 ); 65 ---- 66 67 exec-ddl 68 CREATE TABLE pg_index ( 69 indexrelid oid PRIMARY KEY, 70 indrelid oid NOT NULL, 71 indnatts bigint NOT NULL, 72 indisunique boolean NOT NULL, 73 indisprimary boolean NOT NULL, 74 indisexclusion boolean NOT NULL, 75 indimmediate boolean NOT NULL, 76 indisclustered boolean NOT NULL, 77 indisvalid boolean NOT NULL, 78 indcheckxmin boolean NOT NULL, 79 indisready boolean NOT NULL, 80 indislive boolean NOT NULL, 81 indisreplident boolean NOT NULL, 82 indkey bigint[] NOT NULL, 83 indcollation bigint NOT NULL, 84 indclass bigint NOT NULL, 85 indoption bigint NOT NULL, 86 indexprs text, 87 indpred text, 88 INDEX pg_index_indrelid_index (indrelid) 89 ) 90 ---- 91 92 exec-ddl 93 CREATE TABLE pg_foreign_table ( 94 ftrelid oid PRIMARY KEY, 95 ftserver oid NOT NULL, 96 ftoptions text[] 97 ); 98 ---- 99 100 exec-ddl 101 CREATE TABLE pg_foreign_server ( 102 oid oid PRIMARY KEY, 103 srvname text NOT NULL, 104 srvowner oid NOT NULL, 105 srvfdw oid NOT NULL, 106 srvtype text, 107 srvversion text, 108 srvacl text[], 109 srvoptions text[], 110 UNIQUE INDEX pg_foreign_server_name_index (srvname) 111 ); 112 ---- 113 114 opt 115 SELECT 116 c.oid, 117 n.nspname AS schemaname, 118 c.relname AS tablename, 119 c.relacl, 120 pg_get_userbyid(c.relowner) AS tableowner, 121 obj_description(c.oid) AS description, 122 c.relkind, 123 ci.relname AS cluster, 124 c.relhasoids AS hasoids, 125 c.relhasindex AS hasindexes, 126 c.relhasrules AS hasrules, 127 t.spcname AS tablespace, 128 c.reloptions AS param, 129 c.relhastriggers AS hastriggers, 130 c.relpersistence AS unlogged, 131 ft.ftoptions, 132 fs.srvname, 133 c.reltuples, 134 ((SELECT count(*) FROM pg_inherits WHERE inhparent = c.oid) > 0) AS inhtable, 135 i2.nspname AS inhschemaname, 136 i2.relname AS inhtablename 137 FROM pg_class AS c 138 LEFT JOIN pg_namespace AS n 139 ON n.oid = c.relnamespace 140 LEFT JOIN pg_tablespace AS t 141 ON t.oid = c.reltablespace 142 LEFT JOIN 143 ( 144 pg_inherits AS i 145 INNER JOIN pg_class AS c2 146 ON i.inhparent = c2.oid 147 LEFT JOIN pg_namespace AS n2 148 ON n2.oid = c2.relnamespace 149 ) AS i2 150 ON i2.inhrelid = c.oid 151 LEFT JOIN pg_index AS ind 152 ON (ind.indrelid = c.oid) AND (ind.indisclustered = 't') 153 LEFT JOIN pg_class AS ci 154 ON ci.oid = ind.indexrelid 155 LEFT JOIN pg_foreign_table AS ft 156 ON ft.ftrelid = c.oid 157 LEFT JOIN pg_foreign_server AS fs 158 ON ft.ftserver = fs.oid 159 WHERE ((c.relkind = 'r'::CHAR) OR (c.relkind = 'f'::CHAR)) AND (n.nspname = 'public') 160 ORDER BY schemaname, tablename 161 ---- 162 sort 163 ├── columns: oid:1!null schemaname:29!null tablename:2!null relacl:26 tableowner:133 description:134 relkind:17!null cluster:92 hasoids:20!null hasindexes:13!null hasrules:22!null tablespace:33 param:27 hastriggers:23!null unlogged:15!null ftoptions:120 srvname:122 reltuples:10!null inhtable:135!null inhschemaname:69 inhtablename:42 164 ├── stable 165 ├── fd: ()-->(29), (1)-->(2,10,13,15,17,20,22,23,26,27,33,133,134), (2)-->(1,10,13,15,17,20,22,23,26,27,33,133,134) 166 ├── ordering: +2 opt(29) [actual: +2] 167 └── project 168 ├── columns: tableowner:133 description:134 inhtable:135!null c.oid:1!null c.relname:2!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.nspname:29!null spcname:33 c2.relname:42 n2.nspname:69 ci.relname:92 ftoptions:120 srvname:122 169 ├── stable 170 ├── fd: ()-->(29), (1)-->(2,10,13,15,17,20,22,23,26,27,33,133,134), (2)-->(1,10,13,15,17,20,22,23,26,27,33,133,134) 171 ├── group-by 172 │ ├── columns: c.oid:1!null c.relname:2!null c.relowner:5!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.nspname:29!null spcname:33 c2.relname:42 n2.nspname:69 ci.relname:92 ftoptions:120 srvname:122 count_rows:132!null rownum:136!null 173 │ ├── grouping columns: rownum:136!null 174 │ ├── key: (136) 175 │ ├── fd: ()-->(29), (1)-->(2,5,10,13,15,17,20,22,23,26,27,33), (2)-->(1,5,10,13,15,17,20,22,23,26,27,33), (136)-->(1,2,5,10,13,15,17,20,22,23,26,27,29,33,42,69,92,120,122,132) 176 │ ├── right-join (hash) 177 │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 ci.oid:91 ci.relname:92 ftrelid:118 ftserver:119 ftoptions:120 fs.oid:121 srvname:122 pg_inherits.inhparent:130 rownum:136!null 178 │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73), (91)-->(92), (118)-->(119,120), (121)-->(122), (122)-->(121), (136)-->(1,2,5,8,10,13,15,17,20,22,23,26,27,32,33,38,39,41-43,68,69,72,73,79,91,92,118-122) 179 │ │ ├── scan pg_inherits 180 │ │ │ └── columns: pg_inherits.inhparent:130!null 181 │ │ ├── ordinality 182 │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 ci.oid:91 ci.relname:92 ftrelid:118 ftserver:119 ftoptions:120 fs.oid:121 srvname:122 rownum:136!null 183 │ │ │ ├── key: (136) 184 │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73), (91)-->(92), (118)-->(119,120), (121)-->(122), (122)-->(121), (136)-->(1-3,5,8,10,13,15,17,20,22,23,26-29,32,33,38,39,41-43,68,69,72,73,79,91,92,118-122) 185 │ │ │ └── left-join (lookup pg_foreign_server) 186 │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 ci.oid:91 ci.relname:92 ftrelid:118 ftserver:119 ftoptions:120 fs.oid:121 srvname:122 187 │ │ │ ├── key columns: [119] = [121] 188 │ │ │ ├── lookup columns are key 189 │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73), (91)-->(92), (118)-->(119,120), (121)-->(122), (122)-->(121) 190 │ │ │ ├── left-join (lookup pg_foreign_table) 191 │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 ci.oid:91 ci.relname:92 ftrelid:118 ftserver:119 ftoptions:120 192 │ │ │ │ ├── key columns: [1] = [118] 193 │ │ │ │ ├── lookup columns are key 194 │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73), (91)-->(92), (118)-->(119,120) 195 │ │ │ │ ├── left-join (lookup pg_class) 196 │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 ci.oid:91 ci.relname:92 197 │ │ │ │ │ ├── key columns: [72] = [91] 198 │ │ │ │ │ ├── lookup columns are key 199 │ │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73), (91)-->(92) 200 │ │ │ │ │ ├── right-join (hash) 201 │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72 indrelid:73 indisclustered:79 202 │ │ │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68), (72)-->(73) 203 │ │ │ │ │ │ ├── select 204 │ │ │ │ │ │ │ ├── columns: i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72!null indrelid:73!null indisclustered:79!null 205 │ │ │ │ │ │ │ ├── key: (72) 206 │ │ │ │ │ │ │ ├── fd: ()-->(79), (72)-->(73) 207 │ │ │ │ │ │ │ ├── scan ind 208 │ │ │ │ │ │ │ │ ├── columns: i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 indexrelid:72!null indrelid:73!null indisclustered:79!null 209 │ │ │ │ │ │ │ │ ├── key: (72) 210 │ │ │ │ │ │ │ │ └── fd: (72)-->(73,79) 211 │ │ │ │ │ │ │ └── filters 212 │ │ │ │ │ │ │ └── indisclustered:79 = true [outer=(79), constraints=(/79: [/true - /true]; tight), fd=()-->(79)] 213 │ │ │ │ │ │ ├── right-join (hash) 214 │ │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 i.inhrelid:38 i.inhparent:39 c2.oid:41 c2.relname:42 c2.relnamespace:43 n2.oid:68 n2.nspname:69 215 │ │ │ │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32), (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)~~>(69), (69)~~>(68) 216 │ │ │ │ │ │ │ ├── left-join (hash) 217 │ │ │ │ │ │ │ │ ├── columns: i.inhrelid:38!null i.inhparent:39!null c2.oid:41!null c2.relname:42!null c2.relnamespace:43!null n2.oid:68 n2.nspname:69 218 │ │ │ │ │ │ │ │ ├── fd: (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39), (68)-->(69), (69)-->(68) 219 │ │ │ │ │ │ │ │ ├── inner-join (hash) 220 │ │ │ │ │ │ │ │ │ ├── columns: i.inhrelid:38!null i.inhparent:39!null c2.oid:41!null c2.relname:42!null c2.relnamespace:43!null 221 │ │ │ │ │ │ │ │ │ ├── fd: (41)-->(42,43), (42,43)-->(41), (39)==(41), (41)==(39) 222 │ │ │ │ │ │ │ │ │ ├── scan i 223 │ │ │ │ │ │ │ │ │ │ └── columns: i.inhrelid:38!null i.inhparent:39!null 224 │ │ │ │ │ │ │ │ │ ├── scan c2@pg_class_relname_nsp_index 225 │ │ │ │ │ │ │ │ │ │ ├── columns: c2.oid:41!null c2.relname:42!null c2.relnamespace:43!null 226 │ │ │ │ │ │ │ │ │ │ ├── key: (41) 227 │ │ │ │ │ │ │ │ │ │ └── fd: (41)-->(42,43), (42,43)-->(41) 228 │ │ │ │ │ │ │ │ │ └── filters 229 │ │ │ │ │ │ │ │ │ └── i.inhparent:39 = c2.oid:41 [outer=(39,41), constraints=(/39: (/NULL - ]; /41: (/NULL - ]), fd=(39)==(41), (41)==(39)] 230 │ │ │ │ │ │ │ │ ├── scan n2@pg_namespace_nspname_index 231 │ │ │ │ │ │ │ │ │ ├── columns: n2.oid:68!null n2.nspname:69!null 232 │ │ │ │ │ │ │ │ │ ├── key: (68) 233 │ │ │ │ │ │ │ │ │ └── fd: (68)-->(69), (69)-->(68) 234 │ │ │ │ │ │ │ │ └── filters 235 │ │ │ │ │ │ │ │ └── n2.oid:68 = c2.relnamespace:43 [outer=(43,68), constraints=(/43: (/NULL - ]; /68: (/NULL - ]), fd=(43)==(68), (68)==(43)] 236 │ │ │ │ │ │ │ ├── left-join (lookup pg_tablespace) 237 │ │ │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null t.oid:32 spcname:33 238 │ │ │ │ │ │ │ │ ├── key columns: [8] = [32] 239 │ │ │ │ │ │ │ │ ├── lookup columns are key 240 │ │ │ │ │ │ │ │ ├── key: (1) 241 │ │ │ │ │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27,32,33), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3), (32)-->(33), (33)-->(32) 242 │ │ │ │ │ │ │ │ ├── inner-join (hash) 243 │ │ │ │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 n.oid:28!null n.nspname:29!null 244 │ │ │ │ │ │ │ │ │ ├── key: (1) 245 │ │ │ │ │ │ │ │ │ ├── fd: ()-->(3,28,29), (1)-->(2,5,8,10,13,15,17,20,22,23,26,27), (2)-->(1,5,8,10,13,15,17,20,22,23,26,27), (3)==(28), (28)==(3) 246 │ │ │ │ │ │ │ │ │ ├── select 247 │ │ │ │ │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 248 │ │ │ │ │ │ │ │ │ │ ├── key: (1) 249 │ │ │ │ │ │ │ │ │ │ ├── fd: (1)-->(2,3,5,8,10,13,15,17,20,22,23,26,27), (2,3)-->(1,5,8,10,13,15,17,20,22,23,26,27) 250 │ │ │ │ │ │ │ │ │ │ ├── scan c 251 │ │ │ │ │ │ │ │ │ │ │ ├── columns: c.oid:1!null c.relname:2!null c.relnamespace:3!null c.relowner:5!null c.reltablespace:8!null c.reltuples:10!null c.relhasindex:13!null c.relpersistence:15!null c.relkind:17!null c.relhasoids:20!null c.relhasrules:22!null c.relhastriggers:23!null c.relacl:26 c.reloptions:27 252 │ │ │ │ │ │ │ │ │ │ │ ├── key: (1) 253 │ │ │ │ │ │ │ │ │ │ │ └── fd: (1)-->(2,3,5,8,10,13,15,17,20,22,23,26,27), (2,3)-->(1,5,8,10,13,15,17,20,22,23,26,27) 254 │ │ │ │ │ │ │ │ │ │ └── filters 255 │ │ │ │ │ │ │ │ │ │ └── (c.relkind:17 = 'r') OR (c.relkind:17 = 'f') [outer=(17), constraints=(/17: [/'f' - /'f'] [/'r' - /'r']; tight)] 256 │ │ │ │ │ │ │ │ │ ├── scan n@pg_namespace_nspname_index 257 │ │ │ │ │ │ │ │ │ │ ├── columns: n.oid:28!null n.nspname:29!null 258 │ │ │ │ │ │ │ │ │ │ ├── constraint: /29: [/'public' - /'public'] 259 │ │ │ │ │ │ │ │ │ │ ├── cardinality: [0 - 1] 260 │ │ │ │ │ │ │ │ │ │ ├── key: () 261 │ │ │ │ │ │ │ │ │ │ └── fd: ()-->(28,29) 262 │ │ │ │ │ │ │ │ │ └── filters 263 │ │ │ │ │ │ │ │ │ └── n.oid:28 = c.relnamespace:3 [outer=(3,28), constraints=(/3: (/NULL - ]; /28: (/NULL - ]), fd=(3)==(28), (28)==(3)] 264 │ │ │ │ │ │ │ │ └── filters (true) 265 │ │ │ │ │ │ │ └── filters 266 │ │ │ │ │ │ │ └── i.inhrelid:38 = c.oid:1 [outer=(1,38), constraints=(/1: (/NULL - ]; /38: (/NULL - ]), fd=(1)==(38), (38)==(1)] 267 │ │ │ │ │ │ └── filters 268 │ │ │ │ │ │ └── indrelid:73 = c.oid:1 [outer=(1,73), constraints=(/1: (/NULL - ]; /73: (/NULL - ]), fd=(1)==(73), (73)==(1)] 269 │ │ │ │ │ └── filters (true) 270 │ │ │ │ └── filters (true) 271 │ │ │ └── filters (true) 272 │ │ └── filters 273 │ │ └── pg_inherits.inhparent:130 = c.oid:1 [outer=(1,130), constraints=(/1: (/NULL - ]; /130: (/NULL - ]), fd=(1)==(130), (130)==(1)] 274 │ └── aggregations 275 │ ├── count [as=count_rows:132, outer=(130)] 276 │ │ └── pg_inherits.inhparent:130 277 │ ├── const-agg [as=c.oid:1, outer=(1)] 278 │ │ └── c.oid:1 279 │ ├── const-agg [as=c.relname:2, outer=(2)] 280 │ │ └── c.relname:2 281 │ ├── const-agg [as=c.relowner:5, outer=(5)] 282 │ │ └── c.relowner:5 283 │ ├── const-agg [as=c.reltuples:10, outer=(10)] 284 │ │ └── c.reltuples:10 285 │ ├── const-agg [as=c.relhasindex:13, outer=(13)] 286 │ │ └── c.relhasindex:13 287 │ ├── const-agg [as=c.relpersistence:15, outer=(15)] 288 │ │ └── c.relpersistence:15 289 │ ├── const-agg [as=c.relkind:17, outer=(17)] 290 │ │ └── c.relkind:17 291 │ ├── const-agg [as=c.relhasoids:20, outer=(20)] 292 │ │ └── c.relhasoids:20 293 │ ├── const-agg [as=c.relhasrules:22, outer=(22)] 294 │ │ └── c.relhasrules:22 295 │ ├── const-agg [as=c.relhastriggers:23, outer=(23)] 296 │ │ └── c.relhastriggers:23 297 │ ├── const-agg [as=c.relacl:26, outer=(26)] 298 │ │ └── c.relacl:26 299 │ ├── const-agg [as=c.reloptions:27, outer=(27)] 300 │ │ └── c.reloptions:27 301 │ ├── const-agg [as=n.nspname:29, outer=(29)] 302 │ │ └── n.nspname:29 303 │ ├── const-agg [as=spcname:33, outer=(33)] 304 │ │ └── spcname:33 305 │ ├── const-agg [as=c2.relname:42, outer=(42)] 306 │ │ └── c2.relname:42 307 │ ├── const-agg [as=n2.nspname:69, outer=(69)] 308 │ │ └── n2.nspname:69 309 │ ├── const-agg [as=ci.relname:92, outer=(92)] 310 │ │ └── ci.relname:92 311 │ ├── const-agg [as=ftoptions:120, outer=(120)] 312 │ │ └── ftoptions:120 313 │ └── const-agg [as=srvname:122, outer=(122)] 314 │ └── srvname:122 315 └── projections 316 ├── pg_get_userbyid(c.relowner:5) [as=tableowner:133, outer=(5), stable] 317 ├── obj_description(c.oid:1) [as=description:134, outer=(1), stable] 318 └── count_rows:132 > 0 [as=inhtable:135, outer=(132)]