pgBadger-
Global information
- Generated on Sun Jul 28 00:00:22 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,144,283 log entries in 20s
- Log start from 2019-07-27 00:00:00 to 2019-07-27 23:59:59
-
Overview
Global Stats
- 177 Number of unique normalized queries
- 1,074,582 Number of queries
- 51s308ms Total query duration
- 2019-07-27 00:00:00 First query
- 2019-07-27 23:59:59 Last query
- 1,490 queries/s at 2019-07-27 18:40:00 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 53 Total number of automatic vacuums
- 75 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,214 Total number of sessions
- 2 sessions at 2019-07-27 00:30:25 Session peak
- 10d1h14m18s Total duration of sessions
- 6m32s Average duration of sessions
- 485 Average queries per session
- 23ms Average queries duration per session
- 2,214 Total number of connections
- 3 connections/s at 2019-07-27 00:30:33 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,490 queries/s Query Peak
- 2019-07-27 18:40:00 Date
SELECT Traffic
Key values
- 1,485 queries/s Query Peak
- 2019-07-27 18:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 307 queries/s Query Peak
- 2019-07-27 03:20:04 Date
Queries duration
Key values
- 51s308ms Total query duration
Prepared queries ratio
Key values
- 1.54 Ratio of bind vs prepare
- 170.12 % 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) Jul 27 00 52,523 0ms 61ms 0ms 82ms 112ms 1s124ms 01 44,746 0ms 61ms 0ms 70ms 106ms 268ms 02 44,366 0ms 60ms 0ms 54ms 69ms 290ms 03 45,055 0ms 60ms 0ms 68ms 131ms 263ms 04 44,098 0ms 60ms 0ms 65ms 76ms 259ms 05 44,120 0ms 59ms 0ms 56ms 68ms 259ms 06 44,127 0ms 58ms 0ms 59ms 67ms 285ms 07 44,162 0ms 140ms 0ms 55ms 68ms 622ms 08 44,143 0ms 66ms 0ms 59ms 70ms 272ms 09 44,197 0ms 103ms 0ms 53ms 64ms 560ms 10 44,189 0ms 80ms 0ms 56ms 63ms 381ms 11 44,067 0ms 79ms 0ms 55ms 80ms 348ms 12 43,955 0ms 62ms 0ms 60ms 75ms 233ms 13 44,598 0ms 63ms 0ms 56ms 62ms 197ms 14 44,474 0ms 41ms 0ms 58ms 72ms 137ms 15 44,476 0ms 46ms 0ms 57ms 67ms 139ms 16 44,353 0ms 21ms 0ms 49ms 65ms 142ms 17 44,409 0ms 34ms 0ms 55ms 68ms 137ms 18 44,542 0ms 13ms 0ms 55ms 66ms 137ms 19 44,395 0ms 14ms 0ms 52ms 59ms 138ms 20 45,332 0ms 29ms 0ms 53ms 65ms 446ms 21 44,820 0ms 13ms 0ms 52ms 56ms 134ms 22 44,719 0ms 15ms 0ms 52ms 60ms 139ms 23 44,716 0ms 22ms 0ms 52ms 61ms 145ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 27 00 18,728 0 0ms 26ms 46ms 345ms 01 14,949 0 0ms 26ms 38ms 117ms 02 14,712 0 0ms 26ms 37ms 120ms 03 14,961 0 0ms 23ms 46ms 113ms 04 14,609 0 0ms 24ms 36ms 108ms 05 14,613 0 0ms 27ms 35ms 111ms 06 14,600 0 0ms 23ms 37ms 109ms 07 14,615 0 0ms 24ms 34ms 118ms 08 14,595 0 0ms 23ms 37ms 70ms 09 14,621 0 0ms 24ms 32ms 75ms 10 14,616 0 0ms 26ms 35ms 56ms 11 14,564 0 0ms 24ms 37ms 59ms 12 14,517 0 0ms 23ms 37ms 43ms 13 14,595 0 0ms 20ms 34ms 43ms 14 14,566 0 0ms 18ms 32ms 49ms 15 14,561 0 0ms 21ms 32ms 46ms 16 14,508 0 0ms 20ms 29ms 42ms 17 14,535 0 0ms 20ms 31ms 42ms 18 14,591 0 0ms 21ms 32ms 44ms 19 14,558 0 0ms 20ms 32ms 41ms 20 15,278 0 0ms 21ms 32ms 121ms 21 14,668 0 0ms 20ms 30ms 42ms 22 14,641 0 0ms 21ms 28ms 41ms 23 14,634 0 0ms 20ms 28ms 39ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 27 00 525 1,147 103 0 0ms 9ms 11ms 23ms 01 319 49 99 0 0ms 0ms 7ms 32ms 02 181 49 101 0 0ms 0ms 5ms 10ms 03 548 58 102 0 0ms 1ms 7ms 11ms 04 80 47 101 0 1ms 0ms 2ms 8ms 05 83 47 102 0 1ms 0ms 4ms 8ms 06 80 47 100 0 1ms 0ms 3ms 8ms 07 82 49 97 0 2ms 0ms 4ms 8ms 08 82 48 92 0 1ms 0ms 3ms 8ms 09 82 47 91 0 2ms 0ms 4ms 8ms 10 76 46 91 0 1ms 0ms 4ms 8ms 11 70 42 82 0 1ms 0ms 3ms 8ms 12 70 41 83 0 1ms 0ms 3ms 8ms 13 73 44 85 0 1ms 0ms 1ms 8ms 14 73 43 77 0 0ms 0ms 3ms 8ms 15 70 41 79 0 0ms 0ms 3ms 8ms 16 73 43 80 0 0ms 0ms 1ms 8ms 17 77 46 75 0 0ms 0ms 2ms 8ms 18 77 45 78 0 0ms 0ms 3ms 8ms 19 78 60 77 0 0ms 0ms 2ms 8ms 20 125 95 123 0 0ms 1ms 5ms 8ms 21 88 53 80 0 0ms 1ms 6ms 8ms 22 88 53 81 0 0ms 1ms 7ms 8ms 23 88 54 82 0 0ms 1ms 6ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 27 00 33,459 52,487 1.57 99.81% 01 29,862 44,710 1.50 112.99% 02 29,749 44,330 1.49 114.25% 03 30,166 45,019 1.49 113.02% 04 29,789 44,062 1.48 115.48% 05 29,829 44,084 1.48 115.58% 06 29,738 44,091 1.48 115.27% 07 29,836 44,126 1.48 115.52% 08 29,541 44,107 1.49 114.50% 09 29,809 44,161 1.48 115.36% 10 29,808 44,153 1.48 115.43% 11 29,683 44,031 1.48 115.43% 12 29,448 43,919 1.49 114.84% 13 27,896 44,562 1.60 107.41% 14 27,948 44,438 1.59 107.89% 15 27,854 44,440 1.60 107.60% 16 27,653 44,317 1.60 107.12% 17 27,806 44,373 1.60 107.50% 18 28,038 44,506 1.59 108.07% 19 27,771 44,359 1.60 107.26% 20 28,280 45,296 1.60 105.56% 21 27,975 44,784 1.60 106.96% 22 28,088 44,683 1.59 107.63% 23 27,855 44,680 1.60 106.76% Day Hour Count Average / Second Jul 27 00 111 0.03/s 01 95 0.03/s 02 98 0.03/s 03 102 0.03/s 04 106 0.03/s 05 105 0.03/s 06 105 0.03/s 07 104 0.03/s 08 103 0.03/s 09 107 0.03/s 10 104 0.03/s 11 108 0.03/s 12 106 0.03/s 13 83 0.02/s 14 81 0.02/s 15 82 0.02/s 16 82 0.02/s 17 80 0.02/s 18 79 0.02/s 19 74 0.02/s 20 79 0.02/s 21 73 0.02/s 22 75 0.02/s 23 72 0.02/s Day Hour Count Average Duration Jul 27 00 111 5m46s 01 95 6m4s 02 98 6m13s 03 102 5m57s 04 106 5m42s 05 105 5m40s 06 105 5m40s 07 104 5m48s 08 103 5m48s 09 107 5m38s 10 104 5m47s 11 108 5m24s 12 106 5m42s 13 83 6m58s 14 81 7m29s 15 82 7m21s 16 82 7m19s 17 80 7m47s 18 79 7m38s 19 74 8m 20 79 7m13s 21 73 8m53s 22 75 7m53s 23 72 8m35s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2019-07-27 00:30:33 Date
Connections per database
Key values
- pharmisight Main Database
- 2,214 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,214 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2019-07-27 00:30:25 Date
Histogram of session times
Key values
- 1,672 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,214 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,214 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,214 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6,404 buffers Checkpoint Peak
- 2019-07-27 07:04:17 Date
- 149.936 seconds Highest write time
- 0.094 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2019-07-27 07:04:17 Date
Checkpoints distance
Key values
- 79.20 Mo Distance Peak
- 2019-07-27 07:04:17 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 27 00 1,675 167.744s 0.029s 167.85s 01 671 67.224s 0.013s 67.284s 02 395 39.627s 0.012s 39.689s 03 459 46.07s 0.01s 46.127s 04 370 37.118s 0.014s 37.182s 05 740 74.045s 0.013s 74.108s 06 555 55.581s 0.071s 55.698s 07 6,697 179.023s 0.01s 179.077s 08 1,795 179.978s 0.016s 180.04s 09 2,445 174.512s 0.011s 174.568s 10 1,416 141.775s 0.008s 141.827s 11 1,720 172.572s 0.01s 172.631s 12 1,167 116.919s 0.013s 116.975s 13 1,202 120.497s 0.011s 120.553s 14 861 86.283s 0.011s 86.345s 15 1,098 109.879s 0.016s 109.936s 16 676 67.718s 0.009s 67.769s 17 602 60.312s 0.104s 60.459s 18 559 56.075s 0.016s 56.298s 19 485 48.56s 0.02s 48.628s 20 600 60.203s 0.017s 60.281s 21 431 43.242s 0.021s 43.332s 22 582 58.391s 0.019s 58.477s 23 720 72.153s 0.036s 72.25s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 27 00 0 0 1 301 0.008s 0s 01 0 0 0 244 0.002s 0s 02 0 0 0 218 0.002s 0s 03 0 0 0 224 0.002s 0s 04 0 0 0 206 0.002s 0.001s 05 0 0 1 220 0.002s 0.002s 06 0 0 0 204 0.059s 0.002s 07 0 0 2 231 0.003s 0s 08 0 0 1 233 0.004s 0.001s 09 0 0 1 223 0.002s 0s 10 0 0 0 226 0.002s 0s 11 0 0 0 233 0.002s 0s 12 0 0 1 237 0.002s 0s 13 0 0 0 222 0.002s 0s 14 0 0 1 232 0.002s 0s 15 0 0 0 227 0.008s 0s 16 0 0 0 223 0.002s 0s 17 0 0 0 223 0.094s 0.003s 18 0 0 0 229 0.003s 0s 19 0 0 0 212 0.009s 0s 20 0 0 0 289 0.003s 0s 21 0 0 1 309 0.002s 0s 22 0 0 0 304 0.003s 0s 23 0 0 0 315 0.018s 0s Day Hour Count Avg time (sec) Jul 27 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 Jul 27 00 854.55 kB 1,037.55 kB 01 357.67 kB 1,016.00 kB 02 213.25 kB 551.50 kB 03 222.22 kB 526.33 kB 04 157.00 kB 432.44 kB 05 390.78 kB 1,780.22 kB 06 341.75 kB 1,415.12 kB 07 5,189.12 kB 28,911.88 kB 08 1,012.33 kB 12,519.89 kB 09 1,429.75 kB 7,590.38 kB 10 660.75 kB 3,644.75 kB 11 979.22 kB 5,310.00 kB 12 816.25 kB 4,158.50 kB 13 931.50 kB 4,771.25 kB 14 452.89 kB 2,315.89 kB 15 716.50 kB 3,317.12 kB 16 334.00 kB 1,623.62 kB 17 284.00 kB 1,140.88 kB 18 187.90 kB 562.00 kB 19 183.22 kB 659.33 kB 20 157.27 kB 369.82 kB 21 103.42 kB 201.50 kB 22 143.83 kB 317.50 kB 23 158.42 kB 381.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (16) Main table analyzed (database pharmisight)
- 75 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data_event 14 pharmisight.public.sym_data 13 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_data_gap 8 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 3 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 pharmisight.public.patients 1 Total 75 Vacuums per table
Key values
- public.sym_outgoing_batch (12) Main table vacuumed on database pharmisight
- 53 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 12 12 pharmisight.public.sym_data_event 11 11 pharmisight.public.sym_data 10 10 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.public.sym_data_gap 4 4 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.item_codes 1 1 Total 53 48 Tuples removed per table
Key values
- public.sym_data_event (36916) Main table with removed tuples on database pharmisight
- 66148 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 11 11 36916 1025 pharmisight.public.sym_data 10 10 21580 5523 pharmisight.public.sym_outgoing_batch 12 12 5091 56 pharmisight.public.sym_incoming_batch 6 6 1157 0 pharmisight.pg_catalog.pg_statistic 2 2 555 0 pharmisight.public.sym_node_host 5 0 261 0 pharmisight.public.item_codes 1 1 223 0 pharmisight.public.sym_data_gap 4 4 204 0 pharmisight.pg_toast.pg_toast_2619 2 2 161 0 Total 53 48 66,148 6,604 Pages removed per table
Key values
- public.sym_data (5523) Main table with removed pages on database pharmisight
- 6604 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 21580 5523 pharmisight.public.sym_data_event 11 11 36916 1025 pharmisight.public.sym_outgoing_batch 12 12 5091 56 pharmisight.public.sym_node_host 5 0 261 0 pharmisight.public.sym_incoming_batch 6 6 1157 0 pharmisight.pg_catalog.pg_statistic 2 2 555 0 pharmisight.public.item_codes 1 1 223 0 pharmisight.pg_toast.pg_toast_2619 2 2 161 0 pharmisight.public.sym_data_gap 4 4 204 0 Total 53 48 66,148 6,604 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 27 00 2 4 01 1 2 02 1 1 03 0 0 04 0 2 05 1 3 06 1 0 07 4 3 08 3 5 09 2 3 10 1 4 11 5 5 12 4 4 13 3 3 14 4 5 15 3 5 16 4 3 17 4 4 18 2 4 19 2 2 20 1 4 21 1 2 22 1 1 23 3 6 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 355,835 Total read queries
- 275,313 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,074,582 Requests
- 51s308ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,063,531 Requests
User Request type Count Duration pharmisight Total 55,528 4s113ms DELETE 43 3ms INSERT 232 119ms OTHERS 2,793 112ms SELECT 51,851 3s842ms TCL 546 27ms UPDATE 63 7ms symmetricds Total 1,063,531 48s859ms DELETE 2,183 3s718ms INSERT 3,388 947ms OTHERS 459,211 7s435ms SELECT 318,118 29s374ms TCL 278,342 5s327ms UPDATE 2,289 2s56ms tony Total 900 279ms SELECT 900 279ms Duration by user
Key values
- 48s859ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 55,528 4s113ms DELETE 43 3ms INSERT 232 119ms OTHERS 2,793 112ms SELECT 51,851 3s842ms TCL 546 27ms UPDATE 63 7ms symmetricds Total 1,063,531 48s859ms DELETE 2,183 3s718ms INSERT 3,388 947ms OTHERS 459,211 7s435ms SELECT 318,118 29s374ms TCL 278,342 5s327ms UPDATE 2,289 2s56ms tony Total 900 279ms SELECT 900 279ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,119,059 Requests
- 52s973ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,071,792 Requests
- 50s961ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-07-27 04:06:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,070,391 0-1ms duration
Slowest individual queries
Rank Duration Query 1 140ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '9170120' AND '9170757' AND status != 'OK') AND batch_id BETWEEN '9170120' AND '9170757';[ Date: 2019-07-27 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 103ms DELETE FROM sym_data WHERE data_id BETWEEN '104440918' AND '104445918' AND create_time < '2019-07-26 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 80ms DELETE FROM sym_data WHERE data_id BETWEEN '104446449' AND '104451449' AND create_time < '2019-07-26 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 79ms DELETE FROM sym_data WHERE data_id BETWEEN '104449545' AND '104454545' AND create_time < '2019-07-26 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 66ms DELETE FROM sym_data WHERE data_id BETWEEN '104435364' AND '104440364' AND create_time < '2019-07-26 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104435364' AND '104440364') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104435364' AND '104440364' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 63ms DELETE FROM sym_data WHERE data_id BETWEEN '104458635' AND '104463635' AND create_time < '2019-07-26 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104458635' AND '104463635') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104458635' AND '104463635' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 62ms DELETE FROM sym_data WHERE data_id BETWEEN '104454763' AND '104459763' AND create_time < '2019-07-26 12:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104454763' AND '104459763') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104454763' AND '104459763' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 61ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 61ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 60ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 60ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 60ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 59ms DELETE FROM sym_data WHERE data_id BETWEEN '104445919' AND '104450919' AND create_time < '2019-07-26 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104445919' AND '104450919') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104445919' AND '104450919' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 59ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 58ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-07-27 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 52ms DELETE FROM sym_data WHERE data_id BETWEEN '104409757' AND '104414757' AND create_time < '2019-07-26 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104409757' AND '104414757') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104409757' AND '104414757' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 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_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '9170758' AND '9171411' AND status != 'OK') AND batch_id BETWEEN '9170758' AND '9171411';[ Date: 2019-07-27 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 46ms DELETE FROM sym_data WHERE data_id BETWEEN '104466047' AND '104471047' AND create_time < '2019-07-26 15:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104466047' AND '104471047') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104466047' AND '104471047' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 43ms DELETE FROM sym_data WHERE data_id BETWEEN '104454546' AND '104459546' AND create_time < '2019-07-26 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104454546' AND '104459546') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104454546' AND '104459546' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 41ms DELETE FROM sym_data WHERE data_id BETWEEN '104464026' AND '104469026' AND create_time < '2019-07-26 14:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104464026' AND '104469026') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104464026' AND '104469026' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-07-27 14: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 9s937ms 17,197 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 27 01 717 426ms 0ms 02 716 426ms 0ms 03 718 421ms 0ms 04 716 425ms 0ms 05 716 417ms 0ms 06 716 424ms 0ms 07 718 425ms 0ms 08 716 417ms 0ms 09 716 413ms 0ms 10 716 415ms 0ms 11 716 421ms 0ms 12 718 424ms 0ms 13 716 418ms 0ms 14 716 399ms 0ms 15 716 405ms 0ms 16 718 398ms 0ms 17 716 402ms 0ms 18 716 411ms 0ms 19 718 409ms 0ms 20 716 406ms 0ms 21 716 402ms 0ms 22 718 401ms 0ms 23 716 410ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 9s937ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s937ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-07-27 07:51:24 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:34:23 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:35:13 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s839ms 421,320 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 01 18,040 295ms 0ms 02 17,394 279ms 0ms 03 17,393 276ms 0ms 04 17,414 280ms 0ms 05 17,357 279ms 0ms 06 17,365 278ms 0ms 07 17,382 279ms 0ms 08 17,391 282ms 0ms 09 17,398 279ms 0ms 10 17,408 279ms 0ms 11 17,420 279ms 0ms 12 17,399 282ms 0ms 13 17,364 277ms 0ms 14 17,722 289ms 0ms 15 17,676 286ms 0ms 16 17,684 289ms 0ms 17 17,637 284ms 0ms 18 17,649 290ms 0ms 19 17,698 290ms 0ms 20 17,623 289ms 0ms 21 17,645 293ms 0ms 22 17,783 293ms 0ms 23 17,736 289ms 0ms 00 17,742 289ms 0ms [ User: symmetricds - Total duration: 6s796ms - Times executed: 420429 ]
[ User: pharmisight - Total duration: 42ms - Times executed: 891 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s839ms - Times executed: 421320 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-07-27 11:58:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:43:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:53:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s266ms 133,834 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 01 6,509 551ms 0ms 02 5,506 180ms 0ms 03 5,498 156ms 0ms 04 5,511 174ms 0ms 05 5,479 161ms 0ms 06 5,481 153ms 0ms 07 5,486 167ms 0ms 08 5,492 153ms 0ms 09 5,492 153ms 0ms 10 5,500 158ms 0ms 11 5,497 152ms 0ms 12 5,479 162ms 0ms 13 5,466 179ms 0ms 14 5,587 151ms 0ms 15 5,572 145ms 0ms 16 5,568 147ms 0ms 17 5,556 160ms 0ms 18 5,567 165ms 0ms 19 5,577 160ms 0ms 20 5,559 150ms 0ms 21 5,585 161ms 0ms 22 5,633 160ms 0ms 23 5,617 175ms 0ms 00 5,617 182ms 0ms [ User: symmetricds - Total duration: 4s242ms - Times executed: 133571 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s266ms - Times executed: 133834 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-07-27 23:56:09 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:47:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 06:35:58 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s206ms 149 0ms 103ms 14ms 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 #4
Day Hour Count Duration Avg duration Jul 27 01 13 84ms 6ms 02 13 81ms 6ms 03 13 101ms 7ms 04 13 81ms 6ms 05 13 83ms 6ms 06 13 80ms 6ms 07 13 101ms 7ms 08 13 281ms 21ms 09 8 112ms 14ms 10 7 322ms 46ms 11 6 212ms 35ms 12 5 190ms 38ms 13 4 122ms 30ms 14 3 104ms 34ms 15 2 54ms 27ms 16 2 55ms 27ms 17 1 19ms 19ms 18 1 34ms 34ms 19 1 13ms 13ms 20 1 11ms 11ms 21 1 14ms 14ms 22 1 12ms 12ms 23 1 9ms 9ms 00 1 14ms 14ms [ User: symmetricds - Total duration: 2s206ms - Times executed: 149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s206ms - Times executed: 149 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104440918' AND '104445918' AND create_time < '2019-07-26 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918' 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 '104446449' AND '104451449' AND create_time < '2019-07-26 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449' 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 '104449545' AND '104454545' AND create_time < '2019-07-26 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-07-27 09:00:00 Duration: 103ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 10:00:00 Duration: 80ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 11:00:00 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s747ms 153,954 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 01 7,758 83ms 0ms 02 6,334 77ms 0ms 03 6,332 69ms 0ms 04 6,354 73ms 0ms 05 6,308 70ms 0ms 06 6,320 70ms 0ms 07 6,322 72ms 0ms 08 6,318 71ms 0ms 09 6,321 69ms 0ms 10 6,322 69ms 0ms 11 6,321 73ms 0ms 12 6,295 69ms 0ms 13 6,280 72ms 0ms 14 6,409 72ms 0ms 15 6,383 72ms 0ms 16 6,385 75ms 0ms 17 6,368 70ms 0ms 18 6,373 72ms 0ms 19 6,395 74ms 0ms 20 6,367 74ms 0ms 21 6,387 72ms 0ms 22 6,443 72ms 0ms 23 6,424 72ms 0ms 00 6,435 73ms 0ms [ User: symmetricds - Total duration: 1s747ms - Times executed: 153954 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s747ms - Times executed: 153954 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-07-27 01:43:46 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:15:50 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 12:09:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s456ms 1,012 0ms 5ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 01 55 79ms 1ms 02 56 79ms 1ms 03 54 77ms 1ms 04 58 81ms 1ms 05 57 82ms 1ms 06 56 80ms 1ms 07 54 77ms 1ms 08 58 81ms 1ms 09 53 76ms 1ms 10 59 87ms 1ms 11 57 80ms 1ms 12 56 81ms 1ms 13 52 74ms 1ms 14 25 35ms 1ms 15 27 39ms 1ms 16 26 37ms 1ms 17 25 36ms 1ms 18 26 38ms 1ms 19 27 39ms 1ms 20 26 38ms 1ms 21 29 41ms 1ms 22 25 36ms 1ms 23 27 39ms 1ms 00 24 35ms 1ms [ User: symmetricds - Total duration: 1s456ms - Times executed: 1012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s456ms - Times executed: 1012 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 09:13:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 06:40:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:03:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s251ms 1,224 0ms 7ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 01 65 64ms 0ms 02 66 68ms 1ms 03 67 71ms 1ms 04 68 68ms 1ms 05 66 67ms 1ms 06 67 66ms 0ms 07 67 68ms 1ms 08 68 68ms 1ms 09 65 72ms 1ms 10 71 72ms 1ms 11 68 70ms 1ms 12 65 66ms 1ms 13 65 66ms 1ms 14 33 33ms 1ms 15 36 36ms 1ms 16 30 30ms 1ms 17 31 32ms 1ms 18 29 29ms 1ms 19 32 32ms 1ms 20 31 31ms 1ms 21 35 34ms 0ms 22 33 32ms 0ms 23 35 34ms 0ms 00 31 29ms 0ms [ User: symmetricds - Total duration: 1s251ms - Times executed: 1224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s251ms - Times executed: 1224 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 08:13:47 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 02:29:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 10:49:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s249ms 25,030 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 01 1,128 55ms 0ms 02 1,042 52ms 0ms 03 1,042 49ms 0ms 04 1,042 52ms 0ms 05 1,036 51ms 0ms 06 1,038 51ms 0ms 07 1,038 52ms 0ms 08 1,038 50ms 0ms 09 1,038 51ms 0ms 10 1,042 53ms 0ms 11 1,040 51ms 0ms 12 1,038 52ms 0ms 13 1,036 50ms 0ms 14 1,038 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 53ms 0ms 18 1,036 52ms 0ms 19 1,038 51ms 0ms 20 1,036 50ms 0ms 21 1,040 53ms 0ms 22 1,046 53ms 0ms 23 1,044 51ms 0ms 00 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s249ms - Times executed: 25030 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s249ms - Times executed: 25030 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-07-27 14:43:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 20:43:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:14:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s182ms 24,624 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 01 1,026 27ms 0ms 02 1,026 45ms 0ms 03 1,026 45ms 0ms 04 1,026 46ms 0ms 05 1,026 42ms 0ms 06 1,026 42ms 0ms 07 1,026 44ms 0ms 08 1,026 47ms 0ms 09 1,026 56ms 0ms 10 1,026 52ms 0ms 11 1,026 53ms 0ms 12 1,026 52ms 0ms 13 1,026 52ms 0ms 14 1,026 51ms 0ms 15 1,026 52ms 0ms 16 1,026 53ms 0ms 17 1,026 51ms 0ms 18 1,026 53ms 0ms 19 1,026 52ms 0ms 20 1,026 53ms 0ms 21 1,026 48ms 0ms 22 1,026 51ms 0ms 23 1,026 52ms 0ms 00 1,026 52ms 0ms [ User: pharmisight - Total duration: 1s182ms - Times executed: 24624 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s182ms - Times executed: 24624 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3307' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3339' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2728' ORDER BY itemcodes0_.code ASC;
Date: 2019-07-27 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s58ms 21,864 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 01 911 24ms 0ms 02 911 39ms 0ms 03 911 40ms 0ms 04 911 42ms 0ms 05 911 38ms 0ms 06 911 39ms 0ms 07 911 40ms 0ms 08 911 42ms 0ms 09 911 50ms 0ms 10 911 47ms 0ms 11 911 47ms 0ms 12 911 46ms 0ms 13 911 47ms 0ms 14 911 46ms 0ms 15 911 46ms 0ms 16 911 48ms 0ms 17 911 46ms 0ms 18 911 48ms 0ms 19 911 46ms 0ms 20 911 46ms 0ms 21 911 43ms 0ms 22 911 46ms 0ms 23 911 46ms 0ms 00 911 46ms 0ms [ User: pharmisight - Total duration: 1s58ms - Times executed: 21864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s58ms - Times executed: 21864 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3209' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2728' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3369' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-07-27 17:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s20ms 237 3ms 9ms 4ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 01 11 44ms 4ms 02 10 41ms 4ms 03 9 34ms 3ms 04 14 59ms 4ms 05 10 41ms 4ms 06 10 39ms 3ms 07 9 35ms 3ms 08 10 39ms 3ms 09 11 43ms 3ms 10 8 31ms 3ms 11 10 39ms 3ms 12 9 39ms 4ms 13 9 40ms 4ms 14 11 48ms 4ms 15 11 59ms 5ms 16 12 61ms 5ms 17 8 40ms 5ms 18 10 42ms 4ms 19 11 45ms 4ms 20 10 45ms 4ms 21 9 40ms 4ms 22 8 32ms 4ms 23 8 35ms 4ms 00 9 37ms 4ms [ User: symmetricds - Total duration: 1s20ms - Times executed: 237 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s20ms - Times executed: 237 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 14:13:49 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 14:13:49 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 20:43:53 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 975ms 151 4ms 13ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 01 101 611ms 6ms 02 3 23ms 7ms 03 3 23ms 7ms 04 3 23ms 7ms 05 2 14ms 7ms 06 3 23ms 7ms 07 2 14ms 7ms 08 2 14ms 7ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 14ms 7ms 14 2 13ms 6ms 15 2 14ms 7ms 16 2 13ms 6ms 17 2 14ms 7ms 18 2 14ms 7ms 19 2 14ms 7ms 20 2 14ms 7ms 21 2 17ms 8ms 22 2 14ms 7ms 23 2 13ms 6ms 00 2 14ms 7ms [ User: symmetricds - Total duration: 767ms - Times executed: 106 ]
[ User: pharmisight - Total duration: 207ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 975ms - Times executed: 151 ]
-
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 = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-07-27 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:00:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:06:04 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 953ms 1,011 0ms 3ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 01 55 53ms 0ms 02 56 53ms 0ms 03 55 51ms 0ms 04 58 54ms 0ms 05 56 52ms 0ms 06 57 53ms 0ms 07 55 51ms 0ms 08 57 53ms 0ms 09 52 49ms 0ms 10 59 55ms 0ms 11 57 56ms 0ms 12 55 52ms 0ms 13 52 49ms 0ms 14 25 23ms 0ms 15 27 24ms 0ms 16 26 24ms 0ms 17 25 23ms 0ms 18 26 24ms 0ms 19 27 25ms 0ms 20 26 23ms 0ms 21 29 26ms 0ms 22 25 23ms 0ms 23 27 25ms 0ms 00 24 22ms 0ms [ User: symmetricds - Total duration: 953ms - Times executed: 1011 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 953ms - Times executed: 1011 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 10:49:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:49:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:27:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 892ms 17,294 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 01 720 36ms 0ms 02 720 36ms 0ms 03 722 37ms 0ms 04 722 36ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 36ms 0ms 09 720 36ms 0ms 10 720 36ms 0ms 11 720 37ms 0ms 12 722 36ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 37ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 38ms 0ms 20 720 37ms 0ms 21 720 37ms 0ms 22 722 38ms 0ms 23 720 37ms 0ms 00 720 38ms 0ms [ User: symmetricds - Total duration: 892ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-07-27 05:05:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 18:16:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:05:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 879ms 999 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 01 54 47ms 0ms 02 55 48ms 0ms 03 54 47ms 0ms 04 58 50ms 0ms 05 56 49ms 0ms 06 56 48ms 0ms 07 54 47ms 0ms 08 56 49ms 0ms 09 52 46ms 0ms 10 57 49ms 0ms 11 54 47ms 0ms 12 54 47ms 0ms 13 52 46ms 0ms 14 25 21ms 0ms 15 27 23ms 0ms 16 26 22ms 0ms 17 25 22ms 0ms 18 26 22ms 0ms 19 27 23ms 0ms 20 26 22ms 0ms 21 29 25ms 0ms 22 25 22ms 0ms 23 27 24ms 0ms 00 24 21ms 0ms [ User: symmetricds - Total duration: 879ms - Times executed: 999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 879ms - Times executed: 999 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 07:31:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 12:23:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:27:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 871ms 133,835 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 01 6,510 41ms 0ms 02 5,506 35ms 0ms 03 5,498 35ms 0ms 04 5,511 35ms 0ms 05 5,479 35ms 0ms 06 5,481 34ms 0ms 07 5,486 35ms 0ms 08 5,492 35ms 0ms 09 5,492 35ms 0ms 10 5,500 34ms 0ms 11 5,497 35ms 0ms 12 5,479 37ms 0ms 13 5,466 34ms 0ms 14 5,587 36ms 0ms 15 5,572 35ms 0ms 16 5,568 36ms 0ms 17 5,556 36ms 0ms 18 5,567 38ms 0ms 19 5,577 36ms 0ms 20 5,559 36ms 0ms 21 5,585 36ms 0ms 22 5,633 36ms 0ms 23 5,617 36ms 0ms 00 5,617 40ms 0ms [ User: symmetricds - Total duration: 869ms - Times executed: 133571 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 871ms - Times executed: 133835 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-07-27 11:27:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:27:51 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:08:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 745ms 178 0ms 9ms 4ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 01 8 25ms 3ms 02 8 27ms 3ms 03 8 26ms 3ms 04 8 28ms 3ms 05 8 23ms 2ms 06 8 30ms 3ms 07 8 30ms 3ms 08 8 35ms 4ms 09 8 30ms 3ms 10 7 39ms 5ms 11 6 33ms 5ms 12 6 22ms 3ms 13 6 26ms 4ms 14 6 20ms 3ms 15 7 25ms 3ms 16 6 25ms 4ms 17 7 27ms 3ms 18 8 22ms 2ms 19 8 20ms 2ms 20 8 23ms 2ms 21 7 38ms 5ms 22 8 50ms 6ms 23 8 55ms 6ms 00 8 53ms 6ms [ User: symmetricds - Total duration: 745ms - Times executed: 178 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 745ms - Times executed: 178 ]
-
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-8-amd64', "available_processors" = '3', "free_memory_bytes" = '223092912', "total_memory_bytes" = '597688320', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 08:49:41', "last_restart_time" = '2019-05-14 22:11:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '88172048', "total_memory_bytes" = '562561024', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 16:38:14', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '118627072', "total_memory_bytes" = '562561024', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 22:23:15', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2019-07-27 08:49:59 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 16:36:01 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 22:21:03 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 733ms 137 0ms 22ms 5ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? 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 #18
Day Hour Count Duration Avg duration Jul 27 01 13 62ms 4ms 02 13 56ms 4ms 03 13 56ms 4ms 04 13 56ms 4ms 05 13 55ms 4ms 06 13 55ms 4ms 07 13 54ms 4ms 08 8 30ms 3ms 09 7 25ms 3ms 10 6 108ms 18ms 11 5 71ms 14ms 12 4 41ms 10ms 13 3 24ms 8ms 14 2 12ms 6ms 15 2 7ms 3ms 16 1 2ms 2ms 17 1 1ms 1ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 1ms 1ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 733ms - Times executed: 137 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 137 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104446449' AND '104451449' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104461452' AND '104466452' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104461452' AND '104466452');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104451450' AND '104456450' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104451450' AND '104456450');
Date: 2019-07-27 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 710ms 6,207 0ms 4ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 01 239 27ms 0ms 02 240 26ms 0ms 03 237 26ms 0ms 04 239 28ms 0ms 05 240 27ms 0ms 06 237 26ms 0ms 07 239 27ms 0ms 08 240 28ms 0ms 09 240 27ms 0ms 10 236 27ms 0ms 11 240 28ms 0ms 12 240 32ms 0ms 13 239 27ms 0ms 14 289 32ms 0ms 15 288 31ms 0ms 16 282 30ms 0ms 17 281 33ms 0ms 18 284 32ms 0ms 19 285 31ms 0ms 20 280 31ms 0ms 21 274 29ms 0ms 22 283 31ms 0ms 23 277 31ms 0ms 00 278 29ms 0ms [ User: symmetricds - Total duration: 710ms - Times executed: 6207 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 6207 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-07-27 11:25:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 16:37:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 13:57:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 608ms 96 0ms 7ms 6ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 01 4 22ms 5ms 02 4 29ms 7ms 03 4 26ms 6ms 04 4 26ms 6ms 05 4 29ms 7ms 06 4 28ms 7ms 07 4 27ms 6ms 08 4 28ms 7ms 09 4 27ms 6ms 10 4 27ms 6ms 11 4 28ms 7ms 12 4 28ms 7ms 13 4 28ms 7ms 14 4 16ms 4ms 15 4 28ms 7ms 16 4 27ms 6ms 17 4 15ms 3ms 18 4 21ms 5ms 19 4 28ms 7ms 20 4 22ms 5ms 21 4 22ms 5ms 22 4 22ms 5ms 23 4 27ms 6ms 00 4 16ms 4ms [ User: symmetricds - Total duration: 608ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 608ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '117700352', total_memory_bytes = '271056896', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 04:43:33', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '129937424', total_memory_bytes = '281018368', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 02:28:32', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '87711176', total_memory_bytes = '264765440', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 01:13:32', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-07-27 04:43:33 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 02:28:32 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:13:32 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 421,320 6s839ms 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 27 01 18,040 295ms 0ms 02 17,394 279ms 0ms 03 17,393 276ms 0ms 04 17,414 280ms 0ms 05 17,357 279ms 0ms 06 17,365 278ms 0ms 07 17,382 279ms 0ms 08 17,391 282ms 0ms 09 17,398 279ms 0ms 10 17,408 279ms 0ms 11 17,420 279ms 0ms 12 17,399 282ms 0ms 13 17,364 277ms 0ms 14 17,722 289ms 0ms 15 17,676 286ms 0ms 16 17,684 289ms 0ms 17 17,637 284ms 0ms 18 17,649 290ms 0ms 19 17,698 290ms 0ms 20 17,623 289ms 0ms 21 17,645 293ms 0ms 22 17,783 293ms 0ms 23 17,736 289ms 0ms 00 17,742 289ms 0ms [ User: symmetricds - Total duration: 6s796ms - Times executed: 420429 ]
[ User: pharmisight - Total duration: 42ms - Times executed: 891 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s839ms - Times executed: 421320 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-07-27 11:58:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:43:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:53:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 153,954 1s747ms 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 01 7,758 83ms 0ms 02 6,334 77ms 0ms 03 6,332 69ms 0ms 04 6,354 73ms 0ms 05 6,308 70ms 0ms 06 6,320 70ms 0ms 07 6,322 72ms 0ms 08 6,318 71ms 0ms 09 6,321 69ms 0ms 10 6,322 69ms 0ms 11 6,321 73ms 0ms 12 6,295 69ms 0ms 13 6,280 72ms 0ms 14 6,409 72ms 0ms 15 6,383 72ms 0ms 16 6,385 75ms 0ms 17 6,368 70ms 0ms 18 6,373 72ms 0ms 19 6,395 74ms 0ms 20 6,367 74ms 0ms 21 6,387 72ms 0ms 22 6,443 72ms 0ms 23 6,424 72ms 0ms 00 6,435 73ms 0ms [ User: symmetricds - Total duration: 1s747ms - Times executed: 153954 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s747ms - Times executed: 153954 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-07-27 01:43:46 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:15:50 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 12:09:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 133,835 871ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 01 6,510 41ms 0ms 02 5,506 35ms 0ms 03 5,498 35ms 0ms 04 5,511 35ms 0ms 05 5,479 35ms 0ms 06 5,481 34ms 0ms 07 5,486 35ms 0ms 08 5,492 35ms 0ms 09 5,492 35ms 0ms 10 5,500 34ms 0ms 11 5,497 35ms 0ms 12 5,479 37ms 0ms 13 5,466 34ms 0ms 14 5,587 36ms 0ms 15 5,572 35ms 0ms 16 5,568 36ms 0ms 17 5,556 36ms 0ms 18 5,567 38ms 0ms 19 5,577 36ms 0ms 20 5,559 36ms 0ms 21 5,585 36ms 0ms 22 5,633 36ms 0ms 23 5,617 36ms 0ms 00 5,617 40ms 0ms [ User: symmetricds - Total duration: 869ms - Times executed: 133571 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 871ms - Times executed: 133835 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-07-27 11:27:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:27:51 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:08:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 133,834 4s266ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 01 6,509 551ms 0ms 02 5,506 180ms 0ms 03 5,498 156ms 0ms 04 5,511 174ms 0ms 05 5,479 161ms 0ms 06 5,481 153ms 0ms 07 5,486 167ms 0ms 08 5,492 153ms 0ms 09 5,492 153ms 0ms 10 5,500 158ms 0ms 11 5,497 152ms 0ms 12 5,479 162ms 0ms 13 5,466 179ms 0ms 14 5,587 151ms 0ms 15 5,572 145ms 0ms 16 5,568 147ms 0ms 17 5,556 160ms 0ms 18 5,567 165ms 0ms 19 5,577 160ms 0ms 20 5,559 150ms 0ms 21 5,585 161ms 0ms 22 5,633 160ms 0ms 23 5,617 175ms 0ms 00 5,617 182ms 0ms [ User: symmetricds - Total duration: 4s242ms - Times executed: 133571 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s266ms - Times executed: 133834 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-07-27 23:56:09 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:47:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 06:35:58 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,030 1s249ms 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 01 1,128 55ms 0ms 02 1,042 52ms 0ms 03 1,042 49ms 0ms 04 1,042 52ms 0ms 05 1,036 51ms 0ms 06 1,038 51ms 0ms 07 1,038 52ms 0ms 08 1,038 50ms 0ms 09 1,038 51ms 0ms 10 1,042 53ms 0ms 11 1,040 51ms 0ms 12 1,038 52ms 0ms 13 1,036 50ms 0ms 14 1,038 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 53ms 0ms 18 1,036 52ms 0ms 19 1,038 51ms 0ms 20 1,036 50ms 0ms 21 1,040 53ms 0ms 22 1,046 53ms 0ms 23 1,044 51ms 0ms 00 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s249ms - Times executed: 25030 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s249ms - Times executed: 25030 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-07-27 14:43:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 20:43:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:14:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,624 1s182ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 01 1,026 27ms 0ms 02 1,026 45ms 0ms 03 1,026 45ms 0ms 04 1,026 46ms 0ms 05 1,026 42ms 0ms 06 1,026 42ms 0ms 07 1,026 44ms 0ms 08 1,026 47ms 0ms 09 1,026 56ms 0ms 10 1,026 52ms 0ms 11 1,026 53ms 0ms 12 1,026 52ms 0ms 13 1,026 52ms 0ms 14 1,026 51ms 0ms 15 1,026 52ms 0ms 16 1,026 53ms 0ms 17 1,026 51ms 0ms 18 1,026 53ms 0ms 19 1,026 52ms 0ms 20 1,026 53ms 0ms 21 1,026 48ms 0ms 22 1,026 51ms 0ms 23 1,026 52ms 0ms 00 1,026 52ms 0ms [ User: pharmisight - Total duration: 1s182ms - Times executed: 24624 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s182ms - Times executed: 24624 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3307' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3339' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2728' ORDER BY itemcodes0_.code ASC;
Date: 2019-07-27 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,864 1s58ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 01 911 24ms 0ms 02 911 39ms 0ms 03 911 40ms 0ms 04 911 42ms 0ms 05 911 38ms 0ms 06 911 39ms 0ms 07 911 40ms 0ms 08 911 42ms 0ms 09 911 50ms 0ms 10 911 47ms 0ms 11 911 47ms 0ms 12 911 46ms 0ms 13 911 47ms 0ms 14 911 46ms 0ms 15 911 46ms 0ms 16 911 48ms 0ms 17 911 46ms 0ms 18 911 48ms 0ms 19 911 46ms 0ms 20 911 46ms 0ms 21 911 43ms 0ms 22 911 46ms 0ms 23 911 46ms 0ms 00 911 46ms 0ms [ User: pharmisight - Total duration: 1s58ms - Times executed: 21864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s58ms - Times executed: 21864 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3209' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2728' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3369' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-07-27 17:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,294 892ms 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 01 720 36ms 0ms 02 720 36ms 0ms 03 722 37ms 0ms 04 722 36ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 36ms 0ms 09 720 36ms 0ms 10 720 36ms 0ms 11 720 37ms 0ms 12 722 36ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 37ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 38ms 0ms 20 720 37ms 0ms 21 720 37ms 0ms 22 722 38ms 0ms 23 720 37ms 0ms 00 720 38ms 0ms [ User: symmetricds - Total duration: 892ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-07-27 05:05:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 18:16:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:05:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,264 465ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 01 718 18ms 0ms 02 720 19ms 0ms 03 720 19ms 0ms 04 718 19ms 0ms 05 720 19ms 0ms 06 720 19ms 0ms 07 718 19ms 0ms 08 720 19ms 0ms 09 720 19ms 0ms 10 718 18ms 0ms 11 720 19ms 0ms 12 720 19ms 0ms 13 718 19ms 0ms 14 720 19ms 0ms 15 720 19ms 0ms 16 720 19ms 0ms 17 718 19ms 0ms 18 720 19ms 0ms 19 720 19ms 0ms 20 720 19ms 0ms 21 718 18ms 0ms 22 720 19ms 0ms 23 720 19ms 0ms 00 718 19ms 0ms [ User: symmetricds - Total duration: 465ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 465ms - Times executed: 17264 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-07-27 21:55:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:41:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:37:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,197 9s937ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 01 717 426ms 0ms 02 716 426ms 0ms 03 718 421ms 0ms 04 716 425ms 0ms 05 716 417ms 0ms 06 716 424ms 0ms 07 718 425ms 0ms 08 716 417ms 0ms 09 716 413ms 0ms 10 716 415ms 0ms 11 716 421ms 0ms 12 718 424ms 0ms 13 716 418ms 0ms 14 716 399ms 0ms 15 716 405ms 0ms 16 718 398ms 0ms 17 716 402ms 0ms 18 716 411ms 0ms 19 718 409ms 0ms 20 716 406ms 0ms 21 716 402ms 0ms 22 718 401ms 0ms 23 716 410ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 9s937ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s937ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-07-27 07:51:24 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:34:23 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:35:13 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,132 152ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 01 382 6ms 0ms 02 378 6ms 0ms 03 381 6ms 0ms 04 386 6ms 0ms 05 378 6ms 0ms 06 382 6ms 0ms 07 379 6ms 0ms 08 380 6ms 0ms 09 382 6ms 0ms 10 378 6ms 0ms 11 382 6ms 0ms 12 379 6ms 0ms 13 380 6ms 0ms 14 383 6ms 0ms 15 377 6ms 0ms 16 384 6ms 0ms 17 380 6ms 0ms 18 377 6ms 0ms 19 384 6ms 0ms 20 377 6ms 0ms 21 382 6ms 0ms 22 379 6ms 0ms 23 380 6ms 0ms 00 382 6ms 0ms [ User: symmetricds - Total duration: 152ms - Times executed: 9132 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 152ms - Times executed: 9132 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2019-07-27 08:50:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 21:37:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 21:52:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,130 111ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 01 380 4ms 0ms 02 380 4ms 0ms 03 381 4ms 0ms 04 384 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 381 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 380 4ms 0ms 12 381 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 380 4ms 0ms 16 381 4ms 0ms 17 380 4ms 0ms 18 380 4ms 0ms 19 381 4ms 0ms 20 380 4ms 0ms 21 380 4ms 0ms 22 381 4ms 0ms 23 380 4ms 0ms 00 380 4ms 0ms [ User: symmetricds - Total duration: 111ms - Times executed: 9130 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 111ms - Times executed: 9130 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-07-27 10:45:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 06:07:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 388ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 01 358 15ms 0ms 02 358 15ms 0ms 03 359 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 359 16ms 0ms 08 358 15ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 16ms 0ms 13 358 15ms 0ms 14 358 15ms 0ms 15 358 16ms 0ms 16 359 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 359 15ms 0ms 20 358 15ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 16ms 0ms 00 358 15ms 0ms [ User: symmetricds - Total duration: 388ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 388ms - Times executed: 8598 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-07-27 10:24:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:59:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:02:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,598 278ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 01 358 12ms 0ms 02 358 12ms 0ms 03 359 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 12ms 0ms 12 359 11ms 0ms 13 358 10ms 0ms 14 358 11ms 0ms 15 358 10ms 0ms 16 359 10ms 0ms 17 358 10ms 0ms 18 358 10ms 0ms 19 359 10ms 0ms 20 358 10ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms 00 358 10ms 0ms [ User: symmetricds - Total duration: 278ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 278ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '104471673' AND '154471672'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '104471905' AND '154471904'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '104471814' AND '154471813'));
Date: 2019-07-27 03:20:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 11:51:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:46:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,598 217ms 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 #15
Day Hour Count Duration Avg duration Jul 27 01 358 9ms 0ms 02 358 9ms 0ms 03 359 9ms 0ms 04 358 9ms 0ms 05 358 9ms 0ms 06 358 9ms 0ms 07 359 9ms 0ms 08 358 9ms 0ms 09 358 9ms 0ms 10 358 9ms 0ms 11 358 8ms 0ms 12 359 8ms 0ms 13 358 9ms 0ms 14 358 9ms 0ms 15 358 9ms 0ms 16 359 8ms 0ms 17 358 9ms 0ms 18 358 8ms 0ms 19 359 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 359 8ms 0ms 23 358 8ms 0ms 00 358 8ms 0ms [ User: symmetricds - Total duration: 217ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 217ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104471663' AND data_id <= '154471662' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104471946' AND data_id <= '154471945' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104471917' AND data_id <= '154471916' ORDER BY data_id ASC;
Date: 2019-07-27 02:24:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 12:56:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,598 302ms 0ms 1ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 01 358 14ms 0ms 02 358 12ms 0ms 03 359 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 359 12ms 0ms 13 358 12ms 0ms 14 358 13ms 0ms 15 358 12ms 0ms 16 359 12ms 0ms 17 358 13ms 0ms 18 358 12ms 0ms 19 359 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms 00 358 12ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 8598 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-07-27 00:12:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 04:12:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:17:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,207 318ms 0ms 0ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 01 239 12ms 0ms 02 240 13ms 0ms 03 237 12ms 0ms 04 239 13ms 0ms 05 240 12ms 0ms 06 237 12ms 0ms 07 239 12ms 0ms 08 240 13ms 0ms 09 240 12ms 0ms 10 236 13ms 0ms 11 240 12ms 0ms 12 240 12ms 0ms 13 239 12ms 0ms 14 289 14ms 0ms 15 288 13ms 0ms 16 282 13ms 0ms 17 281 13ms 0ms 18 284 14ms 0ms 19 285 13ms 0ms 20 280 13ms 0ms 21 274 13ms 0ms 22 283 14ms 0ms 23 277 14ms 0ms 00 278 13ms 0ms [ User: symmetricds - Total duration: 318ms - Times executed: 6207 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 318ms - Times executed: 6207 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
Date: 2019-07-27 09:08:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 22:35:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:36:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,207 710ms 0ms 4ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 01 239 27ms 0ms 02 240 26ms 0ms 03 237 26ms 0ms 04 239 28ms 0ms 05 240 27ms 0ms 06 237 26ms 0ms 07 239 27ms 0ms 08 240 28ms 0ms 09 240 27ms 0ms 10 236 27ms 0ms 11 240 28ms 0ms 12 240 32ms 0ms 13 239 27ms 0ms 14 289 32ms 0ms 15 288 31ms 0ms 16 282 30ms 0ms 17 281 33ms 0ms 18 284 32ms 0ms 19 285 31ms 0ms 20 280 31ms 0ms 21 274 29ms 0ms 22 283 31ms 0ms 23 277 31ms 0ms 00 278 29ms 0ms [ User: symmetricds - Total duration: 710ms - Times executed: 6207 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 6207 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-07-27 11:25:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 16:37:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 13:57:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,418 483ms 0ms 10ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 01 184 31ms 0ms 02 184 27ms 0ms 03 184 19ms 0ms 04 186 20ms 0ms 05 184 30ms 0ms 06 184 18ms 0ms 07 184 21ms 0ms 08 184 19ms 0ms 09 184 19ms 0ms 10 184 20ms 0ms 11 184 19ms 0ms 12 184 19ms 0ms 13 184 18ms 0ms 14 184 16ms 0ms 15 184 19ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 17ms 0ms 19 184 20ms 0ms 20 184 20ms 0ms 21 184 18ms 0ms 22 184 17ms 0ms 23 184 16ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 483ms - Times executed: 4418 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 483ms - Times executed: 4418 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-07-27 04:07:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:17:45 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:17:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,084 92ms 0ms 0ms 0ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 01 1,096 26ms 0ms 02 60 3ms 0ms 03 56 3ms 0ms 04 56 3ms 0ms 05 48 2ms 0ms 06 52 2ms 0ms 07 48 2ms 0ms 08 48 3ms 0ms 09 48 2ms 0ms 10 44 3ms 0ms 11 40 3ms 0ms 12 32 2ms 0ms 13 32 2ms 0ms 14 36 2ms 0ms 15 32 2ms 0ms 16 32 2ms 0ms 17 32 2ms 0ms 18 36 2ms 0ms 19 36 2ms 0ms 20 36 2ms 0ms 21 40 2ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 92ms - Times executed: 2084 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 92ms - Times executed: 2084 ]
-
SELECT set_config('symmetric.node_disabled', '', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-07-27 00:33:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:56:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 103ms 14ms 149 2s206ms 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 Jul 27 01 13 84ms 6ms 02 13 81ms 6ms 03 13 101ms 7ms 04 13 81ms 6ms 05 13 83ms 6ms 06 13 80ms 6ms 07 13 101ms 7ms 08 13 281ms 21ms 09 8 112ms 14ms 10 7 322ms 46ms 11 6 212ms 35ms 12 5 190ms 38ms 13 4 122ms 30ms 14 3 104ms 34ms 15 2 54ms 27ms 16 2 55ms 27ms 17 1 19ms 19ms 18 1 34ms 34ms 19 1 13ms 13ms 20 1 11ms 11ms 21 1 14ms 14ms 22 1 12ms 12ms 23 1 9ms 9ms 00 1 14ms 14ms [ User: symmetricds - Total duration: 2s206ms - Times executed: 149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s206ms - Times executed: 149 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104440918' AND '104445918' AND create_time < '2019-07-26 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104440918' AND '104445918' 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 '104446449' AND '104451449' AND create_time < '2019-07-26 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449' 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 '104449545' AND '104454545' AND create_time < '2019-07-26 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104449545' AND '104454545' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-07-27 09:00:00 Duration: 103ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 10:00:00 Duration: 80ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 11:00:00 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4ms 13ms 6ms 151 975ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 01 101 611ms 6ms 02 3 23ms 7ms 03 3 23ms 7ms 04 3 23ms 7ms 05 2 14ms 7ms 06 3 23ms 7ms 07 2 14ms 7ms 08 2 14ms 7ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 14ms 7ms 14 2 13ms 6ms 15 2 14ms 7ms 16 2 13ms 6ms 17 2 14ms 7ms 18 2 14ms 7ms 19 2 14ms 7ms 20 2 14ms 7ms 21 2 17ms 8ms 22 2 14ms 7ms 23 2 13ms 6ms 00 2 14ms 7ms [ User: symmetricds - Total duration: 767ms - Times executed: 106 ]
[ User: pharmisight - Total duration: 207ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 975ms - Times executed: 151 ]
-
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 = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-07-27 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:00:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:06:04 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 7ms 6ms 96 608ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 01 4 22ms 5ms 02 4 29ms 7ms 03 4 26ms 6ms 04 4 26ms 6ms 05 4 29ms 7ms 06 4 28ms 7ms 07 4 27ms 6ms 08 4 28ms 7ms 09 4 27ms 6ms 10 4 27ms 6ms 11 4 28ms 7ms 12 4 28ms 7ms 13 4 28ms 7ms 14 4 16ms 4ms 15 4 28ms 7ms 16 4 27ms 6ms 17 4 15ms 3ms 18 4 21ms 5ms 19 4 28ms 7ms 20 4 22ms 5ms 21 4 22ms 5ms 22 4 22ms 5ms 23 4 27ms 6ms 00 4 16ms 4ms [ User: symmetricds - Total duration: 608ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 608ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '117700352', total_memory_bytes = '271056896', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 04:43:33', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '129937424', total_memory_bytes = '281018368', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 02:28:32', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '87711176', total_memory_bytes = '264765440', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-07-27 01:13:32', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-07-27 04:43:33 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 02:28:32 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:13:32 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 22ms 5ms 137 733ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 01 13 62ms 4ms 02 13 56ms 4ms 03 13 56ms 4ms 04 13 56ms 4ms 05 13 55ms 4ms 06 13 55ms 4ms 07 13 54ms 4ms 08 8 30ms 3ms 09 7 25ms 3ms 10 6 108ms 18ms 11 5 71ms 14ms 12 4 41ms 10ms 13 3 24ms 8ms 14 2 12ms 6ms 15 2 7ms 3ms 16 1 2ms 2ms 17 1 1ms 1ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 1ms 1ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 733ms - Times executed: 137 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 137 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104446449' AND '104451449' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104446449' AND '104451449');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104461452' AND '104466452' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104461452' AND '104466452');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104451450' AND '104456450' AND data_id < '104471877' AND create_time < '2019-07-26 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104451450' AND '104456450');
Date: 2019-07-27 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3ms 9ms 4ms 237 1s20ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 01 11 44ms 4ms 02 10 41ms 4ms 03 9 34ms 3ms 04 14 59ms 4ms 05 10 41ms 4ms 06 10 39ms 3ms 07 9 35ms 3ms 08 10 39ms 3ms 09 11 43ms 3ms 10 8 31ms 3ms 11 10 39ms 3ms 12 9 39ms 4ms 13 9 40ms 4ms 14 11 48ms 4ms 15 11 59ms 5ms 16 12 61ms 5ms 17 8 40ms 5ms 18 10 42ms 4ms 19 11 45ms 4ms 20 10 45ms 4ms 21 9 40ms 4ms 22 8 32ms 4ms 23 8 35ms 4ms 00 9 37ms 4ms [ User: symmetricds - Total duration: 1s20ms - Times executed: 237 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s20ms - Times executed: 237 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 14:13:49 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 14:13:49 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 20:43:53 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 9ms 4ms 178 745ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 01 8 25ms 3ms 02 8 27ms 3ms 03 8 26ms 3ms 04 8 28ms 3ms 05 8 23ms 2ms 06 8 30ms 3ms 07 8 30ms 3ms 08 8 35ms 4ms 09 8 30ms 3ms 10 7 39ms 5ms 11 6 33ms 5ms 12 6 22ms 3ms 13 6 26ms 4ms 14 6 20ms 3ms 15 7 25ms 3ms 16 6 25ms 4ms 17 7 27ms 3ms 18 8 22ms 2ms 19 8 20ms 2ms 20 8 23ms 2ms 21 7 38ms 5ms 22 8 50ms 6ms 23 8 55ms 6ms 00 8 53ms 6ms [ User: symmetricds - Total duration: 745ms - Times executed: 178 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 745ms - Times executed: 178 ]
-
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-8-amd64', "available_processors" = '3', "free_memory_bytes" = '223092912', "total_memory_bytes" = '597688320', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 08:49:41', "last_restart_time" = '2019-05-14 22:11:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '88172048', "total_memory_bytes" = '562561024', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 16:38:14', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '118627072', "total_memory_bytes" = '562561024', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-07-27 22:23:15', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2019-07-27 08:49:59 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 16:36:01 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 22:21:03 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 5ms 1ms 1,012 1s456ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 01 55 79ms 1ms 02 56 79ms 1ms 03 54 77ms 1ms 04 58 81ms 1ms 05 57 82ms 1ms 06 56 80ms 1ms 07 54 77ms 1ms 08 58 81ms 1ms 09 53 76ms 1ms 10 59 87ms 1ms 11 57 80ms 1ms 12 56 81ms 1ms 13 52 74ms 1ms 14 25 35ms 1ms 15 27 39ms 1ms 16 26 37ms 1ms 17 25 36ms 1ms 18 26 38ms 1ms 19 27 39ms 1ms 20 26 38ms 1ms 21 29 41ms 1ms 22 25 36ms 1ms 23 27 39ms 1ms 00 24 35ms 1ms [ User: symmetricds - Total duration: 1s456ms - Times executed: 1012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s456ms - Times executed: 1012 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 09:13:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 06:40:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:03:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 7ms 1ms 1,224 1s251ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 01 65 64ms 0ms 02 66 68ms 1ms 03 67 71ms 1ms 04 68 68ms 1ms 05 66 67ms 1ms 06 67 66ms 0ms 07 67 68ms 1ms 08 68 68ms 1ms 09 65 72ms 1ms 10 71 72ms 1ms 11 68 70ms 1ms 12 65 66ms 1ms 13 65 66ms 1ms 14 33 33ms 1ms 15 36 36ms 1ms 16 30 30ms 1ms 17 31 32ms 1ms 18 29 29ms 1ms 19 32 32ms 1ms 20 31 31ms 1ms 21 35 34ms 0ms 22 33 32ms 0ms 23 35 34ms 0ms 00 31 29ms 0ms [ User: symmetricds - Total duration: 1s251ms - Times executed: 1224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s251ms - Times executed: 1224 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 08:13:47 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 02:29:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 10:49:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 3ms 0ms 1,011 953ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 01 55 53ms 0ms 02 56 53ms 0ms 03 55 51ms 0ms 04 58 54ms 0ms 05 56 52ms 0ms 06 57 53ms 0ms 07 55 51ms 0ms 08 57 53ms 0ms 09 52 49ms 0ms 10 59 55ms 0ms 11 57 56ms 0ms 12 55 52ms 0ms 13 52 49ms 0ms 14 25 23ms 0ms 15 27 24ms 0ms 16 26 24ms 0ms 17 25 23ms 0ms 18 26 24ms 0ms 19 27 25ms 0ms 20 26 23ms 0ms 21 29 26ms 0ms 22 25 23ms 0ms 23 27 25ms 0ms 00 24 22ms 0ms [ User: symmetricds - Total duration: 953ms - Times executed: 1011 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 953ms - Times executed: 1011 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 10:49:48 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:49:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:27:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 999 879ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 01 54 47ms 0ms 02 55 48ms 0ms 03 54 47ms 0ms 04 58 50ms 0ms 05 56 49ms 0ms 06 56 48ms 0ms 07 54 47ms 0ms 08 56 49ms 0ms 09 52 46ms 0ms 10 57 49ms 0ms 11 54 47ms 0ms 12 54 47ms 0ms 13 52 46ms 0ms 14 25 21ms 0ms 15 27 23ms 0ms 16 26 22ms 0ms 17 25 22ms 0ms 18 26 22ms 0ms 19 27 23ms 0ms 20 26 22ms 0ms 21 29 25ms 0ms 22 25 22ms 0ms 23 27 24ms 0ms 00 24 21ms 0ms [ User: symmetricds - Total duration: 879ms - Times executed: 999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 879ms - Times executed: 999 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-07-27 07:31:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 12:23:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:27:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 2ms 0ms 17,197 9s937ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 01 717 426ms 0ms 02 716 426ms 0ms 03 718 421ms 0ms 04 716 425ms 0ms 05 716 417ms 0ms 06 716 424ms 0ms 07 718 425ms 0ms 08 716 417ms 0ms 09 716 413ms 0ms 10 716 415ms 0ms 11 716 421ms 0ms 12 718 424ms 0ms 13 716 418ms 0ms 14 716 399ms 0ms 15 716 405ms 0ms 16 718 398ms 0ms 17 716 402ms 0ms 18 716 411ms 0ms 19 718 409ms 0ms 20 716 406ms 0ms 21 716 402ms 0ms 22 718 401ms 0ms 23 716 410ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 9s937ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s937ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-07-27 07:51:24 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:34:23 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:35:13 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 4ms 0ms 6,207 710ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 01 239 27ms 0ms 02 240 26ms 0ms 03 237 26ms 0ms 04 239 28ms 0ms 05 240 27ms 0ms 06 237 26ms 0ms 07 239 27ms 0ms 08 240 28ms 0ms 09 240 27ms 0ms 10 236 27ms 0ms 11 240 28ms 0ms 12 240 32ms 0ms 13 239 27ms 0ms 14 289 32ms 0ms 15 288 31ms 0ms 16 282 30ms 0ms 17 281 33ms 0ms 18 284 32ms 0ms 19 285 31ms 0ms 20 280 31ms 0ms 21 274 29ms 0ms 22 283 31ms 0ms 23 277 31ms 0ms 00 278 29ms 0ms [ User: symmetricds - Total duration: 710ms - Times executed: 6207 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 6207 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-07-27 11:25:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 16:37:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 13:57:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 10ms 0ms 4,418 483ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 01 184 31ms 0ms 02 184 27ms 0ms 03 184 19ms 0ms 04 186 20ms 0ms 05 184 30ms 0ms 06 184 18ms 0ms 07 184 21ms 0ms 08 184 19ms 0ms 09 184 19ms 0ms 10 184 20ms 0ms 11 184 19ms 0ms 12 184 19ms 0ms 13 184 18ms 0ms 14 184 16ms 0ms 15 184 19ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 17ms 0ms 19 184 20ms 0ms 20 184 20ms 0ms 21 184 18ms 0ms 22 184 17ms 0ms 23 184 16ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 483ms - Times executed: 4418 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 483ms - Times executed: 4418 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-07-27 04:07:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 00:17:45 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:17:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 17,294 892ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 01 720 36ms 0ms 02 720 36ms 0ms 03 722 37ms 0ms 04 722 36ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 36ms 0ms 09 720 36ms 0ms 10 720 36ms 0ms 11 720 37ms 0ms 12 722 36ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 37ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 38ms 0ms 20 720 37ms 0ms 21 720 37ms 0ms 22 722 38ms 0ms 23 720 37ms 0ms 00 720 38ms 0ms [ User: symmetricds - Total duration: 892ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-07-27 05:05:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 18:16:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 23:05:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 6,207 318ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 01 239 12ms 0ms 02 240 13ms 0ms 03 237 12ms 0ms 04 239 13ms 0ms 05 240 12ms 0ms 06 237 12ms 0ms 07 239 12ms 0ms 08 240 13ms 0ms 09 240 12ms 0ms 10 236 13ms 0ms 11 240 12ms 0ms 12 240 12ms 0ms 13 239 12ms 0ms 14 289 14ms 0ms 15 288 13ms 0ms 16 282 13ms 0ms 17 281 13ms 0ms 18 284 14ms 0ms 19 285 13ms 0ms 20 280 13ms 0ms 21 274 13ms 0ms 22 283 14ms 0ms 23 277 14ms 0ms 00 278 13ms 0ms [ User: symmetricds - Total duration: 318ms - Times executed: 6207 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 318ms - Times executed: 6207 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
Date: 2019-07-27 09:08:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 22:35:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:36:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 25,030 1s249ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 01 1,128 55ms 0ms 02 1,042 52ms 0ms 03 1,042 49ms 0ms 04 1,042 52ms 0ms 05 1,036 51ms 0ms 06 1,038 51ms 0ms 07 1,038 52ms 0ms 08 1,038 50ms 0ms 09 1,038 51ms 0ms 10 1,042 53ms 0ms 11 1,040 51ms 0ms 12 1,038 52ms 0ms 13 1,036 50ms 0ms 14 1,038 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 53ms 0ms 18 1,036 52ms 0ms 19 1,038 51ms 0ms 20 1,036 50ms 0ms 21 1,040 53ms 0ms 22 1,046 53ms 0ms 23 1,044 51ms 0ms 00 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s249ms - Times executed: 25030 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s249ms - Times executed: 25030 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-07-27 14:43:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 20:43:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:14:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 21,864 1s58ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 01 911 24ms 0ms 02 911 39ms 0ms 03 911 40ms 0ms 04 911 42ms 0ms 05 911 38ms 0ms 06 911 39ms 0ms 07 911 40ms 0ms 08 911 42ms 0ms 09 911 50ms 0ms 10 911 47ms 0ms 11 911 47ms 0ms 12 911 46ms 0ms 13 911 47ms 0ms 14 911 46ms 0ms 15 911 46ms 0ms 16 911 48ms 0ms 17 911 46ms 0ms 18 911 48ms 0ms 19 911 46ms 0ms 20 911 46ms 0ms 21 911 43ms 0ms 22 911 46ms 0ms 23 911 46ms 0ms 00 911 46ms 0ms [ User: pharmisight - Total duration: 1s58ms - Times executed: 21864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s58ms - Times executed: 21864 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3209' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2728' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3369' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-07-27 17:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 24,624 1s182ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 01 1,026 27ms 0ms 02 1,026 45ms 0ms 03 1,026 45ms 0ms 04 1,026 46ms 0ms 05 1,026 42ms 0ms 06 1,026 42ms 0ms 07 1,026 44ms 0ms 08 1,026 47ms 0ms 09 1,026 56ms 0ms 10 1,026 52ms 0ms 11 1,026 53ms 0ms 12 1,026 52ms 0ms 13 1,026 52ms 0ms 14 1,026 51ms 0ms 15 1,026 52ms 0ms 16 1,026 53ms 0ms 17 1,026 51ms 0ms 18 1,026 53ms 0ms 19 1,026 52ms 0ms 20 1,026 53ms 0ms 21 1,026 48ms 0ms 22 1,026 51ms 0ms 23 1,026 52ms 0ms 00 1,026 52ms 0ms [ User: pharmisight - Total duration: 1s182ms - Times executed: 24624 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s182ms - Times executed: 24624 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3307' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3339' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2728' ORDER BY itemcodes0_.code ASC;
Date: 2019-07-27 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,598 388ms 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 Jul 27 01 358 15ms 0ms 02 358 15ms 0ms 03 359 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 359 16ms 0ms 08 358 15ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 16ms 0ms 13 358 15ms 0ms 14 358 15ms 0ms 15 358 16ms 0ms 16 359 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 359 15ms 0ms 20 358 15ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 16ms 0ms 00 358 15ms 0ms [ User: symmetricds - Total duration: 388ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 388ms - Times executed: 8598 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-07-27 10:24:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 03:59:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 17:02:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 2,084 92ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 01 1,096 26ms 0ms 02 60 3ms 0ms 03 56 3ms 0ms 04 56 3ms 0ms 05 48 2ms 0ms 06 52 2ms 0ms 07 48 2ms 0ms 08 48 3ms 0ms 09 48 2ms 0ms 10 44 3ms 0ms 11 40 3ms 0ms 12 32 2ms 0ms 13 32 2ms 0ms 14 36 2ms 0ms 15 32 2ms 0ms 16 32 2ms 0ms 17 32 2ms 0ms 18 36 2ms 0ms 19 36 2ms 0ms 20 36 2ms 0ms 21 40 2ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 92ms - Times executed: 2084 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 92ms - Times executed: 2084 ]
-
SELECT set_config('symmetric.node_disabled', '', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-07-27 00:33:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 01:56:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-07-27 08:49:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,143,516 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET