pgBadger-
Global information
- Generated on Wed Jun 25 23:01:36 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-25.log
- Parsed 5,659,333 log entries in 1m35s
- Log start from 2025-06-25 00:00:00 to 2025-06-25 23:01:33
-
Overview
Global Stats
- 845 Number of unique normalized queries
- 1,299,460 Number of queries
- 0ms Total query duration
- 2025-06-25 00:00:00 First query
- 2025-06-25 23:01:33 Last query
- 168 queries/s at 2025-06-25 13:23:05 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 54 Number of events
- 9 Number of unique normalized events
- 30 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
- 3,198 Total number of sessions
- 11 sessions at 2025-06-25 14:30:50 Session peak
- 6h11m25s Total duration of sessions
- 6s968ms Average duration of sessions
- 406 Average queries per session
- 0ms Average queries duration per session
- 6s968ms Average idle time per session
- 3,198 Total number of connections
- 6 connections/s at 2025-06-25 13:38:24 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 168 queries/s Query Peak
- 2025-06-25 13:23:05 Date
SELECT Traffic
Key values
- 117 queries/s Query Peak
- 2025-06-25 05:21:47 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 70 queries/s Query Peak
- 2025-06-25 12:23:05 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 25 00 51,020 0ms 0ms 0ms 0ms 0ms 0ms 01 51,075 0ms 0ms 0ms 0ms 0ms 0ms 02 51,032 0ms 0ms 0ms 0ms 0ms 0ms 03 51,124 0ms 0ms 0ms 0ms 0ms 0ms 04 51,271 0ms 0ms 0ms 0ms 0ms 0ms 05 56,453 0ms 0ms 0ms 0ms 0ms 0ms 06 51,177 0ms 0ms 0ms 0ms 0ms 0ms 07 51,085 0ms 0ms 0ms 0ms 0ms 0ms 08 51,122 0ms 0ms 0ms 0ms 0ms 0ms 09 52,606 0ms 0ms 0ms 0ms 0ms 0ms 10 51,199 0ms 0ms 0ms 0ms 0ms 0ms 11 59,889 0ms 0ms 0ms 0ms 0ms 0ms 12 83,507 0ms 0ms 0ms 0ms 0ms 0ms 13 93,465 0ms 0ms 0ms 0ms 0ms 0ms 14 83,046 0ms 0ms 0ms 0ms 0ms 0ms 15 51,150 0ms 0ms 0ms 0ms 0ms 0ms 16 51,156 0ms 0ms 0ms 0ms 0ms 0ms 17 51,142 0ms 0ms 0ms 0ms 0ms 0ms 18 51,022 0ms 0ms 0ms 0ms 0ms 0ms 19 51,089 0ms 0ms 0ms 0ms 0ms 0ms 20 51,138 0ms 0ms 0ms 0ms 0ms 0ms 21 51,007 0ms 0ms 0ms 0ms 0ms 0ms 22 51,149 0ms 0ms 0ms 0ms 0ms 0ms 23 1,536 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 25 00 16,696 0 0ms 0ms 0ms 0ms 01 16,683 0 0ms 0ms 0ms 0ms 02 16,696 0 0ms 0ms 0ms 0ms 03 16,710 0 0ms 0ms 0ms 0ms 04 16,715 0 0ms 0ms 0ms 0ms 05 20,009 0 0ms 0ms 0ms 0ms 06 16,703 0 0ms 0ms 0ms 0ms 07 16,714 0 0ms 0ms 0ms 0ms 08 16,710 0 0ms 0ms 0ms 0ms 09 17,573 0 0ms 0ms 0ms 0ms 10 16,651 0 0ms 0ms 0ms 0ms 11 22,404 0 0ms 0ms 0ms 0ms 12 36,963 0 0ms 0ms 0ms 0ms 13 44,725 0 0ms 0ms 0ms 0ms 14 37,461 0 0ms 0ms 0ms 0ms 15 16,657 0 0ms 0ms 0ms 0ms 16 16,683 0 0ms 0ms 0ms 0ms 17 16,656 0 0ms 0ms 0ms 0ms 18 16,690 0 0ms 0ms 0ms 0ms 19 16,673 0 0ms 0ms 0ms 0ms 20 16,650 0 0ms 0ms 0ms 0ms 21 16,671 0 0ms 0ms 0ms 0ms 22 16,677 0 0ms 0ms 0ms 0ms 23 431 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 25 00 6,786 744 88 0 0ms 0ms 0ms 0ms 01 6,801 744 88 0 0ms 0ms 0ms 0ms 02 6,787 744 88 0 0ms 0ms 0ms 0ms 03 6,793 744 88 0 0ms 0ms 0ms 0ms 04 6,810 744 88 0 0ms 0ms 0ms 0ms 05 6,804 799 88 0 0ms 0ms 0ms 0ms 06 6,803 744 88 0 0ms 0ms 0ms 0ms 07 6,785 746 88 0 0ms 0ms 0ms 0ms 08 6,792 745 88 0 0ms 0ms 0ms 0ms 09 6,814 763 88 0 0ms 0ms 0ms 0ms 10 6,815 744 88 0 0ms 0ms 0ms 0ms 11 6,806 808 88 0 0ms 0ms 0ms 0ms 12 6,804 1,110 88 0 0ms 0ms 0ms 0ms 13 6,467 1,225 107 0 0ms 0ms 0ms 0ms 14 6,808 1,032 111 0 0ms 0ms 0ms 0ms 15 6,805 744 88 0 0ms 0ms 0ms 0ms 16 6,805 744 88 0 0ms 0ms 0ms 0ms 17 6,805 744 88 0 0ms 0ms 0ms 0ms 18 6,788 744 88 0 0ms 0ms 0ms 0ms 19 6,794 744 88 0 0ms 0ms 0ms 0ms 20 6,810 745 88 0 0ms 0ms 0ms 0ms 21 6,785 744 88 0 0ms 0ms 0ms 0ms 22 6,815 744 88 0 0ms 0ms 0ms 0ms 23 265 19 2 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 25 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 267 267.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 25 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 127 0.04/s 06 1 0.00/s 07 2 0.00/s 08 1 0.00/s 09 36 0.01/s 10 1 0.00/s 11 236 0.07/s 12 793 0.22/s 13 1,101 0.31/s 14 882 0.24/s 15 1 0.00/s 16 2 0.00/s 17 1 0.00/s 18 2 0.00/s 19 2 0.00/s 20 1 0.00/s 21 1 0.00/s 22 2 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 25 00 1 1s534ms 1s534ms 01 1 1s679ms 1s679ms 02 1 1s693ms 1s693ms 03 1 1s776ms 1s776ms 04 2 1s405ms 1s405ms 05 127 1s984ms 1s984ms 06 1 1s988ms 1s988ms 07 2 1s485ms 1s485ms 08 1 1s836ms 1s836ms 09 36 1s851ms 1s851ms 10 1 1s708ms 1s708ms 11 234 1s758ms 1s758ms 12 792 1s967ms 1s967ms 13 1,101 1s894ms 1s894ms 14 885 20s196ms 20s196ms 15 1 1s621ms 1s621ms 16 2 1s340ms 1s340ms 17 1 1s752ms 1s752ms 18 2 1s409ms 1s409ms 19 2 1s398ms 1s398ms 20 1 1s979ms 1s979ms 21 1 1s887ms 1s887ms 22 2 1s397ms 1s397ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-06-25 13:38:24 Date
Connections per database
Key values
- zabbix Main Database
- 3,198 connections Total
Connections per user
Key values
- zabbix Main User
- 3,198 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2025-06-25 14:30:50 Date
Histogram of session times
Key values
- 3,184 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 3,198 sessions Total
Sessions per user
Key values
- zabbix Main User
- 3,198 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 3,198 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 3,198 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 533 buffers Checkpoint Peak
- 2025-06-25 15:37:48 Date
- 53.073 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-25 14:17:12 Date
Checkpoints distance
Key values
- 3.16 Mo Distance Peak
- 2025-06-25 15:02:23 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 25 00 2,431 241.844s 0.039s 241.916s 01 2,364 235.232s 0.028s 235.296s 02 2,636 262.466s 0.032s 262.53s 03 2,673 266.074s 0.03s 266.138s 04 2,356 234.329s 0.03s 234.392s 05 2,508 249.652s 0.033s 249.717s 06 2,504 249.149s 0.039s 249.22s 07 2,626 261.468s 0.032s 261.531s 08 2,665 265.37s 0.027s 265.431s 09 2,411 239.737s 0.029s 239.801s 10 2,597 258.564s 0.028s 258.624s 11 2,516 250.356s 0.031s 250.42s 12 2,495 248.246s 0.038s 248.316s 13 2,843 282.994s 0.033s 283.064s 14 2,650 263.672s 0.033s 263.737s 15 2,862 284.999s 0.034s 285.064s 16 2,438 242.645s 0.032s 242.708s 17 2,366 235.336s 0.026s 235.395s 18 2,426 241.341s 0.029s 241.403s 19 2,491 247.952s 0.03s 248.014s 20 2,732 271.887s 0.025s 271.946s 21 2,359 234.733s 0.035s 234.804s 22 2,385 237.338s 0.026s 237.4s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 25 00 0 0 0 226 0.002s 0.012s 01 0 0 1 222 0.002s 0.012s 02 0 0 1 223 0.002s 0.012s 03 0 0 1 235 0.003s 0.012s 04 0 0 0 223 0.002s 0.012s 05 0 0 1 251 0.002s 0.012s 06 0 0 1 221 0.002s 0.012s 07 0 0 1 260 0.002s 0.012s 08 0 0 0 233 0.002s 0.012s 09 0 0 1 240 0.002s 0.012s 10 0 0 1 228 0.002s 0.012s 11 0 0 1 241 0.002s 0.012s 12 0 0 0 284 0.002s 0.012s 13 0 0 1 431 0.002s 0.012s 14 0 0 1 403 0.002s 0.012s 15 0 0 1 224 0.002s 0.012s 16 0 0 1 219 0.003s 0.012s 17 0 0 0 215 0.002s 0.012s 18 0 0 1 214 0.002s 0.012s 19 0 0 1 220 0.002s 0.012s 20 0 0 1 232 0.002s 0.012s 21 0 0 0 224 0.002s 0.012s 22 0 0 1 220 0.002s 0.012s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 25 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 25 00 1,079.58 kB 1,112.42 kB 01 1,188.08 kB 1,256.33 kB 02 967.00 kB 1,318.33 kB 03 931.83 kB 1,047.17 kB 04 1,013.08 kB 1,098.25 kB 05 1,177.08 kB 1,232.67 kB 06 1,070.17 kB 1,306.50 kB 07 901.42 kB 1,057.75 kB 08 982.33 kB 1,021.58 kB 09 1,094.50 kB 1,139.67 kB 10 1,160.00 kB 1,325.25 kB 11 919.83 kB 1,158.42 kB 12 982.25 kB 1,044.58 kB 13 1,122.50 kB 1,175.33 kB 14 1,270.08 kB 1,412.92 kB 15 1,007.25 kB 1,356.58 kB 16 910.25 kB 1,043.42 kB 17 991.17 kB 1,050.08 kB 18 1,126.25 kB 1,220.83 kB 19 1,088.25 kB 1,279.83 kB 20 882.33 kB 1,034.17 kB 21 959.92 kB 1,008.58 kB 22 1,078.08 kB 1,129.17 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 25 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 25 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
- 463,201 Total read queries
- 826,616 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,299,460 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,299,460 Requests
User Request type Count Duration zabbix Total 1,299,460 0ms delete 2,068 0ms insert 156,347 0ms others 9,643 0ms select 463,201 0ms tcl 649,793 0ms update 18,408 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,299,460 0ms delete 2,068 0ms insert 156,347 0ms others 9,643 0ms select 463,201 0ms tcl 649,793 0ms update 18,408 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,299,193 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,299,203 Requests
- 0ms (unknown)
- Main time consuming application
Application Request type Count Duration DBeaver 25.1.2 - Main Total 21 0ms others 2 0ms select 19 0ms DBeaver 25.1.2 - Metadata Total 227 0ms others 1 0ms select 226 0ms DBeaver 25.1.2 - Read PostgreSQL database list Total 4 0ms select 4 0ms PostgreSQL JDBC Driver Total 5 0ms others 5 0ms [unknown] Total 1,299,203 0ms delete 2,068 0ms insert 156,347 0ms others 9,635 0ms select 462,952 0ms tcl 649,793 0ms update 18,408 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-25 06:32:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750828864) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750828864) / ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 2 0ms 153 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 00 7 0ms 0ms 01 7 0ms 0ms 02 5 0ms 0ms 03 7 0ms 0ms 04 6 0ms 0ms 05 5 0ms 0ms 06 6 0ms 0ms 07 6 0ms 0ms 08 5 0ms 0ms 09 7 0ms 0ms 10 7 0ms 0ms 11 7 0ms 0ms 12 7 0ms 0ms 13 7 0ms 0ms 14 5 0ms 0ms 15 7 0ms 0ms 16 7 0ms 0ms 17 6 0ms 0ms 18 6 0ms 0ms 19 7 0ms 0ms 20 7 0ms 0ms 21 7 0ms 0ms 22 7 0ms 0ms 23 5 0ms 0ms 3 0ms 77 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 25 00 3 0ms 0ms 01 3 0ms 0ms 02 4 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 3 0ms 0ms 08 5 0ms 0ms 09 4 0ms 0ms 10 3 0ms 0ms 11 4 0ms 0ms 12 5 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 5 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms 20 5 0ms 0ms 21 3 0ms 0ms 22 4 0ms 0ms 4 0ms 26 0ms 0ms 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 25 00 2 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 5 0ms 1 0ms 0ms 0ms select t.sysmapuserid, t.sysmapid, t.userid from sysmap_user t where t.sysmapid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 6 0ms 6 0ms 0ms 0ms select st.selementid, st.triggerid, st.selement_triggerid from sysmap_element_trigger st, triggers tr where st.selementid = ? and st.triggerid = tr.triggerid order by tr.priority desc, st.selement_triggerid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 25 14 6 0ms 0ms 7 0ms 2 0ms 0ms 0ms select reltype from pg_catalog.pg_class where ? <> ? limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 25 11 2 0ms 0ms 8 0ms 1 0ms 0ms 0ms select am.oid, am.* from pg_catalog.pg_am am order by am.oid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 11 1 0ms 0ms 9 0ms 1 0ms 0ms 0ms delete from profiles where idx like ? and idx2 in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 10 0ms 4 0ms 0ms 0ms select h.hostid, h.host, h.name from hosts h where h.flags in (...) and h.status in (...) and (h.host = ? or h.name = ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 13 2 0ms 0ms 14 2 0ms 0ms 11 0ms 16 0ms 0ms 0ms update profiles set value_str = ?, type = ? where userid = ? and idx = ? and idx2 = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 25 05 1 0ms 0ms 11 1 0ms 0ms 13 6 0ms 0ms 14 8 0ms 0ms 12 0ms 5 0ms 0ms 0ms select h.hostid, h.status, h.name, h.maintenance_status, h.flags, hr.active_available from hosts h left join host_rtdata hr on h.hostid = hr.hostid where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 25 13 3 0ms 0ms 14 2 0ms 0ms 13 0ms 4 0ms 0ms 0ms select p.eventid, p.objectid, p.name, p.acknowledged, p.clock, p.r_clock, p.severity from problem p where p.source = ? and p.object = ? and ? = ? and not exists ( select null from event_suppress es where es.eventid = p.eventid) and p.cause_eventid is null and (p.r_eventid is null or p.r_clock > ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 25 14 4 0ms 0ms 14 0ms 321 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 00 15 0ms 0ms 01 13 0ms 0ms 02 13 0ms 0ms 03 13 0ms 0ms 04 13 0ms 0ms 05 13 0ms 0ms 06 12 0ms 0ms 07 14 0ms 0ms 08 13 0ms 0ms 09 15 0ms 0ms 10 14 0ms 0ms 11 14 0ms 0ms 12 14 0ms 0ms 13 13 0ms 0ms 14 12 0ms 0ms 15 13 0ms 0ms 16 14 0ms 0ms 17 14 0ms 0ms 18 11 0ms 0ms 19 15 0ms 0ms 20 14 0ms 0ms 21 13 0ms 0ms 22 13 0ms 0ms 23 13 0ms 0ms 15 0ms 14 0ms 0ms 0ms select nextid from ids where table_name = ? and field_name = ? for update;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 25 13 3 0ms 0ms 14 11 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 - 1750822203) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750822203) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 25 12 1 0ms 0ms 17 0ms 31 0ms 0ms 0ms select f.triggerid, i.hostid from functions f, items i where f.triggerid = ? and f.itemid = i.itemid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 25 05 18 0ms 0ms 13 13 0ms 0ms 18 0ms 3 0ms 0ms 0ms show search_path;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 11 3 0ms 0ms 19 0ms 2 0ms 0ms 0ms insert into profiles (profileid, userid, idx, value_int, type, idx2, value_str) values (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 13 2 0ms 0ms 20 0ms 18 0ms 0ms 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 324,896 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 00 13,350 0ms 0ms 01 13,377 0ms 0ms 02 13,356 0ms 0ms 03 13,392 0ms 0ms 04 13,453 0ms 0ms 05 14,185 0ms 0ms 06 13,417 0ms 0ms 07 13,372 0ms 0ms 08 13,391 0ms 0ms 09 13,629 0ms 0ms 10 13,448 0ms 0ms 11 14,535 0ms 0ms 12 18,081 0ms 0ms 13 18,818 0ms 0ms 14 17,493 0ms 0ms 15 13,425 0ms 0ms 16 13,414 0ms 0ms 17 13,422 0ms 0ms 18 13,352 0ms 0ms 19 13,391 0ms 0ms 20 13,420 0ms 0ms 21 13,357 0ms 0ms 22 13,409 0ms 0ms 23 409 0ms 0ms 2 321,753 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 00 13,351 0ms 0ms 01 13,377 0ms 0ms 02 13,356 0ms 0ms 03 13,392 0ms 0ms 04 13,452 0ms 0ms 05 14,061 0ms 0ms 06 13,417 0ms 0ms 07 13,371 0ms 0ms 08 13,391 0ms 0ms 09 13,594 0ms 0ms 10 13,448 0ms 0ms 11 14,306 0ms 0ms 12 17,289 0ms 0ms 13 17,724 0ms 0ms 14 16,628 0ms 0ms 15 13,426 0ms 0ms 16 13,413 0ms 0ms 17 13,422 0ms 0ms 18 13,351 0ms 0ms 19 13,390 0ms 0ms 20 13,420 0ms 0ms 21 13,357 0ms 0ms 22 13,407 0ms 0ms 23 410 0ms 0ms 3 47,401 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 25 00 2,069 0ms 0ms 01 2,045 0ms 0ms 02 2,054 0ms 0ms 03 2,051 0ms 0ms 04 2,072 0ms 0ms 05 2,071 0ms 0ms 06 2,082 0ms 0ms 07 2,064 0ms 0ms 08 2,059 0ms 0ms 09 2,079 0ms 0ms 10 2,070 0ms 0ms 11 2,055 0ms 0ms 12 2,066 0ms 0ms 13 1,928 0ms 0ms 14 2,051 0ms 0ms 15 2,080 0ms 0ms 16 2,076 0ms 0ms 17 2,067 0ms 0ms 18 2,068 0ms 0ms 19 2,051 0ms 0ms 20 2,067 0ms 0ms 21 2,051 0ms 0ms 22 2,072 0ms 0ms 23 53 0ms 0ms 4 42,238 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 25 00 1,832 0ms 0ms 01 1,844 0ms 0ms 02 1,901 0ms 0ms 03 1,930 0ms 0ms 04 1,880 0ms 0ms 05 1,815 0ms 0ms 06 1,913 0ms 0ms 07 1,818 0ms 0ms 08 1,830 0ms 0ms 09 1,840 0ms 0ms 10 1,865 0ms 0ms 11 1,864 0ms 0ms 12 1,732 0ms 0ms 13 1,667 0ms 0ms 14 1,736 0ms 0ms 15 1,839 0ms 0ms 16 1,897 0ms 0ms 17 1,845 0ms 0ms 18 1,861 0ms 0ms 19 1,858 0ms 0ms 20 1,836 0ms 0ms 21 1,793 0ms 0ms 22 1,798 0ms 0ms 23 44 0ms 0ms 5 28,658 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 25 00 1,225 0ms 0ms 01 1,270 0ms 0ms 02 1,178 0ms 0ms 03 1,169 0ms 0ms 04 1,216 0ms 0ms 05 1,267 0ms 0ms 06 1,170 0ms 0ms 07 1,244 0ms 0ms 08 1,255 0ms 0ms 09 1,256 0ms 0ms 10 1,245 0ms 0ms 11 1,235 0ms 0ms 12 1,356 0ms 0ms 13 1,244 0ms 0ms 14 1,346 0ms 0ms 15 1,251 0ms 0ms 16 1,191 0ms 0ms 17 1,261 0ms 0ms 18 1,208 0ms 0ms 19 1,227 0ms 0ms 20 1,246 0ms 0ms 21 1,275 0ms 0ms 22 1,291 0ms 0ms 23 32 0ms 0ms 6 27,598 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is 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 25 00 1,199 0ms 0ms 01 1,197 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,199 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,199 0ms 0ms 23 32 0ms 0ms 7 27,598 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is 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 25 00 1,199 0ms 0ms 01 1,197 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,199 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 31 0ms 0ms 8 27,598 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 00 1,199 0ms 0ms 01 1,197 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,199 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 31 0ms 0ms 9 27,598 0ms 0ms 0ms 0ms select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is 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 25 00 1,199 0ms 0ms 01 1,197 0ms 0ms 02 1,199 0ms 0ms 03 1,199 0ms 0ms 04 1,199 0ms 0ms 05 1,199 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,198 0ms 0ms 09 1,199 0ms 0ms 10 1,199 0ms 0ms 11 1,198 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,198 0ms 0ms 15 1,198 0ms 0ms 16 1,199 0ms 0ms 17 1,198 0ms 0ms 18 1,199 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,200 0ms 0ms 23 31 0ms 0ms 10 16,579 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 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 19 0ms 0ms 11 16,579 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 25 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 19 0ms 0ms 12 16,579 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 25 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 19 0ms 0ms 13 16,579 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 25 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 19 0ms 0ms 14 16,579 0ms 0ms 0ms 0ms select cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 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 19 0ms 0ms 15 10,122 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 25 00 442 0ms 0ms 01 429 0ms 0ms 02 451 0ms 0ms 03 435 0ms 0ms 04 449 0ms 0ms 05 433 0ms 0ms 06 433 0ms 0ms 07 441 0ms 0ms 08 426 0ms 0ms 09 429 0ms 0ms 10 441 0ms 0ms 11 437 0ms 0ms 12 440 0ms 0ms 13 423 0ms 0ms 14 436 0ms 0ms 15 449 0ms 0ms 16 450 0ms 0ms 17 451 0ms 0ms 18 451 0ms 0ms 19 435 0ms 0ms 20 437 0ms 0ms 21 445 0ms 0ms 22 449 0ms 0ms 23 10 0ms 0ms 16 8,244 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 25 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 359 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,111 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 #17
Day Hour Count Duration Avg duration Jun 25 00 310 0ms 0ms 01 309 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 309 0ms 0ms 12 307 0ms 0ms 13 307 0ms 0ms 14 307 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 309 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 18 7,111 0ms 0ms 0ms 0ms select actionid, eventsource, evaltype, formula from actions where eventsource <> ? and status = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 00 310 0ms 0ms 01 309 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 309 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 307 0ms 0ms 14 307 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 309 0ms 0ms 23 8 0ms 0ms 19 7,111 0ms 0ms 0ms 0ms select maintenancetagid, maintenanceid, operator, tag, value from maintenance_tag;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 00 310 0ms 0ms 01 309 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 310 0ms 0ms 08 310 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 307 0ms 0ms 14 307 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 309 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 20 7,111 0ms 0ms 0ms 0ms select cc.corr_conditionid, cc.correlationid, cc.type, cct.tag, cctv.tag, cctv.value, cctv.operator, ccg.groupid, ccg.operator, cctp.oldtag, cctp.newtag from correlation c, corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid = cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid = cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid = cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid = cc.corr_conditionid where c.correlationid = cc.correlationid and c.status = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 00 310 0ms 0ms 01 309 0ms 0ms 02 310 0ms 0ms 03 310 0ms 0ms 04 310 0ms 0ms 05 310 0ms 0ms 06 310 0ms 0ms 07 309 0ms 0ms 08 311 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 308 0ms 0ms 13 307 0ms 0ms 14 307 0ms 0ms 15 308 0ms 0ms 16 309 0ms 0ms 17 308 0ms 0ms 18 309 0ms 0ms 19 308 0ms 0ms 20 308 0ms 0ms 21 308 0ms 0ms 22 309 0ms 0ms 23 8 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 1 0ms select itemid, count(*) as count, avg(value) as avg, min(value) as min, max(value) as max, round(?.? * (clock - 1750828864) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750828864) / ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 2 0ms 0ms 0ms 153 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 00 7 0ms 0ms 01 7 0ms 0ms 02 5 0ms 0ms 03 7 0ms 0ms 04 6 0ms 0ms 05 5 0ms 0ms 06 6 0ms 0ms 07 6 0ms 0ms 08 5 0ms 0ms 09 7 0ms 0ms 10 7 0ms 0ms 11 7 0ms 0ms 12 7 0ms 0ms 13 7 0ms 0ms 14 5 0ms 0ms 15 7 0ms 0ms 16 7 0ms 0ms 17 6 0ms 0ms 18 6 0ms 0ms 19 7 0ms 0ms 20 7 0ms 0ms 21 7 0ms 0ms 22 7 0ms 0ms 23 5 0ms 0ms 3 0ms 0ms 0ms 77 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?.?), (?, ?, ?, ?.?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 25 00 3 0ms 0ms 01 3 0ms 0ms 02 4 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 3 0ms 0ms 08 5 0ms 0ms 09 4 0ms 0ms 10 3 0ms 0ms 11 4 0ms 0ms 12 5 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 5 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms 20 5 0ms 0ms 21 3 0ms 0ms 22 4 0ms 0ms 4 0ms 0ms 0ms 26 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 25 00 2 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 5 0ms 0ms 0ms 1 0ms select t.sysmapuserid, t.sysmapid, t.userid from sysmap_user t where t.sysmapid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 6 0ms 0ms 0ms 6 0ms select st.selementid, st.triggerid, st.selement_triggerid from sysmap_element_trigger st, triggers tr where st.selementid = ? and st.triggerid = tr.triggerid order by tr.priority desc, st.selement_triggerid;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 25 14 6 0ms 0ms 7 0ms 0ms 0ms 2 0ms select reltype from pg_catalog.pg_class where ? <> ? limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 25 11 2 0ms 0ms 8 0ms 0ms 0ms 1 0ms select am.oid, am.* from pg_catalog.pg_am am order by am.oid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 11 1 0ms 0ms 9 0ms 0ms 0ms 1 0ms delete from profiles where idx like ? and idx2 in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 25 14 1 0ms 0ms 10 0ms 0ms 0ms 4 0ms select h.hostid, h.host, h.name from hosts h where h.flags in (...) and h.status in (...) and (h.host = ? or h.name = ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 13 2 0ms 0ms 14 2 0ms 0ms 11 0ms 0ms 0ms 16 0ms update profiles set value_str = ?, type = ? where userid = ? and idx = ? and idx2 = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 25 05 1 0ms 0ms 11 1 0ms 0ms 13 6 0ms 0ms 14 8 0ms 0ms 12 0ms 0ms 0ms 5 0ms select h.hostid, h.status, h.name, h.maintenance_status, h.flags, hr.active_available from hosts h left join host_rtdata hr on h.hostid = hr.hostid where h.flags in (...) and h.hostid = ? and h.status in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 25 13 3 0ms 0ms 14 2 0ms 0ms 13 0ms 0ms 0ms 4 0ms select p.eventid, p.objectid, p.name, p.acknowledged, p.clock, p.r_clock, p.severity from problem p where p.source = ? and p.object = ? and ? = ? and not exists ( select null from event_suppress es where es.eventid = p.eventid) and p.cause_eventid is null and (p.r_eventid is null or p.r_clock > ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 25 14 4 0ms 0ms 14 0ms 0ms 0ms 321 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 00 15 0ms 0ms 01 13 0ms 0ms 02 13 0ms 0ms 03 13 0ms 0ms 04 13 0ms 0ms 05 13 0ms 0ms 06 12 0ms 0ms 07 14 0ms 0ms 08 13 0ms 0ms 09 15 0ms 0ms 10 14 0ms 0ms 11 14 0ms 0ms 12 14 0ms 0ms 13 13 0ms 0ms 14 12 0ms 0ms 15 13 0ms 0ms 16 14 0ms 0ms 17 14 0ms 0ms 18 11 0ms 0ms 19 15 0ms 0ms 20 14 0ms 0ms 21 13 0ms 0ms 22 13 0ms 0ms 23 13 0ms 0ms 15 0ms 0ms 0ms 14 0ms select nextid from ids where table_name = ? and field_name = ? for update;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 25 13 3 0ms 0ms 14 11 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 - 1750822203) / ?, ?) as i, max(clock) as clock from history where itemid = ? and clock >= ? and clock <= ? group by itemid, round(?.? * (clock - 1750822203) / ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 25 12 1 0ms 0ms 17 0ms 0ms 0ms 31 0ms select f.triggerid, i.hostid from functions f, items i where f.triggerid = ? and f.itemid = i.itemid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 25 05 18 0ms 0ms 13 13 0ms 0ms 18 0ms 0ms 0ms 3 0ms show search_path;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 11 3 0ms 0ms 19 0ms 0ms 0ms 2 0ms insert into profiles (profileid, userid, idx, value_int, type, idx2, value_str) values (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 13 2 0ms 0ms 20 0ms 0ms 0ms 18 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 09 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 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 16,350 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 25 00 718 0ms 0ms 01 720 0ms 0ms 02 721 0ms 0ms 03 718 0ms 0ms 04 695 0ms 0ms 05 699 0ms 0ms 06 707 0ms 0ms 07 712 0ms 0ms 08 705 0ms 0ms 09 705 0ms 0ms 10 703 0ms 0ms 11 710 0ms 0ms 12 706 0ms 0ms 13 679 0ms 0ms 14 714 0ms 0ms 15 707 0ms 0ms 16 715 0ms 0ms 17 710 0ms 0ms 18 720 0ms 0ms 19 708 0ms 0ms 20 711 0ms 0ms 21 714 0ms 0ms 22 721 0ms 0ms 23 32 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,747,139 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 48 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 30 Max number of times the same event was reported
- 54 Total events found
Rank Times reported Error 1 30 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 25 06 1 08 1 11 22 13 1 15 3 19 1 20 1 - FATAL: no pg_hba.conf entry for host "106.75.175.160", user "postgres", database "template0", no encryption
- FATAL: no pg_hba.conf entry for host "195.184.76.173", user "test", database "test", no encryption
- FATAL: no pg_hba.conf entry for host "5.188.230.152", user "root", database "postgres", no encryption
Detail: Client IP address resolved to "am2n2.shop", forward lookup not checked.
Date: 2025-06-25 06:25:33 Database: template0 Application: [unknown] User: postgres Remote: am2n2.shop
Detail: Client IP address resolved to "santana.probe.onyphe.net", forward lookup not checked.
Date: 2025-06-25 08:32:08 Database: test Application: [unknown] User: test Remote: santana.probe.onyphe.net
Detail: Client IP address resolved to "free.ds", forward lookup not checked.
Date: 2025-06-25 11:40:40 Database: postgres Application: [unknown] User: root Remote: free.ds
2 6 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 25 05 3 07 1 18 1 22 1 3 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 25 05 1 07 1 18 1 22 1 4 4 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 25 03 1 04 1 05 1 16 1 5 3 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 25 07 1 18 1 22 1 6 2 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 25 03 1 05 1 7 2 FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 25 06 2 8 2 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 25 14 2 9 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 25 07 1