pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Apr 16 00:00:26 2019
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 9,031,009 log entries in 24s
Log start from 2019-04-15 00:00:00 to 2019-04-15 23:59:58

Global Stats

2,099 Number of unique normalized queries
2,689,676 Number of queries
10m55s Total query duration
2019-04-15 00:00:00 First query
2019-04-15 23:59:58 Last query
10,409 queries/s at 2019-04-15 06:05:16 Query peak

16 Number of events
2 Number of unique normalized events
11 Max number of times the same event was reported
0 Number of cancellation

129 Total number of automatic vacuums
270 Total number of automatic analyzes

4 Number temporary file
9.48 MiB Max size of temporary file
9.37 MiB Average size of temporary file

2,091 Total number of sessions
3 sessions at 2019-04-15 00:30:15 Session peak
10d13h23m10s Total duration of sessions
7m16s Average duration of sessions
1,286 Average queries per session
313ms Average queries duration per session

2,091 Total number of connections
9 connections/s at 2019-04-15 15:00:53 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,409 queries/s Query Peak
2019-04-15 06:05:16 Date

SELECT Traffic

Key values

2,495 queries/s Query Peak
2019-04-15 10:40:35 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,339 queries/s Query Peak
2019-04-15 06:05:16 Date

Queries duration

Key values

10m55s Total query duration

Prepared queries ratio

Key values

2.71 Ratio of bind vs prepare
128.57 % 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)
Apr 15	00	47,615	0ms	18ms	0ms	55ms	67ms	841ms
	01	44,760	0ms	13ms	0ms	56ms	64ms	140ms
	02	44,533	0ms	15ms	0ms	53ms	64ms	156ms
	03	44,732	0ms	17ms	0ms	58ms	68ms	197ms
	04	44,264	0ms	18ms	0ms	53ms	61ms	138ms
	05	44,943	0ms	221ms	0ms	49ms	63ms	679ms
	06	374,219	0ms	4s489ms	0ms	5s522ms	6s744ms	8s937ms
	07	176,587	0ms	734ms	0ms	1s480ms	1s795ms	2s903ms
	08	163,955	0ms	7s561ms	0ms	1s293ms	1s608ms	8s452ms
	09	226,890	0ms	6s966ms	0ms	1s570ms	2s732ms	8s818ms
	10	199,779	0ms	521ms	0ms	2s104ms	2s433ms	2s910ms
	11	212,159	0ms	8s103ms	0ms	2s110ms	2s295ms	15s220ms
	12	152,748	0ms	193ms	0ms	1s582ms	2s180ms	3s607ms
	13	191,974	0ms	726ms	0ms	1s417ms	2s45ms	2s702ms
	14	89,469	0ms	5s4ms	0ms	760ms	1s217ms	6s839ms
	15	139,774	0ms	8s67ms	0ms	1s545ms	2s424ms	28s140ms
	16	77,792	0ms	5s736ms	0ms	438ms	1s20ms	12s900ms
	17	127,218	0ms	511ms	0ms	1s540ms	1s994ms	2s127ms
	18	51,624	0ms	81ms	0ms	71ms	131ms	625ms
	19	45,601	0ms	81ms	0ms	51ms	143ms	422ms
	20	47,339	0ms	90ms	0ms	60ms	186ms	817ms
	21	45,534	0ms	81ms	0ms	55ms	85ms	412ms
	22	48,015	0ms	84ms	0ms	64ms	200ms	490ms
	23	48,152	0ms	81ms	0ms	88ms	252ms	427ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 15	00	16,813	0ms	23ms	37ms	357ms
	01	14,736	0ms	25ms	32ms	43ms
	02	14,698	0ms	23ms	35ms	42ms
	03	14,731	0ms	23ms	36ms	45ms
	04	14,588	0ms	23ms	28ms	42ms
	05	14,893	0ms	23ms	37ms	136ms
	06	162,546	0ms	1s993ms	3s976ms	4s452ms
	07	80,105	0ms	848ms	1s80ms	2s563ms
	08	88,417	0ms	894ms	1s152ms	1s770ms
	09	111,734	0ms	1s109ms	1s324ms	2s182ms
	10	112,960	0ms	1s303ms	1s916ms	2s260ms
	11	119,149	0ms	1s355ms	1s884ms	2s94ms
	12	77,097	0ms	1s123ms	1s411ms	2s96ms
	13	108,211	0ms	845ms	1s199ms	1s988ms
	14	39,070	0ms	339ms	663ms	1s180ms
	15	75,948	0ms	359ms	1s446ms	2s250ms
	16	33,283	0ms	114ms	239ms	988ms
	17	71,871	0ms	617ms	1s323ms	1s935ms
	18	17,823	0ms	24ms	32ms	160ms
	19	14,906	0ms	23ms	34ms	145ms
	20	17,348	0ms	26ms	38ms	177ms
	21	14,779	0ms	24ms	33ms	134ms
	22	15,296	0ms	19ms	33ms	144ms
	23	15,265	0ms	22ms	36ms	141ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 15	00	112	99	82	0ms	1ms	4ms	14ms
	01	108	75	83	0ms	1ms	5ms	13ms
	02	96	64	82	0ms	0ms	4ms	11ms
	03	132	81	83	0ms	0ms	7ms	13ms
	04	86	52	82	0ms	0ms	4ms	8ms
	05	182	190	83	0ms	0ms	7ms	13ms
	06	108,213	32,136	530	0ms	638ms	1s91ms	4s60ms
	07	19,684	7,310	430	0ms	140ms	171ms	207ms
	08	14,260	4,925	399	0ms	89ms	107ms	157ms
	09	16,644	9,492	398	0ms	99ms	131ms	781ms
	10	16,612	6,341	404	0ms	94ms	125ms	171ms
	11	17,561	7,219	410	0ms	103ms	123ms	226ms
	12	13,193	6,239	324	0ms	96ms	124ms	235ms
	13	16,782	6,383	384	0ms	91ms	111ms	162ms
	14	5,764	2,647	223	0ms	52ms	69ms	274ms
	15	7,938	3,588	328	2ms	60ms	80ms	143ms
	16	4,146	1,659	200	2ms	37ms	51ms	106ms
	17	7,070	2,813	282	0ms	59ms	98ms	286ms
	18	473	1,240	119	0ms	8ms	14ms	28ms
	19	466	181	118	0ms	0ms	5ms	26ms
	20	457	228	143	0ms	0ms	7ms	29ms
	21	752	242	119	0ms	0ms	5ms	32ms
	22	2,120	580	117	0ms	0ms	9ms	123ms
	23	2,240	610	118	0ms	0ms	8ms	100ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Apr 15	00	30,335	47,579	1.57	105.81%
	01	30,014	44,724	1.49	114.66%
	02	29,986	44,497	1.48	115.14%
	03	30,147	44,696	1.48	115.16%
	04	29,819	44,228	1.48	115.43%
	05	30,068	44,907	1.49	113.60%
	06	63,440	374,086	5.90	18.80%
	07	55,798	174,093	3.12	38.71%
	08	51,500	163,919	3.18	37.95%
	09	80,137	226,854	2.83	45.02%
	10	55,465	199,743	3.60	33.22%
	11	57,499	212,123	3.69	32.35%
	12	51,109	152,712	2.99	41.56%
	13	53,710	191,938	3.57	33.68%
	14	39,137	89,433	2.29	59.90%
	15	49,931	139,738	2.80	45.21%
	16	35,798	77,742	2.17	65.12%
	17	43,445	127,182	2.93	42.87%
	18	30,198	50,442	1.67	92.58%
	19	28,533	45,565	1.60	105.94%
	20	29,376	47,303	1.61	100.84%
	21	28,581	45,498	1.59	105.75%
	22	28,320	47,979	1.69	96.46%
	23	28,358	48,116	1.70	96.16%

Day	Hour	Count	Average / Second
Apr 15	00	97	0.03/s
	01	117	0.03/s
	02	116	0.03/s
	03	118	0.03/s
	04	119	0.03/s
	05	116	0.03/s
	06	92	0.03/s
	07	85	0.02/s
	08	91	0.03/s
	09	78	0.02/s
	10	66	0.02/s
	11	64	0.02/s
	12	71	0.02/s
	13	78	0.02/s
	14	62	0.02/s
	15	79	0.02/s
	16	62	0.02/s
	17	77	0.02/s
	18	78	0.02/s
	19	77	0.02/s
	20	105	0.03/s
	21	85	0.02/s
	22	81	0.02/s
	23	77	0.02/s

Day	Hour	Count	Average Duration
Apr 15	00	97	6m19s
	01	117	5m10s
	02	116	5m8s
	03	118	5m5s
	04	119	5m5s
	05	116	5m8s
	06	92	6m54s
	07	85	6m44s
	08	91	7m8s
	09	78	6m57s
	10	66	10m50s
	11	64	10m46s
	12	71	9m40s
	13	78	9m25s
	14	62	10m19s
	15	73	9m59s
	16	68	10m3s
	17	77	8m58s
	18	78	7m9s
	19	77	8m14s
	20	105	6m
	21	85	6m47s
	22	81	7m20s
	23	77	7m57s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2019-04-15 15:00:53 Date

Connections per database

Key values

pharmisight Main Database
2,091 connections Total

Chart
Table

Database	User	Count
pharmisight		2,091
	pharmisight	823
	symmetricds	980
	tony	288

Connections per user

Key values

symmetricds Main User
2,091 connections Total

Chart
Table

User	Count
pharmisight	823
symmetricds	980
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1803 connections
2,091 Total connections

Chart
Table

Host	Count
10.10.10.1	1,803
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2019-04-15 00:30:15 Date

Histogram of session times

Key values

1,470 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	13.77%
500ms-1s	0	0.00%
1s-30s	4	0.19%
30s-1m	0	0.00%
1m-10m	1,470	70.30%
10m-30m	295	14.11%
30m-1h	31	1.48%
1h-8h	3	0.14%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,091 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,091	10d13h23m10s	7m16s

Sessions per user

Key values

symmetricds Main User
2,091 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	823	5d12h55m38s
symmetricds	980	5d27m19s
tony	288	11s912ms

Sessions per host

Key values

10.10.10.1 Main Host
2,091 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,803	10d13h22m58s	8m25s
::1	288	11s912ms	41ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,091 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,799	10d13h22m20s	8m27s
[unknown]	292	49s663ms	170ms

Checkpoints Buffers

Key values

3,272 buffers Checkpoint Peak
2019-04-15 06:20:43 Date
149.884 seconds Highest write time
0.030 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2019-04-15 06:05:43 Date

Checkpoints distance

Key values

124.37 Mo Distance Peak
2019-04-15 06:10:43 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Apr 15	00	559	56.084s	0.016s	56.157s
	01	464	46.553s	0.013s	46.621s
	02	475	47.661s	0.007s	47.715s
	03	315	31.606s	0.013s	31.679s
	04	372	37.319s	0.012s	37.376s
	05	278	27.893s	0.012s	27.948s
	06	16,179	1,237.422s	0.066s	1,237.589s
	07	9,963	1,017.468s	0.046s	1,017.586s
	08	7,135	718.73s	0.033s	718.847s
	09	9,937	873.394s	0.045s	873.508s
	10	6,968	698.121s	0.034s	698.24s
	11	7,878	801.325s	0.058s	801.446s
	12	6,984	695.736s	0.031s	695.835s
	13	6,882	690.225s	0.034s	690.319s
	14	3,344	334.941s	0.018s	335.024s
	15	4,157	421.474s	0.033s	421.576s
	16	1,919	193.339s	0.021s	193.42s
	17	3,211	328.782s	0.036s	328.873s
	18	1,461	146.402s	0.009s	146.471s
	19	432	43.356s	0.011s	43.515s
	20	410	41.153s	0.01s	41.234s
	21	436	43.74s	0.011s	43.807s
	22	541	54.18s	0.018s	54.249s
	23	614	61.517s	0.01s	61.575s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Apr 15	00	0	0	200	0.004s	0s
	01	0	0	190	0.002s	0.001s
	02	0	0	169	0.001s	0.001s
	03	0	0	178	0.002s	0s
	04	0	0	143	0.003s	0s
	05	0	0	138	0.003s	0s
	06	1	16	1,354	0.004s	0s
	07	1	4	1,256	0.002s	0s
	08	0	2	1,203	0.001s	0s
	09	0	5	1,300	0.005s	0s
	10	0	3	1,143	0.001s	0s
	11	0	3	1,221	0.005s	0s
	12	0	3	1,175	0.001s	0s
	13	0	3	1,163	0.001s	0s
	14	0	1	758	0.002s	0s
	15	0	2	1,032	0.003s	0s
	16	0	1	543	0.001s	0s
	17	0	1	840	0.005s	0s
	18	0	0	264	0.001s	0s
	19	0	1	197	0.002s	0s
	20	0	0	211	0.002s	0s
	21	0	0	188	0.002s	0s
	22	0	0	186	0.008s	0s
	23	0	0	179	0.002s	0s

Day	Hour	Avg time (sec)
Apr 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
Apr 15	00	243.90 kB	683.90 kB
	01	218.22 kB	703.22 kB
	02	221.67 kB	601.22 kB
	03	117.00 kB	321.67 kB
	04	177.11 kB	458.56 kB
	05	128.75 kB	345.88 kB
	06	16,110.40 kB	48,885.10 kB
	07	5,820.33 kB	20,630.50 kB
	08	3,925.25 kB	8,937.83 kB
	09	6,043.33 kB	13,380.00 kB
	10	3,868.92 kB	8,508.75 kB
	11	4,690.83 kB	6,160.33 kB
	12	3,898.50 kB	6,242.83 kB
	13	3,924.25 kB	7,082.17 kB
	14	1,715.42 kB	3,475.00 kB
	15	2,378.27 kB	2,852.00 kB
	16	1,146.91 kB	2,326.36 kB
	17	1,899.64 kB	3,396.18 kB
	18	881.00 kB	1,931.91 kB
	19	220.22 kB	947.67 kB
	20	192.20 kB	642.80 kB
	21	208.70 kB	481.90 kB
	22	339.67 kB	935.11 kB
	23	391.11 kB	992.89 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

9.48 MiB Temp Files size Peak
2019-04-15 06:05:14 Date

Number of temporary files

Key values

1 per second Temp Files Peak
2019-04-15 07:51:39 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Apr 15	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	3	28.03 MiB	9.34 MiB
	07	1	9.43 MiB	9.43 MiB
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

public.sym_data_gap (113) Main table analyzed (database pharmisight)
270 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	113
pharmisight.public.sym_outgoing_batch	81
pharmisight.public.sym_incoming_batch	21
pharmisight.public.sym_data	15
pharmisight.public.sym_data_event	15
pharmisight.public.sym_sequence	12
pharmisight.public.sym_node_host	5
pharmisight.public.item_codes	2
pharmisight.public.orders	1
pharmisight.public.eps	1
pharmisight.public.flow_report_summary_delays	1
pharmisight.public.order_line_history	1
pharmisight.public.users	1
pharmisight.public.tablets	1
Total	270

Vacuums per table

Key values

public.sym_data_gap (59) Main table vacuumed on database pharmisight
129 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	59	59
pharmisight.public.sym_outgoing_batch	37	37
pharmisight.public.sym_sequence	12	0
pharmisight.public.sym_incoming_batch	8	8
pharmisight.public.sym_node_host	5	0
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.pg_catalog.pg_statistic	3	3
pharmisight.public.item_codes	1	1
pharmisight.public.sym_data	1	1
Total	129	112

Tuples removed per table

Key values

public.sym_data_gap (3163) Main table with removed tuples on database pharmisight
8163 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_data_gap	59	59	3163
pharmisight.public.sym_outgoing_batch	37	37	1502
pharmisight.public.sym_incoming_batch	8	8	1114
pharmisight.pg_catalog.pg_statistic	3	3	825
pharmisight.public.sym_sequence	12	0	613
pharmisight.public.item_codes	1	1	265
pharmisight.public.sym_node_host	5	0	260
pharmisight.pg_toast.pg_toast_2619	3	3	214
pharmisight.public.sym_data	1	1	207
Total	129	112	8,163

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_outgoing_batch	37	37	1502
pharmisight.public.sym_data_gap	59	59	3163
pharmisight.pg_toast.pg_toast_2619	3	3	214
pharmisight.public.sym_sequence	12	0	613
pharmisight.public.sym_incoming_batch	8	8	1114
pharmisight.public.sym_node_host	5	0	260
pharmisight.pg_catalog.pg_statistic	3	3	825
pharmisight.public.item_codes	1	1	265
pharmisight.public.sym_data	1	1	207
Total	129	112	8,163

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Apr 15	00	1	4
	01	1	2
	02	2	4
	03	2	0
	04	0	4
	05	1	1
	06	17	44
	07	18	33
	08	10	23
	09	12	25
	10	11	22
	11	12	23
	12	8	17
	13	9	19
	14	4	7
	15	9	17
	16	4	4
	17	5	11
	18	1	5
	19	0	1
	20	0	2
	21	1	1
	22	1	1
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
16 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		5	26s1ms	5s200ms
	tuple	5	26s1ms	5s200ms
ShareLock		11	47s679ms	4s334ms
	transaction	11	47s679ms	4s334ms
	Total	16	1m13s	4s605ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	14	1m11s	1s14ms	8s102ms	5s86ms	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, manuallychangedpicktime = ?, created = ?, updated = ?, note = ? WHERE flow_report_id = ?; UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2019-04-15 06:25:56 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	2	2s476ms	1s147ms	1s329ms	1s238ms	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: 2019-04-15 06:05:22 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 09:21:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 14:53:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 06:30:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 06:25:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 15:01:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 06:08:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 06:05:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-15 06:31:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	8s102ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	8s62ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	6s966ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 09:21:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	6s84ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	5s735ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	5s588ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	5s567ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	5s51ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	5s4ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 14:53:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	4s488ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 06:30:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	3s708ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	3s155ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 06:25:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	2s673ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 15:01:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	1s329ms	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: 2019-04-15 06:08:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	1s147ms	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: 2019-04-15 06:05:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	1s14ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-04-15 06:31:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,266,267 Total read queries
822,140 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,266,267	47.08%
INSERT	255,091	9.48%
UPDATE	94,394	3.51%
DELETE	5,541	0.21%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	467,114	17.37%
OTHERS	601,269	22.35%

Queries by database

Key values

pharmisight Main database
2,689,676 Requests
10m55s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,689,676	10m55s
	DELETE	5,541	6s534ms
	INSERT	255,091	41s105ms
	OTHERS	601,269	9s180ms
	SELECT	1,266,267	7m
	TCL	467,114	32s148ms
	UPDATE	94,394	2m26s

Queries by user

Key values

symmetricds Main user
1,719,497 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,014,481	9m8s
	DELETE	76	2s163ms
	INSERT	38,976	25s278ms
	OTHERS	2,609	93ms
	SELECT	836,565	6m15s
	TCL	76,152	9s529ms
	UPDATE	60,103	2m15s
symmetricds	Total	1,719,497	1m48s
	DELETE	5,535	4s382ms
	INSERT	216,237	15s873ms
	OTHERS	617,431	9s391ms
	SELECT	443,574	45s135ms
	TCL	402,342	22s836ms
	UPDATE	34,378	10s528ms
tony	Total	900	275ms
	SELECT	900	275ms

Duration by user

Key values

9m8s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,014,481	9m8s
	DELETE	76	2s163ms
	INSERT	38,976	25s278ms
	OTHERS	2,609	93ms
	SELECT	836,565	6m15s
	TCL	76,152	9s529ms
	UPDATE	60,103	2m15s
symmetricds	Total	1,719,497	1m48s
	DELETE	5,535	4s382ms
	INSERT	216,237	15s873ms
	OTHERS	617,431	9s391ms
	SELECT	443,574	45s135ms
	TCL	402,342	22s836ms
	UPDATE	34,378	10s528ms
tony	Total	900	275ms
	SELECT	900	275ms

Queries by host

Key values

10.10.10.1 Main host
2,733,978 Requests
10m57s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,733,978	10m57s
	DELETE	5,611	6s545ms
	INSERT	255,213	41s152ms
	OTHERS	620,040	9s485ms
	SELECT	1,280,139	7m1s
	TCL	478,494	32s366ms
	UPDATE	94,481	2m26s
::1	Total	900	275ms
	SELECT	900	275ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,683,298 Requests
10m54s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,683,298	10m54s
	DELETE	5,541	6s534ms
	INSERT	255,005	41s68ms
	OTHERS	599,462	9s108ms
	SELECT	1,261,978	6m59s
	TCL	466,918	32s117ms
	UPDATE	94,394	2m26s
[unknown]	Total	6,378	799ms
	INSERT	86	37ms
	OTHERS	1,807	71ms
	SELECT	4,289	660ms
	TCL	196	30ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2019-04-15 06:41:47 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,629,323 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,629,323	97.76%
1-5ms	49,025	1.82%
5-10ms	4,098	0.15%
10-25ms	4,422	0.16%
25-50ms	2,236	0.08%
50-100ms	387	0.01%
100-500ms	157	0.01%
500-1000ms	7	0.00%
1000-10000ms	21	0.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 08:44:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 09:21:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 14:53:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:30:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:25:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:22:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 15:01:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:08:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:00:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:08:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:05:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-15 06:21:37 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	8s103ms	UPDATE FLOW_REPORTS SET routeNumber = '9394149', roundDeliveryDate = '2019-04-16', distributionPoint = 'Ed Didcott', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 11:09:15.633', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-13 09:00:06', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-15 09:49:34.788', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 12:30:47.041', UPDATED = '2019-04-15 11:09:15.648', note = NULL WHERE FLOW_REPORT_ID = '200520622'; [ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	8s67ms	UPDATE FLOW_REPORTS SET routeNumber = '9394202', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 12:09:24', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:24:45.73', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:20.434', UPDATED = '2019-04-15 15:01:05.471', note = NULL WHERE FLOW_REPORT_ID = '200521012'; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	7s561ms	SELECT this_.ORDER_LINE_ID AS ORDER_LI1_24_0_, this_.routeNumber AS routeNum2_24_0_, this_.sapOrderNumber AS sapOrder3_24_0_, this_.orderNumber AS orderNum4_24_0_, this_.answerOrderNumber AS answerOr5_24_0_, this_.partCode AS partCode6_24_0_, this_.partDescription AS partDesc7_24_0_, this_.patientName AS patientN8_24_0_, this_.firstName AS firstNam9_24_0_, this_.middleName AS middleN10_24_0_, this_.lastName AS lastNam11_24_0_, this_.patientDateOfBirth AS patient12_24_0_, this_.patientPostcode AS patient13_24_0_, this_.patientPostcodePrefix AS patient14_24_0_, this_.orderQty AS orderQt15_24_0_, this_.allocQty AS allocQt16_24_0_, this_.shipQty AS shipQty17_24_0_, this_.adjustedQty AS adjuste18_24_0_, this_.scannedQty AS scanned19_24_0_, this_.assignedQty AS assigne20_24_0_, this_.checkedQty AS checked21_24_0_, this_.backOrderQty AS backOrd22_24_0_, this_.cancelQty AS cancelQ23_24_0_, this_.reducedQty AS reduced24_24_0_, this_.status AS status25_24_0_, this_.reason AS reason26_24_0_, this_.deliveryDate AS deliver27_24_0_, this_.customer AS custome28_24_0_, this_.sapCustomerId AS sapCust29_24_0_, this_.billToType AS billToT30_24_0_, this_.barcodeDate AS barcode31_24_0_, this_.barcodeBatch AS barcode32_24_0_, this_.patientId AS patient33_24_0_, this_.isAdded AS isAdded34_24_0_, this_.isNotWithinAge AS isNotWi35_24_0_, this_.isUnderAge AS isUnder36_24_0_, this_.ageCheck AS ageChec37_24_0_, this_.expired AS expired38_24_0_, this_.paperwork AS paperwo39_24_0_, this_.isPaperworkProblem AS isPaper40_24_0_, this_.paperworkResolution AS paperwo41_24_0_, this_.pickerId AS pickerI42_24_0_, this_.specialCare AS special43_24_0_, this_.paperworkEnquiryStarted AS paperwo44_24_0_, this_.paperworkEnquiryFinished AS paperwo45_24_0_, this_.paperworkEnquiryResponse AS paperwo46_24_0_, this_.isNewProduct AS isNewPr47_24_0_, this_.extraProcedure AS extraPr48_24_0_, this_.overAverageQtyMax AS overAve49_24_0_, this_.overAverageQtyResolution AS overAve50_24_0_, this_.createUser AS createU51_24_0_, this_.patientAlert AS patient52_24_0_, this_.itemAlert AS itemAle53_24_0_, this_.checkerId AS checker54_24_0_, this_.reductionSummary AS reducti55_24_0_, this_.isMetabolic AS isMetab56_24_0_, this_.rxStatus AS rxStatu57_24_0_, this_.lastRegUpdateUserType AS lastReg58_24_0_, this_.lastRegUpdateUserName AS lastReg59_24_0_, this_.lastRegUpdateDate AS lastReg60_24_0_, this_.sapPlannedShipDate AS sapPlan61_24_0_, this_.sapPlannedDeliveryDate AS sapPlan62_24_0_, this_.requestedSAPQuantity AS request63_24_0_, this_.orderQuantity AS orderQu64_24_0_, this_.regLineCreatedUserType AS regLine65_24_0_, this_.regLineCreatedUserName AS regLine66_24_0_, this_.regLineCreatedDate AS regLine67_24_0_, this_.audited AS audited68_24_0_, this_.isMetabolicPatient AS isMetab69_24_0_, this_.addedCase AS addedCa70_24_0_, this_.orderType AS orderTy71_24_0_, this_.CREATED AS CREATED72_24_0_, this_.UPDATED AS UPDATED73_24_0_, this_.rxCheckBy AS rxCheck74_24_0_, this_.note AS note75_24_0_, this_.item AS item76_24_0_, this_.alertConfirmation AS alertCo77_24_0_, this_.homewardAction AS homewar78_24_0_ FROM ORDER_LINES this_ WHERE this_.status <> 'Quarantine' AND (this_.patientAlert = '1' OR this_.itemAlert = '1') AND (this_.ageCheck <> '10608' OR (this_.patientAlert <> '0' OR this_.itemAlert <> '0') OR this_.status = 'Mismatch' OR this_.rxStatus = '2' OR (this_.overAverageQtyMax <> '0')) ORDER BY this_.routeNumber ASC, this_.lastName ASC, this_.partCode ASC LIMIT '1000'; [ Date: 2019-04-15 08:44:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	6s966ms	UPDATE FLOW_REPORTS SET routeNumber = '9394154', roundDeliveryDate = '2019-04-16', distributionPoint = 'C Irlam', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 09:21:22.598', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-13 05:26:26', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-15 07:17:50.138', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:58.124', UPDATED = '2019-04-15 09:21:22.611', note = NULL WHERE FLOW_REPORT_ID = '200520672'; [ Date: 2019-04-15 09:21:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	6s94ms	UPDATE FLOW_REPORTS SET routeNumber = '9394202', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 12:09:24', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:24:45.73', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:20.434', UPDATED = '2019-04-15 15:01:05.471', note = NULL WHERE FLOW_REPORT_ID = '200521012'; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	5s736ms	UPDATE FLOW_REPORTS SET routeNumber = '9394206', roundDeliveryDate = '2019-04-20', distributionPoint = 'Ed Didcott', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 16:14:06.795', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 14:25:10', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:26:34.146', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 12:30:33.975', UPDATED = '2019-04-15 16:14:06.821', note = NULL WHERE FLOW_REPORT_ID = '200521052'; [ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	5s594ms	UPDATE FLOW_REPORTS SET routeNumber = '9394206', roundDeliveryDate = '2019-04-20', distributionPoint = 'Ed Didcott', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 16:14:06.795', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 14:25:10', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:26:34.146', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 12:30:33.975', UPDATED = '2019-04-15 16:14:06.821', note = NULL WHERE FLOW_REPORT_ID = '200521052'; [ Date: 2019-04-15 16:14:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	5s587ms	UPDATE FLOW_REPORTS SET routeNumber = '9394202', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 12:09:24', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:24:45.73', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:20.434', UPDATED = '2019-04-15 15:01:05.471', note = NULL WHERE FLOW_REPORT_ID = '200521012'; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	5s56ms	UPDATE FLOW_REPORTS SET routeNumber = '9394149', roundDeliveryDate = '2019-04-16', distributionPoint = 'Ed Didcott', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 11:09:15.633', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-13 09:00:06', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-15 09:49:34.788', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 12:30:47.041', UPDATED = '2019-04-15 11:09:15.648', note = NULL WHERE FLOW_REPORT_ID = '200520622'; [ Date: 2019-04-15 11:09:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	5s4ms	UPDATE FLOW_REPORTS SET routeNumber = '9394199', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-15 14:53:07.255', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 11:40:50', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 06:24:07.839', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 11:30:31.757', UPDATED = '2019-04-15 14:53:07.27', note = NULL WHERE FLOW_REPORT_ID = '200520982'; [ Date: 2019-04-15 14:53:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	4s489ms	UPDATE FLOW_REPORTS SET routeNumber = '9394227', roundDeliveryDate = '2019-04-20', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-15 06:24:07.476', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 12:00:06.644', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200521262'; [ Date: 2019-04-15 06:30:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	3s714ms	UPDATE FLOW_REPORTS SET routeNumber = '9394202', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 12:09:24', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:24:45.73', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:20.434', UPDATED = '2019-04-15 15:01:05.471', note = NULL WHERE FLOW_REPORT_ID = '200521012'; [ Date: 2019-04-15 15:01:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	3s156ms	UPDATE FLOW_REPORTS SET routeNumber = '9394212', roundDeliveryDate = '2019-04-20', distributionPoint = 'C Irlam', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-15 06:24:08.121', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:00:17.442', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200521112'; [ Date: 2019-04-15 06:25:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	2s709ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = '348778'; [ Date: 2019-04-15 06:22:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	2s674ms	UPDATE FLOW_REPORTS SET routeNumber = '9394202', roundDeliveryDate = '2019-04-20', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-15 12:09:24', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-04-15 11:24:45.73', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-15 10:30:20.434', UPDATED = '2019-04-15 15:01:05.471', note = NULL WHERE FLOW_REPORT_ID = '200521012'; [ Date: 2019-04-15 15:01:45 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	1s889ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = '657689'; [ Date: 2019-04-15 06:08:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1s840ms	SELECT this_.ORDER_LINE_ID AS ORDER_LI1_24_0_, this_.routeNumber AS routeNum2_24_0_, this_.sapOrderNumber AS sapOrder3_24_0_, this_.orderNumber AS orderNum4_24_0_, this_.answerOrderNumber AS answerOr5_24_0_, this_.partCode AS partCode6_24_0_, this_.partDescription AS partDesc7_24_0_, this_.patientName AS patientN8_24_0_, this_.firstName AS firstNam9_24_0_, this_.middleName AS middleN10_24_0_, this_.lastName AS lastNam11_24_0_, this_.patientDateOfBirth AS patient12_24_0_, this_.patientPostcode AS patient13_24_0_, this_.patientPostcodePrefix AS patient14_24_0_, this_.orderQty AS orderQt15_24_0_, this_.allocQty AS allocQt16_24_0_, this_.shipQty AS shipQty17_24_0_, this_.adjustedQty AS adjuste18_24_0_, this_.scannedQty AS scanned19_24_0_, this_.assignedQty AS assigne20_24_0_, this_.checkedQty AS checked21_24_0_, this_.backOrderQty AS backOrd22_24_0_, this_.cancelQty AS cancelQ23_24_0_, this_.reducedQty AS reduced24_24_0_, this_.status AS status25_24_0_, this_.reason AS reason26_24_0_, this_.deliveryDate AS deliver27_24_0_, this_.customer AS custome28_24_0_, this_.sapCustomerId AS sapCust29_24_0_, this_.billToType AS billToT30_24_0_, this_.barcodeDate AS barcode31_24_0_, this_.barcodeBatch AS barcode32_24_0_, this_.patientId AS patient33_24_0_, this_.isAdded AS isAdded34_24_0_, this_.isNotWithinAge AS isNotWi35_24_0_, this_.isUnderAge AS isUnder36_24_0_, this_.ageCheck AS ageChec37_24_0_, this_.expired AS expired38_24_0_, this_.paperwork AS paperwo39_24_0_, this_.isPaperworkProblem AS isPaper40_24_0_, this_.paperworkResolution AS paperwo41_24_0_, this_.pickerId AS pickerI42_24_0_, this_.specialCare AS special43_24_0_, this_.paperworkEnquiryStarted AS paperwo44_24_0_, this_.paperworkEnquiryFinished AS paperwo45_24_0_, this_.paperworkEnquiryResponse AS paperwo46_24_0_, this_.isNewProduct AS isNewPr47_24_0_, this_.extraProcedure AS extraPr48_24_0_, this_.overAverageQtyMax AS overAve49_24_0_, this_.overAverageQtyResolution AS overAve50_24_0_, this_.createUser AS createU51_24_0_, this_.patientAlert AS patient52_24_0_, this_.itemAlert AS itemAle53_24_0_, this_.checkerId AS checker54_24_0_, this_.reductionSummary AS reducti55_24_0_, this_.isMetabolic AS isMetab56_24_0_, this_.rxStatus AS rxStatu57_24_0_, this_.lastRegUpdateUserType AS lastReg58_24_0_, this_.lastRegUpdateUserName AS lastReg59_24_0_, this_.lastRegUpdateDate AS lastReg60_24_0_, this_.sapPlannedShipDate AS sapPlan61_24_0_, this_.sapPlannedDeliveryDate AS sapPlan62_24_0_, this_.requestedSAPQuantity AS request63_24_0_, this_.orderQuantity AS orderQu64_24_0_, this_.regLineCreatedUserType AS regLine65_24_0_, this_.regLineCreatedUserName AS regLine66_24_0_, this_.regLineCreatedDate AS regLine67_24_0_, this_.audited AS audited68_24_0_, this_.isMetabolicPatient AS isMetab69_24_0_, this_.addedCase AS addedCa70_24_0_, this_.orderType AS orderTy71_24_0_, this_.CREATED AS CREATED72_24_0_, this_.UPDATED AS UPDATED73_24_0_, this_.rxCheckBy AS rxCheck74_24_0_, this_.note AS note75_24_0_, this_.item AS item76_24_0_, this_.alertConfirmation AS alertCo77_24_0_, this_.homewardAction AS homewar78_24_0_ FROM ORDER_LINES this_ WHERE this_.deliveryDate BETWEEN '2019-04-01' AND '2019-04-30'; [ Date: 2019-04-15 06:00:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	1s330ms	UPDATE ORDER_ROUNDS SET routeNumber = '9394150', 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 = '2019-04-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = NULL, distributionPoint = 'Ed Didcott', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = NULL, lastRxCompleted = NULL, lastRxCompletedBy = NULL, orderRoundNoteReadBy = NULL, routeOrderLinesQty = '899', dlxPickedLinesQty = '899', flowReport = '200520632', CREATED = '2019-04-15 06:00:54.41', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200557912'; [ Date: 2019-04-15 06:08:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	1s147ms	UPDATE ORDER_ROUNDS SET routeNumber = '9394144', 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 = '2019-04-16', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = NULL, distributionPoint = NULL, audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = NULL, lastRxCompleted = NULL, lastRxCompletedBy = NULL, orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1191', dlxPickedLinesQty = '1191', flowReport = NULL, CREATED = '2019-04-15 06:00:42.021', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200557852'; [ Date: 2019-04-15 06:05:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	1s51ms	SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '8774434' AND o.node_id = '0' ORDER BY d.data_id ASC; [ Date: 2019-04-15 06:21:37 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 56s41ms - Times executed: 92473 ]
[ User: pharmisight - Total duration: 50s672ms - Times executed: 1585 ]
[ User: pharmisight - Total duration: 37s365ms - Times executed: 235 ]
[ User: symmetricds - Total duration: 21s376ms - Times executed: 195490 ]
[ User: pharmisight - Total duration: 26s255ms - Times executed: 129 ]
[ User: pharmisight - Total duration: 25s942ms - Times executed: 107525 ]
[ User: pharmisight - Total duration: 19s950ms - Times executed: 333 ]
[ User: pharmisight - Total duration: 18s927ms - Times executed: 1585 ]
[ User: pharmisight - Total duration: 18s699ms - Times executed: 6340 ]
[ User: pharmisight - Total duration: 15s970ms - Times executed: 102702 ]
[ User: pharmisight - Total duration: 15s35ms - Times executed: 632 ]
[ User: pharmisight - Total duration: 14s897ms - Times executed: 565 ]
[ User: pharmisight - Total duration: 13s571ms - Times executed: 3723 ]
[ User: pharmisight - Total duration: 12s430ms - Times executed: 692 ]
[ User: pharmisight - Total duration: 10s941ms - Times executed: 17067 ]
[ User: symmetricds - Total duration: 10s8ms - Times executed: 198588 ]
[ User: symmetricds - Total duration: 9s418ms - Times executed: 17157 ]
[ User: pharmisight - Total duration: 8s731ms - Times executed: 79 ]
[ User: symmetricds - Total duration: 8s441ms - Times executed: 553196 ]
[ User: pharmisight - Total duration: 8s183ms - Times executed: 54 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 8s441ms - Times executed: 553196 ]
[ User: symmetricds - Total duration: 1s244ms - Times executed: 195490 ]
[ User: symmetricds - Total duration: 21s376ms - Times executed: 195490 ]
[ User: symmetricds - Total duration: 2s514ms - Times executed: 229147 ]
[ User: symmetricds - Total duration: 10s8ms - Times executed: 198588 ]
[ User: pharmisight - Total duration: 25s942ms - Times executed: 107525 ]
[ User: pharmisight - Total duration: 15s970ms - Times executed: 102702 ]
[ User: pharmisight - Total duration: 56s41ms - Times executed: 92473 ]
[ User: pharmisight - Total duration: 3s761ms - Times executed: 86461 ]
[ User: pharmisight - Total duration: 2s538ms - Times executed: 54607 ]
[ User: pharmisight - Total duration: 1s961ms - Times executed: 36900 ]
[ User: pharmisight - Total duration: 737ms - Times executed: 34327 ]
[ User: pharmisight - Total duration: 1s363ms - Times executed: 28785 ]
[ User: symmetricds - Total duration: 1s227ms - Times executed: 26172 ]
[ User: pharmisight - Total duration: 1s54ms - Times executed: 25698 ]
[ User: symmetricds - Total duration: 1s164ms - Times executed: 23204 ]
[ User: pharmisight - Total duration: 3s203ms - Times executed: 22365 ]
[ User: pharmisight - Total duration: 1s18ms - Times executed: 22282 ]
[ User: symmetricds - Total duration: 313ms - Times executed: 21824 ]
[ User: symmetricds - Total duration: 267ms - Times executed: 21824 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 26s255ms - Times executed: 129 ]
[ User: pharmisight - Total duration: 37s365ms - Times executed: 235 ]
[ User: pharmisight - Total duration: 8s183ms - Times executed: 54 ]
[ User: pharmisight - Total duration: 8s731ms - Times executed: 79 ]
[ User: pharmisight - Total duration: 19s950ms - Times executed: 333 ]
[ User: pharmisight - Total duration: 50s672ms - Times executed: 1585 ]
[ User: pharmisight - Total duration: 14s897ms - Times executed: 565 ]
[ User: pharmisight - Total duration: 15s35ms - Times executed: 632 ]
[ User: pharmisight - Total duration: 12s430ms - Times executed: 692 ]
[ User: pharmisight - Total duration: 18s927ms - Times executed: 1585 ]
[ User: pharmisight - Total duration: 13s571ms - Times executed: 3723 ]
[ User: pharmisight - Total duration: 18s699ms - Times executed: 6340 ]
[ User: pharmisight - Total duration: 10s941ms - Times executed: 17067 ]
[ User: pharmisight - Total duration: 56s41ms - Times executed: 92473 ]
[ User: symmetricds - Total duration: 9s418ms - Times executed: 17157 ]
[ User: pharmisight - Total duration: 25s942ms - Times executed: 107525 ]
[ User: pharmisight - Total duration: 15s970ms - Times executed: 102702 ]
[ User: pharmisight - Total duration: 3s203ms - Times executed: 22365 ]
[ User: symmetricds - Total duration: 21s376ms - Times executed: 195490 ]
[ User: pharmisight - Total duration: 1s961ms - Times executed: 36900 ]

Log levels

Key values

8,926,318 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	22	0.00%
DETAIL	2,555,032	28.62%
ERROR	16	0.00%
LOG	6,371,216	71.38%
STATEMENT	32	0.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
16 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

11 Max number of times the same event was reported
16 Total events found

Rank

Times reported

Error

1

11

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Apr 15	07	5
	10	1
	12	1
	15	1
	16	2
	17	1

ERROR: process 28888 still waiting for ShareLock on transaction 40893703 after 1000.108 ms
ERROR: process 28864 still waiting for ShareLock on transaction 40893708 after 1000.099 ms
ERROR: process 28711 still waiting for ShareLock on transaction 40893246 after 1000.094 ms

2

5

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Apr 15	12	1
	16	3
	17	1

ERROR: process 28221 still waiting for ExclusiveLock on tuple (1337,51) of relation 142522 of database 16401 after 1000.104 ms
ERROR: process 28887 still waiting for ExclusiveLock on tuple (1337,51) of relation 142522 of database 16401 after 1000.083 ms
ERROR: process 28889 still waiting for ExclusiveLock on tuple (1337,51) of relation 142522 of database 16401 after 1000.158 ms

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

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

Key values