pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Jul 19 23:00:07 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 59,245 log entries in 5s
Log start from 2026-07-19 07:00:01 to 2026-07-19 21:59:32

Global Stats

1 Number of unique normalized queries
3 Number of queries
6s488ms Total query duration
2026-07-19 09:47:10 First query
2026-07-19 09:57:29 Last query
1 queries/s at 2026-07-19 09:47:10 Query peak

6s488ms Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
6s488ms Execute total duration

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

13,688 Total number of automatic vacuums
121 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

5,415 Total number of sessions
6 sessions at 2026-07-19 21:00:01 Session peak
1m58s Total duration of sessions
21ms Average duration of sessions
0 Average queries per session
1ms Average queries duration per session
20ms Average idle time per session

5,420 Total number of connections
6 connections/s at 2026-07-19 11:05:24 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-19 09:47:10 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-19 09:47:10 Date

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Queries duration

Key values

6s488ms Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % 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)
Jul 19	07	0	0ms	0ms	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms	0ms	0ms
	09	3	0ms	2s386ms	2s162ms	0ms	2s31ms	2s386ms
	10	0	0ms	0ms	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 19	07	0	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms
	09	3	2s162ms	0ms	0ms	2s70ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 19	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 19	07	0	0.00	0.00%
	08	0	0.00	0.00%
	09	3	3.00	0.00%
	10	0	0.00	0.00%
	11	0	0.00	0.00%
	12	0	0.00	0.00%
	13	0	0.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	0	0.00	0.00%
	21	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jul 19	07	362	0.10/s
	08	361	0.10/s
	09	363	0.10/s
	10	361	0.10/s
	11	361	0.10/s
	12	361	0.10/s
	13	361	0.10/s
	14	361	0.10/s
	15	361	0.10/s
	16	361	0.10/s
	17	361	0.10/s
	18	361	0.10/s
	19	361	0.10/s
	20	361	0.10/s
	21	363	0.10/s

Day	Hour	Count	Average Duration	Average idle time
Jul 19	07	361	21ms	21ms
	08	361	21ms	21ms
	09	361	21ms	3ms
	10	361	22ms	22ms
	11	361	21ms	21ms
	12	361	21ms	21ms
	13	361	21ms	21ms
	14	361	21ms	21ms
	15	361	21ms	21ms
	16	361	21ms	21ms
	17	361	22ms	22ms
	18	361	22ms	22ms
	19	361	21ms	21ms
	20	361	22ms	22ms
	21	361	21ms	21ms

↑ Back to the top of the General Activity table

Established Connections

Key values

6 connections Connection Peak
2026-07-19 11:05:24 Date

Connections per database

Key values

etendo Main Database
5,420 connections Total

Chart
Table

Database	User	Count
etendo		3,245
	postgres	60
	tad	3,185
postgres		15
	postgres	15
template1		2,160
	postgres	2,160

Connections per user

Key values

tad Main User
5,420 connections Total

Chart
Table

User	Count
postgres	2,235
tad	3,185

Connections per host

Key values

127.0.0.1 Main host with 3185 connections
5,420 Total connections

Chart
Table

Host	Count
127.0.0.1	3,185
[local]	2,235

Simultaneous sessions

Key values

6 sessions Session Peak
2026-07-19 21:00:01 Date

Histogram of session times

Key values

5,396 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,396	99.65%
500ms-1s	19	0.35%
1s-30s	0	0.00%
30s-1m	0	0.00%
1m-10m	0	0.00%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	0	0.00%
> 8h	0	0.00%

Sessions per database

Key values

etendo Main Database
5,415 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	3,240	1m43s	32ms
postgres	15	669ms	44ms
template1	2,160	13s506ms	6ms

Sessions per user

Key values

tad Main User
5,415 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	2,235	36s658ms	16ms
tad	3,180	1m21s	25ms

Sessions per host

Key values

127.0.0.1 Main Host
5,415 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	3,180	1m21s	25ms
[local]	2,235	36s658ms	16ms

Sessions per application

Key values

psql Main Application
5,415 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	2,160	13s506ms	6ms
pg_profile	45	10s512ms	233ms
psql	3,210	1m34s	29ms

Checkpoints Buffers

Key values

4,524 buffers Checkpoint Peak
2026-07-19 10:04:46 Date
269.905 seconds Highest write time
0.004 seconds Sync time

Checkpoints Wal files

Key values

2 files Wal files usage Peak
2026-07-19 10:04:46 Date

Checkpoints distance

Key values

77.99 Mo Distance Peak
2026-07-19 10:04:46 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 19	07	1,577	156.66s	0.015s	156.712s
	08	2,097	208.884s	0.017s	208.932s
	09	7,264	561.487s	0.021s	561.545s
	10	5,458	362.189s	0.022s	362.248s
	11	1,926	191.549s	0.016s	191.596s
	12	2,006	199.454s	0.016s	199.507s
	13	1,981	196.667s	0.016s	196.717s
	14	1,742	173.199s	0.015s	173.25s
	15	2,037	202.688s	0.016s	202.742s
	16	1,449	143.353s	0.019s	143.413s
	17	1,363	135.115s	0.016s	135.166s
	18	1,390	137.732s	0.016s	137.784s
	19	1,404	139.22s	0.014s	139.27s
	20	1,499	148.44s	0.017s	148.491s
	21	1,452	144.253s	0.016s	144.308s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 19	07	1	220	0.002s	0.011s
	08	1	236	0.001s	0.011s
	09	4	607	0.002s	0.011s
	10	3	487	0.003s	0.012s
	11	0	241	0.001s	0.011s
	12	1	232	0.001s	0.011s
	13	1	245	0.001s	0.011s
	14	0	226	0.001s	0.011s
	15	1	234	0.001s	0.011s
	16	1	234	0.002s	0.012s
	17	0	227	0.002s	0.011s
	18	1	229	0.002s	0.012s
	19	1	242	0.002s	0.012s
	20	0	245	0.001s	0.011s
	21	1	242	0.002s	0.012s

Day	Hour	Avg time (sec)
Jul 19	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

Day	Hour	Mean distance	Mean estimate
Jul 19	07	1,039.45 kB	6,250.55 kB
	08	1,045.27 kB	6,280.45 kB
	09	6,215.55 kB	10,914.55 kB
	10	3,519.08 kB	23,973.58 kB
	11	1,158.64 kB	7,878.64 kB
	12	1,075.55 kB	6,471.36 kB
	13	1,072.91 kB	6,228.91 kB
	14	996.00 kB	6,174.45 kB
	15	1,020.55 kB	6,154.27 kB
	16	928.42 kB	6,191.00 kB
	17	962.45 kB	6,189.00 kB
	18	905.42 kB	6,115.75 kB
	19	909.83 kB	6,128.75 kB
	20	1,066.45 kB	6,911.82 kB
	21	951.92 kB	6,413.42 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (170) Main checkpoint cause
170 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	170
Total	170

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

NO DATASET

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

NO DATASET

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 19	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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0.41 sec Highest CPU-cost vacuum
Table public.m_inoutline
Database etendo
2026-07-19 09:47:56 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

0.41 sec Highest CPU-cost vacuum
Table public.m_inoutline
Database etendo
2026-07-19 09:47:56 Date

Analyzes per table

Key values

profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
121 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.profile.tables_list	10
etendo.profile.last_stat_io	8
etendo.public.ad_process_request	6
etendo.profile.last_extension_versions	4
etendo.profile.stmt_list	4
etendo.profile.last_stat_activity_count_srv1	4
etendo.public.ad_ep_instance_para	3
etendo.profile.last_stat_slru	3
etendo.profile.indexes_list	3
etendo.public.m_inoutline	3
etendo.profile.funcs_list	3
etendo.profile.sample_stat_tables	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_stat_io	1
etendo.profile.sample_stat_database	1
etendo.profile.sample_stat_indexes	1
etendo.profile.sample_stat_user_functions	1
etendo.profile.sample_stat_slru	1
etendo.profile.sample_statements_total	1
Total	121

Vacuums per table

Key values

profile.last_stat_user_functions_srv1 (899) Main table vacuumed on database etendo
13,688 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage			Frozen
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes	pages	tuples
etendo.profile.last_stat_user_functions_srv1	899	0	337,200	0	18	0	0	37	26	210,109	0	0
etendo.profile.tables_list	899	0	150,970	0	1	0	0	37	1	16,633	0	0
etendo.profile.last_stat_indexes_srv1	899	0	4,818,926	0	3,009	0	0	37	27	216,437	0	0
etendo.profile.last_stat_tables_srv1	899	0	3,764,467	0	394	0	0	37	27	216,545	0	0
etendo.public.ad_process_request	899	0	95,103	0	559	0	0	58	20	164,764	0	0
etendo.profile.stmt_list	899	0	160,616	0	43	0	0	37	33	256,021	0	0
etendo.profile.indexes_list	899	0	88,882	0	24	0	0	37	0	8,917	0	0
etendo.profile.last_stat_statements_srv1	898	0	829,650	0	16	0	0	36	24	196,644	0	0
etendo.profile.last_stat_io	839	0	41,234	0	58	0	0	36	32	256,016	0	0
etendo.pg_catalog.pg_statistic	838	0	1,234,904	0	609	0	0	55	43	341,411	0	0
etendo.public.m_inoutline	732	0	2,923,215	0	1,618	0	0	1,635	32	352,318	0	0
etendo.public.ad_ep_instance_para	728	0	23,561	0	26	0	0	29	28	167,880	0	0
etendo.profile.funcs_list	719	0	51,599	0	38	0	0	26	26	209,274	0	0
etendo.profile.last_stat_activity_count_srv1	719	0	11,695	0	52	0	0	26	24	181,450	0	0
etendo.profile.last_extension_versions	719	0	26,637	0	54	0	0	26	26	204,698	0	0
etendo.profile.last_stat_slru	479	0	27,093	0	35	0	0	15	15	118,635	0	0
etendo.pg_toast.pg_toast_2619	361	0	210,696	0	120	0	0	26	14	112,870	0	0
etendo.profile.last_stat_database_srv1	360	0	13,189	0	20	0	0	10	5	27,090	0	0
etendo.profile.sample_stat_indexes	1	0	418	0	151	0	0	147	2	24,668	0	0
etendo.pg_toast.pg_toast_1950640	1	0	37	0	6	0	0	3	1	8,503	0	0
etendo.profile.sample_stat_user_functions	1	0	190	0	65	0	0	56	1	11,683	0	0
Total	13,688	0	14,810,282	0	6,916	0	0	2,406	407	3,302,566	0	0

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (63.0300000000001) Max CPU elapsed for vacuum on database etendo
unknown (0 ms) Max I/O read time for vacuum on database etendo
unknown (0 ms) Max I/O write time for vacuum on database etendo

Chart
Table

	I/O timing (ms)		CPU (s)
Table	read	write	elapsed
etendo.profile.last_stat_user_functions_srv1	0	0	0
etendo.profile.tables_list	0	0	0
etendo.profile.last_stat_indexes_srv1	0	0	63.0300000000001
etendo.profile.last_stat_tables_srv1	0	0	46.1499999999999
etendo.public.ad_process_request	0	0	0
etendo.profile.stmt_list	0	0	0
etendo.profile.indexes_list	0	0	0
etendo.profile.last_stat_statements_srv1	0	0	6.46999999999991
etendo.profile.last_stat_io	0	0	0
etendo.pg_catalog.pg_statistic	0	0	12.3399999999998
etendo.public.m_inoutline	0	0	36.86
etendo.public.ad_ep_instance_para	0	0	0
etendo.profile.funcs_list	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_slru	0	0	0
etendo.pg_toast.pg_toast_2619	0	0	0.02
etendo.profile.last_stat_database_srv1	0	0	0
etendo.profile.sample_stat_indexes	0	0	0.03
etendo.pg_toast.pg_toast_1950640	0	0	0
etendo.profile.sample_stat_user_functions	0	0	0.01
Total	0	0	164.91

Tuples removed per table

Key values

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

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.public.m_inoutline	732	0	0	32,067,843	19,806,014	0	2,571,348
etendo.profile.last_stat_user_functions_srv1	899	0	0	4,712,650	4,351,252	0	152,995
etendo.profile.funcs_list	719	0	0	308,625	182,800	0	9,107
etendo.profile.last_stat_io	839	0	0	136,331	125,424	0	3,476
etendo.profile.tables_list	899	0	0	2,456,450	1,573,811	0	54,118
etendo.profile.last_stat_indexes_srv1	899	0	0	58,807,188	56,272,907	0	2,394,285
etendo.profile.sample_stat_indexes	1	0	0	10,562	688	0	169
etendo.pg_toast.pg_toast_1950640	1	0	0	16	6	0	3
etendo.profile.sample_stat_user_functions	1	0	0	6,777	341	0	64
etendo.pg_catalog.pg_statistic	838	0	0	10,919,288	3,811,372	0	612,248
etendo.pg_toast.pg_toast_2619	361	0	0	625,357	140,821	0	181,583
etendo.profile.last_stat_activity_count_srv1	719	0	0	71,904	71,904	0	2,097
etendo.profile.last_stat_database_srv1	360	0	0	23,760	22,320	0	1,140
etendo.public.ad_ep_instance_para	728	0	0	84,942	84,942	0	2,900
etendo.profile.last_stat_tables_srv1	899	0	0	35,953,617	34,476,560	0	1,867,104
etendo.public.ad_process_request	899	0	0	293,767	219,664	0	29,482
etendo.profile.last_extension_versions	719	0	0	77,656	71,904	0	1,378
etendo.profile.last_stat_statements_srv1	898	0	0	7,223,711	6,797,394	0	392,074
etendo.profile.stmt_list	899	0	0	846,984	426,188	0	58,552
etendo.profile.indexes_list	899	0	0	655,640	280,395	0	14,983
etendo.profile.last_stat_slru	479	0	0	37,135	34,740	0	779
Total	13,688	0	0	155,320,203	128,751,447	0	8,349,885

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.public.m_inoutline	732	0	0	0
etendo.profile.last_stat_user_functions_srv1	899	0	0	0
etendo.profile.funcs_list	719	0	0	0
etendo.profile.last_stat_io	839	0	0	0
etendo.profile.tables_list	899	0	0	0
etendo.profile.last_stat_indexes_srv1	899	0	0	0
etendo.profile.sample_stat_indexes	1	0	0	0
etendo.pg_toast.pg_toast_1950640	1	0	0	0
etendo.profile.sample_stat_user_functions	1	0	0	0
etendo.pg_catalog.pg_statistic	838	0	0	0
etendo.pg_toast.pg_toast_2619	361	0	0	0
etendo.profile.last_stat_activity_count_srv1	719	0	0	0
etendo.profile.last_stat_database_srv1	360	0	0	0
etendo.public.ad_ep_instance_para	728	0	0	0
etendo.profile.last_stat_tables_srv1	899	0	0	0
etendo.public.ad_process_request	899	0	0	0
etendo.profile.last_extension_versions	719	0	0	0
etendo.profile.last_stat_statements_srv1	898	0	0	0
etendo.profile.stmt_list	899	0	0	0
etendo.profile.indexes_list	899	0	0	0
etendo.profile.last_stat_slru	479	0	0	0
Total	13,688	0	0	0

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 19	07	480	9
	08	599	6
	09	622	13
	10	900	8
	11	901	10
	12	900	6
	13	886	10
	14	959	4
	15	961	10
	16	1,080	7
	17	1,080	6
	18	1,080	7
	19	1,080	9
	20	1,080	7
	21	1,080	9

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

3 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	3	100.00%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

etendo Main database
3 Requests
6s488ms (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	3	6s488ms
	select	3	6s488ms

Queries by user

Key values

tad Main user
3 Requests

Queries Chart
Table

User	Request type	Count	Duration
tad	Total	3	6s488ms
	select	3	6s488ms

Duration by user

Key values

6s488ms (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
tad	Total	3	6s488ms
	select	3	6s488ms

Queries by host

Key values

127.0.0.1 Main host
3 Requests
6s488ms (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	3	6s488ms
	select	3	6s488ms

Queries by application

Key values

openbravo Main application
3 Requests
6s488ms (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	3	6s488ms
	select	3	6s488ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-19 20:46:49 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

3 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	3	100.00%
> 10000ms	0	0.00%

Slowest individual queries

Rank	Duration	Query
1	2s386ms	SELECT * FROM M_InOut_Post0 ('05874126A59C4B849CA6FAC47A5DF6CF'); [ Date: 2026-07-19 09:47:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	2s70ms	SELECT * FROM M_InOut_Post0 ('C7CB9D738AB3454DA75EFF5A324CE117'); [ Date: 2026-07-19 09:57:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	2s31ms	SELECT * FROM M_InOut_Post0 ('2657727F454341248385F51316384065'); [ Date: 2026-07-19 09:51:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank

Duration

Query

1

2s386ms

SELECT * FROM M_InOut_Post0 ('05874126A59C4B849CA6FAC47A5DF6CF');

[ Date: 2026-07-19 09:47:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

2

2s70ms

SELECT * FROM M_InOut_Post0 ('C7CB9D738AB3454DA75EFF5A324CE117');

[ Date: 2026-07-19 09:57:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

3

2s31ms

SELECT * FROM M_InOut_Post0 ('2657727F454341248385F51316384065');

[ Date: 2026-07-19 09:51:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

6s488ms

3

Details

2s31ms

2s386ms

2s162ms

select * from m_inout_post0 (?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	09	3	6s488ms	2s162ms

[ User: tad - Total duration: 6s488ms - Times executed: 3 ]

[ Application: openbravo - Total duration: 6s488ms - Times executed: 3 ]

SELECT * FROM M_InOut_Post0 ('05874126A59C4B849CA6FAC47A5DF6CF');

Date: 2026-07-19 09:47:10 Duration: 2s386ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('C7CB9D738AB3454DA75EFF5A324CE117');

Date: 2026-07-19 09:57:29 Duration: 2s70ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('2657727F454341248385F51316384065');

Date: 2026-07-19 09:51:09 Duration: 2s31ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

3

Details

6s488ms

2s31ms

2s386ms

2s162ms

select * from m_inout_post0 (?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	09	3	6s488ms	2s162ms

[ User: tad - Total duration: 6s488ms - Times executed: 3 ]

[ Application: openbravo - Total duration: 6s488ms - Times executed: 3 ]

SELECT * FROM M_InOut_Post0 ('05874126A59C4B849CA6FAC47A5DF6CF');

Date: 2026-07-19 09:47:10 Duration: 2s386ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('C7CB9D738AB3454DA75EFF5A324CE117');

Date: 2026-07-19 09:57:29 Duration: 2s70ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('2657727F454341248385F51316384065');

Date: 2026-07-19 09:51:09 Duration: 2s31ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

2s31ms

2s386ms

2s162ms

3

Details

6s488ms

select * from m_inout_post0 (?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	09	3	6s488ms	2s162ms

[ User: tad - Total duration: 6s488ms - Times executed: 3 ]

[ Application: openbravo - Total duration: 6s488ms - Times executed: 3 ]

SELECT * FROM M_InOut_Post0 ('05874126A59C4B849CA6FAC47A5DF6CF');

Date: 2026-07-19 09:47:10 Duration: 2s386ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('C7CB9D738AB3454DA75EFF5A324CE117');

Date: 2026-07-19 09:57:29 Duration: 2s70ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM M_InOut_Post0 ('2657727F454341248385F51316384065');

Date: 2026-07-19 09:51:09 Duration: 2s31ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

35,831 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	3	0.01%
LOG	35,828	99.99%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
0 ERROR entries
0 WARNING entries
0 EVENTLOG entries

Events per 5 minutes

NO DATASET

Most Frequent Errors/Events

Key values

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

Rank	Times reported	Error
NO DATASET

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

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Vacuum throughput per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values