pgBadger-
Global information
- Generated on Fri Jul 17 23:00:07 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 44,624 log entries in 5s
- Log start from 2026-07-17 07:00:01 to 2026-07-17 21:59:31
-
Overview
Global Stats
- 3 Number of unique normalized queries
- 5 Number of queries
- 17s38ms Total query duration
- 2026-07-17 13:00:02 First query
- 2026-07-17 13:24:52 Last query
- 1 queries/s at 2026-07-17 13:00:02 Query peak
- 17s38ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 17s38ms 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
- 94 Total number of automatic vacuums
- 127 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 5,415 Total number of sessions
- 5 sessions at 2026-07-17 12:00:01 Session peak
- 1m58s Total duration of sessions
- 21ms Average duration of sessions
- 0 Average queries per session
- 3ms Average queries duration per session
- 18ms Average idle time per session
- 5,418 Total number of connections
- 6 connections/s at 2026-07-17 13:45:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-17 13:00:02 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-17 13:00:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 17s38ms 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 17 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 5 0ms 4s390ms 3s407ms 0ms 0ms 16s20ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 5 0 3s407ms 0ms 0ms 16s20ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 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 17 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 17 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 4 4.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% Day Hour Count Average / Second Jul 17 07 361 0.10/s 08 361 0.10/s 09 363 0.10/s 10 362 0.10/s 11 361 0.10/s 12 361 0.10/s 13 361 0.10/s 14 361 0.10/s 15 361 0.10/s 16 361 0.10/s 17 361 0.10/s 18 361 0.10/s 19 361 0.10/s 20 361 0.10/s 21 361 0.10/s Day Hour Count Average Duration Average idle time Jul 17 07 361 21ms 21ms 08 361 21ms 21ms 09 361 21ms 21ms 10 361 21ms 21ms 11 361 22ms 22ms 12 361 21ms 21ms 13 361 22ms 0ms 14 361 21ms 21ms 15 361 22ms 22ms 16 361 22ms 22ms 17 361 21ms 21ms 18 361 21ms 21ms 19 361 22ms 22ms 20 361 22ms 22ms 21 361 21ms 21ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-17 13:45:20 Date
Connections per database
Key values
- etendo Main Database
- 5,418 connections Total
Connections per user
Key values
- tad Main User
- 5,418 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-07-17 12:00:01 Date
Histogram of session times
Key values
- 5,399 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,415 sessions Total
Sessions per user
Key values
- tad Main User
- 5,415 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,415 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 3,257 buffers Checkpoint Peak
- 2026-07-17 13:29:48 Date
- 269.243 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-17 09:35:47 Date
Checkpoints distance
Key values
- 68.56 Mo Distance Peak
- 2026-07-17 13:29:48 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 17 07 1,276 137.939s 0.009s 137.966s 08 1,322 131.516s 0.009s 131.549s 09 2,730 282.771s 0.014s 282.812s 10 2,354 233.544s 0.025s 233.602s 11 1,701 168.755s 0.018s 168.814s 12 2,208 224.423s 0.021s 224.478s 13 6,069 548.211s 0.023s 548.282s 14 2,232 222.131s 0.021s 222.201s 15 1,580 159.322s 0.018s 159.375s 16 2,098 214.346s 0.008s 214.376s 17 1,335 132.615s 0.012s 132.655s 18 1,280 127.416s 0.01s 127.454s 19 1,507 149.968s 0.011s 150.002s 20 2,082 207.636s 0.011s 207.685s 21 1,380 137.033s 0.012s 137.068s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 17 07 0 0 0 184 0.001s 0.007s 08 0 1 0 172 0.001s 0.007s 09 0 1 0 321 0.002s 0.009s 10 0 1 0 608 0.002s 0.012s 11 0 1 0 271 0.002s 0.012s 12 0 1 0 518 0.002s 0.012s 13 0 4 0 901 0.002s 0.011s 14 0 1 0 453 0.002s 0.012s 15 0 0 0 215 0.002s 0.011s 16 0 1 0 194 0.001s 0.007s 17 0 1 0 174 0.002s 0.007s 18 0 1 0 167 0.001s 0.007s 19 0 0 0 176 0.001s 0.007s 20 0 1 0 208 0.002s 0.007s 21 0 1 0 173 0.002s 0.007s Day Hour Count Avg time (sec) Jul 17 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 Day Hour Mean distance Mean estimate Jul 17 07 1,700.86 kB 65,996.29 kB 08 1,678.00 kB 32,451.14 kB 09 1,540.33 kB 15,080.67 kB 10 1,543.17 kB 6,444.75 kB 11 1,248.17 kB 6,746.42 kB 12 1,424.67 kB 6,491.42 kB 13 5,365.55 kB 19,703.36 kB 14 1,494.50 kB 12,262.25 kB 15 1,272.82 kB 6,894.27 kB 16 1,808.43 kB 7,737.57 kB 17 1,559.00 kB 7,921.86 kB 18 1,494.86 kB 7,573.00 kB 19 1,616.43 kB 8,015.29 kB 20 2,208.29 kB 11,299.86 kB 21 1,571.71 kB 7,975.43 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 17 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.30 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-17 09:00:36 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.30 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-17 09:00:36 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 127 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.public.ad_session 9 etendo.profile.tables_list 8 etendo.profile.last_stat_io 8 etendo.profile.last_extension_versions 5 etendo.profile.stmt_list 4 etendo.profile.indexes_list 4 etendo.profile.funcs_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.ad_ep_instance_para 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_tables 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tables_total 1 etendo.public.m_inoutline 1 etendo.profile.sample_statements 1 etendo.public.ad_process_request 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_slru 1 Total 127 Vacuums per table
Key values
- profile.last_stat_indexes_srv1 (15) Main table vacuumed on database etendo
- 94 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.last_stat_indexes_srv1 15 15 17,826 0 323 0 0 13,130 2,816 3,243,054 74 547 etendo.profile.last_stat_user_functions_srv1 15 15 2,348 0 51 0 0 1,563 329 1,352,116 242 3,566 etendo.profile.last_stat_statements_srv1 15 15 6,115 0 90 0 0 4,497 1,090 4,057,595 665 6,513 etendo.profile.last_stat_tables_srv1 15 15 13,617 0 169 0 0 10,455 2,194 2,514,780 127 964 etendo.profile.tables_list 6 6 1,011 0 17 0 0 681 165 1,018,590 109 1,369 etendo.profile.last_stat_io 4 4 229 0 20 0 0 23 14 77,577 3 42 etendo.profile.last_extension_versions 3 3 154 0 15 0 0 17 10 53,128 2 18 etendo.profile.indexes_list 3 3 428 0 19 0 0 139 60 374,364 26 291 etendo.profile.funcs_list 3 3 277 0 16 0 0 102 39 231,029 21 235 etendo.profile.stmt_list 3 3 679 0 32 0 0 469 130 846,122 74 285 etendo.public.ad_ep_instance_para 2 2 120 0 10 0 0 14 4 32,962 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 46 0 8 0 0 12 3 18,365 0 0 etendo.profile.last_stat_database_srv1 1 1 49 0 6 0 0 7 5 24,298 1 4 etendo.pg_toast.pg_toast_2619 1 1 851 0 150 0 0 423 130 303,671 47 100 etendo.profile.sample_stat_user_functions 1 1 233 0 69 0 0 90 17 85,996 0 0 etendo.profile.sample_stat_tables 1 1 2,512 0 1,185 0 0 1,270 85 403,481 0 0 etendo.profile.sample_statements_total 1 1 99 0 27 0 0 32 4 16,438 0 0 etendo.profile.last_stat_slru 1 1 69 0 5 0 0 6 4 17,601 1 5 etendo.profile.sample_statements 1 1 1,493 0 667 0 0 760 79 267,785 0 0 etendo.public.m_inoutline 1 1 6,544 0 263 0 0 4,715 2,013 4,194,732 47 47 Total 94 92 54,700 225 3,142 0 0 38,405 9,191 19,133,684 1,439 13,986 Vacuum throughput per table
Key values
- profile.sample_stat_tables (0.3) 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.last_stat_indexes_srv1 0 0 0.25 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 0.03 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.public.ad_ep_instance_para 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.04 etendo.profile.sample_stat_user_functions 0 0 0.01 etendo.profile.sample_stat_tables 0 0 0.3 etendo.profile.sample_statements_total 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.sample_statements 0 0 0.16 etendo.public.m_inoutline 0 0 0.17 Total 0 0 1.11 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (81998) Main table with removed tuples on database etendo
- 166033 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 81,998 40,575 0 221 4,772 etendo.profile.last_stat_tables_srv1 15 15 52,147 24,635 0 0 4,014 etendo.profile.last_stat_statements_srv1 15 15 11,962 9,902 0 159 1,082 etendo.public.m_inoutline 1 1 9,199 20,106 0 0 2,142 etendo.profile.last_stat_user_functions_srv1 15 15 6,411 5,745 0 1 396 etendo.profile.sample_stat_tables 1 1 1,087 31,900 0 0 1,136 etendo.profile.tables_list 6 6 948 5,895 0 0 180 etendo.profile.sample_statements 1 1 765 11,686 0 0 628 etendo.pg_toast.pg_toast_2619 1 1 321 1,682 0 0 637 etendo.profile.sample_stat_user_functions 1 1 289 6,418 0 0 65 etendo.profile.stmt_list 3 3 203 1,850 0 0 155 etendo.profile.last_extension_versions 3 3 162 27 0 0 3 etendo.profile.funcs_list 3 3 158 553 0 0 24 etendo.profile.indexes_list 3 3 149 1,122 0 0 30 etendo.profile.last_stat_io 4 4 56 56 0 0 4 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.sample_statements_total 1 1 42 504 0 0 24 etendo.public.ad_ep_instance_para 2 2 29 0 0 2 0 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 94 92 166,033 162,665 0 385 15,294 Pages removed per table
Key values
- profile.last_stat_indexes_srv1 (221) Main table with removed pages on database etendo
- 385 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_indexes_srv1 15 15 81998 221 etendo.profile.last_stat_statements_srv1 15 15 11962 159 etendo.public.ad_ep_instance_para 2 2 29 2 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.last_stat_user_functions_srv1 15 15 6411 1 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.last_extension_versions 3 3 162 0 etendo.pg_toast.pg_toast_2619 1 1 321 0 etendo.profile.last_stat_io 4 4 56 0 etendo.profile.sample_stat_user_functions 1 1 289 0 etendo.profile.sample_stat_tables 1 1 1087 0 etendo.profile.sample_statements_total 1 1 42 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.profile.sample_statements 1 1 765 0 etendo.profile.indexes_list 3 3 149 0 etendo.public.m_inoutline 1 1 9199 0 etendo.profile.tables_list 6 6 948 0 etendo.profile.funcs_list 3 3 158 0 etendo.profile.last_stat_tables_srv1 15 15 52147 0 etendo.profile.stmt_list 3 3 203 0 Total 94 92 166,033 385 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 17 07 6 7 08 5 4 09 6 8 10 7 9 11 7 9 12 5 14 13 9 11 14 6 8 15 8 12 16 7 7 17 5 6 18 5 6 19 7 10 20 4 6 21 7 10 - 0.30 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
- 5 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 5 Requests
- 17s38ms (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 4 Requests
User Request type Count Duration postgres Total 1 1s18ms select 1 1s18ms tad Total 4 16s20ms select 4 16s20ms Duration by user
Key values
- 16s20ms (tad) Main time consuming user
User Request type Count Duration postgres Total 1 1s18ms select 1 1s18ms tad Total 4 16s20ms select 4 16s20ms Queries by host
Key values
- 127.0.0.1 Main host
- 4 Requests
- 16s20ms (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 4 Requests
- 16s20ms (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-17 12:24:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 5 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 4s390ms select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('C41D328865AD42AA93973AE1FEFFD4A1', '1E70A1DA717940A38DA1FB5DFB4636FE', '8E90D5F920CE46438FE16F5C6906E677', '78EC3418B39E488A81515713D44BF7BA', '27F6B640A6234864969D4ABDE265CA65', '3F90E918CEFE495183BAD0A611983C83', 'AFE230B89E264FD9840BA262B9AF1BF2', '4F99909FB256422EA4B2028F888BFA21', 'AA54856D7D804DB59A0B824B6D5DE883', '7A4CE4B564A444B39D20C7E050AA2994', '869BFBB2749249AB9A923B5D8C3D7156', '5D197AEE7D6949C19640C5D062A60B6D', '024038AC0C3541C0AFFF0BFB13923BA7', '4E0AA18D6C97442EA9EB9952366F0564', 'B165433237AF4964A723EA1E16FDCA43', 'B14916D0619C4262A7D575220ECE72A2', '0AB9A733648D4D338B9C2FB4ED97E59A', 'B66FEE2D396A4C3F83DC5E5A0C214208', '1FF369653A514C8D959C116F06370D17', '8AF9C63DB5C44C43852D491616F08C94', 'C0E3121D975B4AEC874CD68DE701A5E2', 'FDD4CE6D154F4E02839512C2F6F07F01', '8629C7933A1C4D00A78B0A4B989B961D', 'BA1F2F6CEBEA4C549AFAA2BF8086FB19', '0AC3EAA466F0406F877E16C3D813B21F', 'E8DC822B5AE9478D87EA935767B30388', '9911C99E1FC9454CB3EE87B333A153BA', '4BA75BB72744404E83F6078319F5DA72', '36269CA4D91A46AAB82C998D280BB603', '44A61EB14D6C4339BA3BBED61344F92E', '84696E48FACB4986B14509BE750265AE', '7CCAB9341DF54FBF8CE7D3EF1457B318', '7DB90C0248DA4E85B62EC6F1EBA62B53', '6B67FE1F3D9444BB803CE6F3AFA5F2C5', '31B8BCF4EF5A4FFC8BBBF776C2C0D5A2', 'D33E647C8328429089B14545E5EEDD34', '388859B575B84205999F5882B071592A', 'A87A20F1346E4CDB963CE9B7CD3EAA48', '96DFEAE166054936A60221D65BFF500B', '1ED75391B9C346A1BF248A87E62251D5', 'AB7501C333CA41BFBDA43348C298CC34', '0698731C984148238289D22601367F8A', '0243AB0D58AA424494F44B935CEC7C67', '430BCDFF756F4C56A389E884D6AD762F', 'C4778A1C01C04C87BB36C8648F744440', 'DAF3A9A457284F4BBBBBB52602D3723E', '9B8488C14AF04B5C9657DA4D63E028A1', '673F7879CB8245DCA44505334539126C', '2653EA509DB24E5596BFA2E0C4F3AEA3', 'A5CF99895A54421A9EFE36610B7AB2B3');[ Date: 2026-07-17 13:24:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 4s194ms select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('5BB7062942934BC9A7122DE38B3DA3B2', '1ADA3E552866479F85D05B62CBBA82D3', 'BBC58CBF99A843EBB5577B3B831FEEE6', '2F44F8DC812149DCA6E5521845DA7151', '504BAC8EE28E4F6E8FC783F442D3DAAE', 'DBA45AC582A9463B80AD2E96A1ACE2E9', 'D9B29C19D7494F15AA0D152F43AC5D5B', 'DE8D8920D1674C589AEE7B57D4325D40', '957D012A89354D9BBD40954C5F325FF4', 'CE835EAC08BA4532BEF9A8BE0237A9CC', 'DFFEFB95487B4BFCBADD80F87F6AB31A', '99CC871B07934353AF8E469B8D158D7A', 'C31A59ED716D4C438682DFE59F52775E', '691AC798596D4675817ED5DC89E94A76', '1D96BB0006E74802AF2B924AE75E0A46', '320B7416F4134BE28502FCCCD26E4473', 'AEF1BB94290B43888E467D257BBAAAD3', 'ECD609736B5D4F32B9690DE2EC0D3231', 'C993769DD0484ECDB0A9F4D451896CF3', 'CA91A9AC257D4FD7AE16806F80F934C6', '9B0D4011C64540D3B0EC080665377676', '65CF1BCDFB3B42F9BBFA23DDC35A9F84', 'D14CCA440F37410FB8A3E09B444EE567', '9C1E8ABF6D204E5DA55B68F3771CDF22', '28F290CDD1CB4AB99C1BA584BB22116E', 'C64269760EEF46BF82FABF54E7C3703A', 'E42A71BC46B94BBDA0196CE08A83C147', '34479D695E884F95A5D13EF6A67F147D', '43C746714E8644199CB87105F7F4AB8D', 'C8AAAC29D75C4634AC830FDD4DC98548', '24A45FE2E28A45C09D785B150558F63C', '5A75BB86F87147F2B843B0053081E245', '44CC3400120B4D529EDC0F639D34CBFF', '76011A0633134811B5C60C3A17B27C1C', '844DD980C7304AB98653C2B1F703421F', '5D3D680B78A840FE8951DC01B4484A1C', '7E4AFCC9BB8C4449B4188B1D20AD41B1', '12E42E6FC9DD47CABC90BACCEA8D2932', '8046C871CC2E4D589531B00393781114', '005B574993A34D4DAAADBA8C16B319B3', 'A0A4C89378E74A96A8D2E171C73800AA', '94663AEC882C458DBFA744A249B861B3', '9E829603A4074140A793286F4665D6BA', '1511659E5F854DC6834D09D638231684', 'EC7A97EBA78F431A8B3926C351BE0053', '6FF11E36840E4F80ABCB07155C1B24F0', '937A3EDA062C4BAA81FC75449CF2C724', 'D421F3F053524361A73E5A54B7F0F23A', '471EC858704749469FEE9DFEA85CF450', '103DBD1BEA0D46B39955FC29352DA922');[ Date: 2026-07-17 13:24:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 4s126ms SELECT * FROM M_InOut_Post0 ('E6A955B984804585947D8A709DD816D6');[ Date: 2026-07-17 13:24:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 3s308ms select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('91E2C101F412448DA83F1E79198CED2B', '5CBF80E5459D4A27BC02AFE3E4398A8E', 'A3DAF905FC2445E29A6A7EB8A27E9185', 'FC8D2CDE782D4EA3B4EEF6EE8BE4E3BC', 'D0C7AC150B4F4586988FC3DF75394A9C', 'BC75247419AD4B53BFB8A9BF40DA3FF6', '70E13CDB9A7C425885389A663C8BF4EF', '33F4537F74314A43B05E88E47A6354C3', 'D9F82DD1999D43A3A099731E59EEDEA4', 'C36BDF0BFBC8442F9B44AAC455FE4FB2', '606E0E91A3A94053BE9150EB7108DA3B', 'F15C6A003B004FD0B02DE854C54C3D0F', 'A630DEF9AF3540089FC034C2E157A91C', 'E7F5E311A0CC43C6A92347D5C7725151', 'D213042C418340D59CDEAD1E9C62B6E4', '098D64E68B954B9B82930C08BE53F845', '262EA05477474C1B904386184950D818', 'B51EBA1B9F464E6D91A32E10321ECAEC', 'F4453E89492F4FC4A2AB1A57058A9713', '43CC8B4F50EB43CFA621ABE3BC57B817', '9F7D604558A542A78EEB270788FE005F', '97C8E4E717524C67A87859735DE574BA', '18DC89BC68074050B40B97DD461C0BF1', 'CBDA03DB6B364B4A84EE15CCC00FA5AC', '258AFEC4B19448939692B2C8EAD5F0A0', '50DDF392EC62427995C367714E647E82', 'F984B722058B4D19B99E608ECFE5F0A4', '1B3677AB247D4E7F82683730329BBF6B', '19E1172487064EE7BF31C97E8D1003A0', 'D7B40E022D9B49969250DFB66FEB5170', 'B5CCDC8D0BDB40EA9B06B78A4725F80F', '524627668BA8417FB2A29418143DB5B6', '45E83CDDA5954900BA80A69996226097', '7D347BDD15DF40F98FE17033D0422E89', '0A9A430E4E644086A4B270E2C6744002', '0053A6A9189246909A9E1A0D45E8F224', 'D3A36D3077B845B0941F381745DA6458', '582DCA19118449F3B4BFED3705FEA330', '62BADB749BDA4DA486C67DD95D07FEC5', 'D496702DB1A5421B8F91DC8A235C37F9', 'E8BF2269094D45958DE529D7884166AC', 'F33F66DCE95648098EB66EBD79C4D02F', '1734E5BCA64D40A4AB743D04DAB994F3', '4D2D77165C3E4B94B17251739AB28777', '87CA47C6B57A4DC3A4C8A06A7DB0F6CD', '7BDA9D33681B4FBBBCEA4A64F167FE60', 'B580A322EA0F4510B874B30722808AF6', 'ACF16C5F82A34626B88B67959E9A7324', '8F38335A1E46481EA1E87D8CC31B29D0', '8433BFC049014BBAA1F5D6FCF40807EC');[ Date: 2026-07-17 13:24:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 1s18ms SELECT profile.take_sample ();[ Date: 2026-07-17 13:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 11s893ms 3 3s308ms 4s390ms 3s964ms select shipmentin0_.m_inout_id as m_inout_1_495_0_, shipmentin0_.ad_client_id as ad_clien2_495_0_, shipmentin0_.ad_org_id as ad_org_i3_495_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula31_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 3 11s893ms 3s964ms [ User: tad - Total duration: 11s893ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 11s893ms - Times executed: 3 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('C41D328865AD42AA93973AE1FEFFD4A1', '1E70A1DA717940A38DA1FB5DFB4636FE', '8E90D5F920CE46438FE16F5C6906E677', '78EC3418B39E488A81515713D44BF7BA', '27F6B640A6234864969D4ABDE265CA65', '3F90E918CEFE495183BAD0A611983C83', 'AFE230B89E264FD9840BA262B9AF1BF2', '4F99909FB256422EA4B2028F888BFA21', 'AA54856D7D804DB59A0B824B6D5DE883', '7A4CE4B564A444B39D20C7E050AA2994', '869BFBB2749249AB9A923B5D8C3D7156', '5D197AEE7D6949C19640C5D062A60B6D', '024038AC0C3541C0AFFF0BFB13923BA7', '4E0AA18D6C97442EA9EB9952366F0564', 'B165433237AF4964A723EA1E16FDCA43', 'B14916D0619C4262A7D575220ECE72A2', '0AB9A733648D4D338B9C2FB4ED97E59A', 'B66FEE2D396A4C3F83DC5E5A0C214208', '1FF369653A514C8D959C116F06370D17', '8AF9C63DB5C44C43852D491616F08C94', 'C0E3121D975B4AEC874CD68DE701A5E2', 'FDD4CE6D154F4E02839512C2F6F07F01', '8629C7933A1C4D00A78B0A4B989B961D', 'BA1F2F6CEBEA4C549AFAA2BF8086FB19', '0AC3EAA466F0406F877E16C3D813B21F', 'E8DC822B5AE9478D87EA935767B30388', '9911C99E1FC9454CB3EE87B333A153BA', '4BA75BB72744404E83F6078319F5DA72', '36269CA4D91A46AAB82C998D280BB603', '44A61EB14D6C4339BA3BBED61344F92E', '84696E48FACB4986B14509BE750265AE', '7CCAB9341DF54FBF8CE7D3EF1457B318', '7DB90C0248DA4E85B62EC6F1EBA62B53', '6B67FE1F3D9444BB803CE6F3AFA5F2C5', '31B8BCF4EF5A4FFC8BBBF776C2C0D5A2', 'D33E647C8328429089B14545E5EEDD34', '388859B575B84205999F5882B071592A', 'A87A20F1346E4CDB963CE9B7CD3EAA48', '96DFEAE166054936A60221D65BFF500B', '1ED75391B9C346A1BF248A87E62251D5', 'AB7501C333CA41BFBDA43348C298CC34', '0698731C984148238289D22601367F8A', '0243AB0D58AA424494F44B935CEC7C67', '430BCDFF756F4C56A389E884D6AD762F', 'C4778A1C01C04C87BB36C8648F744440', 'DAF3A9A457284F4BBBBBB52602D3723E', '9B8488C14AF04B5C9657DA4D63E028A1', '673F7879CB8245DCA44505334539126C', '2653EA509DB24E5596BFA2E0C4F3AEA3', 'A5CF99895A54421A9EFE36610B7AB2B3');
Date: 2026-07-17 13:24:40 Duration: 4s390ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('5BB7062942934BC9A7122DE38B3DA3B2', '1ADA3E552866479F85D05B62CBBA82D3', 'BBC58CBF99A843EBB5577B3B831FEEE6', '2F44F8DC812149DCA6E5521845DA7151', '504BAC8EE28E4F6E8FC783F442D3DAAE', 'DBA45AC582A9463B80AD2E96A1ACE2E9', 'D9B29C19D7494F15AA0D152F43AC5D5B', 'DE8D8920D1674C589AEE7B57D4325D40', '957D012A89354D9BBD40954C5F325FF4', 'CE835EAC08BA4532BEF9A8BE0237A9CC', 'DFFEFB95487B4BFCBADD80F87F6AB31A', '99CC871B07934353AF8E469B8D158D7A', 'C31A59ED716D4C438682DFE59F52775E', '691AC798596D4675817ED5DC89E94A76', '1D96BB0006E74802AF2B924AE75E0A46', '320B7416F4134BE28502FCCCD26E4473', 'AEF1BB94290B43888E467D257BBAAAD3', 'ECD609736B5D4F32B9690DE2EC0D3231', 'C993769DD0484ECDB0A9F4D451896CF3', 'CA91A9AC257D4FD7AE16806F80F934C6', '9B0D4011C64540D3B0EC080665377676', '65CF1BCDFB3B42F9BBFA23DDC35A9F84', 'D14CCA440F37410FB8A3E09B444EE567', '9C1E8ABF6D204E5DA55B68F3771CDF22', '28F290CDD1CB4AB99C1BA584BB22116E', 'C64269760EEF46BF82FABF54E7C3703A', 'E42A71BC46B94BBDA0196CE08A83C147', '34479D695E884F95A5D13EF6A67F147D', '43C746714E8644199CB87105F7F4AB8D', 'C8AAAC29D75C4634AC830FDD4DC98548', '24A45FE2E28A45C09D785B150558F63C', '5A75BB86F87147F2B843B0053081E245', '44CC3400120B4D529EDC0F639D34CBFF', '76011A0633134811B5C60C3A17B27C1C', '844DD980C7304AB98653C2B1F703421F', '5D3D680B78A840FE8951DC01B4484A1C', '7E4AFCC9BB8C4449B4188B1D20AD41B1', '12E42E6FC9DD47CABC90BACCEA8D2932', '8046C871CC2E4D589531B00393781114', '005B574993A34D4DAAADBA8C16B319B3', 'A0A4C89378E74A96A8D2E171C73800AA', '94663AEC882C458DBFA744A249B861B3', '9E829603A4074140A793286F4665D6BA', '1511659E5F854DC6834D09D638231684', 'EC7A97EBA78F431A8B3926C351BE0053', '6FF11E36840E4F80ABCB07155C1B24F0', '937A3EDA062C4BAA81FC75449CF2C724', 'D421F3F053524361A73E5A54B7F0F23A', '471EC858704749469FEE9DFEA85CF450', '103DBD1BEA0D46B39955FC29352DA922');
Date: 2026-07-17 13:24:45 Duration: 4s194ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('91E2C101F412448DA83F1E79198CED2B', '5CBF80E5459D4A27BC02AFE3E4398A8E', 'A3DAF905FC2445E29A6A7EB8A27E9185', 'FC8D2CDE782D4EA3B4EEF6EE8BE4E3BC', 'D0C7AC150B4F4586988FC3DF75394A9C', 'BC75247419AD4B53BFB8A9BF40DA3FF6', '70E13CDB9A7C425885389A663C8BF4EF', '33F4537F74314A43B05E88E47A6354C3', 'D9F82DD1999D43A3A099731E59EEDEA4', 'C36BDF0BFBC8442F9B44AAC455FE4FB2', '606E0E91A3A94053BE9150EB7108DA3B', 'F15C6A003B004FD0B02DE854C54C3D0F', 'A630DEF9AF3540089FC034C2E157A91C', 'E7F5E311A0CC43C6A92347D5C7725151', 'D213042C418340D59CDEAD1E9C62B6E4', '098D64E68B954B9B82930C08BE53F845', '262EA05477474C1B904386184950D818', 'B51EBA1B9F464E6D91A32E10321ECAEC', 'F4453E89492F4FC4A2AB1A57058A9713', '43CC8B4F50EB43CFA621ABE3BC57B817', '9F7D604558A542A78EEB270788FE005F', '97C8E4E717524C67A87859735DE574BA', '18DC89BC68074050B40B97DD461C0BF1', 'CBDA03DB6B364B4A84EE15CCC00FA5AC', '258AFEC4B19448939692B2C8EAD5F0A0', '50DDF392EC62427995C367714E647E82', 'F984B722058B4D19B99E608ECFE5F0A4', '1B3677AB247D4E7F82683730329BBF6B', '19E1172487064EE7BF31C97E8D1003A0', 'D7B40E022D9B49969250DFB66FEB5170', 'B5CCDC8D0BDB40EA9B06B78A4725F80F', '524627668BA8417FB2A29418143DB5B6', '45E83CDDA5954900BA80A69996226097', '7D347BDD15DF40F98FE17033D0422E89', '0A9A430E4E644086A4B270E2C6744002', '0053A6A9189246909A9E1A0D45E8F224', 'D3A36D3077B845B0941F381745DA6458', '582DCA19118449F3B4BFED3705FEA330', '62BADB749BDA4DA486C67DD95D07FEC5', 'D496702DB1A5421B8F91DC8A235C37F9', 'E8BF2269094D45958DE529D7884166AC', 'F33F66DCE95648098EB66EBD79C4D02F', '1734E5BCA64D40A4AB743D04DAB994F3', '4D2D77165C3E4B94B17251739AB28777', '87CA47C6B57A4DC3A4C8A06A7DB0F6CD', '7BDA9D33681B4FBBBCEA4A64F167FE60', 'B580A322EA0F4510B874B30722808AF6', 'ACF16C5F82A34626B88B67959E9A7324', '8F38335A1E46481EA1E87D8CC31B29D0', '8433BFC049014BBAA1F5D6FCF40807EC');
Date: 2026-07-17 13:24:39 Duration: 3s308ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 4s126ms 1 4s126ms 4s126ms 4s126ms select * from m_inout_post0 (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 13 1 4s126ms 4s126ms [ User: tad - Total duration: 4s126ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s126ms - Times executed: 1 ]
-
SELECT * FROM M_InOut_Post0 ('E6A955B984804585947D8A709DD816D6');
Date: 2026-07-17 13:24:52 Duration: 4s126ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s18ms 1 1s18ms 1s18ms 1s18ms select profile.take_sample ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 13 1 1s18ms 1s18ms [ User: postgres - Total duration: 1s18ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s18ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s18ms Database: etendo User: postgres Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3 11s893ms 3s308ms 4s390ms 3s964ms select shipmentin0_.m_inout_id as m_inout_1_495_0_, shipmentin0_.ad_client_id as ad_clien2_495_0_, shipmentin0_.ad_org_id as ad_org_i3_495_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula31_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 3 11s893ms 3s964ms [ User: tad - Total duration: 11s893ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 11s893ms - Times executed: 3 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('C41D328865AD42AA93973AE1FEFFD4A1', '1E70A1DA717940A38DA1FB5DFB4636FE', '8E90D5F920CE46438FE16F5C6906E677', '78EC3418B39E488A81515713D44BF7BA', '27F6B640A6234864969D4ABDE265CA65', '3F90E918CEFE495183BAD0A611983C83', 'AFE230B89E264FD9840BA262B9AF1BF2', '4F99909FB256422EA4B2028F888BFA21', 'AA54856D7D804DB59A0B824B6D5DE883', '7A4CE4B564A444B39D20C7E050AA2994', '869BFBB2749249AB9A923B5D8C3D7156', '5D197AEE7D6949C19640C5D062A60B6D', '024038AC0C3541C0AFFF0BFB13923BA7', '4E0AA18D6C97442EA9EB9952366F0564', 'B165433237AF4964A723EA1E16FDCA43', 'B14916D0619C4262A7D575220ECE72A2', '0AB9A733648D4D338B9C2FB4ED97E59A', 'B66FEE2D396A4C3F83DC5E5A0C214208', '1FF369653A514C8D959C116F06370D17', '8AF9C63DB5C44C43852D491616F08C94', 'C0E3121D975B4AEC874CD68DE701A5E2', 'FDD4CE6D154F4E02839512C2F6F07F01', '8629C7933A1C4D00A78B0A4B989B961D', 'BA1F2F6CEBEA4C549AFAA2BF8086FB19', '0AC3EAA466F0406F877E16C3D813B21F', 'E8DC822B5AE9478D87EA935767B30388', '9911C99E1FC9454CB3EE87B333A153BA', '4BA75BB72744404E83F6078319F5DA72', '36269CA4D91A46AAB82C998D280BB603', '44A61EB14D6C4339BA3BBED61344F92E', '84696E48FACB4986B14509BE750265AE', '7CCAB9341DF54FBF8CE7D3EF1457B318', '7DB90C0248DA4E85B62EC6F1EBA62B53', '6B67FE1F3D9444BB803CE6F3AFA5F2C5', '31B8BCF4EF5A4FFC8BBBF776C2C0D5A2', 'D33E647C8328429089B14545E5EEDD34', '388859B575B84205999F5882B071592A', 'A87A20F1346E4CDB963CE9B7CD3EAA48', '96DFEAE166054936A60221D65BFF500B', '1ED75391B9C346A1BF248A87E62251D5', 'AB7501C333CA41BFBDA43348C298CC34', '0698731C984148238289D22601367F8A', '0243AB0D58AA424494F44B935CEC7C67', '430BCDFF756F4C56A389E884D6AD762F', 'C4778A1C01C04C87BB36C8648F744440', 'DAF3A9A457284F4BBBBBB52602D3723E', '9B8488C14AF04B5C9657DA4D63E028A1', '673F7879CB8245DCA44505334539126C', '2653EA509DB24E5596BFA2E0C4F3AEA3', 'A5CF99895A54421A9EFE36610B7AB2B3');
Date: 2026-07-17 13:24:40 Duration: 4s390ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('5BB7062942934BC9A7122DE38B3DA3B2', '1ADA3E552866479F85D05B62CBBA82D3', 'BBC58CBF99A843EBB5577B3B831FEEE6', '2F44F8DC812149DCA6E5521845DA7151', '504BAC8EE28E4F6E8FC783F442D3DAAE', 'DBA45AC582A9463B80AD2E96A1ACE2E9', 'D9B29C19D7494F15AA0D152F43AC5D5B', 'DE8D8920D1674C589AEE7B57D4325D40', '957D012A89354D9BBD40954C5F325FF4', 'CE835EAC08BA4532BEF9A8BE0237A9CC', 'DFFEFB95487B4BFCBADD80F87F6AB31A', '99CC871B07934353AF8E469B8D158D7A', 'C31A59ED716D4C438682DFE59F52775E', '691AC798596D4675817ED5DC89E94A76', '1D96BB0006E74802AF2B924AE75E0A46', '320B7416F4134BE28502FCCCD26E4473', 'AEF1BB94290B43888E467D257BBAAAD3', 'ECD609736B5D4F32B9690DE2EC0D3231', 'C993769DD0484ECDB0A9F4D451896CF3', 'CA91A9AC257D4FD7AE16806F80F934C6', '9B0D4011C64540D3B0EC080665377676', '65CF1BCDFB3B42F9BBFA23DDC35A9F84', 'D14CCA440F37410FB8A3E09B444EE567', '9C1E8ABF6D204E5DA55B68F3771CDF22', '28F290CDD1CB4AB99C1BA584BB22116E', 'C64269760EEF46BF82FABF54E7C3703A', 'E42A71BC46B94BBDA0196CE08A83C147', '34479D695E884F95A5D13EF6A67F147D', '43C746714E8644199CB87105F7F4AB8D', 'C8AAAC29D75C4634AC830FDD4DC98548', '24A45FE2E28A45C09D785B150558F63C', '5A75BB86F87147F2B843B0053081E245', '44CC3400120B4D529EDC0F639D34CBFF', '76011A0633134811B5C60C3A17B27C1C', '844DD980C7304AB98653C2B1F703421F', '5D3D680B78A840FE8951DC01B4484A1C', '7E4AFCC9BB8C4449B4188B1D20AD41B1', '12E42E6FC9DD47CABC90BACCEA8D2932', '8046C871CC2E4D589531B00393781114', '005B574993A34D4DAAADBA8C16B319B3', 'A0A4C89378E74A96A8D2E171C73800AA', '94663AEC882C458DBFA744A249B861B3', '9E829603A4074140A793286F4665D6BA', '1511659E5F854DC6834D09D638231684', 'EC7A97EBA78F431A8B3926C351BE0053', '6FF11E36840E4F80ABCB07155C1B24F0', '937A3EDA062C4BAA81FC75449CF2C724', 'D421F3F053524361A73E5A54B7F0F23A', '471EC858704749469FEE9DFEA85CF450', '103DBD1BEA0D46B39955FC29352DA922');
Date: 2026-07-17 13:24:45 Duration: 4s194ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('91E2C101F412448DA83F1E79198CED2B', '5CBF80E5459D4A27BC02AFE3E4398A8E', 'A3DAF905FC2445E29A6A7EB8A27E9185', 'FC8D2CDE782D4EA3B4EEF6EE8BE4E3BC', 'D0C7AC150B4F4586988FC3DF75394A9C', 'BC75247419AD4B53BFB8A9BF40DA3FF6', '70E13CDB9A7C425885389A663C8BF4EF', '33F4537F74314A43B05E88E47A6354C3', 'D9F82DD1999D43A3A099731E59EEDEA4', 'C36BDF0BFBC8442F9B44AAC455FE4FB2', '606E0E91A3A94053BE9150EB7108DA3B', 'F15C6A003B004FD0B02DE854C54C3D0F', 'A630DEF9AF3540089FC034C2E157A91C', 'E7F5E311A0CC43C6A92347D5C7725151', 'D213042C418340D59CDEAD1E9C62B6E4', '098D64E68B954B9B82930C08BE53F845', '262EA05477474C1B904386184950D818', 'B51EBA1B9F464E6D91A32E10321ECAEC', 'F4453E89492F4FC4A2AB1A57058A9713', '43CC8B4F50EB43CFA621ABE3BC57B817', '9F7D604558A542A78EEB270788FE005F', '97C8E4E717524C67A87859735DE574BA', '18DC89BC68074050B40B97DD461C0BF1', 'CBDA03DB6B364B4A84EE15CCC00FA5AC', '258AFEC4B19448939692B2C8EAD5F0A0', '50DDF392EC62427995C367714E647E82', 'F984B722058B4D19B99E608ECFE5F0A4', '1B3677AB247D4E7F82683730329BBF6B', '19E1172487064EE7BF31C97E8D1003A0', 'D7B40E022D9B49969250DFB66FEB5170', 'B5CCDC8D0BDB40EA9B06B78A4725F80F', '524627668BA8417FB2A29418143DB5B6', '45E83CDDA5954900BA80A69996226097', '7D347BDD15DF40F98FE17033D0422E89', '0A9A430E4E644086A4B270E2C6744002', '0053A6A9189246909A9E1A0D45E8F224', 'D3A36D3077B845B0941F381745DA6458', '582DCA19118449F3B4BFED3705FEA330', '62BADB749BDA4DA486C67DD95D07FEC5', 'D496702DB1A5421B8F91DC8A235C37F9', 'E8BF2269094D45958DE529D7884166AC', 'F33F66DCE95648098EB66EBD79C4D02F', '1734E5BCA64D40A4AB743D04DAB994F3', '4D2D77165C3E4B94B17251739AB28777', '87CA47C6B57A4DC3A4C8A06A7DB0F6CD', '7BDA9D33681B4FBBBCEA4A64F167FE60', 'B580A322EA0F4510B874B30722808AF6', 'ACF16C5F82A34626B88B67959E9A7324', '8F38335A1E46481EA1E87D8CC31B29D0', '8433BFC049014BBAA1F5D6FCF40807EC');
Date: 2026-07-17 13:24:39 Duration: 3s308ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1 4s126ms 4s126ms 4s126ms 4s126ms select * from m_inout_post0 (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 13 1 4s126ms 4s126ms [ User: tad - Total duration: 4s126ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s126ms - Times executed: 1 ]
-
SELECT * FROM M_InOut_Post0 ('E6A955B984804585947D8A709DD816D6');
Date: 2026-07-17 13:24:52 Duration: 4s126ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1 1s18ms 1s18ms 1s18ms 1s18ms select profile.take_sample ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 13 1 1s18ms 1s18ms [ User: postgres - Total duration: 1s18ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s18ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s18ms Database: etendo User: postgres Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s126ms 4s126ms 4s126ms 1 4s126ms select * from m_inout_post0 (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 1 4s126ms 4s126ms [ User: tad - Total duration: 4s126ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s126ms - Times executed: 1 ]
-
SELECT * FROM M_InOut_Post0 ('E6A955B984804585947D8A709DD816D6');
Date: 2026-07-17 13:24:52 Duration: 4s126ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 3s308ms 4s390ms 3s964ms 3 11s893ms select shipmentin0_.m_inout_id as m_inout_1_495_0_, shipmentin0_.ad_client_id as ad_clien2_495_0_, shipmentin0_.ad_org_id as ad_org_i3_495_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula31_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 13 3 11s893ms 3s964ms [ User: tad - Total duration: 11s893ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 11s893ms - Times executed: 3 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('C41D328865AD42AA93973AE1FEFFD4A1', '1E70A1DA717940A38DA1FB5DFB4636FE', '8E90D5F920CE46438FE16F5C6906E677', '78EC3418B39E488A81515713D44BF7BA', '27F6B640A6234864969D4ABDE265CA65', '3F90E918CEFE495183BAD0A611983C83', 'AFE230B89E264FD9840BA262B9AF1BF2', '4F99909FB256422EA4B2028F888BFA21', 'AA54856D7D804DB59A0B824B6D5DE883', '7A4CE4B564A444B39D20C7E050AA2994', '869BFBB2749249AB9A923B5D8C3D7156', '5D197AEE7D6949C19640C5D062A60B6D', '024038AC0C3541C0AFFF0BFB13923BA7', '4E0AA18D6C97442EA9EB9952366F0564', 'B165433237AF4964A723EA1E16FDCA43', 'B14916D0619C4262A7D575220ECE72A2', '0AB9A733648D4D338B9C2FB4ED97E59A', 'B66FEE2D396A4C3F83DC5E5A0C214208', '1FF369653A514C8D959C116F06370D17', '8AF9C63DB5C44C43852D491616F08C94', 'C0E3121D975B4AEC874CD68DE701A5E2', 'FDD4CE6D154F4E02839512C2F6F07F01', '8629C7933A1C4D00A78B0A4B989B961D', 'BA1F2F6CEBEA4C549AFAA2BF8086FB19', '0AC3EAA466F0406F877E16C3D813B21F', 'E8DC822B5AE9478D87EA935767B30388', '9911C99E1FC9454CB3EE87B333A153BA', '4BA75BB72744404E83F6078319F5DA72', '36269CA4D91A46AAB82C998D280BB603', '44A61EB14D6C4339BA3BBED61344F92E', '84696E48FACB4986B14509BE750265AE', '7CCAB9341DF54FBF8CE7D3EF1457B318', '7DB90C0248DA4E85B62EC6F1EBA62B53', '6B67FE1F3D9444BB803CE6F3AFA5F2C5', '31B8BCF4EF5A4FFC8BBBF776C2C0D5A2', 'D33E647C8328429089B14545E5EEDD34', '388859B575B84205999F5882B071592A', 'A87A20F1346E4CDB963CE9B7CD3EAA48', '96DFEAE166054936A60221D65BFF500B', '1ED75391B9C346A1BF248A87E62251D5', 'AB7501C333CA41BFBDA43348C298CC34', '0698731C984148238289D22601367F8A', '0243AB0D58AA424494F44B935CEC7C67', '430BCDFF756F4C56A389E884D6AD762F', 'C4778A1C01C04C87BB36C8648F744440', 'DAF3A9A457284F4BBBBBB52602D3723E', '9B8488C14AF04B5C9657DA4D63E028A1', '673F7879CB8245DCA44505334539126C', '2653EA509DB24E5596BFA2E0C4F3AEA3', 'A5CF99895A54421A9EFE36610B7AB2B3');
Date: 2026-07-17 13:24:40 Duration: 4s390ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('5BB7062942934BC9A7122DE38B3DA3B2', '1ADA3E552866479F85D05B62CBBA82D3', 'BBC58CBF99A843EBB5577B3B831FEEE6', '2F44F8DC812149DCA6E5521845DA7151', '504BAC8EE28E4F6E8FC783F442D3DAAE', 'DBA45AC582A9463B80AD2E96A1ACE2E9', 'D9B29C19D7494F15AA0D152F43AC5D5B', 'DE8D8920D1674C589AEE7B57D4325D40', '957D012A89354D9BBD40954C5F325FF4', 'CE835EAC08BA4532BEF9A8BE0237A9CC', 'DFFEFB95487B4BFCBADD80F87F6AB31A', '99CC871B07934353AF8E469B8D158D7A', 'C31A59ED716D4C438682DFE59F52775E', '691AC798596D4675817ED5DC89E94A76', '1D96BB0006E74802AF2B924AE75E0A46', '320B7416F4134BE28502FCCCD26E4473', 'AEF1BB94290B43888E467D257BBAAAD3', 'ECD609736B5D4F32B9690DE2EC0D3231', 'C993769DD0484ECDB0A9F4D451896CF3', 'CA91A9AC257D4FD7AE16806F80F934C6', '9B0D4011C64540D3B0EC080665377676', '65CF1BCDFB3B42F9BBFA23DDC35A9F84', 'D14CCA440F37410FB8A3E09B444EE567', '9C1E8ABF6D204E5DA55B68F3771CDF22', '28F290CDD1CB4AB99C1BA584BB22116E', 'C64269760EEF46BF82FABF54E7C3703A', 'E42A71BC46B94BBDA0196CE08A83C147', '34479D695E884F95A5D13EF6A67F147D', '43C746714E8644199CB87105F7F4AB8D', 'C8AAAC29D75C4634AC830FDD4DC98548', '24A45FE2E28A45C09D785B150558F63C', '5A75BB86F87147F2B843B0053081E245', '44CC3400120B4D529EDC0F639D34CBFF', '76011A0633134811B5C60C3A17B27C1C', '844DD980C7304AB98653C2B1F703421F', '5D3D680B78A840FE8951DC01B4484A1C', '7E4AFCC9BB8C4449B4188B1D20AD41B1', '12E42E6FC9DD47CABC90BACCEA8D2932', '8046C871CC2E4D589531B00393781114', '005B574993A34D4DAAADBA8C16B319B3', 'A0A4C89378E74A96A8D2E171C73800AA', '94663AEC882C458DBFA744A249B861B3', '9E829603A4074140A793286F4665D6BA', '1511659E5F854DC6834D09D638231684', 'EC7A97EBA78F431A8B3926C351BE0053', '6FF11E36840E4F80ABCB07155C1B24F0', '937A3EDA062C4BAA81FC75449CF2C724', 'D421F3F053524361A73E5A54B7F0F23A', '471EC858704749469FEE9DFEA85CF450', '103DBD1BEA0D46B39955FC29352DA922');
Date: 2026-07-17 13:24:45 Duration: 4s194ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_495_0_, shipmentin0_.AD_Client_ID as ad_clien2_495_0_, shipmentin0_.AD_Org_ID as ad_org_i3_495_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula31_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('91E2C101F412448DA83F1E79198CED2B', '5CBF80E5459D4A27BC02AFE3E4398A8E', 'A3DAF905FC2445E29A6A7EB8A27E9185', 'FC8D2CDE782D4EA3B4EEF6EE8BE4E3BC', 'D0C7AC150B4F4586988FC3DF75394A9C', 'BC75247419AD4B53BFB8A9BF40DA3FF6', '70E13CDB9A7C425885389A663C8BF4EF', '33F4537F74314A43B05E88E47A6354C3', 'D9F82DD1999D43A3A099731E59EEDEA4', 'C36BDF0BFBC8442F9B44AAC455FE4FB2', '606E0E91A3A94053BE9150EB7108DA3B', 'F15C6A003B004FD0B02DE854C54C3D0F', 'A630DEF9AF3540089FC034C2E157A91C', 'E7F5E311A0CC43C6A92347D5C7725151', 'D213042C418340D59CDEAD1E9C62B6E4', '098D64E68B954B9B82930C08BE53F845', '262EA05477474C1B904386184950D818', 'B51EBA1B9F464E6D91A32E10321ECAEC', 'F4453E89492F4FC4A2AB1A57058A9713', '43CC8B4F50EB43CFA621ABE3BC57B817', '9F7D604558A542A78EEB270788FE005F', '97C8E4E717524C67A87859735DE574BA', '18DC89BC68074050B40B97DD461C0BF1', 'CBDA03DB6B364B4A84EE15CCC00FA5AC', '258AFEC4B19448939692B2C8EAD5F0A0', '50DDF392EC62427995C367714E647E82', 'F984B722058B4D19B99E608ECFE5F0A4', '1B3677AB247D4E7F82683730329BBF6B', '19E1172487064EE7BF31C97E8D1003A0', 'D7B40E022D9B49969250DFB66FEB5170', 'B5CCDC8D0BDB40EA9B06B78A4725F80F', '524627668BA8417FB2A29418143DB5B6', '45E83CDDA5954900BA80A69996226097', '7D347BDD15DF40F98FE17033D0422E89', '0A9A430E4E644086A4B270E2C6744002', '0053A6A9189246909A9E1A0D45E8F224', 'D3A36D3077B845B0941F381745DA6458', '582DCA19118449F3B4BFED3705FEA330', '62BADB749BDA4DA486C67DD95D07FEC5', 'D496702DB1A5421B8F91DC8A235C37F9', 'E8BF2269094D45958DE529D7884166AC', 'F33F66DCE95648098EB66EBD79C4D02F', '1734E5BCA64D40A4AB743D04DAB994F3', '4D2D77165C3E4B94B17251739AB28777', '87CA47C6B57A4DC3A4C8A06A7DB0F6CD', '7BDA9D33681B4FBBBCEA4A64F167FE60', 'B580A322EA0F4510B874B30722808AF6', 'ACF16C5F82A34626B88B67959E9A7324', '8F38335A1E46481EA1E87D8CC31B29D0', '8433BFC049014BBAA1F5D6FCF40807EC');
Date: 2026-07-17 13:24:39 Duration: 3s308ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s18ms 1s18ms 1s18ms 1 1s18ms select profile.take_sample ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 13 1 1s18ms 1s18ms [ User: postgres - Total duration: 1s18ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s18ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s18ms Database: etendo User: postgres Remote: [local] Application: psql
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
- 22,169 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