pgBadger :: pgBadger

Global information

Generated on Sun Aug 12 12:31:16 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 67,025,230 log entries in 1m10s
Log start from 2018-08-05 00:00:00 to 2018-08-11 06:47:06

Global Stats

2,828 Number of unique normalized queries
21,128,340 Number of queries
1h15m43s Total query duration
2018-08-05 00:00:00 First query
2018-08-11 06:47:06 Last query
11,176 queries/s at 2018-08-07 06:06:39 Query peak

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

2,562 Total number of automatic vacuums
3,141 Total number of automatic analyzes

13 Number temporary file
17.98 MiB Max size of temporary file
9.24 MiB Average size of temporary file

11,060 Total number of sessions
3 sessions at 2018-08-06 10:52:51 Session peak
70d7h2m42s Total duration of sessions
9m9s Average duration of sessions
1,910 Average queries per session
410ms Average queries duration per session

11,078 Total number of connections
35 connections/s at 2018-08-10 07:49:45 Connection peak
1 Total number of databases

SQL Traffic

Key values

11,176 queries/s Query Peak
2018-08-07 06:06:39 Date

SELECT Traffic

Key values

2,226 queries/s Query Peak
2018-08-08 10:20:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

11,117 queries/s Query Peak
2018-08-07 06:06:39 Date

Queries duration

Key values

1h15m43s Total query duration

Prepared queries ratio

Key values

2.20 Ratio of bind vs prepare
138.49 % 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)
Aug 05	00	104,401	0ms	17ms	0ms	79ms	91ms	1s687ms
	01	93,694	0ms	14ms	0ms	63ms	75ms	198ms
	02	93,812	0ms	15ms	0ms	61ms	64ms	222ms
	03	93,818	0ms	14ms	0ms	60ms	71ms	200ms
	04	93,702	0ms	31ms	0ms	60ms	74ms	230ms
	05	93,852	0ms	15ms	0ms	61ms	70ms	204ms
	06	93,821	0ms	14ms	0ms	58ms	68ms	174ms
	07	93,669	0ms	21ms	0ms	65ms	76ms	210ms
	08	93,818	0ms	20ms	0ms	63ms	76ms	181ms
	09	93,835	0ms	15ms	0ms	72ms	74ms	196ms
	10	93,740	0ms	15ms	0ms	59ms	77ms	176ms
	11	93,624	0ms	14ms	0ms	65ms	91ms	203ms
	12	93,774	0ms	18ms	0ms	67ms	95ms	196ms
	13	93,774	0ms	16ms	0ms	65ms	89ms	171ms
	14	93,748	0ms	16ms	0ms	65ms	95ms	186ms
	15	93,630	0ms	22ms	0ms	67ms	82ms	211ms
	16	93,793	0ms	28ms	0ms	75ms	89ms	192ms
	17	93,817	0ms	38ms	0ms	64ms	81ms	238ms
	18	94,696	0ms	18ms	0ms	67ms	175ms	224ms
	19	94,820	0ms	15ms	0ms	71ms	86ms	247ms
	20	93,841	0ms	18ms	0ms	71ms	124ms	425ms
	21	93,510	0ms	15ms	0ms	61ms	82ms	182ms
	22	94,342	0ms	22ms	0ms	65ms	103ms	296ms
	23	94,736	0ms	22ms	0ms	69ms	82ms	238ms
Aug 06	00	97,410	0ms	20ms	0ms	63ms	125ms	1s669ms
	01	94,709	0ms	18ms	0ms	62ms	66ms	262ms
	02	94,113	0ms	14ms	0ms	59ms	80ms	239ms
	03	94,317	0ms	19ms	0ms	63ms	91ms	226ms
	04	94,130	0ms	19ms	0ms	63ms	72ms	234ms
	05	93,869	0ms	15ms	0ms	59ms	73ms	219ms
	06	331,284	0ms	5s549ms	0ms	7s416ms	10s402ms	14s465ms
	07	210,603	0ms	312ms	0ms	2s248ms	2s880ms	3s281ms
	08	212,881	0ms	1s496ms	0ms	2s656ms	2s870ms	3s575ms
	09	240,753	0ms	229ms	0ms	2s759ms	3s221ms	5s135ms
	10	270,019	0ms	320ms	0ms	3s844ms	4s566ms	9s399ms
	11	285,371	0ms	4s780ms	0ms	4s995ms	5s805ms	18s429ms
	12	196,107	0ms	841ms	0ms	2s587ms	3s609ms	4s465ms
	13	127,481	0ms	291ms	0ms	1s95ms	1s726ms	2s459ms
	14	146,276	0ms	215ms	0ms	1s105ms	1s906ms	2s842ms
	15	153,134	0ms	267ms	0ms	2s235ms	3s295ms	4s917ms
	16	94,735	0ms	204ms	0ms	127ms	229ms	611ms
	17	122,407	0ms	207ms	0ms	2s4ms	2s469ms	3s386ms
	18	95,406	0ms	73ms	0ms	65ms	86ms	595ms
	19	94,195	0ms	65ms	0ms	54ms	85ms	431ms
	20	96,159	0ms	61ms	0ms	65ms	169ms	734ms
	21	95,310	0ms	62ms	0ms	66ms	195ms	429ms
	22	97,916	0ms	59ms	0ms	67ms	179ms	544ms
	23	97,464	0ms	70ms	0ms	69ms	292ms	483ms
Aug 07	00	98,615	0ms	67ms	0ms	70ms	141ms	1s925ms
	01	96,406	0ms	63ms	0ms	71ms	181ms	454ms
	02	96,012	0ms	34ms	0ms	59ms	106ms	432ms
	03	96,181	0ms	69ms	0ms	63ms	209ms	533ms
	04	95,339	0ms	63ms	0ms	57ms	72ms	495ms
	05	94,506	0ms	62ms	0ms	63ms	110ms	411ms
	06	376,897	0ms	1s469ms	0ms	6s652ms	7s720ms	8s354ms
	07	201,808	0ms	134ms	0ms	2s583ms	2s909ms	3s356ms
	08	253,329	0ms	150ms	0ms	4s16ms	4s379ms	5s199ms
	09	202,116	0ms	296ms	0ms	2s550ms	3s352ms	4s59ms
	10	214,882	0ms	213ms	0ms	4s114ms	4s290ms	5s109ms
	11	227,971	0ms	11s827ms	0ms	3s673ms	5s270ms	1m27s
	12	253,189	0ms	227ms	0ms	4s413ms	5s536ms	6s329ms
	13	243,964	0ms	1s148ms	0ms	3s733ms	4s539ms	5s107ms
	14	178,201	0ms	1s640ms	0ms	2s949ms	3s520ms	5s100ms
	15	150,198	0ms	275ms	0ms	839ms	1s325ms	2s527ms
	16	150,069	0ms	216ms	0ms	1s170ms	1s614ms	3s425ms
	17	97,346	0ms	170ms	0ms	221ms	499ms	705ms
	18	93,838	0ms	15ms	0ms	57ms	76ms	359ms
	19	94,215	0ms	15ms	0ms	54ms	76ms	372ms
	20	94,740	0ms	18ms	0ms	75ms	190ms	703ms
	21	94,688	0ms	20ms	0ms	63ms	163ms	346ms
	22	97,091	0ms	14ms	0ms	63ms	203ms	616ms
	23	96,476	0ms	17ms	0ms	76ms	156ms	460ms
Aug 08	00	104,791	0ms	24ms	0ms	82ms	118ms	1s856ms
	01	97,006	0ms	23ms	0ms	63ms	222ms	452ms
	02	95,305	0ms	20ms	0ms	64ms	99ms	472ms
	03	95,762	0ms	16ms	0ms	66ms	249ms	407ms
	04	95,177	0ms	16ms	0ms	57ms	82ms	445ms
	05	130,500	0ms	113ms	0ms	416ms	4s201ms	8s12ms
	06	312,316	0ms	1s820ms	0ms	4s91ms	4s728ms	6s179ms
	07	250,050	0ms	14s50ms	0ms	3s340ms	4s223ms	18s87ms
	08	254,547	0ms	183ms	0ms	1s868ms	2s560ms	2s889ms
	09	181,885	0ms	166ms	0ms	1s565ms	2s308ms	3s307ms
	10	197,140	0ms	215ms	0ms	1s657ms	2s508ms	3s237ms
	11	151,808	0ms	323ms	0ms	1s496ms	2s142ms	2s303ms
	12	191,002	0ms	2s803ms	0ms	2s31ms	4s369ms	12s642ms
	13	181,086	0ms	222ms	0ms	3s387ms	5s459ms	7s263ms
	14	151,884	0ms	642ms	0ms	1s968ms	2s490ms	3s563ms
	15	165,932	0ms	207ms	0ms	2s165ms	2s698ms	2s960ms
	16	128,948	0ms	2s488ms	0ms	2s8ms	3s28ms	4s78ms
	17	100,175	0ms	49ms	0ms	136ms	383ms	713ms
	18	102,030	0ms	16ms	0ms	77ms	97ms	466ms
	19	94,361	0ms	16ms	0ms	65ms	110ms	418ms
	20	96,642	0ms	20ms	0ms	74ms	165ms	682ms
	21	94,133	0ms	15ms	0ms	53ms	119ms	333ms
	22	96,168	0ms	15ms	0ms	59ms	187ms	493ms
	23	95,958	0ms	18ms	0ms	74ms	157ms	405ms
Aug 09	00	110,359	0ms	21ms	0ms	78ms	241ms	2s209ms
	01	96,644	0ms	15ms	0ms	64ms	150ms	476ms
	02	96,252	0ms	16ms	0ms	67ms	144ms	548ms
	03	95,970	0ms	35ms	0ms	63ms	105ms	544ms
	04	96,467	0ms	14ms	0ms	65ms	212ms	413ms
	05	110,571	0ms	87ms	0ms	96ms	495ms	7s926ms
	06	333,483	0ms	983ms	0ms	5s174ms	5s901ms	8s125ms
	07	213,352	0ms	323ms	0ms	2s963ms	4s30ms	4s855ms
	08	230,733	0ms	217ms	0ms	2s98ms	2s415ms	3s382ms
	09	202,981	0ms	218ms	0ms	2s713ms	3s324ms	3s962ms
	10	254,148	0ms	831ms	0ms	3s409ms	4s218ms	5s84ms
	11	208,121	0ms	1s406ms	0ms	3s21ms	4s300ms	4s874ms
	12	230,179	0ms	218ms	0ms	3s878ms	4s355ms	5s164ms
	13	220,521	0ms	5s364ms	0ms	2s962ms	4s362ms	21s121ms
	14	152,545	0ms	266ms	0ms	1s924ms	2s779ms	3s143ms
	15	231,368	0ms	212ms	0ms	4s660ms	5s751ms	10s471ms
	16	163,504	0ms	200ms	0ms	4s118ms	6s279ms	7s850ms
	17	113,859	0ms	210ms	0ms	1s4ms	1s702ms	3s46ms
	18	102,351	0ms	18ms	0ms	87ms	106ms	523ms
	19	94,718	0ms	24ms	0ms	60ms	117ms	361ms
	20	97,424	0ms	20ms	0ms	102ms	220ms	762ms
	21	94,772	0ms	14ms	0ms	75ms	146ms	371ms
	22	97,555	0ms	15ms	0ms	94ms	155ms	476ms
	23	96,603	0ms	19ms	0ms	67ms	158ms	435ms
Aug 10	00	106,580	0ms	18ms	0ms	87ms	195ms	2s15ms
	01	97,386	0ms	18ms	0ms	65ms	166ms	519ms
	02	95,306	0ms	20ms	0ms	63ms	123ms	444ms
	03	97,069	0ms	19ms	0ms	65ms	284ms	498ms
	04	95,828	0ms	18ms	0ms	61ms	172ms	468ms
	05	105,825	0ms	58ms	0ms	87ms	428ms	3s858ms
	06	291,634	0ms	2s254ms	0ms	5s283ms	6s318ms	7s986ms
	07	217,037	0ms	316ms	0ms	2s362ms	3s266ms	3s473ms
	08	264,082	0ms	217ms	0ms	4s376ms	5s143ms	5s427ms
	09	175,840	0ms	1s95ms	0ms	2s144ms	2s371ms	3s729ms
	10	281,969	0ms	216ms	0ms	4s344ms	5s136ms	6s325ms
	11	271,039	0ms	223ms	0ms	3s671ms	5s175ms	6s536ms
	12	254,712	0ms	341ms	0ms	4s303ms	5s273ms	5s962ms
	13	242,839	0ms	328ms	0ms	3s502ms	5s723ms	7s319ms
	14	188,028	0ms	207ms	0ms	2s930ms	3s932ms	5s639ms
	15	176,268	0ms	210ms	0ms	1s716ms	2s127ms	3s265ms
	16	125,063	0ms	281ms	0ms	2s3ms	3s105ms	4s192ms
	17	94,729	0ms	211ms	0ms	135ms	479ms	961ms
	18	101,380	0ms	23ms	0ms	94ms	103ms	363ms
	19	94,095	0ms	19ms	0ms	65ms	81ms	388ms
	20	96,155	0ms	18ms	0ms	72ms	195ms	678ms
	21	96,199	0ms	16ms	0ms	74ms	207ms	392ms
	22	97,162	0ms	28ms	0ms	78ms	184ms	569ms
	23	97,469	0ms	17ms	0ms	62ms	132ms	531ms
Aug 11	00	104,217	0ms	18ms	0ms	85ms	178ms	2s95ms
	01	95,509	0ms	16ms	0ms	63ms	137ms	431ms
	02	96,479	0ms	22ms	0ms	62ms	172ms	534ms
	03	95,700	0ms	25ms	0ms	58ms	154ms	434ms
	04	95,647	0ms	20ms	0ms	61ms	116ms	542ms
	05	94,917	0ms	15ms	0ms	58ms	72ms	470ms
	06	74,698	0ms	53ms	0ms	65ms	70ms	557ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 05	00	36,939	0ms	28ms	38ms	153ms
	01	32,475	0ms	31ms	34ms	152ms
	02	32,507	0ms	32ms	38ms	150ms
	03	32,512	0ms	31ms	35ms	145ms
	04	32,472	0ms	28ms	35ms	153ms
	05	32,539	0ms	28ms	36ms	141ms
	06	32,503	0ms	28ms	32ms	141ms
	07	32,473	0ms	27ms	36ms	152ms
	08	32,522	0ms	31ms	36ms	145ms
	09	32,540	0ms	29ms	32ms	145ms
	10	32,465	0ms	28ms	32ms	143ms
	11	32,434	0ms	27ms	34ms	140ms
	12	32,489	0ms	27ms	35ms	142ms
	13	32,487	0ms	32ms	35ms	127ms
	14	32,471	0ms	29ms	35ms	143ms
	15	32,445	0ms	30ms	40ms	141ms
	16	32,495	0ms	35ms	39ms	142ms
	17	32,516	0ms	29ms	36ms	124ms
	18	32,733	0ms	28ms	35ms	150ms
	19	32,762	0ms	29ms	33ms	152ms
	20	32,850	0ms	29ms	34ms	147ms
	21	32,401	0ms	29ms	33ms	148ms
	22	32,577	0ms	28ms	33ms	172ms
	23	32,739	0ms	28ms	37ms	157ms
Aug 06	00	34,641	0ms	28ms	35ms	154ms
	01	32,739	0ms	30ms	33ms	164ms
	02	32,629	0ms	33ms	35ms	160ms
	03	32,685	0ms	32ms	35ms	165ms
	04	32,617	0ms	29ms	33ms	159ms
	05	32,557	0ms	27ms	36ms	138ms
	06	153,093	0ms	2s276ms	3s561ms	4s115ms
	07	100,075	0ms	1s200ms	1s760ms	2s448ms
	08	101,327	0ms	1s314ms	2s326ms	2s664ms
	09	125,145	0ms	1s910ms	2s485ms	3s23ms
	10	150,762	0ms	2s374ms	3s318ms	6s393ms
	11	167,631	0ms	2s728ms	4s415ms	4s816ms
	12	97,521	0ms	1s700ms	2s266ms	3s963ms
	13	49,587	0ms	449ms	1s17ms	1s987ms
	14	59,368	0ms	593ms	977ms	1s734ms
	15	69,550	0ms	929ms	2s167ms	3s611ms
	16	32,832	0ms	31ms	51ms	177ms
	17	53,597	0ms	845ms	1s919ms	2s342ms
	18	33,741	0ms	30ms	36ms	153ms
	19	32,703	0ms	27ms	32ms	177ms
	20	34,833	0ms	30ms	35ms	157ms
	21	32,946	0ms	27ms	39ms	158ms
	22	33,439	0ms	32ms	34ms	177ms
	23	33,330	0ms	32ms	34ms	172ms
Aug 07	00	34,909	0ms	31ms	37ms	170ms
	01	33,131	0ms	31ms	36ms	175ms
	02	33,024	0ms	33ms	36ms	144ms
	03	33,054	0ms	31ms	37ms	167ms
	04	32,906	0ms	28ms	32ms	180ms
	05	32,798	0ms	30ms	32ms	166ms
	06	186,229	0ms	3s63ms	4s523ms	5s393ms
	07	99,278	0ms	1s497ms	2s163ms	2s958ms
	08	127,877	0ms	2s932ms	3s714ms	4s92ms
	09	104,291	0ms	1s28ms	2s411ms	3s747ms
	10	117,998	0ms	2s43ms	3s768ms	4s90ms
	11	124,004	0ms	2s236ms	3s179ms	5s121ms
	12	144,873	0ms	3s124ms	4s81ms	5s797ms
	13	139,904	0ms	2s430ms	3s676ms	4s452ms
	14	87,663	0ms	1s172ms	2s752ms	3s834ms
	15	66,791	0ms	485ms	739ms	1s267ms
	16	75,636	0ms	546ms	1s20ms	1s658ms
	17	34,951	0ms	37ms	200ms	476ms
	18	32,466	0ms	28ms	31ms	164ms
	19	32,709	0ms	27ms	33ms	145ms
	20	34,479	0ms	28ms	37ms	176ms
	21	32,685	0ms	29ms	34ms	174ms
	22	33,281	0ms	29ms	33ms	171ms
	23	33,063	0ms	27ms	47ms	160ms
Aug 08	00	36,987	0ms	29ms	37ms	167ms
	01	33,190	0ms	30ms	36ms	168ms
	02	32,854	0ms	33ms	36ms	157ms
	03	32,886	0ms	33ms	36ms	165ms
	04	32,725	0ms	27ms	33ms	150ms
	05	46,903	0ms	33ms	176ms	1s31ms
	06	143,872	0ms	1s497ms	3s107ms	4s329ms
	07	134,433	0ms	886ms	3s107ms	4s829ms
	08	124,208	0ms	1s167ms	1s360ms	2s172ms
	09	83,754	0ms	820ms	1s272ms	2s416ms
	10	97,332	0ms	1s132ms	1s384ms	2s742ms
	11	65,458	0ms	633ms	1s312ms	2s101ms
	12	96,285	0ms	1s266ms	1s619ms	5s395ms
	13	94,460	0ms	1s386ms	2s990ms	5s687ms
	14	67,287	0ms	539ms	1s876ms	2s301ms
	15	74,196	0ms	1s176ms	1s867ms	2s531ms
	16	57,183	0ms	1s82ms	1s736ms	2s936ms
	17	37,354	0ms	28ms	117ms	304ms
	18	35,940	0ms	30ms	33ms	163ms
	19	32,754	0ms	29ms	33ms	142ms
	20	35,064	0ms	28ms	41ms	162ms
	21	32,548	0ms	27ms	34ms	153ms
	22	32,984	0ms	30ms	35ms	173ms
	23	33,007	0ms	30ms	43ms	147ms
Aug 09	00	38,660	0ms	31ms	40ms	170ms
	01	33,310	0ms	34ms	38ms	173ms
	02	33,083	0ms	32ms	40ms	165ms
	03	33,046	0ms	31ms	36ms	161ms
	04	33,089	0ms	29ms	36ms	139ms
	05	38,538	0ms	33ms	41ms	1s5ms
	06	153,205	0ms	2s912ms	4s58ms	4s824ms
	07	108,362	0ms	1s366ms	2s643ms	3s881ms
	08	115,895	0ms	1s522ms	1s813ms	2s781ms
	09	97,149	0ms	1s746ms	2s381ms	3s160ms
	10	136,466	0ms	2s531ms	3s80ms	3s985ms
	11	104,374	0ms	1s969ms	2s802ms	3s364ms
	12	120,020	0ms	2s545ms	3s580ms	4s457ms
	13	125,044	0ms	1s859ms	2s587ms	5s226ms
	14	68,644	0ms	956ms	1s719ms	2s889ms
	15	128,750	0ms	2s682ms	4s542ms	5s593ms
	16	90,161	0ms	2s20ms	3s927ms	6s610ms
	17	47,485	0ms	178ms	760ms	2s540ms
	18	36,148	0ms	31ms	41ms	155ms
	19	32,833	0ms	30ms	35ms	163ms
	20	35,354	0ms	32ms	38ms	181ms
	21	32,703	0ms	28ms	41ms	155ms
	22	33,349	0ms	31ms	40ms	162ms
	23	33,008	0ms	30ms	39ms	154ms
Aug 10	00	37,479	0ms	29ms	45ms	167ms
	01	33,293	0ms	33ms	37ms	173ms
	02	32,907	0ms	33ms	36ms	163ms
	03	33,299	0ms	33ms	38ms	168ms
	04	33,041	0ms	29ms	37ms	166ms
	05	36,453	0ms	31ms	42ms	285ms
	06	138,236	0ms	2s311ms	3s674ms	5s734ms
	07	99,712	0ms	1s560ms	1s947ms	2s892ms
	08	141,097	0ms	3s331ms	3s972ms	4s824ms
	09	78,531	0ms	1s150ms	1s730ms	2s394ms
	10	162,892	0ms	3s229ms	4s6ms	5s931ms
	11	156,301	0ms	2s437ms	3s265ms	5s284ms
	12	143,533	0ms	2s900ms	3s892ms	5s78ms
	13	141,600	0ms	2s684ms	3s124ms	5s554ms
	14	100,367	0ms	1s590ms	2s714ms	4s435ms
	15	81,198	0ms	882ms	1s569ms	2s169ms
	16	57,857	0ms	855ms	1s936ms	3s108ms
	17	33,162	0ms	31ms	101ms	683ms
	18	35,003	0ms	31ms	42ms	162ms
	19	32,686	0ms	31ms	36ms	157ms
	20	35,152	0ms	34ms	44ms	167ms
	21	33,012	0ms	35ms	43ms	146ms
	22	33,278	0ms	28ms	47ms	172ms
	23	33,306	0ms	29ms	35ms	165ms
Aug 11	00	37,028	0ms	30ms	35ms	174ms
	01	33,010	0ms	31ms	37ms	163ms
	02	33,099	0ms	32ms	35ms	156ms
	03	32,984	0ms	31ms	35ms	171ms
	04	32,963	0ms	29ms	35ms	163ms
	05	32,899	0ms	28ms	32ms	153ms
	06	26,434	0ms	31ms	36ms	180ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 05	00	300	1,738	80	0ms	9ms	13ms	20ms
	01	88	581	81	0ms	1ms	6ms	11ms
	02	88	581	81	0ms	1ms	6ms	10ms
	03	88	582	81	0ms	1ms	7ms	9ms
	04	88	581	81	0ms	1ms	5ms	10ms
	05	88	581	83	0ms	1ms	7ms	10ms
	06	88	580	80	0ms	1ms	6ms	10ms
	07	88	581	80	0ms	1ms	6ms	10ms
	08	88	581	81	0ms	1ms	6ms	10ms
	09	88	581	81	0ms	1ms	8ms	10ms
	10	88	581	81	0ms	1ms	5ms	8ms
	11	88	581	81	0ms	1ms	8ms	9ms
	12	88	581	81	0ms	1ms	7ms	10ms
	13	88	581	81	0ms	1ms	7ms	10ms
	14	88	581	81	0ms	1ms	8ms	10ms
	15	88	582	83	0ms	1ms	8ms	10ms
	16	88	581	80	0ms	1ms	6ms	10ms
	17	88	581	81	0ms	1ms	6ms	9ms
	18	446	683	83	0ms	1ms	8ms	21ms
	19	525	694	85	0ms	1ms	8ms	19ms
	20	314	624	95	0ms	1ms	5ms	13ms
	21	82	576	80	0ms	1ms	3ms	10ms
	22	610	742	80	0ms	2ms	9ms	29ms
	23	348	688	85	0ms	3ms	9ms	14ms
Aug 06	00	203	662	81	0ms	2ms	8ms	9ms
	01	424	693	83	0ms	1ms	8ms	18ms
	02	104	613	83	0ms	1ms	8ms	9ms
	03	132	620	85	0ms	1ms	8ms	11ms
	04	152	625	82	0ms	1ms	7ms	11ms
	05	88	582	82	0ms	1ms	6ms	10ms
	06	59,927	21,005	407	0ms	528ms	1s601ms	4s448ms
	07	12,509	7,249	391	0ms	250ms	291ms	488ms
	08	13,526	7,280	370	0ms	190ms	235ms	321ms
	09	12,515	7,297	390	0ms	196ms	258ms	358ms
	10	14,633	7,729	400	0ms	228ms	271ms	409ms
	11	14,405	7,456	379	1ms	223ms	265ms	404ms
	12	9,165	6,065	263	0ms	146ms	214ms	315ms
	13	3,761	2,944	162	0ms	36ms	128ms	192ms
	14	6,066	4,822	242	0ms	93ms	140ms	198ms
	15	4,527	3,476	242	0ms	83ms	117ms	178ms
	16	135	875	104	0ms	1ms	8ms	29ms
	17	1,308	1,411	142	0ms	16ms	74ms	139ms
	18	240	646	104	0ms	1ms	6ms	17ms
	19	122	615	102	0ms	1ms	8ms	10ms
	20	121	620	119	0ms	1ms	6ms	10ms
	21	616	755	107	0ms	1ms	9ms	37ms
	22	2,271	1,179	106	0ms	1ms	9ms	92ms
	23	2,132	1,134	106	0ms	1ms	9ms	164ms
Aug 07	00	1,110	901	108	0ms	2ms	9ms	59ms
	01	1,352	939	109	0ms	1ms	9ms	80ms
	02	1,152	890	108	0ms	2ms	9ms	70ms
	03	1,304	927	109	0ms	2ms	9ms	87ms
	04	763	767	107	0ms	1ms	8ms	53ms
	05	177	629	107	0ms	1ms	9ms	15ms
	06	65,076	22,549	499	0ms	560ms	1s312ms	2s314ms
	07	10,220	6,186	359	0ms	196ms	250ms	538ms
	08	15,268	8,289	421	0ms	274ms	322ms	408ms
	09	10,403	5,531	310	0ms	157ms	217ms	275ms
	10	8,774	5,120	294	0ms	122ms	181ms	288ms
	11	12,306	6,637	311	6ms	150ms	252ms	371ms
	12	10,987	7,535	318	0ms	147ms	199ms	275ms
	13	10,462	5,968	337	0ms	142ms	187ms	256ms
	14	5,774	4,063	277	0ms	110ms	136ms	183ms
	15	4,979	3,576	252	0ms	84ms	134ms	195ms
	16	2,367	2,187	186	0ms	45ms	92ms	232ms
	17	174	700	112	0ms	2ms	9ms	28ms
	18	100	599	105	0ms	1ms	7ms	11ms
	19	110	602	107	0ms	1ms	8ms	13ms
	20	133	628	117	0ms	1ms	8ms	15ms
	21	639	740	102	0ms	1ms	9ms	52ms
	22	1,886	1,069	105	0ms	1ms	10ms	95ms
	23	1,930	972	108	0ms	2ms	8ms	81ms
Aug 08	00	944	1,654	106	0ms	10ms	14ms	45ms
	01	1,788	1,048	107	0ms	1ms	8ms	101ms
	02	688	773	108	0ms	2ms	8ms	42ms
	03	1,147	888	111	0ms	1ms	8ms	56ms
	04	720	781	107	0ms	2ms	6ms	45ms
	05	9,471	9,430	116	1ms	9ms	122ms	2s581ms
	06	54,121	13,710	484	0ms	377ms	478ms	1s484ms
	07	15,563	8,114	413	0ms	269ms	354ms	547ms
	08	19,625	9,430	434	0ms	308ms	362ms	442ms
	09	11,225	5,730	309	0ms	158ms	203ms	268ms
	10	10,785	6,063	300	0ms	137ms	191ms	251ms
	11	5,872	4,190	231	0ms	86ms	131ms	171ms
	12	8,427	4,899	288	1ms	109ms	190ms	299ms
	13	6,982	3,922	235	0ms	97ms	161ms	241ms
	14	6,632	3,854	243	0ms	99ms	131ms	240ms
	15	6,792	4,699	308	0ms	107ms	142ms	189ms
	16	2,228	1,828	159	1ms	30ms	69ms	168ms
	17	1,242	857	107	0ms	2ms	8ms	77ms
	18	294	1,493	107	0ms	9ms	11ms	20ms
	19	123	631	107	0ms	1ms	8ms	12ms
	20	139	651	133	0ms	1ms	8ms	11ms
	21	180	632	106	0ms	1ms	7ms	13ms
	22	1,593	991	110	0ms	2ms	9ms	98ms
	23	1,104	878	107	0ms	2ms	9ms	77ms
Aug 09	00	2,369	2,506	108	0ms	13ms	17ms	126ms
	01	1,527	885	108	0ms	1ms	9ms	74ms
	02	1,272	920	106	0ms	1ms	9ms	83ms
	03	1,148	888	109	0ms	2ms	9ms	74ms
	04	1,432	958	109	0ms	3ms	9ms	55ms
	05	5,913	4,329	113	0ms	5ms	14ms	1s750ms
	06	56,943	18,815	490	0ms	459ms	1s31ms	1s973ms
	07	11,532	6,584	393	0ms	187ms	262ms	331ms
	08	14,127	7,600	398	0ms	236ms	321ms	390ms
	09	10,551	6,226	370	0ms	166ms	218ms	284ms
	10	15,827	7,999	401	0ms	217ms	273ms	347ms
	11	11,095	6,045	335	0ms	160ms	243ms	343ms
	12	11,653	7,037	331	0ms	165ms	223ms	283ms
	13	10,004	6,034	253	1ms	130ms	207ms	377ms
	14	5,136	3,646	258	0ms	81ms	110ms	154ms
	15	9,190	5,859	353	0ms	158ms	212ms	294ms
	16	1,805	1,821	164	0ms	27ms	84ms	139ms
	17	1,839	1,297	132	0ms	9ms	43ms	133ms
	18	285	1,461	108	0ms	9ms	12ms	16ms
	19	285	687	112	0ms	2ms	8ms	21ms
	20	1,149	928	145	0ms	1ms	8ms	65ms
	21	608	747	105	0ms	2ms	9ms	33ms
	22	2,344	1,181	108	0ms	2ms	10ms	99ms
	23	1,847	1,056	105	0ms	1ms	9ms	81ms
Aug 10	00	1,551	1,949	104	0ms	12ms	16ms	81ms
	01	2,128	1,129	111	0ms	1ms	8ms	107ms
	02	720	779	107	0ms	1ms	8ms	46ms
	03	1,832	1,059	110	0ms	1ms	8ms	94ms
	04	960	840	109	0ms	1ms	8ms	57ms
	05	5,172	2,831	114	0ms	7ms	12ms	1s53ms
	06	54,905	17,995	373	0ms	366ms	1s244ms	2s360ms
	07	13,786	7,925	417	0ms	316ms	357ms	473ms
	08	13,623	7,777	405	0ms	262ms	345ms	447ms
	09	9,982	5,599	317	0ms	135ms	200ms	307ms
	10	16,569	8,026	391	0ms	221ms	272ms	386ms
	11	15,334	8,185	379	0ms	193ms	241ms	343ms
	12	12,137	7,315	352	0ms	176ms	215ms	306ms
	13	10,562	5,870	304	0ms	175ms	238ms	328ms
	14	5,850	3,967	264	0ms	94ms	152ms	234ms
	15	8,676	5,220	317	0ms	137ms	165ms	236ms
	16	899	1,259	143	0ms	10ms	31ms	104ms
	17	138	644	109	0ms	2ms	6ms	12ms
	18	291	1,555	105	0ms	10ms	12ms	16ms
	19	122	625	106	0ms	2ms	8ms	10ms
	20	329	687	149	0ms	2ms	8ms	14ms
	21	1,364	942	110	0ms	2ms	8ms	110ms
	22	1,843	1,060	107	0ms	2ms	8ms	114ms
	23	2,128	1,133	110	0ms	2ms	8ms	96ms
Aug 11	00	1,043	1,544	111	0ms	9ms	14ms	65ms
	01	719	780	112	0ms	2ms	9ms	52ms
	02	1,440	961	109	0ms	2ms	9ms	96ms
	03	1,003	850	108	0ms	2ms	9ms	61ms
	04	884	823	111	0ms	1ms	9ms	66ms
	05	324	681	109	0ms	2ms	8ms	29ms
	06	76	465	97	0ms	1ms	6ms	18ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Aug 05	00	60,027	104,365	1.74	90.92%
	01	54,812	93,658	1.71	95.37%
	02	54,725	93,776	1.71	95.10%
	03	54,840	93,782	1.71	95.29%
	04	54,817	93,666	1.71	95.38%
	05	55,024	93,816	1.71	95.57%
	06	54,864	93,785	1.71	95.35%
	07	54,734	93,633	1.71	95.24%
	08	54,989	93,782	1.71	95.53%
	09	55,060	93,799	1.70	95.63%
	10	54,571	93,704	1.72	94.90%
	11	54,655	93,588	1.71	95.16%
	12	54,759	93,738	1.71	95.19%
	13	54,712	93,738	1.71	95.11%
	14	54,688	93,712	1.71	95.09%
	15	54,630	93,594	1.71	95.09%
	16	54,814	93,757	1.71	95.28%
	17	54,886	93,781	1.71	95.36%
	18	55,413	94,660	1.71	94.96%
	19	55,087	94,784	1.72	94.18%
	20	54,387	93,805	1.72	93.84%
	21	54,316	93,474	1.72	94.71%
	22	54,796	94,306	1.72	94.03%
	23	55,012	94,700	1.72	94.28%
Aug 06	00	57,630	97,374	1.69	95.34%
	01	55,362	94,673	1.71	94.87%
	02	55,231	94,077	1.70	95.55%
	03	55,296	94,281	1.71	95.43%
	04	55,086	94,094	1.71	95.23%
	05	55,161	93,833	1.70	95.77%
	06	85,912	331,248	3.86	30.25%
	07	81,024	209,254	2.58	49.06%
	08	81,200	212,845	2.62	48.44%
	09	83,744	240,717	2.87	42.98%
	10	88,545	269,983	3.05	39.57%
	11	87,274	285,335	3.27	36.44%
	12	76,647	196,071	2.56	50.18%
	13	64,530	127,424	1.97	73.73%
	14	71,500	146,240	2.05	68.11%
	15	69,351	153,098	2.21	61.66%
	16	55,365	94,683	1.71	94.77%
	17	62,632	122,371	1.95	73.85%
	18	55,121	94,281	1.71	93.23%
	19	55,039	94,159	1.71	95.06%
	20	54,711	96,123	1.76	91.21%
	21	55,664	95,274	1.71	94.49%
	22	56,327	97,880	1.74	91.56%
	23	55,750	97,428	1.75	91.18%
Aug 07	00	57,654	98,579	1.71	93.23%
	01	56,013	96,370	1.72	93.33%
	02	55,492	95,976	1.73	93.02%
	03	55,806	96,145	1.72	93.26%
	04	55,496	95,303	1.72	94.09%
	05	55,417	94,470	1.70	95.29%
	06	90,685	376,861	4.16	27.64%
	07	76,140	200,504	2.63	48.19%
	08	85,520	253,293	2.96	41.45%
	09	75,174	202,080	2.69	47.14%
	10	78,882	214,846	2.72	45.77%
	11	80,755	227,896	2.82	43.83%
	12	85,993	253,121	2.94	41.30%
	13	81,703	243,912	2.99	40.75%
	14	73,950	178,165	2.41	54.07%
	15	70,060	150,162	2.14	64.00%
	16	64,118	150,016	2.34	57.70%
	17	56,054	96,241	1.72	92.17%
	18	54,207	93,802	1.73	94.13%
	19	55,003	94,179	1.71	95.02%
	20	53,875	94,704	1.76	90.97%
	21	54,747	94,652	1.73	93.64%
	22	55,638	97,055	1.74	91.58%
	23	55,136	96,440	1.75	91.35%
Aug 08	00	60,973	104,755	1.72	91.74%
	01	55,452	96,970	1.75	91.49%
	02	55,360	95,269	1.72	93.99%
	03	54,664	95,726	1.75	91.94%
	04	53,878	95,141	1.77	91.62%
	05	59,671	130,464	2.19	64.78%
	06	84,264	310,831	3.69	31.92%
	07	80,297	250,014	3.11	39.35%
	08	84,528	254,511	3.01	40.91%
	09	71,954	181,849	2.53	51.69%
	10	74,544	197,071	2.64	48.51%
	11	70,669	151,772	2.15	64.02%
	12	71,328	190,966	2.68	48.03%
	13	66,757	181,035	2.71	47.44%
	14	67,604	151,831	2.25	60.62%
	15	73,618	165,882	2.25	59.57%
	16	60,882	128,895	2.12	66.97%
	17	54,670	100,139	1.83	85.48%
	18	57,423	100,873	1.76	89.34%
	19	55,059	94,325	1.71	94.88%
	20	54,517	96,606	1.77	90.29%
	21	54,146	94,097	1.74	93.58%
	22	55,185	96,132	1.74	91.95%
	23	55,312	95,922	1.73	92.83%
Aug 09	00	62,754	110,323	1.76	88.02%
	01	56,331	96,608	1.72	93.45%
	02	55,794	96,216	1.72	93.19%
	03	55,986	95,934	1.71	93.89%
	04	55,916	96,431	1.72	93.09%
	05	57,662	110,535	1.92	78.04%
	06	91,230	332,010	3.64	32.09%
	07	77,220	213,316	2.76	45.66%
	08	82,398	230,697	2.80	44.52%
	09	76,370	202,878	2.66	48.16%
	10	81,692	254,112	3.11	39.20%
	11	75,691	208,085	2.75	46.00%
	12	84,679	230,108	2.72	45.94%
	13	74,756	220,442	2.95	41.77%
	14	69,619	152,509	2.19	62.23%
	15	79,012	231,300	2.93	42.16%
	16	62,847	163,438	2.60	50.20%
	17	58,371	113,806	1.95	75.69%
	18	58,296	101,097	1.73	90.39%
	19	54,772	94,682	1.73	93.82%
	20	54,524	97,388	1.79	88.40%
	21	54,265	94,736	1.75	92.70%
	22	55,767	97,519	1.75	90.93%
	23	54,847	96,567	1.76	90.85%
Aug 10	00	61,419	106,544	1.73	90.21%
	01	56,147	97,350	1.73	91.93%
	02	55,537	95,270	1.72	94.21%
	03	56,414	97,033	1.72	92.89%
	04	56,325	95,792	1.70	94.78%
	05	57,707	105,789	1.83	83.31%
	06	77,702	290,254	3.74	30.98%
	07	88,712	217,001	2.45	52.12%
	08	85,782	264,046	3.08	39.47%
	09	77,634	175,804	2.26	58.33%
	10	85,757	281,896	3.29	36.28%
	11	87,369	269,666	3.09	38.79%
	12	87,981	254,676	2.89	42.07%
	13	80,640	241,642	3.00	40.42%
	14	73,799	187,978	2.55	50.31%
	15	74,413	176,217	2.37	55.69%
	16	60,303	125,027	2.07	68.59%
	17	55,131	94,673	1.72	94.23%
	18	58,119	101,344	1.74	91.52%
	19	54,906	94,059	1.71	94.87%
	20	54,659	96,119	1.76	90.53%
	21	55,715	96,163	1.73	93.06%
	22	56,307	97,126	1.72	92.67%
	23	55,957	97,433	1.74	91.55%
Aug 11	00	60,108	104,181	1.73	90.81%
	01	55,776	95,473	1.71	94.38%
	02	55,733	96,443	1.73	92.74%
	03	55,275	95,664	1.73	93.08%
	04	55,403	95,611	1.73	93.48%
	05	55,051	94,881	1.72	94.10%
	06	43,154	74,668	1.73	93.42%

Day	Hour	Count	Average / Second
Aug 05	00	76	0.02/s
	01	77	0.02/s
	02	73	0.02/s
	03	75	0.02/s
	04	81	0.02/s
	05	78	0.02/s
	06	78	0.02/s
	07	70	0.02/s
	08	71	0.02/s
	09	72	0.02/s
	10	62	0.02/s
	11	65	0.02/s
	12	65	0.02/s
	13	66	0.02/s
	14	62	0.02/s
	15	62	0.02/s
	16	71	0.02/s
	17	72	0.02/s
	18	68	0.02/s
	19	66	0.02/s
	20	67	0.02/s
	21	64	0.02/s
	22	64	0.02/s
	23	63	0.02/s
Aug 06	00	81	0.02/s
	01	76	0.02/s
	02	83	0.02/s
	03	76	0.02/s
	04	72	0.02/s
	05	77	0.02/s
	06	79	0.02/s
	07	81	0.02/s
	08	69	0.02/s
	09	82	0.02/s
	10	106	0.03/s
	11	97	0.03/s
	12	77	0.02/s
	13	62	0.02/s
	14	64	0.02/s
	15	68	0.02/s
	16	69	0.02/s
	17	76	0.02/s
	18	69	0.02/s
	19	67	0.02/s
	20	64	0.02/s
	21	74	0.02/s
	22	66	0.02/s
	23	63	0.02/s
Aug 07	00	69	0.02/s
	01	70	0.02/s
	02	56	0.02/s
	03	73	0.02/s
	04	70	0.02/s
	05	72	0.02/s
	06	91	0.03/s
	07	64	0.02/s
	08	73	0.02/s
	09	74	0.02/s
	10	93	0.03/s
	11	111	0.03/s
	12	104	0.03/s
	13	114	0.03/s
	14	98	0.03/s
	15	69	0.02/s
	16	65	0.02/s
	17	80	0.02/s
	18	67	0.02/s
	19	74	0.02/s
	20	79	0.02/s
	21	76	0.02/s
	22	77	0.02/s
	23	72	0.02/s
Aug 08	00	94	0.03/s
	01	72	0.02/s
	02	73	0.02/s
	03	59	0.02/s
	04	57	0.02/s
	05	57	0.02/s
	06	52	0.01/s
	07	61	0.02/s
	08	51	0.01/s
	09	54	0.01/s
	10	57	0.02/s
	11	51	0.01/s
	12	67	0.02/s
	13	70	0.02/s
	14	68	0.02/s
	15	68	0.02/s
	16	61	0.02/s
	17	56	0.02/s
	18	57	0.02/s
	19	66	0.02/s
	20	54	0.01/s
	21	54	0.01/s
	22	60	0.02/s
	23	61	0.02/s
Aug 09	00	77	0.02/s
	01	83	0.02/s
	02	63	0.02/s
	03	78	0.02/s
	04	75	0.02/s
	05	81	0.02/s
	06	98	0.03/s
	07	69	0.02/s
	08	77	0.02/s
	09	55	0.02/s
	10	68	0.02/s
	11	60	0.02/s
	12	99	0.03/s
	13	99	0.03/s
	14	67	0.02/s
	15	103	0.03/s
	16	66	0.02/s
	17	59	0.02/s
	18	68	0.02/s
	19	58	0.02/s
	20	60	0.02/s
	21	51	0.01/s
	22	72	0.02/s
	23	59	0.02/s
Aug 10	00	76	0.02/s
	01	73	0.02/s
	02	72	0.02/s
	03	77	0.02/s
	04	82	0.02/s
	05	74	0.02/s
	06	110	0.03/s
	07	139	0.04/s
	08	72	0.02/s
	09	99	0.03/s
	10	87	0.02/s
	11	121	0.03/s
	12	131	0.04/s
	13	100	0.03/s
	14	90	0.03/s
	15	72	0.02/s
	16	77	0.02/s
	17	71	0.02/s
	18	66	0.02/s
	19	63	0.02/s
	20	66	0.02/s
	21	67	0.02/s
	22	75	0.02/s
	23	74	0.02/s
Aug 11	00	75	0.02/s
	01	76	0.02/s
	02	65	0.02/s
	03	62	0.02/s
	04	62	0.02/s
	05	69	0.02/s
	06	53	0.01/s

Day	Hour	Count	Average Duration
Aug 05	00	76	8m17s
	01	77	7m40s
	02	73	8m19s
	03	75	8m7s
	04	81	7m26s
	05	78	7m46s
	06	78	7m40s
	07	70	8m40s
	08	71	8m21s
	09	72	8m13s
	10	62	9m3s
	11	65	9m41s
	12	65	8m46s
	13	66	9m25s
	14	62	9m59s
	15	62	9m20s
	16	71	8m35s
	17	72	8m29s
	18	68	8m40s
	19	66	9m2s
	20	67	9m7s
	21	63	9m27s
	22	65	9m39s
	23	63	9m23s
Aug 06	00	75	7m30s
	01	76	8m9s
	02	83	7m15s
	03	75	7m39s
	04	73	8m27s
	05	77	7m51s
	06	79	8m36s
	07	78	9m6s
	08	66	8m42s
	09	88	9m10s
	10	104	9m27s
	11	93	8m27s
	12	81	11m
	13	64	10m50s
	14	61	9m40s
	15	71	9m2s
	16	69	9m37s
	17	73	8m55s
	18	72	8m58s
	19	67	9m6s
	20	64	9m13s
	21	74	8m8s
	22	66	9m
	23	63	9m34s
Aug 07	00	69	8m41s
	01	70	8m16s
	02	56	11m19s
	03	73	8m27s
	04	70	8m47s
	05	72	7m52s
	06	91	8m45s
	07	64	11m6s
	08	70	10m14s
	09	77	10m36s
	10	84	9m33s
	11	102	11m28s
	12	111	8m55s
	13	116	10m16s
	14	107	9m5s
	15	69	8m16s
	16	65	9m29s
	17	80	8m8s
	18	67	9m
	19	74	8m5s
	20	79	7m16s
	21	76	8m17s
	22	77	7m32s
	23	72	8m30s
Aug 08	00	94	6m43s
	01	72	8m10s
	02	73	8m25s
	03	59	8m56s
	04	57	9m43s
	05	57	12m47s
	06	52	11m43s
	07	58	10m50s
	08	54	10m56s
	09	54	12m45s
	10	57	11m4s
	11	51	10m49s
	12	67	10m42s
	13	70	12m14s
	14	68	10m48s
	15	65	10m36s
	16	64	9m13s
	17	56	10m38s
	18	57	12m1s
	19	66	8m49s
	20	54	9m41s
	21	54	12m58s
	22	60	10m3s
	23	61	9m32s
Aug 09	00	77	8m26s
	01	83	7m5s
	02	63	9m14s
	03	78	8m3s
	04	75	8m9s
	05	81	7m15s
	06	94	5m57s
	07	73	12m16s
	08	77	8m41s
	09	55	10m50s
	10	66	11m22s
	11	59	12m39s
	12	84	10m24s
	13	108	9m28s
	14	69	9m46s
	15	97	9m27s
	16	79	13m20s
	17	59	10m27s
	18	68	10m16s
	19	58	9m49s
	20	60	11m6s
	21	51	10m47s
	22	72	8m41s
	23	59	10m28s
Aug 10	00	76	8m
	01	73	7m41s
	02	71	8m40s
	03	78	8m10s
	04	82	7m39s
	05	74	7m43s
	06	92	8m22s
	07	136	8m8s
	08	81	8m22s
	09	97	9m20s
	10	81	7m34s
	11	119	9m50s
	12	129	8m44s
	13	103	10m1s
	14	95	9m15s
	15	76	10m3s
	16	74	9m3s
	17	74	8m42s
	18	66	9m7s
	19	63	8m57s
	20	66	9m19s
	21	67	9m29s
	22	75	7m49s
	23	74	8m12s
Aug 11	00	75	8m
	01	76	8m7s
	02	65	9m2s
	03	62	9m34s
	04	61	9m18s
	05	70	9m24s
	06	53	8m15s

↑ Back to the top of the General Activity table

Established Connections

Key values

35 connections Connection Peak
2018-08-10 07:49:45 Date

Connections per database

Key values

pharmisight Main Database
11,078 connections Total

Chart
Table

Database	User	Count
pharmisight		11,078
	pharmisight	4,396
	symmetricds	4,873
	tony	1,809

Connections per user

Key values

symmetricds Main User
11,078 connections Total

Chart
Table

User	Count
pharmisight	4,396
symmetricds	4,873
tony	1,809

Connections per host

Key values

10.10.10.1 Main host with 9269 connections
11,078 Total connections

Chart
Table

Host	Count
10.10.10.1	9,269
::1	1,809

Simultaneous sessions

Key values

3 sessions Session Peak
2018-08-06 10:52:51 Date

Histogram of session times

Key values

5,984 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	1,813	16.39%
500ms-1s	3	0.03%
1s-30s	33	0.30%
30s-1m	0	0.00%
1m-10m	5,984	54.10%
10m-30m	2,884	26.08%
30m-1h	317	2.87%
1h-8h	26	0.24%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
11,060 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	11,060	70d7h2m42s	9m9s

Sessions per user

Key values

symmetricds Main User
11,060 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	4,384	38d16h40m19s
symmetricds	4,867	31d14h20m43s
tony	1,809	1m39s

Sessions per host

Key values

10.10.10.1 Main Host
11,060 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	9,251	70d7h1m3s	10m56s
::1	1,809	1m39s	55ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
11,060 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	9,219	70d6h57m5s	10m58s
[unknown]	1,841	5m37s	183ms

Checkpoints Buffers

Key values

8,136 buffers Checkpoint Peak
2018-08-08 07:03:45 Date
150.044 seconds Highest write time
0.099 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-08-09 06:12:36 Date

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

NO DATASET

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Aug 05	00	2,222	222.458s	0.013s	222.511s
	01	709	71.009s	0.014s	71.065s
	02	749	75.131s	0.012s	75.183s
	03	718	72.017s	0.031s	72.087s
	04	743	74.529s	0.01s	74.577s
	05	709	71.113s	0.014s	71.164s
	06	760	76.124s	0.013s	76.176s
	07	610	61.191s	0.013s	61.248s
	08	638	63.995s	0.024s	64.053s
	09	616	61.794s	0.012s	61.843s
	10	672	67.411s	0.011s	67.456s
	11	592	59.381s	0.015s	59.438s
	12	636	63.796s	0.013s	63.851s
	13	629	63.094s	0.04s	63.174s
	14	568	56.981s	0.011s	57.039s
	15	629	63.092s	0.017s	63.163s
	16	653	65.489s	0.019s	65.548s
	17	608	60.976s	0.015s	61.044s
	18	726	72.815s	0.013s	72.866s
	19	954	95.673s	0.01s	95.726s
	20	564	56.565s	0.014s	56.62s
	21	538	53.965s	0.014s	54.021s
	22	708	71.006s	0.015s	71.061s
	23	646	64.785s	0.02s	64.84s
Aug 06	00	674	67.601s	0.01s	67.651s
	01	801	80.328s	0.018s	80.384s
	02	644	64.61s	0.016s	64.669s
	03	647	64.897s	0.014s	64.966s
	04	555	55.669s	0.019s	55.727s
	05	509	51.052s	0.021s	51.124s
	06	10,210	996.205s	0.058s	996.309s
	07	6,956	696.891s	0.046s	696.982s
	08	5,717	572.337s	0.037s	572.416s
	09	5,842	584.611s	0.033s	584.687s
	10	6,195	619.879s	0.032s	619.951s
	11	6,256	626.31s	0.045s	626.395s
	12	5,144	530.476s	0.047s	530.565s
	13	3,472	347.882s	0.026s	347.95s
	14	4,914	492.416s	0.03s	492.485s
	15	3,205	320.783s	0.021s	320.847s
	16	779	78.143s	0.019s	78.208s
	17	1,624	162.589s	0.015s	162.647s
	18	636	63.793s	0.015s	63.85s
	19	516	51.771s	0.021s	51.829s
	20	688	69.01s	0.015s	69.073s
	21	760	76.233s	0.012s	76.287s
	22	915	91.678s	0.015s	91.741s
	23	1,028	103.111s	0.025s	103.178s
Aug 07	00	805	80.742s	0.013s	80.795s
	01	899	90.185s	0.011s	90.239s
	02	1,014	101.636s	0.01s	101.684s
	03	937	94.005s	0.016s	94.06s
	04	865	86.753s	0.013s	86.807s
	05	666	66.808s	0.014s	66.862s
	06	11,017	993.131s	0.045s	993.219s
	07	11,601	707.363s	0.021s	707.427s
	08	7,188	720.66s	0.033s	720.733s
	09	5,098	510.917s	0.021s	510.984s
	10	6,220	508.989s	0.027s	509.056s
	11	6,077	608.705s	0.047s	608.793s
	12	7,338	735.366s	0.027s	735.437s
	13	5,705	495.624s	0.039s	495.703s
	14	1,900	193.884s	0.041s	193.978s
	15	3,172	317.735s	0.019s	317.823s
	16	2,511	251.557s	0.015s	251.614s
	17	739	74.143s	0.025s	74.206s
	18	764	76.635s	0.018s	76.693s
	19	731	73.322s	0.015s	73.378s
	20	575	57.675s	0.015s	57.734s
	21	637	63.891s	0.017s	63.95s
	22	781	78.223s	0.018s	78.298s
	23	876	87.751s	0.012s	87.809s
Aug 08	00	1,641	164.377s	0.019s	164.429s
	01	959	96.077s	0.025s	96.144s
	02	747	74.93s	0.018s	74.986s
	03	820	82.239s	0.016s	82.294s
	04	719	72.113s	0.017s	72.169s
	05	2,520	226.332s	0.023s	226.394s
	06	10,158	1,019.892s	0.035s	1,019.981s
	07	14,163	759.111s	0.024s	759.178s
	08	7,973	799.12s	0.026s	799.187s
	09	5,319	532.989s	0.018s	533.05s
	10	5,820	582.072s	0.018s	582.132s
	11	6,866	537.838s	0.023s	537.9s
	12	5,065	506.847s	0.034s	506.921s
	13	4,182	418.674s	0.117s	418.835s
	14	3,889	394.303s	0.019s	394.364s
	15	5,770	532.047s	0.031s	532.122s
	16	2,200	220.997s	0.02s	221.061s
	17	1,027	102.818s	0.024s	102.882s
	18	1,370	137.346s	0.01s	137.398s
	19	565	56.688s	0.014s	56.74s
	20	713	71.424s	0.016s	71.48s
	21	726	72.831s	0.024s	72.895s
	22	1,149	115.263s	0.015s	115.321s
	23	928	93.093s	0.047s	93.181s
Aug 09	00	2,190	219.52s	0.014s	219.573s
	01	990	99.318s	0.024s	99.383s
	02	896	89.792s	0.027s	89.862s
	03	948	95.012s	0.016s	95.065s
	04	983	98.505s	0.016s	98.57s
	05	795	79.634s	0.018s	79.692s
	06	13,387	963.95s	0.037s	964.082s
	07	8,707	611.083s	0.021s	611.144s
	08	9,297	768.66s	0.016s	768.72s
	09	5,982	581.64s	0.024s	581.708s
	10	6,921	692.895s	0.018s	692.959s
	11	7,979	733.896s	0.019s	733.957s
	12	6,485	648.812s	0.034s	648.889s
	13	8,017	646.665s	0.018s	646.724s
	14	3,759	377.067s	0.02s	377.124s
	15	5,246	525.568s	0.04s	525.647s
	16	2,573	257.568s	0.017s	257.624s
	17	1,625	163.026s	0.017s	163.081s
	18	1,507	151.183s	0.015s	151.24s
	19	762	76.444s	0.018s	76.501s
	20	802	80.452s	0.016s	80.508s
	21	707	70.944s	0.026s	71.008s
	22	927	92.896s	0.014s	92.95s
	23	2,724	219.926s	0.017s	219.984s
Aug 10	00	1,701	170.445s	0.014s	170.501s
	01	981	98.402s	0.022s	98.464s
	02	753	75.537s	0.015s	75.59s
	03	1,165	116.852s	0.014s	116.909s
	04	993	99.52s	0.014s	99.577s
	05	782	78.45s	0.015s	78.506s
	06	10,437	800.931s	0.031s	800.995s
	07	10,335	818.921s	0.023s	818.983s
	08	9,849	813.35s	0.035s	813.429s
	09	6,148	596.9s	0.017s	596.962s
	10	7,386	749.102s	0.024s	749.167s
	11	9,682	869.312s	0.02s	869.374s
	12	7,790	779.812s	0.032s	779.888s
	13	6,014	611.033s	0.032s	611.106s
	14	4,220	422.77s	0.016s	422.828s
	15	5,352	535.947s	0.021s	536.005s
	16	3,802	266.313s	0.013s	266.365s
	17	954	95.609s	0.014s	95.659s
	18	1,397	139.852s	0.013s	139.908s
	19	660	66.221s	0.017s	66.278s
	20	713	71.531s	0.039s	71.613s
	21	915	91.685s	0.017s	91.769s
	22	1,048	104.915s	0.03s	104.984s
	23	1,253	125.489s	0.024s	125.556s
Aug 11	00	2,058	205.961s	0.011s	206.011s
	01	978	98.017s	0.012s	98.068s
	02	991	99.319s	0.03s	99.389s
	03	931	93.403s	0.015s	93.458s
	04	1,125	112.678s	0.014s	112.731s
	05	786	78.76s	0.023s	78.822s
	06	4,349	183.078s	0.016s	183.127s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Aug 05	00	0	0	0	348	0.002s	0s
	01	0	0	1	296	0.002s	0s
	02	0	0	0	300	0.001s	0s
	03	0	0	0	288	0.010s	0s
	04	0	0	0	300	0.002s	0s
	05	0	0	0	303	0.002s	0s
	06	0	0	0	296	0.002s	0s
	07	0	0	1	292	0.002s	0s
	08	0	0	0	292	0.013s	0.003s
	09	0	0	0	293	0.002s	0s
	10	0	0	0	280	0.001s	0s
	11	0	0	0	285	0.002s	0.001s
	12	0	0	0	288	0.002s	0s
	13	0	0	0	289	0.027s	0s
	14	0	0	1	286	0.002s	0s
	15	0	0	0	289	0.005s	0s
	16	0	0	0	295	0.006s	0s
	17	0	0	0	294	0.002s	0s
	18	0	0	0	311	0.002s	0s
	19	0	0	0	334	0.001s	0s
	20	0	0	1	257	0.002s	0s
	21	0	0	0	187	0.002s	0s
	22	0	0	0	284	0.002s	0s
	23	0	0	0	286	0.002s	0s
Aug 06	00	0	0	0	275	0.002s	0s
	01	0	0	0	280	0.004s	0.001s
	02	0	0	1	276	0.002s	0s
	03	0	0	0	278	0.002s	0s
	04	0	0	0	265	0.008s	0s
	05	0	0	0	238	0.008s	0s
	06	0	0	8	1,181	0.008s	0s
	07	0	2	2	1,147	0.009s	0s
	08	0	0	2	1,056	0.002s	0s
	09	0	0	2	1,187	0.004s	0s
	10	0	0	3	1,197	0.002s	0s
	11	0	0	2	1,123	0.008s	0s
	12	0	0	2	996	0.008s	0s
	13	0	0	2	806	0.002s	0s
	14	0	0	2	1,026	0.002s	0s
	15	0	0	1	943	0.002s	0s
	16	0	0	0	307	0.008s	0s
	17	0	0	1	712	0.002s	0s
	18	0	0	0	331	0.002s	0s
	19	0	0	0	257	0.008s	0s
	20	0	0	0	314	0.002s	0s
	21	0	0	0	362	0.002s	0s
	22	0	0	1	385	0.002s	0s
	23	0	0	0	383	0.008s	0s
Aug 07	00	0	0	0	386	0.002s	0s
	01	0	0	1	369	0.001s	0s
	02	0	0	0	381	0.001s	0s
	03	0	0	0	375	0.002s	0s
	04	0	0	1	380	0.002s	0s
	05	0	0	0	350	0.002s	0s
	06	0	1	7	1,232	0.009s	0s
	07	0	1	4	1,093	0.002s	0s
	08	0	0	3	1,217	0.015s	0s
	09	0	0	2	1,035	0.003s	0s
	10	0	0	2	1,105	0.003s	0s
	11	0	0	2	1,240	0.017s	0s
	12	0	0	5	1,372	0.008s	0s
	13	0	0	2	1,143	0.002s	0s
	14	0	0	2	982	0.002s	0s
	15	0	0	1	962	0.002s	0s
	16	0	0	1	863	0.002s	0s
	17	0	0	0	466	0.008s	0s
	18	0	0	0	364	0.004s	0s
	19	0	0	0	389	0.002s	0s
	20	0	0	0	338	0.002s	0s
	21	0	0	1	313	0.002s	0s
	22	0	0	0	328	0.002s	0s
	23	0	0	0	327	0.002s	0s
Aug 08	00	0	0	1	377	0.002s	0s
	01	0	0	0	346	0.011s	0.002s
	02	0	0	0	345	0.002s	0s
	03	0	0	0	340	0.002s	0s
	04	0	0	1	321	0.002s	0s
	05	0	0	0	453	0.002s	0s
	06	0	1	8	1,250	0.007s	0s
	07	0	1	4	1,153	0.002s	0s
	08	0	0	3	1,171	0.003s	0s
	09	0	0	3	1,084	0.002s	0s
	10	0	0	2	1,136	0.003s	0s
	11	0	0	2	1,168	0.002s	0s
	12	0	0	2	1,190	0.011s	0s
	13	0	0	2	1,028	0.098s	0.001s
	14	0	0	1	905	0.001s	0s
	15	0	0	2	1,065	0.008s	0s
	16	0	0	1	699	0.003s	0s
	17	0	0	0	362	0.008s	0s
	18	0	0	1	327	0.002s	0s
	19	0	0	0	310	0.002s	0s
	20	0	0	0	360	0.002s	0s
	21	0	0	0	376	0.008s	0s
	22	0	0	0	433	0.002s	0s
	23	0	0	1	420	0.017s	0s
Aug 09	00	0	0	1	438	0.002s	0s
	01	0	0	0	408	0.008s	0s
	02	0	0	0	408	0.008s	0s
	03	0	0	0	408	0.003s	0s
	04	0	0	1	409	0.003s	0s
	05	0	0	0	396	0.002s	0s
	06	1	2	8	1,206	0.002s	0s
	07	0	2	1	1,139	0.002s	0s
	08	0	0	4	1,194	0.002s	0s
	09	0	0	2	1,210	0.002s	0s
	10	0	0	3	1,186	0.002s	0s
	11	0	0	3	1,153	0.001s	0s
	12	0	0	3	1,282	0.007s	0s
	13	0	0	3	1,021	0.002s	0s
	14	0	0	1	1,017	0.003s	0s
	15	0	0	2	1,218	0.017s	0s
	16	0	0	1	860	0.003s	0s
	17	0	0	1	626	0.002s	0s
	18	0	0	0	410	0.002s	0s
	19	0	0	0	395	0.002s	0s
	20	0	0	1	375	0.002s	0s
	21	0	0	0	330	0.014s	0s
	22	0	0	0	330	0.002s	0s
	23	0	0	1	304	0.005s	0s
Aug 10	00	0	0	0	367	0.002s	0s
	01	0	0	1	340	0.008s	0s
	02	0	0	0	324	0.002s	0s
	03	0	0	0	345	0.002s	0s
	04	0	0	1	356	0.002s	0s
	05	0	0	0	320	0.002s	0s
	06	0	2	7	1,067	0.002s	0s
	07	0	3	1	1,201	0.001s	0s
	08	0	0	3	1,206	0.008s	0s
	09	0	0	3	1,156	0.002s	0s
	10	0	0	3	1,220	0.003s	0s
	11	0	0	3	1,276	0.002s	0s
	12	0	0	4	1,358	0.008s	0s
	13	0	0	2	1,240	0.006s	0s
	14	0	0	2	1,089	0.001s	0s
	15	0	0	2	1,085	0.008s	0s
	16	0	0	1	633	0.002s	0s
	17	0	0	0	394	0.002s	0s
	18	0	0	1	312	0.002s	0s
	19	0	0	0	319	0.002s	0s
	20	0	0	0	356	0.025s	0s
	21	0	0	0	385	0.003s	0s
	22	0	0	1	409	0.008s	0s
	23	0	0	0	399	0.008s	0s
Aug 11	00	0	0	1	442	0.002s	0s
	01	0	0	0	405	0.001s	0s
	02	0	0	0	399	0.008s	0s
	03	0	0	1	397	0.002s	0s
	04	0	0	0	417	0.002s	0s
	05	0	0	0	393	0.008s	0s
	06	0	0	1	264	0.008s	0s

Day	Hour	Avg time (sec)
Aug 05	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
Aug 06	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
Aug 07	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
Aug 08	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
Aug 09	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
Aug 10	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
Aug 11	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s

Day	Hour	Mean distance	Mean estimate
Aug 05	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 06	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 07	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 08	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 09	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 10	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 11	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

18.68 MiB Temp Files size Peak
2018-08-09 06:03:44 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-08-08 06:00:37 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Aug 05	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 06	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	3	27.01 MiB	9.00 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 07	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	1	8.86 MiB	8.86 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 08	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	3	27.41 MiB	9.14 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 09	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	3	27.95 MiB	9.32 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 10	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	3	28.95 MiB	9.65 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Aug 11	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

29.94 sec Highest CPU-cost vacuum
Table public.eps
Database pharmisight
2018-08-07 11:55:54 Date
7.82 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-08-07 14:42:37 Date

Analyzes per table

Key values

public.sym_node_communication (1297) Main table analyzed (database pharmisight)
3,141 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	1297
pharmisight.public.sym_data_gap	498
pharmisight.public.sym_sequence	483
pharmisight.public.sym_outgoing_batch	333
pharmisight.public.sym_node_channel_ctl	124
pharmisight.public.sym_incoming_batch	101
pharmisight.public.sym_data_event	85
pharmisight.public.sym_data	80
pharmisight.public.sym_lock	70
pharmisight.public.sym_node_host	35
pharmisight.public.item_codes	16
pharmisight.public.flow_report_summary_delays	5
pharmisight.public.users	3
pharmisight.public.tablets	3
pharmisight.public.patients	2
pharmisight.public.flow_report_summary_months	1
pharmisight.public.eps	1
pharmisight.public.eps_check_lines	1
pharmisight.public.order_rounds	1
pharmisight.public.stats_picker_months	1
pharmisight.public.flow_reports	1
Total	3,141

Vacuums per table

Key values

public.sym_node_communication (1287) Main table vacuumed on database pharmisight
2,562 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	1287	0
pharmisight.public.sym_sequence	485	0
pharmisight.public.sym_data_gap	259	259
pharmisight.public.sym_outgoing_batch	163	162
pharmisight.public.sym_node_channel_ctl	123	0
pharmisight.public.sym_lock	70	0
pharmisight.public.sym_incoming_batch	41	41
pharmisight.public.sym_node_host	34	0
pharmisight.public.sym_data	29	23
pharmisight.pg_catalog.pg_statistic	28	28
pharmisight.public.sym_data_event	20	20
pharmisight.pg_toast.pg_toast_2619	14	14
pharmisight.public.item_codes	5	5
pharmisight.public.eps	1	1
pharmisight.public.order_rounds	1	1
pharmisight.public.flow_report_summary_delays	1	1
pharmisight.public.flow_reports	1	1
Total	2,562	556

Tuples removed per table

Key values

public.sym_node_communication (71966) Main table with removed tuples on database pharmisight
248966 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_node_communication	1287	0	71966	0
pharmisight.public.sym_data_event	20	20	40976	134
pharmisight.public.sym_outgoing_batch	163	162	28572	198
pharmisight.public.sym_sequence	485	0	26777	0
pharmisight.public.sym_data	29	23	23011	1026
pharmisight.public.sym_data_gap	259	259	13633	0
pharmisight.pg_catalog.pg_statistic	28	28	8279	0
pharmisight.public.sym_incoming_batch	41	41	8012	0
pharmisight.public.flow_reports	1	1	7796	0
pharmisight.public.sym_node_channel_ctl	123	0	6603	0
pharmisight.public.eps	1	1	4239	0
pharmisight.public.sym_lock	70	0	3640	0
pharmisight.public.sym_node_host	34	0	1770	0
pharmisight.public.item_codes	5	5	1393	0
pharmisight.public.order_rounds	1	1	1273	0
pharmisight.pg_toast.pg_toast_2619	14	14	1004	3
pharmisight.public.flow_report_summary_delays	1	1	22	0
Total	2,562	556	248,966	1,361

Pages removed per table

Key values

public.sym_data (1026) Main table with removed pages on database pharmisight
1361 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data	29	23	23011	1026
pharmisight.public.sym_outgoing_batch	163	162	28572	198
pharmisight.public.sym_data_event	20	20	40976	134
pharmisight.pg_toast.pg_toast_2619	14	14	1004	3
pharmisight.public.sym_incoming_batch	41	41	8012	0
pharmisight.public.sym_data_gap	259	259	13633	0
pharmisight.public.eps	1	1	4239	0
pharmisight.public.sym_sequence	485	0	26777	0
pharmisight.public.sym_node_communication	1287	0	71966	0
pharmisight.public.item_codes	5	5	1393	0
pharmisight.public.sym_node_host	34	0	1770	0
pharmisight.public.sym_lock	70	0	3640	0
pharmisight.public.order_rounds	1	1	1273	0
pharmisight.public.flow_report_summary_delays	1	1	22	0
pharmisight.pg_catalog.pg_statistic	28	28	8279	0
pharmisight.public.sym_node_channel_ctl	123	0	6603	0
pharmisight.public.flow_reports	1	1	7796	0
Total	2,562	556	248,966	1,361

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Aug 05	00	14	17
	01	12	12
	02	12	14
	03	12	11
	04	12	14
	05	13	14
	06	13	12
	07	10	11
	08	10	14
	09	13	11
	10	9	14
	11	11	10
	12	11	13
	13	11	12
	14	10	12
	15	12	10
	16	9	16
	17	12	11
	18	10	14
	19	12	14
	20	10	10
	21	10	16
	22	12	13
	23	9	13
Aug 06	00	12	13
	01	13	16
	02	10	13
	03	11	13
	04	9	12
	05	12	12
	06	43	63
	07	35	52
	08	35	50
	09	37	49
	10	32	47
	11	34	42
	12	23	37
	13	16	18
	14	25	29
	15	19	27
	16	11	10
	17	15	16
	18	10	11
	19	10	11
	20	10	10
	21	10	13
	22	10	10
	23	12	13
Aug 07	00	10	10
	01	9	12
	02	13	10
	03	10	10
	04	11	14
	05	10	11
	06	32	46
	07	33	40
	08	31	44
	09	26	33
	10	28	34
	11	30	37
	12	24	37
	13	33	37
	14	23	33
	15	22	28
	16	19	21
	17	9	12
	18	12	11
	19	11	10
	20	10	12
	21	9	11
	22	11	10
	23	10	11
Aug 08	00	13	15
	01	9	13
	02	11	9
	03	11	10
	04	11	12
	05	9	13
	06	34	47
	07	34	42
	08	34	46
	09	26	36
	10	27	35
	11	23	27
	12	25	34
	13	23	28
	14	21	28
	15	28	34
	16	13	17
	17	12	12
	18	10	13
	19	9	11
	20	11	13
	21	11	10
	22	14	12
	23	8	10
Aug 09	00	11	14
	01	10	14
	02	12	11
	03	11	11
	04	10	12
	05	10	11
	06	36	47
	07	33	41
	08	30	41
	09	32	39
	10	30	46
	11	33	35
	12	28	41
	13	23	28
	14	23	29
	15	31	37
	16	14	19
	17	13	14
	18	10	14
	19	11	10
	20	11	12
	21	10	9
	22	10	12
	23	10	14
Aug 10	00	12	11
	01	11	12
	02	11	10
	03	10	12
	04	13	13
	05	9	11
	06	32	34
	07	34	46
	08	31	42
	09	29	34
	10	31	42
	11	32	41
	12	29	39
	13	28	34
	14	22	30
	15	27	33
	16	13	17
	17	13	12
	18	9	12
	19	10	11
	20	11	12
	21	9	12
	22	11	9
	23	12	15
Aug 11	00	11	12
	01	11	14
	02	10	10
	03	11	12
	04	11	10
	05	10	13
	06	11	9

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
75 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		22	1m2s	2s829ms
	tuple	22	1m2s	2s829ms
ShareLock		53	2m1s	2s298ms
	transaction	53	2m1s	2s298ms
	Total	75	3m4s	2s454ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	75	3m4s	1s1ms	8s24ms	2s454ms	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, manuallychangedpicktime = ?, created = ?, updated = ?, note = ? WHERE flow_report_id = ?; UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2018-08-09 13:37:01 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 06:18:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 06:19:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-06 06:19:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	8s24ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	7s927ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	6s732ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	5s547ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 06:18:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	5s349ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	4s776ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	4s628ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	4s388ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	4s385ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	3s812ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	3s471ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 06:19:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	3s448ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	3s447ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	3s300ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-06 06:19:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	3s168ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	3s168ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	3s165ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	3s161ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	3s161ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	2s997ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

9,226,846 Total read queries
6,014,776 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	9,226,846	43.67%
INSERT	864,605	4.09%
UPDATE	473,110	2.24%
DELETE	27,486	0.13%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	7	0.00%
TCL	4,649,568	22.01%
OTHERS	5,886,718	27.86%

Queries by database

Key values

pharmisight Main database
21,128,340 Requests
1h15m43s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	21,128,340	1h15m43s
	DDL	7	8ms
	DELETE	27,486	31s58ms
	INSERT	864,605	3m31s
	OTHERS	5,886,718	1m48s
	SELECT	9,226,846	54m22s
	TCL	4,649,568	2m59s
	UPDATE	473,110	12m31s

Queries by user

Key values

symmetricds Main user
17,495,296 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	5,083,472	1h5m5s
	DELETE	259	2s845ms
	INSERT	139,308	2m41s
	OTHERS	14,257	440ms
	SELECT	4,371,944	50m17s
	TCL	373,251	37s835ms
	UPDATE	184,453	11m25s
postgres	Total	4	481ms
	SELECT	4	481ms
symmetricds	Total	17,495,296	10m59s
	DDL	9	76ms
	DELETE	28,933	29s752ms
	INSERT	742,075	52s877ms
	OTHERS	6,425,469	1m58s
	SELECT	5,343,489	3m59s
	TCL	4,651,897	2m28s
	UPDATE	303,424	1m10s
tony	Total	5,973	30s515ms
	SELECT	5,973	30s515ms

Duration by user

Key values

1h5m5s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	5,083,472	1h5m5s
	DELETE	259	2s845ms
	INSERT	139,308	2m41s
	OTHERS	14,257	440ms
	SELECT	4,371,944	50m17s
	TCL	373,251	37s835ms
	UPDATE	184,453	11m25s
postgres	Total	4	481ms
	SELECT	4	481ms
symmetricds	Total	17,495,296	10m59s
	DDL	9	76ms
	DELETE	28,933	29s752ms
	INSERT	742,075	52s877ms
	OTHERS	6,425,469	1m58s
	SELECT	5,343,489	3m59s
	TCL	4,651,897	2m28s
	UPDATE	303,424	1m10s
tony	Total	5,973	30s515ms
	SELECT	5,973	30s515ms

Queries by host

Key values

10.10.10.1 Main host
22,578,768 Requests
1h16m4s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	22,578,768	1h16m4s
	DDL	9	76ms
	DELETE	29,192	32s598ms
	INSERT	881,383	3m34s
	OTHERS	6,439,726	1m58s
	SELECT	9,715,433	54m16s
	TCL	5,025,148	3m6s
	UPDATE	487,877	12m36s
::1	Total	5,973	30s515ms
	SELECT	5,973	30s515ms
[local]	Total	4	481ms
	SELECT	4	481ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
21,099,320 Requests
1h15m13s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	21,099,320	1h15m13s
	DDL	7	8ms
	DELETE	27,486	31s58ms
	INSERT	864,407	3m30s
	OTHERS	5,877,417	1m48s
	SELECT	9,207,913	53m52s
	TCL	4,648,980	2m59s
	UPDATE	473,110	12m31s
[unknown]	Total	29,020	29s857ms
	INSERT	198	108ms
	OTHERS	9,301	211ms
	SELECT	18,933	29s442ms
	TCL	588	94ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-08-06 23:10:45 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

20,612,015 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	20,612,015	97.56%
1-5ms	405,027	1.92%
5-10ms	26,269	0.12%
10-25ms	60,966	0.29%
25-50ms	20,352	0.10%
50-100ms	1,962	0.01%
100-500ms	1,669	0.01%
500-1000ms	27	0.00%
1000-10000ms	50	0.00%
> 10000ms	3	0.00%

Slowest individual queries


[ Date: 2018-08-08 07:45:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:04:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:23 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-06 06:18:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-06 06:19:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	14s50ms	SELECT orderlinea0_.ORDER_LINE_HISTORY_ID AS ORDER_L17_24_0_, orderlinea0_.ORDER_LINE_ACTIVITY_ID AS ORDER_LI1_23_0_, orderlinea0_.ORDER_LINE_ACTIVITY_ID AS ORDER_LI1_23_1_, orderlinea0_.status AS status2_23_1_, orderlinea0_.reason AS reason3_23_1_, orderlinea0_.scannedQty AS scannedQ4_23_1_, orderlinea0_.assignedQty AS assigned5_23_1_, orderlinea0_.backOrderQty AS backOrde6_23_1_, orderlinea0_.barcode AS barcode7_23_1_, orderlinea0_.barcodeDate AS barcodeD8_23_1_, orderlinea0_.barcodeBatch AS barcodeB9_23_1_, orderlinea0_.expiration AS expirat10_23_1_, orderlinea0_.cancelQty AS cancelQ11_23_1_, orderlinea0_.reducedQty AS reduced12_23_1_, orderlinea0_.misPickItemCode AS misPick13_23_1_, orderlinea0_.CREATED AS CREATED14_23_1_, orderlinea0_.missingLabels AS missing15_23_1_ FROM ORDER_LINE_ACTIVITIES orderlinea0_ WHERE orderlinea0_.ORDER_LINE_HISTORY_ID = '200001672' ORDER BY orderlinea0_.CREATED ASC; [ Date: 2018-08-08 07:45:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	11s827ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	10s620ms	UPDATE FLOW_REPORTS SET routeNumber = '9041886', roundDeliveryDate = '2018-08-08', distributionPoint = 'D Spenny', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:04:14.872', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 02:46:42', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 08:19:40.383', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 12:00:33.92', UPDATED = '2018-08-07 11:04:14.897', note = NULL WHERE FLOW_REPORT_ID = '200419562'; [ Date: 2018-08-07 11:04:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	9s284ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	8s590ms	UPDATE FLOW_REPORTS SET routeNumber = '9041886', roundDeliveryDate = '2018-08-08', distributionPoint = 'D Spenny', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:04:14.872', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 02:46:42', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 08:19:40.383', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 12:00:33.92', UPDATED = '2018-08-07 11:04:14.897', note = NULL WHERE FLOW_REPORT_ID = '200419562'; [ Date: 2018-08-07 11:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	8s419ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:23 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	8s314ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	8s297ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	8s27ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	6s936ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	6s766ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	6s437ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	6s79ms	UPDATE FLOW_REPORTS SET routeNumber = '9041886', roundDeliveryDate = '2018-08-08', distributionPoint = 'D Spenny', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:04:14.872', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 02:46:42', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 08:19:40.383', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 12:00:33.92', UPDATED = '2018-08-07 11:04:14.897', note = NULL WHERE FLOW_REPORT_ID = '200419562'; [ Date: 2018-08-07 11:04:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	6s24ms	UPDATE FLOW_REPORTS SET routeNumber = '9042065', roundDeliveryDate = '2018-08-08', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-07 11:29:00.458', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-07 10:46:18', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-07 10:33:51.089', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-07 13:00:41.046', UPDATED = '2018-08-07 11:29:00.495', note = NULL WHERE FLOW_REPORT_ID = '200419652'; [ Date: 2018-08-07 11:29:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	5s549ms	UPDATE FLOW_REPORTS SET routeNumber = '9039454', roundDeliveryDate = '2018-08-07', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-06 06:11:04.923', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-06 12:00:21.633', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200419272'; [ Date: 2018-08-06 06:18:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	5s377ms	UPDATE FLOW_REPORTS SET routeNumber = '9039461', roundDeliveryDate = '2018-08-07', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-06 06:11:02.786', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-06 12:00:33.561', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200419342'; [ Date: 2018-08-06 06:19:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	5s364ms	UPDATE FLOW_REPORTS SET routeNumber = '9046029', roundDeliveryDate = '2018-08-10', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-09 13:36:09.987', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-09 12:04:40', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-09 10:11:18.123', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-09 17:00:16.369', UPDATED = '2018-08-09 13:36:10.009', note = NULL WHERE FLOW_REPORT_ID = '200420902'; [ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	5s93ms	UPDATE FLOW_REPORTS SET routeNumber = '9046029', roundDeliveryDate = '2018-08-10', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-09 13:36:09.987', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-09 12:04:40', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-09 10:11:18.123', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-09 17:00:16.369', UPDATED = '2018-08-09 13:36:10.009', note = NULL WHERE FLOW_REPORT_ID = '200420902'; [ Date: 2018-08-09 13:37:04 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	4s780ms	UPDATE FLOW_REPORTS SET routeNumber = '9039443', roundDeliveryDate = '2018-08-07', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-06 11:44:21.511', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-06 10:33:00', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-06 10:48:55.776', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-06 13:00:09.517', UPDATED = '2018-08-06 11:44:21.533', note = NULL WHERE FLOW_REPORT_ID = '200419172'; [ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	4s645ms	UPDATE FLOW_REPORTS SET routeNumber = '9039443', roundDeliveryDate = '2018-08-07', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-08-06 11:44:21.511', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-06 10:33:00', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-08-06 10:48:55.776', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-06 13:00:09.517', UPDATED = '2018-08-06 11:44:21.533', note = NULL WHERE FLOW_REPORT_ID = '200419172'; [ Date: 2018-08-06 11:44:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 10m28s - Times executed: 16897 ]
[ User: pharmisight - Total duration: 5m4s - Times executed: 445747 ]
[ User: pharmisight - Total duration: 3m54s - Times executed: 16897 ]
[ User: pharmisight - Total duration: 3m39s - Times executed: 67588 ]
[ User: pharmisight - Total duration: 2m56s - Times executed: 41627 ]
[ User: pharmisight - Total duration: 2m45s - Times executed: 1150 ]
[ User: symmetricds - Total duration: 2m7s - Times executed: 2138337 ]
[ User: pharmisight - Total duration: 2m43s - Times executed: 4858 ]
[ User: pharmisight - Total duration: 2m14s - Times executed: 488470 ]
[ User: symmetricds - Total duration: 1m47s - Times executed: 5863816 ]
[ User: pharmisight - Total duration: 1m41s - Times executed: 1083 ]
[ User: pharmisight - Total duration: 1m29s - Times executed: 4967 ]
[ User: pharmisight - Total duration: 1m12s - Times executed: 55513 ]
[ User: pharmisight - Total duration: 1m11s - Times executed: 5618 ]
[ User: pharmisight - Total duration: 1m2s - Times executed: 315 ]
[ User: pharmisight - Total duration: 54s201ms - Times executed: 462719 ]
[ User: pharmisight - Total duration: 53s129ms - Times executed: 2350 ]
[ User: pharmisight - Total duration: 52s850ms - Times executed: 16897 ]
[ User: pharmisight - Total duration: 51s783ms - Times executed: 14611 ]
[ User: pharmisight - Total duration: 49s717ms - Times executed: 60472 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 1m47s - Times executed: 5863816 ]
[ User: symmetricds - Total duration: 34s707ms - Times executed: 2755257 ]
[ User: symmetricds - Total duration: 13s990ms - Times executed: 2138334 ]
[ User: symmetricds - Total duration: 2m7s - Times executed: 2138337 ]
[ User: symmetricds - Total duration: 36s244ms - Times executed: 645377 ]
[ User: pharmisight - Total duration: 2m14s - Times executed: 488470 ]
[ User: symmetricds - Total duration: 22s220ms - Times executed: 484204 ]
[ User: pharmisight - Total duration: 54s201ms - Times executed: 462719 ]
[ User: pharmisight - Total duration: 5m4s - Times executed: 445747 ]
[ User: symmetricds - Total duration: 12s816ms - Times executed: 429592 ]
[ User: pharmisight - Total duration: 19s252ms - Times executed: 413214 ]
[ User: symmetricds - Total duration: 7s676ms - Times executed: 359965 ]
[ User: pharmisight - Total duration: 17s842ms - Times executed: 311202 ]
[ User: pharmisight - Total duration: 18s761ms - Times executed: 311177 ]
[ User: pharmisight - Total duration: 11s279ms - Times executed: 244628 ]
[ User: pharmisight - Total duration: 8s323ms - Times executed: 177575 ]
[ User: pharmisight - Total duration: 6s859ms - Times executed: 148546 ]
[ User: symmetricds - Total duration: 26s460ms - Times executed: 127130 ]
[ User: pharmisight - Total duration: 2s812ms - Times executed: 108057 ]
[ User: symmetricds - Total duration: 5s8ms - Times executed: 101422 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 1m2s - Times executed: 315 ]
[ User: pharmisight - Total duration: 2m45s - Times executed: 1150 ]
[ User: pharmisight - Total duration: 1m41s - Times executed: 1083 ]
[ User: pharmisight - Total duration: 10m28s - Times executed: 16897 ]
[ User: pharmisight - Total duration: 2m43s - Times executed: 4858 ]
[ User: pharmisight - Total duration: 53s129ms - Times executed: 2350 ]
[ User: pharmisight - Total duration: 1m29s - Times executed: 4967 ]
[ User: pharmisight - Total duration: 3m54s - Times executed: 16897 ]
[ User: pharmisight - Total duration: 1m11s - Times executed: 5618 ]
[ User: pharmisight - Total duration: 2m56s - Times executed: 41627 ]
[ User: pharmisight - Total duration: 51s783ms - Times executed: 14611 ]
[ User: pharmisight - Total duration: 3m39s - Times executed: 67588 ]
[ User: pharmisight - Total duration: 52s850ms - Times executed: 16897 ]
[ User: pharmisight - Total duration: 1m12s - Times executed: 55513 ]
[ User: pharmisight - Total duration: 49s717ms - Times executed: 60472 ]
[ User: pharmisight - Total duration: 5m4s - Times executed: 445747 ]
[ User: pharmisight - Total duration: 2m14s - Times executed: 488470 ]
[ User: symmetricds - Total duration: 26s460ms - Times executed: 127130 ]
[ User: pharmisight - Total duration: 54s201ms - Times executed: 462719 ]
[ User: symmetricds - Total duration: 2m7s - Times executed: 2138337 ]

Log levels

Key values

66,719,361 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	106	0.00%
DETAIL	14,850,049	22.26%
ERROR	76	0.00%
FATAL	6	0.00%
LOG	51,868,967	77.74%
STATEMENT	157	0.00%

Events distribution

Key values

0 PANIC entries
6 FATAL entries
82 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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


Date: 2018-08-06 11:44:32
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-06 11:44:32
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-05 00:00:12
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
Code: 
Date: 2018-08-09 12:50:15
Database: postgres
Application: [unknown]
User: postgres
Remote: 178.128.196.88
Code: 
Date: 2018-08-08 09:42:25
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.112
Code: 
Date: 2018-08-08 09:42:25
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.112
Code: 
Date: 2018-08-08 09:42:25
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.112
Code: 
Date: 2018-08-09 12:50:14
Database: postgres
Application: [unknown]
User: postgres
Remote: 178.128.196.88
Code: 

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

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

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

Duration by user

Key values

Queries by host

Key values

Queries by application