pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jun 5 04:15:04 2026
Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260604
Parsed 15,929 log entries in 2s
Log start from 2026-06-04 00:00:01 to 2026-06-04 23:59:47

Global Stats

23 Number of unique normalized queries
58 Number of queries
32m40s Total query duration
2026-06-04 00:09:18 First query
2026-06-04 23:05:37 Last query
1 queries/s at 2026-06-04 06:01:14 Query peak

32m40s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
32m40s Execute total duration

8 Number of events
1 Number of unique normalized events
8 Max number of times the same event was reported
0 Number of cancellation

3 Total number of automatic vacuums
17 Total number of automatic analyzes

4 Number temporary file
2.09 MiB Max size of temporary file
1.23 MiB Average size of temporary file

1,932 Total number of sessions
55 sessions at 2026-06-04 23:39:13 Session peak
43d9h20m55s Total duration of sessions
32m20s Average duration of sessions
0 Average queries per session
1s14ms Average queries duration per session
32m19s Average idle time per session

1,934 Total number of connections
9 connections/s at 2026-06-04 05:45:08 Connection peak
2 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-06-04 06:01:14 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-06-04 12:20:31 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-06-04 06:01:14 Date

Queries duration

Key values

32m40s 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

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 04	00	3	0ms	9m16s	3m11s	0ms	10s129ms	9m23s
	01	0	0ms	0ms	0ms	0ms	0ms	0ms
	02	0	0ms	0ms	0ms	0ms	0ms	0ms
	03	0	0ms	0ms	0ms	0ms	0ms	0ms
	04	1	0ms	5s55ms	5s55ms	0ms	0ms	5s55ms
	05	2	0ms	5s748ms	5s703ms	0ms	5s658ms	5s748ms
	06	12	0ms	3m13s	50s920ms	53s233ms	3m12s	3m13s
	07	1	0ms	5s57ms	5s57ms	0ms	0ms	5s57ms
	08	1	0ms	7s44ms	7s44ms	0ms	0ms	7s44ms
	09	1	0ms	8s55ms	8s55ms	0ms	0ms	8s55ms
	10	9	0ms	1m51s	24s333ms	0ms	39s184ms	1m51s
	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	4	0ms	6s622ms	6s132ms	0ms	0ms	13s200ms
	13	0	0ms	0ms	0ms	0ms	0ms	0ms
	14	9	0ms	1m51s	24s345ms	20s830ms	47s450ms	1m51s
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	1	0ms	7s567ms	7s567ms	0ms	0ms	7s567ms
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	9	0ms	1m51s	24s365ms	0ms	39s360ms	1m51s
	19	0	0ms	0ms	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms	0ms	0ms
	22	2	0ms	13s261ms	10s251ms	0ms	0ms	13s261ms
	23	3	0ms	14s818ms	9s775ms	0ms	0ms	14s818ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 04	00	2	0	4m43s	0ms	0ms	9m16s
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	1	0	5s55ms	0ms	0ms	5s55ms
	05	2	0	5s703ms	0ms	0ms	5s748ms
	06	3	9	50s920ms	0ms	47s761ms	3m13s
	07	1	0	5s57ms	0ms	0ms	5s57ms
	08	1	0	7s44ms	0ms	0ms	7s44ms
	09	1	0	8s55ms	0ms	0ms	8s55ms
	10	0	9	24s333ms	0ms	0ms	1m51s
	11	0	0	0ms	0ms	0ms	0ms
	12	4	0	6s132ms	0ms	0ms	13s200ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	9	24s345ms	0ms	20s830ms	1m51s
	15	0	0	0ms	0ms	0ms	0ms
	16	1	0	7s567ms	0ms	0ms	7s567ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	9	24s365ms	0ms	0ms	1m51s
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	2	0	10s251ms	0ms	0ms	13s261ms
	23	3	0	9s775ms	0ms	0ms	14s818ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 04	00	0ms	0ms	0ms	0ms
	01	0ms	0ms	0ms	0ms
	02	0ms	0ms	0ms	0ms
	03	0ms	0ms	0ms	0ms
	04	0ms	0ms	0ms	0ms
	05	0ms	0ms	0ms	0ms
	06	0ms	0ms	0ms	0ms
	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms
	22	0ms	0ms	0ms	0ms
	23	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jun 04	00	1	1.00	0.00%
	01	0	0.00	0.00%
	02	0	0.00	0.00%
	03	0	0.00	0.00%
	04	1	1.00	0.00%
	05	2	2.00	0.00%
	06	3	3.00	0.00%
	07	1	1.00	0.00%
	08	1	1.00	0.00%
	09	1	1.00	0.00%
	10	0	0.00	0.00%
	11	0	0.00	0.00%
	12	4	4.00	0.00%
	13	0	0.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	0	0.00	0.00%
	21	0	0.00	0.00%
	22	2	2.00	0.00%
	23	3	3.00	0.00%

Day	Hour	Count	Average / Second
Jun 04	00	80	0.02/s
	01	80	0.02/s
	02	81	0.02/s
	03	80	0.02/s
	04	79	0.02/s
	05	94	0.03/s
	06	76	0.02/s
	07	76	0.02/s
	08	73	0.02/s
	09	83	0.02/s
	10	82	0.02/s
	11	81	0.02/s
	12	77	0.02/s
	13	86	0.02/s
	14	77	0.02/s
	15	76	0.02/s
	16	80	0.02/s
	17	75	0.02/s
	18	79	0.02/s
	19	77	0.02/s
	20	79	0.02/s
	21	76	0.02/s
	22	90	0.03/s
	23	97	0.03/s

Day	Hour	Count	Average Duration	Average idle time
Jun 04	00	80	29m54s	29m47s
	01	83	59m30s	59m30s
	02	83	51m16s	51m16s
	03	80	30m35s	30m35s
	04	79	29m50s	29m50s
	05	94	25m42s	25m42s
	06	76	30m21s	30m13s
	07	76	30m54s	30m54s
	08	73	31m37s	31m37s
	09	81	30m3s	30m3s
	10	82	29m41s	29m39s
	11	83	33m16s	33m16s
	12	77	30m37s	30m37s
	13	79	31m23s	31m23s
	14	77	30m19s	30m17s
	15	76	32m9s	32m9s
	16	79	30m54s	30m54s
	17	75	31m36s	31m36s
	18	79	31m3s	31m
	19	78	33m34s	33m34s
	20	79	30m32s	30m32s
	21	76	31m1s	31m1s
	22	90	26m48s	26m48s
	23	97	24m34s	24m34s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2026-06-04 05:45:08 Date

Connections per database

Key values

ctdprd51 Main Database
1,934 connections Total

Chart
Table

Database	User	Count
ctdprd51		1,930
	edit	1
	editeu	371
	load	1
	postgres	8
	pub1	1
	pub2	1
	pubc	4
	pubeu	789
	qaeu	754
postgres		4
	pub1	1
	pub2	1
	pubc	2

Connections per user

Key values

pubeu Main User
1,934 connections Total

Chart
Table

User	Count
edit	1
editeu	371
load	1
postgres	8
pub1	2
pub2	2
pubc	6
pubeu	789
qaeu	754

Connections per host

Key values

10.12.5.53 Main host with 417 connections
1,934 Total connections

Chart
Table

Host	Count
10.12.5.45	378
10.12.5.46	376
10.12.5.53	417
10.12.5.54	374
10.12.5.55	370
10.12.5.56	1
192.168.201.14	7
192.168.201.6	3
::1	8

Simultaneous sessions

Key values

55 sessions Session Peak
2026-06-04 23:39:13 Date

Histogram of session times

Key values

1,764 1800000-3600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	8	0.41%
500ms-1s	1	0.05%
1s-30s	8	0.41%
30s-1m	31	1.60%
1m-10m	72	3.73%
10m-30m	34	1.76%
30m-1h	1,764	91.30%
1h-8h	9	0.47%
> 8h	5	0.26%

Sessions per database

Key values

ctdprd51 Main Database
1,932 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctdprd51	1,929	42d2h37m30s	31m26s
postgres	3	1d6h43m24s	10h14m28s

Sessions per user

Key values

pubeu Main User
1,932 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
edit	1	2h43m23s	2h43m23s
editeu	371	8d43m35s	31m10s
load	1	6m46s	6m46s
postgres	8	15m30s	1m56s
pub1	2	1d1h12m33s	12h36m16s
pub2	1	14h54m50s	14h54m50s
pubc	5	1d11h48m39s	7h9m43s
pubeu	789	16d17m35s	29m13s
qaeu	754	16d1h18m	30m39s

Sessions per host

Key values

10.12.5.53 Main Host
1,932 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.45	378	8d1h6m41s	30m39s
10.12.5.46	376	8d11m19s	30m40s
10.12.5.53	417	8d50m52s	27m44s
10.12.5.54	374	7d23h40m21s	30m44s
10.12.5.55	370	8d39m20s	31m14s
10.12.5.56	1	6m46s	6m46s
192.168.201.6	8	3d6h30m2s	9h48m45s
::1	8	15m30s	1m56s

Sessions per application

Key values

unknown Main Application
1,932 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	1,932	43d9h20m55s	32m20s

Checkpoints Buffers

Key values

26,403 buffers Checkpoint Peak
2026-06-04 04:18:41 Date
1619.348 seconds Highest write time
0.002 seconds Sync time

Checkpoints Wal files

Key values

0 files Wal files usage Peak
2026-06-04 15:21:52 Date

Checkpoints distance

Key values

192.99 Mo Distance Peak
2026-06-04 23:06:42 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jun 04	00	574	57.681s	0.003s	57.692s
	01	835	83.81s	0.002s	83.866s
	02	456	45.847s	0.002s	45.856s
	03	236	23.729s	0.001s	23.733s
	04	27,231	1,702.352s	0.003s	1,702.417s
	05	1,300	130.395s	0.002s	130.45s
	06	1,187	119.116s	0.002s	119.125s
	07	895	89.839s	0.002s	89.892s
	08	1,251	125.47s	0.002s	125.478s
	09	855	85.828s	0.002s	85.836s
	10	384	38.628s	0.002s	38.636s
	11	1,090	109.346s	0.002s	109.402s
	12	1,872	187.446s	0.002s	187.504s
	13	1,188	119.161s	0.002s	119.169s
	14	510	51.262s	0.002s	51.271s
	15	294	29.614s	0.002s	29.624s
	16	653	65.609s	0.002s	65.67s
	17	381	38.333s	0.002s	38.341s
	18	248	25.007s	0.002s	25.017s
	19	112	11.304s	0.001s	11.309s
	20	923	92.595s	0.002s	92.651s
	21	1,203	120.656s	0.002s	120.664s
	22	92	9.329s	0.001s	9.334s
	23	9,130	914.288s	0.004s	914.325s

Day	Hour	Removed	Synced files	Longest sync	Average sync
Jun 04	00	0	65	0.001s	0.002s
	01	1	43	0.001s	0.002s
	02	0	33	0.001s	0.002s
	03	0	18	0.001s	0.001s
	04	3	76	0.001s	0.003s
	05	1	45	0.001s	0.002s
	06	0	89	0.001s	0.002s
	07	1	131	0.001s	0.002s
	08	0	74	0.001s	0.002s
	09	0	127	0.001s	0.002s
	10	0	28	0.001s	0.002s
	11	1	40	0.001s	0.002s
	12	1	33	0.001s	0.002s
	13	0	76	0.001s	0.002s
	14	0	109	0.001s	0.002s
	15	0	27	0.001s	0.002s
	16	1	138	0.001s	0.002s
	17	0	69	0.001s	0.002s
	18	0	26	0.001s	0.002s
	19	0	9	0.001s	0.001s
	20	1	29	0.001s	0.002s
	21	0	31	0.001s	0.002s
	22	0	10	0.001s	0.001s
	23	6	59	0.001s	0.003s

Day	Hour	Avg time (sec)
Jun 04	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s

Day	Hour	Mean distance	Mean estimate
Jun 04	00	1,366.00 kB	89,886.00 kB
	01	1,636.50 kB	73,108.00 kB
	02	301.00 kB	59,263.00 kB
	03	322.00 kB	50,587.00 kB
	04	20,541.00 kB	53,023.67 kB
	05	3,526.00 kB	41,145.00 kB
	06	4,370.50 kB	34,084.50 kB
	07	2,120.50 kB	28,230.00 kB
	08	3,798.50 kB	23,440.00 kB
	09	1,925.00 kB	19,651.00 kB
	10	330.50 kB	15,977.50 kB
	11	3,111.00 kB	13,265.50 kB
	12	6,712.50 kB	12,697.50 kB
	13	3,760.00 kB	10,670.00 kB
	14	1,109.50 kB	9,141.50 kB
	15	269.00 kB	7,480.50 kB
	16	7,885.00 kB	10,931.50 kB
	17	489.50 kB	13,282.00 kB
	18	78.50 kB	10,774.00 kB
	19	26.00 kB	9,192.00 kB
	20	2,160.00 kB	8,077.50 kB
	21	3,782.50 kB	7,449.50 kB
	22	131.00 kB	6,369.00 kB
	23	33,148.00 kB	89,294.33 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (47) Main checkpoint cause
47 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	47
Total	47

Size of temporary files

Key values

4.92 MiB Temp Files size Peak
2026-06-04 16:26:33 Date

Number of temporary files

Key values

4 per second Temp Files Peak
2026-06-04 16:26:33 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 04	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	4	4.92 MiB	1.23 MiB
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	4	4.92 MiB	688.00 KiB	2.09 MiB	1.23 MiB	vacuum full analyze edit.reference_contact; VACUUM FULL ANALYZE edit.reference_contact; Date: 2026-06-04 16:26:33 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	2.09 MiB	VACUUM FULL ANALYZE edit.reference_contact; [ Date: 2026-06-04 16:26:33 ]
2	1.19 MiB	VACUUM FULL ANALYZE edit.reference_contact; [ Date: 2026-06-04 16:26:33 ]
3	1000.00 KiB	VACUUM FULL ANALYZE edit.reference_contact; [ Date: 2026-06-04 16:26:33 ]
4	688.00 KiB	VACUUM FULL ANALYZE edit.reference_contact; [ Date: 2026-06-04 16:26:33 ]

Vacuums / Analyzes Distribution

Key values

4.93 sec Highest CPU-cost vacuum
Table pub1.term_set_enrichment_agent
Database ctdprd51
2026-06-04 03:29:50 Date
0 sec Highest CPU-cost analyze
Table
Database ctdprd51
Date

Average Autovacuum Duration

Key values

4.93 sec Highest CPU-cost vacuum
Table pub1.term_set_enrichment_agent
Database ctdprd51
2026-06-04 03:29:50 Date

Analyzes per table

Key values

pubc.log_query (14) Main table analyzed (database ctdprd51)
17 analyzes Total

Chart
Table

Table	Number of analyzes
ctdprd51.pubc.log_query	14
ctdprd51.pub1.term_set_enrichment_agent	1
ctdprd51.pg_catalog.pg_attribute	1
ctdprd51.pub1.term_set_enrichment	1
Total	17

Vacuums per table

Key values

pubc.log_query (2) Main table vacuumed on database ctdprd51
3 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
ctdprd51.pubc.log_query	2	1	451	0	71	0	0	136	51	350,624
ctdprd51.pub1.term_set_enrichment_agent	1	0	46,347	0	21,064	0	0	23,122	2	1,376,077
Total	3	1	46,798	4	21,135	0	0	23,258	53	1,726,701

Tuples removed per table

Key values

pubc.log_query (25) Main table with removed tuples on database ctdprd51
25 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
ctdprd51.pubc.log_query	2	1	25	1,515	0	0	63
ctdprd51.pub1.term_set_enrichment_agent	1	0	0	11,382,410	0	0	129,346
Total	3	1	25	11,383,925	0	0	129,409

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
ctdprd51.pubc.log_query	2	1	25
ctdprd51.pub1.term_set_enrichment_agent	1	0	0
Total	3	1	25

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jun 04	00	1	0
	01	0	2
	02	0	1
	03	1	2
	04	0	1
	05	0	3
	06	0	1
	07	0	1
	08	0	0
	09	0	1
	10	1	0
	11	0	1
	12	0	0
	13	0	0
	14	0	0
	15	0	1
	16	0	1
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	1
	23	0	1

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

21 Total read queries
36 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	21	36.21%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	36	62.07%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	1	1.72%

Queries by database

Key values

ctdprd51 Main database
29 Requests
26m40s (ctdprd51)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctdprd51	Total	29	26m40s
	copy to	8	8m44s
	select	21	17m56s
unknown	Total	29	6m
	copy to	28	5m53s
	others	1	6s454ms

Queries by user

Key values

unknown Main user
61 Requests

Queries Chart
Table

User	Request type	Count	Duration
edit	Total	1	7s567ms
	select	1	7s567ms
editeu	Total	14	2m59s
	select	14	2m59s
postgres	Total	16	17m31s
	copy to	16	17m31s
pubc	Total	1	9m16s
	select	1	9m16s
pubeu	Total	38	11m13s
	select	38	11m13s
qaeu	Total	2	11s266ms
	select	2	11s266ms
unknown	Total	61	12m45s
	copy to	56	11m48s
	others	1	6s454ms
	select	4	50s774ms

Duration by user

Key values

17m31s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
edit	Total	1	7s567ms
	select	1	7s567ms
editeu	Total	14	2m59s
	select	14	2m59s
postgres	Total	16	17m31s
	copy to	16	17m31s
pubc	Total	1	9m16s
	select	1	9m16s
pubeu	Total	38	11m13s
	select	38	11m13s
qaeu	Total	2	11s266ms
	select	2	11s266ms
unknown	Total	61	12m45s
	copy to	56	11m48s
	others	1	6s454ms
	select	4	50s774ms

Queries by host

Key values

unknown Main host
133 Requests
54m6s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	133	54m6s
	copy to	72	29m20s
	others	1	6s454ms
	select	60	24m39s

Queries by application

Key values

unknown Main application
48 Requests
14m31s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pgAdmin 4 - CONN:3363897	Total	1	7s567ms
	select	1	7s567ms
pg_dump	Total	8	8m44s
	copy to	8	8m44s
psql	Total	1	9m16s
	select	1	9m16s
unknown	Total	48	14m31s
	copy to	28	5m53s
	others	1	6s454ms
	select	19	8m31s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-06-04 19:15:16 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

30 > 10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	28	48.28%
> 10000ms	30	51.72%

Slowest individual queries


[ Date: 2026-06-04 00:09:18 - Database: ctdprd51 - User: pubc - Application: psql ]
[ Date: 2026-06-04 06:28:48 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2026-06-04 06:31:48 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2026-06-04 06:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 10:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 14:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 18:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 06:07:17 ]
[ Date: 2026-06-04 14:07:17 ]
[ Date: 2026-06-04 10:07:17 ]
[ Date: 2026-06-04 18:07:17 ]
[ Date: 2026-06-04 18:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 06:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 10:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 14:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
[ Date: 2026-06-04 14:07:32 ]
[ Date: 2026-06-04 18:07:32 ]
[ Date: 2026-06-04 06:07:33 ]
[ Date: 2026-06-04 10:07:33 ]
[ Date: 2026-06-04 23:04:03 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Rank	Duration	Query
1	9m16s	/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ / SELECT maint_query_logs_archive (); [ Date:* 2026-06-04 00:09:18 - Database: ctdprd51 - User: pubc - Application: psql ]
2	3m13s	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', 'CHADL & HEY1 & XLOC_L2_015508 & (LNC-RAD1-2 \| LNCRAD12) & XLOC_L2_015209 & REEP3 & POR & RBMS2 & (LNC-C17ORF62-1 \| LNCC17ORF621) & C18ORF32 & (LNC-HSP90AA1-2 \| LNCHSP90AA12) & LOC100133286 & XLOC_L2_005952 & XLOC_L2_005415 & (LNC-TTC26-2 \| LNCTTC262) & GNAI1 & (LNC-A1CF-3 \| LNCA1CF3) & DDN & (LNC-GPR15-1 \| LNCGPR151) & MRGPRG & LOC102725353 & SBNO2 & LRRC26 & (KRTAP4-2 \| KRTAP42) & UBE2NL & SERPINB6 & AVP & SERINC5 & (LNC-DYM-1 \| LNCDYM1) & TMEM95 & PABPC3 & (LNC-CADPS-1 \| LNCCADPS1) & (LNC-C9ORF103-1 \| LNCC9ORF1031) & LINC00657 & TAF13 & (LNC-SLC36A4-1 \| LNCSLC36A41) & LOC100129917 & A4GALT & UNCX & GPR150 & (LNC-PLTP-1 \| LNCPLTP1) & (LNC-ANKRD11-2 \| LNCANKRD112) & TINAGL1 & NOXO1 & (LNC-GPR27-2 \| LNCGPR272) & SCGB3A1 & FAM229A & POT1 & (LNC-CR392000.1-2 \| LNCCR392000.12) & (LNC-SERPINA12-1 \| LNCSERPINA121) & LOC439951 &(LNC-SCEL-2 \| LNCSCEL2)') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CHADL & HEY1 & XLOC_L2_015508 & (LNC-RAD1-2 \| LNCRAD12) & XLOC_L2_015209 & REEP3 & POR & RBMS2 & (LNC-C17ORF62-1 \| LNCC17ORF621) & C18ORF32 & (LNC-HSP90AA1-2 \| LNCHSP90AA12) & LOC100133286 & XLOC_L2_005952 & XLOC_L2_005415 & (LNC-TTC26-2 \| LNCTTC262) & GNAI1 & (LNC-A1CF-3 \| LNCA1CF3) & DDN & (LNC-GPR15-1 \| LNCGPR151) & MRGPRG & LOC102725353 & SBNO2 & LRRC26 & (KRTAP4-2 \| KRTAP42) & UBE2NL & SERPINB6 & AVP & SERINC5 & (LNC-DYM-1 \| LNCDYM1) & TMEM95 & PABPC3 & (LNC-CADPS-1 \| LNCCADPS1) & (LNC-C9ORF103-1 \| LNCC9ORF1031) & LINC00657 & TAF13 & (LNC-SLC36A4-1 \| LNCSLC36A41) & LOC100129917 & A4GALT & UNCX & GPR150 & (LNC-PLTP-1 \| LNCPLTP1) & (LNC-ANKRD11-2 \| LNCANKRD112) & TINAGL1 & NOXO1 & (LNC-GPR27-2 \| LNCGPR272) & SCGB3A1 & FAM229A & POT1 & (LNC-CR392000.1-2 \| LNCCR392000.12) & (LNC-SERPINA12-1 \| LNCSERPINA121) & LOC439951 & (LNC-SCEL-2 \| LNCSCEL2)') 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 'CHADL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEY1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_015508' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-RAD1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCRAD12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_015209' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'REEP3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'POR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'RBMS2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-C17ORF62-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCC17ORF621)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'C18ORF32' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-HSP90AA1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCHSP90AA12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC100133286' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_005952' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_005415' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-TTC26-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCTTC262)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GNAI1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-A1CF-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCA1CF3)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DDN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-GPR15-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCGPR151)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MRGPRG' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC102725353' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SBNO2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LRRC26' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(KRTAP4-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KRTAP42)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UBE2NL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SERPINB6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AVP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SERINC5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-DYM-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCDYM1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TMEM95' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PABPC3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-CADPS-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCCADPS1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-C9ORF103-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCC9ORF1031)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LINC00657' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TAF13' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SLC36A4-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSLC36A41)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC100129917' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'A4GALT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UNCX' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GPR150' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-PLTP-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCPLTP1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-ANKRD11-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCANKRD112)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TINAGL1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOXO1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-GPR27-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCGPR272)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SCGB3A1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAM229A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'POT1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-CR392000.1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCCR392000.12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SERPINA12-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSERPINA121)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC439951' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SCEL-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSCEL2)')) 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 'CHADL' OR upper(l.acc_txt) LIKE 'HEY1' OR upper(l.acc_txt) LIKE 'XLOC_L2_015508' OR upper(l.acc_txt) LIKE 'LNC-RAD1-2' OR upper(l.acc_txt) LIKE 'XLOC_L2_015209' OR upper(l.acc_txt) LIKE 'REEP3' OR upper(l.acc_txt) LIKE 'POR' OR upper(l.acc_txt) LIKE 'RBMS2' OR upper(l.acc_txt) LIKE 'LNC-C17ORF62-1' OR upper(l.acc_txt) LIKE 'C18ORF32' OR upper(l.acc_txt) LIKE 'LNC-HSP90AA1-2' OR upper(l.acc_txt) LIKE 'LOC100133286' OR upper(l.acc_txt) LIKE 'XLOC_L2_005952' OR upper(l.acc_txt) LIKE 'XLOC_L2_005415' OR upper(l.acc_txt) LIKE 'LNC-TTC26-2' OR upper(l.acc_txt) LIKE 'GNAI1' OR upper(l.acc_txt) LIKE 'LNC-A1CF-3' OR upper(l.acc_txt) LIKE 'DDN' OR upper(l.acc_txt) LIKE 'LNC-GPR15-1' OR upper(l.acc_txt) LIKE 'MRGPRG' OR upper(l.acc_txt) LIKE 'LOC102725353' OR upper(l.acc_txt) LIKE 'SBNO2' OR upper(l.acc_txt) LIKE 'LRRC26' OR upper(l.acc_txt) LIKE 'KRTAP4-2' OR upper(l.acc_txt) LIKE 'UBE2NL', $97 = 'SERPINB6' OR upper(l.acc_txt) LIKE 'AVP' OR upper(l.acc_txt) LIKE 'SERINC5' OR upper(l.acc_txt) LIKE 'LNC-DYM-1' OR upper(l.acc_txt) LIKE 'TMEM95' OR upper(l.acc_txt) LIKE 'PABPC3' OR upper(l.acc_txt) LIKE 'LNC-CADPS-1' OR upper(l.acc_txt) LIKE 'LNC-C9ORF103-1' OR upper(l.acc_txt) LIKE 'LINC00657' OR upper(l.acc_txt) LIKE 'TAF13' OR upper(l.acc_txt) LIKE 'LNC-SLC36A4-1' OR upper(l.acc_txt) LIKE 'LOC100129917' OR upper(l.acc_txt) LIKE 'A4GALT' OR upper(l.acc_txt) LIKE 'UNCX' OR upper(l.acc_txt) LIKE 'GPR150' OR upper(l.acc_txt) LIKE 'LNC-PLTP-1' OR upper(l.acc_txt) LIKE 'LNC-ANKRD11-2' OR upper(l.acc_txt) LIKE 'TINAGL1' OR upper(l.acc_txt) LIKE 'NOXO1' OR upper(l.acc_txt) LIKE 'LNC-GPR27-2' OR upper(l.acc_txt) LIKE 'SCGB3A1' OR upper(l.acc_txt) LIKE 'FAM229A' OR upper(l.acc_txt) LIKE 'POT1' OR upper(l.acc_txt) LIKE 'LNC-CR392000.1-2' OR upper(l.acc_txt) LIKE 'LNC-SERPINA12-1' OR upper(l.acc_txt) LIKE 'LOC439951' OR upper(l.acc_txt) LIKE 'LNC-SCEL-2' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2026-06-04 06:28:48 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
3	3m12s	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', 'CHADL & HEY1 & XLOC_L2_015508 & (LNC-RAD1-2 \| LNCRAD12) & XLOC_L2_015209 & REEP3 & POR & RBMS2 & (LNC-C17ORF62-1 \| LNCC17ORF621) & C18ORF32 & (LNC-HSP90AA1-2 \| LNCHSP90AA12) & LOC100133286 & XLOC_L2_005952 & XLOC_L2_005415 & (LNC-TTC26-2 \| LNCTTC262) & GNAI1 & (LNC-A1CF-3 \| LNCA1CF3) & DDN & (LNC-GPR15-1 \| LNCGPR151) & MRGPRG & LOC102725353 & SBNO2 & LRRC26 & (KRTAP4-2 \| KRTAP42) & UBE2NL & SERPINB6 & AVP & SERINC5 & (LNC-DYM-1 \| LNCDYM1) & TMEM95 & PABPC3 & (LNC-CADPS-1 \| LNCCADPS1) & (LNC-C9ORF103-1 \| LNCC9ORF1031) & LINC00657 & TAF13 & (LNC-SLC36A4-1 \| LNCSLC36A41) & LOC100129917 & A4GALT & UNCX & GPR150 & (LNC-PLTP-1 \| LNCPLTP1) & (LNC-ANKRD11-2 \| LNCANKRD112) & TINAGL1 & NOXO1 & (LNC-GPR27-2 \| LNCGPR272) & SCGB3A1 & FAM229A & POT1 & (LNC-CR392000.1-2 \| LNCCR392000.12) & (LNC-SERPINA12-1 \| LNCSERPINA121) & LOC439951 &(LNC-SCEL-2 \| LNCSCEL2)') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CHADL & HEY1 & XLOC_L2_015508 & (LNC-RAD1-2 \| LNCRAD12) & XLOC_L2_015209 & REEP3 & POR & RBMS2 & (LNC-C17ORF62-1 \| LNCC17ORF621) & C18ORF32 & (LNC-HSP90AA1-2 \| LNCHSP90AA12) & LOC100133286 & XLOC_L2_005952 & XLOC_L2_005415 & (LNC-TTC26-2 \| LNCTTC262) & GNAI1 & (LNC-A1CF-3 \| LNCA1CF3) & DDN & (LNC-GPR15-1 \| LNCGPR151) & MRGPRG & LOC102725353 & SBNO2 & LRRC26 & (KRTAP4-2 \| KRTAP42) & UBE2NL & SERPINB6 & AVP & SERINC5 & (LNC-DYM-1 \| LNCDYM1) & TMEM95 & PABPC3 & (LNC-CADPS-1 \| LNCCADPS1) & (LNC-C9ORF103-1 \| LNCC9ORF1031) & LINC00657 & TAF13 & (LNC-SLC36A4-1 \| LNCSLC36A41) & LOC100129917 & A4GALT & UNCX & GPR150 & (LNC-PLTP-1 \| LNCPLTP1) & (LNC-ANKRD11-2 \| LNCANKRD112) & TINAGL1 & NOXO1 & (LNC-GPR27-2 \| LNCGPR272) & SCGB3A1 & FAM229A & POT1 & (LNC-CR392000.1-2 \| LNCCR392000.12) & (LNC-SERPINA12-1 \| LNCSERPINA121) & LOC439951 & (LNC-SCEL-2 \| LNCSCEL2)') 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 'CHADL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEY1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_015508' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-RAD1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCRAD12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_015209' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'REEP3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'POR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'RBMS2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-C17ORF62-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCC17ORF621)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'C18ORF32' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-HSP90AA1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCHSP90AA12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC100133286' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_005952' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'XLOC_L2_005415' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-TTC26-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCTTC262)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GNAI1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-A1CF-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCA1CF3)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DDN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-GPR15-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCGPR151)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MRGPRG' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC102725353' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SBNO2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LRRC26' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(KRTAP4-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'KRTAP42)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UBE2NL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SERPINB6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AVP' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SERINC5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-DYM-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCDYM1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TMEM95' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'PABPC3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-CADPS-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCCADPS1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-C9ORF103-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCC9ORF1031)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LINC00657' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TAF13' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SLC36A4-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSLC36A41)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC100129917' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'A4GALT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'UNCX' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GPR150' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-PLTP-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCPLTP1)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-ANKRD11-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCANKRD112)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'TINAGL1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOXO1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-GPR27-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCGPR272)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SCGB3A1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'FAM229A' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'POT1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-CR392000.1-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCCR392000.12)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SERPINA12-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSERPINA121)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LOC439951' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(LNC-SCEL-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LNCSCEL2)')) 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 'CHADL' OR upper(l.acc_txt) LIKE 'HEY1' OR upper(l.acc_txt) LIKE 'XLOC_L2_015508' OR upper(l.acc_txt) LIKE 'LNC-RAD1-2' OR upper(l.acc_txt) LIKE 'XLOC_L2_015209' OR upper(l.acc_txt) LIKE 'REEP3' OR upper(l.acc_txt) LIKE 'POR' OR upper(l.acc_txt) LIKE 'RBMS2' OR upper(l.acc_txt) LIKE 'LNC-C17ORF62-1' OR upper(l.acc_txt) LIKE 'C18ORF32' OR upper(l.acc_txt) LIKE 'LNC-HSP90AA1-2' OR upper(l.acc_txt) LIKE 'LOC100133286' OR upper(l.acc_txt) LIKE 'XLOC_L2_005952' OR upper(l.acc_txt) LIKE 'XLOC_L2_005415' OR upper(l.acc_txt) LIKE 'LNC-TTC26-2' OR upper(l.acc_txt) LIKE 'GNAI1' OR upper(l.acc_txt) LIKE 'LNC-A1CF-3' OR upper(l.acc_txt) LIKE 'DDN' OR upper(l.acc_txt) LIKE 'LNC-GPR15-1' OR upper(l.acc_txt) LIKE 'MRGPRG' OR upper(l.acc_txt) LIKE 'LOC102725353' OR upper(l.acc_txt) LIKE 'SBNO2' OR upper(l.acc_txt) LIKE 'LRRC26' OR upper(l.acc_txt) LIKE 'KRTAP4-2' OR upper(l.acc_txt) LIKE 'UBE2NL', $97 = 'SERPINB6' OR upper(l.acc_txt) LIKE 'AVP' OR upper(l.acc_txt) LIKE 'SERINC5' OR upper(l.acc_txt) LIKE 'LNC-DYM-1' OR upper(l.acc_txt) LIKE 'TMEM95' OR upper(l.acc_txt) LIKE 'PABPC3' OR upper(l.acc_txt) LIKE 'LNC-CADPS-1' OR upper(l.acc_txt) LIKE 'LNC-C9ORF103-1' OR upper(l.acc_txt) LIKE 'LINC00657' OR upper(l.acc_txt) LIKE 'TAF13' OR upper(l.acc_txt) LIKE 'LNC-SLC36A4-1' OR upper(l.acc_txt) LIKE 'LOC100129917' OR upper(l.acc_txt) LIKE 'A4GALT' OR upper(l.acc_txt) LIKE 'UNCX' OR upper(l.acc_txt) LIKE 'GPR150' OR upper(l.acc_txt) LIKE 'LNC-PLTP-1' OR upper(l.acc_txt) LIKE 'LNC-ANKRD11-2' OR upper(l.acc_txt) LIKE 'TINAGL1' OR upper(l.acc_txt) LIKE 'NOXO1' OR upper(l.acc_txt) LIKE 'LNC-GPR27-2' OR upper(l.acc_txt) LIKE 'SCGB3A1' OR upper(l.acc_txt) LIKE 'FAM229A' OR upper(l.acc_txt) LIKE 'POT1' OR upper(l.acc_txt) LIKE 'LNC-CR392000.1-2' OR upper(l.acc_txt) LIKE 'LNC-SERPINA12-1' OR upper(l.acc_txt) LIKE 'LOC439951' OR upper(l.acc_txt) LIKE 'LNC-SCEL-2' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd; [ Date:* 2026-06-04 06:31:48 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
4	1m52s	COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 06:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
5	1m51s	COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 10:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
6	1m51s	COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 14:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
7	1m51s	COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 18:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
8	24s142ms	COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 06:07:17 ]
9	23s881ms	COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 14:07:17 ]
10	23s843ms	COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 10:07:17 ]
11	23s835ms	COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout; [ Date: 2026-06-04 18:07:17 ]
12	19s566ms	COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout; [ Date: 2026-06-04 18:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
13	19s496ms	COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout; [ Date: 2026-06-04 06:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
14	19s383ms	COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout; [ Date: 2026-06-04 10:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
15	19s367ms	COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout; [ Date: 2026-06-04 14:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
16	15s547ms	COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout; [ Date: 2026-06-04 14:07:32 ]
17	15s524ms	COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout; [ Date: 2026-06-04 18:07:32 ]
18	15s372ms	COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout; [ Date: 2026-06-04 06:07:33 ]
19	15s340ms	COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout; [ Date: 2026-06-04 10:07:33 ]
20	14s818ms	SELECT /* DiseaseGeneAssnsDAO / d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd \|\| '^' \|\| a.action_type_nm, '\|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2195504') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort; [ Date:* 2026-06-04 23:04:03 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Time consuming queries (N)


[ User: pubc - Total duration: 9m16s - Times executed: 1 ]
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
[ User: pubeu - Total duration: 6m25s - Times executed: 2 ]
Date: 2026-06-04 06:07:17
Duration: 24s142ms
[ User: postgres - Total duration: 1m17s - Times executed: 4 ]
Date: 2026-06-04 14:07:32
Duration: 15s547ms
Date: 2026-06-04 06:00:51
Duration: 14s790ms
Date: 2026-06-04 06:01:06
Duration: 14s554ms
[ User: pubeu - Total duration: 35s321ms - Times executed: 3 ]
Date: 2026-06-04 18:00:30
Duration: 7s419ms
[ User: pubeu - Total duration: 26s914ms - Times executed: 5 ]
Date: 2026-06-04 18:01:14
Duration: 6s424ms
Date: 2026-06-04 18:00:37
Duration: 6s126ms
[ User: pubeu - Total duration: 13s200ms - Times executed: 2 ]
[ User: pubeu - Total duration: 5s748ms - Times executed: 1 ]
[ User: pubeu - Total duration: 10s129ms - Times executed: 1 ]
[ User: pubeu - Total duration: 8s55ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s594ms - Times executed: 1 ]
[ User: edit - Total duration: 7s567ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s44ms - Times executed: 1 ]

Most frequent queries (N)


[ User: pubeu - Total duration: 26s914ms - Times executed: 5 ]
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
Date: 2026-06-04 06:07:17
Duration: 24s142ms
[ User: postgres - Total duration: 1m17s - Times executed: 4 ]
Date: 2026-06-04 14:07:32
Duration: 15s547ms
Date: 2026-06-04 06:00:51
Duration: 14s790ms
Date: 2026-06-04 06:01:06
Duration: 14s554ms
Date: 2026-06-04 18:00:30
Duration: 7s419ms
Date: 2026-06-04 18:01:14
Duration: 6s424ms
Date: 2026-06-04 18:00:37
Duration: 6s126ms
[ User: pubeu - Total duration: 35s321ms - Times executed: 3 ]
[ User: pubeu - Total duration: 6m25s - Times executed: 2 ]
[ User: pubeu - Total duration: 13s200ms - Times executed: 2 ]
[ User: pubeu - Total duration: 5s748ms - Times executed: 1 ]
[ User: pubc - Total duration: 9m16s - Times executed: 1 ]
[ User: pubeu - Total duration: 10s129ms - Times executed: 1 ]
[ User: pubeu - Total duration: 8s55ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s594ms - Times executed: 1 ]
[ User: edit - Total duration: 7s567ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s44ms - Times executed: 1 ]

Normalized slowest queries (N)


[ User: pubc - Total duration: 9m16s - Times executed: 1 ]
[ User: pubeu - Total duration: 6m25s - Times executed: 2 ]
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
Date: 2026-06-04 06:07:17
Duration: 24s142ms
[ User: postgres - Total duration: 1m17s - Times executed: 4 ]
Date: 2026-06-04 14:07:32
Duration: 15s547ms
Date: 2026-06-04 06:00:51
Duration: 14s790ms
Date: 2026-06-04 06:01:06
Duration: 14s554ms
[ User: pubeu - Total duration: 35s321ms - Times executed: 3 ]
[ User: pubeu - Total duration: 10s129ms - Times executed: 1 ]
[ User: pubeu - Total duration: 8s55ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s594ms - Times executed: 1 ]
[ User: edit - Total duration: 7s567ms - Times executed: 1 ]
Date: 2026-06-04 18:00:30
Duration: 7s419ms
[ User: pubeu - Total duration: 7s44ms - Times executed: 1 ]
[ User: pubeu - Total duration: 13s200ms - Times executed: 2 ]
Date: 2026-06-04 18:01:14
Duration: 6s424ms
Date: 2026-06-04 18:00:37
Duration: 6s126ms
[ User: pubeu - Total duration: 5s748ms - Times executed: 1 ]
[ User: pubeu - Total duration: 26s914ms - Times executed: 5 ]

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

1

0ms

2

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Jun 04	06	2	0ms	0ms

[ User: pubeu - Total duration: 6m25s - Times executed: 2 ]

;

Date: Duration: 0ms Database: postgres User: ctdprd51 Remote: pubeu

Log levels

Key values

7,947 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	17	0.21%
EVENTLOG	8	0.10%
LOG	7,918	99.64%
STATEMENT	4	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
0 ERROR entries
0 WARNING entries
8 EVENTLOG entries

Most Frequent Errors/Events

Key values

8 Max number of times the same event was reported
8 Total events found

Rank

Times reported

Error

1

8

Details

LOG: could not receive data from client: Connection timed out

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jun 04	01	3
	02	2
	11	2
	19	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values