Seq Scan on tbl (cost=81.54..2122.54 rows=100000 width=47) (actual time=0.336..11.523 rows=100000 loops=1) |
InitPlan 1 (returns $8) |
-> Nested Loop Left Join (cost=27.54..40.77 rows=1 width=0) (actual time=0.118..0.122 rows=0 loops=1) |
Join Filter: (dep.refobjsubid = a.attnum) |
-> Merge Right Join (cost=27.10..27.27 rows=1 width=6) (actual time=0.117..0.121 rows=0 loops=1) |
Merge Cond: (co.oid = a.attcollation) |
-> Nested Loop (cost=0.28..114.16 rows=781 width=4) (actual time=0.089..0.091 rows=1 loops=1) |
Join Filter: ((co.collnamespace = nco.oid) AND ((nco.nspname <> 'pg_catalog'::name) OR (co.collname <> 'default'::name))) |
Rows Removed by Join Filter: 16 |
-> Index Scan using pg_collation_oid_index on pg_collation co (cost=0.28..59.99 rows=781 width=72) (actual time=0.065..0.066 rows=2 loops=1) |
-> Materialize (cost=0.00..1.06 rows=4 width=68) (actual time=0.006..0.009 rows=8 loops=2) |
-> Seq Scan on pg_namespace nco (cost=0.00..1.04 rows=4 width=68) (actual time=0.008..0.010 rows=15 loops=1) |
-> Sort (cost=26.83..26.83 rows=1 width=10) (actual time=0.026..0.028 rows=0 loops=1) |
Sort Key: a.attcollation |
Sort Method: quicksort Memory: 25kB |
-> Nested Loop (cost=1.36..26.82 rows=1 width=10) (actual time=0.020..0.023 rows=0 loops=1) |
-> Nested Loop (cost=1.23..26.64 rows=1 width=14) (actual time=0.020..0.022 rows=0 loops=1) |
Join Filter: (c.relnamespace = nc.oid) |
-> Nested Loop Left Join (cost=1.23..25.55 rows=1 width=18) (actual time=0.020..0.022 rows=0 loops=1) |
Join Filter: (t.typtype = 'd'::"char") |
-> Nested Loop (cost=0.82..24.94 rows=1 width=23) (actual time=0.020..0.021 rows=0 loops=1) |
-> Nested Loop (cost=0.55..16.61 rows=1 width=18) (actual time=0.020..0.020 rows=0 loops=1) |
-> Index Scan using pg_class_relname_nsp_index on pg_class c (cost=0.27..8.30 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=1) |
Index Cond: (relname = 'tbl'::name) |
Filter: (relkind = ANY ('{r,v,f,p}'::"char"[])) |
-> Index Scan using pg_attribute_relid_attnam_index on pg_attribute a (cost=0.28..8.31 rows=1 width=14) (actual time=0.006..0.006 rows=0 loops=1) |
Index Cond: ((attrelid = c.oid) AND (attname = 'extra'::name)) |
Filter: ((NOT attisdropped) AND (attnum > 0) AND (pg_has_role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))) |
-> Index Scan using pg_type_oid_index on pg_type t (cost=0.27..8.29 rows=1 width=13) (never executed) |
Index Cond: (oid = a.atttypid) |
-> Nested Loop (cost=0.40..0.60 rows=1 width=4) (never executed) |
-> Index Scan using pg_type_oid_index on pg_type bt (cost=0.27..0.42 rows=1 width=8) (never executed) |
Index Cond: (oid = t.typbasetype) |
-> Index Only Scan using pg_namespace_oid_index on pg_namespace nbt (cost=0.13..0.17 rows=1 width=4) (never executed) |
Index Cond: (oid = bt.typnamespace) |
Heap Fetches: 0 |
-> Seq Scan on pg_namespace nc (cost=0.00..1.05 rows=3 width=4) (never executed) |
Filter: (NOT pg_is_other_temp_schema(oid)) |
-> Index Only Scan using pg_namespace_oid_index on pg_namespace nt (cost=0.13..0.17 rows=1 width=4) (never executed) |
Index Cond: (oid = t.typnamespace) |
Heap Fetches: 0 |
-> Nested Loop (cost=0.44..13.49 rows=1 width=8) (never executed) |
-> Index Scan using pg_depend_reference_index on pg_depend dep (cost=0.29..8.31 rows=1 width=12) (never executed) |
Index Cond: ((refclassid = '1259'::oid) AND (refobjid = c.oid)) |
Filter: ((classid = '1259'::oid) AND (deptype = 'i'::"char")) |
-> Index Only Scan using pg_sequence_seqrelid_index on pg_sequence seq (cost=0.15..5.17 rows=1 width=4) (never executed) |
Index Cond: (seqrelid = dep.objid) |
Heap Fetches: 0 |
InitPlan 2 (returns $17) |
-> Nested Loop Left Join (cost=27.54..40.77 rows=1 width=0) (never executed) |
Join Filter: (dep_1.refobjsubid = a_1.attnum) |
-> Merge Right Join (cost=27.10..27.27 rows=1 width=6) (never executed) |
Merge Cond: (co_1.oid = a_1.attcollation) |
-> Nested Loop (cost=0.28..114.16 rows=781 width=4) (never executed) |
Join Filter: ((co_1.collnamespace = nco_1.oid) AND ((nco_1.nspname <> 'pg_catalog'::name) OR (co_1.collname <> 'default'::name))) |
-> Index Scan using pg_collation_oid_index on pg_collation co_1 (cost=0.28..59.99 rows=781 width=72) (never executed) |
-> Materialize (cost=0.00..1.06 rows=4 width=68) (never executed) |
-> Seq Scan on pg_namespace nco_1 (cost=0.00..1.04 rows=4 width=68) (never executed) |
-> Sort (cost=26.83..26.83 rows=1 width=10) (never executed) |
Sort Key: a_1.attcollation |
-> Nested Loop (cost=1.36..26.82 rows=1 width=10) (never executed) |
-> Nested Loop (cost=1.23..26.64 rows=1 width=14) (never executed) |
Join Filter: (c_1.relnamespace = nc_1.oid) |
-> Nested Loop Left Join (cost=1.23..25.55 rows=1 width=18) (never executed) |
Join Filter: (t_1.typtype = 'd'::"char") |
-> Nested Loop (cost=0.82..24.94 rows=1 width=23) (never executed) |
-> Nested Loop (cost=0.55..16.61 rows=1 width=18) (never executed) |
-> Index Scan using pg_class_relname_nsp_index on pg_class c_1 (cost=0.27..8.30 rows=1 width=12) (never executed) |
Index Cond: (relname = 'tbl'::name) |
Filter: (relkind = ANY ('{r,v,f,p}'::"char"[])) |
-> Index Scan using pg_attribute_relid_attnam_index on pg_attribute a_1 (cost=0.28..8.31 rows=1 width=14) (never executed) |
Index Cond: ((attrelid = c_1.oid) AND (attname = 'extra'::name)) |
Filter: ((NOT attisdropped) AND (attnum > 0) AND (pg_has_role(c_1.relowner, 'USAGE'::text) OR has_column_privilege(c_1.oid, attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))) |
-> Index Scan using pg_type_oid_index on pg_type t_1 (cost=0.27..8.29 rows=1 width=13) (never executed) |
Index Cond: (oid = a_1.atttypid) |
-> Nested Loop (cost=0.40..0.60 rows=1 width=4) (never executed) |
-> Index Scan using pg_type_oid_index on pg_type bt_1 (cost=0.27..0.42 rows=1 width=8) (never executed) |
Index Cond: (oid = t_1.typbasetype) |
-> Index Only Scan using pg_namespace_oid_index on pg_namespace nbt_1 (cost=0.13..0.17 rows=1 width=4) (never executed) |
Index Cond: (oid = bt_1.typnamespace) |
Heap Fetches: 0 |
-> Seq Scan on pg_namespace nc_1 (cost=0.00..1.05 rows=3 width=4) (never executed) |
Filter: (NOT pg_is_other_temp_schema(oid)) |
-> Index Only Scan using pg_namespace_oid_index on pg_namespace nt_1 (cost=0.13..0.17 rows=1 width=4) (never executed) |
Index Cond: (oid = t_1.typnamespace) |
Heap Fetches: 0 |
-> Nested Loop (cost=0.44..13.49 rows=1 width=8) (never executed) |
-> Index Scan using pg_depend_reference_index on pg_depend dep_1 (cost=0.29..8.31 rows=1 width=12) (never executed) |
Index Cond: ((refclassid = '1259'::oid) AND (refobjid = c_1.oid)) |
Filter: ((classid = '1259'::oid) AND (deptype = 'i'::"char")) |
-> Index Only Scan using pg_sequence_seqrelid_index on pg_sequence seq_1 (cost=0.15..5.17 rows=1 width=4) (never executed) |
Index Cond: (seqrelid = dep_1.objid) |
Heap Fetches: 0 |
Planning Time: 10.360 ms |
Execution Time: 15.337 ms |