pgBadger-
Global information
- Generated on Fri Jul 17 23:00:08 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 53,898 log entries in 7s
- Log start from 2026-07-17 07:00:01 to 2026-07-17 22:00:00
-
Overview
Global Stats
- 1 Number of unique normalized queries
- 1 Number of queries
- 1s136ms Total query duration
- 2026-07-17 13:00:02 First query
- 2026-07-17 13:00:02 Last query
- 1 queries/s at 2026-07-17 13:00:02 Query peak
- 1s136ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1s136ms Execute total duration
- 1,133 Number of events
- 10 Number of unique normalized events
- 1,078 Max number of times the same event was reported
- 0 Number of cancellation
- 159 Total number of automatic vacuums
- 217 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 5,758 Total number of sessions
- 32 sessions at 2026-07-17 19:00:01 Session peak
- 3d5h9m25s Total duration of sessions
- 48s239ms Average duration of sessions
- 0 Average queries per session
- 0ms Average queries duration per session
- 48s239ms Average idle time per session
- 5,756 Total number of connections
- 10 connections/s at 2026-07-17 19:00:00 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
- 1s136ms 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 1 0ms 1s136ms 1s136ms 0ms 0ms 1s136ms 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 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 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 1 0 1s136ms 0ms 0ms 0ms 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 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 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 22 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 0 0.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% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 17 07 375 0.10/s 08 383 0.11/s 09 382 0.11/s 10 387 0.11/s 11 385 0.11/s 12 386 0.11/s 13 382 0.11/s 14 383 0.11/s 15 383 0.11/s 16 383 0.11/s 17 383 0.11/s 18 383 0.11/s 19 385 0.11/s 20 383 0.11/s 21 383 0.11/s 22 10 0.00/s Day Hour Count Average Duration Average idle time Jul 17 07 387 48s850ms 48s850ms 08 383 49s424ms 49s424ms 09 381 44s115ms 44s115ms 10 388 59s723ms 59s723ms 11 385 44s22ms 44s22ms 12 386 57s553ms 57s553ms 13 382 48s808ms 48s805ms 14 383 35s999ms 35s999ms 15 383 1m 1m 16 383 49s60ms 49s60ms 17 383 36s998ms 36s998ms 18 383 46s397ms 46s397ms 19 385 48s962ms 48s962ms 20 383 43s578ms 43s578ms 21 383 49s63ms 49s63ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2026-07-17 19:00:00 Date
Connections per database
Key values
- etendo Main Database
- 5,756 connections Total
Connections per user
Key values
- tad Main User
- 5,756 connections Total
-
Sessions
Simultaneous sessions
Key values
- 32 sessions Session Peak
- 2026-07-17 19:00:01 Date
Histogram of session times
Key values
- 5,399 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,758 sessions Total
Sessions per user
Key values
- tad Main User
- 5,758 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,758 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6,348 buffers Checkpoint Peak
- 2026-07-17 13:19:40 Date
- 270.088 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-07-17 14:19:40 Date
Checkpoints distance
Key values
- 94.53 Mo Distance Peak
- 2026-07-17 13:19:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 17 07 19,329 1,273.426s 0.012s 1,273.458s 08 18,499 1,279.163s 0.012s 1,279.194s 09 20,027 1,317.121s 0.013s 1,317.152s 10 21,255 1,451.352s 0.015s 1,451.385s 11 21,469 1,420.512s 0.016s 1,420.543s 12 22,326 1,423.881s 0.012s 1,423.914s 13 22,611 1,478.456s 0.014s 1,478.488s 14 20,447 1,340.886s 0.014s 1,340.914s 15 19,910 1,301.278s 0.012s 1,301.305s 16 19,420 1,304.311s 0.012s 1,304.338s 17 19,440 1,286.178s 0.013s 1,286.208s 18 19,646 1,306.322s 0.012s 1,306.35s 19 19,708 1,308.575s 0.012s 1,308.604s 20 19,723 1,324.048s 0.012s 1,324.081s 21 19,430 1,291.723s 0.012s 1,291.754s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 17 07 0 0 12 587 0.001s 0.012s 08 0 0 11 575 0.001s 0.012s 09 0 0 12 661 0.001s 0.012s 10 0 0 13 1,580 0.001s 0.012s 11 0 0 12 997 0.001s 0.012s 12 0 0 13 948 0.001s 0.012s 13 0 0 13 1,053 0.001s 0.012s 14 0 0 12 752 0.001s 0.012s 15 0 0 11 475 0.001s 0.012s 16 0 0 12 477 0.001s 0.012s 17 0 0 12 438 0.002s 0.012s 18 0 0 11 437 0.001s 0.012s 19 0 0 12 439 0.001s 0.012s 20 0 0 11 449 0.001s 0.012s 21 0 0 12 435 0.001s 0.012s 22 0 0 0 0 0s 0s 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 22 0 0s Day Hour Mean distance Mean estimate Jul 17 07 15,914.17 kB 37,851.25 kB 08 15,944.17 kB 37,794.75 kB 09 16,146.08 kB 37,692.17 kB 10 17,718.83 kB 39,412.42 kB 11 16,627.17 kB 38,382.42 kB 12 16,705.33 kB 37,838.92 kB 13 17,811.92 kB 40,279.42 kB 14 16,338.92 kB 38,205.08 kB 15 15,924.92 kB 37,810.58 kB 16 15,864.50 kB 37,598.00 kB 17 15,817.42 kB 37,682.50 kB 18 15,824.25 kB 37,610.50 kB 19 15,787.50 kB 37,588.67 kB 20 15,875.75 kB 37,650.83 kB 21 15,790.92 kB 37,657.17 kB 22 0.00 kB 0.00 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 22 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.36 sec Highest CPU-cost vacuum
Table public.opxap_detalle_costes
Database etendo - 2026-07-17 09:47:31 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.36 sec Highest CPU-cost vacuum
Table public.opxap_detalle_costes
Database etendo - 2026-07-17 09:47:31 Date
Analyzes per table
Key values
- public.opxap_detalle_costes (30) Main table analyzed (database etendo)
- 217 analyzes Total
Table Number of analyzes etendo.public.opxap_detalle_costes 30 etendo.public.prscrm_account 25 etendo.profile.last_stat_user_functions_srv1 15 etendo.public.ad_process_request 15 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_io 8 etendo.profile.tables_list 7 etendo.public.prscrm_contact 7 etendo.public.ad_ep_instance_para 6 etendo.profile.last_extension_versions 5 etendo.public.ad_preference 5 etendo.public.ad_session 4 etendo.pg_catalog.pg_type 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.prscrm_conf 4 etendo.profile.stmt_list 4 etendo.profile.funcs_list 4 etendo.profile.indexes_list 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_tables 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_user_functions 2 etendo.pg_catalog.pg_attribute 2 template1.pg_catalog.pg_shdepend 1 etendo.profile.sample_stat_tables_total 1 etendo.pg_catalog.pg_class 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_slru 1 postgres.pg_catalog.pg_shdepend 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_database 1 Total 217 Vacuums per table
Key values
- public.prscrm_account (33) Main table vacuumed on database etendo
- 159 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.public.prscrm_account 33 15 25,417 0 21 0 0 11,476 1,401 1,776,731 353 382 etendo.public.opxap_detalle_costes 30 30 220,683 0 9,051 0 0 172,013 18,313 19,322,164 784 8,328 etendo.profile.last_stat_tables_srv1 15 15 15,095 0 193 0 0 11,673 3,516 3,322,629 320 1,484 etendo.profile.last_stat_indexes_srv1 15 15 19,226 0 918 0 0 14,402 4,456 4,201,770 135 1,185 etendo.profile.last_stat_user_functions_srv1 15 15 3,054 0 66 0 0 2,513 725 3,133,826 572 8,598 etendo.profile.last_stat_statements_srv1 15 15 10,008 0 158 0 0 8,708 2,441 9,241,899 1,671 16,089 etendo.profile.tables_list 4 4 990 0 24 0 0 836 266 1,748,216 177 1,577 etendo.profile.last_stat_io 4 4 245 0 14 0 0 30 18 73,929 2 29 etendo.public.ad_ep_instance_para 4 4 241 0 19 0 0 25 7 58,354 0 0 etendo.profile.indexes_list 3 3 398 0 17 0 0 145 57 355,975 28 281 etendo.profile.funcs_list 3 3 315 0 14 0 0 101 38 243,578 21 277 etendo.profile.last_extension_versions 3 3 154 0 14 0 0 18 11 46,620 3 27 etendo.pg_toast.pg_toast_2619 3 3 2,196 0 451 0 0 1,346 413 819,741 65 145 etendo.public.prscrm_contact 2 2 2,394 0 937 0 0 1,485 386 895,377 56 86 etendo.profile.stmt_list 2 2 524 0 22 0 0 379 123 788,719 68 249 etendo.profile.last_stat_activity_count_srv1 2 0 44 0 10 0 0 12 6 22,730 0 0 etendo.pg_catalog.pg_type 1 1 124 0 14 0 0 33 11 45,504 3 6 etendo.profile.last_stat_slru 1 1 51 0 5 0 0 6 4 17,509 1 5 etendo.pg_toast.pg_toast_88053 1 1 339 0 145 0 0 148 7 48,841 2 5 etendo.pg_toast.pg_toast_88656 1 1 42 0 4 0 0 4 2 16,240 0 0 etendo.profile.sample_stat_tables_total 1 1 171 0 48 0 0 53 9 55,800 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 6 0 0 7 5 25,710 1 4 Total 159 139 301,761 9 12,151 0 0 225,413 32,215 46,261,862 4,262 38,757 Vacuum throughput per table
Key values
- public.opxap_detalle_costes (4.47) 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.public.prscrm_account 0 0 0.09 etendo.public.opxap_detalle_costes 0 0 4.47 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.last_stat_indexes_srv1 0 0 0.4 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 0.07 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.public.ad_ep_instance_para 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.1 etendo.public.prscrm_contact 0 0 0.21 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.pg_catalog.pg_type 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.pg_toast.pg_toast_88053 0 0 0.03 etendo.pg_toast.pg_toast_88656 0 0 0 etendo.profile.sample_stat_tables_total 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 Total 0 0 5.52 Tuples removed per table
Key values
- public.opxap_detalle_costes (790202) Main table with removed tuples on database etendo
- 985145 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.opxap_detalle_costes 30 30 790,202 790,200 0 10,657 64,809 etendo.profile.last_stat_indexes_srv1 15 15 89,181 44,145 0 121 5,334 etendo.profile.last_stat_tables_srv1 15 15 57,548 27,203 0 283 4,133 etendo.profile.last_stat_statements_srv1 15 15 21,490 18,613 0 211 2,055 etendo.public.prscrm_account 33 15 14,109 40,823 16,810 120 13,763 etendo.profile.last_stat_user_functions_srv1 15 15 9,467 8,670 0 2 578 etendo.pg_toast.pg_toast_2619 3 3 1,161 5,459 0 0 2,244 etendo.profile.tables_list 4 4 748 7,950 0 0 212 etendo.public.prscrm_contact 2 2 234 4,673 0 0 1,556 etendo.profile.last_extension_versions 3 3 162 27 0 0 3 etendo.profile.stmt_list 2 2 158 1,351 0 0 132 etendo.profile.funcs_list 3 3 139 588 0 0 24 etendo.profile.indexes_list 3 3 130 1,205 0 0 33 etendo.profile.last_stat_io 4 4 106 60 0 0 8 etendo.pg_catalog.pg_type 1 1 102 2,479 0 0 70 etendo.profile.sample_stat_tables_total 1 1 57 1,521 0 0 42 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.public.ad_ep_instance_para 4 4 40 30 30 3 1 etendo.pg_toast.pg_toast_88053 1 1 4 595 0 0 138 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 etendo.pg_toast.pg_toast_88656 1 1 0 3 2 0 1 Total 159 139 985,145 955,604 16,842 11,399 95,138 Pages removed per table
Key values
- public.opxap_detalle_costes (10657) Main table with removed pages on database etendo
- 11399 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.opxap_detalle_costes 30 30 790202 10657 etendo.profile.last_stat_tables_srv1 15 15 57548 283 etendo.profile.last_stat_statements_srv1 15 15 21490 211 etendo.profile.last_stat_indexes_srv1 15 15 89181 121 etendo.public.prscrm_account 33 15 14109 120 etendo.public.ad_ep_instance_para 4 4 40 3 etendo.profile.last_stat_user_functions_srv1 15 15 9467 2 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.tables_list 4 4 748 0 etendo.profile.last_stat_io 4 4 106 0 etendo.public.prscrm_contact 2 2 234 0 etendo.pg_catalog.pg_type 1 1 102 0 etendo.profile.indexes_list 3 3 130 0 etendo.profile.stmt_list 2 2 158 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.pg_toast.pg_toast_88053 1 1 4 0 etendo.profile.funcs_list 3 3 139 0 etendo.pg_toast.pg_toast_88656 1 1 0 0 etendo.profile.last_extension_versions 3 3 162 0 etendo.profile.sample_stat_tables_total 1 1 57 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.pg_toast.pg_toast_2619 3 3 1161 0 Total 159 139 985,145 11,399 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 17 07 11 12 08 9 11 09 12 14 10 10 18 11 12 15 12 13 21 13 11 16 14 11 14 15 13 17 16 11 12 17 9 11 18 10 13 19 9 13 20 9 14 21 9 16 22 0 0 - 0.36 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
- 1 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 1 Requests
- 1s136ms (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 1 Requests
User Request type Count Duration postgres Total 1 1s136ms select 1 1s136ms Duration by user
Key values
- 1s136ms (postgres) Main time consuming user
User Request type Count Duration postgres Total 1 1s136ms select 1 1s136ms Queries by host
Key values
- [local] Main host
- 1 Requests
- 1s136ms ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 1 Requests
- 1s136ms (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-17 21:30:00 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s136ms 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 1s136ms 1 1s136ms 1s136ms 1s136ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 1 1s136ms 1s136ms [ User: postgres - Total duration: 1s136ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s136ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s136ms 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 1 1s136ms 1s136ms 1s136ms 1s136ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 1 1s136ms 1s136ms [ User: postgres - Total duration: 1s136ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s136ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s136ms 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 1s136ms 1s136ms 1s136ms 1 1s136ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 13 1 1s136ms 1s136ms [ User: postgres - Total duration: 1s136ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s136ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:02 Duration: 1s136ms 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
- 26,154 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1106 FATAL entries
- 24 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,078 Max number of times the same event was reported
- 1,133 Total events found
Rank Times reported Error 1 1,078 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 17 07 76 08 80 09 72 10 70 11 71 12 70 13 70 14 68 15 74 16 72 17 68 18 74 19 74 20 68 21 71 - FATAL: no pg_hba.conf entry for host "159.65.148.75", user "administrator", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "administrator", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "186.236.254.56", user "app", database "postgres", no encryption
Date: 2026-07-17 07:00:47 Database: postgres Application: [unknown] User: administrator Remote: 159.65.148.75
Date: 2026-07-17 07:00:47 Database: postgres Application: [unknown] User: administrator Remote: 159.65.148.75
Date: 2026-07-17 07:02:20 Database: postgres Application: [unknown] User: app Remote: 186.236.254.56
2 17 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 17 11 1 16 14 18 2 - FATAL: no pg_hba.conf entry for host "35.205.47.236", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
Date: 2026-07-17 11:01:03 Database: postgres Application: [unknown] User: postgres Remote: 35.205.47.236
Date: 2026-07-17 16:13:17 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
Date: 2026-07-17 16:14:58 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
3 15 ERROR: Email en uso... no pongas nada o usa otro email. -> Email: gemabalbas@acquabysalud.com
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 17 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 - ERROR: Email en uso... no pongas nada o usa otro email. -> Email: gemabalbas@acquabysalud.com
- ERROR: Email en uso... no pongas nada o usa otro email. -> Email: gemabalbas@acquabysalud.com
- ERROR: Email en uso... no pongas nada o usa otro email. -> Email: gemabalbas@acquabysalud.com
Context: PL/pgSQL function opxepr_usermail_trg() line 16 at RAISE
Statement: insert into AD_User (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Name, Email, C_BPartner_ID, Processing, Phone, Phone2, Fax, IsLocked, Grant_Portal_Access, Isexpiredpassword, Commercialauth, Viasms, Viaemail, EM_Prscrm_Accountuser, EM_Pruti_Isbillingcontact, EM_Pruti_Isordercontact, EM_Pruti_Ispurchaseordcontact, EM_Prscrm_Createdbyprocess, Isdefaultfordocs, EM_Etas_bad_Password_Attempts, EM_Etas_Enable_Mult_Session, EM_Opxepr_Process_Selection, EM_Etas_Issecure_Pw, EM_Etas_Isused_Pw, EM_Etas_Isnewuser, EM_Pruti_Isshipmentcontact, AD_User_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34)Date: 2026-07-17 07:45:03 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function opxepr_usermail_trg() line 16 at RAISE
Statement: insert into AD_User (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Name, Email, C_BPartner_ID, Processing, Phone, Phone2, Fax, IsLocked, Grant_Portal_Access, Isexpiredpassword, Commercialauth, Viasms, Viaemail, EM_Prscrm_Accountuser, EM_Pruti_Isbillingcontact, EM_Pruti_Isordercontact, EM_Pruti_Ispurchaseordcontact, EM_Prscrm_Createdbyprocess, Isdefaultfordocs, EM_Etas_bad_Password_Attempts, EM_Etas_Enable_Mult_Session, EM_Opxepr_Process_Selection, EM_Etas_Issecure_Pw, EM_Etas_Isused_Pw, EM_Etas_Isnewuser, EM_Pruti_Isshipmentcontact, AD_User_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34)Date: 2026-07-17 08:45:02 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function opxepr_usermail_trg() line 16 at RAISE
Statement: insert into AD_User (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Name, Email, C_BPartner_ID, Processing, Phone, Phone2, Fax, IsLocked, Grant_Portal_Access, Isexpiredpassword, Commercialauth, Viasms, Viaemail, EM_Prscrm_Accountuser, EM_Pruti_Isbillingcontact, EM_Pruti_Isordercontact, EM_Pruti_Ispurchaseordcontact, EM_Prscrm_Createdbyprocess, Isdefaultfordocs, EM_Etas_bad_Password_Attempts, EM_Etas_Enable_Mult_Session, EM_Opxepr_Process_Selection, EM_Etas_Issecure_Pw, EM_Etas_Isused_Pw, EM_Etas_Isnewuser, EM_Pruti_Isshipmentcontact, AD_User_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34)Date: 2026-07-17 09:45:02 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
4 8 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 17 09 8 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
Date: 2026-07-17 09:28:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: SELECT coalesce(E_TRL.NAME, E.NAME) AS NAME FROM AD_ELEMENT E left join AD_ELEMENT_TRL E_TRL on E.AD_ELEMENT_ID = E_TRL.AD_ELEMENT_ID and E_TRL.AD_LANGUAGE = $1 where E.COLUMNNAME=$2
Date: 2026-07-17 09:28:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
Date: 2026-07-17 09:28:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
5 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 17 08 1 15 1 18 1 21 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-17 08:54:18 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-17 15:59:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-17 18:02:46 Database: [unknown] Application: [unknown] User: [unknown] Remote: 87.236.176.165
6 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 17 13 3 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-17 13:41:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 104.130.6.74
Date: 2026-07-17 13:41:33 Database: [unknown] Application: [unknown] User: [unknown] Remote: 104.130.6.74
Date: 2026-07-17 13:42:11 Database: [unknown] Application: [unknown] User: [unknown] Remote: 104.130.6.74
7 3 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 17 08 1 15 1 21 1 - FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Date: 2026-07-17 08:54:17 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-17 15:59:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-17 21:57:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.130.168.2
8 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 17 08 1 15 1 21 1 - FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Date: 2026-07-17 08:54:17 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-17 15:59:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-17 21:57:34 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.130.168.2
9 1 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 17 09 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x00
Context: portal "C_2326" parameter $1
Statement: select this_.AD_Org_ID as ad_org_i1_71_0_, this_.AD_Client_ID as ad_clien2_71_0_, this_.IsActive as isactive3_71_0_, this_.Created as created4_71_0_, this_.CreatedBy as createdb5_71_0_, this_.Updated as updated6_71_0_, this_.UpdatedBy as updatedb7_71_0_, this_.Value as value8_71_0_, this_.Name as name9_71_0_, this_.Description as descrip10_71_0_, this_.IsSummary as issumma11_71_0_, this_.AD_Orgtype_ID as ad_orgt12_71_0_, this_.IsPeriodControlAllowed as isperio13_71_0_, this_.C_Calendar_ID as c_calen14_71_0_, this_.IsReady as isready15_71_0_, this_.EM_Intr_C_Calendar_ID as em_intr16_71_0_, this_.Social_Name as social_17_71_0_, this_.C_Currency_ID as c_curre18_71_0_, this_.C_Acctschema_ID as c_accts19_71_0_, this_.EM_APRM_Glitem_ID as em_aprm20_71_0_, this_.EM_OBMFM_Product_ID as em_obmf21_71_0_, this_.AD_Periodcontrolallowed_Org_ID as ad_peri22_71_0_, this_.AD_Calendarowner_Org_ID as ad_cale23_71_0_, this_.AD_Legalentity_Org_ID as ad_lega24_71_0_, this_.AD_Inheritedcalendar_ID as ad_inhe25_71_0_, this_.AD_Businessunit_Org_ID as ad_busi26_71_0_, this_.EM_Etsg_Add_Certificate as em_etsg27_71_0_, this_.EM_Pruti_Planningmethod_ID as em_prut28_71_0_, this_.EM_Prapi_Glitem_ID as em_prap29_71_0_, this_.EM_Prapi_Paymentmethod_ID as em_prap30_71_0_, this_.EM_Prapi_Paymentterm_ID as em_prap31_71_0_, this_.EM_Pruti_M_Locator as em_prut32_71_0_ from AD_Org this_ where this_.Value=$1 and this_.AD_Client_ID=$2 and this_.AD_Client_ID in ($3, $4) and this_.IsActive=$5Date: 2026-07-17 09:28:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
10 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 17 14 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Date: 2026-07-17 14:22:05 Database: [unknown] Application: [unknown] User: [unknown] Remote: 121.199.173.72