pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Oct 10 00:00:46 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 10,589,354 log entries in 43s
Log start from 2018-10-09 00:00:00 to 2018-10-09 23:59:59

Global Stats

1,029 Number of unique normalized queries
3,356,743 Number of queries
10m45s Total query duration
2018-10-09 00:00:00 First query
2018-10-09 23:59:59 Last query
10,482 queries/s at 2018-10-09 06:01:13 Query peak

3 Number of events
3 Number of unique normalized events
1 Max number of times the same event was reported
0 Number of cancellation

420 Total number of automatic vacuums
512 Total number of automatic analyzes

3 Number temporary file
8.51 MiB Max size of temporary file
8.45 MiB Average size of temporary file

1,522 Total number of sessions
3 sessions at 2018-10-09 14:41:59 Session peak
10d19h7m13s Total duration of sessions
10m12s Average duration of sessions
2,205 Average queries per session
424ms Average queries duration per session

1,522 Total number of connections
12 connections/s at 2018-10-09 12:08:23 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,482 queries/s Query Peak
2018-10-09 06:01:13 Date

SELECT Traffic

Key values

2,094 queries/s Query Peak
2018-10-09 10:20:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,360 queries/s Query Peak
2018-10-09 06:01:13 Date

Queries duration

Key values

10m45s Total query duration

Prepared queries ratio

Key values

2.19 Ratio of bind vs prepare
138.99 % 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)
Oct 09	00	98,271	0ms	63ms	0ms	73ms	167ms	1s293ms
	01	96,986	0ms	61ms	0ms	82ms	237ms	448ms
	02	95,432	0ms	64ms	0ms	59ms	113ms	533ms
	03	97,019	0ms	63ms	0ms	57ms	237ms	449ms
	04	95,672	0ms	64ms	0ms	59ms	154ms	447ms
	05	128,059	0ms	161ms	0ms	478ms	3s602ms	7s173ms
	06	320,840	0ms	144ms	0ms	4s281ms	4s483ms	5s569ms
	07	205,510	0ms	112ms	0ms	1s346ms	1s696ms	2s159ms
	08	246,643	0ms	286ms	0ms	3s294ms	3s874ms	4s50ms
	09	209,368	0ms	277ms	0ms	2s712ms	3s175ms	3s903ms
	10	122,128	0ms	284ms	0ms	997ms	2s15ms	2s304ms
	11	273,500	0ms	2s757ms	0ms	3s283ms	4s140ms	6s974ms
	12	187,811	0ms	234ms	0ms	2s203ms	2s647ms	3s837ms
	13	151,328	0ms	301ms	0ms	2s598ms	4s277ms	5s180ms
	14	138,535	0ms	203ms	0ms	1s162ms	1s556ms	2s885ms
	15	116,310	0ms	776ms	0ms	879ms	1s692ms	2s499ms
	16	110,720	0ms	198ms	0ms	894ms	1s504ms	2s350ms
	17	100,724	0ms	165ms	0ms	376ms	917ms	2s777ms
	18	92,475	0ms	19ms	0ms	61ms	92ms	239ms
	19	92,485	0ms	13ms	0ms	55ms	89ms	264ms
	20	93,382	0ms	22ms	0ms	68ms	176ms	453ms
	21	93,426	0ms	14ms	0ms	53ms	111ms	331ms
	22	93,958	0ms	12ms	0ms	69ms	162ms	440ms
	23	96,161	0ms	17ms	0ms	60ms	187ms	435ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 09	00	34,423	0ms	29ms	42ms	161ms
	01	33,094	0ms	29ms	34ms	180ms
	02	32,875	0ms	31ms	39ms	165ms
	03	33,178	0ms	32ms	35ms	165ms
	04	32,882	0ms	28ms	33ms	153ms
	05	47,987	0ms	31ms	164ms	1s328ms
	06	148,133	0ms	1s999ms	2s613ms	4s347ms
	07	95,696	0ms	508ms	1s10ms	1s404ms
	08	121,551	0ms	2s336ms	2s827ms	3s360ms
	09	105,809	0ms	1s793ms	2s396ms	3s288ms
	10	47,831	0ms	136ms	814ms	2s135ms
	11	151,116	0ms	2s394ms	2s952ms	5s609ms
	12	90,239	0ms	1s228ms	2s82ms	2s560ms
	13	72,036	0ms	1s449ms	2s495ms	4s218ms
	14	55,108	0ms	388ms	1s33ms	1s538ms
	15	43,844	0ms	234ms	791ms	2s233ms
	16	44,603	0ms	156ms	763ms	1s473ms
	17	37,382	0ms	34ms	147ms	1s340ms
	18	30,814	0ms	28ms	33ms	43ms
	19	30,886	0ms	27ms	33ms	79ms
	20	32,775	0ms	29ms	36ms	172ms
	21	31,032	0ms	27ms	34ms	54ms
	22	29,566	0ms	27ms	34ms	53ms
	23	33,121	0ms	32ms	34ms	171ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 09	00	1,411	956	107	0ms	4ms	9ms	75ms
	01	1,908	1,078	108	0ms	2ms	9ms	124ms
	02	748	788	109	0ms	2ms	9ms	26ms
	03	1,756	1,040	109	0ms	1ms	8ms	106ms
	04	1,008	854	111	0ms	1ms	9ms	61ms
	05	7,929	7,786	132	0ms	7ms	85ms	1s997ms
	06	53,807	15,004	510	0ms	391ms	491ms	1s208ms
	07	14,442	7,505	396	0ms	201ms	284ms	385ms
	08	17,161	8,704	421	0ms	280ms	357ms	524ms
	09	11,643	6,004	323	0ms	202ms	252ms	305ms
	10	3,776	2,458	180	0ms	56ms	87ms	134ms
	11	17,627	8,940	395	0ms	227ms	293ms	389ms
	12	8,927	5,804	289	0ms	125ms	172ms	234ms
	13	3,056	2,703	224	0ms	60ms	86ms	205ms
	14	4,748	3,655	261	0ms	68ms	94ms	129ms
	15	2,639	2,092	179	0ms	37ms	80ms	145ms
	16	1,483	1,207	132	0ms	13ms	35ms	159ms
	17	374	821	116	0ms	5ms	13ms	80ms
	18	112	629	108	0ms	1ms	9ms	12ms
	19	143	650	108	0ms	1ms	9ms	12ms
	20	136	623	128	0ms	1ms	8ms	12ms
	21	628	758	109	0ms	1ms	9ms	30ms
	22	2,298	1,174	101	0ms	2ms	9ms	117ms
	23	1,321	928	107	0ms	1ms	9ms	82ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Oct 09	00	57,056	98,235	1.72	92.67%
	01	55,100	96,950	1.76	90.86%
	02	54,779	95,396	1.74	92.81%
	03	55,768	96,983	1.74	92.04%
	04	55,009	95,636	1.74	92.74%
	05	59,458	128,023	2.15	65.90%
	06	88,116	319,543	3.63	32.48%
	07	78,834	205,474	2.61	49.12%
	08	84,122	246,607	2.93	42.07%
	09	75,559	209,332	2.77	45.53%
	10	62,549	122,092	1.95	74.98%
	11	84,228	273,464	3.25	37.16%
	12	75,885	187,686	2.47	52.61%
	13	66,799	151,277	2.26	59.87%
	14	68,983	138,437	2.01	70.68%
	15	62,071	116,274	1.87	79.79%
	16	59,172	110,684	1.87	80.25%
	17	56,431	99,642	1.77	88.08%
	18	54,575	92,424	1.69	97.22%
	19	54,803	92,449	1.69	97.50%
	20	54,077	93,346	1.73	93.76%
	21	54,802	93,390	1.70	96.09%
	22	54,873	93,922	1.71	95.26%
	23	55,151	96,128	1.74	92.10%

Day	Hour	Count	Average / Second
Oct 09	00	80	0.02/s
	01	63	0.02/s
	02	59	0.02/s
	03	69	0.02/s
	04	63	0.02/s
	05	69	0.02/s
	06	62	0.02/s
	07	66	0.02/s
	08	56	0.02/s
	09	63	0.02/s
	10	61	0.02/s
	11	66	0.02/s
	12	79	0.02/s
	13	71	0.02/s
	14	60	0.02/s
	15	56	0.02/s
	16	66	0.02/s
	17	58	0.02/s
	18	59	0.02/s
	19	58	0.02/s
	20	67	0.02/s
	21	56	0.02/s
	22	54	0.01/s
	23	61	0.02/s

Day	Hour	Count	Average Duration
Oct 09	00	80	7m5s
	01	63	9m50s
	02	59	9m40s
	03	69	9m7s
	04	63	9m6s
	05	63	9m13s
	06	68	11m26s
	07	66	9m54s
	08	54	9m39s
	09	62	12m5s
	10	64	10m56s
	11	62	12m12s
	12	83	10m29s
	13	71	10m54s
	14	60	10m28s
	15	56	10m6s
	16	66	10m53s
	17	58	11m9s
	18	59	9m38s
	19	58	10m8s
	20	67	9m34s
	21	56	10m20s
	22	54	11m47s
	23	61	10m11s

↑ Back to the top of the General Activity table

Established Connections

Key values

12 connections Connection Peak
2018-10-09 12:08:23 Date

Connections per database

Key values

pharmisight Main Database
1,522 connections Total

Chart
Table

Database	User	Count
pharmisight		1,522
	pharmisight	649
	symmetricds	586
	tony	287

Connections per user

Key values

pharmisight Main User
1,522 connections Total

Chart
Table

User	Count
pharmisight	649
symmetricds	586
tony	287

Connections per host

Key values

10.10.10.1 Main host with 1235 connections
1,522 Total connections

Chart
Table

Host	Count
10.10.10.1	1,235
::1	287

Simultaneous sessions

Key values

3 sessions Session Peak
2018-10-09 14:41:59 Date

Histogram of session times

Key values

717 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	18.92%
500ms-1s	0	0.00%
1s-30s	6	0.39%
30s-1m	0	0.00%
1m-10m	717	47.11%
10m-30m	440	28.91%
30m-1h	65	4.27%
1h-8h	6	0.39%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,522 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,522	10d19h7m13s	10m12s

Sessions per user

Key values

pharmisight Main User
1,522 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	649	5d18h11m22s
symmetricds	586	5d55m35s
tony	287	15s739ms

Sessions per host

Key values

10.10.10.1 Main Host
1,522 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,235	10d19h6m57s	12m35s
::1	287	15s739ms	54ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,522 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,229	10d19h5m55s	12m38s
[unknown]	293	1m18s	266ms

Checkpoints Buffers

Key values

4,151 buffers Checkpoint Peak
2018-10-09 07:07:11 Date
149.960 seconds Highest write time
0.017 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-10-09 06:10:30 Date

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

NO DATASET

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Oct 09	00	1,012	101.315s	0.019s	101.396s
	01	915	91.714s	0.028s	91.809s
	02	840	84.266s	0.011s	84.336s
	03	935	93.809s	0.013s	93.865s
	04	757	75.946s	0.012s	75.998s
	05	678	68.024s	0.014s	68.072s
	06	10,429	965.14s	0.024s	965.249s
	07	9,538	711.308s	0.02s	711.368s
	08	7,797	774.491s	0.024s	774.556s
	09	5,370	549.098s	0.028s	549.167s
	10	4,236	319.785s	0.021s	319.849s
	11	8,589	858.384s	0.038s	858.465s
	12	5,376	547.98s	0.023s	548.047s
	13	3,133	318.355s	0.018s	318.413s
	14	4,917	422.007s	0.019s	422.076s
	15	2,446	244.669s	0.02s	244.739s
	16	1,661	166.423s	0.027s	166.493s
	17	956	95.817s	0.011s	95.867s
	18	689	69.017s	0.038s	69.097s
	19	724	72.52s	0.016s	72.578s
	20	561	56.27s	0.016s	56.327s
	21	694	69.615s	0.022s	69.681s
	22	939	94.097s	0.014s	94.155s
	23	1,098	109.864s	0.022s	109.926s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Oct 09	00	0	0	0	398	0.003s	0s
	01	0	0	0	368	0.017s	0s
	02	0	0	1	372	0.001s	0s
	03	0	0	0	381	0.002s	0s
	04	0	0	0	321	0.002s	0s
	05	0	0	0	280	0.002s	0s
	06	1	2	8	1,358	0.002s	0s
	07	0	2	2	1,148	0.002s	0s
	08	0	0	3	1,219	0.002s	0s
	09	0	0	3	1,077	0.009s	0s
	10	0	0	1	718	0.002s	0s
	11	0	0	3	1,455	0.002s	0s
	12	0	0	2	1,191	0.008s	0s
	13	0	0	2	997	0.002s	0s
	14	0	0	1	1,022	0.002s	0s
	15	0	0	1	787	0.002s	0s
	16	0	0	1	654	0.008s	0s
	17	0	0	0	496	0.002s	0s
	18	0	0	0	354	0.008s	0s
	19	0	0	0	382	0.002s	0s
	20	0	0	0	330	0.002s	0s
	21	0	0	0	302	0.008s	0s
	22	0	0	1	344	0.002s	0s
	23	0	0	0	364	0.008s	0s

Day	Hour	Avg time (sec)
Oct 09	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
Oct 09	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

