pgBadger-
Global information
- Generated on Wed Jul 2 23:01:27 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-07-02.log
- Parsed 5,206,275 log entries in 1m26s
- Log start from 2025-07-02 00:00:00 to 2025-07-02 23:01:24
-
Overview
Global Stats
- 294 Number of unique normalized queries
- 1,194,119 Number of queries
- 0ms Total query duration
- 2025-07-02 00:00:00 First query
- 2025-07-02 23:01:24 Last query
- 159 queries/s at 2025-07-02 20:27:48 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 19 Number of events
- 5 Number of unique normalized events
- 7 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
- 59 Total number of sessions
- 4 sessions at 2025-07-02 20:11:31 Session peak
- 1m41s Total duration of sessions
- 1s714ms Average duration of sessions
- 20,239 Average queries per session
- 0ms Average queries duration per session
- 1s714ms Average idle time per session
- 59 Total number of connections
- 6 connections/s at 2025-07-02 20:27:45 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 159 queries/s Query Peak
- 2025-07-02 20:27:48 Date
SELECT Traffic
Key values
- 106 queries/s Query Peak
- 2025-07-02 20:27:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 59 queries/s Query Peak
- 2025-07-02 20:27:48 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 02 00 51,764 0ms 0ms 0ms 0ms 0ms 0ms 01 51,851 0ms 0ms 0ms 0ms 0ms 0ms 02 51,918 0ms 0ms 0ms 0ms 0ms 0ms 03 51,913 0ms 0ms 0ms 0ms 0ms 0ms 04 51,942 0ms 0ms 0ms 0ms 0ms 0ms 05 51,822 0ms 0ms 0ms 0ms 0ms 0ms 06 51,720 0ms 0ms 0ms 0ms 0ms 0ms 07 51,771 0ms 0ms 0ms 0ms 0ms 0ms 08 51,784 0ms 0ms 0ms 0ms 0ms 0ms 09 51,878 0ms 0ms 0ms 0ms 0ms 0ms 10 51,858 0ms 0ms 0ms 0ms 0ms 0ms 11 51,898 0ms 0ms 0ms 0ms 0ms 0ms 12 51,747 0ms 0ms 0ms 0ms 0ms 0ms 13 51,728 0ms 0ms 0ms 0ms 0ms 0ms 14 51,580 0ms 0ms 0ms 0ms 0ms 0ms 15 51,596 0ms 0ms 0ms 0ms 0ms 0ms 16 51,765 0ms 0ms 0ms 0ms 0ms 0ms 17 51,869 0ms 0ms 0ms 0ms 0ms 0ms 18 51,853 0ms 0ms 0ms 0ms 0ms 0ms 19 51,849 0ms 0ms 0ms 0ms 0ms 0ms 20 52,898 0ms 0ms 0ms 0ms 0ms 0ms 21 51,769 0ms 0ms 0ms 0ms 0ms 0ms 22 51,818 0ms 0ms 0ms 0ms 0ms 0ms 23 1,528 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 02 00 17,152 0 0ms 0ms 0ms 0ms 01 17,146 0 0ms 0ms 0ms 0ms 02 17,158 0 0ms 0ms 0ms 0ms 03 17,136 0 0ms 0ms 0ms 0ms 04 17,166 0 0ms 0ms 0ms 0ms 05 17,157 0 0ms 0ms 0ms 0ms 06 17,132 0 0ms 0ms 0ms 0ms 07 17,137 0 0ms 0ms 0ms 0ms 08 17,155 0 0ms 0ms 0ms 0ms 09 17,146 0 0ms 0ms 0ms 0ms 10 17,165 0 0ms 0ms 0ms 0ms 11 17,132 0 0ms 0ms 0ms 0ms 12 17,186 0 0ms 0ms 0ms 0ms 13 17,224 0 0ms 0ms 0ms 0ms 14 17,145 0 0ms 0ms 0ms 0ms 15 17,135 0 0ms 0ms 0ms 0ms 16 17,133 0 0ms 0ms 0ms 0ms 17 17,146 0 0ms 0ms 0ms 0ms 18 17,151 0 0ms 0ms 0ms 0ms 19 17,140 0 0ms 0ms 0ms 0ms 20 17,858 0 0ms 0ms 0ms 0ms 21 17,133 0 0ms 0ms 0ms 0ms 22 17,143 0 0ms 0ms 0ms 0ms 23 394 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 02 00 6,889 744 88 0 0ms 0ms 0ms 0ms 01 6,918 744 88 0 0ms 0ms 0ms 0ms 02 6,911 744 88 0 0ms 0ms 0ms 0ms 03 6,908 744 88 0 0ms 0ms 0ms 0ms 04 6,918 744 88 0 0ms 0ms 0ms 0ms 05 6,887 744 88 0 0ms 0ms 0ms 0ms 06 6,895 744 88 0 0ms 0ms 0ms 0ms 07 6,894 744 89 0 0ms 0ms 0ms 0ms 08 6,903 744 88 0 0ms 0ms 0ms 0ms 09 6,907 744 88 0 0ms 0ms 0ms 0ms 10 6,904 744 88 0 0ms 0ms 0ms 0ms 11 6,922 745 88 0 0ms 0ms 0ms 0ms 12 6,891 744 87 0 0ms 0ms 0ms 0ms 13 6,875 744 88 0 0ms 0ms 0ms 0ms 14 6,876 744 88 0 0ms 0ms 0ms 0ms 15 6,878 744 88 0 0ms 0ms 0ms 0ms 16 6,897 744 88 0 0ms 0ms 0ms 0ms 17 6,902 744 88 0 0ms 0ms 0ms 0ms 18 6,911 744 88 0 0ms 0ms 0ms 0ms 19 6,906 744 88 0 0ms 0ms 0ms 0ms 20 6,901 761 88 0 0ms 0ms 0ms 0ms 21 6,903 744 88 0 0ms 0ms 0ms 0ms 22 6,900 744 88 0 0ms 0ms 0ms 0ms 23 275 17 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 02 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 02 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 2 0.00/s 09 1 0.00/s 10 1 0.00/s 11 1 0.00/s 12 3 0.00/s 13 5 0.00/s 14 1 0.00/s 15 1 0.00/s 16 1 0.00/s 17 1 0.00/s 18 1 0.00/s 19 1 0.00/s 20 28 0.01/s 21 1 0.00/s 22 1 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 02 00 1 1s945ms 1s945ms 01 1 1s767ms 1s767ms 02 1 1s686ms 1s686ms 03 1 1s855ms 1s855ms 04 2 1s360ms 1s360ms 05 2 1s245ms 1s245ms 06 1 1s960ms 1s960ms 07 1 1s791ms 1s791ms 08 2 1s445ms 1s445ms 09 1 1s659ms 1s659ms 10 1 1s885ms 1s885ms 11 1 1s705ms 1s705ms 12 3 1s201ms 1s201ms 13 5 1s183ms 1s183ms 14 1 1s867ms 1s867ms 15 1 1s685ms 1s685ms 16 1 1s729ms 1s729ms 17 1 1s671ms 1s671ms 18 1 1s680ms 1s680ms 19 1 1s661ms 1s661ms 20 28 1s898ms 1s898ms 21 1 1s969ms 1s969ms 22 1 1s851ms 1s851ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-07-02 20:27:45 Date
Connections per database
Key values
- zabbix Main Database
- 59 connections Total
Connections per user
Key values
- zabbix Main User
- 59 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2025-07-02 20:11:31 Date
Histogram of session times
Key values
- 52 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 59 sessions Total
Sessions per user
Key values
- zabbix Main User
- 59 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 59 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,123 buffers Checkpoint Peak
- 2025-07-02 18:27:35 Date
- 112.350 seconds Highest write time
- 0.010 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-07-02 17:21:02 Date
Checkpoints distance
Key values
- 3.99 Mo Distance Peak
- 2025-07-02 21:01:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 02 00 2,844 283.199s 0.034s 283.267s 01 2,596 258.364s 0.027s 258.426s 02 2,596 258.362s 0.035s 258.433s 03 2,755 274.185s 0.027s 274.247s 04 2,658 264.574s 0.03s 264.649s 05 2,595 258.364s 0.029s 258.422s 06 2,600 258.661s 0.031s 258.727s 07 2,600 258.864s 0.029s 258.924s 08 2,759 274.786s 0.032s 274.853s 09 2,619 260.665s 0.034s 260.736s 10 2,597 258.567s 0.028s 258.628s 11 2,634 262.169s 0.031s 262.233s 12 3,429 341.776s 0.03s 341.843s 13 2,646 263.372s 0.033s 263.439s 14 2,574 256.267s 0.029s 256.33s 15 2,659 264.671s 0.028s 264.736s 16 2,741 272.782s 0.032s 272.846s 17 2,655 264.29s 0.036s 264.359s 18 3,573 356.194s 0.032s 356.262s 19 2,595 258.375s 0.035s 258.442s 20 2,622 261.014s 0.03s 261.081s 21 2,768 275.492s 0.038s 275.564s 22 2,603 259.178s 0.039s 259.247s 23 343 34.051s 0.003s 34.057s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 02 00 0 0 1 227 0.003s 0.012s 01 0 0 1 221 0.002s 0.012s 02 0 0 0 224 0.003s 0.012s 03 0 0 1 224 0.002s 0.012s 04 0 0 1 221 0.002s 0.012s 05 0 0 1 222 0.002s 0.012s 06 0 0 1 220 0.002s 0.012s 07 0 0 1 220 0.002s 0.012s 08 0 0 0 230 0.002s 0.012s 09 0 0 1 223 0.003s 0.012s 10 0 0 1 225 0.002s 0.012s 11 0 0 1 223 0.002s 0.012s 12 0 0 1 230 0.002s 0.012s 13 0 0 1 227 0.002s 0.012s 14 0 0 0 222 0.002s 0.012s 15 0 0 1 225 0.002s 0.012s 16 0 0 1 224 0.002s 0.012s 17 0 0 1 217 0.002s 0.012s 18 0 0 1 222 0.002s 0.012s 19 0 0 0 222 0.002s 0.012s 20 0 0 1 230 0.002s 0.012s 21 0 0 1 224 0.003s 0.012s 22 0 0 1 215 0.003s 0.012s 23 0 0 0 28 0.002s 0.001s Day Hour Count Avg time (sec) Jul 02 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 02 00 994.83 kB 1,262.58 kB 01 1,086.25 kB 1,328.50 kB 02 1,220.17 kB 1,473.42 kB 03 1,295.92 kB 1,637.50 kB 04 1,008.08 kB 1,319.83 kB 05 1,016.92 kB 1,296.33 kB 06 1,144.25 kB 1,399.58 kB 07 1,266.50 kB 1,479.33 kB 08 1,070.42 kB 1,632.58 kB 09 989.75 kB 1,242.08 kB 10 1,112.67 kB 1,316.25 kB 11 1,257.25 kB 1,479.17 kB 12 1,224.33 kB 1,542.25 kB 13 998.42 kB 1,280.25 kB 14 1,071.33 kB 1,296.08 kB 15 1,219.08 kB 1,474.00 kB 16 1,294.08 kB 1,612.42 kB 17 1,015.92 kB 1,404.67 kB 18 1,020.50 kB 1,360.58 kB 19 1,130.00 kB 1,428.67 kB 20 1,270.00 kB 1,579.33 kB 21 1,105.17 kB 1,659.00 kB 22 985.67 kB 1,355.25 kB 23 1,761.00 kB 1,761.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 02 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 02 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
- 395,570 Total read queries
- 798,326 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,194,119 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,194,119 Requests
User Request type Count Duration zabbix Total 1,194,119 0ms delete 2,026 0ms insert 158,971 0ms others 223 0ms select 395,570 0ms tcl 620,182 0ms update 17,147 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,194,119 0ms delete 2,026 0ms insert 158,971 0ms others 223 0ms select 395,570 0ms tcl 620,182 0ms update 17,147 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,194,119 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,194,119 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-07-02 09:36:18 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,382 0ms 0ms 0ms select eventid, maintenanceid from event_suppress where suppress_until < ? and suppress_until <> ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 0ms 0ms 10 60 0ms 0ms 11 60 0ms 0ms 12 60 0ms 0ms 13 60 0ms 0ms 14 60 0ms 0ms 15 60 0ms 0ms 16 60 0ms 0ms 17 60 0ms 0ms 18 60 0ms 0ms 19 60 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 22 60 0ms 0ms 23 2 0ms 0ms 2 0ms 7,101 0ms 0ms 0ms select maintenanceid, hostid from maintenances_hosts order by maintenanceid;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 3 0ms 19 0ms 0ms 0ms select distinct i.itemid, i.hostid, i.key_, i.history, i.trends, i.value_type, i.units, i.valuemapid from hosts h, items i left join item_rtname irn on i.itemid = irn.itemid where i.flags in (...) and i.hostid in (...) and h.hostid = i.hostid and h.status = ? and i.status = ? and i.status = ? and irn.name_resolved = ? order by i.key_;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 02 20 19 0ms 0ms 4 0ms 36 0ms 0ms 0ms select configid, authentication_type, http_auth_enabled, http_login_form, http_strip_domains, http_case_sensitive, saml_auth_enabled, saml_case_sensitive, saml_jit_status, disabled_usrgrpid, mfa_status, mfaid, ldap_userdirectoryid from config;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 02 04 1 0ms 0ms 05 1 0ms 0ms 08 1 0ms 0ms 12 2 0ms 0ms 13 4 0ms 0ms 20 27 0ms 0ms 5 0ms 207 0ms 0ms 0ms select distinct g.graphid, g.name, g.width, g.height, g.yaxismin, g.yaxismax, g.show_work_period, g.show_triggers, g.graphtype, g.show_legend, g.show_3d, g.percent_left, g.percent_right, g.ymin_type, g.ymin_itemid, g.ymax_type, g.ymax_itemid, g.discover from graphs g, graphs_items gi, items i, item_discovery id where g.graphid = gi.graphid and gi.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 02 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 6 0ms 28,890 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 02 00 1,229 0ms 0ms 01 1,247 0ms 0ms 02 1,215 0ms 0ms 03 1,280 0ms 0ms 04 1,228 0ms 0ms 05 1,231 0ms 0ms 06 1,321 0ms 0ms 07 1,231 0ms 0ms 08 1,269 0ms 0ms 09 1,276 0ms 0ms 10 1,254 0ms 0ms 11 1,273 0ms 0ms 12 1,212 0ms 0ms 13 1,280 0ms 0ms 14 1,244 0ms 0ms 15 1,236 0ms 0ms 16 1,232 0ms 0ms 17 1,231 0ms 0ms 18 1,245 0ms 0ms 19 1,261 0ms 0ms 20 1,328 0ms 0ms 21 1,284 0ms 0ms 22 1,251 0ms 0ms 23 32 0ms 0ms 7 0ms 4 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 02 07 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 19 1 0ms 0ms 8 0ms 13 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 02 00 1 0ms 0ms 01 1 0ms 0ms 05 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 9 0ms 207 0ms 0ms 0ms select hm.macro, hm.value, hm.description, hm.type from hostmacro hm, items i where hm.hostid = i.hostid and i.itemid = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 02 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 10 0ms 207 0ms 0ms 0ms select ip.itemid, ip.step, ip.type, ip.params, ip.error_handler, ip.error_handler_params from item_preproc ip, item_discovery id where ip.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 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 11 0ms 7,101 0ms 0ms 0ms select globalmacroid, macro, value, type from globalmacro;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 309 0ms 0ms 18 308 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 12 0ms 59 0ms 0ms 0ms set bytea_output = escape;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 02 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 3 0ms 0ms 13 5 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 28 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 13 0ms 23 0ms 0ms 0ms select valuemapid, hostid from valuemap where valuemapid is null;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 20 23 0ms 0ms 14 0ms 184 0ms 0ms 0ms select functionid, triggerid, itemid, name, parameter from functions where triggerid in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 02 00 8 0ms 0ms 01 8 0ms 0ms 02 8 0ms 0ms 03 8 0ms 0ms 04 8 0ms 0ms 05 8 0ms 0ms 06 8 0ms 0ms 07 8 0ms 0ms 08 8 0ms 0ms 09 8 0ms 0ms 10 8 0ms 0ms 11 8 0ms 0ms 12 8 0ms 0ms 13 8 0ms 0ms 14 8 0ms 0ms 15 8 0ms 0ms 16 8 0ms 0ms 17 8 0ms 0ms 18 8 0ms 0ms 19 8 0ms 0ms 20 8 0ms 0ms 21 8 0ms 0ms 22 8 0ms 0ms 15 0ms 4,708 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 02 00 200 0ms 0ms 01 199 0ms 0ms 02 203 0ms 0ms 03 205 0ms 0ms 04 203 0ms 0ms 05 211 0ms 0ms 06 205 0ms 0ms 07 206 0ms 0ms 08 205 0ms 0ms 09 202 0ms 0ms 10 202 0ms 0ms 11 204 0ms 0ms 12 213 0ms 0ms 13 199 0ms 0ms 14 209 0ms 0ms 15 206 0ms 0ms 16 209 0ms 0ms 17 211 0ms 0ms 18 208 0ms 0ms 19 195 0ms 0ms 20 213 0ms 0ms 21 200 0ms 0ms 22 194 0ms 0ms 23 6 0ms 0ms 16 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 #16
Day Hour Count Duration Avg duration Jul 02 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 17 0ms 153 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 00 8 0ms 0ms 01 5 0ms 0ms 02 6 0ms 0ms 03 5 0ms 0ms 04 10 0ms 0ms 05 11 0ms 0ms 06 10 0ms 0ms 07 6 0ms 0ms 08 8 0ms 0ms 09 5 0ms 0ms 10 8 0ms 0ms 11 5 0ms 0ms 12 9 0ms 0ms 13 6 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms 16 11 0ms 0ms 17 4 0ms 0ms 18 9 0ms 0ms 19 5 0ms 0ms 20 9 0ms 0ms 21 4 0ms 0ms 22 1 0ms 0ms 18 0ms 4 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 04 1 0ms 0ms 06 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 19 0ms 1 0ms 0ms 0ms select han.ha_nodeid, han.name, han.address, han.port, han.lastaccess, han.status from ha_node han order by han.status desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 20 1 0ms 0ms 20 0ms 3 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 02 01 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 310,091 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 00 13,443 0ms 0ms 01 13,475 0ms 0ms 02 13,506 0ms 0ms 03 13,516 0ms 0ms 04 13,509 0ms 0ms 05 13,469 0ms 0ms 06 13,428 0ms 0ms 07 13,451 0ms 0ms 08 13,443 0ms 0ms 09 13,494 0ms 0ms 10 13,476 0ms 0ms 11 13,503 0ms 0ms 12 13,414 0ms 0ms 13 13,390 0ms 0ms 14 13,361 0ms 0ms 15 13,373 0ms 0ms 16 13,449 0ms 0ms 17 13,492 0ms 0ms 18 13,477 0ms 0ms 19 13,483 0ms 0ms 20 13,602 0ms 0ms 21 13,448 0ms 0ms 22 13,469 0ms 0ms 23 420 0ms 0ms 2 310,055 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 00 13,443 0ms 0ms 01 13,475 0ms 0ms 02 13,506 0ms 0ms 03 13,516 0ms 0ms 04 13,508 0ms 0ms 05 13,468 0ms 0ms 06 13,428 0ms 0ms 07 13,451 0ms 0ms 08 13,442 0ms 0ms 09 13,494 0ms 0ms 10 13,476 0ms 0ms 11 13,503 0ms 0ms 12 13,412 0ms 0ms 13 13,386 0ms 0ms 14 13,361 0ms 0ms 15 13,373 0ms 0ms 16 13,449 0ms 0ms 17 13,492 0ms 0ms 18 13,477 0ms 0ms 19 13,483 0ms 0ms 20 13,575 0ms 0ms 21 13,448 0ms 0ms 22 13,469 0ms 0ms 23 420 0ms 0ms 3 47,544 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 02 00 2,052 0ms 0ms 01 2,070 0ms 0ms 02 2,061 0ms 0ms 03 2,076 0ms 0ms 04 2,082 0ms 0ms 05 2,053 0ms 0ms 06 2,072 0ms 0ms 07 2,067 0ms 0ms 08 2,072 0ms 0ms 09 2,070 0ms 0ms 10 2,070 0ms 0ms 11 2,071 0ms 0ms 12 2,066 0ms 0ms 13 2,051 0ms 0ms 14 2,051 0ms 0ms 15 2,055 0ms 0ms 16 2,054 0ms 0ms 17 2,058 0ms 0ms 18 2,067 0ms 0ms 19 2,087 0ms 0ms 20 2,061 0ms 0ms 21 2,060 0ms 0ms 22 2,068 0ms 0ms 23 50 0ms 0ms 4 41,630 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 02 00 1,827 0ms 0ms 01 1,827 0ms 0ms 02 1,868 0ms 0ms 03 1,794 0ms 0ms 04 1,856 0ms 0ms 05 1,835 0ms 0ms 06 1,721 0ms 0ms 07 1,813 0ms 0ms 08 1,782 0ms 0ms 09 1,792 0ms 0ms 10 1,817 0ms 0ms 11 1,827 0ms 0ms 12 1,832 0ms 0ms 13 1,772 0ms 0ms 14 1,797 0ms 0ms 15 1,798 0ms 0ms 16 1,840 0ms 0ms 17 1,837 0ms 0ms 18 1,835 0ms 0ms 19 1,801 0ms 0ms 20 1,725 0ms 0ms 21 1,783 0ms 0ms 22 1,805 0ms 0ms 23 46 0ms 0ms 5 28,890 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 02 00 1,229 0ms 0ms 01 1,247 0ms 0ms 02 1,215 0ms 0ms 03 1,280 0ms 0ms 04 1,228 0ms 0ms 05 1,231 0ms 0ms 06 1,321 0ms 0ms 07 1,231 0ms 0ms 08 1,269 0ms 0ms 09 1,276 0ms 0ms 10 1,254 0ms 0ms 11 1,273 0ms 0ms 12 1,212 0ms 0ms 13 1,280 0ms 0ms 14 1,244 0ms 0ms 15 1,236 0ms 0ms 16 1,232 0ms 0ms 17 1,231 0ms 0ms 18 1,245 0ms 0ms 19 1,261 0ms 0ms 20 1,328 0ms 0ms 21 1,284 0ms 0ms 22 1,251 0ms 0ms 23 32 0ms 0ms 6 27,603 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 #6
Day Hour Count Duration Avg duration Jul 02 00 1,198 0ms 0ms 01 1,200 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,198 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,198 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,199 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,200 0ms 0ms 22 1,199 0ms 0ms 23 29 0ms 0ms 7 27,602 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 02 00 1,198 0ms 0ms 01 1,200 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,198 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,198 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,199 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 28 0ms 0ms 8 27,602 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 Jul 02 00 1,198 0ms 0ms 01 1,200 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,198 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,198 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,199 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 28 0ms 0ms 9 27,602 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 Jul 02 00 1,198 0ms 0ms 01 1,200 0ms 0ms 02 1,200 0ms 0ms 03 1,198 0ms 0ms 04 1,198 0ms 0ms 05 1,200 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,200 0ms 0ms 09 1,198 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,198 0ms 0ms 13 1,199 0ms 0ms 14 1,198 0ms 0ms 15 1,199 0ms 0ms 16 1,198 0ms 0ms 17 1,199 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,199 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 28 0ms 0ms 10 16,577 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 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 02 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 02 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 update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 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,576 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 02 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 17 0ms 0ms 15 10,155 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 02 00 432 0ms 0ms 01 445 0ms 0ms 02 439 0ms 0ms 03 437 0ms 0ms 04 442 0ms 0ms 05 433 0ms 0ms 06 436 0ms 0ms 07 454 0ms 0ms 08 446 0ms 0ms 09 448 0ms 0ms 10 440 0ms 0ms 11 438 0ms 0ms 12 442 0ms 0ms 13 436 0ms 0ms 14 429 0ms 0ms 15 438 0ms 0ms 16 444 0ms 0ms 17 447 0ms 0ms 18 451 0ms 0ms 19 439 0ms 0ms 20 432 0ms 0ms 21 442 0ms 0ms 22 454 0ms 0ms 23 11 0ms 0ms 16 8,241 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 02 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 357 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 357 0ms 0ms 21 358 0ms 0ms 22 358 0ms 0ms 23 9 0ms 0ms 17 7,101 0ms 0ms 0ms 0ms select maintenanceid, hostid from maintenances_hosts order by maintenanceid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 18 7,101 0ms 0ms 0ms 0ms select globalmacroid, macro, value, type from globalmacro;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 309 0ms 0ms 18 308 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 19 7,101 0ms 0ms 0ms 0ms select i.interfaceid, i.hostid, i.type, i.main, i.useip, i.ip, i.dns, i.port, i.available, i.disable_until, i.error, i.errors_from, s.version, s.bulk, s.community, s.securityname, s.securitylevel, s.authpassphrase, s.privpassphrase, s.authprotocol, s.privprotocol, s.contextname, s.max_repetitions from interface i left join interface_snmp s on i.interfaceid = s.interfaceid;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 20 7,101 0ms 0ms 0ms 0ms select hg.groupid, hg.hostid from hosts_groups hg, hosts h where hg.hostid = h.hostid and h.status in (...) and h.flags <> ? order by hg.groupid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 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,382 0ms select eventid, maintenanceid from event_suppress where suppress_until < ? and suppress_until <> ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 0ms 0ms 10 60 0ms 0ms 11 60 0ms 0ms 12 60 0ms 0ms 13 60 0ms 0ms 14 60 0ms 0ms 15 60 0ms 0ms 16 60 0ms 0ms 17 60 0ms 0ms 18 60 0ms 0ms 19 60 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 22 60 0ms 0ms 23 2 0ms 0ms 2 0ms 0ms 0ms 7,101 0ms select maintenanceid, hostid from maintenances_hosts order by maintenanceid;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 3 0ms 0ms 0ms 19 0ms select distinct i.itemid, i.hostid, i.key_, i.history, i.trends, i.value_type, i.units, i.valuemapid from hosts h, items i left join item_rtname irn on i.itemid = irn.itemid where i.flags in (...) and i.hostid in (...) and h.hostid = i.hostid and h.status = ? and i.status = ? and i.status = ? and irn.name_resolved = ? order by i.key_;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 02 20 19 0ms 0ms 4 0ms 0ms 0ms 36 0ms select configid, authentication_type, http_auth_enabled, http_login_form, http_strip_domains, http_case_sensitive, saml_auth_enabled, saml_case_sensitive, saml_jit_status, disabled_usrgrpid, mfa_status, mfaid, ldap_userdirectoryid from config;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 02 04 1 0ms 0ms 05 1 0ms 0ms 08 1 0ms 0ms 12 2 0ms 0ms 13 4 0ms 0ms 20 27 0ms 0ms 5 0ms 0ms 0ms 207 0ms select distinct g.graphid, g.name, g.width, g.height, g.yaxismin, g.yaxismax, g.show_work_period, g.show_triggers, g.graphtype, g.show_legend, g.show_3d, g.percent_left, g.percent_right, g.ymin_type, g.ymin_itemid, g.ymax_type, g.ymax_itemid, g.discover from graphs g, graphs_items gi, items i, item_discovery id where g.graphid = gi.graphid and gi.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 02 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 6 0ms 0ms 0ms 28,890 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 02 00 1,229 0ms 0ms 01 1,247 0ms 0ms 02 1,215 0ms 0ms 03 1,280 0ms 0ms 04 1,228 0ms 0ms 05 1,231 0ms 0ms 06 1,321 0ms 0ms 07 1,231 0ms 0ms 08 1,269 0ms 0ms 09 1,276 0ms 0ms 10 1,254 0ms 0ms 11 1,273 0ms 0ms 12 1,212 0ms 0ms 13 1,280 0ms 0ms 14 1,244 0ms 0ms 15 1,236 0ms 0ms 16 1,232 0ms 0ms 17 1,231 0ms 0ms 18 1,245 0ms 0ms 19 1,261 0ms 0ms 20 1,328 0ms 0ms 21 1,284 0ms 0ms 22 1,251 0ms 0ms 23 32 0ms 0ms 7 0ms 0ms 0ms 4 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 02 07 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 19 1 0ms 0ms 8 0ms 0ms 0ms 13 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 02 00 1 0ms 0ms 01 1 0ms 0ms 05 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 9 0ms 0ms 0ms 207 0ms select hm.macro, hm.value, hm.description, hm.type from hostmacro hm, items i where hm.hostid = i.hostid and i.itemid = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 02 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 10 0ms 0ms 0ms 207 0ms select ip.itemid, ip.step, ip.type, ip.params, ip.error_handler, ip.error_handler_params from item_preproc ip, item_discovery id where ip.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 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 11 0ms 0ms 0ms 7,101 0ms select globalmacroid, macro, value, type from globalmacro;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 02 00 309 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 308 0ms 0ms 08 309 0ms 0ms 09 308 0ms 0ms 10 309 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 310 0ms 0ms 14 308 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 309 0ms 0ms 18 308 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 7 0ms 0ms 12 0ms 0ms 0ms 59 0ms set bytea_output = escape;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 02 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 3 0ms 0ms 13 5 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 28 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 13 0ms 0ms 0ms 23 0ms select valuemapid, hostid from valuemap where valuemapid is null;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 20 23 0ms 0ms 14 0ms 0ms 0ms 184 0ms select functionid, triggerid, itemid, name, parameter from functions where triggerid in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 02 00 8 0ms 0ms 01 8 0ms 0ms 02 8 0ms 0ms 03 8 0ms 0ms 04 8 0ms 0ms 05 8 0ms 0ms 06 8 0ms 0ms 07 8 0ms 0ms 08 8 0ms 0ms 09 8 0ms 0ms 10 8 0ms 0ms 11 8 0ms 0ms 12 8 0ms 0ms 13 8 0ms 0ms 14 8 0ms 0ms 15 8 0ms 0ms 16 8 0ms 0ms 17 8 0ms 0ms 18 8 0ms 0ms 19 8 0ms 0ms 20 8 0ms 0ms 21 8 0ms 0ms 22 8 0ms 0ms 15 0ms 0ms 0ms 4,708 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 02 00 200 0ms 0ms 01 199 0ms 0ms 02 203 0ms 0ms 03 205 0ms 0ms 04 203 0ms 0ms 05 211 0ms 0ms 06 205 0ms 0ms 07 206 0ms 0ms 08 205 0ms 0ms 09 202 0ms 0ms 10 202 0ms 0ms 11 204 0ms 0ms 12 213 0ms 0ms 13 199 0ms 0ms 14 209 0ms 0ms 15 206 0ms 0ms 16 209 0ms 0ms 17 211 0ms 0ms 18 208 0ms 0ms 19 195 0ms 0ms 20 213 0ms 0ms 21 200 0ms 0ms 22 194 0ms 0ms 23 6 0ms 0ms 16 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 #16
Day Hour Count Duration Avg duration Jul 02 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 17 0ms 0ms 0ms 153 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 00 8 0ms 0ms 01 5 0ms 0ms 02 6 0ms 0ms 03 5 0ms 0ms 04 10 0ms 0ms 05 11 0ms 0ms 06 10 0ms 0ms 07 6 0ms 0ms 08 8 0ms 0ms 09 5 0ms 0ms 10 8 0ms 0ms 11 5 0ms 0ms 12 9 0ms 0ms 13 6 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms 16 11 0ms 0ms 17 4 0ms 0ms 18 9 0ms 0ms 19 5 0ms 0ms 20 9 0ms 0ms 21 4 0ms 0ms 22 1 0ms 0ms 18 0ms 0ms 0ms 4 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 04 1 0ms 0ms 06 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 19 0ms 0ms 0ms 1 0ms select han.ha_nodeid, han.name, han.address, han.port, han.lastaccess, han.status from ha_node han order by han.status desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 20 1 0ms 0ms 20 0ms 0ms 0ms 3 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 02 01 1 0ms 0ms 18 1 0ms 0ms 20 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 18,007 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 02 00 777 0ms 0ms 01 789 0ms 0ms 02 770 0ms 0ms 03 769 0ms 0ms 04 776 0ms 0ms 05 766 0ms 0ms 06 789 0ms 0ms 07 776 0ms 0ms 08 788 0ms 0ms 09 772 0ms 0ms 10 783 0ms 0ms 11 782 0ms 0ms 12 796 0ms 0ms 13 790 0ms 0ms 14 801 0ms 0ms 15 796 0ms 0ms 16 775 0ms 0ms 17 771 0ms 0ms 18 781 0ms 0ms 19 784 0ms 0ms 20 786 0ms 0ms 21 786 0ms 0ms 22 775 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,522,498 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 7 Max number of times the same event was reported
- 19 Total events found
Rank Times reported Error 1 7 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 02 02 1 03 1 04 2 05 1 22 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.154.242", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "free.ds", forward lookup not checked.
Date: 2025-07-02 02:37:52 Database: postgres Application: [unknown] User: root Remote: free.ds
Detail: Client IP address resolved to "242.154.38.34.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-07-02 04:54:27 Database: postgres Application: [unknown] User: postgres Remote: 242.154.38.34.bc.googleusercontent.com
2 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 02 13 1 16 1 19 1 20 1 3 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 02 13 2 19 1 20 1 4 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 02 13 1 19 1 20 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 Jul 02 18 1