pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jul 16 23:00:10 2026
Log file: /var/log/postgresql/postgresql-14-main.log
Parsed 90,880 log entries in 8s
Log start from 2026-07-16 07:00:01 to 2026-07-16 22:00:00

Global Stats

4 Number of unique normalized queries
174 Number of queries
4m31s Total query duration
2026-07-16 07:00:04 First query
2026-07-16 21:59:30 Last query
1 queries/s at 2026-07-16 13:19:33 Query peak

4m31s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4m31s Execute total duration

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

928 Total number of automatic vacuums
168 Total number of automatic analyzes

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

10,563 Total number of sessions
28 sessions at 2026-07-16 21:00:02 Session peak
3d36m59s Total duration of sessions
24s748ms Average duration of sessions
0 Average queries per session
25ms Average queries duration per session
24s722ms Average idle time per session

10,563 Total number of connections
10 connections/s at 2026-07-16 13:55:07 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-16 13:19:33 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-16 13:39:32 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-07-16 13:19:33 Date

Queries duration

Key values

4m31s 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 16	07	10	0ms	2s733ms	1s631ms	1s455ms	2s730ms	3s500ms
	08	16	0ms	2s813ms	1s400ms	2s761ms	3s476ms	3s494ms
	09	11	0ms	2s814ms	1s606ms	1s548ms	2s569ms	2s814ms
	10	11	0ms	2s872ms	1s600ms	1s543ms	2s711ms	3s468ms
	11	12	0ms	2s817ms	1s550ms	1s541ms	2s782ms	3s547ms
	12	15	0ms	2s829ms	1s451ms	2s567ms	3s519ms	3s541ms
	13	15	0ms	2s780ms	1s441ms	2s461ms	3s495ms	3s538ms
	14	9	0ms	2s805ms	1s721ms	1s508ms	2s453ms	2s805ms
	15	11	0ms	2s803ms	1s596ms	1s476ms	2s759ms	3s479ms
	16	13	0ms	2s720ms	1s494ms	1s562ms	2s720ms	3s494ms
	17	9	0ms	2s762ms	1s736ms	1s521ms	2s548ms	2s762ms
	18	10	0ms	2s700ms	1s620ms	1s468ms	2s585ms	3s495ms
	19	13	0ms	2s764ms	1s501ms	2s490ms	2s638ms	3s509ms
	20	9	0ms	2s688ms	1s703ms	1s481ms	2s500ms	2s688ms
	21	10	0ms	2s672ms	1s640ms	1s517ms	2s566ms	2s672ms
	22	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	7	1s404ms	0ms	1s439ms	1s551ms
	08	10	1s279ms	0ms	1s452ms	2s469ms
	09	6	1s513ms	0ms	1s453ms	1s553ms
	10	7	1s428ms	0ms	1s465ms	1s546ms
	11	8	1s372ms	0ms	1s465ms	2s462ms
	12	9	1s345ms	0ms	1s509ms	2s498ms
	13	9	1s332ms	0ms	1s460ms	2s493ms
	14	7	1s420ms	0ms	1s449ms	1s544ms
	15	7	1s424ms	0ms	1s461ms	1s567ms
	16	8	1s375ms	0ms	1s462ms	2s471ms
	17	6	1s523ms	0ms	1s464ms	1s549ms
	18	7	1s416ms	0ms	1s458ms	1s562ms
	19	9	1s342ms	0ms	1s481ms	2s490ms
	20	6	1s495ms	0ms	1s459ms	1s518ms
	21	7	1s436ms	0ms	1s463ms	1s565ms
	22	0	0ms	0ms	0ms	0ms

Day	Hour	UPDATE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	3	2s161ms	0ms	0ms	1s21ms
	08	6	1s602ms	0ms	0ms	1s17ms
	09	5	1s718ms	0ms	0ms	1s13ms
	10	4	1s902ms	0ms	0ms	1s22ms
	11	4	1s906ms	0ms	0ms	1s17ms
	12	6	1s610ms	0ms	0ms	1s44ms
	13	6	1s604ms	0ms	0ms	1s43ms
	14	2	2s778ms	0ms	0ms	0ms
	15	4	1s897ms	0ms	0ms	1s15ms
	16	5	1s684ms	0ms	0ms	1s23ms
	17	3	2s162ms	0ms	0ms	1s27ms
	18	3	2s97ms	0ms	0ms	1s8ms
	19	4	1s859ms	0ms	0ms	1s18ms
	20	3	2s118ms	0ms	0ms	1s9ms
	21	3	2s114ms	0ms	0ms	1s5ms
	22	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 16	07	10	10.00	0.00%
	08	16	16.00	0.00%
	09	11	11.00	0.00%
	10	11	11.00	0.00%
	11	12	12.00	0.00%
	12	15	15.00	0.00%
	13	15	15.00	0.00%
	14	9	9.00	0.00%
	15	11	11.00	0.00%
	16	13	13.00	0.00%
	17	9	9.00	0.00%
	18	10	10.00	0.00%
	19	13	13.00	0.00%
	20	9	9.00	0.00%
	21	10	10.00	0.00%
	22	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jul 16	07	699	0.19/s
	08	707	0.20/s
	09	705	0.20/s
	10	704	0.20/s
	11	704	0.20/s
	12	704	0.20/s
	13	704	0.20/s
	14	704	0.20/s
	15	703	0.20/s
	16	703	0.20/s
	17	704	0.20/s
	18	704	0.20/s
	19	704	0.20/s
	20	704	0.20/s
	21	706	0.20/s
	22	4	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Jul 16	07	703	11s661ms	11s638ms
	08	707	20s220ms	20s189ms
	09	705	29s910ms	29s885ms
	10	704	17s646ms	17s621ms
	11	704	17s645ms	17s619ms
	12	704	43s214ms	43s183ms
	13	704	20s203ms	20s172ms
	14	704	32s987ms	32s965ms
	15	703	16s782ms	16s757ms
	16	703	24s464ms	24s437ms
	17	704	40s658ms	40s636ms
	18	704	15s90ms	15s67ms
	19	704	22s760ms	22s732ms
	20	704	32s987ms	32s965ms
	21	706	24s975ms	24s952ms
	22	0	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

10 connections Connection Peak
2026-07-16 13:55:07 Date

Connections per database

Key values

etendo Main Database
10,563 connections Total

Chart
Table

Database	User	Count
etendo		6,228
	postgres	2,940
	tad	3,288
postgres		15
	postgres	15
template1		4,320
	postgres	4,320

Connections per user

Key values

postgres Main User
10,563 connections Total

Chart
Table

User	Count
postgres	7,275
tad	3,288

Connections per host

Key values

[local] Main host with 7275 connections
10,563 Total connections

Chart
Table

Host	Count
127.0.0.1	3,288
[local]	7,275

Simultaneous sessions

Key values

28 sessions Session Peak
2026-07-16 21:00:02 Date

Histogram of session times

Key values

10,425 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	10,425	98.69%
500ms-1s	30	0.28%
1s-30s	0	0.00%
30s-1m	0	0.00%
1m-10m	32	0.30%
10m-30m	27	0.26%
30m-1h	23	0.22%
1h-8h	26	0.25%
> 8h	0	0.00%

Sessions per database

Key values

etendo Main Database
10,563 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	6,228	3d36m23s	41s969ms
postgres	15	710ms	47ms
template1	4,320	34s816ms	8ms

Sessions per user

Key values

postgres Main User
10,563 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	7,275	1m32s	12ms
tad	3,288	3d35m27s	1m19s

Sessions per host

Key values

[local] Main Host
10,563 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	3,288	3d35m27s	1m19s
[local]	7,275	1m32s	12ms

Sessions per application

Key values

[unknown] Main Application
10,563 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	7,200	1m3s	8ms
openbravo	108	3d34m10s	40m18s
pg_profile	45	13s781ms	306ms
psql	3,210	1m31s	28ms

Checkpoints Buffers

Key values

7,788 buffers Checkpoint Peak
2026-07-16 19:06:35 Date
270.044 seconds Highest write time
0.004 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2026-07-16 19:06:35 Date

Checkpoints distance

Key values

110.27 Mo Distance Peak
2026-07-16 19:06:35 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 16	07	18,187	1,106.251s	0.015s	1,106.302s
	08	17,887	1,097.875s	0.015s	1,097.923s
	09	17,676	1,078.796s	0.014s	1,078.844s
	10	21,299	1,313.695s	0.013s	1,313.738s
	11	17,411	1,076.759s	0.015s	1,076.807s
	12	17,574	1,076.839s	0.017s	1,076.886s
	13	19,086	1,108.317s	0.014s	1,108.371s
	14	17,468	1,065.197s	0.013s	1,065.245s
	15	17,924	1,092.495s	0.015s	1,092.548s
	16	17,528	1,064.161s	0.014s	1,064.205s
	17	16,715	1,077.187s	0.012s	1,077.231s
	18	17,691	1,074.156s	0.014s	1,074.204s
	19	19,426	1,068.287s	0.014s	1,068.332s
	20	17,628	1,066.176s	0.014s	1,066.223s
	21	18,408	1,136.335s	0.018s	1,136.39s
	22	0	0s	0s	0s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 16	07	8	519	0.002s	0.01s
	08	7	440	0.002s	0.01s
	09	7	433	0.002s	0.01s
	10	8	430	0.002s	0.009s
	11	7	421	0.001s	0.01s
	12	7	428	0.002s	0.01s
	13	8	436	0.002s	0.011s
	14	7	404	0.001s	0.009s
	15	8	415	0.002s	0.01s
	16	7	413	0.002s	0.009s
	17	7	418	0.001s	0.01s
	18	7	416	0.002s	0.01s
	19	8	408	0.002s	0.009s
	20	7	403	0.002s	0.009s
	21	7	435	0.002s	0.012s
	22	0	0	0s	0s

Day	Hour	Avg time (sec)
Jul 16	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s

Day	Hour	Mean distance	Mean estimate
Jul 16	07	12,223.80 kB	40,180.00 kB
	08	12,000.80 kB	39,114.80 kB
	09	11,987.30 kB	40,078.40 kB
	10	13,698.22 kB	40,686.00 kB
	11	11,919.20 kB	39,900.20 kB
	12	11,951.70 kB	39,951.40 kB
	13	11,196.18 kB	39,304.18 kB
	14	13,216.00 kB	40,578.78 kB
	15	12,095.50 kB	40,348.40 kB
	16	13,258.33 kB	40,809.89 kB
	17	12,031.30 kB	40,278.30 kB
	18	12,055.30 kB	40,416.90 kB
	19	13,812.78 kB	42,638.11 kB
	20	12,695.56 kB	38,614.44 kB
	21	9,808.42 kB	37,137.50 kB
	22	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (148) Main checkpoint cause
148 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	148
Total	148

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 16	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0.93 sec Highest CPU-cost vacuum
Table public.ad_process_run
Database etendo
2026-07-16 10:20:26 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

0.93 sec Highest CPU-cost vacuum
Table public.ad_process_run
Database etendo
2026-07-16 10:20:26 Date

Analyzes per table

Key values

public.c_bpartner (30) Main table analyzed (database etendo)
168 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.public.c_bpartner	30
etendo.public.c_order	30
etendo.profile.last_stat_indexes_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.public.ad_process_request	6
etendo.profile.last_stat_activity_count_srv1	4
etendo.profile.last_extension_versions	4
etendo.profile.tables_list	4
etendo.profile.stmt_list	4
etendo.profile.indexes_list	3
etendo.profile.last_stat_slru	3
etendo.profile.sample_stat_user_functions	2
etendo.profile.sample_stat_indexes	2
etendo.pg_catalog.pg_attribute	1
etendo.profile.sample_stat_wal	1
etendo.profile.samples	1
etendo.pg_catalog.pg_class	1
etendo.pg_catalog.pg_type	1
etendo.profile.sample_stat_archiver	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.sample_stat_database	1
etendo.profile.funcs_list	1
etendo.pg_catalog.pg_shdepend	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_statements_total	1
etendo.profile.sample_stat_cluster	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_tables	1
etendo.profile.sample_stat_slru	1
Total	168

Vacuums per table

Key values

public.c_bpartner (262) Main table vacuumed on database etendo
928 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.c_bpartner	262	30	1,304,522	0	48,164	0	0	263,518	49,100	211,873,123	0	0
etendo.profile.last_stat_tables_srv1	160	15	107,387	0	4,950	0	0	11,235	3,473	2,813,039	0	0
etendo.profile.last_stat_statements_srv1	160	15	32,807	0	1,041	0	0	2,550	909	3,321,298	0	0
etendo.profile.last_stat_user_functions_srv1	160	15	21,515	0	810	0	0	1,910	681	2,843,768	0	0
etendo.profile.last_stat_indexes_srv1	160	15	134,327	0	6,278	0	0	14,191	4,395	3,884,743	0	0
etendo.pg_toast.pg_toast_2619	5	5	3,969	0	798	0	225	2,337	720	2,056,242	0	0
etendo.profile.stmt_list	4	4	697	0	25	0	0	220	22	163,542	0	0
etendo.profile.tables_list	2	2	354	0	14	0	0	103	12	84,584	0	0
etendo.profile.last_extension_versions	2	2	108	0	8	0	0	8	2	16,930	0	0
etendo.profile.last_stat_activity_count_srv1	2	0	72	0	7	0	0	12	6	30,772	0	0
etendo.profile.indexes_list	2	2	262	0	11	0	0	36	8	59,167	0	0
etendo.profile.sample_stat_indexes	1	1	558	0	186	0	0	269	43	117,423	0	0
etendo.profile.sample_statements	1	1	1,606	0	637	0	0	903	136	300,229	0	0
etendo.profile.sample_stat_tables_total	1	1	209	0	53	0	0	73	15	39,618	0	0
postgres.pg_catalog.pg_shdepend	1	1	254	0	32	0	0	53	12	36,798	0	0
etendo.profile.sample_stat_user_functions	1	1	342	0	103	0	0	154	27	104,840	0	0
etendo.profile.last_stat_database_srv1	1	1	57	0	4	0	0	3	1	7,707	0	0
etendo.public.ad_process_run	1	1	7,486	0	3,700	0	0	4,050	611	3,922,169	0	0
etendo.pg_catalog.pg_statistic	1	1	1,973	0	302	0	0	863	382	1,698,111	0	0
etendo.profile.last_stat_slru	1	1	55	0	4	0	0	4	1	8,297	0	0
Total	928	114	1,618,560	177	67,127	0	225	302,492	60,556	233,382,400	0	0

Vacuum throughput per table

Key values

public.c_bpartner (29.8599999999999) 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.c_bpartner	0	0	29.8599999999999
etendo.profile.last_stat_tables_srv1	0	0	1.24
etendo.profile.last_stat_statements_srv1	0	0	0.18
etendo.profile.last_stat_user_functions_srv1	0	0	0.15
etendo.profile.last_stat_indexes_srv1	0	0	1.76
etendo.pg_toast.pg_toast_2619	0	0	0.19
etendo.profile.stmt_list	0	0	0
etendo.profile.tables_list	0	0	0
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.indexes_list	0	0	0
etendo.profile.sample_stat_indexes	0	0	0.05
etendo.profile.sample_statements	0	0	0.17
etendo.profile.sample_stat_tables_total	0	0	0.01
postgres.pg_catalog.pg_shdepend	0	0	0.03
etendo.profile.sample_stat_user_functions	0	0	0.02
etendo.profile.last_stat_database_srv1	0	0	0
etendo.public.ad_process_run	0	0	0.93
etendo.pg_catalog.pg_statistic	0	0	0.1
etendo.profile.last_stat_slru	0	0	0
Total	0	0	34.6899999999999

Tuples removed per table

Key values

public.c_bpartner (228870) Main table with removed tuples on database etendo
405159 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.public.c_bpartner	262	30	228,870	3,552,052	1,769,928	0	234,490
etendo.profile.last_stat_indexes_srv1	160	15	90,729	1,356,569	877,049	600	57,342
etendo.profile.last_stat_tables_srv1	160	15	58,584	865,773	566,321	0	46,240
etendo.profile.last_stat_statements_srv1	160	15	9,661	172,162	93,352	10	8,170
etendo.profile.last_stat_user_functions_srv1	160	15	9,513	186,040	91,960	0	6,240
etendo.profile.sample_statements	1	1	2,252	12,758	74	0	614
etendo.pg_toast.pg_toast_2619	5	5	1,894	9,231	59	0	3,340
etendo.profile.sample_stat_user_functions	1	1	917	7,906	46	0	89
etendo.pg_catalog.pg_statistic	1	1	865	11,126	605	0	782
etendo.profile.sample_stat_indexes	1	1	856	9,146	51	0	169
etendo.public.ad_process_run	1	1	264	34,200	0	0	3,342
etendo.profile.sample_stat_tables_total	1	1	252	1,530	18	0	48
etendo.profile.stmt_list	4	4	122	1,345	83	0	120
etendo.profile.tables_list	2	2	110	2,071	82	0	54
etendo.profile.last_extension_versions	2	2	96	32	16	0	2
etendo.profile.last_stat_activity_count_srv1	2	0	96	16	16	0	4
etendo.profile.last_stat_slru	1	1	48	8	4	0	1
etendo.profile.indexes_list	2	2	21	493	25	0	14
postgres.pg_catalog.pg_shdepend	1	1	9	2,244	0	29	29
etendo.profile.last_stat_database_srv1	1	1	0	8	4	0	1
Total	928	114	405,159	6,224,710	3,399,693	639	361,091

Pages removed per table

Key values

profile.last_stat_indexes_srv1 (600) Main table with removed pages on database etendo
639 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.profile.last_stat_indexes_srv1	160	15	90729	600
postgres.pg_catalog.pg_shdepend	1	1	9	29
etendo.profile.last_stat_statements_srv1	160	15	9661	10
etendo.profile.sample_stat_indexes	1	1	856	0
etendo.profile.sample_statements	1	1	2252	0
etendo.profile.sample_stat_tables_total	1	1	252	0
etendo.public.c_bpartner	262	30	228870	0
etendo.profile.stmt_list	4	4	122	0
etendo.profile.sample_stat_user_functions	1	1	917	0
etendo.profile.last_stat_tables_srv1	160	15	58584	0
etendo.pg_toast.pg_toast_2619	5	5	1894	0
etendo.profile.last_stat_database_srv1	1	1	0	0
etendo.public.ad_process_run	1	1	264	0
etendo.profile.tables_list	2	2	110	0
etendo.profile.last_stat_user_functions_srv1	160	15	9513	0
etendo.profile.last_extension_versions	2	2	96	0
etendo.profile.last_stat_activity_count_srv1	2	0	96	0
etendo.profile.indexes_list	2	2	21	0
etendo.pg_catalog.pg_statistic	1	1	865	0
etendo.profile.last_stat_slru	1	1	48	0
Total	928	114	405,159	639

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 16	07	62	15
	08	58	10
	09	63	12
	10	67	9
	11	62	10
	12	63	9
	13	67	15
	14	62	10
	15	64	15
	16	68	11
	17	63	9
	18	56	11
	19	57	11
	20	58	8
	21	58	13
	22	0	0

↑ 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

113 Total read queries
61 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	113	64.94%
INSERT	0	0.00%
UPDATE	61	35.06%
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
174 Requests
4m31s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	174	4m31s
	select	113	2m37s
	update	61	1m53s

Queries by user

Key values

tad Main user
174 Requests

Queries Chart
Table

User	Request type	Count	Duration
tad	Total	174	4m31s
	select	113	2m37s
	update	61	1m53s

Duration by user

Key values

4m31s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
tad	Total	174	4m31s
	select	113	2m37s
	update	61	1m53s

Queries by host

Key values

127.0.0.1 Main host
174 Requests
4m31s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	174	4m31s
	select	113	2m37s
	update	61	1m53s

Queries by application

Key values

openbravo Main application
174 Requests
4m31s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	174	4m31s
	select	113	2m37s
	update	61	1m53s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-16 20:04:35 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

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

Slowest individual queries


[ Date: 2026-07-16 10:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 11:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 08:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 14:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 15:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 11:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 13:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 19:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 13:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 17:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 08:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 15:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 14:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 16:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	2s872ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 10:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	2s829ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 12:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	2s817ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 11:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	2s814ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5	2s813ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 08:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	2s805ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 14:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	2s803ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 15:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	2s782ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 11:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9	2s780ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 13:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	2s764ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 19:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	2s763ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 13:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12	2s762ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 17:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	2s761ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 08:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	2s759ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 15:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15	2s753ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 09:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16	2s751ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 14:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	2s733ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 07:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18	2s730ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 07:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19	2s723ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 12:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20	2s720ms	update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id); [ Date: 2026-07-16 16:30:04 - 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

2m14s

90

Details

1s439ms

1s573ms

1s494ms

select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 16	07	6	8s815ms	1s469ms
	08	6	8s763ms	1s460ms
	09	6	9s80ms	1s513ms
	10	6	8s986ms	1s497ms
	11	6	8s954ms	1s492ms
	12	6	9s35ms	1s505ms
	13	6	8s918ms	1s486ms
	14	6	8s937ms	1s489ms
	15	6	8s963ms	1s493ms
	16	6	8s962ms	1s493ms
	17	6	9s142ms	1s523ms
	18	6	8s899ms	1s483ms
	19	6	9s37ms	1s506ms
	20	6	8s973ms	1s495ms
	21	6	9s53ms	1s508ms

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

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

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 17:39:30 Duration: 1s573ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 19:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

1m22s

30

Details

2s585ms

2s872ms

2s740ms

update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 16	07	2	5s464ms	2s732ms
	08	2	5s574ms	2s787ms
	09	2	5s568ms	2s784ms
	10	2	5s584ms	2s792ms
	11	2	5s600ms	2s800ms
	12	2	5s552ms	2s776ms
	13	2	5s544ms	2s772ms
	14	2	5s557ms	2s778ms
	15	2	5s563ms	2s781ms
	16	2	5s370ms	2s685ms
	17	2	5s461ms	2s730ms
	18	2	5s285ms	2s642ms
	19	2	5s403ms	2s701ms
	20	2	5s344ms	2s672ms
	21	2	5s339ms	2s669ms

[ User: tad - Total duration: 1m22s - Times executed: 30 ]

[ Application: openbravo - Total duration: 1m22s - Times executed: 30 ]

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 10:30:04 Duration: 2s872ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 12:30:04 Duration: 2s829ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 11:30:04 Duration: 2s817ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

3

31s496ms

31

Details

1s

1s44ms

1s16ms

update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s21ms	1s21ms
	08	4	4s39ms	1s9ms
	09	3	3s25ms	1s8ms
	10	2	2s27ms	1s13ms
	11	2	2s27ms	1s13ms
	12	4	4s113ms	1s28ms
	13	4	4s83ms	1s20ms
	15	2	2s25ms	1s12ms
	16	3	3s49ms	1s16ms
	17	1	1s27ms	1s27ms
	18	1	1s8ms	1s8ms
	19	2	2s32ms	1s16ms
	20	1	1s9ms	1s9ms
	21	1	1s5ms	1s5ms

[ User: tad - Total duration: 31s496ms - Times executed: 31 ]

[ Application: openbravo - Total duration: 31s496ms - Times executed: 31 ]

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:59:33 Duration: 1s44ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 13:29:33 Duration: 1s43ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:29:33 Duration: 1s32ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

4

23s352ms

23

Details

1s

1s45ms

1s15ms

select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) 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 #4

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s17ms	1s17ms
	08	4	4s31ms	1s7ms
	10	1	1s11ms	1s11ms
	11	2	2s26ms	1s13ms
	12	3	3s75ms	1s25ms
	13	3	3s73ms	1s24ms
	14	1	1s2ms	1s2ms
	15	1	1s9ms	1s9ms
	16	2	2s40ms	1s20ms
	18	1	1s14ms	1s14ms
	19	3	3s44ms	1s14ms
	21	1	1s4ms	1s4ms

[ User: tad - Total duration: 23s352ms - Times executed: 23 ]

[ Application: openbravo - Total duration: 23s352ms - Times executed: 23 ]

SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:19:32 Duration: 1s45ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 12:59:32 Duration: 1s41ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:29:32 Duration: 1s27ms 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

2m14s

1s439ms

1s573ms

1s494ms

select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 16	07	6	8s815ms	1s469ms
	08	6	8s763ms	1s460ms
	09	6	9s80ms	1s513ms
	10	6	8s986ms	1s497ms
	11	6	8s954ms	1s492ms
	12	6	9s35ms	1s505ms
	13	6	8s918ms	1s486ms
	14	6	8s937ms	1s489ms
	15	6	8s963ms	1s493ms
	16	6	8s962ms	1s493ms
	17	6	9s142ms	1s523ms
	18	6	8s899ms	1s483ms
	19	6	9s37ms	1s506ms
	20	6	8s973ms	1s495ms
	21	6	9s53ms	1s508ms

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

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

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 17:39:30 Duration: 1s573ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 19:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

31

Details

31s496ms

1s

1s44ms

1s16ms

update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s21ms	1s21ms
	08	4	4s39ms	1s9ms
	09	3	3s25ms	1s8ms
	10	2	2s27ms	1s13ms
	11	2	2s27ms	1s13ms
	12	4	4s113ms	1s28ms
	13	4	4s83ms	1s20ms
	15	2	2s25ms	1s12ms
	16	3	3s49ms	1s16ms
	17	1	1s27ms	1s27ms
	18	1	1s8ms	1s8ms
	19	2	2s32ms	1s16ms
	20	1	1s9ms	1s9ms
	21	1	1s5ms	1s5ms

[ User: tad - Total duration: 31s496ms - Times executed: 31 ]

[ Application: openbravo - Total duration: 31s496ms - Times executed: 31 ]

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:59:33 Duration: 1s44ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 13:29:33 Duration: 1s43ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:29:33 Duration: 1s32ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

3

30

Details

1m22s

2s585ms

2s872ms

2s740ms

update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 16	07	2	5s464ms	2s732ms
	08	2	5s574ms	2s787ms
	09	2	5s568ms	2s784ms
	10	2	5s584ms	2s792ms
	11	2	5s600ms	2s800ms
	12	2	5s552ms	2s776ms
	13	2	5s544ms	2s772ms
	14	2	5s557ms	2s778ms
	15	2	5s563ms	2s781ms
	16	2	5s370ms	2s685ms
	17	2	5s461ms	2s730ms
	18	2	5s285ms	2s642ms
	19	2	5s403ms	2s701ms
	20	2	5s344ms	2s672ms
	21	2	5s339ms	2s669ms

[ User: tad - Total duration: 1m22s - Times executed: 30 ]

[ Application: openbravo - Total duration: 1m22s - Times executed: 30 ]

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 10:30:04 Duration: 2s872ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 12:30:04 Duration: 2s829ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 11:30:04 Duration: 2s817ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

4

23

Details

23s352ms

1s

1s45ms

1s15ms

select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) 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 #4

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s17ms	1s17ms
	08	4	4s31ms	1s7ms
	10	1	1s11ms	1s11ms
	11	2	2s26ms	1s13ms
	12	3	3s75ms	1s25ms
	13	3	3s73ms	1s24ms
	14	1	1s2ms	1s2ms
	15	1	1s9ms	1s9ms
	16	2	2s40ms	1s20ms
	18	1	1s14ms	1s14ms
	19	3	3s44ms	1s14ms
	21	1	1s4ms	1s4ms

[ User: tad - Total duration: 23s352ms - Times executed: 23 ]

[ Application: openbravo - Total duration: 23s352ms - Times executed: 23 ]

SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:19:32 Duration: 1s45ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 12:59:32 Duration: 1s41ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:29:32 Duration: 1s27ms 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

2s585ms

2s872ms

2s740ms

30

Details

1m22s

update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 16	07	2	5s464ms	2s732ms
	08	2	5s574ms	2s787ms
	09	2	5s568ms	2s784ms
	10	2	5s584ms	2s792ms
	11	2	5s600ms	2s800ms
	12	2	5s552ms	2s776ms
	13	2	5s544ms	2s772ms
	14	2	5s557ms	2s778ms
	15	2	5s563ms	2s781ms
	16	2	5s370ms	2s685ms
	17	2	5s461ms	2s730ms
	18	2	5s285ms	2s642ms
	19	2	5s403ms	2s701ms
	20	2	5s344ms	2s672ms
	21	2	5s339ms	2s669ms

[ User: tad - Total duration: 1m22s - Times executed: 30 ]

[ Application: openbravo - Total duration: 1m22s - Times executed: 30 ]

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 10:30:04 Duration: 2s872ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 12:30:04 Duration: 2s829ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-16 11:30:04 Duration: 2s817ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

2

1s439ms

1s573ms

1s494ms

90

Details

2m14s

select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 16	07	6	8s815ms	1s469ms
	08	6	8s763ms	1s460ms
	09	6	9s80ms	1s513ms
	10	6	8s986ms	1s497ms
	11	6	8s954ms	1s492ms
	12	6	9s35ms	1s505ms
	13	6	8s918ms	1s486ms
	14	6	8s937ms	1s489ms
	15	6	8s963ms	1s493ms
	16	6	8s962ms	1s493ms
	17	6	9s142ms	1s523ms
	18	6	8s899ms	1s483ms
	19	6	9s37ms	1s506ms
	20	6	8s973ms	1s495ms
	21	6	9s53ms	1s508ms

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

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

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 17:39:30 Duration: 1s573ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 19:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:09:30 Duration: 1s567ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

3

1s

1s44ms

1s16ms

31

Details

31s496ms

update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s21ms	1s21ms
	08	4	4s39ms	1s9ms
	09	3	3s25ms	1s8ms
	10	2	2s27ms	1s13ms
	11	2	2s27ms	1s13ms
	12	4	4s113ms	1s28ms
	13	4	4s83ms	1s20ms
	15	2	2s25ms	1s12ms
	16	3	3s49ms	1s16ms
	17	1	1s27ms	1s27ms
	18	1	1s8ms	1s8ms
	19	2	2s32ms	1s16ms
	20	1	1s9ms	1s9ms
	21	1	1s5ms	1s5ms

[ User: tad - Total duration: 31s496ms - Times executed: 31 ]

[ Application: openbravo - Total duration: 31s496ms - Times executed: 31 ]

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:59:33 Duration: 1s44ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 13:29:33 Duration: 1s43ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-16 12:29:33 Duration: 1s32ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes

4

1s

1s45ms

1s15ms

23

Details

23s352ms

select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) 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 #4

Day	Hour	Count	Duration	Avg duration
Jul 16	07	1	1s17ms	1s17ms
	08	4	4s31ms	1s7ms
	10	1	1s11ms	1s11ms
	11	2	2s26ms	1s13ms
	12	3	3s75ms	1s25ms
	13	3	3s73ms	1s24ms
	14	1	1s2ms	1s2ms
	15	1	1s9ms	1s9ms
	16	2	2s40ms	1s20ms
	18	1	1s14ms	1s14ms
	19	3	3s44ms	1s14ms
	21	1	1s4ms	1s4ms

[ User: tad - Total duration: 23s352ms - Times executed: 23 ]

[ Application: openbravo - Total duration: 23s352ms - Times executed: 23 ]

SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:19:32 Duration: 1s45ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 12:59:32 Duration: 1s41ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-16 13:29:32 Duration: 1s27ms 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

45,295 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	144	0.32%
FATAL	615	1.36%
HINT	2	0.00%
LOG	44,534	98.32%

Events distribution (except queries)

Key values

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

Most Frequent Errors/Events

Key values

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


Date: 2026-07-16 07:01:14
Database: postgres
Application: [unknown]
User: test
Remote: 186.236.254.56
Date: 2026-07-16 08:56:18
Database: postgres
Application: [unknown]
User: postgres
Remote: 213.209.159.66
Date: 2026-07-16 08:41:57
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 213.209.159.66
Date: 2026-07-16 08:41:57
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 213.209.159.66
Date: 2026-07-16 08:41:57
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 213.209.159.66
Date: 2026-07-16 13:45:57
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 156.225.1.101
Date: 2026-07-16 09:48:43
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 35.187.180.20
Date: 2026-07-16 19:57:20
Database: [unknown]
Application: [unknown]
User: [unknown]
Remote: 20.163.15.96

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

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

Queries by database