pgBadger-
Global information
- Generated on Mon Jul 13 23:00:07 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 63,731 log entries in 6s
- Log start from 2026-07-13 07:00:01 to 2026-07-13 22:00:00
-
Overview
Global Stats
- 1 Number of unique normalized queries
- 2 Number of queries
- 2s151ms Total query duration
- 2026-07-13 09:00:02 First query
- 2026-07-13 14:00:02 Last query
- 1 queries/s at 2026-07-13 14:00:02 Query peak
- 2s151ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2s151ms Execute total duration
- 920 Number of events
- 14 Number of unique normalized events
- 876 Max number of times the same event was reported
- 0 Number of cancellation
- 10,591 Total number of automatic vacuums
- 237 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 5,730 Total number of sessions
- 33 sessions at 2026-07-13 19:00:01 Session peak
- 3d59m46s Total duration of sessions
- 45s861ms Average duration of sessions
- 0 Average queries per session
- 0ms Average queries duration per session
- 45s861ms Average idle time per session
- 5,733 Total number of connections
- 10 connections/s at 2026-07-13 14:00:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 14:00:02 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 14:00:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 2s151ms 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 13 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 1 0ms 1s72ms 1s72ms 0ms 0ms 1s72ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 14 1 0ms 1s78ms 1s78ms 0ms 0ms 1s78ms 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 13 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 1 0 1s72ms 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 0 0 0ms 0ms 0ms 0ms 14 1 0 1s78ms 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 13 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 13 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 13 07 379 0.11/s 08 386 0.11/s 09 381 0.11/s 10 384 0.11/s 11 388 0.11/s 12 388 0.11/s 13 382 0.11/s 14 394 0.11/s 15 377 0.10/s 16 377 0.10/s 17 378 0.10/s 18 380 0.11/s 19 379 0.11/s 20 376 0.10/s 21 376 0.10/s 22 8 0.00/s Day Hour Count Average Duration Average idle time Jul 13 07 391 35s951ms 35s951ms 08 385 46s703ms 46s703ms 09 381 59s399ms 59s396ms 10 385 47s422ms 47s422ms 11 386 49s332ms 49s332ms 12 387 40s637ms 40s637ms 13 383 47s411ms 47s411ms 14 388 51s991ms 51s988ms 15 378 35s51ms 35s51ms 16 377 20s216ms 20s216ms 17 378 1m7s 1m7s 18 380 51s497ms 51s497ms 19 379 46s565ms 46s565ms 20 376 44s37ms 44s37ms 21 376 44s357ms 44s357ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2026-07-13 14:00:00 Date
Connections per database
Key values
- etendo Main Database
- 5,733 connections Total
Connections per user
Key values
- tad Main User
- 5,733 connections Total
-
Sessions
Simultaneous sessions
Key values
- 33 sessions Session Peak
- 2026-07-13 19:00:01 Date
Histogram of session times
Key values
- 5,397 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,730 sessions Total
Sessions per user
Key values
- tad Main User
- 5,730 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,730 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,199 buffers Checkpoint Peak
- 2026-07-13 21:49:52 Date
- 270.012 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-07-13 20:54:52 Date
Checkpoints distance
Key values
- 152.02 Mo Distance Peak
- 2026-07-13 21:54:52 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 13 07 18,533 1,295.654s 0.013s 1,295.684s 08 18,793 1,291.413s 0.012s 1,291.442s 09 21,183 1,428.462s 0.017s 1,428.501s 10 20,869 1,445.743s 0.015s 1,445.774s 11 23,382 1,544.357s 0.014s 1,544.392s 12 22,993 1,535.777s 0.021s 1,535.816s 13 25,488 1,451.963s 0.016s 1,451.996s 14 27,628 1,552.762s 0.024s 1,552.803s 15 27,539 1,441.356s 0.014s 1,441.388s 16 27,409 1,303.772s 0.012s 1,303.8s 17 28,079 1,294.353s 0.013s 1,294.381s 18 28,928 1,276.471s 0.013s 1,276.5s 19 30,452 1,290.213s 0.014s 1,290.245s 20 32,276 1,273.529s 0.015s 1,273.559s 21 33,858 1,301.086s 0.014s 1,301.117s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 13 07 0 0 12 855 0.001s 0.012s 08 0 0 12 851 0.001s 0.012s 09 0 0 12 1,437 0.001s 0.012s 10 0 0 13 1,707 0.001s 0.012s 11 0 0 13 1,471 0.001s 0.012s 12 0 0 13 1,230 0.001s 0.012s 13 0 0 15 1,450 0.001s 0.012s 14 0 0 15 1,992 0.001s 0.012s 15 0 0 15 877 0.001s 0.012s 16 0 0 15 489 0.001s 0.012s 17 0 0 16 535 0.001s 0.012s 18 0 0 16 465 0.001s 0.012s 19 0 0 17 446 0.001s 0.012s 20 0 0 17 450 0.003s 0.012s 21 0 0 18 450 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 13 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 13 07 16,286.33 kB 37,813.00 kB 08 16,416.83 kB 38,595.83 kB 09 17,060.50 kB 38,348.33 kB 10 17,610.67 kB 39,208.50 kB 11 17,718.08 kB 40,642.00 kB 12 18,087.42 kB 40,344.75 kB 13 19,297.67 kB 43,910.00 kB 14 21,204.42 kB 48,763.92 kB 15 20,543.17 kB 48,965.92 kB 16 20,517.42 kB 50,309.00 kB 17 21,309.58 kB 52,539.83 kB 18 22,113.17 kB 54,738.50 kB 19 22,919.17 kB 57,154.08 kB 20 23,513.50 kB 60,381.25 kB 21 24,068.50 kB 61,945.75 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 13 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.84 sec Highest CPU-cost vacuum
Table public.opxap_detalle_costes
Database etendo - 2026-07-13 21:47:48 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.84 sec Highest CPU-cost vacuum
Table public.opxap_detalle_costes
Database etendo - 2026-07-13 21:47:48 Date
Analyzes per table
Key values
- public.opxap_detalle_costes (30) Main table analyzed (database etendo)
- 237 analyzes Total
Table Number of analyzes etendo.public.opxap_detalle_costes 30 etendo.public.prscrm_account 23 etendo.public.ad_process_request 18 etendo.public.ad_ep_instance_para 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.public.prscrm_contact 11 etendo.profile.last_stat_io 8 etendo.profile.tables_list 7 etendo.profile.funcs_list 5 etendo.public.ad_session 5 etendo.profile.last_extension_versions 5 etendo.profile.indexes_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.stmt_list 4 etendo.public.prscrm_conf 4 etendo.profile.last_stat_slru 3 etendo.pg_catalog.pg_type 3 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_tables 2 etendo.pg_catalog.pg_attribute 2 etendo.public.ad_preference 2 etendo.profile.sample_stat_indexes 2 etendo.public.fin_bankstatementline 2 etendo.profile.sample_statements 2 etendo.public.fin_reconciliation 2 etendo.profile.sample_statements_total 1 etendo.public.ad_sequence 1 etendo.public.fin_financial_account 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_tables_total 1 etendo.public.ad_pinstance 1 template1.pg_catalog.pg_shdepend 1 etendo.profile.sample_stat_slru 1 etendo.pg_catalog.pg_class 1 postgres.pg_catalog.pg_shdepend 1 etendo.profile.sample_stat_database 1 Total 237 Vacuums per table
Key values
- public.prscrm_account (623) Main table vacuumed on database etendo
- 10,591 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 623 4 1,540,679 0 55 0 0 3,206 530 1,003,602 113 128 etendo.public.opxap_detalle_costes 623 9 18,268,076 0 15,451 0 0 51,410 5,374 5,886,046 126 1,167 etendo.profile.last_stat_indexes_srv1 605 5 1,776,059 0 154 0 0 4,878 1,538 1,844,483 48 479 etendo.profile.last_stat_tables_srv1 605 5 1,450,726 0 69 0 0 3,963 1,172 1,129,535 95 558 etendo.profile.last_stat_user_functions_srv1 605 5 176,637 0 58 0 0 902 285 1,369,629 183 2,787 etendo.profile.last_stat_statements_srv1 605 5 913,766 0 99 0 0 3,438 987 4,230,846 632 6,802 etendo.public.fin_bankstatementline 599 1 145,264 0 88 0 0 147 10 97,850 0 0 etendo.public.ad_process_request 566 1 125,503 0 526 0 0 172 92 721,569 3 7 etendo.public.ad_ep_instance_para 548 12 19,046 0 79 0 0 123 61 465,496 0 0 etendo.profile.funcs_list 482 2 34,202 0 54 0 0 93 56 417,069 6 77 etendo.public.ad_session 460 1 132,925 0 324 0 0 315 62 513,355 1 2 etendo.public.fin_reconciliation 455 1 37,278 0 46 0 0 52 40 325,418 0 0 etendo.profile.tables_list 423 3 77,712 0 55 0 0 476 216 1,555,664 78 697 etendo.profile.stmt_list 422 2 82,341 0 85 0 0 287 146 1,041,561 22 79 etendo.profile.last_stat_io 422 2 18,094 0 54 0 0 46 37 257,086 2 29 etendo.profile.indexes_list 422 2 40,525 0 52 0 0 102 67 443,135 11 138 etendo.pg_catalog.pg_statistic 421 1 681,362 0 854 0 0 592 328 1,919,867 19 130 etendo.public.prscrm_contact 421 1 259,768 0 1,293 0 0 1,202 212 754,276 16 20 etendo.pg_toast.pg_toast_2619 374 2 260,446 0 457 0 0 823 271 851,251 55 111 etendo.public.prscrm_conf 361 1 24,437 0 74 0 0 71 40 199,848 0 0 etendo.profile.last_extension_versions 302 2 18,009 0 39 0 0 32 26 187,894 1 9 etendo.profile.last_stat_activity_count_srv1 242 0 3,565 0 35 0 0 24 20 74,039 0 0 etendo.pg_catalog.pg_type 1 1 113 0 22 0 0 14 5 28,818 0 0 etendo.pg_toast.pg_toast_81522 1 1 229 0 89 0 0 112 16 87,609 7 18 etendo.profile.last_stat_database_srv1 1 1 50 0 5 0 0 4 4 22,698 0 0 etendo.profile.last_stat_slru 1 1 54 0 5 0 0 5 4 18,773 0 0 etendo.pg_toast.pg_toast_88656 1 1 51 0 7 0 0 4 3 24,029 0 0 Total 10,591 72 26,086,917 40 20,129 0 0 72,493 11,602 25,471,446 1,418 13,238 Vacuum throughput per table
Key values
- public.opxap_detalle_costes (214.46) 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 13.9999999999999 etendo.public.opxap_detalle_costes 0 0 214.46 etendo.profile.last_stat_indexes_srv1 0 0 17.06 etendo.profile.last_stat_tables_srv1 0 0 14.0099999999999 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 7.22999999999992 etendo.public.fin_bankstatementline 0 0 0.01 etendo.public.ad_process_request 0 0 0 etendo.public.ad_ep_instance_para 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.public.ad_session 0 0 0.05 etendo.public.fin_reconciliation 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.pg_catalog.pg_statistic 0 0 5.06999999999994 etendo.public.prscrm_contact 0 0 0.27 etendo.pg_toast.pg_toast_2619 0 0 0.1 etendo.public.prscrm_conf 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.pg_catalog.pg_type 0 0 0 etendo.pg_toast.pg_toast_81522 0 0 0.01 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.pg_toast.pg_toast_88656 0 0 0 Total 0 0 272.27 Tuples removed per table
Key values
- public.opxap_detalle_costes (236943) Main table with removed tuples on database etendo
- 302617 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.opxap_detalle_costes 623 9 236,943 189,732,419 173,325,928 3,723 9,107,920 etendo.profile.last_stat_indexes_srv1 605 5 29,755 21,424,635 19,644,120 239 875,176 etendo.profile.last_stat_tables_srv1 605 5 19,226 13,743,549 12,643,680 0 713,917 etendo.profile.last_stat_statements_srv1 605 5 7,899 8,280,629 7,406,340 0 440,578 etendo.public.prscrm_account 623 4 3,972 3,802,502 3,521,851 116 837,589 etendo.profile.last_stat_user_functions_srv1 605 5 3,215 2,456,465 2,107,380 0 77,655 etendo.pg_toast.pg_toast_2619 374 2 552 862,633 256,199 0 274,890 etendo.profile.tables_list 423 3 346 1,244,707 391,836 0 27,700 etendo.public.prscrm_contact 421 1 102 579,692 455,280 0 381,717 etendo.pg_catalog.pg_statistic 421 1 100 6,002,477 1,683,672 0 340,941 etendo.public.ad_ep_instance_para 548 12 88 113,972 113,972 4 2,499 etendo.profile.funcs_list 482 2 81 211,800 116,612 0 5,716 etendo.profile.last_extension_versions 302 2 72 24,354 21,636 0 482 etendo.profile.stmt_list 422 2 64 414,088 135,408 0 30,787 etendo.profile.indexes_list 422 2 53 277,205 104,896 0 6,323 etendo.profile.last_stat_io 422 2 46 50,430 44,100 0 1,264 etendo.profile.last_stat_slru 1 1 40 20 15 0 1 etendo.profile.last_stat_activity_count_srv1 242 0 24 16,368 16,368 1 482 etendo.public.prscrm_conf 361 1 15 30,903 30,542 0 7,581 etendo.pg_toast.pg_toast_81522 1 1 13 392 18 0 87 etendo.public.ad_process_request 566 1 7 445,347 294,077 0 49,793 etendo.public.ad_session 460 1 4 2,172,802 692,648 0 97,007 etendo.public.fin_reconciliation 455 1 0 51,913 36,906 0 2,705 etendo.public.fin_bankstatementline 599 1 0 920,608 368,347 0 56,297 etendo.pg_catalog.pg_type 1 1 0 2,713 220 0 70 etendo.profile.last_stat_database_srv1 1 1 0 24 20 0 1 etendo.pg_toast.pg_toast_88656 1 1 0 17 16 0 5 Total 10,591 72 302,617 252,862,664 223,412,087 4,083 13,339,183 Pages removed per table
Key values
- public.opxap_detalle_costes (3723) Main table with removed pages on database etendo
- 4083 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.opxap_detalle_costes 623 9 236943 3723 etendo.profile.last_stat_indexes_srv1 605 5 29755 239 etendo.public.prscrm_account 623 4 3972 116 etendo.public.ad_ep_instance_para 548 12 88 4 etendo.profile.last_stat_activity_count_srv1 242 0 24 1 etendo.public.fin_reconciliation 455 1 0 0 etendo.public.prscrm_conf 361 1 15 0 etendo.public.fin_bankstatementline 599 1 0 0 etendo.profile.last_stat_tables_srv1 605 5 19226 0 etendo.profile.tables_list 423 3 346 0 etendo.pg_catalog.pg_type 1 1 0 0 etendo.profile.last_extension_versions 302 2 72 0 etendo.profile.last_stat_user_functions_srv1 605 5 3215 0 etendo.public.ad_session 460 1 4 0 etendo.pg_toast.pg_toast_2619 374 2 552 0 etendo.public.ad_process_request 566 1 7 0 etendo.pg_toast.pg_toast_81522 1 1 13 0 etendo.profile.funcs_list 482 2 81 0 etendo.pg_catalog.pg_statistic 421 1 100 0 etendo.public.prscrm_contact 421 1 102 0 etendo.profile.stmt_list 422 2 64 0 etendo.profile.last_stat_database_srv1 1 1 0 0 etendo.profile.last_stat_statements_srv1 605 5 7899 0 etendo.profile.last_stat_slru 1 1 40 0 etendo.profile.last_stat_io 422 2 46 0 etendo.pg_toast.pg_toast_88656 1 1 0 0 etendo.profile.indexes_list 422 2 53 0 Total 10,591 72 302,617 4,083 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 13 07 12 12 08 12 15 09 10 15 10 13 19 11 36 15 12 450 23 13 543 16 14 678 20 15 1,093 17 16 1,202 13 17 1,261 12 18 1,321 14 19 1,320 15 20 1,320 13 21 1,320 18 22 0 0 - 0.84 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
- 2 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 2 Requests
- 2s151ms (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 2 Requests
User Request type Count Duration postgres Total 2 2s151ms select 2 2s151ms Duration by user
Key values
- 2s151ms (postgres) Main time consuming user
User Request type Count Duration postgres Total 2 2s151ms select 2 2s151ms Queries by host
Key values
- [local] Main host
- 2 Requests
- 2s151ms ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 2 Requests
- 2s151ms (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-13 08:43:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s78ms SELECT profile.take_sample ();[ Date: 2026-07-13 14:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 1s72ms SELECT profile.take_sample ();[ Date: 2026-07-13 09: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 2s151ms 2 1s72ms 1s78ms 1s75ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 09 1 1s72ms 1s72ms 14 1 1s78ms 1s78ms [ User: postgres - Total duration: 2s151ms - Times executed: 2 ]
[ Application: psql - Total duration: 2s151ms - Times executed: 2 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 14:00:02 Duration: 1s78ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 09:00:02 Duration: 1s72ms 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 2 2s151ms 1s72ms 1s78ms 1s75ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 09 1 1s72ms 1s72ms 14 1 1s78ms 1s78ms [ User: postgres - Total duration: 2s151ms - Times executed: 2 ]
[ Application: psql - Total duration: 2s151ms - Times executed: 2 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 14:00:02 Duration: 1s78ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 09:00:02 Duration: 1s72ms 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 1s72ms 1s78ms 1s75ms 2 2s151ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 09 1 1s72ms 1s72ms 14 1 1s78ms 1s78ms [ User: postgres - Total duration: 2s151ms - Times executed: 2 ]
[ Application: psql - Total duration: 2s151ms - Times executed: 2 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 14:00:02 Duration: 1s78ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 09:00:02 Duration: 1s72ms 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
- 36,066 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 884 FATAL entries
- 33 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 876 Max number of times the same event was reported
- 920 Total events found
Rank Times reported Error 1 876 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 13 07 67 08 67 09 58 10 60 11 59 12 55 13 56 14 57 15 61 16 62 17 59 18 62 19 62 20 63 21 28 - FATAL: no pg_hba.conf entry for host "186.236.254.56", user "webuser", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
Date: 2026-07-13 07:00:11 Database: postgres Application: [unknown] User: webuser Remote: 186.236.254.56
Date: 2026-07-13 07:01:03 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
Date: 2026-07-13 07:01:03 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
2 15 ERROR: Email en uso... no pongas nada o usa otro email. -> Email: gemabalbas@acquabysalud.com
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 13 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-13 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-13 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-13 09:45:03 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
3 7 ERROR: @20501@
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 13 07 3 11 2 13 2 - ERROR: @20501@
- ERROR: @20501@
- ERROR: @20501@
Context: PL/pgSQL function c_invline_chk_restrictions_trg() line 99 at RAISE
Statement: insert into C_InvoiceLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, Line, Financial_Invoice_Line, QtyInvoiced, PriceList, PriceActual, PriceLimit, LineNetAmt, C_UOM_ID, IsDescription, PriceStd, Excludeforwithholding, Iseditlinenetamt, Line_Gross_Amount, Gross_Unit_Price, C_Bpartner_ID, grosspricestd, Grosspricelist, IsDeferred, Explode, Match_Lccosts, CANCELPRICEAD, EM_Prapi_Deleteadvpaymentline, EM_Prapi_Isadvpaymentline, C_InvoiceLine_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)Date: 2026-07-13 07:25:13 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function c_invtax_chk_restrictions_trg() line 53 at RAISE
Statement: delete from C_InvoiceTax where C_InvoiceTax_ID=$1Date: 2026-07-13 07:41:35 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function c_invline_chk_restrictions_trg() line 99 at RAISE
Statement: insert into C_InvoiceLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, Line, Financial_Invoice_Line, QtyInvoiced, PriceList, PriceActual, PriceLimit, LineNetAmt, C_UOM_ID, IsDescription, PriceStd, Excludeforwithholding, Iseditlinenetamt, Line_Gross_Amount, Gross_Unit_Price, C_Bpartner_ID, grosspricestd, Grosspricelist, IsDeferred, Explode, Match_Lccosts, CANCELPRICEAD, EM_Prapi_Deleteadvpaymentline, EM_Prapi_Isadvpaymentline, C_InvoiceLine_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)Date: 2026-07-13 07:44:41 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
4 3 ERROR: @DeliveredInvoicedOrderline@
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 13 07 3 - ERROR: @DeliveredInvoicedOrderline@
- ERROR: @DeliveredInvoicedOrderline@
- ERROR: @DeliveredInvoicedOrderline@
Context: PL/pgSQL function c_ordline_chk_restrictions_trg() line 84 at RAISE
Statement: update C_OrderLine set Updated=$1, Description=$2, PriceList=$3, PriceActual=$4, LineNetAmt=$5, Discount=$6, PriceStd=$7, Taxbaseamt=$8 where C_OrderLine_ID=$9Date: 2026-07-13 07:40:32 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function c_ordline_chk_restrictions_trg() line 84 at RAISE
Statement: update C_OrderLine set Updated=$1, PriceList=$2, PriceActual=$3, LineNetAmt=$4, Discount=$5, PriceStd=$6, Taxbaseamt=$7 where C_OrderLine_ID=$8Date: 2026-07-13 07:41:13 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function c_ordline_chk_restrictions_trg() line 84 at RAISE
Statement: update C_OrderLine set Updated=$1, Description=$2, PriceList=$3, PriceActual=$4, LineNetAmt=$5, Discount=$6 where C_OrderLine_ID=$7Date: 2026-07-13 07:41:47 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
5 3 ERROR: @GLJournalDocumentPosted@
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 13 12 1 13 2 - ERROR: @GLJournalDocumentPosted@
- ERROR: @GLJournalDocumentPosted@
- ERROR: @GLJournalDocumentPosted@
Context: PL/pgSQL function gl_journal_post(character varying,character varying) line 360 at RAISE
Statement: SELECT gl_journal_post($1,$2) AS RESULT FROM DUALDate: 2026-07-13 12:57:24 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function gl_journal_post(character varying,character varying) line 360 at RAISE
Statement: SELECT gl_journal_post($1,$2) AS RESULT FROM DUALDate: 2026-07-13 13:04:00 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function gl_journal_post(character varying,character varying) line 360 at RAISE
Statement: SELECT gl_journal_post($1,$2) AS RESULT FROM DUALDate: 2026-07-13 13:10:00 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
6 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 13 17 1 20 1 - FATAL: no pg_hba.conf entry for host "34.34.178.22", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "47.86.9.194", user "postgres", database "template0", SSL encryption
Date: 2026-07-13 17:49:00 Database: postgres Application: [unknown] User: postgres Remote: 34.34.178.22
Date: 2026-07-13 20:15:57 Database: template0 Application: [unknown] User: postgres Remote: 47.86.9.194
7 2 ERROR: @ProductDefinedByOrder@
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 13 14 2 - ERROR: @ProductDefinedByOrder@
- ERROR: @ProductDefinedByOrder@
Context: PL/pgSQL function c_invline_chk_restrictions_trg() line 88 at RAISE
Statement: update C_InvoiceLine set Updated=$1, UpdatedBy=$2, M_Product_ID=$3 where C_InvoiceLine_ID=$4Date: 2026-07-13 14:02:51 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function c_invline_chk_restrictions_trg() line 88 at RAISE
Statement: update C_InvoiceLine set Updated=$1, UpdatedBy=$2, M_Product_ID=$3 where C_InvoiceLine_ID=$4Date: 2026-07-13 14:12:16 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
8 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 13 17 1 18 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
Date: 2026-07-13 17:55:45 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.222
Date: 2026-07-13 18:56:08 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.224.80
9 2 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 13 11 1 14 1 - 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-13 11:27:29 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Date: 2026-07-13 14:06:11 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
10 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 13 17 1 18 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
Date: 2026-07-13 17:55:45 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.222
Date: 2026-07-13 18:56:09 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.224.80
11 2 ERROR: @APRM_JSAMOUNTDIFFTOZERO@
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 13 12 2 - ERROR: @APRM_JSAMOUNTDIFFTOZERO@
- ERROR: @APRM_JSAMOUNTDIFFTOZERO@
Context: PL/pgSQL function gl_journalline_trg() line 67 at RAISE
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, C_ValidCombination_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_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)Date: 2026-07-13 12:43:59 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function gl_journalline_trg() line 67 at RAISE
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, C_ValidCombination_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_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)Date: 2026-07-13 12:45:32 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
12 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 13 17 1 18 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-13 17:55:46 Database: [unknown] Application: [unknown] User: [unknown] Remote: 64.62.156.222
Date: 2026-07-13 18:56:12 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.224.80
13 1 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 13 11 1 - ERROR: update or delete on table "c_invoiceline" violates foreign key constraint "opxap_detalle_costes_invline" on table "opxap_detalle_costes"
Detail: Key (c_invoiceline_id)=(33E661AA03784E43B8678BFDC519A843) is still referenced from table "opxap_detalle_costes".
Statement: delete from C_InvoiceLine where C_InvoiceLine_ID=$1Date: 2026-07-13 11:22:51 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
14 1 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 13 14 1 - ERROR: unexpected EOF on client connection with an open transaction
Date: 2026-07-13 14:06:11 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1