pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Jul 18 23:00:15 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 51,401 log entries in 13s
Log start from 2026-07-18 07:00:01 to 2026-07-18 21:59:56

Global Stats

2 Number of unique normalized queries
180 Number of queries
10m19s Total query duration
2026-07-18 07:02:34 First query
2026-07-18 21:52:40 Last query
1 queries/s at 2026-07-18 09:22:34 Query peak

10m19s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
10m19s Execute total duration

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

18,662 Total number of automatic vacuums
180 Total number of automatic analyzes

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

3,261 Total number of sessions
30 sessions at 2026-07-18 21:00:01 Session peak
17h31m56s Total duration of sessions
19s354ms Average duration of sessions
0 Average queries per session
190ms Average queries duration per session
19s164ms Average idle time per session

3,264 Total number of connections
5 connections/s at 2026-07-18 12:00:01 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-18 09:22:34 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-18 09:22:34 Date

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Queries duration

Key values

10m19s 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 18	07	12	0ms	5s268ms	3s446ms	6s838ms	6s888ms	6s946ms
	08	12	0ms	5s248ms	3s400ms	6s709ms	6s803ms	6s865ms
	09	12	0ms	5s247ms	3s421ms	6s776ms	6s853ms	6s898ms
	10	12	0ms	5s642ms	3s439ms	6s773ms	6s827ms	7s269ms
	11	12	0ms	5s279ms	3s431ms	6s805ms	6s886ms	6s911ms
	12	12	0ms	5s355ms	3s456ms	6s867ms	6s904ms	6s972ms
	13	12	0ms	5s323ms	3s453ms	6s862ms	6s920ms	6s966ms
	14	12	0ms	5s260ms	3s429ms	6s797ms	6s841ms	6s927ms
	15	12	0ms	5s374ms	3s463ms	6s844ms	6s928ms	7s12ms
	16	12	0ms	5s408ms	3s448ms	6s820ms	6s887ms	7s40ms
	17	12	0ms	5s223ms	3s409ms	6s780ms	6s817ms	6s855ms
	18	12	0ms	5s240ms	3s416ms	6s770ms	6s852ms	6s873ms
	19	12	0ms	5s868ms	3s494ms	6s844ms	6s898ms	7s491ms
	20	12	0ms	5s499ms	3s477ms	6s827ms	6s920ms	7s167ms
	21	12	0ms	5s591ms	3s465ms	6s766ms	6s898ms	7s233ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 18	07	12	3s446ms	0ms	6s838ms	6s936ms
	08	12	3s400ms	0ms	6s709ms	6s843ms
	09	12	3s421ms	0ms	6s776ms	6s882ms
	10	12	3s439ms	0ms	6s773ms	6s836ms
	11	12	3s431ms	0ms	6s805ms	6s891ms
	12	12	3s456ms	0ms	6s867ms	6s969ms
	13	12	3s453ms	0ms	6s862ms	6s933ms
	14	12	3s429ms	0ms	6s797ms	6s920ms
	15	12	3s463ms	0ms	6s844ms	6s965ms
	16	12	3s448ms	0ms	6s820ms	6s906ms
	17	12	3s409ms	0ms	6s780ms	6s842ms
	18	12	3s416ms	0ms	6s770ms	6s858ms
	19	12	3s494ms	0ms	6s844ms	6s954ms
	20	12	3s477ms	0ms	6s827ms	7s33ms
	21	12	3s465ms	0ms	6s766ms	7s45ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 18	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 18	07	12	12.00	0.00%
	08	12	12.00	0.00%
	09	12	12.00	0.00%
	10	12	12.00	0.00%
	11	12	12.00	0.00%
	12	12	12.00	0.00%
	13	12	12.00	0.00%
	14	12	12.00	0.00%
	15	12	12.00	0.00%
	16	12	12.00	0.00%
	17	12	12.00	0.00%
	18	12	12.00	0.00%
	19	12	12.00	0.00%
	20	12	12.00	0.00%
	21	12	12.00	0.00%

Day	Hour	Count	Average / Second
Jul 18	07	217	0.06/s
	08	217	0.06/s
	09	220	0.06/s
	10	217	0.06/s
	11	217	0.06/s
	12	217	0.06/s
	13	219	0.06/s
	14	217	0.06/s
	15	219	0.06/s
	16	217	0.06/s
	17	217	0.06/s
	18	217	0.06/s
	19	217	0.06/s
	20	217	0.06/s
	21	219	0.06/s

Day	Hour	Count	Average Duration	Average idle time
Jul 18	07	217	20ms	0ms
	08	217	20ms	0ms
	09	219	1m6s	1m5s
	10	217	20ms	0ms
	11	217	20ms	0ms
	12	217	20ms	0ms
	13	217	20ms	0ms
	14	217	21ms	0ms
	15	219	33s180ms	32s990ms
	16	217	21ms	0ms
	17	217	20ms	0ms
	18	217	20ms	0ms
	19	217	21ms	0ms
	20	217	21ms	0ms
	21	219	3m8s	3m8s

↑ Back to the top of the General Activity table

Established Connections

Key values

5 connections Connection Peak
2026-07-18 12:00:01 Date

Connections per database

Key values

etendo Main Database
3,264 connections Total

Chart
Table

Database	User	Count
etendo		3,249
	postgres	60
	tad	3,189
postgres		15
	postgres	15

Connections per user

Key values

tad Main User
3,264 connections Total

Chart
Table

User	Count
postgres	75
tad	3,189

Connections per host

Key values

127.0.0.1 Main host with 3189 connections
3,264 Total connections

Chart
Table

Host	Count
127.0.0.1	3,189
[local]	75

Simultaneous sessions

Key values

30 sessions Session Peak
2026-07-18 21:00:01 Date

Histogram of session times

Key values

3,240 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	3,240	99.36%
500ms-1s	15	0.46%
1s-30s	0	0.00%
30s-1m	0	0.00%
1m-10m	3	0.09%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	2	0.06%
> 8h	1	0.03%

Sessions per database

Key values

etendo Main Database
3,261 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	3,246	17h31m55s	19s444ms
postgres	15	447ms	29ms

Sessions per user

Key values

tad Main User
3,261 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	75	19s483ms	259ms
tad	3,186	17h31m36s	19s804ms

Sessions per host

Key values

127.0.0.1 Main Host
3,261 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	3,186	17h31m36s	19s804ms
[local]	75	19s483ms	259ms

Sessions per application

Key values

psql Main Application
3,261 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
openbravo	6	17h30m48s	2h55m8s
pg_profile	45	8s532ms	189ms
psql	3,210	59s650ms	18ms

Checkpoints Buffers

Key values

12,507 buffers Checkpoint Peak
2026-07-18 13:30:02 Date
809.744 seconds Highest write time
0.009 seconds Sync time

Checkpoints Wal files

Key values

0 files Wal files usage Peak
2026-07-18 21:32:21 Date

Checkpoints distance

Key values

93.36 Mo Distance Peak
2026-07-18 21:25:06 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 18	07	2,773	276.871s	0.005s	276.886s
	08	2,141	213.675s	0.005s	213.691s
	09	2,841	283.786s	0.005s	283.798s
	10	2,326	232.21s	0.004s	232.222s
	11	2,492	248.852s	0.005s	248.87s
	12	2,491	248.551s	0.006s	248.568s
	13	15,125	1,071.097s	0.013s	1,071.125s
	14	2,183	217.877s	0.004s	217.893s
	15	2,990	298.632s	0.004s	298.643s
	16	2,704	269.473s	0.005s	269.493s
	17	2,420	241.614s	0.004s	241.628s
	18	2,480	247.434s	0.004s	247.447s
	19	2,395	239.115s	0.004s	239.131s
	20	2,845	283.919s	0.006s	283.939s
	21	8,048	804.543s	0.014s	804.575s

Day	Hour	Removed	Synced files	Longest sync	Average sync
Jul 18	07	1	264	0.001s	0.004s
	08	1	249	0.001s	0.004s
	09	1	308	0.001s	0.004s
	10	1	254	0.001s	0.004s
	11	2	267	0.001s	0.004s
	12	1	408	0.001s	0.004s
	13	4	487	0.003s	0.004s
	14	1	267	0.001s	0.004s
	15	1	354	0.001s	0.004s
	16	2	605	0.001s	0.004s
	17	1	272	0.001s	0.004s
	18	1	413	0.001s	0.004s
	19	1	269	0.001s	0.004s
	20	2	579	0.001s	0.004s
	21	4	681	0.003s	0.004s

Day	Hour	Avg time (sec)
Jul 18	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 18	07	4,665.25 kB	382,935.00 kB
	08	4,351.00 kB	252,855.75 kB
	09	5,637.75 kB	167,715.50 kB
	10	4,711.50 kB	111,736.25 kB
	11	5,059.25 kB	74,957.50 kB
	12	4,780.25 kB	50,865.75 kB
	13	16,480.00 kB	41,472.25 kB
	14	4,373.75 kB	30,638.50 kB
	15	5,840.50 kB	21,901.00 kB
	16	5,203.50 kB	16,246.75 kB
	17	4,865.75 kB	12,330.50 kB
	18	4,824.25 kB	11,321.00 kB
	19	4,789.50 kB	11,377.75 kB
	20	5,427.25 kB	12,940.50 kB
	21	17,654.75 kB	36,493.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (60) Main checkpoint cause
60 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	60
Total	60

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 18	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

1.82 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo
2026-07-18 13:05:01 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

1.82 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo
2026-07-18 13:05:01 Date

Analyzes per table

Key values

profile.last_stat_statements_srv1 (15) Main table analyzed (database etendo)
180 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.profile.last_stat_statements_srv1	15
etendo.public.prspf_conf	15
etendo.profile.last_stat_indexes_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_tables_srv1	15
etendo.public.pramz_product	15
etendo.public.ad_process_request	10
etendo.profile.tables_list	9
etendo.public.prspf_product	8
etendo.public.prspf_variant	8
etendo.profile.last_stat_io	8
etendo.public.m_storage_detail	6
etendo.public.ad_ep_instance_para	5
etendo.profile.last_extension_versions	5
etendo.profile.stmt_list	5
etendo.profile.last_stat_activity_count_srv1	4
etendo.profile.funcs_list	4
etendo.profile.indexes_list	4
etendo.profile.last_stat_slru	3
etendo.public.c_invoice	2
etendo.profile.sample_stat_indexes	1
etendo.profile.sample_stat_slru	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_user_functions	1
etendo.profile.sample_stat_tables	1
etendo.profile.sample_stat_database	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_stat_io	1
etendo.profile.sample_stat_tables_total	1
Total	180

Vacuums per table

Key values

public.prspf_product (899) Main table vacuumed on database etendo
18,662 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.public.prspf_product	899	0	282,632	0	26	0	0	43	25	201,363	0	0
etendo.public.ad_ep_instance_para	899	0	26,702	0	41	0	0	28	21	166,768	0	0
etendo.profile.last_stat_statements_srv1	899	0	1,178,516	0	0	0	0	28	0	13,244	0	0
etendo.profile.funcs_list	899	0	71,121	0	20	0	0	30	1	15,063	0	0
etendo.public.prspf_variant	899	0	300,713	0	29	0	0	78	30	246,198	0	0
etendo.profile.tables_list	899	0	149,324	0	21	0	0	28	22	167,524	0	0
etendo.public.prspf_conf	899	0	174,974	0	143	0	0	128	44	362,432	0	0
etendo.public.m_storage_detail	899	0	534,683	0	56	0	0	66	39	314,142	4	16
etendo.profile.last_stat_indexes_srv1	899	0	5,656,951	0	9	0	0	28	10	83,124	0	0
etendo.profile.last_stat_io	899	0	40,461	0	66	0	0	28	22	174,598	0	0
etendo.profile.stmt_list	899	0	280,417	0	25	0	0	28	24	190,492	0	0
etendo.profile.indexes_list	899	0	100,631	0	32	0	0	28	24	187,612	0	0
etendo.public.pramz_product	899	0	179,095	0	38	0	0	49	39	310,861	0	0
etendo.public.ad_process_request	899	0	317,042	0	266	0	0	114	58	471,058	0	0
etendo.profile.last_stat_user_functions_srv1	899	0	512,211	0	0	0	0	28	0	13,244	0	0
etendo.profile.last_stat_tables_srv1	899	0	4,543,377	0	9	0	0	28	10	86,524	0	0
etendo.pg_catalog.pg_statistic	868	0	1,833,763	0	450	0	0	114	19	158,657	2	13
etendo.profile.last_extension_versions	779	0	29,876	0	54	0	0	26	22	174,310	0	0
etendo.profile.last_stat_activity_count_srv1	719	0	11,658	0	50	0	0	25	21	130,937	0	0
etendo.pg_toast.pg_toast_2619	538	0	509,166	0	225	0	0	78	26	210,718	0	0
etendo.public.c_invoice	535	0	4,035,950	0	7,622	0	0	6,587	3	423,592	0	0
etendo.profile.last_stat_slru	479	0	16,106	0	34	0	0	18	14	112,766	0	0
etendo.profile.last_stat_database_srv1	360	0	13,271	0	22	0	0	16	8	62,768	0	0
Total	18,662	0	20,798,640	0	9,238	0	0	7,624	482	4,277,995	6	29

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (61.4000000000003) 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.public.prspf_product	0	0	0
etendo.public.ad_ep_instance_para	0	0	0
etendo.profile.last_stat_statements_srv1	0	0	7.81999999999988
etendo.profile.funcs_list	0	0	0
etendo.public.prspf_variant	0	0	0
etendo.profile.tables_list	0	0	0
etendo.public.prspf_conf	0	0	0
etendo.public.m_storage_detail	0	0	0
etendo.profile.last_stat_indexes_srv1	0	0	61.4000000000003
etendo.profile.last_stat_io	0	0	0
etendo.profile.stmt_list	0	0	0
etendo.profile.indexes_list	0	0	0
etendo.public.pramz_product	0	0	0
etendo.public.ad_process_request	0	0	0
etendo.profile.last_stat_user_functions_srv1	0	0	0.07
etendo.profile.last_stat_tables_srv1	0	0	47.7499999999999
etendo.pg_catalog.pg_statistic	0	0	17.2299999999998
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.pg_toast.pg_toast_2619	0	0	1.53
etendo.public.c_invoice	0	0	45.6699999999996
etendo.profile.last_stat_slru	0	0	0
etendo.profile.last_stat_database_srv1	0	0	0
Total	0	0	181.469999999999

Tuples removed per table

Key values

pg_catalog.pg_statistic (14) Main table with removed tuples on database etendo
14 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.pg_catalog.pg_statistic	868	0	14	16,051,282	5,683,745	0	927,865
etendo.public.c_invoice	535	0	0	23,421,400	7,824,375	0	5,197,378
etendo.public.prspf_product	899	0	0	2,695,226	1,360,143	0	118,444
etendo.public.ad_ep_instance_para	899	0	0	93,615	93,615	0	2,423
etendo.profile.last_stat_statements_srv1	899	0	0	10,467,434	9,824,152	0	566,575
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.profile.funcs_list	899	0	0	484,431	230,012	0	14,744
etendo.pg_toast.pg_toast_2619	538	0	0	1,728,588	447,770	0	524,550
etendo.public.prspf_variant	899	0	0	2,312,542	1,832,295	0	142,042
etendo.profile.tables_list	899	0	0	2,440,990	1,412,595	0	53,817
etendo.profile.last_extension_versions	779	0	0	91,143	84,132	0	1,618
etendo.profile.last_stat_slru	479	0	0	37,135	34,740	0	779
etendo.public.prspf_conf	899	0	0	520,847	512,756	0	72,731
etendo.public.m_storage_detail	899	0	0	5,557,468	2,208,054	0	212,142
etendo.profile.last_stat_indexes_srv1	899	0	0	68,899,831	65,932,232	0	2,813,298
etendo.profile.last_stat_io	899	0	0	161,805	148,320	0	3,895
etendo.profile.stmt_list	899	0	0	1,548,052	661,157	0	116,262
etendo.profile.indexes_list	899	0	0	933,233	505,729	0	20,916
etendo.public.pramz_product	899	0	0	1,104,467	958,829	0	70,955
etendo.public.ad_process_request	899	0	0	1,164,100	681,337	0	139,616
etendo.profile.last_stat_user_functions_srv1	899	0	0	7,542,881	6,959,430	0	241,090
etendo.profile.last_stat_tables_srv1	899	0	0	43,413,354	41,609,960	0	2,256,631
Total	18,662	0	14	190,765,488	149,099,602	0	13,501,008

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	Tuples removed
etendo.public.c_invoice	535	0
etendo.public.prspf_product	899	0
etendo.public.ad_ep_instance_para	899	0
etendo.profile.last_stat_statements_srv1	899	0
etendo.profile.last_stat_activity_count_srv1	719	0
etendo.profile.last_stat_database_srv1	360	0
etendo.profile.funcs_list	899	0
etendo.pg_toast.pg_toast_2619	538	0
etendo.public.prspf_variant	899	0
etendo.profile.tables_list	899	0
etendo.profile.last_extension_versions	779	0
etendo.profile.last_stat_slru	479	0
etendo.public.prspf_conf	899	0
etendo.public.m_storage_detail	899	0
etendo.profile.last_stat_indexes_srv1	899	0
etendo.profile.last_stat_io	899	0
etendo.profile.stmt_list	899	0
etendo.pg_catalog.pg_statistic	868	14
etendo.profile.indexes_list	899	0
etendo.public.pramz_product	899	0
etendo.public.ad_process_request	899	0
etendo.profile.last_stat_user_functions_srv1	899	0
etendo.profile.last_stat_tables_srv1	899	0
Total	18,662	14

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 18	07	989	13
	08	1,020	8
	09	1,080	13
	10	1,140	9
	11	1,140	12
	12	1,140	11
	13	1,234	15
	14	1,319	8
	15	1,320	17
	16	1,380	11
	17	1,380	11
	18	1,380	13
	19	1,380	13
	20	1,380	9
	21	1,380	17

↑ 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

180 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	180	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
180 Requests
10m19s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	180	10m19s
	select	180	10m19s

Queries by user

Key values

tad Main user
180 Requests

Queries Chart
Table

User	Request type	Count	Duration
tad	Total	180	10m19s
	select	180	10m19s

Duration by user

Key values

10m19s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
tad	Total	180	10m19s
	select	180	10m19s

Queries by host

Key values

127.0.0.1 Main host
180 Requests
10m19s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	180	10m19s
	select	180	10m19s

Queries by application

Key values

openbravo Main application
180 Requests
10m19s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	180	10m19s
	select	180	10m19s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-18 21:13:56 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

180 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	180	100.00%
> 10000ms	0	0.00%

Slowest individual queries


[ Date: 2026-07-18 19:32:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 10:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 21:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 20:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 21:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 16:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 15:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 12:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 15:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 19:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 13:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 12:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 15:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 20:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 13:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 11:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 21:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 20:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 19:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-18 13:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	5s868ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 19:32:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	5s642ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 10:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	5s591ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 21:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	5s499ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 20:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5	5s420ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 21:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	5s408ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 16:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	5s374ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 15:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	5s355ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 12:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9	5s327ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 15:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	5s324ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 19:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	5s323ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 13:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12	5s314ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 12:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	5s304ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 15:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	5s303ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 20:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15	5s295ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 13:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16	5s279ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 11:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	5s279ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 21:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18	5s276ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 20:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19	5s271ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 19:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20	5s270ms	SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' \|\| op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT() > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date:* 2026-07-18 13:52:40 - 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

7m52s

90

Details

5s94ms

5s868ms

5s249ms

select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	31s421ms	5s236ms
	08	6	31s73ms	5s178ms
	09	6	31s216ms	5s202ms
	10	6	31s560ms	5s260ms
	11	6	31s413ms	5s235ms
	12	6	31s589ms	5s264ms
	13	6	31s584ms	5s264ms
	14	6	31s190ms	5s198ms
	15	6	31s729ms	5s288ms
	16	6	31s529ms	5s254ms
	17	6	31s148ms	5s191ms
	18	6	31s215ms	5s202ms
	19	6	32s164ms	5s360ms
	20	6	31s754ms	5s292ms
	21	6	31s866ms	5s311ms

[ User: tad - Total duration: 7m52s - Times executed: 90 ]

[ Application: openbravo - Total duration: 7m52s - Times executed: 90 ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 19:32:41 Duration: 5s868ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 10:32:40 Duration: 5s642ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 21:12:40 Duration: 5s591ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

2m27s

90

Details

1s604ms

1s730ms

1s637ms

select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	9s938ms	1s656ms
	08	6	9s728ms	1s621ms
	09	6	9s841ms	1s640ms
	10	6	9s709ms	1s618ms
	11	6	9s761ms	1s626ms
	12	6	9s885ms	1s647ms
	13	6	9s861ms	1s643ms
	14	6	9s961ms	1s660ms
	15	6	9s830ms	1s638ms
	16	6	9s854ms	1s642ms
	17	6	9s761ms	1s626ms
	18	6	9s777ms	1s629ms
	19	6	9s773ms	1s628ms
	20	6	9s978ms	1s663ms
	21	6	9s718ms	1s619ms

[ User: tad - Total duration: 2m27s - Times executed: 90 ]

[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]

SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 20:42:34 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 07:22:34 Duration: 1s707ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 14:52:34 Duration: 1s691ms 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

90

Details

7m52s

5s94ms

5s868ms

5s249ms

select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	31s421ms	5s236ms
	08	6	31s73ms	5s178ms
	09	6	31s216ms	5s202ms
	10	6	31s560ms	5s260ms
	11	6	31s413ms	5s235ms
	12	6	31s589ms	5s264ms
	13	6	31s584ms	5s264ms
	14	6	31s190ms	5s198ms
	15	6	31s729ms	5s288ms
	16	6	31s529ms	5s254ms
	17	6	31s148ms	5s191ms
	18	6	31s215ms	5s202ms
	19	6	32s164ms	5s360ms
	20	6	31s754ms	5s292ms
	21	6	31s866ms	5s311ms

[ User: tad - Total duration: 7m52s - Times executed: 90 ]

[ Application: openbravo - Total duration: 7m52s - Times executed: 90 ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 19:32:41 Duration: 5s868ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 10:32:40 Duration: 5s642ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 21:12:40 Duration: 5s591ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

90

Details

2m27s

1s604ms

1s730ms

1s637ms

select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	9s938ms	1s656ms
	08	6	9s728ms	1s621ms
	09	6	9s841ms	1s640ms
	10	6	9s709ms	1s618ms
	11	6	9s761ms	1s626ms
	12	6	9s885ms	1s647ms
	13	6	9s861ms	1s643ms
	14	6	9s961ms	1s660ms
	15	6	9s830ms	1s638ms
	16	6	9s854ms	1s642ms
	17	6	9s761ms	1s626ms
	18	6	9s777ms	1s629ms
	19	6	9s773ms	1s628ms
	20	6	9s978ms	1s663ms
	21	6	9s718ms	1s619ms

[ User: tad - Total duration: 2m27s - Times executed: 90 ]

[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]

SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 20:42:34 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 07:22:34 Duration: 1s707ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 14:52:34 Duration: 1s691ms 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

5s94ms

5s868ms

5s249ms

90

Details

7m52s

select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	31s421ms	5s236ms
	08	6	31s73ms	5s178ms
	09	6	31s216ms	5s202ms
	10	6	31s560ms	5s260ms
	11	6	31s413ms	5s235ms
	12	6	31s589ms	5s264ms
	13	6	31s584ms	5s264ms
	14	6	31s190ms	5s198ms
	15	6	31s729ms	5s288ms
	16	6	31s529ms	5s254ms
	17	6	31s148ms	5s191ms
	18	6	31s215ms	5s202ms
	19	6	32s164ms	5s360ms
	20	6	31s754ms	5s292ms
	21	6	31s866ms	5s311ms

[ User: tad - Total duration: 7m52s - Times executed: 90 ]

[ Application: openbravo - Total duration: 7m52s - Times executed: 90 ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 19:32:41 Duration: 5s868ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 10:32:40 Duration: 5s642ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 21:12:40 Duration: 5s591ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

1s604ms

1s730ms

1s637ms

90

Details

2m27s

select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 18	07	6	9s938ms	1s656ms
	08	6	9s728ms	1s621ms
	09	6	9s841ms	1s640ms
	10	6	9s709ms	1s618ms
	11	6	9s761ms	1s626ms
	12	6	9s885ms	1s647ms
	13	6	9s861ms	1s643ms
	14	6	9s961ms	1s660ms
	15	6	9s830ms	1s638ms
	16	6	9s854ms	1s642ms
	17	6	9s761ms	1s626ms
	18	6	9s777ms	1s629ms
	19	6	9s773ms	1s628ms
	20	6	9s978ms	1s663ms
	21	6	9s718ms	1s619ms

[ User: tad - Total duration: 2m27s - Times executed: 90 ]

[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]

SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 20:42:34 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 07:22:34 Duration: 1s707ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-18 14:52:34 Duration: 1s691ms 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

34,449 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	296	0.86%
DETAIL	180	0.52%
ERROR	296	0.86%
EVENTLOG	1	0.00%
FATAL	557	1.62%
HINT	1	0.00%
LOG	32,822	95.28%
STATEMENT	296	0.86%

Events distribution (except queries)

Key values

0 PANIC entries
557 FATAL entries
296 ERROR entries
0 WARNING entries
1 EVENTLOG entries

Most Frequent Errors/Events

Key values

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


Date: 2026-07-18 07:00:13
Database: postgres
Application: [unknown]
User: db
Remote: 159.65.148.75
Date: 2026-07-18 07:35:34
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-18 14:27:05
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 146.190.64.87
Date: 2026-07-18 07:16:52
Database: postgres
Application: [unknown]
User: postgres
Remote: 64.89.163.83
Date: 2026-07-18 14:27:05
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 146.190.64.87
Date: 2026-07-18 13:49:52
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 156.225.1.112
Date: 2026-07-18 17:40:27
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 184.105.139.67
Date: 2026-07-18 14:27:03
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 206.189.179.51
Date: 2026-07-18 14:26:54
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 206.189.179.51
Date: 2026-07-18 14:27:04
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 206.189.179.51

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