pgBadger-
Global information
- Generated on Sun May 20 00:00:22 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,226,979 log entries in 20s
- Log start from 2018-05-19 00:00:00 to 2018-05-19 23:59:54
-
Overview
Global Stats
- 162 Number of unique normalized queries
- 2,154,184 Number of queries
- 1m3s Total query duration
- 2018-05-19 00:00:00 First query
- 2018-05-19 23:59:54 Last query
- 1,223 queries/s at 2018-05-19 00:00:20 Query peak
- 8 Number of events
- 4 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 278 Total number of automatic vacuums
- 303 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,129 Total number of sessions
- 3 sessions at 2018-05-19 20:05:01 Session peak
- 10d4h50m33s Total duration of sessions
- 13m Average duration of sessions
- 1,908 Average queries per session
- 56ms Average queries duration per session
- 1,126 Total number of connections
- 6 connections/s at 2018-05-19 00:00:08 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,223 queries/s Query Peak
- 2018-05-19 00:00:20 Date
SELECT Traffic
Key values
- 594 queries/s Query Peak
- 2018-05-19 00:00:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 538 queries/s Query Peak
- 2018-05-19 00:00:20 Date
Queries duration
Key values
- 1m3s Total query duration
Prepared queries ratio
Key values
- 1.66 Ratio of bind vs prepare
- 166.61 % 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) May 19 00 100,279 0ms 24ms 0ms 70ms 144ms 1s812ms 01 92,551 0ms 26ms 0ms 52ms 184ms 397ms 02 91,966 0ms 23ms 0ms 58ms 169ms 364ms 03 91,613 0ms 36ms 0ms 57ms 159ms 350ms 04 92,227 0ms 25ms 0ms 57ms 208ms 342ms 05 91,950 0ms 26ms 0ms 56ms 152ms 329ms 06 89,762 0ms 61ms 0ms 56ms 60ms 428ms 07 89,706 0ms 135ms 0ms 59ms 63ms 512ms 08 89,645 0ms 61ms 0ms 58ms 67ms 225ms 09 89,626 0ms 120ms 0ms 60ms 66ms 572ms 10 89,739 0ms 91ms 0ms 55ms 61ms 282ms 11 89,480 0ms 72ms 0ms 55ms 62ms 309ms 12 89,847 0ms 83ms 0ms 53ms 66ms 291ms 13 89,580 0ms 77ms 0ms 56ms 68ms 254ms 14 89,449 0ms 70ms 0ms 54ms 61ms 223ms 15 89,621 0ms 55ms 0ms 54ms 60ms 158ms 16 89,467 0ms 46ms 0ms 53ms 57ms 126ms 17 89,584 0ms 44ms 0ms 55ms 60ms 118ms 18 88,043 0ms 15ms 0ms 59ms 67ms 72ms 19 89,918 0ms 21ms 0ms 58ms 65ms 107ms 20 88,817 0ms 18ms 0ms 57ms 61ms 97ms 21 88,082 0ms 49ms 0ms 61ms 67ms 94ms 22 81,391 0ms 23ms 0ms 54ms 58ms 70ms 23 81,841 0ms 30ms 0ms 56ms 70ms 88ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 19 00 32,845 0 0ms 22ms 25ms 45ms 01 29,222 0 0ms 19ms 26ms 51ms 02 29,099 0 0ms 19ms 24ms 49ms 03 29,081 0 0ms 21ms 26ms 39ms 04 29,138 0 0ms 20ms 27ms 43ms 05 29,122 0 0ms 21ms 24ms 38ms 06 28,635 0 0ms 20ms 24ms 27ms 07 28,638 0 0ms 21ms 25ms 29ms 08 28,594 0 0ms 19ms 25ms 32ms 09 28,618 0 0ms 25ms 26ms 31ms 10 28,656 0 0ms 22ms 26ms 31ms 11 28,528 0 0ms 21ms 23ms 36ms 12 28,645 0 0ms 19ms 28ms 31ms 13 28,534 0 0ms 18ms 21ms 36ms 14 28,509 0 0ms 20ms 23ms 29ms 15 28,580 0 0ms 20ms 23ms 27ms 16 28,520 0 0ms 20ms 22ms 27ms 17 28,563 0 0ms 18ms 20ms 28ms 18 28,081 0 0ms 19ms 24ms 29ms 19 28,799 0 0ms 22ms 26ms 31ms 20 28,433 0 0ms 23ms 24ms 49ms 21 28,185 0 0ms 22ms 26ms 34ms 22 26,047 0 0ms 23ms 26ms 28ms 23 26,143 0 0ms 21ms 24ms 30ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 19 00 1,365 1,612 97 0 0ms 9ms 15ms 92ms 01 1,600 1,001 98 0 0ms 1ms 9ms 85ms 02 1,164 892 99 0 0ms 1ms 9ms 70ms 03 884 822 97 0 0ms 1ms 10ms 70ms 04 1,420 956 98 0 0ms 1ms 9ms 99ms 05 1,120 882 98 0 0ms 1ms 9ms 63ms 06 92 595 96 0 0ms 1ms 9ms 12ms 07 72 578 90 0 0ms 1ms 4ms 10ms 08 72 577 84 0 0ms 1ms 3ms 10ms 09 73 578 83 0 0ms 1ms 3ms 11ms 10 72 578 81 0 0ms 1ms 8ms 10ms 11 72 576 80 0 0ms 1ms 4ms 10ms 12 88 595 79 0 0ms 1ms 8ms 10ms 13 72 577 75 0 0ms 1ms 3ms 11ms 14 72 578 76 0 0ms 1ms 2ms 10ms 15 72 577 71 0 0ms 1ms 4ms 9ms 16 72 576 69 0 0ms 1ms 4ms 10ms 17 72 577 71 0 0ms 1ms 3ms 11ms 18 72 569 69 0 0ms 1ms 3ms 14ms 19 73 593 69 0 0ms 1ms 3ms 11ms 20 63 569 73 0 0ms 1ms 1ms 11ms 21 72 569 69 0 0ms 1ms 6ms 10ms 22 72 529 69 0 0ms 1ms 8ms 10ms 23 72 536 69 0 0ms 1ms 8ms 10ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 19 00 59,495 100,279 1.69 95.42% 01 55,410 92,551 1.67 98.41% 02 54,805 91,966 1.68 98.44% 03 55,186 91,613 1.66 99.79% 04 55,036 92,227 1.68 98.29% 05 55,218 91,950 1.67 99.24% 06 54,141 89,762 1.66 100.92% 07 54,312 89,706 1.65 101.37% 08 54,035 89,645 1.66 100.95% 09 54,359 89,626 1.65 101.54% 10 54,531 89,739 1.65 101.76% 11 53,926 89,480 1.66 100.95% 12 54,053 89,847 1.66 100.71% 13 53,530 89,580 1.67 100.12% 14 53,660 89,449 1.67 100.49% 15 53,964 89,621 1.66 100.87% 16 53,895 89,467 1.66 100.93% 17 53,850 89,584 1.66 100.69% 18 53,260 88,043 1.65 101.34% 19 55,474 89,918 1.62 103.23% 20 54,388 88,817 1.63 102.53% 21 54,293 88,082 1.62 103.18% 22 50,198 81,391 1.62 103.20% 23 49,990 81,841 1.64 102.25% Day Hour Count Average / Second May 19 00 46 0.01/s 01 46 0.01/s 02 39 0.01/s 03 50 0.01/s 04 38 0.01/s 05 47 0.01/s 06 43 0.01/s 07 45 0.01/s 08 40 0.01/s 09 44 0.01/s 10 54 0.01/s 11 41 0.01/s 12 42 0.01/s 13 34 0.01/s 14 35 0.01/s 15 41 0.01/s 16 43 0.01/s 17 35 0.01/s 18 47 0.01/s 19 71 0.02/s 20 61 0.02/s 21 67 0.02/s 22 62 0.02/s 23 55 0.02/s Day Hour Count Average Duration May 19 00 49 13m31s 01 46 12m36s 02 39 15m44s 03 50 13m15s 04 38 14m36s 05 47 13m25s 06 43 14m18s 07 45 12m58s 08 40 13m39s 09 44 14m3s 10 54 12m43s 11 40 13m18s 12 43 15m7s 13 34 17m35s 14 35 17m45s 15 40 15m56s 16 41 15m44s 17 38 15m33s 18 47 13m53s 19 71 8m42s 20 61 9m27s 21 67 8m30s 22 62 9m51s 23 55 11m25s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2018-05-19 00:00:08 Date
Connections per database
Key values
- pharmisight Main Database
- 1,126 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,126 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-05-19 20:05:01 Date
Histogram of session times
Key values
- 617 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,129 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,129 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,129 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 3,707 buffers Checkpoint Peak
- 2018-05-19 07:03:46 Date
- 149.961 seconds Highest write time
- 0.016 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-05-19 08:06:19 Date
Checkpoints distance
Key values
Checkpoint mean distance and estimate (5 minutes period)
NO DATASET
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 19 00 1,430 143.292s 0.016s 143.35s 01 990 99.228s 0.014s 99.286s 02 781 78.26s 0.023s 78.321s 03 736 73.846s 0.011s 73.901s 04 868 86.972s 0.018s 87.038s 05 803 80.449s 0.016s 80.503s 06 4,112 193.912s 0.017s 193.972s 07 4,120 191.291s 0.026s 191.358s 08 1,206 120.887s 0.032s 120.964s 09 1,807 181.071s 0.016s 181.133s 10 1,113 111.649s 0.01s 111.702s 11 1,842 184.307s 0.011s 184.36s 12 1,198 120.003s 0.013s 120.057s 13 1,201 120.39s 0.02s 120.452s 14 1,160 115.988s 0.015s 116.046s 15 1,058 105.844s 0.023s 105.909s 16 1,123 112.596s 0.012s 112.651s 17 1,016 101.571s 0.012s 101.637s 18 659 66.126s 0.022s 66.191s 19 809 81.193s 0.024s 81.26s 20 448 44.958s 0.014s 45.016s 21 690 69.254s 0.012s 69.312s 22 894 89.614s 0.03s 89.685s 23 637 63.931s 0.014s 63.985s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 19 00 0 0 1 353 0.002s 0s 01 0 0 0 329 0.002s 0s 02 0 0 0 317 0.008s 0s 03 0 0 1 318 0.001s 0s 04 0 0 0 317 0.002s 0s 05 0 0 0 307 0.002s 0s 06 0 0 2 264 0.002s 0s 07 0 0 1 278 0.011s 0s 08 0 0 1 263 0.016s 0.002s 09 0 0 0 272 0.002s 0s 10 0 0 1 264 0.002s 0s 11 0 0 0 265 0.001s 0s 12 0 0 1 288 0.002s 0s 13 0 0 0 271 0.003s 0s 14 0 0 1 262 0.002s 0s 15 0 0 0 265 0.008s 0s 16 0 0 0 269 0.001s 0s 17 0 0 0 256 0.002s 0s 18 0 0 1 273 0.008s 0s 19 0 0 0 348 0.008s 0s 20 0 0 0 251 0.002s 0s 21 0 0 0 266 0.002s 0s 22 0 0 0 297 0.009s 0.001s 23 0 0 0 307 0.002s 0s Day Hour Count Avg time (sec) May 19 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 May 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 8.38 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-05-19 07:00:28 Date
- 1.70 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-05-19 00:00:35 Date
Analyzes per table
Key values
- public.sym_node_communication (207) Main table analyzed (database pharmisight)
- 303 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 207 pharmisight.public.sym_outgoing_batch 17 pharmisight.public.sym_data 15 pharmisight.public.sym_data_event 14 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_lock 11 pharmisight.public.sym_incoming_batch 9 pharmisight.public.sym_sequence 8 pharmisight.public.sym_node_host 6 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.flow_report_summary_delays 1 Total 303 Vacuums per table
Key values
- public.sym_node_communication (205) Main table vacuumed on database pharmisight
- 278 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 205 0 pharmisight.public.sym_outgoing_batch 11 11 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_data 11 11 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_sequence 8 0 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data_gap 5 5 pharmisight.public.sym_incoming_batch 4 4 pharmisight.pg_toast.pg_toast_2619 3 3 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_node_channel_ctl 2 0 Total 278 46 Tuples removed per table
Key values
- public.sym_data_event (30214) Main table with removed tuples on database pharmisight
- 71257 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 30214 0 pharmisight.public.sym_data 11 11 20445 2382 pharmisight.public.sym_node_communication 205 0 11448 0 pharmisight.public.sym_outgoing_batch 11 11 5574 7 pharmisight.public.sym_incoming_batch 4 4 1091 0 pharmisight.pg_catalog.pg_statistic 2 2 598 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 8 0 410 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.pg_toast.pg_toast_2619 3 3 231 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 Total 278 46 71,257 2,389 Pages removed per table
Key values
- public.sym_data (2382) Main table with removed pages on database pharmisight
- 2389 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 11 11 20445 2382 pharmisight.public.sym_outgoing_batch 11 11 5574 7 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.pg_catalog.pg_statistic 2 2 598 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_data_event 10 10 30214 0 pharmisight.pg_toast.pg_toast_2619 3 3 231 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 pharmisight.public.sym_node_communication 205 0 11448 0 pharmisight.public.sym_incoming_batch 4 4 1091 0 pharmisight.public.sym_sequence 8 0 410 0 Total 278 46 71,257 2,389 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 19 00 10 14 01 11 11 02 10 12 03 11 9 04 10 13 05 11 9 06 10 13 07 14 13 08 9 14 09 13 14 10 11 15 11 13 11 12 14 15 13 15 14 14 12 12 15 13 14 16 14 14 17 11 14 18 12 10 19 13 14 20 8 10 21 12 13 22 11 12 23 10 13 - 8.38 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
- 687,215 Total read queries
- 605,753 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,154,184 Requests
- 1m3s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,240,526 Requests
User Request type Count Duration pharmisight Total 7,105 2s76ms DELETE 7 0ms INSERT 2,172 1s391ms OTHERS 1,347 56ms SELECT 3,039 543ms TCL 512 81ms UPDATE 28 2ms symmetricds Total 2,240,526 1m4s DDL 1 1ms DELETE 2,012 4s49ms INSERT 9,042 912ms OTHERS 896,117 17s388ms SELECT 713,394 26s807ms TCL 602,270 10s64ms UPDATE 17,690 4s936ms Duration by user
Key values
- 1m4s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 7,105 2s76ms DELETE 7 0ms INSERT 2,172 1s391ms OTHERS 1,347 56ms SELECT 3,039 543ms TCL 512 81ms UPDATE 28 2ms symmetricds Total 2,240,526 1m4s DDL 1 1ms DELETE 2,012 4s49ms INSERT 9,042 912ms OTHERS 896,117 17s388ms SELECT 713,394 26s807ms TCL 602,270 10s64ms UPDATE 17,690 4s936ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,247,631 Requests
- 1m6s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,153,058 Requests
- 1m3s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-05-19 20:44:08 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,150,190 0-1ms duration
Slowest individual queries
Rank Duration Query 1 135ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7528336' AND '7528933' AND STATUS != 'OK') AND batch_id BETWEEN '7528336' AND '7528933';[ Date: 2018-05-19 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 120ms DELETE FROM sym_data WHERE data_id BETWEEN '83436816' AND '83441816' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 91ms DELETE FROM sym_data WHERE data_id BETWEEN '83442186' AND '83447186' AND create_time < '2018-05-18 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 84ms DELETE FROM sym_data WHERE data_id BETWEEN '83441817' AND '83446817' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 83ms DELETE FROM sym_data WHERE data_id BETWEEN '83451890' AND '83456890' AND create_time < '2018-05-18 12:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451890' AND '83456890') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451890' AND '83456890' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 77ms DELETE FROM sym_data WHERE data_id BETWEEN '83455674' AND '83460674' AND create_time < '2018-05-18 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83455674' AND '83460674') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83455674' AND '83460674' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 72ms DELETE FROM sym_data WHERE data_id BETWEEN '83445343' AND '83450343' AND create_time < '2018-05-18 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83445343' AND '83450343') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83445343' AND '83450343' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 70ms DELETE FROM sym_data WHERE data_id BETWEEN '83459659' AND '83464659' AND create_time < '2018-05-18 14:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83459659' AND '83464659') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83459659' AND '83464659' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 61ms DELETE FROM sym_data WHERE data_id BETWEEN '83406423' AND '83411423' AND create_time < '2018-05-18 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83406423' AND '83411423') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83406423' AND '83411423' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 61ms DELETE FROM sym_data WHERE data_id BETWEEN '83431955' AND '83436955' AND create_time < '2018-05-18 08:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83431955' AND '83436955') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83431955' AND '83436955' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 55ms DELETE FROM sym_data WHERE data_id BETWEEN '83463840' AND '83468840' AND create_time < '2018-05-18 15:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83463840' AND '83468840') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83463840' AND '83468840' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 50ms DELETE FROM sym_data WHERE data_id BETWEEN '83446818' AND '83451818' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83446818' AND '83451818') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83446818' AND '83451818' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 49ms DELETE FROM sym_data WHERE data_id BETWEEN '83469772' AND '83473081' AND create_time < '2018-05-18 21:00:01.982' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83469772' AND '83473081') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83469772' AND '83473081' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 21:00:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 48ms DELETE FROM sym_data WHERE data_id BETWEEN '83451819' AND '83456819' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451819' AND '83456819') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451819' AND '83456819' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 48ms DELETE FROM sym_data WHERE data_id BETWEEN '83419343' AND '83424343' AND create_time < '2018-05-18 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83419343' AND '83424343') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83419343' AND '83424343' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 47ms DELETE FROM sym_outgoing_batch WHERE STATUS = 'OK' AND batch_id BETWEEN '7528336' AND '7528933' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '7528336' AND '7528933');[ Date: 2018-05-19 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 46ms DELETE FROM sym_data WHERE data_id BETWEEN '83466575' AND '83471575' AND create_time < '2018-05-18 16:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83466575' AND '83471575') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83466575' AND '83471575' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 45ms DELETE FROM sym_data WHERE data_id BETWEEN '83456820' AND '83461820' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83456820' AND '83461820') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83456820' AND '83461820' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 45ms DELETE FROM sym_data WHERE data_id BETWEEN '83424344' AND '83429344' AND create_time < '2018-05-18 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83424344' AND '83429344') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83424344' AND '83429344' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 44ms DELETE FROM sym_data WHERE data_id BETWEEN '83467779' AND '83472779' AND create_time < '2018-05-18 17:00:00.387' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83467779' AND '83472779') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83467779' AND '83472779' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-05-19 17:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 16s651ms 858,964 0ms 8ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 19 00 37,837 733ms 0ms 01 36,156 688ms 0ms 02 36,214 717ms 0ms 03 36,211 710ms 0ms 04 36,155 706ms 0ms 05 36,214 712ms 0ms 06 36,030 712ms 0ms 07 36,038 704ms 0ms 08 36,038 697ms 0ms 09 36,002 688ms 0ms 10 36,044 711ms 0ms 11 35,980 697ms 0ms 12 36,090 714ms 0ms 13 36,048 692ms 0ms 14 35,981 711ms 0ms 15 36,039 697ms 0ms 16 35,983 685ms 0ms 17 36,033 712ms 0ms 18 35,392 699ms 0ms 19 36,040 678ms 0ms 20 35,647 677ms 0ms 21 35,327 662ms 0ms 22 32,624 607ms 0ms 23 32,841 629ms 0ms [ User: symmetricds - Total duration: 16s628ms - Times executed: 858539 ]
[ User: pharmisight - Total duration: 22ms - Times executed: 425 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s651ms - Times executed: 858964 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-05-19 02:35:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 05:38:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:03:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s679ms 289,211 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 00 13,215 582ms 0ms 01 12,191 341ms 0ms 02 12,210 357ms 0ms 03 12,209 336ms 0ms 04 12,192 351ms 0ms 05 12,210 340ms 0ms 06 12,114 317ms 0ms 07 12,100 300ms 0ms 08 12,100 308ms 0ms 09 12,092 306ms 0ms 10 12,100 293ms 0ms 11 12,081 291ms 0ms 12 12,133 306ms 0ms 13 12,103 314ms 0ms 14 12,081 295ms 0ms 15 12,100 289ms 0ms 16 12,081 295ms 0ms 17 12,099 293ms 0ms 18 11,883 297ms 0ms 19 12,101 302ms 0ms 20 11,955 280ms 0ms 21 11,863 311ms 0ms 22 10,963 283ms 0ms 23 11,035 278ms 0ms [ User: symmetricds - Total duration: 7s609ms - Times executed: 288964 ]
[ User: pharmisight - Total duration: 69ms - Times executed: 247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s679ms - Times executed: 289211 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-05-19 04:45:28 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:53:22 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 02:40:07 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s860ms 380,448 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 19 00 17,406 218ms 0ms 01 16,030 200ms 0ms 02 16,062 210ms 0ms 03 16,056 208ms 0ms 04 16,027 202ms 0ms 05 16,063 203ms 0ms 06 15,943 208ms 0ms 07 15,937 203ms 0ms 08 15,928 204ms 0ms 09 15,910 207ms 0ms 10 15,924 202ms 0ms 11 15,890 208ms 0ms 12 15,962 204ms 0ms 13 15,920 208ms 0ms 14 15,892 203ms 0ms 15 15,915 201ms 0ms 16 15,879 201ms 0ms 17 15,913 200ms 0ms 18 15,624 201ms 0ms 19 15,912 200ms 0ms 20 15,740 198ms 0ms 21 15,595 199ms 0ms 22 14,421 180ms 0ms 23 14,499 179ms 0ms [ User: symmetricds - Total duration: 4s860ms - Times executed: 380448 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s860ms - Times executed: 380448 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-05-19 13:11:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:36:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:19:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s593ms 76,491 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 19 00 3,204 149ms 0ms 01 3,213 149ms 0ms 02 3,222 153ms 0ms 03 3,222 149ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 3,213 153ms 0ms 07 3,222 148ms 0ms 08 3,222 150ms 0ms 09 3,213 153ms 0ms 10 3,222 152ms 0ms 11 3,213 148ms 0ms 12 3,222 150ms 0ms 13 3,222 151ms 0ms 14 3,213 152ms 0ms 15 3,222 149ms 0ms 16 3,213 147ms 0ms 17 3,222 151ms 0ms 18 3,159 150ms 0ms 19 3,222 152ms 0ms 20 3,213 150ms 0ms 21 3,150 150ms 0ms 22 2,916 138ms 0ms 23 2,916 138ms 0ms [ User: symmetricds - Total duration: 3s593ms - Times executed: 76491 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s593ms - Times executed: 76491 ]
-
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: 2018-05-19 20:25:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:45:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 2s710ms 163 0ms 120ms 16ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 19 00 14 101ms 7ms 01 14 104ms 7ms 02 14 96ms 6ms 03 14 116ms 8ms 04 14 97ms 6ms 05 14 102ms 7ms 06 14 258ms 18ms 07 11 218ms 19ms 08 9 104ms 11ms 09 8 435ms 54ms 10 7 161ms 23ms 11 6 173ms 28ms 12 5 171ms 34ms 13 4 137ms 34ms 14 3 112ms 37ms 15 2 72ms 36ms 16 2 47ms 23ms 17 2 45ms 22ms 18 1 15ms 15ms 19 1 21ms 21ms 20 1 11ms 11ms 21 1 49ms 49ms 22 1 23ms 23ms 23 1 30ms 30ms [ User: symmetricds - Total duration: 2s710ms - Times executed: 163 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s710ms - Times executed: 163 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '83436816' AND '83441816' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '83442186' AND '83447186' AND create_time < '2018-05-18 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '83441817' AND '83446817' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-05-19 09:00:00 Duration: 120ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:00:00 Duration: 91ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 2s28ms 289,211 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 19 00 13,215 92ms 0ms 01 12,191 83ms 0ms 02 12,210 85ms 0ms 03 12,209 87ms 0ms 04 12,192 83ms 0ms 05 12,210 83ms 0ms 06 12,114 88ms 0ms 07 12,100 87ms 0ms 08 12,100 85ms 0ms 09 12,092 88ms 0ms 10 12,100 84ms 0ms 11 12,081 83ms 0ms 12 12,133 84ms 0ms 13 12,103 83ms 0ms 14 12,082 86ms 0ms 15 12,100 83ms 0ms 16 12,080 84ms 0ms 17 12,099 87ms 0ms 18 11,883 84ms 0ms 19 12,101 85ms 0ms 20 11,955 83ms 0ms 21 11,863 82ms 0ms 22 10,963 74ms 0ms 23 11,035 74ms 0ms [ User: symmetricds - Total duration: 2s26ms - Times executed: 288964 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s28ms - Times executed: 289211 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-05-19 09:09:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:54:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:36:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s625ms 68,000 0ms 3ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 19 00 2,850 70ms 0ms 01 2,858 69ms 0ms 02 2,865 70ms 0ms 03 2,864 69ms 0ms 04 2,858 73ms 0ms 05 2,865 69ms 0ms 06 2,856 68ms 0ms 07 2,864 67ms 0ms 08 2,864 70ms 0ms 09 2,856 70ms 0ms 10 2,864 67ms 0ms 11 2,856 70ms 0ms 12 2,864 70ms 0ms 13 2,864 66ms 0ms 14 2,856 66ms 0ms 15 2,864 66ms 0ms 16 2,856 65ms 0ms 17 2,864 66ms 0ms 18 2,808 65ms 0ms 19 2,864 66ms 0ms 20 2,856 65ms 0ms 21 2,800 65ms 0ms 22 2,592 61ms 0ms 23 2,592 58ms 0ms [ User: symmetricds - Total duration: 1s625ms - Times executed: 68000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s625ms - Times executed: 68000 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'dynamic' AND ((d.data_id BETWEEN '83472478' AND '133472477')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'config' AND ((d.data_id BETWEEN '83473099' AND '133473098')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'pharmisight' AND ((d.data_id BETWEEN '83471517' AND '133471516')) ORDER BY d.data_id ASC;
Date: 2018-05-19 04:35:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:15:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 01:20:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s284ms 57,040 0ms 5ms 0ms SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = '' AND channel_id = '';Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 19 00 2,400 55ms 0ms 01 2,400 51ms 0ms 02 2,400 56ms 0ms 03 2,400 55ms 0ms 04 2,400 54ms 0ms 05 2,400 56ms 0ms 06 2,400 53ms 0ms 07 2,400 58ms 0ms 08 2,400 54ms 0ms 09 2,400 54ms 0ms 10 2,400 50ms 0ms 11 2,400 53ms 0ms 12 2,400 52ms 0ms 13 2,400 52ms 0ms 14 2,400 57ms 0ms 15 2,400 55ms 0ms 16 2,400 55ms 0ms 17 2,400 57ms 0ms 18 2,360 57ms 0ms 19 2,400 50ms 0ms 20 2,360 49ms 0ms 21 2,360 48ms 0ms 22 2,160 44ms 0ms 23 2,200 46ms 0ms [ User: symmetricds - Total duration: 1s284ms - Times executed: 57040 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s284ms - Times executed: 57040 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'filesync';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'filesync_reload';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'pharmisight';
Date: 2018-05-19 18:49:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 17:22:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:05:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s217ms 189 1ms 13ms 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" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 00 8 38ms 4ms 01 8 55ms 6ms 02 8 47ms 5ms 03 8 56ms 7ms 04 8 35ms 4ms 05 8 55ms 6ms 06 8 51ms 6ms 07 8 55ms 6ms 08 8 41ms 5ms 09 8 44ms 5ms 10 8 61ms 7ms 11 8 55ms 6ms 12 8 55ms 6ms 13 8 33ms 4ms 14 8 51ms 6ms 15 8 55ms 6ms 16 8 56ms 7ms 17 8 50ms 6ms 18 8 55ms 6ms 19 8 51ms 6ms 20 5 41ms 8ms 21 8 50ms 6ms 22 8 62ms 7ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s217ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s217ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '193755176', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:25:44', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '436445752', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:36:53', "last_restart_time" = '2018-05-17 16:07:48', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '182956112', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:10:44', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-05-19 18:26:27 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 18:38:28 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 18:11:26 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s168ms 5,744 0ms 1ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 19 00 249 49ms 0ms 01 241 46ms 0ms 02 243 50ms 0ms 03 241 53ms 0ms 04 244 50ms 0ms 05 243 51ms 0ms 06 242 50ms 0ms 07 241 50ms 0ms 08 241 48ms 0ms 09 240 48ms 0ms 10 242 48ms 0ms 11 240 47ms 0ms 12 241 49ms 0ms 13 240 49ms 0ms 14 242 53ms 0ms 15 242 47ms 0ms 16 241 47ms 0ms 17 240 47ms 0ms 18 235 49ms 0ms 19 241 47ms 0ms 20 236 46ms 0ms 21 236 46ms 0ms 22 220 43ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s168ms - Times executed: 5744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s168ms - Times executed: 5744 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-19 12:37:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:25:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 16:09:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s142ms 1,731 0ms 14ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 19 00 282 175ms 0ms 01 379 236ms 0ms 02 270 184ms 0ms 03 200 138ms 0ms 04 334 225ms 0ms 05 259 164ms 0ms 06 4 9ms 2ms 12 3 8ms 2ms [ User: pharmisight - Total duration: 1s142ms - Times executed: 1731 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s142ms - Times executed: 1731 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003977359', '2018-05-19 04:28:18', 'RYBAKJ', '2018-05-19 04:40:00.03', '40832', '6', '150505230115232238');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003989791', '2018-05-19 02:39:32', 'ARKADIUSZC', '2018-05-19 03:00:00.034', '54548', '8', '150505230115224653');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003992252', '2018-05-19 03:39:08', 'KWAPIENM', '2018-05-19 04:00:00.034', '110638', '24', '31237090251936005');
Date: 2018-05-19 04:40:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 04:00:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s42ms 202 3ms 10ms 5ms 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 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 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 - 0 ] & 0 WHEN 0 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 May 19 00 166 832ms 5ms 01 3 13ms 4ms 02 2 17ms 8ms 03 3 17ms 5ms 04 3 13ms 4ms 05 3 13ms 4ms 06 3 13ms 4ms 07 1 4ms 4ms 08 1 4ms 4ms 09 2 12ms 6ms 10 1 4ms 4ms 11 1 8ms 8ms 12 2 13ms 6ms 13 1 8ms 8ms 14 1 4ms 4ms 15 1 4ms 4ms 16 1 4ms 4ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 8ms 8ms 20 1 8ms 8ms 21 1 8ms 8ms 22 1 8ms 8ms 23 1 10ms 10ms [ User: symmetricds - Total duration: 1s42ms - Times executed: 202 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s42ms - Times executed: 202 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' 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 = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-05-19 23:09:20 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:00:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 898ms 5,703 0ms 5ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 00 240 38ms 0ms 01 240 36ms 0ms 02 240 35ms 0ms 03 240 36ms 0ms 04 240 43ms 0ms 05 240 38ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 36ms 0ms 09 240 36ms 0ms 10 240 37ms 0ms 11 240 39ms 0ms 12 240 40ms 0ms 13 240 37ms 0ms 14 240 38ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 36ms 0ms 18 236 37ms 0ms 19 240 35ms 0ms 20 236 35ms 0ms 21 236 36ms 0ms 22 216 31ms 0ms 23 219 33ms 0ms [ User: symmetricds - Total duration: 898ms - Times executed: 5703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 898ms - Times executed: 5703 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 04:30:27.779', last_lock_time = '2018-05-19 04:30:27.779' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 02:30:27.779');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 21:02:02.986', last_lock_time = '2018-05-19 21:02:02.986' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 19:02:02.986');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 11:56:39.776', last_lock_time = '2018-05-19 11:56:39.776' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 09:56:39.776');
Date: 2018-05-19 04:30:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:02:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:56:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 884ms 771 0ms 18ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 19 00 32 32ms 1ms 01 32 33ms 1ms 02 25 32ms 1ms 03 31 31ms 1ms 04 28 38ms 1ms 05 31 30ms 0ms 06 28 29ms 1ms 07 31 35ms 1ms 08 26 29ms 1ms 09 32 31ms 0ms 10 37 57ms 1ms 11 24 43ms 1ms 12 23 37ms 1ms 13 18 17ms 0ms 14 22 26ms 1ms 15 25 27ms 1ms 16 26 28ms 1ms 17 24 24ms 1ms 18 29 32ms 1ms 19 55 55ms 1ms 20 44 45ms 1ms 21 55 56ms 1ms 22 51 53ms 1ms 23 42 53ms 1ms [ User: symmetricds - Total duration: 884ms - Times executed: 771 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 884ms - Times executed: 771 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 11:18:38 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:34:40 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:16:37 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 827ms 15,864 0ms 2ms 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 WHERE node_id = '';Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 19 00 693 36ms 0ms 01 668 34ms 0ms 02 669 34ms 0ms 03 669 34ms 0ms 04 668 35ms 0ms 05 669 34ms 0ms 06 666 34ms 0ms 07 666 34ms 0ms 08 666 34ms 0ms 09 666 34ms 0ms 10 666 34ms 0ms 11 665 37ms 0ms 12 667 36ms 0ms 13 666 34ms 0ms 14 665 34ms 0ms 15 666 34ms 0ms 16 665 32ms 0ms 17 666 32ms 0ms 18 654 34ms 0ms 19 666 37ms 0ms 20 657 34ms 0ms 21 653 34ms 0ms 22 602 30ms 0ms 23 606 33ms 0ms [ User: symmetricds - Total duration: 827ms - Times executed: 15864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 827ms - Times executed: 15864 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-19 11:00:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:31:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 06:38:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 784ms 11,408 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 19 00 481 31ms 0ms 01 480 32ms 0ms 02 480 35ms 0ms 03 480 34ms 0ms 04 480 31ms 0ms 05 480 33ms 0ms 06 480 30ms 0ms 07 480 33ms 0ms 08 480 31ms 0ms 09 480 33ms 0ms 10 480 35ms 0ms 11 480 32ms 0ms 12 480 32ms 0ms 13 480 34ms 0ms 14 480 36ms 0ms 15 480 32ms 0ms 16 480 30ms 0ms 17 480 33ms 0ms 18 472 32ms 0ms 19 480 32ms 0ms 20 472 33ms 0ms 21 472 32ms 0ms 22 432 29ms 0ms 23 439 30ms 0ms [ User: symmetricds - Total duration: 784ms - Times executed: 11408 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 784ms - Times executed: 11408 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-19 14:58:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 14:04:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:00:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 768ms 5,704 0ms 5ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 19 00 240 34ms 0ms 01 240 32ms 0ms 02 240 33ms 0ms 03 240 31ms 0ms 04 240 31ms 0ms 05 240 32ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 30ms 0ms 09 240 31ms 0ms 10 240 31ms 0ms 11 240 31ms 0ms 12 240 32ms 0ms 13 240 33ms 0ms 14 240 32ms 0ms 15 240 32ms 0ms 16 240 31ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 30ms 0ms 20 236 30ms 0ms 21 236 35ms 0ms 22 216 28ms 0ms 23 220 29ms 0ms [ User: symmetricds - Total duration: 768ms - Times executed: 5704 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 768ms - Times executed: 5704 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '71', success_count = '115099', fail_count = '0', total_success_count = '115099', total_fail_count = '0', total_success_millis = '6748670', total_fail_millis = '0', last_lock_time = '2018-05-19 21:54:05.614' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '76', success_count = '115172', fail_count = '0', total_success_count = '115172', total_fail_count = '0', total_success_millis = '7093942', total_fail_millis = '0', last_lock_time = '2018-05-19 22:43:11.181' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '72', success_count = '114935', fail_count = '0', total_success_count = '114935', total_fail_count = '0', total_success_millis = '6402375', total_fail_millis = '0', last_lock_time = '2018-05-19 13:41:42.394' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-05-19 21:55:04 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:43:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 13:41:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 762ms 508 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 00 22 31ms 1ms 01 25 35ms 1ms 02 21 31ms 1ms 03 23 35ms 1ms 04 21 31ms 1ms 05 23 34ms 1ms 06 25 37ms 1ms 07 25 37ms 1ms 08 22 32ms 1ms 09 25 37ms 1ms 10 22 33ms 1ms 11 18 27ms 1ms 12 18 27ms 1ms 13 15 22ms 1ms 14 13 19ms 1ms 15 19 28ms 1ms 16 21 31ms 1ms 17 19 28ms 1ms 18 23 33ms 1ms 19 26 39ms 1ms 20 29 44ms 1ms 21 29 45ms 1ms 22 14 20ms 1ms 23 10 14ms 1ms [ User: symmetricds - Total duration: 762ms - Times executed: 508 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 762ms - Times executed: 508 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 12:14:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:06:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:03:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 714ms 163 0ms 15ms 4ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 19 00 14 70ms 5ms 01 14 69ms 4ms 02 14 66ms 4ms 03 14 65ms 4ms 04 14 68ms 4ms 05 14 68ms 4ms 06 14 56ms 4ms 07 11 43ms 3ms 08 9 34ms 3ms 09 8 28ms 3ms 10 7 46ms 6ms 11 6 16ms 2ms 12 5 23ms 4ms 13 4 18ms 4ms 14 3 9ms 3ms 15 2 6ms 3ms 16 2 4ms 2ms 17 2 3ms 1ms 18 1 1ms 1ms 19 1 2ms 2ms 20 1 1ms 1ms 21 1 4ms 4ms 22 1 2ms 2ms 23 1 2ms 2ms [ User: symmetricds - Total duration: 714ms - Times executed: 163 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 714ms - Times executed: 163 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '83447187' AND '83452187' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 10:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83447187' AND '83452187');
-
DELETE FROM sym_data WHERE data_id BETWEEN '83442186' AND '83447186' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 10:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186');
-
DELETE FROM sym_data WHERE data_id BETWEEN '83451890' AND '83456890' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 12:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451890' AND '83456890');
Date: 2018-05-19 10:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 689ms 656 0ms 7ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 00 26 25ms 0ms 01 25 24ms 0ms 02 23 25ms 1ms 03 28 28ms 1ms 04 20 20ms 1ms 05 26 27ms 1ms 06 24 27ms 1ms 07 27 27ms 1ms 08 23 22ms 0ms 09 29 30ms 1ms 10 33 35ms 1ms 11 22 22ms 1ms 12 20 19ms 0ms 13 15 14ms 0ms 14 18 18ms 1ms 15 23 26ms 1ms 16 22 22ms 1ms 17 20 21ms 1ms 18 23 22ms 0ms 19 50 55ms 1ms 20 38 41ms 1ms 21 45 43ms 0ms 22 41 39ms 0ms 23 35 47ms 1ms [ User: symmetricds - Total duration: 689ms - Times executed: 656 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 656 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 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), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 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), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 23:07:43 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 19:09:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 23:03:23 Duration: 6ms 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 858,964 16s651ms 0ms 8ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 19 00 37,837 733ms 0ms 01 36,156 688ms 0ms 02 36,214 717ms 0ms 03 36,211 710ms 0ms 04 36,155 706ms 0ms 05 36,214 712ms 0ms 06 36,030 712ms 0ms 07 36,038 704ms 0ms 08 36,038 697ms 0ms 09 36,002 688ms 0ms 10 36,044 711ms 0ms 11 35,980 697ms 0ms 12 36,090 714ms 0ms 13 36,048 692ms 0ms 14 35,981 711ms 0ms 15 36,039 697ms 0ms 16 35,983 685ms 0ms 17 36,033 712ms 0ms 18 35,392 699ms 0ms 19 36,040 678ms 0ms 20 35,647 677ms 0ms 21 35,327 662ms 0ms 22 32,624 607ms 0ms 23 32,841 629ms 0ms [ User: symmetricds - Total duration: 16s628ms - Times executed: 858539 ]
[ User: pharmisight - Total duration: 22ms - Times executed: 425 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s651ms - Times executed: 858964 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-05-19 02:35:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 05:38:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:03:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 380,448 4s860ms 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 00 17,406 218ms 0ms 01 16,030 200ms 0ms 02 16,062 210ms 0ms 03 16,056 208ms 0ms 04 16,027 202ms 0ms 05 16,063 203ms 0ms 06 15,943 208ms 0ms 07 15,937 203ms 0ms 08 15,928 204ms 0ms 09 15,910 207ms 0ms 10 15,924 202ms 0ms 11 15,890 208ms 0ms 12 15,962 204ms 0ms 13 15,920 208ms 0ms 14 15,892 203ms 0ms 15 15,915 201ms 0ms 16 15,879 201ms 0ms 17 15,913 200ms 0ms 18 15,624 201ms 0ms 19 15,912 200ms 0ms 20 15,740 198ms 0ms 21 15,595 199ms 0ms 22 14,421 180ms 0ms 23 14,499 179ms 0ms [ User: symmetricds - Total duration: 4s860ms - Times executed: 380448 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s860ms - Times executed: 380448 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-05-19 13:11:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:36:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:19:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 289,211 2s28ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 19 00 13,215 92ms 0ms 01 12,191 83ms 0ms 02 12,210 85ms 0ms 03 12,209 87ms 0ms 04 12,192 83ms 0ms 05 12,210 83ms 0ms 06 12,114 88ms 0ms 07 12,100 87ms 0ms 08 12,100 85ms 0ms 09 12,092 88ms 0ms 10 12,100 84ms 0ms 11 12,081 83ms 0ms 12 12,133 84ms 0ms 13 12,103 83ms 0ms 14 12,082 86ms 0ms 15 12,100 83ms 0ms 16 12,080 84ms 0ms 17 12,099 87ms 0ms 18 11,883 84ms 0ms 19 12,101 85ms 0ms 20 11,955 83ms 0ms 21 11,863 82ms 0ms 22 10,963 74ms 0ms 23 11,035 74ms 0ms [ User: symmetricds - Total duration: 2s26ms - Times executed: 288964 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s28ms - Times executed: 289211 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-05-19 09:09:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:54:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:36:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 289,211 7s679ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 19 00 13,215 582ms 0ms 01 12,191 341ms 0ms 02 12,210 357ms 0ms 03 12,209 336ms 0ms 04 12,192 351ms 0ms 05 12,210 340ms 0ms 06 12,114 317ms 0ms 07 12,100 300ms 0ms 08 12,100 308ms 0ms 09 12,092 306ms 0ms 10 12,100 293ms 0ms 11 12,081 291ms 0ms 12 12,133 306ms 0ms 13 12,103 314ms 0ms 14 12,081 295ms 0ms 15 12,100 289ms 0ms 16 12,081 295ms 0ms 17 12,099 293ms 0ms 18 11,883 297ms 0ms 19 12,101 302ms 0ms 20 11,955 280ms 0ms 21 11,863 311ms 0ms 22 10,963 283ms 0ms 23 11,035 278ms 0ms [ User: symmetricds - Total duration: 7s609ms - Times executed: 288964 ]
[ User: pharmisight - Total duration: 69ms - Times executed: 247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s679ms - Times executed: 289211 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-05-19 04:45:28 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:53:22 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 02:40:07 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 76,491 3s593ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 19 00 3,204 149ms 0ms 01 3,213 149ms 0ms 02 3,222 153ms 0ms 03 3,222 149ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 3,213 153ms 0ms 07 3,222 148ms 0ms 08 3,222 150ms 0ms 09 3,213 153ms 0ms 10 3,222 152ms 0ms 11 3,213 148ms 0ms 12 3,222 150ms 0ms 13 3,222 151ms 0ms 14 3,213 152ms 0ms 15 3,222 149ms 0ms 16 3,213 147ms 0ms 17 3,222 151ms 0ms 18 3,159 150ms 0ms 19 3,222 152ms 0ms 20 3,213 150ms 0ms 21 3,150 150ms 0ms 22 2,916 138ms 0ms 23 2,916 138ms 0ms [ User: symmetricds - Total duration: 3s593ms - Times executed: 76491 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s593ms - Times executed: 76491 ]
-
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: 2018-05-19 20:25:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:45:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 68,000 1s625ms 0ms 3ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 19 00 2,850 70ms 0ms 01 2,858 69ms 0ms 02 2,865 70ms 0ms 03 2,864 69ms 0ms 04 2,858 73ms 0ms 05 2,865 69ms 0ms 06 2,856 68ms 0ms 07 2,864 67ms 0ms 08 2,864 70ms 0ms 09 2,856 70ms 0ms 10 2,864 67ms 0ms 11 2,856 70ms 0ms 12 2,864 70ms 0ms 13 2,864 66ms 0ms 14 2,856 66ms 0ms 15 2,864 66ms 0ms 16 2,856 65ms 0ms 17 2,864 66ms 0ms 18 2,808 65ms 0ms 19 2,864 66ms 0ms 20 2,856 65ms 0ms 21 2,800 65ms 0ms 22 2,592 61ms 0ms 23 2,592 58ms 0ms [ User: symmetricds - Total duration: 1s625ms - Times executed: 68000 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s625ms - Times executed: 68000 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'dynamic' AND ((d.data_id BETWEEN '83472478' AND '133472477')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'config' AND ((d.data_id BETWEEN '83473099' AND '133473098')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'pharmisight' AND ((d.data_id BETWEEN '83471517' AND '133471516')) ORDER BY d.data_id ASC;
Date: 2018-05-19 04:35:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:15:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 01:20:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 57,040 1s284ms 0ms 5ms 0ms SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = '' AND channel_id = '';Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 19 00 2,400 55ms 0ms 01 2,400 51ms 0ms 02 2,400 56ms 0ms 03 2,400 55ms 0ms 04 2,400 54ms 0ms 05 2,400 56ms 0ms 06 2,400 53ms 0ms 07 2,400 58ms 0ms 08 2,400 54ms 0ms 09 2,400 54ms 0ms 10 2,400 50ms 0ms 11 2,400 53ms 0ms 12 2,400 52ms 0ms 13 2,400 52ms 0ms 14 2,400 57ms 0ms 15 2,400 55ms 0ms 16 2,400 55ms 0ms 17 2,400 57ms 0ms 18 2,360 57ms 0ms 19 2,400 50ms 0ms 20 2,360 49ms 0ms 21 2,360 48ms 0ms 22 2,160 44ms 0ms 23 2,200 46ms 0ms [ User: symmetricds - Total duration: 1s284ms - Times executed: 57040 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s284ms - Times executed: 57040 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'filesync';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'filesync_reload';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'pharmisight';
Date: 2018-05-19 18:49:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 17:22:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:05:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 15,864 827ms 0ms 2ms 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 WHERE node_id = '';Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 19 00 693 36ms 0ms 01 668 34ms 0ms 02 669 34ms 0ms 03 669 34ms 0ms 04 668 35ms 0ms 05 669 34ms 0ms 06 666 34ms 0ms 07 666 34ms 0ms 08 666 34ms 0ms 09 666 34ms 0ms 10 666 34ms 0ms 11 665 37ms 0ms 12 667 36ms 0ms 13 666 34ms 0ms 14 665 34ms 0ms 15 666 34ms 0ms 16 665 32ms 0ms 17 666 32ms 0ms 18 654 34ms 0ms 19 666 37ms 0ms 20 657 34ms 0ms 21 653 34ms 0ms 22 602 30ms 0ms 23 606 33ms 0ms [ User: symmetricds - Total duration: 827ms - Times executed: 15864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 827ms - Times executed: 15864 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-19 11:00:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:31:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 06:38:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 11,408 784ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 00 481 31ms 0ms 01 480 32ms 0ms 02 480 35ms 0ms 03 480 34ms 0ms 04 480 31ms 0ms 05 480 33ms 0ms 06 480 30ms 0ms 07 480 33ms 0ms 08 480 31ms 0ms 09 480 33ms 0ms 10 480 35ms 0ms 11 480 32ms 0ms 12 480 32ms 0ms 13 480 34ms 0ms 14 480 36ms 0ms 15 480 32ms 0ms 16 480 30ms 0ms 17 480 33ms 0ms 18 472 32ms 0ms 19 480 32ms 0ms 20 472 33ms 0ms 21 472 32ms 0ms 22 432 29ms 0ms 23 439 30ms 0ms [ User: symmetricds - Total duration: 784ms - Times executed: 11408 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 784ms - Times executed: 11408 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-19 14:58:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 14:04:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:00:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 8,552 289ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 19 00 358 12ms 0ms 01 360 12ms 0ms 02 360 12ms 0ms 03 360 12ms 0ms 04 360 12ms 0ms 05 359 12ms 0ms 06 360 12ms 0ms 07 360 12ms 0ms 08 360 12ms 0ms 09 360 11ms 0ms 10 360 11ms 0ms 11 360 12ms 0ms 12 359 12ms 0ms 13 360 12ms 0ms 14 360 12ms 0ms 15 360 11ms 0ms 16 360 11ms 0ms 17 359 12ms 0ms 18 354 12ms 0ms 19 359 11ms 0ms 20 360 11ms 0ms 21 352 11ms 0ms 22 326 9ms 0ms 23 326 10ms 0ms [ User: symmetricds - Total duration: 289ms - Times executed: 8552 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 289ms - Times executed: 8552 ]
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
Date: 2018-05-19 10:13:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:49:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:18:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 8,507 199ms 0ms 0ms 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 #11
Day Hour Count Duration Avg duration May 19 00 358 9ms 0ms 01 359 9ms 0ms 02 359 9ms 0ms 03 358 9ms 0ms 04 359 9ms 0ms 05 359 9ms 0ms 06 357 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 357 8ms 0ms 10 358 8ms 0ms 11 357 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 357 7ms 0ms 15 358 7ms 0ms 16 357 7ms 0ms 17 358 7ms 0ms 18 351 7ms 0ms 19 358 7ms 0ms 20 357 7ms 0ms 21 350 7ms 0ms 22 324 7ms 0ms 23 324 7ms 0ms [ User: symmetricds - Total duration: 199ms - Times executed: 8507 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 199ms - Times executed: 8507 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83472702' AND data_id <= '133472701' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83471944' AND data_id <= '133471943' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83472370' AND data_id <= '133472369' ORDER BY data_id ASC;
Date: 2018-05-19 05:20:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 02:40:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 04:20:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,499 480ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 19 00 356 20ms 0ms 01 357 21ms 0ms 02 358 21ms 0ms 03 358 20ms 0ms 04 357 21ms 0ms 05 358 22ms 0ms 06 357 22ms 0ms 07 358 19ms 0ms 08 358 20ms 0ms 09 357 19ms 0ms 10 358 20ms 0ms 11 357 19ms 0ms 12 358 19ms 0ms 13 358 20ms 0ms 14 357 19ms 0ms 15 358 19ms 0ms 16 357 19ms 0ms 17 358 19ms 0ms 18 351 18ms 0ms 19 358 19ms 0ms 20 357 19ms 0ms 21 350 19ms 0ms 22 324 17ms 0ms 23 324 18ms 0ms [ User: symmetricds - Total duration: 480ms - Times executed: 8499 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 480ms - Times executed: 8499 ]
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
Date: 2018-05-19 13:08:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:11:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 06:41:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 7,130 678ms 0ms 2ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 00 300 26ms 0ms 01 300 29ms 0ms 02 300 31ms 0ms 03 300 32ms 0ms 04 300 36ms 0ms 05 300 31ms 0ms 06 300 31ms 0ms 07 300 26ms 0ms 08 300 31ms 0ms 09 300 26ms 0ms 10 300 27ms 0ms 11 300 30ms 0ms 12 300 27ms 0ms 13 300 26ms 0ms 14 300 27ms 0ms 15 300 24ms 0ms 16 300 24ms 0ms 17 300 28ms 0ms 18 295 27ms 0ms 19 300 29ms 0ms 20 295 26ms 0ms 21 295 27ms 0ms 22 270 25ms 0ms 23 275 23ms 0ms [ User: symmetricds - Total duration: 678ms - Times executed: 7130 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 678ms - Times executed: 7130 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-05-19 04:34:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 14:26:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:28:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 5,744 1s168ms 0ms 1ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 19 00 249 49ms 0ms 01 241 46ms 0ms 02 243 50ms 0ms 03 241 53ms 0ms 04 244 50ms 0ms 05 243 51ms 0ms 06 242 50ms 0ms 07 241 50ms 0ms 08 241 48ms 0ms 09 240 48ms 0ms 10 242 48ms 0ms 11 240 47ms 0ms 12 241 49ms 0ms 13 240 49ms 0ms 14 242 53ms 0ms 15 242 47ms 0ms 16 241 47ms 0ms 17 240 47ms 0ms 18 235 49ms 0ms 19 241 47ms 0ms 20 236 46ms 0ms 21 236 46ms 0ms 22 220 43ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s168ms - Times executed: 5744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s168ms - Times executed: 5744 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-19 12:37:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:25:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 16:09:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 5,728 235ms 0ms 0ms 0ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 19 00 265 10ms 0ms 01 240 10ms 0ms 02 240 10ms 0ms 03 240 10ms 0ms 04 240 10ms 0ms 05 240 10ms 0ms 06 240 10ms 0ms 07 240 9ms 0ms 08 240 9ms 0ms 09 240 9ms 0ms 10 240 10ms 0ms 11 240 9ms 0ms 12 240 10ms 0ms 13 240 9ms 0ms 14 240 11ms 0ms 15 240 10ms 0ms 16 240 10ms 0ms 17 240 9ms 0ms 18 236 9ms 0ms 19 240 9ms 0ms 20 236 9ms 0ms 21 236 9ms 0ms 22 216 8ms 0ms 23 219 8ms 0ms [ User: symmetricds - Total duration: 235ms - Times executed: 5728 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 235ms - Times executed: 5728 ]
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
Date: 2018-05-19 14:22:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:50:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 16:05:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,704 768ms 0ms 5ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 19 00 240 34ms 0ms 01 240 32ms 0ms 02 240 33ms 0ms 03 240 31ms 0ms 04 240 31ms 0ms 05 240 32ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 30ms 0ms 09 240 31ms 0ms 10 240 31ms 0ms 11 240 31ms 0ms 12 240 32ms 0ms 13 240 33ms 0ms 14 240 32ms 0ms 15 240 32ms 0ms 16 240 31ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 30ms 0ms 20 236 30ms 0ms 21 236 35ms 0ms 22 216 28ms 0ms 23 220 29ms 0ms [ User: symmetricds - Total duration: 768ms - Times executed: 5704 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 768ms - Times executed: 5704 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '71', success_count = '115099', fail_count = '0', total_success_count = '115099', total_fail_count = '0', total_success_millis = '6748670', total_fail_millis = '0', last_lock_time = '2018-05-19 21:54:05.614' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '76', success_count = '115172', fail_count = '0', total_success_count = '115172', total_fail_count = '0', total_success_millis = '7093942', total_fail_millis = '0', last_lock_time = '2018-05-19 22:43:11.181' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '72', success_count = '114935', fail_count = '0', total_success_count = '114935', total_fail_count = '0', total_success_millis = '6402375', total_fail_millis = '0', last_lock_time = '2018-05-19 13:41:42.394' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-05-19 21:55:04 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:43:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 13:41:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,703 898ms 0ms 5ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 19 00 240 38ms 0ms 01 240 36ms 0ms 02 240 35ms 0ms 03 240 36ms 0ms 04 240 43ms 0ms 05 240 38ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 36ms 0ms 09 240 36ms 0ms 10 240 37ms 0ms 11 240 39ms 0ms 12 240 40ms 0ms 13 240 37ms 0ms 14 240 38ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 36ms 0ms 18 236 37ms 0ms 19 240 35ms 0ms 20 236 35ms 0ms 21 236 36ms 0ms 22 216 31ms 0ms 23 219 33ms 0ms [ User: symmetricds - Total duration: 898ms - Times executed: 5703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 898ms - Times executed: 5703 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 04:30:27.779', last_lock_time = '2018-05-19 04:30:27.779' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 02:30:27.779');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 21:02:02.986', last_lock_time = '2018-05-19 21:02:02.986' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 19:02:02.986');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 11:56:39.776', last_lock_time = '2018-05-19 11:56:39.776' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 09:56:39.776');
Date: 2018-05-19 04:30:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:02:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:56:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,703 427ms 0ms 0ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 00 240 18ms 0ms 01 240 17ms 0ms 02 240 18ms 0ms 03 240 19ms 0ms 04 240 19ms 0ms 05 240 17ms 0ms 06 240 17ms 0ms 07 240 18ms 0ms 08 240 16ms 0ms 09 240 17ms 0ms 10 240 18ms 0ms 11 240 17ms 0ms 12 240 17ms 0ms 13 240 17ms 0ms 14 240 16ms 0ms 15 240 17ms 0ms 16 240 17ms 0ms 17 240 16ms 0ms 18 236 18ms 0ms 19 240 17ms 0ms 20 236 18ms 0ms 21 236 18ms 0ms 22 216 15ms 0ms 23 219 17ms 0ms [ User: symmetricds - Total duration: 427ms - Times executed: 5703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 427ms - Times executed: 5703 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-05-19 23:37:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 04:48:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:31:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,317 338ms 0ms 0ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 19 00 600 36ms 0ms 01 794 50ms 0ms 02 576 43ms 0ms 03 436 32ms 0ms 04 704 47ms 0ms 05 554 37ms 0ms 06 44 5ms 0ms 07 36 5ms 0ms 08 36 4ms 0ms 09 36 4ms 0ms 10 36 5ms 0ms 11 36 4ms 0ms 12 42 5ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 5ms 0ms 18 36 4ms 0ms 19 36 5ms 0ms 20 27 4ms 0ms 21 36 5ms 0ms 22 36 5ms 0ms 23 36 5ms 0ms [ User: symmetricds - Total duration: 338ms - Times executed: 4317 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 338ms - Times executed: 4317 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83473050', '7534135', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83471230', '7533812', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83471396', '7533828', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2018-05-19 17:56:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:08:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:53:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 3,433 271ms 0ms 1ms 0ms SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '' ORDER BY channel_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 00 196 15ms 0ms 01 152 11ms 0ms 02 150 12ms 0ms 03 151 11ms 0ms 04 150 11ms 0ms 05 150 11ms 0ms 06 142 10ms 0ms 07 139 12ms 0ms 08 139 11ms 0ms 09 142 11ms 0ms 10 138 9ms 0ms 11 140 11ms 0ms 12 144 12ms 0ms 13 140 12ms 0ms 14 138 10ms 0ms 15 138 10ms 0ms 16 139 10ms 0ms 17 140 11ms 0ms 18 138 10ms 0ms 19 140 10ms 0ms 20 132 9ms 0ms 21 138 13ms 0ms 22 128 8ms 0ms 23 129 9ms 0ms [ User: symmetricds - Total duration: 271ms - Times executed: 3433 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 271ms - Times executed: 3433 ]
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
Date: 2018-05-19 21:09:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:16:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:52:58 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 0ms 120ms 16ms 163 2s710ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 19 00 14 101ms 7ms 01 14 104ms 7ms 02 14 96ms 6ms 03 14 116ms 8ms 04 14 97ms 6ms 05 14 102ms 7ms 06 14 258ms 18ms 07 11 218ms 19ms 08 9 104ms 11ms 09 8 435ms 54ms 10 7 161ms 23ms 11 6 173ms 28ms 12 5 171ms 34ms 13 4 137ms 34ms 14 3 112ms 37ms 15 2 72ms 36ms 16 2 47ms 23ms 17 2 45ms 22ms 18 1 15ms 15ms 19 1 21ms 21ms 20 1 11ms 11ms 21 1 49ms 49ms 22 1 23ms 23ms 23 1 30ms 30ms [ User: symmetricds - Total duration: 2s710ms - Times executed: 163 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s710ms - Times executed: 163 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '83436816' AND '83441816' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83436816' AND '83441816' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '83442186' AND '83447186' AND create_time < '2018-05-18 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '83441817' AND '83446817' AND create_time < '2018-05-18 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83441817' AND '83446817' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-05-19 09:00:00 Duration: 120ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:00:00 Duration: 91ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 1ms 13ms 6ms 189 1s217ms 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" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 00 8 38ms 4ms 01 8 55ms 6ms 02 8 47ms 5ms 03 8 56ms 7ms 04 8 35ms 4ms 05 8 55ms 6ms 06 8 51ms 6ms 07 8 55ms 6ms 08 8 41ms 5ms 09 8 44ms 5ms 10 8 61ms 7ms 11 8 55ms 6ms 12 8 55ms 6ms 13 8 33ms 4ms 14 8 51ms 6ms 15 8 55ms 6ms 16 8 56ms 7ms 17 8 50ms 6ms 18 8 55ms 6ms 19 8 51ms 6ms 20 5 41ms 8ms 21 8 50ms 6ms 22 8 62ms 7ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s217ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s217ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '193755176', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:25:44', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '436445752', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:36:53', "last_restart_time" = '2018-05-17 16:07:48', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '182956112', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-19 18:10:44', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-05-19 18:26:27 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 18:38:28 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 18:11:26 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 10ms 5ms 202 1s42ms 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 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 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 - 0 ] & 0 WHEN 0 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 May 19 00 166 832ms 5ms 01 3 13ms 4ms 02 2 17ms 8ms 03 3 17ms 5ms 04 3 13ms 4ms 05 3 13ms 4ms 06 3 13ms 4ms 07 1 4ms 4ms 08 1 4ms 4ms 09 2 12ms 6ms 10 1 4ms 4ms 11 1 8ms 8ms 12 2 13ms 6ms 13 1 8ms 8ms 14 1 4ms 4ms 15 1 4ms 4ms 16 1 4ms 4ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 8ms 8ms 20 1 8ms 8ms 21 1 8ms 8ms 22 1 8ms 8ms 23 1 10ms 10ms [ User: symmetricds - Total duration: 1s42ms - Times executed: 202 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s42ms - Times executed: 202 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' 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 = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-05-19 23:09:20 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:00:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 15ms 4ms 163 714ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 19 00 14 70ms 5ms 01 14 69ms 4ms 02 14 66ms 4ms 03 14 65ms 4ms 04 14 68ms 4ms 05 14 68ms 4ms 06 14 56ms 4ms 07 11 43ms 3ms 08 9 34ms 3ms 09 8 28ms 3ms 10 7 46ms 6ms 11 6 16ms 2ms 12 5 23ms 4ms 13 4 18ms 4ms 14 3 9ms 3ms 15 2 6ms 3ms 16 2 4ms 2ms 17 2 3ms 1ms 18 1 1ms 1ms 19 1 2ms 2ms 20 1 1ms 1ms 21 1 4ms 4ms 22 1 2ms 2ms 23 1 2ms 2ms [ User: symmetricds - Total duration: 714ms - Times executed: 163 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 714ms - Times executed: 163 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '83447187' AND '83452187' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 10:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83447187' AND '83452187');
-
DELETE FROM sym_data WHERE data_id BETWEEN '83442186' AND '83447186' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 10:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83442186' AND '83447186');
-
DELETE FROM sym_data WHERE data_id BETWEEN '83451890' AND '83456890' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-05-18 12:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '83451890' AND '83456890');
Date: 2018-05-19 10:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 2ms 1ms 508 762ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 19 00 22 31ms 1ms 01 25 35ms 1ms 02 21 31ms 1ms 03 23 35ms 1ms 04 21 31ms 1ms 05 23 34ms 1ms 06 25 37ms 1ms 07 25 37ms 1ms 08 22 32ms 1ms 09 25 37ms 1ms 10 22 33ms 1ms 11 18 27ms 1ms 12 18 27ms 1ms 13 15 22ms 1ms 14 13 19ms 1ms 15 19 28ms 1ms 16 21 31ms 1ms 17 19 28ms 1ms 18 23 33ms 1ms 19 26 39ms 1ms 20 29 44ms 1ms 21 29 45ms 1ms 22 14 20ms 1ms 23 10 14ms 1ms [ User: symmetricds - Total duration: 762ms - Times executed: 508 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 762ms - Times executed: 508 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 12:14:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:06:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:03:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 18ms 1ms 771 884ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 19 00 32 32ms 1ms 01 32 33ms 1ms 02 25 32ms 1ms 03 31 31ms 1ms 04 28 38ms 1ms 05 31 30ms 0ms 06 28 29ms 1ms 07 31 35ms 1ms 08 26 29ms 1ms 09 32 31ms 0ms 10 37 57ms 1ms 11 24 43ms 1ms 12 23 37ms 1ms 13 18 17ms 0ms 14 22 26ms 1ms 15 25 27ms 1ms 16 26 28ms 1ms 17 24 24ms 1ms 18 29 32ms 1ms 19 55 55ms 1ms 20 44 45ms 1ms 21 55 56ms 1ms 22 51 53ms 1ms 23 42 53ms 1ms [ User: symmetricds - Total duration: 884ms - Times executed: 771 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 884ms - Times executed: 771 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 11:18:38 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:34:40 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 10:16:37 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 7ms 1ms 656 689ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 19 00 26 25ms 0ms 01 25 24ms 0ms 02 23 25ms 1ms 03 28 28ms 1ms 04 20 20ms 1ms 05 26 27ms 1ms 06 24 27ms 1ms 07 27 27ms 1ms 08 23 22ms 0ms 09 29 30ms 1ms 10 33 35ms 1ms 11 22 22ms 1ms 12 20 19ms 0ms 13 15 14ms 0ms 14 18 18ms 1ms 15 23 26ms 1ms 16 22 22ms 1ms 17 20 21ms 1ms 18 23 22ms 0ms 19 50 55ms 1ms 20 38 41ms 1ms 21 45 43ms 0ms 22 41 39ms 0ms 23 35 47ms 1ms [ User: symmetricds - Total duration: 689ms - Times executed: 656 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 689ms - Times executed: 656 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 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), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 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), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-19 23:07:43 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 19:09:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 23:03:23 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 14ms 0ms 1,731 1s142ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 19 00 282 175ms 0ms 01 379 236ms 0ms 02 270 184ms 0ms 03 200 138ms 0ms 04 334 225ms 0ms 05 259 164ms 0ms 06 4 9ms 2ms 12 3 8ms 2ms [ User: pharmisight - Total duration: 1s142ms - Times executed: 1731 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s142ms - Times executed: 1731 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003977359', '2018-05-19 04:28:18', 'RYBAKJ', '2018-05-19 04:40:00.03', '40832', '6', '150505230115232238');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003989791', '2018-05-19 02:39:32', 'ARKADIUSZC', '2018-05-19 03:00:00.034', '54548', '8', '150505230115224653');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003992252', '2018-05-19 03:39:08', 'KWAPIENM', '2018-05-19 04:00:00.034', '110638', '24', '31237090251936005');
Date: 2018-05-19 04:40:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 04:00:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 5,744 1s168ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 00 249 49ms 0ms 01 241 46ms 0ms 02 243 50ms 0ms 03 241 53ms 0ms 04 244 50ms 0ms 05 243 51ms 0ms 06 242 50ms 0ms 07 241 50ms 0ms 08 241 48ms 0ms 09 240 48ms 0ms 10 242 48ms 0ms 11 240 47ms 0ms 12 241 49ms 0ms 13 240 49ms 0ms 14 242 53ms 0ms 15 242 47ms 0ms 16 241 47ms 0ms 17 240 47ms 0ms 18 235 49ms 0ms 19 241 47ms 0ms 20 236 46ms 0ms 21 236 46ms 0ms 22 220 43ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s168ms - Times executed: 5744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s168ms - Times executed: 5744 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-19 12:37:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:25:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 16:09:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 5ms 0ms 5,703 898ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 19 00 240 38ms 0ms 01 240 36ms 0ms 02 240 35ms 0ms 03 240 36ms 0ms 04 240 43ms 0ms 05 240 38ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 36ms 0ms 09 240 36ms 0ms 10 240 37ms 0ms 11 240 39ms 0ms 12 240 40ms 0ms 13 240 37ms 0ms 14 240 38ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 36ms 0ms 18 236 37ms 0ms 19 240 35ms 0ms 20 236 35ms 0ms 21 236 36ms 0ms 22 216 31ms 0ms 23 219 33ms 0ms [ User: symmetricds - Total duration: 898ms - Times executed: 5703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 898ms - Times executed: 5703 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 04:30:27.779', last_lock_time = '2018-05-19 04:30:27.779' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 02:30:27.779');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 21:02:02.986', last_lock_time = '2018-05-19 21:02:02.986' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 19:02:02.986');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-19 11:56:39.776', last_lock_time = '2018-05-19 11:56:39.776' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-19 09:56:39.776');
Date: 2018-05-19 04:30:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:02:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:56:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 5ms 0ms 5,704 768ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 19 00 240 34ms 0ms 01 240 32ms 0ms 02 240 33ms 0ms 03 240 31ms 0ms 04 240 31ms 0ms 05 240 32ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 30ms 0ms 09 240 31ms 0ms 10 240 31ms 0ms 11 240 31ms 0ms 12 240 32ms 0ms 13 240 33ms 0ms 14 240 32ms 0ms 15 240 32ms 0ms 16 240 31ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 30ms 0ms 20 236 30ms 0ms 21 236 35ms 0ms 22 216 28ms 0ms 23 220 29ms 0ms [ User: symmetricds - Total duration: 768ms - Times executed: 5704 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 768ms - Times executed: 5704 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '71', success_count = '115099', fail_count = '0', total_success_count = '115099', total_fail_count = '0', total_success_millis = '6748670', total_fail_millis = '0', last_lock_time = '2018-05-19 21:54:05.614' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '76', success_count = '115172', fail_count = '0', total_success_count = '115172', total_fail_count = '0', total_success_millis = '7093942', total_fail_millis = '0', last_lock_time = '2018-05-19 22:43:11.181' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '72', success_count = '114935', fail_count = '0', total_success_count = '114935', total_fail_count = '0', total_success_millis = '6402375', total_fail_millis = '0', last_lock_time = '2018-05-19 13:41:42.394' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-05-19 21:55:04 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 22:43:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 13:41:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 7,130 678ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 19 00 300 26ms 0ms 01 300 29ms 0ms 02 300 31ms 0ms 03 300 32ms 0ms 04 300 36ms 0ms 05 300 31ms 0ms 06 300 31ms 0ms 07 300 26ms 0ms 08 300 31ms 0ms 09 300 26ms 0ms 10 300 27ms 0ms 11 300 30ms 0ms 12 300 27ms 0ms 13 300 26ms 0ms 14 300 27ms 0ms 15 300 24ms 0ms 16 300 24ms 0ms 17 300 28ms 0ms 18 295 27ms 0ms 19 300 29ms 0ms 20 295 26ms 0ms 21 295 27ms 0ms 22 270 25ms 0ms 23 275 23ms 0ms [ User: symmetricds - Total duration: 678ms - Times executed: 7130 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 678ms - Times executed: 7130 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-05-19 04:34:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 14:26:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:28:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 3,433 271ms SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '' ORDER BY channel_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 00 196 15ms 0ms 01 152 11ms 0ms 02 150 12ms 0ms 03 151 11ms 0ms 04 150 11ms 0ms 05 150 11ms 0ms 06 142 10ms 0ms 07 139 12ms 0ms 08 139 11ms 0ms 09 142 11ms 0ms 10 138 9ms 0ms 11 140 11ms 0ms 12 144 12ms 0ms 13 140 12ms 0ms 14 138 10ms 0ms 15 138 10ms 0ms 16 139 10ms 0ms 17 140 11ms 0ms 18 138 10ms 0ms 19 140 10ms 0ms 20 132 9ms 0ms 21 138 13ms 0ms 22 128 8ms 0ms 23 129 9ms 0ms [ User: symmetricds - Total duration: 271ms - Times executed: 3433 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 271ms - Times executed: 3433 ]
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
Date: 2018-05-19 21:09:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:16:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 21:52:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 4,317 338ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 19 00 600 36ms 0ms 01 794 50ms 0ms 02 576 43ms 0ms 03 436 32ms 0ms 04 704 47ms 0ms 05 554 37ms 0ms 06 44 5ms 0ms 07 36 5ms 0ms 08 36 4ms 0ms 09 36 4ms 0ms 10 36 5ms 0ms 11 36 4ms 0ms 12 42 5ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 5ms 0ms 18 36 4ms 0ms 19 36 5ms 0ms 20 27 4ms 0ms 21 36 5ms 0ms 22 36 5ms 0ms 23 36 5ms 0ms [ User: symmetricds - Total duration: 338ms - Times executed: 4317 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 338ms - Times executed: 4317 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83473050', '7534135', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83471230', '7533812', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('83471396', '7533828', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2018-05-19 17:56:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:08:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:53:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 5,703 427ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 19 00 240 18ms 0ms 01 240 17ms 0ms 02 240 18ms 0ms 03 240 19ms 0ms 04 240 19ms 0ms 05 240 17ms 0ms 06 240 17ms 0ms 07 240 18ms 0ms 08 240 16ms 0ms 09 240 17ms 0ms 10 240 18ms 0ms 11 240 17ms 0ms 12 240 17ms 0ms 13 240 17ms 0ms 14 240 16ms 0ms 15 240 17ms 0ms 16 240 17ms 0ms 17 240 16ms 0ms 18 236 18ms 0ms 19 240 17ms 0ms 20 236 18ms 0ms 21 236 18ms 0ms 22 216 15ms 0ms 23 219 17ms 0ms [ User: symmetricds - Total duration: 427ms - Times executed: 5703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 427ms - Times executed: 5703 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-05-19 23:37:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 04:48:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:31:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 11,408 784ms 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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 19 00 481 31ms 0ms 01 480 32ms 0ms 02 480 35ms 0ms 03 480 34ms 0ms 04 480 31ms 0ms 05 480 33ms 0ms 06 480 30ms 0ms 07 480 33ms 0ms 08 480 31ms 0ms 09 480 33ms 0ms 10 480 35ms 0ms 11 480 32ms 0ms 12 480 32ms 0ms 13 480 34ms 0ms 14 480 36ms 0ms 15 480 32ms 0ms 16 480 30ms 0ms 17 480 33ms 0ms 18 472 32ms 0ms 19 480 32ms 0ms 20 472 33ms 0ms 21 472 32ms 0ms 22 432 29ms 0ms 23 439 30ms 0ms [ User: symmetricds - Total duration: 784ms - Times executed: 11408 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 784ms - Times executed: 11408 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-19 14:58:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 14:04:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 07:00:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 8,499 480ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 19 00 356 20ms 0ms 01 357 21ms 0ms 02 358 21ms 0ms 03 358 20ms 0ms 04 357 21ms 0ms 05 358 22ms 0ms 06 357 22ms 0ms 07 358 19ms 0ms 08 358 20ms 0ms 09 357 19ms 0ms 10 358 20ms 0ms 11 357 19ms 0ms 12 358 19ms 0ms 13 358 20ms 0ms 14 357 19ms 0ms 15 358 19ms 0ms 16 357 19ms 0ms 17 358 19ms 0ms 18 351 18ms 0ms 19 358 19ms 0ms 20 357 19ms 0ms 21 350 19ms 0ms 22 324 17ms 0ms 23 324 18ms 0ms [ User: symmetricds - Total duration: 480ms - Times executed: 8499 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 480ms - Times executed: 8499 ]
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
Date: 2018-05-19 13:08:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 11:11:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 06:41:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 2ms 0ms 15,864 827ms 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 WHERE node_id = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 00 693 36ms 0ms 01 668 34ms 0ms 02 669 34ms 0ms 03 669 34ms 0ms 04 668 35ms 0ms 05 669 34ms 0ms 06 666 34ms 0ms 07 666 34ms 0ms 08 666 34ms 0ms 09 666 34ms 0ms 10 666 34ms 0ms 11 665 37ms 0ms 12 667 36ms 0ms 13 666 34ms 0ms 14 665 34ms 0ms 15 666 34ms 0ms 16 665 32ms 0ms 17 666 32ms 0ms 18 654 34ms 0ms 19 666 37ms 0ms 20 657 34ms 0ms 21 653 34ms 0ms 22 602 30ms 0ms 23 606 33ms 0ms [ User: symmetricds - Total duration: 827ms - Times executed: 15864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 827ms - Times executed: 15864 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-19 11:00:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 12:31:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 06:38:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 76,491 3s593ms 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 May 19 00 3,204 149ms 0ms 01 3,213 149ms 0ms 02 3,222 153ms 0ms 03 3,222 149ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 3,213 153ms 0ms 07 3,222 148ms 0ms 08 3,222 150ms 0ms 09 3,213 153ms 0ms 10 3,222 152ms 0ms 11 3,213 148ms 0ms 12 3,222 150ms 0ms 13 3,222 151ms 0ms 14 3,213 152ms 0ms 15 3,222 149ms 0ms 16 3,213 147ms 0ms 17 3,222 151ms 0ms 18 3,159 150ms 0ms 19 3,222 152ms 0ms 20 3,213 150ms 0ms 21 3,150 150ms 0ms 22 2,916 138ms 0ms 23 2,916 138ms 0ms [ User: symmetricds - Total duration: 3s593ms - Times executed: 76491 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s593ms - Times executed: 76491 ]
-
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: 2018-05-19 20:25:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 09:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 00:45:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 5,728 235ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 00 265 10ms 0ms 01 240 10ms 0ms 02 240 10ms 0ms 03 240 10ms 0ms 04 240 10ms 0ms 05 240 10ms 0ms 06 240 10ms 0ms 07 240 9ms 0ms 08 240 9ms 0ms 09 240 9ms 0ms 10 240 10ms 0ms 11 240 9ms 0ms 12 240 10ms 0ms 13 240 9ms 0ms 14 240 11ms 0ms 15 240 10ms 0ms 16 240 10ms 0ms 17 240 9ms 0ms 18 236 9ms 0ms 19 240 9ms 0ms 20 236 9ms 0ms 21 236 9ms 0ms 22 216 8ms 0ms 23 219 8ms 0ms [ User: symmetricds - Total duration: 235ms - Times executed: 5728 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 235ms - Times executed: 5728 ]
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
Date: 2018-05-19 14:22:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 03:50:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-19 16:05:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,223,480 Log entries
Events distribution
Key values
- 0 PANIC entries
- 7 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 8 Total events found
Rank Times reported Error 1 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count May 19 00 2 17 1 - FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "template0", SSL off
- FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "-h", SSL off
- FATAL: no pg_hba.conf entry for host "93.170.89.4", user "postgres", database "postgres", SSL off
Date: 2018-05-19 00:22:07 Database: template0 Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
Date: 2018-05-19 00:22:08 Database: -h Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
Date: 2018-05-19 17:29:12 Database: postgres Application: [unknown] User: postgres Remote: 93.170.89.4 Code:
2 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #2
Day Hour Count May 19 00 2 - FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "template0", SSL on
- FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "-h", SSL on
Date: 2018-05-19 00:22:07 Database: template0 Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
Date: 2018-05-19 00:22:08 Database: -h Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
3 2 FATAL: unsupported frontend protocol 65363.19778: server supports 1.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count May 19 00 1 13 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 1.0 to 3.0
Date: 2018-05-19 13:59:32 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.228.45.246 Code:
4 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 19 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-05-19 00:00:08 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: