pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jan 16 00:00:26 2019
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 8,214,387 log entries in 24s
Log start from 2019-01-15 00:00:00 to 2019-01-15 23:59:57

Global Stats

1,618 Number of unique normalized queries
2,484,013 Number of queries
9m53s Total query duration
2019-01-15 00:00:00 First query
2019-01-15 23:59:57 Last query
11,255 queries/s at 2019-01-15 06:05:40 Query peak

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

97 Total number of automatic vacuums
186 Total number of automatic analyzes

3 Number temporary file
9.84 MiB Max size of temporary file
9.79 MiB Average size of temporary file

1,917 Total number of sessions
3 sessions at 2019-01-15 12:35:46 Session peak
10d23h49m52s Total duration of sessions
8m15s Average duration of sessions
1,295 Average queries per session
309ms Average queries duration per session

1,917 Total number of connections
15 connections/s at 2019-01-15 06:05:23 Connection peak
1 Total number of databases

SQL Traffic

Key values

11,255 queries/s Query Peak
2019-01-15 06:05:40 Date

SELECT Traffic

Key values

2,166 queries/s Query Peak
2019-01-15 11:20:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,875 queries/s Query Peak
2019-01-15 06:05:40 Date

Queries duration

Key values

9m53s Total query duration

Prepared queries ratio

Key values

2.50 Ratio of bind vs prepare
132.48 % 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 15	00	54,092	0ms	65ms	0ms	60ms	141ms	1s105ms
	01	53,759	0ms	61ms	0ms	57ms	236ms	421ms
	02	53,561	0ms	63ms	0ms	55ms	114ms	586ms
	03	53,935	0ms	67ms	0ms	54ms	212ms	489ms
	04	53,333	0ms	56ms	0ms	60ms	143ms	483ms
	05	70,734	0ms	132ms	0ms	520ms	1s43ms	3s821ms
	06	297,724	0ms	588ms	0ms	3s59ms	4s605ms	5s401ms
	07	182,480	0ms	120ms	0ms	1s755ms	2s3ms	2s530ms
	08	221,944	0ms	176ms	0ms	1s905ms	2s238ms	3s490ms
	09	168,105	0ms	528ms	0ms	1s511ms	1s920ms	3s90ms
	10	142,549	0ms	184ms	0ms	1s527ms	1s924ms	3s180ms
	11	247,181	0ms	4s208ms	0ms	2s580ms	4s593ms	9s599ms
	12	204,266	0ms	10s246ms	0ms	3s179ms	4s580ms	59s601ms
	13	93,079	0ms	1s300ms	0ms	1s268ms	2s406ms	3s313ms
	14	99,935	0ms	183ms	0ms	572ms	2s308ms	3s178ms
	15	57,763	0ms	184ms	0ms	582ms	833ms	1s240ms
	16	63,270	0ms	186ms	0ms	483ms	1s154ms	2s661ms
	17	56,141	0ms	160ms	0ms	216ms	608ms	1s576ms
	18	56,520	0ms	44ms	0ms	68ms	88ms	421ms
	19	52,117	0ms	84ms	0ms	47ms	90ms	409ms
	20	52,500	0ms	78ms	0ms	44ms	185ms	587ms
	21	49,830	0ms	77ms	0ms	49ms	67ms	303ms
	22	49,622	0ms	78ms	0ms	46ms	50ms	307ms
	23	49,573	0ms	43ms	0ms	41ms	64ms	193ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 15	00	19,160	0ms	23ms	38ms	160ms
	01	18,494	0ms	27ms	35ms	164ms
	02	18,481	0ms	26ms	34ms	170ms
	03	18,471	0ms	25ms	34ms	166ms
	04	18,388	0ms	25ms	38ms	164ms
	05	27,993	0ms	35ms	260ms	1s158ms
	06	135,110	0ms	2s191ms	2s696ms	3s8ms
	07	87,171	0ms	989ms	1s267ms	1s943ms
	08	115,201	0ms	1s362ms	1s749ms	2s346ms
	09	86,172	0ms	1s13ms	1s384ms	2s231ms
	10	73,563	0ms	733ms	1s299ms	2s122ms
	11	154,940	0ms	1s672ms	2s272ms	4s359ms
	12	126,307	0ms	1s593ms	2s136ms	4s150ms
	13	47,288	0ms	432ms	1s113ms	2s810ms
	14	48,289	0ms	241ms	460ms	2s986ms
	15	21,871	0ms	144ms	574ms	839ms
	16	26,683	0ms	47ms	407ms	1s840ms
	17	21,510	0ms	33ms	209ms	659ms
	18	19,736	0ms	27ms	31ms	125ms
	19	18,196	0ms	23ms	31ms	158ms
	20	18,723	0ms	23ms	29ms	175ms
	21	16,109	0ms	26ms	32ms	76ms
	22	16,009	0ms	23ms	28ms	127ms
	23	16,001	0ms	23ms	30ms	93ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 15	00	751	244	111	0ms	2ms	7ms	32ms
	01	1,366	397	111	0ms	1ms	7ms	92ms
	02	1,251	370	111	0ms	1ms	7ms	87ms
	03	1,472	424	115	0ms	1ms	7ms	83ms
	04	1,107	332	110	0ms	1ms	7ms	41ms
	05	5,235	1,725	139	0ms	6ms	18ms	166ms
	06	63,742	20,337	501	0ms	152ms	600ms	1s505ms
	07	17,220	6,900	423	0ms	105ms	122ms	254ms
	08	20,649	7,695	447	0ms	113ms	130ms	179ms
	09	14,857	5,511	361	0ms	86ms	100ms	149ms
	10	11,315	4,750	267	0ms	78ms	119ms	205ms
	11	18,174	6,763	401	0ms	88ms	131ms	366ms
	12	13,501	5,033	337	4ms	81ms	104ms	331ms
	13	2,709	1,273	178	0ms	25ms	49ms	93ms
	14	4,185	1,886	229	0ms	42ms	61ms	99ms
	15	540	295	121	0ms	4ms	8ms	35ms
	16	505	361	127	0ms	7ms	15ms	89ms
	17	307	173	118	0ms	1ms	7ms	48ms
	18	317	1,065	112	0ms	9ms	12ms	28ms
	19	122	93	107	0ms	1ms	6ms	10ms
	20	134	95	138	0ms	1ms	5ms	9ms
	21	104	66	106	0ms	1ms	4ms	7ms
	22	88	54	106	0ms	0ms	3ms	7ms
	23	88	53	106	0ms	0ms	1ms	7ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 15	00	32,845	54,056	1.65	99.21%
	01	32,982	53,723	1.63	99.88%
	02	32,691	53,525	1.64	99.49%
	03	32,547	53,899	1.66	98.11%
	04	32,762	53,297	1.63	100.51%
	05	35,004	70,698	2.02	71.53%
	06	68,094	297,563	4.37	26.43%
	07	60,825	181,163	2.98	41.77%
	08	63,654	221,908	3.49	34.84%
	09	54,539	168,069	3.08	40.48%
	10	50,042	142,513	2.85	44.02%
	11	61,062	247,145	4.05	28.83%
	12	56,998	204,230	3.58	33.10%
	13	42,147	93,026	2.21	61.15%
	14	44,938	99,899	2.22	61.07%
	15	34,666	57,713	1.66	95.09%
	16	35,839	63,234	1.76	86.01%
	17	33,147	56,088	1.69	94.11%
	18	33,029	56,484	1.71	93.20%
	19	31,158	52,081	1.67	99.62%
	20	30,796	52,464	1.70	96.90%
	21	31,166	49,794	1.60	107.18%
	22	30,624	49,586	1.62	105.93%
	23	30,799	49,537	1.61	106.64%

Day	Hour	Count	Average / Second
Jan 15	00	86	0.02/s
	01	99	0.03/s
	02	93	0.03/s
	03	88	0.02/s
	04	94	0.03/s
	05	88	0.02/s
	06	82	0.02/s
	07	67	0.02/s
	08	50	0.01/s
	09	55	0.02/s
	10	78	0.02/s
	11	81	0.02/s
	12	110	0.03/s
	13	110	0.03/s
	14	85	0.02/s
	15	90	0.03/s
	16	95	0.03/s
	17	80	0.02/s
	18	65	0.02/s
	19	66	0.02/s
	20	61	0.02/s
	21	66	0.02/s
	22	61	0.02/s
	23	67	0.02/s

Day	Hour	Count	Average Duration
Jan 15	00	86	7m45s
	01	99	6m6s
	02	93	6m30s
	03	88	6m23s
	04	94	6m41s
	05	88	6m31s
	06	82	7m54s
	07	67	10m54s
	08	50	10m51s
	09	55	11m44s
	10	78	8m58s
	11	80	10m58s
	12	109	8m32s
	13	112	8m26s
	14	85	8m8s
	15	90	6m49s
	16	89	7m7s
	17	86	7m11s
	18	65	9m29s
	19	66	9m4s
	20	61	9m43s
	21	66	9m20s
	22	61	9m23s
	23	67	9m5s

↑ Back to the top of the General Activity table

Established Connections

Key values

15 connections Connection Peak
2019-01-15 06:05:23 Date

Connections per database

Key values

pharmisight Main Database
1,917 connections Total

Chart
Table

Database	User	Count
pharmisight		1,917
	pharmisight	709
	symmetricds	920
	tony	288

Connections per user

Key values

symmetricds Main User
1,917 connections Total

Chart
Table

User	Count
pharmisight	709
symmetricds	920
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1629 connections
1,917 Total connections

Chart
Table

Host	Count
10.10.10.1	1,629
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2019-01-15 12:35:46 Date

Histogram of session times

Key values

1,157 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	15.02%
500ms-1s	0	0.00%
1s-30s	5	0.26%
30s-1m	0	0.00%
1m-10m	1,157	60.35%
10m-30m	428	22.33%
30m-1h	36	1.88%
1h-8h	3	0.16%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,917 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,917	10d23h49m52s	8m15s

Sessions per user

Key values

symmetricds Main User
1,917 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	709	5d22h54m2s
symmetricds	920	5d55m38s
tony	288	11s671ms

Sessions per host

Key values

10.10.10.1 Main Host
1,917 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,629	10d23h49m40s	9m43s
::1	288	11s671ms	40ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,917 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,624	10d23h48m57s	9m44s
[unknown]	293	54s342ms	185ms

Checkpoints Buffers

Key values

8,463 buffers Checkpoint Peak
2019-01-15 07:04:30 Date
150.007 seconds Highest write time
0.030 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2019-01-15 06:09:29 Date

Checkpoints distance

Key values

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 15	00	601	60.326s	0.019s	60.402s
	01	581	58.312s	0.012s	58.373s
	02	603	60.51s	0.014s	60.575s
	03	621	62.314s	0.015s	62.386s
	04	558	55.999s	0.016s	56.067s
	05	636	63.719s	0.015s	63.786s
	06	11,315	1,085.593s	0.042s	1,085.705s
	07	15,838	892.057s	0.027s	892.158s
	08	8,475	862.53s	0.017s	862.623s
	09	7,009	702.154s	0.02s	702.241s
	10	7,630	649.832s	0.018s	649.914s
	11	8,001	802.931s	0.026s	803.043s
	12	5,905	590.808s	0.018s	590.893s
	13	4,180	317.98s	0.017s	318.077s
	14	3,064	307.06s	0.016s	307.141s
	15	876	87.916s	0.019s	87.993s
	16	1,174	117.791s	0.016s	117.873s
	17	696	69.741s	0.013s	69.807s
	18	1,571	157.638s	0.038s	157.795s
	19	434	43.544s	0.014s	43.618s
	20	348	34.923s	0.013s	34.985s
	21	408	40.947s	0.022s	41.017s
	22	374	37.531s	0.022s	37.657s
	23	383	38.438s	0.047s	38.585s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 15	00	0	1	250	0.011s	0.001s
	01	0	0	229	0.003s	0s
	02	0	0	235	0.003s	0s
	03	0	0	234	0.003s	0s
	04	0	0	234	0.003s	0s
	05	0	1	251	0.003s	0s
	06	2	8	1,287	0.002s	0s
	07	0	6	1,220	0.002s	0s
	08	0	4	1,224	0.002s	0s
	09	0	2	1,200	0.001s	0s
	10	0	3	947	0.002s	0s
	11	0	3	1,240	0.003s	0s
	12	0	3	1,117	0.002s	0s
	13	0	1	845	0.003s	0s
	14	0	1	845	0.002s	0s
	15	0	0	367	0.008s	0s
	16	0	1	431	0.003s	0s
	17	0	0	345	0.002s	0s
	18	0	1	309	0.017s	0s
	19	0	0	236	0.002s	0.001s
	20	0	0	233	0.003s	0s
	21	0	0	244	0.008s	0s
	22	0	0	206	0.008s	0s
	23	0	0	208	0.030s	0.001s

Day	Hour	Avg time (sec)
Jan 15	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s

Day	Hour	Mean distance	Mean estimate
Jan 15	00	285.60 kB	753.20 kB
	01	320.00 kB	663.22 kB
	02	343.22 kB	857.22 kB
	03	363.33 kB	685.78 kB
	04	324.00 kB	856.33 kB
	05	386.78 kB	860.11 kB
	06	14,455.75 kB	42,253.00 kB
	07	7,967.17 kB	28,456.42 kB
	08	4,908.17 kB	11,492.58 kB
	09	3,942.92 kB	7,855.92 kB
	10	3,674.83 kB	8,819.08 kB
	11	4,579.55 kB	7,673.91 kB
	12	3,256.67 kB	6,640.08 kB
	13	1,722.92 kB	7,341.33 kB
	14	1,464.92 kB	2,945.33 kB
	15	439.20 kB	1,879.20 kB
	16	653.22 kB	1,083.78 kB
	17	330.90 kB	1,194.40 kB
	18	851.30 kB	1,547.80 kB
	19	172.20 kB	730.90 kB
	20	124.33 kB	349.00 kB
	21	167.33 kB	423.11 kB
	22	167.89 kB	327.78 kB
	23	206.38 kB	441.88 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

19.62 MiB Temp Files size Peak
2019-01-15 06:05:58 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2019-01-15 06:05:58 Date

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

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

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	89
pharmisight.public.sym_outgoing_batch	40
pharmisight.public.sym_incoming_batch	16
pharmisight.public.sym_data	11
pharmisight.public.sym_data_event	11
pharmisight.public.sym_sequence	9
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	3
pharmisight.public.eps_header	1
Total	186

Vacuums per table

Key values

public.sym_data_gap (46) Main table vacuumed on database pharmisight
97 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	46	46
pharmisight.public.sym_outgoing_batch	18	18
pharmisight.public.sym_sequence	9	0
pharmisight.public.sym_incoming_batch	6	6
pharmisight.public.sym_node_host	6	0
pharmisight.public.sym_data_event	3	3
pharmisight.public.sym_data	3	3
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.pg_catalog.pg_statistic	2	2
pharmisight.public.item_codes	1	1
Total	97	82

Tuples removed per table

Key values

public.sym_data_event (63469) Main table with removed tuples on database pharmisight
97644 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_data_event	3	3	63469
pharmisight.public.sym_data	3	3	26487
pharmisight.public.sym_outgoing_batch	18	18	2521
pharmisight.public.sym_data_gap	46	46	2460
pharmisight.public.sym_incoming_batch	6	6	1023
pharmisight.pg_catalog.pg_statistic	2	2	501
pharmisight.public.sym_sequence	9	0	462
pharmisight.public.sym_node_host	6	0	312
pharmisight.public.item_codes	1	1	209
pharmisight.pg_toast.pg_toast_2619	3	3	200
Total	97	82	97,644

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	63469
pharmisight.public.sym_data_gap	46	46	2460
pharmisight.public.item_codes	1	1	209
pharmisight.pg_catalog.pg_statistic	2	2	501
pharmisight.public.sym_outgoing_batch	18	18	2521
pharmisight.public.sym_incoming_batch	6	6	1023
pharmisight.public.sym_node_host	6	0	312
pharmisight.public.sym_sequence	9	0	462
pharmisight.public.sym_data	3	3	26487
pharmisight.pg_toast.pg_toast_2619	3	3	200
Total	97	82	97,644

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
26 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		11	32s499ms	2s954ms
	tuple	11	32s499ms	2s954ms
ShareLock		15	46s547ms	3s103ms
	transaction	15	46s547ms	3s103ms
	Total	26	1m19s	3s40ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	26	1m19s	1s346ms	7s528ms	3s40ms	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-15 12:49:55 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-15 12:49:55 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-15 12:50:02 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most


[ Date: 2019-01-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 11:23:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-01-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	7s528ms	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-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	6s555ms	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-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	6s210ms	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-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	4s207ms	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-15 11:23:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	3s682ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	3s682ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	3s682ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	3s414ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	3s83ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	2s608ms	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-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	2s478ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	2s450ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	2s235ms	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-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	1s982ms	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-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,169,866 Total read queries
703,388 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,169,866	47.10%
INSERT	179,739	7.24%
UPDATE	65,895	2.65%
DELETE	4,882	0.20%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	452,872	18.23%
OTHERS	610,759	24.59%

Queries by database

Key values

pharmisight Main database
2,484,013 Requests
9m53s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,484,013	9m53s
	DELETE	4,882	6s40ms
	INSERT	179,739	28s428ms
	OTHERS	610,759	9s176ms
	SELECT	1,169,866	6m36s
	TCL	452,872	25s411ms
	UPDATE	65,895	2m7s

Queries by user

Key values

symmetricds Main user
1,667,716 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	868,272	8m18s
	DELETE	32	70ms
	INSERT	28,917	18s552ms
	OTHERS	2,215	75ms
	SELECT	739,383	5m53s
	TCL	58,196	6s869ms
	UPDATE	39,529	1m59s
symmetricds	Total	1,667,716	1m37s
	DELETE	4,920	5s975ms
	INSERT	152,702	10s178ms
	OTHERS	629,439	9s422ms
	SELECT	446,245	44s418ms
	TCL	407,502	18s793ms
	UPDATE	26,908	8s263ms
tony	Total	900	254ms
	SELECT	900	254ms

Duration by user

Key values

8m18s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	868,272	8m18s
	DELETE	32	70ms
	INSERT	28,917	18s552ms
	OTHERS	2,215	75ms
	SELECT	739,383	5m53s
	TCL	58,196	6s869ms
	UPDATE	39,529	1m59s
symmetricds	Total	1,667,716	1m37s
	DELETE	4,920	5s975ms
	INSERT	152,702	10s178ms
	OTHERS	629,439	9s422ms
	SELECT	446,245	44s418ms
	TCL	407,502	18s793ms
	UPDATE	26,908	8s263ms
tony	Total	900	254ms
	SELECT	900	254ms

Queries by host

Key values

10.10.10.1 Main host
2,535,988 Requests
9m55s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,535,988	9m55s
	DELETE	4,952	6s46ms
	INSERT	181,619	28s730ms
	OTHERS	631,654	9s498ms
	SELECT	1,185,628	6m37s
	TCL	465,698	25s662ms
	UPDATE	66,437	2m7s
::1	Total	900	254ms
	SELECT	900	254ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,480,071 Requests
9m52s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,480,071	9m52s
	DELETE	4,882	6s40ms
	INSERT	179,702	28s410ms
	OTHERS	609,125	9s112ms
	SELECT	1,167,699	6m36s
	TCL	452,768	25s399ms
	UPDATE	65,895	2m7s
[unknown]	Total	3,942	494ms
	INSERT	37	18ms
	OTHERS	1,634	63ms
	SELECT	2,167	399ms
	TCL	104	12ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2019-01-15 15:16:53 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,425,041 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,425,041	97.63%
1-5ms	48,015	1.93%
5-10ms	3,196	0.13%
10-25ms	5,354	0.22%
25-50ms	2,010	0.08%
50-100ms	264	0.01%
100-500ms	116	0.00%
500-1000ms	2	0.00%
1000-10000ms	14	0.00%
> 10000ms	1	0.00%

Slowest individual queries


[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:50:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:50:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 11:23:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 13:40:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 06:05:58 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 09:08:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 09:09:07 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 09:09:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-01-15 09:09:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	10s246ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	9s894ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	8s861ms	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-15 12:50:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	8s750ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	7s529ms	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-15 12:49:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	5s772ms	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-15 12:50:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	5s551ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	4s362ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	4s208ms	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-15 11:23:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	3s908ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	3s419ms	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-15 12:49:55 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	3s385ms	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-15 12:49:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	2s238ms	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-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	1s988ms	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-15 11:53:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	1s300ms	SELECT this_.ORDER_LINE_ID AS ORDER_LI1_24_0_, this_.routeNumber AS routeNum2_24_0_, this_.sapOrderNumber AS sapOrder3_24_0_, this_.orderNumber AS orderNum4_24_0_, this_.answerOrderNumber AS answerOr5_24_0_, this_.partCode AS partCode6_24_0_, this_.partDescription AS partDesc7_24_0_, this_.patientName AS patientN8_24_0_, this_.firstName AS firstNam9_24_0_, this_.middleName AS middleN10_24_0_, this_.lastName AS lastNam11_24_0_, this_.patientDateOfBirth AS patient12_24_0_, this_.patientPostcode AS patient13_24_0_, this_.patientPostcodePrefix AS patient14_24_0_, this_.orderQty AS orderQt15_24_0_, this_.allocQty AS allocQt16_24_0_, this_.shipQty AS shipQty17_24_0_, this_.adjustedQty AS adjuste18_24_0_, this_.scannedQty AS scanned19_24_0_, this_.assignedQty AS assigne20_24_0_, this_.checkedQty AS checked21_24_0_, this_.backOrderQty AS backOrd22_24_0_, this_.cancelQty AS cancelQ23_24_0_, this_.reducedQty AS reduced24_24_0_, this_.status AS status25_24_0_, this_.reason AS reason26_24_0_, this_.deliveryDate AS deliver27_24_0_, this_.customer AS custome28_24_0_, this_.sapCustomerId AS sapCust29_24_0_, this_.billToType AS billToT30_24_0_, this_.barcodeDate AS barcode31_24_0_, this_.barcodeBatch AS barcode32_24_0_, this_.patientId AS patient33_24_0_, this_.isAdded AS isAdded34_24_0_, this_.isNotWithinAge AS isNotWi35_24_0_, this_.isUnderAge AS isUnder36_24_0_, this_.ageCheck AS ageChec37_24_0_, this_.expired AS expired38_24_0_, this_.paperwork AS paperwo39_24_0_, this_.isPaperworkProblem AS isPaper40_24_0_, this_.paperworkResolution AS paperwo41_24_0_, this_.pickerId AS pickerI42_24_0_, this_.specialCare AS special43_24_0_, this_.paperworkEnquiryStarted AS paperwo44_24_0_, this_.paperworkEnquiryFinished AS paperwo45_24_0_, this_.paperworkEnquiryResponse AS paperwo46_24_0_, this_.isNewProduct AS isNewPr47_24_0_, this_.extraProcedure AS extraPr48_24_0_, this_.overAverageQtyMax AS overAve49_24_0_, this_.overAverageQtyResolution AS overAve50_24_0_, this_.createUser AS createU51_24_0_, this_.patientAlert AS patient52_24_0_, this_.itemAlert AS itemAle53_24_0_, this_.checkerId AS checker54_24_0_, this_.reductionSummary AS reducti55_24_0_, this_.isMetabolic AS isMetab56_24_0_, this_.rxStatus AS rxStatu57_24_0_, this_.lastRegUpdateUserType AS lastReg58_24_0_, this_.lastRegUpdateUserName AS lastReg59_24_0_, this_.lastRegUpdateDate AS lastReg60_24_0_, this_.sapPlannedShipDate AS sapPlan61_24_0_, this_.sapPlannedDeliveryDate AS sapPlan62_24_0_, this_.requestedSAPQuantity AS request63_24_0_, this_.orderQuantity AS orderQu64_24_0_, this_.regLineCreatedUserType AS regLine65_24_0_, this_.regLineCreatedUserName AS regLine66_24_0_, this_.regLineCreatedDate AS regLine67_24_0_, this_.audited AS audited68_24_0_, this_.isMetabolicPatient AS isMetab69_24_0_, this_.addedCase AS addedCa70_24_0_, this_.orderType AS orderTy71_24_0_, this_.CREATED AS CREATED72_24_0_, this_.UPDATED AS UPDATED73_24_0_, this_.rxCheckBy AS rxCheck74_24_0_, this_.note AS note75_24_0_, this_.item AS item76_24_0_, this_.alertConfirmation AS alertCo77_24_0_, this_.homewardAction AS homewar78_24_0_ FROM ORDER_LINES this_ WHERE this_.deliveryDate BETWEEN $1 AND $2; [ Date: 2019-01-15 13:40:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	588ms	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-15 06:05:58 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	528ms	SELECT this_.ORDER_ID AS ORDER_ID1_22_0_, this_.sapOrderNumber AS sapOrder2_22_0_, this_.answerOrderNumber AS answerOr3_22_0_, this_.orderNumber AS orderNum4_22_0_, this_.routeNumber AS routeNum5_22_0_, this_.billToType AS billToTy6_22_0_, this_.patientName AS patientN7_22_0_, this_.firstName AS firstNam8_22_0_, this_.middleName AS middleNa9_22_0_, this_.lastName AS lastNam10_22_0_, this_.patientDateOfBirth AS patient11_22_0_, this_.patientPostcode AS patient12_22_0_, this_.customer AS custome13_22_0_, this_.sapCustomerId AS sapCust14_22_0_, this_.status AS status15_22_0_, this_.patientId AS patient16_22_0_, this_.isNotWithinAge AS isNotWi17_22_0_, this_.expired AS expired18_22_0_, this_.paperwork AS paperwo19_22_0_, this_.deliveryBarcode AS deliver20_22_0_, this_.deliveryDate AS deliver21_22_0_, this_.rxStatus AS rxStatu22_22_0_, this_.createUser AS createU23_22_0_, this_.subOrderType AS subOrde24_22_0_, this_.sapContractId AS sapCont25_22_0_, this_.salesforceOrderNumber AS salesfo26_22_0_, this_.patientType AS patient27_22_0_, this_.orderType AS orderTy28_22_0_, this_.orderStatus AS orderSt29_22_0_, this_.NHSnumber AS NHSnumb30_22_0_, this_.individualLabelling AS individ31_22_0_, this_.orderId AS orderId32_22_0_, this_.clusterLead AS cluster33_22_0_, this_.clusterGroup AS cluster34_22_0_, this_.accountId AS account35_22_0_, this_.reduction AS reducti36_22_0_, this_.reductionBy AS reducti37_22_0_, this_.alertConfirmation AS alertCo38_22_0_, this_.CREATED AS CREATED39_22_0_, this_.UPDATED AS UPDATED40_22_0_, this_.note AS note41_22_0_ FROM ORDERS this_ WHERE this_.salesforceOrderNumber = $1; [ Date: 2019-01-15 09:08:52 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	486ms	SELECT this_.ORDER_ID AS ORDER_ID1_22_0_, this_.sapOrderNumber AS sapOrder2_22_0_, this_.answerOrderNumber AS answerOr3_22_0_, this_.orderNumber AS orderNum4_22_0_, this_.routeNumber AS routeNum5_22_0_, this_.billToType AS billToTy6_22_0_, this_.patientName AS patientN7_22_0_, this_.firstName AS firstNam8_22_0_, this_.middleName AS middleNa9_22_0_, this_.lastName AS lastNam10_22_0_, this_.patientDateOfBirth AS patient11_22_0_, this_.patientPostcode AS patient12_22_0_, this_.customer AS custome13_22_0_, this_.sapCustomerId AS sapCust14_22_0_, this_.status AS status15_22_0_, this_.patientId AS patient16_22_0_, this_.isNotWithinAge AS isNotWi17_22_0_, this_.expired AS expired18_22_0_, this_.paperwork AS paperwo19_22_0_, this_.deliveryBarcode AS deliver20_22_0_, this_.deliveryDate AS deliver21_22_0_, this_.rxStatus AS rxStatu22_22_0_, this_.createUser AS createU23_22_0_, this_.subOrderType AS subOrde24_22_0_, this_.sapContractId AS sapCont25_22_0_, this_.salesforceOrderNumber AS salesfo26_22_0_, this_.patientType AS patient27_22_0_, this_.orderType AS orderTy28_22_0_, this_.orderStatus AS orderSt29_22_0_, this_.NHSnumber AS NHSnumb30_22_0_, this_.individualLabelling AS individ31_22_0_, this_.orderId AS orderId32_22_0_, this_.clusterLead AS cluster33_22_0_, this_.clusterGroup AS cluster34_22_0_, this_.accountId AS account35_22_0_, this_.reduction AS reducti36_22_0_, this_.reductionBy AS reducti37_22_0_, this_.alertConfirmation AS alertCo38_22_0_, this_.CREATED AS CREATED39_22_0_, this_.UPDATED AS UPDATED40_22_0_, this_.note AS note41_22_0_ FROM ORDERS this_ WHERE this_.salesforceOrderNumber = $1; [ Date: 2019-01-15 09:09:07 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	484ms	SELECT this_.ORDER_ID AS ORDER_ID1_22_0_, this_.sapOrderNumber AS sapOrder2_22_0_, this_.answerOrderNumber AS answerOr3_22_0_, this_.orderNumber AS orderNum4_22_0_, this_.routeNumber AS routeNum5_22_0_, this_.billToType AS billToTy6_22_0_, this_.patientName AS patientN7_22_0_, this_.firstName AS firstNam8_22_0_, this_.middleName AS middleNa9_22_0_, this_.lastName AS lastNam10_22_0_, this_.patientDateOfBirth AS patient11_22_0_, this_.patientPostcode AS patient12_22_0_, this_.customer AS custome13_22_0_, this_.sapCustomerId AS sapCust14_22_0_, this_.status AS status15_22_0_, this_.patientId AS patient16_22_0_, this_.isNotWithinAge AS isNotWi17_22_0_, this_.expired AS expired18_22_0_, this_.paperwork AS paperwo19_22_0_, this_.deliveryBarcode AS deliver20_22_0_, this_.deliveryDate AS deliver21_22_0_, this_.rxStatus AS rxStatu22_22_0_, this_.createUser AS createU23_22_0_, this_.subOrderType AS subOrde24_22_0_, this_.sapContractId AS sapCont25_22_0_, this_.salesforceOrderNumber AS salesfo26_22_0_, this_.patientType AS patient27_22_0_, this_.orderType AS orderTy28_22_0_, this_.orderStatus AS orderSt29_22_0_, this_.NHSnumber AS NHSnumb30_22_0_, this_.individualLabelling AS individ31_22_0_, this_.orderId AS orderId32_22_0_, this_.clusterLead AS cluster33_22_0_, this_.clusterGroup AS cluster34_22_0_, this_.accountId AS account35_22_0_, this_.reduction AS reducti36_22_0_, this_.reductionBy AS reducti37_22_0_, this_.alertConfirmation AS alertCo38_22_0_, this_.CREATED AS CREATED39_22_0_, this_.UPDATED AS UPDATED40_22_0_, this_.note AS note41_22_0_ FROM ORDERS this_ WHERE this_.salesforceOrderNumber = $1; [ Date: 2019-01-15 09:09:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	483ms	SELECT this_.ORDER_ID AS ORDER_ID1_22_0_, this_.sapOrderNumber AS sapOrder2_22_0_, this_.answerOrderNumber AS answerOr3_22_0_, this_.orderNumber AS orderNum4_22_0_, this_.routeNumber AS routeNum5_22_0_, this_.billToType AS billToTy6_22_0_, this_.patientName AS patientN7_22_0_, this_.firstName AS firstNam8_22_0_, this_.middleName AS middleNa9_22_0_, this_.lastName AS lastNam10_22_0_, this_.patientDateOfBirth AS patient11_22_0_, this_.patientPostcode AS patient12_22_0_, this_.customer AS custome13_22_0_, this_.sapCustomerId AS sapCust14_22_0_, this_.status AS status15_22_0_, this_.patientId AS patient16_22_0_, this_.isNotWithinAge AS isNotWi17_22_0_, this_.expired AS expired18_22_0_, this_.paperwork AS paperwo19_22_0_, this_.deliveryBarcode AS deliver20_22_0_, this_.deliveryDate AS deliver21_22_0_, this_.rxStatus AS rxStatu22_22_0_, this_.createUser AS createU23_22_0_, this_.subOrderType AS subOrde24_22_0_, this_.sapContractId AS sapCont25_22_0_, this_.salesforceOrderNumber AS salesfo26_22_0_, this_.patientType AS patient27_22_0_, this_.orderType AS orderTy28_22_0_, this_.orderStatus AS orderSt29_22_0_, this_.NHSnumber AS NHSnumb30_22_0_, this_.individualLabelling AS individ31_22_0_, this_.orderId AS orderId32_22_0_, this_.clusterLead AS cluster33_22_0_, this_.clusterGroup AS cluster34_22_0_, this_.accountId AS account35_22_0_, this_.reduction AS reducti36_22_0_, this_.reductionBy AS reducti37_22_0_, this_.alertConfirmation AS alertCo38_22_0_, this_.CREATED AS CREATED39_22_0_, this_.UPDATED AS UPDATED40_22_0_, this_.note AS note41_22_0_ FROM ORDERS this_ WHERE this_.salesforceOrderNumber = $1; [ Date: 2019-01-15 09:09:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1m21s - Times executed: 688 ]
[ User: pharmisight - Total duration: 53s438ms - Times executed: 1664 ]
[ User: pharmisight - Total duration: 53s290ms - Times executed: 89171 ]
[ User: symmetricds - Total duration: 17s374ms - Times executed: 197347 ]
[ User: pharmisight - Total duration: 22s234ms - Times executed: 98238 ]
[ User: pharmisight - Total duration: 21s817ms - Times executed: 6656 ]
[ User: pharmisight - Total duration: 20s628ms - Times executed: 889 ]
[ User: pharmisight - Total duration: 20s254ms - Times executed: 1664 ]
[ User: pharmisight - Total duration: 16s115ms - Times executed: 4173 ]
[ User: pharmisight - Total duration: 15s112ms - Times executed: 7055 ]
[ User: symmetricds - Total duration: 13s907ms - Times executed: 25744 ]
[ User: pharmisight - Total duration: 13s589ms - Times executed: 803 ]
[ User: pharmisight - Total duration: 10s348ms - Times executed: 187 ]
[ User: pharmisight - Total duration: 9s608ms - Times executed: 62 ]
[ User: pharmisight - Total duration: 8s711ms - Times executed: 13838 ]
[ User: symmetricds - Total duration: 8s571ms - Times executed: 570745 ]
[ User: pharmisight - Total duration: 8s459ms - Times executed: 388 ]
[ User: pharmisight - Total duration: 8s325ms - Times executed: 13830 ]
[ User: pharmisight - Total duration: 7s710ms - Times executed: 83293 ]
[ User: pharmisight - Total duration: 7s224ms - Times executed: 5564 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 8s571ms - Times executed: 570745 ]
[ User: symmetricds - Total duration: 2s336ms - Times executed: 227142 ]
[ User: symmetricds - Total duration: 1s174ms - Times executed: 197347 ]
[ User: symmetricds - Total duration: 17s374ms - Times executed: 197347 ]
[ User: symmetricds - Total duration: 6s720ms - Times executed: 136724 ]
[ User: pharmisight - Total duration: 22s234ms - Times executed: 98238 ]
[ User: pharmisight - Total duration: 53s290ms - Times executed: 89171 ]
[ User: pharmisight - Total duration: 7s710ms - Times executed: 83293 ]
[ User: pharmisight - Total duration: 3s120ms - Times executed: 74791 ]
[ User: pharmisight - Total duration: 2s336ms - Times executed: 53196 ]
[ User: pharmisight - Total duration: 2s223ms - Times executed: 47108 ]
[ User: pharmisight - Total duration: 2s146ms - Times executed: 44103 ]
[ User: symmetricds - Total duration: 1s443ms - Times executed: 30297 ]
[ User: symmetricds - Total duration: 1s212ms - Times executed: 26158 ]
[ User: symmetricds - Total duration: 13s907ms - Times executed: 25744 ]
[ User: pharmisight - Total duration: 495ms - Times executed: 23477 ]
[ User: pharmisight - Total duration: 832ms - Times executed: 20359 ]
[ User: symmetricds - Total duration: 213ms - Times executed: 18026 ]
[ User: symmetricds - Total duration: 256ms - Times executed: 18026 ]
[ User: symmetricds - Total duration: 4s608ms - Times executed: 17790 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 9s608ms - Times executed: 62 ]
[ User: pharmisight - Total duration: 1m21s - Times executed: 688 ]
[ User: pharmisight - Total duration: 10s348ms - Times executed: 187 ]
[ User: pharmisight - Total duration: 53s438ms - Times executed: 1664 ]
[ User: pharmisight - Total duration: 20s628ms - Times executed: 889 ]
[ User: pharmisight - Total duration: 8s459ms - Times executed: 388 ]
[ User: pharmisight - Total duration: 13s589ms - Times executed: 803 ]
[ User: pharmisight - Total duration: 20s254ms - Times executed: 1664 ]
[ User: pharmisight - Total duration: 16s115ms - Times executed: 4173 ]
[ User: pharmisight - Total duration: 21s817ms - Times executed: 6656 ]
[ User: pharmisight - Total duration: 15s112ms - Times executed: 7055 ]
[ User: pharmisight - Total duration: 7s224ms - Times executed: 5564 ]
[ User: pharmisight - Total duration: 8s711ms - Times executed: 13838 ]
[ User: pharmisight - Total duration: 8s325ms - Times executed: 13830 ]
[ User: pharmisight - Total duration: 53s290ms - Times executed: 89171 ]
[ User: symmetricds - Total duration: 13s907ms - Times executed: 25744 ]
[ User: symmetricds - Total duration: 4s608ms - Times executed: 17790 ]
[ User: pharmisight - Total duration: 22s234ms - Times executed: 98238 ]
[ User: symmetricds - Total duration: 17s374ms - Times executed: 197347 ]
[ User: pharmisight - Total duration: 7s710ms - Times executed: 83293 ]

Log levels

Key values

8,133,273 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	30	0.00%
DETAIL	2,169,411	26.67%
ERROR	26	0.00%
LOG	5,963,754	73.33%
STATEMENT	52	0.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
26 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

15

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 15	11	2
	12	13

ERROR: process 20982 still waiting for ShareLock on transaction 30971943 after 1000.173 ms
ERROR: process 23658 still waiting for ShareLock on transaction 30976711 after 1000.071 ms
ERROR: process 23651 still waiting for ShareLock on transaction 30976713 after 1000.101 ms

2

11

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 15	11	1
	12	10

ERROR: process 23651 still waiting for ExclusiveLock on tuple (1367,40) of relation 142522 of database 16401 after 1000.092 ms
ERROR: process 23655 still waiting for ExclusiveLock on tuple (1367,40) of relation 142522 of database 16401 after 1000.116 ms
ERROR: process 23648 still waiting for ExclusiveLock on tuple (1367,40) of relation 142522 of database 16401 after 1000.101 ms

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values

Queries by application

Key values