public inbox for [email protected]help / color / mirror / Atom feed
From: nikhil raj <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Cc: NIKITA PATEL <[email protected]>
Cc: Patel Khushbu <[email protected]>
Subject: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
Date: Tue, 27 Aug 2024 03:19:04 +0530
Message-ID: <CAG1ps1xvnTZceKK24OUfMKLPvDP2vjT-d+F2AOCWbw_v3KeEgg@mail.gmail.com> (raw)
In-Reply-To: <CAAvG1pChk3W9MWkK-_JPyUdThSoJhv4MueH5i8cZS2T_HUP5dA@mail.gmail.com>
References: <CALNXOfqDr5jVRZHThyXyNftDuezjxOJB1mqw=4x1T8YBibi6uw@mail.gmail.com>
<CAG1ps1w61XD1LxUf3EBCZ=VR3S_orRj_dk6cxmO5KusBVyrgMg@mail.gmail.com>
<CAAvG1pChk3W9MWkK-_JPyUdThSoJhv4MueH5i8cZS2T_HUP5dA@mail.gmail.com>
Hi All,
I've encountered a noticeable difference in execution time and query
execution plan row counts between PostgreSQL 13 and PostgreSQL 16 when
running a query on information_schema tables. Surprisingly, PostgreSQL 16
is performing slower than PostgreSQL 13.
The query executed on both versions is as follows:
SELECT DISTINCT "tc"."constraint_name" AS "ConstraintName",
"ccu"."column_name" AS "ColumnName"
FROM
information_schema.constraint_column_usage AS "ccu" right join
information_schema.table_constraints AS "tc"
ON "tc"."constraint_catalog" = "ccu"."constraint_catalog"
AND "tc"."constraint_name" = "ccu"."constraint_name"
WHERE "tc"."constraint_type" = 'PRIMARY KEY'
AND "ccu"."table_name" = 't_c56ng1_repository'
Here are the details of the PostgreSQL versions and the execution plans:
*4PostgreSQL 13.14 (PostgreSQL 13.14 on x86_64-pc-linux-gnu, compiled by
gcc 11.4.0, 64-bit)*
Execution plan: PG13.14 Execution Plan
<https://explain.dalibo.com/plan/ag1a62a9d47dg29d;
*PostgreSQL 16.4 (PostgreSQL 16.4 on x86_64-pc-linux-gnu, compiled by gcc
11.4.0, 64-bit)*
Execution plan: PG16.4 Execution Plan
<https://explain.dalibo.com/plan/4c66fdfbf2hf9ed2;
Has anyone else experienced similar behavior or could provide insights into
why PostgreSQL 16 might be slower for this query? Any advice or suggestions
for optimization would be greatly appreciated.
Thank you!
NOTE:- PFA the raw file of explain and analyze below.
[
{
"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
}
]
[
{
"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
}
]
Attachments:
[text/plain] PG13_32644.txt (80.1K, 3-PG13_32644.txt)
download
[text/plain] PG16_32644.txt (92.0K, 4-PG16_32644.txt)
download
view thread (22+ messages) latest in thread
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: [email protected] Cc: [email protected], [email protected], [email protected], [email protected] Subject: Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. In-Reply-To: <CAG1ps1xvnTZceKK24OUfMKLPvDP2vjT-d+F2AOCWbw_v3KeEgg@mail.gmail.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox