pgBadger :: PostgreSQL Log Analyzer

Global information
- Generated on Tue Jul 2 12:48:52 2024
- Log file:
- Parsed 184,673 log entries in 0ms
- Log start from 2024-05-27 00:00:01 to 2024-05-31 23:58:54

Global Stats

493 Number of unique normalized queries
9,776 Number of queries
2d44m43s Total query duration
2024-05-27 00:04:09 First query
2024-05-31 23:58:41 Last query
3 queries/s at 2024-05-30 04:49:16 Query peak

2d44m43s Total query duration
0ms Prepare/parse total duration
2s832ms Bind total duration
2d44m40s Execute total duration

1,368 Number of events
18 Number of unique normalized events
1,024 Max number of times the same event was reported
0 Number of cancellation

121 Total number of automatic vacuums
240 Total number of automatic analyzes

2,898 Number temporary file
39.66 GiB Max size of temporary file
190.07 MiB Average size of temporary file

15,276 Total number of sessions
104 sessions at 2024-05-30 02:51:24 Session peak
218d5h4m1s Total duration of sessions
20m34s Average duration of sessions
0 Average queries per session
11s487ms Average queries duration per session
20m22s Average idle time per session

15,276 Total number of connections
37 connections/s at 2024-05-31 09:24:06 Connection peak
2 Total number of databases

SQL Traffic

Key values

3 queries/s Query Peak
2024-05-30 04:49:16 Date

SELECT Traffic

Key values

3 queries/s Query Peak
2024-05-30 04:49:16 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2024-05-28 05:40:12 Date

Queries duration

Key values

2d44m43s 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)
May 27	00	62	0ms	16m	17s608ms	7s687ms	7s907ms	16m7s
	01	40	0ms	12s15ms	2s712ms	7s566ms	10s443ms	12s965ms
	02	62	0ms	4s936ms	1s666ms	5s47ms	6s245ms	8s331ms
	03	64	0ms	5s441ms	1s851ms	5s333ms	6s623ms	8s627ms
	04	58	0ms	25s136ms	2s465ms	5s584ms	8s651ms	25s136ms
	05	84	0ms	8s668ms	2s145ms	10s633ms	14s672ms	35s524ms
	06	60	0ms	32s668ms	3s569ms	8s22ms	24s806ms	52s320ms
	07	44	0ms	3m35s	6s800ms	5s171ms	6s437ms	3m38s
	08	50	0ms	25s302ms	2s617ms	6s84ms	11s818ms	26s584ms
	09	52	0ms	6s396ms	2s444ms	6s395ms	12s473ms	21s238ms
	10	51	0ms	32s653ms	3s648ms	6s438ms	16s777ms	52s339ms
	11	44	0ms	17m6s	25s496ms	4s752ms	12s889ms	17m11s
	12	51	0ms	6s805ms	1s920ms	6s115ms	6s316ms	12s121ms
	13	45	0ms	7s415ms	2s29ms	4s672ms	6s30ms	20s441ms
	14	48	0ms	33s243ms	4s290ms	9s402ms	34s397ms	54s22ms
	15	38	0ms	5s331ms	1s620ms	2s623ms	4s847ms	6s493ms
	16	47	0ms	6s704ms	1s922ms	5s648ms	6s857ms	17s86ms
	17	48	0ms	39s244ms	2s729ms	3s714ms	14s45ms	40s402ms
	18	61	0ms	32s436ms	3s103ms	7s560ms	11s443ms	52s350ms
	19	48	0ms	5s172ms	1s570ms	4s50ms	4s400ms	8s77ms
	20	43	0ms	7s868ms	1s754ms	3s900ms	5s97ms	7s868ms
	21	55	0ms	5s8ms	1s615ms	4s865ms	5s284ms	6s112ms
	22	57	0ms	1m17s	3s784ms	9s584ms	13s883ms	1m17s
	23	74	0ms	1m22s	10s12ms	14s809ms	32s828ms	6m28s
May 28	00	53	0ms	15m56s	25s368ms	4s808ms	22s637ms	15m56s
	01	47	0ms	17s21ms	2s668ms	5s415ms	8s95ms	18s179ms
	02	39	0ms	29s556ms	2s177ms	3s683ms	4s872ms	29s556ms
	03	64	0ms	17s339ms	2s413ms	4s568ms	14s59ms	38s590ms
	04	45	0ms	8s150ms	1s958ms	4s399ms	8s150ms	10s453ms
	05	83	0ms	5s854ms	1s932ms	6s201ms	14s906ms	20s425ms
	06	56	0ms	9m9s	13s47ms	7s959ms	34s918ms	9m11s
	07	50	0ms	4s720ms	1s552ms	3s425ms	3s892ms	9s340ms
	08	62	0ms	1m7s	4s148ms	7s227ms	12s450ms	1m8s
	09	52	0ms	1m8s	3s487ms	5s299ms	9s952ms	1m9s
	10	48	0ms	32s570ms	3s774ms	5s74ms	13s51ms	52s469ms
	11	53	0ms	7s109ms	1s922ms	4s609ms	7s410ms	9s272ms
	12	45	0ms	3m46s	7s992ms	5s790ms	13s1ms	3m48s
	13	58	0ms	5s717ms	2s181ms	5s717ms	7s261ms	13s291ms
	14	65	0ms	4m19s	7s11ms	7s513ms	39s478ms	4m21s
	15	59	0ms	39s858ms	2s800ms	6s300ms	8s202ms	41s61ms
	16	65	0ms	13s705ms	3s94ms	10s736ms	16s300ms	42s441ms
	17	76	0ms	3m48s	11s199ms	1m5s	1m28s	4m2s
	18	48	0ms	1m3s	5s354ms	9s507ms	40s611ms	1m3s
	19	53	0ms	6s420ms	1s491ms	2s728ms	7s536ms	9s960ms
	20	39	0ms	34s400ms	2s458ms	3s555ms	5s441ms	34s400ms
	21	50	0ms	6s234ms	1s540ms	3s985ms	6s234ms	6s709ms
	22	49	0ms	6s426ms	1s953ms	5s251ms	6s851ms	12s216ms
	23	87	0ms	48s744ms	4s213ms	9s354ms	40s482ms	2m23s
May 29	00	61	0ms	16m1s	18s920ms	12s453ms	26s514ms	16m8s
	01	59	0ms	7s904ms	1s955ms	6s266ms	9s13ms	13s960ms
	02	68	0ms	48s991ms	3s129ms	6s913ms	12s138ms	48s991ms
	03	54	0ms	44s753ms	2s879ms	6s379ms	7s497ms	44s753ms
	04	47	0ms	5s326ms	1s853ms	4s108ms	6s496ms	8s623ms
	05	98	0ms	14s832ms	2s738ms	14s670ms	17s843ms	25s164ms
	06	68	0ms	32s570ms	3s202ms	8s813ms	14s564ms	52s467ms
	07	63	0ms	3m36s	5s611ms	8s188ms	9s155ms	3m37s
	08	62	0ms	1m46s	10s53ms	1m5s	1m20s	2m15s
	09	42	0ms	45s406ms	2s741ms	2s687ms	5s963ms	47s722ms
	10	57	0ms	32s441ms	3s677ms	5s323ms	32s42ms	55s508ms
	11	49	0ms	9s66ms	1s814ms	4s890ms	7s388ms	11s434ms
	12	42	0ms	1m32s	7s48ms	4s927ms	30s523ms	2m42s
	13	63	0ms	6s937ms	1s970ms	5s849ms	8s832ms	10s697ms
	14	62	0ms	32s637ms	3s253ms	6s825ms	11s234ms	55s589ms
	15	32	0ms	6s886ms	2s279ms	4s867ms	6s412ms	7s736ms
	16	39	0ms	15s512ms	2s430ms	3s953ms	7s432ms	21s225ms
	17	60	0ms	23m6s	41s367ms	6s520ms	3m13s	23m8s
	18	67	0ms	34m6s	50s431ms	1m2s	4m44s	34m20s
	19	116	0ms	51s124ms	19s264ms	1m13s	1m17s	1m22s
	20	159	1s30ms	39m46s	52s586ms	1m18s	2m46s	40m22s
	21	181	1s111ms	6m27s	30s596ms	2m48s	4m13s	7m49s
	22	163	1s12ms	57s653ms	23s68ms	1m22s	1m36s	2m45s
	23	151	0ms	12m17s	26s258ms	1m48s	4m20s	13m32s
May 30	00	56	0ms	23m2s	49s9ms	21s662ms	2m4s	23m3s
	01	52	0ms	1h35m57s	1m57s	7s864ms	1m36s	1h35m57s
	02	101	0ms	43s117ms	16s41ms	1m15s	1m22s	1m36s
	03	152	1s9ms	1h7m21s	1m10s	1m27s	3m43s	1h8m43s
	04	141	1s11ms	37s505ms	24s669ms	1m13s	1m15s	1m46s
	05	146	1s23ms	1h56m	1m9s	1m13s	2m	1h56m59s
	06	135	1s45ms	33m23s	44s775ms	1m20s	1m53s	33m58s
	07	136	1s30ms	36s58ms	24s231ms	1m11s	1m12s	1m14s
	08	149	1s115ms	3m37s	24s763ms	1m14s	1m14s	4m51s
	09	149	1s33ms	39s190ms	23s751ms	1m15s	1m25s	1m39s
	10	197	1s3ms	54s858ms	18s831ms	1m17s	1m50s	2m9s
	11	168	0ms	1m14s	22s586ms	1m27s	2m1s	2m31s
	12	349	1s1ms	33m14s	18s370ms	1m46s	1m47s	34m37s
	13	144	1s110ms	2m7s	26s403ms	1m17s	1m31s	3m3s
	14	159	1s33ms	38s718ms	22s693ms	1m14s	1m23s	2m5s
	15	134	1s112ms	38s610ms	25s714ms	1m13s	1m14s	1m16s
	16	140	1s111ms	37s564ms	24s821ms	1m14s	1m15s	1m17s
	17	119	1s11ms	36s492ms	28s673ms	1m11s	1m12s	1m14s
	18	180	1s18ms	1m3s	20s609ms	1m19s	1m25s	2m7s
	19	137	1s112ms	36s818ms	25s309ms	1m14s	1m15s	1m19s
	20	135	1s111ms	37s999ms	25s638ms	1m15s	1m17s	1m18s
	21	143	1s114ms	39s106ms	24s680ms	1m16s	1m17s	1m54s
	22	148	1s57ms	8m27s	27s115ms	1m15s	1m16s	9m39s
	23	137	1s37ms	37s165ms	25s25ms	1m13s	1m13s	1m14s
May 31	00	141	1s112ms	16m10s	31s611ms	1m15s	1m18s	17m34s
	01	149	1s114ms	39s93ms	23s423ms	1m17s	1m19s	1m27s
	02	133	1s1ms	37s478ms	26s210ms	1m14s	1m17s	1m19s
	03	153	1s13ms	38s52ms	22s678ms	1m15s	1m17s	1m20s
	04	142	1s55ms	39s527ms	24s528ms	1m16s	1m17s	1m23s
	05	154	0ms	37s980ms	14s723ms	1m14s	1m16s	1m26s
	06	46	0ms	17m6s	25s749ms	5s210ms	43s321ms	17m6s
	07	41	0ms	8s394ms	1s925ms	4s312ms	7s167ms	14s739ms
	08	49	0ms	6s6ms	1s708ms	3s765ms	6s180ms	10s586ms
	09	58	0ms	3m35s	9s870ms	10s215ms	42s457ms	5m8s
	10	62	0ms	32s643ms	3s653ms	17s172ms	24s788ms	53s413ms
	11	49	0ms	5s83ms	1s508ms	2s514ms	4s689ms	8s868ms
	12	39	0ms	8s356ms	1s881ms	2s572ms	5s823ms	9s516ms
	13	38	0ms	7s378ms	2s101ms	5s288ms	7s266ms	7s378ms
	14	50	0ms	32s605ms	3s935ms	7s333ms	16s569ms	54s592ms
	15	83	0ms	12s273ms	2s35ms	7s36ms	12s995ms	24s681ms
	16	38	0ms	4s687ms	1s447ms	2s894ms	3s859ms	5s879ms
	17	54	0ms	5s502ms	1s775ms	4s863ms	6s644ms	9s224ms
	18	51	0ms	32s934ms	3s507ms	6s9ms	10s573ms	53s349ms
	19	53	0ms	13s644ms	1s758ms	4s80ms	6s892ms	15s838ms
	20	47	0ms	6s699ms	1s692ms	4s58ms	5s898ms	7s898ms
	21	37	0ms	6s342ms	1s735ms	5s2ms	5s980ms	9s996ms
	22	56	0ms	12s505ms	2s51ms	5s387ms	7s630ms	13s636ms
	23	51	0ms	14s120ms	2s571ms	5s237ms	14s120ms	22s8ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 27	00	61	0	17s817ms	4s710ms	7s687ms	16m2s
	01	40	0	2s712ms	5s34ms	7s566ms	12s965ms
	02	62	0	1s666ms	3s701ms	5s47ms	7s618ms
	03	64	0	1s851ms	3s790ms	5s333ms	6s890ms
	04	58	0	2s465ms	4s345ms	5s584ms	15s166ms
	05	82	0	2s116ms	4s151ms	10s633ms	35s524ms
	06	50	10	3s569ms	3s868ms	8s22ms	39s504ms
	07	44	0	6s800ms	2s683ms	5s171ms	6s467ms
	08	50	0	2s617ms	3s639ms	6s84ms	12s463ms
	09	52	0	2s444ms	3s612ms	6s395ms	13s332ms
	10	41	10	3s648ms	2s765ms	6s438ms	39s457ms
	11	44	0	25s496ms	3s399ms	4s752ms	13s755ms
	12	51	0	1s920ms	3s892ms	6s115ms	12s121ms
	13	45	0	2s29ms	2s490ms	4s672ms	8s883ms
	14	38	10	4s290ms	2s477ms	9s402ms	39s266ms
	15	38	0	1s620ms	2s362ms	2s623ms	5s579ms
	16	47	0	1s922ms	2s524ms	5s648ms	17s86ms
	17	48	0	2s729ms	2s511ms	3s714ms	14s361ms
	18	51	10	3s103ms	3s678ms	7s560ms	39s247ms
	19	48	0	1s570ms	2s512ms	4s50ms	8s77ms
	20	43	0	1s754ms	2s497ms	3s900ms	6s646ms
	21	55	0	1s615ms	3s649ms	4s865ms	6s112ms
	22	57	0	3s784ms	5s195ms	9s584ms	1m17s
	23	74	0	10s12ms	5s113ms	14s809ms	2m44s
May 28	00	52	0	25s764ms	2s488ms	4s654ms	4m50s
	01	47	0	2s668ms	3s890ms	5s415ms	12s402ms
	02	39	0	2s177ms	2s369ms	3s683ms	29s556ms
	03	64	0	2s413ms	3s670ms	4s568ms	14s660ms
	04	45	0	1s958ms	2s761ms	4s399ms	10s453ms
	05	79	0	1s919ms	3s428ms	6s201ms	19s892ms
	06	48	8	13s47ms	3s543ms	7s959ms	39s306ms
	07	50	0	1s552ms	2s403ms	3s425ms	7s821ms
	08	62	0	4s148ms	3s910ms	7s227ms	1m7s
	09	52	0	3s487ms	3s716ms	5s299ms	20s498ms
	10	38	10	3s774ms	3s817ms	5s377ms	39s405ms
	11	53	0	1s922ms	3s656ms	4s609ms	7s578ms
	12	45	0	7s992ms	2s395ms	5s790ms	53s149ms
	13	54	0	2s137ms	4s340ms	5s608ms	7s261ms
	14	55	10	7s11ms	3s877ms	7s513ms	52s666ms
	15	59	0	2s800ms	5s164ms	6s300ms	11s703ms
	16	64	0	2s975ms	4s924ms	6s821ms	42s441ms
	17	76	0	11s199ms	15s412ms	1m5s	1m35s
	18	39	9	5s354ms	3s783ms	8s351ms	1m3s
	19	53	0	1s491ms	2s388ms	2s728ms	9s960ms
	20	39	0	2s458ms	2s342ms	3s555ms	34s400ms
	21	50	0	1s540ms	2s387ms	3s985ms	6s535ms
	22	49	0	1s953ms	3s431ms	5s251ms	12s216ms
	23	87	0	4s213ms	4s719ms	9s354ms	45s227ms
May 29	00	60	0	19s154ms	4s164ms	12s453ms	45s763ms
	01	59	0	1s955ms	2s994ms	6s266ms	12s969ms
	02	68	0	3s129ms	4s416ms	6s913ms	43s566ms
	03	54	0	2s879ms	4s785ms	6s379ms	12s212ms
	04	47	0	1s853ms	3s441ms	4s108ms	6s956ms
	05	95	0	2s743ms	6s938ms	14s670ms	24s289ms
	06	59	9	3s202ms	4s872ms	8s336ms	39s416ms
	07	62	0	5s672ms	4s874ms	7s433ms	9s531ms
	08	61	0	10s165ms	6s605ms	1m5s	1m21s
	09	41	0	2s749ms	2s211ms	2s687ms	7s518ms
	10	47	10	3s677ms	3s276ms	5s323ms	39s265ms
	11	48	0	1s812ms	2s377ms	4s890ms	8s356ms
	12	38	0	4s301ms	3s124ms	4s881ms	1m9s
	13	63	0	1s970ms	4s785ms	5s849ms	9s347ms
	14	52	10	3s253ms	4s940ms	6s825ms	39s576ms
	15	32	0	2s279ms	3s515ms	4s867ms	7s736ms
	16	39	0	2s430ms	1s292ms	3s953ms	15s727ms
	17	55	0	1s611ms	2s427ms	3s858ms	6s520ms
	18	50	10	48s726ms	4s16ms	9s463ms	10m22s
	19	116	0	19s264ms	1m11s	1m13s	1m18s
	20	159	0	52s586ms	1m15s	1m18s	40m11s
	21	148	0	29s507ms	1m16s	1m22s	5m59s
	22	163	0	23s68ms	1m15s	1m22s	2m38s
	23	114	0	21s792ms	1m13s	1m18s	1m41s
May 30	00	45	0	23s170ms	2s231ms	3s946ms	8s75ms
	01	50	0	1m58s	3s348ms	6s271ms	1m36s
	02	101	0	16s41ms	1m13s	1m15s	1m24s
	03	138	0	55s654ms	1m19s	1m24s	3m39s
	04	141	0	24s669ms	1m12s	1m13s	1m16s
	05	142	0	1m11s	1m11s	1m13s	2m3s
	06	126	9	44s775ms	1m16s	1m18s	10m6s
	07	136	0	24s231ms	1m11s	1m11s	1m14s
	08	149	0	24s763ms	1m12s	1m14s	1m15s
	09	148	0	23s899ms	1m12s	1m15s	1m26s
	10	185	10	19s2ms	1m11s	1m13s	1m30s
	11	166	0	22s831ms	1m16s	1m27s	2m2s
	12	349	0	18s370ms	1m44s	1m46s	1m48s
	13	143	0	26s578ms	1m14s	1m17s	2m52s
	14	148	10	22s824ms	1m12s	1m14s	1m17s
	15	134	0	25s714ms	1m12s	1m13s	1m15s
	16	140	0	24s821ms	1m13s	1m14s	1m15s
	17	119	0	28s673ms	1m11s	1m11s	1m12s
	18	170	10	20s609ms	1m13s	1m18s	1m25s
	19	137	0	25s309ms	1m12s	1m14s	1m16s
	20	135	0	25s638ms	1m13s	1m15s	1m18s
	21	143	0	24s680ms	1m14s	1m16s	1m19s
	22	148	0	27s115ms	1m13s	1m15s	1m16s
	23	137	0	25s25ms	1m13s	1m13s	1m13s
May 31	00	140	0	31s802ms	1m14s	1m15s	1m19s
	01	149	0	23s423ms	1m14s	1m17s	1m20s
	02	133	0	26s210ms	1m13s	1m14s	1m18s
	03	153	0	22s678ms	1m14s	1m15s	1m18s
	04	141	0	24s688ms	1m14s	1m16s	1m18s
	05	151	0	14s963ms	1m13s	1m14s	1m16s
	06	36	10	25s749ms	1s452ms	5s210ms	53s502ms
	07	41	0	1s925ms	2s399ms	4s312ms	10s899ms
	08	48	0	1s704ms	2s375ms	3s765ms	9s619ms
	09	54	0	10s441ms	2s26ms	10s215ms	5m8s
	10	52	10	3s653ms	5s577ms	11s393ms	53s413ms
	11	49	0	1s508ms	2s408ms	2s514ms	6s742ms
	12	39	0	1s881ms	2s339ms	2s572ms	6s161ms
	13	38	0	2s101ms	2s491ms	5s288ms	7s378ms
	14	40	10	3s935ms	3s583ms	7s333ms	39s516ms
	15	81	0	2s31ms	3s929ms	7s36ms	23s116ms
	16	38	0	1s447ms	1s557ms	2s894ms	5s879ms
	17	54	0	1s775ms	2s574ms	4s863ms	8s63ms
	18	41	10	3s507ms	3s608ms	6s9ms	39s806ms
	19	53	0	1s758ms	3s397ms	4s80ms	15s838ms
	20	47	0	1s692ms	2s271ms	4s58ms	7s639ms
	21	36	0	1s728ms	1s387ms	5s2ms	8s145ms
	22	56	0	2s51ms	2s757ms	5s387ms	13s636ms
	23	51	0	2s571ms	3s804ms	5s237ms	15s672ms

Day	Hour	INSERT	UPDATE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 27	00	0	0	0ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms
May 28	00	0	0	0ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	1	0	10s736ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms
May 29	00	0	0	0ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	5	0	7m58s	0ms	0ms	3m12s
	18	7	0	1m5s	0ms	0ms	1m52s
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	12	5	22s151ms	0ms	0ms	1m17s
May 30	00	5	4	3m8s	0ms	0ms	1m38s
	01	1	0	2m39s	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms
May 31	00	0	0	0ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
May 27	00	61	61.00	0.00%
	01	40	40.00	0.00%
	02	62	62.00	0.00%
	03	64	64.00	0.00%
	04	58	58.00	0.00%
	05	84	84.00	0.00%
	06	62	62.00	0.00%
	07	54	54.00	0.00%
	08	54	54.00	0.00%
	09	52	52.00	0.00%
	10	41	41.00	0.00%
	11	44	44.00	0.00%
	12	51	51.00	0.00%
	13	45	45.00	0.00%
	14	42	42.00	0.00%
	15	39	39.00	0.00%
	16	47	47.00	0.00%
	17	48	48.00	0.00%
	18	51	51.00	0.00%
	19	48	48.00	0.00%
	20	43	43.00	0.00%
	21	55	55.00	0.00%
	22	57	57.00	0.00%
	23	74	74.00	0.00%
May 28	00	51	51.00	0.00%
	01	47	47.00	0.00%
	02	39	39.00	0.00%
	03	64	64.00	0.00%
	04	45	45.00	0.00%
	05	95	95.00	0.00%
	06	64	64.00	0.00%
	07	54	54.00	0.00%
	08	62	62.00	0.00%
	09	52	52.00	0.00%
	10	42	42.00	0.00%
	11	57	57.00	0.00%
	12	55	55.00	0.00%
	13	56	56.00	0.00%
	14	56	56.00	0.00%
	15	61	61.00	0.00%
	16	64	64.00	0.00%
	17	78	78.00	0.00%
	18	39	39.00	0.00%
	19	53	53.00	0.00%
	20	39	39.00	0.00%
	21	50	50.00	0.00%
	22	49	49.00	0.00%
	23	87	87.00	0.00%
May 29	00	59	59.00	0.00%
	01	59	59.00	0.00%
	02	68	68.00	0.00%
	03	54	54.00	0.00%
	04	47	47.00	0.00%
	05	98	98.00	0.00%
	06	63	63.00	0.00%
	07	80	80.00	0.00%
	08	67	67.00	0.00%
	09	43	43.00	0.00%
	10	50	50.00	0.00%
	11	50	50.00	0.00%
	12	36	36.00	0.00%
	13	63	63.00	0.00%
	14	52	52.00	0.00%
	15	32	32.00	0.00%
	16	39	39.00	0.00%
	17	61	61.00	0.00%
	18	59	59.00	0.00%
	19	116	116.00	0.00%
	20	159	159.00	0.00%
	21	181	181.00	0.00%
	22	163	163.00	0.00%
	23	151	151.00	0.00%
May 30	00	54	54.00	0.00%
	01	53	53.00	0.00%
	02	101	101.00	0.00%
	03	152	152.00	0.00%
	04	144	144.00	0.00%
	05	147	147.00	0.00%
	06	130	130.00	0.00%
	07	141	141.00	0.00%
	08	149	149.00	0.00%
	09	126	126.00	0.00%
	10	186	186.00	0.00%
	11	169	169.00	0.00%
	12	349	349.00	0.00%
	13	142	142.00	0.00%
	14	149	149.00	0.00%
	15	134	134.00	0.00%
	16	140	140.00	0.00%
	17	119	119.00	0.00%
	18	170	170.00	0.00%
	19	137	137.00	0.00%
	20	135	135.00	0.00%
	21	143	143.00	0.00%
	22	148	148.00	0.00%
	23	137	137.00	0.00%
May 31	00	139	139.00	0.00%
	01	149	149.00	0.00%
	02	133	133.00	0.00%
	03	153	153.00	0.00%
	04	142	142.00	0.00%
	05	154	154.00	0.00%
	06	41	41.00	0.00%
	07	50	50.00	0.00%
	08	50	50.00	0.00%
	09	58	58.00	0.00%
	10	56	56.00	0.00%
	11	49	49.00	0.00%
	12	40	40.00	0.00%
	13	46	46.00	0.00%
	14	41	41.00	0.00%
	15	83	83.00	0.00%
	16	40	40.00	0.00%
	17	58	58.00	0.00%
	18	41	41.00	0.00%
	19	53	53.00	0.00%
	20	47	47.00	0.00%
	21	37	37.00	0.00%
	22	56	56.00	0.00%
	23	51	51.00	0.00%

Day	Hour	Count	Average / Second
May 27	00	95	0.03/s
	01	121	0.03/s
	02	115	0.03/s
	03	100	0.03/s
	04	92	0.03/s
	05	116	0.03/s
	06	86	0.02/s
	07	82	0.02/s
	08	99	0.03/s
	09	96	0.03/s
	10	96	0.03/s
	11	141	0.04/s
	12	102	0.03/s
	13	111	0.03/s
	14	122	0.03/s
	15	89	0.02/s
	16	92	0.03/s
	17	95	0.03/s
	18	90	0.03/s
	19	95	0.03/s
	20	93	0.03/s
	21	87	0.02/s
	22	84	0.02/s
	23	109	0.03/s
May 28	00	93	0.03/s
	01	113	0.03/s
	02	110	0.03/s
	03	89	0.02/s
	04	79	0.02/s
	05	114	0.03/s
	06	94	0.03/s
	07	89	0.02/s
	08	109	0.03/s
	09	100	0.03/s
	10	117	0.03/s
	11	106	0.03/s
	12	298	0.08/s
	13	161	0.04/s
	14	99	0.03/s
	15	107	0.03/s
	16	140	0.04/s
	17	110	0.03/s
	18	108	0.03/s
	19	92	0.03/s
	20	86	0.02/s
	21	84	0.02/s
	22	84	0.02/s
	23	92	0.03/s
May 29	00	135	0.04/s
	01	103	0.03/s
	02	89	0.02/s
	03	121	0.03/s
	04	94	0.03/s
	05	158	0.04/s
	06	100	0.03/s
	07	106	0.03/s
	08	98	0.03/s
	09	93	0.03/s
	10	107	0.03/s
	11	111	0.03/s
	12	83	0.02/s
	13	83	0.02/s
	14	90	0.03/s
	15	92	0.03/s
	16	98	0.03/s
	17	92	0.03/s
	18	101	0.03/s
	19	142	0.04/s
	20	177	0.05/s
	21	192	0.05/s
	22	239	0.07/s
	23	190	0.05/s
May 30	00	94	0.03/s
	01	87	0.02/s
	02	144	0.04/s
	03	177	0.05/s
	04	183	0.05/s
	05	182	0.05/s
	06	182	0.05/s
	07	178	0.05/s
	08	189	0.05/s
	09	188	0.05/s
	10	219	0.06/s
	11	213	0.06/s
	12	173	0.05/s
	13	190	0.05/s
	14	187	0.05/s
	15	181	0.05/s
	16	187	0.05/s
	17	178	0.05/s
	18	183	0.05/s
	19	179	0.05/s
	20	187	0.05/s
	21	204	0.06/s
	22	182	0.05/s
	23	181	0.05/s
May 31	00	186	0.05/s
	01	181	0.05/s
	02	186	0.05/s
	03	196	0.05/s
	04	194	0.05/s
	05	162	0.04/s
	06	87	0.02/s
	07	85	0.02/s
	08	93	0.03/s
	09	365	0.10/s
	10	87	0.02/s
	11	86	0.02/s
	12	81	0.02/s
	13	87	0.02/s
	14	85	0.02/s
	15	127	0.04/s
	16	83	0.02/s
	17	82	0.02/s
	18	103	0.03/s
	19	108	0.03/s
	20	89	0.02/s
	21	82	0.02/s
	22	102	0.03/s
	23	115	0.03/s

Day	Hour	Count	Average Duration	Average idle time
May 27	00	95	25m53s	25m41s
	01	121	20m7s	20m6s
	02	115	20m55s	20m54s
	03	100	24m3s	24m2s
	04	92	25m26s	25m25s
	05	116	19m41s	19m40s
	06	86	28m2s	28m
	07	82	29m12s	29m9s
	08	99	24m21s	24m19s
	09	96	25m31s	25m30s
	10	96	26m	25m58s
	11	141	17m8s	17m
	12	102	24m5s	24m4s
	13	111	21m10s	21m10s
	14	122	20m29s	20m28s
	15	89	26m53s	26m52s
	16	88	27m20s	27m19s
	17	95	25m18s	25m16s
	18	90	27m8s	27m6s
	19	95	24m38s	24m38s
	20	93	24m59s	24m58s
	21	87	26m2s	26m1s
	22	84	27m56s	27m53s
	23	109	23m46s	23m39s
May 28	00	93	25m31s	25m17s
	01	113	22m12s	22m10s
	02	110	21m14s	21m13s
	03	89	26m53s	26m51s
	04	79	28m25s	28m24s
	05	114	20m52s	20m51s
	06	94	25m31s	25m23s
	07	89	27m10s	27m10s
	08	109	22m32s	22m30s
	09	100	24m30s	24m28s
	10	117	20m39s	20m38s
	11	106	23m18s	23m17s
	12	298	8m1s	8m
	13	159	46m57s	46m56s
	14	99	25m7s	25m3s
	15	107	22m	21m58s
	16	139	17m26s	17m25s
	17	111	21m59s	21m52s
	18	108	22m44s	22m42s
	19	95	36m57s	36m56s
	20	89	39m39s	39m38s
	21	84	27m28s	27m27s
	22	84	28m51s	28m50s
	23	92	27m9s	27m5s
May 29	00	135	18m17s	18m8s
	01	103	22m31s	22m30s
	02	89	25m47s	25m44s
	03	121	19m17s	19m16s
	04	94	26m1s	26m
	05	158	15m	14m59s
	06	97	24m2s	24m
	07	106	23m19s	23m15s
	08	98	24m28s	24m22s
	09	93	27m23s	27m22s
	10	107	21m57s	21m55s
	11	111	22m28s	22m28s
	12	83	28m18s	28m14s
	13	83	28m43s	28m41s
	14	90	27m10s	27m8s
	15	92	26m29s	26m29s
	16	98	25m2s	25m1s
	17	91	25m21s	24m53s
	18	101	25m	24m27s
	19	142	17m8s	16m53s
	20	177	14m36s	13m49s
	21	191	55m2s	54m33s
	22	239	10m26s	10m10s
	23	191	13m5s	12m44s
May 30	00	94	26m16s	25m46s
	01	87	26m3s	24m53s
	02	143	16m31s	16m19s
	03	177	13m59s	12m59s
	04	184	13m21s	13m3s
	05	181	13m18s	12m22s
	06	183	15m27s	14m54s
	07	179	13m50s	13m31s
	08	189	13m7s	12m47s
	09	187	13m7s	12m48s
	10	216	10m58s	10m40s
	11	214	12m16s	11m59s
	12	173	14m6s	13m29s
	13	188	13m8s	12m48s
	14	188	13m8s	12m49s
	15	180	13m48s	13m29s
	16	188	13m1s	12m43s
	17	181	19m57s	19m38s
	18	183	13m22s	13m1s
	19	183	49m52s	49m33s
	20	186	13m2s	12m43s
	21	204	11m49s	11m32s
	22	183	13m34s	13m12s
	23	181	13m28s	13m9s
May 31	00	186	13m40s	13m16s
	01	180	12m36s	12m16s
	02	187	13m4s	12m46s
	03	196	12m7s	11m49s
	04	193	12m44s	12m26s
	05	162	14m4s	13m50s
	06	88	26m39s	26m26s
	07	85	28m42s	28m41s
	08	92	26m58s	26m57s
	09	366	7m43s	7m42s
	10	87	27m14s	27m11s
	11	86	27m13s	27m12s
	12	81	30m6s	30m5s
	13	87	27m51s	27m50s
	14	85	28m56s	28m54s
	15	127	18m11s	18m9s
	16	83	29m21s	29m20s
	17	82	29m58s	29m57s
	18	103	23m47s	23m46s
	19	108	22m51s	22m50s
	20	89	25m40s	25m39s
	21	82	28m41s	28m41s
	22	102	23m25s	23m24s
	23	115	21m24s	21m23s

↑ Back to the top of the General Activity table

Database	User	Count
ctdprd51		15,270
	edit	9
	editeu	1,850
	load	164
	postgres	40
	pub1	26
	pub2	2
	pubc	10
	pubeu	9,338
	qaeu	3,830
	zbx_monitor	1
postgres		6
	edit	2
	load	1
	pub1	2
	pubc	1

User	Count
edit	11
editeu	1,850
load	165
postgres	40
pub1	28
pub2	2
pubc	11
pubeu	9,338
qaeu	3,830
zbx_monitor	1

Host	Count
10.12.5.36	38
10.12.5.37	7,460
10.12.5.38	1,885
10.12.5.39	1,849
10.12.5.40	169
10.12.5.45	1,930
10.12.5.46	1,882
192.168.201.14	15
192.168.201.6	7
::1	41

Simultaneous sessions

Key values

104 sessions Session Peak
2024-05-30 02:51:24 Date

Histogram of session times

Key values

8,507 1800000-3600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	604	3.95%
500ms-1s	87	0.57%
1s-30s	440	2.88%
30s-1m	1,762	11.53%
1m-10m	3,318	21.72%
10m-30m	518	3.39%
30m-1h	8,507	55.69%
1h-8h	32	0.21%
> 8h	8	0.05%

Sessions per database

Key values

ctdprd51 Main Database
15,276 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctdprd51	15,270	215d16h51m21s	20m20s
postgres	6	2d12h12m39s	10h2m6s

Sessions per user

Key values

pubeu Main User
15,276 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
edit	11	3d23h18m36s	8h39m52s
editeu	1,850	40d1h45m44s	31m11s
load	165	2d20h23s	24m43s
postgres	40	36m45s	55s136ms
pub1	28	1d18h50m	1h31m47s
pub2	2	30s429ms	15s214ms
pubc	11	2d16h48m38s	5h53m30s
pubeu	9,338	81d1h32m53s	12m30s
qaeu	3,830	80d2h26m3s	30m6s
zbx_monitor	1	5d15h44m25s	5d15h44m25s

Sessions per host

Key values

10.12.5.37 Main Host
15,276 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.36	38	2h28s	3m10s
10.12.5.37	7,460	41d2h4m31s	7m55s
10.12.5.38	1,885	40d48m24s	30m34s
10.12.5.39	1,849	40d1h45m44s	31m12s
10.12.5.40	169	14h23m2s	5m6s
10.12.5.45	1,930	40d13m26s	29m51s
10.12.5.46	1,882	40d15m22s	30m36s
192.168.201.14	15	5d5h16m38s	8h21m6s
192.168.201.6	7	5d9h55m11s	18h33m35s
::1	41	5d16h21m10s	3h19m32s

Sessions per application

Key values

unknown Main Application
15,276 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
pgAdmin 4 - DB:ctdprd51	2	1s722ms	861ms
pg_bulkload	14	7s31ms	502ms
psql	27	15s71ms	558ms
unknown	15,233	218d5h3m37s	20m37s

Checkpoints Buffers

Key values

4,930,288 buffers Checkpoint Peak
2024-05-29 23:53:53 Date
1619.997 seconds Highest write time
0.927 seconds Sync time

Checkpoints Wal files

Key values

975 files Wal files usage Peak
2024-05-30 03:30:33 Date

Checkpoints distance

Key values

18,692.72 Mo Distance Peak
2024-05-29 23:31:52 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 27	00	3,039	320.236s	0.002s	320.282s
	01	274	27.658s	0.002s	27.688s
	02	373	37.567s	0.002s	37.598s
	03	6,167	617.704s	0.003s	617.821s
	04	393	39.566s	0.002s	39.596s
	05	3,704	371.097s	0.003s	371.179s
	06	3,712	371.938s	0.003s	372.065s
	07	1,749	175.427s	0.003s	175.458s
	08	4,724	473.227s	0.002s	473.284s
	09	63,541	2,093.098s	0.004s	2,093.682s
	10	510	51.292s	0.003s	51.322s
	11	384	38.573s	0.003s	38.604s
	12	394	39.684s	0.003s	39.718s
	13	2,019	202.687s	0.004s	202.767s
	14	540	54.195s	0.003s	54.226s
	15	6,858	687.046s	0.004s	687.197s
	16	391	39.306s	0.007s	39.453s
	17	2,133	213.889s	0.004s	213.921s
	18	373	37.561s	0.002s	37.638s
	19	504	50.624s	0.002s	50.653s
	20	4,405	441.52s	0.002s	441.609s
	21	571	57.282s	0.002s	57.312s
	22	436	43.862s	0.002s	43.893s
	23	50,591	1,641.448s	0.002s	1,641.917s
May 28	00	1,997	223.002s	0.004s	223.047s
	01	6,788	679.912s	0.003s	680.013s
	02	321	32.349s	0.002s	32.38s
	03	321	32.255s	0.002s	32.287s
	04	170	17.142s	0.001s	17.204s
	05	50,309	1,669.491s	0.005s	1,669.966s
	06	70,290	1,646.855s	0.004s	1,647.422s
	07	665	66.62s	0.003s	66.652s
	08	374	37.663s	0.002s	37.693s
	09	1,027	102.998s	0.002s	103.029s
	10	7,477	748.925s	0.004s	749.05s
	11	694	69.674s	0.003s	69.705s
	12	515	51.813s	0.003s	51.844s
	13	223	22.437s	0.001s	22.452s
	14	36,961	1,936.5s	0.17s	1,937.127s
	15	471	47.369s	0.003s	47.402s
	16	250	25.141s	0.002s	25.157s
	17	254,196	1,834.437s	0.669s	1,852.065s
	18	429	43.169s	0.003s	43.343s
	19	687	69.02s	0.002s	69.05s
	20	431	43.255s	0.003s	43.286s
	21	540	54.292s	0.002s	54.322s
	22	32,016	1,630.984s	0.003s	1,631.091s
	23	590	59.302s	0.002s	59.333s
May 29	00	2,438	244.511s	0.004s	244.591s
	01	313	31.549s	0.003s	31.58s
	02	395	39.769s	0.004s	39.803s
	03	59,154	1,643.249s	0.003s	1,643.436s
	04	56,046	1,696.599s	0.003s	1,696.78s
	05	5,046	505.508s	0.003s	505.592s
	06	7,207	722.019s	0.003s	722.097s
	07	671	67.458s	0.004s	67.533s
	08	1,324	132.731s	0.01s	140.236s
	09	23,641	1,673.796s	0.008s	1,678.354s
	10	949	95.279s	0.003s	95.434s
	11	526	52.794s	0.002s	52.825s
	12	33,127	1,634.973s	0.003s	1,640.07s
	13	494	49.571s	0.002s	49.709s
	14	6,834	684.503s	0.003s	684.633s
	15	328	33.075s	0.002s	33.118s
	16	481	48.282s	0.003s	48.377s
	17	1,782,505	956.598s	0.485s	977.823s
	18	1,463,683	3,238.948s	0.042s	3,250.147s
	19	32,036	1,670.925s	0.006s	1,671.189s
	20	217	21.829s	0.002s	21.844s
	21	3,742,423	482.579s	1.508s	520.808s
	22	666,507	1,629.219s	0.013s	1,635.846s
	23	8,807,658	3,125.137s	0.972s	3,154.676s
May 30	00	1,688,031	1,443.065s	0.851s	1,464.248s
	01	1,152,261	1,661.452s	0.005s	1,667.551s
	02	322,306	1,619.997s	0.006s	1,622.675s
	03	651,011	2,162.283s	3.64s	2,323.343s
	04	471,439	1,619.356s	0.008s	1,626.511s
	05	180,325	3,667.716s	0.059s	3,669.762s
	06	1,162,698	3,238.868s	0.004s	3,249.824s
	07	3,290	329.688s	0.003s	329.718s
	08	1,701	170.829s	0.005s	170.878s
	09	1,733	173.728s	0.002s	173.748s
	10	25,864	1,656.295s	0.003s	1,656.432s
	11	21,620	1,741.429s	0.004s	1,741.804s
	12	662	66.604s	0.015s	66.648s
	13	305	30.662s	0.002s	30.677s
	14	3,161	316.975s	0.006s	317.069s
	15	1,093	109.709s	0.003s	109.741s
	16	666	66.856s	0.002s	66.93s
	17	456	45.898s	0.002s	45.929s
	18	778	78.038s	0.004s	78.071s
	19	912	91.592s	0.003s	91.623s
	20	979	98.292s	0.003s	98.322s
	21	256	25.746s	0.002s	25.763s
	22	51,121	1,680.414s	0.004s	1,680.616s
	23	272	27.359s	0.001s	27.416s
May 31	00	55,268	1,859.079s	0.018s	1,859.342s
	01	762	76.499s	0.002s	76.529s
	02	603	60.634s	0.002s	60.663s
	03	633	63.551s	0.003s	63.582s
	04	781	78.35s	0.002s	78.366s
	05	79,252	3,239.065s	0.004s	3,239.349s
	06	20,097	2,013.062s	0.005s	2,013.169s
	07	1,154	115.824s	0.002s	115.912s
	08	50,689	1,630.958s	0.003s	1,631.14s
	09	823	82.605s	0.003s	82.688s
	10	677	68.01s	0.003s	68.04s
	11	397	39.869s	0.002s	39.899s
	12	2,363	236.908s	0.003s	236.988s
	13	613	61.516s	0.002s	61.548s
	14	698	70.142s	0.003s	70.175s
	15	1,187	118.94s	0.001s	119.002s
	16	2,295	230.011s	0.004s	230.043s
	17	3,438	344.605s	0.004s	344.687s
	18	2,255	226.282s	0.004s	226.314s
	19	1,774	177.92s	0.004s	177.952s
	20	1,293	129.757s	0.004s	129.838s
	21	2,137	214.289s	0.005s	214.337s
	22	622	62.431s	0.002s	62.446s
	23	1,349	135.236s	0.003s	135.268s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
May 27	00	0	1	76	0.001s	0.002s
	01	0	0	33	0.001s	0.002s
	02	0	0	44	0.001s	0.002s
	03	0	4	46	0.001s	0.002s
	04	0	0	30	0.001s	0.002s
	05	0	1	49	0.001s	0.002s
	06	0	2	105	0.001s	0.002s
	07	0	0	144	0.001s	0.002s
	08	0	3	67	0.001s	0.001s
	09	0	42	110	0.001s	0.003s
	10	0	0	31	0.001s	0.002s
	11	0	0	26	0.002s	0.002s
	12	0	0	24	0.001s	0.002s
	13	0	1	43	0.001s	0.002s
	14	0	0	79	0.001s	0.002s
	15	0	4	101	0.001s	0.002s
	16	0	1	76	0.001s	0.002s
	17	0	0	46	0.001s	0.002s
	18	0	1	26	0.001s	0.002s
	19	0	0	28	0.001s	0.002s
	20	0	2	31	0.001s	0.002s
	21	0	0	28	0.001s	0.002s
	22	0	0	17	0.001s	0.002s
	23	0	34	39	0.001s	0.002s
May 28	00	0	1	75	0.001s	0.002s
	01	0	3	54	0.001s	0.002s
	02	0	0	31	0.001s	0.002s
	03	0	0	33	0.001s	0.002s
	04	0	1	17	0.001s	0.001s
	05	0	33	115	0.001s	0.003s
	06	0	43	155	0.001s	0.002s
	07	0	0	126	0.001s	0.002s
	08	0	0	33	0.001s	0.002s
	09	0	0	45	0.001s	0.002s
	10	0	5	139	0.001s	0.002s
	11	0	0	123	0.001s	0.002s
	12	0	0	73	0.001s	0.002s
	13	0	0	52	0.001s	0.001s
	14	0	23	890	0.002s	0.003s
	15	0	0	29	0.001s	0.002s
	16	0	0	51	0.001s	0.001s
	17	172	1,286	422	0.382s	0.008s
	18	1	0	40	0.002s	0.002s
	19	0	0	27	0.001s	0.002s
	20	0	0	20	0.001s	0.002s
	21	0	0	26	0.001s	0.002s
	22	3	0	38	0.001s	0.002s
	23	0	0	32	0.001s	0.002s
May 29	00	1	0	83	0.001s	0.002s
	01	0	0	34	0.001s	0.002s
	02	0	0	37	0.001s	0.002s
	03	39	0	55	0.001s	0.002s
	04	38	0	61	0.001s	0.002s
	05	3	0	55	0.001s	0.002s
	06	3	0	90	0.001s	0.002s
	07	1	0	160	0.001s	0.002s
	08	0	570	156	0.001s	0.002s
	09	0	367	197	0.001s	0.003s
	10	1	0	105	0.001s	0.002s
	11	0	0	116	0.001s	0.002s
	12	16	406	114	0.001s	0.002s
	13	1	0	23	0.001s	0.002s
	14	3	0	57	0.001s	0.002s
	15	0	0	17	0.001s	0.002s
	16	1	0	28	0.001s	0.002s
	17	31	1,615	247	0.101s	0.008s
	18	0	917	413	0.001s	0.002s
	19	1	0	73	0.002s	0.003s
	20	0	0	11	0.001s	0.001s
	21	35	2,605	184	0.845s	0.043s
	22	0	545	95	0.002s	0.002s
	23	546	1,953	500	0.803s	0.022s
May 30	00	4	1,610	254	0.599s	0.01s
	01	0	498	138	0.001s	0.003s
	02	108	184	71	0.002s	0.001s
	03	698	10,739	1,039	0.917s	0.068s
	04	0	589	146	0.001s	0.001s
	05	51	112	158	0.030s	0.003s
	06	0	896	247	0.001s	0.002s
	07	0	0	155	0.001s	0.002s
	08	0	0	209	0.001s	0.003s
	09	1	0	30	0.001s	0.001s
	10	10	0	72	0.001s	0.002s
	11	10	0	143	0.002s	0.003s
	12	0	0	36	0.014s	0.003s
	13	0	0	54	0.001s	0.001s
	14	1	0	301	0.002s	0.003s
	15	0	0	121	0.001s	0.002s
	16	1	0	32	0.001s	0.002s
	17	0	0	27	0.001s	0.002s
	18	0	0	32	0.002s	0.002s
	19	0	0	36	0.001s	0.002s
	20	0	0	29	0.001s	0.002s
	21	0	0	11	0.001s	0.001s
	22	35	0	61	0.001s	0.003s
	23	1	0	11	0.001s	0.001s
May 31	00	36	0	100	0.011s	0.003s
	01	0	0	38	0.001s	0.002s
	02	0	0	39	0.001s	0.002s
	03	0	0	40	0.001s	0.002s
	04	0	0	25	0.001s	0.001s
	05	54	0	77	0.001s	0.002s
	06	3	0	142	0.001s	0.003s
	07	1	0	151	0.001s	0.002s
	08	33	0	115	0.001s	0.002s
	09	1	0	37	0.001s	0.002s
	10	0	0	110	0.001s	0.002s
	11	0	0	26	0.001s	0.002s
	12	1	0	125	0.001s	0.002s
	13	0	0	84	0.001s	0.002s
	14	0	0	67	0.001s	0.002s
	15	1	0	37	0.001s	0.001s
	16	0	0	124	0.001s	0.002s
	17	1	0	127	0.001s	0.002s
	18	0	0	46	0.001s	0.002s
	19	0	0	36	0.001s	0.002s
	20	1	0	25	0.001s	0.002s
	21	0	0	65	0.001s	0.003s
	22	0	0	13	0.001s	0.001s
	23	0	0	24	0.001s	0.002s

Day	Hour	Avg time (sec)
May 27	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
May 28	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
May 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
May 30	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
May 31	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
May 27	00	7,477.00 kB	69,948.00 kB
	01	747.50 kB	56,887.00 kB
	02	951.50 kB	46,251.50 kB
	03	31,071.50 kB	50,375.00 kB
	04	1,069.00 kB	52,450.00 kB
	05	12,181.00 kB	44,790.00 kB
	06	11,017.50 kB	38,269.50 kB
	07	5,601.50 kB	32,147.00 kB
	08	47,117.00 kB	47,117.00 kB
	09	229,222.67 kB	581,134.33 kB
	10	1,191.50 kB	447,102.00 kB
	11	1,042.00 kB	362,359.50 kB
	12	1,041.00 kB	293,685.00 kB
	13	6,440.50 kB	238,722.00 kB
	14	1,559.00 kB	194,024.50 kB
	15	32,789.00 kB	160,796.00 kB
	16	1,271.00 kB	133,090.50 kB
	17	6,643.00 kB	108,753.00 kB
	18	1,035.50 kB	88,622.50 kB
	19	1,281.50 kB	72,007.00 kB
	20	16,165.50 kB	60,059.00 kB
	21	1,458.00 kB	50,255.50 kB
	22	1,182.50 kB	40,950.00 kB
	23	276,163.50 kB	523,267.00 kB
May 28	00	7,432.50 kB	425,224.50 kB
	01	30,075.50 kB	350,216.00 kB
	02	807.00 kB	283,823.50 kB
	03	888.00 kB	230,069.00 kB
	04	939.00 kB	196,298.00 kB
	05	181,626.00 kB	489,269.00 kB
	06	352,238.50 kB	667,482.50 kB
	07	1,738.50 kB	541,015.00 kB
	08	1,009.00 kB	438,442.50 kB
	09	2,878.50 kB	355,516.00 kB
	10	35,147.50 kB	294,763.00 kB
	11	2,048.00 kB	239,179.50 kB
	12	1,498.50 kB	194,018.00 kB
	13	1,273.00 kB	165,614.00 kB
	14	125,152.00 kB	322,146.67 kB
	15	1,255.50 kB	247,850.50 kB
	16	1,396.00 kB	211,534.00 kB
	17	5,971,938.25 kB	7,059,686.50 kB
	18	1,036.00 kB	7,129,990.50 kB
	19	1,318.00 kB	5,775,516.00 kB
	20	1,155.50 kB	4,678,409.00 kB
	21	1,294.00 kB	3,789,740.50 kB
	22	25,183.50 kB	3,074,485.50 kB
	23	1,510.50 kB	2,490,597.50 kB
May 29	00	7,904.00 kB	2,018,838.00 kB
	01	816.50 kB	1,635,505.00 kB
	02	924.50 kB	1,324,927.50 kB
	03	319,621.00 kB	1,133,902.00 kB
	04	304,397.50 kB	976,141.00 kB
	05	23,322.50 kB	793,279.50 kB
	06	32,873.50 kB	650,798.00 kB
	07	1,862.50 kB	527,463.00 kB
	08	4,409,018.50 kB	4,633,235.00 kB
	09	2,180,678.33 kB	7,758,636.00 kB
	10	2,432.00 kB	5,948,685.00 kB
	11	1,435.00 kB	4,818,822.00 kB
	12	3,463,403.00 kB	6,579,310.00 kB
	13	1,106.50 kB	5,329,448.50 kB
	14	30,896.00 kB	4,322,740.00 kB
	15	974.00 kB	3,501,603.50 kB
	16	1,230.50 kB	2,836,530.50 kB
	17	8,816,666.00 kB	8,816,666.00 kB
	18	7,777,019.50 kB	8,714,244.00 kB
	19	1,535.33 kB	7,000,693.33 kB
	20	1,250.00 kB	5,649,877.00 kB
	21	7,350,357.67 kB	8,203,677.33 kB
	22	4,045,402.50 kB	8,315,037.00 kB
	23	8,082,109.40 kB	9,011,947.80 kB
May 30	00	8,818,130.00 kB	9,368,053.33 kB
	01	2,891,070.33 kB	8,353,901.67 kB
	02	4,258,507.00 kB	7,167,610.00 kB
	03	8,556,002.82 kB	8,847,383.73 kB
	04	8,799,057.00 kB	8,985,133.00 kB
	05	891,118.00 kB	7,523,154.00 kB
	06	7,592,479.00 kB	8,692,119.50 kB
	07	11,104.00 kB	7,329,340.00 kB
	08	2,309.67 kB	5,645,688.00 kB
	09	12,993.00 kB	4,557,582.00 kB
	10	79,980.00 kB	3,911,874.00 kB
	11	54,598.67 kB	3,027,581.67 kB
	12	1,116.00 kB	2,321,525.00 kB
	13	1,281.00 kB	1,979,596.00 kB
	14	5,769.33 kB	1,610,866.33 kB
	15	1,536.50 kB	1,235,340.00 kB
	16	1,482.00 kB	1,000,903.50 kB
	17	1,045.00 kB	810,944.50 kB
	18	1,416.50 kB	657,124.00 kB
	19	1,800.50 kB	532,575.50 kB
	20	1,508.50 kB	431,691.00 kB
	21	1,578.00 kB	368,307.00 kB
	22	192,067.67 kB	517,385.00 kB
	23	1,771.00 kB	417,877.00 kB
May 31	00	197,460.33 kB	516,462.33 kB
	01	897.50 kB	396,733.50 kB
	02	994.50 kB	321,544.50 kB
	03	941.00 kB	260,632.00 kB
	04	2,719.00 kB	222,537.00 kB
	05	421,801.00 kB	590,725.50 kB
	06	30,778.33 kB	471,951.00 kB
	07	3,050.50 kB	363,692.00 kB
	08	276,038.00 kB	523,702.00 kB
	09	1,061.50 kB	424,389.50 kB
	10	1,593.50 kB	344,035.50 kB
	11	868.50 kB	278,869.00 kB
	12	9,840.50 kB	227,721.50 kB
	13	1,469.00 kB	184,742.00 kB
	14	1,350.50 kB	149,900.00 kB
	15	1,925.00 kB	128,063.00 kB
	16	1,617.50 kB	109,731.00 kB
	17	10,942.00 kB	90,121.50 kB
	18	1,471.00 kB	74,126.50 kB
	19	1,684.50 kB	60,341.00 kB
	20	1,445.50 kB	49,175.50 kB
	21	1,963.00 kB	38,332.33 kB
	22	1,558.00 kB	31,235.00 kB
	23	1,529.50 kB	26,931.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (230) Main checkpoint cause
272 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	230
wal	42
Total	272

Size of temporary files

Key values

15.00 GiB Temp Files size Peak
2024-05-29 20:50:56 Date

Number of temporary files

Key values

18 per second Temp Files Peak
2024-05-30 03:19:19 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
May 27	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0
May 28	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	6	5.82 GiB	993.56 MiB
	15	0	0	0
	16	240	2.14 GiB	9.11 MiB
	17	566	22.61 GiB	40.90 MiB
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0
May 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	202	17.69 GiB	89.69 MiB
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	115	5.11 GiB	45.54 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	25	24.05 GiB	985.17 MiB
	20	117	114.24 GiB	999.81 MiB
	21	260	102.41 GiB	403.32 MiB
	22	175	15.77 GiB	92.27 MiB
	23	166	30.62 GiB	188.92 MiB
May 30	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	978	150.01 GiB	157.06 MiB
	04	0	0	0
	05	0	0	0
	06	8	7.78 GiB	996.28 MiB
	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	40	39.66 GiB	1015.23 MiB
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0
May 31	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	1,193	66.07 GiB	8.00 KiB	1.00 GiB	56.71 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-05-29 21:01:40 Duration: 6m27s 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-05-29 21:29:17 Duration: 5m23s 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-05-28 17:05:46 Duration: 3m48s
2	896	147.35 GiB	128.00 KiB	1.00 GiB	168.40 MiB	vacuum full analyze; VACUUM FULL ANALYZE; Date: 2024-05-30 03:58:57 Duration: 46m7s VACUUM FULL ANALYZE; Date: 2024-05-30 03:20:22 Duration: 0ms
3	65	64.04 GiB	37.40 MiB	1.00 GiB	1008.82 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-05-29 20:50:55 Duration: 0ms
4	62	1.97 GiB	6.77 MiB	1.00 GiB	32.54 MiB	cluster pub1.term; CLUSTER pub1.TERM; Date: 2024-05-30 03:12:12 Duration: 1m CLUSTER pub1.TERM; Date: 2024-05-30 03:11:22 Duration: 0ms
5	46	45.12 GiB	120.14 MiB	1.00 GiB	1004.35 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-05-29 20:11:02 Duration: 0ms
6	35	3.46 GiB	52.74 MiB	133.49 MiB	101.32 MiB	vacuum full analyze db_link; vacuum FULL analyze db_link; Date: 2024-05-29 12:16:47 Duration: 1m32s vacuum FULL analyze db_link; Date: 2024-05-29 12:15:32 Duration: 0ms
7	35	1.09 GiB	23.73 MiB	47.56 MiB	31.93 MiB	vacuum full analyze ixn_actor; vacuum FULL analyze ixn_actor; Date: 2024-05-29 12:14:38 Duration: 22s790ms vacuum FULL analyze ixn_actor; Date: 2024-05-29 12:14:21 Duration: 0ms
8	25	358.81 MiB	10.45 MiB	18.96 MiB	14.35 MiB	vacuum full analyze ixn; vacuum FULL analyze ixn; Date: 2024-05-29 12:14:57 Duration: 7s356ms vacuum FULL analyze ixn; Date: 2024-05-29 12:14:52 Duration: 0ms
9	25	15.57 GiB	8.00 KiB	1.00 GiB	637.91 MiB	alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id); ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id); Date: 2024-05-29 23:32:10 Duration: 2m52s ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id); Date: 2024-05-29 23:32:09 Duration: 0ms
10	25	24.05 GiB	53.20 MiB	1.00 GiB	985.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 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-05-29 19:28:32 Duration: 0ms
11	20	12.18 GiB	8.00 KiB	1.00 GiB	623.85 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-05-29 21:05:51 Duration: 3m 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-05-29 21:05:50 Duration: 0ms Database: ctdprd51 User: pub1
12	20	214.87 MiB	6.12 MiB	17.12 MiB	10.74 MiB	vacuum full analyze term; vacuum FULL analyze TERM; Date: 2024-05-29 12:14:51 Duration: 9s546ms vacuum FULL analyze TERM; Date: 2024-05-29 12:14:43 Duration: 0ms Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:6440632
13	20	700.86 MiB	20.55 MiB	57.66 MiB	35.04 MiB	cluster pub1.term_label; CLUSTER pub1.TERM_LABEL; Date: 2024-05-30 03:12:48 Duration: 35s328ms CLUSTER pub1.TERM_LABEL; Date: 2024-05-30 03:12:18 Duration: 0ms
14	15	6.77 GiB	8.00 KiB	1.00 GiB	462.11 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-05-29 21:19:50 Duration: 1m4s ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id); Date: 2024-05-29 21:19:50 Duration: 0ms
15	15	11.12 GiB	202.72 MiB	1.00 GiB	759.41 MiB	create index ix_term_enrich_agent_enr_term on pub1.term_enrichment_agent using btree (enriched_term_id); CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id); Date: 2024-05-29 23:29:17 Duration: 1m45s CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id); Date: 2024-05-29 23:29:17 Duration: 0ms
16	10	6.77 GiB	300.84 MiB	1.00 GiB	693.16 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-05-29 21:09:05 Duration: 1m26s CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id); Date: 2024-05-29 21:09:05 Duration: 0ms
17	10	6.77 GiB	322.07 MiB	1.00 GiB	693.16 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-05-29 21:18:45 Duration: 2m23s CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score); Date: 2024-05-29 21:18:45 Duration: 0ms
18	10	62.48 MiB	8.00 KiB	13.04 MiB	6.25 MiB	alter table pub1.phenotype_term add constraint phenotype_term_pk primary key (phenotype_id, term_id); ALTER TABLE pub1.phenotype_term ADD CONSTRAINT phenotype_term_pk PRIMARY KEY (phenotype_id, term_id); Date: 2024-05-29 23:46:21 Duration: 0ms
19	10	239.68 MiB	8.00 KiB	49.95 MiB	23.97 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-05-29 21:21:52 Duration: 2s478ms ALTER TABLE pub1.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id); Date: 2024-05-29 21:21:52 Duration: 0ms
20	10	6.77 GiB	297.42 MiB	1.00 GiB	693.16 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-05-29 21:16:21 Duration: 1m21s CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm); Date: 2024-05-29 21:16:21 Duration: 0ms
21	10	6.77 GiB	276.34 MiB	1.00 GiB	693.16 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-05-29 21:06:40 Duration: 49s127ms CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id); Date: 2024-05-29 21:06:40 Duration: 0ms
22	10	436.70 MiB	8.00 KiB	89.99 MiB	43.67 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-05-29 21:21:59 Duration: 6s675ms 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-05-29 21:21:59 Duration: 0ms
23	10	6.77 GiB	298.69 MiB	1.00 GiB	693.16 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-05-29 21:15:00 Duration: 1m22s CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id); Date: 2024-05-29 21:14:59 Duration: 0ms
24	10	6.77 GiB	285.03 MiB	1.00 GiB	693.16 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-05-29 21:10:29 Duration: 1m23s CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id); Date: 2024-05-29 21:10:29 Duration: 0ms
25	10	6.77 GiB	174.77 MiB	1.00 GiB	693.16 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-05-29 21:07:39 Duration: 58s495ms CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd); Date: 2024-05-29 21:07:38 Duration: 0ms
26	10	155.76 MiB	8.00 KiB	33.75 MiB	15.58 MiB	alter table pub1.term_enrichment add constraint term_enrichment_pk primary key (term_id, enriched_term_id); ALTER TABLE pub1.term_enrichment ADD CONSTRAINT term_enrichment_pk PRIMARY KEY (term_id, enriched_term_id); Date: 2024-05-29 23:15:15 Duration: 1s990ms ALTER TABLE pub1.term_enrichment ADD CONSTRAINT term_enrichment_pk PRIMARY KEY (term_id, enriched_term_id); Date: 2024-05-29 23:15:15 Duration: 0ms
27	10	6.77 GiB	278.23 MiB	1.00 GiB	693.16 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-05-29 21:13:37 Duration: 1m49s CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id); Date: 2024-05-29 21:13:37 Duration: 0ms
28	10	6.77 GiB	326.88 MiB	1.00 GiB	693.16 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-05-29 21:11:48 Duration: 1m18s CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id); Date: 2024-05-29 21:11:47 Duration: 0ms
29	10	624.20 MiB	8.00 KiB	126.51 MiB	62.42 MiB	alter table pub1.gene_disease add constraint gene_disease_pk primary key (gene_id, disease_id); ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id); Date: 2024-05-29 23:46:19 Duration: 7s116ms ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id); Date: 2024-05-29 23:46:18 Duration: 0ms
30	10	1001.67 MiB	8.00 KiB	207.09 MiB	100.17 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-05-29 21:21:50 Duration: 10s752ms ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id); Date: 2024-05-29 21:21:49 Duration: 0ms
31	8	63.19 MiB	8.00 KiB	16.02 MiB	7.90 MiB	alter table pub1.chem_disease add constraint chem_disease_pk primary key (chem_id, disease_id); ALTER TABLE pub1.chem_disease ADD CONSTRAINT chem_disease_pk PRIMARY KEY (chem_id, disease_id); Date: 2024-05-29 23:46:24 Duration: 0ms
32	8	7.78 GiB	802.20 MiB	1.00 GiB	996.28 MiB	select pub1.maint_cached_value_refresh_data_metrics (); select pub1.maint_cached_value_refresh_data_metrics (); Date: 2024-05-30 06:38:45 Duration: 33m23s select pub1.maint_cached_value_refresh_data_metrics (); Date: 2024-05-30 06:34:36 Duration: 0ms
33	6	5.82 GiB	841.38 MiB	1.00 GiB	993.56 MiB	select distinct ; select distinct ; Date: 2024-05-28 14:32:59 Duration: 0ms
34	6	5.08 GiB	83.89 MiB	1.00 GiB	867.32 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-05-29 20:54:22 Duration: 0ms
35	5	1001.63 MiB	194.12 MiB	210.35 MiB	200.33 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-05-29 21:20:19 Duration: 8s517ms CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id); Date: 2024-05-29 21:20:19 Duration: 0ms
36	5	1001.63 MiB	186.32 MiB	208.44 MiB	200.33 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-05-29 21:21:25 Duration: 11s708ms CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id); Date: 2024-05-29 21:21:25 Duration: 0ms
37	5	217.41 MiB	41.73 MiB	44.73 MiB	43.48 MiB	create index ix_term_enrich_raw_p_val on pub1.term_enrichment using btree (raw_p_val); CREATE INDEX ix_term_enrich_raw_p_val ON pub1.term_enrichment USING btree (raw_p_val); Date: 2024-05-29 23:15:13 Duration: 4s802ms CREATE INDEX ix_term_enrich_raw_p_val ON pub1.term_enrichment USING btree (raw_p_val); Date: 2024-05-29 23:15:13 Duration: 0ms
38	5	1001.64 MiB	196.02 MiB	204.42 MiB	200.33 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-05-29 21:20:36 Duration: 7s169ms CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id); Date: 2024-05-29 21:20:36 Duration: 0ms
39	5	624.02 MiB	123.69 MiB	126.41 MiB	124.80 MiB	create index ix_gene_disease_ind_chem_qty on pub1.gene_disease using btree (indirect_chem_qty) where (indirect_chem_qty > ?); CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0); Date: 2024-05-29 23:46:11 Duration: 7s59ms CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0); Date: 2024-05-29 23:46:11 Duration: 0ms
40	5	1001.63 MiB	193.17 MiB	207.95 MiB	200.33 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-05-29 21:21:14 Duration: 10s335ms CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id); Date: 2024-05-29 21:21:14 Duration: 0ms
41	5	239.64 MiB	47.01 MiB	48.77 MiB	47.93 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-05-29 21:22:07 Duration: 1s948ms CREATE INDEX ix_chem_disease_ref_source_cd ON pub1.chem_disease_reference USING btree (source_cd); Date: 2024-05-29 21:22:07 Duration: 0ms
42	5	155.71 MiB	30.23 MiB	32.38 MiB	31.14 MiB	create index ix_term_enrich_obj_type on pub1.term_enrichment using btree (object_type_id); CREATE INDEX ix_term_enrich_obj_type ON pub1.term_enrichment USING btree (object_type_id); Date: 2024-05-29 23:15:01 Duration: 1s304ms CREATE INDEX ix_term_enrich_obj_type ON pub1.term_enrichment USING btree (object_type_id); Date: 2024-05-29 23:15:01 Duration: 0ms Database: ctdprd51 User: pub1
43	5	239.63 MiB	45.38 MiB	49.62 MiB	47.93 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-05-29 21:22:14 Duration: 2s835ms CREATE INDEX ix_chem_disease_reference_ixn ON pub1.chem_disease_reference USING btree (ixn_id); Date: 2024-05-29 21:22:14 Duration: 0ms
44	5	62.45 MiB	9.55 MiB	14.55 MiB	12.49 MiB	create index ix_phenotype_term_term_id on pub1.phenotype_term using btree (term_id); CREATE INDEX ix_phenotype_term_term_id ON pub1.phenotype_term USING btree (term_id); Date: 2024-05-29 23:46:20 Duration: 0ms
45	5	239.64 MiB	46.64 MiB	50.81 MiB	47.93 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-05-29 21:22:05 Duration: 2s866ms CREATE INDEX ix_chem_disease_reference_ref ON pub1.chem_disease_reference USING btree (reference_id); Date: 2024-05-29 21:22:05 Duration: 0ms
46	5	1001.64 MiB	192.80 MiB	204.91 MiB	200.33 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-05-29 21:20:53 Duration: 7s373ms CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id); Date: 2024-05-29 21:20:53 Duration: 0ms
47	5	239.63 MiB	43.46 MiB	50.79 MiB	47.93 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-05-29 21:22:22 Duration: 5s122ms CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score); Date: 2024-05-29 21:22:22 Duration: 0ms
48	5	40.00 KiB	8.00 KiB	8.00 KiB	8.00 KiB	create index ix_gene_disease_exp_ref_qty on pub1.gene_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?); CREATE INDEX ix_gene_disease_exp_ref_qty ON pub1.gene_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0); Date: 2024-05-29 23:46:12 Duration: 0ms
49	5	217.43 MiB	39.38 MiB	46.75 MiB	43.49 MiB	create index ix_term_enrich_corr_p_val on pub1.term_enrichment using btree (corrected_p_val); CREATE INDEX ix_term_enrich_corr_p_val ON pub1.term_enrichment USING btree (corrected_p_val); Date: 2024-05-29 23:15:08 Duration: 4s663ms CREATE INDEX ix_term_enrich_corr_p_val ON pub1.term_enrichment USING btree (corrected_p_val); Date: 2024-05-29 23:15:08 Duration: 0ms
50	5	62.44 MiB	10.91 MiB	13.57 MiB	12.49 MiB	create index ix_phenotype_term_phenotype_id on pub1.phenotype_term using btree (phenotype_id); CREATE INDEX ix_phenotype_term_phenotype_id ON pub1.phenotype_term USING btree (phenotype_id); Date: 2024-05-29 23:46:20 Duration: 0ms
51	5	155.72 MiB	27.27 MiB	33.35 MiB	31.14 MiB	create index ix_term_enrich_tgt_match on pub1.term_enrichment using btree (target_match_qty); CREATE INDEX ix_term_enrich_tgt_match ON pub1.term_enrichment USING btree (target_match_qty); Date: 2024-05-29 23:15:02 Duration: 1s860ms CREATE INDEX ix_term_enrich_tgt_match ON pub1.term_enrichment USING btree (target_match_qty); Date: 2024-05-29 23:15:02 Duration: 0ms
52	5	1001.63 MiB	197.06 MiB	202.52 MiB	200.33 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-05-29 21:20:45 Duration: 8s890ms CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd); Date: 2024-05-29 21:20:45 Duration: 0ms
53	5	1001.64 MiB	193.22 MiB	209.36 MiB	200.33 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-05-29 21:21:03 Duration: 10s566ms CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id); Date: 2024-05-29 21:21:03 Duration: 0ms
54	5	624.16 MiB	121.12 MiB	130.45 MiB	124.83 MiB	create index ix_gene_disease_disease on pub1.gene_disease using btree (disease_id); CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id); Date: 2024-05-29 23:46:03 Duration: 6s882ms CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id); Date: 2024-05-29 23:46:03 Duration: 0ms
55	5	1.37 GiB	260.72 MiB	300.95 MiB	281.14 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-05-29 21:21:39 Duration: 13s805ms 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-05-29 21:21:39 Duration: 0ms
56	5	1001.64 MiB	182.41 MiB	212.80 MiB	200.33 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-05-29 21:20:29 Duration: 10s637ms CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id); Date: 2024-05-29 21:20:29 Duration: 0ms
57	5	1001.63 MiB	172.98 MiB	215.42 MiB	200.33 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-05-29 21:20:10 Duration: 9s642ms CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id); Date: 2024-05-29 21:20:10 Duration: 0ms
58	5	155.72 MiB	28.72 MiB	32.93 MiB	31.14 MiB	create index ix_term_enrich_enr_obj_type on pub1.term_enrichment using btree (enriched_object_type_id); CREATE INDEX ix_term_enrich_enr_obj_type ON pub1.term_enrichment USING btree (enriched_object_type_id); Date: 2024-05-29 23:15:04 Duration: 1s152ms CREATE INDEX ix_term_enrich_enr_obj_type ON pub1.term_enrichment USING btree (enriched_object_type_id); Date: 2024-05-29 23:15:04 Duration: 0ms
59	5	239.63 MiB	43.34 MiB	50.90 MiB	47.93 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-05-29 21:22:11 Duration: 2s734ms CREATE INDEX ix_chem_disease_reference_gene ON pub1.chem_disease_reference USING btree (via_gene_id); Date: 2024-05-29 21:22:11 Duration: 0ms
60	5	688.00 KiB	128.00 KiB	144.00 KiB	137.60 KiB	create index ix_gene_disease_cur_ref_qty on pub1.gene_disease using btree (curated_reference_qty) where (curated_reference_qty > ?); CREATE INDEX ix_gene_disease_cur_ref_qty ON pub1.gene_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0); Date: 2024-05-29 23:46:04 Duration: 0ms
61	5	239.63 MiB	45.50 MiB	50.15 MiB	47.93 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-05-29 21:22:02 Duration: 2s748ms CREATE INDEX ix_chem_disease_reference_dis ON pub1.chem_disease_reference USING btree (disease_id); Date: 2024-05-29 21:22:02 Duration: 0ms
62	5	239.64 MiB	46.24 MiB	49.45 MiB	47.93 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-05-29 21:22:17 Duration: 2s725ms CREATE INDEX ix_chem_disease_ref_mod_tm ON pub1.chem_disease_reference USING btree (mod_tm); Date: 2024-05-29 21:22:17 Duration: 0ms
63	5	1001.63 MiB	185.91 MiB	217.50 MiB	200.33 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-05-29 21:20:00 Duration: 10s235ms CREATE INDEX ixn_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id); Date: 2024-05-29 21:20:00 Duration: 0ms
64	5	624.16 MiB	121.71 MiB	126.78 MiB	124.83 MiB	create index ix_gene_disease_network_score on pub1.gene_disease using btree (network_score); CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score); Date: 2024-05-29 23:45:57 Duration: 14s600ms CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score); Date: 2024-05-29 23:45:56 Duration: 0ms Database: ctdprd51 User: pub1
65	5	239.64 MiB	46.75 MiB	49.25 MiB	47.93 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-05-29 21:22:09 Duration: 1s915ms CREATE INDEX ix_chem_disease_ref_src_db ON pub1.chem_disease_reference USING btree (source_acc_db_id); Date: 2024-05-29 21:22:09 Duration: 0ms
66	4	62.27 MiB	15.05 MiB	15.88 MiB	15.57 MiB	create index ix_chem_disease_ind_gene_qty on pub1.chem_disease using btree (indirect_gene_qty) where (indirect_gene_qty > ?); CREATE INDEX ix_chem_disease_ind_gene_qty ON pub1.chem_disease USING btree (indirect_gene_qty) WHERE (indirect_gene_qty > 0); Date: 2024-05-29 23:46:23 Duration: 0ms
67	4	32.00 KiB	8.00 KiB	8.00 KiB	8.00 KiB	create index ix_chem_disease_exp_ref_qty on pub1.chem_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?); CREATE INDEX ix_chem_disease_exp_ref_qty ON pub1.chem_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0); Date: 2024-05-29 23:46:23 Duration: 0ms
68	4	63.15 MiB	13.29 MiB	17.63 MiB	15.79 MiB	create index ix_chem_disease_network_score on pub1.chem_disease using btree (network_score); CREATE INDEX ix_chem_disease_network_score ON pub1.chem_disease USING btree (network_score); Date: 2024-05-29 23:46:25 Duration: 1s481ms CREATE INDEX ix_chem_disease_network_score ON pub1.chem_disease USING btree (network_score); Date: 2024-05-29 23:46:25 Duration: 0ms
69	4	1.98 MiB	424.00 KiB	544.00 KiB	506.00 KiB	create index ix_chem_disease_cur_ref_qty on pub1.chem_disease using btree (curated_reference_qty) where (curated_reference_qty > ?); CREATE INDEX ix_chem_disease_cur_ref_qty ON pub1.chem_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0); Date: 2024-05-29 23:46:22 Duration: 0ms
70	4	13.08 MiB	8.00 KiB	7.38 MiB	3.27 MiB	alter table pub1.phenotype_term_axn add constraint phenotype_term_axn_pk primary key (phenotype_id, term_id, action_type_nm, action_degree_type_nm); ALTER TABLE pub1.phenotype_term_axn ADD CONSTRAINT phenotype_term_axn_pk PRIMARY KEY (phenotype_id, term_id, action_type_nm, action_degree_type_nm); Date: 2024-05-29 23:46:22 Duration: 0ms
71	4	63.15 MiB	14.26 MiB	18.09 MiB	15.79 MiB	create index ix_chem_disease_disease on pub1.chem_disease using btree (disease_id); CREATE INDEX ix_chem_disease_disease ON pub1.chem_disease USING btree (disease_id); Date: 2024-05-29 23:46:26 Duration: 0ms
72	2	5.92 MiB	2.47 MiB	3.45 MiB	2.96 MiB	create index ix_phenotype_term_axn_term_id on pub1.phenotype_term_axn using btree (term_id); CREATE INDEX ix_phenotype_term_axn_term_id ON pub1.phenotype_term_axn USING btree (term_id); Date: 2024-05-29 23:46:22 Duration: 0ms
73	2	5.93 MiB	2.87 MiB	3.06 MiB	2.96 MiB	create index ix_phenotype_term_axn_phenotype_id on pub1.phenotype_term_axn using btree (phenotype_id); CREATE INDEX ix_phenotype_term_axn_phenotype_id ON pub1.phenotype_term_axn USING btree (phenotype_id); Date: 2024-05-29 23:46:22 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	1.00 GiB	select distinct ; [ Date: 2024-05-28 14:32:59 ]
2	1.00 GiB	select distinct ; [ Date: 2024-05-28 14:32:59 ]
3	1.00 GiB	select distinct ; [ Date: 2024-05-28 14:32:59 ]
4	1.00 GiB	select distinct ; [ Date: 2024-05-28 14:32:59 ]
5	1.00 GiB	select distinct ; [ Date: 2024-05-28 14:32:59 ]
6	1.00 GiB	SELECT * FROM pgbulkload.pg_bulkload ($1); [ Date: 2024-05-29 08:13:34 - Database: ctdprd51 - User: load - Application: pg_bulkload ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]
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-05-29 19:28:32 ]

Vacuums / Analyzes Distribution

Key values

253.49 sec Highest CPU-cost vacuum
Table pub1.gene_disease
Database ctdprd51
2024-05-30 00:20:52 Date
0 sec Highest CPU-cost analyze
Table
Database ctdprd51
Date

Average Autovacuum Duration

Key values

253.49 sec Highest CPU-cost vacuum
Table pub1.gene_disease
Database ctdprd51
2024-05-30 00:20:52 Date

Analyzes per table

Key values

pubc.log_query (135) Main table analyzed (database ctdprd51)
240 analyzes Total

Chart
Table

Table	Number of analyzes
ctdprd51.pubc.log_query	135
ctdprd51.pg_catalog.pg_class	5
ctdprd51.pub1.term_set_enrichment	4
ctdprd51.pub1.term	4
ctdprd51.pg_catalog.pg_attribute	4
ctdprd51.pub1.reference	3
ctdprd51.pub1.db	2
ctdprd51.pub1.term_set_enrichment_agent	2
ctdprd51.pub2.term_comp_agent	2
ctdprd51.pg_catalog.pg_depend	2
postgres.pg_catalog.pg_shdepend	2
ctdprd51.pub2.term_set_enrichment_agent	2
ctdprd51.pg_catalog.pg_index	2
ctdprd51.pg_catalog.pg_type	2
ctdprd51.pub1.phenotype_term	2
ctdprd51.pub1.term_comp_agent	2
ctdprd51.pub1.dag_node	2
ctdprd51.pub1.gene_gene_reference	1
ctdprd51.edit.geographic_region	1
ctdprd51.pub1.exp_anatomy	1
ctdprd51.edit.db_report	1
ctdprd51.pub1.term_comp	1
ctdprd51.edit.list_db_report	1
ctdprd51.edit.db_report_site	1
ctdprd51.pub1.term_label	1
ctdprd51.pg_catalog.pg_shdepend	1
ctdprd51.pub1.reference_party	1
ctdprd51.pg_catalog.pg_proc	1
ctdprd51.edit.db_link	1
ctdprd51.pub2.term_set_enrichment	1
ctdprd51.edit.country	1
ctdprd51.pub1.gene_go_annot	1
ctdprd51.edit.db	1
ctdprd51.pub1.exp_event_project	1
ctdprd51.pub1.list_db_report	1
ctdprd51.pub1.country	1
ctdprd51.pub1.exp_outcome	1
ctdprd51.edit.action_type_path	1
ctdprd51.pub1.exp_receptor_tobacco_use	1
ctdprd51.pub1.gene_chem_ref_gene_form	1
ctdprd51.pub1.term_pathway	1
ctdprd51.pub1.slim_term_mapping	1
ctdprd51.pub1.chem_disease	1
ctdprd51.pub1.gene_gene_ref_throughput	1
ctdprd51.pub1.db_link	1
ctdprd51.pub1.geographic_region	1
ctdprd51.pg_catalog.pg_attrdef	1
ctdprd51.edit.action_type	1
ctdprd51.edit.action_degree	1
ctdprd51.pub1.reference_party_role	1
ctdprd51.pg_catalog.pg_constraint	1
ctdprd51.pub1.img	1
ctdprd51.pub1.ixn	1
ctdprd51.pub1.exp_receptor_race	1
ctdprd51.pub1.exposure	1
ctdprd51.pub1.dag_edge	1
ctdprd51.pub1.exp_event_location	1
ctdprd51.pub1.db_report	1
ctdprd51.pg_catalog.pg_description	1
ctdprd51.pub1.gene_disease	1
ctdprd51.pub1.exp_receptor	1
ctdprd51.pub1.reference_exp	1
ctdprd51.pub1.exp_event	1
ctdprd51.pub1.db_report_site	1
ctdprd51.pub1.term_reference	1
ctdprd51.pub1.exp_stressor	1
ctdprd51.pub1.gene_gene	1
ctdprd51.pub1.exp_event_assay_method	1
ctdprd51.pub1.exp_stressor_stressor_src	1
ctdprd51.load.data_load	1
ctdprd51.edit.slim_term	1
ctdprd51.pub1.medium	1
ctdprd51.pub1.action_type	1
ctdprd51.pg_catalog.pg_trigger	1
ctdprd51.edit.object_note	1
ctdprd51.pub1.exp_study_factor	1
ctdprd51.pub1.exp_receptor_gender	1
ctdprd51.pub1.gene_taxon	1
ctdprd51.edit.reference_db_link	1
ctdprd51.edit.term_label_type	1
Total	240

Vacuums per table

Key values

pubc.log_query (37) Main table vacuumed on database ctdprd51
121 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	37	27	36,768	0	7,766	0	3,305	12,828	1,902	8,266,458
ctdprd51.pg_catalog.pg_statistic	6	6	3,727	0	552	0	118	1,971	465	2,118,912
ctdprd51.pub1.term	5	3	2,188,082	0	282,300	0	188	1,412,001	470,347	1,978,105,841
ctdprd51.pg_toast.pg_toast_2619	4	4	17,355	0	5,195	0	40,622	14,025	3,482	2,084,407
ctdprd51.pub1.phenotype_term	3	2	1,301,029	0	140,852	0	0	750,320	150,879	337,611,084
ctdprd51.pg_catalog.pg_class	3	3	946	0	127	0	0	493	115	545,458
ctdprd51.pub1.reference	3	2	644,820	0	15	0	0	402,812	50,138	219,964,807
ctdprd51.pg_catalog.pg_attribute	2	2	1,218	0	135	0	139	524	103	431,803
ctdprd51.pub1.dag_node	2	1	399,804	0	583	0	0	312,993	573	94,253,943
ctdprd51.pub1.term_label	2	0	533,545	0	6	0	0	88,926	4	5,276,683
ctdprd51.pub2.term_comp_agent	2	0	460	0	157	0	0	149	4	34,029
ctdprd51.pub1.term_set_enrichment_agent	2	0	12,186	0	525	0	0	6,058	2	374,260
ctdprd51.pub1.term_set_enrichment	2	0	884	0	113	0	0	350	3	43,144
ctdprd51.pub1.exp_outcome	1	0	559	0	3	0	0	221	1	21,458
ctdprd51.pub1.exp_event_project	1	0	2,018	0	4	0	0	987	2	72,116
ctdprd51.pub1.exp_stressor_stressor_src	1	0	2,557	0	5	0	0	1,250	2	86,861
ctdprd51.pub1.gene_go_annot	1	0	506,895	0	253,350	0	0	253,339	9	15,017,671
ctdprd51.pub1.exp_event_assay_method	1	0	4,763	0	4	0	0	2,336	2	150,447
ctdprd51.pub1.gene_gene	1	0	11,761	0	5	0	0	5,853	2	358,794
ctdprd51.pub1.exp_stressor	1	0	5,974	0	3	0	0	2,957	1	182,882
ctdprd51.pub1.term_pathway	1	0	3,331	0	4	0	0	1,614	2	108,881
ctdprd51.pub1.gene_chem_ref_gene_form	1	0	31,501	0	5	0	0	15,700	2	940,491
ctdprd51.pg_catalog.pg_depend	1	1	647	0	88	0	65	308	94	400,694
ctdprd51.pg_catalog.pg_trigger	1	1	374	0	43	0	0	152	41	215,333
ctdprd51.pub1.exp_receptor_tobacco_use	1	0	1,180	0	3	0	0	555	1	41,164
ctdprd51.pub1.db_link	1	0	229,800	0	70,857	0	0	114,781	4	6,805,089
ctdprd51.pub1.exp_receptor_gender	1	0	2,658	0	3	0	0	1,314	1	85,945
ctdprd51.pub1.gene_gene_ref_throughput	1	0	14,266	0	3	0	0	7,093	1	426,906
ctdprd51.pg_toast.pg_toast_486223	1	0	39	0	4	0	0	7	1	8,739
ctdprd51.pub1.term_comp_agent	1	0	175	0	4	0	0	35	2	16,140
ctdprd51.pub1.chem_disease	1	1	261,093	0	9,541	0	0	159,637	9,530	115,415,433
ctdprd51.pub1.exp_study_factor	1	0	79	0	15	0	0	11	2	13,760
ctdprd51.pub1.slim_term_mapping	1	0	634	0	4	0	0	262	2	28,741
ctdprd51.pg_catalog.pg_index	1	1	191	0	22	0	0	113	21	76,528
ctdprd51.pub1.exp_receptor_race	1	0	1,324	0	3	0	0	627	1	45,412
ctdprd51.pub1.img	1	0	1,108	0	5	0	0	524	2	44,207
ctdprd51.pub1.ixn	1	1	1,426,302	0	83	0	0	951,684	17	65,354,915
ctdprd51.edit.reference_db_link	1	0	7,186	0	4	0	0	3,580	1	219,546
ctdprd51.pg_catalog.pg_constraint	1	1	289	0	27	0	0	126	22	87,572
ctdprd51.pg_toast.pg_toast_5273228	1	1	90	0	3	0	0	49	1	11,558
ctdprd51.pub1.gene_taxon	1	0	134,765	0	5	0	0	67,325	3	3,996,988
ctdprd51.pub1.reference_party_role	1	0	13,214	0	4	0	0	6,568	1	395,931
ctdprd51.pub2.term_set_enrichment_agent	1	0	347,058	0	306,355	0	0	326,615	12	19,362,166
ctdprd51.pub1.exp_event_location	1	0	3,399	0	3	0	0	1,648	1	105,651
ctdprd51.pub1.dag_edge	1	0	1,025	0	5	0	0	482	2	39,733
ctdprd51.pub1.exposure	1	0	3,623	0	3	0	0	1,758	1	112,141
ctdprd51.pg_catalog.pg_type	1	1	73	0	46	0	0	71	35	169,038
ctdprd51.edit.db_report	1	1	117	0	3	0	0	14	2	14,288
ctdprd51.pub1.exp_anatomy	1	0	123	0	3	0	0	33	1	10,366
ctdprd51.pub1.gene_gene_reference	1	0	29,697	0	3	0	0	14,789	1	880,970
ctdprd51.pg_catalog.pg_shdepend	1	1	210	0	13	0	0	103	15	52,258
ctdprd51.pub1.db	1	1	146	0	3	0	0	17	1	11,378
ctdprd51.pub1.gene_disease	1	1	2,812,789	0	780,237	0	0	1,578,282	727,597	2,010,443,986
ctdprd51.pub1.term_reference	1	0	36,165	0	4	0	0	18,028	1	1,072,071
ctdprd51.pg_toast.pg_toast_5273297	1	0	86,875	0	4	0	0	43,309	2	2,571,754
ctdprd51.pub2.term_set_enrichment	1	0	11,808	0	5,517	0	0	5,849	2	358,626
ctdprd51.edit.db_link	1	0	7,397	0	3	0	0	3,580	1	219,615
ctdprd51.pub1.reference_exp	1	0	324	0	4	0	0	125	2	22,438
ctdprd51.pub1.exp_event	1	0	12,274	0	3	0	0	6,059	1	365,900
ctdprd51.pub1.reference_party	1	0	5,092	0	4	0	0	2,495	2	162,600
ctdprd51.pub1.exp_receptor	1	0	7,239	0	3	0	0	3,591	1	220,288
Total	121	62	11,171,031	479,723	1,864,646	0	44,437	6,609,306	1,415,468	4,895,936,298

Tuples removed per table

Key values

pub1.gene_disease (32658852) Main table with removed tuples on database ctdprd51
62085061 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
ctdprd51.pub1.gene_disease	1	1	32,658,852	32,658,852	0	0	480,278
ctdprd51.pub1.phenotype_term	3	2	19,626,212	26,159,512	16,359,562	0	427,905
ctdprd51.pub1.term	5	3	4,601,797	8,419,075	0	0	594,136
ctdprd51.pub1.chem_disease	1	1	3,303,655	3,303,655	0	0	48,534
ctdprd51.pub1.dag_node	2	1	1,709,773	3,405,114	0	0	123,140
ctdprd51.pub1.reference	3	2	67,806	588,958	0	0	199,924
ctdprd51.pub1.ixn	1	1	53,365	2,209,849	0	0	522,092
ctdprd51.pubc.log_query	37	27	38,113	309,440	38,491	0	16,613
ctdprd51.pg_toast.pg_toast_2619	4	4	16,492	82,632	248	0	50,368
ctdprd51.pg_catalog.pg_attribute	2	2	2,808	18,345	0	85	364
ctdprd51.pg_catalog.pg_statistic	6	6	2,594	12,230	55	0	1,740
ctdprd51.pg_catalog.pg_depend	1	1	1,456	13,666	0	0	145
ctdprd51.pg_catalog.pg_shdepend	1	1	627	2,056	0	3	21
ctdprd51.pg_catalog.pg_index	1	1	354	1,153	0	0	41
ctdprd51.pg_catalog.pg_class	3	3	321	5,331	0	0	183
ctdprd51.pg_catalog.pg_constraint	1	1	242	874	0	9	35
ctdprd51.pg_catalog.pg_type	1	1	174	1,151	0	0	35
ctdprd51.pub1.db	1	1	130	130	0	0	6
ctdprd51.pg_catalog.pg_trigger	1	1	129	1,785	0	12	45
ctdprd51.edit.db_report	1	1	91	158	0	0	4
ctdprd51.pg_toast.pg_toast_5273228	1	1	70	69	0	0	21
ctdprd51.pub1.exp_outcome	1	0	0	11,800	0	0	220
ctdprd51.pub1.exp_event_project	1	0	0	94,511	0	0	986
ctdprd51.pub1.exp_stressor_stressor_src	1	0	0	282,121	0	0	1,249
ctdprd51.pub1.gene_go_annot	1	0	0	39,776,068	0	0	253,338
ctdprd51.pub1.exp_event_assay_method	1	0	0	234,296	0	0	2,335
ctdprd51.pub1.gene_gene	1	0	0	1,082,610	0	0	5,852
ctdprd51.pub1.exp_stressor	1	0	0	206,602	0	0	2,956
ctdprd51.pub1.term_pathway	1	0	0	135,792	0	0	1,613
ctdprd51.pub1.gene_chem_ref_gene_form	1	0	0	2,898,239	0	0	15,699
ctdprd51.pub1.exp_receptor_tobacco_use	1	0	0	78,595	0	0	554
ctdprd51.pub1.db_link	1	0	0	15,915,293	0	0	114,780
ctdprd51.pub1.exp_receptor_gender	1	0	0	187,167	0	0	1,313
ctdprd51.pub1.gene_gene_ref_throughput	1	0	0	1,363,981	0	0	7,092
ctdprd51.pg_toast.pg_toast_486223	1	0	0	24	0	0	6
ctdprd51.pub1.term_comp_agent	1	0	0	4,466	0	0	43
ctdprd51.pub1.exp_study_factor	1	0	0	1,613	0	0	10
ctdprd51.pub1.slim_term_mapping	1	0	0	32,795	0	0	261
ctdprd51.pub1.exp_receptor_race	1	0	0	96,500	0	0	626
ctdprd51.pub1.img	1	0	0	50,714	0	0	523
ctdprd51.edit.reference_db_link	1	0	0	321,341	0	0	3,579
ctdprd51.pub1.gene_taxon	1	0	0	10,569,892	0	0	67,324
ctdprd51.pub1.reference_party_role	1	0	0	1,214,752	0	0	6,567
ctdprd51.pub2.term_set_enrichment_agent	1	0	0	146,773,858	0	0	1,667,885
ctdprd51.pub1.exp_event_location	1	0	0	248,044	0	0	1,647
ctdprd51.pub1.dag_edge	1	0	0	88,931	0	0	481
ctdprd51.pub1.exposure	1	0	0	213,457	0	0	1,757
ctdprd51.pub1.exp_anatomy	1	0	0	3,797	0	0	32
ctdprd51.pub1.gene_gene_reference	1	0	0	1,358,371	0	0	14,788
ctdprd51.pub1.term_label	2	0	0	18,135,978	6,045,326	0	266,633
ctdprd51.pub2.term_comp_agent	2	0	0	56,431	0	0	482
ctdprd51.pub1.term_set_enrichment_agent	2	0	0	1,020,119	0	0	11,593
ctdprd51.pub1.term_reference	1	0	0	3,334,856	0	0	18,027
ctdprd51.pg_toast.pg_toast_5273297	1	0	0	234,872	0	0	43,429
ctdprd51.pub2.term_set_enrichment	1	0	0	1,790,364	0	0	29,655
ctdprd51.edit.db_link	1	0	0	321,341	0	0	3,579
ctdprd51.pub1.term_set_enrichment	2	0	0	35,530	0	0	590
ctdprd51.pub1.reference_exp	1	0	0	3,437	0	0	124
ctdprd51.pub1.exp_event	1	0	0	206,466	0	0	6,058
ctdprd51.pub1.reference_party	1	0	0	446,427	0	0	2,494
ctdprd51.pub1.exp_receptor	1	0	0	189,952	0	0	3,590
Total	121	62	62,085,061	326,215,438	22,443,682	109	5,025,400

Pages removed per table

Key values

pg_catalog.pg_attribute (85) Main table with removed pages on database ctdprd51
109 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
ctdprd51.pg_catalog.pg_attribute	2	2	2808	85
ctdprd51.pg_catalog.pg_trigger	1	1	129	12
ctdprd51.pg_catalog.pg_constraint	1	1	242	9
ctdprd51.pg_catalog.pg_shdepend	1	1	627	3
ctdprd51.pub1.exp_outcome	1	0	0	0
ctdprd51.pub1.exp_event_project	1	0	0	0
ctdprd51.pub1.term	5	3	4601797	0
ctdprd51.pub1.exp_stressor_stressor_src	1	0	0	0
ctdprd51.pub1.gene_go_annot	1	0	0	0
ctdprd51.pub1.exp_event_assay_method	1	0	0	0
ctdprd51.pub1.gene_gene	1	0	0	0
ctdprd51.pub1.exp_stressor	1	0	0	0
ctdprd51.pub1.term_pathway	1	0	0	0
ctdprd51.pub1.gene_chem_ref_gene_form	1	0	0	0
ctdprd51.pg_catalog.pg_depend	1	1	1456	0
ctdprd51.pub1.exp_receptor_tobacco_use	1	0	0	0
ctdprd51.pub1.db_link	1	0	0	0
ctdprd51.pub1.exp_receptor_gender	1	0	0	0
ctdprd51.pub1.gene_gene_ref_throughput	1	0	0	0
ctdprd51.pg_toast.pg_toast_486223	1	0	0	0
ctdprd51.pub1.term_comp_agent	1	0	0	0
ctdprd51.pub1.chem_disease	1	1	3303655	0
ctdprd51.pg_toast.pg_toast_2619	4	4	16492	0
ctdprd51.pub1.exp_study_factor	1	0	0	0
ctdprd51.pub1.slim_term_mapping	1	0	0	0
ctdprd51.pub1.phenotype_term	3	2	19626212	0
ctdprd51.pg_catalog.pg_index	1	1	354	0
ctdprd51.pub1.exp_receptor_race	1	0	0	0
ctdprd51.pub1.img	1	0	0	0
ctdprd51.pub1.ixn	1	1	53365	0
ctdprd51.edit.reference_db_link	1	0	0	0
ctdprd51.pub1.dag_node	2	1	1709773	0
ctdprd51.pg_toast.pg_toast_5273228	1	1	70	0
ctdprd51.pub1.gene_taxon	1	0	0	0
ctdprd51.pub1.reference_party_role	1	0	0	0
ctdprd51.pub2.term_set_enrichment_agent	1	0	0	0
ctdprd51.pg_catalog.pg_statistic	6	6	2594	0
ctdprd51.pub1.exp_event_location	1	0	0	0
ctdprd51.pub1.dag_edge	1	0	0	0
ctdprd51.pub1.exposure	1	0	0	0
ctdprd51.pg_catalog.pg_type	1	1	174	0
ctdprd51.edit.db_report	1	1	91	0
ctdprd51.pub1.exp_anatomy	1	0	0	0
ctdprd51.pub1.gene_gene_reference	1	0	0	0
ctdprd51.pub1.term_label	2	0	0	0
ctdprd51.pubc.log_query	37	27	38113	0
ctdprd51.pub1.db	1	1	130	0
ctdprd51.pub1.gene_disease	1	1	32658852	0
ctdprd51.pg_catalog.pg_class	3	3	321	0
ctdprd51.pub2.term_comp_agent	2	0	0	0
ctdprd51.pub1.term_set_enrichment_agent	2	0	0	0
ctdprd51.pub1.term_reference	1	0	0	0
ctdprd51.pg_toast.pg_toast_5273297	1	0	0	0
ctdprd51.pub1.reference	3	2	67806	0
ctdprd51.pub2.term_set_enrichment	1	0	0	0
ctdprd51.edit.db_link	1	0	0	0
ctdprd51.pub1.term_set_enrichment	2	0	0	0
ctdprd51.pub1.reference_exp	1	0	0	0
ctdprd51.pub1.exp_event	1	0	0	0
ctdprd51.pub1.reference_party	1	0	0	0
ctdprd51.pub1.exp_receptor	1	0	0	0
Total	121	62	62,085,061	109

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	ANALYZEs
May 27	00	3
	01	3
	02	3
	03	3
	04	1
	05	2
	06	2
	07	1
	08	1
	09	1
	10	0
	11	1
	12	1
	13	0
	14	1
	15	1
	16	0
	17	1
	18	0
	19	1
	20	0
	21	1
	22	0
	23	1
May 28	00	4
	01	3
	02	3
	03	2
	04	2
	05	2
	06	1
	07	1
	08	2
	09	1
	10	0
	11	1
	12	1
	13	14
	14	0
	15	1
	16	14
	17	1
	18	0
	19	1
	20	0
	21	1
	22	1
	23	1
May 29	00	3
	01	4
	02	2
	03	3
	04	2
	05	3
	06	1
	07	1
	08	1
	09	0
	10	2
	11	1
	12	4
	13	0
	14	1
	15	0
	16	1
	17	12
	18	8
	19	0
	20	0
	21	1
	22	1
	23	24
May 30	00	10
	01	5
	02	2
	03	6
	04	2
	05	1
	06	5
	07	1
	08	1
	09	2
	10	6
	11	3
	12	1
	13	0
	14	1
	15	0
	16	1
	17	0
	18	1
	19	1
	20	0
	21	0
	22	1
	23	0
May 31	00	4
	01	3
	02	3
	03	2
	04	1
	05	3
	06	1
	07	1
	08	1
	09	1
	10	1
	11	0
	12	1
	13	1
	14	0
	15	1
	16	0
	17	3
	18	0
	19	1
	20	0
	21	1
	22	0
	23	1

↑ Back to the top of the Autovacuum Activity table

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

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	1m7s	1m7s	1m7s	1m7s	select count() from edit.db_link; select count() from edit.db_link; Date: 2024-05-29 12:16:45 select count() from edit.db_link; Date:* 2024-05-29 12:16:45

Rank	Wait time	Query
1	1m7s	select count() from edit.db_link; [ Date:* 2024-05-29 12:16:45 ]

Queries by type

Key values

9,423 Total read queries
326 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	9,423	96.39%
INSERT	31	0.32%
UPDATE	9	0.09%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	195	1.99%
CTE	37	0.38%
DDL	53	0.54%
TCL	1	0.01%
CURSOR	0	0.00%
OTHERS	27	0.28%

Queries by database

Key values

ctdprd51 Main database
5,024 Requests
1d1h6m36s (ctdprd51)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctdprd51	Total	5,024	1d1h6m36s
	copy to	40	15m23s
	cte	21	1m1s
	ddl	1	4s587ms
	insert	2	11m48s
	others	1	2s675ms
	select	4,958	1d38m13s
	tcl	1	1s373ms
unknown	Total	4,752	23h38m4s
	copy to	155	17m57s
	cte	16	23s34ms
	ddl	52	38m22s
	insert	29	41m25s
	others	26	51m59s
	select	4,465	20h36m20s
	update	9	31m35s

Queries by user

Key values

pubeu Main user
8,898 Requests

Queries Chart
Table

User	Request type	Count	Duration
edit	Total	2	2s978ms
	select	2	2s978ms
editeu	Total	4	12s496ms
	select	4	12s496ms
load	Total	64	48m47s
	others	2	5s350ms
	select	62	48m41s
postgres	Total	80	30m43s
	copy to	80	30m43s
pub1	Total	17	24m7s
	ddl	2	9s174ms
	insert	3	23m17s
	select	10	38s666ms
	tcl	2	2s747ms
pub2	Total	2	9s39ms
	select	2	9s39ms
pubeu	Total	8,898	1d18h34m45s
	cte	24	1m4s
	select	8,874	1d18h33m41s
qaeu	Total	106	1h28m47s
	cte	14	47s527ms
	select	92	1h27m59s
unknown	Total	8,851	1d16h20m54s
	copy to	308	35m37s
	cte	26	37s866ms
	ddl	101	1h15m45s
	insert	53	1h18m33s
	others	39	1h41m15s
	select	8,310	1d10h52m9s
	update	14	36m55s

Duration by user

Key values

1d18h34m45s (pubeu) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
edit	Total	2	2s978ms
	select	2	2s978ms
editeu	Total	4	12s496ms
	select	4	12s496ms
load	Total	64	48m47s
	others	2	5s350ms
	select	62	48m41s
postgres	Total	80	30m43s
	copy to	80	30m43s
pub1	Total	17	24m7s
	ddl	2	9s174ms
	insert	3	23m17s
	select	10	38s666ms
	tcl	2	2s747ms
pub2	Total	2	9s39ms
	select	2	9s39ms
pubeu	Total	8,898	1d18h34m45s
	cte	24	1m4s
	select	8,874	1d18h33m41s
qaeu	Total	106	1h28m47s
	cte	14	47s527ms
	select	92	1h27m59s
unknown	Total	8,851	1d16h20m54s
	copy to	308	35m37s
	cte	26	37s866ms
	ddl	101	1h15m45s
	insert	53	1h18m33s
	others	39	1h41m15s
	select	8,310	1d10h52m9s
	update	14	36m55s

Queries by host

Key values

unknown Main host
18,024 Requests
3d14h8m29s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,024	3d14h8m29s
	copy to	388	1h6m20s
	cte	64	2m29s
	ddl	103	1h15m54s
	insert	56	1h41m50s
	others	41	1h41m20s
	select	17,356	3d7h43m35s
	tcl	2	2s747ms
	update	14	36m55s

Queries by application

Key values

unknown Main application
9,706 Requests
2d15m20s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pgAdmin 4 - CONN:9603023	Total	1	1s373ms
	tcl	1	1s373ms
pgAdmin 4 - CONN:9791214	Total	1	1s489ms
	select	1	1s489ms
pg_bulkload	Total	23	13m35s
	select	23	13m35s
pg_dump	Total	40	15m23s
	copy to	40	15m23s
psql	Total	5	18s529ms
	ddl	1	4s587ms
	select	4	13s942ms
unknown	Total	9,706	2d15m20s
	copy to	155	17m57s
	cte	37	1m24s
	ddl	52	38m22s
	insert	31	53m14s
	others	27	52m2s
	select	9,395	1d21h43s
	update	9	31m35s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-05-31 13:54:39 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

6,692 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	6,692	67.24%
> 10000ms	3,261	32.76%

Slowest individual queries

Rank	Duration	Query
1	1h56m	select pub1.maint_term_derive_data (); [ Date: 2024-05-30 05:55:20 - Bind query: yes ]
2	1h35m57s	select pub1.maint_gene_chem_ref_gene_form_refresh (); [ Date: 2024-05-30 01:57:01 - Bind query: yes ]
3	1h7m21s	SELECT maint_term_derive_nm_fts (); [ Date: 2024-05-30 03:07:10 - Bind query: yes ]
4	46m7s	VACUUM FULL ANALYZE; [ Date: 2024-05-30 03:58:57 - Bind query: yes ]
5	39m46s	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-05-29 20:50:52 - Bind query: yes ]
6	38m56s	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-05-29 20:11:00 - Bind query: yes ]
7	34m6s	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-05-29 18:39:35 - Bind query: yes ]
8	33m23s	select pub1.maint_cached_value_refresh_data_metrics (); [ Date: 2024-05-30 06:38:45 - Bind query: yes ]
9	33m14s	SELECT /* AllGDRelationsDAO / g.nm "GeneSymbol", g.acc_txt "GeneID", d.nm "DiseaseName", d.acc_db_cd \|\| ':' \|\| d.acc_txt "DiseaseID", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '\|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '\|' ORDER BY r.acc_txt) "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id GROUP BY g.nm, g.acc_txt, d.nm, d.acc_db_cd \|\| ':' \|\| d.acc_txt, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '\|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY g.nm, d.nm; [ Date:* 2024-05-30 12:04:32 - Database: ctdprd51 - User: qaeu - Bind query: yes ]
10	23m6s	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-05-29 17:57:10 - Bind query: yes ]
11	23m2s	update pub1.GENE_DISEASE gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.GENE_DISEASE_REFERENCE gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.REFERENCE r where has_exposures = true)); [ Date: 2024-05-30 00:15:50 - Bind query: yes ]
12	17m6s	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 = '1232823') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-05-31 06:15:12 - Bind query: yes ]
13	17m6s	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 = '1232823') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50; [ Date: 2024-05-27 11:39:36 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
14	16m10s	/* * 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-05-31 00:16:12 ]
15	16m6s	/* * 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-05-30 00:16:08 ]
16	16m1s	/* * 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-05-29 00:16:03 ]
17	16m	/* * 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-05-27 00:16:02 ]
18	15m56s	/* * 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-05-28 00:15:58 ]
19	12m17s	ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id); [ Date: 2024-05-29 23:27:32 - Bind query: yes ]
20	11m28s	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-05-29 17:28:43 - Database: ctdprd51 - User: pub1 - Bind query: yes ]

Time consuming queries (N)


[ User: pubeu - Total duration: 21h14m28s - Times executed: 2230 ]
Date: 2024-05-30 05:55:20
Duration: 1h56m
Bind query: yes
Date: 2024-05-30 01:57:01
Duration: 1h35m57s
Bind query: yes
[ User: pubeu - Total duration: 39m31s - Times executed: 28 ]
Date: 2024-05-31 00:16:12
Duration: 16m10s
Date: 2024-05-30 03:07:10
Duration: 1h7m21s
Bind query: yes
[ User: pubeu - Total duration: 24m23s - Times executed: 1254 ]
[ User: qaeu - Total duration: 33m14s - Times executed: 1 ]
Date: 2024-05-30 03:58:57
Duration: 46m7s
Bind query: yes
[ User: load - Total duration: 13m35s - Times executed: 23 ]
Date: 2024-05-29 20:50:52
Duration: 39m46s
Bind query: yes
Date: 2024-05-29 20:11:00
Duration: 38m56s
Bind query: yes
Date: 2024-05-29 18:39:35
Duration: 34m6s
Bind query: yes
Date: 2024-05-30 06:38:45
Duration: 33m23s
Bind query: yes
Date: 2024-05-29 17:57:10
Duration: 23m6s
Bind query: yes
Date: 2024-05-30 00:15:50
Duration: 23m2s
Bind query: yes
[ User: pubeu - Total duration: 8m15s - Times executed: 125 ]
[ User: pubeu - Total duration: 6m59s - Times executed: 91 ]
[ User: load - Total duration: 10m22s - Times executed: 1 ]
Date: 2024-05-29 23:27:32
Duration: 12m17s
Bind query: yes

Most frequent queries (N)


[ User: pubeu - Total duration: 21h14m28s - Times executed: 2230 ]
[ User: pubeu - Total duration: 24m23s - Times executed: 1254 ]
[ User: pubeu - Total duration: 5m26s - Times executed: 254 ]
[ User: pubeu - Total duration: 3m51s - Times executed: 181 ]
[ User: pubeu - Total duration: 8m15s - Times executed: 125 ]
[ User: qaeu - Total duration: 33m14s - Times executed: 1 ]
[ User: pubeu - Total duration: 6m59s - Times executed: 91 ]
[ User: pubeu - Total duration: 3m27s - Times executed: 68 ]
[ User: pubeu - Total duration: 2m10s - Times executed: 52 ]
[ User: pubeu - Total duration: 39m31s - Times executed: 28 ]
[ User: load - Total duration: 13m35s - Times executed: 23 ]
[ User: pubeu - Total duration: 6m50s - Times executed: 39 ]
[ User: pubeu - Total duration: 35s582ms - Times executed: 26 ]
[ User: pubeu - Total duration: 49s588ms - Times executed: 16 ]
[ User: pubeu - Total duration: 38s84ms - Times executed: 14 ]
[ User: pubeu - Total duration: 26s791ms - Times executed: 17 ]
[ User: pubeu - Total duration: 48s706ms - Times executed: 16 ]
[ User: pubeu - Total duration: 9s155ms - Times executed: 8 ]
[ User: pubeu - Total duration: 47s458ms - Times executed: 14 ]
[ User: pubeu - Total duration: 31s850ms - Times executed: 13 ]

Normalized slowest queries (N)


Date: 2024-05-30 05:55:20
Duration: 1h56m
Bind query: yes
Date: 2024-05-30 01:57:01
Duration: 1h35m57s
Bind query: yes
Date: 2024-05-30 03:07:10
Duration: 1h7m21s
Bind query: yes
Date: 2024-05-30 03:58:57
Duration: 46m7s
Bind query: yes
Date: 2024-05-29 20:50:52
Duration: 39m46s
Bind query: yes
Date: 2024-05-29 20:11:00
Duration: 38m56s
Bind query: yes
Date: 2024-05-29 18:39:35
Duration: 34m6s
Bind query: yes
Date: 2024-05-30 06:38:45
Duration: 33m23s
Bind query: yes
Date: 2024-05-29 17:57:10
Duration: 23m6s
Bind query: yes
Date: 2024-05-30 00:15:50
Duration: 23m2s
Bind query: yes
Date: 2024-05-31 00:16:12
Duration: 16m10s
Date: 2024-05-29 23:27:32
Duration: 12m17s
Bind query: yes
[ User: pubeu - Total duration: 39m31s - Times executed: 28 ]
[ User: load - Total duration: 10m22s - Times executed: 1 ]
[ User: load - Total duration: 13m35s - Times executed: 23 ]
[ User: pubeu - Total duration: 21h14m28s - Times executed: 2230 ]
[ User: qaeu - Total duration: 33m14s - Times executed: 1 ]
[ User: pubeu - Total duration: 6m50s - Times executed: 39 ]
[ User: pubeu - Total duration: 6m59s - Times executed: 91 ]
[ User: pubeu - Total duration: 47s458ms - Times executed: 14 ]

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

3s525ms

Details

1s762ms

select distinct ptr.phenotype_id, ptr.term_id, i.action_type_nm, i.action_type_cd, i.action_degree_type_nm, i.action_degree_type_cd from pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.IXN_AXN i where ptr.ixn_id = i.ixn_id;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
May 31	19	2	3s525ms	1s762ms

select distinct ptr.phenotype_id, ptr.term_id, i.action_type_nm, i.action_type_cd, i.action_degree_type_nm, i.action_degree_type_cd from pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.IXN_AXN i where ptr.ixn_id = i.ixn_id;

Date: 2024-05-29 23:45:11 Duration: 1s762ms Database: postgres

2s138ms

Details

1s69ms

SELECT /* GeneDiseaseChemsDAO */ ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	18	2	2s138ms	1s69ms

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2024-05-27 23:17:49 Duration: 1s69ms Database: postgres parameters: $1 = '2066403'

0ms

224

Details

0ms

;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
May 26	01	1	0ms	0ms
	03	3	0ms	0ms
	04	4	0ms	0ms
	05	5	0ms	0ms
May 27	20	1	0ms	0ms
	02	6	0ms	0ms
	03	14	0ms	0ms
	04	8	0ms	0ms
	10	8	0ms	0ms
	11	2	0ms	0ms
May 28	01	12	0ms	0ms
	02	16	0ms	0ms
	03	2	0ms	0ms
	05	2	0ms	0ms
	06	6	0ms	0ms
	07	10	0ms	0ms
	08	6	0ms	0ms
	09	4	0ms	0ms
	10	2	0ms	0ms
	11	4	0ms	0ms
	13	2	0ms	0ms
May 29	02	4	0ms	0ms
	03	26	0ms	0ms
	04	10	0ms	0ms
	05	2	0ms	0ms
	06	6	0ms	0ms
	07	2	0ms	0ms
	13	2	0ms	0ms
	14	2	0ms	0ms
May 30	21	1	0ms	0ms
	00	6	0ms	0ms
	01	2	0ms	0ms
	02	8	0ms	0ms
	03	10	0ms	0ms
	07	2	0ms	0ms
May 31	02	4	0ms	0ms
	03	4	0ms	0ms
	06	3	0ms	0ms
	08	2	0ms	0ms
	09	3	0ms	0ms
	10	1	0ms	0ms
	12	3	0ms	0ms
	13	3	0ms	0ms

[ User: pubeu - Total duration: 4m36s - Times executed: 125 ]

[ User: qaeu - Total duration: 7s803ms - Times executed: 2 ]

;

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

Log levels

Key values

107,757 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	19,504	18.10%
DETAIL	9,081	8.43%
ERROR	64	0.06%
FATAL	7	0.01%
HINT	1	0.00%
LOG	75,052	69.65%
STATEMENT	2,751	2.55%
WARNING	1,297	1.20%

Events distribution

Key values

0 PANIC entries
7 FATAL entries
64 ERROR entries
1297 WARNING entries

Most Frequent Errors/Events

Key values

1,024 Max number of times the same event was reported
1,368 Total events found

Rank

Times reported

Error

1,024

Details

WARNING: skipping "..." --- only table or database owner can vacuum it

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
May 30	23	1,024

224

Details

WARNING: skipping "..." --- only superuser or database owner can vacuum it

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 30	23	224

Details

WARNING: skipping "..." --- only superuser can vacuum it

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
May 30	23	43

Details

ERROR: syntax error in ts"..."

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
May 27	09	1
May 28	08	1
	10	1
	13	2
	17	1
	18	1
May 29	21	1
	02	2
	03	1
	05	1
	08	2
	12	1
	15	1
May 30	04	2
	17	1
	19	1
May 31	20	1
	00	1
	02	1
	03	1
	06	1
	07	2
	14	2
	18	1

ERROR: syntax error in ts"エーザイ & ユベラNソフトカプセル200MG　販売"
ERROR: syntax error in ts"NMDZ & THJYXZ< & >DQMMWQ"
ERROR: syntax error in ts"エーザイ & ユベラNソフトカプセル200MG　販売"

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
May 28	15	3
	16	3
May 30	13	4
	15	3

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
May 28	09	4
May 30	07	3
May 31	05	1

Details

WARNING: there is no transaction in progress

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
May 30	23	2
	01	3
	02	1

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
May 27	07	1
May 29	17	1
May 30	07	1
May 31	02	1
	05	1

FATAL: connection to client lost

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
May 27	07	1
May 29	17	1
May 31	02	1
	05	1

ERROR: could not send data to client: Broken pipe

Details

FATAL: canceling authentication due to timeout

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
May 31	05	2

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
May 29	02	2

ERROR: syntax error at or near "," at character 22
ERROR: syntax error at or near "m" at character 1

Details

ERROR: operator does not exist: character varying ~~ record

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
May 30	07	1

ERROR: operator does not exist: character varying ~~ record at character 52

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
May 29	02	1

ERROR: column "9831364" does not exist at character 80

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
May 29	08	1

ERROR: process 385623 still waiting for AccessShareLock on relation 2633821 of database 484829 after 1000.071 ms at character 22

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
May 29	03	1

ERROR: missing FROM-clause entry for table "i" at character 23

Details

ERROR: canceling statement due to user request

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
May 29	17	1

ERROR: canceling statement due to user request

Details

LOG: could not send data to client: Connection reset by peer

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
May 30	07	1

Details

ERROR: zero-length delimited identifier at or near """"

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
May 28	09	1

ERROR: zero-length delimited identifier at or near """" at character 47

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