pgBadger-
Global information
- Generated on Fri Jul 11 23:01:29 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-07-11.log
- Parsed 5,294,419 log entries in 1m28s
- Log start from 2025-07-11 00:00:00 to 2025-07-11 23:01:26
-
Overview
Global Stats
- 405 Number of unique normalized queries
- 1,214,505 Number of queries
- 0ms Total query duration
- 2025-07-11 00:00:00 First query
- 2025-07-11 23:01:26 Last query
- 201 queries/s at 2025-07-11 17:46:38 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 17 Number of events
- 8 Number of unique normalized events
- 5 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
- 560 Total number of sessions
- 7 sessions at 2025-07-11 17:46:36 Session peak
- 24m4s Total duration of sessions
- 2s579ms Average duration of sessions
- 2,168 Average queries per session
- 0ms Average queries duration per session
- 2s579ms Average idle time per session
- 560 Total number of connections
- 6 connections/s at 2025-07-11 17:43:37 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 201 queries/s Query Peak
- 2025-07-11 17:46:38 Date
SELECT Traffic
Key values
- 118 queries/s Query Peak
- 2025-07-11 17:46:38 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 83 queries/s Query Peak
- 2025-07-11 17:46:38 Date
Queries duration
Key values
- 0ms Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 11 00 51,881 0ms 0ms 0ms 0ms 0ms 0ms 01 51,818 0ms 0ms 0ms 0ms 0ms 0ms 02 51,890 0ms 0ms 0ms 0ms 0ms 0ms 03 51,930 0ms 0ms 0ms 0ms 0ms 0ms 04 51,904 0ms 0ms 0ms 0ms 0ms 0ms 05 51,737 0ms 0ms 0ms 0ms 0ms 0ms 06 51,932 0ms 0ms 0ms 0ms 0ms 0ms 07 51,841 0ms 0ms 0ms 0ms 0ms 0ms 08 51,931 0ms 0ms 0ms 0ms 0ms 0ms 09 51,869 0ms 0ms 0ms 0ms 0ms 0ms 10 51,859 0ms 0ms 0ms 0ms 0ms 0ms 11 51,896 0ms 0ms 0ms 0ms 0ms 0ms 12 51,729 0ms 0ms 0ms 0ms 0ms 0ms 13 51,824 0ms 0ms 0ms 0ms 0ms 0ms 14 51,874 0ms 0ms 0ms 0ms 0ms 0ms 15 51,771 0ms 0ms 0ms 0ms 0ms 0ms 16 51,793 0ms 0ms 0ms 0ms 0ms 0ms 17 72,881 0ms 0ms 0ms 0ms 0ms 0ms 18 51,776 0ms 0ms 0ms 0ms 0ms 0ms 19 51,714 0ms 0ms 0ms 0ms 0ms 0ms 20 51,743 0ms 0ms 0ms 0ms 0ms 0ms 21 51,721 0ms 0ms 0ms 0ms 0ms 0ms 22 51,668 0ms 0ms 0ms 0ms 0ms 0ms 23 1,523 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 11 00 17,214 0 0ms 0ms 0ms 0ms 01 17,191 0 0ms 0ms 0ms 0ms 02 17,218 0 0ms 0ms 0ms 0ms 03 17,213 0 0ms 0ms 0ms 0ms 04 17,190 0 0ms 0ms 0ms 0ms 05 17,182 0 0ms 0ms 0ms 0ms 06 17,215 0 0ms 0ms 0ms 0ms 07 17,184 0 0ms 0ms 0ms 0ms 08 17,189 0 0ms 0ms 0ms 0ms 09 17,195 0 0ms 0ms 0ms 0ms 10 17,212 0 0ms 0ms 0ms 0ms 11 17,220 0 0ms 0ms 0ms 0ms 12 17,186 0 0ms 0ms 0ms 0ms 13 17,198 0 0ms 0ms 0ms 0ms 14 17,207 0 0ms 0ms 0ms 0ms 15 17,153 0 0ms 0ms 0ms 0ms 16 17,118 0 0ms 0ms 0ms 0ms 17 30,608 0 0ms 0ms 0ms 0ms 18 17,111 0 0ms 0ms 0ms 0ms 19 17,124 0 0ms 0ms 0ms 0ms 20 17,104 0 0ms 0ms 0ms 0ms 21 17,091 0 0ms 0ms 0ms 0ms 22 17,070 0 0ms 0ms 0ms 0ms 23 430 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 11 00 6,902 744 88 0 0ms 0ms 0ms 0ms 01 6,899 744 88 0 0ms 0ms 0ms 0ms 02 6,904 744 88 0 0ms 0ms 0ms 0ms 03 6,900 744 88 0 0ms 0ms 0ms 0ms 04 6,909 744 88 0 0ms 0ms 0ms 0ms 05 6,888 744 88 0 0ms 0ms 0ms 0ms 06 6,914 744 88 0 0ms 0ms 0ms 0ms 07 6,901 746 88 0 0ms 0ms 0ms 0ms 08 6,910 746 88 0 0ms 0ms 0ms 0ms 09 6,898 744 88 0 0ms 0ms 0ms 0ms 10 6,896 744 88 0 0ms 0ms 0ms 0ms 11 6,901 745 88 0 0ms 0ms 0ms 0ms 12 6,882 744 88 0 0ms 0ms 0ms 0ms 13 6,893 744 88 0 0ms 0ms 0ms 0ms 14 6,903 744 88 0 0ms 0ms 0ms 0ms 15 6,898 744 88 0 0ms 0ms 0ms 0ms 16 6,904 744 87 0 0ms 0ms 0ms 0ms 17 6,896 922 88 0 0ms 0ms 0ms 0ms 18 6,904 744 88 0 0ms 0ms 0ms 0ms 19 6,884 744 88 0 0ms 0ms 0ms 0ms 20 6,909 744 88 0 0ms 0ms 0ms 0ms 21 6,900 744 88 0 0ms 0ms 0ms 0ms 22 6,898 744 88 0 0ms 0ms 0ms 0ms 23 268 17 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 11 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 52 52.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 Jul 11 00 1 0.00/s 01 2 0.00/s 02 2 0.00/s 03 3 0.00/s 04 1 0.00/s 05 1 0.00/s 06 1 0.00/s 07 1 0.00/s 08 1 0.00/s 09 2 0.00/s 10 3 0.00/s 11 2 0.00/s 12 1 0.00/s 13 1 0.00/s 14 2 0.00/s 15 1 0.00/s 16 1 0.00/s 17 525 0.15/s 18 1 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 11 00 1 1s704ms 1s704ms 01 2 1s266ms 1s266ms 02 2 1s429ms 1s429ms 03 3 1s232ms 1s232ms 04 1 1s768ms 1s768ms 05 1 1s809ms 1s809ms 06 1 1s707ms 1s707ms 07 1 1s688ms 1s688ms 08 1 1s872ms 1s872ms 09 2 1s294ms 1s294ms 10 3 1s286ms 1s286ms 11 2 1s536ms 1s536ms 12 1 1s786ms 1s786ms 13 1 1s597ms 1s597ms 14 2 1s521ms 1s521ms 15 1 1s915ms 1s915ms 16 1 1s684ms 1s684ms 17 525 2s652ms 2s652ms 18 1 1s677ms 1s677ms 19 2 1s300ms 1s300ms 20 2 1s307ms 1s307ms 21 2 1s565ms 1s565ms 22 2 1s472ms 1s472ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-07-11 17:43:37 Date
Connections per database
Key values
- zabbix Main Database
- 560 connections Total
Connections per user
Key values
- zabbix Main User
- 560 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2025-07-11 17:46:36 Date
Histogram of session times
Key values
- 553 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 560 sessions Total
Sessions per user
Key values
- zabbix Main User
- 560 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 560 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 3,887 buffers Checkpoint Peak
- 2025-07-11 00:59:11 Date
- 269.575 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-07-11 20:45:25 Date
Checkpoints distance
Key values
- 3.97 Mo Distance Peak
- 2025-07-11 09:05:33 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 11 00 6,543 534.053s 0.038s 534.124s 01 2,468 245.649s 0.032s 245.712s 02 2,600 258.867s 0.03s 258.93s 03 2,604 259.168s 0.037s 259.238s 04 2,605 259.366s 0.029s 259.426s 05 3,007 299.623s 0.028s 299.685s 06 2,634 261.975s 0.032s 262.039s 07 2,611 259.974s 0.03s 260.038s 08 2,609 259.673s 0.028s 259.734s 09 2,768 275.694s 0.034s 275.763s 10 2,697 268.585s 0.034s 268.651s 11 2,620 260.674s 0.032s 260.739s 12 2,590 257.869s 0.027s 257.93s 13 2,707 269.586s 0.028s 269.648s 14 2,705 269.288s 0.033s 269.355s 15 2,638 262.483s 0.027s 262.546s 16 2,612 260.076s 0.028s 260.141s 17 2,645 263.281s 0.03s 263.342s 18 2,815 280.404s 0.028s 280.47s 19 2,619 260.682s 0.028s 260.747s 20 2,603 259.08s 0.03s 259.142s 21 2,618 260.583s 0.028s 260.645s 22 3,443 343.089s 0.03s 343.153s 23 260 25.944s 0.005s 25.951s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 11 00 0 0 1 247 0.002s 0.013s 01 0 0 1 196 0.002s 0.011s 02 0 0 1 217 0.002s 0.012s 03 0 0 1 222 0.003s 0.012s 04 0 0 1 220 0.002s 0.012s 05 0 0 0 223 0.002s 0.012s 06 0 0 1 218 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 1 225 0.002s 0.012s 10 0 0 1 219 0.002s 0.012s 11 0 0 0 221 0.002s 0.012s 12 0 0 1 218 0.002s 0.012s 13 0 0 1 225 0.002s 0.012s 14 0 0 1 230 0.002s 0.012s 15 0 0 1 224 0.002s 0.012s 16 0 0 0 223 0.002s 0.012s 17 0 0 1 247 0.002s 0.012s 18 0 0 1 226 0.002s 0.012s 19 0 0 1 221 0.002s 0.012s 20 0 0 1 215 0.002s 0.012s 21 0 0 1 226 0.002s 0.012s 22 0 0 1 218 0.002s 0.012s 23 0 0 0 28 0.003s 0.001s Day Hour Count Avg time (sec) Jul 11 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 Jul 11 00 1,310.00 kB 1,642.62 kB 01 999.64 kB 1,439.27 kB 02 987.17 kB 1,382.83 kB 03 1,121.58 kB 1,493.42 kB 04 1,254.42 kB 1,599.92 kB 05 1,148.83 kB 1,651.25 kB 06 995.08 kB 1,423.00 kB 07 1,108.67 kB 1,481.83 kB 08 1,239.50 kB 1,632.83 kB 09 1,246.25 kB 1,697.17 kB 10 1,013.75 kB 1,500.50 kB 11 1,024.92 kB 1,367.58 kB 12 1,146.83 kB 1,484.58 kB 13 1,296.50 kB 1,666.17 kB 14 1,008.33 kB 1,445.83 kB 15 989.50 kB 1,294.50 kB 16 1,111.50 kB 1,456.33 kB 17 1,256.25 kB 1,524.50 kB 18 1,173.08 kB 1,585.42 kB 19 983.83 kB 1,287.75 kB 20 1,092.42 kB 1,364.50 kB 21 1,227.92 kB 1,527.00 kB 22 1,257.83 kB 1,685.00 kB 23 1,191.00 kB 1,419.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 11 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 Jul 11 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
- 408,823 Total read queries
- 803,954 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,214,505 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,214,505 Requests
User Request type Count Duration zabbix Total 1,214,505 0ms delete 2,025 0ms insert 158,961 0ms others 1,728 0ms select 408,823 0ms tcl 625,656 0ms update 17,312 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,214,505 0ms delete 2,025 0ms insert 158,961 0ms others 1,728 0ms select 408,823 0ms tcl 625,656 0ms update 17,312 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,214,453 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,214,459 Requests
- 0ms (unknown)
- Main time consuming application
Application Request type Count Duration DBeaver 25.1.2 - Main Total 7 0ms others 1 0ms select 6 0ms DBeaver 25.1.2 - Metadata Total 34 0ms others 1 0ms select 33 0ms DBeaver 25.1.2 - Read PostgreSQL database list Total 2 0ms select 2 0ms PostgreSQL JDBC Driver Total 3 0ms others 3 0ms [unknown] Total 1,214,459 0ms delete 2,025 0ms insert 158,961 0ms others 1,723 0ms select 408,782 0ms tcl 625,656 0ms update 17,312 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-11 17:39:36 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 1 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?.? e - 05, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 21 1 0ms 0ms 2 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 #2
Day Hour Count Duration Avg duration Jul 11 07 1 0ms 0ms 08 1 0ms 0ms 3 0ms 2 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622159) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622159) / ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 17 2 0ms 0ms 4 0ms 20 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 = ? and g.groupid = hg.groupid);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 17 20 0ms 0ms 5 0ms 1 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622157) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622157) / ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 6 0ms 2 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 22 1 0ms 0ms 7 0ms 2 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.? e - 05, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 11 11 1 0ms 0ms 17 1 0ms 0ms 8 0ms 1 0ms 0ms 0ms select d.dashboardid, d.name, d.userid, d.display_period, d.auto_start from dashboard d where d.templateid is null and d.dashboardid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 9 0ms 2 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751621979) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751621979) / ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 11 17 2 0ms 0ms 10 0ms 3 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622457) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622457) / ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 11 17 3 0ms 0ms 11 0ms 520 0ms 0ms 0ms select r.roleid, r.name, r.type from role r where r.roleid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 17 520 0ms 0ms 12 0ms 1 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 11 11 1 0ms 0ms 13 0ms 209 0ms 0ms 0ms select item_conditionid, macro, value, operator from item_condition where itemid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 11 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 11 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 14 0ms 23 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 01 2 0ms 0ms 02 10 0ms 0ms 13 10 0ms 0ms 15 1 0ms 0ms 15 0ms 320 0ms 0ms 0ms select * from history h where h.itemid = ? and h.clock > ? order by h.clock desc, h.ns desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 11 17 320 0ms 0ms 16 0ms 1 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622819) / ?, ?) as i, max(clock) as clock from trends_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622819) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 17 0ms 1 0ms 0ms 0ms select c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull or (t.typtype = ? and t.typnotnull), a.attidentity != ? or pg_catalog.pg_get_expr(d.adbin, d.adrelid) like ? from pg_catalog.pg_class c join pg_catalog.pg_namespace n on (c.relnamespace = n.oid) join pg_catalog.pg_attribute a on (c.oid = a.attrelid) join pg_catalog.pg_type t on (a.atttypid = t.oid) left join pg_catalog.pg_attrdef d on (d.adrelid = a.attrelid and d.adnum = a.attnum) join ( select ? as oid, ? as attnum union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ?) vals on (c.oid = vals.oid and a.attnum = vals.attnum);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 18 0ms 1 0ms 0ms 0ms select current_database();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 19 0ms 520 0ms 0ms 0ms select role_ruleid, roleid, type, name, value_int, value_str, value_moduleid, value_serviceid from role_rule where roleid = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 17 520 0ms 0ms 20 0ms 3 0ms 0ms 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622577) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622577) / ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 17 3 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 312,828 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 00 13,464 0ms 0ms 01 13,444 0ms 0ms 02 13,464 0ms 0ms 03 13,487 0ms 0ms 04 13,484 0ms 0ms 05 13,415 0ms 0ms 06 13,483 0ms 0ms 07 13,459 0ms 0ms 08 13,496 0ms 0ms 09 13,468 0ms 0ms 10 13,454 0ms 0ms 11 13,467 0ms 0ms 12 13,412 0ms 0ms 13 13,448 0ms 0ms 14 13,462 0ms 0ms 15 13,442 0ms 0ms 16 13,467 0ms 0ms 17 16,394 0ms 0ms 18 13,462 0ms 0ms 19 13,433 0ms 0ms 20 13,445 0ms 0ms 21 13,445 0ms 0ms 22 13,430 0ms 0ms 23 403 0ms 0ms 2 312,294 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 11 00 13,464 0ms 0ms 01 13,443 0ms 0ms 02 13,463 0ms 0ms 03 13,485 0ms 0ms 04 13,484 0ms 0ms 05 13,415 0ms 0ms 06 13,483 0ms 0ms 07 13,458 0ms 0ms 08 13,497 0ms 0ms 09 13,467 0ms 0ms 10 13,452 0ms 0ms 11 13,466 0ms 0ms 12 13,412 0ms 0ms 13 13,448 0ms 0ms 14 13,461 0ms 0ms 15 13,441 0ms 0ms 16 13,468 0ms 0ms 17 15,873 0ms 0ms 18 13,462 0ms 0ms 19 13,432 0ms 0ms 20 13,444 0ms 0ms 21 13,444 0ms 0ms 22 13,429 0ms 0ms 23 403 0ms 0ms 3 47,438 0ms 0ms 0ms 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 00 2,065 0ms 0ms 01 2,068 0ms 0ms 02 2,053 0ms 0ms 03 2,069 0ms 0ms 04 2,066 0ms 0ms 05 2,048 0ms 0ms 06 2,065 0ms 0ms 07 2,070 0ms 0ms 08 2,063 0ms 0ms 09 2,071 0ms 0ms 10 2,067 0ms 0ms 11 2,048 0ms 0ms 12 2,049 0ms 0ms 13 2,052 0ms 0ms 14 2,062 0ms 0ms 15 2,056 0ms 0ms 16 2,072 0ms 0ms 17 2,066 0ms 0ms 18 2,065 0ms 0ms 19 2,047 0ms 0ms 20 2,052 0ms 0ms 21 2,058 0ms 0ms 22 2,055 0ms 0ms 23 51 0ms 0ms 4 41,419 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 00 1,850 0ms 0ms 01 1,831 0ms 0ms 02 1,816 0ms 0ms 03 1,848 0ms 0ms 04 1,853 0ms 0ms 05 1,814 0ms 0ms 06 1,810 0ms 0ms 07 1,813 0ms 0ms 08 1,830 0ms 0ms 09 1,782 0ms 0ms 10 1,789 0ms 0ms 11 1,842 0ms 0ms 12 1,758 0ms 0ms 13 1,793 0ms 0ms 14 1,818 0ms 0ms 15 1,785 0ms 0ms 16 1,782 0ms 0ms 17 1,748 0ms 0ms 18 1,795 0ms 0ms 19 1,723 0ms 0ms 20 1,766 0ms 0ms 21 1,755 0ms 0ms 22 1,780 0ms 0ms 23 38 0ms 0ms 5 29,231 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 11 00 1,208 0ms 0ms 01 1,223 0ms 0ms 02 1,251 0ms 0ms 03 1,223 0ms 0ms 04 1,236 0ms 0ms 05 1,252 0ms 0ms 06 1,273 0ms 0ms 07 1,249 0ms 0ms 08 1,250 0ms 0ms 09 1,273 0ms 0ms 10 1,269 0ms 0ms 11 1,244 0ms 0ms 12 1,301 0ms 0ms 13 1,277 0ms 0ms 14 1,248 0ms 0ms 15 1,277 0ms 0ms 16 1,287 0ms 0ms 17 1,313 0ms 0ms 18 1,291 0ms 0ms 19 1,351 0ms 0ms 20 1,311 0ms 0ms 21 1,311 0ms 0ms 22 1,278 0ms 0ms 23 35 0ms 0ms 6 27,598 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 #6
Day Hour Count Duration Avg duration Jul 11 00 1,199 0ms 0ms 01 1,198 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,200 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 7 27,598 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 11 00 1,199 0ms 0ms 01 1,198 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,200 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 8 27,598 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 Jul 11 00 1,199 0ms 0ms 01 1,198 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,200 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 9 27,598 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 #9
Day Hour Count Duration Avg duration Jul 11 00 1,199 0ms 0ms 01 1,198 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,200 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 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 Jul 11 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 cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 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 12 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 #12
Day Hour Count Duration Avg duration Jul 11 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 Jul 11 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 taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 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 15 10,065 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 11 00 436 0ms 0ms 01 446 0ms 0ms 02 438 0ms 0ms 03 439 0ms 0ms 04 448 0ms 0ms 05 427 0ms 0ms 06 428 0ms 0ms 07 438 0ms 0ms 08 435 0ms 0ms 09 439 0ms 0ms 10 441 0ms 0ms 11 440 0ms 0ms 12 437 0ms 0ms 13 443 0ms 0ms 14 448 0ms 0ms 15 438 0ms 0ms 16 441 0ms 0ms 17 450 0ms 0ms 18 426 0ms 0ms 19 418 0ms 0ms 20 429 0ms 0ms 21 429 0ms 0ms 22 441 0ms 0ms 23 10 0ms 0ms 16 8,245 0ms 0ms 0ms 0ms select m.mediaid, m.mediatypeid, m.sendto from media m, users_groups u, config c, media_type mt where m.userid = u.userid and u.usrgrpid = c.alert_usrgrpid and m.mediatypeid = mt.mediatypeid and m.active = ? and mt.status = ? and mt.type <> ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 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 359 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 359 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,116 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 #17
Day Hour Count Duration Avg duration Jul 11 00 311 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 311 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 311 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 311 0ms 0ms 15 309 0ms 0ms 16 307 0ms 0ms 17 306 0ms 0ms 18 307 0ms 0ms 19 307 0ms 0ms 20 306 0ms 0ms 21 306 0ms 0ms 22 305 0ms 0ms 23 8 0ms 0ms 18 7,116 0ms 0ms 0ms 0ms select maintenanceid, hostid from maintenances_hosts order by maintenanceid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 00 311 0ms 0ms 01 310 0ms 0ms 02 311 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 311 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 309 0ms 0ms 16 307 0ms 0ms 17 306 0ms 0ms 18 307 0ms 0ms 19 307 0ms 0ms 20 306 0ms 0ms 21 306 0ms 0ms 22 305 0ms 0ms 23 8 0ms 0ms 19 7,116 0ms 0ms 0ms 0ms select c.conditionid, c.actionid, c.conditiontype, c.operator, c.value, c.value2 from conditions c, actions a where c.actionid = a.actionid and a.status = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 00 311 0ms 0ms 01 310 0ms 0ms 02 310 0ms 0ms 03 311 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 311 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 311 0ms 0ms 15 309 0ms 0ms 16 307 0ms 0ms 17 306 0ms 0ms 18 307 0ms 0ms 19 307 0ms 0ms 20 306 0ms 0ms 21 306 0ms 0ms 22 305 0ms 0ms 23 8 0ms 0ms 20 7,116 0ms 0ms 0ms 0ms select maintenanceid, groupid from maintenances_groups order by maintenanceid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 00 311 0ms 0ms 01 310 0ms 0ms 02 311 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 311 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 311 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 309 0ms 0ms 16 307 0ms 0ms 17 306 0ms 0ms 18 307 0ms 0ms 19 307 0ms 0ms 20 306 0ms 0ms 21 306 0ms 0ms 22 305 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 1 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?.? e - 05, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 11 21 1 0ms 0ms 2 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 #2
Day Hour Count Duration Avg duration Jul 11 07 1 0ms 0ms 08 1 0ms 0ms 3 0ms 0ms 0ms 2 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622159) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622159) / ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 11 17 2 0ms 0ms 4 0ms 0ms 0ms 20 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 = ? and g.groupid = hg.groupid);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 11 17 20 0ms 0ms 5 0ms 0ms 0ms 1 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622157) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622157) / ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 6 0ms 0ms 0ms 2 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 22 1 0ms 0ms 7 0ms 0ms 0ms 2 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.? e - 05, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 11 11 1 0ms 0ms 17 1 0ms 0ms 8 0ms 0ms 0ms 1 0ms select d.dashboardid, d.name, d.userid, d.display_period, d.auto_start from dashboard d where d.templateid is null and d.dashboardid = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 9 0ms 0ms 0ms 2 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751621979) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751621979) / ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 11 17 2 0ms 0ms 10 0ms 0ms 0ms 3 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622457) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622457) / ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 11 17 3 0ms 0ms 11 0ms 0ms 0ms 520 0ms select r.roleid, r.name, r.type from role r where r.roleid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 11 17 520 0ms 0ms 12 0ms 0ms 0ms 1 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 11 11 1 0ms 0ms 13 0ms 0ms 0ms 209 0ms select item_conditionid, macro, value, operator from item_condition where itemid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 11 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 11 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 14 0ms 0ms 0ms 23 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 11 01 2 0ms 0ms 02 10 0ms 0ms 13 10 0ms 0ms 15 1 0ms 0ms 15 0ms 0ms 0ms 320 0ms select * from history h where h.itemid = ? and h.clock > ? order by h.clock desc, h.ns desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 11 17 320 0ms 0ms 16 0ms 0ms 0ms 1 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622819) / ?, ?) as i, max(clock) as clock from trends_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622819) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 17 0ms 0ms 0ms 1 0ms select c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull or (t.typtype = ? and t.typnotnull), a.attidentity != ? or pg_catalog.pg_get_expr(d.adbin, d.adrelid) like ? from pg_catalog.pg_class c join pg_catalog.pg_namespace n on (c.relnamespace = n.oid) join pg_catalog.pg_attribute a on (c.oid = a.attrelid) join pg_catalog.pg_type t on (a.atttypid = t.oid) left join pg_catalog.pg_attrdef d on (d.adrelid = a.attrelid and d.adnum = a.attnum) join ( select ? as oid, ? as attnum union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ? union all select ?, ?) vals on (c.oid = vals.oid and a.attnum = vals.attnum);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 18 0ms 0ms 0ms 1 0ms select current_database();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 11 17 1 0ms 0ms 19 0ms 0ms 0ms 520 0ms select role_ruleid, roleid, type, name, value_int, value_str, value_moduleid, value_serviceid from role_rule where roleid = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 11 17 520 0ms 0ms 20 0ms 0ms 0ms 3 0ms select itemid, sum(num) as count, avg(value_avg) as avg, min(value_min) as min, max(value_max) as max, round(?.? * (clock - 1751622577) / ?, ?) as i, max(clock) as clock from trends where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751622577) / ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 11 17 3 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 18,028 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 11 00 780 0ms 0ms 01 784 0ms 0ms 02 782 0ms 0ms 03 774 0ms 0ms 04 780 0ms 0ms 05 783 0ms 0ms 06 781 0ms 0ms 07 780 0ms 0ms 08 775 0ms 0ms 09 778 0ms 0ms 10 781 0ms 0ms 11 787 0ms 0ms 12 783 0ms 0ms 13 781 0ms 0ms 14 780 0ms 0ms 15 785 0ms 0ms 16 783 0ms 0ms 17 784 0ms 0ms 18 787 0ms 0ms 19 778 0ms 0ms 20 793 0ms 0ms 21 785 0ms 0ms 22 790 0ms 0ms 23 34 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,566,106 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 17 Total events found
Rank Times reported Error 1 5 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 11 08 4 22 1 2 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 11 08 2 22 1 3 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 11 03 1 17 1 19 1 - FATAL: no pg_hba.conf entry for host "34.38.102.48", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "48.102.38.34.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-07-11 17:51:43 Database: postgres Application: [unknown] User: postgres Remote: 48.102.38.34.bc.googleusercontent.com
4 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 11 08 1 22 1 5 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 11 08 1 6 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 11 08 1 7 1 FATAL: received unencrypted data after SSL request
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 11 02 1 - FATAL: received unencrypted data after SSL request
Detail: This could be either a client-software bug or evidence of an attempted man-in-the-middle attack.
Date: 2025-07-11 02:03:46 Database: [unknown] Application: [unknown] User: [unknown] Remote: 218.75.38.211
8 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 11 10 1