pgBadger-
Global information
- Generated on Sat Jul 18 23:00:46 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 88,135 log entries in 45s
- Log start from 2026-07-18 07:00:01 to 2026-07-18 22:00:00
-
Overview
Global Stats
- 5 Number of unique normalized queries
- 49 Number of queries
- 8m9s Total query duration
- 2026-07-18 07:00:01 First query
- 2026-07-18 21:00:18 Last query
- 1 queries/s at 2026-07-18 21:00:15 Query peak
- 8m9s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8m9s 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,633 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-18 14:00:01 Session peak
- 3d49m9s Total duration of sessions
- 1m20s Average duration of sessions
- 0 Average queries per session
- 149ms Average queries duration per session
- 1m20s Average idle time per session
- 3,271 Total number of connections
- 5 connections/s at 2026-07-18 22:00:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-18 21:00:15 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-18 21:00:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 8m9s 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 18 07 4 0ms 22s13ms 11s191ms 0ms 0ms 44s765ms 08 3 0ms 18s91ms 10s907ms 0ms 0ms 32s722ms 09 3 0ms 18s381ms 11s161ms 0ms 0ms 33s485ms 10 4 0ms 17s749ms 8s282ms 0ms 0ms 33s128ms 11 3 0ms 17s801ms 10s455ms 0ms 0ms 31s367ms 12 4 0ms 18s331ms 8s622ms 0ms 0ms 34s491ms 13 3 0ms 16s814ms 9s973ms 0ms 0ms 29s920ms 14 4 0ms 18s427ms 8s598ms 0ms 0ms 34s392ms 15 3 0ms 16s710ms 10s318ms 0ms 0ms 30s955ms 16 3 0ms 16s186ms 9s979ms 0ms 0ms 29s938ms 17 3 0ms 16s837ms 10s89ms 0ms 0ms 30s269ms 18 3 0ms 17s263ms 10s268ms 0ms 0ms 30s804ms 19 3 0ms 17s880ms 10s195ms 0ms 0ms 30s586ms 20 3 0ms 17s543ms 10s624ms 0ms 0ms 31s874ms 21 3 0ms 17s291ms 10s219ms 0ms 0ms 30s658ms 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 18 07 4 0 11s191ms 0ms 0ms 0ms 08 3 0 10s907ms 0ms 0ms 0ms 09 3 0 11s161ms 0ms 0ms 0ms 10 4 0 8s282ms 0ms 0ms 0ms 11 3 0 10s455ms 0ms 0ms 0ms 12 4 0 8s622ms 0ms 0ms 0ms 13 3 0 9s973ms 0ms 0ms 0ms 14 4 0 8s598ms 0ms 0ms 0ms 15 3 0 10s318ms 0ms 0ms 0ms 16 3 0 9s979ms 0ms 0ms 0ms 17 3 0 10s89ms 0ms 0ms 0ms 18 3 0 10s268ms 0ms 0ms 0ms 19 3 0 10s195ms 0ms 0ms 0ms 20 3 0 10s624ms 0ms 0ms 0ms 21 3 0 10s219ms 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 18 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 18 07 0 3 3.00 0.00% 08 0 2 2.00 0.00% 09 0 2 2.00 0.00% 10 0 3 3.00 0.00% 11 0 2 2.00 0.00% 12 0 3 3.00 0.00% 13 0 2 2.00 0.00% 14 0 3 3.00 0.00% 15 0 2 2.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 18 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 18 07 217 150ms 0ms 08 217 123ms 0ms 09 220 2m45s 2m45s 10 217 123ms 0ms 11 217 120ms 0ms 12 220 3m51s 3m50s 13 217 117ms 0ms 14 220 7m44s 7m44s 15 217 116ms 0ms 16 217 111ms 0ms 17 217 123ms 0ms 18 217 122ms 0ms 19 217 121ms 0ms 20 217 119ms 0ms 21 220 5m29s 5m29s 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-18 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-18 14:00:01 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,306 buffers Checkpoint Peak
- 2026-07-18 14:07:41 Date
- 269.861 seconds Highest write time
- 0.001 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-07-18 14:07:41 Date
Checkpoints distance
Key values
- 53.20 Mo Distance Peak
- 2026-07-18 14:07:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 07 1,932 191.493s 0.012s 191.513s 08 2,032 201.314s 0.012s 201.336s 09 2,178 216.057s 0.012s 216.081s 10 1,923 190.497s 0.012s 190.52s 11 1,831 181.671s 0.012s 181.691s 12 1,853 183.992s 0.012s 184.013s 13 1,853 183.796s 0.012s 183.819s 14 5,590 296.912s 0.012s 296.934s 15 1,948 193.41s 0.012s 193.432s 16 1,900 188.508s 0.012s 188.532s 17 1,834 181.683s 0.012s 181.706s 18 1,856 184.288s 0.012s 184.31s 19 1,864 184.801s 0.012s 184.824s 20 1,904 188.997s 0.012s 189.018s 21 1,868 184.887s 0.012s 184.911s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 07 0 0 1 327 0.001s 0.012s 08 0 0 1 327 0.001s 0.012s 09 0 0 0 364 0.001s 0.012s 10 0 0 1 347 0.001s 0.012s 11 0 0 1 327 0.001s 0.012s 12 0 0 0 337 0.001s 0.012s 13 0 0 1 341 0.001s 0.012s 14 0 0 2 376 0.001s 0.012s 15 0 0 0 344 0.001s 0.012s 16 0 0 1 325 0.001s 0.012s 17 0 0 1 327 0.001s 0.012s 18 0 0 0 322 0.001s 0.012s 19 0 0 1 326 0.001s 0.012s 20 0 0 0 326 0.001s 0.012s 21 0 0 1 346 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 18 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 18 07 883.33 kB 6,063.83 kB 08 903.50 kB 6,199.75 kB 09 1,045.33 kB 5,782.00 kB 10 872.00 kB 5,974.33 kB 11 845.33 kB 5,777.42 kB 12 857.67 kB 5,945.58 kB 13 848.50 kB 5,848.42 kB 14 2,312.00 kB 16,307.33 kB 15 885.17 kB 6,066.67 kB 16 878.00 kB 6,014.42 kB 17 850.00 kB 5,815.42 kB 18 851.25 kB 5,850.83 kB 19 834.92 kB 5,701.08 kB 20 878.25 kB 6,006.25 kB 21 857.92 kB 5,895.58 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-18 19:00:12 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-18 19:00:12 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 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-18 07:00:21 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-18 07:00:21 - 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-18 08:00:14 - 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-18 09:00:14 - 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-18 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-18 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-18 12:00:14 - 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-18 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-18 14:00:14 - 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-18 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-18 16:00:13 - 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-18 17:00:12 - 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-18 18:00:13 - 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-18 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-18 20:00:13 - 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-18 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-18 07:00:21 - 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-18 08:00:14 - 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-18 09:00:14 - 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-18 10:00:14 - 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-18 11:00:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.37 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-18 17:00:04 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 4.37 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-18 17:00:04 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_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.tables_list 12 etendo.profile.last_stat_io 7 etendo.profile.indexes_list 6 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.stmt_list 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_tables 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_tables_total 2 etendo.profile.sample_statements 2 etendo.profile.last_stat_archiver 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_indexes_total 1 etendo.public.ad_process_request 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_stat_archiver 1 etendo.profile.sample_stat_cluster 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.samples 1 etendo.public.ad_module 1 etendo.profile.funcs_list 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_wal 1 etendo.profile.last_stat_wal 1 Total 126 Vacuums per table
Key values
- pg_catalog.pg_shdepend (900) Main table vacuumed on database postgres
- 56,633 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples postgres.pg_catalog.pg_shdepend 900 0 103,500 0 45 0 0 47 42 82,074 0 0 template1.pg_catalog.pg_shdepend 900 0 103,726 0 47 0 0 55 41 82,473 0 0 etendo.public.ad_process_request 899 0 3,712,314 0 484 0 0 57 0 10,716 0 0 etendo.profile.servers 899 0 59,149 0 86 0 0 57 41 100,903 15 15 etendo.profile.sample_stat_indexes_total 899 0 81,186 0 45 0 0 47 0 11,327 0 0 etendo.pg_catalog.pg_shdepend 899 0 95,473 0 44 0 0 48 41 90,684 0 0 etendo.profile.sample_stat_tables 899 0 5,668,050 0 0 0 0 47 0 11,327 0 0 etendo.public.m_storage_pending 899 0 1,076,021 0 41 0 0 43 41 108,818 0 0 etendo.profile.indexes_list 899 0 1,459,932 0 6 0 0 47 0 11,327 0 0 etendo.profile.last_stat_cluster 899 0 53,404 0 86 0 0 42 41 101,067 0 0 etendo.pg_catalog.pg_attribute 899 0 890,117 0 20 0 0 29 4 17,621 0 0 etendo.profile.sample_stat_slru 899 0 68,733 0 42 0 0 47 0 11,327 0 0 etendo.pg_toast.pg_toast_125223 899 0 90,451 0 34 0 0 47 34 92,091 0 0 etendo.profile.sample_stat_user_functions 899 0 374,622 0 30 0 0 46 0 11,086 0 0 etendo.pg_toast.pg_toast_2619 899 0 3,720,692 0 54 0 0 49 42 104,889 0 0 etendo.profile.sample_stat_indexes 899 0 856,842 0 2 0 0 47 0 11,327 0 0 etendo.pg_catalog.pg_statistic 899 0 35,994,661 0 42 0 0 58 42 128,569 0 0 etendo.public.ad_session_usage_audit 899 0 9,355,893 0 0 0 0 0 0 0 0 0 etendo.profile.sample_stat_tables_total 899 0 212,803 0 33 0 0 46 0 11,086 0 0 etendo.public.ad_audit_trail 899 0 7,942,665 0 0 0 0 0 0 0 0 0 etendo.profile.last_extension_versions 899 0 158,464 0 68 0 0 42 26 70,934 0 0 etendo.public.ad_process_run 899 0 5,146,519 0 565 0 0 183 166 452,905 0 0 etendo.public.ad_module 899 0 683,706 0 42 0 0 45 42 115,770 0 0 etendo.profile.funcs_list 899 0 709,441 0 39 0 0 46 0 11,086 0 0 etendo.profile.sample_statements 899 0 2,564,133 0 2 0 0 46 0 11,086 0 0 etendo.profile.samples 899 0 54,880 0 45 0 0 47 0 11,327 0 0 etendo.public.m_stock_proposed 899 0 199,625 0 41 0 0 43 41 110,707 0 0 etendo.public.ad_sequence 899 0 225,215 0 41 0 0 44 41 111,308 0 0 etendo.profile.sample_stat_wal 899 0 36,848 0 45 0 0 47 0 11,327 0 0 etendo.profile.sample_statements_total 899 0 87,048 0 46 0 0 47 1 13,576 0 0 etendo.public.m_storage_detail 899 0 1,651,897 0 0 0 0 43 0 8,084 0 0 etendo.profile.last_stat_archiver 899 0 37,232 0 86 0 0 42 41 101,903 0 0 etendo.profile.sample_stat_io 899 0 132,129 0 39 0 0 47 0 11,327 0 0 etendo.public.fin_financial_account 899 0 84,772 0 41 0 0 43 41 115,208 0 0 etendo.profile.sample_stat_archiver 899 0 34,558 0 45 0 0 47 0 11,327 0 0 etendo.profile.sample_stat_cluster 899 0 41,751 0 45 0 0 47 0 11,327 0 0 etendo.public.ad_session 899 0 1,683,868 0 0 0 0 44 0 8,272 0 0 etendo.profile.sample_stat_tablespaces 899 0 55,162 0 45 0 0 47 0 11,327 0 0 etendo.profile.last_stat_io 899 0 480,237 0 30 0 0 42 0 7,896 0 0 etendo.public.ad_ep_instance_para 899 0 1,062,115 0 41 0 0 44 41 119,419 0 0 etendo.public.c_order 899 0 11,445,589 0 1 0 0 0 0 0 0 0 etendo.pg_toast.pg_toast_46165 899 0 4,575,222 0 43 0 0 48 42 111,673 0 0 etendo.profile.sample_stat_user_func_total 899 0 44,397 0 45 0 0 46 0 11,086 0 0 etendo.public.ad_pinstance 899 0 363,089 0 0 0 0 44 0 8,272 0 0 etendo.profile.stmt_list 899 0 4,267,189 0 50 0 0 47 41 92,666 0 0 etendo.profile.sample_stat_database 899 0 146,696 0 39 0 0 46 0 11,086 0 0 etendo.public.c_bpartner 899 0 913,968 0 402 0 0 1,841 41 352,377 0 0 etendo.pg_catalog.pg_class 899 0 203,078 0 21 0 0 19 0 4,579 0 0 etendo.public.ad_pinstance_para 899 0 79,684 0 0 0 0 44 0 8,272 0 0 etendo.profile.tables_list 899 0 5,005,434 0 0 0 0 47 0 11,327 0 0 etendo.public.ad_preference 899 0 1,579,031 0 1 0 0 44 0 8,272 0 0 etendo.pg_catalog.pg_type 899 0 151,251 0 11 0 0 49 0 11,809 0 0 etendo.profile.last_stat_wal 899 0 44,419 0 45 0 0 42 0 7,896 0 0 etendo.public.c_invoice 899 0 47,176,913 0 41 0 0 43 41 133,013 0 0 etendo.profile.last_stat_slru 899 0 123,309 0 42 0 0 42 0 7,896 0 0 etendo.pg_toast.pg_toast_45833 899 0 293,356 0 14 0 0 47 14 44,233 0 0 etendo.profile.last_stat_activity_count_srv1 899 0 277,948 0 76 0 0 47 40 103,001 0 0 etendo.profile.last_stat_statements_srv1 898 0 40,100,169 0 26 0 0 56 26 64,043 0 0 etendo.profile.last_stat_tablespaces_srv1 898 0 70,179 0 42 0 0 41 0 19,393 0 0 etendo.profile.last_stat_user_functions_srv1 898 0 20,882,496 0 11 0 0 46 11 37,295 0 0 etendo.profile.last_stat_tables_srv1 898 0 221,119,274 0 18 0 0 56 18 51,897 0 0 etendo.profile.last_stat_database_srv1 898 0 244,107 0 39 0 0 41 0 19,393 0 0 etendo.profile.last_stat_indexes_srv1 898 0 298,733,623 0 2 0 0 57 2 29,789 0 0 Total 56,633 0 744,890,255 113,063,376 3,416 0 0 4,688 1,085 3,474,096 15 15 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (3606.07) 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 postgres.pg_catalog.pg_shdepend 0 0 0 template1.pg_catalog.pg_shdepend 0 0 0 etendo.public.ad_process_request 0 0 40.1599999999996 etendo.profile.servers 0 0 0 etendo.profile.sample_stat_indexes_total 0 0 0 etendo.pg_catalog.pg_shdepend 0 0 0 etendo.profile.sample_stat_tables 0 0 194.09 etendo.public.m_storage_pending 0 0 35.0599999999995 etendo.profile.indexes_list 0 0 13.4499999999998 etendo.profile.last_stat_cluster 0 0 0 etendo.pg_catalog.pg_attribute 0 0 26.9800000000003 etendo.profile.sample_stat_slru 0 0 0 etendo.pg_toast.pg_toast_125223 0 0 0 etendo.profile.sample_stat_user_functions 0 0 8.98999999999985 etendo.pg_toast.pg_toast_2619 0 0 122.99 etendo.profile.sample_stat_indexes 0 0 27.0000000000003 etendo.pg_catalog.pg_statistic 0 0 470.639999999995 etendo.public.ad_session_usage_audit 0 0 331.110000000003 etendo.profile.sample_stat_tables_total 0 0 0 etendo.public.ad_audit_trail 0 0 279.57 etendo.profile.last_extension_versions 0 0 0 etendo.public.ad_process_run 0 0 59.2200000000004 etendo.public.ad_module 0 0 16.2799999999997 etendo.profile.funcs_list 0 0 0 etendo.profile.sample_statements 0 0 81.7900000000016 etendo.profile.samples 0 0 0 etendo.public.m_stock_proposed 0 0 0 etendo.public.ad_sequence 0 0 0 etendo.profile.sample_stat_wal 0 0 0 etendo.profile.sample_statements_total 0 0 0 etendo.public.m_storage_detail 0 0 17.9799999999997 etendo.profile.last_stat_archiver 0 0 0 etendo.profile.sample_stat_io 0 0 0 etendo.public.fin_financial_account 0 0 0 etendo.profile.sample_stat_archiver 0 0 0 etendo.profile.sample_stat_cluster 0 0 0 etendo.public.ad_session 0 0 53.9600000000005 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.public.ad_ep_instance_para 0 0 35.9599999999994 etendo.public.c_order 0 0 391.91 etendo.pg_toast.pg_toast_46165 0 0 109.46 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.public.ad_pinstance 0 0 8.98999999999985 etendo.profile.stmt_list 0 0 44.9999999999996 etendo.profile.sample_stat_database 0 0 0 etendo.public.c_bpartner 0 0 30.7199999999999 etendo.pg_catalog.pg_class 0 0 0 etendo.public.ad_pinstance_para 0 0 0 etendo.profile.tables_list 0 0 55.4900000000003 etendo.public.ad_preference 0 0 46.7299999999997 etendo.pg_catalog.pg_type 0 0 0 etendo.profile.last_stat_wal 0 0 0 etendo.public.c_invoice 0 0 561.059999999999 etendo.profile.last_stat_slru 0 0 0 etendo.pg_toast.pg_toast_45833 0 0 0.31 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 1,391.12999999999 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.last_stat_user_functions_srv1 0 0 251.19 etendo.profile.last_stat_tables_srv1 0 0 3,128.67 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 3,606.07 Total 0 0 11,441.96 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.public.ad_process_request 899 0 0 17,664,074 16,107,006 0 1,838,440 etendo.profile.servers 899 0 0 676,044 675,145 0 12,586 etendo.profile.sample_stat_indexes_total 899 0 0 2,700,580 2,095,016 0 31,165 etendo.pg_catalog.pg_shdepend 899 0 0 2,901,190 1,160,942 0 23,374 etendo.profile.last_stat_statements_srv1 898 0 0 740,375,623 740,017,968 0 39,533,528 etendo.profile.sample_stat_tables 899 0 0 165,754,971 127,810,836 0 5,533,079 etendo.public.m_storage_pending 899 0 0 32,932,168 20,720,152 0 1,038,345 etendo.profile.indexes_list 899 0 0 32,132,638 31,827,038 0 700,017 etendo.profile.last_stat_cluster 899 0 0 675,145 674,246 0 14,384 etendo.pg_catalog.pg_attribute 899 0 0 40,150,503 11,666,956 0 768,405 etendo.profile.sample_stat_slru 899 0 0 2,701,479 2,095,915 0 38,537 etendo.pg_toast.pg_toast_125223 899 0 0 186,992 120,466 0 33,263 etendo.profile.sample_stat_user_functions 899 0 0 34,554,625 26,720,041 0 323,399 etendo.pg_toast.pg_toast_2619 899 0 0 17,866,821 16,545,590 0 3,668,183 etendo.profile.sample_stat_indexes 899 0 0 49,186,634 37,951,456 0 782,186 etendo.pg_catalog.pg_statistic 899 0 0 282,818,599 277,695,198 0 18,430,238 etendo.public.ad_session_usage_audit 899 0 0 376,752,021 157,881,481 0 10,649,554 postgres.pg_catalog.pg_shdepend 900 0 0 2,904,425 1,162,236 0 23,400 etendo.profile.sample_stat_tables_total 899 0 0 6,076,314 4,713,795 0 159,302 etendo.public.ad_audit_trail 899 0 0 360,559,233 107,354,085 0 16,455,296 etendo.profile.last_extension_versions 899 0 0 4,726,015 4,719,722 0 64,308 etendo.public.ad_process_run 899 0 0 35,214,872 26,012,186 0 2,544,747 etendo.public.ad_module 899 0 0 7,147,954 6,930,396 0 543,353 etendo.profile.last_stat_tablespaces_srv1 898 0 0 1,348,782 1,346,986 0 21,312 template1.pg_catalog.pg_shdepend 900 0 0 2,904,420 1,162,227 0 23,400 etendo.profile.funcs_list 899 0 0 12,326,828 12,153,321 0 333,768 etendo.profile.sample_statements 899 0 0 49,600,317 38,756,616 0 2,480,581 etendo.profile.samples 899 0 0 675,146 523,755 0 4,495 etendo.profile.last_stat_user_functions_srv1 898 0 0 322,967,636 322,575,210 0 10,425,073 etendo.public.m_stock_proposed 899 0 0 4,795,266 2,823,759 0 152,830 etendo.public.ad_sequence 899 0 0 7,343,032 7,198,293 0 178,901 etendo.profile.sample_stat_wal 899 0 0 675,145 523,754 0 9,469 etendo.profile.sample_statements_total 899 0 0 1,350,292 1,047,510 0 56,697 etendo.public.m_storage_detail 899 0 0 24,079,715 8,448,802 0 771,342 etendo.profile.last_stat_archiver 899 0 0 675,145 674,246 0 6,293 etendo.profile.sample_stat_io 899 0 0 4,453,618 3,381,295 0 96,312 etendo.public.fin_financial_account 899 0 0 1,316,136 1,307,146 0 48,546 etendo.profile.sample_stat_archiver 899 0 0 675,145 523,754 0 6,293 etendo.profile.sample_stat_cluster 899 0 0 675,145 523,754 0 14,384 etendo.public.ad_session 899 0 0 54,559,411 53,653,219 0 1,610,109 etendo.profile.last_stat_tables_srv1 898 0 0 2,368,250,358 2,366,782,546 0 120,523,274 etendo.profile.sample_stat_tablespaces 899 0 0 1,350,290 1,047,508 0 10,488 etendo.profile.last_stat_io 899 0 0 10,047,164 10,033,679 0 223,850 etendo.profile.last_stat_database_srv1 898 0 0 2,697,564 2,693,972 0 108,358 etendo.public.ad_ep_instance_para 899 0 0 53,744,917 53,744,917 0 1,046,436 etendo.profile.last_stat_indexes_srv1 898 0 0 3,674,939,656 3,672,524,036 0 149,441,392 etendo.public.c_order 899 0 0 188,869,112 35,107,748 0 17,654,562 etendo.pg_toast.pg_toast_46165 899 0 0 14,449,496 14,007,188 0 3,611,475 etendo.profile.sample_stat_user_func_total 899 0 0 1,350,292 1,047,510 0 11,687 etendo.public.ad_pinstance 899 0 0 10,985,780 8,864,140 0 325,438 etendo.profile.stmt_list 899 0 0 28,862,200 28,427,204 0 2,133,205 etendo.profile.sample_stat_database 899 0 0 2,700,584 2,095,020 0 108,480 etendo.public.c_bpartner 899 0 0 12,660,617 3,338,886 0 714,705 etendo.pg_catalog.pg_class 899 0 0 4,659,955 1,317,368 0 119,447 etendo.public.ad_pinstance_para 899 0 0 1,439,299 649,977 0 43,152 etendo.profile.tables_list 899 0 0 114,041,370 113,090,828 0 2,481,285 etendo.public.ad_preference 899 0 0 11,692,264 11,016,216 0 1,529,199 etendo.pg_catalog.pg_type 899 0 0 4,593,225 2,321,884 0 108,779 etendo.profile.last_stat_wal 899 0 0 675,145 674,246 0 9,889 etendo.public.c_invoice 899 0 0 288,264,451 183,697,266 0 23,468,811 etendo.profile.last_stat_slru 899 0 0 3,375,725 3,371,230 0 48,006 etendo.pg_toast.pg_toast_45833 899 0 0 1,300,853 1,073,406 0 268,801 etendo.profile.last_stat_activity_count_srv1 899 0 0 5,492,318 5,492,318 0 133,771 Total 56,633 0 0 9,513,522,734 8,601,700,612 0 443,573,384 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.public.ad_process_request 899 0 0 0 etendo.profile.servers 899 0 0 0 etendo.profile.sample_stat_indexes_total 899 0 0 0 etendo.pg_catalog.pg_shdepend 899 0 0 0 etendo.profile.last_stat_statements_srv1 898 0 0 0 etendo.profile.sample_stat_tables 899 0 0 0 etendo.public.m_storage_pending 899 0 0 0 etendo.profile.indexes_list 899 0 0 0 etendo.profile.last_stat_cluster 899 0 0 0 etendo.pg_catalog.pg_attribute 899 0 0 0 etendo.profile.sample_stat_slru 899 0 0 0 etendo.pg_toast.pg_toast_125223 899 0 0 0 etendo.profile.sample_stat_user_functions 899 0 0 0 etendo.pg_toast.pg_toast_2619 899 0 0 0 etendo.profile.sample_stat_indexes 899 0 0 0 etendo.pg_catalog.pg_statistic 899 0 0 0 etendo.public.ad_session_usage_audit 899 0 0 0 postgres.pg_catalog.pg_shdepend 900 0 0 0 etendo.profile.sample_stat_tables_total 899 0 0 0 etendo.public.ad_audit_trail 899 0 0 0 etendo.profile.last_extension_versions 899 0 0 0 etendo.public.ad_process_run 899 0 0 0 etendo.public.ad_module 899 0 0 0 etendo.profile.last_stat_tablespaces_srv1 898 0 0 0 template1.pg_catalog.pg_shdepend 900 0 0 0 etendo.profile.funcs_list 899 0 0 0 etendo.profile.sample_statements 899 0 0 0 etendo.profile.samples 899 0 0 0 etendo.profile.last_stat_user_functions_srv1 898 0 0 0 etendo.public.m_stock_proposed 899 0 0 0 etendo.public.ad_sequence 899 0 0 0 etendo.profile.sample_stat_wal 899 0 0 0 etendo.profile.sample_statements_total 899 0 0 0 etendo.public.m_storage_detail 899 0 0 0 etendo.profile.last_stat_archiver 899 0 0 0 etendo.profile.sample_stat_io 899 0 0 0 etendo.public.fin_financial_account 899 0 0 0 etendo.profile.sample_stat_archiver 899 0 0 0 etendo.profile.sample_stat_cluster 899 0 0 0 etendo.public.ad_session 899 0 0 0 etendo.profile.last_stat_tables_srv1 898 0 0 0 etendo.profile.sample_stat_tablespaces 899 0 0 0 etendo.profile.last_stat_io 899 0 0 0 etendo.profile.last_stat_database_srv1 898 0 0 0 etendo.public.ad_ep_instance_para 899 0 0 0 etendo.profile.last_stat_indexes_srv1 898 0 0 0 etendo.public.c_order 899 0 0 0 etendo.pg_toast.pg_toast_46165 899 0 0 0 etendo.profile.sample_stat_user_func_total 899 0 0 0 etendo.public.ad_pinstance 899 0 0 0 etendo.profile.stmt_list 899 0 0 0 etendo.profile.sample_stat_database 899 0 0 0 etendo.public.c_bpartner 899 0 0 0 etendo.pg_catalog.pg_class 899 0 0 0 etendo.public.ad_pinstance_para 899 0 0 0 etendo.profile.tables_list 899 0 0 0 etendo.public.ad_preference 899 0 0 0 etendo.pg_catalog.pg_type 899 0 0 0 etendo.profile.last_stat_wal 899 0 0 0 etendo.public.c_invoice 899 0 0 0 etendo.profile.last_stat_slru 899 0 0 0 etendo.pg_toast.pg_toast_45833 899 0 0 0 etendo.profile.last_stat_activity_count_srv1 899 0 0 0 Total 56,633 0 0 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 07 3,780 13 08 3,780 12 09 3,780 5 10 3,780 7 11 3,772 6 12 3,761 9 13 3,780 6 14 3,780 7 15 3,780 7 16 3,779 9 17 3,747 9 18 3,774 8 19 3,780 9 20 3,780 13 21 3,779 6 22 1 0 - 4.37 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
- 49 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 49 Requests
- 8m9s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 34 Requests
User Request type Count Duration postgres Total 15 4m27s select 15 4m27s tad Total 34 3m42s select 34 3m42s Duration by user
Key values
- 4m27s (postgres) Main time consuming user
User Request type Count Duration postgres Total 15 4m27s select 15 4m27s tad Total 34 3m42s select 34 3m42s Queries by host
Key values
- 127.0.0.1 Main host
- 34 Requests
- 4m27s ([local])
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 34 Requests
- 4m27s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 16:13:05 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 22s13ms SELECT profile.take_sample ();[ Date: 2026-07-18 07:00:23 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 20s134ms 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-18 07:00:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 18s427ms SELECT profile.take_sample ();[ Date: 2026-07-18 14:00:20 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
4 18s381ms SELECT profile.take_sample ();[ Date: 2026-07-18 09:00:20 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5 18s331ms SELECT profile.take_sample ();[ Date: 2026-07-18 12:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
6 18s91ms SELECT profile.take_sample ();[ Date: 2026-07-18 08:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
7 17s880ms SELECT profile.take_sample ();[ Date: 2026-07-18 19:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
8 17s801ms SELECT profile.take_sample ();[ Date: 2026-07-18 11:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 17s749ms SELECT profile.take_sample ();[ Date: 2026-07-18 10:00:19 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 17s543ms SELECT profile.take_sample ();[ Date: 2026-07-18 20:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 17s291ms SELECT profile.take_sample ();[ Date: 2026-07-18 21:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 17s263ms SELECT profile.take_sample ();[ Date: 2026-07-18 18:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 16s837ms SELECT profile.take_sample ();[ Date: 2026-07-18 17:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14 16s814ms SELECT profile.take_sample ();[ Date: 2026-07-18 13:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15 16s710ms SELECT profile.take_sample ();[ Date: 2026-07-18 15:00:18 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
16 16s186ms SELECT profile.take_sample ();[ Date: 2026-07-18 16:00:17 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
17 13s439ms 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-18 12:00:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 13s245ms 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-18 09:00:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 13s63ms 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-18 14:00:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 12s875ms 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-18 08:00:14 - 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 4m27s 15 16s186ms 22s13ms 17s821ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 22s13ms 22s13ms 08 1 18s91ms 18s91ms 09 1 18s381ms 18s381ms 10 1 17s749ms 17s749ms 11 1 17s801ms 17s801ms 12 1 18s331ms 18s331ms 13 1 16s814ms 16s814ms 14 1 18s427ms 18s427ms 15 1 16s710ms 16s710ms 16 1 16s186ms 16s186ms 17 1 16s837ms 16s837ms 18 1 17s263ms 17s263ms 19 1 17s880ms 17s880ms 20 1 17s543ms 17s543ms 21 1 17s291ms 17s291ms [ User: postgres - Total duration: 4m27s - Times executed: 15 ]
[ Application: psql - Total duration: 4m27s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:23 Duration: 22s13ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 14:00:20 Duration: 18s427ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 09:00:20 Duration: 18s381ms Database: etendo User: postgres Remote: [local] Application: psql
2 3m11s 15 10s965ms 20s134ms 12s774ms 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 18 07 1 20s134ms 20s134ms 08 1 12s875ms 12s875ms 09 1 13s245ms 13s245ms 10 1 12s524ms 12s524ms 11 1 11s741ms 11s741ms 12 1 13s439ms 13s439ms 13 1 11s451ms 11s451ms 14 1 13s63ms 13s63ms 15 1 12s553ms 12s553ms 16 1 11s874ms 11s874ms 17 1 11s654ms 11s654ms 18 1 11s831ms 11s831ms 19 1 10s965ms 10s965ms 20 1 12s625ms 12s625ms 21 1 11s636ms 11s636ms [ User: tad - Total duration: 3m11s - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m11s - 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-18 07:00:21 Duration: 20s134ms 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-18 12:00:14 Duration: 13s439ms 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-18 09:00:14 Duration: 13s245ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 26s324ms 15 1s604ms 1s894ms 1s754ms 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 18 07 1 1s604ms 1s604ms 08 1 1s755ms 1s755ms 09 1 1s858ms 1s858ms 10 1 1s785ms 1s785ms 11 1 1s824ms 1s824ms 12 1 1s715ms 1s715ms 13 1 1s654ms 1s654ms 14 1 1s894ms 1s894ms 15 1 1s691ms 1s691ms 16 1 1s876ms 1s876ms 17 1 1s777ms 1s777ms 18 1 1s710ms 1s710ms 19 1 1s740ms 1s740ms 20 1 1s705ms 1s705ms 21 1 1s730ms 1s730ms [ User: tad - Total duration: 26s324ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s324ms - 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-18 14:00:17 Duration: 1s894ms 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-18 16:00:16 Duration: 1s876ms 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-18 09:00:17 Duration: 1s858ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 4s92ms 4 1s4ms 1s69ms 1s23ms 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 18 07 1 1s12ms 1s12ms 10 1 1s69ms 1s69ms 12 1 1s4ms 1s4ms 14 1 1s6ms 1s6ms [ User: tad - Total duration: 4s92ms - Times executed: 4 ]
[ Application: openbravo - Total duration: 4s92ms - Times executed: 4 ]
-
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-18 10:00:01 Duration: 1s69ms 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 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-18 07:00:01 Duration: 1s12ms 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 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-18 14:00:01 Duration: 1s6ms 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 4m27s 16s186ms 22s13ms 17s821ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 22s13ms 22s13ms 08 1 18s91ms 18s91ms 09 1 18s381ms 18s381ms 10 1 17s749ms 17s749ms 11 1 17s801ms 17s801ms 12 1 18s331ms 18s331ms 13 1 16s814ms 16s814ms 14 1 18s427ms 18s427ms 15 1 16s710ms 16s710ms 16 1 16s186ms 16s186ms 17 1 16s837ms 16s837ms 18 1 17s263ms 17s263ms 19 1 17s880ms 17s880ms 20 1 17s543ms 17s543ms 21 1 17s291ms 17s291ms [ User: postgres - Total duration: 4m27s - Times executed: 15 ]
[ Application: psql - Total duration: 4m27s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:23 Duration: 22s13ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 14:00:20 Duration: 18s427ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 09:00:20 Duration: 18s381ms Database: etendo User: postgres Remote: [local] Application: psql
2 15 3m11s 10s965ms 20s134ms 12s774ms 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 18 07 1 20s134ms 20s134ms 08 1 12s875ms 12s875ms 09 1 13s245ms 13s245ms 10 1 12s524ms 12s524ms 11 1 11s741ms 11s741ms 12 1 13s439ms 13s439ms 13 1 11s451ms 11s451ms 14 1 13s63ms 13s63ms 15 1 12s553ms 12s553ms 16 1 11s874ms 11s874ms 17 1 11s654ms 11s654ms 18 1 11s831ms 11s831ms 19 1 10s965ms 10s965ms 20 1 12s625ms 12s625ms 21 1 11s636ms 11s636ms [ User: tad - Total duration: 3m11s - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m11s - 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-18 07:00:21 Duration: 20s134ms 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-18 12:00:14 Duration: 13s439ms 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-18 09:00:14 Duration: 13s245ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 15 26s324ms 1s604ms 1s894ms 1s754ms 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 18 07 1 1s604ms 1s604ms 08 1 1s755ms 1s755ms 09 1 1s858ms 1s858ms 10 1 1s785ms 1s785ms 11 1 1s824ms 1s824ms 12 1 1s715ms 1s715ms 13 1 1s654ms 1s654ms 14 1 1s894ms 1s894ms 15 1 1s691ms 1s691ms 16 1 1s876ms 1s876ms 17 1 1s777ms 1s777ms 18 1 1s710ms 1s710ms 19 1 1s740ms 1s740ms 20 1 1s705ms 1s705ms 21 1 1s730ms 1s730ms [ User: tad - Total duration: 26s324ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s324ms - 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-18 14:00:17 Duration: 1s894ms 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-18 16:00:16 Duration: 1s876ms 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-18 09:00:17 Duration: 1s858ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 4 4s92ms 1s4ms 1s69ms 1s23ms 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 18 07 1 1s12ms 1s12ms 10 1 1s69ms 1s69ms 12 1 1s4ms 1s4ms 14 1 1s6ms 1s6ms [ User: tad - Total duration: 4s92ms - Times executed: 4 ]
[ Application: openbravo - Total duration: 4s92ms - Times executed: 4 ]
-
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-18 10:00:01 Duration: 1s69ms 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 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-18 07:00:01 Duration: 1s12ms 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 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-18 14:00:01 Duration: 1s6ms 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 16s186ms 22s13ms 17s821ms 15 4m27s select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 22s13ms 22s13ms 08 1 18s91ms 18s91ms 09 1 18s381ms 18s381ms 10 1 17s749ms 17s749ms 11 1 17s801ms 17s801ms 12 1 18s331ms 18s331ms 13 1 16s814ms 16s814ms 14 1 18s427ms 18s427ms 15 1 16s710ms 16s710ms 16 1 16s186ms 16s186ms 17 1 16s837ms 16s837ms 18 1 17s263ms 17s263ms 19 1 17s880ms 17s880ms 20 1 17s543ms 17s543ms 21 1 17s291ms 17s291ms [ User: postgres - Total duration: 4m27s - Times executed: 15 ]
[ Application: psql - Total duration: 4m27s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:23 Duration: 22s13ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 14:00:20 Duration: 18s427ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 09:00:20 Duration: 18s381ms Database: etendo User: postgres Remote: [local] Application: psql
2 10s965ms 20s134ms 12s774ms 15 3m11s 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 18 07 1 20s134ms 20s134ms 08 1 12s875ms 12s875ms 09 1 13s245ms 13s245ms 10 1 12s524ms 12s524ms 11 1 11s741ms 11s741ms 12 1 13s439ms 13s439ms 13 1 11s451ms 11s451ms 14 1 13s63ms 13s63ms 15 1 12s553ms 12s553ms 16 1 11s874ms 11s874ms 17 1 11s654ms 11s654ms 18 1 11s831ms 11s831ms 19 1 10s965ms 10s965ms 20 1 12s625ms 12s625ms 21 1 11s636ms 11s636ms [ User: tad - Total duration: 3m11s - Times executed: 15 ]
[ Application: openbravo - Total duration: 3m11s - 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-18 07:00:21 Duration: 20s134ms 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-18 12:00:14 Duration: 13s439ms 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-18 09:00:14 Duration: 13s245ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s604ms 1s894ms 1s754ms 15 26s324ms 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 18 07 1 1s604ms 1s604ms 08 1 1s755ms 1s755ms 09 1 1s858ms 1s858ms 10 1 1s785ms 1s785ms 11 1 1s824ms 1s824ms 12 1 1s715ms 1s715ms 13 1 1s654ms 1s654ms 14 1 1s894ms 1s894ms 15 1 1s691ms 1s691ms 16 1 1s876ms 1s876ms 17 1 1s777ms 1s777ms 18 1 1s710ms 1s710ms 19 1 1s740ms 1s740ms 20 1 1s705ms 1s705ms 21 1 1s730ms 1s730ms [ User: tad - Total duration: 26s324ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 26s324ms - 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-18 14:00:17 Duration: 1s894ms 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-18 16:00:16 Duration: 1s876ms 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-18 09:00:17 Duration: 1s858ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s4ms 1s69ms 1s23ms 4 4s92ms 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 18 07 1 1s12ms 1s12ms 10 1 1s69ms 1s69ms 12 1 1s4ms 1s4ms 14 1 1s6ms 1s6ms [ User: tad - Total duration: 4s92ms - Times executed: 4 ]
[ Application: openbravo - Total duration: 4s92ms - Times executed: 4 ]
-
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-18 10:00:01 Duration: 1s69ms 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 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-18 07:00:01 Duration: 1s12ms 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 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-18 14:00:01 Duration: 1s6ms 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,318 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