pgBadger-
Global information
- Generated on Thu Jun 26 23:01:38 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-26.log
- Parsed 5,595,853 log entries in 1m37s
- Log start from 2025-06-26 00:00:00 to 2025-06-26 23:01:35
-
Overview
Global Stats
- 833 Number of unique normalized queries
- 1,282,269 Number of queries
- 0ms Total query duration
- 2025-06-26 00:00:00 First query
- 2025-06-26 23:01:35 Last query
- 180 queries/s at 2025-06-26 13:44:37 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 17 Number of events
- 5 Number of unique normalized events
- 4 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
- 2,720 Total number of sessions
- 9 sessions at 2025-06-26 22:15:57 Session peak
- 1h23m42s Total duration of sessions
- 1s846ms Average duration of sessions
- 471 Average queries per session
- 0ms Average queries duration per session
- 1s846ms Average idle time per session
- 2,720 Total number of connections
- 6 connections/s at 2025-06-26 21:03:45 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 180 queries/s Query Peak
- 2025-06-26 13:44:37 Date
SELECT Traffic
Key values
- 112 queries/s Query Peak
- 2025-06-26 13:44:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 77 queries/s Query Peak
- 2025-06-26 13:58:52 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 26 00 51,162 0ms 0ms 0ms 0ms 0ms 0ms 01 51,158 0ms 0ms 0ms 0ms 0ms 0ms 02 51,105 0ms 0ms 0ms 0ms 0ms 0ms 03 51,106 0ms 0ms 0ms 0ms 0ms 0ms 04 51,068 0ms 0ms 0ms 0ms 0ms 0ms 05 51,160 0ms 0ms 0ms 0ms 0ms 0ms 06 51,123 0ms 0ms 0ms 0ms 0ms 0ms 07 51,046 0ms 0ms 0ms 0ms 0ms 0ms 08 51,188 0ms 0ms 0ms 0ms 0ms 0ms 09 51,132 0ms 0ms 0ms 0ms 0ms 0ms 10 51,073 0ms 0ms 0ms 0ms 0ms 0ms 11 51,122 0ms 0ms 0ms 0ms 0ms 0ms 12 55,315 0ms 0ms 0ms 0ms 0ms 0ms 13 101,353 0ms 0ms 0ms 0ms 0ms 0ms 14 51,100 0ms 0ms 0ms 0ms 0ms 0ms 15 51,023 0ms 0ms 0ms 0ms 0ms 0ms 16 51,116 0ms 0ms 0ms 0ms 0ms 0ms 17 50,926 0ms 0ms 0ms 0ms 0ms 0ms 18 51,088 0ms 0ms 0ms 0ms 0ms 0ms 19 51,063 0ms 0ms 0ms 0ms 0ms 0ms 20 61,684 0ms 0ms 0ms 0ms 0ms 0ms 21 74,414 0ms 0ms 0ms 0ms 0ms 0ms 22 68,102 0ms 0ms 0ms 0ms 0ms 0ms 23 1,642 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 26 00 16,660 0 0ms 0ms 0ms 0ms 01 16,673 0 0ms 0ms 0ms 0ms 02 16,738 0 0ms 0ms 0ms 0ms 03 16,657 0 0ms 0ms 0ms 0ms 04 16,663 0 0ms 0ms 0ms 0ms 05 16,728 0 0ms 0ms 0ms 0ms 06 16,665 0 0ms 0ms 0ms 0ms 07 16,670 0 0ms 0ms 0ms 0ms 08 16,694 0 0ms 0ms 0ms 0ms 09 16,659 0 0ms 0ms 0ms 0ms 10 16,648 0 0ms 0ms 0ms 0ms 11 16,685 0 0ms 0ms 0ms 0ms 12 19,438 0 0ms 0ms 0ms 0ms 13 49,207 0 0ms 0ms 0ms 0ms 14 16,656 0 0ms 0ms 0ms 0ms 15 16,657 0 0ms 0ms 0ms 0ms 16 16,694 0 0ms 0ms 0ms 0ms 17 16,662 0 0ms 0ms 0ms 0ms 18 16,669 0 0ms 0ms 0ms 0ms 19 16,668 0 0ms 0ms 0ms 0ms 20 23,662 0 0ms 0ms 0ms 0ms 21 30,995 0 0ms 0ms 0ms 0ms 22 27,855 0 0ms 0ms 0ms 0ms 23 436 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 26 00 6,804 744 88 0 0ms 0ms 0ms 0ms 01 6,811 744 88 0 0ms 0ms 0ms 0ms 02 6,783 744 88 0 0ms 0ms 0ms 0ms 03 6,802 744 88 0 0ms 0ms 0ms 0ms 04 6,790 744 87 0 0ms 0ms 0ms 0ms 05 6,810 744 88 0 0ms 0ms 0ms 0ms 06 6,800 744 88 0 0ms 0ms 0ms 0ms 07 6,794 744 89 0 0ms 0ms 0ms 0ms 08 6,811 744 88 0 0ms 0ms 0ms 0ms 09 6,798 744 88 0 0ms 0ms 0ms 0ms 10 6,804 744 88 0 0ms 0ms 0ms 0ms 11 6,795 745 88 0 0ms 0ms 0ms 0ms 12 6,781 783 88 0 0ms 0ms 0ms 0ms 13 6,808 1,059 89 0 0ms 0ms 0ms 0ms 14 6,807 744 88 0 0ms 0ms 0ms 0ms 15 6,789 744 88 0 0ms 0ms 0ms 0ms 16 6,802 744 88 0 0ms 0ms 0ms 0ms 17 6,777 744 88 0 0ms 0ms 0ms 0ms 18 6,801 744 87 0 0ms 0ms 0ms 0ms 19 6,796 744 88 0 0ms 0ms 0ms 0ms 20 6,837 861 102 0 0ms 0ms 0ms 0ms 21 6,822 1,044 509 0 0ms 0ms 0ms 0ms 22 6,816 928 99 0 0ms 0ms 0ms 0ms 23 279 19 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 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% 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 2 2.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 26 00 2 0.00/s 01 2 0.00/s 02 6 0.00/s 03 1 0.00/s 04 2 0.00/s 05 4 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 1 0.00/s 10 1 0.00/s 11 1 0.00/s 12 111 0.03/s 13 1,338 0.37/s 14 1 0.00/s 15 1 0.00/s 16 2 0.00/s 17 1 0.00/s 18 1 0.00/s 19 1 0.00/s 20 280 0.08/s 21 512 0.14/s 22 446 0.12/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 26 00 2 1s460ms 1s460ms 01 2 1s400ms 1s400ms 02 6 1s85ms 1s85ms 03 1 1s724ms 1s724ms 04 2 1s338ms 1s338ms 05 4 1s217ms 1s217ms 06 2 1s346ms 1s346ms 07 2 1s456ms 1s456ms 08 2 1s355ms 1s355ms 09 1 1s577ms 1s577ms 10 1 1s707ms 1s707ms 11 1 1s732ms 1s732ms 12 110 1s842ms 1s842ms 13 1,339 1s790ms 1s790ms 14 1 1s764ms 1s764ms 15 1 1s715ms 1s715ms 16 2 1s432ms 1s432ms 17 1 1s788ms 1s788ms 18 1 1s667ms 1s667ms 19 1 1s536ms 1s536ms 20 279 1s792ms 1s792ms 21 513 2s82ms 2s82ms 22 446 1s811ms 1s811ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-06-26 21:03:45 Date
Connections per database
Key values
- zabbix Main Database
- 2,720 connections Total
Connections per user
Key values
- zabbix Main User
- 2,720 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2025-06-26 22:15:57 Date
Histogram of session times
Key values
- 2,709 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 2,720 sessions Total
Sessions per user
Key values
- zabbix Main User
- 2,720 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 2,720 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 841 buffers Checkpoint Peak
- 2025-06-26 21:03:56 Date
- 84.013 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-26 17:57:49 Date
Checkpoints distance
Key values
- 5.51 Mo Distance Peak
- 2025-06-26 21:03:56 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 26 00 2,514 250.249s 0.027s 250.313s 01 2,360 234.835s 0.035s 234.904s 02 2,443 243.046s 0.036s 243.114s 03 2,386 237.337s 0.027s 237.398s 04 2,735 272.283s 0.027s 272.347s 05 2,544 253.162s 0.027s 253.224s 06 2,368 235.635s 0.026s 235.696s 07 2,400 238.839s 0.036s 238.911s 08 2,505 249.159s 0.032s 249.22s 09 2,902 288.908s 0.028s 288.972s 10 2,421 240.943s 0.033s 241.006s 11 2,465 245.249s 0.028s 245.312s 12 2,494 248.255s 0.028s 248.315s 13 2,519 250.553s 0.03s 250.617s 14 2,459 244.648s 0.036s 244.715s 15 2,653 264.174s 0.025s 264.23s 16 2,589 257.667s 0.027s 257.724s 17 2,543 252.96s 0.028s 253.023s 18 2,425 241.343s 0.033s 241.41s 19 2,379 236.735s 0.031s 236.798s 20 2,404 239.138s 0.031s 239.204s 21 3,934 392.046s 0.035s 392.114s 22 2,614 260.166s 0.028s 260.228s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 26 00 0 0 1 226 0.002s 0.012s 01 0 0 0 220 0.002s 0.012s 02 0 0 1 226 0.002s 0.012s 03 0 0 1 225 0.002s 0.012s 04 0 0 1 220 0.002s 0.012s 05 0 0 0 226 0.002s 0.012s 06 0 0 1 224 0.002s 0.012s 07 0 0 1 223 0.002s 0.012s 08 0 0 1 224 0.002s 0.012s 09 0 0 0 220 0.002s 0.012s 10 0 0 1 220 0.002s 0.012s 11 0 0 1 223 0.002s 0.012s 12 0 0 1 228 0.002s 0.012s 13 0 0 0 280 0.002s 0.012s 14 0 0 1 260 0.002s 0.012s 15 0 0 1 223 0.002s 0.012s 16 0 0 1 226 0.002s 0.012s 17 0 0 1 221 0.002s 0.012s 18 0 0 0 227 0.002s 0.012s 19 0 0 1 220 0.002s 0.012s 20 0 0 1 243 0.002s 0.012s 21 0 0 1 461 0.002s 0.012s 22 0 0 0 295 0.002s 0.012s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 26 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 26 00 910.92 kB 1,147.58 kB 01 943.33 kB 1,033.92 kB 02 1,068.83 kB 1,153.92 kB 03 1,183.17 kB 1,252.92 kB 04 1,014.58 kB 1,278.00 kB 05 900.67 kB 1,015.33 kB 06 998.17 kB 1,095.17 kB 07 1,127.50 kB 1,260.58 kB 08 1,097.50 kB 1,309.75 kB 09 895.50 kB 1,055.08 kB 10 960.33 kB 1,047.75 kB 11 1,087.67 kB 1,180.92 kB 12 1,190.75 kB 1,333.83 kB 13 964.17 kB 1,187.58 kB 14 976.67 kB 1,182.17 kB 15 1,069.75 kB 1,204.17 kB 16 1,179.33 kB 1,289.08 kB 17 1,013.67 kB 1,257.50 kB 18 911.33 kB 1,069.33 kB 19 994.75 kB 1,093.17 kB 20 1,130.42 kB 1,271.00 kB 21 1,349.92 kB 2,225.00 kB 22 942.58 kB 1,422.33 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 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 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 26 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
- 451,739 Total read queries
- 822,322 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,282,269 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,282,269 Requests
User Request type Count Duration zabbix Total 1,282,269 0ms delete 2,472 0ms insert 156,717 0ms others 8,208 0ms select 451,739 0ms tcl 645,046 0ms update 18,087 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,282,269 0ms delete 2,472 0ms insert 156,717 0ms others 8,208 0ms select 451,739 0ms tcl 645,046 0ms update 18,087 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,282,269 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,282,269 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-26 11:25:17 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 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 #1
Day Hour Count Duration Avg duration Jun 26 20 2 0ms 0ms 2 0ms 26 0ms 0ms 0ms select g.groupid, g.name from hstgrp g where g.type = ? and g.groupid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 13 6 0ms 0ms 20 13 0ms 0ms 22 7 0ms 0ms 3 0ms 35 0ms 0ms 0ms update ids set nextid = nextid + ? where table_name = ? and field_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 26 20 7 0ms 0ms 21 7 0ms 0ms 22 21 0ms 0ms 4 0ms 1,294 0ms 0ms 0ms select p.idx, p.source, p.value_id, p.value_str, type from profiles p where p.userid = ? and p.idx = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 12 53 0ms 0ms 13 712 0ms 0ms 20 145 0ms 0ms 21 178 0ms 0ms 22 206 0ms 0ms 5 0ms 7,098 0ms 0ms 0ms select hostmacroid, hostid, macro, value, type from hostmacro;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 6 0ms 5 0ms 0ms 0ms select distinct g.graphid, g.templateid, i.hostid from graphs g, graphs_items gi, items i where g.graphid = gi.graphid and gi.itemid = i.itemid and g.templateid in (...) and i.hostid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 26 21 5 0ms 0ms 7 0ms 6 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750856447) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750856447) / ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 26 21 6 0ms 0ms 8 0ms 2 0ms 0ms 0ms select triggerid, description, expression, error, priority, type, value, state, lastchange, status, recovery_mode, recovery_expression, correlation_mode, correlation_tag, opdata, event_name, null, null, null, flags from triggers where triggerid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 9 0ms 1 0ms 0ms 0ms select p.profileid, p.idx, p.source, p.value_id, p.value_str, type from profiles p where p.userid = ? and p.idx = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 26 22 1 0ms 0ms 10 0ms 2 0ms 0ms 0ms select mt.mediatypeid, mt.name, mt.type from media_type mt where ? = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 26 22 2 0ms 0ms 11 0ms 209 0ms 0ms 0ms select t.triggerid, t.description, t.expression, t.status, t.type, t.priority, t.comments, t.url, t.url_name, t.recovery_expression, t.recovery_mode, t.correlation_mode, t.correlation_tag, t.manual_close, t.opdata, t.discover, t.event_name from triggers t where t.triggerid in ( select distinct tg.triggerid from triggers tg, functions f, items i, item_discovery id where tg.triggerid = f.triggerid and f.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 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 06 9 0ms 0ms 07 9 0ms 0ms 08 9 0ms 0ms 09 9 0ms 0ms 10 9 0ms 0ms 11 9 0ms 0ms 12 10 0ms 0ms 13 9 0ms 0ms 14 9 0ms 0ms 15 9 0ms 0ms 16 9 0ms 0ms 17 9 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 10 0ms 0ms 22 9 0ms 0ms 12 0ms 7 0ms 0ms 0ms select h.hostid, h.name, h.status, h.maintenance_status, h.maintenanceid, h.maintenance_type, hr.active_available from hosts h left join host_rtdata hr on h.hostid = hr.hostid where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 26 20 5 0ms 0ms 21 2 0ms 0ms 13 0ms 1 0ms 0ms 0ms select count(distinct h.hostid) as rowscount, hg.groupid from hosts h, hosts_groups hg where h.flags in (...) and hg.groupid in (...) and hg.hostid = h.hostid and h.status in (...) group by hg.groupid;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 14 0ms 1 0ms 0ms 0ms select id.parent_itemid, id.itemid from item_discovery id, items i where id.itemid in (...) and i.itemid = id.itemid and i.flags = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 15 0ms 2 0ms 0ms 0ms select ht.hostid, ht.templateid, ht.link_type from hosts_templates ht where ht.hostid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 21 1 0ms 0ms 16 0ms 2 0ms 0ms 0ms select i.itemid, coalesce(irn.name_resolved, ?) as name_resolved from items i left join item_rtname irn on i.itemid = irn.itemid where i.type <> ? and i.flags in (...) and i.itemid in (...) and i.hostid = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 17 0ms 2 0ms 0ms 0ms select h.hostid, h.host from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...) and h.flags = ? limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 21 1 0ms 0ms 18 0ms 2 0ms 0ms 0ms select t.gitemid, t.graphid, t.itemid from graphs_items t where t.graphid in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 19 0ms 2,697 0ms 0ms 0ms select ? from information_schema.tables where table_catalog = ? and table_schema = ? and table_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 00 1 0ms 0ms 01 1 0ms 0ms 02 5 0ms 0ms 04 1 0ms 0ms 05 3 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 12 109 0ms 0ms 13 1,338 0ms 0ms 16 1 0ms 0ms 20 278 0ms 0ms 21 512 0ms 0ms 22 445 0ms 0ms 20 0ms 1 0ms 0ms 0ms select null from triggers t where t.triggerid in (...) for update;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 21 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 322,523 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 26 00 13,429 0ms 0ms 01 13,417 0ms 0ms 02 13,366 0ms 0ms 03 13,405 0ms 0ms 04 13,388 0ms 0ms 05 13,388 0ms 0ms 06 13,409 0ms 0ms 07 13,371 0ms 0ms 08 13,421 0ms 0ms 09 13,419 0ms 0ms 10 13,392 0ms 0ms 11 13,402 0ms 0ms 12 13,945 0ms 0ms 13 20,087 0ms 0ms 14 13,400 0ms 0ms 15 13,370 0ms 0ms 16 13,390 0ms 0ms 17 13,325 0ms 0ms 18 13,391 0ms 0ms 19 13,381 0ms 0ms 20 14,689 0ms 0ms 21 16,753 0ms 0ms 22 15,532 0ms 0ms 23 453 0ms 0ms 2 319,870 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 00 13,428 0ms 0ms 01 13,416 0ms 0ms 02 13,361 0ms 0ms 03 13,405 0ms 0ms 04 13,387 0ms 0ms 05 13,385 0ms 0ms 06 13,408 0ms 0ms 07 13,369 0ms 0ms 08 13,421 0ms 0ms 09 13,419 0ms 0ms 10 13,392 0ms 0ms 11 13,402 0ms 0ms 12 13,836 0ms 0ms 13 18,752 0ms 0ms 14 13,400 0ms 0ms 15 13,370 0ms 0ms 16 13,389 0ms 0ms 17 13,325 0ms 0ms 18 13,391 0ms 0ms 19 13,381 0ms 0ms 20 14,417 0ms 0ms 21 16,250 0ms 0ms 22 15,113 0ms 0ms 23 453 0ms 0ms 3 47,580 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 Jun 26 00 2,070 0ms 0ms 01 2,086 0ms 0ms 02 2,068 0ms 0ms 03 2,071 0ms 0ms 04 2,075 0ms 0ms 05 2,082 0ms 0ms 06 2,070 0ms 0ms 07 2,064 0ms 0ms 08 2,070 0ms 0ms 09 2,079 0ms 0ms 10 2,077 0ms 0ms 11 2,067 0ms 0ms 12 2,057 0ms 0ms 13 2,071 0ms 0ms 14 2,059 0ms 0ms 15 2,049 0ms 0ms 16 2,059 0ms 0ms 17 2,043 0ms 0ms 18 2,066 0ms 0ms 19 2,074 0ms 0ms 20 2,053 0ms 0ms 21 2,060 0ms 0ms 22 2,058 0ms 0ms 23 52 0ms 0ms 4 42,392 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 00 1,890 0ms 0ms 01 1,906 0ms 0ms 02 1,898 0ms 0ms 03 1,834 0ms 0ms 04 1,793 0ms 0ms 05 1,851 0ms 0ms 06 1,893 0ms 0ms 07 1,844 0ms 0ms 08 1,871 0ms 0ms 09 1,869 0ms 0ms 10 1,850 0ms 0ms 11 1,783 0ms 0ms 12 1,819 0ms 0ms 13 1,821 0ms 0ms 14 1,836 0ms 0ms 15 1,866 0ms 0ms 16 1,860 0ms 0ms 17 1,850 0ms 0ms 18 1,782 0ms 0ms 19 1,846 0ms 0ms 20 1,833 0ms 0ms 21 1,772 0ms 0ms 22 1,771 0ms 0ms 23 54 0ms 0ms 5 28,565 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 26 00 1,209 0ms 0ms 01 1,189 0ms 0ms 02 1,166 0ms 0ms 03 1,237 0ms 0ms 04 1,264 0ms 0ms 05 1,233 0ms 0ms 06 1,192 0ms 0ms 07 1,230 0ms 0ms 08 1,229 0ms 0ms 09 1,209 0ms 0ms 10 1,242 0ms 0ms 11 1,304 0ms 0ms 12 1,252 0ms 0ms 13 1,266 0ms 0ms 14 1,257 0ms 0ms 15 1,206 0ms 0ms 16 1,232 0ms 0ms 17 1,218 0ms 0ms 18 1,308 0ms 0ms 19 1,225 0ms 0ms 20 1,235 0ms 0ms 21 1,317 0ms 0ms 22 1,313 0ms 0ms 23 32 0ms 0ms 6 27,611 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 #6
Day Hour Count Duration Avg duration Jun 26 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,198 0ms 0ms 14 1,200 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 32 0ms 0ms 7 27,611 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 #7
Day Hour Count Duration Avg duration Jun 26 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,198 0ms 0ms 14 1,200 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,199 0ms 0ms 18 1,200 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 32 0ms 0ms 8 27,611 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 26 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,200 0ms 0ms 03 1,199 0ms 0ms 04 1,198 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,198 0ms 0ms 14 1,200 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 32 0ms 0ms 9 27,611 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 Jun 26 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,200 0ms 0ms 13 1,198 0ms 0ms 14 1,200 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 32 0ms 0ms 10 16,579 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 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 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 19 0ms 0ms 11 16,579 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 Jun 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 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 19 0ms 0ms 12 16,579 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 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 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 19 0ms 0ms 13 16,579 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 00 719 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 20 0ms 0ms 14 16,579 0ms 0ms 0ms 0ms update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 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 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 19 0ms 0ms 15 10,196 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 26 00 439 0ms 0ms 01 450 0ms 0ms 02 433 0ms 0ms 03 452 0ms 0ms 04 448 0ms 0ms 05 449 0ms 0ms 06 439 0ms 0ms 07 440 0ms 0ms 08 456 0ms 0ms 09 448 0ms 0ms 10 434 0ms 0ms 11 431 0ms 0ms 12 434 0ms 0ms 13 443 0ms 0ms 14 453 0ms 0ms 15 448 0ms 0ms 16 437 0ms 0ms 17 433 0ms 0ms 18 437 0ms 0ms 19 446 0ms 0ms 20 450 0ms 0ms 21 451 0ms 0ms 22 433 0ms 0ms 23 12 0ms 0ms 16 8,243 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 Jun 26 00 358 0ms 0ms 01 358 0ms 0ms 02 358 0ms 0ms 03 358 0ms 0ms 04 358 0ms 0ms 05 358 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 358 0ms 0ms 15 359 0ms 0ms 16 358 0ms 0ms 17 357 0ms 0ms 18 358 0ms 0ms 19 358 0ms 0ms 20 358 0ms 0ms 21 358 0ms 0ms 22 358 0ms 0ms 23 9 0ms 0ms 17 7,098 0ms 0ms 0ms 0ms select hostmacroid, hostid, macro, value, type from hostmacro;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 18 7,098 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 Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 19 7,098 0ms 0ms 0ms 0ms select maintenanceid, groupid from maintenances_groups order by maintenanceid;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 20 7,098 0ms 0ms 0ms 0ms select r.name, e.expressionid, e.expression, e.expression_type, e.exp_delimiter, e.case_sensitive from regexps r, expressions e where r.regexpid = e.regexpid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 308 0ms 0ms 19 309 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 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 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 #1
Day Hour Count Duration Avg duration Jun 26 20 2 0ms 0ms 2 0ms 0ms 0ms 26 0ms select g.groupid, g.name from hstgrp g where g.type = ? and g.groupid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 13 6 0ms 0ms 20 13 0ms 0ms 22 7 0ms 0ms 3 0ms 0ms 0ms 35 0ms update ids set nextid = nextid + ? where table_name = ? and field_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 26 20 7 0ms 0ms 21 7 0ms 0ms 22 21 0ms 0ms 4 0ms 0ms 0ms 1,294 0ms select p.idx, p.source, p.value_id, p.value_str, type from profiles p where p.userid = ? and p.idx = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 12 53 0ms 0ms 13 712 0ms 0ms 20 145 0ms 0ms 21 178 0ms 0ms 22 206 0ms 0ms 5 0ms 0ms 0ms 7,098 0ms select hostmacroid, hostid, macro, value, type from hostmacro;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 26 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 308 0ms 0ms 13 308 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 6 0ms 0ms 0ms 5 0ms select distinct g.graphid, g.templateid, i.hostid from graphs g, graphs_items gi, items i where g.graphid = gi.graphid and gi.itemid = i.itemid and g.templateid in (...) and i.hostid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 26 21 5 0ms 0ms 7 0ms 0ms 0ms 6 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750856447) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750856447) / ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 26 21 6 0ms 0ms 8 0ms 0ms 0ms 2 0ms select triggerid, description, expression, error, priority, type, value, state, lastchange, status, recovery_mode, recovery_expression, correlation_mode, correlation_tag, opdata, event_name, null, null, null, flags from triggers where triggerid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 9 0ms 0ms 0ms 1 0ms select p.profileid, p.idx, p.source, p.value_id, p.value_str, type from profiles p where p.userid = ? and p.idx = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 26 22 1 0ms 0ms 10 0ms 0ms 0ms 2 0ms select mt.mediatypeid, mt.name, mt.type from media_type mt where ? = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 26 22 2 0ms 0ms 11 0ms 0ms 0ms 209 0ms select t.triggerid, t.description, t.expression, t.status, t.type, t.priority, t.comments, t.url, t.url_name, t.recovery_expression, t.recovery_mode, t.correlation_mode, t.correlation_tag, t.manual_close, t.opdata, t.discover, t.event_name from triggers t where t.triggerid in ( select distinct tg.triggerid from triggers tg, functions f, items i, item_discovery id where tg.triggerid = f.triggerid and f.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 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 06 9 0ms 0ms 07 9 0ms 0ms 08 9 0ms 0ms 09 9 0ms 0ms 10 9 0ms 0ms 11 9 0ms 0ms 12 10 0ms 0ms 13 9 0ms 0ms 14 9 0ms 0ms 15 9 0ms 0ms 16 9 0ms 0ms 17 9 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 10 0ms 0ms 22 9 0ms 0ms 12 0ms 0ms 0ms 7 0ms select h.hostid, h.name, h.status, h.maintenance_status, h.maintenanceid, h.maintenance_type, hr.active_available from hosts h left join host_rtdata hr on h.hostid = hr.hostid where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 26 20 5 0ms 0ms 21 2 0ms 0ms 13 0ms 0ms 0ms 1 0ms select count(distinct h.hostid) as rowscount, hg.groupid from hosts h, hosts_groups hg where h.flags in (...) and hg.groupid in (...) and hg.hostid = h.hostid and h.status in (...) group by hg.groupid;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 14 0ms 0ms 0ms 1 0ms select id.parent_itemid, id.itemid from item_discovery id, items i where id.itemid in (...) and i.itemid = id.itemid and i.flags = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 15 0ms 0ms 0ms 2 0ms select ht.hostid, ht.templateid, ht.link_type from hosts_templates ht where ht.hostid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 21 1 0ms 0ms 16 0ms 0ms 0ms 2 0ms select i.itemid, coalesce(irn.name_resolved, ?) as name_resolved from items i left join item_rtname irn on i.itemid = irn.itemid where i.type <> ? and i.flags in (...) and i.itemid in (...) and i.hostid = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 17 0ms 0ms 0ms 2 0ms select h.hostid, h.host from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...) and h.flags = ? limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 26 20 1 0ms 0ms 21 1 0ms 0ms 18 0ms 0ms 0ms 2 0ms select t.gitemid, t.graphid, t.itemid from graphs_items t where t.graphid in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 26 21 2 0ms 0ms 19 0ms 0ms 0ms 2,697 0ms select ? from information_schema.tables where table_catalog = ? and table_schema = ? and table_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 00 1 0ms 0ms 01 1 0ms 0ms 02 5 0ms 0ms 04 1 0ms 0ms 05 3 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 12 109 0ms 0ms 13 1,338 0ms 0ms 16 1 0ms 0ms 20 278 0ms 0ms 21 512 0ms 0ms 22 445 0ms 0ms 20 0ms 0ms 0ms 1 0ms select null from triggers t where t.triggerid in (...) for update;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 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 16,507 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 26 00 703 0ms 0ms 01 715 0ms 0ms 02 714 0ms 0ms 03 712 0ms 0ms 04 704 0ms 0ms 05 728 0ms 0ms 06 704 0ms 0ms 07 724 0ms 0ms 08 709 0ms 0ms 09 709 0ms 0ms 10 718 0ms 0ms 11 707 0ms 0ms 12 712 0ms 0ms 13 713 0ms 0ms 14 716 0ms 0ms 15 709 0ms 0ms 16 721 0ms 0ms 17 727 0ms 0ms 18 723 0ms 0ms 19 722 0ms 0ms 20 736 0ms 0ms 21 747 0ms 0ms 22 714 0ms 0ms 23 20 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,715,011 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4 Max number of times the same event was reported
- 17 Total events found
Rank Times reported Error 1 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 26 04 1 05 1 06 1 17 1 2 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 26 04 1 05 1 06 1 17 1 3 4 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 26 04 3 06 1 - FATAL: no pg_hba.conf entry for host "34.38.121.245", user "postgres", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "185.226.197.27", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "245.121.38.34.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-06-26 04:35:31 Database: postgres Application: [unknown] User: postgres Remote: 245.121.38.34.bc.googleusercontent.com
Detail: Client IP address resolved to "zl-ams-nl-gp1-wk127a.internet-census.org", forward lookup not checked.
Date: 2025-06-26 04:37:08 Database: postgres Application: [unknown] User: postgres Remote: zl-ams-nl-gp1-wk127a.internet-census.org
4 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 26 04 1 05 1 06 1 17 1 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 26 08 1