pgBadger-
Global information
- Generated on Fri Jun 28 13:59:12 2019
- Log file: ./With_Tuning_Insert_postgresql-Mon-01.log, ..., ./With_Tuning_Update_postgresql-Mon-02.log
- Parsed 35,472,570 log entries in 18m59s
- Log start from 2019-06-10 00:25:28 to 2019-06-10 23:51:15
-
Overview
Global Stats
- 43 Number of unique normalized queries
- 12,845,909 Number of queries
- 2d3h20m27s Total query duration
- 2019-06-10 00:25:28 First query
- 2019-06-10 23:51:15 Last query
- 2,109 queries/s at 2019-06-10 16:28:59 Query peak
- 7 Number of events
- 5 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 1 Total number of automatic vacuums
- 44 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 452 Total number of sessions
- 1 sessions at 2019-06-10 12:52:44 Session peak
- 13d22h6m7s Total duration of sessions
- 44m20s Average duration of sessions
- 28,420 Average queries per session
- 6m48s Average queries duration per session
- 452 Total number of connections
- 10 connections/s at 2019-06-10 16:24:54 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2,109 queries/s Query Peak
- 2019-06-10 16:28:59 Date
SELECT Traffic
Key values
- 445 queries/s Query Peak
- 2019-06-10 16:28:59 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,188 queries/s Query Peak
- 2019-06-10 16:28:59 Date
Queries duration
Key values
- 2d3h20m27s Total query duration
Prepared queries ratio
Key values
- 6.37 Ratio of bind vs prepare
- 118.59 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 10 00 36 0ms 0ms 0ms 0ms 0ms 0ms 01 36 0ms 0ms 0ms 0ms 0ms 0ms 02 36 0ms 0ms 0ms 0ms 0ms 0ms 03 36 0ms 0ms 0ms 0ms 0ms 0ms 04 36 0ms 0ms 0ms 0ms 0ms 0ms 05 36 0ms 0ms 0ms 0ms 0ms 0ms 06 36 0ms 0ms 0ms 0ms 0ms 0ms 07 36 0ms 0ms 0ms 0ms 0ms 0ms 08 36 0ms 0ms 0ms 0ms 0ms 0ms 09 36 0ms 0ms 0ms 0ms 0ms 0ms 10 30 0ms 0ms 0ms 0ms 0ms 0ms 11 894,927 0ms 680ms 17ms 7m39s 7m42s 7m44s 12 1,412,148 0ms 685ms 18ms 7m21s 7m22s 7m24s 13 955,109 0ms 696ms 18ms 7m15s 7m15s 7m17s 14 501,980 0ms 718ms 16ms 2m18s 2m19s 2m20s 15 220,170 0ms 1s757ms 14ms 2m16s 2m17s 2m18s 16 1,290,237 0ms 1s954ms 12ms 7m44s 7m49s 7m49s 17 2,003,111 0ms 3s68ms 13ms 7m44s 7m45s 7m48s 18 1,848,519 0ms 3s661ms 14ms 7m44s 7m46s 7m49s 19 1,763,389 0ms 4s145ms 13ms 7m38s 7m41s 7m44s 20 787,850 0ms 2s731ms 10ms 2m32s 2m32s 2m34s 21 773,382 0ms 3s838ms 10ms 2m30s 2m31s 2m33s 22 394,661 0ms 2s460ms 9ms 2m26s 2m29s 2m29s 23 36 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 10 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 223,748 0 0ms 74ms 77ms 106ms 12 353,028 0 0ms 56ms 76ms 80ms 13 238,767 0 0ms 52ms 56ms 78ms 14 125,486 0 0ms 19ms 24ms 26ms 15 55,033 0 0ms 15ms 17ms 25ms 16 273,748 0 0ms 309ms 330ms 412ms 17 428,348 0 0ms 312ms 322ms 344ms 18 397,170 0 0ms 319ms 339ms 514ms 19 378,532 0 0ms 327ms 344ms 442ms 20 160,034 0 0ms 136ms 156ms 264ms 21 157,453 0 0ms 144ms 154ms 187ms 22 83,624 0 0ms 138ms 168ms 205ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 10 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 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 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 223,707 2 1 0 0ms 474ms 589ms 636ms 12 353,028 0 0 0 0ms 426ms 474ms 619ms 13 238,767 0 0 0 0ms 412ms 426ms 605ms 14 125,486 0 0 0 0ms 171ms 212ms 278ms 15 55,033 0 0 0 0ms 23ms 166ms 214ms 16 3,981 143,847 0 0 0ms 149ms 311ms 341ms 17 0 226,207 0 0 0ms 293ms 305ms 322ms 18 0 208,881 0 0 0ms 272ms 293ms 312ms 19 0 199,652 0 0 0ms 260ms 287ms 306ms 20 0 92,018 0 0 0ms 116ms 120ms 135ms 21 0 90,469 0 0 0ms 116ms 118ms 132ms 22 0 45,156 0 0 0ms 93ms 114ms 139ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 10 00 36 36 1.00 3,600.00% 01 36 36 1.00 3,600.00% 02 36 36 1.00 3,600.00% 03 36 36 1.00 3,600.00% 04 36 36 1.00 3,600.00% 05 36 36 1.00 3,600.00% 06 36 36 1.00 3,600.00% 07 36 36 1.00 3,600.00% 08 36 36 1.00 3,600.00% 09 36 36 1.00 3,600.00% 10 28 28 1.00 2,800.00% 11 372 894,923 2,405.71 0.04% 12 342 1,412,148 4,129.09 0.02% 13 260 955,109 3,673.50 0.03% 14 274 501,980 1,832.04 0.05% 15 155 220,170 1,420.45 0.07% 16 288,252 1,290,236 4.48 28.75% 17 452,756 2,003,111 4.42 29.20% 18 418,104 1,848,519 4.42 29.22% 19 399,612 1,763,389 4.41 29.30% 20 184,296 787,850 4.27 30.52% 21 181,229 773,382 4.27 30.59% 22 90,450 394,661 4.36 29.72% 23 36 36 1.00 3,600.00% Day Hour Count Average / Second Jun 10 00 18 0.01/s 01 18 0.01/s 02 18 0.01/s 03 18 0.01/s 04 18 0.01/s 05 18 0.01/s 06 18 0.01/s 07 18 0.01/s 08 18 0.01/s 09 18 0.01/s 10 14 0.00/s 11 20 0.01/s 12 18 0.01/s 13 18 0.01/s 14 18 0.01/s 15 18 0.01/s 16 40 0.01/s 17 18 0.01/s 18 18 0.01/s 19 18 0.01/s 20 18 0.01/s 21 18 0.01/s 22 18 0.01/s 23 18 0.01/s Day Hour Count Average Duration Jun 10 00 18 29m36s 01 18 29m34s 02 18 29m34s 03 18 29m41s 04 18 29m34s 05 18 29m33s 06 18 29m32s 07 18 29m33s 08 18 29m33s 09 18 29m35s 10 24 2h30m37s 11 10 6h47m24s 12 18 29m44s 13 18 29m38s 14 18 29m39s 15 18 29m35s 16 40 29m4s 17 18 29m37s 18 18 29m37s 19 18 29m40s 20 18 29m40s 21 18 29m36s 22 18 29m37s 23 18 29m36s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2019-06-10 16:24:54 Date
Connections per database
Key values
- galaxy Main Database
- 452 connections Total
Connections per user
Key values
- browndwarf Main User
- 452 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-06-10 12:52:44 Date
Histogram of session times
Key values
- 423 600000-1800000ms duration
Sessions per database
Key values
- galaxy Main Database
- 452 sessions Total
Sessions per user
Key values
- browndwarf Main User
- 452 sessions Total
Sessions per host
Key values
- 16.8.35.227 Main Host
- 452 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 12,724 buffers Checkpoint Peak
- 2019-06-10 20:01:37 Date
- 163.438 seconds Highest write time
- 3.365 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2019-06-10 16:36:35 Date
Checkpoints distance
Key values
- 173.73 Mo Distance Peak
- 2019-06-10 16:31:29 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 10 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 1 0.1s 0.037s 0.205s 11 3,689 369.121s 3.133s 375.373s 12 7,880 788.833s 3.179s 796.735s 13 6,362 636.426s 2.641s 643.282s 14 2,899 289.63s 2.946s 296.997s 15 1,998 200.519s 1.048s 204.014s 16 60,431 913.037s 6.201s 940.469s 17 109,370 1,798.001s 11.248s 1,841.544s 18 105,819 1,834.596s 9.439s 1,878.332s 19 107,068 1,803.321s 10.784s 1,855.555s 20 48,054 1,792.145s 16.28s 1,823.751s 21 38,669 1,795.554s 17.494s 1,830.654s 22 22,210 1,124.824s 10.061s 1,142.084s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 10 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 1 1 0.037s 0.037s 11 0 1 1 85 0.354s 0.298s 12 0 0 5 66 0.468s 0.576s 13 0 0 4 56 0.563s 0.576s 14 0 0 2 50 0.451s 0.724s 15 0 0 1 50 0.250s 0.246s 16 0 0 27 42 0.788s 1.856s 17 0 0 55 40 1.763s 3.486s 18 0 0 53 38 1.263s 3.078s 19 0 0 53 40 1.997s 3.273s 20 0 5 19 36 2.510s 5.541s 21 0 2 18 34 3.361s 6.726s 22 0 0 12 23 2.143s 3.402s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jun 10 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 10 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 8.00 kB 24,970.00 kB 11 6,132.62 kB 9,153.38 kB 12 6,976.33 kB 7,620.83 kB 13 4,945.17 kB 6,893.92 kB 14 2,482.08 kB 4,053.08 kB 15 1,211.83 kB 2,492.08 kB 16 45,751.00 kB 51,992.10 kB 17 75,461.83 kB 83,023.83 kB 18 71,856.17 kB 78,635.25 kB 19 72,878.08 kB 80,117.58 kB 20 28,176.50 kB 54,570.17 kB 21 27,759.50 kB 35,415.00 kB 22 24,014.38 kB 29,778.38 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.02 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database galaxy - 2019-06-10 11:45:26 Date
- 21.47 sec Highest CPU-cost analyze
Table public.star
Database galaxy - 2019-06-10 19:58:39 Date
Analyzes per table
Key values
- public.star (43) Main table analyzed (database galaxy)
- 44 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database galaxy
- 1 vacuums Total
Tuples removed per table
Key values
- pg_catalog.pg_statistic (94) Main table with removed tuples on database galaxy
- 94 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 10 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 1 19 12 0 9 13 0 4 14 0 1 15 0 1 16 0 1 17 0 3 18 0 2 19 0 2 20 0 0 21 0 1 22 0 1 23 0 0 - 0.02 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
- 2,874,971 Total read queries
- 7,957,581 Total write queries
Queries by database
Key values
- galaxy Main database
- 12,845,909 Requests
- 2d3h20m27s (galaxy)
- Main time consuming database
Queries by user
Key values
- browndwarf Main user
- 12,845,909 Requests
User Request type Count Duration browndwarf Total 12,845,909 2d3h20m27s DDL 6 594ms DELETE 1 0ms INSERT 1,000,002 1m19s OTHERS 2,013,357 17s249ms SELECT 2,874,971 1m14s TCL 5,951,340 2d3h16m36s UPDATE 1,006,232 59s386ms Duration by user
Key values
- 2d3h20m27s (browndwarf) Main time consuming user
User Request type Count Duration browndwarf Total 12,845,909 2d3h20m27s DDL 6 594ms DELETE 1 0ms INSERT 1,000,002 1m19s OTHERS 2,013,357 17s249ms SELECT 2,874,971 1m14s TCL 5,951,340 2d3h16m36s UPDATE 1,006,232 59s386ms Queries by host
Key values
- 16.8.35.227 Main host
- 12,845,902 Requests
- 2d3h20m26s (16.8.35.227)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 12,845,452 Requests
- 2d3h20m26s (PostgreSQL JDBC Driver)
- Main time consuming application
Application Request type Count Duration PostgreSQL JDBC Driver Total 12,845,452 2d3h20m26s DDL 3 246ms DELETE 1 0ms INSERT 1,000,002 1m19s OTHERS 2,012,905 17s243ms SELECT 2,874,969 1m14s TCL 5,951,340 2d3h16m36s UPDATE 1,006,232 59s386ms [unknown] Total 450 6ms OTHERS 450 6ms psql Total 7 358ms DDL 3 348ms OTHERS 2 0ms SELECT 2 9ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-06-10 15:04:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 10,838,416 0-1ms duration
Slowest individual queries
Rank Duration Query 1 4s145ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 4s144ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 4s144ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 4s144ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 4s144ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 4s144ms COMMIT;[ Date: 2019-06-10 19:19:42 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 4s78ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 4s78ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 4s77ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 4s77ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 4s77ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 4s77ms COMMIT;[ Date: 2019-06-10 19:19:31 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 4s66ms COMMIT;[ Date: 2019-06-10 19:19:29 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 3s961ms COMMIT;[ Date: 2019-06-10 19:19:29 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 3s935ms COMMIT;[ Date: 2019-06-10 19:19:36 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 3s841ms COMMIT;[ Date: 2019-06-10 19:19:36 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 3s838ms COMMIT;[ Date: 2019-06-10 21:56:38 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 3s814ms COMMIT;[ Date: 2019-06-10 19:19:38 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 3s814ms COMMIT;[ Date: 2019-06-10 19:19:38 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 3s814ms COMMIT;[ Date: 2019-06-10 19:19:38 - Database: galaxy - User: browndwarf - Remote: 16.8.35.227 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2d3h16m25s 2,975,665 0ms 4s145ms 62ms COMMIT;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 11 223,705 4h17m29s 69ms 12 353,028 7h14m47s 73ms 13 238,772 4h47m53s 72ms 14 125,486 2h14m52s 64ms 15 55,035 53m32s 58ms 16 290,442 4h30m27s 55ms 17 448,053 7h21m13s 59ms 18 412,335 7h22m51s 64ms 19 392,935 6h44m43s 61ms 20 175,863 2h22m18s 48ms 21 172,243 2h20m45s 49ms 22 87,768 1h5m30s 44ms [ User: browndwarf - Total duration: 2d3h16m25s - Times executed: 2975665 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2d3h16m25s - Times executed: 2975665 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-06-10 19:19:42 Duration: 4s145ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m19s 1,000,000 0ms 74ms 0ms INSERT INTO star (createdtime, description, mass, name, pictureurl, radius, class, temperature, updatedtime) VALUES (?, ?, ?, ?, NULL, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 11 223,705 17s351ms 0ms 12 353,028 27s316ms 0ms 13 238,767 18s820ms 0ms 14 125,486 10s809ms 0ms 15 55,033 4s733ms 0ms 16 3,981 317ms 0ms [ User: browndwarf - Total duration: 1m19s - Times executed: 1000000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m19s - Times executed: 1000000 ]
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.028', 'Mass Test', '53', 'Antares-92c', NULL, '84', 'C', '7000', '2019-06-10 12:18:11.028');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '73', 'Barnerd-22x', NULL, '30', 'C', '6000', '2019-06-10 12:18:11.064');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '64', 'Gacrux-33s', NULL, '32', 'C', '5000', '2019-06-10 12:18:11.064');
Date: 2019-06-10 12:18:11 Duration: 74ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
3 1m5s 1,874,873 0ms 164ms 0ms SELECT star0_.id AS id1_0_0_, star0_.createdtime AS createdt2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureurl AS pictureu6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedtime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 10 16 269,712 8s389ms 0ms 17 428,348 13s165ms 0ms 18 397,170 12s594ms 0ms 19 378,532 12s413ms 0ms 20 160,034 7s266ms 0ms 21 157,453 7s333ms 0ms 22 83,624 3s912ms 0ms [ User: browndwarf - Total duration: 1m5s - Times executed: 1874873 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m5s - Times executed: 1874873 ]
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '339921';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '165702';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '245413';
Date: 2019-06-10 20:01:34 Duration: 164ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:22:17 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:25:22 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
4 59s386ms 1,006,225 0ms 686ms 0ms UPDATE star SET description = ?, mass = ?, name = ?, pictureurl = NULL, radius = ?, class = ?, temperature = ?, updatedtime = ? WHERE id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 10 16 143,843 7s911ms 0ms 17 226,207 13s230ms 0ms 18 208,880 12s18ms 0ms 19 199,652 10s694ms 0ms 20 92,018 6s585ms 0ms 21 90,469 6s21ms 0ms 22 45,156 2s924ms 0ms [ User: browndwarf - Total duration: 59s386ms - Times executed: 1006225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 59s386ms - Times executed: 1006225 ]
-
UPDATE star SET description = 'Mass Test', mass = '399', name = 'Gacrux-70aSOE', pictureURL = NULL, radius = '72', class = 'C', temperature = '1000', updatedTime = '2019-06-10 18:19:07.48' WHERE id = '27626';
-
UPDATE star SET description = 'Mass Test', mass = '132', name = 'HD-68zQ', pictureURL = NULL, radius = '42', class = 'C', temperature = '2000', updatedTime = '2019-06-10 17:25:33.277' WHERE id = '648662';
-
UPDATE star SET description = 'Mass Test', mass = '138', name = 'Gacrux-1bJ', pictureURL = NULL, radius = '70', class = 'C', temperature = '1000', updatedTime = '2019-06-10 20:10:26.825' WHERE id = '678204';
Date: 2019-06-10 18:19:08 Duration: 686ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:25:33 Duration: 581ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 20:10:27 Duration: 289ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
5 10s412ms 1,006,226 0ms 0ms 0ms SET session characteristics AS TRANSACTION read ONLY;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 16 143,843 1s306ms 0ms 17 226,207 2s118ms 0ms 18 208,881 1s897ms 0ms 19 199,652 1s870ms 0ms 20 92,018 1s287ms 0ms 21 90,469 1s271ms 0ms 22 45,156 659ms 0ms [ User: browndwarf - Total duration: 10s412ms - Times executed: 1006226 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s412ms - Times executed: 1006226 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
Date: 2019-06-10 19:41:32 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 18:23:39 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:35:39 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
6 10s312ms 2,975,670 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 11 223,716 882ms 0ms 12 353,028 1s464ms 0ms 13 238,767 1s13ms 0ms 14 125,486 582ms 0ms 15 55,033 270ms 0ms 16 290,451 921ms 0ms 17 448,053 1s447ms 0ms 18 412,335 1s299ms 0ms 19 392,930 1s239ms 0ms 20 175,863 484ms 0ms 21 172,243 476ms 0ms 22 87,765 232ms 0ms [ User: browndwarf - Total duration: 10s312ms - Times executed: 2975670 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s312ms - Times executed: 2975670 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-06-10 13:11:05 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:10:54 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 13:07:00 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
7 9s45ms 1,000,000 0ms 0ms 0ms SELECT currval(?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 11 223,705 2s34ms 0ms 12 353,028 3s350ms 0ms 13 238,767 2s170ms 0ms 14 125,486 1s 0ms 15 55,033 452ms 0ms 16 3,981 36ms 0ms [ User: browndwarf - Total duration: 9s45ms - Times executed: 1000000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s45ms - Times executed: 1000000 ]
-
SELECT currval('star_id_seq');
-
SELECT currval('star_id_seq');
-
SELECT currval('star_id_seq');
Date: 2019-06-10 12:00:14 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:39:30 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:08:07 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
8 6s823ms 1,006,226 0ms 0ms 0ms SET session characteristics AS TRANSACTION read write;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 16 143,843 973ms 0ms 17 226,207 1s557ms 0ms 18 208,881 1s410ms 0ms 19 199,652 1s362ms 0ms 20 92,018 608ms 0ms 21 90,469 607ms 0ms 22 45,156 304ms 0ms [ User: browndwarf - Total duration: 6s823ms - Times executed: 1006226 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s823ms - Times executed: 1006226 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
Date: 2019-06-10 20:30:53 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:39:14 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:38:07 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
9 130ms 1 130ms 130ms 130ms CREATE TABLE public.databasechangeloglock ( id integer NOT NULL, LOCKED boolean NOT NULL, lockgranted timestamp without time zone, lockedby varchar(?), CONSTRAINT databasechangeloglock_pkey PRIMARY KEY (id) );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 11 1 130ms 130ms [ User: browndwarf - Total duration: 130ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 130ms - Times executed: 1 ]
-
CREATE TABLE public.databasechangeloglock ( ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED timestamp WITHOUT time ZONE, LOCKEDBY varchar(255), CONSTRAINT DATABASECHANGELOGLOCK_PKEY PRIMARY KEY (ID) );
Date: 2019-06-10 11:23:42 Duration: 130ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
10 123ms 1 123ms 123ms 123ms DROP TABLE databasechangelog;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 11 1 123ms 123ms [ User: browndwarf - Total duration: 123ms - Times executed: 1 ]
[ Application: psql - Total duration: 123ms - Times executed: 1 ]
-
DROP TABLE databasechangelog;
Date: 2019-06-10 11:23:07 Duration: 123ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
11 117ms 1 117ms 117ms 117ms DROP TABLE star;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 11 1 117ms 117ms [ User: browndwarf - Total duration: 117ms - Times executed: 1 ]
[ Application: psql - Total duration: 117ms - Times executed: 1 ]
-
DROP TABLE star;
Date: 2019-06-10 11:23:17 Duration: 117ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
12 107ms 1 107ms 107ms 107ms DROP TABLE databasechangeloglock;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 11 1 107ms 107ms [ User: browndwarf - Total duration: 107ms - Times executed: 1 ]
[ Application: psql - Total duration: 107ms - Times executed: 1 ]
-
DROP TABLE databasechangeloglock;
Date: 2019-06-10 11:23:11 Duration: 107ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
13 72ms 1 72ms 72ms 72ms CREATE TABLE public.star ( id bigserial NOT NULL, name varchar(?) NOT NULL, temperature integer, mass integer, radius integer, class varchar(?), pictureurl varchar(?), description varchar(?), createdtime timestamp(?) without time zone, updatedtime timestamp(?) without time zone, CONSTRAINT star_pkey PRIMARY KEY (id) );Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 11 1 72ms 72ms [ User: browndwarf - Total duration: 72ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 72ms - Times executed: 1 ]
-
CREATE TABLE public.star ( id BIGSERIAL NOT NULL, name varchar(50) NOT NULL, temperature INTEGER, mass INTEGER, radius INTEGER, class varchar(50), pictureurl varchar(255), description varchar(255), createdtime timestamp(6) WITHOUT time ZONE, updatedtime timestamp(6) WITHOUT time ZONE, CONSTRAINT STAR_PKEY PRIMARY KEY (id) );
Date: 2019-06-10 11:23:43 Duration: 72ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
14 52ms 34 0ms 3ms 1ms SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 10 11 17 28ms 1ms 16 17 23ms 1ms [ User: browndwarf - Total duration: 52ms - Times executed: 34 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 34 ]
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13053';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13052';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '1034';
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
15 50ms 24 0ms 3ms 2ms SELECT typinput = ?::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(?, array_upper(current_schemas(FALSE), ?)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = ? ORDER BY sp.r, pg_type.oid DESC LIMIT ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 11 12 27ms 2ms 16 12 23ms 1ms [ User: browndwarf - Total duration: 50ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50ms - Times executed: 24 ]
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'pg_node_tree' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'regproc' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'oidvector' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
16 43ms 1 43ms 43ms 43ms CREATE TABLE public.databasechangelog ( id varchar(?) NOT NULL, author varchar(?) NOT NULL, filename varchar(?) NOT NULL, dateexecuted timestamp without time zone NOT NULL, orderexecuted integer NOT NULL, exectype varchar(?) NOT NULL, md5sum varchar(?), description varchar(?), comments varchar(?), tag varchar(?), liquibase varchar(?), contexts varchar(?), labels varchar(?), deployment_id varchar(?) );Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 11 1 43ms 43ms [ User: browndwarf - Total duration: 43ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43ms - Times executed: 1 ]
-
CREATE TABLE public.databasechangelog ( ID varchar(255) NOT NULL, AUTHOR varchar(255) NOT NULL, FILENAME varchar(255) NOT NULL, DATEEXECUTED timestamp WITHOUT time ZONE NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE varchar(10) NOT NULL, MD5SUM varchar(35), DESCRIPTION varchar(255), COMMENTS varchar(255), TAG varchar(255), LIQUIBASE varchar(20), CONTEXTS varchar(255), LABELS varchar(255), DEPLOYMENT_ID varchar(10) );
Date: 2019-06-10 11:23:43 Duration: 43ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
17 26ms 2 12ms 14ms 13ms SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = ? AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = ?) LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = ?) WHERE c.relkind IN (...) AND a.attnum > ? AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE ? ORDER BY nspname, c.relname, attnum;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 11 1 12ms 12ms 16 1 14ms 14ms [ User: browndwarf - Total duration: 26ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26ms - Times executed: 2 ]
-
SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind IN ('r', 'p', 'v', 'f', 'm') AND a.attnum > 0 AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
-
SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind IN ('r', 'p', 'v', 'f', 'm') AND a.attnum > 0 AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
Date: 2019-06-10 16:24:57 Duration: 14ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 12ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
18 16ms 6 2ms 2ms 2ms SELECT count(*) FROM public.databasechangeloglock;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 11 2 5ms 2ms 16 4 11ms 2ms [ User: browndwarf - Total duration: 16ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 6 ]
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
19 16ms 3 4ms 6ms 5ms SELECT string_agg(word, ?) FROM pg_catalog.pg_get_keywords() WHERE word <> ALL (?::text [ ]);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 11 1 5ms 5ms 16 2 11ms 5ms [ User: browndwarf - Total duration: 16ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 3 ]
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
Date: 2019-06-10 16:23:20 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 5ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:54 Duration: 4ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
20 10ms 3 3ms 3ms 3ms SELECT NULL AS table_cat, n.nspname AS table_schem, c.relname AS table_name, CASE n.nspname ~ ? OR n.nspname = ? WHEN TRUE THEN CASE WHEN n.nspname = ? OR n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END WHEN n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE NULL END AS table_type, d.description AS remarks FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = ?) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = ?) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = ?) WHERE c.relnamespace = n.oid AND n.nspname LIKE ? AND c.relname LIKE ? AND (FALSE OR (c.relkind IN (...) AND n.nspname !~ ? AND n.nspname <> ?)) ORDER BY table_type, table_schem, table_name;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 11 1 3ms 3ms 16 2 7ms 3ms [ User: browndwarf - Total duration: 10ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 3 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2019-06-10 16:24:56 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:43 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,975,670 10s312ms 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 11 223,716 882ms 0ms 12 353,028 1s464ms 0ms 13 238,767 1s13ms 0ms 14 125,486 582ms 0ms 15 55,033 270ms 0ms 16 290,451 921ms 0ms 17 448,053 1s447ms 0ms 18 412,335 1s299ms 0ms 19 392,930 1s239ms 0ms 20 175,863 484ms 0ms 21 172,243 476ms 0ms 22 87,765 232ms 0ms [ User: browndwarf - Total duration: 10s312ms - Times executed: 2975670 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s312ms - Times executed: 2975670 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-06-10 13:11:05 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:10:54 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 13:07:00 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
2 2,975,665 2d3h16m25s 0ms 4s145ms 62ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 11 223,705 4h17m29s 69ms 12 353,028 7h14m47s 73ms 13 238,772 4h47m53s 72ms 14 125,486 2h14m52s 64ms 15 55,035 53m32s 58ms 16 290,442 4h30m27s 55ms 17 448,053 7h21m13s 59ms 18 412,335 7h22m51s 64ms 19 392,935 6h44m43s 61ms 20 175,863 2h22m18s 48ms 21 172,243 2h20m45s 49ms 22 87,768 1h5m30s 44ms [ User: browndwarf - Total duration: 2d3h16m25s - Times executed: 2975665 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2d3h16m25s - Times executed: 2975665 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-06-10 19:19:42 Duration: 4s145ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
3 1,874,873 1m5s 0ms 164ms 0ms SELECT star0_.id AS id1_0_0_, star0_.createdtime AS createdt2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureurl AS pictureu6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedtime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 10 16 269,712 8s389ms 0ms 17 428,348 13s165ms 0ms 18 397,170 12s594ms 0ms 19 378,532 12s413ms 0ms 20 160,034 7s266ms 0ms 21 157,453 7s333ms 0ms 22 83,624 3s912ms 0ms [ User: browndwarf - Total duration: 1m5s - Times executed: 1874873 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m5s - Times executed: 1874873 ]
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '339921';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '165702';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '245413';
Date: 2019-06-10 20:01:34 Duration: 164ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:22:17 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:25:22 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
4 1,006,226 6s823ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION read write;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 10 16 143,843 973ms 0ms 17 226,207 1s557ms 0ms 18 208,881 1s410ms 0ms 19 199,652 1s362ms 0ms 20 92,018 608ms 0ms 21 90,469 607ms 0ms 22 45,156 304ms 0ms [ User: browndwarf - Total duration: 6s823ms - Times executed: 1006226 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s823ms - Times executed: 1006226 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;
Date: 2019-06-10 20:30:53 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:39:14 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:38:07 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
5 1,006,226 10s412ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION read ONLY;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 16 143,843 1s306ms 0ms 17 226,207 2s118ms 0ms 18 208,881 1s897ms 0ms 19 199,652 1s870ms 0ms 20 92,018 1s287ms 0ms 21 90,469 1s271ms 0ms 22 45,156 659ms 0ms [ User: browndwarf - Total duration: 10s412ms - Times executed: 1006226 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s412ms - Times executed: 1006226 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
-
SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
Date: 2019-06-10 19:41:32 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 18:23:39 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:35:39 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
6 1,006,225 59s386ms 0ms 686ms 0ms UPDATE star SET description = ?, mass = ?, name = ?, pictureurl = NULL, radius = ?, class = ?, temperature = ?, updatedtime = ? WHERE id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 16 143,843 7s911ms 0ms 17 226,207 13s230ms 0ms 18 208,880 12s18ms 0ms 19 199,652 10s694ms 0ms 20 92,018 6s585ms 0ms 21 90,469 6s21ms 0ms 22 45,156 2s924ms 0ms [ User: browndwarf - Total duration: 59s386ms - Times executed: 1006225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 59s386ms - Times executed: 1006225 ]
-
UPDATE star SET description = 'Mass Test', mass = '399', name = 'Gacrux-70aSOE', pictureURL = NULL, radius = '72', class = 'C', temperature = '1000', updatedTime = '2019-06-10 18:19:07.48' WHERE id = '27626';
-
UPDATE star SET description = 'Mass Test', mass = '132', name = 'HD-68zQ', pictureURL = NULL, radius = '42', class = 'C', temperature = '2000', updatedTime = '2019-06-10 17:25:33.277' WHERE id = '648662';
-
UPDATE star SET description = 'Mass Test', mass = '138', name = 'Gacrux-1bJ', pictureURL = NULL, radius = '70', class = 'C', temperature = '1000', updatedTime = '2019-06-10 20:10:26.825' WHERE id = '678204';
Date: 2019-06-10 18:19:08 Duration: 686ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:25:33 Duration: 581ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 20:10:27 Duration: 289ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
7 1,000,000 9s45ms 0ms 0ms 0ms SELECT currval(?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 11 223,705 2s34ms 0ms 12 353,028 3s350ms 0ms 13 238,767 2s170ms 0ms 14 125,486 1s 0ms 15 55,033 452ms 0ms 16 3,981 36ms 0ms [ User: browndwarf - Total duration: 9s45ms - Times executed: 1000000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s45ms - Times executed: 1000000 ]
-
SELECT currval('star_id_seq');
-
SELECT currval('star_id_seq');
-
SELECT currval('star_id_seq');
Date: 2019-06-10 12:00:14 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:39:30 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:08:07 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
8 1,000,000 1m19s 0ms 74ms 0ms INSERT INTO star (createdtime, description, mass, name, pictureurl, radius, class, temperature, updatedtime) VALUES (?, ?, ?, ?, NULL, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 11 223,705 17s351ms 0ms 12 353,028 27s316ms 0ms 13 238,767 18s820ms 0ms 14 125,486 10s809ms 0ms 15 55,033 4s733ms 0ms 16 3,981 317ms 0ms [ User: browndwarf - Total duration: 1m19s - Times executed: 1000000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m19s - Times executed: 1000000 ]
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.028', 'Mass Test', '53', 'Antares-92c', NULL, '84', 'C', '7000', '2019-06-10 12:18:11.028');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '73', 'Barnerd-22x', NULL, '30', 'C', '6000', '2019-06-10 12:18:11.064');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '64', 'Gacrux-33s', NULL, '32', 'C', '5000', '2019-06-10 12:18:11.064');
Date: 2019-06-10 12:18:11 Duration: 74ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
9 450 6ms 0ms 0ms 0ms SET extra_float_digits = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 00 18 0ms 0ms 01 18 0ms 0ms 02 18 0ms 0ms 03 18 0ms 0ms 04 18 0ms 0ms 05 18 0ms 0ms 06 18 0ms 0ms 07 18 0ms 0ms 08 18 0ms 0ms 09 18 0ms 0ms 10 14 0ms 0ms 11 19 0ms 0ms 12 18 0ms 0ms 13 18 0ms 0ms 14 18 0ms 0ms 15 18 0ms 0ms 16 39 0ms 0ms 17 18 0ms 0ms 18 18 0ms 0ms 19 18 0ms 0ms 20 18 0ms 0ms 21 18 0ms 0ms 22 18 0ms 0ms 23 18 0ms 0ms [ User: browndwarf - Total duration: 6ms - Times executed: 450 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 450 ]
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
Date: 2019-06-10 20:51:52 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: [unknown] Bind query: yes
Date: 2019-06-10 18:24:19 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: [unknown] Bind query: yes
Date: 2019-06-10 13:52:21 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: [unknown] Bind query: yes
10 450 6ms 0ms 0ms 0ms SET application_name = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 00 18 0ms 0ms 01 18 0ms 0ms 02 18 0ms 0ms 03 18 0ms 0ms 04 18 0ms 0ms 05 18 0ms 0ms 06 18 0ms 0ms 07 18 0ms 0ms 08 18 0ms 0ms 09 18 0ms 0ms 10 14 0ms 0ms 11 19 0ms 0ms 12 18 0ms 0ms 13 18 0ms 0ms 14 18 0ms 0ms 15 18 0ms 0ms 16 39 0ms 0ms 17 18 0ms 0ms 18 18 0ms 0ms 19 18 0ms 0ms 20 18 0ms 0ms 21 18 0ms 0ms 22 18 0ms 0ms 23 18 0ms 0ms [ User: browndwarf - Total duration: 6ms - Times executed: 450 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6ms - Times executed: 450 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-06-10 17:53:56 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 04:24:48 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 10:20:03 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
11 34 52ms 0ms 3ms 1ms SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 11 17 28ms 1ms 16 17 23ms 1ms [ User: browndwarf - Total duration: 52ms - Times executed: 34 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 34 ]
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13053';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13052';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '1034';
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
12 24 50ms 0ms 3ms 2ms SELECT typinput = ?::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(?, array_upper(current_schemas(FALSE), ?)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = ? ORDER BY sp.r, pg_type.oid DESC LIMIT ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 11 12 27ms 2ms 16 12 23ms 1ms [ User: browndwarf - Total duration: 50ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50ms - Times executed: 24 ]
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'pg_node_tree' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'regproc' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'oidvector' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
13 6 16ms 2ms 2ms 2ms SELECT count(*) FROM public.databasechangeloglock;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 11 2 5ms 2ms 16 4 11ms 2ms [ User: browndwarf - Total duration: 16ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 6 ]
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
14 5 0ms 0ms 0ms 0ms ROLLBACK;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 10 11 3 0ms 0ms 16 2 0ms 0ms [ User: browndwarf - Total duration: 0ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 5 ]
-
ROLLBACK;
-
ROLLBACK;
-
ROLLBACK;
Date: 2019-06-10 11:23:43 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
15 3 9ms 2ms 3ms 3ms SELECT setting FROM pg_settings WHERE name = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 6ms 3ms [ User: browndwarf - Total duration: 9ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 3 ]
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
Date: 2019-06-10 16:23:21 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:54 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
16 3 10ms 3ms 3ms 3ms SELECT NULL AS table_cat, n.nspname AS table_schem, c.relname AS table_name, CASE n.nspname ~ ? OR n.nspname = ? WHEN TRUE THEN CASE WHEN n.nspname = ? OR n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END WHEN n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE NULL END AS table_type, d.description AS remarks FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = ?) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = ?) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = ?) WHERE c.relnamespace = n.oid AND n.nspname LIKE ? AND c.relname LIKE ? AND (FALSE OR (c.relkind IN (...) AND n.nspname !~ ? AND n.nspname <> ?)) ORDER BY table_type, table_schem, table_name;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 11 1 3ms 3ms 16 2 7ms 3ms [ User: browndwarf - Total duration: 10ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 3 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2019-06-10 16:24:56 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:43 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
17 3 16ms 4ms 6ms 5ms SELECT string_agg(word, ?) FROM pg_catalog.pg_get_keywords() WHERE word <> ALL (?::text [ ]);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 11 1 5ms 5ms 16 2 11ms 5ms [ User: browndwarf - Total duration: 16ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 3 ]
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
Date: 2019-06-10 16:23:20 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 5ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:54 Duration: 4ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
18 3 8ms 2ms 2ms 2ms SELECT current_schema();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 5ms 2ms [ User: browndwarf - Total duration: 8ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8ms - Times executed: 3 ]
-
SELECT current_schema();
-
SELECT current_schema();
-
SELECT current_schema();
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
19 3 7ms 2ms 2ms 2ms SELECT * FROM public.databasechangelog ORDER BY dateexecuted ASC, orderexecuted ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 5ms 2ms [ User: browndwarf - Total duration: 7ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 3 ]
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
Date: 2019-06-10 16:24:56 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:43 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
20 3 0ms 0ms 0ms 0ms UPDATE public.databasechangeloglock SET LOCKED = FALSE, lockedby = NULL, lockgranted = NULL WHERE id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 11 1 0ms 0ms 16 2 0ms 0ms [ User: browndwarf - Total duration: 0ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 3 ]
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
Date: 2019-06-10 11:23:43 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:56 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 130ms 130ms 130ms 1 130ms CREATE TABLE public.databasechangeloglock ( id integer NOT NULL, LOCKED boolean NOT NULL, lockgranted timestamp without time zone, lockedby varchar(?), CONSTRAINT databasechangeloglock_pkey PRIMARY KEY (id) );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 11 1 130ms 130ms [ User: browndwarf - Total duration: 130ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 130ms - Times executed: 1 ]
-
CREATE TABLE public.databasechangeloglock ( ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED timestamp WITHOUT time ZONE, LOCKEDBY varchar(255), CONSTRAINT DATABASECHANGELOGLOCK_PKEY PRIMARY KEY (ID) );
Date: 2019-06-10 11:23:42 Duration: 130ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
2 123ms 123ms 123ms 1 123ms DROP TABLE databasechangelog;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 11 1 123ms 123ms [ User: browndwarf - Total duration: 123ms - Times executed: 1 ]
[ Application: psql - Total duration: 123ms - Times executed: 1 ]
-
DROP TABLE databasechangelog;
Date: 2019-06-10 11:23:07 Duration: 123ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
3 117ms 117ms 117ms 1 117ms DROP TABLE star;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 10 11 1 117ms 117ms [ User: browndwarf - Total duration: 117ms - Times executed: 1 ]
[ Application: psql - Total duration: 117ms - Times executed: 1 ]
-
DROP TABLE star;
Date: 2019-06-10 11:23:17 Duration: 117ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
4 107ms 107ms 107ms 1 107ms DROP TABLE databasechangeloglock;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 10 11 1 107ms 107ms [ User: browndwarf - Total duration: 107ms - Times executed: 1 ]
[ Application: psql - Total duration: 107ms - Times executed: 1 ]
-
DROP TABLE databasechangeloglock;
Date: 2019-06-10 11:23:11 Duration: 107ms Database: galaxy User: browndwarf Remote: ::1 Application: psql
5 72ms 72ms 72ms 1 72ms CREATE TABLE public.star ( id bigserial NOT NULL, name varchar(?) NOT NULL, temperature integer, mass integer, radius integer, class varchar(?), pictureurl varchar(?), description varchar(?), createdtime timestamp(?) without time zone, updatedtime timestamp(?) without time zone, CONSTRAINT star_pkey PRIMARY KEY (id) );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 11 1 72ms 72ms [ User: browndwarf - Total duration: 72ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 72ms - Times executed: 1 ]
-
CREATE TABLE public.star ( id BIGSERIAL NOT NULL, name varchar(50) NOT NULL, temperature INTEGER, mass INTEGER, radius INTEGER, class varchar(50), pictureurl varchar(255), description varchar(255), createdtime timestamp(6) WITHOUT time ZONE, updatedtime timestamp(6) WITHOUT time ZONE, CONSTRAINT STAR_PKEY PRIMARY KEY (id) );
Date: 2019-06-10 11:23:43 Duration: 72ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 4s145ms 62ms 2,975,665 2d3h16m25s COMMIT;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 11 223,705 4h17m29s 69ms 12 353,028 7h14m47s 73ms 13 238,772 4h47m53s 72ms 14 125,486 2h14m52s 64ms 15 55,035 53m32s 58ms 16 290,442 4h30m27s 55ms 17 448,053 7h21m13s 59ms 18 412,335 7h22m51s 64ms 19 392,935 6h44m43s 61ms 20 175,863 2h22m18s 48ms 21 172,243 2h20m45s 49ms 22 87,768 1h5m30s 44ms [ User: browndwarf - Total duration: 2d3h16m25s - Times executed: 2975665 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2d3h16m25s - Times executed: 2975665 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-06-10 19:19:42 Duration: 4s145ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 19:19:42 Duration: 4s144ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
7 43ms 43ms 43ms 1 43ms CREATE TABLE public.databasechangelog ( id varchar(?) NOT NULL, author varchar(?) NOT NULL, filename varchar(?) NOT NULL, dateexecuted timestamp without time zone NOT NULL, orderexecuted integer NOT NULL, exectype varchar(?) NOT NULL, md5sum varchar(?), description varchar(?), comments varchar(?), tag varchar(?), liquibase varchar(?), contexts varchar(?), labels varchar(?), deployment_id varchar(?) );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 11 1 43ms 43ms [ User: browndwarf - Total duration: 43ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43ms - Times executed: 1 ]
-
CREATE TABLE public.databasechangelog ( ID varchar(255) NOT NULL, AUTHOR varchar(255) NOT NULL, FILENAME varchar(255) NOT NULL, DATEEXECUTED timestamp WITHOUT time ZONE NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE varchar(10) NOT NULL, MD5SUM varchar(35), DESCRIPTION varchar(255), COMMENTS varchar(255), TAG varchar(255), LIQUIBASE varchar(20), CONTEXTS varchar(255), LABELS varchar(255), DEPLOYMENT_ID varchar(10) );
Date: 2019-06-10 11:23:43 Duration: 43ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
8 12ms 14ms 13ms 2 26ms SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = ? AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = ?) LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = ?) WHERE c.relkind IN (...) AND a.attnum > ? AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE ? ORDER BY nspname, c.relname, attnum;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 11 1 12ms 12ms 16 1 14ms 14ms [ User: browndwarf - Total duration: 26ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26ms - Times executed: 2 ]
-
SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind IN ('r', 'p', 'v', 'f', 'm') AND a.attnum > 0 AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
-
SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, NULL AS attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind IN ('r', 'p', 'v', 'f', 'm') AND a.attnum > 0 AND NOT a.attisdropped) c WHERE TRUE AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
Date: 2019-06-10 16:24:57 Duration: 14ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 12ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
9 4ms 6ms 5ms 3 16ms SELECT string_agg(word, ?) FROM pg_catalog.pg_get_keywords() WHERE word <> ALL (?::text [ ]);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 11 1 5ms 5ms 16 2 11ms 5ms [ User: browndwarf - Total duration: 16ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 3 ]
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
-
SELECT string_agg(word, ',') FROM pg_catalog.pg_get_keywords() WHERE word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text [ ]);
Date: 2019-06-10 16:23:20 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 5ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:54 Duration: 4ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
10 3ms 3ms 3ms 3 10ms SELECT NULL AS table_cat, n.nspname AS table_schem, c.relname AS table_name, CASE n.nspname ~ ? OR n.nspname = ? WHEN TRUE THEN CASE WHEN n.nspname = ? OR n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END WHEN n.nspname = ? THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? ELSE NULL END ELSE NULL END AS table_type, d.description AS remarks FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = ?) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = ?) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = ?) WHERE c.relnamespace = n.oid AND n.nspname LIKE ? AND c.relname LIKE ? AND (FALSE OR (c.relkind IN (...) AND n.nspname !~ ? AND n.nspname <> ?)) ORDER BY table_type, table_schem, table_name;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 11 1 3ms 3ms 16 2 7ms 3ms [ User: browndwarf - Total duration: 10ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 3 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN TRUE THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN FALSE THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (FALSE OR (c.relkind IN ('r', 'p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2019-06-10 16:24:56 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:43 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
11 2ms 3ms 3ms 3 9ms SELECT setting FROM pg_settings WHERE name = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 6ms 3ms [ User: browndwarf - Total duration: 9ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 3 ]
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
-
SELECT setting FROM pg_settings WHERE name = 'edb_redwood_date';
Date: 2019-06-10 16:23:21 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:54 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
12 2ms 2ms 2ms 3 8ms SELECT current_schema();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 5ms 2ms [ User: browndwarf - Total duration: 8ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8ms - Times executed: 3 ]
-
SELECT current_schema();
-
SELECT current_schema();
-
SELECT current_schema();
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:42 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
13 2ms 2ms 2ms 6 16ms SELECT count(*) FROM public.databasechangeloglock;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 11 2 5ms 2ms 16 4 11ms 2ms [ User: browndwarf - Total duration: 16ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16ms - Times executed: 6 ]
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
-
SELECT count(*) FROM public.databasechangeloglock;
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:55 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
14 2ms 2ms 2ms 3 7ms SELECT * FROM public.databasechangelog ORDER BY dateexecuted ASC, orderexecuted ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 10 11 1 2ms 2ms 16 2 5ms 2ms [ User: browndwarf - Total duration: 7ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 3 ]
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
-
SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
Date: 2019-06-10 16:24:56 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:43 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 2ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 3ms 2ms 24 50ms SELECT typinput = ?::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(?, array_upper(current_schemas(FALSE), ?)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = ? ORDER BY sp.r, pg_type.oid DESC LIMIT ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 11 12 27ms 2ms 16 12 23ms 1ms [ User: browndwarf - Total duration: 50ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 50ms - Times executed: 24 ]
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'pg_node_tree' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'regproc' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
-
SELECT typinput = 'array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN ( SELECT ns.oid AS nspoid, ns.nspname, r.r FROM pg_namespace AS ns JOIN ( SELECT s.r, (current_schemas(FALSE)) [ s.r ] AS nspname FROM generate_series(1, array_upper(current_schemas(FALSE), 1)) AS s (r)) AS r USING (nspname)) AS sp ON sp.nspoid = typnamespace WHERE typname = 'oidvector' ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 3ms 1ms 34 52ms SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 11 17 28ms 1ms 16 17 23ms 1ms [ User: browndwarf - Total duration: 52ms - Times executed: 34 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 34 ]
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13053';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '13052';
-
SELECT n.nspname = ANY (current_schemas(TRUE)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = '1034';
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 11:23:44 Duration: 3ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 74ms 0ms 1,000,000 1m19s INSERT INTO star (createdtime, description, mass, name, pictureurl, radius, class, temperature, updatedtime) VALUES (?, ?, ?, ?, NULL, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 11 223,705 17s351ms 0ms 12 353,028 27s316ms 0ms 13 238,767 18s820ms 0ms 14 125,486 10s809ms 0ms 15 55,033 4s733ms 0ms 16 3,981 317ms 0ms [ User: browndwarf - Total duration: 1m19s - Times executed: 1000000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m19s - Times executed: 1000000 ]
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.028', 'Mass Test', '53', 'Antares-92c', NULL, '84', 'C', '7000', '2019-06-10 12:18:11.028');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '73', 'Barnerd-22x', NULL, '30', 'C', '6000', '2019-06-10 12:18:11.064');
-
INSERT INTO star (createdTime, description, mass, name, pictureURL, radius, class, temperature, updatedTime) VALUES ('2019-06-10 12:18:11.063', 'Mass Test', '64', 'Gacrux-33s', NULL, '32', 'C', '5000', '2019-06-10 12:18:11.064');
Date: 2019-06-10 12:18:11 Duration: 74ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 12:18:11 Duration: 38ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 686ms 0ms 1,006,225 59s386ms UPDATE star SET description = ?, mass = ?, name = ?, pictureurl = NULL, radius = ?, class = ?, temperature = ?, updatedtime = ? WHERE id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 16 143,843 7s911ms 0ms 17 226,207 13s230ms 0ms 18 208,880 12s18ms 0ms 19 199,652 10s694ms 0ms 20 92,018 6s585ms 0ms 21 90,469 6s21ms 0ms 22 45,156 2s924ms 0ms [ User: browndwarf - Total duration: 59s386ms - Times executed: 1006225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 59s386ms - Times executed: 1006225 ]
-
UPDATE star SET description = 'Mass Test', mass = '399', name = 'Gacrux-70aSOE', pictureURL = NULL, radius = '72', class = 'C', temperature = '1000', updatedTime = '2019-06-10 18:19:07.48' WHERE id = '27626';
-
UPDATE star SET description = 'Mass Test', mass = '132', name = 'HD-68zQ', pictureURL = NULL, radius = '42', class = 'C', temperature = '2000', updatedTime = '2019-06-10 17:25:33.277' WHERE id = '648662';
-
UPDATE star SET description = 'Mass Test', mass = '138', name = 'Gacrux-1bJ', pictureURL = NULL, radius = '70', class = 'C', temperature = '1000', updatedTime = '2019-06-10 20:10:26.825' WHERE id = '678204';
Date: 2019-06-10 18:19:08 Duration: 686ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 17:25:33 Duration: 581ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 20:10:27 Duration: 289ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 3 0ms UPDATE public.databasechangeloglock SET LOCKED = FALSE, lockedby = NULL, lockgranted = NULL WHERE id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 11 1 0ms 0ms 16 2 0ms 0ms [ User: browndwarf - Total duration: 0ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 3 ]
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
-
UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
Date: 2019-06-10 11:23:43 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:24:56 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:23:21 Duration: 0ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 164ms 0ms 1,874,873 1m5s SELECT star0_.id AS id1_0_0_, star0_.createdtime AS createdt2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureurl AS pictureu6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedtime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 16 269,712 8s389ms 0ms 17 428,348 13s165ms 0ms 18 397,170 12s594ms 0ms 19 378,532 12s413ms 0ms 20 160,034 7s266ms 0ms 21 157,453 7s333ms 0ms 22 83,624 3s912ms 0ms [ User: browndwarf - Total duration: 1m5s - Times executed: 1874873 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m5s - Times executed: 1874873 ]
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '339921';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '165702';
-
SELECT star0_.id AS id1_0_0_, star0_.createdTime AS createdT2_0_0_, star0_.description AS descript3_0_0_, star0_.mass AS mass4_0_0_, star0_.name AS name5_0_0_, star0_.pictureURL AS pictureU6_0_0_, star0_.radius AS radius7_0_0_, star0_.class AS class8_0_0_, star0_.temperature AS temperat9_0_0_, star0_.updatedTime AS updated10_0_0_ FROM star star0_ WHERE star0_.id = '245413';
Date: 2019-06-10 20:01:34 Duration: 164ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:22:17 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-06-10 16:25:22 Duration: 6ms Database: galaxy User: browndwarf Remote: 16.8.35.227 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 35,472,540 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 5 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 7 Total events found
Rank Times reported Error 1 2 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 10 11 1 16 1 - FATAL: terminating connection due to administrator command
Date: 2019-06-10 11:15:13 Database: galaxy Application: psql User: browndwarf Remote: ::1 Code:
2 2 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 10 11 1 16 1 - LOG: database system was shut down at 2019-06-10 11:15:13 KST
- LOG: database system was shut down at 2019-06-10 16:23:56 KST
Date: 2019-06-10 11:22:10
Date: 2019-06-10 16:23:59
3 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 10 10 1 - ERROR: column "max_parallel_workers_per_gather" does not exist at character 8
Statement: SELECT max_parallel_workers_per_gather;
Date: 2019-06-10 10:32:29 Database: galaxy Application: psql User: browndwarf Remote: ::1 Code:
4 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 10 11 1 - ERROR: relation "public.databasechangeloglock" does not exist at character 22
Statement: SELECT COUNT(*) FROM public.databasechangeloglock
Date: 2019-06-10 11:23:42 Database: galaxy Application: PostgreSQL JDBC Driver User: browndwarf Remote: 16.8.35.227 Code:
5 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 10 10 1 - ERROR: syntax error at or near "GET" at character 1
Statement: GET max_parallel_workers_per_gather;
Date: 2019-06-10 10:32:18 Database: galaxy Application: psql User: browndwarf Remote: ::1 Code: