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

SELECT 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 /*, ... */)

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 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 pg_database_size(current_database()) /*pghero*/

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 /*, ... */) AND n.nspname !~ $7 AND c.relkind IN ($8 /*, ... */) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

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

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 /*, ... */)

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 /*, ... */) ORDER BY 1, 2 /*pghero*/

SELECT t.oid, t.typname
FROM pg_type as t
WHERE t.typname IN ($1 /*, ... */)

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

SET SESSION timezone TO $1

SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*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 /*, ... */) /*pghero*/

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

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

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

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

SELECT schemaname AS schema, tablename AS table, attname AS column, null_frac, n_distinct FROM pg_stats WHERE schemaname = $1 AND tablename IN ($2 /*, ... */) ORDER BY 1, 2, 3 /*pghero*/

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

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 /*, ... */)

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 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 "public"."profiles"."id", "public"."profiles"."first_name", "public"."profiles"."last_name", "public"."profiles"."phone", "public"."profiles"."email", "public"."profiles"."username", "public"."profiles"."password_hash", "public"."profiles"."is_active", "public"."profiles"."created_at", "public"."profiles"."updated_at" FROM "public"."profiles" WHERE ("public"."profiles"."id" = $1 AND 1=1) LIMIT $2 OFFSET $3

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

SELECT "public"."user_roles"."id", "public"."user_roles"."user_id", "public"."user_roles"."role"::text, "public"."user_roles"."created_at" FROM "public"."user_roles" WHERE "public"."user_roles"."user_id" IN ($1) OFFSET $2

SELECT "public"."payment_approvals"."id", "public"."payment_approvals"."work_order_id", "public"."payment_approvals"."requested_amount", "public"."payment_approvals"."requested_status"::text, "public"."payment_approvals"."requested_at", "public"."payment_approvals"."requested_by", "public"."payment_approvals"."approved_at", "public"."payment_approvals"."approved_by", "public"."payment_approvals"."payment_method"::text, "public"."payment_approvals"."status", "public"."payment_approvals"."notes", "public"."payment_approvals"."created_at" FROM "public"."payment_approvals" WHERE "public"."payment_approvals"."work_order_id" = $1 ORDER BY "public"."payment_approvals"."requested_at" DESC OFFSET $2

SELECT "public"."payments"."id", "public"."payments"."work_order_id", "public"."payments"."amount", "public"."payments"."payment_method"::text, "public"."payments"."payment_date", "public"."payments"."notes", "public"."payments"."recorded_by", "public"."payments"."created_at" FROM "public"."payments" WHERE "public"."payments"."work_order_id" = $1 ORDER BY "public"."payments"."payment_date" DESC OFFSET $2

SET client_min_messages TO $1

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

SELECT "public"."notifications"."id", "public"."notifications"."user_id", "public"."notifications"."title", "public"."notifications"."message", "public"."notifications"."type", "public"."notifications"."related_work_order_id", "public"."notifications"."is_read", "public"."notifications"."created_at" FROM "public"."notifications" WHERE "public"."notifications"."user_id" = $1 ORDER BY "public"."notifications"."created_at" DESC OFFSET $2

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

SHOW search_path

SELECT "public"."check_outs"."id", "public"."check_outs"."work_order_id", "public"."check_outs"."technician_id", "public"."check_outs"."technician_signature_url", "public"."check_outs"."technician_signature_date", "public"."check_outs"."customer_name", "public"."check_outs"."customer_vehicle_registration", "public"."check_outs"."customer_signature_url", "public"."check_outs"."customer_signature_date", "public"."check_outs"."check_out_date", "public"."check_outs"."created_at" FROM "public"."check_outs" WHERE "public"."check_outs"."work_order_id" = $1 LIMIT $2 OFFSET $3

SELECT "public"."activity_log"."id", "public"."activity_log"."work_order_id", "public"."activity_log"."action", "public"."activity_log"."details", "public"."activity_log"."performed_by", "public"."activity_log"."created_at" FROM "public"."activity_log" WHERE "public"."activity_log"."work_order_id" IS NOT NULL ORDER BY "public"."activity_log"."created_at" DESC LIMIT $1 OFFSET $2