16.95 MiB Temp Files size Peak
2018-10-09 06:01:35 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-10-09 06:01:35 Date

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	1	8.38 MiB	8.38 MiB	8.38 MiB	8.38 MiB	& lt; hl7:porx_in070103uk31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "0ad5a89c-7bd4-4b6c-b83a-c42d110a0c12" / > & lt; hl7:creationtime VALUE = "0" / > & lt; hl7:versioncode code = "v3npfit4.0.0" / > & lt; hl7:interactionid root = "0.0.0.0.0.0.0.0.0.0.0" 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 = "0bbf070c-5edc-4764-bd83-b518dfa3e8d8" / > & lt; / hl7:messageref > & lt; / hl7:acknowledgement > & lt; hl7:communicationfunctionrcv typecode = "rcv" > & lt; hl7:device classcode = "dev" determinercode = "instance" > & lt; hl7:id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; / hl7:device > & lt; / hl7:communicationfunctionrcv > & lt; hl7:communicationfunctionsnd typecode = "snd" > & lt; hl7:device classcode = "dev" determinercode = "instance" > & lt; hl7:id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & 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 = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; / hl7:agentsystemsds > & lt; / hl7:agentsystemsds > & lt; / hl7:author1 > & lt; hl7:subject typecode = "subj" contextconductionind = "false" > & lt; prescriptionreleaseresponse xmlns:xsi = "http://www.w3.org/0/xmlschema-instance" xmlns:ppdbatch = "http://spine.nhs.uk/spine-service-ppd" xmlns:fn = "http://www.w3.org/0/0/xpath-functions" xmlns:eb = "http://www.oasis-open.org/committees/ebxml-msg/schema/msg-header-2_0.xsd" xmlns:soapcsf = "http://www.w3.org/0/0/soap-envelope" xmlns = "urn:hl7-org:v3" xmlns:nasp = "http://spine.nhs.uk/spine-servicev1.0" xmlns:soap = "http://www.w3.org/0/0/soap-envelope" classcode = "info" moodcode = "evn" TYPE = "controlact" > & lt; id root = "0ad5a89c-7bd4-4b6c-b83a-c42d110a0c12" / > & lt; effectivetime VALUE = "0" / > & lt; component TYPE = "actrelationship" typecode = "comp" contextconductionind = "false" > & lt; seperatableind VALUE = "false" / > & lt; templateid root = "0.0.0.0.0.0.0.0.0.0.0.0" EXTENSION = "porx_mt122003uk30" / > & lt; parentprescription classcode = "info" moodcode = "evn" > & lt; id xmlns:xsd = "http://www.w3.org/0/xmlschema" root = "0ee928-a11c-4b60-9628-f3b49ba7bbeb" / > & lt; code xmlns:xsd = "http://www.w3.org/0/xmlschema" code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "prescription" / > & lt; effectivetime xmlns:xsd = "http://www.w3.org/0/xmlschema" VALUE = "0" / > & lt; recordtarget xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "participation" typecode = "rct" > & lt; patient TYPE = "patient" classcode = "pat" > & lt; id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; addr > & lt; streetaddressline > 0a auckland road & lt; / streetaddressline > & lt; streetaddressline > london & lt; / streetaddressline > & lt; postalcode > se19 0dj & lt; / postalcode > & lt; / addr > & lt; telecom VALUE = "tel:0" USE = "hp" / > & lt; telecom VALUE = "tel:0" USE = "mc" / > & lt; patientperson TYPE = "person" classcode = "psn" determinercode = "instance" > & lt; name USE = "l" > & lt; prefix > mrs & lt; / prefix > & lt; family > hussein & lt; / family > & lt; given > amina & lt; / given > & lt; given > adan sharif & lt; / given > & lt; validtime OPERATOR = "i" > & lt; low VALUE = "0" inclusive = "true" / > & lt; / validtime > & lt; / name > & lt; administrativegendercode code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; birthtime VALUE = "0" / > & lt; / patientperson > & lt; sourceof typecode = "registeredwith" > & lt; gpregisteredwith classcode = "rol" > & lt; id root = "0.0.0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; / gpregisteredwith > & lt; / sourceof > & lt; / patient > & lt; / recordtarget > & lt; pertinentinformation1 typecode = "pert" contextconductionind = "true" > & lt; seperatableind VALUE = "true" / > & lt; templateid xmlns:xsd = "http://www.w3.org/0/xmlschema" root = "0.0.0.0.0.0.0.0.0.0.0.0" EXTENSION = "csab_rm-npfituk10.pertinentinformation" / > & lt; pertinentprescription classcode = "sbadm" moodcode = "rqo" > & lt; id xmlns:xsd = "http://www.w3.org/0/xmlschema" root = "0ee928-a11c-4b60-9628-f3b49ba7bbeb" / > & lt; id xmlns:xsd = "http://www.w3.org/0/xmlschema" root = "0.0.0.0.0.0.0.0.0.0.0.0" EXTENSION = "0ee928-a11c-4b60-9628-f3b49ba7bbebf" / > & lt; code xmlns:xsd = "http://www.w3.org/0/xmlschema" code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "substanceadministration" / > & lt; author xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "participation" typecode = "aut" contextcontrolcode = "op" > & lt; time VALUE = "0" / > & lt; signaturetext nullflavor = "na" / > & lt; agentperson TYPE = "roleheir" classcode = "agnt" > & lt; id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; code code = "s8000:g8000:r8000" codesystem = "0.0.0.0.0.0.0.0.0" / > & lt; telecom VALUE = "tel:0" USE = "wp" / > & lt; agentperson TYPE = "person" classcode = "psn" determinercode = "instance" > & lt; id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; name > & lt; prefix > dr & lt; / prefix > & lt; family > gray & lt; / family > & lt; given > catherine & lt; / given > & lt; / name > & lt; administrativegendercode code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; / agentperson > & lt; representedorganization TYPE = "organization" classcode = "org" determinercode = "instance" > & lt; id root = "0.0.0.0.0.0.0.0" EXTENSION = "h83037" / > & lt; code code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; name > auckland surgery & lt; / name > & lt; telecom VALUE = "tel:0" USE = "wp" / > & lt; addr > & lt; streetaddressline > auckland surgery & lt; / streetaddressline > & lt; streetaddressline > 0a auckland road & lt; / streetaddressline > & lt; streetaddressline > london & lt; / streetaddressline > & lt; postalcode > se19 0df & lt; / postalcode > & lt; / addr > & lt; / representedorganization > & lt; / agentperson > & lt; / author > & lt; responsibleparty xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "participation" typecode = "resp" contextcontrolcode = "op" > & lt; agentperson TYPE = "roleheir" classcode = "agnt" > & lt; id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; code code = "s8000:g8000:r8000" codesystem = "0.0.0.0.0.0.0.0.0" / > & lt; telecom VALUE = "tel:0" USE = "wp" / > & lt; agentperson TYPE = "person" classcode = "psn" determinercode = "instance" > & lt; id root = "0.0.0.0.0.0.0.0.0" EXTENSION = "0" / > & lt; name > & lt; prefix > dr & lt; / prefix > & lt; family > nunn & lt; / family > & lt; given > paul & lt; / given > & lt; / name > & lt; administrativegendercode code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; / agentperson > & lt; representedorganization TYPE = "organization" classcode = "org" determinercode = "instance" > & lt; id root = "0.0.0.0.0.0.0.0" EXTENSION = "h83037" / > & lt; code code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; name > auckland surgery & lt; / name > & lt; telecom VALUE = "tel:0" USE = "wp" / > & lt; addr > & lt; streetaddressline > auckland surgery & lt; / streetaddressline > & lt; streetaddressline > 0a auckland road & lt; / streetaddressline > & lt; streetaddressline > london & lt; / streetaddressline > & lt; postalcode > se19 0df & lt; / postalcode > & lt; / addr > & lt; / representedorganization > & lt; / agentperson > & lt; / responsibleparty > & lt; pertinentinformation5 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentprescriptiontreatmenttype TYPE = "observation" classcode = "obs" moodcode = "evn" > & lt; code code = "ptt" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & 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 = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" displayname = "is 0 years of age or over" / > & lt; VALUE VALUE = "0" / > & 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 = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" displayname = "is under 0 years of age" / > & lt; VALUE VALUE = "0" / > & 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 = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" code = "0" displayname = "to be dispensed" / > & lt; / pertinentprescriptionstatus > & lt; / pertinentinformation10 > & lt; pertinentinformation1 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentdispensingsitepreference TYPE = "observation" classcode = "obs" moodcode = "evn" > & lt; code code = "dsp" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & 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 = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; pertinentlineitem classcode = "sbadm" moodcode = "rqo" > & lt; id xmlns:xsd = "http://www.w3.org/0/xmlschema" root = "fdc490d3-fcbc-4094-8ff2-3b8d6c0e8bfb" / > & lt; code xmlns:xsd = "http://www.w3.org/0/xmlschema" code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "substanceadministration" / > & lt; product xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "participation" typecode = "prd" contextcontrolcode = "op" > & lt; manufacturedproduct TYPE = "roleheir" classcode = "manu" > & lt; manufacturedrequestedmaterial TYPE = "manufacturedmaterial" classcode = "mmat" determinercode = "kind" > & lt; code code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "prosource tf liquid 0ml sachets (nutrinovo 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 = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" code = "0" displayname = "to be dispensed" / > & lt; / pertinentitemstatus > & lt; / pertinentinformation5 > & lt; pertinentinformation2 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentlineitemquantity TYPE = "supply" classcode = "sply" moodcode = "rqo" > & lt; code code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "substanceadministration" / > & lt; quantity VALUE = "0" unit = "0" > & lt; translation code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0" displayname = "sachet" VALUE = "0" / > & lt; / quantity > & lt; / pertinentlineitemquantity > & lt; / pertinentinformation2 > & lt; pertinentinformation3 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentprescriberendorsement TYPE = "observation" classcode = "obs" moodcode = "evn" > & lt; code code = "pe" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE code = "acbs" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; / pertinentprescriberendorsement > & lt; / pertinentinformation3 > & lt; pertinentinformation4 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentdosageinstructions TYPE = "observation" classcode = "obs" moodcode = "evn" > & lt; code code = "di" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE > AS directed & lt; / VALUE > & lt; / pertinentdosageinstructions > & lt; / pertinentinformation4 > & lt; / pertinentlineitem > & lt; / pertinentinformation2 > & lt; pertinentinformation4 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" inversionind = "false" contextconductionind = "true" negationind = "false" > & lt; seperatableind VALUE = "true" / > & lt; pertinentprescriptiontype TYPE = "observation" classcode = "obs" moodcode = "evn" > & lt; code code = "pt" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; VALUE code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; / pertinentprescriptiontype > & lt; / pertinentinformation4 > & lt; / pertinentprescription > & lt; / pertinentinformation1 > & lt; pertinentinformation2 xmlns:xsd = "http://www.w3.org/0/xmlschema" TYPE = "actrelationship" typecode = "pert" > & lt; templateid root = "0.0.0.0.0.0.0.0.0.0.0.0" EXTENSION = "csab_rm-npfituk10.pertinentinformation1" / > & lt; pertinentcarerecordelementcategory TYPE = "actheir" classcode = "category" moodcode = "evn" > & lt; code code = "0" codesystem = "0.0.0.0.0.0.0.0.0.0.0.0" / > & lt; component TYPE = "actrelationship" typecode = "comp" > & lt; actref TYPE = "actheir" classcode = "sbadm" moodcode = "rqo" > & lt; id root = "0ee928-a11c-4b60-9628-f3b49ba7bbeb" / > & lt; / actref > & lt; / component > & lt; component TYPE = "actrelationship" typecode = "comp" > & lt; actref TYPE = "actheir" classcode = "sbadm" moodcode = "rqo" > & lt; id root = "fdc490d3-fcbc-4094-8ff2-3b8d6c0e8bfb" / > & 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 = "0b07c827-9420-4c42-9669-b39f305de060" / > & lt; / priordownloadrequestref > & lt; / infulfillmentof > & lt; / prescriptionreleaseresponse > & lt; / hl7:subject > & lt; / hl7:controlactevent > & lt; / hl7:porx_in070103uk31 > '' 0 '' 0 - 10 - 09 0:0:0.0 + 0:0 '' 0 '' 0ee928 - a11c - 4b60 - 9628 - f3b49ba7bbeb; & lt; hl7:PORX_IN070103UK31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "5AD5A89C-7BD4-4B6C-B83A-C42D110A0C12" / > & lt; hl7:creationTime VALUE = "20181009050044" / > & 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 = "1BBF070C-5EDC-4764-BD83-B518DFA3E8D8" / > & 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 = "5AD5A89C-7BD4-4B6C-B83A-C42D110A0C12" / > & lt; effectiveTime VALUE = "20181009050044" / > & 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "163501000000109" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "Prescription" / > & lt; effectiveTime xmlns:xsd = "http://www.w3.org/2001/XMLSchema" VALUE = "20181005170729" / > & lt; recordTarget xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "RCT" > & lt; Patient TYPE = "Patient" classCode = "PAT" > & lt; id root = "2.16.840.1.113883.2.1.4.1" EXTENSION = "7041062430" / > & lt; addr > & lt; streetAddressLine > 26A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DJ & lt; / postalCode > & lt; / addr > & lt; telecom VALUE = "tel:02087713913" USE = "HP" / > & lt; telecom VALUE = "tel:07506345091" USE = "MC" / > & lt; patientPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; name USE = "L" > & lt; prefix > Mrs & lt; / prefix > & lt; family > Hussein & lt; / family > & lt; given > Amina & lt; / given > & lt; given > Adan Sharif & lt; / given > & lt; validTime OPERATOR = "I" > & lt; low VALUE = "20181005" inclusive = "true" / > & lt; / validTime > & lt; / name > & lt; administrativeGenderCode code = "2" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; birthTime VALUE = "19430727" / > & lt; / patientPerson > & lt; sourceOf typeCode = "registeredWith" > & lt; GpRegisteredWith classCode = "ROL" > & lt; id root = "2.16.840.1.113883.2.1.3.2.4.11" EXTENSION = "617717774039" / > & lt; / GpRegisteredWith > & lt; / sourceOf > & lt; / Patient > & lt; / recordTarget > & lt; pertinentInformation1 typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd VALUE = "true" / > & lt; templateId xmlns:xsd = "http://www.w3.org/2001/XMLSchema" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; id xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "2.16.840.1.113883.2.1.3.2.4.18.4" EXTENSION = "226EE928-A11C-4B60-9628-F3B49BA7BBEBF" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; author xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "AUT" contextControlCode = "OP" > & lt; time VALUE = "20181005170729" / > & lt; signatureText nullFlavor = "NA" / > & lt; AgentPerson TYPE = "RoleHeir" classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "310600508561" / > & lt; code code = "S8000:G8000:R8000" codeSystem = "1.2.826.0.1285.0.2.1.104" / > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; agentPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "617717774039" / > & lt; name > & lt; prefix > Dr & lt; / prefix > & lt; family > Gray & lt; / family > & lt; given > Catherine & lt; / given > & lt; / name > & lt; administrativeGenderCode code = "2" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; / agentPerson > & lt; representedOrganization TYPE = "Organization" classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.1.10" EXTENSION = "H83037" / > & lt; code code = "001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.94" / > & lt; name > AUCKLAND SURGERY & lt; / name > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; addr > & lt; streetAddressLine > Auckland Surgery & lt; / streetAddressLine > & lt; streetAddressLine > 84A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DF & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / author > & lt; responsibleParty xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "RESP" contextControlCode = "OP" > & lt; AgentPerson TYPE = "RoleHeir" classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "502570374566" / > & lt; code code = "S8000:G8000:R8000" codeSystem = "1.2.826.0.1285.0.2.1.104" / > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; agentPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.1.54" EXTENSION = "843005" / > & lt; name > & lt; prefix > Dr & lt; / prefix > & lt; family > Nunn & lt; / family > & lt; given > Paul & lt; / given > & lt; / name > & lt; administrativeGenderCode code = "1" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; / agentPerson > & lt; representedOrganization TYPE = "Organization" classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.1.10" EXTENSION = "H83037" / > & lt; code code = "001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.94" / > & lt; name > AUCKLAND SURGERY & lt; / name > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; addr > & lt; streetAddressLine > Auckland Surgery & lt; / streetAddressLine > & lt; streetAddressLine > 84A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DF & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / responsibleParty > & lt; pertinentInformation5 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriptionTreatmentType TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "PTT" 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.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 = "20030727" / > & 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 = "19590726" / > & 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentDispensingSitePreference TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "FDC490D3-FCBC-4094-8FF2-3B8D6C0E8BFB" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; product xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct TYPE = "RoleHeir" classCode = "MANU" > & lt; manufacturedRequestedMaterial TYPE = "ManufacturedMaterial" classCode = "MMAT" determinerCode = "KIND" > & lt; code code = "24399011000001100" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ProSource TF liquid 45ml sachets (Nutrinovo 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; pertinentInformation2 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentLineItemQuantity TYPE = "Supply" classCode = "SPLY" moodCode = "RQO" > & lt; code code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; quantity VALUE = "52" unit = "1" > & lt; translation code = "733013000" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "sachet" VALUE = "52" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriberEndorsement TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentDosageInstructions TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; VALUE > AS Directed & lt; / VALUE > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation4 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriptionType TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation1" / > & lt; pertinentCareRecordElementCategory TYPE = "ActHeir" classCode = "CATEGORY" moodCode = "EVN" > & lt; code code = "110" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.56" / > & lt; component TYPE = "ActRelationship" typeCode = "COMP" > & lt; actRef TYPE = "ActHeir" classCode = "SBADM" moodCode = "RQO" > & lt; id root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; / actRef > & lt; / component > & lt; component TYPE = "ActRelationship" typeCode = "COMP" > & lt; actRef TYPE = "ActHeir" classCode = "SBADM" moodCode = "RQO" > & lt; id root = "FDC490D3-FCBC-4094-8FF2-3B8D6C0E8BFB" / > & 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 = "8B07C827-9420-4C42-9669-B39F305DE060" / > & lt; / priorDownloadRequestRef > & lt; / inFulfillmentOf > & lt; / PrescriptionReleaseResponse > & lt; / hl7:subject > & lt; / hl7:ControlActEvent > & lt; / hl7:PORX_IN070103UK31 > ', $2 = ' 0 ', $3 = ' 2018 - 10 - 09 06:01:09.068726 + 01:00 ', $4 = ' 130779 ', $5 = ' 226ee928 - a11c - 4b60 - 9628 - f3b49ba7bbeb; Date: 2018-10-09 06:01:13 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.38 MiB	& lt; hl7:PORX_IN070103UK31 xmlns:hl7 = "urn:hl7-org:v3" > & lt; hl7:id root = "5AD5A89C-7BD4-4B6C-B83A-C42D110A0C12" / > & lt; hl7:creationTime VALUE = "20181009050044" / > & 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 = "1BBF070C-5EDC-4764-BD83-B518DFA3E8D8" / > & 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 = "5AD5A89C-7BD4-4B6C-B83A-C42D110A0C12" / > & lt; effectiveTime VALUE = "20181009050044" / > & 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "163501000000109" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "Prescription" / > & lt; effectiveTime xmlns:xsd = "http://www.w3.org/2001/XMLSchema" VALUE = "20181005170729" / > & lt; recordTarget xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "RCT" > & lt; Patient TYPE = "Patient" classCode = "PAT" > & lt; id root = "2.16.840.1.113883.2.1.4.1" EXTENSION = "7041062430" / > & lt; addr > & lt; streetAddressLine > 26A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DJ & lt; / postalCode > & lt; / addr > & lt; telecom VALUE = "tel:02087713913" USE = "HP" / > & lt; telecom VALUE = "tel:07506345091" USE = "MC" / > & lt; patientPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; name USE = "L" > & lt; prefix > Mrs & lt; / prefix > & lt; family > Hussein & lt; / family > & lt; given > Amina & lt; / given > & lt; given > Adan Sharif & lt; / given > & lt; validTime OPERATOR = "I" > & lt; low VALUE = "20181005" inclusive = "true" / > & lt; / validTime > & lt; / name > & lt; administrativeGenderCode code = "2" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; birthTime VALUE = "19430727" / > & lt; / patientPerson > & lt; sourceOf typeCode = "registeredWith" > & lt; GpRegisteredWith classCode = "ROL" > & lt; id root = "2.16.840.1.113883.2.1.3.2.4.11" EXTENSION = "617717774039" / > & lt; / GpRegisteredWith > & lt; / sourceOf > & lt; / Patient > & lt; / recordTarget > & lt; pertinentInformation1 typeCode = "PERT" contextConductionInd = "true" > & lt; seperatableInd VALUE = "true" / > & lt; templateId xmlns:xsd = "http://www.w3.org/2001/XMLSchema" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; id xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "2.16.840.1.113883.2.1.3.2.4.18.4" EXTENSION = "226EE928-A11C-4B60-9628-F3B49BA7BBEBF" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; author xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "AUT" contextControlCode = "OP" > & lt; time VALUE = "20181005170729" / > & lt; signatureText nullFlavor = "NA" / > & lt; AgentPerson TYPE = "RoleHeir" classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "310600508561" / > & lt; code code = "S8000:G8000:R8000" codeSystem = "1.2.826.0.1285.0.2.1.104" / > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; agentPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.0.65" EXTENSION = "617717774039" / > & lt; name > & lt; prefix > Dr & lt; / prefix > & lt; family > Gray & lt; / family > & lt; given > Catherine & lt; / given > & lt; / name > & lt; administrativeGenderCode code = "2" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; / agentPerson > & lt; representedOrganization TYPE = "Organization" classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.1.10" EXTENSION = "H83037" / > & lt; code code = "001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.94" / > & lt; name > AUCKLAND SURGERY & lt; / name > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; addr > & lt; streetAddressLine > Auckland Surgery & lt; / streetAddressLine > & lt; streetAddressLine > 84A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DF & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / author > & lt; responsibleParty xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "RESP" contextControlCode = "OP" > & lt; AgentPerson TYPE = "RoleHeir" classCode = "AGNT" > & lt; id root = "1.2.826.0.1285.0.2.0.67" EXTENSION = "502570374566" / > & lt; code code = "S8000:G8000:R8000" codeSystem = "1.2.826.0.1285.0.2.1.104" / > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; agentPerson TYPE = "Person" classCode = "PSN" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.2.1.54" EXTENSION = "843005" / > & lt; name > & lt; prefix > Dr & lt; / prefix > & lt; family > Nunn & lt; / family > & lt; given > Paul & lt; / given > & lt; / name > & lt; administrativeGenderCode code = "1" codeSystem = "2.16.840.1.113883.2.1.3.2.4.16.25" / > & lt; / agentPerson > & lt; representedOrganization TYPE = "Organization" classCode = "ORG" determinerCode = "INSTANCE" > & lt; id root = "1.2.826.0.1285.0.1.10" EXTENSION = "H83037" / > & lt; code code = "001" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.94" / > & lt; name > AUCKLAND SURGERY & lt; / name > & lt; telecom VALUE = "tel:02086535146" USE = "WP" / > & lt; addr > & lt; streetAddressLine > Auckland Surgery & lt; / streetAddressLine > & lt; streetAddressLine > 84A Auckland Road & lt; / streetAddressLine > & lt; streetAddressLine > London & lt; / streetAddressLine > & lt; postalCode > SE19 2DF & lt; / postalCode > & lt; / addr > & lt; / representedOrganization > & lt; / AgentPerson > & lt; / responsibleParty > & lt; pertinentInformation5 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriptionTreatmentType TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "PTT" 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.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 = "20030727" / > & 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 = "19590726" / > & 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentDispensingSitePreference TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" root = "FDC490D3-FCBC-4094-8FF2-3B8D6C0E8BFB" / > & lt; code xmlns:xsd = "http://www.w3.org/2001/XMLSchema" code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; product xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "Participation" typeCode = "PRD" contextControlCode = "OP" > & lt; manufacturedProduct TYPE = "RoleHeir" classCode = "MANU" > & lt; manufacturedRequestedMaterial TYPE = "ManufacturedMaterial" classCode = "MMAT" determinerCode = "KIND" > & lt; code code = "24399011000001100" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "ProSource TF liquid 45ml sachets (Nutrinovo 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; pertinentInformation2 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentLineItemQuantity TYPE = "Supply" classCode = "SPLY" moodCode = "RQO" > & lt; code code = "225426007" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "SubstanceAdministration" / > & lt; quantity VALUE = "52" unit = "1" > & lt; translation code = "733013000" codeSystem = "2.16.840.1.113883.2.1.3.2.4.15" displayName = "sachet" VALUE = "52" / > & lt; / quantity > & lt; / pertinentLineItemQuantity > & lt; / pertinentInformation2 > & lt; pertinentInformation3 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriberEndorsement TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentDosageInstructions TYPE = "Observation" classCode = "OBS" moodCode = "EVN" > & lt; code code = "DI" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.30" / > & lt; VALUE > AS Directed & lt; / VALUE > & lt; / pertinentDosageInstructions > & lt; / pertinentInformation4 > & lt; / pertinentLineItem > & lt; / pertinentInformation2 > & lt; pertinentInformation4 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" inversionInd = "false" contextConductionInd = "true" negationInd = "false" > & lt; seperatableInd VALUE = "true" / > & lt; pertinentPrescriptionType TYPE = "Observation" 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 xmlns:xsd = "http://www.w3.org/2001/XMLSchema" TYPE = "ActRelationship" typeCode = "PERT" > & lt; templateId root = "2.16.840.1.113883.2.1.3.2.4.18.2" EXTENSION = "CSAB_RM-NPfITUK10.pertinentInformation1" / > & lt; pertinentCareRecordElementCategory TYPE = "ActHeir" classCode = "CATEGORY" moodCode = "EVN" > & lt; code code = "110" codeSystem = "2.16.840.1.113883.2.1.3.2.4.17.56" / > & lt; component TYPE = "ActRelationship" typeCode = "COMP" > & lt; actRef TYPE = "ActHeir" classCode = "SBADM" moodCode = "RQO" > & lt; id root = "226EE928-A11C-4B60-9628-F3B49BA7BBEB" / > & lt; / actRef > & lt; / component > & lt; component TYPE = "ActRelationship" typeCode = "COMP" > & lt; actRef TYPE = "ActHeir" classCode = "SBADM" moodCode = "RQO" > & lt; id root = "FDC490D3-FCBC-4094-8FF2-3B8D6C0E8BFB" / > & 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 = "8B07C827-9420-4C42-9669-B39F305DE060" / > & lt; / priorDownloadRequestRef > & lt; / inFulfillmentOf > & lt; / PrescriptionReleaseResponse > & lt; / hl7:subject > & lt; / hl7:ControlActEvent > & lt; / hl7:PORX_IN070103UK31 > ', $2 = ' 0 ', $3 = ' 2018 - 10 - 09 06:01:09.068726 + 01:00 ', $4 = ' 130779 ', $5 = ' 226ee928 - a11c - 4b60 - 9628 - f3b49ba7bbeb; [ Date: 2018-10-09 06:01:13 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Vacuums / Analyzes Distribution

Key values

15.71 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight
2018-10-09 06:03:18 Date
6.82 sec Highest CPU-cost analyze
Table public.eps_checks
Database pharmisight
2018-10-09 06:04:09 Date

Analyzes per table

Key values

public.sym_node_communication (207) Main table analyzed (database pharmisight)
512 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	207
pharmisight.public.sym_data_gap	86
pharmisight.public.sym_sequence	85
pharmisight.public.sym_outgoing_batch	51
pharmisight.public.sym_node_channel_ctl	22
pharmisight.public.sym_incoming_batch	14
pharmisight.public.sym_data	14
pharmisight.public.sym_data_event	11
pharmisight.public.sym_lock	11
pharmisight.public.sym_node_host	5
pharmisight.public.item_codes	3
pharmisight.public.users	1
pharmisight.public.eps_checks	1
pharmisight.public.tablets	1
Total	512

Vacuums per table

Key values

public.sym_node_communication (204) Main table vacuumed on database pharmisight
420 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	204	0
pharmisight.public.sym_sequence	85	0
pharmisight.public.sym_data_gap	45	45
pharmisight.public.sym_outgoing_batch	23	23
pharmisight.public.sym_node_channel_ctl	22	0
pharmisight.public.sym_lock	11	0
pharmisight.pg_catalog.pg_statistic	6	6
pharmisight.public.sym_incoming_batch	6	6
pharmisight.public.sym_node_host	6	0
pharmisight.public.sym_data	6	5
pharmisight.public.sym_data_event	3	3
pharmisight.pg_toast.pg_toast_2619	2	2
pharmisight.public.item_codes	1	1
Total	420	91

Tuples removed per table

Key values

public.sym_data_event (58315) Main table with removed tuples on database pharmisight
101284 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_data_event	3	3	58315
pharmisight.public.sym_data	6	5	12641
pharmisight.public.sym_node_communication	204	0	11454
pharmisight.public.sym_outgoing_batch	23	23	6356
pharmisight.public.sym_sequence	85	0	4692
pharmisight.public.sym_data_gap	45	45	2403
pharmisight.pg_catalog.pg_statistic	6	6	1764
pharmisight.public.sym_node_channel_ctl	22	0	1177
pharmisight.public.sym_incoming_batch	6	6	1151
pharmisight.public.sym_lock	11	0	572
pharmisight.public.sym_node_host	6	0	312
pharmisight.public.item_codes	1	1	287
pharmisight.pg_toast.pg_toast_2619	2	2	160
Total	420	91	101,284

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_data_event	3	3	58315
pharmisight.pg_catalog.pg_statistic	6	6	1764
pharmisight.public.item_codes	1	1	287
pharmisight.public.sym_incoming_batch	6	6	1151
pharmisight.public.sym_node_host	6	0	312
pharmisight.public.sym_node_communication	204	0	11454
pharmisight.public.sym_node_channel_ctl	22	0	1177
pharmisight.public.sym_outgoing_batch	23	23	6356
pharmisight.public.sym_data	6	5	12641
pharmisight.public.sym_data_gap	45	45	2403
pharmisight.public.sym_sequence	85	0	4692
pharmisight.pg_toast.pg_toast_2619	2	2	160
pharmisight.public.sym_lock	11	0	572
Total	420	91	101,284

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Oct 09	00	12	14
	01	9	9
	02	12	11
	03	10	13
	04	10	11
	05	11	11
	06	38	50
	07	33	41
	08	35	46
	09	24	36
	10	18	19
	11	35	49
	12	25	32
	13	20	26
	14	26	28
	15	17	23
	16	10	14
	17	14	12
	18	9	9
	19	11	13
	20	10	11
	21	10	11
	22	9	13
	23	12	10

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

1,415,981 Total read queries
996,657 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,415,981	42.18%
INSERT	159,081	4.74%
UPDATE	82,161	2.45%
DELETE	4,763	0.14%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	750,651	22.36%
OTHERS	944,105	28.13%

Queries by database

Key values

pharmisight Main database
3,356,743 Requests
10m45s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	3,356,743	10m45s
	DDL	1	1ms
	DELETE	4,763	6s942ms
	INSERT	159,081	35s607ms
	OTHERS	944,105	17s186ms
	SELECT	1,415,981	7m41s
	TCL	750,651	29s429ms
	UPDATE	82,161	1m35s

Queries by user

Key values

symmetricds Main user
2,698,346 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	752,942	9m2s
	DELETE	54	1s532ms
	INSERT	25,713	26s860ms
	OTHERS	2,031	64ms
	SELECT	630,618	7m2s
	TCL	60,233	6s296ms
	UPDATE	34,293	1m24s
symmetricds	Total	2,698,346	1m41s
	DDL	1	1ms
	DELETE	4,780	5s418ms
	INSERT	135,440	9s70ms
	OTHERS	978,448	17s756ms
	SELECT	815,825	35s196ms
	TCL	714,832	23s541ms
	UPDATE	49,020	10s732ms
tony	Total	897	4s584ms
	SELECT	897	4s584ms

Duration by user

Key values

9m2s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	752,942	9m2s
	DELETE	54	1s532ms
	INSERT	25,713	26s860ms
	OTHERS	2,031	64ms
	SELECT	630,618	7m2s
	TCL	60,233	6s296ms
	UPDATE	34,293	1m24s
symmetricds	Total	2,698,346	1m41s
	DDL	1	1ms
	DELETE	4,780	5s418ms
	INSERT	135,440	9s70ms
	OTHERS	978,448	17s756ms
	SELECT	815,825	35s196ms
	TCL	714,832	23s541ms
	UPDATE	49,020	10s732ms
tony	Total	897	4s584ms
	SELECT	897	4s584ms

Queries by host

Key values

10.10.10.1 Main host
3,451,288 Requests
10m44s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	3,451,288	10m44s
	DDL	1	1ms
	DELETE	4,834	6s950ms
	INSERT	161,153	35s931ms
	OTHERS	980,479	17s821ms
	SELECT	1,446,443	7m38s
	TCL	775,065	29s837ms
	UPDATE	83,313	1m35s
::1	Total	897	4s584ms
	SELECT	897	4s584ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
3,352,165 Requests
10m40s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	3,352,165	10m40s
	DDL	1	1ms
	DELETE	4,763	6s942ms
	INSERT	159,033	35s574ms
	OTHERS	942,864	17s157ms
	SELECT	1,412,824	7m36s
	TCL	750,519	29s392ms
	UPDATE	82,161	1m35s
[unknown]	Total	4,578	4s822ms
	INSERT	48	33ms
	OTHERS	1,241	28ms
	SELECT	3,157	4s722ms
	TCL	132	37ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-10-09 22:31:57 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

3,278,114 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	3,278,114	97.66%
1-5ms	61,596	1.83%
5-10ms	3,971	0.12%
10-25ms	9,477	0.28%
25-50ms	3,094	0.09%
50-100ms	180	0.01%
100-500ms	309	0.01%
500-1000ms	1	0.00%
1000-10000ms	1	0.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2018-10-09 11:43:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:06:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 13:10:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 13:10:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 13:13:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 08:34:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 10:40:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 13:45:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 09:11:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 08:59:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:40:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:40:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 08:37:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:05:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 13:45:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 08:59:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:06:08 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:06:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:40:10 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-10-09 15:40:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	2s757ms	SELECT orderlinea0_.ORDER_LINE_HISTORY_ID AS ORDER_L17_24_0_, orderlinea0_.ORDER_LINE_ACTIVITY_ID AS ORDER_LI1_23_0_, orderlinea0_.ORDER_LINE_ACTIVITY_ID AS ORDER_LI1_23_1_, orderlinea0_.status AS status2_23_1_, orderlinea0_.reason AS reason3_23_1_, orderlinea0_.scannedQty AS scannedQ4_23_1_, orderlinea0_.assignedQty AS assigned5_23_1_, orderlinea0_.backOrderQty AS backOrde6_23_1_, orderlinea0_.barcode AS barcode7_23_1_, orderlinea0_.barcodeDate AS barcodeD8_23_1_, orderlinea0_.barcodeBatch AS barcodeB9_23_1_, orderlinea0_.expiration AS expirat10_23_1_, orderlinea0_.cancelQty AS cancelQ11_23_1_, orderlinea0_.reducedQty AS reduced12_23_1_, orderlinea0_.misPickItemCode AS misPick13_23_1_, orderlinea0_.CREATED AS CREATED14_23_1_, orderlinea0_.missingLabels AS missing15_23_1_ FROM ORDER_LINE_ACTIVITIES orderlinea0_ WHERE orderlinea0_.ORDER_LINE_HISTORY_ID = '200002272' ORDER BY orderlinea0_.CREATED ASC; [ Date: 2018-10-09 11:43:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	776ms	SELECT this_.ORDER_LINE_ID AS ORDER_LI1_22_0_, this_.routeNumber AS routeNum2_22_0_, this_.sapOrderNumber AS sapOrder3_22_0_, this_.orderNumber AS orderNum4_22_0_, this_.answerOrderNumber AS answerOr5_22_0_, this_.partCode AS partCode6_22_0_, this_.partDescription AS partDesc7_22_0_, this_.patientName AS patientN8_22_0_, this_.firstName AS firstNam9_22_0_, this_.middleName AS middleN10_22_0_, this_.lastName AS lastNam11_22_0_, this_.patientDateOfBirth AS patient12_22_0_, this_.patientPostcode AS patient13_22_0_, this_.patientPostcodePrefix AS patient14_22_0_, this_.orderQty AS orderQt15_22_0_, this_.allocQty AS allocQt16_22_0_, this_.shipQty AS shipQty17_22_0_, this_.adjustedQty AS adjuste18_22_0_, this_.scannedQty AS scanned19_22_0_, this_.assignedQty AS assigne20_22_0_, this_.checkedQty AS checked21_22_0_, this_.backOrderQty AS backOrd22_22_0_, this_.cancelQty AS cancelQ23_22_0_, this_.reducedQty AS reduced24_22_0_, this_.status AS status25_22_0_, this_.reason AS reason26_22_0_, this_.deliveryDate AS deliver27_22_0_, this_.customer AS custome28_22_0_, this_.sapCustomerId AS sapCust29_22_0_, this_.billToType AS billToT30_22_0_, this_.barcodeDate AS barcode31_22_0_, this_.barcodeBatch AS barcode32_22_0_, this_.patientId AS patient33_22_0_, this_.isAdded AS isAdded34_22_0_, this_.isNotWithinAge AS isNotWi35_22_0_, this_.isUnderAge AS isUnder36_22_0_, this_.ageCheck AS ageChec37_22_0_, this_.expired AS expired38_22_0_, this_.paperwork AS paperwo39_22_0_, this_.isPaperworkProblem AS isPaper40_22_0_, this_.paperworkResolution AS paperwo41_22_0_, this_.pickerId AS pickerI42_22_0_, this_.specialCare AS special43_22_0_, this_.paperworkEnquiryStarted AS paperwo44_22_0_, this_.paperworkEnquiryFinished AS paperwo45_22_0_, this_.paperworkEnquiryResponse AS paperwo46_22_0_, this_.isNewProduct AS isNewPr47_22_0_, this_.extraProcedure AS extraPr48_22_0_, this_.overAverageQtyMax AS overAve49_22_0_, this_.overAverageQtyResolution AS overAve50_22_0_, this_.createUser AS createU51_22_0_, this_.patientAlert AS patient52_22_0_, this_.itemAlert AS itemAle53_22_0_, this_.checkerId AS checker54_22_0_, this_.reductionSummary AS reducti55_22_0_, this_.isMetabolic AS isMetab56_22_0_, this_.rxStatus AS rxStatu57_22_0_, this_.lastRegUpdateUserType AS lastReg58_22_0_, this_.lastRegUpdateUserName AS lastReg59_22_0_, this_.lastRegUpdateDate AS lastReg60_22_0_, this_.sapPlannedShipDate AS sapPlan61_22_0_, this_.sapPlannedDeliveryDate AS sapPlan62_22_0_, this_.requestedSAPQuantity AS request63_22_0_, this_.orderQuantity AS orderQu64_22_0_, this_.regLineCreatedUserType AS regLine65_22_0_, this_.regLineCreatedUserName AS regLine66_22_0_, this_.regLineCreatedDate AS regLine67_22_0_, this_.audited AS audited68_22_0_, this_.isMetabolicPatient AS isMetab69_22_0_, this_.addedCase AS addedCa70_22_0_, this_.orderType AS orderTy71_22_0_, this_.CREATED AS CREATED72_22_0_, this_.UPDATED AS UPDATED73_22_0_, this_.rxCheckBy AS rxCheck74_22_0_, this_.note AS note75_22_0_, this_.item AS item76_22_0_, this_.alertConfirmation AS alertCo77_22_0_, this_.homewardAction AS homewar78_22_0_ FROM ORDER_LINES this_ WHERE this_.deliveryDate BETWEEN '2018-10-01' AND '2018-10-31'; [ Date: 2018-10-09 15:06:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	301ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '211201522'; [ Date: 2018-10-09 13:10:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	297ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '211194672'; [ Date: 2018-10-09 13:10:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	290ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '211191762'; [ Date: 2018-10-09 13:13:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	286ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4058' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 08:34:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	284ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4062' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 10:40:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	283ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4058' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 13:45:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	277ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4058' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 09:11:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	274ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '211191092'; [ Date: 2018-10-09 08:59:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	258ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-04 00:00:00' AND '2018-10-04 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:40:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	258ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-05 00:00:00' AND '2018-10-05 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:40:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	257ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '200001322' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 08:37:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	255ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-10 00:00:00' AND '2018-10-10 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:05:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	252ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4058' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 13:45:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	244ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '211200572'; [ Date: 2018-10-09 08:59:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	241ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-09 00:00:00' AND '2018-10-09 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:06:08 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	240ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-10 00:00:00' AND '2018-10-10 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:06:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	239ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-06 00:00:00' AND '2018-10-06 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:40:10 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	238ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-11 00:00:00' AND '2018-10-11 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2018-10-09 15:40:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1m36s - Times executed: 2515 ]
[ User: pharmisight - Total duration: 38s488ms - Times executed: 52815 ]
[ User: pharmisight - Total duration: 31s588ms - Times executed: 2517 ]
[ User: pharmisight - Total duration: 29s283ms - Times executed: 10063 ]
[ User: symmetricds - Total duration: 20s890ms - Times executed: 345217 ]
[ User: pharmisight - Total duration: 22s467ms - Times executed: 5420 ]
[ User: pharmisight - Total duration: 21s669ms - Times executed: 604 ]
[ User: pharmisight - Total duration: 17s489ms - Times executed: 60040 ]
[ User: symmetricds - Total duration: 17s88ms - Times executed: 940992 ]
[ User: pharmisight - Total duration: 16s458ms - Times executed: 158 ]
[ User: pharmisight - Total duration: 15s297ms - Times executed: 1348 ]
[ User: pharmisight - Total duration: 12s156ms - Times executed: 532 ]
[ User: pharmisight - Total duration: 10s658ms - Times executed: 560 ]
[ User: pharmisight - Total duration: 9s421ms - Times executed: 11750 ]
[ User: pharmisight - Total duration: 8s758ms - Times executed: 7220 ]
[ User: pharmisight - Total duration: 8s636ms - Times executed: 2651 ]
[ User: pharmisight - Total duration: 8s330ms - Times executed: 72425 ]
[ User: pharmisight - Total duration: 7s827ms - Times executed: 874 ]
[ User: pharmisight - Total duration: 7s666ms - Times executed: 1726 ]
[ User: pharmisight - Total duration: 7s186ms - Times executed: 2515 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 17s88ms - Times executed: 940992 ]
[ User: symmetricds - Total duration: 5s725ms - Times executed: 444380 ]
[ User: symmetricds - Total duration: 2s250ms - Times executed: 345219 ]
[ User: symmetricds - Total duration: 20s890ms - Times executed: 345217 ]
[ User: symmetricds - Total duration: 6s500ms - Times executed: 119838 ]
[ User: symmetricds - Total duration: 3s502ms - Times executed: 77139 ]
[ User: pharmisight - Total duration: 8s330ms - Times executed: 72425 ]
[ User: symmetricds - Total duration: 2s52ms - Times executed: 68379 ]
[ User: pharmisight - Total duration: 3s30ms - Times executed: 63767 ]
[ User: pharmisight - Total duration: 17s489ms - Times executed: 60040 ]
[ User: symmetricds - Total duration: 1s220ms - Times executed: 57248 ]
[ User: pharmisight - Total duration: 38s488ms - Times executed: 52815 ]
[ User: pharmisight - Total duration: 2s391ms - Times executed: 39801 ]
[ User: pharmisight - Total duration: 2s38ms - Times executed: 36835 ]
[ User: pharmisight - Total duration: 1s514ms - Times executed: 30226 ]
[ User: pharmisight - Total duration: 1s340ms - Times executed: 28687 ]
[ User: pharmisight - Total duration: 1s59ms - Times executed: 23575 ]
[ User: symmetricds - Total duration: 4s580ms - Times executed: 22294 ]
[ User: pharmisight - Total duration: 516ms - Times executed: 20356 ]
[ User: symmetricds - Total duration: 803ms - Times executed: 16146 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 16s458ms - Times executed: 158 ]
[ User: pharmisight - Total duration: 1m36s - Times executed: 2515 ]
[ User: pharmisight - Total duration: 21s669ms - Times executed: 604 ]
[ User: pharmisight - Total duration: 12s156ms - Times executed: 532 ]
[ User: pharmisight - Total duration: 10s658ms - Times executed: 560 ]
[ User: pharmisight - Total duration: 31s588ms - Times executed: 2517 ]
[ User: pharmisight - Total duration: 15s297ms - Times executed: 1348 ]
[ User: pharmisight - Total duration: 7s827ms - Times executed: 874 ]
[ User: pharmisight - Total duration: 7s666ms - Times executed: 1726 ]
[ User: pharmisight - Total duration: 22s467ms - Times executed: 5420 ]
[ User: pharmisight - Total duration: 8s636ms - Times executed: 2651 ]
[ User: pharmisight - Total duration: 29s283ms - Times executed: 10063 ]
[ User: pharmisight - Total duration: 7s186ms - Times executed: 2515 ]
[ User: pharmisight - Total duration: 8s758ms - Times executed: 7220 ]
[ User: pharmisight - Total duration: 9s421ms - Times executed: 11750 ]
[ User: pharmisight - Total duration: 38s488ms - Times executed: 52815 ]
[ User: pharmisight - Total duration: 17s489ms - Times executed: 60040 ]
[ User: symmetricds - Total duration: 4s580ms - Times executed: 22294 ]
[ User: pharmisight - Total duration: 8s330ms - Times executed: 72425 ]
[ User: symmetricds - Total duration: 20s890ms - Times executed: 345217 ]

Log levels

Key values

10,545,750 Log entries

Chart
Table

Type	Count	Percentage
DETAIL	2,302,584	21.83%
ERROR	3	0.00%
LOG	8,243,160	78.17%
STATEMENT	3	0.00%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

1 Max number of times the same event was reported
3 Total events found

Rank

Times reported

Error

1

Details

ERROR: value too long for type character varying(...)

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Oct 09	13	1

ERROR: value too long for type character varying(255)

2

1

Details

ERROR: current transaction is aborted, commands ignored until end of transaction block

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Oct 09	13	1

ERROR: current transaction is aborted, commands ignored until end of transaction block

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Oct 09	00	1

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

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

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

Type of locks

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