pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jun 13 00:00:26 2019
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 7,659,772 log entries in 24s
Log start from 2019-06-12 00:00:00 to 2019-06-12 23:59:59

Global Stats

1,720 Number of unique normalized queries
2,321,728 Number of queries
10m34s Total query duration
2019-06-12 00:00:00 First query
2019-06-12 23:59:54 Last query
10,957 queries/s at 2019-06-12 06:01:51 Query peak

20 Number of events
5 Number of unique normalized events
14 Max number of times the same event was reported
0 Number of cancellation

105 Total number of automatic vacuums
201 Total number of automatic analyzes

5 Number temporary file
9.67 MiB Max size of temporary file
5.78 MiB Average size of temporary file

1,792 Total number of sessions
3 sessions at 2019-06-12 08:18:16 Session peak
10d11h56m35s Total duration of sessions
8m26s Average duration of sessions
1,295 Average queries per session
354ms Average queries duration per session

1,792 Total number of connections
8 connections/s at 2019-06-12 13:01:48 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,957 queries/s Query Peak
2019-06-12 06:01:51 Date

SELECT Traffic

Key values

2,022 queries/s Query Peak
2019-06-12 06:00:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,877 queries/s Query Peak
2019-06-12 06:01:51 Date

Queries duration

Key values

10m34s Total query duration

Prepared queries ratio

Key values

2.46 Ratio of bind vs prepare
132.56 % 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)
Jun 12	00	55,543	0ms	70ms	0ms	74ms	162ms	1s76ms
	01	46,756	0ms	76ms	0ms	61ms	86ms	366ms
	02	46,759	0ms	71ms	0ms	55ms	72ms	351ms
	03	46,968	0ms	70ms	0ms	62ms	76ms	373ms
	04	46,638	0ms	75ms	0ms	59ms	74ms	399ms
	05	77,747	0ms	401ms	0ms	379ms	2s773ms	5s507ms
	06	255,788	0ms	6s897ms	0ms	3s240ms	4s489ms	34s277ms
	07	170,061	0ms	228ms	0ms	1s426ms	2s523ms	2s755ms
	08	217,319	0ms	52s627ms	0ms	3s674ms	4s563ms	1m8s
	09	128,716	0ms	1s459ms	0ms	1s569ms	2s1ms	3s289ms
	10	161,111	0ms	362ms	0ms	1s782ms	2s677ms	3s331ms
	11	132,911	0ms	263ms	0ms	1s709ms	2s419ms	3s160ms
	12	154,655	0ms	1s821ms	0ms	1s930ms	2s778ms	3s223ms
	13	148,035	0ms	919ms	0ms	1s705ms	2s44ms	2s192ms
	14	99,566	0ms	215ms	0ms	597ms	1s146ms	1s428ms
	15	108,862	0ms	553ms	0ms	1s176ms	1s534ms	3s140ms
	16	71,110	0ms	204ms	0ms	1s48ms	1s317ms	1s825ms
	17	60,530	0ms	203ms	0ms	691ms	804ms	2s383ms
	18	52,966	0ms	71ms	0ms	65ms	85ms	477ms
	19	46,807	0ms	77ms	0ms	50ms	68ms	391ms
	20	49,687	0ms	73ms	0ms	53ms	151ms	732ms
	21	47,108	0ms	76ms	0ms	55ms	66ms	394ms
	22	47,798	0ms	78ms	0ms	60ms	119ms	419ms
	23	48,287	0ms	73ms	0ms	74ms	82ms	400ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 12	00	22,125	0ms	25ms	34ms	591ms
	01	16,734	0ms	22ms	34ms	117ms
	02	16,844	0ms	22ms	34ms	132ms
	03	16,871	0ms	23ms	33ms	138ms
	04	16,776	0ms	23ms	34ms	135ms
	05	28,323	0ms	31ms	233ms	1s43ms
	06	118,012	0ms	1s826ms	2s609ms	3s498ms
	07	92,344	0ms	725ms	1s250ms	2s162ms
	08	113,117	0ms	1s723ms	3s128ms	4s467ms
	09	64,782	0ms	960ms	1s458ms	1s868ms
	10	85,237	0ms	989ms	1s565ms	2s858ms
	11	66,886	0ms	1s140ms	1s596ms	2s316ms
	12	84,164	0ms	1s38ms	1s666ms	2s547ms
	13	79,249	0ms	1s222ms	1s505ms	1s972ms
	14	43,052	0ms	288ms	436ms	1s162ms
	15	49,976	0ms	474ms	1s14ms	2s56ms
	16	33,219	0ms	445ms	925ms	1s712ms
	17	27,111	0ms	231ms	556ms	979ms
	18	18,977	0ms	22ms	32ms	141ms
	19	16,657	0ms	21ms	31ms	132ms
	20	19,392	0ms	22ms	33ms	146ms
	21	16,781	0ms	23ms	28ms	136ms
	22	17,145	0ms	24ms	27ms	143ms
	23	17,227	0ms	22ms	31ms	167ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 12	00	520	982	106	0ms	9ms	11ms	23ms
	01	470	57	104	0ms	1ms	7ms	26ms
	02	196	56	105	0ms	1ms	7ms	7ms
	03	451	57	105	0ms	1ms	7ms	29ms
	04	275	57	105	0ms	1ms	7ms	16ms
	05	7,948	7,559	134	0ms	7ms	15ms	1s575ms
	06	56,331	12,470	485	0ms	130ms	396ms	1s57ms
	07	15,747	5,513	413	0ms	91ms	111ms	476ms
	08	13,198	7,556	415	3ms	85ms	107ms	764ms
	09	7,306	3,255	330	0ms	56ms	76ms	534ms
	10	12,395	4,896	360	0ms	72ms	97ms	139ms
	11	8,599	4,495	309	0ms	71ms	105ms	155ms
	12	11,226	4,457	329	0ms	73ms	90ms	141ms
	13	11,106	4,164	300	0ms	81ms	107ms	146ms
	14	7,053	2,889	269	0ms	58ms	69ms	103ms
	15	7,220	3,056	278	0ms	59ms	74ms	101ms
	16	1,700	815	153	0ms	17ms	54ms	119ms
	17	603	328	122	0ms	7ms	18ms	79ms
	18	397	1,186	107	0ms	8ms	10ms	15ms
	19	158	74	103	0ms	1ms	6ms	7ms
	20	309	83	130	0ms	1ms	7ms	8ms
	21	271	56	104	0ms	1ms	7ms	15ms
	22	644	57	107	0ms	1ms	7ms	42ms
	23	1,018	65	104	0ms	1ms	7ms	42ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jun 12	00	32,238	55,507	1.72	88.13%
	01	29,695	46,720	1.57	104.47%
	02	29,900	46,723	1.56	105.58%
	03	29,689	46,932	1.58	103.92%
	04	29,605	46,602	1.57	104.67%
	05	33,946	77,711	2.29	59.26%
	06	56,185	254,345	4.53	25.20%
	07	51,899	170,025	3.28	36.78%
	08	73,713	217,265	2.95	42.62%
	09	47,615	128,666	2.70	47.67%
	10	51,944	161,075	3.10	40.05%
	11	49,508	132,875	2.68	47.46%
	12	50,633	154,619	3.05	40.56%
	13	48,435	147,973	3.06	40.71%
	14	44,076	99,511	2.26	60.41%
	15	45,174	108,826	2.41	55.38%
	16	35,153	71,074	2.02	69.94%
	17	32,284	59,327	1.84	78.78%
	18	30,403	52,916	1.74	89.41%
	19	28,011	46,771	1.67	99.19%
	20	28,641	49,651	1.73	92.00%
	21	28,633	47,072	1.64	100.52%
	22	28,372	47,762	1.68	97.14%
	23	28,212	48,251	1.71	95.00%

Day	Hour	Count	Average / Second
Jun 12	00	82	0.02/s
	01	88	0.02/s
	02	92	0.03/s
	03	93	0.03/s
	04	94	0.03/s
	05	94	0.03/s
	06	88	0.02/s
	07	84	0.02/s
	08	81	0.02/s
	09	54	0.01/s
	10	60	0.02/s
	11	72	0.02/s
	12	73	0.02/s
	13	82	0.02/s
	14	62	0.02/s
	15	60	0.02/s
	16	73	0.02/s
	17	69	0.02/s
	18	62	0.02/s
	19	63	0.02/s
	20	68	0.02/s
	21	73	0.02/s
	22	65	0.02/s
	23	60	0.02/s

Day	Hour	Count	Average Duration
Jun 12	00	82	7m15s
	01	88	7m11s
	02	92	6m32s
	03	93	6m30s
	04	94	6m27s
	05	93	6m22s
	06	89	6m44s
	07	84	7m39s
	08	81	7m42s
	09	53	11m43s
	10	58	12m10s
	11	72	10m43s
	12	73	9m11s
	13	85	9m32s
	14	62	9m43s
	15	60	10m1s
	16	73	8m32s
	17	68	9m7s
	18	63	9m21s
	19	63	9m59s
	20	68	8m52s
	21	73	8m15s
	22	65	9m8s
	23	60	9m28s

↑ Back to the top of the General Activity table

Established Connections

Key values

8 connections Connection Peak
2019-06-12 13:01:48 Date

Connections per database

Key values

pharmisight Main Database
1,792 connections Total

Chart
Table

Database	User	Count
pharmisight		1,792
	pharmisight	605
	symmetricds	899
	tony	288

Connections per user

Key values

symmetricds Main User
1,792 connections Total

Chart
Table

User	Count
pharmisight	605
symmetricds	899
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1504 connections
1,792 Total connections

Chart
Table

Host	Count
10.10.10.1	1,504
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2019-06-12 08:18:16 Date

Histogram of session times

Key values

1,002 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	16.07%
500ms-1s	0	0.00%
1s-30s	7	0.39%
30s-1m	0	0.00%
1m-10m	1,002	55.92%
10m-30m	455	25.39%
30m-1h	36	2.01%
1h-8h	4	0.22%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
1,792 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	1,792	10d11h56m35s	8m26s

Sessions per user

Key values

symmetricds Main User
1,792 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	605	5d11h22m8s
symmetricds	899	5d34m14s
tony	288	12s30ms

Sessions per host

Key values

10.10.10.1 Main Host
1,792 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,504	10d11h56m23s	10m3s
::1	288	12s30ms	41ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,792 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,497	10d11h55m34s	10m5s
[unknown]	295	1m	205ms

Checkpoints Buffers

Key values

5,338 buffers Checkpoint Peak
2019-06-12 07:03:39 Date
149.965 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

3 files Wal files usage Peak
2019-06-12 06:03:39 Date

Checkpoints distance

Key values

110.32 Mo Distance Peak
2019-06-12 06:03:39 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jun 12	00	1,384	138.766s	0.014s	138.836s
	01	576	57.787s	0.008s	57.845s
	02	487	48.873s	0.02s	48.944s
	03	500	50.179s	0.011s	50.237s
	04	442	44.35s	0.012s	44.5s
	05	1,138	159.947s	0.023s	160.025s
	06	11,353	993.119s	0.037s	993.222s
	07	14,480	931.858s	0.029s	931.995s
	08	6,475	674.836s	0.026s	674.924s
	09	4,842	493.26s	0.024s	493.349s
	10	7,164	645.727s	0.019s	645.808s
	11	6,673	669.655s	0.026s	669.747s
	12	6,158	616.747s	0.024s	616.836s
	13	5,752	586.184s	0.02s	586.278s
	14	5,563	482.345s	0.014s	482.421s
	15	4,268	427.175s	0.021s	427.284s
	16	1,953	195.789s	0.016s	195.866s
	17	1,038	103.934s	0.01s	103.995s
	18	1,500	150.498s	0.016s	150.584s
	19	578	57.997s	0.011s	58.061s
	20	466	46.755s	0.018s	46.832s
	21	535	53.689s	0.022s	53.775s
	22	671	67.337s	0.017s	67.418s
	23	817	81.979s	0.013s	82.05s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jun 12	00	0	1	287	0.002s	0s
	01	0	0	231	0.002s	0s
	02	0	0	226	0.008s	0s
	03	0	0	229	0.002s	0s
	04	0	0	215	0.003s	0s
	05	0	1	320	0.002s	0.001s
	06	1	8	1,204	0.002s	0s
	07	0	6	1,190	0.002s	0s
	08	0	3	1,219	0.002s	0s
	09	0	2	1,104	0.001s	0s
	10	0	3	1,104	0.002s	0s
	11	0	3	1,297	0.007s	0s
	12	0	2	1,165	0.002s	0s
	13	0	2	1,095	0.001s	0s
	14	0	2	860	0.002s	0s
	15	0	2	1,012	0.001s	0s
	16	0	0	726	0.002s	0s
	17	0	1	460	0.002s	0s
	18	0	0	279	0.002s	0s
	19	0	1	229	0.002s	0s
	20	0	0	254	0.002s	0s
	21	0	0	303	0.005s	0s
	22	0	0	313	0.002s	0s
	23	0	0	324	0.002s	0s

Day	Hour	Avg time (sec)
Jun 12	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
Jun 12	00	741.73 kB	1,026.55 kB
	01	298.11 kB	703.78 kB
	02	237.56 kB	440.56 kB
	03	243.67 kB	431.89 kB
	04	213.44 kB	431.44 kB
	05	1,007.90 kB	1,266.60 kB
	06	12,949.00 kB	38,288.50 kB
	07	8,436.33 kB	22,260.75 kB
	08	4,248.18 kB	10,190.27 kB
	09	2,711.00 kB	6,828.75 kB
	10	3,471.33 kB	6,704.17 kB
	11	3,467.00 kB	5,770.83 kB
	12	3,250.17 kB	6,276.92 kB
	13	3,222.33 kB	5,901.17 kB
	14	2,856.55 kB	7,262.45 kB
	15	2,206.33 kB	3,964.42 kB
	16	993.82 kB	2,210.18 kB
	17	606.00 kB	1,776.78 kB
	18	765.50 kB	1,016.92 kB
	19	266.30 kB	671.20 kB
	20	186.45 kB	473.73 kB
	21	182.83 kB	356.50 kB
	22	248.67 kB	622.58 kB
	23	330.92 kB	790.00 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

9.74 MiB Temp Files size Peak
2019-06-12 06:11:17 Date

Number of temporary files

Key values

3 per second Temp Files Peak
2019-06-12 06:11:17 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 12	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	5	28.91 MiB	5.78 MiB
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	2	6.15 MiB	2.70 MiB	3.45 MiB	3.07 MiB	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 = ? AND o.node_id = ? ORDER BY d.data_id ASC; 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-06-12 06:11:17 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	3.45 MiB	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-06-12 06:11:17 ]
2	2.70 MiB	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-06-12 06:11:17 ]

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

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	99
pharmisight.public.sym_outgoing_batch	42
pharmisight.public.sym_incoming_batch	18
pharmisight.public.sym_data	11
pharmisight.public.sym_data_event	11
pharmisight.public.sym_sequence	10
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	2
pharmisight.public.flow_report_summary_delays	1
pharmisight.public.users	1
Total	201

Vacuums per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	52	52
pharmisight.public.sym_outgoing_batch	19	19
pharmisight.public.sym_sequence	10	0
pharmisight.public.sym_incoming_batch	6	6
pharmisight.public.sym_node_host	5	0
pharmisight.public.sym_data_event	3	3
pharmisight.pg_catalog.pg_statistic	3	3
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.public.sym_data	3	3
pharmisight.public.item_codes	1	1
Total	105	90

Tuples removed per table

Key values

public.sym_data_event (4502) Main table with removed tuples on database pharmisight
14197 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_event	3	3	4502	0
pharmisight.public.sym_data_gap	52	52	2709	0
pharmisight.public.sym_data	3	3	2211	0
pharmisight.public.sym_outgoing_batch	19	19	1637	0
pharmisight.public.sym_incoming_batch	6	6	1016	0
pharmisight.pg_catalog.pg_statistic	3	3	893	0
pharmisight.public.sym_sequence	10	0	510	0
pharmisight.public.item_codes	1	1	265	0
pharmisight.public.sym_node_host	5	0	260	0
pharmisight.pg_toast.pg_toast_2619	3	3	194	5
Total	105	90	14,197	5

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.pg_toast.pg_toast_2619	3	3	194	5
pharmisight.public.sym_node_host	5	0	260	0
pharmisight.public.item_codes	1	1	265	0
pharmisight.public.sym_sequence	10	0	510	0
pharmisight.public.sym_data_event	3	3	4502	0
pharmisight.public.sym_incoming_batch	6	6	1016	0
pharmisight.pg_catalog.pg_statistic	3	3	893	0
pharmisight.public.sym_data_gap	52	52	2709	0
pharmisight.public.sym_outgoing_batch	19	19	1637	0
pharmisight.public.sym_data	3	3	2211	0
Total	105	90	14,197	5

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
17 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		3	14s568ms	4s856ms
	tuple	3	14s568ms	4s856ms
ShareLock		14	1m22s	5s865ms
	transaction	14	1m22s	5s865ms
	Total	17	1m36s	5s687ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	3	1m5s	4s851ms	52s625ms	21s779ms	UPDATE order_rounds SET routenumber = ?, uploadedbyuserid = ?, uploadedbyusername = ?, updatedby = ?, updatedbyusername = ?, orderroundnote = ?, firstcheckout = ?, allordersscannedok = ?, status = ?, reopenedtimes = ?, lastreopenbyid = ?, lastdonecheckin = ?, lastdonebyid = ?, lastdonebyusername = ?, missinglabels = ?, rounddeliverydate = ?, trolley = ?, stack = ?, picktime = ?, uploadupdated = ?, patientalert = ?, mismatches = ?, rxstatus = ?, distributionpoint = ?, audited = ?, auditedby = ?, auditstatus = ?, uploadfinished = ?, lastrxcompleted = ?, lastrxcompletedby = ?, orderroundnotereadby = ?, routeorderlinesqty = ?, dlxpickedlinesqty = ?, flowreport = ?, created = ?, createdby = ?, updated = ?, note = ? WHERE order_round_id = ?; UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; Date: 2019-06-12 08:51:32 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	14	31s351ms	1s340ms	3s446ms	2s239ms	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-06-12 09:37:03 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 12:31:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 09:37:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-06-12 08:55:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	52s625ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	7s862ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	4s851ms	UPDATE ORDER_ROUNDS SET routeNumber = $1, uploadedByUserId = $2, uploadedByUserName = $3, updatedBy = $4, updatedByUserName = $5, orderRoundNote = $6, firstCheckOut = $7, allOrdersScannedOK = $8, status = $9, reopenedTimes = $10, lastReopenById = $11, lastDoneCheckIn = $12, lastDoneById = $13, lastDoneByUserName = $14, missingLabels = $15, roundDeliveryDate = $16, trolley = $17, stack = $18, picktime = $19, uploadUpdated = $20, patientAlert = $21, mismatches = $22, rxStatus = $23, distributionPoint = $24, audited = $25, auditedBy = $26, auditStatus = $27, uploadFinished = $28, lastRxCompleted = $29, lastRxCompletedBy = $30, orderRoundNoteReadBy = $31, routeOrderLinesQty = $32, dlxPickedLinesQty = $33, flowReport = $34, CREATED = $35, createdBy = $36, UPDATED = $37, note = $38 WHERE ORDER_ROUND_ID = $39; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	3s446ms	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-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	3s446ms	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-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	3s446ms	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-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	3s446ms	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-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	3s275ms	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-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	1s854ms	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-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	1s816ms	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-06-12 12:31:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	1s692ms	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-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	1s535ms	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-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	1s534ms	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-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	1s534ms	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-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	1s522ms	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-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	1s459ms	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-06-12 09:37:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	1s340ms	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-06-12 08:55:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,081,001 Total read queries
667,787 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,081,001	46.56%
INSERT	165,141	7.11%
UPDATE	64,183	2.76%
DELETE	5,077	0.22%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	433,386	18.67%
OTHERS	572,940	24.68%

Queries by database

Key values

pharmisight Main database
2,321,728 Requests
10m34s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,321,728	10m34s
	DELETE	5,077	7s75ms
	INSERT	165,141	32s222ms
	OTHERS	572,940	9s118ms
	SELECT	1,081,001	6m47s
	TCL	433,386	27s267ms
	UPDATE	64,183	2m31s

Queries by user

Key values

symmetricds Main user
1,570,327 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	796,559	8m55s
	DELETE	65	1s646ms
	INSERT	23,349	18s250ms
	OTHERS	1,889	72ms
	SELECT	671,494	6m6s
	TCL	60,956	6s712ms
	UPDATE	38,806	2m22s
symmetricds	Total	1,570,327	1m40s
	DELETE	5,081	5s433ms
	INSERT	142,695	14s177ms
	OTHERS	589,670	9s356ms
	SELECT	423,701	41s883ms
	TCL	383,738	20s764ms
	UPDATE	25,442	8s812ms
tony	Total	900	280ms
	SELECT	900	280ms

Duration by user

Key values

8m55s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	796,559	8m55s
	DELETE	65	1s646ms
	INSERT	23,349	18s250ms
	OTHERS	1,889	72ms
	SELECT	671,494	6m6s
	TCL	60,956	6s712ms
	UPDATE	38,806	2m22s
symmetricds	Total	1,570,327	1m40s
	DELETE	5,081	5s433ms
	INSERT	142,695	14s177ms
	OTHERS	589,670	9s356ms
	SELECT	423,701	41s883ms
	TCL	383,738	20s764ms
	UPDATE	25,442	8s812ms
tony	Total	900	280ms
	SELECT	900	280ms

Queries by host

Key values

10.10.10.1 Main host
2,366,886 Requests
10m36s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,366,886	10m36s
	DELETE	5,146	7s80ms
	INSERT	166,044	32s428ms
	OTHERS	591,559	9s428ms
	SELECT	1,095,195	6m48s
	TCL	444,694	27s477ms
	UPDATE	64,248	2m31s
::1	Total	900	280ms
	SELECT	900	280ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,316,702 Requests
10m33s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,316,702	10m33s
	DELETE	5,077	7s75ms
	INSERT	165,094	32s195ms
	OTHERS	571,429	9s57ms
	SELECT	1,077,669	6m46s
	TCL	433,250	27s248ms
	UPDATE	64,183	2m31s
[unknown]	Total	5,026	680ms
	INSERT	47	27ms
	OTHERS	1,511	60ms
	SELECT	3,332	573ms
	TCL	136	18ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2019-06-12 14:29:55 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,263,793 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,263,793	97.50%
1-5ms	46,924	2.02%
5-10ms	3,350	0.14%
10-25ms	4,348	0.19%
25-50ms	2,677	0.12%
50-100ms	319	0.01%
100-500ms	294	0.01%
500-1000ms	10	0.00%
1000-10000ms	12	0.00%
> 10000ms	1	0.00%

Slowest individual queries


[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 12:31:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 09:37:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 08:55:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 13:39:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:54:49 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 06:09:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 08:44:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 15:19:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-06-12 09:42:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	52s627ms	UPDATE ORDER_ROUNDS SET routeNumber = '9468804', uploadedByUserId = '4061', uploadedByUserName = 'Beverley Mitchell', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, status = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2019-06-13', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2019-06-12 06:45:38.983', lastRxCompletedBy = '4061', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '473', dlxPickedLinesQty = '175', flowReport = '200543932', CREATED = '2019-06-12 05:56:59.394', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200581442'; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	7s868ms	UPDATE ORDER_ROUNDS SET routeNumber = '9468804', uploadedByUserId = '4061', uploadedByUserName = 'Beverley Mitchell', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, status = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2019-06-13', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2019-06-12 08:51:24.568', lastRxCompletedBy = '4', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '473', dlxPickedLinesQty = '0', flowReport = '200543932', CREATED = '2019-06-12 05:56:59.394', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200581442'; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	6s897ms	UPDATE FLOW_REPORTS SET routeNumber = '9468871', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.841', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:22.35', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544112'; [ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	5s896ms	UPDATE FLOW_REPORTS SET routeNumber = '9468871', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.841', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:22.35', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544112'; [ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	5s301ms	UPDATE FLOW_REPORTS SET routeNumber = '9468871', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.841', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:22.35', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544112'; [ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	4s867ms	UPDATE ORDER_ROUNDS SET routeNumber = '9468804', uploadedByUserId = '4061', uploadedByUserName = 'Beverley Mitchell', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, status = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2019-06-13', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2019-06-12 06:45:38.983', lastRxCompletedBy = '4061', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '473', dlxPickedLinesQty = '175', flowReport = '200543932', CREATED = '2019-06-12 05:56:59.394', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200581442'; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	4s2ms	UPDATE FLOW_REPORTS SET routeNumber = '9468871', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.841', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:22.35', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544112'; [ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	3s276ms	UPDATE FLOW_REPORTS SET routeNumber = '9468871', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.841', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:22.35', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544112'; [ Date: 2019-06-12 06:09:28 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	2s131ms	UPDATE FLOW_REPORTS SET routeNumber = '9468872', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.613', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:49.073', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544122'; [ Date: 2019-06-12 06:09:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	1s821ms	UPDATE FLOW_REPORTS SET routeNumber = '9468805', roundDeliveryDate = '2019-06-13', distributionPoint = 'F Loncol', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-06-12 12:31:28.492', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-06-12 12:09:39', failedTargetPickTime = 't', actualPaperworkCompleteTime = '2019-06-12 08:52:39.666', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 13:00:20.887', UPDATED = '2019-06-12 12:31:28.515', note = NULL WHERE FLOW_REPORT_ID = '200543942'; [ Date: 2019-06-12 12:31:39 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	1s692ms	UPDATE FLOW_REPORTS SET routeNumber = '9468872', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:12.613', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:49.073', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544122'; [ Date: 2019-06-12 06:09:31 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1s459ms	UPDATE FLOW_REPORTS SET routeNumber = '9468789', roundDeliveryDate = '2019-06-13', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-06-12 00:09:50', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-06-12 08:38:50.56', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 10:30:04.814', UPDATED = '2019-06-12 09:36:56.54', note = NULL WHERE FLOW_REPORT_ID = '200543782'; [ Date: 2019-06-12 09:37:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	1s341ms	UPDATE FLOW_REPORTS SET routeNumber = '9468797', roundDeliveryDate = '2019-06-13', distributionPoint = 'Ed Didcott', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 08:44:46.734', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 11:00:21.518', UPDATED = '2019-06-12 08:55:00.228', note = NULL WHERE FLOW_REPORT_ID = '200543862'; [ Date: 2019-06-12 08:55:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	919ms	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 '2019-06-01' AND '2019-06-30'; [ Date: 2019-06-12 13:39:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	857ms	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 '2019-06-01' AND '2019-06-30'; [ Date: 2019-06-12 06:54:49 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	816ms	UPDATE ORDER_ROUNDS SET routeNumber = '9468804', uploadedByUserId = '4061', uploadedByUserName = 'Beverley Mitchell', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, status = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2019-06-13', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'F Loncol', audited = '2019-06-12 08:51:31.627', auditedBy = '4', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2019-06-12 06:45:38.983', lastRxCompletedBy = '4061', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '473', dlxPickedLinesQty = '0', flowReport = '200543932', CREATED = '2019-06-12 05:56:59.394', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200581442'; [ Date: 2019-06-12 08:51:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	702ms	UPDATE FLOW_REPORTS SET routeNumber = '9468869', roundDeliveryDate = '2019-06-13', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-06-12 06:05:13.328', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-06-12 12:00:51.948', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200544102'; [ Date: 2019-06-12 06:09:17 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	554ms	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 = '11511918'; [ Date: 2019-06-12 08:44:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	553ms	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 = '5004871247'; [ Date: 2019-06-12 15:19:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	539ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '214507362'; [ Date: 2019-06-12 09:42:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1m5s - Times executed: 194 ]
[ User: pharmisight - Total duration: 1m5s - Times executed: 2078 ]
[ User: pharmisight - Total duration: 33s268ms - Times executed: 53928 ]
[ User: pharmisight - Total duration: 30s623ms - Times executed: 62 ]
[ User: symmetricds - Total duration: 19s360ms - Times executed: 186224 ]
[ User: pharmisight - Total duration: 25s758ms - Times executed: 146 ]
[ User: pharmisight - Total duration: 24s174ms - Times executed: 8312 ]
[ User: pharmisight - Total duration: 23s876ms - Times executed: 2078 ]
[ User: pharmisight - Total duration: 17s353ms - Times executed: 104 ]
[ User: pharmisight - Total duration: 16s200ms - Times executed: 64225 ]
[ User: pharmisight - Total duration: 13s936ms - Times executed: 223 ]
[ User: pharmisight - Total duration: 13s421ms - Times executed: 533 ]
[ User: pharmisight - Total duration: 12s699ms - Times executed: 666 ]
[ User: pharmisight - Total duration: 12s484ms - Times executed: 503 ]
[ User: symmetricds - Total duration: 9s564ms - Times executed: 17167 ]
[ User: pharmisight - Total duration: 8s724ms - Times executed: 13434 ]
[ User: symmetricds - Total duration: 8s439ms - Times executed: 530112 ]
[ User: pharmisight - Total duration: 8s241ms - Times executed: 2196 ]
[ User: pharmisight - Total duration: 7s753ms - Times executed: 81076 ]
[ User: symmetricds - Total duration: 6s670ms - Times executed: 124687 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 8s439ms - Times executed: 530112 ]
[ User: symmetricds - Total duration: 2s374ms - Times executed: 217613 ]
[ User: symmetricds - Total duration: 1s194ms - Times executed: 186224 ]
[ User: symmetricds - Total duration: 19s360ms - Times executed: 186224 ]
[ User: symmetricds - Total duration: 6s670ms - Times executed: 124687 ]
[ User: pharmisight - Total duration: 7s753ms - Times executed: 81076 ]
[ User: pharmisight - Total duration: 3s132ms - Times executed: 71359 ]
[ User: pharmisight - Total duration: 16s200ms - Times executed: 64225 ]
[ User: pharmisight - Total duration: 33s268ms - Times executed: 53928 ]
[ User: pharmisight - Total duration: 2s898ms - Times executed: 53217 ]
[ User: pharmisight - Total duration: 2s595ms - Times executed: 50926 ]
[ User: pharmisight - Total duration: 1s571ms - Times executed: 32892 ]
[ User: symmetricds - Total duration: 1s269ms - Times executed: 26336 ]
[ User: pharmisight - Total duration: 1s14ms - Times executed: 23706 ]
[ User: pharmisight - Total duration: 535ms - Times executed: 22877 ]
[ User: symmetricds - Total duration: 1s156ms - Times executed: 22264 ]
[ User: symmetricds - Total duration: 249ms - Times executed: 19611 ]
[ User: symmetricds - Total duration: 294ms - Times executed: 19611 ]
[ User: symmetricds - Total duration: 466ms - Times executed: 17264 ]
[ User: symmetricds - Total duration: 9s564ms - Times executed: 17167 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 30s623ms - Times executed: 62 ]
[ User: pharmisight - Total duration: 1m5s - Times executed: 194 ]
[ User: pharmisight - Total duration: 25s758ms - Times executed: 146 ]
[ User: pharmisight - Total duration: 17s353ms - Times executed: 104 ]
[ User: pharmisight - Total duration: 13s936ms - Times executed: 223 ]
[ User: pharmisight - Total duration: 1m5s - Times executed: 2078 ]
[ User: pharmisight - Total duration: 13s421ms - Times executed: 533 ]
[ User: pharmisight - Total duration: 12s484ms - Times executed: 503 ]
[ User: pharmisight - Total duration: 12s699ms - Times executed: 666 ]
[ User: pharmisight - Total duration: 23s876ms - Times executed: 2078 ]
[ User: pharmisight - Total duration: 8s241ms - Times executed: 2196 ]
[ User: pharmisight - Total duration: 24s174ms - Times executed: 8312 ]
[ User: pharmisight - Total duration: 8s724ms - Times executed: 13434 ]
[ User: pharmisight - Total duration: 33s268ms - Times executed: 53928 ]
[ User: symmetricds - Total duration: 9s564ms - Times executed: 17167 ]
[ User: pharmisight - Total duration: 16s200ms - Times executed: 64225 ]
[ User: symmetricds - Total duration: 19s360ms - Times executed: 186224 ]
[ User: pharmisight - Total duration: 7s753ms - Times executed: 81076 ]
[ User: pharmisight - Total duration: 2s898ms - Times executed: 53217 ]
[ User: symmetricds - Total duration: 6s670ms - Times executed: 124687 ]

Log levels

Key values

7,576,177 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	28	0.00%
DETAIL	1,986,993	26.23%
ERROR	17	0.00%
FATAL	3	0.00%
LOG	5,589,100	73.77%
STATEMENT	36	0.00%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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


Date: 2019-06-12 06:09:26
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2019-06-12 06:09:27
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2019-06-12 12:02:23
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.240
Code: 
Date: 2019-06-12 12:02:23
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.240
Code: 
Date: 2019-06-12 12:02:23
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.240
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

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values