pgBadger-
Global information
- Generated on Tue Jun 24 23:01:16 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-24.log
- Parsed 4,460,184 log entries in 1m15s
- Log start from 2025-06-24 00:00:00 to 2025-06-24 23:01:14
-
Overview
Global Stats
- 803 Number of unique normalized queries
- 1,016,779 Number of queries
- 0ms Total query duration
- 2025-06-24 00:00:00 First query
- 2025-06-24 23:01:14 Last query
- 186 queries/s at 2025-06-24 20:44:36 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 11 Number of events
- 6 Number of unique normalized events
- 3 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
- 920 Total number of sessions
- 7 sessions at 2025-06-24 20:29:32 Session peak
- 28m18s Total duration of sessions
- 1s845ms Average duration of sessions
- 1,105 Average queries per session
- 0ms Average queries duration per session
- 1s845ms Average idle time per session
- 920 Total number of connections
- 7 connections/s at 2025-06-24 21:55:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 186 queries/s Query Peak
- 2025-06-24 20:44:36 Date
SELECT Traffic
Key values
- 123 queries/s Query Peak
- 2025-06-24 20:44:36 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 68 queries/s Query Peak
- 2025-06-24 21:55:22 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) Jun 24 00 41,637 0ms 0ms 0ms 0ms 0ms 0ms 01 41,620 0ms 0ms 0ms 0ms 0ms 0ms 02 41,649 0ms 0ms 0ms 0ms 0ms 0ms 03 41,610 0ms 0ms 0ms 0ms 0ms 0ms 04 41,588 0ms 0ms 0ms 0ms 0ms 0ms 05 41,686 0ms 0ms 0ms 0ms 0ms 0ms 06 41,728 0ms 0ms 0ms 0ms 0ms 0ms 07 41,638 0ms 0ms 0ms 0ms 0ms 0ms 08 41,669 0ms 0ms 0ms 0ms 0ms 0ms 09 44,666 0ms 0ms 0ms 0ms 0ms 0ms 10 42,253 0ms 0ms 0ms 0ms 0ms 0ms 11 41,671 0ms 0ms 0ms 0ms 0ms 0ms 12 41,526 0ms 0ms 0ms 0ms 0ms 0ms 13 41,761 0ms 0ms 0ms 0ms 0ms 0ms 14 41,611 0ms 0ms 0ms 0ms 0ms 0ms 15 41,545 0ms 0ms 0ms 0ms 0ms 0ms 16 41,605 0ms 0ms 0ms 0ms 0ms 0ms 17 41,647 0ms 0ms 0ms 0ms 0ms 0ms 18 41,656 0ms 0ms 0ms 0ms 0ms 0ms 19 41,769 0ms 0ms 0ms 0ms 0ms 0ms 20 62,417 0ms 0ms 0ms 0ms 0ms 0ms 21 58,515 0ms 0ms 0ms 0ms 0ms 0ms 22 57,944 0ms 0ms 0ms 0ms 0ms 0ms 23 1,368 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 24 00 16,677 0 0ms 0ms 0ms 0ms 01 16,627 0 0ms 0ms 0ms 0ms 02 16,611 0 0ms 0ms 0ms 0ms 03 16,641 0 0ms 0ms 0ms 0ms 04 16,651 0 0ms 0ms 0ms 0ms 05 16,603 0 0ms 0ms 0ms 0ms 06 16,635 0 0ms 0ms 0ms 0ms 07 16,614 0 0ms 0ms 0ms 0ms 08 16,662 0 0ms 0ms 0ms 0ms 09 18,575 0 0ms 0ms 0ms 0ms 10 17,065 0 0ms 0ms 0ms 0ms 11 16,643 0 0ms 0ms 0ms 0ms 12 16,585 0 0ms 0ms 0ms 0ms 13 16,660 0 0ms 0ms 0ms 0ms 14 16,607 0 0ms 0ms 0ms 0ms 15 16,618 0 0ms 0ms 0ms 0ms 16 16,602 0 0ms 0ms 0ms 0ms 17 16,664 0 0ms 0ms 0ms 0ms 18 16,605 0 0ms 0ms 0ms 0ms 19 16,697 0 0ms 0ms 0ms 0ms 20 27,977 0 0ms 0ms 0ms 0ms 21 21,534 0 0ms 0ms 0ms 0ms 22 21,284 0 0ms 0ms 0ms 0ms 23 359 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 24 00 4,673 733 81 0 0ms 0ms 0ms 0ms 01 4,682 732 81 0 0ms 0ms 0ms 0ms 02 4,686 732 81 0 0ms 0ms 0ms 0ms 03 4,668 732 81 0 0ms 0ms 0ms 0ms 04 4,664 732 81 0 0ms 0ms 0ms 0ms 05 4,694 732 81 0 0ms 0ms 0ms 0ms 06 4,691 732 81 0 0ms 0ms 0ms 0ms 07 4,686 732 81 0 0ms 0ms 0ms 0ms 08 4,679 732 81 0 0ms 0ms 0ms 0ms 09 4,691 785 83 0 0ms 0ms 0ms 0ms 10 4,666 744 81 0 0ms 0ms 0ms 0ms 11 4,685 735 81 0 0ms 0ms 0ms 0ms 12 4,673 732 81 0 0ms 0ms 0ms 0ms 13 4,692 736 81 0 0ms 0ms 0ms 0ms 14 4,680 732 81 0 0ms 0ms 0ms 0ms 15 4,669 732 81 0 0ms 0ms 0ms 0ms 16 4,683 732 81 0 0ms 0ms 0ms 0ms 17 4,672 736 81 0 0ms 0ms 0ms 0ms 18 4,688 732 80 0 0ms 0ms 0ms 0ms 19 4,688 735 81 0 0ms 0ms 0ms 0ms 20 5,556 1,022 118 0 0ms 0ms 0ms 0ms 21 6,791 832 100 0 0ms 0ms 0ms 0ms 22 6,778 804 88 0 0ms 0ms 0ms 0ms 23 243 15 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 24 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% 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% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 24 00 1 0.00/s 01 2 0.00/s 02 1 0.00/s 03 3 0.00/s 04 3 0.00/s 05 2 0.00/s 06 1 0.00/s 07 1 0.00/s 08 5 0.00/s 09 70 0.02/s 10 19 0.01/s 11 3 0.00/s 12 1 0.00/s 13 2 0.00/s 14 1 0.00/s 15 1 0.00/s 16 1 0.00/s 17 2 0.00/s 18 1 0.00/s 19 4 0.00/s 20 430 0.12/s 21 193 0.05/s 22 173 0.05/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 24 00 1 1s370ms 1s370ms 01 2 1s124ms 1s124ms 02 1 1s189ms 1s189ms 03 3 1s62ms 1s62ms 04 3 1s75ms 1s75ms 05 2 1s126ms 1s126ms 06 1 1s437ms 1s437ms 07 1 1s411ms 1s411ms 08 5 1s137ms 1s137ms 09 70 2s36ms 2s36ms 10 19 1s803ms 1s803ms 11 3 1s79ms 1s79ms 12 1 1s268ms 1s268ms 13 2 1s136ms 1s136ms 14 1 1s397ms 1s397ms 15 1 1s327ms 1s327ms 16 1 1s336ms 1s336ms 17 2 1s178ms 1s178ms 18 1 1s285ms 1s285ms 19 4 1s830ms 1s830ms 20 430 1s838ms 1s838ms 21 191 1s847ms 1s847ms 22 175 1s907ms 1s907ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2025-06-24 21:55:20 Date
Connections per database
Key values
- zabbix Main Database
- 920 connections Total
Connections per user
Key values
- zabbix Main User
- 920 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2025-06-24 20:29:32 Date
Histogram of session times
Key values
- 912 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 920 sessions Total
Sessions per user
Key values
- zabbix Main User
- 920 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 920 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 423 buffers Checkpoint Peak
- 2025-06-24 20:42:11 Date
- 42.259 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-24 22:26:50 Date
Checkpoints distance
Key values
- 4.72 Mo Distance Peak
- 2025-06-24 20:42:11 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 24 00 935 92.244s 0.024s 92.306s 01 1,312 129.895s 0.025s 129.95s 02 1,647 163.539s 0.024s 163.593s 03 1,678 166.545s 0.026s 166.601s 04 1,778 176.656s 0.025s 176.715s 05 1,717 170.346s 0.031s 170.408s 06 1,722 171.044s 0.027s 171.103s 07 1,733 172.046s 0.025s 172.103s 08 1,799 178.762s 0.027s 178.82s 09 1,867 185.467s 0.035s 185.534s 10 1,712 170.048s 0.025s 170.105s 11 1,762 175.052s 0.025s 175.111s 12 1,844 183.063s 0.027s 183.121s 13 1,697 168.543s 0.03s 168.606s 14 1,795 178.256s 0.026s 178.313s 15 1,855 184.369s 0.024s 184.425s 16 1,623 161.038s 0.025s 161.096s 17 1,900 188.873s 0.028s 188.931s 18 1,664 165.043s 0.026s 165.099s 19 1,949 193.79s 0.03s 193.853s 20 2,158 214.609s 0.035s 214.675s 21 2,123 211.098s 0.029s 211.162s 22 2,230 221.713s 0.032s 221.779s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 24 00 0 1 0 233 0.002s 0.012s 01 0 0 0 213 0.002s 0.012s 02 0 0 1 206 0.002s 0.012s 03 0 0 0 199 0.002s 0.012s 04 0 0 1 202 0.002s 0.012s 05 0 0 0 190 0.002s 0.012s 06 0 0 1 205 0.002s 0.012s 07 0 0 1 195 0.002s 0.012s 08 0 0 0 204 0.002s 0.012s 09 0 0 1 225 0.002s 0.012s 10 0 0 0 208 0.002s 0.012s 11 0 0 1 221 0.002s 0.012s 12 0 0 0 206 0.002s 0.012s 13 0 0 1 195 0.002s 0.012s 14 0 0 0 201 0.002s 0.012s 15 0 0 1 217 0.002s 0.012s 16 0 0 0 198 0.002s 0.012s 17 0 0 1 195 0.002s 0.012s 18 0 0 0 189 0.002s 0.012s 19 0 0 1 256 0.002s 0.012s 20 0 0 0 475 0.002s 0.012s 21 0 0 1 243 0.002s 0.012s 22 0 0 1 254 0.002s 0.012s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 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 23 0 0s Day Hour Mean distance Mean estimate Jun 24 00 425.17 kB 9,931.67 kB 01 577.25 kB 3,181.00 kB 02 729.08 kB 1,384.83 kB 03 866.50 kB 980.50 kB 04 762.58 kB 920.33 kB 05 641.17 kB 727.42 kB 06 731.58 kB 754.92 kB 07 791.08 kB 839.67 kB 08 838.67 kB 994.42 kB 09 652.08 kB 865.67 kB 10 657.08 kB 716.92 kB 11 747.58 kB 775.50 kB 12 886.08 kB 894.00 kB 13 657.75 kB 1,002.83 kB 14 617.92 kB 733.42 kB 15 688.83 kB 724.67 kB 16 777.08 kB 815.83 kB 17 778.00 kB 969.92 kB 18 585.83 kB 739.75 kB 19 667.25 kB 684.25 kB 20 944.75 kB 1,282.25 kB 21 976.42 kB 1,537.92 kB 22 850.08 kB 1,074.75 kB 23 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 Jun 24 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 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 23 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 Jun 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 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
- 406,196 Total read queries
- 607,777 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,016,779 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,016,779 Requests
User Request type Count Duration zabbix Total 1,016,779 0ms delete 1,929 0ms insert 112,978 0ms others 2,806 0ms select 406,196 0ms tcl 475,477 0ms update 17,393 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,016,779 0ms delete 1,929 0ms insert 112,978 0ms others 2,806 0ms select 406,196 0ms tcl 475,477 0ms update 17,393 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,016,779 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,016,779 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-24 18:30:44 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 2 0ms 0ms 0ms select a.actionid, a.name, a.eventsource from actions a where a.actionid in (...) order by a.name;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 21 2 0ms 0ms 2 0ms 1 0ms 0ms 0ms select g.groupid, g.name from hstgrp g where g.type = ? and exists ( select null from hosts h, hosts_groups hg where hg.hostid = h.hostid and h.status in (...) and g.groupid = hg.groupid);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 3 0ms 4 0ms 0ms 0ms select h.hostid, h.name, h.maintenance_status, h.maintenance_type, h.maintenanceid from hosts h where h.flags in (...) and h.hostid = ? and h.status = ? and h.maintenance_status = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 09 1 0ms 0ms 10 1 0ms 0ms 20 2 0ms 0ms 4 0ms 8,244 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 #4
Day Hour Count Duration Avg duration Jun 24 00 358 0ms 0ms 01 358 0ms 0ms 02 358 0ms 0ms 03 358 0ms 0ms 04 358 0ms 0ms 05 359 0ms 0ms 06 358 0ms 0ms 07 358 0ms 0ms 08 358 0ms 0ms 09 358 0ms 0ms 10 358 0ms 0ms 11 358 0ms 0ms 12 358 0ms 0ms 13 358 0ms 0ms 14 359 0ms 0ms 15 358 0ms 0ms 16 358 0ms 0ms 17 358 0ms 0ms 18 358 0ms 0ms 19 358 0ms 0ms 20 358 0ms 0ms 21 359 0ms 0ms 22 358 0ms 0ms 23 7 0ms 0ms 5 0ms 1 0ms 0ms 0ms select t.dashboard_pageid, t.dashboardid, t.sortorder from dashboard_page t where t.dashboardid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 6 0ms 1 0ms 0ms 0ms select distinct f.triggerid, td.triggerid_up from items i, functions f, trigger_depends td where i.itemid = f.itemid and f.triggerid = td.triggerid_down and i.hostid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 7 0ms 27 0ms 0ms 0ms select count(*) as rowscount, a.eventid from alerts a where exists ( select null from actions aa where a.actionid = aa.actionid and aa.eventsource = ?) and a.status in (...) and a.eventid = ? group by a.eventid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 24 20 13 0ms 0ms 21 6 0ms 0ms 22 8 0ms 0ms 8 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750730025) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750730025) / ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 24 21 1 0ms 0ms 9 0ms 10 0ms 0ms 0ms select h.hostid from hosts h where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 20 8 0ms 0ms 21 2 0ms 0ms 10 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750765408) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750765408) / ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 11 0ms 2 0ms 0ms 0ms select h.hostid, h.host, h.name from hosts h where h.flags in (...) and h.status in (...) and (h.host = ? or h.name = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 20 2 0ms 0ms 12 0ms 6 0ms 0ms 0ms select gitemid, graphid, itemid, drawtype, sortorder, color, yaxisside, calc_fnc, type from graphs_items where graphid = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 24 20 6 0ms 0ms 13 0ms 4 0ms 0ms 0ms select clock, ns, value from history where itemid = ? and clock > ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 24 20 4 0ms 0ms 14 0ms 7 0ms 0ms 0ms select t.triggerid, t.priority, t.manual_close, t.expression, t.comments from triggers t where t.triggerid = ? and not exists ( select null from functions f, items i, hosts h where t.triggerid = f.triggerid and f.itemid = i.itemid and i.hostid = h.hostid and (i.status <> ? or h.status <> ?)) and t.status = ? and t.flags in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 24 20 5 0ms 0ms 22 2 0ms 0ms 15 0ms 1 0ms 0ms 0ms select t.interfaceid, t.hostid from interface t where t.interfaceid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 16 0ms 24 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 17 0ms 2 0ms 0ms 0ms select count(*) as rowscount from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 20 2 0ms 0ms 18 0ms 881 0ms 0ms 0ms select g.usrgrpid, g.debug_mode, g.users_status, g.gui_access, g.userdirectoryid, g.mfa_status, g.mfaid from users_groups ug, usrgrp g where ug.usrgrpid = g.usrgrpid and ug.userid = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 09 68 0ms 0ms 10 17 0ms 0ms 19 3 0ms 0ms 20 429 0ms 0ms 21 191 0ms 0ms 22 173 0ms 0ms 19 0ms 2 0ms 0ms 0ms select e.eventid, i.hostid from events e, functions f, items i where e.eventid = ? and e.objectid = f.triggerid and f.itemid = i.itemid and e.object = ? and e.source = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 21 1 0ms 0ms 20 0ms 1 0ms 0ms 0ms select distinct h.hostid from hosts h, host_discovery hd, items i, hosts ph where ? = ? and h.flags = ? and h.hostid = hd.hostid and hd.parent_itemid = i.itemid and i.hostid = ph.hostid and ph.flags = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 21 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 237,739 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 00 9,734 0ms 0ms 01 9,745 0ms 0ms 02 9,767 0ms 0ms 03 9,739 0ms 0ms 04 9,724 0ms 0ms 05 9,784 0ms 0ms 06 9,792 0ms 0ms 07 9,760 0ms 0ms 08 9,749 0ms 0ms 09 10,160 0ms 0ms 10 9,819 0ms 0ms 11 9,758 0ms 0ms 12 9,725 0ms 0ms 13 9,792 0ms 0ms 14 9,753 0ms 0ms 15 9,720 0ms 0ms 16 9,751 0ms 0ms 17 9,743 0ms 0ms 18 9,773 0ms 0ms 19 9,777 0ms 0ms 20 13,226 0ms 0ms 21 14,340 0ms 0ms 22 14,233 0ms 0ms 23 375 0ms 0ms 2 236,869 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 00 9,734 0ms 0ms 01 9,744 0ms 0ms 02 9,767 0ms 0ms 03 9,736 0ms 0ms 04 9,723 0ms 0ms 05 9,783 0ms 0ms 06 9,792 0ms 0ms 07 9,760 0ms 0ms 08 9,745 0ms 0ms 09 10,095 0ms 0ms 10 9,801 0ms 0ms 11 9,756 0ms 0ms 12 9,725 0ms 0ms 13 9,791 0ms 0ms 14 9,753 0ms 0ms 15 9,720 0ms 0ms 16 9,751 0ms 0ms 17 9,742 0ms 0ms 18 9,773 0ms 0ms 19 9,774 0ms 0ms 20 12,806 0ms 0ms 21 14,163 0ms 0ms 22 14,061 0ms 0ms 23 374 0ms 0ms 3 33,203 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 00 1,410 0ms 0ms 01 1,431 0ms 0ms 02 1,417 0ms 0ms 03 1,346 0ms 0ms 04 1,370 0ms 0ms 05 1,452 0ms 0ms 06 1,406 0ms 0ms 07 1,394 0ms 0ms 08 1,438 0ms 0ms 09 1,395 0ms 0ms 10 1,345 0ms 0ms 11 1,375 0ms 0ms 12 1,400 0ms 0ms 13 1,372 0ms 0ms 14 1,426 0ms 0ms 15 1,412 0ms 0ms 16 1,407 0ms 0ms 17 1,363 0ms 0ms 18 1,375 0ms 0ms 19 1,425 0ms 0ms 20 1,502 0ms 0ms 21 1,857 0ms 0ms 22 1,846 0ms 0ms 23 39 0ms 0ms 4 30,686 0ms 0ms 0ms 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 24 00 1,245 0ms 0ms 01 1,245 0ms 0ms 02 1,233 0ms 0ms 03 1,253 0ms 0ms 04 1,249 0ms 0ms 05 1,245 0ms 0ms 06 1,251 0ms 0ms 07 1,251 0ms 0ms 08 1,249 0ms 0ms 09 1,245 0ms 0ms 10 1,257 0ms 0ms 11 1,250 0ms 0ms 12 1,249 0ms 0ms 13 1,251 0ms 0ms 14 1,247 0ms 0ms 15 1,251 0ms 0ms 16 1,249 0ms 0ms 17 1,251 0ms 0ms 18 1,251 0ms 0ms 19 1,246 0ms 0ms 20 1,547 0ms 0ms 21 2,066 0ms 0ms 22 2,065 0ms 0ms 23 40 0ms 0ms 5 27,607 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 #5
Day Hour Count Duration Avg duration Jun 24 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,200 0ms 0ms 07 1,199 0ms 0ms 08 1,200 0ms 0ms 09 1,200 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,200 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 24 0ms 0ms 6 27,607 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 #6
Day Hour Count Duration Avg duration Jun 24 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,200 0ms 0ms 07 1,199 0ms 0ms 08 1,200 0ms 0ms 09 1,200 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,200 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 24 0ms 0ms 7 27,607 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 Jun 24 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,200 0ms 0ms 07 1,199 0ms 0ms 08 1,200 0ms 0ms 09 1,200 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,200 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 24 0ms 0ms 8 27,606 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 #8
Day Hour Count Duration Avg duration Jun 24 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,200 0ms 0ms 07 1,199 0ms 0ms 08 1,200 0ms 0ms 09 1,200 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,200 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 24 0ms 0ms 9 20,312 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 00 813 0ms 0ms 01 823 0ms 0ms 02 860 0ms 0ms 03 869 0ms 0ms 04 846 0ms 0ms 05 826 0ms 0ms 06 850 0ms 0ms 07 851 0ms 0ms 08 797 0ms 0ms 09 858 0ms 0ms 10 871 0ms 0ms 11 876 0ms 0ms 12 827 0ms 0ms 13 885 0ms 0ms 14 824 0ms 0ms 15 804 0ms 0ms 16 844 0ms 0ms 17 859 0ms 0ms 18 881 0ms 0ms 19 830 0ms 0ms 20 1,006 0ms 0ms 21 1,188 0ms 0ms 22 1,194 0ms 0ms 23 30 0ms 0ms 10 16,575 0ms 0ms 0ms 0ms select cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 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 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 15 0ms 0ms 11 16,575 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 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 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 15 0ms 0ms 12 16,575 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 Jun 24 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 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 15 0ms 0ms 13 16,575 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 Jun 24 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 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 15 0ms 0ms 14 16,575 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 Jun 24 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 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 15 0ms 0ms 15 8,244 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 #15
Day Hour Count Duration Avg duration Jun 24 00 358 0ms 0ms 01 358 0ms 0ms 02 358 0ms 0ms 03 358 0ms 0ms 04 358 0ms 0ms 05 359 0ms 0ms 06 358 0ms 0ms 07 358 0ms 0ms 08 358 0ms 0ms 09 358 0ms 0ms 10 358 0ms 0ms 11 358 0ms 0ms 12 358 0ms 0ms 13 358 0ms 0ms 14 359 0ms 0ms 15 358 0ms 0ms 16 358 0ms 0ms 17 358 0ms 0ms 18 358 0ms 0ms 19 358 0ms 0ms 20 358 0ms 0ms 21 359 0ms 0ms 22 358 0ms 0ms 23 7 0ms 0ms 16 7,137 0ms 0ms 0ms 0ms select maintenancetagid, maintenanceid, operator, tag, value from maintenance_tag;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 00 310 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 311 0ms 0ms 05 309 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 311 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 310 0ms 0ms 21 309 0ms 0ms 22 310 0ms 0ms 23 7 0ms 0ms 17 7,137 0ms 0ms 0ms 0ms select maintenanceid, groupid from maintenances_groups order by maintenanceid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 00 310 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 311 0ms 0ms 05 309 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 311 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 310 0ms 0ms 21 309 0ms 0ms 22 310 0ms 0ms 23 7 0ms 0ms 18 7,137 0ms 0ms 0ms 0ms select correlationid, name, evaltype, formula from correlation where status = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 00 310 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 311 0ms 0ms 05 309 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 311 0ms 0ms 11 310 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 310 0ms 0ms 21 309 0ms 0ms 22 310 0ms 0ms 23 7 0ms 0ms 19 7,137 0ms 0ms 0ms 0ms select actionid, eventsource, evaltype, formula from actions where eventsource <> ? and status = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 00 310 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 311 0ms 0ms 05 309 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 311 0ms 0ms 11 310 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 310 0ms 0ms 21 309 0ms 0ms 22 310 0ms 0ms 23 7 0ms 0ms 20 7,137 0ms 0ms 0ms 0ms select tls_psk_identity, tls_psk from config_autoreg_tls order by autoreg_tlsid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 00 310 0ms 0ms 01 310 0ms 0ms 02 311 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 309 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 311 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 310 0ms 0ms 21 309 0ms 0ms 22 310 0ms 0ms 23 7 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 2 0ms select a.actionid, a.name, a.eventsource from actions a where a.actionid in (...) order by a.name;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 21 2 0ms 0ms 2 0ms 0ms 0ms 1 0ms select g.groupid, g.name from hstgrp g where g.type = ? and exists ( select null from hosts h, hosts_groups hg where hg.hostid = h.hostid and h.status in (...) and g.groupid = hg.groupid);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 3 0ms 0ms 0ms 4 0ms select h.hostid, h.name, h.maintenance_status, h.maintenance_type, h.maintenanceid from hosts h where h.flags in (...) and h.hostid = ? and h.status = ? and h.maintenance_status = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 09 1 0ms 0ms 10 1 0ms 0ms 20 2 0ms 0ms 4 0ms 0ms 0ms 8,244 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 #4
Day Hour Count Duration Avg duration Jun 24 00 358 0ms 0ms 01 358 0ms 0ms 02 358 0ms 0ms 03 358 0ms 0ms 04 358 0ms 0ms 05 359 0ms 0ms 06 358 0ms 0ms 07 358 0ms 0ms 08 358 0ms 0ms 09 358 0ms 0ms 10 358 0ms 0ms 11 358 0ms 0ms 12 358 0ms 0ms 13 358 0ms 0ms 14 359 0ms 0ms 15 358 0ms 0ms 16 358 0ms 0ms 17 358 0ms 0ms 18 358 0ms 0ms 19 358 0ms 0ms 20 358 0ms 0ms 21 359 0ms 0ms 22 358 0ms 0ms 23 7 0ms 0ms 5 0ms 0ms 0ms 1 0ms select t.dashboard_pageid, t.dashboardid, t.sortorder from dashboard_page t where t.dashboardid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 6 0ms 0ms 0ms 1 0ms select distinct f.triggerid, td.triggerid_up from items i, functions f, trigger_depends td where i.itemid = f.itemid and f.triggerid = td.triggerid_down and i.hostid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 7 0ms 0ms 0ms 27 0ms select count(*) as rowscount, a.eventid from alerts a where exists ( select null from actions aa where a.actionid = aa.actionid and aa.eventsource = ?) and a.status in (...) and a.eventid = ? group by a.eventid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 24 20 13 0ms 0ms 21 6 0ms 0ms 22 8 0ms 0ms 8 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750730025) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750730025) / ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 24 21 1 0ms 0ms 9 0ms 0ms 0ms 10 0ms select h.hostid from hosts h where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 20 8 0ms 0ms 21 2 0ms 0ms 10 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750765408) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750765408) / ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 11 0ms 0ms 0ms 2 0ms select h.hostid, h.host, h.name from hosts h where h.flags in (...) and h.status in (...) and (h.host = ? or h.name = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 20 2 0ms 0ms 12 0ms 0ms 0ms 6 0ms select gitemid, graphid, itemid, drawtype, sortorder, color, yaxisside, calc_fnc, type from graphs_items where graphid = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 24 20 6 0ms 0ms 13 0ms 0ms 0ms 4 0ms select clock, ns, value from history where itemid = ? and clock > ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 24 20 4 0ms 0ms 14 0ms 0ms 0ms 7 0ms select t.triggerid, t.priority, t.manual_close, t.expression, t.comments from triggers t where t.triggerid = ? and not exists ( select null from functions f, items i, hosts h where t.triggerid = f.triggerid and f.itemid = i.itemid and i.hostid = h.hostid and (i.status <> ? or h.status <> ?)) and t.status = ? and t.flags in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 24 20 5 0ms 0ms 22 2 0ms 0ms 15 0ms 0ms 0ms 1 0ms select t.interfaceid, t.hostid from interface t where t.interfaceid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 16 0ms 0ms 0ms 24 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 17 0ms 0ms 0ms 2 0ms select count(*) as rowscount from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 20 2 0ms 0ms 18 0ms 0ms 0ms 881 0ms select g.usrgrpid, g.debug_mode, g.users_status, g.gui_access, g.userdirectoryid, g.mfa_status, g.mfaid from users_groups ug, usrgrp g where ug.usrgrpid = g.usrgrpid and ug.userid = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 09 68 0ms 0ms 10 17 0ms 0ms 19 3 0ms 0ms 20 429 0ms 0ms 21 191 0ms 0ms 22 173 0ms 0ms 19 0ms 0ms 0ms 2 0ms select e.eventid, i.hostid from events e, functions f, items i where e.eventid = ? and e.objectid = f.triggerid and f.itemid = i.itemid and e.object = ? and e.source = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 20 1 0ms 0ms 21 1 0ms 0ms 20 0ms 0ms 0ms 1 0ms select distinct h.hostid from hosts h, host_discovery hd, items i, hosts ph where ? = ? and h.flags = ? and h.hostid = hd.hostid and hd.parent_itemid = i.itemid and i.hostid = ph.hostid and ph.flags = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 21 1 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 10,505 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 24 00 420 0ms 0ms 01 429 0ms 0ms 02 418 0ms 0ms 03 420 0ms 0ms 04 426 0ms 0ms 05 419 0ms 0ms 06 414 0ms 0ms 07 422 0ms 0ms 08 423 0ms 0ms 09 423 0ms 0ms 10 421 0ms 0ms 11 429 0ms 0ms 12 426 0ms 0ms 13 420 0ms 0ms 14 422 0ms 0ms 15 427 0ms 0ms 16 424 0ms 0ms 17 422 0ms 0ms 18 420 0ms 0ms 19 429 0ms 0ms 20 600 0ms 0ms 21 705 0ms 0ms 22 725 0ms 0ms 23 21 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,171,522 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 10 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 11 Total events found
Rank Times reported Error 1 3 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 24 00 1 02 1 22 1 2 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 24 02 1 22 1 3 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 24 02 1 22 1 4 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 24 18 1 19 1 - FATAL: no pg_hba.conf entry for host "35.187.8.174", user "postgres", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "5.188.230.157", user "root", database "postgres", no encryption
Detail: Client IP address resolved to "174.8.187.35.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-06-24 18:39:58 Database: postgres Application: [unknown] User: postgres Remote: 174.8.187.35.bc.googleusercontent.com
Detail: Client IP address resolved to "free.ds", forward lookup not checked.
Date: 2025-06-24 19:29:46 Database: postgres Application: [unknown] User: root Remote: free.ds
5 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 24 07 1 6 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 24 20 1