PG13_32644.txt
text/plain
Filename: PG13_32644.txt
Type: text/plain
Part: 0
[
{
"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
}
]