-
Global information
- Generated on Tue Jul 16 20:06:04 2019
- Log file: postgresql.log.2019-07-16-14
- Parsed 163,963 log entries in 18s
- Log start from 2019-07-16 14:01:31 to 2019-07-16 14:32:59
-
Overview
Global Stats
- 22 Number of unique normalized queries
- 159,889 Number of queries
- 7h43m3s Total query duration
- 2019-07-16 14:22:41 First query
- 2019-07-16 14:26:31 Last query
- 2,009 queries/s at 2019-07-16 14:25:48 Query peak
- 466 Number of events
- 6 Number of unique normalized events
- 381 Max number of times the same event was reported
- 0 Number of cancellation
- 5 Total number of automatic vacuums
- 14 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 304 Total number of sessions
- 288 sessions at 2019-07-16 14:24:51 Session peak
- 8h21m19s Total duration of sessions
- 1m38s Average duration of sessions
- 525 Average queries per session
- 1m31s Average queries duration per session
- 304 Total number of connections
- 278 connections/s at 2019-07-16 14:24:51 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2,009 queries/s Query Peak
- 2019-07-16 14:25:48 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2019-07-16 14:26:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2,009 queries/s Query Peak
- 2019-07-16 14:25:48 Date
Queries duration
Key values
- 7h43m3s 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) Jul 16 14 159,889 0ms 8s745ms 173ms 33m2s 2h28m8s 4h41m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 14 4 0 18ms 0ms 19ms 28ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 14 3 158,814 0 1 174ms 0ms 32ms 4h41m42s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 16 14 0 0 0.00 0.00% Day Hour Count Average / Second Jul 16 14 304 0.08/s Day Hour Count Average Duration Jul 16 14 304 1m38s -
Connections
Established Connections
Key values
- 278 connections Connection Peak
- 2019-07-16 14:24:51 Date
Connections per database
Key values
- postgres Main Database
- 304 connections Total
Connections per user
Key values
- postgres Main User
- 304 connections Total
-
Sessions
Simultaneous sessions
Key values
- 288 sessions Session Peak
- 2019-07-16 14:24:51 Date
Histogram of session times
Key values
- 301 60000-600000ms duration
Sessions per database
Key values
- postgres Main Database
- 304 sessions Total
Sessions per user
Key values
- postgres Main User
- 304 sessions Total
Sessions per host
Key values
- 172.31.90.158 Main Host
- 304 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
Checkpoint mean distance and estimate (5 minutes period)
NO DATASET
Checkpoints Activity
Day Hour Written buffers Write time Sync time Total time Jul 16 14 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 16 14 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 16 14 11 17.00s Day Hour Mean distance Mean estimate Jul 16 14 0 0 -
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 Jul 16 14 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
Analyzes per table
Key values
- public.pgbench_history (5) Main table analyzed (database postgres)
- 14 analyzes Total
Vacuums per table
Key values
- public.pgbench_tellers (4) Main table vacuumed on database postgres
- 5 vacuums Total
Tuples removed per table
Key values
- public.pgbench_tellers (23029) Main table with removed tuples on database postgres
- 27376 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Autovacuum Activity
Day Hour VACUUMs ANALYZEs Jul 16 14 5 14 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 451 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 375 12m40s 1s1ms 4s695ms 2s27ms UPDATE pgbench_tellers SET tbalance = tbalance + 0 WHERE tid = 0;-
UPDATE pgbench_tellers SET tbalance = tbalance + - 2432 WHERE tid = 64;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1841 WHERE tid = 78;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 878 WHERE tid = 99;
Date: 2019-07-16 14:25:01 Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:59 Database: postgres User: postgres Remote: 172.31.90.158
2 76 2m2s 1s604ms 1s615ms 1s612ms UPDATE pgbench_branches SET bbalance = bbalance + 0 WHERE bid = 0;-
UPDATE pgbench_branches SET bbalance = bbalance + - 1391 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + - 98 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + 4977 WHERE bid = 3;
Date: 2019-07-16 14:24:57 Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:57 Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:56 Database: postgres User: postgres Remote: 172.31.90.158
Queries that waited the most
Rank Wait time Query 1 4s695ms UPDATE pgbench_tellers SET tbalance = tbalance + - 512 WHERE tid = 53;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
2 4s611ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2459 WHERE tid = 59;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
3 4s607ms UPDATE pgbench_tellers SET tbalance = tbalance + 3745 WHERE tid = 59;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
4 4s574ms UPDATE pgbench_tellers SET tbalance = tbalance + - 3423 WHERE tid = 59;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
5 4s155ms UPDATE pgbench_tellers SET tbalance = tbalance + 1590 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
6 4s155ms UPDATE pgbench_tellers SET tbalance = tbalance + 2339 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
7 4s155ms UPDATE pgbench_tellers SET tbalance = tbalance + - 4703 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
8 4s154ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1721 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
9 4s154ms UPDATE pgbench_tellers SET tbalance = tbalance + - 110 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
10 4s154ms UPDATE pgbench_tellers SET tbalance = tbalance + 2875 WHERE tid = 20;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
11 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1683 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
12 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 4013 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
13 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 3979 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
14 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 2838 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
15 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 2351 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
16 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2271 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
17 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 2847 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
18 3s884ms UPDATE pgbench_tellers SET tbalance = tbalance + 2779 WHERE tid = 17;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
19 3s883ms UPDATE pgbench_tellers SET tbalance = tbalance + - 4973 WHERE tid = 84;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
20 3s627ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2690 WHERE tid = 37;[ Date: 2019-07-16 14:24:56 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
-
Queries
Queries by type
Key values
- 4 Total read queries
- 159,878 Total write queries
Queries by database
Key values
- postgres Main database
- 159,889 Requests
- 7h43m3s (postgres)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 159,889 Requests
User Request type Count Duration postgres Total 159,889 7h43m3s COPY FROM 1 2s210ms DDL 16 0ms INSERT 3 32ms OTHERS 3 1s322ms SELECT 4 73ms TCL 1,044 15s245ms UPDATE 158,814 7h42m41s Duration by user
Key values
- 7h43m3s (postgres) Main time consuming user
User Request type Count Duration postgres Total 159,889 7h43m3s COPY FROM 1 2s210ms DDL 16 0ms INSERT 3 32ms OTHERS 3 1s322ms SELECT 4 73ms TCL 1,044 15s245ms UPDATE 158,814 7h42m41s Queries by host
Key values
- 172.31.90.158 Main host
- 159,889 Requests
- 7h43m3s (172.31.90.158)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 159,889 Requests
- 7h43m3s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-07-16 14:25:12 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 54,475 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8s745ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2432 WHERE tid = 64;[ Date: 2019-07-16 14:25:01 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
2 8s101ms UPDATE pgbench_tellers SET tbalance = tbalance + 1841 WHERE tid = 78;[ Date: 2019-07-16 14:25:00 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
3 7s184ms UPDATE pgbench_tellers SET tbalance = tbalance + 878 WHERE tid = 99;[ Date: 2019-07-16 14:24:59 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
4 6s837ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2803 WHERE tid = 21;[ Date: 2019-07-16 14:24:59 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
5 6s786ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2726 WHERE tid = 64;[ Date: 2019-07-16 14:24:59 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
6 6s729ms UPDATE pgbench_tellers SET tbalance = tbalance + - 528 WHERE tid = 23;[ Date: 2019-07-16 14:24:59 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
7 6s706ms UPDATE pgbench_tellers SET tbalance = tbalance + - 3462 WHERE tid = 23;[ Date: 2019-07-16 14:24:59 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
8 6s476ms UPDATE pgbench_tellers SET tbalance = tbalance + 2838 WHERE tid = 17;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
9 6s220ms UPDATE pgbench_tellers SET tbalance = tbalance + 2351 WHERE tid = 17;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
10 5s710ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1683 WHERE tid = 17;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
11 5s643ms UPDATE pgbench_tellers SET tbalance = tbalance + 4367 WHERE tid = 64;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
12 5s643ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2832 WHERE tid = 64;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
13 5s602ms UPDATE pgbench_tellers SET tbalance = tbalance + 4013 WHERE tid = 17;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
14 5s511ms UPDATE pgbench_tellers SET tbalance = tbalance + 4297 WHERE tid = 21;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
15 5s511ms UPDATE pgbench_tellers SET tbalance = tbalance + 3979 WHERE tid = 17;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
16 5s502ms UPDATE pgbench_tellers SET tbalance = tbalance + 3728 WHERE tid = 23;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
17 5s494ms UPDATE pgbench_tellers SET tbalance = tbalance + 250 WHERE tid = 19;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
18 5s485ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1997 WHERE tid = 21;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
19 5s482ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1721 WHERE tid = 20;[ Date: 2019-07-16 14:24:57 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
20 5s463ms UPDATE pgbench_tellers SET tbalance = tbalance + - 215 WHERE tid = 91;[ Date: 2019-07-16 14:24:58 - Database: postgres - User: postgres - Remote: 172.31.90.158 ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6h2m24s 77,663 10ms 8s745ms 279ms UPDATE pgbench_tellers SET tbalance = tbalance + 0 WHERE tid = 0;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 14 77,663 6h2m24s 279ms [ User: postgres - Total duration: 6h2m24s - Times executed: 77663 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 2432 WHERE tid = 64;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1841 WHERE tid = 78;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 878 WHERE tid = 99;
Date: 2019-07-16 14:25:01 Duration: 8s745ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 8s101ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:59 Duration: 7s184ms Database: postgres User: postgres Remote: 172.31.90.158
2 1h40m4s 81,034 10ms 4s723ms 74ms UPDATE pgbench_branches SET bbalance = bbalance + 0 WHERE bid = 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 14 81,034 1h40m4s 74ms [ User: postgres - Total duration: 1h40m4s - Times executed: 81034 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + - 1391 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + - 98 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + 4977 WHERE bid = 3;
Date: 2019-07-16 14:24:57 Duration: 4s723ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:57 Duration: 4s637ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:56 Duration: 3s906ms Database: postgres User: postgres Remote: 172.31.90.158
3 15s245ms 1,044 10ms 43ms 14ms END;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 14 1,044 15s245ms 14ms [ User: postgres - Total duration: 15s245ms - Times executed: 1044 ]
-
END;
-
END;
-
END;
Date: 2019-07-16 14:26:00 Duration: 43ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
4 12s773ms 117 10ms 990ms 109ms UPDATE pgbench_accounts SET abalance = abalance + 0 WHERE aid = 0;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 14 117 12s773ms 109ms [ User: postgres - Total duration: 12s773ms - Times executed: 117 ]
-
UPDATE pgbench_accounts SET abalance = abalance + 4494 WHERE aid = 601781;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4637 WHERE aid = 594685;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4198 WHERE aid = 835554;
Date: 2019-07-16 14:26:11 Duration: 990ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:28 Duration: 888ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 681ms Database: postgres User: postgres Remote: 172.31.90.158
5 2s210ms 1 2s210ms 2s210ms 2s210ms COPY pgbench_accounts FROM STDIN;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 14 1 2s210ms 2s210ms [ User: postgres - Total duration: 2s210ms - Times executed: 1 ]
-
COPY pgbench_accounts FROM STDIN;
Date: 2019-07-16 14:24:12 Duration: 2s210ms Database: postgres User: postgres Remote: 172.31.90.158
6 1s293ms 1 1s293ms 1s293ms 1s293ms VACUUM ANALYZE pgbench_accounts;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 14 1 1s293ms 1s293ms [ User: postgres - Total duration: 1s293ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_accounts;
Date: 2019-07-16 14:24:14 Duration: 1s293ms Database: postgres User: postgres Remote: 172.31.90.158
7 44ms 3 11ms 19ms 14ms SELECT abalance FROM pgbench_accounts WHERE aid = 0;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 14 3 44ms 14ms [ User: postgres - Total duration: 44ms - Times executed: 3 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 264571;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 506270;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 940039;
Date: 2019-07-16 14:26:12 Duration: 19ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:26 Duration: 13ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
8 32ms 3 10ms 11ms 10ms INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (0, 0, 0, 0, current_timestamp);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 14 3 32ms 10ms [ User: postgres - Total duration: 32ms - Times executed: 3 ]
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (10, 9, 623984, 1808, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (70, 1, 611886, 4583, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (53, 9, 644594, - 3338, current_timestamp);
Date: 2019-07-16 14:25:58 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:40 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:58 Duration: 10ms Database: postgres User: postgres Remote: 172.31.90.158
9 28ms 1 28ms 28ms 28ms SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN (...) AND substring (pg_catalog.quote_ident (c.relname), 0, 0) = '' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = '' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) > 0 UNION SELECT pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN (...) AND substring (pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname), 0, 0) = '' AND substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 0) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) = 0 LIMIT 0;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 14 1 28ms 28ms [ User: postgres - Total duration: 28ms - Times executed: 1 ]
-
SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = 'pg_stat_Ac' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) > 1 UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 1) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) = 1 LIMIT 1000;
Date: 2019-07-16 14:23:23 Duration: 28ms Database: postgres User: postgres Remote: 172.31.90.158
10 16ms 1 16ms 16ms 16ms VACUUM ANALYZE pgbench_branches;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 14 1 16ms 16ms [ User: postgres - Total duration: 16ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_branches;
Date: 2019-07-16 14:24:12 Duration: 16ms Database: postgres User: postgres Remote: 172.31.90.158
11 11ms 1 11ms 11ms 11ms VACUUM ANALYZE pgbench_history;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 14 1 11ms 11ms [ User: postgres - Total duration: 11ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_history;
Date: 2019-07-16 14:24:14 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 81,034 1h40m4s 10ms 4s723ms 74ms UPDATE pgbench_branches SET bbalance = bbalance + 0 WHERE bid = 0;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 14 81,034 1h40m4s 74ms [ User: postgres - Total duration: 1h40m4s - Times executed: 81034 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + - 1391 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + - 98 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + 4977 WHERE bid = 3;
Date: 2019-07-16 14:24:57 Duration: 4s723ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:57 Duration: 4s637ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:56 Duration: 3s906ms Database: postgres User: postgres Remote: 172.31.90.158
2 77,663 6h2m24s 10ms 8s745ms 279ms UPDATE pgbench_tellers SET tbalance = tbalance + 0 WHERE tid = 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 14 77,663 6h2m24s 279ms [ User: postgres - Total duration: 6h2m24s - Times executed: 77663 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 2432 WHERE tid = 64;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1841 WHERE tid = 78;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 878 WHERE tid = 99;
Date: 2019-07-16 14:25:01 Duration: 8s745ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 8s101ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:59 Duration: 7s184ms Database: postgres User: postgres Remote: 172.31.90.158
3 1,044 15s245ms 10ms 43ms 14ms END;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 14 1,044 15s245ms 14ms [ User: postgres - Total duration: 15s245ms - Times executed: 1044 ]
-
END;
-
END;
-
END;
Date: 2019-07-16 14:26:00 Duration: 43ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
4 117 12s773ms 10ms 990ms 109ms UPDATE pgbench_accounts SET abalance = abalance + 0 WHERE aid = 0;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 14 117 12s773ms 109ms [ User: postgres - Total duration: 12s773ms - Times executed: 117 ]
-
UPDATE pgbench_accounts SET abalance = abalance + 4494 WHERE aid = 601781;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4637 WHERE aid = 594685;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4198 WHERE aid = 835554;
Date: 2019-07-16 14:26:11 Duration: 990ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:28 Duration: 888ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 681ms Database: postgres User: postgres Remote: 172.31.90.158
5 3 32ms 10ms 11ms 10ms INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (0, 0, 0, 0, current_timestamp);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 14 3 32ms 10ms [ User: postgres - Total duration: 32ms - Times executed: 3 ]
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (10, 9, 623984, 1808, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (70, 1, 611886, 4583, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (53, 9, 644594, - 3338, current_timestamp);
Date: 2019-07-16 14:25:58 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:40 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:58 Duration: 10ms Database: postgres User: postgres Remote: 172.31.90.158
6 3 44ms 11ms 19ms 14ms SELECT abalance FROM pgbench_accounts WHERE aid = 0;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 14 3 44ms 14ms [ User: postgres - Total duration: 44ms - Times executed: 3 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 264571;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 506270;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 940039;
Date: 2019-07-16 14:26:12 Duration: 19ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:26 Duration: 13ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
7 2 0ms 0ms 0ms 0ms DROP TABLE IF EXISTS pgbench_accounts;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 14 2 0ms 0ms 8 2 0ms 0ms 0ms 0ms CREATE TABLE pgbench_history ( tid INT, bid INT, aid INT, DELTA INT, mtime TIMESTAMP, filler char (0));Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 14 2 0ms 0ms 9 2 0ms 0ms 0ms 0ms DROP TABLE IF EXISTS pgbench_tellers;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 14 2 0ms 0ms 10 2 0ms 0ms 0ms 0ms CREATE TABLE pgbench_tellers ( tid INT NOT NULL, bid INT, tbalance INT, filler char (0)) WITH ( fillfactor = 0);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 14 2 0ms 0ms 11 2 0ms 0ms 0ms 0ms DROP TABLE IF EXISTS pgbench_history;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 14 2 0ms 0ms 12 1 11ms 11ms 11ms 11ms VACUUM ANALYZE pgbench_history;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 14 1 11ms 11ms [ User: postgres - Total duration: 11ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_history;
Date: 2019-07-16 14:24:14 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
13 1 0ms 0ms 0ms 0ms ALTER TABLE pgbench_branches ADD PRIMARY KEY (bid);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 14 1 0ms 0ms 14 1 0ms 0ms 0ms 0ms CREATE TABLE pgbench_branches ( bid INT NOT NULL, bbalance INT, filler char (0)) WITH ( fillfactor = 0);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 14 1 0ms 0ms 15 1 28ms 28ms 28ms 28ms SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN (...) AND substring (pg_catalog.quote_ident (c.relname), 0, 0) = '' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = '' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) > 0 UNION SELECT pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN (...) AND substring (pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname), 0, 0) = '' AND substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 0) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) = 0 LIMIT 0;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 14 1 28ms 28ms [ User: postgres - Total duration: 28ms - Times executed: 1 ]
-
SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = 'pg_stat_Ac' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) > 1 UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 1) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) = 1 LIMIT 1000;
Date: 2019-07-16 14:23:23 Duration: 28ms Database: postgres User: postgres Remote: 172.31.90.158
16 1 16ms 16ms 16ms 16ms VACUUM ANALYZE pgbench_branches;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 14 1 16ms 16ms [ User: postgres - Total duration: 16ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_branches;
Date: 2019-07-16 14:24:12 Duration: 16ms Database: postgres User: postgres Remote: 172.31.90.158
17 1 0ms 0ms 0ms 0ms ALTER TABLE pgbench_tellers ADD PRIMARY KEY (tid);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 14 1 0ms 0ms 18 1 1s293ms 1s293ms 1s293ms 1s293ms VACUUM ANALYZE pgbench_accounts;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 14 1 1s293ms 1s293ms [ User: postgres - Total duration: 1s293ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_accounts;
Date: 2019-07-16 14:24:14 Duration: 1s293ms Database: postgres User: postgres Remote: 172.31.90.158
19 1 0ms 0ms 0ms 0ms CREATE TABLE pgbench_accounts ( aid INT NOT NULL, bid INT, abalance INT, filler char (0)) WITH ( fillfactor = 0);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 14 1 0ms 0ms 20 1 0ms 0ms 0ms 0ms DROP TABLE IF EXISTS pgbench_branches;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 14 1 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s210ms 2s210ms 2s210ms 1 2s210ms COPY pgbench_accounts FROM STDIN;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 14 1 2s210ms 2s210ms [ User: postgres - Total duration: 2s210ms - Times executed: 1 ]
-
COPY pgbench_accounts FROM STDIN;
Date: 2019-07-16 14:24:12 Duration: 2s210ms Database: postgres User: postgres Remote: 172.31.90.158
2 1s293ms 1s293ms 1s293ms 1 1s293ms VACUUM ANALYZE pgbench_accounts;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 14 1 1s293ms 1s293ms [ User: postgres - Total duration: 1s293ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_accounts;
Date: 2019-07-16 14:24:14 Duration: 1s293ms Database: postgres User: postgres Remote: 172.31.90.158
3 10ms 8s745ms 279ms 77,663 6h2m24s UPDATE pgbench_tellers SET tbalance = tbalance + 0 WHERE tid = 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 14 77,663 6h2m24s 279ms [ User: postgres - Total duration: 6h2m24s - Times executed: 77663 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 2432 WHERE tid = 64;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1841 WHERE tid = 78;
-
UPDATE pgbench_tellers SET tbalance = tbalance + 878 WHERE tid = 99;
Date: 2019-07-16 14:25:01 Duration: 8s745ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 8s101ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:59 Duration: 7s184ms Database: postgres User: postgres Remote: 172.31.90.158
4 10ms 990ms 109ms 117 12s773ms UPDATE pgbench_accounts SET abalance = abalance + 0 WHERE aid = 0;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 14 117 12s773ms 109ms [ User: postgres - Total duration: 12s773ms - Times executed: 117 ]
-
UPDATE pgbench_accounts SET abalance = abalance + 4494 WHERE aid = 601781;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4637 WHERE aid = 594685;
-
UPDATE pgbench_accounts SET abalance = abalance + - 4198 WHERE aid = 835554;
Date: 2019-07-16 14:26:11 Duration: 990ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:28 Duration: 888ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 681ms Database: postgres User: postgres Remote: 172.31.90.158
5 10ms 4s723ms 74ms 81,034 1h40m4s UPDATE pgbench_branches SET bbalance = bbalance + 0 WHERE bid = 0;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 14 81,034 1h40m4s 74ms [ User: postgres - Total duration: 1h40m4s - Times executed: 81034 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + - 1391 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + - 98 WHERE bid = 3;
-
UPDATE pgbench_branches SET bbalance = bbalance + 4977 WHERE bid = 3;
Date: 2019-07-16 14:24:57 Duration: 4s723ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:57 Duration: 4s637ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:24:56 Duration: 3s906ms Database: postgres User: postgres Remote: 172.31.90.158
6 28ms 28ms 28ms 1 28ms SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN (...) AND substring (pg_catalog.quote_ident (c.relname), 0, 0) = '' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = '' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) > 0 UNION SELECT pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN (...) AND substring (pg_catalog.quote_ident (n.nspname) || '' || pg_catalog.quote_ident (c.relname), 0, 0) = '' AND substring (pg_catalog.quote_ident (n.nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 0) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '', 0, 0) = substring ('', 0, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 0)) = 0 LIMIT 0;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 14 1 28ms 28ms [ User: postgres - Total duration: 28ms - Times executed: 1 ]
-
SELECT pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND pg_catalog.pg_table_is_visible (c.oid) UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' FROM pg_catalog.pg_namespace n WHERE substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = 'pg_stat_Ac' AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) > 1 UNION SELECT pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname) FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') AND substring (pg_catalog.quote_ident (n.nspname) || '.' || pg_catalog.quote_ident (c.relname), 1, 10) = 'pg_stat_Ac' AND substring (pg_catalog.quote_ident (n.nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (n.nspname)) + 1) AND ( SELECT pg_catalog.count (*) FROM pg_catalog.pg_namespace WHERE substring (pg_catalog.quote_ident (nspname) || '.', 1, 10) = substring ('pg_stat_Ac', 1, pg_catalog.length (pg_catalog.quote_ident (nspname)) + 1)) = 1 LIMIT 1000;
Date: 2019-07-16 14:23:23 Duration: 28ms Database: postgres User: postgres Remote: 172.31.90.158
7 16ms 16ms 16ms 1 16ms VACUUM ANALYZE pgbench_branches;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 14 1 16ms 16ms [ User: postgres - Total duration: 16ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_branches;
Date: 2019-07-16 14:24:12 Duration: 16ms Database: postgres User: postgres Remote: 172.31.90.158
8 11ms 19ms 14ms 3 44ms SELECT abalance FROM pgbench_accounts WHERE aid = 0;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 14 3 44ms 14ms [ User: postgres - Total duration: 44ms - Times executed: 3 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 264571;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 506270;
-
SELECT abalance FROM pgbench_accounts WHERE aid = 940039;
Date: 2019-07-16 14:26:12 Duration: 19ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:26 Duration: 13ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:00 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
9 10ms 43ms 14ms 1,044 15s245ms END;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 14 1,044 15s245ms 14ms [ User: postgres - Total duration: 15s245ms - Times executed: 1044 ]
-
END;
-
END;
-
END;
Date: 2019-07-16 14:26:00 Duration: 43ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:26:00 Duration: 42ms Database: postgres User: postgres Remote: 172.31.90.158
10 11ms 11ms 11ms 1 11ms VACUUM ANALYZE pgbench_history;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 14 1 11ms 11ms [ User: postgres - Total duration: 11ms - Times executed: 1 ]
-
VACUUM ANALYZE pgbench_history;
Date: 2019-07-16 14:24:14 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
11 10ms 11ms 10ms 3 32ms INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (0, 0, 0, 0, current_timestamp);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 14 3 32ms 10ms [ User: postgres - Total duration: 32ms - Times executed: 3 ]
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (10, 9, 623984, 1808, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (70, 1, 611886, 4583, current_timestamp);
-
INSERT INTO pgbench_history (tid, bid, aid, DELTA, mtime) VALUES (53, 9, 644594, - 3338, current_timestamp);
Date: 2019-07-16 14:25:58 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:40 Duration: 11ms Database: postgres User: postgres Remote: 172.31.90.158
Date: 2019-07-16 14:25:58 Duration: 10ms Database: postgres User: postgres Remote: 172.31.90.158
-
Events
Log levels
Key values
- 163,933 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 464 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 381 Max number of times the same event was reported
- 466 Total events found
Rank Times reported Error 1 381 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 16 14 381 - LOG: process 5525 still waiting for ShareLock on transaction 17829 after 1000.122 ms
- LOG: process 5629 still waiting for ShareLock on transaction 17913 after 1000.089 ms
- LOG: process 5395 still waiting for ShareLock on transaction 17907 after 1000.104 ms
Detail: Process holding the lock: 5600. Wait queue: 5525.
Context: while updating tuple (4,16) in relation "pgbench_tellers"
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + -2690 WHERE tid = 37;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
Detail: Process holding the lock: 5409. Wait queue: 5629.
Context: while locking tuple (18,14) in relation "pgbench_tellers"
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + -869 WHERE tid = 24;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
Detail: Process holding the lock: 5373. Wait queue: 5395, 5372, 5659, 5420.
Context: while rechecking updated tuple (23,16) in relation "pgbench_tellers"
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + 3748 WHERE tid = 32;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
2 70 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 16 14 70 - LOG: process 5578 still waiting for ExclusiveLock on tuple (4,16) of relation 24642 of database 13934 after 1000.095 ms
- LOG: process 5423 still waiting for ExclusiveLock on tuple (4,16) of relation 24642 of database 13934 after 1000.108 ms
- LOG: process 5368 still waiting for ExclusiveLock on tuple (4,22) of relation 24642 of database 13934 after 1000.123 ms
Detail: Process holding the lock: 5525. Wait queue: 5578, 5423, 5444, 5364.
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + 886 WHERE tid = 37;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
Detail: Process holding the lock: 5525. Wait queue: 5578, 5423, 5444, 5364.
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + -1747 WHERE tid = 37;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
Detail: Process holding the lock: 5561. Wait queue: 5368, 5546.
Statement: UPDATE pgbench_tellers SET tbalance = tbalance + -4898 WHERE tid = 28;Date: 2019-07-16 14:24:53 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
3 8 LOG: parameter "..." changed to "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 16 14 8 - LOG: parameter "log_autovacuum_min_duration" changed to "10"
- LOG: parameter "log_connections" changed to "1"
- LOG: parameter "log_disconnections" changed to "1"
Date: 2019-07-16 14:22:15
Date: 2019-07-16 14:22:15
Date: 2019-07-16 14:22:15
4 4 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 16 14 4 - LOG: skipping analyze of "pgbench_accounts" --- lock not available
Date: 2019-07-16 14:22:22
5 2 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 16 14 2 - FATAL: terminating connection due to administrator command
Statement: drop table if exists pgbench_accounts
Date: 2019-07-16 14:24:02 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code:
6 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 16 14 1 - LOG: process 4129 still waiting for AccessExclusiveLock on relation 24625 of database 13934 after 1000.108 ms
Detail: Process holding the lock: 1197. Wait queue: 4129.
Statement: drop table if exists pgbench_accountsDate: 2019-07-16 14:22:42 Database: postgres Application: User: postgres Remote: 172.31.90.158 Code: