[ { "Plan": { "Node Type": "Unique", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 538.23, "Total Cost": 538.24, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 14303.709, "Actual Total Time": 14303.725, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1_1\".constraint_name", "((\"*SELECT* 1\".attname)::information_schema.sql_identifier)"], "Shared Hit Blocks": 5153046, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Startup Cost": 538.23, "Total Cost": 538.23, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 14303.707, "Actual Total Time": 14303.723, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1_1\".constraint_name", "((\"*SELECT* 1\".attname)::information_schema.sql_identifier)"], "Sort Key": ["\"*SELECT* 1_1\".constraint_name", "((\"*SELECT* 1\".attname)::information_schema.sql_identifier)"], "Sort Method": "quicksort", "Sort Space Used": 25, "Sort Space Type": "Memory", "Shared Hit Blocks": 5153046, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 62.84, "Total Cost": 538.22, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 1971.500, "Actual Total Time": 14303.694, "Actual Rows": 1, "Actual Loops": 1, "Output": ["\"*SELECT* 1_1\".constraint_name", "((\"*SELECT* 1\".attname)::information_schema.sql_identifier)"], "Inner Unique": false, "Join Filter": "(\"*SELECT* 1\".conname = (\"*SELECT* 1_1\".constraint_name)::name)", "Rows Removed by Join Filter": 997, "Shared Hit Blocks": 5153046, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Alias": "*SELECT* 1_1", "Startup Cost": 0.42, "Total Cost": 71.27, "Plan Rows": 1, "Plan Width": 64, "Actual Startup Time": 0.080, "Actual Total Time": 46.686, "Actual Rows": 998, "Actual Loops": 1, "Output": ["\"*SELECT* 1_1\".constraint_name"], "Shared Hit Blocks": 6013, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Startup Cost": 0.42, "Total Cost": 71.26, "Plan Rows": 1, "Plan Width": 544, "Actual Startup Time": 0.078, "Actual Total Time": 45.877, "Actual Rows": 998, "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", "NULL::information_schema.yes_or_no"], "One-Time Filter": "(current_database() = current_database())", "Shared Hit Blocks": 6013, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.42, "Total Cost": 71.26, "Plan Rows": 1, "Plan Width": 64, "Actual Startup Time": 0.070, "Actual Total Time": 44.470, "Actual Rows": 998, "Actual Loops": 1, "Output": ["c.conname"], "Inner Unique": true, "Shared Hit Blocks": 6013, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.28, "Total Cost": 71.09, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.058, "Actual Total Time": 34.322, "Actual Rows": 998, "Actual Loops": 1, "Output": ["c.conname", "r.relnamespace"], "Inner Unique": true, "Join Filter": "(nc.oid = c.connamespace)", "Rows Removed by Join Filter": 2870, "Shared Hit Blocks": 4017, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.28, "Total Cost": 70.00, "Plan Rows": 1, "Plan Width": 72, "Actual Startup Time": 0.048, "Actual Total Time": 19.368, "Actual Rows": 998, "Actual Loops": 1, "Output": ["c.conname", "c.connamespace", "r.relnamespace"], "Inner Unique": true, "Shared Hit Blocks": 3019, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c", "Startup Cost": 0.00, "Total Cost": 54.80, "Plan Rows": 6, "Plan Width": 72, "Actual Startup Time": 0.023, "Actual Total Time": 3.497, "Actual Rows": 998, "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.confdelsetcols", "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": 194, "Shared Hit Blocks": 25, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": 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.012, "Actual Total Time": 0.012, "Actual Rows": 1, "Actual Loops": 998, "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": 2994, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": 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.002, "Actual Total Time": 0.002, "Actual Rows": 4, "Actual Loops": 998, "Output": ["nc.oid", "nc.nspname", "nc.nspowner", "nc.nspacl"], "Shared Hit Blocks": 998, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": 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.007, "Actual Total Time": 0.007, "Actual Rows": 1, "Actual Loops": 998, "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": 998, "Shared Hit Blocks": 1996, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] }, { "Node Type": "Append", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 62.42, "Total Cost": 466.92, "Plan Rows": 2, "Plan Width": 128, "Actual Startup Time": 2.112, "Actual Total Time": 14.279, "Actual Rows": 1, "Actual Loops": 998, "Shared Hit Blocks": 5147033, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Alias": "*SELECT* 1", "Startup Cost": 62.42, "Total Cost": 62.45, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 0.010, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 998, "Output": ["\"*SELECT* 1\".conname", "(\"*SELECT* 1\".attname)::information_schema.sql_identifier"], "Filter": "(((\"*SELECT* 1\".relname)::information_schema.sql_identifier)::name = 't_c56ng1_repository'::name)", "Rows Removed by Filter": 6, "Shared Hit Blocks": 157, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Startup Cost": 62.42, "Total Cost": 62.44, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.003, "Actual Total Time": 0.009, "Actual Rows": 6, "Actual Loops": 998, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Shared Hit Blocks": 157, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Startup Cost": 62.42, "Total Cost": 62.42, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.002, "Actual Total Time": 0.003, "Actual Rows": 12, "Actual Loops": 998, "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.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Sort Method": "quicksort", "Sort Space Used": 29, "Sort Space Type": "Memory", "Shared Hit Blocks": 157, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.99, "Total Cost": 62.41, "Plan Rows": 1, "Plan Width": 324, "Actual Startup Time": 0.121, "Actual Total Time": 0.595, "Actual Rows": 12, "Actual Loops": 1, "Output": ["nr_1.nspname", "r_1.relname", "r_1.relowner", "a.attname", "nc_1.nspname", "c_1.conname"], "Inner Unique": true, "Join Filter": "(nc_1.oid = c_1.connamespace)", "Rows Removed by Join Filter": 36, "Shared Hit Blocks": 157, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.99, "Total Cost": 61.32, "Plan Rows": 1, "Plan Width": 264, "Actual Startup Time": 0.114, "Actual Total Time": 0.547, "Actual Rows": 12, "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": 145, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.86, "Total Cost": 61.15, "Plan Rows": 1, "Plan Width": 204, "Actual Startup Time": 0.107, "Actual Total Time": 0.513, "Actual Rows": 12, "Actual Loops": 1, "Output": ["r_1.relname", "r_1.relowner", "r_1.relnamespace", "a.attname", "c_1.conname", "c_1.connamespace"], "Inner Unique": true, "Shared Hit Blocks": 121, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.58, "Total Cost": 60.84, "Plan Rows": 1, "Plan Width": 140, "Actual Startup Time": 0.092, "Actual Total Time": 0.449, "Actual Rows": 12, "Actual Loops": 1, "Output": ["a.attname", "a.attrelid", "d.refobjid", "c_1.conname", "c_1.connamespace"], "Inner Unique": true, "Shared Hit Blocks": 85, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.29, "Total Cost": 60.06, "Plan Rows": 1, "Plan Width": 76, "Actual Startup Time": 0.076, "Actual Total Time": 0.366, "Actual Rows": 12, "Actual Loops": 1, "Output": ["d.refobjid", "d.refobjsubid", "c_1.conname", "c_1.connamespace"], "Inner Unique": false, "Shared Hit Blocks": 49, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c_1", "Startup Cost": 0.00, "Total Cost": 39.90, "Plan Rows": 8, "Plan Width": 72, "Actual Startup Time": 0.038, "Actual Total Time": 0.295, "Actual Rows": 8, "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.confdelsetcols", "c_1.conexclop", "c_1.conbin"], "Filter": "(c_1.contype = 'c'::\"char\")", "Rows Removed by Filter": 1184, "Shared Hit Blocks": 25, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "pg_depend_depender_index", "Relation Name": "pg_depend", "Schema": "pg_catalog", "Alias": "d", "Startup Cost": 0.29, "Total Cost": 2.51, "Plan Rows": 1, "Plan Width": 12, "Actual Startup Time": 0.006, "Actual Total Time": 0.007, "Actual Rows": 2, "Actual Loops": 8, "Output": ["d.classid", "d.objid", "d.objsubid", "d.refclassid", "d.refobjid", "d.refobjsubid", "d.deptype"], "Index Cond": "((d.classid = '2606'::oid) AND (d.objid = c_1.oid))", "Rows Removed by Index Recheck": 0, "Filter": "(d.refclassid = '1259'::oid)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 24, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": 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.78, "Plan Rows": 1, "Plan Width": 70, "Actual Startup Time": 0.006, "Actual Total Time": 0.006, "Actual Rows": 1, "Actual Loops": 12, "Output": ["a.attrelid", "a.attname", "a.atttypid", "a.attlen", "a.attnum", "a.attcacheoff", "a.atttypmod", "a.attndims", "a.attbyval", "a.attalign", "a.attstorage", "a.attcompression", "a.attnotnull", "a.atthasdef", "a.atthasmissing", "a.attidentity", "a.attgenerated", "a.attisdropped", "a.attislocal", "a.attinhcount", "a.attstattarget", "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": 36, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "pg_class_oid_index", "Relation Name": "pg_class", "Schema": "pg_catalog", "Alias": "r_1", "Startup Cost": 0.28, "Total Cost": 0.31, "Plan Rows": 1, "Plan Width": 76, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 1, "Actual Loops": 12, "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.oid = a.attrelid)", "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": 36, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "pg_namespace_oid_index", "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nr_1", "Startup Cost": 0.13, "Total Cost": 0.16, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 1, "Actual Loops": 12, "Output": ["nr_1.oid", "nr_1.nspname", "nr_1.nspowner", "nr_1.nspacl"], "Index Cond": "(nr_1.oid = r_1.relnamespace)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 24, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nc_1", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 4, "Plan Width": 68, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 4, "Actual Loops": 12, "Output": ["nc_1.oid", "nc_1.nspname", "nc_1.nspowner", "nc_1.nspacl"], "Shared Hit Blocks": 12, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Alias": "*SELECT* 2", "Startup Cost": 276.16, "Total Cost": 404.46, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 2.102, "Actual Total Time": 14.267, "Actual Rows": 1, "Actual Loops": 998, "Output": ["\"*SELECT* 2\".conname", "(\"*SELECT* 2\".attname)::information_schema.sql_identifier"], "Filter": "(((\"*SELECT* 2\".relname)::information_schema.sql_identifier)::name = 't_c56ng1_repository'::name)", "Rows Removed by Filter": 1784, "Shared Hit Blocks": 5146876, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 276.16, "Total Cost": 404.21, "Plan Rows": 20, "Plan Width": 324, "Actual Startup Time": 0.018, "Actual Total Time": 14.078, "Actual Rows": 1785, "Actual Loops": 998, "Output": ["NULL::name", "r_2.relname", "NULL::oid", "a_1.attname", "NULL::name", "c_2.conname"], "Inner Unique": true, "Shared Hit Blocks": 5146876, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 276.02, "Total Cost": 403.19, "Plan Rows": 20, "Plan Width": 196, "Actual Startup Time": 0.017, "Actual Total Time": 13.356, "Actual Rows": 1785, "Actual Loops": 998, "Output": ["r_2.relname", "a_1.attname", "c_2.conname", "c_2.connamespace"], "Inner Unique": true, "Shared Hit Blocks": 5146872, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 275.88, "Total Cost": 402.00, "Plan Rows": 20, "Plan Width": 200, "Actual Startup Time": 0.017, "Actual Total Time": 12.644, "Actual Rows": 1785, "Actual Loops": 998, "Output": ["r_2.relname", "r_2.relnamespace", "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": 5146868, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 275.59, "Total Cost": 320.23, "Plan Rows": 69, "Plan Width": 205, "Actual Startup Time": 0.008, "Actual Total Time": 0.881, "Actual Rows": 1184, "Actual Loops": 998, "Output": ["r_2.relname", "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": 25132, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Relation Name": "pg_constraint", "Schema": "pg_catalog", "Alias": "c_2", "Startup Cost": 0.00, "Total Cost": 41.39, "Plan Rows": 1184, "Plan Width": 133, "Actual Startup Time": 0.004, "Actual Total Time": 0.294, "Actual Rows": 1184, "Actual Loops": 998, "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.confdelsetcols", "c_2.conexclop", "c_2.conbin"], "Filter": "(c_2.contype = ANY ('{p,u,f}'::\"char\"[]))", "Rows Removed by Filter": 8, "Shared Hit Blocks": 24950, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 271.24, "Total Cost": 271.24, "Plan Rows": 348, "Plan Width": 72, "Actual Startup Time": 2.542, "Actual Total Time": 2.543, "Actual Rows": 1045, "Actual Loops": 1, "Output": ["r_2.relname", "r_2.relnamespace", "r_2.oid"], "Hash Buckets": 2048, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 123, "Shared Hit Blocks": 182, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": false, "Relation Name": "pg_class", "Schema": "pg_catalog", "Alias": "r_2", "Startup Cost": 0.00, "Total Cost": 271.24, "Plan Rows": 348, "Plan Width": 72, "Actual Startup Time": 0.009, "Actual Total Time": 2.238, "Actual Rows": 1045, "Actual Loops": 1, "Output": ["r_2.relname", "r_2.relnamespace", "r_2.oid"], "Filter": "((r_2.relkind = ANY ('{r,p}'::\"char\"[])) AND pg_has_role(r_2.relowner, 'USAGE'::text))", "Rows Removed by Filter": 4904, "Shared Hit Blocks": 182, "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, "Temp I/O Read Time": 0.000, "Temp 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, "Async Capable": 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.17, "Plan Rows": 1, "Plan Width": 70, "Actual Startup Time": 0.005, "Actual Total Time": 0.009, "Actual Rows": 2, "Actual Loops": 1181632, "Output": ["a_1.attrelid", "a_1.attname", "a_1.atttypid", "a_1.attlen", "a_1.attnum", "a_1.attcacheoff", "a_1.atttypmod", "a_1.attndims", "a_1.attbyval", "a_1.attalign", "a_1.attstorage", "a_1.attcompression", "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.attstattarget", "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": 17, "Shared Hit Blocks": 5121736, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] }, { "Node Type": "Memoize", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.14, "Total Cost": 0.17, "Plan Rows": 1, "Plan Width": 4, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 1, "Actual Loops": 1781430, "Output": ["nr_2.oid"], "Cache Key": "r_2.relnamespace", "Cache Mode": "logical", "Cache Hits": 1781428, "Cache Misses": 2, "Cache Evictions": 0, "Cache Overflows": 0, "Peak Memory Usage": 1, "Shared Hit Blocks": 4, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Index Only Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "pg_namespace_oid_index", "Relation Name": "pg_namespace", "Schema": "pg_catalog", "Alias": "nr_2", "Startup Cost": 0.13, "Total Cost": 0.16, "Plan Rows": 1, "Plan Width": 4, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 1, "Actual Loops": 2, "Output": ["nr_2.oid"], "Index Cond": "(nr_2.oid = r_2.relnamespace)", "Rows Removed by Index Recheck": 0, "Heap Fetches": 2, "Shared Hit Blocks": 4, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] }, { "Node Type": "Memoize", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.14, "Total Cost": 0.16, "Plan Rows": 1, "Plan Width": 4, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 1, "Actual Loops": 1781430, "Output": ["nc_2.oid"], "Cache Key": "c_2.connamespace", "Cache Mode": "logical", "Cache Hits": 1781428, "Cache Misses": 2, "Cache Evictions": 0, "Cache Overflows": 0, "Peak Memory Usage": 1, "Shared Hit Blocks": 4, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Index Only Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": 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.002, "Actual Total Time": 0.002, "Actual Rows": 1, "Actual Loops": 2, "Output": ["nc_2.oid"], "Index Cond": "(nc_2.oid = c_2.connamespace)", "Rows Removed by Index Recheck": 0, "Heap Fetches": 2, "Shared Hit Blocks": 4, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] } ] } ] } ] } ] }, "Settings": { "work_mem": "16MB", "hash_mem_multiplier": "1", "effective_io_concurrency": "400", "max_parallel_workers": "4", "random_page_cost": "1.1", "effective_cache_size": "36GB", "jit": "off" }, "Query Identifier": 7256322301156103390, "Planning": { "Shared Hit Blocks": 76, "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, "Temp I/O Read Time": 0.000, "Temp I/O Write Time": 0.000 }, "Planning Time": 6.945, "Triggers": [ ], "Execution Time": 14304.353 } ]