pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jun 29 00:00:47 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 14,937,249 log entries in 45s
Log start from 2018-06-28 00:00:00 to 2018-06-28 23:59:58

Global Stats

1,234 Number of unique normalized queries
4,385,235 Number of queries
2h21m54s Total query duration
2018-06-28 00:00:00 First query
2018-06-28 23:59:58 Last query
10,399 queries/s at 2018-06-28 05:59:48 Query peak

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

463 Total number of automatic vacuums
571 Total number of automatic analyzes

3 Number temporary file
10.94 MiB Max size of temporary file
10.82 MiB Average size of temporary file

2,372 Total number of sessions
3 sessions at 2018-06-28 14:14:01 Session peak
16d3h4m46s Total duration of sessions
9m47s Average duration of sessions
1,848 Average queries per session
3s589ms Average queries duration per session

2,372 Total number of connections
30 connections/s at 2018-06-28 12:10:11 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,399 queries/s Query Peak
2018-06-28 05:59:48 Date

SELECT Traffic

Key values

1,904 queries/s Query Peak
2018-06-28 15:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,335 queries/s Query Peak
2018-06-28 05:59:48 Date

Queries duration

Key values

2h21m54s Total query duration

Prepared queries ratio

Key values

2.56 Ratio of bind vs prepare
128.83 % 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 28	00	105,314	0ms	58ms	0ms	88ms	240ms	1s849ms
	01	95,913	0ms	34ms	0ms	72ms	293ms	437ms
	02	95,025	0ms	22ms	0ms	70ms	257ms	431ms
	03	94,416	0ms	21ms	0ms	69ms	203ms	392ms
	04	93,884	0ms	21ms	0ms	66ms	170ms	342ms
	05	190,777	0ms	69ms	0ms	3s299ms	4s425ms	6s728ms
	06	388,933	0ms	3m40s	11ms	3m49s	8m24s	20m56s
	07	249,731	0ms	218ms	0ms	3s185ms	3s794ms	4s855ms
	08	218,758	0ms	252ms	0ms	2s649ms	3s497ms	4s233ms
	09	207,966	0ms	1s607ms	0ms	3s777ms	4s293ms	5s440ms
	10	294,077	0ms	14s390ms	0ms	5s81ms	6s955ms	42s468ms
	11	347,603	0ms	41s410ms	1ms	6s450ms	7s786ms	5m59s
	12	364,180	0ms	15s529ms	0ms	5s335ms	5s849ms	34s790ms
	13	358,883	0ms	2m17s	5ms	8s628ms	1m56s	21m3s
	14	281,806	0ms	1m2s	3ms	6s589ms	9s244ms	9m
	15	180,589	0ms	281ms	0ms	2s392ms	2s677ms	3s533ms
	16	148,520	0ms	4s519ms	0ms	2s703ms	4s609ms	10s311ms
	17	105,610	0ms	247ms	0ms	644ms	1s309ms	2s636ms
	18	92,280	0ms	19ms	0ms	67ms	86ms	366ms
	19	92,566	0ms	14ms	0ms	70ms	89ms	323ms
	20	94,865	0ms	26ms	0ms	70ms	163ms	570ms
	21	92,267	0ms	16ms	0ms	71ms	75ms	303ms
	22	94,313	0ms	18ms	0ms	68ms	255ms	371ms
	23	96,959	0ms	19ms	0ms	72ms	403ms	570ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 28	00	35,706	0ms	33ms	41ms	188ms
	01	31,575	0ms	33ms	42ms	68ms
	02	31,321	0ms	33ms	38ms	61ms
	03	31,214	0ms	33ms	38ms	61ms
	04	31,130	0ms	29ms	36ms	55ms
	05	61,623	0ms	35ms	311ms	1s67ms
	06	225,358	0ms	3s126ms	4s129ms	5s655ms
	07	120,539	0ms	1s924ms	2s677ms	3s542ms
	08	109,934	0ms	1s988ms	2s220ms	3s486ms
	09	102,576	0ms	2s121ms	3s392ms	4s880ms
	10	175,766	0ms	3s412ms	4s405ms	5s977ms
	11	230,180	0ms	3s664ms	5s128ms	7s351ms
	12	243,994	0ms	4s41ms	4s868ms	5s457ms
	13	238,887	0ms	3s641ms	5s22ms	7s60ms
	14	192,193	0ms	3s282ms	5s696ms	8s340ms
	15	94,337	0ms	1s603ms	2s176ms	2s581ms
	16	74,236	0ms	1s505ms	2s473ms	3s419ms
	17	39,901	0ms	289ms	582ms	1s170ms
	18	30,766	0ms	30ms	36ms	59ms
	19	30,922	0ms	32ms	35ms	64ms
	20	33,327	0ms	32ms	36ms	190ms
	21	30,746	0ms	33ms	35ms	57ms
	22	31,196	0ms	32ms	35ms	59ms
	23	31,725	0ms	28ms	34ms	66ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 28	00	1,917	2,082	113	0ms	12ms	15ms	91ms
	01	2,237	1,161	114	0ms	2ms	8ms	158ms
	02	1,684	1,022	114	0ms	1ms	9ms	113ms
	03	1,376	945	114	0ms	1ms	9ms	87ms
	04	960	841	114	0ms	2ms	8ms	69ms
	05	41,183	12,076	169	0ms	11ms	1s22ms	2s158ms
	06	37,662	16,020	582	77ms	504ms	31s611ms	8m19s
	07	15,713	8,343	409	0ms	361ms	453ms	541ms
	08	11,875	6,627	372	0ms	218ms	316ms	416ms
	09	11,537	6,400	361	0ms	182ms	256ms	372ms
	10	15,347	7,824	387	2ms	245ms	318ms	2s749ms
	11	14,255	7,763	381	19ms	218ms	333ms	504ms
	12	15,991	9,701	390	1ms	215ms	291ms	449ms
	13	17,197	8,480	404	67ms	229ms	260ms	1m53s
	14	6,359	4,222	265	79ms	103ms	151ms	369ms
	15	5,275	3,885	280	0ms	88ms	128ms	208ms
	16	2,180	2,114	191	3ms	39ms	87ms	249ms
	17	812	1,110	141	0ms	9ms	31ms	82ms
	18	108	614	115	0ms	1ms	8ms	10ms
	19	134	635	115	0ms	1ms	8ms	17ms
	20	157	639	121	0ms	1ms	8ms	34ms
	21	108	614	116	0ms	1ms	8ms	11ms
	22	1,236	910	115	0ms	1ms	9ms	61ms
	23	3,015	1,354	114	0ms	1ms	9ms	211ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jun 28	00	61,307	105,278	1.72	91.63%
	01	57,061	95,877	1.68	95.83%
	02	56,070	94,989	1.69	95.62%
	03	55,806	94,380	1.69	96.05%
	04	55,564	93,848	1.69	96.60%
	05	73,197	190,741	2.61	50.01%
	06	104,748	387,574	3.70	31.20%
	07	92,978	249,695	2.69	47.09%
	08	80,249	218,697	2.73	46.23%
	09	78,425	207,885	2.65	47.77%
	10	93,512	294,041	3.14	37.74%
	11	97,331	347,553	3.57	32.26%
	12	95,790	364,144	3.80	30.13%
	13	97,534	358,847	3.68	31.16%
	14	82,824	281,754	3.40	34.40%
	15	73,422	180,537	2.46	52.69%
	16	66,234	148,470	2.24	60.41%
	17	59,104	105,544	1.79	86.32%
	18	54,982	92,230	1.68	98.18%
	19	55,113	92,530	1.68	98.02%
	20	54,984	94,829	1.72	93.86%
	21	54,854	92,231	1.68	98.02%
	22	55,684	94,277	1.69	96.12%
	23	55,949	96,923	1.73	92.28%

Day	Hour	Count	Average / Second
Jun 28	00	73	0.02/s
	01	81	0.02/s
	02	61	0.02/s
	03	58	0.02/s
	04	64	0.02/s
	05	56	0.02/s
	06	131	0.04/s
	07	66	0.02/s
	08	66	0.02/s
	09	97	0.03/s
	10	143	0.04/s
	11	202	0.06/s
	12	188	0.05/s
	13	217	0.06/s
	14	181	0.05/s
	15	108	0.03/s
	16	89	0.02/s
	17	73	0.02/s
	18	62	0.02/s
	19	68	0.02/s
	20	70	0.02/s
	21	74	0.02/s
	22	71	0.02/s
	23	73	0.02/s

Day	Hour	Count	Average Duration
Jun 28	00	73	7m57s
	01	81	7m53s
	02	60	8m55s
	03	59	11m15s
	04	64	9m24s
	05	56	9m26s
	06	128	11m22s
	07	69	11m
	08	65	10m51s
	09	83	10m47s
	10	143	9m2s
	11	191	10m30s
	12	194	11m28s
	13	194	11m46s
	14	223	9m23s
	15	109	8m37s
	16	89	8m47s
	17	73	8m7s
	18	62	9m51s
	19	68	8m53s
	20	70	8m51s
	21	74	8m1s
	22	71	8m44s
	23	73	8m1s

↑ Back to the top of the General Activity table

Established Connections

Key values

30 connections Connection Peak
2018-06-28 12:10:11 Date

Connections per database

Key values

pharmisight Main Database
2,372 connections Total

Chart
Table

Database	User	Count
pharmisight		2,372
	pharmisight	1,232
	symmetricds	852
	tony	288

Connections per user

Key values

pharmisight Main User
2,372 connections Total

Chart
Table

User	Count
pharmisight	1,232
symmetricds	852
tony	288

Connections per host

Key values

10.10.10.1 Main host with 2084 connections
2,372 Total connections

Chart
Table

Host	Count
10.10.10.1	2,084
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2018-06-28 14:14:01 Date

Histogram of session times

Key values

1,286 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	289	12.18%
500ms-1s	0	0.00%
1s-30s	9	0.38%
30s-1m	0	0.00%
1m-10m	1,286	54.22%
10m-30m	724	30.52%
30m-1h	54	2.28%
1h-8h	10	0.42%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,372 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,372	16d3h4m46s	9m47s

Sessions per user

Key values

pharmisight Main User
2,372 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	1,232	11d2h12m46s
symmetricds	852	5d51m44s
tony	288	15s774ms

Sessions per host

Key values

10.10.10.1 Main Host
2,372 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	2,084	16d3h4m30s	11m8s
::1	288	15s774ms	54ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,372 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	2,075	16d3h3m29s	11m11s
[unknown]	297	1m16s	257ms

Checkpoints Buffers

Key values

4,385 buffers Checkpoint Peak
2018-06-28 07:07:24 Date
150.039 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2018-06-28 06:07:23 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
Jun 28	00	1,837	184.24s	0.023s	184.304s
	01	1,028	103.16s	0.017s	103.222s
	02	1,040	104.36s	0.014s	104.417s
	03	936	93.719s	0.015s	93.779s
	04	869	87.196s	0.015s	87.253s
	05	4,126	215.362s	0.023s	215.462s
	06	12,863	996.389s	0.029s	996.463s
	07	11,811	925.665s	0.045s	925.752s
	08	6,039	611.686s	0.022s	611.755s
	09	5,911	619.03s	0.03s	619.102s
	10	8,447	731.432s	0.019s	731.488s
	11	7,316	758.61s	0.04s	758.693s
	12	8,268	842.654s	0.018s	842.727s
	13	8,226	862.877s	0.021s	862.944s
	14	4,474	470.884s	0.012s	470.94s
	15	3,775	384.671s	0.021s	384.739s
	16	2,197	219.898s	0.018s	219.965s
	17	1,528	153.277s	0.019s	153.343s
	18	618	61.994s	0.015s	62.053s
	19	688	69.021s	0.012s	69.079s
	20	627	62.901s	0.024s	62.986s
	21	691	69.314s	0.011s	69.368s
	22	1,049	105.137s	0.018s	105.193s
	23	1,279	128.328s	0.01s	128.38s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jun 28	00	0	0	0	393	0.006s	0s
	01	0	0	1	342	0.002s	0s
	02	0	0	0	348	0.002s	0s
	03	0	0	0	330	0.002s	0s
	04	0	0	1	339	0.002s	0s
	05	1	0	0	408	0.002s	0s
	06	0	2	11	1,366	0.002s	0s
	07	0	3	2	1,250	0.015s	0s
	08	0	0	3	1,149	0.002s	0s
	09	0	0	2	1,166	0.002s	0s
	10	0	0	3	1,289	0.001s	0s
	11	0	0	3	1,222	0.018s	0s
	12	0	0	3	1,289	0.001s	0s
	13	0	0	4	1,221	0.002s	0s
	14	0	0	2	1,116	0.001s	0s
	15	0	0	2	1,099	0.002s	0s
	16	0	0	1	877	0.006s	0s
	17	0	0	0	526	0.002s	0s
	18	0	0	0	305	0.002s	0s
	19	0	0	0	317	0.002s	0s
	20	0	0	1	312	0.008s	0s
	21	0	0	0	318	0.002s	0s
	22	0	0	0	356	0.002s	0s
	23	0	0	1	331	0.002s	0s

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

Day	Hour	Mean distance	Mean estimate
Jun 28	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

21.80 MiB Temp Files size Peak
2018-06-28 06:00:33 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-06-28 06:00:33 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 28	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	1	10.66 MiB	10.66 MiB
	06	2	21.80 MiB	10.90 MiB
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	1	10.86 MiB	10.86 MiB	10.86 MiB	10.86 MiB	sanderson park cleator moor cumbria '' ca25 0jz '' 0 - 10 - 09 '' 0 '' 0 '' 0 - 10 - 08 '' 0 - 10 - 09 '' dr '' fiona c '' ironside '' lowther medical centre '' 0 castle meadows whitehaven cumbria '' ca28 0rg '' 0 '' 0 - 06 - 27 '' f '' 0 - 06 - 28 0:0:0 '' 0 - 06 - 28 0:0:0 '' f64fc4 - a82041 - 2625az '' 0 '' f456bb83 - 2e7f - 40f3 - b925 - 863d983c5ef1; Sanderson Park Cleator Moor Cumbria ', $6 = ' CA25 5JZ ', $7 = ' 1997 - 10 - 09 ', $8 = ' 1 ', $9 = ' 6007590011 ', $10 = ' 2013 - 10 - 08 ', $11 = ' 2057 - 10 - 09 ', $12 = ' Dr ', $13 = ' Fiona C ', $14 = ' Ironside ', $15 = ' Lowther Medical Centre ', $16 = ' 1 Castle Meadows Whitehaven Cumbria ', $17 = ' CA28 7RG ', $18 = ' 2 ', $19 = ' 2018 - 06 - 27 ', $20 = ' f ', $21 = ' 2018 - 06 - 28 06:00:02 ', $22 = ' 2018 - 06 - 28 06:00:02 ', $23 = NULL, $24 = ' F64FC4 - A82041 - 2625AZ ', $25 = NULL, $26 = ' 0 ', $27 = ' f456bb83 - 2e7f - 40f3 - b925 - 863d983c5ef1; Date: 2018-06-28 06:00:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files

Rank	Size	Query
1	10.86 MiB	Sanderson Park Cleator Moor Cumbria ', $6 = ' CA25 5JZ ', $7 = ' 1997 - 10 - 09 ', $8 = ' 1 ', $9 = ' 6007590011 ', $10 = ' 2013 - 10 - 08 ', $11 = ' 2057 - 10 - 09 ', $12 = ' Dr ', $13 = ' Fiona C ', $14 = ' Ironside ', $15 = ' Lowther Medical Centre ', $16 = ' 1 Castle Meadows Whitehaven Cumbria ', $17 = ' CA28 7RG ', $18 = ' 2 ', $19 = ' 2018 - 06 - 27 ', $20 = ' f ', $21 = ' 2018 - 06 - 28 06:00:02 ', $22 = ' 2018 - 06 - 28 06:00:02 ', $23 = NULL, $24 = ' F64FC4 - A82041 - 2625AZ ', $25 = NULL, $26 = ' 0 ', $27 = ' f456bb83 - 2e7f - 40f3 - b925 - 863d983c5ef1; [ Date: 2018-06-28 06:00:33 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Vacuums / Analyzes Distribution

Key values

15.11 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight
2018-06-28 06:01:01 Date
7.68 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-06-28 06:14:54 Date

Analyzes per table

Key values

public.sym_node_communication (208) Main table analyzed (database pharmisight)
571 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	208
pharmisight.public.sym_data_gap	109
pharmisight.public.sym_sequence	106
pharmisight.public.sym_outgoing_batch	60
pharmisight.public.sym_node_channel_ctl	26
pharmisight.public.sym_incoming_batch	13
pharmisight.public.sym_data	13
pharmisight.public.sym_lock	12
pharmisight.public.sym_data_event	12
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	2
pharmisight.public.tablets	1
pharmisight.public.item_notes	1
pharmisight.public.eps_header	1
pharmisight.public.users	1
Total	571

Vacuums per table

Key values

public.sym_node_communication (206) Main table vacuumed on database pharmisight
463 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	206	0
pharmisight.public.sym_sequence	109	0
pharmisight.public.sym_data_gap	58	58
pharmisight.public.sym_outgoing_batch	28	28
pharmisight.public.sym_node_channel_ctl	26	0
pharmisight.public.sym_lock	11	0
pharmisight.public.sym_incoming_batch	6	6
pharmisight.public.sym_node_host	5	0
pharmisight.pg_catalog.pg_statistic	4	4
pharmisight.public.sym_data	4	4
pharmisight.public.sym_data_event	3	3
pharmisight.pg_toast.pg_toast_2619	3	3
Total	463	106

Tuples removed per table

Key values

public.sym_data_event (12700) Main table with removed tuples on database pharmisight
48008 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_event	3	3	12700	0
pharmisight.public.sym_node_communication	206	0	11480	0
pharmisight.public.sym_outgoing_batch	28	28	6494	0
pharmisight.public.sym_sequence	109	0	5905	0
pharmisight.public.sym_data	4	4	3543	0
pharmisight.public.sym_data_gap	58	58	3122	1
pharmisight.public.sym_node_channel_ctl	26	0	1392	0
pharmisight.public.sym_incoming_batch	6	6	1207	0
pharmisight.pg_catalog.pg_statistic	4	4	1132	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	201	0
Total	463	106	48,008	1

Pages removed per table

Key values

public.sym_data_gap (1) Main table with removed pages on database pharmisight
1 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_data_gap	58	58	3122	1
pharmisight.public.sym_data_event	3	3	12700	0
pharmisight.public.sym_incoming_batch	6	6	1207	0
pharmisight.public.sym_outgoing_batch	28	28	6494	0
pharmisight.pg_catalog.pg_statistic	4	4	1132	0
pharmisight.pg_toast.pg_toast_2619	3	3	201	0
pharmisight.public.sym_sequence	109	0	5905	0
pharmisight.public.sym_node_communication	206	0	11480	0
pharmisight.public.sym_lock	11	0	572	0
pharmisight.public.sym_node_channel_ctl	26	0	1392	0
pharmisight.public.sym_node_host	5	0	260	0
pharmisight.public.sym_data	4	4	3543	0
Total	463	106	48,008	1

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jun 28	00	12	12
	01	9	13
	02	11	14
	03	9	10
	04	12	11
	05	14	15
	06	35	48
	07	35	42
	08	29	39
	09	30	39
	10	33	42
	11	31	40
	12	33	43
	13	34	42
	14	23	29
	15	22	30
	16	16	18
	17	13	15
	18	11	11
	19	9	12
	20	11	10
	21	11	13
	22	11	12
	23	9	11

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
548 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		238	56m46s	14s314ms
	tuple	238	56m46s	14s314ms
ShareLock		310	1h5m14s	12s628ms
	transaction	310	1h5m14s	12s628ms
	Total	548	2h2m1s	13s360ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	511	1h55m26s	1s5ms	2m21s	13s555ms	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, 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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; Date: 2018-06-28 16:32:11 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	37	6m34s	2s113ms	25s390ms	10s669ms	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: 2018-06-28 14:01:21 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-06-28 06:15:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	2m21s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:15:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	1m28s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	1m28s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	1m24s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	1m14s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	1m14s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	1m13s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	1m12s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	1m12s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	1m10s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	1m9s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	1m9s	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:14:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	41s405ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	41s126ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	40s224ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	40s198ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	40s127ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 11:27:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	40s106ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	40s106ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	40s106ms	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, CREATED = $16, UPDATED = $17, note = $18 WHERE FLOW_REPORT_ID = $19; [ Date: 2018-06-28 06:12:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

2,259,152 Total read queries
1,142,829 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	2,259,152	51.52%
INSERT	208,318	4.75%
UPDATE	105,382	2.40%
DELETE	5,597	0.13%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	823,531	18.78%
OTHERS	983,254	22.42%

Queries by database

Key values

pharmisight Main database
4,385,235 Requests
2h21m54s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	4,385,235	2h21m54s
	DDL	1	58ms
	DELETE	5,597	7s997ms
	INSERT	208,318	46s850ms
	OTHERS	983,254	17s823ms
	SELECT	2,259,152	16m14s
	TCL	823,531	37s384ms
	UPDATE	105,382	2h3m50s

Queries by user

Key values

symmetricds Main user
2,891,419 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,588,311	2h19m54s
	DELETE	33	625ms
	INSERT	32,183	35s703ms
	OTHERS	3,750	121ms
	SELECT	1,412,654	15m31s
	TCL	92,302	9s115ms
	UPDATE	47,389	2h3m37s
symmetricds	Total	2,891,419	1m58s
	DDL	1	58ms
	DELETE	5,635	7s379ms
	INSERT	178,417	11s530ms
	OTHERS	1,015,756	18s386ms
	SELECT	876,790	39s829ms
	TCL	755,617	28s693ms
	UPDATE	59,203	12s766ms
tony	Total	900	4s659ms
	SELECT	900	4s659ms

Duration by user

Key values

2h19m54s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,588,311	2h19m54s
	DELETE	33	625ms
	INSERT	32,183	35s703ms
	OTHERS	3,750	121ms
	SELECT	1,412,654	15m31s
	TCL	92,302	9s115ms
	UPDATE	47,389	2h3m37s
symmetricds	Total	2,891,419	1m58s
	DDL	1	58ms
	DELETE	5,635	7s379ms
	INSERT	178,417	11s530ms
	OTHERS	1,015,756	18s386ms
	SELECT	876,790	39s829ms
	TCL	755,617	28s693ms
	UPDATE	59,203	12s766ms
tony	Total	900	4s659ms
	SELECT	900	4s659ms

Queries by host

Key values

10.10.10.1 Main host
4,479,730 Requests
2h21m53s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	4,479,730	2h21m53s
	DDL	1	58ms
	DELETE	5,668	8s4ms
	INSERT	210,600	47s234ms
	OTHERS	1,019,506	18s507ms
	SELECT	2,289,444	16m11s
	TCL	847,919	37s808ms
	UPDATE	106,592	2h3m50s
::1	Total	900	4s659ms
	SELECT	900	4s659ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
4,380,799 Requests
2h21m49s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	4,380,799	2h21m49s
	DDL	1	58ms
	DELETE	5,597	7s997ms
	INSERT	208,281	46s806ms
	OTHERS	981,161	17s765ms
	SELECT	2,256,974	16m9s
	TCL	823,403	37s281ms
	UPDATE	105,382	2h3m50s
[unknown]	Total	4,436	5s296ms
	INSERT	37	44ms
	OTHERS	2,093	57ms
	SELECT	2,178	5s91ms
	TCL	128	102ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-06-28 08:29:18 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

4,253,034 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	4,253,034	96.99%
1-5ms	101,937	2.32%
5-10ms	7,621	0.17%
10-25ms	16,305	0.37%
25-50ms	5,038	0.11%
50-100ms	729	0.02%
100-500ms	290	0.01%
500-1000ms	3	0.00%
1000-10000ms	106	0.00%
> 10000ms	172	0.00%

Slowest individual queries


[ Date: 2018-06-28 06:15:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 06:14:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	3m40s	UPDATE FLOW_REPORTS SET routeNumber = '8980506', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:44.161', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:04.907', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404542'; [ Date: 2018-06-28 06:15:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	2m37s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	2m17s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	1m59s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	1m54s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	1m53s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	1m52s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	1m52s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	1m51s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	1m51s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	1m50s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1m50s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	1m49s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	1m49s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	1m49s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	1m48s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:15:20 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1m45s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	1m43s	UPDATE FLOW_REPORTS SET routeNumber = '8980507', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 06:03:43.648', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:48.73', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200404642'; [ Date: 2018-06-28 06:14:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	1m41s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	1m40s	UPDATE FLOW_REPORTS SET routeNumber = '8980508', roundDeliveryDate = '2018-06-29', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-06-28 12:58:03', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-06-28 11:49:00', changedPickDateTime = 'f', CREATED = '2018-06-28 12:00:59.97', UPDATED = '2018-06-28 12:12:16.01', note = NULL WHERE FLOW_REPORT_ID = '200404572'; [ Date: 2018-06-28 13:24:03 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1h55s - Times executed: 402 ]
[ User: pharmisight - Total duration: 26m42s - Times executed: 413 ]
[ User: pharmisight - Total duration: 9m15s - Times executed: 442 ]
[ User: pharmisight - Total duration: 6m50s - Times executed: 457 ]
[ User: pharmisight - Total duration: 5m37s - Times executed: 539 ]
[ User: pharmisight - Total duration: 4m39s - Times executed: 25 ]
[ User: pharmisight - Total duration: 3m9s - Times executed: 32 ]
[ User: pharmisight - Total duration: 2m42s - Times executed: 4295 ]
[ User: pharmisight - Total duration: 2m30s - Times executed: 224091 ]
[ User: pharmisight - Total duration: 1m34s - Times executed: 6 ]
[ User: pharmisight - Total duration: 1m13s - Times executed: 2564 ]
[ User: pharmisight - Total duration: 1m9s - Times executed: 4294 ]
[ User: pharmisight - Total duration: 1m1s - Times executed: 152 ]
[ User: pharmisight - Total duration: 1m1s - Times executed: 351 ]
[ User: pharmisight - Total duration: 1m - Times executed: 234901 ]
[ User: pharmisight - Total duration: 59s546ms - Times executed: 17184 ]
[ User: pharmisight - Total duration: 49s454ms - Times executed: 10449 ]
[ User: pharmisight - Total duration: 46s528ms - Times executed: 3 ]
[ User: pharmisight - Total duration: 41s930ms - Times executed: 2700 ]
[ User: symmetricds - Total duration: 25s914ms - Times executed: 365624 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 17s646ms - Times executed: 977863 ]
[ User: symmetricds - Total duration: 5s682ms - Times executed: 477413 ]
[ User: symmetricds - Total duration: 2s362ms - Times executed: 365623 ]
[ User: symmetricds - Total duration: 25s914ms - Times executed: 365624 ]
[ User: pharmisight - Total duration: 1m - Times executed: 234901 ]
[ User: pharmisight - Total duration: 2m30s - Times executed: 224091 ]
[ User: symmetricds - Total duration: 8s619ms - Times executed: 159177 ]
[ User: pharmisight - Total duration: 6s282ms - Times executed: 153042 ]
[ User: pharmisight - Total duration: 13s341ms - Times executed: 114319 ]
[ User: pharmisight - Total duration: 4s909ms - Times executed: 104528 ]
[ User: symmetricds - Total duration: 3s636ms - Times executed: 77045 ]
[ User: symmetricds - Total duration: 1s917ms - Times executed: 62351 ]
[ User: symmetricds - Total duration: 1s185ms - Times executed: 57312 ]
[ User: pharmisight - Total duration: 3s578ms - Times executed: 50560 ]
[ User: pharmisight - Total duration: 14s69ms - Times executed: 50555 ]
[ User: pharmisight - Total duration: 2s39ms - Times executed: 45886 ]
[ User: pharmisight - Total duration: 12s717ms - Times executed: 44221 ]
[ User: pharmisight - Total duration: 1s617ms - Times executed: 38148 ]
[ User: pharmisight - Total duration: 1s960ms - Times executed: 30683 ]
[ User: symmetricds - Total duration: 5s752ms - Times executed: 28497 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 1m34s - Times executed: 6 ]
[ User: pharmisight - Total duration: 46s528ms - Times executed: 3 ]
[ User: pharmisight - Total duration: 4m39s - Times executed: 25 ]
[ User: pharmisight - Total duration: 1h55s - Times executed: 402 ]
[ User: pharmisight - Total duration: 3m9s - Times executed: 32 ]
[ User: pharmisight - Total duration: 26m42s - Times executed: 413 ]
[ User: pharmisight - Total duration: 9m15s - Times executed: 442 ]
[ User: pharmisight - Total duration: 6m50s - Times executed: 457 ]
[ User: pharmisight - Total duration: 5m37s - Times executed: 539 ]
[ User: pharmisight - Total duration: 1m1s - Times executed: 152 ]
[ User: pharmisight - Total duration: 1m1s - Times executed: 351 ]
[ User: pharmisight - Total duration: 2m42s - Times executed: 4295 ]
[ User: pharmisight - Total duration: 1m13s - Times executed: 2564 ]
[ User: pharmisight - Total duration: 1m9s - Times executed: 4294 ]
[ User: pharmisight - Total duration: 41s930ms - Times executed: 2700 ]
[ User: pharmisight - Total duration: 49s454ms - Times executed: 10449 ]
[ User: pharmisight - Total duration: 59s546ms - Times executed: 17184 ]
[ User: pharmisight - Total duration: 2m30s - Times executed: 224091 ]
[ User: pharmisight - Total duration: 12s717ms - Times executed: 44221 ]
[ User: pharmisight - Total duration: 14s69ms - Times executed: 50555 ]

Log levels

Key values

14,531,668 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	632	0.00%
DETAIL	4,040,785	27.81%
ERROR	567	0.00%
HINT	8	0.00%
LOG	10,488,547	72.18%
STATEMENT	1,129	0.01%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
573 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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


Date: 2018-06-28 06:12:07
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-28 06:12:10
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-28 06:06:40
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-28 06:06:40
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-06-28 00:00:09
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
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

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