pgBadger-
Global information
- Generated on Sun Nov 25 00:00:44 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,682,644 log entries in 42s
- Log start from 2018-11-24 00:00:00 to 2018-11-24 23:59:59
-
Overview
Global Stats
- 201 Number of unique normalized queries
- 2,278,070 Number of queries
- 1m12s Total query duration
- 2018-11-24 00:00:00 First query
- 2018-11-24 23:59:59 Last query
- 1,911 queries/s at 2018-11-24 18:20:00 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
- 284 Total number of automatic vacuums
- 304 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,831 Total number of sessions
- 1 sessions at 2018-11-24 23:38:21 Session peak
- 10d58m53s Total duration of sessions
- 7m53s Average duration of sessions
- 1,244 Average queries per session
- 39ms Average queries duration per session
- 1,831 Total number of connections
- 5 connections/s at 2018-11-24 00:00:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,911 queries/s Query Peak
- 2018-11-24 18:20:00 Date
SELECT Traffic
Key values
- 1,881 queries/s Query Peak
- 2018-11-24 16:20:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 460 queries/s Query Peak
- 2018-11-24 03:20:11 Date
Queries duration
Key values
- 1m12s Total query duration
Prepared queries ratio
Key values
- 1.74 Ratio of bind vs prepare
- 162.08 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 24 00 108,763 0ms 28ms 0ms 85ms 286ms 1s977ms 01 96,490 0ms 113ms 0ms 66ms 228ms 494ms 02 96,127 0ms 77ms 0ms 64ms 171ms 519ms 03 96,669 0ms 22ms 0ms 69ms 240ms 392ms 04 95,985 0ms 35ms 0ms 67ms 153ms 470ms 05 95,572 0ms 19ms 0ms 60ms 82ms 470ms 06 93,667 0ms 18ms 0ms 52ms 85ms 349ms 07 93,811 0ms 129ms 0ms 53ms 92ms 694ms 08 93,711 0ms 74ms 0ms 62ms 85ms 594ms 09 93,709 0ms 84ms 0ms 59ms 90ms 624ms 10 93,777 0ms 99ms 0ms 53ms 83ms 500ms 11 95,339 0ms 474ms 0ms 63ms 157ms 1s149ms 12 93,683 0ms 69ms 0ms 51ms 79ms 377ms 13 93,782 0ms 99ms 0ms 60ms 75ms 414ms 14 93,804 0ms 75ms 0ms 63ms 69ms 335ms 15 93,768 0ms 71ms 0ms 62ms 68ms 287ms 16 93,548 0ms 38ms 0ms 59ms 66ms 228ms 17 93,760 0ms 33ms 0ms 55ms 82ms 216ms 18 93,273 0ms 26ms 0ms 59ms 81ms 209ms 19 93,704 0ms 19ms 0ms 57ms 69ms 189ms 20 94,250 0ms 41ms 0ms 62ms 81ms 543ms 21 93,670 0ms 20ms 0ms 55ms 76ms 186ms 22 93,608 0ms 24ms 0ms 51ms 65ms 198ms 23 93,600 0ms 49ms 0ms 59ms 82ms 229ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 24 00 40,110 0 0ms 29ms 42ms 356ms 01 33,087 0 0ms 32ms 35ms 139ms 02 33,023 0 0ms 33ms 39ms 161ms 03 33,050 0 0ms 28ms 35ms 152ms 04 32,967 0 0ms 28ms 31ms 150ms 05 32,886 0 0ms 27ms 32ms 166ms 06 32,405 0 0ms 27ms 32ms 142ms 07 32,458 0 0ms 27ms 30ms 136ms 08 32,434 0 0ms 28ms 32ms 140ms 09 32,385 0 0ms 27ms 29ms 144ms 10 32,430 0 0ms 28ms 34ms 137ms 11 33,882 0 0ms 27ms 31ms 176ms 12 32,419 0 0ms 28ms 32ms 127ms 13 32,435 0 0ms 28ms 31ms 137ms 14 32,468 0 0ms 29ms 38ms 149ms 15 32,430 0 0ms 29ms 38ms 141ms 16 32,351 0 0ms 28ms 35ms 81ms 17 32,429 0 0ms 27ms 31ms 136ms 18 32,329 0 0ms 28ms 34ms 142ms 19 32,449 0 0ms 27ms 35ms 141ms 20 33,047 0 0ms 27ms 39ms 157ms 21 32,372 0 0ms 28ms 35ms 135ms 22 32,327 0 0ms 26ms 29ms 138ms 23 32,360 0 0ms 28ms 31ms 134ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 24 00 1,263 1,701 108 0 0ms 9ms 14ms 50ms 01 1,473 971 112 0 0ms 2ms 9ms 68ms 02 1,176 895 109 0 0ms 2ms 8ms 52ms 03 1,651 1,012 109 0 0ms 1ms 8ms 120ms 04 1,151 888 111 0 0ms 1ms 8ms 60ms 05 944 838 112 0 0ms 1ms 8ms 52ms 06 88 581 106 0 0ms 1ms 5ms 8ms 07 88 581 109 0 0ms 1ms 5ms 10ms 08 88 581 96 0 0ms 1ms 8ms 11ms 09 88 580 91 0 0ms 1ms 5ms 10ms 10 88 581 91 0 0ms 1ms 8ms 11ms 11 93 596 91 0 0ms 1ms 7ms 10ms 12 88 582 89 0 0ms 1ms 5ms 11ms 13 88 582 88 0 0ms 1ms 4ms 10ms 14 88 579 82 0 0ms 1ms 5ms 9ms 15 88 582 87 0 0ms 1ms 3ms 10ms 16 88 580 79 0 0ms 1ms 4ms 10ms 17 88 581 81 0 0ms 1ms 3ms 9ms 18 88 573 81 0 0ms 1ms 7ms 9ms 19 89 598 83 0 0ms 1ms 6ms 9ms 20 105 604 111 0 0ms 1ms 7ms 9ms 21 88 579 79 0 0ms 1ms 3ms 9ms 22 88 581 80 0 0ms 1ms 3ms 9ms 23 88 582 84 0 0ms 1ms 5ms 10ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 24 00 60,885 108,727 1.79 86.72% 01 55,028 96,454 1.75 91.55% 02 55,499 96,091 1.73 92.98% 03 55,072 96,633 1.75 91.35% 04 54,998 95,949 1.74 92.32% 05 54,988 95,536 1.74 92.86% 06 54,135 93,631 1.73 94.26% 07 54,149 93,775 1.73 94.13% 08 54,366 93,675 1.72 94.62% 09 53,630 93,673 1.75 93.38% 10 54,139 93,741 1.73 94.19% 11 54,562 95,303 1.75 92.45% 12 54,358 93,647 1.72 94.64% 13 54,181 93,746 1.73 94.26% 14 54,498 93,768 1.72 94.77% 15 54,091 93,732 1.73 94.11% 16 53,788 93,512 1.74 93.80% 17 54,174 93,724 1.73 94.27% 18 54,297 93,237 1.72 94.92% 19 54,342 93,668 1.72 94.56% 20 54,240 94,214 1.74 93.40% 21 53,562 93,634 1.75 93.30% 22 53,188 93,572 1.76 92.72% 23 53,761 93,564 1.74 93.72% Day Hour Count Average / Second Nov 24 00 81 0.02/s 01 77 0.02/s 02 83 0.02/s 03 67 0.02/s 04 81 0.02/s 05 79 0.02/s 06 77 0.02/s 07 76 0.02/s 08 82 0.02/s 09 70 0.02/s 10 80 0.02/s 11 80 0.02/s 12 80 0.02/s 13 78 0.02/s 14 83 0.02/s 15 76 0.02/s 16 67 0.02/s 17 78 0.02/s 18 82 0.02/s 19 78 0.02/s 20 78 0.02/s 21 65 0.02/s 22 58 0.02/s 23 75 0.02/s Day Hour Count Average Duration Nov 24 00 81 7m35s 01 77 7m49s 02 83 7m13s 03 67 7m52s 04 81 8m22s 05 79 7m29s 06 77 7m13s 07 76 7m41s 08 82 7m44s 09 70 7m55s 10 80 8m40s 11 80 7m9s 12 80 7m50s 13 78 7m45s 14 83 6m56s 15 76 7m51s 16 67 8m30s 17 78 8m22s 18 82 7m30s 19 78 7m32s 20 78 7m32s 21 65 8m11s 22 58 10m26s 23 75 9m9s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2018-11-24 00:00:20 Date
Connections per database
Key values
- pharmisight Main Database
- 1,831 connections Total
Connections per user
Key values
- pharmisight Main User
- 1,831 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2018-11-24 23:38:21 Date
Histogram of session times
Key values
- 1,284 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,831 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 1,831 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,831 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,052 buffers Checkpoint Peak
- 2018-11-24 07:07:27 Date
- 149.316 seconds Highest write time
- 0.021 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2018-11-24 07:10:02 Date
Checkpoints distance
Key values
Checkpoint mean distance and estimate (5 minutes period)
NO DATASET
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 24 00 1,749 175.165s 0.017s 175.226s 01 959 96.129s 0.014s 96.202s 02 909 91.084s 0.014s 91.138s 03 1,004 100.625s 0.026s 100.69s 04 4,163 212.744s 0.016s 212.823s 05 730 73.223s 0.019s 73.289s 06 799 80.164s 0.016s 80.218s 07 5,489 193.165s 0.024s 193.224s 08 1,882 188.418s 0.017s 188.477s 09 2,646 195.529s 0.016s 195.581s 10 1,887 188.841s 0.024s 188.905s 11 1,867 186.923s 0.018s 187.004s 12 1,911 191.041s 0.021s 191.111s 13 1,492 149.966s 0.011s 150.022s 14 1,250 125.078s 0.015s 125.14s 15 1,346 134.68s 0.013s 134.73s 16 1,123 112.548s 0.015s 112.601s 17 1,021 102.417s 0.035s 102.49s 18 777 77.924s 0.023s 77.989s 19 677 67.898s 0.053s 67.995s 20 607 60.886s 0.015s 60.938s 21 610 61.185s 0.015s 61.238s 22 649 65.124s 0.016s 65.181s 23 842 84.465s 0.014s 84.528s Day Hour Added Removed Recycled Synced files Longest sync Average sync Nov 24 00 0 0 0 367 0.002s 0s 01 0 0 1 324 0.002s 0s 02 0 0 0 328 0.002s 0s 03 0 0 0 319 0.008s 0s 04 0 0 1 318 0.002s 0s 05 0 0 0 309 0.002s 0s 06 0 0 1 279 0.002s 0s 07 0 0 2 282 0.007s 0s 08 0 0 1 277 0.002s 0s 09 0 0 1 282 0.002s 0s 10 0 0 0 289 0.008s 0s 11 0 0 1 322 0.005s 0s 12 0 0 0 296 0.008s 0s 13 0 0 1 303 0.002s 0s 14 0 0 0 297 0.002s 0s 15 0 0 0 298 0.002s 0s 16 0 0 1 298 0.002s 0s 17 0 0 0 293 0.018s 0s 18 0 0 0 290 0.008s 0s 19 0 0 0 283 0.021s 0s 20 0 0 0 298 0.002s 0s 21 0 0 0 284 0.002s 0s 22 0 0 1 279 0.002s 0s 23 0 0 0 294 0.003s 0s Day Hour Count Avg time (sec) Nov 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Nov 24 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
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 24 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
- 11.27 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight - 2018-11-24 04:00:52 Date
- 3.14 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-11-24 08:00:50 Date
Analyzes per table
Key values
- public.sym_node_communication (209) Main table analyzed (database pharmisight)
- 304 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 209 pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data_event 13 pharmisight.public.sym_data 12 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_incoming_batch 11 pharmisight.public.sym_lock 11 pharmisight.public.sym_sequence 8 pharmisight.public.sym_node_host 6 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_delays 1 Total 304 Vacuums per table
Key values
- public.sym_node_communication (205) Main table vacuumed on database pharmisight
- 284 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 205 0 pharmisight.public.sym_outgoing_batch 12 12 pharmisight.public.sym_data_event 12 12 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_data 11 11 pharmisight.public.sym_sequence 8 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.public.sym_node_channel_ctl 3 0 pharmisight.pg_toast.pg_toast_2619 2 2 Total 284 52 Tuples removed per table
Key values
- public.sym_data_event (44280) Main table with removed tuples on database pharmisight
- 80813 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 12 12 44280 912 pharmisight.public.sym_data 11 11 15855 4493 pharmisight.public.sym_node_communication 205 0 11496 0 pharmisight.public.sym_outgoing_batch 12 12 5211 0 pharmisight.public.sym_incoming_batch 6 6 1220 0 pharmisight.pg_catalog.pg_statistic 3 3 875 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 8 0 411 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_toast.pg_toast_2619 2 2 169 0 pharmisight.public.sym_node_channel_ctl 3 0 158 0 Total 284 52 80,813 5,405 Pages removed per table
Key values
- public.sym_data (4493) Main table with removed pages on database pharmisight
- 5405 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 11 11 15855 4493 pharmisight.public.sym_data_event 12 12 44280 912 pharmisight.public.sym_incoming_batch 6 6 1220 0 pharmisight.public.sym_outgoing_batch 12 12 5211 0 pharmisight.public.sym_node_communication 205 0 11496 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.pg_toast.pg_toast_2619 2 2 169 0 pharmisight.public.sym_sequence 8 0 411 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_catalog.pg_statistic 3 3 875 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_channel_ctl 3 0 158 0 Total 284 52 80,813 5,405 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 24 00 12 14 01 11 12 02 11 11 03 8 10 04 14 13 05 11 10 06 11 10 07 11 15 08 10 14 09 15 14 10 13 12 11 13 15 12 13 13 13 14 14 14 12 13 15 13 14 16 13 14 17 14 14 18 13 12 19 12 10 20 9 13 21 9 12 22 12 12 23 10 13 - 11.27 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
- 790,533 Total read queries
- 614,465 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,278,070 Requests
- 1m12s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,265,692 Requests
User Request type Count Duration pharmisight Total 105,148 9s159ms DELETE 32 2ms INSERT 1,900 985ms OTHERS 3,156 102ms SELECT 99,423 7s976ms TCL 586 75ms UPDATE 51 17ms symmetricds Total 2,265,692 1m1s DDL 1 1ms DELETE 2,310 4s289ms INSERT 8,242 1s24ms OTHERS 906,233 16s427ms SELECT 721,355 25s735ms TCL 609,959 9s796ms UPDATE 17,592 4s524ms tony Total 900 4s599ms SELECT 900 4s599ms Duration by user
Key values
- 1m1s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 105,148 9s159ms DELETE 32 2ms INSERT 1,900 985ms OTHERS 3,156 102ms SELECT 99,423 7s976ms TCL 586 75ms UPDATE 51 17ms symmetricds Total 2,265,692 1m1s DDL 1 1ms DELETE 2,310 4s289ms INSERT 8,242 1s24ms OTHERS 906,233 16s427ms SELECT 721,355 25s735ms TCL 609,959 9s796ms UPDATE 17,592 4s524ms tony Total 900 4s599ms SELECT 900 4s599ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,370,840 Requests
- 1m10s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,275,663 Requests
- 1m8s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-11-24 18:41:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,273,919 0-1ms duration
Slowest individual queries
Rank Duration Query 1 474ms SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-31 23:00:00' AND '2018-11-29 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;[ Date: 2018-11-24 11:43:59 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 422ms SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-09-30 23:00:00' AND '2018-10-30 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;[ Date: 2018-11-24 11:43:15 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 129ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8245312' AND '8245937' AND STATUS != 'OK') AND batch_id BETWEEN '8245312' AND '8245937';[ Date: 2018-11-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 113ms DELETE FROM sym_data WHERE data_id BETWEEN '92441543' AND '92446543' AND create_time < '2018-11-23 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 99ms DELETE FROM sym_data WHERE data_id BETWEEN '92483346' AND '92488346' AND create_time < '2018-11-23 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 99ms DELETE FROM sym_data WHERE data_id BETWEEN '92496289' AND '92501289' AND create_time < '2018-11-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 84ms DELETE FROM sym_data WHERE data_id BETWEEN '92475967' AND '92480967' AND create_time < '2018-11-23 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92475967' AND '92480967') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92475967' AND '92480967' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 82ms DELETE FROM sym_data WHERE data_id BETWEEN '92488290' AND '92493290' AND create_time < '2018-11-23 11:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92488290' AND '92493290') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92488290' AND '92493290' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 77ms DELETE FROM sym_data WHERE data_id BETWEEN '92441703' AND '92446703' AND create_time < '2018-11-23 02:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441703' AND '92446703') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441703' AND '92446703' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 75ms DELETE FROM sym_data WHERE data_id BETWEEN '92500110' AND '92505110' AND create_time < '2018-11-23 14:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92500110' AND '92505110') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92500110' AND '92505110' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 74ms DELETE FROM sym_data WHERE data_id BETWEEN '92469819' AND '92474819' AND create_time < '2018-11-23 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92469819' AND '92474819') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92469819' AND '92474819' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 71ms DELETE FROM sym_data WHERE data_id BETWEEN '92480968' AND '92485968' AND create_time < '2018-11-23 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92480968' AND '92485968') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92480968' AND '92485968' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 71ms DELETE FROM sym_data WHERE data_id BETWEEN '92502568' AND '92507568' AND create_time < '2018-11-23 15:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92502568' AND '92507568') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92502568' AND '92507568' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 69ms DELETE FROM sym_data WHERE data_id BETWEEN '92492902' AND '92497902' AND create_time < '2018-11-23 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92492902' AND '92497902') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92492902' AND '92497902' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 58ms DELETE FROM sym_data WHERE data_id BETWEEN '92443023' AND '92448023' AND create_time < '2018-11-23 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92443023' AND '92448023') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92443023' AND '92448023' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 51ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8246580' AND '8247273' AND STATUS != 'OK') AND batch_id BETWEEN '8246580' AND '8247273';[ Date: 2018-11-24 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 49ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8245938' AND '8246579' AND STATUS != 'OK') AND batch_id BETWEEN '8245938' AND '8246579';[ Date: 2018-11-24 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 49ms DELETE FROM sym_data WHERE data_id BETWEEN '92508206' AND '92510701' AND create_time < '2018-11-23 23:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92508206' AND '92510701') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92508206' AND '92510701' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 23:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 48ms DELETE FROM sym_data WHERE data_id BETWEEN '92474820' AND '92479820' AND create_time < '2018-11-23 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92474820' AND '92479820') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92474820' AND '92479820' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 48ms DELETE FROM sym_data WHERE data_id BETWEEN '92448024' AND '92453024' AND create_time < '2018-11-23 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92448024' AND '92453024') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92448024' AND '92453024' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-11-24 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15s788ms 869,986 0ms 3ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 24 00 38,419 673ms 0ms 01 36,256 661ms 0ms 02 36,298 657ms 0ms 03 36,272 668ms 0ms 04 36,272 642ms 0ms 05 36,224 666ms 0ms 06 36,106 652ms 0ms 07 36,160 665ms 0ms 08 36,116 660ms 0ms 09 36,161 668ms 0ms 10 36,163 657ms 0ms 11 36,187 657ms 0ms 12 36,113 645ms 0ms 13 36,168 658ms 0ms 14 36,158 651ms 0ms 15 36,164 665ms 0ms 16 36,093 649ms 0ms 17 36,161 663ms 0ms 18 35,928 649ms 0ms 19 36,101 652ms 0ms 20 36,047 659ms 0ms 21 36,157 657ms 0ms 22 36,153 660ms 0ms 23 36,109 641ms 0ms [ User: symmetricds - Total duration: 15s750ms - Times executed: 868957 ]
[ User: pharmisight - Total duration: 38ms - Times executed: 1029 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s788ms - Times executed: 869986 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-11-24 13:09:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:59:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 20:59:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s536ms 293,060 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 24 00 13,511 600ms 0ms 01 12,230 352ms 0ms 02 12,242 323ms 0ms 03 12,233 330ms 0ms 04 12,229 326ms 0ms 05 12,217 331ms 0ms 06 12,125 302ms 0ms 07 12,144 289ms 0ms 08 12,128 293ms 0ms 09 12,144 295ms 0ms 10 12,144 293ms 0ms 11 12,177 295ms 0ms 12 12,128 286ms 0ms 13 12,144 289ms 0ms 14 12,144 299ms 0ms 15 12,144 298ms 0ms 16 12,124 289ms 0ms 17 12,144 285ms 0ms 18 12,067 297ms 0ms 19 12,126 301ms 0ms 20 12,102 281ms 0ms 21 12,144 283ms 0ms 22 12,144 283ms 0ms 23 12,125 303ms 0ms [ User: symmetricds - Total duration: 7s470ms - Times executed: 292777 ]
[ User: pharmisight - Total duration: 65ms - Times executed: 283 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s536ms - Times executed: 293060 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-11-24 01:40:35 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 08:35:42 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:38:32 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 5s1ms 385,259 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 24 00 17,814 224ms 0ms 01 16,073 205ms 0ms 02 16,090 205ms 0ms 03 16,079 208ms 0ms 04 16,080 205ms 0ms 05 16,059 209ms 0ms 06 15,954 208ms 0ms 07 15,985 210ms 0ms 08 15,946 209ms 0ms 09 15,967 206ms 0ms 10 15,963 214ms 0ms 11 15,993 212ms 0ms 12 15,943 205ms 0ms 13 15,965 205ms 0ms 14 15,957 206ms 0ms 15 15,965 210ms 0ms 16 15,925 206ms 0ms 17 15,953 205ms 0ms 18 15,877 203ms 0ms 19 15,930 206ms 0ms 20 15,897 210ms 0ms 21 15,956 209ms 0ms 22 15,956 205ms 0ms 23 15,932 205ms 0ms [ User: symmetricds - Total duration: 5s1ms - Times executed: 385259 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s1ms - Times executed: 385259 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-11-24 11:59:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:52:56 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:52:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s485ms 77,237 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 24 00 3,204 144ms 0ms 01 3,213 147ms 0ms 02 3,222 145ms 0ms 03 3,222 143ms 0ms 04 3,222 145ms 0ms 05 3,213 147ms 0ms 06 3,213 142ms 0ms 07 3,222 145ms 0ms 08 3,213 146ms 0ms 09 3,222 147ms 0ms 10 3,222 143ms 0ms 11 3,222 142ms 0ms 12 3,213 144ms 0ms 13 3,222 147ms 0ms 14 3,222 144ms 0ms 15 3,222 143ms 0ms 16 3,213 145ms 0ms 17 3,222 146ms 0ms 18 3,222 145ms 0ms 19 3,212 142ms 0ms 20 3,222 145ms 0ms 21 3,222 147ms 0ms 22 3,222 147ms 0ms 23 3,213 142ms 0ms [ User: symmetricds - Total duration: 3s485ms - Times executed: 77237 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s485ms - Times executed: 77237 ]
-
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-11-24 00:09:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:24:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:06:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s466ms 288 1ms 12ms 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 #5
Day Hour Count Duration Avg duration Nov 24 00 12 145ms 12ms 01 12 144ms 12ms 02 12 145ms 12ms 03 12 145ms 12ms 04 12 144ms 12ms 05 12 146ms 12ms 06 12 144ms 12ms 07 12 144ms 12ms 08 12 144ms 12ms 09 12 145ms 12ms 10 12 144ms 12ms 11 12 144ms 12ms 12 12 144ms 12ms 13 12 146ms 12ms 14 12 145ms 12ms 15 12 145ms 12ms 16 12 125ms 10ms 17 12 145ms 12ms 18 12 146ms 12ms 19 12 144ms 12ms 20 12 146ms 12ms 21 12 144ms 12ms 22 12 144ms 12ms 23 12 146ms 12ms [ User: tony - Total duration: 3s466ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s466ms - 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-11-24 16:41:32 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 15:56:21 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 22:01:23 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
6 2s854ms 159 0ms 113ms 17ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 24 00 14 105ms 7ms 01 14 185ms 13ms 02 14 146ms 10ms 03 14 94ms 6ms 04 14 105ms 7ms 05 14 90ms 6ms 06 14 87ms 6ms 07 14 277ms 19ms 08 9 318ms 35ms 09 7 312ms 44ms 10 6 239ms 39ms 11 5 180ms 36ms 12 4 144ms 36ms 13 3 146ms 48ms 14 3 96ms 32ms 15 2 86ms 43ms 16 1 38ms 38ms 17 1 33ms 33ms 18 1 26ms 26ms 19 1 19ms 19ms 20 1 23ms 23ms 21 1 20ms 20ms 22 1 24ms 24ms 23 1 49ms 49ms [ User: symmetricds - Total duration: 2s854ms - Times executed: 159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s854ms - Times executed: 159 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '92441543' AND '92446543' AND create_time < '2018-11-23 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '92483346' AND '92488346' AND create_time < '2018-11-23 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '92496289' AND '92501289' AND create_time < '2018-11-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-11-24 01:00:00 Duration: 113ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 2s632ms 48,510 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 24 00 2,970 137ms 0ms 01 1,980 92ms 0ms 02 1,980 109ms 0ms 03 1,980 101ms 0ms 04 1,980 109ms 0ms 05 1,980 112ms 0ms 06 1,980 117ms 0ms 07 1,980 111ms 0ms 08 1,980 110ms 0ms 09 1,980 112ms 0ms 10 1,980 111ms 0ms 11 1,980 110ms 0ms 12 1,980 95ms 0ms 13 1,980 110ms 0ms 14 1,980 116ms 0ms 15 1,980 109ms 0ms 16 1,980 83ms 0ms 17 1,980 110ms 0ms 18 1,980 112ms 0ms 19 1,980 113ms 0ms 20 1,980 110ms 0ms 21 1,980 109ms 0ms 22 1,980 113ms 0ms 23 1,980 110ms 0ms [ User: pharmisight - Total duration: 2s632ms - Times executed: 48510 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s632ms - Times executed: 48510 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965578' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33016204' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3549' ORDER BY itemcodes0_.code ASC;
Date: 2018-11-24 12:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 2s377ms 43,071 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 24 00 2,637 125ms 0ms 01 1,758 83ms 0ms 02 1,758 100ms 0ms 03 1,758 92ms 0ms 04 1,758 98ms 0ms 05 1,758 100ms 0ms 06 1,758 104ms 0ms 07 1,758 100ms 0ms 08 1,758 99ms 0ms 09 1,758 101ms 0ms 10 1,758 100ms 0ms 11 1,758 100ms 0ms 12 1,758 87ms 0ms 13 1,758 100ms 0ms 14 1,758 104ms 0ms 15 1,758 99ms 0ms 16 1,758 75ms 0ms 17 1,758 100ms 0ms 18 1,758 101ms 0ms 19 1,758 101ms 0ms 20 1,758 99ms 0ms 21 1,758 99ms 0ms 22 1,758 101ms 0ms 23 1,758 99ms 0ms [ User: pharmisight - Total duration: 2s377ms - Times executed: 43071 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s377ms - Times executed: 43071 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '8' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3113' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074096' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-11-24 02:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s913ms 293,061 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 24 00 13,511 85ms 0ms 01 12,231 80ms 0ms 02 12,242 79ms 0ms 03 12,232 81ms 0ms 04 12,229 78ms 0ms 05 12,217 80ms 0ms 06 12,126 79ms 0ms 07 12,143 80ms 0ms 08 12,128 79ms 0ms 09 12,144 79ms 0ms 10 12,144 79ms 0ms 11 12,177 80ms 0ms 12 12,128 79ms 0ms 13 12,145 79ms 0ms 14 12,143 78ms 0ms 15 12,145 79ms 0ms 16 12,123 79ms 0ms 17 12,144 79ms 0ms 18 12,067 77ms 0ms 19 12,126 78ms 0ms 20 12,102 80ms 0ms 21 12,145 78ms 0ms 22 12,143 78ms 0ms 23 12,126 77ms 0ms [ User: symmetricds - Total duration: 1s911ms - Times executed: 292777 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 284 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s913ms - Times executed: 293061 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-11-24 20:20:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:31:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:36:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s529ms 68,663 0ms 1ms 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 #10
Day Hour Count Duration Avg duration Nov 24 00 2,849 66ms 0ms 01 2,858 67ms 0ms 02 2,864 66ms 0ms 03 2,867 67ms 0ms 04 2,865 65ms 0ms 05 2,857 66ms 0ms 06 2,856 65ms 0ms 07 2,864 67ms 0ms 08 2,856 64ms 0ms 09 2,864 63ms 0ms 10 2,864 63ms 0ms 11 2,864 62ms 0ms 12 2,856 61ms 0ms 13 2,864 62ms 0ms 14 2,864 62ms 0ms 15 2,864 62ms 0ms 16 2,855 62ms 0ms 17 2,864 61ms 0ms 18 2,864 62ms 0ms 19 2,856 62ms 0ms 20 2,864 62ms 0ms 21 2,864 62ms 0ms 22 2,864 62ms 0ms 23 2,856 61ms 0ms [ User: symmetricds - Total duration: 1s529ms - Times executed: 68663 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s529ms - Times executed: 68663 ]
-
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 '92509187' AND '142509186')) 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 '92509844' AND '142509843')) 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 '92509510' AND '142509509')) ORDER BY d.data_id ASC;
Date: 2018-11-24 01:40:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 03:40:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:40:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s442ms 269 3ms 9ms 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 #11
Day Hour Count Duration Avg duration Nov 24 00 214 1s81ms 5ms 01 4 22ms 5ms 02 4 30ms 7ms 03 3 17ms 5ms 04 3 18ms 6ms 05 4 30ms 7ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 3 25ms 8ms 12 2 8ms 4ms 13 2 13ms 6ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 14ms 7ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 1s238ms - Times executed: 224 ]
[ User: pharmisight - Total duration: 204ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s442ms - Times executed: 269 ]
-
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 = 'item_codes' 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 = 'item_codes' 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 = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-11-24 19:15:23 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:15:23 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 09:15:43 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s263ms 5,808 0ms 3ms 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 #12
Day Hour Count Duration Avg duration Nov 24 00 246 51ms 0ms 01 244 52ms 0ms 02 240 51ms 0ms 03 247 51ms 0ms 04 240 50ms 0ms 05 242 53ms 0ms 06 240 53ms 0ms 07 246 52ms 0ms 08 240 48ms 0ms 09 240 55ms 0ms 10 241 52ms 0ms 11 243 53ms 0ms 12 244 53ms 0ms 13 244 56ms 0ms 14 244 50ms 0ms 15 240 51ms 0ms 16 243 53ms 0ms 17 242 53ms 0ms 18 237 49ms 0ms 19 241 52ms 0ms 20 243 54ms 0ms 21 240 57ms 0ms 22 241 52ms 0ms 23 240 50ms 0ms [ User: symmetricds - Total duration: 1s263ms - Times executed: 5808 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s263ms - Times executed: 5808 ]
-
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 = '2' 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-11-24 09:30:47 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:04:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:42:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s259ms 57,600 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 Nov 24 00 2,440 49ms 0ms 01 2,400 52ms 0ms 02 2,400 51ms 0ms 03 2,400 54ms 0ms 04 2,400 51ms 0ms 05 2,400 52ms 0ms 06 2,400 54ms 0ms 07 2,400 55ms 0ms 08 2,400 49ms 0ms 09 2,400 53ms 0ms 10 2,400 52ms 0ms 11 2,400 51ms 0ms 12 2,400 51ms 0ms 13 2,400 52ms 0ms 14 2,400 53ms 0ms 15 2,400 51ms 0ms 16 2,400 55ms 0ms 17 2,400 52ms 0ms 18 2,360 52ms 0ms 19 2,400 52ms 0ms 20 2,400 52ms 0ms 21 2,400 52ms 0ms 22 2,400 53ms 0ms 23 2,400 51ms 0ms [ User: symmetricds - Total duration: 1s259ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s259ms - Times executed: 57600 ]
-
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 = 'pharmisight';
-
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-11-24 18:09:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:45:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 16:10:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 1s64ms 189 0ms 10ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = '', "os_user" = '', "os_name" = '', "os_arch" = '', "os_version" = '', "available_processors" = '', "free_memory_bytes" = '', "total_memory_bytes" = '', "max_memory_bytes" = '', "java_version" = '', "java_vendor" = '', "symmetric_version" = '', "timezone_offset" = '', "heartbeat_time" = '', "last_restart_time" = '', "create_time" = '', "jdbc_version" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 24 00 8 52ms 6ms 01 8 47ms 5ms 02 8 51ms 6ms 03 8 52ms 6ms 04 8 44ms 5ms 05 8 44ms 5ms 06 8 42ms 5ms 07 8 48ms 6ms 08 8 49ms 6ms 09 8 38ms 4ms 10 8 46ms 5ms 11 8 49ms 6ms 12 8 39ms 4ms 13 8 40ms 5ms 14 8 59ms 7ms 15 8 33ms 4ms 16 8 30ms 3ms 17 8 30ms 3ms 18 8 47ms 5ms 19 8 55ms 6ms 20 5 33ms 6ms 21 8 44ms 5ms 22 8 28ms 3ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s64ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s64ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '100765880', "total_memory_bytes" = '532676608', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 00:22:12', "last_restart_time" = '2018-11-20 12:12:12', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '159775544', "total_memory_bytes" = '523763712', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 23:34:44', "last_restart_time" = '2018-11-20 13:49:33.42', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '177181992', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 15:34:44', "last_restart_time" = '2018-11-20 13:49:33.42', "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-11-24 00:24:07 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 23:35:41 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:35:08 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 927ms 5,760 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 #15
Day Hour Count Duration Avg duration Nov 24 00 244 38ms 0ms 01 240 39ms 0ms 02 240 38ms 0ms 03 240 36ms 0ms 04 240 35ms 0ms 05 240 41ms 0ms 06 240 37ms 0ms 07 240 41ms 0ms 08 240 35ms 0ms 09 240 42ms 0ms 10 240 42ms 0ms 11 240 41ms 0ms 12 240 36ms 0ms 13 240 39ms 0ms 14 240 36ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 39ms 0ms 18 236 37ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 40ms 0ms 22 240 38ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 927ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 927ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 09:04:46.628', last_lock_time = '2018-11-24 09:04:46.628' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 07:04:46.628');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 00:41:33.971', last_lock_time = '2018-11-24 00:41:33.971' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-23 22:41:33.971');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 18:30:00.523', last_lock_time = '2018-11-24 18:30:00.523' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 16:30:00.523');
Date: 2018-11-24 09:04:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 00:41:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:30:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 896ms 2 422ms 474ms 448ms SELECT _lines.routenumber, _lines.deliverydate, _lines.ordernumber, _lines.patientname, _lines.partdescription, _lines.orderqty, _lines.order_line_id, _checks.created AS check_created, _checks.newrxcheck AS check_checked, _checkers.firstname AS checker_firstname, _checkers.lastname AS checker_lastname, _audits.created AS audit_created, _audits.newrxcheck AS audit_checked, _auditors.firstname AS auditor_firstname, _auditors.lastname AS auditor_lastname, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '' AND '') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 24 11 2 896ms 448ms [ User: pharmisight - Total duration: 896ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 896ms - Times executed: 2 ]
-
SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-31 23:00:00' AND '2018-11-29 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;
-
SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-09-30 23:00:00' AND '2018-10-30 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;
Date: 2018-11-24 11:43:59 Duration: 474ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:43:15 Duration: 422ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 857ms 1,720 0ms 9ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 24 00 246 140ms 0ms 01 343 146ms 0ms 02 269 113ms 0ms 03 388 191ms 0ms 04 263 144ms 0ms 05 211 120ms 0ms [ User: pharmisight - Total duration: 857ms - Times executed: 1720 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 857ms - Times executed: 1720 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004812540', '2018-11-24 01:22:48', 'SZKLARCZYKB', '2018-11-24 01:40:00.043', '86738', '5', '150505230129209042');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004812686', '2018-11-24 01:17:01', 'NYERSAHW', '2018-11-24 01:40:00.043', '79771', '360', '150505230129208236');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004816638', '2018-11-24 03:32:51', 'RYBAKJ', '2018-11-24 04:00:01.396', '71951', '5', '150505230129219294');
Date: 2018-11-24 01:40:00 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:40:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:00:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 810ms 16,104 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security WHERE node_id = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 24 00 702 34ms 0ms 01 672 33ms 0ms 02 672 34ms 0ms 03 671 34ms 0ms 04 671 32ms 0ms 05 670 35ms 0ms 06 669 32ms 0ms 07 670 34ms 0ms 08 669 35ms 0ms 09 670 33ms 0ms 10 670 34ms 0ms 11 670 33ms 0ms 12 669 32ms 0ms 13 670 33ms 0ms 14 670 34ms 0ms 15 670 33ms 0ms 16 669 34ms 0ms 17 670 34ms 0ms 18 665 33ms 0ms 19 669 34ms 0ms 20 667 32ms 0ms 21 670 32ms 0ms 22 670 32ms 0ms 23 669 31ms 0ms [ User: symmetricds - Total duration: 810ms - Times executed: 16104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 810ms - Times executed: 16104 ]
-
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-11-24 08:21:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:16:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:43:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 782ms 288 1ms 3ms 2ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 24 00 12 31ms 2ms 01 12 32ms 2ms 02 12 32ms 2ms 03 12 33ms 2ms 04 12 31ms 2ms 05 12 33ms 2ms 06 12 32ms 2ms 07 12 32ms 2ms 08 12 31ms 2ms 09 12 31ms 2ms 10 12 32ms 2ms 11 12 32ms 2ms 12 12 31ms 2ms 13 12 34ms 2ms 14 12 33ms 2ms 15 12 32ms 2ms 16 12 33ms 2ms 17 12 32ms 2ms 18 12 33ms 2ms 19 12 32ms 2ms 20 12 32ms 2ms 21 12 32ms 2ms 22 12 32ms 2ms 23 12 32ms 2ms [ User: tony - Total duration: 782ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 782ms - 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-11-24 13:36:20 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 23:36:21 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 18:11:21 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
20 778ms 5,759 0ms 1ms 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 #20
Day Hour Count Duration Avg duration Nov 24 00 243 31ms 0ms 01 240 31ms 0ms 02 240 31ms 0ms 03 240 31ms 0ms 04 240 32ms 0ms 05 240 34ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 31ms 0ms 09 240 32ms 0ms 10 240 34ms 0ms 11 240 32ms 0ms 12 240 31ms 0ms 13 240 31ms 0ms 14 240 31ms 0ms 15 240 32ms 0ms 16 240 32ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 34ms 0ms 20 240 32ms 0ms 21 240 34ms 0ms 22 240 31ms 0ms 23 240 33ms 0ms [ User: symmetricds - Total duration: 778ms - Times executed: 5759 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 778ms - Times executed: 5759 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '70', success_count = '203510', fail_count = '0', total_success_count = '203510', total_fail_count = '0', total_success_millis = '13552128', total_fail_millis = '0', last_lock_time = '2018-11-24 23:17:07.199' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '80', success_count = '203311', fail_count = '0', total_success_count = '203311', total_fail_count = '0', total_success_millis = '13049800', total_fail_millis = '0', last_lock_time = '2018-11-24 10:24:48.377' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '66', success_count = '203404', fail_count = '0', total_success_count = '203404', total_fail_count = '0', total_success_millis = '13057210', total_fail_millis = '0', last_lock_time = '2018-11-24 15:03:55.458' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-11-24 23:17:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:24:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:03:55 Duration: 1ms 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 869,986 15s788ms 0ms 3ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 24 00 38,419 673ms 0ms 01 36,256 661ms 0ms 02 36,298 657ms 0ms 03 36,272 668ms 0ms 04 36,272 642ms 0ms 05 36,224 666ms 0ms 06 36,106 652ms 0ms 07 36,160 665ms 0ms 08 36,116 660ms 0ms 09 36,161 668ms 0ms 10 36,163 657ms 0ms 11 36,187 657ms 0ms 12 36,113 645ms 0ms 13 36,168 658ms 0ms 14 36,158 651ms 0ms 15 36,164 665ms 0ms 16 36,093 649ms 0ms 17 36,161 663ms 0ms 18 35,928 649ms 0ms 19 36,101 652ms 0ms 20 36,047 659ms 0ms 21 36,157 657ms 0ms 22 36,153 660ms 0ms 23 36,109 641ms 0ms [ User: symmetricds - Total duration: 15s750ms - Times executed: 868957 ]
[ User: pharmisight - Total duration: 38ms - Times executed: 1029 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s788ms - Times executed: 869986 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-11-24 13:09:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:59:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 20:59:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 385,259 5s1ms 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 24 00 17,814 224ms 0ms 01 16,073 205ms 0ms 02 16,090 205ms 0ms 03 16,079 208ms 0ms 04 16,080 205ms 0ms 05 16,059 209ms 0ms 06 15,954 208ms 0ms 07 15,985 210ms 0ms 08 15,946 209ms 0ms 09 15,967 206ms 0ms 10 15,963 214ms 0ms 11 15,993 212ms 0ms 12 15,943 205ms 0ms 13 15,965 205ms 0ms 14 15,957 206ms 0ms 15 15,965 210ms 0ms 16 15,925 206ms 0ms 17 15,953 205ms 0ms 18 15,877 203ms 0ms 19 15,930 206ms 0ms 20 15,897 210ms 0ms 21 15,956 209ms 0ms 22 15,956 205ms 0ms 23 15,932 205ms 0ms [ User: symmetricds - Total duration: 5s1ms - Times executed: 385259 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s1ms - Times executed: 385259 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-11-24 11:59:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:52:56 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:52:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 293,061 1s913ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 24 00 13,511 85ms 0ms 01 12,231 80ms 0ms 02 12,242 79ms 0ms 03 12,232 81ms 0ms 04 12,229 78ms 0ms 05 12,217 80ms 0ms 06 12,126 79ms 0ms 07 12,143 80ms 0ms 08 12,128 79ms 0ms 09 12,144 79ms 0ms 10 12,144 79ms 0ms 11 12,177 80ms 0ms 12 12,128 79ms 0ms 13 12,145 79ms 0ms 14 12,143 78ms 0ms 15 12,145 79ms 0ms 16 12,123 79ms 0ms 17 12,144 79ms 0ms 18 12,067 77ms 0ms 19 12,126 78ms 0ms 20 12,102 80ms 0ms 21 12,145 78ms 0ms 22 12,143 78ms 0ms 23 12,126 77ms 0ms [ User: symmetricds - Total duration: 1s911ms - Times executed: 292777 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 284 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s913ms - Times executed: 293061 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-11-24 20:20:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:31:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:36:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 293,060 7s536ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 24 00 13,511 600ms 0ms 01 12,230 352ms 0ms 02 12,242 323ms 0ms 03 12,233 330ms 0ms 04 12,229 326ms 0ms 05 12,217 331ms 0ms 06 12,125 302ms 0ms 07 12,144 289ms 0ms 08 12,128 293ms 0ms 09 12,144 295ms 0ms 10 12,144 293ms 0ms 11 12,177 295ms 0ms 12 12,128 286ms 0ms 13 12,144 289ms 0ms 14 12,144 299ms 0ms 15 12,144 298ms 0ms 16 12,124 289ms 0ms 17 12,144 285ms 0ms 18 12,067 297ms 0ms 19 12,126 301ms 0ms 20 12,102 281ms 0ms 21 12,144 283ms 0ms 22 12,144 283ms 0ms 23 12,125 303ms 0ms [ User: symmetricds - Total duration: 7s470ms - Times executed: 292777 ]
[ User: pharmisight - Total duration: 65ms - Times executed: 283 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s536ms - Times executed: 293060 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-11-24 01:40:35 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 08:35:42 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:38:32 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 77,237 3s485ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 24 00 3,204 144ms 0ms 01 3,213 147ms 0ms 02 3,222 145ms 0ms 03 3,222 143ms 0ms 04 3,222 145ms 0ms 05 3,213 147ms 0ms 06 3,213 142ms 0ms 07 3,222 145ms 0ms 08 3,213 146ms 0ms 09 3,222 147ms 0ms 10 3,222 143ms 0ms 11 3,222 142ms 0ms 12 3,213 144ms 0ms 13 3,222 147ms 0ms 14 3,222 144ms 0ms 15 3,222 143ms 0ms 16 3,213 145ms 0ms 17 3,222 146ms 0ms 18 3,222 145ms 0ms 19 3,212 142ms 0ms 20 3,222 145ms 0ms 21 3,222 147ms 0ms 22 3,222 147ms 0ms 23 3,213 142ms 0ms [ User: symmetricds - Total duration: 3s485ms - Times executed: 77237 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s485ms - Times executed: 77237 ]
-
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-11-24 00:09:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:24:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:06:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 68,663 1s529ms 0ms 1ms 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 Nov 24 00 2,849 66ms 0ms 01 2,858 67ms 0ms 02 2,864 66ms 0ms 03 2,867 67ms 0ms 04 2,865 65ms 0ms 05 2,857 66ms 0ms 06 2,856 65ms 0ms 07 2,864 67ms 0ms 08 2,856 64ms 0ms 09 2,864 63ms 0ms 10 2,864 63ms 0ms 11 2,864 62ms 0ms 12 2,856 61ms 0ms 13 2,864 62ms 0ms 14 2,864 62ms 0ms 15 2,864 62ms 0ms 16 2,855 62ms 0ms 17 2,864 61ms 0ms 18 2,864 62ms 0ms 19 2,856 62ms 0ms 20 2,864 62ms 0ms 21 2,864 62ms 0ms 22 2,864 62ms 0ms 23 2,856 61ms 0ms [ User: symmetricds - Total duration: 1s529ms - Times executed: 68663 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s529ms - Times executed: 68663 ]
-
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 '92509187' AND '142509186')) 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 '92509844' AND '142509843')) 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 '92509510' AND '142509509')) ORDER BY d.data_id ASC;
Date: 2018-11-24 01:40:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 03:40:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:40:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 57,600 1s259ms 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 Nov 24 00 2,440 49ms 0ms 01 2,400 52ms 0ms 02 2,400 51ms 0ms 03 2,400 54ms 0ms 04 2,400 51ms 0ms 05 2,400 52ms 0ms 06 2,400 54ms 0ms 07 2,400 55ms 0ms 08 2,400 49ms 0ms 09 2,400 53ms 0ms 10 2,400 52ms 0ms 11 2,400 51ms 0ms 12 2,400 51ms 0ms 13 2,400 52ms 0ms 14 2,400 53ms 0ms 15 2,400 51ms 0ms 16 2,400 55ms 0ms 17 2,400 52ms 0ms 18 2,360 52ms 0ms 19 2,400 52ms 0ms 20 2,400 52ms 0ms 21 2,400 52ms 0ms 22 2,400 53ms 0ms 23 2,400 51ms 0ms [ User: symmetricds - Total duration: 1s259ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s259ms - Times executed: 57600 ]
-
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 = 'pharmisight';
-
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-11-24 18:09:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:45:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 16:10:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 48,510 2s632ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 24 00 2,970 137ms 0ms 01 1,980 92ms 0ms 02 1,980 109ms 0ms 03 1,980 101ms 0ms 04 1,980 109ms 0ms 05 1,980 112ms 0ms 06 1,980 117ms 0ms 07 1,980 111ms 0ms 08 1,980 110ms 0ms 09 1,980 112ms 0ms 10 1,980 111ms 0ms 11 1,980 110ms 0ms 12 1,980 95ms 0ms 13 1,980 110ms 0ms 14 1,980 116ms 0ms 15 1,980 109ms 0ms 16 1,980 83ms 0ms 17 1,980 110ms 0ms 18 1,980 112ms 0ms 19 1,980 113ms 0ms 20 1,980 110ms 0ms 21 1,980 109ms 0ms 22 1,980 113ms 0ms 23 1,980 110ms 0ms [ User: pharmisight - Total duration: 2s632ms - Times executed: 48510 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s632ms - Times executed: 48510 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965578' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33016204' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3549' ORDER BY itemcodes0_.code ASC;
Date: 2018-11-24 12:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 43,071 2s377ms 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 24 00 2,637 125ms 0ms 01 1,758 83ms 0ms 02 1,758 100ms 0ms 03 1,758 92ms 0ms 04 1,758 98ms 0ms 05 1,758 100ms 0ms 06 1,758 104ms 0ms 07 1,758 100ms 0ms 08 1,758 99ms 0ms 09 1,758 101ms 0ms 10 1,758 100ms 0ms 11 1,758 100ms 0ms 12 1,758 87ms 0ms 13 1,758 100ms 0ms 14 1,758 104ms 0ms 15 1,758 99ms 0ms 16 1,758 75ms 0ms 17 1,758 100ms 0ms 18 1,758 101ms 0ms 19 1,758 101ms 0ms 20 1,758 99ms 0ms 21 1,758 99ms 0ms 22 1,758 101ms 0ms 23 1,758 99ms 0ms [ User: pharmisight - Total duration: 2s377ms - Times executed: 43071 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s377ms - Times executed: 43071 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '8' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3113' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074096' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-11-24 02:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 16,104 810ms 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security WHERE node_id = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 24 00 702 34ms 0ms 01 672 33ms 0ms 02 672 34ms 0ms 03 671 34ms 0ms 04 671 32ms 0ms 05 670 35ms 0ms 06 669 32ms 0ms 07 670 34ms 0ms 08 669 35ms 0ms 09 670 33ms 0ms 10 670 34ms 0ms 11 670 33ms 0ms 12 669 32ms 0ms 13 670 33ms 0ms 14 670 34ms 0ms 15 670 33ms 0ms 16 669 34ms 0ms 17 670 34ms 0ms 18 665 33ms 0ms 19 669 34ms 0ms 20 667 32ms 0ms 21 670 32ms 0ms 22 670 32ms 0ms 23 669 31ms 0ms [ User: symmetricds - Total duration: 810ms - Times executed: 16104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 810ms - Times executed: 16104 ]
-
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-11-24 08:21:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:16:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:43:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 11,521 746ms 0ms 5ms 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 #11
Day Hour Count Duration Avg duration Nov 24 00 489 31ms 0ms 01 480 31ms 0ms 02 480 38ms 0ms 03 480 31ms 0ms 04 480 30ms 0ms 05 480 31ms 0ms 06 480 29ms 0ms 07 480 30ms 0ms 08 480 29ms 0ms 09 480 32ms 0ms 10 480 33ms 0ms 11 480 31ms 0ms 12 480 28ms 0ms 13 480 29ms 0ms 14 480 29ms 0ms 15 480 31ms 0ms 16 480 30ms 0ms 17 480 34ms 0ms 18 472 31ms 0ms 19 480 29ms 0ms 20 480 30ms 0ms 21 480 30ms 0ms 22 480 29ms 0ms 23 480 28ms 0ms [ User: symmetricds - Total duration: 746ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 746ms - Times executed: 11521 ]
-
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-11-24 02:51:37 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:28:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:35:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,634 285ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 24 00 358 11ms 0ms 01 360 11ms 0ms 02 360 12ms 0ms 03 360 11ms 0ms 04 359 12ms 0ms 05 360 11ms 0ms 06 360 12ms 0ms 07 360 11ms 0ms 08 360 11ms 0ms 09 360 11ms 0ms 10 360 11ms 0ms 11 359 11ms 0ms 12 360 11ms 0ms 13 360 11ms 0ms 14 360 11ms 0ms 15 360 12ms 0ms 16 360 12ms 0ms 17 360 12ms 0ms 18 359 11ms 0ms 19 360 12ms 0ms 20 359 12ms 0ms 21 360 11ms 0ms 22 360 11ms 0ms 23 360 11ms 0ms [ User: symmetricds - Total duration: 285ms - Times executed: 8634 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 285ms - Times executed: 8634 ]
-
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-11-24 06:33:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:28:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:44:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,590 193ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '' AND data_id <= '' ORDER BY data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 24 00 357 8ms 0ms 01 359 8ms 0ms 02 358 8ms 0ms 03 361 9ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 357 8ms 0ms 07 358 8ms 0ms 08 357 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 357 7ms 0ms 13 358 8ms 0ms 14 358 7ms 0ms 15 358 7ms 0ms 16 357 7ms 0ms 17 358 7ms 0ms 18 358 7ms 0ms 19 357 7ms 0ms 20 358 7ms 0ms 21 358 7ms 0ms 22 358 7ms 0ms 23 357 7ms 0ms [ User: symmetricds - Total duration: 193ms - Times executed: 8590 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 193ms - Times executed: 8590 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '92509638' AND data_id <= '142509637' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '92509036' AND data_id <= '142509035' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '92509844' AND data_id <= '142509843' ORDER BY data_id ASC;
Date: 2018-11-24 03:20:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:20:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 03:40:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,582 472ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 24 00 356 21ms 0ms 01 357 21ms 0ms 02 358 21ms 0ms 03 358 20ms 0ms 04 358 19ms 0ms 05 357 20ms 0ms 06 357 19ms 0ms 07 358 19ms 0ms 08 357 19ms 0ms 09 358 19ms 0ms 10 358 19ms 0ms 11 358 19ms 0ms 12 357 19ms 0ms 13 358 19ms 0ms 14 358 19ms 0ms 15 358 19ms 0ms 16 357 19ms 0ms 17 358 18ms 0ms 18 358 19ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 19ms 0ms 22 358 19ms 0ms 23 357 19ms 0ms [ User: symmetricds - Total duration: 472ms - Times executed: 8582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 472ms - Times executed: 8582 ]
-
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-11-24 14:12:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 00:54:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 16:38:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 7,200 591ms 0ms 2ms 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 #15
Day Hour Count Duration Avg duration Nov 24 00 305 25ms 0ms 01 300 27ms 0ms 02 300 29ms 0ms 03 300 26ms 0ms 04 300 24ms 0ms 05 300 25ms 0ms 06 300 26ms 0ms 07 300 27ms 0ms 08 300 23ms 0ms 09 300 24ms 0ms 10 300 26ms 0ms 11 300 24ms 0ms 12 300 23ms 0ms 13 300 21ms 0ms 14 300 23ms 0ms 15 300 24ms 0ms 16 300 23ms 0ms 17 300 24ms 0ms 18 295 22ms 0ms 19 300 23ms 0ms 20 300 22ms 0ms 21 300 25ms 0ms 22 300 23ms 0ms 23 300 21ms 0ms [ User: symmetricds - Total duration: 591ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 591ms - Times executed: 7200 ]
-
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 = '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 = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-11-24 15:56:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:15:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:46:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,808 1s263ms 0ms 3ms 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 #16
Day Hour Count Duration Avg duration Nov 24 00 246 51ms 0ms 01 244 52ms 0ms 02 240 51ms 0ms 03 247 51ms 0ms 04 240 50ms 0ms 05 242 53ms 0ms 06 240 53ms 0ms 07 246 52ms 0ms 08 240 48ms 0ms 09 240 55ms 0ms 10 241 52ms 0ms 11 243 53ms 0ms 12 244 53ms 0ms 13 244 56ms 0ms 14 244 50ms 0ms 15 240 51ms 0ms 16 243 53ms 0ms 17 242 53ms 0ms 18 237 49ms 0ms 19 241 52ms 0ms 20 243 54ms 0ms 21 240 57ms 0ms 22 241 52ms 0ms 23 240 50ms 0ms [ User: symmetricds - Total duration: 1s263ms - Times executed: 5808 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s263ms - Times executed: 5808 ]
-
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 = '2' 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-11-24 09:30:47 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:04:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:42:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,785 219ms 0ms 4ms 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 #17
Day Hour Count Duration Avg duration Nov 24 00 269 9ms 0ms 01 240 8ms 0ms 02 240 9ms 0ms 03 240 9ms 0ms 04 240 8ms 0ms 05 240 8ms 0ms 06 240 9ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 9ms 0ms 10 240 8ms 0ms 11 240 12ms 0ms 12 240 8ms 0ms 13 240 9ms 0ms 14 240 10ms 0ms 15 240 8ms 0ms 16 240 8ms 0ms 17 240 9ms 0ms 18 236 8ms 0ms 19 240 9ms 0ms 20 240 9ms 0ms 21 240 9ms 0ms 22 240 8ms 0ms 23 240 8ms 0ms [ User: symmetricds - Total duration: 219ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 219ms - Times executed: 5785 ]
-
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-11-24 11:12:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:21:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 14:29:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,760 469ms 0ms 3ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 24 00 244 18ms 0ms 01 240 20ms 0ms 02 240 21ms 0ms 03 240 19ms 0ms 04 240 21ms 0ms 05 240 19ms 0ms 06 240 19ms 0ms 07 240 20ms 0ms 08 240 18ms 0ms 09 240 20ms 0ms 10 240 18ms 0ms 11 240 18ms 0ms 12 240 19ms 0ms 13 240 18ms 0ms 14 240 19ms 0ms 15 240 19ms 0ms 16 240 18ms 0ms 17 240 19ms 0ms 18 236 18ms 0ms 19 240 19ms 0ms 20 240 20ms 0ms 21 240 23ms 0ms 22 240 18ms 0ms 23 240 17ms 0ms [ User: symmetricds - Total duration: 469ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 469ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-11-24 04:25:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 21:14:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 07:09:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 5,760 927ms 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 #19
Day Hour Count Duration Avg duration Nov 24 00 244 38ms 0ms 01 240 39ms 0ms 02 240 38ms 0ms 03 240 36ms 0ms 04 240 35ms 0ms 05 240 41ms 0ms 06 240 37ms 0ms 07 240 41ms 0ms 08 240 35ms 0ms 09 240 42ms 0ms 10 240 42ms 0ms 11 240 41ms 0ms 12 240 36ms 0ms 13 240 39ms 0ms 14 240 36ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 39ms 0ms 18 236 37ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 40ms 0ms 22 240 38ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 927ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 927ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 09:04:46.628', last_lock_time = '2018-11-24 09:04:46.628' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 07:04:46.628');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 00:41:33.971', last_lock_time = '2018-11-24 00:41:33.971' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-23 22:41:33.971');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 18:30:00.523', last_lock_time = '2018-11-24 18:30:00.523' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 16:30:00.523');
Date: 2018-11-24 09:04:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 00:41:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:30:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 5,759 778ms 0ms 1ms 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 #20
Day Hour Count Duration Avg duration Nov 24 00 243 31ms 0ms 01 240 31ms 0ms 02 240 31ms 0ms 03 240 31ms 0ms 04 240 32ms 0ms 05 240 34ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 31ms 0ms 09 240 32ms 0ms 10 240 34ms 0ms 11 240 32ms 0ms 12 240 31ms 0ms 13 240 31ms 0ms 14 240 31ms 0ms 15 240 32ms 0ms 16 240 32ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 34ms 0ms 20 240 32ms 0ms 21 240 34ms 0ms 22 240 31ms 0ms 23 240 33ms 0ms [ User: symmetricds - Total duration: 778ms - Times executed: 5759 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 778ms - Times executed: 5759 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '70', success_count = '203510', fail_count = '0', total_success_count = '203510', total_fail_count = '0', total_success_millis = '13552128', total_fail_millis = '0', last_lock_time = '2018-11-24 23:17:07.199' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '80', success_count = '203311', fail_count = '0', total_success_count = '203311', total_fail_count = '0', total_success_millis = '13049800', total_fail_millis = '0', last_lock_time = '2018-11-24 10:24:48.377' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '66', success_count = '203404', fail_count = '0', total_success_count = '203404', total_fail_count = '0', total_success_millis = '13057210', total_fail_millis = '0', last_lock_time = '2018-11-24 15:03:55.458' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-11-24 23:17:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:24:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:03:55 Duration: 1ms 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 422ms 474ms 448ms 2 896ms SELECT _lines.routenumber, _lines.deliverydate, _lines.ordernumber, _lines.patientname, _lines.partdescription, _lines.orderqty, _lines.order_line_id, _checks.created AS check_created, _checks.newrxcheck AS check_checked, _checkers.firstname AS checker_firstname, _checkers.lastname AS checker_lastname, _audits.created AS audit_created, _audits.newrxcheck AS audit_checked, _auditors.firstname AS auditor_firstname, _auditors.lastname AS auditor_lastname, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '' AND '') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 24 11 2 896ms 448ms [ User: pharmisight - Total duration: 896ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 896ms - Times executed: 2 ]
-
SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-10-31 23:00:00' AND '2018-11-29 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;
-
SELECT _lines.routeNumber, _lines.deliveryDate, _lines.orderNumber, _lines.patientName, _lines.partDescription, _lines.orderQty, _lines.order_line_id, _checks.created AS check_created, _checks.newRxCheck AS check_checked, _checkers.firstName AS checker_firstName, _checkers.lastName AS checker_lastName, _audits.created AS audit_created, _audits.newRxCheck AS audit_checked, _auditors.firstName AS auditor_firstName, _auditors.lastName AS auditor_lastName, _audits.rx_line_activity_id, _checks.auditedbyrxlineactivity, _checks.auditedaserror FROM rx_line_activities AS _audits INNER JOIN rx_line_activities AS _checks ON (_audits.rx_line_activity_id = _checks.auditedbyrxlineactivity) LEFT OUTER JOIN order_lines AS _lines ON (_audits.order_line_id = _lines.order_line_id) LEFT OUTER JOIN users AS _auditors ON (_audits.newrxcheckby = _auditors.user_id) LEFT OUTER JOIN users AS _checkers ON (_checks.newrxcheckby = _checkers.user_id) WHERE (_checks.created BETWEEN '2018-09-30 23:00:00' AND '2018-10-30 23:00:00') AND _checks.auditedaserror IS TRUE ORDER BY _checks.created DESC;
Date: 2018-11-24 11:43:59 Duration: 474ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:43:15 Duration: 422ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 113ms 17ms 159 2s854ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 24 00 14 105ms 7ms 01 14 185ms 13ms 02 14 146ms 10ms 03 14 94ms 6ms 04 14 105ms 7ms 05 14 90ms 6ms 06 14 87ms 6ms 07 14 277ms 19ms 08 9 318ms 35ms 09 7 312ms 44ms 10 6 239ms 39ms 11 5 180ms 36ms 12 4 144ms 36ms 13 3 146ms 48ms 14 3 96ms 32ms 15 2 86ms 43ms 16 1 38ms 38ms 17 1 33ms 33ms 18 1 26ms 26ms 19 1 19ms 19ms 20 1 23ms 23ms 21 1 20ms 20ms 22 1 24ms 24ms 23 1 49ms 49ms [ User: symmetricds - Total duration: 2s854ms - Times executed: 159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s854ms - Times executed: 159 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '92441543' AND '92446543' AND create_time < '2018-11-23 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92441543' AND '92446543' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '92483346' AND '92488346' AND create_time < '2018-11-23 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92483346' AND '92488346' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '92496289' AND '92501289' AND create_time < '2018-11-23 13:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '92496289' AND '92501289' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-11-24 01:00:00 Duration: 113ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 1ms 12ms 12ms 288 3s466ms 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 #3
Day Hour Count Duration Avg duration Nov 24 00 12 145ms 12ms 01 12 144ms 12ms 02 12 145ms 12ms 03 12 145ms 12ms 04 12 144ms 12ms 05 12 146ms 12ms 06 12 144ms 12ms 07 12 144ms 12ms 08 12 144ms 12ms 09 12 145ms 12ms 10 12 144ms 12ms 11 12 144ms 12ms 12 12 144ms 12ms 13 12 146ms 12ms 14 12 145ms 12ms 15 12 145ms 12ms 16 12 125ms 10ms 17 12 145ms 12ms 18 12 146ms 12ms 19 12 144ms 12ms 20 12 146ms 12ms 21 12 144ms 12ms 22 12 144ms 12ms 23 12 146ms 12ms [ User: tony - Total duration: 3s466ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s466ms - 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-11-24 16:41:32 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 15:56:21 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 22:01:23 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
4 0ms 10ms 5ms 189 1s64ms 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 #4
Day Hour Count Duration Avg duration Nov 24 00 8 52ms 6ms 01 8 47ms 5ms 02 8 51ms 6ms 03 8 52ms 6ms 04 8 44ms 5ms 05 8 44ms 5ms 06 8 42ms 5ms 07 8 48ms 6ms 08 8 49ms 6ms 09 8 38ms 4ms 10 8 46ms 5ms 11 8 49ms 6ms 12 8 39ms 4ms 13 8 40ms 5ms 14 8 59ms 7ms 15 8 33ms 4ms 16 8 30ms 3ms 17 8 30ms 3ms 18 8 47ms 5ms 19 8 55ms 6ms 20 5 33ms 6ms 21 8 44ms 5ms 22 8 28ms 3ms 23 8 53ms 6ms [ User: symmetricds - Total duration: 1s64ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s64ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '100765880', "total_memory_bytes" = '532676608', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 00:22:12', "last_restart_time" = '2018-11-20 12:12:12', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '159775544', "total_memory_bytes" = '523763712', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 23:34:44', "last_restart_time" = '2018-11-20 13:49:33.42', "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" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '177181992', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-11-24 15:34:44', "last_restart_time" = '2018-11-20 13:49:33.42', "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-11-24 00:24:07 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 23:35:41 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:35:08 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3ms 9ms 5ms 269 1s442ms 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 #5
Day Hour Count Duration Avg duration Nov 24 00 214 1s81ms 5ms 01 4 22ms 5ms 02 4 30ms 7ms 03 3 17ms 5ms 04 3 18ms 6ms 05 4 30ms 7ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 3 25ms 8ms 12 2 8ms 4ms 13 2 13ms 6ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 14ms 7ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 1s238ms - Times executed: 224 ]
[ User: pharmisight - Total duration: 204ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s442ms - Times executed: 269 ]
-
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 = 'item_codes' 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 = 'item_codes' 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 = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-11-24 19:15:23 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:15:23 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 09:15:43 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1ms 3ms 2ms 288 782ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 24 00 12 31ms 2ms 01 12 32ms 2ms 02 12 32ms 2ms 03 12 33ms 2ms 04 12 31ms 2ms 05 12 33ms 2ms 06 12 32ms 2ms 07 12 32ms 2ms 08 12 31ms 2ms 09 12 31ms 2ms 10 12 32ms 2ms 11 12 32ms 2ms 12 12 31ms 2ms 13 12 34ms 2ms 14 12 33ms 2ms 15 12 32ms 2ms 16 12 33ms 2ms 17 12 32ms 2ms 18 12 33ms 2ms 19 12 32ms 2ms 20 12 32ms 2ms 21 12 32ms 2ms 22 12 32ms 2ms 23 12 32ms 2ms [ User: tony - Total duration: 782ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 782ms - 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-11-24 13:36:20 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 23:36:21 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-11-24 18:11:21 Duration: 3ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
7 0ms 9ms 0ms 1,720 857ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 24 00 246 140ms 0ms 01 343 146ms 0ms 02 269 113ms 0ms 03 388 191ms 0ms 04 263 144ms 0ms 05 211 120ms 0ms [ User: pharmisight - Total duration: 857ms - Times executed: 1720 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 857ms - Times executed: 1720 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004812540', '2018-11-24 01:22:48', 'SZKLARCZYKB', '2018-11-24 01:40:00.043', '86738', '5', '150505230129209042');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004812686', '2018-11-24 01:17:01', 'NYERSAHW', '2018-11-24 01:40:00.043', '79771', '360', '150505230129208236');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004816638', '2018-11-24 03:32:51', 'RYBAKJ', '2018-11-24 04:00:01.396', '71951', '5', '150505230129219294');
Date: 2018-11-24 01:40:00 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:40:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 04:00:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 0ms 5,808 1s263ms 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 #8
Day Hour Count Duration Avg duration Nov 24 00 246 51ms 0ms 01 244 52ms 0ms 02 240 51ms 0ms 03 247 51ms 0ms 04 240 50ms 0ms 05 242 53ms 0ms 06 240 53ms 0ms 07 246 52ms 0ms 08 240 48ms 0ms 09 240 55ms 0ms 10 241 52ms 0ms 11 243 53ms 0ms 12 244 53ms 0ms 13 244 56ms 0ms 14 244 50ms 0ms 15 240 51ms 0ms 16 243 53ms 0ms 17 242 53ms 0ms 18 237 49ms 0ms 19 241 52ms 0ms 20 243 54ms 0ms 21 240 57ms 0ms 22 241 52ms 0ms 23 240 50ms 0ms [ User: symmetricds - Total duration: 1s263ms - Times executed: 5808 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s263ms - Times executed: 5808 ]
-
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 = '2' 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-11-24 09:30:47 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:04:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:42:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 3ms 0ms 5,760 927ms 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 #9
Day Hour Count Duration Avg duration Nov 24 00 244 38ms 0ms 01 240 39ms 0ms 02 240 38ms 0ms 03 240 36ms 0ms 04 240 35ms 0ms 05 240 41ms 0ms 06 240 37ms 0ms 07 240 41ms 0ms 08 240 35ms 0ms 09 240 42ms 0ms 10 240 42ms 0ms 11 240 41ms 0ms 12 240 36ms 0ms 13 240 39ms 0ms 14 240 36ms 0ms 15 240 38ms 0ms 16 240 38ms 0ms 17 240 39ms 0ms 18 236 37ms 0ms 19 240 37ms 0ms 20 240 36ms 0ms 21 240 40ms 0ms 22 240 38ms 0ms 23 240 38ms 0ms [ User: symmetricds - Total duration: 927ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 927ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 09:04:46.628', last_lock_time = '2018-11-24 09:04:46.628' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 07:04:46.628');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 00:41:33.971', last_lock_time = '2018-11-24 00:41:33.971' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-23 22:41:33.971');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-11-24 18:30:00.523', last_lock_time = '2018-11-24 18:30:00.523' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-11-24 16:30:00.523');
Date: 2018-11-24 09:04:46 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 00:41:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:30:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 1ms 0ms 5,759 778ms 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 #10
Day Hour Count Duration Avg duration Nov 24 00 243 31ms 0ms 01 240 31ms 0ms 02 240 31ms 0ms 03 240 31ms 0ms 04 240 32ms 0ms 05 240 34ms 0ms 06 240 32ms 0ms 07 240 32ms 0ms 08 240 31ms 0ms 09 240 32ms 0ms 10 240 34ms 0ms 11 240 32ms 0ms 12 240 31ms 0ms 13 240 31ms 0ms 14 240 31ms 0ms 15 240 32ms 0ms 16 240 32ms 0ms 17 240 32ms 0ms 18 236 32ms 0ms 19 240 34ms 0ms 20 240 32ms 0ms 21 240 34ms 0ms 22 240 31ms 0ms 23 240 33ms 0ms [ User: symmetricds - Total duration: 778ms - Times executed: 5759 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 778ms - Times executed: 5759 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '70', success_count = '203510', fail_count = '0', total_success_count = '203510', total_fail_count = '0', total_success_millis = '13552128', total_fail_millis = '0', last_lock_time = '2018-11-24 23:17:07.199' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '80', success_count = '203311', fail_count = '0', total_success_count = '203311', total_fail_count = '0', total_success_millis = '13049800', total_fail_millis = '0', last_lock_time = '2018-11-24 10:24:48.377' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '66', success_count = '203404', fail_count = '0', total_success_count = '203404', total_fail_count = '0', total_success_millis = '13057210', total_fail_millis = '0', last_lock_time = '2018-11-24 15:03:55.458' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-11-24 23:17:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:24:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 15:03:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 2ms 0ms 7,200 591ms 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 #11
Day Hour Count Duration Avg duration Nov 24 00 305 25ms 0ms 01 300 27ms 0ms 02 300 29ms 0ms 03 300 26ms 0ms 04 300 24ms 0ms 05 300 25ms 0ms 06 300 26ms 0ms 07 300 27ms 0ms 08 300 23ms 0ms 09 300 24ms 0ms 10 300 26ms 0ms 11 300 24ms 0ms 12 300 23ms 0ms 13 300 21ms 0ms 14 300 23ms 0ms 15 300 24ms 0ms 16 300 23ms 0ms 17 300 24ms 0ms 18 295 22ms 0ms 19 300 23ms 0ms 20 300 22ms 0ms 21 300 25ms 0ms 22 300 23ms 0ms 23 300 21ms 0ms [ User: symmetricds - Total duration: 591ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 591ms - Times executed: 7200 ]
-
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 = '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 = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-11-24 15:56:56 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:15:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:46:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 3ms 0ms 5,760 469ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 24 00 244 18ms 0ms 01 240 20ms 0ms 02 240 21ms 0ms 03 240 19ms 0ms 04 240 21ms 0ms 05 240 19ms 0ms 06 240 19ms 0ms 07 240 20ms 0ms 08 240 18ms 0ms 09 240 20ms 0ms 10 240 18ms 0ms 11 240 18ms 0ms 12 240 19ms 0ms 13 240 18ms 0ms 14 240 19ms 0ms 15 240 19ms 0ms 16 240 18ms 0ms 17 240 19ms 0ms 18 236 18ms 0ms 19 240 19ms 0ms 20 240 20ms 0ms 21 240 23ms 0ms 22 240 18ms 0ms 23 240 17ms 0ms [ User: symmetricds - Total duration: 469ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 469ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-11-24 04:25:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 21:14:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 07:09:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 5ms 0ms 11,521 746ms 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 #13
Day Hour Count Duration Avg duration Nov 24 00 489 31ms 0ms 01 480 31ms 0ms 02 480 38ms 0ms 03 480 31ms 0ms 04 480 30ms 0ms 05 480 31ms 0ms 06 480 29ms 0ms 07 480 30ms 0ms 08 480 29ms 0ms 09 480 32ms 0ms 10 480 33ms 0ms 11 480 31ms 0ms 12 480 28ms 0ms 13 480 29ms 0ms 14 480 29ms 0ms 15 480 31ms 0ms 16 480 30ms 0ms 17 480 34ms 0ms 18 472 31ms 0ms 19 480 29ms 0ms 20 480 30ms 0ms 21 480 30ms 0ms 22 480 29ms 0ms 23 480 28ms 0ms [ User: symmetricds - Total duration: 746ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 746ms - Times executed: 11521 ]
-
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-11-24 02:51:37 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:28:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:35:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 43,071 2s377ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 24 00 2,637 125ms 0ms 01 1,758 83ms 0ms 02 1,758 100ms 0ms 03 1,758 92ms 0ms 04 1,758 98ms 0ms 05 1,758 100ms 0ms 06 1,758 104ms 0ms 07 1,758 100ms 0ms 08 1,758 99ms 0ms 09 1,758 101ms 0ms 10 1,758 100ms 0ms 11 1,758 100ms 0ms 12 1,758 87ms 0ms 13 1,758 100ms 0ms 14 1,758 104ms 0ms 15 1,758 99ms 0ms 16 1,758 75ms 0ms 17 1,758 100ms 0ms 18 1,758 101ms 0ms 19 1,758 101ms 0ms 20 1,758 99ms 0ms 21 1,758 99ms 0ms 22 1,758 101ms 0ms 23 1,758 99ms 0ms [ User: pharmisight - Total duration: 2s377ms - Times executed: 43071 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s377ms - Times executed: 43071 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '8' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3113' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074096' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-11-24 02:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 18:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 8,582 472ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 24 00 356 21ms 0ms 01 357 21ms 0ms 02 358 21ms 0ms 03 358 20ms 0ms 04 358 19ms 0ms 05 357 20ms 0ms 06 357 19ms 0ms 07 358 19ms 0ms 08 357 19ms 0ms 09 358 19ms 0ms 10 358 19ms 0ms 11 358 19ms 0ms 12 357 19ms 0ms 13 358 19ms 0ms 14 358 19ms 0ms 15 358 19ms 0ms 16 357 19ms 0ms 17 358 18ms 0ms 18 358 19ms 0ms 19 357 19ms 0ms 20 358 19ms 0ms 21 358 19ms 0ms 22 358 19ms 0ms 23 357 19ms 0ms [ User: symmetricds - Total duration: 472ms - Times executed: 8582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 472ms - Times executed: 8582 ]
-
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-11-24 14:12:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 00:54:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 16:38:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 48,510 2s632ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 24 00 2,970 137ms 0ms 01 1,980 92ms 0ms 02 1,980 109ms 0ms 03 1,980 101ms 0ms 04 1,980 109ms 0ms 05 1,980 112ms 0ms 06 1,980 117ms 0ms 07 1,980 111ms 0ms 08 1,980 110ms 0ms 09 1,980 112ms 0ms 10 1,980 111ms 0ms 11 1,980 110ms 0ms 12 1,980 95ms 0ms 13 1,980 110ms 0ms 14 1,980 116ms 0ms 15 1,980 109ms 0ms 16 1,980 83ms 0ms 17 1,980 110ms 0ms 18 1,980 112ms 0ms 19 1,980 113ms 0ms 20 1,980 110ms 0ms 21 1,980 109ms 0ms 22 1,980 113ms 0ms 23 1,980 110ms 0ms [ User: pharmisight - Total duration: 2s632ms - Times executed: 48510 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s632ms - Times executed: 48510 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965578' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '33016204' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3549' ORDER BY itemcodes0_.code ASC;
Date: 2018-11-24 12:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 10:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 16,104 810ms 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 Nov 24 00 702 34ms 0ms 01 672 33ms 0ms 02 672 34ms 0ms 03 671 34ms 0ms 04 671 32ms 0ms 05 670 35ms 0ms 06 669 32ms 0ms 07 670 34ms 0ms 08 669 35ms 0ms 09 670 33ms 0ms 10 670 34ms 0ms 11 670 33ms 0ms 12 669 32ms 0ms 13 670 33ms 0ms 14 670 34ms 0ms 15 670 33ms 0ms 16 669 34ms 0ms 17 670 34ms 0ms 18 665 33ms 0ms 19 669 34ms 0ms 20 667 32ms 0ms 21 670 32ms 0ms 22 670 32ms 0ms 23 669 31ms 0ms [ User: symmetricds - Total duration: 810ms - Times executed: 16104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 810ms - Times executed: 16104 ]
-
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-11-24 08:21:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:16:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:43:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 77,237 3s485ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 24 00 3,204 144ms 0ms 01 3,213 147ms 0ms 02 3,222 145ms 0ms 03 3,222 143ms 0ms 04 3,222 145ms 0ms 05 3,213 147ms 0ms 06 3,213 142ms 0ms 07 3,222 145ms 0ms 08 3,213 146ms 0ms 09 3,222 147ms 0ms 10 3,222 143ms 0ms 11 3,222 142ms 0ms 12 3,213 144ms 0ms 13 3,222 147ms 0ms 14 3,222 144ms 0ms 15 3,222 143ms 0ms 16 3,213 145ms 0ms 17 3,222 146ms 0ms 18 3,222 145ms 0ms 19 3,212 142ms 0ms 20 3,222 145ms 0ms 21 3,222 147ms 0ms 22 3,222 147ms 0ms 23 3,213 142ms 0ms [ User: symmetricds - Total duration: 3s485ms - Times executed: 77237 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s485ms - Times executed: 77237 ]
-
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-11-24 00:09:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 01:24:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 11:06:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 4ms 0ms 5,785 219ms 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 #19
Day Hour Count Duration Avg duration Nov 24 00 269 9ms 0ms 01 240 8ms 0ms 02 240 9ms 0ms 03 240 9ms 0ms 04 240 8ms 0ms 05 240 8ms 0ms 06 240 9ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 9ms 0ms 10 240 8ms 0ms 11 240 12ms 0ms 12 240 8ms 0ms 13 240 9ms 0ms 14 240 10ms 0ms 15 240 8ms 0ms 16 240 8ms 0ms 17 240 9ms 0ms 18 236 8ms 0ms 19 240 9ms 0ms 20 240 9ms 0ms 21 240 9ms 0ms 22 240 8ms 0ms 23 240 8ms 0ms [ User: symmetricds - Total duration: 219ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 219ms - Times executed: 5785 ]
-
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-11-24 11:12:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 13:21:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 14:29:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,634 285ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 24 00 358 11ms 0ms 01 360 11ms 0ms 02 360 12ms 0ms 03 360 11ms 0ms 04 359 12ms 0ms 05 360 11ms 0ms 06 360 12ms 0ms 07 360 11ms 0ms 08 360 11ms 0ms 09 360 11ms 0ms 10 360 11ms 0ms 11 359 11ms 0ms 12 360 11ms 0ms 13 360 11ms 0ms 14 360 11ms 0ms 15 360 12ms 0ms 16 360 12ms 0ms 17 360 12ms 0ms 18 359 11ms 0ms 19 360 12ms 0ms 20 359 12ms 0ms 21 360 11ms 0ms 22 360 11ms 0ms 23 360 11ms 0ms [ User: symmetricds - Total duration: 285ms - Times executed: 8634 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 285ms - Times executed: 8634 ]
-
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-11-24 06:33:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 02:28:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-11-24 19:44:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,679,032 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 Nov 24 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-11-24 00:00:20 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: