pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Jun 19 00:00:44 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 13,017,417 log entries in 42s
Log start from 2018-06-18 00:00:00 to 2018-06-18 23:59:59

Global Stats

1,326 Number of unique normalized queries
3,929,082 Number of queries
45m34s Total query duration
2018-06-18 00:00:00 First query
2018-06-18 23:59:59 Last query
10,366 queries/s at 2018-06-18 06:07:49 Query peak

156 Number of events
5 Number of unique normalized events
99 Max number of times the same event was reported
0 Number of cancellation

463 Total number of automatic vacuums
610 Total number of automatic analyzes

1 Number temporary file
9.55 MiB Max size of temporary file
9.55 MiB Average size of temporary file

2,128 Total number of sessions
4 sessions at 2018-06-18 14:08:47 Session peak
14d10h12m10s Total duration of sessions
9m45s Average duration of sessions
1,846 Average queries per session
1s284ms Average queries duration per session

2,128 Total number of connections
24 connections/s at 2018-06-18 16:05:06 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,366 queries/s Query Peak
2018-06-18 06:07:49 Date

SELECT Traffic

Key values

2,251 queries/s Query Peak
2018-06-18 08:47:52 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,346 queries/s Query Peak
2018-06-18 06:07:49 Date

Queries duration

Key values

45m34s Total query duration

Prepared queries ratio

Key values

2.40 Ratio of bind vs prepare
132.25 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 18	00	94,178	0ms	15ms	0ms	64ms	79ms	1s694ms
	01	90,780	0ms	12ms	0ms	66ms	109ms	138ms
	02	91,050	0ms	16ms	0ms	67ms	88ms	179ms
	03	90,273	0ms	12ms	0ms	60ms	91ms	108ms
	04	90,168	0ms	16ms	0ms	64ms	88ms	112ms
	05	90,308	0ms	13ms	0ms	70ms	73ms	93ms
	06	334,885	0ms	4s892ms	0ms	5s268ms	8s207ms	18s248ms
	07	200,902	0ms	257ms	0ms	1s468ms	1s804ms	2s511ms
	08	225,890	0ms	1s932ms	0ms	2s548ms	3s124ms	4s28ms
	09	291,659	0ms	7s288ms	0ms	4s884ms	5s819ms	28s19ms
	10	303,230	0ms	211ms	0ms	3s752ms	4s549ms	5s85ms
	11	301,194	0ms	1m24s	5ms	5s171ms	1m31s	19m49s
	12	283,088	0ms	1s66ms	0ms	4s579ms	5s109ms	5s944ms
	13	220,055	0ms	280ms	0ms	3s955ms	5s69ms	6s65ms
	14	190,676	0ms	6s935ms	0ms	3s279ms	3s870ms	14s536ms
	15	166,751	0ms	5s18ms	0ms	2s608ms	3s64ms	17s843ms
	16	164,899	0ms	5s145ms	0ms	2s853ms	3s578ms	11s74ms
	17	150,368	0ms	257ms	0ms	2s853ms	3s649ms	5s566ms
	18	89,958	0ms	83ms	0ms	72ms	93ms	291ms
	19	90,584	0ms	100ms	0ms	65ms	99ms	342ms
	20	90,285	0ms	174ms	0ms	108ms	206ms	384ms
	21	91,206	0ms	198ms	0ms	75ms	139ms	367ms
	22	93,981	0ms	73ms	0ms	64ms	195ms	458ms
	23	92,714	0ms	76ms	0ms	69ms	251ms	363ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 18	00	31,099	0	0ms	29ms	33ms	51ms
	01	28,965	0	0ms	32ms	39ms	43ms
	02	29,025	0	0ms	32ms	36ms	50ms
	03	28,852	0	0ms	33ms	37ms	43ms
	04	28,810	0	0ms	31ms	33ms	39ms
	05	28,694	0	0ms	28ms	33ms	43ms
	06	148,455	0	0ms	1s851ms	2s718ms	4s96ms
	07	94,733	0	0ms	761ms	1s55ms	1s451ms
	08	109,885	0	0ms	1s465ms	1s894ms	3s183ms
	09	173,342	0	0ms	2s941ms	4s436ms	5s346ms
	10	185,837	0	0ms	2s721ms	3s601ms	4s313ms
	11	187,883	0	0ms	3s228ms	4s96ms	4s957ms
	12	160,886	0	0ms	3s47ms	4s91ms	5s86ms
	13	124,911	0	0ms	3s36ms	3s753ms	5s59ms
	14	101,322	1	0ms	1s773ms	2s801ms	3s638ms
	15	81,779	0	0ms	1s125ms	2s239ms	2s900ms
	16	85,718	0	0ms	1s715ms	2s537ms	4s13ms
	17	77,702	0	0ms	1s565ms	2s668ms	3s953ms
	18	28,730	0	0ms	28ms	37ms	46ms
	19	29,022	0	0ms	32ms	33ms	57ms
	20	30,422	0	0ms	34ms	56ms	186ms
	21	29,119	0	0ms	33ms	38ms	50ms
	22	29,633	0	0ms	32ms	35ms	56ms
	23	29,417	0	0ms	32ms	34ms	58ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 18	00	541	747	75	0ms	1ms	8ms	23ms
	01	420	706	70	0ms	1ms	9ms	18ms
	02	528	734	74	0ms	1ms	9ms	20ms
	03	147	637	70	0ms	1ms	9ms	12ms
	04	131	620	69	0ms	1ms	9ms	16ms
	05	253	665	72	0ms	1ms	4ms	17ms
	06	63,827	22,304	424	0ms	527ms	1s291ms	4s137ms
	07	12,171	6,747	336	0ms	223ms	328ms	380ms
	08	13,958	7,539	357	0ms	237ms	374ms	586ms
	09	14,270	7,621	368	2ms	198ms	271ms	388ms
	10	13,592	7,293	352	0ms	196ms	252ms	375ms
	11	10,122	7,751	314	86ms	155ms	270ms	1m28s
	12	12,909	9,335	342	0ms	212ms	300ms	372ms
	13	5,840	4,587	240	0ms	84ms	117ms	209ms
	14	6,784	4,144	241	2ms	93ms	148ms	244ms
	15	5,769	4,232	214	2ms	91ms	124ms	208ms
	16	3,808	2,738	197	0ms	70ms	102ms	196ms
	17	1,360	1,748	155	0ms	23ms	53ms	131ms
	18	100	612	94	0ms	1ms	9ms	12ms
	19	126	646	97	0ms	1ms	9ms	12ms
	20	209	644	101	0ms	1ms	8ms	18ms
	21	620	757	97	0ms	1ms	9ms	40ms
	22	2,380	1,196	97	0ms	1ms	9ms	115ms
	23	1,628	1,007	93	0ms	1ms	9ms	120ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jun 18	00	56,600	94,142	1.66	98.77%
	01	55,309	90,744	1.64	101.44%
	02	55,251	91,014	1.65	100.91%
	03	54,693	90,237	1.65	101.18%
	04	54,524	90,132	1.65	101.05%
	05	53,028	90,272	1.70	98.05%
	06	91,990	334,849	3.64	32.15%
	07	77,396	199,501	2.58	49.49%
	08	84,587	225,854	2.67	46.95%
	09	86,689	291,623	3.36	35.25%
	10	88,818	303,194	3.41	34.45%
	11	90,349	301,158	3.33	35.34%
	12	94,141	283,052	3.01	39.97%
	13	77,004	220,019	2.86	43.28%
	14	77,628	190,639	2.46	52.16%
	15	74,257	166,715	2.25	58.89%
	16	70,667	164,863	2.33	56.32%
	17	64,410	150,332	2.33	57.37%
	18	54,500	89,922	1.65	101.27%
	19	55,033	90,548	1.65	101.36%
	20	53,858	90,249	1.68	97.80%
	21	55,099	91,170	1.65	100.20%
	22	55,797	93,945	1.68	96.70%
	23	55,349	92,678	1.67	97.96%

Day	Hour	Count	Average / Second
Jun 18	00	61	0.02/s
	01	75	0.02/s
	02	70	0.02/s
	03	66	0.02/s
	04	57	0.02/s
	05	34	0.01/s
	06	117	0.03/s
	07	71	0.02/s
	08	75	0.02/s
	09	106	0.03/s
	10	145	0.04/s
	11	153	0.04/s
	12	130	0.04/s
	13	109	0.03/s
	14	143	0.04/s
	15	125	0.03/s
	16	126	0.04/s
	17	102	0.03/s
	18	57	0.02/s
	19	62	0.02/s
	20	69	0.02/s
	21	57	0.02/s
	22	60	0.02/s
	23	58	0.02/s

Day	Hour	Count	Average Duration
Jun 18	00	61	9m42s
	01	75	7m57s
	02	70	8m28s
	03	66	9m22s
	04	57	9m47s
	05	34	10m37s
	06	117	10m57s
	07	71	9m29s
	08	75	7m57s
	09	106	8m54s
	10	127	10m48s
	11	156	11m33s
	12	145	10m34s
	13	109	9m44s
	14	131	9m35s
	15	110	8m59s
	16	143	8m24s
	17	112	10m
	18	57	10m40s
	19	62	10m28s
	20	69	8m32s
	21	57	10m36s
	22	60	9m46s
	23	58	9m57s

↑ Back to the top of the General Activity table

Established Connections

Key values

24 connections Connection Peak
2018-06-18 16:05:06 Date

Connections per database

Key values

pharmisight Main Database
2,128 connections Total

Chart
Table

Database	User	Count
pharmisight		2,128
	pharmisight	1,063
	symmetricds	776
	tony	289

Connections per user

Key values

pharmisight Main User
2,128 connections Total

Chart
Table

User	Count
pharmisight	1,063
symmetricds	776
tony	289

Connections per host

Key values

10.10.10.1 Main host with 1840 connections
2,128 Total connections

Chart
Table

Host	Count
10.10.10.1	1,840
::1	288

Simultaneous sessions

Key values

4 sessions Session Peak
2018-06-18 14:08:47 Date

Histogram of session times

Key values

1,180 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	289	13.58%
500ms-1s	0	0.00%
1s-30s	2	0.09%
30s-1m	0	0.00%
1m-10m	1,180	55.45%
10m-30m	579	27.21%
30m-1h	70	3.29%
1h-8h	8	0.38%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,128 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,128	14d10h12m10s	9m45s

Sessions per user

Key values

pharmisight Main User
2,128 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	1,063	9d9h51m31s
symmetricds	776	5d20m21s
tony	289	17s790ms

Sessions per host

Key values

10.10.10.1 Main Host
2,128 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,840	14d10h11m54s	11m17s
::1	288	16s185ms	56ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,128 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,838	14d10h11m43s	11m18s
[unknown]	289	25s942ms	89ms
psql	1	1s605ms	1s605ms

Checkpoints Buffers

Key values

2,831 buffers Checkpoint Peak
2018-06-18 06:08:40 Date
149.977 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-06-18 06:16:55 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
Jun 18	00	773	77.547s	0.014s	77.606s
	01	753	75.571s	0.011s	75.621s
	02	687	68.924s	0.023s	68.988s
	03	698	70.02s	0.016s	70.074s
	04	647	64.912s	0.013s	64.966s
	05	667	66.926s	0.013s	66.98s
	06	11,263	923.399s	0.038s	923.498s
	07	6,418	643.519s	0.026s	643.587s
	08	6,379	640.878s	0.019s	640.944s
	09	6,106	612.736s	0.054s	612.833s
	10	5,222	523.011s	0.032s	523.085s
	11	5,995	599.871s	0.033s	599.945s
	12	7,974	801.962s	0.042s	802.046s
	13	3,854	385.769s	0.023s	385.834s
	14	3,659	366.393s	0.027s	366.464s
	15	4,049	404.965s	0.023s	405.032s
	16	2,520	252.263s	0.02s	252.328s
	17	1,588	159.211s	0.021s	159.271s
	18	546	54.773s	0.028s	54.844s
	19	612	61.414s	0.011s	61.469s
	20	593	59.494s	0.025s	59.561s
	21	735	74.248s	0.011s	74.303s
	22	939	94.012s	0.013s	94.068s
	23	862	86.385s	0.013s	86.438s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jun 18	00	0	0	322	0.002s	0s
	01	0	0	320	0.001s	0s
	02	0	0	327	0.008s	0s
	03	0	0	322	0.002s	0s
	04	0	0	335	0.002s	0s
	05	0	1	310	0.003s	0s
	06	1	8	1,214	0.002s	0s
	07	2	0	1,074	0.002s	0s
	08	0	3	1,131	0.002s	0s
	09	0	3	1,163	0.008s	0s
	10	0	2	1,139	0.002s	0s
	11	0	2	1,127	0.002s	0s
	12	0	4	1,317	0.008s	0s
	13	0	1	1,030	0.002s	0s
	14	0	2	1,076	0.003s	0s
	15	0	1	1,017	0.002s	0s
	16	0	1	848	0.005s	0s
	17	0	1	701	0.002s	0s
	18	0	0	296	0.008s	0s
	19	0	0	299	0.002s	0s
	20	0	0	310	0.013s	0s
	21	0	0	339	0.002s	0s
	22	0	1	341	0.002s	0s
	23	0	0	343	0.002s	0s

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

Day	Hour	Mean distance	Mean estimate
Jun 18	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

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

9.55 MiB Temp Files size Peak
2018-06-18 06:07:48 Date

Number of temporary files

Key values

1 per second Temp Files Peak
2018-06-18 06:07:48 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 18	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	1	9.55 MiB	9.55 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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0.85 sec Highest CPU-cost vacuum
Table public.sym_outgoing_batch
Database pharmisight
2018-06-18 17:10:16 Date
4.09 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-06-18 10:45:08 Date

Analyzes per table

Key values

public.sym_node_communication (206) Main table analyzed (database pharmisight)
610 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	206
pharmisight.public.sym_outgoing_batch	102
pharmisight.public.sym_data_gap	100
pharmisight.public.sym_sequence	99
pharmisight.public.sym_node_channel_ctl	27
pharmisight.public.sym_incoming_batch	21
pharmisight.public.sym_data	17
pharmisight.public.sym_data_event	17
pharmisight.public.sym_lock	11
pharmisight.public.sym_node_host	5
pharmisight.public.users	1
pharmisight.public.flow_reports	1
pharmisight.public.alert_confirmations	1
pharmisight.public.tablets	1
pharmisight.public.patient_history	1
Total	610

Vacuums per table

Key values

public.sym_node_communication (205) Main table vacuumed on database pharmisight
463 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	205	0
pharmisight.public.sym_sequence	100	0
pharmisight.public.sym_data_gap	52	52
pharmisight.public.sym_outgoing_batch	52	50
pharmisight.public.sym_node_channel_ctl	26	0
pharmisight.public.sym_lock	11	0
pharmisight.public.sym_incoming_batch	7	7
pharmisight.public.sym_node_host	5	0
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.pg_catalog.pg_statistic	2	2
Total	463	114

Tuples removed per table

Key values

public.sym_node_communication (11404) Main table with removed tuples on database pharmisight
25082 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_node_communication	205	0	11404
pharmisight.public.sym_sequence	100	0	5489
pharmisight.public.sym_data_gap	52	52	2764
pharmisight.public.sym_outgoing_batch	52	50	1605
pharmisight.public.sym_node_channel_ctl	26	0	1392
pharmisight.public.sym_incoming_batch	7	7	841
pharmisight.public.sym_lock	11	0	572
pharmisight.pg_catalog.pg_statistic	2	2	525
pharmisight.public.sym_node_host	5	0	260
pharmisight.pg_toast.pg_toast_2619	3	3	230
Total	463	114	25,082

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_node_host	5	0	260
pharmisight.public.sym_lock	11	0	572
pharmisight.public.sym_incoming_batch	7	7	841
pharmisight.public.sym_node_channel_ctl	26	0	1392
pharmisight.public.sym_node_communication	205	0	11404
pharmisight.public.sym_sequence	100	0	5489
pharmisight.pg_catalog.pg_statistic	2	2	525
pharmisight.pg_toast.pg_toast_2619	3	3	230
pharmisight.public.sym_data_gap	52	52	2764
pharmisight.public.sym_outgoing_batch	52	50	1605
Total	463	114	25,082

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jun 18	00	10	13
	01	12	14
	02	9	13
	03	13	13
	04	11	11
	05	9	12
	06	46	70
	07	33	47
	08	35	50
	09	35	47
	10	30	45
	11	31	43
	12	31	43
	13	24	29
	14	21	30
	15	21	25
	16	18	24
	17	17	18
	18	9	9
	19	9	13
	20	9	7
	21	11	14
	22	11	10
	23	8	10

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
147 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		48	15m17s	19s106ms
	tuple	48	15m17s	19s106ms
ShareLock		99	12m	7s277ms
	transaction	99	12m	7s277ms
	Total	147	27m17s	11s140ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	66	19m46s	3s153ms	55s596ms	17s980ms	UPDATE order_rounds SET routenumber = ?, uploadedbyuserid = ?, uploadedbyusername = ?, updatedby = ?, updatedbyusername = ?, orderroundnote = ?, firstcheckout = ?, allordersscannedok = ?, STATUS = ?, reopenedtimes = ?, lastreopenbyid = ?, lastdonecheckin = ?, lastdonebyid = ?, lastdonebyusername = ?, missinglabels = ?, rounddeliverydate = ?, trolley = ?, stack = ?, picktime = ?, uploadupdated = ?, patientalert = ?, mismatches = ?, rxstatus = ?, distributionpoint = ?, audited = ?, auditedby = ?, auditstatus = ?, uploadfinished = ?, lastrxcompleted = ?, lastrxcompletedby = ?, orderroundnotereadby = ?, routeorderlinesqty = ?, dlxpickedlinesqty = ?, flowreport = ?, created = ?, createdby = ?, updated = ?, note = ? WHERE order_round_id = ?; UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; Date: 2018-06-18 11:46:11 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	81	7m30s	1s99ms	19s933ms	5s566ms	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, 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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; Date: 2018-06-18 09:06:33 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	55s596ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	51s946ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	51s946ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	51s21ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	50s362ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	50s349ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	50s14ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	48s862ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	47s894ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	42s308ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	42s74ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	41s622ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	41s575ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	40s743ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	40s41ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	39s843ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	39s275ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, STATUS = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	19s933ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	19s687ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	16s772ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-18 11:21:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,884,241 Total read queries
1,084,941 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,884,241	47.96%
INSERT	171,493	4.36%
UPDATE	95,010	2.42%
DELETE	4,549	0.12%
COPY FROM	0	0.00%
COPY TO	1	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	813,887	20.71%
OTHERS	959,900	24.43%

Queries by database

Key values

pharmisight Main database
3,929,082 Requests
45m34s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	3,929,082	45m34s
	COPY TO	1	1s569ms
	DDL	1	8ms
	DELETE	4,549	4s21ms
	INSERT	171,493	41s910ms
	OTHERS	959,900	17s775ms
	SELECT	1,884,241	14m28s
	TCL	813,887	35s520ms
	UPDATE	95,010	29m25s

Queries by user

Key values

symmetricds Main user
2,776,377 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,243,674	43m38s
	DELETE	30	355ms
	INSERT	25,825	31s291ms
	OTHERS	3,281	127ms
	SELECT	1,074,373	13m46s
	TCL	102,195	8s65ms
	UPDATE	37,970	29m11s
symmetricds	Total	2,776,377	1m52s
	DDL	1	8ms
	DELETE	4,578	3s668ms
	INSERT	146,856	10s830ms
	OTHERS	992,889	18s357ms
	SELECT	838,062	37s930ms
	TCL	736,040	27s882ms
	UPDATE	57,951	13s507ms
tony	Total	901	6s214ms
	COPY TO	1	1s569ms
	SELECT	900	4s644ms

Duration by user

Key values

43m38s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,243,674	43m38s
	DELETE	30	355ms
	INSERT	25,825	31s291ms
	OTHERS	3,281	127ms
	SELECT	1,074,373	13m46s
	TCL	102,195	8s65ms
	UPDATE	37,970	29m11s
symmetricds	Total	2,776,377	1m52s
	DDL	1	8ms
	DELETE	4,578	3s668ms
	INSERT	146,856	10s830ms
	OTHERS	992,889	18s357ms
	SELECT	838,062	37s930ms
	TCL	736,040	27s882ms
	UPDATE	57,951	13s507ms
tony	Total	901	6s214ms
	COPY TO	1	1s569ms
	SELECT	900	4s644ms

Queries by host

Key values

10.10.10.1 Main host
4,020,052 Requests
45m32s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	4,020,052	45m32s
	COPY TO	1	1s569ms
	DDL	1	8ms
	DELETE	4,608	4s24ms
	INSERT	172,681	42s121ms
	OTHERS	996,170	18s485ms
	SELECT	1,912,435	14m24s
	TCL	838,235	35s947ms
	UPDATE	95,921	29m25s
::1	Total	900	4s644ms
	SELECT	900	4s644ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
3,925,014 Requests
45m27s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	3,925,014	45m27s
	DDL	1	8ms
	DELETE	4,549	4s21ms
	INSERT	171,459	41s895ms
	OTHERS	958,060	17s724ms
	SELECT	1,882,122	14m23s
	TCL	813,813	35s510ms
	UPDATE	95,010	29m25s
[unknown]	Total	4,067	4s672ms
	INSERT	34	15ms
	OTHERS	1,840	51ms
	SELECT	2,119	4s594ms
	TCL	74	10ms
psql	Total	1	1s569ms
	COPY TO	1	1s569ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-06-18 07:30:09 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

3,811,923 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	3,811,923	97.02%
1-5ms	90,696	2.31%
5-10ms	5,923	0.15%
10-25ms	14,184	0.36%
25-50ms	5,378	0.14%
50-100ms	547	0.01%
100-500ms	361	0.01%
500-1000ms	2	0.00%
1000-10000ms	32	0.00%
> 10000ms	36	0.00%

Slowest individual queries


[ Date: 2018-06-18 11:46:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:22:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:21:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-18 11:21:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	1m24s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	1m19s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	1m18s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	1m18s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	1m17s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	1m16s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	1m11s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	1m10s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	1m9s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	1m7s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	1m6s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1m5s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	1m4s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	1m4s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	1m3s	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	55s602ms	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	53s201ms	UPDATE ORDER_ROUNDS SET routeNumber = '8962365', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-18 09:37:51.405', allOrdersScannedOK = 't', STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = '2018-06-18 11:44:40.861', lastDoneById = '15364', lastDoneByUserName = 'Taylor Tracey', missingLabels = NULL, roundDeliveryDate = '2018-06-19', trolley = '10', stack = '10', picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Ed Didcott', audited = '2018-06-18 11:24:20.962', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-06-18 11:24:04.167', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '917', dlxPickedLinesQty = '917', flowReport = '200399832', CREATED = '2018-06-18 06:04:51.117', createdBy = NULL, UPDATED = '2018-06-18 11:44:40.861', note = NULL WHERE ORDER_ROUND_ID = '200435882'; [ Date: 2018-06-18 11:46:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	32s933ms	UPDATE FLOW_REPORTS SET routeNumber = '8962363', roundDeliveryDate = '2018-06-19', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-18 10:59:32', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-18 06:10:45.305', changedPickDateTime = 'f', CREATED = '2018-06-18 11:30:59.446', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200399812'; [ Date: 2018-06-18 11:22:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	25s738ms	UPDATE FLOW_REPORTS SET routeNumber = '8962363', roundDeliveryDate = '2018-06-19', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-18 10:59:32', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-18 06:10:45.305', changedPickDateTime = 'f', CREATED = '2018-06-18 11:30:59.446', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200399812'; [ Date: 2018-06-18 11:21:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	24s	UPDATE FLOW_REPORTS SET routeNumber = '8962363', roundDeliveryDate = '2018-06-19', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-18 10:59:32', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-18 06:10:45.305', changedPickDateTime = 'f', CREATED = '2018-06-18 11:30:59.446', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200399812'; [ Date: 2018-06-18 11:21:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 19m47s - Times executed: 104 ]
[ User: pharmisight - Total duration: 7m - Times executed: 449 ]
[ User: pharmisight - Total duration: 3m3s - Times executed: 4941 ]
[ User: pharmisight - Total duration: 1m46s - Times executed: 158179 ]
[ User: pharmisight - Total duration: 1m9s - Times executed: 4942 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 19764 ]
[ User: pharmisight - Total duration: 59s567ms - Times executed: 1946 ]
[ User: pharmisight - Total duration: 45s769ms - Times executed: 169362 ]
[ User: symmetricds - Total duration: 25s94ms - Times executed: 355854 ]
[ User: pharmisight - Total duration: 31s280ms - Times executed: 1980 ]
[ User: pharmisight - Total duration: 22s438ms - Times executed: 126 ]
[ User: pharmisight - Total duration: 21s640ms - Times executed: 4993 ]
[ User: pharmisight - Total duration: 19s475ms - Times executed: 237 ]
[ User: pharmisight - Total duration: 19s257ms - Times executed: 57 ]
[ User: symmetricds - Total duration: 17s599ms - Times executed: 955160 ]
[ User: pharmisight - Total duration: 16s199ms - Times executed: 393 ]
[ User: pharmisight - Total duration: 15s862ms - Times executed: 1207 ]
[ User: pharmisight - Total duration: 15s543ms - Times executed: 4941 ]
[ User: pharmisight - Total duration: 12s506ms - Times executed: 71 ]
[ User: pharmisight - Total duration: 12s24ms - Times executed: 81 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 17s599ms - Times executed: 955160 ]
[ User: symmetricds - Total duration: 5s575ms - Times executed: 456931 ]
[ User: symmetricds - Total duration: 2s374ms - Times executed: 355856 ]
[ User: symmetricds - Total duration: 25s94ms - Times executed: 355854 ]
[ User: pharmisight - Total duration: 45s769ms - Times executed: 169362 ]
[ User: pharmisight - Total duration: 1m46s - Times executed: 158179 ]
[ User: symmetricds - Total duration: 7s261ms - Times executed: 127940 ]
[ User: pharmisight - Total duration: 4s106ms - Times executed: 90743 ]
[ User: pharmisight - Total duration: 9s782ms - Times executed: 84306 ]
[ User: symmetricds - Total duration: 3s587ms - Times executed: 77089 ]
[ User: pharmisight - Total duration: 3s651ms - Times executed: 76183 ]
[ User: symmetricds - Total duration: 1s919ms - Times executed: 62848 ]
[ User: symmetricds - Total duration: 1s247ms - Times executed: 57168 ]
[ User: pharmisight - Total duration: 2s565ms - Times executed: 55780 ]
[ User: pharmisight - Total duration: 2s123ms - Times executed: 46798 ]
[ User: pharmisight - Total duration: 8s47ms - Times executed: 32065 ]
[ User: pharmisight - Total duration: 2s229ms - Times executed: 32065 ]
[ User: pharmisight - Total duration: 7s531ms - Times executed: 30644 ]
[ User: symmetricds - Total duration: 5s373ms - Times executed: 26313 ]
[ User: pharmisight - Total duration: 2s46ms - Times executed: 21321 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 19m47s - Times executed: 104 ]
[ User: pharmisight - Total duration: 7m - Times executed: 449 ]
[ User: pharmisight - Total duration: 19s257ms - Times executed: 57 ]
[ User: pharmisight - Total duration: 22s438ms - Times executed: 126 ]
[ User: pharmisight - Total duration: 12s506ms - Times executed: 71 ]
[ User: pharmisight - Total duration: 12s24ms - Times executed: 81 ]
[ User: pharmisight - Total duration: 19s475ms - Times executed: 237 ]
[ User: pharmisight - Total duration: 16s199ms - Times executed: 393 ]
[ User: pharmisight - Total duration: 3m3s - Times executed: 4941 ]
[ User: pharmisight - Total duration: 59s567ms - Times executed: 1946 ]
[ User: pharmisight - Total duration: 31s280ms - Times executed: 1980 ]
[ User: pharmisight - Total duration: 1m9s - Times executed: 4942 ]
[ User: pharmisight - Total duration: 15s862ms - Times executed: 1207 ]
[ User: pharmisight - Total duration: 21s640ms - Times executed: 4993 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 19764 ]
[ User: pharmisight - Total duration: 15s543ms - Times executed: 4941 ]
[ User: pharmisight - Total duration: 1m46s - Times executed: 158179 ]
[ User: pharmisight - Total duration: 45s769ms - Times executed: 169362 ]
[ User: pharmisight - Total duration: 8s47ms - Times executed: 32065 ]
[ User: pharmisight - Total duration: 7s531ms - Times executed: 30644 ]

Log levels

Key values

12,740,481 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	198	0.00%
DETAIL	3,240,045	25.43%
ERROR	150	0.00%
HINT	3	0.00%
LOG	9,499,779	74.56%
STATEMENT	306	0.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
156 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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


Date: 2018-06-18 11:41:37
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-18 11:41:37
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-18 11:21:35
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-18 11:21:35
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-18 00:00:10
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
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