Queries

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*/

WITH query_stats AS ( SELECT LEFT(query, 10000) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / 1000 / 60) 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 > 0 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * 100.0 / (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 100 /*pghero*/

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*/

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

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

COPY dataset.surname (id, name, corrected_name) TO stdout

COPY dataset.name (id, full_name, sex) TO stdout

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_

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

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*/

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*/

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

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

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)

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 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, $125, $126, $127)

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*/

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)

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

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

SELECT n.nspname AS schema, c.relname AS relation, CASE c.relkind WHEN $1 THEN $2 WHEN $3 then $4 ELSE $5 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($6, $7) AND n.nspname !~ $8 AND c.relkind IN ($9, $10, $11) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

SET SESSION timezone TO 'UTC'

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, $125, $126, $127, $128)

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*/

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)

SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*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 table_name FROM information_schema.tables WHERE table_schema = $1

SELECT schemaname AS schema, relname AS table, indexrelname AS index, pg_relation_size(i.indexrelid) AS size_bytes, idx_scan as index_scans FROM pg_stat_user_indexes ui INNER JOIN pg_index i ON ui.indexrelid = i.indexrelid WHERE NOT indisunique AND idx_scan <= $1 ORDER BY pg_relation_size(i.indexrelid) DESC, relname ASC /*pghero*/

DROP DATABASE IF EXISTS "prisma_migrate_shadow_db_74fe9723-de6d-41a7-90da-95e8d9b73bc9"

DROP DATABASE IF EXISTS "prisma_migrate_shadow_db_431dbfc1-0dba-47d1-ab0b-4fd4a04207fd"

COPY dataset.first_name (id, name, corrected_name, sex) TO stdout

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

SELECT pg_database_size(current_database()) /*pghero*/

SELECT migration_name FROM _prisma_migrations ORDER BY finished_at DESC LIMIT $1

SELECT count(*) FROM _prisma_migrations WHERE finished_at IS NOT NULL

SELECT finished_at FROM _prisma_migrations ORDER BY finished_at DESC LIMIT $1

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

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 )

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)

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

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

SELECT schemaname AS schema, relname AS table, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, n_dead_tup AS dead_rows, n_live_tup AS live_rows FROM pg_stat_user_tables ORDER BY 1, 2 /*pghero*/

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*/

SELECT slot_name, database, active FROM pg_replication_slots /*pghero*/

SELECT count(*) FROM _prisma_migrations WHERE finished_at IS NULL

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*/

SELECT format_type(seqtypid, $1), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = $2::oid

CREATE DATABASE "prisma_migrate_shadow_db_431dbfc1-0dba-47d1-ab0b-4fd4a04207fd"

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

SET client_min_messages TO 'warning'

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

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

SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid

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

SELECT "id", "checksum", "finished_at", "migration_name", "logs", "rolled_back_at", "started_at", "applied_steps_count" FROM "_prisma_migrations" ORDER BY "started_at" ASC

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

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

SELECT DISTINCT attrelid FROM pg_attribute WHERE attacl IS NOT NULL

SET standard_conforming_strings = on

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)

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

SET intervalstyle = iso_8601

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() ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/

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

PREPARE dumpEnumType(pg_catalog.oid) AS
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = $1 ORDER BY enumsortorder

SELECT pg_terminate_backend($1) /*pghero*/

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

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

COPY microservice_test_schema.impacto_sent_communication (id, slug, created_at, created_by, method, kind, subject, body, recipients, report, sender) TO stdout

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

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND query <> $1 AND datname = current_database() /*pghero*/

COPY public.impacto_document_draft (id, slug, created_at, created_by, updated_at, updated_by, status, name, description, subject, header, footer, body, url, kind, format, attachments, icon, color, category, person_id) TO stdout

COPY public.impacto_form_answer (id, slug, created_at, created_by, updated_at, updated_by, status, form_id, form_question_id, origin_activity_id, service_request_id, value, review_answer_id, score, is_file, nps_answer_by_area_id, survey_answer_id, version, process_id) TO stdout

COPY microservice_test_schema.impacto_authentication_token (id, created_at, updated_at, last_used_at, created_ip, last_used_ip, status, jwt_token, jwt_secret, keep, person_id) TO stdout

COPY microservice_test_schema.impacto_private_file (id, slug, created_at, created_by, updated_at, updated_by, name, original_name, extension, status, description, url, size, bucket_host, bucket_name) TO stdout

COPY microservice_test_schema.impacto_feedback (id, slug, created_at, updated_at, updated_by, http, message, description, success, action_field, usage_count) TO stdout

EXPLAIN (FORMAT TEXT) SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]*\((.*)\)$', '\1') AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]*) \(.*', '\1') 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*/ /*pghero*/

SELECT tableoid, oid, oprname, oprnamespace, oprowner, oprkind, oprcode::oid AS oprcode FROM pg_operator

SELECT set_config(name, $1, $2) FROM pg_settings WHERE name = $3

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", "device_name", "device_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)

SELECT tableoid, oid, collname, collnamespace, collowner FROM pg_collation

SET search_path = "public"

SELECT EXISTS(SELECT $2 FROM pg_namespace WHERE nspname = $1), version(), current_setting($3)::integer as numeric_version

COPY dataset.result_name (id, name) TO stdout

SELECT pid, phase FROM pg_stat_progress_vacuum WHERE datname = current_database() /*pghero*/

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", "device_name", "device_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, $22, $23, NULLIF($24, $25)::json, NULLIF($26,$27)::numeric, $28, NULLIF($29, $30)::json, $31, $32)

COPY api_test_schema.impacto_bond_request (id, slug, created_at, created_by, updated_at, updated_by, resolved_at, resolved_by, status, internal_id, description, is_citizen, is_public_agent, person_id, person_slug, person_name, person_mother_name, person_father_name, person_cpf_number, person_ctps_pis_number, person_cns_number, person_rg_number, person_birth_certificate_date, person_birth_certificate_city, person_birth_certificate_state, person_birth_certificate_country, person_sex, person_document_name, person_document_number, person_document_file_id, person_document_file_slug, person_document_selfie_id, person_document_selfie_slug, person_main_avatar_variations, person_main_phone_contact_id, person_main_phone_contact_type, person_main_phone_contact_value, person_main_phone_contact_is_verified, person_main_mail_contact_id, person_main_mail_contact_type, person_main_mail_contact_value, person_main_mail_contact_is_verified, person_main_avatar_id, person_main_avatar_url, person_main_avatar_name, person_main_avatar_size, person_main_avatar_extension) TO stdout

SET LOCAL statement_timeout = 10000 /*pghero*/

SELECT p.tableoid, p.oid, p.proname AS aggname, p.pronamespace AS aggnamespace, p.pronargs, p.proargtypes, p.proowner, p.proacl AS aggacl, acldefault($1, p.proowner) AS acldefault 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 (p.pronamespace != (SELECT oid FROM pg_namespace WHERE nspname = $5) OR p.proacl IS DISTINCT FROM pip.initprivs)

COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) TO stdout

COPY public.impacto_archive_file (id, slug, created_at, created_by, updated_at, updated_by, status, name, description, privacy, archive_id, parent_directory_id, original_name, extension, url, size, icon, color, category, info_1, info_2, info_3, info_4, info_5, info_6, info_7, impacto_id, impacto_slug) TO stdout

COPY microservice_test_schema.impacto_person (id, slug, created_at, registered_at, updated_at, kind, name, social_name, sex, cpf_number, cnpj_number, mother_name, father_name, birth_certificate_date, status, login, password, main_phone_contact_id, main_mail_contact_id, main_avatar_id, white_label_id, birth_certificate_blood_type, birth_certificate_born_alive_number, birth_certificate_city, birth_certificate_country, birth_certificate_state, birth_certificate_twins, birth_certificate_twins_number, cnh_category, cnh_dispatched_at, cnh_note, cnh_number, cnh_valid_through, cns_number, ctps_number, ctps_pis_number, rg_dispatched_at, rg_dispatched_by, rg_number, voter_certificate_city, voter_certificate_country, voter_certificate_dispatched_at, voter_certificate_number, voter_certificate_section, voter_certificate_state, voter_certificate_zone, military_dispatched_at, military_number, birth_certificate_file_id, birth_certificate_selfie_id, cnh_file_id, cnh_selfie_id, cnpj_file_id, cnpj_selfie_id, cns_file_id, cns_selfie_id, cpf_file_id, cpf_selfie_id, ctps_file_id, ctps_selfie_id, military_file_id, military_selfie_id, rg_file_id, rg_selfie_id, voter_certificate_file_id, voter_certificate_selfie_id) TO stdout

COPY api_test_schema.impacto_contact (id, slug, created_at, created_by, updated_at, updated_by, status, type, name, value, is_verified, place_id, unified_person_id, origin_person_id) TO stdout

SELECT pg_stat_activity.pid, datname AS database, usename AS user, application_name AS source, client_addr AS ip, state, ssl FROM pg_stat_activity LEFT JOIN pg_stat_ssl ON pg_stat_activity.pid = pg_stat_ssl.pid ORDER BY pg_stat_activity.pid /*pghero*/

COPY public.impacto_origin_activity (id, slug, created_at, created_by, updated_at, updated_by, system_id, activity_type_id, origin_id, import_id, import_unique_id, origin_created_at, origin_updated_at, status, origin, competence, executed_at, parent_id, place_id, service_id, unified_person_id, origin_person_id, professional_id, info_1, info_2, info_3, info_4, info_5, info_6, info_7, origin_parent_id, origin_competence, origin_place_id, origin_place_name, origin_professional_id, origin_professional_name, origin_person_origin_id, origin_person_kind, origin_person_name, origin_person_cpf_number, origin_person_cnpj_number, origin_person_rg_number, origin_person_cns_number, origin_person_birth_certificate_date, origin_person_mother_name, origin_person_father_name, origin_person_ctps_pis_number, code, sub_place_id, ciap, cid, sus, tuss, is_admin_record, info_10, info_11, info_12, info_13, info_14, info_15, info_16, info_17, info_18, info_19, info_20, info_21, info_22, info_23, info_24, info_25, info_26, info_27, info_28, info_29, info_30, info_8, info_9, origin_is_deleted, origin_is_deleted_checked_at, signed_file_id, attendance_group_slug, version, family_id) TO stdout

SELECT conrelid, confrelid FROM pg_constraint JOIN pg_depend ON (objid = confrelid) WHERE contype = $1 AND refclassid = $2::regclass AND classid = $3::regclass

COPY api_test_schema.impacto_alert_follow_up (id, slug, created_at, created_by, updated_at, updated_by, status, name, action, description, alert_id, parent_id, old_alert_responsable_person_id, new_alert_responsable_person_id, old_alert_responsable_group_id, new_alert_responsable_group_id, old_alert_status, new_alert_status) TO stdout

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