pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Apr 13 00:00:16 2019
Log file: /var/log/postgresql/postgresql-11-main.log.1
Parsed 7,651,791 log entries in 14s
Log start from 2019-04-12 00:00:03 to 2019-04-12 23:59:59

Global Stats

1,665 Number of unique normalized queries
2,280,233 Number of queries
9m15s Total query duration
2019-04-12 00:00:03 First query
2019-04-12 23:59:59 Last query
10,806 queries/s at 2019-04-12 06:05:17 Query peak

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

94 Total number of automatic vacuums
183 Total number of automatic analyzes

5 Number temporary file
10.30 MiB Max size of temporary file
6.18 MiB Average size of temporary file

2,132 Total number of sessions
3 sessions at 2019-04-12 11:03:18 Session peak
10d22h43m5s Total duration of sessions
7m23s Average duration of sessions
1,069 Average queries per session
260ms Average queries duration per session

2,132 Total number of connections
9 connections/s at 2019-04-12 11:18:33 Connection peak
1 Total number of databases

SQL Traffic

Key values

10,806 queries/s Query Peak
2019-04-12 06:05:17 Date

SELECT Traffic

Key values

2,024 queries/s Query Peak
2019-04-12 11:40:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

10,714 queries/s Query Peak
2019-04-12 06:05:17 Date

Queries duration

Key values

9m15s Total query duration

Prepared queries ratio

Key values

2.56 Ratio of bind vs prepare
129.66 % 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)
Apr 12	00	48,646	0ms	69ms	0ms	96ms	210ms	324ms
	01	43,174	0ms	69ms	0ms	76ms	172ms	297ms
	02	43,624	0ms	70ms	0ms	66ms	138ms	1s69ms
	03	41,971	0ms	70ms	0ms	66ms	84ms	273ms
	04	41,569	0ms	68ms	0ms	57ms	92ms	272ms
	05	49,410	0ms	1s162ms	0ms	150ms	266ms	3s785ms
	06	300,583	0ms	5s87ms	0ms	4s976ms	6s751ms	11s221ms
	07	145,220	0ms	177ms	0ms	1s105ms	1s461ms	1s806ms
	08	206,267	0ms	397ms	0ms	2s41ms	2s73ms	2s528ms
	09	156,077	0ms	1s800ms	0ms	2s214ms	2s693ms	3s983ms
	10	106,628	0ms	76ms	0ms	1s118ms	1s892ms	2s628ms
	11	198,038	0ms	74ms	0ms	2s376ms	3s803ms	4s316ms
	12	204,610	0ms	1s121ms	0ms	3s261ms	3s671ms	4s605ms
	13	100,992	0ms	144ms	0ms	1s276ms	1s568ms	2s417ms
	14	106,373	0ms	184ms	0ms	1s472ms	2s174ms	2s482ms
	15	85,622	0ms	5s23ms	0ms	1s318ms	2s362ms	15s672ms
	16	67,646	0ms	1s84ms	0ms	1s515ms	1s953ms	2s945ms
	17	51,196	0ms	210ms	0ms	683ms	1s324ms	2s340ms
	18	49,074	0ms	46ms	0ms	74ms	114ms	334ms
	19	44,941	0ms	41ms	0ms	56ms	86ms	258ms
	20	48,272	0ms	41ms	0ms	58ms	196ms	686ms
	21	45,847	0ms	43ms	0ms	57ms	115ms	357ms
	22	47,369	0ms	42ms	0ms	63ms	217ms	346ms
	23	47,084	0ms	41ms	0ms	59ms	215ms	329ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 12	00	16,607	0ms	26ms	37ms	114ms
	01	14,036	0ms	21ms	32ms	102ms
	02	15,113	0ms	27ms	40ms	115ms
	03	13,996	0ms	21ms	37ms	115ms
	04	13,839	0ms	21ms	34ms	115ms
	05	16,572	0ms	33ms	109ms	1s465ms
	06	151,536	0ms	2s402ms	3s317ms	4s119ms
	07	73,516	0ms	553ms	936ms	1s584ms
	08	107,442	0ms	1s454ms	1s779ms	2s242ms
	09	83,648	0ms	1s645ms	1s959ms	2s316ms
	10	53,429	0ms	160ms	992ms	1s846ms
	11	117,650	0ms	1s364ms	2s201ms	3s857ms
	12	124,560	0ms	1s797ms	2s950ms	3s492ms
	13	46,376	0ms	562ms	971ms	1s769ms
	14	51,892	0ms	759ms	1s249ms	2s272ms
	15	45,904	0ms	675ms	1s285ms	2s792ms
	16	34,734	0ms	612ms	1s502ms	2s817ms
	17	21,312	0ms	159ms	580ms	1s679ms
	18	16,487	0ms	25ms	35ms	83ms
	19	14,894	0ms	29ms	34ms	87ms
	20	17,716	0ms	27ms	36ms	169ms
	21	14,966	0ms	23ms	34ms	94ms
	22	15,212	0ms	27ms	33ms	97ms
	23	15,187	0ms	27ms	35ms	89ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 12	00	1,306	1,441	111	0ms	11ms	18ms	34ms
	01	1,578	445	111	0ms	2ms	7ms	47ms
	02	791	213	110	0ms	1ms	7ms	25ms
	03	707	153	110	0ms	1ms	7ms	35ms
	04	518	139	110	0ms	1ms	7ms	25ms
	05	3,769	1,650	112	0ms	1ms	7ms	150ms
	06	67,123	19,872	454	0ms	168ms	902ms	1s926ms
	07	15,494	5,076	387	0ms	96ms	127ms	160ms
	08	15,386	7,465	400	0ms	92ms	115ms	159ms
	09	11,075	4,385	359	0ms	80ms	100ms	512ms
	10	9,639	3,162	225	0ms	69ms	95ms	184ms
	11	17,993	6,685	336	0ms	105ms	131ms	194ms
	12	16,166	6,144	363	0ms	90ms	117ms	204ms
	13	8,772	3,105	247	0ms	63ms	92ms	139ms
	14	7,437	2,748	251	0ms	57ms	89ms	123ms
	15	2,259	1,017	166	4ms	23ms	38ms	90ms
	16	1,255	505	133	0ms	8ms	34ms	104ms
	17	592	297	122	0ms	5ms	16ms	79ms
	18	365	1,132	111	0ms	11ms	16ms	20ms
	19	141	102	112	0ms	1ms	6ms	11ms
	20	1,095	356	136	0ms	1ms	7ms	90ms
	21	748	245	112	0ms	1ms	7ms	44ms
	22	1,836	511	113	0ms	2ms	9ms	66ms
	23	1,600	452	111	0ms	1ms	7ms	64ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Apr 12	00	29,398	48,610	1.65	93.72%
	01	27,477	43,138	1.57	104.28%
	02	28,253	43,588	1.54	106.39%
	03	27,186	41,935	1.54	108.16%
	04	27,345	41,533	1.52	110.44%
	05	28,009	49,374	1.76	86.34%
	06	54,355	298,939	5.50	20.09%
	07	45,871	145,184	3.17	38.53%
	08	65,179	206,231	3.16	39.18%
	09	49,816	156,041	3.13	39.23%
	10	38,650	106,592	2.76	46.10%
	11	52,247	198,002	3.79	30.88%
	12	53,893	204,574	3.80	30.88%
	13	39,599	100,929	2.55	51.28%
	14	42,727	106,337	2.49	52.38%
	15	35,881	85,570	2.38	55.49%
	16	32,100	67,596	2.11	64.84%
	17	29,973	49,937	1.67	89.01%
	18	31,512	49,022	1.56	102.75%
	19	30,299	44,905	1.48	114.70%
	20	29,580	48,236	1.63	98.02%
	21	29,851	45,811	1.53	109.43%
	22	30,163	47,333	1.57	104.57%
	23	30,269	47,048	1.55	106.06%

Day	Hour	Count	Average / Second
Apr 12	00	99	0.03/s
	01	83	0.02/s
	02	88	0.02/s
	03	86	0.02/s
	04	86	0.02/s
	05	83	0.02/s
	06	88	0.02/s
	07	78	0.02/s
	08	62	0.02/s
	09	72	0.02/s
	10	79	0.02/s
	11	90	0.03/s
	12	100	0.03/s
	13	69	0.02/s
	14	82	0.02/s
	15	83	0.02/s
	16	99	0.03/s
	17	88	0.02/s
	18	105	0.03/s
	19	104	0.03/s
	20	111	0.03/s
	21	97	0.03/s
	22	99	0.03/s
	23	101	0.03/s

Day	Hour	Count	Average Duration
Apr 12	00	99	6m43s
	01	83	7m15s
	02	88	6m59s
	03	86	6m39s
	04	86	7m3s
	05	83	6m47s
	06	85	8m27s
	07	81	7m46s
	08	62	9m37s
	09	69	10m17s
	10	82	8m58s
	11	87	8m43s
	12	101	8m33s
	13	71	10m1s
	14	82	8m9s
	15	83	8m46s
	16	99	7m33s
	17	88	7m33s
	18	105	5m47s
	19	104	5m44s
	20	111	5m19s
	21	97	6m6s
	22	99	6m8s
	23	101	5m59s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2019-04-12 11:18:33 Date

Connections per database

Key values

pharmisight Main Database
2,132 connections Total

Chart
Table

Database	User	Count
pharmisight		2,132
	pharmisight	665
	symmetricds	1,179
	tony	288

Connections per user

Key values

symmetricds Main User
2,132 connections Total

Chart
Table

User	Count
pharmisight	665
symmetricds	1,179
tony	288

Connections per host

Key values

10.10.10.1 Main host with 1844 connections
2,132 Total connections

Chart
Table

Host	Count
10.10.10.1	1,844
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2019-04-12 11:03:18 Date

Histogram of session times

Key values

1,437 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	288	13.51%
500ms-1s	0	0.00%
1s-30s	6	0.28%
30s-1m	0	0.00%
1m-10m	1,437	67.40%
10m-30m	352	16.51%
30m-1h	45	2.11%
1h-8h	4	0.19%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,132 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,132	10d22h43m5s	7m23s

Sessions per user

Key values

symmetricds Main User
2,132 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	665	5d22h35m19s
symmetricds	1,179	5d7m34s
tony	288	11s921ms

Sessions per host

Key values

10.10.10.1 Main Host
2,132 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	1,844	10d22h42m53s	8m32s
::1	288	11s921ms	41ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,132 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,838	10d22h41m53s	8m34s
[unknown]	294	1m12s	244ms

Checkpoints Buffers

Key values

2,999 buffers Checkpoint Peak
2019-04-12 07:09:32 Date
149.951 seconds Highest write time
0.016 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2019-04-12 06:09:32 Date

Checkpoints distance

Key values

196.50 Mo Distance Peak
2019-04-12 06:09:32 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Apr 12	00	1,804	180.879s	0.015s	180.963s
	01	850	85.296s	0.007s	85.355s
	02	583	58.505s	0.014s	58.572s
	03	588	59.007s	0.014s	59.086s
	04	491	49.258s	0.013s	49.325s
	05	395	39.64s	0.023s	39.715s
	06	12,263	1,046.087s	0.038s	1,046.193s
	07	8,847	734.343s	0.02s	734.432s
	08	9,453	800.177s	0.022s	800.265s
	09	6,544	707.848s	0.015s	707.928s
	10	4,694	470.166s	0.016s	470.249s
	11	8,946	895.494s	0.022s	895.584s
	12	7,305	748.222s	0.04s	748.328s
	13	4,410	441.925s	0.016s	442.004s
	14	3,927	393.601s	0.017s	393.708s
	15	4,095	298.59s	0.019s	298.677s
	16	1,496	149.911s	0.019s	149.993s
	17	752	75.476s	0.012s	75.544s
	18	1,747	174.906s	0.02s	174.984s
	19	486	48.784s	0.01s	48.844s
	20	582	58.403s	0.008s	58.469s
	21	501	50.282s	0.013s	50.34s
	22	661	66.232s	0.007s	66.293s
	23	655	65.619s	0.011s	65.679s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Apr 12	00	0	1	342	0.002s	0s
	01	0	0	240	0.001s	0s
	02	0	0	236	0.002s	0s
	03	0	0	251	0.003s	0s
	04	0	0	194	0.002s	0s
	05	0	1	232	0.010s	0s
	06	1	12	1,330	0.001s	0s
	07	2	2	1,121	0.002s	0s
	08	0	4	1,178	0.002s	0s
	09	0	3	1,166	0.001s	0s
	10	0	2	804	0.002s	0s
	11	0	3	1,204	0.002s	0s
	12	0	3	1,320	0.009s	0s
	13	0	2	862	0.005s	0s
	14	0	2	860	0.001s	0s
	15	0	1	756	0.002s	0s
	16	0	0	531	0.002s	0s
	17	0	1	431	0.002s	0s
	18	0	0	297	0.008s	0s
	19	0	0	206	0.001s	0.001s
	20	0	1	238	0.001s	0s
	21	0	0	202	0.003s	0s
	22	0	0	213	0.001s	0.001s
	23	0	0	205	0.002s	0s

Day	Hour	Avg time (sec)
Apr 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
Apr 12	00	969.00 kB	1,463.75 kB
	01	485.10 kB	962.90 kB
	02	274.40 kB	619.00 kB
	03	242.42 kB	496.42 kB
	04	242.11 kB	462.44 kB
	05	151.50 kB	320.50 kB
	06	18,165.50 kB	64,486.83 kB
	07	6,072.18 kB	23,751.36 kB
	08	4,893.58 kB	11,063.33 kB
	09	3,938.42 kB	8,179.42 kB
	10	2,725.67 kB	6,932.67 kB
	11	4,660.08 kB	6,154.00 kB
	12	4,364.17 kB	6,324.83 kB
	13	1,966.20 kB	8,860.60 kB
	14	2,069.00 kB	4,163.25 kB
	15	781.73 kB	5,453.91 kB
	16	643.33 kB	2,228.25 kB
	17	409.40 kB	1,005.30 kB
	18	1,047.09 kB	1,995.18 kB
	19	232.50 kB	1,049.80 kB
	20	295.80 kB	705.30 kB
	21	270.89 kB	740.44 kB
	22	368.20 kB	1,005.30 kB
	23	389.44 kB	861.78 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

10.34 MiB Temp Files size Peak
2019-04-12 06:11:27 Date

Number of temporary files

Key values

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

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Apr 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	30.89 MiB	6.18 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	7.12 MiB	3.47 MiB	3.65 MiB	3.56 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-04-12 06:11:27 Duration: 0ms
2	1	10.26 MiB	10.26 MiB	10.26 MiB	10.26 MiB	burgess hill west sussex ? rh15 ? aw ? ? - 10 - 21 ? ? ? ? ? ? - 10 - 20 ? ? - 10 - 21 ? dr ? duncan l ? wells ? park VIEW health partnership ? sidney west PRIMARY care centre leylands road burgess hill west sussex ? rh15 ? hs ? ? ? ? - 04 - 11 ? f ? ? - 04 - 12 ? : ? : ? ? ? - 04 - 12 ? : ? : ? ? ? c9e49 - h82621 - 15fcfr ? ? ? ? ? ? ? f ? ? ba8e2 - 23b8 - 4f67 - 9ecb - d19a323dc6cc; Burgess Hill West Sussex ', $6 = ' RH15 8AW ', $7 = ' 2015 - 10 - 21 ', $8 = ' 1 ', $9 = ' 7140755302 ', $10 = ' 2031 - 10 - 20 ', $11 = ' 2075 - 10 - 21 ', $12 = ' Dr ', $13 = ' Duncan L ', $14 = ' Wells ', $15 = ' Park VIEW Health Partnership ', $16 = ' Sidney West PRIMARY Care Centre Leylands Road Burgess Hill West Sussex ', $17 = ' RH15 8HS ', $18 = ' 2 ', $19 = ' 2019 - 04 - 11 ', $20 = ' f ', $21 = ' 2019 - 04 - 12 06:05:03 ', $22 = ' 2019 - 04 - 12 06:05:03 ', $23 = NULL, $24 = ' 8C9E49 - H82621 - 15FCFR ', $25 = NULL, $26 = ' 0 ', $27 = ' 1 ', $28 = ' 1 ', $29 = NULL, $30 = ' f ', $31 = NULL, $32 = ' 036ba8e2 - 23b8 - 4f67 - 9ecb - d19a323dc6cc; Date: 2019-04-12 06:05:24 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.26 MiB	Burgess Hill West Sussex ', $6 = ' RH15 8AW ', $7 = ' 2015 - 10 - 21 ', $8 = ' 1 ', $9 = ' 7140755302 ', $10 = ' 2031 - 10 - 20 ', $11 = ' 2075 - 10 - 21 ', $12 = ' Dr ', $13 = ' Duncan L ', $14 = ' Wells ', $15 = ' Park VIEW Health Partnership ', $16 = ' Sidney West PRIMARY Care Centre Leylands Road Burgess Hill West Sussex ', $17 = ' RH15 8HS ', $18 = ' 2 ', $19 = ' 2019 - 04 - 11 ', $20 = ' f ', $21 = ' 2019 - 04 - 12 06:05:03 ', $22 = ' 2019 - 04 - 12 06:05:03 ', $23 = NULL, $24 = ' 8C9E49 - H82621 - 15FCFR ', $25 = NULL, $26 = ' 0 ', $27 = ' 1 ', $28 = ' 1 ', $29 = NULL, $30 = ' f ', $31 = NULL, $32 = ' 036ba8e2 - 23b8 - 4f67 - 9ecb - d19a323dc6cc; [ Date: 2019-04-12 06:05:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	3.65 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-04-12 06:11:27 ]
3	3.47 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-04-12 06:11:27 ]

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

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_data_gap	87
pharmisight.public.sym_outgoing_batch	38
pharmisight.public.sym_incoming_batch	18
pharmisight.public.sym_data	11
pharmisight.public.sym_data_event	11
pharmisight.public.sym_sequence	9
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	3
Total	183

Vacuums per table

Key values

public.sym_data_gap (45) Main table vacuumed on database pharmisight
94 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_data_gap	45	45
pharmisight.public.sym_outgoing_batch	17	17
pharmisight.public.sym_sequence	9	0
pharmisight.public.sym_incoming_batch	7	7
pharmisight.public.sym_node_host	5	0
pharmisight.public.sym_data	4	4
pharmisight.public.sym_data_event	3	3
pharmisight.pg_toast.pg_toast_2619	2	2
pharmisight.public.item_codes	1	1
pharmisight.pg_catalog.pg_statistic	1	1
Total	94	80

Tuples removed per table

Key values

public.sym_data_event (12330) Main table with removed tuples on database pharmisight
26619 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.sym_data_event	3	3	12330
pharmisight.public.sym_data	4	4	7751
pharmisight.public.sym_data_gap	45	45	2330
pharmisight.public.sym_outgoing_batch	17	17	1813
pharmisight.public.sym_incoming_batch	7	7	1041
pharmisight.public.sym_sequence	9	0	459
pharmisight.pg_catalog.pg_statistic	1	1	283
pharmisight.public.sym_node_host	5	0	261
pharmisight.public.item_codes	1	1	199
pharmisight.pg_toast.pg_toast_2619	2	2	152
Total	94	80	26,619

Pages removed per table

Key values

unknown (0) Main table with removed pages on database
0 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
pharmisight.public.item_codes	1	1	199
pharmisight.pg_toast.pg_toast_2619	2	2	152
pharmisight.public.sym_node_host	5	0	261
pharmisight.public.sym_data	4	4	7751
pharmisight.public.sym_sequence	9	0	459
pharmisight.public.sym_incoming_batch	7	7	1041
pharmisight.pg_catalog.pg_statistic	1	1	283
pharmisight.public.sym_data_event	3	3	12330
pharmisight.public.sym_data_gap	45	45	2330
pharmisight.public.sym_outgoing_batch	17	17	1813
Total	94	80	26,619

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
11 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		3	8s701ms	2s900ms
	tuple	3	8s701ms	2s900ms
ShareLock		8	17s523ms	2s190ms
	transaction	8	17s523ms	2s190ms
	Total	11	26s224ms	2s384ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	11	26s224ms	1s536ms	3s415ms	2s384ms	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-04-12 06:10:42 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2019-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 06:13:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 09:59:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 06:11:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2019-04-12 06:10:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	3s415ms	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-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	3s138ms	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-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	3s5ms	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-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	2s966ms	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-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	2s596ms	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-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	2s56ms	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-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	2s55ms	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-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	1s947ms	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-04-12 06:13:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	1s799ms	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-04-12 09:59:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	1s707ms	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-04-12 06:11:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	1s536ms	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-04-12 06:10:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

1,096,624 Total read queries
659,082 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,096,624	48.09%
INSERT	187,645	8.23%
UPDATE	67,300	2.95%
DELETE	4,802	0.21%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	399,335	17.51%
OTHERS	524,527	23.00%

Queries by database

Key values

pharmisight Main database
2,280,233 Requests
9m15s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	2,280,233	9m15s
	DELETE	4,802	7s363ms
	INSERT	187,645	30s249ms
	OTHERS	524,527	8s106ms
	SELECT	1,096,624	6m47s
	TCL	399,335	24s933ms
	UPDATE	67,300	1m16s

Queries by user

Key values

symmetricds Main user
1,426,435 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	852,934	7m42s
	DELETE	47	1s86ms
	INSERT	29,235	18s798ms
	OTHERS	1,989	73ms
	SELECT	718,581	6m6s
	TCL	61,572	7s225ms
	UPDATE	41,510	1m7s
symmetricds	Total	1,426,435	1m32s
	DELETE	4,755	6s277ms
	INSERT	158,410	11s451ms
	OTHERS	522,538	8s32ms
	SELECT	377,179	40s609ms
	TCL	337,763	17s707ms
	UPDATE	25,790	8s669ms
tony	Total	864	266ms
	SELECT	864	266ms

Duration by user

Key values

7m42s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	852,934	7m42s
	DELETE	47	1s86ms
	INSERT	29,235	18s798ms
	OTHERS	1,989	73ms
	SELECT	718,581	6m6s
	TCL	61,572	7s225ms
	UPDATE	41,510	1m7s
symmetricds	Total	1,426,435	1m32s
	DELETE	4,755	6s277ms
	INSERT	158,410	11s451ms
	OTHERS	522,538	8s32ms
	SELECT	377,179	40s609ms
	TCL	337,763	17s707ms
	UPDATE	25,790	8s669ms
tony	Total	864	266ms
	SELECT	864	266ms

Queries by host

Key values

10.10.10.1 Main host
2,279,369 Requests
9m14s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	2,279,369	9m14s
	DELETE	4,802	7s363ms
	INSERT	187,645	30s249ms
	OTHERS	524,527	8s106ms
	SELECT	1,095,760	6m47s
	TCL	399,335	24s933ms
	UPDATE	67,300	1m16s
::1	Total	864	266ms
	SELECT	864	266ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
2,274,627 Requests
9m14s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	2,274,627	9m14s
	DELETE	4,802	7s363ms
	INSERT	187,568	30s208ms
	OTHERS	522,677	8s32ms
	SELECT	1,093,135	6m47s
	TCL	399,145	24s849ms
	UPDATE	67,300	1m16s
[unknown]	Total	5,606	810ms
	INSERT	77	41ms
	OTHERS	1,850	73ms
	SELECT	3,489	612ms
	TCL	190	83ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2019-04-12 08:40:32 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2,219,257 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	2,219,257	97.33%
1-5ms	49,734	2.18%
5-10ms	3,038	0.13%
10-25ms	5,268	0.23%
25-50ms	2,601	0.11%
50-100ms	211	0.01%
100-500ms	107	0.00%
500-1000ms	5	0.00%
1000-10000ms	12	0.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2019-04-12 06:13:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 09:59:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:11:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:10:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 05:56:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 12:37:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 05:56:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 16:45:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:08:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:11:27 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:05:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 09:20:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 09:21:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 06:08:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 08:08:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2019-04-12 12:35:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	5s87ms	UPDATE FLOW_REPORTS SET routeNumber = '9392485', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:55.825', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 12:00:06.654', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520342'; [ Date: 2019-04-12 06:13:21 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	5s23ms	UPDATE FLOW_REPORTS SET routeNumber = '9392480', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-12 14:59:39.219', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 14:10:01', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-12 09:19:19.736', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 17:00:25.914', UPDATED = '2019-04-12 14:59:39.241', note = NULL WHERE FLOW_REPORT_ID = '200520292'; [ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	4s656ms	UPDATE FLOW_REPORTS SET routeNumber = '9392480', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-12 14:59:39.219', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 14:10:01', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-12 09:19:19.736', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 17:00:25.914', UPDATED = '2019-04-12 14:59:39.241', note = NULL WHERE FLOW_REPORT_ID = '200520292'; [ Date: 2019-04-12 15:07:24 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	3s416ms	UPDATE FLOW_REPORTS SET routeNumber = '9392485', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:55.825', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 12:00:06.654', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520342'; [ Date: 2019-04-12 06:13:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	3s6ms	UPDATE FLOW_REPORTS SET routeNumber = '9392480', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 't', outbaseRoutesCorrectlyGrouped = 't', causeOfDelay = ' ', pharmacy100CheckTime = '2019-04-12 14:59:39.219', linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 14:10:01', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-12 09:19:19.736', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 17:00:25.914', UPDATED = '2019-04-12 14:59:39.241', note = NULL WHERE FLOW_REPORT_ID = '200520292'; [ Date: 2019-04-12 15:07:22 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	1s800ms	UPDATE FLOW_REPORTS SET routeNumber = '9392322', roundDeliveryDate = '2019-04-15', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 00:44:43', failedTargetPickTime = 'f', actualPaperworkCompleteTime = '2019-04-12 09:00:37.113', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 10:30:10.634', UPDATED = '2019-04-12 09:59:29.066', note = NULL WHERE FLOW_REPORT_ID = '200519972'; [ Date: 2019-04-12 09:59:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	1s707ms	UPDATE FLOW_REPORTS SET routeNumber = '9392475', roundDeliveryDate = '2019-04-15', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:55.725', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 12:00:48.743', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520242'; [ Date: 2019-04-12 06:11:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	1s537ms	UPDATE FLOW_REPORTS SET routeNumber = '9392470', roundDeliveryDate = '2019-04-15', distributionPoint = 'F Loncol', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:56.808', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 11:30:14.595', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520192'; [ Date: 2019-04-12 06:10:42 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	1s162ms	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-04-01' AND '2019-04-30'; [ Date: 2019-04-12 05:56:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	1s121ms	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-04-01' AND '2019-04-30'; [ Date: 2019-04-12 12:37:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	1s105ms	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-04-01' AND '2019-04-30'; [ Date: 2019-04-12 05:56:14 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	1s84ms	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-04-01' AND '2019-04-30'; [ Date: 2019-04-12 16:45:06 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	863ms	UPDATE FLOW_REPORTS SET routeNumber = '9392541', roundDeliveryDate = '2019-04-15', distributionPoint = 'B UK Mail', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 03:50:41', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:55.674', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 09:30:41.302', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520082'; [ Date: 2019-04-12 06:08:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	741ms	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 = '8768715' AND o.node_id = '2' ORDER BY d.data_id ASC; [ Date: 2019-04-12 06:11:27 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	675ms	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 = '8768716' AND o.node_id = '0' ORDER BY d.data_id ASC; [ Date: 2019-04-12 06:05:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	509ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '213700862'; [ Date: 2019-04-12 09:20:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	504ms	DELETE FROM RX_LINE_ACTIVITIES WHERE RX_LINE_ACTIVITY_ID = '213700852'; [ Date: 2019-04-12 09:21:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	451ms	UPDATE FLOW_REPORTS SET routeNumber = '9392541', roundDeliveryDate = '2019-04-15', distributionPoint = 'B UK Mail', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2019-04-12 03:50:41', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2019-04-12 06:07:55.674', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2019-04-12 09:30:41.302', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200520082'; [ Date: 2019-04-12 06:08:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	397ms	SELECT count() AS y0_ FROM ORDER_LINES this_ WHERE (this_.partCode = '18439' OR this_.partCode = '40711'); [ Date:* 2019-04-12 08:08:27 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	237ms	SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE _checks.newRxCheckBy = '4060' AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC; [ Date: 2019-04-12 12:35:47 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 1m3s - Times executed: 1984 ]
[ User: pharmisight - Total duration: 49s671ms - Times executed: 82370 ]
[ User: pharmisight - Total duration: 29s960ms - Times executed: 1984 ]
[ User: pharmisight - Total duration: 26s844ms - Times executed: 7936 ]
[ User: symmetricds - Total duration: 16s618ms - Times executed: 168881 ]
[ User: pharmisight - Total duration: 21s809ms - Times executed: 90598 ]
[ User: pharmisight - Total duration: 20s386ms - Times executed: 841 ]
[ User: pharmisight - Total duration: 16s533ms - Times executed: 971 ]
[ User: pharmisight - Total duration: 12s986ms - Times executed: 210 ]
[ User: pharmisight - Total duration: 12s689ms - Times executed: 3330 ]
[ User: pharmisight - Total duration: 12s7ms - Times executed: 65 ]
[ User: pharmisight - Total duration: 11s852ms - Times executed: 503 ]
[ User: pharmisight - Total duration: 9s24ms - Times executed: 14325 ]
[ User: symmetricds - Total duration: 8s982ms - Times executed: 15947 ]
[ User: pharmisight - Total duration: 8s919ms - Times executed: 93836 ]
[ User: pharmisight - Total duration: 8s873ms - Times executed: 142 ]
[ User: symmetricds - Total duration: 7s480ms - Times executed: 485654 ]
[ User: symmetricds - Total duration: 7s57ms - Times executed: 142097 ]
[ User: pharmisight - Total duration: 6s745ms - Times executed: 1984 ]
[ User: pharmisight - Total duration: 6s241ms - Times executed: 2035 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 7s480ms - Times executed: 485654 ]
[ User: symmetricds - Total duration: 1s89ms - Times executed: 168882 ]
[ User: symmetricds - Total duration: 16s618ms - Times executed: 168881 ]
[ User: symmetricds - Total duration: 2s197ms - Times executed: 197459 ]
[ User: symmetricds - Total duration: 7s57ms - Times executed: 142097 ]
[ User: pharmisight - Total duration: 8s919ms - Times executed: 93836 ]
[ User: pharmisight - Total duration: 21s809ms - Times executed: 90598 ]
[ User: pharmisight - Total duration: 3s623ms - Times executed: 83910 ]
[ User: pharmisight - Total duration: 49s671ms - Times executed: 82370 ]
[ User: pharmisight - Total duration: 2s65ms - Times executed: 47191 ]
[ User: pharmisight - Total duration: 1s618ms - Times executed: 30563 ]
[ User: pharmisight - Total duration: 1s149ms - Times executed: 24732 ]
[ User: pharmisight - Total duration: 543ms - Times executed: 24708 ]
[ User: symmetricds - Total duration: 1s182ms - Times executed: 24485 ]
[ User: pharmisight - Total duration: 975ms - Times executed: 23362 ]
[ User: symmetricds - Total duration: 1s31ms - Times executed: 20341 ]
[ User: pharmisight - Total duration: 768ms - Times executed: 17893 ]
[ User: pharmisight - Total duration: 1s412ms - Times executed: 17806 ]
[ User: pharmisight - Total duration: 807ms - Times executed: 17408 ]
[ User: symmetricds - Total duration: 214ms - Times executed: 17263 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 12s7ms - Times executed: 65 ]
[ User: pharmisight - Total duration: 8s873ms - Times executed: 142 ]
[ User: pharmisight - Total duration: 12s986ms - Times executed: 210 ]
[ User: pharmisight - Total duration: 1m3s - Times executed: 1984 ]
[ User: pharmisight - Total duration: 20s386ms - Times executed: 841 ]
[ User: pharmisight - Total duration: 11s852ms - Times executed: 503 ]
[ User: pharmisight - Total duration: 16s533ms - Times executed: 971 ]
[ User: pharmisight - Total duration: 29s960ms - Times executed: 1984 ]
[ User: pharmisight - Total duration: 12s689ms - Times executed: 3330 ]
[ User: pharmisight - Total duration: 6s745ms - Times executed: 1984 ]
[ User: pharmisight - Total duration: 26s844ms - Times executed: 7936 ]
[ User: pharmisight - Total duration: 6s241ms - Times executed: 2035 ]
[ User: pharmisight - Total duration: 9s24ms - Times executed: 14325 ]
[ User: pharmisight - Total duration: 49s671ms - Times executed: 82370 ]
[ User: symmetricds - Total duration: 8s982ms - Times executed: 15947 ]
[ User: pharmisight - Total duration: 21s809ms - Times executed: 90598 ]
[ User: symmetricds - Total duration: 16s618ms - Times executed: 168881 ]
[ User: pharmisight - Total duration: 8s919ms - Times executed: 93836 ]
[ User: pharmisight - Total duration: 1s412ms - Times executed: 17806 ]
[ User: pharmisight - Total duration: 1s618ms - Times executed: 30563 ]

Log levels

Key values

7,564,950 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	16	0.00%
DETAIL	2,111,954	27.92%
ERROR	173	0.00%
FATAL	3	0.00%
LOG	5,452,618	72.08%
STATEMENT	186	0.00%

Events distribution

Key values

0 PANIC entries
3 FATAL entries
173 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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


Date: 2019-04-12 14:00:39
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2019-04-12 06:13:17
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2019-04-12 06:13:17
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2019-04-12 11:56:02
Database: postgres
Application: [unknown]
User: postgres
Remote: 178.128.202.215
Code: 
Date: 2019-04-12 14:02:42
Database: postgres
Application: [unknown]
User: postgres
Remote: 138.68.29.165
Code: 
Date: 2019-04-12 14:00:37
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
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

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