pgBadger-
Global information
- Generated on Tue Apr 24 00:00:44 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 2,217,924 log entries in 42s
- Log start from 2018-04-23 16:21:33 to 2018-04-23 23:59:59
-
Overview
Global Stats
- 340 Number of unique normalized queries
- 748,061 Number of queries
- 5m57s Total query duration
- 2018-04-23 16:21:33 First query
- 2018-04-23 23:59:59 Last query
- 2,021 queries/s at 2018-04-23 16:22:09 Query peak
- 2 Number of events
- 2 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 83 Total number of automatic vacuums
- 92 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 645 Total number of sessions
- 2 sessions at 2018-04-23 19:12:02 Session peak
- 3d4h8m20s Total duration of sessions
- 7m4s Average duration of sessions
- 1,159 Average queries per session
- 554ms Average queries duration per session
- 655 Total number of connections
- 5 connections/s at 2018-04-23 16:22:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2,021 queries/s Query Peak
- 2018-04-23 16:22:09 Date
SELECT Traffic
Key values
- 1,910 queries/s Query Peak
- 2018-04-23 17:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 530 queries/s Query Peak
- 2018-04-23 23:20:05 Date
Queries duration
Key values
- 5m57s Total query duration
Prepared queries ratio
Key values
- 1.73 Ratio of bind vs prepare
- 159.72 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 23 16 76,578 0ms 322ms 0ms 403ms 1s374ms 1s384ms 17 98,192 0ms 408ms 0ms 287ms 1s52ms 4s703ms 18 94,771 0ms 87ms 0ms 58ms 63ms 416ms 19 94,259 0ms 69ms 0ms 63ms 192ms 910ms 20 95,002 0ms 419ms 3ms 10s600ms 59s657ms 59s831ms 21 94,476 0ms 85ms 0ms 54ms 96ms 487ms 22 97,266 0ms 71ms 0ms 59ms 212ms 478ms 23 97,517 0ms 71ms 0ms 60ms 346ms 440ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 23 16 29,695 0 0ms 106ms 272ms 1s222ms 17 34,908 0 0ms 33ms 156ms 2s50ms 18 32,837 0 0ms 24ms 28ms 154ms 19 32,653 0 0ms 22ms 28ms 156ms 20 34,377 0 9ms 29ms 10s582ms 59s678ms 21 32,675 0 0ms 22ms 26ms 155ms 22 33,249 0 0ms 23ms 29ms 170ms 23 33,232 0 0ms 21ms 25ms 149ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 23 16 1,400 1,386 93 0 0ms 46ms 73ms 144ms 17 443 861 119 0 0ms 7ms 13ms 88ms 18 110 626 105 0 0ms 2ms 7ms 11ms 19 127 641 107 0 0ms 2ms 7ms 10ms 20 296 722 117 0 0ms 3ms 7ms 18ms 21 155 638 110 0 0ms 1ms 8ms 9ms 22 1,811 1,066 108 0 0ms 2ms 8ms 99ms 23 2,176 1,145 112 0 0ms 1ms 9ms 179ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 23 16 43,069 76,575 1.78 83.79% 17 57,611 98,176 1.70 93.73% 18 55,820 94,771 1.70 95.88% 19 55,043 94,259 1.71 95.04% 20 54,611 95,002 1.74 91.93% 21 54,998 94,476 1.72 94.75% 22 56,219 97,266 1.73 92.51% 23 56,272 97,517 1.73 92.08% Day Hour Count Average / Second Apr 23 16 75 0.02/s 17 98 0.03/s 18 93 0.03/s 19 76 0.02/s 20 80 0.02/s 21 74 0.02/s 22 79 0.02/s 23 80 0.02/s Day Hour Count Average Duration Apr 23 16 64 5m27s 17 99 6m 18 93 6m30s 19 76 7m44s 20 80 7m29s 21 74 8m6s 22 79 7m39s 23 80 7m47s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2018-04-23 16:22:01 Date
Connections per database
Key values
- pharmisight Main Database
- 655 connections Total
Connections per user
Key values
- pharmisight Main User
- 655 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2018-04-23 19:12:02 Date
Histogram of session times
Key values
- 575 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 645 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 645 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 645 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 337 buffers Checkpoint Peak
- 2018-04-23 16:42:06 Date
- 33.817 seconds Highest write time
- 0.016 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-04-23 21:26:47 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 Apr 23 16 1,298 129.952s 0.01s 129.989s 17 883 88.597s 0.012s 88.651s 18 559 56.08s 0.021s 56.144s 19 605 60.69s 0.026s 60.756s 20 587 58.892s 0.019s 58.955s 21 574 57.588s 0.039s 57.667s 22 812 81.465s 0.012s 81.513s 23 917 91.921s 0.026s 92.004s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 23 16 0 0 1 523 0.001s 0s 17 0 0 0 474 0.002s 0s 18 0 0 0 279 0.008s 0s 19 0 0 0 287 0.008s 0s 20 0 0 0 320 0.008s 0s 21 0 0 1 301 0.015s 0.001s 22 0 0 0 309 0.002s 0s 23 0 0 0 327 0.008s 0s Day Hour Count Avg time (sec) Apr 23 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Apr 23 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 Apr 23 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
- 1.08 sec Highest CPU-cost vacuum
Table public.sym_outgoing_batch
Database pharmisight - 2018-04-23 16:37:05 Date
- 0.39 sec Highest CPU-cost analyze
Table public.sym_outgoing_batch
Database pharmisight - 2018-04-23 16:32:04 Date
Analyzes per table
Key values
- public.sym_node_communication (66) Main table analyzed (database pharmisight)
- 92 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 66 pharmisight.public.sym_data_gap 6 pharmisight.public.sym_sequence 5 pharmisight.public.sym_lock 4 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.sym_incoming_batch 3 pharmisight.public.sym_outgoing_batch 2 pharmisight.public.sym_node_host 2 pharmisight.public.item_codes 1 Total 92 Vacuums per table
Key values
- public.sym_node_communication (64) Main table vacuumed on database pharmisight
- 83 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 64 0 pharmisight.public.sym_sequence 5 0 pharmisight.public.sym_lock 3 0 pharmisight.public.sym_data_gap 3 3 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.public.sym_node_host 2 0 pharmisight.public.sym_incoming_batch 2 2 pharmisight.public.sym_outgoing_batch 1 1 pharmisight.pg_catalog.pg_statistic 1 1 Total 83 7 Tuples removed per table
Key values
- public.sym_node_communication (3590) Main table with removed tuples on database pharmisight
- 5074 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_node_communication 64 0 3590 0 pharmisight.pg_catalog.pg_statistic 1 1 282 0 pharmisight.public.sym_incoming_batch 2 2 273 0 pharmisight.public.sym_sequence 5 0 256 0 pharmisight.public.sym_lock 3 0 156 0 pharmisight.public.sym_data_gap 3 3 153 0 pharmisight.public.sym_outgoing_batch 1 1 152 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 pharmisight.public.sym_node_host 2 0 105 0 Total 83 7 5,074 0 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_node_communication 64 0 3590 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 pharmisight.public.sym_outgoing_batch 1 1 152 0 pharmisight.public.sym_node_host 2 0 105 0 pharmisight.public.sym_lock 3 0 156 0 pharmisight.pg_catalog.pg_statistic 1 1 282 0 pharmisight.public.sym_data_gap 3 3 153 0 pharmisight.public.sym_sequence 5 0 256 0 pharmisight.public.sym_incoming_batch 2 2 273 0 Total 83 7 5,074 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 23 16 13 12 17 10 13 18 10 11 19 9 14 20 10 8 21 12 11 22 10 12 23 9 11 - 1.08 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
- 263,626 Total read queries
- 204,706 Total write queries
Queries by database
Key values
- pharmisight Main database
- 748,058 Requests
- 5m57s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 704,999 Requests
User Request type Count Duration pharmisight Total 43,059 5m36s DELETE 7 0ms INSERT 1,273 1s79ms OTHERS 1,061 33ms SELECT 39,234 5m33s TCL 1,036 154ms UPDATE 448 1s621ms postgres Total 3 6ms SELECT 3 6ms symmetricds Total 704,999 21s542ms DDL 1 1ms DELETE 864 1s561ms INSERT 5,245 562ms OTHERS 278,668 4s967ms SELECT 224,389 9s398ms TCL 189,195 3s399ms UPDATE 6,637 1s651ms Duration by user
Key values
- 5m36s (pharmisight) Main time consuming user
User Request type Count Duration pharmisight Total 43,059 5m36s DELETE 7 0ms INSERT 1,273 1s79ms OTHERS 1,061 33ms SELECT 39,234 5m33s TCL 1,036 154ms UPDATE 448 1s621ms postgres Total 3 6ms SELECT 3 6ms symmetricds Total 704,999 21s542ms DDL 1 1ms DELETE 864 1s561ms INSERT 5,245 562ms OTHERS 278,668 4s967ms SELECT 224,389 9s398ms TCL 189,195 3s399ms UPDATE 6,637 1s651ms Queries by host
Key values
- 10.10.10.1 Main host
- 748,058 Requests
- 5m57s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 747,391 Requests
- 5m57s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-04-23 21:07:23 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 743,451 0-1ms duration
Slowest individual queries
Rank Duration Query 1 419ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264762' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:03:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 408ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:46 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 399ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:51 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 398ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264832' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 397ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 396ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264832' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:57 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 387ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213229662' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:04:08 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 378ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213244852' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:03:50 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 369ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213231362' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:04:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 366ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213231462' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:04:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 349ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264832' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 17:03:53 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 340ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213232632' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:07:11 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 339ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213233222' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:07:10 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 339ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213229602' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:04:12 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 337ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213241552' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:06:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 337ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213233672' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:08:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 337ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213241662' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:06:02 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 332ms SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264832' ORDER BY orderlinep0_.prescriptionId ASC;[ Date: 2018-04-23 17:04:36 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 331ms SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264812' ORDER BY orderlinep0_.prescriptionId ASC;[ Date: 2018-04-23 17:03:46 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 331ms SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213229302' ORDER BY rxlineacti0_.CREATED ASC;[ Date: 2018-04-23 20:04:13 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5m21s 1,906 160ms 419ms 168ms SELECT rxlineacti0_.order_line_id AS order_l10_22_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_1_, rxlineacti0_.created AS created2_35_1_, rxlineacti0_.newrxstatus AS newrxsta3_35_1_, rxlineacti0_.newrxcheckby AS newrxche4_35_1_, rxlineacti0_.newrxcheck AS newrxche5_35_1_, rxlineacti0_.rxerror AS rxerror6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedbyrxlineactivity AS auditedb8_35_1_, rxlineacti0_.auditedaserror AS auditeda9_35_1_ FROM rx_line_activities rxlineacti0_ WHERE rxlineacti0_.order_line_id = '' ORDER BY rxlineacti0_.created ASC;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 23 17 7 2s668ms 381ms 20 1,899 5m18s 167ms [ User: pharmisight - Total duration: 5m21s - Times executed: 1906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m21s - Times executed: 1906 ]
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264762' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
Date: 2018-04-23 20:03:50 Duration: 419ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:46 Duration: 408ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:51 Duration: 399ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4s963ms 278,426 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 23 16 25,033 431ms 0ms 17 36,532 634ms 0ms 18 36,367 656ms 0ms 19 36,191 673ms 0ms 20 35,435 608ms 0ms 21 36,283 640ms 0ms 22 36,340 671ms 0ms 23 36,245 647ms 0ms [ User: symmetricds - Total duration: 4s949ms - Times executed: 278072 ]
[ User: pharmisight - Total duration: 13ms - Times executed: 354 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s963ms - Times executed: 278425 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-04-23 22:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:21:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:17:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3s488ms 11 291ms 332ms 317ms SELECT orderlinep0_.order_line_id AS order_l10_22_0_, orderlinep0_.order_line_prescription_id AS order_li1_25_0_, orderlinep0_.order_line_prescription_id AS order_li1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionid AS prescrip3_25_1_, orderlinep0_.plonkernumber AS plonkern4_25_1_, orderlinep0_.plonkerdate AS plonkerd5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imagelink AS imagelin7_25_1_, orderlinep0_.imagelinkoriginal AS imagelin8_25_1_, orderlinep0_.epscheck AS epscheck9_25_1_ FROM order_line_prescriptions orderlinep0_ WHERE orderlinep0_.order_line_id = '' ORDER BY orderlinep0_.prescriptionid ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 23 16 3 922ms 307ms 17 8 2s566ms 320ms [ User: pharmisight - Total duration: 3s488ms - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s488ms - Times executed: 11 ]
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264832' ORDER BY orderlinep0_.prescriptionId ASC;
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264812' ORDER BY orderlinep0_.prescriptionId ASC;
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264812' ORDER BY orderlinep0_.prescriptionId ASC;
Date: 2018-04-23 17:04:36 Duration: 332ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:46 Duration: 331ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:59:10 Duration: 322ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s947ms 95,111 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 23 16 9,412 632ms 0ms 17 12,564 410ms 0ms 18 12,270 308ms 0ms 19 12,194 308ms 0ms 20 11,947 294ms 0ms 21 12,234 328ms 0ms 22 12,267 334ms 0ms 23 12,223 328ms 0ms [ User: symmetricds - Total duration: 2s797ms - Times executed: 94597 ]
[ User: pharmisight - Total duration: 149ms - Times executed: 514 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s947ms - Times executed: 95111 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-04-23 21:52:21 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:13:17 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:31:16 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 2s233ms 122 15ms 27ms 18ms SELECT orderround0_.order_round_id AS order_ro6_26_0_, orderround0_.order_round_picker_id AS order_ro1_29_0_, orderround0_.order_round_picker_id AS order_ro1_29_1_, orderround0_.pickerid AS pickerid2_29_1_, orderround0_.pickedorderlinescount AS pickedor3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errornote AS errornot5_29_1_ FROM order_round_pickers orderround0_ WHERE orderround0_.order_round_id = '' ORDER BY orderround0_.pickerid ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 23 16 24 460ms 19ms 17 47 901ms 19ms 19 51 872ms 17ms [ User: pharmisight - Total duration: 2s233ms - Times executed: 122 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s233ms - Times executed: 122 ]
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414562' ORDER BY orderround0_.pickerId ASC;
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414332' ORDER BY orderround0_.pickerId ASC;
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414782' ORDER BY orderround0_.pickerId ASC;
Date: 2018-04-23 16:31:19 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:17:00 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:17:01 Duration: 22ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s478ms 124,474 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 23 16 11,970 141ms 0ms 17 16,340 191ms 0ms 18 16,105 195ms 0ms 19 16,036 192ms 0ms 20 15,764 183ms 0ms 21 16,081 187ms 0ms 22 16,116 191ms 0ms 23 16,062 194ms 0ms [ User: symmetricds - Total duration: 1s478ms - Times executed: 124474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s478ms - Times executed: 124474 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-04-23 18:25:18 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:25:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:05:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s113ms 24,570 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 23 16 2,043 93ms 0ms 17 3,213 145ms 0ms 18 3,222 144ms 0ms 19 3,222 148ms 0ms 20 3,213 141ms 0ms 21 3,222 148ms 0ms 22 3,222 144ms 0ms 23 3,213 146ms 0ms [ User: symmetricds - Total duration: 1s113ms - Times executed: 24570 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s113ms - Times executed: 24570 ]
-
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-04-23 23:44:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:44:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:51:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s63ms 98 1ms 90ms 10ms 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 #8
Day Hour Count Duration Avg duration Apr 23 17 14 120ms 8ms 18 14 161ms 11ms 19 14 138ms 9ms 20 14 157ms 11ms 21 14 209ms 14ms 22 14 137ms 9ms 23 14 139ms 9ms [ User: symmetricds - Total duration: 1s63ms - Times executed: 98 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s63ms - Times executed: 98 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '82126425' AND '82131425' AND create_time < '2018-04-22 20:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126425' AND '82131425') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126425' AND '82131425' 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 '82126401' AND '82131401' AND create_time < '2018-04-22 18:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126401' AND '82131401') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126401' AND '82131401' 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 '82126437' AND '82131437' AND create_time < '2018-04-22 21:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126437' AND '82131437') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126437' AND '82131437' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-04-23 20:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:00 Duration: 85ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 964ms 188 3ms 15ms 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 #9
Day Hour Count Duration Avg duration Apr 23 16 161 733ms 4ms 17 5 41ms 8ms 18 3 26ms 8ms 19 4 30ms 7ms 20 6 53ms 8ms 21 3 26ms 8ms 22 3 26ms 8ms 23 3 26ms 8ms [ User: symmetricds - Total duration: 782ms - Times executed: 145 ]
[ User: pharmisight - Total duration: 181ms - Times executed: 43 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 964ms - Times executed: 188 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-04-23 16:22:59 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:23:19 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:00:39 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 798ms 14,671 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 23 16 979 29ms 0ms 17 1,956 84ms 0ms 18 1,956 112ms 0ms 19 1,956 112ms 0ms 20 1,956 113ms 0ms 21 1,956 121ms 0ms 22 1,956 112ms 0ms 23 1,956 111ms 0ms [ User: pharmisight - Total duration: 798ms - Times executed: 14671 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 798ms - Times executed: 14671 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3592' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969671' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969670' ORDER BY itemcodes0_.code ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 725ms 13,179 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 23 16 968 34ms 0ms 17 1,747 76ms 0ms 18 1,744 101ms 0ms 19 1,744 101ms 0ms 20 1,744 101ms 0ms 21 1,744 108ms 0ms 22 1,744 101ms 0ms 23 1,744 100ms 0ms [ User: pharmisight - Total duration: 725ms - Times executed: 13179 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 725ms - Times executed: 13179 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3592' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969669' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 699ms 1,015 0ms 9ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 23 16 17 11ms 0ms 17 28 34ms 1ms 18 2 7ms 3ms 19 4 20ms 5ms 20 4 14ms 3ms 21 14 30ms 2ms 22 427 265ms 0ms 23 519 314ms 0ms [ User: pharmisight - Total duration: 699ms - Times executed: 1015 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 699ms - Times executed: 1015 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003853710', '2018-04-23 20:35:21', 'LINTONK', '2018-04-23 21:00:01.449', '41495', '1008', '150505230113182726');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003865714', '2018-04-23 17:03:44', 'TRYBE', '2018-04-23 17:20:01.3', '42675', '2', '150505230113178170');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003858996', '2018-04-23 21:03:35', 'LINTONK', '2018-04-23 21:20:01.294', '66675', '32', '150505230113183457');
Date: 2018-04-23 21:00:01 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:20:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:20:01 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 607ms 95,116 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 23 16 9,413 60ms 0ms 17 12,567 80ms 0ms 18 12,270 77ms 0ms 19 12,194 78ms 0ms 20 11,948 73ms 0ms 21 12,233 77ms 0ms 22 12,267 79ms 0ms 23 12,224 80ms 0ms [ User: symmetricds - Total duration: 602ms - Times executed: 94598 ]
[ User: pharmisight - Total duration: 4ms - Times executed: 518 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 606ms - Times executed: 95113 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-04-23 22:09:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:36:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:21:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 580ms 680 0ms 4ms 0ms SELECT orderlines0_.order_round_id AS order_r80_26_0_, orderlines0_.order_line_id AS order_li1_22_0_, orderlines0_.order_line_id AS order_li1_22_1_, orderlines0_.routenumber AS routenum2_22_1_, orderlines0_.sapordernumber AS saporder3_22_1_, orderlines0_.ordernumber AS ordernum4_22_1_, orderlines0_.answerordernumber AS answeror5_22_1_, orderlines0_.partcode AS partcode6_22_1_, orderlines0_.partdescription AS partdesc7_22_1_, orderlines0_.patientname AS patientn8_22_1_, orderlines0_.firstname AS firstnam9_22_1_, orderlines0_.middlename AS middlen10_22_1_, orderlines0_.lastname AS lastnam11_22_1_, orderlines0_.patientdateofbirth AS patient12_22_1_, orderlines0_.patientpostcode AS patient13_22_1_, orderlines0_.patientpostcodeprefix AS patient14_22_1_, orderlines0_.orderqty AS orderqt15_22_1_, orderlines0_.allocqty AS allocqt16_22_1_, orderlines0_.shipqty AS shipqty17_22_1_, orderlines0_.adjustedqty AS adjuste18_22_1_, orderlines0_.scannedqty AS scanned19_22_1_, orderlines0_.assignedqty AS assigne20_22_1_, orderlines0_.checkedqty AS checked21_22_1_, orderlines0_.backorderqty AS backord22_22_1_, orderlines0_.cancelqty AS cancelq23_22_1_, orderlines0_.reducedqty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliverydate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapcustomerid AS sapcust29_22_1_, orderlines0_.billtotype AS billtot30_22_1_, orderlines0_.barcodedate AS barcode31_22_1_, orderlines0_.barcodebatch AS barcode32_22_1_, orderlines0_.patientid AS patient33_22_1_, orderlines0_.isadded AS isadded34_22_1_, orderlines0_.isnotwithinage AS isnotwi35_22_1_, orderlines0_.isunderage AS isunder36_22_1_, orderlines0_.agecheck AS agechec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.ispaperworkproblem AS ispaper40_22_1_, orderlines0_.paperworkresolution AS paperwo41_22_1_, orderlines0_.pickerid AS pickeri42_22_1_, orderlines0_.specialcare AS special43_22_1_, orderlines0_.paperworkenquirystarted AS paperwo44_22_1_, orderlines0_.paperworkenquiryfinished AS paperwo45_22_1_, orderlines0_.paperworkenquiryresponse AS paperwo46_22_1_, orderlines0_.isnewproduct AS isnewpr47_22_1_, orderlines0_.extraprocedure AS extrapr48_22_1_, orderlines0_.overaverageqtymax AS overave49_22_1_, orderlines0_.overaverageqtyresolution AS overave50_22_1_, orderlines0_.createuser AS createu51_22_1_, orderlines0_.patientalert AS patient52_22_1_, orderlines0_.itemalert AS itemale53_22_1_, orderlines0_.checkerid AS checker54_22_1_, orderlines0_.reductionsummary AS reducti55_22_1_, orderlines0_.ismetabolic AS ismetab56_22_1_, orderlines0_.rxstatus AS rxstatu57_22_1_, orderlines0_.lastregupdateusertype AS lastreg58_22_1_, orderlines0_.lastregupdateusername AS lastreg59_22_1_, orderlines0_.lastregupdatedate AS lastreg60_22_1_, orderlines0_.sapplannedshipdate AS sapplan61_22_1_, orderlines0_.sapplanneddeliverydate AS sapplan62_22_1_, orderlines0_.requestedsapquantity AS request63_22_1_, orderlines0_.orderquantity AS orderqu64_22_1_, orderlines0_.reglinecreatedusertype AS regline65_22_1_, orderlines0_.reglinecreatedusername AS regline66_22_1_, orderlines0_.reglinecreateddate AS regline67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.ismetabolicpatient AS ismetab69_22_1_, orderlines0_.addedcase AS addedca70_22_1_, orderlines0_.ordertype AS orderty71_22_1_, orderlines0_.created AS created72_22_1_, orderlines0_.updated AS updated73_22_1_, orderlines0_.rxcheckby AS rxcheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertconfirmation AS alertco77_22_1_, orderlines0_.homewardaction AS homewar78_22_1_ FROM order_lines orderlines0_ WHERE orderlines0_.order_round_id = '' ORDER BY orderlines0_.lastname, orderlines0_.partcode ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 23 16 168 167ms 0ms 17 410 347ms 0ms 20 102 66ms 0ms [ User: pharmisight - Total duration: 580ms - Times executed: 680 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 580ms - Times executed: 680 ]
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
Date: 2018-04-23 16:36:00 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:08:04 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:08:13 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 514ms 21,847 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 #15
Day Hour Count Duration Avg duration Apr 23 16 1,816 47ms 0ms 17 2,856 67ms 0ms 18 2,864 65ms 0ms 19 2,864 66ms 0ms 20 2,856 63ms 0ms 21 2,864 66ms 0ms 22 2,867 68ms 0ms 23 2,860 68ms 0ms [ User: symmetricds - Total duration: 514ms - Times executed: 21847 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 514ms - Times executed: 21847 ]
-
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 '82193969' AND '132193968')) 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 '82194651' AND '132194650')) 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 '82193798' AND '132193797')) ORDER BY d.data_id ASC;
Date: 2018-04-23 22:20:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:00:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 493ms 3 118ms 255ms 164ms SELECT ordertasks0_.order_id AS order_id7_20_0_, ordertasks0_.order_task_id AS order_ta1_30_0_, ordertasks0_.order_task_id AS order_ta1_30_1_, ordertasks0_.tasklastmodifieddatetime AS tasklast2_30_1_, ordertasks0_.taskcreatedby AS taskcrea3_30_1_, ordertasks0_.spoketo AS spoketo4_30_1_, ordertasks0_.roleingpsurgery AS roleingp5_30_1_, ordertasks0_.gpsurgeryname AS gpsurger6_30_1_ FROM order_tasks ordertasks0_ WHERE ordertasks0_.order_id = '' ORDER BY ordertasks0_.taskcreatedby ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 23 17 3 493ms 164ms [ User: pharmisight - Total duration: 493ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 493ms - Times executed: 3 ]
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552352' ORDER BY ordertasks0_.taskCreatedBy ASC;
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552372' ORDER BY ordertasks0_.taskCreatedBy ASC;
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552372' ORDER BY ordertasks0_.taskCreatedBy ASC;
Date: 2018-04-23 17:03:47 Duration: 255ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:04:41 Duration: 119ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:53 Duration: 118ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 412ms 98 1ms 5ms 4ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 23 17 14 33ms 2ms 18 14 62ms 4ms 19 14 63ms 4ms 20 14 61ms 4ms 21 14 63ms 4ms 22 14 61ms 4ms 23 14 66ms 4ms [ User: symmetricds - Total duration: 412ms - Times executed: 98 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 412ms - Times executed: 98 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '82141416' AND '82146416' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 19:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82141416' AND '82146416');
-
DELETE FROM sym_data WHERE data_id BETWEEN '82146462' AND '82151462' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 23:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82146462' AND '82151462');
-
DELETE FROM sym_data WHERE data_id BETWEEN '82136439' AND '82141439' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 21:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82136439' AND '82141439');
Date: 2018-04-23 19:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 382ms 18,192 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 #18
Day Hour Count Duration Avg duration Apr 23 16 1,560 31ms 0ms 17 2,400 45ms 0ms 18 2,400 48ms 0ms 19 2,400 55ms 0ms 20 2,232 42ms 0ms 21 2,400 50ms 0ms 22 2,400 54ms 0ms 23 2,400 54ms 0ms [ User: symmetricds - Total duration: 382ms - Times executed: 18192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 382ms - Times executed: 18192 ]
-
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 = 'heartbeat';
-
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 = 'reload';
Date: 2018-04-23 21:22:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 22:40:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:47:16 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 366ms 1,846 0ms 1ms 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 #19
Day Hour Count Duration Avg duration Apr 23 16 161 31ms 0ms 17 242 46ms 0ms 18 240 50ms 0ms 19 245 49ms 0ms 20 229 45ms 0ms 21 242 46ms 0ms 22 240 47ms 0ms 23 247 49ms 0ms [ User: symmetricds - Total duration: 366ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 366ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
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;
Date: 2018-04-23 23:30:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:23:22 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:21:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 345ms 145 1ms 4ms 2ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = '' AND ct.relname = '' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 23 16 118 245ms 2ms 17 5 18ms 3ms 18 3 11ms 3ms 19 4 13ms 3ms 20 6 22ms 3ms 21 3 11ms 3ms 22 3 11ms 3ms 23 3 11ms 3ms [ User: symmetricds - Total duration: 345ms - Times executed: 145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 345ms - Times executed: 145 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'flow_reports' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2018-04-23 16:22:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:22:17 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:00:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 278,426 4s963ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 23 16 25,033 431ms 0ms 17 36,532 634ms 0ms 18 36,367 656ms 0ms 19 36,191 673ms 0ms 20 35,435 608ms 0ms 21 36,283 640ms 0ms 22 36,340 671ms 0ms 23 36,245 647ms 0ms [ User: symmetricds - Total duration: 4s949ms - Times executed: 278072 ]
[ User: pharmisight - Total duration: 13ms - Times executed: 354 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s963ms - Times executed: 278425 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 1 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-04-23 22:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:21:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:17:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 124,474 1s478ms 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 23 16 11,970 141ms 0ms 17 16,340 191ms 0ms 18 16,105 195ms 0ms 19 16,036 192ms 0ms 20 15,764 183ms 0ms 21 16,081 187ms 0ms 22 16,116 191ms 0ms 23 16,062 194ms 0ms [ User: symmetricds - Total duration: 1s478ms - Times executed: 124474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s478ms - Times executed: 124474 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-04-23 18:25:18 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:25:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:05:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 95,116 607ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 23 16 9,413 60ms 0ms 17 12,567 80ms 0ms 18 12,270 77ms 0ms 19 12,194 78ms 0ms 20 11,948 73ms 0ms 21 12,233 77ms 0ms 22 12,267 79ms 0ms 23 12,224 80ms 0ms [ User: symmetricds - Total duration: 602ms - Times executed: 94598 ]
[ User: pharmisight - Total duration: 4ms - Times executed: 518 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 606ms - Times executed: 95113 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-04-23 22:09:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:36:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:21:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 95,111 2s947ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 23 16 9,412 632ms 0ms 17 12,564 410ms 0ms 18 12,270 308ms 0ms 19 12,194 308ms 0ms 20 11,947 294ms 0ms 21 12,234 328ms 0ms 22 12,267 334ms 0ms 23 12,223 328ms 0ms [ User: symmetricds - Total duration: 2s797ms - Times executed: 94597 ]
[ User: pharmisight - Total duration: 149ms - Times executed: 514 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s947ms - Times executed: 95111 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-04-23 21:52:21 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:13:17 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:31:16 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 24,570 1s113ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 23 16 2,043 93ms 0ms 17 3,213 145ms 0ms 18 3,222 144ms 0ms 19 3,222 148ms 0ms 20 3,213 141ms 0ms 21 3,222 148ms 0ms 22 3,222 144ms 0ms 23 3,213 146ms 0ms [ User: symmetricds - Total duration: 1s113ms - Times executed: 24570 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s113ms - Times executed: 24570 ]
-
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-04-23 23:44:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:44:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:51:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 21,847 514ms 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 Apr 23 16 1,816 47ms 0ms 17 2,856 67ms 0ms 18 2,864 65ms 0ms 19 2,864 66ms 0ms 20 2,856 63ms 0ms 21 2,864 66ms 0ms 22 2,867 68ms 0ms 23 2,860 68ms 0ms [ User: symmetricds - Total duration: 514ms - Times executed: 21847 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 514ms - Times executed: 21847 ]
-
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 '82193969' AND '132193968')) 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 '82194651' AND '132194650')) 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 '82193798' AND '132193797')) ORDER BY d.data_id ASC;
Date: 2018-04-23 22:20:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:00:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 18,192 382ms 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 Apr 23 16 1,560 31ms 0ms 17 2,400 45ms 0ms 18 2,400 48ms 0ms 19 2,400 55ms 0ms 20 2,232 42ms 0ms 21 2,400 50ms 0ms 22 2,400 54ms 0ms 23 2,400 54ms 0ms [ User: symmetricds - Total duration: 382ms - Times executed: 18192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 382ms - Times executed: 18192 ]
-
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 = 'heartbeat';
-
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 = 'reload';
Date: 2018-04-23 21:22:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 22:40:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:47:16 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 14,671 798ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_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 Apr 23 16 979 29ms 0ms 17 1,956 84ms 0ms 18 1,956 112ms 0ms 19 1,956 112ms 0ms 20 1,956 113ms 0ms 21 1,956 121ms 0ms 22 1,956 112ms 0ms 23 1,956 111ms 0ms [ User: pharmisight - Total duration: 798ms - Times executed: 14671 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 798ms - Times executed: 14671 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3592' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969671' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969670' ORDER BY itemcodes0_.code ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 13,179 725ms 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_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 Apr 23 16 968 34ms 0ms 17 1,747 76ms 0ms 18 1,744 101ms 0ms 19 1,744 101ms 0ms 20 1,744 101ms 0ms 21 1,744 108ms 0ms 22 1,744 101ms 0ms 23 1,744 100ms 0ms [ User: pharmisight - Total duration: 725ms - Times executed: 13179 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 725ms - Times executed: 13179 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3592' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969669' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 5,107 251ms 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 Apr 23 16 428 19ms 0ms 17 670 35ms 0ms 18 676 33ms 0ms 19 669 33ms 0ms 20 648 31ms 0ms 21 672 32ms 0ms 22 673 31ms 0ms 23 671 33ms 0ms [ User: symmetricds - Total duration: 251ms - Times executed: 5107 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 251ms - Times executed: 5107 ]
-
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-04-23 17:19:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:38:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:45:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 3,652 225ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 23 16 313 18ms 0ms 17 480 28ms 0ms 18 480 32ms 0ms 19 480 30ms 0ms 20 459 27ms 0ms 21 480 29ms 0ms 22 480 28ms 0ms 23 480 29ms 0ms [ User: symmetricds - Total duration: 225ms - Times executed: 3652 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 225ms - Times executed: 3652 ]
-
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-04-23 18:49:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:38:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:22:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 3,560 256ms 0ms 0ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 23 16 1,011 75ms 0ms 17 264 20ms 0ms 18 40 4ms 0ms 19 44 4ms 0ms 20 173 13ms 0ms 21 64 6ms 0ms 22 890 58ms 0ms 23 1,074 72ms 0ms [ User: symmetricds - Total duration: 256ms - Times executed: 3560 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 256ms - Times executed: 3560 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82194547', '7437383', 'redditch_bankstreet', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82193887', '7437341', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82194676', '7437392', 'redditch_bankstreet', current_timestamp);
Date: 2018-04-23 23:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:24:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:40:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 2,748 92ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 23 16 229 7ms 0ms 17 360 11ms 0ms 18 360 12ms 0ms 19 359 12ms 0ms 20 360 12ms 0ms 21 360 11ms 0ms 22 360 11ms 0ms 23 360 11ms 0ms [ User: symmetricds - Total duration: 92ms - Times executed: 2748 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 92ms - Times executed: 2748 ]
-
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-04-23 20:31:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:21:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:47:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 2,737 69ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '' AND data_id <= '' ORDER BY data_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 23 16 227 7ms 0ms 17 357 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 357 8ms 0ms 21 358 8ms 0ms 22 361 9ms 0ms 23 361 9ms 0ms [ User: symmetricds - Total duration: 69ms - Times executed: 2737 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 69ms - Times executed: 2737 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '82194216' AND data_id <= '132194215' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '82193969' AND data_id <= '132193968' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '82194651' AND data_id <= '132194650' ORDER BY data_id ASC;
Date: 2018-04-23 22:40:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 22:20:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:40:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 2,730 151ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 23 16 227 13ms 0ms 17 357 19ms 0ms 18 358 19ms 0ms 19 358 19ms 0ms 20 357 19ms 0ms 21 358 20ms 0ms 22 358 19ms 0ms 23 357 18ms 0ms [ User: symmetricds - Total duration: 151ms - Times executed: 2730 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 151ms - Times executed: 2730 ]
-
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-04-23 17:40:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:22:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:43:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 2,274 225ms 0ms 1ms 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 #16
Day Hour Count Duration Avg duration Apr 23 16 195 27ms 0ms 17 300 30ms 0ms 18 300 27ms 0ms 19 300 28ms 0ms 20 279 27ms 0ms 21 300 27ms 0ms 22 300 28ms 0ms 23 300 27ms 0ms [ User: symmetricds - Total duration: 225ms - Times executed: 2274 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 225ms - Times executed: 2274 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
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 = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-04-23 23:34:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:07:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:53:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 1,906 5m21s 160ms 419ms 168ms SELECT rxlineacti0_.order_line_id AS order_l10_22_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_1_, rxlineacti0_.created AS created2_35_1_, rxlineacti0_.newrxstatus AS newrxsta3_35_1_, rxlineacti0_.newrxcheckby AS newrxche4_35_1_, rxlineacti0_.newrxcheck AS newrxche5_35_1_, rxlineacti0_.rxerror AS rxerror6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedbyrxlineactivity AS auditedb8_35_1_, rxlineacti0_.auditedaserror AS auditeda9_35_1_ FROM rx_line_activities rxlineacti0_ WHERE rxlineacti0_.order_line_id = '' ORDER BY rxlineacti0_.created ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 23 17 7 2s668ms 381ms 20 1,899 5m18s 167ms [ User: pharmisight - Total duration: 5m21s - Times executed: 1906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m21s - Times executed: 1906 ]
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264762' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
Date: 2018-04-23 20:03:50 Duration: 419ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:46 Duration: 408ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:51 Duration: 399ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 1,861 74ms 0ms 0ms 0ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 23 16 181 7ms 0ms 17 240 8ms 0ms 18 240 8ms 0ms 19 240 9ms 0ms 20 240 9ms 0ms 21 240 9ms 0ms 22 240 10ms 0ms 23 240 10ms 0ms [ User: symmetricds - Total duration: 74ms - Times executed: 1861 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 74ms - Times executed: 1861 ]
-
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-04-23 22:21:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 19:04:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:06:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1,846 366ms 0ms 1ms 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 #19
Day Hour Count Duration Avg duration Apr 23 16 161 31ms 0ms 17 242 46ms 0ms 18 240 50ms 0ms 19 245 49ms 0ms 20 229 45ms 0ms 21 242 46ms 0ms 22 240 47ms 0ms 23 247 49ms 0ms [ User: symmetricds - Total duration: 366ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 366ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
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;
Date: 2018-04-23 23:30:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:23:22 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:21:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,836 273ms 0ms 0ms 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 #20
Day Hour Count Duration Avg duration Apr 23 16 156 22ms 0ms 17 240 33ms 0ms 18 240 34ms 0ms 19 240 37ms 0ms 20 240 34ms 0ms 21 240 34ms 0ms 22 240 38ms 0ms 23 240 37ms 0ms [ User: symmetricds - Total duration: 273ms - Times executed: 1836 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 273ms - Times executed: 1836 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 21:48:24.11', last_lock_time = '2018-04-23 21:48:24.11' WHERE node_id = '2' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 19:48:24.11');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 23:17:26.224', last_lock_time = '2018-04-23 23:17:26.224' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 21:17:26.224');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 18:56:19.91', last_lock_time = '2018-04-23 18:56:19.91' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 16:56:19.91');
Date: 2018-04-23 21:48:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:17:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:56:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 291ms 332ms 317ms 11 3s488ms SELECT orderlinep0_.order_line_id AS order_l10_22_0_, orderlinep0_.order_line_prescription_id AS order_li1_25_0_, orderlinep0_.order_line_prescription_id AS order_li1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionid AS prescrip3_25_1_, orderlinep0_.plonkernumber AS plonkern4_25_1_, orderlinep0_.plonkerdate AS plonkerd5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imagelink AS imagelin7_25_1_, orderlinep0_.imagelinkoriginal AS imagelin8_25_1_, orderlinep0_.epscheck AS epscheck9_25_1_ FROM order_line_prescriptions orderlinep0_ WHERE orderlinep0_.order_line_id = '' ORDER BY orderlinep0_.prescriptionid ASC;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 23 16 3 922ms 307ms 17 8 2s566ms 320ms [ User: pharmisight - Total duration: 3s488ms - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s488ms - Times executed: 11 ]
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264832' ORDER BY orderlinep0_.prescriptionId ASC;
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264812' ORDER BY orderlinep0_.prescriptionId ASC;
-
SELECT orderlinep0_.ORDER_LINE_ID AS ORDER_L10_22_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_0_, orderlinep0_.ORDER_LINE_PRESCRIPTION_ID AS ORDER_LI1_25_1_, orderlinep0_.uuid AS uuid2_25_1_, orderlinep0_.prescriptionId AS prescrip3_25_1_, orderlinep0_.plonkerNumber AS plonkerN4_25_1_, orderlinep0_.plonkerDate AS plonkerD5_25_1_, orderlinep0_.imagetype AS imagetyp6_25_1_, orderlinep0_.imageLink AS imageLin7_25_1_, orderlinep0_.imageLinkOriginal AS imageLin8_25_1_, orderlinep0_.epsCheck AS epsCheck9_25_1_ FROM ORDER_LINE_PRESCRIPTIONS orderlinep0_ WHERE orderlinep0_.ORDER_LINE_ID = '213264812' ORDER BY orderlinep0_.prescriptionId ASC;
Date: 2018-04-23 17:04:36 Duration: 332ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:46 Duration: 331ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:59:10 Duration: 322ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 160ms 419ms 168ms 1,906 5m21s SELECT rxlineacti0_.order_line_id AS order_l10_22_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_0_, rxlineacti0_.rx_line_activity_id AS rx_line_1_35_1_, rxlineacti0_.created AS created2_35_1_, rxlineacti0_.newrxstatus AS newrxsta3_35_1_, rxlineacti0_.newrxcheckby AS newrxche4_35_1_, rxlineacti0_.newrxcheck AS newrxche5_35_1_, rxlineacti0_.rxerror AS rxerror6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedbyrxlineactivity AS auditedb8_35_1_, rxlineacti0_.auditedaserror AS auditeda9_35_1_ FROM rx_line_activities rxlineacti0_ WHERE rxlineacti0_.order_line_id = '' ORDER BY rxlineacti0_.created ASC;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 23 17 7 2s668ms 381ms 20 1,899 5m18s 167ms [ User: pharmisight - Total duration: 5m21s - Times executed: 1906 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m21s - Times executed: 1906 ]
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264762' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
-
SELECT rxlineacti0_.ORDER_LINE_ID AS ORDER_L10_22_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_0_, rxlineacti0_.RX_LINE_ACTIVITY_ID AS RX_LINE_1_35_1_, rxlineacti0_.CREATED AS CREATED2_35_1_, rxlineacti0_.newRxStatus AS newRxSta3_35_1_, rxlineacti0_.newRxCheckBy AS newRxChe4_35_1_, rxlineacti0_.newRxCheck AS newRxChe5_35_1_, rxlineacti0_.rxError AS rxError6_35_1_, rxlineacti0_.audited AS audited7_35_1_, rxlineacti0_.auditedByRxLineActivity AS auditedB8_35_1_, rxlineacti0_.auditedAsError AS auditedA9_35_1_ FROM RX_LINE_ACTIVITIES rxlineacti0_ WHERE rxlineacti0_.ORDER_LINE_ID = '213264812' ORDER BY rxlineacti0_.CREATED ASC;
Date: 2018-04-23 20:03:50 Duration: 419ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:46 Duration: 408ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:51 Duration: 399ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 118ms 255ms 164ms 3 493ms SELECT ordertasks0_.order_id AS order_id7_20_0_, ordertasks0_.order_task_id AS order_ta1_30_0_, ordertasks0_.order_task_id AS order_ta1_30_1_, ordertasks0_.tasklastmodifieddatetime AS tasklast2_30_1_, ordertasks0_.taskcreatedby AS taskcrea3_30_1_, ordertasks0_.spoketo AS spoketo4_30_1_, ordertasks0_.roleingpsurgery AS roleingp5_30_1_, ordertasks0_.gpsurgeryname AS gpsurger6_30_1_ FROM order_tasks ordertasks0_ WHERE ordertasks0_.order_id = '' ORDER BY ordertasks0_.taskcreatedby ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 23 17 3 493ms 164ms [ User: pharmisight - Total duration: 493ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 493ms - Times executed: 3 ]
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552352' ORDER BY ordertasks0_.taskCreatedBy ASC;
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552372' ORDER BY ordertasks0_.taskCreatedBy ASC;
-
SELECT ordertasks0_.ORDER_ID AS ORDER_ID7_20_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_0_, ordertasks0_.ORDER_TASK_ID AS ORDER_TA1_30_1_, ordertasks0_.taskLastModifiedDateTime AS taskLast2_30_1_, ordertasks0_.taskCreatedBy AS taskCrea3_30_1_, ordertasks0_.spokeTo AS spokeTo4_30_1_, ordertasks0_.roleInGPSurgery AS roleInGP5_30_1_, ordertasks0_.gpSurgeryName AS gpSurger6_30_1_ FROM ORDER_TASKS ordertasks0_ WHERE ordertasks0_.ORDER_ID = '207552372' ORDER BY ordertasks0_.taskCreatedBy ASC;
Date: 2018-04-23 17:03:47 Duration: 255ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:04:41 Duration: 119ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:03:53 Duration: 118ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 15ms 27ms 18ms 122 2s233ms SELECT orderround0_.order_round_id AS order_ro6_26_0_, orderround0_.order_round_picker_id AS order_ro1_29_0_, orderround0_.order_round_picker_id AS order_ro1_29_1_, orderround0_.pickerid AS pickerid2_29_1_, orderround0_.pickedorderlinescount AS pickedor3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errornote AS errornot5_29_1_ FROM order_round_pickers orderround0_ WHERE orderround0_.order_round_id = '' ORDER BY orderround0_.pickerid ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 23 16 24 460ms 19ms 17 47 901ms 19ms 19 51 872ms 17ms [ User: pharmisight - Total duration: 2s233ms - Times executed: 122 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s233ms - Times executed: 122 ]
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414562' ORDER BY orderround0_.pickerId ASC;
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414332' ORDER BY orderround0_.pickerId ASC;
-
SELECT orderround0_.ORDER_ROUND_ID AS ORDER_RO6_26_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_0_, orderround0_.ORDER_ROUND_PICKER_ID AS ORDER_RO1_29_1_, orderround0_.pickerId AS pickerId2_29_1_, orderround0_.pickedOrderLinesCount AS pickedOr3_29_1_, orderround0_.errors AS errors4_29_1_, orderround0_.errorNote AS errorNot5_29_1_ FROM ORDER_ROUND_PICKERS orderround0_ WHERE orderround0_.ORDER_ROUND_ID = '200414782' ORDER BY orderround0_.pickerId ASC;
Date: 2018-04-23 16:31:19 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:17:00 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:17:01 Duration: 22ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 90ms 10ms 98 1s63ms 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 #5
Day Hour Count Duration Avg duration Apr 23 17 14 120ms 8ms 18 14 161ms 11ms 19 14 138ms 9ms 20 14 157ms 11ms 21 14 209ms 14ms 22 14 137ms 9ms 23 14 139ms 9ms [ User: symmetricds - Total duration: 1s63ms - Times executed: 98 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s63ms - Times executed: 98 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '82126425' AND '82131425' AND create_time < '2018-04-22 20:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126425' AND '82131425') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126425' AND '82131425' 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 '82126401' AND '82131401' AND create_time < '2018-04-22 18:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126401' AND '82131401') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126401' AND '82131401' 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 '82126437' AND '82131437' AND create_time < '2018-04-22 21:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126437' AND '82131437') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82126437' AND '82131437' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-04-23 20:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:00 Duration: 85ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 3ms 15ms 5ms 188 964ms 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 #6
Day Hour Count Duration Avg duration Apr 23 16 161 733ms 4ms 17 5 41ms 8ms 18 3 26ms 8ms 19 4 30ms 7ms 20 6 53ms 8ms 21 3 26ms 8ms 22 3 26ms 8ms 23 3 26ms 8ms [ User: symmetricds - Total duration: 782ms - Times executed: 145 ]
[ User: pharmisight - Total duration: 181ms - Times executed: 43 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 964ms - Times executed: 188 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-04-23 16:22:59 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 16:23:19 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:00:39 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1ms 5ms 4ms 98 412ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 23 17 14 33ms 2ms 18 14 62ms 4ms 19 14 63ms 4ms 20 14 61ms 4ms 21 14 63ms 4ms 22 14 61ms 4ms 23 14 66ms 4ms [ User: symmetricds - Total duration: 412ms - Times executed: 98 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 412ms - Times executed: 98 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '82141416' AND '82146416' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 19:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82141416' AND '82146416');
-
DELETE FROM sym_data WHERE data_id BETWEEN '82146462' AND '82151462' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 23:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82146462' AND '82151462');
-
DELETE FROM sym_data WHERE data_id BETWEEN '82136439' AND '82141439' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-04-22 21:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '82136439' AND '82141439');
Date: 2018-04-23 19:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1ms 4ms 2ms 145 345ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = '' AND ct.relname = '' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 23 16 118 245ms 2ms 17 5 18ms 3ms 18 3 11ms 3ms 19 4 13ms 3ms 20 6 22ms 3ms 21 3 11ms 3ms 22 3 11ms 3ms 23 3 11ms 3ms [ User: symmetricds - Total duration: 345ms - Times executed: 145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 345ms - Times executed: 145 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'flow_reports' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'patients' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2018-04-23 16:22:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:22:17 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:00:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 4ms 0ms 680 580ms SELECT orderlines0_.order_round_id AS order_r80_26_0_, orderlines0_.order_line_id AS order_li1_22_0_, orderlines0_.order_line_id AS order_li1_22_1_, orderlines0_.routenumber AS routenum2_22_1_, orderlines0_.sapordernumber AS saporder3_22_1_, orderlines0_.ordernumber AS ordernum4_22_1_, orderlines0_.answerordernumber AS answeror5_22_1_, orderlines0_.partcode AS partcode6_22_1_, orderlines0_.partdescription AS partdesc7_22_1_, orderlines0_.patientname AS patientn8_22_1_, orderlines0_.firstname AS firstnam9_22_1_, orderlines0_.middlename AS middlen10_22_1_, orderlines0_.lastname AS lastnam11_22_1_, orderlines0_.patientdateofbirth AS patient12_22_1_, orderlines0_.patientpostcode AS patient13_22_1_, orderlines0_.patientpostcodeprefix AS patient14_22_1_, orderlines0_.orderqty AS orderqt15_22_1_, orderlines0_.allocqty AS allocqt16_22_1_, orderlines0_.shipqty AS shipqty17_22_1_, orderlines0_.adjustedqty AS adjuste18_22_1_, orderlines0_.scannedqty AS scanned19_22_1_, orderlines0_.assignedqty AS assigne20_22_1_, orderlines0_.checkedqty AS checked21_22_1_, orderlines0_.backorderqty AS backord22_22_1_, orderlines0_.cancelqty AS cancelq23_22_1_, orderlines0_.reducedqty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliverydate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapcustomerid AS sapcust29_22_1_, orderlines0_.billtotype AS billtot30_22_1_, orderlines0_.barcodedate AS barcode31_22_1_, orderlines0_.barcodebatch AS barcode32_22_1_, orderlines0_.patientid AS patient33_22_1_, orderlines0_.isadded AS isadded34_22_1_, orderlines0_.isnotwithinage AS isnotwi35_22_1_, orderlines0_.isunderage AS isunder36_22_1_, orderlines0_.agecheck AS agechec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.ispaperworkproblem AS ispaper40_22_1_, orderlines0_.paperworkresolution AS paperwo41_22_1_, orderlines0_.pickerid AS pickeri42_22_1_, orderlines0_.specialcare AS special43_22_1_, orderlines0_.paperworkenquirystarted AS paperwo44_22_1_, orderlines0_.paperworkenquiryfinished AS paperwo45_22_1_, orderlines0_.paperworkenquiryresponse AS paperwo46_22_1_, orderlines0_.isnewproduct AS isnewpr47_22_1_, orderlines0_.extraprocedure AS extrapr48_22_1_, orderlines0_.overaverageqtymax AS overave49_22_1_, orderlines0_.overaverageqtyresolution AS overave50_22_1_, orderlines0_.createuser AS createu51_22_1_, orderlines0_.patientalert AS patient52_22_1_, orderlines0_.itemalert AS itemale53_22_1_, orderlines0_.checkerid AS checker54_22_1_, orderlines0_.reductionsummary AS reducti55_22_1_, orderlines0_.ismetabolic AS ismetab56_22_1_, orderlines0_.rxstatus AS rxstatu57_22_1_, orderlines0_.lastregupdateusertype AS lastreg58_22_1_, orderlines0_.lastregupdateusername AS lastreg59_22_1_, orderlines0_.lastregupdatedate AS lastreg60_22_1_, orderlines0_.sapplannedshipdate AS sapplan61_22_1_, orderlines0_.sapplanneddeliverydate AS sapplan62_22_1_, orderlines0_.requestedsapquantity AS request63_22_1_, orderlines0_.orderquantity AS orderqu64_22_1_, orderlines0_.reglinecreatedusertype AS regline65_22_1_, orderlines0_.reglinecreatedusername AS regline66_22_1_, orderlines0_.reglinecreateddate AS regline67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.ismetabolicpatient AS ismetab69_22_1_, orderlines0_.addedcase AS addedca70_22_1_, orderlines0_.ordertype AS orderty71_22_1_, orderlines0_.created AS created72_22_1_, orderlines0_.updated AS updated73_22_1_, orderlines0_.rxcheckby AS rxcheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertconfirmation AS alertco77_22_1_, orderlines0_.homewardaction AS homewar78_22_1_ FROM order_lines orderlines0_ WHERE orderlines0_.order_round_id = '' ORDER BY orderlines0_.lastname, orderlines0_.partcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 23 16 168 167ms 0ms 17 410 347ms 0ms 20 102 66ms 0ms [ User: pharmisight - Total duration: 580ms - Times executed: 680 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 580ms - Times executed: 680 ]
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
-
SELECT orderlines0_.ORDER_ROUND_ID AS ORDER_R80_26_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_0_, orderlines0_.ORDER_LINE_ID AS ORDER_LI1_22_1_, orderlines0_.routeNumber AS routeNum2_22_1_, orderlines0_.sapOrderNumber AS sapOrder3_22_1_, orderlines0_.orderNumber AS orderNum4_22_1_, orderlines0_.answerOrderNumber AS answerOr5_22_1_, orderlines0_.partCode AS partCode6_22_1_, orderlines0_.partDescription AS partDesc7_22_1_, orderlines0_.patientName AS patientN8_22_1_, orderlines0_.firstName AS firstNam9_22_1_, orderlines0_.middleName AS middleN10_22_1_, orderlines0_.lastName AS lastNam11_22_1_, orderlines0_.patientDateOfBirth AS patient12_22_1_, orderlines0_.patientPostcode AS patient13_22_1_, orderlines0_.patientPostcodePrefix AS patient14_22_1_, orderlines0_.orderQty AS orderQt15_22_1_, orderlines0_.allocQty AS allocQt16_22_1_, orderlines0_.shipQty AS shipQty17_22_1_, orderlines0_.adjustedQty AS adjuste18_22_1_, orderlines0_.scannedQty AS scanned19_22_1_, orderlines0_.assignedQty AS assigne20_22_1_, orderlines0_.checkedQty AS checked21_22_1_, orderlines0_.backOrderQty AS backOrd22_22_1_, orderlines0_.cancelQty AS cancelQ23_22_1_, orderlines0_.reducedQty AS reduced24_22_1_, orderlines0_.status AS status25_22_1_, orderlines0_.reason AS reason26_22_1_, orderlines0_.deliveryDate AS deliver27_22_1_, orderlines0_.customer AS custome28_22_1_, orderlines0_.sapCustomerId AS sapCust29_22_1_, orderlines0_.billToType AS billToT30_22_1_, orderlines0_.barcodeDate AS barcode31_22_1_, orderlines0_.barcodeBatch AS barcode32_22_1_, orderlines0_.patientId AS patient33_22_1_, orderlines0_.isAdded AS isAdded34_22_1_, orderlines0_.isNotWithinAge AS isNotWi35_22_1_, orderlines0_.isUnderAge AS isUnder36_22_1_, orderlines0_.ageCheck AS ageChec37_22_1_, orderlines0_.expired AS expired38_22_1_, orderlines0_.paperwork AS paperwo39_22_1_, orderlines0_.isPaperworkProblem AS isPaper40_22_1_, orderlines0_.paperworkResolution AS paperwo41_22_1_, orderlines0_.pickerId AS pickerI42_22_1_, orderlines0_.specialCare AS special43_22_1_, orderlines0_.paperworkEnquiryStarted AS paperwo44_22_1_, orderlines0_.paperworkEnquiryFinished AS paperwo45_22_1_, orderlines0_.paperworkEnquiryResponse AS paperwo46_22_1_, orderlines0_.isNewProduct AS isNewPr47_22_1_, orderlines0_.extraProcedure AS extraPr48_22_1_, orderlines0_.overAverageQtyMax AS overAve49_22_1_, orderlines0_.overAverageQtyResolution AS overAve50_22_1_, orderlines0_.createUser AS createU51_22_1_, orderlines0_.patientAlert AS patient52_22_1_, orderlines0_.itemAlert AS itemAle53_22_1_, orderlines0_.checkerId AS checker54_22_1_, orderlines0_.reductionSummary AS reducti55_22_1_, orderlines0_.isMetabolic AS isMetab56_22_1_, orderlines0_.rxStatus AS rxStatu57_22_1_, orderlines0_.lastRegUpdateUserType AS lastReg58_22_1_, orderlines0_.lastRegUpdateUserName AS lastReg59_22_1_, orderlines0_.lastRegUpdateDate AS lastReg60_22_1_, orderlines0_.sapPlannedShipDate AS sapPlan61_22_1_, orderlines0_.sapPlannedDeliveryDate AS sapPlan62_22_1_, orderlines0_.requestedSAPQuantity AS request63_22_1_, orderlines0_.orderQuantity AS orderQu64_22_1_, orderlines0_.regLineCreatedUserType AS regLine65_22_1_, orderlines0_.regLineCreatedUserName AS regLine66_22_1_, orderlines0_.regLineCreatedDate AS regLine67_22_1_, orderlines0_.audited AS audited68_22_1_, orderlines0_.isMetabolicPatient AS isMetab69_22_1_, orderlines0_.addedCase AS addedCa70_22_1_, orderlines0_.orderType AS orderTy71_22_1_, orderlines0_.CREATED AS CREATED72_22_1_, orderlines0_.UPDATED AS UPDATED73_22_1_, orderlines0_.rxCheckBy AS rxCheck74_22_1_, orderlines0_.note AS note75_22_1_, orderlines0_.item AS item76_22_1_, orderlines0_.alertConfirmation AS alertCo77_22_1_, orderlines0_.homewardAction AS homewar78_22_1_ FROM ORDER_LINES orderlines0_ WHERE orderlines0_.ORDER_ROUND_ID = '200414422' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
Date: 2018-04-23 16:36:00 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:08:04 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:08:13 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 9ms 0ms 1,015 699ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 23 16 17 11ms 0ms 17 28 34ms 1ms 18 2 7ms 3ms 19 4 20ms 5ms 20 4 14ms 3ms 21 14 30ms 2ms 22 427 265ms 0ms 23 519 314ms 0ms [ User: pharmisight - Total duration: 699ms - Times executed: 1015 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 699ms - Times executed: 1015 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003853710', '2018-04-23 20:35:21', 'LINTONK', '2018-04-23 21:00:01.449', '41495', '1008', '150505230113182726');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003865714', '2018-04-23 17:03:44', 'TRYBE', '2018-04-23 17:20:01.3', '42675', '2', '150505230113178170');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5003858996', '2018-04-23 21:03:35', 'LINTONK', '2018-04-23 21:20:01.294', '66675', '32', '150505230113183457');
Date: 2018-04-23 21:00:01 Duration: 9ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:20:01 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:20:01 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 1,846 366ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 23 16 161 31ms 0ms 17 242 46ms 0ms 18 240 50ms 0ms 19 245 49ms 0ms 20 229 45ms 0ms 21 242 46ms 0ms 22 240 47ms 0ms 23 247 49ms 0ms [ User: symmetricds - Total duration: 366ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 366ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
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;
Date: 2018-04-23 23:30:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:23:22 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:21:18 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 0ms 0ms 1,836 273ms 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 #12
Day Hour Count Duration Avg duration Apr 23 16 156 22ms 0ms 17 240 33ms 0ms 18 240 34ms 0ms 19 240 37ms 0ms 20 240 34ms 0ms 21 240 34ms 0ms 22 240 38ms 0ms 23 240 37ms 0ms [ User: symmetricds - Total duration: 273ms - Times executed: 1836 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 273ms - Times executed: 1836 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 21:48:24.11', last_lock_time = '2018-04-23 21:48:24.11' WHERE node_id = '2' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 19:48:24.11');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 23:17:26.224', last_lock_time = '2018-04-23 23:17:26.224' WHERE node_id = '1' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 21:17:26.224');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-04-23 18:56:19.91', last_lock_time = '2018-04-23 18:56:19.91' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-04-23 16:56:19.91');
Date: 2018-04-23 21:48:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:17:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:56:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 2,274 225ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 23 16 195 27ms 0ms 17 300 30ms 0ms 18 300 27ms 0ms 19 300 28ms 0ms 20 279 27ms 0ms 21 300 27ms 0ms 22 300 28ms 0ms 23 300 27ms 0ms [ User: symmetricds - Total duration: 225ms - Times executed: 2274 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 225ms - Times executed: 2274 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
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 = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-04-23 23:34:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:07:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:53:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 3,560 256ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 23 16 1,011 75ms 0ms 17 264 20ms 0ms 18 40 4ms 0ms 19 44 4ms 0ms 20 173 13ms 0ms 21 64 6ms 0ms 22 890 58ms 0ms 23 1,074 72ms 0ms [ User: symmetricds - Total duration: 256ms - Times executed: 3560 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 256ms - Times executed: 3560 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82194547', '7437383', 'redditch_bankstreet', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82193887', '7437341', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('82194676', '7437392', 'redditch_bankstreet', current_timestamp);
Date: 2018-04-23 23:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:24:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:40:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 3,652 225ms 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 #15
Day Hour Count Duration Avg duration Apr 23 16 313 18ms 0ms 17 480 28ms 0ms 18 480 32ms 0ms 19 480 30ms 0ms 20 459 27ms 0ms 21 480 29ms 0ms 22 480 28ms 0ms 23 480 29ms 0ms [ User: symmetricds - Total duration: 225ms - Times executed: 3652 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 225ms - Times executed: 3652 ]
-
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-04-23 18:49:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:38:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:22:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 2,730 151ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 23 16 227 13ms 0ms 17 357 19ms 0ms 18 358 19ms 0ms 19 358 19ms 0ms 20 357 19ms 0ms 21 358 20ms 0ms 22 358 19ms 0ms 23 357 18ms 0ms [ User: symmetricds - Total duration: 151ms - Times executed: 2730 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 151ms - Times executed: 2730 ]
-
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-04-23 17:40:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 23:22:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:43:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 13,179 725ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 23 16 968 34ms 0ms 17 1,747 76ms 0ms 18 1,744 101ms 0ms 19 1,744 101ms 0ms 20 1,744 101ms 0ms 21 1,744 108ms 0ms 22 1,744 101ms 0ms 23 1,744 100ms 0ms [ User: pharmisight - Total duration: 725ms - Times executed: 13179 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 725ms - Times executed: 13179 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3592' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32969669' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 14,671 798ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 23 16 979 29ms 0ms 17 1,956 84ms 0ms 18 1,956 112ms 0ms 19 1,956 112ms 0ms 20 1,956 113ms 0ms 21 1,956 121ms 0ms 22 1,956 112ms 0ms 23 1,956 111ms 0ms [ User: pharmisight - Total duration: 798ms - Times executed: 14671 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 798ms - Times executed: 14671 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3592' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969671' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32969670' ORDER BY itemcodes0_.code ASC;
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:00:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 5,107 251ms 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 #19
Day Hour Count Duration Avg duration Apr 23 16 428 19ms 0ms 17 670 35ms 0ms 18 676 33ms 0ms 19 669 33ms 0ms 20 648 31ms 0ms 21 672 32ms 0ms 22 673 31ms 0ms 23 671 33ms 0ms [ User: symmetricds - Total duration: 251ms - Times executed: 5107 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 251ms - Times executed: 5107 ]
-
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-04-23 17:19:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 17:38:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 20:45:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 24,570 1s113ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 23 16 2,043 93ms 0ms 17 3,213 145ms 0ms 18 3,222 144ms 0ms 19 3,222 148ms 0ms 20 3,213 141ms 0ms 21 3,222 148ms 0ms 22 3,222 144ms 0ms 23 3,213 146ms 0ms [ User: symmetricds - Total duration: 1s113ms - Times executed: 24570 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s113ms - Times executed: 24570 ]
-
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-04-23 23:44:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 18:44:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-04-23 21:51:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 2,217,462 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 2 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 23 16 1 - LOG: database system was shut down at 2018-04-23 16:21:32 BST
Date: 2018-04-23 16:21:33
2 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 23 16 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-04-23 16:22:02 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: