pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Dec 28 00:00:28 2018
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 8,789,283 log entries in 26s
Log start from 2018-12-27 00:00:00 to 2018-12-27 23:59:59

Global Stats

1,186 Number of unique normalized queries
2,660,892 Number of queries
10m59s Total query duration
2018-12-27 00:00:00 First query
2018-12-27 23:59:59 Last query
11,459 queries/s at 2018-12-27 06:12:26 Query peak

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

127 Total number of automatic vacuums
275 Total number of automatic analyzes

3 Number temporary file
8.12 MiB Max size of temporary file
8.03 MiB Average size of temporary file

1,742 Total number of sessions
3 sessions at 2018-12-27 16:05:58 Session peak
11d1h50m50s Total duration of sessions
9m9s Average duration of sessions
1,527 Average queries per session
378ms Average queries duration per session

1,742 Total number of connections
12 connections/s at 2018-12-27 12:28:22 Connection peak
1 Total number of databases

SQL Traffic

Key values

11,459 queries/s Query Peak
2018-12-27 06:12:26 Date

SELECT Traffic

Key values

1,924 queries/s Query Peak
2018-12-27 08:00:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

11,422 queries/s Query Peak
2018-12-27 06:12:26 Date

Queries duration

Key values

10m59s Total query duration

Prepared queries ratio

Key values

2.62 Ratio of bind vs prepare
131.17 % 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)
Dec 27	00	58,287	0ms	16ms	0ms	59ms	201ms	1s905ms
	01	53,091	0ms	14ms	0ms	62ms	120ms	295ms
	02	52,116	0ms	16ms	0ms	49ms	60ms	301ms
	03	52,340	0ms	14ms	0ms	57ms	93ms	245ms
	04	53,008	0ms	25ms	0ms	55ms	114ms	319ms
	05	52,055	0ms	14ms	0ms	54ms	118ms	240ms
	06	218,963	0ms	7s239ms	0ms	3s560ms	18s415ms	19s193ms
	07	179,211	0ms	443ms	0ms	954ms	1s400ms	1s594ms
	08	182,970	0ms	58ms	0ms	935ms	1s96ms	1s366ms
	09	165,755	0ms	189ms	0ms	1s269ms	1s405ms	4s350ms
	10	179,691	0ms	2s71ms	0ms	2s295ms	3s143ms	3s599ms
	11	176,920	0ms	321ms	0ms	2s76ms	2s444ms	3s431ms
	12	185,446	0ms	202ms	0ms	2s634ms	3s66ms	3s193ms
	13	202,067	0ms	382ms	0ms	3s196ms	3s983ms	6s45ms
	14	164,506	0ms	202ms	0ms	2s147ms	2s927ms	3s408ms
	15	173,947	0ms	449ms	0ms	2s118ms	2s711ms	3s36ms
	16	106,343	0ms	440ms	0ms	1s587ms	2s634ms	3s930ms
	17	79,638	0ms	184ms	0ms	1s92ms	2s23ms	2s198ms
	18	53,902	0ms	100ms	0ms	50ms	92ms	807ms
	19	52,021	0ms	79ms	0ms	65ms	83ms	441ms
	20	56,498	0ms	59ms	0ms	73ms	165ms	790ms
	21	53,262	0ms	61ms	0ms	63ms	82ms	496ms
	22	54,999	0ms	59ms	0ms	62ms	142ms	494ms
	23	53,856	0ms	61ms	0ms	56ms	113ms	422ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 27	00	23,302	0ms	22ms	29ms	546ms
	01	18,208	0ms	22ms	33ms	153ms
	02	18,025	0ms	21ms	30ms	134ms
	03	18,059	0ms	22ms	29ms	152ms
	04	18,175	0ms	20ms	31ms	145ms
	05	18,001	0ms	21ms	26ms	134ms
	06	83,254	0ms	954ms	1s236ms	2s80ms
	07	86,145	0ms	527ms	646ms	1s271ms
	08	95,506	0ms	521ms	697ms	910ms
	09	83,895	0ms	789ms	1s87ms	1s599ms
	10	97,151	0ms	1s280ms	2s140ms	3s100ms
	11	90,593	0ms	1s489ms	1s647ms	2s119ms
	12	103,497	0ms	1s572ms	2s420ms	2s831ms
	13	122,358	0ms	1s722ms	2s918ms	4s691ms
	14	92,780	0ms	1s401ms	2s52ms	2s738ms
	15	92,859	0ms	1s381ms	1s999ms	2s559ms
	16	52,688	0ms	914ms	1s367ms	3s541ms
	17	36,761	0ms	549ms	827ms	1s995ms
	18	19,342	0ms	22ms	42ms	161ms
	19	18,124	0ms	24ms	38ms	155ms
	20	20,879	0ms	28ms	42ms	155ms
	21	18,249	0ms	23ms	34ms	147ms
	22	18,583	0ms	26ms	36ms	153ms
	23	18,359	0ms	27ms	38ms	149ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 27	00	348	143	83	0ms	1ms	6ms	17ms
	01	832	265	84	0ms	1ms	7ms	30ms
	02	276	108	82	0ms	0ms	4ms	8ms
	03	416	152	83	0ms	0ms	6ms	12ms
	04	752	243	85	0ms	1ms	7ms	31ms
	05	186	93	84	0ms	1ms	6ms	10ms
	06	53,532	17,146	339	1ms	195ms	796ms	16s356ms
	07	17,523	6,723	377	0ms	109ms	136ms	236ms
	08	15,737	5,978	375	0ms	95ms	125ms	161ms
	09	12,153	5,000	351	0ms	80ms	99ms	130ms
	10	12,107	5,052	349	0ms	72ms	104ms	155ms
	11	19,004	6,954	321	0ms	80ms	124ms	426ms
	12	12,099	4,843	321	0ms	93ms	122ms	212ms
	13	10,556	5,094	345	0ms	71ms	99ms	206ms
	14	9,762	3,932	302	0ms	68ms	91ms	127ms
	15	13,535	5,168	363	0ms	75ms	94ms	282ms
	16	4,883	2,040	224	0ms	38ms	53ms	142ms
	17	3,485	1,179	149	0ms	12ms	37ms	165ms
	18	684	216	114	0ms	0ms	6ms	49ms
	19	173	105	104	0ms	1ms	6ms	9ms
	20	1,236	461	146	0ms	1ms	7ms	57ms
	21	924	286	112	0ms	1ms	7ms	43ms
	22	1,976	546	112	0ms	1ms	7ms	67ms
	23	1,352	390	116	0ms	1ms	7ms	51ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 27	00	33,875	58,251	1.72	91.63%
	01	31,393	53,055	1.69	97.58%
	02	31,055	52,080	1.68	99.45%
	03	31,140	52,304	1.68	99.00%
	04	30,873	52,972	1.72	96.30%
	05	30,540	52,019	1.70	98.08%
	06	59,156	218,927	3.70	32.14%
	07	59,919	177,946	2.97	42.00%
	08	57,353	182,934	3.19	38.78%
	09	56,476	165,719	2.93	42.87%
	10	55,475	179,655	3.24	38.03%
	11	53,026	176,884	3.34	36.54%
	12	56,023	184,061	3.29	36.69%
	13	56,974	202,016	3.55	33.70%
	14	52,490	164,450	3.13	39.33%
	15	54,309	173,880	3.20	38.60%
	16	41,566	106,307	2.56	51.86%
	17	36,247	79,586	2.20	63.34%
	18	30,637	52,653	1.72	92.57%
	19	30,932	51,985	1.68	99.02%
	20	31,272	56,462	1.81	87.90%
	21	30,878	53,226	1.72	95.40%
	22	31,376	54,963	1.75	92.17%
	23	31,031	53,820	1.73	94.06%

Day	Hour	Count	Average / Second
Dec 27	00	96	0.03/s
	01	89	0.02/s
	02	87	0.02/s
	03	88	0.02/s
	04	81	0.02/s
	05	79	0.02/s
	06	80	0.02/s
	07	62	0.02/s
	08	55	0.02/s
	09	53	0.01/s
	10	52	0.01/s
	11	64	0.02/s
	12	73	0.02/s
	13	108	0.03/s
	14	79	0.02/s
	15	52	0.01/s
	16	53	0.01/s
	17	74	0.02/s
	18	64	0.02/s
	19	69	0.02/s
	20	66	0.02/s
	21	71	0.02/s
	22	74	0.02/s
	23	73	0.02/s

Day	Hour	Count	Average Duration
Dec 27	00	96	6m11s
	01	89	6m47s
	02	87	7m
	03	88	6m27s
	04	81	7m36s
	05	79	7m44s
	06	77	7m33s
	07	65	10m2s
	08	55	10m27s
	09	53	10m59s
	10	52	12m43s
	11	61	11m24s
	12	68	11m
	13	107	9m37s
	14	82	12m6s
	15	58	13m7s
	16	53	12m44s
	17	74	9m52s
	18	64	9m53s
	19	69	8m59s
	20	66	9m17s
	21	71	7m43s
	22	74	8m51s
	23	73	8m3s

↑ Back to the top of the General Activity table

Established Connections

Key values

12 connections Connection Peak
2018-12-27 12:28:22 Date

Connections per database

Key values

pharmisight Main Database
1,742 connections Total

Chart
Table

Database	User	Count
pharmisight		1,742
	pharmisight	901
	symmetricds	553
	tony	288

Connections per user

Key values

pharmisight Main User
1,742 connections Total

Chart
Table

User	Count
pharmisight	901
symmetricds	553
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1454 connections
1,742 Total connections

Chart
Table

Host	Count
10.10.10.1	1,454
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2018-12-27 16:05:58 Date

Histogram of session times

Key values

973 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	16.53%
500ms-1s	1	0.06%
1s-30s	12	0.69%
30s-1m	0	0.00%
1m-10m	973	55.86%
10m-30m	411	23.59%
30m-1h	54	3.10%
1h-8h	3	0.17%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,742 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,742	11d1h50m50s	9m9s

Sessions per user

Key values

pharmisight Main User
1,742 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	901	6d44m35s
symmetricds	553	5d1h6m3s
tony	288	11s55ms

Sessions per host

Key values

10.10.10.1 Main Host
1,742 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,454	11d1h50m38s	10m58s
::1	288	11s55ms	38ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,742 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,447	11d1h49m32s	11m1s
[unknown]	295	1m17s	261ms

Checkpoints Buffers

Key values

2,384 buffers Checkpoint Peak
2018-12-27 06:13:10 Date
149.855 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-12-27 06:18:10 Date

Checkpoints distance

Key values

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 27	00	582	58.289s	0.015s	58.36s
	01	652	65.415s	0.017s	65.493s
	02	442	44.352s	0.013s	44.42s
	03	504	50.571s	0.013s	50.64s
	04	659	66.131s	0.012s	66.2s
	05	423	42.45s	0.01s	42.515s
	06	10,672	915.327s	0.046s	915.437s
	07	7,983	811.092s	0.028s	811.187s
	08	6,782	678.285s	0.028s	678.379s
	09	5,726	572.823s	0.03s	572.913s
	10	6,040	604.387s	0.03s	604.485s
	11	6,652	591.962s	0.032s	592.067s
	12	6,727	690.76s	0.032s	690.862s
	13	5,588	560.073s	0.036s	560.171s
	14	4,822	483.831s	0.026s	483.923s
	15	5,421	543.266s	0.033s	543.362s
	16	2,899	290.768s	0.018s	290.863s
	17	2,000	201.042s	0.018s	201.149s
	18	520	52.165s	0.033s	52.274s
	19	431	43.252s	0.016s	43.328s
	20	790	79.271s	0.016s	79.349s
	21	588	59.002s	0.029s	59.093s
	22	678	68.024s	0.022s	68.109s
	23	648	65.017s	0.018s	65.096s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 27	00	0	1	276	0.002s	0s
	01	0	0	276	0.003s	0s
	02	0	0	230	0.002s	0s
	03	0	0	231	0.002s	0s
	04	0	0	262	0.002s	0s
	05	0	0	220	0.002s	0s
	06	1	8	1,192	0.014s	0s
	07	0	3	1,143	0.002s	0s
	08	0	3	1,176	0.002s	0s
	09	0	2	1,155	0.001s	0s
	10	0	3	1,180	0.002s	0s
	11	0	3	1,264	0.004s	0s
	12	0	3	1,135	0.011s	0s
	13	0	2	1,192	0.007s	0s
	14	0	2	1,062	0.002s	0s
	15	0	2	1,131	0.002s	0s
	16	0	1	879	0.002s	0s
	17	0	1	647	0.002s	0s
	18	0	0	242	0.008s	0s
	19	0	0	240	0.003s	0s
	20	0	1	314	0.002s	0s
	21	0	0	276	0.011s	0s
	22	0	0	263	0.003s	0s
	23	0	1	260	0.003s	0s

Day	Hour	Avg time (sec)
Dec 27	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
Dec 27	00	199.10 kB	378.00 kB
	01	233.70 kB	423.50 kB
	02	157.00 kB	359.67 kB
	03	194.70 kB	295.00 kB
	04	258.82 kB	416.00 kB
	05	136.73 kB	295.91 kB
	06	12,816.64 kB	39,497.18 kB
	07	4,731.50 kB	18,378.17 kB
	08	3,820.17 kB	8,111.67 kB
	09	3,090.83 kB	4,684.58 kB
	10	3,268.75 kB	3,834.00 kB
	11	4,523.83 kB	13,541.33 kB
	12	3,944.67 kB	8,567.00 kB
	13	2,917.25 kB	5,792.42 kB
	14	2,621.00 kB	3,901.27 kB
	15	3,103.92 kB	3,976.33 kB
	16	1,586.75 kB	3,373.83 kB
	17	988.50 kB	3,361.08 kB
	18	258.27 kB	1,346.73 kB
	19	201.10 kB	553.70 kB
	20	386.92 kB	769.25 kB
	21	282.75 kB	526.83 kB
	22	381.50 kB	867.17 kB
	23	361.08 kB	786.92 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

8.12 MiB Temp Files size Peak
2018-12-27 06:12:45 Date

Number of temporary files

Key values

1 per second Temp Files Peak
2018-12-27 06:12:25 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 27	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	24.08 MiB	8.03 MiB
	07	0	0	0
	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

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	1	8.12 MiB	8.12 MiB	8.12 MiB	8.12 MiB	& lt; hl7:porx_in070103uk31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "?D?-36EA?CF?B?-7C?" / > & lt; hl7:creationtime value = "?" / > & lt; hl7:versioncode code = "V?NPfIT?.?.?" / > & lt; hl7:interactionid root = "?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "PORX_IN?UK?" / > & lt; hl7:processingcode code = "P" / > & lt; hl7:processingmodecode code = "T" / > & lt; hl7:acceptackcode code = "NE" / > & lt; hl7:acknowledgement typecode = "AA" > & lt; hl7:messageref > & lt; hl7:id root = "?E?CCD?A?-4DA?-A?A?E?DC?E" / > & lt; / hl7:messageref > & lt; / hl7:acknowledgement > & lt; hl7:communicationfunctionrcv typecode = "RCV" > & lt; hl7:device classcode = "DEV" determinercode = "INSTANCE" > & lt; hl7:id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; / hl7:device > & lt; / hl7:communicationfunctionrcv > & lt; hl7:communicationfunctionsnd typecode = "SND" > & lt; hl7:device classcode = "DEV" determinercode = "INSTANCE" > & lt; hl7:id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; / hl7:device > & lt; / hl7:communicationfunctionsnd > & lt; hl7:controlactevent classcode = "CACT" moodcode = "EVN" > & lt; hl7:author1 typecode = "AUT" > & lt; hl7:agentsystemsds classcode = "AGNT" > & lt; hl7:agentsystemsds classcode = "DEV" determinercode = "INSTANCE" > & lt; hl7:id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; / hl7:agentsystemsds > & lt; / hl7:agentsystemsds > & lt; / hl7:author1 > & lt; hl7:subject typecode = "SUBJ" contextconductionind = "false" > & lt; prescriptionreleaseresponse xmlns:xsi = "http://www.w3.org/?/XMLSchema-instance" xmlns:ppdbatch = "http://spine.nhs.uk/spine-service-ppd" xmlns:fn = "http://www.w3.org/?/?/xpath-functions" xmlns:eb = "http://www.oasis-open.org/committees/ebxml-msg/schema/msg-header-2_0.xsd" xmlns:soapcsf = "http://www.w3.org/?/?/soap-envelope" xmlns = "urn:hl7-org:v3" xmlns:nasp = "http://spine.nhs.uk/spine-servicev1.?" xmlns:soap = "http://www.w3.org/?/?/soap-envelope" classcode = "INFO" moodcode = "EVN" TYPE = "ControlAct" > & lt; id root = "?D?-36EA?CF?B?-7C?" / > & lt; effectivetime value = "?" / > & lt; component TYPE = "ActRelationship" typecode = "COMP" contextconductionind = "false" > & lt; seperatableind value = "false" / > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "PORX_MT?UK?" / > & lt; parentprescription classcode = "INFO" moodcode = "EVN" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?" / > & lt; effectivetime value = "?" / > & lt; recordtarget typecode = "RCT" > & lt; patient classcode = "PAT" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; addr use = "H" > & lt; streetaddressline / > & lt; streetaddressline > ? powell drive & lt; / streetaddressline > & lt; streetaddressline / > & lt; streetaddressline > london & lt; / streetaddressline > & lt; streetaddressline > london & lt; / streetaddressline > & lt; postalcode > e4 ? fg & lt; / postalcode > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / addr > & lt; telecom use = "MC" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; patientperson classcode = "PSN" determinercode = "INSTANCE" > & lt; name use = "L" > & lt; prefix > mr & lt; / prefix > & lt; given > max & lt; / given > & lt; family > meade & lt; / family > & lt; / name > & lt; administrativegendercode code = "?" / > & lt; birthtime value = "?" / > & lt; / patientperson > & lt; sourceof typecode = "registeredWith" > & lt; gpregisteredwith classcode = "ROL" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "F?" / > & lt; / gpregisteredwith > & lt; / sourceof > & lt; / patient > & lt; / recordtarget > & lt; pertinentinformation1 typecode = "PERT" contextconductionind = "true" > & lt; seperatableind value = "true" / > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "CSAB_RM-NPfITUK?.pertinentInformation" / > & lt; pertinentprescription classcode = "SBADM" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; id root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; code codesystem = "?.?.?.?.?.?.?.?.?.?.?" code = "?" / > & lt; repeatnumber > & lt; low value = "?" / > & lt; high value = "?" / > & lt; / repeatnumber > & lt; author typecode = "AUT" contextcontrolcode = "OP" > & lt; time value = "?" / > & lt; signaturetext nullflavor = "NA" / > & lt; agentperson classcode = "AGNT" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; addr use = "WP" > & lt; streetaddressline > ? sewardstone road & lt; / streetaddressline > & lt; streetaddressline > waltham abbey & lt; / streetaddressline > & lt; streetaddressline > essex & lt; / streetaddressline > & lt; postalcode > en9 ? np & lt; / postalcode > & lt; / addr > & lt; telecom use = "WP" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; agentperson classcode = "PSN" determinercode = "INSTANCE" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; name use = "L" > & lt; prefix > dr & lt; / prefix > & lt; given > naresh & lt; / given > & lt; family > dhawan & lt; / family > & lt; / name > & lt; administrativegendercode code = "?" / > & lt; / agentperson > & lt; representedorganization classcode = "ORG" determinercode = "INSTANCE" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "F?" / > & lt; code code = "?" / > & lt; name > the market square surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetaddressline > ? sewardstone road & lt; / streetaddressline > & lt; streetaddressline > waltham abbey & lt; / streetaddressline > & lt; streetaddressline > essex & lt; / streetaddressline > & lt; postalcode > en9 ? np & lt; / postalcode > & lt; / addr > & lt; / representedorganization > & lt; / agentperson > & lt; / author > & lt; responsibleparty typecode = "RESP" contextcontrolcode = "OP" > & lt; agentperson classcode = "AGNT" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; addr use = "WP" > & lt; streetaddressline > ? sewardstone road & lt; / streetaddressline > & lt; streetaddressline > waltham abbey & lt; / streetaddressline > & lt; streetaddressline > essex & lt; / streetaddressline > & lt; postalcode > en9 ? np & lt; / postalcode > & lt; / addr > & lt; telecom use = "WP" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; agentperson classcode = "PSN" determinercode = "INSTANCE" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "?" / > & lt; name use = "L" > & lt; prefix > dr & lt; / prefix > & lt; given > naresh & lt; / given > & lt; family > dhawan & lt; / family > & lt; / name > & lt; administrativegendercode code = "?" / > & lt; / agentperson > & lt; representedorganization classcode = "ORG" determinercode = "INSTANCE" > & lt; id root = "?.?.?.?.?.?.?.?.?" EXTENSION = "F?" / > & lt; code code = "?" / > & lt; name > the market square surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:?" > & lt; useableperiod > & lt; low value = "?" / > & lt; / useableperiod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetaddressline > ? sewardstone road & lt; / streetaddressline > & lt; streetaddressline > waltham abbey & lt; / streetaddressline > & lt; streetaddressline > essex & lt; / streetaddressline > & lt; postalcode > en9 ? np & lt; / postalcode > & lt; / addr > & lt; / representedorganization > & lt; / agentperson > & lt; / responsibleparty > & lt; pertinentinformation5 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentprescriptiontreatmenttype classcode = "OBS" moodcode = "EVN" > & lt; code code = "PTT" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; / pertinentprescriptiontreatmenttype > & lt; / pertinentinformation5 > & lt; pertinentinformation8 TYPE = "ActRelationship" typecode = "PERT" contextconductionind = "true" > & lt; seperatableind value = "true" / > & lt; pertinenthighpermanentexemptioninfo classcode = "OBS" moodcode = "EVN" > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" displayname = "is ? years of age or over" / > & lt; value value = "?" / > & lt; / pertinenthighpermanentexemptioninfo > & lt; / pertinentinformation8 > & lt; pertinentinformation9 TYPE = "ActRelationship" typecode = "PERT" contextconductionind = "true" > & lt; seperatableind value = "true" / > & lt; pertinentlowpermanentexemptioninfo classcode = "OBS" moodcode = "EVN" > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" displayname = "is under ? years of age" / > & lt; value value = "?" / > & lt; / pertinentlowpermanentexemptioninfo > & lt; / pertinentinformation9 > & lt; pertinentinformation10 TYPE = "ActRelationship" typecode = "PERT" contextconductionind = "true" > & lt; seperatableind updatemode = "added" value = "false" / > & lt; pertinentprescriptionstatus TYPE = "Observation" classcode = "OBS" moodcode = "EVN" > & lt; code code = "PS" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" code = "?" displayname = "To Be Dispensed" / > & lt; / pertinentprescriptionstatus > & lt; / pertinentinformation10 > & lt; pertinentinformation1 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentdispensingsitepreference classcode = "OBS" moodcode = "EVN" > & lt; code code = "DSP" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; / pertinentdispensingsitepreference > & lt; / pertinentinformation1 > & lt; pertinentinformation2 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; templateid EXTENSION = "CSAB_RM-NPfITUK?.sourceOf2" root = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; pertinentlineitem classcode = "SBADM" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; code code = "?" / > & lt; repeatnumber > & lt; low value = "?" / > & lt; high value = "?" / > & lt; / repeatnumber > & lt; product typecode = "PRD" contextcontrolcode = "OP" > & lt; manufacturedproduct classcode = "MANU" > & lt; manufacturedrequestedmaterial classcode = "MMAT" determinercode = "KIND" > & lt; code codesystem = "?.?.?.?.?.?.?.?.?.?.?" code = "?" displayname = "Fortini Multi Fibre liquid strawberry (Nutricia Ltd)" / > & lt; / manufacturedrequestedmaterial > & lt; / manufacturedproduct > & lt; / product > & lt; pertinentinformation5 TYPE = "ActRelationship" typecode = "PERT" contextconductionind = "true" > & lt; seperatableind value = "false" / > & lt; pertinentitemstatus TYPE = "Observation" classcode = "OBS" moodcode = "EVN" > & lt; code code = "IS" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" code = "?" displayname = "To Be Dispensed" / > & lt; / pertinentitemstatus > & lt; / pertinentinformation5 > & lt; pertinentinformation1 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentadditionalinstructions classcode = "OBS" moodcode = "EVN" > & lt; code code = "AI" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value / > & lt; / pertinentadditionalinstructions > & lt; / pertinentinformation1 > & lt; pertinentinformation2 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentlineitemquantity classcode = "SPLY" moodcode = "RQO" > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; quantity value = "?" unit = "?" > & lt; translation value = "?" code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?" displayname = "ml" / > & lt; / quantity > & lt; / pertinentlineitemquantity > & lt; / pertinentinformation2 > & lt; pertinentinformation3 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentprescriberendorsement classcode = "OBS" moodcode = "EVN" > & lt; code code = "PE" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value code = "ACBS" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; / pertinentprescriberendorsement > & lt; / pertinentinformation3 > & lt; pertinentinformation4 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentdosageinstructions classcode = "OBS" moodcode = "EVN" > & lt; code code = "DI" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentdosageinstructions > & lt; / pertinentinformation4 > & lt; infulfillmentof typecode = "FLFS" > & lt; seperatableind value = "true" / > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "CSAB_RM-NPfITUK?.sourceOf1" / > & lt; priororiginalitemref classcode = "SBADM" moodcode = "RQO" > & lt; id root = "ACC?AC?-C?C?E?-BE?-D?D?" / > & lt; / priororiginalitemref > & lt; / infulfillmentof > & lt; / pertinentlineitem > & lt; / pertinentinformation2 > & lt; pertinentinformation2 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "CSAB_RM-NPfITUK?.sourceOf2" / > & lt; pertinentlineitem classcode = "SBADM" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; code code = "?" / > & lt; repeatnumber > & lt; low value = "?" / > & lt; high value = "?" / > & lt; / repeatnumber > & lt; product typecode = "PRD" contextcontrolcode = "OP" > & lt; manufacturedproduct classcode = "MANU" > & lt; manufacturedrequestedmaterial classcode = "MMAT" determinercode = "KIND" > & lt; code codesystem = "?.?.?.?.?.?.?.?.?.?.?" code = "?" displayname = "Fortini Multi Fibre liquid vanilla (Nutricia Ltd)" / > & lt; / manufacturedrequestedmaterial > & lt; / manufacturedproduct > & lt; / product > & lt; pertinentinformation5 TYPE = "ActRelationship" typecode = "PERT" contextconductionind = "true" > & lt; seperatableind value = "false" / > & lt; pertinentitemstatus TYPE = "Observation" classcode = "OBS" moodcode = "EVN" > & lt; code code = "IS" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" code = "?" displayname = "To Be Dispensed" / > & lt; / pertinentitemstatus > & lt; / pertinentinformation5 > & lt; pertinentinformation1 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentadditionalinstructions classcode = "OBS" moodcode = "EVN" > & lt; code code = "AI" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value / > & lt; / pertinentadditionalinstructions > & lt; / pertinentinformation1 > & lt; pertinentinformation2 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentlineitemquantity classcode = "SPLY" moodcode = "RQO" > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; quantity value = "?" unit = "?" > & lt; translation value = "?" code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?" displayname = "ml" / > & lt; / quantity > & lt; / pertinentlineitemquantity > & lt; / pertinentinformation2 > & lt; pertinentinformation3 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentprescriberendorsement classcode = "OBS" moodcode = "EVN" > & lt; code code = "PE" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value code = "ACBS" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; / pertinentprescriberendorsement > & lt; / pertinentinformation3 > & lt; pertinentinformation4 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentdosageinstructions classcode = "OBS" moodcode = "EVN" > & lt; code code = "DI" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentdosageinstructions > & lt; / pertinentinformation4 > & lt; infulfillmentof typecode = "FLFS" > & lt; seperatableind value = "true" / > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "CSAB_RM-NPfITUK?.sourceOf1" / > & lt; priororiginalitemref classcode = "SBADM" moodcode = "RQO" > & lt; id root = "?D?-73D?-11E?-90F?-534F?EBE?AA" / > & lt; / priororiginalitemref > & lt; / infulfillmentof > & lt; / pertinentlineitem > & lt; / pertinentinformation2 > & lt; pertinentinformation4 typecode = "PERT" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind value = "true" / > & lt; pertinentprescriptiontype classcode = "OBS" moodcode = "EVN" > & lt; code code = "PT" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; value code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?.?" / > & lt; / pertinentprescriptiontype > & lt; / pertinentinformation4 > & lt; / pertinentprescription > & lt; / pertinentinformation1 > & lt; pertinentinformation2 typecode = "PERT" > & lt; templateid root = "?.?.?.?.?.?.?.?.?.?.?.?" EXTENSION = "CSAB_RM-NPfITUK?.pertinentInformation1" / > & lt; pertinentcarerecordelementcategory classcode = "CATEGORY" moodcode = "EVN" > & lt; code code = "?" codesystem = "?.?.?.?.?.?.?.?.?.?.?" / > & lt; component typecode = "COMP" > & lt; actref classcode = "ACT" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; / actref > & lt; / component > & lt; component typecode = "COMP" > & lt; actref classcode = "ACT" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; / actref > & lt; / component > & lt; component typecode = "COMP" > & lt; actref classcode = "ACT" moodcode = "RQO" > & lt; id root = "?B?A?-0362-11E?-BCC?-AF?F?CFE?" / > & lt; / actref > & lt; / component > & lt; / pertinentcarerecordelementcategory > & lt; / pertinentinformation2 > & lt; / parentprescription > & lt; / component > & lt; infulfillmentof TYPE = "ActRelationship" typecode = "FLFS" inversionind = "false" negationind = "false" > & lt; seperatableind value = "true" / > & lt; priordownloadrequestref TYPE = "ControlAct" classcode = "INFO" moodcode = "RQO" > & lt; id root = "F?F?B?-304C?C?-A?D?-E?C?EF?B" / > & lt; / priordownloadrequestref > & lt; / infulfillmentof > & lt; / prescriptionreleaseresponse > & lt; / hl7:subject > & lt; / hl7:controlactevent > & lt; / hl7:porx_in070103uk31 > ? ? ? ? - 12 - 27 ? : ? : ?.? ? : ? ? ? ? ? b9a7121 - 0362 - 11e9 - bcc0 - af1f1683cfe7; & lt; hl7:PORX_IN070103UK31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "06607D40-36EA-49CF-81B9-7C9074763838" / > & lt; hl7:creationTime value = "20181227061210" / > & lt; hl7:versionCode code = "V3NPfIT4.2.00" / > & lt; hl7:interactionId root = "2.16.840.1.113883.2.1.3.2.4.12" EXTENSION = "PORX_IN070103UK31" / > & lt; hl7:processingCode code = "P" / > & lt; hl7:processingModeCode code = "T" / > & lt; hl7:acceptAckCode code = "NE" / > & lt; hl7:acknowledgement typeCode = "AA" > & lt; hl7:messageRef > & lt; hl7:id root = "3E640CCD-63A0-4DA0-A22A-7E23711DC39E" / > & lt; / hl7:messageRef > & lt; / hl7:acknowledgement > & lt; hl7:communicationFunctionRcv typeCode = "RCV" > & lt; hl7:device classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "099982784045" / > & lt; / hl7:device > & lt; / hl7:communicationFunctionRcv > & lt; hl7:communicationFunctionSnd typeCode = "SND" > & lt; hl7:device classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "338068513039" / > & lt; / hl7:device > & lt; / hl7:communicationFunctionSnd > & lt; hl7:ControlActEvent classCode = "CACT" moodCode = "EVN" > & lt; hl7:author1 typeCode = "AUT" > & lt; hl7:AgentSystemSDS classCode = "AGNT" > & lt; hl7:agentSystemSDS classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "338068513039" / > & lt; / hl7:agentSystemSDS > & lt; / hl7:AgentSystemSDS > & lt; / hl7:author1 > & lt; hl7:subject typeCode = "SUBJ" contextConductionInd = "false" > & lt; PrescriptionReleaseResponse xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:ppdbatch = "http://spine.nhs.uk/spine-service-ppd" xmlns:fn = "http://www.w3.org/2005/02/xpath-functions" xmlns:eb = "http://www.oasis-open.org/committees/ebxml-msg/schema/msg-header-2_0.xsd" xmlns:soapcsf = "http://www.w3.org/2001/12/soap-envelope" xmlns = "urn:hl7-org:v3" xmlns:nasp = "http://spine.nhs.uk/spine-servicev1.0" xmlns:soap = "http://www.w3.org/2001/12/soap-envelope" classCode = "INFO" moodCode = "EVN" TYPE = "ControlAct" > & lt; id root = "06607D40-36EA-49CF-81B9-7C9074763838" / > & lt; effectiveTime value = "20181227061210" / > & lt; component TYPE = "ActRelationship" typeCode = "COMP" contextConductionInd = "false" > & lt; seperatableInd value = "false" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.17.120" EXTENSION = "PORX_MT122003UK30" / > & lt; ParentPrescription classCode = "INFO" moodCode = "EVN" > & lt; id root = "0B9A7120-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "163501000000109" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" / > & lt; effectiveTime value = "20181219074514" / > & lt; recordTarget typeCode = "RCT" > & lt; Patient classCode = "PAT" > & lt; id root = "2.16.840.1.113883.2.1.4.1" EXTENSION = "6533394738" / > & lt; addr use = "H" > & lt; streetAddressLine / > & lt; streetAddressLine > 49 Powell Drive & lt; / streetAddressLine > & lt; streetAddressLine / > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > E4 7FG & lt; / postalCode > & lt; useablePeriod > & lt; low value = "20140429" / > & lt; / useablePeriod > & lt; / addr > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140612" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140626" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140924" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20170323" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20171126" / > & lt; / useablePeriod > & lt; / telecom > & lt; patientPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; name use = "L" > & lt; prefix > Mr & lt; / prefix > & lt; given > max & lt; / given > & lt; family > Meade & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; birthTime value = "20130412" / > & lt; / patientPerson > & lt; sourceOf typeCode = "registeredWith" > & lt; GpRegisteredWith classCode = "ROL" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; / GpRegisteredWith > & lt; / sourceOf > & lt; / Patient > & lt; / recordTarget > & lt; pertinentInformation1 typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation" / > & lt; pertinentPrescription classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; id root = "2.16.840.1.113883.2.1.3.2.4.18.4" EXTENSION = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE75" / > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "16076005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; author typeCode = "AUT" contextControlCode = "OP" > & lt; time value = "20181219074514" / > & lt; signatureText nullFlavor = "NA" / > & lt; AgentPerson classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "558766899106" / > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; agentPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "218948767031" / > & lt; name use = "L" > & lt; prefix > Dr & lt; / prefix > & lt; given > Naresh & lt; / given > & lt; family > Dhawan & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; / agentPerson > & lt; representedOrganization classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; code code = "001" / > & lt; name > The Market Square Surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / author > & lt; responsibleParty typeCode = "RESP" contextControlCode = "OP" > & lt; AgentPerson classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "558766899106" / > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; agentPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "218948767031" / > & lt; name use = "L" > & lt; prefix > Dr & lt; / prefix > & lt; given > Naresh & lt; / given > & lt; family > Dhawan & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; / agentPerson > & lt; representedOrganization classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; code code = "001" / > & lt; name > The Market Square Surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / responsibleParty > & lt; pertinentInformation5 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriptionTreatmentType classCode = "OBS" moodCode = "EVN" > & lt; code code = "PTT" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.36" / > & lt; / pertinentPrescriptionTreatmentType > & lt; / pertinentInformation5 > & lt; pertinentInformation8 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; pertinentHighPermanentExemptionInfo classCode = "OBS" moodCode = "EVN" > & lt; code code = "0004" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.33" displayName = "is 60 years of age or over" / > & lt; value value = "20730412" / > & lt; / pertinentHighPermanentExemptionInfo > & lt; / pertinentInformation8 > & lt; pertinentInformation9 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; pertinentLowPermanentExemptionInfo classCode = "OBS" moodCode = "EVN" > & lt; code code = "0002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.33" displayName = "is under 16 years of age" / > & lt; value value = "20290411" / > & lt; / pertinentLowPermanentExemptionInfo > & lt; / pertinentInformation9 > & lt; pertinentInformation10 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd updateMode = "added" value = "false" / > & lt; pertinentPrescriptionStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "PS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.35" code = "0001" displayName = "To Be Dispensed" / > & lt; / pertinentPrescriptionStatus > & lt; / pertinentInformation10 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDispensingSitePreference classCode = "OBS" moodCode = "EVN" > & lt; code code = "DSP" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0004" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.21" / > & lt; / pertinentDispensingSitePreference > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; templateId EXTENSION = "CSAB_RM-NPfITUK10.sourceOf2" root = "2.16.840.1.113883.2.1.3.2.4.18.2" / > & lt; pertinentLineItem classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7122-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "18629005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; product typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct classCode = "MANU" > & lt; manufacturedRequestedMaterial classCode = "MMAT" determinerCode = "KIND" > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "408311000001109" displayName = "Fortini Multi Fibre liquid strawberry (Nutricia Ltd)" / > & lt; / manufacturedRequestedMaterial > & lt; / manufacturedProduct > & lt; / product > & lt; pertinentInformation5 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "false" / > & lt; pertinentItemStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "IS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.23" code = "0007" displayName = "To Be Dispensed" / > & lt; / pertinentItemStatus > & lt; / pertinentInformation5 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentAdditionalInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "AI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value / > & lt; / pertinentAdditionalInstructions > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentLineItemQuantity classCode = "SPLY" moodCode = "RQO" > & lt; code code = "246205007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; quantity value = "3200" unit = "1" > & lt; translation value = "3200" code = "258773002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ml" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriberEndorsement classCode = "OBS" moodCode = "EVN" > & lt; code code = "PE" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "ACBS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.32" / > & lt; / pertinentPrescriberEndorsement > & lt; / pertinentInformation3 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDosageInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; inFulfillmentOf typeCode = "FLFS" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf1" / > & lt; priorOriginalItemRef classCode = "SBADM" moodCode = "RQO" > & lt; id root = "ACC6AC72-C72C-11E8-BE45-D9D500274025" / > & lt; / priorOriginalItemRef > & lt; / inFulfillmentOf > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf2" / > & lt; pertinentLineItem classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7123-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "18629005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; product typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct classCode = "MANU" > & lt; manufacturedRequestedMaterial classCode = "MMAT" determinerCode = "KIND" > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "90911000001103" displayName = "Fortini Multi Fibre liquid vanilla (Nutricia Ltd)" / > & lt; / manufacturedRequestedMaterial > & lt; / manufacturedProduct > & lt; / product > & lt; pertinentInformation5 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "false" / > & lt; pertinentItemStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "IS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.23" code = "0007" displayName = "To Be Dispensed" / > & lt; / pertinentItemStatus > & lt; / pertinentInformation5 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentAdditionalInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "AI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value / > & lt; / pertinentAdditionalInstructions > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentLineItemQuantity classCode = "SPLY" moodCode = "RQO" > & lt; code code = "246205007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; quantity value = "9600" unit = "1" > & lt; translation value = "9600" code = "258773002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ml" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriberEndorsement classCode = "OBS" moodCode = "EVN" > & lt; code code = "PE" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "ACBS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.32" / > & lt; / pertinentPrescriberEndorsement > & lt; / pertinentInformation3 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDosageInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; inFulfillmentOf typeCode = "FLFS" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf1" / > & lt; priorOriginalItemRef classCode = "SBADM" moodCode = "RQO" > & lt; id root = "51D15193-73D9-11E8-90F5-534F9EBE76AA" / > & lt; / priorOriginalItemRef > & lt; / inFulfillmentOf > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriptionType classCode = "OBS" moodCode = "EVN" > & lt; code code = "PT" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.25" / > & lt; / pertinentPrescriptionType > & lt; / pertinentInformation4 > & lt; / pertinentPrescription > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation1" / > & lt; pertinentCareRecordElementCategory classCode = "CATEGORY" moodCode = "EVN" > & lt; code code = "110" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" / > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7122-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7123-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; / pertinentCareRecordElementCategory > & lt; / pertinentInformation2 > & lt; / ParentPrescription > & lt; / component > & lt; inFulfillmentOf TYPE = "ActRelationship" typeCode = "FLFS" inversionInd = "false" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; priorDownloadRequestRef TYPE = "ControlAct" classCode = "INFO" moodCode = "RQO" > & lt; id root = "F9F4B574-304C-45C9-A2D6-E92C8EF0757B" / > & lt; / priorDownloadRequestRef > & lt; / inFulfillmentOf > & lt; / PrescriptionReleaseResponse > & lt; / hl7:subject > & lt; / hl7:ControlActEvent > & lt; / hl7:PORX_IN070103UK31 > ', $2 = ' 0 ', $3 = ' 2018 - 12 - 27 06:12:28.879728 - 00:00 ', $4 = ' 151696 ', $5 = ' 0b9a7121 - 0362 - 11e9 - bcc0 - af1f1683cfe7; Date: 2018-12-27 06:12:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files

Rank	Size	Query
1	8.12 MiB	& lt; hl7:PORX_IN070103UK31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "06607D40-36EA-49CF-81B9-7C9074763838" / > & lt; hl7:creationTime value = "20181227061210" / > & lt; hl7:versionCode code = "V3NPfIT4.2.00" / > & lt; hl7:interactionId root = "2.16.840.1.113883.2.1.3.2.4.12" EXTENSION = "PORX_IN070103UK31" / > & lt; hl7:processingCode code = "P" / > & lt; hl7:processingModeCode code = "T" / > & lt; hl7:acceptAckCode code = "NE" / > & lt; hl7:acknowledgement typeCode = "AA" > & lt; hl7:messageRef > & lt; hl7:id root = "3E640CCD-63A0-4DA0-A22A-7E23711DC39E" / > & lt; / hl7:messageRef > & lt; / hl7:acknowledgement > & lt; hl7:communicationFunctionRcv typeCode = "RCV" > & lt; hl7:device classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "099982784045" / > & lt; / hl7:device > & lt; / hl7:communicationFunctionRcv > & lt; hl7:communicationFunctionSnd typeCode = "SND" > & lt; hl7:device classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "338068513039" / > & lt; / hl7:device > & lt; / hl7:communicationFunctionSnd > & lt; hl7:ControlActEvent classCode = "CACT" moodCode = "EVN" > & lt; hl7:author1 typeCode = "AUT" > & lt; hl7:AgentSystemSDS classCode = "AGNT" > & lt; hl7:agentSystemSDS classCode = "DEV" determinerCode = "INSTANCE" > & lt; hl7:id root = "1.2.826.0.1285.0.2.0.107" EXTENSION = "338068513039" / > & lt; / hl7:agentSystemSDS > & lt; / hl7:AgentSystemSDS > & lt; / hl7:author1 > & lt; hl7:subject typeCode = "SUBJ" contextConductionInd = "false" > & lt; PrescriptionReleaseResponse xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:ppdbatch = "http://spine.nhs.uk/spine-service-ppd" xmlns:fn = "http://www.w3.org/2005/02/xpath-functions" xmlns:eb = "http://www.oasis-open.org/committees/ebxml-msg/schema/msg-header-2_0.xsd" xmlns:soapcsf = "http://www.w3.org/2001/12/soap-envelope" xmlns = "urn:hl7-org:v3" xmlns:nasp = "http://spine.nhs.uk/spine-servicev1.0" xmlns:soap = "http://www.w3.org/2001/12/soap-envelope" classCode = "INFO" moodCode = "EVN" TYPE = "ControlAct" > & lt; id root = "06607D40-36EA-49CF-81B9-7C9074763838" / > & lt; effectiveTime value = "20181227061210" / > & lt; component TYPE = "ActRelationship" typeCode = "COMP" contextConductionInd = "false" > & lt; seperatableInd value = "false" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.17.120" EXTENSION = "PORX_MT122003UK30" / > & lt; ParentPrescription classCode = "INFO" moodCode = "EVN" > & lt; id root = "0B9A7120-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "163501000000109" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" / > & lt; effectiveTime value = "20181219074514" / > & lt; recordTarget typeCode = "RCT" > & lt; Patient classCode = "PAT" > & lt; id root = "2.16.840.1.113883.2.1.4.1" EXTENSION = "6533394738" / > & lt; addr use = "H" > & lt; streetAddressLine / > & lt; streetAddressLine > 49 Powell Drive & lt; / streetAddressLine > & lt; streetAddressLine / > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > E4 7FG & lt; / postalCode > & lt; useablePeriod > & lt; low value = "20140429" / > & lt; / useablePeriod > & lt; / addr > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140612" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140626" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20140924" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20170323" / > & lt; / useablePeriod > & lt; / telecom > & lt; telecom use = "MC" value = "tel:07719196415" > & lt; useablePeriod > & lt; low value = "20171126" / > & lt; / useablePeriod > & lt; / telecom > & lt; patientPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; name use = "L" > & lt; prefix > Mr & lt; / prefix > & lt; given > max & lt; / given > & lt; family > Meade & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; birthTime value = "20130412" / > & lt; / patientPerson > & lt; sourceOf typeCode = "registeredWith" > & lt; GpRegisteredWith classCode = "ROL" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; / GpRegisteredWith > & lt; / sourceOf > & lt; / Patient > & lt; / recordTarget > & lt; pertinentInformation1 typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation" / > & lt; pertinentPrescription classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; id root = "2.16.840.1.113883.2.1.3.2.4.18.4" EXTENSION = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE75" / > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "16076005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; author typeCode = "AUT" contextControlCode = "OP" > & lt; time value = "20181219074514" / > & lt; signatureText nullFlavor = "NA" / > & lt; AgentPerson classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "558766899106" / > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; agentPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "218948767031" / > & lt; name use = "L" > & lt; prefix > Dr & lt; / prefix > & lt; given > Naresh & lt; / given > & lt; family > Dhawan & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; / agentPerson > & lt; representedOrganization classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; code code = "001" / > & lt; name > The Market Square Surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / author > & lt; responsibleParty typeCode = "RESP" contextControlCode = "OP" > & lt; AgentPerson classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "558766899106" / > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; agentPerson classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "218948767031" / > & lt; name use = "L" > & lt; prefix > Dr & lt; / prefix > & lt; given > Naresh & lt; / given > & lt; family > Dhawan & lt; / family > & lt; / name > & lt; administrativeGenderCode code = "1" / > & lt; / agentPerson > & lt; representedOrganization classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "2.16.840.1.113883.2.1.4.3" EXTENSION = "F81749" / > & lt; code code = "001" / > & lt; name > The Market Square Surgery & lt; / name > & lt; DESC / > & lt; telecom use = "WP" value = "tel:01992707130" > & lt; useablePeriod > & lt; low value = "20181219" / > & lt; / useablePeriod > & lt; / telecom > & lt; addr use = "WP" > & lt; streetAddressLine > 13 Sewardstone Road & lt; / streetAddressLine > & lt; streetAddressLine > Waltham Abbey & lt; / streetAddressLine > & lt; streetAddressLine > Essex & lt; / streetAddressLine > & lt; postalCode > EN9 1NP & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / responsibleParty > & lt; pertinentInformation5 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriptionTreatmentType classCode = "OBS" moodCode = "EVN" > & lt; code code = "PTT" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.36" / > & lt; / pertinentPrescriptionTreatmentType > & lt; / pertinentInformation5 > & lt; pertinentInformation8 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; pertinentHighPermanentExemptionInfo classCode = "OBS" moodCode = "EVN" > & lt; code code = "0004" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.33" displayName = "is 60 years of age or over" / > & lt; value value = "20730412" / > & lt; / pertinentHighPermanentExemptionInfo > & lt; / pertinentInformation8 > & lt; pertinentInformation9 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "true" / > & lt; pertinentLowPermanentExemptionInfo classCode = "OBS" moodCode = "EVN" > & lt; code code = "0002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.33" displayName = "is under 16 years of age" / > & lt; value value = "20290411" / > & lt; / pertinentLowPermanentExemptionInfo > & lt; / pertinentInformation9 > & lt; pertinentInformation10 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd updateMode = "added" value = "false" / > & lt; pertinentPrescriptionStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "PS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.35" code = "0001" displayName = "To Be Dispensed" / > & lt; / pertinentPrescriptionStatus > & lt; / pertinentInformation10 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDispensingSitePreference classCode = "OBS" moodCode = "EVN" > & lt; code code = "DSP" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0004" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.21" / > & lt; / pertinentDispensingSitePreference > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; templateId EXTENSION = "CSAB_RM-NPfITUK10.sourceOf2" root = "2.16.840.1.113883.2.1.3.2.4.18.2" / > & lt; pertinentLineItem classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7122-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "18629005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; product typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct classCode = "MANU" > & lt; manufacturedRequestedMaterial classCode = "MMAT" determinerCode = "KIND" > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "408311000001109" displayName = "Fortini Multi Fibre liquid strawberry (Nutricia Ltd)" / > & lt; / manufacturedRequestedMaterial > & lt; / manufacturedProduct > & lt; / product > & lt; pertinentInformation5 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "false" / > & lt; pertinentItemStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "IS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.23" code = "0007" displayName = "To Be Dispensed" / > & lt; / pertinentItemStatus > & lt; / pertinentInformation5 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentAdditionalInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "AI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value / > & lt; / pertinentAdditionalInstructions > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentLineItemQuantity classCode = "SPLY" moodCode = "RQO" > & lt; code code = "246205007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; quantity value = "3200" unit = "1" > & lt; translation value = "3200" code = "258773002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ml" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriberEndorsement classCode = "OBS" moodCode = "EVN" > & lt; code code = "PE" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "ACBS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.32" / > & lt; / pertinentPrescriberEndorsement > & lt; / pertinentInformation3 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDosageInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; inFulfillmentOf typeCode = "FLFS" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf1" / > & lt; priorOriginalItemRef classCode = "SBADM" moodCode = "RQO" > & lt; id root = "ACC6AC72-C72C-11E8-BE45-D9D500274025" / > & lt; / priorOriginalItemRef > & lt; / inFulfillmentOf > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf2" / > & lt; pertinentLineItem classCode = "SBADM" moodCode = "RQO" > & lt; id root = "0B9A7123-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; code code = "18629005" / > & lt; repeatNumber > & lt; low value = "1" / > & lt; high value = "1" / > & lt; / repeatNumber > & lt; product typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct classCode = "MANU" > & lt; manufacturedRequestedMaterial classCode = "MMAT" determinerCode = "KIND" > & lt; code codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" code = "90911000001103" displayName = "Fortini Multi Fibre liquid vanilla (Nutricia Ltd)" / > & lt; / manufacturedRequestedMaterial > & lt; / manufacturedProduct > & lt; / product > & lt; pertinentInformation5 TYPE = "ActRelationship" typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd value = "false" / > & lt; pertinentItemStatus TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "IS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.23" code = "0007" displayName = "To Be Dispensed" / > & lt; / pertinentItemStatus > & lt; / pertinentInformation5 > & lt; pertinentInformation1 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentAdditionalInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "AI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value / > & lt; / pertinentAdditionalInstructions > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentLineItemQuantity classCode = "SPLY" moodCode = "RQO" > & lt; code code = "246205007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; quantity value = "9600" unit = "1" > & lt; translation value = "9600" code = "258773002" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ml" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriberEndorsement classCode = "OBS" moodCode = "EVN" > & lt; code code = "PE" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "ACBS" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.32" / > & lt; / pertinentPrescriberEndorsement > & lt; / pertinentInformation3 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentDosageInstructions classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value > use AS directed & lt; / value > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; inFulfillmentOf typeCode = "FLFS" > & lt; seperatableInd value = "true" / > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.sourceOf1" / > & lt; priorOriginalItemRef classCode = "SBADM" moodCode = "RQO" > & lt; id root = "51D15193-73D9-11E8-90F5-534F9EBE76AA" / > & lt; / priorOriginalItemRef > & lt; / inFulfillmentOf > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation4 typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; pertinentPrescriptionType classCode = "OBS" moodCode = "EVN" > & lt; code code = "PT" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; value code = "0001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.25" / > & lt; / pertinentPrescriptionType > & lt; / pertinentInformation4 > & lt; / pertinentPrescription > & lt; / pertinentInformation1 > & lt; pertinentInformation2 typeCode = "PERT" > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation1" / > & lt; pertinentCareRecordElementCategory classCode = "CATEGORY" moodCode = "EVN" > & lt; code code = "110" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" / > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7121-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7122-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; component typeCode = "COMP" > & lt; actRef classCode = "ACT" moodCode = "RQO" > & lt; id root = "0B9A7123-0362-11E9-BCC0-AF1F1683CFE7" / > & lt; / actRef > & lt; / component > & lt; / pertinentCareRecordElementCategory > & lt; / pertinentInformation2 > & lt; / ParentPrescription > & lt; / component > & lt; inFulfillmentOf TYPE = "ActRelationship" typeCode = "FLFS" inversionInd = "false" negationInd = "false" > & lt; seperatableInd value = "true" / > & lt; priorDownloadRequestRef TYPE = "ControlAct" classCode = "INFO" moodCode = "RQO" > & lt; id root = "F9F4B574-304C-45C9-A2D6-E92C8EF0757B" / > & lt; / priorDownloadRequestRef > & lt; / inFulfillmentOf > & lt; / PrescriptionReleaseResponse > & lt; / hl7:subject > & lt; / hl7:ControlActEvent > & lt; / hl7:PORX_IN070103UK31 > ', $2 = ' 0 ', $3 = ' 2018 - 12 - 27 06:12:28.879728 - 00:00 ', $4 = ' 151696 ', $5 = ' 0b9a7121 - 0362 - 11e9 - bcc0 - af1f1683cfe7; [ Date: 2018-12-27 06:12:45 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

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 (106) Main table analyzed (database pharmisight)
275 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	106
pharmisight.public.sym_outgoing_batch	89
pharmisight.public.sym_data_event	22
pharmisight.public.sym_data	20
pharmisight.public.sym_incoming_batch	14
pharmisight.public.sym_sequence	12
pharmisight.public.sym_node_host	5
pharmisight.public.item_codes	3
pharmisight.public.flow_report_summary_delays	1
pharmisight.public.eps_claims	1
pharmisight.public.stats_picker_days	1
pharmisight.public.tablet_logs	1
Total	275

Vacuums per table

Key values

public.sym_data_gap (56) Main table vacuumed on database pharmisight
127 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	56	56
pharmisight.public.sym_outgoing_batch	41	41
pharmisight.public.sym_sequence	12	0
pharmisight.public.sym_node_host	6	0
pharmisight.public.sym_incoming_batch	6	6
pharmisight.pg_toast.pg_toast_2619	4	4
pharmisight.pg_catalog.pg_statistic	1	1
pharmisight.public.item_codes	1	1
Total	127	109

Tuples removed per table

Key values

public.sym_data_gap (2943) Main table with removed tuples on database pharmisight
6747 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_gap	56	56	2943	0
pharmisight.public.sym_outgoing_batch	41	41	1463	0
pharmisight.public.sym_incoming_batch	6	6	621	4
pharmisight.public.sym_sequence	12	0	612	0
pharmisight.public.item_codes	1	1	377	0
pharmisight.public.sym_node_host	6	0	312	0
pharmisight.pg_toast.pg_toast_2619	4	4	262	4
pharmisight.pg_catalog.pg_statistic	1	1	157	0
Total	127	109	6,747	8

Pages removed per table

Key values

public.sym_incoming_batch (4) Main table with removed pages on database pharmisight
8 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_incoming_batch	6	6	621	4
pharmisight.pg_toast.pg_toast_2619	4	4	262	4
pharmisight.public.sym_node_host	6	0	312	0
pharmisight.public.sym_data_gap	56	56	2943	0
pharmisight.pg_catalog.pg_statistic	1	1	157	0
pharmisight.public.sym_sequence	12	0	612	0
pharmisight.public.item_codes	1	1	377	0
pharmisight.public.sym_outgoing_batch	41	41	1463	0
Total	127	109	6,747	8

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 27	00	2	3
	01	1	4
	02	1	4
	03	2	3
	04	2	6
	05	1	2
	06	17	38
	07	14	34
	08	13	27
	09	10	23
	10	11	22
	11	10	18
	12	8	19
	13	8	17
	14	6	14
	15	11	18
	16	4	7
	17	0	2
	18	1	2
	19	2	2
	20	1	4
	21	1	2
	22	0	1
	23	1	3

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
17 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		2	4s379ms	2s189ms
	tuple	2	4s379ms	2s189ms
ShareLock		15	43s414ms	2s894ms
	transaction	15	43s414ms	2s894ms
	Total	17	47s793ms	2s811ms

Most frequent waiting queries (N)

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

Queries that waited the most


[ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:40 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-27 06:25:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	3s927ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	3s825ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	3s693ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	3s564ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	3s545ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	3s533ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	3s533ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	3s52ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	2s986ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	2s938ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	2s895ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	2s222ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	2s161ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:40 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	1s648ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	1s570ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	1s440ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	1s253ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,264,793 Total read queries
760,195 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,264,793	47.53%
INSERT	193,531	7.27%
UPDATE	72,117	2.71%
DELETE	5,021	0.19%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	3	0.00%
TCL	489,523	18.40%
OTHERS	635,904	23.90%

Queries by database

Key values

pharmisight Main database
2,660,892 Requests
10m59s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,660,892	10m59s
	DDL	3	3ms
	DELETE	5,021	5s417ms
	INSERT	193,531	32s397ms
	OTHERS	635,904	9s661ms
	SELECT	1,264,793	7m57s
	TCL	489,523	28s442ms
	UPDATE	72,117	1m46s

Queries by user

Key values

symmetricds Main user
1,740,407 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	970,671	9m22s
	DELETE	53	1s897ms
	INSERT	31,244	21s314ms
	OTHERS	2,840	104ms
	SELECT	818,011	7m13s
	TCL	77,110	7s851ms
	UPDATE	41,413	1m37s
symmetricds	Total	1,740,407	1m39s
	DDL	3	3ms
	DELETE	5,040	3s527ms
	INSERT	163,034	11s227ms
	OTHERS	654,013	9s878ms
	SELECT	462,113	44s794ms
	TCL	425,249	20s841ms
	UPDATE	30,955	9s317ms
tony	Total	900	233ms
	SELECT	900	233ms

Duration by user

Key values

9m22s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	970,671	9m22s
	DELETE	53	1s897ms
	INSERT	31,244	21s314ms
	OTHERS	2,840	104ms
	SELECT	818,011	7m13s
	TCL	77,110	7s851ms
	UPDATE	41,413	1m37s
symmetricds	Total	1,740,407	1m39s
	DDL	3	3ms
	DELETE	5,040	3s527ms
	INSERT	163,034	11s227ms
	OTHERS	654,013	9s878ms
	SELECT	462,113	44s794ms
	TCL	425,249	20s841ms
	UPDATE	30,955	9s317ms
tony	Total	900	233ms
	SELECT	900	233ms

Queries by host

Key values

10.10.10.1 Main host
2,711,078 Requests
11m1s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,711,078	11m1s
	DDL	3	3ms
	DELETE	5,093	5s424ms
	INSERT	194,278	32s542ms
	OTHERS	656,853	9s982ms
	SELECT	1,280,124	7m58s
	TCL	502,359	28s692ms
	UPDATE	72,368	1m46s
::1	Total	900	233ms
	SELECT	900	233ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,654,708 Requests
10m59s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,654,708	10m59s
	DDL	3	3ms
	DELETE	5,021	5s417ms
	INSERT	193,468	32s349ms
	OTHERS	634,443	9s605ms
	SELECT	1,260,301	7m56s
	TCL	489,355	28s415ms
	UPDATE	72,117	1m46s
[unknown]	Total	6,184	838ms
	INSERT	63	47ms
	OTHERS	1,461	55ms
	SELECT	4,492	707ms
	TCL	168	27ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-12-27 12:35:13 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,585,816 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,585,816	97.18%
1-5ms	61,732	2.32%
5-10ms	4,104	0.15%
10-25ms	5,560	0.21%
25-50ms	3,205	0.12%
50-100ms	304	0.01%
100-500ms	147	0.01%
500-1000ms	7	0.00%
1000-10000ms	17	0.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:26:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:26:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:40 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 10:57:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:26:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:11:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 10:22:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 10:22:44 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 10:23:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:25:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-27 06:12:45 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	7s239ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	7s44ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	6s867ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	4s442ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	4s336ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:37 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	3s825ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	3s565ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	2s994ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:27:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	2s223ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	2s162ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:40 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	2s71ms	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 $1 AND $2; [ Date: 2018-12-27 10:57:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1s651ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	1s571ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:26:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	1s558ms	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 $1 AND $2; [ Date: 2018-12-27 06:11:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	1s253ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	1s133ms	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 <> $1 AND (this_.patientAlert = $2 OR this_.itemAlert = $3) AND (this_.ageCheck <> $4 OR (this_.patientAlert <> $5 OR this_.itemAlert <> $6) OR this_.status = $7 OR this_.rxStatus = $8 OR (this_.overAverageQtyMax <> $9)) ORDER BY this_.routeNumber ASC, this_.lastName ASC, this_.partCode ASC LIMIT $10; [ Date: 2018-12-27 10:22:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1s100ms	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 <> $1 AND (this_.patientAlert = $2 OR this_.itemAlert = $3) AND (this_.ageCheck <> $4 OR (this_.patientAlert <> $5 OR this_.itemAlert <> $6) OR this_.status = $7 OR this_.rxStatus = $8 OR (this_.overAverageQtyMax <> $9)) ORDER BY this_.routeNumber ASC, this_.lastName ASC, this_.partCode ASC LIMIT $10; [ Date: 2018-12-27 10:22:44 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	998ms	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 <> $1 AND (this_.patientAlert = $2 OR this_.itemAlert = $3) AND (this_.ageCheck <> $4 OR (this_.patientAlert <> $5 OR this_.itemAlert <> $6) OR this_.status = $7 OR this_.rxStatus = $8 OR (this_.overAverageQtyMax <> $9)) ORDER BY this_.routeNumber ASC, this_.lastName ASC, this_.partCode ASC LIMIT $10; [ Date: 2018-12-27 10:23:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	916ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-27 06:25:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	742ms	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 = $1 AND o.node_id = $2 ORDER BY d.data_id ASC; [ Date: 2018-12-27 06:12:45 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1m37s - Times executed: 3111 ]
[ User: pharmisight - Total duration: 53s303ms - Times executed: 3115 ]
[ User: pharmisight - Total duration: 52s758ms - Times executed: 699 ]
[ User: pharmisight - Total duration: 38s398ms - Times executed: 12448 ]
[ User: pharmisight - Total duration: 30s785ms - Times executed: 38775 ]
[ User: symmetricds - Total duration: 19s344ms - Times executed: 206215 ]
[ User: pharmisight - Total duration: 18s563ms - Times executed: 56951 ]
[ User: pharmisight - Total duration: 17s276ms - Times executed: 4525 ]
[ User: pharmisight - Total duration: 17s240ms - Times executed: 7640 ]
[ User: symmetricds - Total duration: 13s521ms - Times executed: 25709 ]
[ User: pharmisight - Total duration: 12s270ms - Times executed: 131297 ]
[ User: pharmisight - Total duration: 12s76ms - Times executed: 224 ]
[ User: pharmisight - Total duration: 11s283ms - Times executed: 409 ]
[ User: pharmisight - Total duration: 10s581ms - Times executed: 514 ]
[ User: pharmisight - Total duration: 9s744ms - Times executed: 3112 ]
[ User: pharmisight - Total duration: 9s343ms - Times executed: 444 ]
[ User: symmetricds - Total duration: 8s999ms - Times executed: 592209 ]
[ User: pharmisight - Total duration: 8s457ms - Times executed: 12900 ]
[ User: pharmisight - Total duration: 8s252ms - Times executed: 12900 ]
[ User: pharmisight - Total duration: 8s112ms - Times executed: 51 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 8s999ms - Times executed: 592209 ]
[ User: symmetricds - Total duration: 1s250ms - Times executed: 206216 ]
[ User: symmetricds - Total duration: 19s344ms - Times executed: 206215 ]
[ User: symmetricds - Total duration: 2s462ms - Times executed: 238315 ]
[ User: symmetricds - Total duration: 7s695ms - Times executed: 145630 ]
[ User: pharmisight - Total duration: 12s270ms - Times executed: 131297 ]
[ User: pharmisight - Total duration: 4s654ms - Times executed: 120100 ]
[ User: pharmisight - Total duration: 18s563ms - Times executed: 56951 ]
[ User: pharmisight - Total duration: 2s527ms - Times executed: 51969 ]
[ User: pharmisight - Total duration: 2s480ms - Times executed: 49652 ]
[ User: pharmisight - Total duration: 1s631ms - Times executed: 40567 ]
[ User: pharmisight - Total duration: 30s785ms - Times executed: 38775 ]
[ User: symmetricds - Total duration: 1s498ms - Times executed: 31227 ]
[ User: symmetricds - Total duration: 1s210ms - Times executed: 26407 ]
[ User: symmetricds - Total duration: 13s521ms - Times executed: 25709 ]
[ User: pharmisight - Total duration: 1s72ms - Times executed: 25151 ]
[ User: pharmisight - Total duration: 715ms - Times executed: 24251 ]
[ User: pharmisight - Total duration: 1s191ms - Times executed: 23260 ]
[ User: symmetricds - Total duration: 5s752ms - Times executed: 21430 ]
[ User: symmetricds - Total duration: 241ms - Times executed: 19947 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 8s112ms - Times executed: 51 ]
[ User: pharmisight - Total duration: 52s758ms - Times executed: 699 ]
[ User: pharmisight - Total duration: 12s76ms - Times executed: 224 ]
[ User: pharmisight - Total duration: 1m37s - Times executed: 3111 ]
[ User: pharmisight - Total duration: 11s283ms - Times executed: 409 ]
[ User: pharmisight - Total duration: 9s343ms - Times executed: 444 ]
[ User: pharmisight - Total duration: 10s581ms - Times executed: 514 ]
[ User: pharmisight - Total duration: 53s303ms - Times executed: 3115 ]
[ User: pharmisight - Total duration: 17s276ms - Times executed: 4525 ]
[ User: pharmisight - Total duration: 9s744ms - Times executed: 3112 ]
[ User: pharmisight - Total duration: 38s398ms - Times executed: 12448 ]
[ User: pharmisight - Total duration: 17s240ms - Times executed: 7640 ]
[ User: pharmisight - Total duration: 30s785ms - Times executed: 38775 ]
[ User: pharmisight - Total duration: 8s457ms - Times executed: 12900 ]
[ User: pharmisight - Total duration: 8s252ms - Times executed: 12900 ]
[ User: symmetricds - Total duration: 13s521ms - Times executed: 25709 ]
[ User: pharmisight - Total duration: 18s563ms - Times executed: 56951 ]
[ User: symmetricds - Total duration: 5s752ms - Times executed: 21430 ]
[ User: symmetricds - Total duration: 19s344ms - Times executed: 206215 ]
[ User: pharmisight - Total duration: 12s270ms - Times executed: 131297 ]

Log levels

Key values

8,699,662 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	30	0.00%
DETAIL	2,363,156	27.16%
ERROR	18	0.00%
FATAL	1	0.00%
LOG	6,336,422	72.84%
STATEMENT	35	0.00%

Events distribution

Key values

0 PANIC entries
1 FATAL entries
18 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

15 Max number of times the same event was reported
19 Total events found

Rank

Times reported

Error

1

15

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 27	06	15

ERROR: process 29648 still waiting for ShareLock on transaction 30510489 after 1000.175 ms
ERROR: process 29648 still waiting for ShareLock on transaction 30510537 after 1000.070 ms
ERROR: process 29632 still waiting for ShareLock on transaction 30510539 after 1000.097 ms

2

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
Dec 27	06	2

ERROR: process 29632 still waiting for ExclusiveLock on tuple (1305,33) of relation 142522 of database 16401 after 1000.091 ms
ERROR: process 29520 still waiting for ExclusiveLock on tuple (1302,101) of relation 142522 of database 16401 after 1000.100 ms

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 27	00	1

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

4

1

Details

FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 27	01	1

FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0

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

Queries generating the most temporary files (N)

Queries generating the largest temporary files

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