Queries

SELECT
    COALESCE(sum(psat.n_tup_upd), $1) AS total_update_count,
    COALESCE(sum(psat.n_tup_hot_upd), $2) AS hot_update_count,
    (SELECT psd.stats_reset AS stats_reset_time FROM pg_catalog.pg_stat_database psd WHERE psd.datname = current_database()) AS stats_reset_time FROM
    pg_catalog.pg_stat_all_tables psat

SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)), $1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)), $2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND n.nspname <> ALL (ARRAY[$7::name, $8::name, $9::name])

SELECT
    sum(psat.autovacuum_count) AS total_autovacuum_count,
    sum(psat.autoanalyze_count) AS total_autoanalyze_count,
    (SELECT psd.stats_reset FROM pg_stat_database psd WHERE psd.datname = current_database()) AS stats_reset_time
FROM
    pg_catalog.pg_stat_all_tables psat

SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)), $1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)), $2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND n.nspname = $7::name

SET DateStyle='ISO'

SET extra_float_digits = 3

SET application_name = 'PostgreSQL JDBC Driver'

SELECT "c"."column_name" AS "name", CASE WHEN "c"."udt_schema" IN ($3, $4) THEN FORMAT($5, "c"."udt_name") ELSE FORMAT($6, "c"."udt_schema", "c"."udt_name") END AS "database-type", "c"."ordinal_position" - $7 AS "database-position", "c"."table_schema" AS "table-schema", "c"."table_name" AS "table-name", "pk"."column_name" IS NOT NULL AS "pk?", COL_DESCRIPTION(CAST(CAST(FORMAT($8, CAST("c"."table_schema" AS TEXT), CAST("c"."table_name" AS TEXT)) AS REGCLASS) AS OID), "c"."ordinal_position") AS "field-comment", (("column_default" IS NULL) OR (LOWER("column_default") = $9)) AND ("is_nullable" = $10) AND NOT ((("column_default" IS NOT NULL) AND ("column_default" LIKE $11)) OR ("is_identity" <> $12)) AS "database-required", (("column_default" IS NOT NULL) AND ("column_default" LIKE $13)) OR ("is_identity" <> $14) AS "database-is-auto-increment" FROM "information_schema"."columns" AS "c" LEFT JOIN (SELECT "tc"."table_schema", "tc"."table_name", "kc"."column_name" FROM "information_schema"."table_constraints" AS "tc" INNER JOIN "information_schema"."key_column_usage" AS "kc" ON ("tc"."constraint_name" = "kc"."constraint_name") AND ("tc"."table_schema" = "kc"."table_schema") AND ("tc"."table_name" = "kc"."table_name") WHERE "tc"."constraint_type" = $15) AS "pk" ON ("c"."table_schema" = "pk"."table_schema") AND ("c"."table_name" = "pk"."table_name") AND ("c"."column_name" = "pk"."column_name") WHERE c.table_schema !~ $16 AND ("c"."table_schema" IN ($1)) UNION ALL SELECT "pa"."attname" AS "name", CASE WHEN "ptn"."nspname" IN ($17, $18) THEN FORMAT($19, "pt"."typname") ELSE FORMAT($20, "ptn"."nspname", "pt"."typname") END AS "database-type", "pa"."attnum" - $21 AS "database-position", "pn"."nspname" AS "table-schema", "pc"."relname" AS "table-name", $22 AS "pk?", $23 AS "field-comment", $24 AS "database-required", $25 AS "database-is-auto-increment" FROM "pg_catalog"."pg_class" AS "pc" INNER JOIN "pg_catalog"."pg_namespace" AS "pn" ON "pn"."oid" = "pc"."relnamespace" INNER JOIN "pg_catalog"."pg_attribute" AS "pa" ON "pa"."attrelid" = "pc"."oid" INNER JOIN "pg_catalog"."pg_type" AS "pt" ON "pt"."oid" = "pa"."atttypid" INNER JOIN "pg_catalog"."pg_namespace" AS "ptn" ON "ptn"."oid" = "pt"."typnamespace" WHERE ("pc"."relkind" = $26) AND ("pa"."attnum" >= $27) AND ("pn"."nspname" IN ($2)) ORDER BY "table-schema" ASC, "table-name" ASC, "database-position" ASC

SELECT extname, current_timestamp FROM pg_catalog.pg_extension UNION SELECT plugin, current_timestamp FROM pg_catalog.pg_replication_slots WHERE slot_type = $1 AND database = current_database()

SELECT "c"."column_name" AS "name", CASE WHEN "c"."udt_schema" IN ($4, $5) THEN FORMAT($6, "c"."udt_name") ELSE FORMAT($7, "c"."udt_schema", "c"."udt_name") END AS "database-type", "c"."ordinal_position" - $8 AS "database-position", "c"."table_schema" AS "table-schema", "c"."table_name" AS "table-name", "pk"."column_name" IS NOT NULL AS "pk?", COL_DESCRIPTION(CAST(CAST(FORMAT($9, CAST("c"."table_schema" AS TEXT), CAST("c"."table_name" AS TEXT)) AS REGCLASS) AS OID), "c"."ordinal_position") AS "field-comment", (("column_default" IS NULL) OR (LOWER("column_default") = $10)) AND ("is_nullable" = $11) AND NOT ((("column_default" IS NOT NULL) AND ("column_default" LIKE $12)) OR ("is_identity" <> $13)) AS "database-required", "column_default" AS "database-default", (("column_default" IS NOT NULL) AND ("column_default" LIKE $14)) OR ("is_identity" <> $15) AS "database-is-auto-increment", "is_generated" = $1 AS "database-is-generated", "is_nullable" = $16 AS "database-is-nullable" FROM "information_schema"."columns" AS "c" LEFT JOIN (SELECT "tc"."table_schema", "tc"."table_name", "kc"."column_name" FROM "information_schema"."table_constraints" AS "tc" INNER JOIN "information_schema"."key_column_usage" AS "kc" ON ("tc"."constraint_name" = "kc"."constraint_name") AND ("tc"."table_schema" = "kc"."table_schema") AND ("tc"."table_name" = "kc"."table_name") WHERE "tc"."constraint_type" = $17) AS "pk" ON ("c"."table_schema" = "pk"."table_schema") AND ("c"."table_name" = "pk"."table_name") AND ("c"."column_name" = "pk"."column_name") WHERE c.table_schema !~ $18 AND ("c"."table_schema" IN ($2)) UNION ALL SELECT "pa"."attname" AS "name", CASE WHEN "ptn"."nspname" IN ($19, $20) THEN FORMAT($21, "pt"."typname") ELSE FORMAT($22, "ptn"."nspname", "pt"."typname") END AS "database-type", "pa"."attnum" - $23 AS "database-position", "pn"."nspname" AS "table-schema", "pc"."relname" AS "table-name", $24 AS "pk?", $25 AS "field-comment", $26 AS "database-required", $27 AS "database-default", $28 AS "database-is-auto-increment", $29 AS "database-is-generated", $30 AS "database-is-nullable" FROM "pg_catalog"."pg_class" AS "pc" INNER JOIN "pg_catalog"."pg_namespace" AS "pn" ON "pn"."oid" = "pc"."relnamespace" INNER JOIN "pg_catalog"."pg_attribute" AS "pa" ON "pa"."attrelid" = "pc"."oid" INNER JOIN "pg_catalog"."pg_type" AS "pt" ON "pt"."oid" = "pa"."atttypid" INNER JOIN "pg_catalog"."pg_namespace" AS "ptn" ON "ptn"."oid" = "pt"."typnamespace" WHERE ("pc"."relkind" = $31) AND ("pa"."attnum" >= $32) AND ("pn"."nspname" IN ($3)) ORDER BY "table-schema" ASC, "table-name" ASC, "database-position" ASC

SET application_name=''

SELECT * FROM (SELECT current_database(), n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull  OR (t.typtype = $1 AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, $2) as attidentity,nullif(a.attgenerated, $3) as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname=$4)  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname=$5)  WHERE c.relkind in ($6,$7,$8,$9,$10) and a.attnum > $11 AND NOT a.attisdropped  AND n.nspname LIKE $12 AND c.relname LIKE $13) c WHERE $14  ORDER BY nspname,c.relname,attnum

SELECT        result.TABLE_CAT AS "TABLE_CAT",        result.TABLE_SCHEM AS "TABLE_SCHEM",        result.TABLE_NAME AS "TABLE_NAME",        result.COLUMN_NAME AS "COLUMN_NAME",        result.KEY_SEQ AS "KEY_SEQ",        result.PK_NAME AS "PK_NAME"FROM      (SELECT current_database() AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME,   information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM, i.indnkeyatts as KEY_COUNT FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE $1  AND n.nspname = $2 AND ct.relname = $3 AND i.indisprimary  ) result where  result.A_ATTNUM = (result.KEYS).x AND result.KEY_SEQ <= KEY_COUNT  ORDER BY result.table_name, result.pk_name, result.key_seq

with table_privileges as (
 select
   $1 as role,
   t.schemaname as schema,
   t.objectname as table,
   pg_catalog.has_any_column_privilege(current_user, $2 || replace(t.schemaname, $3, $4) || $5 || $6 || $7 || replace(t.objectname, $8, $9) || $10,  $11) as update,
   pg_catalog.has_any_column_privilege(current_user, $12 || replace(t.schemaname, $13, $14) || $15 || $16 || $17 || replace(t.objectname, $18, $19) || $20,  $21) as select,
   pg_catalog.has_any_column_privilege(current_user, $22 || replace(t.schemaname, $23, $24) || $25 || $26 || $27 || replace(t.objectname, $28, $29) || $30,  $31) as insert,
   pg_catalog.has_table_privilege(     current_user, $32 || replace(t.schemaname, $33, $34) || $35 || $36 || $37 || replace(t.objectname, $38, $39) || $40,  $41) as delete
 from (
   select schemaname, tablename as objectname from pg_catalog.pg_tables
   union
   select schemaname, viewname as objectname from pg_catalog.pg_views
   union
   select schemaname, matviewname as objectname from pg_catalog.pg_matviews
 ) t
 where t.schemaname !~ $42
   and t.schemaname <> $43
   and pg_catalog.has_schema_privilege(current_user, t.schemaname, $44)
)
select t.*
from table_privileges t

insert into gateway_pix (comments,created_at,currency_code,deleted_at,description,error,has_status_collision,merchant_payment_id,new_status_collision,original_amount,paid_amount,pix_token,qr_code_text,status,transaction_token,updated_at) values ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16) returning id

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)

insert into gateway_pix (comments,created_at,currency_code,deleted_at,error,has_status_collision,merchant_payment_id,new_status_collision,original_amount,paid_amount,pix_token,qr_code_text,status,transaction_token,updated_at) values ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15) returning id

SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT "n"."nspname" AS "schema", "c"."relname" AS "name", CASE "c"."relkind" WHEN $5 THEN $6 WHEN $7 THEN $8 WHEN $9 THEN $10 WHEN $11 THEN $12 WHEN $13 THEN $14 ELSE $15 END AS "type", "d"."description" AS "description", "stat"."n_live_tup" AS "estimated_row_count" FROM "pg_catalog"."pg_class" AS "c" INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "c"."relnamespace" = "n"."oid" LEFT JOIN "pg_catalog"."pg_description" AS "d" ON ("c"."oid" = "d"."objoid") AND ("d"."objsubid" = $1) AND ("d"."classoid" = $16::regclass) LEFT JOIN "pg_stat_user_tables" AS "stat" ON ("n"."nspname" = "stat"."schemaname") AND ("c"."relname" = "stat"."relname") WHERE ("c"."relnamespace" = "n"."oid") AND ("n"."nspname" !~ $2) AND ("n"."nspname" <> $3) AND c.relkind in ($17, $18, $19, $20, $21) AND ("n"."nspname" IN ($4)) ORDER BY "type" ASC, "schema" ASC, "name" ASC

insert into pix_events (currency_code,original_amount,paid_amount,pix_id,pix_token,status) values ($1,$2,$3,$4,$5,$6) returning id

SET TimeZone='GMT'

insert into pix_events (currency_code,original_amount,paid_amount,pix_id,pix_token,status) values ($1,$2,$3,$4,$5,$6)
RETURNING *

update gateway_pix set paid_amount=$1,qr_code_text=$2,updated_at=$3,status=$4,has_status_collision=$5 where id=$6

Covered by index on (id)
Rows: 22247
Row progression: 22247, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

select $1

SELECT nspname AS "TABLE_SCHEM", current_database() AS "TABLE_CATALOG" FROM pg_catalog.pg_namespace  WHERE nspname <> $1 AND (nspname !~ $2  OR nspname = (pg_catalog.current_schemas($3))[$4]) AND (nspname !~ $5  OR nspname = replace((pg_catalog.current_schemas($6))[$7], $8, $9))  ORDER BY "TABLE_SCHEM"

update gateway_pix set comments=$1,created_at=$2,currency_code=$3,deleted_at=$4,error=$5,has_status_collision=$6,merchant_payment_id=$7,new_status_collision=$8,original_amount=$9,paid_amount=$10,pix_token=$11,qr_code_text=$12,status=$13,transaction_token=$14,updated_at=$15 where id=$16

Covered by index on (id)
Rows: 22247
Row progression: 22247, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

