pgBadger-
Global information
- Generated on Mon Mar 11 00:00:23 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,146,164 log entries in 21s
- Log start from 2019-03-10 00:00:00 to 2019-03-10 23:59:59
-
Overview
Global Stats
- 173 Number of unique normalized queries
- 1,075,874 Number of queries
- 45s917ms Total query duration
- 2019-03-10 00:00:00 First query
- 2019-03-10 23:59:59 Last query
- 1,517 queries/s at 2019-03-10 08:40:00 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 40 Total number of automatic vacuums
- 73 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,013 Total number of sessions
- 1 sessions at 2019-03-10 22:16:11 Session peak
- 10d44m18s Total duration of sessions
- 7m10s Average duration of sessions
- 534 Average queries per session
- 22ms Average queries duration per session
- 2,013 Total number of connections
- 5 connections/s at 2019-03-10 00:30:16 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,517 queries/s Query Peak
- 2019-03-10 08:40:00 Date
SELECT Traffic
Key values
- 1,510 queries/s Query Peak
- 2019-03-10 14:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 124 queries/s Query Peak
- 2019-03-10 23:40:08 Date
Queries duration
Key values
- 45s917ms Total query duration
Prepared queries ratio
Key values
- 1.54 Ratio of bind vs prepare
- 170.15 % 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) Mar 10 00 52,663 0ms 18ms 0ms 74ms 89ms 621ms 01 44,212 0ms 24ms 0ms 54ms 66ms 151ms 02 44,182 0ms 18ms 0ms 49ms 63ms 139ms 03 44,199 0ms 30ms 0ms 53ms 68ms 162ms 04 44,278 0ms 18ms 0ms 48ms 65ms 174ms 05 44,144 0ms 15ms 0ms 52ms 62ms 157ms 06 44,173 0ms 12ms 0ms 44ms 68ms 155ms 07 44,297 0ms 14ms 0ms 46ms 62ms 154ms 08 44,218 0ms 18ms 0ms 46ms 65ms 162ms 09 44,185 0ms 12ms 0ms 49ms 71ms 151ms 10 44,266 0ms 13ms 0ms 48ms 64ms 160ms 11 44,360 0ms 14ms 0ms 43ms 64ms 156ms 12 44,208 0ms 14ms 0ms 45ms 70ms 156ms 13 44,391 0ms 13ms 0ms 44ms 55ms 150ms 14 44,745 0ms 12ms 0ms 43ms 53ms 146ms 15 44,733 0ms 18ms 0ms 46ms 47ms 165ms 16 44,693 0ms 13ms 0ms 44ms 47ms 150ms 17 44,629 0ms 14ms 0ms 46ms 50ms 145ms 18 44,548 0ms 12ms 0ms 40ms 44ms 145ms 19 44,625 0ms 14ms 0ms 43ms 60ms 153ms 20 44,979 0ms 29ms 0ms 47ms 63ms 295ms 21 44,870 0ms 15ms 0ms 47ms 53ms 154ms 22 44,686 0ms 22ms 0ms 43ms 48ms 153ms 23 45,590 0ms 13ms 0ms 48ms 56ms 197ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 10 00 18,538 0 0ms 23ms 31ms 508ms 01 14,592 0 0ms 24ms 31ms 51ms 02 14,560 0 0ms 24ms 29ms 56ms 03 14,573 0 0ms 23ms 33ms 49ms 04 14,603 0 0ms 23ms 30ms 53ms 05 14,558 0 0ms 24ms 33ms 48ms 06 14,562 0 0ms 23ms 30ms 56ms 07 14,604 0 0ms 23ms 31ms 40ms 08 14,584 0 0ms 22ms 30ms 50ms 09 14,566 0 0ms 23ms 30ms 56ms 10 14,587 0 0ms 24ms 30ms 53ms 11 14,630 0 0ms 25ms 28ms 52ms 12 14,585 0 0ms 22ms 29ms 54ms 13 14,585 0 0ms 22ms 27ms 51ms 14 14,610 0 0ms 18ms 26ms 47ms 15 14,621 0 0ms 22ms 26ms 36ms 16 14,595 0 0ms 18ms 26ms 32ms 17 14,605 0 0ms 21ms 28ms 36ms 18 14,573 0 0ms 19ms 27ms 34ms 19 14,608 0 0ms 18ms 29ms 48ms 20 14,998 0 0ms 18ms 28ms 145ms 21 14,659 0 0ms 20ms 26ms 70ms 22 14,641 0 0ms 22ms 26ms 35ms 23 14,843 0 0ms 19ms 29ms 74ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 10 00 397 1,396 81 0 0ms 10ms 12ms 21ms 01 88 54 81 0 0ms 1ms 3ms 8ms 02 88 53 83 0 0ms 0ms 3ms 8ms 03 88 54 79 0 0ms 1ms 4ms 13ms 04 88 53 81 0 0ms 0ms 2ms 13ms 05 88 54 81 0 0ms 1ms 3ms 8ms 06 88 54 80 0 0ms 1ms 4ms 8ms 07 88 53 81 0 0ms 0ms 2ms 10ms 08 88 54 81 0 0ms 1ms 3ms 9ms 09 88 53 81 0 0ms 0ms 3ms 10ms 10 88 54 81 0 0ms 1ms 3ms 13ms 11 88 54 81 0 0ms 1ms 3ms 13ms 12 88 53 81 0 0ms 0ms 3ms 9ms 13 88 54 82 0 0ms 0ms 3ms 8ms 14 88 53 81 0 0ms 1ms 3ms 7ms 15 88 54 83 0 0ms 1ms 6ms 7ms 16 88 54 79 0 0ms 1ms 4ms 7ms 17 88 53 82 0 0ms 1ms 4ms 7ms 18 88 54 80 0 0ms 1ms 3ms 7ms 19 80 49 76 0 0ms 0ms 1ms 7ms 20 91 64 99 0 0ms 1ms 3ms 7ms 21 100 65 85 0 0ms 1ms 3ms 7ms 22 88 54 80 0 0ms 1ms 1ms 7ms 23 399 155 85 0 0ms 1ms 5ms 15ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 10 00 33,123 52,627 1.59 98.22% 01 29,766 44,176 1.48 115.12% 02 29,646 44,146 1.49 114.84% 03 29,800 44,163 1.48 115.38% 04 29,894 44,242 1.48 115.51% 05 29,624 44,108 1.49 114.79% 06 29,508 44,137 1.50 114.26% 07 29,830 44,261 1.48 115.21% 08 29,658 44,182 1.49 114.72% 09 29,747 44,149 1.48 115.20% 10 29,813 44,230 1.48 115.29% 11 30,126 44,324 1.47 116.20% 12 29,955 44,172 1.47 115.90% 13 28,916 44,355 1.53 111.52% 14 27,917 44,709 1.60 106.98% 15 28,367 44,697 1.58 108.74% 16 27,919 44,657 1.60 107.13% 17 28,270 44,593 1.58 108.53% 18 27,903 44,512 1.60 107.30% 19 27,805 44,589 1.60 106.83% 20 28,036 44,943 1.60 106.02% 21 27,818 44,834 1.61 106.14% 22 28,321 44,650 1.58 108.53% 23 28,279 45,554 1.61 105.31% Day Hour Count Average / Second Mar 10 00 97 0.03/s 01 95 0.03/s 02 100 0.03/s 03 101 0.03/s 04 99 0.03/s 05 93 0.03/s 06 91 0.03/s 07 95 0.03/s 08 93 0.03/s 09 99 0.03/s 10 105 0.03/s 11 102 0.03/s 12 97 0.03/s 13 82 0.02/s 14 68 0.02/s 15 77 0.02/s 16 71 0.02/s 17 68 0.02/s 18 62 0.02/s 19 63 0.02/s 20 63 0.02/s 21 59 0.02/s 22 69 0.02/s 23 64 0.02/s Day Hour Count Average Duration Mar 10 00 97 6m34s 01 95 6m7s 02 100 6m17s 03 101 5m50s 04 99 6m15s 05 93 6m13s 06 91 6m28s 07 95 6m35s 08 93 6m24s 09 99 6m8s 10 105 5m41s 11 102 5m49s 12 97 6m7s 13 82 7m18s 14 68 8m35s 15 77 8m 16 71 8m5s 17 68 9m17s 18 62 9m37s 19 63 9m36s 20 63 9m38s 21 59 10m23s 22 69 8m28s 23 64 9m11s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2019-03-10 00:30:16 Date
Connections per database
Key values
- pharmisight Main Database
- 2,013 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,013 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-03-10 22:16:11 Date
Histogram of session times
Key values
- 1,343 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,013 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,013 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,013 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 389 buffers Checkpoint Peak
- 2019-03-10 00:06:17 Date
- 39.027 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-03-10 22:35:54 Date
Checkpoints distance
Key values
- 2.79 Mo Distance Peak
- 2019-03-10 00:56:03 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 10 00 2,030 203.539s 0.014s 203.611s 01 562 56.277s 0.008s 56.334s 02 512 51.364s 0.011s 51.42s 03 377 37.805s 0.013s 37.863s 04 579 57.979s 0.009s 58.038s 05 443 44.43s 0.012s 44.495s 06 327 32.794s 0.01s 32.846s 07 538 53.963s 0.014s 54.032s 08 456 45.737s 0.023s 45.812s 09 280 28.088s 0.009s 28.145s 10 400 40.221s 0.01s 40.278s 11 302 30.292s 0.008s 30.353s 12 416 41.731s 0.023s 41.8s 13 375 37.613s 0.011s 37.669s 14 383 38.429s 0.011s 38.494s 15 448 44.937s 0.019s 45.001s 16 538 53.974s 0.014s 54.044s 17 314 31.511s 0.009s 31.572s 18 376 37.723s 0.013s 37.797s 19 493 49.468s 0.013s 49.536s 20 429 43.051s 0.013s 43.128s 21 424 42.535s 0.014s 42.613s 22 513 51.468s 0.016s 51.546s 23 520 52.177s 0.012s 52.245s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 10 00 0 0 1 255 0.002s 0s 01 0 0 0 177 0.002s 0s 02 0 0 0 165 0.002s 0s 03 0 0 0 154 0.002s 0s 04 0 0 0 165 0.002s 0s 05 0 0 0 158 0.002s 0.001s 06 0 0 0 145 0.002s 0s 07 0 0 0 165 0.002s 0s 08 0 0 0 173 0.016s 0.002s 09 0 0 0 146 0.002s 0.001s 10 0 0 0 157 0.003s 0s 11 0 0 1 154 0.001s 0s 12 0 0 0 163 0.018s 0.001s 13 0 0 0 158 0.002s 0s 14 0 0 0 177 0.002s 0s 15 0 0 0 183 0.010s 0s 16 0 0 0 221 0.002s 0s 17 0 0 0 180 0.002s 0s 18 0 0 0 210 0.002s 0s 19 0 0 0 226 0.002s 0s 20 0 0 0 233 0.002s 0s 21 0 0 0 244 0.002s 0s 22 0 0 1 225 0.002s 0s 23 0 0 0 266 0.002s 0s Day Hour Count Avg time (sec) Mar 10 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 Mar 10 00 992.36 kB 1,146.00 kB 01 193.20 kB 940.00 kB 02 182.89 kB 490.44 kB 03 147.56 kB 286.22 kB 04 186.70 kB 612.90 kB 05 154.60 kB 405.70 kB 06 139.12 kB 253.12 kB 07 190.40 kB 399.20 kB 08 142.22 kB 284.33 kB 09 94.89 kB 257.89 kB 10 187.43 kB 406.29 kB 11 85.75 kB 261.00 kB 12 132.50 kB 324.00 kB 13 175.44 kB 280.00 kB 14 122.40 kB 286.40 kB 15 189.14 kB 345.71 kB 16 198.09 kB 354.36 kB 17 142.38 kB 284.12 kB 18 102.45 kB 262.36 kB 19 136.91 kB 280.91 kB 20 130.92 kB 306.00 kB 21 118.18 kB 228.55 kB 22 145.83 kB 279.50 kB 23 192.82 kB 424.00 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 Mar 10 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 (15) Main table analyzed (database pharmisight)
- 73 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data_event 15 pharmisight.public.sym_incoming_batch 14 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_data 10 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 2 pharmisight.public.sym_sequence 1 Total 73 Vacuums per table
Key values
- public.sym_outgoing_batch (8) Main table vacuumed on database pharmisight
- 40 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data_event 6 6 pharmisight.public.sym_data 5 5 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_data_gap 5 5 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.public.item_codes 1 1 pharmisight.public.sym_sequence 1 0 Total 40 33 Tuples removed per table
Key values
- public.sym_data_event (4047) Main table with removed tuples on database pharmisight
- 9551 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 6 6 4047 192 pharmisight.public.sym_data 5 5 1799 544 pharmisight.pg_catalog.pg_statistic 3 3 994 0 pharmisight.public.sym_outgoing_batch 8 8 935 205 pharmisight.public.sym_incoming_batch 5 5 790 0 pharmisight.public.item_codes 1 1 367 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_sequence 1 0 51 0 Total 40 33 9,551 941 Pages removed per table
Key values
- public.sym_data (544) Main table with removed pages on database pharmisight
- 941 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 5 5 1799 544 pharmisight.public.sym_outgoing_batch 8 8 935 205 pharmisight.public.sym_data_event 6 6 4047 192 pharmisight.public.sym_incoming_batch 5 5 790 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.pg_catalog.pg_statistic 3 3 994 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.item_codes 1 1 367 0 pharmisight.public.sym_sequence 1 0 51 0 Total 40 33 9,551 941 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 10 00 5 9 01 3 4 02 2 3 03 1 3 04 3 4 05 3 4 06 0 2 07 4 3 08 1 3 09 0 1 10 2 3 11 0 2 12 2 3 13 1 2 14 2 3 15 1 2 16 3 4 17 0 1 18 1 2 19 2 2 20 0 4 21 1 3 22 2 2 23 1 4 - 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
- 354,880 Total read queries
- 276,911 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,075,874 Requests
- 45s917ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,067,194 Requests
User Request type Count Duration pharmisight Total 52,193 3s992ms DELETE 21 3ms INSERT 98 71ms OTHERS 2,118 81ms SELECT 49,406 3s813ms TCL 530 19ms UPDATE 20 3ms symmetricds Total 1,067,194 43s361ms DELETE 2,012 530ms INSERT 2,729 732ms OTHERS 460,459 7s175ms SELECT 319,095 27s189ms TCL 280,118 5s470ms UPDATE 2,781 2s262ms tony Total 900 255ms SELECT 900 255ms Duration by user
Key values
- 43s361ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 52,193 3s992ms DELETE 21 3ms INSERT 98 71ms OTHERS 2,118 81ms SELECT 49,406 3s813ms TCL 530 19ms UPDATE 20 3ms symmetricds Total 1,067,194 43s361ms DELETE 2,012 530ms INSERT 2,729 732ms OTHERS 460,459 7s175ms SELECT 319,095 27s189ms TCL 280,118 5s470ms UPDATE 2,781 2s262ms tony Total 900 255ms SELECT 900 255ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,119,387 Requests
- 47s353ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,073,285 Requests
- 45s603ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-03-10 10:30:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,072,722 0-1ms duration
Slowest individual queries
Rank Duration Query 1 30ms 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-03-10 03:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 29ms 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-03-09 00:00:00' AND '2019-03-10 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2019-03-10 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 24ms DELETE FROM sym_data WHERE data_id BETWEEN '97722206' AND '97723905' AND create_time < '2019-03-09 01:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '97722206' AND '97723905') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '97722206' AND '97723905' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-03-10 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 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-03-10 22:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 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-03-10 00:00:00' AND '2019-03-11 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2019-03-10 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 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-03-10 04:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 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-03-09' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-03-10 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 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-03-10 02:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 18ms UPDATE "public"."patients" SET "caloriesday" = '1832' WHERE "patient_id" = '128539900';[ Date: 2019-03-10 00:26:11 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 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-03-10 15:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 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-03-10 08:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 17ms COMMIT;[ Date: 2019-03-10 00:12:10 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 17ms COMMIT;[ Date: 2019-03-10 00:37:11 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 17ms 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-03-10' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-03-10 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 16ms COMMIT;[ Date: 2019-03-10 03:09:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 16ms COMMIT;[ Date: 2019-03-10 15:25:55 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 15ms 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-03-10 20:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 15ms 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-03-10 21:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 15ms 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-03-08' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-03-10 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 15ms 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-03-10 05:40: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 9s613ms 17,199 0ms 1ms 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 Mar 10 00 717 400ms 0ms 01 716 410ms 0ms 02 716 411ms 0ms 03 716 404ms 0ms 04 718 407ms 0ms 05 716 395ms 0ms 06 716 401ms 0ms 07 718 404ms 0ms 08 716 416ms 0ms 09 716 401ms 0ms 10 716 414ms 0ms 11 718 413ms 0ms 12 716 417ms 0ms 13 716 391ms 0ms 14 718 399ms 0ms 15 716 384ms 0ms 16 716 391ms 0ms 17 718 395ms 0ms 18 716 383ms 0ms 19 718 404ms 0ms 20 716 383ms 0ms 21 716 389ms 0ms 22 718 394ms 0ms 23 716 395ms 0ms [ User: symmetricds - Total duration: 9s613ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s613ms - Times executed: 17199 ]
-
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-03-10 06:40:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 08:43:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:32:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s586ms 422,347 0ms 12ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 10 00 18,009 271ms 0ms 01 17,432 268ms 0ms 02 17,430 274ms 0ms 03 17,432 269ms 0ms 04 17,464 270ms 0ms 05 17,413 269ms 0ms 06 17,431 279ms 0ms 07 17,477 274ms 0ms 08 17,443 269ms 0ms 09 17,429 264ms 0ms 10 17,460 272ms 0ms 11 17,493 275ms 0ms 12 17,433 270ms 0ms 13 17,560 267ms 0ms 14 17,777 275ms 0ms 15 17,753 274ms 0ms 16 17,752 276ms 0ms 17 17,708 279ms 0ms 18 17,685 279ms 0ms 19 17,734 279ms 0ms 20 17,673 277ms 0ms 21 17,795 286ms 0ms 22 17,716 278ms 0ms 23 17,848 280ms 0ms [ User: symmetricds - Total duration: 6s558ms - Times executed: 421668 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 679 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s586ms - Times executed: 422347 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-03-10 06:54:40 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:22:40 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 02:35:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s406ms 134,729 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 10 00 6,655 635ms 0ms 01 5,521 163ms 0ms 02 5,515 164ms 0ms 03 5,517 182ms 0ms 04 5,528 162ms 0ms 05 5,513 165ms 0ms 06 5,521 160ms 0ms 07 5,533 159ms 0ms 08 5,523 158ms 0ms 09 5,517 158ms 0ms 10 5,525 166ms 0ms 11 5,536 164ms 0ms 12 5,519 167ms 0ms 13 5,560 154ms 0ms 14 5,632 162ms 0ms 15 5,621 174ms 0ms 16 5,623 160ms 0ms 17 5,610 157ms 0ms 18 5,605 157ms 0ms 19 5,607 153ms 0ms 20 5,596 152ms 0ms 21 5,650 167ms 0ms 22 5,616 167ms 0ms 23 5,686 190ms 0ms [ User: symmetricds - Total duration: 4s389ms - Times executed: 134471 ]
[ User: pharmisight - Total duration: 17ms - Times executed: 258 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s406ms - Times executed: 134729 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-03-10 00:12:10 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:37:11 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:09:05 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1s771ms 154,385 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 10 00 7,648 83ms 0ms 01 6,331 70ms 0ms 02 6,329 70ms 0ms 03 6,326 79ms 0ms 04 6,341 70ms 0ms 05 6,324 70ms 0ms 06 6,330 70ms 0ms 07 6,342 72ms 0ms 08 6,338 71ms 0ms 09 6,327 71ms 0ms 10 6,334 71ms 0ms 11 6,351 76ms 0ms 12 6,331 73ms 0ms 13 6,372 78ms 0ms 14 6,444 72ms 0ms 15 6,435 74ms 0ms 16 6,433 72ms 0ms 17 6,424 74ms 0ms 18 6,414 75ms 0ms 19 6,420 72ms 0ms 20 6,388 76ms 0ms 21 6,472 72ms 0ms 22 6,424 73ms 0ms 23 6,507 74ms 0ms [ User: symmetricds - Total duration: 1s771ms - Times executed: 154385 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s771ms - Times executed: 154385 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-03-10 03:00:00 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:05:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:25:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s428ms 1,009 0ms 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 #5
Day Hour Count Duration Avg duration Mar 10 00 52 74ms 1ms 01 56 82ms 1ms 02 52 74ms 1ms 03 53 75ms 1ms 04 55 76ms 1ms 05 54 75ms 1ms 06 52 75ms 1ms 07 55 75ms 1ms 08 53 74ms 1ms 09 54 77ms 1ms 10 56 80ms 1ms 11 57 78ms 1ms 12 56 78ms 1ms 13 42 57ms 1ms 14 24 33ms 1ms 15 29 41ms 1ms 16 25 36ms 1ms 17 29 41ms 1ms 18 26 36ms 1ms 19 24 35ms 1ms 20 26 34ms 1ms 21 22 31ms 1ms 22 31 45ms 1ms 23 26 37ms 1ms [ User: symmetricds - Total duration: 1s428ms - Times executed: 1009 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s428ms - Times executed: 1009 ]
-
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-03-10 11:29:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:32:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:42:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s226ms 1,233 0ms 9ms 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 #6
Day Hour Count Duration Avg duration Mar 10 00 60 59ms 0ms 01 66 63ms 0ms 02 64 61ms 0ms 03 65 64ms 0ms 04 66 66ms 1ms 05 63 61ms 0ms 06 64 73ms 1ms 07 64 62ms 0ms 08 65 63ms 0ms 09 65 66ms 1ms 10 64 65ms 1ms 11 65 67ms 1ms 12 65 66ms 1ms 13 48 45ms 0ms 14 31 28ms 0ms 15 39 37ms 0ms 16 32 31ms 0ms 17 37 34ms 0ms 18 36 41ms 1ms 19 33 30ms 0ms 20 32 30ms 0ms 21 32 31ms 0ms 22 41 38ms 0ms 23 36 34ms 0ms [ User: symmetricds - Total duration: 1s226ms - Times executed: 1233 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s226ms - Times executed: 1233 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-03-10 18:56:22 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 06:50:40 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 12:38:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s212ms 25,166 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 10 00 1,136 52ms 0ms 01 1,044 49ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,046 49ms 0ms 05 1,044 49ms 0ms 06 1,044 50ms 0ms 07 1,046 50ms 0ms 08 1,044 48ms 0ms 09 1,044 49ms 0ms 10 1,044 49ms 0ms 11 1,046 49ms 0ms 12 1,044 47ms 0ms 13 1,044 49ms 0ms 14 1,046 49ms 0ms 15 1,044 50ms 0ms 16 1,044 51ms 0ms 17 1,046 50ms 0ms 18 1,044 52ms 0ms 19 1,046 55ms 0ms 20 1,038 51ms 0ms 21 1,048 50ms 0ms 22 1,046 52ms 0ms 23 1,050 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 25166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 25166 ]
-
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-03-10 22:45:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:40:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:39:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s204ms 24,096 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 10 00 1,004 37ms 0ms 01 1,004 51ms 0ms 02 1,004 37ms 0ms 03 1,004 45ms 0ms 04 1,004 59ms 0ms 05 1,004 50ms 0ms 06 1,004 51ms 0ms 07 1,004 50ms 0ms 08 1,004 50ms 0ms 09 1,004 49ms 0ms 10 1,004 50ms 0ms 11 1,004 49ms 0ms 12 1,004 50ms 0ms 13 1,004 50ms 0ms 14 1,004 50ms 0ms 15 1,004 53ms 0ms 16 1,004 49ms 0ms 17 1,004 50ms 0ms 18 1,004 49ms 0ms 19 1,004 50ms 0ms 20 1,004 55ms 0ms 21 1,004 57ms 0ms 22 1,004 50ms 0ms 23 1,004 50ms 0ms [ User: pharmisight - Total duration: 1s204ms - Times executed: 24096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s204ms - Times executed: 24096 ]
-
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 = '33074043' 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 = '3360' 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 = '2927' ORDER BY itemcodes0_.code ASC;
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s78ms 21,336 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 10 00 889 33ms 0ms 01 889 45ms 0ms 02 889 34ms 0ms 03 889 40ms 0ms 04 889 53ms 0ms 05 889 45ms 0ms 06 889 45ms 0ms 07 889 44ms 0ms 08 889 44ms 0ms 09 889 44ms 0ms 10 889 45ms 0ms 11 889 44ms 0ms 12 889 44ms 0ms 13 889 45ms 0ms 14 889 45ms 0ms 15 889 48ms 0ms 16 889 43ms 0ms 17 889 45ms 0ms 18 889 44ms 0ms 19 889 46ms 0ms 20 889 50ms 0ms 21 889 51ms 0ms 22 889 44ms 0ms 23 889 44ms 0ms [ User: pharmisight - Total duration: 1s78ms - Times executed: 21336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s78ms - Times executed: 21336 ]
-
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 = '33052849' 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 = '33073043' 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 = '3179' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-03-10 19:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s75ms 163 3ms 11ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 10 00 114 643ms 5ms 01 2 17ms 8ms 02 2 17ms 8ms 03 2 17ms 8ms 04 2 18ms 9ms 05 2 18ms 9ms 06 2 18ms 9ms 07 2 13ms 6ms 08 2 18ms 9ms 09 2 18ms 9ms 10 2 18ms 9ms 11 2 18ms 9ms 12 2 18ms 9ms 13 2 17ms 8ms 14 2 17ms 8ms 15 2 17ms 8ms 16 2 18ms 9ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 18ms 9ms 20 2 17ms 8ms 21 3 27ms 9ms 22 2 18ms 9ms 23 4 30ms 7ms [ User: symmetricds - Total duration: 759ms - Times executed: 118 ]
[ User: pharmisight - Total duration: 315ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s75ms - Times executed: 163 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-03-10 00:30:19 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:30:18 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:00:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 999ms 189 0ms 10ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 10 00 8 35ms 4ms 01 8 46ms 5ms 02 8 45ms 5ms 03 8 50ms 6ms 04 8 41ms 5ms 05 8 46ms 5ms 06 8 50ms 6ms 07 8 33ms 4ms 08 8 43ms 5ms 09 8 42ms 5ms 10 8 50ms 6ms 11 8 50ms 6ms 12 8 46ms 5ms 13 8 52ms 6ms 14 8 37ms 4ms 15 8 47ms 5ms 16 8 47ms 5ms 17 8 41ms 5ms 18 8 39ms 4ms 19 8 41ms 5ms 20 5 21ms 4ms 21 8 39ms 4ms 22 8 18ms 2ms 23 8 29ms 3ms [ User: symmetricds - Total duration: 999ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 999ms - Times executed: 189 ]
-
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" = '432248304', "total_memory_bytes" = '733478912', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 21:55:41', "last_restart_time" = '2019-02-19 05:14:14.845', "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" = '381600976', "total_memory_bytes" = '733478912', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 05:55:09', "last_restart_time" = '2019-02-19 05:14:14.845', "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" = '238351672', "total_memory_bytes" = '536346624', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 04:51:53', "last_restart_time" = '2019-03-07 10:07:48', "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-03-10 21:56:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:55:23 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 04:53:21 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 935ms 1,021 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 #12
Day Hour Count Duration Avg duration Mar 10 00 53 48ms 0ms 01 57 51ms 0ms 02 55 50ms 0ms 03 55 49ms 0ms 04 57 53ms 0ms 05 55 50ms 0ms 06 53 49ms 0ms 07 55 50ms 0ms 08 54 49ms 0ms 09 55 49ms 0ms 10 55 52ms 0ms 11 57 53ms 0ms 12 56 52ms 0ms 13 42 38ms 0ms 14 24 21ms 0ms 15 29 25ms 0ms 16 25 22ms 0ms 17 29 25ms 0ms 18 26 23ms 0ms 19 24 22ms 0ms 20 26 23ms 0ms 21 22 20ms 0ms 22 31 27ms 0ms 23 26 22ms 0ms [ User: symmetricds - Total duration: 935ms - Times executed: 1021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 1021 ]
-
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-03-10 10:06:14 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:52:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 12:48:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 884ms 134,730 0ms 12ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 10 00 6,656 42ms 0ms 01 5,521 36ms 0ms 02 5,515 35ms 0ms 03 5,517 35ms 0ms 04 5,528 35ms 0ms 05 5,513 37ms 0ms 06 5,521 47ms 0ms 07 5,533 35ms 0ms 08 5,523 35ms 0ms 09 5,517 34ms 0ms 10 5,525 35ms 0ms 11 5,536 35ms 0ms 12 5,519 35ms 0ms 13 5,560 35ms 0ms 14 5,632 36ms 0ms 15 5,621 35ms 0ms 16 5,623 36ms 0ms 17 5,610 37ms 0ms 18 5,605 35ms 0ms 19 5,607 36ms 0ms 20 5,596 35ms 0ms 21 5,650 37ms 0ms 22 5,616 36ms 0ms 23 5,686 37ms 0ms [ User: symmetricds - Total duration: 882ms - Times executed: 134471 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 259 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 884ms - Times executed: 134730 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-03-10 06:32:40 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:47:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:24:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 875ms 17,302 0ms 2ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 10 00 720 35ms 0ms 01 720 35ms 0ms 02 720 35ms 0ms 03 720 36ms 0ms 04 722 35ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 35ms 0ms 09 720 35ms 0ms 10 720 36ms 0ms 11 722 36ms 0ms 12 720 36ms 0ms 13 720 36ms 0ms 14 722 36ms 0ms 15 720 36ms 0ms 16 720 36ms 0ms 17 722 36ms 0ms 18 720 36ms 0ms 19 722 37ms 0ms 20 720 36ms 0ms 21 722 37ms 0ms 22 722 38ms 0ms 23 726 37ms 0ms [ User: symmetricds - Total duration: 875ms - Times executed: 17302 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 875ms - Times executed: 17302 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-03-10 22:58:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 20:03:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 17:01:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 864ms 1,007 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 #15
Day Hour Count Duration Avg duration Mar 10 00 52 43ms 0ms 01 56 48ms 0ms 02 53 45ms 0ms 03 54 46ms 0ms 04 56 49ms 0ms 05 53 45ms 0ms 06 51 44ms 0ms 07 55 47ms 0ms 08 51 44ms 0ms 09 54 45ms 0ms 10 55 49ms 0ms 11 57 48ms 0ms 12 56 47ms 0ms 13 42 35ms 0ms 14 24 19ms 0ms 15 29 23ms 0ms 16 25 21ms 0ms 17 29 24ms 0ms 18 26 22ms 0ms 19 24 20ms 0ms 20 26 22ms 0ms 21 22 19ms 0ms 22 31 26ms 0ms 23 26 21ms 0ms [ User: symmetricds - Total duration: 864ms - Times executed: 1007 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 864ms - Times executed: 1007 ]
-
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-03-10 10:06:14 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:50:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:52:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 681ms 6,172 0ms 0ms 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 #16
Day Hour Count Duration Avg duration Mar 10 00 240 27ms 0ms 01 240 25ms 0ms 02 237 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 236 26ms 0ms 06 239 27ms 0ms 07 240 27ms 0ms 08 240 26ms 0ms 09 237 26ms 0ms 10 239 26ms 0ms 11 240 28ms 0ms 12 236 27ms 0ms 13 256 26ms 0ms 14 285 30ms 0ms 15 284 31ms 0ms 16 285 31ms 0ms 17 275 28ms 0ms 18 276 28ms 0ms 19 288 31ms 0ms 20 286 30ms 0ms 21 283 31ms 0ms 22 271 29ms 0ms 23 280 30ms 0ms [ User: symmetricds - Total duration: 681ms - Times executed: 6172 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 681ms - Times executed: 6172 ]
-
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-03-10 21:41:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:23:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 23:48:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 655ms 4,424 0ms 10ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 10 00 184 21ms 0ms 01 184 40ms 0ms 02 184 54ms 0ms 03 184 58ms 0ms 04 184 17ms 0ms 05 184 38ms 0ms 06 184 56ms 0ms 07 184 16ms 0ms 08 184 19ms 0ms 09 184 50ms 0ms 10 184 40ms 0ms 11 184 22ms 0ms 12 184 14ms 0ms 13 184 12ms 0ms 14 184 14ms 0ms 15 184 14ms 0ms 16 184 14ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 14ms 0ms 20 184 33ms 0ms 21 186 30ms 0ms 22 184 15ms 0ms 23 190 20ms 0ms [ User: symmetricds - Total duration: 655ms - Times executed: 4424 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 655ms - Times executed: 4424 ]
-
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 = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-03-10 06:06:40 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:05:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:32:41 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 624ms 149 1ms 11ms 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 #18
Day Hour Count Duration Avg duration Mar 10 00 6 25ms 4ms 01 6 23ms 3ms 02 7 28ms 4ms 03 6 31ms 5ms 04 6 23ms 3ms 05 8 30ms 3ms 06 6 23ms 3ms 07 6 23ms 3ms 08 6 29ms 4ms 09 6 32ms 5ms 10 5 22ms 4ms 11 7 31ms 4ms 12 5 19ms 3ms 13 6 13ms 2ms 14 5 17ms 3ms 15 6 26ms 4ms 16 5 19ms 3ms 17 7 29ms 4ms 18 5 25ms 5ms 19 7 28ms 4ms 20 4 16ms 4ms 21 9 41ms 4ms 22 6 23ms 3ms 23 9 36ms 4ms [ User: symmetricds - Total duration: 624ms - Times executed: 149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 624ms - Times executed: 149 ]
-
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-03-10 18:39:44 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:39:39 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 09:24:40 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 471ms 17,264 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 10 00 718 18ms 0ms 01 720 18ms 0ms 02 720 18ms 0ms 03 718 19ms 0ms 04 718 19ms 0ms 05 720 19ms 0ms 06 718 18ms 0ms 07 720 19ms 0ms 08 720 19ms 0ms 09 718 19ms 0ms 10 720 19ms 0ms 11 720 20ms 0ms 12 720 20ms 0ms 13 718 19ms 0ms 14 720 19ms 0ms 15 720 20ms 0ms 16 720 19ms 0ms 17 718 19ms 0ms 18 720 20ms 0ms 19 720 20ms 0ms 20 720 19ms 0ms 21 718 19ms 0ms 22 720 20ms 0ms 23 720 20ms 0ms [ User: symmetricds - Total duration: 471ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 471ms - Times executed: 17264 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-03-10 02:40:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:28:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 06:19:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 451ms 1,033 0ms 18ms 0ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 00 1,033 451ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 1033 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 1033 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1832' WHERE "patient_id" = '128539900';
-
UPDATE "public"."patients" SET "caloriesday" = '1368' WHERE "patient_id" = '170073';
-
UPDATE "public"."patients" SET "caloriesday" = '2726' WHERE "patient_id" = '137250';
Date: 2019-03-10 00:26:11 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:04:10 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:54:12 Duration: 11ms 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 422,347 6s586ms 0ms 12ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 10 00 18,009 271ms 0ms 01 17,432 268ms 0ms 02 17,430 274ms 0ms 03 17,432 269ms 0ms 04 17,464 270ms 0ms 05 17,413 269ms 0ms 06 17,431 279ms 0ms 07 17,477 274ms 0ms 08 17,443 269ms 0ms 09 17,429 264ms 0ms 10 17,460 272ms 0ms 11 17,493 275ms 0ms 12 17,433 270ms 0ms 13 17,560 267ms 0ms 14 17,777 275ms 0ms 15 17,753 274ms 0ms 16 17,752 276ms 0ms 17 17,708 279ms 0ms 18 17,685 279ms 0ms 19 17,734 279ms 0ms 20 17,673 277ms 0ms 21 17,795 286ms 0ms 22 17,716 278ms 0ms 23 17,848 280ms 0ms [ User: symmetricds - Total duration: 6s558ms - Times executed: 421668 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 679 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s586ms - Times executed: 422347 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-03-10 06:54:40 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:22:40 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 02:35:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 154,385 1s771ms 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 10 00 7,648 83ms 0ms 01 6,331 70ms 0ms 02 6,329 70ms 0ms 03 6,326 79ms 0ms 04 6,341 70ms 0ms 05 6,324 70ms 0ms 06 6,330 70ms 0ms 07 6,342 72ms 0ms 08 6,338 71ms 0ms 09 6,327 71ms 0ms 10 6,334 71ms 0ms 11 6,351 76ms 0ms 12 6,331 73ms 0ms 13 6,372 78ms 0ms 14 6,444 72ms 0ms 15 6,435 74ms 0ms 16 6,433 72ms 0ms 17 6,424 74ms 0ms 18 6,414 75ms 0ms 19 6,420 72ms 0ms 20 6,388 76ms 0ms 21 6,472 72ms 0ms 22 6,424 73ms 0ms 23 6,507 74ms 0ms [ User: symmetricds - Total duration: 1s771ms - Times executed: 154385 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s771ms - Times executed: 154385 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-03-10 03:00:00 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:05:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:25:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 134,730 884ms 0ms 12ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 10 00 6,656 42ms 0ms 01 5,521 36ms 0ms 02 5,515 35ms 0ms 03 5,517 35ms 0ms 04 5,528 35ms 0ms 05 5,513 37ms 0ms 06 5,521 47ms 0ms 07 5,533 35ms 0ms 08 5,523 35ms 0ms 09 5,517 34ms 0ms 10 5,525 35ms 0ms 11 5,536 35ms 0ms 12 5,519 35ms 0ms 13 5,560 35ms 0ms 14 5,632 36ms 0ms 15 5,621 35ms 0ms 16 5,623 36ms 0ms 17 5,610 37ms 0ms 18 5,605 35ms 0ms 19 5,607 36ms 0ms 20 5,596 35ms 0ms 21 5,650 37ms 0ms 22 5,616 36ms 0ms 23 5,686 37ms 0ms [ User: symmetricds - Total duration: 882ms - Times executed: 134471 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 259 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 884ms - Times executed: 134730 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-03-10 06:32:40 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:47:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:24:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 134,729 4s406ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 10 00 6,655 635ms 0ms 01 5,521 163ms 0ms 02 5,515 164ms 0ms 03 5,517 182ms 0ms 04 5,528 162ms 0ms 05 5,513 165ms 0ms 06 5,521 160ms 0ms 07 5,533 159ms 0ms 08 5,523 158ms 0ms 09 5,517 158ms 0ms 10 5,525 166ms 0ms 11 5,536 164ms 0ms 12 5,519 167ms 0ms 13 5,560 154ms 0ms 14 5,632 162ms 0ms 15 5,621 174ms 0ms 16 5,623 160ms 0ms 17 5,610 157ms 0ms 18 5,605 157ms 0ms 19 5,607 153ms 0ms 20 5,596 152ms 0ms 21 5,650 167ms 0ms 22 5,616 167ms 0ms 23 5,686 190ms 0ms [ User: symmetricds - Total duration: 4s389ms - Times executed: 134471 ]
[ User: pharmisight - Total duration: 17ms - Times executed: 258 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s406ms - Times executed: 134729 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-03-10 00:12:10 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:37:11 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:09:05 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,166 1s212ms 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 10 00 1,136 52ms 0ms 01 1,044 49ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,046 49ms 0ms 05 1,044 49ms 0ms 06 1,044 50ms 0ms 07 1,046 50ms 0ms 08 1,044 48ms 0ms 09 1,044 49ms 0ms 10 1,044 49ms 0ms 11 1,046 49ms 0ms 12 1,044 47ms 0ms 13 1,044 49ms 0ms 14 1,046 49ms 0ms 15 1,044 50ms 0ms 16 1,044 51ms 0ms 17 1,046 50ms 0ms 18 1,044 52ms 0ms 19 1,046 55ms 0ms 20 1,038 51ms 0ms 21 1,048 50ms 0ms 22 1,046 52ms 0ms 23 1,050 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 25166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 25166 ]
-
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-03-10 22:45:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:40:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:39:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,096 1s204ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 10 00 1,004 37ms 0ms 01 1,004 51ms 0ms 02 1,004 37ms 0ms 03 1,004 45ms 0ms 04 1,004 59ms 0ms 05 1,004 50ms 0ms 06 1,004 51ms 0ms 07 1,004 50ms 0ms 08 1,004 50ms 0ms 09 1,004 49ms 0ms 10 1,004 50ms 0ms 11 1,004 49ms 0ms 12 1,004 50ms 0ms 13 1,004 50ms 0ms 14 1,004 50ms 0ms 15 1,004 53ms 0ms 16 1,004 49ms 0ms 17 1,004 50ms 0ms 18 1,004 49ms 0ms 19 1,004 50ms 0ms 20 1,004 55ms 0ms 21 1,004 57ms 0ms 22 1,004 50ms 0ms 23 1,004 50ms 0ms [ User: pharmisight - Total duration: 1s204ms - Times executed: 24096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s204ms - Times executed: 24096 ]
-
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 = '33074043' 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 = '3360' 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 = '2927' ORDER BY itemcodes0_.code ASC;
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,336 1s78ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 10 00 889 33ms 0ms 01 889 45ms 0ms 02 889 34ms 0ms 03 889 40ms 0ms 04 889 53ms 0ms 05 889 45ms 0ms 06 889 45ms 0ms 07 889 44ms 0ms 08 889 44ms 0ms 09 889 44ms 0ms 10 889 45ms 0ms 11 889 44ms 0ms 12 889 44ms 0ms 13 889 45ms 0ms 14 889 45ms 0ms 15 889 48ms 0ms 16 889 43ms 0ms 17 889 45ms 0ms 18 889 44ms 0ms 19 889 46ms 0ms 20 889 50ms 0ms 21 889 51ms 0ms 22 889 44ms 0ms 23 889 44ms 0ms [ User: pharmisight - Total duration: 1s78ms - Times executed: 21336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s78ms - Times executed: 21336 ]
-
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 = '33052849' 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 = '33073043' 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 = '3179' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-03-10 19:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,302 875ms 0ms 2ms 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 Mar 10 00 720 35ms 0ms 01 720 35ms 0ms 02 720 35ms 0ms 03 720 36ms 0ms 04 722 35ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 35ms 0ms 09 720 35ms 0ms 10 720 36ms 0ms 11 722 36ms 0ms 12 720 36ms 0ms 13 720 36ms 0ms 14 722 36ms 0ms 15 720 36ms 0ms 16 720 36ms 0ms 17 722 36ms 0ms 18 720 36ms 0ms 19 722 37ms 0ms 20 720 36ms 0ms 21 722 37ms 0ms 22 722 38ms 0ms 23 726 37ms 0ms [ User: symmetricds - Total duration: 875ms - Times executed: 17302 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 875ms - Times executed: 17302 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-03-10 22:58:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 20:03:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 17:01:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,264 471ms 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 Mar 10 00 718 18ms 0ms 01 720 18ms 0ms 02 720 18ms 0ms 03 718 19ms 0ms 04 718 19ms 0ms 05 720 19ms 0ms 06 718 18ms 0ms 07 720 19ms 0ms 08 720 19ms 0ms 09 718 19ms 0ms 10 720 19ms 0ms 11 720 20ms 0ms 12 720 20ms 0ms 13 718 19ms 0ms 14 720 19ms 0ms 15 720 20ms 0ms 16 720 19ms 0ms 17 718 19ms 0ms 18 720 20ms 0ms 19 720 20ms 0ms 20 720 19ms 0ms 21 718 19ms 0ms 22 720 20ms 0ms 23 720 20ms 0ms [ User: symmetricds - Total duration: 471ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 471ms - Times executed: 17264 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-03-10 02:40:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:28:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 06:19:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,199 9s613ms 0ms 1ms 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 Mar 10 00 717 400ms 0ms 01 716 410ms 0ms 02 716 411ms 0ms 03 716 404ms 0ms 04 718 407ms 0ms 05 716 395ms 0ms 06 716 401ms 0ms 07 718 404ms 0ms 08 716 416ms 0ms 09 716 401ms 0ms 10 716 414ms 0ms 11 718 413ms 0ms 12 716 417ms 0ms 13 716 391ms 0ms 14 718 399ms 0ms 15 716 384ms 0ms 16 716 391ms 0ms 17 718 395ms 0ms 18 716 383ms 0ms 19 718 404ms 0ms 20 716 383ms 0ms 21 716 389ms 0ms 22 718 394ms 0ms 23 716 395ms 0ms [ User: symmetricds - Total duration: 9s613ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s613ms - Times executed: 17199 ]
-
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-03-10 06:40:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 08:43:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:32:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,143 112ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 10 00 380 4ms 0ms 01 380 4ms 0ms 02 380 4ms 0ms 03 380 4ms 0ms 04 381 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 381 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 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 381 4ms 0ms 20 380 4ms 0ms 21 385 4ms 0ms 22 380 4ms 0ms 23 392 4ms 0ms [ User: symmetricds - Total duration: 112ms - Times executed: 9143 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 112ms - Times executed: 9143 ]
-
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-03-10 04:06:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:32:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,143 150ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 10 00 380 5ms 0ms 01 377 6ms 0ms 02 382 6ms 0ms 03 381 6ms 0ms 04 378 6ms 0ms 05 382 6ms 0ms 06 378 6ms 0ms 07 381 6ms 0ms 08 380 6ms 0ms 09 380 6ms 0ms 10 380 6ms 0ms 11 381 6ms 0ms 12 380 6ms 0ms 13 382 6ms 0ms 14 379 6ms 0ms 15 382 6ms 0ms 16 381 6ms 0ms 17 380 6ms 0ms 18 378 6ms 0ms 19 381 6ms 0ms 20 380 6ms 0ms 21 387 6ms 0ms 22 381 6ms 0ms 23 392 6ms 0ms [ User: symmetricds - Total duration: 150ms - Times executed: 9143 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 150ms - Times executed: 9143 ]
-
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-03-10 17:06:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:14:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 23:02:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,599 259ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 10 00 358 10ms 0ms 01 358 10ms 0ms 02 358 10ms 0ms 03 358 10ms 0ms 04 359 9ms 0ms 05 358 10ms 0ms 06 358 10ms 0ms 07 359 11ms 0ms 08 358 10ms 0ms 09 358 10ms 0ms 10 358 10ms 0ms 11 359 10ms 0ms 12 358 10ms 0ms 13 358 11ms 0ms 14 359 10ms 0ms 15 358 10ms 0ms 16 358 10ms 0ms 17 359 11ms 0ms 18 358 11ms 0ms 19 359 11ms 0ms 20 358 11ms 0ms 21 358 11ms 0ms 22 359 11ms 0ms 23 358 11ms 0ms [ User: symmetricds - Total duration: 259ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 259ms - Times executed: 8599 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '97724211' AND '147724210'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '97724175' AND '147724174'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '97724058' AND '147724057'));
Date: 2019-03-10 23:40:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 23:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:38:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,599 404ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 10 00 358 16ms 0ms 01 358 16ms 0ms 02 358 17ms 0ms 03 358 17ms 0ms 04 359 16ms 0ms 05 358 17ms 0ms 06 358 17ms 0ms 07 359 17ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 17ms 0ms 11 359 17ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 359 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 359 16ms 0ms 18 358 17ms 0ms 19 359 17ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 17ms 0ms [ User: symmetricds - Total duration: 404ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 8599 ]
-
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-03-10 18:04:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:47:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:02:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,599 301ms 0ms 1ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 10 00 358 11ms 0ms 01 358 11ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 359 11ms 0ms 12 358 12ms 0ms 13 358 13ms 0ms 14 359 13ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 359 12ms 0ms 18 358 13ms 0ms 19 359 12ms 0ms 20 358 12ms 0ms 21 358 13ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms [ User: symmetricds - Total duration: 301ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 301ms - Times executed: 8599 ]
-
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-03-10 18:45:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:37:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 14:11:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,599 198ms 0ms 1ms 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 #16
Day Hour Count Duration Avg duration Mar 10 00 358 8ms 0ms 01 358 8ms 0ms 02 358 9ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 359 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 359 8ms 0ms 12 358 7ms 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 359 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 359 8ms 0ms 23 358 8ms 0ms [ User: symmetricds - Total duration: 198ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 198ms - Times executed: 8599 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '97723926' AND data_id <= '147723925' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '97724031' AND data_id <= '147724030' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '97723902' AND data_id <= '147723901' ORDER BY data_id ASC;
Date: 2019-03-10 02:30:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:10:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:37:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,172 681ms 0ms 0ms 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 Mar 10 00 240 27ms 0ms 01 240 25ms 0ms 02 237 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 236 26ms 0ms 06 239 27ms 0ms 07 240 27ms 0ms 08 240 26ms 0ms 09 237 26ms 0ms 10 239 26ms 0ms 11 240 28ms 0ms 12 236 27ms 0ms 13 256 26ms 0ms 14 285 30ms 0ms 15 284 31ms 0ms 16 285 31ms 0ms 17 275 28ms 0ms 18 276 28ms 0ms 19 288 31ms 0ms 20 286 30ms 0ms 21 283 31ms 0ms 22 271 29ms 0ms 23 280 30ms 0ms [ User: symmetricds - Total duration: 681ms - Times executed: 6172 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 681ms - Times executed: 6172 ]
-
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-03-10 21:41:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:23:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 23:48:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,172 307ms 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 Mar 10 00 240 12ms 0ms 01 240 12ms 0ms 02 237 11ms 0ms 03 239 12ms 0ms 04 240 12ms 0ms 05 236 12ms 0ms 06 239 12ms 0ms 07 240 12ms 0ms 08 240 12ms 0ms 09 237 12ms 0ms 10 239 12ms 0ms 11 240 13ms 0ms 12 236 12ms 0ms 13 256 12ms 0ms 14 285 13ms 0ms 15 284 14ms 0ms 16 285 13ms 0ms 17 275 12ms 0ms 18 276 12ms 0ms 19 288 13ms 0ms 20 286 13ms 0ms 21 283 13ms 0ms 22 271 13ms 0ms 23 280 13ms 0ms [ User: symmetricds - Total duration: 307ms - Times executed: 6172 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 307ms - Times executed: 6172 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
Date: 2019-03-10 22:37:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:17:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:33:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,424 655ms 0ms 10ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 10 00 184 21ms 0ms 01 184 40ms 0ms 02 184 54ms 0ms 03 184 58ms 0ms 04 184 17ms 0ms 05 184 38ms 0ms 06 184 56ms 0ms 07 184 16ms 0ms 08 184 19ms 0ms 09 184 50ms 0ms 10 184 40ms 0ms 11 184 22ms 0ms 12 184 14ms 0ms 13 184 12ms 0ms 14 184 14ms 0ms 15 184 14ms 0ms 16 184 14ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 14ms 0ms 20 184 33ms 0ms 21 186 30ms 0ms 22 184 15ms 0ms 23 190 20ms 0ms [ User: symmetricds - Total duration: 655ms - Times executed: 4424 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 655ms - Times executed: 4424 ]
-
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 = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-03-10 06:06:40 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:05:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:32:41 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,388 108ms 0ms 0ms 0ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 00 1,284 29ms 0ms 01 48 3ms 0ms 02 48 3ms 0ms 03 48 4ms 0ms 04 48 3ms 0ms 05 48 3ms 0ms 06 48 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 3ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 3ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 36 2ms 0ms 21 52 2ms 0ms 22 48 2ms 0ms 23 56 2ms 0ms [ User: symmetricds - Total duration: 108ms - Times executed: 2388 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 108ms - Times executed: 2388 ]
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-03-10 21:11:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:38:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:54:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3ms 11ms 6ms 163 1s75ms 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 #1
Day Hour Count Duration Avg duration Mar 10 00 114 643ms 5ms 01 2 17ms 8ms 02 2 17ms 8ms 03 2 17ms 8ms 04 2 18ms 9ms 05 2 18ms 9ms 06 2 18ms 9ms 07 2 13ms 6ms 08 2 18ms 9ms 09 2 18ms 9ms 10 2 18ms 9ms 11 2 18ms 9ms 12 2 18ms 9ms 13 2 17ms 8ms 14 2 17ms 8ms 15 2 17ms 8ms 16 2 18ms 9ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 18ms 9ms 20 2 17ms 8ms 21 3 27ms 9ms 22 2 18ms 9ms 23 4 30ms 7ms [ User: symmetricds - Total duration: 759ms - Times executed: 118 ]
[ User: pharmisight - Total duration: 315ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s75ms - Times executed: 163 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-03-10 00:30:19 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:30:18 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:00:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 10ms 5ms 189 999ms 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 #2
Day Hour Count Duration Avg duration Mar 10 00 8 35ms 4ms 01 8 46ms 5ms 02 8 45ms 5ms 03 8 50ms 6ms 04 8 41ms 5ms 05 8 46ms 5ms 06 8 50ms 6ms 07 8 33ms 4ms 08 8 43ms 5ms 09 8 42ms 5ms 10 8 50ms 6ms 11 8 50ms 6ms 12 8 46ms 5ms 13 8 52ms 6ms 14 8 37ms 4ms 15 8 47ms 5ms 16 8 47ms 5ms 17 8 41ms 5ms 18 8 39ms 4ms 19 8 41ms 5ms 20 5 21ms 4ms 21 8 39ms 4ms 22 8 18ms 2ms 23 8 29ms 3ms [ User: symmetricds - Total duration: 999ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 999ms - Times executed: 189 ]
-
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" = '432248304', "total_memory_bytes" = '733478912', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 21:55:41', "last_restart_time" = '2019-02-19 05:14:14.845', "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" = '381600976', "total_memory_bytes" = '733478912', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 05:55:09', "last_restart_time" = '2019-02-19 05:14:14.845', "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" = '238351672', "total_memory_bytes" = '536346624', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+00:00', "heartbeat_time" = '2019-03-10 04:51:53', "last_restart_time" = '2019-03-07 10:07:48', "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-03-10 21:56:02 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:55:23 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 04:53:21 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 1ms 11ms 4ms 149 624ms 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 #3
Day Hour Count Duration Avg duration Mar 10 00 6 25ms 4ms 01 6 23ms 3ms 02 7 28ms 4ms 03 6 31ms 5ms 04 6 23ms 3ms 05 8 30ms 3ms 06 6 23ms 3ms 07 6 23ms 3ms 08 6 29ms 4ms 09 6 32ms 5ms 10 5 22ms 4ms 11 7 31ms 4ms 12 5 19ms 3ms 13 6 13ms 2ms 14 5 17ms 3ms 15 6 26ms 4ms 16 5 19ms 3ms 17 7 29ms 4ms 18 5 25ms 5ms 19 7 28ms 4ms 20 4 16ms 4ms 21 9 41ms 4ms 22 6 23ms 3ms 23 9 36ms 4ms [ User: symmetricds - Total duration: 624ms - Times executed: 149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 624ms - Times executed: 149 ]
-
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-03-10 18:39:44 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:39:39 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 09:24:40 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 2ms 1ms 1,009 1s428ms 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 #4
Day Hour Count Duration Avg duration Mar 10 00 52 74ms 1ms 01 56 82ms 1ms 02 52 74ms 1ms 03 53 75ms 1ms 04 55 76ms 1ms 05 54 75ms 1ms 06 52 75ms 1ms 07 55 75ms 1ms 08 53 74ms 1ms 09 54 77ms 1ms 10 56 80ms 1ms 11 57 78ms 1ms 12 56 78ms 1ms 13 42 57ms 1ms 14 24 33ms 1ms 15 29 41ms 1ms 16 25 36ms 1ms 17 29 41ms 1ms 18 26 36ms 1ms 19 24 35ms 1ms 20 26 34ms 1ms 21 22 31ms 1ms 22 31 45ms 1ms 23 26 37ms 1ms [ User: symmetricds - Total duration: 1s428ms - Times executed: 1009 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s428ms - Times executed: 1009 ]
-
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-03-10 11:29:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:32:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:42:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 9ms 0ms 1,233 1s226ms 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 #5
Day Hour Count Duration Avg duration Mar 10 00 60 59ms 0ms 01 66 63ms 0ms 02 64 61ms 0ms 03 65 64ms 0ms 04 66 66ms 1ms 05 63 61ms 0ms 06 64 73ms 1ms 07 64 62ms 0ms 08 65 63ms 0ms 09 65 66ms 1ms 10 64 65ms 1ms 11 65 67ms 1ms 12 65 66ms 1ms 13 48 45ms 0ms 14 31 28ms 0ms 15 39 37ms 0ms 16 32 31ms 0ms 17 37 34ms 0ms 18 36 41ms 1ms 19 33 30ms 0ms 20 32 30ms 0ms 21 32 31ms 0ms 22 41 38ms 0ms 23 36 34ms 0ms [ User: symmetricds - Total duration: 1s226ms - Times executed: 1233 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s226ms - Times executed: 1233 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-03-10 18:56:22 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 06:50:40 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 12:38:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 1ms 0ms 1,021 935ms 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 #6
Day Hour Count Duration Avg duration Mar 10 00 53 48ms 0ms 01 57 51ms 0ms 02 55 50ms 0ms 03 55 49ms 0ms 04 57 53ms 0ms 05 55 50ms 0ms 06 53 49ms 0ms 07 55 50ms 0ms 08 54 49ms 0ms 09 55 49ms 0ms 10 55 52ms 0ms 11 57 53ms 0ms 12 56 52ms 0ms 13 42 38ms 0ms 14 24 21ms 0ms 15 29 25ms 0ms 16 25 22ms 0ms 17 29 25ms 0ms 18 26 23ms 0ms 19 24 22ms 0ms 20 26 23ms 0ms 21 22 20ms 0ms 22 31 27ms 0ms 23 26 22ms 0ms [ User: symmetricds - Total duration: 935ms - Times executed: 1021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 1021 ]
-
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-03-10 10:06:14 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:52:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 12:48:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 1ms 0ms 1,007 864ms 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 #7
Day Hour Count Duration Avg duration Mar 10 00 52 43ms 0ms 01 56 48ms 0ms 02 53 45ms 0ms 03 54 46ms 0ms 04 56 49ms 0ms 05 53 45ms 0ms 06 51 44ms 0ms 07 55 47ms 0ms 08 51 44ms 0ms 09 54 45ms 0ms 10 55 49ms 0ms 11 57 48ms 0ms 12 56 47ms 0ms 13 42 35ms 0ms 14 24 19ms 0ms 15 29 23ms 0ms 16 25 21ms 0ms 17 29 24ms 0ms 18 26 22ms 0ms 19 24 20ms 0ms 20 26 22ms 0ms 21 22 19ms 0ms 22 31 26ms 0ms 23 26 21ms 0ms [ User: symmetricds - Total duration: 864ms - Times executed: 1007 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 864ms - Times executed: 1007 ]
-
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-03-10 10:06:14 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:50:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:52:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 17,199 9s613ms 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 #8
Day Hour Count Duration Avg duration Mar 10 00 717 400ms 0ms 01 716 410ms 0ms 02 716 411ms 0ms 03 716 404ms 0ms 04 718 407ms 0ms 05 716 395ms 0ms 06 716 401ms 0ms 07 718 404ms 0ms 08 716 416ms 0ms 09 716 401ms 0ms 10 716 414ms 0ms 11 718 413ms 0ms 12 716 417ms 0ms 13 716 391ms 0ms 14 718 399ms 0ms 15 716 384ms 0ms 16 716 391ms 0ms 17 718 395ms 0ms 18 716 383ms 0ms 19 718 404ms 0ms 20 716 383ms 0ms 21 716 389ms 0ms 22 718 394ms 0ms 23 716 395ms 0ms [ User: symmetricds - Total duration: 9s613ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s613ms - Times executed: 17199 ]
-
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-03-10 06:40:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 08:43:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 07:32:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 18ms 0ms 1,033 451ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 10 00 1,033 451ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 1033 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 1033 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1832' WHERE "patient_id" = '128539900';
-
UPDATE "public"."patients" SET "caloriesday" = '1368' WHERE "patient_id" = '170073';
-
UPDATE "public"."patients" SET "caloriesday" = '2726' WHERE "patient_id" = '137250';
Date: 2019-03-10 00:26:11 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:04:10 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:54:12 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 10ms 0ms 4,424 655ms 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 #10
Day Hour Count Duration Avg duration Mar 10 00 184 21ms 0ms 01 184 40ms 0ms 02 184 54ms 0ms 03 184 58ms 0ms 04 184 17ms 0ms 05 184 38ms 0ms 06 184 56ms 0ms 07 184 16ms 0ms 08 184 19ms 0ms 09 184 50ms 0ms 10 184 40ms 0ms 11 184 22ms 0ms 12 184 14ms 0ms 13 184 12ms 0ms 14 184 14ms 0ms 15 184 14ms 0ms 16 184 14ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 14ms 0ms 20 184 33ms 0ms 21 186 30ms 0ms 22 184 15ms 0ms 23 190 20ms 0ms [ User: symmetricds - Total duration: 655ms - Times executed: 4424 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 655ms - Times executed: 4424 ]
-
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 = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-03-10 06:06:40 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:05:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:32:41 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 0ms 0ms 6,172 681ms 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 #11
Day Hour Count Duration Avg duration Mar 10 00 240 27ms 0ms 01 240 25ms 0ms 02 237 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 236 26ms 0ms 06 239 27ms 0ms 07 240 27ms 0ms 08 240 26ms 0ms 09 237 26ms 0ms 10 239 26ms 0ms 11 240 28ms 0ms 12 236 27ms 0ms 13 256 26ms 0ms 14 285 30ms 0ms 15 284 31ms 0ms 16 285 31ms 0ms 17 275 28ms 0ms 18 276 28ms 0ms 19 288 31ms 0ms 20 286 30ms 0ms 21 283 31ms 0ms 22 271 29ms 0ms 23 280 30ms 0ms [ User: symmetricds - Total duration: 681ms - Times executed: 6172 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 681ms - Times executed: 6172 ]
-
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-03-10 21:41:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:23:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 23:48:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 17,302 875ms 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 Mar 10 00 720 35ms 0ms 01 720 35ms 0ms 02 720 35ms 0ms 03 720 36ms 0ms 04 722 35ms 0ms 05 720 36ms 0ms 06 720 36ms 0ms 07 722 36ms 0ms 08 720 35ms 0ms 09 720 35ms 0ms 10 720 36ms 0ms 11 722 36ms 0ms 12 720 36ms 0ms 13 720 36ms 0ms 14 722 36ms 0ms 15 720 36ms 0ms 16 720 36ms 0ms 17 722 36ms 0ms 18 720 36ms 0ms 19 722 37ms 0ms 20 720 36ms 0ms 21 722 37ms 0ms 22 722 38ms 0ms 23 726 37ms 0ms [ User: symmetricds - Total duration: 875ms - Times executed: 17302 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 875ms - Times executed: 17302 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-03-10 22:58:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 20:03:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 17:01:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 21,336 1s78ms 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 #13
Day Hour Count Duration Avg duration Mar 10 00 889 33ms 0ms 01 889 45ms 0ms 02 889 34ms 0ms 03 889 40ms 0ms 04 889 53ms 0ms 05 889 45ms 0ms 06 889 45ms 0ms 07 889 44ms 0ms 08 889 44ms 0ms 09 889 44ms 0ms 10 889 45ms 0ms 11 889 44ms 0ms 12 889 44ms 0ms 13 889 45ms 0ms 14 889 45ms 0ms 15 889 48ms 0ms 16 889 43ms 0ms 17 889 45ms 0ms 18 889 44ms 0ms 19 889 46ms 0ms 20 889 50ms 0ms 21 889 51ms 0ms 22 889 44ms 0ms 23 889 44ms 0ms [ User: pharmisight - Total duration: 1s78ms - Times executed: 21336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s78ms - Times executed: 21336 ]
-
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 = '33052849' 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 = '33073043' 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 = '3179' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-03-10 19:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 10:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 24,096 1s204ms 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 #14
Day Hour Count Duration Avg duration Mar 10 00 1,004 37ms 0ms 01 1,004 51ms 0ms 02 1,004 37ms 0ms 03 1,004 45ms 0ms 04 1,004 59ms 0ms 05 1,004 50ms 0ms 06 1,004 51ms 0ms 07 1,004 50ms 0ms 08 1,004 50ms 0ms 09 1,004 49ms 0ms 10 1,004 50ms 0ms 11 1,004 49ms 0ms 12 1,004 50ms 0ms 13 1,004 50ms 0ms 14 1,004 50ms 0ms 15 1,004 53ms 0ms 16 1,004 49ms 0ms 17 1,004 50ms 0ms 18 1,004 49ms 0ms 19 1,004 50ms 0ms 20 1,004 55ms 0ms 21 1,004 57ms 0ms 22 1,004 50ms 0ms 23 1,004 50ms 0ms [ User: pharmisight - Total duration: 1s204ms - Times executed: 24096 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s204ms - Times executed: 24096 ]
-
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 = '33074043' 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 = '3360' 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 = '2927' ORDER BY itemcodes0_.code ASC;
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 01:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 6,172 307ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 10 00 240 12ms 0ms 01 240 12ms 0ms 02 237 11ms 0ms 03 239 12ms 0ms 04 240 12ms 0ms 05 236 12ms 0ms 06 239 12ms 0ms 07 240 12ms 0ms 08 240 12ms 0ms 09 237 12ms 0ms 10 239 12ms 0ms 11 240 13ms 0ms 12 236 12ms 0ms 13 256 12ms 0ms 14 285 13ms 0ms 15 284 14ms 0ms 16 285 13ms 0ms 17 275 12ms 0ms 18 276 12ms 0ms 19 288 13ms 0ms 20 286 13ms 0ms 21 283 13ms 0ms 22 271 13ms 0ms 23 280 13ms 0ms [ User: symmetricds - Total duration: 307ms - Times executed: 6172 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 307ms - Times executed: 6172 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
Date: 2019-03-10 22:37:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 15:17:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:33:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 25,166 1s212ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 10 00 1,136 52ms 0ms 01 1,044 49ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,046 49ms 0ms 05 1,044 49ms 0ms 06 1,044 50ms 0ms 07 1,046 50ms 0ms 08 1,044 48ms 0ms 09 1,044 49ms 0ms 10 1,044 49ms 0ms 11 1,046 49ms 0ms 12 1,044 47ms 0ms 13 1,044 49ms 0ms 14 1,046 49ms 0ms 15 1,044 50ms 0ms 16 1,044 51ms 0ms 17 1,046 50ms 0ms 18 1,044 52ms 0ms 19 1,046 55ms 0ms 20 1,038 51ms 0ms 21 1,048 50ms 0ms 22 1,046 52ms 0ms 23 1,050 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 25166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 25166 ]
-
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-03-10 22:45:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:40:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:39:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 8,599 404ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 10 00 358 16ms 0ms 01 358 16ms 0ms 02 358 17ms 0ms 03 358 17ms 0ms 04 359 16ms 0ms 05 358 17ms 0ms 06 358 17ms 0ms 07 359 17ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 17ms 0ms 11 359 17ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 359 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 359 16ms 0ms 18 358 17ms 0ms 19 359 17ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 17ms 0ms [ User: symmetricds - Total duration: 404ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 8599 ]
-
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-03-10 18:04:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 19:47:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 05:02:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 2,388 108ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 10 00 1,284 29ms 0ms 01 48 3ms 0ms 02 48 3ms 0ms 03 48 4ms 0ms 04 48 3ms 0ms 05 48 3ms 0ms 06 48 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 3ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 3ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 36 2ms 0ms 21 52 2ms 0ms 22 48 2ms 0ms 23 56 2ms 0ms [ User: symmetricds - Total duration: 108ms - Times executed: 2388 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 108ms - Times executed: 2388 ]
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-03-10 21:11:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 11:38:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:54:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 8,599 301ms 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 #19
Day Hour Count Duration Avg duration Mar 10 00 358 11ms 0ms 01 358 11ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 359 11ms 0ms 12 358 12ms 0ms 13 358 13ms 0ms 14 359 13ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 359 12ms 0ms 18 358 13ms 0ms 19 359 12ms 0ms 20 358 12ms 0ms 21 358 13ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms [ User: symmetricds - Total duration: 301ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 301ms - Times executed: 8599 ]
-
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-03-10 18:45:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 13:37:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 14:11:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 17ms 0ms 134,729 4s406ms COMMIT;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 00 6,655 635ms 0ms 01 5,521 163ms 0ms 02 5,515 164ms 0ms 03 5,517 182ms 0ms 04 5,528 162ms 0ms 05 5,513 165ms 0ms 06 5,521 160ms 0ms 07 5,533 159ms 0ms 08 5,523 158ms 0ms 09 5,517 158ms 0ms 10 5,525 166ms 0ms 11 5,536 164ms 0ms 12 5,519 167ms 0ms 13 5,560 154ms 0ms 14 5,632 162ms 0ms 15 5,621 174ms 0ms 16 5,623 160ms 0ms 17 5,610 157ms 0ms 18 5,605 157ms 0ms 19 5,607 153ms 0ms 20 5,596 152ms 0ms 21 5,650 167ms 0ms 22 5,616 167ms 0ms 23 5,686 190ms 0ms [ User: symmetricds - Total duration: 4s389ms - Times executed: 134471 ]
[ User: pharmisight - Total duration: 17ms - Times executed: 258 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s406ms - Times executed: 134729 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-03-10 00:12:10 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 00:37:11 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-03-10 03:09:05 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,143,658 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