-
Global information
- Generated on Tue May 29 00:00:38 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 5,726,699 log entries in 35s
- Log start from 2018-05-28 00:00:01 to 2018-05-28 23:59:58
-
Overview
Global Stats
- 187 Number of unique normalized queries
- 1,974,640 Number of queries
- 59s478ms Total query duration
- 2018-05-28 00:00:01 First query
- 2018-05-28 23:59:58 Last query
- 1,077 queries/s at 2018-05-28 00:00:44 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 207 Total number of automatic vacuums
- 279 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,078 Total number of sessions
- 3 sessions at 2018-05-28 06:26:46 Session peak
- 10d1h20m48s Total duration of sessions
- 6m58s Average duration of sessions
- 950 Average queries per session
- 28ms Average queries duration per session
- 2,078 Total number of connections
- 4 connections/s at 2018-05-28 19:13:25 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,077 queries/s Query Peak
- 2018-05-28 00:00:44 Date
SELECT Traffic
Key values
- 652 queries/s Query Peak
- 2018-05-28 00:00:44 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 264 queries/s Query Peak
- 2018-05-28 23:20:34 Date
Queries duration
Key values
- 59s478ms Total query duration
Prepared queries ratio
Key values
- 1.61 Ratio of bind vs prepare
- 166.85 % Ratio between prepared and "usual" statements
General Activity
Day Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 28 00 88,808 0ms 12ms 0ms 75ms 90ms 878ms 01 81,301 0ms 12ms 0ms 56ms 69ms 88ms 02 81,568 0ms 21ms 0ms 63ms 69ms 76ms 03 81,481 0ms 12ms 0ms 57ms 69ms 88ms 04 82,018 0ms 12ms 0ms 56ms 70ms 90ms 05 81,394 0ms 12ms 0ms 61ms 74ms 84ms 06 82,476 0ms 12ms 0ms 61ms 74ms 93ms 07 81,396 0ms 12ms 0ms 61ms 69ms 77ms 08 82,102 0ms 12ms 0ms 63ms 76ms 103ms 09 81,509 0ms 12ms 0ms 61ms 62ms 82ms 10 81,575 0ms 12ms 0ms 57ms 64ms 68ms 11 82,068 0ms 12ms 0ms 58ms 67ms 77ms 12 81,762 0ms 12ms 0ms 61ms 70ms 93ms 13 82,019 0ms 12ms 0ms 59ms 69ms 83ms 14 81,513 0ms 12ms 0ms 57ms 59ms 81ms 15 81,625 0ms 15ms 0ms 59ms 70ms 73ms 16 82,065 0ms 12ms 0ms 61ms 65ms 76ms 17 81,480 0ms 12ms 0ms 63ms 74ms 79ms 18 81,455 0ms 13ms 0ms 60ms 73ms 83ms 19 82,529 0ms 198ms 0ms 61ms 77ms 314ms 20 82,125 0ms 40ms 0ms 63ms 87ms 152ms 21 83,529 0ms 12ms 0ms 67ms 79ms 130ms 22 82,883 0ms 12ms 0ms 67ms 81ms 189ms 23 83,959 0ms 12ms 0ms 74ms 89ms 180ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 28 00 29,239 0 0ms 30ms 42ms 64ms 01 26,045 0 0ms 27ms 32ms 44ms 02 26,130 0 0ms 28ms 34ms 46ms 03 26,107 0 0ms 27ms 33ms 42ms 04 26,262 0 0ms 27ms 35ms 47ms 05 26,074 0 0ms 28ms 35ms 45ms 06 26,428 0 0ms 27ms 34ms 42ms 07 26,080 0 0ms 29ms 35ms 38ms 08 26,301 0 0ms 27ms 36ms 44ms 09 26,131 0 0ms 28ms 36ms 39ms 10 26,131 0 0ms 27ms 32ms 36ms 11 26,292 0 0ms 28ms 34ms 36ms 12 26,205 0 0ms 27ms 34ms 39ms 13 26,271 0 0ms 28ms 36ms 43ms 14 26,129 0 0ms 28ms 36ms 43ms 15 26,163 0 0ms 26ms 34ms 42ms 16 26,286 0 0ms 28ms 35ms 42ms 17 26,105 0 0ms 27ms 36ms 42ms 18 26,115 0 0ms 28ms 33ms 48ms 19 26,508 0 0ms 28ms 37ms 158ms 20 26,320 0 0ms 27ms 40ms 61ms 21 26,741 0 0ms 28ms 37ms 44ms 22 26,536 0 0ms 30ms 34ms 36ms 23 26,783 0 0ms 29ms 33ms 51ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 28 00 189 959 60 0 0ms 7ms 9ms 14ms 01 70 527 68 0 0ms 1ms 7ms 10ms 02 66 519 68 0 0ms 1ms 6ms 9ms 03 72 529 69 0 0ms 1ms 6ms 10ms 04 72 537 69 0 0ms 1ms 4ms 10ms 05 66 519 68 0 0ms 1ms 6ms 10ms 06 70 535 68 0 0ms 1ms 6ms 10ms 07 66 519 68 0 0ms 1ms 1ms 9ms 08 70 535 68 0 0ms 1ms 5ms 10ms 09 72 529 69 0 0ms 1ms 7ms 10ms 10 66 519 68 0 0ms 1ms 3ms 10ms 11 72 537 69 0 0ms 1ms 8ms 10ms 12 72 529 69 0 0ms 1ms 2ms 10ms 13 66 527 68 0 0ms 1ms 6ms 10ms 14 72 529 69 0 0ms 1ms 5ms 12ms 15 71 524 68 0 0ms 1ms 6ms 10ms 16 67 532 69 0 0ms 1ms 3ms 10ms 17 72 529 69 0 0ms 1ms 8ms 10ms 18 66 519 68 0 0ms 1ms 6ms 9ms 19 77 552 70 0 0ms 1ms 6ms 9ms 20 257 592 76 0 0ms 1ms 6ms 11ms 21 686 660 71 0 0ms 1ms 8ms 16ms 22 613 682 71 0 0ms 1ms 9ms 16ms 23 696 732 70 0 0ms 1ms 9ms 23ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 28 00 54,396 88,772 1.63 100.26% 01 50,337 81,265 1.61 103.60% 02 50,459 81,532 1.62 103.55% 03 50,356 81,445 1.62 103.38% 04 50,713 81,982 1.62 103.45% 05 50,356 81,358 1.62 103.55% 06 51,276 82,440 1.61 104.04% 07 50,512 81,360 1.61 103.88% 08 50,953 82,066 1.61 103.86% 09 50,636 81,473 1.61 103.91% 10 50,550 81,539 1.61 103.73% 11 51,011 82,032 1.61 103.99% 12 50,757 81,726 1.61 103.85% 13 50,915 81,983 1.61 103.92% 14 50,700 81,477 1.61 104.04% 15 50,715 81,589 1.61 103.97% 16 51,051 82,029 1.61 104.12% 17 50,555 81,444 1.61 103.81% 18 50,751 81,419 1.60 104.27% 19 51,186 82,493 1.61 103.55% 20 50,992 82,089 1.61 103.51% 21 51,695 83,493 1.62 102.57% 22 51,181 82,847 1.62 102.39% 23 51,805 83,923 1.62 102.27% Day Hour Count Average / Second May 28 00 89 0.02/s 01 87 0.02/s 02 85 0.02/s 03 80 0.02/s 04 80 0.02/s 05 83 0.02/s 06 90 0.03/s 07 90 0.03/s 08 91 0.03/s 09 84 0.02/s 10 89 0.02/s 11 87 0.02/s 12 83 0.02/s 13 89 0.02/s 14 86 0.02/s 15 92 0.03/s 16 90 0.03/s 17 85 0.02/s 18 88 0.02/s 19 86 0.02/s 20 85 0.02/s 21 88 0.02/s 22 87 0.02/s 23 84 0.02/s Day Hour Count Average Duration May 28 00 89 6m41s 01 87 6m55s 02 85 7m7s 03 80 7m19s 04 80 7m37s 05 83 7m24s 06 90 6m45s 07 90 6m25s 08 91 6m35s 09 84 7m1s 10 89 7m5s 11 87 6m53s 12 83 7m17s 13 89 6m52s 14 86 6m30s 15 92 6m48s 16 90 6m48s 17 85 7m7s 18 85 6m53s 19 89 7m7s 20 85 7m10s 21 88 6m59s 22 87 6m48s 23 84 7m7s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2018-05-28 19:13:25 Date
Connections per database
Key values
- pharmisight Main Database
- 2,078 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,078 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-05-28 06:26:46 Date
Histogram of session times
Key values
- 1,421 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,078 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,078 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,078 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 226 buffers Checkpoint Peak
- 2018-05-28 15:09:07 Date
- 22.669 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-05-28 01:53:33 Date
Checkpoints distance
Key values
Checkpoint mean distance and estimate (5 minutes period)
NO DATASET
Checkpoints Activity
Day Hour Written buffers Write time Sync time Total time May 28 00 849 85.184s 0.014s 85.242s 01 579 58.097s 0.014s 58.153s 02 430 43.165s 0.013s 43.218s 03 523 52.477s 0.016s 52.535s 04 551 55.292s 0.013s 55.345s 05 577 57.89s 0.035s 57.966s 06 465 46.654s 0.028s 46.724s 07 509 51.064s 0.013s 51.122s 08 602 60.399s 0.018s 60.461s 09 455 45.661s 0.014s 45.715s 10 597 59.897s 0.016s 59.957s 11 496 49.762s 0.014s 49.82s 12 532 53.374s 0.014s 53.434s 13 571 57.288s 0.018s 57.347s 14 418 41.938s 0.018s 41.998s 15 587 58.889s 0.014s 58.945s 16 534 53.585s 0.011s 53.633s 17 428 42.941s 0.016s 42.999s 18 600 60.204s 0.028s 60.272s 19 555 55.679s 0.014s 55.733s 20 448 44.948s 0.014s 45.003s 21 766 76.852s 0.015s 76.913s 22 769 77.153s 0.014s 77.227s 23 645 64.72s 0.013s 64.775s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 28 00 0 0 0 309 0.002s 0s 01 0 0 1 253 0.001s 0s 02 0 0 0 279 0.002s 0s 03 0 0 0 257 0.002s 0s 04 0 0 0 244 0.002s 0s 05 0 0 0 330 0.010s 0s 06 0 0 0 259 0.018s 0s 07 0 0 0 262 0.002s 0s 08 0 0 0 331 0.003s 0s 09 0 0 1 247 0.002s 0s 10 0 0 0 293 0.002s 0s 11 0 0 0 264 0.002s 0s 12 0 0 0 251 0.002s 0s 13 0 0 0 316 0.002s 0s 14 0 0 0 241 0.003s 0s 15 0 0 0 249 0.002s 0s 16 0 0 0 303 0.002s 0s 17 0 0 1 246 0.003s 0s 18 0 0 0 275 0.010s 0s 19 0 0 0 298 0.002s 0s 20 0 0 0 206 0.002s 0s 21 0 0 0 301 0.001s 0s 22 0 0 0 281 0.002s 0s 23 0 0 1 237 0.002s 0s Day Hour Count Avg time (sec) May 28 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
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
Day Hour Count Total size Average size May 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.74 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-05-28 05:06:08 Date
- 0.09 sec Highest CPU-cost analyze
Table public.sym_incoming_batch
Database pharmisight - 2018-05-28 18:41:53 Date
Analyzes per table
Key values
- public.sym_node_communication (191) Main table analyzed (database pharmisight)
- 279 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 191 pharmisight.public.sym_outgoing_batch 17 pharmisight.public.sym_data_event 15 pharmisight.public.sym_lock 11 pharmisight.public.sym_data 11 pharmisight.public.sym_data_gap 10 pharmisight.public.sym_incoming_batch 9 pharmisight.public.sym_sequence 8 pharmisight.public.sym_node_host 5 pharmisight.public.sym_node_channel_ctl 2 Total 279 Vacuums per table
Key values
- public.sym_node_communication (154) Main table vacuumed on database pharmisight
- 207 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 154 0 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_outgoing_batch 9 9 pharmisight.public.sym_sequence 8 0 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_data_event 3 3 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_data 2 2 Total 207 27 Tuples removed per table
Key values
- public.sym_node_communication (1740) Main table with removed tuples on database pharmisight
- 6834 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_node_communication 154 0 1740 0 pharmisight.public.sym_outgoing_batch 9 9 1121 0 pharmisight.public.sym_data_event 3 3 735 0 pharmisight.public.sym_incoming_batch 5 5 731 0 pharmisight.pg_catalog.pg_statistic 2 2 620 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 8 0 412 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_data 2 2 231 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 Total 207 27 6,834 0 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_data_event 3 3 735 0 pharmisight.public.sym_sequence 8 0 412 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 pharmisight.pg_catalog.pg_statistic 2 2 620 0 pharmisight.public.sym_node_communication 154 0 1740 0 pharmisight.public.sym_outgoing_batch 9 9 1121 0 pharmisight.public.sym_incoming_batch 5 5 731 0 pharmisight.public.sym_data 2 2 231 0 Total 207 27 6,834 0 Autovacuum Activity
Day Hour VACUUMs ANALYZEs May 28 00 9 14 01 11 13 02 9 10 03 10 11 04 6 13 05 8 9 06 9 12 07 7 11 08 10 13 09 7 10 10 12 11 11 6 12 12 8 11 13 10 11 14 5 9 15 7 12 16 10 12 17 9 11 18 7 13 19 12 9 20 8 13 21 10 13 22 7 15 23 10 11 - 4.74 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
- 633,382 Total read queries
- 549,556 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,974,640 Requests
- 59s478ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,051,257 Requests
User Request type Count Duration pharmisight Total 4,290 1s220ms DELETE 7 1ms INSERT 486 276ms OTHERS 1,602 63ms SELECT 1,643 828ms TCL 544 36ms UPDATE 8 14ms symmetricds Total 2,051,257 55s952ms DDL 1 8ms DELETE 1,712 239ms INSERT 3,352 560ms OTHERS 823,001 15s276ms SELECT 657,061 26s790ms TCL 551,932 8s777ms UPDATE 14,198 4s299ms tony Total 900 4s724ms SELECT 900 4s724ms Duration by user
Key values
- 55s952ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 4,290 1s220ms DELETE 7 1ms INSERT 486 276ms OTHERS 1,602 63ms SELECT 1,643 828ms TCL 544 36ms UPDATE 8 14ms symmetricds Total 2,051,257 55s952ms DDL 1 8ms DELETE 1,712 239ms INSERT 3,352 560ms OTHERS 823,001 15s276ms SELECT 657,061 26s790ms TCL 551,932 8s777ms UPDATE 14,198 4s299ms tony Total 900 4s724ms SELECT 900 4s724ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,055,547 Requests
- 57s173ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,971,986 Requests
- 54s889ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-05-28 19:24:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,969,612 0-1ms duration
Slowest individual queries
Rank Duration Query 1 198ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ ORDER BY this_.roundDeliveryDate DESC, this_.routeNumber ASC LIMIT '20';[ Date: 2018-05-28 19:57:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 48ms SELECT count (*) AS col_0_0_ FROM ORDER_ROUNDS orderround0_ WHERE orderround0_.status <> 'Quarantine';[ Date: 2018-05-28 19:56:58 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 44ms SELECT count (*) AS col_0_0_ FROM ORDER_ROUNDS orderround0_;[ Date: 2018-05-28 19:57:19 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 40ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-05-28 00:00:00' AND '2018-05-29 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2018-05-28 20:01:07 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 31ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_7_0_, this_.routeNumber AS routeNum2_7_0_, this_.roundDeliveryDate AS roundDel3_7_0_, this_.distributionPoint AS distribu4_7_0_, this_.fullyPicked AS fullyPic5_7_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_7_0_, this_.causeOfDelay AS causeOfD7_7_0_, this_.pharmacy100CheckTime AS pharmacy8_7_0_, this_.linesHeldBack AS linesHel9_7_0_, this_.packTime100 AS packTim10_7_0_, this_.replenish AS repleni11_7_0_, this_.comment AS comment12_7_0_, this_.pickDateTime AS pickDat13_7_0_, this_.failedTargetPickTime AS failedT14_7_0_, this_.actualPaperworkCompleteTime AS actualP15_7_0_, this_.changedPickDateTime AS changed16_7_0_, this_.CREATED AS CREATED17_7_0_, this_.UPDATED AS UPDATED18_7_0_, this_.note AS note19_7_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = '2018-05-28' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2018-05-28 20:01:07 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 21ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 02:21:11 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
7 20ms SELECT * FROM order_lines WHERE (deliveryDate = '2018-05-29' AND STATUS <> 'Quarantine') AND ((ageCheck = 10609 OR ageCheck = 10611 OR ageCheck = 10612) OR (STATUS = 'Mismatch') OR (paperwork IS NOT NULL AND paperwork <> 'Rx OK' AND paperwork <> 'Evidence OK' AND paperwork <> 'REG OK' AND paperwork <> 'ES OK') OR (paperworkResolution IS NOT NULL) OR (overAverageQtyMax IS NOT NULL));[ Date: 2018-05-28 19:56:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 15ms COMMIT;[ Date: 2018-05-28 15:27:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 13ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 02:51:16 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
10 13ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 18:26:13 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
11 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 01:31:15 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
12 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 23:51:16 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
13 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 12:06:17 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
14 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 04:46:14 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
15 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 01:56:17 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
16 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 23:41:12 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
17 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 10:51:13 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
18 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 02:31:12 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
19 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 00:26:11 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
20 12ms SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;[ Date: 2018-05-28 08:16:14 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 14s602ms 788,122 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 00 34,398 641ms 0ms 01 32,565 600ms 0ms 02 32,691 608ms 0ms 03 32,636 605ms 0ms 04 32,860 609ms 0ms 05 32,621 600ms 0ms 06 33,033 620ms 0ms 07 32,613 595ms 0ms 08 32,884 603ms 0ms 09 32,634 600ms 0ms 10 32,691 608ms 0ms 11 32,866 620ms 0ms 12 32,743 611ms 0ms 13 32,869 612ms 0ms 14 32,636 605ms 0ms 15 32,687 601ms 0ms 16 32,877 605ms 0ms 17 32,633 609ms 0ms 18 32,629 599ms 0ms 19 32,950 597ms 0ms 20 32,718 607ms 0ms 21 32,977 608ms 0ms 22 32,749 615ms 0ms 23 33,162 615ms 0ms [ User: symmetricds - Total duration: 14s577ms - Times executed: 787608 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 514 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s602ms - Times executed: 788122 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-05-28 11:55:28 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:43:55 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 11:13:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s661ms 265,234 0ms 15ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 00 11,904 447ms 0ms 01 10,938 265ms 0ms 02 10,974 264ms 0ms 03 10,966 265ms 0ms 04 11,041 264ms 0ms 05 10,952 257ms 0ms 06 11,093 264ms 0ms 07 10,947 260ms 0ms 08 11,043 282ms 0ms 09 10,965 263ms 0ms 10 10,973 262ms 0ms 11 11,041 264ms 0ms 12 11,001 269ms 0ms 13 11,032 259ms 0ms 14 10,965 262ms 0ms 15 10,976 274ms 0ms 16 11,039 262ms 0ms 17 10,963 268ms 0ms 18 10,953 257ms 0ms 19 11,112 269ms 0ms 20 11,008 275ms 0ms 21 11,121 293ms 0ms 22 11,041 302ms 0ms 23 11,186 305ms 0ms [ User: symmetricds - Total duration: 6s627ms - Times executed: 264971 ]
[ User: pharmisight - Total duration: 33ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s661ms - Times executed: 265234 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-05-28 15:27:02 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 08:26:49 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:27:36 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s354ms 348,666 0ms 8ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 28 00 15,676 192ms 0ms 01 14,385 180ms 0ms 02 14,436 180ms 0ms 03 14,424 183ms 0ms 04 14,507 178ms 0ms 05 14,405 183ms 0ms 06 14,584 183ms 0ms 07 14,400 179ms 0ms 08 14,507 180ms 0ms 09 14,423 178ms 0ms 10 14,435 179ms 0ms 11 14,507 180ms 0ms 12 14,477 180ms 0ms 13 14,493 182ms 0ms 14 14,423 176ms 0ms 15 14,440 179ms 0ms 16 14,503 179ms 0ms 17 14,421 180ms 0ms 18 14,406 180ms 0ms 19 14,562 181ms 0ms 20 14,473 189ms 0ms 21 14,591 178ms 0ms 22 14,504 181ms 0ms 23 14,684 183ms 0ms [ User: symmetricds - Total duration: 4s354ms - Times executed: 348666 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s354ms - Times executed: 348666 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-05-28 20:50:15 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 02:04:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 11:20:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s510ms 288 1ms 21ms 12ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 28 00 12 147ms 12ms 01 12 148ms 12ms 02 12 157ms 13ms 03 12 147ms 12ms 04 12 147ms 12ms 05 12 146ms 12ms 06 12 147ms 12ms 07 12 146ms 12ms 08 12 147ms 12ms 09 12 146ms 12ms 10 12 148ms 12ms 11 12 137ms 11ms 12 12 137ms 11ms 13 12 136ms 11ms 14 12 147ms 12ms 15 12 146ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 148ms 12ms 19 12 146ms 12ms 20 12 146ms 12ms 21 12 146ms 12ms 22 12 145ms 12ms 23 12 148ms 12ms [ User: tony - Total duration: 3s510ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s510ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-05-28 02:21:11 Duration: 21ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 02:51:16 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 18:26:13 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
5 3s322ms 70,110 0ms 8ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 00 2,934 139ms 0ms 01 2,907 139ms 0ms 02 2,925 137ms 0ms 03 2,916 136ms 0ms 04 2,916 136ms 0ms 05 2,916 139ms 0ms 06 2,943 139ms 0ms 07 2,916 136ms 0ms 08 2,916 137ms 0ms 09 2,916 139ms 0ms 10 2,925 141ms 0ms 11 2,916 135ms 0ms 12 2,934 137ms 0ms 13 2,916 138ms 0ms 14 2,916 139ms 0ms 15 2,925 137ms 0ms 16 2,916 135ms 0ms 17 2,916 138ms 0ms 18 2,916 138ms 0ms 19 2,925 147ms 0ms 20 2,925 133ms 0ms 21 2,916 137ms 0ms 22 2,916 139ms 0ms 23 2,943 140ms 0ms [ User: symmetricds - Total duration: 3s322ms - Times executed: 70110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s322ms - Times executed: 70110 ]
-
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: 2018-05-28 19:23:56 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:53:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s796ms 265,234 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 00 11,904 80ms 0ms 01 10,938 73ms 0ms 02 10,974 74ms 0ms 03 10,966 73ms 0ms 04 11,041 75ms 0ms 05 10,952 74ms 0ms 06 11,093 74ms 0ms 07 10,947 73ms 0ms 08 11,043 74ms 0ms 09 10,965 73ms 0ms 10 10,973 74ms 0ms 11 11,041 75ms 0ms 12 11,001 74ms 0ms 13 11,032 80ms 0ms 14 10,965 75ms 0ms 15 10,976 73ms 0ms 16 11,039 73ms 0ms 17 10,963 77ms 0ms 18 10,953 74ms 0ms 19 11,112 73ms 0ms 20 11,008 74ms 0ms 21 11,121 73ms 0ms 22 11,041 74ms 0ms 23 11,186 74ms 0ms [ User: symmetricds - Total duration: 1s793ms - Times executed: 264971 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s796ms - Times executed: 265234 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-05-28 13:58:44 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:36:12 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:50:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s500ms 1,348 0ms 6ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 00 56 61ms 1ms 01 56 60ms 1ms 02 54 59ms 1ms 03 54 58ms 1ms 04 55 61ms 1ms 05 55 63ms 1ms 06 60 66ms 1ms 07 57 62ms 1ms 08 58 66ms 1ms 09 58 62ms 1ms 10 54 58ms 1ms 11 58 63ms 1ms 12 56 67ms 1ms 13 55 69ms 1ms 14 58 66ms 1ms 15 56 59ms 1ms 16 59 69ms 1ms 17 53 58ms 1ms 18 57 61ms 1ms 19 55 58ms 1ms 20 55 60ms 1ms 21 58 61ms 1ms 22 57 63ms 1ms 23 54 59ms 1ms [ User: symmetricds - Total duration: 1s500ms - Times executed: 1348 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s500ms - Times executed: 1348 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 13:30:05 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 08:03:36 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 13:41:05 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s467ms 62,320 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 00 2,608 60ms 0ms 01 2,584 60ms 0ms 02 2,599 60ms 0ms 03 2,592 61ms 0ms 04 2,592 60ms 0ms 05 2,592 60ms 0ms 06 2,616 60ms 0ms 07 2,592 60ms 0ms 08 2,592 60ms 0ms 09 2,592 60ms 0ms 10 2,600 60ms 0ms 11 2,592 61ms 0ms 12 2,608 60ms 0ms 13 2,592 61ms 0ms 14 2,592 60ms 0ms 15 2,600 60ms 0ms 16 2,592 60ms 0ms 17 2,592 60ms 0ms 18 2,592 60ms 0ms 19 2,600 61ms 0ms 20 2,600 60ms 0ms 21 2,592 63ms 0ms 22 2,593 62ms 0ms 23 2,616 63ms 0ms [ User: symmetricds - Total duration: 1s467ms - Times executed: 62320 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s467ms - Times executed: 62320 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'default' AND ((d.data_id BETWEEN '83824940' AND '133824939')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'pharmisight' AND ((d.data_id BETWEEN '83825441' AND '133825440')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'default' AND ((d.data_id BETWEEN '83824862' AND '133824861')) ORDER BY d.data_id ASC;
Date: 2018-05-28 11:54:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:20:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 05:12:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s402ms 814 0ms 9ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 00 27 45ms 1ms 01 39 62ms 1ms 02 38 61ms 1ms 03 36 58ms 1ms 04 34 54ms 1ms 05 44 73ms 1ms 06 32 52ms 1ms 07 38 60ms 1ms 08 32 56ms 1ms 09 35 62ms 1ms 10 39 68ms 1ms 11 36 57ms 1ms 12 41 78ms 1ms 13 29 55ms 1ms 14 37 65ms 1ms 15 25 42ms 1ms 16 41 75ms 1ms 17 31 52ms 1ms 18 28 47ms 1ms 19 31 54ms 1ms 20 24 41ms 1ms 21 35 57ms 1ms 22 35 67ms 1ms 23 27 48ms 1ms [ User: symmetricds - Total duration: 1s402ms - Times executed: 814 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s402ms - Times executed: 814 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) 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), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) 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), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 13:16:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:56:29 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:26:20 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s386ms 191 1ms 10ms 7ms 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" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 00 8 56ms 7ms 01 8 53ms 6ms 02 8 61ms 7ms 03 8 61ms 7ms 04 8 54ms 6ms 05 8 60ms 7ms 06 8 61ms 7ms 07 8 59ms 7ms 08 8 61ms 7ms 09 8 64ms 8ms 10 8 62ms 7ms 11 8 61ms 7ms 12 8 61ms 7ms 13 8 61ms 7ms 14 8 64ms 8ms 15 8 57ms 7ms 16 8 54ms 6ms 17 8 61ms 7ms 18 8 60ms 7ms 19 8 61ms 7ms 20 7 45ms 6ms 21 8 47ms 5ms 22 8 48ms 6ms 23 8 43ms 5ms [ User: symmetricds - Total duration: 1s386ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s386ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '240479672', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 14:56:05', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '203136256', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 09:48:28', "last_restart_time" = '2018-05-17 16:07:48', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '296274696', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 15:56:05', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-05-28 14:57:06 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 09:49:48 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 15:57:10 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s102ms 5,306 0ms 5ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 28 00 226 50ms 0ms 01 219 44ms 0ms 02 219 45ms 0ms 03 220 46ms 0ms 04 223 47ms 0ms 05 218 44ms 0ms 06 223 46ms 0ms 07 219 42ms 0ms 08 223 50ms 0ms 09 220 47ms 0ms 10 219 46ms 0ms 11 223 48ms 0ms 12 219 44ms 0ms 13 223 43ms 0ms 14 220 44ms 0ms 15 221 45ms 0ms 16 223 46ms 0ms 17 218 47ms 0ms 18 220 44ms 0ms 19 223 45ms 0ms 20 221 44ms 0ms 21 224 45ms 0ms 22 219 44ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s102ms - Times executed: 5306 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s102ms - Times executed: 5306 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-28 00:45:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:35:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 03:02:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s72ms 1,113 0ms 3ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 00 41 43ms 1ms 01 41 39ms 0ms 02 39 39ms 1ms 03 41 40ms 0ms 04 40 39ms 0ms 05 41 42ms 1ms 06 44 42ms 0ms 07 41 39ms 0ms 08 44 42ms 0ms 09 49 48ms 0ms 10 50 47ms 0ms 11 48 45ms 0ms 12 50 47ms 0ms 13 48 44ms 0ms 14 50 47ms 0ms 15 49 45ms 0ms 16 51 47ms 0ms 17 48 46ms 0ms 18 51 47ms 0ms 19 47 44ms 0ms 20 50 47ms 0ms 21 54 49ms 0ms 22 47 46ms 0ms 23 49 46ms 0ms [ User: symmetricds - Total duration: 1s72ms - Times executed: 1113 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s72ms - Times executed: 1113 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 05:01:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 09:07:37 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:02:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s47ms 52,240 0ms 1ms 0ms SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = '' AND channel_id = '';Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 00 2,200 44ms 0ms 01 2,160 42ms 0ms 02 2,160 42ms 0ms 03 2,160 42ms 0ms 04 2,200 44ms 0ms 05 2,160 43ms 0ms 06 2,200 44ms 0ms 07 2,160 42ms 0ms 08 2,200 43ms 0ms 09 2,160 44ms 0ms 10 2,160 45ms 0ms 11 2,200 46ms 0ms 12 2,160 43ms 0ms 13 2,200 43ms 0ms 14 2,160 42ms 0ms 15 2,160 42ms 0ms 16 2,200 43ms 0ms 17 2,160 42ms 0ms 18 2,160 43ms 0ms 19 2,200 44ms 0ms 20 2,160 44ms 0ms 21 2,200 43ms 0ms 22 2,160 44ms 0ms 23 2,200 43ms 0ms [ User: symmetricds - Total duration: 1s47ms - Times executed: 52240 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s47ms - Times executed: 52240 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'config';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'dynamic';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'config';
Date: 2018-05-28 18:53:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:06:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:16:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 855ms 1,242 0ms 4ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 00 52 43ms 0ms 01 53 35ms 0ms 02 52 35ms 0ms 03 51 34ms 0ms 04 51 34ms 0ms 05 51 34ms 0ms 06 56 37ms 0ms 07 53 36ms 0ms 08 54 36ms 0ms 09 54 37ms 0ms 10 51 34ms 0ms 11 53 36ms 0ms 12 50 34ms 0ms 13 51 37ms 0ms 14 50 33ms 0ms 15 49 32ms 0ms 16 52 35ms 0ms 17 49 34ms 0ms 18 52 36ms 0ms 19 49 34ms 0ms 20 51 35ms 0ms 21 55 36ms 0ms 22 53 37ms 0ms 23 50 33ms 0ms [ User: symmetricds - Total duration: 855ms - Times executed: 1242 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 855ms - Times executed: 1242 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) 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), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) 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), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 00:25:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:01:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:43:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 840ms 288 1ms 3ms 2ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 00 12 34ms 2ms 01 12 35ms 2ms 02 12 35ms 2ms 03 12 35ms 2ms 04 12 35ms 2ms 05 12 35ms 2ms 06 12 34ms 2ms 07 12 35ms 2ms 08 12 35ms 2ms 09 12 34ms 2ms 10 12 34ms 2ms 11 12 35ms 2ms 12 12 34ms 2ms 13 12 34ms 2ms 14 12 35ms 2ms 15 12 33ms 2ms 16 12 35ms 2ms 17 12 35ms 2ms 18 12 35ms 2ms 19 12 35ms 2ms 20 12 35ms 2ms 21 12 34ms 2ms 22 12 32ms 2ms 23 12 35ms 2ms [ User: tony - Total duration: 840ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 840ms - Times executed: 288 ]
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
Date: 2018-05-28 02:21:11 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 17:11:13 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 11:16:15 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
16 804ms 5,224 0ms 3ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 00 220 34ms 0ms 01 216 34ms 0ms 02 216 32ms 0ms 03 216 32ms 0ms 04 220 34ms 0ms 05 216 34ms 0ms 06 220 31ms 0ms 07 216 30ms 0ms 08 220 32ms 0ms 09 216 31ms 0ms 10 216 32ms 0ms 11 220 35ms 0ms 12 216 34ms 0ms 13 220 34ms 0ms 14 216 32ms 0ms 15 216 34ms 0ms 16 220 35ms 0ms 17 216 32ms 0ms 18 216 31ms 0ms 19 220 33ms 0ms 20 216 32ms 0ms 21 220 33ms 0ms 22 216 34ms 0ms 23 220 35ms 0ms [ User: symmetricds - Total duration: 804ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 804ms - Times executed: 5224 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 23:42:58.973', last_lock_time = '2018-05-28 23:42:58.973' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 21:42:58.973');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 00:08:56.301', last_lock_time = '2018-05-28 00:08:56.301' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-27 22:08:56.301');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 15:39:38.21', last_lock_time = '2018-05-28 15:39:38.21' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 13:39:38.21');
Date: 2018-05-28 23:43:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:09:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 15:40:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 750ms 14,543 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 WHERE node_id = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 00 631 32ms 0ms 01 601 31ms 0ms 02 603 29ms 0ms 03 602 30ms 0ms 04 607 31ms 0ms 05 602 30ms 0ms 06 610 31ms 0ms 07 602 31ms 0ms 08 607 32ms 0ms 09 602 29ms 0ms 10 603 31ms 0ms 11 607 32ms 0ms 12 604 31ms 0ms 13 607 31ms 0ms 14 602 30ms 0ms 15 603 31ms 0ms 16 607 30ms 0ms 17 602 31ms 0ms 18 602 30ms 0ms 19 608 31ms 0ms 20 603 34ms 0ms 21 610 31ms 0ms 22 605 30ms 0ms 23 613 30ms 0ms [ User: symmetricds - Total duration: 750ms - Times executed: 14543 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 750ms - Times executed: 14543 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-28 20:33:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 20:45:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 713ms 10,449 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 00 441 28ms 0ms 01 432 28ms 0ms 02 432 27ms 0ms 03 432 31ms 0ms 04 440 28ms 0ms 05 432 28ms 0ms 06 440 30ms 0ms 07 432 28ms 0ms 08 440 28ms 0ms 09 432 31ms 0ms 10 432 31ms 0ms 11 440 30ms 0ms 12 432 28ms 0ms 13 440 30ms 0ms 14 432 29ms 0ms 15 432 27ms 0ms 16 440 30ms 0ms 17 432 29ms 0ms 18 432 30ms 0ms 19 440 29ms 0ms 20 432 33ms 0ms 21 440 28ms 0ms 22 432 29ms 0ms 23 440 30ms 0ms [ User: symmetricds - Total duration: 713ms - Times executed: 10449 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - Times executed: 10449 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-28 20:48:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 18:10:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 05:39:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 691ms 133 3ms 10ms 5ms 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 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 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 - 0 ] & 0 WHEN 0 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 #19
Day Hour Count Duration Avg duration May 28 00 105 461ms 4ms 01 1 8ms 8ms 02 1 8ms 8ms 03 1 8ms 8ms 04 1 8ms 8ms 05 1 8ms 8ms 06 1 8ms 8ms 07 1 8ms 8ms 08 1 8ms 8ms 09 1 8ms 8ms 10 1 8ms 8ms 11 1 8ms 8ms 12 1 8ms 8ms 13 1 8ms 8ms 14 1 8ms 8ms 15 1 8ms 8ms 16 1 8ms 8ms 17 1 8ms 8ms 18 1 8ms 8ms 19 2 16ms 8ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 691ms - Times executed: 133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 133 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
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 = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-05-28 00:01:13 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 20:40:09 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:11:35 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 665ms 236 1ms 3ms 2ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 00 11 31ms 2ms 01 10 28ms 2ms 02 11 30ms 2ms 03 10 28ms 2ms 04 9 25ms 2ms 05 11 29ms 2ms 06 10 28ms 2ms 07 9 25ms 2ms 08 10 27ms 2ms 09 10 28ms 2ms 10 10 28ms 2ms 11 9 25ms 2ms 12 8 22ms 2ms 13 11 31ms 2ms 14 9 25ms 2ms 15 9 25ms 2ms 16 11 31ms 2ms 17 10 28ms 2ms 18 11 31ms 2ms 19 10 28ms 2ms 20 9 25ms 2ms 21 10 28ms 2ms 22 9 25ms 2ms 23 9 25ms 2ms [ User: symmetricds - Total duration: 665ms - Times executed: 236 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 665ms - Times executed: 236 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) 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), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) 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), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 03:23:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 16:27:13 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 21:47:30 Duration: 3ms 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 788,122 14s602ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 00 34,398 641ms 0ms 01 32,565 600ms 0ms 02 32,691 608ms 0ms 03 32,636 605ms 0ms 04 32,860 609ms 0ms 05 32,621 600ms 0ms 06 33,033 620ms 0ms 07 32,613 595ms 0ms 08 32,884 603ms 0ms 09 32,634 600ms 0ms 10 32,691 608ms 0ms 11 32,866 620ms 0ms 12 32,743 611ms 0ms 13 32,869 612ms 0ms 14 32,636 605ms 0ms 15 32,687 601ms 0ms 16 32,877 605ms 0ms 17 32,633 609ms 0ms 18 32,629 599ms 0ms 19 32,950 597ms 0ms 20 32,718 607ms 0ms 21 32,977 608ms 0ms 22 32,749 615ms 0ms 23 33,162 615ms 0ms [ User: symmetricds - Total duration: 14s577ms - Times executed: 787608 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 514 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s602ms - Times executed: 788122 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-05-28 11:55:28 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:43:55 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 11:13:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 348,666 4s354ms 0ms 8ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 00 15,676 192ms 0ms 01 14,385 180ms 0ms 02 14,436 180ms 0ms 03 14,424 183ms 0ms 04 14,507 178ms 0ms 05 14,405 183ms 0ms 06 14,584 183ms 0ms 07 14,400 179ms 0ms 08 14,507 180ms 0ms 09 14,423 178ms 0ms 10 14,435 179ms 0ms 11 14,507 180ms 0ms 12 14,477 180ms 0ms 13 14,493 182ms 0ms 14 14,423 176ms 0ms 15 14,440 179ms 0ms 16 14,503 179ms 0ms 17 14,421 180ms 0ms 18 14,406 180ms 0ms 19 14,562 181ms 0ms 20 14,473 189ms 0ms 21 14,591 178ms 0ms 22 14,504 181ms 0ms 23 14,684 183ms 0ms [ User: symmetricds - Total duration: 4s354ms - Times executed: 348666 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s354ms - Times executed: 348666 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-05-28 20:50:15 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 02:04:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 11:20:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 265,234 6s661ms 0ms 15ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 28 00 11,904 447ms 0ms 01 10,938 265ms 0ms 02 10,974 264ms 0ms 03 10,966 265ms 0ms 04 11,041 264ms 0ms 05 10,952 257ms 0ms 06 11,093 264ms 0ms 07 10,947 260ms 0ms 08 11,043 282ms 0ms 09 10,965 263ms 0ms 10 10,973 262ms 0ms 11 11,041 264ms 0ms 12 11,001 269ms 0ms 13 11,032 259ms 0ms 14 10,965 262ms 0ms 15 10,976 274ms 0ms 16 11,039 262ms 0ms 17 10,963 268ms 0ms 18 10,953 257ms 0ms 19 11,112 269ms 0ms 20 11,008 275ms 0ms 21 11,121 293ms 0ms 22 11,041 302ms 0ms 23 11,186 305ms 0ms [ User: symmetricds - Total duration: 6s627ms - Times executed: 264971 ]
[ User: pharmisight - Total duration: 33ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s661ms - Times executed: 265234 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-05-28 15:27:02 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 08:26:49 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:27:36 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 265,234 1s796ms 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 28 00 11,904 80ms 0ms 01 10,938 73ms 0ms 02 10,974 74ms 0ms 03 10,966 73ms 0ms 04 11,041 75ms 0ms 05 10,952 74ms 0ms 06 11,093 74ms 0ms 07 10,947 73ms 0ms 08 11,043 74ms 0ms 09 10,965 73ms 0ms 10 10,973 74ms 0ms 11 11,041 75ms 0ms 12 11,001 74ms 0ms 13 11,032 80ms 0ms 14 10,965 75ms 0ms 15 10,976 73ms 0ms 16 11,039 73ms 0ms 17 10,963 77ms 0ms 18 10,953 74ms 0ms 19 11,112 73ms 0ms 20 11,008 74ms 0ms 21 11,121 73ms 0ms 22 11,041 74ms 0ms 23 11,186 74ms 0ms [ User: symmetricds - Total duration: 1s793ms - Times executed: 264971 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s796ms - Times executed: 265234 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-05-28 13:58:44 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:36:12 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:50:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 70,110 3s322ms 0ms 8ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 00 2,934 139ms 0ms 01 2,907 139ms 0ms 02 2,925 137ms 0ms 03 2,916 136ms 0ms 04 2,916 136ms 0ms 05 2,916 139ms 0ms 06 2,943 139ms 0ms 07 2,916 136ms 0ms 08 2,916 137ms 0ms 09 2,916 139ms 0ms 10 2,925 141ms 0ms 11 2,916 135ms 0ms 12 2,934 137ms 0ms 13 2,916 138ms 0ms 14 2,916 139ms 0ms 15 2,925 137ms 0ms 16 2,916 135ms 0ms 17 2,916 138ms 0ms 18 2,916 138ms 0ms 19 2,925 147ms 0ms 20 2,925 133ms 0ms 21 2,916 137ms 0ms 22 2,916 139ms 0ms 23 2,943 140ms 0ms [ User: symmetricds - Total duration: 3s322ms - Times executed: 70110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s322ms - Times executed: 70110 ]
-
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: 2018-05-28 19:23:56 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:53:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 62,320 1s467ms 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 00 2,608 60ms 0ms 01 2,584 60ms 0ms 02 2,599 60ms 0ms 03 2,592 61ms 0ms 04 2,592 60ms 0ms 05 2,592 60ms 0ms 06 2,616 60ms 0ms 07 2,592 60ms 0ms 08 2,592 60ms 0ms 09 2,592 60ms 0ms 10 2,600 60ms 0ms 11 2,592 61ms 0ms 12 2,608 60ms 0ms 13 2,592 61ms 0ms 14 2,592 60ms 0ms 15 2,600 60ms 0ms 16 2,592 60ms 0ms 17 2,592 60ms 0ms 18 2,592 60ms 0ms 19 2,600 61ms 0ms 20 2,600 60ms 0ms 21 2,592 63ms 0ms 22 2,593 62ms 0ms 23 2,616 63ms 0ms [ User: symmetricds - Total duration: 1s467ms - Times executed: 62320 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s467ms - Times executed: 62320 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'default' AND ((d.data_id BETWEEN '83824940' AND '133824939')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'pharmisight' AND ((d.data_id BETWEEN '83825441' AND '133825440')) ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = 'default' AND ((d.data_id BETWEEN '83824862' AND '133824861')) ORDER BY d.data_id ASC;
Date: 2018-05-28 11:54:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:20:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 05:12:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 52,240 1s47ms 0ms 1ms 0ms SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = '' AND channel_id = '';Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 00 2,200 44ms 0ms 01 2,160 42ms 0ms 02 2,160 42ms 0ms 03 2,160 42ms 0ms 04 2,200 44ms 0ms 05 2,160 43ms 0ms 06 2,200 44ms 0ms 07 2,160 42ms 0ms 08 2,200 43ms 0ms 09 2,160 44ms 0ms 10 2,160 45ms 0ms 11 2,200 46ms 0ms 12 2,160 43ms 0ms 13 2,200 43ms 0ms 14 2,160 42ms 0ms 15 2,160 42ms 0ms 16 2,200 43ms 0ms 17 2,160 42ms 0ms 18 2,160 43ms 0ms 19 2,200 44ms 0ms 20 2,160 44ms 0ms 21 2,200 43ms 0ms 22 2,160 44ms 0ms 23 2,200 43ms 0ms [ User: symmetricds - Total duration: 1s47ms - Times executed: 52240 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s47ms - Times executed: 52240 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'config';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'dynamic';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'config';
Date: 2018-05-28 18:53:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:06:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:16:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 14,543 750ms 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 WHERE node_id = '';Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 00 631 32ms 0ms 01 601 31ms 0ms 02 603 29ms 0ms 03 602 30ms 0ms 04 607 31ms 0ms 05 602 30ms 0ms 06 610 31ms 0ms 07 602 31ms 0ms 08 607 32ms 0ms 09 602 29ms 0ms 10 603 31ms 0ms 11 607 32ms 0ms 12 604 31ms 0ms 13 607 31ms 0ms 14 602 30ms 0ms 15 603 31ms 0ms 16 607 30ms 0ms 17 602 31ms 0ms 18 602 30ms 0ms 19 608 31ms 0ms 20 603 34ms 0ms 21 610 31ms 0ms 22 605 30ms 0ms 23 613 30ms 0ms [ User: symmetricds - Total duration: 750ms - Times executed: 14543 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 750ms - Times executed: 14543 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-28 20:33:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 20:45:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 10,449 713ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 00 441 28ms 0ms 01 432 28ms 0ms 02 432 27ms 0ms 03 432 31ms 0ms 04 440 28ms 0ms 05 432 28ms 0ms 06 440 30ms 0ms 07 432 28ms 0ms 08 440 28ms 0ms 09 432 31ms 0ms 10 432 31ms 0ms 11 440 30ms 0ms 12 432 28ms 0ms 13 440 30ms 0ms 14 432 29ms 0ms 15 432 27ms 0ms 16 440 30ms 0ms 17 432 29ms 0ms 18 432 30ms 0ms 19 440 29ms 0ms 20 432 33ms 0ms 21 440 28ms 0ms 22 432 29ms 0ms 23 440 30ms 0ms [ User: symmetricds - Total duration: 713ms - Times executed: 10449 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - Times executed: 10449 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-28 20:48:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 18:10:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 05:39:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 7,834 250ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 00 327 10ms 0ms 01 326 10ms 0ms 02 326 10ms 0ms 03 326 10ms 0ms 04 326 10ms 0ms 05 326 10ms 0ms 06 328 11ms 0ms 07 327 10ms 0ms 08 326 10ms 0ms 09 326 9ms 0ms 10 326 10ms 0ms 11 326 10ms 0ms 12 327 10ms 0ms 13 327 10ms 0ms 14 326 10ms 0ms 15 326 10ms 0ms 16 326 9ms 0ms 17 326 10ms 0ms 18 326 10ms 0ms 19 326 10ms 0ms 20 328 10ms 0ms 21 325 10ms 0ms 22 327 10ms 0ms 23 328 10ms 0ms [ User: symmetricds - Total duration: 250ms - Times executed: 7834 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 250ms - Times executed: 7834 ]
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
-
SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = 'NE';
Date: 2018-05-28 19:08:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 19:04:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:48:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 7,791 182ms 0ms 1ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '' AND data_id <= '' ORDER BY data_id ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 28 00 326 7ms 0ms 01 323 7ms 0ms 02 325 7ms 0ms 03 324 7ms 0ms 04 324 7ms 0ms 05 324 7ms 0ms 06 327 7ms 0ms 07 324 6ms 0ms 08 324 7ms 0ms 09 324 7ms 0ms 10 325 7ms 0ms 11 324 7ms 0ms 12 326 7ms 0ms 13 324 7ms 0ms 14 324 7ms 0ms 15 325 7ms 0ms 16 324 7ms 0ms 17 324 7ms 0ms 18 324 7ms 0ms 19 325 7ms 0ms 20 325 7ms 0ms 21 324 8ms 0ms 22 325 8ms 0ms 23 327 10ms 0ms [ User: symmetricds - Total duration: 182ms - Times executed: 7791 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 182ms - Times executed: 7791 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83825288' AND data_id <= '133825287' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83825441' AND data_id <= '133825440' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '83825539' AND data_id <= '133825538' ORDER BY data_id ASC;
Date: 2018-05-28 22:40:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:20:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:40:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 7,790 433ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 00 326 18ms 0ms 01 323 18ms 0ms 02 325 17ms 0ms 03 324 17ms 0ms 04 324 17ms 0ms 05 324 17ms 0ms 06 327 18ms 0ms 07 324 18ms 0ms 08 324 17ms 0ms 09 324 17ms 0ms 10 325 17ms 0ms 11 324 17ms 0ms 12 326 18ms 0ms 13 324 17ms 0ms 14 324 17ms 0ms 15 325 18ms 0ms 16 324 17ms 0ms 17 324 18ms 0ms 18 324 18ms 0ms 19 325 17ms 0ms 20 325 17ms 0ms 21 324 17ms 0ms 22 324 18ms 0ms 23 327 17ms 0ms [ User: symmetricds - Total duration: 433ms - Times executed: 7790 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 433ms - Times executed: 7790 ]
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
Date: 2018-05-28 12:01:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 16:27:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 18:29:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 6,530 564ms 0ms 7ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 00 275 22ms 0ms 01 270 21ms 0ms 02 270 20ms 0ms 03 270 23ms 0ms 04 275 32ms 0ms 05 270 21ms 0ms 06 275 24ms 0ms 07 270 21ms 0ms 08 275 20ms 0ms 09 270 21ms 0ms 10 270 23ms 0ms 11 275 22ms 0ms 12 270 21ms 0ms 13 275 19ms 0ms 14 270 20ms 0ms 15 270 22ms 0ms 16 275 21ms 0ms 17 270 22ms 0ms 18 270 21ms 0ms 19 275 24ms 0ms 20 270 24ms 0ms 21 275 27ms 0ms 22 270 30ms 0ms 23 275 31ms 0ms [ User: symmetricds - Total duration: 564ms - Times executed: 6530 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 564ms - Times executed: 6530 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-05-28 04:41:58 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 19:36:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 10:52:34 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 5,306 1s102ms 0ms 5ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 00 226 50ms 0ms 01 219 44ms 0ms 02 219 45ms 0ms 03 220 46ms 0ms 04 223 47ms 0ms 05 218 44ms 0ms 06 223 46ms 0ms 07 219 42ms 0ms 08 223 50ms 0ms 09 220 47ms 0ms 10 219 46ms 0ms 11 223 48ms 0ms 12 219 44ms 0ms 13 223 43ms 0ms 14 220 44ms 0ms 15 221 45ms 0ms 16 223 46ms 0ms 17 218 47ms 0ms 18 220 44ms 0ms 19 223 45ms 0ms 20 221 44ms 0ms 21 224 45ms 0ms 22 219 44ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s102ms - Times executed: 5306 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s102ms - Times executed: 5306 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-28 00:45:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:35:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 03:02:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 5,249 200ms 0ms 0ms 0ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 00 245 8ms 0ms 01 216 8ms 0ms 02 216 8ms 0ms 03 216 8ms 0ms 04 220 8ms 0ms 05 216 8ms 0ms 06 220 8ms 0ms 07 216 8ms 0ms 08 220 8ms 0ms 09 216 8ms 0ms 10 216 8ms 0ms 11 220 8ms 0ms 12 216 8ms 0ms 13 220 8ms 0ms 14 216 8ms 0ms 15 216 8ms 0ms 16 220 8ms 0ms 17 216 8ms 0ms 18 216 8ms 0ms 19 220 8ms 0ms 20 216 8ms 0ms 21 220 8ms 0ms 22 216 8ms 0ms 23 220 8ms 0ms [ User: symmetricds - Total duration: 200ms - Times executed: 5249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 200ms - Times executed: 5249 ]
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
Date: 2018-05-28 09:06:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:49:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:40:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,224 661ms 0ms 0ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 00 220 29ms 0ms 01 216 27ms 0ms 02 216 28ms 0ms 03 216 28ms 0ms 04 220 27ms 0ms 05 216 27ms 0ms 06 220 28ms 0ms 07 216 26ms 0ms 08 220 27ms 0ms 09 216 26ms 0ms 10 216 27ms 0ms 11 220 28ms 0ms 12 216 28ms 0ms 13 220 27ms 0ms 14 216 26ms 0ms 15 216 27ms 0ms 16 220 27ms 0ms 17 216 27ms 0ms 18 216 26ms 0ms 19 220 27ms 0ms 20 216 27ms 0ms 21 220 27ms 0ms 22 216 27ms 0ms 23 220 27ms 0ms [ User: symmetricds - Total duration: 661ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 661ms - Times executed: 5224 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '50', success_count = '232564', fail_count = '0', total_success_count = '232564', total_fail_count = '682', total_success_millis = '368821809', total_fail_millis = '162479472', last_lock_time = '2018-05-28 11:38:21.054' WHERE node_id = '2' AND communication_type = 'PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '56', success_count = '119072', fail_count = '0', total_success_count = '119072', total_fail_count = '0', total_success_millis = '7388816', total_fail_millis = '0', last_lock_time = '2018-05-28 21:42:35.832' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '55', success_count = '118906', fail_count = '0', total_success_count = '118906', total_fail_count = '0', total_success_millis = '7378417', total_fail_millis = '0', last_lock_time = '2018-05-28 12:33:15.019' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
Date: 2018-05-28 11:38:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 21:43:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 12:33:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,224 440ms 0ms 0ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 00 220 18ms 0ms 01 216 17ms 0ms 02 216 17ms 0ms 03 216 17ms 0ms 04 220 17ms 0ms 05 216 17ms 0ms 06 220 17ms 0ms 07 216 17ms 0ms 08 220 17ms 0ms 09 216 18ms 0ms 10 216 19ms 0ms 11 220 18ms 0ms 12 216 18ms 0ms 13 220 18ms 0ms 14 216 18ms 0ms 15 216 18ms 0ms 16 220 19ms 0ms 17 216 18ms 0ms 18 216 18ms 0ms 19 220 18ms 0ms 20 216 18ms 0ms 21 220 19ms 0ms 22 216 18ms 0ms 23 220 19ms 0ms [ User: symmetricds - Total duration: 440ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 440ms - Times executed: 5224 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
Date: 2018-05-28 00:31:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:02:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 01:56:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,224 804ms 0ms 3ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 00 220 34ms 0ms 01 216 34ms 0ms 02 216 32ms 0ms 03 216 32ms 0ms 04 220 34ms 0ms 05 216 34ms 0ms 06 220 31ms 0ms 07 216 30ms 0ms 08 220 32ms 0ms 09 216 31ms 0ms 10 216 32ms 0ms 11 220 35ms 0ms 12 216 34ms 0ms 13 220 34ms 0ms 14 216 32ms 0ms 15 216 34ms 0ms 16 220 35ms 0ms 17 216 32ms 0ms 18 216 31ms 0ms 19 220 33ms 0ms 20 216 32ms 0ms 21 220 33ms 0ms 22 216 34ms 0ms 23 220 35ms 0ms [ User: symmetricds - Total duration: 804ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 804ms - Times executed: 5224 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 23:42:58.973', last_lock_time = '2018-05-28 23:42:58.973' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 21:42:58.973');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 00:08:56.301', last_lock_time = '2018-05-28 00:08:56.301' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-27 22:08:56.301');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 15:39:38.21', last_lock_time = '2018-05-28 15:39:38.21' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 13:39:38.21');
Date: 2018-05-28 23:43:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:09:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 15:40:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 3,157 236ms 0ms 1ms 0ms SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '' ORDER BY channel_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 28 00 170 12ms 0ms 01 128 11ms 0ms 02 127 9ms 0ms 03 128 10ms 0ms 04 130 10ms 0ms 05 127 9ms 0ms 06 130 9ms 0ms 07 127 10ms 0ms 08 130 9ms 0ms 09 128 10ms 0ms 10 127 8ms 0ms 11 130 8ms 0ms 12 128 8ms 0ms 13 129 9ms 0ms 14 127 9ms 0ms 15 127 8ms 0ms 16 129 10ms 0ms 17 128 9ms 0ms 18 126 9ms 0ms 19 132 9ms 0ms 20 129 9ms 0ms 21 140 9ms 0ms 22 138 9ms 0ms 23 142 9ms 0ms [ User: symmetricds - Total duration: 236ms - Times executed: 3157 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 236ms - Times executed: 3157 ]
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2018-05-28 01:38:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:27:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:55:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,612 111ms 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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = '' AND d.data_event_action = '' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 00 110 4ms 0ms 01 108 4ms 0ms 02 108 4ms 0ms 03 108 4ms 0ms 04 110 4ms 0ms 05 108 4ms 0ms 06 110 4ms 0ms 07 108 4ms 0ms 08 110 4ms 0ms 09 108 4ms 0ms 10 108 4ms 0ms 11 110 4ms 0ms 12 108 4ms 0ms 13 110 4ms 0ms 14 108 4ms 0ms 15 108 4ms 0ms 16 110 4ms 0ms 17 108 4ms 0ms 18 108 4ms 0ms 19 110 4ms 0ms 20 108 4ms 0ms 21 110 4ms 0ms 22 108 4ms 0ms 23 110 4ms 0ms [ User: symmetricds - Total duration: 111ms - Times executed: 2612 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 111ms - Times executed: 2612 ]
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
Date: 2018-05-28 11:09:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 03:39:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:55:11 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 21ms 12ms 288 3s510ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 00 12 147ms 12ms 01 12 148ms 12ms 02 12 157ms 13ms 03 12 147ms 12ms 04 12 147ms 12ms 05 12 146ms 12ms 06 12 147ms 12ms 07 12 146ms 12ms 08 12 147ms 12ms 09 12 146ms 12ms 10 12 148ms 12ms 11 12 137ms 11ms 12 12 137ms 11ms 13 12 136ms 11ms 14 12 147ms 12ms 15 12 146ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 148ms 12ms 19 12 146ms 12ms 20 12 146ms 12ms 21 12 146ms 12ms 22 12 145ms 12ms 23 12 148ms 12ms [ User: tony - Total duration: 3s510ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s510ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-05-28 02:21:11 Duration: 21ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 02:51:16 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 18:26:13 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
2 1ms 10ms 7ms 191 1s386ms 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" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 00 8 56ms 7ms 01 8 53ms 6ms 02 8 61ms 7ms 03 8 61ms 7ms 04 8 54ms 6ms 05 8 60ms 7ms 06 8 61ms 7ms 07 8 59ms 7ms 08 8 61ms 7ms 09 8 64ms 8ms 10 8 62ms 7ms 11 8 61ms 7ms 12 8 61ms 7ms 13 8 61ms 7ms 14 8 64ms 8ms 15 8 57ms 7ms 16 8 54ms 6ms 17 8 61ms 7ms 18 8 60ms 7ms 19 8 61ms 7ms 20 7 45ms 6ms 21 8 47ms 5ms 22 8 48ms 6ms 23 8 43ms 5ms [ User: symmetricds - Total duration: 1s386ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s386ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '240479672', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 14:56:05', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '203136256', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 09:48:28', "last_restart_time" = '2018-05-17 16:07:48', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '178.239.165.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '296274696', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-05-28 15:56:05', "last_restart_time" = '2018-05-01 10:55:28.548', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-05-28 14:57:06 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 09:49:48 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 15:57:10 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 10ms 5ms 133 691ms 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 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 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 - 0 ] & 0 WHEN 0 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 May 28 00 105 461ms 4ms 01 1 8ms 8ms 02 1 8ms 8ms 03 1 8ms 8ms 04 1 8ms 8ms 05 1 8ms 8ms 06 1 8ms 8ms 07 1 8ms 8ms 08 1 8ms 8ms 09 1 8ms 8ms 10 1 8ms 8ms 11 1 8ms 8ms 12 1 8ms 8ms 13 1 8ms 8ms 14 1 8ms 8ms 15 1 8ms 8ms 16 1 8ms 8ms 17 1 8ms 8ms 18 1 8ms 8ms 19 2 16ms 8ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 691ms - Times executed: 133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 133 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
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 = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-05-28 00:01:13 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 20:40:09 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:11:35 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1ms 3ms 2ms 288 840ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 28 00 12 34ms 2ms 01 12 35ms 2ms 02 12 35ms 2ms 03 12 35ms 2ms 04 12 35ms 2ms 05 12 35ms 2ms 06 12 34ms 2ms 07 12 35ms 2ms 08 12 35ms 2ms 09 12 34ms 2ms 10 12 34ms 2ms 11 12 35ms 2ms 12 12 34ms 2ms 13 12 34ms 2ms 14 12 35ms 2ms 15 12 33ms 2ms 16 12 35ms 2ms 17 12 35ms 2ms 18 12 35ms 2ms 19 12 35ms 2ms 20 12 35ms 2ms 21 12 34ms 2ms 22 12 32ms 2ms 23 12 35ms 2ms [ User: tony - Total duration: 840ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 840ms - Times executed: 288 ]
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
-
SELECT datname, usename, client_addr, query FROM pg_stat_activity;
Date: 2018-05-28 02:21:11 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 17:11:13 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-05-28 11:16:15 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
5 1ms 3ms 2ms 236 665ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 00 11 31ms 2ms 01 10 28ms 2ms 02 11 30ms 2ms 03 10 28ms 2ms 04 9 25ms 2ms 05 11 29ms 2ms 06 10 28ms 2ms 07 9 25ms 2ms 08 10 27ms 2ms 09 10 28ms 2ms 10 10 28ms 2ms 11 9 25ms 2ms 12 8 22ms 2ms 13 11 31ms 2ms 14 9 25ms 2ms 15 9 25ms 2ms 16 11 31ms 2ms 17 10 28ms 2ms 18 11 31ms 2ms 19 10 28ms 2ms 20 9 25ms 2ms 21 10 28ms 2ms 22 9 25ms 2ms 23 9 25ms 2ms [ User: symmetricds - Total duration: 665ms - Times executed: 236 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 665ms - Times executed: 236 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) 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), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) 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), 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 17143 AS OID, 1 AS attnum UNION ALL SELECT 17143, 5 UNION ALL SELECT 17143, 30 UNION ALL SELECT 17143, 4 UNION ALL SELECT 17143, 3 UNION ALL SELECT 17143, 2 UNION ALL SELECT 17143, 7 UNION ALL SELECT 17143, 6 UNION ALL SELECT 17143, 8 UNION ALL SELECT 17143, 9 UNION ALL SELECT 17143, 19 UNION ALL SELECT 17143, 20 UNION ALL SELECT 17143, 24 UNION ALL SELECT 17143, 29 UNION ALL SELECT 17143, 18 UNION ALL SELECT 17143, 28 UNION ALL SELECT 17143, 12 UNION ALL SELECT 17143, 11 UNION ALL SELECT 17143, 10 UNION ALL SELECT 17143, 14 UNION ALL SELECT 17143, 13 UNION ALL SELECT 17143, 15 UNION ALL SELECT 17143, 26 UNION ALL SELECT 17143, 25 UNION ALL SELECT 17143, 27 UNION ALL SELECT 17143, 17 UNION ALL SELECT 17143, 16 UNION ALL SELECT 17143, 31 UNION ALL SELECT 17143, 21 UNION ALL SELECT 17143, 23 UNION ALL SELECT 17143, 22 UNION ALL SELECT 17099, 10 UNION ALL SELECT 17099, 9 UNION ALL SELECT 17099, 11 UNION ALL SELECT 17099, 2 UNION ALL SELECT 17099, 5 UNION ALL SELECT 17099, 3 UNION ALL SELECT 17099, 4 UNION ALL SELECT 17099, 6 UNION ALL SELECT 17099, 8 UNION ALL SELECT 17099, 7 UNION ALL SELECT 17099, 1 UNION ALL SELECT 17099, 12 UNION ALL SELECT 17099, 14 UNION ALL SELECT 17099, 13 UNION ALL SELECT 17099, 15 UNION ALL SELECT 17169, 6 UNION ALL SELECT 17169, 8 UNION ALL SELECT 17169, 7 UNION ALL SELECT 17169, 3 UNION ALL SELECT 17169, 4 UNION ALL SELECT 17169, 10 UNION ALL SELECT 17169, 11 UNION ALL SELECT 17169, 5 UNION ALL SELECT 17169, 9) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 03:23:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 16:27:13 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 21:47:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 9ms 1ms 814 1s402ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 00 27 45ms 1ms 01 39 62ms 1ms 02 38 61ms 1ms 03 36 58ms 1ms 04 34 54ms 1ms 05 44 73ms 1ms 06 32 52ms 1ms 07 38 60ms 1ms 08 32 56ms 1ms 09 35 62ms 1ms 10 39 68ms 1ms 11 36 57ms 1ms 12 41 78ms 1ms 13 29 55ms 1ms 14 37 65ms 1ms 15 25 42ms 1ms 16 41 75ms 1ms 17 31 52ms 1ms 18 28 47ms 1ms 19 31 54ms 1ms 20 24 41ms 1ms 21 35 57ms 1ms 22 35 67ms 1ms 23 27 48ms 1ms [ User: symmetricds - Total duration: 1s402ms - Times executed: 814 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s402ms - Times executed: 814 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) 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), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) 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), 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 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 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 16964, 5 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 13:16:51 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 23:56:29 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:26:20 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 6ms 1ms 1,348 1s500ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 00 56 61ms 1ms 01 56 60ms 1ms 02 54 59ms 1ms 03 54 58ms 1ms 04 55 61ms 1ms 05 55 63ms 1ms 06 60 66ms 1ms 07 57 62ms 1ms 08 58 66ms 1ms 09 58 62ms 1ms 10 54 58ms 1ms 11 58 63ms 1ms 12 56 67ms 1ms 13 55 69ms 1ms 14 58 66ms 1ms 15 56 59ms 1ms 16 59 69ms 1ms 17 53 58ms 1ms 18 57 61ms 1ms 19 55 58ms 1ms 20 55 60ms 1ms 21 58 61ms 1ms 22 57 63ms 1ms 23 54 59ms 1ms [ User: symmetricds - Total duration: 1s500ms - Times executed: 1348 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s500ms - Times executed: 1348 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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) 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), 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) 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), 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 13:30:05 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 08:03:36 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 13:41:05 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 0ms 1,113 1s72ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 00 41 43ms 1ms 01 41 39ms 0ms 02 39 39ms 1ms 03 41 40ms 0ms 04 40 39ms 0ms 05 41 42ms 1ms 06 44 42ms 0ms 07 41 39ms 0ms 08 44 42ms 0ms 09 49 48ms 0ms 10 50 47ms 0ms 11 48 45ms 0ms 12 50 47ms 0ms 13 48 44ms 0ms 14 50 47ms 0ms 15 49 45ms 0ms 16 51 47ms 0ms 17 48 46ms 0ms 18 51 47ms 0ms 19 47 44ms 0ms 20 50 47ms 0ms 21 54 49ms 0ms 22 47 46ms 0ms 23 49 46ms 0ms [ User: symmetricds - Total duration: 1s72ms - Times executed: 1113 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s72ms - Times executed: 1113 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 05:01:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 09:07:37 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:02:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 4ms 0ms 1,242 855ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), 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 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 00 52 43ms 0ms 01 53 35ms 0ms 02 52 35ms 0ms 03 51 34ms 0ms 04 51 34ms 0ms 05 51 34ms 0ms 06 56 37ms 0ms 07 53 36ms 0ms 08 54 36ms 0ms 09 54 37ms 0ms 10 51 34ms 0ms 11 53 36ms 0ms 12 50 34ms 0ms 13 51 37ms 0ms 14 50 33ms 0ms 15 49 32ms 0ms 16 52 35ms 0ms 17 49 34ms 0ms 18 52 36ms 0ms 19 49 34ms 0ms 20 51 35ms 0ms 21 55 36ms 0ms 22 53 37ms 0ms 23 50 33ms 0ms [ User: symmetricds - Total duration: 855ms - Times executed: 1242 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 855ms - Times executed: 1242 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) 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), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) 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), 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 16947 AS OID, 1 AS attnum UNION ALL SELECT 16947, 2 UNION ALL SELECT 16947, 3 UNION ALL SELECT 16947, 4 UNION ALL SELECT 16947, 5 UNION ALL SELECT 16947, 6 UNION ALL SELECT 16947, 8 UNION ALL SELECT 16947, 7) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-05-28 00:25:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:01:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:43:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 5ms 0ms 5,306 1s102ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 00 226 50ms 0ms 01 219 44ms 0ms 02 219 45ms 0ms 03 220 46ms 0ms 04 223 47ms 0ms 05 218 44ms 0ms 06 223 46ms 0ms 07 219 42ms 0ms 08 223 50ms 0ms 09 220 47ms 0ms 10 219 46ms 0ms 11 223 48ms 0ms 12 219 44ms 0ms 13 223 43ms 0ms 14 220 44ms 0ms 15 221 45ms 0ms 16 223 46ms 0ms 17 218 47ms 0ms 18 220 44ms 0ms 19 223 45ms 0ms 20 221 44ms 0ms 21 224 45ms 0ms 22 219 44ms 0ms 23 223 44ms 0ms [ User: symmetricds - Total duration: 1s102ms - Times executed: 5306 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s102ms - Times executed: 5306 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, 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, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-05-28 00:45:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 06:35:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 03:02:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 3ms 0ms 5,224 804ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 28 00 220 34ms 0ms 01 216 34ms 0ms 02 216 32ms 0ms 03 216 32ms 0ms 04 220 34ms 0ms 05 216 34ms 0ms 06 220 31ms 0ms 07 216 30ms 0ms 08 220 32ms 0ms 09 216 31ms 0ms 10 216 32ms 0ms 11 220 35ms 0ms 12 216 34ms 0ms 13 220 34ms 0ms 14 216 32ms 0ms 15 216 34ms 0ms 16 220 35ms 0ms 17 216 32ms 0ms 18 216 31ms 0ms 19 220 33ms 0ms 20 216 32ms 0ms 21 220 33ms 0ms 22 216 34ms 0ms 23 220 35ms 0ms [ User: symmetricds - Total duration: 804ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 804ms - Times executed: 5224 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 23:42:58.973', last_lock_time = '2018-05-28 23:42:58.973' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 21:42:58.973');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 00:08:56.301', last_lock_time = '2018-05-28 00:08:56.301' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-27 22:08:56.301');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-05-28 15:39:38.21', last_lock_time = '2018-05-28 15:39:38.21' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-05-28 13:39:38.21');
Date: 2018-05-28 23:43:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:09:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 15:40:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 0ms 0ms 5,224 661ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 00 220 29ms 0ms 01 216 27ms 0ms 02 216 28ms 0ms 03 216 28ms 0ms 04 220 27ms 0ms 05 216 27ms 0ms 06 220 28ms 0ms 07 216 26ms 0ms 08 220 27ms 0ms 09 216 26ms 0ms 10 216 27ms 0ms 11 220 28ms 0ms 12 216 28ms 0ms 13 220 27ms 0ms 14 216 26ms 0ms 15 216 27ms 0ms 16 220 27ms 0ms 17 216 27ms 0ms 18 216 26ms 0ms 19 220 27ms 0ms 20 216 27ms 0ms 21 220 27ms 0ms 22 216 27ms 0ms 23 220 27ms 0ms [ User: symmetricds - Total duration: 661ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 661ms - Times executed: 5224 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '50', success_count = '232564', fail_count = '0', total_success_count = '232564', total_fail_count = '682', total_success_millis = '368821809', total_fail_millis = '162479472', last_lock_time = '2018-05-28 11:38:21.054' WHERE node_id = '2' AND communication_type = 'PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '56', success_count = '119072', fail_count = '0', total_success_count = '119072', total_fail_count = '0', total_success_millis = '7388816', total_fail_millis = '0', last_lock_time = '2018-05-28 21:42:35.832' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '55', success_count = '118906', fail_count = '0', total_success_count = '118906', total_fail_count = '0', total_success_millis = '7378417', total_fail_millis = '0', last_lock_time = '2018-05-28 12:33:15.019' WHERE node_id = '0' AND communication_type = 'FILE_PUSH';
Date: 2018-05-28 11:38:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 21:43:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 12:33:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 7ms 0ms 6,530 564ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 00 275 22ms 0ms 01 270 21ms 0ms 02 270 20ms 0ms 03 270 23ms 0ms 04 275 32ms 0ms 05 270 21ms 0ms 06 275 24ms 0ms 07 270 21ms 0ms 08 275 20ms 0ms 09 270 21ms 0ms 10 270 23ms 0ms 11 275 22ms 0ms 12 270 21ms 0ms 13 275 19ms 0ms 14 270 20ms 0ms 15 270 22ms 0ms 16 275 21ms 0ms 17 270 22ms 0ms 18 270 21ms 0ms 19 275 24ms 0ms 20 270 24ms 0ms 21 275 27ms 0ms 22 270 30ms 0ms 23 275 31ms 0ms [ User: symmetricds - Total duration: 564ms - Times executed: 6530 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 564ms - Times executed: 6530 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY 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_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, 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 FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-05-28 04:41:58 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 19:36:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 10:52:34 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 5,224 440ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 00 220 18ms 0ms 01 216 17ms 0ms 02 216 17ms 0ms 03 216 17ms 0ms 04 220 17ms 0ms 05 216 17ms 0ms 06 220 17ms 0ms 07 216 17ms 0ms 08 220 17ms 0ms 09 216 18ms 0ms 10 216 19ms 0ms 11 220 18ms 0ms 12 216 18ms 0ms 13 220 18ms 0ms 14 216 18ms 0ms 15 216 18ms 0ms 16 220 19ms 0ms 17 216 18ms 0ms 18 216 18ms 0ms 19 220 18ms 0ms 20 216 18ms 0ms 21 220 19ms 0ms 22 216 18ms 0ms 23 220 19ms 0ms [ User: symmetricds - Total duration: 440ms - Times executed: 5224 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 440ms - Times executed: 5224 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
Date: 2018-05-28 00:31:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 00:02:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 01:56:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 3,157 236ms SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '' ORDER BY channel_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 00 170 12ms 0ms 01 128 11ms 0ms 02 127 9ms 0ms 03 128 10ms 0ms 04 130 10ms 0ms 05 127 9ms 0ms 06 130 9ms 0ms 07 127 10ms 0ms 08 130 9ms 0ms 09 128 10ms 0ms 10 127 8ms 0ms 11 130 8ms 0ms 12 128 8ms 0ms 13 129 9ms 0ms 14 127 9ms 0ms 15 127 8ms 0ms 16 129 10ms 0ms 17 128 9ms 0ms 18 126 9ms 0ms 19 132 9ms 0ms 20 129 9ms 0ms 21 140 9ms 0ms 22 138 9ms 0ms 23 142 9ms 0ms [ User: symmetricds - Total duration: 236ms - Times executed: 3157 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 236ms - Times executed: 3157 ]
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2018-05-28 01:38:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:27:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 07:55:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 10,449 713ms 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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 00 441 28ms 0ms 01 432 28ms 0ms 02 432 27ms 0ms 03 432 31ms 0ms 04 440 28ms 0ms 05 432 28ms 0ms 06 440 30ms 0ms 07 432 28ms 0ms 08 440 28ms 0ms 09 432 31ms 0ms 10 432 31ms 0ms 11 440 30ms 0ms 12 432 28ms 0ms 13 440 30ms 0ms 14 432 29ms 0ms 15 432 27ms 0ms 16 440 30ms 0ms 17 432 29ms 0ms 18 432 30ms 0ms 19 440 29ms 0ms 20 432 33ms 0ms 21 440 28ms 0ms 22 432 29ms 0ms 23 440 30ms 0ms [ User: symmetricds - Total duration: 713ms - Times executed: 10449 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - Times executed: 10449 ]
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
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 FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-05-28 20:48:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 18:10:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 05:39:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 7,790 433ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 00 326 18ms 0ms 01 323 18ms 0ms 02 325 17ms 0ms 03 324 17ms 0ms 04 324 17ms 0ms 05 324 17ms 0ms 06 327 18ms 0ms 07 324 18ms 0ms 08 324 17ms 0ms 09 324 17ms 0ms 10 325 17ms 0ms 11 324 17ms 0ms 12 326 18ms 0ms 13 324 17ms 0ms 14 324 17ms 0ms 15 325 18ms 0ms 16 324 17ms 0ms 17 324 18ms 0ms 18 324 18ms 0ms 19 325 17ms 0ms 20 325 17ms 0ms 21 324 17ms 0ms 22 324 18ms 0ms 23 327 17ms 0ms [ User: symmetricds - Total duration: 433ms - Times executed: 7790 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 433ms - Times executed: 7790 ]
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
-
SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = 'RT';
Date: 2018-05-28 12:01:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 16:27:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 18:29:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 2ms 0ms 14,543 750ms 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 WHERE node_id = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 00 631 32ms 0ms 01 601 31ms 0ms 02 603 29ms 0ms 03 602 30ms 0ms 04 607 31ms 0ms 05 602 30ms 0ms 06 610 31ms 0ms 07 602 31ms 0ms 08 607 32ms 0ms 09 602 29ms 0ms 10 603 31ms 0ms 11 607 32ms 0ms 12 604 31ms 0ms 13 607 31ms 0ms 14 602 30ms 0ms 15 603 31ms 0ms 16 607 30ms 0ms 17 602 31ms 0ms 18 602 30ms 0ms 19 608 31ms 0ms 20 603 34ms 0ms 21 610 31ms 0ms 22 605 30ms 0ms 23 613 30ms 0ms [ User: symmetricds - Total duration: 750ms - Times executed: 14543 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 750ms - Times executed: 14543 ]
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
-
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 WHERE node_id = '3';
Date: 2018-05-28 20:33:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 20:45:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 8ms 0ms 70,110 3s322ms 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 May 28 00 2,934 139ms 0ms 01 2,907 139ms 0ms 02 2,925 137ms 0ms 03 2,916 136ms 0ms 04 2,916 136ms 0ms 05 2,916 139ms 0ms 06 2,943 139ms 0ms 07 2,916 136ms 0ms 08 2,916 137ms 0ms 09 2,916 139ms 0ms 10 2,925 141ms 0ms 11 2,916 135ms 0ms 12 2,934 137ms 0ms 13 2,916 138ms 0ms 14 2,916 139ms 0ms 15 2,925 137ms 0ms 16 2,916 135ms 0ms 17 2,916 138ms 0ms 18 2,916 138ms 0ms 19 2,925 147ms 0ms 20 2,925 133ms 0ms 21 2,916 137ms 0ms 22 2,916 139ms 0ms 23 2,943 140ms 0ms [ User: symmetricds - Total duration: 3s322ms - Times executed: 70110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s322ms - Times executed: 70110 ]
-
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: 2018-05-28 19:23:56 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 22:53:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 17:05:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 2,612 111ms 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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = '' AND d.data_event_action = '' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 00 110 4ms 0ms 01 108 4ms 0ms 02 108 4ms 0ms 03 108 4ms 0ms 04 110 4ms 0ms 05 108 4ms 0ms 06 110 4ms 0ms 07 108 4ms 0ms 08 110 4ms 0ms 09 108 4ms 0ms 10 108 4ms 0ms 11 110 4ms 0ms 12 108 4ms 0ms 13 110 4ms 0ms 14 108 4ms 0ms 15 108 4ms 0ms 16 110 4ms 0ms 17 108 4ms 0ms 18 108 4ms 0ms 19 110 4ms 0ms 20 108 4ms 0ms 21 110 4ms 0ms 22 108 4ms 0ms 23 110 4ms 0ms [ User: symmetricds - Total duration: 111ms - Times executed: 2612 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 111ms - Times executed: 2612 ]
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
-
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 FROM sym_node c INNER JOIN sym_node_group_link d ON c.node_group_id = d.source_node_group_id WHERE d.target_node_group_id = 'redditch' AND d.data_event_action = 'W' AND c.node_id NOT IN ( SELECT node_id FROM sym_node_identity);
Date: 2018-05-28 11:09:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 03:39:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-05-28 04:55:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 5,724,785 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 28 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-05-28 00:00:39 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: