pgBadger-
Global information
- Generated on Mon Oct 22 00:00:43 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 1,340,860 log entries in 40s
- Log start from 2018-10-21 19:23:00 to 2018-10-21 23:59:59
-
Overview
Global Stats
- 188 Number of unique normalized queries
- 457,008 Number of queries
- 22s958ms Total query duration
- 2018-10-21 19:23:02 First query
- 2018-10-21 23:59:59 Last query
- 2,363 queries/s at 2018-10-21 19:23:57 Query peak
- 8 Number of events
- 3 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 53 Total number of automatic vacuums
- 68 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 460 Total number of sessions
- 3 sessions at 2018-10-21 19:23:00 Session peak
- 1d21h32m2s Total duration of sessions
- 5m56s Average duration of sessions
- 993 Average queries per session
- 49ms Average queries duration per session
- 470 Total number of connections
- 6 connections/s at 2018-10-21 19:23:02 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2,363 queries/s Query Peak
- 2018-10-21 19:23:57 Date
SELECT Traffic
Key values
- 1,644 queries/s Query Peak
- 2018-10-21 19:28:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,144 queries/s Query Peak
- 2018-10-21 19:23:57 Date
Queries duration
Key values
- 22s958ms Total query duration
Prepared queries ratio
Key values
- 1.72 Ratio of bind vs prepare
- 159.90 % 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) Oct 21 19 85,116 0ms 316ms 0ms 491ms 765ms 4s164ms 20 91,908 0ms 318ms 0ms 62ms 80ms 2s942ms 21 93,492 0ms 25ms 0ms 65ms 212ms 373ms 22 93,219 0ms 27ms 0ms 68ms 159ms 257ms 23 93,273 0ms 21ms 0ms 67ms 144ms 323ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 21 19 33,598 0 0ms 33ms 121ms 2s239ms 20 30,979 0 0ms 32ms 34ms 233ms 21 31,082 0 0ms 30ms 34ms 48ms 22 31,006 0 0ms 31ms 36ms 44ms 23 30,941 0 0ms 29ms 33ms 43ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 21 19 1,843 2,022 442 0 0ms 3ms 15ms 231ms 20 157 631 124 0 1ms 1ms 8ms 89ms 21 671 769 81 0 0ms 2ms 8ms 98ms 22 475 717 80 0 0ms 2ms 8ms 82ms 23 671 770 84 0 0ms 2ms 8ms 85ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 21 19 42,788 85,092 1.99 72.46% 20 54,735 91,872 1.68 97.79% 21 56,191 93,456 1.66 98.50% 22 56,091 93,183 1.66 98.85% 23 55,305 93,237 1.69 97.21% Day Hour Count Average / Second Oct 21 19 63 0.02/s 20 102 0.03/s 21 107 0.03/s 22 108 0.03/s 23 90 0.03/s Day Hour Count Average Duration Oct 21 19 53 3m59s 20 102 7m14s 21 107 5m35s 22 108 5m28s 23 90 6m34s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2018-10-21 19:23:02 Date
Connections per database
Key values
- pharmisight Main Database
- 470 connections Total
Connections per user
Key values
- pharmisight Main User
- 470 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-10-21 19:23:00 Date
Histogram of session times
Key values
- 376 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 460 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 460 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 460 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,115 buffers Checkpoint Peak
- 2018-10-21 20:04:53 Date
- 111.743 seconds Highest write time
- 0.114 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-10-21 20:08:07 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 Oct 21 19 1,033 102.946s 0.124s 103.132s 20 1,598 160.197s 0.015s 160.254s 21 754 75.631s 0.013s 75.688s 22 736 73.827s 0.016s 73.898s 23 754 75.641s 0.014s 75.707s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 21 19 0 0 1 193 0.114s 0.114s 20 0 0 1 354 0.002s 0s 21 0 0 0 373 0.002s 0s 22 0 0 1 369 0.003s 0s 23 0 0 0 366 0.002s 0s Day Hour Count Avg time (sec) Oct 21 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 21 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 Oct 21 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.44 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-10-21 20:00:43 Date
- 0.12 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-10-21 20:00:35 Date
Analyzes per table
Key values
- public.sym_node_communication (39) Main table analyzed (database pharmisight)
- 68 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 39 pharmisight.public.sym_outgoing_batch 6 pharmisight.public.sym_data_event 5 pharmisight.public.sym_data 4 pharmisight.public.sym_node_host 4 pharmisight.public.sym_incoming_batch 3 pharmisight.public.sym_sequence 2 pharmisight.public.sym_data_gap 2 pharmisight.public.sym_lock 2 pharmisight.public.item_codes 1 Total 68 Vacuums per table
Key values
- public.sym_node_communication (38) Main table vacuumed on database pharmisight
- 53 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 38 0 pharmisight.public.sym_outgoing_batch 4 4 pharmisight.public.sym_sequence 2 0 pharmisight.public.sym_incoming_batch 2 2 pharmisight.public.sym_lock 2 0 pharmisight.public.sym_data 1 1 pharmisight.public.sym_node_host 1 0 pharmisight.public.sym_data_gap 1 1 pharmisight.public.sym_data_event 1 1 pharmisight.public.item_codes 1 1 Total 53 10 Tuples removed per table
Key values
- public.sym_data_event (14299) Main table with removed tuples on database pharmisight
- 27103 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 1 1 14299 992 pharmisight.public.sym_data 1 1 6680 2335 pharmisight.public.sym_outgoing_batch 4 4 2663 232 pharmisight.public.sym_node_communication 38 0 2192 0 pharmisight.public.sym_incoming_batch 2 2 908 3 pharmisight.public.sym_sequence 2 0 111 0 pharmisight.public.sym_lock 2 0 104 0 pharmisight.public.sym_node_host 1 0 52 0 pharmisight.public.sym_data_gap 1 1 51 0 pharmisight.public.item_codes 1 1 43 0 Total 53 10 27,103 3,562 Pages removed per table
Key values
- public.sym_data (2335) Main table with removed pages on database pharmisight
- 3562 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 1 1 6680 2335 pharmisight.public.sym_data_event 1 1 14299 992 pharmisight.public.sym_outgoing_batch 4 4 2663 232 pharmisight.public.sym_incoming_batch 2 2 908 3 pharmisight.public.sym_sequence 2 0 111 0 pharmisight.public.sym_node_host 1 0 52 0 pharmisight.public.sym_data_gap 1 1 51 0 pharmisight.public.sym_node_communication 38 0 2192 0 pharmisight.public.item_codes 1 1 43 0 pharmisight.public.sym_lock 2 0 104 0 Total 53 10 27,103 3,562 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 21 19 7 11 20 13 13 21 11 15 22 11 13 23 11 16 - 7.44 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
- 157,606 Total read queries
- 128,099 Total write queries
Queries by database
Key values
- pharmisight Main database
- 457,005 Requests
- 22s638ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 475,119 Requests
User Request type Count Duration pharmisight Total 17,140 5s28ms DELETE 32 3ms INSERT 423 1s246ms OTHERS 732 26ms SELECT 15,692 3s678ms TCL 212 32ms UPDATE 49 40ms postgres Total 3 320ms SELECT 3 320ms symmetricds Total 475,119 17s483ms DDL 2 138ms DELETE 797 728ms INSERT 3,406 554ms OTHERS 184,935 3s276ms SELECT 152,996 7s490ms TCL 127,912 3s51ms UPDATE 5,071 2s244ms tony Total 165 907ms SELECT 165 907ms Duration by user
Key values
- 17s483ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 17,140 5s28ms DELETE 32 3ms INSERT 423 1s246ms OTHERS 732 26ms SELECT 15,692 3s678ms TCL 212 32ms UPDATE 49 40ms postgres Total 3 320ms SELECT 3 320ms symmetricds Total 475,119 17s483ms DDL 2 138ms DELETE 797 728ms INSERT 3,406 554ms OTHERS 184,935 3s276ms SELECT 152,996 7s490ms TCL 127,912 3s51ms UPDATE 5,071 2s244ms tony Total 165 907ms SELECT 165 907ms Queries by host
Key values
- 10.10.10.1 Main host
- 492,259 Requests
- 22s511ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 456,428 Requests
- 21s721ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-10-21 23:07:19 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 455,122 0-1ms duration
Slowest individual queries
Rank Duration Query 1 318ms DELETE FROM sym_data WHERE data_id BETWEEN '90743920' AND '90748920' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 316ms SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;[ Date: 2018-10-21 19:23:02 - Database: postgres - User: postgres - Remote: [local] - Application: psql ]
3 171ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-21 00:00:00' AND '2018-10-22 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2018-10-21 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 155ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_7_0_, this_.routeNumber AS routeNum2_7_0_, this_.roundDeliveryDate AS roundDel3_7_0_, this_.distributionPoint AS distribu4_7_0_, this_.fullyPicked AS fullyPic5_7_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_7_0_, this_.causeOfDelay AS causeOfD7_7_0_, this_.pharmacy100CheckTime AS pharmacy8_7_0_, this_.linesHeldBack AS linesHel9_7_0_, this_.packTime100 AS packTim10_7_0_, this_.replenish AS repleni11_7_0_, this_.comment AS comment12_7_0_, this_.pickDateTime AS pickDat13_7_0_, this_.failedTargetPickTime AS failedT14_7_0_, this_.actualPaperworkCompleteTime AS actualP15_7_0_, this_.changedPickDateTime AS changed16_7_0_, this_.manuallyChangedPickTime AS manuall17_7_0_, this_.CREATED AS CREATED18_7_0_, this_.UPDATED AS UPDATED19_7_0_, this_.note AS note20_7_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = '2018-10-21' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2018-10-21 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 137ms UPDATE sym_node_communication SET lock_time = NULL WHERE locking_server_id = 'scancheck' AND lock_time IS NOT NULL;[ Date: 2018-10-21 19:23:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 132ms ALTER TABLE "public"."sym_sequence" ALTER COLUMN "max_value" SET DEFAULT 9999999999;[ Date: 2018-10-21 19:23:14 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 90ms UPDATE sym_outgoing_batch SET STATUS = 'OK' WHERE node_id NOT IN ( SELECT node_id FROM sym_node WHERE sync_enabled = '1') AND STATUS != 'OK';[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 88ms SELECT datname, usename, client_addr, query FROM pg_stat_activity;[ Date: 2018-10-21 19:26:20 - Database: pharmisight - User: tony - Remote: ::1 - Application: [unknown] ]
9 83ms 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 = '200483362' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;[ Date: 2018-10-21 20:00:33 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 74ms UPDATE sym_node_host SET ip_address = '10.10.10.1', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '415971528', total_memory_bytes = '514850816', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.0.0', symmetric_version = '3.6.17', timezone_offset = '+01:00', heartbeat_time = '2018-10-21 19:23:23', last_restart_time = '2018-10-21 19:23:23.898' WHERE node_id = '3' AND host_name = 'scancheck';[ Date: 2018-10-21 19:23:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 71ms 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 = '200482782' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;[ Date: 2018-10-21 20:00:38 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 70ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8112265' AND '8114724' AND STATUS != 'OK') AND batch_id BETWEEN '8112265' AND '8114724';[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 67ms UPDATE "public"."eps_header" SET "received" = 't', "update_date" = '2018-10-21 03:37:47.131171', "document_id" = '2911576', "parent_uuid" = CAST (NULL AS uuid) WHERE "uuid" = CAST ('b11c3cb2-d229-11e8-a540-25eac1e6c021' AS uuid);[ Date: 2018-10-21 19:23:59 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 62ms DELETE FROM sym_data WHERE data_id BETWEEN '90763924' AND '90765288' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 61ms 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 = '200483372' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;[ Date: 2018-10-21 20:00:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 56ms DELETE FROM sym_data WHERE data_id BETWEEN '90748921' AND '90753921' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 53ms SELECT SUM (dlx_barcodes.orderqty) FROM dlx_barcodes INNER JOIN order_lines ON (dlx_barcodes.ordernumber = order_lines.ordernumber AND dlx_barcodes.partcode = order_lines.partcode) WHERE order_round_id = '200483632';[ Date: 2018-10-21 20:00:35 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 53ms 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 = '200482722' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;[ Date: 2018-10-21 20:00:32 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 51ms DELETE FROM sym_data WHERE data_id BETWEEN '90753922' AND '90758922' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90753922' AND '90758922') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90753922' AND '90758922' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-10-21 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 50ms SELECT * FROM ( SELECT n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, row_number () OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, pg_catalog.pg_get_expr (def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind IN ('r', 'v', 'f', 'm') AND a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'sym_parameter') c WHERE TRUE ORDER BY nspname, c.relname, attnum;[ Date: 2018-10-21 19:23:10 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3s10ms 170,479 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 19 25,961 446ms 0ms 20 35,755 627ms 0ms 21 36,253 646ms 0ms 22 36,285 643ms 0ms 23 36,225 646ms 0ms [ User: symmetricds - Total duration: 3s2ms - Times executed: 170254 ]
[ User: pharmisight - Total duration: 8ms - Times executed: 225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s10ms - Times executed: 170479 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-10-21 19:23:23 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:48:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:15:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 2s578ms 59,277 0ms 35ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 19 10,569 1s276ms 0ms 20 12,041 302ms 0ms 21 12,223 322ms 0ms 22 12,232 344ms 0ms 23 12,212 331ms 0ms [ User: symmetricds - Total duration: 2s546ms - Times executed: 59176 ]
[ User: pharmisight - Total duration: 31ms - Times executed: 101 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s578ms - Times executed: 59277 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-10-21 19:25:43 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:43 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:43 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 1s596ms 315 3ms 23ms 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 #3
Day Hour Count Duration Avg duration Oct 21 19 300 1s463ms 4ms 20 6 53ms 8ms 21 3 26ms 8ms 22 3 26ms 8ms 23 3 26ms 8ms [ User: symmetricds - Total duration: 1s206ms - Times executed: 229 ]
[ User: pharmisight - Total duration: 389ms - Times executed: 86 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s596ms - Times executed: 315 ]
-
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 = 'alerts' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-10-21 19:23:05 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:17 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:36 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1s185ms 389 0ms 34ms 3ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 20 9 87ms 9ms 21 143 491ms 3ms 22 94 292ms 3ms 23 143 314ms 2ms [ User: pharmisight - Total duration: 1s185ms - Times executed: 389 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s185ms - Times executed: 389 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004674284', '2018-10-21 20:24:58', 'BARTCZAKM', '2018-10-21 20:40:01.993', '41107', '24', '31237090307184001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004666797', '2018-10-21 21:38:52', 'BARTCZAKM', '2018-10-21 22:00:00.066', '88664', '6', '31237090307220007');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004668954', '2018-10-21 20:31:15', 'BARTCZAKM', '2018-10-21 21:00:00.082', '63953', '30', '31237090307193001');
Date: 2018-10-21 20:40:02 Duration: 34ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:00:00 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:00:00 Duration: 25ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 970ms 77,371 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 21 19 13,408 157ms 0ms 20 15,846 200ms 0ms 21 16,040 202ms 0ms 22 16,046 202ms 0ms 23 16,031 207ms 0ms [ User: symmetricds - Total duration: 970ms - Times executed: 77371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 970ms - Times executed: 77371 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-10-21 20:00:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:45:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 23:08:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 914ms 120 0ms 83ms 7ms 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 #6
Day Hour Count Duration Avg duration Oct 21 20 120 914ms 7ms [ User: pharmisight - Total duration: 914ms - Times executed: 120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 914ms - Times executed: 120 ]
-
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 = '200483362' 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 = '200482782' 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 = '200483372' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
Date: 2018-10-21 20:00:33 Duration: 83ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:38 Duration: 71ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:32 Duration: 61ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 675ms 14,778 0ms 5ms 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 Oct 21 19 1,908 91ms 0ms 20 3,217 146ms 0ms 21 3,218 147ms 0ms 22 3,222 144ms 0ms 23 3,213 144ms 0ms [ User: symmetricds - Total duration: 675ms - Times executed: 14778 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 14778 ]
-
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-10-21 19:23:23 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:53:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:47:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 659ms 55 11ms 12ms 11ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 21 19 7 84ms 12ms 20 12 143ms 11ms 21 12 144ms 12ms 22 12 143ms 11ms 23 12 143ms 11ms [ User: tony - Total duration: 659ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 659ms - Times executed: 55 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-10-21 19:26:20 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-10-21 21:41:20 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-10-21 20:20:44 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
9 537ms 8 0ms 318ms 67ms 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 #9
Day Hour Count Duration Avg duration Oct 21 20 5 534ms 106ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: symmetricds - Total duration: 537ms - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 537ms - Times executed: 8 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '90743920' AND '90748920' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920' 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 '90763924' AND '90765288' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288' 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 '90748921' AND '90753921' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-10-21 20:00:00 Duration: 318ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:00 Duration: 62ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 536ms 297 0ms 24ms 1ms UPDATE "public"."sym_node_host" SET "ip_address" = '', "os_user" = '', "os_name" = '', "os_arch" = '', "os_version" = '', "available_processors" = '', "free_memory_bytes" = '', "total_memory_bytes" = '', "max_memory_bytes" = '', "java_version" = '', "java_vendor" = '', "symmetric_version" = '', "timezone_offset" = '', "heartbeat_time" = '', "last_restart_time" = '', "create_time" = '', "jdbc_version" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 19 266 343ms 1ms 20 7 51ms 7ms 21 8 49ms 6ms 22 8 48ms 6ms 23 8 44ms 5ms [ User: symmetricds - Total duration: 536ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 536ms - Times executed: 297 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '279705992', "total_memory_bytes" = '534249472', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 14:34:50', "last_restart_time" = '2018-09-04 16:05:59', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '216067168', "total_memory_bytes" = '525336576', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 15:35:59', "last_restart_time" = '2018-09-06 13:12:42.532', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '328429672', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 19:34:50', "last_restart_time" = '2018-09-04 16:05:59', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2018-10-21 19:25:43 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:44 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:35:42 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 526ms 229 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 #11
Day Hour Count Duration Avg duration Oct 21 19 214 470ms 2ms 20 6 22ms 3ms 21 3 10ms 3ms 22 3 10ms 3ms 23 3 11ms 3ms [ User: symmetricds - Total duration: 526ms - Times executed: 229 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 526ms - Times executed: 229 ]
-
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 = 'order_rounds' 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 = 'order_round_activities' 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;
Date: 2018-10-21 20:00:36 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:28:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 444ms 744 0ms 15ms 0ms UPDATE "public"."patients" SET "caloriesday" = '' WHERE "patient_id" = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 21 19 744 444ms 0ms [ User: symmetricds - Total duration: 444ms - Times executed: 744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 444ms - Times executed: 744 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1339' WHERE "patient_id" = '200083690';
-
UPDATE "public"."patients" SET "caloriesday" = '1186' WHERE "patient_id" = '200350840';
-
UPDATE "public"."patients" SET "caloriesday" = '386' WHERE "patient_id" = '168309';
Date: 2018-10-21 19:23:56 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:56 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 404ms 6,923 0ms 7ms 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 #13
Day Hour Count Duration Avg duration Oct 21 19 2,967 153ms 0ms 20 989 74ms 0ms 21 989 70ms 0ms 22 989 50ms 0ms 23 989 54ms 0ms [ User: pharmisight - Total duration: 404ms - Times executed: 6923 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 6923 ]
-
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 = '43' 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 = '33016204' 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 = '33074331' ORDER BY itemcodes0_.code ASC;
Date: 2018-10-21 19:23:08 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:07 Duration: 5ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:08 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 377ms 59,281 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 19 10,571 62ms 0ms 20 12,041 77ms 0ms 21 12,223 77ms 0ms 22 12,232 79ms 0ms 23 12,214 79ms 0ms [ User: symmetricds - Total duration: 376ms - Times executed: 59178 ]
[ User: pharmisight - Total duration: 0ms - Times executed: 103 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 377ms - Times executed: 59281 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-10-21 22:56:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:17:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:02:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 361ms 6,146 0ms 13ms 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 #15
Day Hour Count Duration Avg duration Oct 21 19 2,634 133ms 0ms 20 878 68ms 0ms 21 878 64ms 0ms 22 878 46ms 0ms 23 878 49ms 0ms [ User: pharmisight - Total duration: 361ms - Times executed: 6146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 361ms - Times executed: 6146 ]
-
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;
-
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 = '2' 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 = '8' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-10-21 19:23:08 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:07 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:08 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 320ms 3 1ms 316ms 106ms SELECT d.datname AS "name", pg_catalog.pg_get_userbyid (d.datdba) AS "owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "encoding", d.datcollate AS "collate", d.datctype AS "ctype", pg_catalog.array_to_string (d.datacl, e '') AS "access privileges" FROM pg_catalog.pg_database d ORDER BY 0;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 19 3 320ms 106ms [ User: postgres - Total duration: 320ms - Times executed: 3 ]
[ Application: psql - Total duration: 320ms - Times executed: 3 ]
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
Date: 2018-10-21 19:23:02 Duration: 316ms Database: postgres User: postgres Remote: [local] Application: psql
Date: 2018-10-21 19:23:02 Duration: 2ms Database: postgres User: postgres Remote: [local] Application: psql
Date: 2018-10-21 19:23:03 Duration: 1ms Database: postgres User: postgres Remote: [local] Application: psql
17 303ms 13,137 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 21 19 1,697 39ms 0ms 20 2,859 63ms 0ms 21 2,861 64ms 0ms 22 2,864 67ms 0ms 23 2,856 68ms 0ms [ User: symmetricds - Total duration: 303ms - Times executed: 13137 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 303ms - Times executed: 13137 ]
-
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 = 'heartbeat' AND ((d.data_id BETWEEN '90765022' AND '140765021')) 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 = 'heartbeat' AND ((d.data_id BETWEEN '90765222' AND '140765221')) 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 '90765340' AND '140765339')) ORDER BY d.data_id ASC;
Date: 2018-10-21 19:23:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 284ms 116 0ms 33ms 2ms SELECT orders0_.order_round_id AS order_r42_26_0_, orders0_.order_id AS order_id1_20_0_, orders0_.order_id AS order_id1_20_1_, orders0_.sapordernumber AS saporder2_20_1_, orders0_.answerordernumber AS answeror3_20_1_, orders0_.ordernumber AS ordernum4_20_1_, orders0_.routenumber AS routenum5_20_1_, orders0_.billtotype AS billtoty6_20_1_, orders0_.patientname AS patientn7_20_1_, orders0_.firstname AS firstnam8_20_1_, orders0_.middlename AS middlena9_20_1_, orders0_.lastname AS lastnam10_20_1_, orders0_.patientdateofbirth AS patient11_20_1_, orders0_.patientpostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapcustomerid AS sapcust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientid AS patient16_20_1_, orders0_.isnotwithinage AS isnotwi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliverybarcode AS deliver20_20_1_, orders0_.deliverydate AS deliver21_20_1_, orders0_.rxstatus AS rxstatu22_20_1_, orders0_.createuser AS createu23_20_1_, orders0_.subordertype AS suborde24_20_1_, orders0_.sapcontractid AS sapcont25_20_1_, orders0_.salesforceordernumber AS salesfo26_20_1_, orders0_.patienttype AS patient27_20_1_, orders0_.ordertype AS orderty28_20_1_, orders0_.orderstatus AS orderst29_20_1_, orders0_.nhsnumber AS nhsnumb30_20_1_, orders0_.individuallabelling AS individ31_20_1_, orders0_.orderid AS orderid32_20_1_, orders0_.clusterlead AS cluster33_20_1_, orders0_.clustergroup AS cluster34_20_1_, orders0_.accountid AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionby AS reducti37_20_1_, orders0_.alertconfirmation AS alertco38_20_1_, orders0_.created AS created39_20_1_, orders0_.updated AS updated40_20_1_, orders0_.note AS note41_20_1_ FROM orders orders0_ WHERE orders0_.order_round_id = '' ORDER BY orders0_.order_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 20 116 284ms 2ms [ User: pharmisight - Total duration: 284ms - Times executed: 116 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 284ms - Times executed: 116 ]
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200482212' ORDER BY orders0_.order_id ASC;
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200483542' ORDER BY orders0_.order_id ASC;
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200484382' ORDER BY orders0_.order_id ASC;
Date: 2018-10-21 20:00:35 Duration: 33ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:33 Duration: 20ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:31 Duration: 19ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 247ms 1,102 0ms 7ms 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 Oct 21 19 143 39ms 0ms 20 234 50ms 0ms 21 240 54ms 0ms 22 243 53ms 0ms 23 242 49ms 0ms [ User: symmetricds - Total duration: 247ms - Times executed: 1102 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 247ms - Times executed: 1102 ]
-
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 = '3' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-10-21 19:23:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:34:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:01:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 237ms 4 15ms 171ms 59ms SELECT this_.order_round_id AS order_ro1_26_0_, this_.routenumber AS routenum2_26_0_, this_.uploadedbyuserid AS uploaded3_26_0_, this_.uploadedbyusername AS uploaded4_26_0_, this_.updatedby AS updatedb5_26_0_, this_.updatedbyusername AS updatedb6_26_0_, this_.orderroundnote AS orderrou7_26_0_, this_.firstcheckout AS firstche8_26_0_, this_.allordersscannedok AS allorder9_26_0_, this_.status AS status10_26_0_, this_.reopenedtimes AS reopene11_26_0_, this_.lastreopenbyid AS lastreo12_26_0_, this_.lastdonecheckin AS lastdon13_26_0_, this_.lastdonebyid AS lastdon14_26_0_, this_.lastdonebyusername AS lastdon15_26_0_, this_.missinglabels AS missing16_26_0_, this_.rounddeliverydate AS roundde17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadupdated AS uploadu21_26_0_, this_.patientalert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxstatus AS rxstatu24_26_0_, this_.distributionpoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedby AS audited27_26_0_, this_.auditstatus AS auditst28_26_0_, this_.uploadfinished AS uploadf29_26_0_, this_.lastrxcompleted AS lastrxc30_26_0_, this_.lastrxcompletedby AS lastrxc31_26_0_, this_.orderroundnotereadby AS orderro32_26_0_, this_.routeorderlinesqty AS routeor33_26_0_, this_.dlxpickedlinesqty AS dlxpick34_26_0_, this_.flowreport AS flowrep35_26_0_, this_.created AS created36_26_0_, this_.createdby AS created37_26_0_, this_.updated AS updated38_26_0_, this_.note AS note39_26_0_ FROM order_rounds this_ WHERE this_.created BETWEEN '' AND '' AND this_.status <> '';Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 20 4 237ms 59ms [ User: pharmisight - Total duration: 237ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 237ms - Times executed: 4 ]
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-21 00:00:00' AND '2018-10-22 00:00:00' AND this_.status <> 'Quarantine';
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-19 00:00:00' AND '2018-10-20 00:00:00' AND this_.status <> 'Quarantine';
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-20 00:00:00' AND '2018-10-21 00:00:00' AND this_.status <> 'Quarantine';
Date: 2018-10-21 20:00:30 Duration: 171ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:31 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:30 Duration: 25ms Database: pharmisight User: pharmisight 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 170,479 3s10ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 19 25,961 446ms 0ms 20 35,755 627ms 0ms 21 36,253 646ms 0ms 22 36,285 643ms 0ms 23 36,225 646ms 0ms [ User: symmetricds - Total duration: 3s2ms - Times executed: 170254 ]
[ User: pharmisight - Total duration: 8ms - Times executed: 225 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s10ms - Times executed: 170479 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-10-21 19:23:23 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:48:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:15:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 77,371 970ms 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 19 13,408 157ms 0ms 20 15,846 200ms 0ms 21 16,040 202ms 0ms 22 16,046 202ms 0ms 23 16,031 207ms 0ms [ User: symmetricds - Total duration: 970ms - Times executed: 77371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 970ms - Times executed: 77371 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-10-21 20:00:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:45:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 23:08:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 59,281 377ms 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 19 10,571 62ms 0ms 20 12,041 77ms 0ms 21 12,223 77ms 0ms 22 12,232 79ms 0ms 23 12,214 79ms 0ms [ User: symmetricds - Total duration: 376ms - Times executed: 59178 ]
[ User: pharmisight - Total duration: 0ms - Times executed: 103 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 377ms - Times executed: 59281 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-10-21 22:56:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:17:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:02:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 59,277 2s578ms 0ms 35ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 19 10,569 1s276ms 0ms 20 12,041 302ms 0ms 21 12,223 322ms 0ms 22 12,232 344ms 0ms 23 12,212 331ms 0ms [ User: symmetricds - Total duration: 2s546ms - Times executed: 59176 ]
[ User: pharmisight - Total duration: 31ms - Times executed: 101 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s578ms - Times executed: 59277 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-10-21 19:25:43 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:43 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:43 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 14,778 675ms 0ms 5ms 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 Oct 21 19 1,908 91ms 0ms 20 3,217 146ms 0ms 21 3,218 147ms 0ms 22 3,222 144ms 0ms 23 3,213 144ms 0ms [ User: symmetricds - Total duration: 675ms - Times executed: 14778 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 14778 ]
-
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-10-21 19:23:23 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:53:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:47:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 13,137 303ms 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 21 19 1,697 39ms 0ms 20 2,859 63ms 0ms 21 2,861 64ms 0ms 22 2,864 67ms 0ms 23 2,856 68ms 0ms [ User: symmetricds - Total duration: 303ms - Times executed: 13137 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 303ms - Times executed: 13137 ]
-
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 = 'heartbeat' AND ((d.data_id BETWEEN '90765022' AND '140765021')) 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 = 'heartbeat' AND ((d.data_id BETWEEN '90765222' AND '140765221')) 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 '90765340' AND '140765339')) ORDER BY d.data_id ASC;
Date: 2018-10-21 19:23:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 10,944 221ms 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 Oct 21 19 1,440 30ms 0ms 20 2,304 47ms 0ms 21 2,400 45ms 0ms 22 2,400 47ms 0ms 23 2,400 49ms 0ms [ User: symmetricds - Total duration: 221ms - Times executed: 10944 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 221ms - Times executed: 10944 ]
-
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 = 'config';
Date: 2018-10-21 20:00:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:28:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:33:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 6,923 404ms 0ms 7ms 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 Oct 21 19 2,967 153ms 0ms 20 989 74ms 0ms 21 989 70ms 0ms 22 989 50ms 0ms 23 989 54ms 0ms [ User: pharmisight - Total duration: 404ms - Times executed: 6923 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 404ms - Times executed: 6923 ]
-
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 = '43' 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 = '33016204' 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 = '33074331' ORDER BY itemcodes0_.code ASC;
Date: 2018-10-21 19:23:08 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:07 Duration: 5ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:08 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 6,146 361ms 0ms 13ms 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 Oct 21 19 2,634 133ms 0ms 20 878 68ms 0ms 21 878 64ms 0ms 22 878 46ms 0ms 23 878 49ms 0ms [ User: pharmisight - Total duration: 361ms - Times executed: 6146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 361ms - Times executed: 6146 ]
-
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;
-
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 = '2' 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 = '8' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-10-21 19:23:08 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:07 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:08 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 3,071 146ms 0ms 0ms 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 Oct 21 19 403 19ms 0ms 20 657 28ms 0ms 21 670 32ms 0ms 22 671 33ms 0ms 23 670 32ms 0ms [ User: symmetricds - Total duration: 146ms - Times executed: 3071 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 146ms - Times executed: 3071 ]
-
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-10-21 22:51:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:34:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 2,612 55ms 0ms 0ms 0ms SELECT set_config ('', '', FALSE);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 19 2,400 39ms 0ms 20 44 3ms 0ms 21 56 3ms 0ms 22 56 4ms 0ms 23 56 4ms 0ms [ User: symmetricds - Total duration: 55ms - Times executed: 2612 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55ms - Times executed: 2612 ]
-
SELECT set_config ('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config ('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config ('symmetric.triggers_disabled', '1', FALSE);
Date: 2018-10-21 20:36:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:10:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:50:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 2,198 143ms 0ms 8ms 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 #12
Day Hour Count Duration Avg duration Oct 21 19 290 25ms 0ms 20 468 28ms 0ms 21 480 31ms 0ms 22 480 28ms 0ms 23 480 29ms 0ms [ User: symmetricds - Total duration: 143ms - Times executed: 2198 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 143ms - Times executed: 2198 ]
-
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-10-21 19:23:14 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:18:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:41:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1,737 157ms 0ms 22ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 21 19 810 92ms 0ms 20 59 5ms 0ms 21 322 20ms 0ms 22 224 16ms 0ms 23 322 21ms 0ms [ User: symmetricds - Total duration: 157ms - Times executed: 1737 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 157ms - Times executed: 1737 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765243', '8114734', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765029', '8114728', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765120', '8114730', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
Date: 2018-10-21 19:25:46 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:55 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:24:05 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 1,653 52ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 19 213 6ms 0ms 20 360 11ms 0ms 21 360 11ms 0ms 22 360 11ms 0ms 23 360 11ms 0ms [ User: symmetricds - Total duration: 52ms - Times executed: 1653 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52ms - Times executed: 1653 ]
-
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-10-21 21:19:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:29:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:58:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 1,643 96ms 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 #15
Day Hour Count Duration Avg duration Oct 21 19 213 6ms 0ms 20 358 39ms 0ms 21 357 32ms 0ms 22 358 9ms 0ms 23 357 9ms 0ms [ User: symmetricds - Total duration: 96ms - Times executed: 1643 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 96ms - Times executed: 1643 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765021' AND data_id <= '140765020' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765601' AND data_id <= '140765600' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765297' AND data_id <= '140765296' ORDER BY data_id ASC;
Date: 2018-10-21 19:23:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 23:20:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:20:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 1,642 108ms 0ms 1ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 19 212 12ms 0ms 20 358 30ms 0ms 21 357 22ms 0ms 22 358 22ms 0ms 23 357 21ms 0ms [ User: symmetricds - Total duration: 108ms - Times executed: 1642 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 108ms - Times executed: 1642 ]
-
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-10-21 19:23:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:55:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:12:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 1,368 172ms 0ms 20ms 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 #17
Day Hour Count Duration Avg duration Oct 21 19 180 41ms 0ms 20 288 26ms 0ms 21 300 30ms 0ms 22 300 35ms 0ms 23 300 38ms 0ms [ User: symmetricds - Total duration: 172ms - Times executed: 1368 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 172ms - Times executed: 1368 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-10-21 19:23:24 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:24 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 1,154 40ms 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 Oct 21 19 194 6ms 0ms 20 240 8ms 0ms 21 240 8ms 0ms 22 240 7ms 0ms 23 240 8ms 0ms [ User: symmetricds - Total duration: 40ms - Times executed: 1154 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40ms - Times executed: 1154 ]
-
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-10-21 19:48:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:16:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:02:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1,104 78ms 0ms 0ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 19 144 11ms 0ms 20 240 16ms 0ms 21 240 16ms 0ms 22 240 17ms 0ms 23 240 16ms 0ms [ User: symmetricds - Total duration: 78ms - Times executed: 1104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 78ms - Times executed: 1104 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-10-21 22:39:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:54:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:18:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,104 170ms 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 Oct 21 19 144 23ms 0ms 20 240 35ms 0ms 21 240 36ms 0ms 22 240 37ms 0ms 23 240 37ms 0ms [ User: symmetricds - Total duration: 170ms - Times executed: 1104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 170ms - Times executed: 1104 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 23:07:07.597', last_lock_time = '2018-10-21 23:07:07.597' WHERE node_id = '0' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 21:07:07.597');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 20:27:03.596', last_lock_time = '2018-10-21 20:27:03.596' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 18:27:03.596');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 19:47:02.592', last_lock_time = '2018-10-21 19:47:02.592' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 17:47:02.592');
Date: 2018-10-21 23:07:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:27:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:47:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1ms 316ms 106ms 3 320ms SELECT d.datname AS "name", pg_catalog.pg_get_userbyid (d.datdba) AS "owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "encoding", d.datcollate AS "collate", d.datctype AS "ctype", pg_catalog.array_to_string (d.datacl, e '') AS "access privileges" FROM pg_catalog.pg_database d ORDER BY 0;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 19 3 320ms 106ms [ User: postgres - Total duration: 320ms - Times executed: 3 ]
[ Application: psql - Total duration: 320ms - Times executed: 3 ]
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
-
SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid (d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char (d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string (d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;
Date: 2018-10-21 19:23:02 Duration: 316ms Database: postgres User: postgres Remote: [local] Application: psql
Date: 2018-10-21 19:23:02 Duration: 2ms Database: postgres User: postgres Remote: [local] Application: psql
Date: 2018-10-21 19:23:03 Duration: 1ms Database: postgres User: postgres Remote: [local] Application: psql
2 0ms 318ms 67ms 8 537ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 20 5 534ms 106ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: symmetricds - Total duration: 537ms - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 537ms - Times executed: 8 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '90743920' AND '90748920' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90743920' AND '90748920' 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 '90763924' AND '90765288' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90763924' AND '90765288' 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 '90748921' AND '90753921' AND create_time < '2018-10-20 20:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '90748921' AND '90753921' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-10-21 20:00:00 Duration: 318ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:00 Duration: 62ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 15ms 171ms 59ms 4 237ms SELECT this_.order_round_id AS order_ro1_26_0_, this_.routenumber AS routenum2_26_0_, this_.uploadedbyuserid AS uploaded3_26_0_, this_.uploadedbyusername AS uploaded4_26_0_, this_.updatedby AS updatedb5_26_0_, this_.updatedbyusername AS updatedb6_26_0_, this_.orderroundnote AS orderrou7_26_0_, this_.firstcheckout AS firstche8_26_0_, this_.allordersscannedok AS allorder9_26_0_, this_.status AS status10_26_0_, this_.reopenedtimes AS reopene11_26_0_, this_.lastreopenbyid AS lastreo12_26_0_, this_.lastdonecheckin AS lastdon13_26_0_, this_.lastdonebyid AS lastdon14_26_0_, this_.lastdonebyusername AS lastdon15_26_0_, this_.missinglabels AS missing16_26_0_, this_.rounddeliverydate AS roundde17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadupdated AS uploadu21_26_0_, this_.patientalert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxstatus AS rxstatu24_26_0_, this_.distributionpoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedby AS audited27_26_0_, this_.auditstatus AS auditst28_26_0_, this_.uploadfinished AS uploadf29_26_0_, this_.lastrxcompleted AS lastrxc30_26_0_, this_.lastrxcompletedby AS lastrxc31_26_0_, this_.orderroundnotereadby AS orderro32_26_0_, this_.routeorderlinesqty AS routeor33_26_0_, this_.dlxpickedlinesqty AS dlxpick34_26_0_, this_.flowreport AS flowrep35_26_0_, this_.created AS created36_26_0_, this_.createdby AS created37_26_0_, this_.updated AS updated38_26_0_, this_.note AS note39_26_0_ FROM order_rounds this_ WHERE this_.created BETWEEN '' AND '' AND this_.status <> '';Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 20 4 237ms 59ms [ User: pharmisight - Total duration: 237ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 237ms - Times executed: 4 ]
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-21 00:00:00' AND '2018-10-22 00:00:00' AND this_.status <> 'Quarantine';
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-19 00:00:00' AND '2018-10-20 00:00:00' AND this_.status <> 'Quarantine';
-
SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_26_0_, this_.routeNumber AS routeNum2_26_0_, this_.uploadedByUserId AS uploaded3_26_0_, this_.uploadedByUserName AS uploaded4_26_0_, this_.updatedBy AS updatedB5_26_0_, this_.updatedByUserName AS updatedB6_26_0_, this_.orderRoundNote AS orderRou7_26_0_, this_.firstCheckOut AS firstChe8_26_0_, this_.allOrdersScannedOK AS allOrder9_26_0_, this_.status AS status10_26_0_, this_.reopenedTimes AS reopene11_26_0_, this_.lastReopenById AS lastReo12_26_0_, this_.lastDoneCheckIn AS lastDon13_26_0_, this_.lastDoneById AS lastDon14_26_0_, this_.lastDoneByUserName AS lastDon15_26_0_, this_.missingLabels AS missing16_26_0_, this_.roundDeliveryDate AS roundDe17_26_0_, this_.trolley AS trolley18_26_0_, this_.stack AS stack19_26_0_, this_.picktime AS picktim20_26_0_, this_.uploadUpdated AS uploadU21_26_0_, this_.patientAlert AS patient22_26_0_, this_.mismatches AS mismatc23_26_0_, this_.rxStatus AS rxStatu24_26_0_, this_.distributionPoint AS distrib25_26_0_, this_.audited AS audited26_26_0_, this_.auditedBy AS audited27_26_0_, this_.auditStatus AS auditSt28_26_0_, this_.uploadFinished AS uploadF29_26_0_, this_.lastRxCompleted AS lastRxC30_26_0_, this_.lastRxCompletedBy AS lastRxC31_26_0_, this_.orderRoundNoteReadBy AS orderRo32_26_0_, this_.routeOrderLinesQty AS routeOr33_26_0_, this_.dlxPickedLinesQty AS dlxPick34_26_0_, this_.flowReport AS flowRep35_26_0_, this_.CREATED AS CREATED36_26_0_, this_.createdBy AS created37_26_0_, this_.UPDATED AS UPDATED38_26_0_, this_.note AS note39_26_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-10-20 00:00:00' AND '2018-10-21 00:00:00' AND this_.status <> 'Quarantine';
Date: 2018-10-21 20:00:30 Duration: 171ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:31 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:30 Duration: 25ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 11ms 12ms 11ms 55 659ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 19 7 84ms 12ms 20 12 143ms 11ms 21 12 144ms 12ms 22 12 143ms 11ms 23 12 143ms 11ms [ User: tony - Total duration: 659ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 659ms - Times executed: 55 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-10-21 19:26:20 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-10-21 21:41:20 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-10-21 20:20:44 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
5 0ms 83ms 7ms 120 914ms 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 #5
Day Hour Count Duration Avg duration Oct 21 20 120 914ms 7ms [ User: pharmisight - Total duration: 914ms - Times executed: 120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 914ms - Times executed: 120 ]
-
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 = '200483362' 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 = '200482782' 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 = '200483372' ORDER BY orderlines0_.lastName, orderlines0_.partCode ASC;
Date: 2018-10-21 20:00:33 Duration: 83ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:38 Duration: 71ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:32 Duration: 61ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 3ms 23ms 5ms 315 1s596ms 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 Oct 21 19 300 1s463ms 4ms 20 6 53ms 8ms 21 3 26ms 8ms 22 3 26ms 8ms 23 3 26ms 8ms [ User: symmetricds - Total duration: 1s206ms - Times executed: 229 ]
[ User: pharmisight - Total duration: 389ms - Times executed: 86 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s596ms - Times executed: 315 ]
-
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 = 'alerts' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_rounds' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-10-21 19:23:05 Duration: 23ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:17 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:36 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 34ms 3ms 389 1s185ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 21 20 9 87ms 9ms 21 143 491ms 3ms 22 94 292ms 3ms 23 143 314ms 2ms [ User: pharmisight - Total duration: 1s185ms - Times executed: 389 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s185ms - Times executed: 389 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004674284', '2018-10-21 20:24:58', 'BARTCZAKM', '2018-10-21 20:40:01.993', '41107', '24', '31237090307184001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004666797', '2018-10-21 21:38:52', 'BARTCZAKM', '2018-10-21 22:00:00.066', '88664', '6', '31237090307220007');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004668954', '2018-10-21 20:31:15', 'BARTCZAKM', '2018-10-21 21:00:00.082', '63953', '30', '31237090307193001');
Date: 2018-10-21 20:40:02 Duration: 34ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 22:00:00 Duration: 27ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:00:00 Duration: 25ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 33ms 2ms 116 284ms SELECT orders0_.order_round_id AS order_r42_26_0_, orders0_.order_id AS order_id1_20_0_, orders0_.order_id AS order_id1_20_1_, orders0_.sapordernumber AS saporder2_20_1_, orders0_.answerordernumber AS answeror3_20_1_, orders0_.ordernumber AS ordernum4_20_1_, orders0_.routenumber AS routenum5_20_1_, orders0_.billtotype AS billtoty6_20_1_, orders0_.patientname AS patientn7_20_1_, orders0_.firstname AS firstnam8_20_1_, orders0_.middlename AS middlena9_20_1_, orders0_.lastname AS lastnam10_20_1_, orders0_.patientdateofbirth AS patient11_20_1_, orders0_.patientpostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapcustomerid AS sapcust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientid AS patient16_20_1_, orders0_.isnotwithinage AS isnotwi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliverybarcode AS deliver20_20_1_, orders0_.deliverydate AS deliver21_20_1_, orders0_.rxstatus AS rxstatu22_20_1_, orders0_.createuser AS createu23_20_1_, orders0_.subordertype AS suborde24_20_1_, orders0_.sapcontractid AS sapcont25_20_1_, orders0_.salesforceordernumber AS salesfo26_20_1_, orders0_.patienttype AS patient27_20_1_, orders0_.ordertype AS orderty28_20_1_, orders0_.orderstatus AS orderst29_20_1_, orders0_.nhsnumber AS nhsnumb30_20_1_, orders0_.individuallabelling AS individ31_20_1_, orders0_.orderid AS orderid32_20_1_, orders0_.clusterlead AS cluster33_20_1_, orders0_.clustergroup AS cluster34_20_1_, orders0_.accountid AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionby AS reducti37_20_1_, orders0_.alertconfirmation AS alertco38_20_1_, orders0_.created AS created39_20_1_, orders0_.updated AS updated40_20_1_, orders0_.note AS note41_20_1_ FROM orders orders0_ WHERE orders0_.order_round_id = '' ORDER BY orders0_.order_id ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 21 20 116 284ms 2ms [ User: pharmisight - Total duration: 284ms - Times executed: 116 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 284ms - Times executed: 116 ]
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200482212' ORDER BY orders0_.order_id ASC;
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200483542' ORDER BY orders0_.order_id ASC;
-
SELECT orders0_.ORDER_ROUND_ID AS ORDER_R42_26_0_, orders0_.ORDER_ID AS ORDER_ID1_20_0_, orders0_.ORDER_ID AS ORDER_ID1_20_1_, orders0_.sapOrderNumber AS sapOrder2_20_1_, orders0_.answerOrderNumber AS answerOr3_20_1_, orders0_.orderNumber AS orderNum4_20_1_, orders0_.routeNumber AS routeNum5_20_1_, orders0_.billToType AS billToTy6_20_1_, orders0_.patientName AS patientN7_20_1_, orders0_.firstName AS firstNam8_20_1_, orders0_.middleName AS middleNa9_20_1_, orders0_.lastName AS lastNam10_20_1_, orders0_.patientDateOfBirth AS patient11_20_1_, orders0_.patientPostcode AS patient12_20_1_, orders0_.customer AS custome13_20_1_, orders0_.sapCustomerId AS sapCust14_20_1_, orders0_.status AS status15_20_1_, orders0_.patientId AS patient16_20_1_, orders0_.isNotWithinAge AS isNotWi17_20_1_, orders0_.expired AS expired18_20_1_, orders0_.paperwork AS paperwo19_20_1_, orders0_.deliveryBarcode AS deliver20_20_1_, orders0_.deliveryDate AS deliver21_20_1_, orders0_.rxStatus AS rxStatu22_20_1_, orders0_.createUser AS createU23_20_1_, orders0_.subOrderType AS subOrde24_20_1_, orders0_.sapContractId AS sapCont25_20_1_, orders0_.salesforceOrderNumber AS salesfo26_20_1_, orders0_.patientType AS patient27_20_1_, orders0_.orderType AS orderTy28_20_1_, orders0_.orderStatus AS orderSt29_20_1_, orders0_.NHSnumber AS NHSnumb30_20_1_, orders0_.individualLabelling AS individ31_20_1_, orders0_.orderId AS orderId32_20_1_, orders0_.clusterLead AS cluster33_20_1_, orders0_.clusterGroup AS cluster34_20_1_, orders0_.accountId AS account35_20_1_, orders0_.reduction AS reducti36_20_1_, orders0_.reductionBy AS reducti37_20_1_, orders0_.alertConfirmation AS alertCo38_20_1_, orders0_.CREATED AS CREATED39_20_1_, orders0_.UPDATED AS UPDATED40_20_1_, orders0_.note AS note41_20_1_ FROM ORDERS orders0_ WHERE orders0_.ORDER_ROUND_ID = '200484382' ORDER BY orders0_.order_id ASC;
Date: 2018-10-21 20:00:35 Duration: 33ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:33 Duration: 20ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:31 Duration: 19ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1ms 4ms 2ms 229 526ms 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 #9
Day Hour Count Duration Avg duration Oct 21 19 214 470ms 2ms 20 6 22ms 3ms 21 3 10ms 3ms 22 3 10ms 3ms 23 3 11ms 3ms [ User: symmetricds - Total duration: 526ms - Times executed: 229 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 526ms - Times executed: 229 ]
-
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 = 'order_rounds' 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 = 'order_round_activities' 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;
Date: 2018-10-21 20:00:36 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:00:36 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:28:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 24ms 1ms 297 536ms UPDATE "public"."sym_node_host" SET "ip_address" = '', "os_user" = '', "os_name" = '', "os_arch" = '', "os_version" = '', "available_processors" = '', "free_memory_bytes" = '', "total_memory_bytes" = '', "max_memory_bytes" = '', "java_version" = '', "java_vendor" = '', "symmetric_version" = '', "timezone_offset" = '', "heartbeat_time" = '', "last_restart_time" = '', "create_time" = '', "jdbc_version" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 19 266 343ms 1ms 20 7 51ms 7ms 21 8 49ms 6ms 22 8 48ms 6ms 23 8 44ms 5ms [ User: symmetricds - Total duration: 536ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 536ms - Times executed: 297 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '279705992', "total_memory_bytes" = '534249472', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 14:34:50', "last_restart_time" = '2018-09-04 16:05:59', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '216067168', "total_memory_bytes" = '525336576', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 15:35:59', "last_restart_time" = '2018-09-06 13:12:42.532', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '328429672', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-10-21 19:34:50', "last_restart_time" = '2018-09-04 16:05:59', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2018-10-21 19:25:43 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:25:44 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:35:42 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 15ms 0ms 744 444ms UPDATE "public"."patients" SET "caloriesday" = '' WHERE "patient_id" = '';Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 19 744 444ms 0ms [ User: symmetricds - Total duration: 444ms - Times executed: 744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 444ms - Times executed: 744 ]
-
UPDATE "public"."patients" SET "caloriesday" = '1339' WHERE "patient_id" = '200083690';
-
UPDATE "public"."patients" SET "caloriesday" = '1186' WHERE "patient_id" = '200350840';
-
UPDATE "public"."patients" SET "caloriesday" = '386' WHERE "patient_id" = '168309';
Date: 2018-10-21 19:23:56 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:56 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 7ms 0ms 1,102 247ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 21 19 143 39ms 0ms 20 234 50ms 0ms 21 240 54ms 0ms 22 243 53ms 0ms 23 242 49ms 0ms [ User: symmetricds - Total duration: 247ms - Times executed: 1102 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 247ms - Times executed: 1102 ]
-
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 = '3' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '1' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-10-21 19:23:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:34:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:01:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 0ms 0ms 1,104 170ms 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 #13
Day Hour Count Duration Avg duration Oct 21 19 144 23ms 0ms 20 240 35ms 0ms 21 240 36ms 0ms 22 240 37ms 0ms 23 240 37ms 0ms [ User: symmetricds - Total duration: 170ms - Times executed: 1104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 170ms - Times executed: 1104 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 23:07:07.597', last_lock_time = '2018-10-21 23:07:07.597' WHERE node_id = '0' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 21:07:07.597');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 20:27:03.596', last_lock_time = '2018-10-21 20:27:03.596' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 18:27:03.596');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-10-21 19:47:02.592', last_lock_time = '2018-10-21 19:47:02.592' WHERE node_id = '2' AND communication_type = 'FILE_PUSH' AND (lock_time IS NULL OR lock_time < '2018-10-21 17:47:02.592');
Date: 2018-10-21 23:07:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:27:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:47:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 20ms 0ms 1,368 172ms 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 #14
Day Hour Count Duration Avg duration Oct 21 19 180 41ms 0ms 20 288 26ms 0ms 21 300 30ms 0ms 22 300 35ms 0ms 23 300 38ms 0ms [ User: symmetricds - Total duration: 172ms - Times executed: 1368 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 172ms - Times executed: 1368 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-10-21 19:23:24 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:24 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 22ms 0ms 1,737 157ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('', '', '', current_timestamp);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 21 19 810 92ms 0ms 20 59 5ms 0ms 21 322 20ms 0ms 22 224 16ms 0ms 23 322 21ms 0ms [ User: symmetricds - Total duration: 157ms - Times executed: 1737 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 157ms - Times executed: 1737 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765243', '8114734', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765029', '8114728', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('90765120', '8114730', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
Date: 2018-10-21 19:25:46 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:55 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:24:05 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 1,104 78ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 19 144 11ms 0ms 20 240 16ms 0ms 21 240 16ms 0ms 22 240 17ms 0ms 23 240 16ms 0ms [ User: symmetricds - Total duration: 78ms - Times executed: 1104 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 78ms - Times executed: 1104 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
Date: 2018-10-21 22:39:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:54:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:18:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 1,642 108ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 21 19 212 12ms 0ms 20 358 30ms 0ms 21 357 22ms 0ms 22 358 22ms 0ms 23 357 21ms 0ms [ User: symmetricds - Total duration: 108ms - Times executed: 1642 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 108ms - Times executed: 1642 ]
-
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-10-21 19:23:23 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:55:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:12:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 8ms 0ms 2,198 143ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 19 290 25ms 0ms 20 468 28ms 0ms 21 480 31ms 0ms 22 480 28ms 0ms 23 480 29ms 0ms [ User: symmetricds - Total duration: 143ms - Times executed: 2198 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 143ms - Times executed: 2198 ]
-
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-10-21 19:23:14 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:18:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 21:41:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 1,643 96ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '' AND data_id <= '' ORDER BY data_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 19 213 6ms 0ms 20 358 39ms 0ms 21 357 32ms 0ms 22 358 9ms 0ms 23 357 9ms 0ms [ User: symmetricds - Total duration: 96ms - Times executed: 1643 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 96ms - Times executed: 1643 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765021' AND data_id <= '140765020' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765601' AND data_id <= '140765600' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '90765297' AND data_id <= '140765296' ORDER BY data_id ASC;
Date: 2018-10-21 19:23:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 23:20:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 20:20:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 13ms 0ms 6,146 361ms 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 #20
Day Hour Count Duration Avg duration Oct 21 19 2,634 133ms 0ms 20 878 68ms 0ms 21 878 64ms 0ms 22 878 46ms 0ms 23 878 49ms 0ms [ User: pharmisight - Total duration: 361ms - Times executed: 6146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 361ms - Times executed: 6146 ]
-
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;
-
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 = '2' 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 = '8' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-10-21 19:23:08 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:07 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-10-21 19:23:08 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 1,340,352 Log entries
Events distribution
Key values
- 0 PANIC entries
- 5 FATAL entries
- 3 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 8 Total events found
Rank Times reported Error 1 5 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 21 19 5 - FATAL: the database system is starting up
Date: 2018-10-21 19:23:01 Database: pharmisight Application: [unknown] User: pharmisight Remote: 10.10.10.1 Code:
2 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 21 19 2 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-10-21 19:23:10 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code:
3 1 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 21 19 1 - LOG: database system was not properly shut down; automatic recovery in progress
Date: 2018-10-21 19:23:01