pgBadger-
Global information
- Generated on Mon Aug 26 00:00:25 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,329,882 log entries in 23s
- Log start from 2019-08-25 00:00:00 to 2019-08-25 23:59:59
-
Overview
Global Stats
- 171 Number of unique normalized queries
- 1,126,712 Number of queries
- 1m1s Total query duration
- 2019-08-25 00:00:00 First query
- 2019-08-25 23:59:59 Last query
- 1,975 queries/s at 2019-08-25 05:20:00 Query peak
- 2 Number of events
- 1 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 42 Total number of automatic vacuums
- 76 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,042 Total number of sessions
- 3 sessions at 2019-08-25 10:31:46 Session peak
- 8d4h33m58s Total duration of sessions
- 5m46s Average duration of sessions
- 551 Average queries per session
- 29ms Average queries duration per session
- 2,044 Total number of connections
- 9 connections/s at 2019-08-25 00:30:21 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1,975 queries/s Query Peak
- 2019-08-25 05:20:00 Date
SELECT Traffic
Key values
- 1,959 queries/s Query Peak
- 2019-08-25 05:20:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 103 queries/s Query Peak
- 2019-08-25 00:19:56 Date
Queries duration
Key values
- 1m1s Total query duration
Prepared queries ratio
Key values
- 1.65 Ratio of bind vs prepare
- 164.94 % 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) Aug 25 00 55,453 0ms 36ms 0ms 100ms 172ms 1s15ms 01 46,160 0ms 39ms 0ms 80ms 93ms 210ms 02 46,226 0ms 42ms 0ms 78ms 105ms 227ms 03 46,209 0ms 40ms 0ms 79ms 101ms 230ms 04 46,220 0ms 40ms 0ms 83ms 101ms 230ms 05 46,205 0ms 41ms 0ms 79ms 96ms 246ms 06 46,535 0ms 40ms 0ms 74ms 102ms 243ms 07 46,593 0ms 37ms 0ms 77ms 98ms 229ms 08 46,534 0ms 38ms 0ms 75ms 92ms 246ms 09 46,574 0ms 42ms 0ms 76ms 98ms 210ms 10 46,599 0ms 39ms 0ms 74ms 96ms 227ms 11 46,629 0ms 123ms 0ms 83ms 153ms 202ms 12 46,706 0ms 43ms 0ms 74ms 104ms 221ms 13 46,608 0ms 104ms 0ms 75ms 192ms 252ms 14 46,637 0ms 37ms 0ms 76ms 94ms 208ms 15 46,674 0ms 39ms 0ms 76ms 87ms 225ms 16 46,713 0ms 48ms 0ms 85ms 108ms 224ms 17 46,637 0ms 38ms 0ms 63ms 111ms 229ms 18 46,668 0ms 36ms 0ms 62ms 122ms 231ms 19 46,614 0ms 42ms 0ms 69ms 114ms 231ms 20 47,598 0ms 37ms 0ms 81ms 122ms 602ms 21 46,676 0ms 38ms 0ms 80ms 103ms 214ms 22 46,540 0ms 37ms 0ms 80ms 97ms 212ms 23 46,704 0ms 38ms 0ms 77ms 103ms 179ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 22,123 0 0ms 55ms 70ms 531ms 01 16,595 0 0ms 44ms 62ms 155ms 02 16,603 0 0ms 49ms 59ms 152ms 03 16,613 0 0ms 50ms 60ms 150ms 04 16,600 0 0ms 47ms 62ms 186ms 05 16,616 0 0ms 42ms 60ms 131ms 06 16,607 0 0ms 51ms 57ms 191ms 07 16,617 0 0ms 43ms 57ms 184ms 08 16,595 0 0ms 42ms 56ms 199ms 09 16,618 0 0ms 37ms 56ms 183ms 10 16,617 0 0ms 46ms 56ms 188ms 11 16,621 0 0ms 50ms 56ms 181ms 12 16,648 0 0ms 52ms 57ms 179ms 13 16,629 0 0ms 45ms 56ms 175ms 14 16,619 0 0ms 42ms 57ms 178ms 15 16,624 0 0ms 48ms 57ms 178ms 16 16,645 0 0ms 51ms 56ms 168ms 17 16,619 0 0ms 50ms 55ms 182ms 18 16,650 0 0ms 37ms 54ms 172ms 19 16,640 0 0ms 40ms 61ms 169ms 20 17,512 0 0ms 48ms 58ms 183ms 21 16,635 0 0ms 50ms 57ms 170ms 22 16,607 0 0ms 44ms 56ms 139ms 23 16,645 0 0ms 43ms 55ms 150ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 322 1,052 83 0 0ms 9ms 11ms 16ms 01 88 54 79 0 0ms 1ms 7ms 8ms 02 88 54 81 0 0ms 1ms 7ms 8ms 03 88 53 81 0 0ms 0ms 7ms 7ms 04 88 54 81 0 0ms 1ms 7ms 8ms 05 88 53 82 0 0ms 1ms 7ms 8ms 06 88 54 80 0 0ms 0ms 7ms 8ms 07 88 54 82 0 0ms 1ms 7ms 8ms 08 88 53 80 0 0ms 1ms 6ms 8ms 09 88 54 82 0 0ms 0ms 4ms 8ms 10 88 53 80 0 0ms 0ms 5ms 8ms 11 88 54 81 0 0ms 1ms 6ms 8ms 12 88 54 81 0 0ms 1ms 7ms 8ms 13 88 53 81 0 0ms 1ms 6ms 8ms 14 88 54 82 0 0ms 1ms 5ms 8ms 15 88 53 81 0 0ms 1ms 2ms 8ms 16 88 54 80 0 0ms 0ms 2ms 9ms 17 88 54 82 0 0ms 0ms 2ms 12ms 18 88 53 82 0 0ms 0ms 4ms 15ms 19 88 68 79 0 0ms 0ms 3ms 9ms 20 120 90 120 0 0ms 1ms 2ms 9ms 21 88 54 79 0 0ms 1ms 5ms 8ms 22 88 54 81 0 0ms 1ms 3ms 8ms 23 88 53 82 0 0ms 1ms 4ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 25 00 31,916 55,391 1.74 87.50% 01 29,242 46,100 1.58 104.95% 02 28,989 46,166 1.59 103.99% 03 29,041 46,149 1.59 104.14% 04 29,150 46,160 1.58 104.56% 05 29,246 46,145 1.58 104.88% 06 28,285 46,473 1.64 101.01% 07 27,650 46,533 1.68 98.54% 08 27,775 46,474 1.67 99.09% 09 27,922 46,514 1.67 99.54% 10 27,811 46,539 1.67 99.11% 11 27,948 46,569 1.67 99.62% 12 27,976 46,644 1.67 99.48% 13 27,960 46,548 1.66 99.58% 14 27,862 46,577 1.67 99.26% 15 27,861 46,614 1.67 99.18% 16 27,885 46,653 1.67 99.15% 17 27,827 46,577 1.67 99.11% 18 28,155 46,606 1.66 100.17% 19 27,979 46,554 1.66 99.59% 20 27,767 47,538 1.71 95.53% 21 27,966 46,616 1.67 99.49% 22 28,007 46,480 1.66 99.88% 23 27,935 46,644 1.67 99.34% Day Hour Count Average / Second Aug 25 00 115 0.03/s 01 97 0.03/s 02 108 0.03/s 03 103 0.03/s 04 103 0.03/s 05 100 0.03/s 06 106 0.03/s 07 74 0.02/s 08 72 0.02/s 09 77 0.02/s 10 76 0.02/s 11 94 0.03/s 12 78 0.02/s 13 73 0.02/s 14 80 0.02/s 15 81 0.02/s 16 79 0.02/s 17 76 0.02/s 18 81 0.02/s 19 75 0.02/s 20 78 0.02/s 21 75 0.02/s 22 71 0.02/s 23 72 0.02/s Day Hour Count Average Duration Aug 25 00 112 5m12s 01 98 4m45s 02 105 4m57s 03 103 4m40s 04 106 5m 05 97 4m13s 06 103 6m21s 07 80 6m35s 08 72 5m49s 09 76 6m41s 10 77 6m39s 11 88 6m12s 12 85 5m59s 13 72 5m57s 14 77 5m45s 15 84 6m35s 16 76 5m28s 17 79 7m27s 18 75 6m13s 19 79 5m47s 20 80 5m26s 21 76 6m49s 22 71 5m20s 23 71 6m7s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2019-08-25 00:30:21 Date
Connections per database
Key values
- pharmisight Main Database
- 2,044 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,044 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-08-25 10:31:46 Date
Histogram of session times
Key values
- 872 0-500ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,042 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,042 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,042 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 608 buffers Checkpoint Peak
- 2019-08-25 01:05:04 Date
- 61.011 seconds Highest write time
- 0.125 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-08-25 11:09:15 Date
Checkpoints distance
Key values
- 3.13 Mo Distance Peak
- 2019-08-25 01:05:04 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 25 00 1,441 144.632s 0.016s 144.72s 01 930 93.338s 0.017s 93.441s 02 481 48.311s 0.138s 48.522s 03 513 51.507s 0.016s 51.593s 04 555 55.836s 0.023s 55.937s 05 545 54.715s 0.025s 54.811s 06 400 40.162s 0.016s 40.248s 07 602 60.323s 0.022s 60.413s 08 527 52.9s 0.021s 52.991s 09 424 42.652s 0.015s 42.748s 10 585 58.734s 0.02s 58.824s 11 430 43.177s 0.025s 43.337s 12 464 46.484s 0.019s 46.594s 13 549 55.107s 0.032s 55.209s 14 417 41.865s 0.023s 41.96s 15 372 37.344s 0.012s 37.438s 16 490 49.186s 0.012s 49.267s 17 387 38.853s 0.015s 38.934s 18 371 37.236s 0.015s 37.45s 19 609 61.023s 0.018s 61.135s 20 409 41.062s 0.027s 41.158s 21 391 39.278s 0.025s 39.384s 22 514 51.591s 0.143s 51.798s 23 376 37.741s 0.012s 37.819s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 25 00 0 0 0 286 0.002s 0s 01 0 0 1 268 0.002s 0s 02 0 0 0 256 0.125s 0.005s 03 0 0 0 257 0.002s 0s 04 0 0 0 253 0.005s 0s 05 0 0 0 249 0.008s 0s 06 0 0 0 235 0.003s 0s 07 0 0 0 261 0.003s 0s 08 0 0 0 249 0.004s 0s 09 0 0 0 236 0.005s 0s 10 0 0 0 252 0.003s 0s 11 0 0 1 227 0.008s 0s 12 0 0 0 237 0.003s 0s 13 0 0 0 248 0.016s 0.003s 14 0 0 0 241 0.011s 0s 15 0 0 0 234 0.002s 0s 16 0 0 0 247 0.002s 0s 17 0 0 0 222 0.003s 0s 18 0 0 0 216 0.002s 0s 19 0 0 0 250 0.002s 0s 20 0 0 0 235 0.008s 0s 21 0 0 1 220 0.008s 0s 22 0 0 0 229 0.123s 0.006s 23 0 0 0 210 0.002s 0s Day Hour Count Avg time (sec) Aug 25 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 Aug 25 00 684.75 kB 1,000.50 kB 01 223.00 kB 999.42 kB 02 127.58 kB 373.08 kB 03 110.67 kB 258.08 kB 04 155.50 kB 559.33 kB 05 153.58 kB 308.75 kB 06 110.91 kB 207.27 kB 07 172.42 kB 612.33 kB 08 163.92 kB 429.25 kB 09 119.00 kB 223.08 kB 10 191.92 kB 704.75 kB 11 126.00 kB 315.58 kB 12 119.33 kB 362.58 kB 13 158.17 kB 581.92 kB 14 115.08 kB 285.92 kB 15 97.33 kB 200.75 kB 16 141.42 kB 516.25 kB 17 113.92 kB 274.17 kB 18 121.25 kB 209.67 kB 19 187.75 kB 631.33 kB 20 144.17 kB 348.25 kB 21 105.67 kB 223.00 kB 22 156.64 kB 505.64 kB 23 110.67 kB 265.42 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 Aug 25 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 (16) Main table analyzed (database pharmisight)
- 76 analyzes Total
Table Number of analyzes pharmisight.public.sym_data_event 16 pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_data 10 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 3 pharmisight.public.sym_sequence 1 pharmisight.public.flow_report_summary_delays 1 Total 76 Vacuums per table
Key values
- public.sym_outgoing_batch (8) Main table vacuumed on database pharmisight
- 42 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_data_event 7 7 pharmisight.public.sym_data 7 7 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 3 3 Total 42 37 Tuples removed per table
Key values
- public.sym_data_event (3176) Main table with removed tuples on database pharmisight
- 7942 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 7 7 3176 1201 pharmisight.public.sym_data 7 7 1121 3757 pharmisight.public.sym_outgoing_batch 8 8 1069 313 pharmisight.pg_catalog.pg_statistic 3 3 1058 0 pharmisight.public.sym_incoming_batch 6 6 952 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 Total 42 37 7,942 5,271 Pages removed per table
Key values
- public.sym_data (3757) Main table with removed pages on database pharmisight
- 5271 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 7 7 1121 3757 pharmisight.public.sym_data_event 7 7 3176 1201 pharmisight.public.sym_outgoing_batch 8 8 1069 313 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_incoming_batch 6 6 952 0 pharmisight.pg_catalog.pg_statistic 3 3 1058 0 Total 42 37 7,942 5,271 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 25 00 2 5 01 5 5 02 1 4 03 3 2 04 1 4 05 2 4 06 1 1 07 3 5 08 2 3 09 0 3 10 5 4 11 1 3 12 2 2 13 2 5 14 1 2 15 0 1 16 2 4 17 0 1 18 0 3 19 5 3 20 1 4 21 1 0 22 1 7 23 1 1 - 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
- 405,298 Total read queries
- 276,923 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,126,128 Requests
- 50s822ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,068,075 Requests
User Request type Count Duration librenms Total 608 10s733ms SELECT 608 10s733ms pharmisight Total 101,455 7s149ms DELETE 38 3ms INSERT 38 2ms OTHERS 1,059 53ms SELECT 99,756 7s62ms TCL 510 20ms UPDATE 54 7ms symmetricds Total 1,068,075 45s187ms DELETE 2,012 700ms INSERT 2,428 902ms OTHERS 461,845 7s717ms SELECT 318,591 27s319ms TCL 280,863 6s82ms UPDATE 2,336 2s465ms tony Total 900 290ms SELECT 900 290ms Duration by user
Key values
- 45s187ms (symmetricds) Main time consuming user
User Request type Count Duration librenms Total 608 10s733ms SELECT 608 10s733ms pharmisight Total 101,455 7s149ms DELETE 38 3ms INSERT 38 2ms OTHERS 1,059 53ms SELECT 99,756 7s62ms TCL 510 20ms UPDATE 54 7ms symmetricds Total 1,068,075 45s187ms DELETE 2,012 700ms INSERT 2,428 902ms OTHERS 461,845 7s717ms SELECT 318,591 27s319ms TCL 280,863 6s82ms UPDATE 2,336 2s465ms tony Total 900 290ms SELECT 900 290ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,169,530 Requests
- 52s337ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,124,092 Requests
- 50s488ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-25 09:53:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,123,317 0-1ms duration
Slowest individual queries
Rank Duration Query 1 123ms COMMIT;[ Date: 2019-08-25 11:49:59 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 104ms COMMIT;[ Date: 2019-08-25 13:05:43 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 62ms COMMIT;[ Date: 2019-08-25 13:05:43 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 48ms COMMIT;[ Date: 2019-08-25 16:26:09 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
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-08-25 12:30:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
6 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-08-25 09:50:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
7 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-08-25 19:55: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-08-25 02:50:10 - 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-08-25 05: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-08-25 12:35: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-08-25 09:35:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
12 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-08-25 04:55:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
13 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-08-25 03:30:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
14 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-08-25 06:50:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
15 39ms 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-08-25 04:50:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
16 39ms 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-08-25 05:55:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
17 39ms 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-08-25 15:55:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
18 39ms 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-08-25 01:20:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
19 39ms 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-08-25 16:35:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
20 39ms 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-08-25 03:55:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10s137ms 292 22ms 43ms 34ms 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 Aug 25 01 13 429ms 33ms 02 12 423ms 35ms 03 12 417ms 34ms 04 12 439ms 36ms 05 12 412ms 34ms 06 12 412ms 34ms 07 13 467ms 35ms 08 12 412ms 34ms 09 12 414ms 34ms 10 12 410ms 34ms 11 12 405ms 33ms 12 12 425ms 35ms 13 13 477ms 36ms 14 12 413ms 34ms 15 12 419ms 34ms 16 12 422ms 35ms 17 12 429ms 35ms 18 12 413ms 34ms 19 13 416ms 32ms 20 12 420ms 35ms 21 12 409ms 34ms 22 12 425ms 35ms 23 12 420ms 35ms 00 12 397ms 33ms [ User: librenms - Total duration: 10s137ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s137ms - Times executed: 292 ]
-
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-08-25 12:30:10 Duration: 43ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-25 09:50:11 Duration: 42ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-25 19:55:10 Duration: 42ms Database: postgres User: librenms Remote: [local] Application: psql
2 9s948ms 17,201 0ms 10ms 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 #2
Day Hour Count Duration Avg duration Aug 25 01 719 414ms 0ms 02 716 417ms 0ms 03 716 428ms 0ms 04 716 429ms 0ms 05 718 416ms 0ms 06 716 431ms 0ms 07 716 405ms 0ms 08 718 420ms 0ms 09 716 409ms 0ms 10 716 409ms 0ms 11 718 400ms 0ms 12 716 412ms 0ms 13 716 411ms 0ms 14 718 414ms 0ms 15 716 412ms 0ms 16 716 408ms 0ms 17 718 418ms 0ms 18 716 413ms 0ms 19 716 402ms 0ms 20 718 409ms 0ms 21 716 416ms 0ms 22 716 420ms 0ms 23 716 415ms 0ms 00 718 408ms 0ms [ User: symmetricds - Total duration: 9s948ms - Times executed: 17201 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s948ms - Times executed: 17201 ]
-
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-08-25 14:01:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:28:33 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:39:37 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 7s70ms 423,890 0ms 10ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 01 18,061 294ms 0ms 02 17,418 284ms 0ms 03 17,444 294ms 0ms 04 17,430 287ms 0ms 05 17,445 287ms 0ms 06 17,431 287ms 0ms 07 17,637 287ms 0ms 08 17,694 296ms 0ms 09 17,674 292ms 0ms 10 17,680 298ms 0ms 11 17,695 291ms 0ms 12 17,697 302ms 0ms 13 17,743 297ms 0ms 14 17,696 294ms 0ms 15 17,715 294ms 0ms 16 17,734 293ms 0ms 17 17,745 319ms 0ms 18 17,718 293ms 0ms 19 17,716 294ms 0ms 20 17,682 298ms 0ms 21 17,685 300ms 0ms 22 17,733 291ms 0ms 23 17,670 295ms 0ms 00 17,747 293ms 0ms [ User: symmetricds - Total duration: 7s50ms - Times executed: 423559 ]
[ User: pharmisight - Total duration: 20ms - Times executed: 331 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s70ms - Times executed: 423890 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-25 16:46:43 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:46:30 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:46:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4s989ms 135,112 0ms 123ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 01 6,446 544ms 0ms 02 5,523 173ms 0ms 03 5,525 173ms 0ms 04 5,526 180ms 0ms 05 5,528 174ms 0ms 06 5,523 176ms 0ms 07 5,587 172ms 0ms 08 5,609 179ms 0ms 09 5,607 173ms 0ms 10 5,605 179ms 0ms 11 5,612 172ms 0ms 12 5,606 296ms 0ms 13 5,625 184ms 0ms 14 5,614 358ms 0ms 15 5,614 176ms 0ms 16 5,622 184ms 0ms 17 5,628 242ms 0ms 18 5,617 173ms 0ms 19 5,617 171ms 0ms 20 5,609 174ms 0ms 21 5,612 189ms 0ms 22 5,626 185ms 0ms 23 5,605 173ms 0ms 00 5,626 176ms 0ms [ User: symmetricds - Total duration: 4s970ms - Times executed: 134864 ]
[ User: pharmisight - Total duration: 18ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s989ms - Times executed: 135112 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-25 11:49:59 Duration: 123ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:05:43 Duration: 104ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:05:43 Duration: 62ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 2s644ms 50,568 0ms 1ms 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 Aug 25 01 3,096 124ms 0ms 02 2,064 86ms 0ms 03 2,064 99ms 0ms 04 2,064 93ms 0ms 05 2,064 115ms 0ms 06 2,064 85ms 0ms 07 2,064 112ms 0ms 08 2,064 116ms 0ms 09 2,064 115ms 0ms 10 2,064 114ms 0ms 11 2,064 115ms 0ms 12 2,064 112ms 0ms 13 2,064 119ms 0ms 14 2,064 113ms 0ms 15 2,064 113ms 0ms 16 2,064 116ms 0ms 17 2,064 114ms 0ms 18 2,064 121ms 0ms 19 2,064 117ms 0ms 20 2,064 116ms 0ms 21 2,064 101ms 0ms 22 2,064 116ms 0ms 23 2,064 102ms 0ms 00 2,064 98ms 0ms [ User: pharmisight - Total duration: 2s644ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s644ms - Times executed: 50568 ]
-
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 = '32965583' 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 = '33074301' 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 = '32964834' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-25 12:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 2s372ms 44,884 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 Aug 25 01 2,748 111ms 0ms 02 1,832 78ms 0ms 03 1,832 87ms 0ms 04 1,832 84ms 0ms 05 1,832 103ms 0ms 06 1,832 76ms 0ms 07 1,832 101ms 0ms 08 1,832 104ms 0ms 09 1,832 103ms 0ms 10 1,832 102ms 0ms 11 1,832 103ms 0ms 12 1,832 100ms 0ms 13 1,832 104ms 0ms 14 1,832 102ms 0ms 15 1,832 101ms 0ms 16 1,832 106ms 0ms 17 1,832 103ms 0ms 18 1,832 107ms 0ms 19 1,832 104ms 0ms 20 1,832 106ms 0ms 21 1,832 91ms 0ms 22 1,832 103ms 0ms 23 1,832 92ms 0ms 00 1,832 88ms 0ms [ User: pharmisight - Total duration: 2s372ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s372ms - Times executed: 44884 ]
-
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 = '165' 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 = '2912' 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 = '3552' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-25 15:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s890ms 154,896 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 01 7,576 84ms 0ms 02 6,332 74ms 0ms 03 6,337 73ms 0ms 04 6,334 74ms 0ms 05 6,339 75ms 0ms 06 6,340 77ms 0ms 07 6,394 74ms 0ms 08 6,427 78ms 0ms 09 6,414 76ms 0ms 10 6,420 83ms 0ms 11 6,418 75ms 0ms 12 6,419 77ms 0ms 13 6,439 82ms 0ms 14 6,426 78ms 0ms 15 6,428 84ms 0ms 16 6,432 77ms 0ms 17 6,440 76ms 0ms 18 6,428 78ms 0ms 19 6,430 79ms 0ms 20 6,414 82ms 0ms 21 6,417 86ms 0ms 22 6,434 76ms 0ms 23 6,412 83ms 0ms 00 6,446 78ms 0ms [ User: symmetricds - Total duration: 1s890ms - Times executed: 154896 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 154896 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-25 14:52:43 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 19:32:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:47:12 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s406ms 25,142 0ms 7ms 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 #8
Day Hour Count Duration Avg duration Aug 25 01 1,118 62ms 0ms 02 1,044 60ms 0ms 03 1,044 54ms 0ms 04 1,044 56ms 0ms 05 1,046 57ms 0ms 06 1,044 60ms 0ms 07 1,044 54ms 0ms 08 1,046 63ms 0ms 09 1,044 56ms 0ms 10 1,044 59ms 0ms 11 1,046 63ms 0ms 12 1,044 59ms 0ms 13 1,044 61ms 0ms 14 1,046 56ms 0ms 15 1,044 58ms 0ms 16 1,044 55ms 0ms 17 1,046 54ms 0ms 18 1,044 56ms 0ms 19 1,044 54ms 0ms 20 1,046 60ms 0ms 21 1,042 69ms 0ms 22 1,044 54ms 0ms 23 1,044 62ms 0ms 00 1,046 54ms 0ms [ User: symmetricds - Total duration: 1s406ms - Times executed: 25142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s406ms - Times executed: 25142 ]
-
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-08-25 07:14:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:23:07 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:02:15 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s183ms 191 0ms 18ms 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 #9
Day Hour Count Duration Avg duration Aug 25 01 8 43ms 5ms 02 8 55ms 6ms 03 8 57ms 7ms 04 8 50ms 6ms 05 8 53ms 6ms 06 8 47ms 5ms 07 8 51ms 6ms 08 8 53ms 6ms 09 8 51ms 6ms 10 8 48ms 6ms 11 8 42ms 5ms 12 8 49ms 6ms 13 8 61ms 7ms 14 8 58ms 7ms 15 8 48ms 6ms 16 8 45ms 5ms 17 8 47ms 5ms 18 8 47ms 5ms 19 8 55ms 6ms 20 8 52ms 6ms 21 7 27ms 3ms 22 8 42ms 5ms 23 8 45ms 5ms 00 8 47ms 5ms [ User: symmetricds - Total duration: 1s183ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s183ms - Times executed: 191 ]
-
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" = '17552904', "total_memory_bytes" = '265289728', "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-08-25 12:48:50', "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';
-
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" = '56618824', "total_memory_bytes" = '265289728', "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-08-25 22:53:50', "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';
-
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" = '72507592', "total_memory_bytes" = '265289728', "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-08-25 20:53:50', "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-08-25 12:49:59 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:55:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:55:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s183ms 823 0ms 6ms 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 #10
Day Hour Count Duration Avg duration Aug 25 01 47 70ms 1ms 02 53 72ms 1ms 03 54 76ms 1ms 04 56 80ms 1ms 05 55 80ms 1ms 06 57 86ms 1ms 07 35 51ms 1ms 08 28 39ms 1ms 09 27 39ms 1ms 10 29 41ms 1ms 11 28 40ms 1ms 12 28 39ms 1ms 13 27 38ms 1ms 14 28 39ms 1ms 15 26 36ms 1ms 16 26 36ms 1ms 17 28 40ms 1ms 18 27 38ms 1ms 19 28 39ms 1ms 20 27 39ms 1ms 21 27 38ms 1ms 22 26 35ms 1ms 23 29 41ms 1ms 00 27 39ms 1ms [ User: symmetricds - Total duration: 1s183ms - Times executed: 823 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s183ms - Times executed: 823 ]
-
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-08-25 05:39:39 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:15:20 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:05:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s30ms 1,072 0ms 5ms 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 ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 25 01 60 56ms 0ms 02 70 72ms 1ms 03 67 63ms 0ms 04 71 70ms 0ms 05 68 62ms 0ms 06 67 66ms 0ms 07 47 46ms 0ms 08 37 37ms 1ms 09 36 34ms 0ms 10 41 37ms 0ms 11 38 35ms 0ms 12 35 33ms 0ms 13 36 34ms 0ms 14 39 37ms 0ms 15 33 30ms 0ms 16 31 30ms 0ms 17 40 39ms 0ms 18 35 33ms 0ms 19 37 35ms 0ms 20 36 34ms 0ms 21 37 34ms 0ms 22 36 33ms 0ms 23 37 34ms 0ms 00 38 35ms 0ms [ User: symmetricds - Total duration: 1s30ms - Times executed: 1072 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s30ms - Times executed: 1072 ]
-
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-08-25 01:15:21 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:51:23 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 05:37:22 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s28ms 148 4ms 13ms 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 #12
Day Hour Count Duration Avg duration Aug 25 01 102 720ms 7ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 9ms 4ms 05 2 13ms 6ms 06 2 17ms 8ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 716ms - Times executed: 103 ]
[ User: pharmisight - Total duration: 312ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s28ms - Times executed: 148 ]
-
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 = '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_trigger_router' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-25 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:30:15 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 988ms 17,296 0ms 7ms 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 #13
Day Hour Count Duration Avg duration Aug 25 01 722 38ms 0ms 02 720 38ms 0ms 03 720 39ms 0ms 04 720 39ms 0ms 05 722 42ms 0ms 06 720 47ms 0ms 07 720 39ms 0ms 08 722 40ms 0ms 09 720 43ms 0ms 10 720 44ms 0ms 11 722 40ms 0ms 12 720 39ms 0ms 13 720 40ms 0ms 14 722 40ms 0ms 15 720 41ms 0ms 16 720 39ms 0ms 17 722 40ms 0ms 18 720 39ms 0ms 19 720 43ms 0ms 20 722 43ms 0ms 21 720 39ms 0ms 22 720 41ms 0ms 23 720 44ms 0ms 00 722 39ms 0ms [ User: symmetricds - Total duration: 988ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 988ms - Times executed: 17296 ]
-
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 = '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 = '0';
Date: 2019-08-25 05:16:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 09:14:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:02:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 900ms 135,114 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 01 6,447 42ms 0ms 02 5,523 35ms 0ms 03 5,525 36ms 0ms 04 5,526 35ms 0ms 05 5,528 35ms 0ms 06 5,523 38ms 0ms 07 5,587 36ms 0ms 08 5,609 38ms 0ms 09 5,607 36ms 0ms 10 5,605 38ms 0ms 11 5,612 36ms 0ms 12 5,606 37ms 0ms 13 5,625 37ms 0ms 14 5,614 37ms 0ms 15 5,614 37ms 0ms 16 5,622 37ms 0ms 17 5,628 38ms 0ms 18 5,617 38ms 0ms 19 5,617 37ms 0ms 20 5,609 38ms 0ms 21 5,612 38ms 0ms 22 5,626 36ms 0ms 23 5,605 37ms 0ms 00 5,627 37ms 0ms [ User: symmetricds - Total duration: 898ms - Times executed: 134865 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 900ms - Times executed: 135114 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-25 05:49:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:42:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:17:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 741ms 791 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 ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 01 44 43ms 0ms 02 49 46ms 0ms 03 50 48ms 0ms 04 51 49ms 0ms 05 47 44ms 0ms 06 51 48ms 0ms 07 33 30ms 0ms 08 28 25ms 0ms 09 26 23ms 0ms 10 29 26ms 0ms 11 28 25ms 0ms 12 28 25ms 0ms 13 27 24ms 0ms 14 28 26ms 0ms 15 26 23ms 0ms 16 26 24ms 0ms 17 28 25ms 0ms 18 27 26ms 0ms 19 28 26ms 0ms 20 27 24ms 0ms 21 27 24ms 0ms 22 27 24ms 0ms 23 29 26ms 0ms 00 27 23ms 0ms [ User: symmetricds - Total duration: 741ms - Times executed: 791 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 741ms - Times executed: 791 ]
-
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-08-25 17:03:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:11:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:59:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 733ms 6,474 0ms 4ms 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 #16
Day Hour Count Duration Avg duration Aug 25 01 247 29ms 0ms 02 237 27ms 0ms 03 240 29ms 0ms 04 239 29ms 0ms 05 235 27ms 0ms 06 240 28ms 0ms 07 270 29ms 0ms 08 274 30ms 0ms 09 279 30ms 0ms 10 277 30ms 0ms 11 275 30ms 0ms 12 276 30ms 0ms 13 288 35ms 0ms 14 277 30ms 0ms 15 281 30ms 0ms 16 286 30ms 0ms 17 282 31ms 0ms 18 282 31ms 0ms 19 283 30ms 0ms 20 274 31ms 0ms 21 282 31ms 0ms 22 288 31ms 0ms 23 279 31ms 0ms 00 283 32ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6474 ]
-
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-08-25 12:02:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:11:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:11:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 723ms 49 6ms 24ms 14ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 01 3 44ms 14ms 02 2 27ms 13ms 03 2 31ms 15ms 04 2 35ms 17ms 05 2 28ms 14ms 06 2 22ms 11ms 07 2 31ms 15ms 08 2 27ms 13ms 09 2 33ms 16ms 10 2 30ms 15ms 11 2 30ms 15ms 12 2 37ms 18ms 13 2 31ms 15ms 14 2 28ms 14ms 15 2 27ms 13ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 29ms 14ms 19 2 30ms 15ms 20 2 31ms 15ms 21 2 33ms 16ms 22 2 29ms 14ms 23 2 20ms 10ms 00 2 21ms 10ms [ User: pharmisight - Total duration: 723ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 723ms - Times executed: 49 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-08-25 00:00:00 Duration: 24ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:00:00 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 03:00:00 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 685ms 780 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 ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 25 01 43 38ms 0ms 02 48 40ms 0ms 03 46 41ms 0ms 04 49 42ms 0ms 05 45 39ms 0ms 06 51 43ms 0ms 07 33 28ms 0ms 08 27 23ms 0ms 09 26 23ms 0ms 10 29 24ms 0ms 11 28 23ms 0ms 12 28 24ms 0ms 13 27 23ms 0ms 14 28 25ms 0ms 15 26 22ms 0ms 16 26 22ms 0ms 17 28 24ms 0ms 18 27 23ms 0ms 19 28 24ms 0ms 20 27 25ms 0ms 21 27 23ms 0ms 22 27 23ms 0ms 23 29 25ms 0ms 00 27 22ms 0ms [ User: symmetricds - Total duration: 685ms - Times executed: 780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 685ms - Times executed: 780 ]
-
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-08-25 19:31:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 04:35:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:21:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 603ms 148 1ms 9ms 4ms 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 ?, ? 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 ?, ? 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 #19
Day Hour Count Duration Avg duration Aug 25 01 5 18ms 3ms 02 4 16ms 4ms 03 4 14ms 3ms 04 5 20ms 4ms 05 6 23ms 3ms 06 6 27ms 4ms 07 7 30ms 4ms 08 5 10ms 2ms 09 7 28ms 4ms 10 6 22ms 3ms 11 7 30ms 4ms 12 7 35ms 5ms 13 8 28ms 3ms 14 7 28ms 4ms 15 7 29ms 4ms 16 6 24ms 4ms 17 7 30ms 4ms 18 6 26ms 4ms 19 7 28ms 4ms 20 7 30ms 4ms 21 5 19ms 3ms 22 5 22ms 4ms 23 7 28ms 4ms 00 7 29ms 4ms [ User: symmetricds - Total duration: 603ms - Times executed: 148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 603ms - Times executed: 148 ]
-
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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-25 11:36:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 08:36:24 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:21:34 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 540ms 17,264 0ms 4ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 01 720 19ms 0ms 02 720 20ms 0ms 03 718 20ms 0ms 04 720 20ms 0ms 05 720 20ms 0ms 06 718 19ms 0ms 07 720 20ms 0ms 08 720 21ms 0ms 09 718 29ms 0ms 10 720 21ms 0ms 11 720 24ms 0ms 12 720 26ms 0ms 13 718 21ms 0ms 14 718 25ms 0ms 15 720 21ms 0ms 16 718 21ms 0ms 17 720 25ms 0ms 18 720 23ms 0ms 19 720 25ms 0ms 20 718 21ms 0ms 21 720 22ms 0ms 22 720 21ms 0ms 23 718 22ms 0ms 00 720 21ms 0ms [ User: symmetricds - Total duration: 540ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 540ms - Times executed: 17264 ]
-
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-08-25 11:16:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:22:58 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:36:44 Duration: 3ms 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 423,890 7s70ms 0ms 10ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 01 18,061 294ms 0ms 02 17,418 284ms 0ms 03 17,444 294ms 0ms 04 17,430 287ms 0ms 05 17,445 287ms 0ms 06 17,431 287ms 0ms 07 17,637 287ms 0ms 08 17,694 296ms 0ms 09 17,674 292ms 0ms 10 17,680 298ms 0ms 11 17,695 291ms 0ms 12 17,697 302ms 0ms 13 17,743 297ms 0ms 14 17,696 294ms 0ms 15 17,715 294ms 0ms 16 17,734 293ms 0ms 17 17,745 319ms 0ms 18 17,718 293ms 0ms 19 17,716 294ms 0ms 20 17,682 298ms 0ms 21 17,685 300ms 0ms 22 17,733 291ms 0ms 23 17,670 295ms 0ms 00 17,747 293ms 0ms [ User: symmetricds - Total duration: 7s50ms - Times executed: 423559 ]
[ User: pharmisight - Total duration: 20ms - Times executed: 331 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s70ms - Times executed: 423890 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-25 16:46:43 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:46:30 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:46:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 154,896 1s890ms 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 01 7,576 84ms 0ms 02 6,332 74ms 0ms 03 6,337 73ms 0ms 04 6,334 74ms 0ms 05 6,339 75ms 0ms 06 6,340 77ms 0ms 07 6,394 74ms 0ms 08 6,427 78ms 0ms 09 6,414 76ms 0ms 10 6,420 83ms 0ms 11 6,418 75ms 0ms 12 6,419 77ms 0ms 13 6,439 82ms 0ms 14 6,426 78ms 0ms 15 6,428 84ms 0ms 16 6,432 77ms 0ms 17 6,440 76ms 0ms 18 6,428 78ms 0ms 19 6,430 79ms 0ms 20 6,414 82ms 0ms 21 6,417 86ms 0ms 22 6,434 76ms 0ms 23 6,412 83ms 0ms 00 6,446 78ms 0ms [ User: symmetricds - Total duration: 1s890ms - Times executed: 154896 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 154896 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-25 14:52:43 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 19:32:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:47:12 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 135,114 900ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 01 6,447 42ms 0ms 02 5,523 35ms 0ms 03 5,525 36ms 0ms 04 5,526 35ms 0ms 05 5,528 35ms 0ms 06 5,523 38ms 0ms 07 5,587 36ms 0ms 08 5,609 38ms 0ms 09 5,607 36ms 0ms 10 5,605 38ms 0ms 11 5,612 36ms 0ms 12 5,606 37ms 0ms 13 5,625 37ms 0ms 14 5,614 37ms 0ms 15 5,614 37ms 0ms 16 5,622 37ms 0ms 17 5,628 38ms 0ms 18 5,617 38ms 0ms 19 5,617 37ms 0ms 20 5,609 38ms 0ms 21 5,612 38ms 0ms 22 5,626 36ms 0ms 23 5,605 37ms 0ms 00 5,627 37ms 0ms [ User: symmetricds - Total duration: 898ms - Times executed: 134865 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 900ms - Times executed: 135114 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-25 05:49:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:42:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:17:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 135,112 4s989ms 0ms 123ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 01 6,446 544ms 0ms 02 5,523 173ms 0ms 03 5,525 173ms 0ms 04 5,526 180ms 0ms 05 5,528 174ms 0ms 06 5,523 176ms 0ms 07 5,587 172ms 0ms 08 5,609 179ms 0ms 09 5,607 173ms 0ms 10 5,605 179ms 0ms 11 5,612 172ms 0ms 12 5,606 296ms 0ms 13 5,625 184ms 0ms 14 5,614 358ms 0ms 15 5,614 176ms 0ms 16 5,622 184ms 0ms 17 5,628 242ms 0ms 18 5,617 173ms 0ms 19 5,617 171ms 0ms 20 5,609 174ms 0ms 21 5,612 189ms 0ms 22 5,626 185ms 0ms 23 5,605 173ms 0ms 00 5,626 176ms 0ms [ User: symmetricds - Total duration: 4s970ms - Times executed: 134864 ]
[ User: pharmisight - Total duration: 18ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s989ms - Times executed: 135112 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-25 11:49:59 Duration: 123ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:05:43 Duration: 104ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:05:43 Duration: 62ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 50,568 2s644ms 0ms 1ms 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 Aug 25 01 3,096 124ms 0ms 02 2,064 86ms 0ms 03 2,064 99ms 0ms 04 2,064 93ms 0ms 05 2,064 115ms 0ms 06 2,064 85ms 0ms 07 2,064 112ms 0ms 08 2,064 116ms 0ms 09 2,064 115ms 0ms 10 2,064 114ms 0ms 11 2,064 115ms 0ms 12 2,064 112ms 0ms 13 2,064 119ms 0ms 14 2,064 113ms 0ms 15 2,064 113ms 0ms 16 2,064 116ms 0ms 17 2,064 114ms 0ms 18 2,064 121ms 0ms 19 2,064 117ms 0ms 20 2,064 116ms 0ms 21 2,064 101ms 0ms 22 2,064 116ms 0ms 23 2,064 102ms 0ms 00 2,064 98ms 0ms [ User: pharmisight - Total duration: 2s644ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s644ms - Times executed: 50568 ]
-
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 = '32965583' 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 = '33074301' 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 = '32964834' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-25 12:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 44,884 2s372ms 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 Aug 25 01 2,748 111ms 0ms 02 1,832 78ms 0ms 03 1,832 87ms 0ms 04 1,832 84ms 0ms 05 1,832 103ms 0ms 06 1,832 76ms 0ms 07 1,832 101ms 0ms 08 1,832 104ms 0ms 09 1,832 103ms 0ms 10 1,832 102ms 0ms 11 1,832 103ms 0ms 12 1,832 100ms 0ms 13 1,832 104ms 0ms 14 1,832 102ms 0ms 15 1,832 101ms 0ms 16 1,832 106ms 0ms 17 1,832 103ms 0ms 18 1,832 107ms 0ms 19 1,832 104ms 0ms 20 1,832 106ms 0ms 21 1,832 91ms 0ms 22 1,832 103ms 0ms 23 1,832 92ms 0ms 00 1,832 88ms 0ms [ User: pharmisight - Total duration: 2s372ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s372ms - Times executed: 44884 ]
-
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 = '165' 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 = '2912' 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 = '3552' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-25 15:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,142 1s406ms 0ms 7ms 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 Aug 25 01 1,118 62ms 0ms 02 1,044 60ms 0ms 03 1,044 54ms 0ms 04 1,044 56ms 0ms 05 1,046 57ms 0ms 06 1,044 60ms 0ms 07 1,044 54ms 0ms 08 1,046 63ms 0ms 09 1,044 56ms 0ms 10 1,044 59ms 0ms 11 1,046 63ms 0ms 12 1,044 59ms 0ms 13 1,044 61ms 0ms 14 1,046 56ms 0ms 15 1,044 58ms 0ms 16 1,044 55ms 0ms 17 1,046 54ms 0ms 18 1,044 56ms 0ms 19 1,044 54ms 0ms 20 1,046 60ms 0ms 21 1,042 69ms 0ms 22 1,044 54ms 0ms 23 1,044 62ms 0ms 00 1,046 54ms 0ms [ User: symmetricds - Total duration: 1s406ms - Times executed: 25142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s406ms - Times executed: 25142 ]
-
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-08-25 07:14:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:23:07 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:02:15 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,296 988ms 0ms 7ms 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 Aug 25 01 722 38ms 0ms 02 720 38ms 0ms 03 720 39ms 0ms 04 720 39ms 0ms 05 722 42ms 0ms 06 720 47ms 0ms 07 720 39ms 0ms 08 722 40ms 0ms 09 720 43ms 0ms 10 720 44ms 0ms 11 722 40ms 0ms 12 720 39ms 0ms 13 720 40ms 0ms 14 722 40ms 0ms 15 720 41ms 0ms 16 720 39ms 0ms 17 722 40ms 0ms 18 720 39ms 0ms 19 720 43ms 0ms 20 722 43ms 0ms 21 720 39ms 0ms 22 720 41ms 0ms 23 720 44ms 0ms 00 722 39ms 0ms [ User: symmetricds - Total duration: 988ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 988ms - Times executed: 17296 ]
-
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 = '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 = '0';
Date: 2019-08-25 05:16:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 09:14:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:02:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,264 540ms 0ms 4ms 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 Aug 25 01 720 19ms 0ms 02 720 20ms 0ms 03 718 20ms 0ms 04 720 20ms 0ms 05 720 20ms 0ms 06 718 19ms 0ms 07 720 20ms 0ms 08 720 21ms 0ms 09 718 29ms 0ms 10 720 21ms 0ms 11 720 24ms 0ms 12 720 26ms 0ms 13 718 21ms 0ms 14 718 25ms 0ms 15 720 21ms 0ms 16 718 21ms 0ms 17 720 25ms 0ms 18 720 23ms 0ms 19 720 25ms 0ms 20 718 21ms 0ms 21 720 22ms 0ms 22 720 21ms 0ms 23 718 22ms 0ms 00 720 21ms 0ms [ User: symmetricds - Total duration: 540ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 540ms - Times executed: 17264 ]
-
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-08-25 11:16:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:22:58 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 13:36:44 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,201 9s948ms 0ms 10ms 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 Aug 25 01 719 414ms 0ms 02 716 417ms 0ms 03 716 428ms 0ms 04 716 429ms 0ms 05 718 416ms 0ms 06 716 431ms 0ms 07 716 405ms 0ms 08 718 420ms 0ms 09 716 409ms 0ms 10 716 409ms 0ms 11 718 400ms 0ms 12 716 412ms 0ms 13 716 411ms 0ms 14 718 414ms 0ms 15 716 412ms 0ms 16 716 408ms 0ms 17 718 418ms 0ms 18 716 413ms 0ms 19 716 402ms 0ms 20 718 409ms 0ms 21 716 416ms 0ms 22 716 420ms 0ms 23 716 415ms 0ms 00 718 408ms 0ms [ User: symmetricds - Total duration: 9s948ms - Times executed: 17201 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s948ms - Times executed: 17201 ]
-
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-08-25 14:01:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:28:33 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:39:37 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,130 168ms 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 25 01 383 6ms 0ms 02 378 6ms 0ms 03 382 6ms 0ms 04 378 6ms 0ms 05 381 7ms 0ms 06 381 7ms 0ms 07 379 6ms 0ms 08 383 6ms 0ms 09 378 6ms 0ms 10 380 6ms 0ms 11 381 7ms 0ms 12 380 6ms 0ms 13 382 6ms 0ms 14 379 6ms 0ms 15 383 6ms 0ms 16 380 7ms 0ms 17 378 6ms 0ms 18 382 7ms 0ms 19 379 7ms 0ms 20 380 6ms 0ms 21 383 6ms 0ms 22 377 8ms 0ms 23 380 6ms 0ms 00 383 7ms 0ms [ User: symmetricds - Total duration: 168ms - Times executed: 9130 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 168ms - Times executed: 9130 ]
-
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-08-25 21:39:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 05:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,127 122ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 01 381 5ms 0ms 02 380 5ms 0ms 03 380 5ms 0ms 04 380 5ms 0ms 05 381 5ms 0ms 06 380 5ms 0ms 07 380 5ms 0ms 08 381 5ms 0ms 09 380 5ms 0ms 10 380 5ms 0ms 11 381 5ms 0ms 12 380 5ms 0ms 13 380 5ms 0ms 14 380 4ms 0ms 15 380 5ms 0ms 16 380 5ms 0ms 17 381 4ms 0ms 18 380 4ms 0ms 19 380 5ms 0ms 20 381 5ms 0ms 21 380 5ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms 00 381 5ms 0ms [ User: symmetricds - Total duration: 122ms - Times executed: 9127 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 122ms - Times executed: 9127 ]
-
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-08-25 18:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 14:59:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,600 348ms 0ms 3ms 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 Aug 25 01 359 13ms 0ms 02 358 12ms 0ms 03 358 13ms 0ms 04 358 13ms 0ms 05 359 13ms 0ms 06 358 16ms 0ms 07 358 13ms 0ms 08 359 14ms 0ms 09 358 13ms 0ms 10 358 14ms 0ms 11 359 14ms 0ms 12 358 18ms 0ms 13 358 14ms 0ms 14 359 14ms 0ms 15 358 13ms 0ms 16 358 14ms 0ms 17 359 18ms 0ms 18 358 14ms 0ms 19 358 13ms 0ms 20 359 14ms 0ms 21 358 14ms 0ms 22 358 14ms 0ms 23 358 14ms 0ms 00 359 14ms 0ms [ User: symmetricds - Total duration: 348ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 348ms - Times executed: 8600 ]
-
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-08-25 16:22:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:38:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 05:16:22 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,600 432ms 0ms 2ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 01 359 17ms 0ms 02 358 17ms 0ms 03 358 18ms 0ms 04 358 17ms 0ms 05 359 17ms 0ms 06 358 18ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 18ms 0ms 11 359 17ms 0ms 12 358 17ms 0ms 13 358 18ms 0ms 14 359 18ms 0ms 15 358 18ms 0ms 16 358 17ms 0ms 17 359 20ms 0ms 18 358 18ms 0ms 19 358 18ms 0ms 20 359 17ms 0ms 21 358 17ms 0ms 22 358 17ms 0ms 23 358 18ms 0ms 00 359 17ms 0ms [ User: symmetricds - Total duration: 432ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 432ms - Times executed: 8600 ]
-
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-08-25 16:01:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:53:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:42:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,600 304ms 0ms 3ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 01 359 10ms 0ms 02 358 10ms 0ms 03 358 13ms 0ms 04 358 11ms 0ms 05 359 13ms 0ms 06 358 11ms 0ms 07 358 13ms 0ms 08 359 17ms 0ms 09 358 13ms 0ms 10 358 13ms 0ms 11 359 13ms 0ms 12 358 13ms 0ms 13 358 12ms 0ms 14 359 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 359 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 359 12ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 358 12ms 0ms 00 359 12ms 0ms [ User: symmetricds - Total duration: 304ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 304ms - Times executed: 8600 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105905597' AND '155905596'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105905549' AND '155905548'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105905780' AND '155905779'));
Date: 2019-08-25 07:14:56 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 03:14:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:37:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,600 217ms 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 Aug 25 01 359 8ms 0ms 02 358 9ms 0ms 03 358 8ms 0ms 04 358 8ms 0ms 05 359 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 359 9ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 359 9ms 0ms 12 358 8ms 0ms 13 358 9ms 0ms 14 359 9ms 0ms 15 358 9ms 0ms 16 358 9ms 0ms 17 359 9ms 0ms 18 358 9ms 0ms 19 358 8ms 0ms 20 359 9ms 0ms 21 358 10ms 0ms 22 358 9ms 0ms 23 358 9ms 0ms 00 359 9ms 0ms [ User: symmetricds - Total duration: 217ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 217ms - Times executed: 8600 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105905753' AND data_id <= '155905752' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105905525' AND data_id <= '155905524' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105905723' AND data_id <= '155905722' ORDER BY data_id ASC;
Date: 2019-08-25 20:14:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 01:11:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:43:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,474 733ms 0ms 4ms 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 #17
Day Hour Count Duration Avg duration Aug 25 01 247 29ms 0ms 02 237 27ms 0ms 03 240 29ms 0ms 04 239 29ms 0ms 05 235 27ms 0ms 06 240 28ms 0ms 07 270 29ms 0ms 08 274 30ms 0ms 09 279 30ms 0ms 10 277 30ms 0ms 11 275 30ms 0ms 12 276 30ms 0ms 13 288 35ms 0ms 14 277 30ms 0ms 15 281 30ms 0ms 16 286 30ms 0ms 17 282 31ms 0ms 18 282 31ms 0ms 19 283 30ms 0ms 20 274 31ms 0ms 21 282 31ms 0ms 22 288 31ms 0ms 23 279 31ms 0ms 00 283 32ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6474 ]
-
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-08-25 12:02:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:11:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:11:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,474 338ms 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 #18
Day Hour Count Duration Avg duration Aug 25 01 247 13ms 0ms 02 237 13ms 0ms 03 240 13ms 0ms 04 239 13ms 0ms 05 235 13ms 0ms 06 240 14ms 0ms 07 270 13ms 0ms 08 274 14ms 0ms 09 279 13ms 0ms 10 277 13ms 0ms 11 275 14ms 0ms 12 276 13ms 0ms 13 288 14ms 0ms 14 277 14ms 0ms 15 281 14ms 0ms 16 286 14ms 0ms 17 282 14ms 0ms 18 282 14ms 0ms 19 283 14ms 0ms 20 274 14ms 0ms 21 282 14ms 0ms 22 288 14ms 0ms 23 279 14ms 0ms 00 283 14ms 0ms [ User: symmetricds - Total duration: 338ms - Times executed: 6474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 338ms - Times executed: 6474 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' 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;
-
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-08-25 00:17:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:46:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 14:22:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,416 504ms 0ms 5ms 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 Aug 25 01 184 16ms 0ms 02 184 16ms 0ms 03 184 18ms 0ms 04 184 17ms 0ms 05 184 19ms 0ms 06 184 19ms 0ms 07 184 18ms 0ms 08 184 17ms 0ms 09 184 30ms 0ms 10 184 50ms 0ms 11 184 20ms 0ms 12 184 30ms 0ms 13 184 47ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 16ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 17ms 0ms 20 184 17ms 0ms 21 184 16ms 0ms 22 184 14ms 0ms 23 184 15ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 504ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 504ms - Times executed: 4416 ]
-
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 = '1' 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;
-
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-08-25 12:29:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:50:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 08:36:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,084 106ms 0ms 0ms 0ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 01 984 24ms 0ms 02 48 4ms 0ms 03 48 4ms 0ms 04 48 3ms 0ms 05 48 4ms 0ms 06 48 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 3ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 4ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 2ms 0ms 17 48 3ms 0ms 18 48 2ms 0ms 19 48 3ms 0ms 20 48 3ms 0ms 21 44 2ms 0ms 22 48 2ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 106ms - Times executed: 2084 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 106ms - Times executed: 2084 ]
-
SELECT set_config('symmetric.node_disabled', '', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-08-25 12:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:55:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:10:59 Duration: 0ms Database: pharmisight User: symmetricds 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 22ms 43ms 34ms 292 10s137ms 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 Aug 25 01 13 429ms 33ms 02 12 423ms 35ms 03 12 417ms 34ms 04 12 439ms 36ms 05 12 412ms 34ms 06 12 412ms 34ms 07 13 467ms 35ms 08 12 412ms 34ms 09 12 414ms 34ms 10 12 410ms 34ms 11 12 405ms 33ms 12 12 425ms 35ms 13 13 477ms 36ms 14 12 413ms 34ms 15 12 419ms 34ms 16 12 422ms 35ms 17 12 429ms 35ms 18 12 413ms 34ms 19 13 416ms 32ms 20 12 420ms 35ms 21 12 409ms 34ms 22 12 425ms 35ms 23 12 420ms 35ms 00 12 397ms 33ms [ User: librenms - Total duration: 10s137ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s137ms - Times executed: 292 ]
-
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-08-25 12:30:10 Duration: 43ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-25 09:50:11 Duration: 42ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-25 19:55:10 Duration: 42ms Database: postgres User: librenms Remote: [local] Application: psql
2 6ms 24ms 14ms 49 723ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 01 3 44ms 14ms 02 2 27ms 13ms 03 2 31ms 15ms 04 2 35ms 17ms 05 2 28ms 14ms 06 2 22ms 11ms 07 2 31ms 15ms 08 2 27ms 13ms 09 2 33ms 16ms 10 2 30ms 15ms 11 2 30ms 15ms 12 2 37ms 18ms 13 2 31ms 15ms 14 2 28ms 14ms 15 2 27ms 13ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 29ms 14ms 19 2 30ms 15ms 20 2 31ms 15ms 21 2 33ms 16ms 22 2 29ms 14ms 23 2 20ms 10ms 00 2 21ms 10ms [ User: pharmisight - Total duration: 723ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 723ms - Times executed: 49 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-08-25 00:00:00 Duration: 24ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:00:00 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 03:00:00 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4ms 13ms 6ms 148 1s28ms 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 Aug 25 01 102 720ms 7ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 9ms 4ms 05 2 13ms 6ms 06 2 17ms 8ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 716ms - Times executed: 103 ]
[ User: pharmisight - Total duration: 312ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s28ms - Times executed: 148 ]
-
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 = '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_trigger_router' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-25 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:30:15 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 18ms 6ms 191 1s183ms 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 Aug 25 01 8 43ms 5ms 02 8 55ms 6ms 03 8 57ms 7ms 04 8 50ms 6ms 05 8 53ms 6ms 06 8 47ms 5ms 07 8 51ms 6ms 08 8 53ms 6ms 09 8 51ms 6ms 10 8 48ms 6ms 11 8 42ms 5ms 12 8 49ms 6ms 13 8 61ms 7ms 14 8 58ms 7ms 15 8 48ms 6ms 16 8 45ms 5ms 17 8 47ms 5ms 18 8 47ms 5ms 19 8 55ms 6ms 20 8 52ms 6ms 21 7 27ms 3ms 22 8 42ms 5ms 23 8 45ms 5ms 00 8 47ms 5ms [ User: symmetricds - Total duration: 1s183ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s183ms - Times executed: 191 ]
-
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" = '17552904', "total_memory_bytes" = '265289728', "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-08-25 12:48:50', "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';
-
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" = '56618824', "total_memory_bytes" = '265289728', "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-08-25 22:53:50', "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';
-
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" = '72507592', "total_memory_bytes" = '265289728', "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-08-25 20:53:50', "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-08-25 12:49:59 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:55:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:55:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 9ms 4ms 148 603ms 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 ?, ? 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 ?, ? 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 Aug 25 01 5 18ms 3ms 02 4 16ms 4ms 03 4 14ms 3ms 04 5 20ms 4ms 05 6 23ms 3ms 06 6 27ms 4ms 07 7 30ms 4ms 08 5 10ms 2ms 09 7 28ms 4ms 10 6 22ms 3ms 11 7 30ms 4ms 12 7 35ms 5ms 13 8 28ms 3ms 14 7 28ms 4ms 15 7 29ms 4ms 16 6 24ms 4ms 17 7 30ms 4ms 18 6 26ms 4ms 19 7 28ms 4ms 20 7 30ms 4ms 21 5 19ms 3ms 22 5 22ms 4ms 23 7 28ms 4ms 00 7 29ms 4ms [ User: symmetricds - Total duration: 603ms - Times executed: 148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 603ms - Times executed: 148 ]
-
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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-25 11:36:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 08:36:24 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:21:34 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 6ms 1ms 823 1s183ms 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 Aug 25 01 47 70ms 1ms 02 53 72ms 1ms 03 54 76ms 1ms 04 56 80ms 1ms 05 55 80ms 1ms 06 57 86ms 1ms 07 35 51ms 1ms 08 28 39ms 1ms 09 27 39ms 1ms 10 29 41ms 1ms 11 28 40ms 1ms 12 28 39ms 1ms 13 27 38ms 1ms 14 28 39ms 1ms 15 26 36ms 1ms 16 26 36ms 1ms 17 28 40ms 1ms 18 27 38ms 1ms 19 28 39ms 1ms 20 27 39ms 1ms 21 27 38ms 1ms 22 26 35ms 1ms 23 29 41ms 1ms 00 27 39ms 1ms [ User: symmetricds - Total duration: 1s183ms - Times executed: 823 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s183ms - Times executed: 823 ]
-
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-08-25 05:39:39 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:15:20 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:05:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 5ms 0ms 1,072 1s30ms 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 #7
Day Hour Count Duration Avg duration Aug 25 01 60 56ms 0ms 02 70 72ms 1ms 03 67 63ms 0ms 04 71 70ms 0ms 05 68 62ms 0ms 06 67 66ms 0ms 07 47 46ms 0ms 08 37 37ms 1ms 09 36 34ms 0ms 10 41 37ms 0ms 11 38 35ms 0ms 12 35 33ms 0ms 13 36 34ms 0ms 14 39 37ms 0ms 15 33 30ms 0ms 16 31 30ms 0ms 17 40 39ms 0ms 18 35 33ms 0ms 19 37 35ms 0ms 20 36 34ms 0ms 21 37 34ms 0ms 22 36 33ms 0ms 23 37 34ms 0ms 00 38 35ms 0ms [ User: symmetricds - Total duration: 1s30ms - Times executed: 1072 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s30ms - Times executed: 1072 ]
-
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-08-25 01:15:21 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:51:23 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 05:37:22 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 791 741ms 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 #8
Day Hour Count Duration Avg duration Aug 25 01 44 43ms 0ms 02 49 46ms 0ms 03 50 48ms 0ms 04 51 49ms 0ms 05 47 44ms 0ms 06 51 48ms 0ms 07 33 30ms 0ms 08 28 25ms 0ms 09 26 23ms 0ms 10 29 26ms 0ms 11 28 25ms 0ms 12 28 25ms 0ms 13 27 24ms 0ms 14 28 26ms 0ms 15 26 23ms 0ms 16 26 24ms 0ms 17 28 25ms 0ms 18 27 26ms 0ms 19 28 26ms 0ms 20 27 24ms 0ms 21 27 24ms 0ms 22 27 24ms 0ms 23 29 26ms 0ms 00 27 23ms 0ms [ User: symmetricds - Total duration: 741ms - Times executed: 791 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 741ms - Times executed: 791 ]
-
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-08-25 17:03:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:11:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 17:59:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 2ms 0ms 780 685ms 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 #9
Day Hour Count Duration Avg duration Aug 25 01 43 38ms 0ms 02 48 40ms 0ms 03 46 41ms 0ms 04 49 42ms 0ms 05 45 39ms 0ms 06 51 43ms 0ms 07 33 28ms 0ms 08 27 23ms 0ms 09 26 23ms 0ms 10 29 24ms 0ms 11 28 23ms 0ms 12 28 24ms 0ms 13 27 23ms 0ms 14 28 25ms 0ms 15 26 22ms 0ms 16 26 22ms 0ms 17 28 24ms 0ms 18 27 23ms 0ms 19 28 24ms 0ms 20 27 25ms 0ms 21 27 23ms 0ms 22 27 23ms 0ms 23 29 25ms 0ms 00 27 22ms 0ms [ User: symmetricds - Total duration: 685ms - Times executed: 780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 685ms - Times executed: 780 ]
-
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-08-25 19:31:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 04:35:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:21:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 10ms 0ms 17,201 9s948ms 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 Aug 25 01 719 414ms 0ms 02 716 417ms 0ms 03 716 428ms 0ms 04 716 429ms 0ms 05 718 416ms 0ms 06 716 431ms 0ms 07 716 405ms 0ms 08 718 420ms 0ms 09 716 409ms 0ms 10 716 409ms 0ms 11 718 400ms 0ms 12 716 412ms 0ms 13 716 411ms 0ms 14 718 414ms 0ms 15 716 412ms 0ms 16 716 408ms 0ms 17 718 418ms 0ms 18 716 413ms 0ms 19 716 402ms 0ms 20 718 409ms 0ms 21 716 416ms 0ms 22 716 420ms 0ms 23 716 415ms 0ms 00 718 408ms 0ms [ User: symmetricds - Total duration: 9s948ms - Times executed: 17201 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s948ms - Times executed: 17201 ]
-
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-08-25 14:01:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:28:33 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 21:39:37 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 5ms 0ms 4,416 504ms 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 #11
Day Hour Count Duration Avg duration Aug 25 01 184 16ms 0ms 02 184 16ms 0ms 03 184 18ms 0ms 04 184 17ms 0ms 05 184 19ms 0ms 06 184 19ms 0ms 07 184 18ms 0ms 08 184 17ms 0ms 09 184 30ms 0ms 10 184 50ms 0ms 11 184 20ms 0ms 12 184 30ms 0ms 13 184 47ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 16ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 17ms 0ms 20 184 17ms 0ms 21 184 16ms 0ms 22 184 14ms 0ms 23 184 15ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 504ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 504ms - Times executed: 4416 ]
-
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 = '1' 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;
-
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-08-25 12:29:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:50:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 08:36:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 4ms 0ms 6,474 733ms 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 Aug 25 01 247 29ms 0ms 02 237 27ms 0ms 03 240 29ms 0ms 04 239 29ms 0ms 05 235 27ms 0ms 06 240 28ms 0ms 07 270 29ms 0ms 08 274 30ms 0ms 09 279 30ms 0ms 10 277 30ms 0ms 11 275 30ms 0ms 12 276 30ms 0ms 13 288 35ms 0ms 14 277 30ms 0ms 15 281 30ms 0ms 16 286 30ms 0ms 17 282 31ms 0ms 18 282 31ms 0ms 19 283 30ms 0ms 20 274 31ms 0ms 21 282 31ms 0ms 22 288 31ms 0ms 23 279 31ms 0ms 00 283 32ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6474 ]
-
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-08-25 12:02:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:11:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:11:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 7ms 0ms 17,296 988ms 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 Aug 25 01 722 38ms 0ms 02 720 38ms 0ms 03 720 39ms 0ms 04 720 39ms 0ms 05 722 42ms 0ms 06 720 47ms 0ms 07 720 39ms 0ms 08 722 40ms 0ms 09 720 43ms 0ms 10 720 44ms 0ms 11 722 40ms 0ms 12 720 39ms 0ms 13 720 40ms 0ms 14 722 40ms 0ms 15 720 41ms 0ms 16 720 39ms 0ms 17 722 40ms 0ms 18 720 39ms 0ms 19 720 43ms 0ms 20 722 43ms 0ms 21 720 39ms 0ms 22 720 41ms 0ms 23 720 44ms 0ms 00 722 39ms 0ms [ User: symmetricds - Total duration: 988ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 988ms - Times executed: 17296 ]
-
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 = '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 = '0';
Date: 2019-08-25 05:16:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 09:14:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 18:02:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 7ms 0ms 25,142 1s406ms 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 Aug 25 01 1,118 62ms 0ms 02 1,044 60ms 0ms 03 1,044 54ms 0ms 04 1,044 56ms 0ms 05 1,046 57ms 0ms 06 1,044 60ms 0ms 07 1,044 54ms 0ms 08 1,046 63ms 0ms 09 1,044 56ms 0ms 10 1,044 59ms 0ms 11 1,046 63ms 0ms 12 1,044 59ms 0ms 13 1,044 61ms 0ms 14 1,046 56ms 0ms 15 1,044 58ms 0ms 16 1,044 55ms 0ms 17 1,046 54ms 0ms 18 1,044 56ms 0ms 19 1,044 54ms 0ms 20 1,046 60ms 0ms 21 1,042 69ms 0ms 22 1,044 54ms 0ms 23 1,044 62ms 0ms 00 1,046 54ms 0ms [ User: symmetricds - Total duration: 1s406ms - Times executed: 25142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s406ms - Times executed: 25142 ]
-
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-08-25 07:14:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 00:23:07 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:02:15 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 44,884 2s372ms 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 #15
Day Hour Count Duration Avg duration Aug 25 01 2,748 111ms 0ms 02 1,832 78ms 0ms 03 1,832 87ms 0ms 04 1,832 84ms 0ms 05 1,832 103ms 0ms 06 1,832 76ms 0ms 07 1,832 101ms 0ms 08 1,832 104ms 0ms 09 1,832 103ms 0ms 10 1,832 102ms 0ms 11 1,832 103ms 0ms 12 1,832 100ms 0ms 13 1,832 104ms 0ms 14 1,832 102ms 0ms 15 1,832 101ms 0ms 16 1,832 106ms 0ms 17 1,832 103ms 0ms 18 1,832 107ms 0ms 19 1,832 104ms 0ms 20 1,832 106ms 0ms 21 1,832 91ms 0ms 22 1,832 103ms 0ms 23 1,832 92ms 0ms 00 1,832 88ms 0ms [ User: pharmisight - Total duration: 2s372ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s372ms - Times executed: 44884 ]
-
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 = '165' 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 = '2912' 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 = '3552' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-25 15:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 22:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 50,568 2s644ms 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 #16
Day Hour Count Duration Avg duration Aug 25 01 3,096 124ms 0ms 02 2,064 86ms 0ms 03 2,064 99ms 0ms 04 2,064 93ms 0ms 05 2,064 115ms 0ms 06 2,064 85ms 0ms 07 2,064 112ms 0ms 08 2,064 116ms 0ms 09 2,064 115ms 0ms 10 2,064 114ms 0ms 11 2,064 115ms 0ms 12 2,064 112ms 0ms 13 2,064 119ms 0ms 14 2,064 113ms 0ms 15 2,064 113ms 0ms 16 2,064 116ms 0ms 17 2,064 114ms 0ms 18 2,064 121ms 0ms 19 2,064 117ms 0ms 20 2,064 116ms 0ms 21 2,064 101ms 0ms 22 2,064 116ms 0ms 23 2,064 102ms 0ms 00 2,064 98ms 0ms [ User: pharmisight - Total duration: 2s644ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s644ms - Times executed: 50568 ]
-
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 = '32965583' 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 = '33074301' 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 = '32964834' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-25 12:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 6,474 338ms 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 Aug 25 01 247 13ms 0ms 02 237 13ms 0ms 03 240 13ms 0ms 04 239 13ms 0ms 05 235 13ms 0ms 06 240 14ms 0ms 07 270 13ms 0ms 08 274 14ms 0ms 09 279 13ms 0ms 10 277 13ms 0ms 11 275 14ms 0ms 12 276 13ms 0ms 13 288 14ms 0ms 14 277 14ms 0ms 15 281 14ms 0ms 16 286 14ms 0ms 17 282 14ms 0ms 18 282 14ms 0ms 19 283 14ms 0ms 20 274 14ms 0ms 21 282 14ms 0ms 22 288 14ms 0ms 23 279 14ms 0ms 00 283 14ms 0ms [ User: symmetricds - Total duration: 338ms - Times executed: 6474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 338ms - Times executed: 6474 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' 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;
-
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-08-25 00:17:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 07:46:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 14:22:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 2,084 106ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 25 01 984 24ms 0ms 02 48 4ms 0ms 03 48 4ms 0ms 04 48 3ms 0ms 05 48 4ms 0ms 06 48 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 3ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 4ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 2ms 0ms 17 48 3ms 0ms 18 48 2ms 0ms 19 48 3ms 0ms 20 48 3ms 0ms 21 44 2ms 0ms 22 48 2ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 106ms - Times executed: 2084 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 106ms - Times executed: 2084 ]
-
SELECT set_config('symmetric.node_disabled', '', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-08-25 12:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 20:55:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 16:10:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 2ms 0ms 8,600 432ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 01 359 17ms 0ms 02 358 17ms 0ms 03 358 18ms 0ms 04 358 17ms 0ms 05 359 17ms 0ms 06 358 18ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 18ms 0ms 11 359 17ms 0ms 12 358 17ms 0ms 13 358 18ms 0ms 14 359 18ms 0ms 15 358 18ms 0ms 16 358 17ms 0ms 17 359 20ms 0ms 18 358 18ms 0ms 19 358 18ms 0ms 20 359 17ms 0ms 21 358 17ms 0ms 22 358 17ms 0ms 23 358 18ms 0ms 00 359 17ms 0ms [ User: symmetricds - Total duration: 432ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 432ms - Times executed: 8600 ]
-
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-08-25 16:01:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:53:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 02:42:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 3ms 0ms 8,600 348ms 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 Aug 25 01 359 13ms 0ms 02 358 12ms 0ms 03 358 13ms 0ms 04 358 13ms 0ms 05 359 13ms 0ms 06 358 16ms 0ms 07 358 13ms 0ms 08 359 14ms 0ms 09 358 13ms 0ms 10 358 14ms 0ms 11 359 14ms 0ms 12 358 18ms 0ms 13 358 14ms 0ms 14 359 14ms 0ms 15 358 13ms 0ms 16 358 14ms 0ms 17 359 18ms 0ms 18 358 14ms 0ms 19 358 13ms 0ms 20 359 14ms 0ms 21 358 14ms 0ms 22 358 14ms 0ms 23 358 14ms 0ms 00 359 14ms 0ms [ User: symmetricds - Total duration: 348ms - Times executed: 8600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 348ms - Times executed: 8600 ]
-
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-08-25 16:22:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 11:38:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-25 05:16:22 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,324,901 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 2 FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 25 14 1 15 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Date: 2019-08-25 14:22:40 Database: [unknown] Application: [unknown] User: [unknown] Remote: 185.100.87.190 Code: