pgBadger-
Global information
- Generated on Sun Jul 29 00:00:21 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 2,156,923 log entries in 18s
- Log start from 2018-07-28 00:00:00 to 2018-07-28 23:59:59
-
Overview
Global Stats
- 145 Number of unique normalized queries
- 735,362 Number of queries
- 29s862ms Total query duration
- 2018-07-28 00:00:00 First query
- 2018-07-28 23:59:59 Last query
- 2,038 queries/s at 2018-07-28 23:13:27 Query peak
- 10 Number of events
- 4 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 82 Total number of automatic vacuums
- 89 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 563 Total number of sessions
- 3 sessions at 2018-07-28 23:13:54 Session peak
- 3d3h56m57s Total duration of sessions
- 8m5s Average duration of sessions
- 1,306 Average queries per session
- 53ms Average queries duration per session
- 573 Total number of connections
- 7 connections/s at 2018-07-28 23:12:51 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2,038 queries/s Query Peak
- 2018-07-28 23:13:27 Date
SELECT Traffic
Key values
- 1,518 queries/s Query Peak
- 2018-07-28 00:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,037 queries/s Query Peak
- 2018-07-28 23:13:27 Date
Queries duration
Key values
- 29s862ms Total query duration
Prepared queries ratio
Key values
- 1.70 Ratio of bind vs prepare
- 161.50 % 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) Jul 28 00 103,412 0ms 27ms 0ms 81ms 185ms 1s916ms 01 94,791 0ms 18ms 0ms 68ms 147ms 383ms 02 93,677 0ms 22ms 0ms 78ms 144ms 306ms 03 93,578 0ms 18ms 0ms 66ms 143ms 308ms 04 93,022 0ms 19ms 0ms 69ms 92ms 279ms 05 92,951 0ms 20ms 0ms 62ms 84ms 278ms 06 74,761 0ms 52ms 0ms 76ms 88ms 335ms 23 89,170 0ms 258ms 0ms 76ms 185ms 3s556ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 00 35,467 0 0ms 30ms 37ms 165ms 01 31,469 0 0ms 33ms 34ms 83ms 02 31,048 0 0ms 34ms 36ms 68ms 03 31,069 0 0ms 32ms 36ms 51ms 04 30,977 0 0ms 29ms 33ms 57ms 05 30,902 0 0ms 29ms 34ms 55ms 06 25,180 0 0ms 28ms 34ms 182ms 23 34,822 0 0ms 30ms 40ms 2s532ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 00 1,018 1,564 105 0 0ms 9ms 15ms 56ms 01 1,392 949 109 0 0ms 1ms 9ms 93ms 02 908 829 109 0 0ms 3ms 10ms 52ms 03 740 785 106 0 0ms 2ms 9ms 49ms 04 424 707 108 0 0ms 2ms 8ms 23ms 05 356 690 108 0 0ms 2ms 9ms 26ms 06 90 493 97 0 0ms 1ms 8ms 13ms 23 863 815 253 0 0ms 1ms 9ms 256ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 28 00 61,031 103,376 1.69 93.94% 01 55,910 94,755 1.69 95.73% 02 55,358 93,641 1.69 96.54% 03 55,536 93,542 1.68 97.12% 04 55,297 92,986 1.68 97.57% 05 55,164 92,915 1.68 97.55% 06 44,464 74,731 1.68 97.69% 23 49,648 89,140 1.80 84.83% Day Hour Count Average / Second Jul 28 00 80 0.02/s 01 69 0.02/s 02 65 0.02/s 03 69 0.02/s 04 70 0.02/s 05 64 0.02/s 06 55 0.02/s 23 101 0.03/s Day Hour Count Average Duration Jul 28 00 80 7m53s 01 69 8m29s 02 65 9m12s 03 69 8m35s 04 70 9m5s 05 64 8m43s 06 55 9m25s 23 91 4m46s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2018-07-28 23:12:51 Date
Connections per database
Key values
- pharmisight Main Database
- 573 connections Total
Connections per user
Key values
- symmetricds Main User
- 573 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-07-28 23:13:54 Date
Histogram of session times
Key values
- 309 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 563 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 563 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 563 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,996 buffers Checkpoint Peak
- 2018-07-28 06:05:22 Date
- 149.522 seconds Highest write time
- 0.132 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-07-28 00:07:52 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 Jul 28 00 1,673 167.637s 0.011s 167.691s 01 924 92.72s 0.024s 92.784s 02 745 74.764s 0.013s 74.813s 03 779 78.071s 0.012s 78.125s 04 712 71.43s 0.021s 71.492s 05 648 65.015s 0.021s 65.082s 06 3,329 182.926s 0.013s 182.975s 23 547 54.463s 0.144s 54.654s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 28 00 0 0 1 370 0.002s 0s 01 0 0 0 334 0.008s 0s 02 0 0 0 321 0.002s 0s 03 0 0 1 324 0.001s 0s 04 0 0 0 315 0.008s 0s 05 0 0 0 321 0.008s 0s 06 0 0 1 247 0.002s 0s 23 0 0 0 235 0.132s 0.132s Day Hour Count Avg time (sec) Jul 28 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 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 Jul 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 23 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.39 sec Highest CPU-cost vacuum
Table public.sym_data
Database pharmisight - 2018-07-28 06:00:35 Date
- 4.16 sec Highest CPU-cost analyze
Table public.patients
Database pharmisight - 2018-07-28 00:08:53 Date
Analyzes per table
Key values
- public.sym_node_communication (65) Main table analyzed (database pharmisight)
- 89 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 65 pharmisight.public.sym_incoming_batch 5 pharmisight.public.sym_data_gap 4 pharmisight.public.sym_sequence 3 pharmisight.public.sym_lock 3 pharmisight.public.sym_node_host 2 pharmisight.public.item_codes 2 pharmisight.public.sym_data_event 1 pharmisight.public.sym_outgoing_batch 1 pharmisight.public.sym_node_channel_ctl 1 pharmisight.public.sym_data 1 pharmisight.public.patients 1 Total 89 Vacuums per table
Key values
- public.sym_node_communication (65) Main table vacuumed on database pharmisight
- 82 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 65 0 pharmisight.public.sym_lock 3 0 pharmisight.public.sym_sequence 3 0 pharmisight.public.sym_incoming_batch 3 3 pharmisight.public.sym_node_host 2 0 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.public.sym_data_gap 2 2 pharmisight.public.item_codes 1 1 pharmisight.public.sym_data 1 1 Total 82 7 Tuples removed per table
Key values
- public.sym_data (5992) Main table with removed tuples on database pharmisight
- 11050 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 1 1 5992 0 pharmisight.public.sym_node_communication 65 0 3664 0 pharmisight.public.sym_incoming_batch 3 3 486 0 pharmisight.public.item_codes 1 1 287 0 pharmisight.public.sym_lock 3 0 156 0 pharmisight.public.sym_sequence 3 0 154 0 pharmisight.public.sym_node_channel_ctl 2 0 105 0 pharmisight.public.sym_node_host 2 0 104 0 pharmisight.public.sym_data_gap 2 2 102 0 Total 82 7 11,050 0 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_lock 3 0 156 0 pharmisight.public.sym_sequence 3 0 154 0 pharmisight.public.sym_incoming_batch 3 3 486 0 pharmisight.public.sym_node_host 2 0 104 0 pharmisight.public.item_codes 1 1 287 0 pharmisight.public.sym_node_communication 65 0 3664 0 pharmisight.public.sym_data 1 1 5992 0 pharmisight.public.sym_node_channel_ctl 2 0 105 0 pharmisight.public.sym_data_gap 2 2 102 0 Total 82 7 11,050 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 28 00 14 13 01 12 12 02 9 10 03 11 12 04 9 12 05 12 10 06 8 11 23 7 9 - 6.39 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
- 250,934 Total read queries
- 204,228 Total write queries
Queries by database
Key values
- pharmisight Main database
- 735,359 Requests
- 29s600ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 803,029 Requests
User Request type Count Duration pharmisight Total 26,592 3s250ms INSERT 1,382 899ms OTHERS 696 24ms SELECT 24,212 2s262ms TCL 302 64ms postgres Total 3 262ms SELECT 3 262ms symmetricds Total 803,029 27s776ms DDL 3 80ms DELETE 1,069 1s223ms INSERT 6,437 962ms OTHERS 315,574 5s852ms SELECT 257,394 13s143ms TCL 214,582 4s108ms UPDATE 7,970 2s406ms tony Total 309 1s617ms SELECT 309 1s617ms Duration by user
Key values
- 27s776ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 26,592 3s250ms INSERT 1,382 899ms OTHERS 696 24ms SELECT 24,212 2s262ms TCL 302 64ms postgres Total 3 262ms SELECT 3 262ms symmetricds Total 803,029 27s776ms DDL 3 80ms DELETE 1,069 1s223ms INSERT 6,437 962ms OTHERS 315,574 5s852ms SELECT 257,394 13s143ms TCL 214,582 4s108ms UPDATE 7,970 2s406ms tony Total 309 1s617ms SELECT 309 1s617ms Queries by host
Key values
- 10.10.10.1 Main host
- 829,621 Requests
- 31s27ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 734,607 Requests
- 28s158ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-07-28 23:28:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 732,739 0-1ms duration
Slowest individual queries
Rank Duration Query 1 258ms 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-07-28 23:12:51 - Database: postgres - User: postgres - Remote: [local] - Application: psql ]
2 78ms 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-6-amd64', available_processors = '2', free_memory_bytes = '409526312', total_memory_bytes = '514850816', max_memory_bytes = '1908932608', java_version = '1.8.0_171', java_vendor = 'Oracle Corporation', jdbc_version = '42.0.0', symmetric_version = '3.6.17', timezone_offset = '+01:00', heartbeat_time = '2018-07-28 23:13:09', last_restart_time = '2018-07-28 23:13:09.434' WHERE node_id = '3' AND host_name = 'scancheck';[ Date: 2018-07-28 23:13:09 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 68ms ALTER TABLE "public"."sym_sequence" ALTER COLUMN "max_value" SET DEFAULT 9999999999;[ Date: 2018-07-28 23:13:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 62ms INSERT INTO "public"."dlx_barcodes" ("dlx_barcode", "ordernumber", "pickdatetime", "picker", "created", "partcode", "orderqty") ( SELECT '150505230120439547', '5004289201', '2018-07-28 09:08:58', 'ALVAREZJ', '2018-07-28 10:20:00.047', '98456', '384' WHERE ( SELECT DISTINCT 1 FROM "public"."dlx_barcodes" WHERE "dlx_barcode" = '150505230120439547') IS NULL);[ Date: 2018-07-28 23:13:27 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 59ms 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_channel') c WHERE TRUE ORDER BY nspname, c.relname, attnum;[ Date: 2018-07-28 23:12:59 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 52ms DELETE FROM sym_data WHERE data_id BETWEEN '86751186' AND '86756186' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-07-28 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 41ms INSERT INTO sym_incoming_batch (batch_id, node_id, channel_id, STATUS, network_millis, filter_millis, database_millis, failed_row_number, failed_line_number, byte_count, statement_count, fallback_insert_count, fallback_update_count, ignore_count, missing_delete_count, skip_count, sql_state, sql_code, sql_message, last_update_hostname, last_update_time, create_time) VALUES ('3778015', '0', 'heartbeat', 'LD', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, '0', NULL, 'scancheck', '2018-07-28 23:13:23.989', current_timestamp);[ Date: 2018-07-28 23:13:24 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 38ms DELETE FROM sym_data WHERE data_id BETWEEN '86756187' AND '86761187' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-07-28 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 34ms SELECT this_.ITEM_ID AS ITEM_ID1_13_0_, this_.dmdCode AS dmdCode2_13_0_, this_.description AS descript3_13_0_, this_.alias AS alias4_13_0_, this_.status AS status5_13_0_, this_.ageFrom AS ageFrom6_13_0_, this_.ageTo AS ageTo7_13_0_, this_.ageFromMonths AS ageFromM8_13_0_, this_.specialCare AS specialC9_13_0_, this_.extraProcedure AS extraPr10_13_0_, this_.averageQty AS average11_13_0_, this_.nutrition AS nutriti12_13_0_, this_.pack_calories AS pack_ca13_13_0_, this_.isItemAlert AS isItemA14_13_0_, this_.isMetabolic AS isMetab15_13_0_, this_.created AS created16_13_0_, this_.createdBy AS created17_13_0_, this_.updated AS updated18_13_0_, this_.updatedBy AS updated19_13_0_, this_.note AS note20_13_0_, this_.snomed AS snomed21_13_0_, this_.packSize AS packSiz22_13_0_, this_.unitOfMeasure AS unitOfM23_13_0_, this_.category AS categor24_13_0_, this_.is_unflavoured AS is_unfl25_13_0_, this_.unflavoured AS unflavo26_13_0_, this_.unitecode AS uniteco27_13_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2018-07-28 23:12:56 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 33ms SELECT count (*) FROM information_schema.routines WHERE routine_name = 'sym_triggers_disabled' AND specific_schema = 'public';[ Date: 2018-07-28 23:13:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 33ms DELETE FROM sym_data WHERE data_id BETWEEN '86761188' AND '86766188' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-07-28 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 27ms SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_load_filter' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;[ Date: 2018-07-28 00:00:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 27ms DELETE FROM sym_data WHERE data_id BETWEEN '86749240' AND '86754240' AND create_time < '2018-07-27 00:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86749240' AND '86754240') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86749240' AND '86754240' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-07-28 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 27ms INSERT INTO "public"."item_codes" ("item_code_id", "code", "itemcodetype", "item_id", "isprimary", "status", "created", "createdby", "updated", "updatedby", "note") ( SELECT '106811761', 'AEF044a', 'NCODE', '3248', 'f', 'ACTIVE', '2018-07-28 07:00:04.671763', NULL, '2018-07-28 07:00:08.8893', NULL, NULL WHERE ( SELECT DISTINCT 1 FROM "public"."item_codes" WHERE "item_code_id" = '106811761') IS NULL);[ Date: 2018-07-28 23:13:26 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 24ms SELECT sequence_name, current_value, increment_by, min_value, max_value, CYCLE, create_time, last_update_by, last_update_time FROM sym_sequence;[ Date: 2018-07-28 23:13:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 22ms DELETE FROM sym_data WHERE data_id BETWEEN '86749914' AND '86754914' AND create_time < '2018-07-27 02:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86749914' AND '86754914') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86749914' AND '86754914' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-07-28 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 22ms INSERT INTO sym_data_gap (STATUS, last_update_hostname, start_id, end_id, last_update_time, create_time) VALUES ('GP', 'scancheck', '86811437', '136811436', current_timestamp, current_timestamp);[ Date: 2018-07-28 23:13:20 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 21ms 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;[ Date: 2018-07-28 23:12:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 20ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811436', '7799703', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);[ Date: 2018-07-28 23:13:10 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 20ms SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'p' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'p' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series (1, 32) pos (n), pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey [ pos.n ] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey [ pos.n ] AND con.conrelid = fkc.oid AND con.contype = 'f' AND pkic.relkind = 'i' AND pkic.oid = con.conindid AND fkn.nspname = 'public' AND fkc.relname = 'alerts' ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n;[ Date: 2018-07-28 23:12:54 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s159ms 279,242 0ms 1ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 38,308 694ms 0ms 01 36,276 680ms 0ms 02 36,227 677ms 0ms 03 36,280 675ms 0ms 04 36,234 659ms 0ms 05 36,297 668ms 0ms 06 29,155 547ms 0ms 23 30,465 556ms 0ms [ User: symmetricds - Total duration: 5s150ms - Times executed: 279034 ]
[ User: pharmisight - Total duration: 9ms - Times executed: 208 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s159ms - Times executed: 279242 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-07-28 03:54:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:58:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:48:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 3s141ms 95,302 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 00 13,407 624ms 0ms 01 12,241 329ms 0ms 02 12,225 342ms 0ms 03 12,242 312ms 0ms 04 12,228 330ms 0ms 05 12,247 340ms 0ms 06 9,828 281ms 0ms 23 10,884 580ms 0ms [ User: symmetricds - Total duration: 3s98ms - Times executed: 95162 ]
[ User: pharmisight - Total duration: 43ms - Times executed: 140 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s141ms - Times executed: 95302 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-07-28 23:28:56 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:35 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:16:53 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2s699ms 486 3ms 27ms 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 Jul 28 00 167 907ms 5ms 01 4 19ms 4ms 02 3 27ms 9ms 03 3 18ms 6ms 04 4 23ms 5ms 05 3 18ms 6ms 06 3 24ms 8ms 23 299 1s660ms 5ms [ User: symmetricds - Total duration: 2s220ms - Times executed: 400 ]
[ User: pharmisight - Total duration: 479ms - Times executed: 86 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s699ms - Times executed: 486 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_load_filter' 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 = '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;
Date: 2018-07-28 00:00:01 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:54 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:43 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1s577ms 125,500 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 00 17,746 216ms 0ms 01 16,092 202ms 0ms 02 16,063 204ms 0ms 03 16,085 200ms 0ms 04 16,063 203ms 0ms 05 16,094 203ms 0ms 06 12,930 165ms 0ms 23 14,427 180ms 0ms [ User: symmetricds - Total duration: 1s577ms - Times executed: 125500 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s577ms - Times executed: 125500 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-07-28 02:22:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:30:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:06:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s147ms 24,399 0ms 2ms 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 Jul 28 00 3,204 149ms 0ms 01 3,222 149ms 0ms 02 3,213 153ms 0ms 03 3,222 151ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 2,592 123ms 0ms 23 2,511 119ms 0ms [ User: symmetricds - Total duration: 1s147ms - Times executed: 24399 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s147ms - Times executed: 24399 ]
-
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-07-28 23:13:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:21:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:18:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s111ms 91 11ms 12ms 12ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 00 12 145ms 12ms 01 12 148ms 12ms 02 12 147ms 12ms 03 12 146ms 12ms 04 12 147ms 12ms 05 12 146ms 12ms 06 10 122ms 12ms 23 9 107ms 11ms [ User: tony - Total duration: 1s111ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 1s111ms - Times executed: 91 ]
-
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-07-28 06:16:12 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-07-28 04:06:00 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-07-28 03:26:12 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
7 964ms 400 1ms 6ms 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 #7
Day Hour Count Duration Avg duration Jul 28 00 167 394ms 2ms 01 4 7ms 1ms 02 3 11ms 3ms 03 3 7ms 2ms 04 4 9ms 2ms 05 3 7ms 2ms 06 3 9ms 3ms 23 213 516ms 2ms [ User: symmetricds - Total duration: 964ms - Times executed: 400 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 964ms - Times executed: 400 ]
-
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_transform_table' 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_load_filter' 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_conflict' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2018-07-28 00:00:00 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:00:01 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 705ms 1,020 0ms 15ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 28 00 189 118ms 0ms 01 323 206ms 0ms 02 202 129ms 0ms 03 160 112ms 0ms 04 81 73ms 0ms 05 64 57ms 0ms 06 1 7ms 7ms [ User: pharmisight - Total duration: 705ms - Times executed: 1020 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 705ms - Times executed: 1020 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004295015', '2018-07-28 02:36:29', 'KWAPIENM', '2018-07-28 03:00:00.224', '88665', '6', '31237090277491001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004299296', '2018-07-28 03:36:21', 'BULZC', '2018-07-28 04:00:00.042', '49225', '18', '31237090277479004');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004292276', '2018-07-28 00:32:59', 'RYBAKJ', '2018-07-28 01:00:00.043', '132210', '12', '31237090277239001');
Date: 2018-07-28 03:00:00 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:00:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 693ms 91 0ms 52ms 7ms 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 Jul 28 00 13 93ms 7ms 01 13 83ms 6ms 02 13 87ms 6ms 03 13 83ms 6ms 04 13 85ms 6ms 05 13 85ms 6ms 06 13 173ms 13ms [ User: symmetricds - Total duration: 693ms - Times executed: 91 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 693ms - Times executed: 91 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '86751186' AND '86756186' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186' 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 '86756187' AND '86761187' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187' 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 '86761188' AND '86766188' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-07-28 06:00:00 Duration: 52ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:00 Duration: 38ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:00 Duration: 33ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 613ms 95,303 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 00 13,406 83ms 0ms 01 12,241 79ms 0ms 02 12,225 78ms 0ms 03 12,242 77ms 0ms 04 12,228 78ms 0ms 05 12,247 80ms 0ms 06 9,828 66ms 0ms 23 10,886 69ms 0ms [ User: symmetricds - Total duration: 612ms - Times executed: 95161 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 95303 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-07-28 05:13:36 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:08:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:36:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 546ms 9,860 0ms 6ms 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 #11
Day Hour Count Duration Avg duration Jul 28 00 986 56ms 0ms 01 986 59ms 0ms 02 986 57ms 0ms 03 986 56ms 0ms 04 986 58ms 0ms 05 986 56ms 0ms 06 986 57ms 0ms 23 2,958 141ms 0ms [ User: pharmisight - Total duration: 546ms - Times executed: 9860 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 546ms - Times executed: 9860 ]
-
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;
-
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 = '1' 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 = '43' ORDER BY itemcodes0_.code ASC;
Date: 2018-07-28 23:12:57 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:57 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 527ms 21,691 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 #12
Day Hour Count Duration Avg duration Jul 28 00 2,848 69ms 0ms 01 2,866 70ms 0ms 02 2,856 69ms 0ms 03 2,864 69ms 0ms 04 2,856 69ms 0ms 05 2,864 69ms 0ms 06 2,304 55ms 0ms 23 2,233 53ms 0ms [ User: symmetricds - Total duration: 527ms - Times executed: 21691 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 527ms - Times executed: 21691 ]
-
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 '86811437' AND '136811436')) 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 '86810720' AND '136810719')) 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 '86810534' AND '136810533')) ORDER BY d.data_id ASC;
Date: 2018-07-28 23:13:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:40:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:00:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 506ms 189 0ms 11ms 2ms 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 #13
Day Hour Count Duration Avg duration Jul 28 00 8 55ms 6ms 01 8 52ms 6ms 02 8 51ms 6ms 03 8 56ms 7ms 04 8 37ms 4ms 05 8 49ms 6ms 06 7 44ms 6ms 23 134 158ms 1ms [ User: symmetricds - Total duration: 506ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 506ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '328445160', "total_memory_bytes" = '532676608', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 02:37:06', "last_restart_time" = '2018-07-11 21:16:49', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '362807456', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 08:22:07', "last_restart_time" = '2018-07-11 21:16:49', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '374099568', "total_memory_bytes" = '533200896', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 03:07:06', "last_restart_time" = '2018-07-11 21:16:49', "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-07-28 02:38:02 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:09:05 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 488ms 8,770 0ms 6ms 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 #14
Day Hour Count Duration Avg duration Jul 28 00 877 50ms 0ms 01 877 53ms 0ms 02 877 51ms 0ms 03 877 51ms 0ms 04 877 53ms 0ms 05 877 51ms 0ms 06 877 52ms 0ms 23 2,631 123ms 0ms [ User: pharmisight - Total duration: 488ms - Times executed: 8770 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 488ms - Times executed: 8770 ]
-
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 = '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 = '32964971' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-07-28 23:12:56 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 414ms 1,846 0ms 4ms 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 #15
Day Hour Count Duration Avg duration Jul 28 00 248 54ms 0ms 01 242 54ms 0ms 02 242 53ms 0ms 03 241 53ms 0ms 04 240 49ms 0ms 05 243 57ms 0ms 06 196 45ms 0ms 23 194 45ms 0ms [ User: symmetricds - Total duration: 414ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 414ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '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 = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-07-28 23:13:01 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:47:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:06:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 410ms 18,280 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 #16
Day Hour Count Duration Avg duration Jul 28 00 2,440 52ms 0ms 01 2,400 54ms 0ms 02 2,400 55ms 0ms 03 2,400 51ms 0ms 04 2,400 51ms 0ms 05 2,400 57ms 0ms 06 1,920 44ms 0ms 23 1,920 41ms 0ms [ User: symmetricds - Total duration: 410ms - Times executed: 18280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 410ms - Times executed: 18280 ]
-
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 = 'default';
-
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 = 'default';
-
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 = 'default';
Date: 2018-07-28 01:38:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:09:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:52:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 405ms 91 0ms 5ms 4ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 28 00 13 59ms 4ms 01 13 58ms 4ms 02 13 58ms 4ms 03 13 58ms 4ms 04 13 58ms 4ms 05 13 58ms 4ms 06 13 53ms 4ms [ User: symmetricds - Total duration: 405ms - Times executed: 91 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 405ms - Times executed: 91 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '86766189' AND '86771189' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 06:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86766189' AND '86771189');
-
DELETE FROM sym_data WHERE data_id BETWEEN '86750649' AND '86755649' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 04:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86750649' AND '86755649');
-
DELETE FROM sym_data WHERE data_id BETWEEN '86750872' AND '86755872' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 05:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86750872' AND '86755872');
Date: 2018-07-28 06:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 319ms 218 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 00 29 42ms 1ms 01 30 45ms 1ms 02 28 41ms 1ms 03 29 42ms 1ms 04 28 41ms 1ms 05 27 38ms 1ms 06 23 32ms 1ms 23 24 34ms 1ms [ User: symmetricds - Total duration: 319ms - Times executed: 218 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 319ms - Times executed: 218 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-07-28 01:40:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:26:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:02:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 316ms 287 0ms 3ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 28 00 44 53ms 1ms 01 35 42ms 1ms 02 32 31ms 0ms 03 36 43ms 1ms 04 37 38ms 1ms 05 30 34ms 1ms 06 28 28ms 1ms 23 45 43ms 0ms [ User: symmetricds - Total duration: 316ms - Times executed: 287 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 316ms - Times executed: 287 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-07-28 00:08:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:34:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:16:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 302ms 1,828 0ms 1ms 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 Jul 28 00 244 37ms 0ms 01 240 39ms 0ms 02 240 37ms 0ms 03 240 42ms 0ms 04 240 41ms 0ms 05 240 41ms 0ms 06 192 31ms 0ms 23 192 31ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 1828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 1828 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 03:05:33.168', last_lock_time = '2018-07-28 03:05:33.168' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-28 01:05:33.168');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 06:04:37.804', last_lock_time = '2018-07-28 06:04:37.804' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-28 04:04:37.804');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 01:46:31.116', last_lock_time = '2018-07-28 01:46:31.116' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-27 23:46:31.116');
Date: 2018-07-28 03:05:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:04:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:46:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 279,242 5s159ms 0ms 1ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 38,308 694ms 0ms 01 36,276 680ms 0ms 02 36,227 677ms 0ms 03 36,280 675ms 0ms 04 36,234 659ms 0ms 05 36,297 668ms 0ms 06 29,155 547ms 0ms 23 30,465 556ms 0ms [ User: symmetricds - Total duration: 5s150ms - Times executed: 279034 ]
[ User: pharmisight - Total duration: 9ms - Times executed: 208 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s159ms - Times executed: 279242 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-07-28 03:54:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:58:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:48:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 125,500 1s577ms 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 00 17,746 216ms 0ms 01 16,092 202ms 0ms 02 16,063 204ms 0ms 03 16,085 200ms 0ms 04 16,063 203ms 0ms 05 16,094 203ms 0ms 06 12,930 165ms 0ms 23 14,427 180ms 0ms [ User: symmetricds - Total duration: 1s577ms - Times executed: 125500 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s577ms - Times executed: 125500 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-07-28 02:22:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:30:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:06:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 95,303 613ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 00 13,406 83ms 0ms 01 12,241 79ms 0ms 02 12,225 78ms 0ms 03 12,242 77ms 0ms 04 12,228 78ms 0ms 05 12,247 80ms 0ms 06 9,828 66ms 0ms 23 10,886 69ms 0ms [ User: symmetricds - Total duration: 612ms - Times executed: 95161 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 95303 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-07-28 05:13:36 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:08:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:36:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 95,302 3s141ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 00 13,407 624ms 0ms 01 12,241 329ms 0ms 02 12,225 342ms 0ms 03 12,242 312ms 0ms 04 12,228 330ms 0ms 05 12,247 340ms 0ms 06 9,828 281ms 0ms 23 10,884 580ms 0ms [ User: symmetricds - Total duration: 3s98ms - Times executed: 95162 ]
[ User: pharmisight - Total duration: 43ms - Times executed: 140 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s141ms - Times executed: 95302 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-07-28 23:28:56 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:35 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:16:53 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 24,399 1s147ms 0ms 2ms 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 Jul 28 00 3,204 149ms 0ms 01 3,222 149ms 0ms 02 3,213 153ms 0ms 03 3,222 151ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 2,592 123ms 0ms 23 2,511 119ms 0ms [ User: symmetricds - Total duration: 1s147ms - Times executed: 24399 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s147ms - Times executed: 24399 ]
-
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-07-28 23:13:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:21:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:18:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 21,691 527ms 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 Jul 28 00 2,848 69ms 0ms 01 2,866 70ms 0ms 02 2,856 69ms 0ms 03 2,864 69ms 0ms 04 2,856 69ms 0ms 05 2,864 69ms 0ms 06 2,304 55ms 0ms 23 2,233 53ms 0ms [ User: symmetricds - Total duration: 527ms - Times executed: 21691 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 527ms - Times executed: 21691 ]
-
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 '86811437' AND '136811436')) 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 '86810720' AND '136810719')) 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 '86810534' AND '136810533')) ORDER BY d.data_id ASC;
Date: 2018-07-28 23:13:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:40:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:00:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 18,280 410ms 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 Jul 28 00 2,440 52ms 0ms 01 2,400 54ms 0ms 02 2,400 55ms 0ms 03 2,400 51ms 0ms 04 2,400 51ms 0ms 05 2,400 57ms 0ms 06 1,920 44ms 0ms 23 1,920 41ms 0ms [ User: symmetricds - Total duration: 410ms - Times executed: 18280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 410ms - Times executed: 18280 ]
-
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 = 'default';
-
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 = 'default';
-
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 = 'default';
Date: 2018-07-28 01:38:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:09:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:52:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 9,860 546ms 0ms 6ms 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 Jul 28 00 986 56ms 0ms 01 986 59ms 0ms 02 986 57ms 0ms 03 986 56ms 0ms 04 986 58ms 0ms 05 986 56ms 0ms 06 986 57ms 0ms 23 2,958 141ms 0ms [ User: pharmisight - Total duration: 546ms - Times executed: 9860 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 546ms - Times executed: 9860 ]
-
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;
-
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 = '1' 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 = '43' ORDER BY itemcodes0_.code ASC;
Date: 2018-07-28 23:12:57 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:57 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 8,770 488ms 0ms 6ms 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 Jul 28 00 877 50ms 0ms 01 877 53ms 0ms 02 877 51ms 0ms 03 877 51ms 0ms 04 877 53ms 0ms 05 877 51ms 0ms 06 877 52ms 0ms 23 2,631 123ms 0ms [ User: pharmisight - Total duration: 488ms - Times executed: 8770 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 488ms - Times executed: 8770 ]
-
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 = '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 = '32964971' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-07-28 23:12:56 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 5,133 259ms 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security WHERE node_id = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 00 700 33ms 0ms 01 672 34ms 0ms 02 671 33ms 0ms 03 673 34ms 0ms 04 672 33ms 0ms 05 673 34ms 0ms 06 540 28ms 0ms 23 532 26ms 0ms [ User: symmetricds - Total duration: 259ms - Times executed: 5133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 259ms - Times executed: 5133 ]
-
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-07-28 01:01:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:05:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:48:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 3,659 247ms 0ms 9ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 28 00 489 30ms 0ms 01 480 34ms 0ms 02 480 31ms 0ms 03 480 33ms 0ms 04 480 31ms 0ms 05 480 29ms 0ms 06 384 24ms 0ms 23 386 31ms 0ms [ User: symmetricds - Total duration: 247ms - Times executed: 3659 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 247ms - Times executed: 3659 ]
-
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-07-28 23:13:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:16:33 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:41:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 2,727 94ms 0ms 0ms 0ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 28 00 359 12ms 0ms 01 359 13ms 0ms 02 360 12ms 0ms 03 360 12ms 0ms 04 360 12ms 0ms 05 360 12ms 0ms 06 289 9ms 0ms 23 280 9ms 0ms [ User: symmetricds - Total duration: 94ms - Times executed: 2727 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 94ms - Times executed: 2727 ]
-
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-07-28 01:09:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:21:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:54:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 2,714 65ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '' AND data_id <= '' ORDER BY data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 28 00 356 8ms 0ms 01 360 8ms 0ms 02 357 8ms 0ms 03 358 8ms 0ms 04 357 8ms 0ms 05 358 8ms 0ms 06 288 6ms 0ms 23 280 7ms 0ms [ User: symmetricds - Total duration: 65ms - Times executed: 2714 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 65ms - Times executed: 2714 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '86811436' AND data_id <= '136811435' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '86810720' AND data_id <= '136810719' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '86810402' AND data_id <= '136810401' ORDER BY data_id ASC;
Date: 2018-07-28 23:13:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:40:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:20:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 2,711 156ms 0ms 1ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 28 00 356 19ms 0ms 01 358 20ms 0ms 02 357 20ms 0ms 03 358 20ms 0ms 04 357 20ms 0ms 05 358 21ms 0ms 06 288 16ms 0ms 23 279 17ms 0ms [ User: symmetricds - Total duration: 156ms - Times executed: 2711 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 156ms - Times executed: 2711 ]
-
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-07-28 23:13:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:32:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 2,706 250ms 0ms 20ms 0ms 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 Jul 28 00 414 32ms 0ms 01 682 47ms 0ms 02 440 28ms 0ms 03 356 26ms 0ms 04 198 15ms 0ms 05 164 14ms 0ms 06 35 5ms 0ms 23 417 79ms 0ms [ User: symmetricds - Total duration: 250ms - Times executed: 2706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 250ms - Times executed: 2706 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811436', '7799703', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811469', '7799705', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811483', '7799706', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
Date: 2018-07-28 23:13:10 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:30 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:30 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 2,285 218ms 0ms 1ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 28 00 305 26ms 0ms 01 300 28ms 0ms 02 300 27ms 0ms 03 300 28ms 0ms 04 300 27ms 0ms 05 300 31ms 0ms 06 240 25ms 0ms 23 240 22ms 0ms [ User: symmetricds - Total duration: 218ms - Times executed: 2285 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 218ms - Times executed: 2285 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-07-28 06:15:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:04:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 1,903 73ms 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 #17
Day Hour Count Duration Avg duration Jul 28 00 269 10ms 0ms 01 240 9ms 0ms 02 240 9ms 0ms 03 240 8ms 0ms 04 240 9ms 0ms 05 240 9ms 0ms 06 192 7ms 0ms 23 242 8ms 0ms [ User: symmetricds - Total duration: 73ms - Times executed: 1903 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 73ms - Times executed: 1903 ]
-
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-07-28 04:10:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:16:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:30:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 1,882 61ms 0ms 0ms 0ms SELECT set_config ('', '', FALSE);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 00 710 20ms 0ms 01 60 4ms 0ms 02 60 4ms 0ms 03 60 3ms 0ms 04 60 3ms 0ms 05 60 3ms 0ms 06 48 3ms 0ms 23 824 17ms 0ms [ User: symmetricds - Total duration: 61ms - Times executed: 1882 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 61ms - Times executed: 1882 ]
-
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-07-28 01:46:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:54:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:40:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1,846 414ms 0ms 4ms 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 Jul 28 00 248 54ms 0ms 01 242 54ms 0ms 02 242 53ms 0ms 03 241 53ms 0ms 04 240 49ms 0ms 05 243 57ms 0ms 06 196 45ms 0ms 23 194 45ms 0ms [ User: symmetricds - Total duration: 414ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 414ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '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 = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-07-28 23:13:01 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:47:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:06:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,828 148ms 0ms 0ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 28 00 244 20ms 0ms 01 240 20ms 0ms 02 240 20ms 0ms 03 240 19ms 0ms 04 240 19ms 0ms 05 240 19ms 0ms 06 192 15ms 0ms 23 192 14ms 0ms [ User: symmetricds - Total duration: 148ms - Times executed: 1828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 148ms - Times executed: 1828 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-07-28 05:04:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:47:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:36:29 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 11ms 12ms 12ms 91 1s111ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 00 12 145ms 12ms 01 12 148ms 12ms 02 12 147ms 12ms 03 12 146ms 12ms 04 12 147ms 12ms 05 12 146ms 12ms 06 10 122ms 12ms 23 9 107ms 11ms [ User: tony - Total duration: 1s111ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 1s111ms - Times executed: 91 ]
-
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-07-28 06:16:12 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-07-28 04:06:00 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-07-28 03:26:12 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
2 0ms 52ms 7ms 91 693ms 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 Jul 28 00 13 93ms 7ms 01 13 83ms 6ms 02 13 87ms 6ms 03 13 83ms 6ms 04 13 85ms 6ms 05 13 85ms 6ms 06 13 173ms 13ms [ User: symmetricds - Total duration: 693ms - Times executed: 91 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 693ms - Times executed: 91 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '86751186' AND '86756186' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86751186' AND '86756186' 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 '86756187' AND '86761187' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86756187' AND '86761187' 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 '86761188' AND '86766188' AND create_time < '2018-07-27 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86761188' AND '86766188' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-07-28 06:00:00 Duration: 52ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:00 Duration: 38ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:00:00 Duration: 33ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 27ms 5ms 486 2s699ms 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 Jul 28 00 167 907ms 5ms 01 4 19ms 4ms 02 3 27ms 9ms 03 3 18ms 6ms 04 4 23ms 5ms 05 3 18ms 6ms 06 3 24ms 8ms 23 299 1s660ms 5ms [ User: symmetricds - Total duration: 2s220ms - Times executed: 400 ]
[ User: pharmisight - Total duration: 479ms - Times executed: 86 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s699ms - Times executed: 486 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_load_filter' 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 = '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;
Date: 2018-07-28 00:00:01 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:54 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:43 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 5ms 4ms 91 405ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '');Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 00 13 59ms 4ms 01 13 58ms 4ms 02 13 58ms 4ms 03 13 58ms 4ms 04 13 58ms 4ms 05 13 58ms 4ms 06 13 53ms 4ms [ User: symmetricds - Total duration: 405ms - Times executed: 91 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 405ms - Times executed: 91 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '86766189' AND '86771189' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 06:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86766189' AND '86771189');
-
DELETE FROM sym_data WHERE data_id BETWEEN '86750649' AND '86755649' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 04:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86750649' AND '86755649');
-
DELETE FROM sym_data WHERE data_id BETWEEN '86750872' AND '86755872' AND data_id < ( SELECT min (start_id) FROM sym_data_gap) AND create_time < '2018-07-27 05:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '86750872' AND '86755872');
Date: 2018-07-28 06:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 11ms 2ms 189 506ms 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 #5
Day Hour Count Duration Avg duration Jul 28 00 8 55ms 6ms 01 8 52ms 6ms 02 8 51ms 6ms 03 8 56ms 7ms 04 8 37ms 4ms 05 8 49ms 6ms 06 7 44ms 6ms 23 134 158ms 1ms [ User: symmetricds - Total duration: 506ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 506ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '328445160', "total_memory_bytes" = '532676608', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 02:37:06', "last_restart_time" = '2018-07-11 21:16:49', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '362807456', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 08:22:07', "last_restart_time" = '2018-07-11 21:16:49', "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" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '374099568', "total_memory_bytes" = '533200896', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-07-28 03:07:06', "last_restart_time" = '2018-07-11 21:16:49', "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-07-28 02:38:02 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:09:05 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1ms 6ms 2ms 400 964ms 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 #6
Day Hour Count Duration Avg duration Jul 28 00 167 394ms 2ms 01 4 7ms 1ms 02 3 11ms 3ms 03 3 7ms 2ms 04 4 9ms 2ms 05 3 7ms 2ms 06 3 9ms 3ms 23 213 516ms 2ms [ User: symmetricds - Total duration: 964ms - Times executed: 400 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 964ms - Times executed: 400 ]
-
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_transform_table' 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_load_filter' 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_conflict' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2018-07-28 00:00:00 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:00:01 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 2ms 1ms 218 319ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 28 00 29 42ms 1ms 01 30 45ms 1ms 02 28 41ms 1ms 03 29 42ms 1ms 04 28 41ms 1ms 05 27 38ms 1ms 06 23 32ms 1ms 23 24 34ms 1ms [ User: symmetricds - Total duration: 319ms - Times executed: 218 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 319ms - Times executed: 218 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-07-28 01:40:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:26:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:02:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 1ms 287 316ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 28 00 44 53ms 1ms 01 35 42ms 1ms 02 32 31ms 0ms 03 36 43ms 1ms 04 37 38ms 1ms 05 30 34ms 1ms 06 28 28ms 1ms 23 45 43ms 0ms [ User: symmetricds - Total duration: 316ms - Times executed: 287 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 316ms - Times executed: 287 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS OID, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-07-28 00:08:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:34:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:16:28 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 15ms 0ms 1,020 705ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 28 00 189 118ms 0ms 01 323 206ms 0ms 02 202 129ms 0ms 03 160 112ms 0ms 04 81 73ms 0ms 05 64 57ms 0ms 06 1 7ms 7ms [ User: pharmisight - Total duration: 705ms - Times executed: 1020 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 705ms - Times executed: 1020 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004295015', '2018-07-28 02:36:29', 'KWAPIENM', '2018-07-28 03:00:00.224', '88665', '6', '31237090277491001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004299296', '2018-07-28 03:36:21', 'BULZC', '2018-07-28 04:00:00.042', '49225', '18', '31237090277479004');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004292276', '2018-07-28 00:32:59', 'RYBAKJ', '2018-07-28 01:00:00.043', '132210', '12', '31237090277239001');
Date: 2018-07-28 03:00:00 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:00:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 4ms 0ms 1,846 414ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 00 248 54ms 0ms 01 242 54ms 0ms 02 242 53ms 0ms 03 241 53ms 0ms 04 240 49ms 0ms 05 243 57ms 0ms 06 196 45ms 0ms 23 194 45ms 0ms [ User: symmetricds - Total duration: 414ms - Times executed: 1846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 414ms - Times executed: 1846 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '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 = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-07-28 23:13:01 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:47:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:06:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 1,828 302ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 28 00 244 37ms 0ms 01 240 39ms 0ms 02 240 37ms 0ms 03 240 42ms 0ms 04 240 41ms 0ms 05 240 41ms 0ms 06 192 31ms 0ms 23 192 31ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 1828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 1828 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 03:05:33.168', last_lock_time = '2018-07-28 03:05:33.168' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-28 01:05:33.168');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 06:04:37.804', last_lock_time = '2018-07-28 06:04:37.804' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-28 04:04:37.804');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-07-28 01:46:31.116', last_lock_time = '2018-07-28 01:46:31.116' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-07-27 23:46:31.116');
Date: 2018-07-28 03:05:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:04:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:46:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 1ms 0ms 2,285 218ms 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 #12
Day Hour Count Duration Avg duration Jul 28 00 305 26ms 0ms 01 300 28ms 0ms 02 300 27ms 0ms 03 300 28ms 0ms 04 300 27ms 0ms 05 300 31ms 0ms 06 240 25ms 0ms 23 240 22ms 0ms [ User: symmetricds - Total duration: 218ms - Times executed: 2285 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 218ms - Times executed: 2285 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '2' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-07-28 06:15:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:04:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 20ms 0ms 2,706 250ms 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 Jul 28 00 414 32ms 0ms 01 682 47ms 0ms 02 440 28ms 0ms 03 356 26ms 0ms 04 198 15ms 0ms 05 164 14ms 0ms 06 35 5ms 0ms 23 417 79ms 0ms [ User: symmetricds - Total duration: 250ms - Times executed: 2706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 250ms - Times executed: 2706 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811436', '7799703', 'sym_nd_hst_rddtch_2_bnkstrt', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811469', '7799705', 'sym_nd_hst_rddtch_2_wrndn', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('86811483', '7799706', 'sym_nd_hst_rddtch_2_cld', current_timestamp);
Date: 2018-07-28 23:13:10 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:30 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:30 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 1,828 148ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 28 00 244 20ms 0ms 01 240 20ms 0ms 02 240 20ms 0ms 03 240 19ms 0ms 04 240 19ms 0ms 05 240 19ms 0ms 06 192 15ms 0ms 23 192 14ms 0ms [ User: symmetricds - Total duration: 148ms - Times executed: 1828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 148ms - Times executed: 1828 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-07-28 05:04:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 01:47:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 00:36:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 9ms 0ms 3,659 247ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 28 00 489 30ms 0ms 01 480 34ms 0ms 02 480 31ms 0ms 03 480 33ms 0ms 04 480 31ms 0ms 05 480 29ms 0ms 06 384 24ms 0ms 23 386 31ms 0ms [ User: symmetricds - Total duration: 247ms - Times executed: 3659 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 247ms - Times executed: 3659 ]
-
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-07-28 23:13:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 03:16:33 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 04:41:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 2,711 156ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 28 00 356 19ms 0ms 01 358 20ms 0ms 02 357 20ms 0ms 03 358 20ms 0ms 04 357 20ms 0ms 05 358 21ms 0ms 06 288 16ms 0ms 23 279 17ms 0ms [ User: symmetricds - Total duration: 156ms - Times executed: 2711 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 156ms - Times executed: 2711 ]
-
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-07-28 23:13:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:13:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 05:32:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 6ms 0ms 8,770 488ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 28 00 877 50ms 0ms 01 877 53ms 0ms 02 877 51ms 0ms 03 877 51ms 0ms 04 877 53ms 0ms 05 877 51ms 0ms 06 877 52ms 0ms 23 2,631 123ms 0ms [ User: pharmisight - Total duration: 488ms - Times executed: 8770 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 488ms - Times executed: 8770 ]
-
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 = '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 = '32964971' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-07-28 23:12:56 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 6ms 0ms 9,860 546ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 00 986 56ms 0ms 01 986 59ms 0ms 02 986 57ms 0ms 03 986 56ms 0ms 04 986 58ms 0ms 05 986 56ms 0ms 06 986 57ms 0ms 23 2,958 141ms 0ms [ User: pharmisight - Total duration: 546ms - Times executed: 9860 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 546ms - Times executed: 9860 ]
-
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;
-
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 = '1' 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 = '43' ORDER BY itemcodes0_.code ASC;
Date: 2018-07-28 23:12:57 Duration: 6ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:56 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:12:57 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 5,133 259ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security WHERE node_id = '';Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 28 00 700 33ms 0ms 01 672 34ms 0ms 02 671 33ms 0ms 03 673 34ms 0ms 04 672 33ms 0ms 05 673 34ms 0ms 06 540 28ms 0ms 23 532 26ms 0ms [ User: symmetricds - Total duration: 259ms - Times executed: 5133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 259ms - Times executed: 5133 ]
-
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-07-28 01:01:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 06:05:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 23:48:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 2ms 0ms 24,399 1s147ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 28 00 3,204 149ms 0ms 01 3,222 149ms 0ms 02 3,213 153ms 0ms 03 3,222 151ms 0ms 04 3,213 149ms 0ms 05 3,222 151ms 0ms 06 2,592 123ms 0ms 23 2,511 119ms 0ms [ User: symmetricds - Total duration: 1s147ms - Times executed: 24399 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s147ms - Times executed: 24399 ]
-
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-07-28 23:13:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:21:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-07-28 02:18:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 2,155,688 Log entries
Events distribution
Key values
- 0 PANIC entries
- 5 FATAL entries
- 5 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 10 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 Jul 28 23 5 - FATAL: the database system is starting up
Date: 2018-07-28 23:12:50 Database: pharmisight Application: [unknown] User: pharmisight Remote: 10.10.10.1 Code:
2 3 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 28 00 1 23 2 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-07-28 23:12:57 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code:
3 1 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 28 06 1 - LOG: database system was interrupted; last known up at 2018-07-28 06:47:58 BST
Date: 2018-07-28 06:48:19
4 1 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 28 23 1 - LOG: database system was not properly shut down; automatic recovery in progress
Date: 2018-07-28 23:12:50