pgBadger-
Global information
- Generated on Sat Nov 29 05:00:16 2025
- Log file: ssh://root@db2.cetoc.muni.cz//mnt/logpsql/var/log/postgresql/postgresql-12-main.log
- Parsed 20,133 log entries in 12s
- Log start from 2025-11-23 00:06:39 to 2025-11-29 02:01:16
-
Overview
Global Stats
- 305 Number of unique normalized queries
- 9,664 Number of queries
- 1m26s Total query duration
- 2025-11-23 02:01:03 First query
- 2025-11-29 02:01:16 Last query
- 519 queries/s at 2025-11-27 02:01:14 Query peak
- 1m26s Total query duration
- 8ms Prepare/parse total duration
- 16ms Bind total duration
- 1m26s Execute total duration
- 22 Number of events
- 2 Number of unique normalized events
- 20 Max number of times the same event was reported
- 0 Number of cancellation
- 3 Total number of automatic vacuums
- 3 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 87 Total number of sessions
- 1 sessions at 2025-11-27 02:01:02 Session peak
- 8h25m19s Total duration of sessions
- 5m48s Average duration of sessions
- 111 Average queries per session
- 993ms Average queries duration per session
- 5m47s Average idle time per session
- 87 Total number of connections
- 4 connections/s at 2025-11-24 02:01:13 Connection peak
- 11 Total number of databases
SQL Traffic
Key values
- 519 queries/s Query Peak
- 2025-11-27 02:01:14 Date
SELECT Traffic
Key values
- 379 queries/s Query Peak
- 2025-11-27 02:01:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 62 queries/s Query Peak
- 2025-11-27 02:01:14 Date
Queries duration
Key values
- 1m26s 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 23 00 0 0ms 0ms 0ms 0ms 0ms 0ms 02 1,377 0ms 3s157ms 8ms 11s585ms 11s585ms 11s585ms Nov 24 02 1,377 0ms 3s269ms 8ms 11s264ms 11s264ms 11s264ms Nov 25 02 1,377 0ms 3s112ms 8ms 11s348ms 11s348ms 11s348ms 09 25 0ms 76ms 3ms 82ms 82ms 82ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 26 02 1,377 0ms 3s308ms 9ms 13s295ms 13s295ms 13s295ms Nov 27 02 1,377 0ms 3s283ms 9ms 12s569ms 12s569ms 12s569ms Nov 28 02 1,377 0ms 3s136ms 9ms 12s935ms 12s935ms 12s935ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 29 02 1,377 0ms 3s515ms 9ms 13s351ms 13s351ms 13s351ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 23 00 0 0 0ms 0ms 0ms 0ms 02 1,003 132 10ms 9s566ms 9s566ms 9s566ms Nov 24 02 1,003 132 9ms 9s626ms 9s626ms 9s626ms Nov 25 02 1,003 132 9ms 9s900ms 9s900ms 9s900ms 09 14 0 5ms 79ms 79ms 79ms 12 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms Nov 26 02 1,003 132 11ms 10s926ms 10s926ms 10s926ms Nov 27 02 1,003 132 11ms 10s710ms 10s710ms 10s710ms Nov 28 02 1,003 132 11ms 10s551ms 10s551ms 10s551ms 09 0 0 0ms 0ms 0ms 0ms Nov 29 02 1,003 132 11ms 11s242ms 11s242ms 11s242ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 23 00 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms Nov 24 02 0 0 0 0 0ms 0ms 0ms 0ms Nov 25 02 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms Nov 26 02 0 0 0 0 0ms 0ms 0ms 0ms Nov 27 02 0 0 0 0 0ms 0ms 0ms 0ms Nov 28 02 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms Nov 29 02 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 23 00 0 0 0.00 0.00% 02 0 0 0.00 0.00% Nov 24 02 0 0 0.00 0.00% Nov 25 02 0 0 0.00 0.00% 09 25 25 1.00 178.57% 12 0 0 0.00 0.00% 14 0 0 0.00 0.00% 16 0 0 0.00 0.00% Nov 26 02 0 0 0.00 0.00% Nov 27 02 0 0 0.00 0.00% Nov 28 02 0 0 0.00 0.00% 09 0 0 0.00 0.00% Nov 29 02 0 0 0.00 0.00% Day Hour Count Average / Second Nov 23 00 0 0.00/s 02 12 0.00/s Nov 24 02 12 0.00/s Nov 25 02 12 0.00/s 09 3 0.00/s 12 0 0.00/s 14 0 0.00/s 16 0 0.00/s Nov 26 02 12 0.00/s Nov 27 02 12 0.00/s Nov 28 02 12 0.00/s 09 0 0.00/s Nov 29 02 12 0.00/s Day Hour Count Average Duration Average idle time Nov 23 00 0 0ms 0ms 02 12 1s 34ms Nov 24 02 12 975ms 36ms Nov 25 02 12 974ms 29ms 09 1 210ms 127ms 12 0 0ms 0ms 14 2 4h11m55s 4h11m55s 16 0 0ms 0ms Nov 26 02 12 1s132ms 24ms Nov 27 02 12 1s78ms 30ms Nov 28 02 12 1s99ms 21ms 09 0 0ms 0ms Nov 29 02 12 1s141ms 28ms -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2025-11-24 02:01:13 Date
Connections per database
Key values
- postgres Main Database
- 87 connections Total
Connections per user
Key values
- postgres Main User
- 87 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2025-11-27 02:01:02 Date
Histogram of session times
Key values
- 64 0-500ms duration
Sessions per database
Key values
- postgres Main Database
- 87 sessions Total
Sessions per user
Key values
- postgres Main User
- 87 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 87 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1 buffers Checkpoint Peak
- 2025-11-23 02:02:48 Date
- 3.550 seconds Highest write time
- 0.055 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2025-11-23 02:02:48 Date
Checkpoints distance
Key values
- 0.01 Mo Distance Peak
- 2025-11-23 02:02:48 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 23 00 1 2.031s 0.007s 2.096s 02 1 0.105s 0.006s 0.121s Nov 24 02 0 0s 0s 0s Nov 25 02 0 0s 0s 0s 09 0 0s 0s 0s 12 1 3.55s 0.055s 3.669s 14 0 0s 0s 0s 16 0 0s 0s 0s Nov 26 02 1 0.111s 0.005s 0.129s Nov 27 02 0 0s 0s 0s Nov 28 02 0 0s 0s 0s 09 1 2.67s 0.005s 2.721s Nov 29 02 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Nov 23 00 0 0 0 1 0.007s 0.007s 02 0 0 0 1 0.006s 0.006s Nov 24 02 0 0 0 0 0s 0s Nov 25 02 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 12 0 0 0 1 0.055s 0.055s 14 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s Nov 26 02 0 0 0 1 0.005s 0.005s Nov 27 02 0 0 0 0 0s 0s Nov 28 02 0 0 0 0 0s 0s 09 0 0 0 1 0.005s 0.005s Nov 29 02 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Nov 23 00 0 0s 02 0 0s Nov 24 02 0 0s Nov 25 02 0 0s 09 0 0s 12 0 0s 14 0 0s 16 0 0s Nov 26 02 0 0s Nov 27 02 0 0s Nov 28 02 0 0s 09 0 0s Nov 29 02 0 0s Day Hour Mean distance Mean estimate Nov 23 00 6.00 kB 13.00 kB 02 6.00 kB 12.00 kB Nov 24 02 0.00 kB 0.00 kB Nov 25 02 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 12 6.00 kB 11.00 kB 14 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB Nov 26 02 6.00 kB 11.00 kB Nov 27 02 0.00 kB 0.00 kB Nov 28 02 0.00 kB 0.00 kB 09 6.00 kB 10.00 kB Nov 29 02 0.00 kB 0.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 23 00 0 0 0 02 0 0 0 Nov 24 02 0 0 0 Nov 25 02 0 0 0 09 0 0 0 12 0 0 0 14 0 0 0 16 0 0 0 Nov 26 02 0 0 0 Nov 27 02 0 0 0 Nov 28 02 0 0 0 09 0 0 0 Nov 29 02 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database testikee - 2025-11-23 00:06:39 Date
- 0 sec Highest CPU-cost analyze
Table
Database testikee - Date
Average Autovacuum Duration
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database testikee - 2025-11-23 00:06:39 Date
Analyzes per table
Key values
- pg_catalog.pg_shdepend (2) Main table analyzed (database testikee)
- 3 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_shdepend (2) Main table vacuumed on database testikee
- 3 vacuums Total
Vacuum throughput per table
Key values
- pg_catalog.pg_shdepend (0.01) Max CPU elapsed for vacuum on database testikee
- unknown (0 ms) Max I/O read time for vacuum on database testikee
- unknown (0 ms) Max I/O write time for vacuum on database testikee
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 23 00 1 1 02 0 0 Nov 24 02 0 0 Nov 25 02 0 0 09 0 0 12 1 1 14 0 0 16 0 0 Nov 26 02 0 0 Nov 27 02 0 0 Nov 28 02 0 0 09 1 1 Nov 29 02 0 0 - 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
- 7,035 Total read queries
- 1,064 Total write queries
Queries by database
Key values
- unknown Main database
- 9,580 Requests
- 1m25s (unknown)
- Main time consuming database
Database Request type Count Duration airbyte Total 7 102ms select 7 102ms airbytev2 Total 7 20ms select 7 20ms airflow Total 7 26ms select 7 26ms airflow_db Total 7 31ms select 7 31ms opendata Total 7 14ms select 7 14ms openmetadata_db Total 7 25ms select 7 25ms postgres Total 21 147ms select 21 147ms temporal Total 7 24ms select 7 24ms temporal_visibility Total 7 40ms select 7 40ms testikee Total 7 42ms select 7 42ms unknown Total 9,580 1m25s copy to 924 1m12s cte 70 87ms others 1,565 125ms select 6,951 13s211ms tcl 70 7ms Queries by user
Key values
- unknown Main user
- 12,335 Requests
User Request type Count Duration postgres Total 108 605ms select 108 605ms unknown Total 12,335 1m52s copy to 1,188 1m34s cte 90 113ms others 2,020 140ms select 8,947 17s616ms tcl 90 8ms Duration by user
Key values
- 1m52s (unknown) Main time consuming user
User Request type Count Duration postgres Total 108 605ms select 108 605ms unknown Total 12,335 1m52s copy to 1,188 1m34s cte 90 113ms others 2,020 140ms select 8,947 17s616ms tcl 90 8ms Queries by host
Key values
- unknown Main host
- 12,443 Requests
- 1m52s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 9,580 Requests
- 1m25s (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 70 340ms select 70 340ms psql SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) Total 14 135ms select 14 135ms unknown Total 9,580 1m25s copy to 924 1m12s cte 70 87ms others 1,565 125ms select 6,951 13s211ms tcl 70 7ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-28 02:01:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 7,994 0-1ms duration
Slowest individual queries
Rank Duration Query 1 3s515ms 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-29 02:01:06 ]
2 3s320ms 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-29 02:01:12 ]
3 3s308ms 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-26 02:01:12 ]
4 3s283ms 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-27 02:01:07 ]
5 3s269ms 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-24 02:01:05 ]
6 3s241ms 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-27 02:01:12 ]
7 3s157ms 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-23 02:01:11 ]
8 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 ]
9 3s125ms 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-23 02:01:06 ]
10 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 ]
11 3s114ms 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-26 02:01:06 ]
12 3s112ms 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-25 02:01:10 ]
13 2s978ms 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-24 02:01:10 ]
14 2s821ms 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-25 02:01:05 ]
15 1s860ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-26 02:01:08 ]
16 1s834ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-29 02:01:08 ]
17 1s812ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-29 02:01:14 ]
18 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 ]
19 1s654ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-27 02:01:08 ]
20 1s653ms COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;[ Date: 2025-11-27 02:01:14 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 44s505ms 14 2s821ms 3s515ms 3s178ms 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 23 02 2 6s283ms 3s141ms Nov 24 02 2 6s248ms 3s124ms Nov 25 02 2 5s934ms 2s967ms Nov 26 02 2 6s422ms 3s211ms Nov 27 02 2 6s524ms 3s262ms Nov 28 02 2 6s256ms 3s128ms Nov 29 02 2 6s835ms 3s417ms -
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-29 02:01:06 Duration: 3s515ms
-
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-29 02:01:12 Duration: 3s320ms
-
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-26 02:01:12 Duration: 3s308ms
2 22s710ms 14 1s413ms 1s860ms 1s622ms 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 23 02 2 2s841ms 1s420ms Nov 24 02 2 2s997ms 1s498ms Nov 25 02 2 3s180ms 1s590ms Nov 26 02 2 3s434ms 1s717ms Nov 27 02 2 3s308ms 1s654ms Nov 28 02 2 3s301ms 1s650ms Nov 29 02 2 3s646ms 1s823ms -
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-26 02:01:08 Duration: 1s860ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-29 02:01:08 Duration: 1s834ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-29 02:01:14 Duration: 1s812ms
3 2s542ms 70 12ms 119ms 36ms 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 #3
Day Hour Count Duration Avg duration Nov 23 02 10 355ms 35ms Nov 24 02 10 254ms 25ms Nov 25 02 10 314ms 31ms Nov 26 02 10 416ms 41ms Nov 27 02 10 325ms 32ms Nov 28 02 10 454ms 45ms Nov 29 02 10 421ms 42ms -
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-26 02:01:16 Duration: 81ms
-
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-23 02:01:14 Duration: 68ms
4 2s84ms 70 3ms 162ms 29ms 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 #4
Day Hour Count Duration Avg duration Nov 23 02 10 293ms 29ms Nov 24 02 10 233ms 23ms Nov 25 02 10 179ms 17ms Nov 26 02 10 300ms 30ms Nov 27 02 10 260ms 26ms Nov 28 02 10 483ms 48ms Nov 29 02 10 334ms 33ms -
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-26 02:01:16 Duration: 65ms
5 2s41ms 7 32ms 472ms 291ms 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 #5
Day Hour Count Duration Avg duration Nov 23 02 1 50ms 50ms Nov 24 02 1 32ms 32ms Nov 25 02 1 351ms 351ms Nov 26 02 1 419ms 419ms Nov 27 02 1 377ms 377ms Nov 28 02 1 472ms 472ms Nov 29 02 1 337ms 337ms -
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
-
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-26 02:01:16 Duration: 419ms
-
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-27 02:01:15 Duration: 377ms
6 1s249ms 70 2ms 83ms 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 23 02 10 225ms 22ms Nov 24 02 10 177ms 17ms Nov 25 02 10 125ms 12ms Nov 26 02 10 247ms 24ms Nov 27 02 10 138ms 13ms Nov 28 02 10 170ms 17ms Nov 29 02 10 164ms 16ms -
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-23 02:01:14 Duration: 83ms
-
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-26 02:01:15 Duration: 48ms
7 950ms 14 16ms 145ms 67ms 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 #7
Day Hour Count Duration Avg duration Nov 23 02 2 163ms 81ms Nov 24 02 2 117ms 58ms Nov 25 02 2 139ms 69ms Nov 26 02 2 177ms 88ms Nov 27 02 2 142ms 71ms Nov 28 02 2 95ms 47ms Nov 29 02 2 116ms 58ms -
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-26 02:01:09 Duration: 145ms
-
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-23 02:01:08 Duration: 134ms
-
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-25 02:01:07 Duration: 116ms
8 781ms 924 0ms 16ms 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 23 02 132 110ms 0ms Nov 24 02 132 112ms 0ms Nov 25 02 132 102ms 0ms Nov 26 02 132 114ms 0ms Nov 27 02 132 125ms 0ms Nov 28 02 132 105ms 0ms Nov 29 02 132 109ms 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 = '68577'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-27 02:01:03 Duration: 16ms
-
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-23 02:01:08 Duration: 6ms
-
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-26 02:01:09 Duration: 5ms
9 657ms 70 1ms 51ms 9ms 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 23 02 10 131ms 13ms Nov 24 02 10 86ms 8ms Nov 25 02 10 49ms 4ms Nov 26 02 10 124ms 12ms Nov 27 02 10 67ms 6ms Nov 28 02 10 105ms 10ms Nov 29 02 10 91ms 9ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-23 02:01:14 Duration: 51ms
-
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-29 02:01:14 Duration: 23ms
10 624ms 70 4ms 20ms 8ms 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 #10
Day Hour Count Duration Avg duration Nov 23 02 10 85ms 8ms Nov 24 02 10 89ms 8ms Nov 25 02 10 73ms 7ms Nov 26 02 10 89ms 8ms Nov 27 02 10 82ms 8ms Nov 28 02 10 100ms 10ms Nov 29 02 10 102ms 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-29 02:01:08 Duration: 20ms
-
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
11 588ms 35 4ms 46ms 16ms select description, classoid, objoid, objsubid from pg_catalog.pg_description order by classoid, objoid, objsubid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 23 02 5 62ms 12ms Nov 24 02 5 81ms 16ms Nov 25 02 5 57ms 11ms Nov 26 02 5 126ms 25ms Nov 27 02 5 79ms 15ms Nov 28 02 5 97ms 19ms Nov 29 02 5 84ms 16ms -
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-26 02:01:16 Duration: 41ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-26 02:01:17 Duration: 35ms
12 572ms 70 1ms 36ms 8ms 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 23 02 10 75ms 7ms Nov 24 02 10 52ms 5ms Nov 25 02 10 53ms 5ms Nov 26 02 10 91ms 9ms Nov 27 02 10 86ms 8ms Nov 28 02 10 124ms 12ms Nov 29 02 10 88ms 8ms -
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 536ms 70 0ms 19ms 7ms select classid, objid, refobjid from pg_depend where refclassid = ?::regclass and deptype = ? order by ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 23 02 10 75ms 7ms Nov 24 02 10 54ms 5ms Nov 25 02 10 52ms 5ms Nov 26 02 10 95ms 9ms Nov 27 02 10 74ms 7ms Nov 28 02 10 91ms 9ms Nov 29 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-27 02:01:03 Duration: 19ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
14 487ms 14 21ms 55ms 34ms 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 #14
Day Hour Count Duration Avg duration Nov 23 02 2 54ms 27ms Nov 24 02 2 76ms 38ms Nov 25 02 2 58ms 29ms Nov 26 02 2 93ms 46ms Nov 27 02 2 57ms 28ms Nov 28 02 2 71ms 35ms Nov 29 02 2 75ms 37ms -
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-24 02:01:02 Duration: 55ms
-
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-26 02:01:09 Duration: 55ms
-
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-29 02:01:09 Duration: 42ms
15 466ms 70 0ms 23ms 6ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 23 02 10 59ms 5ms Nov 24 02 10 43ms 4ms Nov 25 02 10 60ms 6ms Nov 26 02 10 84ms 8ms Nov 27 02 10 57ms 5ms Nov 28 02 10 75ms 7ms Nov 29 02 10 84ms 8ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-26 02:01:16 Duration: 23ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-27 02:01:03 Duration: 18ms
-
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
16 396ms 70 0ms 30ms 5ms 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 23 02 10 47ms 4ms Nov 24 02 10 36ms 3ms Nov 25 02 10 43ms 4ms Nov 26 02 10 58ms 5ms Nov 27 02 10 51ms 5ms Nov 28 02 10 79ms 7ms Nov 29 02 10 80ms 8ms -
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-29 02:01:15 Duration: 17ms
-
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-29 02:01:15 Duration: 14ms
17 368ms 14 17ms 47ms 26ms copy public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 23 02 2 48ms 24ms Nov 24 02 2 37ms 18ms Nov 25 02 2 65ms 32ms Nov 26 02 2 51ms 25ms Nov 27 02 2 69ms 34ms Nov 28 02 2 47ms 23ms Nov 29 02 2 50ms 25ms -
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-27 02:01:03 Duration: 47ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-25 02:01:02 Duration: 40ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-26 02:01:03 Duration: 26ms
18 343ms 140 0ms 24ms 2ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 23 02 20 35ms 1ms Nov 24 02 20 45ms 2ms Nov 25 02 20 44ms 2ms Nov 26 02 20 51ms 2ms Nov 27 02 20 39ms 1ms Nov 28 02 20 70ms 3ms Nov 29 02 20 58ms 2ms [ User: postgres - Total duration: 340ms - Times executed: 70 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 340ms - Times executed: 70 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-24 02:01:02 Duration: 24ms Database: airbyte 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: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-27 02:01:03 Duration: 16ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
19 288ms 924 0ms 3ms 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 #19
Day Hour Count Duration Avg duration Nov 23 02 132 38ms 0ms Nov 24 02 132 39ms 0ms Nov 25 02 132 39ms 0ms Nov 26 02 132 44ms 0ms Nov 27 02 132 40ms 0ms Nov 28 02 132 42ms 0ms Nov 29 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 = '66071'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-26 02:01:17 Duration: 3ms
-
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 = '66099'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-26 02:01:15 Duration: 3ms
-
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
20 266ms 7 3ms 100ms 38ms copy public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 23 02 1 5ms 5ms Nov 24 02 1 3ms 3ms Nov 25 02 1 22ms 22ms Nov 26 02 1 94ms 94ms Nov 27 02 1 23ms 23ms Nov 28 02 1 100ms 100ms Nov 29 02 1 16ms 16ms -
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 100ms
-
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-26 02:01:16 Duration: 94ms
-
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-27 02:01:15 Duration: 23ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 924 781ms 0ms 16ms 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 23 02 132 110ms 0ms Nov 24 02 132 112ms 0ms Nov 25 02 132 102ms 0ms Nov 26 02 132 114ms 0ms Nov 27 02 132 125ms 0ms Nov 28 02 132 105ms 0ms Nov 29 02 132 109ms 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 = '68577'::pg_catalog.oid AND (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY indexname;
Date: 2025-11-27 02:01:03 Duration: 16ms
-
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-23 02:01:08 Duration: 6ms
-
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-26 02:01:09 Duration: 5ms
2 924 288ms 0ms 3ms 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 23 02 132 38ms 0ms Nov 24 02 132 39ms 0ms Nov 25 02 132 39ms 0ms Nov 26 02 132 44ms 0ms Nov 27 02 132 40ms 0ms Nov 28 02 132 42ms 0ms Nov 29 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 = '66071'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-26 02:01:17 Duration: 3ms
-
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 = '66099'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum;
Date: 2025-11-26 02:01:15 Duration: 3ms
-
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
3 602 133ms 0ms 5ms 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 23 02 86 19ms 0ms Nov 24 02 86 25ms 0ms Nov 25 02 86 15ms 0ms Nov 26 02 86 14ms 0ms Nov 27 02 86 20ms 0ms Nov 28 02 86 18ms 0ms Nov 29 02 86 19ms 0ms -
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-24 02:01:02 Duration: 5ms
-
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-29 02:01:02 Duration: 3ms
-
SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '65367'::pg_catalog.oid;
Date: 2025-11-24 02:01:12 Duration: 3ms
4 504 106ms 0ms 4ms 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 23 02 72 14ms 0ms Nov 24 02 72 13ms 0ms Nov 25 02 72 13ms 0ms Nov 26 02 72 19ms 0ms Nov 27 02 72 15ms 0ms Nov 28 02 72 14ms 0ms Nov 29 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 = '68577'::pg_catalog.oid AND (NOT t.tgisinternal);
Date: 2025-11-26 02:01:03 Duration: 4ms
-
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-27 02:01:03 Duration: 2ms
-
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-26 02:01:09 Duration: 2ms
5 504 43ms 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 23 02 72 6ms 0ms Nov 24 02 72 6ms 0ms Nov 25 02 72 6ms 0ms Nov 26 02 72 6ms 0ms Nov 27 02 72 6ms 0ms Nov 28 02 72 6ms 0ms Nov 29 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 = '35225'::pg_catalog.oid AND conparentid = 0 AND contype = 'f';
Date: 2025-11-29 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-26 02:01:03 Duration: 0ms
6 238 22ms 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 23 02 34 3ms 0ms Nov 24 02 34 2ms 0ms Nov 25 02 34 2ms 0ms Nov 26 02 34 4ms 0ms Nov 27 02 34 2ms 0ms Nov 28 02 34 3ms 0ms Nov 29 02 34 2ms 0ms -
SELECT oid, enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = '68435' ORDER BY enumsortorder;
Date: 2025-11-26 02:01:03 Duration: 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-26 02:01:09 Duration: 0ms
7 217 29ms 0ms 2ms 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 23 02 31 4ms 0ms Nov 24 02 31 6ms 0ms Nov 25 02 31 4ms 0ms Nov 26 02 31 2ms 0ms Nov 27 02 31 4ms 0ms Nov 28 02 31 3ms 0ms Nov 29 02 31 3ms 0ms -
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '35276'::oid;
Date: 2025-11-25 02:01:07 Duration: 2ms
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '68649'::oid;
Date: 2025-11-24 02:01:02 Duration: 2ms
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '66111'::oid;
Date: 2025-11-23 02:01:15 Duration: 2ms
8 140 343ms 0ms 24ms 2ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 23 02 20 35ms 1ms Nov 24 02 20 45ms 2ms Nov 25 02 20 44ms 2ms Nov 26 02 20 51ms 2ms Nov 27 02 20 39ms 1ms Nov 28 02 20 70ms 3ms Nov 29 02 20 58ms 2ms [ User: postgres - Total duration: 340ms - Times executed: 70 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 340ms - Times executed: 70 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-24 02:01:02 Duration: 24ms Database: airbyte 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: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-27 02:01:03 Duration: 16ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
9 70 2s542ms 12ms 119ms 36ms 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 #9
Day Hour Count Duration Avg duration Nov 23 02 10 355ms 35ms Nov 24 02 10 254ms 25ms Nov 25 02 10 314ms 31ms Nov 26 02 10 416ms 41ms Nov 27 02 10 325ms 32ms Nov 28 02 10 454ms 45ms Nov 29 02 10 421ms 42ms -
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-26 02:01:16 Duration: 81ms
-
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-23 02:01:14 Duration: 68ms
10 70 2s84ms 3ms 162ms 29ms 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 #10
Day Hour Count Duration Avg duration Nov 23 02 10 293ms 29ms Nov 24 02 10 233ms 23ms Nov 25 02 10 179ms 17ms Nov 26 02 10 300ms 30ms Nov 27 02 10 260ms 26ms Nov 28 02 10 483ms 48ms Nov 29 02 10 334ms 33ms -
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-26 02:01:16 Duration: 65ms
11 70 1s249ms 2ms 83ms 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 23 02 10 225ms 22ms Nov 24 02 10 177ms 17ms Nov 25 02 10 125ms 12ms Nov 26 02 10 247ms 24ms Nov 27 02 10 138ms 13ms Nov 28 02 10 170ms 17ms Nov 29 02 10 164ms 16ms -
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-23 02:01:14 Duration: 83ms
-
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-26 02:01:15 Duration: 48ms
12 70 657ms 1ms 51ms 9ms 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 #12
Day Hour Count Duration Avg duration Nov 23 02 10 131ms 13ms Nov 24 02 10 86ms 8ms Nov 25 02 10 49ms 4ms Nov 26 02 10 124ms 12ms Nov 27 02 10 67ms 6ms Nov 28 02 10 105ms 10ms Nov 29 02 10 91ms 9ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-23 02:01:14 Duration: 51ms
-
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-29 02:01:14 Duration: 23ms
13 70 624ms 4ms 20ms 8ms 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 #13
Day Hour Count Duration Avg duration Nov 23 02 10 85ms 8ms Nov 24 02 10 89ms 8ms Nov 25 02 10 73ms 7ms Nov 26 02 10 89ms 8ms Nov 27 02 10 82ms 8ms Nov 28 02 10 100ms 10ms Nov 29 02 10 102ms 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-29 02:01:08 Duration: 20ms
-
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
14 70 572ms 1ms 36ms 8ms 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 #14
Day Hour Count Duration Avg duration Nov 23 02 10 75ms 7ms Nov 24 02 10 52ms 5ms Nov 25 02 10 53ms 5ms Nov 26 02 10 91ms 9ms Nov 27 02 10 86ms 8ms Nov 28 02 10 124ms 12ms Nov 29 02 10 88ms 8ms -
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
15 70 536ms 0ms 19ms 7ms 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 23 02 10 75ms 7ms Nov 24 02 10 54ms 5ms Nov 25 02 10 52ms 5ms Nov 26 02 10 95ms 9ms Nov 27 02 10 74ms 7ms Nov 28 02 10 91ms 9ms Nov 29 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-27 02:01:03 Duration: 19ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
16 70 466ms 0ms 23ms 6ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 23 02 10 59ms 5ms Nov 24 02 10 43ms 4ms Nov 25 02 10 60ms 6ms Nov 26 02 10 84ms 8ms Nov 27 02 10 57ms 5ms Nov 28 02 10 75ms 7ms Nov 29 02 10 84ms 8ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-26 02:01:16 Duration: 23ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-27 02:01:03 Duration: 18ms
-
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
17 70 396ms 0ms 30ms 5ms 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 #17
Day Hour Count Duration Avg duration Nov 23 02 10 47ms 4ms Nov 24 02 10 36ms 3ms Nov 25 02 10 43ms 4ms Nov 26 02 10 58ms 5ms Nov 27 02 10 51ms 5ms Nov 28 02 10 79ms 7ms Nov 29 02 10 80ms 8ms -
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-29 02:01:15 Duration: 17ms
-
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-29 02:01:15 Duration: 14ms
18 70 263ms 0ms 26ms 3ms 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 23 02 10 69ms 6ms Nov 24 02 10 18ms 1ms Nov 25 02 10 16ms 1ms Nov 26 02 10 56ms 5ms Nov 27 02 10 30ms 3ms Nov 28 02 10 44ms 4ms Nov 29 02 10 28ms 2ms -
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-23 02:01:14 Duration: 26ms
-
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-23 02:01:14 Duration: 14ms
19 70 154ms 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 #19
Day Hour Count Duration Avg duration Nov 23 02 10 22ms 2ms Nov 24 02 10 21ms 2ms Nov 25 02 10 19ms 1ms Nov 26 02 10 20ms 2ms Nov 27 02 10 20ms 2ms Nov 28 02 10 26ms 2ms Nov 29 02 10 24ms 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-29 02:01:15 Duration: 4ms
20 70 126ms 0ms 11ms 1ms select tableoid, oid, conname, connamespace, ( select rolname from pg_catalog.pg_roles where oid = conowner) as rolname from pg_conversion;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 23 02 10 32ms 3ms Nov 24 02 10 17ms 1ms Nov 25 02 10 7ms 0ms Nov 26 02 10 27ms 2ms Nov 27 02 10 14ms 1ms Nov 28 02 10 12ms 1ms Nov 29 02 10 13ms 1ms -
SELECT tableoid, oid, conname, connamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = conowner) AS rolname FROM pg_conversion;
Date: 2025-11-23 02:01:14 Duration: 11ms
-
SELECT tableoid, oid, conname, connamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = conowner) AS rolname FROM pg_conversion;
Date: 2025-11-23 02:01:14 Duration: 10ms
-
SELECT tableoid, oid, conname, connamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = conowner) AS rolname FROM pg_conversion;
Date: 2025-11-26 02:01:15 Duration: 6ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s821ms 3s515ms 3s178ms 14 44s505ms 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 23 02 2 6s283ms 3s141ms Nov 24 02 2 6s248ms 3s124ms Nov 25 02 2 5s934ms 2s967ms Nov 26 02 2 6s422ms 3s211ms Nov 27 02 2 6s524ms 3s262ms Nov 28 02 2 6s256ms 3s128ms Nov 29 02 2 6s835ms 3s417ms -
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-29 02:01:06 Duration: 3s515ms
-
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-29 02:01:12 Duration: 3s320ms
-
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-26 02:01:12 Duration: 3s308ms
2 1s413ms 1s860ms 1s622ms 14 22s710ms 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 23 02 2 2s841ms 1s420ms Nov 24 02 2 2s997ms 1s498ms Nov 25 02 2 3s180ms 1s590ms Nov 26 02 2 3s434ms 1s717ms Nov 27 02 2 3s308ms 1s654ms Nov 28 02 2 3s301ms 1s650ms Nov 29 02 2 3s646ms 1s823ms -
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-26 02:01:08 Duration: 1s860ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-29 02:01:08 Duration: 1s834ms
-
COPY public.jobs (id, config_type, scope, config, status, started_at, created_at, updated_at) TO stdout;
Date: 2025-11-29 02:01:14 Duration: 1s812ms
3 32ms 472ms 291ms 7 2s41ms 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 23 02 1 50ms 50ms Nov 24 02 1 32ms 32ms Nov 25 02 1 351ms 351ms Nov 26 02 1 419ms 419ms Nov 27 02 1 377ms 377ms Nov 28 02 1 472ms 472ms Nov 29 02 1 337ms 337ms -
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
-
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-26 02:01:16 Duration: 419ms
-
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-27 02:01:15 Duration: 377ms
4 16ms 145ms 67ms 14 950ms 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 #4
Day Hour Count Duration Avg duration Nov 23 02 2 163ms 81ms Nov 24 02 2 117ms 58ms Nov 25 02 2 139ms 69ms Nov 26 02 2 177ms 88ms Nov 27 02 2 142ms 71ms Nov 28 02 2 95ms 47ms Nov 29 02 2 116ms 58ms -
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-26 02:01:09 Duration: 145ms
-
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-23 02:01:08 Duration: 134ms
-
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-25 02:01:07 Duration: 116ms
5 3ms 100ms 38ms 7 266ms copy public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 23 02 1 5ms 5ms Nov 24 02 1 3ms 3ms Nov 25 02 1 22ms 22ms Nov 26 02 1 94ms 94ms Nov 27 02 1 23ms 23ms Nov 28 02 1 100ms 100ms Nov 29 02 1 16ms 16ms -
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-28 02:01:15 Duration: 100ms
-
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-26 02:01:16 Duration: 94ms
-
COPY public.timer_tasks (shard_id, visibility_timestamp, task_id, data, data_encoding) TO stdout;
Date: 2025-11-27 02:01:15 Duration: 23ms
6 12ms 119ms 36ms 70 2s542ms 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 #6
Day Hour Count Duration Avg duration Nov 23 02 10 355ms 35ms Nov 24 02 10 254ms 25ms Nov 25 02 10 314ms 31ms Nov 26 02 10 416ms 41ms Nov 27 02 10 325ms 32ms Nov 28 02 10 454ms 45ms Nov 29 02 10 421ms 42ms -
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-26 02:01:16 Duration: 81ms
-
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-23 02:01:14 Duration: 68ms
7 21ms 55ms 34ms 14 487ms 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 #7
Day Hour Count Duration Avg duration Nov 23 02 2 54ms 27ms Nov 24 02 2 76ms 38ms Nov 25 02 2 58ms 29ms Nov 26 02 2 93ms 46ms Nov 27 02 2 57ms 28ms Nov 28 02 2 71ms 35ms Nov 29 02 2 75ms 37ms -
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-24 02:01:02 Duration: 55ms
-
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-26 02:01:09 Duration: 55ms
-
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-29 02:01:09 Duration: 42ms
8 3ms 162ms 29ms 70 2s84ms 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 #8
Day Hour Count Duration Avg duration Nov 23 02 10 293ms 29ms Nov 24 02 10 233ms 23ms Nov 25 02 10 179ms 17ms Nov 26 02 10 300ms 30ms Nov 27 02 10 260ms 26ms Nov 28 02 10 483ms 48ms Nov 29 02 10 334ms 33ms -
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-26 02:01:16 Duration: 65ms
9 17ms 47ms 26ms 14 368ms 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 23 02 2 48ms 24ms Nov 24 02 2 37ms 18ms Nov 25 02 2 65ms 32ms Nov 26 02 2 51ms 25ms Nov 27 02 2 69ms 34ms Nov 28 02 2 47ms 23ms Nov 29 02 2 50ms 25ms -
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-27 02:01:03 Duration: 47ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-25 02:01:02 Duration: 40ms
-
COPY public.actor_catalog (id, catalog, catalog_hash, created_at, modified_at) TO stdout;
Date: 2025-11-26 02:01:03 Duration: 26ms
10 2ms 83ms 17ms 70 1s249ms 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 #10
Day Hour Count Duration Avg duration Nov 23 02 10 225ms 22ms Nov 24 02 10 177ms 17ms Nov 25 02 10 125ms 12ms Nov 26 02 10 247ms 24ms Nov 27 02 10 138ms 13ms Nov 28 02 10 170ms 17ms Nov 29 02 10 164ms 16ms -
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-23 02:01:14 Duration: 83ms
-
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-26 02:01:15 Duration: 48ms
11 4ms 46ms 16ms 35 588ms select description, classoid, objoid, objsubid from pg_catalog.pg_description order by classoid, objoid, objsubid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 23 02 5 62ms 12ms Nov 24 02 5 81ms 16ms Nov 25 02 5 57ms 11ms Nov 26 02 5 126ms 25ms Nov 27 02 5 79ms 15ms Nov 28 02 5 97ms 19ms Nov 29 02 5 84ms 16ms -
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-26 02:01:16 Duration: 41ms
-
SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid;
Date: 2025-11-26 02:01:17 Duration: 35ms
12 1ms 51ms 9ms 70 657ms 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 #12
Day Hour Count Duration Avg duration Nov 23 02 10 131ms 13ms Nov 24 02 10 86ms 8ms Nov 25 02 10 49ms 4ms Nov 26 02 10 124ms 12ms Nov 27 02 10 67ms 6ms Nov 28 02 10 105ms 10ms Nov 29 02 10 91ms 9ms -
SELECT tableoid, oid, collname, collnamespace, ( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = collowner) AS rolname FROM pg_collation;
Date: 2025-11-23 02:01:14 Duration: 51ms
-
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-29 02:01:14 Duration: 23ms
13 4ms 20ms 8ms 70 624ms 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 #13
Day Hour Count Duration Avg duration Nov 23 02 10 85ms 8ms Nov 24 02 10 89ms 8ms Nov 25 02 10 73ms 7ms Nov 26 02 10 89ms 8ms Nov 27 02 10 82ms 8ms Nov 28 02 10 100ms 10ms Nov 29 02 10 102ms 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-29 02:01:08 Duration: 20ms
-
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
14 1ms 36ms 8ms 70 572ms 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 #14
Day Hour Count Duration Avg duration Nov 23 02 10 75ms 7ms Nov 24 02 10 52ms 5ms Nov 25 02 10 53ms 5ms Nov 26 02 10 91ms 9ms Nov 27 02 10 86ms 8ms Nov 28 02 10 124ms 12ms Nov 29 02 10 88ms 8ms -
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
15 0ms 19ms 7ms 70 536ms 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 23 02 10 75ms 7ms Nov 24 02 10 54ms 5ms Nov 25 02 10 52ms 5ms Nov 26 02 10 95ms 9ms Nov 27 02 10 74ms 7ms Nov 28 02 10 91ms 9ms Nov 29 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-27 02:01:03 Duration: 19ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
-
SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3;
Date: 2025-11-23 02:01:14 Duration: 17ms
16 0ms 23ms 6ms 70 466ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 23 02 10 59ms 5ms Nov 24 02 10 43ms 4ms Nov 25 02 10 60ms 6ms Nov 26 02 10 84ms 8ms Nov 27 02 10 57ms 5ms Nov 28 02 10 75ms 7ms Nov 29 02 10 84ms 8ms -
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-26 02:01:16 Duration: 23ms
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-11-27 02:01:03 Duration: 18ms
-
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
17 0ms 30ms 5ms 70 396ms 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 #17
Day Hour Count Duration Avg duration Nov 23 02 10 47ms 4ms Nov 24 02 10 36ms 3ms Nov 25 02 10 43ms 4ms Nov 26 02 10 58ms 5ms Nov 27 02 10 51ms 5ms Nov 28 02 10 79ms 7ms Nov 29 02 10 80ms 8ms -
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-29 02:01:15 Duration: 17ms
-
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-29 02:01:15 Duration: 14ms
18 0ms 26ms 3ms 70 263ms 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 23 02 10 69ms 6ms Nov 24 02 10 18ms 1ms Nov 25 02 10 16ms 1ms Nov 26 02 10 56ms 5ms Nov 27 02 10 30ms 3ms Nov 28 02 10 44ms 4ms Nov 29 02 10 28ms 2ms -
SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid;
Date: 2025-11-23 02:01:14 Duration: 26ms
-
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-23 02:01:14 Duration: 14ms
19 0ms 24ms 2ms 140 343ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 23 02 20 35ms 1ms Nov 24 02 20 45ms 2ms Nov 25 02 20 44ms 2ms Nov 26 02 20 51ms 2ms Nov 27 02 20 39ms 1ms Nov 28 02 20 70ms 3ms Nov 29 02 20 58ms 2ms [ User: postgres - Total duration: 340ms - Times executed: 70 ]
[ Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off) - Total duration: 340ms - Times executed: 70 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-11-24 02:01:02 Duration: 24ms Database: airbyte 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: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-27 02:01:03 Duration: 16ms Database: airbyte User: postgres Application: pg_dump SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)
20 1ms 4ms 2ms 70 154ms 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 23 02 10 22ms 2ms Nov 24 02 10 21ms 2ms Nov 25 02 10 19ms 1ms Nov 26 02 10 20ms 2ms Nov 27 02 10 20ms 2ms Nov 28 02 10 26ms 2ms Nov 29 02 10 24ms 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-29 02:01:15 Duration: 4ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5ms 2 2ms 2ms 2ms SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Nov 29 09 2 5ms 2ms -
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-11-25 09:58:25 Duration: 2ms Database: postgres
2 4ms 2 2ms 2ms 2ms SELECT version();Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 08 2 4ms 2ms -
SELECT version();
Date: 2025-11-25 09:58:25 Duration: 2ms Database: postgres
3 1ms 2 0ms 0ms 0ms SELECT db.oid, db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname = $1;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 2 1ms 0ms -
SELECT db.oid, db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname = $1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
4 1ms 2 0ms 0ms 0ms select * from pg_catalog.pg_settings where name = $1;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 08 2 1ms 0ms -
select * from pg_catalog.pg_settings where name = $1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
5 0ms 2 0ms 0ms 0ms SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
6 0ms 2 0ms 0ms 0ms SELECT t.oid, t.*, c.relkind, format_type(nullif (t.typbasetype, 0), t.typtypmod) as base_type_name, d.description;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT t.oid, t.*, c.relkind, format_type(nullif (t.typbasetype, 0), t.typtypmod) as base_type_name, d.description;
Date: 2025-11-25 09:58:26 Duration: 0ms Database: postgres
7 0ms 4 0ms 0ms 0ms SELECT current_schema(), session_user;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 08 4 0ms 0ms -
SELECT current_schema(), session_user;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SELECT current_schema(), session_user;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
8 0ms 2 0ms 0ms 0ms select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
9 0ms 2 0ms 0ms 0ms SELECT n.nspname = ANY (current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT n.nspname = ANY (current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
10 0ms 6 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 08 6 0ms 0ms -
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
11 0ms 2 0ms 0ms 0ms SELECT current_database();Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT current_database();
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
12 0ms 2 0ms 0ms 0ms SELECT * FROM pg_catalog.pg_enum WHERE 1 <> 1 LIMIT 1;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT * FROM pg_catalog.pg_enum WHERE 1 <> 1 LIMIT 1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
13 0ms 2 0ms 0ms 0ms SELECT reltype FROM pg_catalog.pg_class WHERE 1 <> 1 LIMIT 1;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT reltype FROM pg_catalog.pg_class WHERE 1 <> 1 LIMIT 1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
14 0ms 2 0ms 0ms 0ms SELECT * FROM pg_catalog.pg_enum;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT * FROM pg_catalog.pg_enum;
Date: 2025-11-25 09:58:26 Duration: 0ms Database: postgres
15 0ms 4 0ms 0ms 0ms SHOW search_path;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 08 4 0ms 0ms -
SHOW search_path;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SHOW search_path;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
16 0ms 6 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 08 6 0ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
17 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Read PostgreSQL database list';Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Read PostgreSQL database list';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
18 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Metadata <postgres>';Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Metadata <postgres>';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
19 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Main <postgres>';Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Main <postgres>';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 17ms 2 8ms 8ms 8ms SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n LEFT OUTER JOIN pg_catalog.pg_description d ON d.objoid = n.oid AND d.objsubid = 0 AND d.classoid = 'pg_namespace'::regclass ORDER BY nspname;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Nov 29 09 2 17ms 8ms -
SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n LEFT OUTER JOIN pg_catalog.pg_description d ON d.objoid = n.oid AND d.objsubid = 0 AND d.classoid = 'pg_namespace'::regclass ORDER BY nspname;
Date: 2025-11-25 09:58:25 Duration: 8ms Database: postgres
2 6ms 2 3ms 3ms 3ms SELECT t.oid, t.*, c.relkind, format_type(nullif (t.typbasetype, 0), t.typtypmod) as base_type_name, d.description FROM pg_catalog.pg_type t LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid = t.typelem LEFT OUTER JOIN pg_catalog.pg_class c ON c.oid = t.typrelid LEFT OUTER JOIN pg_catalog.pg_description d ON t.oid = d.objoid WHERE t.typname IS NOT NULL AND (c.relkind IS NULL OR c.relkind = 'c') AND (et.typcategory IS NULL OR et.typcategory <> 'C');Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 08 2 6ms 3ms -
SELECT t.oid, t.*, c.relkind, format_type(nullif (t.typbasetype, 0), t.typtypmod) as base_type_name, d.description FROM pg_catalog.pg_type t LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid = t.typelem LEFT OUTER JOIN pg_catalog.pg_class c ON c.oid = t.typrelid LEFT OUTER JOIN pg_catalog.pg_description d ON t.oid = d.objoid WHERE t.typname IS NOT NULL AND (c.relkind IS NULL OR c.relkind = 'c') AND (et.typcategory IS NULL OR et.typcategory <> 'C');
Date: 2025-11-25 09:58:26 Duration: 3ms Database: postgres
3 6ms 2 3ms 3ms 3ms SELECT * FROM pg_catalog.pg_enum WHERE 1 <> 1 LIMIT 1;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 08 2 6ms 3ms -
SELECT * FROM pg_catalog.pg_enum WHERE 1 <> 1 LIMIT 1;
Date: 2025-11-25 09:58:25 Duration: 3ms Database: postgres
4 0ms 2 0ms 0ms 0ms SELECT db.oid, db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname = $1 ORDER BY db.datname;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT db.oid, db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname = $1 ORDER BY db.datname;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres parameters: $1 = 'postgres'
5 0ms 2 0ms 0ms 0ms SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres parameters: $1 = '1034'
6 0ms 2 0ms 0ms 0ms select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
7 0ms 2 0ms 0ms 0ms SELECT n.nspname = ANY (current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT n.nspname = ANY (current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres parameters: $1 = '1034'
8 0ms 2 0ms 0ms 0ms select * from pg_catalog.pg_settings where name = $1;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
select * from pg_catalog.pg_settings where name = $1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres parameters: $1 = 'standard_conforming_strings'
9 0ms 2 0ms 0ms 0ms SELECT reltype FROM pg_catalog.pg_class WHERE 1 <> 1 LIMIT 1;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT reltype FROM pg_catalog.pg_class WHERE 1 <> 1 LIMIT 1;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
10 0ms 4 0ms 0ms 0ms SELECT current_schema(), session_user;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 08 4 0ms 0ms -
SELECT current_schema(), session_user;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SELECT current_schema(), session_user;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
11 0ms 2 0ms 0ms 0ms SELECT * FROM pg_catalog.pg_enum;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT * FROM pg_catalog.pg_enum;
Date: 2025-11-25 09:58:26 Duration: 0ms Database: postgres
12 0ms 6 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 08 6 0ms 0ms -
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
13 0ms 2 0ms 0ms 0ms SELECT current_database();Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT current_database();
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
14 0ms 2 0ms 0ms 0ms SELECT version();Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SELECT version();
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
15 0ms 6 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 08 6 0ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
16 0ms 4 0ms 0ms 0ms SHOW search_path;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 08 4 0ms 0ms -
SHOW search_path;
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
17 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Metadata <postgres>';Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Metadata <postgres>';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
18 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Read PostgreSQL database list';Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Read PostgreSQL database list';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
19 0ms 2 0ms 0ms 0ms SET application_name = 'DBeaver 25.2.5 - Main <postgres>';Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 08 2 0ms 0ms -
SET application_name = 'DBeaver 25.2.5 - Main <postgres>';
Date: 2025-11-25 09:58:25 Duration: 0ms Database: postgres
-
Events
Log levels
Key values
- 10,061 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 20 Max number of times the same event was reported
- 22 Total events found
Rank Times reported Error 1 20 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 25 09 2 16 18 - FATAL: password authentication failed for user "smetanova"
- FATAL: password authentication failed for user "prasilova"
Detail: Role "smetanova" does not exist. Connection matched pg_hba.conf line 214: "host all all 100.67.130.0/24 md5 #eduvpn Power Users"
Date: 2025-11-25 09:34:48
Detail: Role "prasilova" does not exist. Connection matched pg_hba.conf line 214: "host all all 100.67.130.0/24 md5 #eduvpn Power Users"
Date: 2025-11-25 16:23:20
2 2 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 25 14 2