Queries

SELECT invoices.method_id, methods.method_name, invoices.system_id FROM invoices JOIN methods ON methods.id = invoices.method_id WHERE invoices.project_id = $1 AND ext_user_id = $2 AND is_finished = $3 AND is_success = $4 ORDER by created_at DESC

SELECT methods.id, method_name, count(*)
  FROM invoices
  JOIN methods ON invoices.method_id = methods.id
  WHERE created_at > NOW() - $2::interval AND invoices.project_id = $1
  GROUP by methods.id, method_name
  ORDER by count(*) DESC
  limit $3

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

SELECT * FROM invoices WHERE is_finished = $1 AND is_success is null

SELECT * FROM payout_invoices WHERE is_sended_to_project = $1 and is_finished = $2

SELECT
    methods.*,
    systems.name as system_name
  FROM methods
  JOIN systems ON systems.id = methods.system_id
  WHERE
    project_id = $1 AND
    methods.is_enabled = $2 AND
    systems.is_enabled = $3
  ORDER by priority_number DESC

SELECT * FROM methods WHERE system_id = $1

SELECT * FROM payout_invoices WHERE is_sended_to_ps = $1

SELECT systems.name,
  date((created_at) AT TIME ZONE $2) as date,
  SUM(amount/$3) as raw_amount,
  SUM(recieved_amount) as amount,
  currency.title as currency
  FROM invoices
  JOIN systems ON systems.id = invoices.system_id
  JOIN currency on currency.id = recieved_currency
  WHERE project_id = $1 AND is_finished = $4
  GROUP by systems.name, date((created_at) AT TIME ZONE 'Europe/Moscow'), currency.title
  ORDER by date((created_at) AT TIME ZONE 'Europe/Moscow') DESC

SELECT
    methods.method_name
  FROM methods
  JOIN systems ON systems.id = methods.system_id
  WHERE
    project_id = $1 AND
    methods.is_enabled = $2 AND
    systems.is_enabled = $3
  
  GROUP by methods.method_name
  ORDER by method_name

INSERT INTO error_log(source, msg) VALUES($1, $2)

SELECT * FROM invoices WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT * FROM systems WHERE id = $1

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_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/

SELECT * FROM paycodes WHERE is_used = $1 AND is_finished = $2

SELECT
    methods.method_name as name,
    currency.title, invoices.currency_id,
    date(created_at AT TIME ZONE $2) as date,
    COUNT(*),
    SUM(invoices.recieved_amount),
    SUM(amount) as amount,
    (
      SELECT
        COUNT(*)
      FROM invoices i
      WHERE
        date((created_at) AT TIME ZONE $3) = date(NOW() AT TIME ZONE $4) AND 
        is_finished = $5 AND
        i.method_id = methods.id AND
        i.currency_id = invoices.currency_id
    ) as not_success,
    (
      SELECT
        COUNT(*)
      FROM invoices i
      WHERE
        date((created_at) AT TIME ZONE $6) = date(NOW() AT TIME ZONE $7) AND 
        is_finished = $8 AND
        i.method_id = methods.id AND
        i.currency_id = invoices.currency_id
    ) as success
  FROM invoices
  JOIN methods ON methods.id = invoices.method_id
  JOIN currency ON invoices.recieved_currency = currency.id
  JOIN systems ON systems.id = invoices.system_id
  WHERE invoices.project_id = $1 AND date((created_at) AT TIME ZONE $9) = date(NOW() AT TIME ZONE $10)
  GROUP by
    methods.id, methods.method_name,
    currency.title, invoices.currency_id,
    date((created_at) AT TIME ZONE 'Europe/Moscow')
  ORDER by date((created_at) AT TIME ZONE 'Europe/Moscow') DESC, SUM(amount) DESC

SELECT * FROM methods WHERE id = $1

SELECT * FROM payout_systems WHERE id = $1

SELECT * FROM currency

INSERT INTO invoices (project_id, method_id, system_id, amount, wallet, ext_id, ext_user_id, ext_redirect_success, ext_redirect_fail, currency_id, ext_user_email, ext_lang, ext_user_login, convert_currency_id)
        VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
        RETURNING *

SELECT * FROM methods WHERE is_enabled = $1 AND (SELECT is_enabled FROM systems sys WHERE sys.id = system_id) = $2 ORDER by priority_number DESC

SELECT * FROM payout_methods WHERE system_id = $1

SELECT * FROM currency WHERE id = $1

SELECT * FROM projects WHERE id = $1

SELECT *,
  (SELECT COUNT(*) FROM invoices WHERE invoices.project_id = projects.id AND is_finished = $1) as num
  FROM projects

SELECT "id", "source", "msg", "created_at" FROM "public"."error_log"  ORDER BY "id" DESC, "id" DESC  LIMIT $1

COPY public.error_log (id, source, msg, created_at) 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)
  OR t.typtype IN ($41, $42, $43)
  OR t.typinput = $44::regprocedure
  OR t.typelem != $45

SELECT icon_url FROM methods WHERE id = $1

SELECT * FROM invoices WHERE system_id = $2 AND id = $1 AND is_finished = $3

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

Row estimates
- id (=): 1
- system_id (=): 20424
- is_finished (=): 81698

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

UPDATE invoices SET is_success = $2 WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

UPDATE invoices
        SET recieved_amount = $2, recieved_currency = $3
        WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT * FROM payout_methods WHERE is_enabled = $1 AND (SELECT is_enabled FROM payout_systems ps WHERE ps.id = system_id) = $2 ORDER by priority_number DESC

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

SELECT * FROM projects WHERE id = $1 AND is_enabled = $2

SELECT * FROM currency WHERE title = $1

EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) SELECT routines.routine_name, parameters.data_type, parameters.ordinal_position FROM information_schema.routines LEFT JOIN information_schema.parameters ON routines.specific_name=parameters.specific_name WHERE routines.specific_schema='my_specified_schema_name' ORDER BY routines.routine_name, parameters.ordinal_position

SET LOCAL statement_timeout = 10000 /*pghero*/

UPDATE invoices
        SET is_finished = $6, ps_id = $1, finished_at = NOW(), callback_data = $2, order_info = $4, callback_from_ip = $5
        WHERE id = $3

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT
  methods.*, (SELECT COUNT(*) FROM invoices WHERE method_id = methods.id AND is_finished = $3) as num,
  (SELECT COUNT(*) FROM invoices WHERE method_id = methods.id AND is_finished = $4 AND created_at > NOW() - $5::interval) as num_today
  FROM methods WHERE system_id = $1 AND project_id = $2 ORDER by id

SELECT payout_systems.title,
  date((created_at) AT TIME ZONE $2) as date,
  SUM(amount/$3) as raw_amount,
  SUM(spent_amount) as amount,
  currency.title as currency
  FROM payout_invoices
  JOIN payout_systems ON payout_systems.id = payout_invoices.system_id
  JOIN currency on currency.id = spent_currency_id
  WHERE project_id = $1 AND is_finished = $4 AND is_success = $5 AND payout_invoices.is_internal = $6
  GROUP by payout_systems.title, date((created_at) AT TIME ZONE 'Europe/Moscow'), currency.title
  ORDER by date((created_at) AT TIME ZONE 'Europe/Moscow') DESC

UPDATE invoices SET ps_create_response = $1 WHERE id = $2

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

UPDATE invoices SET ps_create_request = $1 WHERE id = $2

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

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

SET SESSION timezone TO 'UTC'

SELECT $1

INSERT INTO payout_invoices
        (
            project_id,
            method_id,
            system_id,
            amount,
            wallet,
            ext_id, ext_user_id, ext_user_email, ext_user_ip,
            currency_id,
            is_internal
        )
        VALUES (
            $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11
        )
        RETURNING *

SELECT name, setting FROM pg_settings WHERE source = $1

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_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 "calls" DESC LIMIT $6 /*pghero*/

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

SELECT $2 FROM ONLY "public"."projects" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

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 COUNT($1) FROM "public"."error_log"

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_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 "average_time" DESC LIMIT $6 /*pghero*/

SELECT $2 FROM ONLY "public"."methods" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

SET TIME ZONE INTERVAL '+00:00' HOUR TO MINUTE

UPDATE invoices
        SET wallet = $2
        WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT * FROM payout_methods WHERE id = $1

SELECT $2 FROM ONLY "public"."currency" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

SELECT c.tableoid, c.oid, c.relname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(c.relacl,pg_catalog.acldefault(CASE WHEN c.relkind = $1 THEN $2 ELSE $3 END::"char",c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $4 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault(CASE WHEN c.relkind = $5 THEN $6 ELSE $7 END::"char",c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS relacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault(CASE WHEN c.relkind = $8 THEN $9 ELSE $10 END::"char",c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $11 FROM pg_catalog.unnest(coalesce(c.relacl,pg_catalog.acldefault(CASE WHEN c.relkind = $12 THEN $13 ELSE $14 END::"char",c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, $15 AS initrelacl, $16 as initrrelacl, c.relkind, c.relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = c.relowner) AS rolname, c.relchecks, c.relhastriggers, c.relhasindex, c.relhasrules, $17::bool AS relhasoids, c.relrowsecurity, c.relforcerowsecurity, c.relfrozenxid, c.relminmxid, tc.oid AS toid, tc.relfrozenxid AS tfrozenxid, tc.relminmxid AS tminmxid, c.relpersistence, c.relispopulated, c.relreplident, c.relpages, am.amname, CASE WHEN c.relkind = $18 THEN (SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE $19 END AS foreignserver, CASE WHEN c.reloftype <> $20 THEN c.reloftype::pg_catalog.regtype ELSE $21 END AS reloftype, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace, array_remove(array_remove(c.reloptions,$22),$23) AS reloptions, CASE WHEN $24 = ANY (c.reloptions) THEN $25::text WHEN $26 = ANY (c.reloptions) THEN $27::text ELSE $28 END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = $29 AND EXISTS (SELECT $30 FROM pg_depend WHERE classid = $31::regclass AND objid = c.oid AND objsubid = $32 AND refclassid = $33::regclass AND deptype = $34) AS is_identity_sequence, EXISTS (SELECT $35 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = $36::regclass AND pip.objsubid = at.attnum)WHERE at.attrelid = c.oid AND ((SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($37,c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $38 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($39,c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($40,c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $41 FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($42,c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR $43 IS NOT NULL OR $44 IS NOT NULL))AS changed_acl, pg_get_partkeydef(c.oid) AS partkeydef, c.relispartition AS ispartition, pg_get_expr(c.relpartbound, c.oid) AS partbound FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = $45 AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = $46 AND d.refclassid = c.tableoid AND d.deptype IN ($47, $48)) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> $49) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = $50::regclass AND pip.objsubid = $51) WHERE c.relkind in ($52, $53, $54, $55, $56, $57, $58) ORDER BY c.oid

SELECT * FROM systems WHERE is_enabled = $1

UPDATE currency SET convert_rate = $1, updated_at = NOW() WHERE title = $2

SELECT $2 FROM ONLY "public"."systems" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x

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

UPDATE invoices
        SET is_finished = $6, ps_id = $1, finished_at = NOW(), callback_data = $2, order_info = $4, amount = $5
        WHERE id = $3

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT * FROM payout_systems WHERE is_enabled = $1

SELECT last_value FROM "public"."projects_id_seq" UNION ALL SELECT last_value FROM "public"."systems_id_seq" UNION ALL SELECT last_value FROM "public"."methods_id_seq" UNION ALL SELECT last_value FROM "public"."country_seq" UNION ALL SELECT last_value FROM "public"."error_log_id_seq" UNION ALL SELECT last_value FROM "public"."currency_id_seq" UNION ALL SELECT last_value FROM "public"."payout_systems_id_seq" UNION ALL SELECT last_value FROM "public"."payout_methods_id_seq" UNION ALL SELECT last_value FROM "public"."paycodes_id_seq" UNION ALL SELECT last_value FROM "public"."internal_invoices_id_seq" UNION ALL SELECT last_value FROM "public"."systems_balance_id_seq" /*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*/

SELECT n.nspname AS schema, c.relname AS relation, CASE WHEN c.relkind = $1 THEN $2 ELSE $3 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 ($4, $5) AND n.nspname !~ $6 AND c.relkind IN ($7, $8) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

SELECT pi.*, pm.method_name, ps.title as ps_title
  FROM payout_invoices pi
  JOIN payout_systems ps ON ps.id = pi.system_id
  JOIN payout_methods pm ON pm.id = pi.method_id
  WHERE pi.project_id = $1
  ORDER by pi.created_at DESC
  LIMIT $2

SELECT DISTINCT
    tc.constraint_name as constraint_name,
    tc.constraint_type as constraint_type,
    tc.constraint_schema as source_schema,
    tc.table_name as source_table,
    kcu.column_name as source_column,
    CASE WHEN tc.constraint_type = $1 THEN ccu.constraint_schema ELSE $2 END AS target_schema,
    CASE WHEN tc.constraint_type = $3 THEN ccu.table_name ELSE $4 END AS target_table,
    CASE WHEN tc.constraint_type = $5 THEN ccu.column_name ELSE $6 END AS target_column,
    co.column_default as extra,
    co.identity_generation as generation
    FROM information_schema.table_constraints AS tc
    JOIN information_schema.key_column_usage AS kcu
      ON tc.table_schema = kcu.table_schema AND tc.table_name = kcu.table_name AND tc.constraint_name = kcu.constraint_name
    JOIN information_schema.constraint_column_usage AS ccu
      ON ccu.constraint_schema = tc.constraint_schema AND ccu.constraint_name = tc.constraint_name
    JOIN information_schema.columns AS co
      ON co.table_schema = kcu.table_schema AND co.table_name = kcu.table_name AND co.column_name = kcu.column_name
    WHERE tc.table_name = $7
       AND tc.constraint_schema = $8

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

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

BEGIN

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

SELECT $1+$2

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, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19) ORDER BY 1, 2 /*pghero*/

SELECT t.tableoid, t.oid, t.typname, t.typnamespace, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(t.typacl,pg_catalog.acldefault($1,t.typowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,t.typowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS typacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($4,t.typowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(t.typacl,pg_catalog.acldefault($6,t.typowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, $7 AS inittypacl, $8 AS initrtypacl, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = $9 THEN $10::"char" ELSE (SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[$11] = $12 AND t.typelem != $13 AND (SELECT typarray FROM pg_type te WHERE oid = t.typelem) = t.oid AS isarray FROM pg_type t LEFT JOIN pg_init_privs pip ON (t.oid = pip.objoid AND pip.classoid = $14::regclass AND pip.objsubid = $15)

UPDATE
            payout_invoices
          SET
            is_sended_to_ps = $5,
            ps_id = $2,
            ps_create_response = $3,
            ps_create_request = $4
          WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- ext_id, project_id UNIQUE

UPDATE invoices
        SET method_id = $2
        WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT * FROM payout_invoices WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- ext_id, project_id UNIQUE

ROLLBACK

UPDATE payout_invoices
        SET is_finished = $5, ps_id = $1, finished_at = NOW(), callback_data = $2, is_success = $4
        WHERE id = $3

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- ext_id, project_id UNIQUE

SELECT pi.*, pm.method_name, ps.name as ps_title
  FROM invoices pi
  JOIN systems ps ON ps.id = pi.system_id
  JOIN methods pm ON pm.id = pi.method_id
  WHERE pi.project_id = $1 AND is_finished = $2
  ORDER by pi.created_at DESC
  LIMIT $3

SELECT pk.constraint_type as "Constraint",c.column_name as "Field", c.column_default as "Default",c.is_nullable as "Null", (CASE WHEN c.udt_name = $1 THEN c.udt_name ELSE c.data_type END) || (CASE WHEN c.character_maximum_length IS NOT NULL THEN $2 || c.character_maximum_length || $3 ELSE $4 END) as "Type", (SELECT array_agg(e.enumlabel) FROM pg_catalog.pg_type t JOIN pg_catalog.pg_enum e ON t.oid=e.enumtypid WHERE t.typname=c.udt_name) AS "special", (SELECT pgd.description FROM pg_catalog.pg_statio_all_tables AS st INNER JOIN pg_catalog.pg_description pgd on (pgd.objoid=st.relid) WHERE c.ordinal_position=pgd.objsubid AND c.table_name=st.relname) AS "Comment" FROM information_schema.columns c LEFT JOIN (SELECT tc.table_schema, tc.table_name, cu.column_name, tc.constraint_type FROM information_schema.TABLE_CONSTRAINTS tc JOIN information_schema.KEY_COLUMN_USAGE  cu ON tc.table_schema=cu.table_schema and tc.table_name=cu.table_name and tc.constraint_name=cu.constraint_name and tc.constraint_type=$5) pk ON pk.table_schema=c.table_schema AND pk.table_name=c.table_name AND pk.column_name=c.column_name WHERE c.table_name = $6 AND c.table_schema = $7

UPDATE payout_invoices SET is_sended_to_project = $2 WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- ext_id, project_id UNIQUE

UPDATE invoices
        SET is_finished = $5, ps_id = $1, finished_at = NOW(), callback_data = $2, order_info = $4
        WHERE id = $3

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- created_at
- is_finished, is_success
- method_id
- project_id
- system_id

SELECT
  payout_methods.method_name
  FROM payout_methods
  JOIN payout_systems ON payout_systems.id = payout_methods.system_id
  WHERE
    project_id = $1 AND
    payout_methods.is_enabled = $2 AND
    payout_systems.is_enabled = $3 AND
    payout_methods.is_internal = $4
  
  GROUP by payout_methods.method_name
  ORDER by method_name

SELECT
    payout_methods.*, payout_systems.title as system_name
  FROM payout_methods
  JOIN payout_systems ON payout_systems.id = payout_methods.system_id
  WHERE
    project_id = $1 AND
    payout_methods.is_enabled = $2 AND
    payout_systems.is_enabled = $3 AND 
    payout_methods.is_internal = $4
  ORDER by method_name

UPDATE "public"."systems_balance" SET "updated_at"=$1,"balance"=$2 WHERE "id" = $3

SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($1,p.proowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,p.proowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS proacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($4,p.proowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($6,p.proowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, $7 AS initproacl, $8 AS initrproacl, p.pronamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = p.proowner) AS rolname FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = $9::regclass AND pip.objsubid = $10) WHERE p.prokind <> $11
  AND NOT EXISTS (SELECT $12 FROM pg_depend WHERE classid = $13::regclass AND objid = p.oid AND deptype = $14)
  AND (
  pronamespace != (SELECT oid FROM pg_namespace WHERE nspname = $15)
  OR EXISTS (SELECT $16 FROM pg_cast
  WHERE pg_cast.oid > $17 
  AND p.oid = pg_cast.castfunc)
  OR EXISTS (SELECT $18 FROM pg_transform
  WHERE pg_transform.oid > $19 AND 
  (p.oid = pg_transform.trffromsql
  OR p.oid = pg_transform.trftosql))
  OR p.proacl IS DISTINCT FROM pip.initprivs)

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

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

UPDATE payout_invoices SET ps_id = $1 WHERE id = $2

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- ext_id, project_id UNIQUE

UPDATE paycodes SET is_finished = $2 WHERE id = $1

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

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- code

SELECT * FROM paycodes WHERE code = $1

Covered by index on (code)
Rows: 2738
Row progression: 2738, 1

Row estimates
- code (=): 1

Existing indexes
- id PRIMARY
- code

UPDATE paycodes SET is_used = $4, used_at = NOW(), invoice_id = $2, user_ip = $3 WHERE id = $1 AND is_used = $5

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

Row estimates
- id (=): 1
- is_used (=): 1369

Existing indexes
- id PRIMARY
- code

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, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22) ORDER BY 1, 2 /*pghero*/

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