pgBadger-
Global information
- Generated on Sun Apr 21 00:00:22 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,212,896 log entries in 20s
- Log start from 2019-04-20 00:00:00 to 2019-04-20 23:59:59
-
Overview
Global Stats
- 209 Number of unique normalized queries
- 1,095,615 Number of queries
- 55s745ms Total query duration
- 2019-04-20 00:00:00 First query
- 2019-04-20 23:59:59 Last query
- 1,511 queries/s at 2019-04-20 18:40:00 Query peak
- 2 Number of events
- 2 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 52 Total number of automatic vacuums
- 79 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,821 Total number of sessions
- 1 sessions at 2019-04-20 06:21:28 Session peak
- 10d1h32m13s Total duration of sessions
- 7m57s Average duration of sessions
- 601 Average queries per session
- 30ms Average queries duration per session
- 1,821 Total number of connections
- 5 connections/s at 2019-04-20 00:30:36 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,511 queries/s Query Peak
- 2019-04-20 18:40:00 Date
SELECT Traffic
Key values
- 1,493 queries/s Query Peak
- 2019-04-20 21:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 382 queries/s Query Peak
- 2019-04-20 03:20:05 Date
Queries duration
Key values
- 55s745ms Total query duration
Prepared queries ratio
Key values
- 1.56 Ratio of bind vs prepare
- 168.44 % 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) Apr 20 00 54,517 0ms 79ms 0ms 86ms 95ms 1s98ms 01 45,859 0ms 81ms 0ms 66ms 104ms 392ms 02 46,416 0ms 79ms 0ms 51ms 160ms 448ms 03 46,600 0ms 80ms 0ms 48ms 183ms 468ms 04 44,994 0ms 78ms 0ms 60ms 87ms 429ms 05 44,240 0ms 77ms 0ms 61ms 63ms 341ms 06 44,900 0ms 63ms 0ms 44ms 58ms 506ms 07 46,586 0ms 152ms 0ms 48ms 219ms 721ms 08 45,057 0ms 60ms 0ms 54ms 99ms 359ms 09 45,025 0ms 62ms 0ms 61ms 97ms 363ms 10 45,461 0ms 99ms 0ms 54ms 135ms 386ms 11 47,047 0ms 130ms 0ms 78ms 213ms 393ms 12 44,718 0ms 59ms 0ms 51ms 56ms 342ms 13 44,598 0ms 99ms 0ms 44ms 59ms 468ms 14 44,826 0ms 86ms 0ms 42ms 54ms 327ms 15 44,712 0ms 78ms 0ms 52ms 61ms 241ms 16 44,712 0ms 68ms 0ms 46ms 59ms 208ms 17 44,744 0ms 59ms 0ms 48ms 57ms 166ms 18 44,557 0ms 53ms 0ms 51ms 57ms 132ms 19 44,823 0ms 30ms 0ms 52ms 82ms 131ms 20 47,134 0ms 42ms 0ms 48ms 134ms 460ms 21 44,542 0ms 58ms 0ms 42ms 69ms 132ms 22 44,707 0ms 50ms 0ms 53ms 55ms 133ms 23 44,840 0ms 53ms 0ms 48ms 55ms 131ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 20 00 19,206 0 0ms 24ms 40ms 525ms 01 15,069 0 0ms 24ms 37ms 128ms 02 15,064 0 0ms 24ms 33ms 150ms 03 15,107 0 0ms 25ms 32ms 134ms 04 14,788 0 0ms 23ms 33ms 105ms 05 14,602 0 0ms 22ms 43ms 118ms 06 14,775 0 0ms 23ms 30ms 123ms 07 15,096 0 0ms 25ms 33ms 135ms 08 14,794 0 0ms 25ms 34ms 92ms 09 14,804 0 0ms 23ms 30ms 114ms 10 14,854 0 0ms 23ms 37ms 102ms 11 15,392 0 0ms 25ms 39ms 160ms 12 14,635 0 0ms 18ms 34ms 68ms 13 14,603 0 0ms 18ms 30ms 57ms 14 14,664 0 0ms 20ms 29ms 52ms 15 14,615 0 0ms 18ms 30ms 45ms 16 14,609 0 0ms 17ms 33ms 43ms 17 14,633 0 0ms 18ms 30ms 41ms 18 14,579 0 0ms 18ms 35ms 40ms 19 14,688 0 0ms 18ms 30ms 71ms 20 17,125 0 0ms 19ms 30ms 135ms 21 14,550 0 0ms 19ms 25ms 53ms 22 14,624 0 0ms 18ms 27ms 39ms 23 14,663 0 0ms 18ms 28ms 40ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 20 00 432 1,962 116 0 0ms 17ms 22ms 28ms 01 650 272 120 0 0ms 2ms 7ms 46ms 02 1,188 353 121 0 0ms 1ms 7ms 71ms 03 1,316 385 120 0 0ms 1ms 7ms 70ms 04 356 137 118 0 0ms 1ms 7ms 26ms 05 88 54 117 0 1ms 1ms 6ms 7ms 06 356 129 118 0 0ms 1ms 7ms 19ms 07 1,236 365 111 0 0ms 1ms 6ms 68ms 08 392 146 106 0 0ms 1ms 7ms 37ms 09 300 131 102 0 0ms 1ms 7ms 15ms 10 676 217 100 0 0ms 1ms 6ms 29ms 11 1,118 350 100 0 0ms 1ms 7ms 57ms 12 88 53 92 0 1ms 1ms 5ms 7ms 13 88 54 90 0 2ms 1ms 3ms 7ms 14 88 53 89 0 1ms 1ms 2ms 7ms 15 88 54 85 0 1ms 1ms 3ms 7ms 16 88 54 84 0 1ms 1ms 3ms 7ms 17 88 53 84 0 0ms 1ms 2ms 7ms 18 83 53 80 0 0ms 1ms 5ms 7ms 19 110 73 82 0 0ms 1ms 4ms 7ms 20 113 87 116 0 0ms 0ms 1ms 7ms 21 82 50 79 0 0ms 1ms 1ms 7ms 22 88 54 81 0 0ms 1ms 4ms 7ms 23 88 53 82 0 0ms 1ms 3ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 20 00 32,944 54,481 1.65 93.05% 01 30,010 45,823 1.53 109.55% 02 30,023 46,380 1.54 107.53% 03 30,307 46,564 1.54 107.79% 04 30,119 44,958 1.49 113.45% 05 29,595 44,204 1.49 114.28% 06 30,118 44,864 1.49 113.75% 07 30,215 46,550 1.54 107.81% 08 29,927 45,021 1.50 112.56% 09 30,173 44,989 1.49 113.74% 10 29,788 45,425 1.52 110.35% 11 30,415 47,011 1.55 107.21% 12 28,158 44,682 1.59 107.78% 13 28,208 44,562 1.58 108.29% 14 28,397 44,790 1.58 108.54% 15 28,117 44,676 1.59 107.74% 16 28,036 44,676 1.59 107.48% 17 28,191 44,708 1.59 107.97% 18 28,173 44,521 1.58 108.37% 19 28,149 44,787 1.59 107.47% 20 28,219 47,098 1.67 98.65% 21 27,820 44,506 1.60 107.12% 22 28,379 44,671 1.57 108.76% 23 28,377 44,804 1.58 108.48% Day Hour Count Average / Second Apr 20 00 68 0.02/s 01 71 0.02/s 02 83 0.02/s 03 81 0.02/s 04 86 0.02/s 05 90 0.03/s 06 91 0.03/s 07 93 0.03/s 08 92 0.03/s 09 88 0.02/s 10 91 0.03/s 11 88 0.02/s 12 54 0.01/s 13 61 0.02/s 14 68 0.02/s 15 64 0.02/s 16 68 0.02/s 17 66 0.02/s 18 70 0.02/s 19 73 0.02/s 20 70 0.02/s 21 66 0.02/s 22 67 0.02/s 23 72 0.02/s Day Hour Count Average Duration Apr 20 00 68 9m31s 01 71 8m 02 83 7m41s 03 81 7m30s 04 86 7m8s 05 90 6m30s 06 91 6m28s 07 93 6m59s 08 92 6m28s 09 88 6m47s 10 91 6m34s 11 88 6m9s 12 54 10m12s 13 61 10m42s 14 68 9m28s 15 64 9m25s 16 68 8m36s 17 66 9m22s 18 70 8m8s 19 73 8m39s 20 70 8m21s 21 66 9m12s 22 67 8m57s 23 72 8m23s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2019-04-20 00:30:36 Date
Connections per database
Key values
- pharmisight Main Database
- 1,821 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,821 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-04-20 06:21:28 Date
Histogram of session times
Key values
- 1,135 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,821 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,821 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,821 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 4,927 buffers Checkpoint Peak
- 2019-04-20 06:07:25 Date
- 150.021 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2019-04-20 06:07:25 Date
Checkpoints distance
Key values
- 61.88 Mo Distance Peak
- 2019-04-20 07:07:25 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 20 00 2,099 210.523s 0.03s 210.613s 01 988 99.142s 0.027s 99.222s 02 761 76.243s 0.012s 76.304s 03 766 76.876s 0.014s 76.933s 04 689 69.025s 0.012s 69.087s 05 378 37.933s 0.01s 37.991s 06 5,311 188.175s 0.013s 188.238s 07 5,108 193.045s 0.011s 193.102s 08 1,467 146.972s 0.017s 147.031s 09 2,370 185.322s 0.021s 185.391s 10 1,525 152.303s 0.015s 152.365s 11 2,723 196.673s 0.018s 196.76s 12 1,362 136.182s 0.017s 136.241s 13 1,886 173.905s 0.011s 173.959s 14 1,213 121.686s 0.011s 121.739s 15 1,680 168.538s 0.016s 168.603s 16 1,495 149.54s 0.027s 149.62s 17 1,171 117.833s 0.016s 117.913s 18 1,436 143.735s 0.009s 143.79s 19 403 40.441s 0.01s 40.49s 20 422 42.325s 0.015s 42.388s 21 470 47.162s 0.007s 47.21s 22 347 34.813s 0.009s 34.867s 23 451 45.239s 0.009s 45.292s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 20 00 0 0 1 301 0.010s 0s 01 0 0 0 300 0.018s 0s 02 0 0 1 256 0.002s 0s 03 0 0 0 250 0.002s 0s 04 0 0 0 251 0.002s 0s 05 0 0 0 195 0.002s 0s 06 0 0 2 228 0.003s 0.001s 07 0 0 2 268 0.002s 0s 08 0 0 0 251 0.006s 0s 09 0 0 1 274 0.002s 0s 10 0 0 1 248 0.003s 0s 11 0 0 0 310 0.002s 0s 12 0 0 1 196 0.007s 0s 13 0 0 0 225 0.002s 0s 14 0 0 1 218 0.002s 0s 15 0 0 0 239 0.008s 0s 16 0 0 1 229 0.018s 0s 17 0 0 0 227 0.008s 0s 18 0 0 1 220 0.002s 0s 19 0 0 0 210 0.002s 0s 20 0 0 0 214 0.002s 0s 21 0 0 0 208 0.001s 0s 22 0 0 0 196 0.002s 0s 23 0 0 0 193 0.002s 0s Day Hour Count Avg time (sec) Apr 20 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 Apr 20 00 1,277.82 kB 1,576.45 kB 01 605.89 kB 1,696.22 kB 02 477.00 kB 1,188.33 kB 03 481.67 kB 1,203.89 kB 04 326.33 kB 969.67 kB 05 203.88 kB 522.50 kB 06 2,838.67 kB 16,227.78 kB 07 3,756.44 kB 21,658.11 kB 08 1,087.88 kB 9,410.50 kB 09 1,418.67 kB 7,899.89 kB 10 944.33 kB 4,982.44 kB 11 1,571.78 kB 8,368.00 kB 12 1,222.43 kB 5,808.71 kB 13 1,141.12 kB 5,923.62 kB 14 1,010.62 kB 5,230.75 kB 15 646.71 kB 2,818.57 kB 16 930.00 kB 3,056.12 kB 17 368.62 kB 2,346.12 kB 18 723.88 kB 2,449.00 kB 19 174.25 kB 1,145.50 kB 20 145.25 kB 559.25 kB 21 188.43 kB 409.86 kB 22 117.29 kB 301.43 kB 23 176.71 kB 345.71 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 Apr 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (16) Main table analyzed (database pharmisight)
- 79 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data 14 pharmisight.public.sym_data_event 13 pharmisight.public.sym_incoming_batch 13 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 3 pharmisight.public.stats_picker_months 1 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 Total 79 Vacuums per table
Key values
- public.sym_data (11) Main table vacuumed on database pharmisight
- 52 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_data 11 11 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.pg_toast.pg_toast_2619 1 1 Total 52 46 Tuples removed per table
Key values
- public.sym_data_event (34391) Main table with removed tuples on database pharmisight
- 62233 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 34391 719 pharmisight.public.sym_data 11 11 20301 0 pharmisight.public.sym_outgoing_batch 10 10 5445 0 pharmisight.public.sym_incoming_batch 6 6 854 0 pharmisight.pg_catalog.pg_statistic 2 2 544 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_toast.pg_toast_2619 1 1 81 0 pharmisight.public.sym_sequence 1 0 51 0 Total 52 46 62,233 719 Pages removed per table
Key values
- public.sym_data_event (719) Main table with removed pages on database pharmisight
- 719 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 34391 719 pharmisight.pg_catalog.pg_statistic 2 2 544 0 pharmisight.public.sym_data 11 11 20301 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.pg_toast.pg_toast_2619 1 1 81 0 pharmisight.public.sym_incoming_batch 6 6 854 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_outgoing_batch 10 10 5445 0 pharmisight.public.sym_node_host 5 0 260 0 Total 52 46 62,233 719 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 20 00 2 6 01 3 2 02 1 1 03 0 3 04 1 3 05 0 1 06 2 2 07 3 4 08 2 5 09 3 4 10 1 3 11 5 6 12 2 4 13 3 4 14 3 4 15 6 4 16 4 4 17 3 5 18 3 3 19 1 3 20 2 3 21 1 3 22 0 1 23 1 1 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 361,539 Total read queries
- 288,379 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,095,615 Requests
- 55s745ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,081,741 Requests
User Request type Count Duration pharmisight Total 57,623 5s501ms DELETE 38 3ms INSERT 1,713 997ms OTHERS 1,683 65ms SELECT 53,447 4s316ms TCL 676 85ms UPDATE 66 33ms symmetricds Total 1,081,741 51s883ms DELETE 2,425 5s11ms INSERT 7,583 999ms OTHERS 462,546 7s312ms SELECT 321,817 29s394ms TCL 282,180 5s972ms UPDATE 5,190 3s193ms tony Total 900 279ms SELECT 900 279ms Duration by user
Key values
- 51s883ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 57,623 5s501ms DELETE 38 3ms INSERT 1,713 997ms OTHERS 1,683 65ms SELECT 53,447 4s316ms TCL 676 85ms UPDATE 66 33ms symmetricds Total 1,081,741 51s883ms DELETE 2,425 5s11ms INSERT 7,583 999ms OTHERS 462,546 7s312ms SELECT 321,817 29s394ms TCL 282,180 5s972ms UPDATE 5,190 3s193ms tony Total 900 279ms SELECT 900 279ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,139,364 Requests
- 57s384ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,093,218 Requests
- 55s413ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-04-20 04:34:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,091,841 0-1ms duration
Slowest individual queries
Rank Duration Query 1 152ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8798832' AND '8799461' AND status != 'OK') AND batch_id BETWEEN '8798832' AND '8799461';[ Date: 2019-04-20 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 130ms 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_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT '20';[ Date: 2019-04-20 11:50:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 99ms DELETE FROM sym_data WHERE data_id BETWEEN '99846389' AND '99851389' AND create_time < '2019-04-19 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 99ms DELETE FROM sym_data WHERE data_id BETWEEN '99865159' AND '99870159' AND create_time < '2019-04-19 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 86ms DELETE FROM sym_data WHERE data_id BETWEEN '99871638' AND '99876638' AND create_time < '2019-04-19 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 81ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 80ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 79ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 79ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 78ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 78ms DELETE FROM sym_data WHERE data_id BETWEEN '99876784' AND '99881784' AND create_time < '2019-04-19 15:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99876784' AND '99881784') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99876784' AND '99881784' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 77ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 73ms SELECT count(*) AS col_0_0_ FROM ORDER_ROUNDS orderround0_;[ Date: 2019-04-20 11:50:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 68ms DELETE FROM sym_data WHERE data_id BETWEEN '99880686' AND '99885686' AND create_time < '2019-04-19 16:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99880686' AND '99885686') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99880686' AND '99885686' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 63ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-20 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 62ms DELETE FROM sym_data WHERE data_id BETWEEN '99839954' AND '99844954' AND create_time < '2019-04-19 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99839954' AND '99844954') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99839954' AND '99844954' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 60ms DELETE FROM sym_data WHERE data_id BETWEEN '99834003' AND '99839003' AND create_time < '2019-04-19 08:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99834003' AND '99839003') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99834003' AND '99839003' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 60ms DELETE FROM sym_data WHERE data_id BETWEEN '99870160' AND '99875160' AND create_time < '2019-04-19 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99870160' AND '99875160') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99870160' AND '99875160' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 59ms DELETE FROM sym_data WHERE data_id BETWEEN '99852223' AND '99857223' AND create_time < '2019-04-19 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99852223' AND '99857223') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99852223' AND '99857223' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 59ms DELETE FROM sym_data WHERE data_id BETWEEN '99884911' AND '99889911' AND create_time < '2019-04-19 17:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99884911' AND '99889911') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99884911' AND '99889911' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-20 17:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9s789ms 17,199 0ms 5ms 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 Apr 20 01 717 409ms 0ms 02 716 423ms 0ms 03 718 414ms 0ms 04 716 420ms 0ms 05 716 415ms 0ms 06 716 414ms 0ms 07 716 414ms 0ms 08 718 418ms 0ms 09 716 420ms 0ms 10 716 408ms 0ms 11 716 411ms 0ms 12 718 405ms 0ms 13 716 398ms 0ms 14 716 403ms 0ms 15 718 403ms 0ms 16 716 392ms 0ms 17 716 396ms 0ms 18 718 403ms 0ms 19 716 397ms 0ms 20 716 396ms 0ms 21 718 406ms 0ms 22 716 409ms 0ms 23 716 400ms 0ms 00 718 405ms 0ms [ User: symmetricds - Total duration: 9s789ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s789ms - 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-04-20 08:07:29 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:33:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:53:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s695ms 424,158 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 20 01 18,239 281ms 0ms 02 17,562 278ms 0ms 03 17,568 274ms 0ms 04 17,557 274ms 0ms 05 17,524 272ms 0ms 06 17,427 274ms 0ms 07 17,495 272ms 0ms 08 17,611 275ms 0ms 09 17,534 272ms 0ms 10 17,561 273ms 0ms 11 17,532 272ms 0ms 12 17,723 276ms 0ms 13 17,748 281ms 0ms 14 17,691 282ms 0ms 15 17,787 282ms 0ms 16 17,753 287ms 0ms 17 17,755 283ms 0ms 18 17,763 288ms 0ms 19 17,685 279ms 0ms 20 17,746 283ms 0ms 21 17,651 280ms 0ms 22 17,705 283ms 0ms 23 17,744 280ms 0ms 00 17,797 285ms 0ms [ User: symmetricds - Total duration: 6s671ms - Times executed: 423607 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s695ms - Times executed: 424158 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-04-20 23:44:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:49:43 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 16:12:43 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s922ms 135,796 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 20 01 6,844 788ms 0ms 02 5,642 242ms 0ms 03 5,597 188ms 0ms 04 5,595 198ms 0ms 05 5,575 198ms 0ms 06 5,518 180ms 0ms 07 5,549 175ms 0ms 08 5,610 188ms 0ms 09 5,575 180ms 0ms 10 5,596 202ms 0ms 11 5,574 191ms 0ms 12 5,705 209ms 0ms 13 5,629 162ms 0ms 14 5,607 165ms 0ms 15 5,634 166ms 0ms 16 5,628 178ms 0ms 17 5,625 160ms 0ms 18 5,626 165ms 0ms 19 5,601 159ms 0ms 20 5,620 167ms 0ms 21 5,582 152ms 0ms 22 5,605 153ms 0ms 23 5,623 180ms 0ms 00 5,636 163ms 0ms [ User: symmetricds - Total duration: 4s840ms - Times executed: 135466 ]
[ User: pharmisight - Total duration: 82ms - Times executed: 330 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s922ms - Times executed: 135796 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-04-20 15:01:46 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:21:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:45:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s138ms 227 1ms 99ms 13ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 20 01 19 124ms 6ms 02 19 121ms 6ms 03 19 117ms 6ms 04 19 120ms 6ms 05 19 141ms 7ms 06 19 115ms 6ms 07 19 292ms 15ms 08 18 257ms 14ms 09 12 138ms 11ms 10 11 135ms 12ms 11 10 160ms 16ms 12 9 129ms 14ms 13 7 194ms 27ms 14 6 288ms 48ms 15 5 190ms 38ms 16 4 132ms 33ms 17 3 104ms 34ms 18 2 77ms 38ms 19 2 58ms 29ms 20 1 30ms 30ms 21 1 42ms 42ms 22 1 58ms 58ms 23 1 50ms 50ms 00 1 53ms 53ms [ User: symmetricds - Total duration: 3s138ms - Times executed: 227 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s138ms - Times executed: 227 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99846389' AND '99851389' AND create_time < '2019-04-19 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99865159' AND '99870159' AND create_time < '2019-04-19 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99871638' AND '99876638' AND create_time < '2019-04-19 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-04-20 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 13:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 14:00:00 Duration: 86ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s803ms 156,116 0ms 3ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 20 01 8,113 89ms 0ms 02 6,499 75ms 0ms 03 6,460 73ms 0ms 04 6,453 77ms 0ms 05 6,422 73ms 0ms 06 6,365 72ms 0ms 07 6,405 72ms 0ms 08 6,460 74ms 0ms 09 6,413 72ms 0ms 10 6,430 74ms 0ms 11 6,409 72ms 0ms 12 6,507 74ms 0ms 13 6,445 74ms 0ms 14 6,427 76ms 0ms 15 6,460 76ms 0ms 16 6,438 74ms 0ms 17 6,439 74ms 0ms 18 6,447 76ms 0ms 19 6,408 73ms 0ms 20 6,435 74ms 0ms 21 6,383 72ms 0ms 22 6,409 74ms 0ms 23 6,434 75ms 0ms 00 6,455 75ms 0ms [ User: symmetricds - Total duration: 1s803ms - Times executed: 156116 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s803ms - Times executed: 156116 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-04-20 03:02:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 14:08:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 16:11:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s396ms 960 0ms 3ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 20 01 39 58ms 1ms 02 52 74ms 1ms 03 53 76ms 1ms 04 57 83ms 1ms 05 54 80ms 1ms 06 54 77ms 1ms 07 56 81ms 1ms 08 55 80ms 1ms 09 53 77ms 1ms 10 55 80ms 1ms 11 53 76ms 1ms 12 51 74ms 1ms 13 27 38ms 1ms 14 28 40ms 1ms 15 29 41ms 1ms 16 26 38ms 1ms 17 25 36ms 1ms 18 27 39ms 1ms 19 28 40ms 1ms 20 27 38ms 1ms 21 29 42ms 1ms 22 24 36ms 1ms 23 29 41ms 1ms 00 29 42ms 1ms [ User: symmetricds - Total duration: 1s396ms - Times executed: 960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s396ms - Times executed: 960 ]
-
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-04-20 09:43:40 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:15:38 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:21:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s255ms 25,224 0ms 2ms 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 Apr 20 01 1,140 56ms 0ms 02 1,052 51ms 0ms 03 1,050 51ms 0ms 04 1,050 50ms 0ms 05 1,048 51ms 0ms 06 1,042 51ms 0ms 07 1,048 50ms 0ms 08 1,056 50ms 0ms 09 1,050 51ms 0ms 10 1,054 51ms 0ms 11 1,050 51ms 0ms 12 1,058 51ms 0ms 13 1,044 54ms 0ms 14 1,044 53ms 0ms 15 1,046 52ms 0ms 16 1,044 50ms 0ms 17 1,044 51ms 0ms 18 1,046 54ms 0ms 19 1,044 53ms 0ms 20 1,044 55ms 0ms 21 1,038 51ms 0ms 22 1,042 54ms 0ms 23 1,044 52ms 0ms 00 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25224 ]
-
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-04-20 12:44:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 19:14:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s163ms 1,245 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 20 01 55 50ms 0ms 02 66 62ms 0ms 03 71 67ms 0ms 04 73 69ms 0ms 05 67 61ms 0ms 06 66 61ms 0ms 07 70 66ms 0ms 08 70 64ms 0ms 09 72 68ms 0ms 10 65 61ms 0ms 11 68 63ms 0ms 12 71 65ms 0ms 13 33 31ms 0ms 14 38 35ms 0ms 15 39 36ms 0ms 16 35 32ms 0ms 17 32 30ms 0ms 18 35 32ms 0ms 19 37 34ms 0ms 20 39 36ms 0ms 21 38 35ms 0ms 22 30 27ms 0ms 23 35 32ms 0ms 00 40 36ms 0ms [ User: symmetricds - Total duration: 1s163ms - Times executed: 1245 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s163ms - Times executed: 1245 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13 UNION ALL SELECT 16852, 3) 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-04-20 01:57:39 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:00:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:09:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s142ms 24,120 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 #9
Day Hour Count Duration Avg duration Apr 20 01 1,005 31ms 0ms 02 1,005 35ms 0ms 03 1,005 51ms 0ms 04 1,005 39ms 0ms 05 1,005 39ms 0ms 06 1,005 46ms 0ms 07 1,005 42ms 0ms 08 1,005 50ms 0ms 09 1,005 50ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 51ms 0ms 13 1,005 46ms 0ms 14 1,005 49ms 0ms 15 1,005 50ms 0ms 16 1,005 51ms 0ms 17 1,005 52ms 0ms 18 1,005 50ms 0ms 19 1,005 50ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 49ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s142ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s142ms - Times executed: 24120 ]
-
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 = '33074255' 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 = '3364' 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 = '3504' ORDER BY itemcodes0_.code ASC;
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s67ms 157 3ms 13ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 20 01 98 695ms 7ms 02 4 23ms 5ms 03 3 13ms 4ms 04 3 17ms 5ms 05 3 13ms 4ms 06 2 13ms 6ms 07 3 21ms 7ms 08 3 17ms 5ms 09 3 17ms 5ms 10 3 17ms 5ms 11 3 26ms 8ms 12 5 35ms 7ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 12ms 6ms 16 2 13ms 6ms 17 2 12ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 12ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 751ms - Times executed: 112 ]
[ User: pharmisight - Total duration: 316ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s67ms - Times executed: 157 ]
-
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 = '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;
Date: 2019-04-20 00:30:40 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:30:40 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s51ms 209 0ms 27ms 5ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 20 01 19 82ms 4ms 02 19 81ms 4ms 03 19 81ms 4ms 04 19 81ms 4ms 05 19 80ms 4ms 06 19 79ms 4ms 07 18 71ms 3ms 08 12 48ms 4ms 09 11 43ms 3ms 10 10 39ms 3ms 11 9 34ms 3ms 12 7 29ms 4ms 13 6 25ms 4ms 14 5 73ms 14ms 15 4 42ms 10ms 16 3 28ms 9ms 17 2 20ms 10ms 18 2 10ms 5ms 19 1 2ms 2ms 20 1 7ms 7ms 21 1 7ms 7ms 22 1 27ms 27ms 23 1 25ms 25ms 00 1 25ms 25ms [ User: symmetricds - Total duration: 1s51ms - Times executed: 209 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s51ms - Times executed: 209 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892123' AND '99894055' AND data_id < '99894058' AND create_time < '2019-04-19 21:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892123' AND '99894055');
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892149' AND '99894078' AND data_id < '99894081' AND create_time < '2019-04-19 23:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894078');
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892135' AND '99894066' AND data_id < '99894069' AND create_time < '2019-04-19 22:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892135' AND '99894066');
Date: 2019-04-20 21:00:00 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 23:00:00 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:00:00 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s23ms 21,360 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 #12
Day Hour Count Duration Avg duration Apr 20 01 890 27ms 0ms 02 890 31ms 0ms 03 890 45ms 0ms 04 890 35ms 0ms 05 890 35ms 0ms 06 890 41ms 0ms 07 890 38ms 0ms 08 890 46ms 0ms 09 890 44ms 0ms 10 890 45ms 0ms 11 890 45ms 0ms 12 890 45ms 0ms 13 890 41ms 0ms 14 890 44ms 0ms 15 890 44ms 0ms 16 890 47ms 0ms 17 890 46ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s23ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s23ms - Times executed: 21360 ]
-
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 = '32994452' 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 = '1860' 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 = '3364' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-20 07:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 985ms 1,646 0ms 14ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 20 02 134 82ms 0ms 03 272 160ms 0ms 04 304 164ms 0ms 05 65 50ms 0ms 07 66 20ms 0ms 08 284 166ms 0ms 09 74 59ms 0ms 10 50 48ms 0ms 11 145 97ms 0ms 12 252 135ms 0ms [ User: pharmisight - Total duration: 985ms - Times executed: 1646 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 985ms - Times executed: 1646 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005460432', '2019-04-20 07:36:38', 'AMBROSZWICSM', '2019-04-20 07:00:00.041', '88670', '12', '150505230140191258');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005466040', '2019-04-20 03:15:29', 'DRAGONM', '2019-04-20 02:40:02.352', '115263', '1', '31237090373935001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005465981', '2019-04-20 02:17:07', 'DZIEMIN', '2019-04-20 01:40:01.596', '71545', '24', '31237090373799001');
Date: 2019-04-20 07:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 02:40:02 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:40:01 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 951ms 187 0ms 9ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 20 01 8 34ms 4ms 02 8 41ms 5ms 03 8 34ms 4ms 04 8 45ms 5ms 05 8 43ms 5ms 06 8 49ms 6ms 07 8 49ms 6ms 08 8 48ms 6ms 09 8 40ms 5ms 10 8 49ms 6ms 11 8 38ms 4ms 12 8 46ms 5ms 13 8 43ms 5ms 14 8 33ms 4ms 15 8 40ms 5ms 16 8 33ms 4ms 17 8 41ms 5ms 18 8 35ms 4ms 19 8 40ms 5ms 20 8 38ms 4ms 21 4 14ms 3ms 22 7 40ms 5ms 23 8 35ms 4ms 00 8 29ms 3ms [ User: symmetricds - Total duration: 951ms - Times executed: 187 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 951ms - Times executed: 187 ]
-
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" = '460469544', "total_memory_bytes" = '748158976', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 16:44: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" = '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" = '529181128', "total_memory_bytes" = '757596160', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 05:58:47', "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" = '483975384', "total_memory_bytes" = '747634688', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 21:44:19', "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';
Date: 2019-04-20 16:44:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 05:59:21 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:45:04 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 913ms 17,348 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 20 01 720 37ms 0ms 02 726 38ms 0ms 03 728 38ms 0ms 04 726 38ms 0ms 05 724 38ms 0ms 06 720 37ms 0ms 07 722 38ms 0ms 08 728 38ms 0ms 09 724 37ms 0ms 10 726 38ms 0ms 11 724 37ms 0ms 12 732 38ms 0ms 13 720 38ms 0ms 14 720 38ms 0ms 15 722 38ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 38ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 722 37ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 913ms - Times executed: 17348 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 913ms - Times executed: 17348 ]
-
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 = '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';
Date: 2019-04-20 11:43:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:31:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:48:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 912ms 973 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 20 01 42 39ms 0ms 02 53 50ms 0ms 03 56 52ms 0ms 04 58 55ms 0ms 05 55 52ms 0ms 06 53 50ms 0ms 07 57 54ms 0ms 08 56 52ms 0ms 09 54 50ms 0ms 10 54 50ms 0ms 11 54 50ms 0ms 12 52 48ms 0ms 13 27 24ms 0ms 14 28 25ms 0ms 15 29 26ms 0ms 16 26 25ms 0ms 17 25 23ms 0ms 18 27 24ms 0ms 19 28 25ms 0ms 20 27 24ms 0ms 21 29 26ms 0ms 22 25 22ms 0ms 23 29 26ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 912ms - Times executed: 973 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 973 ]
-
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-04-20 15:37:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:07:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 06:07:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 904ms 135,797 0ms 3ms 0ms BEGIN;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 20 01 6,845 45ms 0ms 02 5,642 36ms 0ms 03 5,597 36ms 0ms 04 5,595 36ms 0ms 05 5,575 40ms 0ms 06 5,518 36ms 0ms 07 5,550 36ms 0ms 08 5,609 36ms 0ms 09 5,575 36ms 0ms 10 5,596 36ms 0ms 11 5,574 36ms 0ms 12 5,705 40ms 0ms 13 5,629 36ms 0ms 14 5,607 36ms 0ms 15 5,634 36ms 0ms 16 5,628 37ms 0ms 17 5,625 37ms 0ms 18 5,626 37ms 0ms 19 5,601 37ms 0ms 20 5,620 38ms 0ms 21 5,582 39ms 0ms 22 5,605 37ms 0ms 23 5,623 37ms 0ms 00 5,636 36ms 0ms [ User: symmetricds - Total duration: 901ms - Times executed: 135466 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 331 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 135797 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-04-20 04:20:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 20:12:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 11:33:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 843ms 953 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 20 01 42 36ms 0ms 02 51 45ms 0ms 03 54 47ms 0ms 04 57 50ms 0ms 05 54 47ms 0ms 06 51 45ms 0ms 07 56 51ms 0ms 08 52 45ms 0ms 09 52 45ms 0ms 10 54 47ms 0ms 11 51 45ms 0ms 12 50 43ms 0ms 13 27 23ms 0ms 14 28 24ms 0ms 15 29 25ms 0ms 16 26 22ms 0ms 17 25 22ms 0ms 18 27 24ms 0ms 19 28 24ms 0ms 20 27 23ms 0ms 21 29 25ms 0ms 22 25 22ms 0ms 23 29 25ms 0ms 00 29 25ms 0ms [ User: symmetricds - Total duration: 843ms - Times executed: 953 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 843ms - Times executed: 953 ]
-
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-04-20 06:43:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 10:55:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 17:21:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 819ms 1,607 0ms 27ms 0ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 20 01 1,564 758ms 0ms 02 43 61ms 1ms [ User: symmetricds - Total duration: 819ms - Times executed: 1607 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 819ms - Times executed: 1607 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1489' WHERE "patient_id" = '205969';
-
UPDATE "public"."patients" SET "caloriesday" = '2845' WHERE "patient_id" = '200226010';
-
UPDATE "public"."patients" SET "caloriesday" = '1578' WHERE "patient_id" = '200097490';
Date: 2019-04-20 01:01:09 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:02:08 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:35:07 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 790ms 24 1ms 81ms 32ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 20 01 1 79ms 79ms 02 1 81ms 81ms 03 1 79ms 79ms 04 1 80ms 80ms 05 1 78ms 78ms 06 1 77ms 77ms 07 1 63ms 63ms 08 1 45ms 45ms 09 1 31ms 31ms 10 1 44ms 44ms 11 1 24ms 24ms 12 1 34ms 34ms 13 1 17ms 17ms 14 1 15ms 15ms 15 1 10ms 10ms 16 1 8ms 8ms 17 1 5ms 5ms 18 1 3ms 3ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 1ms 1ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 790ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 790ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-04-20 01:00:00 Duration: 81ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:00:00 Duration: 80ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 02:00:00 Duration: 79ms 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 424,158 6s695ms 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 20 01 18,239 281ms 0ms 02 17,562 278ms 0ms 03 17,568 274ms 0ms 04 17,557 274ms 0ms 05 17,524 272ms 0ms 06 17,427 274ms 0ms 07 17,495 272ms 0ms 08 17,611 275ms 0ms 09 17,534 272ms 0ms 10 17,561 273ms 0ms 11 17,532 272ms 0ms 12 17,723 276ms 0ms 13 17,748 281ms 0ms 14 17,691 282ms 0ms 15 17,787 282ms 0ms 16 17,753 287ms 0ms 17 17,755 283ms 0ms 18 17,763 288ms 0ms 19 17,685 279ms 0ms 20 17,746 283ms 0ms 21 17,651 280ms 0ms 22 17,705 283ms 0ms 23 17,744 280ms 0ms 00 17,797 285ms 0ms [ User: symmetricds - Total duration: 6s671ms - Times executed: 423607 ]
[ User: pharmisight - Total duration: 23ms - Times executed: 551 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s695ms - Times executed: 424158 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-04-20 23:44:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:49:43 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 16:12:43 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 156,116 1s803ms 0ms 3ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 20 01 8,113 89ms 0ms 02 6,499 75ms 0ms 03 6,460 73ms 0ms 04 6,453 77ms 0ms 05 6,422 73ms 0ms 06 6,365 72ms 0ms 07 6,405 72ms 0ms 08 6,460 74ms 0ms 09 6,413 72ms 0ms 10 6,430 74ms 0ms 11 6,409 72ms 0ms 12 6,507 74ms 0ms 13 6,445 74ms 0ms 14 6,427 76ms 0ms 15 6,460 76ms 0ms 16 6,438 74ms 0ms 17 6,439 74ms 0ms 18 6,447 76ms 0ms 19 6,408 73ms 0ms 20 6,435 74ms 0ms 21 6,383 72ms 0ms 22 6,409 74ms 0ms 23 6,434 75ms 0ms 00 6,455 75ms 0ms [ User: symmetricds - Total duration: 1s803ms - Times executed: 156116 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s803ms - Times executed: 156116 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-04-20 03:02:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 14:08:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 16:11:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 135,797 904ms 0ms 3ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 20 01 6,845 45ms 0ms 02 5,642 36ms 0ms 03 5,597 36ms 0ms 04 5,595 36ms 0ms 05 5,575 40ms 0ms 06 5,518 36ms 0ms 07 5,550 36ms 0ms 08 5,609 36ms 0ms 09 5,575 36ms 0ms 10 5,596 36ms 0ms 11 5,574 36ms 0ms 12 5,705 40ms 0ms 13 5,629 36ms 0ms 14 5,607 36ms 0ms 15 5,634 36ms 0ms 16 5,628 37ms 0ms 17 5,625 37ms 0ms 18 5,626 37ms 0ms 19 5,601 37ms 0ms 20 5,620 38ms 0ms 21 5,582 39ms 0ms 22 5,605 37ms 0ms 23 5,623 37ms 0ms 00 5,636 36ms 0ms [ User: symmetricds - Total duration: 901ms - Times executed: 135466 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 331 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 135797 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-04-20 04:20:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 20:12:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 11:33:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 135,796 4s922ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 20 01 6,844 788ms 0ms 02 5,642 242ms 0ms 03 5,597 188ms 0ms 04 5,595 198ms 0ms 05 5,575 198ms 0ms 06 5,518 180ms 0ms 07 5,549 175ms 0ms 08 5,610 188ms 0ms 09 5,575 180ms 0ms 10 5,596 202ms 0ms 11 5,574 191ms 0ms 12 5,705 209ms 0ms 13 5,629 162ms 0ms 14 5,607 165ms 0ms 15 5,634 166ms 0ms 16 5,628 178ms 0ms 17 5,625 160ms 0ms 18 5,626 165ms 0ms 19 5,601 159ms 0ms 20 5,620 167ms 0ms 21 5,582 152ms 0ms 22 5,605 153ms 0ms 23 5,623 180ms 0ms 00 5,636 163ms 0ms [ User: symmetricds - Total duration: 4s840ms - Times executed: 135466 ]
[ User: pharmisight - Total duration: 82ms - Times executed: 330 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s922ms - Times executed: 135796 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-04-20 15:01:46 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:21:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:45:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,224 1s255ms 0ms 2ms 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 Apr 20 01 1,140 56ms 0ms 02 1,052 51ms 0ms 03 1,050 51ms 0ms 04 1,050 50ms 0ms 05 1,048 51ms 0ms 06 1,042 51ms 0ms 07 1,048 50ms 0ms 08 1,056 50ms 0ms 09 1,050 51ms 0ms 10 1,054 51ms 0ms 11 1,050 51ms 0ms 12 1,058 51ms 0ms 13 1,044 54ms 0ms 14 1,044 53ms 0ms 15 1,046 52ms 0ms 16 1,044 50ms 0ms 17 1,044 51ms 0ms 18 1,046 54ms 0ms 19 1,044 53ms 0ms 20 1,044 55ms 0ms 21 1,038 51ms 0ms 22 1,042 54ms 0ms 23 1,044 52ms 0ms 00 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25224 ]
-
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-04-20 12:44:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 19:14:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,120 1s142ms 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 Apr 20 01 1,005 31ms 0ms 02 1,005 35ms 0ms 03 1,005 51ms 0ms 04 1,005 39ms 0ms 05 1,005 39ms 0ms 06 1,005 46ms 0ms 07 1,005 42ms 0ms 08 1,005 50ms 0ms 09 1,005 50ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 51ms 0ms 13 1,005 46ms 0ms 14 1,005 49ms 0ms 15 1,005 50ms 0ms 16 1,005 51ms 0ms 17 1,005 52ms 0ms 18 1,005 50ms 0ms 19 1,005 50ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 49ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s142ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s142ms - Times executed: 24120 ]
-
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 = '33074255' 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 = '3364' 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 = '3504' ORDER BY itemcodes0_.code ASC;
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,360 1s23ms 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 Apr 20 01 890 27ms 0ms 02 890 31ms 0ms 03 890 45ms 0ms 04 890 35ms 0ms 05 890 35ms 0ms 06 890 41ms 0ms 07 890 38ms 0ms 08 890 46ms 0ms 09 890 44ms 0ms 10 890 45ms 0ms 11 890 45ms 0ms 12 890 45ms 0ms 13 890 41ms 0ms 14 890 44ms 0ms 15 890 44ms 0ms 16 890 47ms 0ms 17 890 46ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s23ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s23ms - Times executed: 21360 ]
-
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 = '32994452' 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 = '1860' 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 = '3364' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-20 07:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,348 913ms 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 20 01 720 37ms 0ms 02 726 38ms 0ms 03 728 38ms 0ms 04 726 38ms 0ms 05 724 38ms 0ms 06 720 37ms 0ms 07 722 38ms 0ms 08 728 38ms 0ms 09 724 37ms 0ms 10 726 38ms 0ms 11 724 37ms 0ms 12 732 38ms 0ms 13 720 38ms 0ms 14 720 38ms 0ms 15 722 38ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 38ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 722 37ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 913ms - Times executed: 17348 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 913ms - Times executed: 17348 ]
-
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 = '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';
Date: 2019-04-20 11:43:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:31:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:48:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,260 485ms 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 Apr 20 01 720 20ms 0ms 02 718 20ms 0ms 03 720 19ms 0ms 04 720 19ms 0ms 05 720 19ms 0ms 06 718 19ms 0ms 07 718 19ms 0ms 08 720 20ms 0ms 09 718 19ms 0ms 10 718 20ms 0ms 11 720 20ms 0ms 12 718 20ms 0ms 13 720 20ms 0ms 14 720 21ms 0ms 15 718 20ms 0ms 16 720 20ms 0ms 17 718 20ms 0ms 18 720 20ms 0ms 19 718 20ms 0ms 20 720 20ms 0ms 21 720 20ms 0ms 22 720 20ms 0ms 23 718 20ms 0ms 00 720 20ms 0ms [ User: symmetricds - Total duration: 485ms - Times executed: 17260 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 485ms - Times executed: 17260 ]
-
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-04-20 01:27:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 17:16:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:17:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,199 9s789ms 0ms 5ms 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 Apr 20 01 717 409ms 0ms 02 716 423ms 0ms 03 718 414ms 0ms 04 716 420ms 0ms 05 716 415ms 0ms 06 716 414ms 0ms 07 716 414ms 0ms 08 718 418ms 0ms 09 716 420ms 0ms 10 716 408ms 0ms 11 716 411ms 0ms 12 718 405ms 0ms 13 716 398ms 0ms 14 716 403ms 0ms 15 718 403ms 0ms 16 716 392ms 0ms 17 716 396ms 0ms 18 718 403ms 0ms 19 716 397ms 0ms 20 716 396ms 0ms 21 718 406ms 0ms 22 716 409ms 0ms 23 716 400ms 0ms 00 718 405ms 0ms [ User: symmetricds - Total duration: 9s789ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s789ms - 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-04-20 08:07:29 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:33:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:53:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,238 153ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 20 01 380 6ms 0ms 02 392 6ms 0ms 03 393 6ms 0ms 04 395 6ms 0ms 05 385 6ms 0ms 06 380 6ms 0ms 07 386 6ms 0ms 08 393 6ms 0ms 09 387 6ms 0ms 10 391 6ms 0ms 11 388 6ms 0ms 12 401 6ms 0ms 13 380 6ms 0ms 14 380 6ms 0ms 15 384 6ms 0ms 16 377 6ms 0ms 17 380 6ms 0ms 18 382 6ms 0ms 19 379 6ms 0ms 20 382 6ms 0ms 21 381 6ms 0ms 22 378 6ms 0ms 23 380 6ms 0ms 00 384 6ms 0ms [ User: symmetricds - Total duration: 153ms - Times executed: 9238 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 153ms - Times executed: 9238 ]
-
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-04-20 08:03:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 10:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 09:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,235 117ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 20 01 380 4ms 0ms 02 392 5ms 0ms 03 393 5ms 0ms 04 392 4ms 0ms 05 388 4ms 0ms 06 380 4ms 0ms 07 384 4ms 0ms 08 393 5ms 0ms 09 388 4ms 0ms 10 392 4ms 0ms 11 388 4ms 0ms 12 401 5ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 381 4ms 0ms 16 380 4ms 0ms 17 380 4ms 0ms 18 381 4ms 0ms 19 380 4ms 0ms 20 380 4ms 0ms 21 381 4ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms 00 381 4ms 0ms [ User: symmetricds - Total duration: 117ms - Times executed: 9235 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 117ms - Times executed: 9235 ]
-
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-04-20 20:48:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:19:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:07:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,599 411ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 20 01 358 17ms 0ms 02 358 16ms 0ms 03 359 17ms 0ms 04 358 17ms 0ms 05 358 17ms 0ms 06 358 17ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 17ms 0ms 11 358 17ms 0ms 12 359 17ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 359 17ms 0ms 16 358 17ms 0ms 17 358 16ms 0ms 18 359 16ms 0ms 19 358 16ms 0ms 20 358 17ms 0ms 21 359 16ms 0ms 22 358 16ms 0ms 23 358 17ms 0ms 00 359 17ms 0ms [ User: symmetricds - Total duration: 411ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 411ms - 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-04-20 05:16:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 23:31:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:47:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,599 211ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 20 01 358 8ms 0ms 02 358 8ms 0ms 03 359 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 359 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 359 8ms 0ms 13 358 8ms 0ms 14 358 9ms 0ms 15 359 9ms 0ms 16 358 9ms 0ms 17 358 8ms 0ms 18 359 9ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 359 8ms 0ms 22 358 8ms 0ms 23 358 8ms 0ms 00 359 8ms 0ms [ User: symmetricds - Total duration: 211ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 211ms - Times executed: 8599 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99893517' AND data_id <= '149893516' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99893988' AND data_id <= '149893987' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99894061' AND data_id <= '149894060' ORDER BY data_id ASC;
Date: 2019-04-20 09:38:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 14:47:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:17:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,599 280ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 20 01 358 12ms 0ms 02 358 13ms 0ms 03 359 13ms 0ms 04 358 13ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 11ms 0ms 08 359 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 12ms 0ms 12 359 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 359 11ms 0ms 16 358 10ms 0ms 17 358 10ms 0ms 18 359 11ms 0ms 19 358 10ms 0ms 20 358 10ms 0ms 21 359 10ms 0ms 22 358 10ms 0ms 23 358 10ms 0ms 00 359 10ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 8599 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99892713' AND '149892712'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99892409' AND '149892408'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99893179' AND '149893178'));
Date: 2019-04-20 03:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 02:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 07:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,599 310ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 20 01 358 12ms 0ms 02 358 12ms 0ms 03 359 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 359 12ms 0ms 09 358 13ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 359 13ms 0ms 13 358 13ms 0ms 14 358 12ms 0ms 15 359 13ms 0ms 16 358 13ms 0ms 17 358 13ms 0ms 18 359 13ms 0ms 19 358 13ms 0ms 20 358 13ms 0ms 21 359 12ms 0ms 22 358 13ms 0ms 23 358 13ms 0ms 00 359 13ms 0ms [ User: symmetricds - Total duration: 310ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 310ms - 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-04-20 06:41:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 19:10:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:09:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,312 701ms 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 20 01 251 29ms 0ms 02 242 27ms 0ms 03 237 27ms 0ms 04 239 27ms 0ms 05 241 26ms 0ms 06 239 26ms 0ms 07 239 27ms 0ms 08 240 27ms 0ms 09 241 27ms 0ms 10 238 26ms 0ms 11 240 27ms 0ms 12 247 29ms 0ms 13 285 31ms 0ms 14 278 30ms 0ms 15 289 30ms 0ms 16 289 31ms 0ms 17 288 31ms 0ms 18 284 30ms 0ms 19 280 29ms 0ms 20 284 32ms 0ms 21 280 30ms 0ms 22 284 30ms 0ms 23 288 31ms 0ms 00 289 31ms 0ms [ User: symmetricds - Total duration: 701ms - Times executed: 6312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 701ms - Times executed: 6312 ]
-
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-04-20 19:29:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 13:06:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:44:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,312 273ms 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 Apr 20 01 251 11ms 0ms 02 242 10ms 0ms 03 237 10ms 0ms 04 239 10ms 0ms 05 241 10ms 0ms 06 239 10ms 0ms 07 239 10ms 0ms 08 240 10ms 0ms 09 241 10ms 0ms 10 238 10ms 0ms 11 240 10ms 0ms 12 247 10ms 0ms 13 285 12ms 0ms 14 278 12ms 0ms 15 289 12ms 0ms 16 289 12ms 0ms 17 288 12ms 0ms 18 284 12ms 0ms 19 280 11ms 0ms 20 284 12ms 0ms 21 280 12ms 0ms 22 284 12ms 0ms 23 288 12ms 0ms 00 289 12ms 0ms [ User: symmetricds - Total duration: 273ms - Times executed: 6312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 273ms - Times executed: 6312 ]
-
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 = '1' ORDER BY channel_id;
Date: 2019-04-20 00:36:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 17:44:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 05:17:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,468 709ms 0ms 9ms 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 Apr 20 01 184 77ms 0ms 02 190 84ms 0ms 03 190 80ms 0ms 04 190 72ms 0ms 05 188 35ms 0ms 06 184 18ms 0ms 07 186 21ms 0ms 08 190 19ms 0ms 09 188 28ms 0ms 10 190 19ms 0ms 11 188 19ms 0ms 12 192 18ms 0ms 13 184 19ms 0ms 14 184 19ms 0ms 15 184 17ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 16ms 0ms 20 184 22ms 0ms 21 184 17ms 0ms 22 184 17ms 0ms 23 184 16ms 0ms 00 184 18ms 0ms [ User: symmetricds - Total duration: 709ms - Times executed: 4468 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 709ms - Times executed: 4468 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-04-20 01:27:38 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 08:27:40 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:14:38 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 4,145 295ms 0ms 0ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 20 01 36 5ms 0ms 02 304 21ms 0ms 03 580 39ms 0ms 04 644 36ms 0ms 05 166 10ms 0ms 06 36 6ms 0ms 07 168 13ms 0ms 08 604 33ms 0ms 09 184 11ms 0ms 10 136 11ms 0ms 11 326 21ms 0ms 12 544 35ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 33 3ms 0ms 20 36 4ms 0ms 21 27 3ms 0ms 22 33 3ms 0ms 23 36 4ms 0ms 00 36 4ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 4145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 4145 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99893005', '8805936', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99893526', '8806017', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99892238', '8805851', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2019-04-20 05:44:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 09:41:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:31: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 1ms 81ms 32ms 24 790ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 20 01 1 79ms 79ms 02 1 81ms 81ms 03 1 79ms 79ms 04 1 80ms 80ms 05 1 78ms 78ms 06 1 77ms 77ms 07 1 63ms 63ms 08 1 45ms 45ms 09 1 31ms 31ms 10 1 44ms 44ms 11 1 24ms 24ms 12 1 34ms 34ms 13 1 17ms 17ms 14 1 15ms 15ms 15 1 10ms 10ms 16 1 8ms 8ms 17 1 5ms 5ms 18 1 3ms 3ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 1ms 1ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 790ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 790ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-04-20 01:00:00 Duration: 81ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:00:00 Duration: 80ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 02:00:00 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 1ms 99ms 13ms 227 3s138ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 20 01 19 124ms 6ms 02 19 121ms 6ms 03 19 117ms 6ms 04 19 120ms 6ms 05 19 141ms 7ms 06 19 115ms 6ms 07 19 292ms 15ms 08 18 257ms 14ms 09 12 138ms 11ms 10 11 135ms 12ms 11 10 160ms 16ms 12 9 129ms 14ms 13 7 194ms 27ms 14 6 288ms 48ms 15 5 190ms 38ms 16 4 132ms 33ms 17 3 104ms 34ms 18 2 77ms 38ms 19 2 58ms 29ms 20 1 30ms 30ms 21 1 42ms 42ms 22 1 58ms 58ms 23 1 50ms 50ms 00 1 53ms 53ms [ User: symmetricds - Total duration: 3s138ms - Times executed: 227 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s138ms - Times executed: 227 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99846389' AND '99851389' AND create_time < '2019-04-19 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99846389' AND '99851389' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99865159' AND '99870159' AND create_time < '2019-04-19 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99865159' AND '99870159' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99871638' AND '99876638' AND create_time < '2019-04-19 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99871638' AND '99876638' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-04-20 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 13:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 14:00:00 Duration: 86ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 13ms 6ms 157 1s67ms 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 #3
Day Hour Count Duration Avg duration Apr 20 01 98 695ms 7ms 02 4 23ms 5ms 03 3 13ms 4ms 04 3 17ms 5ms 05 3 13ms 4ms 06 2 13ms 6ms 07 3 21ms 7ms 08 3 17ms 5ms 09 3 17ms 5ms 10 3 17ms 5ms 11 3 26ms 8ms 12 5 35ms 7ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 12ms 6ms 16 2 13ms 6ms 17 2 12ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 12ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 751ms - Times executed: 112 ]
[ User: pharmisight - Total duration: 316ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s67ms - Times executed: 157 ]
-
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 = '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;
Date: 2019-04-20 00:30:40 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:30:40 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 9ms 5ms 187 951ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 20 01 8 34ms 4ms 02 8 41ms 5ms 03 8 34ms 4ms 04 8 45ms 5ms 05 8 43ms 5ms 06 8 49ms 6ms 07 8 49ms 6ms 08 8 48ms 6ms 09 8 40ms 5ms 10 8 49ms 6ms 11 8 38ms 4ms 12 8 46ms 5ms 13 8 43ms 5ms 14 8 33ms 4ms 15 8 40ms 5ms 16 8 33ms 4ms 17 8 41ms 5ms 18 8 35ms 4ms 19 8 40ms 5ms 20 8 38ms 4ms 21 4 14ms 3ms 22 7 40ms 5ms 23 8 35ms 4ms 00 8 29ms 3ms [ User: symmetricds - Total duration: 951ms - Times executed: 187 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 951ms - Times executed: 187 ]
-
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" = '460469544', "total_memory_bytes" = '748158976', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 16:44: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" = '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" = '529181128', "total_memory_bytes" = '757596160', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 05:58:47', "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" = '483975384', "total_memory_bytes" = '747634688', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-20 21:44:19', "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';
Date: 2019-04-20 16:44:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 05:59:21 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:45:04 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 27ms 5ms 209 1s51ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 20 01 19 82ms 4ms 02 19 81ms 4ms 03 19 81ms 4ms 04 19 81ms 4ms 05 19 80ms 4ms 06 19 79ms 4ms 07 18 71ms 3ms 08 12 48ms 4ms 09 11 43ms 3ms 10 10 39ms 3ms 11 9 34ms 3ms 12 7 29ms 4ms 13 6 25ms 4ms 14 5 73ms 14ms 15 4 42ms 10ms 16 3 28ms 9ms 17 2 20ms 10ms 18 2 10ms 5ms 19 1 2ms 2ms 20 1 7ms 7ms 21 1 7ms 7ms 22 1 27ms 27ms 23 1 25ms 25ms 00 1 25ms 25ms [ User: symmetricds - Total duration: 1s51ms - Times executed: 209 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s51ms - Times executed: 209 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892123' AND '99894055' AND data_id < '99894058' AND create_time < '2019-04-19 21:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892123' AND '99894055');
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892149' AND '99894078' AND data_id < '99894081' AND create_time < '2019-04-19 23:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894078');
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892135' AND '99894066' AND data_id < '99894069' AND create_time < '2019-04-19 22:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892135' AND '99894066');
Date: 2019-04-20 21:00:00 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 23:00:00 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:00:00 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 3ms 1ms 960 1s396ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 20 01 39 58ms 1ms 02 52 74ms 1ms 03 53 76ms 1ms 04 57 83ms 1ms 05 54 80ms 1ms 06 54 77ms 1ms 07 56 81ms 1ms 08 55 80ms 1ms 09 53 77ms 1ms 10 55 80ms 1ms 11 53 76ms 1ms 12 51 74ms 1ms 13 27 38ms 1ms 14 28 40ms 1ms 15 29 41ms 1ms 16 26 38ms 1ms 17 25 36ms 1ms 18 27 39ms 1ms 19 28 40ms 1ms 20 27 38ms 1ms 21 29 42ms 1ms 22 24 36ms 1ms 23 29 41ms 1ms 00 29 42ms 1ms [ User: symmetricds - Total duration: 1s396ms - Times executed: 960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s396ms - Times executed: 960 ]
-
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-04-20 09:43:40 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:15:38 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:21:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 1ms 0ms 973 912ms 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 #7
Day Hour Count Duration Avg duration Apr 20 01 42 39ms 0ms 02 53 50ms 0ms 03 56 52ms 0ms 04 58 55ms 0ms 05 55 52ms 0ms 06 53 50ms 0ms 07 57 54ms 0ms 08 56 52ms 0ms 09 54 50ms 0ms 10 54 50ms 0ms 11 54 50ms 0ms 12 52 48ms 0ms 13 27 24ms 0ms 14 28 25ms 0ms 15 29 26ms 0ms 16 26 25ms 0ms 17 25 23ms 0ms 18 27 24ms 0ms 19 28 25ms 0ms 20 27 24ms 0ms 21 29 26ms 0ms 22 25 22ms 0ms 23 29 26ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 912ms - Times executed: 973 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 973 ]
-
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-04-20 15:37:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:07:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 06:07:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 2ms 0ms 1,245 1s163ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 20 01 55 50ms 0ms 02 66 62ms 0ms 03 71 67ms 0ms 04 73 69ms 0ms 05 67 61ms 0ms 06 66 61ms 0ms 07 70 66ms 0ms 08 70 64ms 0ms 09 72 68ms 0ms 10 65 61ms 0ms 11 68 63ms 0ms 12 71 65ms 0ms 13 33 31ms 0ms 14 38 35ms 0ms 15 39 36ms 0ms 16 35 32ms 0ms 17 32 30ms 0ms 18 35 32ms 0ms 19 37 34ms 0ms 20 39 36ms 0ms 21 38 35ms 0ms 22 30 27ms 0ms 23 35 32ms 0ms 00 40 36ms 0ms [ User: symmetricds - Total duration: 1s163ms - Times executed: 1245 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s163ms - Times executed: 1245 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13 UNION ALL SELECT 16852, 3) 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-04-20 01:57:39 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:00:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 03:09:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 2ms 0ms 953 843ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 20 01 42 36ms 0ms 02 51 45ms 0ms 03 54 47ms 0ms 04 57 50ms 0ms 05 54 47ms 0ms 06 51 45ms 0ms 07 56 51ms 0ms 08 52 45ms 0ms 09 52 45ms 0ms 10 54 47ms 0ms 11 51 45ms 0ms 12 50 43ms 0ms 13 27 23ms 0ms 14 28 24ms 0ms 15 29 25ms 0ms 16 26 22ms 0ms 17 25 22ms 0ms 18 27 24ms 0ms 19 28 24ms 0ms 20 27 23ms 0ms 21 29 25ms 0ms 22 25 22ms 0ms 23 29 25ms 0ms 00 29 25ms 0ms [ User: symmetricds - Total duration: 843ms - Times executed: 953 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 843ms - Times executed: 953 ]
-
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-04-20 06:43:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 10:55:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 17:21:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 14ms 0ms 1,646 985ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 20 02 134 82ms 0ms 03 272 160ms 0ms 04 304 164ms 0ms 05 65 50ms 0ms 07 66 20ms 0ms 08 284 166ms 0ms 09 74 59ms 0ms 10 50 48ms 0ms 11 145 97ms 0ms 12 252 135ms 0ms [ User: pharmisight - Total duration: 985ms - Times executed: 1646 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 985ms - Times executed: 1646 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005460432', '2019-04-20 07:36:38', 'AMBROSZWICSM', '2019-04-20 07:00:00.041', '88670', '12', '150505230140191258');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005466040', '2019-04-20 03:15:29', 'DRAGONM', '2019-04-20 02:40:02.352', '115263', '1', '31237090373935001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5005465981', '2019-04-20 02:17:07', 'DZIEMIN', '2019-04-20 01:40:01.596', '71545', '24', '31237090373799001');
Date: 2019-04-20 07:00:00 Duration: 14ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 02:40:02 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:40:01 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 5ms 0ms 17,199 9s789ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 20 01 717 409ms 0ms 02 716 423ms 0ms 03 718 414ms 0ms 04 716 420ms 0ms 05 716 415ms 0ms 06 716 414ms 0ms 07 716 414ms 0ms 08 718 418ms 0ms 09 716 420ms 0ms 10 716 408ms 0ms 11 716 411ms 0ms 12 718 405ms 0ms 13 716 398ms 0ms 14 716 403ms 0ms 15 718 403ms 0ms 16 716 392ms 0ms 17 716 396ms 0ms 18 718 403ms 0ms 19 716 397ms 0ms 20 716 396ms 0ms 21 718 406ms 0ms 22 716 409ms 0ms 23 716 400ms 0ms 00 718 405ms 0ms [ User: symmetricds - Total duration: 9s789ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s789ms - 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-04-20 08:07:29 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:33:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:53:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 27ms 0ms 1,607 819ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 20 01 1,564 758ms 0ms 02 43 61ms 1ms [ User: symmetricds - Total duration: 819ms - Times executed: 1607 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 819ms - Times executed: 1607 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1489' WHERE "patient_id" = '205969';
-
UPDATE "public"."patients" SET "caloriesday" = '2845' WHERE "patient_id" = '200226010';
-
UPDATE "public"."patients" SET "caloriesday" = '1578' WHERE "patient_id" = '200097490';
Date: 2019-04-20 01:01:09 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:02:08 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:35:07 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 9ms 0ms 4,468 709ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 20 01 184 77ms 0ms 02 190 84ms 0ms 03 190 80ms 0ms 04 190 72ms 0ms 05 188 35ms 0ms 06 184 18ms 0ms 07 186 21ms 0ms 08 190 19ms 0ms 09 188 28ms 0ms 10 190 19ms 0ms 11 188 19ms 0ms 12 192 18ms 0ms 13 184 19ms 0ms 14 184 19ms 0ms 15 184 17ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 16ms 0ms 20 184 22ms 0ms 21 184 17ms 0ms 22 184 17ms 0ms 23 184 16ms 0ms 00 184 18ms 0ms [ User: symmetricds - Total duration: 709ms - Times executed: 4468 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 709ms - Times executed: 4468 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-04-20 01:27:38 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 08:27:40 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:14:38 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 2ms 0ms 6,312 701ms 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 #14
Day Hour Count Duration Avg duration Apr 20 01 251 29ms 0ms 02 242 27ms 0ms 03 237 27ms 0ms 04 239 27ms 0ms 05 241 26ms 0ms 06 239 26ms 0ms 07 239 27ms 0ms 08 240 27ms 0ms 09 241 27ms 0ms 10 238 26ms 0ms 11 240 27ms 0ms 12 247 29ms 0ms 13 285 31ms 0ms 14 278 30ms 0ms 15 289 30ms 0ms 16 289 31ms 0ms 17 288 31ms 0ms 18 284 30ms 0ms 19 280 29ms 0ms 20 284 32ms 0ms 21 280 30ms 0ms 22 284 30ms 0ms 23 288 31ms 0ms 00 289 31ms 0ms [ User: symmetricds - Total duration: 701ms - Times executed: 6312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 701ms - Times executed: 6312 ]
-
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-04-20 19:29:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 13:06:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 22:44:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 4,145 295ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 20 01 36 5ms 0ms 02 304 21ms 0ms 03 580 39ms 0ms 04 644 36ms 0ms 05 166 10ms 0ms 06 36 6ms 0ms 07 168 13ms 0ms 08 604 33ms 0ms 09 184 11ms 0ms 10 136 11ms 0ms 11 326 21ms 0ms 12 544 35ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 33 3ms 0ms 20 36 4ms 0ms 21 27 3ms 0ms 22 33 3ms 0ms 23 36 4ms 0ms 00 36 4ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 4145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 4145 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99893005', '8805936', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99893526', '8806017', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('99892238', '8805851', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
Date: 2019-04-20 05:44:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 09:41:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 01:31:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 17,348 913ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 20 01 720 37ms 0ms 02 726 38ms 0ms 03 728 38ms 0ms 04 726 38ms 0ms 05 724 38ms 0ms 06 720 37ms 0ms 07 722 38ms 0ms 08 728 38ms 0ms 09 724 37ms 0ms 10 726 38ms 0ms 11 724 37ms 0ms 12 732 38ms 0ms 13 720 38ms 0ms 14 720 38ms 0ms 15 722 38ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 38ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 722 37ms 0ms 22 720 38ms 0ms 23 720 38ms 0ms 00 722 38ms 0ms [ User: symmetricds - Total duration: 913ms - Times executed: 17348 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 913ms - Times executed: 17348 ]
-
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 = '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';
Date: 2019-04-20 11:43:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 04:31:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 21:48:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 2ms 0ms 25,224 1s255ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 20 01 1,140 56ms 0ms 02 1,052 51ms 0ms 03 1,050 51ms 0ms 04 1,050 50ms 0ms 05 1,048 51ms 0ms 06 1,042 51ms 0ms 07 1,048 50ms 0ms 08 1,056 50ms 0ms 09 1,050 51ms 0ms 10 1,054 51ms 0ms 11 1,050 51ms 0ms 12 1,058 51ms 0ms 13 1,044 54ms 0ms 14 1,044 53ms 0ms 15 1,046 52ms 0ms 16 1,044 50ms 0ms 17 1,044 51ms 0ms 18 1,046 54ms 0ms 19 1,044 53ms 0ms 20 1,044 55ms 0ms 21 1,038 51ms 0ms 22 1,042 54ms 0ms 23 1,044 52ms 0ms 00 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25224 ]
-
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-04-20 12:44:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 19:14:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 21,360 1s23ms 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 #18
Day Hour Count Duration Avg duration Apr 20 01 890 27ms 0ms 02 890 31ms 0ms 03 890 45ms 0ms 04 890 35ms 0ms 05 890 35ms 0ms 06 890 41ms 0ms 07 890 38ms 0ms 08 890 46ms 0ms 09 890 44ms 0ms 10 890 45ms 0ms 11 890 45ms 0ms 12 890 45ms 0ms 13 890 41ms 0ms 14 890 44ms 0ms 15 890 44ms 0ms 16 890 47ms 0ms 17 890 46ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s23ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s23ms - Times executed: 21360 ]
-
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 = '32994452' 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 = '1860' 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 = '3364' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-20 07:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,599 411ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 20 01 358 17ms 0ms 02 358 16ms 0ms 03 359 17ms 0ms 04 358 17ms 0ms 05 358 17ms 0ms 06 358 17ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 17ms 0ms 11 358 17ms 0ms 12 359 17ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 359 17ms 0ms 16 358 17ms 0ms 17 358 16ms 0ms 18 359 16ms 0ms 19 358 16ms 0ms 20 358 17ms 0ms 21 359 16ms 0ms 22 358 16ms 0ms 23 358 17ms 0ms 00 359 17ms 0ms [ User: symmetricds - Total duration: 411ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 411ms - 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-04-20 05:16:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 23:31:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 00:47:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 24,120 1s142ms 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 #20
Day Hour Count Duration Avg duration Apr 20 01 1,005 31ms 0ms 02 1,005 35ms 0ms 03 1,005 51ms 0ms 04 1,005 39ms 0ms 05 1,005 39ms 0ms 06 1,005 46ms 0ms 07 1,005 42ms 0ms 08 1,005 50ms 0ms 09 1,005 50ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 51ms 0ms 13 1,005 46ms 0ms 14 1,005 49ms 0ms 15 1,005 50ms 0ms 16 1,005 51ms 0ms 17 1,005 52ms 0ms 18 1,005 50ms 0ms 19 1,005 50ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 49ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s142ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s142ms - Times executed: 24120 ]
-
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 = '33074255' 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 = '3364' 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 = '3504' ORDER BY itemcodes0_.code ASC;
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-20 15:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,212,142 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 20 11 1 - FATAL: no pg_hba.conf entry for host "205.185.127.241", user "postgres", database "postgres", SSL on
Date: 2019-04-20 10:39:13 Database: postgres Application: [unknown] User: postgres Remote: 205.185.127.241 Code:
2 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 20 11 1 - FATAL: no pg_hba.conf entry for host "205.185.127.241", user "postgres", database "postgres", SSL off
Date: 2019-04-20 10:39:14 Database: postgres Application: [unknown] User: postgres Remote: 205.185.127.241 Code: