pgBadger-
Global information
- Generated on Tue Jul 1 23:01:30 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-07-01.log
- Parsed 5,243,966 log entries in 1m28s
- Log start from 2025-07-01 00:00:00 to 2025-07-01 23:01:27
-
Overview
Global Stats
- 314 Number of unique normalized queries
- 1,202,598 Number of queries
- 0ms Total query duration
- 2025-07-01 00:00:00 First query
- 2025-07-01 23:01:27 Last query
- 157 queries/s at 2025-07-01 12:33:05 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 18 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
- 206 Total number of sessions
- 4 sessions at 2025-07-01 12:35:07 Session peak
- 6m54s Total duration of sessions
- 2s10ms Average duration of sessions
- 5,837 Average queries per session
- 0ms Average queries duration per session
- 2s10ms Average idle time per session
- 206 Total number of connections
- 6 connections/s at 2025-07-01 12:31:34 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 157 queries/s Query Peak
- 2025-07-01 12:33:05 Date
SELECT Traffic
Key values
- 98 queries/s Query Peak
- 2025-07-01 12:33:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 73 queries/s Query Peak
- 2025-07-01 12:23:19 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 01 00 51,941 0ms 0ms 0ms 0ms 0ms 0ms 01 51,745 0ms 0ms 0ms 0ms 0ms 0ms 02 51,632 0ms 0ms 0ms 0ms 0ms 0ms 03 51,700 0ms 0ms 0ms 0ms 0ms 0ms 04 51,807 0ms 0ms 0ms 0ms 0ms 0ms 05 51,988 0ms 0ms 0ms 0ms 0ms 0ms 06 51,978 0ms 0ms 0ms 0ms 0ms 0ms 07 51,976 0ms 0ms 0ms 0ms 0ms 0ms 08 51,887 0ms 0ms 0ms 0ms 0ms 0ms 09 51,870 0ms 0ms 0ms 0ms 0ms 0ms 10 51,858 0ms 0ms 0ms 0ms 0ms 0ms 11 51,934 0ms 0ms 0ms 0ms 0ms 0ms 12 59,598 0ms 0ms 0ms 0ms 0ms 0ms 13 51,965 0ms 0ms 0ms 0ms 0ms 0ms 14 52,003 0ms 0ms 0ms 0ms 0ms 0ms 15 51,867 0ms 0ms 0ms 0ms 0ms 0ms 16 51,850 0ms 0ms 0ms 0ms 0ms 0ms 17 51,771 0ms 0ms 0ms 0ms 0ms 0ms 18 51,895 0ms 0ms 0ms 0ms 0ms 0ms 19 51,967 0ms 0ms 0ms 0ms 0ms 0ms 20 51,958 0ms 0ms 0ms 0ms 0ms 0ms 21 51,923 0ms 0ms 0ms 0ms 0ms 0ms 22 51,897 0ms 0ms 0ms 0ms 0ms 0ms 23 1,588 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 01 00 17,177 0 0ms 0ms 0ms 0ms 01 17,166 0 0ms 0ms 0ms 0ms 02 17,153 0 0ms 0ms 0ms 0ms 03 17,164 0 0ms 0ms 0ms 0ms 04 17,191 0 0ms 0ms 0ms 0ms 05 17,199 0 0ms 0ms 0ms 0ms 06 17,174 0 0ms 0ms 0ms 0ms 07 17,219 0 0ms 0ms 0ms 0ms 08 17,178 0 0ms 0ms 0ms 0ms 09 17,190 0 0ms 0ms 0ms 0ms 10 17,171 0 0ms 0ms 0ms 0ms 11 17,189 0 0ms 0ms 0ms 0ms 12 22,026 0 0ms 0ms 0ms 0ms 13 17,216 0 0ms 0ms 0ms 0ms 14 17,198 0 0ms 0ms 0ms 0ms 15 17,182 0 0ms 0ms 0ms 0ms 16 17,224 0 0ms 0ms 0ms 0ms 17 17,186 0 0ms 0ms 0ms 0ms 18 17,215 0 0ms 0ms 0ms 0ms 19 17,206 0 0ms 0ms 0ms 0ms 20 17,190 0 0ms 0ms 0ms 0ms 21 17,184 0 0ms 0ms 0ms 0ms 22 17,222 0 0ms 0ms 0ms 0ms 23 401 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 01 00 6,914 744 88 0 0ms 0ms 0ms 0ms 01 6,893 744 88 0 0ms 0ms 0ms 0ms 02 6,878 744 88 0 0ms 0ms 0ms 0ms 03 6,879 744 88 0 0ms 0ms 0ms 0ms 04 6,896 744 88 0 0ms 0ms 0ms 0ms 05 6,927 744 88 0 0ms 0ms 0ms 0ms 06 6,921 744 88 0 0ms 0ms 0ms 0ms 07 6,920 746 88 0 0ms 0ms 0ms 0ms 08 6,908 744 88 0 0ms 0ms 0ms 0ms 09 6,911 744 88 0 0ms 0ms 0ms 0ms 10 6,910 744 88 0 0ms 0ms 0ms 0ms 11 6,929 745 88 0 0ms 0ms 0ms 0ms 12 6,906 836 88 0 0ms 0ms 0ms 0ms 13 6,903 744 88 0 0ms 0ms 0ms 0ms 14 6,931 744 88 0 0ms 0ms 0ms 0ms 15 6,902 744 88 0 0ms 0ms 0ms 0ms 16 6,894 744 88 0 0ms 0ms 0ms 0ms 17 6,884 744 88 0 0ms 0ms 0ms 0ms 18 6,905 744 88 0 0ms 0ms 0ms 0ms 19 6,911 744 87 0 0ms 0ms 0ms 0ms 20 6,917 744 88 0 0ms 0ms 0ms 0ms 21 6,920 744 88 0 0ms 0ms 0ms 0ms 22 6,897 744 88 0 0ms 0ms 0ms 0ms 23 284 18 3 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 01 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 Jul 01 00 1 0.00/s 01 1 0.00/s 02 1 0.00/s 03 1 0.00/s 04 2 0.00/s 05 2 0.00/s 06 1 0.00/s 07 1 0.00/s 08 1 0.00/s 09 1 0.00/s 10 1 0.00/s 11 1 0.00/s 12 178 0.05/s 13 2 0.00/s 14 2 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 1 0.00/s 21 1 0.00/s 22 2 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 01 00 1 1s810ms 1s810ms 01 1 1s643ms 1s643ms 02 1 1s796ms 1s796ms 03 1 1s830ms 1s830ms 04 2 1s344ms 1s344ms 05 2 1s449ms 1s449ms 06 1 2s40ms 2s40ms 07 1 1s871ms 1s871ms 08 1 1s650ms 1s650ms 09 1 1s662ms 1s662ms 10 1 1s665ms 1s665ms 11 1 2s7ms 2s7ms 12 178 2s72ms 2s72ms 13 2 1s388ms 1s388ms 14 2 1s648ms 1s648ms 15 1 1s599ms 1s599ms 16 2 1s390ms 1s390ms 17 1 1s788ms 1s788ms 18 1 1s674ms 1s674ms 19 1 1s697ms 1s697ms 20 1 1s593ms 1s593ms 21 1 1s522ms 1s522ms 22 2 1s475ms 1s475ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-07-01 12:31:34 Date
Connections per database
Key values
- zabbix Main Database
- 206 connections Total
Connections per user
Key values
- zabbix Main User
- 206 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2025-07-01 12:35:07 Date
Histogram of session times
Key values
- 203 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 206 sessions Total
Sessions per user
Key values
- zabbix Main User
- 206 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 206 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,884 buffers Checkpoint Peak
- 2025-07-01 19:48:18 Date
- 188.254 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-07-01 00:10:04 Date
Checkpoints distance
Key values
- 4.06 Mo Distance Peak
- 2025-07-01 01:05:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 01 00 2,657 264.476s 0.03s 264.541s 01 3,270 325.851s 0.033s 325.923s 02 2,646 263.369s 0.037s 263.438s 03 2,586 257.364s 0.031s 257.425s 04 2,641 262.97s 0.035s 263.04s 05 2,655 264.372s 0.032s 264.433s 06 3,423 341.074s 0.029s 341.135s 07 2,637 262.471s 0.036s 262.54s 08 2,601 258.977s 0.027s 259.042s 09 2,586 257.369s 0.028s 257.43s 10 2,760 274.894s 0.03s 274.956s 11 2,615 260.174s 0.031s 260.239s 12 2,927 291.611s 0.031s 291.67s 13 2,575 256.362s 0.027s 256.423s 14 2,752 273.985s 0.026s 274.047s 15 2,644 263.274s 0.034s 263.339s 16 2,601 258.875s 0.032s 258.942s 17 2,644 263.176s 0.027s 263.238s 18 2,641 262.972s 0.029s 263.035s 19 4,412 439.818s 0.03s 439.883s 20 2,915 290.411s 0.027s 290.47s 21 2,601 258.867s 0.033s 258.934s 22 2,581 256.87s 0.03s 256.933s 23 259 25.842s 0.003s 25.849s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 01 00 0 0 1 230 0.002s 0.012s 01 0 0 1 227 0.002s 0.012s 02 0 0 1 227 0.002s 0.012s 03 0 0 1 219 0.002s 0.012s 04 0 0 0 224 0.003s 0.012s 05 0 0 1 223 0.002s 0.012s 06 0 0 1 218 0.002s 0.012s 07 0 0 1 251 0.002s 0.012s 08 0 0 1 219 0.002s 0.012s 09 0 0 1 223 0.002s 0.012s 10 0 0 0 221 0.002s 0.012s 11 0 0 1 223 0.002s 0.012s 12 0 0 1 247 0.002s 0.012s 13 0 0 1 217 0.002s 0.012s 14 0 0 1 222 0.002s 0.012s 15 0 0 0 221 0.003s 0.012s 16 0 0 1 222 0.002s 0.012s 17 0 0 1 225 0.002s 0.012s 18 0 0 1 223 0.002s 0.012s 19 0 0 1 231 0.002s 0.012s 20 0 0 0 232 0.002s 0.012s 21 0 0 1 227 0.002s 0.012s 22 0 0 1 226 0.002s 0.012s 23 0 0 0 26 0.001s 0.001s Day Hour Count Avg time (sec) Jul 01 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 01 00 1,234.33 kB 1,616.92 kB 01 1,256.92 kB 1,718.50 kB 02 997.08 kB 1,436.83 kB 03 1,011.42 kB 1,359.67 kB 04 1,131.67 kB 1,468.33 kB 05 1,280.00 kB 1,607.92 kB 06 1,018.08 kB 1,529.42 kB 07 986.67 kB 1,365.25 kB 08 1,106.92 kB 1,446.42 kB 09 1,235.17 kB 1,561.83 kB 10 1,170.50 kB 1,675.25 kB 11 1,001.92 kB 1,380.58 kB 12 1,098.25 kB 1,442.42 kB 13 1,216.83 kB 1,578.42 kB 14 1,266.17 kB 1,660.75 kB 15 1,001.33 kB 1,377.67 kB 16 1,019.33 kB 1,375.58 kB 17 1,140.17 kB 1,466.33 kB 18 1,276.67 kB 1,556.25 kB 19 1,044.25 kB 1,440.75 kB 20 983.75 kB 1,312.17 kB 21 1,107.92 kB 1,391.42 kB 22 1,233.83 kB 1,469.50 kB 23 1,519.00 kB 1,519.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 01 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 01 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
- 400,621 Total read queries
- 801,313 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,202,598 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,202,598 Requests
User Request type Count Duration zabbix Total 1,202,598 0ms delete 2,026 0ms insert 159,140 0ms others 664 0ms select 400,621 0ms tcl 622,922 0ms update 17,225 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,202,598 0ms delete 2,026 0ms insert 159,140 0ms others 664 0ms select 400,621 0ms tcl 622,922 0ms update 17,225 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,202,598 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,202,598 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-01 10:03:58 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,369 0ms 0ms 0ms select servicetagid, serviceid, tag, value from service_tag;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 00 59 0ms 0ms 01 60 0ms 0ms 02 59 0ms 0ms 03 60 0ms 0ms 04 59 0ms 0ms 05 60 0ms 0ms 06 59 0ms 0ms 07 60 0ms 0ms 08 59 0ms 0ms 09 60 0ms 0ms 10 59 0ms 0ms 11 59 0ms 0ms 12 60 0ms 0ms 13 59 0ms 0ms 14 60 0ms 0ms 15 59 0ms 0ms 16 60 0ms 0ms 17 59 0ms 0ms 18 60 0ms 0ms 19 59 0ms 0ms 20 60 0ms 0ms 21 59 0ms 0ms 22 60 0ms 0ms 23 1 0ms 0ms 2 0ms 207 0ms 0ms 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 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 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 Jul 01 06 1 0ms 0ms 4 0ms 1 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.? e - 05, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.? e - 05, ?.?, ?.?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 01 14 1 0ms 0ms 5 0ms 177 0ms 0ms 0ms select userid, username, name, surname, url, autologin, autologout, lang, refresh, theme, attempt_failed, attempt_ip, attempt_clock, rows_per_page, timezone, roleid, userdirectoryid, ts_provisioned from users where userid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 01 12 177 0ms 0ms 6 0ms 177 0ms 0ms 0ms select null from users u where u.userid = ? for update;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 12 177 0ms 0ms 7 0ms 1 0ms 0ms 0ms update host_inventory set name = ? where hostid = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 01 11 1 0ms 0ms 8 0ms 2 0ms 0ms 0ms select configid, software_update_check_data from config;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 01 12 2 0ms 0ms 9 0ms 4 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 10 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 10 0ms 9 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 #10
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 11 0ms 183 0ms 0ms 0ms select md.moduleid, md.id, md.relative_path, md.config from module md where md.status = ? order by md.relative_path;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 01 04 1 0ms 0ms 05 1 0ms 0ms 12 177 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 22 1 0ms 0ms 12 0ms 9 0ms 0ms 0ms select p.eventid, p.objectid, p.clock, p.ns, p.name, p.severity, p.cause_eventid from problem p where p.source = ? and p.object = ? and not exists ( select null from event_suppress es where es.eventid = p.eventid) and p.cause_eventid is null and p.r_eventid is null order by p.eventid desc limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 13 0ms 18 0ms 0ms 0ms select h.hostid, h.name from hosts h where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 01 12 18 0ms 0ms 14 0ms 5 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 10 1 0ms 0ms 19 1 0ms 0ms 15 0ms 57 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 01 00 3 0ms 0ms 01 3 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 1 0ms 0ms 05 3 0ms 0ms 06 2 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 3 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 3 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms 20 2 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 2 0ms 0ms 16 0ms 9 0ms 0ms 0ms select h.hostid, h.name from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 17 0ms 23 0ms 0ms 0ms show standard_conforming_strings;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 18 0ms 23 0ms 0ms 0ms delete from task where status in (...) and clock <= ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 19 0ms 183 0ms 0ms 0ms select sessionid, userid, lastaccess, secret from sessions where sessionid = ? and status = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 04 1 0ms 0ms 05 1 0ms 0ms 12 177 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 22 1 0ms 0ms 20 0ms 2 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 01 12 1 0ms 0ms 22 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 311,461 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 00 13,507 0ms 0ms 01 13,424 0ms 0ms 02 13,382 0ms 0ms 03 13,410 0ms 0ms 04 13,440 0ms 0ms 05 13,511 0ms 0ms 06 13,523 0ms 0ms 07 13,499 0ms 0ms 08 13,482 0ms 0ms 09 13,466 0ms 0ms 10 13,470 0ms 0ms 11 13,489 0ms 0ms 12 14,603 0ms 0ms 13 13,503 0ms 0ms 14 13,517 0ms 0ms 15 13,473 0ms 0ms 16 13,446 0ms 0ms 17 13,432 0ms 0ms 18 13,469 0ms 0ms 19 13,507 0ms 0ms 20 13,507 0ms 0ms 21 13,491 0ms 0ms 22 13,469 0ms 0ms 23 441 0ms 0ms 2 311,279 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 00 13,506 0ms 0ms 01 13,425 0ms 0ms 02 13,382 0ms 0ms 03 13,410 0ms 0ms 04 13,439 0ms 0ms 05 13,510 0ms 0ms 06 13,523 0ms 0ms 07 13,499 0ms 0ms 08 13,482 0ms 0ms 09 13,466 0ms 0ms 10 13,470 0ms 0ms 11 13,489 0ms 0ms 12 14,427 0ms 0ms 13 13,502 0ms 0ms 14 13,516 0ms 0ms 15 13,473 0ms 0ms 16 13,445 0ms 0ms 17 13,432 0ms 0ms 18 13,469 0ms 0ms 19 13,507 0ms 0ms 20 13,507 0ms 0ms 21 13,491 0ms 0ms 22 13,468 0ms 0ms 23 441 0ms 0ms 3 47,556 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 01 00 2,079 0ms 0ms 01 2,067 0ms 0ms 02 2,054 0ms 0ms 03 2,051 0ms 0ms 04 2,063 0ms 0ms 05 2,068 0ms 0ms 06 2,074 0ms 0ms 07 2,078 0ms 0ms 08 2,070 0ms 0ms 09 2,064 0ms 0ms 10 2,071 0ms 0ms 11 2,067 0ms 0ms 12 2,058 0ms 0ms 13 2,047 0ms 0ms 14 2,079 0ms 0ms 15 2,072 0ms 0ms 16 2,065 0ms 0ms 17 2,053 0ms 0ms 18 2,057 0ms 0ms 19 2,060 0ms 0ms 20 2,069 0ms 0ms 21 2,075 0ms 0ms 22 2,064 0ms 0ms 23 51 0ms 0ms 4 41,658 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 01 00 1,837 0ms 0ms 01 1,871 0ms 0ms 02 1,780 0ms 0ms 03 1,774 0ms 0ms 04 1,844 0ms 0ms 05 1,832 0ms 0ms 06 1,799 0ms 0ms 07 1,811 0ms 0ms 08 1,788 0ms 0ms 09 1,741 0ms 0ms 10 1,779 0ms 0ms 11 1,808 0ms 0ms 12 1,776 0ms 0ms 13 1,780 0ms 0ms 14 1,817 0ms 0ms 15 1,833 0ms 0ms 16 1,758 0ms 0ms 17 1,780 0ms 0ms 18 1,837 0ms 0ms 19 1,840 0ms 0ms 20 1,833 0ms 0ms 21 1,845 0ms 0ms 22 1,847 0ms 0ms 23 48 0ms 0ms 5 29,080 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 01 00 1,241 0ms 0ms 01 1,186 0ms 0ms 02 1,256 0ms 0ms 03 1,269 0ms 0ms 04 1,219 0ms 0ms 05 1,253 0ms 0ms 06 1,286 0ms 0ms 07 1,278 0ms 0ms 08 1,284 0ms 0ms 09 1,337 0ms 0ms 10 1,278 0ms 0ms 11 1,293 0ms 0ms 12 1,298 0ms 0ms 13 1,307 0ms 0ms 14 1,275 0ms 0ms 15 1,227 0ms 0ms 16 1,299 0ms 0ms 17 1,259 0ms 0ms 18 1,243 0ms 0ms 19 1,241 0ms 0ms 20 1,239 0ms 0ms 21 1,252 0ms 0ms 22 1,222 0ms 0ms 23 38 0ms 0ms 6 27,594 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,198 0ms 0ms 03 1,199 0ms 0ms 04 1,198 0ms 0ms 05 1,198 0ms 0ms 06 1,197 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,198 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 7 27,594 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 #7
Day Hour Count Duration Avg duration Jul 01 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,198 0ms 0ms 03 1,199 0ms 0ms 04 1,198 0ms 0ms 05 1,198 0ms 0ms 06 1,197 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,198 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 8 27,594 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 01 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,198 0ms 0ms 03 1,199 0ms 0ms 04 1,198 0ms 0ms 05 1,198 0ms 0ms 06 1,197 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,198 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 9 27,594 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 #9
Day Hour Count Duration Avg duration Jul 01 00 1,198 0ms 0ms 01 1,199 0ms 0ms 02 1,198 0ms 0ms 03 1,199 0ms 0ms 04 1,198 0ms 0ms 05 1,198 0ms 0ms 06 1,197 0ms 0ms 07 1,199 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,198 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,200 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 10 16,578 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 01 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 18 0ms 0ms 11 16,578 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 01 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 18 0ms 0ms 12 16,578 0ms 0ms 0ms 0ms update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 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 18 0ms 0ms 13 16,578 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 #13
Day Hour Count Duration Avg duration Jul 01 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 18 0ms 0ms 14 16,578 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 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 18 0ms 0ms 15 10,164 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 01 00 439 0ms 0ms 01 441 0ms 0ms 02 436 0ms 0ms 03 436 0ms 0ms 04 445 0ms 0ms 05 439 0ms 0ms 06 452 0ms 0ms 07 451 0ms 0ms 08 449 0ms 0ms 09 423 0ms 0ms 10 454 0ms 0ms 11 441 0ms 0ms 12 436 0ms 0ms 13 458 0ms 0ms 14 451 0ms 0ms 15 444 0ms 0ms 16 438 0ms 0ms 17 435 0ms 0ms 18 442 0ms 0ms 19 441 0ms 0ms 20 437 0ms 0ms 21 434 0ms 0ms 22 432 0ms 0ms 23 10 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 Jul 01 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 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,140 0ms 0ms 0ms 0ms select itemid, parent_itemid from item_discovery;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 00 310 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 309 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 311 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 309 0ms 0ms 11 311 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 311 0ms 0ms 17 310 0ms 0ms 18 311 0ms 0ms 19 311 0ms 0ms 20 310 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 18 7,140 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 Jul 01 00 310 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 309 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 311 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 311 0ms 0ms 17 310 0ms 0ms 18 311 0ms 0ms 19 311 0ms 0ms 20 310 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 19 7,140 0ms 0ms 0ms 0ms select maintenancetagid, maintenanceid, operator, tag, value from maintenance_tag;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 00 310 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 309 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 311 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 311 0ms 0ms 17 310 0ms 0ms 18 311 0ms 0ms 19 311 0ms 0ms 20 310 0ms 0ms 21 310 0ms 0ms 22 311 0ms 0ms 23 7 0ms 0ms 20 7,140 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 01 00 310 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 309 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 311 0ms 0ms 08 310 0ms 0ms 09 310 0ms 0ms 10 310 0ms 0ms 11 310 0ms 0ms 12 310 0ms 0ms 13 311 0ms 0ms 14 310 0ms 0ms 15 310 0ms 0ms 16 311 0ms 0ms 17 310 0ms 0ms 18 311 0ms 0ms 19 311 0ms 0ms 20 310 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 1,369 0ms select servicetagid, serviceid, tag, value from service_tag;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 00 59 0ms 0ms 01 60 0ms 0ms 02 59 0ms 0ms 03 60 0ms 0ms 04 59 0ms 0ms 05 60 0ms 0ms 06 59 0ms 0ms 07 60 0ms 0ms 08 59 0ms 0ms 09 60 0ms 0ms 10 59 0ms 0ms 11 59 0ms 0ms 12 60 0ms 0ms 13 59 0ms 0ms 14 60 0ms 0ms 15 59 0ms 0ms 16 60 0ms 0ms 17 59 0ms 0ms 18 60 0ms 0ms 19 59 0ms 0ms 20 60 0ms 0ms 21 59 0ms 0ms 22 60 0ms 0ms 23 1 0ms 0ms 2 0ms 0ms 0ms 207 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 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 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 Jul 01 06 1 0ms 0ms 4 0ms 0ms 0ms 1 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.? e - 05, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.? e - 05, ?.?, ?.?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 01 14 1 0ms 0ms 5 0ms 0ms 0ms 177 0ms select userid, username, name, surname, url, autologin, autologout, lang, refresh, theme, attempt_failed, attempt_ip, attempt_clock, rows_per_page, timezone, roleid, userdirectoryid, ts_provisioned from users where userid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 01 12 177 0ms 0ms 6 0ms 0ms 0ms 177 0ms select null from users u where u.userid = ? for update;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 12 177 0ms 0ms 7 0ms 0ms 0ms 1 0ms update host_inventory set name = ? where hostid = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 01 11 1 0ms 0ms 8 0ms 0ms 0ms 2 0ms select configid, software_update_check_data from config;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 01 12 2 0ms 0ms 9 0ms 0ms 0ms 4 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 10 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 10 0ms 0ms 0ms 9 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 #10
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 11 0ms 0ms 0ms 183 0ms select md.moduleid, md.id, md.relative_path, md.config from module md where md.status = ? order by md.relative_path;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 01 04 1 0ms 0ms 05 1 0ms 0ms 12 177 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 22 1 0ms 0ms 12 0ms 0ms 0ms 9 0ms select p.eventid, p.objectid, p.clock, p.ns, p.name, p.severity, p.cause_eventid from problem p where p.source = ? and p.object = ? and not exists ( select null from event_suppress es where es.eventid = p.eventid) and p.cause_eventid is null and p.r_eventid is null order by p.eventid desc limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 13 0ms 0ms 0ms 18 0ms select h.hostid, h.name from hosts h where h.flags in (...) and h.hostid in (...) and h.status in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 01 12 18 0ms 0ms 14 0ms 0ms 0ms 5 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 10 1 0ms 0ms 19 1 0ms 0ms 15 0ms 0ms 0ms 57 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 01 00 3 0ms 0ms 01 3 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 1 0ms 0ms 05 3 0ms 0ms 06 2 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 3 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 3 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms 20 2 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 2 0ms 0ms 16 0ms 0ms 0ms 9 0ms select h.hostid, h.name from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 01 12 9 0ms 0ms 17 0ms 0ms 0ms 23 0ms show standard_conforming_strings;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 18 0ms 0ms 0ms 23 0ms delete from task where status in (...) and clock <= ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 01 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 19 0ms 0ms 0ms 183 0ms select sessionid, userid, lastaccess, secret from sessions where sessionid = ? and status = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 04 1 0ms 0ms 05 1 0ms 0ms 12 177 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 22 1 0ms 0ms 20 0ms 0ms 0ms 2 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 01 12 1 0ms 0ms 22 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 17,982 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 01 00 775 0ms 0ms 01 793 0ms 0ms 02 790 0ms 0ms 03 781 0ms 0ms 04 786 0ms 0ms 05 784 0ms 0ms 06 774 0ms 0ms 07 787 0ms 0ms 08 780 0ms 0ms 09 783 0ms 0ms 10 780 0ms 0ms 11 792 0ms 0ms 12 768 0ms 0ms 13 767 0ms 0ms 14 784 0ms 0ms 15 779 0ms 0ms 16 781 0ms 0ms 17 775 0ms 0ms 18 784 0ms 0ms 19 770 0ms 0ms 20 780 0ms 0ms 21 786 0ms 0ms 22 775 0ms 0ms 23 28 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,540,903 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 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
- 18 Total events found
Rank Times reported Error 1 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 01 00 1 05 1 08 1 13 1 2 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 01 00 1 05 1 08 1 13 1 3 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 01 00 1 05 1 08 1 13 1 4 4 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 01 02 2 07 2 - FATAL: no pg_hba.conf entry for host "5.188.230.157", user "root", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "34.38.6.152", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "free.ds", forward lookup not checked.
Date: 2025-07-01 02:39:12 Database: postgres Application: [unknown] User: root Remote: free.ds
Detail: Client IP address resolved to "152.6.38.34.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-07-01 02:48:02 Database: postgres Application: [unknown] User: postgres Remote: 152.6.38.34.bc.googleusercontent.com
5 2 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 01 16 1 19 1