pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Jun 16 00:00:26 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 12,044,301 log entries in 23s
Log start from 2018-06-15 00:00:00 to 2018-06-15 23:59:59

Global Stats

1,088 Number of unique normalized queries
3,701,423 Number of queries
3h9m51s Total query duration
2018-06-15 00:00:00 First query
2018-06-15 23:59:59 Last query
10,848 queries/s at 2018-06-15 05:59:19 Query peak

111 Number of events
4 Number of unique normalized events
62 Max number of times the same event was reported
0 Number of cancellation

366 Total number of automatic vacuums
566 Total number of automatic analyzes

3 Number temporary file
9.15 MiB Max size of temporary file
9.08 MiB Average size of temporary file

2,043 Total number of sessions
3 sessions at 2018-06-15 08:59:47 Session peak
12d17h28m37s Total duration of sessions
8m58s Average duration of sessions
1,811 Average queries per session
5s575ms Average queries duration per session

2,057 Total number of connections
21 connections/s at 2018-06-15 14:52:16 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,848 queries/s Query Peak
2018-06-15 05:59:19 Date

SELECT Traffic

Key values

1,448 queries/s Query Peak
2018-06-15 10:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,678 queries/s Query Peak
2018-06-15 05:59:19 Date

Queries duration

Key values

3h9m51s Total query duration

Prepared queries ratio

Key values

2.30 Ratio of bind vs prepare
134.52 % 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 15	00	104,194	0ms	84ms	0ms	89ms	287ms	1s999ms
	01	93,915	0ms	45ms	0ms	56ms	283ms	397ms
	02	91,388	0ms	92ms	0ms	59ms	167ms	408ms
	03	91,361	0ms	85ms	0ms	57ms	125ms	496ms
	04	92,216	0ms	80ms	0ms	56ms	147ms	490ms
	05	178,839	0ms	4s149ms	0ms	6s472ms	7s233ms	7s912ms
	06	195,560	0ms	19s596ms	1ms	4s926ms	1m24s	1m51s
	07	215,406	0ms	196ms	0ms	2s427ms	3s36ms	4s308ms
	08	230,045	0ms	310ms	0ms	4s203ms	4s937ms	5s936ms
	09	204,429	0ms	208ms	0ms	3s885ms	4s224ms	5s9ms
	10	224,344	0ms	1s344ms	0ms	2s737ms	3s400ms	4s285ms
	11	266,833	0ms	11s364ms	0ms	4s274ms	7s58ms	1m
	12	211,812	0ms	5s203ms	0ms	2s64ms	2s644ms	20s886ms
	13	193,102	0ms	1s239ms	0ms	2s529ms	3s232ms	3s955ms
	14	218,804	0ms	203ms	0ms	3s496ms	4s454ms	7s238ms
	15	184,219	0ms	205ms	0ms	3s913ms	4s401ms	6s566ms
	16	186,931	0ms	199ms	0ms	2s101ms	2s295ms	2s784ms
	17	171,521	0ms	8m59s	58ms	1s736ms	16s753ms	2h14m47s
	18	89,723	0ms	51ms	0ms	56ms	71ms	337ms
	19	90,036	0ms	24ms	0ms	59ms	84ms	247ms
	20	90,641	0ms	30ms	0ms	70ms	190ms	428ms
	21	91,027	0ms	28ms	0ms	62ms	86ms	353ms
	22	93,769	0ms	26ms	0ms	57ms	285ms	423ms
	23	91,308	0ms	29ms	0ms	62ms	103ms	379ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 15	00	34,335	0ms	32ms	42ms	60ms
	01	29,514	0ms	32ms	38ms	55ms
	02	29,037	0ms	33ms	37ms	41ms
	03	29,067	0ms	32ms	36ms	44ms
	04	29,246	0ms	29ms	36ms	48ms
	05	62,082	0ms	33ms	1s791ms	4s532ms
	06	102,622	0ms	1s904ms	3s306ms	4s404ms
	07	99,355	0ms	1s754ms	1s918ms	2s468ms
	08	117,998	0ms	3s191ms	3s862ms	4s829ms
	09	101,120	0ms	2s580ms	3s398ms	4s36ms
	10	109,093	0ms	2s33ms	2s471ms	3s453ms
	11	154,586	0ms	2s653ms	3s871ms	6s711ms
	12	102,436	0ms	982ms	1s665ms	2s994ms
	13	87,256	0ms	1s594ms	2s155ms	3s150ms
	14	122,709	0ms	1s560ms	3s315ms	4s416ms
	15	99,872	0ms	2s753ms	3s798ms	4s596ms
	16	98,292	0ms	1s359ms	1s784ms	2s460ms
	17	96,638	0ms	1s120ms	1s410ms	5s571ms
	18	28,684	0ms	28ms	34ms	44ms
	19	28,840	0ms	29ms	32ms	46ms
	20	30,526	0ms	30ms	39ms	169ms
	21	28,982	0ms	31ms	34ms	48ms
	22	29,556	0ms	33ms	35ms	60ms
	23	29,022	0ms	29ms	35ms	52ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 15	00	2,041	2,057	99	0ms	11ms	15ms	130ms
	01	2,581	1,241	92	0ms	1ms	9ms	128ms
	02	1,020	850	96	0ms	1ms	10ms	66ms
	03	900	820	96	0ms	1ms	10ms	65ms
	04	1,428	952	95	0ms	1ms	9ms	93ms
	05	39,047	11,487	166	0ms	20ms	1s132ms	3s72ms
	06	17,676	8,127	302	12ms	309ms	403ms	1m29s
	07	13,700	7,762	398	0ms	343ms	427ms	473ms
	08	10,692	6,739	375	0ms	225ms	280ms	425ms
	09	10,838	6,009	306	0ms	171ms	301ms	411ms
	10	13,923	7,906	413	0ms	205ms	268ms	326ms
	11	11,859	7,191	396	3ms	195ms	247ms	371ms
	12	12,324	7,473	341	1ms	175ms	234ms	345ms
	13	10,698	7,217	321	0ms	165ms	242ms	327ms
	14	7,946	5,152	306	0ms	122ms	175ms	274ms
	15	4,654	3,330	219	0ms	89ms	142ms	215ms
	16	6,070	4,285	273	0ms	92ms	114ms	203ms
	17	2,595	2,206	174	2s19ms	42ms	57ms	274ms
	18	80	600	93	0ms	1ms	2ms	11ms
	19	97	609	95	0ms	1ms	7ms	11ms
	20	1,007	830	101	0ms	1ms	9ms	62ms
	21	592	749	98	0ms	1ms	9ms	26ms
	22	2,256	1,165	98	0ms	1ms	9ms	152ms
	23	1,080	862	98	0ms	2ms	9ms	72ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jun 15	00	61,872	104,158	1.68	94.33%
	01	55,725	93,879	1.68	96.52%
	02	55,450	91,352	1.65	100.33%
	03	55,242	91,325	1.65	100.12%
	04	55,702	92,180	1.65	99.43%
	05	61,930	178,803	2.89	44.08%
	06	59,387	194,228	3.27	36.71%
	07	81,864	215,370	2.63	48.37%
	08	82,547	230,009	2.79	44.61%
	09	78,104	204,393	2.62	48.45%
	10	83,799	224,308	2.68	46.99%
	11	90,584	266,797	2.95	40.95%
	12	82,616	211,719	2.56	49.70%
	13	79,075	193,066	2.44	53.34%
	14	80,570	218,744	2.71	45.77%
	15	75,406	184,167	2.44	52.45%
	16	73,592	186,871	2.54	50.67%
	17	64,948	171,456	2.64	49.06%
	18	54,684	89,673	1.64	101.94%
	19	54,773	90,000	1.64	101.69%
	20	54,104	90,605	1.67	96.93%
	21	54,920	90,991	1.66	100.25%
	22	55,682	93,733	1.68	96.90%
	23	54,936	91,272	1.66	99.38%

Day	Hour	Count	Average / Second
Jun 15	00	79	0.02/s
	01	64	0.02/s
	02	68	0.02/s
	03	69	0.02/s
	04	70	0.02/s
	05	67	0.02/s
	06	57	0.02/s
	07	71	0.02/s
	08	85	0.02/s
	09	75	0.02/s
	10	100	0.03/s
	11	163	0.05/s
	12	73	0.02/s
	13	71	0.02/s
	14	176	0.05/s
	15	156	0.04/s
	16	79	0.02/s
	17	82	0.02/s
	18	76	0.02/s
	19	77	0.02/s
	20	86	0.02/s
	21	67	0.02/s
	22	77	0.02/s
	23	69	0.02/s

Day	Hour	Count	Average Duration
Jun 15	00	79	7m35s
	01	64	9m29s
	02	67	8m1s
	03	70	9m44s
	04	70	8m29s
	05	61	9m46s
	06	46	10m19s
	07	74	10m7s
	08	70	9m55s
	09	90	11m1s
	10	67	9m22s
	11	177	8m50s
	12	89	9m57s
	13	71	10m41s
	14	170	7m41s
	15	159	8m37s
	16	82	8m25s
	17	85	11m26s
	18	76	8m23s
	19	76	7m35s
	20	87	7m2s
	21	67	8m36s
	22	77	8m1s
	23	69	8m38s

↑ Back to the top of the General Activity table

Established Connections

Key values

21 connections Connection Peak
2018-06-15 14:52:16 Date

Connections per database

Key values

pharmisight Main Database
2,057 connections Total

Chart
Table

Database	User	Count
pharmisight		2,057
	pharmisight	957
	symmetricds	815
	tony	285

Connections per user

Key values

pharmisight Main User
2,057 connections Total

Chart
Table

User	Count
pharmisight	957
symmetricds	815
tony	285

Connections per host

Key values

10.10.10.1 Main host with 1772 connections
2,057 Total connections

Chart
Table

Host	Count
10.10.10.1	1,772
::1	285

Simultaneous sessions

Key values

3 sessions Session Peak
2018-06-15 08:59:47 Date

Histogram of session times

Key values

1,208 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	285	13.95%
500ms-1s	2	0.10%
1s-30s	6	0.29%
30s-1m	0	0.00%
1m-10m	1,208	59.13%
10m-30m	493	24.13%
30m-1h	45	2.20%
1h-8h	4	0.20%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,043 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,043	12d17h28m37s	8m58s

Sessions per user

Key values

pharmisight Main User
2,043 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	943	7d17h25m59s
symmetricds	815	5d2m22s
tony	285	15s685ms

Sessions per host

Key values

10.10.10.1 Main Host
2,043 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,758	12d17h28m21s	10m25s
::1	285	15s685ms	55ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,043 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,751	12d17h27m33s	10m28s
[unknown]	292	1m3s	217ms

Checkpoints Buffers

Key values

4,098 buffers Checkpoint Peak
2018-06-15 07:07:35 Date
150.043 seconds Highest write time
0.044 seconds Sync time

Checkpoints Wal files

Key values

3 files Wal files usage Peak
2018-06-15 06:07:35 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 15	00	2,376	237.636s	0.015s	237.703s
	01	1,583	158.567s	0.014s	158.63s
	02	1,149	115.056s	0.011s	115.111s
	03	1,037	104.014s	0.012s	104.071s
	04	1,338	134.105s	0.013s	134.161s
	05	3,564	297.609s	0.043s	297.716s
	06	6,074	648.413s	0.024s	648.478s
	07	13,732	874.065s	0.027s	874.136s
	08	6,456	649.407s	0.016s	649.478s
	09	5,535	557.351s	0.014s	557.411s
	10	6,593	671.752s	0.013s	671.812s
	11	7,535	692.101s	0.021s	692.167s
	12	6,447	645.115s	0.016s	645.173s
	13	8,330	835.075s	0.031s	835.15s
	14	4,727	473.545s	0.019s	473.604s
	15	3,726	374.752s	0.015s	374.809s
	16	6,071	506.667s	0.027s	506.741s
	17	2,788	279.026s	0.015s	279.091s
	18	1,315	131.798s	0.067s	131.908s
	19	549	55.087s	0.009s	55.135s
	20	708	71.026s	0.015s	71.082s
	21	644	64.597s	0.015s	64.649s
	22	1,092	109.57s	0.015s	109.624s
	23	1,107	110.938s	0.01s	110.99s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jun 15	00	0	1	364	0.002s	0s
	01	0	0	308	0.002s	0s
	02	0	1	304	0.002s	0s
	03	0	0	310	0.002s	0s
	04	0	1	294	0.002s	0s
	05	0	1	403	0.011s	0s
	06	1	6	855	0.002s	0s
	07	2	4	1,143	0.002s	0s
	08	0	3	1,115	0.002s	0s
	09	0	2	1,071	0.003s	0s
	10	0	3	1,156	0.001s	0s
	11	0	3	1,142	0.002s	0s
	12	0	3	1,110	0.002s	0s
	13	0	4	1,155	0.002s	0s
	14	0	1	1,043	0.002s	0s
	15	0	2	1,017	0.002s	0s
	16	0	2	1,138	0.008s	0s
	17	0	1	827	0.003s	0s
	18	0	0	264	0.033s	0.011s
	19	0	1	249	0.001s	0s
	20	0	0	317	0.002s	0s
	21	0	0	292	0.003s	0s
	22	0	0	334	0.004s	0s
	23	0	1	324	0.002s	0s

Day	Hour	Avg time (sec)
Jun 15	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 15	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

18.23 MiB Temp Files size Peak
2018-06-15 05:59:36 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-06-15 05:59:36 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 15	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	3	27.23 MiB	9.08 MiB
	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 Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

17.42 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight
2018-06-15 07:01:15 Date
12.69 sec Highest CPU-cost analyze
Table public.order_tasks
Database pharmisight
2018-06-15 06:00:15 Date

Analyzes per table

Key values

public.sym_node_communication (205) Main table analyzed (database pharmisight)
566 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	205
pharmisight.public.sym_data_gap	107
pharmisight.public.sym_sequence	105
pharmisight.public.sym_outgoing_batch	55
pharmisight.public.sym_node_channel_ctl	28
pharmisight.public.sym_incoming_batch	16
pharmisight.public.sym_data_event	12
pharmisight.public.sym_data	12
pharmisight.public.sym_lock	12
pharmisight.public.sym_node_host	6
pharmisight.public.items	4
pharmisight.public.order_tasks	1
pharmisight.public.order_rounds	1
pharmisight.public.users	1
pharmisight.public.patients	1
Total	566

Vacuums per table

Key values

public.sym_node_communication (116) Main table vacuumed on database pharmisight
366 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	116	1
pharmisight.public.sym_sequence	105	0
pharmisight.public.sym_data_gap	56	56
pharmisight.public.sym_node_channel_ctl	27	0
pharmisight.public.sym_outgoing_batch	26	26
pharmisight.public.sym_lock	11	0
pharmisight.public.sym_node_host	6	0
pharmisight.public.sym_incoming_batch	5	5
pharmisight.pg_toast.pg_toast_2619	4	4
pharmisight.public.sym_data_event	4	4
pharmisight.pg_catalog.pg_statistic	3	3
pharmisight.public.sym_data	3	3
Total	366	102

Tuples removed per table

Key values

public.sym_data_event (13288) Main table with removed tuples on database pharmisight
42643 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_event	4	4	13288	0
pharmisight.public.sym_data	3	3	6059	0
pharmisight.public.sym_outgoing_batch	26	26	5980	3
pharmisight.public.sym_sequence	105	0	5740	0
pharmisight.public.sym_node_communication	116	1	4203	0
pharmisight.public.sym_data_gap	56	56	2893	0
pharmisight.public.sym_node_channel_ctl	27	0	1452	0
pharmisight.public.sym_incoming_batch	5	5	1035	0
pharmisight.pg_catalog.pg_statistic	3	3	806	0
pharmisight.public.sym_lock	11	0	572	0
pharmisight.public.sym_node_host	6	0	315	0
pharmisight.pg_toast.pg_toast_2619	4	4	300	0
Total	366	102	42,643	3

Pages removed per table

Key values

public.sym_outgoing_batch (3) Main table with removed pages on database pharmisight
3 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_outgoing_batch	26	26	5980	3
pharmisight.public.sym_data_gap	56	56	2893	0
pharmisight.pg_toast.pg_toast_2619	4	4	300	0
pharmisight.public.sym_node_channel_ctl	27	0	1452	0
pharmisight.public.sym_node_communication	116	1	4203	0
pharmisight.public.sym_incoming_batch	5	5	1035	0
pharmisight.pg_catalog.pg_statistic	3	3	806	0
pharmisight.public.sym_data_event	4	4	13288	0
pharmisight.public.sym_data	3	3	6059	0
pharmisight.public.sym_node_host	6	0	315	0
pharmisight.public.sym_lock	11	0	572	0
pharmisight.public.sym_sequence	105	0	5740	0
Total	366	102	42,643	3

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jun 15	00	10	15
	01	5	12
	02	9	10
	03	7	10
	04	5	11
	05	11	16
	06	17	30
	07	26	41
	08	22	41
	09	21	34
	10	29	45
	11	28	43
	12	23	41
	13	23	39
	14	22	35
	15	16	24
	16	17	31
	17	13	21
	18	11	10
	19	10	10
	20	10	10
	21	9	9
	22	12	13
	23	10	15

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ExclusiveLock Main Lock Type
109 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		62	2h26m40s	2m21s
	tuple	62	2h26m40s	2m21s
ShareLock		47	26m54s	34s343ms
	transaction	47	26m54s	34s343ms
	Total	109	2h53m34s	1m35s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	25	2h29m56s	4s145ms	8m26s	5m59s	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-15 17:42:16 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	84	23m37s	1s40ms	8m59s	16s879ms	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-15 17:52:36 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	8m59s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	8m31s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	8m26s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	8m21s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	8m16s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	8m11s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	8m6s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	8m1s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	7m45s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	7m39s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	7m25s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	7m12s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	6m54s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	6m29s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	6m	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	5m45s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	5m23s	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-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	5m7s	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-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	4m59s	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-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	4m45s	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-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,680,868 Total read queries
1,069,015 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,680,868	45.41%
INSERT	175,104	4.73%
UPDATE	95,619	2.58%
DELETE	5,051	0.14%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	793,240	21.43%
OTHERS	951,540	25.71%

Queries by database

Key values

pharmisight Main database
3,701,423 Requests
3h9m51s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	3,701,423	3h9m51s
	DDL	1	60ms
	DELETE	5,051	7s104ms
	INSERT	175,104	43s69ms
	OTHERS	951,540	17s687ms
	SELECT	1,680,868	12m23s
	TCL	793,240	36s878ms
	UPDATE	95,619	2h55m43s

Queries by user

Key values

symmetricds Main user
2,766,026 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,026,772	3h7m52s
	DELETE	10	31ms
	INSERT	27,664	32s581ms
	OTHERS	2,930	95ms
	SELECT	876,271	11m41s
	TCL	82,315	8s205ms
	UPDATE	37,582	2h55m30s
symmetricds	Total	2,766,026	1m56s
	DDL	1	60ms
	DELETE	5,097	7s77ms
	INSERT	148,989	10s765ms
	OTHERS	984,504	18s297ms
	SELECT	833,376	38s483ms
	TCL	735,021	29s109ms
	UPDATE	59,038	13s75ms
tony	Total	891	4s623ms
	SELECT	891	4s623ms

Duration by user

Key values

3h7m52s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,026,772	3h7m52s
	DELETE	10	31ms
	INSERT	27,664	32s581ms
	OTHERS	2,930	95ms
	SELECT	876,271	11m41s
	TCL	82,315	8s205ms
	UPDATE	37,582	2h55m30s
symmetricds	Total	2,766,026	1m56s
	DDL	1	60ms
	DELETE	5,097	7s77ms
	INSERT	148,989	10s765ms
	OTHERS	984,504	18s297ms
	SELECT	833,376	38s483ms
	TCL	735,021	29s109ms
	UPDATE	59,038	13s75ms
tony	Total	891	4s623ms
	SELECT	891	4s623ms

Queries by host

Key values

10.10.10.1 Main host
3,792,798 Requests
3h9m49s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	3,792,798	3h9m49s
	DDL	1	60ms
	DELETE	5,107	7s108ms
	INSERT	176,653	43s346ms
	OTHERS	987,434	18s392ms
	SELECT	1,709,647	12m19s
	TCL	817,336	37s315ms
	UPDATE	96,620	2h55m43s
::1	Total	891	4s623ms
	SELECT	891	4s623ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
3,697,334 Requests
3h9m46s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	3,697,334	3h9m46s
	DDL	1	60ms
	DELETE	5,051	7s104ms
	INSERT	175,066	43s42ms
	OTHERS	949,761	17s637ms
	SELECT	1,678,714	12m18s
	TCL	793,122	36s853ms
	UPDATE	95,619	2h55m43s
[unknown]	Total	4,089	4s723ms
	INSERT	38	26ms
	OTHERS	1,779	50ms
	SELECT	2,154	4s620ms
	TCL	118	25ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-06-15 02:28:58 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

3,589,105 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	3,589,105	96.97%
1-5ms	87,283	2.36%
5-10ms	5,837	0.16%
10-25ms	13,709	0.37%
25-50ms	4,488	0.12%
50-100ms	501	0.01%
100-500ms	401	0.01%
500-1000ms	16	0.00%
1000-10000ms	48	0.00%
> 10000ms	35	0.00%

Slowest individual queries


[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	8m59s	UPDATE FLOW_REPORTS SET routeNumber = '8962066', roundDeliveryDate = '2018-06-16', distributionPoint = 'Same Day', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = NULL, packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-15 17:37:32.302', changedPickDateTime = 'f', CREATED = '2018-06-15 17:00:46.26', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200399532'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	8m31s	UPDATE FLOW_REPORTS SET routeNumber = '8962066', roundDeliveryDate = '2018-06-16', distributionPoint = 'Same Day', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-06-15 17:44:05.117', linesHeldBack = NULL, packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-15 17:37:32.302', changedPickDateTime = 'f', CREATED = '2018-06-15 17:36:46.26', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200399532'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	8m26s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:10.136', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	8m21s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:15.193', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	8m16s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:20.23', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	8m11s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:25.278', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	8m6s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:30.348', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	8m1s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:35.342', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	7m45s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:51.53', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	7m39s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:44:57.334', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	7m25s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:45:11.074', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	7m12s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:45:24.132', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	6m54s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:45:41.933', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	6m29s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:46:07.091', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	6m	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:46:36.343', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	5m46s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:46:50.841', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	5m23s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = NULL, audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:36:49.592', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = NULL, CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	5m7s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = '15364', updatedByUserName = 'Tracey Taylor', orderRoundNote = NULL, firstCheckOut = '2018-06-15 17:43:11.988', allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'Same Day', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:32.302', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = '200399532', CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = '2018-06-15 17:47:29.694', note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:52:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	4m59s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = NULL, audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:36:49.592', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '3', dlxPickedLinesQty = '0', flowReport = NULL, CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	4m46s	UPDATE ORDER_ROUNDS SET routeNumber = '8962066', uploadedByUserId = '4', uploadedByUserName = 'Neville Bosworth', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-06-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = NULL, audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-06-15 17:37:30.551', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = NULL, dlxPickedLinesQty = NULL, flowReport = NULL, CREATED = '2018-06-15 17:36:46.26', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200435562'; [ Date: 2018-06-15 17:42:16 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1h57m10s - Times executed: 48 ]
[ User: pharmisight - Total duration: 19m8s - Times executed: 88 ]
[ User: pharmisight - Total duration: 9m30s - Times executed: 22 ]
[ User: pharmisight - Total duration: 8m59s - Times executed: 7 ]
[ User: pharmisight - Total duration: 8m31s - Times executed: 3 ]
[ User: pharmisight - Total duration: 4m27s - Times executed: 107 ]
[ User: pharmisight - Total duration: 4m5s - Times executed: 1 ]
[ User: pharmisight - Total duration: 2m22s - Times executed: 3943 ]
[ User: pharmisight - Total duration: 1m49s - Times executed: 346 ]
[ User: pharmisight - Total duration: 1m6s - Times executed: 95138 ]
[ User: pharmisight - Total duration: 59s187ms - Times executed: 3943 ]
[ User: pharmisight - Total duration: 50s267ms - Times executed: 15772 ]
[ User: pharmisight - Total duration: 44s918ms - Times executed: 1483 ]
[ User: pharmisight - Total duration: 34s558ms - Times executed: 8190 ]
[ User: symmetricds - Total duration: 26s322ms - Times executed: 355472 ]
[ User: pharmisight - Total duration: 30s344ms - Times executed: 160 ]
[ User: pharmisight - Total duration: 28s587ms - Times executed: 152 ]
[ User: pharmisight - Total duration: 28s49ms - Times executed: 102798 ]
[ User: pharmisight - Total duration: 26s595ms - Times executed: 1612 ]
[ User: pharmisight - Total duration: 18s555ms - Times executed: 224 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 17s539ms - Times executed: 947046 ]
[ User: symmetricds - Total duration: 5s581ms - Times executed: 455520 ]
[ User: symmetricds - Total duration: 2s370ms - Times executed: 355471 ]
[ User: symmetricds - Total duration: 26s322ms - Times executed: 355472 ]
[ User: symmetricds - Total duration: 7s374ms - Times executed: 130582 ]
[ User: pharmisight - Total duration: 28s49ms - Times executed: 102798 ]
[ User: pharmisight - Total duration: 1m6s - Times executed: 95138 ]
[ User: pharmisight - Total duration: 10s718ms - Times executed: 91117 ]
[ User: pharmisight - Total duration: 4s66ms - Times executed: 83244 ]
[ User: symmetricds - Total duration: 3s545ms - Times executed: 76293 ]
[ User: pharmisight - Total duration: 3s130ms - Times executed: 67844 ]
[ User: symmetricds - Total duration: 2s158ms - Times executed: 66854 ]
[ User: symmetricds - Total duration: 1s220ms - Times executed: 56576 ]
[ User: pharmisight - Total duration: 1s726ms - Times executed: 36905 ]
[ User: pharmisight - Total duration: 1s479ms - Times executed: 31993 ]
[ User: symmetricds - Total duration: 6s11ms - Times executed: 28403 ]
[ User: pharmisight - Total duration: 1s537ms - Times executed: 22353 ]
[ User: pharmisight - Total duration: 1s322ms - Times executed: 21969 ]
[ User: pharmisight - Total duration: 4s351ms - Times executed: 21967 ]
[ User: pharmisight - Total duration: 575ms - Times executed: 21084 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 4m5s - Times executed: 1 ]
[ User: pharmisight - Total duration: 8m31s - Times executed: 3 ]
[ User: pharmisight - Total duration: 1h57m10s - Times executed: 48 ]
[ User: pharmisight - Total duration: 8m59s - Times executed: 7 ]
[ User: pharmisight - Total duration: 9m30s - Times executed: 22 ]
[ User: pharmisight - Total duration: 19m8s - Times executed: 88 ]
[ User: pharmisight - Total duration: 4m27s - Times executed: 107 ]
[ User: pharmisight - Total duration: 1m49s - Times executed: 346 ]
[ User: pharmisight - Total duration: 30s344ms - Times executed: 160 ]
[ User: pharmisight - Total duration: 28s587ms - Times executed: 152 ]
[ User: pharmisight - Total duration: 18s555ms - Times executed: 224 ]
[ User: pharmisight - Total duration: 2m22s - Times executed: 3943 ]
[ User: pharmisight - Total duration: 44s918ms - Times executed: 1483 ]
[ User: pharmisight - Total duration: 26s595ms - Times executed: 1612 ]
[ User: pharmisight - Total duration: 59s187ms - Times executed: 3943 ]
[ User: pharmisight - Total duration: 34s558ms - Times executed: 8190 ]
[ User: pharmisight - Total duration: 50s267ms - Times executed: 15772 ]
[ User: pharmisight - Total duration: 1m6s - Times executed: 95138 ]
[ User: pharmisight - Total duration: 28s49ms - Times executed: 102798 ]
[ User: symmetricds - Total duration: 6s11ms - Times executed: 28403 ]

Log levels

Key values

11,868,823 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	94	0.00%
DETAIL	2,853,847	24.04%
ERROR	104	0.00%
FATAL	1	0.00%
LOG	9,014,558	75.95%
STATEMENT	219	0.00%

Events distribution

Key values

0 PANIC entries
1 FATAL entries
110 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

62 Max number of times the same event was reported
111 Total events found

Rank

Times reported

Error

1

62

Details

LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jun 15	06	25
	11	10
	12	4
	17	23

LOG: process 4243 still waiting for ExclusiveLock on tuple (1290,94) of relation 142522 of database 16389 after 1000.108 ms
LOG: process 4238 still waiting for ExclusiveLock on tuple (1290,94) of relation 142522 of database 16389 after 1000.091 ms
LOG: process 4379 still waiting for ExclusiveLock on tuple (1290,94) of relation 142522 of database 16389 after 1000.123 ms

2

47

Details

LOG: process ... still waiting for ShareLock on transaction ... after ... ms

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jun 15	05	1
	06	28
	11	13
	12	2
	17	3

LOG: process 28692 still waiting for ShareLock on transaction 21245548 after 1000.156 ms
LOG: process 4254 still waiting for ShareLock on transaction 21279337 after 1000.105 ms
LOG: process 4245 still waiting for ShareLock on transaction 21279339 after 1000.069 ms

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jun 15	00	1

ERROR: relation "gp_id" does not exist at character 20

4

1

Details

FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jun 15	04	1

FATAL: no pg_hba.conf entry for host "195.201.2.148", user "postgres", database "postgres", SSL off

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