pgBadger-
Global information
- Generated on Sat Nov 29 05:00:07 2025
- Log file: ssh://root@db2.cetoc.muni.cz//mnt/logpsql/var/log/postgresql/postgresql-12-main.log
- Parsed 2,833 log entries in 3s
- Log start from 2025-11-28 02:01:02 to 2025-11-28 09:14:47
-
Overview
Global Stats
- 289 Number of unique normalized queries
- 1,377 Number of queries
- 12s935ms Total query duration
- 2025-11-28 02:01:02 First query
- 2025-11-28 02:01:16 Last query
- 434 queries/s at 2025-11-28 02:01:13 Query peak
- 12s935ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 12s935ms Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 1 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 12 Total number of sessions
- 0 sessions at Session peak
- 13s199ms Total duration of sessions
- 1s99ms Average duration of sessions
- 114 Average queries per session
- 1s77ms Average queries duration per session
- 21ms Average idle time per session
- 12 Total number of connections
- 3 connections/s at 2025-11-28 02:01:14 Connection peak
- 11 Total number of databases
SQL Traffic
Key values
- 434 queries/s Query Peak
- 2025-11-28 02:01:13 Date
SELECT Traffic
Key values
- 306 queries/s Query Peak
- 2025-11-28 02:01:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 59 queries/s Query Peak
- 2025-11-28 02:01:13 Date
Queries duration
Key values
- 12s935ms Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 28 02 1,377 0ms 3s136ms 9ms 12s935ms 12s935ms 12s935ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 28 02 1,003 132 11ms 10s551ms 10s551ms 10s551ms 09 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 28 02 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 28 02 0 0 0.00 0.00% 09 0 0 0.00 0.00% Day Hour Count Average / Second Nov 28 02 12 0.00/s 09 0 0.00/s Day Hour Count Average Duration Average idle time Nov 28 02 12 1s99ms 21ms 09 0 0ms 0ms -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2025-11-28 02:01:14 Date
Connections per database
Key values
- postgres Main Database
- 12 connections Total
Connections per user
Key values
- postgres Main User
- 12 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 8 0-500ms duration
Sessions per database
Key values
- postgres Main Database
- 12 sessions Total
Sessions per user
Key values
- postgres Main User
- 12 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 12 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1 buffers Checkpoint Peak
- 2025-11-28 09:14:47 Date
- 2.670 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2025-11-28 09:14:47 Date
Checkpoints distance
Key values
- 0.01 Mo Distance Peak
- 2025-11-28 09:14:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 28 02 0 0s 0s 0s 09 1 2.67s 0.005s 2.721s Day Hour Added Removed Recycled Synced files Longest sync Average sync Nov 28 02 0 0 0 0 0s 0s 09 0 0 0 1 0.005s 0.005s Day Hour Count Avg time (sec) Nov 28 02 0 0s 09 0 0s Day Hour Mean distance Mean estimate Nov 28 02 0.00 kB 0.00 kB 09 6.00 kB 10.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 28 02 0 0 0 09 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database openmetadata_db - 2025-11-28 09:10:35 Date
- 0 sec Highest CPU-cost analyze
Table
Database openmetadata_db - Date
Average Autovacuum Duration
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database openmetadata_db - 2025-11-28 09:10:35 Date
Analyzes per table
Key values
- pg_catalog.pg_shdepend (1) Main table analyzed (database openmetadata_db)
- 1 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_shdepend (1) Main table vacuumed on database openmetadata_db
- 1 vacuums Total
Vacuum throughput per table
Key values
- pg_catalog.pg_shdepend (0.01) Max CPU elapsed for vacuum on database openmetadata_db
- unknown (0 ms) Max I/O read time for vacuum on database openmetadata_db
- unknown (0 ms) Max I/O write time for vacuum on database openmetadata_db
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 28 02 0 0 09 1 1 - 0.01 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 1,003 Total read queries
- 152 Total write queries
Queries by database
Key values
- unknown Main database
- 1,365 Requests
- 12s864ms (unknown)
- Main time consuming database
Database Request type Count Duration airbyte Total 1 12ms select 1 12ms airbytev2 Total 1 1ms select 1 1ms airflow Total 1 3ms select 1 3ms airflow_db Total 1 6ms select 1 6ms opendata Total 1 1ms select 1 1ms openmetadata_db Total 1 1ms select 1 1ms postgres Total 3 2ms select 3 2ms temporal Total 1 2ms select 1 2ms temporal_visibility Total 1 15ms select 1 15ms testikee Total 1 22ms select 1 22ms unknown Total 1,365 12s864ms copy to 132 10s551ms cte 10 13ms others 222 6ms select 991 2s293ms tcl 10 0ms Queries by user
Key values
- unknown Main user
- 1,365 Requests
User Request type Count Duration postgres Total 12 70ms select 12 70ms unknown Total 1,365 12s864ms copy to 132 10s551ms cte 10 13ms others 222 6ms select 991 2s293ms tcl 10 0ms Duration by user
Key values
- 12s864ms (unknown) Main time consuming user
User Request type Count Duration postgres Total 12 70ms select 12 70ms unknown Total 1,365 12s864ms copy to 132 10s551ms cte 10 13ms others 222 6ms select 991 2s293ms tcl 10 0ms Queries by host
Key values
- unknown Main host
- 1,377 Requests
- 12s935ms (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 1,365 Requests
- 12s864ms (unknown)
- Main time consuming application
Application Request type Count Duration pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 10 69ms select 10 69ms psql SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 2 1ms select 2 1ms unknown Total 1,365 12s864ms copy to 132 10s551ms cte 10 13ms others 222 6ms select 991 2s293ms tcl 10 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-28 02:01:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,153 0-1ms duration
Slowest individual queries
Rank Duration Query 1 3s136ms COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;[ Date: 2025-11-28 02:01:11 ]
2 3s119ms COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;[ Date: 2025-11-28 02:01:06 ]
3 1s661ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-28 02:01:08 ]
4 1s639ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-28 02:01:13 ]
5 472ms COPY public.history_node (shard_id, tree_id, branch_id, node_id, txn_id, data, data_encoding, prev_txn_id) TO stdout;[ Date: 2025-11-28 02:01:15 ]
6 162ms 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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);[ Date: 2025-11-28 02:01:16 ]
7 119ms 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;[ Date: 2025-11-28 02:01:16 ]
8 100ms COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;[ Date: 2025-11-28 02:01:15 ]
9 94ms 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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);[ Date: 2025-11-28 02:01:15 ]
10 78ms COPY public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) TO stdout;[ Date: 2025-11-28 02:01:08 ]
11 64ms 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;[ Date: 2025-11-28 02:01:14 ]
12 53ms SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;[ Date: 2025-11-28 02:01:15 ]
13 49ms 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;[ Date: 2025-11-28 02:01:15 ]
14 46ms SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;[ Date: 2025-11-28 02:01:15 ]
15 45ms 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;[ Date: 2025-11-28 02:01:03 ]
16 43ms COPY public.timer_info_maps (shard_id, namespace_id, workflow_id, run_id, timer_id, data, data_encoding) TO stdout;[ Date: 2025-11-28 02:01:15 ]
17 42ms 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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);[ Date: 2025-11-28 02:01:14 ]
18 40ms 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;[ Date: 2025-11-28 02:01:14 ]
19 36ms SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;[ Date: 2025-11-28 02:01:15 ]
20 36ms COPY public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) TO stdout;[ Date: 2025-11-28 02:01:08 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6s256ms 2 3s119ms 3s136ms 3s128ms copy public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 28 02 2 6s256ms 3s128ms -
COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;
Date: 2025-11-28 02:01:11 Duration: 3s136ms
-
COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;
Date: 2025-11-28 02:01:06 Duration: 3s119ms
2 3s301ms 2 1s639ms 1s661ms 1s650ms copy public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 28 02 2 3s301ms 1s650ms -
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 1s661ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-28 02:01:13 Duration: 1s639ms
3 483ms 10 13ms 162ms 48ms 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(?, p.proowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, p.proowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault(?, p.proowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rproacl, null as initproacl, null 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 = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 28 02 10 483ms 48ms -
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:16 Duration: 162ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:15 Duration: 94ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:14 Duration: 42ms
4 472ms 1 472ms 472ms 472ms copy public.history_node (shard_id, tree_id, branch_id, node_id, txn_id, data, data_encoding, prev_txn_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 28 02 1 472ms 472ms -
COPY public.history_node (shard_id, tree_id, branch_id, node_id, txn_id, data, data_encoding, prev_txn_id) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 472ms
5 454ms 10 23ms 119ms 45ms 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( case when c.relkind = ? then ? else ? 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( case when c.relkind = ? then ? else ? end::"char", c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rrelacl, null as initrelacl, null 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, ?::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, c.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, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, tc.reloptions as toast_reloptions, c.relkind = ? and exists ( select ? from pg_depend where classid = ?::regclass and objid = c.oid and objsubid = ? and refclassid = ?::regclass and deptype = ?) as is_identity_sequence, exists ( select ? from pg_attribute at left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::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(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null)) as changed_acl, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = ? and d.refclassid = c.tableoid and d.deptype in (...)) left join pg_class tc on (c.reltoastrelid = tc.oid and c.relkind <> ?) left join pg_am am on (c.relam = am.oid) left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 28 02 10 454ms 45ms -
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:16 Duration: 119ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:14 Duration: 64ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:15 Duration: 49ms
6 170ms 10 3ms 53ms 17ms select classid, objid, refclassid, refobjid, deptype from pg_depend where deptype != ? and deptype != ? union all select ?::regclass as classid, amopfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amop o where deptype not in (...) and classid = ?::regclass and objid = o.oid and not (refclassid = ?::regclass and amopfamily = refobjid) union all select ?::regclass as classid, amprocfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amproc p where deptype not in (...) and classid = ?::regclass and objid = p.oid and not (refclassid = ?::regclass and amprocfamily = refobjid) order by ?, ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 28 02 10 170ms 17ms -
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:15 Duration: 53ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:03 Duration: 28ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:14 Duration: 19ms
7 124ms 10 3ms 36ms 12ms select n.tableoid, n.oid, n.nspname, ( select rolname from pg_catalog.pg_roles where oid = nspowner) as rolname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, n.nspowner))) as init (init_acl) where acl = init_acl)) as foo) as nspacl, ( 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(?, n.nspowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rnspacl, null as initnspacl, null as initrnspacl from pg_namespace n left join pg_init_privs pip on (n.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 28 02 10 124ms 12ms -
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:16 Duration: 36ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:14 Duration: 26ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 16ms
8 105ms 132 0ms 3ms 0ms select t.tableoid, t.oid, t.relname as indexname, inh.inhparent as parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, i.indnkeyatts as indnkeyatts, i.indnatts as indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid as contableoid, c.oid as conoid, pg_catalog.pg_get_constraintdef(c.oid, false) as condef, ( select spcname from pg_catalog.pg_tablespace s where s.oid = t.reltablespace) as tablespace, t.reloptions as indreloptions, ( select pg_catalog.array_agg(attnum order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatcols, ( select pg_catalog.array_agg(attstattarget order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatvals from pg_catalog.pg_index i 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 (...)) left join pg_catalog.pg_inherits inh on (inh.inhrelid = indexrelid) where i.indrelid = ?::pg_catalog.oid and (i.indisvalid or t2.relkind = ?) and i.indisready order by indexname;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 28 02 132 105ms 0ms -
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '65635'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:13 Duration: 3ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '35225'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:08 Duration: 2ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '66071'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:15 Duration: 2ms
9 105ms 10 2ms 36ms 10ms select tableoid, oid, collname, collnamespace, ( select rolname from pg_catalog.pg_roles where oid = collowner) as rolname from pg_collation;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 28 02 10 105ms 10ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:15 Duration: 36ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:13 Duration: 13ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:14 Duration: 12ms
10 100ms 1 100ms 100ms 100ms copy public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 28 02 1 100ms 100ms -
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 100ms
11 100ms 10 5ms 19ms 10ms 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(?, t.typowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, t.typowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault(?, t.typowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rtypacl, null as inittypacl, null as initrtypacl, ( select rolname from pg_catalog.pg_roles where oid = t.typowner) as rolname, t.typelem, t.typrelid, case when t.typrelid = ? then ?::"char" else ( select relkind from pg_class where oid = t.typrelid) end as typrelkind, t.typtype, t.typisdefined, t.typname[?] = ? and t.typelem != ? 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 = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 28 02 10 100ms 10ms -
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:15 Duration: 19ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 17ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:13 Duration: 12ms
12 97ms 5 10ms 46ms 19ms select description, classoid, objoid, objsubid from pg_catalog.pg_description order by classoid, objoid, objsubid;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 28 02 5 97ms 19ms -
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:15 Duration: 46ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:03 Duration: 15ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:08 Duration: 13ms
13 95ms 2 16ms 78ms 47ms copy public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 28 02 2 95ms 47ms -
COPY public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 78ms
-
COPY public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) TO stdout;
Date: 2025-11-28 02:01:13 Duration: 16ms
14 91ms 10 2ms 16ms 9ms select classid, objid, refobjid from pg_depend where refclassid = ?::regclass and deptype = ? order by ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 28 02 10 91ms 9ms -
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:15 Duration: 14ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:14 Duration: 11ms
15 79ms 10 1ms 30ms 7ms select x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition from pg_extension x join pg_namespace n on n.oid = x.extnamespace;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 28 02 10 79ms 7ms -
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:16 Duration: 30ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:15 Duration: 10ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:14 Duration: 8ms
16 75ms 10 2ms 16ms 7ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 28 02 10 75ms 7ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:15 Duration: 13ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:14 Duration: 11ms
17 71ms 2 34ms 36ms 35ms copy public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 28 02 2 71ms 35ms -
COPY public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 36ms
-
COPY public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) TO stdout;
Date: 2025-11-28 02:01:03 Duration: 34ms
18 70ms 20 0ms 22ms 3ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 28 02 20 70ms 3ms [ User: postgres - Total duration: 69ms - Times executed: 10 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 69ms - Times executed: 10 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:16 Duration: 22ms Database: testikee User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:15 Duration: 15ms Database: temporal_visibility User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:02 Duration: 12ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
19 47ms 2 21ms 25ms 23ms copy public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 28 02 2 47ms 23ms -
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-28 02:01:03 Duration: 25ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 21ms
20 44ms 10 0ms 16ms 4ms select tableoid, oid, rulename, ev_class as ruletable, ev_type, is_instead, ev_enabled from pg_rewrite order by oid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 28 02 10 44ms 4ms -
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:15 Duration: 16ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:03 Duration: 7ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:14 Duration: 4ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 132 105ms 0ms 3ms 0ms select t.tableoid, t.oid, t.relname as indexname, inh.inhparent as parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, i.indnkeyatts as indnkeyatts, i.indnatts as indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid as contableoid, c.oid as conoid, pg_catalog.pg_get_constraintdef(c.oid, false) as condef, ( select spcname from pg_catalog.pg_tablespace s where s.oid = t.reltablespace) as tablespace, t.reloptions as indreloptions, ( select pg_catalog.array_agg(attnum order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatcols, ( select pg_catalog.array_agg(attstattarget order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatvals from pg_catalog.pg_index i 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 (...)) left join pg_catalog.pg_inherits inh on (inh.inhrelid = indexrelid) where i.indrelid = ?::pg_catalog.oid and (i.indisvalid or t2.relkind = ?) and i.indisready order by indexname;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 28 02 132 105ms 0ms -
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '65635'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:13 Duration: 3ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '35225'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:08 Duration: 2ms
-
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, ( SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, ( SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, ( SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals FROM pg_catalog.pg_index i 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 ('p', 'u', 'x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = '66071'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-28 02:01:15 Duration: 2ms
2 132 42ms 0ms 2ms 0ms select 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, a.attgenerated, case when a.atthasmissing and not a.attisdropped then a.attmissingval else null end as attmissingval, a.attidentity, pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(option_name) || ? || pg_catalog.quote_literal(option_value) from pg_catalog.pg_options_to_table(attfdwoptions) order by option_name), e ?) as attfdwoptions, case when a.attcollation <> t.typcollation then a.attcollation else ? end as attcollation, array_to_string(a.attoptions, ?) as attoptions from pg_catalog.pg_attribute a left join pg_catalog.pg_type t on a.atttypid = t.oid where a.attrelid = ?::pg_catalog.oid and a.attnum > ?::pg_catalog.int2 order by a.attnum;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 28 02 132 42ms 0ms -
SELECT 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, pg_catalog.array_to_string(ARRAY ( SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), E', ') AS attfdwoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '68577'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-28 02:01:03 Duration: 2ms
-
SELECT 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, pg_catalog.array_to_string(ARRAY ( SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), E', ') AS attfdwoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '35225'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-28 02:01:08 Duration: 1ms
-
SELECT 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, a.attgenerated, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE null END AS attmissingval, a.attidentity, pg_catalog.array_to_string(ARRAY ( SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), E', ') AS attfdwoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, array_to_string(a.attoptions, ', ') AS attoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '65367'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-28 02:01:13 Duration: 1ms
3 86 18ms 0ms 2ms 0ms select tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) as adsrc from pg_catalog.pg_attrdef where adrelid = ?::pg_catalog.oid;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 28 02 86 18ms 0ms -
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '66071'::pg_catalog.oid;
Date: 2025-11-28 02:01:15 Duration: 2ms
-
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '68577'::pg_catalog.oid;
Date: 2025-11-28 02:01:03 Duration: 2ms
-
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '35225'::pg_catalog.oid;
Date: 2025-11-28 02:01:08 Duration: 1ms
4 72 14ms 0ms 0ms 0ms select t.tgname, t.tgfoid::pg_catalog.regproc as tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) as tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal from pg_catalog.pg_trigger t left join pg_catalog.pg_depend as d on d.classid = ?::pg_catalog.regclass and d.refclassid = ?::pg_catalog.regclass and d.objid = t.oid left join pg_catalog.pg_trigger as pt on pt.oid = refobjid where t.tgrelid = ?::pg_catalog.oid and (not t.tgisinternal);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 28 02 72 14ms 0ms -
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '35225'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-11-28 02:01:08 Duration: 0ms
-
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '65400'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-11-28 02:01:13 Duration: 0ms
-
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, false) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = '68577'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-11-28 02:01:03 Duration: 0ms
5 72 6ms 0ms 0ms 0ms select tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) as condef from pg_catalog.pg_constraint where conrelid = ?::pg_catalog.oid and conparentid = ? and contype = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 28 02 72 6ms 0ms -
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '35225'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-11-28 02:01:08 Duration: 0ms
-
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '68577'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-11-28 02:01:03 Duration: 0ms
-
SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = '35306'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-11-28 02:01:08 Duration: 0ms
6 34 3ms 0ms 0ms 0ms select oid, enumlabel from pg_catalog.pg_enum where enumtypid = ? order by enumsortorder;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 28 02 34 3ms 0ms -
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = '68435' ORDER BY enumsortorder;
Date: 2025-11-28 02:01:03 Duration: 0ms
-
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = '35110' ORDER BY enumsortorder;
Date: 2025-11-28 02:01:08 Duration: 0ms
-
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = '35116' ORDER BY enumsortorder;
Date: 2025-11-28 02:01:08 Duration: 0ms
7 31 3ms 0ms 0ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 28 02 31 3ms 0ms -
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '68649'::oid;
Date: 2025-11-28 02:01:03 Duration: 0ms
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '35276'::oid;
Date: 2025-11-28 02:01:08 Duration: 0ms
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '65550'::oid;
Date: 2025-11-28 02:01:13 Duration: 0ms
8 20 70ms 0ms 22ms 3ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 28 02 20 70ms 3ms [ User: postgres - Total duration: 69ms - Times executed: 10 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 69ms - Times executed: 10 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:16 Duration: 22ms Database: testikee User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:15 Duration: 15ms Database: temporal_visibility User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:02 Duration: 12ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
9 10 483ms 13ms 162ms 48ms 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(?, p.proowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, p.proowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault(?, p.proowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rproacl, null as initproacl, null 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 = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 28 02 10 483ms 48ms -
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:16 Duration: 162ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:15 Duration: 94ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:14 Duration: 42ms
10 10 454ms 23ms 119ms 45ms 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( case when c.relkind = ? then ? else ? 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( case when c.relkind = ? then ? else ? end::"char", c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rrelacl, null as initrelacl, null 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, ?::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, c.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, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, tc.reloptions as toast_reloptions, c.relkind = ? and exists ( select ? from pg_depend where classid = ?::regclass and objid = c.oid and objsubid = ? and refclassid = ?::regclass and deptype = ?) as is_identity_sequence, exists ( select ? from pg_attribute at left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::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(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null)) as changed_acl, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = ? and d.refclassid = c.tableoid and d.deptype in (...)) left join pg_class tc on (c.reltoastrelid = tc.oid and c.relkind <> ?) left join pg_am am on (c.relam = am.oid) left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 28 02 10 454ms 45ms -
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:16 Duration: 119ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:14 Duration: 64ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:15 Duration: 49ms
11 10 170ms 3ms 53ms 17ms select classid, objid, refclassid, refobjid, deptype from pg_depend where deptype != ? and deptype != ? union all select ?::regclass as classid, amopfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amop o where deptype not in (...) and classid = ?::regclass and objid = o.oid and not (refclassid = ?::regclass and amopfamily = refobjid) union all select ?::regclass as classid, amprocfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amproc p where deptype not in (...) and classid = ?::regclass and objid = p.oid and not (refclassid = ?::regclass and amprocfamily = refobjid) order by ?, ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 28 02 10 170ms 17ms -
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:15 Duration: 53ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:03 Duration: 28ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:14 Duration: 19ms
12 10 124ms 3ms 36ms 12ms select n.tableoid, n.oid, n.nspname, ( select rolname from pg_catalog.pg_roles where oid = nspowner) as rolname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, n.nspowner))) as init (init_acl) where acl = init_acl)) as foo) as nspacl, ( 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(?, n.nspowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rnspacl, null as initnspacl, null as initrnspacl from pg_namespace n left join pg_init_privs pip on (n.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 28 02 10 124ms 12ms -
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:16 Duration: 36ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:14 Duration: 26ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 16ms
13 10 105ms 2ms 36ms 10ms select tableoid, oid, collname, collnamespace, ( select rolname from pg_catalog.pg_roles where oid = collowner) as rolname from pg_collation;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 28 02 10 105ms 10ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:15 Duration: 36ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:13 Duration: 13ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:14 Duration: 12ms
14 10 100ms 5ms 19ms 10ms 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(?, t.typowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, t.typowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault(?, t.typowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rtypacl, null as inittypacl, null as initrtypacl, ( select rolname from pg_catalog.pg_roles where oid = t.typowner) as rolname, t.typelem, t.typrelid, case when t.typrelid = ? then ?::"char" else ( select relkind from pg_class where oid = t.typrelid) end as typrelkind, t.typtype, t.typisdefined, t.typname[?] = ? and t.typelem != ? 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 = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 28 02 10 100ms 10ms -
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:15 Duration: 19ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 17ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:13 Duration: 12ms
15 10 91ms 2ms 16ms 9ms select classid, objid, refobjid from pg_depend where refclassid = ?::regclass and deptype = ? order by ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 28 02 10 91ms 9ms -
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:15 Duration: 14ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:14 Duration: 11ms
16 10 79ms 1ms 30ms 7ms select x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition from pg_extension x join pg_namespace n on n.oid = x.extnamespace;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 28 02 10 79ms 7ms -
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:16 Duration: 30ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:15 Duration: 10ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:14 Duration: 8ms
17 10 75ms 2ms 16ms 7ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 28 02 10 75ms 7ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:15 Duration: 13ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:14 Duration: 11ms
18 10 44ms 0ms 16ms 4ms select tableoid, oid, rulename, ev_class as ruletable, ev_type, is_instead, ev_enabled from pg_rewrite order by oid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 28 02 10 44ms 4ms -
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:15 Duration: 16ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:03 Duration: 7ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:14 Duration: 4ms
19 10 26ms 0ms 16ms 2ms select l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault(?, l.lanowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, l.lanowner))) as init (init_acl) where acl = init_acl)) as foo) as lanacl, ( 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(?, l.lanowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault(?, l.lanowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rlanacl, null as initlanacl, null as initrlanacl, ( select rolname from pg_catalog.pg_roles where oid = l.lanowner) as lanowner from pg_language l left join pg_init_privs pip on (l.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where l.lanispl order by l.oid;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 28 02 10 26ms 2ms -
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:15 Duration: 16ms
-
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:08 Duration: 2ms
-
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:03 Duration: 1ms
20 10 26ms 1ms 4ms 2ms select tableoid, oid, oprname, oprnamespace, ( select rolname from pg_catalog.pg_roles where oid = oprowner) as rolname, oprkind, oprcode::oid as oprcode from pg_operator;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 28 02 10 26ms 2ms -
SELECT tableoid, oid, oprname, oprnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = oprowner) AS rolname, oprkind, oprcode::oid AS oprcode FROM pg_operator;
Date: 2025-11-28 02:01:15 Duration: 4ms
-
SELECT tableoid, oid, oprname, oprnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = oprowner) AS rolname, oprkind, oprcode::oid AS oprcode FROM pg_operator;
Date: 2025-11-28 02:01:14 Duration: 4ms
-
SELECT tableoid, oid, oprname, oprnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = oprowner) AS rolname, oprkind, oprcode::oid AS oprcode FROM pg_operator;
Date: 2025-11-28 02:01:14 Duration: 2ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3s119ms 3s136ms 3s128ms 2 6s256ms copy public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 28 02 2 6s256ms 3s128ms -
COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;
Date: 2025-11-28 02:01:11 Duration: 3s136ms
-
COPY public.attempts (id, job_id, attempt_number, log_path, output, status, created_at, updated_at, ended_at, temporal_workflow_id, failure_summary, processing_task_queue, attempt_sync_config) TO stdout;
Date: 2025-11-28 02:01:06 Duration: 3s119ms
2 1s639ms 1s661ms 1s650ms 2 3s301ms copy public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 28 02 2 3s301ms 1s650ms -
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 1s661ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-28 02:01:13 Duration: 1s639ms
3 472ms 472ms 472ms 1 472ms copy public.history_node (shard_id, tree_id, branch_id, node_id, txn_id, data, data_encoding, prev_txn_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 28 02 1 472ms 472ms -
COPY public.history_node (shard_id, tree_id, branch_id, node_id, txn_id, data, data_encoding, prev_txn_id) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 472ms
4 100ms 100ms 100ms 1 100ms copy public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 28 02 1 100ms 100ms -
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 100ms
5 13ms 162ms 48ms 10 483ms 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(?, p.proowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, p.proowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault(?, p.proowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rproacl, null as initproacl, null 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 = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 28 02 10 483ms 48ms -
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:16 Duration: 162ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:15 Duration: 94ms
-
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('f', p.proowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('f', 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('f', p.proowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(p.proacl, pg_catalog.acldefault('f', p.proowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, NULL AS initproacl, NULL 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 = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2025-11-28 02:01:14 Duration: 42ms
6 16ms 78ms 47ms 2 95ms copy public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 28 02 2 95ms 47ms -
COPY public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 78ms
-
COPY public.stream_stats (id, attempt_id, stream_namespace, stream_name, records_emitted, bytes_emitted, estimated_records, estimated_bytes, created_at, updated_at, bytes_committed, records_committed) TO stdout;
Date: 2025-11-28 02:01:13 Duration: 16ms
7 23ms 119ms 45ms 10 454ms 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( case when c.relkind = ? then ? else ? 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 = ? then ? else ? end::"char", c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( case when c.relkind = ? then ? else ? end::"char", c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rrelacl, null as initrelacl, null 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, ?::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, c.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, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, tc.reloptions as toast_reloptions, c.relkind = ? and exists ( select ? from pg_depend where classid = ?::regclass and objid = c.oid and objsubid = ? and refclassid = ?::regclass and deptype = ?) as is_identity_sequence, exists ( select ? from pg_attribute at left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::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(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null)) as changed_acl, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = ? and d.refclassid = c.tableoid and d.deptype in (...)) left join pg_class tc on (c.reltoastrelid = tc.oid and c.relkind <> ?) left join pg_am am on (c.relam = am.oid) left join pg_init_privs pip on (c.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 28 02 10 454ms 45ms -
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:16 Duration: 119ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:14 Duration: 64ms
-
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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' 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 = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(c.relacl, pg_catalog.acldefault( CASE WHEN c.relkind = 'S' THEN 's' ELSE 'r' END::"char", c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, NULL AS initrelacl, NULL 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, 'f'::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, c.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, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = 'S' AND EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_class'::regclass AND objid = c.oid AND objsubid = 0 AND refclassid = 'pg_class'::regclass AND deptype = 'i') AS is_identity_sequence, EXISTS ( SELECT 1 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::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('c', c.relowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('c', 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('c', c.relowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault('c', c.relowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR NULL IS NOT NULL OR NULL IS NOT NULL)) AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype IN ('a', 'i')) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND c.relkind <> 'p') LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = 'pg_class'::regclass AND pip.objsubid = 0) WHERE c.relkind in ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2025-11-28 02:01:15 Duration: 49ms
8 34ms 36ms 35ms 2 71ms copy public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 28 02 2 71ms 35ms -
COPY public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 36ms
-
COPY public.actor_definition (id, name, docker_repository, docker_image_tag, documentation_url, icon, actor_type, source_type, spec, created_at, updated_at, tombstone, release_stage, release_date, resource_requirements, public, custom, protocol_version, normalization_repository, normalization_tag, supports_dbt, normalization_integration_type, allowed_hosts, suggested_streams, max_seconds_between_messages, default_version_id) TO stdout;
Date: 2025-11-28 02:01:03 Duration: 34ms
9 21ms 25ms 23ms 2 47ms copy public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 28 02 2 47ms 23ms -
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-28 02:01:03 Duration: 25ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-28 02:01:08 Duration: 21ms
10 10ms 46ms 19ms 5 97ms select description, classoid, objoid, objsubid from pg_catalog.pg_description order by classoid, objoid, objsubid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 28 02 5 97ms 19ms -
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:15 Duration: 46ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:03 Duration: 15ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-28 02:01:08 Duration: 13ms
11 3ms 53ms 17ms 10 170ms select classid, objid, refclassid, refobjid, deptype from pg_depend where deptype != ? and deptype != ? union all select ?::regclass as classid, amopfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amop o where deptype not in (...) and classid = ?::regclass and objid = o.oid and not (refclassid = ?::regclass and amopfamily = refobjid) union all select ?::regclass as classid, amprocfamily as objid, refclassid, refobjid, deptype from pg_depend d, pg_amproc p where deptype not in (...) and classid = ?::regclass and objid = p.oid and not (refclassid = ?::regclass and amprocfamily = refobjid) order by ?, ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 28 02 10 170ms 17ms -
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:15 Duration: 53ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:03 Duration: 28ms
-
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e' UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid) UNION ALL SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid) ORDER BY 1, 2;
Date: 2025-11-28 02:01:14 Duration: 19ms
12 3ms 36ms 12ms 10 124ms select n.tableoid, n.oid, n.nspname, ( select rolname from pg_catalog.pg_roles where oid = nspowner) as rolname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, n.nspowner))) as init (init_acl) where acl = init_acl)) as foo) as nspacl, ( 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(?, n.nspowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault(?, n.nspowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rnspacl, null as initnspacl, null as initrnspacl from pg_namespace n left join pg_init_privs pip on (n.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 28 02 10 124ms 12ms -
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:16 Duration: 36ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:14 Duration: 26ms
-
SELECT n.tableoid, n.oid, n.nspname, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('n', n.nspowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) as nspacl, ( 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('n', n.nspowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl, pg_catalog.acldefault('n', n.nspowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 16ms
13 2ms 36ms 10ms 10 105ms select tableoid, oid, collname, collnamespace, ( select rolname from pg_catalog.pg_roles where oid = collowner) as rolname from pg_collation;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 28 02 10 105ms 10ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:15 Duration: 36ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:13 Duration: 13ms
-
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-28 02:01:14 Duration: 12ms
14 5ms 19ms 10ms 10 100ms 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(?, t.typowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, 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(?, t.typowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault(?, t.typowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rtypacl, null as inittypacl, null as initrtypacl, ( select rolname from pg_catalog.pg_roles where oid = t.typowner) as rolname, t.typelem, t.typrelid, case when t.typrelid = ? then ?::"char" else ( select relkind from pg_class where oid = t.typrelid) end as typrelkind, t.typtype, t.typisdefined, t.typname[?] = ? and t.typelem != ? 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 = ?::regclass and pip.objsubid = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 28 02 10 100ms 10ms -
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:15 Duration: 19ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:03 Duration: 17ms
-
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('T', t.typowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('T', 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('T', t.typowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(t.typacl, pg_catalog.acldefault('T', t.typowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, NULL AS inittypacl, NULL AS initrtypacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = 0 THEN ' '::"char" ELSE ( SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[0] = '_' AND t.typelem != 0 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 = 'pg_type'::regclass AND pip.objsubid = 0);
Date: 2025-11-28 02:01:13 Duration: 12ms
15 2ms 16ms 9ms 10 91ms select classid, objid, refobjid from pg_depend where refclassid = ?::regclass and deptype = ? order by ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 28 02 10 91ms 9ms -
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:15 Duration: 14ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-28 02:01:14 Duration: 11ms
16 1ms 30ms 7ms 10 79ms select x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition from pg_extension x join pg_namespace n on n.oid = x.extnamespace;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 28 02 10 79ms 7ms -
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:16 Duration: 30ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:15 Duration: 10ms
-
SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace;
Date: 2025-11-28 02:01:14 Duration: 8ms
17 2ms 16ms 7ms 10 75ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 28 02 10 75ms 7ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:16 Duration: 16ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:15 Duration: 13ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-28 02:01:14 Duration: 11ms
18 0ms 16ms 4ms 10 44ms select tableoid, oid, rulename, ev_class as ruletable, ev_type, is_instead, ev_enabled from pg_rewrite order by oid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 28 02 10 44ms 4ms -
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:15 Duration: 16ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:03 Duration: 7ms
-
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-28 02:01:14 Duration: 4ms
19 0ms 22ms 3ms 20 70ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 28 02 20 70ms 3ms [ User: postgres - Total duration: 69ms - Times executed: 10 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 69ms - Times executed: 10 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:16 Duration: 22ms Database: testikee User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:15 Duration: 15ms Database: temporal_visibility User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-28 02:01:02 Duration: 12ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
20 0ms 16ms 2ms 10 26ms select l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault(?, l.lanowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, l.lanowner))) as init (init_acl) where acl = init_acl)) as foo) as lanacl, ( 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(?, l.lanowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault(?, l.lanowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rlanacl, null as initlanacl, null as initrlanacl, ( select rolname from pg_catalog.pg_roles where oid = l.lanowner) as lanowner from pg_language l left join pg_init_privs pip on (l.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where l.lanispl order by l.oid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 28 02 10 26ms 2ms -
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:15 Duration: 16ms
-
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:08 Duration: 2ms
-
SELECT l.tableoid, l.oid, l.lanname, l.lanpltrusted, l.lanplcallfoid, l.laninline, l.lanvalidator, ( SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM ( SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) WITH ORDINALITY AS perm (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault('l', l.lanowner))) AS init (init_acl) WHERE acl = init_acl)) as foo) AS lanacl, ( 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('l', l.lanowner))) WITH ORDINALITY AS initp (acl, row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(l.lanacl, pg_catalog.acldefault('l', l.lanowner))) AS permp (orig_acl) WHERE acl = orig_acl)) as foo) AS rlanacl, NULL AS initlanacl, NULL AS initrlanacl, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lanowner) AS lanowner FROM pg_language l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = 'pg_language'::regclass AND pip.objsubid = 0) WHERE l.lanispl ORDER BY l.oid;
Date: 2025-11-28 02:01:03 Duration: 1ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,417 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET