pgBadger-
Global information
- Generated on Sun Jul 19 23:00:20 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 87,807 log entries in 19s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 22:00:00
-
Overview
Global Stats
- 5 Number of unique normalized queries
- 46 Number of queries
- 8m19s Total query duration
- 2026-07-19 07:00:17 First query
- 2026-07-19 21:00:20 Last query
- 2 queries/s at 2026-07-19 07:00:20 Query peak
- 8m19s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8m19s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 56,694 Total number of automatic vacuums
- 126 Total number of automatic analyzes
- 30 Number temporary file
- 154.66 MiB Max size of temporary file
- 132.59 MiB Average size of temporary file
- 3,267 Total number of sessions
- 6 sessions at 2026-07-19 14:00:02 Session peak
- 1d13h34m33s Total duration of sessions
- 41s406ms Average duration of sessions
- 0 Average queries per session
- 152ms Average queries duration per session
- 41s253ms Average idle time per session
- 3,271 Total number of connections
- 5 connections/s at 2026-07-19 22:00:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 07:00:20 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 07:00:20 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 8m19s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 3 0ms 18s897ms 12s376ms 0ms 0ms 37s129ms 08 3 0ms 17s539ms 10s640ms 0ms 0ms 31s920ms 09 3 0ms 17s505ms 10s331ms 0ms 0ms 30s994ms 10 3 0ms 16s215ms 9s854ms 0ms 0ms 29s563ms 11 3 0ms 47s216ms 20s25ms 0ms 0ms 1m 12 3 0ms 17s867ms 10s544ms 0ms 0ms 31s634ms 13 3 0ms 17s90ms 10s94ms 0ms 0ms 30s283ms 14 3 0ms 19s240ms 11s144ms 0ms 0ms 33s434ms 15 4 0ms 17s449ms 8s173ms 0ms 0ms 32s693ms 16 3 0ms 16s576ms 9s680ms 0ms 0ms 29s40ms 17 3 0ms 16s737ms 10s67ms 0ms 0ms 30s202ms 18 3 0ms 16s890ms 9s919ms 0ms 0ms 29s757ms 19 3 0ms 18s239ms 10s649ms 0ms 0ms 31s949ms 20 3 0ms 16s652ms 9s757ms 0ms 0ms 29s271ms 21 3 0ms 18s239ms 10s620ms 0ms 0ms 31s860ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 3 0 12s376ms 0ms 0ms 0ms 08 3 0 10s640ms 0ms 0ms 0ms 09 3 0 10s331ms 0ms 0ms 0ms 10 3 0 9s854ms 0ms 0ms 0ms 11 3 0 20s25ms 0ms 0ms 0ms 12 3 0 10s544ms 0ms 0ms 0ms 13 3 0 10s94ms 0ms 0ms 0ms 14 3 0 11s144ms 0ms 0ms 0ms 15 4 0 8s173ms 0ms 0ms 0ms 16 3 0 9s680ms 0ms 0ms 0ms 17 3 0 10s67ms 0ms 0ms 0ms 18 3 0 9s919ms 0ms 0ms 0ms 19 3 0 10s649ms 0ms 0ms 0ms 20 3 0 9s757ms 0ms 0ms 0ms 21 3 0 10s620ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 19 07 0 2 2.00 0.00% 08 0 2 2.00 0.00% 09 0 2 2.00 0.00% 10 0 2 2.00 0.00% 11 0 2 2.00 0.00% 12 0 2 2.00 0.00% 13 0 2 2.00 0.00% 14 0 2 2.00 0.00% 15 0 3 3.00 0.00% 16 0 2 2.00 0.00% 17 0 2 2.00 0.00% 18 0 2 2.00 0.00% 19 0 2 2.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 19 07 217 0.06/s 08 217 0.06/s 09 219 0.06/s 10 218 0.06/s 11 217 0.06/s 12 219 0.06/s 13 218 0.06/s 14 219 0.06/s 15 218 0.06/s 16 217 0.06/s 17 217 0.06/s 18 217 0.06/s 19 217 0.06/s 20 217 0.06/s 21 219 0.06/s 22 5 0.00/s Day Hour Count Average Duration Average idle time Jul 19 07 217 131ms 0ms 08 217 121ms 0ms 09 220 5m12s 5m12s 10 217 113ms 0ms 11 217 256ms 0ms 12 220 2m12s 2m12s 13 217 116ms 0ms 14 220 34s735ms 34s583ms 15 217 118ms 0ms 16 217 116ms 0ms 17 217 115ms 0ms 18 217 120ms 0ms 19 217 128ms 0ms 20 217 112ms 0ms 21 220 2m12s 2m12s 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-19 22:00:00 Date
Connections per database
Key values
- etendo Main Database
- 3,271 connections Total
Connections per user
Key values
- tad Main User
- 3,271 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-07-19 14:00:02 Date
Histogram of session times
Key values
- 3,224 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,267 sessions Total
Sessions per user
Key values
- tad Main User
- 3,267 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,267 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,253 buffers Checkpoint Peak
- 2026-07-19 14:08:07 Date
- 269.967 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-07-19 14:08:07 Date
Checkpoints distance
Key values
- 53.75 Mo Distance Peak
- 2026-07-19 14:08:07 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 1,906 188.798s 0.012s 188.816s 08 1,929 191.601s 0.012s 191.62s 09 2,145 212.824s 0.012s 212.844s 10 1,982 196.72s 0.012s 196.738s 11 1,817 179.965s 0.012s 179.985s 12 1,871 185.488s 0.012s 185.509s 13 1,918 190.397s 0.013s 190.416s 14 5,537 296.989s 0.012s 297.008s 15 1,874 185.679s 0.012s 185.701s 16 1,931 191.695s 0.012s 191.716s 17 1,786 177.069s 0.012s 177.087s 18 1,837 181.767s 0.012s 181.789s 19 1,972 195.708s 0.012s 195.724s 20 1,811 179.272s 0.012s 179.293s 21 1,871 185.277s 0.012s 185.298s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 0 0 333 0.001s 0.012s 08 0 0 1 329 0.001s 0.012s 09 0 0 1 369 0.001s 0.012s 10 0 0 1 351 0.001s 0.012s 11 0 0 0 337 0.001s 0.012s 12 0 0 1 350 0.001s 0.012s 13 0 0 0 341 0.001s 0.012s 14 0 0 2 381 0.001s 0.012s 15 0 0 1 345 0.001s 0.012s 16 0 0 0 326 0.001s 0.012s 17 0 0 1 323 0.001s 0.012s 18 0 0 1 332 0.001s 0.012s 19 0 0 0 332 0.001s 0.012s 20 0 0 1 332 0.001s 0.012s 21 0 0 1 356 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 19 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 19 07 858.58 kB 5,881.17 kB 08 897.33 kB 6,203.58 kB 09 1,058.25 kB 5,912.08 kB 10 908.17 kB 6,229.33 kB 11 848.08 kB 5,707.08 kB 12 881.50 kB 6,038.67 kB 13 867.50 kB 6,013.25 kB 14 2,337.58 kB 16,475.42 kB 15 872.42 kB 6,014.17 kB 16 881.58 kB 6,095.92 kB 17 846.92 kB 5,888.92 kB 18 860.67 kB 5,902.00 kB 19 885.83 kB 6,081.50 kB 20 848.75 kB 5,804.08 kB 21 849.25 kB 5,722.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 265.19 MiB Temp Files size Peak
- 2026-07-19 20:00:12 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-19 20:00:12 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 2 265.19 MiB 132.59 MiB 08 2 265.19 MiB 132.59 MiB 09 2 265.19 MiB 132.59 MiB 10 2 265.19 MiB 132.59 MiB 11 2 265.19 MiB 132.59 MiB 12 2 265.19 MiB 132.59 MiB 13 2 265.19 MiB 132.59 MiB 14 2 265.19 MiB 132.59 MiB 15 2 265.19 MiB 132.59 MiB 16 2 265.19 MiB 132.59 MiB 17 2 265.19 MiB 132.59 MiB 18 2 265.19 MiB 132.59 MiB 19 2 265.19 MiB 132.59 MiB 20 2 265.19 MiB 132.59 MiB 21 2 265.19 MiB 132.59 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 30 3.88 GiB 110.52 MiB 154.66 MiB 132.59 MiB select * from ( select c_invoice_id as referencekey_id, ;-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;
Date: 2026-07-19 07:00:17 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 07:00:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 08:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 09:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 10:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 11:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 12:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 13:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 14:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 15:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 16:00:11 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 17:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 18:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 19:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 20:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 154.66 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 21:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 110.52 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 07:00:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 110.52 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 08:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 110.52 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 09:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 110.52 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 10:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 110.52 MiB SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;[ Date: 2026-07-19 11:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.29 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-19 21:44:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 4.29 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-19 21:44:51 Date
Analyzes per table
Key values
- profile.last_stat_statements_srv1 (15) Main table analyzed (database etendo)
- 126 analyzes Total
Table Number of analyzes etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.tables_list 13 etendo.profile.last_stat_io 7 etendo.profile.indexes_list 5 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_tables 2 etendo.profile.funcs_list 2 etendo.profile.stmt_list 2 etendo.profile.sample_stat_tables_total 2 etendo.public.ad_process_request 2 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_archiver 1 etendo.profile.last_stat_archiver 1 etendo.profile.samples 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_wal 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_cluster 1 etendo.profile.sample_stat_io 1 etendo.public.ad_module 1 postgres.pg_catalog.pg_shdepend 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_stat_indexes 1 Total 126 Vacuums per table
Key values
- profile.sample_stat_archiver (900) Main table vacuumed on database etendo
- 56,694 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.sample_stat_archiver 900 0 34,488 0 45 0 0 37 0 8,917 0 0 etendo.pg_catalog.pg_class 900 0 203,526 0 21 0 0 19 0 4,579 0 0 etendo.profile.samples 900 0 54,740 0 45 0 0 37 0 8,917 0 0 etendo.public.m_stock_proposed 900 0 199,714 0 37 0 0 37 37 99,309 0 0 etendo.profile.sample_stat_tables 900 0 5,827,288 0 0 0 0 38 0 9,158 0 0 etendo.profile.sample_stat_indexes_total 900 0 82,188 0 45 0 0 37 0 8,917 0 0 etendo.public.ad_session_usage_audit 900 0 10,364,400 0 0 0 0 0 0 0 0 0 etendo.profile.last_stat_archiver 900 0 37,233 0 82 0 0 37 37 91,821 0 0 etendo.profile.sample_stat_user_functions 900 0 382,751 0 30 0 0 37 0 8,917 0 0 etendo.profile.last_stat_io 900 0 495,370 0 30 0 0 37 0 6,956 0 0 etendo.pg_catalog.pg_shdepend 900 0 95,574 0 37 0 0 42 37 81,557 0 0 etendo.pg_toast.pg_toast_125223 900 0 90,492 0 24 0 0 37 24 65,823 0 0 etendo.pg_toast.pg_toast_46165 900 0 4,692,576 0 40 0 0 38 38 100,025 0 0 etendo.profile.funcs_list 900 0 718,886 0 36 0 0 37 0 8,917 0 0 etendo.public.ad_ep_instance_para 900 0 1,063,233 0 36 0 0 37 36 104,555 0 0 etendo.pg_catalog.pg_attribute 900 0 901,186 0 10 0 0 23 2 10,859 0 0 etendo.public.c_invoice 900 0 47,967,628 0 37 0 0 38 37 119,888 0 0 etendo.public.c_bpartner 900 0 913,988 0 398 0 0 1,837 37 341,428 0 0 etendo.profile.sample_stat_wal 900 0 37,151 0 45 0 0 37 0 8,917 0 0 etendo.public.m_storage_detail 900 0 1,653,547 0 0 0 0 37 0 6,956 0 0 etendo.public.ad_pinstance_para 900 0 79,681 0 0 0 0 37 0 6,956 0 0 etendo.profile.sample_stat_cluster 900 0 41,628 0 45 0 0 37 0 8,917 0 0 etendo.pg_catalog.pg_type 900 0 151,378 0 12 0 0 42 0 10,122 0 0 etendo.profile.stmt_list 900 0 4,356,055 0 50 0 0 38 37 82,567 0 0 etendo.profile.sample_stat_slru 900 0 69,791 0 42 0 0 37 0 8,917 0 0 etendo.public.ad_module 900 0 703,915 0 38 0 0 38 38 104,231 0 0 etendo.profile.sample_stat_indexes 900 0 879,843 0 2 0 0 38 0 9,158 0 0 etendo.profile.last_stat_activity_count_srv1 900 0 286,427 0 76 0 0 37 35 87,837 0 0 etendo.public.c_order 900 0 11,458,319 0 1 0 0 0 0 0 0 0 etendo.public.ad_process_request 900 0 3,780,186 0 481 0 0 52 0 9,776 0 0 etendo.pg_toast.pg_toast_2619 900 0 3,800,324 0 50 0 0 41 39 96,575 0 0 etendo.public.ad_pinstance 900 0 363,366 0 0 0 0 37 0 6,956 0 0 etendo.public.ad_sequence 900 0 225,247 0 37 0 0 37 37 99,945 0 0 etendo.profile.last_stat_wal 900 0 45,873 0 45 0 0 37 0 6,956 0 0 etendo.profile.sample_stat_database 900 0 150,437 0 39 0 0 37 0 8,917 0 0 etendo.profile.sample_statements 900 0 2,640,074 0 3 0 0 39 1 11,644 0 0 etendo.public.ad_preference 900 0 1,580,525 0 1 0 0 37 0 6,956 0 0 etendo.public.fin_financial_account 900 0 84,576 0 37 0 0 37 37 103,638 0 0 template1.pg_catalog.pg_shdepend 900 0 103,674 0 37 0 0 42 37 72,601 0 0 etendo.profile.indexes_list 900 0 1,504,776 0 19 0 0 38 1 11,400 0 0 etendo.profile.tables_list 900 0 5,180,826 0 0 0 0 38 0 9,158 0 0 etendo.profile.last_stat_slru 900 0 126,453 0 45 0 0 37 0 6,956 0 0 etendo.profile.sample_stat_tables_total 900 0 217,991 0 36 0 0 37 0 8,917 0 0 etendo.profile.sample_stat_user_func_total 900 0 44,536 0 45 0 0 37 0 8,917 0 0 etendo.profile.sample_statements_total 900 0 88,824 0 45 0 0 37 0 8,917 0 0 etendo.profile.sample_stat_io 900 0 135,528 0 39 0 0 37 0 8,917 0 0 etendo.public.ad_audit_trail 900 0 8,972,100 0 0 0 0 0 0 0 0 0 etendo.pg_catalog.pg_statistic 900 0 36,985,775 0 39 0 0 56 39 119,928 0 0 etendo.profile.last_stat_cluster 900 0 53,433 0 82 0 0 37 37 91,018 0 0 etendo.profile.sample_stat_tablespaces 900 0 55,344 0 45 0 0 37 0 8,917 0 0 etendo.public.ad_process_run 900 0 5,251,205 0 565 0 0 182 180 487,453 0 0 postgres.pg_catalog.pg_shdepend 900 0 103,499 0 50 0 0 47 37 73,650 0 0 etendo.public.m_storage_pending 900 0 1,077,103 0 37 0 0 37 37 97,866 0 0 etendo.profile.last_extension_versions 900 0 162,648 0 64 0 0 38 22 60,525 0 0 etendo.public.ad_session 900 0 1,685,600 0 0 0 0 37 0 6,956 0 0 etendo.profile.servers 900 0 60,689 0 82 0 0 52 37 90,918 15 15 etendo.pg_toast.pg_toast_45833 900 0 293,622 0 0 0 0 37 0 6,956 0 0 etendo.profile.last_stat_statements_srv1 899 0 40,788,340 0 22 0 0 52 22 56,406 0 0 etendo.profile.last_stat_indexes_srv1 899 0 308,276,943 0 2 0 0 52 0 24,596 0 0 etendo.profile.last_stat_database_srv1 899 0 251,180 0 39 0 0 38 0 17,974 0 0 etendo.profile.last_stat_user_functions_srv1 899 0 21,573,317 0 0 0 0 38 0 17,974 0 0 etendo.profile.last_stat_tables_srv1 899 0 223,022,381 0 24 0 0 52 22 55,697 0 0 etendo.profile.last_stat_tablespaces_srv1 899 0 70,932 0 45 0 0 38 0 17,974 0 0 Total 56,694 0 762,600,323 122,954,865 3,319 0 0 4,270 980 3,137,075 15 15 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (3729.00999999999) 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
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.sample_stat_archiver 0 0 0 etendo.pg_catalog.pg_class 0 0 0 etendo.profile.samples 0 0 0 etendo.public.m_stock_proposed 0 0 0 etendo.profile.sample_stat_tables 0 0 201.629999999998 etendo.profile.sample_stat_indexes_total 0 0 0 etendo.public.ad_session_usage_audit 0 0 369.590000000001 etendo.profile.last_stat_archiver 0 0 0 etendo.profile.sample_stat_user_functions 0 0 8.99999999999985 etendo.profile.last_stat_io 0 0 0.01 etendo.pg_catalog.pg_shdepend 0 0 0 etendo.pg_toast.pg_toast_125223 0 0 0 etendo.pg_toast.pg_toast_46165 0 0 113.07 etendo.profile.funcs_list 0 0 2.89999999999998 etendo.public.ad_ep_instance_para 0 0 35.9999999999994 etendo.pg_catalog.pg_attribute 0 0 27.0000000000003 etendo.public.c_invoice 0 0 572.409999999994 etendo.public.c_bpartner 0 0 31.2899999999999 etendo.profile.sample_stat_wal 0 0 0 etendo.public.m_storage_detail 0 0 17.9999999999997 etendo.public.ad_pinstance_para 0 0 0 etendo.profile.sample_stat_cluster 0 0 0 etendo.pg_catalog.pg_type 0 0 0 etendo.profile.stmt_list 0 0 44.9999999999996 etendo.profile.sample_stat_slru 0 0 0 etendo.public.ad_module 0 0 16.3099999999997 etendo.profile.sample_stat_indexes 0 0 27.0100000000003 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.public.c_order 0 0 394.35 etendo.public.ad_process_request 0 0 44.0299999999996 etendo.pg_toast.pg_toast_2619 0 0 125.19 etendo.public.ad_pinstance 0 0 8.99999999999985 etendo.public.ad_sequence 0 0 0 etendo.profile.last_stat_wal 0 0 0 etendo.profile.sample_stat_database 0 0 0 etendo.profile.sample_statements 0 0 86.3400000000002 etendo.public.ad_preference 0 0 47.2799999999997 etendo.public.fin_financial_account 0 0 0 template1.pg_catalog.pg_shdepend 0 0 0 etendo.profile.indexes_list 0 0 14.1099999999998 etendo.profile.tables_list 0 0 59.2400000000003 etendo.profile.last_stat_slru 0 0 0 etendo.profile.sample_stat_tables_total 0 0 0 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.profile.sample_statements_total 0 0 0 etendo.profile.sample_stat_io 0 0 0 etendo.public.ad_audit_trail 0 0 317.660000000003 etendo.pg_catalog.pg_statistic 0 0 485.000000000001 etendo.profile.last_stat_cluster 0 0 0 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.public.ad_process_run 0 0 62.7100000000002 postgres.pg_catalog.pg_shdepend 0 0 0 etendo.public.m_storage_pending 0 0 35.3099999999995 etendo.profile.last_extension_versions 0 0 0 etendo.public.ad_session 0 0 54.0000000000005 etendo.profile.servers 0 0 0 etendo.pg_toast.pg_toast_45833 0 0 0.18 etendo.profile.last_stat_statements_srv1 0 0 1,419.16999999998 etendo.profile.last_stat_indexes_srv1 0 0 3,729.00999999999 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_user_functions_srv1 0 0 258.37 etendo.profile.last_stat_tables_srv1 0 0 3,296.82999999999 etendo.profile.last_stat_tablespaces_srv1 0 0 0 Total 0 0 11,907 Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_statements_srv1 899 0 0 753,744,644 753,383,849 0 40,255,032 etendo.profile.sample_stat_archiver 900 0 0 697,499 545,580 0 6,300 etendo.pg_catalog.pg_class 900 0 0 4,689,128 1,344,036 0 119,700 etendo.profile.samples 900 0 0 697,499 545,580 0 4,500 etendo.public.m_stock_proposed 900 0 0 4,800,600 3,501,000 0 153,000 etendo.profile.last_stat_indexes_srv1 899 0 0 3,796,768,395 3,794,350,085 0 154,397,982 etendo.profile.sample_stat_tables 900 0 0 171,516,707 133,333,620 0 5,725,191 etendo.profile.sample_stat_indexes_total 900 0 0 2,789,996 2,182,320 0 32,220 etendo.public.ad_session_usage_audit 900 0 0 393,268,500 194,109,300 0 10,661,400 etendo.profile.last_stat_archiver 900 0 0 697,499 696,599 0 6,300 etendo.profile.sample_stat_user_functions 900 0 0 35,431,943 27,576,900 0 331,620 etendo.profile.last_stat_io 900 0 0 10,382,385 10,368,885 0 231,300 etendo.profile.last_stat_database_srv1 899 0 0 2,786,912 2,783,316 0 111,896 etendo.pg_catalog.pg_shdepend 900 0 0 2,929,620 1,187,436 0 23,400 etendo.pg_toast.pg_toast_125223 900 0 0 187,200 120,600 0 33,300 etendo.pg_toast.pg_toast_46165 900 0 0 14,907,948 14,465,148 0 3,726,087 etendo.profile.funcs_list 900 0 0 12,508,135 12,334,435 0 338,520 etendo.public.ad_ep_instance_para 900 0 0 53,804,700 53,804,700 0 1,047,600 etendo.pg_catalog.pg_attribute 900 0 0 40,416,775 11,931,960 0 774,540 etendo.public.c_invoice 900 0 0 293,201,190 188,517,690 0 23,864,414 etendo.public.c_bpartner 900 0 0 12,674,700 3,342,600 0 715,500 etendo.profile.sample_stat_wal 900 0 0 697,499 545,580 0 9,900 etendo.public.m_storage_detail 900 0 0 24,106,500 8,458,200 0 772,200 etendo.profile.last_stat_user_functions_srv1 899 0 0 333,598,630 333,205,767 0 10,770,546 etendo.public.ad_pinstance_para 900 0 0 1,440,900 993,600 0 43,200 etendo.profile.sample_stat_cluster 900 0 0 697,499 545,580 0 14,400 etendo.pg_catalog.pg_type 900 0 0 4,648,740 2,374,872 0 108,900 etendo.profile.stmt_list 900 0 0 29,456,983 29,023,843 0 2,177,999 etendo.profile.sample_stat_slru 900 0 0 2,790,896 2,183,220 0 39,720 etendo.public.ad_module 900 0 0 7,373,498 7,155,698 0 560,911 etendo.profile.sample_stat_indexes 900 0 0 50,846,268 39,547,200 0 808,439 etendo.profile.last_stat_activity_count_srv1 900 0 0 5,672,692 5,672,692 0 138,060 etendo.public.c_order 900 0 0 189,079,200 35,146,800 0 17,674,200 etendo.public.ad_process_request 900 0 0 18,038,370 17,007,870 0 1,872,395 etendo.pg_toast.pg_toast_2619 900 0 0 18,254,797 16,931,139 0 3,743,176 etendo.public.ad_pinstance 900 0 0 10,998,000 9,642,600 0 325,800 etendo.public.ad_sequence 900 0 0 7,351,200 7,206,300 0 179,100 etendo.profile.last_stat_tables_srv1 899 0 0 2,447,014,679 2,445,545,233 0 124,533,315 etendo.profile.last_stat_wal 900 0 0 697,499 696,599 0 10,620 etendo.profile.sample_stat_database 900 0 0 2,789,996 2,182,320 0 112,020 etendo.profile.sample_statements 900 0 0 51,176,568 40,314,060 0 2,559,300 etendo.public.ad_preference 900 0 0 11,706,169 11,029,369 0 1,530,900 etendo.public.fin_financial_account 900 0 0 1,317,600 1,308,600 0 48,600 template1.pg_catalog.pg_shdepend 900 0 0 2,929,620 1,187,436 0 23,400 etendo.profile.indexes_list 900 0 0 33,163,965 32,861,865 0 722,460 etendo.profile.tables_list 900 0 0 118,073,728 117,120,328 0 2,569,016 etendo.profile.last_stat_slru 900 0 0 3,487,495 3,482,995 0 49,560 etendo.profile.last_stat_tablespaces_srv1 899 0 0 1,393,456 1,391,658 0 21,696 etendo.profile.sample_stat_tables_total 900 0 0 6,277,491 4,910,220 0 164,520 etendo.profile.sample_stat_user_func_total 900 0 0 1,394,998 1,091,160 0 11,820 etendo.profile.sample_statements_total 900 0 0 1,394,998 1,091,160 0 58,560 etendo.profile.sample_stat_io 900 0 0 4,610,693 3,534,660 0 99,720 etendo.public.ad_audit_trail 900 0 0 361,743,300 137,109,600 0 16,473,600 etendo.pg_catalog.pg_statistic 900 0 0 291,506,099 286,376,999 0 18,939,394 etendo.profile.last_stat_cluster 900 0 0 697,499 696,599 0 14,400 etendo.profile.sample_stat_tablespaces 900 0 0 1,394,998 1,091,160 0 10,800 etendo.public.ad_process_run 900 0 0 35,963,339 29,403,569 0 2,597,075 postgres.pg_catalog.pg_shdepend 900 0 0 2,929,620 1,187,433 0 23,400 etendo.public.m_storage_pending 900 0 0 32,968,800 20,743,200 0 1,039,500 etendo.profile.last_extension_versions 900 0 0 4,882,493 4,876,193 0 66,360 etendo.public.ad_session 900 0 0 54,620,100 53,887,500 0 1,611,900 etendo.profile.servers 900 0 0 698,399 697,499 0 13,380 etendo.pg_toast.pg_toast_45833 900 0 0 1,302,300 1,074,600 0 269,100 Total 56,694 0 0 9,790,089,549 8,930,958,615 0 455,373,164 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 899 0 0 0 etendo.profile.sample_stat_archiver 900 0 0 0 etendo.pg_catalog.pg_class 900 0 0 0 etendo.profile.samples 900 0 0 0 etendo.public.m_stock_proposed 900 0 0 0 etendo.profile.last_stat_indexes_srv1 899 0 0 0 etendo.profile.sample_stat_tables 900 0 0 0 etendo.profile.sample_stat_indexes_total 900 0 0 0 etendo.public.ad_session_usage_audit 900 0 0 0 etendo.profile.last_stat_archiver 900 0 0 0 etendo.profile.sample_stat_user_functions 900 0 0 0 etendo.profile.last_stat_io 900 0 0 0 etendo.profile.last_stat_database_srv1 899 0 0 0 etendo.pg_catalog.pg_shdepend 900 0 0 0 etendo.pg_toast.pg_toast_125223 900 0 0 0 etendo.pg_toast.pg_toast_46165 900 0 0 0 etendo.profile.funcs_list 900 0 0 0 etendo.public.ad_ep_instance_para 900 0 0 0 etendo.pg_catalog.pg_attribute 900 0 0 0 etendo.public.c_invoice 900 0 0 0 etendo.public.c_bpartner 900 0 0 0 etendo.profile.sample_stat_wal 900 0 0 0 etendo.public.m_storage_detail 900 0 0 0 etendo.profile.last_stat_user_functions_srv1 899 0 0 0 etendo.public.ad_pinstance_para 900 0 0 0 etendo.profile.sample_stat_cluster 900 0 0 0 etendo.pg_catalog.pg_type 900 0 0 0 etendo.profile.stmt_list 900 0 0 0 etendo.profile.sample_stat_slru 900 0 0 0 etendo.public.ad_module 900 0 0 0 etendo.profile.sample_stat_indexes 900 0 0 0 etendo.profile.last_stat_activity_count_srv1 900 0 0 0 etendo.public.c_order 900 0 0 0 etendo.public.ad_process_request 900 0 0 0 etendo.pg_toast.pg_toast_2619 900 0 0 0 etendo.public.ad_pinstance 900 0 0 0 etendo.public.ad_sequence 900 0 0 0 etendo.profile.last_stat_tables_srv1 899 0 0 0 etendo.profile.last_stat_wal 900 0 0 0 etendo.profile.sample_stat_database 900 0 0 0 etendo.profile.sample_statements 900 0 0 0 etendo.public.ad_preference 900 0 0 0 etendo.public.fin_financial_account 900 0 0 0 template1.pg_catalog.pg_shdepend 900 0 0 0 etendo.profile.indexes_list 900 0 0 0 etendo.profile.tables_list 900 0 0 0 etendo.profile.last_stat_slru 900 0 0 0 etendo.profile.last_stat_tablespaces_srv1 899 0 0 0 etendo.profile.sample_stat_tables_total 900 0 0 0 etendo.profile.sample_stat_user_func_total 900 0 0 0 etendo.profile.sample_statements_total 900 0 0 0 etendo.profile.sample_stat_io 900 0 0 0 etendo.public.ad_audit_trail 900 0 0 0 etendo.pg_catalog.pg_statistic 900 0 0 0 etendo.profile.last_stat_cluster 900 0 0 0 etendo.profile.sample_stat_tablespaces 900 0 0 0 etendo.public.ad_process_run 900 0 0 0 postgres.pg_catalog.pg_shdepend 900 0 0 0 etendo.public.m_storage_pending 900 0 0 0 etendo.profile.last_extension_versions 900 0 0 0 etendo.public.ad_session 900 0 0 0 etendo.profile.servers 900 0 0 0 etendo.pg_toast.pg_toast_45833 900 0 0 0 Total 56,694 0 0 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 3,780 7 08 3,780 11 09 3,780 7 10 3,780 10 11 3,774 6 12 3,780 9 13 3,780 9 14 3,780 6 15 3,780 7 16 3,780 8 17 3,780 12 18 3,780 9 19 3,780 10 20 3,780 9 21 3,780 6 22 0 0 - 4.29 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
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
Queries by type
Key values
- 46 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 46 Requests
- 8m19s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 31 Requests
User Request type Count Duration postgres Total 15 4m52s select 15 4m52s tad Total 31 3m27s select 31 3m27s Duration by user
Key values
- 4m52s (postgres) Main time consuming user
User Request type Count Duration postgres Total 15 4m52s select 15 4m52s tad Total 31 3m27s select 31 3m27s Queries by host
Key values
- 127.0.0.1 Main host
- 31 Requests
- 4m52s ([local])
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 31 Requests
- 4m52s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 12:23:34 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 30 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 47s216ms SELECT profile.take_sample ();[ Date: 2026-07-19 11:00:48 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 19s240ms SELECT profile.take_sample ();[ Date: 2026-07-19 14:00:21 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
3 18s897ms SELECT profile.take_sample ();[ Date: 2026-07-19 07:00:20 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
4 18s239ms SELECT profile.take_sample ();[ Date: 2026-07-19 19:00:20 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5 18s239ms SELECT profile.take_sample ();[ Date: 2026-07-19 21:00:20 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
6 17s867ms SELECT profile.take_sample ();[ Date: 2026-07-19 12:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
7 17s539ms SELECT profile.take_sample ();[ Date: 2026-07-19 08:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
8 17s505ms SELECT profile.take_sample ();[ Date: 2026-07-19 09:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 17s449ms SELECT profile.take_sample ();[ Date: 2026-07-19 15:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 17s90ms SELECT profile.take_sample ();[ Date: 2026-07-19 13:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 16s890ms SELECT profile.take_sample ();[ Date: 2026-07-19 18:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 16s737ms SELECT profile.take_sample ();[ Date: 2026-07-19 17:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 16s652ms SELECT profile.take_sample ();[ Date: 2026-07-19 20:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14 16s576ms SELECT profile.take_sample ();[ Date: 2026-07-19 16:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15 16s320ms SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 07:00:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 16s215ms SELECT profile.take_sample ();[ Date: 2026-07-19 10:00:17 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
17 12s756ms SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 08:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 12s351ms SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 14:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 12s320ms SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 15:00:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 12s22ms SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 12:00:13 - 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 4m52s 15 16s215ms 47s216ms 19s490ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 18s897ms 18s897ms 08 1 17s539ms 17s539ms 09 1 17s505ms 17s505ms 10 1 16s215ms 16s215ms 11 1 47s216ms 47s216ms 12 1 17s867ms 17s867ms 13 1 17s90ms 17s90ms 14 1 19s240ms 19s240ms 15 1 17s449ms 17s449ms 16 1 16s576ms 16s576ms 17 1 16s737ms 16s737ms 18 1 16s890ms 16s890ms 19 1 18s239ms 18s239ms 20 1 16s652ms 16s652ms 21 1 18s239ms 18s239ms [ User: postgres - Total duration: 4m52s - Times executed: 15 ]
[ Application: psql - Total duration: 4m52s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 11:00:48 Duration: 47s216ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 14:00:21 Duration: 19s240ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:20 Duration: 18s897ms Database: etendo User: postgres Remote: [local] Application: psql
2 3m 15 10s794ms 16s320ms 12s22ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 1 16s320ms 16s320ms 08 1 12s756ms 12s756ms 09 1 11s555ms 11s555ms 10 1 11s766ms 11s766ms 11 1 11s663ms 11s663ms 12 1 12s22ms 12s22ms 13 1 11s511ms 11s511ms 14 1 12s351ms 12s351ms 15 1 12s320ms 12s320ms 16 1 10s794ms 10s794ms 17 1 11s902ms 11s902ms 18 1 11s104ms 11s104ms 19 1 11s686ms 11s686ms 20 1 10s912ms 10s912ms 21 1 11s662ms 11s662ms [ User: tad - Total duration: 3m - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m - Times executed: 15 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:17 Duration: 16s320ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 08:00:13 Duration: 12s756ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:13 Duration: 12s351ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 26s63ms 15 1s198ms 2s22ms 1s737ms select * from ( select c_invoice.c_invoice_id as referencekey_id, c_invoice.documentno as record_id, ? as ad_role_id, null as ad_user_id, ?| | c_invoice.documentno || ?| | c_invoice.grandtotal || ?| | (( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, ? as isactive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_invoice where c_invoice.issotrx = ? and c_invoice.grandtotal <> round((( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 1 1s910ms 1s910ms 08 1 1s624ms 1s624ms 09 1 1s933ms 1s933ms 10 1 1s581ms 1s581ms 11 1 1s198ms 1s198ms 12 1 1s745ms 1s745ms 13 1 1s681ms 1s681ms 14 1 1s842ms 1s842ms 15 1 1s861ms 1s861ms 16 1 1s669ms 1s669ms 17 1 1s563ms 1s563ms 18 1 1s762ms 1s762ms 19 1 2s22ms 2s22ms 20 1 1s706ms 1s706ms 21 1 1s959ms 1s959ms [ User: tad - Total duration: 26s63ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s63ms - Times executed: 15 ]
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:16 Duration: 2s22ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 21:00:16 Duration: 1s959ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:16 Duration: 1s933ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s62ms 1 1s62ms 1s62ms 1s62ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 15 1 1s62ms 1s62ms [ User: tad - Total duration: 1s62ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s62ms - Times executed: 1 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE ACCOUNTING DATE NOT IN A PERIOD' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, posted FROM C_INVOICE, c_doctype WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and not exists ( select 1 from c_period where c_period.startdate <= TRUNC(dateacct) and TRUNC(dateacct) <= c_period.enddate) GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_org_id, C_INVOICE.ad_client_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '9949239808164E51ADF2E6B1E8DF6D63' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:00:01 Duration: 1s62ms 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 15 4m52s 16s215ms 47s216ms 19s490ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 18s897ms 18s897ms 08 1 17s539ms 17s539ms 09 1 17s505ms 17s505ms 10 1 16s215ms 16s215ms 11 1 47s216ms 47s216ms 12 1 17s867ms 17s867ms 13 1 17s90ms 17s90ms 14 1 19s240ms 19s240ms 15 1 17s449ms 17s449ms 16 1 16s576ms 16s576ms 17 1 16s737ms 16s737ms 18 1 16s890ms 16s890ms 19 1 18s239ms 18s239ms 20 1 16s652ms 16s652ms 21 1 18s239ms 18s239ms [ User: postgres - Total duration: 4m52s - Times executed: 15 ]
[ Application: psql - Total duration: 4m52s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 11:00:48 Duration: 47s216ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 14:00:21 Duration: 19s240ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:20 Duration: 18s897ms Database: etendo User: postgres Remote: [local] Application: psql
2 15 3m 10s794ms 16s320ms 12s22ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 1 16s320ms 16s320ms 08 1 12s756ms 12s756ms 09 1 11s555ms 11s555ms 10 1 11s766ms 11s766ms 11 1 11s663ms 11s663ms 12 1 12s22ms 12s22ms 13 1 11s511ms 11s511ms 14 1 12s351ms 12s351ms 15 1 12s320ms 12s320ms 16 1 10s794ms 10s794ms 17 1 11s902ms 11s902ms 18 1 11s104ms 11s104ms 19 1 11s686ms 11s686ms 20 1 10s912ms 10s912ms 21 1 11s662ms 11s662ms [ User: tad - Total duration: 3m - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m - Times executed: 15 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:17 Duration: 16s320ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 08:00:13 Duration: 12s756ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:13 Duration: 12s351ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 15 26s63ms 1s198ms 2s22ms 1s737ms select * from ( select c_invoice.c_invoice_id as referencekey_id, c_invoice.documentno as record_id, ? as ad_role_id, null as ad_user_id, ?| | c_invoice.documentno || ?| | c_invoice.grandtotal || ?| | (( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, ? as isactive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_invoice where c_invoice.issotrx = ? and c_invoice.grandtotal <> round((( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 1 1s910ms 1s910ms 08 1 1s624ms 1s624ms 09 1 1s933ms 1s933ms 10 1 1s581ms 1s581ms 11 1 1s198ms 1s198ms 12 1 1s745ms 1s745ms 13 1 1s681ms 1s681ms 14 1 1s842ms 1s842ms 15 1 1s861ms 1s861ms 16 1 1s669ms 1s669ms 17 1 1s563ms 1s563ms 18 1 1s762ms 1s762ms 19 1 2s22ms 2s22ms 20 1 1s706ms 1s706ms 21 1 1s959ms 1s959ms [ User: tad - Total duration: 26s63ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s63ms - Times executed: 15 ]
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:16 Duration: 2s22ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 21:00:16 Duration: 1s959ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:16 Duration: 1s933ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1 1s62ms 1s62ms 1s62ms 1s62ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 15 1 1s62ms 1s62ms [ User: tad - Total duration: 1s62ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s62ms - Times executed: 1 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE ACCOUNTING DATE NOT IN A PERIOD' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, posted FROM C_INVOICE, c_doctype WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and not exists ( select 1 from c_period where c_period.startdate <= TRUNC(dateacct) and TRUNC(dateacct) <= c_period.enddate) GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_org_id, C_INVOICE.ad_client_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '9949239808164E51ADF2E6B1E8DF6D63' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:00:01 Duration: 1s62ms 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 16s215ms 47s216ms 19s490ms 15 4m52s select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 18s897ms 18s897ms 08 1 17s539ms 17s539ms 09 1 17s505ms 17s505ms 10 1 16s215ms 16s215ms 11 1 47s216ms 47s216ms 12 1 17s867ms 17s867ms 13 1 17s90ms 17s90ms 14 1 19s240ms 19s240ms 15 1 17s449ms 17s449ms 16 1 16s576ms 16s576ms 17 1 16s737ms 16s737ms 18 1 16s890ms 16s890ms 19 1 18s239ms 18s239ms 20 1 16s652ms 16s652ms 21 1 18s239ms 18s239ms [ User: postgres - Total duration: 4m52s - Times executed: 15 ]
[ Application: psql - Total duration: 4m52s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 11:00:48 Duration: 47s216ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 14:00:21 Duration: 19s240ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:20 Duration: 18s897ms Database: etendo User: postgres Remote: [local] Application: psql
2 10s794ms 16s320ms 12s22ms 15 3m select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 1 16s320ms 16s320ms 08 1 12s756ms 12s756ms 09 1 11s555ms 11s555ms 10 1 11s766ms 11s766ms 11 1 11s663ms 11s663ms 12 1 12s22ms 12s22ms 13 1 11s511ms 11s511ms 14 1 12s351ms 12s351ms 15 1 12s320ms 12s320ms 16 1 10s794ms 10s794ms 17 1 11s902ms 11s902ms 18 1 11s104ms 11s104ms 19 1 11s686ms 11s686ms 20 1 10s912ms 10s912ms 21 1 11s662ms 11s662ms [ User: tad - Total duration: 3m - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m - Times executed: 15 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:17 Duration: 16s320ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 08:00:13 Duration: 12s756ms 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, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:13 Duration: 12s351ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s198ms 2s22ms 1s737ms 15 26s63ms select * from ( select c_invoice.c_invoice_id as referencekey_id, c_invoice.documentno as record_id, ? as ad_role_id, null as ad_user_id, ?| | c_invoice.documentno || ?| | c_invoice.grandtotal || ?| | (( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, ? as isactive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_invoice where c_invoice.issotrx = ? and c_invoice.grandtotal <> round((( select round(sum(linenetamt), ?) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), ?), ?) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), ?)) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 1 1s910ms 1s910ms 08 1 1s624ms 1s624ms 09 1 1s933ms 1s933ms 10 1 1s581ms 1s581ms 11 1 1s198ms 1s198ms 12 1 1s745ms 1s745ms 13 1 1s681ms 1s681ms 14 1 1s842ms 1s842ms 15 1 1s861ms 1s861ms 16 1 1s669ms 1s669ms 17 1 1s563ms 1s563ms 18 1 1s762ms 1s762ms 19 1 2s22ms 2s22ms 20 1 1s706ms 1s706ms 21 1 1s959ms 1s959ms [ User: tad - Total duration: 26s63ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s63ms - Times executed: 15 ]
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:16 Duration: 2s22ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 21:00:16 Duration: 1s959ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice.C_INVOICE_ID as referencekey_id, c_invoice.documentno as record_id, 0 as ad_role_id, null as ad_user_id, 'Factura ' || c_invoice.documentno || ' difiere el importe total ' || c_invoice.grandtotal || ' con la suma del total de las lineas + impuestos ' || (( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)) as description, 'Y' as isActive, c_invoice.ad_org_id, c_invoice.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from c_invoice where c_invoice.issotrx = 'Y' and c_invoice.grandtotal <> round((( select round(sum(linenetamt), 2) from c_invoiceline line where line.c_invoice_id = c_invoice.c_invoice_id) + ( select coalesce(round(sum(tax.taxamt), 2), 0) from c_invoicetax tax where tax.c_invoice_id = c_invoice.c_invoice_id)), 2)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'D385EC7B4B9F428093AF4EBA38AF5821' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:16 Duration: 1s933ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s62ms 1s62ms 1s62ms 1 1s62ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 15 1 1s62ms 1s62ms [ User: tad - Total duration: 1s62ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s62ms - Times executed: 1 ]
-
SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE ACCOUNTING DATE NOT IN A PERIOD' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, posted FROM C_INVOICE, c_doctype WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and not exists ( select 1 from c_period where c_period.startdate <= TRUNC(dateacct) and TRUNC(dateacct) <= c_period.enddate) GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_org_id, C_INVOICE.ad_client_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '9949239808164E51ADF2E6B1E8DF6D63' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:00:01 Duration: 1s62ms 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
-
Events
Log levels
Key values
- 70,373 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET