pgBadger-
Global information
- Generated on Mon May 20 00:00:25 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,353,217 log entries in 22s
- Log start from 2019-05-19 00:00:00 to 2019-05-19 23:59:58
-
Overview
Global Stats
- 177 Number of unique normalized queries
- 1,133,411 Number of queries
- 49s432ms Total query duration
- 2019-05-19 00:00:00 First query
- 2019-05-19 23:59:58 Last query
- 1,641 queries/s at 2019-05-19 00:00:00 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 37 Total number of automatic vacuums
- 68 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,224 Total number of sessions
- 1 sessions at 2019-05-19 18:48:02 Session peak
- 10d1h23m49s Total duration of sessions
- 6m30s Average duration of sessions
- 509 Average queries per session
- 22ms Average queries duration per session
- 2,224 Total number of connections
- 5 connections/s at 2019-05-19 00:30:19 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,641 queries/s Query Peak
- 2019-05-19 00:00:00 Date
SELECT Traffic
Key values
- 1,540 queries/s Query Peak
- 2019-05-19 00:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 244 queries/s Query Peak
- 2019-05-19 09:18:49 Date
Queries duration
Key values
- 49s432ms Total query duration
Prepared queries ratio
Key values
- 1.64 Ratio of bind vs prepare
- 165.22 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 19 00 55,796 0ms 34ms 0ms 66ms 156ms 1s15ms 01 46,040 0ms 19ms 0ms 46ms 62ms 167ms 02 46,200 0ms 25ms 0ms 48ms 61ms 192ms 03 46,257 0ms 24ms 0ms 56ms 68ms 178ms 04 46,206 0ms 44ms 0ms 58ms 65ms 201ms 05 46,640 0ms 45ms 0ms 49ms 58ms 170ms 06 47,412 0ms 22ms 0ms 61ms 98ms 186ms 07 47,892 0ms 19ms 0ms 52ms 88ms 186ms 08 47,498 0ms 17ms 0ms 53ms 105ms 176ms 09 47,732 0ms 19ms 0ms 54ms 109ms 184ms 10 47,366 0ms 18ms 0ms 53ms 78ms 176ms 11 47,501 0ms 22ms 0ms 55ms 114ms 175ms 12 46,811 0ms 22ms 0ms 54ms 71ms 173ms 13 46,705 0ms 15ms 0ms 57ms 70ms 152ms 14 46,593 0ms 18ms 0ms 51ms 75ms 151ms 15 46,665 0ms 19ms 0ms 50ms 59ms 153ms 16 46,664 0ms 16ms 0ms 54ms 68ms 144ms 17 46,548 0ms 15ms 0ms 51ms 66ms 150ms 18 46,612 0ms 14ms 0ms 53ms 65ms 151ms 19 46,773 0ms 18ms 0ms 54ms 68ms 164ms 20 47,350 0ms 20ms 0ms 50ms 57ms 417ms 21 46,767 0ms 20ms 0ms 52ms 54ms 147ms 22 46,533 0ms 15ms 0ms 47ms 54ms 152ms 23 46,850 0ms 16ms 0ms 44ms 51ms 157ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 19 00 22,278 0 0ms 24ms 36ms 371ms 01 16,412 0 0ms 23ms 33ms 116ms 02 16,508 0 0ms 24ms 36ms 107ms 03 16,510 0 0ms 23ms 33ms 120ms 04 16,505 0 0ms 25ms 37ms 129ms 05 16,507 0 0ms 18ms 29ms 140ms 06 16,814 0 0ms 19ms 36ms 142ms 07 17,087 0 0ms 21ms 32ms 136ms 08 16,961 0 0ms 18ms 33ms 135ms 09 17,036 0 0ms 20ms 34ms 142ms 10 16,864 0 0ms 19ms 39ms 144ms 11 16,947 0 0ms 18ms 37ms 140ms 12 16,624 0 0ms 20ms 32ms 128ms 13 16,529 0 0ms 19ms 38ms 129ms 14 16,503 0 0ms 19ms 31ms 129ms 15 16,527 0 0ms 18ms 30ms 129ms 16 16,526 0 0ms 18ms 32ms 129ms 17 16,487 0 0ms 17ms 35ms 134ms 18 16,512 0 0ms 19ms 32ms 126ms 19 16,594 0 0ms 19ms 37ms 136ms 20 17,058 0 0ms 25ms 28ms 129ms 21 16,578 0 0ms 28ms 31ms 128ms 22 16,483 0 0ms 19ms 31ms 132ms 23 16,618 0 0ms 22ms 32ms 128ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 19 00 331 834 80 0 0ms 6ms 10ms 15ms 01 88 54 81 0 0ms 1ms 6ms 7ms 02 88 54 81 0 0ms 1ms 6ms 7ms 03 88 51 81 0 0ms 1ms 6ms 7ms 04 88 54 81 0 0ms 1ms 6ms 7ms 05 88 52 81 0 0ms 0ms 4ms 7ms 06 510 56 81 0 0ms 1ms 6ms 29ms 07 494 56 81 0 0ms 1ms 6ms 26ms 08 446 54 81 0 0ms 1ms 6ms 20ms 09 610 55 82 0 0ms 1ms 5ms 24ms 10 377 54 80 0 0ms 1ms 4ms 24ms 11 438 55 82 0 0ms 1ms 7ms 17ms 12 105 52 81 0 0ms 1ms 4ms 8ms 13 88 51 80 0 0ms 0ms 5ms 7ms 14 88 51 81 0 0ms 1ms 4ms 7ms 15 88 50 82 0 0ms 0ms 1ms 7ms 16 88 51 80 0 0ms 1ms 7ms 7ms 17 88 50 82 0 0ms 0ms 4ms 7ms 18 88 49 81 0 0ms 0ms 3ms 7ms 19 97 60 80 0 0ms 1ms 5ms 7ms 20 160 98 116 0 0ms 0ms 5ms 8ms 21 91 51 82 0 0ms 0ms 5ms 7ms 22 91 52 80 0 0ms 0ms 2ms 7ms 23 94 52 81 0 0ms 0ms 4ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 19 00 32,367 55,760 1.72 88.42% 01 29,785 46,004 1.54 107.72% 02 29,964 46,164 1.54 107.90% 03 29,932 46,221 1.54 107.70% 04 29,823 46,170 1.55 107.39% 05 28,090 46,604 1.66 100.43% 06 28,358 47,376 1.67 98.71% 07 28,529 47,856 1.68 98.11% 08 28,313 47,462 1.68 98.26% 09 28,231 47,696 1.69 97.18% 10 28,318 47,330 1.67 98.80% 11 28,458 47,465 1.67 98.81% 12 28,229 46,775 1.66 100.37% 13 28,158 46,669 1.66 100.54% 14 28,274 46,557 1.65 101.18% 15 28,374 46,629 1.64 101.40% 16 28,304 46,628 1.65 101.14% 17 28,173 46,512 1.65 100.92% 18 28,228 46,576 1.65 100.99% 19 28,393 46,737 1.65 101.10% 20 28,378 47,314 1.67 98.94% 21 28,397 46,731 1.65 101.19% 22 27,897 46,497 1.67 99.92% 23 28,216 46,814 1.66 100.29% Day Hour Count Average / Second May 19 00 94 0.03/s 01 118 0.03/s 02 116 0.03/s 03 117 0.03/s 04 117 0.03/s 05 86 0.02/s 06 87 0.02/s 07 87 0.02/s 08 88 0.02/s 09 86 0.02/s 10 87 0.02/s 11 88 0.02/s 12 86 0.02/s 13 87 0.02/s 14 89 0.02/s 15 89 0.02/s 16 90 0.03/s 17 87 0.02/s 18 89 0.02/s 19 88 0.02/s 20 89 0.02/s 21 89 0.02/s 22 85 0.02/s 23 85 0.02/s Day Hour Count Average Duration May 19 00 94 7m3s 01 118 5m9s 02 116 5m4s 03 117 5m9s 04 117 5m9s 05 86 6m46s 06 87 6m59s 07 87 6m42s 08 88 6m41s 09 86 7m20s 10 87 6m42s 11 88 7m2s 12 86 6m44s 13 87 6m59s 14 89 6m59s 15 89 6m44s 16 90 6m37s 17 87 6m48s 18 89 6m46s 19 88 6m47s 20 89 6m55s 21 89 6m36s 22 85 6m51s 23 85 7m25s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2019-05-19 00:30:19 Date
Connections per database
Key values
- pharmisight Main Database
- 2,224 connections Total
Connections per user
Key values
- pharmisight Main User
- 2,224 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-05-19 18:48:02 Date
Histogram of session times
Key values
- 1,710 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,224 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 2,224 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,224 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 380 buffers Checkpoint Peak
- 2019-05-19 07:03:26 Date
- 38.108 seconds Highest write time
- 0.015 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-05-19 06:17:52 Date
Checkpoints distance
Key values
- 1.91 Mo Distance Peak
- 2019-05-19 07:03:26 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 19 00 1,464 146.871s 0.016s 146.954s 01 604 60.607s 0.021s 60.703s 02 606 60.7s 0.019s 60.785s 03 592 59.398s 0.018s 59.495s 04 621 62.316s 0.023s 62.405s 05 485 48.668s 0.019s 48.763s 06 673 67.538s 0.018s 67.628s 07 937 93.986s 0.015s 94.065s 08 632 63.406s 0.02s 63.49s 09 803 80.558s 0.032s 80.655s 10 612 61.407s 0.029s 61.503s 11 652 65.415s 0.017s 65.5s 12 785 78.676s 0.016s 78.763s 13 458 45.959s 0.019s 46.049s 14 583 58.509s 0.016s 58.594s 15 535 53.689s 0.015s 53.778s 16 429 43.048s 0.019s 43.137s 17 591 59.314s 0.016s 59.393s 18 484 48.564s 0.016s 48.645s 19 566 56.796s 0.014s 56.877s 20 563 56.488s 0.014s 56.554s 21 512 51.287s 0.011s 51.343s 22 497 49.864s 0.012s 49.933s 23 438 43.954s 0.011s 44.018s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 19 00 0 0 1 379 0.002s 0s 01 0 0 0 313 0.003s 0s 02 0 0 0 309 0.002s 0s 03 0 0 0 310 0.003s 0s 04 0 0 0 321 0.008s 0s 05 0 0 0 307 0.002s 0s 06 0 0 1 316 0.002s 0s 07 0 0 0 327 0.002s 0s 08 0 0 0 323 0.003s 0s 09 0 0 0 328 0.014s 0s 10 0 0 0 308 0.008s 0s 11 0 0 0 324 0.002s 0s 12 0 0 1 327 0.003s 0s 13 0 0 0 300 0.002s 0s 14 0 0 0 302 0.002s 0s 15 0 0 0 297 0.002s 0s 16 0 0 0 283 0.002s 0s 17 0 0 0 307 0.002s 0s 18 0 0 0 302 0.003s 0s 19 0 0 0 305 0.003s 0s 20 0 0 0 255 0.002s 0s 21 0 0 1 226 0.002s 0s 22 0 0 0 231 0.003s 0.001s 23 0 0 0 223 0.002s 0s Day Hour Count Avg time (sec) May 19 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 19 00 594.58 kB 727.33 kB 01 169.58 kB 611.25 kB 02 111.58 kB 257.67 kB 03 155.50 kB 407.83 kB 04 168.83 kB 428.00 kB 05 111.92 kB 208.33 kB 06 194.67 kB 385.25 kB 07 266.58 kB 664.00 kB 08 218.00 kB 464.67 kB 09 284.00 kB 591.83 kB 10 206.58 kB 422.33 kB 11 200.17 kB 421.67 kB 12 209.25 kB 558.58 kB 13 119.08 kB 293.17 kB 14 149.17 kB 387.92 kB 15 138.58 kB 225.83 kB 16 111.67 kB 220.42 kB 17 171.83 kB 354.83 kB 18 124.33 kB 255.58 kB 19 156.92 kB 426.75 kB 20 228.30 kB 513.00 kB 21 172.62 kB 326.50 kB 22 161.10 kB 419.90 kB 23 166.10 kB 323.10 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 May 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (16) Main table analyzed (database pharmisight)
- 68 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_incoming_batch 13 pharmisight.public.sym_data_event 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_data 7 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_delays 1 Total 68 Vacuums per table
Key values
- public.sym_outgoing_batch (8) Main table vacuumed on database pharmisight
- 37 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_event 4 4 pharmisight.public.sym_data 3 3 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.public.item_codes 1 1 Total 37 31 Tuples removed per table
Key values
- public.sym_data_event (1028) Main table with removed tuples on database pharmisight
- 5297 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 4 4 1028 1384 pharmisight.pg_catalog.pg_statistic 3 3 1014 0 pharmisight.public.sym_outgoing_batch 8 8 965 260 pharmisight.public.sym_incoming_batch 6 6 945 0 pharmisight.public.item_codes 1 1 373 0 pharmisight.public.sym_data 3 3 354 2912 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 306 0 Total 37 31 5,297 4,556 Pages removed per table
Key values
- public.sym_data (2912) Main table with removed pages on database pharmisight
- 4556 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 3 3 354 2912 pharmisight.public.sym_data_event 4 4 1028 1384 pharmisight.public.sym_outgoing_batch 8 8 965 260 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.pg_catalog.pg_statistic 3 3 1014 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_incoming_batch 6 6 945 0 pharmisight.public.item_codes 1 1 373 0 Total 37 31 5,297 4,556 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 19 00 6 8 01 1 3 02 1 1 03 2 2 04 3 3 05 0 3 06 1 3 07 2 2 08 2 2 09 1 5 10 0 1 11 0 3 12 4 2 13 2 2 14 1 3 15 1 2 16 0 2 17 2 4 18 1 2 19 1 2 20 1 5 21 4 2 22 1 3 23 0 3 - 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
- 405,468 Total read queries
- 280,024 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,133,411 Requests
- 49s432ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,073,369 Requests
User Request type Count Duration pharmisight Total 103,608 6s750ms DELETE 35 3ms INSERT 43 7ms OTHERS 3,498 133ms SELECT 99,414 6s580ms TCL 574 17ms UPDATE 44 8ms symmetricds Total 1,073,369 44s154ms DELETE 2,012 665ms INSERT 4,857 1s349ms OTHERS 462,930 7s556ms SELECT 319,698 26s969ms TCL 281,766 5s531ms UPDATE 2,106 2s81ms tony Total 900 281ms SELECT 900 281ms Duration by user
Key values
- 44s154ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 103,608 6s750ms DELETE 35 3ms INSERT 43 7ms OTHERS 3,498 133ms SELECT 99,414 6s580ms TCL 574 17ms UPDATE 44 8ms symmetricds Total 1,073,369 44s154ms DELETE 2,012 665ms INSERT 4,857 1s349ms OTHERS 462,930 7s556ms SELECT 319,698 26s969ms TCL 281,766 5s531ms UPDATE 2,106 2s81ms tony Total 900 281ms SELECT 900 281ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,176,977 Requests
- 50s905ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,130,611 Requests
- 49s82ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-05-19 20:56:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,130,350 0-1ms duration
Slowest individual queries
Rank Duration Query 1 45ms 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-05-19 05:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 44ms DELETE FROM sym_data WHERE data_id BETWEEN '101179574' AND '101179884' AND create_time < '2019-05-18 04:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179574' AND '101179884') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179574' AND '101179884' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 34ms DELETE FROM sym_data WHERE data_id BETWEEN '101179526' AND '101179836' AND create_time < '2019-05-18 00:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179526' AND '101179836') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179526' AND '101179836' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 25ms 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-05-19 02:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 24ms UPDATE "public"."patients" SET "caloriesday" = '168' WHERE "patient_id" = '108050260';[ Date: 2019-05-19 00:27:44 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 24ms DELETE FROM sym_data WHERE data_id BETWEEN '101179562' AND '101179872' AND create_time < '2019-05-18 03:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179562' AND '101179872') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179562' AND '101179872' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 22ms DELETE FROM sym_data WHERE data_id BETWEEN '101179598' AND '101179908' AND create_time < '2019-05-18 06:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179598' AND '101179908') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179598' AND '101179908' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 22ms 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-05-19 11:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 22ms DELETE FROM sym_data WHERE data_id BETWEEN '101179670' AND '101179980' AND create_time < '2019-05-18 12:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179670' AND '101179980') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179670' AND '101179980' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 20ms DELETE FROM sym_data WHERE data_id BETWEEN '101179658' AND '101179968' AND create_time < '2019-05-18 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179658' AND '101179968') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179658' AND '101179968' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 20ms 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-05-19 21:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 20ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2019-05-19 00:00:00' AND '2019-05-20 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2019-05-19 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 19ms DELETE FROM sym_data WHERE data_id BETWEEN '101179538' AND '101179848' AND create_time < '2019-05-18 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179538' AND '101179848') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179538' AND '101179848' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 19ms 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-05-19 00:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 19ms DELETE FROM sym_data WHERE data_id BETWEEN '101179610' AND '101179920' AND create_time < '2019-05-18 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179610' AND '101179920') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179610' AND '101179920' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 19ms DELETE FROM sym_data WHERE data_id BETWEEN '101179550' AND '101179860' AND create_time < '2019-05-18 02:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179550' AND '101179860') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179550' AND '101179860' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 19ms DELETE FROM sym_data WHERE data_id BETWEEN '101179634' AND '101179944' AND create_time < '2019-05-18 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179634' AND '101179944') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '101179634' AND '101179944' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-19 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 19ms 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-05-19 15:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 18ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_9_0_, this_.routeNumber AS routeNum2_9_0_, this_.roundDeliveryDate AS roundDel3_9_0_, this_.distributionPoint AS distribu4_9_0_, this_.fullyPicked AS fullyPic5_9_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_9_0_, this_.causeOfDelay AS causeOfD7_9_0_, this_.pharmacy100CheckTime AS pharmacy8_9_0_, this_.linesHeldBack AS linesHel9_9_0_, this_.packTime100 AS packTim10_9_0_, this_.replenish AS repleni11_9_0_, this_.comment AS comment12_9_0_, this_.pickDateTime AS pickDat13_9_0_, this_.failedTargetPickTime AS failedT14_9_0_, this_.actualPaperworkCompleteTime AS actualP15_9_0_, this_.changedPickDateTime AS changed16_9_0_, this_.manuallyChangedPickTime AS manuall17_9_0_, this_.CREATED AS CREATED18_9_0_, this_.UPDATED AS UPDATED19_9_0_, this_.note AS note20_9_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = '2019-05-19' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-05-19 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 18ms 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-05-19 04:00:00 - Database: pharmisight - User: pharmisight - 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 9s758ms 17,197 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 19 01 717 412ms 0ms 02 714 411ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 427ms 0ms 06 716 400ms 0ms 07 716 407ms 0ms 08 718 405ms 0ms 09 716 384ms 0ms 10 716 408ms 0ms 11 718 410ms 0ms 12 716 398ms 0ms 13 716 398ms 0ms 14 718 400ms 0ms 15 716 398ms 0ms 16 716 407ms 0ms 17 718 407ms 0ms 18 716 409ms 0ms 19 716 402ms 0ms 20 718 413ms 0ms 21 716 404ms 0ms 22 716 407ms 0ms 23 716 401ms 0ms 00 718 398ms 0ms [ User: symmetricds - Total duration: 9s758ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s758ms - 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-05-19 17:35:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:44:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:31:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s967ms 425,788 0ms 2ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 01 18,266 297ms 0ms 02 17,419 281ms 0ms 03 17,460 282ms 0ms 04 17,494 281ms 0ms 05 17,464 285ms 0ms 06 17,762 289ms 0ms 07 17,772 290ms 0ms 08 17,901 290ms 0ms 09 17,772 289ms 0ms 10 17,771 291ms 0ms 11 17,793 292ms 0ms 12 17,787 293ms 0ms 13 17,780 289ms 0ms 14 17,788 290ms 0ms 15 17,736 290ms 0ms 16 17,766 291ms 0ms 17 17,763 292ms 0ms 18 17,723 291ms 0ms 19 17,746 287ms 0ms 20 17,774 289ms 0ms 21 17,746 295ms 0ms 22 17,790 294ms 0ms 23 17,708 295ms 0ms 00 17,807 292ms 0ms [ User: symmetricds - Total duration: 6s920ms - Times executed: 424647 ]
[ User: pharmisight - Total duration: 47ms - Times executed: 1141 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s967ms - Times executed: 425788 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-05-19 16:07:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:48:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:37:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s443ms 135,568 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 19 01 6,541 505ms 0ms 02 5,508 160ms 0ms 03 5,520 161ms 0ms 04 5,531 182ms 0ms 05 5,522 167ms 0ms 06 5,621 163ms 0ms 07 5,634 175ms 0ms 08 5,681 182ms 0ms 09 5,636 164ms 0ms 10 5,634 185ms 0ms 11 5,644 166ms 0ms 12 5,639 185ms 0ms 13 5,631 178ms 0ms 14 5,629 162ms 0ms 15 5,610 193ms 0ms 16 5,618 159ms 0ms 17 5,620 176ms 0ms 18 5,604 160ms 0ms 19 5,611 162ms 0ms 20 5,627 177ms 0ms 21 5,625 165ms 0ms 22 5,630 179ms 0ms 23 5,607 162ms 0ms 00 5,645 164ms 0ms [ User: symmetricds - Total duration: 4s429ms - Times executed: 135288 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s443ms - Times executed: 135568 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-05-19 14:47:31 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:50:50 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:56:58 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s494ms 49,367 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 19 01 3,024 129ms 0ms 02 1,991 86ms 0ms 03 2,016 91ms 0ms 04 2,016 91ms 0ms 05 2,016 100ms 0ms 06 2,016 104ms 0ms 07 2,016 106ms 0ms 08 2,016 103ms 0ms 09 2,016 102ms 0ms 10 2,016 105ms 0ms 11 2,016 109ms 0ms 12 2,016 104ms 0ms 13 2,016 104ms 0ms 14 2,016 103ms 0ms 15 2,016 105ms 0ms 16 2,016 103ms 0ms 17 2,016 105ms 0ms 18 2,016 107ms 0ms 19 2,016 103ms 0ms 20 2,016 106ms 0ms 21 2,016 107ms 0ms 22 2,016 103ms 0ms 23 2,016 104ms 0ms 00 2,016 103ms 0ms [ User: pharmisight - Total duration: 2s494ms - Times executed: 49367 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s494ms - Times executed: 49367 ]
-
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 = '2934' 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 = '3684' 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 = '2938' ORDER BY itemcodes0_.code ASC;
Date: 2019-05-19 12:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 2s228ms 43,732 0ms 2ms 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 #5
Day Hour Count Duration Avg duration May 19 01 2,679 116ms 0ms 02 1,761 78ms 0ms 03 1,786 82ms 0ms 04 1,786 81ms 0ms 05 1,786 90ms 0ms 06 1,786 92ms 0ms 07 1,786 94ms 0ms 08 1,786 92ms 0ms 09 1,786 91ms 0ms 10 1,786 93ms 0ms 11 1,786 97ms 0ms 12 1,786 93ms 0ms 13 1,786 93ms 0ms 14 1,786 91ms 0ms 15 1,786 93ms 0ms 16 1,786 94ms 0ms 17 1,786 92ms 0ms 18 1,786 95ms 0ms 19 1,786 92ms 0ms 20 1,786 95ms 0ms 21 1,786 95ms 0ms 22 1,786 92ms 0ms 23 1,786 93ms 0ms 00 1,786 92ms 0ms [ User: pharmisight - Total duration: 2s228ms - Times executed: 43732 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s228ms - Times executed: 43732 ]
-
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 = '32994971' 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 = '33074121' 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 = '2979' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-19 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s783ms 155,440 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 19 01 7,779 84ms 0ms 02 6,317 72ms 0ms 03 6,337 71ms 0ms 04 6,338 72ms 0ms 05 6,333 73ms 0ms 06 6,432 71ms 0ms 07 6,448 72ms 0ms 08 6,486 73ms 0ms 09 6,444 74ms 0ms 10 6,449 73ms 0ms 11 6,447 74ms 0ms 12 6,454 75ms 0ms 13 6,439 74ms 0ms 14 6,436 72ms 0ms 15 6,421 74ms 0ms 16 6,433 73ms 0ms 17 6,429 73ms 0ms 18 6,421 73ms 0ms 19 6,421 73ms 0ms 20 6,435 81ms 0ms 21 6,427 72ms 0ms 22 6,448 75ms 0ms 23 6,411 72ms 0ms 00 6,455 76ms 0ms [ User: symmetricds - Total duration: 1s783ms - Times executed: 155440 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s783ms - Times executed: 155440 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-05-19 19:48:35 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:32:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 14:45:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s260ms 25,210 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 May 19 01 1,142 59ms 0ms 02 1,042 50ms 0ms 03 1,044 51ms 0ms 04 1,046 49ms 0ms 05 1,044 50ms 0ms 06 1,044 50ms 0ms 07 1,048 50ms 0ms 08 1,052 54ms 0ms 09 1,050 53ms 0ms 10 1,050 51ms 0ms 11 1,050 52ms 0ms 12 1,048 52ms 0ms 13 1,046 57ms 0ms 14 1,046 51ms 0ms 15 1,044 52ms 0ms 16 1,044 50ms 0ms 17 1,046 52ms 0ms 18 1,044 52ms 0ms 19 1,044 50ms 0ms 20 1,048 52ms 0ms 21 1,044 54ms 0ms 22 1,046 52ms 0ms 23 1,046 52ms 0ms 00 1,052 51ms 0ms [ User: symmetricds - Total duration: 1s260ms - Times executed: 25210 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s260ms - Times executed: 25210 ]
-
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-05-19 12:18:31 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 20:11:36 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 07:26:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s155ms 780 1ms 2ms 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 #8
Day Hour Count Duration Avg duration May 19 01 39 57ms 1ms 02 55 80ms 1ms 03 56 82ms 1ms 04 55 80ms 1ms 05 56 82ms 1ms 06 26 38ms 1ms 07 27 39ms 1ms 08 27 40ms 1ms 09 27 40ms 1ms 10 26 40ms 1ms 11 28 41ms 1ms 12 28 40ms 1ms 13 26 38ms 1ms 14 27 40ms 1ms 15 28 42ms 1ms 16 29 42ms 1ms 17 27 39ms 1ms 18 26 38ms 1ms 19 30 45ms 1ms 20 29 42ms 1ms 21 28 41ms 1ms 22 28 41ms 1ms 23 26 38ms 1ms 00 26 38ms 1ms [ User: symmetricds - Total duration: 1s155ms - Times executed: 780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s155ms - Times executed: 780 ]
-
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-05-19 09:56:29 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:19:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:17:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s80ms 158 4ms 13ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 01 101 610ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 13ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 3 22ms 7ms 08 3 22ms 7ms 09 3 22ms 7ms 10 3 22ms 7ms 11 3 22ms 7ms 12 3 27ms 9ms 13 3 27ms 9ms 14 2 18ms 9ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 18ms 9ms 18 2 18ms 9ms 19 2 18ms 9ms 20 3 26ms 8ms 21 2 18ms 9ms 22 3 27ms 9ms 23 3 27ms 9ms 00 3 27ms 9ms [ User: symmetricds - Total duration: 864ms - Times executed: 113 ]
[ User: pharmisight - Total duration: 215ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s80ms - Times executed: 158 ]
-
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_transform_table' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-05-19 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 996ms 1,002 0ms 5ms 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 #10
Day Hour Count Duration Avg duration May 19 01 48 48ms 1ms 02 67 66ms 0ms 03 68 68ms 1ms 04 67 66ms 0ms 05 66 66ms 1ms 06 37 35ms 0ms 07 36 34ms 0ms 08 37 36ms 0ms 09 36 35ms 0ms 10 33 32ms 0ms 11 38 36ms 0ms 12 38 37ms 0ms 13 33 36ms 1ms 14 34 33ms 0ms 15 36 35ms 0ms 16 37 36ms 0ms 17 39 37ms 0ms 18 35 34ms 0ms 19 36 35ms 0ms 20 38 37ms 0ms 21 36 34ms 0ms 22 38 37ms 0ms 23 35 34ms 0ms 00 34 35ms 1ms [ User: symmetricds - Total duration: 996ms - Times executed: 1002 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 996ms - Times executed: 1002 ]
-
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);
-
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-05-19 12:03:56 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:35:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:53:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 927ms 191 0ms 7ms 4ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 19 01 8 45ms 5ms 02 8 45ms 5ms 03 8 45ms 5ms 04 8 45ms 5ms 05 8 50ms 6ms 06 8 40ms 5ms 07 8 46ms 5ms 08 8 36ms 4ms 09 8 33ms 4ms 10 8 38ms 4ms 11 8 27ms 3ms 12 8 37ms 4ms 13 8 36ms 4ms 14 8 35ms 4ms 15 8 41ms 5ms 16 8 35ms 4ms 17 8 41ms 5ms 18 8 35ms 4ms 19 8 35ms 4ms 20 8 41ms 5ms 21 7 35ms 5ms 22 8 30ms 3ms 23 8 28ms 3ms 00 8 36ms 4ms [ User: symmetricds - Total duration: 927ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 927ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '82242328', "total_memory_bytes" = '437256192', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 08:58:17', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '71472584', "total_memory_bytes" = '437256192', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 19:58:19', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '379714880', "total_memory_bytes" = '770179072', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 23:09:12', "last_restart_time" = '2019-05-14 22:11:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-05-19 08:56:48 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:56:53 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:09:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 912ms 17,294 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 19 01 720 37ms 0ms 02 718 37ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 38ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 38ms 0ms 09 720 37ms 0ms 10 720 38ms 0ms 11 722 38ms 0ms 12 720 37ms 0ms 13 720 37ms 0ms 14 722 38ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 722 38ms 0ms 18 720 38ms 0ms 19 720 38ms 0ms 20 722 38ms 0ms 21 722 38ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 912ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-05-19 04:02:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:15:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:57:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 892ms 135,569 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 01 6,542 42ms 0ms 02 5,508 35ms 0ms 03 5,520 35ms 0ms 04 5,531 37ms 0ms 05 5,522 36ms 0ms 06 5,621 36ms 0ms 07 5,634 36ms 0ms 08 5,681 36ms 0ms 09 5,636 37ms 0ms 10 5,634 37ms 0ms 11 5,644 37ms 0ms 12 5,639 37ms 0ms 13 5,631 36ms 0ms 14 5,629 36ms 0ms 15 5,610 36ms 0ms 16 5,618 36ms 0ms 17 5,620 38ms 0ms 18 5,604 37ms 0ms 19 5,611 38ms 0ms 20 5,627 37ms 0ms 21 5,625 36ms 0ms 22 5,630 36ms 0ms 23 5,607 36ms 0ms 00 5,645 36ms 0ms [ User: symmetricds - Total duration: 890ms - Times executed: 135288 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 281 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - Times executed: 135569 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-05-19 16:25:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:57:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 08:22:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 809ms 182 3ms 15ms 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 #14
Day Hour Count Duration Avg duration May 19 01 10 46ms 4ms 02 8 32ms 4ms 03 9 43ms 4ms 04 7 28ms 4ms 05 11 43ms 3ms 06 8 32ms 4ms 07 9 38ms 4ms 08 8 34ms 4ms 09 8 34ms 4ms 10 8 34ms 4ms 11 9 53ms 5ms 12 8 33ms 4ms 13 7 28ms 4ms 14 8 49ms 6ms 15 6 25ms 4ms 16 6 26ms 4ms 17 8 33ms 4ms 18 5 23ms 4ms 19 6 24ms 4ms 20 7 28ms 4ms 21 7 31ms 4ms 22 8 33ms 4ms 23 4 17ms 4ms 00 7 30ms 4ms [ User: symmetricds - Total duration: 809ms - Times executed: 182 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 809ms - Times executed: 182 ]
-
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-05-19 13:03:31 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:48:30 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:48:26 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 787ms 49 12ms 45ms 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 #15
Day Hour Count Duration Avg duration May 19 01 3 49ms 16ms 02 2 31ms 15ms 03 2 39ms 19ms 04 2 31ms 15ms 05 2 33ms 16ms 06 2 59ms 29ms 07 2 29ms 14ms 08 2 29ms 14ms 09 2 27ms 13ms 10 2 28ms 14ms 11 2 32ms 16ms 12 2 36ms 18ms 13 2 29ms 14ms 14 2 28ms 14ms 15 2 28ms 14ms 16 2 32ms 16ms 17 2 27ms 13ms 18 2 29ms 14ms 19 2 26ms 13ms 20 2 32ms 16ms 21 2 31ms 15ms 22 2 33ms 16ms 23 2 28ms 14ms 00 2 29ms 14ms [ User: pharmisight - Total duration: 787ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 787ms - 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-05-19 05:20:00 Duration: 45ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:00:00 Duration: 25ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 11:20:00 Duration: 22ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 746ms 789 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 19 01 40 37ms 0ms 02 56 54ms 0ms 03 57 55ms 0ms 04 56 54ms 0ms 05 54 51ms 0ms 06 27 25ms 0ms 07 27 24ms 0ms 08 27 25ms 0ms 09 28 26ms 0ms 10 26 23ms 0ms 11 28 26ms 0ms 12 28 26ms 0ms 13 26 24ms 0ms 14 27 25ms 0ms 15 29 26ms 0ms 16 29 27ms 0ms 17 30 28ms 0ms 18 27 24ms 0ms 19 29 27ms 0ms 20 29 26ms 0ms 21 28 26ms 0ms 22 29 27ms 0ms 23 26 24ms 0ms 00 26 24ms 0ms [ User: symmetricds - Total duration: 746ms - Times executed: 789 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 746ms - Times executed: 789 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-19 07:17:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:03:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 20:05:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 717ms 6,597 0ms 1ms 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 #17
Day Hour Count Duration Avg duration May 19 01 256 27ms 0ms 02 237 26ms 0ms 03 239 26ms 0ms 04 240 27ms 0ms 05 239 26ms 0ms 06 286 30ms 0ms 07 286 30ms 0ms 08 297 31ms 0ms 09 280 29ms 0ms 10 280 29ms 0ms 11 279 30ms 0ms 12 284 31ms 0ms 13 287 30ms 0ms 14 287 30ms 0ms 15 282 29ms 0ms 16 284 30ms 0ms 17 283 31ms 0ms 18 279 29ms 0ms 19 283 32ms 0ms 20 283 30ms 0ms 21 277 30ms 0ms 22 289 30ms 0ms 23 276 32ms 0ms 00 284 30ms 0ms [ User: symmetricds - Total duration: 717ms - Times executed: 6597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 717ms - Times executed: 6597 ]
-
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-05-19 22:12:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:50:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:31:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 702ms 781 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 01 40 36ms 0ms 02 55 50ms 0ms 03 56 50ms 0ms 04 53 47ms 0ms 05 54 48ms 0ms 06 27 24ms 0ms 07 27 24ms 0ms 08 27 24ms 0ms 09 28 25ms 0ms 10 26 23ms 0ms 11 28 25ms 0ms 12 28 25ms 0ms 13 26 23ms 0ms 14 27 24ms 0ms 15 28 25ms 0ms 16 29 25ms 0ms 17 28 25ms 0ms 18 27 24ms 0ms 19 29 25ms 0ms 20 29 26ms 0ms 21 28 25ms 0ms 22 29 25ms 0ms 23 26 23ms 0ms 00 26 23ms 0ms [ User: symmetricds - Total duration: 702ms - Times executed: 781 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 702ms - Times executed: 781 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-19 17:57:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:41:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 03:53:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 592ms 2,352 0ms 9ms 0ms INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT ?, ?, ?, ?, ?, ?, ? WHERE ( SELECT DISTINCT ? FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = ?) IS NULL);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 19 07 419 109ms 0ms 08 403 99ms 0ms 09 355 83ms 0ms 10 519 122ms 0ms 11 286 74ms 0ms 12 347 76ms 0ms 13 16 6ms 0ms 22 2 4ms 2ms 23 2 4ms 2ms 00 3 10ms 3ms [ User: symmetricds - Total duration: 592ms - Times executed: 2352 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 592ms - Times executed: 2352 ]
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '150505230142165844', '5005581029', '2019-05-19 07:26:53', 'BERLANR', '2019-05-19 06:40:00.047', '79786', '4' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '150505230142165844') IS NULL);
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '150505230142191454', '5005581572', '2019-05-19 11:11:50', 'RYBAKJ', '2019-05-19 10:20:01.76', '63284', '8' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '150505230142191454') IS NULL);
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '31237090385087005', '5005581015', '2019-05-19 09:57:56', 'KRYSINSKID', '2019-05-19 09:20:01.471', '64273', '30' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '31237090385087005') IS NULL);
Date: 2019-05-19 06:38:47 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:18:49 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:18:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 534ms 96 0ms 7ms 5ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 01 4 22ms 5ms 02 4 26ms 6ms 03 4 21ms 5ms 04 4 26ms 6ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 17ms 4ms 08 4 26ms 6ms 09 4 25ms 6ms 10 4 14ms 3ms 11 4 15ms 3ms 12 4 19ms 4ms 13 4 26ms 6ms 14 4 25ms 6ms 15 4 24ms 6ms 16 4 20ms 5ms 17 4 27ms 6ms 18 4 19ms 4ms 19 4 18ms 4ms 20 4 19ms 4ms 21 4 18ms 4ms 22 4 25ms 6ms 23 4 20ms 5ms 00 4 24ms 6ms [ User: symmetricds - Total duration: 534ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 534ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '124253496', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 09:47:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '105735968', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 11:02:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '120418728', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 12:47:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-05-19 09:47:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 11:02:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:47:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 425,788 6s967ms 0ms 2ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 19 01 18,266 297ms 0ms 02 17,419 281ms 0ms 03 17,460 282ms 0ms 04 17,494 281ms 0ms 05 17,464 285ms 0ms 06 17,762 289ms 0ms 07 17,772 290ms 0ms 08 17,901 290ms 0ms 09 17,772 289ms 0ms 10 17,771 291ms 0ms 11 17,793 292ms 0ms 12 17,787 293ms 0ms 13 17,780 289ms 0ms 14 17,788 290ms 0ms 15 17,736 290ms 0ms 16 17,766 291ms 0ms 17 17,763 292ms 0ms 18 17,723 291ms 0ms 19 17,746 287ms 0ms 20 17,774 289ms 0ms 21 17,746 295ms 0ms 22 17,790 294ms 0ms 23 17,708 295ms 0ms 00 17,807 292ms 0ms [ User: symmetricds - Total duration: 6s920ms - Times executed: 424647 ]
[ User: pharmisight - Total duration: 47ms - Times executed: 1141 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s967ms - Times executed: 425788 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-05-19 16:07:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:48:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:37:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 155,440 1s783ms 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 01 7,779 84ms 0ms 02 6,317 72ms 0ms 03 6,337 71ms 0ms 04 6,338 72ms 0ms 05 6,333 73ms 0ms 06 6,432 71ms 0ms 07 6,448 72ms 0ms 08 6,486 73ms 0ms 09 6,444 74ms 0ms 10 6,449 73ms 0ms 11 6,447 74ms 0ms 12 6,454 75ms 0ms 13 6,439 74ms 0ms 14 6,436 72ms 0ms 15 6,421 74ms 0ms 16 6,433 73ms 0ms 17 6,429 73ms 0ms 18 6,421 73ms 0ms 19 6,421 73ms 0ms 20 6,435 81ms 0ms 21 6,427 72ms 0ms 22 6,448 75ms 0ms 23 6,411 72ms 0ms 00 6,455 76ms 0ms [ User: symmetricds - Total duration: 1s783ms - Times executed: 155440 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s783ms - Times executed: 155440 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-05-19 19:48:35 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:32:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 14:45:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 135,569 892ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 19 01 6,542 42ms 0ms 02 5,508 35ms 0ms 03 5,520 35ms 0ms 04 5,531 37ms 0ms 05 5,522 36ms 0ms 06 5,621 36ms 0ms 07 5,634 36ms 0ms 08 5,681 36ms 0ms 09 5,636 37ms 0ms 10 5,634 37ms 0ms 11 5,644 37ms 0ms 12 5,639 37ms 0ms 13 5,631 36ms 0ms 14 5,629 36ms 0ms 15 5,610 36ms 0ms 16 5,618 36ms 0ms 17 5,620 38ms 0ms 18 5,604 37ms 0ms 19 5,611 38ms 0ms 20 5,627 37ms 0ms 21 5,625 36ms 0ms 22 5,630 36ms 0ms 23 5,607 36ms 0ms 00 5,645 36ms 0ms [ User: symmetricds - Total duration: 890ms - Times executed: 135288 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 281 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - Times executed: 135569 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-05-19 16:25:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:57:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 08:22:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 135,568 4s443ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 19 01 6,541 505ms 0ms 02 5,508 160ms 0ms 03 5,520 161ms 0ms 04 5,531 182ms 0ms 05 5,522 167ms 0ms 06 5,621 163ms 0ms 07 5,634 175ms 0ms 08 5,681 182ms 0ms 09 5,636 164ms 0ms 10 5,634 185ms 0ms 11 5,644 166ms 0ms 12 5,639 185ms 0ms 13 5,631 178ms 0ms 14 5,629 162ms 0ms 15 5,610 193ms 0ms 16 5,618 159ms 0ms 17 5,620 176ms 0ms 18 5,604 160ms 0ms 19 5,611 162ms 0ms 20 5,627 177ms 0ms 21 5,625 165ms 0ms 22 5,630 179ms 0ms 23 5,607 162ms 0ms 00 5,645 164ms 0ms [ User: symmetricds - Total duration: 4s429ms - Times executed: 135288 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s443ms - Times executed: 135568 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-05-19 14:47:31 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:50:50 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:56:58 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 49,367 2s494ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 19 01 3,024 129ms 0ms 02 1,991 86ms 0ms 03 2,016 91ms 0ms 04 2,016 91ms 0ms 05 2,016 100ms 0ms 06 2,016 104ms 0ms 07 2,016 106ms 0ms 08 2,016 103ms 0ms 09 2,016 102ms 0ms 10 2,016 105ms 0ms 11 2,016 109ms 0ms 12 2,016 104ms 0ms 13 2,016 104ms 0ms 14 2,016 103ms 0ms 15 2,016 105ms 0ms 16 2,016 103ms 0ms 17 2,016 105ms 0ms 18 2,016 107ms 0ms 19 2,016 103ms 0ms 20 2,016 106ms 0ms 21 2,016 107ms 0ms 22 2,016 103ms 0ms 23 2,016 104ms 0ms 00 2,016 103ms 0ms [ User: pharmisight - Total duration: 2s494ms - Times executed: 49367 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s494ms - Times executed: 49367 ]
-
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 = '2934' 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 = '3684' 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 = '2938' ORDER BY itemcodes0_.code ASC;
Date: 2019-05-19 12:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 43,732 2s228ms 0ms 2ms 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 May 19 01 2,679 116ms 0ms 02 1,761 78ms 0ms 03 1,786 82ms 0ms 04 1,786 81ms 0ms 05 1,786 90ms 0ms 06 1,786 92ms 0ms 07 1,786 94ms 0ms 08 1,786 92ms 0ms 09 1,786 91ms 0ms 10 1,786 93ms 0ms 11 1,786 97ms 0ms 12 1,786 93ms 0ms 13 1,786 93ms 0ms 14 1,786 91ms 0ms 15 1,786 93ms 0ms 16 1,786 94ms 0ms 17 1,786 92ms 0ms 18 1,786 95ms 0ms 19 1,786 92ms 0ms 20 1,786 95ms 0ms 21 1,786 95ms 0ms 22 1,786 92ms 0ms 23 1,786 93ms 0ms 00 1,786 92ms 0ms [ User: pharmisight - Total duration: 2s228ms - Times executed: 43732 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s228ms - Times executed: 43732 ]
-
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 = '32994971' 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 = '33074121' 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 = '2979' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-19 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,210 1s260ms 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 May 19 01 1,142 59ms 0ms 02 1,042 50ms 0ms 03 1,044 51ms 0ms 04 1,046 49ms 0ms 05 1,044 50ms 0ms 06 1,044 50ms 0ms 07 1,048 50ms 0ms 08 1,052 54ms 0ms 09 1,050 53ms 0ms 10 1,050 51ms 0ms 11 1,050 52ms 0ms 12 1,048 52ms 0ms 13 1,046 57ms 0ms 14 1,046 51ms 0ms 15 1,044 52ms 0ms 16 1,044 50ms 0ms 17 1,046 52ms 0ms 18 1,044 52ms 0ms 19 1,044 50ms 0ms 20 1,048 52ms 0ms 21 1,044 54ms 0ms 22 1,046 52ms 0ms 23 1,046 52ms 0ms 00 1,052 51ms 0ms [ User: symmetricds - Total duration: 1s260ms - Times executed: 25210 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s260ms - Times executed: 25210 ]
-
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-05-19 12:18:31 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 20:11:36 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 07:26:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,294 912ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, 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 May 19 01 720 37ms 0ms 02 718 37ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 38ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 38ms 0ms 09 720 37ms 0ms 10 720 38ms 0ms 11 722 38ms 0ms 12 720 37ms 0ms 13 720 37ms 0ms 14 722 38ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 722 38ms 0ms 18 720 38ms 0ms 19 720 38ms 0ms 20 722 38ms 0ms 21 722 38ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 912ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-05-19 04:02:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:15:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:57:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,266 477ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 01 718 19ms 0ms 02 720 19ms 0ms 03 718 19ms 0ms 04 720 19ms 0ms 05 720 19ms 0ms 06 720 20ms 0ms 07 718 19ms 0ms 08 720 20ms 0ms 09 720 19ms 0ms 10 718 19ms 0ms 11 720 20ms 0ms 12 720 20ms 0ms 13 720 19ms 0ms 14 718 20ms 0ms 15 720 19ms 0ms 16 720 19ms 0ms 17 720 19ms 0ms 18 718 20ms 0ms 19 720 20ms 0ms 20 720 19ms 0ms 21 718 20ms 0ms 22 720 20ms 0ms 23 720 19ms 0ms 00 720 19ms 0ms [ User: symmetricds - Total duration: 477ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 477ms - 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-05-19 11:22:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:54:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 21:03:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,197 9s758ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 19 01 717 412ms 0ms 02 714 411ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 427ms 0ms 06 716 400ms 0ms 07 716 407ms 0ms 08 718 405ms 0ms 09 716 384ms 0ms 10 716 408ms 0ms 11 718 410ms 0ms 12 716 398ms 0ms 13 716 398ms 0ms 14 718 400ms 0ms 15 716 398ms 0ms 16 716 407ms 0ms 17 718 407ms 0ms 18 716 409ms 0ms 19 716 402ms 0ms 20 718 413ms 0ms 21 716 404ms 0ms 22 716 407ms 0ms 23 716 401ms 0ms 00 718 398ms 0ms [ User: symmetricds - Total duration: 9s758ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s758ms - 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-05-19 17:35:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:44:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:31:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,130 117ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 19 01 380 4ms 0ms 02 379 4ms 0ms 03 380 4ms 0ms 04 381 5ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 381 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 381 4ms 0ms 12 380 4ms 0ms 13 380 4ms 0ms 14 381 4ms 0ms 15 380 4ms 0ms 16 380 4ms 0ms 17 381 4ms 0ms 18 380 4ms 0ms 19 380 4ms 0ms 20 381 4ms 0ms 21 384 4ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms 00 381 4ms 0ms [ User: symmetricds - Total duration: 117ms - Times executed: 9130 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 117ms - Times executed: 9130 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-05-19 21:40:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 03:57:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,129 158ms 0ms 4ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 19 01 379 6ms 0ms 02 379 6ms 0ms 03 381 6ms 0ms 04 380 6ms 0ms 05 380 6ms 0ms 06 380 6ms 0ms 07 381 10ms 0ms 08 380 6ms 0ms 09 380 6ms 0ms 10 382 6ms 0ms 11 379 6ms 0ms 12 382 6ms 0ms 13 379 6ms 0ms 14 380 6ms 0ms 15 380 6ms 0ms 16 382 6ms 0ms 17 379 6ms 0ms 18 380 6ms 0ms 19 380 6ms 0ms 20 381 6ms 0ms 21 384 6ms 0ms 22 381 6ms 0ms 23 379 6ms 0ms 00 381 6ms 0ms [ User: symmetricds - Total duration: 158ms - Times executed: 9129 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 158ms - Times executed: 9129 ]
-
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-05-19 06:00:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 05:51:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 209ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 01 358 8ms 0ms 02 357 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 359 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 359 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 359 8ms 0ms 15 358 8ms 0ms 16 358 8ms 0ms 17 359 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 359 8ms 0ms 21 358 8ms 0ms 22 358 8ms 0ms 23 358 8ms 0ms 00 359 8ms 0ms [ User: symmetricds - Total duration: 209ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 209ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '101179861' AND data_id <= '151179860' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '101180051' AND data_id <= '151180050' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '101179976' AND data_id <= '151179975' ORDER BY data_id ASC;
Date: 2019-05-19 01:49:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 17:40:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 11:24:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,598 281ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 19 01 358 12ms 0ms 02 357 13ms 0ms 03 358 11ms 0ms 04 359 11ms 0ms 05 358 11ms 0ms 06 358 11ms 0ms 07 358 11ms 0ms 08 359 11ms 0ms 09 358 11ms 0ms 10 358 11ms 0ms 11 359 11ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 359 11ms 0ms 15 358 11ms 0ms 16 358 11ms 0ms 17 359 11ms 0ms 18 358 11ms 0ms 19 358 11ms 0ms 20 359 11ms 0ms 21 358 11ms 0ms 22 358 11ms 0ms 23 358 11ms 0ms 00 359 11ms 0ms [ User: symmetricds - Total duration: 281ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 281ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '101180103' AND '151180102'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '101179913' AND '151179912'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '101179901' AND '151179900'));
Date: 2019-05-19 20:45:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:11:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 05:07:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,598 305ms 0ms 0ms 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 #15
Day Hour Count Duration Avg duration May 19 01 358 12ms 0ms 02 357 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 359 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 359 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 359 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 359 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 359 13ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 358 13ms 0ms 00 359 12ms 0ms [ User: symmetricds - Total duration: 305ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 305ms - 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-05-19 07:38:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:39:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:02:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,598 405ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 19 01 358 16ms 0ms 02 357 16ms 0ms 03 358 17ms 0ms 04 359 17ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 359 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 359 16ms 0ms 15 358 16ms 0ms 16 358 17ms 0ms 17 359 17ms 0ms 18 358 17ms 0ms 19 358 16ms 0ms 20 359 17ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 16ms 0ms 00 359 16ms 0ms [ User: symmetricds - Total duration: 405ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 405ms - 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-05-19 17:20:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:30:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:56:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,597 717ms 0ms 1ms 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 #17
Day Hour Count Duration Avg duration May 19 01 256 27ms 0ms 02 237 26ms 0ms 03 239 26ms 0ms 04 240 27ms 0ms 05 239 26ms 0ms 06 286 30ms 0ms 07 286 30ms 0ms 08 297 31ms 0ms 09 280 29ms 0ms 10 280 29ms 0ms 11 279 30ms 0ms 12 284 31ms 0ms 13 287 30ms 0ms 14 287 30ms 0ms 15 282 29ms 0ms 16 284 30ms 0ms 17 283 31ms 0ms 18 279 29ms 0ms 19 283 32ms 0ms 20 283 30ms 0ms 21 277 30ms 0ms 22 289 30ms 0ms 23 276 32ms 0ms 00 284 30ms 0ms [ User: symmetricds - Total duration: 717ms - Times executed: 6597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 717ms - Times executed: 6597 ]
-
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-05-19 22:12:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:50:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:31:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,597 295ms 0ms 0ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 01 256 11ms 0ms 02 237 10ms 0ms 03 239 10ms 0ms 04 240 10ms 0ms 05 239 10ms 0ms 06 286 12ms 0ms 07 286 12ms 0ms 08 297 13ms 0ms 09 280 12ms 0ms 10 280 12ms 0ms 11 279 12ms 0ms 12 284 12ms 0ms 13 287 12ms 0ms 14 287 12ms 0ms 15 282 12ms 0ms 16 284 12ms 0ms 17 283 12ms 0ms 18 279 12ms 0ms 19 283 12ms 0ms 20 283 12ms 0ms 21 277 12ms 0ms 22 289 12ms 0ms 23 276 12ms 0ms 00 284 12ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 6597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 6597 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-05-19 17:01:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:07:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 04:35:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,418 439ms 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 May 19 01 184 16ms 0ms 02 184 22ms 0ms 03 184 18ms 0ms 04 184 17ms 0ms 05 184 16ms 0ms 06 184 16ms 0ms 07 184 16ms 0ms 08 184 21ms 0ms 09 184 46ms 0ms 10 184 17ms 0ms 11 184 16ms 0ms 12 184 15ms 0ms 13 184 15ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 15ms 0ms 17 184 20ms 0ms 18 184 15ms 0ms 19 184 15ms 0ms 20 184 15ms 0ms 21 186 17ms 0ms 22 184 17ms 0ms 23 184 14ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 439ms - Times executed: 4418 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 439ms - Times executed: 4418 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '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 = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-05-19 01:17:25 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:08:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:02:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,406 90ms 0ms 0ms 0ms SELECT this_.dlx_barcode AS dlx_barc1_3_0_, this_.ordernumber AS ordernum2_3_0_, this_.pickdatetime AS pickdate3_3_0_, this_.picker AS picker4_3_0_, this_.created AS created5_3_0_, this_.partcode AS partcode6_3_0_, this_.orderqty AS orderqty7_3_0_ FROM dlx_barcodes this_ WHERE this_.dlx_barcode = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 07 253 9ms 0ms 08 447 17ms 0ms 09 402 12ms 0ms 10 486 20ms 0ms 11 296 10ms 0ms 12 374 13ms 0ms 13 87 3ms 0ms 22 6 0ms 0ms 23 11 0ms 0ms 00 44 1ms 0ms [ User: pharmisight - Total duration: 90ms - Times executed: 2406 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 90ms - Times executed: 2406 ]
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385288006';
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385109002';
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385189007';
Date: 2019-05-19 10:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:20:01 Duration: 0ms Database: pharmisight User: pharmisight 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 12ms 45ms 16ms 49 787ms 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 #1
Day Hour Count Duration Avg duration May 19 01 3 49ms 16ms 02 2 31ms 15ms 03 2 39ms 19ms 04 2 31ms 15ms 05 2 33ms 16ms 06 2 59ms 29ms 07 2 29ms 14ms 08 2 29ms 14ms 09 2 27ms 13ms 10 2 28ms 14ms 11 2 32ms 16ms 12 2 36ms 18ms 13 2 29ms 14ms 14 2 28ms 14ms 15 2 28ms 14ms 16 2 32ms 16ms 17 2 27ms 13ms 18 2 29ms 14ms 19 2 26ms 13ms 20 2 32ms 16ms 21 2 31ms 15ms 22 2 33ms 16ms 23 2 28ms 14ms 00 2 29ms 14ms [ User: pharmisight - Total duration: 787ms - Times executed: 49 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 787ms - 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-05-19 05:20:00 Duration: 45ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:00:00 Duration: 25ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 11:20:00 Duration: 22ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4ms 13ms 6ms 158 1s80ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 19 01 101 610ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 13ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 3 22ms 7ms 08 3 22ms 7ms 09 3 22ms 7ms 10 3 22ms 7ms 11 3 22ms 7ms 12 3 27ms 9ms 13 3 27ms 9ms 14 2 18ms 9ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 18ms 9ms 18 2 18ms 9ms 19 2 18ms 9ms 20 3 26ms 8ms 21 2 18ms 9ms 22 3 27ms 9ms 23 3 27ms 9ms 00 3 27ms 9ms [ User: symmetricds - Total duration: 864ms - Times executed: 113 ]
[ User: pharmisight - Total duration: 215ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s80ms - Times executed: 158 ]
-
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_transform_table' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-05-19 00:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 7ms 5ms 96 534ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 19 01 4 22ms 5ms 02 4 26ms 6ms 03 4 21ms 5ms 04 4 26ms 6ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 17ms 4ms 08 4 26ms 6ms 09 4 25ms 6ms 10 4 14ms 3ms 11 4 15ms 3ms 12 4 19ms 4ms 13 4 26ms 6ms 14 4 25ms 6ms 15 4 24ms 6ms 16 4 20ms 5ms 17 4 27ms 6ms 18 4 19ms 4ms 19 4 18ms 4ms 20 4 19ms 4ms 21 4 18ms 4ms 22 4 25ms 6ms 23 4 20ms 5ms 00 4 24ms 6ms [ User: symmetricds - Total duration: 534ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 534ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '124253496', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 09:47:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '105735968', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 11:02:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '120418728', total_memory_bytes = '287834112', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-05-19 12:47:25', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-05-19 09:47:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 11:02:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:47:25 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 7ms 4ms 191 927ms 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 #4
Day Hour Count Duration Avg duration May 19 01 8 45ms 5ms 02 8 45ms 5ms 03 8 45ms 5ms 04 8 45ms 5ms 05 8 50ms 6ms 06 8 40ms 5ms 07 8 46ms 5ms 08 8 36ms 4ms 09 8 33ms 4ms 10 8 38ms 4ms 11 8 27ms 3ms 12 8 37ms 4ms 13 8 36ms 4ms 14 8 35ms 4ms 15 8 41ms 5ms 16 8 35ms 4ms 17 8 41ms 5ms 18 8 35ms 4ms 19 8 35ms 4ms 20 8 41ms 5ms 21 7 35ms 5ms 22 8 30ms 3ms 23 8 28ms 3ms 00 8 36ms 4ms [ User: symmetricds - Total duration: 927ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 927ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '82242328', "total_memory_bytes" = '437256192', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 08:58:17', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '71472584', "total_memory_bytes" = '437256192', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 19:58:19', "last_restart_time" = '2019-05-07 11:12:08.553', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '379714880', "total_memory_bytes" = '770179072', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-19 23:09:12', "last_restart_time" = '2019-05-14 22:11:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-05-19 08:56:48 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:56:53 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:09:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3ms 15ms 4ms 182 809ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 19 01 10 46ms 4ms 02 8 32ms 4ms 03 9 43ms 4ms 04 7 28ms 4ms 05 11 43ms 3ms 06 8 32ms 4ms 07 9 38ms 4ms 08 8 34ms 4ms 09 8 34ms 4ms 10 8 34ms 4ms 11 9 53ms 5ms 12 8 33ms 4ms 13 7 28ms 4ms 14 8 49ms 6ms 15 6 25ms 4ms 16 6 26ms 4ms 17 8 33ms 4ms 18 5 23ms 4ms 19 6 24ms 4ms 20 7 28ms 4ms 21 7 31ms 4ms 22 8 33ms 4ms 23 4 17ms 4ms 00 7 30ms 4ms [ User: symmetricds - Total duration: 809ms - Times executed: 182 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 809ms - Times executed: 182 ]
-
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-05-19 13:03:31 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:48:30 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:48:26 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1ms 2ms 1ms 780 1s155ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 19 01 39 57ms 1ms 02 55 80ms 1ms 03 56 82ms 1ms 04 55 80ms 1ms 05 56 82ms 1ms 06 26 38ms 1ms 07 27 39ms 1ms 08 27 40ms 1ms 09 27 40ms 1ms 10 26 40ms 1ms 11 28 41ms 1ms 12 28 40ms 1ms 13 26 38ms 1ms 14 27 40ms 1ms 15 28 42ms 1ms 16 29 42ms 1ms 17 27 39ms 1ms 18 26 38ms 1ms 19 30 45ms 1ms 20 29 42ms 1ms 21 28 41ms 1ms 22 28 41ms 1ms 23 26 38ms 1ms 00 26 38ms 1ms [ User: symmetricds - Total duration: 1s155ms - Times executed: 780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s155ms - Times executed: 780 ]
-
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-05-19 09:56:29 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:19:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:17:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 5ms 0ms 1,002 996ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 19 01 48 48ms 1ms 02 67 66ms 0ms 03 68 68ms 1ms 04 67 66ms 0ms 05 66 66ms 1ms 06 37 35ms 0ms 07 36 34ms 0ms 08 37 36ms 0ms 09 36 35ms 0ms 10 33 32ms 0ms 11 38 36ms 0ms 12 38 37ms 0ms 13 33 36ms 1ms 14 34 33ms 0ms 15 36 35ms 0ms 16 37 36ms 0ms 17 39 37ms 0ms 18 35 34ms 0ms 19 36 35ms 0ms 20 38 37ms 0ms 21 36 34ms 0ms 22 38 37ms 0ms 23 35 34ms 0ms 00 34 35ms 1ms [ User: symmetricds - Total duration: 996ms - Times executed: 1002 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 996ms - Times executed: 1002 ]
-
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);
-
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-05-19 12:03:56 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 23:35:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 00:53:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 789 746ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 19 01 40 37ms 0ms 02 56 54ms 0ms 03 57 55ms 0ms 04 56 54ms 0ms 05 54 51ms 0ms 06 27 25ms 0ms 07 27 24ms 0ms 08 27 25ms 0ms 09 28 26ms 0ms 10 26 23ms 0ms 11 28 26ms 0ms 12 28 26ms 0ms 13 26 24ms 0ms 14 27 25ms 0ms 15 29 26ms 0ms 16 29 27ms 0ms 17 30 28ms 0ms 18 27 24ms 0ms 19 29 27ms 0ms 20 29 26ms 0ms 21 28 26ms 0ms 22 29 27ms 0ms 23 26 24ms 0ms 00 26 24ms 0ms [ User: symmetricds - Total duration: 746ms - Times executed: 789 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 746ms - Times executed: 789 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-19 07:17:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:03:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 20:05:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 781 702ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 19 01 40 36ms 0ms 02 55 50ms 0ms 03 56 50ms 0ms 04 53 47ms 0ms 05 54 48ms 0ms 06 27 24ms 0ms 07 27 24ms 0ms 08 27 24ms 0ms 09 28 25ms 0ms 10 26 23ms 0ms 11 28 25ms 0ms 12 28 25ms 0ms 13 26 23ms 0ms 14 27 24ms 0ms 15 28 25ms 0ms 16 29 25ms 0ms 17 28 25ms 0ms 18 27 24ms 0ms 19 29 25ms 0ms 20 29 26ms 0ms 21 28 25ms 0ms 22 29 25ms 0ms 23 26 23ms 0ms 00 26 23ms 0ms [ User: symmetricds - Total duration: 702ms - Times executed: 781 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 702ms - Times executed: 781 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-19 17:57:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:41:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 03:53:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 17,197 9s758ms 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 May 19 01 717 412ms 0ms 02 714 411ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 427ms 0ms 06 716 400ms 0ms 07 716 407ms 0ms 08 718 405ms 0ms 09 716 384ms 0ms 10 716 408ms 0ms 11 718 410ms 0ms 12 716 398ms 0ms 13 716 398ms 0ms 14 718 400ms 0ms 15 716 398ms 0ms 16 716 407ms 0ms 17 718 407ms 0ms 18 716 409ms 0ms 19 716 402ms 0ms 20 718 413ms 0ms 21 716 404ms 0ms 22 716 407ms 0ms 23 716 401ms 0ms 00 718 398ms 0ms [ User: symmetricds - Total duration: 9s758ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s758ms - 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-05-19 17:35:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:44:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:31:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 9ms 0ms 2,352 592ms INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT ?, ?, ?, ?, ?, ?, ? WHERE ( SELECT DISTINCT ? FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = ?) IS NULL);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 19 07 419 109ms 0ms 08 403 99ms 0ms 09 355 83ms 0ms 10 519 122ms 0ms 11 286 74ms 0ms 12 347 76ms 0ms 13 16 6ms 0ms 22 2 4ms 2ms 23 2 4ms 2ms 00 3 10ms 3ms [ User: symmetricds - Total duration: 592ms - Times executed: 2352 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 592ms - Times executed: 2352 ]
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '150505230142165844', '5005581029', '2019-05-19 07:26:53', 'BERLANR', '2019-05-19 06:40:00.047', '79786', '4' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '150505230142165844') IS NULL);
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '150505230142191454', '5005581572', '2019-05-19 11:11:50', 'RYBAKJ', '2019-05-19 10:20:01.76', '63284', '8' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '150505230142191454') IS NULL);
-
INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '31237090385087005', '5005581015', '2019-05-19 09:57:56', 'KRYSINSKID', '2019-05-19 09:20:01.471', '64273', '30' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '31237090385087005') IS NULL);
Date: 2019-05-19 06:38:47 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:18:49 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:18:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 1ms 0ms 6,597 717ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 19 01 256 27ms 0ms 02 237 26ms 0ms 03 239 26ms 0ms 04 240 27ms 0ms 05 239 26ms 0ms 06 286 30ms 0ms 07 286 30ms 0ms 08 297 31ms 0ms 09 280 29ms 0ms 10 280 29ms 0ms 11 279 30ms 0ms 12 284 31ms 0ms 13 287 30ms 0ms 14 287 30ms 0ms 15 282 29ms 0ms 16 284 30ms 0ms 17 283 31ms 0ms 18 279 29ms 0ms 19 283 32ms 0ms 20 283 30ms 0ms 21 277 30ms 0ms 22 289 30ms 0ms 23 276 32ms 0ms 00 284 30ms 0ms [ User: symmetricds - Total duration: 717ms - Times executed: 6597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 717ms - Times executed: 6597 ]
-
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-05-19 22:12:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 22:50:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 18:31:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 3ms 0ms 4,418 439ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 19 01 184 16ms 0ms 02 184 22ms 0ms 03 184 18ms 0ms 04 184 17ms 0ms 05 184 16ms 0ms 06 184 16ms 0ms 07 184 16ms 0ms 08 184 21ms 0ms 09 184 46ms 0ms 10 184 17ms 0ms 11 184 16ms 0ms 12 184 15ms 0ms 13 184 15ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 15ms 0ms 17 184 20ms 0ms 18 184 15ms 0ms 19 184 15ms 0ms 20 184 15ms 0ms 21 186 17ms 0ms 22 184 17ms 0ms 23 184 14ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 439ms - Times executed: 4418 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 439ms - Times executed: 4418 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '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 = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-05-19 01:17:25 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:08:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:02:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 1ms 0ms 17,294 912ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 19 01 720 37ms 0ms 02 718 37ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 38ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 38ms 0ms 09 720 37ms 0ms 10 720 38ms 0ms 11 722 38ms 0ms 12 720 37ms 0ms 13 720 37ms 0ms 14 722 38ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 722 38ms 0ms 18 720 38ms 0ms 19 720 38ms 0ms 20 722 38ms 0ms 21 722 38ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 912ms - Times executed: 17294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 17294 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-05-19 04:02:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:15:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 06:57:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 2ms 0ms 43,732 2s228ms 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 #15
Day Hour Count Duration Avg duration May 19 01 2,679 116ms 0ms 02 1,761 78ms 0ms 03 1,786 82ms 0ms 04 1,786 81ms 0ms 05 1,786 90ms 0ms 06 1,786 92ms 0ms 07 1,786 94ms 0ms 08 1,786 92ms 0ms 09 1,786 91ms 0ms 10 1,786 93ms 0ms 11 1,786 97ms 0ms 12 1,786 93ms 0ms 13 1,786 93ms 0ms 14 1,786 91ms 0ms 15 1,786 93ms 0ms 16 1,786 94ms 0ms 17 1,786 92ms 0ms 18 1,786 95ms 0ms 19 1,786 92ms 0ms 20 1,786 95ms 0ms 21 1,786 95ms 0ms 22 1,786 92ms 0ms 23 1,786 93ms 0ms 00 1,786 92ms 0ms [ User: pharmisight - Total duration: 2s228ms - Times executed: 43732 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s228ms - Times executed: 43732 ]
-
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 = '32994971' 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 = '33074121' 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 = '2979' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-19 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 12:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 19:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 49,367 2s494ms 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 #16
Day Hour Count Duration Avg duration May 19 01 3,024 129ms 0ms 02 1,991 86ms 0ms 03 2,016 91ms 0ms 04 2,016 91ms 0ms 05 2,016 100ms 0ms 06 2,016 104ms 0ms 07 2,016 106ms 0ms 08 2,016 103ms 0ms 09 2,016 102ms 0ms 10 2,016 105ms 0ms 11 2,016 109ms 0ms 12 2,016 104ms 0ms 13 2,016 104ms 0ms 14 2,016 103ms 0ms 15 2,016 105ms 0ms 16 2,016 103ms 0ms 17 2,016 105ms 0ms 18 2,016 107ms 0ms 19 2,016 103ms 0ms 20 2,016 106ms 0ms 21 2,016 107ms 0ms 22 2,016 103ms 0ms 23 2,016 104ms 0ms 00 2,016 103ms 0ms [ User: pharmisight - Total duration: 2s494ms - Times executed: 49367 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s494ms - Times executed: 49367 ]
-
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 = '2934' 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 = '3684' 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 = '2938' ORDER BY itemcodes0_.code ASC;
Date: 2019-05-19 12:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 13:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 16:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 3ms 0ms 25,210 1s260ms 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 #17
Day Hour Count Duration Avg duration May 19 01 1,142 59ms 0ms 02 1,042 50ms 0ms 03 1,044 51ms 0ms 04 1,046 49ms 0ms 05 1,044 50ms 0ms 06 1,044 50ms 0ms 07 1,048 50ms 0ms 08 1,052 54ms 0ms 09 1,050 53ms 0ms 10 1,050 51ms 0ms 11 1,050 52ms 0ms 12 1,048 52ms 0ms 13 1,046 57ms 0ms 14 1,046 51ms 0ms 15 1,044 52ms 0ms 16 1,044 50ms 0ms 17 1,046 52ms 0ms 18 1,044 52ms 0ms 19 1,044 50ms 0ms 20 1,048 52ms 0ms 21 1,044 54ms 0ms 22 1,046 52ms 0ms 23 1,046 52ms 0ms 00 1,052 51ms 0ms [ User: symmetricds - Total duration: 1s260ms - Times executed: 25210 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s260ms - Times executed: 25210 ]
-
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-05-19 12:18:31 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 20:11:36 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 07:26:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 8,598 405ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 19 01 358 16ms 0ms 02 357 16ms 0ms 03 358 17ms 0ms 04 359 17ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 359 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 359 16ms 0ms 15 358 16ms 0ms 16 358 17ms 0ms 17 359 17ms 0ms 18 358 17ms 0ms 19 358 16ms 0ms 20 359 17ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 16ms 0ms 00 359 16ms 0ms [ User: symmetricds - Total duration: 405ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 405ms - 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-05-19 17:20:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 02:30:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:56:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 6,597 295ms 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 #19
Day Hour Count Duration Avg duration May 19 01 256 11ms 0ms 02 237 10ms 0ms 03 239 10ms 0ms 04 240 10ms 0ms 05 239 10ms 0ms 06 286 12ms 0ms 07 286 12ms 0ms 08 297 13ms 0ms 09 280 12ms 0ms 10 280 12ms 0ms 11 279 12ms 0ms 12 284 12ms 0ms 13 287 12ms 0ms 14 287 12ms 0ms 15 282 12ms 0ms 16 284 12ms 0ms 17 283 12ms 0ms 18 279 12ms 0ms 19 283 12ms 0ms 20 283 12ms 0ms 21 277 12ms 0ms 22 289 12ms 0ms 23 276 12ms 0ms 00 284 12ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 6597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 6597 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-05-19 17:01:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:07:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 04:35:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 2,406 90ms SELECT this_.dlx_barcode AS dlx_barc1_3_0_, this_.ordernumber AS ordernum2_3_0_, this_.pickdatetime AS pickdate3_3_0_, this_.picker AS picker4_3_0_, this_.created AS created5_3_0_, this_.partcode AS partcode6_3_0_, this_.orderqty AS orderqty7_3_0_ FROM dlx_barcodes this_ WHERE this_.dlx_barcode = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 19 07 253 9ms 0ms 08 447 17ms 0ms 09 402 12ms 0ms 10 486 20ms 0ms 11 296 10ms 0ms 12 374 13ms 0ms 13 87 3ms 0ms 22 6 0ms 0ms 23 11 0ms 0ms 00 44 1ms 0ms [ User: pharmisight - Total duration: 90ms - Times executed: 2406 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 90ms - Times executed: 2406 ]
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385288006';
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385109002';
-
SELECT this_.DLX_BARCODE AS DLX_BARC1_3_0_, this_.orderNumber AS orderNum2_3_0_, this_.pickDateTime AS pickDate3_3_0_, this_.picker AS picker4_3_0_, this_.CREATED AS CREATED5_3_0_, this_.partCode AS partCode6_3_0_, this_.orderQty AS orderQty7_3_0_ FROM DLX_BARCODES this_ WHERE this_.DLX_BARCODE = '31237090385189007';
Date: 2019-05-19 10:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 09:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-19 10:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,352,611 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET