pgBadger-
Global information
- Generated on Tue Jul 22 04:10:04 2025
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20250721
- Parsed 2,176 log entries in 2s
- Log start from 2025-07-21 00:03:28 to 2025-07-21 23:49:03
-
Overview
Global Stats
- 8 Number of unique normalized queries
- 67 Number of queries
- 19m15s Total query duration
- 2025-07-21 00:42:54 First query
- 2025-07-21 23:49:03 Last query
- 1 queries/s at 2025-07-21 15:09:05 Query peak
- 19m15s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 19m15s Execute total duration
- 67 Number of events
- 8 Number of unique normalized events
- 28 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
- 217 Total number of sessions
- 22 sessions at 2025-07-21 15:08:54 Session peak
- 76d10h10m34s Total duration of sessions
- 8h27m8s Average duration of sessions
- 0 Average queries per session
- 5s326ms Average queries duration per session
- 8h27m3s Average idle time per session
- 226 Total number of connections
- 9 connections/s at 2025-07-21 15:08:54 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-21 15:09:05 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-21 23:47:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-07-21 15:09:05 Date
Queries duration
Key values
- 19m15s 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 21 00 1 0ms 26s761ms 26s761ms 26s761ms 26s761ms 26s761ms 01 2 2s200ms 28s186ms 15s193ms 28s186ms 28s186ms 28s186ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 05 1 26s643ms 26s643ms 26s643ms 26s643ms 26s643ms 26s643ms 06 1 19s901ms 19s901ms 19s901ms 19s901ms 19s901ms 19s901ms 07 3 7s404ms 26s907ms 15s361ms 26s907ms 26s907ms 26s907ms 08 1 15s728ms 15s728ms 15s728ms 15s728ms 15s728ms 15s728ms 09 3 0ms 34s923ms 15s937ms 34s923ms 34s923ms 34s923ms 10 3 0ms 14s750ms 6s384ms 14s750ms 14s750ms 14s750ms 11 12 0ms 22s119ms 4s262ms 4s577ms 26s686ms 26s686ms 12 1 0ms 6s547ms 6s547ms 6s547ms 6s547ms 6s547ms 13 9 0ms 45s885ms 15s270ms 26s482ms 1m22s 1m22s 14 2 0ms 2m19s 1m31s 43s883ms 2m19s 2m19s 15 11 0ms 47s122ms 9s119ms 4s637ms 31s592ms 47s122ms 16 5 0ms 32s479ms 16s746ms 24s408ms 32s479ms 32s479ms 17 2 0ms 33s538ms 28s804ms 33s538ms 33s538ms 33s538ms 19 2 0ms 20s967ms 12s637ms 20s967ms 20s967ms 20s967ms 20 2 0ms 12s956ms 7s202ms 12s956ms 12s956ms 12s956ms 21 3 0ms 33s256ms 22s976ms 33s256ms 33s256ms 33s256ms 23 3 0ms 2m6s 1m4s 2m6s 2m6s 2m6s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 21 00 1 0 26s761ms 26s761ms 26s761ms 26s761ms 01 2 0 15s193ms 28s186ms 28s186ms 28s186ms 02 0 0 0ms 0ms 0ms 0ms 05 1 0 26s643ms 26s643ms 26s643ms 26s643ms 06 1 0 19s901ms 19s901ms 19s901ms 19s901ms 07 3 0 15s361ms 26s907ms 26s907ms 26s907ms 08 1 0 15s728ms 15s728ms 15s728ms 15s728ms 09 3 0 15s937ms 9s507ms 34s923ms 34s923ms 10 1 0 14s750ms 14s750ms 14s750ms 14s750ms 11 1 0 22s119ms 0ms 0ms 22s119ms 12 1 0 6s547ms 0ms 6s547ms 6s547ms 13 5 0 25s306ms 8s563ms 26s482ms 1m22s 14 2 0 1m31s 0ms 43s883ms 2m19s 15 3 0 26s238ms 0ms 0ms 47s122ms 16 4 0 20s154ms 21s956ms 24s408ms 32s479ms 17 2 0 28s804ms 33s538ms 33s538ms 33s538ms 19 2 0 12s637ms 20s967ms 20s967ms 20s967ms 20 2 0 7s202ms 12s956ms 12s956ms 12s956ms 21 3 0 22s976ms 33s256ms 33s256ms 33s256ms 23 3 0 1m4s 2m6s 2m6s 2m6s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 21 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 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 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 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 21 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 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 0 0.00 0.00% 10 0 2 2.00 0.00% 11 0 11 11.00 0.00% 12 0 0 0.00 0.00% 13 0 4 4.00 0.00% 14 0 0 0.00 0.00% 15 0 9 9.00 0.00% 16 0 4 4.00 0.00% 17 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 21 00 1 0.00/s 01 0 0.00/s 02 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 3 0.00/s 10 16 0.00/s 11 63 0.02/s 12 16 0.00/s 13 38 0.01/s 14 18 0.01/s 15 59 0.02/s 16 9 0.00/s 17 2 0.00/s 19 1 0.00/s 20 0 0.00/s 21 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 21 00 0 0ms 0ms 01 0 0ms 0ms 02 1 12h25m36s 12h25m36s 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 8 26m42s 26m39s 11 58 9m21s 9m20s 12 16 30m38s 30m38s 13 35 30m29s 30m25s 14 15 31m19s 31m7s 15 70 1d43m2s 1d43m1s 16 10 3h3m22s 3h3m14s 17 1 25s695ms 0ms 19 1 4h6m40s 4h6m15s 20 1 6h15m11s 6h14m56s 21 1 4h11m59s 4h10m50s 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2025-07-21 15:08:54 Date
Connections per database
Key values
- ctddev51 Main Database
- 226 connections Total
Connections per user
Key values
- pubeu Main User
- 226 connections Total
-
Sessions
Simultaneous sessions
Key values
- 22 sessions Session Peak
- 2025-07-21 15:08:54 Date
Histogram of session times
Key values
- 67 60000-600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 217 sessions Total
Sessions per user
Key values
- pubeu Main User
- 217 sessions Total
Sessions per host
Key values
- 192.168.201.14 Main Host
- 217 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 22 buffers Checkpoint Peak
- 2025-07-21 16:25:10 Date
- 2.277 seconds Highest write time
- 0.001 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2025-07-21 13:25:08 Date
Checkpoints distance
Key values
- 0.19 Mo Distance Peak
- 2025-07-21 16:25:10 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 21 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 9 0.984s 0.001s 0.999s 12 0 0s 0s 0s 13 6 0.674s 0.001s 0.688s 14 0 0s 0s 0s 15 6 0.68s 0.001s 0.694s 16 35 3.685s 0.002s 3.715s 17 4 0.474s 0.001s 0.489s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 21 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 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 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 7 0.001s 0.001s 12 0 0 0 0 0s 0s 13 0 0 0 6 0.001s 0.001s 14 0 0 0 0 0s 0s 15 0 0 0 6 0.001s 0.001s 16 0 0 0 34 0.001s 0.002s 17 0 0 0 4 0.001s 0.001s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 21 00 0 0s 01 0 0s 02 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 19 0 0s 20 0 0s 21 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 21 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 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 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 26.00 kB 33.00 kB 12 0.00 kB 0.00 kB 13 24.00 kB 32.00 kB 14 0.00 kB 0.00 kB 15 22.00 kB 31.00 kB 16 60.00 kB 95.00 kB 17 6.00 kB 82.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 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 21 00 0 0 0 01 0 0 0 02 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 19 0 0 0 20 0 0 0 21 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 21 00 0 0 01 0 0 02 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 19 0 0 20 0 0 21 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
- 41 Total read queries
- 26 Total write queries
Queries by database
Key values
- unknown Main database
- 41 Requests
- 15m51s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 41 Requests
User Request type Count Duration load Total 4 1m42s select 4 1m42s pub1 Total 3 39s582ms select 3 39s582ms pubeu Total 9 29s482ms cte 9 29s482ms qaeu Total 10 32s199ms cte 10 32s199ms unknown Total 41 15m51s cte 7 7s363ms select 34 15m44s Duration by user
Key values
- 15m51s (unknown) Main time consuming user
User Request type Count Duration load Total 4 1m42s select 4 1m42s pub1 Total 3 39s582ms select 3 39s582ms pubeu Total 9 29s482ms cte 9 29s482ms qaeu Total 10 32s199ms cte 10 32s199ms unknown Total 41 15m51s cte 7 7s363ms select 34 15m44s Queries by host
Key values
- unknown Main host
- 67 Requests
- 19m15s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 64 Requests
- 18m36s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-21 15:09:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 37 1000-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-21 14:07:50 ]
2 2m6s /*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-21 23:25:32 ]
3 47s122ms /*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-21 15:42:18 ]
4 45s885ms /*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-21 13:27:22 ]
5 43s883ms /*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-21 14:47:19 ]
6 37s443ms /*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-21 23:49:03 ]
7 36s808ms 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-21 13:27:29 ]
8 34s923ms /*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-21 09:11:02 ]
9 33s538ms /*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-21 17:49:29 ]
10 33s256ms /*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-21 21:52:59 ]
11 32s479ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;[ Date: 2025-07-21 16:25:12 - Database: ctddev51 - User: load - Bind query: yes ]
12 30s435ms /*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-21 23:47:56 ]
13 28s186ms /*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-21 01:33:56 ]
14 26s907ms /*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-21 07:08:54 ]
15 26s761ms /*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-21 00:42:54 ]
16 26s643ms /*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-21 05:33:54 ]
17 26s482ms /*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-21 13:47:42 ]
18 26s481ms /*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-21 15:33:12 - Database: ctddev51 - User: pub1 - Application: pgAdmin 4 - DB:ctddev51 ]
19 24s408ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;[ Date: 2025-07-21 16:37:30 - Database: ctddev51 - User: load - Bind query: yes ]
20 24s71ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;[ Date: 2025-07-21 17:07:08 - Database: ctddev51 - User: load - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15m22s 32 1s449ms 2m19s 28s836ms 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 21 00 1 26s761ms 26s761ms 01 2 30s387ms 15s193ms 05 1 26s643ms 26s643ms 06 1 19s901ms 19s901ms 07 3 46s85ms 15s361ms 08 1 15s728ms 15s728ms 09 3 47s812ms 15s937ms 10 1 14s750ms 14s750ms 11 1 22s119ms 22s119ms 12 1 6s547ms 6s547ms 13 2 1m12s 36s183ms 14 2 3m3s 1m31s 15 2 1m13s 36s802ms 17 1 33s538ms 33s538ms 19 2 25s274ms 12s637ms 20 2 14s405ms 7s202ms 21 3 1m8s 22s976ms 23 3 3m14s 1m4s [ User: pub1 - Total duration: 30s788ms - Times executed: 2 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 30s788ms - Times executed: 2 ]
-
/*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-21 14:07:50 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-21 23:25:32 Duration: 2m6s
-
/*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-21 15:42:18 Duration: 47s122ms
2 1m42s 4 21s956ms 32s479ms 25s728ms select t.id, t.object_type_id, t.acc_txt, db.cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from load.term t, load.term_label l, edit.db db where t.object_type_id = ? and t.id = l.term_id and t.acc_db_id = db.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 21 16 3 1m18s 26s281ms 17 1 24s71ms 24s71ms [ User: load - Total duration: 1m42s - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:25:12 Duration: 32s479ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:37:30 Duration: 24s408ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 17:07:08 Duration: 24s71ms Database: ctddev51 User: load Bind query: yes
3 1m9s 26 1s21ms 3s585ms 2s655ms 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 #3
Day Hour Count Duration Avg duration Jul 21 10 2 4s404ms 2s202ms 11 11 29s35ms 2s639ms 13 4 10s897ms 2s724ms 15 8 21s595ms 2s699ms 16 1 3s113ms 3s113ms [ User: qaeu - Total duration: 32s199ms - Times executed: 10 ]
[ User: pubeu - Total duration: 29s482ms - Times executed: 9 ]
-
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-21 13:15:07 Duration: 3s585ms Database: ctddev51 User: qaeu 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-21 15:05:08 Duration: 3s565ms 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-21 15:08:58 Duration: 3s536ms Database: ctddev51 User: pubeu Bind query: yes
4 36s808ms 1 36s808ms 36s808ms 36s808ms 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(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 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 21 13 1 36s808ms 36s808ms -
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-21 13:27:29 Duration: 36s808ms
5 8s794ms 1 8s794ms 8s794ms 8s794ms 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(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 = ? 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 #5
Day Hour Count Duration Avg duration Jul 21 13 1 8s794ms 8s794ms [ User: pub1 - Total duration: 8s794ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 8s794ms - 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-21 13:26:24 Duration: 8s794ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
6 8s563ms 1 8s563ms 8s563ms 8s563ms 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 #6
Day Hour Count Duration Avg duration Jul 21 13 1 8s563ms 8s563ms -
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-21 13:28:20 Duration: 8s563ms
7 5s110ms 1 5s110ms 5s110ms 5s110ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 21 15 1 5s110ms 5s110ms -
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON_0000916') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'UBERON_0000916') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UBERON_0000916')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'UBERON_0000916')) ii GROUP BY ii.cd;
Date: 2025-07-21 15:33:54 Duration: 5s110ms Bind query: yes
8 1s774ms 1 1s774ms 1s774ms 1s774ms select distinct is_primary from db_link;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 16 1 1s774ms 1s774ms -
select distinct is_primary from db_link;
Date: 2025-07-21 16:02:05 Duration: 1s774ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 32 15m22s 1s449ms 2m19s 28s836ms 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 21 00 1 26s761ms 26s761ms 01 2 30s387ms 15s193ms 05 1 26s643ms 26s643ms 06 1 19s901ms 19s901ms 07 3 46s85ms 15s361ms 08 1 15s728ms 15s728ms 09 3 47s812ms 15s937ms 10 1 14s750ms 14s750ms 11 1 22s119ms 22s119ms 12 1 6s547ms 6s547ms 13 2 1m12s 36s183ms 14 2 3m3s 1m31s 15 2 1m13s 36s802ms 17 1 33s538ms 33s538ms 19 2 25s274ms 12s637ms 20 2 14s405ms 7s202ms 21 3 1m8s 22s976ms 23 3 3m14s 1m4s [ User: pub1 - Total duration: 30s788ms - Times executed: 2 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 30s788ms - Times executed: 2 ]
-
/*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-21 14:07:50 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-21 23:25:32 Duration: 2m6s
-
/*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-21 15:42:18 Duration: 47s122ms
2 26 1m9s 1s21ms 3s585ms 2s655ms 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 21 10 2 4s404ms 2s202ms 11 11 29s35ms 2s639ms 13 4 10s897ms 2s724ms 15 8 21s595ms 2s699ms 16 1 3s113ms 3s113ms [ User: qaeu - Total duration: 32s199ms - Times executed: 10 ]
[ User: pubeu - Total duration: 29s482ms - Times executed: 9 ]
-
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-21 13:15:07 Duration: 3s585ms Database: ctddev51 User: qaeu 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-21 15:05:08 Duration: 3s565ms 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-21 15:08:58 Duration: 3s536ms Database: ctddev51 User: pubeu Bind query: yes
3 4 1m42s 21s956ms 32s479ms 25s728ms select t.id, t.object_type_id, t.acc_txt, db.cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from load.term t, load.term_label l, edit.db db where t.object_type_id = ? and t.id = l.term_id and t.acc_db_id = db.id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 21 16 3 1m18s 26s281ms 17 1 24s71ms 24s71ms [ User: load - Total duration: 1m42s - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:25:12 Duration: 32s479ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:37:30 Duration: 24s408ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 17:07:08 Duration: 24s71ms Database: ctddev51 User: load Bind query: yes
4 1 36s808ms 36s808ms 36s808ms 36s808ms 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(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 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 21 13 1 36s808ms 36s808ms -
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-21 13:27:29 Duration: 36s808ms
5 1 8s794ms 8s794ms 8s794ms 8s794ms 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(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 = ? 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 #5
Day Hour Count Duration Avg duration Jul 21 13 1 8s794ms 8s794ms [ User: pub1 - Total duration: 8s794ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 8s794ms - 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-21 13:26:24 Duration: 8s794ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
6 1 8s563ms 8s563ms 8s563ms 8s563ms 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 #6
Day Hour Count Duration Avg duration Jul 21 13 1 8s563ms 8s563ms -
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-21 13:28:20 Duration: 8s563ms
7 1 5s110ms 5s110ms 5s110ms 5s110ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 21 15 1 5s110ms 5s110ms -
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON_0000916') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'UBERON_0000916') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UBERON_0000916')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'UBERON_0000916')) ii GROUP BY ii.cd;
Date: 2025-07-21 15:33:54 Duration: 5s110ms Bind query: yes
8 1 1s774ms 1s774ms 1s774ms 1s774ms select distinct is_primary from db_link;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 16 1 1s774ms 1s774ms -
select distinct is_primary from db_link;
Date: 2025-07-21 16:02:05 Duration: 1s774ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 36s808ms 36s808ms 36s808ms 1 36s808ms 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(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 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 #1
Day Hour Count Duration Avg duration Jul 21 13 1 36s808ms 36s808ms -
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-21 13:27:29 Duration: 36s808ms
2 1s449ms 2m19s 28s836ms 32 15m22s 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 #2
Day Hour Count Duration Avg duration Jul 21 00 1 26s761ms 26s761ms 01 2 30s387ms 15s193ms 05 1 26s643ms 26s643ms 06 1 19s901ms 19s901ms 07 3 46s85ms 15s361ms 08 1 15s728ms 15s728ms 09 3 47s812ms 15s937ms 10 1 14s750ms 14s750ms 11 1 22s119ms 22s119ms 12 1 6s547ms 6s547ms 13 2 1m12s 36s183ms 14 2 3m3s 1m31s 15 2 1m13s 36s802ms 17 1 33s538ms 33s538ms 19 2 25s274ms 12s637ms 20 2 14s405ms 7s202ms 21 3 1m8s 22s976ms 23 3 3m14s 1m4s [ User: pub1 - Total duration: 30s788ms - Times executed: 2 ]
[ Application: pgAdmin 4 - DB:ctddev51 - Total duration: 30s788ms - Times executed: 2 ]
-
/*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-21 14:07:50 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-21 23:25:32 Duration: 2m6s
-
/*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-21 15:42:18 Duration: 47s122ms
3 21s956ms 32s479ms 25s728ms 4 1m42s select t.id, t.object_type_id, t.acc_txt, db.cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from load.term t, load.term_label l, edit.db db where t.object_type_id = ? and t.id = l.term_id and t.acc_db_id = db.id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 21 16 3 1m18s 26s281ms 17 1 24s71ms 24s71ms [ User: load - Total duration: 1m42s - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:25:12 Duration: 32s479ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 16:37:30 Duration: 24s408ms Database: ctddev51 User: load Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;
Date: 2025-07-21 17:07:08 Duration: 24s71ms Database: ctddev51 User: load Bind query: yes
4 8s794ms 8s794ms 8s794ms 1 8s794ms 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(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 = ? 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 21 13 1 8s794ms 8s794ms [ User: pub1 - Total duration: 8s794ms - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:5878813 - Total duration: 8s794ms - 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-21 13:26:24 Duration: 8s794ms Database: ctddev51 User: pub1 Application: pgAdmin 4 - CONN:5878813
5 8s563ms 8s563ms 8s563ms 1 8s563ms 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 #5
Day Hour Count Duration Avg duration Jul 21 13 1 8s563ms 8s563ms -
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-21 13:28:20 Duration: 8s563ms
6 5s110ms 5s110ms 5s110ms 1 5s110ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 21 15 1 5s110ms 5s110ms -
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON_0000916') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'UBERON_0000916') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UBERON_0000916')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'UBERON_0000916')) ii GROUP BY ii.cd;
Date: 2025-07-21 15:33:54 Duration: 5s110ms Bind query: yes
7 1s21ms 3s585ms 2s655ms 26 1m9s 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 #7
Day Hour Count Duration Avg duration Jul 21 10 2 4s404ms 2s202ms 11 11 29s35ms 2s639ms 13 4 10s897ms 2s724ms 15 8 21s595ms 2s699ms 16 1 3s113ms 3s113ms [ User: qaeu - Total duration: 32s199ms - Times executed: 10 ]
[ User: pubeu - Total duration: 29s482ms - Times executed: 9 ]
-
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-21 13:15:07 Duration: 3s585ms Database: ctddev51 User: qaeu 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-21 15:05:08 Duration: 3s565ms 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-21 15:08:58 Duration: 3s536ms Database: ctddev51 User: pubeu Bind query: yes
8 1s774ms 1s774ms 1s774ms 1 1s774ms select distinct is_primary from db_link;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 16 1 1s774ms 1s774ms -
select distinct is_primary from db_link;
Date: 2025-07-21 16:02:05 Duration: 1s774ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,099 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
- 18 ERROR entries
- 2 WARNING entries
- 47 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 28 Max number of times the same event was reported
- 67 Total events found
Rank Times reported Error 1 28 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 21 00 3 01 2 07 2 09 2 11 2 13 2 14 3 15 2 17 2 19 1 21 4 23 3 - 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-21 00:42:38 Database: ctddev51 Application: pgAdmin 4 - DB:ctddev51 User: pub1 Remote:
2 10 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 21 02 1 15 5 16 1 19 1 20 1 21 1 3 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 21 13 6 15 3 - ERROR: syntax error at or near "ELECT" at character 1
- ERROR: syntax error at or near "THEN" at character 439
- ERROR: syntax error at or near ")" at character 988
Statement: ELECT /* MeshBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = $1 THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 2 AND l.object_type_id = 2 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 2 AND i.nm_fts @@ to_tsquery('common.english_nostops', $2) ) UNION ALL SELECT /* term acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,t.has_genes hasgenes ,t.has_chems haschems ,t.has_diseases hasdiseases ,t.has_phenotypes hasPhenotypes ,1 relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasexposures FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 2 AND (upper( l.acc_txt ) = $3 ) ORDER BY 13,14 ) sq LIMIT 50
Date: 2025-07-21 13:08:55
Statement: SELECT /* MeshBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = ? THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 2 AND l.object_type_id = 2 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 2 AND i.nm_fts @@ to_tsquery('common.english_nostops', ?) ) UNION ALL SELECT /* term acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,t.has_genes hasgenes ,t.has_chems haschems ,t.has_diseases hasdiseases ,t.has_phenotypes hasPhenotypes ,1 relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasexposures FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 2 AND (upper( l.acc_txt ) = ? ) ORDER BY 13,14 ) sq LIMIT 50 --,values={ZINC,ZINC,ZINC},sqlValue length=1522]
Date: 2025-07-21 13:17:09 Database: ctddev51 Application: pgAdmin 4 - CONN:4680668 User: edit Remote:
Statement: SELECT /* MeshBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = 'ZINC' THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 2 AND l.object_type_id = 2 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 2 AND i.nm_fts @@ to_tsquery('common.english_nostops', ?) ) UNION ALL SELECT /* term acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,t.has_genes hasgenes ,t.has_chems haschems ,t.has_diseases hasdiseases ,t.has_phenotypes hasPhenotypes ,1 relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasexposures FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 2 AND (upper( l.acc_txt ) = ? ) ORDER BY 13,14 ) sq LIMIT 50 --,values={ZINC,ZINC,ZINC},sqlValue length=1522]
Date: 2025-07-21 13:17:24
4 9 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 21 11 5 16 3 17 1 5 4 ERROR: syntax error at end of input
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 21 15 4 - ERROR: syntax error at end of input at character 940
- ERROR: syntax error at end of input at character 1018
- ERROR: syntax error at end of input at character 553
Statement: SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = 'UBERON_0000916' THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 10 AND l.object_type_id = 10 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 10 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON_0000916')
Date: 2025-07-21 15:52:56
Statement: SELECT /* MeshBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = 'UBERON_0000916' THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 10 AND l.object_type_id = 10 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 10 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON_0000916')
Date: 2025-07-21 15:53:04
Statement: SELECT /* term acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,t.has_genes hasgenes ,t.has_chems haschems ,t.has_diseases hasdiseases ,t.has_phenotypes hasPhenotypes ,1 relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasexposures FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 10 AND (upper( l.acc_txt ) = 'UBERON_0000916' OR upper( l.acc_txt ) = 'UBERON_0000916' < 2025-07-21 15:54:13.535 EDT >NOTICE: text-search query doesn't contain lexemes: ""
Date: 2025-07-21 15:53:43
6 3 ERROR: syntax error in ts"..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 21 16 3 - ERROR: syntax error in ts"UBERON 0000916"
Statement: SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 10 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'UBERON 0000916')
Date: 2025-07-21 16:00:09
7 2 WARNING: is not a PostgreSQL server process
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 21 13 2 8 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 21 13 1 16 1 - ERROR: column l.term_id does not exist at character 588
- ERROR: column "create_by" of relation "db_link" does not exist at character 81
Statement: SELECT /* MeshBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isNameMatch ,t.has_genes hasGenes ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_phenotypes hasPhenotypes ,CASE WHEN UPPER(l.nm) = 'ZINC' THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasExposures FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE t.object_type_id = 2 AND l.object_type_id = 2 AND l.id IN( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 2 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'ZINC') ) UNION ALL SELECT /* term acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm casRN ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,t.has_genes hasgenes ,t.has_chems haschems ,t.has_diseases hasdiseases ,t.has_phenotypes hasPhenotypes ,1 relevance ,t.nm_sort ,t.id ,t.acc_db_cd accdbcd ,t.has_exposures hasexposures FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 2 AND (upper( l.acc_txt ) = 'ZINC' ) ORDER BY 13,14 ) sq LIMIT 50 --,values={ZINC,ZINC,ZINC},sqlValue length=1522]
Date: 2025-07-21 13:17:46
Statement: INSERT INTO db_link ( object_id,object_type_id,acc_txt,db_id,type_cd,is_primary,create_by,create_tm,mod_by,mod_tm ) VALUES ( 1400848 ,2 ,'DTXSID7035012' ,158 ,'X' ,FALSE ,'twiegers' ,now() ,'twiegers' ,now() )
Date: 2025-07-21 16:03:16