select pe1_0.id,pe1_0.comments,pe1_0.created_at,pe1_0.currency_code,pe1_0.deleted_at,pe1_0.error,pe1_0.has_status_collision,pe1_0.merchant_payment_id,pe1_0.new_status_collision,pe1_0.original_amount,pe1_0.paid_amount,pe1_0.pix_token,pe1_0.qr_code_text,pe1_0.status,pe1_0.transaction_token,pe1_0.updated_at from gateway_pix pe1_0 where pe1_0.transaction_token=$1

Covered by index on (transaction_token, status)
Rows: 22247
Row progression: 22247, 1

Row estimates
- transaction_token (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/

select current_catalog

update gateway_pix set comments=$1,created_at=$2,currency_code=$3,deleted_at=$4,description=$5,error=$6,has_status_collision=$7,merchant_payment_id=$8,new_status_collision=$9,original_amount=$10,paid_amount=$11,pix_token=$12,qr_code_text=$13,status=$14,transaction_token=$15,updated_at=$16 where id=$17

Covered by index on (id)
Rows: 22247
Row progression: 22247, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

SET application_name = 'Metabase v0.55.4 [4ab81ca1-119e-4d22-ab21-871056cd693c]'

SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/

SELECT t.oid, t.typname
FROM pg_type as t
WHERE t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)

SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = $1 AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, $2) as attidentity,nullif(a.attgenerated, $3) as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname=$4)  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname=$5)  WHERE c.relkind in ($6,$7,$8,$9,$10) and a.attnum > $11 AND NOT a.attisdropped  AND n.nspname LIKE $12 AND c.relname LIKE $13) c WHERE $14  ORDER BY nspname,c.relname,attnum

SELECT        result.TABLE_CAT,        result.TABLE_SCHEM,        result.TABLE_NAME,        result.COLUMN_NAME,        result.KEY_SEQ,        result.PK_NAME FROM      (SELECT $1 AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME,   information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE $2  AND n.nspname = $3 AND ct.relname = $4 AND i.indisprimary  ) result where  result.A_ATTNUM = (result.KEYS).x  ORDER BY result.table_name, result.pk_name, result.key_seq

SELECT        result.TABLE_CAT AS "TABLE_CAT",        result.TABLE_SCHEM AS "TABLE_SCHEM",        result.TABLE_NAME AS "TABLE_NAME",        result.COLUMN_NAME AS "COLUMN_NAME",        result.KEY_SEQ AS "KEY_SEQ",        result.PK_NAME AS "PK_NAME"FROM      (SELECT current_database() AS TABLE_CAT, n.nspname AS TABLE_SCHEM,   ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,   (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME,   information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM, i.indnkeyatts as KEY_COUNT FROM pg_catalog.pg_class ct   JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)   JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)   JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid)   JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE $3  AND n.nspname = $1 AND ct.relname = $2 AND i.indisprimary  ) result where  result.A_ATTNUM = (result.KEYS).x AND result.KEY_SEQ <= KEY_COUNT  ORDER BY result.table_name, result.pk_name, result.key_seq

SELECT * FROM (SELECT current_database() AS current_database, n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull  OR (t.typtype = $3 AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, $4) as attidentity,nullif(a.attgenerated, $5) as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname=$6)  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname=$7)  WHERE c.relkind in ($8,$9,$10,$11,$12) and a.attnum > $13 AND NOT a.attisdropped  AND n.nspname LIKE $1 AND c.relname LIKE $2) c WHERE $14  ORDER BY nspname,c.relname,attnum

SELECT "tmp"."table-schema", "tmp"."table-name", TRIM(BOTH $2 FROM PG_CATALOG.PG_GET_INDEXDEF("tmp"."ci_oid", "tmp"."pos", $3)) AS "field-name" FROM (SELECT "n"."nspname" AS "table-schema", "ct"."relname" AS "table-name", "ci"."oid" AS "ci_oid", (INFORMATION_SCHEMA._PG_EXPANDARRAY("i"."indkey"))."n" AS "pos" FROM "pg_catalog"."pg_class" AS "ct" INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "ct"."relnamespace" = "n"."oid" INNER JOIN "pg_catalog"."pg_index" AS "i" ON "ct"."oid" = "i"."indrelid" INNER JOIN "pg_catalog"."pg_class" AS "ci" ON "ci"."oid" = "i"."indexrelid" WHERE (PG_CATALOG.PG_GET_EXPR("i"."indpred", "i"."indrelid") IS NULL) AND n.nspname !~ $4) AS "tmp" WHERE "tmp"."pos" = $1

SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typtype IN ($1, $2, $3)

SELECT "fk_ns"."nspname" AS "fk-table-schema", "fk_table"."relname" AS "fk-table-name", "fk_column"."attname" AS "fk-column-name", "pk_ns"."nspname" AS "pk-table-schema", "pk_table"."relname" AS "pk-table-name", "pk_column"."attname" AS "pk-column-name" FROM "pg_constraint" AS "c" INNER JOIN "pg_class" AS "fk_table" ON "c"."conrelid" = "fk_table"."oid" INNER JOIN "pg_namespace" AS "fk_ns" ON "c"."connamespace" = "fk_ns"."oid" INNER JOIN "pg_attribute" AS "fk_column" ON "c"."conrelid" = "fk_column"."attrelid" INNER JOIN "pg_class" AS "pk_table" ON "c"."confrelid" = "pk_table"."oid" INNER JOIN "pg_namespace" AS "pk_ns" ON "pk_table"."relnamespace" = "pk_ns"."oid" INNER JOIN "pg_attribute" AS "pk_column" ON "c"."confrelid" = "pk_column"."attrelid" WHERE fk_ns.nspname !~ $2 AND ("c"."contype" = $3::char) AND ("fk_column"."attnum" = ANY(c.conkey)) AND ("pk_column"."attnum" = ANY(c.confkey)) AND ("fk_ns"."nspname" IN ($1)) ORDER BY "fk-table-schema" ASC, "fk-table-name" ASC

SET application_name = 'Metabase v0.54.3 [dc38388e-2ec2-4652-8a2e-b0964ad66424]'

select pe1_0.id,pe1_0.comments,pe1_0.created_at,pe1_0.currency_code,pe1_0.deleted_at,pe1_0.description,pe1_0.error,pe1_0.has_status_collision,pe1_0.merchant_payment_id,pe1_0.new_status_collision,pe1_0.original_amount,pe1_0.paid_amount,pe1_0.pix_token,pe1_0.qr_code_text,pe1_0.status,pe1_0.transaction_token,pe1_0.updated_at from gateway_pix pe1_0 where pe1_0.transaction_token=$1

Covered by index on (transaction_token, status)
Rows: 22247
Row progression: 22247, 1

Row estimates
- transaction_token (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

SET TimeZone='America/Sao_Paulo'

SET application_name = 'Metabase v0.57.6 [ba292c24-6eca-4333-b4b8-84fa722a7cba]'

SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = $1 AND t.typnotnull), a.attidentity != $2 OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE $3 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT $4 AS oid , $5 AS attnum UNION ALL SELECT $6, $7 UNION ALL SELECT $8, $9 UNION ALL SELECT $10, $11 UNION ALL SELECT $12, $13 UNION ALL SELECT $14, $15 UNION ALL SELECT $16, $17 UNION ALL SELECT $18, $19 UNION ALL SELECT $20, $21 UNION ALL SELECT $22, $23 UNION ALL SELECT $24, $25 UNION ALL SELECT $26, $27 UNION ALL SELECT $28, $29) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) where c.oid in ($30)

SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = $1 AND t.typnotnull), a.attidentity != $2 OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE $3 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT $4 AS oid , $5 AS attnum UNION ALL SELECT $6, $7 UNION ALL SELECT $8, $9 UNION ALL SELECT $10, $11) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) where c.oid in ($12)

select string_agg(word, $1) from pg_catalog.pg_get_keywords() where word <> ALL ($2::text[])

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typelem IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48)

SELECT last_value FROM "public"."gateway_pix_id_seq" UNION ALL SELECT last_value FROM "public"."pix_events_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_events_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_events_transaction_id_seq" /*pghero*/

SELECT "n"."nspname" AS "schema", "c"."relname" AS "name", CASE "c"."relkind" WHEN $6 THEN $7 WHEN $8 THEN $9 WHEN $10 THEN $11 WHEN $12 THEN $13 WHEN $14 THEN $15 ELSE $16 END AS "type", "d"."description" AS "description", NULLIF("stat"."n_live_tup", $1) AS "estimated_row_count" FROM "pg_catalog"."pg_class" AS "c" INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "c"."relnamespace" = "n"."oid" LEFT JOIN "pg_catalog"."pg_description" AS "d" ON ("c"."oid" = "d"."objoid") AND ("d"."objsubid" = $2) AND ("d"."classoid" = $17::regclass) LEFT JOIN "pg_stat_user_tables" AS "stat" ON ("n"."nspname" = "stat"."schemaname") AND ("c"."relname" = "stat"."relname") WHERE ("c"."relnamespace" = "n"."oid") AND ("n"."nspname" !~ $3) AND ("n"."nspname" <> $4) AND c.relkind in ($18, $19, $20, $21, $22) AND ("n"."nspname" IN ($5)) ORDER BY "type" ASC, "schema" ASC, "name" ASC

SELECT t.oid,t.*,c.relkind,format_type(nullif(t.typbasetype, $1), t.typtypmod) as base_type_name, d.description
FROM pg_catalog.pg_type t
LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid=t.typelem 
LEFT OUTER JOIN pg_catalog.pg_class c ON c.oid=t.typrelid
LEFT OUTER JOIN pg_catalog.pg_description d ON t.oid=d.objoid
WHERE t.typname IS NOT NULL
AND (c.relkind IS NULL OR c.relkind = $2) AND (et.typcategory IS NULL OR et.typcategory <> $3)

SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED

SELECT * FROM pg_stat_statements LIMIT $1 /*pghero*/

SELECT last_value FROM "public"."gateway_pix_id_seq" UNION ALL SELECT last_value FROM "public"."pix_events_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_events_id_seq" UNION ALL SELECT last_value FROM "public"."disputes_events_transaction_id_seq" UNION ALL SELECT last_value FROM "public"."tokenized_pix_accounts_id_seq" UNION ALL SELECT last_value FROM "public"."tokenized_pix_account_events_id_seq" /*pghero*/

SELECT nspname AS TABLE_SCHEM, $1 AS TABLE_CATALOG FROM pg_catalog.pg_namespace  WHERE nspname <> $2 AND (nspname !~ $3  OR nspname = (pg_catalog.current_schemas($4))[$5]) AND (nspname !~ $6  OR nspname = replace((pg_catalog.current_schemas($7))[$8], $9, $10))  ORDER BY TABLE_SCHEM

SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = $1 AND t.typnotnull), a.attidentity != $2 OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE $3 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT $4 AS oid , $5 AS attnum UNION ALL SELECT $6, $7 UNION ALL SELECT $8, $9 UNION ALL SELECT $10, $11 UNION ALL SELECT $12, $13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) where c.oid in ($14)

SELECT pid, state, application_name AS source, age(NOW(), COALESCE(query_start, xact_start)) AS duration, (wait_event IS NOT NULL) AS waiting, query, COALESCE(query_start, xact_start) AS started_at, EXTRACT($1 FROM NOW() - COALESCE(query_start, xact_start)) * $2 AS duration_ms, usename AS user, backend_type FROM pg_stat_activity WHERE state <> $3 AND pid <> pg_backend_pid() AND datname = current_database() AND NOW() - COALESCE(query_start, xact_start) > interval $4 AND query <> $5 ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/

SELECT n.nspname AS schema, c.relname AS table, $1 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid)) AS transactions_left FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_class t ON c.reltoastrelid = t.oid WHERE c.relkind = $2 AND ($3 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid))) < $4 ORDER BY 3, 1, 2 /*pghero*/

SET application_name = 'Metabase v0.55.3 [908574d9-21e0-4f2d-b616-3703bda6920d]'

select * from gateway_pix gp where gp.qr_code_text = $1

CREATE INDEX CONCURRENTLY ON gateway_pix (qr_code_text)

Rows: 22247
Row progression: 22247, 1

Row estimates
- qr_code_text (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

SET application_name = 'Metabase v0.55.8 [7f7142ba-0f96-4aec-aa59-d91fcebd2d73]'

SELECT nsp.nspname AS schema, rel.relname AS table, con.conname AS name, fnsp.nspname AS referenced_schema, frel.relname AS referenced_table FROM pg_catalog.pg_constraint con INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid LEFT JOIN pg_catalog.pg_class frel ON frel.oid = con.confrelid LEFT JOIN pg_catalog.pg_namespace nsp ON nsp.oid = con.connamespace LEFT JOIN pg_catalog.pg_namespace fnsp ON fnsp.oid = frel.relnamespace WHERE con.convalidated = $1 /*pghero*/

SET application_name='Metabase v0.55.4 [4ab81ca1-119e-4d22-ab21-871056cd693c]'

SELECT typinput=$2::regproc as is_array, typtype, typname, pg_type.oid   FROM pg_catalog.pg_type   LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas($3))[s.r] as nspname                    from generate_series($4, array_upper(current_schemas($5), $6)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE pg_type.oid = $1  ORDER BY sp.r, pg_type.oid DESC

create table tokenized_pix_accounts
(
    id                  bigserial,
    pix_token           uuid not null,
    ispb                varchar(20)  not null,
    bank                varchar(20)  not null,
    bank_account        varchar(50)  not null,
    bank_branch         varchar(20)  not null,
    bank_account_digit  varchar(5)   not null,
    account_holder_name varchar(255) not null,
    tax_number          varchar(20)  not null,
    tax_type            varchar(4)   not null,
    metadata            jsonb,
    status              varchar(50),
    status_reason       varchar(255),
    created_at          timestamp default CURRENT_TIMESTAMP,
    updated_at          timestamp,
    deleted_at          timestamp,
    used_at             timestamp,

    constraint pk_tokenized_pix_accounts primary key (id),
    constraint uq_tokenized_pix_accounts_token unique (pix_token),
    constraint uq_tokenized_pix_accounts_account unique (ispb, bank, bank_branch, bank_account, bank_account_digit, tax_number),
    constraint ck_tokenized_pix_accounts_tax_type check (tax_type in ('CPF', 'CNPJ', 'MISSING', 'PASSPORT', 'RNE'))
)

select pe1_0.id,pe1_0.comments,pe1_0.created_at,pe1_0.currency_code,pe1_0.deleted_at,pe1_0.error,pe1_0.has_status_collision,pe1_0.merchant_payment_id,pe1_0.new_status_collision,pe1_0.original_amount,pe1_0.paid_amount,pe1_0.pix_token,pe1_0.qr_code_text,pe1_0.status,pe1_0.transaction_token,pe1_0.updated_at from gateway_pix pe1_0 where pe1_0.id=$1

Covered by index on (id)
Rows: 22247
Row progression: 22247, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

SET application_name='Metabase v0.54.11 [66edaad8-a76e-4518-8cd0-f5ce4607bedd]'

SET application_name='Metabase v0.54.9 [f26f19a4-a07c-41bf-886f-ffe12caf6a99]'

CREATE EXTENSION IF NOT EXISTS pg_stat_statements /*pghero*/

SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*pghero*/

SET application_name = 'Metabase v0.58.5.2 [27133d2b-860a-42f4-9d31-ce9b4d148d6a]'

SET application_name = 'Metabase v0.55.10 [0d5e4e57-029f-4fa7-ab80-e8908ccce4d9]'

SET application_name = 'Metabase v0.58.6.1 [78ad800a-ee89-4a0d-a7c5-f32a33ddf1ed]'

SET application_name='Metabase v0.54.9 [b357cdb9-2310-4985-b844-5fbb306e9d58]'

select pe1_0.id,pe1_0.comments,pe1_0.created_at,pe1_0.currency_code,pe1_0.deleted_at,pe1_0.description,pe1_0.error,pe1_0.has_status_collision,pe1_0.merchant_payment_id,pe1_0.new_status_collision,pe1_0.original_amount,pe1_0.paid_amount,pe1_0.pix_token,pe1_0.qr_code_text,pe1_0.status,pe1_0.transaction_token,pe1_0.updated_at from gateway_pix pe1_0 where pe1_0.id=$1

Covered by index on (id)
Rows: 22247
Row progression: 22247, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- merchant_payment_id, status
- pix_token UNIQUE
- pix_token, status
- transaction_token UNIQUE
- transaction_token, status

SET application_name='Metabase v0.54.8 [d5dfb610-2a5d-4c14-a421-2229219e6c69]'

alter table gateway_pix
    add description varchar(255)

SET application_name = 'Metabase v0.56.8 [1b049a17-5270-42c4-be05-e2274f7e60ec]'

SELECT n.nspname AS schema, c.relname AS sequence, has_sequence_privilege(c.oid, $1) AS readable FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = $2 AND n.nspname NOT IN ($3, $4) /*pghero*/

SET application_name = 'Metabase v0.58.1 [f8c2d014-996c-456a-8ac0-eb8f550a8eec]'

SET application_name='Metabase v0.54.6 [31b894aa-957c-4dab-ad8c-42aa65719f39]'

SHOW TRANSACTION ISOLATION LEVEL

SET application_name='Metabase v0.54.3 [dc38388e-2ec2-4652-8a2e-b0964ad66424]'

SELECT nspname, typname FROM pg_type t JOIN pg_namespace n ON n.oid = t.typnamespace WHERE t.oid IN (SELECT DISTINCT enumtypid FROM pg_enum e)

SELECT n.nspname = ANY(current_schemas($2)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1

SET extra_float_digits = 2

SET application_name = 'Metabase v0.56.9 [593d4851-10d5-43c1-9862-174c708b436c]'

SELECT schemaname AS schema, tablename AS table, attname AS column, null_frac, n_distinct FROM pg_stats WHERE schemaname = $1 AND tablename IN ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) ORDER BY 1, 2, 3 /*pghero*/

SELECT COUNT(*) AS count FROM pg_available_extensions WHERE name = $1 /*pghero*/

SET application_name='Metabase v0.55.3 [908574d9-21e0-4f2d-b616-3703bda6920d]'

SET SESSION timezone TO 'UTC'

-- Metabase
SELECT "public"."disputes"."updated_at" AS "updated_at", "public"."disputes"."refunded_at" AS "refunded_at", "public"."disputes"."total_amount" AS "total_amount", "public"."disputes"."paid_amount" AS "paid_amount", SUBSTRING("public"."disputes"."status_reason", $1, $2) AS "substring33597", "public"."disputes"."deleted_at" AS "deleted_at", "public"."disputes"."transaction_token" AS "transaction_token", "public"."disputes"."movement_date" AS "movement_date", "public"."disputes"."payer_token" AS "payer_token", "public"."disputes"."created_at" AS "created_at", "public"."disputes"."merchant_token" AS "merchant_token", "public"."disputes"."payment_method_token" AS "payment_method_token", SUBSTRING("public"."disputes"."session_key", $3, $4) AS "substring33598", SUBSTRING("public"."disputes"."comments", $5, $6) AS "substring33599", "public"."disputes"."payment_partner_token" AS "payment_partner_token", "public"."disputes"."business_unit_token" AS "business_unit_token", SUBSTRING("public"."disputes"."status", $7, $8) AS "substring33600" FROM "public"."disputes" LIMIT $9

show timezone

-- Metabase
SELECT SUBSTRING("public"."disputes_events"."session_key", $1, $2) AS "substring33621", "public"."disputes_events"."deleted_at" AS "deleted_at", SUBSTRING("public"."disputes_events"."status", $3, $4) AS "substring33622", "public"."disputes_events"."transaction_id" AS "transaction_id", SUBSTRING("public"."disputes_events"."event_name", $5, $6) AS "substring33623", "public"."disputes_events"."created_at" AS "created_at", "public"."disputes_events"."updated_at" AS "updated_at", SUBSTRING("public"."disputes_events"."status_reason", $7, $8) AS "substring33624" FROM "public"."disputes_events" LIMIT $9

SET application_name = 'Metabase v0.56.3 [165ced25-5854-41c1-9461-3d65fefe36ff]'

BEGIN

SELECT c.relname,a.*,pg_catalog.pg_get_expr(ad.adbin, ad.adrelid, $2) as def_value,dsc.description,dep.objid
FROM pg_catalog.pg_attribute a
INNER JOIN pg_catalog.pg_class c ON (a.attrelid=c.oid)
LEFT OUTER JOIN pg_catalog.pg_attrdef ad ON (a.attrelid=ad.adrelid AND a.attnum = ad.adnum)
LEFT OUTER JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)
LEFT OUTER JOIN pg_depend dep on dep.refobjid = a.attrelid AND dep.deptype = $3 and dep.refobjsubid = a.attnum and dep.classid = dep.refclassid
WHERE NOT a.attisdropped AND c.relkind not in ($4,$5,$6) AND c.oid=$1
ORDER BY a.attnum

SELECT CASE WHEN $3 < LENGTH(CAST("public"."tokenized_pix_account_events"."metadata" AS TEXT)) THEN $4 ELSE "public"."tokenized_pix_account_events"."metadata" END AS "metadata" FROM "public"."tokenized_pix_account_events" INNER JOIN ((SELECT "public"."tokenized_pix_account_events"."id" FROM "public"."tokenized_pix_account_events" ORDER BY "public"."tokenized_pix_account_events"."id" ASC LIMIT $1) UNION ALL (SELECT "public"."tokenized_pix_account_events"."id" FROM "public"."tokenized_pix_account_events" ORDER BY "public"."tokenized_pix_account_events"."id" DESC LIMIT $2)) AS "result" ON ("result"."id" = "public"."tokenized_pix_account_events"."id")

SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = $1 AND t.typnotnull), a.attidentity != $2 OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE $3 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT $4 AS oid , $5 AS attnum UNION ALL SELECT $6, $7 UNION ALL SELECT $8, $9 UNION ALL SELECT $10, $11 UNION ALL SELECT $12, $13 UNION ALL SELECT $14, $15 UNION ALL SELECT $16, $17 UNION ALL SELECT $18, $19 UNION ALL SELECT $20, $21 UNION ALL SELECT $22, $23 UNION ALL SELECT $24, $25 UNION ALL SELECT $26, $27 UNION ALL SELECT $28, $29) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)