-
Global information
- Generated on Wed Oct 23 09:49:49 2019
- Log file: postgres-9.4.stderr.log, ..., postgres-9.4.stderr.log.7
- Parsed 4,205,989 log entries in 1m24s
- Log start from 2019-10-22 20:09:22 to 2019-10-23 13:48:01
-
Overview
Global Stats
- 37 Number of unique normalized queries
- 1,042,335 Number of queries
- 3m19s Total query duration
- -- :: First query
- 2019-10-23 13:48:01 Last query
- 156 queries/s at 2019-10-22 20:10:09 Query peak
- 3m19s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3m19s Execute total duration
- 21 Number of events
- 6 Number of unique normalized events
- 9 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
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 1,042,335 Average queries per session
- 3m19s Average queries duration per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 156 queries/s Query Peak
- 2019-10-22 20:10:09 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 153 queries/s Query Peak
- 2019-10-22 20:10:09 Date
Queries duration
Key values
- 3m19s 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
Day Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 10 18 0ms 0ms 0ms 3ms 3ms 3ms Oct 22 20 49,414 0ms 10ms 0ms 193ms 201ms 565ms 21 58,889 0ms 6ms 0ms 196ms 202ms 209ms 22 59,080 0ms 5ms 0ms 197ms 201ms 203ms 23 59,064 0ms 5ms 0ms 196ms 197ms 198ms Oct 23 00 59,096 0ms 4ms 0ms 197ms 202ms 203ms 01 59,157 0ms 6ms 0ms 191ms 194ms 197ms 02 59,206 0ms 5ms 0ms 197ms 198ms 201ms 03 59,480 0ms 5ms 0ms 199ms 201ms 201ms 04 59,488 0ms 5ms 0ms 207ms 208ms 211ms 05 59,488 0ms 1ms 0ms 212ms 214ms 221ms 06 59,416 0ms 5ms 0ms 204ms 212ms 217ms 07 59,466 0ms 5ms 0ms 204ms 206ms 231ms 08 59,496 0ms 5ms 0ms 204ms 208ms 214ms 09 59,400 0ms 7ms 0ms 206ms 207ms 211ms 10 58,837 0ms 5ms 0ms 203ms 207ms 212ms 11 58,065 0ms 5ms 0ms 188ms 193ms 194ms 12 58,355 0ms 3ms 0ms 193ms 194ms 208ms 13 46,920 0ms 5ms 0ms 193ms 196ms 200ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 10 10 0 0ms 3ms 3ms 3ms Oct 22 20 25,068 0 0ms 170ms 175ms 189ms 21 29,511 0 0ms 174ms 177ms 188ms 22 29,608 0 0ms 177ms 179ms 182ms 23 29,600 0 0ms 172ms 177ms 180ms Oct 23 00 29,616 0 0ms 177ms 178ms 183ms 01 29,647 0 0ms 171ms 173ms 178ms 02 29,671 0 0ms 176ms 178ms 181ms 03 29,808 0 0ms 180ms 181ms 183ms 04 29,812 0 0ms 186ms 188ms 191ms 05 29,812 0 0ms 188ms 193ms 197ms 06 29,773 0 0ms 181ms 183ms 193ms 07 29,796 0 0ms 183ms 185ms 188ms 08 29,816 0 0ms 183ms 186ms 189ms 09 29,768 0 0ms 185ms 187ms 189ms 10 29,487 0 0ms 178ms 184ms 192ms 11 29,101 0 0ms 168ms 170ms 175ms 12 29,246 0 0ms 171ms 174ms 175ms 13 23,518 0 0ms 173ms 174ms 182ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 10 0 0 0 0 0ms 0ms 0ms 0ms Oct 22 20 5 4 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 2 5 1 0 1ms 0ms 0ms 1ms 07 2 5 1 0 1ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare 10 0 0 0.00 0.00% Oct 22 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% Oct 23 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% Day Hour Count Average / Second 10 0 0.00/s Oct 22 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Oct 23 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s Day Hour Count Average Duration 10 0 0ms Oct 22 20 0 0ms 21 0 0ms 22 0 0ms 23 0 0ms Oct 23 00 0 0ms 01 0 0ms 02 0 0ms 03 0 0ms 04 0 0ms 05 0 0ms 06 0 0ms 07 0 0ms 08 0 0ms 09 0 0ms 10 0 0ms 11 0 0ms 12 0 0ms 13 0 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
Day Hour Written buffers Write time Sync time Total time 10 0 0s 0s 0s Oct 22 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Oct 23 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync 10 0 0 0 0 0s 0s Oct 22 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Oct 23 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s Day Hour Count Avg time (sec) 10 0 0s Oct 22 20 0 0s 21 0 0s 22 0 0s 23 0 0s Oct 23 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 Day Hour Mean distance Mean estimate 10 0.00 kB 0.00 kB Oct 22 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB Oct 23 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 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
Day Hour Count Total size Average size 10 0 0 0 Oct 22 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 23 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 -
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
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
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
Day Hour VACUUMs ANALYZEs 10 0 0 Oct 22 20 0 0 21 0 0 22 0 0 23 0 0 Oct 23 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 - 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
- 522,668 Total read queries
- 25 Total write queries
Queries by database
Key values
- unknown Main database
- 1,042,335 Requests
- 3m19s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 1,042,335 Requests
User Request type Count Duration unknown Total 1,042,335 3m19s ALTER 1 1ms BEGIN 256,595 8s112ms COMMIT 256,599 10s47ms DELETE 2 2ms INSERT 9 12ms SELECT 522,668 3m1s UPDATE 14 9ms others 6,447 348ms Duration by user
Key values
- 3m19s (unknown) Main time consuming user
User Request type Count Duration unknown Total 1,042,335 3m19s ALTER 1 1ms BEGIN 256,595 8s112ms COMMIT 256,599 10s47ms DELETE 2 2ms INSERT 9 12ms SELECT 522,668 3m1s UPDATE 14 9ms others 6,447 348ms Queries by host
Key values
- unknown Main host
- 1,042,335 Requests
- 3m19s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 1,042,335 Requests
- 3m19s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-10-23 10:16:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,571,658 0-1ms duration
Slowest individual queries
Rank Duration Query 1 10ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:30:07.705333+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:30:07.705333+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 20:30:09 ]
2 9ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:09:22.962184+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:09:22.962184+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 20:09:23 ]
3 8ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:11:28.477364+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:11:28.477364+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 20:11:28 ]
4 7ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 09:57:58.468270+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 09:57:58.468270+0000') OR ("locked_by" = 'worker_2')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 09:57:58 ]
5 7ms BEGIN;[ Date: 2019-10-22 20:21:36 ]
6 6ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 21:26:48.440261+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 21:26:48.440261+0000') OR ("locked_by" = 'worker_3')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 21:26:48 ]
7 6ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:38:35.631313+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:38:35.631313+0000') OR ("locked_by" = 'worker_2')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 20:38:35 ]
8 6ms COMMIT;[ Date: 2019-10-23 01:32:45 ]
9 6ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 21:18:38.316902+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 21:18:38.316902+0000') OR ("locked_by" = 'worker_4')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 21:18:38 ]
10 5ms SELECT NULL;[ Date: 2019-10-22 23:24:50 ]
11 5ms COMMIT;[ Date: 2019-10-23 13:19:20 ]
12 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 03:24:52.244146+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 03:24:52.244146+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 03:24:52 ]
13 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 02:05:45.693265+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 02:05:45.693265+0000') OR ("locked_by" = 'worker_3')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 02:05:45 ]
14 5ms SELECT NULL;[ Date: 2019-10-22 21:26:07 ]
15 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 23:19:03.086278+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 23:19:03.086278+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-22 23:19:03 ]
16 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 10:33:52.875857+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 10:33:52.875857+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 10:33:52 ]
17 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 08:15:57.889392+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 08:15:57.889392+0000') OR ("locked_by" = 'worker_2')) AND ("failed_at" IS NULL) AND ("queue" IN ('normal', 'urgent', 'dfc75fa9-1bc0-4bb2-82db-1bb87484a7e2'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 08:15:57 ]
18 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 06:11:02.451652+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 06:11:02.451652+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 06:11:02 ]
19 5ms SELECT NULL;[ Date: 2019-10-23 13:16:33 ]
20 5ms SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-23 07:44:44.538156+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-23 07:44:44.538156+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;[ Date: 2019-10-23 07:44:44 ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2m18s 250,234 0ms 10ms 0ms select * from "delayed_jobs" where (((("run_at" <= ?) and ("locked_at" is null)) or ("locked_at" < ?) or ("locked_by" = ?)) and ("failed_at" is null) and ("queue" in (...))) order by "priority" asc, "run_at" asc limit ? for update;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 00 5 2ms 0ms Oct 22 20 11,665 6s343ms 0ms 21 14,149 7s851ms 0ms 22 14,196 7s833ms 0ms 23 14,192 7s836ms 0ms Oct 23 00 14,200 7s843ms 0ms 01 14,216 7s748ms 0ms 02 14,228 7s797ms 0ms 03 14,296 7s995ms 0ms 04 14,298 8s237ms 0ms 05 14,298 8s255ms 0ms 06 14,269 7s965ms 0ms 07 14,281 8s96ms 0ms 08 14,300 8s107ms 0ms 09 14,276 8s168ms 0ms 10 14,136 7s684ms 0ms 11 13,944 7s463ms 0ms 12 14,016 7s496ms 0ms 13 11,269 6s227ms 0ms -
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:30:07.705333+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:30:07.705333+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:30:09 Duration: 10ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:09:22.962184+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:09:22.962184+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:09:23 Duration: 9ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:11:28.477364+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:11:28.477364+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:11:28 Duration: 8ms
2 38s190ms 262,919 0ms 5ms 0ms select null;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration 23 5 0ms 0ms Oct 22 20 12,603 1s678ms 0ms 21 14,845 2s110ms 0ms 22 14,894 2s102ms 0ms 23 14,890 2s88ms 0ms Oct 23 00 14,898 2s105ms 0ms 01 14,914 2s65ms 0ms 02 14,925 2s96ms 0ms 03 14,994 2s231ms 0ms 04 14,996 2s387ms 0ms 05 14,996 2s431ms 0ms 06 14,979 2s247ms 0ms 07 14,990 2s277ms 0ms 08 14,998 2s263ms 0ms 09 14,974 2s326ms 0ms 10 14,834 2s101ms 0ms 11 14,640 1s996ms 0ms 12 14,713 2s 0ms 13 11,831 1s677ms 0ms -
SELECT NULL;
Date: 2019-10-22 23:24:50 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-22 21:26:07 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-23 13:16:33 Duration: 5ms
3 10s47ms 256,599 0ms 6ms 0ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration 23 6 0ms 0ms Oct 22 20 11,973 468ms 0ms 21 14,508 576ms 0ms 22 14,556 573ms 0ms 23 14,552 568ms 0ms Oct 23 00 14,560 571ms 0ms 01 14,575 577ms 0ms 02 14,588 568ms 0ms 03 14,656 573ms 0ms 04 14,658 579ms 0ms 05 14,658 575ms 0ms 06 14,635 573ms 0ms 07 14,648 578ms 0ms 08 14,660 575ms 0ms 09 14,636 578ms 0ms 10 14,495 554ms 0ms 11 14,303 545ms 0ms 12 14,375 547ms 0ms 13 11,557 461ms 0ms -
COMMIT;
Date: 2019-10-23 01:32:45 Duration: 6ms
-
COMMIT;
Date: 2019-10-23 13:19:20 Duration: 5ms
-
COMMIT;
Date: 2019-10-23 08:44:28 Duration: 2ms
4 8s112ms 256,595 0ms 7ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration 23 2 0ms 0ms Oct 22 20 11,973 383ms 0ms 21 14,508 469ms 0ms 22 14,556 463ms 0ms 23 14,552 464ms 0ms Oct 23 00 14,560 465ms 0ms 01 14,576 456ms 0ms 02 14,587 455ms 0ms 03 14,656 455ms 0ms 04 14,658 469ms 0ms 05 14,658 469ms 0ms 06 14,635 457ms 0ms 07 14,648 459ms 0ms 08 14,660 461ms 0ms 09 14,636 473ms 0ms 10 14,496 448ms 0ms 11 14,302 445ms 0ms 12 14,375 446ms 0ms 13 11,557 368ms 0ms -
BEGIN;
Date: 2019-10-22 20:21:36 Duration: 7ms
-
BEGIN;
Date: 2019-10-23 09:26:31 Duration: 5ms
-
BEGIN;
Date: 2019-10-22 23:03:07 Duration: 3ms
5 2s35ms 6,345 0ms 3ms 0ms select * from "local_dns_blobs" order by "version" desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 22 20 303 98ms 0ms 21 359 114ms 0ms 22 360 116ms 0ms 23 360 116ms 0ms Oct 23 00 360 114ms 0ms 01 359 116ms 0ms 02 360 116ms 0ms 03 360 115ms 0ms 04 360 114ms 0ms 05 360 116ms 0ms 06 359 114ms 0ms 07 360 116ms 0ms 08 360 115ms 0ms 09 360 114ms 0ms 10 359 113ms 0ms 11 359 113ms 0ms 12 359 114ms 0ms 13 288 92ms 0ms -
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 20:09:22 Duration: 3ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 23:58:55 Duration: 0ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-23 07:35:11 Duration: 0ms
6 954ms 1,057 0ms 2ms 0ms select * from "configs" where (("deleted" is false) and ("type" = ?) and ("id" in ( select max("id") from "configs" where (("deleted" is false) and ("type" = ?)) group by "type", "name"))) order by "type", ( case when ("name" = ?) then ? else ? end), "name", "id" desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 49 49ms 1ms 21 60 54ms 0ms 22 60 53ms 0ms 23 60 53ms 0ms Oct 23 00 60 53ms 0ms 01 60 55ms 0ms 02 60 52ms 0ms 03 60 52ms 0ms 04 60 53ms 0ms 05 60 52ms 0ms 06 60 56ms 0ms 07 60 53ms 0ms 08 60 53ms 0ms 09 60 52ms 0ms 10 60 53ms 0ms 11 60 53ms 0ms 12 60 53ms 0ms 13 48 44ms 0ms -
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:15:07 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:21:08 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:12:07 Duration: 2ms
7 481ms 334 1ms 5ms 1ms select "pg_attribute"."attname" AS "name", cast("pg_attribute"."atttypid" as integer) AS "oid", cast("basetype"."oid" as integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", not "pg_attribute"."attnotnull" AS "allow_null", coalesce(("pg_attribute"."attnum" = any ("pg_index"."indkey")), false) AS "primary_key" from "pg_class" inner join "pg_attribute" on ("pg_attribute"."attrelid" = "pg_class"."oid") inner join "pg_type" on ("pg_type"."oid" = "pg_attribute"."atttypid") left outer join "pg_type" AS "basetype" on ("basetype"."oid" = "pg_type"."typbasetype") left outer join "pg_attrdef" on (("pg_attrdef"."adrelid" = "pg_class"."oid") and ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) left outer join "pg_index" on (("pg_index"."indrelid" = "pg_class"."oid") and ("pg_index"."indisprimary" is true)) where (("pg_attribute"."attisdropped" is false) and ("pg_attribute"."attnum" > ?) and ("pg_class"."oid" = cast(cast(? as regclass) as oid))) order by "pg_attribute"."attnum";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 22 20 333 477ms 1ms Oct 23 06 1 4ms 4ms -
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"compiled_packages"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:10:03 Duration: 5ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"delayed_jobs"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-23 06:00:00 Duration: 4ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"agent_dns_versions"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:09:56 Duration: 3ms
8 378ms 1,057 0ms 2ms 0ms select * from "deployments" order by "name" asc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 20 49 21ms 0ms 21 60 21ms 0ms 22 60 20ms 0ms 23 60 20ms 0ms Oct 23 00 60 20ms 0ms 01 60 21ms 0ms 02 60 21ms 0ms 03 60 21ms 0ms 04 60 21ms 0ms 05 60 21ms 0ms 06 60 22ms 0ms 07 60 21ms 0ms 08 60 21ms 0ms 09 60 21ms 0ms 10 60 20ms 0ms 11 60 20ms 0ms 12 60 20ms 0ms 13 48 17ms 0ms -
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:14:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:12:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-23 13:42:12 Duration: 0ms
9 342ms 6,345 0ms 0ms 0ms set transaction isolation level read committed;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 20 303 15ms 0ms 21 359 19ms 0ms 22 360 19ms 0ms 23 360 19ms 0ms Oct 23 00 360 19ms 0ms 01 359 19ms 0ms 02 360 19ms 0ms 03 360 19ms 0ms 04 360 19ms 0ms 05 360 19ms 0ms 06 359 19ms 0ms 07 360 19ms 0ms 08 360 19ms 0ms 09 360 19ms 0ms 10 359 19ms 0ms 11 359 18ms 0ms 12 359 19ms 0ms 13 288 15ms 0ms -
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:14:07 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:52:49 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 07:35:11 Duration: 0ms
10 122ms 422 0ms 1ms 0ms select * from "orphaned_vms";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 18 7ms 0ms 21 24 7ms 0ms 22 24 6ms 0ms 23 24 7ms 0ms Oct 23 00 24 6ms 0ms 01 24 7ms 0ms 02 24 6ms 0ms 03 24 6ms 0ms 04 24 7ms 0ms 05 24 7ms 0ms 06 24 7ms 0ms 07 24 6ms 0ms 08 24 6ms 0ms 09 24 7ms 0ms 10 24 7ms 0ms 11 24 5ms 0ms 12 24 6ms 0ms 13 20 5ms 0ms -
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 20:40:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 21:10:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-23 06:05:00 Duration: 0ms
11 31ms 70 0ms 2ms 0ms select * from "networks" where (orphaned = true and orphaned_at < ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 2ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 3ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-22 06:00:00.181345+0000');
Date: 2019-10-23 06:00:00 Duration: 2ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.236959+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.230017+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
12 30ms 70 0ms 1ms 0ms select * from "orphan_disks" where (created_at < ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 22 20 2 1ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 1ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 2ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:00:00.015610+0000');
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:30:00.228498+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-18 06:30:00.080123+0000');
Date: 2019-10-23 06:30:00 Duration: 1ms
13 27ms 70 0ms 1ms 0ms select count(*) AS "count" from "local_dns_blobs" limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 1ms 0ms 07 4 1ms 0ms 08 4 2ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-23 08:30:00 Duration: 0ms
14 18ms 34 0ms 2ms 0ms select count(*) AS "count" from "events" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 21 2 3ms 1ms 22 2 1ms 0ms 23 2 0ms 0ms Oct 23 00 2 1ms 0ms 01 2 1ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 1ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms -
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 2ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-23 07:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 22:00:00 Duration: 1ms
15 7ms 2 2ms 5ms 3ms insert into "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") values (?, ?, ?, ?, null, ?, ?, ?, ?, ?) returning *;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 23 06 1 5ms 5ms 07 1 2ms 2ms -
INSERT INTO "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") VALUES ('scheduler', 'snapshot_self', 'scheduled SnapshotSelf', 'queued', NULL, '2019-10-23 06:00:00.170351+0000', '2019-10-23 06:00:00.170357+0000', '', '', '') RETURNING *;
Date: 2019-10-23 06:00:00 Duration: 5ms
-
INSERT INTO "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") VALUES ('scheduler', 'snapshot_deployments', 'scheduled SnapshotDeployments', 'queued', NULL, '2019-10-23 07:00:00.327625+0000', '2019-10-23 07:00:00.327629+0000', '', '', '') RETURNING *;
Date: 2019-10-23 07:00:00 Duration: 2ms
16 5ms 4 0ms 2ms 1ms update "tasks" set "state" = ?, "timestamp" = ?, "description" = ?, "result" = null, "output" = ?, "checkpoint_time" = ?, "type" = ?, "username" = ?, "deployment_name" = null, "started_at" = null, "event_output" = ?, "result_output" = ?, "context_id" = ? where ("id" = ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 23 06 2 3ms 1ms 07 2 2ms 1ms -
UPDATE "tasks" SET "state" = 'queued', "timestamp" = '2019-10-23 06:00:00.170351+0000', "description" = 'scheduled SnapshotSelf', "result" = NULL, "output" = '/var/vcap/store/director/tasks/31', "checkpoint_time" = '2019-10-23 06:00:00.170357+0000', "type" = 'snapshot_self', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 31);
Date: 2019-10-23 06:00:00 Duration: 2ms
-
UPDATE "tasks" SET "state" = 'queued', "timestamp" = '2019-10-23 07:00:00.327625+0000', "description" = 'scheduled SnapshotDeployments', "result" = NULL, "output" = '/var/vcap/store/director/tasks/32', "checkpoint_time" = '2019-10-23 07:00:00.327629+0000', "type" = 'snapshot_deployments', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 32);
Date: 2019-10-23 07:00:00 Duration: 1ms
-
UPDATE "tasks" SET "state" = 'processing', "timestamp" = '2019-10-23 07:00:00.327625+0000', "description" = 'scheduled SnapshotDeployments', "result" = NULL, "output" = '/var/vcap/store/director/tasks/32', "checkpoint_time" = '2019-10-23 07:00:00.414249+0000', "type" = 'snapshot_deployments', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 32);
Date: 2019-10-23 07:00:00 Duration: 0ms
17 5ms 17 0ms 0ms 0ms select cast(current_setting(?) as integer) as v;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 22 20 17 5ms 0ms -
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:53 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:51 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:10:02 Duration: 0ms
18 4ms 2 1ms 3ms 2ms select * from "tasks" where (state not in (...) and type = ?) order by "id" desc limit ? offset ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 23 06 1 3ms 3ms 07 1 1ms 1ms -
SELECT * FROM "tasks" WHERE (state NOT IN ('processing', 'queued') and type = 'snapshot_self') ORDER BY "id" DESC LIMIT 10 OFFSET 2000;
Date: 2019-10-23 06:00:00 Duration: 3ms
-
SELECT * FROM "tasks" WHERE (state NOT IN ('processing', 'queued') and type = 'snapshot_deployments') ORDER BY "id" DESC LIMIT 10 OFFSET 2000;
Date: 2019-10-23 07:00:00 Duration: 1ms
19 4ms 2 1ms 3ms 2ms select * from "tasks" where ("id" = ?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 23 06 1 1ms 1ms 07 1 3ms 3ms -
SELECT * FROM "tasks" WHERE ("id" = 32) LIMIT 1;
Date: 2019-10-23 07:00:00 Duration: 3ms
-
SELECT * FROM "tasks" WHERE ("id" = 31) LIMIT 1;
Date: 2019-10-23 06:00:00 Duration: 1ms
20 3ms 34 0ms 0ms 0ms set standard_conforming_strings = on;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 22 20 29 2ms 0ms 21 1 0ms 0ms Oct 23 06 2 0ms 0ms 07 2 0ms 0ms -
SET standard_conforming_strings = ON;
Date: 2019-10-23 06:00:00 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:09:22 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:14:07 Duration: 0ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 262,919 38s190ms 0ms 5ms 0ms select null;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 00 5 0ms 0ms Oct 22 20 12,603 1s678ms 0ms 21 14,845 2s110ms 0ms 22 14,894 2s102ms 0ms 23 14,890 2s88ms 0ms Oct 23 00 14,898 2s105ms 0ms 01 14,914 2s65ms 0ms 02 14,925 2s96ms 0ms 03 14,994 2s231ms 0ms 04 14,996 2s387ms 0ms 05 14,996 2s431ms 0ms 06 14,979 2s247ms 0ms 07 14,990 2s277ms 0ms 08 14,998 2s263ms 0ms 09 14,974 2s326ms 0ms 10 14,834 2s101ms 0ms 11 14,640 1s996ms 0ms 12 14,713 2s 0ms 13 11,831 1s677ms 0ms -
SELECT NULL;
Date: 2019-10-22 23:24:50 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-22 21:26:07 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-23 13:16:33 Duration: 5ms
2 256,599 10s47ms 0ms 6ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration 23 6 0ms 0ms Oct 22 20 11,973 468ms 0ms 21 14,508 576ms 0ms 22 14,556 573ms 0ms 23 14,552 568ms 0ms Oct 23 00 14,560 571ms 0ms 01 14,575 577ms 0ms 02 14,588 568ms 0ms 03 14,656 573ms 0ms 04 14,658 579ms 0ms 05 14,658 575ms 0ms 06 14,635 573ms 0ms 07 14,648 578ms 0ms 08 14,660 575ms 0ms 09 14,636 578ms 0ms 10 14,495 554ms 0ms 11 14,303 545ms 0ms 12 14,375 547ms 0ms 13 11,557 461ms 0ms -
COMMIT;
Date: 2019-10-23 01:32:45 Duration: 6ms
-
COMMIT;
Date: 2019-10-23 13:19:20 Duration: 5ms
-
COMMIT;
Date: 2019-10-23 08:44:28 Duration: 2ms
3 256,595 8s112ms 0ms 7ms 0ms begin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration 23 2 0ms 0ms Oct 22 20 11,973 383ms 0ms 21 14,508 469ms 0ms 22 14,556 463ms 0ms 23 14,552 464ms 0ms Oct 23 00 14,560 465ms 0ms 01 14,576 456ms 0ms 02 14,587 455ms 0ms 03 14,656 455ms 0ms 04 14,658 469ms 0ms 05 14,658 469ms 0ms 06 14,635 457ms 0ms 07 14,648 459ms 0ms 08 14,660 461ms 0ms 09 14,636 473ms 0ms 10 14,496 448ms 0ms 11 14,302 445ms 0ms 12 14,375 446ms 0ms 13 11,557 368ms 0ms -
BEGIN;
Date: 2019-10-22 20:21:36 Duration: 7ms
-
BEGIN;
Date: 2019-10-23 09:26:31 Duration: 5ms
-
BEGIN;
Date: 2019-10-22 23:03:07 Duration: 3ms
4 250,234 2m18s 0ms 10ms 0ms select * from "delayed_jobs" where (((("run_at" <= ?) and ("locked_at" is null)) or ("locked_at" < ?) or ("locked_by" = ?)) and ("failed_at" is null) and ("queue" in (...))) order by "priority" asc, "run_at" asc limit ? for update;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration 23 5 2ms 0ms Oct 22 20 11,665 6s343ms 0ms 21 14,149 7s851ms 0ms 22 14,196 7s833ms 0ms 23 14,192 7s836ms 0ms Oct 23 00 14,200 7s843ms 0ms 01 14,216 7s748ms 0ms 02 14,228 7s797ms 0ms 03 14,296 7s995ms 0ms 04 14,298 8s237ms 0ms 05 14,298 8s255ms 0ms 06 14,269 7s965ms 0ms 07 14,281 8s96ms 0ms 08 14,300 8s107ms 0ms 09 14,276 8s168ms 0ms 10 14,136 7s684ms 0ms 11 13,944 7s463ms 0ms 12 14,016 7s496ms 0ms 13 11,269 6s227ms 0ms -
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:30:07.705333+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:30:07.705333+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:30:09 Duration: 10ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:09:22.962184+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:09:22.962184+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:09:23 Duration: 9ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:11:28.477364+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:11:28.477364+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:11:28 Duration: 8ms
5 6,345 2s35ms 0ms 3ms 0ms select * from "local_dns_blobs" order by "version" desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 22 20 303 98ms 0ms 21 359 114ms 0ms 22 360 116ms 0ms 23 360 116ms 0ms Oct 23 00 360 114ms 0ms 01 359 116ms 0ms 02 360 116ms 0ms 03 360 115ms 0ms 04 360 114ms 0ms 05 360 116ms 0ms 06 359 114ms 0ms 07 360 116ms 0ms 08 360 115ms 0ms 09 360 114ms 0ms 10 359 113ms 0ms 11 359 113ms 0ms 12 359 114ms 0ms 13 288 92ms 0ms -
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 20:09:22 Duration: 3ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 23:58:55 Duration: 0ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-23 07:35:11 Duration: 0ms
6 6,345 342ms 0ms 0ms 0ms set transaction isolation level read committed;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 303 15ms 0ms 21 359 19ms 0ms 22 360 19ms 0ms 23 360 19ms 0ms Oct 23 00 360 19ms 0ms 01 359 19ms 0ms 02 360 19ms 0ms 03 360 19ms 0ms 04 360 19ms 0ms 05 360 19ms 0ms 06 359 19ms 0ms 07 360 19ms 0ms 08 360 19ms 0ms 09 360 19ms 0ms 10 359 19ms 0ms 11 359 18ms 0ms 12 359 19ms 0ms 13 288 15ms 0ms -
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:14:07 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:52:49 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 07:35:11 Duration: 0ms
7 1,057 954ms 0ms 2ms 0ms select * from "configs" where (("deleted" is false) and ("type" = ?) and ("id" in ( select max("id") from "configs" where (("deleted" is false) and ("type" = ?)) group by "type", "name"))) order by "type", ( case when ("name" = ?) then ? else ? end), "name", "id" desc;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 22 20 49 49ms 1ms 21 60 54ms 0ms 22 60 53ms 0ms 23 60 53ms 0ms Oct 23 00 60 53ms 0ms 01 60 55ms 0ms 02 60 52ms 0ms 03 60 52ms 0ms 04 60 53ms 0ms 05 60 52ms 0ms 06 60 56ms 0ms 07 60 53ms 0ms 08 60 53ms 0ms 09 60 52ms 0ms 10 60 53ms 0ms 11 60 53ms 0ms 12 60 53ms 0ms 13 48 44ms 0ms -
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:15:07 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:21:08 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:12:07 Duration: 2ms
8 1,057 378ms 0ms 2ms 0ms select * from "deployments" order by "name" asc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 20 49 21ms 0ms 21 60 21ms 0ms 22 60 20ms 0ms 23 60 20ms 0ms Oct 23 00 60 20ms 0ms 01 60 21ms 0ms 02 60 21ms 0ms 03 60 21ms 0ms 04 60 21ms 0ms 05 60 21ms 0ms 06 60 22ms 0ms 07 60 21ms 0ms 08 60 21ms 0ms 09 60 21ms 0ms 10 60 20ms 0ms 11 60 20ms 0ms 12 60 20ms 0ms 13 48 17ms 0ms -
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:14:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:12:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-23 13:42:12 Duration: 0ms
9 422 122ms 0ms 1ms 0ms select * from "orphaned_vms";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 20 18 7ms 0ms 21 24 7ms 0ms 22 24 6ms 0ms 23 24 7ms 0ms Oct 23 00 24 6ms 0ms 01 24 7ms 0ms 02 24 6ms 0ms 03 24 6ms 0ms 04 24 7ms 0ms 05 24 7ms 0ms 06 24 7ms 0ms 07 24 6ms 0ms 08 24 6ms 0ms 09 24 7ms 0ms 10 24 7ms 0ms 11 24 5ms 0ms 12 24 6ms 0ms 13 20 5ms 0ms -
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 20:40:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 21:10:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-23 06:05:00 Duration: 0ms
10 334 481ms 1ms 5ms 1ms select "pg_attribute"."attname" AS "name", cast("pg_attribute"."atttypid" as integer) AS "oid", cast("basetype"."oid" as integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", not "pg_attribute"."attnotnull" AS "allow_null", coalesce(("pg_attribute"."attnum" = any ("pg_index"."indkey")), false) AS "primary_key" from "pg_class" inner join "pg_attribute" on ("pg_attribute"."attrelid" = "pg_class"."oid") inner join "pg_type" on ("pg_type"."oid" = "pg_attribute"."atttypid") left outer join "pg_type" AS "basetype" on ("basetype"."oid" = "pg_type"."typbasetype") left outer join "pg_attrdef" on (("pg_attrdef"."adrelid" = "pg_class"."oid") and ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) left outer join "pg_index" on (("pg_index"."indrelid" = "pg_class"."oid") and ("pg_index"."indisprimary" is true)) where (("pg_attribute"."attisdropped" is false) and ("pg_attribute"."attnum" > ?) and ("pg_class"."oid" = cast(cast(? as regclass) as oid))) order by "pg_attribute"."attnum";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 333 477ms 1ms Oct 23 06 1 4ms 4ms -
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"compiled_packages"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:10:03 Duration: 5ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"delayed_jobs"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-23 06:00:00 Duration: 4ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"agent_dns_versions"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:09:56 Duration: 3ms
11 70 31ms 0ms 2ms 0ms select * from "networks" where (orphaned = true and orphaned_at < ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 2ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 3ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-22 06:00:00.181345+0000');
Date: 2019-10-23 06:00:00 Duration: 2ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.236959+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.230017+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
12 70 30ms 0ms 1ms 0ms select * from "orphan_disks" where (created_at < ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 22 20 2 1ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 1ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 2ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:00:00.015610+0000');
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:30:00.228498+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-18 06:30:00.080123+0000');
Date: 2019-10-23 06:30:00 Duration: 1ms
13 70 27ms 0ms 1ms 0ms select count(*) AS "count" from "local_dns_blobs" limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 1ms 0ms 07 4 1ms 0ms 08 4 2ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-23 08:30:00 Duration: 0ms
14 34 18ms 0ms 2ms 0ms select count(*) AS "count" from "events" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 21 2 3ms 1ms 22 2 1ms 0ms 23 2 0ms 0ms Oct 23 00 2 1ms 0ms 01 2 1ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 1ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms -
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 2ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-23 07:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 22:00:00 Duration: 1ms
15 34 3ms 0ms 0ms 0ms set standard_conforming_strings = on;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 22 20 29 2ms 0ms 21 1 0ms 0ms Oct 23 06 2 0ms 0ms 07 2 0ms 0ms -
SET standard_conforming_strings = ON;
Date: 2019-10-23 06:00:00 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:09:22 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:14:07 Duration: 0ms
16 34 1ms 0ms 0ms 0ms set client_min_messages = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 22 20 29 1ms 0ms 21 1 0ms 0ms Oct 23 06 2 0ms 0ms 07 2 0ms 0ms -
SET client_min_messages = 'WARNING';
Date: 2019-10-22 20:30:00 Duration: 0ms
-
SET client_min_messages = 'WARNING';
Date: 2019-10-23 06:00:00 Duration: 0ms
-
SET client_min_messages = 'WARNING';
Date: 2019-10-22 20:09:53 Duration: 0ms
17 34 1ms 0ms 0ms 0ms set datestyle = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 22 20 29 0ms 0ms 21 1 0ms 0ms Oct 23 06 2 0ms 0ms 07 2 0ms 0ms -
SET DateStyle = 'ISO';
Date: 2019-10-23 06:00:10 Duration: 0ms
-
SET DateStyle = 'ISO';
Date: 2019-10-22 20:12:07 Duration: 0ms
-
SET DateStyle = 'ISO';
Date: 2019-10-22 21:00:00 Duration: 0ms
18 17 5ms 0ms 0ms 0ms select cast(current_setting(?) as integer) as v;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 22 20 17 5ms 0ms -
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:53 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:51 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:10:02 Duration: 0ms
19 8 2ms 0ms 0ms 0ms select * from "tasks" where "id" = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 23 06 4 1ms 0ms 07 4 0ms 0ms -
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
-
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
-
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
20 7 2ms 0ms 0ms 0ms select * from "director_attributes" where ("name" = ?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 22 20 7 2ms 0ms -
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:10:05 Duration: 0ms
-
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:09:57 Duration: 0ms
-
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:10:08 Duration: 0ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2ms 5ms 3ms 2 7ms insert into "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") values (?, ?, ?, ?, null, ?, ?, ?, ?, ?) returning *;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 06 1 5ms 5ms 07 1 2ms 2ms -
INSERT INTO "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") VALUES ('scheduler', 'snapshot_self', 'scheduled SnapshotSelf', 'queued', NULL, '2019-10-23 06:00:00.170351+0000', '2019-10-23 06:00:00.170357+0000', '', '', '') RETURNING *;
Date: 2019-10-23 06:00:00 Duration: 5ms
-
INSERT INTO "tasks" ("username", "type", "description", "state", "deployment_name", "timestamp", "checkpoint_time", "context_id", "result_output", "event_output") VALUES ('scheduler', 'snapshot_deployments', 'scheduled SnapshotDeployments', 'queued', NULL, '2019-10-23 07:00:00.327625+0000', '2019-10-23 07:00:00.327629+0000', '', '', '') RETURNING *;
Date: 2019-10-23 07:00:00 Duration: 2ms
2 1ms 3ms 2ms 2 4ms select * from "tasks" where (state not in (...) and type = ?) order by "id" desc limit ? offset ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 23 06 1 3ms 3ms 07 1 1ms 1ms -
SELECT * FROM "tasks" WHERE (state NOT IN ('processing', 'queued') and type = 'snapshot_self') ORDER BY "id" DESC LIMIT 10 OFFSET 2000;
Date: 2019-10-23 06:00:00 Duration: 3ms
-
SELECT * FROM "tasks" WHERE (state NOT IN ('processing', 'queued') and type = 'snapshot_deployments') ORDER BY "id" DESC LIMIT 10 OFFSET 2000;
Date: 2019-10-23 07:00:00 Duration: 1ms
3 1ms 3ms 2ms 2 4ms select * from "tasks" where ("id" = ?) limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 23 06 1 1ms 1ms 07 1 3ms 3ms -
SELECT * FROM "tasks" WHERE ("id" = 32) LIMIT 1;
Date: 2019-10-23 07:00:00 Duration: 3ms
-
SELECT * FROM "tasks" WHERE ("id" = 31) LIMIT 1;
Date: 2019-10-23 06:00:00 Duration: 1ms
4 1ms 5ms 1ms 334 481ms select "pg_attribute"."attname" AS "name", cast("pg_attribute"."atttypid" as integer) AS "oid", cast("basetype"."oid" as integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", not "pg_attribute"."attnotnull" AS "allow_null", coalesce(("pg_attribute"."attnum" = any ("pg_index"."indkey")), false) AS "primary_key" from "pg_class" inner join "pg_attribute" on ("pg_attribute"."attrelid" = "pg_class"."oid") inner join "pg_type" on ("pg_type"."oid" = "pg_attribute"."atttypid") left outer join "pg_type" AS "basetype" on ("basetype"."oid" = "pg_type"."typbasetype") left outer join "pg_attrdef" on (("pg_attrdef"."adrelid" = "pg_class"."oid") and ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) left outer join "pg_index" on (("pg_index"."indrelid" = "pg_class"."oid") and ("pg_index"."indisprimary" is true)) where (("pg_attribute"."attisdropped" is false) and ("pg_attribute"."attnum" > ?) and ("pg_class"."oid" = cast(cast(? as regclass) as oid))) order by "pg_attribute"."attnum";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 22 20 333 477ms 1ms Oct 23 06 1 4ms 4ms -
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"compiled_packages"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:10:03 Duration: 5ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"delayed_jobs"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-23 06:00:00 Duration: 4ms
-
SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", CAST("basetype"."oid" AS integer) AS "base_oid", format_type("basetype"."oid", "pg_type"."typtypmod") AS "db_base_type", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type", pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY ("pg_index"."indkey")), false) AS "primary_key" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type"."oid" = "pg_attribute"."atttypid") LEFT OUTER JOIN "pg_type" AS "basetype" ON ("basetype"."oid" = "pg_type"."typbasetype") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TRUE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."oid" = CAST(CAST('"agent_dns_versions"' AS regclass) AS oid))) ORDER BY "pg_attribute"."attnum";
Date: 2019-10-22 20:09:56 Duration: 3ms
5 0ms 2ms 1ms 4 5ms update "tasks" set "state" = ?, "timestamp" = ?, "description" = ?, "result" = null, "output" = ?, "checkpoint_time" = ?, "type" = ?, "username" = ?, "deployment_name" = null, "started_at" = null, "event_output" = ?, "result_output" = ?, "context_id" = ? where ("id" = ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 23 06 2 3ms 1ms 07 2 2ms 1ms -
UPDATE "tasks" SET "state" = 'queued', "timestamp" = '2019-10-23 06:00:00.170351+0000', "description" = 'scheduled SnapshotSelf', "result" = NULL, "output" = '/var/vcap/store/director/tasks/31', "checkpoint_time" = '2019-10-23 06:00:00.170357+0000', "type" = 'snapshot_self', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 31);
Date: 2019-10-23 06:00:00 Duration: 2ms
-
UPDATE "tasks" SET "state" = 'queued', "timestamp" = '2019-10-23 07:00:00.327625+0000', "description" = 'scheduled SnapshotDeployments', "result" = NULL, "output" = '/var/vcap/store/director/tasks/32', "checkpoint_time" = '2019-10-23 07:00:00.327629+0000', "type" = 'snapshot_deployments', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 32);
Date: 2019-10-23 07:00:00 Duration: 1ms
-
UPDATE "tasks" SET "state" = 'processing', "timestamp" = '2019-10-23 07:00:00.327625+0000', "description" = 'scheduled SnapshotDeployments', "result" = NULL, "output" = '/var/vcap/store/director/tasks/32', "checkpoint_time" = '2019-10-23 07:00:00.414249+0000', "type" = 'snapshot_deployments', "username" = 'scheduler', "deployment_name" = NULL, "started_at" = NULL, "event_output" = '', "result_output" = '', "context_id" = '' WHERE ("id" = 32);
Date: 2019-10-23 07:00:00 Duration: 0ms
6 0ms 2ms 0ms 1,057 954ms select * from "configs" where (("deleted" is false) and ("type" = ?) and ("id" in ( select max("id") from "configs" where (("deleted" is false) and ("type" = ?)) group by "type", "name"))) order by "type", ( case when ("name" = ?) then ? else ? end), "name", "id" desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 49 49ms 1ms 21 60 54ms 0ms 22 60 53ms 0ms 23 60 53ms 0ms Oct 23 00 60 53ms 0ms 01 60 55ms 0ms 02 60 52ms 0ms 03 60 52ms 0ms 04 60 53ms 0ms 05 60 52ms 0ms 06 60 56ms 0ms 07 60 53ms 0ms 08 60 53ms 0ms 09 60 52ms 0ms 10 60 53ms 0ms 11 60 53ms 0ms 12 60 53ms 0ms 13 48 44ms 0ms -
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:15:07 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:21:08 Duration: 2ms
-
SELECT * FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection') AND ("id" IN ( SELECT max("id") FROM "configs" WHERE (("deleted" IS FALSE) AND ("type" = 'resurrection')) GROUP BY "type", "name"))) ORDER BY "type", ( CASE WHEN ("name" = 'default') THEN 1 ELSE 2 END), "name", "id" DESC;
Date: 2019-10-22 20:12:07 Duration: 2ms
7 0ms 10ms 0ms 250,234 2m18s select * from "delayed_jobs" where (((("run_at" <= ?) and ("locked_at" is null)) or ("locked_at" < ?) or ("locked_by" = ?)) and ("failed_at" is null) and ("queue" in (...))) order by "priority" asc, "run_at" asc limit ? for update;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration 23 5 2ms 0ms Oct 22 20 11,665 6s343ms 0ms 21 14,149 7s851ms 0ms 22 14,196 7s833ms 0ms 23 14,192 7s836ms 0ms Oct 23 00 14,200 7s843ms 0ms 01 14,216 7s748ms 0ms 02 14,228 7s797ms 0ms 03 14,296 7s995ms 0ms 04 14,298 8s237ms 0ms 05 14,298 8s255ms 0ms 06 14,269 7s965ms 0ms 07 14,281 8s96ms 0ms 08 14,300 8s107ms 0ms 09 14,276 8s168ms 0ms 10 14,136 7s684ms 0ms 11 13,944 7s463ms 0ms 12 14,016 7s496ms 0ms 13 11,269 6s227ms 0ms -
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:30:07.705333+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:30:07.705333+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:30:09 Duration: 10ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:09:22.962184+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:09:22.962184+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:09:23 Duration: 9ms
-
SELECT * FROM "delayed_jobs" WHERE (((("run_at" <= '2019-10-22 20:11:28.477364+0000') AND ("locked_at" IS NULL)) OR ("locked_at" < '2018-10-22 20:11:28.477364+0000') OR ("locked_by" = 'worker_1')) AND ("failed_at" IS NULL) AND ("queue" IN ('urgent'))) ORDER BY "priority" ASC, "run_at" ASC LIMIT 1 FOR UPDATE;
Date: 2019-10-22 20:11:28 Duration: 8ms
8 0ms 2ms 0ms 34 18ms select count(*) AS "count" from "events" limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 21 2 3ms 1ms 22 2 1ms 0ms 23 2 0ms 0ms Oct 23 00 2 1ms 0ms 01 2 1ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 1ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms -
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 2ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-23 07:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "events" LIMIT 1;
Date: 2019-10-22 22:00:00 Duration: 1ms
9 0ms 2ms 0ms 70 31ms select * from "networks" where (orphaned = true and orphaned_at < ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 2ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 3ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-22 06:00:00.181345+0000');
Date: 2019-10-23 06:00:00 Duration: 2ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.236959+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "networks" WHERE (orphaned = true and orphaned_at < '2019-10-21 21:30:00.230017+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
10 0ms 1ms 0ms 70 30ms select * from "orphan_disks" where (created_at < ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 2 1ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 1ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 2ms 0ms 07 4 1ms 0ms 08 4 1ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:00:00.015610+0000');
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-17 21:30:00.228498+0000');
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT * FROM "orphan_disks" WHERE (created_at < '2019-10-18 06:30:00.080123+0000');
Date: 2019-10-23 06:30:00 Duration: 1ms
11 0ms 1ms 0ms 70 27ms select count(*) AS "count" from "local_dns_blobs" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 2 0ms 0ms 21 4 3ms 0ms 22 4 1ms 0ms 23 4 1ms 0ms Oct 23 00 4 1ms 0ms 01 4 1ms 0ms 02 4 1ms 0ms 03 4 0ms 0ms 04 4 1ms 0ms 05 4 1ms 0ms 06 4 1ms 0ms 07 4 1ms 0ms 08 4 2ms 0ms 09 4 1ms 0ms 10 4 1ms 0ms 11 4 1ms 0ms 12 4 1ms 0ms 13 4 1ms 0ms -
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:30:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-22 21:00:00 Duration: 1ms
-
SELECT count(*) AS "count" FROM "local_dns_blobs" LIMIT 1;
Date: 2019-10-23 08:30:00 Duration: 0ms
12 0ms 2ms 0ms 1,057 378ms select * from "deployments" order by "name" asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 22 20 49 21ms 0ms 21 60 21ms 0ms 22 60 20ms 0ms 23 60 20ms 0ms Oct 23 00 60 20ms 0ms 01 60 21ms 0ms 02 60 21ms 0ms 03 60 21ms 0ms 04 60 21ms 0ms 05 60 21ms 0ms 06 60 22ms 0ms 07 60 21ms 0ms 08 60 21ms 0ms 09 60 21ms 0ms 10 60 20ms 0ms 11 60 20ms 0ms 12 60 20ms 0ms 13 48 17ms 0ms -
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:14:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-22 20:12:07 Duration: 2ms
-
SELECT * FROM "deployments" ORDER BY "name" ASC;
Date: 2019-10-23 13:42:12 Duration: 0ms
13 0ms 0ms 0ms 7 2ms select * from "director_attributes" where ("name" = ?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 7 2ms 0ms -
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:10:05 Duration: 0ms
-
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:09:57 Duration: 0ms
-
SELECT * FROM "director_attributes" WHERE ("name" = 'uuid') LIMIT 1;
Date: 2019-10-22 20:10:08 Duration: 0ms
14 0ms 3ms 0ms 6,345 2s35ms select * from "local_dns_blobs" order by "version" desc limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 20 303 98ms 0ms 21 359 114ms 0ms 22 360 116ms 0ms 23 360 116ms 0ms Oct 23 00 360 114ms 0ms 01 359 116ms 0ms 02 360 116ms 0ms 03 360 115ms 0ms 04 360 114ms 0ms 05 360 116ms 0ms 06 359 114ms 0ms 07 360 116ms 0ms 08 360 115ms 0ms 09 360 114ms 0ms 10 359 113ms 0ms 11 359 113ms 0ms 12 359 114ms 0ms 13 288 92ms 0ms -
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 20:09:22 Duration: 3ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-22 23:58:55 Duration: 0ms
-
SELECT * FROM "local_dns_blobs" ORDER BY "version" DESC LIMIT 1;
Date: 2019-10-23 07:35:11 Duration: 0ms
15 0ms 0ms 0ms 17 5ms select cast(current_setting(?) as integer) as v;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 22 20 17 5ms 0ms -
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:53 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:09:51 Duration: 0ms
-
SELECT CAST(current_setting('server_version_num') AS integer) AS v;
Date: 2019-10-22 20:10:02 Duration: 0ms
16 0ms 1ms 0ms 422 122ms select * from "orphaned_vms";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 22 20 18 7ms 0ms 21 24 7ms 0ms 22 24 6ms 0ms 23 24 7ms 0ms Oct 23 00 24 6ms 0ms 01 24 7ms 0ms 02 24 6ms 0ms 03 24 6ms 0ms 04 24 7ms 0ms 05 24 7ms 0ms 06 24 7ms 0ms 07 24 6ms 0ms 08 24 6ms 0ms 09 24 7ms 0ms 10 24 7ms 0ms 11 24 5ms 0ms 12 24 6ms 0ms 13 20 5ms 0ms -
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 20:40:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-22 21:10:00 Duration: 1ms
-
SELECT * FROM "orphaned_vms";
Date: 2019-10-23 06:05:00 Duration: 0ms
17 0ms 0ms 0ms 8 2ms select * from "tasks" where "id" = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 23 06 4 1ms 0ms 07 4 0ms 0ms -
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
-
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
-
SELECT * FROM "tasks" WHERE "id" = 31;
Date: 2019-10-23 06:00:10 Duration: 0ms
18 0ms 5ms 0ms 262,919 38s190ms select null;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration 23 5 0ms 0ms Oct 22 20 12,603 1s678ms 0ms 21 14,845 2s110ms 0ms 22 14,894 2s102ms 0ms 23 14,890 2s88ms 0ms Oct 23 00 14,898 2s105ms 0ms 01 14,914 2s65ms 0ms 02 14,925 2s96ms 0ms 03 14,994 2s231ms 0ms 04 14,996 2s387ms 0ms 05 14,996 2s431ms 0ms 06 14,979 2s247ms 0ms 07 14,990 2s277ms 0ms 08 14,998 2s263ms 0ms 09 14,974 2s326ms 0ms 10 14,834 2s101ms 0ms 11 14,640 1s996ms 0ms 12 14,713 2s 0ms 13 11,831 1s677ms 0ms -
SELECT NULL;
Date: 2019-10-22 23:24:50 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-22 21:26:07 Duration: 5ms
-
SELECT NULL;
Date: 2019-10-23 13:16:33 Duration: 5ms
19 0ms 0ms 0ms 34 3ms set standard_conforming_strings = on;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 22 20 29 2ms 0ms 21 1 0ms 0ms Oct 23 06 2 0ms 0ms 07 2 0ms 0ms -
SET standard_conforming_strings = ON;
Date: 2019-10-23 06:00:00 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:09:22 Duration: 0ms
-
SET standard_conforming_strings = ON;
Date: 2019-10-22 20:14:07 Duration: 0ms
20 0ms 0ms 0ms 6,345 342ms set transaction isolation level read committed;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 22 20 303 15ms 0ms 21 359 19ms 0ms 22 360 19ms 0ms 23 360 19ms 0ms Oct 23 00 360 19ms 0ms 01 359 19ms 0ms 02 360 19ms 0ms 03 360 19ms 0ms 04 360 19ms 0ms 05 360 19ms 0ms 06 359 19ms 0ms 07 360 19ms 0ms 08 360 19ms 0ms 09 360 19ms 0ms 10 359 19ms 0ms 11 359 18ms 0ms 12 359 19ms 0ms 13 288 15ms 0ms -
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:14:07 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 10:52:49 Duration: 0ms
-
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-10-23 07:35:11 Duration: 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 NO DATASET
-
Events
Log levels
Key values
- 2,579,283 Log entries
Events distribution
Key values
- 0 PANIC entries
- 4 FATAL entries
- 17 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 9 Max number of times the same event was reported
- 21 Total events found
Rank Times reported Error 1 9 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 22 20 9 - ERROR: duplicate key value violates unique constraint "oauth_client_details_pkey"
- ERROR: duplicate key value violates unique constraint "external_group_unique_key"
Detail: Key (client_id, identity_zone_id)=(admin, uaa) already exists.
Statement: insert into oauth_client_details (client_secret, resource_ids, scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity, refresh_token_validity, additional_information, autoapprove, lastmodified, required_user_groups, client_id, identity_zone_id, created_by) values ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15)Date: 2019-10-22 20:10:27
Detail: Key (origin, external_group, group_id)=(ldap, cn=test_org,ou=people,o=springsource,o=org, 316e7a9c-5d19-4190-afe5-ccfbce63484f) already exists.
Statement: insert into external_group_mapping ( group_id,external_group,added,origin,identity_zone_id ) values ($1,lower($2),$3,$4,$5)Date: 2019-10-22 20:10:31
2 4 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 22 20 4 - FATAL: the database system is starting up
Date: 2019-10-22 20:09:21
3 3 ERROR: role "..." already exists
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 22 20 3 - ERROR: role "boshdb" already exists
Statement: create role "boshdb" NOSUPERUSER LOGIN INHERIT CREATEDB
Date: 2019-10-22 20:09:22
4 3 ERROR: database "..." already exists
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 22 20 3 - ERROR: database "uaa" already exists
- ERROR: database "credhub" already exists
- ERROR: database "bosh" already exists
Statement: CREATE DATABASE uaa;
Date: 2019-10-22 20:09:22
Statement: CREATE DATABASE credhub;
Date: 2019-10-22 20:09:22
Statement: CREATE DATABASE bosh;
Date: 2019-10-22 20:09:22
5 1 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 22 20 1 - LOG: database system was interrupted; last known up at 2019-10-22 19:55:17 GMT
Date: 2019-10-22 20:09:21
6 1 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 22 20 1 - LOG: database system was not properly shut down; automatic recovery in progress
Date: 2019-10-22 20:09:21