pgBadger-
Global information
- Generated on Sun Dec 9 00:00:46 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,627,716 log entries in 44s
- Log start from 2018-12-08 00:00:00 to 2018-12-08 23:59:57
-
Overview
Global Stats
- 193 Number of unique normalized queries
- 2,250,612 Number of queries
- 1m11s Total query duration
- 2018-12-08 00:00:00 First query
- 2018-12-08 23:59:57 Last query
- 1,861 queries/s at 2018-12-08 18:00:02 Query peak
- 41 Number of events
- 3 Number of unique normalized events
- 39 Max number of times the same event was reported
- 0 Number of cancellation
- 277 Total number of automatic vacuums
- 303 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,675 Total number of sessions
- 2 sessions at 2018-12-08 13:11:30 Session peak
- 10d15m57s Total duration of sessions
- 5m23s Average duration of sessions
- 841 Average queries per session
- 26ms Average queries duration per session
- 2,675 Total number of connections
- 5 connections/s at 2018-12-08 00:00:21 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,861 queries/s Query Peak
- 2018-12-08 18:00:02 Date
SELECT Traffic
Key values
- 1,836 queries/s Query Peak
- 2018-12-08 18:00:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 696 queries/s Query Peak
- 2018-12-08 02:00:41 Date
Queries duration
Key values
- 1m11s Total query duration
Prepared queries ratio
Key values
- 1.68 Ratio of bind vs prepare
- 162.59 % 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) Dec 08 00 109,519 0ms 15ms 0ms 93ms 393ms 1s73ms 01 94,743 0ms 22ms 0ms 72ms 221ms 335ms 02 95,276 0ms 17ms 0ms 77ms 125ms 278ms 03 92,978 0ms 17ms 0ms 72ms 77ms 213ms 04 95,568 0ms 19ms 0ms 68ms 221ms 331ms 05 92,805 0ms 16ms 0ms 70ms 74ms 186ms 06 92,615 0ms 15ms 0ms 65ms 78ms 229ms 07 87,598 0ms 138ms 0ms 56ms 78ms 618ms 08 95,141 0ms 55ms 0ms 84ms 205ms 275ms 09 95,689 0ms 56ms 0ms 77ms 149ms 498ms 10 93,863 0ms 55ms 0ms 82ms 208ms 286ms 11 92,982 0ms 95ms 0ms 65ms 72ms 538ms 12 94,679 0ms 78ms 0ms 65ms 191ms 305ms 13 92,770 0ms 42ms 0ms 64ms 76ms 234ms 14 91,924 0ms 35ms 0ms 66ms 79ms 200ms 15 90,619 0ms 33ms 0ms 67ms 79ms 200ms 16 92,221 0ms 40ms 0ms 69ms 78ms 197ms 17 93,910 0ms 15ms 0ms 67ms 76ms 181ms 18 93,687 0ms 30ms 0ms 69ms 81ms 190ms 19 91,708 0ms 14ms 0ms 64ms 84ms 164ms 20 93,346 0ms 42ms 0ms 64ms 202ms 282ms 21 92,213 0ms 13ms 0ms 59ms 72ms 174ms 22 90,964 0ms 21ms 0ms 64ms 91ms 152ms 23 93,794 0ms 20ms 0ms 67ms 76ms 161ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 08 00 39,937 0 0ms 36ms 46ms 353ms 01 32,320 0 0ms 33ms 43ms 124ms 02 32,932 0 0ms 29ms 37ms 90ms 03 31,114 0 0ms 29ms 35ms 62ms 04 32,781 0 0ms 32ms 38ms 111ms 05 31,095 0 0ms 29ms 36ms 41ms 06 30,965 0 0ms 31ms 37ms 47ms 07 29,304 0 0ms 27ms 37ms 49ms 08 32,946 0 0ms 29ms 45ms 160ms 09 32,991 0 0ms 28ms 46ms 134ms 10 32,531 0 0ms 29ms 40ms 141ms 11 32,384 0 0ms 32ms 36ms 160ms 12 32,836 0 0ms 29ms 39ms 139ms 13 32,253 0 0ms 29ms 42ms 142ms 14 30,708 0 0ms 29ms 37ms 47ms 15 30,282 0 0ms 29ms 36ms 45ms 16 30,796 0 0ms 30ms 36ms 46ms 17 32,610 0 0ms 32ms 37ms 130ms 18 32,549 0 0ms 34ms 42ms 125ms 19 31,914 0 0ms 30ms 39ms 135ms 20 32,848 0 0ms 32ms 39ms 243ms 21 30,783 0 0ms 28ms 35ms 47ms 22 31,654 0 0ms 31ms 37ms 129ms 23 32,573 0 0ms 28ms 38ms 71ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 08 00 1,726 2,058 75 0 0ms 11ms 15ms 63ms 01 1,124 874 112 0 0ms 1ms 9ms 42ms 02 1,031 781 110 0 0ms 1ms 8ms 45ms 03 431 584 110 0 0ms 1ms 7ms 28ms 04 1,659 1,007 112 0 0ms 1ms 9ms 92ms 05 324 584 109 0 0ms 1ms 8ms 17ms 06 184 583 109 0 0ms 1ms 8ms 10ms 07 398 619 110 0 0ms 2ms 8ms 15ms 08 492 700 102 0 0ms 1ms 8ms 32ms 09 880 821 100 0 0ms 1ms 9ms 57ms 10 506 718 95 0 0ms 2ms 8ms 37ms 11 225 574 91 0 0ms 1ms 7ms 16ms 12 239 646 92 0 0ms 1ms 8ms 18ms 13 88 573 86 0 0ms 1ms 8ms 10ms 14 88 581 86 0 0ms 1ms 8ms 10ms 15 88 573 83 0 0ms 1ms 8ms 10ms 16 88 583 87 0 0ms 1ms 8ms 10ms 17 88 579 77 0 0ms 1ms 8ms 10ms 18 88 575 81 0 0ms 1ms 8ms 9ms 19 89 581 81 0 0ms 1ms 6ms 9ms 20 114 612 110 0 0ms 1ms 7ms 10ms 21 88 581 81 0 0ms 1ms 7ms 10ms 22 82 555 80 0 0ms 1ms 6ms 10ms 23 88 581 81 0 0ms 1ms 6ms 9ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 08 00 62,522 109,483 1.75 88.07% 01 55,836 94,707 1.70 95.19% 02 55,442 95,240 1.72 93.82% 03 54,808 92,942 1.70 96.84% 04 55,868 95,532 1.71 93.65% 05 56,041 92,769 1.66 99.31% 06 56,140 92,579 1.65 99.92% 07 52,869 87,562 1.66 99.09% 08 56,571 95,105 1.68 96.43% 09 56,721 95,653 1.69 95.75% 10 56,038 93,827 1.67 96.72% 11 55,355 92,946 1.68 96.78% 12 56,605 94,643 1.67 97.23% 13 55,297 92,734 1.68 97.12% 14 56,055 91,888 1.64 100.69% 15 55,153 90,583 1.64 100.48% 16 56,170 92,185 1.64 100.58% 17 55,993 93,874 1.68 97.21% 18 55,863 93,651 1.68 97.20% 19 54,605 91,672 1.68 96.97% 20 55,325 93,310 1.69 96.07% 21 55,868 92,177 1.65 100.07% 22 53,903 90,928 1.69 96.56% 23 55,874 93,758 1.68 97.11% Day Hour Count Average / Second Dec 08 00 109 0.03/s 01 100 0.03/s 02 97 0.03/s 03 88 0.02/s 04 102 0.03/s 05 115 0.03/s 06 115 0.03/s 07 111 0.03/s 08 116 0.03/s 09 113 0.03/s 10 115 0.03/s 11 112 0.03/s 12 118 0.03/s 13 114 0.03/s 14 117 0.03/s 15 115 0.03/s 16 117 0.03/s 17 115 0.03/s 18 116 0.03/s 19 113 0.03/s 20 116 0.03/s 21 114 0.03/s 22 112 0.03/s 23 115 0.03/s Day Hour Count Average Duration Dec 08 00 109 5m40s 01 100 5m55s 02 97 6m16s 03 88 6m43s 04 102 5m56s 05 115 5m15s 06 115 5m13s 07 111 5m23s 08 116 5m12s 09 113 5m15s 10 115 5m18s 11 112 5m10s 12 118 5m10s 13 114 5m18s 14 117 5m3s 15 115 5m15s 16 117 5m9s 17 115 5m13s 18 116 5m9s 19 113 5m12s 20 116 5m15s 21 114 5m17s 22 112 5m21s 23 115 5m8s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2018-12-08 00:00:21 Date
Connections per database
Key values
- pharmisight Main Database
- 2,675 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,675 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2018-12-08 13:11:30 Date
Histogram of session times
Key values
- 2,305 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,675 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,675 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,675 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,481 buffers Checkpoint Peak
- 2018-12-08 07:07:34 Date
- 149.858 seconds Highest write time
- 0.015 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2018-12-08 07:10:06 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 Dec 08 00 1,781 178.576s 0.021s 178.641s 01 1,083 108.556s 0.018s 108.612s 02 1,020 102.338s 0.01s 102.394s 03 805 80.768s 0.039s 80.859s 04 1,245 124.801s 0.021s 124.868s 05 748 75.029s 0.024s 75.093s 06 736 73.834s 0.017s 73.906s 07 8,100 211.948s 0.013s 212.009s 08 1,798 180.255s 0.029s 180.335s 09 3,139 211.212s 0.026s 211.289s 10 1,421 142.029s 0.02s 142.088s 11 1,631 163.505s 0.017s 163.561s 12 1,737 173.451s 0.017s 173.507s 13 580 58.175s 0.013s 58.231s 14 1,383 138.312s 0.024s 138.374s 15 1,257 125.884s 0.017s 125.947s 16 1,089 109.125s 0.017s 109.193s 17 681 68.308s 0.015s 68.365s 18 877 87.854s 0.021s 87.918s 19 655 65.689s 0.016s 65.755s 20 692 69.414s 0.016s 69.472s 21 537 53.871s 0.017s 53.933s 22 678 68.015s 0.017s 68.069s 23 883 88.575s 0.022s 88.634s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 08 00 0 0 1 436 0.004s 0s 01 0 0 0 420 0.002s 0s 02 0 0 1 391 0.002s 0s 03 0 0 0 371 0.010s 0s 04 0 0 0 407 0.008s 0s 05 0 0 0 376 0.008s 0s 06 0 0 1 362 0.002s 0s 07 0 0 3 374 0.002s 0s 08 0 0 0 324 0.008s 0s 09 0 0 1 358 0.008s 0s 10 0 0 1 349 0.008s 0s 11 0 0 0 330 0.002s 0s 12 0 0 1 353 0.002s 0s 13 0 0 0 287 0.002s 0s 14 0 0 1 320 0.008s 0s 15 0 0 0 329 0.003s 0s 16 0 0 0 318 0.004s 0s 17 0 0 0 302 0.002s 0s 18 0 0 1 315 0.008s 0s 19 0 0 0 304 0.002s 0s 20 0 0 0 332 0.002s 0s 21 0 0 0 286 0.002s 0s 22 0 0 0 298 0.003s 0s 23 0 0 0 283 0.009s 0s Day Hour Count Avg time (sec) Dec 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Dec 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.49 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-12-08 07:02:14 Date
- 3.18 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-12-08 04:01:52 Date
Analyzes per table
Key values
- public.sym_node_communication (207) Main table analyzed (database pharmisight)
- 303 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 207 pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data 14 pharmisight.public.sym_data_event 13 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_lock 11 pharmisight.public.sym_sequence 8 pharmisight.public.sym_node_host 5 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_delays 1 Total 303 Vacuums per table
Key values
- public.sym_node_communication (204) Main table vacuumed on database pharmisight
- 277 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 204 0 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_data 10 10 pharmisight.public.sym_sequence 8 0 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.pg_catalog.pg_statistic 2 2 Total 277 46 Tuples removed per table
Key values
- public.sym_data_event (37578) Main table with removed tuples on database pharmisight
- 75833 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 37578 840 pharmisight.public.sym_data 10 10 17730 6578 pharmisight.public.sym_node_communication 204 0 11384 0 pharmisight.public.sym_outgoing_batch 10 10 5468 3 pharmisight.public.sym_incoming_batch 6 6 1252 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.pg_catalog.pg_statistic 2 2 553 0 pharmisight.public.sym_sequence 8 0 413 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.pg_toast.pg_toast_2619 2 2 157 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 Total 277 46 75,833 7,421 Pages removed per table
Key values
- public.sym_data (6578) Main table with removed pages on database pharmisight
- 7421 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 17730 6578 pharmisight.public.sym_data_event 10 10 37578 840 pharmisight.public.sym_outgoing_batch 10 10 5468 3 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_sequence 8 0 413 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_node_communication 204 0 11384 0 pharmisight.public.sym_node_channel_ctl 2 0 107 0 pharmisight.public.sym_incoming_batch 6 6 1252 0 pharmisight.pg_toast.pg_toast_2619 2 2 157 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.pg_catalog.pg_statistic 2 2 553 0 Total 277 46 75,833 7,421 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 08 00 11 14 01 13 11 02 9 12 03 9 10 04 13 13 05 10 9 06 9 11 07 13 14 08 9 14 09 16 16 10 10 11 11 13 15 12 15 14 13 11 10 14 12 14 15 15 14 16 11 13 17 11 14 18 14 11 19 11 14 20 10 13 21 10 10 22 10 15 23 12 11 - 9.49 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
- 773,106 Total read queries
- 610,629 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,250,612 Requests
- 1m11s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,252,393 Requests
User Request type Count Duration pharmisight Total 89,632 6s772ms DELETE 31 3ms INSERT 1,693 863ms OTHERS 3,324 110ms SELECT 83,920 5s728ms TCL 619 58ms UPDATE 45 7ms symmetricds Total 2,252,393 1m3s DDL 1 1ms DELETE 2,338 3s464ms INSERT 9,003 1s473ms OTHERS 899,486 15s701ms SELECT 719,422 28s489ms TCL 604,690 9s548ms UPDATE 17,453 4s823ms tony Total 900 4s613ms SELECT 900 4s613ms Duration by user
Key values
- 1m3s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 89,632 6s772ms DELETE 31 3ms INSERT 1,693 863ms OTHERS 3,324 110ms SELECT 83,920 5s728ms TCL 619 58ms UPDATE 45 7ms symmetricds Total 2,252,393 1m3s DDL 1 1ms DELETE 2,338 3s464ms INSERT 9,003 1s473ms OTHERS 899,486 15s701ms SELECT 719,422 28s489ms TCL 604,690 9s548ms UPDATE 17,453 4s823ms tony Total 900 4s613ms SELECT 900 4s613ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,342,025 Requests
- 1m10s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,247,361 Requests
- 1m7s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-12-08 19:10:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,245,215 0-1ms duration
Slowest individual queries
Rank Duration Query 1 138ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8298795' AND '8299432' AND STATUS != 'OK') AND batch_id BETWEEN '8298795' AND '8299432';[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 95ms DELETE FROM sym_data WHERE data_id BETWEEN '93208237' AND '93213237' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 11:01:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 78ms DELETE FROM sym_data WHERE data_id BETWEEN '93213704' AND '93218704' AND create_time < '2018-12-07 12:02:02.633' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 12:02:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 60ms DELETE FROM sym_data WHERE data_id BETWEEN '93213238' AND '93218238' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 11:01:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 56ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8300094' AND '8300744' AND STATUS != 'OK') AND batch_id BETWEEN '8300094' AND '8300744';[ Date: 2018-12-08 09:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 55ms DELETE FROM sym_data WHERE data_id BETWEEN '93202907' AND '93207907' AND create_time < '2018-12-07 10:01:02.124' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93202907' AND '93207907') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93202907' AND '93207907' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 10:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 55ms DELETE FROM sym_data WHERE data_id BETWEEN '93187564' AND '93192564' AND create_time < '2018-12-07 08:03:35.911' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93187564' AND '93192564') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93187564' AND '93192564' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 08:04:38 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 55ms DELETE FROM sym_data WHERE data_id BETWEEN '93194135' AND '93199135' AND create_time < '2018-12-07 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93194135' AND '93199135') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93194135' AND '93199135' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 09:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 54ms DELETE FROM sym_data WHERE data_id BETWEEN '93199136' AND '93204136' AND create_time < '2018-12-07 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93199136' AND '93204136') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93199136' AND '93204136' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 09:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 53ms DELETE FROM sym_data WHERE data_id BETWEEN '93171125' AND '93176125' AND create_time < '2018-12-07 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93171125' AND '93176125') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93171125' AND '93176125' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 52ms DELETE FROM sym_data WHERE data_id BETWEEN '93218705' AND '93223705' AND create_time < '2018-12-07 12:02:02.633' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93218705' AND '93223705') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93218705' AND '93223705' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 12:02:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 52ms DELETE FROM sym_outgoing_batch WHERE STATUS = 'OK' AND batch_id BETWEEN '8298795' AND '8299432' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '8298795' AND '8299432');[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 44ms DELETE FROM sym_data WHERE data_id BETWEEN '93161123' AND '93166123' AND create_time < '2018-12-07 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93161123' AND '93166123') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93161123' AND '93166123' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 42ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2018-12-08 00:00:00' AND '2018-12-09 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2018-12-08 20:00:59 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 42ms DELETE FROM sym_data WHERE data_id BETWEEN '93220311' AND '93225311' AND create_time < '2018-12-07 13:00:00.898' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93220311' AND '93225311') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93220311' AND '93225311' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 13:00:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 40ms DELETE FROM sym_data WHERE data_id BETWEEN '93166124' AND '93171124' AND create_time < '2018-12-07 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93166124' AND '93171124') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93166124' AND '93171124' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 40ms DELETE FROM sym_data WHERE data_id BETWEEN '93228312' AND '93233312' AND create_time < '2018-12-07 16:01:03.207' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93228312' AND '93233312') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93228312' AND '93233312' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 16:02:06 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 38ms DELETE FROM sym_data WHERE data_id BETWEEN '93176126' AND '93181126' AND create_time < '2018-12-07 07:00:00.002' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93176126' AND '93181126') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93176126' AND '93181126' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-12-08 07:01:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 37ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_9_0_, this_.routeNumber AS routeNum2_9_0_, this_.roundDeliveryDate AS roundDel3_9_0_, this_.distributionPoint AS distribu4_9_0_, this_.fullyPicked AS fullyPic5_9_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_9_0_, this_.causeOfDelay AS causeOfD7_9_0_, this_.pharmacy100CheckTime AS pharmacy8_9_0_, this_.linesHeldBack AS linesHel9_9_0_, this_.packTime100 AS packTim10_9_0_, this_.replenish AS repleni11_9_0_, this_.comment AS comment12_9_0_, this_.pickDateTime AS pickDat13_9_0_, this_.failedTargetPickTime AS failedT14_9_0_, this_.actualPaperworkCompleteTime AS actualP15_9_0_, this_.changedPickDateTime AS changed16_9_0_, this_.manuallyChangedPickTime AS manuall17_9_0_, this_.CREATED AS CREATED18_9_0_, this_.UPDATED AS UPDATED19_9_0_, this_.note AS note20_9_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = '2018-12-07' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2018-12-08 20:00:59 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 37ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8301227' AND '8301760' AND STATUS != 'OK') AND batch_id BETWEEN '8301227' AND '8301760';[ Date: 2018-12-08 11:01:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15s50ms 862,103 0ms 8ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 08 00 38,334 658ms 0ms 01 35,912 619ms 0ms 02 36,012 627ms 0ms 03 36,229 666ms 0ms 04 35,731 620ms 0ms 05 36,169 639ms 0ms 06 36,224 629ms 0ms 07 34,043 594ms 0ms 08 36,265 626ms 0ms 09 36,247 630ms 0ms 10 35,717 619ms 0ms 11 35,584 607ms 0ms 12 36,248 629ms 0ms 13 35,632 615ms 0ms 14 36,043 620ms 0ms 15 35,525 623ms 0ms 16 36,167 623ms 0ms 17 36,102 629ms 0ms 18 36,004 637ms 0ms 19 35,195 629ms 0ms 20 35,552 635ms 0ms 21 36,178 634ms 0ms 22 34,939 609ms 0ms 23 36,051 623ms 0ms [ User: symmetricds - Total duration: 15s9ms - Times executed: 861015 ]
[ User: pharmisight - Total duration: 41ms - Times executed: 1088 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s50ms - Times executed: 862103 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-08 05:53:49 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 19:08:58 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:29:25 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s381ms 290,616 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 08 00 13,596 641ms 0ms 01 12,112 339ms 0ms 02 12,120 306ms 0ms 03 12,179 297ms 0ms 04 12,049 313ms 0ms 05 12,159 291ms 0ms 06 12,172 293ms 0ms 07 11,462 283ms 0ms 08 12,214 319ms 0ms 09 12,224 311ms 0ms 10 12,045 300ms 0ms 11 11,962 279ms 0ms 12 12,203 313ms 0ms 13 11,967 274ms 0ms 14 12,104 277ms 0ms 15 11,931 275ms 0ms 16 12,145 282ms 0ms 17 12,124 277ms 0ms 18 12,091 296ms 0ms 19 11,823 294ms 0ms 20 11,951 280ms 0ms 21 12,149 276ms 0ms 22 11,727 283ms 0ms 23 12,107 272ms 0ms [ User: symmetricds - Total duration: 7s325ms - Times executed: 290322 ]
[ User: pharmisight - Total duration: 56ms - Times executed: 294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s381ms - Times executed: 290616 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-08 01:51:43 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:30:42 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:46:05 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s843ms 381,698 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 08 00 17,665 219ms 0ms 01 15,928 197ms 0ms 02 15,927 200ms 0ms 03 16,018 209ms 0ms 04 15,838 198ms 0ms 05 15,988 202ms 0ms 06 16,012 202ms 0ms 07 15,075 192ms 0ms 08 16,051 202ms 0ms 09 16,053 202ms 0ms 10 15,815 201ms 0ms 11 15,710 197ms 0ms 12 16,032 201ms 0ms 13 15,732 201ms 0ms 14 15,904 203ms 0ms 15 15,675 199ms 0ms 16 15,966 202ms 0ms 17 15,922 200ms 0ms 18 15,889 201ms 0ms 19 15,526 200ms 0ms 20 15,697 204ms 0ms 21 15,962 204ms 0ms 22 15,411 195ms 0ms 23 15,902 202ms 0ms [ User: symmetricds - Total duration: 4s843ms - Times executed: 381698 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s843ms - Times executed: 381698 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-08 23:40:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 15:20:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 19:17:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s494ms 288 1ms 13ms 12ms SELECT sum (xact_commit) AS xact_commit, sum (xact_rollback) AS xact_rollback, sum (blks_read) AS blks_read, sum (blks_hit) AS blks_hit, sum (tup_returned) AS tup_returned, sum (tup_fetched) AS tup_fetched, sum (tup_inserted) AS tup_inserted, sum (tup_updated) AS tup_updated, sum (tup_deleted) AS tup_deleted FROM pg_stat_database;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 08 00 12 145ms 12ms 01 12 147ms 12ms 02 12 145ms 12ms 03 12 146ms 12ms 04 12 146ms 12ms 05 12 146ms 12ms 06 12 145ms 12ms 07 12 146ms 12ms 08 12 146ms 12ms 09 12 146ms 12ms 10 12 147ms 12ms 11 12 145ms 12ms 12 12 145ms 12ms 13 12 143ms 11ms 14 12 145ms 12ms 15 12 145ms 12ms 16 12 147ms 12ms 17 12 145ms 12ms 18 12 146ms 12ms 19 12 146ms 12ms 20 12 145ms 12ms 21 12 146ms 12ms 22 12 145ms 12ms 23 12 135ms 11ms [ User: tony - Total duration: 3s494ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s494ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-12-08 09:36:20 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-12-08 16:46:25 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-12-08 14:41:21 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
5 3s474ms 76,437 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 00 3,195 145ms 0ms 01 3,195 142ms 0ms 02 3,186 141ms 0ms 03 3,222 146ms 0ms 04 3,168 145ms 0ms 05 3,213 144ms 0ms 06 3,222 146ms 0ms 07 3,024 138ms 0ms 08 3,222 149ms 0ms 09 3,213 143ms 0ms 10 3,168 143ms 0ms 11 3,159 144ms 0ms 12 3,222 149ms 0ms 13 3,177 141ms 0ms 14 3,204 144ms 0ms 15 3,159 144ms 0ms 16 3,222 149ms 0ms 17 3,213 144ms 0ms 18 3,213 145ms 0ms 19 3,123 141ms 0ms 20 3,177 147ms 0ms 21 3,222 147ms 0ms 22 3,114 141ms 0ms 23 3,204 145ms 0ms [ User: symmetricds - Total duration: 3s474ms - Times executed: 76437 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s474ms - Times executed: 76437 ]
-
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-12-08 17:51:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:36:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:10:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 2s83ms 40,261 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 08 00 2,973 140ms 0ms 01 1,612 62ms 0ms 02 1,982 82ms 0ms 03 991 44ms 0ms 04 1,982 89ms 0ms 05 991 55ms 0ms 06 991 57ms 0ms 07 991 55ms 0ms 08 1,982 111ms 0ms 09 1,982 96ms 0ms 10 1,982 111ms 0ms 11 1,982 110ms 0ms 12 1,982 109ms 0ms 13 1,982 114ms 0ms 14 991 57ms 0ms 15 991 54ms 0ms 16 991 57ms 0ms 17 1,982 121ms 0ms 18 1,982 100ms 0ms 19 1,982 109ms 0ms 20 1,982 91ms 0ms 21 991 54ms 0ms 22 1,982 110ms 0ms 23 1,982 83ms 0ms [ User: pharmisight - Total duration: 2s83ms - Times executed: 40261 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s83ms - Times executed: 40261 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2991' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965305' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3418' ORDER BY itemcodes0_.code ASC;
Date: 2018-12-08 13:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:21:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 2s37ms 159 0ms 95ms 12ms 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 #7
Day Hour Count Duration Avg duration Dec 08 01 15 74ms 4ms 02 15 51ms 3ms 03 15 69ms 4ms 04 15 91ms 6ms 05 15 50ms 3ms 06 15 92ms 6ms 07 15 308ms 20ms 08 10 117ms 11ms 09 9 215ms 23ms 10 7 183ms 26ms 11 6 259ms 43ms 12 5 186ms 37ms 13 3 61ms 20ms 14 3 63ms 21ms 15 2 44ms 22ms 16 2 48ms 24ms 17 1 12ms 12ms 18 1 30ms 30ms 19 1 8ms 8ms 20 1 15ms 15ms 21 1 8ms 8ms 22 1 21ms 21ms 23 1 20ms 20ms [ User: symmetricds - Total duration: 2s37ms - Times executed: 159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s37ms - Times executed: 159 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '93208237' AND '93213237' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237' 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 '93213704' AND '93218704' AND create_time < '2018-12-07 12:02:02.633' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704' 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 '93213238' AND '93218238' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-12-08 11:01:03 Duration: 95ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:02:03 Duration: 78ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:01:03 Duration: 60ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s890ms 35,706 0ms 3ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 00 2,637 127ms 0ms 01 1,425 57ms 0ms 02 1,758 74ms 0ms 03 879 40ms 0ms 04 1,758 81ms 0ms 05 879 49ms 0ms 06 879 52ms 0ms 07 879 50ms 0ms 08 1,758 101ms 0ms 09 1,758 87ms 0ms 10 1,758 101ms 0ms 11 1,758 99ms 0ms 12 1,758 100ms 0ms 13 1,758 101ms 0ms 14 879 51ms 0ms 15 879 49ms 0ms 16 879 52ms 0ms 17 1,758 109ms 0ms 18 1,758 94ms 0ms 19 1,758 99ms 0ms 20 1,758 82ms 0ms 21 879 49ms 0ms 22 1,758 99ms 0ms 23 1,758 75ms 0ms [ User: pharmisight - Total duration: 1s890ms - Times executed: 35706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 35706 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074340' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3393' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32994465' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-12-08 18:00:02 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 16:21:03 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s854ms 290,619 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 08 00 13,597 84ms 0ms 01 12,113 76ms 0ms 02 12,120 77ms 0ms 03 12,179 78ms 0ms 04 12,049 75ms 0ms 05 12,159 78ms 0ms 06 12,172 77ms 0ms 07 11,463 71ms 0ms 08 12,214 79ms 0ms 09 12,224 77ms 0ms 10 12,045 77ms 0ms 11 11,962 74ms 0ms 12 12,203 77ms 0ms 13 11,967 76ms 0ms 14 12,104 81ms 0ms 15 11,931 76ms 0ms 16 12,145 77ms 0ms 17 12,124 78ms 0ms 18 12,091 76ms 0ms 19 11,823 73ms 0ms 20 11,951 77ms 0ms 21 12,149 77ms 0ms 22 11,727 75ms 0ms 23 12,107 76ms 0ms [ User: symmetricds - Total duration: 1s852ms - Times executed: 290322 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s854ms - Times executed: 290619 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-08 14:49:45 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:13:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:11:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s515ms 67,950 0ms 1ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 08 00 2,841 66ms 0ms 01 2,841 64ms 0ms 02 2,833 63ms 0ms 03 2,864 63ms 0ms 04 2,819 67ms 0ms 05 2,856 64ms 0ms 06 2,864 65ms 0ms 07 2,688 61ms 0ms 08 2,864 66ms 0ms 09 2,856 65ms 0ms 10 2,816 65ms 0ms 11 2,808 61ms 0ms 12 2,864 62ms 0ms 13 2,824 62ms 0ms 14 2,848 62ms 0ms 15 2,808 61ms 0ms 16 2,864 62ms 0ms 17 2,856 61ms 0ms 18 2,856 61ms 0ms 19 2,776 60ms 0ms 20 2,824 61ms 0ms 21 2,864 62ms 0ms 22 2,768 60ms 0ms 23 2,848 61ms 0ms [ User: symmetricds - Total duration: 1s515ms - Times executed: 67950 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s515ms - Times executed: 67950 ]
-
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 = 'config' AND ((d.data_id BETWEEN '93234547' AND '143234546')) 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 '93233950' AND '143233949')) 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 = 'filesync' AND ((d.data_id BETWEEN '93234099' AND '143234098')) ORDER BY d.data_id ASC;
Date: 2018-12-08 10:15:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:40:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:41:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s447ms 1,365 0ms 10ms 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 #11
Day Hour Count Duration Avg duration Dec 08 00 62 63ms 1ms 01 48 46ms 0ms 02 44 45ms 1ms 03 33 38ms 1ms 04 47 48ms 1ms 05 59 66ms 1ms 06 59 60ms 1ms 07 55 57ms 1ms 08 60 65ms 1ms 09 57 59ms 1ms 10 60 62ms 1ms 11 59 65ms 1ms 12 60 62ms 1ms 13 59 61ms 1ms 14 62 65ms 1ms 15 60 62ms 1ms 16 61 63ms 1ms 17 61 65ms 1ms 18 61 78ms 1ms 19 61 63ms 1ms 20 61 64ms 1ms 21 58 57ms 0ms 22 56 59ms 1ms 23 62 63ms 1ms [ User: symmetricds - Total duration: 1s447ms - Times executed: 1365 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s447ms - Times executed: 1365 ]
-
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-12-08 18:21:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:29:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:10:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s242ms 189 0ms 17ms 6ms 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 #12
Day Hour Count Duration Avg duration Dec 08 00 8 51ms 6ms 01 8 50ms 6ms 02 8 49ms 6ms 03 8 46ms 5ms 04 8 59ms 7ms 05 8 49ms 6ms 06 8 56ms 7ms 07 8 56ms 7ms 08 8 54ms 6ms 09 8 56ms 7ms 10 8 39ms 4ms 11 8 52ms 6ms 12 8 56ms 7ms 13 8 52ms 6ms 14 8 56ms 7ms 15 8 57ms 7ms 16 8 52ms 6ms 17 8 57ms 7ms 18 8 58ms 7ms 19 8 45ms 5ms 20 5 37ms 7ms 21 8 50ms 6ms 22 8 45ms 5ms 23 8 50ms 6ms [ User: symmetricds - Total duration: 1s242ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s242ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '292707848', "total_memory_bytes" = '535298048', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 03:11:21', "last_restart_time" = '2018-11-20 12:12:12', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '266757928', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 08:26:21', "last_restart_time" = '2018-11-20 12:12:12', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '393778208', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 16:51:18', "last_restart_time" = '2018-11-20 13:49:33.42', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-12-08 03:12:45 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:27:04 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 16:51:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s212ms 5,713 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 #13
Day Hour Count Duration Avg duration Dec 08 00 243 49ms 0ms 01 236 48ms 0ms 02 242 51ms 0ms 03 243 54ms 0ms 04 237 46ms 0ms 05 240 53ms 0ms 06 240 51ms 0ms 07 227 46ms 0ms 08 239 50ms 0ms 09 240 50ms 0ms 10 237 49ms 0ms 11 236 48ms 0ms 12 240 49ms 0ms 13 236 49ms 0ms 14 240 49ms 0ms 15 236 50ms 0ms 16 240 48ms 0ms 17 240 49ms 0ms 18 237 51ms 0ms 19 235 54ms 0ms 20 236 52ms 0ms 21 240 53ms 0ms 22 232 50ms 0ms 23 241 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 5713 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 5713 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-08 19:19:04 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 22:59:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 05:33:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 1s166ms 214 3ms 15ms 5ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 END END AS TYPE, (i.keys).n AS ordinal_position, trim (BOTH '' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN '' THEN CASE i.indoption [ (i.keys).n - 0 ] & 0 WHEN 0 THEN '' ELSE '' END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = '' AND ct.relname = '' ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 08 00 153 664ms 4ms 01 3 14ms 4ms 02 4 34ms 8ms 03 3 26ms 8ms 04 4 22ms 5ms 05 3 26ms 8ms 06 3 26ms 8ms 07 3 26ms 8ms 08 3 25ms 8ms 09 3 27ms 9ms 10 3 27ms 9ms 11 3 22ms 7ms 12 3 26ms 8ms 13 2 12ms 6ms 14 2 17ms 8ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 17ms 8ms 20 3 22ms 7ms 21 2 17ms 8ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 974ms - Times executed: 169 ]
[ User: pharmisight - Total duration: 191ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s166ms - Times executed: 214 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-12-08 00:00:33 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 15:15:31 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 21:16:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 1s111ms 56,999 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 #15
Day Hour Count Duration Avg duration Dec 08 00 2,400 46ms 0ms 01 2,360 45ms 0ms 02 2,400 49ms 0ms 03 2,400 52ms 0ms 04 2,360 44ms 0ms 05 2,400 45ms 0ms 06 2,400 44ms 0ms 07 2,240 43ms 0ms 08 2,400 44ms 0ms 09 2,400 46ms 0ms 10 2,360 47ms 0ms 11 2,360 47ms 0ms 12 2,400 46ms 0ms 13 2,360 47ms 0ms 14 2,400 46ms 0ms 15 2,360 45ms 0ms 16 2,400 45ms 0ms 17 2,400 45ms 0ms 18 2,376 47ms 0ms 19 2,343 45ms 0ms 20 2,360 45ms 0ms 21 2,400 46ms 0ms 22 2,320 44ms 0ms 23 2,400 45ms 0ms [ User: symmetricds - Total duration: 1s111ms - Times executed: 56999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 56999 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'reload';
-
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 = 'filesync';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'reload';
Date: 2018-12-08 11:01:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:38:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:31:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 1s96ms 1,184 0ms 3ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 08 00 51 46ms 0ms 01 40 37ms 0ms 02 37 34ms 0ms 03 29 29ms 1ms 04 40 40ms 1ms 05 49 44ms 0ms 06 53 48ms 0ms 07 49 45ms 0ms 08 52 46ms 0ms 09 50 46ms 0ms 10 55 50ms 0ms 11 53 50ms 0ms 12 53 48ms 0ms 13 54 48ms 0ms 14 56 50ms 0ms 15 53 47ms 0ms 16 56 51ms 0ms 17 52 48ms 0ms 18 54 49ms 0ms 19 47 44ms 0ms 20 52 47ms 0ms 21 47 43ms 0ms 22 50 46ms 0ms 23 52 48ms 0ms [ User: symmetricds - Total duration: 1s96ms - Times executed: 1184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s96ms - Times executed: 1184 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-08 04:05:44 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:11:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 03:53:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 881ms 542 0ms 7ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 08 00 22 31ms 1ms 01 8 10ms 1ms 02 5 9ms 1ms 03 1 1ms 1ms 04 17 26ms 1ms 05 18 30ms 1ms 06 17 25ms 1ms 07 25 39ms 1ms 08 48 78ms 1ms 09 35 56ms 1ms 10 22 35ms 1ms 11 23 37ms 1ms 12 24 46ms 1ms 13 20 31ms 1ms 14 22 41ms 1ms 15 17 27ms 1ms 16 36 58ms 1ms 17 16 26ms 1ms 18 27 44ms 1ms 19 32 51ms 1ms 20 25 39ms 1ms 21 23 35ms 1ms 22 30 46ms 1ms 23 29 46ms 1ms [ User: symmetricds - Total duration: 881ms - Times executed: 542 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 881ms - Times executed: 542 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-08 14:47:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:46:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:16:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 875ms 609 0ms 5ms 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 Dec 08 00 19 26ms 1ms 01 30 45ms 1ms 02 30 43ms 1ms 03 29 42ms 1ms 04 24 33ms 1ms 05 29 40ms 1ms 06 30 43ms 1ms 07 13 17ms 1ms 08 6 8ms 1ms 09 14 19ms 1ms 10 30 44ms 1ms 11 26 36ms 1ms 12 31 44ms 1ms 13 28 40ms 1ms 14 31 44ms 1ms 15 30 43ms 1ms 16 19 26ms 1ms 17 34 48ms 1ms 18 30 43ms 1ms 19 20 28ms 1ms 20 30 43ms 1ms 21 29 40ms 1ms 22 22 32ms 1ms 23 25 35ms 1ms [ User: symmetricds - Total duration: 875ms - Times executed: 609 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 875ms - Times executed: 609 ]
-
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-12-08 01:00:37 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:49:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 20:17:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 860ms 5,700 0ms 2ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 08 00 240 33ms 0ms 01 236 32ms 0ms 02 240 34ms 0ms 03 240 41ms 0ms 04 236 34ms 0ms 05 240 35ms 0ms 06 240 36ms 0ms 07 224 33ms 0ms 08 240 34ms 0ms 09 240 37ms 0ms 10 236 37ms 0ms 11 236 35ms 0ms 12 240 35ms 0ms 13 236 37ms 0ms 14 240 35ms 0ms 15 236 37ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 237 35ms 0ms 19 235 36ms 0ms 20 236 36ms 0ms 21 240 38ms 0ms 22 232 34ms 0ms 23 240 35ms 0ms [ User: symmetricds - Total duration: 860ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 860ms - Times executed: 5700 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 21:22:39.309', last_lock_time = '2018-12-08 21:22:39.309' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 19:22:39.309');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 13:48:44.7', last_lock_time = '2018-12-08 13:48:44.7' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 11:48:44.7');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 10:46:33.766', last_lock_time = '2018-12-08 10:46:33.766' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 08:46:33.766');
Date: 2018-12-08 21:23:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:48:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:47:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 857ms 1,657 0ms 8ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 08 00 352 201ms 0ms 01 256 113ms 0ms 02 183 48ms 0ms 04 390 188ms 0ms 07 53 33ms 0ms 08 90 61ms 0ms 09 195 102ms 0ms 10 102 71ms 0ms 12 36 36ms 1ms [ User: pharmisight - Total duration: 857ms - Times executed: 1657 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 857ms - Times executed: 1657 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004877274', '2018-12-08 03:40:13', 'DZIEMIN', '2018-12-08 04:00:15.473', '53451', '4', '150505230130291975');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004888547', '2018-12-08 00:01:07', 'RYBAKJ', '2018-12-08 00:20:01.479', '40879', '6', '150505230130276552');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004884171', '2018-12-08 04:21:06', 'KOPACZM', '2018-12-08 04:40:00.042', '49760', '6', '150505230130295683');
Date: 2018-12-08 04:00:15 Duration: 8ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:20:02 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:40:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 862,103 15s50ms 0ms 8ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 08 00 38,334 658ms 0ms 01 35,912 619ms 0ms 02 36,012 627ms 0ms 03 36,229 666ms 0ms 04 35,731 620ms 0ms 05 36,169 639ms 0ms 06 36,224 629ms 0ms 07 34,043 594ms 0ms 08 36,265 626ms 0ms 09 36,247 630ms 0ms 10 35,717 619ms 0ms 11 35,584 607ms 0ms 12 36,248 629ms 0ms 13 35,632 615ms 0ms 14 36,043 620ms 0ms 15 35,525 623ms 0ms 16 36,167 623ms 0ms 17 36,102 629ms 0ms 18 36,004 637ms 0ms 19 35,195 629ms 0ms 20 35,552 635ms 0ms 21 36,178 634ms 0ms 22 34,939 609ms 0ms 23 36,051 623ms 0ms [ User: symmetricds - Total duration: 15s9ms - Times executed: 861015 ]
[ User: pharmisight - Total duration: 41ms - Times executed: 1088 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s50ms - Times executed: 862103 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-08 05:53:49 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 19:08:58 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:29:25 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 381,698 4s843ms 0ms 1ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 08 00 17,665 219ms 0ms 01 15,928 197ms 0ms 02 15,927 200ms 0ms 03 16,018 209ms 0ms 04 15,838 198ms 0ms 05 15,988 202ms 0ms 06 16,012 202ms 0ms 07 15,075 192ms 0ms 08 16,051 202ms 0ms 09 16,053 202ms 0ms 10 15,815 201ms 0ms 11 15,710 197ms 0ms 12 16,032 201ms 0ms 13 15,732 201ms 0ms 14 15,904 203ms 0ms 15 15,675 199ms 0ms 16 15,966 202ms 0ms 17 15,922 200ms 0ms 18 15,889 201ms 0ms 19 15,526 200ms 0ms 20 15,697 204ms 0ms 21 15,962 204ms 0ms 22 15,411 195ms 0ms 23 15,902 202ms 0ms [ User: symmetricds - Total duration: 4s843ms - Times executed: 381698 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s843ms - Times executed: 381698 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-08 23:40:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 15:20:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 19:17:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 290,619 1s854ms 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 08 00 13,597 84ms 0ms 01 12,113 76ms 0ms 02 12,120 77ms 0ms 03 12,179 78ms 0ms 04 12,049 75ms 0ms 05 12,159 78ms 0ms 06 12,172 77ms 0ms 07 11,463 71ms 0ms 08 12,214 79ms 0ms 09 12,224 77ms 0ms 10 12,045 77ms 0ms 11 11,962 74ms 0ms 12 12,203 77ms 0ms 13 11,967 76ms 0ms 14 12,104 81ms 0ms 15 11,931 76ms 0ms 16 12,145 77ms 0ms 17 12,124 78ms 0ms 18 12,091 76ms 0ms 19 11,823 73ms 0ms 20 11,951 77ms 0ms 21 12,149 77ms 0ms 22 11,727 75ms 0ms 23 12,107 76ms 0ms [ User: symmetricds - Total duration: 1s852ms - Times executed: 290322 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s854ms - Times executed: 290619 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-08 14:49:45 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:13:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:11:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 290,616 7s381ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 08 00 13,596 641ms 0ms 01 12,112 339ms 0ms 02 12,120 306ms 0ms 03 12,179 297ms 0ms 04 12,049 313ms 0ms 05 12,159 291ms 0ms 06 12,172 293ms 0ms 07 11,462 283ms 0ms 08 12,214 319ms 0ms 09 12,224 311ms 0ms 10 12,045 300ms 0ms 11 11,962 279ms 0ms 12 12,203 313ms 0ms 13 11,967 274ms 0ms 14 12,104 277ms 0ms 15 11,931 275ms 0ms 16 12,145 282ms 0ms 17 12,124 277ms 0ms 18 12,091 296ms 0ms 19 11,823 294ms 0ms 20 11,951 280ms 0ms 21 12,149 276ms 0ms 22 11,727 283ms 0ms 23 12,107 272ms 0ms [ User: symmetricds - Total duration: 7s325ms - Times executed: 290322 ]
[ User: pharmisight - Total duration: 56ms - Times executed: 294 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s381ms - Times executed: 290616 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-08 01:51:43 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:30:42 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:46:05 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 76,437 3s474ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 00 3,195 145ms 0ms 01 3,195 142ms 0ms 02 3,186 141ms 0ms 03 3,222 146ms 0ms 04 3,168 145ms 0ms 05 3,213 144ms 0ms 06 3,222 146ms 0ms 07 3,024 138ms 0ms 08 3,222 149ms 0ms 09 3,213 143ms 0ms 10 3,168 143ms 0ms 11 3,159 144ms 0ms 12 3,222 149ms 0ms 13 3,177 141ms 0ms 14 3,204 144ms 0ms 15 3,159 144ms 0ms 16 3,222 149ms 0ms 17 3,213 144ms 0ms 18 3,213 145ms 0ms 19 3,123 141ms 0ms 20 3,177 147ms 0ms 21 3,222 147ms 0ms 22 3,114 141ms 0ms 23 3,204 145ms 0ms [ User: symmetricds - Total duration: 3s474ms - Times executed: 76437 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s474ms - Times executed: 76437 ]
-
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-12-08 17:51:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:36:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:10:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 67,950 1s515ms 0ms 1ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 08 00 2,841 66ms 0ms 01 2,841 64ms 0ms 02 2,833 63ms 0ms 03 2,864 63ms 0ms 04 2,819 67ms 0ms 05 2,856 64ms 0ms 06 2,864 65ms 0ms 07 2,688 61ms 0ms 08 2,864 66ms 0ms 09 2,856 65ms 0ms 10 2,816 65ms 0ms 11 2,808 61ms 0ms 12 2,864 62ms 0ms 13 2,824 62ms 0ms 14 2,848 62ms 0ms 15 2,808 61ms 0ms 16 2,864 62ms 0ms 17 2,856 61ms 0ms 18 2,856 61ms 0ms 19 2,776 60ms 0ms 20 2,824 61ms 0ms 21 2,864 62ms 0ms 22 2,768 60ms 0ms 23 2,848 61ms 0ms [ User: symmetricds - Total duration: 1s515ms - Times executed: 67950 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s515ms - Times executed: 67950 ]
-
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 = 'config' AND ((d.data_id BETWEEN '93234547' AND '143234546')) 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 '93233950' AND '143233949')) 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 = 'filesync' AND ((d.data_id BETWEEN '93234099' AND '143234098')) ORDER BY d.data_id ASC;
Date: 2018-12-08 10:15:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:40:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:41:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 56,999 1s111ms 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 Dec 08 00 2,400 46ms 0ms 01 2,360 45ms 0ms 02 2,400 49ms 0ms 03 2,400 52ms 0ms 04 2,360 44ms 0ms 05 2,400 45ms 0ms 06 2,400 44ms 0ms 07 2,240 43ms 0ms 08 2,400 44ms 0ms 09 2,400 46ms 0ms 10 2,360 47ms 0ms 11 2,360 47ms 0ms 12 2,400 46ms 0ms 13 2,360 47ms 0ms 14 2,400 46ms 0ms 15 2,360 45ms 0ms 16 2,400 45ms 0ms 17 2,400 45ms 0ms 18 2,376 47ms 0ms 19 2,343 45ms 0ms 20 2,360 45ms 0ms 21 2,400 46ms 0ms 22 2,320 44ms 0ms 23 2,400 45ms 0ms [ User: symmetricds - Total duration: 1s111ms - Times executed: 56999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 56999 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'reload';
-
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 = 'filesync';
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = 'reload';
Date: 2018-12-08 11:01:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:38:41 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:31:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 40,261 2s83ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 00 2,973 140ms 0ms 01 1,612 62ms 0ms 02 1,982 82ms 0ms 03 991 44ms 0ms 04 1,982 89ms 0ms 05 991 55ms 0ms 06 991 57ms 0ms 07 991 55ms 0ms 08 1,982 111ms 0ms 09 1,982 96ms 0ms 10 1,982 111ms 0ms 11 1,982 110ms 0ms 12 1,982 109ms 0ms 13 1,982 114ms 0ms 14 991 57ms 0ms 15 991 54ms 0ms 16 991 57ms 0ms 17 1,982 121ms 0ms 18 1,982 100ms 0ms 19 1,982 109ms 0ms 20 1,982 91ms 0ms 21 991 54ms 0ms 22 1,982 110ms 0ms 23 1,982 83ms 0ms [ User: pharmisight - Total duration: 2s83ms - Times executed: 40261 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s83ms - Times executed: 40261 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2991' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965305' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3418' ORDER BY itemcodes0_.code ASC;
Date: 2018-12-08 13:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:21:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 35,706 1s890ms 0ms 3ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 08 00 2,637 127ms 0ms 01 1,425 57ms 0ms 02 1,758 74ms 0ms 03 879 40ms 0ms 04 1,758 81ms 0ms 05 879 49ms 0ms 06 879 52ms 0ms 07 879 50ms 0ms 08 1,758 101ms 0ms 09 1,758 87ms 0ms 10 1,758 101ms 0ms 11 1,758 99ms 0ms 12 1,758 100ms 0ms 13 1,758 101ms 0ms 14 879 51ms 0ms 15 879 49ms 0ms 16 879 52ms 0ms 17 1,758 109ms 0ms 18 1,758 94ms 0ms 19 1,758 99ms 0ms 20 1,758 82ms 0ms 21 879 49ms 0ms 22 1,758 99ms 0ms 23 1,758 75ms 0ms [ User: pharmisight - Total duration: 1s890ms - Times executed: 35706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 35706 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074340' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3393' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32994465' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-12-08 18:00:02 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 16:21:03 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 15,962 805ms 0ms 5ms 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 Dec 08 00 701 33ms 0ms 01 664 32ms 0ms 02 668 31ms 0ms 03 672 33ms 0ms 04 661 33ms 0ms 05 671 33ms 0ms 06 672 33ms 0ms 07 630 30ms 0ms 08 672 31ms 0ms 09 671 35ms 0ms 10 662 34ms 0ms 11 661 31ms 0ms 12 671 33ms 0ms 13 660 32ms 0ms 14 668 31ms 0ms 15 658 33ms 0ms 16 670 33ms 0ms 17 669 32ms 0ms 18 665 35ms 0ms 19 653 35ms 0ms 20 657 32ms 0ms 21 670 40ms 0ms 22 648 32ms 0ms 23 668 34ms 0ms [ User: symmetricds - Total duration: 805ms - Times executed: 15962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 805ms - Times executed: 15962 ]
-
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-12-08 21:23:43 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:06:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 09:40:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 11,401 747ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 08 00 481 30ms 0ms 01 472 26ms 0ms 02 480 30ms 0ms 03 480 32ms 0ms 04 472 29ms 0ms 05 480 33ms 0ms 06 480 31ms 0ms 07 448 28ms 0ms 08 480 30ms 0ms 09 480 31ms 0ms 10 472 35ms 0ms 11 472 29ms 0ms 12 480 30ms 0ms 13 472 31ms 0ms 14 480 29ms 0ms 15 472 30ms 0ms 16 480 32ms 0ms 17 480 31ms 0ms 18 476 33ms 0ms 19 468 33ms 0ms 20 472 31ms 0ms 21 480 30ms 0ms 22 464 31ms 0ms 23 480 30ms 0ms [ User: symmetricds - Total duration: 747ms - Times executed: 11401 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 747ms - Times executed: 11401 ]
-
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-12-08 16:21:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:19:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:52:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,545 268ms 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 Dec 08 00 358 11ms 0ms 01 356 11ms 0ms 02 357 12ms 0ms 03 360 12ms 0ms 04 354 10ms 0ms 05 359 10ms 0ms 06 360 10ms 0ms 07 338 10ms 0ms 08 360 10ms 0ms 09 360 11ms 0ms 10 354 11ms 0ms 11 353 11ms 0ms 12 360 11ms 0ms 13 355 11ms 0ms 14 358 11ms 0ms 15 353 11ms 0ms 16 360 11ms 0ms 17 360 10ms 0ms 18 359 10ms 0ms 19 349 10ms 0ms 20 355 11ms 0ms 21 360 11ms 0ms 22 348 11ms 0ms 23 359 11ms 0ms [ User: symmetricds - Total duration: 268ms - Times executed: 8545 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 268ms - Times executed: 8545 ]
-
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-12-08 03:14:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:48:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:53:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,499 188ms 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 Dec 08 00 356 8ms 0ms 01 356 8ms 0ms 02 355 8ms 0ms 03 358 8ms 0ms 04 355 8ms 0ms 05 357 7ms 0ms 06 358 8ms 0ms 07 336 7ms 0ms 08 358 8ms 0ms 09 357 8ms 0ms 10 352 7ms 0ms 11 351 7ms 0ms 12 358 7ms 0ms 13 353 7ms 0ms 14 356 7ms 0ms 15 351 7ms 0ms 16 358 7ms 0ms 17 357 7ms 0ms 18 357 7ms 0ms 19 347 7ms 0ms 20 353 7ms 0ms 21 358 7ms 0ms 22 346 7ms 0ms 23 356 7ms 0ms [ User: symmetricds - Total duration: 188ms - Times executed: 8499 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 188ms - Times executed: 8499 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '93233357' AND data_id <= '143233356' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '93233130' AND data_id <= '143233129' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '93232956' AND data_id <= '143232955' ORDER BY data_id ASC;
Date: 2018-12-08 01:40:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:40:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:20:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,493 466ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 08 00 355 20ms 0ms 01 355 20ms 0ms 02 354 20ms 0ms 03 358 20ms 0ms 04 352 20ms 0ms 05 357 20ms 0ms 06 358 21ms 0ms 07 336 18ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 352 19ms 0ms 11 351 18ms 0ms 12 358 18ms 0ms 13 353 19ms 0ms 14 356 19ms 0ms 15 351 18ms 0ms 16 358 19ms 0ms 17 357 18ms 0ms 18 357 18ms 0ms 19 347 18ms 0ms 20 353 19ms 0ms 21 358 18ms 0ms 22 346 18ms 0ms 23 356 18ms 0ms [ User: symmetricds - Total duration: 466ms - Times executed: 8493 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 466ms - Times executed: 8493 ]
-
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-12-08 06:46:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:12:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:44:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 7,124 560ms 0ms 3ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 08 00 300 27ms 0ms 01 295 25ms 0ms 02 300 23ms 0ms 03 300 27ms 0ms 04 295 23ms 0ms 05 300 24ms 0ms 06 300 25ms 0ms 07 280 23ms 0ms 08 300 24ms 0ms 09 300 25ms 0ms 10 295 23ms 0ms 11 295 23ms 0ms 12 300 23ms 0ms 13 295 23ms 0ms 14 300 21ms 0ms 15 295 22ms 0ms 16 300 20ms 0ms 17 300 22ms 0ms 18 296 21ms 0ms 19 293 21ms 0ms 20 295 22ms 0ms 21 300 20ms 0ms 22 290 21ms 0ms 23 300 22ms 0ms [ User: symmetricds - Total duration: 560ms - Times executed: 7124 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 560ms - Times executed: 7124 ]
-
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-12-08 00:12:34 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 09:21:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 07:14:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,725 205ms 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 #16
Day Hour Count Duration Avg duration Dec 08 00 265 9ms 0ms 01 236 8ms 0ms 02 240 8ms 0ms 03 240 8ms 0ms 04 236 8ms 0ms 05 240 8ms 0ms 06 240 8ms 0ms 07 224 7ms 0ms 08 240 8ms 0ms 09 240 8ms 0ms 10 236 8ms 0ms 11 236 8ms 0ms 12 240 8ms 0ms 13 236 8ms 0ms 14 240 8ms 0ms 15 236 8ms 0ms 16 240 8ms 0ms 17 240 8ms 0ms 18 239 8ms 0ms 19 233 9ms 0ms 20 236 8ms 0ms 21 240 8ms 0ms 22 232 9ms 0ms 23 240 8ms 0ms [ User: symmetricds - Total duration: 205ms - Times executed: 5725 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 205ms - Times executed: 5725 ]
-
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-12-08 19:50:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 22:07:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 22:14:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,713 1s212ms 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 #17
Day Hour Count Duration Avg duration Dec 08 00 243 49ms 0ms 01 236 48ms 0ms 02 242 51ms 0ms 03 243 54ms 0ms 04 237 46ms 0ms 05 240 53ms 0ms 06 240 51ms 0ms 07 227 46ms 0ms 08 239 50ms 0ms 09 240 50ms 0ms 10 237 49ms 0ms 11 236 48ms 0ms 12 240 49ms 0ms 13 236 49ms 0ms 14 240 49ms 0ms 15 236 50ms 0ms 16 240 48ms 0ms 17 240 49ms 0ms 18 237 51ms 0ms 19 235 54ms 0ms 20 236 52ms 0ms 21 240 53ms 0ms 22 232 50ms 0ms 23 241 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 5713 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 5713 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-08 19:19:04 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 22:59:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 05:33:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,700 860ms 0ms 2ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 08 00 240 33ms 0ms 01 236 32ms 0ms 02 240 34ms 0ms 03 240 41ms 0ms 04 236 34ms 0ms 05 240 35ms 0ms 06 240 36ms 0ms 07 224 33ms 0ms 08 240 34ms 0ms 09 240 37ms 0ms 10 236 37ms 0ms 11 236 35ms 0ms 12 240 35ms 0ms 13 236 37ms 0ms 14 240 35ms 0ms 15 236 37ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 237 35ms 0ms 19 235 36ms 0ms 20 236 36ms 0ms 21 240 38ms 0ms 22 232 34ms 0ms 23 240 35ms 0ms [ User: symmetricds - Total duration: 860ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 860ms - Times executed: 5700 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 21:22:39.309', last_lock_time = '2018-12-08 21:22:39.309' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 19:22:39.309');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 13:48:44.7', last_lock_time = '2018-12-08 13:48:44.7' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 11:48:44.7');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 10:46:33.766', last_lock_time = '2018-12-08 10:46:33.766' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 08:46:33.766');
Date: 2018-12-08 21:23:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:48:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:47:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 5,700 473ms 0ms 6ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 08 00 240 20ms 0ms 01 236 19ms 0ms 02 240 18ms 0ms 03 240 20ms 0ms 04 236 18ms 0ms 05 240 18ms 0ms 06 240 19ms 0ms 07 224 18ms 0ms 08 240 19ms 0ms 09 240 19ms 0ms 10 236 19ms 0ms 11 236 18ms 0ms 12 240 20ms 0ms 13 236 18ms 0ms 14 240 19ms 0ms 15 236 18ms 0ms 16 240 20ms 0ms 17 240 19ms 0ms 18 239 20ms 0ms 19 233 26ms 0ms 20 236 19ms 0ms 21 240 19ms 0ms 22 232 20ms 0ms 23 240 20ms 0ms [ User: symmetricds - Total duration: 473ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 473ms - Times executed: 5700 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
Date: 2018-12-08 19:18:59 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 01:31:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:35:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 5,700 713ms 0ms 5ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 08 00 240 29ms 0ms 01 236 29ms 0ms 02 240 31ms 0ms 03 240 31ms 0ms 04 236 28ms 0ms 05 240 33ms 0ms 06 240 31ms 0ms 07 224 27ms 0ms 08 240 28ms 0ms 09 240 31ms 0ms 10 236 29ms 0ms 11 236 28ms 0ms 12 240 29ms 0ms 13 236 29ms 0ms 14 240 28ms 0ms 15 236 28ms 0ms 16 240 28ms 0ms 17 240 35ms 0ms 18 237 29ms 0ms 19 235 28ms 0ms 20 236 28ms 0ms 21 240 29ms 0ms 22 232 28ms 0ms 23 240 28ms 0ms [ User: symmetricds - Total duration: 713ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - Times executed: 5700 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '62', success_count = '210162', fail_count = '0', total_success_count = '210162', total_fail_count = '0', total_success_millis = '13559797', total_fail_millis = '0', last_lock_time = '2018-12-08 17:12:51.637' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '62', success_count = '209931', fail_count = '0', total_success_count = '209931', total_fail_count = '0', total_success_millis = '13544519', total_fail_millis = '0', last_lock_time = '2018-12-08 05:30:46.527' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '68', success_count = '209958', fail_count = '0', total_success_count = '209958', total_fail_count = '0', total_success_millis = '13546366', total_fail_millis = '0', last_lock_time = '2018-12-08 06:51:48.22' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-12-08 17:12:52 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 05:31:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 06:52:50 Duration: 2ms 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 0ms 95ms 12ms 159 2s37ms 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 #1
Day Hour Count Duration Avg duration Dec 08 01 15 74ms 4ms 02 15 51ms 3ms 03 15 69ms 4ms 04 15 91ms 6ms 05 15 50ms 3ms 06 15 92ms 6ms 07 15 308ms 20ms 08 10 117ms 11ms 09 9 215ms 23ms 10 7 183ms 26ms 11 6 259ms 43ms 12 5 186ms 37ms 13 3 61ms 20ms 14 3 63ms 21ms 15 2 44ms 22ms 16 2 48ms 24ms 17 1 12ms 12ms 18 1 30ms 30ms 19 1 8ms 8ms 20 1 15ms 15ms 21 1 8ms 8ms 22 1 21ms 21ms 23 1 20ms 20ms [ User: symmetricds - Total duration: 2s37ms - Times executed: 159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s37ms - Times executed: 159 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '93208237' AND '93213237' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93208237' AND '93213237' 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 '93213704' AND '93218704' AND create_time < '2018-12-07 12:02:02.633' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213704' AND '93218704' 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 '93213238' AND '93218238' AND create_time < '2018-12-07 11:00:01.259' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '93213238' AND '93218238' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-12-08 11:01:03 Duration: 95ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:02:03 Duration: 78ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:01:03 Duration: 60ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 1ms 13ms 12ms 288 3s494ms 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 #2
Day Hour Count Duration Avg duration Dec 08 00 12 145ms 12ms 01 12 147ms 12ms 02 12 145ms 12ms 03 12 146ms 12ms 04 12 146ms 12ms 05 12 146ms 12ms 06 12 145ms 12ms 07 12 146ms 12ms 08 12 146ms 12ms 09 12 146ms 12ms 10 12 147ms 12ms 11 12 145ms 12ms 12 12 145ms 12ms 13 12 143ms 11ms 14 12 145ms 12ms 15 12 145ms 12ms 16 12 147ms 12ms 17 12 145ms 12ms 18 12 146ms 12ms 19 12 146ms 12ms 20 12 145ms 12ms 21 12 146ms 12ms 22 12 145ms 12ms 23 12 135ms 11ms [ User: tony - Total duration: 3s494ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s494ms - Times executed: 288 ]
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
-
SELECT SUM (xact_commit) AS xact_commit, SUM (xact_rollback) AS xact_rollback, SUM (blks_read) AS blks_read, SUM (blks_hit) AS blks_hit, SUM (tup_returned) AS tup_returned, SUM (tup_fetched) AS tup_fetched, SUM (tup_inserted) AS tup_inserted, SUM (tup_updated) AS tup_updated, SUM (tup_deleted) AS tup_deleted FROM pg_stat_database;
Date: 2018-12-08 09:36:20 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-12-08 16:46:25 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-12-08 14:41:21 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
3 0ms 17ms 6ms 189 1s242ms 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 #3
Day Hour Count Duration Avg duration Dec 08 00 8 51ms 6ms 01 8 50ms 6ms 02 8 49ms 6ms 03 8 46ms 5ms 04 8 59ms 7ms 05 8 49ms 6ms 06 8 56ms 7ms 07 8 56ms 7ms 08 8 54ms 6ms 09 8 56ms 7ms 10 8 39ms 4ms 11 8 52ms 6ms 12 8 56ms 7ms 13 8 52ms 6ms 14 8 56ms 7ms 15 8 57ms 7ms 16 8 52ms 6ms 17 8 57ms 7ms 18 8 58ms 7ms 19 8 45ms 5ms 20 5 37ms 7ms 21 8 50ms 6ms 22 8 45ms 5ms 23 8 50ms 6ms [ User: symmetricds - Total duration: 1s242ms - Times executed: 189 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s242ms - Times executed: 189 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '292707848', "total_memory_bytes" = '535298048', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 03:11:21', "last_restart_time" = '2018-11-20 12:12:12', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '266757928', "total_memory_bytes" = '533725184', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 08:26:21', "last_restart_time" = '2018-11-20 12:12:12', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '393778208', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+00:00', "heartbeat_time" = '2018-12-08 16:51:18', "last_restart_time" = '2018-11-20 13:49:33.42', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2018-12-08 03:12:45 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:27:04 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 16:51:39 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3ms 15ms 5ms 214 1s166ms 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 #4
Day Hour Count Duration Avg duration Dec 08 00 153 664ms 4ms 01 3 14ms 4ms 02 4 34ms 8ms 03 3 26ms 8ms 04 4 22ms 5ms 05 3 26ms 8ms 06 3 26ms 8ms 07 3 26ms 8ms 08 3 25ms 8ms 09 3 27ms 9ms 10 3 27ms 9ms 11 3 22ms 7ms 12 3 26ms 8ms 13 2 12ms 6ms 14 2 17ms 8ms 15 2 18ms 9ms 16 2 18ms 9ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 17ms 8ms 20 3 22ms 7ms 21 2 17ms 8ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 974ms - Times executed: 169 ]
[ User: pharmisight - Total duration: 191ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s166ms - Times executed: 214 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'dlx_barcodes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim (BOTH '"' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-12-08 00:00:33 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 15:15:31 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 21:16:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 7ms 1ms 542 881ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 08 00 22 31ms 1ms 01 8 10ms 1ms 02 5 9ms 1ms 03 1 1ms 1ms 04 17 26ms 1ms 05 18 30ms 1ms 06 17 25ms 1ms 07 25 39ms 1ms 08 48 78ms 1ms 09 35 56ms 1ms 10 22 35ms 1ms 11 23 37ms 1ms 12 24 46ms 1ms 13 20 31ms 1ms 14 22 41ms 1ms 15 17 27ms 1ms 16 36 58ms 1ms 17 16 26ms 1ms 18 27 44ms 1ms 19 32 51ms 1ms 20 25 39ms 1ms 21 23 35ms 1ms 22 30 46ms 1ms 23 29 46ms 1ms [ User: symmetricds - Total duration: 881ms - Times executed: 542 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 881ms - Times executed: 542 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS OID, 1 AS attnum UNION ALL SELECT 16964, 1 UNION ALL SELECT 16964, 4 UNION ALL SELECT 16964, 3 UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16964, 5 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-08 14:47:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:46:41 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:16:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 5ms 1ms 609 875ms 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 #6
Day Hour Count Duration Avg duration Dec 08 00 19 26ms 1ms 01 30 45ms 1ms 02 30 43ms 1ms 03 29 42ms 1ms 04 24 33ms 1ms 05 29 40ms 1ms 06 30 43ms 1ms 07 13 17ms 1ms 08 6 8ms 1ms 09 14 19ms 1ms 10 30 44ms 1ms 11 26 36ms 1ms 12 31 44ms 1ms 13 28 40ms 1ms 14 31 44ms 1ms 15 30 43ms 1ms 16 19 26ms 1ms 17 34 48ms 1ms 18 30 43ms 1ms 19 20 28ms 1ms 20 30 43ms 1ms 21 29 40ms 1ms 22 22 32ms 1ms 23 25 35ms 1ms [ User: symmetricds - Total duration: 875ms - Times executed: 609 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 875ms - Times executed: 609 ]
-
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-12-08 01:00:37 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:49:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 20:17:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 10ms 1ms 1,365 1s447ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 08 00 62 63ms 1ms 01 48 46ms 0ms 02 44 45ms 1ms 03 33 38ms 1ms 04 47 48ms 1ms 05 59 66ms 1ms 06 59 60ms 1ms 07 55 57ms 1ms 08 60 65ms 1ms 09 57 59ms 1ms 10 60 62ms 1ms 11 59 65ms 1ms 12 60 62ms 1ms 13 59 61ms 1ms 14 62 65ms 1ms 15 60 62ms 1ms 16 61 63ms 1ms 17 61 65ms 1ms 18 61 78ms 1ms 19 61 63ms 1ms 20 61 64ms 1ms 21 58 57ms 0ms 22 56 59ms 1ms 23 62 63ms 1ms [ User: symmetricds - Total duration: 1s447ms - Times executed: 1365 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s447ms - Times executed: 1365 ]
-
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-12-08 18:21:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:29:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:10:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 0ms 1,184 1s96ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 08 00 51 46ms 0ms 01 40 37ms 0ms 02 37 34ms 0ms 03 29 29ms 1ms 04 40 40ms 1ms 05 49 44ms 0ms 06 53 48ms 0ms 07 49 45ms 0ms 08 52 46ms 0ms 09 50 46ms 0ms 10 55 50ms 0ms 11 53 50ms 0ms 12 53 48ms 0ms 13 54 48ms 0ms 14 56 50ms 0ms 15 53 47ms 0ms 16 56 51ms 0ms 17 52 48ms 0ms 18 54 49ms 0ms 19 47 44ms 0ms 20 52 47ms 0ms 21 47 43ms 0ms 22 50 46ms 0ms 23 52 48ms 0ms [ User: symmetricds - Total duration: 1s96ms - Times executed: 1184 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s96ms - Times executed: 1184 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16969 AS OID, 1 AS attnum UNION ALL SELECT 16969, 2 UNION ALL SELECT 16969, 3 UNION ALL SELECT 16969, 4 UNION ALL SELECT 16969, 5 UNION ALL SELECT 16969, 6 UNION ALL SELECT 16969, 7 UNION ALL SELECT 16969, 8 UNION ALL SELECT 16969, 9 UNION ALL SELECT 16969, 10 UNION ALL SELECT 16969, 11 UNION ALL SELECT 16969, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-08 04:05:44 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 11:11:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 03:53:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 8ms 0ms 1,657 857ms 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 Dec 08 00 352 201ms 0ms 01 256 113ms 0ms 02 183 48ms 0ms 04 390 188ms 0ms 07 53 33ms 0ms 08 90 61ms 0ms 09 195 102ms 0ms 10 102 71ms 0ms 12 36 36ms 1ms [ User: pharmisight - Total duration: 857ms - Times executed: 1657 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 857ms - Times executed: 1657 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004877274', '2018-12-08 03:40:13', 'DZIEMIN', '2018-12-08 04:00:15.473', '53451', '4', '150505230130291975');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004888547', '2018-12-08 00:01:07', 'RYBAKJ', '2018-12-08 00:20:01.479', '40879', '6', '150505230130276552');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004884171', '2018-12-08 04:21:06', 'KOPACZM', '2018-12-08 04:40:00.042', '49760', '6', '150505230130295683');
Date: 2018-12-08 04:00:15 Duration: 8ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:20:02 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:40:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 4ms 0ms 5,713 1s212ms 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 Dec 08 00 243 49ms 0ms 01 236 48ms 0ms 02 242 51ms 0ms 03 243 54ms 0ms 04 237 46ms 0ms 05 240 53ms 0ms 06 240 51ms 0ms 07 227 46ms 0ms 08 239 50ms 0ms 09 240 50ms 0ms 10 237 49ms 0ms 11 236 48ms 0ms 12 240 49ms 0ms 13 236 49ms 0ms 14 240 49ms 0ms 15 236 50ms 0ms 16 240 48ms 0ms 17 240 49ms 0ms 18 237 51ms 0ms 19 235 54ms 0ms 20 236 52ms 0ms 21 240 53ms 0ms 22 232 50ms 0ms 23 241 51ms 0ms [ User: symmetricds - Total duration: 1s212ms - Times executed: 5713 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s212ms - Times executed: 5713 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-08 19:19:04 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 22:59:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 05:33:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 2ms 0ms 5,700 860ms 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 Dec 08 00 240 33ms 0ms 01 236 32ms 0ms 02 240 34ms 0ms 03 240 41ms 0ms 04 236 34ms 0ms 05 240 35ms 0ms 06 240 36ms 0ms 07 224 33ms 0ms 08 240 34ms 0ms 09 240 37ms 0ms 10 236 37ms 0ms 11 236 35ms 0ms 12 240 35ms 0ms 13 236 37ms 0ms 14 240 35ms 0ms 15 236 37ms 0ms 16 240 32ms 0ms 17 240 37ms 0ms 18 237 35ms 0ms 19 235 36ms 0ms 20 236 36ms 0ms 21 240 38ms 0ms 22 232 34ms 0ms 23 240 35ms 0ms [ User: symmetricds - Total duration: 860ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 860ms - Times executed: 5700 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 21:22:39.309', last_lock_time = '2018-12-08 21:22:39.309' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 19:22:39.309');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 13:48:44.7', last_lock_time = '2018-12-08 13:48:44.7' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 11:48:44.7');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-12-08 10:46:33.766', last_lock_time = '2018-12-08 10:46:33.766' WHERE node_id = '0' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-12-08 08:46:33.766');
Date: 2018-12-08 21:23:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 13:48:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:47:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 5ms 0ms 5,700 713ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 08 00 240 29ms 0ms 01 236 29ms 0ms 02 240 31ms 0ms 03 240 31ms 0ms 04 236 28ms 0ms 05 240 33ms 0ms 06 240 31ms 0ms 07 224 27ms 0ms 08 240 28ms 0ms 09 240 31ms 0ms 10 236 29ms 0ms 11 236 28ms 0ms 12 240 29ms 0ms 13 236 29ms 0ms 14 240 28ms 0ms 15 236 28ms 0ms 16 240 28ms 0ms 17 240 35ms 0ms 18 237 29ms 0ms 19 235 28ms 0ms 20 236 28ms 0ms 21 240 29ms 0ms 22 232 28ms 0ms 23 240 28ms 0ms [ User: symmetricds - Total duration: 713ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 713ms - Times executed: 5700 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '62', success_count = '210162', fail_count = '0', total_success_count = '210162', total_fail_count = '0', total_success_millis = '13559797', total_fail_millis = '0', last_lock_time = '2018-12-08 17:12:51.637' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '62', success_count = '209931', fail_count = '0', total_success_count = '209931', total_fail_count = '0', total_success_millis = '13544519', total_fail_millis = '0', last_lock_time = '2018-12-08 05:30:46.527' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '68', success_count = '209958', fail_count = '0', total_success_count = '209958', total_fail_count = '0', total_success_millis = '13546366', total_fail_millis = '0', last_lock_time = '2018-12-08 06:51:48.22' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
Date: 2018-12-08 17:12:52 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 05:31:48 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 06:52:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 6ms 0ms 5,700 473ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 08 00 240 20ms 0ms 01 236 19ms 0ms 02 240 18ms 0ms 03 240 20ms 0ms 04 236 18ms 0ms 05 240 18ms 0ms 06 240 19ms 0ms 07 224 18ms 0ms 08 240 19ms 0ms 09 240 19ms 0ms 10 236 19ms 0ms 11 236 18ms 0ms 12 240 20ms 0ms 13 236 18ms 0ms 14 240 19ms 0ms 15 236 18ms 0ms 16 240 20ms 0ms 17 240 19ms 0ms 18 239 20ms 0ms 19 233 26ms 0ms 20 236 19ms 0ms 21 240 19ms 0ms 22 232 20ms 0ms 23 240 20ms 0ms [ User: symmetricds - Total duration: 473ms - Times executed: 5700 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 473ms - Times executed: 5700 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
Date: 2018-12-08 19:18:59 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 01:31:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:35:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 3ms 0ms 7,124 560ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 08 00 300 27ms 0ms 01 295 25ms 0ms 02 300 23ms 0ms 03 300 27ms 0ms 04 295 23ms 0ms 05 300 24ms 0ms 06 300 25ms 0ms 07 280 23ms 0ms 08 300 24ms 0ms 09 300 25ms 0ms 10 295 23ms 0ms 11 295 23ms 0ms 12 300 23ms 0ms 13 295 23ms 0ms 14 300 21ms 0ms 15 295 22ms 0ms 16 300 20ms 0ms 17 300 22ms 0ms 18 296 21ms 0ms 19 293 21ms 0ms 20 295 22ms 0ms 21 300 20ms 0ms 22 290 21ms 0ms 23 300 22ms 0ms [ User: symmetricds - Total duration: 560ms - Times executed: 7124 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 560ms - Times executed: 7124 ]
-
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-12-08 00:12:34 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 09:21:30 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 07:14:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 11,401 747ms 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 Dec 08 00 481 30ms 0ms 01 472 26ms 0ms 02 480 30ms 0ms 03 480 32ms 0ms 04 472 29ms 0ms 05 480 33ms 0ms 06 480 31ms 0ms 07 448 28ms 0ms 08 480 30ms 0ms 09 480 31ms 0ms 10 472 35ms 0ms 11 472 29ms 0ms 12 480 30ms 0ms 13 472 31ms 0ms 14 480 29ms 0ms 15 472 30ms 0ms 16 480 32ms 0ms 17 480 31ms 0ms 18 476 33ms 0ms 19 468 33ms 0ms 20 472 31ms 0ms 21 480 30ms 0ms 22 464 31ms 0ms 23 480 30ms 0ms [ User: symmetricds - Total duration: 747ms - Times executed: 11401 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 747ms - Times executed: 11401 ]
-
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-12-08 16:21:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:19:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:52:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 8,493 466ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 08 00 355 20ms 0ms 01 355 20ms 0ms 02 354 20ms 0ms 03 358 20ms 0ms 04 352 20ms 0ms 05 357 20ms 0ms 06 358 21ms 0ms 07 336 18ms 0ms 08 358 19ms 0ms 09 357 19ms 0ms 10 352 19ms 0ms 11 351 18ms 0ms 12 358 18ms 0ms 13 353 19ms 0ms 14 356 19ms 0ms 15 351 18ms 0ms 16 358 19ms 0ms 17 357 18ms 0ms 18 357 18ms 0ms 19 347 18ms 0ms 20 353 19ms 0ms 21 358 18ms 0ms 22 346 18ms 0ms 23 356 18ms 0ms [ User: symmetricds - Total duration: 466ms - Times executed: 8493 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 466ms - Times executed: 8493 ]
-
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-12-08 06:46:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:12:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:44:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 3ms 0ms 35,706 1s890ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 08 00 2,637 127ms 0ms 01 1,425 57ms 0ms 02 1,758 74ms 0ms 03 879 40ms 0ms 04 1,758 81ms 0ms 05 879 49ms 0ms 06 879 52ms 0ms 07 879 50ms 0ms 08 1,758 101ms 0ms 09 1,758 87ms 0ms 10 1,758 101ms 0ms 11 1,758 99ms 0ms 12 1,758 100ms 0ms 13 1,758 101ms 0ms 14 879 51ms 0ms 15 879 49ms 0ms 16 879 52ms 0ms 17 1,758 109ms 0ms 18 1,758 94ms 0ms 19 1,758 99ms 0ms 20 1,758 82ms 0ms 21 879 49ms 0ms 22 1,758 99ms 0ms 23 1,758 75ms 0ms [ User: pharmisight - Total duration: 1s890ms - Times executed: 35706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 35706 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '33074340' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3393' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '32994465' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-12-08 18:00:02 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 16:21:03 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 12:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 40,261 2s83ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 08 00 2,973 140ms 0ms 01 1,612 62ms 0ms 02 1,982 82ms 0ms 03 991 44ms 0ms 04 1,982 89ms 0ms 05 991 55ms 0ms 06 991 57ms 0ms 07 991 55ms 0ms 08 1,982 111ms 0ms 09 1,982 96ms 0ms 10 1,982 111ms 0ms 11 1,982 110ms 0ms 12 1,982 109ms 0ms 13 1,982 114ms 0ms 14 991 57ms 0ms 15 991 54ms 0ms 16 991 57ms 0ms 17 1,982 121ms 0ms 18 1,982 100ms 0ms 19 1,982 109ms 0ms 20 1,982 91ms 0ms 21 991 54ms 0ms 22 1,982 110ms 0ms 23 1,982 83ms 0ms [ User: pharmisight - Total duration: 2s83ms - Times executed: 40261 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s83ms - Times executed: 40261 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2991' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '32965305' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3418' ORDER BY itemcodes0_.code ASC;
Date: 2018-12-08 13:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 02:21:02 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 04:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 5ms 0ms 15,962 805ms 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 Dec 08 00 701 33ms 0ms 01 664 32ms 0ms 02 668 31ms 0ms 03 672 33ms 0ms 04 661 33ms 0ms 05 671 33ms 0ms 06 672 33ms 0ms 07 630 30ms 0ms 08 672 31ms 0ms 09 671 35ms 0ms 10 662 34ms 0ms 11 661 31ms 0ms 12 671 33ms 0ms 13 660 32ms 0ms 14 668 31ms 0ms 15 658 33ms 0ms 16 670 33ms 0ms 17 669 32ms 0ms 18 665 35ms 0ms 19 653 35ms 0ms 20 657 32ms 0ms 21 670 40ms 0ms 22 648 32ms 0ms 23 668 34ms 0ms [ User: symmetricds - Total duration: 805ms - Times executed: 15962 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 805ms - Times executed: 15962 ]
-
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-12-08 21:23:43 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 10:06:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 09:40:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 76,437 3s474ms 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 Dec 08 00 3,195 145ms 0ms 01 3,195 142ms 0ms 02 3,186 141ms 0ms 03 3,222 146ms 0ms 04 3,168 145ms 0ms 05 3,213 144ms 0ms 06 3,222 146ms 0ms 07 3,024 138ms 0ms 08 3,222 149ms 0ms 09 3,213 143ms 0ms 10 3,168 143ms 0ms 11 3,159 144ms 0ms 12 3,222 149ms 0ms 13 3,177 141ms 0ms 14 3,204 144ms 0ms 15 3,159 144ms 0ms 16 3,222 149ms 0ms 17 3,213 144ms 0ms 18 3,213 145ms 0ms 19 3,123 141ms 0ms 20 3,177 147ms 0ms 21 3,222 147ms 0ms 22 3,114 141ms 0ms 23 3,204 145ms 0ms [ User: symmetricds - Total duration: 3s474ms - Times executed: 76437 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s474ms - Times executed: 76437 ]
-
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-12-08 17:51:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 00:36:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-08 08:10:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,622,803 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 41 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 39 Max number of times the same event was reported
- 41 Total events found
Rank Times reported Error 1 39 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 08 07 39 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind IN ('r','p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
Date: 2018-12-08 07:41:02 Database: pharmisight Application: PostgreSQL JDBC Driver User: pharmisight Remote: 10.10.10.1 Code:
2 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 08 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-12-08 00:00:21 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code:
3 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 08 07 1 - ERROR: duplicate key value violates unique constraint "dlx_barcodes_pkey"
Detail: Key (dlx_barcode)=(150505230130307331) already exists.
Statement: insert into DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) values ($1, $2, $3, $4, $5, $6, $7)Date: 2018-12-08 07:41:01 Database: pharmisight Application: PostgreSQL JDBC Driver User: pharmisight Remote: 10.10.10.1 Code: