pgBadger-
Global information
- Generated on Sun Jun 10 00:00:41 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,296,177 log entries in 38s
- Log start from 2018-06-08 23:59:59 to 2018-06-09 23:59:59
-
Overview
Global Stats
- 166 Number of unique normalized queries
- 2,176,471 Number of queries
- 1m8s Total query duration
- 2018-06-09 00:00:00 First query
- 2018-06-09 23:59:59 Last query
- 1,040 queries/s at 2018-06-09 00:00:21 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 229 Total number of automatic vacuums
- 306 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,542 Total number of sessions
- 1 sessions at 2018-06-09 14:46:03 Session peak
- 10d1h47m28s Total duration of sessions
- 9m24s Average duration of sessions
- 1,411 Average queries per session
- 44ms Average queries duration per session
- 1,542 Total number of connections
- 5 connections/s at 2018-06-09 00:19:33 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,040 queries/s Query Peak
- 2018-06-09 00:00:21 Date
SELECT Traffic
Key values
- 493 queries/s Query Peak
- 2018-06-09 00:00:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 546 queries/s Query Peak
- 2018-06-09 00:00:21 Date
Queries duration
Key values
- 1m8s Total query duration
Prepared queries ratio
Key values
- 1.65 Ratio of bind vs prepare
- 166.47 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jun 09 00 101,722 0ms 25ms 0ms 84ms 140ms 1s898ms 01 91,760 0ms 19ms 0ms 61ms 144ms 292ms 02 91,921 0ms 23ms 0ms 58ms 118ms 427ms 03 92,430 0ms 18ms 0ms 61ms 187ms 374ms 04 91,983 0ms 22ms 0ms 76ms 132ms 340ms 05 92,287 0ms 22ms 0ms 73ms 144ms 363ms 06 90,333 0ms 107ms 0ms 55ms 61ms 669ms 07 89,768 0ms 98ms 0ms 54ms 63ms 477ms 08 89,826 0ms 63ms 0ms 57ms 71ms 282ms 09 89,628 0ms 119ms 0ms 59ms 69ms 570ms 10 89,742 0ms 88ms 0ms 60ms 69ms 270ms 11 89,603 0ms 87ms 0ms 55ms 58ms 318ms 12 89,720 0ms 76ms 0ms 55ms 71ms 263ms 13 89,770 0ms 74ms 0ms 56ms 64ms 248ms 14 89,591 0ms 78ms 0ms 57ms 74ms 205ms 15 89,727 0ms 61ms 0ms 59ms 65ms 172ms 16 89,568 0ms 46ms 0ms 59ms 62ms 121ms 17 89,734 0ms 44ms 0ms 59ms 67ms 141ms 18 89,726 0ms 33ms 0ms 56ms 68ms 121ms 19 89,682 0ms 18ms 0ms 57ms 63ms 75ms 20 89,352 0ms 28ms 0ms 58ms 69ms 144ms 21 89,460 0ms 18ms 0ms 54ms 63ms 77ms 22 89,401 0ms 27ms 0ms 55ms 69ms 84ms 23 89,737 0ms 24ms 0ms 56ms 68ms 92ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 23 0 0 0ms 0ms 0ms 0ms Jun 09 00 33,340 0 0ms 31ms 41ms 54ms 01 29,189 0 0ms 31ms 36ms 48ms 02 29,143 0 0ms 32ms 35ms 45ms 03 29,328 0 0ms 32ms 41ms 44ms 04 29,151 0 0ms 28ms 32ms 44ms 05 29,346 0 0ms 28ms 34ms 56ms 06 28,831 0 0ms 27ms 31ms 35ms 07 28,684 0 0ms 27ms 32ms 42ms 08 28,736 0 0ms 27ms 34ms 37ms 09 28,651 0 0ms 28ms 34ms 39ms 10 28,676 0 0ms 27ms 32ms 41ms 11 28,637 0 0ms 27ms 33ms 37ms 12 28,670 0 0ms 28ms 33ms 37ms 13 28,693 0 0ms 28ms 32ms 39ms 14 28,627 0 0ms 28ms 39ms 42ms 15 28,661 0 0ms 28ms 39ms 40ms 16 28,604 0 0ms 28ms 31ms 40ms 17 28,660 0 0ms 28ms 31ms 33ms 18 28,658 0 0ms 28ms 32ms 33ms 19 28,685 0 0ms 28ms 31ms 32ms 20 28,561 0 0ms 28ms 32ms 35ms 21 28,566 0 0ms 27ms 30ms 34ms 22 28,546 0 0ms 28ms 31ms 33ms 23 28,655 0 0ms 28ms 32ms 34ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 23 0 0 0 0 0ms 0ms 0ms 0ms Jun 09 00 1,498 1,837 97 0 0ms 9ms 14ms 83ms 01 1,004 852 100 0 0ms 1ms 9ms 54ms 02 1,104 877 96 0 0ms 1ms 9ms 86ms 03 1,355 940 98 0 0ms 1ms 9ms 70ms 04 1,227 908 96 0 0ms 1ms 9ms 61ms 05 1,232 909 99 0 0ms 2ms 10ms 55ms 06 376 667 96 0 0ms 1ms 8ms 12ms 07 72 576 91 0 0ms 1ms 9ms 11ms 08 72 578 82 0 0ms 1ms 8ms 11ms 09 72 577 80 0 0ms 1ms 8ms 11ms 10 72 577 78 0 0ms 1ms 9ms 11ms 11 72 577 80 0 0ms 1ms 4ms 10ms 12 72 577 75 0 0ms 1ms 8ms 10ms 13 72 577 76 0 0ms 1ms 3ms 10ms 14 72 576 74 0 0ms 1ms 3ms 11ms 15 72 578 72 0 0ms 1ms 3ms 11ms 16 72 577 71 0 0ms 1ms 9ms 11ms 17 72 578 73 0 0ms 1ms 5ms 11ms 18 72 577 69 0 0ms 1ms 3ms 11ms 19 73 589 66 0 0ms 1ms 8ms 11ms 20 60 573 72 0 0ms 1ms 2ms 11ms 21 66 571 65 0 0ms 1ms 2ms 11ms 22 68 573 67 0 0ms 1ms 2ms 11ms 23 72 577 68 0 0ms 1ms 2ms 11ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 08 23 0 0 0.00 0.00% Jun 09 00 59,976 101,686 1.70 94.38% 01 55,437 91,724 1.65 99.87% 02 55,028 91,885 1.67 98.92% 03 55,485 92,394 1.67 98.85% 04 55,230 91,947 1.66 99.07% 05 55,586 92,251 1.66 99.29% 06 54,797 90,297 1.65 101.11% 07 54,544 89,732 1.65 101.71% 08 54,972 89,790 1.63 102.43% 09 54,660 89,592 1.64 102.08% 10 54,593 89,706 1.64 101.85% 11 54,482 89,567 1.64 101.78% 12 54,641 89,684 1.64 101.96% 13 54,772 89,734 1.64 102.15% 14 54,529 89,555 1.64 101.90% 15 54,511 89,691 1.65 101.73% 16 54,308 89,532 1.65 101.54% 17 54,456 89,698 1.65 101.63% 18 54,527 89,690 1.64 101.78% 19 54,713 89,646 1.64 102.13% 20 54,035 89,316 1.65 101.30% 21 54,131 89,424 1.65 101.39% 22 54,062 89,365 1.65 101.31% 23 54,265 89,701 1.65 101.29% Day Hour Count Average / Second Jun 08 23 0 0.00/s Jun 09 00 66 0.02/s 01 69 0.02/s 02 59 0.02/s 03 63 0.02/s 04 59 0.02/s 05 69 0.02/s 06 64 0.02/s 07 59 0.02/s 08 71 0.02/s 09 63 0.02/s 10 62 0.02/s 11 59 0.02/s 12 60 0.02/s 13 67 0.02/s 14 63 0.02/s 15 61 0.02/s 16 62 0.02/s 17 64 0.02/s 18 65 0.02/s 19 75 0.02/s 20 64 0.02/s 21 67 0.02/s 22 65 0.02/s 23 66 0.02/s Day Hour Count Average Duration Jun 08 23 0 0ms Jun 09 00 66 9m25s 01 69 9m15s 02 59 9m18s 03 63 9m52s 04 59 10m35s 05 69 8m51s 06 64 8m49s 07 59 9m30s 08 71 9m6s 09 63 9m47s 10 59 9m59s 11 62 9m33s 12 60 10m44s 13 67 8m42s 14 63 9m22s 15 61 9m50s 16 62 9m37s 17 64 9m49s 18 65 9m32s 19 75 7m51s 20 64 9m12s 21 67 9m21s 22 65 8m56s 23 66 9m20s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2018-06-09 00:19:33 Date
Connections per database
Key values
- pharmisight Main Database
- 1,542 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,542 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2018-06-09 14:46:03 Date
Histogram of session times
Key values
- 752 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,542 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,542 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,542 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,036 buffers Checkpoint Peak
- 2018-06-09 06:05:19 Date
- 149.922 seconds Highest write time
- 0.010 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2018-06-09 06:07:50 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 Jun 08 23 0 0s 0s 0s Jun 09 00 1,811 181.609s 0.013s 181.665s 01 947 95.024s 0.012s 95.079s 02 865 86.689s 0.015s 86.755s 03 912 91.525s 0.023s 91.593s 04 935 93.814s 0.025s 93.881s 05 1,028 103.143s 0.016s 103.201s 06 5,436 189.618s 0.015s 189.676s 07 2,751 193.977s 0.032s 194.049s 08 1,572 157.542s 0.013s 157.596s 09 2,370 194.873s 0.026s 194.943s 10 1,070 107.153s 0.016s 107.211s 11 1,556 155.821s 0.013s 155.877s 12 1,090 109.367s 0.031s 109.439s 13 1,591 159.57s 0.014s 159.629s 14 972 97.319s 0.023s 97.383s 15 989 99.219s 0.014s 99.278s 16 871 87.389s 0.023s 87.451s 17 1,053 105.569s 0.02s 105.633s 18 928 92.908s 0.024s 92.976s 19 632 63.416s 0.011s 63.472s 20 426 42.74s 0.017s 42.802s 21 555 55.691s 0.012s 55.749s 22 516 51.778s 0.013s 51.829s 23 743 74.433s 0.024s 74.498s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 08 23 0 0 0 0 0s 0s Jun 09 00 0 0 1 409 0.001s 0s 01 0 0 0 375 0.002s 0s 02 0 0 0 366 0.002s 0s 03 0 0 1 371 0.008s 0s 04 0 0 0 364 0.008s 0s 05 0 0 0 373 0.002s 0s 06 0 0 2 328 0.002s 0s 07 0 0 1 344 0.008s 0s 08 0 0 1 325 0.002s 0s 09 0 0 1 334 0.008s 0s 10 0 0 0 330 0.002s 0s 11 0 0 0 340 0.002s 0s 12 0 0 1 340 0.008s 0s 13 0 0 0 333 0.002s 0s 14 0 0 1 342 0.008s 0s 15 0 0 0 345 0.004s 0s 16 0 0 0 326 0.008s 0s 17 0 0 0 352 0.008s 0s 18 0 0 1 362 0.008s 0s 19 0 0 0 355 0.001s 0s 20 0 0 0 254 0.002s 0s 21 0 0 0 242 0.002s 0s 22 0 0 0 242 0.002s 0s 23 0 0 0 246 0.008s 0s Day Hour Count Avg time (sec) Jun 08 23 0 0s Jun 09 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 08 23 0 0 Jun 09 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 Jun 08 23 0 0 Jun 09 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
- 7.86 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-06-09 06:00:47 Date
- 3.02 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-06-09 05:01:02 Date
Analyzes per table
Key values
- public.sym_node_communication (208) Main table analyzed (database pharmisight)
- 306 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 208 pharmisight.public.sym_data 16 pharmisight.public.sym_data_event 16 pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_lock 11 pharmisight.public.sym_incoming_batch 11 pharmisight.public.sym_sequence 8 pharmisight.public.sym_node_host 5 pharmisight.public.sym_node_channel_ctl 3 Total 306 Vacuums per table
Key values
- public.sym_node_communication (156) Main table vacuumed on database pharmisight
- 229 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 156 0 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_data 10 10 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_sequence 8 0 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_gap 5 5 pharmisight.public.sym_node_channel_ctl 3 0 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.pg_toast.pg_toast_2619 2 2 Total 229 45 Tuples removed per table
Key values
- public.sym_data_event (31622) Main table with removed tuples on database pharmisight
- 61371 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 31622 984 pharmisight.public.sym_data 10 10 19294 6367 pharmisight.public.sym_outgoing_batch 10 10 5285 0 pharmisight.public.sym_node_communication 156 0 1546 0 pharmisight.public.sym_incoming_batch 6 6 1159 0 pharmisight.pg_catalog.pg_statistic 2 2 580 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 8 0 411 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 2 2 177 0 pharmisight.public.sym_node_channel_ctl 3 0 158 0 Total 229 45 61,371 7,351 Pages removed per table
Key values
- public.sym_data (6367) Main table with removed pages on database pharmisight
- 7351 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 19294 6367 pharmisight.public.sym_data_event 10 10 31622 984 pharmisight.public.sym_sequence 8 0 411 0 pharmisight.public.sym_node_communication 156 0 1546 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_node_channel_ctl 3 0 158 0 pharmisight.public.sym_incoming_batch 6 6 1159 0 pharmisight.pg_catalog.pg_statistic 2 2 580 0 pharmisight.pg_toast.pg_toast_2619 2 2 177 0 pharmisight.public.sym_outgoing_batch 10 10 5285 0 Total 229 45 61,371 7,351 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 08 23 0 0 Jun 09 00 9 15 01 9 11 02 10 10 03 10 11 04 7 11 05 10 15 06 12 11 07 12 14 08 9 14 09 11 15 10 8 11 11 8 14 12 10 14 13 8 12 14 11 16 15 12 11 16 7 15 17 11 14 18 13 14 19 10 11 20 7 9 21 7 13 22 8 12 23 10 13 - 7.86 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
- 695,298 Total read queries
- 611,620 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,176,471 Requests
- 1m8s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,213,103 Requests
User Request type Count Duration pharmisight Total 7,081 1s934ms DELETE 6 0ms INSERT 1,894 1s225ms OTHERS 1,527 59ms SELECT 3,131 564ms TCL 500 81ms UPDATE 23 2ms symmetricds Total 2,213,103 1m3s DDL 1 1ms DELETE 1,962 4s116ms INSERT 7,647 826ms OTHERS 885,678 16s995ms SELECT 705,390 26s349ms TCL 595,229 9s896ms UPDATE 17,196 4s937ms tony Total 882 4s702ms SELECT 882 4s702ms Duration by user
Key values
- 1m3s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 7,081 1s934ms DELETE 6 0ms INSERT 1,894 1s225ms OTHERS 1,527 59ms SELECT 3,131 564ms TCL 500 81ms UPDATE 23 2ms symmetricds Total 2,213,103 1m3s DDL 1 1ms DELETE 1,962 4s116ms INSERT 7,647 826ms OTHERS 885,678 16s995ms SELECT 705,390 26s349ms TCL 595,229 9s896ms UPDATE 17,196 4s937ms tony Total 882 4s702ms SELECT 882 4s702ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,220,184 Requests
- 1m5s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,174,353 Requests
- 1m3s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-06-09 15:29:14 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,172,020 0-1ms duration
Slowest individual queries
Rank Duration Query 1 119ms DELETE FROM sym_data WHERE data_id BETWEEN '84427291' AND '84432291' AND create_time < '2018-06-08 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 107ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7603604' AND '7603659' AND STATUS != 'OK') AND batch_id BETWEEN '7603604' AND '7603659';[ Date: 2018-06-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 98ms DELETE FROM sym_data WHERE data_id BETWEEN '84407930' AND '84412930' AND create_time < '2018-06-08 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 88ms DELETE FROM sym_data WHERE data_id BETWEEN '84433606' AND '84438606' AND create_time < '2018-06-08 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 87ms DELETE FROM sym_data WHERE data_id BETWEEN '84436907' AND '84441907' AND create_time < '2018-06-08 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84436907' AND '84441907') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84436907' AND '84441907' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 83ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7603660' AND '7604349' AND STATUS != 'OK') AND batch_id BETWEEN '7603660' AND '7604349';[ Date: 2018-06-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 83ms DELETE FROM sym_data WHERE data_id BETWEEN '84432292' AND '84437292' AND create_time < '2018-06-08 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84432292' AND '84437292') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84432292' AND '84437292' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 78ms DELETE FROM sym_data WHERE data_id BETWEEN '84447346' AND '84452346' AND create_time < '2018-06-08 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84447346' AND '84452346') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84447346' AND '84452346' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 76ms DELETE FROM sym_data WHERE data_id BETWEEN '84440933' AND '84445933' AND create_time < '2018-06-08 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84440933' AND '84445933') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84440933' AND '84445933' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 74ms DELETE FROM sym_data WHERE data_id BETWEEN '84443160' AND '84448160' AND create_time < '2018-06-08 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84443160' AND '84448160') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84443160' AND '84448160' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 71ms DELETE FROM sym_data WHERE data_id BETWEEN '84412931' AND '84417931' AND create_time < '2018-06-08 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84412931' AND '84417931') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84412931' AND '84417931' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 63ms DELETE FROM sym_data WHERE data_id BETWEEN '84421078' AND '84426078' AND create_time < '2018-06-08 08:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84421078' AND '84426078') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84421078' AND '84426078' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 61ms DELETE FROM sym_data WHERE data_id BETWEEN '84449609' AND '84454609' AND create_time < '2018-06-08 15:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84449609' AND '84454609') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84449609' AND '84454609' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 61ms DELETE FROM sym_data WHERE data_id BETWEEN '84417932' AND '84422932' AND create_time < '2018-06-08 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84417932' AND '84422932') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84417932' AND '84422932' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 58ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7604350' AND '7605001' AND STATUS != 'OK') AND batch_id BETWEEN '7604350' AND '7605001';[ Date: 2018-06-09 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 56ms DELETE FROM sym_data WHERE data_id BETWEEN '84392434' AND '84397434' AND create_time < '2018-06-08 06:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84392434' AND '84397434') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84392434' AND '84397434' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 49ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7605002' AND '7605647' AND STATUS != 'OK') AND batch_id BETWEEN '7605002' AND '7605647';[ Date: 2018-06-09 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 48ms DELETE FROM sym_data WHERE data_id BETWEEN '84437293' AND '84442293' AND create_time < '2018-06-08 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84437293' AND '84442293') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84437293' AND '84442293' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 47ms DELETE FROM sym_data WHERE data_id BETWEEN '84402436' AND '84407436' AND create_time < '2018-06-08 06:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84402436' AND '84407436') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84402436' AND '84407436' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 46ms DELETE FROM sym_data WHERE data_id BETWEEN '84452174' AND '84457174' AND create_time < '2018-06-08 16:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84452174' AND '84457174') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84452174' AND '84457174' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-06-09 16: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 16s623ms 867,045 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 09 00 38,064 720ms 0ms 01 36,135 673ms 0ms 02 36,199 706ms 0ms 03 36,198 690ms 0ms 04 36,139 688ms 0ms 05 36,188 696ms 0ms 06 36,032 696ms 0ms 07 36,045 688ms 0ms 08 36,040 687ms 0ms 09 35,982 675ms 0ms 10 36,039 685ms 0ms 11 35,981 679ms 0ms 12 36,033 690ms 0ms 13 36,041 671ms 0ms 14 35,979 693ms 0ms 15 36,044 690ms 0ms 16 35,983 689ms 0ms 17 36,046 691ms 0ms 18 36,044 707ms 0ms 19 35,984 696ms 0ms 20 35,907 703ms 0ms 21 35,959 676ms 0ms 22 35,930 716ms 0ms 23 36,053 707ms 0ms [ User: symmetricds - Total duration: 16s599ms - Times executed: 866544 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 501 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s623ms - Times executed: 867045 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-06-09 03:40:26 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:53:51 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 20:13:52 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s746ms 291,940 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 00 13,389 635ms 0ms 01 12,183 349ms 0ms 02 12,204 349ms 0ms 03 12,204 360ms 0ms 04 12,184 357ms 0ms 05 12,200 343ms 0ms 06 12,113 306ms 0ms 07 12,103 297ms 0ms 08 12,100 296ms 0ms 09 12,082 293ms 0ms 10 12,100 298ms 0ms 11 12,081 289ms 0ms 12 12,099 305ms 0ms 13 12,100 281ms 0ms 14 12,081 298ms 0ms 15 12,100 295ms 0ms 16 12,081 291ms 0ms 17 12,100 302ms 0ms 18 12,100 317ms 0ms 19 12,080 297ms 0ms 20 12,038 295ms 0ms 21 12,061 284ms 0ms 22 12,055 301ms 0ms 23 12,102 295ms 0ms [ User: symmetricds - Total duration: 7s670ms - Times executed: 291694 ]
[ User: pharmisight - Total duration: 75ms - Times executed: 246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s746ms - Times executed: 291940 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-06-09 12:19:38 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:41:01 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 02:38:53 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s893ms 384,012 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 09 00 17,589 217ms 0ms 01 16,025 200ms 0ms 02 16,050 205ms 0ms 03 16,051 203ms 0ms 04 16,021 204ms 0ms 05 16,048 201ms 0ms 06 15,947 201ms 0ms 07 15,937 203ms 0ms 08 15,926 204ms 0ms 09 15,895 198ms 0ms 10 15,922 202ms 0ms 11 15,895 200ms 0ms 12 15,917 204ms 0ms 13 15,919 203ms 0ms 14 15,886 201ms 0ms 15 15,918 206ms 0ms 16 15,884 201ms 0ms 17 15,917 201ms 0ms 18 15,913 204ms 0ms 19 15,878 204ms 0ms 20 15,839 207ms 0ms 21 15,866 203ms 0ms 22 15,854 204ms 0ms 23 15,915 207ms 0ms [ User: symmetricds - Total duration: 4s893ms - Times executed: 384012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s893ms - Times executed: 384012 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-06-09 13:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 21:44:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:29:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s646ms 77,229 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 Jun 09 00 3,204 150ms 0ms 01 3,213 151ms 0ms 02 3,222 154ms 0ms 03 3,222 150ms 0ms 04 3,213 150ms 0ms 05 3,222 153ms 0ms 06 3,213 151ms 0ms 07 3,222 149ms 0ms 08 3,222 152ms 0ms 09 3,213 152ms 0ms 10 3,222 154ms 0ms 11 3,213 148ms 0ms 12 3,222 151ms 0ms 13 3,222 155ms 0ms 14 3,213 154ms 0ms 15 3,222 150ms 0ms 16 3,213 149ms 0ms 17 3,222 152ms 0ms 18 3,222 153ms 0ms 19 3,213 149ms 0ms 20 3,222 148ms 0ms 21 3,222 151ms 0ms 22 3,213 152ms 0ms 23 3,222 154ms 0ms [ User: symmetricds - Total duration: 3s646ms - Times executed: 77229 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s646ms - Times executed: 77229 ]
-
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-06-09 13:06:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:48:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:49:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s536ms 288 2ms 12ms 12ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 09 00 12 148ms 12ms 01 12 146ms 12ms 02 12 149ms 12ms 03 12 148ms 12ms 04 12 146ms 12ms 05 12 147ms 12ms 06 12 146ms 12ms 07 12 148ms 12ms 08 12 137ms 11ms 09 12 146ms 12ms 10 12 147ms 12ms 11 12 147ms 12ms 12 12 146ms 12ms 13 12 148ms 12ms 14 12 146ms 12ms 15 12 148ms 12ms 16 12 148ms 12ms 17 12 148ms 12ms 18 12 147ms 12ms 19 12 148ms 12ms 20 12 148ms 12ms 21 12 147ms 12ms 22 12 147ms 12ms 23 12 147ms 12ms [ User: tony - Total duration: 3s536ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s536ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-06-09 03:16:05 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 18:46:03 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 06:31:05 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
6 2s643ms 158 0ms 119ms 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 #6
Day Hour Count Duration Avg duration Jun 09 00 14 109ms 7ms 01 14 93ms 6ms 02 14 100ms 7ms 03 14 91ms 6ms 04 14 97ms 6ms 05 14 100ms 7ms 06 14 272ms 19ms 07 11 269ms 24ms 08 8 117ms 14ms 09 7 386ms 55ms 10 6 136ms 22ms 11 5 183ms 36ms 12 4 137ms 34ms 13 4 122ms 30ms 14 3 101ms 33ms 15 2 79ms 39ms 16 2 48ms 24ms 17 2 45ms 22ms 18 1 33ms 33ms 19 1 18ms 18ms 20 1 25ms 25ms 21 1 18ms 18ms 22 1 27ms 27ms 23 1 24ms 24ms [ User: symmetricds - Total duration: 2s643ms - Times executed: 158 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s643ms - Times executed: 158 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '84427291' AND '84432291' AND create_time < '2018-06-08 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291' 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 '84407930' AND '84412930' AND create_time < '2018-06-08 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930' 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 '84433606' AND '84438606' AND create_time < '2018-06-08 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-06-09 09:00:00 Duration: 119ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:00:00 Duration: 98ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:00:00 Duration: 88ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 2s34ms 291,941 0ms 9ms 0ms BEGIN;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 09 00 13,388 92ms 0ms 01 12,183 82ms 0ms 02 12,204 84ms 0ms 03 12,205 85ms 0ms 04 12,184 86ms 0ms 05 12,199 83ms 0ms 06 12,114 83ms 0ms 07 12,103 86ms 0ms 08 12,100 84ms 0ms 09 12,082 90ms 0ms 10 12,100 86ms 0ms 11 12,081 82ms 0ms 12 12,098 84ms 0ms 13 12,101 82ms 0ms 14 12,080 82ms 0ms 15 12,102 84ms 0ms 16 12,080 82ms 0ms 17 12,101 83ms 0ms 18 12,100 89ms 0ms 19 12,079 83ms 0ms 20 12,037 82ms 0ms 21 12,062 82ms 0ms 22 12,056 83ms 0ms 23 12,102 83ms 0ms [ User: symmetricds - Total duration: 2s32ms - Times executed: 291695 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s34ms - Times executed: 291941 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-06-09 09:39:36 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 18:10:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:28:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s610ms 68,653 0ms 0ms 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 #8
Day Hour Count Duration Avg duration Jun 09 00 2,849 69ms 0ms 01 2,856 69ms 0ms 02 2,865 71ms 0ms 03 2,865 71ms 0ms 04 2,857 69ms 0ms 05 2,865 69ms 0ms 06 2,856 68ms 0ms 07 2,864 67ms 0ms 08 2,864 67ms 0ms 09 2,856 66ms 0ms 10 2,864 66ms 0ms 11 2,856 65ms 0ms 12 2,864 66ms 0ms 13 2,864 66ms 0ms 14 2,856 66ms 0ms 15 2,864 65ms 0ms 16 2,856 64ms 0ms 17 2,864 65ms 0ms 18 2,864 65ms 0ms 19 2,856 64ms 0ms 20 2,864 65ms 0ms 21 2,864 65ms 0ms 22 2,856 65ms 0ms 23 2,864 65ms 0ms [ User: symmetricds - Total duration: 1s610ms - Times executed: 68653 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s610ms - Times executed: 68653 ]
-
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 '84458631' AND '134458630')) 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 '84458017' AND '134458016')) 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 '84458354' AND '134458353')) ORDER BY d.data_id ASC;
Date: 2018-06-09 05:20:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s279ms 57,600 0ms 2ms 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 #9
Day Hour Count Duration Avg duration Jun 09 00 2,400 53ms 0ms 01 2,400 51ms 0ms 02 2,400 53ms 0ms 03 2,400 50ms 0ms 04 2,400 51ms 0ms 05 2,400 54ms 0ms 06 2,400 51ms 0ms 07 2,400 54ms 0ms 08 2,400 51ms 0ms 09 2,400 51ms 0ms 10 2,400 53ms 0ms 11 2,400 49ms 0ms 12 2,400 51ms 0ms 13 2,400 51ms 0ms 14 2,400 58ms 0ms 15 2,400 54ms 0ms 16 2,400 53ms 0ms 17 2,400 56ms 0ms 18 2,400 52ms 0ms 19 2,400 51ms 0ms 20 2,400 54ms 0ms 21 2,400 53ms 0ms 22 2,400 59ms 0ms 23 2,400 54ms 0ms [ User: symmetricds - Total duration: 1s279ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s279ms - Times executed: 57600 ]
-
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 = 'default';
-
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 = 'reload';
Date: 2018-06-09 17:39:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 05:52:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 23:35:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s226ms 189 0ms 9ms 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 #10
Day Hour Count Duration Avg duration Jun 09 00 8 47ms 5ms 01 8 55ms 6ms 02 8 46ms 5ms 03 8 53ms 6ms 04 8 56ms 7ms 05 8 50ms 6ms 06 8 49ms 6ms 07 8 61ms 7ms 08 8 53ms 6ms 09 8 53ms 6ms 10 8 63ms 7ms 11 8 55ms 6ms 12 8 54ms 6ms 13 8 55ms 6ms 14 8 43ms 5ms 15 8 41ms 5ms 16 8 63ms 7ms 17 8 49ms 6ms 18 8 49ms 6ms 19 8 59ms 7ms 20 5 30ms 6ms 21 8 38ms 4ms 22 8 45ms 5ms 23 8 46ms 5ms [ User: symmetricds - Total duration: 1s226ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s226ms - 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" = '188905088', "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-06-09 10:18:59', "last_restart_time" = '2018-05-29 12:07:33.321', "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" = '194200592', "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-06-09 10:08:34', "last_restart_time" = '2018-05-29 17:47:25', "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" = '131992544', "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-06-09 23:19:25', "last_restart_time" = '2018-05-29 12:07:33.321', "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-06-09 10:19:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:09:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 23:19:37 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s192ms 5,799 0ms 8ms 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 #11
Day Hour Count Duration Avg duration Jun 09 00 245 50ms 0ms 01 242 47ms 0ms 02 242 47ms 0ms 03 242 49ms 0ms 04 241 47ms 0ms 05 240 46ms 0ms 06 244 48ms 0ms 07 240 47ms 0ms 08 240 49ms 0ms 09 241 48ms 0ms 10 240 53ms 0ms 11 240 46ms 0ms 12 240 49ms 0ms 13 240 55ms 0ms 14 240 49ms 0ms 15 246 50ms 0ms 16 240 50ms 0ms 17 240 50ms 0ms 18 246 51ms 0ms 19 245 48ms 0ms 20 241 50ms 0ms 21 240 49ms 0ms 22 242 50ms 0ms 23 242 52ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 5799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 5799 ]
-
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;
-
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;
-
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-06-09 13:15:41 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 17:18:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:23:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s147ms 1,758 0ms 28ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 09 00 307 187ms 0ms 01 230 149ms 0ms 02 255 166ms 0ms 03 318 190ms 0ms 04 286 183ms 0ms 05 287 178ms 0ms 06 75 91ms 1ms [ User: pharmisight - Total duration: 1s147ms - Times executed: 1758 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s147ms - Times executed: 1758 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004081669', '2018-06-09 05:32:36', 'KRYSINSKID', '2018-06-09 06:00:00.032', '40891', '8', '150505230116798535');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004087500', '2018-06-09 05:35:15', 'KRYSINSKID', '2018-06-09 06:00:00.032', '40891', '8', '150505230116798788');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004088485', '2018-06-09 01:49:06', 'KRYSINSKID', '2018-06-09 02:20:00.039', '49638', '2', '150505230116782657');
Date: 2018-06-09 06:00:00 Duration: 28ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 06:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 02:20:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s48ms 203 3ms 9ms 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 #13
Day Hour Count Duration Avg duration Jun 09 00 168 860ms 5ms 01 3 13ms 4ms 02 3 22ms 7ms 03 3 23ms 7ms 04 3 13ms 4ms 05 3 24ms 8ms 06 3 13ms 4ms 07 1 4ms 4ms 08 1 4ms 4ms 09 1 4ms 4ms 10 1 4ms 4ms 11 1 4ms 4ms 12 1 8ms 8ms 13 1 4ms 4ms 14 1 4ms 4ms 15 1 4ms 4ms 16 1 4ms 4ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 4ms 4ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 1s48ms - Times executed: 203 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s48ms - Times executed: 203 ]
-
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;
-
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-06-09 03:00:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:00:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 995ms 646 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 #14
Day Hour Count Duration Avg duration Jun 09 00 24 36ms 1ms 01 29 43ms 1ms 02 23 35ms 1ms 03 25 38ms 1ms 04 26 39ms 1ms 05 28 44ms 1ms 06 29 44ms 1ms 07 26 40ms 1ms 08 29 44ms 1ms 09 28 43ms 1ms 10 26 39ms 1ms 11 26 40ms 1ms 12 29 44ms 1ms 13 27 41ms 1ms 14 28 43ms 1ms 15 27 41ms 1ms 16 25 39ms 1ms 17 26 40ms 1ms 18 29 44ms 1ms 19 29 44ms 1ms 20 25 37ms 1ms 21 25 37ms 1ms 22 29 44ms 1ms 23 28 42ms 1ms [ User: symmetricds - Total duration: 995ms - Times executed: 646 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 995ms - Times executed: 646 ]
-
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-06-09 05:10:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:02:55 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:20:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 940ms 5,760 0ms 2ms 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 #15
Day Hour Count Duration Avg duration Jun 09 00 240 38ms 0ms 01 240 37ms 0ms 02 240 38ms 0ms 03 240 37ms 0ms 04 240 37ms 0ms 05 240 39ms 0ms 06 240 38ms 0ms 07 240 37ms 0ms 08 240 39ms 0ms 09 240 40ms 0ms 10 240 39ms 0ms 11 240 36ms 0ms 12 240 39ms 0ms 13 240 36ms 0ms 14 240 41ms 0ms 15 240 37ms 0ms 16 240 41ms 0ms 17 240 40ms 0ms 18 240 41ms 0ms 19 240 41ms 0ms 20 240 41ms 0ms 21 240 39ms 0ms 22 240 40ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 940ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 940ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 19:04:50.534', last_lock_time = '2018-06-09 19:04:50.534' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 17:04:50.534');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 14:52:44.074', last_lock_time = '2018-06-09 14:52:44.074' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 12:52:44.074');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 20:45:53.29', last_lock_time = '2018-06-09 20:45:53.29' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 18:45:53.29');
Date: 2018-06-09 19:04:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 14:52:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 20:45:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 872ms 288 1ms 4ms 3ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 09 00 12 38ms 3ms 01 12 36ms 3ms 02 12 37ms 3ms 03 12 36ms 3ms 04 12 35ms 2ms 05 12 35ms 2ms 06 12 34ms 2ms 07 12 37ms 3ms 08 12 35ms 2ms 09 12 36ms 3ms 10 12 36ms 3ms 11 12 37ms 3ms 12 12 35ms 2ms 13 12 36ms 3ms 14 12 34ms 2ms 15 12 36ms 3ms 16 12 36ms 3ms 17 12 36ms 3ms 18 12 36ms 3ms 19 12 36ms 3ms 20 12 36ms 3ms 21 12 38ms 3ms 22 12 35ms 2ms 23 12 35ms 2ms [ User: tony - Total duration: 872ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 872ms - Times executed: 288 ]
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
Date: 2018-06-09 21:01:03 Duration: 4ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 09:16:05 Duration: 4ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 02:11:04 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
17 871ms 793 0ms 5ms 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 #17
Day Hour Count Duration Avg duration Jun 09 00 30 34ms 1ms 01 39 44ms 1ms 02 25 24ms 0ms 03 36 36ms 1ms 04 28 37ms 1ms 05 35 38ms 1ms 06 34 42ms 1ms 07 31 36ms 1ms 08 43 49ms 1ms 09 37 37ms 1ms 10 34 36ms 1ms 11 33 35ms 1ms 12 33 36ms 1ms 13 36 38ms 1ms 14 34 33ms 0ms 15 32 33ms 1ms 16 30 32ms 1ms 17 30 34ms 1ms 18 32 37ms 1ms 19 38 41ms 1ms 20 29 29ms 1ms 21 33 33ms 1ms 22 30 33ms 1ms 23 31 33ms 1ms [ User: symmetricds - Total duration: 871ms - Times executed: 793 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 871ms - Times executed: 793 ]
-
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-06-09 04:06:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 08:58:34 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:30:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 811ms 16,012 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 #18
Day Hour Count Duration Avg duration Jun 09 00 696 34ms 0ms 01 668 32ms 0ms 02 669 33ms 0ms 03 669 33ms 0ms 04 668 33ms 0ms 05 669 33ms 0ms 06 666 33ms 0ms 07 666 33ms 0ms 08 666 33ms 0ms 09 665 34ms 0ms 10 666 32ms 0ms 11 665 32ms 0ms 12 666 34ms 0ms 13 666 32ms 0ms 14 665 33ms 0ms 15 666 34ms 0ms 16 665 33ms 0ms 17 666 35ms 0ms 18 666 34ms 0ms 19 665 34ms 0ms 20 662 36ms 0ms 21 663 32ms 0ms 22 663 34ms 0ms 23 666 33ms 0ms [ User: symmetricds - Total duration: 811ms - Times executed: 16012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 811ms - Times executed: 16012 ]
-
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-06-09 20:16:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:09:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 09:25:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 807ms 5,760 0ms 1ms 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 #19
Day Hour Count Duration Avg duration Jun 09 00 240 33ms 0ms 01 240 33ms 0ms 02 240 36ms 0ms 03 240 32ms 0ms 04 240 31ms 0ms 05 240 33ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 34ms 0ms 09 240 33ms 0ms 10 240 33ms 0ms 11 240 35ms 0ms 12 240 33ms 0ms 13 240 32ms 0ms 14 240 33ms 0ms 15 240 33ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 34ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 807ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 807ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '97', success_count = '124586', fail_count = '0', total_success_count = '124586', total_fail_count = '0', total_success_millis = '7096310', total_fail_millis = '0', last_lock_time = '2018-06-09 14:31:43.5' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '65', success_count = '124528', fail_count = '0', total_success_count = '124528', total_fail_count = '0', total_success_millis = '7428421', total_fail_millis = '0', last_lock_time = '2018-06-09 11:36:38.984' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '88', success_count = '124736', fail_count = '0', total_success_count = '124736', total_fail_count = '0', total_success_millis = '7108732', total_fail_millis = '0', last_lock_time = '2018-06-09 22:01:55.137' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-06-09 14:31:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:36:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:01:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 791ms 11,521 0ms 11ms 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 #20
Day Hour Count Duration Avg duration Jun 09 00 481 44ms 0ms 01 480 32ms 0ms 02 480 31ms 0ms 03 480 31ms 0ms 04 480 32ms 0ms 05 480 32ms 0ms 06 480 31ms 0ms 07 480 31ms 0ms 08 480 30ms 0ms 09 480 31ms 0ms 10 480 33ms 0ms 11 480 36ms 0ms 12 480 36ms 0ms 13 480 31ms 0ms 14 480 31ms 0ms 15 480 30ms 0ms 16 480 32ms 0ms 17 480 31ms 0ms 18 480 31ms 0ms 19 480 32ms 0ms 20 480 35ms 0ms 21 480 31ms 0ms 22 480 32ms 0ms 23 480 33ms 0ms [ User: symmetricds - Total duration: 791ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 791ms - Times executed: 11521 ]
-
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-06-09 00:40:22 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:46:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 12:19:40 Duration: 4ms 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 867,045 16s623ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 09 00 38,064 720ms 0ms 01 36,135 673ms 0ms 02 36,199 706ms 0ms 03 36,198 690ms 0ms 04 36,139 688ms 0ms 05 36,188 696ms 0ms 06 36,032 696ms 0ms 07 36,045 688ms 0ms 08 36,040 687ms 0ms 09 35,982 675ms 0ms 10 36,039 685ms 0ms 11 35,981 679ms 0ms 12 36,033 690ms 0ms 13 36,041 671ms 0ms 14 35,979 693ms 0ms 15 36,044 690ms 0ms 16 35,983 689ms 0ms 17 36,046 691ms 0ms 18 36,044 707ms 0ms 19 35,984 696ms 0ms 20 35,907 703ms 0ms 21 35,959 676ms 0ms 22 35,930 716ms 0ms 23 36,053 707ms 0ms [ User: symmetricds - Total duration: 16s599ms - Times executed: 866544 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 501 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s623ms - Times executed: 867045 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-06-09 03:40:26 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:53:51 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 20:13:52 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 384,012 4s893ms 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 00 17,589 217ms 0ms 01 16,025 200ms 0ms 02 16,050 205ms 0ms 03 16,051 203ms 0ms 04 16,021 204ms 0ms 05 16,048 201ms 0ms 06 15,947 201ms 0ms 07 15,937 203ms 0ms 08 15,926 204ms 0ms 09 15,895 198ms 0ms 10 15,922 202ms 0ms 11 15,895 200ms 0ms 12 15,917 204ms 0ms 13 15,919 203ms 0ms 14 15,886 201ms 0ms 15 15,918 206ms 0ms 16 15,884 201ms 0ms 17 15,917 201ms 0ms 18 15,913 204ms 0ms 19 15,878 204ms 0ms 20 15,839 207ms 0ms 21 15,866 203ms 0ms 22 15,854 204ms 0ms 23 15,915 207ms 0ms [ User: symmetricds - Total duration: 4s893ms - Times executed: 384012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s893ms - Times executed: 384012 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-06-09 13:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 21:44:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:29:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 291,941 2s34ms 0ms 9ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 09 00 13,388 92ms 0ms 01 12,183 82ms 0ms 02 12,204 84ms 0ms 03 12,205 85ms 0ms 04 12,184 86ms 0ms 05 12,199 83ms 0ms 06 12,114 83ms 0ms 07 12,103 86ms 0ms 08 12,100 84ms 0ms 09 12,082 90ms 0ms 10 12,100 86ms 0ms 11 12,081 82ms 0ms 12 12,098 84ms 0ms 13 12,101 82ms 0ms 14 12,080 82ms 0ms 15 12,102 84ms 0ms 16 12,080 82ms 0ms 17 12,101 83ms 0ms 18 12,100 89ms 0ms 19 12,079 83ms 0ms 20 12,037 82ms 0ms 21 12,062 82ms 0ms 22 12,056 83ms 0ms 23 12,102 83ms 0ms [ User: symmetricds - Total duration: 2s32ms - Times executed: 291695 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s34ms - Times executed: 291941 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-06-09 09:39:36 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 18:10:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:28:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 291,940 7s746ms 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 09 00 13,389 635ms 0ms 01 12,183 349ms 0ms 02 12,204 349ms 0ms 03 12,204 360ms 0ms 04 12,184 357ms 0ms 05 12,200 343ms 0ms 06 12,113 306ms 0ms 07 12,103 297ms 0ms 08 12,100 296ms 0ms 09 12,082 293ms 0ms 10 12,100 298ms 0ms 11 12,081 289ms 0ms 12 12,099 305ms 0ms 13 12,100 281ms 0ms 14 12,081 298ms 0ms 15 12,100 295ms 0ms 16 12,081 291ms 0ms 17 12,100 302ms 0ms 18 12,100 317ms 0ms 19 12,080 297ms 0ms 20 12,038 295ms 0ms 21 12,061 284ms 0ms 22 12,055 301ms 0ms 23 12,102 295ms 0ms [ User: symmetricds - Total duration: 7s670ms - Times executed: 291694 ]
[ User: pharmisight - Total duration: 75ms - Times executed: 246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s746ms - Times executed: 291940 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-06-09 12:19:38 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:41:01 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 02:38:53 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 77,229 3s646ms 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 Jun 09 00 3,204 150ms 0ms 01 3,213 151ms 0ms 02 3,222 154ms 0ms 03 3,222 150ms 0ms 04 3,213 150ms 0ms 05 3,222 153ms 0ms 06 3,213 151ms 0ms 07 3,222 149ms 0ms 08 3,222 152ms 0ms 09 3,213 152ms 0ms 10 3,222 154ms 0ms 11 3,213 148ms 0ms 12 3,222 151ms 0ms 13 3,222 155ms 0ms 14 3,213 154ms 0ms 15 3,222 150ms 0ms 16 3,213 149ms 0ms 17 3,222 152ms 0ms 18 3,222 153ms 0ms 19 3,213 149ms 0ms 20 3,222 148ms 0ms 21 3,222 151ms 0ms 22 3,213 152ms 0ms 23 3,222 154ms 0ms [ User: symmetricds - Total duration: 3s646ms - Times executed: 77229 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s646ms - Times executed: 77229 ]
-
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-06-09 13:06:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:48:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:49:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 68,653 1s610ms 0ms 0ms 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 Jun 09 00 2,849 69ms 0ms 01 2,856 69ms 0ms 02 2,865 71ms 0ms 03 2,865 71ms 0ms 04 2,857 69ms 0ms 05 2,865 69ms 0ms 06 2,856 68ms 0ms 07 2,864 67ms 0ms 08 2,864 67ms 0ms 09 2,856 66ms 0ms 10 2,864 66ms 0ms 11 2,856 65ms 0ms 12 2,864 66ms 0ms 13 2,864 66ms 0ms 14 2,856 66ms 0ms 15 2,864 65ms 0ms 16 2,856 64ms 0ms 17 2,864 65ms 0ms 18 2,864 65ms 0ms 19 2,856 64ms 0ms 20 2,864 65ms 0ms 21 2,864 65ms 0ms 22 2,856 65ms 0ms 23 2,864 65ms 0ms [ User: symmetricds - Total duration: 1s610ms - Times executed: 68653 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s610ms - Times executed: 68653 ]
-
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 '84458631' AND '134458630')) 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 '84458017' AND '134458016')) 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 '84458354' AND '134458353')) ORDER BY d.data_id ASC;
Date: 2018-06-09 05:20:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 57,600 1s279ms 0ms 2ms 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 Jun 09 00 2,400 53ms 0ms 01 2,400 51ms 0ms 02 2,400 53ms 0ms 03 2,400 50ms 0ms 04 2,400 51ms 0ms 05 2,400 54ms 0ms 06 2,400 51ms 0ms 07 2,400 54ms 0ms 08 2,400 51ms 0ms 09 2,400 51ms 0ms 10 2,400 53ms 0ms 11 2,400 49ms 0ms 12 2,400 51ms 0ms 13 2,400 51ms 0ms 14 2,400 58ms 0ms 15 2,400 54ms 0ms 16 2,400 53ms 0ms 17 2,400 56ms 0ms 18 2,400 52ms 0ms 19 2,400 51ms 0ms 20 2,400 54ms 0ms 21 2,400 53ms 0ms 22 2,400 59ms 0ms 23 2,400 54ms 0ms [ User: symmetricds - Total duration: 1s279ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s279ms - Times executed: 57600 ]
-
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 = 'default';
-
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 = 'reload';
Date: 2018-06-09 17:39:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 05:52:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 23:35:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 16,012 811ms 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 Jun 09 00 696 34ms 0ms 01 668 32ms 0ms 02 669 33ms 0ms 03 669 33ms 0ms 04 668 33ms 0ms 05 669 33ms 0ms 06 666 33ms 0ms 07 666 33ms 0ms 08 666 33ms 0ms 09 665 34ms 0ms 10 666 32ms 0ms 11 665 32ms 0ms 12 666 34ms 0ms 13 666 32ms 0ms 14 665 33ms 0ms 15 666 34ms 0ms 16 665 33ms 0ms 17 666 35ms 0ms 18 666 34ms 0ms 19 665 34ms 0ms 20 662 36ms 0ms 21 663 32ms 0ms 22 663 34ms 0ms 23 666 33ms 0ms [ User: symmetricds - Total duration: 811ms - Times executed: 16012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 811ms - Times executed: 16012 ]
-
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-06-09 20:16:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:09:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 09:25:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 11,521 791ms 0ms 11ms 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 Jun 09 00 481 44ms 0ms 01 480 32ms 0ms 02 480 31ms 0ms 03 480 31ms 0ms 04 480 32ms 0ms 05 480 32ms 0ms 06 480 31ms 0ms 07 480 31ms 0ms 08 480 30ms 0ms 09 480 31ms 0ms 10 480 33ms 0ms 11 480 36ms 0ms 12 480 36ms 0ms 13 480 31ms 0ms 14 480 31ms 0ms 15 480 30ms 0ms 16 480 32ms 0ms 17 480 31ms 0ms 18 480 31ms 0ms 19 480 32ms 0ms 20 480 35ms 0ms 21 480 31ms 0ms 22 480 32ms 0ms 23 480 33ms 0ms [ User: symmetricds - Total duration: 791ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 791ms - Times executed: 11521 ]
-
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-06-09 00:40:22 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:46:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 12:19:40 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 8,635 290ms 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 Jun 09 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 12ms 0ms 10 360 11ms 0ms 11 360 12ms 0ms 12 359 12ms 0ms 13 360 11ms 0ms 14 360 11ms 0ms 15 360 11ms 0ms 16 360 11ms 0ms 17 360 11ms 0ms 18 359 12ms 0ms 19 360 11ms 0ms 20 360 12ms 0ms 21 360 12ms 0ms 22 360 11ms 0ms 23 360 11ms 0ms [ User: symmetricds - Total duration: 290ms - Times executed: 8635 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 290ms - Times executed: 8635 ]
-
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-06-09 21:50:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 00:42:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:50:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 8,587 202ms 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 Jun 09 00 357 8ms 0ms 01 358 9ms 0ms 02 359 9ms 0ms 03 359 9ms 0ms 04 358 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 8ms 0ms 15 358 8ms 0ms 16 357 7ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 357 7ms 0ms 20 358 7ms 0ms 21 358 7ms 0ms 22 357 7ms 0ms 23 358 7ms 0ms [ User: symmetricds - Total duration: 202ms - Times executed: 8587 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 202ms - Times executed: 8587 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '84457464' AND data_id <= '134457463' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '84458354' AND data_id <= '134458353' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '84458190' AND data_id <= '134458189' ORDER BY data_id ASC;
Date: 2018-06-09 01:20:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:20:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:40:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,581 472ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 09 00 356 20ms 0ms 01 357 20ms 0ms 02 358 21ms 0ms 03 358 21ms 0ms 04 357 21ms 0ms 05 358 20ms 0ms 06 357 19ms 0ms 07 358 19ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 358 19ms 0ms 11 357 19ms 0ms 12 358 19ms 0ms 13 358 19ms 0ms 14 357 18ms 0ms 15 358 19ms 0ms 16 357 18ms 0ms 17 358 19ms 0ms 18 358 19ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 19ms 0ms 22 357 18ms 0ms 23 358 19ms 0ms [ User: symmetricds - Total duration: 472ms - Times executed: 8581 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 472ms - Times executed: 8581 ]
-
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-06-09 04:54:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 21:49:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:30:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 7,200 658ms 0ms 4ms 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 Jun 09 00 300 29ms 0ms 01 300 28ms 0ms 02 300 27ms 0ms 03 300 29ms 0ms 04 300 33ms 0ms 05 300 28ms 0ms 06 300 28ms 0ms 07 300 25ms 0ms 08 300 27ms 0ms 09 300 25ms 0ms 10 300 26ms 0ms 11 300 25ms 0ms 12 300 29ms 0ms 13 300 23ms 0ms 14 300 25ms 0ms 15 300 25ms 0ms 16 300 27ms 0ms 17 300 25ms 0ms 18 300 26ms 0ms 19 300 32ms 0ms 20 300 25ms 0ms 21 300 25ms 0ms 22 300 28ms 0ms 23 300 27ms 0ms [ User: symmetricds - Total duration: 658ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 658ms - Times executed: 7200 ]
-
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 = '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 = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-06-09 04:00:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:09:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:31:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 5,799 1s192ms 0ms 8ms 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 Jun 09 00 245 50ms 0ms 01 242 47ms 0ms 02 242 47ms 0ms 03 242 49ms 0ms 04 241 47ms 0ms 05 240 46ms 0ms 06 244 48ms 0ms 07 240 47ms 0ms 08 240 49ms 0ms 09 241 48ms 0ms 10 240 53ms 0ms 11 240 46ms 0ms 12 240 49ms 0ms 13 240 55ms 0ms 14 240 49ms 0ms 15 246 50ms 0ms 16 240 50ms 0ms 17 240 50ms 0ms 18 246 51ms 0ms 19 245 48ms 0ms 20 241 50ms 0ms 21 240 49ms 0ms 22 242 50ms 0ms 23 242 52ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 5799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 5799 ]
-
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;
-
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;
-
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-06-09 13:15:41 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 17:18:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:23:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 5,785 231ms 0ms 1ms 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 Jun 09 00 265 9ms 0ms 01 240 8ms 0ms 02 240 9ms 0ms 03 240 9ms 0ms 04 240 9ms 0ms 05 240 9ms 0ms 06 240 10ms 0ms 07 240 9ms 0ms 08 240 10ms 0ms 09 240 9ms 0ms 10 240 9ms 0ms 11 240 9ms 0ms 12 240 9ms 0ms 13 240 9ms 0ms 14 240 9ms 0ms 15 240 9ms 0ms 16 240 10ms 0ms 17 240 9ms 0ms 18 240 11ms 0ms 19 240 10ms 0ms 20 240 10ms 0ms 21 240 9ms 0ms 22 240 10ms 0ms 23 240 9ms 0ms [ User: symmetricds - Total duration: 231ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 231ms - Times executed: 5785 ]
-
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-06-09 22:03:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 08:52:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:43:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,760 468ms 0ms 1ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 09 00 240 19ms 0ms 01 240 19ms 0ms 02 240 18ms 0ms 03 240 18ms 0ms 04 240 18ms 0ms 05 240 19ms 0ms 06 240 21ms 0ms 07 240 19ms 0ms 08 240 20ms 0ms 09 240 20ms 0ms 10 240 19ms 0ms 11 240 19ms 0ms 12 240 20ms 0ms 13 240 19ms 0ms 14 240 19ms 0ms 15 240 19ms 0ms 16 240 20ms 0ms 17 240 19ms 0ms 18 240 19ms 0ms 19 240 19ms 0ms 20 240 20ms 0ms 21 240 18ms 0ms 22 240 19ms 0ms 23 240 18ms 0ms [ User: symmetricds - Total duration: 468ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 468ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' 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 = 'PUSH' ORDER BY last_lock_time;
Date: 2018-06-09 06:59:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 09:41:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 06:32:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,760 940ms 0ms 2ms 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 Jun 09 00 240 38ms 0ms 01 240 37ms 0ms 02 240 38ms 0ms 03 240 37ms 0ms 04 240 37ms 0ms 05 240 39ms 0ms 06 240 38ms 0ms 07 240 37ms 0ms 08 240 39ms 0ms 09 240 40ms 0ms 10 240 39ms 0ms 11 240 36ms 0ms 12 240 39ms 0ms 13 240 36ms 0ms 14 240 41ms 0ms 15 240 37ms 0ms 16 240 41ms 0ms 17 240 40ms 0ms 18 240 41ms 0ms 19 240 41ms 0ms 20 240 41ms 0ms 21 240 39ms 0ms 22 240 40ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 940ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 940ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 19:04:50.534', last_lock_time = '2018-06-09 19:04:50.534' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 17:04:50.534');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 14:52:44.074', last_lock_time = '2018-06-09 14:52:44.074' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 12:52:44.074');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 20:45:53.29', last_lock_time = '2018-06-09 20:45:53.29' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 18:45:53.29');
Date: 2018-06-09 19:04:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 14:52:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 20:45:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,760 807ms 0ms 1ms 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 #18
Day Hour Count Duration Avg duration Jun 09 00 240 33ms 0ms 01 240 33ms 0ms 02 240 36ms 0ms 03 240 32ms 0ms 04 240 31ms 0ms 05 240 33ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 34ms 0ms 09 240 33ms 0ms 10 240 33ms 0ms 11 240 35ms 0ms 12 240 33ms 0ms 13 240 32ms 0ms 14 240 33ms 0ms 15 240 33ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 34ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 807ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 807ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '97', success_count = '124586', fail_count = '0', total_success_count = '124586', total_fail_count = '0', total_success_millis = '7096310', total_fail_millis = '0', last_lock_time = '2018-06-09 14:31:43.5' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '65', success_count = '124528', fail_count = '0', total_success_count = '124528', total_fail_count = '0', total_success_millis = '7428421', total_fail_millis = '0', last_lock_time = '2018-06-09 11:36:38.984' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '88', success_count = '124736', fail_count = '0', total_success_count = '124736', total_fail_count = '0', total_success_millis = '7108732', total_fail_millis = '0', last_lock_time = '2018-06-09 22:01:55.137' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-06-09 14:31:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:36:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:01:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,371 333ms 0ms 3ms 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 Jun 09 00 650 36ms 0ms 01 496 36ms 0ms 02 546 40ms 0ms 03 672 45ms 0ms 04 608 39ms 0ms 05 610 41ms 0ms 06 186 10ms 0ms 07 36 5ms 0ms 08 36 5ms 0ms 09 36 5ms 0ms 10 36 4ms 0ms 11 36 4ms 0ms 12 36 5ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 36 7ms 0ms 20 27 3ms 0ms 21 36 4ms 0ms 22 36 4ms 0ms 23 36 4ms 0ms [ User: symmetricds - Total duration: 333ms - Times executed: 4371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 333ms - Times executed: 4371 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84459111', '7609031', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84458966', '7608838', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84457432', '7608695', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2018-06-09 19:55:19 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:49:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 00:54:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 3,440 267ms 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 Jun 09 00 204 15ms 0ms 01 152 10ms 0ms 02 152 12ms 0ms 03 151 10ms 0ms 04 152 11ms 0ms 05 151 11ms 0ms 06 139 10ms 0ms 07 140 9ms 0ms 08 140 11ms 0ms 09 140 10ms 0ms 10 140 11ms 0ms 11 140 10ms 0ms 12 140 10ms 0ms 13 140 10ms 0ms 14 140 11ms 0ms 15 134 9ms 0ms 16 140 11ms 0ms 17 140 10ms 0ms 18 134 10ms 0ms 19 134 12ms 0ms 20 132 10ms 0ms 21 134 9ms 0ms 22 134 10ms 0ms 23 137 11ms 0ms [ User: symmetricds - Total duration: 267ms - Times executed: 3440 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 267ms - Times executed: 3440 ]
-
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;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
Date: 2018-06-09 02:24:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:19:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:13:36 Duration: 1ms 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 119ms 16ms 158 2s643ms 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 Jun 09 00 14 109ms 7ms 01 14 93ms 6ms 02 14 100ms 7ms 03 14 91ms 6ms 04 14 97ms 6ms 05 14 100ms 7ms 06 14 272ms 19ms 07 11 269ms 24ms 08 8 117ms 14ms 09 7 386ms 55ms 10 6 136ms 22ms 11 5 183ms 36ms 12 4 137ms 34ms 13 4 122ms 30ms 14 3 101ms 33ms 15 2 79ms 39ms 16 2 48ms 24ms 17 2 45ms 22ms 18 1 33ms 33ms 19 1 18ms 18ms 20 1 25ms 25ms 21 1 18ms 18ms 22 1 27ms 27ms 23 1 24ms 24ms [ User: symmetricds - Total duration: 2s643ms - Times executed: 158 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s643ms - Times executed: 158 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '84427291' AND '84432291' AND create_time < '2018-06-08 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84427291' AND '84432291' 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 '84407930' AND '84412930' AND create_time < '2018-06-08 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84407930' AND '84412930' 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 '84433606' AND '84438606' AND create_time < '2018-06-08 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '84433606' AND '84438606' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-06-09 09:00:00 Duration: 119ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:00:00 Duration: 98ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:00:00 Duration: 88ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 2ms 12ms 12ms 288 3s536ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 00 12 148ms 12ms 01 12 146ms 12ms 02 12 149ms 12ms 03 12 148ms 12ms 04 12 146ms 12ms 05 12 147ms 12ms 06 12 146ms 12ms 07 12 148ms 12ms 08 12 137ms 11ms 09 12 146ms 12ms 10 12 147ms 12ms 11 12 147ms 12ms 12 12 146ms 12ms 13 12 148ms 12ms 14 12 146ms 12ms 15 12 148ms 12ms 16 12 148ms 12ms 17 12 148ms 12ms 18 12 147ms 12ms 19 12 148ms 12ms 20 12 148ms 12ms 21 12 147ms 12ms 22 12 147ms 12ms 23 12 147ms 12ms [ User: tony - Total duration: 3s536ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s536ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-06-09 03:16:05 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 18:46:03 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 06:31:05 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
3 0ms 9ms 6ms 189 1s226ms 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 #3
Day Hour Count Duration Avg duration Jun 09 00 8 47ms 5ms 01 8 55ms 6ms 02 8 46ms 5ms 03 8 53ms 6ms 04 8 56ms 7ms 05 8 50ms 6ms 06 8 49ms 6ms 07 8 61ms 7ms 08 8 53ms 6ms 09 8 53ms 6ms 10 8 63ms 7ms 11 8 55ms 6ms 12 8 54ms 6ms 13 8 55ms 6ms 14 8 43ms 5ms 15 8 41ms 5ms 16 8 63ms 7ms 17 8 49ms 6ms 18 8 49ms 6ms 19 8 59ms 7ms 20 5 30ms 6ms 21 8 38ms 4ms 22 8 45ms 5ms 23 8 46ms 5ms [ User: symmetricds - Total duration: 1s226ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s226ms - 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" = '188905088', "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-06-09 10:18:59', "last_restart_time" = '2018-05-29 12:07:33.321', "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" = '194200592', "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-06-09 10:08:34', "last_restart_time" = '2018-05-29 17:47:25', "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" = '131992544', "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-06-09 23:19:25', "last_restart_time" = '2018-05-29 12:07:33.321', "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-06-09 10:19:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:09:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 23:19:37 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3ms 9ms 5ms 203 1s48ms 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 #4
Day Hour Count Duration Avg duration Jun 09 00 168 860ms 5ms 01 3 13ms 4ms 02 3 22ms 7ms 03 3 23ms 7ms 04 3 13ms 4ms 05 3 24ms 8ms 06 3 13ms 4ms 07 1 4ms 4ms 08 1 4ms 4ms 09 1 4ms 4ms 10 1 4ms 4ms 11 1 4ms 4ms 12 1 8ms 8ms 13 1 4ms 4ms 14 1 4ms 4ms 15 1 4ms 4ms 16 1 4ms 4ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 4ms 4ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 1s48ms - Times executed: 203 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s48ms - Times executed: 203 ]
-
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;
-
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-06-09 03:00:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:00:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 4ms 3ms 288 872ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 09 00 12 38ms 3ms 01 12 36ms 3ms 02 12 37ms 3ms 03 12 36ms 3ms 04 12 35ms 2ms 05 12 35ms 2ms 06 12 34ms 2ms 07 12 37ms 3ms 08 12 35ms 2ms 09 12 36ms 3ms 10 12 36ms 3ms 11 12 37ms 3ms 12 12 35ms 2ms 13 12 36ms 3ms 14 12 34ms 2ms 15 12 36ms 3ms 16 12 36ms 3ms 17 12 36ms 3ms 18 12 36ms 3ms 19 12 36ms 3ms 20 12 36ms 3ms 21 12 38ms 3ms 22 12 35ms 2ms 23 12 35ms 2ms [ User: tony - Total duration: 872ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 872ms - Times executed: 288 ]
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
Date: 2018-06-09 21:01:03 Duration: 4ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 09:16:05 Duration: 4ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-06-09 02:11:04 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
6 0ms 2ms 1ms 646 995ms 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 #6
Day Hour Count Duration Avg duration Jun 09 00 24 36ms 1ms 01 29 43ms 1ms 02 23 35ms 1ms 03 25 38ms 1ms 04 26 39ms 1ms 05 28 44ms 1ms 06 29 44ms 1ms 07 26 40ms 1ms 08 29 44ms 1ms 09 28 43ms 1ms 10 26 39ms 1ms 11 26 40ms 1ms 12 29 44ms 1ms 13 27 41ms 1ms 14 28 43ms 1ms 15 27 41ms 1ms 16 25 39ms 1ms 17 26 40ms 1ms 18 29 44ms 1ms 19 29 44ms 1ms 20 25 37ms 1ms 21 25 37ms 1ms 22 29 44ms 1ms 23 28 42ms 1ms [ User: symmetricds - Total duration: 995ms - Times executed: 646 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 995ms - Times executed: 646 ]
-
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-06-09 05:10:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:02:55 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:20:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 5ms 1ms 793 871ms 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 #7
Day Hour Count Duration Avg duration Jun 09 00 30 34ms 1ms 01 39 44ms 1ms 02 25 24ms 0ms 03 36 36ms 1ms 04 28 37ms 1ms 05 35 38ms 1ms 06 34 42ms 1ms 07 31 36ms 1ms 08 43 49ms 1ms 09 37 37ms 1ms 10 34 36ms 1ms 11 33 35ms 1ms 12 33 36ms 1ms 13 36 38ms 1ms 14 34 33ms 0ms 15 32 33ms 1ms 16 30 32ms 1ms 17 30 34ms 1ms 18 32 37ms 1ms 19 38 41ms 1ms 20 29 29ms 1ms 21 33 33ms 1ms 22 30 33ms 1ms 23 31 33ms 1ms [ User: symmetricds - Total duration: 871ms - Times executed: 793 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 871ms - Times executed: 793 ]
-
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-06-09 04:06:27 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 08:58:34 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 04:30:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 28ms 0ms 1,758 1s147ms 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 Jun 09 00 307 187ms 0ms 01 230 149ms 0ms 02 255 166ms 0ms 03 318 190ms 0ms 04 286 183ms 0ms 05 287 178ms 0ms 06 75 91ms 1ms [ User: pharmisight - Total duration: 1s147ms - Times executed: 1758 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s147ms - Times executed: 1758 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004081669', '2018-06-09 05:32:36', 'KRYSINSKID', '2018-06-09 06:00:00.032', '40891', '8', '150505230116798535');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004087500', '2018-06-09 05:35:15', 'KRYSINSKID', '2018-06-09 06:00:00.032', '40891', '8', '150505230116798788');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004088485', '2018-06-09 01:49:06', 'KRYSINSKID', '2018-06-09 02:20:00.039', '49638', '2', '150505230116782657');
Date: 2018-06-09 06:00:00 Duration: 28ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 06:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 02:20:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 8ms 0ms 5,799 1s192ms 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 Jun 09 00 245 50ms 0ms 01 242 47ms 0ms 02 242 47ms 0ms 03 242 49ms 0ms 04 241 47ms 0ms 05 240 46ms 0ms 06 244 48ms 0ms 07 240 47ms 0ms 08 240 49ms 0ms 09 241 48ms 0ms 10 240 53ms 0ms 11 240 46ms 0ms 12 240 49ms 0ms 13 240 55ms 0ms 14 240 49ms 0ms 15 246 50ms 0ms 16 240 50ms 0ms 17 240 50ms 0ms 18 246 51ms 0ms 19 245 48ms 0ms 20 241 50ms 0ms 21 240 49ms 0ms 22 242 50ms 0ms 23 242 52ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 5799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 5799 ]
-
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;
-
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;
-
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-06-09 13:15:41 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 17:18:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:23:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 5,760 940ms 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 Jun 09 00 240 38ms 0ms 01 240 37ms 0ms 02 240 38ms 0ms 03 240 37ms 0ms 04 240 37ms 0ms 05 240 39ms 0ms 06 240 38ms 0ms 07 240 37ms 0ms 08 240 39ms 0ms 09 240 40ms 0ms 10 240 39ms 0ms 11 240 36ms 0ms 12 240 39ms 0ms 13 240 36ms 0ms 14 240 41ms 0ms 15 240 37ms 0ms 16 240 41ms 0ms 17 240 40ms 0ms 18 240 41ms 0ms 19 240 41ms 0ms 20 240 41ms 0ms 21 240 39ms 0ms 22 240 40ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 940ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 940ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 19:04:50.534', last_lock_time = '2018-06-09 19:04:50.534' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 17:04:50.534');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 14:52:44.074', last_lock_time = '2018-06-09 14:52:44.074' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 12:52:44.074');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-06-09 20:45:53.29', last_lock_time = '2018-06-09 20:45:53.29' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-06-09 18:45:53.29');
Date: 2018-06-09 19:04:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 14:52:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 20:45:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 5,760 807ms 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 Jun 09 00 240 33ms 0ms 01 240 33ms 0ms 02 240 36ms 0ms 03 240 32ms 0ms 04 240 31ms 0ms 05 240 33ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 34ms 0ms 09 240 33ms 0ms 10 240 33ms 0ms 11 240 35ms 0ms 12 240 33ms 0ms 13 240 32ms 0ms 14 240 33ms 0ms 15 240 33ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 34ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 807ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 807ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '97', success_count = '124586', fail_count = '0', total_success_count = '124586', total_fail_count = '0', total_success_millis = '7096310', total_fail_millis = '0', last_lock_time = '2018-06-09 14:31:43.5' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '65', success_count = '124528', fail_count = '0', total_success_count = '124528', total_fail_count = '0', total_success_millis = '7428421', total_fail_millis = '0', last_lock_time = '2018-06-09 11:36:38.984' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '88', success_count = '124736', fail_count = '0', total_success_count = '124736', total_fail_count = '0', total_success_millis = '7108732', total_fail_millis = '0', last_lock_time = '2018-06-09 22:01:55.137' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-06-09 14:31:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:36:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:01:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 4ms 0ms 7,200 658ms 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 Jun 09 00 300 29ms 0ms 01 300 28ms 0ms 02 300 27ms 0ms 03 300 29ms 0ms 04 300 33ms 0ms 05 300 28ms 0ms 06 300 28ms 0ms 07 300 25ms 0ms 08 300 27ms 0ms 09 300 25ms 0ms 10 300 26ms 0ms 11 300 25ms 0ms 12 300 29ms 0ms 13 300 23ms 0ms 14 300 25ms 0ms 15 300 25ms 0ms 16 300 27ms 0ms 17 300 25ms 0ms 18 300 26ms 0ms 19 300 32ms 0ms 20 300 25ms 0ms 21 300 25ms 0ms 22 300 28ms 0ms 23 300 27ms 0ms [ User: symmetricds - Total duration: 658ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 658ms - Times executed: 7200 ]
-
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 = '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 = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-06-09 04:00:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:09:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 22:31:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 5,760 468ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 09 00 240 19ms 0ms 01 240 19ms 0ms 02 240 18ms 0ms 03 240 18ms 0ms 04 240 18ms 0ms 05 240 19ms 0ms 06 240 21ms 0ms 07 240 19ms 0ms 08 240 20ms 0ms 09 240 20ms 0ms 10 240 19ms 0ms 11 240 19ms 0ms 12 240 20ms 0ms 13 240 19ms 0ms 14 240 19ms 0ms 15 240 19ms 0ms 16 240 20ms 0ms 17 240 19ms 0ms 18 240 19ms 0ms 19 240 19ms 0ms 20 240 20ms 0ms 21 240 18ms 0ms 22 240 19ms 0ms 23 240 18ms 0ms [ User: symmetricds - Total duration: 468ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 468ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' 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 = 'PUSH' ORDER BY last_lock_time;
Date: 2018-06-09 06:59:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 09:41:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 06:32:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 1ms 0ms 3,440 267ms SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '' ORDER BY channel_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 09 00 204 15ms 0ms 01 152 10ms 0ms 02 152 12ms 0ms 03 151 10ms 0ms 04 152 11ms 0ms 05 151 11ms 0ms 06 139 10ms 0ms 07 140 9ms 0ms 08 140 11ms 0ms 09 140 10ms 0ms 10 140 11ms 0ms 11 140 10ms 0ms 12 140 10ms 0ms 13 140 10ms 0ms 14 140 11ms 0ms 15 134 9ms 0ms 16 140 11ms 0ms 17 140 10ms 0ms 18 134 10ms 0ms 19 134 12ms 0ms 20 132 10ms 0ms 21 134 9ms 0ms 22 134 10ms 0ms 23 137 11ms 0ms [ User: symmetricds - Total duration: 267ms - Times executed: 3440 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 267ms - Times executed: 3440 ]
-
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;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
Date: 2018-06-09 02:24:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:19:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 10:13:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 3ms 0ms 4,371 333ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 09 00 650 36ms 0ms 01 496 36ms 0ms 02 546 40ms 0ms 03 672 45ms 0ms 04 608 39ms 0ms 05 610 41ms 0ms 06 186 10ms 0ms 07 36 5ms 0ms 08 36 5ms 0ms 09 36 5ms 0ms 10 36 4ms 0ms 11 36 4ms 0ms 12 36 5ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 36 7ms 0ms 20 27 3ms 0ms 21 36 4ms 0ms 22 36 4ms 0ms 23 36 4ms 0ms [ User: symmetricds - Total duration: 333ms - Times executed: 4371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 333ms - Times executed: 4371 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84459111', '7609031', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84458966', '7608838', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('84457432', '7608695', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2018-06-09 19:55:19 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 07:49:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 00:54:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 11ms 0ms 11,521 791ms 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 Jun 09 00 481 44ms 0ms 01 480 32ms 0ms 02 480 31ms 0ms 03 480 31ms 0ms 04 480 32ms 0ms 05 480 32ms 0ms 06 480 31ms 0ms 07 480 31ms 0ms 08 480 30ms 0ms 09 480 31ms 0ms 10 480 33ms 0ms 11 480 36ms 0ms 12 480 36ms 0ms 13 480 31ms 0ms 14 480 31ms 0ms 15 480 30ms 0ms 16 480 32ms 0ms 17 480 31ms 0ms 18 480 31ms 0ms 19 480 32ms 0ms 20 480 35ms 0ms 21 480 31ms 0ms 22 480 32ms 0ms 23 480 33ms 0ms [ User: symmetricds - Total duration: 791ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 791ms - Times executed: 11521 ]
-
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-06-09 00:40:22 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 11:46:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 12:19:40 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 8,581 472ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 09 00 356 20ms 0ms 01 357 20ms 0ms 02 358 21ms 0ms 03 358 21ms 0ms 04 357 21ms 0ms 05 358 20ms 0ms 06 357 19ms 0ms 07 358 19ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 358 19ms 0ms 11 357 19ms 0ms 12 358 19ms 0ms 13 358 19ms 0ms 14 357 18ms 0ms 15 358 19ms 0ms 16 357 18ms 0ms 17 358 19ms 0ms 18 358 19ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 19ms 0ms 22 357 18ms 0ms 23 358 19ms 0ms [ User: symmetricds - Total duration: 472ms - Times executed: 8581 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 472ms - Times executed: 8581 ]
-
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-06-09 04:54:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 21:49:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:30:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 2ms 0ms 16,012 811ms 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 Jun 09 00 696 34ms 0ms 01 668 32ms 0ms 02 669 33ms 0ms 03 669 33ms 0ms 04 668 33ms 0ms 05 669 33ms 0ms 06 666 33ms 0ms 07 666 33ms 0ms 08 666 33ms 0ms 09 665 34ms 0ms 10 666 32ms 0ms 11 665 32ms 0ms 12 666 34ms 0ms 13 666 32ms 0ms 14 665 33ms 0ms 15 666 34ms 0ms 16 665 33ms 0ms 17 666 35ms 0ms 18 666 34ms 0ms 19 665 34ms 0ms 20 662 36ms 0ms 21 663 32ms 0ms 22 663 34ms 0ms 23 666 33ms 0ms [ User: symmetricds - Total duration: 811ms - Times executed: 16012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 811ms - Times executed: 16012 ]
-
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-06-09 20:16:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 03:09:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 09:25:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 77,229 3s646ms 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 Jun 09 00 3,204 150ms 0ms 01 3,213 151ms 0ms 02 3,222 154ms 0ms 03 3,222 150ms 0ms 04 3,213 150ms 0ms 05 3,222 153ms 0ms 06 3,213 151ms 0ms 07 3,222 149ms 0ms 08 3,222 152ms 0ms 09 3,213 152ms 0ms 10 3,222 154ms 0ms 11 3,213 148ms 0ms 12 3,222 151ms 0ms 13 3,222 155ms 0ms 14 3,213 154ms 0ms 15 3,222 150ms 0ms 16 3,213 149ms 0ms 17 3,222 152ms 0ms 18 3,222 153ms 0ms 19 3,213 149ms 0ms 20 3,222 148ms 0ms 21 3,222 151ms 0ms 22 3,213 152ms 0ms 23 3,222 154ms 0ms [ User: symmetricds - Total duration: 3s646ms - Times executed: 77229 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s646ms - Times executed: 77229 ]
-
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-06-09 13:06:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:48:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 13:49:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 5,785 231ms 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 Jun 09 00 265 9ms 0ms 01 240 8ms 0ms 02 240 9ms 0ms 03 240 9ms 0ms 04 240 9ms 0ms 05 240 9ms 0ms 06 240 10ms 0ms 07 240 9ms 0ms 08 240 10ms 0ms 09 240 9ms 0ms 10 240 9ms 0ms 11 240 9ms 0ms 12 240 9ms 0ms 13 240 9ms 0ms 14 240 9ms 0ms 15 240 9ms 0ms 16 240 10ms 0ms 17 240 9ms 0ms 18 240 11ms 0ms 19 240 10ms 0ms 20 240 10ms 0ms 21 240 9ms 0ms 22 240 10ms 0ms 23 240 9ms 0ms [ User: symmetricds - Total duration: 231ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 231ms - Times executed: 5785 ]
-
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-06-09 22:03:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 08:52:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-06-09 19:43:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,291,972 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 09 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-06-09 00:00:09 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: