pgBadger :: PostgreSQL Log Analyzer

Global information
- Generated on Thu Apr 30 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260429
- Parsed 20,006 log entries in 2s
- Log start from 2026-04-29 00:00:01 to 2026-04-29 23:58:34

Global Stats

86 Number of unique normalized queries
142 Number of queries
5h26m40s Total query duration
2026-04-29 00:09:19 First query
2026-04-29 23:53:11 Last query
1 queries/s at 2026-04-29 05:44:06 Query peak

5h26m40s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5h26m40s Execute total duration

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

23 Total number of automatic vacuums
41 Total number of automatic analyzes

975 Number temporary file
1.00 GiB Max size of temporary file
555.05 MiB Average size of temporary file

1,991 Total number of sessions
119 sessions at 2026-04-29 00:01:24 Session peak
40d6h9m28s Total duration of sessions
29m6s Average duration of sessions
0 Average queries per session
9s844ms Average queries duration per session
28m57s Average idle time per session

1,996 Total number of connections
13 connections/s at 2026-04-29 13:07:39 Connection peak
2 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-04-29 05:44:06 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-04-29 05:44:06 Date

INSERT/UPDATE/DELETE Traffic

Key values

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

Queries duration

Key values

5h26m40s 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)
Apr 29	00	2	0ms	9m17s	4m42s	0ms	0ms	9m24s
	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	2	0ms	5s154ms	5s146ms	0ms	0ms	10s292ms
	05	6	0ms	7s617ms	6s907ms	5s574ms	13s107ms	15s229ms
	06	9	0ms	1m51s	24s440ms	20s934ms	47s856ms	1m51s
	07	0	0ms	0ms	0ms	0ms	0ms	0ms
	08	2	0ms	6s118ms	6s103ms	0ms	6s89ms	6s118ms
	09	1	0ms	6s747ms	6s747ms	0ms	0ms	6s747ms
	10	10	0ms	1m51s	24s400ms	20s913ms	39s665ms	1m51s
	11	1	0ms	34s965ms	34s965ms	0ms	0ms	34s965ms
	12	6	0ms	2m22s	1m10s	0ms	2m4s	4m11s
	13	4	0ms	6s152ms	5s668ms	0ms	5s648ms	6s152ms
	14	9	0ms	1m51s	24s448ms	20s947ms	48s265ms	1m51s
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms	0ms	0ms
	17	7	0ms	29m9s	8m20s	4m	16m26s	29m9s
	18	18	0ms	34m55s	2m59s	1m51s	12m8s	35m3s
	19	5	0ms	1m2s	55s81ms	55s25ms	58s582ms	1m2s
	20	1	0ms	48m49s	48m49s	0ms	0ms	48m49s
	21	18	0ms	1h4m50s	5m3s	3m44s	7m28s	1h4m50s
	22	31	0ms	5m21s	1m9s	2m22s	3m37s	5m21s
	23	10	0ms	1m3s	26s198ms	28s59ms	57s280ms	1m31s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 29	00	1	0	9m17s	0ms	0ms	9m17s
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	2	0	5s146ms	0ms	0ms	10s292ms
	05	6	0	6s907ms	0ms	5s574ms	15s229ms
	06	0	9	24s440ms	0ms	20s934ms	1m51s
	07	0	0	0ms	0ms	0ms	0ms
	08	2	0	6s103ms	0ms	0ms	6s118ms
	09	1	0	6s747ms	0ms	0ms	6s747ms
	10	1	9	24s400ms	0ms	20s913ms	1m51s
	11	1	0	34s965ms	0ms	0ms	34s965ms
	12	2	0	1m57s	0ms	0ms	2m4s
	13	4	0	5s668ms	0ms	0ms	6s152ms
	14	0	9	24s448ms	0ms	20s947ms	1m51s
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	6	9	3m28s	0ms	1m8s	35m3s
	19	5	0	55s81ms	0ms	55s25ms	1m2s
	20	1	0	48m49s	0ms	0ms	48m49s
	21	18	0	5m3s	1m8s	3m44s	1h4m50s
	22	6	0	1m30s	0ms	12s874ms	5m21s
	23	10	0	26s198ms	0ms	28s59ms	1m31s

Day	Hour	INSERT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 29	00	0	0ms	0ms	0ms	0ms
	01	0	0ms	0ms	0ms	0ms
	02	0	0ms	0ms	0ms	0ms
	03	0	0ms	0ms	0ms	0ms
	04	0	0ms	0ms	0ms	0ms
	05	0	0ms	0ms	0ms	0ms
	06	0	0ms	0ms	0ms	0ms
	07	0	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	7	8m20s	0ms	0ms	16m26s
	18	3	36s45ms	0ms	0ms	20s158ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	0	0ms	0ms	0ms	0ms
	23	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Apr 29	00	0	0.00	0.00%
	01	0	0.00	0.00%
	02	0	0.00	0.00%
	03	0	0.00	0.00%
	04	2	2.00	0.00%
	05	6	6.00	0.00%
	06	0	0.00	0.00%
	07	0	0.00	0.00%
	08	2	2.00	0.00%
	09	1	1.00	0.00%
	10	0	0.00	0.00%
	11	1	1.00	0.00%
	12	1	1.00	0.00%
	13	4	4.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	17	7	7.00	0.00%
	18	9	9.00	0.00%
	19	5	5.00	0.00%
	20	1	1.00	0.00%
	21	18	18.00	0.00%
	22	31	31.00	0.00%
	23	10	10.00	0.00%

Day	Hour	Count	Average / Second
Apr 29	00	82	0.02/s
	01	82	0.02/s
	02	86	0.02/s
	03	78	0.02/s
	04	92	0.03/s
	05	92	0.03/s
	06	79	0.02/s
	07	83	0.02/s
	08	84	0.02/s
	09	77	0.02/s
	10	87	0.02/s
	11	80	0.02/s
	12	83	0.02/s
	13	95	0.03/s
	14	81	0.02/s
	15	79	0.02/s
	16	75	0.02/s
	17	77	0.02/s
	18	95	0.03/s
	19	80	0.02/s
	20	75	0.02/s
	21	75	0.02/s
	22	82	0.02/s
	23	97	0.03/s

Day	Hour	Count	Average Duration	Average idle time
Apr 29	00	82	29m33s	29m26s
	01	82	28m57s	28m57s
	02	86	28m1s	28m1s
	03	78	31m38s	31m38s
	04	92	26m45s	26m45s
	05	92	26m11s	26m11s
	06	79	30m27s	30m24s
	07	83	28m55s	28m55s
	08	84	28m45s	28m44s
	09	77	31m3s	31m3s
	10	83	29m21s	29m18s
	11	79	30m54s	30m53s
	12	84	28m49s	28m44s
	13	95	25m37s	25m36s
	14	81	30m42s	30m39s
	15	79	31m12s	31m12s
	16	75	30m58s	30m58s
	17	76	31m43s	30m57s
	18	95	26m16s	25m42s
	19	80	30m12s	30m8s
	20	75	31m22s	30m43s
	21	75	32m29s	31m16s
	22	82	27m41s	27m15s
	23	97	24m51s	24m49s

↑ Back to the top of the General Activity table

Database	User	Count
ctdprd51		1,994
	edit	1
	editeu	367
	load	55
	postgres	8
	pub2	6
	pubc	1
	pubeu	801
	qaeu	755
postgres		2
	edit	2

User	Count
edit	3
editeu	367
load	55
postgres	8
pub2	6
pubc	1
pubeu	801
qaeu	755

Host	Count
10.12.5.45	380
10.12.5.46	375
10.12.5.53	427
10.12.5.54	375
10.12.5.55	367
10.12.5.56	59
192.168.201.6	5
::1	8

Simultaneous sessions

Key values

119 sessions Session Peak
2026-04-29 00:01:24 Date

Histogram of session times

Key values

1,802 1800000-3600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	19	0.95%
500ms-1s	7	0.35%
1s-30s	33	1.66%
30s-1m	32	1.61%
1m-10m	74	3.72%
10m-30m	21	1.05%
30m-1h	1,802	90.51%
1h-8h	3	0.15%
> 8h	0	0.00%

Sessions per database

Key values

ctdprd51 Main Database
1,991 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctdprd51	1,990	40d6h9m28s	29m7s
postgres	1	796ms	796ms

Sessions per user

Key values

pubeu Main User
1,991 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
edit	1	796ms	796ms
editeu	367	7d22h38m20s	31m10s
load	53	5h29m41s	6m13s
postgres	8	15m31s	1m56s
pub2	5	1h27m29s	17m29s
pubc	1	9m24s	9m24s
pubeu	801	16d28m30s	28m47s
qaeu	755	15d23h40m29s	30m29s

Sessions per host

Key values

10.12.5.53 Main Host
1,991 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.45	380	7d23h59m37s	30m18s
10.12.5.46	375	7d23h40m51s	30m40s
10.12.5.53	427	8d33m6s	27m3s
10.12.5.54	375	8d4m49s	30m43s
10.12.5.55	367	7d22h38m20s	31m10s
10.12.5.56	58	6h57m11s	7m11s
192.168.201.6	1	796ms	796ms
::1	8	15m31s	1m56s

Sessions per application

Key values

unknown Main Application
1,991 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
pgAdmin 4 - DB:postgres	1	796ms	796ms
pg_bulkload	12	16s889ms	1s407ms
unknown	1,978	40d6h9m11s	29m18s

Checkpoints Buffers

Key values

1,058,871 buffers Checkpoint Peak
2026-04-29 18:21:08 Date
1619.889 seconds Highest write time
15.243 seconds Sync time

Checkpoints Wal files

Key values

571 files Wal files usage Peak
2026-04-29 22:04:28 Date

Checkpoints distance

Key values

17,241.25 Mo Distance Peak
2026-04-29 22:04:28 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Apr 29	00	49,533	1,650.931s	0.002s	1,651.073s
	01	116	11.782s	0.002s	11.793s
	02	106	10.796s	0.002s	10.806s
	03	174	17.633s	0.002s	17.642s
	04	137	13.922s	0.002s	13.931s
	05	191	19.304s	0.002s	19.313s
	06	385	38.71s	0.002s	38.72s
	07	423	42.59s	0.002s	42.599s
	08	328	33.071s	0.002s	33.081s
	09	321	32.357s	0.002s	32.374s
	10	355	35.767s	0.004s	35.778s
	11	161	16.314s	0.002s	16.322s
	12	816	81.806s	0.01s	83.209s
	13	32,572	1,629.658s	0.003s	1,630.177s
	14	1,271	127.535s	0.003s	127.549s
	15	34	3.584s	0.002s	3.592s
	16	152	15.425s	0.003s	15.435s
	17	3,252,654	2,800.855s	0.687s	2,806.887s
	18	1,382,956	3,239.172s	0.02s	3,241.018s
	19	35,334	1,619.534s	0.001s	1,619.555s
	20	10,398	1,041.376s	0.002s	1,041.41s
	21	26	2.749s	0.025s	2.821s
	22	644,443	2,018.853s	15.26s	2,041.697s
	23	143,433	1,619.73s	0.001s	1,620.232s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Apr 29	00	32	0	89	0.001s	0.002s
	01	0	0	27	0.001s	0.002s
	02	0	0	32	0.001s	0.002s
	03	0	0	41	0.001s	0.002s
	04	0	0	32	0.001s	0.002s
	05	0	0	33	0.001s	0.002s
	06	0	0	79	0.001s	0.002s
	07	0	0	129	0.001s	0.002s
	08	0	0	128	0.001s	0.002s
	09	1	0	32	0.001s	0.002s
	10	0	0	176	0.001s	0.002s
	11	0	0	65	0.001s	0.002s
	12	49	570	106	0.001s	0.002s
	13	0	216	51	0.001s	0.002s
	14	0	0	42	0.001s	0.003s
	15	0	0	17	0.001s	0.002s
	16	0	0	61	0.001s	0.002s
	17	31	2,691	453	0.078s	0.011s
	18	0	796	364	0.001s	0.002s
	19	0	0	34	0.001s	0.001s
	20	7	0	34	0.001s	0.002s
	21	0	0	9	0.016s	0.003s
	22	0	3,495	241	12.415s	0.417s
	23	0	175	46	0.001s	0.001s

Day	Hour	Avg time (sec)
Apr 29	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
Apr 29	00	264,066.50 kB	922,112.50 kB
	01	292.50 kB	770,607.50 kB
	02	216.50 kB	624,254.00 kB
	03	364.50 kB	505,702.50 kB
	04	265.50 kB	409,668.00 kB
	05	439.50 kB	331,913.00 kB
	06	959.00 kB	269,018.00 kB
	07	1,376.50 kB	218,156.50 kB
	08	964.00 kB	176,888.00 kB
	09	720.50 kB	143,441.00 kB
	10	843.50 kB	116,316.00 kB
	11	463.50 kB	94,321.00 kB
	12	4,814,917.50 kB	4,814,917.50 kB
	13	2,025,027.00 kB	7,925,122.50 kB
	14	2,724.00 kB	6,104,762.67 kB
	15	44.00 kB	4,680,295.00 kB
	16	450.50 kB	3,791,088.50 kB
	17	8,813,481.40 kB	8,815,222.00 kB
	18	6,785,277.00 kB	8,615,891.00 kB
	19	545.00 kB	7,571,797.00 kB
	20	54,466.00 kB	6,484,230.50 kB
	21	106.00 kB	5,528,675.00 kB
	22	7,092,617.88 kB	8,279,949.88 kB
	23	3,385,538.00 kB	8,277,080.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (41) Main checkpoint cause
56 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	41
wal	15
Total	56

Size of temporary files

Key values

50.00 GiB Temp Files size Peak
2026-04-29 21:45:09 Date

Number of temporary files

Key values

50 per second Temp Files Peak
2026-04-29 21:45:09 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Apr 29	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	155	11.63 GiB	76.82 MiB
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	31	30.25 GiB	999.17 MiB
	20	61	60.74 GiB	1019.62 MiB
	21	293	290.79 GiB	1016.26 MiB
	22	260	117.68 GiB	463.48 MiB
	23	175	17.41 GiB	101.89 MiB

↑ 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	286	284.45 GiB	89.53 MiB	1.00 GiB	1018.46 MiB	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.gene_go_annot gga, pub2.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in; select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in; Date: 2026-04-29 21:44:56 Duration: 0ms
2	225	30.77 GiB	8.00 KiB	1.00 GiB	140.05 MiB	select * from pgbulkload.pg_bulkload (?); SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}'); Date: 2026-04-29 21:57:53 Duration: 7m28s Database: ctdprd51 User: load Application: pg_bulkload SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}'); Date: 2026-04-29 22:35:19 Duration: 5m21s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.DUPE}'); Date: 2026-04-29 12:02:37 Duration: 2m4s
3	61	60.74 GiB	756.92 MiB	1.00 GiB	1019.62 MiB	select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.object_type where cd = ?), ptr.term_id, ( select id from pub2.object_type where cd = ?), ( select current_date) from pub2.gene_chem_reference gcr, pub2.phenotype_term_reference ptr, pub2.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in; select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in; Date: 2026-04-29 20:25:51 Duration: 0ms
4	35	4.89 GiB	82.18 MiB	217.33 MiB	143.18 MiB	vacuum full analyze db_link; vacuum FULL analyze db_link; Date: 2026-04-29 12:30:30 Duration: 2m22s vacuum FULL analyze db_link; Date: 2026-04-29 12:28:34 Duration: 0ms
5	35	1.23 GiB	24.32 MiB	51.84 MiB	35.96 MiB	vacuum full analyze ixn_actor; vacuum FULL analyze ixn_actor; Date: 2026-04-29 12:27:21 Duration: 26s759ms vacuum FULL analyze ixn_actor; Date: 2026-04-29 12:27:01 Duration: 0ms Database: ctdprd51 User: edit Application: pgAdmin 4 - CONN:6933350
6	31	30.25 GiB	254.18 MiB	1.00 GiB	999.17 MiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub2.gene_chem_reference gcr, pub2.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; Date: 2026-04-29 19:32:53 Duration: 0ms
7	25	405.86 MiB	12.05 MiB	20.69 MiB	16.23 MiB	vacuum full analyze ixn; vacuum FULL analyze ixn; Date: 2026-04-29 12:27:45 Duration: 8s583ms vacuum FULL analyze ixn; Date: 2026-04-29 12:27:39 Duration: 0ms
8	20	220.39 MiB	7.09 MiB	17.20 MiB	11.02 MiB	vacuum full analyze term; vacuum FULL analyze TERM; Date: 2026-04-29 12:27:15 Duration: 11s314ms vacuum FULL analyze TERM; Date: 2026-04-29 12:27:06 Duration: 0ms
9	20	14.02 GiB	8.00 KiB	1.00 GiB	717.87 MiB	create unique index gene_disease_reference_ak1 on pub2.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); Date: 2026-04-29 22:06:03 Duration: 4m11s CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); Date: 2026-04-29 22:06:02 Duration: 0ms
10	15	7.79 GiB	8.00 KiB	1.00 GiB	531.75 MiB	alter table pub2.gene_disease_reference add constraint gene_disease_reference_pk primary key (id); ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); Date: 2026-04-29 22:01:52 Duration: 2m36s ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); Date: 2026-04-29 22:01:52 Duration: 0ms Database: ctdprd51 User: pub2
11	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_dis_gene on pub2.gene_disease_reference using btree (disease_id, gene_id); CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id); Date: 2026-04-29 22:16:32 Duration: 2m22s CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id); Date: 2026-04-29 22:16:31 Duration: 0ms
12	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_reference on pub2.gene_disease_reference using btree (reference_id); CREATE INDEX ix_gene_disease_ref_reference ON pub2.gene_disease_reference USING btree (reference_id); Date: 2026-04-29 22:14:09 Duration: 1m45s CREATE INDEX ix_gene_disease_ref_reference ON pub2.gene_disease_reference USING btree (reference_id); Date: 2026-04-29 22:14:09 Duration: 0ms
13	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_reference_ixn on pub2.gene_disease_reference using btree (ixn_id); CREATE INDEX ix_gene_disease_reference_ixn ON pub2.gene_disease_reference USING btree (ixn_id); Date: 2026-04-29 22:18:20 Duration: 1m48s CREATE INDEX ix_gene_disease_reference_ixn ON pub2.gene_disease_reference USING btree (ixn_id); Date: 2026-04-29 22:18:19 Duration: 0ms
14	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_disease on pub2.gene_disease_reference using btree (disease_id); CREATE INDEX ix_gene_disease_ref_disease ON pub2.gene_disease_reference USING btree (disease_id); Date: 2026-04-29 22:12:24 Duration: 1m51s CREATE INDEX ix_gene_disease_ref_disease ON pub2.gene_disease_reference USING btree (disease_id); Date: 2026-04-29 22:12:24 Duration: 0ms
15	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_mod_tm on pub2.gene_disease_reference using btree (mod_tm); CREATE INDEX ix_gene_disease_ref_mod_tm ON pub2.gene_disease_reference USING btree (mod_tm); Date: 2026-04-29 22:20:11 Duration: 1m50s CREATE INDEX ix_gene_disease_ref_mod_tm ON pub2.gene_disease_reference USING btree (mod_tm); Date: 2026-04-29 22:20:10 Duration: 0ms
16	10	1.17 GiB	8.00 KiB	244.22 MiB	120.13 MiB	alter table pub2.phenotype_term_reference add constraint phenotype_term_reference_pk primary key (id); ALTER TABLE pub2.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id); Date: 2026-04-29 22:25:42 Duration: 13s398ms ALTER TABLE pub2.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id); Date: 2026-04-29 22:25:41 Duration: 0ms
17	10	260.13 MiB	8.00 KiB	53.52 MiB	26.01 MiB	alter table pub2.chem_disease_reference add constraint chem_disease_reference_pk primary key (id); ALTER TABLE pub2.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id); Date: 2026-04-29 22:25:46 Duration: 0ms
18	10	473.98 MiB	8.00 KiB	99.51 MiB	47.40 MiB	create unique index chem_disease_reference_ak1 on pub2.chem_disease_reference using btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id); CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub2.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id); Date: 2026-04-29 22:25:53 Duration: 6s855ms CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub2.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id); Date: 2026-04-29 22:25:53 Duration: 0ms
19	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_chem on pub2.gene_disease_reference using btree (via_chem_id); CREATE INDEX ix_gene_disease_ref_chem ON pub2.gene_disease_reference USING btree (via_chem_id); Date: 2026-04-29 22:10:33 Duration: 1m55s CREATE INDEX ix_gene_disease_ref_chem ON pub2.gene_disease_reference USING btree (via_chem_id); Date: 2026-04-29 22:10:32 Duration: 0ms
20	10	7.79 GiB	532.64 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_source_cd on pub2.gene_disease_reference using btree (source_cd); CREATE INDEX ix_gene_disease_ref_source_cd ON pub2.gene_disease_reference USING btree (source_cd); Date: 2026-04-29 22:08:37 Duration: 1m23s CREATE INDEX ix_gene_disease_ref_source_cd ON pub2.gene_disease_reference USING btree (source_cd); Date: 2026-04-29 22:08:37 Duration: 0ms
21	10	7.79 GiB	563.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_net_sc on pub2.gene_disease_reference using btree (network_score); CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score); Date: 2026-04-29 22:23:07 Duration: 2m56s CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score); Date: 2026-04-29 22:23:07 Duration: 0ms
22	10	7.79 GiB	550.93 MiB	1.00 GiB	797.63 MiB	create index ix_gene_disease_ref_src_db on pub2.gene_disease_reference using btree (source_acc_db_id); CREATE INDEX ix_gene_disease_ref_src_db ON pub2.gene_disease_reference USING btree (source_acc_db_id); Date: 2026-04-29 22:07:13 Duration: 1m10s CREATE INDEX ix_gene_disease_ref_src_db ON pub2.gene_disease_reference USING btree (source_acc_db_id); Date: 2026-04-29 22:07:13 Duration: 0ms
23	7	6.33 GiB	339.77 MiB	1.00 GiB	926.25 MiB	select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub2.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.object_type where cd = ?), cdr.mod_tm from pub2.chem_disease_reference cdr, pub2.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id; SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub2.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub2.CHEM_DISEASE_REFERENCE cdr, pub2.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id; Date: 2026-04-29 21:49:27 Duration: 0ms
24	5	260.11 MiB	51.33 MiB	52.36 MiB	52.02 MiB	create index ix_chem_disease_reference_dis on pub2.chem_disease_reference using btree (disease_id); CREATE INDEX ix_chem_disease_reference_dis ON pub2.chem_disease_reference USING btree (disease_id); Date: 2026-04-29 22:25:56 Duration: 0ms
25	5	1.17 GiB	239.25 MiB	242.01 MiB	240.25 MiB	create index ix_phenotype_term_ref_phenotype_id on pub2.phenotype_term_reference using btree (phenotype_id); CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub2.phenotype_term_reference USING btree (phenotype_id); Date: 2026-04-29 22:23:25 Duration: 16s869ms CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub2.phenotype_term_reference USING btree (phenotype_id); Date: 2026-04-29 22:23:25 Duration: 0ms
26	5	1.17 GiB	236.26 MiB	244.95 MiB	240.25 MiB	create index ix_phenotype_term_ref_taxon_id on pub2.phenotype_term_reference using btree (taxon_id); CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub2.phenotype_term_reference USING btree (taxon_id); Date: 2026-04-29 22:24:14 Duration: 10s684ms CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub2.phenotype_term_reference USING btree (taxon_id); Date: 2026-04-29 22:24:14 Duration: 0ms
27	5	1.17 GiB	231.24 MiB	251.47 MiB	240.25 MiB	create index ix_phenotype_term_ref_via_term_id on pub2.phenotype_term_reference using btree (via_term_id); CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub2.phenotype_term_reference USING btree (via_term_id); Date: 2026-04-29 22:25:14 Duration: 14s914ms CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub2.phenotype_term_reference USING btree (via_term_id); Date: 2026-04-29 22:25:14 Duration: 0ms
28	5	1.17 GiB	234.62 MiB	248.61 MiB	240.25 MiB	create index ix_phenotype_term_ref_term_id on pub2.phenotype_term_reference using btree (term_id); CREATE INDEX ix_phenotype_term_ref_term_id ON pub2.phenotype_term_reference USING btree (term_id); Date: 2026-04-29 22:23:37 Duration: 11s853ms CREATE INDEX ix_phenotype_term_ref_term_id ON pub2.phenotype_term_reference USING btree (term_id); Date: 2026-04-29 22:23:37 Duration: 0ms
29	5	260.10 MiB	47.68 MiB	53.76 MiB	52.02 MiB	create index ix_chem_disease_ref_mod_tm on pub2.chem_disease_reference using btree (mod_tm); CREATE INDEX ix_chem_disease_ref_mod_tm ON pub2.chem_disease_reference USING btree (mod_tm); Date: 2026-04-29 22:26:14 Duration: 0ms
30	5	260.10 MiB	46.94 MiB	57.52 MiB	52.02 MiB	create index ix_chem_disease_ref_source_cd on pub2.chem_disease_reference using btree (source_cd); CREATE INDEX ix_chem_disease_ref_source_cd ON pub2.chem_disease_reference USING btree (source_cd); Date: 2026-04-29 22:26:02 Duration: 0ms
31	5	1.65 GiB	332.00 MiB	345.35 MiB	337.16 MiB	create index ix_phenotype_term_ref_ids on pub2.phenotype_term_reference using btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id); CREATE INDEX ix_phenotype_term_ref_ids ON pub2.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id); Date: 2026-04-29 22:25:29 Duration: 14s596ms CREATE INDEX ix_phenotype_term_ref_ids ON pub2.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id); Date: 2026-04-29 22:25:29 Duration: 0ms
32	5	260.10 MiB	48.59 MiB	55.71 MiB	52.02 MiB	create index ix_chem_disease_reference_gene on pub2.chem_disease_reference using btree (via_gene_id); CREATE INDEX ix_chem_disease_reference_gene ON pub2.chem_disease_reference USING btree (via_gene_id); Date: 2026-04-29 22:26:07 Duration: 0ms
33	5	1.17 GiB	234.62 MiB	248.08 MiB	240.25 MiB	create index ix_phenotype_term_ref_object_type_id on pub2.phenotype_term_reference using btree (term_object_type_id); CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub2.phenotype_term_reference USING btree (term_object_type_id); Date: 2026-04-29 22:23:49 Duration: 12s536ms CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub2.phenotype_term_reference USING btree (term_object_type_id); Date: 2026-04-29 22:23:49 Duration: 0ms
34	5	1.17 GiB	234.43 MiB	248.63 MiB	240.25 MiB	create index ix_phenotype_term_ref_reference_id on pub2.phenotype_term_reference using btree (reference_id); CREATE INDEX ix_phenotype_term_ref_reference_id ON pub2.phenotype_term_reference USING btree (reference_id); Date: 2026-04-29 22:24:04 Duration: 14s128ms CREATE INDEX ix_phenotype_term_ref_reference_id ON pub2.phenotype_term_reference USING btree (reference_id); Date: 2026-04-29 22:24:04 Duration: 0ms
35	5	260.10 MiB	48.61 MiB	54.00 MiB	52.02 MiB	create index ix_chem_disease_ref_src_db on pub2.chem_disease_reference using btree (source_acc_db_id); CREATE INDEX ix_chem_disease_ref_src_db ON pub2.chem_disease_reference USING btree (source_acc_db_id); Date: 2026-04-29 22:26:04 Duration: 0ms
36	5	260.11 MiB	51.57 MiB	53.56 MiB	52.02 MiB	create index ix_chem_disease_reference_ref on pub2.chem_disease_reference using btree (reference_id); CREATE INDEX ix_chem_disease_reference_ref ON pub2.chem_disease_reference USING btree (reference_id); Date: 2026-04-29 22:25:59 Duration: 0ms
37	5	1.17 GiB	222.56 MiB	251.84 MiB	240.25 MiB	create index ix_phenotype_term_reference_term_reference_id on pub2.phenotype_term_reference using btree (term_reference_id); CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub2.phenotype_term_reference USING btree (term_reference_id); Date: 2026-04-29 22:24:47 Duration: 13s531ms CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub2.phenotype_term_reference USING btree (term_reference_id); Date: 2026-04-29 22:24:46 Duration: 0ms
38	5	1.17 GiB	235.18 MiB	248.77 MiB	240.25 MiB	create index ix_phenotype_term_reference_ixn_id on pub2.phenotype_term_reference using btree (ixn_id); CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub2.phenotype_term_reference USING btree (ixn_id); Date: 2026-04-29 22:24:59 Duration: 12s956ms CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub2.phenotype_term_reference USING btree (ixn_id); Date: 2026-04-29 22:24:59 Duration: 0ms
39	5	1.17 GiB	238.38 MiB	243.30 MiB	240.25 MiB	create index ix_phenotype_term_ref_evidence_cd on pub2.phenotype_term_reference using btree (evidence_cd); CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub2.phenotype_term_reference USING btree (evidence_cd); Date: 2026-04-29 22:24:24 Duration: 9s272ms CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub2.phenotype_term_reference USING btree (evidence_cd); Date: 2026-04-29 22:24:24 Duration: 0ms
40	5	1.17 GiB	233.58 MiB	243.41 MiB	240.25 MiB	create index ix_phenotype_term_reference_source_acc_db_id on pub2.phenotype_term_reference using btree (source_acc_db_id); CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub2.phenotype_term_reference USING btree (source_acc_db_id); Date: 2026-04-29 22:24:33 Duration: 9s384ms CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub2.phenotype_term_reference USING btree (source_acc_db_id); Date: 2026-04-29 22:24:33 Duration: 0ms
41	5	260.10 MiB	50.32 MiB	53.10 MiB	52.02 MiB	create index ix_chem_disease_ref_net_sc on pub2.chem_disease_reference using btree (network_score); CREATE INDEX ix_chem_disease_ref_net_sc ON pub2.chem_disease_reference USING btree (network_score); Date: 2026-04-29 22:26:19 Duration: 5s496ms CREATE INDEX ix_chem_disease_ref_net_sc ON pub2.chem_disease_reference USING btree (network_score); Date: 2026-04-29 22:26:19 Duration: 0ms
42	5	260.10 MiB	50.91 MiB	53.07 MiB	52.02 MiB	create index ix_chem_disease_reference_ixn on pub2.chem_disease_reference using btree (ixn_id); CREATE INDEX ix_chem_disease_reference_ixn ON pub2.chem_disease_reference USING btree (ixn_id); Date: 2026-04-29 22:26:10 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:53 ]
2	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
3	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
4	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
5	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
6	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
7	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
8	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
9	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
10	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
11	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
12	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
13	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
14	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
15	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
16	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:54 ]
17	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:55 ]
18	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:55 ]
19	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:55 ]
20	1.00 GiB	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn; [ Date: 2026-04-29 19:32:55 ]

Vacuums / Analyzes Distribution

Key values

66.95 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51
2026-04-29 17:53:54 Date
0 sec Highest CPU-cost analyze
Table
Database ctdprd51
Date

Average Autovacuum Duration

Key values

66.95 sec Highest CPU-cost vacuum
Table pub2.gene_go_annot
Database ctdprd51
2026-04-29 17:53:54 Date

Analyzes per table

Key values

pubc.log_query (15) Main table analyzed (database ctdprd51)
41 analyzes Total

Chart
Table

Table	Number of analyzes
ctdprd51.pubc.log_query	15
ctdprd51.pub2.db	2
ctdprd51.pg_catalog.pg_class	2
ctdprd51.pub2.term	2
ctdprd51.pub2.gene_go_annot	1
ctdprd51.pub2.reference	1
ctdprd51.pub2.db_link	1
ctdprd51.pub2.reference_party	1
ctdprd51.pub2.img	1
ctdprd51.pub2.chem_conc_anatomy	1
ctdprd51.pg_catalog.pg_index	1
ctdprd51.pub2.reference_party_role	1
ctdprd51.pub2.gene_taxon	1
ctdprd51.pub2.db_report	1
ctdprd51.pub2.term_pathway	1
ctdprd51.pub2.chem_conc	1
ctdprd51.pub2.dag_edge	1
ctdprd51.load.data_load	1
ctdprd51.pub2.term_label	1
ctdprd51.pub2.dag_node	1
ctdprd51.pub2.list_db_report	1
ctdprd51.pg_catalog.pg_attribute	1
ctdprd51.pub2.action_type	1
ctdprd51.pub2.db_report_site	1
Total	41

Vacuums per table

Key values

pub2.term (2) Main table vacuumed on database ctdprd51
23 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
ctdprd51.pub2.term	2	0	120,797	0	5	0	0	46,868	4	2,792,339
ctdprd51.pubc.log_query	2	1	438	0	82	0	0	146	54	353,674
ctdprd51.pub2.reference	1	0	78,867	0	3	0	0	1	1	2,373
ctdprd51.pub2.gene_go_annot	1	0	682,015	0	277,085	0	0	340,886	12	20,205,299
ctdprd51.pub2.reference_party	1	0	5,159	0	3	0	0	1	1	2,653
ctdprd51.pub2.db_link	1	0	325,357	0	131,655	0	0	162,541	6	9,633,770
ctdprd51.pg_toast.pg_toast_486223	1	0	25	0	0	0	0	1	0	188
ctdprd51.pub2.img	1	0	1,110	0	4	0	0	524	2	41,971
ctdprd51.pub2.chem_conc_anatomy	1	0	402	0	3	0	0	186	1	19,393
ctdprd51.pub2.reference_party_role	1	0	13,782	0	4	0	0	6,852	1	412,687
ctdprd51.pub2.db	1	1	151	0	15	0	0	20	9	30,867
ctdprd51.pg_catalog.pg_class	1	1	418	0	69	0	0	123	63	230,652
ctdprd51.pub2.gene_taxon	1	0	182,237	0	6	0	0	91,058	4	5,399,871
ctdprd51.pub2.term_pathway	1	0	3,336	0	4	0	0	1,614	2	107,101
ctdprd51.pub2.dag_edge	1	0	1,053	0	5	0	0	482	2	39,769
ctdprd51.pub2.chem_conc	1	0	624	0	3	0	0	294	1	25,765
ctdprd51.pg_toast.pg_toast_11146414	1	0	90,492	0	2	0	0	1	0	188
ctdprd51.pub2.term_label	1	0	229,553	0	39,334	0	0	114,722	5	6,803,980
ctdprd51.pg_toast.pg_toast_2619	1	1	4,325	0	1,078	0	10,421	3,250	1,026	499,596
ctdprd51.pub2.dag_node	1	0	84,430	0	4	0	0	42,088	2	2,499,808
ctdprd51.pg_catalog.pg_statistic	1	1	653	0	111	0	128	309	107	406,493
Total	23	5	1,825,224	383	449,475	0	10,549	811,967	1,303	49,508,437

Tuples removed per table

Key values

pg_toast.pg_toast_2619 (4092) Main table with removed tuples on database ctdprd51
4947 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
ctdprd51.pg_toast.pg_toast_2619	1	1	4,092	19,595	0	0	12,592
ctdprd51.pg_catalog.pg_statistic	1	1	572	2,650	0	0	410
ctdprd51.pub2.db	1	1	134	134	0	0	7
ctdprd51.pg_catalog.pg_class	1	1	103	1,830	0	0	94
ctdprd51.pubc.log_query	2	1	46	1,535	0	0	66
ctdprd51.pub2.reference	1	0	0	202,420	0	0	39,323
ctdprd51.pub2.gene_go_annot	1	0	0	53,520,202	0	0	340,885
ctdprd51.pub2.reference_party	1	0	0	455,646	0	0	2,545
ctdprd51.pub2.db_link	1	0	0	22,411,914	0	0	162,540
ctdprd51.pg_toast.pg_toast_486223	1	0	0	0	0	0	0
ctdprd51.pub2.img	1	0	0	50,650	0	0	523
ctdprd51.pub2.chem_conc_anatomy	1	0	0	19,683	0	0	185
ctdprd51.pub2.reference_party_role	1	0	0	1,267,402	0	0	6,851
ctdprd51.pub2.gene_taxon	1	0	0	14,295,882	0	0	91,057
ctdprd51.pub2.term_pathway	1	0	0	135,792	0	0	1,613
ctdprd51.pub2.dag_edge	1	0	0	88,931	0	0	481
ctdprd51.pub2.chem_conc	1	0	0	9,118	0	0	293
ctdprd51.pg_toast.pg_toast_11146414	1	0	0	244,521	0	0	45,237
ctdprd51.pub2.term_label	1	0	0	7,899,355	0	0	114,721
ctdprd51.pub2.dag_node	1	0	0	1,752,857	0	0	42,087
ctdprd51.pub2.term	2	0	0	2,208,037	0	0	64,688
Total	23	5	4,947	104,588,154	0	0	926,198

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.pub2.reference	1	0	0
ctdprd51.pub2.gene_go_annot	1	0	0
ctdprd51.pub2.reference_party	1	0	0
ctdprd51.pub2.db_link	1	0	0
ctdprd51.pg_toast.pg_toast_486223	1	0	0
ctdprd51.pub2.img	1	0	0
ctdprd51.pub2.chem_conc_anatomy	1	0	0
ctdprd51.pub2.reference_party_role	1	0	0
ctdprd51.pub2.db	1	1	134
ctdprd51.pg_catalog.pg_class	1	1	103
ctdprd51.pub2.gene_taxon	1	0	0
ctdprd51.pub2.term_pathway	1	0	0
ctdprd51.pub2.dag_edge	1	0	0
ctdprd51.pub2.chem_conc	1	0	0
ctdprd51.pg_toast.pg_toast_11146414	1	0	0
ctdprd51.pub2.term_label	1	0	0
ctdprd51.pg_toast.pg_toast_2619	1	1	4092
ctdprd51.pub2.dag_node	1	0	0
ctdprd51.pub2.term	2	0	0
ctdprd51.pg_catalog.pg_statistic	1	1	572
ctdprd51.pubc.log_query	2	1	46
Total	23	5	4,947

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
1 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessShareLock		1	1m47s	1m47s
	relation	1	1m47s	1m47s
	Total	1	1m47s	1m47s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	1m47s	1m47s	1m47s	1m47s	select o.cd, db.cd, count() from edit.db_link l, edit.db db, edit.object_type o where l.db_id = db.id and l.object_type_id = o.id group by o.cd, db.cd order by o.cd, db.cd; select o.cd, db.cd, count() from edit.db_link l, edit.db db, edit.object_type o where l.db_id = db.id and l.object_type_id = o.id group by o.cd, db.cd order by o.cd, db.cd; Date: 2026-04-29 12:30:29 select o.cd, db.cd, count() from edit.db_link l, edit.db db, edit.object_type o where l.db_id = db.id and l.object_type_id = o.id group by o.cd, db.cd order by o.cd, db.cd; Date:* 2026-04-29 12:30:28

Queries that waited the most

Rank	Wait time	Query
1	1m47s	select o.cd, db.cd, count() from edit.db_link l, edit.db db, edit.object_type o where l.db_id = db.id and l.object_type_id = o.id group by o.cd, db.cd order by o.cd, db.cd; [ Date:* 2026-04-29 12:30:28 ]

Queries by type

Key values

66 Total read queries
71 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	66	46.48%
INSERT	10	7.04%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	36	25.35%
CTE	0	0.00%
DDL	25	17.61%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	5	3.52%

Queries by database

Key values

unknown Main database
105 Requests
3h51m59s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctdprd51	Total	37	1h34m41s
	copy to	8	8m45s
	insert	1	16m16s
	select	28	1h9m39s
unknown	Total	105	3h51m59s
	copy to	28	5m55s
	ddl	25	26m38s
	insert	9	43m52s
	others	5	3m15s
	select	38	2h32m17s

Queries by user

Key values

unknown Main user
180 Requests

Queries Chart
Table

User	Request type	Count	Duration
edit	Total	1	8s818ms
	insert	1	8s818ms
load	Total	24	1h2m45s
	select	24	1h2m45s
postgres	Total	16	17m29s
	copy to	16	17m29s
pub2	Total	3	16m29s
	ddl	1	5s392ms
	insert	1	16m16s
	select	1	7s968ms
pubc	Total	1	9m17s
	select	1	9m17s
pubeu	Total	25	2m27s
	select	25	2m27s
qaeu	Total	3	18s651ms
	select	3	18s651ms
unknown	Total	180	4h31m43s
	copy to	56	11m49s
	ddl	25	26m38s
	insert	9	43m52s
	others	5	3m15s
	select	85	3h6m7s

Duration by user

Key values

4h31m43s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
edit	Total	1	8s818ms
	insert	1	8s818ms
load	Total	24	1h2m45s
	select	24	1h2m45s
postgres	Total	16	17m29s
	copy to	16	17m29s
pub2	Total	3	16m29s
	ddl	1	5s392ms
	insert	1	16m16s
	select	1	7s968ms
pubc	Total	1	9m17s
	select	1	9m17s
pubeu	Total	25	2m27s
	select	25	2m27s
qaeu	Total	3	18s651ms
	select	3	18s651ms
unknown	Total	180	4h31m43s
	copy to	56	11m49s
	ddl	25	26m38s
	insert	9	43m52s
	others	5	3m15s
	select	85	3h6m7s

Queries by host

Key values

unknown Main host
253 Requests
6h20m42s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	253	6h20m42s
	copy to	72	29m19s
	ddl	26	26m43s
	insert	11	1h17s
	others	5	3m15s
	select	139	4h21m6s

Queries by application

Key values

unknown Main application
124 Requests
4h57m33s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pgAdmin 4 - CONN:9784952	Total	1	23s830ms
	select	1	23s830ms
pg_bulkload	Total	8	10m39s
	select	8	10m39s
pg_dump	Total	8	8m45s
	copy to	8	8m45s
psql	Total	1	9m17s
	select	1	9m17s
unknown	Total	124	4h57m33s
	copy to	28	5m55s
	ddl	25	26m38s
	insert	10	1h8s
	others	5	3m15s
	select	56	3h21m35s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-04-29 18:32:30 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

103 > 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	39	27.46%
> 10000ms	103	72.54%

Slowest individual queries

