pgBadger-
Global information
- Generated on Mon Jun 30 23:01:32 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-30.log
- Parsed 5,423,000 log entries in 1m31s
- Log start from 2025-06-30 00:00:00 to 2025-06-30 23:01:28
-
Overview
Global Stats
- 463 Number of unique normalized queries
- 1,216,250 Number of queries
- 0ms Total query duration
- 2025-06-30 00:00:00 First query
- 2025-06-30 23:01:28 Last query
- 178 queries/s at 2025-06-30 20:17:10 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 20,138 Number of events
- 10 Number of unique normalized events
- 20,124 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
- 562 Total number of sessions
- 6 sessions at 2025-06-30 20:20:07 Session peak
- 17m37s Total duration of sessions
- 1s881ms Average duration of sessions
- 2,164 Average queries per session
- 0ms Average queries duration per session
- 1s881ms Average idle time per session
- 562 Total number of connections
- 7 connections/s at 2025-06-30 20:17:09 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 178 queries/s Query Peak
- 2025-06-30 20:17:10 Date
SELECT Traffic
Key values
- 111 queries/s Query Peak
- 2025-06-30 20:03:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 72 queries/s Query Peak
- 2025-06-30 20:04: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) Jun 30 00 51,809 0ms 0ms 0ms 0ms 0ms 0ms 01 51,810 0ms 0ms 0ms 0ms 0ms 0ms 02 51,822 0ms 0ms 0ms 0ms 0ms 0ms 03 51,757 0ms 0ms 0ms 0ms 0ms 0ms 04 51,844 0ms 0ms 0ms 0ms 0ms 0ms 05 51,804 0ms 0ms 0ms 0ms 0ms 0ms 06 51,969 0ms 0ms 0ms 0ms 0ms 0ms 07 51,826 0ms 0ms 0ms 0ms 0ms 0ms 08 51,949 0ms 0ms 0ms 0ms 0ms 0ms 09 51,885 0ms 0ms 0ms 0ms 0ms 0ms 10 51,835 0ms 0ms 0ms 0ms 0ms 0ms 11 51,919 0ms 0ms 0ms 0ms 0ms 0ms 12 51,896 0ms 0ms 0ms 0ms 0ms 0ms 13 51,936 0ms 0ms 0ms 0ms 0ms 0ms 14 52,007 0ms 0ms 0ms 0ms 0ms 0ms 15 51,989 0ms 0ms 0ms 0ms 0ms 0ms 16 54,330 0ms 0ms 0ms 0ms 0ms 0ms 17 51,939 0ms 0ms 0ms 0ms 0ms 0ms 18 51,774 0ms 0ms 0ms 0ms 0ms 0ms 19 51,862 0ms 0ms 0ms 0ms 0ms 0ms 20 70,896 0ms 0ms 0ms 0ms 0ms 0ms 21 51,925 0ms 0ms 0ms 0ms 0ms 0ms 22 51,984 0ms 0ms 0ms 0ms 0ms 0ms 23 1,483 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 30 00 17,177 0 0ms 0ms 0ms 0ms 01 17,148 0 0ms 0ms 0ms 0ms 02 17,138 0 0ms 0ms 0ms 0ms 03 17,172 0 0ms 0ms 0ms 0ms 04 17,160 0 0ms 0ms 0ms 0ms 05 17,194 0 0ms 0ms 0ms 0ms 06 17,191 0 0ms 0ms 0ms 0ms 07 17,190 0 0ms 0ms 0ms 0ms 08 17,207 0 0ms 0ms 0ms 0ms 09 17,165 0 0ms 0ms 0ms 0ms 10 17,182 0 0ms 0ms 0ms 0ms 11 17,196 0 0ms 0ms 0ms 0ms 12 17,216 0 0ms 0ms 0ms 0ms 13 17,195 0 0ms 0ms 0ms 0ms 14 17,230 0 0ms 0ms 0ms 0ms 15 17,222 0 0ms 0ms 0ms 0ms 16 18,625 0 0ms 0ms 0ms 0ms 17 17,176 0 0ms 0ms 0ms 0ms 18 17,174 0 0ms 0ms 0ms 0ms 19 17,204 0 0ms 0ms 0ms 0ms 20 29,263 0 0ms 0ms 0ms 0ms 21 17,182 0 0ms 0ms 0ms 0ms 22 17,199 0 0ms 0ms 0ms 0ms 23 424 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 30 00 6,895 744 88 0 0ms 0ms 0ms 0ms 01 6,909 744 88 0 0ms 0ms 0ms 0ms 02 6,907 744 88 0 0ms 0ms 0ms 0ms 03 6,893 744 88 0 0ms 0ms 0ms 0ms 04 6,911 744 88 0 0ms 0ms 0ms 0ms 05 6,885 744 88 0 0ms 0ms 0ms 0ms 06 6,928 744 88 0 0ms 0ms 0ms 0ms 07 6,887 744 88 0 0ms 0ms 0ms 0ms 08 6,915 744 88 0 0ms 0ms 0ms 0ms 09 6,911 744 88 0 0ms 0ms 0ms 0ms 10 6,898 744 88 0 0ms 0ms 0ms 0ms 11 6,908 745 88 0 0ms 0ms 0ms 0ms 12 6,907 744 88 0 0ms 0ms 0ms 0ms 13 6,905 744 88 0 0ms 0ms 0ms 0ms 14 6,915 746 88 0 0ms 0ms 0ms 0ms 15 6,909 746 88 0 0ms 0ms 0ms 0ms 16 6,934 775 88 0 0ms 0ms 0ms 0ms 17 6,907 748 87 0 0ms 0ms 0ms 0ms 18 6,891 744 88 0 0ms 0ms 0ms 0ms 19 6,920 745 88 0 0ms 0ms 0ms 0ms 20 6,930 921 92 0 0ms 0ms 0ms 0ms 21 6,918 744 88 0 0ms 0ms 0ms 0ms 22 6,913 744 88 0 0ms 0ms 0ms 0ms 23 262 18 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 30 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 30 00 1 0.00/s 01 1 0.00/s 02 1 0.00/s 03 2 0.00/s 04 1 0.00/s 05 1 0.00/s 06 2 0.00/s 07 1 0.00/s 08 1 0.00/s 09 1 0.00/s 10 1 0.00/s 11 4 0.00/s 12 3 0.00/s 13 2 0.00/s 14 4 0.00/s 15 2 0.00/s 16 56 0.02/s 17 1 0.00/s 18 1 0.00/s 19 1 0.00/s 20 472 0.13/s 21 1 0.00/s 22 2 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 30 00 1 1s836ms 1s836ms 01 1 1s513ms 1s513ms 02 1 1s562ms 1s562ms 03 2 1s389ms 1s389ms 04 1 1s893ms 1s893ms 05 1 1s686ms 1s686ms 06 2 1s440ms 1s440ms 07 1 1s657ms 1s657ms 08 1 1s820ms 1s820ms 09 1 2s43ms 2s43ms 10 1 1s676ms 1s676ms 11 4 1s250ms 1s250ms 12 3 1s143ms 1s143ms 13 2 1s251ms 1s251ms 14 4 1s166ms 1s166ms 15 2 1s552ms 1s552ms 16 56 1s888ms 1s888ms 17 1 1s898ms 1s898ms 18 1 1s592ms 1s592ms 19 1 1s668ms 1s668ms 20 472 1s911ms 1s911ms 21 1 1s694ms 1s694ms 22 2 1s343ms 1s343ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2025-06-30 20:17:09 Date
Connections per database
Key values
- zabbix Main Database
- 562 connections Total
Connections per user
Key values
- zabbix Main User
- 562 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2025-06-30 20:20:07 Date
Histogram of session times
Key values
- 553 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 562 sessions Total
Sessions per user
Key values
- zabbix Main User
- 562 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 562 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,581 buffers Checkpoint Peak
- 2025-06-30 10:57:03 Date
- 158.213 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-30 03:19:34 Date
Checkpoints distance
Key values
- 3.97 Mo Distance Peak
- 2025-06-30 12:05:05 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 30 00 2,690 267.781s 0.028s 267.843s 01 3,187 317.546s 0.026s 317.607s 02 2,560 254.762s 0.027s 254.821s 03 2,691 267.877s 0.025s 267.936s 04 2,624 261.266s 0.028s 261.329s 05 2,599 258.763s 0.03s 258.824s 06 2,578 256.563s 0.029s 256.624s 07 2,553 254.06s 0.028s 254.119s 08 2,743 273.088s 0.029s 273.15s 09 2,602 259.067s 0.028s 259.126s 10 3,964 395.447s 0.031s 395.51s 11 2,578 256.56s 0.029s 256.62s 12 2,739 272.585s 0.032s 272.647s 13 2,875 286.302s 0.027s 286.36s 14 2,580 256.764s 0.032s 256.831s 15 2,807 279.394s 0.031s 279.462s 16 2,722 270.88s 0.031s 270.945s 17 2,404 239.338s 0.029s 239.397s 18 2,593 258.063s 0.031s 258.13s 19 2,613 260.166s 0.03s 260.228s 20 3,031 301.821s 0.036s 301.888s 21 2,737 272.48s 0.042s 272.555s 22 2,623 261.07s 0.034s 261.139s 23 212 21.138s 0.003s 21.144s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 30 00 0 0 1 226 0.002s 0.012s 01 0 0 0 222 0.002s 0.012s 02 0 0 1 218 0.002s 0.012s 03 0 0 1 226 0.002s 0.012s 04 0 0 1 218 0.002s 0.012s 05 0 0 1 223 0.002s 0.012s 06 0 0 0 227 0.002s 0.012s 07 0 0 1 216 0.002s 0.012s 08 0 0 1 230 0.002s 0.012s 09 0 0 1 220 0.002s 0.012s 10 0 0 1 225 0.004s 0.012s 11 0 0 1 228 0.002s 0.012s 12 0 0 0 227 0.003s 0.012s 13 0 0 1 220 0.002s 0.012s 14 0 0 1 229 0.003s 0.012s 15 0 0 1 225 0.002s 0.012s 16 0 0 1 235 0.002s 0.012s 17 0 0 0 202 0.002s 0.011s 18 0 0 1 210 0.003s 0.012s 19 0 0 1 242 0.002s 0.012s 20 0 0 1 288 0.003s 0.012s 21 0 0 1 223 0.003s 0.012s 22 0 0 0 226 0.002s 0.012s 23 0 0 1 23 0.002s 0.001s Day Hour Count Avg time (sec) Jun 30 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 30 00 971.42 kB 1,277.92 kB 01 1,026.08 kB 1,306.25 kB 02 1,153.83 kB 1,429.58 kB 03 1,267.67 kB 1,588.00 kB 04 981.67 kB 1,340.25 kB 05 995.67 kB 1,323.92 kB 06 1,119.75 kB 1,406.33 kB 07 1,248.17 kB 1,514.17 kB 08 1,110.67 kB 1,563.25 kB 09 996.92 kB 1,346.33 kB 10 1,114.83 kB 1,424.25 kB 11 1,228.00 kB 1,557.00 kB 12 1,206.58 kB 1,684.50 kB 13 988.17 kB 1,367.75 kB 14 1,015.75 kB 1,310.00 kB 15 1,147.33 kB 1,435.33 kB 16 1,277.50 kB 1,587.75 kB 17 975.18 kB 1,360.00 kB 18 987.58 kB 1,339.00 kB 19 1,117.67 kB 1,450.75 kB 20 1,268.42 kB 1,583.92 kB 21 1,173.25 kB 1,620.33 kB 22 1,000.00 kB 1,356.50 kB 23 1,037.00 kB 1,157.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 30 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
- 409,230 Total read queries
- 805,288 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,216,250 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,216,250 Requests
User Request type Count Duration zabbix Total 1,216,250 0ms delete 2,029 0ms insert 159,158 0ms others 1,732 0ms select 409,230 0ms tcl 626,753 0ms update 17,348 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,216,250 0ms delete 2,029 0ms insert 159,158 0ms others 1,732 0ms select 409,230 0ms tcl 626,753 0ms update 17,348 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,216,250 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,216,250 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-30 01:21:08 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 479 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 00 22 0ms 0ms 01 24 0ms 0ms 02 18 0ms 0ms 03 19 0ms 0ms 04 17 0ms 0ms 05 16 0ms 0ms 06 21 0ms 0ms 07 22 0ms 0ms 08 19 0ms 0ms 09 21 0ms 0ms 10 21 0ms 0ms 11 21 0ms 0ms 12 20 0ms 0ms 13 17 0ms 0ms 14 16 0ms 0ms 15 19 0ms 0ms 16 22 0ms 0ms 17 22 0ms 0ms 18 18 0ms 0ms 19 23 0ms 0ms 20 24 0ms 0ms 21 23 0ms 0ms 22 17 0ms 0ms 23 17 0ms 0ms 2 0ms 1 0ms 0ms 0ms insert into task_acknowledge (acknowledgeid, taskid) values (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 3 0ms 11 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 01 1 0ms 0ms 03 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 22 2 0ms 0ms 4 0ms 208 0ms 0ms 0ms select t.triggerid, t.description, t.expression, t.status, t.type, t.priority, t.comments, t.url, t.url_name, t.recovery_expression, t.recovery_mode, t.correlation_mode, t.correlation_tag, t.manual_close, t.opdata, t.discover, t.event_name from triggers t where t.triggerid in ( select distinct tg.triggerid from triggers tg, functions f, items i, item_discovery id where tg.triggerid = f.triggerid and f.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 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 10 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 5 0ms 2 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 17 1 0ms 0ms 6 0ms 208 0ms 0ms 0ms select lld_macro, path from lld_macro_path where itemid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 30 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 10 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 7 0ms 28 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 3 0ms 0ms 04 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 4 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 12 2 0ms 0ms 14 3 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 8 0ms 92 0ms 0ms 0ms select min(clock) from events where events.source = ? and events.object = ? and not exists ( select null from problem where events.eventid = problem.eventid) and not exists ( select null from problem where events.eventid = problem.r_eventid);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 30 00 4 0ms 0ms 01 4 0ms 0ms 02 4 0ms 0ms 03 4 0ms 0ms 04 4 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 4 0ms 0ms 08 4 0ms 0ms 09 4 0ms 0ms 10 4 0ms 0ms 11 4 0ms 0ms 12 4 0ms 0ms 13 4 0ms 0ms 14 4 0ms 0ms 15 4 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 19 4 0ms 0ms 20 4 0ms 0ms 21 4 0ms 0ms 22 4 0ms 0ms 9 0ms 4 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284903) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284903) / ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 30 20 4 0ms 0ms 10 0ms 3 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 04 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 11 0ms 1,338 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 00 58 0ms 0ms 01 57 0ms 0ms 02 59 0ms 0ms 03 62 0ms 0ms 04 65 0ms 0ms 05 62 0ms 0ms 06 59 0ms 0ms 07 62 0ms 0ms 08 61 0ms 0ms 09 59 0ms 0ms 10 58 0ms 0ms 11 56 0ms 0ms 12 61 0ms 0ms 13 61 0ms 0ms 14 42 0ms 0ms 15 57 0ms 0ms 16 62 0ms 0ms 17 61 0ms 0ms 18 57 0ms 0ms 19 56 0ms 0ms 20 50 0ms 0ms 21 53 0ms 0ms 22 58 0ms 0ms 23 2 0ms 0ms 12 0ms 1 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 03 1 0ms 0ms 13 0ms 10 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 07, ?.? e - 05), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 22 1 0ms 0ms 14 0ms 1,369 0ms 0ms 0ms select linkid, serviceupid, servicedownid from services_links;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 30 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 59 0ms 0ms 23 2 0ms 0ms 15 0ms 1 0ms 0ms 0ms select s.scriptid, s.name, s.command, s.host_access, s.usrgrpid, s.groupid, s.description, s.confirmation, s.type, s.execute_on, s.timeout, s.scope, s.port, s.authtype, s.username, s.password, s.publickey, s.privatekey, s.menu_path, s.url, s.new_window, s.manualinput, s.manualinput_prompt, s.manualinput_validator_type, s.manualinput_validator, s.manualinput_default_value from scripts s where (s.groupid in (...) or s.groupid is null) order by s.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 16 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284430) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284430) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 17 0ms 7 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 04 1 0ms 0ms 07 1 0ms 0ms 09 3 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284236) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284236) / ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 19 0ms 2 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284820) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284820) / ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 20 2 0ms 0ms 20 0ms 1 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 03 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 313,377 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 00 13,450 0ms 0ms 01 13,458 0ms 0ms 02 13,470 0ms 0ms 03 13,426 0ms 0ms 04 13,468 0ms 0ms 05 13,444 0ms 0ms 06 13,505 0ms 0ms 07 13,456 0ms 0ms 08 13,495 0ms 0ms 09 13,486 0ms 0ms 10 13,459 0ms 0ms 11 13,484 0ms 0ms 12 13,465 0ms 0ms 13 13,498 0ms 0ms 14 13,507 0ms 0ms 15 13,508 0ms 0ms 16 13,869 0ms 0ms 17 13,508 0ms 0ms 18 13,436 0ms 0ms 19 13,450 0ms 0ms 20 16,136 0ms 0ms 21 13,494 0ms 0ms 22 13,516 0ms 0ms 23 389 0ms 0ms 2 312,840 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 30 00 13,450 0ms 0ms 01 13,458 0ms 0ms 02 13,470 0ms 0ms 03 13,425 0ms 0ms 04 13,468 0ms 0ms 05 13,444 0ms 0ms 06 13,504 0ms 0ms 07 13,456 0ms 0ms 08 13,495 0ms 0ms 09 13,486 0ms 0ms 10 13,459 0ms 0ms 11 13,481 0ms 0ms 12 13,463 0ms 0ms 13 13,497 0ms 0ms 14 13,504 0ms 0ms 15 13,507 0ms 0ms 16 13,814 0ms 0ms 17 13,508 0ms 0ms 18 13,436 0ms 0ms 19 13,450 0ms 0ms 20 15,668 0ms 0ms 21 13,494 0ms 0ms 22 13,515 0ms 0ms 23 388 0ms 0ms 3 47,630 0ms 0ms 0ms 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 00 2,050 0ms 0ms 01 2,064 0ms 0ms 02 2,070 0ms 0ms 03 2,047 0ms 0ms 04 2,064 0ms 0ms 05 2,074 0ms 0ms 06 2,090 0ms 0ms 07 2,064 0ms 0ms 08 2,069 0ms 0ms 09 2,068 0ms 0ms 10 2,063 0ms 0ms 11 2,064 0ms 0ms 12 2,076 0ms 0ms 13 2,071 0ms 0ms 14 2,079 0ms 0ms 15 2,071 0ms 0ms 16 2,081 0ms 0ms 17 2,073 0ms 0ms 18 2,060 0ms 0ms 19 2,074 0ms 0ms 20 2,075 0ms 0ms 21 2,066 0ms 0ms 22 2,066 0ms 0ms 23 51 0ms 0ms 4 41,123 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 00 1,767 0ms 0ms 01 1,833 0ms 0ms 02 1,863 0ms 0ms 03 1,802 0ms 0ms 04 1,825 0ms 0ms 05 1,730 0ms 0ms 06 1,735 0ms 0ms 07 1,801 0ms 0ms 08 1,810 0ms 0ms 09 1,781 0ms 0ms 10 1,769 0ms 0ms 11 1,812 0ms 0ms 12 1,769 0ms 0ms 13 1,742 0ms 0ms 14 1,739 0ms 0ms 15 1,759 0ms 0ms 16 1,835 0ms 0ms 17 1,828 0ms 0ms 18 1,811 0ms 0ms 19 1,739 0ms 0ms 20 1,754 0ms 0ms 21 1,776 0ms 0ms 22 1,805 0ms 0ms 23 38 0ms 0ms 5 29,642 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 00 1,293 0ms 0ms 01 1,244 0ms 0ms 02 1,204 0ms 0ms 03 1,270 0ms 0ms 04 1,257 0ms 0ms 05 1,314 0ms 0ms 06 1,355 0ms 0ms 07 1,253 0ms 0ms 08 1,274 0ms 0ms 09 1,301 0ms 0ms 10 1,290 0ms 0ms 11 1,260 0ms 0ms 12 1,293 0ms 0ms 13 1,326 0ms 0ms 14 1,338 0ms 0ms 15 1,312 0ms 0ms 16 1,271 0ms 0ms 17 1,249 0ms 0ms 18 1,239 0ms 0ms 19 1,342 0ms 0ms 20 1,321 0ms 0ms 21 1,313 0ms 0ms 22 1,292 0ms 0ms 23 31 0ms 0ms 6 27,609 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 Jun 30 00 1,199 0ms 0ms 01 1,200 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,200 0ms 0ms 05 1,200 0ms 0ms 06 1,198 0ms 0ms 07 1,199 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,198 0ms 0ms 20 1,200 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 29 0ms 0ms 7 27,609 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 Jun 30 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,200 0ms 0ms 05 1,200 0ms 0ms 06 1,198 0ms 0ms 07 1,199 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,198 0ms 0ms 20 1,200 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 29 0ms 0ms 8 27,609 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 #8
Day Hour Count Duration Avg duration Jun 30 00 1,200 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,200 0ms 0ms 05 1,200 0ms 0ms 06 1,198 0ms 0ms 07 1,199 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,198 0ms 0ms 20 1,200 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 29 0ms 0ms 9 27,608 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 #9
Day Hour Count Duration Avg duration Jun 30 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,200 0ms 0ms 05 1,200 0ms 0ms 06 1,198 0ms 0ms 07 1,199 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,199 0ms 0ms 14 1,199 0ms 0ms 15 1,199 0ms 0ms 16 1,200 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,198 0ms 0ms 20 1,200 0ms 0ms 21 1,199 0ms 0ms 22 1,200 0ms 0ms 23 29 0ms 0ms 10 16,578 0ms 0ms 0ms 0ms select cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 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 update ha_node set lastaccess = cast(extract(epoch from now()) as int) where ha_nodeid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 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 select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 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 Jun 30 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 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 Jun 30 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,245 0ms 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 00 435 0ms 0ms 01 451 0ms 0ms 02 444 0ms 0ms 03 457 0ms 0ms 04 446 0ms 0ms 05 437 0ms 0ms 06 441 0ms 0ms 07 437 0ms 0ms 08 444 0ms 0ms 09 446 0ms 0ms 10 445 0ms 0ms 11 447 0ms 0ms 12 463 0ms 0ms 13 449 0ms 0ms 14 452 0ms 0ms 15 464 0ms 0ms 16 441 0ms 0ms 17 435 0ms 0ms 18 444 0ms 0ms 19 450 0ms 0ms 20 443 0ms 0ms 21 435 0ms 0ms 22 428 0ms 0ms 23 11 0ms 0ms 16 8,243 0ms 0ms 0ms 0ms select m.mediaid, m.mediatypeid, m.sendto from media m, users_groups u, config c, media_type mt where m.userid = u.userid and u.usrgrpid = c.alert_usrgrpid and m.mediatypeid = mt.mediatypeid and m.active = ? and mt.status = ? and mt.type <> ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 30 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,129 0ms 0ms 0ms 0ms select discovery_groupid, snmptrap_logging, severity_name_0, severity_name_1, severity_name_2, severity_name_3, severity_name_4, severity_name_5, hk_events_mode, hk_events_trigger, hk_events_internal, hk_events_discovery, hk_events_autoreg, hk_services_mode, hk_services, hk_audit_mode, hk_audit, hk_sessions_mode, hk_sessions, hk_history_mode, hk_history_global, hk_history, hk_trends_mode, hk_trends_global, hk_trends, default_inventory_mode, db_extension, autoreg_tls_accept, compression_status, compress_older, instanceid, default_timezone, hk_events_service, auditlog_enabled, timeout_zabbix_agent, timeout_simple_check, timeout_snmp_agent, timeout_external_check, timeout_db_monitor, timeout_http_agent, timeout_ssh_agent, timeout_telnet_agent, timeout_script, auditlog_mode, timeout_browser from config order by configid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 00 310 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 310 0ms 0ms 11 309 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 311 0ms 0ms 16 309 0ms 0ms 17 309 0ms 0ms 18 309 0ms 0ms 19 311 0ms 0ms 20 309 0ms 0ms 21 310 0ms 0ms 22 310 0ms 0ms 23 8 0ms 0ms 18 7,129 0ms 0ms 0ms 0ms select t.timeperiodid, t.timeperiod_type, t.every, t.month, t.dayofweek, t.day, t.start_time, t.period, t.start_date, m.maintenanceid from maintenances_windows m, timeperiods t where t.timeperiodid = m.timeperiodid;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 00 310 0ms 0ms 01 308 0ms 0ms 02 308 0ms 0ms 03 309 0ms 0ms 04 309 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 310 0ms 0ms 11 309 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 311 0ms 0ms 16 309 0ms 0ms 17 309 0ms 0ms 18 309 0ms 0ms 19 311 0ms 0ms 20 309 0ms 0ms 21 310 0ms 0ms 22 310 0ms 0ms 23 8 0ms 0ms 19 7,129 0ms 0ms 0ms 0ms select groupid, name from hstgrp where type = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 00 310 0ms 0ms 01 308 0ms 0ms 02 308 0ms 0ms 03 309 0ms 0ms 04 309 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 310 0ms 0ms 11 309 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 311 0ms 0ms 16 309 0ms 0ms 17 309 0ms 0ms 18 309 0ms 0ms 19 311 0ms 0ms 20 309 0ms 0ms 21 310 0ms 0ms 22 310 0ms 0ms 23 8 0ms 0ms 20 7,129 0ms 0ms 0ms 0ms select tls_psk_identity, tls_psk from config_autoreg_tls order by autoreg_tlsid;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 00 310 0ms 0ms 01 308 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 310 0ms 0ms 11 309 0ms 0ms 12 310 0ms 0ms 13 310 0ms 0ms 14 310 0ms 0ms 15 311 0ms 0ms 16 309 0ms 0ms 17 309 0ms 0ms 18 309 0ms 0ms 19 311 0ms 0ms 20 309 0ms 0ms 21 310 0ms 0ms 22 310 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 479 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 00 22 0ms 0ms 01 24 0ms 0ms 02 18 0ms 0ms 03 19 0ms 0ms 04 17 0ms 0ms 05 16 0ms 0ms 06 21 0ms 0ms 07 22 0ms 0ms 08 19 0ms 0ms 09 21 0ms 0ms 10 21 0ms 0ms 11 21 0ms 0ms 12 20 0ms 0ms 13 17 0ms 0ms 14 16 0ms 0ms 15 19 0ms 0ms 16 22 0ms 0ms 17 22 0ms 0ms 18 18 0ms 0ms 19 23 0ms 0ms 20 24 0ms 0ms 21 23 0ms 0ms 22 17 0ms 0ms 23 17 0ms 0ms 2 0ms 0ms 0ms 1 0ms insert into task_acknowledge (acknowledgeid, taskid) values (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 3 0ms 0ms 0ms 11 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 01 1 0ms 0ms 03 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 22 2 0ms 0ms 4 0ms 0ms 0ms 208 0ms select t.triggerid, t.description, t.expression, t.status, t.type, t.priority, t.comments, t.url, t.url_name, t.recovery_expression, t.recovery_mode, t.correlation_mode, t.correlation_tag, t.manual_close, t.opdata, t.discover, t.event_name from triggers t where t.triggerid in ( select distinct tg.triggerid from triggers tg, functions f, items i, item_discovery id where tg.triggerid = f.triggerid and f.itemid = i.itemid and i.itemid = id.itemid and id.parent_itemid = ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 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 10 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 5 0ms 0ms 0ms 2 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 17 1 0ms 0ms 6 0ms 0ms 0ms 208 0ms select lld_macro, path from lld_macro_path where itemid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 30 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 10 0ms 0ms 18 9 0ms 0ms 19 9 0ms 0ms 20 9 0ms 0ms 21 9 0ms 0ms 22 9 0ms 0ms 7 0ms 0ms 0ms 28 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 3 0ms 0ms 04 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 4 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 12 2 0ms 0ms 14 3 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 8 0ms 0ms 0ms 92 0ms select min(clock) from events where events.source = ? and events.object = ? and not exists ( select null from problem where events.eventid = problem.eventid) and not exists ( select null from problem where events.eventid = problem.r_eventid);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 30 00 4 0ms 0ms 01 4 0ms 0ms 02 4 0ms 0ms 03 4 0ms 0ms 04 4 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 4 0ms 0ms 08 4 0ms 0ms 09 4 0ms 0ms 10 4 0ms 0ms 11 4 0ms 0ms 12 4 0ms 0ms 13 4 0ms 0ms 14 4 0ms 0ms 15 4 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 19 4 0ms 0ms 20 4 0ms 0ms 21 4 0ms 0ms 22 4 0ms 0ms 9 0ms 0ms 0ms 4 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284903) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284903) / ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 30 20 4 0ms 0ms 10 0ms 0ms 0ms 3 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 04 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 11 0ms 0ms 0ms 1,338 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 00 58 0ms 0ms 01 57 0ms 0ms 02 59 0ms 0ms 03 62 0ms 0ms 04 65 0ms 0ms 05 62 0ms 0ms 06 59 0ms 0ms 07 62 0ms 0ms 08 61 0ms 0ms 09 59 0ms 0ms 10 58 0ms 0ms 11 56 0ms 0ms 12 61 0ms 0ms 13 61 0ms 0ms 14 42 0ms 0ms 15 57 0ms 0ms 16 62 0ms 0ms 17 61 0ms 0ms 18 57 0ms 0ms 19 56 0ms 0ms 20 50 0ms 0ms 21 53 0ms 0ms 22 58 0ms 0ms 23 2 0ms 0ms 12 0ms 0ms 0ms 1 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 03 1 0ms 0ms 13 0ms 0ms 0ms 10 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 07, ?.? e - 05), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 30 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 22 1 0ms 0ms 14 0ms 0ms 0ms 1,369 0ms select linkid, serviceupid, servicedownid from services_links;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 30 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 59 0ms 0ms 23 2 0ms 0ms 15 0ms 0ms 0ms 1 0ms select s.scriptid, s.name, s.command, s.host_access, s.usrgrpid, s.groupid, s.description, s.confirmation, s.type, s.execute_on, s.timeout, s.scope, s.port, s.authtype, s.username, s.password, s.publickey, s.privatekey, s.menu_path, s.url, s.new_window, s.manualinput, s.manualinput_prompt, s.manualinput_validator_type, s.manualinput_validator, s.manualinput_default_value from scripts s where (s.groupid in (...) or s.groupid is null) order by s.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 16 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284430) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284430) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 17 0ms 0ms 0ms 7 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 04 1 0ms 0ms 07 1 0ms 0ms 09 3 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284236) / ?, ?) as i, max(clock) as clock from history_uint where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284236) / ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 20 1 0ms 0ms 19 0ms 0ms 0ms 2 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1751284820) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1751284820) / ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 20 2 0ms 0ms 20 0ms 0ms 0ms 1 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 03 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 Jun 30 00 775 0ms 0ms 01 787 0ms 0ms 02 785 0ms 0ms 03 786 0ms 0ms 04 791 0ms 0ms 05 777 0ms 0ms 06 787 0ms 0ms 07 771 0ms 0ms 08 777 0ms 0ms 09 776 0ms 0ms 10 772 0ms 0ms 11 778 0ms 0ms 12 789 0ms 0ms 13 774 0ms 0ms 14 781 0ms 0ms 15 772 0ms 0ms 16 775 0ms 0ms 17 768 0ms 0ms 18 782 0ms 0ms 19 802 0ms 0ms 20 788 0ms 0ms 21 779 0ms 0ms 22 772 0ms 0ms 23 38 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,630,053 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20137 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 20,124 Max number of times the same event was reported
- 20,138 Total events found
Rank Times reported Error 1 20,124 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 30 00 2 08 1 12 3,165 13 6,008 14 5,538 15 5,410 - FATAL: no pg_hba.conf entry for host "34.78.69.184", user "postgres", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "112.133.246.73", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "184.69.78.34.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-06-30 00:21:31 Database: postgres Application: [unknown] User: postgres Remote: 184.69.78.34.bc.googleusercontent.com
Detail: Client IP address resolved to "ws73-246.133.112.rcil.gov.in", forward lookup not checked.
Date: 2025-06-30 12:28:44 Database: postgres Application: [unknown] User: postgres Remote: ws73-246.133.112.rcil.gov.in
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 Jun 30 04 1 13 3 3 2 FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 30 14 2 4 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 30 04 1 13 1 5 1 FATAL: unsupported frontend protocol 30067.25970: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 30 14 1 6 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 30 14 1 7 1 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 30 04 1 8 1 FATAL: unsupported frontend protocol 1234.5632: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 30 12 1 9 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 30 13 1 10 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 30 13 1