pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jul 5 00:00:27 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 13,522,305 log entries in 25s
Log start from 2018-07-04 00:00:00 to 2018-07-04 23:59:59

Global Stats

1,245 Number of unique normalized queries
4,029,070 Number of queries
1d2h40m51s Total query duration
2018-07-04 00:00:00 First query
2018-07-04 23:59:59 Last query
8,846 queries/s at 2018-07-04 05:57:11 Query peak

1,329 Number of events
8 Number of unique normalized events
789 Max number of times the same event was reported
0 Number of cancellation

813 Total number of automatic vacuums
527 Total number of automatic analyzes

3 Number temporary file
20.62 MiB Max size of temporary file
10.32 MiB Average size of temporary file

1,992 Total number of sessions
3 sessions at 2018-07-04 11:35:15 Session peak
14d1h3m27s Total duration of sessions
10m9s Average duration of sessions
2,022 Average queries per session
48s218ms Average queries duration per session

1,992 Total number of connections
25 connections/s at 2018-07-04 10:52:34 Connection peak
2 Total number of databases

SQL Traffic

Key values

8,846 queries/s Query Peak
2018-07-04 05:57:11 Date

SELECT Traffic

Key values

1,906 queries/s Query Peak
2018-07-04 09:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

8,735 queries/s Query Peak
2018-07-04 05:57:11 Date

Queries duration

Key values

1d2h40m51s Total query duration

Prepared queries ratio

Key values

2.40 Ratio of bind vs prepare
132.45 % 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)
Jul 04	00	105,084	0ms	17ms	0ms	88ms	213ms	1s857ms
	01	94,636	0ms	15ms	0ms	72ms	310ms	323ms
	02	93,271	0ms	15ms	0ms	72ms	213ms	330ms
	03	93,504	0ms	14ms	0ms	71ms	153ms	374ms
	04	94,708	0ms	15ms	0ms	72ms	219ms	393ms
	05	206,224	0ms	1s525ms	0ms	12s927ms	16s866ms	19s182ms
	06	350,333	0ms	5m9s	26ms	9m25s	22m32s	47m8s
	07	251,481	0ms	1s631ms	0ms	2s104ms	2s273ms	2s678ms
	08	267,265	0ms	48s111ms	0ms	5s470ms	8s845ms	1m
	09	255,125	0ms	30m59s	22ms	3s857ms	16m7s	56m20s
	10	251,593	0ms	1h25m9s	318ms	6s483ms	25s609ms	19h34m23s
	11	263,729	0ms	8s365ms	0ms	4s24ms	9s797ms	13s860ms
	12	200,037	0ms	3s59ms	0ms	4s389ms	6s263ms	7s259ms
	13	290,600	0ms	671ms	0ms	4s340ms	5s6ms	11s114ms
	14	143,131	0ms	2s148ms	0ms	1s500ms	2s25ms	6s866ms
	15	163,424	0ms	197ms	0ms	3s454ms	4s252ms	7s279ms
	16	187,498	0ms	264ms	0ms	3s299ms	4s542ms	11s919ms
	17	153,048	0ms	964ms	0ms	2s713ms	4s519ms	7s885ms
	18	92,335	0ms	22ms	0ms	65ms	84ms	285ms
	19	92,182	0ms	19ms	0ms	64ms	93ms	233ms
	20	93,983	0ms	18ms	0ms	72ms	213ms	455ms
	21	94,309	0ms	18ms	0ms	62ms	118ms	374ms
	22	97,216	0ms	40ms	0ms	68ms	403ms	579ms
	23	94,354	0ms	26ms	0ms	64ms	144ms	313ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 04	00	35,582	0ms	31ms	39ms	181ms
	01	31,179	0ms	32ms	35ms	63ms
	02	30,961	0ms	32ms	36ms	69ms
	03	31,003	0ms	32ms	34ms	105ms
	04	31,223	0ms	31ms	35ms	89ms
	05	74,525	1ms	55ms	8s772ms	11s778ms
	06	210,680	0ms	4s76ms	7s453ms	10s480ms
	07	127,047	0ms	1s272ms	1s546ms	2s168ms
	08	147,446	0ms	3s182ms	4s777ms	8s376ms
	09	139,026	0ms	2s361ms	2s935ms	4s31ms
	10	138,893	0ms	2s394ms	4s151ms	9s713ms
	11	147,368	0ms	1s982ms	3s671ms	11s843ms
	12	100,408	0ms	679ms	2s931ms	5s980ms
	13	180,329	0ms	3s258ms	3s957ms	8s822ms
	14	63,722	0ms	149ms	1s323ms	2s214ms
	15	85,010	0ms	1s232ms	3s268ms	4s855ms
	16	105,174	0ms	1s995ms	3s13ms	5s57ms
	17	82,559	0ms	1s726ms	2s668ms	4s316ms
	18	30,782	0ms	28ms	34ms	66ms
	19	30,764	0ms	29ms	33ms	51ms
	20	32,724	0ms	33ms	36ms	180ms
	21	31,221	0ms	32ms	34ms	54ms
	22	31,638	0ms	28ms	37ms	77ms
	23	31,198	0ms	29ms	33ms	51ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 04	00	2,746	2,066	105	0ms	9ms	13ms	126ms
	01	1,723	1,025	107	0ms	1ms	9ms	90ms
	02	867	812	108	0ms	1ms	10ms	52ms
	03	888	819	105	0ms	1ms	9ms	63ms
	04	1,646	1,011	109	0ms	1ms	10ms	96ms
	05	47,039	14,153	223	0ms	36ms	1s507ms	3s740ms
	06	22,743	11,125	473	265ms	502ms	801ms	22m31s
	07	16,233	8,263	422	0ms	291ms	343ms	421ms
	08	13,248	7,606	407	3ms	254ms	377ms	635ms
	09	9,995	5,637	318	355ms	196ms	275ms	16m5s
	10	9,256	6,245	294	5s64ms	131ms	297ms	24s579ms
	11	12,642	7,740	338	0ms	181ms	257ms	402ms
	12	10,665	6,481	265	0ms	167ms	284ms	439ms
	13	13,710	7,216	380	0ms	225ms	254ms	397ms
	14	5,123	3,287	222	1ms	73ms	115ms	246ms
	15	3,333	2,787	218	0ms	67ms	104ms	162ms
	16	3,850	3,253	249	0ms	69ms	105ms	182ms
	17	1,278	1,657	165	1ms	25ms	49ms	133ms
	18	117	625	108	0ms	1ms	7ms	13ms
	19	117	624	105	0ms	1ms	7ms	12ms
	20	1,345	942	115	0ms	1ms	10ms	96ms
	21	1,240	912	109	0ms	1ms	8ms	54ms
	22	3,327	1,431	110	0ms	1ms	9ms	169ms
	23	1,264	918	110	0ms	3ms	9ms	72ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jul 04	00	60,701	105,048	1.73	90.52%
	01	55,439	94,600	1.71	94.93%
	02	55,421	93,235	1.68	97.09%
	03	55,119	93,468	1.70	96.32%
	04	55,964	94,672	1.69	95.82%
	05	66,280	206,188	3.11	39.90%
	06	98,410	348,903	3.55	32.87%
	07	94,110	251,445	2.67	46.91%
	08	86,992	267,229	3.07	39.48%
	09	97,344	255,075	2.62	48.10%
	10	95,370	251,557	2.64	47.58%
	11	95,542	263,531	2.76	44.60%
	12	79,485	200,001	2.52	50.92%
	13	84,992	290,555	3.42	34.59%
	14	66,801	143,069	2.14	64.52%
	15	68,525	163,388	2.38	55.41%
	16	69,971	187,421	2.68	47.63%
	17	62,500	152,994	2.45	54.36%
	18	55,185	92,285	1.67	98.50%
	19	54,817	92,146	1.68	97.98%
	20	54,752	93,947	1.72	93.10%
	21	55,523	94,273	1.70	95.82%
	22	55,066	97,180	1.76	90.38%
	23	55,499	94,318	1.70	95.73%

Day	Hour	Count	Average / Second
Jul 04	00	70	0.02/s
	01	61	0.02/s
	02	64	0.02/s
	03	62	0.02/s
	04	71	0.02/s
	05	83	0.02/s
	06	99	0.03/s
	07	79	0.02/s
	08	98	0.03/s
	09	88	0.02/s
	10	144	0.04/s
	11	119	0.03/s
	12	98	0.03/s
	13	120	0.03/s
	14	68	0.02/s
	15	87	0.02/s
	16	83	0.02/s
	17	88	0.02/s
	18	77	0.02/s
	19	69	0.02/s
	20	77	0.02/s
	21	68	0.02/s
	22	57	0.02/s
	23	62	0.02/s

Day	Hour	Count	Average Duration
Jul 04	00	70	8m8s
	01	61	10m28s
	02	64	9m6s
	03	62	10m24s
	04	71	8m35s
	05	59	9m27s
	06	122	12m51s
	07	77	8m22s
	08	87	8m20s
	09	77	8m7s
	10	169	18m11s
	11	107	7m4s
	12	107	8m58s
	13	123	10m58s
	14	68	12m2s
	15	83	8m50s
	16	78	10m10s
	17	97	9m57s
	18	77	7m45s
	19	69	8m18s
	20	77	8m7s
	21	68	8m45s
	22	57	10m10s
	23	62	10m5s

↑ Back to the top of the General Activity table

Established Connections

Key values

25 connections Connection Peak
2018-07-04 10:52:34 Date

Connections per database

Key values

pharmisight Main Database
1,992 connections Total

Chart
Table

Database	User	Count
pharmisight		1,991
	pharmisight	882
	symmetricds	820
	tony	289
postgres		1
	tony	1

Connections per user

Key values

pharmisight Main User
1,992 connections Total

Chart
Table

User	Count
pharmisight	882
symmetricds	820
tony	290

Connections per host

Key values

10.10.10.1 Main host with 1702 connections
1,992 Total connections

Chart
Table

Host	Count
10.10.10.1	1,702
93.89.137.51	2
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2018-07-04 11:35:15 Date

Histogram of session times

Key values

1,070 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	289	14.51%
500ms-1s	1	0.05%
1s-30s	7	0.35%
30s-1m	0	0.00%
1m-10m	1,070	53.71%
10m-30m	539	27.06%
30m-1h	69	3.46%
1h-8h	17	0.85%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,992 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,991	13d22h32m38s	10m4s
postgres	1	2h30m49s	2h30m49s

Sessions per user

Key values

pharmisight Main User
1,992 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	882	8d21h32m25s
symmetricds	820	5d58m55s
tony	290	2h32m7s

Sessions per host

Key values

10.10.10.1 Main Host
1,992 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,702	13d22h31m20s	11m47s
93.89.137.51	2	2h31m50s	1h15m55s
::1	288	16s73ms	55ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,992 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,695	13d22h30m30s	11m50s
[unknown]	295	1m6s	224ms
pgAdmin III - Browser	2	2h31m50s	1h15m55s

Checkpoints Buffers

Key values

3,993 buffers Checkpoint Peak
2018-07-04 07:06:52 Date
149.929 seconds Highest write time
0.033 seconds Sync time

Checkpoints Wal files

Key values

3 files Wal files usage Peak
2018-07-04 06:09:45 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
Jul 04	00	1,984	198.841s	0.013s	198.892s
	01	842	84.46s	0.017s	84.517s
	02	853	85.56s	0.016s	85.617s
	03	768	76.945s	0.013s	77s
	04	958	96.094s	0.013s	96.154s
	05	3,791	216.361s	0.054s	216.461s
	06	10,080	977.028s	0.039s	977.118s
	07	10,276	779.257s	0.034s	779.332s
	08	7,501	652.229s	0.03s	652.309s
	09	7,016	716.518s	0.046s	716.614s
	10	7,911	732.72s	0.025s	732.786s
	11	8,772	704.786s	0.032s	704.865s
	12	7,099	718.756s	0.02s	718.816s
	13	6,755	676.776s	0.03s	676.854s
	14	3,195	319.922s	0.018s	319.983s
	15	2,663	266.806s	0.018s	266.864s
	16	4,589	413.576s	0.029s	413.642s
	17	1,640	164.301s	0.014s	164.359s
	18	585	58.578s	0.014s	58.633s
	19	538	53.965s	0.023s	54.03s
	20	772	77.445s	0.015s	77.498s
	21	727	72.937s	0.017s	72.993s
	22	1,190	119.065s	0.012s	119.117s
	23	995	99.715s	0.024s	99.781s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jul 04	00	0	0	304	0.002s	0s
	01	0	1	261	0.002s	0s
	02	0	0	255	0.002s	0s
	03	0	0	257	0.002s	0s
	04	0	0	268	0.002s	0s
	05	0	1	372	0.010s	0s
	06	2	8	1,285	0.008s	0s
	07	1	3	1,170	0.002s	0s
	08	0	3	1,098	0.002s	0s
	09	0	3	1,135	0.018s	0s
	10	0	3	1,237	0.002s	0s
	11	0	3	1,281	0.005s	0s
	12	0	3	1,064	0.002s	0s
	13	0	3	1,251	0.002s	0s
	14	0	1	856	0.003s	0s
	15	0	1	879	0.002s	0s
	16	0	1	979	0.008s	0s
	17	0	1	699	0.002s	0s
	18	0	0	232	0.002s	0s
	19	0	0	238	0.008s	0s
	20	0	0	298	0.002s	0s
	21	0	0	318	0.007s	0s
	22	0	1	344	0.001s	0s
	23	0	0	331	0.008s	0s

Day	Hour	Avg time (sec)
Jul 04	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
Jul 04	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

20.70 MiB Temp Files size Peak
2018-07-04 05:57:30 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-07-04 05:57:30 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 04	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	3	30.95 MiB	10.32 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

13.58 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight
2018-07-04 06:01:10 Date
8.55 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-07-04 05:58:05 Date

Analyzes per table

Key values

public.sym_node_communication (200) Main table analyzed (database pharmisight)
527 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	200
pharmisight.public.sym_data_gap	98
pharmisight.public.sym_sequence	90
pharmisight.public.sym_outgoing_batch	52
pharmisight.public.sym_node_channel_ctl	24
pharmisight.public.sym_incoming_batch	17
pharmisight.public.sym_data	13
pharmisight.public.sym_data_event	12
pharmisight.public.sym_lock	11
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	3
pharmisight.public.users	1
Total	527

Vacuums per table

Key values

public.sym_node_communication (275) Main table vacuumed on database pharmisight
813 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	275	1
pharmisight.public.sym_sequence	172	2
pharmisight.public.sym_data_gap	132	49
pharmisight.public.sym_outgoing_batch	91	25
pharmisight.public.sym_node_channel_ctl	79	1
pharmisight.pg_catalog.pg_statistic	30	5
pharmisight.public.sym_lock	11	0
pharmisight.public.sym_incoming_batch	7	7
pharmisight.public.sym_node_host	5	0
pharmisight.public.sym_data	4	4
pharmisight.public.sym_data_event	3	3
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.public.item_codes	1	1
Total	813	101

Tuples removed per table

Key values

public.sym_node_communication (10665) Main table with removed tuples on database pharmisight
38984 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_node_communication	275	1	10665	4
pharmisight.public.sym_outgoing_batch	91	25	7144	3
pharmisight.public.sym_data	4	4	6373	2657
pharmisight.public.sym_sequence	172	2	4386	0
pharmisight.public.sym_data_event	3	3	2902	472
pharmisight.public.sym_data_gap	132	49	2465	3
pharmisight.public.sym_incoming_batch	7	7	1367	0
pharmisight.pg_catalog.pg_statistic	30	5	1267	0
pharmisight.public.sym_node_channel_ctl	79	1	1174	0
pharmisight.public.sym_lock	11	0	542	0
pharmisight.public.sym_node_host	5	0	261	0
pharmisight.public.item_codes	1	1	221	0
pharmisight.pg_toast.pg_toast_2619	3	3	217	0
Total	813	101	38,984	3,139

Pages removed per table

Key values

public.sym_data (2657) Main table with removed pages on database pharmisight
3139 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data	4	4	6373	2657
pharmisight.public.sym_data_event	3	3	2902	472
pharmisight.public.sym_node_communication	275	1	10665	4
pharmisight.public.sym_data_gap	132	49	2465	3
pharmisight.public.sym_outgoing_batch	91	25	7144	3
pharmisight.pg_catalog.pg_statistic	30	5	1267	0
pharmisight.public.sym_node_host	5	0	261	0
pharmisight.public.item_codes	1	1	221	0
pharmisight.public.sym_sequence	172	2	4386	0
pharmisight.public.sym_incoming_batch	7	7	1367	0
pharmisight.public.sym_node_channel_ctl	79	1	1174	0
pharmisight.pg_toast.pg_toast_2619	3	3	217	0
pharmisight.public.sym_lock	11	0	542	0
Total	813	101	38,984	3,139

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 04	00	12	14
	01	10	11
	02	10	10
	03	12	13
	04	10	14
	05	16	19
	06	34	42
	07	32	43
	08	37	42
	09	247	27
	10	171	24
	11	29	38
	12	25	32
	13	34	40
	14	16	26
	15	20	22
	16	22	27
	17	17	18
	18	9	11
	19	10	11
	20	9	10
	21	10	10
	22	13	13
	23	8	10

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
538 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		173	15h9m6s	5m15s
	tuple	173	15h9m6s	5m15s
ShareLock		365	11h11m57s	1m50s
	transaction	365	11h11m57s	1m50s
	Total	538	1d2h21m4s	2m56s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	214	20h23m8s	1s	1h21m2s	5m42s	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-07-04 09:33:52 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	321	5h35m9s	1s660ms	26m21s	1m2s	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-07-04 09:33:52 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
3	2	22m42s	1s15ms	22m41s	11m21s	UPDATE "public"."order_rounds" SET "audited" = ?, "auditedby" = ?, "auditstatus" = ? WHERE "order_round_id" = ?; UPDATE "public"."order_rounds" SET "audited" = $1, "auditedby" = $2, "auditstatus" = $3 WHERE "order_round_id" = $4; Date: 2018-07-04 10:26:00 Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
4	1	3s625ms	3s625ms	3s625ms	3s625ms	UPDATE "public"."order_rounds" SET "dlxpickedlinesqty" = ? WHERE "order_round_id" = ?; UPDATE "public"."order_rounds" SET "dlxpickedlinesqty" = $1 WHERE "order_round_id" = $2; Date: 2018-07-04 10:26:24 Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	1h21m2s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	1h20m10s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	1h20m5s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	1h17m43s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	1h17m38s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	53m21s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	53m18s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	26m21s	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-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	26m21s	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-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	25m46s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	25m45s	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-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	23m10s	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-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	23m10s	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-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,950,462 Total read queries
1,089,683 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,950,462	48.41%
INSERT	184,395	4.58%
UPDATE	96,635	2.40%
DELETE	5,165	0.13%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	1	0.00%
DDL	1	0.00%
TCL	803,486	19.94%
OTHERS	988,925	24.54%

Queries by database

Key values

pharmisight Main database
4,029,034 Requests
1d2h40m50s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	4,029,034	1d2h40m50s
	CTE	1	9ms
	DDL	1	1ms
	DELETE	5,165	7s4ms
	INSERT	184,395	55s971ms
	OTHERS	988,923	17s639ms
	SELECT	1,950,428	16m51s
	TCL	803,486	33s971ms
	UPDATE	96,635	1d2h22m5s
postgres	Total	36	212ms
	OTHERS	2	22ms
	SELECT	34	189ms

Queries by user

Key values

symmetricds Main user
2,848,182 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,223,270	1d2h16m3s
	DELETE	55	982ms
	INSERT	28,825	43s861ms
	OTHERS	2,669	109ms
	SELECT	1,078,511	16m4s
	TCL	73,792	7s900ms
	UPDATE	39,418	1d1h59m5s
symmetricds	Total	2,848,182	24m42s
	DDL	1	1ms
	DELETE	5,139	6s24ms
	INSERT	156,206	12s242ms
	OTHERS	1,002,553	17s822ms
	SELECT	886,043	41s117ms
	TCL	740,608	26s239ms
	UPDATE	57,632	22m59s
tony	Total	963	6s198ms
	CTE	1	9ms
	OTHERS	5	24ms
	SELECT	957	6s164ms

Duration by user

Key values

1d2h16m3s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,223,270	1d2h16m3s
	DELETE	55	982ms
	INSERT	28,825	43s861ms
	OTHERS	2,669	109ms
	SELECT	1,078,511	16m4s
	TCL	73,792	7s900ms
	UPDATE	39,418	1d1h59m5s
symmetricds	Total	2,848,182	24m42s
	DDL	1	1ms
	DELETE	5,139	6s24ms
	INSERT	156,206	12s242ms
	OTHERS	1,002,553	17s822ms
	SELECT	886,043	41s117ms
	TCL	740,608	26s239ms
	UPDATE	57,632	22m59s
tony	Total	963	6s198ms
	CTE	1	9ms
	OTHERS	5	24ms
	SELECT	957	6s164ms

Queries by host

Key values

10.10.10.1 Main host
4,071,452 Requests
1d2h40m46s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	4,071,452	1d2h40m46s
	DDL	1	1ms
	DELETE	5,194	7s7ms
	INSERT	185,031	56s104ms
	OTHERS	1,005,222	17s932ms
	SELECT	1,964,554	16m46s
	TCL	814,400	34s140ms
	UPDATE	97,050	1d2h22m5s
93.89.137.51	Total	84	1s675ms
	CTE	1	9ms
	OTHERS	5	24ms
	SELECT	78	1s640ms
::1	Total	879	4s523ms
	SELECT	879	4s523ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
4,024,833 Requests
1d2h40m44s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	4,024,833	1d2h40m44s
	DDL	1	1ms
	DELETE	5,165	7s4ms
	INSERT	184,350	55s946ms
	OTHERS	987,211	17s596ms
	SELECT	1,948,117	16m45s
	TCL	803,354	33s934ms
	UPDATE	96,635	1d2h22m5s
[unknown]	Total	4,153	4s761ms
	INSERT	45	24ms
	OTHERS	1,709	40ms
	SELECT	2,267	4s658ms
	TCL	132	37ms
pgAdmin III - Browser	Total	84	1s675ms
	CTE	1	9ms
	OTHERS	5	24ms
	SELECT	78	1s640ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-07-04 19:37:33 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

3,852,323 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	3,852,323	95.61%
1-5ms	148,875	3.70%
5-10ms	6,367	0.16%
10-25ms	12,114	0.30%
25-50ms	7,922	0.20%
50-100ms	991	0.02%
100-500ms	270	0.01%
500-1000ms	5	0.00%
1000-10000ms	35	0.00%
> 10000ms	168	0.00%

Slowest individual queries


[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	1h25m9s	UPDATE FLOW_REPORTS SET routeNumber = '8989373', roundDeliveryDate = '2018-07-05', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-07-04 08:44:53', failedTargetPickTime = NULL, actualPaperworkCompleteTime = NULL, changedPickDateTime = 'f', CREATED = '2018-07-04 05:51:51.938', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200406502'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	1h21m2s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Lock', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1976', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 08:45:01.119', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	1h20m10s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2032', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 09:05:50.104', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	1h20m5s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2032', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 09:05:55.139', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	1h18m15s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2032', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 09:08:16.966', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	1h17m38s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Done', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2032', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 09:08:21.995', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	55m20s	UPDATE FLOW_REPORTS SET routeNumber = '8989373', roundDeliveryDate = '2018-07-05', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-07-04 08:44:53', failedTargetPickTime = NULL, actualPaperworkCompleteTime = NULL, changedPickDateTime = 'f', CREATED = '2018-07-04 05:51:51.938', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200406502'; [ Date: 2018-07-04 10:00:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	53m50s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Lock', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1976', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 08:45:01.119', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	53m46s	UPDATE ORDER_ROUNDS SET routeNumber = '8989136', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', updatedBy = '4062', updatedByUserName = 'Maria Giaquinto', orderRoundNote = NULL, firstCheckOut = '2018-07-04 08:45:01.137', allOrdersScannedOK = NULL, STATUS = 'Lock', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'D Leeds', audited = '2018-07-04 08:31:30.275', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 08:31:25.2', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1976', dlxPickedLinesQty = '1976', flowReport = '200406372', CREATED = '2018-07-04 05:53:16.042', createdBy = NULL, UPDATED = '2018-07-04 08:45:01.119', note = NULL WHERE ORDER_ROUND_ID = '200442482'; [ Date: 2018-07-04 10:26:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	45m57s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 09:40:03.497', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	45m55s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 09:40:05.716', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	45m50s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 06:03:20.611', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1992', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	45m48s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = 'F Loncol', audited = '2018-07-04 09:40:12.454', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 06:03:20.611', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	44m28s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 09:41:31.909', lastRxCompletedBy = '15364', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	44m21s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 09:41:39.756', lastRxCompletedBy = '15364', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	38m46s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = 'F Loncol', audited = '2018-07-04 09:47:13.403', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 06:03:20.611', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	30m59s	UPDATE FLOW_REPORTS SET routeNumber = '8989373', roundDeliveryDate = '2018-07-05', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-07-04 08:44:53', failedTargetPickTime = NULL, actualPaperworkCompleteTime = NULL, changedPickDateTime = 'f', CREATED = '2018-07-04 05:51:51.938', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200406502'; [ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	25m46s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = 'F Loncol', audited = '2018-07-04 10:00:14.011', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-07-04 06:03:20.611', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1992', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	25m20s	UPDATE ORDER_ROUNDS SET routeNumber = '8989381', uploadedByUserId = '4062', uploadedByUserName = 'Maria Giaquinto', 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-07-05', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-07-04 06:03:20.611', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '2069', dlxPickedLinesQty = '1572', flowReport = '200406582', CREATED = '2018-07-04 05:50:56.869', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200442272'; [ Date: 2018-07-04 09:33:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	22m41s	UPDATE "public"."order_rounds" SET "audited" = '2018-07-04 10:02:56.671', "auditedby" = '4', "auditstatus" = '1' WHERE "order_round_id" = '200442572'; [ Date: 2018-07-04 10:26:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 11h51m24s - Times executed: 251 ]
[ User: pharmisight - Total duration: 6h22m48s - Times executed: 282 ]
[ User: pharmisight - Total duration: 3h3m34s - Times executed: 143 ]
[ User: pharmisight - Total duration: 2h26m29s - Times executed: 207 ]
[ User: pharmisight - Total duration: 2h7m43s - Times executed: 352 ]
[ User: symmetricds - Total duration: 22m42s - Times executed: 9 ]
[ User: pharmisight - Total duration: 5m7s - Times executed: 349 ]
[ User: pharmisight - Total duration: 2m37s - Times executed: 136793 ]
[ User: pharmisight - Total duration: 2m14s - Times executed: 2934 ]
[ User: pharmisight - Total duration: 1m55s - Times executed: 2742 ]
[ User: pharmisight - Total duration: 1m - Times executed: 146645 ]
[ User: pharmisight - Total duration: 55s341ms - Times executed: 2064 ]
[ User: pharmisight - Total duration: 42s866ms - Times executed: 2938 ]
[ User: pharmisight - Total duration: 42s257ms - Times executed: 11736 ]
[ User: pharmisight - Total duration: 35s45ms - Times executed: 2006 ]
[ User: symmetricds - Total duration: 23s866ms - Times executed: 364852 ]
[ User: pharmisight - Total duration: 25s81ms - Times executed: 5457 ]
[ User: pharmisight - Total duration: 24s456ms - Times executed: 53133 ]
[ User: pharmisight - Total duration: 22s103ms - Times executed: 48012 ]
[ User: pharmisight - Total duration: 21s959ms - Times executed: 1149 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 17s479ms - Times executed: 984641 ]
[ User: symmetricds - Total duration: 5s824ms - Times executed: 488143 ]
[ User: symmetricds - Total duration: 2s208ms - Times executed: 364852 ]
[ User: symmetricds - Total duration: 23s866ms - Times executed: 364852 ]
[ User: pharmisight - Total duration: 1m - Times executed: 146645 ]
[ User: symmetricds - Total duration: 8s401ms - Times executed: 136878 ]
[ User: pharmisight - Total duration: 2m37s - Times executed: 136793 ]
[ User: pharmisight - Total duration: 12s737ms - Times executed: 98069 ]
[ User: pharmisight - Total duration: 4s497ms - Times executed: 89300 ]
[ User: pharmisight - Total duration: 5s137ms - Times executed: 86690 ]
[ User: symmetricds - Total duration: 3s955ms - Times executed: 77058 ]
[ User: symmetricds - Total duration: 1s166ms - Times executed: 57088 ]
[ User: pharmisight - Total duration: 5s270ms - Times executed: 53136 ]
[ User: pharmisight - Total duration: 24s456ms - Times executed: 53133 ]
[ User: symmetricds - Total duration: 1s495ms - Times executed: 52043 ]
[ User: pharmisight - Total duration: 22s103ms - Times executed: 48012 ]
[ User: pharmisight - Total duration: 2s214ms - Times executed: 34537 ]
[ User: pharmisight - Total duration: 1s564ms - Times executed: 30950 ]
[ User: pharmisight - Total duration: 1s695ms - Times executed: 28689 ]
[ User: symmetricds - Total duration: 5s268ms - Times executed: 25373 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 11h51m24s - Times executed: 251 ]
[ User: symmetricds - Total duration: 22m42s - Times executed: 9 ]
[ User: pharmisight - Total duration: 6h22m48s - Times executed: 282 ]
[ User: pharmisight - Total duration: 3h3m34s - Times executed: 143 ]
[ User: pharmisight - Total duration: 2h26m29s - Times executed: 207 ]
[ User: pharmisight - Total duration: 2h7m43s - Times executed: 352 ]
[ User: pharmisight - Total duration: 5m7s - Times executed: 349 ]
[ User: pharmisight - Total duration: 2m14s - Times executed: 2934 ]
[ User: pharmisight - Total duration: 1m55s - Times executed: 2742 ]
[ User: pharmisight - Total duration: 55s341ms - Times executed: 2064 ]
[ User: pharmisight - Total duration: 21s959ms - Times executed: 1149 ]
[ User: pharmisight - Total duration: 35s45ms - Times executed: 2006 ]
[ User: pharmisight - Total duration: 42s866ms - Times executed: 2938 ]
[ User: pharmisight - Total duration: 25s81ms - Times executed: 5457 ]
[ User: pharmisight - Total duration: 42s257ms - Times executed: 11736 ]
[ User: pharmisight - Total duration: 2m37s - Times executed: 136793 ]
[ User: pharmisight - Total duration: 22s103ms - Times executed: 48012 ]
[ User: pharmisight - Total duration: 24s456ms - Times executed: 53133 ]
[ User: pharmisight - Total duration: 1m - Times executed: 146645 ]
[ User: symmetricds - Total duration: 5s268ms - Times executed: 25373 ]

Log levels

Key values

13,098,327 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	723	0.01%
DETAIL	3,351,929	25.59%
ERROR	1,320	0.01%
FATAL	3	0.00%
HINT	13	0.00%
LOG	9,742,462	74.38%
STATEMENT	1,877	0.01%

Events distribution

Key values

0 PANIC entries
3 FATAL entries
1326 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

789 Max number of times the same event was reported
1,329 Total events found


Date: 2018-07-04 06:11:38
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-07-04 06:03:43
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-07-04 06:03:45
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-07-04 06:11:38
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-07-04 10:44:49
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.160
Code: 
Date: 2018-07-04 00:00:07
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
Code: 
Date: 2018-07-04 10:44:48
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.160
Code: 
Date: 2018-07-04 10:44:49
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 141.212.122.160
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