Rank	Duration	Query
1	1h4m50s	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 21:30:46 - Bind query: yes ]
2	48m49s	select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.PHENOTYPE_TERM_REFERENCE ptr, pub2.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 20:25:49 - Bind query: yes ]
3	34m55s	SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc; [ Date: 2026-04-29 18:36:28 - Database: ctdprd51 - User: load - Bind query: yes ]
4	29m9s	insert into pub2.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT; [ Date: 2026-04-29 17:52:24 - Bind query: yes ]
5	16m16s	insert into pub2.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK; [ Date: 2026-04-29 17:17:04 - Database: ctdprd51 - User: pub2 - Bind query: yes ]
6	12m8s	select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub2.GENE_CHEM_REFERENCE gcr, pub2.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub2.gene_chem_reference_axn where action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 18:51:25 - Database: ctdprd51 - User: load - Bind query: yes ]
7	9m17s	/* * 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-04-29 00:09:19 - Database: ctdprd51 - User: pubc - Application: psql ]
8	7m28s	SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}'); [ Date: 2026-04-29 21:57:53 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
9	5m21s	SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.DAG_PATH,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}'); [ Date: 2026-04-29 22:35:19 - Bind query: yes ]
10	5m11s	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 21:44:14 - Bind query: yes ]
11	5m1s	insert into pub2.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON; [ Date: 2026-04-29 17:57:26 - Bind query: yes ]
12	4m11s	CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub2.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); [ Date: 2026-04-29 22:06:03 - Bind query: yes ]
13	4m	INSERT INTO pub2.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub2.TERM); [ Date: 2026-04-29 17:23:13 - Bind query: yes ]
14	3m44s	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub2.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub2.GENE_CHEM_REFERENCE gcr, pub2.GENE_GO_ANNOT gga, pub2.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub2.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 21:39:03 - Bind query: yes ]
15	2m56s	CREATE INDEX ix_gene_disease_ref_net_sc ON pub2.gene_disease_reference USING btree (network_score); [ Date: 2026-04-29 22:23:07 - Bind query: yes ]
16	2m36s	ALTER TABLE pub2.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); [ Date: 2026-04-29 22:01:52 - Bind query: yes ]
17	2m22s	vacuum FULL analyze db_link; [ Date: 2026-04-29 12:30:30 ]
18	2m22s	CREATE INDEX ix_gene_disease_ref_dis_gene ON pub2.gene_disease_reference USING btree (disease_id, gene_id); [ Date: 2026-04-29 22:16:32 - Bind query: yes ]
19	2m14s	SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub2.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub2.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub2.CHEM_DISEASE_REFERENCE cdr, pub2.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id AND ptr.source_cd = 'C' AND cdr.source_cd = 'C' AND ptr.ixn_id NOT IN ( SELECT ixn_id FROM pub2.IXN_AXN WHERE action_degree_type_nm = 'does not affect'); [ Date: 2026-04-29 21:47:25 - Bind query: yes ]
20	2m4s	SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=\|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/misc/bioGrid/output/dbLink.txt.DUPE}'); [ Date: 2026-04-29 12:02:37 - Bind query: yes ]

Time consuming queries (N)


Date: 2026-04-29 21:30:46
Duration: 1h4m50s
Bind query: yes
Date: 2026-04-29 20:25:49
Duration: 48m49s
Bind query: yes
[ User: load - Total duration: 34m55s - Times executed: 1 ]
Date: 2026-04-29 17:52:24
Duration: 29m9s
Bind query: yes
[ User: load - Total duration: 10m39s - Times executed: 8 ]
[ User: pub2 - Total duration: 16m16s - Times executed: 1 ]
[ User: load - Total duration: 12m8s - Times executed: 1 ]
[ User: pubc - Total duration: 9m17s - Times executed: 1 ]
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
Date: 2026-04-29 17:57:26
Duration: 5m1s
Bind query: yes
Date: 2026-04-29 22:06:03
Duration: 4m11s
Bind query: yes
Date: 2026-04-29 17:23:13
Duration: 4m
Bind query: yes
Date: 2026-04-29 22:23:07
Duration: 2m56s
Bind query: yes
Date: 2026-04-29 22:01:52
Duration: 2m36s
Bind query: yes
Date: 2026-04-29 12:30:30
Duration: 2m22s
Date: 2026-04-29 22:16:32
Duration: 2m22s
Bind query: yes
Date: 2026-04-29 21:47:25
Duration: 2m14s
Bind query: yes
Date: 2026-04-29 17:19:13
Duration: 1m57s
Bind query: yes
Date: 2026-04-29 22:10:33
Duration: 1m55s
Bind query: yes
Date: 2026-04-29 22:12:24
Duration: 1m51s
Bind query: yes

Most frequent queries (N)


[ User: load - Total duration: 10m39s - Times executed: 8 ]
Date: 2026-04-29 21:30:46
Duration: 1h4m50s
Bind query: yes
[ User: load - Total duration: 12m8s - Times executed: 1 ]
[ User: pubeu - Total duration: 28s9ms - Times executed: 5 ]
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
Date: 2026-04-29 10:07:18
Duration: 24s124ms
[ User: postgres - Total duration: 1m18s - Times executed: 4 ]
Date: 2026-04-29 10:07:33
Duration: 15s540ms
Date: 2026-04-29 18:00:52
Duration: 14s796ms
Date: 2026-04-29 18:01:07
Duration: 14s611ms
Date: 2026-04-29 10:00:31
Duration: 7s436ms
Date: 2026-04-29 06:01:15
Duration: 6s424ms
Date: 2026-04-29 14:00:38
Duration: 6s431ms
[ User: pubeu - Total duration: 7s612ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s617ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s574ms - Times executed: 1 ]
[ User: pubeu - Total duration: 10s292ms - Times executed: 2 ]
Date: 2026-04-29 20:25:49
Duration: 48m49s
Bind query: yes
[ User: load - Total duration: 34m55s - Times executed: 1 ]
Date: 2026-04-29 17:52:24
Duration: 29m9s
Bind query: yes

Normalized slowest queries (N)


Date: 2026-04-29 20:25:49
Duration: 48m49s
Bind query: yes
[ User: load - Total duration: 34m55s - Times executed: 1 ]
Date: 2026-04-29 17:52:24
Duration: 29m9s
Bind query: yes
[ User: pub2 - Total duration: 16m16s - Times executed: 1 ]
[ User: pubc - Total duration: 9m17s - Times executed: 1 ]
Date: 2026-04-29 21:30:46
Duration: 1h4m50s
Bind query: yes
Date: 2026-04-29 17:57:26
Duration: 5m1s
Bind query: yes
Date: 2026-04-29 22:06:03
Duration: 4m11s
Bind query: yes
Date: 2026-04-29 17:23:13
Duration: 4m
Bind query: yes
[ User: load - Total duration: 12m8s - Times executed: 1 ]
Date: 2026-04-29 22:23:07
Duration: 2m56s
Bind query: yes
Date: 2026-04-29 22:01:52
Duration: 2m36s
Bind query: yes
Date: 2026-04-29 12:30:30
Duration: 2m22s
Date: 2026-04-29 22:16:32
Duration: 2m22s
Bind query: yes
Date: 2026-04-29 21:47:25
Duration: 2m14s
Bind query: yes
Date: 2026-04-29 17:19:13
Duration: 1m57s
Bind query: yes
Date: 2026-04-29 22:10:33
Duration: 1m55s
Bind query: yes
[ User: postgres - Total duration: 7m26s - Times executed: 4 ]
Date: 2026-04-29 22:12:24
Duration: 1m51s
Bind query: yes
[ User: load - Total duration: 10m39s - Times executed: 8 ]

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

0ms

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Apr 28	12	1	0ms	0ms

;

Date: Duration: 0ms Database: postgres

Log levels

Key values

9,943 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	30	0.30%
ERROR	1	0.01%
EVENTLOG	1	0.01%
LOG	9,318	93.71%
STATEMENT	593	5.96%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
1 ERROR entries
0 WARNING entries
1 EVENTLOG entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

Details

ERROR: missing FROM-clause entry for table "..."

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Apr 29	10	1

ERROR: missing FROM-clause entry for table "l" at character 133

Details

LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Apr 29	12	1

LOG: process 1683650 still waiting for AccessShareLock on relation 2633821 of database 484829 after 1000.084 ms at character 35

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

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user