pgBadger-
Global information
- Generated on Sun Jun 29 23:01:28 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-29.log
- Parsed 5,256,169 log entries in 1m27s
- Log start from 2025-06-29 00:00:00 to 2025-06-29 23:01:25
-
Overview
Global Stats
- 560 Number of unique normalized queries
- 1,205,839 Number of queries
- 0ms Total query duration
- 2025-06-29 00:00:00 First query
- 2025-06-29 23:01:25 Last query
- 162 queries/s at 2025-06-29 17:25:13 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 11 Number of events
- 5 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
- 666 Total number of sessions
- 7 sessions at 2025-06-29 17:16:45 Session peak
- 20m9s Total duration of sessions
- 1s816ms Average duration of sessions
- 1,810 Average queries per session
- 0ms Average queries duration per session
- 1s816ms Average idle time per session
- 666 Total number of connections
- 6 connections/s at 2025-06-29 17:04:53 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 162 queries/s Query Peak
- 2025-06-29 17:25:13 Date
SELECT Traffic
Key values
- 106 queries/s Query Peak
- 2025-06-29 17:25:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 67 queries/s Query Peak
- 2025-06-29 17:03:56 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 29 00 51,072 0ms 0ms 0ms 0ms 0ms 0ms 01 51,162 0ms 0ms 0ms 0ms 0ms 0ms 02 51,140 0ms 0ms 0ms 0ms 0ms 0ms 03 51,143 0ms 0ms 0ms 0ms 0ms 0ms 04 51,087 0ms 0ms 0ms 0ms 0ms 0ms 05 51,101 0ms 0ms 0ms 0ms 0ms 0ms 06 51,064 0ms 0ms 0ms 0ms 0ms 0ms 07 51,096 0ms 0ms 0ms 0ms 0ms 0ms 08 51,121 0ms 0ms 0ms 0ms 0ms 0ms 09 51,052 0ms 0ms 0ms 0ms 0ms 0ms 10 51,119 0ms 0ms 0ms 0ms 0ms 0ms 11 51,118 0ms 0ms 0ms 0ms 0ms 0ms 12 51,089 0ms 0ms 0ms 0ms 0ms 0ms 13 51,130 0ms 0ms 0ms 0ms 0ms 0ms 14 51,009 0ms 0ms 0ms 0ms 0ms 0ms 15 51,044 0ms 0ms 0ms 0ms 0ms 0ms 16 51,084 0ms 0ms 0ms 0ms 0ms 0ms 17 76,202 0ms 0ms 0ms 0ms 0ms 0ms 18 51,838 0ms 0ms 0ms 0ms 0ms 0ms 19 51,916 0ms 0ms 0ms 0ms 0ms 0ms 20 52,052 0ms 0ms 0ms 0ms 0ms 0ms 21 51,890 0ms 0ms 0ms 0ms 0ms 0ms 22 51,792 0ms 0ms 0ms 0ms 0ms 0ms 23 1,518 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 29 00 16,664 0 0ms 0ms 0ms 0ms 01 16,713 0 0ms 0ms 0ms 0ms 02 16,680 0 0ms 0ms 0ms 0ms 03 16,684 0 0ms 0ms 0ms 0ms 04 16,666 0 0ms 0ms 0ms 0ms 05 16,688 0 0ms 0ms 0ms 0ms 06 16,665 0 0ms 0ms 0ms 0ms 07 16,698 0 0ms 0ms 0ms 0ms 08 16,678 0 0ms 0ms 0ms 0ms 09 16,673 0 0ms 0ms 0ms 0ms 10 16,690 0 0ms 0ms 0ms 0ms 11 16,673 0 0ms 0ms 0ms 0ms 12 16,652 0 0ms 0ms 0ms 0ms 13 16,685 0 0ms 0ms 0ms 0ms 14 16,652 0 0ms 0ms 0ms 0ms 15 16,686 0 0ms 0ms 0ms 0ms 16 16,708 0 0ms 0ms 0ms 0ms 17 33,129 0 0ms 0ms 0ms 0ms 18 17,177 0 0ms 0ms 0ms 0ms 19 17,190 0 0ms 0ms 0ms 0ms 20 17,224 0 0ms 0ms 0ms 0ms 21 17,194 0 0ms 0ms 0ms 0ms 22 17,207 0 0ms 0ms 0ms 0ms 23 403 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 29 00 6,798 744 88 0 0ms 0ms 0ms 0ms 01 6,805 744 88 0 0ms 0ms 0ms 0ms 02 6,804 744 88 0 0ms 0ms 0ms 0ms 03 6,807 744 87 0 0ms 0ms 0ms 0ms 04 6,797 744 88 0 0ms 0ms 0ms 0ms 05 6,799 744 88 0 0ms 0ms 0ms 0ms 06 6,800 744 88 0 0ms 0ms 0ms 0ms 07 6,796 744 88 0 0ms 0ms 0ms 0ms 08 6,804 744 88 0 0ms 0ms 0ms 0ms 09 6,787 744 88 0 0ms 0ms 0ms 0ms 10 6,803 744 88 0 0ms 0ms 0ms 0ms 11 6,794 745 88 0 0ms 0ms 0ms 0ms 12 6,792 744 88 0 0ms 0ms 0ms 0ms 13 6,804 744 88 0 0ms 0ms 0ms 0ms 14 6,784 744 88 0 0ms 0ms 0ms 0ms 15 6,789 746 88 0 0ms 0ms 0ms 0ms 16 6,791 746 88 0 0ms 0ms 0ms 0ms 17 6,930 994 133 0 0ms 0ms 0ms 0ms 18 6,898 744 87 0 0ms 0ms 0ms 0ms 19 6,904 744 88 0 0ms 0ms 0ms 0ms 20 6,928 744 88 0 0ms 0ms 0ms 0ms 21 6,905 744 88 0 0ms 0ms 0ms 0ms 22 6,886 744 88 0 0ms 0ms 0ms 0ms 23 269 17 3 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 29 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 29 00 2 0.00/s 01 4 0.00/s 02 2 0.00/s 03 3 0.00/s 04 2 0.00/s 05 2 0.00/s 06 1 0.00/s 07 4 0.00/s 08 3 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 1 0.00/s 13 1 0.00/s 14 1 0.00/s 15 1 0.00/s 16 1 0.00/s 17 626 0.17/s 18 1 0.00/s 19 1 0.00/s 20 2 0.00/s 21 1 0.00/s 22 1 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 29 00 2 1s319ms 1s319ms 01 4 1s159ms 1s159ms 02 2 1s395ms 1s395ms 03 3 1s248ms 1s248ms 04 2 1s409ms 1s409ms 05 2 1s432ms 1s432ms 06 1 1s779ms 1s779ms 07 4 1s170ms 1s170ms 08 3 1s227ms 1s227ms 09 2 1s369ms 1s369ms 10 2 1s356ms 1s356ms 11 2 1s423ms 1s423ms 12 1 1s863ms 1s863ms 13 1 1s731ms 1s731ms 14 1 1s615ms 1s615ms 15 1 1s892ms 1s892ms 16 1 1s593ms 1s593ms 17 626 1s843ms 1s843ms 18 1 1s571ms 1s571ms 19 1 1s743ms 1s743ms 20 2 1s241ms 1s241ms 21 1 1s652ms 1s652ms 22 1 1s696ms 1s696ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-06-29 17:04:53 Date
Connections per database
Key values
- zabbix Main Database
- 666 connections Total
Connections per user
Key values
- zabbix Main User
- 666 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2025-06-29 17:16:45 Date
Histogram of session times
Key values
- 656 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 666 sessions Total
Sessions per user
Key values
- zabbix Main User
- 666 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 666 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,331 buffers Checkpoint Peak
- 2025-06-29 07:25:56 Date
- 133.180 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-29 10:59:14 Date
Checkpoints distance
Key values
- 3.99 Mo Distance Peak
- 2025-06-29 06:04:18 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 29 00 3,010 299.822s 0.028s 299.883s 01 2,561 254.959s 0.029s 255.021s 02 2,485 247.064s 0.031s 247.126s 03 2,413 240.139s 0.027s 240.201s 04 2,429 241.741s 0.032s 241.802s 05 2,439 242.642s 0.033s 242.706s 06 2,600 258.866s 0.038s 258.938s 07 3,595 358.402s 0.04s 358.475s 08 2,438 242.546s 0.031s 242.608s 09 2,446 243.452s 0.027s 243.51s 10 2,621 260.868s 0.036s 260.935s 11 2,711 269.681s 0.036s 269.75s 12 2,706 269.279s 0.028s 269.34s 13 2,430 241.843s 0.028s 241.905s 14 2,577 256.463s 0.03s 256.527s 15 2,562 254.962s 0.031s 255.023s 16 2,453 244.044s 0.038s 244.115s 17 3,029 301.625s 0.032s 301.692s 18 2,504 249.253s 0.027s 249.317s 19 2,721 270.882s 0.035s 270.948s 20 2,565 255.36s 0.027s 255.42s 21 3,008 299.421s 0.031s 299.485s 22 2,552 254.059s 0.03s 254.122s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 29 00 0 0 1 217 0.002s 0.012s 01 0 0 1 211 0.003s 0.012s 02 0 0 0 213 0.002s 0.012s 03 0 0 1 215 0.002s 0.012s 04 0 0 1 213 0.002s 0.012s 05 0 0 1 220 0.002s 0.012s 06 0 0 0 222 0.002s 0.012s 07 0 0 1 221 0.004s 0.012s 08 0 0 1 225 0.002s 0.012s 09 0 0 1 220 0.002s 0.012s 10 0 0 1 225 0.003s 0.012s 11 0 0 0 231 0.002s 0.012s 12 0 0 1 227 0.002s 0.012s 13 0 0 1 218 0.002s 0.012s 14 0 0 1 222 0.002s 0.012s 15 0 0 0 232 0.002s 0.012s 16 0 0 1 223 0.002s 0.012s 17 0 0 1 406 0.002s 0.012s 18 0 0 1 222 0.002s 0.012s 19 0 0 1 228 0.003s 0.012s 20 0 0 0 221 0.002s 0.012s 21 0 0 1 225 0.002s 0.012s 22 0 0 1 215 0.002s 0.012s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 29 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 29 00 1,101.75 kB 1,328.17 kB 01 1,180.17 kB 1,459.00 kB 02 910.83 kB 1,182.08 kB 03 947.33 kB 1,162.33 kB 04 1,079.08 kB 1,299.92 kB 05 1,202.17 kB 1,421.33 kB 06 1,024.83 kB 1,599.92 kB 07 965.25 kB 1,214.58 kB 08 1,070.50 kB 1,292.67 kB 09 1,193.08 kB 1,431.42 kB 10 1,111.83 kB 1,449.75 kB 11 942.67 kB 1,234.17 kB 12 978.92 kB 1,199.42 kB 13 1,099.50 kB 1,324.83 kB 14 1,186.08 kB 1,495.33 kB 15 936.50 kB 1,343.50 kB 16 961.42 kB 1,231.50 kB 17 1,176.25 kB 1,411.83 kB 18 1,227.67 kB 1,467.92 kB 19 1,087.42 kB 1,625.42 kB 20 1,005.83 kB 1,291.92 kB 21 1,133.67 kB 1,390.42 kB 22 1,232.00 kB 1,514.83 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 29 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 29 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
- 403,079 Total read queries
- 800,716 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,205,839 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,205,839 Requests
User Request type Count Duration zabbix Total 1,205,839 0ms delete 2,070 0ms insert 157,274 0ms others 2,044 0ms select 403,079 0ms tcl 623,988 0ms update 17,384 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,205,839 0ms delete 2,070 0ms insert 157,274 0ms others 2,044 0ms select 403,079 0ms tcl 623,988 0ms update 17,384 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,205,839 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,205,839 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-29 19:59:31 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 ht.httptestid, ht.name, ht.delay, ht.status, ht.hostid, ht.templateid, h.name as hostname, ht.retries, ht.authentication, ht.http_proxy from httptest ht inner join hosts h on h.hostid = ht.hostid where ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 17 2 0ms 0ms 2 0ms 311,994 0ms 0ms 0ms begin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 00 13,385 0ms 0ms 01 13,399 0ms 0ms 02 13,408 0ms 0ms 03 13,405 0ms 0ms 04 13,392 0ms 0ms 05 13,387 0ms 0ms 06 13,381 0ms 0ms 07 13,378 0ms 0ms 08 13,398 0ms 0ms 09 13,376 0ms 0ms 10 13,393 0ms 0ms 11 13,405 0ms 0ms 12 13,404 0ms 0ms 13 13,402 0ms 0ms 14 13,368 0ms 0ms 15 13,365 0ms 0ms 16 13,373 0ms 0ms 17 16,568 0ms 0ms 18 13,464 0ms 0ms 19 13,492 0ms 0ms 20 13,530 0ms 0ms 21 13,477 0ms 0ms 22 13,431 0ms 0ms 23 413 0ms 0ms 3 0ms 1 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 29 05 1 0ms 0ms 4 0ms 5 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 07, ?.? e - 05), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 29 02 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 5 0ms 5 0ms 0ms 0ms select count(distinct g.graphid) as rowscount, i.hostid from graphs g, graphs_items gi, items i where i.hostid in (...) and gi.graphid = g.graphid and i.itemid = gi.itemid and g.flags in (...) group by i.hostid;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 29 17 5 0ms 0ms 6 0ms 11 0ms 0ms 0ms select count(*) as rowscount, i.hostid from items i where i.type <> ? and i.flags in (...) and i.hostid = ? and i.type = ? and i.status = ? group by i.hostid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 29 17 11 0ms 0ms 7 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751185415) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751185415) / ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 8 0ms 69 0ms 0ms 0ms select lld_overrideid, lld_override_conditionid, macro, value, operator from lld_override_condition where lld_overrideid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 29 00 3 0ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 9 0ms 8 0ms 0ms 0ms select h.hostid, h.status from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 29 17 8 0ms 0ms 10 0ms 2 0ms 0ms 0ms select distinct gi.* from graphs_items gi, graphs g where gi.graphid = g.graphid and g.graphid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 17 2 0ms 0ms 11 0ms 7,112 0ms 0ms 0ms select maintenanceid, maintenance_type, active_since, active_till, tags_evaltype from maintenances;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 309 0ms 0ms 02 308 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 12 0ms 643 0ms 0ms 0ms select configid, session_key, dbversion_status, server_status, software_update_checkid, software_update_check_data from config;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 00 1 0ms 0ms 01 3 0ms 0ms 02 1 0ms 0ms 03 2 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 07 3 0ms 0ms 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 17 625 0ms 0ms 20 1 0ms 0ms 13 0ms 695 0ms 0ms 0ms select type, itemid from httpstepitem where httpstepid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 17 91 0ms 0ms 18 120 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 120 0ms 0ms 22 120 0ms 0ms 23 4 0ms 0ms 14 0ms 4 0ms 0ms 0ms select hm.hostmacroid, hm.macro, hm.value, hm.type, hm.hostid from hostmacro hm where hm.hostid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 29 17 4 0ms 0ms 15 0ms 10 0ms 0ms 0ms select tag, value, httptestid from httptest_tag where httptestid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 29 17 10 0ms 0ms 16 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751185396) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751185396) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 17 0ms 11 0ms 0ms 0ms select count(distinct t.triggerid) as rowscount, i.hostid from triggers t, functions f, items i where i.hostid = ? and f.triggerid = t.triggerid and f.itemid = i.itemid and t.flags in (...) group by i.hostid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 17 11 0ms 0ms 18 0ms 1 0ms 0ms 0ms select max(httpstepitemid) as id from httpstepitem;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 19 0ms 5 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 18 2 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 20 0ms 207 0ms 0ms 0ms select lld_macro, path from lld_macro_path where itemid = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 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 9 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 9 0ms 0ms 22 9 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 311,994 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 00 13,385 0ms 0ms 01 13,399 0ms 0ms 02 13,408 0ms 0ms 03 13,405 0ms 0ms 04 13,392 0ms 0ms 05 13,387 0ms 0ms 06 13,381 0ms 0ms 07 13,378 0ms 0ms 08 13,398 0ms 0ms 09 13,376 0ms 0ms 10 13,393 0ms 0ms 11 13,405 0ms 0ms 12 13,404 0ms 0ms 13 13,402 0ms 0ms 14 13,368 0ms 0ms 15 13,365 0ms 0ms 16 13,373 0ms 0ms 17 16,568 0ms 0ms 18 13,464 0ms 0ms 19 13,492 0ms 0ms 20 13,530 0ms 0ms 21 13,477 0ms 0ms 22 13,431 0ms 0ms 23 413 0ms 0ms 2 311,368 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 00 13,384 0ms 0ms 01 13,396 0ms 0ms 02 13,407 0ms 0ms 03 13,403 0ms 0ms 04 13,391 0ms 0ms 05 13,386 0ms 0ms 06 13,381 0ms 0ms 07 13,375 0ms 0ms 08 13,396 0ms 0ms 09 13,375 0ms 0ms 10 13,392 0ms 0ms 11 13,404 0ms 0ms 12 13,404 0ms 0ms 13 13,402 0ms 0ms 14 13,368 0ms 0ms 15 13,365 0ms 0ms 16 13,373 0ms 0ms 17 15,960 0ms 0ms 18 13,463 0ms 0ms 19 13,493 0ms 0ms 20 13,529 0ms 0ms 21 13,477 0ms 0ms 22 13,431 0ms 0ms 23 413 0ms 0ms 3 47,620 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 29 00 2,070 0ms 0ms 01 2,066 0ms 0ms 02 2,080 0ms 0ms 03 2,084 0ms 0ms 04 2,061 0ms 0ms 05 2,072 0ms 0ms 06 2,067 0ms 0ms 07 2,060 0ms 0ms 08 2,067 0ms 0ms 09 2,065 0ms 0ms 10 2,085 0ms 0ms 11 2,066 0ms 0ms 12 2,062 0ms 0ms 13 2,082 0ms 0ms 14 2,057 0ms 0ms 15 2,068 0ms 0ms 16 2,071 0ms 0ms 17 2,062 0ms 0ms 18 2,066 0ms 0ms 19 2,060 0ms 0ms 20 2,077 0ms 0ms 21 2,071 0ms 0ms 22 2,058 0ms 0ms 23 43 0ms 0ms 4 41,977 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 29 00 1,841 0ms 0ms 01 1,815 0ms 0ms 02 1,826 0ms 0ms 03 1,846 0ms 0ms 04 1,840 0ms 0ms 05 1,841 0ms 0ms 06 1,915 0ms 0ms 07 1,849 0ms 0ms 08 1,786 0ms 0ms 09 1,820 0ms 0ms 10 1,821 0ms 0ms 11 1,840 0ms 0ms 12 1,870 0ms 0ms 13 1,864 0ms 0ms 14 1,885 0ms 0ms 15 1,823 0ms 0ms 16 1,802 0ms 0ms 17 1,736 0ms 0ms 18 1,767 0ms 0ms 19 1,805 0ms 0ms 20 1,797 0ms 0ms 21 1,822 0ms 0ms 22 1,726 0ms 0ms 23 40 0ms 0ms 5 28,862 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 29 00 1,233 0ms 0ms 01 1,275 0ms 0ms 02 1,251 0ms 0ms 03 1,229 0ms 0ms 04 1,256 0ms 0ms 05 1,235 0ms 0ms 06 1,173 0ms 0ms 07 1,230 0ms 0ms 08 1,298 0ms 0ms 09 1,244 0ms 0ms 10 1,259 0ms 0ms 11 1,232 0ms 0ms 12 1,214 0ms 0ms 13 1,218 0ms 0ms 14 1,182 0ms 0ms 15 1,240 0ms 0ms 16 1,257 0ms 0ms 17 1,340 0ms 0ms 18 1,304 0ms 0ms 19 1,281 0ms 0ms 20 1,300 0ms 0ms 21 1,249 0ms 0ms 22 1,322 0ms 0ms 23 40 0ms 0ms 6 27,610 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 29 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,200 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,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 28 0ms 0ms 7 27,610 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 #7
Day Hour Count Duration Avg duration Jun 29 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,200 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,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 28 0ms 0ms 8 27,610 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 Jun 29 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,200 0ms 0ms 05 1,199 0ms 0ms 06 1,200 0ms 0ms 07 1,199 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 28 0ms 0ms 9 27,610 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 29 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,200 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,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,200 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,200 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 28 0ms 0ms 10 16,577 0ms 0ms 0ms 0ms update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 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 17 0ms 0ms 11 16,577 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 29 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 18 0ms 0ms 12 16,577 0ms 0ms 0ms 0ms select cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 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 17 0ms 0ms 13 16,577 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 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 17 0ms 0ms 14 16,577 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 #14
Day Hour Count Duration Avg duration Jun 29 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 17 0ms 0ms 15 10,165 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 29 00 436 0ms 0ms 01 441 0ms 0ms 02 439 0ms 0ms 03 458 0ms 0ms 04 433 0ms 0ms 05 444 0ms 0ms 06 428 0ms 0ms 07 446 0ms 0ms 08 439 0ms 0ms 09 440 0ms 0ms 10 446 0ms 0ms 11 444 0ms 0ms 12 436 0ms 0ms 13 434 0ms 0ms 14 452 0ms 0ms 15 441 0ms 0ms 16 457 0ms 0ms 17 442 0ms 0ms 18 432 0ms 0ms 19 445 0ms 0ms 20 431 0ms 0ms 21 442 0ms 0ms 22 449 0ms 0ms 23 10 0ms 0ms 16 8,242 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 29 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 357 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 358 0ms 0ms 16 358 0ms 0ms 17 358 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,112 0ms 0ms 0ms 0ms select maintenanceid, maintenance_type, active_since, active_till, tags_evaltype from maintenances;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 309 0ms 0ms 02 308 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 18 7,112 0ms 0ms 0ms 0ms select t.timeperiodid, t.timeperiod_type, t.every, t.month, t.dayofweek, t.day, t.start_time, t.period, t.start_date, m.maintenanceid from maintenances_windows m, timeperiods t where t.timeperiodid = m.timeperiodid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 309 0ms 0ms 02 308 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 19 7,112 0ms 0ms 0ms 0ms select p.item_parameterid, p.itemid, p.name, p.value, i.hostid from item_parameter p, items i, hosts h where p.itemid = i.itemid and i.hostid = h.hostid and h.status in (...) and i.flags <> ? order by p.itemid;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 308 0ms 0ms 06 309 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 20 7,112 0ms 0ms 0ms 0ms select a.actionid, o.recovery from actions a left join operations o on a.actionid = o.actionid where a.status = ? group by a.actionid, o.recovery order by a.actionid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 308 0ms 0ms 06 309 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 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 ht.httptestid, ht.name, ht.delay, ht.status, ht.hostid, ht.templateid, h.name as hostname, ht.retries, ht.authentication, ht.http_proxy from httptest ht inner join hosts h on h.hostid = ht.hostid where ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 17 2 0ms 0ms 2 0ms 0ms 0ms 311,994 0ms begin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 00 13,385 0ms 0ms 01 13,399 0ms 0ms 02 13,408 0ms 0ms 03 13,405 0ms 0ms 04 13,392 0ms 0ms 05 13,387 0ms 0ms 06 13,381 0ms 0ms 07 13,378 0ms 0ms 08 13,398 0ms 0ms 09 13,376 0ms 0ms 10 13,393 0ms 0ms 11 13,405 0ms 0ms 12 13,404 0ms 0ms 13 13,402 0ms 0ms 14 13,368 0ms 0ms 15 13,365 0ms 0ms 16 13,373 0ms 0ms 17 16,568 0ms 0ms 18 13,464 0ms 0ms 19 13,492 0ms 0ms 20 13,530 0ms 0ms 21 13,477 0ms 0ms 22 13,431 0ms 0ms 23 413 0ms 0ms 3 0ms 0ms 0ms 1 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 29 05 1 0ms 0ms 4 0ms 0ms 0ms 5 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 07, ?.? e - 05), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 29 02 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 5 0ms 0ms 0ms 5 0ms select count(distinct g.graphid) as rowscount, i.hostid from graphs g, graphs_items gi, items i where i.hostid in (...) and gi.graphid = g.graphid and i.itemid = gi.itemid and g.flags in (...) group by i.hostid;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 29 17 5 0ms 0ms 6 0ms 0ms 0ms 11 0ms select count(*) as rowscount, i.hostid from items i where i.type <> ? and i.flags in (...) and i.hostid = ? and i.type = ? and i.status = ? group by i.hostid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 29 17 11 0ms 0ms 7 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751185415) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751185415) / ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 8 0ms 0ms 0ms 69 0ms select lld_overrideid, lld_override_conditionid, macro, value, operator from lld_override_condition where lld_overrideid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 29 00 3 0ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 9 0ms 0ms 0ms 8 0ms select h.hostid, h.status from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 29 17 8 0ms 0ms 10 0ms 0ms 0ms 2 0ms select distinct gi.* from graphs_items gi, graphs g where gi.graphid = g.graphid and g.graphid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 17 2 0ms 0ms 11 0ms 0ms 0ms 7,112 0ms select maintenanceid, maintenance_type, active_since, active_till, tags_evaltype from maintenances;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 29 00 308 0ms 0ms 01 309 0ms 0ms 02 308 0ms 0ms 03 308 0ms 0ms 04 308 0ms 0ms 05 309 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 309 0ms 0ms 14 308 0ms 0ms 15 309 0ms 0ms 16 310 0ms 0ms 17 310 0ms 0ms 18 310 0ms 0ms 19 310 0ms 0ms 20 311 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 12 0ms 0ms 0ms 643 0ms select configid, session_key, dbversion_status, server_status, software_update_checkid, software_update_check_data from config;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 00 1 0ms 0ms 01 3 0ms 0ms 02 1 0ms 0ms 03 2 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 07 3 0ms 0ms 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 17 625 0ms 0ms 20 1 0ms 0ms 13 0ms 0ms 0ms 695 0ms select type, itemid from httpstepitem where httpstepid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 17 91 0ms 0ms 18 120 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 120 0ms 0ms 22 120 0ms 0ms 23 4 0ms 0ms 14 0ms 0ms 0ms 4 0ms select hm.hostmacroid, hm.macro, hm.value, hm.type, hm.hostid from hostmacro hm where hm.hostid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 29 17 4 0ms 0ms 15 0ms 0ms 0ms 10 0ms select tag, value, httptestid from httptest_tag where httptestid = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 29 17 10 0ms 0ms 16 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751185396) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751185396) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 17 0ms 0ms 0ms 11 0ms select count(distinct t.triggerid) as rowscount, i.hostid from triggers t, functions f, items i where i.hostid = ? and f.triggerid = t.triggerid and f.itemid = i.itemid and t.flags in (...) group by i.hostid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 17 11 0ms 0ms 18 0ms 0ms 0ms 1 0ms select max(httpstepitemid) as id from httpstepitem;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 17 1 0ms 0ms 19 0ms 0ms 0ms 5 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 18 2 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 20 0ms 0ms 0ms 207 0ms select lld_macro, path from lld_macro_path where itemid = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 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 9 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 9 0ms 0ms 22 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 16,839 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 29 00 715 0ms 0ms 01 718 0ms 0ms 02 716 0ms 0ms 03 719 0ms 0ms 04 714 0ms 0ms 05 712 0ms 0ms 06 716 0ms 0ms 07 717 0ms 0ms 08 717 0ms 0ms 09 712 0ms 0ms 10 722 0ms 0ms 11 705 0ms 0ms 12 709 0ms 0ms 13 712 0ms 0ms 14 712 0ms 0ms 15 715 0ms 0ms 16 712 0ms 0ms 17 779 0ms 0ms 18 776 0ms 0ms 19 774 0ms 0ms 20 774 0ms 0ms 21 782 0ms 0ms 22 782 0ms 0ms 23 29 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,547,681 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 11 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
- 11 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 Jun 29 07 1 13 2 17 1 18 1 19 1 - FATAL: no pg_hba.conf entry for host "35.205.45.78", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "78.45.205.35.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-06-29 13:12:40 Database: postgres Application: [unknown] User: postgres Remote: 78.45.205.35.bc.googleusercontent.com
2 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 29 10 1 22 1 3 1 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 29 10 1 4 1 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 29 10 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 29 12 1