PgHero

Queries

Total Time Average Time Calls
160 min 86% 418 ms 22,881 postgres 
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*/
10 min 6% 27 ms 22,881 postgres 
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*/
9 min 5% 23 ms 22,881 postgres 
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*/
2 min 1.0% 13,787 ms 8 postgres 
COPY public.impacto_request_log (id, slug, created_at, created_by, updated_at, updated_by, url, http, authentication, application, body, header, browser, device, os, useragent, "time", res_http, res_body, res_header, res_action, res_field, res_code, res_success, params) TO stdout
1 min 0.4% 2 ms 22,881 postgres 
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*/
1 min 0.3% 536 ms 58 postgres 
SELECT
                oid.namespace,
                info.table_name,
                info.column_name,
                format_type(att.atttypid, att.atttypmod) as formatted_type,
                info.numeric_precision,
                info.numeric_scale,
                info.numeric_precision_radix,
                info.datetime_precision,
                info.data_type,
                info.udt_schema as type_schema_name,
                info.udt_name as full_data_type,
                pg_get_expr(attdef.adbin, attdef.adrelid) AS column_default,
                info.is_nullable,
                info.is_identity,
                info.character_maximum_length,
                col_description(att.attrelid, ordinal_position) AS description
            FROM information_schema.columns info
            JOIN pg_attribute att ON att.attname = info.column_name
            JOIN (
                 SELECT pg_class.oid, relname, pg_namespace.nspname as namespace
                 FROM pg_class
                 JOIN pg_namespace on pg_namespace.oid = pg_class.relnamespace
                 AND pg_namespace.nspname = ANY ( $1 )
                 WHERE reltype > $2
                ) as oid on oid.oid = att.attrelid 
                  AND relname = info.table_name
                  AND namespace = info.table_schema
            LEFT OUTER JOIN pg_attrdef attdef ON attdef.adrelid = att.attrelid AND attdef.adnum = att.attnum AND table_schema = namespace
            WHERE table_schema = ANY ( $1 ) 
            ORDER BY namespace, table_name, ordinal_position
0 min 0.3% 1 ms 22,881 postgres 
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*/
0 min 0.2% 1 ms 27,310 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, updated_at, url, http, body, header, params, browser, device, os, useragent, time, res_http, res_body, res_header, res_action, res_field, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20  RETURNING id
0 min 0.2% 7,856 ms 3 postgres 
COPY api_test_schema.impacto_request_log (id, slug, created_at, created_by, updated_at, updated_by, url, http, authentication, application, body, header, browser, device, os, useragent, "time", res_http, res_body, res_header, res_action, res_field, res_code, res_success, params) TO stdout
0 min 0.2% 2 ms 12,827 postgres 
SELECT last_value FROM "api_test_schema"."impacto_activity_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_activity_type_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_activity_type_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_address_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_address_owner_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_alert_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_alert_follow_up_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_alert_follow_up_action_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_alert_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_application_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_archive_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_archive_directory_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_archive_file_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_attendance_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_attendance_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_bond_option_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_bond_request_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_contact_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_document_draft_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_document_draft_access_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_group_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_group_member_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_organizational_unit_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_origin_activity_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_person_permission_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_person_place_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_person_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_place_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_place_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_request_log_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_letter_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_letter_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_subject_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_target_audience_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_service_target_audience_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_system_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_unified_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_unified_person_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema"."impacto_visualization_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_activity_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_activity_type_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_address_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_address_owner_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_alert_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_alert_follow_up_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_alert_follow_up_action_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_alert_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_application_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_archive_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_archive_directory_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_archive_file_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_bond_option_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_bond_request_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_contact_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_group_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_group_member_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_organizational_unit_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_origin_activity_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_person_permission_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_person_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_place_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_place_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_request_log_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_letter_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_letter_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_subject_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_target_audience_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_service_target_audience_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_system_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_unified_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_unified_person_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v2"."impacto_visualization_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_activity_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_activity_type_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_address_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_address_owner_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_alert_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_alert_follow_up_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_alert_follow_up_action_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_alert_type_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_application_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_archive_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_archive_directory_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_archive_file_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_bond_option_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_bond_request_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_contact_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_group_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_group_member_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_organizational_unit_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_origin_activity_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_person_permission_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_person_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_place_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_place_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_request_log_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_role_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_letter_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_letter_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_subject_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_target_audience_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_service_target_audience_of_service_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_system_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_unified_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_unified_person_origin_person_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v3"."impacto_visualization_id_seq" UNION ALL SELECT last_value FROM "api_test_schema_v4"."impacto_activity_type_id_seq" UNION ALL SELECT last_value FROM "api_test_
0 min 0.2% 6,637 ms 3 postgres 
COPY microservice_test_schema.impacto_microservice_request_log (id, slug, created_at, resolved_at, ip_address, service, operation, rec_body, res_body, microservice, res_error, created_by) TO stdout
0 min 0.1% 1 ms 23,562 postgres 
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)
0 min 0.1% 4,633 ms 3 postgres 
COPY dataset.surname (id, name, corrected_name) TO stdout
0 min 0.1% 1 ms 23,562 postgres 
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)
0 min 0.1% 4,000 ms 3 postgres 
COPY dataset.name (id, full_name, sex) TO stdout
0 min < 0.1% 0 ms 23,562 postgres 
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, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124)
0 min < 0.1% 0 ms 22,881 postgres 
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*/
0 min < 0.1% 97 ms 58 postgres 
WITH rawindex AS (
    SELECT
        indrelid, 
        indexrelid,
        indisunique,
        indisprimary,
        unnest(indkey) AS indkeyid,
        generate_subscripts(indkey, $2) AS indkeyidx,
        unnest(indclass) AS indclass,
        unnest(indoption) AS indoption
    FROM pg_index -- https://www.postgresql.org/docs/current/catalog-pg-index.html
    WHERE
        indpred IS NULL -- filter out partial indexes
        AND NOT indisexclusion -- filter out exclusion constraints
)
SELECT
    schemainfo.nspname AS namespace,
    indexinfo.relname AS index_name,
    tableinfo.relname AS table_name,
    columninfo.attname AS column_name,
    rawindex.indisunique AS is_unique,
    rawindex.indisprimary AS is_primary_key,
    rawindex.indkeyidx AS column_index,
    opclass.opcname AS opclass,
    opclass.opcdefault AS opcdefault,
    indexaccess.amname AS index_algo,
    CASE rawindex.indoption & $3
        WHEN $4 THEN $5
        ELSE $6 END
        AS column_order,
    CASE rawindex.indoption & $7
        WHEN $8 THEN $9
        ELSE $10 END
        AS nulls_first,
    pc.condeferrable AS condeferrable,
    pc.condeferred AS condeferred
FROM
    rawindex
    INNER JOIN pg_class AS tableinfo ON tableinfo.oid = rawindex.indrelid
    INNER JOIN pg_class AS indexinfo ON indexinfo.oid = rawindex.indexrelid
    INNER JOIN pg_namespace AS schemainfo ON schemainfo.oid = tableinfo.relnamespace
    LEFT JOIN pg_attribute AS columninfo
        ON columninfo.attrelid = tableinfo.oid AND columninfo.attnum = rawindex.indkeyid
    INNER JOIN pg_am AS indexaccess ON indexaccess.oid = indexinfo.relam
    LEFT JOIN pg_opclass AS opclass -- left join because crdb has no opclasses
        ON opclass.oid = rawindex.indclass
    LEFT JOIN pg_constraint pc ON rawindex.indexrelid = pc.conindid AND pc.contype <> $11
WHERE schemainfo.nspname = ANY ( $1 )
ORDER BY namespace, table_name, index_name, column_index
0 min < 0.1% 1,338 ms 3 postgres 
COPY production.socialme_afghanistan (id, slug, created_at, created_by, updated_at, updated_by, ip_address, url, http_method, user_token, api_token, app_token, body, headers, params, browser_name, browser_version, device_name, device_version, os_name, os_version, user_agent, res_http_code, res_code, res_body, time_spent, time_unit, error, action, field) TO stdout
0 min < 0.1% 0 ms 23,562 postgres 
SET SESSION timezone TO 'UTC'
0 min < 0.1% 261 ms 8 postgres 
SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, $1) AS condef, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, (SELECT pg_catalog.array_agg(attnum ORDER BY attnum)   FROM pg_catalog.pg_attribute   WHERE attrelid = i.indexrelid AND     attstattarget >= $2) AS indstatcols, (SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum)   FROM pg_catalog.pg_attribute   WHERE attrelid = i.indexrelid AND     attstattarget >= $3) AS indstatvals, $4 AS indnullsnotdistinct FROM unnest($5::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ($6,$7,$8)) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = $9) AND i.indisready ORDER BY i.indrelid, indexname
0 min < 0.1% 0 ms 22,881 postgres 
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*/
0 min < 0.1% 185 ms 8 postgres 
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != $1 AND deptype != $2
UNION ALL
SELECT $3::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ($4, $5, $6) AND classid = $7::regclass AND objid = o.oid AND NOT (refclassid = $8::regclass AND amopfamily = refobjid)
UNION ALL
SELECT $9::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ($10, $11, $12) AND classid = $13::regclass AND objid = p.oid AND NOT (refclassid = $14::regclass AND amprocfamily = refobjid)
ORDER BY 1,2
0 min < 0.1% 0 ms 23,562 postgres 
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)
0 min < 0.1% 0 ms 22,881 postgres 
SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*pghero*/
0 min < 0.1% 1 ms 1,505 postgres 
INSERT INTO production.socialme_afghanistan ("slug", "created_at", "ip_address", "url", "http_method", "user_token", "api_token", "app_token", "body", "headers", "params", "user_agent", "res_http_code", "res_code", "res_body", "time_spent", "time_unit", "error", "action", "field") 
                VALUES ($1, $2, $3, $4, $5, $6, $7, $8, NULLIF($9, $10)::json, NULLIF($11, $12)::json, NULLIF($13, $14)::json, $15, $16, $17, NULLIF($18, $19)::json, NULLIF($20,$21)::numeric, $22, NULLIF($23, $24)::json, $25, $26)
0 min < 0.1% 1 ms 1,371 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, created_by, updated_at, updated_by, url, http, authentication, application, body, header, params, browser, device, os, useragent, time, res_http, res_body, res_header, res_action, res_field, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24  RETURNING id
0 min < 0.1% 1 ms 1,031 postgres 
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
0 min < 0.1% 14 ms 58 postgres 
SELECT
                con.oid         AS "con_id",
                att2.attname    AS "child_column",
                cl.relname      AS "parent_table",
                att.attname     AS "parent_column",
                con.confdeltype,
                con.confupdtype,
                rel_ns.nspname  AS "referenced_schema_name",
                conname         AS constraint_name,
                child,
                parent,
                table_name, 
                namespace,
                condeferrable,
                condeferred
            FROM (SELECT 
                        ns.nspname AS "namespace",
                        unnest(con1.conkey)                AS "parent",
                        unnest(con1.confkey)                AS "child",
                        cl.relname                          AS table_name,
                        ns.nspname                          AS schema_name,
                        generate_subscripts(con1.conkey, $2) AS colidx,
                        con1.oid,
                        con1.confrelid,
                        con1.conrelid,
                        con1.conname,
                        con1.confdeltype,
                        con1.confupdtype,
                        con1.condeferrable                  AS condeferrable,
                        con1.condeferred                    AS condeferred
                FROM pg_class cl
                        join pg_constraint con1 on con1.conrelid = cl.oid
                        join pg_namespace ns on cl.relnamespace = ns.oid
                WHERE
                    ns.nspname = ANY ( $1 )
                    and con1.contype = $3
                ORDER BY colidx
                ) con
                    JOIN pg_attribute att on att.attrelid = con.confrelid and att.attnum = con.child
                    JOIN pg_class cl on cl.oid = con.confrelid
                    JOIN pg_attribute att2 on att2.attrelid = con.conrelid and att2.attnum = con.parent
                    JOIN pg_class rel_cl on con.confrelid = rel_cl.oid
                    JOIN pg_namespace rel_ns on rel_cl.relnamespace = rel_ns.oid
            ORDER BY namespace, table_name, constraint_name, con_id, con.colidx
0 min < 0.1% 2 ms 331 postgres 
SELECT
        table_schema,
        table_name,
        column_name,
        is_nullable,
        is_generated,
        ordinal_position,
        column_default,
        CASE
          WHEN character_maximum_length is not null  and udt_name != $3
            THEN udt_name || $4 || character_maximum_length::varchar(255) || $5
          WHEN numeric_precision is not null and numeric_scale is not null
            THEN udt_name || $6 || numeric_precision::varchar(255) || $7 || numeric_scale::varchar(255) || $8
          WHEN numeric_precision is not null and numeric_scale is null
            THEN udt_name || $9 || numeric_precision::varchar(255) || $10
          WHEN datetime_precision is not null AND udt_name != $11 THEN
            udt_name || $12 || datetime_precision::varchar(255) || $13
          ELSE udt_name
        END as data_type,
        CASE
          WHEN data_type = $14 THEN $15
          ELSE $16
        END as is_array,
        pg_catalog.col_description(format($17, table_schema, table_name)::regclass::oid, ordinal_position) as column_comment
      FROM information_schema.columns
      WHERE table_schema = $1 AND table_name = $2
      ORDER BY table_schema, table_name, ordinal_position
0 min < 0.1% 94 ms 8 postgres 
COPY public.impacto_city (id, slug, created_at, created_by, updated_at, updated_by, status, name, short_name, english_name, description, icon, color, category, code, country_id, state_id) TO stdout
0 min < 0.1% 1 ms 931 postgres 
INSERT INTO production.socialme_afghanistan ("slug", "created_at", "ip_address", "url", "http_method", "user_token", "api_token", "app_token", "body", "headers", "params", "browser_name", "browser_version", "os_name", "os_version", "user_agent", "res_http_code", "res_code", "res_body", "time_spent", "time_unit", "error", "action", "field") 
                VALUES ($1, $2, $3, $4, $5, $6, $7, $8, NULLIF($9, $10)::json, NULLIF($11, $12)::json, NULLIF($13, $14)::json, $15, $16, $17, $18, $19, $20, $21, NULLIF($22, $23)::json, NULLIF($24,$25)::numeric, $26, NULLIF($27, $28)::json, $29, $30)
0 min < 0.1% 12 ms 41 postgres 
SELECT i.*,i.indkey as keys,c.relname,c.relnamespace,c.relam,c.reltablespace,tc.relname as tabrelname,dsc.description,pg_catalog.pg_get_expr(i.indpred, i.indrelid) as pred_expr,pg_catalog.pg_get_expr(i.indexprs, i.indrelid, $2) as expr,pg_catalog.pg_relation_size(i.indexrelid) as index_rel_size,pg_catalog.pg_stat_get_numscans(i.indexrelid) as index_num_scans
FROM pg_catalog.pg_index i
INNER JOIN pg_catalog.pg_class c ON c.oid=i.indexrelid
INNER JOIN pg_catalog.pg_class tc ON tc.oid=i.indrelid
LEFT OUTER JOIN pg_catalog.pg_description dsc ON i.indexrelid=dsc.objoid
WHERE  i.indrelid=$1 ORDER BY tabrelname, c.relname
0 min < 0.1% 0 ms 22,831 postgres 
SELECT nspname AS schema, relname AS table, reltuples::bigint AS estimated_rows, pg_total_relation_size(pg_class.oid) AS size_bytes FROM pg_class INNER JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE relkind = $1 AND nspname = $2 AND relname IN ($3, $4) ORDER BY 1, 2 /*pghero*/
0 min < 0.1% 0 ms 45,763 postgres 
SELECT c.relname FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = ANY (current_schemas($1)) AND c.relname = $2 AND c.relkind IN ($3,$4)
0 min < 0.1% 50 ms 8 postgres 
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault(CASE WHEN c.relkind = $1 THEN $2::"char" ELSE $3::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = $4 THEN (SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE $5 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, $6 AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions,$7),$8) AS reloptions, CASE WHEN $9 = ANY (c.reloptions) THEN $10::text WHEN $11 = ANY (c.reloptions) THEN $12::text ELSE $13 END AS checkoption, am.amname, (d.deptype = $14) IS TRUE AS is_identity_sequence, c.relispartition AS ispartition 
FROM pg_class c
LEFT JOIN pg_depend d ON (c.relkind = $15 AND d.classid = $16::regclass AND d.objid = c.oid AND d.objsubid = $17 AND d.refclassid = $18::regclass AND d.deptype IN ($19, $20))
LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace)
LEFT JOIN pg_am am ON (c.relam = am.oid)
LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = $21 AND c.relkind <> $22)
WHERE c.relkind IN ($23, $24, $25, $26, $27, $28, $29)
ORDER BY c.oid
0 min < 0.1% 49 ms 8 postgres 
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)
0 min < 0.1% 0 ms 22,831 postgres 
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) ORDER BY 1, 2, 3 /*pghero*/
0 min < 0.1% 0 ms 27,239 postgres 
SELECT format_type(seqtypid, $1), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = $2::oid
0 min < 0.1% 0 ms 22,881 postgres 
SELECT slot_name, database, active FROM pg_replication_slots /*pghero*/
0 min < 0.1% 0 ms 5,570 postgres 
-- cities
INSERT INTO impacto_city ( id, slug, code, created_by, name, country_id, state_id) VALUES ($1,uuid_generate_v4(),$2,$3,$4,$5, $6)
0 min < 0.1% 26 ms 8 postgres 
SELECT a.tableoid, a.oid, adrelid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc
FROM unnest($1::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_attrdef a ON (src.tbloid = a.adrelid)
ORDER BY a.adrelid, a.adnum
0 min < 0.1% 3 ms 58 postgres 
SELECT
  tbl.relname AS table_name,
  namespace.nspname as namespace,
  (tbl.relhassubclass and tbl.relkind = $2) as is_partition,
  (tbl.relhassubclass and tbl.relkind = $3) as has_subclass,
  tbl.relrowsecurity as has_row_level_security,
  reloptions,
  obj_description(tbl.oid, $4) as description
FROM pg_class AS tbl
INNER JOIN pg_namespace AS namespace ON namespace.oid = tbl.relnamespace
WHERE
  ( -- (relkind = 'r' and relispartition = 't') matches partition table "duplicates"
    (tbl.relkind = $5 AND tbl.relispartition = $6)
      OR -- when it's a partition
    tbl.relkind = $7
  )
  AND namespace.nspname = ANY ( $1 )
ORDER BY namespace, table_name
0 min < 0.1% 184 ms 1 postgres 
DROP DATABASE IF EXISTS "prisma_migrate_shadow_db_ae364a4f-c3e9-488f-a5ce-5db3e6161d3c" WITH (FORCE)
0 min < 0.1% 179 ms 1 postgres 
DROP DATABASE IF EXISTS "prisma_migrate_shadow_db_1ac5668d-d419-4c90-a0cb-22b9581e5586" WITH (FORCE)
0 min < 0.1% 0 ms 684 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, updated_at, url, http, body, header, params, browser, device, os, time, res_http, res_body, res_header, res_action, res_field, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19  RETURNING id
0 min < 0.1% 177 ms 1 postgres 
DROP DATABASE IF EXISTS "prisma_migrate_shadow_db_52269828-d772-41ba-85ed-a86c9f0ffeb2" WITH (FORCE)
0 min < 0.1% 49 ms 3 postgres 
SELECT
a.attrelid,
a.attnum,
a.attname,
a.atttypmod,
a.attstattarget,
a.attstorage,
t.typstorage,
a.attnotnull,
a.atthasdef,
a.attisdropped,
a.attlen,
a.attalign,
a.attislocal,
pg_catalog.format_type(t.oid, a.atttypmod) AS atttypname,
array_to_string(a.attoptions, $1) AS attoptions,
CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE $2 END AS attcollation,
pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || $3 || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), $4) AS attfdwoptions,
a.attcompression AS attcompression,
a.attidentity,
CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE $5 END AS attmissingval,
a.attgenerated
FROM unnest($6::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_attribute a ON (src.tbloid = a.attrelid) LEFT JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)
WHERE a.attnum > $7::pg_catalog.int2
ORDER BY a.attrelid, a.attnum
0 min < 0.1% 0 ms 23,562 postgres 
SET client_min_messages TO 'warning'
0 min < 0.1% 2 ms 58 postgres 
SELECT
                  sequence_name,
                  sequence_schema AS namespace,
                  start_value::INT8,
                  minimum_value::INT8 AS min_value,
                  maximum_value::INT8 AS max_value,
                  increment::INT8 AS increment_by,
                  (CASE cycle_option WHEN $2 THEN $3 ELSE $4 END) AS cycle,
                  $5::INT8 AS cache_size
              FROM information_schema.sequences
              WHERE sequence_schema = ANY ( $1 )
              ORDER BY sequence_name
0 min < 0.1% 0 ms 4,765 postgres 
PREPARE dumpFunc(pg_catalog.oid) AS
SELECT
proretset,
prosrc,
probin,
provolatile,
proisstrict,
prosecdef,
lanname,
proconfig,
procost,
prorows,
pg_catalog.pg_get_function_arguments(p.oid) AS funcargs,
pg_catalog.pg_get_function_identity_arguments(p.oid) AS funciargs,
pg_catalog.pg_get_function_result(p.oid) AS funcresult,
proleakproof,
array_to_string(protrftypes, $2) AS protrftypes,
proparallel,
prokind,
prosupport,
pg_get_function_sqlbody(p.oid) AS prosqlbody
FROM pg_catalog.pg_proc p, pg_catalog.pg_language l
WHERE p.oid = $1 AND l.oid = p.prolang
0 min < 0.1% 44 ms 3 postgres 
COPY dataset.first_name (id, name, corrected_name, sex) TO stdout
0 min < 0.1% 105 ms 1 postgres 
select c.oid,pg_catalog.pg_total_relation_size(c.oid) as total_rel_size,pg_catalog.pg_relation_size(c.oid) as rel_size
FROM pg_class c
WHERE c.relnamespace=$1
0 min < 0.1% 2 ms 58 postgres 
SELECT
    views.viewname AS view_name,
    views.definition AS view_sql,
    views.schemaname AS namespace,
    obj_description(class.oid, $2) AS description
FROM pg_catalog.pg_views views
INNER JOIN pg_catalog.pg_namespace ns ON views.schemaname = ns.nspname
INNER JOIN pg_catalog.pg_class class ON class.relnamespace = ns.oid AND class.relname = views.viewname
WHERE schemaname = ANY ( $1 )
0 min < 0.1% 2 ms 58 postgres 
SELECT p.proname AS name, n.nspname as namespace,
                CASE WHEN l.lanname = $2 THEN p.prosrc
                     ELSE pg_get_functiondef(p.oid)
                     END as definition
            FROM pg_proc p
            LEFT JOIN pg_namespace n ON p.pronamespace = n.oid
            LEFT JOIN pg_language l ON p.prolang = l.oid
            WHERE n.nspname = ANY ( $1 )
0 min < 0.1% 1 ms 58 postgres 
SELECT
                t.typname AS name,
                e.enumlabel AS value,
                n.nspname AS namespace,
                obj_description(t.oid, $2) AS description
            FROM pg_type t
            JOIN pg_enum e ON t.oid = e.enumtypid
            JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
            WHERE n.nspname = ANY ( $1 )
            ORDER BY e.enumsortorder
0 min < 0.1% 0 ms 1,019 postgres 
SELECT c.oid,c.*,t.relname as tabrelname,rt.relnamespace as refnamespace,d.description, case when c.contype=$2 then "substring"(pg_get_constraintdef(c.oid), $3) else $4 end consrc_copy
FROM pg_catalog.pg_constraint c
INNER JOIN pg_catalog.pg_class t ON t.oid=c.conrelid
LEFT OUTER JOIN pg_catalog.pg_class rt ON rt.oid=c.confrelid
LEFT OUTER JOIN pg_catalog.pg_description d ON d.objoid=c.oid AND d.objsubid=$5 AND d.classoid=$6::regclass
WHERE c.conrelid=$1
ORDER BY c.oid
0 min < 0.1% 0 ms 1,471 postgres 
SELECT app.id, app.name, app.slug, app.allowed_operations, app.white_label_id
FROM public.impacto_application app
 WHERE (app.key = $1 and app.status=$3 and ($2 = any (app.allowed_operations) OR $4 = any (app.allowed_operations)))
 ORDER BY 1 ASC NULLS LAST LIMIT $5 OFFSET $6
0 min < 0.1% 22 ms 3 postgres 
COPY api_test_schema.impacto_origin_person (id, slug, created_at, created_by, updated_at, updated_by, system_id, origin_id, import_id, import_unique_id, is_unified, origin_created_at, origin_updated_at, kind, name, social_name, sex, cpf_number, cnpj_number, cns_number, ctps_number, ctps_pis_number, cnh_number, cnh_category, cnh_valid_through, cnh_dispatched_at, cnh_note, rg_number, rg_dispatched_at, rg_dispatched_by, military_number, military_dispatched_at, voter_certificate_number, voter_certificate_zone, voter_certificate_section, voter_certificate_city, voter_certificate_state, voter_certificate_country, voter_certificate_dispatched_at, birth_certificate_date, birth_certificate_blood_type, birth_certificate_city, birth_certificate_state, birth_certificate_country, birth_certificate_twins, birth_certificate_twins_number, birth_certificate_born_alive_number, death_certificate_number, death_certificate_date, death_certificate_city, death_certificate_state, death_certificate_country, death_certificate_cause, death_certificate_description, mother_name, father_name, status, phone_1, phone_2, phone_3, phone_4, phone_5, phone_6, phone_7, email, profession, race, nationality, family_id, municipal_id, address_zip_code, address_street, address_number, address_reference, address_complement, address_neighbourhood, address_condominium, address_block, address_apartment, address_territory, address_city, address_state, address_country, institution_government_name, institution_health_name, institution_social_name, institution_school_name, corrected_origin_id, corrected_name, corrected_sex, corrected_cpf_number, corrected_cnpj_number, corrected_cns_number, corrected_ctps_number, corrected_ctps_pis_number, corrected_cnh_number, corrected_rg_number, corrected_military_number, corrected_voter_certificate_number, corrected_birth_certificate_date, corrected_death_certificate_date, corrected_mother_name, corrected_father_name, ethnicity, origin_created_by, origin_created_by_name, origin_updated_by, origin_updated_by_name) TO stdout
0 min < 0.1% 8 ms 8 postgres 
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid
0 min < 0.1% 64 ms 1 postgres 
CREATE DATABASE "prisma_migrate_shadow_db_1ac5668d-d419-4c90-a0cb-22b9581e5586"
0 min < 0.1% 0 ms 23,562 postgres 
SET standard_conforming_strings = on
0 min < 0.1% 8 ms 8 postgres 
SELECT c.tableoid, c.oid, conrelid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(c.oid) AS condef
FROM unnest($1::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_constraint c ON (src.tbloid = c.conrelid)
WHERE contype = $2 AND conparentid = $3 ORDER BY conrelid, conname
0 min < 0.1% 7 ms 8 postgres 
SELECT tableoid, oid, typname, typnamespace, typacl, acldefault($1, typowner) AS acldefault, typowner, typelem, typrelid, CASE WHEN typrelid = $2 THEN $3::"char" ELSE (SELECT relkind FROM pg_class WHERE oid = typrelid) END AS typrelkind, typtype, typisdefined, typname[$4] = $5 AND typelem != $6 AND (SELECT typarray FROM pg_type te WHERE oid = pg_type.typelem) = oid AS isarray FROM pg_type
0 min < 0.1% 54 ms 1 postgres 
CREATE DATABASE "prisma_migrate_shadow_db_ae364a4f-c3e9-488f-a5ce-5db3e6161d3c"
0 min < 0.1% 0 ms 23,562 postgres 
SET intervalstyle = iso_8601
0 min < 0.1% 0 ms 682 postgres 
SELECT count(*) over() as "_count"
FROM public.impacto_person_permission pp
LEFT JOIN public.impacto_group_member gm ON gm.group_id = pp.group_id
LEFT JOIN public.impacto_group g ON gm.group_id = g.id
 WHERE (pp.status = $2 AND (pp.expires_at is null OR pp.expires_at > now())
                AND (
                    (pp.scope = $3 AND pp.person_id = $1) 
                    OR 
                    (pp.scope = $4 AND gm.person_id = $1 AND g.status = $5 AND gm.status = $6)
                    )
                AND (pp.permission = $7 OR pp.permission = $8 OR pp.permission = $9) AND $10 < (SELECT COUNT(*) FROM public.impacto_bond_request br 
                WHERE br.status = $11 AND br.person_id = $1 AND br.is_public_agent = $12))
 ORDER BY 1 ASC NULLS LAST LIMIT $13 OFFSET $14
0 min < 0.1% 2 ms 27 postgres 
SELECT tbl.relname AS table_name
                FROM pg_class AS tbl
                INNER JOIN pg_namespace AS namespace ON namespace.oid = tbl.relnamespace
                WHERE tbl.relkind = $2 AND namespace.nspname = ANY ( $1 )
0 min < 0.1% 0 ms 26,592 postgres 
select $1[s],
        s operator(pg_catalog.-) pg_catalog.array_lower($1,$2) operator(pg_catalog.+) $3
        from pg_catalog.generate_series(pg_catalog.array_lower($1,$4),
                                        pg_catalog.array_upper($1,$5),
                                        $6) as g(s)
0 min < 0.1% 0 ms 141 postgres 
SELECT "id", "checksum", "finished_at", "migration_name", "logs", "rolled_back_at", "started_at", "applied_steps_count" FROM "_prisma_migrations" ORDER BY "started_at" ASC
0 min < 0.1% 5 ms 8 postgres 
SELECT DISTINCT attrelid FROM pg_attribute WHERE attacl IS NOT NULL
0 min < 0.1% 0 ms 4,743 postgres 
PREPARE dumpEnumType(pg_catalog.oid) AS
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = $1 ORDER BY enumsortorder
0 min < 0.1% 4 ms 8 postgres 
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault($1, p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = $2::regclass AND pip.objsubid = $3) WHERE p.prokind <> $4
  AND NOT EXISTS (SELECT $5 FROM pg_depend WHERE classid = $6::regclass AND objid = p.oid AND deptype = $7)
  AND (
  pronamespace != (SELECT oid FROM pg_namespace WHERE nspname = $8)
  OR EXISTS (SELECT $9 FROM pg_cast
  WHERE pg_cast.oid > $10 
  AND p.oid = pg_cast.castfunc)
  OR EXISTS (SELECT $11 FROM pg_transform
  WHERE pg_transform.oid > $12 AND 
  (p.oid = pg_transform.trffromsql
  OR p.oid = pg_transform.trftosql))
  OR p.proacl IS DISTINCT FROM pip.initprivs)
0 min < 0.1% 1 ms 40 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, created_by, updated_at, updated_by, url, http, authentication, application, body, header, params, browser, device, os, useragent, time, res_http, res_body, res_header, res_action, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23  RETURNING id
0 min < 0.1% 0 ms 686 postgres 
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
0 min < 0.1% 1 ms 36 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, updated_at, url, http, authentication, application, body, header, params, browser, device, os, useragent, time, res_http, res_body, res_header, res_action, res_field, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22  RETURNING id
0 min < 0.1% 2 ms 15 postgres 
INSERT INTO public.impacto_process_signature (slug, created_at, created_by, process_id, person_id, kind, format, token) SELECT $1, $2, $3, $4, $5, $6, $7, $8  RETURNING *
0 min < 0.1% 0 ms 58 postgres 
SELECT
    schemainfo.nspname AS namespace,
    tableinfo.relname AS table_name,
	constr.conname AS constraint_name,
	constr.contype AS constraint_type,
	pg_get_constraintdef(constr.oid) AS constraint_definition,
	constr.condeferrable AS is_deferrable,
	constr.condeferred AS is_deferred
FROM pg_constraint constr
JOIN pg_class AS tableinfo
	ON tableinfo.oid = constr.conrelid
JOIN pg_namespace AS schemainfo
	ON schemainfo.oid = tableinfo.relnamespace
WHERE schemainfo.nspname = ANY ( $1 )
	AND contype NOT IN ($2, $3, $4)
ORDER BY namespace, table_name, constr.contype, constraint_name
0 min < 0.1% 3 ms 8 postgres 
SELECT c.oid,c.*,d.description,pg_catalog.pg_get_expr(c.relpartbound, c.oid) as partition_expr,  pg_catalog.pg_get_partkeydef(c.oid) as partition_key 
FROM pg_catalog.pg_class c
LEFT OUTER JOIN pg_catalog.pg_description d ON d.objoid=c.oid AND d.objsubid=$2 AND d.classoid=$3::regclass
WHERE c.relnamespace=$1 AND c.relkind not in ($4,$5,$6)
0 min < 0.1% 4 ms 5 postgres 
INSERT INTO public.impacto_unified_person_notification (slug, unified_person_id, kind, title, description) SELECT $1, ((SELECT unified_person_id FROM public.impacto_person p where p.id = $5)), $2, $3, $4  RETURNING id, slug
0 min < 0.1% 2 ms 8 postgres 
select string_agg(word, $1) from pg_catalog.pg_get_keywords() where word <> ALL ($2::text[])
0 min < 0.1% 0 ms 5,597 postgres 
SELECT $2 FROM ONLY "public"."impacto_country" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
0 min < 0.1% 2 ms 8 postgres 
SELECT t.tgrelid, t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, $1) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal as tgispartition
FROM unnest($2::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_trigger t ON (src.tbloid = t.tgrelid) LEFT JOIN pg_catalog.pg_trigger u ON (u.oid = t.tgparentid) WHERE (NOT t.tgisinternal OR t.tgenabled != u.tgenabled) ORDER BY t.tgrelid, t.tgname
0 min < 0.1% 5 ms 3 postgres 
COPY api_test_schema.impacto_person_permission (id, slug, created_at, created_by, updated_at, updated_by, status, expires_at, scope, group_id, person_id, permission) TO stdout
0 min < 0.1% 2 ms 8 postgres 
WITH RECURSIVE w AS ( SELECT d1.objid, d2.refobjid, c2.relkind AS refrelkind FROM pg_depend d1 JOIN pg_class c1 ON c1.oid = d1.objid AND c1.relkind = $1 JOIN pg_rewrite r1 ON r1.ev_class = d1.objid JOIN pg_depend d2 ON d2.classid = $2::regclass AND d2.objid = r1.oid AND d2.refobjid <> d1.objid JOIN pg_class c2 ON c2.oid = d2.refobjid AND c2.relkind IN ($3,$4) WHERE d1.classid = $5::regclass UNION SELECT w.objid, d3.refobjid, c3.relkind FROM w JOIN pg_rewrite r3 ON r3.ev_class = w.refobjid JOIN pg_depend d3 ON d3.classid = $6::regclass AND d3.objid = r3.oid AND d3.refobjid <> w.refobjid JOIN pg_class c3 ON c3.oid = d3.refobjid AND c3.relkind IN ($7,$8) ) SELECT $9::regclass::oid AS classid, objid, refobjid FROM w WHERE refrelkind = $10
0 min < 0.1% 0 ms 653 postgres 
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
0 min < 0.1% 2 ms 5 postgres 
INSERT INTO public.impacto_process_signature (slug, created_at, created_by, process_id, person_id, kind, format, token) SELECT $1, $2, $3, $4, $5, $6, $7, $8 WHERE $9 = (
                            SELECT 
                                count(*)
                            FROM 
                                public.impacto_process_signature _ps 
                            WHERE 
                                _ps.process_id = $10
                                AND _ps.person_id = $11
                                AND _ps.status = $12) RETURNING id, slug, process_id
0 min < 0.1% 1 ms 8 postgres 
INSERT INTO public.impacto_review_answer (slug, created_at, created_by, description, place_id, sub_place_id, review_id, unified_person_id, version) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9  RETURNING id, slug, created_at, status, parent_origin_activity_id, place_id, sub_place_id, review_id, unified_person_id, version
0 min < 0.1% 0 ms 5,570 postgres 
SELECT $2 FROM ONLY "public"."impacto_state" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
0 min < 0.1% 4 ms 2 postgres 
INSERT INTO public.impacto_attendance (slug, created_at, created_by, description, is_priority, classification, place_id, unified_person_id) SELECT $1, $2, $3, $4, $5, $6, $7, $8  RETURNING id, slug, created_at, status, is_priority, classification, description, place_id, unified_person_id, origin_activity_id, schedule_planning_slot_booking_id
0 min < 0.1% 3 ms 3 postgres 
COPY microservice_test_schema.impacto_external_request (id, created_at, created_by, updated_at, updated_by, url, http_method, body, headers, res_http_code, res_body, res_headers) TO stdout
0 min < 0.1% 1 ms 7 postgres 
INSERT INTO public.impacto_request_log (slug, created_at, updated_at, url, http, application, body, header, params, browser, device, os, useragent, time, res_http, res_body, res_header, res_action, res_field, res_code, res_success) SELECT $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21  RETURNING id
0 min < 0.1% 2 ms 5 postgres 
SELECT ra.id, ra.slug, ra.created_at, ra.updated_at, ra.status, ra.description, ra.version, count(*) over() as "_count", (
                            SELECT 
                                SUM(_fa.score) AS total_score
                            FROM 
                                public.impacto_form_answer _fa
                            JOIN
                                public.impacto_form _f ON _f.status = $2 AND _f.id = _fa.form_id 
                            JOIN
                                public.impacto_form_question _fq ON _fq.status = $3 AND _fq.id = _fa.form_question_id
                            WHERE 
                                _fa.status = $4
                                AND _fa.review_answer_id = ra.id
                        ) as "total_score", r.id as "review_id", r.created_at as "review_created_at", r.updated_at as "review_updated_at", r.slug as "review_slug", r.status as "review_status", r.name as "review_name", r.short_name as "review_short_name", r.description as "review_description", r.filling_allowed_for as "review_filling_allowed_for", r.version as "review_version", r.previous_review_id as "review_previous_review_id", up.id as "unified_person_id", up.slug as "unified_person_slug", up.impacto_id as "unified_person_impacto_id", up.created_at as "unified_person_created_at", up.kind as "unified_person_kind", up.status as "unified_person_status", up.name as "unified_person_name", up.social_name as "unified_person_social_name", up.sex as "unified_person_sex", up.cpf_number as "unified_person_cpf_number", up.cnpj_number as "unified_person_cnpj_number", up.cns_number as "unified_person_cns_number", up.ctps_pis_number as "unified_person_ctps_pis_number", up.birth_certificate_date as "unified_person_birth_certificate_date", up.death_certificate_date as "unified_person_death_certificate_date", up.mother_name as "unified_person_mother_name", f.id as "form_id", f.slug as "form_slug", f.created_at as "form_created_at", f.updated_at as "form_updated_at", f.status as "form_status", f.name as "form_name", f.description as "form_description", f.has_score as "form_has_score", f.has_classification as "form_has_classification", f.score_settings as "form_score_settings", (
                                SELECT
                                    json_agg(
                                        json_build_object(
                                            $5, _fq.id,
                                            $6, _fq.slug,
                                            $7, _fq.created_at,
                                            $8, _fq.updated_at,
                                            $9, _fq.title,
                                            $10, (
                                                SELECT 
                                                    _fa.value
                                                FROM 
                                                    public.impacto_form_answer _fa
                                                WHERE 
                                                    _fa.status = $11
                                                    AND _fa.form_id = f.id 
                                                    AND _fa.form_question_id = _fq.id 
                                                    AND _fa.review_answer_id = ra.id
                                                    AND _fq.version = ra.version
                                            ),
                                            $12, (
                                                SELECT 
                                                    _fa.is_file
                                                FROM 
                                                    public.impacto_form_answer _fa
                                                WHERE 
                                                    _fa.status = $13
                                                    AND _fa.form_id = f.id 
                                                    AND _fa.form_question_id = _fq.id 
                                                    AND _fa.review_answer_id = ra.id
                                                    AND _fq.version = ra.version
                                            ),
                                            $14, _fq.description,
                                            $15, _fq.kind,
                                            $16, _fq.has_score,
                                            $17, _fq.score_settings,
                                            $18, _fq.options,
                                            $19, _fq.validation_start_value,
                                            $20, _fq.validation_end_value,
                                            $21, _fq.validation_exact_value,
                                            $22, _fq.regex,
                                            $23, _fq.is_required,
                                            $24, _fq.validation_kind,
                                            $25, _fq.validation_condition,
                                            $26, _fq.validation_message,
                                            $27, _fq.version,
                                            $28, _fq.parent_form_question_id
                                        )
                                        ORDER BY _fq.id
                                    )
                                FROM 
                                    public.impacto_form_question _fq
                                LEFT JOIN
                                    public.impacto_form_answer _fa 
                                    ON _fa.form_question_id = _fq.id
                                    AND _fa.status = $29
                                    AND _fa.form_id = f.id
                                    AND _fa.review_answer_id = ra.id
                                    AND _fq.version = ra.version
                                WHERE 
                                    _fq.status in ($30, $31)
                                    AND _fq.form_id = f.id
                                    AND _fq.version = ra.version
                                ) as "form_questions", (
                                SELECT
                                    json_agg(
                                        json_build_object(
                                            $32, _af.id,
                                            $33, _af.slug,
                                            $34, _af.name,
                                            $35, _af.archive_id,
                                            $36, _af.original_name,
                                            $37, _af.extension,
                                            $38, _af.size
                                        )
                                        ORDER BY _af.id
                                    )
                                FROM 
                                    public.impacto_archive_file _af
                                LEFT JOIN
                                    public.impacto_form_answer_file _faf on _faf.archive_file_id = _af.id
                                LEFT JOIN
                                    public.impacto_form_answer _fa on _fa.id = _faf.form_answer_id
                                LEFT JOIN
                                    public.impacto_form_question _fq on _fq.id = _fa.form_question_id
                                WHERE 
                                    _fq.form_id = f.id
                                    AND _fq.version = ra.version
                                ) as "form_archive_file"
FROM public.impacto_review_answer ra
LEFT JOIN public.impacto_review r ON r.status = $39 AND r.id = ra.review_id
LEFT JOIN public.impacto_unified_person up ON up.id = ra.unified_person_id
LEFT JOIN public.impacto_form f ON f.id = r.form_id
 WHERE ((ra.status=$40) AND ra.review_id = $1)
 ORDER BY id DESC NULLS LAST LIMIT $41 OFFSET $42
0 min < 0.1% 2 ms 3 postgres 
COPY microservice_test_schema.impacto_public_file (id, slug, created_at, created_by, updated_at, updated_by, name, original_name, status, description, url, size, extension, bucket_host, bucket_name) TO stdout
0 min < 0.1% 2 ms 3 postgres 
COPY microservice_test_schema.impacto_terms_and_conditions (id, slug, created_at, created_by, updated_at, updated_by, name, status, description, version, kind) TO stdout