pgBadger-
Global information
- Generated on Mon Sep 2 00:00:15 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,158,035 log entries in 13s
- Log start from 2019-09-01 00:00:00 to 2019-09-01 23:59:59
-
Overview
Global Stats
- 166 Number of unique normalized queries
- 1,070,510 Number of queries
- 1m Total query duration
- 2019-09-01 00:00:00 First query
- 2019-09-01 23:59:59 Last query
- 2,074 queries/s at 2019-09-01 17:01:01 Query peak
- 2 Number of events
- 2 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 40 Total number of automatic vacuums
- 64 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,649 Total number of sessions
- 3 sessions at 2019-09-01 00:58:46 Session peak
- 10d7h25m22s Total duration of sessions
- 5m36s Average duration of sessions
- 404 Average queries per session
- 22ms Average queries duration per session
- 2,649 Total number of connections
- 24 connections/s at 2019-09-01 00:30:21 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2,074 queries/s Query Peak
- 2019-09-01 17:01:01 Date
SELECT Traffic
Key values
- 2,000 queries/s Query Peak
- 2019-09-01 17:01:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 124 queries/s Query Peak
- 2019-09-01 00:00:03 Date
Queries duration
Key values
- 1m Total query duration
Prepared queries ratio
Key values
- 1.53 Ratio of bind vs prepare
- 168.84 % 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) Sep 01 00 51,467 0ms 40ms 0ms 101ms 123ms 803ms 01 43,902 0ms 39ms 0ms 85ms 110ms 175ms 02 43,960 0ms 39ms 0ms 77ms 96ms 178ms 03 43,928 0ms 50ms 0ms 79ms 96ms 195ms 04 43,962 0ms 43ms 0ms 84ms 89ms 199ms 05 43,867 0ms 40ms 0ms 84ms 110ms 199ms 06 43,935 0ms 43ms 0ms 92ms 105ms 199ms 07 43,956 0ms 41ms 0ms 79ms 91ms 204ms 08 43,940 0ms 39ms 0ms 85ms 94ms 197ms 09 43,018 0ms 43ms 0ms 82ms 91ms 149ms 10 43,449 0ms 44ms 0ms 76ms 88ms 151ms 11 45,929 0ms 39ms 0ms 84ms 95ms 210ms 12 43,295 0ms 40ms 0ms 78ms 81ms 155ms 13 43,770 0ms 41ms 0ms 77ms 86ms 224ms 14 44,256 0ms 39ms 0ms 77ms 90ms 217ms 15 43,669 0ms 40ms 0ms 89ms 111ms 163ms 16 46,175 0ms 39ms 0ms 93ms 110ms 167ms 17 45,882 0ms 40ms 0ms 89ms 114ms 230ms 18 42,948 0ms 41ms 0ms 76ms 101ms 151ms 19 46,353 0ms 38ms 0ms 78ms 90ms 167ms 20 45,098 0ms 39ms 0ms 80ms 92ms 537ms 21 46,165 0ms 38ms 0ms 90ms 103ms 160ms 22 44,135 0ms 84ms 0ms 92ms 128ms 239ms 23 43,451 0ms 44ms 0ms 94ms 105ms 181ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 01 00 18,211 0 0ms 55ms 61ms 368ms 01 14,553 0 0ms 47ms 65ms 89ms 02 14,567 0 0ms 53ms 61ms 75ms 03 14,558 0 0ms 39ms 59ms 81ms 04 14,567 0 0ms 46ms 59ms 91ms 05 14,539 0 0ms 45ms 64ms 91ms 06 14,566 0 0ms 53ms 67ms 86ms 07 14,566 0 0ms 52ms 62ms 77ms 08 14,573 0 0ms 50ms 62ms 77ms 09 14,284 0 0ms 51ms 59ms 76ms 10 14,416 0 0ms 51ms 59ms 73ms 11 16,522 0 0ms 51ms 58ms 82ms 12 14,365 0 0ms 51ms 58ms 72ms 13 14,507 0 0ms 49ms 59ms 68ms 14 14,570 0 0ms 46ms 59ms 73ms 15 14,397 0 0ms 50ms 65ms 79ms 16 16,489 0 0ms 52ms 68ms 90ms 17 16,432 0 0ms 50ms 74ms 85ms 18 14,221 0 0ms 51ms 59ms 78ms 19 16,541 0 0ms 52ms 59ms 82ms 20 16,625 0 0ms 51ms 62ms 192ms 21 16,606 0 0ms 49ms 67ms 87ms 22 14,620 0 0ms 45ms 68ms 78ms 23 14,437 0 0ms 57ms 65ms 94ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 01 00 297 1,020 78 0 0ms 9ms 12ms 19ms 01 64 41 76 0 0ms 1ms 4ms 8ms 02 64 41 79 0 0ms 0ms 4ms 8ms 03 64 42 75 0 0ms 1ms 4ms 8ms 04 64 41 78 0 0ms 1ms 4ms 8ms 05 64 41 76 0 0ms 1ms 4ms 8ms 06 64 41 77 0 0ms 1ms 4ms 8ms 07 64 41 77 0 0ms 1ms 4ms 7ms 08 64 42 77 0 0ms 1ms 3ms 8ms 09 64 39 77 0 0ms 1ms 4ms 8ms 10 64 37 77 0 0ms 1ms 4ms 8ms 11 64 39 77 0 0ms 0ms 4ms 8ms 12 64 40 77 0 0ms 0ms 4ms 8ms 13 64 42 77 0 0ms 0ms 2ms 9ms 14 64 41 77 0 0ms 0ms 4ms 8ms 15 64 38 77 0 0ms 0ms 3ms 10ms 16 64 37 77 0 0ms 0ms 2ms 10ms 17 64 40 77 0 0ms 0ms 2ms 10ms 18 64 39 77 0 0ms 0ms 4ms 8ms 19 64 37 77 0 0ms 0ms 3ms 8ms 20 109 75 112 0 0ms 1ms 7ms 8ms 21 88 50 81 0 0ms 1ms 3ms 8ms 22 88 53 81 0 0ms 1ms 3ms 9ms 23 80 48 79 0 0ms 0ms 3ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 01 00 31,862 51,407 1.61 98.29% 01 29,538 43,842 1.48 115.08% 02 29,408 43,900 1.49 114.47% 03 29,508 43,868 1.49 114.95% 04 29,608 43,902 1.48 115.27% 05 29,473 43,807 1.49 114.94% 06 29,530 43,873 1.49 114.99% 07 29,650 43,896 1.48 115.42% 08 29,669 43,880 1.48 115.52% 09 28,969 42,958 1.48 115.18% 10 29,211 43,389 1.49 115.02% 11 29,558 45,869 1.55 106.93% 12 29,054 43,235 1.49 114.77% 13 29,260 43,710 1.49 114.40% 14 28,314 44,196 1.56 109.63% 15 27,820 43,609 1.57 109.10% 16 27,846 46,115 1.66 100.37% 17 28,265 45,822 1.62 102.44% 18 28,050 42,886 1.53 111.74% 19 28,020 46,293 1.65 100.63% 20 28,189 45,038 1.60 102.44% 21 29,920 46,105 1.54 107.48% 22 29,622 44,075 1.49 114.62% 23 29,386 43,391 1.48 115.45% Day Hour Count Average / Second Sep 01 00 152 0.04/s 01 109 0.03/s 02 110 0.03/s 03 117 0.03/s 04 116 0.03/s 05 112 0.03/s 06 113 0.03/s 07 117 0.03/s 08 117 0.03/s 09 116 0.03/s 10 116 0.03/s 11 117 0.03/s 12 111 0.03/s 13 117 0.03/s 14 92 0.03/s 15 88 0.02/s 16 87 0.02/s 17 97 0.03/s 18 103 0.03/s 19 89 0.02/s 20 103 0.03/s 21 119 0.03/s 22 115 0.03/s 23 116 0.03/s Day Hour Count Average Duration Sep 01 00 149 5m49s 01 112 5m47s 02 110 5m24s 03 117 6m 04 116 5m6s 05 112 5m13s 06 113 5m23s 07 117 5m8s 08 117 5m7s 09 116 5m29s 10 116 4m58s 11 117 5m7s 12 111 5m18s 13 117 5m30s 14 92 6m9s 15 88 6m56s 16 87 6m49s 17 97 6m26s 18 103 5m37s 19 89 6m48s 20 103 5m41s 21 119 5m19s 22 115 4m57s 23 116 5m24s -
Connections
Established Connections
Key values
- 24 connections Connection Peak
- 2019-09-01 00:30:21 Date
Connections per database
Key values
- pharmisight Main Database
- 2,649 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,649 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-09-01 00:58:46 Date
Histogram of session times
Key values
- 1,344 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,649 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,649 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,649 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 325 buffers Checkpoint Peak
- 2019-09-01 01:02:08 Date
- 32.632 seconds Highest write time
- 0.011 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-09-01 02:01:54 Date
Checkpoints distance
Key values
- 2.40 Mo Distance Peak
- 2019-09-01 01:02:08 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 01 00 1,387 139.105s 0.016s 139.357s 01 803 80.618s 0.019s 80.706s 02 445 44.581s 0.022s 44.676s 03 531 53.294s 0.022s 53.388s 04 528 52.994s 0.029s 53.096s 05 511 51.294s 0.023s 51.384s 06 548 55.02s 0.013s 55.102s 07 426 42.758s 0.021s 42.856s 08 585 58.725s 0.021s 58.814s 09 283 28.411s 0.016s 28.484s 10 346 34.734s 0.01s 34.795s 11 289 29.01s 0.01s 29.073s 12 336 33.719s 0.017s 33.786s 13 352 35.34s 0.013s 35.404s 14 390 39.951s 0.011s 40.011s 15 368 36.951s 0.008s 37.011s 16 386 38.746s 0.013s 38.815s 17 283 28.409s 0.014s 28.485s 18 404 40.567s 0.018s 40.631s 19 435 43.678s 0.011s 43.741s 20 325 32.635s 0.012s 32.693s 21 420 42.168s 0.015s 42.239s 22 435 43.68s 0.013s 43.748s 23 476 47.683s 0.017s 47.75s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 01 00 0 0 0 287 0.002s 0s 01 0 0 0 255 0.003s 0s 02 0 0 1 236 0.003s 0s 03 0 0 0 241 0.003s 0s 04 0 0 0 235 0.011s 0s 05 0 0 0 230 0.003s 0s 06 0 0 0 240 0.002s 0s 07 0 0 0 223 0.003s 0s 08 0 0 0 235 0.003s 0s 09 0 0 0 176 0.003s 0s 10 0 0 0 161 0.002s 0s 11 0 0 0 144 0.002s 0s 12 0 0 0 144 0.003s 0s 13 0 0 1 148 0.003s 0s 14 0 0 0 146 0.003s 0s 15 0 0 0 155 0.001s 0s 16 0 0 0 157 0.002s 0.002s 17 0 0 0 146 0.003s 0s 18 0 0 0 169 0.010s 0s 19 0 0 0 228 0.002s 0s 20 0 0 0 217 0.003s 0s 21 0 0 0 218 0.003s 0s 22 0 0 0 226 0.002s 0s 23 0 0 0 218 0.005s 0s Day Hour Count Avg time (sec) Sep 01 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 Sep 01 00 677.17 kB 985.25 kB 01 239.58 kB 811.50 kB 02 134.33 kB 518.50 kB 03 141.75 kB 357.58 kB 04 130.17 kB 360.17 kB 05 131.50 kB 513.75 kB 06 154.25 kB 387.17 kB 07 95.08 kB 247.00 kB 08 188.75 kB 473.58 kB 09 79.90 kB 345.90 kB 10 120.11 kB 219.22 kB 11 96.67 kB 188.33 kB 12 121.67 kB 362.78 kB 13 161.38 kB 419.50 kB 14 174.25 kB 365.88 kB 15 160.00 kB 400.78 kB 16 134.20 kB 371.00 kB 17 107.88 kB 204.38 kB 18 197.62 kB 506.50 kB 19 187.11 kB 341.33 kB 20 132.62 kB 324.75 kB 21 167.11 kB 292.00 kB 22 149.89 kB 257.22 kB 23 173.75 kB 547.38 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 Sep 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_data_event (15) Main table analyzed (database pharmisight)
- 64 analyzes Total
Vacuums per table
Key values
- public.sym_data_event (8) Main table vacuumed on database pharmisight
- 40 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_data_event 8 8 pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_data 7 7 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_node_host 4 0 pharmisight.public.sym_data_gap 4 4 pharmisight.pg_catalog.pg_statistic 3 2 pharmisight.public.sym_sequence 1 0 Total 40 34 Tuples removed per table
Key values
- public.sym_data_event (3415) Main table with removed tuples on database pharmisight
- 7851 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 8 8 3415 1199 pharmisight.public.sym_data 7 7 1239 1136 pharmisight.pg_catalog.pg_statistic 3 2 972 0 pharmisight.public.sym_incoming_batch 5 5 892 0 pharmisight.public.sym_outgoing_batch 8 8 870 276 pharmisight.public.sym_node_host 4 0 208 0 pharmisight.public.sym_data_gap 4 4 204 0 pharmisight.public.sym_sequence 1 0 51 0 Total 40 34 7,851 2,611 Pages removed per table
Key values
- public.sym_data_event (1199) Main table with removed pages on database pharmisight
- 2611 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 8 8 3415 1199 pharmisight.public.sym_data 7 7 1239 1136 pharmisight.public.sym_outgoing_batch 8 8 870 276 pharmisight.public.sym_node_host 4 0 208 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.pg_catalog.pg_statistic 3 2 972 0 pharmisight.public.sym_data_gap 4 4 204 0 pharmisight.public.sym_incoming_batch 5 5 892 0 Total 40 34 7,851 2,611 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 01 00 1 8 01 5 4 02 2 2 03 4 4 04 1 3 05 2 3 06 2 6 07 1 0 08 2 3 09 1 0 10 2 3 11 0 2 12 1 2 13 1 2 14 1 2 15 2 2 16 3 3 17 2 2 18 0 1 19 1 5 20 0 0 21 1 3 22 3 2 23 2 2 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 363,732 Total read queries
- 269,440 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,069,930 Requests
- 50s191ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,048,484 Requests
User Request type Count Duration librenms Total 604 10s817ms SELECT 604 10s817ms pharmisight Total 64,730 4s587ms DELETE 33 5ms INSERT 33 3ms OTHERS 1,713 90ms SELECT 62,409 4s464ms TCL 510 15ms UPDATE 32 8ms symmetricds Total 1,048,484 47s97ms DELETE 1,924 597ms INSERT 1,909 695ms OTHERS 454,040 7s620ms SELECT 314,337 30s534ms TCL 274,260 5s572ms UPDATE 2,014 2s76ms tony Total 900 299ms SELECT 900 299ms Duration by user
Key values
- 47s97ms (symmetricds) Main time consuming user
User Request type Count Duration librenms Total 604 10s817ms SELECT 604 10s817ms pharmisight Total 64,730 4s587ms DELETE 33 5ms INSERT 33 3ms OTHERS 1,713 90ms SELECT 62,409 4s464ms TCL 510 15ms UPDATE 32 8ms symmetricds Total 1,048,484 47s97ms DELETE 1,924 597ms INSERT 1,909 695ms OTHERS 454,040 7s620ms SELECT 314,337 30s534ms TCL 274,260 5s572ms UPDATE 2,014 2s76ms tony Total 900 299ms SELECT 900 299ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,113,214 Requests
- 51s685ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,067,285 Requests
- 49s809ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-09-01 18:16:43 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,065,765 0-1ms duration
Slowest individual queries
Rank Duration Query 1 84ms COMMIT;[ Date: 2019-09-01 22:15:53 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 50ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 03:30:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
3 44ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 10:45:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
4 44ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 23:30:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
5 43ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 09:55:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
6 43ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 04:45:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
7 43ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 06:45:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
8 42ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 10:55:13 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
9 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 06:50:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
10 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 18:55:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
11 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 07:55:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
12 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 23:40:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
13 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 13:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
14 41ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 07:50:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
15 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 17:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
16 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 05:20:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
17 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 15:55:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
18 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 03:35:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
19 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 12:35:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
20 40ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;[ Date: 2019-09-01 00:55:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10s379ms 17,075 0ms 5ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 01 717 423ms 0ms 02 716 441ms 0ms 03 718 433ms 0ms 04 716 440ms 0ms 05 716 439ms 0ms 06 716 441ms 0ms 07 716 446ms 0ms 08 716 437ms 0ms 09 716 442ms 0ms 10 702 427ms 0ms 11 706 428ms 0ms 12 718 435ms 0ms 13 704 425ms 0ms 14 716 438ms 0ms 15 716 432ms 0ms 16 704 415ms 0ms 17 716 417ms 0ms 18 712 427ms 0ms 19 696 418ms 0ms 20 716 426ms 0ms 21 686 417ms 0ms 22 716 439ms 0ms 23 716 448ms 0ms 00 704 433ms 0ms [ User: symmetricds - Total duration: 10s379ms - Times executed: 17075 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s379ms - Times executed: 17075 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-01 01:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:09:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:08:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 10s193ms 290 13ms 50ms 35ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 01 12 429ms 35ms 02 12 423ms 35ms 03 12 427ms 35ms 04 12 366ms 30ms 05 12 374ms 31ms 06 12 430ms 35ms 07 13 471ms 36ms 08 12 444ms 37ms 09 12 432ms 36ms 10 12 432ms 36ms 11 12 445ms 37ms 12 12 420ms 35ms 13 12 427ms 35ms 14 12 418ms 34ms 15 12 392ms 32ms 16 12 428ms 35ms 17 12 416ms 34ms 18 12 432ms 36ms 19 13 459ms 35ms 20 12 429ms 35ms 21 12 436ms 36ms 22 12 380ms 31ms 23 12 431ms 35ms 00 12 438ms 36ms [ User: librenms - Total duration: 10s193ms - Times executed: 290 ]
[ Application: psql - Total duration: 10s193ms - Times executed: 290 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-09-01 03:30:11 Duration: 50ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-01 10:45:12 Duration: 44ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-01 23:30:11 Duration: 44ms Database: postgres User: librenms Remote: [local] Application: psql
3 6s943ms 415,652 0ms 11ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 01 18,056 305ms 0ms 02 17,331 289ms 0ms 03 17,357 289ms 0ms 04 17,337 290ms 0ms 05 17,353 288ms 0ms 06 17,316 289ms 0ms 07 17,343 288ms 0ms 08 17,348 284ms 0ms 09 17,334 294ms 0ms 10 16,960 286ms 0ms 11 17,143 285ms 0ms 12 17,363 286ms 0ms 13 17,081 282ms 0ms 14 17,272 295ms 0ms 15 17,556 292ms 0ms 16 17,317 292ms 0ms 17 17,570 291ms 0ms 18 17,411 289ms 0ms 19 16,975 284ms 0ms 20 17,642 295ms 0ms 21 16,721 279ms 0ms 22 17,402 289ms 0ms 23 17,373 287ms 0ms 00 17,091 283ms 0ms [ User: symmetricds - Total duration: 6s915ms - Times executed: 415101 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s943ms - Times executed: 415652 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-09-01 00:37:45 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:46:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 08:25:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4s507ms 131,831 0ms 84ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 01 6,404 551ms 0ms 02 5,467 160ms 0ms 03 5,470 159ms 0ms 04 5,466 164ms 0ms 05 5,468 172ms 0ms 06 5,461 160ms 0ms 07 5,466 165ms 0ms 08 5,470 163ms 0ms 09 5,464 162ms 0ms 10 5,344 172ms 0ms 11 5,401 155ms 0ms 12 5,470 175ms 0ms 13 5,385 163ms 0ms 14 5,443 173ms 0ms 15 5,538 162ms 0ms 16 5,462 155ms 0ms 17 5,538 169ms 0ms 18 5,490 157ms 0ms 19 5,351 174ms 0ms 20 5,563 186ms 0ms 21 5,298 165ms 0ms 22 5,506 173ms 0ms 23 5,501 281ms 0ms 00 5,405 179ms 0ms [ User: symmetricds - Total duration: 4s493ms - Times executed: 131583 ]
[ User: pharmisight - Total duration: 13ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s507ms - Times executed: 131831 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-09-01 22:15:53 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 22:10:53 Duration: 26ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 00:37:48 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s833ms 151,566 0ms 3ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 01 7,622 91ms 0ms 02 6,274 76ms 0ms 03 6,287 75ms 0ms 04 6,275 76ms 0ms 05 6,280 74ms 0ms 06 6,268 75ms 0ms 07 6,281 75ms 0ms 08 6,275 74ms 0ms 09 6,275 75ms 0ms 10 6,141 74ms 0ms 11 6,202 74ms 0ms 12 6,283 78ms 0ms 13 6,184 74ms 0ms 14 6,254 76ms 0ms 15 6,349 78ms 0ms 16 6,261 77ms 0ms 17 6,349 79ms 0ms 18 6,297 74ms 0ms 19 6,142 73ms 0ms 20 6,373 76ms 0ms 21 6,064 72ms 0ms 22 6,317 75ms 0ms 23 6,312 76ms 0ms 00 6,201 75ms 0ms [ User: symmetricds - Total duration: 1s833ms - Times executed: 151566 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s833ms - Times executed: 151566 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-09-01 00:02:45 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 16:16:05 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:40:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s705ms 1,174 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 01 43 62ms 1ms 02 55 78ms 1ms 03 53 77ms 1ms 04 55 80ms 1ms 05 56 81ms 1ms 06 54 78ms 1ms 07 56 78ms 1ms 08 56 79ms 1ms 09 58 85ms 1ms 10 52 76ms 1ms 11 55 81ms 1ms 12 56 80ms 1ms 13 53 77ms 1ms 14 55 80ms 1ms 15 35 50ms 1ms 16 33 47ms 1ms 17 27 41ms 1ms 18 37 54ms 1ms 19 42 59ms 1ms 20 30 43ms 1ms 21 46 68ms 1ms 22 57 83ms 1ms 23 53 77ms 1ms 00 57 81ms 1ms [ User: symmetricds - Total duration: 1s705ms - Times executed: 1174 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s705ms - Times executed: 1174 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 21:42:24 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 16:42:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:27:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s504ms 30,960 0ms 2ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 01 1,032 29ms 0ms 02 1,032 42ms 0ms 03 1,032 43ms 0ms 04 1,032 53ms 0ms 05 1,032 59ms 0ms 06 1,032 52ms 0ms 07 1,032 57ms 0ms 08 1,032 57ms 0ms 09 1,032 55ms 0ms 10 1,032 57ms 0ms 11 1,032 57ms 0ms 12 2,064 85ms 0ms 13 1,032 57ms 0ms 14 1,032 62ms 0ms 15 1,032 63ms 0ms 16 1,032 57ms 0ms 17 2,064 85ms 0ms 18 2,064 85ms 0ms 19 1,032 56ms 0ms 20 2,064 89ms 0ms 21 2,064 88ms 0ms 22 2,064 90ms 0ms 23 1,032 59ms 0ms 00 1,032 57ms 0ms [ User: pharmisight - Total duration: 1s504ms - Times executed: 30960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s504ms - Times executed: 30960 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33074336' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969174' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-01 13:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s477ms 1,419 0ms 10ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 01 56 57ms 1ms 02 65 65ms 1ms 03 65 67ms 1ms 04 64 62ms 0ms 05 66 67ms 1ms 06 66 68ms 1ms 07 65 70ms 1ms 08 67 68ms 1ms 09 70 74ms 1ms 10 65 79ms 1ms 11 65 67ms 1ms 12 66 68ms 1ms 13 63 66ms 1ms 14 66 73ms 1ms 15 42 41ms 0ms 16 38 37ms 0ms 17 32 32ms 1ms 18 42 42ms 1ms 19 51 51ms 1ms 20 38 38ms 1ms 21 56 56ms 1ms 22 73 75ms 1ms 23 70 71ms 1ms 00 68 71ms 1ms [ User: symmetricds - Total duration: 1s477ms - Times executed: 1419 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s477ms - Times executed: 1419 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 09:07:51 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:24:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:37:47 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s346ms 27,480 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 01 01 916 26ms 0ms 02 916 39ms 0ms 03 916 38ms 0ms 04 916 48ms 0ms 05 916 53ms 0ms 06 916 47ms 0ms 07 916 51ms 0ms 08 916 51ms 0ms 09 916 49ms 0ms 10 916 51ms 0ms 11 916 50ms 0ms 12 1,832 76ms 0ms 13 916 51ms 0ms 14 916 53ms 0ms 15 916 55ms 0ms 16 916 51ms 0ms 17 1,832 76ms 0ms 18 1,832 76ms 0ms 19 916 50ms 0ms 20 1,832 80ms 0ms 21 1,832 79ms 0ms 22 1,832 80ms 0ms 23 916 54ms 0ms 00 916 51ms 0ms [ User: pharmisight - Total duration: 1s346ms - Times executed: 27480 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s346ms - Times executed: 27480 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969174' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '43' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3356' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-01 14:40:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s325ms 24,779 0ms 4ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 01 1,112 57ms 0ms 02 1,036 56ms 0ms 03 1,038 54ms 0ms 04 1,036 54ms 0ms 05 1,036 55ms 0ms 06 1,036 59ms 0ms 07 1,036 54ms 0ms 08 1,036 57ms 0ms 09 1,036 58ms 0ms 10 1,012 52ms 0ms 11 1,026 59ms 0ms 12 1,038 56ms 0ms 13 1,019 54ms 0ms 14 1,031 54ms 0ms 15 1,036 53ms 0ms 16 1,019 53ms 0ms 17 1,036 55ms 0ms 18 1,032 56ms 0ms 19 1,006 53ms 0ms 20 1,036 54ms 0ms 21 995 53ms 0ms 22 1,036 54ms 0ms 23 1,036 53ms 0ms 00 1,019 53ms 0ms [ User: symmetricds - Total duration: 1s325ms - Times executed: 24779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s325ms - Times executed: 24779 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-09-01 10:57:54 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:23:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:51:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s136ms 1,184 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 01 45 41ms 0ms 02 55 53ms 0ms 03 55 53ms 0ms 04 56 55ms 0ms 05 57 56ms 0ms 06 54 52ms 0ms 07 56 54ms 0ms 08 57 55ms 0ms 09 57 55ms 0ms 10 53 50ms 0ms 11 54 51ms 0ms 12 57 56ms 0ms 13 53 51ms 0ms 14 54 52ms 0ms 15 35 32ms 0ms 16 32 30ms 0ms 17 28 25ms 0ms 18 37 34ms 0ms 19 42 38ms 0ms 20 30 28ms 0ms 21 46 44ms 0ms 22 58 54ms 0ms 23 55 52ms 0ms 00 58 54ms 0ms [ User: symmetricds - Total duration: 1s136ms - Times executed: 1184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s136ms - Times executed: 1184 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 12:36:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:43:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 10:13:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s106ms 8,537 0ms 1ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 01 358 8ms 0ms 02 358 8ms 0ms 03 359 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 351 8ms 0ms 11 353 8ms 0ms 12 359 9ms 0ms 13 352 8ms 0ms 14 358 37ms 0ms 15 358 97ms 0ms 16 352 97ms 0ms 17 358 98ms 0ms 18 356 95ms 0ms 19 348 90ms 0ms 20 358 93ms 0ms 21 343 91ms 0ms 22 358 98ms 0ms 23 358 99ms 0ms 00 352 92ms 0ms [ User: symmetricds - Total duration: 1s106ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s106ms - Times executed: 8537 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200312' AND data_id <= '156200311' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200260' AND data_id <= '156200259' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200242' AND data_id <= '156200241' ORDER BY data_id ASC;
Date: 2019-09-01 21:52:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:56:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:50:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s33ms 1,161 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 01 44 38ms 0ms 02 53 47ms 0ms 03 53 46ms 0ms 04 54 47ms 0ms 05 55 49ms 0ms 06 53 47ms 0ms 07 55 49ms 0ms 08 56 49ms 0ms 09 57 52ms 0ms 10 52 46ms 0ms 11 54 46ms 0ms 12 55 50ms 0ms 13 53 48ms 0ms 14 51 45ms 0ms 15 34 30ms 0ms 16 32 28ms 0ms 17 28 25ms 0ms 18 37 32ms 0ms 19 42 35ms 0ms 20 30 27ms 0ms 21 46 41ms 0ms 22 58 51ms 0ms 23 53 47ms 0ms 00 56 49ms 0ms [ User: symmetricds - Total duration: 1s33ms - Times executed: 1161 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s33ms - Times executed: 1161 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 00:39:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:24:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:11:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 935ms 139 4ms 12ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 01 93 552ms 5ms 02 2 13ms 6ms 03 2 14ms 7ms 04 2 13ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 18ms 9ms 10 2 17ms 8ms 11 2 18ms 9ms 12 2 18ms 9ms 13 2 18ms 9ms 14 2 18ms 9ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 18ms 9ms 18 2 18ms 9ms 19 2 18ms 9ms 20 2 18ms 9ms 21 2 18ms 9ms 22 2 13ms 6ms 23 2 18ms 9ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 736ms - Times executed: 94 ]
[ User: pharmisight - Total duration: 199ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 139 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-09-01 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 02:06:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:15:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 934ms 17,169 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 01 720 39ms 0ms 02 720 38ms 0ms 03 722 39ms 0ms 04 720 39ms 0ms 05 720 39ms 0ms 06 720 39ms 0ms 07 720 39ms 0ms 08 720 38ms 0ms 09 720 38ms 0ms 10 706 38ms 0ms 11 710 37ms 0ms 12 722 38ms 0ms 13 708 39ms 0ms 14 720 38ms 0ms 15 720 39ms 0ms 16 708 38ms 0ms 17 720 39ms 0ms 18 716 39ms 0ms 19 700 38ms 0ms 20 720 39ms 0ms 21 689 37ms 0ms 22 720 38ms 0ms 23 720 40ms 0ms 00 708 38ms 0ms [ User: symmetricds - Total duration: 934ms - Times executed: 17169 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 934ms - Times executed: 17169 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-09-01 22:56:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:59:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 04:16:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 878ms 131,832 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 01 6,405 42ms 0ms 02 5,467 35ms 0ms 03 5,470 35ms 0ms 04 5,466 36ms 0ms 05 5,468 37ms 0ms 06 5,461 35ms 0ms 07 5,466 36ms 0ms 08 5,470 37ms 0ms 09 5,464 36ms 0ms 10 5,344 35ms 0ms 11 5,401 35ms 0ms 12 5,470 38ms 0ms 13 5,385 35ms 0ms 14 5,443 35ms 0ms 15 5,538 37ms 0ms 16 5,462 36ms 0ms 17 5,538 36ms 0ms 18 5,490 36ms 0ms 19 5,351 35ms 0ms 20 5,563 37ms 0ms 21 5,298 35ms 0ms 22 5,506 36ms 0ms 23 5,501 37ms 0ms 00 5,405 36ms 0ms [ User: symmetricds - Total duration: 876ms - Times executed: 131583 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 878ms - Times executed: 131832 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-09-01 11:10:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 04:11:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:41:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 823ms 4,385 0ms 12ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 01 184 16ms 0ms 02 184 17ms 0ms 03 184 20ms 0ms 04 184 50ms 0ms 05 184 39ms 0ms 06 184 19ms 0ms 07 184 16ms 0ms 08 184 25ms 0ms 09 184 19ms 0ms 10 178 65ms 0ms 11 184 37ms 0ms 12 184 33ms 0ms 13 181 33ms 0ms 14 181 34ms 0ms 15 184 26ms 0ms 16 181 30ms 0ms 17 184 28ms 0ms 18 184 30ms 0ms 19 178 31ms 0ms 20 184 29ms 0ms 21 177 30ms 0ms 22 184 33ms 0ms 23 184 31ms 0ms 00 181 122ms 0ms [ User: symmetricds - Total duration: 823ms - Times executed: 4385 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 823ms - Times executed: 4385 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-09-01 09:28:01 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:47:48 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:41:57 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 706ms 95 0ms 9ms 7ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 01 4 23ms 5ms 02 4 29ms 7ms 03 4 30ms 7ms 04 4 30ms 7ms 05 4 29ms 7ms 06 4 30ms 7ms 07 4 30ms 7ms 08 4 30ms 7ms 09 4 29ms 7ms 10 4 30ms 7ms 11 4 30ms 7ms 12 4 30ms 7ms 13 4 31ms 7ms 14 4 29ms 7ms 15 4 29ms 7ms 16 4 32ms 8ms 17 4 29ms 7ms 18 4 31ms 7ms 19 4 27ms 6ms 20 4 27ms 6ms 21 4 30ms 7ms 22 4 30ms 7ms 23 4 34ms 8ms 00 3 15ms 5ms [ User: symmetricds - Total duration: 706ms - Times executed: 95 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 706ms - Times executed: 95 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '79827696', total_memory_bytes = '265289728', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 22:29:52', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '54264336', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 13:24:02', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '85052296', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 20:12:14', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-09-01 22:29:53 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:24:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:12:31 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 699ms 5,906 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 01 247 28ms 0ms 02 240 29ms 0ms 03 237 28ms 0ms 04 239 29ms 0ms 05 240 28ms 0ms 06 236 28ms 0ms 07 239 28ms 0ms 08 240 28ms 0ms 09 240 28ms 0ms 10 229 26ms 0ms 11 239 28ms 0ms 12 237 28ms 0ms 13 238 28ms 0ms 14 233 28ms 0ms 15 274 31ms 0ms 16 276 32ms 0ms 17 274 33ms 0ms 18 261 29ms 0ms 19 248 28ms 0ms 20 287 33ms 0ms 21 240 28ms 0ms 22 240 28ms 0ms 23 236 27ms 0ms 00 236 28ms 0ms [ User: symmetricds - Total duration: 699ms - Times executed: 5906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 699ms - Times executed: 5906 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-09-01 16:04:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:37:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 19:09:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 690ms 110 0ms 8ms 6ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 01 4 26ms 6ms 02 4 29ms 7ms 03 4 28ms 7ms 04 4 28ms 7ms 05 4 28ms 7ms 06 4 29ms 7ms 07 4 28ms 7ms 08 4 28ms 7ms 09 4 28ms 7ms 10 4 28ms 7ms 11 4 27ms 6ms 12 4 27ms 6ms 13 4 27ms 6ms 14 4 15ms 3ms 15 4 28ms 7ms 16 4 21ms 5ms 17 4 16ms 4ms 18 4 15ms 3ms 19 4 28ms 7ms 20 4 22ms 5ms 21 6 36ms 6ms 22 8 37ms 4ms 23 8 44ms 5ms 00 8 56ms 7ms [ User: symmetricds - Total duration: 690ms - Times executed: 110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 690ms - Times executed: 110 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '439080256', "total_memory_bytes" = '1199046656', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 22:25:34', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '594862560', "total_memory_bytes" = '1195900928', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 05:40:33', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '118350792', "total_memory_bytes" = '266862592', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 20:29:10', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-09-01 22:25:53 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:40:49 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:30:52 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 415,652 6s943ms 0ms 11ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 01 18,056 305ms 0ms 02 17,331 289ms 0ms 03 17,357 289ms 0ms 04 17,337 290ms 0ms 05 17,353 288ms 0ms 06 17,316 289ms 0ms 07 17,343 288ms 0ms 08 17,348 284ms 0ms 09 17,334 294ms 0ms 10 16,960 286ms 0ms 11 17,143 285ms 0ms 12 17,363 286ms 0ms 13 17,081 282ms 0ms 14 17,272 295ms 0ms 15 17,556 292ms 0ms 16 17,317 292ms 0ms 17 17,570 291ms 0ms 18 17,411 289ms 0ms 19 16,975 284ms 0ms 20 17,642 295ms 0ms 21 16,721 279ms 0ms 22 17,402 289ms 0ms 23 17,373 287ms 0ms 00 17,091 283ms 0ms [ User: symmetricds - Total duration: 6s915ms - Times executed: 415101 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s943ms - Times executed: 415652 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-09-01 00:37:45 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:46:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 08:25:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 151,566 1s833ms 0ms 3ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 01 7,622 91ms 0ms 02 6,274 76ms 0ms 03 6,287 75ms 0ms 04 6,275 76ms 0ms 05 6,280 74ms 0ms 06 6,268 75ms 0ms 07 6,281 75ms 0ms 08 6,275 74ms 0ms 09 6,275 75ms 0ms 10 6,141 74ms 0ms 11 6,202 74ms 0ms 12 6,283 78ms 0ms 13 6,184 74ms 0ms 14 6,254 76ms 0ms 15 6,349 78ms 0ms 16 6,261 77ms 0ms 17 6,349 79ms 0ms 18 6,297 74ms 0ms 19 6,142 73ms 0ms 20 6,373 76ms 0ms 21 6,064 72ms 0ms 22 6,317 75ms 0ms 23 6,312 76ms 0ms 00 6,201 75ms 0ms [ User: symmetricds - Total duration: 1s833ms - Times executed: 151566 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s833ms - Times executed: 151566 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-09-01 00:02:45 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 16:16:05 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:40:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 131,832 878ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 01 6,405 42ms 0ms 02 5,467 35ms 0ms 03 5,470 35ms 0ms 04 5,466 36ms 0ms 05 5,468 37ms 0ms 06 5,461 35ms 0ms 07 5,466 36ms 0ms 08 5,470 37ms 0ms 09 5,464 36ms 0ms 10 5,344 35ms 0ms 11 5,401 35ms 0ms 12 5,470 38ms 0ms 13 5,385 35ms 0ms 14 5,443 35ms 0ms 15 5,538 37ms 0ms 16 5,462 36ms 0ms 17 5,538 36ms 0ms 18 5,490 36ms 0ms 19 5,351 35ms 0ms 20 5,563 37ms 0ms 21 5,298 35ms 0ms 22 5,506 36ms 0ms 23 5,501 37ms 0ms 00 5,405 36ms 0ms [ User: symmetricds - Total duration: 876ms - Times executed: 131583 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 878ms - Times executed: 131832 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-09-01 11:10:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 04:11:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:41:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 131,831 4s507ms 0ms 84ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 01 6,404 551ms 0ms 02 5,467 160ms 0ms 03 5,470 159ms 0ms 04 5,466 164ms 0ms 05 5,468 172ms 0ms 06 5,461 160ms 0ms 07 5,466 165ms 0ms 08 5,470 163ms 0ms 09 5,464 162ms 0ms 10 5,344 172ms 0ms 11 5,401 155ms 0ms 12 5,470 175ms 0ms 13 5,385 163ms 0ms 14 5,443 173ms 0ms 15 5,538 162ms 0ms 16 5,462 155ms 0ms 17 5,538 169ms 0ms 18 5,490 157ms 0ms 19 5,351 174ms 0ms 20 5,563 186ms 0ms 21 5,298 165ms 0ms 22 5,506 173ms 0ms 23 5,501 281ms 0ms 00 5,405 179ms 0ms [ User: symmetricds - Total duration: 4s493ms - Times executed: 131583 ]
[ User: pharmisight - Total duration: 13ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s507ms - Times executed: 131831 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-09-01 22:15:53 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 22:10:53 Duration: 26ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 00:37:48 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 30,960 1s504ms 0ms 2ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 01 1,032 29ms 0ms 02 1,032 42ms 0ms 03 1,032 43ms 0ms 04 1,032 53ms 0ms 05 1,032 59ms 0ms 06 1,032 52ms 0ms 07 1,032 57ms 0ms 08 1,032 57ms 0ms 09 1,032 55ms 0ms 10 1,032 57ms 0ms 11 1,032 57ms 0ms 12 2,064 85ms 0ms 13 1,032 57ms 0ms 14 1,032 62ms 0ms 15 1,032 63ms 0ms 16 1,032 57ms 0ms 17 2,064 85ms 0ms 18 2,064 85ms 0ms 19 1,032 56ms 0ms 20 2,064 89ms 0ms 21 2,064 88ms 0ms 22 2,064 90ms 0ms 23 1,032 59ms 0ms 00 1,032 57ms 0ms [ User: pharmisight - Total duration: 1s504ms - Times executed: 30960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s504ms - Times executed: 30960 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33074336' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969174' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-01 13:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 27,480 1s346ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 01 916 26ms 0ms 02 916 39ms 0ms 03 916 38ms 0ms 04 916 48ms 0ms 05 916 53ms 0ms 06 916 47ms 0ms 07 916 51ms 0ms 08 916 51ms 0ms 09 916 49ms 0ms 10 916 51ms 0ms 11 916 50ms 0ms 12 1,832 76ms 0ms 13 916 51ms 0ms 14 916 53ms 0ms 15 916 55ms 0ms 16 916 51ms 0ms 17 1,832 76ms 0ms 18 1,832 76ms 0ms 19 916 50ms 0ms 20 1,832 80ms 0ms 21 1,832 79ms 0ms 22 1,832 80ms 0ms 23 916 54ms 0ms 00 916 51ms 0ms [ User: pharmisight - Total duration: 1s346ms - Times executed: 27480 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s346ms - Times executed: 27480 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969174' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '43' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3356' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-01 14:40:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 24,779 1s325ms 0ms 4ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 01 1,112 57ms 0ms 02 1,036 56ms 0ms 03 1,038 54ms 0ms 04 1,036 54ms 0ms 05 1,036 55ms 0ms 06 1,036 59ms 0ms 07 1,036 54ms 0ms 08 1,036 57ms 0ms 09 1,036 58ms 0ms 10 1,012 52ms 0ms 11 1,026 59ms 0ms 12 1,038 56ms 0ms 13 1,019 54ms 0ms 14 1,031 54ms 0ms 15 1,036 53ms 0ms 16 1,019 53ms 0ms 17 1,036 55ms 0ms 18 1,032 56ms 0ms 19 1,006 53ms 0ms 20 1,036 54ms 0ms 21 995 53ms 0ms 22 1,036 54ms 0ms 23 1,036 53ms 0ms 00 1,019 53ms 0ms [ User: symmetricds - Total duration: 1s325ms - Times executed: 24779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s325ms - Times executed: 24779 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-09-01 10:57:54 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:23:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:51:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,169 934ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 01 720 39ms 0ms 02 720 38ms 0ms 03 722 39ms 0ms 04 720 39ms 0ms 05 720 39ms 0ms 06 720 39ms 0ms 07 720 39ms 0ms 08 720 38ms 0ms 09 720 38ms 0ms 10 706 38ms 0ms 11 710 37ms 0ms 12 722 38ms 0ms 13 708 39ms 0ms 14 720 38ms 0ms 15 720 39ms 0ms 16 708 38ms 0ms 17 720 39ms 0ms 18 716 39ms 0ms 19 700 38ms 0ms 20 720 39ms 0ms 21 689 37ms 0ms 22 720 38ms 0ms 23 720 40ms 0ms 00 708 38ms 0ms [ User: symmetricds - Total duration: 934ms - Times executed: 17169 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 934ms - Times executed: 17169 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-09-01 22:56:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:59:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 04:16:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,144 520ms 0ms 1ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 01 01 720 21ms 0ms 02 718 21ms 0ms 03 720 21ms 0ms 04 720 21ms 0ms 05 718 21ms 0ms 06 720 22ms 0ms 07 718 21ms 0ms 08 720 21ms 0ms 09 718 21ms 0ms 10 706 21ms 0ms 11 708 21ms 0ms 12 720 21ms 0ms 13 708 21ms 0ms 14 718 22ms 0ms 15 720 22ms 0ms 16 706 21ms 0ms 17 720 22ms 0ms 18 714 21ms 0ms 19 700 21ms 0ms 20 718 22ms 0ms 21 688 20ms 0ms 22 720 21ms 0ms 23 718 21ms 0ms 00 708 21ms 0ms [ User: symmetricds - Total duration: 520ms - Times executed: 17144 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 520ms - Times executed: 17144 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-09-01 05:30:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:25:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,075 10s379ms 0ms 5ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 01 717 423ms 0ms 02 716 441ms 0ms 03 718 433ms 0ms 04 716 440ms 0ms 05 716 439ms 0ms 06 716 441ms 0ms 07 716 446ms 0ms 08 716 437ms 0ms 09 716 442ms 0ms 10 702 427ms 0ms 11 706 428ms 0ms 12 718 435ms 0ms 13 704 425ms 0ms 14 716 438ms 0ms 15 716 432ms 0ms 16 704 415ms 0ms 17 716 417ms 0ms 18 712 427ms 0ms 19 696 418ms 0ms 20 716 426ms 0ms 21 686 417ms 0ms 22 716 439ms 0ms 23 716 448ms 0ms 00 704 433ms 0ms [ User: symmetricds - Total duration: 10s379ms - Times executed: 17075 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s379ms - Times executed: 17075 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-01 01:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:09:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:08:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,062 167ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 01 383 6ms 0ms 02 377 6ms 0ms 03 383 7ms 0ms 04 378 6ms 0ms 05 383 7ms 0ms 06 377 6ms 0ms 07 382 7ms 0ms 08 378 6ms 0ms 09 380 7ms 0ms 10 373 6ms 0ms 11 375 6ms 0ms 12 381 6ms 0ms 13 374 6ms 0ms 14 380 7ms 0ms 15 380 6ms 0ms 16 374 7ms 0ms 17 380 6ms 0ms 18 378 6ms 0ms 19 370 6ms 0ms 20 380 6ms 0ms 21 363 6ms 0ms 22 380 7ms 0ms 23 380 7ms 0ms 00 373 6ms 0ms [ User: symmetricds - Total duration: 167ms - Times executed: 9062 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 167ms - Times executed: 9062 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2019-09-01 22:37:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:00:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:28:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,062 123ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 01 380 4ms 0ms 02 380 5ms 0ms 03 381 5ms 0ms 04 380 5ms 0ms 05 380 5ms 0ms 06 380 5ms 0ms 07 380 5ms 0ms 08 380 5ms 0ms 09 380 5ms 0ms 10 373 5ms 0ms 11 375 5ms 0ms 12 381 5ms 0ms 13 374 4ms 0ms 14 380 5ms 0ms 15 380 5ms 0ms 16 374 5ms 0ms 17 380 5ms 0ms 18 378 5ms 0ms 19 370 5ms 0ms 20 380 5ms 0ms 21 363 4ms 0ms 22 380 5ms 0ms 23 380 5ms 0ms 00 373 5ms 0ms [ User: symmetricds - Total duration: 123ms - Times executed: 9062 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 123ms - Times executed: 9062 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-09-01 09:00:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 17:57:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:01:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,537 330ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 01 358 13ms 0ms 02 358 13ms 0ms 03 359 13ms 0ms 04 358 13ms 0ms 05 358 13ms 0ms 06 358 13ms 0ms 07 358 13ms 0ms 08 358 13ms 0ms 09 358 14ms 0ms 10 351 13ms 0ms 11 353 13ms 0ms 12 359 13ms 0ms 13 352 13ms 0ms 14 358 13ms 0ms 15 358 14ms 0ms 16 352 13ms 0ms 17 358 14ms 0ms 18 356 14ms 0ms 19 348 13ms 0ms 20 358 14ms 0ms 21 343 13ms 0ms 22 358 14ms 0ms 23 358 13ms 0ms 00 352 13ms 0ms [ User: symmetricds - Total duration: 330ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 330ms - Times executed: 8537 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-09-01 21:30:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 21:49:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:56:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,537 304ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 01 358 12ms 0ms 02 358 11ms 0ms 03 359 11ms 0ms 04 358 11ms 0ms 05 358 13ms 0ms 06 358 13ms 0ms 07 358 13ms 0ms 08 358 13ms 0ms 09 358 13ms 0ms 10 351 13ms 0ms 11 353 13ms 0ms 12 359 13ms 0ms 13 352 13ms 0ms 14 358 13ms 0ms 15 358 12ms 0ms 16 352 12ms 0ms 17 358 12ms 0ms 18 356 12ms 0ms 19 348 12ms 0ms 20 358 12ms 0ms 21 343 12ms 0ms 22 358 12ms 0ms 23 358 12ms 0ms 00 352 12ms 0ms [ User: symmetricds - Total duration: 304ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 304ms - Times executed: 8537 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106200217' AND '156200216'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106200209' AND '156200208'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106200289' AND '156200288'));
Date: 2019-09-01 10:40:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 09:39:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 19:41:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,537 441ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 01 358 18ms 0ms 02 358 18ms 0ms 03 359 19ms 0ms 04 358 18ms 0ms 05 358 18ms 0ms 06 358 18ms 0ms 07 358 18ms 0ms 08 358 18ms 0ms 09 358 19ms 0ms 10 351 18ms 0ms 11 353 17ms 0ms 12 359 18ms 0ms 13 352 18ms 0ms 14 358 19ms 0ms 15 358 18ms 0ms 16 352 18ms 0ms 17 358 18ms 0ms 18 356 18ms 0ms 19 348 17ms 0ms 20 358 17ms 0ms 21 343 17ms 0ms 22 358 19ms 0ms 23 358 18ms 0ms 00 352 18ms 0ms [ User: symmetricds - Total duration: 441ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 441ms - Times executed: 8537 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-09-01 12:44:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:30:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:11:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,537 1s106ms 0ms 1ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 01 358 8ms 0ms 02 358 8ms 0ms 03 359 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 351 8ms 0ms 11 353 8ms 0ms 12 359 9ms 0ms 13 352 8ms 0ms 14 358 37ms 0ms 15 358 97ms 0ms 16 352 97ms 0ms 17 358 98ms 0ms 18 356 95ms 0ms 19 348 90ms 0ms 20 358 93ms 0ms 21 343 91ms 0ms 22 358 98ms 0ms 23 358 99ms 0ms 00 352 92ms 0ms [ User: symmetricds - Total duration: 1s106ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s106ms - Times executed: 8537 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200312' AND data_id <= '156200311' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200260' AND data_id <= '156200259' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200242' AND data_id <= '156200241' ORDER BY data_id ASC;
Date: 2019-09-01 21:52:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:56:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:50:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,906 279ms 0ms 0ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 01 247 11ms 0ms 02 240 11ms 0ms 03 237 11ms 0ms 04 239 11ms 0ms 05 240 11ms 0ms 06 236 11ms 0ms 07 239 11ms 0ms 08 240 11ms 0ms 09 240 11ms 0ms 10 229 10ms 0ms 11 239 11ms 0ms 12 237 11ms 0ms 13 238 11ms 0ms 14 233 11ms 0ms 15 274 12ms 0ms 16 276 13ms 0ms 17 274 13ms 0ms 18 261 12ms 0ms 19 248 11ms 0ms 20 287 13ms 0ms 21 240 11ms 0ms 22 240 11ms 0ms 23 236 11ms 0ms 00 236 11ms 0ms [ User: symmetricds - Total duration: 279ms - Times executed: 5906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 279ms - Times executed: 5906 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '3' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-09-01 16:23:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:12:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:01:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,906 699ms 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 01 247 28ms 0ms 02 240 29ms 0ms 03 237 28ms 0ms 04 239 29ms 0ms 05 240 28ms 0ms 06 236 28ms 0ms 07 239 28ms 0ms 08 240 28ms 0ms 09 240 28ms 0ms 10 229 26ms 0ms 11 239 28ms 0ms 12 237 28ms 0ms 13 238 28ms 0ms 14 233 28ms 0ms 15 274 31ms 0ms 16 276 32ms 0ms 17 274 33ms 0ms 18 261 29ms 0ms 19 248 28ms 0ms 20 287 33ms 0ms 21 240 28ms 0ms 22 240 28ms 0ms 23 236 27ms 0ms 00 236 28ms 0ms [ User: symmetricds - Total duration: 699ms - Times executed: 5906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 699ms - Times executed: 5906 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-09-01 16:04:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:37:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 19:09:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,385 823ms 0ms 12ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 01 184 16ms 0ms 02 184 17ms 0ms 03 184 20ms 0ms 04 184 50ms 0ms 05 184 39ms 0ms 06 184 19ms 0ms 07 184 16ms 0ms 08 184 25ms 0ms 09 184 19ms 0ms 10 178 65ms 0ms 11 184 37ms 0ms 12 184 33ms 0ms 13 181 33ms 0ms 14 181 34ms 0ms 15 184 26ms 0ms 16 181 30ms 0ms 17 184 28ms 0ms 18 184 30ms 0ms 19 178 31ms 0ms 20 184 29ms 0ms 21 177 30ms 0ms 22 184 33ms 0ms 23 184 31ms 0ms 00 181 122ms 0ms [ User: symmetricds - Total duration: 823ms - Times executed: 4385 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 823ms - Times executed: 4385 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-09-01 09:28:01 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:47:48 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:41:57 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,781 69ms 0ms 0ms 0ms SET application_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 01 116 3ms 0ms 02 73 2ms 0ms 03 74 2ms 0ms 04 81 3ms 0ms 05 80 3ms 0ms 06 76 2ms 0ms 07 75 2ms 0ms 08 81 3ms 0ms 09 81 3ms 0ms 10 80 3ms 0ms 11 80 3ms 0ms 12 81 3ms 0ms 13 75 2ms 0ms 14 81 3ms 0ms 15 56 2ms 0ms 16 52 2ms 0ms 17 51 2ms 0ms 18 61 2ms 0ms 19 65 2ms 0ms 20 53 2ms 0ms 21 67 2ms 0ms 22 83 3ms 0ms 23 79 3ms 0ms 00 80 3ms 0ms [ User: symmetricds - Total duration: 46ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 69ms - Times executed: 1781 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-09-01 18:27:41 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:04:47 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:22:30 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 13ms 50ms 35ms 290 10s193ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 01 12 429ms 35ms 02 12 423ms 35ms 03 12 427ms 35ms 04 12 366ms 30ms 05 12 374ms 31ms 06 12 430ms 35ms 07 13 471ms 36ms 08 12 444ms 37ms 09 12 432ms 36ms 10 12 432ms 36ms 11 12 445ms 37ms 12 12 420ms 35ms 13 12 427ms 35ms 14 12 418ms 34ms 15 12 392ms 32ms 16 12 428ms 35ms 17 12 416ms 34ms 18 12 432ms 36ms 19 13 459ms 35ms 20 12 429ms 35ms 21 12 436ms 36ms 22 12 380ms 31ms 23 12 431ms 35ms 00 12 438ms 36ms [ User: librenms - Total duration: 10s193ms - Times executed: 290 ]
[ Application: psql - Total duration: 10s193ms - Times executed: 290 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-09-01 03:30:11 Duration: 50ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-01 10:45:12 Duration: 44ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-01 23:30:11 Duration: 44ms Database: postgres User: librenms Remote: [local] Application: psql
2 0ms 9ms 7ms 95 706ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 01 4 23ms 5ms 02 4 29ms 7ms 03 4 30ms 7ms 04 4 30ms 7ms 05 4 29ms 7ms 06 4 30ms 7ms 07 4 30ms 7ms 08 4 30ms 7ms 09 4 29ms 7ms 10 4 30ms 7ms 11 4 30ms 7ms 12 4 30ms 7ms 13 4 31ms 7ms 14 4 29ms 7ms 15 4 29ms 7ms 16 4 32ms 8ms 17 4 29ms 7ms 18 4 31ms 7ms 19 4 27ms 6ms 20 4 27ms 6ms 21 4 30ms 7ms 22 4 30ms 7ms 23 4 34ms 8ms 00 3 15ms 5ms [ User: symmetricds - Total duration: 706ms - Times executed: 95 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 706ms - Times executed: 95 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '79827696', total_memory_bytes = '265289728', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 22:29:52', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '54264336', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 13:24:02', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '85052296', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-01 20:12:14', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-09-01 22:29:53 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:24:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:12:31 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4ms 12ms 6ms 139 935ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 01 93 552ms 5ms 02 2 13ms 6ms 03 2 14ms 7ms 04 2 13ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 18ms 9ms 10 2 17ms 8ms 11 2 18ms 9ms 12 2 18ms 9ms 13 2 18ms 9ms 14 2 18ms 9ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 18ms 9ms 18 2 18ms 9ms 19 2 18ms 9ms 20 2 18ms 9ms 21 2 18ms 9ms 22 2 13ms 6ms 23 2 18ms 9ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 736ms - Times executed: 94 ]
[ User: pharmisight - Total duration: 199ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 139 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-09-01 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 02:06:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:15:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 8ms 6ms 110 690ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 01 4 26ms 6ms 02 4 29ms 7ms 03 4 28ms 7ms 04 4 28ms 7ms 05 4 28ms 7ms 06 4 29ms 7ms 07 4 28ms 7ms 08 4 28ms 7ms 09 4 28ms 7ms 10 4 28ms 7ms 11 4 27ms 6ms 12 4 27ms 6ms 13 4 27ms 6ms 14 4 15ms 3ms 15 4 28ms 7ms 16 4 21ms 5ms 17 4 16ms 4ms 18 4 15ms 3ms 19 4 28ms 7ms 20 4 22ms 5ms 21 6 36ms 6ms 22 8 37ms 4ms 23 8 44ms 5ms 00 8 56ms 7ms [ User: symmetricds - Total duration: 690ms - Times executed: 110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 690ms - Times executed: 110 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '439080256', "total_memory_bytes" = '1199046656', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 22:25:34', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '594862560', "total_memory_bytes" = '1195900928', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 05:40:33', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '118350792', "total_memory_bytes" = '266862592', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-09-01 20:29:10', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-09-01 22:25:53 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:40:49 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:30:52 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 2ms 1ms 1,174 1s705ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 01 43 62ms 1ms 02 55 78ms 1ms 03 53 77ms 1ms 04 55 80ms 1ms 05 56 81ms 1ms 06 54 78ms 1ms 07 56 78ms 1ms 08 56 79ms 1ms 09 58 85ms 1ms 10 52 76ms 1ms 11 55 81ms 1ms 12 56 80ms 1ms 13 53 77ms 1ms 14 55 80ms 1ms 15 35 50ms 1ms 16 33 47ms 1ms 17 27 41ms 1ms 18 37 54ms 1ms 19 42 59ms 1ms 20 30 43ms 1ms 21 46 68ms 1ms 22 57 83ms 1ms 23 53 77ms 1ms 00 57 81ms 1ms [ User: symmetricds - Total duration: 1s705ms - Times executed: 1174 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s705ms - Times executed: 1174 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 21:42:24 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 16:42:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:27:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 10ms 1ms 1,419 1s477ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 01 56 57ms 1ms 02 65 65ms 1ms 03 65 67ms 1ms 04 64 62ms 0ms 05 66 67ms 1ms 06 66 68ms 1ms 07 65 70ms 1ms 08 67 68ms 1ms 09 70 74ms 1ms 10 65 79ms 1ms 11 65 67ms 1ms 12 66 68ms 1ms 13 63 66ms 1ms 14 66 73ms 1ms 15 42 41ms 0ms 16 38 37ms 0ms 17 32 32ms 1ms 18 42 42ms 1ms 19 51 51ms 1ms 20 38 38ms 1ms 21 56 56ms 1ms 22 73 75ms 1ms 23 70 71ms 1ms 00 68 71ms 1ms [ User: symmetricds - Total duration: 1s477ms - Times executed: 1419 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s477ms - Times executed: 1419 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 09:07:51 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:24:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:37:47 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 2ms 0ms 1,184 1s136ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 01 45 41ms 0ms 02 55 53ms 0ms 03 55 53ms 0ms 04 56 55ms 0ms 05 57 56ms 0ms 06 54 52ms 0ms 07 56 54ms 0ms 08 57 55ms 0ms 09 57 55ms 0ms 10 53 50ms 0ms 11 54 51ms 0ms 12 57 56ms 0ms 13 53 51ms 0ms 14 54 52ms 0ms 15 35 32ms 0ms 16 32 30ms 0ms 17 28 25ms 0ms 18 37 34ms 0ms 19 42 38ms 0ms 20 30 28ms 0ms 21 46 44ms 0ms 22 58 54ms 0ms 23 55 52ms 0ms 00 58 54ms 0ms [ User: symmetricds - Total duration: 1s136ms - Times executed: 1184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s136ms - Times executed: 1184 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 12:36:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:43:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 10:13:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 1,161 1s33ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 01 44 38ms 0ms 02 53 47ms 0ms 03 53 46ms 0ms 04 54 47ms 0ms 05 55 49ms 0ms 06 53 47ms 0ms 07 55 49ms 0ms 08 56 49ms 0ms 09 57 52ms 0ms 10 52 46ms 0ms 11 54 46ms 0ms 12 55 50ms 0ms 13 53 48ms 0ms 14 51 45ms 0ms 15 34 30ms 0ms 16 32 28ms 0ms 17 28 25ms 0ms 18 37 32ms 0ms 19 42 35ms 0ms 20 30 27ms 0ms 21 46 41ms 0ms 22 58 51ms 0ms 23 53 47ms 0ms 00 56 49ms 0ms [ User: symmetricds - Total duration: 1s33ms - Times executed: 1161 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s33ms - Times executed: 1161 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-01 00:39:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:24:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:11:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 5ms 0ms 17,075 10s379ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 01 01 717 423ms 0ms 02 716 441ms 0ms 03 718 433ms 0ms 04 716 440ms 0ms 05 716 439ms 0ms 06 716 441ms 0ms 07 716 446ms 0ms 08 716 437ms 0ms 09 716 442ms 0ms 10 702 427ms 0ms 11 706 428ms 0ms 12 718 435ms 0ms 13 704 425ms 0ms 14 716 438ms 0ms 15 716 432ms 0ms 16 704 415ms 0ms 17 716 417ms 0ms 18 712 427ms 0ms 19 696 418ms 0ms 20 716 426ms 0ms 21 686 417ms 0ms 22 716 439ms 0ms 23 716 448ms 0ms 00 704 433ms 0ms [ User: symmetricds - Total duration: 10s379ms - Times executed: 17075 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s379ms - Times executed: 17075 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-01 01:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:09:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:08:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 12ms 0ms 4,385 823ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 01 184 16ms 0ms 02 184 17ms 0ms 03 184 20ms 0ms 04 184 50ms 0ms 05 184 39ms 0ms 06 184 19ms 0ms 07 184 16ms 0ms 08 184 25ms 0ms 09 184 19ms 0ms 10 178 65ms 0ms 11 184 37ms 0ms 12 184 33ms 0ms 13 181 33ms 0ms 14 181 34ms 0ms 15 184 26ms 0ms 16 181 30ms 0ms 17 184 28ms 0ms 18 184 30ms 0ms 19 178 31ms 0ms 20 184 29ms 0ms 21 177 30ms 0ms 22 184 33ms 0ms 23 184 31ms 0ms 00 181 122ms 0ms [ User: symmetricds - Total duration: 823ms - Times executed: 4385 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 823ms - Times executed: 4385 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-09-01 09:28:01 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:47:48 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 23:41:57 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 8,537 1s106ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 01 358 8ms 0ms 02 358 8ms 0ms 03 359 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 351 8ms 0ms 11 353 8ms 0ms 12 359 9ms 0ms 13 352 8ms 0ms 14 358 37ms 0ms 15 358 97ms 0ms 16 352 97ms 0ms 17 358 98ms 0ms 18 356 95ms 0ms 19 348 90ms 0ms 20 358 93ms 0ms 21 343 91ms 0ms 22 358 98ms 0ms 23 358 99ms 0ms 00 352 92ms 0ms [ User: symmetricds - Total duration: 1s106ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s106ms - Times executed: 8537 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200312' AND data_id <= '156200311' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200260' AND data_id <= '156200259' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200242' AND data_id <= '156200241' ORDER BY data_id ASC;
Date: 2019-09-01 21:52:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:56:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:50:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 5,906 699ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 01 247 28ms 0ms 02 240 29ms 0ms 03 237 28ms 0ms 04 239 29ms 0ms 05 240 28ms 0ms 06 236 28ms 0ms 07 239 28ms 0ms 08 240 28ms 0ms 09 240 28ms 0ms 10 229 26ms 0ms 11 239 28ms 0ms 12 237 28ms 0ms 13 238 28ms 0ms 14 233 28ms 0ms 15 274 31ms 0ms 16 276 32ms 0ms 17 274 33ms 0ms 18 261 29ms 0ms 19 248 28ms 0ms 20 287 33ms 0ms 21 240 28ms 0ms 22 240 28ms 0ms 23 236 27ms 0ms 00 236 28ms 0ms [ User: symmetricds - Total duration: 699ms - Times executed: 5906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 699ms - Times executed: 5906 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-09-01 16:04:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 15:37:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 19:09:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 17,169 934ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 01 720 39ms 0ms 02 720 38ms 0ms 03 722 39ms 0ms 04 720 39ms 0ms 05 720 39ms 0ms 06 720 39ms 0ms 07 720 39ms 0ms 08 720 38ms 0ms 09 720 38ms 0ms 10 706 38ms 0ms 11 710 37ms 0ms 12 722 38ms 0ms 13 708 39ms 0ms 14 720 38ms 0ms 15 720 39ms 0ms 16 708 38ms 0ms 17 720 39ms 0ms 18 716 39ms 0ms 19 700 38ms 0ms 20 720 39ms 0ms 21 689 37ms 0ms 22 720 38ms 0ms 23 720 40ms 0ms 00 708 38ms 0ms [ User: symmetricds - Total duration: 934ms - Times executed: 17169 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 934ms - Times executed: 17169 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-09-01 22:56:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 12:59:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 04:16:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 4ms 0ms 24,779 1s325ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 01 1,112 57ms 0ms 02 1,036 56ms 0ms 03 1,038 54ms 0ms 04 1,036 54ms 0ms 05 1,036 55ms 0ms 06 1,036 59ms 0ms 07 1,036 54ms 0ms 08 1,036 57ms 0ms 09 1,036 58ms 0ms 10 1,012 52ms 0ms 11 1,026 59ms 0ms 12 1,038 56ms 0ms 13 1,019 54ms 0ms 14 1,031 54ms 0ms 15 1,036 53ms 0ms 16 1,019 53ms 0ms 17 1,036 55ms 0ms 18 1,032 56ms 0ms 19 1,006 53ms 0ms 20 1,036 54ms 0ms 21 995 53ms 0ms 22 1,036 54ms 0ms 23 1,036 53ms 0ms 00 1,019 53ms 0ms [ User: symmetricds - Total duration: 1s325ms - Times executed: 24779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s325ms - Times executed: 24779 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-09-01 10:57:54 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 05:23:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 07:51:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 8,537 441ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 01 358 18ms 0ms 02 358 18ms 0ms 03 359 19ms 0ms 04 358 18ms 0ms 05 358 18ms 0ms 06 358 18ms 0ms 07 358 18ms 0ms 08 358 18ms 0ms 09 358 19ms 0ms 10 351 18ms 0ms 11 353 17ms 0ms 12 359 18ms 0ms 13 352 18ms 0ms 14 358 19ms 0ms 15 358 18ms 0ms 16 352 18ms 0ms 17 358 18ms 0ms 18 356 18ms 0ms 19 348 17ms 0ms 20 358 17ms 0ms 21 343 17ms 0ms 22 358 19ms 0ms 23 358 18ms 0ms 00 352 18ms 0ms [ User: symmetricds - Total duration: 441ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 441ms - Times executed: 8537 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-09-01 12:44:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:30:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 13:11:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 27,480 1s346ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 01 916 26ms 0ms 02 916 39ms 0ms 03 916 38ms 0ms 04 916 48ms 0ms 05 916 53ms 0ms 06 916 47ms 0ms 07 916 51ms 0ms 08 916 51ms 0ms 09 916 49ms 0ms 10 916 51ms 0ms 11 916 50ms 0ms 12 1,832 76ms 0ms 13 916 51ms 0ms 14 916 53ms 0ms 15 916 55ms 0ms 16 916 51ms 0ms 17 1,832 76ms 0ms 18 1,832 76ms 0ms 19 916 50ms 0ms 20 1,832 80ms 0ms 21 1,832 79ms 0ms 22 1,832 80ms 0ms 23 916 54ms 0ms 00 916 51ms 0ms [ User: pharmisight - Total duration: 1s346ms - Times executed: 27480 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s346ms - Times executed: 27480 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969174' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '43' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3356' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-01 14:40:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 2ms 0ms 30,960 1s504ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 01 1,032 29ms 0ms 02 1,032 42ms 0ms 03 1,032 43ms 0ms 04 1,032 53ms 0ms 05 1,032 59ms 0ms 06 1,032 52ms 0ms 07 1,032 57ms 0ms 08 1,032 57ms 0ms 09 1,032 55ms 0ms 10 1,032 57ms 0ms 11 1,032 57ms 0ms 12 2,064 85ms 0ms 13 1,032 57ms 0ms 14 1,032 62ms 0ms 15 1,032 63ms 0ms 16 1,032 57ms 0ms 17 2,064 85ms 0ms 18 2,064 85ms 0ms 19 1,032 56ms 0ms 20 2,064 89ms 0ms 21 2,064 88ms 0ms 22 2,064 90ms 0ms 23 1,032 59ms 0ms 00 1,032 57ms 0ms [ User: pharmisight - Total duration: 1s504ms - Times executed: 30960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s504ms - Times executed: 30960 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33074336' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969174' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-01 13:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:40:02 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 5,906 279ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 01 247 11ms 0ms 02 240 11ms 0ms 03 237 11ms 0ms 04 239 11ms 0ms 05 240 11ms 0ms 06 236 11ms 0ms 07 239 11ms 0ms 08 240 11ms 0ms 09 240 11ms 0ms 10 229 10ms 0ms 11 239 11ms 0ms 12 237 11ms 0ms 13 238 11ms 0ms 14 233 11ms 0ms 15 274 12ms 0ms 16 276 13ms 0ms 17 274 13ms 0ms 18 261 12ms 0ms 19 248 11ms 0ms 20 287 13ms 0ms 21 240 11ms 0ms 22 240 11ms 0ms 23 236 11ms 0ms 00 236 11ms 0ms [ User: symmetricds - Total duration: 279ms - Times executed: 5906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 279ms - Times executed: 5906 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '3' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-09-01 16:23:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:12:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 06:01:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 1,781 69ms SET application_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 01 116 3ms 0ms 02 73 2ms 0ms 03 74 2ms 0ms 04 81 3ms 0ms 05 80 3ms 0ms 06 76 2ms 0ms 07 75 2ms 0ms 08 81 3ms 0ms 09 81 3ms 0ms 10 80 3ms 0ms 11 80 3ms 0ms 12 81 3ms 0ms 13 75 2ms 0ms 14 81 3ms 0ms 15 56 2ms 0ms 16 52 2ms 0ms 17 51 2ms 0ms 18 61 2ms 0ms 19 65 2ms 0ms 20 53 2ms 0ms 21 67 2ms 0ms 22 83 3ms 0ms 23 79 3ms 0ms 00 80 3ms 0ms [ User: symmetricds - Total duration: 46ms - Times executed: 1230 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 69ms - Times executed: 1781 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-09-01 18:27:41 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 14:04:47 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 11:22:30 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,537 330ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 01 358 13ms 0ms 02 358 13ms 0ms 03 359 13ms 0ms 04 358 13ms 0ms 05 358 13ms 0ms 06 358 13ms 0ms 07 358 13ms 0ms 08 358 13ms 0ms 09 358 14ms 0ms 10 351 13ms 0ms 11 353 13ms 0ms 12 359 13ms 0ms 13 352 13ms 0ms 14 358 13ms 0ms 15 358 14ms 0ms 16 352 13ms 0ms 17 358 14ms 0ms 18 356 14ms 0ms 19 348 13ms 0ms 20 358 14ms 0ms 21 343 13ms 0ms 22 358 14ms 0ms 23 358 13ms 0ms 00 352 13ms 0ms [ User: symmetricds - Total duration: 330ms - Times executed: 8537 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 330ms - Times executed: 8537 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-09-01 21:30:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 21:49:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-01 20:56:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,154,002 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 01 04 1 - FATAL: no pg_hba.conf entry for host "104.248.197.181", user "postgres", database "postgres", SSL on
Date: 2019-09-01 03:33:36 Database: postgres Application: [unknown] User: postgres Remote: 104.248.197.181 Code:
2 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 01 04 1 - FATAL: no pg_hba.conf entry for host "104.248.197.181", user "postgres", database "postgres", SSL off
Date: 2019-09-01 03:33:36 Database: postgres Application: [unknown] User: postgres Remote: 104.248.197.181 Code: