pgBadger-
Global information
- Generated on Sun Aug 25 00:00:25 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,399,790 log entries in 23s
- Log start from 2019-08-24 00:00:00 to 2019-08-24 23:59:53
-
Overview
Global Stats
- 195 Number of unique normalized queries
- 1,145,989 Number of queries
- 1m10s Total query duration
- 2019-08-24 00:00:00 First query
- 2019-08-24 23:59:53 Last query
- 1,603 queries/s at 2019-08-24 00:00:00 Query peak
- 2 Number of events
- 2 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 56 Total number of automatic vacuums
- 77 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,134 Total number of sessions
- 2 sessions at 2019-08-24 00:30:13 Session peak
- 10d1h45m20s Total duration of sessions
- 6m47s Average duration of sessions
- 537 Average queries per session
- 33ms Average queries duration per session
- 2,134 Total number of connections
- 9 connections/s at 2019-08-24 00:30:22 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1,603 queries/s Query Peak
- 2019-08-24 00:00:00 Date
SELECT Traffic
Key values
- 1,457 queries/s Query Peak
- 2019-08-24 00:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 422 queries/s Query Peak
- 2019-08-24 00:20:50 Date
Queries duration
Key values
- 1m10s Total query duration
Prepared queries ratio
Key values
- 1.67 Ratio of bind vs prepare
- 163.92 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 24 00 58,123 0ms 92ms 0ms 113ms 447ms 1s373ms 01 48,387 0ms 88ms 0ms 77ms 149ms 581ms 02 47,867 0ms 83ms 0ms 94ms 124ms 575ms 03 48,355 0ms 89ms 0ms 96ms 150ms 658ms 04 47,830 0ms 109ms 0ms 94ms 142ms 648ms 05 47,513 0ms 82ms 0ms 94ms 117ms 568ms 06 47,336 0ms 81ms 0ms 96ms 141ms 543ms 07 47,969 0ms 165ms 0ms 91ms 121ms 1s115ms 08 47,328 0ms 66ms 0ms 81ms 127ms 548ms 09 47,635 0ms 94ms 0ms 88ms 121ms 668ms 10 47,602 0ms 90ms 0ms 95ms 113ms 582ms 11 47,638 0ms 124ms 0ms 86ms 120ms 754ms 12 46,604 0ms 150ms 0ms 78ms 109ms 768ms 13 46,661 0ms 152ms 0ms 83ms 113ms 777ms 14 46,763 0ms 87ms 0ms 92ms 110ms 534ms 15 46,652 0ms 77ms 0ms 86ms 108ms 427ms 16 46,618 0ms 60ms 0ms 79ms 106ms 363ms 17 46,636 0ms 49ms 0ms 81ms 104ms 315ms 18 46,905 0ms 51ms 0ms 90ms 96ms 316ms 19 46,600 0ms 40ms 0ms 79ms 101ms 255ms 20 49,719 0ms 38ms 0ms 75ms 161ms 847ms 21 46,470 0ms 51ms 0ms 82ms 96ms 241ms 22 46,373 0ms 37ms 0ms 74ms 85ms 222ms 23 46,405 0ms 37ms 0ms 76ms 82ms 241ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 24 00 22,570 0 0ms 54ms 73ms 492ms 01 17,010 0 0ms 49ms 56ms 179ms 02 16,920 0 0ms 49ms 72ms 191ms 03 17,074 0 0ms 40ms 74ms 228ms 04 16,935 0 0ms 39ms 62ms 219ms 05 16,874 0 0ms 38ms 65ms 208ms 06 16,843 0 0ms 52ms 74ms 247ms 07 16,982 0 0ms 41ms 68ms 229ms 08 16,825 0 0ms 37ms 60ms 224ms 09 16,877 0 0ms 51ms 65ms 208ms 10 16,906 0 0ms 42ms 64ms 200ms 11 16,881 0 0ms 50ms 70ms 197ms 12 16,606 0 0ms 49ms 55ms 198ms 13 16,634 0 0ms 43ms 61ms 188ms 14 16,666 0 0ms 49ms 57ms 188ms 15 16,623 0 0ms 51ms 56ms 197ms 16 16,617 0 0ms 45ms 64ms 177ms 17 16,621 0 0ms 52ms 59ms 195ms 18 16,709 0 0ms 51ms 67ms 194ms 19 16,649 0 0ms 53ms 59ms 187ms 20 19,613 0 0ms 51ms 57ms 176ms 21 16,577 0 0ms 50ms 60ms 182ms 22 16,540 0 0ms 49ms 55ms 182ms 23 16,557 0 0ms 50ms 57ms 182ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 24 00 1,790 1,574 120 0 0ms 12ms 16ms 91ms 01 906 289 122 0 0ms 1ms 7ms 54ms 02 567 194 116 0 0ms 1ms 8ms 22ms 03 689 224 120 0 0ms 1ms 8ms 36ms 04 515 181 119 0 0ms 1ms 7ms 42ms 05 260 117 118 0 0ms 1ms 8ms 19ms 06 223 100 117 0 0ms 1ms 8ms 17ms 07 509 179 113 0 1ms 1ms 7ms 25ms 08 260 109 103 0 0ms 1ms 7ms 17ms 09 391 150 102 0 0ms 1ms 7ms 26ms 10 288 122 101 0 0ms 1ms 8ms 18ms 11 456 167 98 0 0ms 1ms 7ms 29ms 12 88 53 92 0 2ms 1ms 7ms 9ms 13 83 53 90 0 2ms 1ms 7ms 8ms 14 93 54 89 0 1ms 1ms 2ms 8ms 15 88 54 87 0 1ms 1ms 7ms 9ms 16 83 53 87 0 1ms 1ms 7ms 9ms 17 88 53 81 0 1ms 1ms 7ms 8ms 18 93 55 84 0 1ms 1ms 7ms 8ms 19 103 72 80 0 0ms 1ms 6ms 9ms 20 142 113 120 0 0ms 1ms 7ms 8ms 21 88 54 82 0 0ms 1ms 5ms 8ms 22 88 53 80 0 0ms 1ms 4ms 8ms 23 88 54 81 0 0ms 1ms 7ms 9ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 24 00 32,882 58,061 1.77 84.10% 01 28,550 48,327 1.69 96.20% 02 28,475 47,807 1.68 97.67% 03 28,820 48,295 1.68 97.58% 04 28,772 47,770 1.66 98.83% 05 28,569 47,453 1.66 99.35% 06 28,531 47,274 1.66 99.70% 07 28,876 47,909 1.66 98.94% 08 28,482 47,268 1.66 99.47% 09 28,527 47,575 1.67 98.74% 10 28,884 47,542 1.65 100.24% 11 28,684 47,578 1.66 99.09% 12 28,012 46,542 1.66 99.85% 13 28,284 46,601 1.65 100.73% 14 28,370 46,703 1.65 100.76% 15 28,337 46,592 1.64 100.94% 16 28,307 46,558 1.64 100.91% 17 28,238 46,576 1.65 100.60% 18 28,346 46,843 1.65 100.41% 19 27,783 46,540 1.68 98.91% 20 27,812 49,659 1.79 89.14% 21 27,885 46,410 1.66 99.71% 22 27,674 46,313 1.67 99.14% 23 27,773 46,345 1.67 99.42% Day Hour Count Average / Second Aug 24 00 118 0.03/s 01 85 0.02/s 02 87 0.02/s 03 86 0.02/s 04 85 0.02/s 05 86 0.02/s 06 89 0.02/s 07 90 0.03/s 08 88 0.02/s 09 86 0.02/s 10 87 0.02/s 11 88 0.02/s 12 85 0.02/s 13 88 0.02/s 14 89 0.02/s 15 90 0.03/s 16 89 0.02/s 17 88 0.02/s 18 89 0.02/s 19 87 0.02/s 20 86 0.02/s 21 91 0.03/s 22 89 0.02/s 23 88 0.02/s Day Hour Count Average Duration Aug 24 00 118 5m31s 01 85 7m11s 02 87 6m48s 03 86 7m18s 04 85 6m52s 05 86 7m1s 06 89 6m41s 07 90 6m50s 08 88 6m35s 09 86 7m19s 10 87 6m55s 11 88 6m40s 12 85 6m52s 13 88 6m57s 14 89 6m33s 15 90 7m3s 16 89 6m30s 17 88 6m49s 18 89 6m56s 19 87 6m58s 20 86 6m49s 21 91 6m45s 22 89 6m59s 23 88 6m32s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2019-08-24 00:30:22 Date
Connections per database
Key values
- pharmisight Main Database
- 2,134 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,134 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2019-08-24 00:30:13 Date
Histogram of session times
Key values
- 872 0-500ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,134 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,134 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,134 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,861 buffers Checkpoint Peak
- 2019-08-24 07:06:11 Date
- 149.729 seconds Highest write time
- 0.085 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2019-08-24 07:06:11 Date
Checkpoints distance
Key values
- 102.12 Mo Distance Peak
- 2019-08-24 07:06:11 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 24 00 1,921 192.809s 0.016s 192.894s 01 811 81.318s 0.049s 81.441s 02 630 63.239s 0.017s 63.405s 03 637 63.932s 0.1s 64.128s 04 579 58.01s 0.027s 58.111s 05 593 59.446s 0.016s 59.538s 06 615 61.731s 0.027s 61.833s 07 8,281 191.534s 0.027s 191.63s 08 1,513 151.853s 0.02s 151.945s 09 2,716 189.408s 0.017s 189.489s 10 2,047 186.472s 0.018s 186.561s 11 3,366 188.882s 0.035s 188.983s 12 1,502 150.618s 0.019s 150.71s 13 1,367 136.685s 0.02s 136.772s 14 1,348 135.059s 0.029s 135.16s 15 1,813 181.782s 0.026s 181.873s 16 880 88.13s 0.026s 88.348s 17 1,061 106.53s 0.02s 106.619s 18 1,277 128.02s 0.025s 128.223s 19 924 92.544s 0.016s 92.63s 20 478 48.008s 0.015s 48.093s 21 376 37.739s 0.026s 37.902s 22 546 54.716s 0.024s 54.828s 23 423 42.479s 0.019s 42.562s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 24 00 0 0 0 359 0.002s 0s 01 0 0 0 323 0.016s 0.001s 02 0 0 1 317 0.003s 0s 03 0 0 0 307 0.085s 0.003s 04 0 0 0 295 0.008s 0s 05 0 0 0 290 0.002s 0s 06 0 0 0 290 0.008s 0s 07 0 0 4 308 0.008s 0s 08 0 0 0 314 0.003s 0s 09 0 0 1 307 0.002s 0s 10 0 0 1 309 0.003s 0s 11 0 0 0 322 0.008s 0s 12 0 0 1 286 0.002s 0s 13 0 0 0 301 0.003s 0s 14 0 0 1 305 0.010s 0s 15 0 0 0 287 0.003s 0s 16 0 0 1 298 0.008s 0s 17 0 0 0 301 0.006s 0s 18 0 0 0 309 0.011s 0s 19 0 0 0 312 0.003s 0s 20 0 0 1 270 0.002s 0s 21 0 0 0 233 0.003s 0s 22 0 0 0 244 0.008s 0s 23 0 0 0 237 0.003s 0s Day Hour Count Avg time (sec) Aug 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 24 00 982.25 kB 1,599.58 kB 01 337.00 kB 1,187.58 kB 02 249.17 kB 737.42 kB 03 250.75 kB 654.33 kB 04 214.17 kB 551.42 kB 05 257.17 kB 987.42 kB 06 262.75 kB 994.33 kB 07 4,912.64 kB 32,683.91 kB 08 740.33 kB 10,365.67 kB 09 1,226.09 kB 7,472.73 kB 10 638.92 kB 3,808.00 kB 11 961.50 kB 6,082.33 kB 12 784.33 kB 4,906.67 kB 13 719.58 kB 4,489.25 kB 14 714.17 kB 4,457.42 kB 15 726.00 kB 4,340.45 kB 16 358.67 kB 1,873.00 kB 17 420.42 kB 2,403.92 kB 18 514.75 kB 3,078.33 kB 19 300.50 kB 1,558.42 kB 20 154.17 kB 542.50 kB 21 90.17 kB 229.08 kB 22 141.42 kB 459.33 kB 23 100.25 kB 252.75 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 24 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 (17) Main table analyzed (database pharmisight)
- 77 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 17 pharmisight.public.sym_data 14 pharmisight.public.sym_data_event 14 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_incoming_batch 11 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 Total 77 Vacuums per table
Key values
- public.sym_data (11) Main table vacuumed on database pharmisight
- 56 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_data 11 11 pharmisight.public.sym_data_event 11 11 pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_incoming_batch 5 5 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.flow_report_summary_delays 1 1 pharmisight.public.item_codes 1 1 pharmisight.public.sym_sequence 1 0 Total 56 49 Tuples removed per table
Key values
- public.sym_data_event (34193) Main table with removed tuples on database pharmisight
- 62676 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 11 11 34193 1167 pharmisight.public.sym_data 11 11 19945 3225 pharmisight.public.sym_outgoing_batch 10 10 5712 0 pharmisight.public.sym_incoming_batch 5 5 987 0 pharmisight.pg_catalog.pg_statistic 2 2 613 0 pharmisight.public.item_codes 1 1 327 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 307 0 pharmisight.pg_toast.pg_toast_2619 2 2 167 0 pharmisight.public.flow_report_summary_delays 1 1 62 0 pharmisight.public.sym_sequence 1 0 51 0 Total 56 49 62,676 4,392 Pages removed per table
Key values
- public.sym_data (3225) Main table with removed pages on database pharmisight
- 4392 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 11 11 19945 3225 pharmisight.public.sym_data_event 11 11 34193 1167 pharmisight.public.sym_incoming_batch 5 5 987 0 pharmisight.public.flow_report_summary_delays 1 1 62 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 307 0 pharmisight.public.item_codes 1 1 327 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_outgoing_batch 10 10 5712 0 pharmisight.pg_catalog.pg_statistic 2 2 613 0 pharmisight.pg_toast.pg_toast_2619 2 2 167 0 Total 56 49 62,676 4,392 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 24 00 1 5 01 2 3 02 1 1 03 0 2 04 0 1 05 1 1 06 1 1 07 3 4 08 1 5 09 5 5 10 2 3 11 3 4 12 2 5 13 4 4 14 4 3 15 5 4 16 3 5 17 4 3 18 4 6 19 6 4 20 1 4 21 1 0 22 2 3 23 0 1 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 411,109 Total read queries
- 287,132 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,145,405 Requests
- 1m (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,081,925 Requests
User Request type Count Duration librenms Total 608 10s791ms SELECT 608 10s791ms pharmisight Total 107,816 8s944ms DELETE 39 3ms INSERT 1,457 1s51ms OTHERS 1,785 87ms SELECT 103,863 7s693ms TCL 601 86ms UPDATE 71 21ms symmetricds Total 1,081,925 53s181ms DELETE 2,434 5s794ms INSERT 6,921 1s262ms OTHERS 464,444 7s774ms SELECT 320,709 29s144ms TCL 283,204 6s229ms UPDATE 4,213 2s975ms tony Total 900 283ms SELECT 900 283ms Duration by user
Key values
- 53s181ms (symmetricds) Main time consuming user
User Request type Count Duration librenms Total 608 10s791ms SELECT 608 10s791ms pharmisight Total 107,816 8s944ms DELETE 39 3ms INSERT 1,457 1s51ms OTHERS 1,785 87ms SELECT 103,863 7s693ms TCL 601 86ms UPDATE 71 21ms symmetricds Total 1,081,925 53s181ms DELETE 2,434 5s794ms INSERT 6,921 1s262ms OTHERS 464,444 7s774ms SELECT 320,709 29s144ms TCL 283,204 6s229ms UPDATE 4,213 2s975ms tony Total 900 283ms SELECT 900 283ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,189,741 Requests
- 1m2s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,143,279 Requests
- 59s888ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-24 15:45:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,141,952 0-1ms duration
Slowest individual queries
Rank Duration Query 1 165ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '9280810' AND '9281507' AND status != 'OK') AND batch_id BETWEEN '9280810' AND '9281507';[ Date: 2019-08-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 152ms DELETE FROM sym_data WHERE data_id BETWEEN '105877747' AND '105882747' AND create_time < '2019-08-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 150ms DELETE FROM sym_data WHERE data_id BETWEEN '105871450' AND '105876450' AND create_time < '2019-08-23 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 124ms DELETE FROM sym_data WHERE data_id BETWEEN '105865090' AND '105870090' AND create_time < '2019-08-23 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 109ms DELETE FROM sym_data WHERE data_id BETWEEN '105814655' AND '105819655' AND create_time < '2019-08-23 04:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105814655' AND '105819655') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105814655' AND '105819655' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 94ms DELETE FROM sym_data WHERE data_id BETWEEN '105853362' AND '105858362' AND create_time < '2019-08-23 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105853362' AND '105858362') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105853362' AND '105858362' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 92ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 91ms COMMIT;[ Date: 2019-08-24 13:00:53 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 90ms DELETE FROM sym_data WHERE data_id BETWEEN '105859750' AND '105864750' AND create_time < '2019-08-23 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105859750' AND '105864750') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105859750' AND '105864750' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 89ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 88ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 87ms DELETE FROM sym_data WHERE data_id BETWEEN '105883332' AND '105888332' AND create_time < '2019-08-23 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105883332' AND '105888332') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105883332' AND '105888332' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 83ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 82ms DELETE FROM sym_outgoing_batch WHERE status = 'OK' AND batch_id BETWEEN '9280810' AND '9281507' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '9280810' AND '9281507');[ Date: 2019-08-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 82ms DELETE FROM sym_data WHERE data_id BETWEEN '105820372' AND '105825372' AND create_time < '2019-08-23 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105820372' AND '105825372') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105820372' AND '105825372' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 82ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 81ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-24 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 77ms DELETE FROM sym_data WHERE data_id BETWEEN '105889107' AND '105894107' AND create_time < '2019-08-23 15:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105889107' AND '105894107') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105889107' AND '105894107' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 69ms DELETE FROM sym_data WHERE data_id BETWEEN '105876451' AND '105881451' AND create_time < '2019-08-23 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105876451' AND '105881451') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105876451' AND '105881451' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-24 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10s156ms 292 22ms 51ms 34ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 01 13 443ms 34ms 02 12 406ms 33ms 03 12 425ms 35ms 04 12 415ms 34ms 05 12 410ms 34ms 06 12 429ms 35ms 07 13 462ms 35ms 08 12 411ms 34ms 09 12 412ms 34ms 10 12 422ms 35ms 11 12 404ms 33ms 12 12 410ms 34ms 13 13 454ms 34ms 14 12 412ms 34ms 15 12 436ms 36ms 16 12 428ms 35ms 17 12 415ms 34ms 18 12 432ms 36ms 19 13 449ms 34ms 20 12 425ms 35ms 21 12 401ms 33ms 22 12 436ms 36ms 23 12 413ms 34ms 00 12 394ms 32ms [ User: librenms - Total duration: 10s156ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s156ms - Times executed: 292 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-08-24 21:55:11 Duration: 51ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-24 16:30:11 Duration: 50ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-24 14:30:10 Duration: 43ms Database: postgres User: librenms Remote: [local] Application: psql
2 10s13ms 17,197 0ms 9ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 01 717 423ms 0ms 02 716 422ms 0ms 03 716 421ms 0ms 04 718 420ms 0ms 05 716 420ms 0ms 06 716 429ms 0ms 07 716 413ms 0ms 08 718 419ms 0ms 09 716 408ms 0ms 10 716 418ms 0ms 11 718 421ms 0ms 12 716 410ms 0ms 13 716 412ms 0ms 14 716 418ms 0ms 15 718 406ms 0ms 16 716 416ms 0ms 17 716 419ms 0ms 18 716 423ms 0ms 19 718 425ms 0ms 20 716 417ms 0ms 21 716 419ms 0ms 22 718 407ms 0ms 23 716 409ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 10s13ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s13ms - 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-08-24 18:55:57 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:40:26 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:55:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 7s137ms 426,695 0ms 5ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 01 18,083 292ms 0ms 02 17,825 297ms 0ms 03 17,830 300ms 0ms 04 17,933 297ms 0ms 05 17,837 307ms 0ms 06 17,874 305ms 0ms 07 17,838 298ms 0ms 08 17,890 296ms 0ms 09 17,818 293ms 0ms 10 17,859 294ms 0ms 11 17,896 298ms 0ms 12 17,805 293ms 0ms 13 17,695 294ms 0ms 14 17,716 299ms 0ms 15 17,742 301ms 0ms 16 17,709 297ms 0ms 17 17,700 301ms 0ms 18 17,706 295ms 0ms 19 17,807 296ms 0ms 20 17,651 294ms 0ms 21 17,651 294ms 0ms 22 17,629 296ms 0ms 23 17,596 292ms 0ms 00 17,605 296ms 0ms [ User: symmetricds - Total duration: 7s108ms - Times executed: 426125 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 570 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s137ms - Times executed: 426695 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-24 16:51:15 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:28:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:19:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 5s173ms 136,311 0ms 91ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 24 01 6,522 598ms 0ms 02 5,675 210ms 0ms 03 5,678 211ms 0ms 04 5,714 206ms 0ms 05 5,681 201ms 0ms 06 5,693 210ms 0ms 07 5,667 191ms 0ms 08 5,701 209ms 0ms 09 5,668 208ms 0ms 10 5,686 216ms 0ms 11 5,699 222ms 0ms 12 5,673 211ms 0ms 13 5,608 193ms 0ms 14 5,609 272ms 0ms 15 5,627 194ms 0ms 16 5,610 184ms 0ms 17 5,606 174ms 0ms 18 5,613 174ms 0ms 19 5,645 195ms 0ms 20 5,593 172ms 0ms 21 5,606 181ms 0ms 22 5,583 173ms 0ms 23 5,576 181ms 0ms 00 5,578 176ms 0ms [ User: symmetricds - Total duration: 5s95ms - Times executed: 136021 ]
[ User: pharmisight - Total duration: 77ms - Times executed: 290 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s173ms - Times executed: 136311 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-24 13:00:53 Duration: 91ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 08:05:39 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:14:54 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s569ms 225 0ms 152ms 15ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 24 01 19 122ms 6ms 02 19 112ms 5ms 03 19 114ms 6ms 04 19 155ms 8ms 05 19 202ms 10ms 06 18 112ms 6ms 07 18 116ms 6ms 08 18 424ms 23ms 09 12 145ms 12ms 10 11 205ms 18ms 11 10 161ms 16ms 12 9 315ms 35ms 13 7 383ms 54ms 14 6 313ms 52ms 15 5 205ms 41ms 16 4 131ms 32ms 17 3 85ms 28ms 18 2 66ms 33ms 19 2 63ms 31ms 20 1 39ms 39ms 21 1 21ms 21ms 22 1 19ms 19ms 23 1 23ms 23ms 00 1 25ms 25ms [ User: symmetricds - Total duration: 3s569ms - Times executed: 225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s569ms - Times executed: 225 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105877747' AND '105882747' AND create_time < '2019-08-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747' 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 '105871450' AND '105876450' AND create_time < '2019-08-23 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450' 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 '105865090' AND '105870090' AND create_time < '2019-08-23 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-24 13:00:00 Duration: 152ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 12:00:00 Duration: 150ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 11:00:00 Duration: 124ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 2s784ms 50,568 0ms 0ms 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 Aug 24 01 3,096 145ms 0ms 02 2,064 100ms 0ms 03 2,064 100ms 0ms 04 2,064 110ms 0ms 05 2,064 119ms 0ms 06 2,064 119ms 0ms 07 2,064 115ms 0ms 08 2,064 117ms 0ms 09 2,064 118ms 0ms 10 2,064 115ms 0ms 11 2,064 122ms 0ms 12 2,064 111ms 0ms 13 2,064 114ms 0ms 14 2,064 113ms 0ms 15 2,064 114ms 0ms 16 2,064 118ms 0ms 17 2,064 122ms 0ms 18 2,064 117ms 0ms 19 2,064 114ms 0ms 20 2,064 113ms 0ms 21 2,064 105ms 0ms 22 2,064 121ms 0ms 23 2,064 111ms 0ms 00 2,064 119ms 0ms [ User: pharmisight - Total duration: 2s784ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s784ms - Times executed: 50568 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3131' 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 = '3012' 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 = '3082' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-24 15:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 2s498ms 44,884 0ms 4ms 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 Aug 24 01 2,748 130ms 0ms 02 1,832 91ms 0ms 03 1,832 91ms 0ms 04 1,832 99ms 0ms 05 1,832 106ms 0ms 06 1,832 106ms 0ms 07 1,832 103ms 0ms 08 1,832 105ms 0ms 09 1,832 105ms 0ms 10 1,832 103ms 0ms 11 1,832 109ms 0ms 12 1,832 100ms 0ms 13 1,832 102ms 0ms 14 1,832 105ms 0ms 15 1,832 102ms 0ms 16 1,832 105ms 0ms 17 1,832 109ms 0ms 18 1,832 105ms 0ms 19 1,832 102ms 0ms 20 1,832 101ms 0ms 21 1,832 95ms 0ms 22 1,832 108ms 0ms 23 1,832 99ms 0ms 00 1,832 107ms 0ms [ User: pharmisight - Total duration: 2s498ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s498ms - Times executed: 44884 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3095' 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 = '32969224' 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 = '3232' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-24 13:00:00 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s868ms 156,357 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 24 01 7,458 84ms 0ms 02 6,541 76ms 0ms 03 6,531 78ms 0ms 04 6,574 79ms 0ms 05 6,532 77ms 0ms 06 6,550 77ms 0ms 07 6,520 77ms 0ms 08 6,552 76ms 0ms 09 6,501 76ms 0ms 10 6,522 77ms 0ms 11 6,543 80ms 0ms 12 6,507 79ms 0ms 13 6,429 74ms 0ms 14 6,432 78ms 0ms 15 6,446 75ms 0ms 16 6,427 80ms 0ms 17 6,423 78ms 0ms 18 6,420 79ms 0ms 19 6,465 75ms 0ms 20 6,401 74ms 0ms 21 6,411 80ms 0ms 22 6,402 76ms 0ms 23 6,384 78ms 0ms 00 6,386 74ms 0ms [ User: symmetricds - Total duration: 1s868ms - Times executed: 156357 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s868ms - Times executed: 156357 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-24 17:39:24 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:53:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 15:48:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s342ms 25,228 0ms 3ms 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 #9
Day Hour Count Duration Avg duration Aug 24 01 1,126 56ms 0ms 02 1,051 54ms 0ms 03 1,051 57ms 0ms 04 1,054 53ms 0ms 05 1,052 56ms 0ms 06 1,051 55ms 0ms 07 1,050 55ms 0ms 08 1,054 56ms 0ms 09 1,050 54ms 0ms 10 1,051 56ms 0ms 11 1,054 54ms 0ms 12 1,052 53ms 0ms 13 1,044 53ms 0ms 14 1,044 56ms 0ms 15 1,046 53ms 0ms 16 1,044 56ms 0ms 17 1,044 54ms 0ms 18 1,044 54ms 0ms 19 1,046 59ms 0ms 20 1,044 57ms 0ms 21 1,042 57ms 0ms 22 1,046 57ms 0ms 23 1,044 57ms 0ms 00 1,044 59ms 0ms [ User: symmetricds - Total duration: 1s342ms - Times executed: 25228 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s342ms - Times executed: 25228 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-08-24 18:55:26 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:12:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:13:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s208ms 205 0ms 23ms 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 #10
Day Hour Count Duration Avg duration Aug 24 01 19 96ms 5ms 02 19 94ms 4ms 03 18 85ms 4ms 04 18 115ms 6ms 05 18 87ms 4ms 06 18 84ms 4ms 07 18 84ms 4ms 08 12 58ms 4ms 09 11 47ms 4ms 10 10 42ms 4ms 11 9 35ms 3ms 12 7 64ms 9ms 13 6 102ms 17ms 14 5 66ms 13ms 15 4 46ms 11ms 16 3 27ms 9ms 17 2 22ms 11ms 18 2 13ms 6ms 19 1 6ms 6ms 20 1 5ms 5ms 21 1 5ms 5ms 22 1 5ms 5ms 23 1 5ms 5ms 00 1 5ms 5ms [ User: symmetricds - Total duration: 1s208ms - Times executed: 205 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s208ms - Times executed: 205 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105871450' AND '105876450' AND data_id < '105905262' AND create_time < '2019-08-23 11:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105886453' AND '105891453' AND data_id < '105905262' AND create_time < '2019-08-23 11:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105886453' AND '105891453');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105887749' AND '105892749' AND data_id < '105905363' AND create_time < '2019-08-23 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105887749' AND '105892749');
Date: 2019-08-24 11:00:00 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 11:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 12:00:00 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s128ms 190 0ms 9ms 5ms 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 #11
Day Hour Count Duration Avg duration Aug 24 01 8 49ms 6ms 02 8 46ms 5ms 03 8 39ms 4ms 04 8 46ms 5ms 05 8 56ms 7ms 06 8 51ms 6ms 07 8 55ms 6ms 08 8 42ms 5ms 09 8 48ms 6ms 10 8 45ms 5ms 11 8 48ms 6ms 12 8 41ms 5ms 13 8 51ms 6ms 14 8 39ms 4ms 15 8 47ms 5ms 16 8 48ms 6ms 17 8 44ms 5ms 18 8 50ms 6ms 19 8 49ms 6ms 20 8 39ms 4ms 21 6 37ms 6ms 22 8 45ms 5ms 23 8 50ms 6ms 00 8 53ms 6ms [ User: symmetricds - Total duration: 1s128ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s128ms - Times executed: 190 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '21597176', "total_memory_bytes" = '259522560', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 06:28:49', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '506564336', "total_memory_bytes" = '1211105280', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 05:10:21', "last_restart_time" = '2019-08-20 01:25:09.822', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '18635424', "total_memory_bytes" = '264765440', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 22:03:49', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-08-24 06:29:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:10:51 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:04:55 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s109ms 178 3ms 11ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 24 01 114 704ms 6ms 02 3 17ms 5ms 03 4 22ms 5ms 04 3 17ms 5ms 05 3 17ms 5ms 06 3 17ms 5ms 07 3 22ms 7ms 08 3 17ms 5ms 09 3 17ms 5ms 10 3 28ms 9ms 11 3 17ms 5ms 12 3 17ms 5ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 17ms 8ms 20 2 13ms 6ms 21 8 39ms 4ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 826ms - Times executed: 133 ]
[ User: pharmisight - Total duration: 282ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s109ms - Times executed: 178 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_trigger' 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-08-24 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 00:00:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:05:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 987ms 683 0ms 3ms 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 #13
Day Hour Count Duration Avg duration Aug 24 01 47 63ms 1ms 02 26 38ms 1ms 03 26 38ms 1ms 04 28 40ms 1ms 05 28 40ms 1ms 06 26 38ms 1ms 07 26 38ms 1ms 08 30 42ms 1ms 09 27 38ms 1ms 10 25 35ms 1ms 11 29 42ms 1ms 12 28 40ms 1ms 13 24 33ms 1ms 14 29 39ms 1ms 15 29 41ms 1ms 16 28 39ms 1ms 17 29 39ms 1ms 18 28 40ms 1ms 19 28 42ms 1ms 20 26 39ms 1ms 21 27 39ms 1ms 22 30 46ms 1ms 23 29 43ms 1ms 00 30 43ms 1ms [ User: symmetricds - Total duration: 987ms - Times executed: 683 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 987ms - Times executed: 683 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 11:46:12 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:15:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:33:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 972ms 24 4ms 92ms 40ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 24 01 1 92ms 92ms 02 1 88ms 88ms 03 1 83ms 83ms 04 1 89ms 89ms 05 1 85ms 85ms 06 1 82ms 82ms 07 1 81ms 81ms 08 1 61ms 61ms 09 1 50ms 50ms 10 1 46ms 46ms 11 1 40ms 40ms 12 1 31ms 31ms 13 1 27ms 27ms 14 1 21ms 21ms 15 1 21ms 21ms 16 1 15ms 15ms 17 1 12ms 12ms 18 1 8ms 8ms 19 1 6ms 6ms 20 1 5ms 5ms 21 1 4ms 4ms 22 1 5ms 5ms 23 1 4ms 4ms 00 1 5ms 5ms [ User: symmetricds - Total duration: 972ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 972ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-08-24 00:00:00 Duration: 92ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:00:00 Duration: 89ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 01:00:00 Duration: 88ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 971ms 1,329 0ms 11ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 01 361 221ms 0ms 02 176 103ms 0ms 03 118 70ms 0ms 04 146 94ms 0ms 05 104 76ms 0ms 06 40 58ms 1ms 07 33 32ms 0ms 08 101 76ms 0ms 09 41 37ms 0ms 10 74 67ms 0ms 11 46 65ms 1ms 12 89 68ms 0ms [ User: pharmisight - Total duration: 971ms - Times executed: 1329 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 971ms - Times executed: 1329 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005990917', '2019-08-24 05:36:47', 'MORGANG', '2019-08-24 05:00:01.535', '79754', '24', '31237090426138010');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005986083', '2019-08-24 09:31:54', 'KNIGHTMA', '2019-08-24 09:00:01.551', '134351', '576', '150505230149081642');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005986083', '2019-08-24 11:08:33', 'KNIGHTMA', '2019-08-24 10:20:01.472', '70870', '24', '150505230149083752');
Date: 2019-08-24 05:00:01 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:00:01 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 10:20:01 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 957ms 17,362 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 #16
Day Hour Count Duration Avg duration Aug 24 01 726 39ms 0ms 02 726 40ms 0ms 03 726 40ms 0ms 04 728 40ms 0ms 05 726 39ms 0ms 06 726 40ms 0ms 07 724 40ms 0ms 08 728 39ms 0ms 09 724 39ms 0ms 10 726 39ms 0ms 11 728 39ms 0ms 12 726 39ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 722 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 39ms 0ms [ User: symmetricds - Total duration: 957ms - Times executed: 17362 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 957ms - Times executed: 17362 ]
-
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 = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-08-24 02:15:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:04:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 904ms 136,312 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 24 01 6,522 42ms 0ms 02 5,676 36ms 0ms 03 5,678 37ms 0ms 04 5,714 37ms 0ms 05 5,681 38ms 0ms 06 5,693 39ms 0ms 07 5,667 37ms 0ms 08 5,701 39ms 0ms 09 5,668 38ms 0ms 10 5,686 36ms 0ms 11 5,699 38ms 0ms 12 5,673 36ms 0ms 13 5,608 36ms 0ms 14 5,609 36ms 0ms 15 5,627 36ms 0ms 16 5,610 37ms 0ms 17 5,606 37ms 0ms 18 5,613 38ms 0ms 19 5,645 37ms 0ms 20 5,593 36ms 0ms 21 5,606 39ms 0ms 22 5,583 37ms 0ms 23 5,576 37ms 0ms 00 5,578 36ms 0ms [ User: symmetricds - Total duration: 902ms - Times executed: 136020 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 136312 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-24 20:55:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 07:26:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 17:18:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 885ms 922 0ms 4ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 24 01 64 58ms 0ms 02 36 33ms 0ms 03 36 33ms 0ms 04 36 33ms 0ms 05 37 35ms 0ms 06 38 36ms 0ms 07 36 34ms 0ms 08 41 41ms 1ms 09 36 34ms 0ms 10 37 35ms 0ms 11 40 37ms 0ms 12 42 39ms 0ms 13 34 32ms 0ms 14 36 34ms 0ms 15 39 38ms 0ms 16 40 40ms 1ms 17 38 36ms 0ms 18 34 32ms 0ms 19 37 35ms 0ms 20 34 31ms 0ms 21 36 33ms 0ms 22 41 43ms 1ms 23 37 35ms 0ms 00 37 35ms 0ms [ User: symmetricds - Total duration: 885ms - Times executed: 922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 885ms - Times executed: 922 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 8 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 21:37:18 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 07:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:11:17 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 870ms 202 1ms 12ms 4ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 24 01 12 50ms 4ms 02 11 43ms 3ms 03 10 39ms 3ms 04 11 51ms 4ms 05 11 47ms 4ms 06 8 36ms 4ms 07 11 51ms 4ms 08 12 63ms 5ms 09 9 37ms 4ms 10 6 24ms 4ms 11 10 42ms 4ms 12 12 42ms 3ms 13 7 22ms 3ms 14 5 27ms 5ms 15 7 34ms 4ms 16 6 29ms 4ms 17 7 26ms 3ms 18 6 27ms 4ms 19 7 36ms 5ms 20 8 32ms 4ms 21 10 36ms 3ms 22 6 24ms 4ms 23 6 24ms 4ms 00 4 15ms 3ms [ User: symmetricds - Total duration: 870ms - Times executed: 202 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 870ms - Times executed: 202 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 07:21:09 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:06:15 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:40:07 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 809ms 49 9ms 30ms 16ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 24 01 3 46ms 15ms 02 2 28ms 14ms 03 2 42ms 21ms 04 2 45ms 22ms 05 2 29ms 14ms 06 2 31ms 15ms 07 2 42ms 21ms 08 2 34ms 17ms 09 2 31ms 15ms 10 2 38ms 19ms 11 2 35ms 17ms 12 2 38ms 19ms 13 2 27ms 13ms 14 2 29ms 14ms 15 2 29ms 14ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 29ms 14ms 19 2 33ms 16ms 20 2 27ms 13ms 21 2 29ms 14ms 22 2 36ms 18ms 23 2 29ms 14ms 00 2 33ms 16ms [ User: pharmisight - Total duration: 809ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 809ms - Times executed: 49 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-08-24 03:00:00 Duration: 30ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:00:00 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:00:00 Duration: 24ms Database: pharmisight User: pharmisight 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 426,695 7s137ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 01 18,083 292ms 0ms 02 17,825 297ms 0ms 03 17,830 300ms 0ms 04 17,933 297ms 0ms 05 17,837 307ms 0ms 06 17,874 305ms 0ms 07 17,838 298ms 0ms 08 17,890 296ms 0ms 09 17,818 293ms 0ms 10 17,859 294ms 0ms 11 17,896 298ms 0ms 12 17,805 293ms 0ms 13 17,695 294ms 0ms 14 17,716 299ms 0ms 15 17,742 301ms 0ms 16 17,709 297ms 0ms 17 17,700 301ms 0ms 18 17,706 295ms 0ms 19 17,807 296ms 0ms 20 17,651 294ms 0ms 21 17,651 294ms 0ms 22 17,629 296ms 0ms 23 17,596 292ms 0ms 00 17,605 296ms 0ms [ User: symmetricds - Total duration: 7s108ms - Times executed: 426125 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 570 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s137ms - Times executed: 426695 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-24 16:51:15 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:28:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:19:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 156,357 1s868ms 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 01 7,458 84ms 0ms 02 6,541 76ms 0ms 03 6,531 78ms 0ms 04 6,574 79ms 0ms 05 6,532 77ms 0ms 06 6,550 77ms 0ms 07 6,520 77ms 0ms 08 6,552 76ms 0ms 09 6,501 76ms 0ms 10 6,522 77ms 0ms 11 6,543 80ms 0ms 12 6,507 79ms 0ms 13 6,429 74ms 0ms 14 6,432 78ms 0ms 15 6,446 75ms 0ms 16 6,427 80ms 0ms 17 6,423 78ms 0ms 18 6,420 79ms 0ms 19 6,465 75ms 0ms 20 6,401 74ms 0ms 21 6,411 80ms 0ms 22 6,402 76ms 0ms 23 6,384 78ms 0ms 00 6,386 74ms 0ms [ User: symmetricds - Total duration: 1s868ms - Times executed: 156357 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s868ms - Times executed: 156357 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-24 17:39:24 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:53:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 15:48:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 136,312 904ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 01 6,522 42ms 0ms 02 5,676 36ms 0ms 03 5,678 37ms 0ms 04 5,714 37ms 0ms 05 5,681 38ms 0ms 06 5,693 39ms 0ms 07 5,667 37ms 0ms 08 5,701 39ms 0ms 09 5,668 38ms 0ms 10 5,686 36ms 0ms 11 5,699 38ms 0ms 12 5,673 36ms 0ms 13 5,608 36ms 0ms 14 5,609 36ms 0ms 15 5,627 36ms 0ms 16 5,610 37ms 0ms 17 5,606 37ms 0ms 18 5,613 38ms 0ms 19 5,645 37ms 0ms 20 5,593 36ms 0ms 21 5,606 39ms 0ms 22 5,583 37ms 0ms 23 5,576 37ms 0ms 00 5,578 36ms 0ms [ User: symmetricds - Total duration: 902ms - Times executed: 136020 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 136312 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-24 20:55:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 07:26:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 17:18:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 136,311 5s173ms 0ms 91ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 24 01 6,522 598ms 0ms 02 5,675 210ms 0ms 03 5,678 211ms 0ms 04 5,714 206ms 0ms 05 5,681 201ms 0ms 06 5,693 210ms 0ms 07 5,667 191ms 0ms 08 5,701 209ms 0ms 09 5,668 208ms 0ms 10 5,686 216ms 0ms 11 5,699 222ms 0ms 12 5,673 211ms 0ms 13 5,608 193ms 0ms 14 5,609 272ms 0ms 15 5,627 194ms 0ms 16 5,610 184ms 0ms 17 5,606 174ms 0ms 18 5,613 174ms 0ms 19 5,645 195ms 0ms 20 5,593 172ms 0ms 21 5,606 181ms 0ms 22 5,583 173ms 0ms 23 5,576 181ms 0ms 00 5,578 176ms 0ms [ User: symmetricds - Total duration: 5s95ms - Times executed: 136021 ]
[ User: pharmisight - Total duration: 77ms - Times executed: 290 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s173ms - Times executed: 136311 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-24 13:00:53 Duration: 91ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 08:05:39 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:14:54 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 50,568 2s784ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 24 01 3,096 145ms 0ms 02 2,064 100ms 0ms 03 2,064 100ms 0ms 04 2,064 110ms 0ms 05 2,064 119ms 0ms 06 2,064 119ms 0ms 07 2,064 115ms 0ms 08 2,064 117ms 0ms 09 2,064 118ms 0ms 10 2,064 115ms 0ms 11 2,064 122ms 0ms 12 2,064 111ms 0ms 13 2,064 114ms 0ms 14 2,064 113ms 0ms 15 2,064 114ms 0ms 16 2,064 118ms 0ms 17 2,064 122ms 0ms 18 2,064 117ms 0ms 19 2,064 114ms 0ms 20 2,064 113ms 0ms 21 2,064 105ms 0ms 22 2,064 121ms 0ms 23 2,064 111ms 0ms 00 2,064 119ms 0ms [ User: pharmisight - Total duration: 2s784ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s784ms - Times executed: 50568 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3131' 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 = '3012' 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 = '3082' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-24 15:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 44,884 2s498ms 0ms 4ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 24 01 2,748 130ms 0ms 02 1,832 91ms 0ms 03 1,832 91ms 0ms 04 1,832 99ms 0ms 05 1,832 106ms 0ms 06 1,832 106ms 0ms 07 1,832 103ms 0ms 08 1,832 105ms 0ms 09 1,832 105ms 0ms 10 1,832 103ms 0ms 11 1,832 109ms 0ms 12 1,832 100ms 0ms 13 1,832 102ms 0ms 14 1,832 105ms 0ms 15 1,832 102ms 0ms 16 1,832 105ms 0ms 17 1,832 109ms 0ms 18 1,832 105ms 0ms 19 1,832 102ms 0ms 20 1,832 101ms 0ms 21 1,832 95ms 0ms 22 1,832 108ms 0ms 23 1,832 99ms 0ms 00 1,832 107ms 0ms [ User: pharmisight - Total duration: 2s498ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s498ms - Times executed: 44884 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3095' 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 = '32969224' 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 = '3232' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-24 13:00:00 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,228 1s342ms 0ms 3ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 24 01 1,126 56ms 0ms 02 1,051 54ms 0ms 03 1,051 57ms 0ms 04 1,054 53ms 0ms 05 1,052 56ms 0ms 06 1,051 55ms 0ms 07 1,050 55ms 0ms 08 1,054 56ms 0ms 09 1,050 54ms 0ms 10 1,051 56ms 0ms 11 1,054 54ms 0ms 12 1,052 53ms 0ms 13 1,044 53ms 0ms 14 1,044 56ms 0ms 15 1,046 53ms 0ms 16 1,044 56ms 0ms 17 1,044 54ms 0ms 18 1,044 54ms 0ms 19 1,046 59ms 0ms 20 1,044 57ms 0ms 21 1,042 57ms 0ms 22 1,046 57ms 0ms 23 1,044 57ms 0ms 00 1,044 59ms 0ms [ User: symmetricds - Total duration: 1s342ms - Times executed: 25228 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s342ms - Times executed: 25228 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-08-24 18:55:26 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:12:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:13:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,362 957ms 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 Aug 24 01 726 39ms 0ms 02 726 40ms 0ms 03 726 40ms 0ms 04 728 40ms 0ms 05 726 39ms 0ms 06 726 40ms 0ms 07 724 40ms 0ms 08 728 39ms 0ms 09 724 39ms 0ms 10 726 39ms 0ms 11 728 39ms 0ms 12 726 39ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 722 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 39ms 0ms [ User: symmetricds - Total duration: 957ms - Times executed: 17362 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 957ms - Times executed: 17362 ]
-
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 = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-08-24 02:15:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:04:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,266 520ms 0ms 3ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 24 01 720 22ms 0ms 02 718 21ms 0ms 03 720 21ms 0ms 04 720 21ms 0ms 05 718 22ms 0ms 06 720 21ms 0ms 07 720 21ms 0ms 08 720 22ms 0ms 09 718 21ms 0ms 10 720 21ms 0ms 11 720 21ms 0ms 12 720 21ms 0ms 13 718 20ms 0ms 14 720 21ms 0ms 15 720 21ms 0ms 16 718 21ms 0ms 17 720 21ms 0ms 18 720 21ms 0ms 19 720 25ms 0ms 20 718 21ms 0ms 21 720 21ms 0ms 22 720 21ms 0ms 23 718 21ms 0ms 00 720 21ms 0ms [ User: symmetricds - Total duration: 520ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 520ms - Times executed: 17266 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-08-24 18:56:09 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 00:09:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:48:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,197 10s13ms 0ms 9ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 24 01 717 423ms 0ms 02 716 422ms 0ms 03 716 421ms 0ms 04 718 420ms 0ms 05 716 420ms 0ms 06 716 429ms 0ms 07 716 413ms 0ms 08 718 419ms 0ms 09 716 408ms 0ms 10 716 418ms 0ms 11 718 421ms 0ms 12 716 410ms 0ms 13 716 412ms 0ms 14 716 418ms 0ms 15 718 406ms 0ms 16 716 416ms 0ms 17 716 419ms 0ms 18 716 423ms 0ms 19 718 425ms 0ms 20 716 417ms 0ms 21 716 419ms 0ms 22 718 407ms 0ms 23 716 409ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 10s13ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s13ms - 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-08-24 18:55:57 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:40:26 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:55:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,266 133ms 0ms 6ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 24 01 392 5ms 0ms 02 392 5ms 0ms 03 392 5ms 0ms 04 393 5ms 0ms 05 392 5ms 0ms 06 392 5ms 0ms 07 388 12ms 0ms 08 393 5ms 0ms 09 388 5ms 0ms 10 392 5ms 0ms 11 393 5ms 0ms 12 392 5ms 0ms 13 380 5ms 0ms 14 380 5ms 0ms 15 381 5ms 0ms 16 380 5ms 0ms 17 380 5ms 0ms 18 380 5ms 0ms 19 381 5ms 0ms 20 380 5ms 0ms 21 384 5ms 0ms 22 381 5ms 0ms 23 380 5ms 0ms 00 380 5ms 0ms [ User: symmetricds - Total duration: 133ms - Times executed: 9266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 133ms - Times executed: 9266 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-08-24 06:24:30 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:43:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,263 166ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 24 01 389 6ms 0ms 02 394 7ms 0ms 03 390 6ms 0ms 04 394 7ms 0ms 05 391 7ms 0ms 06 392 7ms 0ms 07 391 7ms 0ms 08 393 6ms 0ms 09 385 6ms 0ms 10 392 6ms 0ms 11 396 7ms 0ms 12 389 6ms 0ms 13 380 6ms 0ms 14 383 6ms 0ms 15 378 6ms 0ms 16 383 6ms 0ms 17 380 6ms 0ms 18 377 6ms 0ms 19 384 6ms 0ms 20 377 6ms 0ms 21 384 6ms 0ms 22 383 7ms 0ms 23 378 6ms 0ms 00 380 6ms 0ms [ User: symmetricds - Total duration: 166ms - Times executed: 9263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 166ms - Times executed: 9263 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2019-08-24 21:11:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 01:28:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 02:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 431ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 24 01 358 18ms 0ms 02 358 18ms 0ms 03 358 18ms 0ms 04 359 17ms 0ms 05 358 17ms 0ms 06 358 18ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 18ms 0ms 10 358 17ms 0ms 11 359 17ms 0ms 12 358 17ms 0ms 13 358 18ms 0ms 14 358 17ms 0ms 15 359 17ms 0ms 16 358 17ms 0ms 17 358 18ms 0ms 18 358 17ms 0ms 19 359 18ms 0ms 20 358 17ms 0ms 21 358 17ms 0ms 22 359 18ms 0ms 23 358 17ms 0ms 00 358 17ms 0ms [ User: symmetricds - Total duration: 431ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 431ms - 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-08-24 18:07:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 00:35:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 08:17:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,598 226ms 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 #14
Day Hour Count Duration Avg duration Aug 24 01 358 9ms 0ms 02 358 9ms 0ms 03 358 9ms 0ms 04 359 9ms 0ms 05 358 9ms 0ms 06 358 10ms 0ms 07 358 9ms 0ms 08 359 9ms 0ms 09 358 9ms 0ms 10 358 9ms 0ms 11 359 9ms 0ms 12 358 9ms 0ms 13 358 9ms 0ms 14 358 9ms 0ms 15 359 9ms 0ms 16 358 9ms 0ms 17 358 9ms 0ms 18 358 9ms 0ms 19 359 9ms 0ms 20 358 9ms 0ms 21 358 9ms 0ms 22 359 9ms 0ms 23 358 9ms 0ms 00 358 9ms 0ms [ User: symmetricds - Total duration: 226ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 226ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105904804' AND data_id <= '155904803' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105904879' AND data_id <= '155904878' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105904951' AND data_id <= '155904950' ORDER BY data_id ASC;
Date: 2019-08-24 04:21:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:07:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:57:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,598 296ms 0ms 1ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 01 358 14ms 0ms 02 358 13ms 0ms 03 358 13ms 0ms 04 359 13ms 0ms 05 358 13ms 0ms 06 358 14ms 0ms 07 358 13ms 0ms 08 359 11ms 0ms 09 358 13ms 0ms 10 358 11ms 0ms 11 359 14ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 359 11ms 0ms 16 358 11ms 0ms 17 358 11ms 0ms 18 358 11ms 0ms 19 359 11ms 0ms 20 358 11ms 0ms 21 358 11ms 0ms 22 359 11ms 0ms 23 358 11ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 296ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 296ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105904905' AND '155904904'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105903987' AND '155903986'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105904278' AND '155904277'));
Date: 2019-08-24 05:53:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 00:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 01:20:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,598 335ms 0ms 4ms 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 Aug 24 01 358 12ms 0ms 02 358 13ms 0ms 03 358 14ms 0ms 04 359 13ms 0ms 05 358 13ms 0ms 06 358 13ms 0ms 07 358 13ms 0ms 08 359 14ms 0ms 09 358 13ms 0ms 10 358 13ms 0ms 11 359 13ms 0ms 12 358 13ms 0ms 13 358 13ms 0ms 14 358 14ms 0ms 15 359 13ms 0ms 16 358 13ms 0ms 17 358 14ms 0ms 18 358 13ms 0ms 19 359 13ms 0ms 20 358 17ms 0ms 21 358 14ms 0ms 22 359 13ms 0ms 23 358 13ms 0ms 00 358 14ms 0ms [ User: symmetricds - Total duration: 335ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 335ms - 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-08-24 19:24:25 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 07:07:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 23:32:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,665 348ms 0ms 1ms 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 Aug 24 01 249 14ms 0ms 02 278 13ms 0ms 03 282 14ms 0ms 04 287 14ms 0ms 05 282 15ms 0ms 06 287 15ms 0ms 07 287 16ms 0ms 08 280 14ms 0ms 09 283 14ms 0ms 10 285 14ms 0ms 11 282 14ms 0ms 12 275 14ms 0ms 13 279 14ms 0ms 14 284 14ms 0ms 15 280 13ms 0ms 16 280 14ms 0ms 17 283 14ms 0ms 18 281 14ms 0ms 19 288 15ms 0ms 20 275 14ms 0ms 21 268 14ms 0ms 22 262 13ms 0ms 23 264 14ms 0ms 00 264 14ms 0ms [ User: symmetricds - Total duration: 348ms - Times executed: 6665 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 348ms - Times executed: 6665 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '3' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-08-24 06:57:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 23:31:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:52:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,664 760ms 0ms 2ms 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 Aug 24 01 248 28ms 0ms 02 278 31ms 0ms 03 282 31ms 0ms 04 287 33ms 0ms 05 282 32ms 0ms 06 287 32ms 0ms 07 287 33ms 0ms 08 280 30ms 0ms 09 283 33ms 0ms 10 285 31ms 0ms 11 282 33ms 0ms 12 275 30ms 0ms 13 279 30ms 0ms 14 284 31ms 0ms 15 280 32ms 0ms 16 280 30ms 0ms 17 283 31ms 0ms 18 281 31ms 0ms 19 288 33ms 0ms 20 275 30ms 0ms 21 268 32ms 0ms 22 262 31ms 0ms 23 264 29ms 0ms 00 264 31ms 0ms [ User: symmetricds - Total duration: 760ms - Times executed: 6664 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 760ms - Times executed: 6664 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-08-24 03:43:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 14:32:13 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:14:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,482 453ms 0ms 3ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 24 01 190 22ms 0ms 02 189 19ms 0ms 03 189 20ms 0ms 04 190 19ms 0ms 05 190 20ms 0ms 06 189 20ms 0ms 07 188 19ms 0ms 08 190 18ms 0ms 09 188 19ms 0ms 10 189 19ms 0ms 11 190 19ms 0ms 12 190 20ms 0ms 13 184 17ms 0ms 14 184 17ms 0ms 15 184 18ms 0ms 16 184 17ms 0ms 17 184 17ms 0ms 18 184 16ms 0ms 19 184 19ms 0ms 20 184 18ms 0ms 21 186 16ms 0ms 22 184 19ms 0ms 23 184 16ms 0ms 00 184 16ms 0ms [ User: symmetricds - Total duration: 453ms - Times executed: 4482 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 453ms - Times executed: 4482 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '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-08-24 18:49:16 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 19:27:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:24:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 3,594 286ms 0ms 1ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 24 01 758 45ms 0ms 02 456 29ms 0ms 03 269 18ms 0ms 04 331 24ms 0ms 05 244 19ms 0ms 06 116 10ms 0ms 07 99 10ms 0ms 08 241 14ms 0ms 09 118 10ms 0ms 10 181 13ms 0ms 11 131 12ms 0ms 12 214 15ms 0ms 13 36 5ms 0ms 14 33 4ms 0ms 15 39 5ms 0ms 16 36 6ms 0ms 17 33 4ms 0ms 18 36 4ms 0ms 19 39 5ms 0ms 20 33 5ms 0ms 21 43 4ms 0ms 22 36 4ms 0ms 23 36 5ms 0ms 00 36 4ms 0ms [ User: symmetricds - Total duration: 286ms - Times executed: 3594 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 286ms - Times executed: 3594 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105904379', '9287889', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105905404', '9288175', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105905490', '9288285', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
Date: 2019-08-24 01:20:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 15:29:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:20:43 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 4ms 92ms 40ms 24 972ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 01 1 92ms 92ms 02 1 88ms 88ms 03 1 83ms 83ms 04 1 89ms 89ms 05 1 85ms 85ms 06 1 82ms 82ms 07 1 81ms 81ms 08 1 61ms 61ms 09 1 50ms 50ms 10 1 46ms 46ms 11 1 40ms 40ms 12 1 31ms 31ms 13 1 27ms 27ms 14 1 21ms 21ms 15 1 21ms 21ms 16 1 15ms 15ms 17 1 12ms 12ms 18 1 8ms 8ms 19 1 6ms 6ms 20 1 5ms 5ms 21 1 4ms 4ms 22 1 5ms 5ms 23 1 4ms 4ms 00 1 5ms 5ms [ User: symmetricds - Total duration: 972ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 972ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-08-24 00:00:00 Duration: 92ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:00:00 Duration: 89ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 01:00:00 Duration: 88ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 22ms 51ms 34ms 292 10s156ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 01 13 443ms 34ms 02 12 406ms 33ms 03 12 425ms 35ms 04 12 415ms 34ms 05 12 410ms 34ms 06 12 429ms 35ms 07 13 462ms 35ms 08 12 411ms 34ms 09 12 412ms 34ms 10 12 422ms 35ms 11 12 404ms 33ms 12 12 410ms 34ms 13 13 454ms 34ms 14 12 412ms 34ms 15 12 436ms 36ms 16 12 428ms 35ms 17 12 415ms 34ms 18 12 432ms 36ms 19 13 449ms 34ms 20 12 425ms 35ms 21 12 401ms 33ms 22 12 436ms 36ms 23 12 413ms 34ms 00 12 394ms 32ms [ User: librenms - Total duration: 10s156ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s156ms - Times executed: 292 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-08-24 21:55:11 Duration: 51ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-24 16:30:11 Duration: 50ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-24 14:30:10 Duration: 43ms Database: postgres User: librenms Remote: [local] Application: psql
3 9ms 30ms 16ms 49 809ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 01 3 46ms 15ms 02 2 28ms 14ms 03 2 42ms 21ms 04 2 45ms 22ms 05 2 29ms 14ms 06 2 31ms 15ms 07 2 42ms 21ms 08 2 34ms 17ms 09 2 31ms 15ms 10 2 38ms 19ms 11 2 35ms 17ms 12 2 38ms 19ms 13 2 27ms 13ms 14 2 29ms 14ms 15 2 29ms 14ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 29ms 14ms 19 2 33ms 16ms 20 2 27ms 13ms 21 2 29ms 14ms 22 2 36ms 18ms 23 2 29ms 14ms 00 2 33ms 16ms [ User: pharmisight - Total duration: 809ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 809ms - Times executed: 49 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-08-24 03:00:00 Duration: 30ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:00:00 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:00:00 Duration: 24ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 152ms 15ms 225 3s569ms 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 Aug 24 01 19 122ms 6ms 02 19 112ms 5ms 03 19 114ms 6ms 04 19 155ms 8ms 05 19 202ms 10ms 06 18 112ms 6ms 07 18 116ms 6ms 08 18 424ms 23ms 09 12 145ms 12ms 10 11 205ms 18ms 11 10 161ms 16ms 12 9 315ms 35ms 13 7 383ms 54ms 14 6 313ms 52ms 15 5 205ms 41ms 16 4 131ms 32ms 17 3 85ms 28ms 18 2 66ms 33ms 19 2 63ms 31ms 20 1 39ms 39ms 21 1 21ms 21ms 22 1 19ms 19ms 23 1 23ms 23ms 00 1 25ms 25ms [ User: symmetricds - Total duration: 3s569ms - Times executed: 225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s569ms - Times executed: 225 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105877747' AND '105882747' AND create_time < '2019-08-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105877747' AND '105882747' 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 '105871450' AND '105876450' AND create_time < '2019-08-23 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450' 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 '105865090' AND '105870090' AND create_time < '2019-08-23 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105865090' AND '105870090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-24 13:00:00 Duration: 152ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 12:00:00 Duration: 150ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 11:00:00 Duration: 124ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3ms 11ms 6ms 178 1s109ms 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 #5
Day Hour Count Duration Avg duration Aug 24 01 114 704ms 6ms 02 3 17ms 5ms 03 4 22ms 5ms 04 3 17ms 5ms 05 3 17ms 5ms 06 3 17ms 5ms 07 3 22ms 7ms 08 3 17ms 5ms 09 3 17ms 5ms 10 3 28ms 9ms 11 3 17ms 5ms 12 3 17ms 5ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 17ms 8ms 20 2 13ms 6ms 21 8 39ms 4ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 826ms - Times executed: 133 ]
[ User: pharmisight - Total duration: 282ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s109ms - Times executed: 178 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_trigger' 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-08-24 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 00:00:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:05:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 9ms 5ms 190 1s128ms 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 Aug 24 01 8 49ms 6ms 02 8 46ms 5ms 03 8 39ms 4ms 04 8 46ms 5ms 05 8 56ms 7ms 06 8 51ms 6ms 07 8 55ms 6ms 08 8 42ms 5ms 09 8 48ms 6ms 10 8 45ms 5ms 11 8 48ms 6ms 12 8 41ms 5ms 13 8 51ms 6ms 14 8 39ms 4ms 15 8 47ms 5ms 16 8 48ms 6ms 17 8 44ms 5ms 18 8 50ms 6ms 19 8 49ms 6ms 20 8 39ms 4ms 21 6 37ms 6ms 22 8 45ms 5ms 23 8 50ms 6ms 00 8 53ms 6ms [ User: symmetricds - Total duration: 1s128ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s128ms - Times executed: 190 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '21597176', "total_memory_bytes" = '259522560', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 06:28:49', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '506564336', "total_memory_bytes" = '1211105280', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 05:10:21', "last_restart_time" = '2019-08-20 01:25:09.822', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '18635424', "total_memory_bytes" = '264765440', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-24 22:03:49', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-08-24 06:29:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:10:51 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:04:55 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 23ms 5ms 205 1s208ms 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 #7
Day Hour Count Duration Avg duration Aug 24 01 19 96ms 5ms 02 19 94ms 4ms 03 18 85ms 4ms 04 18 115ms 6ms 05 18 87ms 4ms 06 18 84ms 4ms 07 18 84ms 4ms 08 12 58ms 4ms 09 11 47ms 4ms 10 10 42ms 4ms 11 9 35ms 3ms 12 7 64ms 9ms 13 6 102ms 17ms 14 5 66ms 13ms 15 4 46ms 11ms 16 3 27ms 9ms 17 2 22ms 11ms 18 2 13ms 6ms 19 1 6ms 6ms 20 1 5ms 5ms 21 1 5ms 5ms 22 1 5ms 5ms 23 1 5ms 5ms 00 1 5ms 5ms [ User: symmetricds - Total duration: 1s208ms - Times executed: 205 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s208ms - Times executed: 205 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105871450' AND '105876450' AND data_id < '105905262' AND create_time < '2019-08-23 11:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105871450' AND '105876450');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105886453' AND '105891453' AND data_id < '105905262' AND create_time < '2019-08-23 11:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105886453' AND '105891453');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105887749' AND '105892749' AND data_id < '105905363' AND create_time < '2019-08-23 12:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105887749' AND '105892749');
Date: 2019-08-24 11:00:00 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 11:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 12:00:00 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1ms 12ms 4ms 202 870ms 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 #8
Day Hour Count Duration Avg duration Aug 24 01 12 50ms 4ms 02 11 43ms 3ms 03 10 39ms 3ms 04 11 51ms 4ms 05 11 47ms 4ms 06 8 36ms 4ms 07 11 51ms 4ms 08 12 63ms 5ms 09 9 37ms 4ms 10 6 24ms 4ms 11 10 42ms 4ms 12 12 42ms 3ms 13 7 22ms 3ms 14 5 27ms 5ms 15 7 34ms 4ms 16 6 29ms 4ms 17 7 26ms 3ms 18 6 27ms 4ms 19 7 36ms 5ms 20 8 32ms 4ms 21 10 36ms 3ms 22 6 24ms 4ms 23 6 24ms 4ms 00 4 15ms 3ms [ User: symmetricds - Total duration: 870ms - Times executed: 202 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 870ms - Times executed: 202 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 07:21:09 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:06:15 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:40:07 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 3ms 1ms 683 987ms 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 #9
Day Hour Count Duration Avg duration Aug 24 01 47 63ms 1ms 02 26 38ms 1ms 03 26 38ms 1ms 04 28 40ms 1ms 05 28 40ms 1ms 06 26 38ms 1ms 07 26 38ms 1ms 08 30 42ms 1ms 09 27 38ms 1ms 10 25 35ms 1ms 11 29 42ms 1ms 12 28 40ms 1ms 13 24 33ms 1ms 14 29 39ms 1ms 15 29 41ms 1ms 16 28 39ms 1ms 17 29 39ms 1ms 18 28 40ms 1ms 19 28 42ms 1ms 20 26 39ms 1ms 21 27 39ms 1ms 22 30 46ms 1ms 23 29 43ms 1ms 00 30 43ms 1ms [ User: symmetricds - Total duration: 987ms - Times executed: 683 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 987ms - Times executed: 683 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 11:46:12 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:15:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:33:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 4ms 0ms 922 885ms 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 #10
Day Hour Count Duration Avg duration Aug 24 01 64 58ms 0ms 02 36 33ms 0ms 03 36 33ms 0ms 04 36 33ms 0ms 05 37 35ms 0ms 06 38 36ms 0ms 07 36 34ms 0ms 08 41 41ms 1ms 09 36 34ms 0ms 10 37 35ms 0ms 11 40 37ms 0ms 12 42 39ms 0ms 13 34 32ms 0ms 14 36 34ms 0ms 15 39 38ms 0ms 16 40 40ms 1ms 17 38 36ms 0ms 18 34 32ms 0ms 19 37 35ms 0ms 20 34 31ms 0ms 21 36 33ms 0ms 22 41 43ms 1ms 23 37 35ms 0ms 00 37 35ms 0ms [ User: symmetricds - Total duration: 885ms - Times executed: 922 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 885ms - Times executed: 922 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 8 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-24 21:37:18 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 07:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:11:17 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 11ms 0ms 1,329 971ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 24 01 361 221ms 0ms 02 176 103ms 0ms 03 118 70ms 0ms 04 146 94ms 0ms 05 104 76ms 0ms 06 40 58ms 1ms 07 33 32ms 0ms 08 101 76ms 0ms 09 41 37ms 0ms 10 74 67ms 0ms 11 46 65ms 1ms 12 89 68ms 0ms [ User: pharmisight - Total duration: 971ms - Times executed: 1329 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 971ms - Times executed: 1329 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005990917', '2019-08-24 05:36:47', 'MORGANG', '2019-08-24 05:00:01.535', '79754', '24', '31237090426138010');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005986083', '2019-08-24 09:31:54', 'KNIGHTMA', '2019-08-24 09:00:01.551', '134351', '576', '150505230149081642');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005986083', '2019-08-24 11:08:33', 'KNIGHTMA', '2019-08-24 10:20:01.472', '70870', '24', '150505230149083752');
Date: 2019-08-24 05:00:01 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 09:00:01 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 10:20:01 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 9ms 0ms 17,197 10s13ms 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 #12
Day Hour Count Duration Avg duration Aug 24 01 717 423ms 0ms 02 716 422ms 0ms 03 716 421ms 0ms 04 718 420ms 0ms 05 716 420ms 0ms 06 716 429ms 0ms 07 716 413ms 0ms 08 718 419ms 0ms 09 716 408ms 0ms 10 716 418ms 0ms 11 718 421ms 0ms 12 716 410ms 0ms 13 716 412ms 0ms 14 716 418ms 0ms 15 718 406ms 0ms 16 716 416ms 0ms 17 716 419ms 0ms 18 716 423ms 0ms 19 718 425ms 0ms 20 716 417ms 0ms 21 716 419ms 0ms 22 718 407ms 0ms 23 716 409ms 0ms 00 716 409ms 0ms [ User: symmetricds - Total duration: 10s13ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s13ms - 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-08-24 18:55:57 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:40:26 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:55:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 2ms 0ms 6,664 760ms 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 #13
Day Hour Count Duration Avg duration Aug 24 01 248 28ms 0ms 02 278 31ms 0ms 03 282 31ms 0ms 04 287 33ms 0ms 05 282 32ms 0ms 06 287 32ms 0ms 07 287 33ms 0ms 08 280 30ms 0ms 09 283 33ms 0ms 10 285 31ms 0ms 11 282 33ms 0ms 12 275 30ms 0ms 13 279 30ms 0ms 14 284 31ms 0ms 15 280 32ms 0ms 16 280 30ms 0ms 17 283 31ms 0ms 18 281 31ms 0ms 19 288 33ms 0ms 20 275 30ms 0ms 21 268 32ms 0ms 22 262 31ms 0ms 23 264 29ms 0ms 00 264 31ms 0ms [ User: symmetricds - Total duration: 760ms - Times executed: 6664 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 760ms - Times executed: 6664 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-08-24 03:43:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 14:32:13 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:14:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 3ms 0ms 4,482 453ms 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 #14
Day Hour Count Duration Avg duration Aug 24 01 190 22ms 0ms 02 189 19ms 0ms 03 189 20ms 0ms 04 190 19ms 0ms 05 190 20ms 0ms 06 189 20ms 0ms 07 188 19ms 0ms 08 190 18ms 0ms 09 188 19ms 0ms 10 189 19ms 0ms 11 190 19ms 0ms 12 190 20ms 0ms 13 184 17ms 0ms 14 184 17ms 0ms 15 184 18ms 0ms 16 184 17ms 0ms 17 184 17ms 0ms 18 184 16ms 0ms 19 184 19ms 0ms 20 184 18ms 0ms 21 186 16ms 0ms 22 184 19ms 0ms 23 184 16ms 0ms 00 184 16ms 0ms [ User: symmetricds - Total duration: 453ms - Times executed: 4482 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 453ms - Times executed: 4482 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '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-08-24 18:49:16 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 19:27:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:24:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 3,594 286ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 01 758 45ms 0ms 02 456 29ms 0ms 03 269 18ms 0ms 04 331 24ms 0ms 05 244 19ms 0ms 06 116 10ms 0ms 07 99 10ms 0ms 08 241 14ms 0ms 09 118 10ms 0ms 10 181 13ms 0ms 11 131 12ms 0ms 12 214 15ms 0ms 13 36 5ms 0ms 14 33 4ms 0ms 15 39 5ms 0ms 16 36 6ms 0ms 17 33 4ms 0ms 18 36 4ms 0ms 19 39 5ms 0ms 20 33 5ms 0ms 21 43 4ms 0ms 22 36 4ms 0ms 23 36 5ms 0ms 00 36 4ms 0ms [ User: symmetricds - Total duration: 286ms - Times executed: 3594 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 286ms - Times executed: 3594 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105904379', '9287889', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105905404', '9288175', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('105905490', '9288285', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
Date: 2019-08-24 01:20:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 15:29:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:20:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 4ms 0ms 44,884 2s498ms 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 #16
Day Hour Count Duration Avg duration Aug 24 01 2,748 130ms 0ms 02 1,832 91ms 0ms 03 1,832 91ms 0ms 04 1,832 99ms 0ms 05 1,832 106ms 0ms 06 1,832 106ms 0ms 07 1,832 103ms 0ms 08 1,832 105ms 0ms 09 1,832 105ms 0ms 10 1,832 103ms 0ms 11 1,832 109ms 0ms 12 1,832 100ms 0ms 13 1,832 102ms 0ms 14 1,832 105ms 0ms 15 1,832 102ms 0ms 16 1,832 105ms 0ms 17 1,832 109ms 0ms 18 1,832 105ms 0ms 19 1,832 102ms 0ms 20 1,832 101ms 0ms 21 1,832 95ms 0ms 22 1,832 108ms 0ms 23 1,832 99ms 0ms 00 1,832 107ms 0ms [ User: pharmisight - Total duration: 2s498ms - Times executed: 44884 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s498ms - Times executed: 44884 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3095' 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 = '32969224' 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 = '3232' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-24 13:00:00 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 05:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 17,362 957ms 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 #17
Day Hour Count Duration Avg duration Aug 24 01 726 39ms 0ms 02 726 40ms 0ms 03 726 40ms 0ms 04 728 40ms 0ms 05 726 39ms 0ms 06 726 40ms 0ms 07 724 40ms 0ms 08 728 39ms 0ms 09 724 39ms 0ms 10 726 39ms 0ms 11 728 39ms 0ms 12 726 39ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 722 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 39ms 0ms [ User: symmetricds - Total duration: 957ms - Times executed: 17362 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 957ms - Times executed: 17362 ]
-
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 = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-08-24 02:15:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 18:04:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 06:20:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 50,568 2s784ms 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 Aug 24 01 3,096 145ms 0ms 02 2,064 100ms 0ms 03 2,064 100ms 0ms 04 2,064 110ms 0ms 05 2,064 119ms 0ms 06 2,064 119ms 0ms 07 2,064 115ms 0ms 08 2,064 117ms 0ms 09 2,064 118ms 0ms 10 2,064 115ms 0ms 11 2,064 122ms 0ms 12 2,064 111ms 0ms 13 2,064 114ms 0ms 14 2,064 113ms 0ms 15 2,064 114ms 0ms 16 2,064 118ms 0ms 17 2,064 122ms 0ms 18 2,064 117ms 0ms 19 2,064 114ms 0ms 20 2,064 113ms 0ms 21 2,064 105ms 0ms 22 2,064 121ms 0ms 23 2,064 111ms 0ms 00 2,064 119ms 0ms [ User: pharmisight - Total duration: 2s784ms - Times executed: 50568 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s784ms - Times executed: 50568 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3131' 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 = '3012' 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 = '3082' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-24 15:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 03:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 22:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 3ms 0ms 25,228 1s342ms 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 #19
Day Hour Count Duration Avg duration Aug 24 01 1,126 56ms 0ms 02 1,051 54ms 0ms 03 1,051 57ms 0ms 04 1,054 53ms 0ms 05 1,052 56ms 0ms 06 1,051 55ms 0ms 07 1,050 55ms 0ms 08 1,054 56ms 0ms 09 1,050 54ms 0ms 10 1,051 56ms 0ms 11 1,054 54ms 0ms 12 1,052 53ms 0ms 13 1,044 53ms 0ms 14 1,044 56ms 0ms 15 1,046 53ms 0ms 16 1,044 56ms 0ms 17 1,044 54ms 0ms 18 1,044 54ms 0ms 19 1,046 59ms 0ms 20 1,044 57ms 0ms 21 1,042 57ms 0ms 22 1,046 57ms 0ms 23 1,044 57ms 0ms 00 1,044 59ms 0ms [ User: symmetricds - Total duration: 1s342ms - Times executed: 25228 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s342ms - Times executed: 25228 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-08-24 18:55:26 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 20:12:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 21:13:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 6,665 348ms 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 #20
Day Hour Count Duration Avg duration Aug 24 01 249 14ms 0ms 02 278 13ms 0ms 03 282 14ms 0ms 04 287 14ms 0ms 05 282 15ms 0ms 06 287 15ms 0ms 07 287 16ms 0ms 08 280 14ms 0ms 09 283 14ms 0ms 10 285 14ms 0ms 11 282 14ms 0ms 12 275 14ms 0ms 13 279 14ms 0ms 14 284 14ms 0ms 15 280 13ms 0ms 16 280 14ms 0ms 17 283 14ms 0ms 18 281 14ms 0ms 19 288 15ms 0ms 20 275 14ms 0ms 21 268 14ms 0ms 22 262 13ms 0ms 23 264 14ms 0ms 00 264 14ms 0ms [ User: symmetricds - Total duration: 348ms - Times executed: 6665 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 348ms - Times executed: 6665 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '3' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-08-24 06:57:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 23:31:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-24 04:52:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,392,721 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 24 17 1 - FATAL: no pg_hba.conf entry for host "94.23.27.140", user "postgres", database "postgres", SSL on
Date: 2019-08-24 16:27:39 Database: postgres Application: [unknown] User: postgres Remote: 94.23.27.140 Code:
2 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 24 17 1 - FATAL: no pg_hba.conf entry for host "94.23.27.140", user "postgres", database "postgres", SSL off
Date: 2019-08-24 16:27:39 Database: postgres Application: [unknown] User: postgres Remote: 94.23.27.140 Code: