pgBadger-
Global information
- Generated on Sat Jul 26 06:00:26 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-07-26.log
- Parsed 1,366,785 log entries in 25s
- Log start from 2025-07-26 00:00:00 to 2025-07-26 06:00:23
-
Overview
Global Stats
- 223 Number of unique normalized queries
- 313,666 Number of queries
- 0ms Total query duration
- 2025-07-26 00:00:00 First query
- 2025-07-26 06:00:23 Last query
- 59 queries/s at 2025-07-26 00:20:01 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 12 Number of events
- 4 Number of unique normalized events
- 6 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 8 Total number of sessions
- 2 sessions at 2025-07-26 05:57:24 Session peak
- 1m5s Total duration of sessions
- 8s234ms Average duration of sessions
- 39,208 Average queries per session
- 0ms Average queries duration per session
- 8s234ms Average idle time per session
- 8 Total number of connections
- 1 connections/s at 2025-07-26 04:20:41 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 59 queries/s Query Peak
- 2025-07-26 00:20:01 Date
SELECT Traffic
Key values
- 34 queries/s Query Peak
- 2025-07-26 04:25:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 43 queries/s Query Peak
- 2025-07-26 00:20:01 Date
Queries duration
Key values
- 0ms 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 26 00 52,193 0ms 0ms 0ms 0ms 0ms 0ms 01 52,363 0ms 0ms 0ms 0ms 0ms 0ms 02 52,223 0ms 0ms 0ms 0ms 0ms 0ms 03 52,164 0ms 0ms 0ms 0ms 0ms 0ms 04 52,091 0ms 0ms 0ms 0ms 0ms 0ms 05 52,181 0ms 0ms 0ms 0ms 0ms 0ms 06 451 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 00 17,136 0 0ms 0ms 0ms 0ms 01 17,140 0 0ms 0ms 0ms 0ms 02 17,158 0 0ms 0ms 0ms 0ms 03 17,154 0 0ms 0ms 0ms 0ms 04 17,171 0 0ms 0ms 0ms 0ms 05 17,162 0 0ms 0ms 0ms 0ms 06 114 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 00 6,903 744 289 0 0ms 0ms 0ms 0ms 01 6,923 744 289 0 0ms 0ms 0ms 0ms 02 6,917 744 289 0 0ms 0ms 0ms 0ms 03 6,903 744 289 0 0ms 0ms 0ms 0ms 04 6,901 744 289 0 0ms 0ms 0ms 0ms 05 6,901 744 289 0 0ms 0ms 0ms 0ms 06 86 5 1 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% Day Hour Count Average / Second Jul 26 00 1 0.00/s 01 1 0.00/s 02 1 0.00/s 03 2 0.00/s 04 2 0.00/s 05 1 0.00/s 06 0 0.00/s Day Hour Count Average Duration Average idle time Jul 26 00 1 9s977ms 9s977ms 01 1 10s589ms 10s589ms 02 1 10s254ms 10s254ms 03 2 5s465ms 5s465ms 04 2 6s155ms 6s155ms 05 1 11s818ms 11s818ms 06 0 0ms 0ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2025-07-26 04:20:41 Date
Connections per database
Key values
- zabbix Main Database
- 8 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-07-26 05:57:24 Date
Histogram of session times
Key values
- 8 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 8 sessions Total
Sessions per user
Key values
- zabbix Main User
- 8 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 8 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 390 buffers Checkpoint Peak
- 2025-07-26 01:21:34 Date
- 38.955 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-07-26 01:21:34 Date
Checkpoints distance
Key values
- 5.07 Mo Distance Peak
- 2025-07-26 01:21:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 26 00 2,780 276.693s 0.027s 276.755s 01 2,875 286.407s 0.033s 286.475s 02 2,835 282.199s 0.03s 282.26s 03 2,754 274.087s 0.033s 274.149s 04 2,750 273.687s 0.029s 273.751s 05 2,733 272.186s 0.032s 272.252s 06 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 26 00 0 0 1 234 0.002s 0.012s 01 0 0 1 231 0.002s 0.012s 02 0 0 1 227 0.002s 0.012s 03 0 0 1 221 0.002s 0.012s 04 0 0 1 227 0.002s 0.012s 05 0 0 1 222 0.003s 0.012s 06 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 26 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s Day Hour Mean distance Mean estimate Jul 26 00 1,290.83 kB 1,902.33 kB 01 1,415.17 kB 2,088.25 kB 02 1,123.00 kB 1,837.25 kB 03 1,099.42 kB 1,799.42 kB 04 1,204.50 kB 1,814.00 kB 05 1,357.50 kB 1,904.17 kB 06 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 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 - 0 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
- 103,035 Total read queries
- 210,595 Total write queries
Queries by database
Key values
- zabbix Main database
- 313,666 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 313,666 Requests
User Request type Count Duration zabbix Total 313,666 0ms delete 1,735 0ms insert 41,534 0ms others 36 0ms select 103,035 0ms tcl 162,857 0ms update 4,469 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 313,666 0ms delete 1,735 0ms insert 41,534 0ms others 36 0ms select 103,035 0ms tcl 162,857 0ms update 4,469 0ms Queries by host
Key values
- k8smaster01 Main host
- 313,666 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 313,666 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-26 00:37:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 448 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 00 78 0ms 0ms 01 72 0ms 0ms 02 73 0ms 0ms 03 76 0ms 0ms 04 69 0ms 0ms 05 80 0ms 0ms 2 0ms 54 0ms 0ms 0ms select distinct g.graphid, g.name, g.width, g.height, g.yaxismin, g.yaxismax, g.show_work_period, g.show_triggers, g.graphtype, g.show_legend, g.show_3d, g.percent_left, g.percent_right, g.ymin_type, g.ymin_itemid, g.ymax_type, g.ymax_itemid, g.discover from graphs g, graphs_items gi, items i, item_discovery id where g.graphid = gi.graphid and gi.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 3 0ms 6 0ms 0ms 0ms delete from task where status in (...) and clock <= ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 4 0ms 12 0ms 0ms 0ms update trigger_discovery set lastcheck = ? where triggerid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 26 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 5 0ms 5 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 6 0ms 54 0ms 0ms 0ms select hostid, key_, evaltype, formula, lifetime_type, lifetime, enabled_lifetime_type, enabled_lifetime from items where itemid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 7 0ms 6 0ms 0ms 0ms set escape_string_warning to off;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 8 0ms 1,853 0ms 0ms 0ms select groupid, name from hstgrp where type = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 9 0ms 72 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 00 13 0ms 0ms 01 9 0ms 0ms 02 16 0ms 0ms 03 12 0ms 0ms 04 12 0ms 0ms 05 10 0ms 0ms 10 0ms 36 0ms 0ms 0ms select cast(extract(epoch from now()) as int);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 26 00 6 0ms 0ms 01 6 0ms 0ms 02 6 0ms 0ms 03 6 0ms 0ms 04 6 0ms 0ms 05 6 0ms 0ms 11 0ms 361 0ms 0ms 0ms select httpstepid, no, name, url, timeout, posts, required, status_codes, post_type, follow_redirects, retrieve_mode from httpstep where httptestid = ? order by no;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 26 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 1 0ms 0ms 12 0ms 58 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 00 8 0ms 0ms 01 9 0ms 0ms 02 10 0ms 0ms 03 11 0ms 0ms 04 10 0ms 0ms 05 10 0ms 0ms 13 0ms 1 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 14 0ms 1,853 0ms 0ms 0ms select discovery_groupid, snmptrap_logging, severity_name_0, severity_name_1, severity_name_2, severity_name_3, severity_name_4, severity_name_5, hk_events_mode, hk_events_trigger, hk_events_internal, hk_events_discovery, hk_events_autoreg, hk_services_mode, hk_services, hk_audit_mode, hk_audit, hk_sessions_mode, hk_sessions, hk_history_mode, hk_history_global, hk_history, hk_trends_mode, hk_trends_global, hk_trends, default_inventory_mode, db_extension, autoreg_tls_accept, compression_status, compress_older, instanceid, default_timezone, hk_events_service, auditlog_enabled, timeout_zabbix_agent, timeout_simple_check, timeout_snmp_agent, timeout_external_check, timeout_db_monitor, timeout_http_agent, timeout_ssh_agent, timeout_telnet_agent, timeout_script, auditlog_mode, timeout_browser from config order by configid;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 15 0ms 7,202 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 16 0ms 6 0ms 0ms 0ms select p1.eventid from problem p1 where p1.r_clock <> ? and p1.r_clock < ? and not exists ( select null from problem p2 where p1.eventid = p2.cause_eventid) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 17 0ms 4,325 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 18 0ms 18 0ms 0ms 0ms select distinct i.itemid, i.flags from items i, functions f where i.itemid = f.itemid and f.triggerid = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 26 00 3 0ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 19 0ms 54 0ms 0ms 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 20 0ms 54 0ms 0ms 0ms delete from trends_uint where itemid = ? and clock < ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 81,429 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 00 13,558 0ms 0ms 01 13,631 0ms 0ms 02 13,555 0ms 0ms 03 13,533 0ms 0ms 04 13,489 0ms 0ms 05 13,540 0ms 0ms 06 123 0ms 0ms 2 81,426 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 00 13,558 0ms 0ms 01 13,631 0ms 0ms 02 13,555 0ms 0ms 03 13,532 0ms 0ms 04 13,488 0ms 0ms 05 13,540 0ms 0ms 06 122 0ms 0ms 3 12,370 0ms 0ms 0ms 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 00 2,060 0ms 0ms 01 2,067 0ms 0ms 02 2,070 0ms 0ms 03 2,052 0ms 0ms 04 2,055 0ms 0ms 05 2,054 0ms 0ms 06 12 0ms 0ms 4 10,605 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 26 00 1,731 0ms 0ms 01 1,787 0ms 0ms 02 1,726 0ms 0ms 03 1,787 0ms 0ms 04 1,786 0ms 0ms 05 1,772 0ms 0ms 06 16 0ms 0ms 5 7,823 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 00 1,333 0ms 0ms 01 1,307 0ms 0ms 02 1,353 0ms 0ms 03 1,282 0ms 0ms 04 1,257 0ms 0ms 05 1,283 0ms 0ms 06 8 0ms 0ms 6 7,202 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 7 7,202 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 8 7,202 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 9 7,202 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 10 4,325 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 11 4,325 0ms 0ms 0ms 0ms select cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 12 4,325 0ms 0ms 0ms 0ms select ha_nodeid, name, status, lastaccess, address, port, ha_sessionid from ha_node order by ha_nodeid for update;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 13 4,325 0ms 0ms 0ms 0ms update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 14 4,325 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 15 2,728 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 26 00 443 0ms 0ms 01 452 0ms 0ms 02 452 0ms 0ms 03 453 0ms 0ms 04 473 0ms 0ms 05 452 0ms 0ms 06 3 0ms 0ms 16 2,150 0ms 0ms 0ms 0ms select m.mediaid, m.mediatypeid, m.sendto from media m, users_groups u, config c, media_type mt where m.userid = u.userid and u.usrgrpid = c.alert_usrgrpid and m.mediatypeid = mt.mediatypeid and m.active = ? and mt.status = ? and mt.type <> ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 26 00 358 0ms 0ms 01 357 0ms 0ms 02 358 0ms 0ms 03 358 0ms 0ms 04 358 0ms 0ms 05 358 0ms 0ms 06 3 0ms 0ms 17 1,853 0ms 0ms 0ms 0ms select groupid, name from hstgrp where type = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 18 1,853 0ms 0ms 0ms 0ms select discovery_groupid, snmptrap_logging, severity_name_0, severity_name_1, severity_name_2, severity_name_3, severity_name_4, severity_name_5, hk_events_mode, hk_events_trigger, hk_events_internal, hk_events_discovery, hk_events_autoreg, hk_services_mode, hk_services, hk_audit_mode, hk_audit, hk_sessions_mode, hk_sessions, hk_history_mode, hk_history_global, hk_history, hk_trends_mode, hk_trends_global, hk_trends, default_inventory_mode, db_extension, autoreg_tls_accept, compression_status, compress_older, instanceid, default_timezone, hk_events_service, auditlog_enabled, timeout_zabbix_agent, timeout_simple_check, timeout_snmp_agent, timeout_external_check, timeout_db_monitor, timeout_http_agent, timeout_ssh_agent, timeout_telnet_agent, timeout_script, auditlog_mode, timeout_browser from config order by configid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 19 1,853 0ms 0ms 0ms 0ms select c.conditionid, c.actionid, c.conditiontype, c.operator, c.value, c.value2 from conditions c, actions a where c.actionid = a.actionid and a.status = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 20 1,853 0ms 0ms 0ms 0ms select co.corr_operationid, co.correlationid, co.type from correlation c, corr_operation co where c.correlationid = co.correlationid and c.status = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 448 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 26 00 78 0ms 0ms 01 72 0ms 0ms 02 73 0ms 0ms 03 76 0ms 0ms 04 69 0ms 0ms 05 80 0ms 0ms 2 0ms 0ms 0ms 54 0ms select distinct g.graphid, g.name, g.width, g.height, g.yaxismin, g.yaxismax, g.show_work_period, g.show_triggers, g.graphtype, g.show_legend, g.show_3d, g.percent_left, g.percent_right, g.ymin_type, g.ymin_itemid, g.ymax_type, g.ymax_itemid, g.discover from graphs g, graphs_items gi, items i, item_discovery id where g.graphid = gi.graphid and gi.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 3 0ms 0ms 0ms 6 0ms delete from task where status in (...) and clock <= ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 4 0ms 0ms 0ms 12 0ms update trigger_discovery set lastcheck = ? where triggerid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 26 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 5 0ms 0ms 0ms 5 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 6 0ms 0ms 0ms 54 0ms select hostid, key_, evaltype, formula, lifetime_type, lifetime, enabled_lifetime_type, enabled_lifetime from items where itemid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 7 0ms 0ms 0ms 6 0ms set escape_string_warning to off;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 8 0ms 0ms 0ms 1,853 0ms select groupid, name from hstgrp where type = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 9 0ms 0ms 0ms 72 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 26 00 13 0ms 0ms 01 9 0ms 0ms 02 16 0ms 0ms 03 12 0ms 0ms 04 12 0ms 0ms 05 10 0ms 0ms 10 0ms 0ms 0ms 36 0ms select cast(extract(epoch from now()) as int);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 26 00 6 0ms 0ms 01 6 0ms 0ms 02 6 0ms 0ms 03 6 0ms 0ms 04 6 0ms 0ms 05 6 0ms 0ms 11 0ms 0ms 0ms 361 0ms select httpstepid, no, name, url, timeout, posts, required, status_codes, post_type, follow_redirects, retrieve_mode from httpstep where httptestid = ? order by no;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 26 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 1 0ms 0ms 12 0ms 0ms 0ms 58 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 26 00 8 0ms 0ms 01 9 0ms 0ms 02 10 0ms 0ms 03 11 0ms 0ms 04 10 0ms 0ms 05 10 0ms 0ms 13 0ms 0ms 0ms 1 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 14 0ms 0ms 0ms 1,853 0ms select discovery_groupid, snmptrap_logging, severity_name_0, severity_name_1, severity_name_2, severity_name_3, severity_name_4, severity_name_5, hk_events_mode, hk_events_trigger, hk_events_internal, hk_events_discovery, hk_events_autoreg, hk_services_mode, hk_services, hk_audit_mode, hk_audit, hk_sessions_mode, hk_sessions, hk_history_mode, hk_history_global, hk_history, hk_trends_mode, hk_trends_global, hk_trends, default_inventory_mode, db_extension, autoreg_tls_accept, compression_status, compress_older, instanceid, default_timezone, hk_events_service, auditlog_enabled, timeout_zabbix_agent, timeout_simple_check, timeout_snmp_agent, timeout_external_check, timeout_db_monitor, timeout_http_agent, timeout_ssh_agent, timeout_telnet_agent, timeout_script, auditlog_mode, timeout_browser from config order by configid;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 309 0ms 0ms 06 2 0ms 0ms 15 0ms 0ms 0ms 7,202 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 26 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 8 0ms 0ms 16 0ms 0ms 0ms 6 0ms select p1.eventid from problem p1 where p1.r_clock <> ? and p1.r_clock < ? and not exists ( select null from problem p2 where p1.eventid = p2.cause_eventid) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 26 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 17 0ms 0ms 0ms 4,325 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 5 0ms 0ms 18 0ms 0ms 0ms 18 0ms select distinct i.itemid, i.flags from items i, functions f where i.itemid = f.itemid and f.triggerid = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 26 00 3 0ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 19 0ms 0ms 0ms 54 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 20 0ms 0ms 0ms 54 0ms delete from trends_uint where itemid = ? and clock < ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 26 00 9 0ms 0ms 01 9 0ms 0ms 02 9 0ms 0ms 03 9 0ms 0ms 04 9 0ms 0ms 05 9 0ms 0ms 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 1 0ms 4,465 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 26 00 733 0ms 0ms 01 724 0ms 0ms 02 747 0ms 0ms 03 749 0ms 0ms 04 764 0ms 0ms 05 739 0ms 0ms 06 9 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 662,347 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6 Max number of times the same event was reported
- 12 Total events found
Rank Times reported Error 1 6 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 26 00 2 01 1 03 2 04 1 - FATAL: no pg_hba.conf entry for host "195.184.76.122", user "test", database "test", no encryption
Detail: Client IP address resolved to "walton.probe.onyphe.net", forward lookup not checked.
Date: 2025-07-26 00:30:25 Database: test Application: [unknown] User: test Remote: walton.probe.onyphe.net
2 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 26 05 2 3 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 26 05 2 4 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 26 05 2