SET standard_conforming_strings = $1

SELECT "public"."work_orders"."id", "public"."work_orders"."order_number", "public"."work_orders"."status"::text, "public"."work_orders"."priority"::text, "public"."work_orders"."payment_status"::text, "public"."work_orders"."customer_id", "public"."work_orders"."created_by", "public"."work_orders"."assigned_to", "public"."work_orders"."assigned_by", "public"."work_orders"."assigned_at", "public"."work_orders"."equipment_model", "public"."work_orders"."serial_number", "public"."work_orders"."customer_request", "public"."work_orders"."technician_notes", "public"."work_orders"."subtotal", "public"."work_orders"."discount", "public"."work_orders"."total", "public"."work_orders"."labor_hours", "public"."work_orders"."expected_completion_date", "public"."work_orders"."created_at", "public"."work_orders"."updated_at" FROM "public"."work_orders" WHERE 1=1 ORDER BY "public"."work_orders"."created_at" DESC OFFSET $1

SET intervalstyle = $1

SELECT pg_stat_statements_reset(0, 5, 0) /*pghero*/

SELECT "public"."profiles"."id", "public"."profiles"."first_name", "public"."profiles"."last_name" FROM "public"."profiles" WHERE "public"."profiles"."id" IN ($1) OFFSET $2

SELECT $1

SELECT "public"."profiles"."id", "public"."profiles"."first_name", "public"."profiles"."last_name" FROM "public"."profiles" WHERE "public"."profiles"."id" IN ($1,$2) OFFSET $3

SELECT "public"."work_order_services"."id", "public"."work_order_services"."work_order_id", "public"."work_order_services"."item_name", "public"."work_order_services"."quantity", "public"."work_order_services"."unit_price", "public"."work_order_services"."created_at" FROM "public"."work_order_services" WHERE "public"."work_order_services"."work_order_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14) OFFSET $15

SHOW max_connections /*pghero*/

SELECT "public"."work_orders"."id", "public"."work_orders"."order_number" FROM "public"."work_orders" WHERE "public"."work_orders"."id" IN ($1 /*, ... */) OFFSET $2

SELECT "public"."customers"."id", "public"."customers"."first_name", "public"."customers"."last_name", "public"."customers"."phone", "public"."customers"."vehicle_registration", "public"."customers"."created_at", "public"."customers"."updated_at" FROM "public"."customers" WHERE "public"."customers"."id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14) OFFSET $15

SELECT "public"."payments"."id", "public"."payments"."amount", "public"."payments"."payment_method"::text, "public"."payments"."payment_date", "public"."payments"."notes", "public"."payments"."work_order_id" FROM "public"."payments" WHERE "public"."payments"."work_order_id" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14) OFFSET $15

SELECT "public"."profiles"."id", "public"."profiles"."first_name", "public"."profiles"."last_name" FROM "public"."profiles" WHERE "public"."profiles"."id" IN ($1,$2,$3) OFFSET $4

SHOW checkpoint_completion_target /*pghero*/

SHOW maintenance_work_mem /*pghero*/

SHOW shared_buffers /*pghero*/

SHOW jit /*pghero*/

SHOW random_page_cost /*pghero*/

SHOW effective_io_concurrency /*pghero*/

SHOW effective_cache_size /*pghero*/

SHOW default_statistics_target /*pghero*/

SHOW wal_buffers /*pghero*/

SHOW huge_pages /*pghero*/

SHOW wal_compression /*pghero*/

SHOW min_wal_size /*pghero*/

SHOW work_mem /*pghero*/

SHOW max_wal_size /*pghero*/

SHOW io_method /*pghero*/

SHOW server_version /*pghero*/

SHOW server_version_num /*pghero*/

SELECT pg_is_in_recovery() /*pghero*/