pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Jan 29 00:00:28 2019
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 7,737,100 log entries in 26s
Log start from 2019-01-28 00:00:00 to 2019-01-28 23:59:59

Global Stats

1,874 Number of unique normalized queries
2,384,491 Number of queries
9m29s Total query duration
2019-01-28 00:00:00 First query
2019-01-28 23:59:59 Last query
10,536 queries/s at 2019-01-28 06:07:43 Query peak

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

127 Total number of automatic vacuums
256 Total number of automatic analyzes

7 Number temporary file
19.70 MiB Max size of temporary file
9.78 MiB Average size of temporary file

1,854 Total number of sessions
3 sessions at 2019-01-28 11:18:38 Session peak
10d9h20m18s Total duration of sessions
8m4s Average duration of sessions
1,286 Average queries per session
306ms Average queries duration per session

1,854 Total number of connections
9 connections/s at 2019-01-28 13:58:29 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,536 queries/s Query Peak
2019-01-28 06:07:43 Date

SELECT Traffic

Key values

1,885 queries/s Query Peak
2019-01-28 06:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,482 queries/s Query Peak
2019-01-28 06:07:43 Date

Queries duration

Key values

9m29s Total query duration

Prepared queries ratio

Key values

2.39 Ratio of bind vs prepare
135.26 % 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)
Jan 28	00	51,457	0ms	14ms	0ms	56ms	63ms	758ms
	01	49,179	0ms	15ms	0ms	44ms	61ms	129ms
	02	49,365	0ms	13ms	0ms	52ms	63ms	138ms
	03	49,186	0ms	13ms	0ms	52ms	58ms	131ms
	04	49,320	0ms	13ms	0ms	47ms	57ms	138ms
	05	49,578	0ms	13ms	0ms	52ms	68ms	119ms
	06	273,145	0ms	3s32ms	0ms	10s416ms	14s202ms	20s304ms
	07	159,769	0ms	87ms	0ms	1s23ms	1s171ms	1s277ms
	08	186,935	0ms	81ms	0ms	1s565ms	1s588ms	7s755ms
	09	122,623	0ms	161ms	0ms	1s27ms	1s426ms	1s903ms
	10	151,113	0ms	191ms	0ms	1s244ms	1s726ms	2s55ms
	11	184,944	0ms	2s96ms	0ms	2s897ms	3s301ms	4s214ms
	12	148,992	0ms	388ms	0ms	1s793ms	1s915ms	2s318ms
	13	156,917	0ms	177ms	0ms	1s829ms	2s121ms	4s788ms
	14	88,613	0ms	194ms	0ms	817ms	1s700ms	2s542ms
	15	117,056	0ms	2s14ms	0ms	718ms	1s54ms	3s144ms
	16	107,057	0ms	458ms	0ms	2s880ms	4s941ms	7s691ms
	17	74,357	0ms	447ms	0ms	1s115ms	3s249ms	6s582ms
	18	55,166	0ms	59ms	0ms	64ms	88ms	318ms
	19	50,225	0ms	59ms	0ms	53ms	93ms	273ms
	20	53,114	0ms	55ms	0ms	58ms	172ms	608ms
	21	51,118	0ms	71ms	0ms	57ms	195ms	285ms
	22	52,595	0ms	54ms	0ms	58ms	245ms	335ms
	23	52,667	0ms	55ms	0ms	69ms	179ms	386ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 28	00	17,683	0ms	26ms	37ms	515ms
	01	15,967	0ms	24ms	33ms	41ms
	02	16,040	0ms	24ms	35ms	47ms
	03	15,976	0ms	24ms	35ms	43ms
	04	16,016	0ms	24ms	35ms	50ms
	05	16,114	0ms	24ms	35ms	54ms
	06	109,151	0ms	1s563ms	4s802ms	11s555ms
	07	72,983	0ms	613ms	766ms	939ms
	08	90,611	0ms	1s151ms	1s268ms	1s498ms
	09	55,640	0ms	489ms	884ms	1s390ms
	10	72,943	0ms	630ms	1s74ms	1s791ms
	11	97,096	0ms	1s137ms	2s375ms	3s295ms
	12	75,681	0ms	1s136ms	1s431ms	1s776ms
	13	84,637	0ms	889ms	1s668ms	2s119ms
	14	36,491	0ms	354ms	774ms	1s782ms
	15	50,467	0ms	513ms	677ms	947ms
	16	65,073	0ms	1s668ms	2s826ms	6s356ms
	17	35,702	0ms	85ms	1s56ms	5s291ms
	18	18,054	0ms	27ms	38ms	105ms
	19	16,274	0ms	26ms	36ms	77ms
	20	18,932	0ms	30ms	37ms	169ms
	21	16,413	0ms	27ms	35ms	76ms
	22	16,694	0ms	29ms	36ms	99ms
	23	16,700	0ms	24ms	33ms	109ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 28	00	96	70	80	0ms	1ms	6ms	7ms
	01	88	54	81	0ms	1ms	6ms	7ms
	02	88	53	89	0ms	1ms	6ms	7ms
	03	88	54	73	0ms	1ms	5ms	7ms
	04	88	53	81	0ms	1ms	6ms	7ms
	05	93	63	95	0ms	1ms	6ms	7ms
	06	65,658	21,045	458	0ms	326ms	1s181ms	6s452ms
	07	14,296	5,836	372	0ms	93ms	118ms	162ms
	08	15,796	6,429	405	0ms	98ms	119ms	173ms
	09	9,074	3,740	289	0ms	60ms	86ms	140ms
	10	13,604	5,079	343	0ms	86ms	107ms	135ms
	11	16,540	6,562	357	0ms	90ms	124ms	265ms
	12	11,306	5,050	301	0ms	77ms	110ms	211ms
	13	11,946	4,429	300	0ms	75ms	99ms	164ms
	14	5,138	2,086	219	0ms	44ms	59ms	133ms
	15	8,408	3,525	300	0ms	60ms	74ms	98ms
	16	873	626	163	1ms	13ms	45ms	118ms
	17	618	405	135	0ms	7ms	20ms	107ms
	18	335	1,139	115	0ms	7ms	10ms	15ms
	19	123	93	109	0ms	1ms	5ms	9ms
	20	239	142	136	0ms	1ms	6ms	22ms
	21	667	227	101	0ms	1ms	6ms	28ms
	22	1,650	467	109	0ms	1ms	7ms	102ms
	23	1,599	456	110	0ms	1ms	7ms	72ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 28	00	33,289	51,421	1.54	108.59%
	01	32,528	49,143	1.51	113.58%
	02	32,663	49,329	1.51	113.60%
	03	32,602	49,150	1.51	113.78%
	04	32,656	49,284	1.51	113.70%
	05	32,815	49,542	1.51	113.57%
	06	67,158	273,109	4.07	28.81%
	07	57,806	158,265	2.74	46.41%
	08	61,033	186,899	3.06	40.78%
	09	48,708	122,587	2.52	52.82%
	10	52,538	151,077	2.88	44.29%
	11	55,713	184,908	3.32	37.00%
	12	52,211	148,939	2.85	44.38%
	13	50,765	156,858	3.09	40.20%
	14	42,178	88,562	2.10	67.50%
	15	50,683	117,020	2.31	58.77%
	16	38,183	107,021	2.80	45.45%
	17	35,622	74,301	2.09	68.29%
	18	32,660	55,130	1.69	96.01%
	19	31,168	50,189	1.61	106.12%
	20	31,426	53,078	1.69	97.43%
	21	31,309	51,082	1.63	103.57%
	22	31,305	52,559	1.68	98.70%
	23	31,571	52,631	1.67	99.55%

Day	Hour	Count	Average / Second
Jan 28	00	110	0.03/s
	01	118	0.03/s
	02	116	0.03/s
	03	117	0.03/s
	04	119	0.03/s
	05	117	0.03/s
	06	80	0.02/s
	07	62	0.02/s
	08	56	0.02/s
	09	55	0.02/s
	10	58	0.02/s
	11	52	0.01/s
	12	60	0.02/s
	13	70	0.02/s
	14	60	0.02/s
	15	61	0.02/s
	16	67	0.02/s
	17	80	0.02/s
	18	65	0.02/s
	19	67	0.02/s
	20	67	0.02/s
	21	67	0.02/s
	22	64	0.02/s
	23	66	0.02/s

Day	Hour	Count	Average Duration
Jan 28	00	110	5m30s
	01	118	5m7s
	02	116	5m7s
	03	117	5m8s
	04	119	5m5s
	05	117	5m4s
	06	80	6m38s
	07	62	10m21s
	08	55	11m6s
	09	55	11m3s
	10	59	10m52s
	11	52	11m
	12	58	11m48s
	13	63	11m43s
	14	69	9m40s
	15	61	10m22s
	16	67	9m28s
	17	79	9m48s
	18	66	9m24s
	19	67	8m48s
	20	67	8m54s
	21	67	9m1s
	22	64	9m23s
	23	66	9m6s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2019-01-28 13:58:29 Date

Connections per database

Key values

pharmisight Main Database
1,854 connections Total

Chart
Table

Database	User	Count
pharmisight		1,854
	pharmisight	707
	symmetricds	859
	tony	288

Connections per user

Key values

symmetricds Main User
1,854 connections Total

Chart
Table

User	Count
pharmisight	707
symmetricds	859
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1566 connections
1,854 Total connections

Chart
Table

Host	Count
10.10.10.1	1,566
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2019-01-28 11:18:38 Date

Histogram of session times

Key values

1,112 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	15.53%
500ms-1s	0	0.00%
1s-30s	5	0.27%
30s-1m	2	0.11%
1m-10m	1,112	59.98%
10m-30m	400	21.57%
30m-1h	45	2.43%
1h-8h	2	0.11%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,854 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,854	10d9h20m18s	8m4s

Sessions per user

Key values

symmetricds Main User
1,854 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	707	5d8h31m4s
symmetricds	859	5d49m1s
tony	288	11s784ms

Sessions per host

Key values

10.10.10.1 Main Host
1,854 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,566	10d9h20m6s	9m33s
::1	288	11s784ms	40ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,854 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,561	10d9h19m20s	9m34s
[unknown]	293	57s62ms	194ms

Checkpoints Buffers

Key values

2,619 buffers Checkpoint Peak
2019-01-28 06:08:53 Date
149.500 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2019-01-28 06:13:53 Date

Checkpoints distance

Key values

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 28	00	622	62.392s	0.018s	62.458s
	01	461	46.261s	0.014s	46.327s
	02	381	38.236s	0.025s	38.305s
	03	568	56.888s	0.011s	56.951s
	04	356	35.727s	0.009s	35.776s
	05	557	55.9s	0.01s	55.953s
	06	12,688	1,154.132s	0.075s	1,154.279s
	07	6,813	689.784s	0.028s	689.882s
	08	7,130	715.748s	0.051s	715.866s
	09	4,253	425.755s	0.029s	425.846s
	10	5,368	537.037s	0.032s	537.139s
	11	7,178	718.102s	0.033s	718.205s
	12	5,986	599.787s	0.026s	599.91s
	13	4,916	492.575s	0.03s	492.685s
	14	2,460	246.269s	0.019s	246.349s
	15	4,227	422.751s	0.028s	422.866s
	16	1,375	138.158s	0.023s	138.251s
	17	1,074	107.77s	0.012s	107.834s
	18	1,312	131.639s	0.014s	131.711s
	19	455	45.65s	0.013s	45.715s
	20	402	40.337s	0.017s	40.403s
	21	523	52.489s	0.009s	52.544s
	22	740	74.263s	0.012s	74.324s
	23	734	73.666s	0.012s	73.732s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 28	00	0	0	235	0.008s	0s
	01	0	0	223	0.002s	0s
	02	0	0	208	0.018s	0s
	03	0	0	235	0.001s	0s
	04	0	0	210	0.002s	0s
	05	0	0	235	0.001s	0s
	06	2	10	1,376	0.009s	0s
	07	0	3	1,138	0.002s	0s
	08	0	3	1,190	0.012s	0s
	09	0	2	993	0.002s	0s
	10	0	2	1,024	0.001s	0s
	11	0	3	1,315	0.002s	0s
	12	0	2	1,240	0.002s	0s
	13	0	2	974	0.002s	0s
	14	0	1	732	0.002s	0s
	15	0	1	1,044	0.002s	0s
	16	0	1	681	0.008s	0s
	17	0	0	483	0.003s	0s
	18	0	1	290	0.002s	0s
	19	0	0	223	0.004s	0s
	20	0	0	218	0.003s	0s
	21	0	0	228	0.001s	0s
	22	0	0	239	0.002s	0s
	23	0	0	254	0.002s	0s

Day	Hour	Avg time (sec)
Jan 28	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
Jan 28	00	225.11 kB	462.44 kB
	01	168.00 kB	419.00 kB
	02	146.38 kB	247.38 kB
	03	192.90 kB	412.40 kB
	04	135.38 kB	254.25 kB
	05	204.89 kB	316.33 kB
	06	15,919.33 kB	47,435.92 kB
	07	3,972.08 kB	19,633.83 kB
	08	4,108.17 kB	8,378.67 kB
	09	2,298.17 kB	4,527.00 kB
	10	2,928.08 kB	3,590.25 kB
	11	3,807.50 kB	4,207.83 kB
	12	2,786.91 kB	4,581.91 kB
	13	2,725.58 kB	4,092.42 kB
	14	1,231.83 kB	2,735.00 kB
	15	2,193.33 kB	2,485.17 kB
	16	566.17 kB	1,737.00 kB
	17	567.20 kB	1,478.50 kB
	18	742.80 kB	1,030.20 kB
	19	218.22 kB	666.89 kB
	20	180.78 kB	482.11 kB
	21	267.78 kB	523.67 kB
	22	460.00 kB	893.00 kB
	23	381.60 kB	895.40 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

19.36 MiB Temp Files size Peak
2019-01-28 17:11:12 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2019-01-28 17:11:09 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 28	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	3	29.73 MiB	9.91 MiB
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	4	38.71 MiB	9.68 MiB
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	2	18.45 MiB	9.23 MiB	9.23 MiB	9.23 MiB	SELECT this_.order_round_id AS order_ro1_28_0_, this_.routenumber AS routenum2_28_0_, this_.uploadedbyuserid AS uploaded3_28_0_, this_.uploadedbyusername AS uploaded4_28_0_, this_.updatedby AS updatedb5_28_0_, this_.updatedbyusername AS updatedb6_28_0_, this_.orderroundnote AS orderrou7_28_0_, this_.firstcheckout AS firstche8_28_0_, this_.allordersscannedok AS allorder9_28_0_, this_.status AS status10_28_0_, this_.reopenedtimes AS reopene11_28_0_, this_.lastreopenbyid AS lastreo12_28_0_, this_.lastdonecheckin AS lastdon13_28_0_, this_.lastdonebyid AS lastdon14_28_0_, this_.lastdonebyusername AS lastdon15_28_0_, this_.missinglabels AS missing16_28_0_, this_.rounddeliverydate AS roundde17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadupdated AS uploadu21_28_0_, this_.patientalert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxstatus AS rxstatu24_28_0_, this_.distributionpoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedby AS audited27_28_0_, this_.auditstatus AS auditst28_28_0_, this_.uploadfinished AS uploadf29_28_0_, this_.lastrxcompleted AS lastrxc30_28_0_, this_.lastrxcompletedby AS lastrxc31_28_0_, this_.orderroundnotereadby AS orderro32_28_0_, this_.routeorderlinesqty AS routeor33_28_0_, this_.dlxpickedlinesqty AS dlxpick34_28_0_, this_.flowreport AS flowrep35_28_0_, this_.created AS created36_28_0_, this_.createdby AS created37_28_0_, this_.updated AS updated38_28_0_, this_.note AS note39_28_0_ FROM order_rounds this_ ORDER BY this_.rounddeliverydate DESC, this_.routenumber ASC LIMIT ? offset ?; SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT $1 offset $2; Date: 2019-01-28 17:11:09 Duration: 447ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT $1 offset $2; Date: 2019-01-28 17:11:12 Duration: 281ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT $1 offset $2; Date: 2019-01-28 17:11:08 Duration: 253ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2	2	20.26 MiB	10.12 MiB	10.13 MiB	10.13 MiB	COMMIT; COMMIT; Date: 2019-01-28 06:10:04 Duration: 252ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes COMMIT; Date: 2019-01-28 13:32:04 Duration: 144ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes COMMIT; Date: 2019-01-28 21:45:06 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries generating the largest temporary files

Rank	Size	Query
1	10.13 MiB	COMMIT; [ Date: 2019-01-28 17:11:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	10.12 MiB	COMMIT; [ Date: 2019-01-28 17:11:09 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	9.23 MiB	SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT $1 offset $2; [ Date: 2019-01-28 17:11:09 ]
4	9.23 MiB	SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT $1 offset $2; [ Date: 2019-01-28 17:11:12 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

public.sym_data_gap (98) Main table analyzed (database pharmisight)
256 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	98
pharmisight.public.sym_outgoing_batch	84
pharmisight.public.sym_incoming_batch	19
pharmisight.public.sym_data_event	18
pharmisight.public.sym_data	17
pharmisight.public.sym_sequence	11
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	2
pharmisight.public.order_lines	1
Total	256

Vacuums per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	52	52
pharmisight.public.sym_outgoing_batch	42	41
pharmisight.public.sym_sequence	11	0
pharmisight.public.sym_incoming_batch	8	8
pharmisight.public.sym_node_host	6	0
pharmisight.pg_toast.pg_toast_2619	4	4
pharmisight.pg_catalog.pg_statistic	2	2
pharmisight.public.sym_data	1	1
pharmisight.public.sym_data_event	1	1
Total	127	109

Tuples removed per table

Key values

public.sym_data_gap (2687) Main table with removed tuples on database pharmisight
7429 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_gap	52	52	2687	0
pharmisight.public.sym_outgoing_batch	42	41	1530	0
pharmisight.public.sym_incoming_batch	8	8	1148	0
pharmisight.public.sym_sequence	11	0	562	0
pharmisight.pg_catalog.pg_statistic	2	2	562	0
pharmisight.public.sym_node_host	6	0	312	0
pharmisight.pg_toast.pg_toast_2619	4	4	268	7
pharmisight.public.sym_data_event	1	1	252	0
pharmisight.public.sym_data	1	1	108	0
Total	127	109	7,429	7

Pages removed per table

Key values

pg_toast.pg_toast_2619 (7) Main table with removed pages on database pharmisight
7 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.pg_toast.pg_toast_2619	4	4	268	7
pharmisight.public.sym_sequence	11	0	562	0
pharmisight.public.sym_node_host	6	0	312	0
pharmisight.public.sym_data	1	1	108	0
pharmisight.pg_catalog.pg_statistic	2	2	562	0
pharmisight.public.sym_data_gap	52	52	2687	0
pharmisight.public.sym_incoming_batch	8	8	1148	0
pharmisight.public.sym_outgoing_batch	42	41	1530	0
pharmisight.public.sym_data_event	1	1	252	0
Total	127	109	7,429	7

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 28	00	5	4
	01	1	2
	02	0	1
	03	3	5
	04	1	0
	05	2	6
	06	21	47
	07	15	29
	08	14	30
	09	8	16
	10	10	21
	11	10	22
	12	8	17
	13	8	15
	14	3	8
	15	7	14
	16	2	3
	17	3	3
	18	2	5
	19	1	1
	20	0	1
	21	0	1
	22	1	3
	23	2	2

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
8 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ShareLock		8	14s942ms	1s867ms
	transaction	8	14s942ms	1s867ms
	Total	8	14s942ms	1s867ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	6	10s1ms	1s153ms	2s95ms	1s666ms	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, manuallychangedpicktime = ?, created = ?, updated = ?, note = ? WHERE flow_report_id = ?; UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2019-01-28 11:45:42 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2019-01-28 15:37:34 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2019-01-28 06:18:57 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2	1	3s30ms	3s30ms	3s30ms	3s30ms	UPDATE order_rounds SET routenumber = ?, uploadedbyuserid = ?, uploadedbyusername = ?, updatedby = ?, updatedbyusername = ?, orderroundnote = ?, firstcheckout = ?, allordersscannedok = ?, status = ?, reopenedtimes = ?, lastreopenbyid = ?, lastdonecheckin = ?, lastdonebyid = ?, lastdonebyusername = ?, missinglabels = ?, rounddeliverydate = ?, trolley = ?, stack = ?, picktime = ?, uploadupdated = ?, patientalert = ?, mismatches = ?, rxstatus = ?, distributionpoint = ?, audited = ?, auditedby = ?, auditstatus = ?, uploadfinished = ?, lastrxcompleted = ?, lastrxcompletedby = ?, orderroundnotereadby = ?, routeorderlinesqty = ?, dlxpickedlinesqty = ?, flowreport = ?, created = ?, createdby = ?, updated = ?, note = ? WHERE order_round_id = ?; UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; Date: 2019-01-28 06:11:27 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; Date: 2019-01-28 16:23:17 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; Date: 2019-01-28 16:27:31 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3	1	1s910ms	1s910ms	1s910ms	1s910ms	UPDATE orders SET sapordernumber = ?, answerordernumber = ?, ordernumber = ?, routenumber = ?, billtotype = ?, patientname = ?, firstname = ?, middlename = ?, lastname = ?, patientdateofbirth = ?, patientpostcode = ?, customer = ?, sapcustomerid = ?, status = ?, patientid = ?, isnotwithinage = ?, expired = ?, paperwork = ?, deliverybarcode = ?, deliverydate = ?, rxstatus = ?, createuser = ?, subordertype = ?, sapcontractid = ?, salesforceordernumber = ?, patienttype = ?, ordertype = ?, orderstatus = ?, nhsnumber = ?, individuallabelling = ?, orderid = ?, clusterlead = ?, clustergroup = ?, accountid = ?, reduction = ?, reductionby = ?, alertconfirmation = ?, created = ?, updated = ?, note = ? WHERE order_id = ?; UPDATE ORDERS SET sapOrderNumber = $1, answerOrderNumber = $2, orderNumber = $3, routeNumber = $4, billToType = $5, patientName = $6, firstName = $7, middleName = $8, lastName = $9, patientDateOfBirth = $10, patientPostcode = $11, customer = $12, sapCustomerId = $13, status = $14, patientId = $15, isNotWithinAge = $16, expired = $17, paperwork = $18, deliveryBarcode = $19, deliveryDate = $20, rxStatus = $21, createUser = $22, subOrderType = $23, sapContractId = $24, salesforceOrderNumber = $25, patientType = $26, orderType = $27, orderStatus = $28, NHSnumber = $29, individualLabelling = $30, orderId = $31, clusterLead = $32, clusterGroup = $33, accountId = $34, reduction = $35, reductionBy = $36, alertConfirmation = $37, CREATED = $38, UPDATED = $39, note = $40 WHERE ORDER_ID = $41; Date: 2019-01-28 06:11:27 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE ORDERS SET sapOrderNumber = $1, answerOrderNumber = $2, orderNumber = $3, routeNumber = $4, billToType = $5, patientName = $6, firstName = $7, middleName = $8, lastName = $9, patientDateOfBirth = $10, patientPostcode = $11, customer = $12, sapCustomerId = $13, status = $14, patientId = $15, isNotWithinAge = $16, expired = $17, paperwork = $18, deliveryBarcode = $19, deliveryDate = $20, rxStatus = $21, createUser = $22, subOrderType = $23, sapContractId = $24, salesforceOrderNumber = $25, patientType = $26, orderType = $27, orderStatus = $28, NHSnumber = $29, individualLabelling = $30, orderId = $31, clusterLead = $32, clusterGroup = $33, accountId = $34, reduction = $35, reductionBy = $36, alertConfirmation = $37, CREATED = $38, UPDATED = $39, note = $40 WHERE ORDER_ID = $41; Date: 2019-01-28 17:10:37 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes UPDATE ORDERS SET sapOrderNumber = $1, answerOrderNumber = $2, orderNumber = $3, routeNumber = $4, billToType = $5, patientName = $6, firstName = $7, middleName = $8, lastName = $9, patientDateOfBirth = $10, patientPostcode = $11, customer = $12, sapCustomerId = $13, status = $14, patientId = $15, isNotWithinAge = $16, expired = $17, paperwork = $18, deliveryBarcode = $19, deliveryDate = $20, rxStatus = $21, createUser = $22, subOrderType = $23, sapContractId = $24, salesforceOrderNumber = $25, patientType = $26, orderType = $27, orderStatus = $28, NHSnumber = $29, individualLabelling = $30, orderId = $31, clusterLead = $32, clusterGroup = $33, accountId = $34, reduction = $35, reductionBy = $36, alertConfirmation = $37, CREATED = $38, UPDATED = $39, note = $40 WHERE ORDER_ID = $41; Date: 2019-01-28 10:36:35 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most


[ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 11:45:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 15:37:34 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 06:18:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 06:18:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 06:18:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-28 06:18:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	3s30ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	2s95ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 11:45:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	2s13ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 15:37:34 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	1s910ms	UPDATE ORDERS SET sapOrderNumber = $1, answerOrderNumber = $2, orderNumber = $3, routeNumber = $4, billToType = $5, patientName = $6, firstName = $7, middleName = $8, lastName = $9, patientDateOfBirth = $10, patientPostcode = $11, customer = $12, sapCustomerId = $13, status = $14, patientId = $15, isNotWithinAge = $16, expired = $17, paperwork = $18, deliveryBarcode = $19, deliveryDate = $20, rxStatus = $21, createUser = $22, subOrderType = $23, sapContractId = $24, salesforceOrderNumber = $25, patientType = $26, orderType = $27, orderStatus = $28, NHSnumber = $29, individualLabelling = $30, orderId = $31, clusterLead = $32, clusterGroup = $33, accountId = $34, reduction = $35, reductionBy = $36, alertConfirmation = $37, CREATED = $38, UPDATED = $39, note = $40 WHERE ORDER_ID = $41; [ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	1s869ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	1s578ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	1s290ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	1s153ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,047,338 Total read queries
713,817 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,047,338	43.92%
INSERT	178,411	7.48%
UPDATE	67,683	2.84%
DELETE	4,821	0.20%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	462,902	19.41%
OTHERS	623,336	26.14%

Queries by database

Key values

pharmisight Main database
2,384,491 Requests
9m29s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,384,491	9m29s
	DELETE	4,821	4s294ms
	INSERT	178,411	31s675ms
	OTHERS	623,336	9s458ms
	SELECT	1,047,338	6m55s
	TCL	462,902	27s820ms
	UPDATE	67,683	1m20s

Queries by user

Key values

symmetricds Main user
1,698,790 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	734,450	7m51s
	DELETE	47	996ms
	INSERT	27,602	20s608ms
	OTHERS	2,263	79ms
	SELECT	606,967	6m11s
	TCL	57,871	7s340ms
	UPDATE	39,700	1m11s
symmetricds	Total	1,698,790	1m39s
	DELETE	4,843	3s309ms
	INSERT	150,897	11s90ms
	OTHERS	641,847	9s705ms
	SELECT	455,476	45s742ms
	TCL	417,691	20s688ms
	UPDATE	28,036	9s78ms
tony	Total	900	236ms
	SELECT	900	236ms

Duration by user

Key values

7m51s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	734,450	7m51s
	DELETE	47	996ms
	INSERT	27,602	20s608ms
	OTHERS	2,263	79ms
	SELECT	606,967	6m11s
	TCL	57,871	7s340ms
	UPDATE	39,700	1m11s
symmetricds	Total	1,698,790	1m39s
	DELETE	4,843	3s309ms
	INSERT	150,897	11s90ms
	OTHERS	641,847	9s705ms
	SELECT	455,476	45s742ms
	TCL	417,691	20s688ms
	UPDATE	28,036	9s78ms
tony	Total	900	236ms
	SELECT	900	236ms

Queries by host

Key values

10.10.10.1 Main host
2,433,240 Requests
9m30s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,433,240	9m30s
	DELETE	4,890	4s306ms
	INSERT	178,499	31s698ms
	OTHERS	644,110	9s785ms
	SELECT	1,062,443	6m56s
	TCL	475,562	28s29ms
	UPDATE	67,736	1m20s
::1	Total	900	236ms
	SELECT	900	236ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,380,523 Requests
9m28s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,380,523	9m28s
	DELETE	4,821	4s294ms
	INSERT	178,366	31s653ms
	OTHERS	621,765	9s399ms
	SELECT	1,045,106	6m55s
	TCL	462,782	27s787ms
	UPDATE	67,683	1m20s
[unknown]	Total	3,968	552ms
	INSERT	45	22ms
	OTHERS	1,571	58ms
	SELECT	2,232	438ms
	TCL	120	33ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2019-01-28 16:46:38 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,331,477 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,331,477	97.78%
1-5ms	42,505	1.78%
5-10ms	3,225	0.14%
10-25ms	4,099	0.17%
25-50ms	2,294	0.10%
50-100ms	456	0.02%
100-500ms	415	0.02%
500-1000ms	7	0.00%
1000-10000ms	13	0.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:08:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:08:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 11:45:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 15:37:34 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:08:31 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:09:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:09:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:19:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:18:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:10:44 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:08:30 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:11:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-28 06:10:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	3s32ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	2s993ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:08:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	2s555ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:08:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	2s96ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 11:45:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	2s14ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 15:37:34 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	1s948ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	1s911ms	UPDATE ORDERS SET sapOrderNumber = $1, answerOrderNumber = $2, orderNumber = $3, routeNumber = $4, billToType = $5, patientName = $6, firstName = $7, middleName = $8, lastName = $9, patientDateOfBirth = $10, patientPostcode = $11, customer = $12, sapCustomerId = $13, status = $14, patientId = $15, isNotWithinAge = $16, expired = $17, paperwork = $18, deliveryBarcode = $19, deliveryDate = $20, rxStatus = $21, createUser = $22, subOrderType = $23, sapContractId = $24, salesforceOrderNumber = $25, patientType = $26, orderType = $27, orderStatus = $28, NHSnumber = $29, individualLabelling = $30, orderId = $31, clusterLead = $32, clusterGroup = $33, accountId = $34, reduction = $35, reductionBy = $36, alertConfirmation = $37, CREATED = $38, UPDATED = $39, note = $40 WHERE ORDER_ID = $41; [ Date: 2019-01-28 06:11:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	1s578ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	1s526ms	SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = $1 AND o.node_id = $2 ORDER BY d.data_id ASC; [ Date: 2019-01-28 06:08:31 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	1s359ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:09:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	1s291ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1s154ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:43 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	1s117ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:09:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	999ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:19:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	894ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	874ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2019-01-28 06:18:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	868ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:10:44 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	702ms	SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = $1 AND o.node_id = $2 ORDER BY d.data_id ASC; [ Date: 2019-01-28 06:08:30 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	675ms	UPDATE ORDERS SET PATIENT_ID = NULL WHERE PATIENT_ID = $1; [ Date: 2019-01-28 06:11:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	608ms	SELECT this_.ORDER_LINE_ID AS ORDER_LI1_24_0_, this_.routeNumber AS routeNum2_24_0_, this_.sapOrderNumber AS sapOrder3_24_0_, this_.orderNumber AS orderNum4_24_0_, this_.answerOrderNumber AS answerOr5_24_0_, this_.partCode AS partCode6_24_0_, this_.partDescription AS partDesc7_24_0_, this_.patientName AS patientN8_24_0_, this_.firstName AS firstNam9_24_0_, this_.middleName AS middleN10_24_0_, this_.lastName AS lastNam11_24_0_, this_.patientDateOfBirth AS patient12_24_0_, this_.patientPostcode AS patient13_24_0_, this_.patientPostcodePrefix AS patient14_24_0_, this_.orderQty AS orderQt15_24_0_, this_.allocQty AS allocQt16_24_0_, this_.shipQty AS shipQty17_24_0_, this_.adjustedQty AS adjuste18_24_0_, this_.scannedQty AS scanned19_24_0_, this_.assignedQty AS assigne20_24_0_, this_.checkedQty AS checked21_24_0_, this_.backOrderQty AS backOrd22_24_0_, this_.cancelQty AS cancelQ23_24_0_, this_.reducedQty AS reduced24_24_0_, this_.status AS status25_24_0_, this_.reason AS reason26_24_0_, this_.deliveryDate AS deliver27_24_0_, this_.customer AS custome28_24_0_, this_.sapCustomerId AS sapCust29_24_0_, this_.billToType AS billToT30_24_0_, this_.barcodeDate AS barcode31_24_0_, this_.barcodeBatch AS barcode32_24_0_, this_.patientId AS patient33_24_0_, this_.isAdded AS isAdded34_24_0_, this_.isNotWithinAge AS isNotWi35_24_0_, this_.isUnderAge AS isUnder36_24_0_, this_.ageCheck AS ageChec37_24_0_, this_.expired AS expired38_24_0_, this_.paperwork AS paperwo39_24_0_, this_.isPaperworkProblem AS isPaper40_24_0_, this_.paperworkResolution AS paperwo41_24_0_, this_.pickerId AS pickerI42_24_0_, this_.specialCare AS special43_24_0_, this_.paperworkEnquiryStarted AS paperwo44_24_0_, this_.paperworkEnquiryFinished AS paperwo45_24_0_, this_.paperworkEnquiryResponse AS paperwo46_24_0_, this_.isNewProduct AS isNewPr47_24_0_, this_.extraProcedure AS extraPr48_24_0_, this_.overAverageQtyMax AS overAve49_24_0_, this_.overAverageQtyResolution AS overAve50_24_0_, this_.createUser AS createU51_24_0_, this_.patientAlert AS patient52_24_0_, this_.itemAlert AS itemAle53_24_0_, this_.checkerId AS checker54_24_0_, this_.reductionSummary AS reducti55_24_0_, this_.isMetabolic AS isMetab56_24_0_, this_.rxStatus AS rxStatu57_24_0_, this_.lastRegUpdateUserType AS lastReg58_24_0_, this_.lastRegUpdateUserName AS lastReg59_24_0_, this_.lastRegUpdateDate AS lastReg60_24_0_, this_.sapPlannedShipDate AS sapPlan61_24_0_, this_.sapPlannedDeliveryDate AS sapPlan62_24_0_, this_.requestedSAPQuantity AS request63_24_0_, this_.orderQuantity AS orderQu64_24_0_, this_.regLineCreatedUserType AS regLine65_24_0_, this_.regLineCreatedUserName AS regLine66_24_0_, this_.regLineCreatedDate AS regLine67_24_0_, this_.audited AS audited68_24_0_, this_.isMetabolicPatient AS isMetab69_24_0_, this_.addedCase AS addedCa70_24_0_, this_.orderType AS orderTy71_24_0_, this_.CREATED AS CREATED72_24_0_, this_.UPDATED AS UPDATED73_24_0_, this_.rxCheckBy AS rxCheck74_24_0_, this_.note AS note75_24_0_, this_.item AS item76_24_0_, this_.alertConfirmation AS alertCo77_24_0_, this_.homewardAction AS homewar78_24_0_ FROM ORDER_LINES this_ WHERE this_.patientId = $1; [ Date: 2019-01-28 06:10:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 56s433ms - Times executed: 1656 ]
[ User: pharmisight - Total duration: 44s333ms - Times executed: 1953 ]
[ User: pharmisight - Total duration: 38s339ms - Times executed: 61683 ]
[ User: pharmisight - Total duration: 29s725ms - Times executed: 183 ]
[ User: symmetricds - Total duration: 19s250ms - Times executed: 202522 ]
[ User: pharmisight - Total duration: 19s804ms - Times executed: 6624 ]
[ User: pharmisight - Total duration: 19s416ms - Times executed: 1656 ]
[ User: pharmisight - Total duration: 18s603ms - Times executed: 74106 ]
[ User: pharmisight - Total duration: 16s80ms - Times executed: 7061 ]
[ User: pharmisight - Total duration: 14s841ms - Times executed: 605 ]
[ User: pharmisight - Total duration: 14s797ms - Times executed: 87 ]
[ User: pharmisight - Total duration: 13s952ms - Times executed: 524 ]
[ User: symmetricds - Total duration: 13s910ms - Times executed: 25735 ]
[ User: pharmisight - Total duration: 12s575ms - Times executed: 650 ]
[ User: pharmisight - Total duration: 9s756ms - Times executed: 8 ]
[ User: pharmisight - Total duration: 9s66ms - Times executed: 166 ]
[ User: symmetricds - Total duration: 8s821ms - Times executed: 581502 ]
[ User: pharmisight - Total duration: 8s837ms - Times executed: 13806 ]
[ User: pharmisight - Total duration: 8s502ms - Times executed: 13806 ]
[ User: pharmisight - Total duration: 8s285ms - Times executed: 1159 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 8s821ms - Times executed: 581502 ]
[ User: symmetricds - Total duration: 2s436ms - Times executed: 232991 ]
[ User: symmetricds - Total duration: 1s229ms - Times executed: 202521 ]
[ User: symmetricds - Total duration: 19s250ms - Times executed: 202522 ]
[ User: symmetricds - Total duration: 7s228ms - Times executed: 135965 ]
[ User: pharmisight - Total duration: 7s392ms - Times executed: 76993 ]
[ User: pharmisight - Total duration: 18s603ms - Times executed: 74106 ]
[ User: pharmisight - Total duration: 3s61ms - Times executed: 68182 ]
[ User: pharmisight - Total duration: 38s339ms - Times executed: 61683 ]
[ User: pharmisight - Total duration: 1s757ms - Times executed: 36762 ]
[ User: symmetricds - Total duration: 1s491ms - Times executed: 30778 ]
[ User: pharmisight - Total duration: 1s505ms - Times executed: 30349 ]
[ User: symmetricds - Total duration: 1s234ms - Times executed: 26472 ]
[ User: symmetricds - Total duration: 13s910ms - Times executed: 25735 ]
[ User: pharmisight - Total duration: 1s173ms - Times executed: 24350 ]
[ User: pharmisight - Total duration: 519ms - Times executed: 23311 ]
[ User: pharmisight - Total duration: 972ms - Times executed: 20656 ]
[ User: symmetricds - Total duration: 5s289ms - Times executed: 19673 ]
[ User: symmetricds - Total duration: 230ms - Times executed: 19001 ]
[ User: symmetricds - Total duration: 274ms - Times executed: 18999 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 9s756ms - Times executed: 8 ]
[ User: pharmisight - Total duration: 14s797ms - Times executed: 87 ]
[ User: pharmisight - Total duration: 29s725ms - Times executed: 183 ]
[ User: pharmisight - Total duration: 9s66ms - Times executed: 166 ]
[ User: pharmisight - Total duration: 56s433ms - Times executed: 1656 ]
[ User: pharmisight - Total duration: 13s952ms - Times executed: 524 ]
[ User: pharmisight - Total duration: 14s841ms - Times executed: 605 ]
[ User: pharmisight - Total duration: 44s333ms - Times executed: 1953 ]
[ User: pharmisight - Total duration: 12s575ms - Times executed: 650 ]
[ User: pharmisight - Total duration: 19s416ms - Times executed: 1656 ]
[ User: pharmisight - Total duration: 8s285ms - Times executed: 1159 ]
[ User: pharmisight - Total duration: 19s804ms - Times executed: 6624 ]
[ User: pharmisight - Total duration: 16s80ms - Times executed: 7061 ]
[ User: pharmisight - Total duration: 8s837ms - Times executed: 13806 ]
[ User: pharmisight - Total duration: 38s339ms - Times executed: 61683 ]
[ User: pharmisight - Total duration: 8s502ms - Times executed: 13806 ]
[ User: symmetricds - Total duration: 13s910ms - Times executed: 25735 ]
[ User: symmetricds - Total duration: 5s289ms - Times executed: 19673 ]
[ User: pharmisight - Total duration: 18s603ms - Times executed: 74106 ]
[ User: symmetricds - Total duration: 19s250ms - Times executed: 202522 ]

Log levels

Key values

7,683,736 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	16	0.00%
DETAIL	1,912,907	24.90%
ERROR	8	0.00%
LOG	5,770,785	75.10%
STATEMENT	20	0.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
8 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

8

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 28	06	6
	11	1
	15	1

ERROR: process 8971 still waiting for ShareLock on transaction 38956643 after 1000.135 ms
ERROR: process 8705 still waiting for ShareLock on transaction 38956643 after 1000.147 ms
ERROR: process 17311 still waiting for ShareLock on transaction 38976974 after 1000.080 ms

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values