pgBadger-
Global information
- Generated on Fri Jun 27 23:01:28 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql-2025-06-27.log
- Parsed 5,149,013 log entries in 1m27s
- Log start from 2025-06-27 00:00:00 to 2025-06-27 23:01:25
-
Overview
Global Stats
- 280 Number of unique normalized queries
- 1,180,884 Number of queries
- 0ms Total query duration
- 2025-06-27 00:00:00 First query
- 2025-06-27 23:01:25 Last query
- 158 queries/s at 2025-06-27 18:39:58 Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 11 Number of events
- 6 Number of unique normalized events
- 3 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
- 131 Total number of sessions
- 6 sessions at 2025-06-27 18:25:27 Session peak
- 4m7s Total duration of sessions
- 1s887ms Average duration of sessions
- 9,014 Average queries per session
- 0ms Average queries duration per session
- 1s887ms Average idle time per session
- 131 Total number of connections
- 6 connections/s at 2025-06-27 18:23:11 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 158 queries/s Query Peak
- 2025-06-27 18:39:58 Date
SELECT Traffic
Key values
- 108 queries/s Query Peak
- 2025-06-27 18:39:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 66 queries/s Query Peak
- 2025-06-27 18:39:58 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 27 00 51,200 0ms 0ms 0ms 0ms 0ms 0ms 01 51,218 0ms 0ms 0ms 0ms 0ms 0ms 02 51,325 0ms 0ms 0ms 0ms 0ms 0ms 03 51,104 0ms 0ms 0ms 0ms 0ms 0ms 04 51,138 0ms 0ms 0ms 0ms 0ms 0ms 05 51,051 0ms 0ms 0ms 0ms 0ms 0ms 06 51,022 0ms 0ms 0ms 0ms 0ms 0ms 07 50,999 0ms 0ms 0ms 0ms 0ms 0ms 08 51,063 0ms 0ms 0ms 0ms 0ms 0ms 09 51,089 0ms 0ms 0ms 0ms 0ms 0ms 10 51,107 0ms 0ms 0ms 0ms 0ms 0ms 11 51,147 0ms 0ms 0ms 0ms 0ms 0ms 12 51,170 0ms 0ms 0ms 0ms 0ms 0ms 13 51,079 0ms 0ms 0ms 0ms 0ms 0ms 14 50,994 0ms 0ms 0ms 0ms 0ms 0ms 15 50,982 0ms 0ms 0ms 0ms 0ms 0ms 16 51,050 0ms 0ms 0ms 0ms 0ms 0ms 17 51,112 0ms 0ms 0ms 0ms 0ms 0ms 18 55,221 0ms 0ms 0ms 0ms 0ms 0ms 19 51,173 0ms 0ms 0ms 0ms 0ms 0ms 20 51,179 0ms 0ms 0ms 0ms 0ms 0ms 21 51,042 0ms 0ms 0ms 0ms 0ms 0ms 22 50,955 0ms 0ms 0ms 0ms 0ms 0ms 23 1,464 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 27 00 16,652 0 0ms 0ms 0ms 0ms 01 16,685 0 0ms 0ms 0ms 0ms 02 16,676 0 0ms 0ms 0ms 0ms 03 16,664 0 0ms 0ms 0ms 0ms 04 16,669 0 0ms 0ms 0ms 0ms 05 16,656 0 0ms 0ms 0ms 0ms 06 16,683 0 0ms 0ms 0ms 0ms 07 16,662 0 0ms 0ms 0ms 0ms 08 16,664 0 0ms 0ms 0ms 0ms 09 16,724 0 0ms 0ms 0ms 0ms 10 16,648 0 0ms 0ms 0ms 0ms 11 16,660 0 0ms 0ms 0ms 0ms 12 16,716 0 0ms 0ms 0ms 0ms 13 16,655 0 0ms 0ms 0ms 0ms 14 16,670 0 0ms 0ms 0ms 0ms 15 16,655 0 0ms 0ms 0ms 0ms 16 16,652 0 0ms 0ms 0ms 0ms 17 16,648 0 0ms 0ms 0ms 0ms 18 19,272 0 0ms 0ms 0ms 0ms 19 16,651 0 0ms 0ms 0ms 0ms 20 16,681 0 0ms 0ms 0ms 0ms 21 16,648 0 0ms 0ms 0ms 0ms 22 16,655 0 0ms 0ms 0ms 0ms 23 380 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 27 00 6,816 744 88 0 0ms 0ms 0ms 0ms 01 6,818 744 88 0 0ms 0ms 0ms 0ms 02 6,832 744 88 0 0ms 0ms 0ms 0ms 03 6,801 744 88 0 0ms 0ms 0ms 0ms 04 6,808 744 88 0 0ms 0ms 0ms 0ms 05 6,798 744 88 0 0ms 0ms 0ms 0ms 06 6,789 744 88 0 0ms 0ms 0ms 0ms 07 6,800 744 88 0 0ms 0ms 0ms 0ms 08 6,792 744 87 0 0ms 0ms 0ms 0ms 09 6,795 744 88 0 0ms 0ms 0ms 0ms 10 6,806 744 88 0 0ms 0ms 0ms 0ms 11 6,801 745 88 0 0ms 0ms 0ms 0ms 12 6,808 744 88 0 0ms 0ms 0ms 0ms 13 6,801 744 88 0 0ms 0ms 0ms 0ms 14 6,785 746 88 0 0ms 0ms 0ms 0ms 15 6,784 746 88 0 0ms 0ms 0ms 0ms 16 6,799 744 88 0 0ms 0ms 0ms 0ms 17 6,803 744 88 0 0ms 0ms 0ms 0ms 18 6,801 787 88 0 0ms 0ms 0ms 0ms 19 6,811 744 88 0 0ms 0ms 0ms 0ms 20 6,807 744 88 0 0ms 0ms 0ms 0ms 21 6,795 744 88 0 0ms 0ms 0ms 0ms 22 6,778 744 87 0 0ms 0ms 0ms 0ms 23 258 17 3 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 27 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 27 00 1 0.00/s 01 1 0.00/s 02 1 0.00/s 03 1 0.00/s 04 1 0.00/s 05 1 0.00/s 06 2 0.00/s 07 1 0.00/s 08 2 0.00/s 09 4 0.00/s 10 1 0.00/s 11 1 0.00/s 12 4 0.00/s 13 1 0.00/s 14 1 0.00/s 15 1 0.00/s 16 1 0.00/s 17 1 0.00/s 18 101 0.03/s 19 1 0.00/s 20 1 0.00/s 21 1 0.00/s 22 1 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 27 00 1 1s673ms 1s673ms 01 1 1s890ms 1s890ms 02 1 1s665ms 1s665ms 03 1 2s1ms 2s1ms 04 1 1s964ms 1s964ms 05 1 1s796ms 1s796ms 06 2 1s367ms 1s367ms 07 1 1s719ms 1s719ms 08 2 1s289ms 1s289ms 09 4 1s180ms 1s180ms 10 1 1s778ms 1s778ms 11 1 1s931ms 1s931ms 12 4 1s268ms 1s268ms 13 1 1s693ms 1s693ms 14 1 1s716ms 1s716ms 15 1 1s618ms 1s618ms 16 1 1s704ms 1s704ms 17 1 2s35ms 2s35ms 18 101 1s976ms 1s976ms 19 1 1s721ms 1s721ms 20 1 1s694ms 1s694ms 21 1 2s145ms 2s145ms 22 1 1s819ms 1s819ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2025-06-27 18:23:11 Date
Connections per database
Key values
- zabbix Main Database
- 131 connections Total
Connections per user
Key values
- zabbix Main User
- 131 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2025-06-27 18:25:27 Date
Histogram of session times
Key values
- 125 1000-30000ms duration
Sessions per database
Key values
- zabbix Main Database
- 131 sessions Total
Sessions per user
Key values
- zabbix Main User
- 131 sessions Total
Sessions per host
Key values
- k8smaster01 Main Host
- 131 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 996 buffers Checkpoint Peak
- 2025-06-27 12:59:34 Date
- 99.434 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-06-27 06:48:02 Date
Checkpoints distance
Key values
- 3.09 Mo Distance Peak
- 2025-06-27 10:03:17 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 27 00 2,377 236.533s 0.028s 236.595s 01 2,484 247.247s 0.036s 247.316s 02 2,473 246.049s 0.033s 246.114s 03 2,391 237.836s 0.027s 237.894s 04 2,755 274.284s 0.036s 274.352s 05 2,513 250.054s 0.03s 250.115s 06 2,811 279.993s 0.027s 280.052s 07 2,425 241.341s 0.028s 241.403s 08 2,394 238.041s 0.026s 238.102s 09 2,417 240.538s 0.028s 240.603s 10 2,525 251.353s 0.03s 251.413s 11 2,789 277.588s 0.032s 277.651s 12 3,277 326.356s 0.034s 326.422s 13 2,391 237.84s 0.039s 237.908s 14 2,478 246.651s 0.035s 246.718s 15 2,475 246.349s 0.033s 246.414s 16 2,394 238.14s 0.027s 238.199s 17 2,407 239.443s 0.027s 239.505s 18 2,450 243.843s 0.029s 243.905s 19 2,983 296.917s 0.028s 296.98s 20 2,419 240.741s 0.032s 240.803s 21 2,381 236.935s 0.027s 236.997s 22 2,409 239.542s 0.029s 239.605s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 27 00 0 0 1 221 0.002s 0.012s 01 0 0 1 222 0.002s 0.012s 02 0 0 1 218 0.004s 0.012s 03 0 0 0 224 0.002s 0.012s 04 0 0 1 228 0.003s 0.012s 05 0 0 1 217 0.002s 0.012s 06 0 0 1 225 0.002s 0.012s 07 0 0 0 228 0.002s 0.012s 08 0 0 1 223 0.002s 0.012s 09 0 0 1 222 0.004s 0.012s 10 0 0 1 220 0.002s 0.012s 11 0 0 0 220 0.002s 0.012s 12 0 0 1 222 0.002s 0.012s 13 0 0 1 220 0.003s 0.012s 14 0 0 1 222 0.002s 0.012s 15 0 0 0 226 0.002s 0.012s 16 0 0 1 217 0.002s 0.012s 17 0 0 1 212 0.002s 0.012s 18 0 0 1 236 0.002s 0.012s 19 0 0 1 213 0.002s 0.012s 20 0 0 0 217 0.002s 0.012s 21 0 0 1 214 0.002s 0.012s 22 0 0 1 214 0.004s 0.012s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 27 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 27 00 1,081.92 kB 1,197.83 kB 01 1,215.33 kB 1,391.42 kB 02 940.42 kB 1,202.67 kB 03 950.08 kB 1,064.50 kB 04 1,089.75 kB 1,227.33 kB 05 1,184.17 kB 1,341.00 kB 06 1,049.92 kB 1,305.83 kB 07 909.00 kB 1,046.75 kB 08 999.83 kB 1,136.92 kB 09 1,131.00 kB 1,305.08 kB 10 1,135.42 kB 1,414.08 kB 11 903.67 kB 1,103.75 kB 12 963.92 kB 1,104.08 kB 13 1,072.75 kB 1,235.42 kB 14 1,212.08 kB 1,367.17 kB 15 954.42 kB 1,230.58 kB 16 952.17 kB 1,162.33 kB 17 1,082.42 kB 1,248.83 kB 18 1,197.83 kB 1,369.25 kB 19 1,071.25 kB 1,344.58 kB 20 902.92 kB 1,064.50 kB 21 988.42 kB 1,134.17 kB 22 1,117.58 kB 1,309.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 27 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 27 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
- 386,326 Total read queries
- 794,119 Total write queries
Queries by database
Key values
- zabbix Main database
- 1,180,884 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- zabbix Main user
- 1,180,884 Requests
User Request type Count Duration zabbix Total 1,180,884 0ms delete 2,025 0ms insert 156,686 0ms others 439 0ms select 386,326 0ms tcl 618,231 0ms update 17,177 0ms Duration by user
Key values
- 0ms (unknown) Main time consuming user
User Request type Count Duration zabbix Total 1,180,884 0ms delete 2,025 0ms insert 156,686 0ms others 439 0ms select 386,326 0ms tcl 618,231 0ms update 17,177 0ms Queries by host
Key values
- k8smaster01 Main host
- 1,180,884 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,180,884 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-27 02:46:05 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 207 0ms 0ms 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 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 2 0ms 108 0ms 0ms 0ms select configid, session_key, dbversion_status, server_status, software_update_checkid, software_update_check_data from config;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 06 1 0ms 0ms 08 1 0ms 0ms 09 3 0ms 0ms 12 3 0ms 0ms 18 100 0ms 0ms 3 0ms 23 0ms 0ms 0ms set escape_string_warning to off;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 27 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 4 0ms 184 0ms 0ms 0ms select triggertagid, triggerid, tag, value from trigger_tag where triggerid in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 27 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 5 0ms 23 0ms 0ms 0ms select housekeeperid, tablename, field, value from housekeeper where tablename in (...) order by tablename;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 27 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 6 0ms 1 0ms 0ms 0ms select count(*) from users;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 7 0ms 26 0ms 0ms 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 27 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 8 0ms 1,623 0ms 0ms 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 27 00 70 0ms 0ms 01 75 0ms 0ms 02 76 0ms 0ms 03 70 0ms 0ms 04 72 0ms 0ms 05 75 0ms 0ms 06 69 0ms 0ms 07 70 0ms 0ms 08 70 0ms 0ms 09 72 0ms 0ms 10 72 0ms 0ms 11 70 0ms 0ms 12 73 0ms 0ms 13 68 0ms 0ms 14 72 0ms 0ms 15 68 0ms 0ms 16 75 0ms 0ms 17 65 0ms 0ms 18 66 0ms 0ms 19 67 0ms 0ms 20 67 0ms 0ms 21 77 0ms 0ms 22 63 0ms 0ms 23 1 0ms 0ms 9 0ms 12 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 #9
Day Hour Count Duration Avg duration Jun 27 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 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 10 0ms 1 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 27 02 1 0ms 0ms 11 0ms 1,154 0ms 0ms 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 27 00 52 0ms 0ms 01 51 0ms 0ms 02 52 0ms 0ms 03 52 0ms 0ms 04 50 0ms 0ms 05 49 0ms 0ms 06 50 0ms 0ms 07 50 0ms 0ms 08 50 0ms 0ms 09 47 0ms 0ms 10 51 0ms 0ms 11 51 0ms 0ms 12 52 0ms 0ms 13 50 0ms 0ms 14 49 0ms 0ms 15 49 0ms 0ms 16 47 0ms 0ms 17 52 0ms 0ms 18 49 0ms 0ms 19 50 0ms 0ms 20 52 0ms 0ms 21 48 0ms 0ms 22 51 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 27 13 1 0ms 0ms 13 0ms 1 0ms 0ms 0ms select d.dashboardid, d.name, d.userid, d.display_period, d.auto_start from dashboard d where d.templateid is null and d.dashboardid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 14 0ms 184 0ms 0ms 0ms select triggerdepid, triggerid_down, triggerid_up from trigger_depends where triggerid_down in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 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 1,380 0ms 0ms 0ms select eventid from problem where source = ? and object = ? and not exists ( select null from triggers where triggerid = objectid);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 27 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 59 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 59 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 22 60 0ms 0ms 23 2 0ms 0ms 16 0ms 9 0ms 0ms 0ms select widgetid, type, name, x, y, width, height, view_mode, dashboard_pageid from widget where dashboard_pageid = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 27 18 9 0ms 0ms 17 0ms 10 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 05, ?.?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 27 02 1 0ms 0ms 03 1 0ms 0ms 05 1 0ms 0ms 07 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 18 0ms 2 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 12 1 0ms 0ms 19 1 0ms 0ms 19 0ms 1 0ms 0ms 0ms select c.relname as table_name from pg_attribute as a left join pg_class as c on c.relfilenode = a.attrelid left join pg_collation as l on l.oid = a.attcollation where atttypid in (...) and c.relnamespace = ? and c.relam = ? and (c.relname in (...)) and l.collname != ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 20 0ms 8 0ms 0ms 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 27 02 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 309,115 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 00 13,447 0ms 0ms 01 13,439 0ms 0ms 02 13,490 0ms 0ms 03 13,401 0ms 0ms 04 13,412 0ms 0ms 05 13,380 0ms 0ms 06 13,355 0ms 0ms 07 13,350 0ms 0ms 08 13,384 0ms 0ms 09 13,362 0ms 0ms 10 13,408 0ms 0ms 11 13,424 0ms 0ms 12 13,400 0ms 0ms 13 13,393 0ms 0ms 14 13,350 0ms 0ms 15 13,352 0ms 0ms 16 13,381 0ms 0ms 17 13,412 0ms 0ms 18 13,984 0ms 0ms 19 13,437 0ms 0ms 20 13,427 0ms 0ms 21 13,381 0ms 0ms 22 13,343 0ms 0ms 23 403 0ms 0ms 2 309,008 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 00 13,448 0ms 0ms 01 13,439 0ms 0ms 02 13,490 0ms 0ms 03 13,401 0ms 0ms 04 13,412 0ms 0ms 05 13,380 0ms 0ms 06 13,354 0ms 0ms 07 13,350 0ms 0ms 08 13,383 0ms 0ms 09 13,359 0ms 0ms 10 13,408 0ms 0ms 11 13,424 0ms 0ms 12 13,397 0ms 0ms 13 13,393 0ms 0ms 14 13,350 0ms 0ms 15 13,352 0ms 0ms 16 13,381 0ms 0ms 17 13,412 0ms 0ms 18 13,884 0ms 0ms 19 13,437 0ms 0ms 20 13,427 0ms 0ms 21 13,381 0ms 0ms 22 13,343 0ms 0ms 23 403 0ms 0ms 3 47,631 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 27 00 2,078 0ms 0ms 01 2,089 0ms 0ms 02 2,097 0ms 0ms 03 2,064 0ms 0ms 04 2,066 0ms 0ms 05 2,055 0ms 0ms 06 2,056 0ms 0ms 07 2,068 0ms 0ms 08 2,056 0ms 0ms 09 2,069 0ms 0ms 10 2,073 0ms 0ms 11 2,077 0ms 0ms 12 2,082 0ms 0ms 13 2,068 0ms 0ms 14 2,069 0ms 0ms 15 2,064 0ms 0ms 16 2,063 0ms 0ms 17 2,060 0ms 0ms 18 2,065 0ms 0ms 19 2,068 0ms 0ms 20 2,075 0ms 0ms 21 2,061 0ms 0ms 22 2,067 0ms 0ms 23 41 0ms 0ms 4 42,708 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 27 00 1,861 0ms 0ms 01 1,802 0ms 0ms 02 1,889 0ms 0ms 03 1,907 0ms 0ms 04 1,939 0ms 0ms 05 1,896 0ms 0ms 06 1,873 0ms 0ms 07 1,845 0ms 0ms 08 1,774 0ms 0ms 09 1,883 0ms 0ms 10 1,854 0ms 0ms 11 1,879 0ms 0ms 12 1,888 0ms 0ms 13 1,861 0ms 0ms 14 1,828 0ms 0ms 15 1,768 0ms 0ms 16 1,848 0ms 0ms 17 1,846 0ms 0ms 18 1,839 0ms 0ms 19 1,871 0ms 0ms 20 1,838 0ms 0ms 21 1,870 0ms 0ms 22 1,806 0ms 0ms 23 43 0ms 0ms 5 28,333 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 27 00 1,231 0ms 0ms 01 1,286 0ms 0ms 02 1,233 0ms 0ms 03 1,176 0ms 0ms 04 1,161 0ms 0ms 05 1,192 0ms 0ms 06 1,205 0ms 0ms 07 1,233 0ms 0ms 08 1,298 0ms 0ms 09 1,196 0ms 0ms 10 1,233 0ms 0ms 11 1,199 0ms 0ms 12 1,205 0ms 0ms 13 1,238 0ms 0ms 14 1,243 0ms 0ms 15 1,292 0ms 0ms 16 1,230 0ms 0ms 17 1,246 0ms 0ms 18 1,246 0ms 0ms 19 1,241 0ms 0ms 20 1,250 0ms 0ms 21 1,215 0ms 0ms 22 1,250 0ms 0ms 23 34 0ms 0ms 6 27,591 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 #6
Day Hour Count Duration Avg duration Jun 27 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,197 0ms 0ms 15 1,199 0ms 0ms 16 1,197 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,198 0ms 0ms 23 28 0ms 0ms 7 27,591 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 27 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,197 0ms 0ms 15 1,199 0ms 0ms 16 1,197 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,198 0ms 0ms 23 28 0ms 0ms 8 27,591 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 Jun 27 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,197 0ms 0ms 15 1,199 0ms 0ms 16 1,197 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,198 0ms 0ms 23 28 0ms 0ms 9 27,591 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 27 00 1,199 0ms 0ms 01 1,199 0ms 0ms 02 1,199 0ms 0ms 03 1,198 0ms 0ms 04 1,199 0ms 0ms 05 1,198 0ms 0ms 06 1,199 0ms 0ms 07 1,198 0ms 0ms 08 1,199 0ms 0ms 09 1,199 0ms 0ms 10 1,198 0ms 0ms 11 1,199 0ms 0ms 12 1,199 0ms 0ms 13 1,198 0ms 0ms 14 1,197 0ms 0ms 15 1,199 0ms 0ms 16 1,197 0ms 0ms 17 1,198 0ms 0ms 18 1,198 0ms 0ms 19 1,199 0ms 0ms 20 1,198 0ms 0ms 21 1,198 0ms 0ms 22 1,198 0ms 0ms 23 28 0ms 0ms 10 16,578 0ms 0ms 0ms 0ms select taskid, type, clock, ttl, proxyid from task where status in (...) order by taskid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 27 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,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 #11
Day Hour Count Duration Avg duration Jun 27 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 cast(extract(epoch from now()) as int) from config;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 27 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 Jun 27 00 720 0ms 0ms 01 720 0ms 0ms 02 720 0ms 0ms 03 720 0ms 0ms 04 720 0ms 0ms 05 720 0ms 0ms 06 720 0ms 0ms 07 720 0ms 0ms 08 720 0ms 0ms 09 720 0ms 0ms 10 720 0ms 0ms 11 720 0ms 0ms 12 720 0ms 0ms 13 720 0ms 0ms 14 720 0ms 0ms 15 720 0ms 0ms 16 720 0ms 0ms 17 720 0ms 0ms 18 720 0ms 0ms 19 720 0ms 0ms 20 720 0ms 0ms 21 720 0ms 0ms 22 720 0ms 0ms 23 17 0ms 0ms 14 16,577 0ms 0ms 0ms 0ms select ha_failover_delay, auditlog_enabled, auditlog_mode from config;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 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 15 10,203 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 27 00 440 0ms 0ms 01 449 0ms 0ms 02 435 0ms 0ms 03 454 0ms 0ms 04 444 0ms 0ms 05 440 0ms 0ms 06 432 0ms 0ms 07 438 0ms 0ms 08 453 0ms 0ms 09 444 0ms 0ms 10 449 0ms 0ms 11 455 0ms 0ms 12 450 0ms 0ms 13 438 0ms 0ms 14 432 0ms 0ms 15 446 0ms 0ms 16 468 0ms 0ms 17 439 0ms 0ms 18 438 0ms 0ms 19 438 0ms 0ms 20 430 0ms 0ms 21 445 0ms 0ms 22 437 0ms 0ms 23 9 0ms 0ms 16 8,240 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 27 00 358 0ms 0ms 01 358 0ms 0ms 02 357 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 357 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 8 0ms 0ms 17 7,100 0ms 0ms 0ms 0ms select changelogid, object, objectid, operation, clock from changelog;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 27 00 308 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 309 0ms 0ms 04 308 0ms 0ms 05 308 0ms 0ms 06 309 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 308 0ms 0ms 14 309 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 0ms 0ms 18 308 0ms 0ms 19 308 0ms 0ms 20 309 0ms 0ms 21 308 0ms 0ms 22 308 0ms 0ms 23 8 0ms 0ms 18 7,099 0ms 0ms 0ms 0ms select correlationid, name, evaltype, formula from correlation where status = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 00 308 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 308 0ms 0ms 07 309 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 308 0ms 0ms 14 309 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 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,099 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 Jun 27 00 308 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 309 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 308 0ms 0ms 14 309 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 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 20 7,099 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 Jun 27 00 308 0ms 0ms 01 309 0ms 0ms 02 309 0ms 0ms 03 308 0ms 0ms 04 309 0ms 0ms 05 308 0ms 0ms 06 309 0ms 0ms 07 308 0ms 0ms 08 308 0ms 0ms 09 309 0ms 0ms 10 308 0ms 0ms 11 308 0ms 0ms 12 309 0ms 0ms 13 308 0ms 0ms 14 309 0ms 0ms 15 308 0ms 0ms 16 308 0ms 0ms 17 308 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 Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 207 0ms select i.itemid, i.name, i.key_, i.type, i.value_type, i.delay, i.history, i.trends, i.status, i.trapper_hosts, i.units, i.formula, i.logtimefmt, i.valuemapid, i.params, i.ipmi_sensor, i.snmp_oid, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.description, i.interfaceid, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, i.posts, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, i.headers, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.discover from items i, item_discovery id where i.itemid = id.itemid and id.parent_itemid = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 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 2 0ms 0ms 0ms 108 0ms select configid, session_key, dbversion_status, server_status, software_update_checkid, software_update_check_data from config;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 06 1 0ms 0ms 08 1 0ms 0ms 09 3 0ms 0ms 12 3 0ms 0ms 18 100 0ms 0ms 3 0ms 0ms 0ms 23 0ms set escape_string_warning to off;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 27 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 4 0ms 0ms 0ms 184 0ms select triggertagid, triggerid, tag, value from trigger_tag where triggerid in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 27 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 5 0ms 0ms 0ms 23 0ms select housekeeperid, tablename, field, value from housekeeper where tablename in (...) order by tablename;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 27 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 6 0ms 0ms 0ms 1 0ms select count(*) from users;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 7 0ms 0ms 0ms 26 0ms insert into trends_uint (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 27 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 8 0ms 0ms 0ms 1,623 0ms insert into history (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 27 00 70 0ms 0ms 01 75 0ms 0ms 02 76 0ms 0ms 03 70 0ms 0ms 04 72 0ms 0ms 05 75 0ms 0ms 06 69 0ms 0ms 07 70 0ms 0ms 08 70 0ms 0ms 09 72 0ms 0ms 10 72 0ms 0ms 11 70 0ms 0ms 12 73 0ms 0ms 13 68 0ms 0ms 14 72 0ms 0ms 15 68 0ms 0ms 16 75 0ms 0ms 17 65 0ms 0ms 18 66 0ms 0ms 19 67 0ms 0ms 20 67 0ms 0ms 21 77 0ms 0ms 22 63 0ms 0ms 23 1 0ms 0ms 9 0ms 0ms 0ms 12 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 07, ?.? e - 05), (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 27 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 13 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 10 0ms 0ms 0ms 1 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 27 02 1 0ms 0ms 11 0ms 0ms 0ms 1,154 0ms insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 27 00 52 0ms 0ms 01 51 0ms 0ms 02 52 0ms 0ms 03 52 0ms 0ms 04 50 0ms 0ms 05 49 0ms 0ms 06 50 0ms 0ms 07 50 0ms 0ms 08 50 0ms 0ms 09 47 0ms 0ms 10 51 0ms 0ms 11 51 0ms 0ms 12 52 0ms 0ms 13 50 0ms 0ms 14 49 0ms 0ms 15 49 0ms 0ms 16 47 0ms 0ms 17 52 0ms 0ms 18 49 0ms 0ms 19 50 0ms 0ms 20 52 0ms 0ms 21 48 0ms 0ms 22 51 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 27 13 1 0ms 0ms 13 0ms 0ms 0ms 1 0ms select d.dashboardid, d.name, d.userid, d.display_period, d.auto_start from dashboard d where d.templateid is null and d.dashboardid = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 14 0ms 0ms 0ms 184 0ms select triggerdepid, triggerid_down, triggerid_up from trigger_depends where triggerid_down in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 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 1,380 0ms select eventid from problem where source = ? and object = ? and not exists ( select null from triggers where triggerid = objectid);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 27 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 59 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 59 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 22 60 0ms 0ms 23 2 0ms 0ms 16 0ms 0ms 0ms 9 0ms select widgetid, type, name, x, y, width, height, view_mode, dashboard_pageid from widget where dashboard_pageid = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 27 18 9 0ms 0ms 17 0ms 0ms 0ms 10 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?, ?.?, ?.?), (?, ?, ?, ?, ?.? e - 05, ?.?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 27 02 1 0ms 0ms 03 1 0ms 0ms 05 1 0ms 0ms 07 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 18 0ms 0ms 0ms 2 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?.?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 12 1 0ms 0ms 19 1 0ms 0ms 19 0ms 0ms 0ms 1 0ms select c.relname as table_name from pg_attribute as a left join pg_class as c on c.relfilenode = a.attrelid left join pg_collation as l on l.oid = a.attcollation where atttypid in (...) and c.relnamespace = ? and c.relam = ? and (c.relname in (...)) and l.collname != ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 27 18 1 0ms 0ms 20 0ms 0ms 0ms 8 0ms insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?), (?, ?, ?, ?.?, ?.?, ?.?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 27 02 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 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,459 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 27 00 699 0ms 0ms 01 714 0ms 0ms 02 701 0ms 0ms 03 715 0ms 0ms 04 714 0ms 0ms 05 716 0ms 0ms 06 720 0ms 0ms 07 734 0ms 0ms 08 712 0ms 0ms 09 729 0ms 0ms 10 714 0ms 0ms 11 707 0ms 0ms 12 718 0ms 0ms 13 718 0ms 0ms 14 721 0ms 0ms 15 718 0ms 0ms 16 718 0ms 0ms 17 707 0ms 0ms 18 707 0ms 0ms 19 707 0ms 0ms 20 711 0ms 0ms 21 718 0ms 0ms 22 718 0ms 0ms 23 23 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: zabbix Remote: zabbix Application: k8smaster01 Queryid: [unknown]
-
-
Events
Log levels
Key values
- 2,495,020 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 11 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 11 Total events found
Rank Times reported Error 1 3 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 27 01 1 05 1 22 1 2 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 27 05 1 22 1 3 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 27 05 1 22 1 4 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 27 20 1 22 1 - FATAL: no pg_hba.conf entry for host "35.205.208.255", user "postgres", database "postgres", no encryption
Detail: Client IP address resolved to "255.208.205.35.bc.googleusercontent.com", forward lookup not checked.
Date: 2025-06-27 20:06:04 Database: postgres Application: [unknown] User: postgres Remote: 255.208.205.35.bc.googleusercontent.com
5 1 FATAL: invalid startup packet layout: expected terminator as last byte
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 27 08 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 27 10 1