2,04	0	0,69	6	125,68
execution time (ms)	planning time (ms)	slowest node (ms)	largest node (rows)	costliest node

Join Type

Left

Temp Written Blocks

0

Local Read Blocks

0

Plan Rows

1

Inner Unique

false

Total Cost

166.49

Local Written Blocks

0

Join Filter

(dep.refobjsubid = a.attnum)

Output

["(current_database())::information_schema.sql_identifier","(nc.nspname)::information_schema.sql_identifier","(c.relname)::information_schema.sql_identifier","(a.attname)::information_schema.sql_identifier","(a.attnum)::information_schema.cardinal_number","(CASE WHEN (a.attgenerated = ''::\"char\") THEN pg_get_expr(ad.adbin, ad.adrelid) ELSE NULL::text END)::information_schema.character_data","(CASE WHEN (a.attnotnull OR ((t.typtype = 'd'::\"char\") AND t.typnotnull)) THEN 'NO'::text ELSE 'YES'::text END)::information_schema.yes_or_no","(CASE WHEN (t.typtype = 'd'::\"char\") THEN CASE WHEN ((bt.typelem <> '0'::oid) AND (bt.typlen = '-1'::integer)) THEN 'ARRAY'::text WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(t.typbasetype, NULL::integer) ELSE 'USER-DEFINED'::text END ELSE CASE WHEN ((t.typelem <> '0'::oid) AND (t.typlen = '-1'::integer)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(a.atttypid, NULL::integer) ELSE 'USER-DEFINED'::text END END)::information_schema.character_data","(information_schema._pg_char_max_length(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_char_octet_length(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_numeric_precision(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_numeric_precision_radix(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_numeric_scale(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_datetime_precision(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.cardinal_number","(information_schema._pg_interval_type(information_schema._pg_truetypid(a.*, t.*), information_schema._pg_truetypmod(a.*, t.*)))::information_schema.character_data","(NULL::integer)::information_schema.cardinal_number","NULL::information_schema.sql_identifier","NULL::information_schema.sql_identifier","NULL::information_schema.sql_identifier","(CASE WHEN (nco.nspname IS NOT NULL) THEN current_database() ELSE NULL::name END)::information_schema.sql_identifier","(nco.nspname)::information_schema.sql_identifier","(co.collname)::information_schema.sql_identifier","(CASE WHEN (t.typtype = 'd'::\"char\") THEN current_database() ELSE NULL::name END)::information_schema.sql_identifier","(CASE WHEN (t.typtype = 'd'::\"char\") THEN nt.nspname ELSE NULL::name END)::information_schema.sql_identifier","(CASE WHEN (t.typtype = 'd'::\"char\") THEN t.typname ELSE NULL::name END)::information_schema.sql_identifier","(current_database())::information_schema.sql_identifier","(COALESCE(nbt.nspname, nt.nspname))::information_schema.sql_identifier","(COALESCE(bt.typname, t.typname))::information_schema.sql_identifier","NULL::information_schema.sql_identifier","NULL::information_schema.sql_identifier","NULL::information_schema.sql_identifier","(NULL::integer)::information_schema.cardinal_number","(a.attnum)::information_schema.sql_identifier","('NO'::character varying(3))::information_schema.yes_or_no","(CASE WHEN (a.attidentity = ANY ('{a,d}'::\"char\"[])) THEN 'YES'::text ELSE 'NO'::text END)::information_schema.yes_or_no","(CASE a.attidentity WHEN 'a'::\"char\" THEN 'ALWAYS'::text WHEN 'd'::\"char\" THEN 'BY DEFAULT'::text ELSE NULL::text END)::information_schema.character_data","(seq.seqstart)::information_schema.character_data","(seq.seqincrement)::information_schema.character_data","(seq.seqmax)::information_schema.character_data","(seq.seqmin)::information_schema.character_data","(CASE WHEN seq.seqcycle THEN 'YES'::text ELSE 'NO'::text END)::information_schema.yes_or_no","(CASE WHEN (a.attgenerated <> ''::\"char\") THEN 'ALWAYS'::text ELSE 'NEVER'::text END)::information_schema.character_data","(CASE WHEN (a.attgenerated <> ''::\"char\") THEN pg_get_expr(ad.adbin, ad.adrelid) ELSE NULL::text END)::information_schema.character_data","(CASE WHEN ((c.relkind = ANY ('{r,p}'::\"char\"[])) OR ((c.relkind = ANY ('{v,f}'::\"char\"[])) AND pg_column_is_updatable((c.oid)::regclass, a.attnum, false))) THEN 'YES'::text ELSE 'NO'::text END)::information_schema.yes_or_no"]

Shared Hit Blocks

89

Startup Cost

154.1

Actual Total Time

2.043

Local Hit Blocks

0

Plan Width

1796

Local Dirtied Blocks

0

Temp Read Blocks

0

Shared Read Blocks

34

Shared Dirtied Blocks

2

Parallel Aware

false

Actual Startup Time

2.037

Actual Loops

1

Node Type

Nested Loop

Rows Removed by Join Filter

0

Actual Rows

1

Shared Written Blocks

0

NESTED LOOP

MERGE JOIN

NESTED LOOP

INDEX SCAN

MATERIALIZE

SEQ SCAN

SORT

NESTED LOOP

NESTED LOOP

NESTED LOOP

NESTED LOOP

NESTED LOOP

NESTED LOOP

SEQ SCAN

INDEX SCAN

NESTED LOOP

INDEX SCAN

INDEX SCAN

INDEX SCAN

INDEX SCAN

SEQ SCAN

SEQ SCAN

NESTED LOOP

INDEX SCAN

INDEX SCAN

Join Type	Right
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Inner Unique	false
Total Cost	153.86
Local Written Blocks	0
Output	["t.typtype","t.typnotnull","t.typbasetype","t.typelem","t.typlen","t.","t.typname","bt.typelem","bt.typlen","bt.typname","nbt.nspname","a.attname","a.attnum","a.attgenerated","a.attnotnull","a.atttypid","a.","a.attidentity","ad.adbin","ad.adrelid","c.relname","c.relkind","c.oid","nc.nspname","nt.nspname","co.collname","nco.nspname"]
Shared Hit Blocks	65
Startup Cost	153.66
Actual Total Time	0.766
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	1187
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	29
Shared Dirtied Blocks	2
Merge Cond	(co.oid = a.attcollation)
Parallel Aware	false
Actual Startup Time	0.76
Actual Loops	1
Node Type	Merge Join
Actual Rows	1
Shared Written Blocks	0

Join Type	Inner
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	740
Inner Unique	true
Total Cost	133.71
Local Written Blocks	0
Join Filter	((co.collnamespace = nco.oid) AND ((nco.nspname <> 'pg_catalog'::name) OR (co.collname <> 'default'::name)))
Output	["co.collname","co.oid","nco.nspname"]
Shared Hit Blocks	4
Startup Cost	0.28
Actual Total Time	0.019
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	132
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.018
Actual Loops	1
Node Type	Nested Loop
Rows Removed by Join Filter	9
Actual Rows	1
Shared Written Blocks	0

Relation Name	pg_collation
Schema	pg_catalog
Index Name	pg_collation_oid_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	740
Total Cost	54.38
Local Written Blocks	0
Output	["co.oid","co.collname","co.collnamespace","co.collowner","co.collprovider","co.collisdeterministic","co.collencoding","co.collcollate","co.collctype","co.collversion"]
Shared Hit Blocks	3
Startup Cost	0.28
Actual Total Time	0.005
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	72
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.005
Alias	co
Actual Loops	1
Node Type	Index Scan
Actual Rows	2
Shared Written Blocks	0

Relation Name	pg_namespace
Schema	pg_catalog
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	6
Total Cost	1.06
Local Written Blocks	0
Output	["nco.nspname","nco.oid"]
Shared Hit Blocks	1
Startup Cost	0.0
Actual Total Time	0.007
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	68
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.006
Alias	nco
Actual Loops	1
Node Type	Seq Scan
Actual Rows	6
Shared Written Blocks	0

Relation Name	pg_attribute
Schema	pg_catalog
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	125.68
Local Written Blocks	0
Output	["a.attname","a.attnum","a.attgenerated","a.attnotnull","a.atttypid","a.*","a.attidentity","a.attrelid","a.attcollation"]
Shared Hit Blocks	44
Startup Cost	0.0
Actual Total Time	0.692
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	344
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	29
Shared Dirtied Blocks	2
Rows Removed by Filter	3511
Parallel Aware	false
Actual Startup Time	0.646
Filter	((NOT a.attisdropped) AND (a.attnum > 0) AND (a.attname = 'jsonb'::name))
Alias	a
Actual Loops	1
Node Type	Seq Scan
Actual Rows	1
Shared Written Blocks	0

Relation Name	pg_type
Schema	pg_catalog
Index Name	pg_type_oid_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	8.29
Local Written Blocks	0
Output	["t.typtype","t.typnotnull","t.typbasetype","t.typelem","t.typlen","t.*","t.typname","t.typnamespace","t.oid"]
Shared Hit Blocks	3
Startup Cost	0.27
Actual Total Time	0.007
Local Hit Blocks	0
Parent Relationship	Inner
Plan Width	364
Rows Removed by Index Recheck	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.007
Alias	t
Actual Loops	1
Node Type	Index Scan
Index Cond	(t.oid = a.atttypid)
Actual Rows	1
Shared Written Blocks	0

Relation Name	pg_attrdef
Schema	pg_catalog
Index Name	pg_attrdef_adrelid_adnum_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	8.17
Local Written Blocks	0
Output	["ad.oid","ad.adrelid","ad.adnum","ad.adbin"]
Shared Hit Blocks	1
Startup Cost	0.15
Actual Total Time	0.001
Local Hit Blocks	0
Parent Relationship	Inner
Plan Width	38
Rows Removed by Index Recheck	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.001
Alias	ad
Actual Loops	1
Node Type	Index Scan
Index Cond	((ad.adrelid = a.attrelid) AND (ad.adnum = a.attnum))
Actual Rows	0
Shared Written Blocks	0

Relation Name	pg_class
Schema	pg_catalog
Index Name	pg_class_oid_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	8.3
Local Written Blocks	0
Output	["c.oid","c.relname","c.relnamespace","c.reltype","c.reloftype","c.relowner","c.relam","c.relfilenode","c.reltablespace","c.relpages","c.reltuples","c.relallvisible","c.reltoastrelid","c.relhasindex","c.relisshared","c.relpersistence","c.relkind","c.relnatts","c.relchecks","c.relhasrules","c.relhastriggers","c.relhassubclass","c.relrowsecurity","c.relforcerowsecurity","c.relispopulated","c.relreplident","c.relispartition","c.relrewrite","c.relfrozenxid","c.relminmxid","c.relacl","c.reloptions","c.relpartbound"]
Shared Hit Blocks	3
Startup Cost	0.27
Actual Total Time	0.006
Local Hit Blocks	0
Parent Relationship	Inner
Plan Width	77
Rows Removed by Index Recheck	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Rows Removed by Filter	0
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.006
Filter	((c.relkind = ANY ('{r,v,f,p}'::"char"[])) AND (pg_has_role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
Alias	c
Actual Loops	1
Node Type	Index Scan
Index Cond	(c.oid = a.attrelid)
Actual Rows	1
Shared Written Blocks	0

Relation Name	pg_depend
Schema	pg_catalog
Index Name	pg_depend_reference_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	2.45
Local Written Blocks	0
Output	["dep.classid","dep.objid","dep.objsubid","dep.refclassid","dep.refobjid","dep.refobjsubid","dep.deptype"]
Shared Hit Blocks	0
Startup Cost	0.29
Actual Total Time	0.687
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	12
Rows Removed by Index Recheck	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	4
Shared Dirtied Blocks	0
Rows Removed by Filter	4
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.686
Filter	((dep.classid = '1259'::oid) AND (dep.deptype = 'i'::"char"))
Alias	dep
Actual Loops	1
Node Type	Index Scan
Index Cond	((dep.refclassid = '1259'::oid) AND (dep.refobjid = c.oid))
Actual Rows	1
Shared Written Blocks	0

Relation Name	pg_sequence
Schema	pg_catalog
Index Name	pg_sequence_seqrelid_index
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	1
Total Cost	4.74
Local Written Blocks	0
Output	["seq.seqrelid","seq.seqtypid","seq.seqstart","seq.seqincrement","seq.seqmax","seq.seqmin","seq.seqcache","seq.seqcycle"]
Shared Hit Blocks	0
Startup Cost	0.15
Actual Total Time	0.011
Local Hit Blocks	0
Parent Relationship	Inner
Plan Width	37
Rows Removed by Index Recheck	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	1
Shared Dirtied Blocks	0
Scan Direction	Forward
Parallel Aware	false
Actual Startup Time	0.011
Alias	seq
Actual Loops	1
Node Type	Index Scan
Index Cond	(seq.seqrelid = dep.objid)
Actual Rows	0
Shared Written Blocks	0

NESTED LOOP	0,58ms \| 28,19%
	Rows: 1

MERGE JOIN	0ms \| 0,15%
	Rows: 1

NESTED LOOP	0,01ms \| 0,44%
	Rows: 1

INDEX SCAN	0,01ms \| 0,24%
	Rows: 2