pgBadger-
Global information
- Generated on Tue Jul 29 04:10:03 2025
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20250728
- Parsed 1,530 log entries in 2s
- Log start from 2025-07-28 00:00:48 to 2025-07-28 23:33:26
-
Overview
Global Stats
- 6 Number of unique normalized queries
- 55 Number of queries
- 22m22s Total query duration
- 2025-07-28 00:30:04 First query
- 2025-07-28 23:33:26 Last query
- 1 queries/s at 2025-07-28 06:54:33 Query peak
- 22m22s Total query duration
- 0ms Prepare/parse total duration
- 13s788ms Bind total duration
- 22m8s Execute total duration
- 67 Number of events
- 4 Number of unique normalized events
- 41 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 125 Total number of sessions
- 21 sessions at 2025-07-28 16:30:41 Session peak
- 12d7h45s Total duration of sessions
- 2h21m36s Average duration of sessions
- 0 Average queries per session
- 10s736ms Average queries duration per session
- 2h21m25s Average idle time per session
- 139 Total number of connections
- 9 connections/s at 2025-07-28 11:15:48 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-28 06:54:33 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-28 06:54:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-28 09:17:11 Date
Queries duration
Key values
- 22m22s 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) Jul 28 00 2 0ms 2m19s 1m22s 2m19s 2m19s 2m19s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 2 0ms 31s447ms 28s928ms 31s447ms 31s447ms 31s447ms 03 1 37s195ms 37s195ms 37s195ms 37s195ms 37s195ms 37s195ms 04 1 0ms 37s497ms 37s497ms 37s497ms 37s497ms 37s497ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 3 0ms 46s67ms 19s728ms 46s67ms 46s67ms 46s67ms 07 5 0ms 2m16s 44s882ms 2m16s 2m16s 2m16s 08 3 0ms 46s90ms 32s392ms 46s90ms 46s90ms 46s90ms 09 3 0ms 25s672ms 11s126ms 25s672ms 25s672ms 25s672ms 10 7 0ms 45s941ms 13s995ms 45s941ms 45s941ms 45s941ms 11 14 0ms 26s861ms 6s186ms 26s474ms 26s861ms 26s861ms 12 1 0ms 33s535ms 33s535ms 33s535ms 33s535ms 33s535ms 13 1 0ms 22s908ms 22s908ms 22s908ms 22s908ms 22s908ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 8 0ms 2m14s 35s951ms 2m14s 2m14s 2m14s 17 1 0ms 45s662ms 45s662ms 45s662ms 45s662ms 45s662ms 18 1 0ms 23s278ms 23s278ms 23s278ms 23s278ms 23s278ms 19 1 6s603ms 6s603ms 6s603ms 6s603ms 6s603ms 6s603ms 23 1 11s524ms 11s524ms 11s524ms 11s524ms 11s524ms 11s524ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 00 2 0 1m22s 26s800ms 2m19s 2m19s 01 0 0 0ms 0ms 0ms 0ms 02 2 0 28s928ms 26s409ms 31s447ms 31s447ms 03 1 0 37s195ms 37s195ms 37s195ms 37s195ms 04 1 0 37s497ms 37s497ms 37s497ms 37s497ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 19s728ms 46s67ms 46s67ms 46s67ms 07 5 0 44s882ms 38s209ms 2m16s 2m16s 08 3 0 32s392ms 45s615ms 46s90ms 46s90ms 09 2 0 14s789ms 25s672ms 25s672ms 25s672ms 10 4 0 22s569ms 37s547ms 45s941ms 45s941ms 11 3 0 18s313ms 1s606ms 26s474ms 26s861ms 12 1 0 33s535ms 33s535ms 33s535ms 33s535ms 13 1 0 22s908ms 22s908ms 22s908ms 22s908ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 8 0 35s951ms 1m12s 2m14s 2m14s 17 1 0 45s662ms 45s662ms 45s662ms 45s662ms 18 1 0 23s278ms 23s278ms 23s278ms 23s278ms 19 1 0 6s603ms 6s603ms 6s603ms 6s603ms 23 1 0 11s524ms 11s524ms 11s524ms 11s524ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 28 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 2 2.00 0.00% 10 0 5 5.00 0.00% 11 0 11 11.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 28 00 4 0.00/s 01 0 0.00/s 02 1 0.00/s 03 0 0.00/s 04 0 0.00/s 05 2 0.00/s 06 1 0.00/s 07 1 0.00/s 08 8 0.00/s 09 1 0.00/s 10 27 0.01/s 11 84 0.02/s 12 3 0.00/s 13 2 0.00/s 14 1 0.00/s 15 1 0.00/s 16 3 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 28 00 3 1h50m41s 1h49m45s 01 2 2h43m22s 2h43m22s 02 3 2h30m38s 2h30m18s 03 0 0ms 0ms 04 1 3h47m39s 3h47m1s 05 1 3h30s 3h30s 06 0 0ms 0ms 07 1 2h31m46s 2h28m2s 08 2 1h19m8s 1h18m19s 09 1 3h54m6s 3h53m33s 10 14 10h20m37s 10h20m30s 11 83 55m27s 55m26s 12 6 2h21m3s 2h20m57s 13 2 3h37m4s 3h36m53s 14 1 7m46s 7m46s 15 1 3h39m41s 3h39m41s 16 0 0ms 0ms 17 3 3h45m26s 3h45m11s 18 1 2h41m24s 2h41m1s 19 0 0ms 0ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2025-07-28 11:15:48 Date
Connections per database
Key values
- ctddev51 Main Database
- 139 connections Total
Connections per user
Key values
- pubeu Main User
- 139 connections Total
-
Sessions
Simultaneous sessions
Key values
- 21 sessions Session Peak
- 2025-07-28 16:30:41 Date
Histogram of session times
Key values
- 73 60000-600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 125 sessions Total
Sessions per user
Key values
- pubeu Main User
- 125 sessions Total
Sessions per host
Key values
- 10.12.5.37 Main Host
- 125 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 157 buffers Checkpoint Peak
- 2025-07-28 08:56:19 Date
- 48.503 seconds Highest write time
- 0.001 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2025-07-28 10:25:32 Date
Checkpoints distance
Key values
- 0.93 Mo Distance Peak
- 2025-07-28 11:25:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 28 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 157 48.503s 0.001s 48.519s 09 8 0.887s 0.001s 14.361s 10 16 1.866s 0.002s 1.897s 11 94 9.509s 0.001s 9.525s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 28 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 22 0.001s 0.001s 09 0 0 0 6 0.001s 0.001s 10 0 0 0 14 0.001s 0.002s 11 0 0 0 59 0.001s 0.001s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 28 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 28 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 265.00 kB 4,899.00 kB 09 37.00 kB 4,413.00 kB 10 53.00 kB 3,782.50 kB 11 474.00 kB 3,273.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 23 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 Jul 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
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 Jul 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 23 0 0 - 0 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
- 40 Total read queries
- 15 Total write queries
Queries by database
Key values
- unknown Main database
- 37 Requests
- 20m1s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 51 Requests
User Request type Count Duration edit Total 1 1s606ms select 1 1s606ms editeu Total 2 6s789ms select 2 6s789ms pub1 Total 11 4m42s select 11 4m42s pubeu Total 12 40s228ms cte 11 36s322ms select 1 3s906ms unknown Total 51 30m4s cte 4 6s835ms select 47 29m57s Duration by user
Key values
- 30m4s (unknown) Main time consuming user
User Request type Count Duration edit Total 1 1s606ms select 1 1s606ms editeu Total 2 6s789ms select 2 6s789ms pub1 Total 11 4m42s select 11 4m42s pubeu Total 12 40s228ms cte 11 36s322ms select 1 3s906ms unknown Total 51 30m4s cte 4 6s835ms select 47 29m57s Queries by host
Key values
- unknown Main host
- 77 Requests
- 35m35s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 51 Requests
- 20m48s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-28 08:55:30 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 33 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 2m19s /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 00:30:04 ]
2 2m16s /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 07:55:17 ]
3 2m14s /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 16:58:31 ]
4 1m12s /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 16:32:47 ]
5 46s90ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 08:56:18 ]
6 46s67ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 06:22:51 - Database: ctddev51 - User: pub1 - Application: pgAdmin 4 - DB:ctddev51 ]
7 45s941ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 10:27:49 ]
8 45s662ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 17:38:23 ]
9 45s615ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 08:20:30 ]
10 38s209ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 07:56:05 ]
11 37s547ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 10:26:55 ]
12 37s497ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 04:51:52 ]
13 37s195ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 03:45:52 ]
14 33s535ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 12:23:31 ]
15 31s447ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 02:51:51 ]
16 30s426ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 16:54:37 ]
17 26s861ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 11:17:14 ]
18 26s800ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 00:55:29 - Database: ctddev51 - User: pub1 - Application: pgAdmin 4 - DB:ctddev51 ]
19 26s699ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 07:10:56 ]
20 26s474ms /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;[ Date: 2025-07-28 11:41:09 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 21m8s 36 1s606ms 2m19s 35s247ms select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select count(*) from pg_catalog.pg_stat_activity where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Total", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Active", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Idle") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(xact_commit) + sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Transactions", ( select sum(xact_commit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Commits", ( select sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Rollbacks") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_inserted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Inserts", ( select sum(tup_updated) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Updates", ( select sum(tup_deleted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Deletes") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_fetched) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Fetched", ( select sum(tup_returned) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Returned") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(blks_read) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Reads", ( select sum(blks_hit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Hits") t;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 2 2m45s 1m22s 02 2 57s856ms 28s928ms 03 1 37s195ms 37s195ms 04 1 37s497ms 37s497ms 06 3 59s186ms 19s728ms 07 5 3m44s 44s882ms 08 2 1m31s 45s852ms 09 1 25s672ms 25s672ms 10 2 1m23s 41s744ms 11 3 54s941ms 18s313ms 12 1 33s535ms 33s535ms 13 1 22s908ms 22s908ms 16 8 4m47s 35s951ms 17 1 45s662ms 45s662ms 18 1 23s278ms 23s278ms 19 1 6s603ms 6s603ms 23 1 11s524ms 11s524ms [ User: pub1 - Total duration: 1m12s - Times executed: 2 ]
[ User: edit - Total duration: 1s606ms - Times executed: 1 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 1m14s - Times executed: 3 ]
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 00:30:04 Duration: 2m19s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 07:55:17 Duration: 2m16s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 16:58:31 Duration: 2m14s
2 39s356ms 14 1s2ms 3s347ms 2s811ms with recursive sub_node ( object_id, id, path, lvl ) as ( select n.object_id, n.id, array[n.nm_sort], ? from dag_node n where n.object_id = ? union all select n.object_id, n.id, cast(path || n.nm_sort as varchar(?)[]), sn.lvl + ? from dag_node n inner join sub_node sn on (n.parent_id = sn.id)) select distinct t.nm prinm, t.nm_html prinmhtml, t.secondary_nm secondarynm, t.acc_db_cd accdbcd, t.acc_txt termacc, t.is_leaf isleaf, t.has_chems haschems, t.has_diseases hasdiseases, t.has_exposures hasexposures, t.has_genes hasgenes, sn.lvl, sn.path, max(sn.lvl) over () maxlvl, t.has_phenotypes hasphenotypes from sub_node sn inner join term t on sn.object_id = t.id where sn.lvl <= ? order by sn.path;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 10 3 7s687ms 2s562ms 11 11 31s669ms 2s879ms [ User: pubeu - Total duration: 36s322ms - Times executed: 11 ]
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 10:54:29 Duration: 3s347ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:15:52 Duration: 3s327ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:12:15 Duration: 3s319ms Database: ctddev51 User: pubeu Bind query: yes
3 6s789ms 2 2s843ms 3s946ms 3s394ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 10 2 6s789ms 3s394ms [ User: editeu - Total duration: 6s789ms - Times executed: 2 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:39 Duration: 3s946ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:38 Duration: 2s843ms Database: ctddev51 User: editeu Bind query: yes
4 5s471ms 1 5s471ms 5s471ms 5s471ms select c.nm as chemicalname, c.acc_txt as chemicalid, c.secondary_nm as casrn, d.nm as diseasename, d.acc_db_cd || ? || d.acc_txt as diseaseid, a.action_type_nm as directevidence, string_agg(r.acc_txt, ? order by r.acc_txt) as pubmedids from chem_disease_reference cdr inner join term d on cdr.disease_id = d.id inner join term c on cdr.chem_id = c.id left outer join chem_disease_reference_axn a on cdr.id = a.chem_disease_reference_id left outer join reference r on cdr.reference_id = r.id where cdr.source_cd = ? group by c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ? || d.acc_txt, a.action_type_nm order by c.nm_sort, d.nm;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 08 1 5s471ms 5s471ms [ User: pub1 - Total duration: 5s471ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 5s471ms - Times executed: 1 ]
-
SELECT --/* AllCuratedCDRelationsDAO */\n") c.nm AS ChemicalName, c.acc_txt AS ChemicalID, c.secondary_nm AS CasRN, d.nm AS DiseaseName, d.acc_db_cd || ':' || d.acc_txt AS DiseaseID, a.action_type_nm AS DirectEvidence -- ,g.nm AS InferenceGeneSymbol -- get rid of this -- ,cdr.network_score AS InferenceScore -- get rid of this , -- ,STRING_AGG(cdr.source_acc_txt, '|' ORDER BY cdr.source_acc_txt) AS OmimIDs STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) AS PubMedIDs FROM chem_disease_reference cdr INNER JOIN term d ON cdr.disease_id = d.id INNER JOIN term c ON cdr.chem_id = c.id LEFT OUTER JOIN chem_disease_reference_axn a ON cdr.id = a.chem_disease_reference_id LEFT OUTER JOIN reference r ON cdr.reference_id = r.id -- LEFT OUTER JOIN term g ON cdr.via_gene_id = g.id WHERE cdr.source_cd = 'C' -- add this in to only get curated -- AND cdr.source_acc_txt is NOT null -- this is null for all curated, only if omim inferred GROUP BY c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ':' || d.acc_txt, a.action_type_nm -- ,g.nm -- ,cdr.network_score ORDER BY c.nm_sort, d.nm;
Date: 2025-07-28 08:33:31 Duration: 5s471ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
5 3s906ms 1 3s906ms 3s906ms 3s906ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 09 1 3s906ms 3s906ms [ User: pubeu - Total duration: 3s906ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2025-07-28 09:17:00 Duration: 3s906ms Database: ctddev51 User: pubeu Bind query: yes
6 3s801ms 1 3s801ms 3s801ms 3s801ms with gene_sq as ( select unnest(array[?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?]) id ) select fg.nm fromgenesymbol, fg.acc_txt fromgeneacc, tg.nm togenesymbol, tg.acc_txt togeneacc, ft.nm fromtaxonnm, ft.secondary_nm fromtaxoncommonnm, ft.acc_txt fromtaxonacc, tt.nm totaxonnm, tt.secondary_nm totaxoncommonnm, tt.acc_txt totaxonacc, r.abbr_authors_txt refauthors, r.core_citation_txt refcitation, r.pub_start_yr refyear, r.acc_txt refacc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( select string_agg(ggt.throughput_txt, ? order by ggt.throughput_txt) from gene_gene_ref_throughput ggt where ggt.gene_gene_reference_id = ggr.id) throughput, count(*) over () fullrowcount from gene_gene_reference ggr inner join term fg on ggr.from_gene_id = fg.id inner join term tg on ggr.to_gene_id = tg.id inner join term ft on ggr.from_taxon_id = ft.id inner join term tt on ggr.to_taxon_id = tt.id inner join reference r on ggr.reference_id = r.id inner join gene_sq g1 on g1.id = ggr.from_gene_id inner join gene_sq g2 on g2.id = ggr.to_gene_id order by fg.nm_sort, tg.nm_sort limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 09 1 3s801ms 3s801ms -
WITH gene_sq AS ( SELECT UNNEST(ARRAY[1449908, 1449912, 1450088, 1450096, 1450100, 1450109, 1450125, 1450126, 1450518, 1450523, 1450526, 1450530, 1450538, 1450683, 1451225, 1451238, 1451318, 1451357, 1451701, 1451702, 1451705, 1451706, 1451720, 1451737, 1451738, 1451761, 1451789, 1452226, 1452240, 1452244, 1452249, 1452265, 1452640, 1452693, 1452694, 1462446, 1462450, 1462470, 1462475, 1462502, 1462512, 1462539, 1462540, 1462599, 1462946, 1462972, 1463212, 1463520, 1463927, 1463937, 1463982, 1464046, 1464363, 1465007, 1465731, 1465799, 1466175, 1466206, 1466223, 1466244, 1466272, 1466786, 1466802, 1466903, 1466927, 1466972, 1466973, 1466974, 1466976, 1466999, 1467392, 1467413, 1467415, 1467428, 1467432, 1467433, 1467453, 1467514, 1467516, 1468997, 1469398, 1476330, 1476358, 1476360, 1476369, 1476502, 1477471, 1477474, 1477504, 1477630, 1477985, 1478069, 1478108, 1478210, 1478483, 1478486, 1478487, 1478513, 1478515, 1478519, 1478540, 1478564, 1478598, 1478599, 1478601, 1478735, 1478736, 1479156, 1479191, 1479229, 1479254, 1479 260, 1479426, 1480026, 1480068, 1480070, 1480179, 1480180, 1480183, 1480207, 1480751, 1480782, 1480909, 1481413, 1481567, 1481569, 1482005, 1482057, 1482058, 1482082, 1482084, 1485316, 1498086, 1516966, 1518318, 1518663, 1518804, 1520313, 1529483, 1531427, 1538036, 1557944, 1559337, 1562248, 1571991, 1573516, 1603705, 1612709, 1624491, 1624971, 1634282, 1634308, 1634883, 1634894, 1634896, 1635636, 1635786, 1635789, 1637060, 1638727, 1639814, 1640241, 1643553, 1645620, 1645643, 1645648, 1645662, 1645667, 1645701, 1646218, 1646240, 1646318, 1646319, 1647411, 1647433, 1647461, 1647814, 1647883, 1647931, 1647932, 1648273, 1648301, 1648368, 1648393, 1648423, 1648753, 1648869, 1649224, 1649228, 1649315, 1649766, 1650449, 1650508, 1661014, 1669207, 1671209, 1686784, 1695031, 1695033, 1734969, 1782580, 1784547, 1811294, 1813574, 1813590, 1813603, 1819862, 1824901, 1831357, 1833267, 1833336, 1833345, 1833625, 1833662, 1835697, 1840473, 1840897, 1843405, 1843747, 1843814, 1844005, 1844223, 1845033, 1845040, 1845678, 1846026, 1846091, 1846111, 1846423, 1846928, 1847965, 1852838, 1853260, 1853567, 1855489, 1872115, 1872360, 1872398, 1872448, 1873022, 1873047, 1873105, 1873314, 1873378, 1873411, 1873623, 1873647, 1873651, 1873689, 1873696, 1873907, 1874152, 1874191, 1874217, 1882928, 1883110, 1883656, 1884577, 1906547, 1909816, 1914666, 1925173, 1941802, 1946569, 1947364, 1957998, 1971984, 1974320, 1984132, 1984149, 1984532, 1985329, 1986290, 1986886, 1996645, 1996716, 1996744, 1996745, 1996761, 1997356, 1997611, 1997612, 1998299, 1998401, 1998681, 1998779, 1999022, 1999589, 1999671, 2000841, 2008271, 2008273, 2008516, 2008736, 2008738, 2008805, 2008870, 2009558, 2009929, 2010330, 2010331, 2011097, 2019216, 2021602, 2023177, 2023248, 2023745, 2023895, 2024313, 2024500, 2024701, 2025064, 2025112, 2025181, 2025184, 2025478, 2025552, 2025613, 2025889, 2026442, 2027083, 2034357, 2034560, 2034660, 2034740, 2034801, 2034982, 2035004, 2035043, 2035053, 2035089, 2035115, 2035263, 2035274, 2035310, 2035317, 2035 378, 2035695, 2035764, 2035851, 2036076, 2036159, 2036250, 2036254, 2036426, 2036450, 2036522, 2036569, 2036733, 2036825, 2037201, 2037202, 2037347, 2041128, 2041274, 2041277, 2041891, 2042155, 2042174, 2042402, 2042564, 2042603, 2042606, 2042906, 2043034, 2043047, 2043295, 2043312, 2043696, 2043812, 2044343, 2044527, 2044586, 2044587, 2044863, 2044981, 2044982, 2044984, 2045003, 2045006, 2045029, 2045067, 2045406, 2045407, 2045418, 2045419, 2045438, 2045500, 2045798, 2045859, 2046130, 2046131, 2046149, 2046167, 2046168, 2046169, 2046187, 2046191, 2046247, 2046248, 2046250, 2046251, 2046263, 2046479, 2046501, 2046547, 2046555, 2046574, 2046632, 2046635, 2046665, 2050500, 2050624, 2050625, 2052295, 2052311, 2052359, 2052361, 2052386, 2052600, 2052624, 2052756, 2052779, 2052784, 2052800, 2053084, 2053105, 2053124, 2053144, 2053180, 2053247, 2053248, 2053469, 2053474, 2053541, 2053566, 2053872, 2053888, 2053948, 2053975, 2054031, 2054039, 2054412, 2054440, 2054532, 2054960, 2054975, 2055429, 2055433, 2055482, 2055520, 2055552, 2055874, 2055953, 2055954, 2055955, 2056294, 2056295, 2056358, 2056367, 2062744, 2062745, 2063089, 2063090, 2063113, 2063195, 2063277, 2063279, 2063575, 2063595, 2063718, 2063719, 2063778, 2064113, 2064197, 2064227, 2064230, 2064240, 2064241, 2064243, 2064245, 2064247, 2064256, 2064425, 2064429, 2064430, 2064482, 2064556, 2064576, 2064855, 2064913, 2064954, 2065005, 2065464, 2065503, 2065513, 2065610, 2065611, 2065629, 2065638, 2065641, 2065643, 2065810, 2065889, 2066059, 2066060, 2066062, 2066064, 2066065, 2066105, 2066182, 2066210, 2066228, 2066261, 2066280, 2066281, 2066315, 2066402, 2066457, 2066763, 2066766, 2066768, 2066770, 2066790, 2066832, 2066932, 2066945, 2066970, 2067364, 2067370, 2067394, 2067430, 2067543, 2067547, 2067550, 2067552, 2067588, 2067616, 2067619, 2067702, 2067969, 2067970, 2067988, 2068010, 2068041, 2068046, 2068098, 2068108, 2068449, 2068484, 2068490, 2068872, 2068917, 2068953, 2068956, 2069020, 2069042, 2069047, 2069075, 2069103, 2069104, 2069 114, 2069353, 2069357, 2069465, 2069490, 2069491, 2069767, 2069883, 2069935, 2075067, 2075129, 2075434, 2075457, 2075518, 2075520, 2075554, 2075587, 2075827, 2075829, 2076085, 2076107, 2076209, 2076217, 2076225, 2076367, 2076504, 2076534, 2076537, 2076772, 2076788, 2076843, 2077303, 2077363, 2077371, 2077382, 2077644, 2077649, 2077659, 2077691, 2077705, 2077990, 2077997, 2078026, 2078032, 2078418, 2078419, 2078464, 2078477, 2081843, 2087083, 2087125, 2087136, 2087160, 2087182, 2087185, 2087489, 2087661, 2087704, 2087705, 2087733, 2087735, 2087916, 2087930, 2087931, 2087946, 2088154, 2088186, 2088209, 2088254]) id ) SELECT /* AnalyzerGeneGeneIxnsDAO */ fg.nm fromGeneSymbol, fg.acc_txt fromGeneAcc, tg.nm toGeneSymbol, tg.acc_txt toGeneAcc, ft.nm fromTaxonNm, ft.secondary_nm fromTaxonCommonNm, ft.acc_txt fromTaxonAcc, tt.nm toTaxonNm, tt.secondary_nm toTaxonCommonNm, tt.acc_txt toTaxonAcc, r.abbr_authors_txt refAuthors, r.core_citation_txt refCitation, r.pub_start_yr refYear, r.acc_txt refAcc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( SELECT STRING_AGG(ggt.throughput_txt, ', ' ORDER BY ggt.throughput_txt) FROM gene_gene_ref_throughput ggt WHERE ggt.gene_gene_reference_id = ggr.id) throughput, COUNT(*) OVER () fullRowCount FROM gene_gene_reference ggr INNER JOIN term fg ON ggr.from_gene_id = fg.id INNER JOIN term tg ON ggr.to_gene_id = tg.id INNER JOIN term ft ON ggr.from_taxon_id = ft.id INNER JOIN term tt ON ggr.to_taxon_id = tt.id INNER JOIN reference r ON ggr.reference_id = r.id INNER JOIN gene_sq g1 ON g1.id = ggr.from_gene_id INNER JOIN gene_sq g2 ON g2.id = ggr.to_gene_id ORDER BY fg.nm_sort, tg.nm_sort LIMIT 1000000;
Date: 2025-07-28 09:17:11 Duration: 3s801ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 36 21m8s 1s606ms 2m19s 35s247ms select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select count(*) from pg_catalog.pg_stat_activity where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Total", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Active", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Idle") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(xact_commit) + sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Transactions", ( select sum(xact_commit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Commits", ( select sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Rollbacks") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_inserted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Inserts", ( select sum(tup_updated) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Updates", ( select sum(tup_deleted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Deletes") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_fetched) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Fetched", ( select sum(tup_returned) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Returned") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(blks_read) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Reads", ( select sum(blks_hit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Hits") t;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 2 2m45s 1m22s 02 2 57s856ms 28s928ms 03 1 37s195ms 37s195ms 04 1 37s497ms 37s497ms 06 3 59s186ms 19s728ms 07 5 3m44s 44s882ms 08 2 1m31s 45s852ms 09 1 25s672ms 25s672ms 10 2 1m23s 41s744ms 11 3 54s941ms 18s313ms 12 1 33s535ms 33s535ms 13 1 22s908ms 22s908ms 16 8 4m47s 35s951ms 17 1 45s662ms 45s662ms 18 1 23s278ms 23s278ms 19 1 6s603ms 6s603ms 23 1 11s524ms 11s524ms [ User: pub1 - Total duration: 1m12s - Times executed: 2 ]
[ User: edit - Total duration: 1s606ms - Times executed: 1 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 1m14s - Times executed: 3 ]
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 00:30:04 Duration: 2m19s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 07:55:17 Duration: 2m16s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 16:58:31 Duration: 2m14s
2 14 39s356ms 1s2ms 3s347ms 2s811ms with recursive sub_node ( object_id, id, path, lvl ) as ( select n.object_id, n.id, array[n.nm_sort], ? from dag_node n where n.object_id = ? union all select n.object_id, n.id, cast(path || n.nm_sort as varchar(?)[]), sn.lvl + ? from dag_node n inner join sub_node sn on (n.parent_id = sn.id)) select distinct t.nm prinm, t.nm_html prinmhtml, t.secondary_nm secondarynm, t.acc_db_cd accdbcd, t.acc_txt termacc, t.is_leaf isleaf, t.has_chems haschems, t.has_diseases hasdiseases, t.has_exposures hasexposures, t.has_genes hasgenes, sn.lvl, sn.path, max(sn.lvl) over () maxlvl, t.has_phenotypes hasphenotypes from sub_node sn inner join term t on sn.object_id = t.id where sn.lvl <= ? order by sn.path;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 10 3 7s687ms 2s562ms 11 11 31s669ms 2s879ms [ User: pubeu - Total duration: 36s322ms - Times executed: 11 ]
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 10:54:29 Duration: 3s347ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:15:52 Duration: 3s327ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:12:15 Duration: 3s319ms Database: ctddev51 User: pubeu Bind query: yes
3 2 6s789ms 2s843ms 3s946ms 3s394ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 10 2 6s789ms 3s394ms [ User: editeu - Total duration: 6s789ms - Times executed: 2 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:39 Duration: 3s946ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:38 Duration: 2s843ms Database: ctddev51 User: editeu Bind query: yes
4 1 5s471ms 5s471ms 5s471ms 5s471ms select c.nm as chemicalname, c.acc_txt as chemicalid, c.secondary_nm as casrn, d.nm as diseasename, d.acc_db_cd || ? || d.acc_txt as diseaseid, a.action_type_nm as directevidence, string_agg(r.acc_txt, ? order by r.acc_txt) as pubmedids from chem_disease_reference cdr inner join term d on cdr.disease_id = d.id inner join term c on cdr.chem_id = c.id left outer join chem_disease_reference_axn a on cdr.id = a.chem_disease_reference_id left outer join reference r on cdr.reference_id = r.id where cdr.source_cd = ? group by c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ? || d.acc_txt, a.action_type_nm order by c.nm_sort, d.nm;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 08 1 5s471ms 5s471ms [ User: pub1 - Total duration: 5s471ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 5s471ms - Times executed: 1 ]
-
SELECT --/* AllCuratedCDRelationsDAO */\n") c.nm AS ChemicalName, c.acc_txt AS ChemicalID, c.secondary_nm AS CasRN, d.nm AS DiseaseName, d.acc_db_cd || ':' || d.acc_txt AS DiseaseID, a.action_type_nm AS DirectEvidence -- ,g.nm AS InferenceGeneSymbol -- get rid of this -- ,cdr.network_score AS InferenceScore -- get rid of this , -- ,STRING_AGG(cdr.source_acc_txt, '|' ORDER BY cdr.source_acc_txt) AS OmimIDs STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) AS PubMedIDs FROM chem_disease_reference cdr INNER JOIN term d ON cdr.disease_id = d.id INNER JOIN term c ON cdr.chem_id = c.id LEFT OUTER JOIN chem_disease_reference_axn a ON cdr.id = a.chem_disease_reference_id LEFT OUTER JOIN reference r ON cdr.reference_id = r.id -- LEFT OUTER JOIN term g ON cdr.via_gene_id = g.id WHERE cdr.source_cd = 'C' -- add this in to only get curated -- AND cdr.source_acc_txt is NOT null -- this is null for all curated, only if omim inferred GROUP BY c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ':' || d.acc_txt, a.action_type_nm -- ,g.nm -- ,cdr.network_score ORDER BY c.nm_sort, d.nm;
Date: 2025-07-28 08:33:31 Duration: 5s471ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
5 1 3s906ms 3s906ms 3s906ms 3s906ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 09 1 3s906ms 3s906ms [ User: pubeu - Total duration: 3s906ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2025-07-28 09:17:00 Duration: 3s906ms Database: ctddev51 User: pubeu Bind query: yes
6 1 3s801ms 3s801ms 3s801ms 3s801ms with gene_sq as ( select unnest(array[?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?]) id ) select fg.nm fromgenesymbol, fg.acc_txt fromgeneacc, tg.nm togenesymbol, tg.acc_txt togeneacc, ft.nm fromtaxonnm, ft.secondary_nm fromtaxoncommonnm, ft.acc_txt fromtaxonacc, tt.nm totaxonnm, tt.secondary_nm totaxoncommonnm, tt.acc_txt totaxonacc, r.abbr_authors_txt refauthors, r.core_citation_txt refcitation, r.pub_start_yr refyear, r.acc_txt refacc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( select string_agg(ggt.throughput_txt, ? order by ggt.throughput_txt) from gene_gene_ref_throughput ggt where ggt.gene_gene_reference_id = ggr.id) throughput, count(*) over () fullrowcount from gene_gene_reference ggr inner join term fg on ggr.from_gene_id = fg.id inner join term tg on ggr.to_gene_id = tg.id inner join term ft on ggr.from_taxon_id = ft.id inner join term tt on ggr.to_taxon_id = tt.id inner join reference r on ggr.reference_id = r.id inner join gene_sq g1 on g1.id = ggr.from_gene_id inner join gene_sq g2 on g2.id = ggr.to_gene_id order by fg.nm_sort, tg.nm_sort limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 09 1 3s801ms 3s801ms -
WITH gene_sq AS ( SELECT UNNEST(ARRAY[1449908, 1449912, 1450088, 1450096, 1450100, 1450109, 1450125, 1450126, 1450518, 1450523, 1450526, 1450530, 1450538, 1450683, 1451225, 1451238, 1451318, 1451357, 1451701, 1451702, 1451705, 1451706, 1451720, 1451737, 1451738, 1451761, 1451789, 1452226, 1452240, 1452244, 1452249, 1452265, 1452640, 1452693, 1452694, 1462446, 1462450, 1462470, 1462475, 1462502, 1462512, 1462539, 1462540, 1462599, 1462946, 1462972, 1463212, 1463520, 1463927, 1463937, 1463982, 1464046, 1464363, 1465007, 1465731, 1465799, 1466175, 1466206, 1466223, 1466244, 1466272, 1466786, 1466802, 1466903, 1466927, 1466972, 1466973, 1466974, 1466976, 1466999, 1467392, 1467413, 1467415, 1467428, 1467432, 1467433, 1467453, 1467514, 1467516, 1468997, 1469398, 1476330, 1476358, 1476360, 1476369, 1476502, 1477471, 1477474, 1477504, 1477630, 1477985, 1478069, 1478108, 1478210, 1478483, 1478486, 1478487, 1478513, 1478515, 1478519, 1478540, 1478564, 1478598, 1478599, 1478601, 1478735, 1478736, 1479156, 1479191, 1479229, 1479254, 1479 260, 1479426, 1480026, 1480068, 1480070, 1480179, 1480180, 1480183, 1480207, 1480751, 1480782, 1480909, 1481413, 1481567, 1481569, 1482005, 1482057, 1482058, 1482082, 1482084, 1485316, 1498086, 1516966, 1518318, 1518663, 1518804, 1520313, 1529483, 1531427, 1538036, 1557944, 1559337, 1562248, 1571991, 1573516, 1603705, 1612709, 1624491, 1624971, 1634282, 1634308, 1634883, 1634894, 1634896, 1635636, 1635786, 1635789, 1637060, 1638727, 1639814, 1640241, 1643553, 1645620, 1645643, 1645648, 1645662, 1645667, 1645701, 1646218, 1646240, 1646318, 1646319, 1647411, 1647433, 1647461, 1647814, 1647883, 1647931, 1647932, 1648273, 1648301, 1648368, 1648393, 1648423, 1648753, 1648869, 1649224, 1649228, 1649315, 1649766, 1650449, 1650508, 1661014, 1669207, 1671209, 1686784, 1695031, 1695033, 1734969, 1782580, 1784547, 1811294, 1813574, 1813590, 1813603, 1819862, 1824901, 1831357, 1833267, 1833336, 1833345, 1833625, 1833662, 1835697, 1840473, 1840897, 1843405, 1843747, 1843814, 1844005, 1844223, 1845033, 1845040, 1845678, 1846026, 1846091, 1846111, 1846423, 1846928, 1847965, 1852838, 1853260, 1853567, 1855489, 1872115, 1872360, 1872398, 1872448, 1873022, 1873047, 1873105, 1873314, 1873378, 1873411, 1873623, 1873647, 1873651, 1873689, 1873696, 1873907, 1874152, 1874191, 1874217, 1882928, 1883110, 1883656, 1884577, 1906547, 1909816, 1914666, 1925173, 1941802, 1946569, 1947364, 1957998, 1971984, 1974320, 1984132, 1984149, 1984532, 1985329, 1986290, 1986886, 1996645, 1996716, 1996744, 1996745, 1996761, 1997356, 1997611, 1997612, 1998299, 1998401, 1998681, 1998779, 1999022, 1999589, 1999671, 2000841, 2008271, 2008273, 2008516, 2008736, 2008738, 2008805, 2008870, 2009558, 2009929, 2010330, 2010331, 2011097, 2019216, 2021602, 2023177, 2023248, 2023745, 2023895, 2024313, 2024500, 2024701, 2025064, 2025112, 2025181, 2025184, 2025478, 2025552, 2025613, 2025889, 2026442, 2027083, 2034357, 2034560, 2034660, 2034740, 2034801, 2034982, 2035004, 2035043, 2035053, 2035089, 2035115, 2035263, 2035274, 2035310, 2035317, 2035 378, 2035695, 2035764, 2035851, 2036076, 2036159, 2036250, 2036254, 2036426, 2036450, 2036522, 2036569, 2036733, 2036825, 2037201, 2037202, 2037347, 2041128, 2041274, 2041277, 2041891, 2042155, 2042174, 2042402, 2042564, 2042603, 2042606, 2042906, 2043034, 2043047, 2043295, 2043312, 2043696, 2043812, 2044343, 2044527, 2044586, 2044587, 2044863, 2044981, 2044982, 2044984, 2045003, 2045006, 2045029, 2045067, 2045406, 2045407, 2045418, 2045419, 2045438, 2045500, 2045798, 2045859, 2046130, 2046131, 2046149, 2046167, 2046168, 2046169, 2046187, 2046191, 2046247, 2046248, 2046250, 2046251, 2046263, 2046479, 2046501, 2046547, 2046555, 2046574, 2046632, 2046635, 2046665, 2050500, 2050624, 2050625, 2052295, 2052311, 2052359, 2052361, 2052386, 2052600, 2052624, 2052756, 2052779, 2052784, 2052800, 2053084, 2053105, 2053124, 2053144, 2053180, 2053247, 2053248, 2053469, 2053474, 2053541, 2053566, 2053872, 2053888, 2053948, 2053975, 2054031, 2054039, 2054412, 2054440, 2054532, 2054960, 2054975, 2055429, 2055433, 2055482, 2055520, 2055552, 2055874, 2055953, 2055954, 2055955, 2056294, 2056295, 2056358, 2056367, 2062744, 2062745, 2063089, 2063090, 2063113, 2063195, 2063277, 2063279, 2063575, 2063595, 2063718, 2063719, 2063778, 2064113, 2064197, 2064227, 2064230, 2064240, 2064241, 2064243, 2064245, 2064247, 2064256, 2064425, 2064429, 2064430, 2064482, 2064556, 2064576, 2064855, 2064913, 2064954, 2065005, 2065464, 2065503, 2065513, 2065610, 2065611, 2065629, 2065638, 2065641, 2065643, 2065810, 2065889, 2066059, 2066060, 2066062, 2066064, 2066065, 2066105, 2066182, 2066210, 2066228, 2066261, 2066280, 2066281, 2066315, 2066402, 2066457, 2066763, 2066766, 2066768, 2066770, 2066790, 2066832, 2066932, 2066945, 2066970, 2067364, 2067370, 2067394, 2067430, 2067543, 2067547, 2067550, 2067552, 2067588, 2067616, 2067619, 2067702, 2067969, 2067970, 2067988, 2068010, 2068041, 2068046, 2068098, 2068108, 2068449, 2068484, 2068490, 2068872, 2068917, 2068953, 2068956, 2069020, 2069042, 2069047, 2069075, 2069103, 2069104, 2069 114, 2069353, 2069357, 2069465, 2069490, 2069491, 2069767, 2069883, 2069935, 2075067, 2075129, 2075434, 2075457, 2075518, 2075520, 2075554, 2075587, 2075827, 2075829, 2076085, 2076107, 2076209, 2076217, 2076225, 2076367, 2076504, 2076534, 2076537, 2076772, 2076788, 2076843, 2077303, 2077363, 2077371, 2077382, 2077644, 2077649, 2077659, 2077691, 2077705, 2077990, 2077997, 2078026, 2078032, 2078418, 2078419, 2078464, 2078477, 2081843, 2087083, 2087125, 2087136, 2087160, 2087182, 2087185, 2087489, 2087661, 2087704, 2087705, 2087733, 2087735, 2087916, 2087930, 2087931, 2087946, 2088154, 2088186, 2088209, 2088254]) id ) SELECT /* AnalyzerGeneGeneIxnsDAO */ fg.nm fromGeneSymbol, fg.acc_txt fromGeneAcc, tg.nm toGeneSymbol, tg.acc_txt toGeneAcc, ft.nm fromTaxonNm, ft.secondary_nm fromTaxonCommonNm, ft.acc_txt fromTaxonAcc, tt.nm toTaxonNm, tt.secondary_nm toTaxonCommonNm, tt.acc_txt toTaxonAcc, r.abbr_authors_txt refAuthors, r.core_citation_txt refCitation, r.pub_start_yr refYear, r.acc_txt refAcc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( SELECT STRING_AGG(ggt.throughput_txt, ', ' ORDER BY ggt.throughput_txt) FROM gene_gene_ref_throughput ggt WHERE ggt.gene_gene_reference_id = ggr.id) throughput, COUNT(*) OVER () fullRowCount FROM gene_gene_reference ggr INNER JOIN term fg ON ggr.from_gene_id = fg.id INNER JOIN term tg ON ggr.to_gene_id = tg.id INNER JOIN term ft ON ggr.from_taxon_id = ft.id INNER JOIN term tt ON ggr.to_taxon_id = tt.id INNER JOIN reference r ON ggr.reference_id = r.id INNER JOIN gene_sq g1 ON g1.id = ggr.from_gene_id INNER JOIN gene_sq g2 ON g2.id = ggr.to_gene_id ORDER BY fg.nm_sort, tg.nm_sort LIMIT 1000000;
Date: 2025-07-28 09:17:11 Duration: 3s801ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s606ms 2m19s 35s247ms 36 21m8s select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select count(*) from pg_catalog.pg_stat_activity where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Total", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Active", ( select count(*) from pg_catalog.pg_stat_activity where state = ? and datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Idle") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(xact_commit) + sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Transactions", ( select sum(xact_commit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Commits", ( select sum(xact_rollback) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Rollbacks") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_inserted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Inserts", ( select sum(tup_updated) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Updates", ( select sum(tup_deleted) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Deletes") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(tup_fetched) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Fetched", ( select sum(tup_returned) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Returned") t union all select ? as chart_name, pg_catalog.row_to_json(t) as chart_data from ( select ( select sum(blks_read) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Reads", ( select sum(blks_hit) from pg_catalog.pg_stat_database where datname = ( select datname from pg_catalog.pg_database where oid = ?)) AS "Hits") t;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 2 2m45s 1m22s 02 2 57s856ms 28s928ms 03 1 37s195ms 37s195ms 04 1 37s497ms 37s497ms 06 3 59s186ms 19s728ms 07 5 3m44s 44s882ms 08 2 1m31s 45s852ms 09 1 25s672ms 25s672ms 10 2 1m23s 41s744ms 11 3 54s941ms 18s313ms 12 1 33s535ms 33s535ms 13 1 22s908ms 22s908ms 16 8 4m47s 35s951ms 17 1 45s662ms 45s662ms 18 1 23s278ms 23s278ms 19 1 6s603ms 6s603ms 23 1 11s524ms 11s524ms [ User: pub1 - Total duration: 1m12s - Times executed: 2 ]
[ User: edit - Total duration: 1s606ms - Times executed: 1 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 1m14s - Times executed: 3 ]
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 00:30:04 Duration: 2m19s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 07:55:17 Duration: 2m16s
-
/*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", ( SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle") t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", ( SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", ( SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks") t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", ( SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", ( SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes") t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", ( SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned") t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM ( SELECT ( SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", ( SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = ( SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits") t;
Date: 2025-07-28 16:58:31 Duration: 2m14s
2 5s471ms 5s471ms 5s471ms 1 5s471ms select c.nm as chemicalname, c.acc_txt as chemicalid, c.secondary_nm as casrn, d.nm as diseasename, d.acc_db_cd || ? || d.acc_txt as diseaseid, a.action_type_nm as directevidence, string_agg(r.acc_txt, ? order by r.acc_txt) as pubmedids from chem_disease_reference cdr inner join term d on cdr.disease_id = d.id inner join term c on cdr.chem_id = c.id left outer join chem_disease_reference_axn a on cdr.id = a.chem_disease_reference_id left outer join reference r on cdr.reference_id = r.id where cdr.source_cd = ? group by c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ? || d.acc_txt, a.action_type_nm order by c.nm_sort, d.nm;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 08 1 5s471ms 5s471ms [ User: pub1 - Total duration: 5s471ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 5s471ms - Times executed: 1 ]
-
SELECT --/* AllCuratedCDRelationsDAO */\n") c.nm AS ChemicalName, c.acc_txt AS ChemicalID, c.secondary_nm AS CasRN, d.nm AS DiseaseName, d.acc_db_cd || ':' || d.acc_txt AS DiseaseID, a.action_type_nm AS DirectEvidence -- ,g.nm AS InferenceGeneSymbol -- get rid of this -- ,cdr.network_score AS InferenceScore -- get rid of this , -- ,STRING_AGG(cdr.source_acc_txt, '|' ORDER BY cdr.source_acc_txt) AS OmimIDs STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) AS PubMedIDs FROM chem_disease_reference cdr INNER JOIN term d ON cdr.disease_id = d.id INNER JOIN term c ON cdr.chem_id = c.id LEFT OUTER JOIN chem_disease_reference_axn a ON cdr.id = a.chem_disease_reference_id LEFT OUTER JOIN reference r ON cdr.reference_id = r.id -- LEFT OUTER JOIN term g ON cdr.via_gene_id = g.id WHERE cdr.source_cd = 'C' -- add this in to only get curated -- AND cdr.source_acc_txt is NOT null -- this is null for all curated, only if omim inferred GROUP BY c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ':' || d.acc_txt, a.action_type_nm -- ,g.nm -- ,cdr.network_score ORDER BY c.nm_sort, d.nm;
Date: 2025-07-28 08:33:31 Duration: 5s471ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
3 3s906ms 3s906ms 3s906ms 1 3s906ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 09 1 3s906ms 3s906ms [ User: pubeu - Total duration: 3s906ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1272867') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2025-07-28 09:17:00 Duration: 3s906ms Database: ctddev51 User: pubeu Bind query: yes
4 3s801ms 3s801ms 3s801ms 1 3s801ms with gene_sq as ( select unnest(array[?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?]) id ) select fg.nm fromgenesymbol, fg.acc_txt fromgeneacc, tg.nm togenesymbol, tg.acc_txt togeneacc, ft.nm fromtaxonnm, ft.secondary_nm fromtaxoncommonnm, ft.acc_txt fromtaxonacc, tt.nm totaxonnm, tt.secondary_nm totaxoncommonnm, tt.acc_txt totaxonacc, r.abbr_authors_txt refauthors, r.core_citation_txt refcitation, r.pub_start_yr refyear, r.acc_txt refacc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( select string_agg(ggt.throughput_txt, ? order by ggt.throughput_txt) from gene_gene_ref_throughput ggt where ggt.gene_gene_reference_id = ggr.id) throughput, count(*) over () fullrowcount from gene_gene_reference ggr inner join term fg on ggr.from_gene_id = fg.id inner join term tg on ggr.to_gene_id = tg.id inner join term ft on ggr.from_taxon_id = ft.id inner join term tt on ggr.to_taxon_id = tt.id inner join reference r on ggr.reference_id = r.id inner join gene_sq g1 on g1.id = ggr.from_gene_id inner join gene_sq g2 on g2.id = ggr.to_gene_id order by fg.nm_sort, tg.nm_sort limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 09 1 3s801ms 3s801ms -
WITH gene_sq AS ( SELECT UNNEST(ARRAY[1449908, 1449912, 1450088, 1450096, 1450100, 1450109, 1450125, 1450126, 1450518, 1450523, 1450526, 1450530, 1450538, 1450683, 1451225, 1451238, 1451318, 1451357, 1451701, 1451702, 1451705, 1451706, 1451720, 1451737, 1451738, 1451761, 1451789, 1452226, 1452240, 1452244, 1452249, 1452265, 1452640, 1452693, 1452694, 1462446, 1462450, 1462470, 1462475, 1462502, 1462512, 1462539, 1462540, 1462599, 1462946, 1462972, 1463212, 1463520, 1463927, 1463937, 1463982, 1464046, 1464363, 1465007, 1465731, 1465799, 1466175, 1466206, 1466223, 1466244, 1466272, 1466786, 1466802, 1466903, 1466927, 1466972, 1466973, 1466974, 1466976, 1466999, 1467392, 1467413, 1467415, 1467428, 1467432, 1467433, 1467453, 1467514, 1467516, 1468997, 1469398, 1476330, 1476358, 1476360, 1476369, 1476502, 1477471, 1477474, 1477504, 1477630, 1477985, 1478069, 1478108, 1478210, 1478483, 1478486, 1478487, 1478513, 1478515, 1478519, 1478540, 1478564, 1478598, 1478599, 1478601, 1478735, 1478736, 1479156, 1479191, 1479229, 1479254, 1479 260, 1479426, 1480026, 1480068, 1480070, 1480179, 1480180, 1480183, 1480207, 1480751, 1480782, 1480909, 1481413, 1481567, 1481569, 1482005, 1482057, 1482058, 1482082, 1482084, 1485316, 1498086, 1516966, 1518318, 1518663, 1518804, 1520313, 1529483, 1531427, 1538036, 1557944, 1559337, 1562248, 1571991, 1573516, 1603705, 1612709, 1624491, 1624971, 1634282, 1634308, 1634883, 1634894, 1634896, 1635636, 1635786, 1635789, 1637060, 1638727, 1639814, 1640241, 1643553, 1645620, 1645643, 1645648, 1645662, 1645667, 1645701, 1646218, 1646240, 1646318, 1646319, 1647411, 1647433, 1647461, 1647814, 1647883, 1647931, 1647932, 1648273, 1648301, 1648368, 1648393, 1648423, 1648753, 1648869, 1649224, 1649228, 1649315, 1649766, 1650449, 1650508, 1661014, 1669207, 1671209, 1686784, 1695031, 1695033, 1734969, 1782580, 1784547, 1811294, 1813574, 1813590, 1813603, 1819862, 1824901, 1831357, 1833267, 1833336, 1833345, 1833625, 1833662, 1835697, 1840473, 1840897, 1843405, 1843747, 1843814, 1844005, 1844223, 1845033, 1845040, 1845678, 1846026, 1846091, 1846111, 1846423, 1846928, 1847965, 1852838, 1853260, 1853567, 1855489, 1872115, 1872360, 1872398, 1872448, 1873022, 1873047, 1873105, 1873314, 1873378, 1873411, 1873623, 1873647, 1873651, 1873689, 1873696, 1873907, 1874152, 1874191, 1874217, 1882928, 1883110, 1883656, 1884577, 1906547, 1909816, 1914666, 1925173, 1941802, 1946569, 1947364, 1957998, 1971984, 1974320, 1984132, 1984149, 1984532, 1985329, 1986290, 1986886, 1996645, 1996716, 1996744, 1996745, 1996761, 1997356, 1997611, 1997612, 1998299, 1998401, 1998681, 1998779, 1999022, 1999589, 1999671, 2000841, 2008271, 2008273, 2008516, 2008736, 2008738, 2008805, 2008870, 2009558, 2009929, 2010330, 2010331, 2011097, 2019216, 2021602, 2023177, 2023248, 2023745, 2023895, 2024313, 2024500, 2024701, 2025064, 2025112, 2025181, 2025184, 2025478, 2025552, 2025613, 2025889, 2026442, 2027083, 2034357, 2034560, 2034660, 2034740, 2034801, 2034982, 2035004, 2035043, 2035053, 2035089, 2035115, 2035263, 2035274, 2035310, 2035317, 2035 378, 2035695, 2035764, 2035851, 2036076, 2036159, 2036250, 2036254, 2036426, 2036450, 2036522, 2036569, 2036733, 2036825, 2037201, 2037202, 2037347, 2041128, 2041274, 2041277, 2041891, 2042155, 2042174, 2042402, 2042564, 2042603, 2042606, 2042906, 2043034, 2043047, 2043295, 2043312, 2043696, 2043812, 2044343, 2044527, 2044586, 2044587, 2044863, 2044981, 2044982, 2044984, 2045003, 2045006, 2045029, 2045067, 2045406, 2045407, 2045418, 2045419, 2045438, 2045500, 2045798, 2045859, 2046130, 2046131, 2046149, 2046167, 2046168, 2046169, 2046187, 2046191, 2046247, 2046248, 2046250, 2046251, 2046263, 2046479, 2046501, 2046547, 2046555, 2046574, 2046632, 2046635, 2046665, 2050500, 2050624, 2050625, 2052295, 2052311, 2052359, 2052361, 2052386, 2052600, 2052624, 2052756, 2052779, 2052784, 2052800, 2053084, 2053105, 2053124, 2053144, 2053180, 2053247, 2053248, 2053469, 2053474, 2053541, 2053566, 2053872, 2053888, 2053948, 2053975, 2054031, 2054039, 2054412, 2054440, 2054532, 2054960, 2054975, 2055429, 2055433, 2055482, 2055520, 2055552, 2055874, 2055953, 2055954, 2055955, 2056294, 2056295, 2056358, 2056367, 2062744, 2062745, 2063089, 2063090, 2063113, 2063195, 2063277, 2063279, 2063575, 2063595, 2063718, 2063719, 2063778, 2064113, 2064197, 2064227, 2064230, 2064240, 2064241, 2064243, 2064245, 2064247, 2064256, 2064425, 2064429, 2064430, 2064482, 2064556, 2064576, 2064855, 2064913, 2064954, 2065005, 2065464, 2065503, 2065513, 2065610, 2065611, 2065629, 2065638, 2065641, 2065643, 2065810, 2065889, 2066059, 2066060, 2066062, 2066064, 2066065, 2066105, 2066182, 2066210, 2066228, 2066261, 2066280, 2066281, 2066315, 2066402, 2066457, 2066763, 2066766, 2066768, 2066770, 2066790, 2066832, 2066932, 2066945, 2066970, 2067364, 2067370, 2067394, 2067430, 2067543, 2067547, 2067550, 2067552, 2067588, 2067616, 2067619, 2067702, 2067969, 2067970, 2067988, 2068010, 2068041, 2068046, 2068098, 2068108, 2068449, 2068484, 2068490, 2068872, 2068917, 2068953, 2068956, 2069020, 2069042, 2069047, 2069075, 2069103, 2069104, 2069 114, 2069353, 2069357, 2069465, 2069490, 2069491, 2069767, 2069883, 2069935, 2075067, 2075129, 2075434, 2075457, 2075518, 2075520, 2075554, 2075587, 2075827, 2075829, 2076085, 2076107, 2076209, 2076217, 2076225, 2076367, 2076504, 2076534, 2076537, 2076772, 2076788, 2076843, 2077303, 2077363, 2077371, 2077382, 2077644, 2077649, 2077659, 2077691, 2077705, 2077990, 2077997, 2078026, 2078032, 2078418, 2078419, 2078464, 2078477, 2081843, 2087083, 2087125, 2087136, 2087160, 2087182, 2087185, 2087489, 2087661, 2087704, 2087705, 2087733, 2087735, 2087916, 2087930, 2087931, 2087946, 2088154, 2088186, 2088209, 2088254]) id ) SELECT /* AnalyzerGeneGeneIxnsDAO */ fg.nm fromGeneSymbol, fg.acc_txt fromGeneAcc, tg.nm toGeneSymbol, tg.acc_txt toGeneAcc, ft.nm fromTaxonNm, ft.secondary_nm fromTaxonCommonNm, ft.acc_txt fromTaxonAcc, tt.nm toTaxonNm, tt.secondary_nm toTaxonCommonNm, tt.acc_txt toTaxonAcc, r.abbr_authors_txt refAuthors, r.core_citation_txt refCitation, r.pub_start_yr refYear, r.acc_txt refAcc, ggr.experimental_sys_nm, ggr.experimental_sys_type, ( SELECT STRING_AGG(ggt.throughput_txt, ', ' ORDER BY ggt.throughput_txt) FROM gene_gene_ref_throughput ggt WHERE ggt.gene_gene_reference_id = ggr.id) throughput, COUNT(*) OVER () fullRowCount FROM gene_gene_reference ggr INNER JOIN term fg ON ggr.from_gene_id = fg.id INNER JOIN term tg ON ggr.to_gene_id = tg.id INNER JOIN term ft ON ggr.from_taxon_id = ft.id INNER JOIN term tt ON ggr.to_taxon_id = tt.id INNER JOIN reference r ON ggr.reference_id = r.id INNER JOIN gene_sq g1 ON g1.id = ggr.from_gene_id INNER JOIN gene_sq g2 ON g2.id = ggr.to_gene_id ORDER BY fg.nm_sort, tg.nm_sort LIMIT 1000000;
Date: 2025-07-28 09:17:11 Duration: 3s801ms Bind query: yes
5 2s843ms 3s946ms 3s394ms 2 6s789ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 10 2 6s789ms 3s394ms [ User: editeu - Total duration: 6s789ms - Times executed: 2 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:39 Duration: 3s946ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-07-28 10:44:38 Duration: 2s843ms Database: ctddev51 User: editeu Bind query: yes
6 1s2ms 3s347ms 2s811ms 14 39s356ms with recursive sub_node ( object_id, id, path, lvl ) as ( select n.object_id, n.id, array[n.nm_sort], ? from dag_node n where n.object_id = ? union all select n.object_id, n.id, cast(path || n.nm_sort as varchar(?)[]), sn.lvl + ? from dag_node n inner join sub_node sn on (n.parent_id = sn.id)) select distinct t.nm prinm, t.nm_html prinmhtml, t.secondary_nm secondarynm, t.acc_db_cd accdbcd, t.acc_txt termacc, t.is_leaf isleaf, t.has_chems haschems, t.has_diseases hasdiseases, t.has_exposures hasexposures, t.has_genes hasgenes, sn.lvl, sn.path, max(sn.lvl) over () maxlvl, t.has_phenotypes hasphenotypes from sub_node sn inner join term t on sn.object_id = t.id where sn.lvl <= ? order by sn.path;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 10 3 7s687ms 2s562ms 11 11 31s669ms 2s879ms [ User: pubeu - Total duration: 36s322ms - Times executed: 11 ]
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 10:54:29 Duration: 3s347ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:15:52 Duration: 3s327ms Database: ctddev51 User: pubeu Bind query: yes
-
WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;
Date: 2025-07-28 11:12:15 Duration: 3s319ms Database: ctddev51 User: pubeu Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 717 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 66 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 41 Max number of times the same event was reported
- 67 Total events found
Rank Times reported Error 1 41 LOG: using stale statistics instead of current ones because stats collector is not responding
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 28 00 5 02 3 03 2 04 2 06 2 07 4 08 3 10 1 11 1 12 2 13 2 15 1 16 9 17 2 18 1 19 1 - LOG: using stale statistics instead of current ones because stats collector is not responding
Statement: /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Total", (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Active", (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Idle" ) t UNION ALL SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Transactions", (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Commits", (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Rollbacks" ) t UNION ALL SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Inserts", (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Updates", (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Deletes" ) t UNION ALL SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Fetched", (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Returned" ) t UNION ALL SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Reads", (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 484829)) AS "Hits" ) t
Date: 2025-07-28 00:27:55 Database: ctddev51 Application: pgAdmin 4 - DB:ctddev51 User: pub1 Remote:
2 23 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 28 00 3 01 2 02 3 04 1 05 1 07 1 08 1 09 1 12 3 13 2 15 1 17 3 18 1 3 2 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 28 11 1 14 1 4 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 28 10 1 - ERROR: syntax error at or near "elect" at character 1
Statement: elect create_by,mod_by from exposure where reference_acc_txt='12893620'
Date: 2025-07-28 10:20:07 Database: ctddev51 Application: pgAdmin 4 - CONN:9645700 User: edit Remote: