pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Aug 21 00:00:46 2018
Log file: /var/log/postgresql/postgresql-9.6-main.log.1
Parsed 14,826,927 log entries in 43s
Log start from 2018-08-20 00:00:00 to 2018-08-20 23:59:59

Global Stats

1,273 Number of unique normalized queries
4,454,967 Number of queries
23h45m20s Total query duration
2018-08-20 00:00:00 First query
2018-08-20 23:59:59 Last query
11,221 queries/s at 2018-08-20 06:06:23 Query peak

632 Number of events
12 Number of unique normalized events
430 Max number of times the same event was reported
0 Number of cancellation

611 Total number of automatic vacuums
642 Total number of automatic analyzes

4 Number temporary file
9.05 MiB Max size of temporary file
8.74 MiB Average size of temporary file

2,312 Total number of sessions
3 sessions at 2018-08-20 15:51:05 Session peak
15d1h57m35s Total duration of sessions
9m23s Average duration of sessions
1,926 Average queries per session
36s989ms Average queries duration per session

2,312 Total number of connections
15 connections/s at 2018-08-20 09:07:17 Connection peak
1 Total number of databases

SQL Traffic

Key values

11,221 queries/s Query Peak
2018-08-20 06:06:23 Date

SELECT Traffic

Key values

1,869 queries/s Query Peak
2018-08-20 11:40:00 Date

INSERT/UPDATE/DELETE Traffic

Key values

11,131 queries/s Query Peak
2018-08-20 06:06:23 Date

Queries duration

Key values

23h45m20s Total query duration

Prepared queries ratio

Key values

2.62 Ratio of bind vs prepare
128.14 % 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)
Aug 20	00	96,097	0ms	17ms	0ms	69ms	118ms	1s673ms
	01	92,892	0ms	19ms	0ms	65ms	142ms	212ms
	02	93,424	0ms	15ms	0ms	56ms	144ms	213ms
	03	92,319	0ms	29ms	0ms	57ms	76ms	194ms
	04	92,764	0ms	18ms	0ms	62ms	116ms	245ms
	05	92,294	0ms	13ms	0ms	69ms	79ms	165ms
	06	339,209	0ms	14s935ms	0ms	6s43ms	10s150ms	41s369ms
	07	224,523	0ms	204ms	0ms	2s229ms	3s268ms	3s892ms
	08	259,844	0ms	1s722ms	0ms	3s291ms	4s421ms	4s802ms
	09	262,745	0ms	921ms	0ms	4s405ms	5s235ms	7s112ms
	10	397,231	0ms	810ms	0ms	6s326ms	7s368ms	8s992ms
	11	358,169	0ms	22m58s	83ms	28m18s	41m20s	4h36m16s
	12	303,119	0ms	3m6s	10ms	6s128ms	6m4s	36m23s
	13	329,595	0ms	23m58s	156ms	21m9s	3h8m27s	4h44m40s
	14	165,430	0ms	1s464ms	0ms	2s967ms	3s191ms	4s857ms
	15	256,918	0ms	261ms	0ms	4s859ms	6s737ms	7s424ms
	16	241,391	0ms	214ms	0ms	3s974ms	6s89ms	6s319ms
	17	183,047	0ms	309ms	0ms	3s638ms	4s861ms	6s403ms
	18	101,930	0ms	20ms	0ms	74ms	95ms	660ms
	19	93,867	0ms	147ms	0ms	82ms	291ms	395ms
	20	94,493	0ms	20ms	0ms	84ms	186ms	762ms
	21	93,480	0ms	15ms	0ms	64ms	154ms	371ms
	22	95,303	0ms	18ms	0ms	69ms	204ms	508ms
	23	94,883	0ms	20ms	0ms	70ms	296ms	407ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 20	00	33,036	0ms	31ms	36ms	147ms
	01	30,852	0ms	29ms	35ms	56ms
	02	31,028	0ms	33ms	36ms	70ms
	03	30,725	0ms	31ms	34ms	74ms
	04	30,818	0ms	29ms	32ms	71ms
	05	30,763	0ms	29ms	33ms	49ms
	06	159,024	0ms	2s237ms	3s114ms	5s143ms
	07	106,774	0ms	1s159ms	1s871ms	2s743ms
	08	135,170	0ms	2s69ms	2s936ms	4s283ms
	09	143,700	0ms	3s679ms	4s93ms	5s613ms
	10	219,413	0ms	4s359ms	5s270ms	5s836ms
	11	229,805	0ms	2s594ms	3s952ms	24s365ms
	12	195,688	0ms	3s135ms	4s711ms	6s711ms
	13	207,664	0ms	2s501ms	4s316ms	5s585ms
	14	74,913	0ms	2s178ms	2s825ms	4s602ms
	15	162,062	0ms	3s406ms	4s732ms	6s856ms
	16	159,069	0ms	2s415ms	3s875ms	5s952ms
	17	110,531	0ms	2s270ms	3s536ms	5s369ms
	18	34,616	0ms	29ms	33ms	170ms
	19	31,320	0ms	36ms	41ms	172ms
	20	33,073	0ms	35ms	40ms	179ms
	21	31,130	0ms	33ms	37ms	92ms
	22	31,488	0ms	32ms	40ms	89ms
	23	31,325	0ms	32ms	36ms	81ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 20	00	467	736	79	0ms	2ms	8ms	19ms
	01	660	760	80	0ms	1ms	9ms	27ms
	02	714	780	85	0ms	1ms	8ms	31ms
	03	264	639	82	0ms	1ms	6ms	10ms
	04	420	704	82	0ms	1ms	8ms	25ms
	05	99	611	83	0ms	1ms	5ms	10ms
	06	58,943	21,022	444	1ms	554ms	1s312ms	5s475ms
	07	15,485	8,335	395	0ms	281ms	350ms	605ms
	08	17,144	8,642	411	0ms	251ms	313ms	381ms
	09	13,902	7,384	370	0ms	195ms	260ms	382ms
	10	55,857	18,903	474	0ms	334ms	1s121ms	2s917ms
	11	16,071	9,074	448	1s159ms	219ms	278ms	41m18s
	12	10,258	6,770	344	172ms	154ms	234ms	6m1s
	13	12,005	8,841	369	2s424ms	537ms	35s864ms	3h8m26s
	14	4,766	4,041	259	0ms	98ms	157ms	199ms
	15	4,246	4,102	309	0ms	108ms	151ms	181ms
	16	4,217	3,127	241	0ms	82ms	129ms	165ms
	17	2,199	1,829	178	0ms	37ms	75ms	221ms
	18	495	1,751	117	0ms	10ms	14ms	24ms
	19	802	813	117	0ms	2ms	9ms	35ms
	20	1,194	946	153	0ms	3ms	11ms	63ms
	21	609	766	118	0ms	1ms	9ms	52ms
	22	1,763	1,041	116	0ms	1ms	9ms	127ms
	23	1,632	1,009	118	0ms	1ms	8ms	138ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Aug 20	00	57,340	96,061	1.68	96.87%
	01	55,153	92,856	1.68	97.30%
	02	55,545	93,388	1.68	97.34%
	03	54,725	92,283	1.69	97.64%
	04	54,948	92,728	1.69	97.33%
	05	54,931	92,258	1.68	98.15%
	06	91,605	339,173	3.70	31.52%
	07	85,370	223,199	2.61	47.92%
	08	85,676	259,808	3.03	40.26%
	09	84,305	262,709	3.12	38.80%
	10	93,796	397,195	4.23	26.83%
	11	96,615	357,276	3.70	31.38%
	12	88,727	303,083	3.42	34.42%
	13	97,417	329,559	3.38	34.79%
	14	77,793	165,334	2.13	63.49%
	15	78,668	256,839	3.26	36.68%
	16	75,230	241,341	3.21	37.42%
	17	68,441	183,011	2.67	47.27%
	18	58,553	100,793	1.72	91.71%
	19	56,330	93,831	1.67	97.93%
	20	55,791	94,457	1.69	94.31%
	21	55,631	93,444	1.68	97.38%
	22	56,947	95,267	1.67	96.72%
	23	56,328	94,847	1.68	96.25%

Day	Hour	Count	Average / Second
Aug 20	00	75	0.02/s
	01	70	0.02/s
	02	73	0.02/s
	03	64	0.02/s
	04	64	0.02/s
	05	65	0.02/s
	06	89	0.02/s
	07	90	0.03/s
	08	81	0.02/s
	09	99	0.03/s
	10	117	0.03/s
	11	104	0.03/s
	12	157	0.04/s
	13	130	0.04/s
	14	94	0.03/s
	15	142	0.04/s
	16	148	0.04/s
	17	155	0.04/s
	18	67	0.02/s
	19	83	0.02/s
	20	99	0.03/s
	21	70	0.02/s
	22	91	0.03/s
	23	85	0.02/s

Day	Hour	Count	Average Duration
Aug 20	00	75	7m57s
	01	70	8m44s
	02	73	7m57s
	03	64	9m12s
	04	64	9m27s
	05	65	9m5s
	06	89	7m43s
	07	90	8m
	08	66	7m58s
	09	111	10m22s
	10	107	10m19s
	11	111	13m58s
	12	118	10m38s
	13	135	16m5s
	14	128	9m18s
	15	139	10m21s
	16	143	8m29s
	17	169	8m41s
	18	67	9m3s
	19	83	7m18s
	20	99	6m28s
	21	70	8m15s
	22	91	6m39s
	23	85	7m17s

↑ Back to the top of the General Activity table

Established Connections

Key values

15 connections Connection Peak
2018-08-20 09:07:17 Date

Connections per database

Key values

pharmisight Main Database
2,312 connections Total

Chart
Table

Database	User	Count
pharmisight		2,312
	pharmisight	1,059
	symmetricds	965
	tony	288

Connections per user

Key values

pharmisight Main User
2,312 connections Total

Chart
Table

User	Count
pharmisight	1,059
symmetricds	965
tony	288

Connections per host

Key values

10.10.10.1 Main host with 2024 connections
2,312 Total connections

Chart
Table

Host	Count
10.10.10.1	2,024
::1	288

Simultaneous sessions

Key values

3 sessions Session Peak
2018-08-20 15:51:05 Date

Histogram of session times

Key values

1,342 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	289	12.50%
500ms-1s	0	0.00%
1s-30s	6	0.26%
30s-1m	0	0.00%
1m-10m	1,342	58.04%
10m-30m	576	24.91%
30m-1h	90	3.89%
1h-8h	9	0.39%
> 8h	0	0.00%

Sessions per database

Key values

pharmisight Main Database
2,312 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
pharmisight	2,312	15d1h57m35s	9m23s

Sessions per user

Key values

pharmisight Main User
2,312 sessions Total

Chart
Table

User	Count	Total Duration
pharmisight	1,059	10d1h3m8s
symmetricds	965	5d54m11s
tony	288	15s487ms

Sessions per host

Key values

10.10.10.1 Main Host
2,312 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.1	2,024	15d1h57m19s	10m43s
::1	288	15s487ms	53ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,312 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	2,018	15d1h56m25s	10m45s
[unknown]	294	1m9s	237ms

Checkpoints Buffers

Key values

2,188 buffers Checkpoint Peak
2018-08-20 10:43:56 Date
149.938 seconds Highest write time
0.040 seconds Sync time

Checkpoints Wal files

Key values

3 files Wal files usage Peak
2018-08-20 06:13:51 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
Aug 20	00	856	85.842s	0.025s	85.91s
	01	813	81.537s	0.023s	81.6s
	02	771	77.324s	0.014s	77.379s
	03	667	66.904s	0.021s	66.964s
	04	700	70.194s	0.018s	70.254s
	05	536	53.759s	0.016s	53.816s
	06	11,396	1,043.011s	0.053s	1,043.113s
	07	7,566	757.031s	0.032s	757.105s
	08	6,690	671.218s	0.037s	671.313s
	09	6,117	613.489s	0.075s	613.608s
	10	8,975	765.185s	0.052s	765.276s
	11	8,530	867.524s	0.027s	867.586s
	12	6,094	609.541s	0.023s	609.607s
	13	9,617	944.569s	0.03s	944.639s
	14	3,400	341.077s	0.031s	341.149s
	15	3,565	356.576s	0.022s	356.636s
	16	2,462	246.714s	0.033s	246.786s
	17	2,094	209.871s	0.014s	209.924s
	18	1,605	160.799s	0.017s	160.857s
	19	1,258	125.888s	0.011s	125.94s
	20	886	88.877s	0.024s	88.943s
	21	952	95.484s	0.016s	95.538s
	22	921	92.295s	0.016s	92.354s
	23	1,058	106.142s	0.013s	106.201s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Aug 20	00	0	0	286	0.008s	0s
	01	0	0	320	0.008s	0s
	02	0	0	315	0.002s	0s
	03	0	0	275	0.008s	0.001s
	04	0	1	301	0.002s	0s
	05	0	0	253	0.002s	0s
	06	2	7	1,301	0.003s	0s
	07	0	3	1,145	0.002s	0s
	08	0	3	1,138	0.002s	0s
	09	0	2	1,135	0.039s	0s
	10	0	8	1,254	0.004s	0s
	11	1	2	1,282	0.003s	0s
	12	0	2	1,188	0.002s	0s
	13	0	4	1,368	0.002s	0s
	14	0	1	993	0.003s	0s
	15	0	2	1,128	0.003s	0s
	16	0	1	763	0.008s	0s
	17	0	0	850	0.001s	0s
	18	0	1	343	0.002s	0s
	19	0	0	320	0.002s	0s
	20	0	1	354	0.008s	0s
	21	0	0	393	0.002s	0s
	22	0	0	369	0.003s	0s
	23	0	1	396	0.002s	0s

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

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

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

18.05 MiB Temp Files size Peak
2018-08-20 06:06:33 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2018-08-20 06:06:33 Date

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

1.00 sec Highest CPU-cost vacuum
Table public.sym_outgoing_batch
Database pharmisight
2018-08-20 10:42:24 Date
5.06 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight
2018-08-20 10:44:29 Date

Analyzes per table

Key values

public.sym_node_communication (205) Main table analyzed (database pharmisight)
642 analyzes Total

Chart
Table

Table	Number of analyzes
pharmisight.public.sym_node_communication	205
pharmisight.public.sym_data_gap	114
pharmisight.public.sym_sequence	108
pharmisight.public.sym_outgoing_batch	107
pharmisight.public.sym_node_channel_ctl	26
pharmisight.public.sym_incoming_batch	22
pharmisight.public.sym_data	19
pharmisight.public.sym_data_event	18
pharmisight.public.sym_lock	11
pharmisight.public.sym_node_host	6
pharmisight.public.item_codes	2
pharmisight.public.patients	1
pharmisight.public.flow_report_summary_delays	1
pharmisight.public.users	1
pharmisight.public.tablets	1
Total	642

Vacuums per table

Key values

public.sym_node_communication (241) Main table vacuumed on database pharmisight
611 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
pharmisight.public.sym_node_communication	241	2
pharmisight.public.sym_sequence	150	4
pharmisight.public.sym_data_gap	93	61
pharmisight.public.sym_outgoing_batch	61	56
pharmisight.public.sym_node_channel_ctl	26	0
pharmisight.public.sym_lock	12	0
pharmisight.pg_catalog.pg_statistic	10	10
pharmisight.public.sym_incoming_batch	8	8
pharmisight.public.sym_node_host	6	0
pharmisight.pg_toast.pg_toast_2619	3	3
pharmisight.public.item_codes	1	1
Total	611	145

Tuples removed per table

Key values

public.sym_node_communication (11356) Main table with removed tuples on database pharmisight
29403 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.public.sym_node_communication	241	2	11356	0
pharmisight.public.sym_sequence	150	4	5625	3
pharmisight.public.sym_data_gap	93	61	3094	2
pharmisight.pg_catalog.pg_statistic	10	10	2681	0
pharmisight.public.sym_outgoing_batch	61	56	2633	0
pharmisight.public.sym_node_channel_ctl	26	0	1350	0
pharmisight.public.sym_incoming_batch	8	8	1274	0
pharmisight.public.sym_lock	12	0	614	0
pharmisight.public.sym_node_host	6	0	313	0
pharmisight.public.item_codes	1	1	257	0
pharmisight.pg_toast.pg_toast_2619	3	3	206	4
Total	611	145	29,403	9

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
pharmisight.pg_toast.pg_toast_2619	3	3	206	4
pharmisight.public.sym_sequence	150	4	5625	3
pharmisight.public.sym_data_gap	93	61	3094	2
pharmisight.public.sym_node_channel_ctl	26	0	1350	0
pharmisight.pg_catalog.pg_statistic	10	10	2681	0
pharmisight.public.sym_node_host	6	0	313	0
pharmisight.public.item_codes	1	1	257	0
pharmisight.public.sym_node_communication	241	2	11356	0
pharmisight.public.sym_incoming_batch	8	8	1274	0
pharmisight.public.sym_outgoing_batch	61	56	2633	0
pharmisight.public.sym_lock	12	0	614	0
Total	611	145	29,403	9

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Aug 20	00	13	15
	01	12	14
	02	10	12
	03	10	13
	04	11	13
	05	11	12
	06	46	67
	07	40	57
	08	35	52
	09	35	47
	10	36	47
	11	92	46
	12	29	39
	13	86	39
	14	22	28
	15	25	31
	16	17	21
	17	16	19
	18	11	14
	19	13	12
	20	7	10
	21	14	12
	22	9	10
	23	11	12

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
625 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		1	14m25s	14m25s
	tuple	1	14m25s	14m25s
ExclusiveLock		189	9h1m45s	2m51s
	tuple	189	9h1m45s	2m51s
ShareLock		435	14h5m3s	1m56s
	transaction	435	14h5m3s	1m56s
	Total	625	23h21m13s	2m14s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	580	18h46m7s	1s36ms	21m11s	1m56s	UPDATE flow_reports SET routenumber = ?, rounddeliverydate = ?, distributionpoint = ?, fullypicked = ?, outbaseroutescorrectlygrouped = ?, causeofdelay = ?, pharmacy100checktime = ?, linesheldback = ?, packtime100 = ?, replenish = ?, COMMENT = ?, pickdatetime = ?, failedtargetpicktime = ?, actualpaperworkcompletetime = ?, changedpickdatetime = ?, manuallychangedpicktime = ?, created = ?, updated = ?, note = ? WHERE flow_report_id = ?; UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; Date: 2018-08-20 13:25:18 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver
2	45	4h35m5s	7s10ms	22m58s	6m6s	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-08-20 11:43:18 Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver

Queries that waited the most


[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:19:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	22m58s	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-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
2	22m38s	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-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
3	21m11s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
4	19m30s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:19:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
5	18m41s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
6	18m41s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
7	18m41s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
8	18m41s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
9	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
10	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
11	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
12	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
13	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
14	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
15	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
16	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
17	18m21s	UPDATE FLOW_REPORTS SET routeNumber = $1, roundDeliveryDate = $2, distributionPoint = $3, fullyPicked = $4, outbaseRoutesCorrectlyGrouped = $5, causeOfDelay = $6, pharmacy100CheckTime = $7, linesHeldBack = $8, packTime100 = $9, replenish = $10, COMMENT = $11, pickDateTime = $12, failedTargetPickTime = $13, actualPaperworkCompleteTime = $14, changedPickDateTime = $15, manuallyChangedPickTime = $16, CREATED = $17, UPDATED = $18, note = $19 WHERE FLOW_REPORT_ID = $20; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
18	17m56s	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-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
19	17m55s	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-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]
20	17m53s	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-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

2,283,987 Total read queries
1,189,450 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	2,283,987	51.27%
INSERT	224,212	5.03%
UPDATE	112,626	2.53%
DELETE	5,472	0.12%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	1	0.00%
TCL	847,139	19.02%
OTHERS	981,530	22.03%

Queries by database

Key values

pharmisight Main database
4,454,967 Requests
23h45m20s (pharmisight)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
pharmisight	Total	4,454,967	23h45m20s
	DDL	1	6ms
	DELETE	5,472	4s502ms
	INSERT	224,212	57s745ms
	OTHERS	981,530	16s709ms
	SELECT	2,283,987	19m1s
	TCL	847,139	37s267ms
	UPDATE	112,626	23h24m22s

Queries by user

Key values

symmetricds Main user
2,903,733 Requests

Queries Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,644,008	23h43m23s
	DELETE	81	597ms
	INSERT	33,948	46s70ms
	OTHERS	3,255	87ms
	SELECT	1,441,953	18m17s
	TCL	112,280	9s517ms
	UPDATE	52,491	23h24m9s
symmetricds	Total	2,903,733	1m54s
	DDL	1	6ms
	DELETE	5,459	3s914ms
	INSERT	191,477	11s872ms
	OTHERS	1,014,506	17s270ms
	SELECT	872,028	40s233ms
	TCL	759,201	28s144ms
	UPDATE	61,061	13s511ms
tony	Total	900	4s501ms
	SELECT	900	4s501ms

Duration by user

Key values

23h43m23s (pharmisight) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pharmisight	Total	1,644,008	23h43m23s
	DELETE	81	597ms
	INSERT	33,948	46s70ms
	OTHERS	3,255	87ms
	SELECT	1,441,953	18m17s
	TCL	112,280	9s517ms
	UPDATE	52,491	23h24m9s
symmetricds	Total	2,903,733	1m54s
	DDL	1	6ms
	DELETE	5,459	3s914ms
	INSERT	191,477	11s872ms
	OTHERS	1,014,506	17s270ms
	SELECT	872,028	40s233ms
	TCL	759,201	28s144ms
	UPDATE	61,061	13s511ms
tony	Total	900	4s501ms
	SELECT	900	4s501ms

Queries by host

Key values

10.10.10.1 Main host
4,547,741 Requests
23h45m18s (10.10.10.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
10.10.10.1	Total	4,547,741	23h45m18s
	DDL	1	6ms
	DELETE	5,540	4s512ms
	INSERT	225,425	57s942ms
	OTHERS	1,017,761	17s357ms
	SELECT	2,313,981	18m58s
	TCL	871,481	37s661ms
	UPDATE	113,552	23h24m22s
::1	Total	900	4s501ms
	SELECT	900	4s501ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
4,448,722 Requests
23h45m15s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	4,448,722	23h45m15s
	DDL	1	6ms
	DELETE	5,472	4s502ms
	INSERT	224,176	57s723ms
	OTHERS	979,500	16s668ms
	SELECT	2,279,916	18m56s
	TCL	847,031	37s254ms
	UPDATE	112,626	23h24m22s
[unknown]	Total	6,245	4s828ms
	INSERT	36	22ms
	OTHERS	2,030	41ms
	SELECT	4,071	4s751ms
	TCL	108	13ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2018-08-20 15:36:46 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

4,292,189 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	4,292,189	96.35%
1-5ms	124,669	2.80%
5-10ms	10,298	0.23%
10-25ms	19,742	0.44%
25-50ms	6,688	0.15%
50-100ms	535	0.01%
100-500ms	632	0.01%
500-1000ms	9	0.00%
1000-10000ms	27	0.00%
> 10000ms	178	0.00%

Slowest individual queries


[ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:19:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:19:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:19:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:22:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:22:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:22:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:22:10 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:19:08 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2018-08-20 13:20:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	23m58s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	23m58s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	23m57s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	23m46s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	23m45s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	23m31s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:20:05 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	23m10s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:19:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	23m9s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:19:41 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	22m58s	UPDATE ORDER_ROUNDS SET routeNumber = '9061058', uploadedByUserId = '200001292', uploadedByUserName = 'mansoureh.g Ghari', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-08-25', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '1', distributionPoint = 'A Scotland', audited = '2018-08-20 11:19:33.077', auditedBy = '200001292', auditStatus = '1', uploadFinished = 't', lastRxCompleted = '2018-08-20 11:19:08.113', lastRxCompletedBy = '200001292', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1507', dlxPickedLinesQty = '1294', flowReport = '200424732', CREATED = '2018-08-20 10:39:39.812', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200460612'; [ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	22m38s	UPDATE ORDER_ROUNDS SET routeNumber = '9061059', uploadedByUserId = '200001292', uploadedByUserName = 'mansoureh.g Ghari', updatedBy = NULL, updatedByUserName = NULL, orderRoundNote = NULL, firstCheckOut = NULL, allOrdersScannedOK = NULL, STATUS = 'Open', reopenedTimes = '0', lastReopenById = NULL, lastDoneCheckIn = NULL, lastDoneById = NULL, lastDoneByUserName = NULL, missingLabels = NULL, roundDeliveryDate = '2018-08-25', trolley = NULL, stack = NULL, picktime = NULL, uploadUpdated = NULL, patientAlert = NULL, mismatches = NULL, rxStatus = '3', distributionPoint = NULL, audited = NULL, auditedBy = NULL, auditStatus = NULL, uploadFinished = 't', lastRxCompleted = '2018-08-20 10:46:13.535', lastRxCompletedBy = '100', orderRoundNoteReadBy = NULL, routeOrderLinesQty = '1125', dlxPickedLinesQty = '921', flowReport = NULL, CREATED = '2018-08-20 10:39:44.593', createdBy = NULL, UPDATED = NULL, note = NULL WHERE ORDER_ROUND_ID = '200460642'; [ Date: 2018-08-20 11:43:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	22m18s	UPDATE FLOW_REPORTS SET routeNumber = '9061044', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.406', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:09.682', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424892'; [ Date: 2018-08-20 13:19:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	22m5s	UPDATE FLOW_REPORTS SET routeNumber = '9061042', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.096', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:40.33', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424872'; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	21m56s	UPDATE FLOW_REPORTS SET routeNumber = '9061043', roundDeliveryDate = '2018-08-25', distributionPoint = 'D Leeds', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:13.506', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:30:42.588', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424882'; [ Date: 2018-08-20 13:18:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	21m11s	UPDATE FLOW_REPORTS SET routeNumber = '9061066', roundDeliveryDate = '2018-08-25', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.958', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 12:00:54.797', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200425072'; [ Date: 2018-08-20 13:22:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	21m6s	UPDATE FLOW_REPORTS SET routeNumber = '9061066', roundDeliveryDate = '2018-08-25', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.958', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 12:00:54.797', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200425072'; [ Date: 2018-08-20 13:22:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	21m4s	UPDATE FLOW_REPORTS SET routeNumber = '9061054', roundDeliveryDate = '2018-08-25', distributionPoint = 'C Irlam', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-20 12:29:25', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.486', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:00:22.479', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424962'; [ Date: 2018-08-20 13:20:29 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	20m58s	UPDATE FLOW_REPORTS SET routeNumber = '9061066', roundDeliveryDate = '2018-08-25', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.958', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 12:00:54.797', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200425072'; [ Date: 2018-08-20 13:22:18 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	20m54s	UPDATE FLOW_REPORTS SET routeNumber = '9061066', roundDeliveryDate = '2018-08-25', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.958', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 12:00:54.797', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200425072'; [ Date: 2018-08-20 13:22:10 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	19m53s	UPDATE FLOW_REPORTS SET routeNumber = '9061054', roundDeliveryDate = '2018-08-25', distributionPoint = 'C Irlam', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = '2018-08-20 12:29:25', failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.486', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 10:00:22.479', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200424962'; [ Date: 2018-08-20 13:19:08 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	19m37s	UPDATE FLOW_REPORTS SET routeNumber = '9061066', roundDeliveryDate = '2018-08-25', distributionPoint = 'Redditch', fullyPicked = 'f', outbaseRoutesCorrectlyGrouped = 'f', causeOfDelay = NULL, pharmacy100CheckTime = NULL, linesHeldBack = '0', packTime100 = NULL, replenish = NULL, COMMENT = NULL, pickDateTime = NULL, failedTargetPickTime = NULL, actualPaperworkCompleteTime = '2018-08-20 10:46:14.958', changedPickDateTime = 'f', manuallyChangedPickTime = 'f', CREATED = '2018-08-20 12:00:54.797', UPDATED = NULL, note = NULL WHERE FLOW_REPORT_ID = '200425072'; [ Date: 2018-08-20 13:20:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: pharmisight - Total duration: 11h39m16s - Times executed: 475 ]
[ User: pharmisight - Total duration: 4h58m19s - Times executed: 160 ]
[ User: pharmisight - Total duration: 2h13m9s - Times executed: 123 ]
[ User: pharmisight - Total duration: 2h7m26s - Times executed: 151 ]
[ User: pharmisight - Total duration: 1h31m48s - Times executed: 56 ]
[ User: pharmisight - Total duration: 37m24s - Times executed: 78 ]
[ User: pharmisight - Total duration: 13m30s - Times executed: 16 ]
[ User: pharmisight - Total duration: 4m9s - Times executed: 6988 ]
[ User: pharmisight - Total duration: 2m34s - Times executed: 250328 ]
[ User: pharmisight - Total duration: 1m18s - Times executed: 2625 ]
[ User: pharmisight - Total duration: 1m16s - Times executed: 6988 ]
[ User: pharmisight - Total duration: 1m15s - Times executed: 27950 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 264453 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 343 ]
[ User: pharmisight - Total duration: 56s63ms - Times executed: 14231 ]
[ User: pharmisight - Total duration: 38s356ms - Times executed: 2466 ]
[ User: symmetricds - Total duration: 25s629ms - Times executed: 367439 ]
[ User: pharmisight - Total duration: 32s441ms - Times executed: 178 ]
[ User: pharmisight - Total duration: 30s377ms - Times executed: 311 ]
[ User: pharmisight - Total duration: 22s166ms - Times executed: 18964 ]

Most frequent queries (N)


[ User: symmetricds - Total duration: 16s569ms - Times executed: 976429 ]
[ User: symmetricds - Total duration: 5s405ms - Times executed: 474839 ]
[ User: symmetricds - Total duration: 2s126ms - Times executed: 367438 ]
[ User: symmetricds - Total duration: 25s629ms - Times executed: 367439 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 264453 ]
[ User: pharmisight - Total duration: 2m34s - Times executed: 250328 ]
[ User: symmetricds - Total duration: 8s624ms - Times executed: 172823 ]
[ User: pharmisight - Total duration: 7s350ms - Times executed: 167578 ]
[ User: pharmisight - Total duration: 10s342ms - Times executed: 90554 ]
[ User: pharmisight - Total duration: 3s647ms - Times executed: 78543 ]
[ User: symmetricds - Total duration: 3s508ms - Times executed: 77082 ]
[ User: symmetricds - Total duration: 1s883ms - Times executed: 60730 ]
[ User: pharmisight - Total duration: 2s774ms - Times executed: 60005 ]
[ User: symmetricds - Total duration: 1s133ms - Times executed: 56944 ]
[ User: pharmisight - Total duration: 2s233ms - Times executed: 51131 ]
[ User: symmetricds - Total duration: 5s679ms - Times executed: 29366 ]
[ User: pharmisight - Total duration: 709ms - Times executed: 29288 ]
[ User: pharmisight - Total duration: 1s769ms - Times executed: 28789 ]
[ User: pharmisight - Total duration: 1m15s - Times executed: 27950 ]
[ User: pharmisight - Total duration: 1s352ms - Times executed: 23957 ]

Normalized slowest queries (N)


[ User: pharmisight - Total duration: 4h58m19s - Times executed: 160 ]
[ User: pharmisight - Total duration: 1h31m48s - Times executed: 56 ]
[ User: pharmisight - Total duration: 11h39m16s - Times executed: 475 ]
[ User: pharmisight - Total duration: 2h13m9s - Times executed: 123 ]
[ User: pharmisight - Total duration: 2h7m26s - Times executed: 151 ]
[ User: pharmisight - Total duration: 13m30s - Times executed: 16 ]
[ User: pharmisight - Total duration: 37m24s - Times executed: 78 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 343 ]
[ User: pharmisight - Total duration: 32s441ms - Times executed: 178 ]
[ User: pharmisight - Total duration: 30s377ms - Times executed: 311 ]
[ User: pharmisight - Total duration: 4m9s - Times executed: 6988 ]
[ User: pharmisight - Total duration: 1m18s - Times executed: 2625 ]
[ User: pharmisight - Total duration: 38s356ms - Times executed: 2466 ]
[ User: pharmisight - Total duration: 1m16s - Times executed: 6988 ]
[ User: pharmisight - Total duration: 56s63ms - Times executed: 14231 ]
[ User: pharmisight - Total duration: 1m15s - Times executed: 27950 ]
[ User: pharmisight - Total duration: 22s166ms - Times executed: 18964 ]
[ User: pharmisight - Total duration: 2m34s - Times executed: 250328 ]
[ User: pharmisight - Total duration: 1m4s - Times executed: 264453 ]
[ User: symmetricds - Total duration: 5s679ms - Times executed: 29366 ]

Log levels

Key values

14,716,869 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	865	0.01%
DETAIL	4,105,058	27.89%
ERROR	615	0.00%
FATAL	10	0.00%
HINT	1	0.00%
LOG	10,609,072	72.09%
STATEMENT	1,248	0.01%

Events distribution

Key values

0 PANIC entries
10 FATAL entries
622 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

430 Max number of times the same event was reported
632 Total events found


Date: 2018-08-20 11:55:13
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 13:03:02
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 17:59:33
Database: template0
Application: [unknown]
User: postgres
Remote: 71.6.146.185
Code: 
Date: 2018-08-20 17:59:32
Database: template0
Application: [unknown]
User: postgres
Remote: 71.6.146.185
Code: 
Date: 2018-08-20 00:00:10
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: symmetricds
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 00:16:28
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.144
Code: 
Date: 2018-08-20 17:59:33
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 71.6.146.185
Code: 
Date: 2018-08-20 11:28:54
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 12:57:16
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 12:57:14
Database: pharmisight
Application: PostgreSQL JDBC Driver
User: pharmisight
Remote: 10.10.10.1
Code: 
Date: 2018-08-20 00:16:28
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.144
Code: 
Date: 2018-08-20 00:16:28
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 198.108.66.144
Code: 

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values

Queries by application