pgBadger :: PostgreSQL Log Analyzer

Global information
- Generated on Sat Nov 23 04:15:07 2024
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20241122
- Parsed 35,258 log entries in 6s
- Log start from 2024-11-22 00:00:01 to 2024-11-22 23:59:11

Global Stats

241 Number of unique normalized queries
1,505 Number of queries
6h12m33s Total query duration
2024-11-22 00:01:47 First query
2024-11-22 23:56:43 Last query
4 queries/s at 2024-11-22 02:16:06 Query peak

6h12m33s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
6h12m33s Execute total duration

23 Number of events
7 Number of unique normalized events
6 Max number of times the same event was reported
0 Number of cancellation

46 Total number of automatic vacuums
90 Total number of automatic analyzes

1,536 Number temporary file
1.00 GiB Max size of temporary file
204.94 MiB Average size of temporary file

2,696 Total number of sessions
138 sessions at 2024-11-22 23:35:29 Session peak
75d4h54m38s Total duration of sessions
40m10s Average duration of sessions
0 Average queries per session
8s291ms Average queries duration per session
40m1s Average idle time per session

2,703 Total number of connections
9 connections/s at 2024-11-22 03:11:44 Connection peak
2 Total number of databases

SQL Traffic

Key values

4 queries/s Query Peak
2024-11-22 02:16:06 Date

SELECT Traffic

Key values

4 queries/s Query Peak
2024-11-22 02:16:06 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2024-11-22 18:00:45 Date

Queries duration

Key values

6h12m33s 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)
Nov 22	00	51	0ms	19m10s	24s422ms	4s908ms	9s580ms	19m18s
	01	52	0ms	6s454ms	2s66ms	6s797ms	8s969ms	9s553ms
	02	72	0ms	3m8s	12s88ms	22s349ms	2m51s	3m57s
	03	40	0ms	3m10s	19s43ms	6s170ms	2m52s	3m10s
	04	54	0ms	4s943ms	1s223ms	2s526ms	5s488ms	7s328ms
	05	70	0ms	4s249ms	1s841ms	4s644ms	19s47ms	24s25ms
	06	40	0ms	38s275ms	3s619ms	4s300ms	9s625ms	55s829ms
	07	54	0ms	19s550ms	3s85ms	4s525ms	6s473ms	1m22s
	08	136	0ms	4m49s	5s423ms	28s636ms	50s131ms	4m52s
	09	78	0ms	17m29s	27s116ms	38s103ms	2m12s	17m29s
	10	86	0ms	38s159ms	4s207ms	15s917ms	39s13ms	55s868ms
	11	62	0ms	7s472ms	1s809ms	6s116ms	8s682ms	20s971ms
	12	44	0ms	6s923ms	1s587ms	3s429ms	5s156ms	10s985ms
	13	44	0ms	10s168ms	1s641ms	3s829ms	5s681ms	11s254ms
	14	104	0ms	4m5s	10s320ms	1m12s	1m30s	4m13s
	15	54	0ms	1m49s	13s112ms	1m14s	1m26s	1m51s
	16	38	0ms	11s481ms	2s253ms	3s683ms	5s470ms	24s207ms
	17	57	0ms	19s289ms	1s634ms	3s528ms	6s137ms	19s289ms
	18	58	0ms	38s332ms	3s629ms	9s711ms	14s180ms	1m20s
	19	73	0ms	23m55s	41s272ms	1m52s	4m6s	23m55s
	20	52	0ms	33m32s	53s660ms	37s100ms	1m8s	33m46s
	21	47	0ms	38m48s	53s287ms	6s728ms	36s740ms	38m49s
	22	67	0ms	42m38s	1m	1m34s	3m6s	42m39s
	23	72	0ms	5m8s	11s591ms	44s112ms	1m20s	5m8s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 22	00	49	0	25s240ms	2s766ms	4s898ms	9s624ms
	01	52	0	2s66ms	4s159ms	6s797ms	9s553ms
	02	72	0	12s88ms	7s123ms	22s349ms	2m59s
	03	40	0	19s43ms	2s464ms	6s170ms	3m10s
	04	54	0	1s223ms	2s353ms	2s526ms	5s721ms
	05	66	0	1s820ms	2s266ms	4s644ms	24s25ms
	06	30	10	3s619ms	2s124ms	4s300ms	54s689ms
	07	54	0	3s85ms	2s792ms	4s525ms	1m22s
	08	136	0	5s423ms	11s284ms	28s636ms	1m39s
	09	78	0	27s116ms	8s53ms	38s103ms	11m20s
	10	74	10	4s212ms	7s306ms	15s917ms	47s218ms
	11	62	0	1s809ms	3s520ms	6s116ms	20s971ms
	12	44	0	1s587ms	2s316ms	3s429ms	7s536ms
	13	43	0	1s443ms	2s333ms	3s700ms	5s681ms
	14	94	9	10s388ms	40s111ms	1m9s	1m34s
	15	50	0	11s415ms	5s662ms	1m13s	1m26s
	16	38	0	2s253ms	3s274ms	3s683ms	7s173ms
	17	57	0	1s634ms	2s521ms	3s528ms	9s266ms
	18	48	10	3s629ms	4s126ms	10s100ms	55s76ms
	19	61	0	1s227ms	2s256ms	3s388ms	4s863ms
	20	52	0	53s660ms	3s608ms	37s100ms	33m46s
	21	47	0	53s287ms	4s296ms	6s728ms	41s599ms
	22	56	0	58s507ms	6s265ms	13s709ms	6m42s
	23	48	0	9s585ms	2s385ms	4s567ms	1m9s

Day	Hour	INSERT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 22	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	1	10s168ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	12	4m4s	0ms	0ms	4m2s
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms
	22	1	1s439ms	0ms	0ms	0ms
	23	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Nov 22	00	49	49.00	0.00%
	01	52	52.00	0.00%
	02	72	72.00	0.00%
	03	40	40.00	0.00%
	04	54	54.00	0.00%
	05	75	75.00	0.00%
	06	35	35.00	0.00%
	07	57	57.00	0.00%
	08	138	138.00	0.00%
	09	90	90.00	0.00%
	10	72	72.00	0.00%
	11	62	62.00	0.00%
	12	44	44.00	0.00%
	13	43	43.00	0.00%
	14	96	96.00	0.00%
	15	55	55.00	0.00%
	16	38	38.00	0.00%
	17	57	57.00	0.00%
	18	48	48.00	0.00%
	19	73	73.00	0.00%
	20	52	52.00	0.00%
	21	47	47.00	0.00%
	22	67	67.00	0.00%
	23	72	72.00	0.00%

Day	Hour	Count	Average / Second
Nov 22	00	89	0.02/s
	01	181	0.05/s
	02	204	0.06/s
	03	202	0.06/s
	04	131	0.04/s
	05	91	0.03/s
	06	73	0.02/s
	07	84	0.02/s
	08	110	0.03/s
	09	95	0.03/s
	10	110	0.03/s
	11	90	0.03/s
	12	110	0.03/s
	13	133	0.04/s
	14	130	0.04/s
	15	111	0.03/s
	16	114	0.03/s
	17	87	0.02/s
	18	95	0.03/s
	19	89	0.02/s
	20	101	0.03/s
	21	79	0.02/s
	22	94	0.03/s
	23	100	0.03/s

Day	Hour	Count	Average Duration	Average idle time
Nov 22	00	89	27m29s	27m15s
	01	181	13m59s	13m59s
	02	202	12m15s	12m11s
	03	204	12m4s	12m
	04	131	18m5s	18m5s
	05	91	25m59s	25m58s
	06	73	31m17s	31m15s
	07	84	29m42s	29m40s
	08	110	21m28s	21m21s
	09	95	25m14s	24m52s
	10	104	5h52m48s	5h52m44s
	11	90	26m57s	26m56s
	12	110	22m34s	22m34s
	13	132	17m41s	17m40s
	14	131	18m25s	18m17s
	15	108	21m59s	21m53s
	16	114	22m31s	22m30s
	17	89	30m38s	30m37s
	18	94	25m21s	25m18s
	19	89	27m40s	27m6s
	20	101	24m1s	23m33s
	21	80	31m36s	31m4s
	22	94	3h9m30s	3h8m46s
	23	100	24m36s	24m28s

↑ Back to the top of the General Activity table

Database	User	Count
ctdprd51		2,700
	edit	7
	editeu	378
	load	130
	postgres	8
	pub1	12
	pubc	1
	pubeu	1,404
	qaeu	757
	zbx_monitor	3
postgres		3
	edit	2
	load	1

User	Count
edit	9
editeu	378
load	131
postgres	8
pub1	12
pubc	1
pubeu	1,404
qaeu	757
zbx_monitor	3

Host	Count
10.12.5.122	10
10.12.5.36	15
10.12.5.37	1,030
10.12.5.38	374
10.12.5.39	368
10.12.5.40	126
10.12.5.45	381
10.12.5.46	376
192.168.201.10	6
192.168.201.14	5
192.168.201.18	1
::1	11

Simultaneous sessions

Key values

138 sessions Session Peak
2024-11-22 23:35:29 Date

Histogram of session times

Key values

1,702 1800000-3600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	128	4.75%
500ms-1s	19	0.70%
1s-30s	121	4.49%
30s-1m	200	7.42%
1m-10m	368	13.65%
10m-30m	138	5.12%
30m-1h	1,702	63.13%
1h-8h	11	0.41%
> 8h	9	0.33%

Sessions per database

Key values

ctdprd51 Main Database
2,696 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctdprd51	2,695	75d2h40m16s	40m8s
postgres	1	2h14m21s	2h14m21s

Sessions per user

Key values

pubeu Main User
2,696 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
edit	6	10h58m4s	1h49m40s
editeu	378	31d18h25m27s	2h1m1s
load	127	4h18m28s	2m2s
postgres	8	7m44s	58s106ms
pub1	12	1h9m6s	5m45s
pubc	1	19m16s	19m16s
pubeu	1,404	16d2h37m14s	16m31s
qaeu	757	16d9m26s	30m26s
zbx_monitor	3	10d14h49m49s	3d12h56m36s

Sessions per host

Key values

10.12.5.37 Main Host
2,696 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.122	10	23d18h46m10s	2d9h4m37s
10.12.5.36	15	28s957ms	1s930ms
10.12.5.37	1,030	8d3h2m42s	11m21s
10.12.5.38	374	7d23h53m48s	30m47s
10.12.5.39	368	7d23h39m17s	31m14s
10.12.5.40	125	5h27m6s	2m37s
10.12.5.45	381	7d23h59m10s	30m14s
10.12.5.46	376	8d10m15s	30m39s
192.168.201.14	5	10h21m17s	2h4m15s
192.168.201.18	1	36m46s	36m46s
::1	11	10d14h57m34s	23h10m41s

Sessions per application

Key values

unknown Main Application
2,696 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
pgAdmin 4 - DB:ctdprd51	1	622ms	622ms
pg_bulkload	11	6s759ms	614ms
psql	16	5s901ms	368ms
unknown	2,668	75d4h54m25s	40m35s

Checkpoints Buffers

Key values

923,499 buffers Checkpoint Peak
2024-11-22 22:49:58 Date
1619.917 seconds Highest write time
4.723 seconds Sync time

Checkpoints Wal files

Key values

570 files Wal files usage Peak
2024-11-22 15:21:00 Date

Checkpoints distance

Key values

17,795.70 Mo Distance Peak
2024-11-22 22:50:13 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Nov 22	00	931	93.34s	0.003s	93.46s
	01	150	15.119s	0.001s	15.134s
	02	36,387	1,981.735s	0.007s	1,981.892s
	03	7,552	756.606s	0.004s	756.765s
	04	3,086	309.247s	0.003s	309.29s
	05	655	65.694s	0.002s	65.723s
	06	1,692	169.634s	0.003s	169.713s
	07	511	51.268s	0.003s	51.299s
	08	601	60.379s	0.003s	60.409s
	09	2,010	201.315s	0.004s	201.395s
	10	4,573	457.955s	0.137s	458.264s
	11	715	71.628s	0.018s	71.684s
	12	640	64.294s	0.003s	64.327s
	13	22,034	1,792.153s	0.003s	1,792.446s
	14	301,134	871.26s	0.387s	886.007s
	15	1,533	153.593s	0.012s	164.941s
	16	49,582	1,765.045s	0.01s	1,776.123s
	17	666	66.903s	0.002s	66.933s
	18	2,467	247.052s	0.002s	247.304s
	19	2,515,383	2,193.93s	1.015s	2,222.047s
	20	1,094,052	3,238.759s	0.033s	3,246.586s
	21	33,728	1,724.282s	0.003s	1,724.344s
	22	932,850	798.929s	4.932s	834.913s
	23	698,291	2,262.778s	0.016s	2,278.552s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Nov 22	00	0	1	76	0.001s	0.002s
	01	0	0	19	0.001s	0.001s
	02	0	5	93	0.002s	0.003s
	03	0	5	60	0.001s	0.002s
	04	0	1	47	0.001s	0.002s
	05	0	0	80	0.001s	0.002s
	06	0	1	133	0.001s	0.002s
	07	0	0	116	0.001s	0.002s
	08	0	0	75	0.001s	0.002s
	09	0	1	137	0.001s	0.002s
	10	0	2	658	0.001s	0.002s
	11	0	0	150	0.001s	0.002s
	12	0	0	31	0.002s	0.002s
	13	0	19	78	0.001s	0.002s
	14	183	1,073	390	0.296s	0.006s
	15	0	878	190	0.003s	0.002s
	16	2	890	269	0.001s	0.003s
	17	0	0	27	0.001s	0.002s
	18	2	0	45	0.001s	0.002s
	19	31	2,153	264	0.168s	0.018s
	20	0	644	330	0.001s	0.002s
	21	0	0	79	0.001s	0.003s
	22	35	2,171	180	3.680s	0.13s
	23	0	1,080	145	0.001s	0.003s

Day	Hour	Avg time (sec)
Nov 22	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
Nov 22	00	12,063.00 kB	48,623.00 kB
	01	943.00 kB	41,597.00 kB
	02	27,118.00 kB	54,132.67 kB
	03	35,700.50 kB	56,520.50 kB
	04	10,147.00 kB	48,218.50 kB
	05	1,992.50 kB	39,364.00 kB
	06	2,101.50 kB	32,336.50 kB
	07	1,542.50 kB	26,505.00 kB
	08	1,453.00 kB	21,756.50 kB
	09	6,768.00 kB	18,448.00 kB
	10	15,515.00 kB	22,968.50 kB
	11	2,192.50 kB	25,506.50 kB
	12	1,565.00 kB	21,041.50 kB
	13	152,643.50 kB	277,849.50 kB
	14	6,688,063.33 kB	6,690,889.33 kB
	15	7,187,152.50 kB	8,652,313.50 kB
	16	5,049,418.67 kB	8,374,576.00 kB
	17	1,833.50 kB	6,601,150.00 kB
	18	9,181.00 kB	5,348,701.00 kB
	19	8,816,352.50 kB	8,817,071.00 kB
	20	5,534,178.00 kB	8,492,640.00 kB
	21	3,127.67 kB	6,638,426.00 kB
	22	5,935,435.50 kB	7,710,145.00 kB
	23	6,071,717.00 kB	8,736,668.33 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (43) Main checkpoint cause
58 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	43
wal	15
Total	58

Size of temporary files

Key values

21.02 GiB Temp Files size Peak
2024-11-22 22:33:42 Date

Number of temporary files

Key values

22 per second Temp Files Peak
2024-11-22 22:33:42 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Nov 22	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	806	26.41 GiB	33.56 MiB
	15	317	24.56 GiB	79.35 MiB
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	74	73.48 GiB	1016.77 MiB
	22	184	145.69 GiB	810.77 MiB
	23	155	37.27 GiB	246.25 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	1,018	53.45 GiB	8.00 KiB	1.00 GiB	53.77 MiB	select * from pgbulkload.pg_bulkload (?); SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 22:44:54 Duration: 6m40s Database: ctdprd51 User: load Application: pg_bulkload SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 23:12:14 Duration: 5m8s 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/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}'); Date: 2024-11-22 14:28:57 Duration: 4m5s
2	73	72.02 GiB	22.38 MiB	1.00 GiB	1010.28 MiB	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.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 pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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: 2024-11-22 22:33:39 Duration: 0ms
3	49	48.91 GiB	936.76 MiB	1.00 GiB	1022.22 MiB	select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.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 pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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: 2024-11-22 21:50:55 Duration: 0ms
4	35	1.13 GiB	24.76 MiB	50.37 MiB	32.98 MiB	vacuum full analyze ixn_actor; vacuum FULL analyze ixn_actor; Date: 2024-11-22 15:39:56 Duration: 23s530ms vacuum FULL analyze ixn_actor; Date: 2024-11-22 15:39:39 Duration: 0ms
5	35	3.73 GiB	62.34 MiB	147.37 MiB	109.00 MiB	vacuum full analyze db_link; vacuum FULL analyze db_link; Date: 2024-11-22 15:42:00 Duration: 1m35s vacuum FULL analyze db_link; Date: 2024-11-22 15:40:42 Duration: 0ms
6	25	24.56 GiB	576.03 MiB	1.00 GiB	1006.08 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 pub1.gene_chem_reference gcr, pub1.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 pub1.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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; Date: 2024-11-22 21:08:38 Duration: 0ms
7	25	370.55 MiB	10.51 MiB	18.88 MiB	14.82 MiB	vacuum full analyze ixn; vacuum FULL analyze ixn; Date: 2024-11-22 15:40:14 Duration: 7s368ms vacuum FULL analyze ixn; Date: 2024-11-22 15:40:09 Duration: 0ms
8	20	12.52 GiB	8.00 KiB	1.00 GiB	641.12 MiB	create unique index gene_disease_reference_ak1 on pub1.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 pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); Date: 2024-11-22 22:50:21 Duration: 3m4s CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); Date: 2024-11-22 22:50:20 Duration: 0ms
9	20	215.91 MiB	4.65 MiB	17.59 MiB	10.80 MiB	vacuum full analyze term; vacuum FULL analyze TERM; Date: 2024-11-22 15:39:56 Duration: 10s567ms vacuum FULL analyze TERM; Date: 2024-11-22 15:39:48 Duration: 0ms
10	15	6.96 GiB	8.00 KiB	1.00 GiB	474.90 MiB	alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id); ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); Date: 2024-11-22 22:47:17 Duration: 1m7s ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); Date: 2024-11-22 22:47:16 Duration: 0ms Database: ctdprd51 User: pub1
11	10	447.18 MiB	8.00 KiB	92.54 MiB	44.72 MiB	create unique index chem_disease_reference_ak1 on pub1.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 pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id); Date: 2024-11-22 23:05:20 Duration: 5s831ms CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id); Date: 2024-11-22 23:05:20 Duration: 0ms
12	10	6.96 GiB	271.70 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_source_cd on pub1.gene_disease_reference using btree (source_cd); CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd); Date: 2024-11-22 22:52:04 Duration: 58s387ms CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd); Date: 2024-11-22 22:52:04 Duration: 0ms
13	10	6.96 GiB	349.58 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_chem on pub1.gene_disease_reference using btree (via_chem_id); CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id); Date: 2024-11-22 22:53:33 Duration: 1m29s CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id); Date: 2024-11-22 22:53:33 Duration: 0ms
14	10	245.48 MiB	8.00 KiB	49.59 MiB	24.55 MiB	alter table pub1.chem_disease_reference add constraint chem_disease_reference_pk primary key (id); ALTER TABLE pub1.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id); Date: 2024-11-22 23:05:14 Duration: 2s204ms ALTER TABLE pub1.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id); Date: 2024-11-22 23:05:14 Duration: 0ms
15	10	6.96 GiB	362.83 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_reference_ixn on pub1.gene_disease_reference using btree (ixn_id); CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id); Date: 2024-11-22 22:59:28 Duration: 1m21s CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id); Date: 2024-11-22 22:59:27 Duration: 0ms
16	10	6.96 GiB	370.00 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_src_db on pub1.gene_disease_reference using btree (source_acc_db_id); CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id); Date: 2024-11-22 22:51:06 Duration: 45s149ms CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id); Date: 2024-11-22 22:51:06 Duration: 0ms
17	10	6.96 GiB	321.89 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score); CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score); Date: 2024-11-22 23:03:10 Duration: 2m21s CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score); Date: 2024-11-22 23:03:09 Duration: 0ms
18	10	6.96 GiB	362.32 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id); CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id); Date: 2024-11-22 22:58:06 Duration: 1m46s CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id); Date: 2024-11-22 22:58:06 Duration: 0ms
19	10	6.96 GiB	375.15 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_reference on pub1.gene_disease_reference using btree (reference_id); CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id); Date: 2024-11-22 22:56:20 Duration: 1m20s CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id); Date: 2024-11-22 22:56:20 Duration: 0ms
20	10	1.04 GiB	8.00 KiB	215.52 MiB	106.22 MiB	alter table pub1.phenotype_term_reference add constraint phenotype_term_reference_pk primary key (id); ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id); Date: 2024-11-22 23:03:22 Duration: 12s37ms ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id); Date: 2024-11-22 23:03:22 Duration: 0ms
21	10	6.96 GiB	361.95 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_mod_tm on pub1.gene_disease_reference using btree (mod_tm); CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm); Date: 2024-11-22 23:00:48 Duration: 1m20s CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm); Date: 2024-11-22 23:00:48 Duration: 0ms
22	10	6.96 GiB	325.20 MiB	1.00 GiB	712.35 MiB	create index ix_gene_disease_ref_disease on pub1.gene_disease_reference using btree (disease_id); CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id); Date: 2024-11-22 22:55:00 Duration: 1m26s CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id); Date: 2024-11-22 22:54:59 Duration: 0ms
23	6	5.49 GiB	500.52 MiB	1.00 GiB	936.75 MiB	select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub1.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.object_type where cd = ?), cdr.mod_tm from pub1.chem_disease_reference cdr, pub1.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id; SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id; Date: 2024-11-22 22:37:23 Duration: 0ms
24	5	1.04 GiB	200.02 MiB	223.02 MiB	212.44 MiB	create index ix_phenotype_term_ref_reference_id on pub1.phenotype_term_reference using btree (reference_id); CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id); Date: 2024-11-22 23:04:00 Duration: 11s42ms CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id); Date: 2024-11-22 23:04:00 Duration: 0ms
25	5	1.04 GiB	202.36 MiB	223.16 MiB	212.43 MiB	create index ix_phenotype_term_ref_via_term_id on pub1.phenotype_term_reference using btree (via_term_id); CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id); Date: 2024-11-22 23:04:58 Duration: 12s453ms CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id); Date: 2024-11-22 23:04:58 Duration: 0ms
26	5	245.44 MiB	48.80 MiB	49.30 MiB	49.09 MiB	create index ix_chem_disease_reference_ixn on pub1.chem_disease_reference using btree (ixn_id); CREATE INDEX ix_chem_disease_reference_ixn ON pub1.chem_disease_reference USING btree (ixn_id); Date: 2024-11-22 23:05:35 Duration: 2s692ms CREATE INDEX ix_chem_disease_reference_ixn ON pub1.chem_disease_reference USING btree (ixn_id); Date: 2024-11-22 23:05:35 Duration: 0ms
27	5	1.04 GiB	198.84 MiB	218.33 MiB	212.44 MiB	create index ix_phenotype_term_reference_ixn_id on pub1.phenotype_term_reference using btree (ixn_id); CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id); Date: 2024-11-22 23:04:46 Duration: 10s762ms CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id); Date: 2024-11-22 23:04:46 Duration: 0ms
28	5	1.04 GiB	191.72 MiB	223.62 MiB	212.44 MiB	create index ix_phenotype_term_ref_taxon_id on pub1.phenotype_term_reference using btree (taxon_id); CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id); Date: 2024-11-22 23:04:09 Duration: 8s895ms CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id); Date: 2024-11-22 23:04:09 Duration: 0ms
29	5	245.44 MiB	44.23 MiB	50.48 MiB	49.09 MiB	create index ix_chem_disease_reference_gene on pub1.chem_disease_reference using btree (via_gene_id); CREATE INDEX ix_chem_disease_reference_gene ON pub1.chem_disease_reference USING btree (via_gene_id); Date: 2024-11-22 23:05:32 Duration: 2s749ms CREATE INDEX ix_chem_disease_reference_gene ON pub1.chem_disease_reference USING btree (via_gene_id); Date: 2024-11-22 23:05:32 Duration: 0ms
30	5	245.44 MiB	48.37 MiB	49.66 MiB	49.09 MiB	create index ix_chem_disease_reference_ref on pub1.chem_disease_reference using btree (reference_id); CREATE INDEX ix_chem_disease_reference_ref ON pub1.chem_disease_reference USING btree (reference_id); Date: 2024-11-22 23:05:26 Duration: 2s688ms CREATE INDEX ix_chem_disease_reference_ref ON pub1.chem_disease_reference USING btree (reference_id); Date: 2024-11-22 23:05:26 Duration: 0ms
31	5	1.04 GiB	205.38 MiB	217.40 MiB	212.44 MiB	create index ix_phenotype_term_reference_term_reference_id on pub1.phenotype_term_reference using btree (term_reference_id); CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id); Date: 2024-11-22 23:04:35 Duration: 11s24ms CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id); Date: 2024-11-22 23:04:35 Duration: 0ms
32	5	245.44 MiB	48.75 MiB	49.68 MiB	49.09 MiB	create index ix_chem_disease_ref_net_sc on pub1.chem_disease_reference using btree (network_score); CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score); Date: 2024-11-22 23:05:42 Duration: 4s938ms CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score); Date: 2024-11-22 23:05:42 Duration: 0ms
33	5	245.44 MiB	46.62 MiB	51.02 MiB	49.09 MiB	create index ix_chem_disease_ref_source_cd on pub1.chem_disease_reference using btree (source_cd); CREATE INDEX ix_chem_disease_ref_source_cd ON pub1.chem_disease_reference USING btree (source_cd); Date: 2024-11-22 23:05:28 Duration: 1s869ms CREATE INDEX ix_chem_disease_ref_source_cd ON pub1.chem_disease_reference USING btree (source_cd); Date: 2024-11-22 23:05:28 Duration: 0ms
34	5	245.44 MiB	46.45 MiB	52.15 MiB	49.09 MiB	create index ix_chem_disease_reference_dis on pub1.chem_disease_reference using btree (disease_id); CREATE INDEX ix_chem_disease_reference_dis ON pub1.chem_disease_reference USING btree (disease_id); Date: 2024-11-22 23:05:23 Duration: 2s687ms CREATE INDEX ix_chem_disease_reference_dis ON pub1.chem_disease_reference USING btree (disease_id); Date: 2024-11-22 23:05:23 Duration: 0ms
35	5	245.44 MiB	48.60 MiB	49.33 MiB	49.09 MiB	create index ix_chem_disease_ref_mod_tm on pub1.chem_disease_reference using btree (mod_tm); CREATE INDEX ix_chem_disease_ref_mod_tm ON pub1.chem_disease_reference USING btree (mod_tm); Date: 2024-11-22 23:05:38 Duration: 2s651ms CREATE INDEX ix_chem_disease_ref_mod_tm ON pub1.chem_disease_reference USING btree (mod_tm); Date: 2024-11-22 23:05:38 Duration: 0ms
36	5	1.04 GiB	208.83 MiB	217.22 MiB	212.44 MiB	create index ix_phenotype_term_ref_term_id on pub1.phenotype_term_reference using btree (term_id); CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id); Date: 2024-11-22 23:03:41 Duration: 9s639ms CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id); Date: 2024-11-22 23:03:41 Duration: 0ms
37	5	1.04 GiB	201.16 MiB	216.73 MiB	212.44 MiB	create index ix_phenotype_term_ref_object_type_id on pub1.phenotype_term_reference using btree (term_object_type_id); CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id); Date: 2024-11-22 23:03:49 Duration: 8s443ms CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id); Date: 2024-11-22 23:03:49 Duration: 0ms
38	5	1.04 GiB	207.02 MiB	220.32 MiB	212.44 MiB	create index ixn_phenotype_term_ref_phenotype_id on pub1.phenotype_term_reference using btree (phenotype_id); CREATE INDEX ixn_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id); Date: 2024-11-22 23:03:31 Duration: 9s184ms CREATE INDEX ixn_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id); Date: 2024-11-22 23:03:31 Duration: 0ms
39	5	1.04 GiB	203.95 MiB	218.63 MiB	212.44 MiB	create index ix_phenotype_term_ref_evidence_cd on pub1.phenotype_term_reference using btree (evidence_cd); CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd); Date: 2024-11-22 23:04:16 Duration: 7s179ms CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd); Date: 2024-11-22 23:04:16 Duration: 0ms
40	5	1.04 GiB	197.35 MiB	218.81 MiB	212.44 MiB	create index ix_phenotype_term_reference_source_acc_db_id on pub1.phenotype_term_reference using btree (source_acc_db_id); CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id); Date: 2024-11-22 23:04:24 Duration: 7s699ms CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id); Date: 2024-11-22 23:04:24 Duration: 0ms
41	5	245.44 MiB	47.79 MiB	49.62 MiB	49.09 MiB	create index ix_chem_disease_ref_src_db on pub1.chem_disease_reference using btree (source_acc_db_id); CREATE INDEX ix_chem_disease_ref_src_db ON pub1.chem_disease_reference USING btree (source_acc_db_id); Date: 2024-11-22 23:05:29 Duration: 1s833ms CREATE INDEX ix_chem_disease_ref_src_db ON pub1.chem_disease_reference USING btree (source_acc_db_id); Date: 2024-11-22 23:05:29 Duration: 0ms
42	5	1.46 GiB	290.28 MiB	315.74 MiB	298.12 MiB	create index ix_phenotype_term_ref_ids on pub1.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 pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id); Date: 2024-11-22 23:05:12 Duration: 13s965ms CREATE INDEX ix_phenotype_term_ref_ids ON pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id); Date: 2024-11-22 23:05:12 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	1.00 GiB	SELECT * FROM pgbulkload.pg_bulkload ($1); [ Date: 2024-11-22 15:06:03 - Database: ctdprd51 - User: load - Application: pg_bulkload ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:38 ]
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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn; [ Date: 2024-11-22 21:08:39 ]

Vacuums / Analyzes Distribution

Key values

57.96 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51
2024-11-22 19:41:00 Date
0 sec Highest CPU-cost analyze
Table
Database ctdprd51
Date

Average Autovacuum Duration

Key values

57.96 sec Highest CPU-cost vacuum
Table pub1.gene_go_annot
Database ctdprd51
2024-11-22 19:41:00 Date

Analyzes per table

Key values

pubc.log_query (30) Main table analyzed (database ctdprd51)
90 analyzes Total

Chart
Table

Table	Number of analyzes
ctdprd51.pubc.log_query	30
ctdprd51.pg_catalog.pg_class	4
ctdprd51.pg_catalog.pg_depend	2
ctdprd51.pg_catalog.pg_constraint	2
ctdprd51.pg_catalog.pg_index	2
ctdprd51.pg_catalog.pg_type	2
ctdprd51.pg_catalog.pg_attribute	2
ctdprd51.pub1.db	2
ctdprd51.pg_catalog.pg_trigger	2
ctdprd51.pg_catalog.pg_shdepend	2
ctdprd51.pub1.term	2
ctdprd51.pg_catalog.pg_description	1
ctdprd51.edit.reference_db_link	1
ctdprd51.pub1.gene_go_annot	1
ctdprd51.pub1.db_report_site	1
ctdprd51.pub1.db_link	1
ctdprd51.edit.exp_stressor_src_type	1
ctdprd51.pg_catalog.pg_attrdef	1
postgres.pg_catalog.pg_shdepend	1
ctdprd51.pub2.term_set_enrichment_agent	1
ctdprd51.pub1.term_label	1
ctdprd51.edit.action_type	1
ctdprd51.edit.object_note	1
ctdprd51.pub1.action_type	1
ctdprd51.edit.action_type_path	1
ctdprd51.pub1.img	1
ctdprd51.pub2.term_comp_agent	1
ctdprd51.pub1.dag_node	1
ctdprd51.edit.country	1
ctdprd51.pub1.gene_taxon	1
ctdprd51.edit.db_report_site	1
ctdprd51.edit.db_report	1
ctdprd51.pub1.reference	1
ctdprd51.pub1.reference_party_role	1
ctdprd51.edit.geographic_region	1
ctdprd51.pg_catalog.pg_proc	1
ctdprd51.edit.term_label_type	1
ctdprd51.pub2.term_comp	1
ctdprd51.pub1.list_db_report	1
ctdprd51.edit.db	1
ctdprd51.edit.db_link	1
ctdprd51.edit.action_degree_type	1
ctdprd51.pub1.db_report	1
ctdprd51.edit.action_degree	1
ctdprd51.pub1.reference_party	1
ctdprd51.pub1.dag_edge	1
ctdprd51.edit.list_db_report	1
ctdprd51.pub1.term_pathway	1
ctdprd51.edit.slim_term	1
Total	90

Vacuums per table

Key values

pubc.log_query (9) Main table vacuumed on database ctdprd51
46 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	9	6	7,012	0	1,272	0	209	1,611	119	930,830
ctdprd51.pg_catalog.pg_class	3	3	928	0	100	0	0	440	91	438,096
ctdprd51.pg_catalog.pg_statistic	3	3	2,027	0	242	0	35	1,092	224	997,398
ctdprd51.pg_toast.pg_toast_2619	2	2	7,620	0	2,044	0	20,513	5,720	1,850	840,829
ctdprd51.pub1.term	2	0	159,053	0	1,455	0	0	45,952	3	2,730,626
ctdprd51.pub2.term_comp_agent	1	0	133	0	44	0	0	41	1	10,838
ctdprd51.pub1.dag_node	1	0	82,803	0	10,058	0	0	41,260	3	2,455,980
ctdprd51.pg_toast.pg_toast_6752601	1	0	87,749	0	4	0	0	43,867	2	2,604,676
ctdprd51.pg_catalog.pg_constraint	1	1	227	0	45	0	0	111	40	154,138
ctdprd51.pg_catalog.pg_index	1	1	178	0	40	0	0	110	32	125,407
ctdprd51.pub1.img	1	0	1,108	0	5	0	0	524	2	44,119
ctdprd51.pg_catalog.pg_depend	1	1	676	0	86	0	65	306	91	337,071
ctdprd51.edit.object_note	1	1	168	0	2	0	0	12	2	11,041
postgres.pg_catalog.pg_shdepend	1	1	213	0	19	0	0	96	17	67,438
ctdprd51.pg_catalog.pg_attrdef	1	1	87	0	10	0	0	22	7	39,246
ctdprd51.pub1.term_label	1	0	183,279	0	5	0	0	91,572	3	5,427,561
ctdprd51.pub1.db_link	1	0	247,351	0	123,562	0	0	123,555	5	7,328,991
ctdprd51.edit.receptor	1	0	44	0	5	0	0	3	2	14,919
ctdprd51.edit.reference_db_link	1	0	7,256	0	4	0	0	3,624	1	222,142
ctdprd51.pub1.gene_go_annot	1	0	561,631	0	241,870	0	0	280,703	10	16,639,688
ctdprd51.pub1.term_pathway	1	0	3,331	0	3	0	0	1,614	1	103,645
ctdprd51.pub1.reference_party	1	0	5,130	0	4	0	0	2,514	2	159,365
ctdprd51.pub1.dag_edge	1	0	1,024	0	5	0	0	482	2	39,765
ctdprd51.edit.db_link	1	0	7,486	0	3	0	0	3,624	1	222,211
ctdprd51.pg_catalog.pg_trigger	1	1	311	0	38	0	0	123	37	169,759
ctdprd51.pub2.term_comp	1	0	156	0	34	0	0	30	2	14,733
ctdprd51.pub1.reference_party_role	1	0	13,408	0	5	0	0	6,665	2	405,918
ctdprd51.edit.db_report	1	0	96	0	2	0	0	9	2	16,762
ctdprd51.pub1.reference	1	0	77,247	0	5	0	0	38,513	3	2,293,667
ctdprd51.pub1.db	1	1	115	0	3	0	0	17	1	11,366
ctdprd51.pg_catalog.pg_attribute	1	1	631	0	120	0	37	302	102	366,453
ctdprd51.pub1.gene_taxon	1	0	148,349	0	6	0	0	74,116	4	4,401,873
Total	46	23	1,606,827	936	381,100	0	20,859	768,630	2,664	49,626,551

Tuples removed per table

Key values

pg_toast.pg_toast_2619 (7132) Main table with removed tuples on database ctdprd51
14446 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
ctdprd51.pg_toast.pg_toast_2619	2	2	7,132	34,702	83	0	25,184
ctdprd51.pg_catalog.pg_depend	1	1	1,823	12,963	0	0	145
ctdprd51.pg_catalog.pg_statistic	3	3	1,548	6,014	43	0	870
ctdprd51.pg_catalog.pg_attribute	1	1	1,364	7,635	0	0	236
ctdprd51.pg_catalog.pg_trigger	1	1	602	1,123	0	5	45
postgres.pg_catalog.pg_shdepend	1	1	548	2,071	0	0	21
ctdprd51.pg_catalog.pg_class	3	3	505	5,078	0	0	183
ctdprd51.pg_catalog.pg_index	1	1	247	959	0	2	39
ctdprd51.pg_catalog.pg_constraint	1	1	215	658	0	0	36
ctdprd51.pub1.db	1	1	130	130	0	0	6
ctdprd51.edit.db_report	1	0	106	158	0	0	4
ctdprd51.pg_catalog.pg_attrdef	1	1	73	204	0	0	11
ctdprd51.edit.receptor	1	0	64	16	0	0	1
ctdprd51.edit.object_note	1	1	61	33	0	0	3
ctdprd51.pubc.log_query	9	6	28	105,046	7	0	3,975
ctdprd51.pub2.term_comp_agent	1	0	0	17,397	0	0	152
ctdprd51.pub1.dag_node	1	0	0	1,713,965	0	0	41,259
ctdprd51.pg_toast.pg_toast_6752601	1	0	0	237,201	0	0	43,866
ctdprd51.pub1.img	1	0	0	50,713	0	0	523
ctdprd51.pub1.term_label	1	0	0	6,230,689	0	0	91,571
ctdprd51.pub1.db_link	1	0	0	17,108,189	0	0	123,554
ctdprd51.edit.reference_db_link	1	0	0	325,269	0	0	3,623
ctdprd51.pub1.gene_go_annot	1	0	0	44,072,144	0	0	280,702
ctdprd51.pub1.term_pathway	1	0	0	135,792	0	0	1,613
ctdprd51.pub1.term	2	0	0	2,133,278	0	0	83,966
ctdprd51.pub1.reference_party	1	0	0	449,932	0	0	2,513
ctdprd51.pub1.dag_edge	1	0	0	88,931	0	0	481
ctdprd51.edit.db_link	1	0	0	325,269	0	0	3,623
ctdprd51.pub2.term_comp	1	0	0	3,055	0	0	29
ctdprd51.pub1.reference_party_role	1	0	0	1,232,731	0	0	6,664
ctdprd51.pub1.reference	1	0	0	198,007	0	0	38,512
ctdprd51.pub1.gene_taxon	1	0	0	11,636,084	0	0	74,115
Total	46	23	14,446	86,135,436	133	7	827,525

Pages removed per table

Key values

pg_catalog.pg_trigger (5) Main table with removed pages on database ctdprd51
7 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
ctdprd51.pg_catalog.pg_trigger	1	1	602	5
ctdprd51.pg_catalog.pg_index	1	1	247	2
ctdprd51.pub2.term_comp_agent	1	0	0	0
ctdprd51.pg_catalog.pg_class	3	3	505	0
ctdprd51.pub1.dag_node	1	0	0	0
ctdprd51.pg_catalog.pg_statistic	3	3	1548	0
ctdprd51.pg_toast.pg_toast_6752601	1	0	0	0
ctdprd51.pg_catalog.pg_constraint	1	1	215	0
ctdprd51.pub1.img	1	0	0	0
ctdprd51.pg_toast.pg_toast_2619	2	2	7132	0
ctdprd51.pg_catalog.pg_depend	1	1	1823	0
ctdprd51.edit.object_note	1	1	61	0
postgres.pg_catalog.pg_shdepend	1	1	548	0
ctdprd51.pg_catalog.pg_attrdef	1	1	73	0
ctdprd51.pub1.term_label	1	0	0	0
ctdprd51.pub1.db_link	1	0	0	0
ctdprd51.edit.receptor	1	0	64	0
ctdprd51.edit.reference_db_link	1	0	0	0
ctdprd51.pub1.gene_go_annot	1	0	0	0
ctdprd51.pub1.term_pathway	1	0	0	0
ctdprd51.pub1.term	2	0	0	0
ctdprd51.pub1.reference_party	1	0	0	0
ctdprd51.pubc.log_query	9	6	28	0
ctdprd51.pub1.dag_edge	1	0	0	0
ctdprd51.edit.db_link	1	0	0	0
ctdprd51.pub2.term_comp	1	0	0	0
ctdprd51.pub1.reference_party_role	1	0	0	0
ctdprd51.edit.db_report	1	0	106	0
ctdprd51.pub1.reference	1	0	0	0
ctdprd51.pub1.db	1	1	130	0
ctdprd51.pg_catalog.pg_attribute	1	1	1364	0
ctdprd51.pub1.gene_taxon	1	0	0	0
Total	46	23	14,446	7

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
1 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		1	24s179ms	24s179ms
	relation	1	24s179ms	24s179ms
	Total	1	24s179ms	24s179ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	24s179ms	24s179ms	24s179ms	24s179ms	select * from pgbulkload.pg_bulkload (?); SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 22:44:54 Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 23:12:14 Bind query: yes 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/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}'); Date: 2024-11-22 14:28:57 Bind query: yes

Queries that waited the most

Rank	Wait time	Query
1	24s179ms	SELECT * FROM pgbulkload.pg_bulkload ($1); [ Date: 2024-11-22 14:00:59 ]

Queries by type

Key values

1,405 Total read queries
95 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,405	93.36%
INSERT	14	0.93%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	39	2.59%
CTE	7	0.47%
DDL	35	2.33%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	5	0.33%

Queries by database

Key values

unknown Main database
1,047 Requests
4h46m49s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctdprd51	Total	458	1h25m44s
	copy to	8	3m24s
	cte	3	10s28ms
	ddl	1	5s996ms
	insert	2	12m16s
	select	444	1h9m46s
unknown	Total	1,047	4h46m49s
	copy to	31	3m48s
	cte	4	8s776ms
	ddl	34	19m35s
	insert	12	36m53s
	others	5	2m22s
	select	961	3h44m1s

Queries by user

Key values

unknown Main user
2,009 Requests

Queries Chart
Table

User	Request type	Count	Duration
edit	Total	1	10s168ms
	insert	1	10s168ms
editeu	Total	3	9s611ms
	select	3	9s611ms
load	Total	24	20m
	select	24	20m
postgres	Total	16	6m57s
	copy to	16	6m57s
pub1	Total	2	12m12s
	ddl	1	5s996ms
	insert	1	12m6s
pubeu	Total	789	1h43m17s
	cte	4	13s258ms
	select	785	1h43m3s
qaeu	Total	10	28s583ms
	cte	2	6s826ms
	select	8	21s757ms
unknown	Total	2,009	6h2m33s
	copy to	59	7m10s
	cte	20	43s553ms
	ddl	34	19m35s
	insert	12	36m53s
	others	5	2m22s
	select	1,879	4h55m47s
zbx_monitor	Total	1	2s489ms
	select	1	2s489ms

Duration by user

Key values

6h2m33s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
edit	Total	1	10s168ms
	insert	1	10s168ms
editeu	Total	3	9s611ms
	select	3	9s611ms
load	Total	24	20m
	select	24	20m
postgres	Total	16	6m57s
	copy to	16	6m57s
pub1	Total	2	12m12s
	ddl	1	5s996ms
	insert	1	12m6s
pubeu	Total	789	1h43m17s
	cte	4	13s258ms
	select	785	1h43m3s
qaeu	Total	10	28s583ms
	cte	2	6s826ms
	select	8	21s757ms
unknown	Total	2,009	6h2m33s
	copy to	59	7m10s
	cte	20	43s553ms
	ddl	34	19m35s
	insert	12	36m53s
	others	5	2m22s
	select	1,879	4h55m47s
zbx_monitor	Total	1	2s489ms
	select	1	2s489ms

Queries by host

Key values

unknown Main host
2,855 Requests
8h25m52s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	2,855	8h25m52s
	copy to	75	14m8s
	cte	26	1m3s
	ddl	35	19m41s
	insert	14	49m9s
	others	5	2m22s
	select	2,700	6h59m26s

Queries by application

Key values

unknown Main application
1,478 Requests
5h58m36s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pgAdmin 4 - CONN:5771213	Total	1	4s216ms
	select	1	4s216ms
pgAdmin 4 - CONN:8515588	Total	1	10s168ms
	insert	1	10s168ms
pg_bulkload	Total	16	10m12s
	select	16	10m12s
pg_dump	Total	8	3m24s
	copy to	8	3m24s
psql	Total	1	5s996ms
	ddl	1	5s996ms
unknown	Total	1,478	5h58m36s
	copy to	31	3m48s
	cte	7	18s804ms
	ddl	34	19m35s
	insert	13	48m59s
	others	5	2m22s
	select	1,388	4h43m31s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-11-22 14:02:26 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

1,412 1000-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	1,412	91.75%
> 10000ms	127	8.25%

Slowest individual queries


[ Date: 2024-11-22 22:33:37 - Bind query: yes ]
[ Date: 2024-11-22 21:50:53 - Bind query: yes ]
[ Date: 2024-11-22 20:21:04 - Bind query: yes ]
[ Date: 2024-11-22 19:39:11 - Bind query: yes ]
[ Date: 2024-11-22 00:19:12 ]
[ Date: 2024-11-22 09:32:50 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2024-11-22 19:10:04 - Database: ctdprd51 - User: pub1 - Bind query: yes ]
[ Date: 2024-11-22 09:28:22 - Bind query: yes ]
[ Date: 2024-11-22 20:33:30 - Database: ctdprd51 - User: load - Bind query: yes ]
[ Date: 2024-11-22 22:44:54 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
[ Date: 2024-11-22 23:12:14 - Bind query: yes ]
[ Date: 2024-11-22 08:52:06 - Bind query: yes ]
[ Date: 2024-11-22 14:28:57 - Bind query: yes ]
[ Date: 2024-11-22 19:43:14 - Bind query: yes ]
[ Date: 2024-11-22 03:36:17 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2024-11-22 19:15:15 - Bind query: yes ]
[ Date: 2024-11-22 02:17:26 - Bind query: yes ]
[ Date: 2024-11-22 22:50:21 - Bind query: yes ]
[ Date: 2024-11-22 03:14:13 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
[ Date: 2024-11-22 02:40:44 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Rank	Duration	Query
1	42m38s	select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2024-11-22 22:33:37 - Bind query: yes ]
2	38m48s	select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.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 pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect'); [ Date: 2024-11-22 21:50:53 - Bind query: yes ]
3	33m32s	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: 2024-11-22 20:21:04 - Bind query: yes ]
4	23m55s	insert into pub1.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: 2024-11-22 19:39:11 - Bind query: yes ]
5	19m10s	/* * 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:* 2024-11-22 00:19:12 ]
6	17m29s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1241583') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-11-22 09:32:50 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
7	12m6s	insert into pub1.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: 2024-11-22 19:10:04 - Database: ctdprd51 - User: pub1 - Bind query: yes ]
8	11m20s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1240539') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-11-22 09:28:22 - Bind query: yes ]
9	9m21s	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 pub1.GENE_CHEM_REFERENCE gcr, pub1.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 pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect'); [ Date: 2024-11-22 20:33:30 - Database: ctdprd51 - User: load - Bind query: yes ]
10	6m40s	SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 22:44:54 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
11	5m8s	SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.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: 2024-11-22 23:12:14 - Bind query: yes ]
12	4m49s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1236728') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-11-22 08:52:06 - Bind query: yes ]
13	4m5s	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/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}'); [ Date: 2024-11-22 14:28:57 - Bind query: yes ]
14	4m2s	insert into pub1.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: 2024-11-22 19:43:14 - Bind query: yes ]
15	3m10s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1213960') and diseaseTerm.object_type_id = 3 ORDER BY phenotypeTerm.nm_sort, diseaseTerm.nm_sort LIMIT 50; [ Date: 2024-11-22 03:36:17 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
16	3m8s	INSERT INTO pub1.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 pub1.TERM); [ Date: 2024-11-22 19:15:15 - Bind query: yes ]
17	3m8s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1236507') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-11-22 02:17:26 - Bind query: yes ]
18	3m4s	CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id); [ Date: 2024-11-22 22:50:21 - Bind query: yes ]
19	2m59s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1213960') and diseaseTerm.object_type_id = 3 ORDER BY phenotypeTerm.nm_sort, diseaseTerm.nm_sort LIMIT 50; [ Date: 2024-11-22 03:14:13 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
20	2m53s	SELECT /* GoDiseasesDAO / phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT() OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1213960') and diseaseTerm.object_type_id = 3 ORDER BY phenotypeTerm.nm_sort, diseaseTerm.nm_sort LIMIT 50; [ Date: 2024-11-22 02:40:44 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

Time consuming queries (N)


[ User: pubeu - Total duration: 20m48s - Times executed: 12 ]
Date: 2024-11-22 22:33:37
Duration: 42m38s
Bind query: yes
Date: 2024-11-22 21:50:53
Duration: 38m48s
Bind query: yes
[ User: load - Total duration: 10m12s - Times executed: 16 ]
Date: 2024-11-22 20:21:04
Duration: 33m32s
Bind query: yes
Date: 2024-11-22 19:39:11
Duration: 23m55s
Bind query: yes
Date: 2024-11-22 00:19:12
Duration: 19m10s
[ User: pubeu - Total duration: 14m46s - Times executed: 5 ]
[ User: load - Total duration: 9m21s - Times executed: 1 ]
[ User: pub1 - Total duration: 12m6s - Times executed: 1 ]
[ User: pubeu - Total duration: 3m11s - Times executed: 169 ]
Date: 2024-11-22 19:43:14
Duration: 4m2s
Bind query: yes
Date: 2024-11-22 19:15:15
Duration: 3m8s
Bind query: yes
Date: 2024-11-22 22:50:21
Duration: 3m4s
Bind query: yes
[ User: pubeu - Total duration: 39s390ms - Times executed: 6 ]
[ User: pubeu - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m33s - Times executed: 4 ]
[ User: pubeu - Total duration: 1m39s - Times executed: 25 ]
[ User: pubeu - Total duration: 43s151ms - Times executed: 35 ]
[ User: pubeu - Total duration: 19s174ms - Times executed: 1 ]

Most frequent queries (N)


[ User: pubeu - Total duration: 3m11s - Times executed: 169 ]
[ User: pubeu - Total duration: 43s151ms - Times executed: 35 ]
[ User: pubeu - Total duration: 30s705ms - Times executed: 24 ]
[ User: load - Total duration: 10m12s - Times executed: 16 ]
[ User: pubeu - Total duration: 1m39s - Times executed: 25 ]
[ User: pubeu - Total duration: 22s489ms - Times executed: 11 ]
[ User: pubeu - Total duration: 39s390ms - Times executed: 6 ]
[ User: pubeu - Total duration: 40s394ms - Times executed: 12 ]
[ User: pubeu - Total duration: 20m48s - Times executed: 12 ]
[ User: load - Total duration: 9m21s - Times executed: 1 ]
[ User: pubeu - Total duration: 35s576ms - Times executed: 7 ]
[ User: pubeu - Total duration: 31s518ms - Times executed: 8 ]
[ User: pubeu - Total duration: 9s874ms - Times executed: 3 ]
[ User: pubeu - Total duration: 9s720ms - Times executed: 7 ]
[ User: pubeu - Total duration: 28s803ms - Times executed: 4 ]
[ User: pubeu - Total duration: 19s174ms - Times executed: 1 ]
[ User: pubeu - Total duration: 2s755ms - Times executed: 2 ]
[ User: pubeu - Total duration: 5s25ms - Times executed: 2 ]
[ User: pubeu - Total duration: 2s348ms - Times executed: 2 ]
[ User: pubeu - Total duration: 1s124ms - Times executed: 1 ]

Normalized slowest queries (N)


Date: 2024-11-22 22:33:37
Duration: 42m38s
Bind query: yes
Date: 2024-11-22 21:50:53
Duration: 38m48s
Bind query: yes
Date: 2024-11-22 20:21:04
Duration: 33m32s
Bind query: yes
Date: 2024-11-22 19:39:11
Duration: 23m55s
Bind query: yes
Date: 2024-11-22 00:19:12
Duration: 19m10s
[ User: pub1 - Total duration: 12m6s - Times executed: 1 ]
Date: 2024-11-22 19:43:14
Duration: 4m2s
Bind query: yes
Date: 2024-11-22 19:15:15
Duration: 3m8s
Bind query: yes
Date: 2024-11-22 22:50:21
Duration: 3m4s
Bind query: yes
[ User: pubeu - Total duration: 14m46s - Times executed: 5 ]
[ User: pubeu - Total duration: 20m48s - Times executed: 12 ]
[ User: load - Total duration: 10m12s - Times executed: 16 ]
[ User: pubeu - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m33s - Times executed: 4 ]
[ User: load - Total duration: 9m21s - Times executed: 1 ]
[ User: pubeu - Total duration: 19s174ms - Times executed: 1 ]
[ User: pubeu - Total duration: 28s803ms - Times executed: 4 ]
[ User: pubeu - Total duration: 39s390ms - Times executed: 6 ]
[ User: pubeu - Total duration: 35s576ms - Times executed: 7 ]
[ User: pubeu - Total duration: 31s518ms - 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
Nov 21	05	4	0ms	0ms
	06	8	0ms	0ms
	07	2	0ms	0ms
	08	4	0ms	0ms
	09	8	0ms	0ms
	10	4	0ms	0ms
	12	2	0ms	0ms
	13	5	0ms	0ms
	14	1	0ms	0ms
	15	3	0ms	0ms
	16	1	0ms	0ms
	17	8	0ms	0ms
Nov 22	05	4	0ms	0ms
	06	4	0ms	0ms
	07	2	0ms	0ms
	08	3	0ms	0ms
	09	9	0ms	0ms
	14	1	0ms	0ms
	15	5	0ms	0ms

[ User: pubeu - Total duration: 1m5s - Times executed: 25 ]

[ User: qaeu - Total duration: 4s221ms - Times executed: 1 ]

;

Date: Duration: 0ms Database: postgres parameters: $1 = '1675850', $2 = '1675850'

Log levels

Key values

19,619 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	2,603	13.27%
DETAIL	1,379	7.03%
ERROR	17	0.09%
FATAL	6	0.03%
HINT	1	0.01%
LOG	14,223	72.50%
STATEMENT	1,390	7.08%

Events distribution

Key values

0 PANIC entries
6 FATAL entries
17 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Nov 22	09	3
	22	3

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Nov 22	09	3
	22	3

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Nov 22	16	2
	17	2
	21	1

Details

ERROR: canceling statement due to user request

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Nov 22	22	3

ERROR: canceling statement due to user request

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Nov 22	14	1

ERROR: process 479542 still waiting for AccessExclusiveLock on relation 2633821 of database 484829 after 1000.056 ms

Details

ERROR: syntax error at or near "..."

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Nov 22	14	1

ERROR: syntax error at or near "select" at character 203

Details

ERROR: function get_ixn_prose(...) does not exist

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Nov 22	14	1

ERROR: function get_ixn_prose(integer) does not exist at character 66

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

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

Key values