pgBadger-
Global information
- Generated on Mon Jul 13 23:00:19 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 94,314 log entries in 17s
- Log start from 2026-07-13 07:00:01 to 2026-07-13 21:59:59
-
Overview
Global Stats
- 1 Number of unique normalized queries
- 15 Number of queries
- 1m36s Total query duration
- 2026-07-13 07:00:05 First query
- 2026-07-13 21:00:05 Last query
- 1 queries/s at 2026-07-13 14:00:04 Query peak
- 1m36s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1m36s Execute total duration
- 329 Number of events
- 7 Number of unique normalized events
- 311 Max number of times the same event was reported
- 0 Number of cancellation
- 46,775 Total number of automatic vacuums
- 117 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 5,417 Total number of sessions
- 21 sessions at 2026-07-13 20:00:01 Session peak
- 3m28s Total duration of sessions
- 38ms Average duration of sessions
- 0 Average queries per session
- 17ms Average queries duration per session
- 20ms Average idle time per session
- 5,417 Total number of connections
- 6 connections/s at 2026-07-13 08:55:15 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 14:00:04 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-13 14:00:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 1m36s 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 1 0ms 4s72ms 4s72ms 0ms 0ms 4s72ms 08 1 0ms 3s283ms 3s283ms 0ms 0ms 3s283ms 09 1 0ms 2s603ms 2s603ms 0ms 0ms 2s603ms 10 1 0ms 2s643ms 2s643ms 0ms 0ms 2s643ms 11 1 0ms 3s178ms 3s178ms 0ms 0ms 3s178ms 12 1 0ms 3s139ms 3s139ms 0ms 0ms 3s139ms 13 1 0ms 2s679ms 2s679ms 0ms 0ms 2s679ms 14 1 0ms 3s100ms 3s100ms 0ms 0ms 3s100ms 15 1 0ms 3s160ms 3s160ms 0ms 0ms 3s160ms 16 1 0ms 2s711ms 2s711ms 0ms 0ms 2s711ms 17 1 0ms 30s626ms 30s626ms 0ms 0ms 30s626ms 18 1 0ms 2s641ms 2s641ms 0ms 0ms 2s641ms 19 1 0ms 26s366ms 26s366ms 0ms 0ms 26s366ms 20 1 0ms 3s182ms 3s182ms 0ms 0ms 3s182ms 21 1 0ms 3s250ms 3s250ms 0ms 0ms 3s250ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 07 1 0 4s72ms 0ms 0ms 0ms 08 1 0 3s283ms 0ms 0ms 0ms 09 1 0 2s603ms 0ms 0ms 0ms 10 1 0 2s643ms 0ms 0ms 0ms 11 1 0 3s178ms 0ms 0ms 0ms 12 1 0 3s139ms 0ms 0ms 0ms 13 1 0 2s679ms 0ms 0ms 0ms 14 1 0 3s100ms 0ms 0ms 0ms 15 1 0 3s160ms 0ms 0ms 0ms 16 1 0 2s711ms 0ms 0ms 0ms 17 1 0 30s626ms 0ms 0ms 0ms 18 1 0 2s641ms 0ms 0ms 0ms 19 1 0 26s366ms 0ms 0ms 0ms 20 1 0 3s182ms 0ms 0ms 0ms 21 1 0 3s250ms 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 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% Day Hour Count Average / Second Jul 13 07 363 0.10/s 08 361 0.10/s 09 361 0.10/s 10 361 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 13 07 363 32ms 20ms 08 361 30ms 21ms 09 361 27ms 20ms 10 361 27ms 20ms 11 361 29ms 20ms 12 361 29ms 20ms 13 361 27ms 20ms 14 361 28ms 20ms 15 361 29ms 20ms 16 361 28ms 20ms 17 361 105ms 20ms 18 361 27ms 20ms 19 361 93ms 20ms 20 361 29ms 21ms 21 361 29ms 20ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-13 08:55:15 Date
Connections per database
Key values
- etendo Main Database
- 5,417 connections Total
Connections per user
Key values
- tad Main User
- 5,417 connections Total
-
Sessions
Simultaneous sessions
Key values
- 21 sessions Session Peak
- 2026-07-13 20:00:01 Date
Histogram of session times
Key values
- 5,387 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,417 sessions Total
Sessions per user
Key values
- tad Main User
- 5,417 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,417 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,005 buffers Checkpoint Peak
- 2026-07-13 07:06:54 Date
- 200.417 seconds Highest write time
- 0.035 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-07-13 07:06:54 Date
Checkpoints distance
Key values
- 32.54 Mo Distance Peak
- 2026-07-13 07:06:54 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 13 07 3,044 303.11s 0.05s 303.201s 08 1,810 181.111s 0.014s 181.163s 09 2,079 207.594s 0.012s 207.644s 10 1,723 172.196s 0.015s 172.245s 11 1,792 179.107s 0.012s 179.155s 12 1,734 173.388s 0.013s 173.436s 13 1,660 165.757s 0.012s 165.809s 14 1,681 168.075s 0.013s 168.129s 15 1,657 165.573s 0.013s 165.625s 16 1,709 171.09s 0.012s 171.136s 17 1,602 159.853s 0.013s 159.899s 18 1,669 166.772s 0.013s 166.824s 19 1,614 161.563s 0.013s 161.615s 20 1,662 166.072s 0.013s 166.121s 21 1,639 163.967s 0.013s 164.015s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 13 07 0 0 2 499 0.006s 0.013s 08 0 0 1 165 0.002s 0.012s 09 0 0 1 172 0.001s 0.012s 10 0 0 0 194 0.001s 0.012s 11 0 0 1 166 0.001s 0.012s 12 0 0 1 154 0.001s 0.012s 13 0 0 1 153 0.001s 0.012s 14 0 0 1 153 0.001s 0.012s 15 0 0 1 153 0.001s 0.012s 16 0 0 0 153 0.001s 0.012s 17 0 0 1 153 0.001s 0.012s 18 0 0 1 153 0.001s 0.012s 19 0 0 1 153 0.001s 0.012s 20 0 0 0 150 0.001s 0.012s 21 0 0 1 153 0.001s 0.012s 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 Day Hour Mean distance Mean estimate Jul 13 07 1,795.00 kB 10,073.62 kB 08 1,197.50 kB 8,567.17 kB 09 1,356.75 kB 8,156.83 kB 10 1,092.83 kB 7,683.83 kB 11 1,164.75 kB 8,330.50 kB 12 1,119.58 kB 8,027.92 kB 13 1,074.00 kB 7,700.83 kB 14 1,081.42 kB 7,754.00 kB 15 1,072.83 kB 7,692.08 kB 16 1,106.17 kB 7,931.42 kB 17 1,031.42 kB 7,395.50 kB 18 1,081.00 kB 7,750.92 kB 19 1,050.33 kB 7,531.08 kB 20 1,073.83 kB 7,699.42 kB 21 1,060.08 kB 7,600.75 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 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.94 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-13 17:01:00 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 3.94 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-13 17:01:00 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 117 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_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.tables_list 9 etendo.profile.last_stat_io 7 etendo.profile.indexes_list 6 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.stmt_list 4 etendo.profile.last_stat_slru 3 etendo.profile.funcs_list 2 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.last_stat_cluster 1 etendo.public.ad_module 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_tables 1 etendo.profile.last_stat_archiver 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_database 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_io 1 etendo.public.ad_session 1 etendo.public.ad_preference 1 Total 117 Vacuums per table
Key values
- public.ad_session (900) Main table vacuumed on database etendo
- 46,775 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.ad_session 900 0 569,938 0 56 0 0 18 3 27,087 0 0 etendo.public.ad_process_run 900 0 215,355 0 0 0 0 15 0 2,820 0 0 etendo.public.ad_preference 900 0 1,059,420 0 21 0 0 16 15 122,543 0 0 etendo.pg_catalog.pg_statistic 900 0 30,010,154 0 19 0 0 32 16 134,304 0 0 etendo.public.m_storage_pending 900 0 204,585 0 15 0 0 15 14 114,330 0 0 etendo.public.c_bpartner 900 0 334,546 0 393 0 0 1,838 18 380,829 1 1 etendo.public.ad_ep_instance_para 900 0 448,335 0 18 0 0 15 14 114,330 0 0 etendo.public.ad_sequence 900 0 128,430 0 15 0 0 15 14 114,218 0 0 etendo.profile.last_stat_slru 900 0 108,015 0 57 0 0 15 14 113,602 0 0 etendo.profile.last_extension_versions 900 0 155,985 0 57 0 0 15 14 113,546 0 0 etendo.public.c_order 900 0 3,800,340 0 15 0 0 15 14 115,058 0 0 etendo.public.c_invoicetax 900 0 335,988 0 20 0 0 36 18 150,714 0 0 etendo.profile.last_stat_cluster 900 0 48,885 0 60 0 0 15 14 115,170 0 0 etendo.public.ad_user 900 0 118,965 0 18 0 0 16 14 114,915 1 2 etendo.public.c_invoice 900 0 96,451,870 0 15 0 0 17 14 114,666 2 11 etendo.profile.last_stat_tablespaces_srv1 900 0 64,050 0 45 0 0 15 0 7,095 0 0 etendo.profile.last_stat_tables_srv1 900 0 192,952,320 0 0 0 0 30 0 14,190 0 0 etendo.profile.last_stat_statements_srv1 900 0 31,978,305 0 4 0 0 15 0 7,095 0 0 etendo.public.ad_pinstance 900 0 391,815 0 3 0 0 15 0 2,820 0 0 etendo.profile.last_stat_wal 900 0 41,670 0 60 0 0 15 14 115,506 0 0 etendo.profile.last_stat_io 900 0 386,775 0 48 0 0 15 14 113,378 0 0 etendo.public.ad_process_request 900 0 373,094 0 0 0 0 15 0 2,820 0 0 etendo.profile.last_stat_archiver 900 0 36,195 0 59 0 0 15 14 113,938 0 0 etendo.profile.last_stat_database_srv1 900 0 209,670 0 39 0 0 15 0 7,095 0 0 etendo.public.ad_session_usage_audit 900 0 3,602,743 0 23 0 0 19 16 131,716 0 0 etendo.profile.servers 900 0 61,755 0 60 0 0 30 14 116,007 15 15 etendo.public.ad_module 900 0 1,347,320 0 1 0 0 16 1 11,033 0 0 etendo.profile.tables_list 899 0 2,798,868 0 3 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_slru 899 0 93,661 0 45 0 0 15 0 3,615 0 0 etendo.profile.funcs_list 899 0 494,419 0 30 0 0 15 0 3,615 0 0 etendo.pg_toast.pg_toast_2619 899 0 4,804,407 0 32 0 0 20 17 139,097 0 0 etendo.profile.samples 899 0 52,412 0 45 0 0 15 0 3,615 0 0 etendo.profile.last_stat_activity_count_srv1 899 0 235,880 0 49 0 0 15 12 98,583 0 0 etendo.profile.sample_stat_user_func_total 899 0 50,494 0 45 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_cluster 899 0 49,728 0 45 0 0 15 0 3,615 0 0 etendo.profile.last_stat_indexes_srv1 899 0 236,993,787 0 2 0 0 30 0 14,190 0 0 etendo.profile.sample_stat_tablespaces 899 0 60,413 0 45 0 0 15 0 3,615 0 0 etendo.pg_toast.pg_toast_81842 899 0 9,849,940 0 2 0 0 16 1 11,009 0 0 etendo.profile.stmt_list 899 0 1,894,300 0 31 0 0 15 14 7,927 0 0 etendo.profile.sample_stat_database 899 0 210,441 0 40 0 0 16 1 11,712 0 0 etendo.profile.sample_stat_io 899 0 165,265 0 39 0 0 15 0 3,615 0 0 etendo.profile.last_stat_user_functions_srv1 899 0 14,645,443 0 2 0 0 15 0 7,095 0 0 etendo.profile.sample_statements_total 899 0 170,674 0 45 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_archiver 899 0 37,024 0 45 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_tables 899 0 8,966,646 0 0 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_tables_total 899 0 318,287 0 33 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_indexes 899 0 1,197,235 0 0 0 0 15 0 3,615 0 0 etendo.profile.sample_statements 899 0 3,234,717 0 1 0 0 17 1 11,953 0 0 etendo.profile.sample_stat_user_functions 899 0 419,634 0 30 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_wal 899 0 42,418 0 45 0 0 15 0 3,615 0 0 etendo.profile.indexes_list 899 0 996,858 0 15 0 0 15 0 3,615 0 0 etendo.profile.sample_stat_indexes_total 899 0 100,838 0 45 0 0 15 0 3,615 0 0 Total 46,775 0 653,320,312 1,432 1,835 0 0 2,707 315 2,853,846 19 29 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (3350.26) 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.ad_session 0 0 0.12 etendo.public.ad_process_run 0 0 0 etendo.public.ad_preference 0 0 8.99999999999985 etendo.pg_catalog.pg_statistic 0 0 429.72 etendo.public.m_storage_pending 0 0 0 etendo.public.c_bpartner 0 0 0.01 etendo.public.ad_ep_instance_para 0 0 0 etendo.public.ad_sequence 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.public.c_order 0 0 44.9799999999996 etendo.public.c_invoicetax 0 0 0.01 etendo.profile.last_stat_cluster 0 0 0 etendo.public.ad_user 0 0 0 etendo.public.c_invoice 0 0 1,287.08000000001 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.last_stat_tables_srv1 0 0 2,689.81 etendo.profile.last_stat_statements_srv1 0 0 435.690000000002 etendo.public.ad_pinstance 0 0 0 etendo.profile.last_stat_wal 0 0 0 etendo.profile.last_stat_io 0 0 0.02 etendo.public.ad_process_request 0 0 0 etendo.profile.last_stat_archiver 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.public.ad_session_usage_audit 0 0 50.2 etendo.profile.servers 0 0 0 etendo.public.ad_module 0 0 9.71999999999984 etendo.profile.tables_list 0 0 35.8399999999994 etendo.profile.sample_stat_slru 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 53.8700000000005 etendo.profile.samples 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.profile.sample_stat_cluster 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 3,350.26 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.pg_toast.pg_toast_81842 0 0 115.929999999999 etendo.profile.stmt_list 0 0 17.9799999999997 etendo.profile.sample_stat_database 0 0 0 etendo.profile.sample_stat_io 0 0 0 etendo.profile.last_stat_user_functions_srv1 0 0 202.94 etendo.profile.sample_statements_total 0 0 0 etendo.profile.sample_stat_archiver 0 0 0 etendo.profile.sample_stat_tables 0 0 120.36 etendo.profile.sample_stat_tables_total 0 0 0 etendo.profile.sample_stat_indexes 0 0 12.0999999999998 etendo.profile.sample_statements 0 0 37.3599999999995 etendo.profile.sample_stat_user_functions 0 0 0.01 etendo.profile.sample_stat_wal 0 0 0 etendo.profile.indexes_list 0 0 8.98999999999985 etendo.profile.sample_stat_indexes_total 0 0 0 Total 0 0 8,912.00000000002 Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.ad_session 900 0 0 7,440,214 7,372,030 0 250,148 etendo.public.ad_process_run 900 0 0 1,516,500 1,316,700 0 72,900 etendo.public.ad_preference 900 0 0 3,707,902 3,556,702 0 506,480 etendo.pg_catalog.pg_statistic 900 0 0 235,684,843 228,960,043 0 14,997,817 etendo.profile.tables_list 899 0 0 63,311,962 62,535,764 0 1,378,210 etendo.public.m_storage_pending 900 0 0 1,997,100 1,905,300 0 80,100 etendo.public.c_bpartner 900 0 0 963,000 540,900 0 76,500 etendo.profile.sample_stat_slru 899 0 0 2,269,947 1,663,423 0 32,364 etendo.profile.funcs_list 899 0 0 8,142,987 7,994,172 0 226,008 etendo.pg_toast.pg_toast_2619 899 0 0 11,663,402 10,841,833 0 2,420,726 etendo.public.ad_ep_instance_para 900 0 0 10,627,200 10,627,200 0 213,300 etendo.profile.samples 899 0 0 567,262 415,631 0 3,596 etendo.public.ad_sequence 900 0 0 1,461,600 1,335,600 0 41,400 etendo.profile.last_stat_activity_count_srv1 899 0 0 4,632,550 4,632,550 0 112,913 etendo.profile.last_stat_slru 900 0 0 2,839,500 2,835,000 0 40,440 etendo.profile.sample_stat_user_func_total 899 0 0 1,134,524 831,262 0 9,889 etendo.profile.sample_stat_cluster 899 0 0 567,262 415,631 0 11,746 etendo.profile.last_stat_indexes_srv1 899 0 0 2,921,936,370 2,919,647,516 0 118,460,425 etendo.profile.last_extension_versions 900 0 0 4,543,200 4,536,000 0 62,640 etendo.profile.sample_stat_tablespaces 899 0 0 1,134,524 831,262 0 8,990 etendo.public.c_order 900 0 0 17,926,200 6,285,600 0 1,832,400 etendo.public.c_invoicetax 900 0 0 4,840,960 2,502,000 0 556,200 etendo.profile.last_stat_cluster 900 0 0 567,900 567,000 0 11,760 etendo.public.ad_user 900 0 0 370,800 192,600 0 17,100 etendo.public.c_invoice 900 0 0 483,860,700 473,446,800 0 48,066,300 etendo.profile.last_stat_tablespaces_srv1 900 0 0 1,135,800 1,134,000 0 18,000 etendo.pg_toast.pg_toast_81842 899 0 0 19,652,179 19,209,871 0 4,912,820 etendo.profile.last_stat_tables_srv1 900 0 0 1,869,552,060 1,868,173,260 0 96,443,880 etendo.profile.stmt_list 899 0 0 12,494,142 12,129,028 0 927,282 etendo.profile.sample_stat_database 899 0 0 2,269,048 1,662,524 0 91,158 etendo.profile.last_stat_statements_srv1 900 0 0 295,424,760 295,073,400 0 15,964,680 etendo.public.ad_pinstance 900 0 0 4,765,500 4,327,200 0 178,200 etendo.profile.sample_stat_io 899 0 0 2,979,010 2,175,546 0 65,926 etendo.profile.last_stat_wal 900 0 0 567,900 567,000 0 8,580 etendo.profile.last_stat_io 900 0 0 7,950,600 7,938,000 0 177,120 etendo.profile.last_stat_user_functions_srv1 899 0 0 221,012,061 220,691,118 0 7,306,682 etendo.public.ad_process_request 900 0 0 1,269,000 1,127,700 0 169,200 etendo.profile.sample_statements_total 899 0 0 1,701,786 1,246,893 0 71,320 etendo.profile.sample_stat_archiver 899 0 0 567,262 415,631 0 5,394 etendo.profile.sample_stat_tables 899 0 0 130,985,358 95,083,199 0 4,450,412 etendo.profile.sample_stat_tables_total 899 0 0 5,105,358 3,740,679 0 133,889 etendo.profile.sample_stat_indexes 899 0 0 35,727,120 25,843,543 0 566,183 etendo.profile.last_stat_archiver 900 0 0 567,900 567,000 0 5,400 etendo.profile.sample_statements 899 0 0 31,679,173 23,136,137 0 1,584,443 etendo.profile.last_stat_database_srv1 900 0 0 2,271,600 2,268,000 0 91,260 etendo.public.ad_session_usage_audit 900 0 0 53,401,053 31,308,300 0 1,778,184 etendo.profile.sample_stat_user_functions 899 0 0 19,847,128 14,472,365 0 185,911 etendo.profile.sample_stat_wal 899 0 0 567,262 415,631 0 8,091 etendo.profile.servers 900 0 0 568,800 567,900 0 10,800 etendo.profile.indexes_list 899 0 0 21,517,548 21,136,192 0 468,672 etendo.public.ad_module 900 0 0 8,478,540 8,289,540 0 656,658 etendo.profile.sample_stat_indexes_total 899 0 0 2,269,048 1,662,524 0 26,071 Total 46,775 0 0 6,548,035,405 6,420,150,700 0 325,796,568 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.ad_session 900 0 0 0 etendo.public.ad_process_run 900 0 0 0 etendo.public.ad_preference 900 0 0 0 etendo.pg_catalog.pg_statistic 900 0 0 0 etendo.profile.tables_list 899 0 0 0 etendo.public.m_storage_pending 900 0 0 0 etendo.public.c_bpartner 900 0 0 0 etendo.profile.sample_stat_slru 899 0 0 0 etendo.profile.funcs_list 899 0 0 0 etendo.pg_toast.pg_toast_2619 899 0 0 0 etendo.public.ad_ep_instance_para 900 0 0 0 etendo.profile.samples 899 0 0 0 etendo.public.ad_sequence 900 0 0 0 etendo.profile.last_stat_activity_count_srv1 899 0 0 0 etendo.profile.last_stat_slru 900 0 0 0 etendo.profile.sample_stat_user_func_total 899 0 0 0 etendo.profile.sample_stat_cluster 899 0 0 0 etendo.profile.last_stat_indexes_srv1 899 0 0 0 etendo.profile.last_extension_versions 900 0 0 0 etendo.profile.sample_stat_tablespaces 899 0 0 0 etendo.public.c_order 900 0 0 0 etendo.public.c_invoicetax 900 0 0 0 etendo.profile.last_stat_cluster 900 0 0 0 etendo.public.ad_user 900 0 0 0 etendo.public.c_invoice 900 0 0 0 etendo.profile.last_stat_tablespaces_srv1 900 0 0 0 etendo.pg_toast.pg_toast_81842 899 0 0 0 etendo.profile.last_stat_tables_srv1 900 0 0 0 etendo.profile.stmt_list 899 0 0 0 etendo.profile.sample_stat_database 899 0 0 0 etendo.profile.last_stat_statements_srv1 900 0 0 0 etendo.public.ad_pinstance 900 0 0 0 etendo.profile.sample_stat_io 899 0 0 0 etendo.profile.last_stat_wal 900 0 0 0 etendo.profile.last_stat_io 900 0 0 0 etendo.profile.last_stat_user_functions_srv1 899 0 0 0 etendo.public.ad_process_request 900 0 0 0 etendo.profile.sample_statements_total 899 0 0 0 etendo.profile.sample_stat_archiver 899 0 0 0 etendo.profile.sample_stat_tables 899 0 0 0 etendo.profile.sample_stat_tables_total 899 0 0 0 etendo.profile.sample_stat_indexes 899 0 0 0 etendo.profile.last_stat_archiver 900 0 0 0 etendo.profile.sample_statements 899 0 0 0 etendo.profile.last_stat_database_srv1 900 0 0 0 etendo.public.ad_session_usage_audit 900 0 0 0 etendo.profile.sample_stat_user_functions 899 0 0 0 etendo.profile.sample_stat_wal 899 0 0 0 etendo.profile.servers 900 0 0 0 etendo.profile.indexes_list 899 0 0 0 etendo.public.ad_module 900 0 0 0 etendo.profile.sample_stat_indexes_total 899 0 0 0 Total 46,775 0 0 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 13 07 3,120 14 08 3,120 7 09 3,120 10 10 3,120 6 11 3,120 11 12 3,120 7 13 3,120 8 14 3,120 9 15 3,120 6 16 3,119 8 17 3,097 5 18 3,119 6 19 3,120 7 20 3,120 7 21 3,120 6 - 3.94 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
- 15 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 15 Requests
- 1m36s (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 15 Requests
User Request type Count Duration postgres Total 15 1m36s select 15 1m36s Duration by user
Key values
- 1m36s (postgres) Main time consuming user
User Request type Count Duration postgres Total 15 1m36s select 15 1m36s Queries by host
Key values
- [local] Main host
- 15 Requests
- 1m36s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 15 Requests
- 1m36s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-13 13:31:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 30s626ms SELECT profile.take_sample ();[ Date: 2026-07-13 17:00:32 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2 26s366ms SELECT profile.take_sample ();[ Date: 2026-07-13 19:00:28 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
3 4s72ms SELECT profile.take_sample ();[ Date: 2026-07-13 07:00:05 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
4 3s283ms SELECT profile.take_sample ();[ Date: 2026-07-13 08:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5 3s250ms SELECT profile.take_sample ();[ Date: 2026-07-13 21:00:05 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
6 3s182ms SELECT profile.take_sample ();[ Date: 2026-07-13 20:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
7 3s178ms SELECT profile.take_sample ();[ Date: 2026-07-13 11:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
8 3s160ms SELECT profile.take_sample ();[ Date: 2026-07-13 15:00:05 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 3s139ms SELECT profile.take_sample ();[ Date: 2026-07-13 12:00:05 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 3s100ms SELECT profile.take_sample ();[ Date: 2026-07-13 14:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 2s711ms SELECT profile.take_sample ();[ Date: 2026-07-13 16:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 2s679ms SELECT profile.take_sample ();[ Date: 2026-07-13 13:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 2s643ms SELECT profile.take_sample ();[ Date: 2026-07-13 10:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14 2s641ms SELECT profile.take_sample ();[ Date: 2026-07-13 18:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15 2s603ms SELECT profile.take_sample ();[ Date: 2026-07-13 09:00:04 - 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 1m36s 15 2s603ms 30s626ms 6s442ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 4s72ms 4s72ms 08 1 3s283ms 3s283ms 09 1 2s603ms 2s603ms 10 1 2s643ms 2s643ms 11 1 3s178ms 3s178ms 12 1 3s139ms 3s139ms 13 1 2s679ms 2s679ms 14 1 3s100ms 3s100ms 15 1 3s160ms 3s160ms 16 1 2s711ms 2s711ms 17 1 30s626ms 30s626ms 18 1 2s641ms 2s641ms 19 1 26s366ms 26s366ms 20 1 3s182ms 3s182ms 21 1 3s250ms 3s250ms [ User: postgres - Total duration: 1m36s - Times executed: 15 ]
[ Application: psql - Total duration: 1m36s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 17:00:32 Duration: 30s626ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 19:00:28 Duration: 26s366ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 07:00:05 Duration: 4s72ms 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 15 1m36s 2s603ms 30s626ms 6s442ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 4s72ms 4s72ms 08 1 3s283ms 3s283ms 09 1 2s603ms 2s603ms 10 1 2s643ms 2s643ms 11 1 3s178ms 3s178ms 12 1 3s139ms 3s139ms 13 1 2s679ms 2s679ms 14 1 3s100ms 3s100ms 15 1 3s160ms 3s160ms 16 1 2s711ms 2s711ms 17 1 30s626ms 30s626ms 18 1 2s641ms 2s641ms 19 1 26s366ms 26s366ms 20 1 3s182ms 3s182ms 21 1 3s250ms 3s250ms [ User: postgres - Total duration: 1m36s - Times executed: 15 ]
[ Application: psql - Total duration: 1m36s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 17:00:32 Duration: 30s626ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 19:00:28 Duration: 26s366ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 07:00:05 Duration: 4s72ms 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 2s603ms 30s626ms 6s442ms 15 1m36s select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 1 4s72ms 4s72ms 08 1 3s283ms 3s283ms 09 1 2s603ms 2s603ms 10 1 2s643ms 2s643ms 11 1 3s178ms 3s178ms 12 1 3s139ms 3s139ms 13 1 2s679ms 2s679ms 14 1 3s100ms 3s100ms 15 1 3s160ms 3s160ms 16 1 2s711ms 2s711ms 17 1 30s626ms 30s626ms 18 1 2s641ms 2s641ms 19 1 26s366ms 26s366ms 20 1 3s182ms 3s182ms 21 1 3s250ms 3s250ms [ User: postgres - Total duration: 1m36s - Times executed: 15 ]
[ Application: psql - Total duration: 1m36s - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-13 17:00:32 Duration: 30s626ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 19:00:28 Duration: 26s366ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-13 07:00:05 Duration: 4s72ms 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
- 69,664 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 327 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 311 Max number of times the same event was reported
- 329 Total events found
Rank Times reported Error 1 311 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 28 08 21 09 20 10 21 11 20 12 19 13 19 14 19 15 21 16 26 17 21 18 22 19 23 20 21 21 10 - 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
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "appuser", database "postgres", no encryption
Date: 2026-07-13 07:00:12 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
Date: 2026-07-13 07:03:11 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
Date: 2026-07-13 07:05:49 Database: postgres Application: [unknown] User: appuser Remote: 159.65.148.75
2 5 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 13 11 1 12 2 20 2 - 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-13 11:13:00 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.144.127.252
Date: 2026-07-13 12:04:56 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-13 12:29:53 Database: [unknown] Application: [unknown] User: [unknown] Remote: 194.164.107.5
3 5 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 13 11 1 12 2 20 2 - 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-13 11:13:00 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.144.127.252
Date: 2026-07-13 12:04:56 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-13 12:29:54 Database: [unknown] Application: [unknown] User: [unknown] Remote: 194.164.107.5
4 5 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 13 11 1 12 2 20 2 - 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-13 11:13:00 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.144.127.252
Date: 2026-07-13 12:04:56 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.142
Date: 2026-07-13 12:29:54 Database: [unknown] Application: [unknown] User: [unknown] Remote: 194.164.107.5
5 1 ERROR: incomplete startup packet
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 13 08 1 - ERROR: incomplete startup packet
Date: 2026-07-13 08:17:09 Database: [unknown] Application: [unknown] User: [unknown] Remote: 185.224.128.16
6 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 13 08 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Date: 2026-07-13 08:43:50 Database: [unknown] Application: [unknown] User: [unknown] Remote: 34.38.4.129
7 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 13 07 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-13 07:22:25 Database: [unknown] Application: [unknown] User: [unknown] Remote: 152.53.81.25