pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Dec 21 00:00:49 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 13,307,547 log entries in 46s
Log start from 2018-12-20 00:00:00 to 2018-12-20 23:59:59

Global Stats

1,623 Number of unique normalized queries
4,067,604 Number of queries
19m40s Total query duration
2018-12-20 00:00:00 First query
2018-12-20 23:59:59 Last query
11,441 queries/s at 2018-12-20 06:09:17 Query peak

74 Number of events
6 Number of unique normalized events
48 Max number of times the same event was reported
0 Number of cancellation

499 Total number of automatic vacuums
600 Total number of automatic analyzes

3 Number temporary file
24.40 MiB Max size of temporary file
12.27 MiB Average size of temporary file

1,880 Total number of sessions
3 sessions at 2018-12-20 10:05:49 Session peak
14d3h8m38s Total duration of sessions
10m49s Average duration of sessions
2,163 Average queries per session
627ms Average queries duration per session

1,878 Total number of connections
15 connections/s at 2018-12-20 13:12:49 Connection peak
1 Total number of databases

SQL Traffic

Key values

11,441 queries/s Query Peak
2018-12-20 06:09:17 Date

SELECT Traffic

Key values

2,128 queries/s Query Peak
2018-12-20 12:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

11,360 queries/s Query Peak
2018-12-20 06:09:17 Date

Queries duration

Key values

19m40s Total query duration

Prepared queries ratio

Key values

2.48 Ratio of bind vs prepare
131.71 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 20	00	105,388	0ms	26ms	0ms	82ms	151ms	1s955ms
	01	96,045	0ms	15ms	0ms	62ms	255ms	373ms
	02	93,850	0ms	18ms	0ms	58ms	158ms	347ms
	03	94,173	0ms	16ms	0ms	57ms	188ms	316ms
	04	93,429	0ms	28ms	0ms	55ms	138ms	321ms
	05	129,728	0ms	2s5ms	0ms	283ms	4s356ms	9s879ms
	06	346,419	0ms	23s725ms	0ms	4s817ms	9s340ms	56s655ms
	07	226,002	0ms	1s191ms	0ms	1s655ms	1s776ms	2s549ms
	08	231,787	0ms	211ms	0ms	1s449ms	1s589ms	2s647ms
	09	179,943	0ms	220ms	0ms	1s55ms	1s548ms	2s378ms
	10	238,898	0ms	226ms	0ms	2s106ms	2s448ms	2s890ms
	11	265,528	0ms	11s693ms	0ms	2s389ms	5s488ms	29s360ms
	12	345,254	0ms	22s234ms	0ms	4s209ms	7s694ms	1m42s
	13	246,907	0ms	18s738ms	0ms	3s515ms	4s486ms	57s383ms
	14	226,817	0ms	277ms	0ms	2s456ms	3s622ms	5s504ms
	15	246,320	0ms	7s804ms	0ms	2s107ms	2s626ms	27s723ms
	16	199,398	0ms	213ms	0ms	1s859ms	2s295ms	3s45ms
	17	129,273	0ms	322ms	0ms	1s812ms	2s215ms	4s96ms
	18	93,516	0ms	31ms	0ms	64ms	89ms	538ms
	19	94,293	0ms	15ms	0ms	66ms	203ms	238ms
	20	97,768	0ms	28ms	0ms	61ms	217ms	798ms
	21	94,933	0ms	32ms	0ms	70ms	209ms	385ms
	22	96,492	0ms	15ms	0ms	67ms	313ms	421ms
	23	95,443	0ms	15ms	0ms	58ms	321ms	367ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 20	00	36,632	0ms	30ms	40ms	345ms
	01	31,486	0ms	32ms	36ms	61ms
	02	31,082	0ms	32ms	35ms	55ms
	03	31,114	0ms	31ms	34ms	50ms
	04	30,925	0ms	27ms	33ms	41ms
	05	45,460	0ms	32ms	160ms	941ms
	06	156,224	0ms	1s837ms	2s179ms	2s793ms
	07	96,002	0ms	829ms	982ms	1s501ms
	08	114,858	0ms	628ms	954ms	1s538ms
	09	77,372	0ms	524ms	755ms	1s944ms
	10	113,152	0ms	1s74ms	1s416ms	2s456ms
	11	154,351	0ms	1s56ms	2s140ms	5s684ms
	12	220,483	0ms	2s844ms	3s757ms	4s909ms
	13	143,721	0ms	1s932ms	3s109ms	4s571ms
	14	119,562	0ms	1s28ms	2s135ms	4s702ms
	15	140,537	0ms	806ms	1s764ms	2s394ms
	16	108,233	0ms	1s519ms	1s679ms	2s311ms
	17	62,725	0ms	827ms	1s523ms	2s591ms
	18	32,028	0ms	29ms	35ms	161ms
	19	31,267	0ms	28ms	36ms	46ms
	20	34,489	0ms	28ms	38ms	189ms
	21	31,325	0ms	32ms	38ms	61ms
	22	31,558	0ms	31ms	40ms	63ms
	23	31,354	0ms	29ms	34ms	56ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 20	00	1,133	1,664	114	0ms	9ms	13ms	51ms
	01	2,408	1,203	118	0ms	1ms	8ms	96ms
	02	916	830	110	0ms	1ms	9ms	66ms
	03	1,144	888	114	0ms	1ms	8ms	56ms
	04	796	799	114	0ms	1ms	8ms	58ms
	05	9,790	9,411	135	1ms	8ms	35ms	2s462ms
	06	69,675	16,677	478	1ms	500ms	858ms	6s639ms
	07	18,354	10,369	427	0ms	401ms	502ms	615ms
	08	16,345	8,379	426	0ms	249ms	321ms	400ms
	09	10,535	6,237	364	0ms	165ms	238ms	430ms
	10	20,973	9,354	407	0ms	288ms	379ms	453ms
	11	14,104	7,757	382	1ms	173ms	208ms	341ms
	12	20,109	9,265	424	6ms	222ms	282ms	361ms
	13	13,074	6,312	318	0ms	182ms	226ms	338ms
	14	13,692	7,125	380	0ms	161ms	217ms	291ms
	15	12,351	6,794	370	1ms	165ms	233ms	276ms
	16	6,357	4,530	312	0ms	97ms	129ms	224ms
	17	1,437	1,216	142	0ms	10ms	27ms	72ms
	18	350	677	116	0ms	2ms	8ms	34ms
	19	1,087	889	121	0ms	2ms	8ms	41ms
	20	1,139	964	159	0ms	2ms	8ms	83ms
	21	1,581	997	122	0ms	2ms	9ms	96ms
	22	2,656	1,266	121	0ms	2ms	9ms	110ms
	23	2,087	1,122	119	0ms	2ms	8ms	103ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 20	00	61,403	105,352	1.72	92.00%
	01	55,741	96,009	1.72	93.43%
	02	55,330	93,814	1.70	96.37%
	03	54,956	94,137	1.71	95.18%
	04	54,952	93,393	1.70	96.29%
	05	60,217	129,692	2.15	65.77%
	06	97,486	343,708	3.53	33.23%
	07	83,352	225,966	2.71	47.01%
	08	80,509	231,751	2.88	43.39%
	09	76,328	179,774	2.36	56.14%
	10	85,377	238,862	2.80	44.50%
	11	80,619	265,492	3.29	36.62%
	12	85,814	345,204	4.02	28.75%
	13	78,157	246,871	3.16	38.36%
	14	79,342	226,755	2.86	43.52%
	15	79,490	246,284	3.10	39.40%
	16	73,480	199,362	2.71	46.72%
	17	59,295	129,223	2.18	64.28%
	18	55,153	92,147	1.67	96.06%
	19	55,567	94,257	1.70	96.03%
	20	55,617	97,732	1.76	90.67%
	21	55,981	94,897	1.70	95.68%
	22	56,015	96,456	1.72	93.24%
	23	55,577	95,407	1.72	94.03%

Day	Hour	Count	Average / Second
Dec 20	00	87	0.02/s
	01	85	0.02/s
	02	85	0.02/s
	03	78	0.02/s
	04	80	0.02/s
	05	83	0.02/s
	06	70	0.02/s
	07	52	0.01/s
	08	62	0.02/s
	09	59	0.02/s
	10	60	0.02/s
	11	71	0.02/s
	12	103	0.03/s
	13	121	0.03/s
	14	85	0.02/s
	15	79	0.02/s
	16	66	0.02/s
	17	74	0.02/s
	18	89	0.02/s
	19	77	0.02/s
	20	71	0.02/s
	21	82	0.02/s
	22	82	0.02/s
	23	77	0.02/s

Day	Hour	Count	Average Duration
Dec 20	00	87	6m46s
	01	85	7m2s
	02	85	7m10s
	03	78	6m48s
	04	80	8m11s
	05	83	7m29s
	06	70	9m1s
	07	52	11m49s
	08	62	10m24s
	09	59	10m15s
	10	60	9m47s
	11	68	10m44s
	12	98	11m9s
	13	125	9m21s
	14	89	11m28s
	15	78	9m53s
	16	61	12m47s
	17	80	9m47s
	18	89	6m55s
	19	77	7m37s
	20	71	8m10s
	21	84	51m2s
	22	82	7m25s
	23	77	8m7s

↑ Back to the top of the General Activity table

Established Connections

Key values

15 connections Connection Peak
2018-12-20 13:12:49 Date

Connections per database

Key values

pharmisight Main Database
1,878 connections Total

Chart
Table

Database	User	Count
pharmisight		1,878
	pharmisight	928
	symmetricds	662
	tony	288

Connections per user

Key values

pharmisight Main User
1,878 connections Total

Chart
Table

User	Count
pharmisight	928
symmetricds	662
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1590 connections
1,878 Total connections

Chart
Table

Host	Count
10.10.10.1	1,590
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2018-12-20 10:05:49 Date

Histogram of session times

Key values

1,119 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	15.32%
500ms-1s	1	0.05%
1s-30s	6	0.32%
30s-1m	1	0.05%
1m-10m	1,119	59.52%
10m-30m	408	21.70%
30m-1h	54	2.87%
1h-8h	1	0.05%
> 8h	2	0.11%

Sessions per database

Key values

pharmisight Main Database
1,880 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,879	12d20h33m40s	9m51s
postgres	1	1d6h34m58s	1d6h34m58s

Sessions per user

Key values

pharmisight Main User
1,880 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	928	6d12h49m24s
symmetricds	662	5d1h9m5s
tony	290	2d13h10m8s

Sessions per host

Key values

10.10.10.1 Main Host
1,880 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,590	11d13h58m30s	10m29s
93.89.131.250	2	2d13h9m53s	1d6h34m56s
::1	288	15s285ms	53ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,880 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,584	11d13h57m39s	10m31s
[unknown]	294	1m6s	224ms
pgAdmin III - Browser	2	2d13h9m53s	1d6h34m56s

Checkpoints Buffers

Key values

4,310 buffers Checkpoint Peak
2018-12-20 06:06:33 Date
150.003 seconds Highest write time
0.018 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-12-20 06:19:25 Date

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

NO DATASET

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 20	00	1,627	163.009s	0.012s	163.062s
	01	915	91.618s	0.018s	91.678s
	02	867	86.898s	0.015s	86.955s
	03	761	76.245s	0.021s	76.307s
	04	768	77.059s	0.016s	77.113s
	05	702	70.43s	0.013s	70.486s
	06	17,142	1,203.961s	0.038s	1,204.046s
	07	12,427	988.519s	0.023s	988.587s
	08	10,321	818.172s	0.03s	818.246s
	09	5,774	577.987s	0.03s	578.061s
	10	7,814	784.092s	0.022s	784.166s
	11	9,312	805.008s	0.04s	805.095s
	12	8,170	820.243s	0.025s	820.303s
	13	6,084	630.66s	0.039s	630.741s
	14	6,031	603.653s	0.025s	603.725s
	15	6,122	615.804s	0.036s	615.883s
	16	4,559	462.376s	0.035s	462.455s
	17	1,485	148.571s	0.019s	148.633s
	18	974	97.604s	0.016s	97.66s
	19	1,148	114.971s	0.015s	115.03s
	20	869	87.095s	0.013s	87.163s
	21	912	91.512s	0.022s	91.577s
	22	994	99.627s	0.013s	99.682s
	23	1,028	103.132s	0.014s	103.188s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 20	00	0	0	368	0.002s	0s
	01	0	1	327	0.006s	0.001s
	02	0	0	335	0.002s	0s
	03	0	0	315	0.008s	0s
	04	0	0	318	0.002s	0s
	05	0	1	304	0.002s	0s
	06	0	13	1,459	0.002s	0s
	07	3	3	1,345	0.002s	0s
	08	0	3	1,172	0.008s	0s
	09	0	3	1,135	0.007s	0s
	10	0	3	1,222	0.002s	0s
	11	0	3	1,312	0.002s	0s
	12	0	4	1,208	0.001s	0s
	13	0	3	1,306	0.003s	0s
	14	0	2	1,041	0.002s	0s
	15	0	2	1,132	0.008s	0s
	16	0	2	1,250	0.009s	0s
	17	0	1	566	0.002s	0s
	18	0	0	315	0.002s	0s
	19	0	1	338	0.002s	0s
	20	0	0	354	0.002s	0s
	21	0	0	331	0.008s	0s
	22	0	0	341	0.001s	0s
	23	0	1	340	0.002s	0s

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

Day	Hour	Mean distance	Mean estimate
Dec 20	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

12.41 MiB Temp Files size Peak
2018-12-20 06:09:44 Date

Number of temporary files

Key values

1 per second Temp Files Peak
2018-12-20 06:09:45 Date

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

14.80 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight
2018-12-20 06:10:30 Date
8.15 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-12-20 10:59:30 Date

Analyzes per table

Key values

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

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	207
pharmisight.public.sym_sequence	120
pharmisight.public.sym_data_gap	120
pharmisight.public.sym_outgoing_batch	61
pharmisight.public.sym_node_channel_ctl	28
pharmisight.public.sym_data	15
pharmisight.public.sym_data_event	14
pharmisight.public.sym_incoming_batch	13
pharmisight.public.sym_lock	11
pharmisight.public.sym_node_host	5
pharmisight.public.item_codes	3
pharmisight.public.stats_checker_months	1
pharmisight.public.flow_report_summary_delays	1
pharmisight.public.tablets	1
Total	600

Vacuums per table

Key values

public.sym_node_communication (210) Main table vacuumed on database pharmisight
499 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	210	0
pharmisight.public.sym_sequence	127	1
pharmisight.public.sym_data_gap	64	64
pharmisight.public.sym_outgoing_batch	30	30
pharmisight.public.sym_node_channel_ctl	27	0
pharmisight.public.sym_lock	11	0
pharmisight.public.sym_data	7	4
pharmisight.public.sym_incoming_batch	6	6
pharmisight.public.sym_node_host	5	0
pharmisight.pg_catalog.pg_statistic	4	4
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.public.sym_data_event	3	3
pharmisight.public.flow_report_summary_delays	1	1
pharmisight.public.flow_report_summary_months	1	1
Total	499	117

Tuples removed per table

Key values

public.sym_data (13939) Main table with removed tuples on database pharmisight
49315 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data	7	4	13939	0
pharmisight.public.sym_node_communication	210	0	11394	0
pharmisight.public.sym_sequence	127	1	6622	1
pharmisight.public.sym_outgoing_batch	30	30	6498	7
pharmisight.public.sym_data_gap	64	64	3327	1
pharmisight.public.sym_data_event	3	3	2656	0
pharmisight.public.sym_node_channel_ctl	27	0	1450	0
pharmisight.pg_catalog.pg_statistic	4	4	1181	0
pharmisight.public.sym_incoming_batch	6	6	1071	0
pharmisight.public.sym_lock	11	0	572	0
pharmisight.public.sym_node_host	5	0	260	0
pharmisight.pg_toast.pg_toast_2619	3	3	252	0
pharmisight.public.flow_report_summary_delays	1	1	88	0
pharmisight.public.flow_report_summary_months	1	1	5	0
Total	499	117	49,315	9

Pages removed per table

Key values

public.sym_outgoing_batch (7) Main table with removed pages on database pharmisight
9 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_outgoing_batch	30	30	6498	7
pharmisight.public.sym_sequence	127	1	6622	1
pharmisight.public.sym_data_gap	64	64	3327	1
pharmisight.pg_catalog.pg_statistic	4	4	1181	0
pharmisight.public.flow_report_summary_delays	1	1	88	0
pharmisight.public.sym_incoming_batch	6	6	1071	0
pharmisight.public.sym_lock	11	0	572	0
pharmisight.pg_toast.pg_toast_2619	3	3	252	0
pharmisight.public.sym_node_communication	210	0	11394	0
pharmisight.public.sym_data	7	4	13939	0
pharmisight.public.sym_node_channel_ctl	27	0	1450	0
pharmisight.public.sym_node_host	5	0	260	0
pharmisight.public.sym_data_event	3	3	2656	0
pharmisight.public.flow_report_summary_months	1	1	5	0
Total	499	117	49,315	9

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 20	00	12	16
	01	10	9
	02	11	16
	03	9	9
	04	11	12
	05	13	14
	06	47	40
	07	36	43
	08	32	44
	09	30	38
	10	31	43
	11	35	43
	12	33	44
	13	26	35
	14	29	38
	15	29	41
	16	25	30
	17	13	13
	18	11	12
	19	12	10
	20	13	14
	21	11	10
	22	10	12
	23	10	14

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
68 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		20	1m47s	5s368ms
	tuple	20	1m47s	5s368ms
ShareLock		48	3m40s	4s583ms
	transaction	48	3m40s	4s583ms
	Total	68	5m27s	4s814ms

Most frequent waiting queries (N)

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

Queries that waited the most


[ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 06:25:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 06:24:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 06:24:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 15:53:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 15:53:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	11s691ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	11s664ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	10s571ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	10s570ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	10s439ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	10s139ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 06:25:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	9s917ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	9s872ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	7s277ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	7s249ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	7s226ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 06:24:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	6s887ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 06:24:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	6s437ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	6s360ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 15:53:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	6s359ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 15:53:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	6s81ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	6s79ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	6s79ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	6s79ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	6s78ms	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,905,940 Total read queries
1,178,597 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,905,940	46.86%
INSERT	242,093	5.95%
UPDATE	114,725	2.82%
DELETE	5,893	0.14%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	815,885	20.06%
OTHERS	983,067	24.17%

Queries by database

Key values

pharmisight Main database
4,067,604 Requests
19m40s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	4,067,604	19m40s
	DDL	1	1ms
	DELETE	5,893	7s106ms
	INSERT	242,093	50s32ms
	OTHERS	983,067	17s33ms
	SELECT	1,905,940	9m49s
	TCL	815,885	39s432ms
	UPDATE	114,725	7m57s

Queries by user

Key values

symmetricds Main user
2,929,649 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,232,744	17m38s
	DELETE	39	24ms
	INSERT	39,589	37s481ms
	OTHERS	2,865	85ms
	SELECT	1,064,095	9m6s
	TCL	74,260	9s681ms
	UPDATE	51,896	7m44s
symmetricds	Total	2,929,649	2m
	DDL	1	1ms
	DELETE	5,925	7s88ms
	INSERT	204,837	12s949ms
	OTHERS	1,016,544	17s589ms
	SELECT	872,254	39s697ms
	TCL	766,057	30s148ms
	UPDATE	64,031	13s39ms
tony	Total	900	4s529ms
	SELECT	900	4s529ms

Duration by user

Key values

17m38s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,232,744	17m38s
	DELETE	39	24ms
	INSERT	39,589	37s481ms
	OTHERS	2,865	85ms
	SELECT	1,064,095	9m6s
	TCL	74,260	9s681ms
	UPDATE	51,896	7m44s
symmetricds	Total	2,929,649	2m
	DDL	1	1ms
	DELETE	5,925	7s88ms
	INSERT	204,837	12s949ms
	OTHERS	1,016,544	17s589ms
	SELECT	872,254	39s697ms
	TCL	766,057	30s148ms
	UPDATE	64,031	13s39ms
tony	Total	900	4s529ms
	SELECT	900	4s529ms

Queries by host

Key values

10.10.10.1 Main host
4,162,393 Requests
19m38s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	4,162,393	19m38s
	DDL	1	1ms
	DELETE	5,964	7s112ms
	INSERT	244,426	50s430ms
	OTHERS	1,019,409	17s675ms
	SELECT	1,936,349	9m45s
	TCL	840,317	39s829ms
	UPDATE	115,927	7m57s
::1	Total	900	4s529ms
	SELECT	900	4s529ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
4,060,961 Requests
19m35s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	4,060,961	19m35s
	DDL	1	1ms
	DELETE	5,893	7s106ms
	INSERT	242,038	50s
	OTHERS	981,471	16s998ms
	SELECT	1,901,094	9m44s
	TCL	815,739	39s374ms
	UPDATE	114,725	7m57s
[unknown]	Total	6,643	4s920ms
	INSERT	55	32ms
	OTHERS	1,596	34ms
	SELECT	4,846	4s795ms
	TCL	146	57ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-12-20 13:38:41 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

3,981,642 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	3,981,642	97.89%
1-5ms	67,279	1.65%
5-10ms	4,559	0.11%
10-25ms	10,585	0.26%
25-50ms	2,820	0.07%
50-100ms	189	0.00%
100-500ms	488	0.01%
500-1000ms	3	0.00%
1000-10000ms	20	0.00%
> 10000ms	19	0.00%

Slowest individual queries


[ Date: 2018-12-20 06:25:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 13:06:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 13:06:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 13:06:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-12-20 15:53:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	23s725ms	UPDATE FLOW_REPORTS SET routeNumber = '9248061', roundDeliveryDate = '2018-12-21', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-12-20 06:12:16.672', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 12:00:19.451', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200475162'; [ Date: 2018-12-20 06:25:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	22s234ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	22s211ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	21s402ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	20s34ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:40:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	19s433ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	19s369ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	18s738ms	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 '2018-12-01' AND '2018-12-31'; [ Date: 2018-12-20 13:06:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	16s635ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	15s73ms	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 '2018-12-01' AND '2018-12-31'; [ Date: 2018-12-20 13:06:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	14s288ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	12s700ms	UPDATE FLOW_REPORTS SET routeNumber = '9248061', roundDeliveryDate = '2018-12-21', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-12-20 06:12:16.672', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 12:00:19.451', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200475162'; [ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	12s9ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	11s693ms	UPDATE FLOW_REPORTS SET routeNumber = '9248046', roundDeliveryDate = '2018-12-21', distributionPoint = 'FfaMensham', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 11:42:49.336', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 11:14:09', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-12-20 10:16:17.77', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:43.909', UPDATED = '2018-12-20 11:42:49.359', note = NULL WHERE FLOW_REPORT_ID = '200474992'; [ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	11s672ms	UPDATE FLOW_REPORTS SET routeNumber = '9248046', roundDeliveryDate = '2018-12-21', distributionPoint = 'FfaMensham', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 11:42:49.336', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 11:14:09', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2018-12-20 10:16:17.77', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:43.909', UPDATED = '2018-12-20 11:42:49.359', note = NULL WHERE FLOW_REPORT_ID = '200474992'; [ Date: 2018-12-20 11:43:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	11s628ms	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 '2018-12-01' AND '2018-12-31'; [ Date: 2018-12-20 13:06:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	10s443ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	10s234ms	UPDATE FLOW_REPORTS SET routeNumber = '9248062', roundDeliveryDate = '2018-12-21', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-12-20 06:12:16.884', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 12:00:35.613', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200475172'; [ Date: 2018-12-20 06:25:01 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	10s147ms	UPDATE FLOW_REPORTS SET routeNumber = '9248052', roundDeliveryDate = '2018-12-21', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 12:39:04.882', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 12:38:00', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:32:38.965', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 13:00:51.208', UPDATED = '2018-12-20 12:39:04.943', note = NULL WHERE FLOW_REPORT_ID = '200475052'; [ Date: 2018-12-20 12:39:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	7s804ms	UPDATE FLOW_REPORTS SET routeNumber = '9248064', roundDeliveryDate = '2018-12-21', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2018-12-20 15:53:21.001', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-12-20 16:22:15', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2018-12-20 10:48:32.342', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-12-20 17:00:07.225', UPDATED = '2018-12-20 15:53:21.026', note = NULL WHERE FLOW_REPORT_ID = '200475192'; [ Date: 2018-12-20 15:53:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 4m2s - Times executed: 295 ]
[ User: pharmisight - Total duration: 1m43s - Times executed: 152140 ]
[ User: pharmisight - Total duration: 1m28s - Times executed: 98 ]
[ User: pharmisight - Total duration: 53s259ms - Times executed: 5 ]
[ User: pharmisight - Total duration: 46s247ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 44s946ms - Times executed: 1331 ]
[ User: pharmisight - Total duration: 44s12ms - Times executed: 167602 ]
[ User: symmetricds - Total duration: 27s441ms - Times executed: 370822 ]
[ User: pharmisight - Total duration: 34s138ms - Times executed: 279 ]
[ User: pharmisight - Total duration: 25s591ms - Times executed: 1503 ]
[ User: pharmisight - Total duration: 25s487ms - Times executed: 2307 ]
[ User: pharmisight - Total duration: 21s30ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 18s121ms - Times executed: 151579 ]
[ User: symmetricds - Total duration: 16s910ms - Times executed: 978965 ]
[ User: pharmisight - Total duration: 16s782ms - Times executed: 706 ]
[ User: pharmisight - Total duration: 16s474ms - Times executed: 4920 ]
[ User: pharmisight - Total duration: 14s535ms - Times executed: 18277 ]
[ User: pharmisight - Total duration: 13s724ms - Times executed: 84 ]
[ User: pharmisight - Total duration: 12s769ms - Times executed: 3871 ]
[ User: pharmisight - Total duration: 12s25ms - Times executed: 1394 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 16s910ms - Times executed: 978965 ]
[ User: symmetricds - Total duration: 5s910ms - Times executed: 478008 ]
[ User: symmetricds - Total duration: 2s317ms - Times executed: 370821 ]
[ User: symmetricds - Total duration: 27s441ms - Times executed: 370822 ]
[ User: symmetricds - Total duration: 9s723ms - Times executed: 183211 ]
[ User: pharmisight - Total duration: 44s12ms - Times executed: 167602 ]
[ User: pharmisight - Total duration: 1m43s - Times executed: 152140 ]
[ User: pharmisight - Total duration: 18s121ms - Times executed: 151579 ]
[ User: pharmisight - Total duration: 6s393ms - Times executed: 137140 ]
[ User: pharmisight - Total duration: 3s989ms - Times executed: 86347 ]
[ User: symmetricds - Total duration: 3s460ms - Times executed: 77073 ]
[ User: symmetricds - Total duration: 2s271ms - Times executed: 68000 ]
[ User: symmetricds - Total duration: 1s169ms - Times executed: 57120 ]
[ User: pharmisight - Total duration: 2s113ms - Times executed: 34756 ]
[ User: symmetricds - Total duration: 6s453ms - Times executed: 32177 ]
[ User: pharmisight - Total duration: 775ms - Times executed: 30911 ]
[ User: pharmisight - Total duration: 1s265ms - Times executed: 25253 ]
[ User: pharmisight - Total duration: 1s304ms - Times executed: 25063 ]
[ User: pharmisight - Total duration: 1s745ms - Times executed: 25002 ]
[ User: pharmisight - Total duration: 970ms - Times executed: 22127 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 53s259ms - Times executed: 5 ]
[ User: pharmisight - Total duration: 1m28s - Times executed: 98 ]
[ User: pharmisight - Total duration: 4m2s - Times executed: 295 ]
[ User: pharmisight - Total duration: 13s724ms - Times executed: 84 ]
[ User: pharmisight - Total duration: 34s138ms - Times executed: 279 ]
[ User: pharmisight - Total duration: 46s247ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 44s946ms - Times executed: 1331 ]
[ User: pharmisight - Total duration: 16s782ms - Times executed: 706 ]
[ User: pharmisight - Total duration: 21s30ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 25s591ms - Times executed: 1503 ]
[ User: pharmisight - Total duration: 25s487ms - Times executed: 2307 ]
[ User: pharmisight - Total duration: 12s25ms - Times executed: 1394 ]
[ User: pharmisight - Total duration: 16s474ms - Times executed: 4920 ]
[ User: pharmisight - Total duration: 12s769ms - Times executed: 3871 ]
[ User: pharmisight - Total duration: 14s535ms - Times executed: 18277 ]
[ User: pharmisight - Total duration: 1m43s - Times executed: 152140 ]
[ User: pharmisight - Total duration: 44s12ms - Times executed: 167602 ]
[ User: symmetricds - Total duration: 6s453ms - Times executed: 32177 ]
[ User: pharmisight - Total duration: 18s121ms - Times executed: 151579 ]
[ User: symmetricds - Total duration: 27s441ms - Times executed: 370822 ]

Log levels

Key values

13,203,047 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	96	0.00%
DETAIL	3,431,193	25.99%
ERROR	63	0.00%
FATAL	5	0.00%
LOG	9,771,553	74.01%
STATEMENT	137	0.00%

Events distribution

Key values

0 PANIC entries
5 FATAL entries
69 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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


Date: 2018-12-20 11:43:02
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-12-20 11:43:02
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-12-20 23:28:53
Database: template0
Application: [unknown]
User: postgres
Remote: 71.6.158.166
Code: 
Date: 2018-12-20 23:28:53
Database: template0
Application: [unknown]
User: postgres
Remote: 71.6.158.166
Code: 
Date: 2018-12-20 00:00:20
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
Code: 
Date: 2018-12-20 23:28:54
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 71.6.158.166
Code: 

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

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