pgBadger-
Global information
- Generated on Sun Aug 26 00:00:42 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,533,124 log entries in 40s
- Log start from 2018-08-25 00:00:00 to 2018-08-25 23:59:59
-
Overview
Global Stats
- 195 Number of unique normalized queries
- 2,236,616 Number of queries
- 1m12s Total query duration
- 2018-08-25 00:00:00 First query
- 2018-08-25 23:59:59 Last query
- 1,671 queries/s at 2018-08-25 00:40:00 Query peak
- 3 Number of events
- 3 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 276 Total number of automatic vacuums
- 312 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,694 Total number of sessions
- 3 sessions at 2018-08-25 15:10:22 Session peak
- 10d8h55m37s Total duration of sessions
- 8m49s Average duration of sessions
- 1,320 Average queries per session
- 42ms Average queries duration per session
- 1,694 Total number of connections
- 6 connections/s at 2018-08-25 07:18:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,671 queries/s Query Peak
- 2018-08-25 00:40:00 Date
SELECT Traffic
Key values
- 1,571 queries/s Query Peak
- 2018-08-25 04:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 532 queries/s Query Peak
- 2018-08-25 01:20:51 Date
Queries duration
Key values
- 1m12s Total query duration
Prepared queries ratio
Key values
- 1.68 Ratio of bind vs prepare
- 163.93 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 106,350 0ms 26ms 0ms 82ms 252ms 2s135ms 01 95,615 0ms 27ms 0ms 71ms 330ms 419ms 02 93,592 0ms 25ms 0ms 58ms 195ms 404ms 03 94,960 0ms 25ms 0ms 68ms 187ms 413ms 04 93,225 0ms 21ms 0ms 64ms 108ms 354ms 05 93,456 0ms 24ms 0ms 62ms 133ms 344ms 06 91,842 0ms 21ms 0ms 56ms 81ms 262ms 07 92,836 0ms 191ms 0ms 56ms 120ms 746ms 08 93,011 0ms 64ms 0ms 62ms 85ms 338ms 09 92,479 0ms 68ms 0ms 72ms 101ms 372ms 10 92,067 0ms 69ms 0ms 53ms 90ms 262ms 11 91,855 0ms 87ms 0ms 53ms 94ms 369ms 12 92,001 0ms 83ms 0ms 59ms 92ms 458ms 13 92,008 0ms 95ms 0ms 57ms 90ms 415ms 14 91,860 0ms 68ms 0ms 69ms 91ms 262ms 15 92,099 0ms 80ms 0ms 61ms 87ms 250ms 16 91,917 0ms 60ms 0ms 58ms 84ms 177ms 17 91,948 0ms 63ms 0ms 59ms 94ms 202ms 18 91,980 0ms 47ms 0ms 58ms 86ms 162ms 19 91,875 0ms 21ms 0ms 58ms 82ms 162ms 20 94,513 0ms 34ms 0ms 59ms 180ms 482ms 21 91,954 0ms 21ms 0ms 59ms 78ms 179ms 22 91,790 0ms 22ms 0ms 63ms 70ms 163ms 23 91,383 0ms 39ms 0ms 70ms 76ms 169ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 36,251 0 0ms 29ms 31ms 174ms 01 31,476 0 0ms 31ms 36ms 76ms 02 31,112 0 0ms 34ms 36ms 69ms 03 31,350 0 0ms 33ms 36ms 71ms 04 30,945 0 0ms 29ms 33ms 69ms 05 31,038 0 0ms 29ms 33ms 59ms 06 30,627 0 0ms 31ms 34ms 39ms 07 30,914 0 0ms 30ms 35ms 53ms 08 30,948 0 0ms 29ms 32ms 49ms 09 30,872 0 0ms 28ms 37ms 59ms 10 30,733 0 0ms 28ms 35ms 51ms 11 30,660 0 0ms 31ms 35ms 52ms 12 30,690 0 0ms 28ms 35ms 54ms 13 30,693 0 0ms 27ms 34ms 52ms 14 30,663 0 0ms 28ms 41ms 51ms 15 30,764 0 0ms 30ms 41ms 49ms 16 30,658 0 0ms 28ms 37ms 45ms 17 30,687 0 0ms 28ms 35ms 51ms 18 30,676 0 0ms 29ms 35ms 42ms 19 30,644 0 0ms 27ms 34ms 36ms 20 33,077 0 0ms 29ms 33ms 161ms 21 30,694 0 0ms 29ms 35ms 43ms 22 30,588 0 0ms 30ms 33ms 41ms 23 30,505 0 0ms 27ms 37ms 45ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 1,716 2,167 118 0 0ms 10ms 16ms 109ms 01 2,135 1,134 121 0 0ms 1ms 9ms 104ms 02 742 816 115 0 0ms 2ms 9ms 47ms 03 1,700 1,026 118 0 0ms 1ms 9ms 82ms 04 684 758 117 0 0ms 1ms 9ms 50ms 05 664 767 119 0 0ms 1ms 9ms 49ms 06 88 582 114 0 0ms 1ms 7ms 10ms 07 344 672 117 0 0ms 1ms 8ms 26ms 08 395 699 106 0 0ms 1ms 9ms 23ms 09 161 628 104 0 0ms 1ms 8ms 17ms 10 88 581 101 0 0ms 1ms 7ms 10ms 11 88 580 92 0 0ms 1ms 8ms 11ms 12 88 581 94 0 0ms 1ms 7ms 10ms 13 88 582 93 0 0ms 1ms 8ms 11ms 14 88 581 90 0 0ms 1ms 8ms 11ms 15 88 581 89 0 0ms 1ms 8ms 11ms 16 88 580 81 0 0ms 1ms 8ms 11ms 17 88 581 86 0 0ms 1ms 8ms 10ms 18 88 581 82 0 0ms 1ms 8ms 10ms 19 108 603 84 0 0ms 1ms 7ms 10ms 20 126 631 112 0 0ms 1ms 7ms 14ms 21 86 579 79 0 0ms 1ms 5ms 10ms 22 88 581 81 0 0ms 1ms 8ms 10ms 23 88 572 80 0 0ms 1ms 7ms 9ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 25 00 60,843 106,314 1.75 90.05% 01 56,148 95,579 1.70 94.68% 02 55,500 93,556 1.69 96.96% 03 55,810 94,924 1.70 95.18% 04 55,282 93,189 1.69 97.13% 05 55,436 93,420 1.69 97.12% 06 54,683 91,806 1.68 98.23% 07 55,561 92,800 1.67 98.38% 08 55,617 92,975 1.67 98.23% 09 55,589 92,443 1.66 98.92% 10 55,398 92,031 1.66 99.29% 11 55,560 91,819 1.65 99.80% 12 55,140 91,965 1.67 98.92% 13 55,203 91,972 1.67 99.03% 14 55,355 91,824 1.66 99.43% 15 55,962 92,063 1.65 100.27% 16 55,072 91,881 1.67 98.91% 17 55,532 91,912 1.66 99.69% 18 55,216 91,944 1.67 99.10% 19 54,558 91,839 1.68 97.96% 20 55,604 94,477 1.70 95.44% 21 55,496 91,918 1.66 99.64% 22 54,527 91,754 1.68 98.08% 23 54,436 91,347 1.68 98.30% Day Hour Count Average / Second Aug 25 00 64 0.02/s 01 64 0.02/s 02 66 0.02/s 03 65 0.02/s 04 61 0.02/s 05 58 0.02/s 06 58 0.02/s 07 70 0.02/s 08 73 0.02/s 09 75 0.02/s 10 78 0.02/s 11 71 0.02/s 12 72 0.02/s 13 73 0.02/s 14 72 0.02/s 15 88 0.02/s 16 74 0.02/s 17 84 0.02/s 18 75 0.02/s 19 57 0.02/s 20 79 0.02/s 21 86 0.02/s 22 65 0.02/s 23 66 0.02/s Day Hour Count Average Duration Aug 25 00 64 9m48s 01 64 9m9s 02 66 8m40s 03 65 10m2s 04 61 9m15s 05 58 10m59s 06 58 10m39s 07 70 9m7s 08 73 8m20s 09 75 8m11s 10 75 8m 11 74 8m5s 12 72 9m10s 13 73 8m29s 14 72 8m38s 15 88 7m42s 16 74 8m10s 17 84 7m28s 18 75 7m13s 19 57 10m51s 20 79 8m5s 21 86 8m14s 22 59 8m59s 23 72 10m33s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2018-08-25 07:18:20 Date
Connections per database
Key values
- pharmisight Main Database
- 1,694 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,694 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-08-25 15:10:22 Date
Histogram of session times
Key values
- 944 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,694 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,694 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,694 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 8,947 buffers Checkpoint Peak
- 2018-08-25 07:05:22 Date
- 149.970 seconds Highest write time
- 0.010 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2018-08-25 07:07:53 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 Aug 25 00 2,055 205.885s 0.013s 205.94s 01 1,311 131.214s 0.013s 131.268s 02 918 92.084s 0.022s 92.147s 03 939 94.097s 0.025s 94.163s 04 1,040 104.018s 0.02s 104.087s 05 808 80.949s 0.013s 81.004s 06 680 68.216s 0.015s 68.269s 07 9,463 201.277s 0.022s 201.345s 08 1,989 198.798s 0.019s 198.862s 09 2,713 198.216s 0.023s 198.281s 10 1,384 138.543s 0.016s 138.601s 11 2,096 188.608s 0.023s 188.671s 12 1,254 125.276s 0.015s 125.328s 13 2,129 202.443s 0.015s 202.499s 14 1,280 128.09s 0.01s 128.144s 15 1,655 165.736s 0.015s 165.792s 16 895 89.694s 0.021s 89.758s 17 1,533 153.772s 0.014s 153.827s 18 1,092 109.231s 0.026s 109.297s 19 639 64.014s 0.022s 64.083s 20 583 58.484s 0.011s 58.535s 21 739 74.148s 0.014s 74.201s 22 621 62.299s 0.012s 62.351s 23 670 67.212s 0.026s 67.293s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 25 00 0 0 1 397 0.002s 0s 01 0 0 0 346 0.002s 0s 02 0 0 1 366 0.008s 0s 03 0 0 0 365 0.008s 0s 04 0 0 0 330 0.008s 0s 05 0 0 1 351 0.002s 0s 06 0 0 0 326 0.002s 0s 07 0 0 3 356 0.008s 0s 08 0 0 1 362 0.008s 0s 09 0 0 1 312 0.008s 0s 10 0 0 0 292 0.002s 0s 11 0 0 1 282 0.008s 0s 12 0 0 0 284 0.002s 0s 13 0 0 1 290 0.002s 0s 14 0 0 0 292 0.001s 0s 15 0 0 1 289 0.001s 0s 16 0 0 0 293 0.008s 0s 17 0 0 1 296 0.002s 0s 18 0 0 0 300 0.008s 0s 19 0 0 0 303 0.008s 0s 20 0 0 0 329 0.002s 0s 21 0 0 0 318 0.002s 0s 22 0 0 1 337 0.002s 0s 23 0 0 0 369 0.008s 0s Day Hour Count Avg time (sec) Aug 25 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 25 00 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 Aug 25 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
- 11.91 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight - 2018-08-25 07:01:10 Date
- 2.95 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-08-25 07:01:13 Date
Analyzes per table
Key values
- public.sym_node_communication (210) Main table analyzed (database pharmisight)
- 312 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 210 pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data_event 14 pharmisight.public.sym_data 14 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_lock 11 pharmisight.public.sym_sequence 9 pharmisight.public.sym_node_host 6 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.item_codes 2 pharmisight.public.stats_picker_months 1 pharmisight.public.flow_report_summary_months 1 pharmisight.public.flow_report_summary_delays 1 Total 312 Vacuums per table
Key values
- public.sym_node_communication (206) Main table vacuumed on database pharmisight
- 276 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 206 0 pharmisight.public.sym_outgoing_batch 11 11 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_sequence 9 0 pharmisight.public.sym_data_event 8 8 pharmisight.public.sym_data 8 8 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.pg_toast.pg_toast_2619 2 2 Total 276 43 Tuples removed per table
Key values
- public.sym_data_event (37095) Main table with removed tuples on database pharmisight
- 84877 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 8 8 37095 370 pharmisight.public.sym_data 8 8 26181 4724 pharmisight.public.sym_node_communication 206 0 11504 0 pharmisight.public.sym_outgoing_batch 11 11 6333 0 pharmisight.public.sym_incoming_batch 5 5 1031 0 pharmisight.pg_catalog.pg_statistic 3 3 857 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 9 0 465 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 259 0 pharmisight.pg_toast.pg_toast_2619 2 2 168 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 Total 276 43 84,877 5,094 Pages removed per table
Key values
- public.sym_data (4724) Main table with removed pages on database pharmisight
- 5094 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 8 8 26181 4724 pharmisight.public.sym_data_event 8 8 37095 370 pharmisight.public.sym_outgoing_batch 11 11 6333 0 pharmisight.public.sym_incoming_batch 5 5 1031 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.pg_toast.pg_toast_2619 2 2 168 0 pharmisight.public.sym_node_communication 206 0 11504 0 pharmisight.pg_catalog.pg_statistic 3 3 857 0 pharmisight.public.sym_node_host 5 0 259 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 9 0 465 0 Total 276 43 84,877 5,094 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 25 00 10 16 01 12 11 02 11 11 03 10 10 04 11 14 05 12 11 06 8 10 07 13 13 08 12 15 09 12 13 10 11 14 11 11 15 12 13 14 13 13 13 14 15 14 15 12 15 16 13 13 17 13 14 18 12 13 19 10 13 20 12 13 21 11 11 22 10 12 23 9 14 - 11.91 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
- 747,265 Total read queries
- 616,583 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,236,616 Requests
- 1m12s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,272,674 Requests
User Request type Count Duration pharmisight Total 56,893 5s563ms DELETE 33 2ms INSERT 2,306 1s338ms OTHERS 1,452 49ms SELECT 52,432 4s40ms TCL 608 100ms UPDATE 62 30ms symmetricds Total 2,272,674 1m5s DDL 1 1ms DELETE 2,431 4s842ms INSERT 9,150 1s106ms OTHERS 907,392 16s495ms SELECT 724,820 28s221ms TCL 610,497 9s774ms UPDATE 18,383 5s57ms tony Total 900 4s639ms SELECT 900 4s639ms Duration by user
Key values
- 1m5s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 56,893 5s563ms DELETE 33 2ms INSERT 2,306 1s338ms OTHERS 1,452 49ms SELECT 52,432 4s40ms TCL 608 100ms UPDATE 62 30ms symmetricds Total 2,272,674 1m5s DDL 1 1ms DELETE 2,431 4s842ms INSERT 9,150 1s106ms OTHERS 907,392 16s495ms SELECT 724,820 28s221ms TCL 610,497 9s774ms UPDATE 18,383 5s57ms tony Total 900 4s639ms SELECT 900 4s639ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,329,567 Requests
- 1m11s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,234,346 Requests
- 1m8s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-08-25 02:21:31 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,231,211 0-1ms duration
Slowest individual queries
Rank Duration Query 1 191ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7901392' AND '7901971' AND STATUS != 'OK') AND batch_id BETWEEN '7901392' AND '7901971';[ Date: 2018-08-25 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 95ms DELETE FROM sym_data WHERE data_id BETWEEN '88167610' AND '88172610' AND create_time < '2018-08-24 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 87ms DELETE FROM sym_data WHERE data_id BETWEEN '88156268' AND '88161268' AND create_time < '2018-08-24 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 83ms DELETE FROM sym_data WHERE data_id BETWEEN '88162581' AND '88167581' AND create_time < '2018-08-24 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 80ms DELETE FROM sym_data WHERE data_id BETWEEN '88177873' AND '88182873' AND create_time < '2018-08-24 15:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88177873' AND '88182873') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88177873' AND '88182873' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 69ms DELETE FROM sym_data WHERE data_id BETWEEN '88150920' AND '88155920' AND create_time < '2018-08-24 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88150920' AND '88155920') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88150920' AND '88155920' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 68ms DELETE FROM sym_data WHERE data_id BETWEEN '88173590' AND '88178590' AND create_time < '2018-08-24 14:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88173590' AND '88178590') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88173590' AND '88178590' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 68ms DELETE FROM sym_data WHERE data_id BETWEEN '88142679' AND '88147679' AND create_time < '2018-08-24 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88142679' AND '88147679') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88142679' AND '88147679' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 66ms DELETE FROM sym_data WHERE data_id BETWEEN '88106144' AND '88111144' AND create_time < '2018-08-24 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88106144' AND '88111144') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88106144' AND '88111144' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 64ms DELETE FROM sym_data WHERE data_id BETWEEN '88136397' AND '88141397' AND create_time < '2018-08-24 08:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88136397' AND '88141397') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88136397' AND '88141397' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 64ms DELETE FROM sym_data WHERE data_id BETWEEN '88172611' AND '88177611' AND create_time < '2018-08-24 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88172611' AND '88177611') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88172611' AND '88177611' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 13: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 '88184124' AND '88189124' AND create_time < '2018-08-24 17:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88184124' AND '88189124') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88184124' AND '88189124' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 17:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 60ms DELETE FROM sym_data WHERE data_id BETWEEN '88182235' AND '88187235' AND create_time < '2018-08-24 16:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88182235' AND '88187235') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88182235' AND '88187235' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 55ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7903888' AND '7904469' AND STATUS != 'OK') AND batch_id BETWEEN '7903888' AND '7904469';[ Date: 2018-08-25 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 50ms DELETE FROM sym_data WHERE data_id BETWEEN '88167582' AND '88172582' AND create_time < '2018-08-24 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167582' AND '88172582') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167582' AND '88172582' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 48ms DELETE FROM sym_outgoing_batch WHERE STATUS = 'OK' AND batch_id BETWEEN '7901392' AND '7901971' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '7901392' AND '7901971');[ Date: 2018-08-25 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 47ms DELETE FROM sym_data WHERE data_id BETWEEN '88189185' AND '88194185' AND create_time < '2018-08-24 18:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88189185' AND '88194185') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88189185' AND '88194185' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 18:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 44ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7904470' AND '7905031' AND STATUS != 'OK') AND batch_id BETWEEN '7904470' AND '7905031';[ Date: 2018-08-25 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 43ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7905032' AND '7905561' AND STATUS != 'OK') AND batch_id BETWEEN '7905032' AND '7905561';[ Date: 2018-08-25 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 42ms DELETE FROM sym_data WHERE data_id BETWEEN '88172583' AND '88177583' AND create_time < '2018-08-24 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88172583' AND '88177583') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88172583' AND '88177583' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-25 12: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 15s781ms 869,956 0ms 7ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 00 38,683 690ms 0ms 01 36,209 662ms 0ms 02 36,244 661ms 0ms 03 36,216 662ms 0ms 04 36,213 667ms 0ms 05 36,284 681ms 0ms 06 36,083 658ms 0ms 07 36,243 645ms 0ms 08 36,269 656ms 0ms 09 36,159 660ms 0ms 10 36,142 655ms 0ms 11 36,068 650ms 0ms 12 36,140 651ms 0ms 13 36,141 646ms 0ms 14 36,070 646ms 0ms 15 36,137 638ms 0ms 16 36,115 666ms 0ms 17 36,100 644ms 0ms 18 36,139 663ms 0ms 19 36,088 667ms 0ms 20 36,117 634ms 0ms 21 36,107 642ms 0ms 22 36,090 666ms 0ms 23 35,899 661ms 0ms [ User: symmetricds - Total duration: 15s761ms - Times executed: 869493 ]
[ User: pharmisight - Total duration: 20ms - Times executed: 463 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s781ms - Times executed: 869956 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-08-25 16:24:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:22:44 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 23:40:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s624ms 293,414 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 00 13,654 644ms 0ms 01 12,218 331ms 0ms 02 12,228 362ms 0ms 03 12,222 340ms 0ms 04 12,205 309ms 0ms 05 12,246 337ms 0ms 06 12,128 289ms 0ms 07 12,215 317ms 0ms 08 12,236 327ms 0ms 09 12,214 347ms 0ms 10 12,145 282ms 0ms 11 12,125 276ms 0ms 12 12,144 296ms 0ms 13 12,144 277ms 0ms 14 12,124 287ms 0ms 15 12,144 284ms 0ms 16 12,136 278ms 0ms 17 12,131 295ms 0ms 18 12,144 283ms 0ms 19 12,129 301ms 0ms 20 12,158 285ms 0ms 21 12,130 295ms 0ms 22 12,128 285ms 0ms 23 12,066 285ms 0ms [ User: symmetricds - Total duration: 7s530ms - Times executed: 293119 ]
[ User: pharmisight - Total duration: 94ms - Times executed: 295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s624ms - Times executed: 293414 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-08-25 09:45:25 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:47:39 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 08:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s747ms 385,802 0ms 8ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 00 18,051 224ms 0ms 01 16,069 198ms 0ms 02 16,082 197ms 0ms 03 16,069 192ms 0ms 04 16,058 203ms 0ms 05 16,104 196ms 0ms 06 15,966 194ms 0ms 07 16,068 191ms 0ms 08 16,079 200ms 0ms 09 16,015 194ms 0ms 10 15,978 192ms 0ms 11 15,937 192ms 0ms 12 15,974 193ms 0ms 13 15,969 199ms 0ms 14 15,936 194ms 0ms 15 15,964 207ms 0ms 16 15,948 193ms 0ms 17 15,942 194ms 0ms 18 15,959 196ms 0ms 19 15,933 201ms 0ms 20 15,959 193ms 0ms 21 15,940 193ms 0ms 22 15,932 198ms 0ms 23 15,870 200ms 0ms [ User: symmetricds - Total duration: 4s747ms - Times executed: 385802 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s747ms - Times executed: 385802 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-08-25 15:52:12 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:19:42 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:40:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s577ms 77,234 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 Aug 25 00 3,211 152ms 0ms 01 3,213 146ms 0ms 02 3,220 149ms 0ms 03 3,213 150ms 0ms 04 3,222 147ms 0ms 05 3,222 147ms 0ms 06 3,213 149ms 0ms 07 3,222 151ms 0ms 08 3,222 147ms 0ms 09 3,213 146ms 0ms 10 3,222 151ms 0ms 11 3,213 152ms 0ms 12 3,222 146ms 0ms 13 3,222 147ms 0ms 14 3,213 148ms 0ms 15 3,222 151ms 0ms 16 3,219 147ms 0ms 17 3,216 148ms 0ms 18 3,222 149ms 0ms 19 3,213 150ms 0ms 20 3,222 150ms 0ms 21 3,222 146ms 0ms 22 3,213 148ms 0ms 23 3,222 150ms 0ms [ User: symmetricds - Total duration: 3s577ms - Times executed: 77234 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s577ms - Times executed: 77234 ]
-
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-08-25 17:09:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:44:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 19:26:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s511ms 288 1ms 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 Aug 25 00 12 135ms 11ms 01 12 146ms 12ms 02 12 147ms 12ms 03 12 148ms 12ms 04 12 145ms 12ms 05 12 146ms 12ms 06 12 147ms 12ms 07 12 147ms 12ms 08 12 147ms 12ms 09 12 146ms 12ms 10 12 146ms 12ms 11 12 147ms 12ms 12 12 146ms 12ms 13 12 146ms 12ms 14 12 146ms 12ms 15 12 146ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 145ms 12ms 19 12 146ms 12ms 20 12 146ms 12ms 21 12 146ms 12ms 22 12 147ms 12ms 23 12 147ms 12ms [ User: tony - Total duration: 3s511ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s511ms - 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-08-25 03:16:13 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-25 08:01:18 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-25 06:41:15 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
6 2s988ms 219 1ms 95ms 13ms 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 Aug 25 00 18 121ms 6ms 01 18 117ms 6ms 02 18 112ms 6ms 03 18 120ms 6ms 04 18 111ms 6ms 05 18 127ms 7ms 06 18 107ms 5ms 07 18 360ms 20ms 08 12 136ms 11ms 09 11 153ms 13ms 10 9 123ms 13ms 11 8 204ms 25ms 12 7 292ms 41ms 13 6 263ms 43ms 14 5 143ms 28ms 15 4 126ms 31ms 16 3 86ms 28ms 17 3 96ms 32ms 18 2 54ms 27ms 19 1 21ms 21ms 20 1 23ms 23ms 21 1 21ms 21ms 22 1 22ms 22ms 23 1 39ms 39ms [ User: symmetricds - Total duration: 2s988ms - Times executed: 219 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s988ms - Times executed: 219 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167610' AND '88172610' AND create_time < '2018-08-24 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610' 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 '88156268' AND '88161268' AND create_time < '2018-08-24 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268' 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 '88162581' AND '88167581' AND create_time < '2018-08-24 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-08-25 13:00:00 Duration: 95ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 11:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:00:00 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s836ms 293,415 0ms 4ms 0ms BEGIN;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 00 13,656 83ms 0ms 01 12,218 80ms 0ms 02 12,227 76ms 0ms 03 12,222 77ms 0ms 04 12,205 76ms 0ms 05 12,246 77ms 0ms 06 12,128 79ms 0ms 07 12,215 76ms 0ms 08 12,236 77ms 0ms 09 12,215 75ms 0ms 10 12,145 74ms 0ms 11 12,124 74ms 0ms 12 12,144 74ms 0ms 13 12,145 75ms 0ms 14 12,124 75ms 0ms 15 12,144 74ms 0ms 16 12,135 75ms 0ms 17 12,131 75ms 0ms 18 12,144 76ms 0ms 19 12,129 76ms 0ms 20 12,158 75ms 0ms 21 12,131 74ms 0ms 22 12,128 76ms 0ms 23 12,065 76ms 0ms [ User: symmetricds - Total duration: 1s834ms - Times executed: 293120 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s836ms - Times executed: 293415 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-08-25 06:21:33 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:12:25 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:50:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s591ms 68,663 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 Aug 25 00 2,857 69ms 0ms 01 2,860 70ms 0ms 02 2,863 67ms 0ms 03 2,859 69ms 0ms 04 2,864 67ms 0ms 05 2,864 68ms 0ms 06 2,856 67ms 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 65ms 0ms 13 2,864 64ms 0ms 14 2,856 64ms 0ms 15 2,864 64ms 0ms 16 2,861 65ms 0ms 17 2,859 64ms 0ms 18 2,864 64ms 0ms 19 2,856 64ms 0ms 20 2,864 64ms 0ms 21 2,864 64ms 0ms 22 2,856 64ms 0ms 23 2,864 64ms 0ms [ User: symmetricds - Total duration: 1s591ms - Times executed: 68663 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s591ms - Times executed: 68663 ]
-
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 '88194499' AND '138194498')) 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 '88194499' AND '138194498')) 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 '88193705' AND '138193704')) ORDER BY d.data_id ASC;
Date: 2018-08-25 03:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 03:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:20:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s368ms 23,712 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 25 00 988 56ms 0ms 01 988 55ms 0ms 02 988 56ms 0ms 03 988 56ms 0ms 04 988 55ms 0ms 05 988 55ms 0ms 06 988 55ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 56ms 0ms 11 988 55ms 0ms 12 988 57ms 0ms 13 988 57ms 0ms 14 988 56ms 0ms 15 988 56ms 0ms 16 988 56ms 0ms 17 988 56ms 0ms 18 988 57ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 63ms 0ms 22 988 57ms 0ms 23 988 59ms 0ms [ User: pharmisight - Total duration: 1s368ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s368ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3126' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3140' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3440' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-25 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s312ms 232 3ms 16ms 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 #10
Day Hour Count Duration Avg duration Aug 25 00 171 941ms 5ms 01 4 17ms 4ms 02 4 19ms 4ms 03 3 18ms 6ms 04 4 18ms 4ms 05 4 22ms 5ms 06 2 8ms 4ms 07 3 18ms 6ms 08 3 18ms 6ms 09 5 31ms 6ms 10 2 14ms 7ms 11 2 14ms 7ms 12 2 13ms 6ms 13 2 18ms 9ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 14ms 7ms 17 2 14ms 7ms 18 2 9ms 4ms 19 2 8ms 4ms 20 3 21ms 7ms 21 2 9ms 4ms 22 2 13ms 6ms 23 2 18ms 9ms [ User: symmetricds - Total duration: 1s312ms - Times executed: 232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s312ms - Times executed: 232 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' 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 = 'eps' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-08-25 00:00:02 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:00:02 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:00:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s267ms 5,774 0ms 2ms 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 Aug 25 00 247 52ms 0ms 01 240 50ms 0ms 02 241 54ms 0ms 03 240 51ms 0ms 04 241 55ms 0ms 05 247 51ms 0ms 06 240 49ms 0ms 07 242 49ms 0ms 08 240 49ms 0ms 09 239 51ms 0ms 10 239 52ms 0ms 11 240 54ms 0ms 12 240 51ms 0ms 13 237 51ms 0ms 14 239 54ms 0ms 15 240 54ms 0ms 16 237 54ms 0ms 17 240 50ms 0ms 18 240 54ms 0ms 19 243 54ms 0ms 20 240 51ms 0ms 21 240 53ms 0ms 22 243 54ms 0ms 23 239 58ms 0ms [ User: symmetricds - Total duration: 1s267ms - Times executed: 5774 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s267ms - Times executed: 5774 ]
-
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 = '3' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-25 22:44:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 16:08:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 14:15:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s234ms 21,048 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 00 877 52ms 0ms 01 877 50ms 0ms 02 877 50ms 0ms 03 877 51ms 0ms 04 877 50ms 0ms 05 877 50ms 0ms 06 877 50ms 0ms 07 877 50ms 0ms 08 877 51ms 0ms 09 877 51ms 0ms 10 877 51ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 51ms 0ms 15 877 50ms 0ms 16 877 50ms 0ms 17 877 50ms 0ms 18 877 51ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 56ms 0ms 22 877 51ms 0ms 23 877 53ms 0ms [ User: pharmisight - Total duration: 1s234ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s234ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3404' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2887' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '102' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-25 00:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 09:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s225ms 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 #13
Day Hour Count Duration Avg duration Aug 25 00 2,440 52ms 0ms 01 2,400 53ms 0ms 02 2,400 52ms 0ms 03 2,400 52ms 0ms 04 2,400 53ms 0ms 05 2,400 54ms 0ms 06 2,400 49ms 0ms 07 2,400 49ms 0ms 08 2,400 52ms 0ms 09 2,400 54ms 0ms 10 2,400 47ms 0ms 11 2,400 49ms 0ms 12 2,400 52ms 0ms 13 2,400 46ms 0ms 14 2,400 49ms 0ms 15 2,400 48ms 0ms 16 2,400 49ms 0ms 17 2,400 50ms 0ms 18 2,400 52ms 0ms 19 2,400 54ms 0ms 20 2,400 47ms 0ms 21 2,400 49ms 0ms 22 2,400 51ms 0ms 23 2,360 50ms 0ms [ User: symmetricds - Total duration: 1s225ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s225ms - 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 = 'dynamic';
-
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';
Date: 2018-08-25 01:42:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:27:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 19:36:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 1s200ms 191 0ms 11ms 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 #14
Day Hour Count Duration Avg duration Aug 25 00 8 41ms 5ms 01 8 38ms 4ms 02 8 56ms 7ms 03 8 32ms 4ms 04 8 51ms 6ms 05 8 41ms 5ms 06 8 47ms 5ms 07 8 56ms 7ms 08 8 58ms 7ms 09 8 56ms 7ms 10 8 45ms 5ms 11 8 58ms 7ms 12 8 49ms 6ms 13 8 57ms 7ms 14 8 59ms 7ms 15 8 52ms 6ms 16 8 51ms 6ms 17 8 57ms 7ms 18 8 52ms 6ms 19 8 52ms 6ms 20 7 32ms 4ms 21 8 46ms 5ms 22 8 52ms 6ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s200ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s200ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '449774384', "total_memory_bytes" = '532676608', "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-08-25 01:31:36', "last_restart_time" = '2018-08-22 16:06:34', "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" = '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" = '357014480', "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-08-25 08:16:37', "last_restart_time" = '2018-08-22 16:06:34', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '295285120', "total_memory_bytes" = '523239424', "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-08-25 04:22:25', "last_restart_time" = '2018-08-22 16:07:18.163', "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-08-25 01:32:52 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 08:17:17 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:23:02 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 1s166ms 1,968 0ms 9ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 00 424 237ms 0ms 01 509 275ms 0ms 02 195 121ms 0ms 03 400 228ms 0ms 04 147 86ms 0ms 05 141 92ms 0ms 07 62 49ms 0ms 08 74 59ms 0ms 09 16 15ms 0ms [ User: pharmisight - Total duration: 1s166ms - Times executed: 1968 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s166ms - Times executed: 1968 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004418203', '2018-08-24 23:31:30', 'BERLANR', '2018-08-25 00:00:00.051', '49703', '3', '31237090287554002');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004272716', '2018-08-25 03:27:04', 'RYBAKJ', '2018-08-25 03:40:01.204', '41088', '14', '150505230122588526');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004406516', '2018-08-25 04:24:13', 'PRICEM', '2018-08-25 05:00:00.026', '77154', '30', '150505230122591991');
Date: 2018-08-25 00:00:00 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 03:40:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 05:00:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 1s95ms 996 0ms 7ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 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 #16
Day Hour Count Duration Avg duration Aug 25 00 33 30ms 0ms 01 38 40ms 1ms 02 37 38ms 1ms 03 35 38ms 1ms 04 31 33ms 1ms 05 33 40ms 1ms 06 34 36ms 1ms 07 41 43ms 1ms 08 41 41ms 1ms 09 43 45ms 1ms 10 48 61ms 1ms 11 50 54ms 1ms 12 41 45ms 1ms 13 42 49ms 1ms 14 49 53ms 1ms 15 59 62ms 1ms 16 41 45ms 1ms 17 53 54ms 1ms 18 42 46ms 1ms 19 30 32ms 1ms 20 51 61ms 1ms 21 52 56ms 1ms 22 34 35ms 1ms 23 38 46ms 1ms [ User: symmetricds - Total duration: 1s95ms - Times executed: 996 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s95ms - Times executed: 996 ]
-
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-08-25 10:14:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:22:39 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 20:40:55 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 963ms 219 0ms 15ms 4ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 00 18 92ms 5ms 01 18 84ms 4ms 02 18 84ms 4ms 03 18 87ms 4ms 04 18 85ms 4ms 05 18 83ms 4ms 06 18 83ms 4ms 07 18 71ms 3ms 08 12 47ms 3ms 09 11 40ms 3ms 10 9 34ms 3ms 11 8 29ms 3ms 12 7 48ms 6ms 13 6 28ms 4ms 14 5 15ms 3ms 15 4 12ms 3ms 16 3 9ms 3ms 17 3 6ms 2ms 18 2 3ms 1ms 19 1 2ms 2ms 20 1 4ms 4ms 21 1 2ms 2ms 22 1 2ms 2ms 23 1 2ms 2ms [ User: symmetricds - Total duration: 963ms - Times executed: 219 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 963ms - Times executed: 219 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167582' AND '88172582' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167582' AND '88172582');
-
DELETE FROM sym_data WHERE data_id BETWEEN '88162581' AND '88167581' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581');
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167610' AND '88172610' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 13:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610');
Date: 2018-08-25 12:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:00:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 909ms 5,760 0ms 1ms 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 #18
Day Hour Count Duration Avg duration Aug 25 00 244 38ms 0ms 01 240 40ms 0ms 02 240 39ms 0ms 03 240 39ms 0ms 04 240 39ms 0ms 05 240 40ms 0ms 06 240 39ms 0ms 07 240 36ms 0ms 08 240 41ms 0ms 09 240 36ms 0ms 10 240 35ms 0ms 11 240 37ms 0ms 12 240 36ms 0ms 13 240 36ms 0ms 14 240 36ms 0ms 15 240 35ms 0ms 16 240 36ms 0ms 17 240 36ms 0ms 18 240 38ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 37ms 0ms 22 240 39ms 0ms 23 236 38ms 0ms [ User: symmetricds - Total duration: 909ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 909ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 22:43:59.071', last_lock_time = '2018-08-25 22:43:59.071' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 20:43:59.071');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 04:03:30.239', last_lock_time = '2018-08-25 04:03:30.239' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 02:03:30.239');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 07:07:34.863', last_lock_time = '2018-08-25 07:07:34.863' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 05:07:34.863');
Date: 2018-08-25 22:43:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:03:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:07:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 886ms 895 0ms 3ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 00 28 26ms 0ms 01 33 32ms 0ms 02 35 34ms 0ms 03 32 31ms 0ms 04 29 27ms 0ms 05 30 31ms 1ms 06 30 28ms 0ms 07 39 38ms 0ms 08 35 34ms 0ms 09 37 36ms 0ms 10 41 40ms 0ms 11 43 41ms 0ms 12 37 36ms 0ms 13 39 38ms 0ms 14 44 45ms 1ms 15 52 55ms 1ms 16 37 36ms 0ms 17 48 46ms 0ms 18 40 39ms 0ms 19 26 26ms 1ms 20 45 44ms 0ms 21 50 49ms 0ms 22 31 31ms 1ms 23 34 33ms 0ms [ User: symmetricds - Total duration: 886ms - Times executed: 895 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 886ms - Times executed: 895 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-08-25 15:56:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:48:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:28:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 802ms 16,112 0ms 5ms 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 #20
Day Hour Count Duration Avg duration Aug 25 00 704 41ms 0ms 01 671 34ms 0ms 02 672 32ms 0ms 03 671 32ms 0ms 04 671 34ms 0ms 05 673 33ms 0ms 06 669 34ms 0ms 07 672 32ms 0ms 08 672 33ms 0ms 09 669 33ms 0ms 10 670 32ms 0ms 11 669 31ms 0ms 12 670 31ms 0ms 13 670 33ms 0ms 14 669 34ms 0ms 15 670 31ms 0ms 16 670 34ms 0ms 17 669 32ms 0ms 18 670 32ms 0ms 19 669 33ms 0ms 20 669 33ms 0ms 21 669 30ms 0ms 22 669 33ms 0ms 23 665 33ms 0ms [ User: symmetricds - Total duration: 802ms - Times executed: 16112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 802ms - Times executed: 16112 ]
-
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-08-25 00:02:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:16:24 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:06:33 Duration: 2ms 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 869,956 15s781ms 0ms 7ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 00 38,683 690ms 0ms 01 36,209 662ms 0ms 02 36,244 661ms 0ms 03 36,216 662ms 0ms 04 36,213 667ms 0ms 05 36,284 681ms 0ms 06 36,083 658ms 0ms 07 36,243 645ms 0ms 08 36,269 656ms 0ms 09 36,159 660ms 0ms 10 36,142 655ms 0ms 11 36,068 650ms 0ms 12 36,140 651ms 0ms 13 36,141 646ms 0ms 14 36,070 646ms 0ms 15 36,137 638ms 0ms 16 36,115 666ms 0ms 17 36,100 644ms 0ms 18 36,139 663ms 0ms 19 36,088 667ms 0ms 20 36,117 634ms 0ms 21 36,107 642ms 0ms 22 36,090 666ms 0ms 23 35,899 661ms 0ms [ User: symmetricds - Total duration: 15s761ms - Times executed: 869493 ]
[ User: pharmisight - Total duration: 20ms - Times executed: 463 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s781ms - Times executed: 869956 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-08-25 16:24:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:22:44 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 23:40:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 385,802 4s747ms 0ms 8ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 00 18,051 224ms 0ms 01 16,069 198ms 0ms 02 16,082 197ms 0ms 03 16,069 192ms 0ms 04 16,058 203ms 0ms 05 16,104 196ms 0ms 06 15,966 194ms 0ms 07 16,068 191ms 0ms 08 16,079 200ms 0ms 09 16,015 194ms 0ms 10 15,978 192ms 0ms 11 15,937 192ms 0ms 12 15,974 193ms 0ms 13 15,969 199ms 0ms 14 15,936 194ms 0ms 15 15,964 207ms 0ms 16 15,948 193ms 0ms 17 15,942 194ms 0ms 18 15,959 196ms 0ms 19 15,933 201ms 0ms 20 15,959 193ms 0ms 21 15,940 193ms 0ms 22 15,932 198ms 0ms 23 15,870 200ms 0ms [ User: symmetricds - Total duration: 4s747ms - Times executed: 385802 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s747ms - Times executed: 385802 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-08-25 15:52:12 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:19:42 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:40:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 293,415 1s836ms 0ms 4ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 00 13,656 83ms 0ms 01 12,218 80ms 0ms 02 12,227 76ms 0ms 03 12,222 77ms 0ms 04 12,205 76ms 0ms 05 12,246 77ms 0ms 06 12,128 79ms 0ms 07 12,215 76ms 0ms 08 12,236 77ms 0ms 09 12,215 75ms 0ms 10 12,145 74ms 0ms 11 12,124 74ms 0ms 12 12,144 74ms 0ms 13 12,145 75ms 0ms 14 12,124 75ms 0ms 15 12,144 74ms 0ms 16 12,135 75ms 0ms 17 12,131 75ms 0ms 18 12,144 76ms 0ms 19 12,129 76ms 0ms 20 12,158 75ms 0ms 21 12,131 74ms 0ms 22 12,128 76ms 0ms 23 12,065 76ms 0ms [ User: symmetricds - Total duration: 1s834ms - Times executed: 293120 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s836ms - Times executed: 293415 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-08-25 06:21:33 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:12:25 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:50:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 293,414 7s624ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 00 13,654 644ms 0ms 01 12,218 331ms 0ms 02 12,228 362ms 0ms 03 12,222 340ms 0ms 04 12,205 309ms 0ms 05 12,246 337ms 0ms 06 12,128 289ms 0ms 07 12,215 317ms 0ms 08 12,236 327ms 0ms 09 12,214 347ms 0ms 10 12,145 282ms 0ms 11 12,125 276ms 0ms 12 12,144 296ms 0ms 13 12,144 277ms 0ms 14 12,124 287ms 0ms 15 12,144 284ms 0ms 16 12,136 278ms 0ms 17 12,131 295ms 0ms 18 12,144 283ms 0ms 19 12,129 301ms 0ms 20 12,158 285ms 0ms 21 12,130 295ms 0ms 22 12,128 285ms 0ms 23 12,066 285ms 0ms [ User: symmetricds - Total duration: 7s530ms - Times executed: 293119 ]
[ User: pharmisight - Total duration: 94ms - Times executed: 295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s624ms - Times executed: 293414 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-08-25 09:45:25 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:47:39 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 08:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 77,234 3s577ms 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 Aug 25 00 3,211 152ms 0ms 01 3,213 146ms 0ms 02 3,220 149ms 0ms 03 3,213 150ms 0ms 04 3,222 147ms 0ms 05 3,222 147ms 0ms 06 3,213 149ms 0ms 07 3,222 151ms 0ms 08 3,222 147ms 0ms 09 3,213 146ms 0ms 10 3,222 151ms 0ms 11 3,213 152ms 0ms 12 3,222 146ms 0ms 13 3,222 147ms 0ms 14 3,213 148ms 0ms 15 3,222 151ms 0ms 16 3,219 147ms 0ms 17 3,216 148ms 0ms 18 3,222 149ms 0ms 19 3,213 150ms 0ms 20 3,222 150ms 0ms 21 3,222 146ms 0ms 22 3,213 148ms 0ms 23 3,222 150ms 0ms [ User: symmetricds - Total duration: 3s577ms - Times executed: 77234 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s577ms - Times executed: 77234 ]
-
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-08-25 17:09:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:44:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 19:26:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 68,663 1s591ms 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 Aug 25 00 2,857 69ms 0ms 01 2,860 70ms 0ms 02 2,863 67ms 0ms 03 2,859 69ms 0ms 04 2,864 67ms 0ms 05 2,864 68ms 0ms 06 2,856 67ms 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 65ms 0ms 13 2,864 64ms 0ms 14 2,856 64ms 0ms 15 2,864 64ms 0ms 16 2,861 65ms 0ms 17 2,859 64ms 0ms 18 2,864 64ms 0ms 19 2,856 64ms 0ms 20 2,864 64ms 0ms 21 2,864 64ms 0ms 22 2,856 64ms 0ms 23 2,864 64ms 0ms [ User: symmetricds - Total duration: 1s591ms - Times executed: 68663 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s591ms - Times executed: 68663 ]
-
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 '88194499' AND '138194498')) 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 '88194499' AND '138194498')) 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 '88193705' AND '138193704')) ORDER BY d.data_id ASC;
Date: 2018-08-25 03:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 03:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:20:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 57,600 1s225ms 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 Aug 25 00 2,440 52ms 0ms 01 2,400 53ms 0ms 02 2,400 52ms 0ms 03 2,400 52ms 0ms 04 2,400 53ms 0ms 05 2,400 54ms 0ms 06 2,400 49ms 0ms 07 2,400 49ms 0ms 08 2,400 52ms 0ms 09 2,400 54ms 0ms 10 2,400 47ms 0ms 11 2,400 49ms 0ms 12 2,400 52ms 0ms 13 2,400 46ms 0ms 14 2,400 49ms 0ms 15 2,400 48ms 0ms 16 2,400 49ms 0ms 17 2,400 50ms 0ms 18 2,400 52ms 0ms 19 2,400 54ms 0ms 20 2,400 47ms 0ms 21 2,400 49ms 0ms 22 2,400 51ms 0ms 23 2,360 50ms 0ms [ User: symmetricds - Total duration: 1s225ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s225ms - 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 = 'dynamic';
-
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';
Date: 2018-08-25 01:42:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:27:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 19:36:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 23,712 1s368ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 25 00 988 56ms 0ms 01 988 55ms 0ms 02 988 56ms 0ms 03 988 56ms 0ms 04 988 55ms 0ms 05 988 55ms 0ms 06 988 55ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 56ms 0ms 11 988 55ms 0ms 12 988 57ms 0ms 13 988 57ms 0ms 14 988 56ms 0ms 15 988 56ms 0ms 16 988 56ms 0ms 17 988 56ms 0ms 18 988 57ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 63ms 0ms 22 988 57ms 0ms 23 988 59ms 0ms [ User: pharmisight - Total duration: 1s368ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s368ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3126' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3140' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3440' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-25 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 21,048 1s234ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 25 00 877 52ms 0ms 01 877 50ms 0ms 02 877 50ms 0ms 03 877 51ms 0ms 04 877 50ms 0ms 05 877 50ms 0ms 06 877 50ms 0ms 07 877 50ms 0ms 08 877 51ms 0ms 09 877 51ms 0ms 10 877 51ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 51ms 0ms 15 877 50ms 0ms 16 877 50ms 0ms 17 877 50ms 0ms 18 877 51ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 56ms 0ms 22 877 51ms 0ms 23 877 53ms 0ms [ User: pharmisight - Total duration: 1s234ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s234ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3404' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2887' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '102' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-25 00:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 09:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 16,112 802ms 0ms 5ms 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 #10
Day Hour Count Duration Avg duration Aug 25 00 704 41ms 0ms 01 671 34ms 0ms 02 672 32ms 0ms 03 671 32ms 0ms 04 671 34ms 0ms 05 673 33ms 0ms 06 669 34ms 0ms 07 672 32ms 0ms 08 672 33ms 0ms 09 669 33ms 0ms 10 670 32ms 0ms 11 669 31ms 0ms 12 670 31ms 0ms 13 670 33ms 0ms 14 669 34ms 0ms 15 670 31ms 0ms 16 670 34ms 0ms 17 669 32ms 0ms 18 670 32ms 0ms 19 669 33ms 0ms 20 669 33ms 0ms 21 669 30ms 0ms 22 669 33ms 0ms 23 665 33ms 0ms [ User: symmetricds - Total duration: 802ms - Times executed: 16112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 802ms - Times executed: 16112 ]
-
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-08-25 00:02:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:16:24 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:06:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 11,521 739ms 0ms 4ms 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 #11
Day Hour Count Duration Avg duration Aug 25 00 489 31ms 0ms 01 480 29ms 0ms 02 480 34ms 0ms 03 480 29ms 0ms 04 480 34ms 0ms 05 480 30ms 0ms 06 480 30ms 0ms 07 480 31ms 0ms 08 480 29ms 0ms 09 480 31ms 0ms 10 480 29ms 0ms 11 480 33ms 0ms 12 480 28ms 0ms 13 480 32ms 0ms 14 480 31ms 0ms 15 480 31ms 0ms 16 480 29ms 0ms 17 480 29ms 0ms 18 480 30ms 0ms 19 480 29ms 0ms 20 480 29ms 0ms 21 480 30ms 0ms 22 480 31ms 0ms 23 472 28ms 0ms [ User: symmetricds - Total duration: 739ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 739ms - 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-08-25 11:30:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:22:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:17:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,634 286ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 00 359 12ms 0ms 01 360 11ms 0ms 02 360 11ms 0ms 03 359 11ms 0ms 04 360 12ms 0ms 05 360 12ms 0ms 06 359 12ms 0ms 07 360 12ms 0ms 08 360 11ms 0ms 09 360 12ms 0ms 10 359 12ms 0ms 11 360 12ms 0ms 12 360 11ms 0ms 13 360 11ms 0ms 14 360 11ms 0ms 15 360 11ms 0ms 16 359 11ms 0ms 17 360 11ms 0ms 18 360 12ms 0ms 19 360 12ms 0ms 20 360 11ms 0ms 21 360 11ms 0ms 22 360 11ms 0ms 23 359 11ms 0ms [ User: symmetricds - Total duration: 286ms - Times executed: 8634 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 286ms - Times executed: 8634 ]
-
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-08-25 10:12:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:56:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:42:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,593 197ms 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 #13
Day Hour Count Duration Avg duration Aug 25 00 360 9ms 0ms 01 361 9ms 0ms 02 359 8ms 0ms 03 360 9ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 357 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 357 8ms 0ms 10 358 8ms 0ms 11 357 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 357 7ms 0ms 15 358 7ms 0ms 16 358 8ms 0ms 17 357 7ms 0ms 18 358 7ms 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: 197ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 197ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '88193705' AND data_id <= '138193704' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '88194499' AND data_id <= '138194498' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '88193963' AND data_id <= '138193962' ORDER BY data_id ASC;
Date: 2018-08-25 01:20:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 03:40:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:40:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,582 463ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 00 357 20ms 0ms 01 357 20ms 0ms 02 358 19ms 0ms 03 357 19ms 0ms 04 358 19ms 0ms 05 358 20ms 0ms 06 357 19ms 0ms 07 358 20ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 358 18ms 0ms 11 357 19ms 0ms 12 358 18ms 0ms 13 358 18ms 0ms 14 357 18ms 0ms 15 358 18ms 0ms 16 358 19ms 0ms 17 357 18ms 0ms 18 358 18ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 18ms 0ms 22 357 19ms 0ms 23 358 19ms 0ms [ User: symmetricds - Total duration: 463ms - Times executed: 8582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 463ms - Times executed: 8582 ]
-
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-08-25 02:15:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:30:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:08:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 7,200 676ms 0ms 2ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 00 305 34ms 0ms 01 300 33ms 0ms 02 300 32ms 0ms 03 300 33ms 0ms 04 300 27ms 0ms 05 300 29ms 0ms 06 300 26ms 0ms 07 300 29ms 0ms 08 300 26ms 0ms 09 300 29ms 0ms 10 300 26ms 0ms 11 300 28ms 0ms 12 300 25ms 0ms 13 300 25ms 0ms 14 300 25ms 0ms 15 300 27ms 0ms 16 300 29ms 0ms 17 300 24ms 0ms 18 300 28ms 0ms 19 300 26ms 0ms 20 300 27ms 0ms 21 300 25ms 0ms 22 300 26ms 0ms 23 295 28ms 0ms [ User: symmetricds - Total duration: 676ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 676ms - 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-08-25 11:21:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 16:01:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 02:57:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,785 221ms 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 #16
Day Hour Count Duration Avg duration Aug 25 00 269 10ms 0ms 01 240 9ms 0ms 02 240 8ms 0ms 03 240 8ms 0ms 04 240 8ms 0ms 05 240 9ms 0ms 06 240 8ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 9ms 0ms 10 240 8ms 0ms 11 240 9ms 0ms 12 240 8ms 0ms 13 240 9ms 0ms 14 240 9ms 0ms 15 240 10ms 0ms 16 240 9ms 0ms 17 240 9ms 0ms 18 240 8ms 0ms 19 240 9ms 0ms 20 240 9ms 0ms 21 240 9ms 0ms 22 240 11ms 0ms 23 236 8ms 0ms [ User: symmetricds - Total duration: 221ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 221ms - 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-08-25 15:40:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:35:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 14:14:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,774 1s267ms 0ms 2ms 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 #17
Day Hour Count Duration Avg duration Aug 25 00 247 52ms 0ms 01 240 50ms 0ms 02 241 54ms 0ms 03 240 51ms 0ms 04 241 55ms 0ms 05 247 51ms 0ms 06 240 49ms 0ms 07 242 49ms 0ms 08 240 49ms 0ms 09 239 51ms 0ms 10 239 52ms 0ms 11 240 54ms 0ms 12 240 51ms 0ms 13 237 51ms 0ms 14 239 54ms 0ms 15 240 54ms 0ms 16 237 54ms 0ms 17 240 50ms 0ms 18 240 54ms 0ms 19 243 54ms 0ms 20 240 51ms 0ms 21 240 53ms 0ms 22 243 54ms 0ms 23 239 58ms 0ms [ User: symmetricds - Total duration: 1s267ms - Times executed: 5774 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s267ms - Times executed: 5774 ]
-
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 = '3' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-25 22:44:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 16:08:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 14:15:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,760 774ms 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 Aug 25 00 244 32ms 0ms 01 240 32ms 0ms 02 240 32ms 0ms 03 240 32ms 0ms 04 240 32ms 0ms 05 240 32ms 0ms 06 240 35ms 0ms 07 240 31ms 0ms 08 240 34ms 0ms 09 240 31ms 0ms 10 240 32ms 0ms 11 240 30ms 0ms 12 240 32ms 0ms 13 240 31ms 0ms 14 240 32ms 0ms 15 240 30ms 0ms 16 240 31ms 0ms 17 240 31ms 0ms 18 240 32ms 0ms 19 240 32ms 0ms 20 240 31ms 0ms 21 240 32ms 0ms 22 240 31ms 0ms 23 236 32ms 0ms [ User: symmetricds - Total duration: 774ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 774ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '160548', fail_count = '0', total_success_count = '160548', total_fail_count = '0', total_success_millis = '10705528', total_fail_millis = '0', last_lock_time = '2018-08-25 17:39:51.202' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '75', success_count = '160503', fail_count = '0', total_success_count = '160503', total_fail_count = '0', total_success_millis = '10257680', total_fail_millis = '0', last_lock_time = '2018-08-25 18:19:52.231' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '64', success_count = '160262', fail_count = '0', total_success_count = '160262', total_fail_count = '0', total_success_millis = '9858078', total_fail_millis = '0', last_lock_time = '2018-08-25 06:17:33.552' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-08-25 17:39:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 18:19:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:17:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 5,760 909ms 0ms 1ms 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 #19
Day Hour Count Duration Avg duration Aug 25 00 244 38ms 0ms 01 240 40ms 0ms 02 240 39ms 0ms 03 240 39ms 0ms 04 240 39ms 0ms 05 240 40ms 0ms 06 240 39ms 0ms 07 240 36ms 0ms 08 240 41ms 0ms 09 240 36ms 0ms 10 240 35ms 0ms 11 240 37ms 0ms 12 240 36ms 0ms 13 240 36ms 0ms 14 240 36ms 0ms 15 240 35ms 0ms 16 240 36ms 0ms 17 240 36ms 0ms 18 240 38ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 37ms 0ms 22 240 39ms 0ms 23 236 38ms 0ms [ User: symmetricds - Total duration: 909ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 909ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 22:43:59.071', last_lock_time = '2018-08-25 22:43:59.071' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 20:43:59.071');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 04:03:30.239', last_lock_time = '2018-08-25 04:03:30.239' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 02:03:30.239');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 07:07:34.863', last_lock_time = '2018-08-25 07:07:34.863' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 05:07:34.863');
Date: 2018-08-25 22:43:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:03:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:07:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 5,760 426ms 0ms 0ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 00 244 18ms 0ms 01 240 17ms 0ms 02 240 17ms 0ms 03 240 17ms 0ms 04 240 17ms 0ms 05 240 19ms 0ms 06 240 18ms 0ms 07 240 17ms 0ms 08 240 17ms 0ms 09 240 17ms 0ms 10 240 17ms 0ms 11 240 17ms 0ms 12 240 17ms 0ms 13 240 17ms 0ms 14 240 17ms 0ms 15 240 16ms 0ms 16 240 17ms 0ms 17 240 17ms 0ms 18 240 18ms 0ms 19 240 17ms 0ms 20 240 18ms 0ms 21 240 18ms 0ms 22 240 19ms 0ms 23 236 17ms 0ms [ User: symmetricds - Total duration: 426ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 426ms - 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 = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-08-25 20:11:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:44:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:14:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1ms 95ms 13ms 219 2s988ms 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 Aug 25 00 18 121ms 6ms 01 18 117ms 6ms 02 18 112ms 6ms 03 18 120ms 6ms 04 18 111ms 6ms 05 18 127ms 7ms 06 18 107ms 5ms 07 18 360ms 20ms 08 12 136ms 11ms 09 11 153ms 13ms 10 9 123ms 13ms 11 8 204ms 25ms 12 7 292ms 41ms 13 6 263ms 43ms 14 5 143ms 28ms 15 4 126ms 31ms 16 3 86ms 28ms 17 3 96ms 32ms 18 2 54ms 27ms 19 1 21ms 21ms 20 1 23ms 23ms 21 1 21ms 21ms 22 1 22ms 22ms 23 1 39ms 39ms [ User: symmetricds - Total duration: 2s988ms - Times executed: 219 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s988ms - Times executed: 219 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167610' AND '88172610' AND create_time < '2018-08-24 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610' 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 '88156268' AND '88161268' AND create_time < '2018-08-24 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88156268' AND '88161268' 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 '88162581' AND '88167581' AND create_time < '2018-08-24 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-08-25 13:00:00 Duration: 95ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 11:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:00:00 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 1ms 12ms 12ms 288 3s511ms 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 Aug 25 00 12 135ms 11ms 01 12 146ms 12ms 02 12 147ms 12ms 03 12 148ms 12ms 04 12 145ms 12ms 05 12 146ms 12ms 06 12 147ms 12ms 07 12 147ms 12ms 08 12 147ms 12ms 09 12 146ms 12ms 10 12 146ms 12ms 11 12 147ms 12ms 12 12 146ms 12ms 13 12 146ms 12ms 14 12 146ms 12ms 15 12 146ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 145ms 12ms 19 12 146ms 12ms 20 12 146ms 12ms 21 12 146ms 12ms 22 12 147ms 12ms 23 12 147ms 12ms [ User: tony - Total duration: 3s511ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s511ms - 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-08-25 03:16:13 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-25 08:01:18 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-25 06:41:15 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
3 0ms 11ms 6ms 191 1s200ms 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 Aug 25 00 8 41ms 5ms 01 8 38ms 4ms 02 8 56ms 7ms 03 8 32ms 4ms 04 8 51ms 6ms 05 8 41ms 5ms 06 8 47ms 5ms 07 8 56ms 7ms 08 8 58ms 7ms 09 8 56ms 7ms 10 8 45ms 5ms 11 8 58ms 7ms 12 8 49ms 6ms 13 8 57ms 7ms 14 8 59ms 7ms 15 8 52ms 6ms 16 8 51ms 6ms 17 8 57ms 7ms 18 8 52ms 6ms 19 8 52ms 6ms 20 7 32ms 4ms 21 8 46ms 5ms 22 8 52ms 6ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s200ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s200ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '449774384', "total_memory_bytes" = '532676608', "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-08-25 01:31:36', "last_restart_time" = '2018-08-22 16:06:34', "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" = '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" = '357014480', "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-08-25 08:16:37', "last_restart_time" = '2018-08-22 16:06:34', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '295285120', "total_memory_bytes" = '523239424', "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-08-25 04:22:25', "last_restart_time" = '2018-08-22 16:07:18.163', "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-08-25 01:32:52 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 08:17:17 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:23:02 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3ms 16ms 5ms 232 1s312ms 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 Aug 25 00 171 941ms 5ms 01 4 17ms 4ms 02 4 19ms 4ms 03 3 18ms 6ms 04 4 18ms 4ms 05 4 22ms 5ms 06 2 8ms 4ms 07 3 18ms 6ms 08 3 18ms 6ms 09 5 31ms 6ms 10 2 14ms 7ms 11 2 14ms 7ms 12 2 13ms 6ms 13 2 18ms 9ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 14ms 7ms 17 2 14ms 7ms 18 2 9ms 4ms 19 2 8ms 4ms 20 3 21ms 7ms 21 2 9ms 4ms 22 2 13ms 6ms 23 2 18ms 9ms [ User: symmetricds - Total duration: 1s312ms - Times executed: 232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s312ms - Times executed: 232 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' 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 = 'eps' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-08-25 00:00:02 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:00:02 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:00:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 15ms 4ms 219 963ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 25 00 18 92ms 5ms 01 18 84ms 4ms 02 18 84ms 4ms 03 18 87ms 4ms 04 18 85ms 4ms 05 18 83ms 4ms 06 18 83ms 4ms 07 18 71ms 3ms 08 12 47ms 3ms 09 11 40ms 3ms 10 9 34ms 3ms 11 8 29ms 3ms 12 7 48ms 6ms 13 6 28ms 4ms 14 5 15ms 3ms 15 4 12ms 3ms 16 3 9ms 3ms 17 3 6ms 2ms 18 2 3ms 1ms 19 1 2ms 2ms 20 1 4ms 4ms 21 1 2ms 2ms 22 1 2ms 2ms 23 1 2ms 2ms [ User: symmetricds - Total duration: 963ms - Times executed: 219 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 963ms - Times executed: 219 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167582' AND '88172582' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167582' AND '88172582');
-
DELETE FROM sym_data WHERE data_id BETWEEN '88162581' AND '88167581' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88162581' AND '88167581');
-
DELETE FROM sym_data WHERE data_id BETWEEN '88167610' AND '88172610' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-08-24 13:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '88167610' AND '88172610');
Date: 2018-08-25 12:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 12:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:00:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 7ms 1ms 996 1s95ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 25 00 33 30ms 0ms 01 38 40ms 1ms 02 37 38ms 1ms 03 35 38ms 1ms 04 31 33ms 1ms 05 33 40ms 1ms 06 34 36ms 1ms 07 41 43ms 1ms 08 41 41ms 1ms 09 43 45ms 1ms 10 48 61ms 1ms 11 50 54ms 1ms 12 41 45ms 1ms 13 42 49ms 1ms 14 49 53ms 1ms 15 59 62ms 1ms 16 41 45ms 1ms 17 53 54ms 1ms 18 42 46ms 1ms 19 30 32ms 1ms 20 51 61ms 1ms 21 52 56ms 1ms 22 34 35ms 1ms 23 38 46ms 1ms [ User: symmetricds - Total duration: 1s95ms - Times executed: 996 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s95ms - Times executed: 996 ]
-
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-08-25 10:14:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:22:39 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 20:40:55 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 3ms 0ms 895 886ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 00 28 26ms 0ms 01 33 32ms 0ms 02 35 34ms 0ms 03 32 31ms 0ms 04 29 27ms 0ms 05 30 31ms 1ms 06 30 28ms 0ms 07 39 38ms 0ms 08 35 34ms 0ms 09 37 36ms 0ms 10 41 40ms 0ms 11 43 41ms 0ms 12 37 36ms 0ms 13 39 38ms 0ms 14 44 45ms 1ms 15 52 55ms 1ms 16 37 36ms 0ms 17 48 46ms 0ms 18 40 39ms 0ms 19 26 26ms 1ms 20 45 44ms 0ms 21 50 49ms 0ms 22 31 31ms 1ms 23 34 33ms 0ms [ User: symmetricds - Total duration: 886ms - Times executed: 895 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 886ms - Times executed: 895 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-08-25 15:56:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:48:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 15:28:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 9ms 0ms 1,968 1s166ms 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 Aug 25 00 424 237ms 0ms 01 509 275ms 0ms 02 195 121ms 0ms 03 400 228ms 0ms 04 147 86ms 0ms 05 141 92ms 0ms 07 62 49ms 0ms 08 74 59ms 0ms 09 16 15ms 0ms [ User: pharmisight - Total duration: 1s166ms - Times executed: 1968 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s166ms - Times executed: 1968 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004418203', '2018-08-24 23:31:30', 'BERLANR', '2018-08-25 00:00:00.051', '49703', '3', '31237090287554002');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004272716', '2018-08-25 03:27:04', 'RYBAKJ', '2018-08-25 03:40:01.204', '41088', '14', '150505230122588526');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004406516', '2018-08-25 04:24:13', 'PRICEM', '2018-08-25 05:00:00.026', '77154', '30', '150505230122591991');
Date: 2018-08-25 00:00:00 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 03:40:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 05:00:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 2ms 0ms 5,774 1s267ms 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 Aug 25 00 247 52ms 0ms 01 240 50ms 0ms 02 241 54ms 0ms 03 240 51ms 0ms 04 241 55ms 0ms 05 247 51ms 0ms 06 240 49ms 0ms 07 242 49ms 0ms 08 240 49ms 0ms 09 239 51ms 0ms 10 239 52ms 0ms 11 240 54ms 0ms 12 240 51ms 0ms 13 237 51ms 0ms 14 239 54ms 0ms 15 240 54ms 0ms 16 237 54ms 0ms 17 240 50ms 0ms 18 240 54ms 0ms 19 243 54ms 0ms 20 240 51ms 0ms 21 240 53ms 0ms 22 243 54ms 0ms 23 239 58ms 0ms [ User: symmetricds - Total duration: 1s267ms - Times executed: 5774 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s267ms - Times executed: 5774 ]
-
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 = '3' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-25 22:44:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 16:08:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 14:15:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 1ms 0ms 5,760 909ms 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 Aug 25 00 244 38ms 0ms 01 240 40ms 0ms 02 240 39ms 0ms 03 240 39ms 0ms 04 240 39ms 0ms 05 240 40ms 0ms 06 240 39ms 0ms 07 240 36ms 0ms 08 240 41ms 0ms 09 240 36ms 0ms 10 240 35ms 0ms 11 240 37ms 0ms 12 240 36ms 0ms 13 240 36ms 0ms 14 240 36ms 0ms 15 240 35ms 0ms 16 240 36ms 0ms 17 240 36ms 0ms 18 240 38ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 37ms 0ms 22 240 39ms 0ms 23 236 38ms 0ms [ User: symmetricds - Total duration: 909ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 909ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 22:43:59.071', last_lock_time = '2018-08-25 22:43:59.071' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 20:43:59.071');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 04:03:30.239', last_lock_time = '2018-08-25 04:03:30.239' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 02:03:30.239');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-25 07:07:34.863', last_lock_time = '2018-08-25 07:07:34.863' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-25 05:07:34.863');
Date: 2018-08-25 22:43:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:03:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:07:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 5,760 774ms 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 Aug 25 00 244 32ms 0ms 01 240 32ms 0ms 02 240 32ms 0ms 03 240 32ms 0ms 04 240 32ms 0ms 05 240 32ms 0ms 06 240 35ms 0ms 07 240 31ms 0ms 08 240 34ms 0ms 09 240 31ms 0ms 10 240 32ms 0ms 11 240 30ms 0ms 12 240 32ms 0ms 13 240 31ms 0ms 14 240 32ms 0ms 15 240 30ms 0ms 16 240 31ms 0ms 17 240 31ms 0ms 18 240 32ms 0ms 19 240 32ms 0ms 20 240 31ms 0ms 21 240 32ms 0ms 22 240 31ms 0ms 23 236 32ms 0ms [ User: symmetricds - Total duration: 774ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 774ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '160548', fail_count = '0', total_success_count = '160548', total_fail_count = '0', total_success_millis = '10705528', total_fail_millis = '0', last_lock_time = '2018-08-25 17:39:51.202' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '75', success_count = '160503', fail_count = '0', total_success_count = '160503', total_fail_count = '0', total_success_millis = '10257680', total_fail_millis = '0', last_lock_time = '2018-08-25 18:19:52.231' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '64', success_count = '160262', fail_count = '0', total_success_count = '160262', total_fail_count = '0', total_success_millis = '9858078', total_fail_millis = '0', last_lock_time = '2018-08-25 06:17:33.552' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-08-25 17:39:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 18:19:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:17:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 7,200 676ms 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 Aug 25 00 305 34ms 0ms 01 300 33ms 0ms 02 300 32ms 0ms 03 300 33ms 0ms 04 300 27ms 0ms 05 300 29ms 0ms 06 300 26ms 0ms 07 300 29ms 0ms 08 300 26ms 0ms 09 300 29ms 0ms 10 300 26ms 0ms 11 300 28ms 0ms 12 300 25ms 0ms 13 300 25ms 0ms 14 300 25ms 0ms 15 300 27ms 0ms 16 300 29ms 0ms 17 300 24ms 0ms 18 300 28ms 0ms 19 300 26ms 0ms 20 300 27ms 0ms 21 300 25ms 0ms 22 300 26ms 0ms 23 295 28ms 0ms [ User: symmetricds - Total duration: 676ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 676ms - 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-08-25 11:21:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 16:01:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 02:57:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 0ms 0ms 5,760 426ms 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 Aug 25 00 244 18ms 0ms 01 240 17ms 0ms 02 240 17ms 0ms 03 240 17ms 0ms 04 240 17ms 0ms 05 240 19ms 0ms 06 240 18ms 0ms 07 240 17ms 0ms 08 240 17ms 0ms 09 240 17ms 0ms 10 240 17ms 0ms 11 240 17ms 0ms 12 240 17ms 0ms 13 240 17ms 0ms 14 240 17ms 0ms 15 240 16ms 0ms 16 240 17ms 0ms 17 240 17ms 0ms 18 240 18ms 0ms 19 240 17ms 0ms 20 240 18ms 0ms 21 240 18ms 0ms 22 240 19ms 0ms 23 236 17ms 0ms [ User: symmetricds - Total duration: 426ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 426ms - 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 = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-08-25 20:11:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:44:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:14:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 4ms 0ms 11,521 739ms 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 #14
Day Hour Count Duration Avg duration Aug 25 00 489 31ms 0ms 01 480 29ms 0ms 02 480 34ms 0ms 03 480 29ms 0ms 04 480 34ms 0ms 05 480 30ms 0ms 06 480 30ms 0ms 07 480 31ms 0ms 08 480 29ms 0ms 09 480 31ms 0ms 10 480 29ms 0ms 11 480 33ms 0ms 12 480 28ms 0ms 13 480 32ms 0ms 14 480 31ms 0ms 15 480 31ms 0ms 16 480 29ms 0ms 17 480 29ms 0ms 18 480 30ms 0ms 19 480 29ms 0ms 20 480 29ms 0ms 21 480 30ms 0ms 22 480 31ms 0ms 23 472 28ms 0ms [ User: symmetricds - Total duration: 739ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 739ms - 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-08-25 11:30:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 13:22:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 04:17:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 21,048 1s234ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 00 877 52ms 0ms 01 877 50ms 0ms 02 877 50ms 0ms 03 877 51ms 0ms 04 877 50ms 0ms 05 877 50ms 0ms 06 877 50ms 0ms 07 877 50ms 0ms 08 877 51ms 0ms 09 877 51ms 0ms 10 877 51ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 51ms 0ms 15 877 50ms 0ms 16 877 50ms 0ms 17 877 50ms 0ms 18 877 51ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 56ms 0ms 22 877 51ms 0ms 23 877 53ms 0ms [ User: pharmisight - Total duration: 1s234ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s234ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3404' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2887' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '102' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-25 00:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 09:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 23,712 1s368ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 25 00 988 56ms 0ms 01 988 55ms 0ms 02 988 56ms 0ms 03 988 56ms 0ms 04 988 55ms 0ms 05 988 55ms 0ms 06 988 55ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 56ms 0ms 11 988 55ms 0ms 12 988 57ms 0ms 13 988 57ms 0ms 14 988 56ms 0ms 15 988 56ms 0ms 16 988 56ms 0ms 17 988 56ms 0ms 18 988 57ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 63ms 0ms 22 988 57ms 0ms 23 988 59ms 0ms [ User: pharmisight - Total duration: 1s368ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s368ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3126' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3140' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3440' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-25 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 8,582 463ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 00 357 20ms 0ms 01 357 20ms 0ms 02 358 19ms 0ms 03 357 19ms 0ms 04 358 19ms 0ms 05 358 20ms 0ms 06 357 19ms 0ms 07 358 20ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 358 18ms 0ms 11 357 19ms 0ms 12 358 18ms 0ms 13 358 18ms 0ms 14 357 18ms 0ms 15 358 18ms 0ms 16 358 19ms 0ms 17 357 18ms 0ms 18 358 18ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 18ms 0ms 22 357 19ms 0ms 23 358 19ms 0ms [ User: symmetricds - Total duration: 463ms - Times executed: 8582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 463ms - Times executed: 8582 ]
-
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-08-25 02:15:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 01:30:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 07:08:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 5ms 0ms 16,112 802ms 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 Aug 25 00 704 41ms 0ms 01 671 34ms 0ms 02 672 32ms 0ms 03 671 32ms 0ms 04 671 34ms 0ms 05 673 33ms 0ms 06 669 34ms 0ms 07 672 32ms 0ms 08 672 33ms 0ms 09 669 33ms 0ms 10 670 32ms 0ms 11 669 31ms 0ms 12 670 31ms 0ms 13 670 33ms 0ms 14 669 34ms 0ms 15 670 31ms 0ms 16 670 34ms 0ms 17 669 32ms 0ms 18 670 32ms 0ms 19 669 33ms 0ms 20 669 33ms 0ms 21 669 30ms 0ms 22 669 33ms 0ms 23 665 33ms 0ms [ User: symmetricds - Total duration: 802ms - Times executed: 16112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 802ms - Times executed: 16112 ]
-
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-08-25 00:02:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 00:16:24 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 06:06:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 77,234 3s577ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 00 3,211 152ms 0ms 01 3,213 146ms 0ms 02 3,220 149ms 0ms 03 3,213 150ms 0ms 04 3,222 147ms 0ms 05 3,222 147ms 0ms 06 3,213 149ms 0ms 07 3,222 151ms 0ms 08 3,222 147ms 0ms 09 3,213 146ms 0ms 10 3,222 151ms 0ms 11 3,213 152ms 0ms 12 3,222 146ms 0ms 13 3,222 147ms 0ms 14 3,213 148ms 0ms 15 3,222 151ms 0ms 16 3,219 147ms 0ms 17 3,216 148ms 0ms 18 3,222 149ms 0ms 19 3,213 150ms 0ms 20 3,222 150ms 0ms 21 3,222 146ms 0ms 22 3,213 148ms 0ms 23 3,222 150ms 0ms [ User: symmetricds - Total duration: 3s577ms - Times executed: 77234 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s577ms - Times executed: 77234 ]
-
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-08-25 17:09:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 10:44:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 19:26:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 5,785 221ms 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 Aug 25 00 269 10ms 0ms 01 240 9ms 0ms 02 240 8ms 0ms 03 240 8ms 0ms 04 240 8ms 0ms 05 240 9ms 0ms 06 240 8ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 9ms 0ms 10 240 8ms 0ms 11 240 9ms 0ms 12 240 8ms 0ms 13 240 9ms 0ms 14 240 9ms 0ms 15 240 10ms 0ms 16 240 9ms 0ms 17 240 9ms 0ms 18 240 8ms 0ms 19 240 9ms 0ms 20 240 9ms 0ms 21 240 9ms 0ms 22 240 11ms 0ms 23 236 8ms 0ms [ User: symmetricds - Total duration: 221ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 221ms - 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-08-25 15:40:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 22:35:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-25 14:14:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,529,148 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 3 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 25 21 1 - FATAL: no pg_hba.conf entry for host "125.212.217.214", user "postgres", database "template0", SSL off
Date: 2018-08-25 21:02:00 Database: template0 Application: [unknown] User: postgres Remote: 125.212.217.214 Code:
2 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 25 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-08-25 00:00:11 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code:
3 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 25 21 1 - FATAL: no pg_hba.conf entry for host "125.212.217.214", user "postgres", database "template0", SSL on
Date: 2018-08-25 21:02:00 Database: template0 Application: [unknown] User: postgres Remote: 125.212.217.214 Code: