[ { "Plan": { "Node Type": "Unique", "Parallel Aware": false, "Startup Cost": 119.03, "Total Cost": 119.04, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 367.918, "Actual Total Time": 367.930, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1\".constraint_name", "((\"*SELECT* 1_1\".attname)::information_schema.sql_identifier)"], "Shared Hit Blocks": 34639, "Shared Read Blocks": 50, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 52.372, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 119.03, "Total Cost": 119.04, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 367.669, "Actual Total Time": 367.680, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1\".constraint_name", "((\"*SELECT* 1_1\".attname)::information_schema.sql_identifier)"], "Sort Key": ["\"*SELECT* 1\".constraint_name", "((\"*SELECT* 1_1\".attname)::information_schema.sql_identifier)"], "Sort Method": "quicksort", "Sort Space Used": 25, "Sort Space Type": "Memory", "Shared Hit Blocks": 34639, "Shared Read Blocks": 50, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 52.372, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 9.54, "Total Cost": 119.02, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 14.418, "Actual Total Time": 367.601, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1\".constraint_name", "(\"*SELECT* 1_1\".attname)::information_schema.sql_identifier"], "Inner Unique": false, "Join Filter": "((\"*SELECT* 1\".constraint_name)::name = \"*SELECT* 1_1\".conname)", "Rows Removed by Join Filter": 935, "Shared Hit Blocks": 34636, "Shared Read Blocks": 50, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 52.372, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Alias": "*SELECT* 1", "Startup Cost": 0.42, "Total Cost": 63.99, "Plan Rows": 1, "Plan Width": 64, "Actual Startup Time": 1.337, "Actual Total Time": 50.081, "Actual Rows": 936, "Actual Loops": 1, "Output": ["\"*SELECT* 1\".constraint_name"], "Shared Hit Blocks": 4688, "Shared Read Blocks": 18, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 40.971, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Result", "Parent Relationship": "Subquery", "Parallel Aware": false, "Startup Cost": 0.42, "Total Cost": 63.98, "Plan Rows": 1, "Plan Width": 512, "Actual Startup Time": 1.335, "Actual Total Time": 49.922, "Actual Rows": 936, "Actual Loops": 1, "Output": ["NULL::information_schema.sql_identifier", "NULL::information_schema.sql_identifier", "(c.conname)::information_schema.sql_identifier", "NULL::information_schema.sql_identifier", "NULL::information_schema.sql_identifier", "NULL::information_schema.sql_identifier", "NULL::information_schema.character_data", "NULL::information_schema.yes_or_no", "NULL::information_schema.yes_or_no", "NULL::information_schema.yes_or_no"], "One-Time Filter": "(current_database() = current_database())", "Shared Hit Blocks": 4688, "Shared Read Blocks": 18, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 40.971, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.42, "Total Cost": 63.98, "Plan Rows": 1, "Plan Width": 64, "Actual Startup Time": 1.327, "Actual Total Time": 49.635, "Actual Rows": 936, "Actual Loops": 1, "Output": ["c.conname"], "Inner Unique": true, "Shared Hit Blocks": 4688, "Shared Read Blocks": 18, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 40.971, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.28, "Total Cost": 63.81, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 1.290, "Actual Total Time": 48.143, "Actual Rows": 936, "Actual Loops": 1, "Output": ["c.conname", "r.relnamespace"], "Inner Unique": true, "Join Filter": "(c.connamespace = nc.oid)", "Rows Removed by Join Filter": 2808, "Shared Hit Blocks": 3749, "Shared Read Blocks": 18, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 40.971, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.28, "Total Cost": 62.72, "Plan Rows": 1, "Plan Width": 72, "Actual Startup Time": 1.278, "Actual Total Time": 45.844, "Actual Rows": 936, "Actual Loops": 1, "Output": ["c.conname", "c.connamespace", "r.relnamespace"], "Inner Unique": true, "Shared Hit Blocks": 2813, "Shared Read Blocks": 18, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 40.971, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c", "Startup Cost": 0.00, "Total Cost": 50.05, "Plan Rows": 5, "Plan Width": 72, "Actual Startup Time": 1.238, "Actual Total Time": 1.637, "Actual Rows": 936, "Actual Loops": 1, "Output": ["c.oid", "c.conname", "c.connamespace", "c.contype", "c.condeferrable", "c.condeferred", "c.convalidated", "c.conrelid", "c.contypid", "c.conindid", "c.conparentid", "c.confrelid", "c.confupdtype", "c.confdeltype", "c.confmatchtype", "c.conislocal", "c.coninhcount", "c.connoinherit", "c.conkey", "c.confkey", "c.conpfeqop", "c.conppeqop", "c.conffeqop", "c.conexclop", "c.conbin"], "Filter": "((c.contype <> ALL ('{t,x}'::\"char\"[])) AND ((CASE c.contype WHEN 'c'::\"char\" THEN 'CHECK'::text WHEN 'f'::\"char\" THEN 'FOREIGN KEY'::text WHEN 'p'::\"char\" THEN 'PRIMARY KEY'::text WHEN 'u'::\"char\" THEN 'UNIQUE'::text ELSE NULL::text END)::text = 'PRIMARY KEY'::text))", "Rows Removed by Filter": 146, "Shared Hit Blocks": 22, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 1.207, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_class_oid_index", "Relation Name": "pg_class", "Schema": "pg_catalog", "Alias": "r", "Startup Cost": 0.28, "Total Cost": 2.53, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.046, "Actual Total Time": 0.046, "Actual Rows": 1, "Actual Loops": 936, "Output": ["r.oid", "r.relname", "r.relnamespace", "r.reltype", "r.reloftype", "r.relowner", "r.relam", "r.relfilenode", "r.reltablespace", "r.relpages", "r.reltuples", "r.relallvisible", "r.reltoastrelid", "r.relhasindex", "r.relisshared", "r.relpersistence", "r.relkind", "r.relnatts", "r.relchecks", "r.relhasrules", "r.relhastriggers", "r.relhassubclass", "r.relrowsecurity", "r.relforcerowsecurity", "r.relispopulated", "r.relreplident", "r.relispartition", "r.relrewrite", "r.relfrozenxid", "r.relminmxid", "r.relacl", "r.reloptions", "r.relpartbound"], "Index Cond": "(r.oid = c.conrelid)", "Rows Removed by Index Recheck": 0, "Filter": "((r.relkind = ANY ('{r,p}'::\"char\"[])) AND (pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(r.oid, 'INSERT, UPDATE, REFERENCES'::text)))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 2791, "Shared Read Blocks": 17, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 39.763, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Seq Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nc", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 4, "Plan Width": 4, "Actual Startup Time": 0.000, "Actual Total Time": 0.001, "Actual Rows": 4, "Actual Loops": 936, "Output": ["nc.oid", "nc.nspname", "nc.nspowner", "nc.nspacl"], "Shared Hit Blocks": 936, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Only Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_namespace_oid_index", "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nr", "Startup Cost": 0.13, "Total Cost": 0.15, "Plan Rows": 1, "Plan Width": 4, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 1, "Actual Loops": 936, "Output": ["nr.oid"], "Index Cond": "(nr.oid = r.relnamespace)", "Rows Removed by Index Recheck": 0, "Filter": "(NOT pg_is_other_temp_schema(nr.oid))", "Rows Removed by Filter": 0, "Heap Fetches": 0, "Shared Hit Blocks": 939, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] }, { "Node Type": "Append", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 9.12, "Total Cost": 55.01, "Plan Rows": 2, "Plan Width": 128, "Actual Startup Time": 0.019, "Actual Total Time": 0.338, "Actual Rows": 1, "Actual Loops": 936, "Shared Hit Blocks": 29948, "Shared Read Blocks": 32, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 11.402, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Alias": "*SELECT* 1_1", "Startup Cost": 9.12, "Total Cost": 9.15, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 936, "Output": ["\"*SELECT* 1_1\".attname", "\"*SELECT* 1_1\".conname"], "Shared Hit Blocks": 13, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Unique", "Parent Relationship": "Subquery", "Parallel Aware": false, "Startup Cost": 9.12, "Total Cost": 9.14, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 936, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Shared Hit Blocks": 13, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 9.12, "Total Cost": 9.13, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 936, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Sort Key": ["nr_1.nspname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Sort Method": "quicksort", "Sort Space Used": 25, "Sort Space Type": "Memory", "Shared Hit Blocks": 13, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 1.27, "Total Cost": 9.11, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 6.707, "Actual Total Time": 6.712, "Actual Rows": 0, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Inner Unique": true, "Shared Hit Blocks": 10, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 1.14, "Total Cost": 8.38, "Plan Rows": 1, "Plan Width": 264, "Actual Startup Time": 6.706, "Actual Total Time": 6.710, "Actual Rows": 0, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "c_1.conname", "c_1.connamespace"], "Inner Unique": true, "Shared Hit Blocks": 10, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.86, "Total Cost": 8.05, "Plan Rows": 1, "Plan Width": 200, "Actual Startup Time": 4.723, "Actual Total Time": 6.666, "Actual Rows": 1, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "d.objid"], "Inner Unique": true, "Join Filter": "(r_1.oid = a.attrelid)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 7, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 6.426, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.57, "Total Cost": 7.15, "Plan Rows": 1, "Plan Width": 148, "Actual Startup Time": 2.837, "Actual Total Time": 4.778, "Actual Rows": 1, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "r_1.oid", "d.refobjid", "d.refobjsubid", "d.objid"], "Inner Unique": false, "Shared Hit Blocks": 3, "Shared Read Blocks": 6, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.637, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.28, "Total Cost": 3.60, "Plan Rows": 1, "Plan Width": 136, "Actual Startup Time": 0.044, "Actual Total Time": 0.047, "Actual Rows": 1, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "r_1.oid"], "Inner Unique": true, "Join Filter": "(nr_1.oid = r_1.relnamespace)", "Rows Removed by Join Filter": 3, "Shared Hit Blocks": 3, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.011, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_class_relname_nsp_index", "Relation Name": "pg_class", "Schema": "pg_catalog", "Alias": "r_1", "Startup Cost": 0.28, "Total Cost": 2.51, "Plan Rows": 1, "Plan Width": 76, "Actual Startup Time": 0.038, "Actual Total Time": 0.041, "Actual Rows": 1, "Actual Loops": 1, "Output": ["r_1.oid", "r_1.relname", "r_1.relnamespace", "r_1.reltype", "r_1.reloftype", "r_1.relowner", "r_1.relam", "r_1.relfilenode", "r_1.reltablespace", "r_1.relpages", "r_1.reltuples", "r_1.relallvisible", "r_1.reltoastrelid", "r_1.relhasindex", "r_1.relisshared", "r_1.relpersistence", "r_1.relkind", "r_1.relnatts", "r_1.relchecks", "r_1.relhasrules", "r_1.relhastriggers", "r_1.relhassubclass", "r_1.relrowsecurity", "r_1.relforcerowsecurity", "r_1.relispopulated", "r_1.relreplident", "r_1.relispartition", "r_1.relrewrite", "r_1.relfrozenxid", "r_1.relminmxid", "r_1.relacl", "r_1.reloptions", "r_1.relpartbound"], "Index Cond": "(r_1.relname = 't_c56ng1_repository'::name)", "Rows Removed by Index Recheck": 0, "Filter": "((r_1.relkind = ANY ('{r,p}'::\"char\"[])) AND pg_has_role(r_1.relowner, 'USAGE'::text))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.011, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nr_1", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 4, "Plan Width": 68, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 4, "Actual Loops": 1, "Output": ["nr_1.oid", "nr_1.nspname", "nr_1.nspowner", "nr_1.nspacl"], "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_depend_reference_index", "Relation Name": "pg_depend", "Schema": "pg_catalog", "Alias": "d", "Startup Cost": 0.29, "Total Cost": 3.54, "Plan Rows": 1, "Plan Width": 12, "Actual Startup Time": 2.789, "Actual Total Time": 4.723, "Actual Rows": 1, "Actual Loops": 1, "Output": ["d.classid", "d.objid", "d.objsubid", "d.refclassid", "d.refobjid", "d.refobjsubid", "d.deptype"], "Index Cond": "((d.refclassid = '1259'::oid) AND (d.refobjid = r_1.oid))", "Rows Removed by Index Recheck": 0, "Filter": "(d.classid = '2606'::oid)", "Rows Removed by Filter": 4, "Shared Hit Blocks": 0, "Shared Read Blocks": 5, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.626, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_attribute_relid_attnum_index", "Relation Name": "pg_attribute", "Schema": "pg_catalog", "Alias": "a", "Startup Cost": 0.29, "Total Cost": 0.89, "Plan Rows": 1, "Plan Width": 70, "Actual Startup Time": 1.877, "Actual Total Time": 1.877, "Actual Rows": 1, "Actual Loops": 1, "Output": ["a.attrelid", "a.attname", "a.atttypid", "a.attstattarget", "a.attlen", "a.attnum", "a.attndims", "a.attcacheoff", "a.atttypmod", "a.attbyval", "a.attstorage", "a.attalign", "a.attnotnull", "a.atthasdef", "a.atthasmissing", "a.attidentity", "a.attgenerated", "a.attisdropped", "a.attislocal", "a.attinhcount", "a.attcollation", "a.attacl", "a.attoptions", "a.attfdwoptions", "a.attmissingval"], "Index Cond": "((a.attrelid = d.refobjid) AND (a.attnum = d.refobjsubid))", "Rows Removed by Index Recheck": 0, "Filter": "(NOT a.attisdropped)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 1.789, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_constraint_oid_index", "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c_1", "Startup Cost": 0.28, "Total Cost": 0.32, "Plan Rows": 1, "Plan Width": 72, "Actual Startup Time": 0.037, "Actual Total Time": 0.037, "Actual Rows": 0, "Actual Loops": 1, "Output": ["c_1.oid", "c_1.conname", "c_1.connamespace", "c_1.contype", "c_1.condeferrable", "c_1.condeferred", "c_1.convalidated", "c_1.conrelid", "c_1.contypid", "c_1.conindid", "c_1.conparentid", "c_1.confrelid", "c_1.confupdtype", "c_1.confdeltype", "c_1.confmatchtype", "c_1.conislocal", "c_1.coninhcount", "c_1.connoinherit", "c_1.conkey", "c_1.confkey", "c_1.conpfeqop", "c_1.conppeqop", "c_1.conffeqop", "c_1.conexclop", "c_1.conbin"], "Index Cond": "(c_1.oid = d.objid)", "Rows Removed by Index Recheck": 0, "Filter": "(c_1.contype = 'c'::\"char\")", "Rows Removed by Filter": 1, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_namespace_oid_index", "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nc_1", "Startup Cost": 0.13, "Total Cost": 0.56, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["nc_1.oid", "nc_1.nspname", "nc_1.nspowner", "nc_1.nspacl"], "Index Cond": "(nc_1.oid = c_1.connamespace)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] } ] }, { "Node Type": "Subquery Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Alias": "*SELECT* 2", "Startup Cost": 2.94, "Total Cost": 45.85, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 0.011, "Actual Total Time": 0.330, "Actual Rows": 1, "Actual Loops": 936, "Output": ["\"*SELECT* 2\".attname", "\"*SELECT* 2\".conname"], "Shared Hit Blocks": 29935, "Shared Read Blocks": 24, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.976, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Subquery", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 2.94, "Total Cost": 45.84, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.011, "Actual Total Time": 0.329, "Actual Rows": 1, "Actual Loops": 936, "Output": ["NULL::name", "NULL::name", "NULL::oid", "a_1.attname", "NULL::name", "c_2.conname"], "Inner Unique": true, "Shared Hit Blocks": 29935, "Shared Read Blocks": 24, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.976, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 2.81, "Total Cost": 45.68, "Plan Rows": 1, "Plan Width": 132, "Actual Startup Time": 0.010, "Actual Total Time": 0.328, "Actual Rows": 1, "Actual Loops": 936, "Output": ["a_1.attname", "c_2.conname", "c_2.connamespace"], "Inner Unique": false, "Join Filter": "(r_2.oid = a_1.attrelid)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 28998, "Shared Read Blocks": 24, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.976, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 2.52, "Total Cost": 44.44, "Plan Rows": 1, "Plan Width": 136, "Actual Startup Time": 0.004, "Actual Total Time": 0.317, "Actual Rows": 1, "Actual Loops": 936, "Output": ["r_2.oid", "c_2.conname", "c_2.connamespace", "c_2.contype", "c_2.confrelid", "c_2.conrelid", "c_2.confkey", "c_2.conkey"], "Inner Unique": true, "Join Filter": "(r_2.relnamespace = nr_2.oid)", "Rows Removed by Join Filter": 3, "Shared Hit Blocks": 22448, "Shared Read Blocks": 22, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.191, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 2.52, "Total Cost": 43.35, "Plan Rows": 1, "Plan Width": 140, "Actual Startup Time": 0.002, "Actual Total Time": 0.315, "Actual Rows": 1, "Actual Loops": 936, "Output": ["r_2.relnamespace", "r_2.oid", "c_2.conname", "c_2.connamespace", "c_2.contype", "c_2.confrelid", "c_2.conrelid", "c_2.confkey", "c_2.conkey"], "Inner Unique": true, "Hash Cond": "(CASE c_2.contype WHEN 'f'::\"char\" THEN c_2.confrelid ELSE c_2.conrelid END = r_2.oid)", "Shared Hit Blocks": 21512, "Shared Read Blocks": 22, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.191, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c_2", "Startup Cost": 0.00, "Total Cost": 37.88, "Plan Rows": 1074, "Plan Width": 132, "Actual Startup Time": 0.001, "Actual Total Time": 0.154, "Actual Rows": 1074, "Actual Loops": 936, "Output": ["c_2.oid", "c_2.conname", "c_2.connamespace", "c_2.contype", "c_2.condeferrable", "c_2.condeferred", "c_2.convalidated", "c_2.conrelid", "c_2.contypid", "c_2.conindid", "c_2.conparentid", "c_2.confrelid", "c_2.confupdtype", "c_2.confdeltype", "c_2.confmatchtype", "c_2.conislocal", "c_2.coninhcount", "c_2.connoinherit", "c_2.conkey", "c_2.confkey", "c_2.conpfeqop", "c_2.conppeqop", "c_2.conffeqop", "c_2.conexclop", "c_2.conbin"], "Filter": "(c_2.contype = ANY ('{p,u,f}'::\"char\"[]))", "Rows Removed by Filter": 8, "Shared Hit Blocks": 21506, "Shared Read Blocks": 22, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 4.191, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 2.51, "Total Cost": 2.51, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.042, "Actual Total Time": 0.043, "Actual Rows": 1, "Actual Loops": 1, "Output": ["r_2.relnamespace", "r_2.oid"], "Hash Buckets": 1024, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 9, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_class_relname_nsp_index", "Relation Name": "pg_class", "Schema": "pg_catalog", "Alias": "r_2", "Startup Cost": 0.28, "Total Cost": 2.51, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.028, "Actual Total Time": 0.029, "Actual Rows": 1, "Actual Loops": 1, "Output": ["r_2.relnamespace", "r_2.oid"], "Index Cond": "(r_2.relname = 't_c56ng1_repository'::name)", "Rows Removed by Index Recheck": 0, "Filter": "((r_2.relkind = ANY ('{r,p}'::\"char\"[])) AND pg_has_role(r_2.relowner, 'USAGE'::text))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] }, { "Node Type": "Seq Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nr_2", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 4, "Plan Width": 4, "Actual Startup Time": 0.000, "Actual Total Time": 0.001, "Actual Rows": 4, "Actual Loops": 936, "Output": ["nr_2.oid", "nr_2.nspname", "nr_2.nspowner", "nr_2.nspacl"], "Shared Hit Blocks": 936, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_attribute_relid_attnum_index", "Relation Name": "pg_attribute", "Schema": "pg_catalog", "Alias": "a_1", "Startup Cost": 0.29, "Total Cost": 1.23, "Plan Rows": 1, "Plan Width": 70, "Actual Startup Time": 0.005, "Actual Total Time": 0.011, "Actual Rows": 1, "Actual Loops": 936, "Output": ["a_1.attrelid", "a_1.attname", "a_1.atttypid", "a_1.attstattarget", "a_1.attlen", "a_1.attnum", "a_1.attndims", "a_1.attcacheoff", "a_1.atttypmod", "a_1.attbyval", "a_1.attstorage", "a_1.attalign", "a_1.attnotnull", "a_1.atthasdef", "a_1.atthasmissing", "a_1.attidentity", "a_1.attgenerated", "a_1.attisdropped", "a_1.attislocal", "a_1.attinhcount", "a_1.attcollation", "a_1.attacl", "a_1.attoptions", "a_1.attfdwoptions", "a_1.attmissingval"], "Index Cond": "(a_1.attrelid = CASE c_2.contype WHEN 'f'::\"char\" THEN c_2.confrelid ELSE c_2.conrelid END)", "Rows Removed by Index Recheck": 0, "Filter": "((NOT a_1.attisdropped) AND (a_1.attnum = ANY (CASE c_2.contype WHEN 'f'::\"char\" THEN c_2.confkey ELSE c_2.conkey END)))", "Rows Removed by Filter": 18, "Shared Hit Blocks": 6550, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.784, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Index Only Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "pg_namespace_oid_index", "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nc_2", "Startup Cost": 0.13, "Total Cost": 0.15, "Plan Rows": 1, "Plan Width": 4, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 1, "Actual Loops": 936, "Output": ["nc_2.oid"], "Index Cond": "(nc_2.oid = c_2.connamespace)", "Rows Removed by Index Recheck": 0, "Heap Fetches": 0, "Shared Hit Blocks": 937, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] } ] } ] } ] }, "Settings": { "effective_cache_size": "36GB", "effective_io_concurrency": "400", "jit": "off", "max_parallel_workers": "4", "random_page_cost": "1.1", "work_mem": "16MB" }, "Planning": { "Shared Hit Blocks": 651, "Shared Read Blocks": 59, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 70.080, "I/O Write Time": 0.000 }, "Planning Time": 80.888, "Triggers": [ ], "Execution Time": 369.328 } ]