pgBadger-
Global information
- Generated on Sun Aug 19 00:00:43 2018
- Log file: /var/log/postgresql/postgresql-9.6-main.log.1
- Parsed 6,478,146 log entries in 41s
- Log start from 2018-08-18 00:00:00 to 2018-08-18 23:59:59
-
Overview
Global Stats
- 177 Number of unique normalized queries
- 2,223,615 Number of queries
- 1m8s Total query duration
- 2018-08-18 00:00:00 First query
- 2018-08-18 23:59:59 Last query
- 1,586 queries/s at 2018-08-18 03:40:00 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 285 Total number of automatic vacuums
- 304 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,562 Total number of sessions
- 3 sessions at 2018-08-18 13:46:02 Session peak
- 10d1h41m14s Total duration of sessions
- 9m17s Average duration of sessions
- 1,423 Average queries per session
- 44ms Average queries duration per session
- 1,562 Total number of connections
- 6 connections/s at 2018-08-18 00:00:11 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,586 queries/s Query Peak
- 2018-08-18 03:40:00 Date
SELECT Traffic
Key values
- 1,531 queries/s Query Peak
- 2018-08-18 15:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 539 queries/s Query Peak
- 2018-08-18 00:00:23 Date
Queries duration
Key values
- 1m8s Total query duration
Prepared queries ratio
Key values
- 1.69 Ratio of bind vs prepare
- 164.24 % 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) Aug 18 00 105,817 0ms 83ms 0ms 84ms 192ms 1s871ms 01 93,378 0ms 67ms 0ms 69ms 200ms 328ms 02 92,774 0ms 14ms 0ms 63ms 105ms 285ms 03 93,326 0ms 20ms 0ms 59ms 202ms 313ms 04 92,786 0ms 17ms 0ms 67ms 90ms 350ms 05 93,247 0ms 30ms 0ms 66ms 171ms 370ms 06 92,247 0ms 20ms 0ms 66ms 101ms 265ms 07 92,317 0ms 134ms 0ms 62ms 81ms 679ms 08 92,841 0ms 82ms 0ms 55ms 93ms 418ms 09 92,857 0ms 90ms 0ms 55ms 110ms 535ms 10 91,326 0ms 84ms 0ms 58ms 74ms 366ms 11 91,460 0ms 77ms 0ms 63ms 70ms 285ms 12 91,373 0ms 66ms 0ms 55ms 61ms 233ms 13 91,620 0ms 61ms 0ms 67ms 79ms 210ms 14 91,376 0ms 57ms 0ms 68ms 78ms 161ms 15 91,490 0ms 36ms 0ms 58ms 79ms 151ms 16 91,415 0ms 38ms 0ms 58ms 81ms 161ms 17 91,404 0ms 31ms 0ms 55ms 78ms 163ms 18 91,297 0ms 21ms 0ms 52ms 77ms 154ms 19 91,476 0ms 18ms 0ms 56ms 78ms 163ms 20 92,366 0ms 33ms 0ms 57ms 86ms 470ms 21 91,677 0ms 16ms 0ms 55ms 74ms 154ms 22 91,859 0ms 39ms 0ms 54ms 76ms 159ms 23 91,886 0ms 36ms 0ms 61ms 68ms 167ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 18 00 35,846 0 0ms 29ms 41ms 171ms 01 31,007 0 0ms 31ms 34ms 60ms 02 30,828 0 0ms 33ms 38ms 51ms 03 30,963 0 0ms 33ms 35ms 57ms 04 30,846 0 0ms 27ms 32ms 64ms 05 31,003 0 0ms 30ms 36ms 68ms 06 30,693 0 0ms 27ms 33ms 46ms 07 30,751 0 0ms 28ms 32ms 62ms 08 30,835 0 0ms 28ms 33ms 52ms 09 30,888 0 0ms 28ms 35ms 82ms 10 30,432 0 0ms 28ms 32ms 60ms 11 30,478 0 0ms 29ms 31ms 43ms 12 30,351 0 0ms 27ms 28ms 41ms 13 30,563 0 0ms 27ms 36ms 42ms 14 30,433 0 0ms 28ms 37ms 46ms 15 30,454 0 0ms 30ms 38ms 43ms 16 30,429 0 0ms 29ms 38ms 39ms 17 30,425 0 0ms 27ms 32ms 46ms 18 30,404 0 0ms 27ms 31ms 47ms 19 30,481 0 0ms 27ms 31ms 49ms 20 31,111 0 0ms 28ms 34ms 147ms 21 30,517 0 0ms 28ms 30ms 48ms 22 30,588 0 0ms 28ms 34ms 62ms 23 30,592 0 0ms 27ms 32ms 41ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 18 00 2,000 2,267 103 0 0ms 11ms 16ms 98ms 01 878 814 108 0 0ms 1ms 8ms 63ms 02 529 724 100 0 0ms 1ms 8ms 34ms 03 876 811 104 0 0ms 1ms 9ms 48ms 04 581 739 107 0 0ms 1ms 8ms 43ms 05 733 775 102 0 0ms 1ms 9ms 54ms 06 270 648 102 0 0ms 1ms 7ms 20ms 07 297 667 106 0 0ms 1ms 8ms 23ms 08 657 743 95 0 0ms 1ms 7ms 36ms 09 538 727 90 0 0ms 1ms 9ms 41ms 10 77 570 85 0 0ms 1ms 2ms 11ms 11 78 572 85 0 0ms 1ms 3ms 10ms 12 80 573 87 0 0ms 1ms 2ms 10ms 13 79 571 79 0 0ms 1ms 6ms 10ms 14 79 572 80 0 0ms 1ms 3ms 10ms 15 79 572 80 0 0ms 1ms 3ms 9ms 16 79 572 77 0 0ms 1ms 2ms 10ms 17 77 571 79 0 0ms 1ms 2ms 10ms 18 78 570 75 0 0ms 1ms 2ms 10ms 19 78 581 77 0 0ms 1ms 2ms 10ms 20 123 619 121 0 0ms 1ms 4ms 10ms 21 88 581 81 0 0ms 1ms 3ms 11ms 22 88 581 81 0 0ms 1ms 4ms 10ms 23 88 582 81 0 0ms 1ms 7ms 11ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 18 00 61,105 105,781 1.73 90.72% 01 55,646 93,342 1.68 97.40% 02 55,121 92,738 1.68 97.52% 03 55,202 93,290 1.69 96.70% 04 55,215 92,750 1.68 97.59% 05 55,828 93,211 1.67 98.01% 06 54,788 92,211 1.68 97.81% 07 54,890 92,281 1.68 97.80% 08 55,260 92,805 1.68 97.60% 09 55,885 92,821 1.66 98.75% 10 54,250 91,290 1.68 98.13% 11 54,153 91,424 1.69 97.79% 12 52,969 91,337 1.72 95.82% 13 54,986 91,584 1.67 99.12% 14 54,107 91,340 1.69 97.83% 15 53,978 91,454 1.69 97.49% 16 53,645 91,379 1.70 96.95% 17 53,884 91,368 1.70 97.43% 18 54,012 91,261 1.69 97.76% 19 54,109 91,440 1.69 97.72% 20 54,319 92,330 1.70 96.63% 21 53,957 91,641 1.70 97.19% 22 54,189 91,823 1.69 97.42% 23 54,100 91,850 1.70 97.23% Day Hour Count Average / Second Aug 18 00 71 0.02/s 01 82 0.02/s 02 72 0.02/s 03 69 0.02/s 04 78 0.02/s 05 87 0.02/s 06 72 0.02/s 07 71 0.02/s 08 73 0.02/s 09 82 0.02/s 10 63 0.02/s 11 54 0.01/s 12 40 0.01/s 13 73 0.02/s 14 60 0.02/s 15 58 0.02/s 16 49 0.01/s 17 60 0.02/s 18 60 0.02/s 19 62 0.02/s 20 55 0.02/s 21 54 0.01/s 22 59 0.02/s 23 58 0.02/s Day Hour Count Average Duration Aug 18 00 71 8m59s 01 82 7m22s 02 72 8m13s 03 69 8m30s 04 78 8m6s 05 87 6m50s 06 72 8m14s 07 71 8m27s 08 73 8m8s 09 82 7m49s 10 63 8m16s 11 54 11m12s 12 40 13m56s 13 73 9m18s 14 60 10m7s 15 58 10m51s 16 49 11m15s 17 60 10m37s 18 60 9m57s 19 62 9m15s 20 55 11m38s 21 54 11m40s 22 59 10m14s 23 58 10m5s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2018-08-18 00:00:11 Date
Connections per database
Key values
- pharmisight Main Database
- 1,562 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,562 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2018-08-18 13:46:02 Date
Histogram of session times
Key values
- 777 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,562 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,562 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,562 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 4,797 buffers Checkpoint Peak
- 2018-08-18 07:03:08 Date
- 149.738 seconds Highest write time
- 0.023 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2018-08-18 07:06:59 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 Aug 18 00 2,101 210.444s 0.013s 210.495s 01 3,333 220.689s 0.013s 220.739s 02 677 67.915s 0.013s 67.966s 03 745 74.735s 0.023s 74.796s 04 950 95.187s 0.015s 95.243s 05 742 74.321s 0.017s 74.377s 06 639 64.095s 0.02s 64.159s 07 6,056 275.535s 0.036s 275.611s 08 2,151 210.951s 0.013s 211.007s 09 2,762 209.421s 0.025s 209.491s 10 1,659 165.724s 0.017s 165.781s 11 1,360 136.098s 0.013s 136.152s 12 1,232 123.149s 0.014s 123.202s 13 1,465 146.322s 0.013s 146.375s 14 872 87.448s 0.022s 87.509s 15 1,018 102.001s 0.014s 102.052s 16 815 81.655s 0.011s 81.706s 17 750 75.224s 0.016s 75.276s 18 693 69.489s 0.011s 69.538s 19 599 60.073s 0.013s 60.127s 20 651 65.307s 0.021s 65.373s 21 686 68.813s 0.012s 68.865s 22 722 72.411s 0.016s 72.475s 23 917 91.964s 0.013s 92.013s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 18 00 0 0 1 354 0.002s 0s 01 0 0 1 315 0.002s 0s 02 0 0 0 294 0.002s 0s 03 0 0 0 307 0.008s 0s 04 0 0 1 324 0.003s 0s 05 0 0 0 321 0.002s 0s 06 0 0 0 292 0.008s 0s 07 0 0 3 319 0.023s 0.004s 08 0 0 0 320 0.002s 0s 09 0 0 1 348 0.008s 0s 10 0 0 0 266 0.002s 0s 11 0 0 1 289 0.002s 0s 12 0 0 0 269 0.002s 0s 13 0 0 1 295 0.002s 0s 14 0 0 0 289 0.008s 0s 15 0 0 0 292 0.002s 0s 16 0 0 1 290 0.002s 0s 17 0 0 0 284 0.005s 0s 18 0 0 0 273 0.002s 0s 19 0 0 0 278 0.002s 0s 20 0 0 0 348 0.008s 0s 21 0 0 0 342 0.002s 0s 22 0 0 1 353 0.002s 0s 23 0 0 0 355 0.002s 0s Day Hour Count Avg time (sec) Aug 18 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 Aug 18 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 Aug 18 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
- 8.23 sec Highest CPU-cost vacuum
Table public.sym_data_event
Database pharmisight - 2018-08-18 01:01:08 Date
- 2.64 sec Highest CPU-cost analyze
Table public.sym_data
Database pharmisight - 2018-08-18 07:00:10 Date
Analyzes per table
Key values
- public.sym_node_communication (209) Main table analyzed (database pharmisight)
- 304 analyzes Total
Table Number of analyzes pharmisight.public.sym_node_communication 209 pharmisight.public.sym_outgoing_batch 17 pharmisight.public.sym_data 13 pharmisight.public.sym_data_event 13 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_lock 11 pharmisight.public.sym_data_gap 9 pharmisight.public.sym_sequence 7 pharmisight.public.sym_node_host 6 pharmisight.public.sym_node_channel_ctl 3 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_months 1 pharmisight.public.flow_report_summary_delays 1 Total 304 Vacuums per table
Key values
- public.sym_node_communication (206) Main table vacuumed on database pharmisight
- 285 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_node_communication 206 0 pharmisight.public.sym_data_event 12 12 pharmisight.public.sym_data 12 12 pharmisight.public.sym_outgoing_batch 12 12 pharmisight.public.sym_lock 11 0 pharmisight.public.sym_sequence 7 0 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_gap 4 4 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.sym_node_channel_ctl 2 0 pharmisight.public.flow_report_summary_months 1 1 pharmisight.public.item_codes 1 1 Total 285 53 Tuples removed per table
Key values
- public.sym_data_event (36440) Main table with removed tuples on database pharmisight
- 75397 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 12 12 36440 584 pharmisight.public.sym_data 12 12 18173 3587 pharmisight.public.sym_node_communication 206 0 11504 0 pharmisight.public.sym_outgoing_batch 12 12 5307 5 pharmisight.public.sym_incoming_batch 6 6 1050 0 pharmisight.pg_catalog.pg_statistic 3 3 896 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.public.sym_sequence 7 0 359 0 pharmisight.public.sym_node_host 6 0 315 0 pharmisight.public.item_codes 1 1 287 0 pharmisight.public.sym_data_gap 4 4 205 0 pharmisight.pg_toast.pg_toast_2619 2 2 170 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 pharmisight.public.flow_report_summary_months 1 1 13 0 Total 285 53 75,397 4,176 Pages removed per table
Key values
- public.sym_data (3587) Main table with removed pages on database pharmisight
- 4176 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 12 12 18173 3587 pharmisight.public.sym_data_event 12 12 36440 584 pharmisight.public.sym_outgoing_batch 12 12 5307 5 pharmisight.public.sym_node_host 6 0 315 0 pharmisight.public.sym_incoming_batch 6 6 1050 0 pharmisight.pg_catalog.pg_statistic 3 3 896 0 pharmisight.public.sym_data_gap 4 4 205 0 pharmisight.public.sym_sequence 7 0 359 0 pharmisight.public.sym_lock 11 0 572 0 pharmisight.pg_toast.pg_toast_2619 2 2 170 0 pharmisight.public.sym_node_channel_ctl 2 0 106 0 pharmisight.public.sym_node_communication 206 0 11504 0 pharmisight.public.flow_report_summary_months 1 1 13 0 pharmisight.public.item_codes 1 1 287 0 Total 285 53 75,397 4,176 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 18 00 13 15 01 13 11 02 10 11 03 10 10 04 10 11 05 10 11 06 11 11 07 12 16 08 11 11 09 15 17 10 11 13 11 15 13 12 12 14 13 15 14 14 14 12 15 12 15 16 12 13 17 13 12 18 10 14 19 12 9 20 11 12 21 10 15 22 11 13 23 12 11 - 8.23 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
- 740,918 Total read queries
- 612,401 Total write queries
Queries by database
Key values
- pharmisight Main database
- 2,223,615 Requests
- 1m8s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 2,261,451 Requests
User Request type Count Duration pharmisight Total 54,472 5s157ms DELETE 42 3ms INSERT 1,817 1s195ms OTHERS 1,815 58ms SELECT 50,182 3s821ms TCL 560 70ms UPDATE 56 7ms symmetricds Total 2,261,451 1m1s DDL 1 1ms DELETE 2,210 3s796ms INSERT 7,689 913ms OTHERS 904,682 16s561ms SELECT 720,692 26s650ms TCL 608,405 9s397ms UPDATE 17,772 4s471ms tony Total 900 4s545ms SELECT 900 4s545ms Duration by user
Key values
- 1m1s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 54,472 5s157ms DELETE 42 3ms INSERT 1,817 1s195ms OTHERS 1,815 58ms SELECT 50,182 3s821ms TCL 560 70ms UPDATE 56 7ms symmetricds Total 2,261,451 1m1s DDL 1 1ms DELETE 2,210 3s796ms INSERT 7,689 913ms OTHERS 904,682 16s561ms SELECT 720,692 26s650ms TCL 608,405 9s397ms UPDATE 17,772 4s471ms tony Total 900 4s545ms SELECT 900 4s545ms Queries by host
Key values
- 10.10.10.1 Main host
- 2,315,923 Requests
- 1m6s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 2,221,477 Requests
- 1m4s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-08-18 06:46:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,219,117 0-1ms duration
Slowest individual queries
Rank Duration Query 1 134ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7873947' AND '7874568' AND STATUS != 'OK') AND batch_id BETWEEN '7873947' AND '7874568';[ Date: 2018-08-18 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 90ms DELETE FROM sym_data WHERE data_id BETWEEN '87766547' AND '87771547' AND create_time < '2018-08-17 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 84ms DELETE FROM sym_data WHERE data_id BETWEEN '87773276' AND '87778276' AND create_time < '2018-08-17 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 83ms DELETE FROM sym_data WHERE data_id BETWEEN '87733788' AND '87738788' AND create_time < '2018-08-17 00:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 82ms DELETE FROM sym_data WHERE data_id BETWEEN '87760500' AND '87765500' AND create_time < '2018-08-17 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87760500' AND '87765500') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87760500' AND '87765500' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 77ms DELETE FROM sym_data WHERE data_id BETWEEN '87777626' AND '87782626' AND create_time < '2018-08-17 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87777626' AND '87782626') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87777626' AND '87782626' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 67ms DELETE FROM sym_data WHERE data_id BETWEEN '87734241' AND '87739241' AND create_time < '2018-08-17 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87734241' AND '87739241') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87734241' AND '87739241' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 67ms DELETE FROM sym_data WHERE data_id BETWEEN '87735364' AND '87740364' AND create_time < '2018-08-17 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87735364' AND '87740364') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87735364' AND '87740364' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 66ms DELETE FROM sym_data WHERE data_id BETWEEN '87781861' AND '87786861' AND create_time < '2018-08-17 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87781861' AND '87786861') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87781861' AND '87786861' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 63ms DELETE FROM sym_data WHERE data_id BETWEEN '87771548' AND '87776548' AND create_time < '2018-08-17 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87771548' AND '87776548') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87771548' AND '87776548' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 61ms DELETE FROM sym_data WHERE data_id BETWEEN '87784686' AND '87789686' AND create_time < '2018-08-17 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87784686' AND '87789686') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87784686' AND '87789686' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 57ms DELETE FROM sym_data WHERE data_id BETWEEN '87789672' AND '87794672' AND create_time < '2018-08-17 14:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87789672' AND '87794672') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87789672' AND '87794672' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 54ms DELETE FROM sym_data WHERE data_id BETWEEN '87740365' AND '87745365' AND create_time < '2018-08-17 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87740365' AND '87745365') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87740365' AND '87745365' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 50ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7874569' AND '7875218' AND STATUS != 'OK') AND batch_id BETWEEN '7874569' AND '7875218';[ Date: 2018-08-18 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 46ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '7875219' AND '7875886' AND STATUS != 'OK') AND batch_id BETWEEN '7875219' AND '7875886';[ Date: 2018-08-18 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 45ms DELETE FROM sym_outgoing_batch WHERE STATUS = 'OK' AND batch_id BETWEEN '7873947' AND '7874568' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '7873947' AND '7874568');[ Date: 2018-08-18 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 45ms DELETE FROM sym_data WHERE data_id BETWEEN '87765501' AND '87770501' AND create_time < '2018-08-17 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87765501' AND '87770501') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87765501' AND '87770501' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 44ms DELETE FROM sym_data WHERE data_id BETWEEN '87745366' AND '87750366' AND create_time < '2018-08-17 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87745366' AND '87750366') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87745366' AND '87750366' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 39ms DELETE FROM sym_data WHERE data_id BETWEEN '87795031' AND '87797590' AND create_time < '2018-08-17 22:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87795031' AND '87797590') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87795031' AND '87797590' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 22:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 38ms DELETE FROM sym_data WHERE data_id BETWEEN '87792592' AND '87797519' AND create_time < '2018-08-17 16:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87792592' AND '87797519') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87792592' AND '87797519' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));[ Date: 2018-08-18 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15s876ms 867,748 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 18 00 38,342 686ms 0ms 01 36,104 650ms 0ms 02 36,132 661ms 0ms 03 36,126 649ms 0ms 04 36,078 642ms 0ms 05 36,138 631ms 0ms 06 36,115 664ms 0ms 07 36,075 654ms 0ms 08 36,100 654ms 0ms 09 36,126 639ms 0ms 10 35,942 665ms 0ms 11 36,001 651ms 0ms 12 36,036 673ms 0ms 13 36,026 659ms 0ms 14 35,974 663ms 0ms 15 36,033 688ms 0ms 16 36,010 661ms 0ms 17 36,003 662ms 0ms 18 35,949 647ms 0ms 19 36,003 662ms 0ms 20 36,064 653ms 0ms 21 36,078 687ms 0ms 22 36,139 693ms 0ms 23 36,154 672ms 0ms [ User: symmetricds - Total duration: 15s854ms - Times executed: 867167 ]
[ User: pharmisight - Total duration: 21ms - Times executed: 581 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s876ms - Times executed: 867748 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-08-18 12:00:41 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:42:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 02:33:27 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s277ms 292,341 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 18 00 13,570 656ms 0ms 01 12,163 296ms 0ms 02 12,171 313ms 0ms 03 12,166 299ms 0ms 04 12,151 312ms 0ms 05 12,173 308ms 0ms 06 12,150 297ms 0ms 07 12,151 296ms 0ms 08 12,144 286ms 0ms 09 12,175 308ms 0ms 10 12,059 273ms 0ms 11 12,081 272ms 0ms 12 12,095 279ms 0ms 13 12,090 274ms 0ms 14 12,071 271ms 0ms 15 12,090 270ms 0ms 16 12,087 282ms 0ms 17 12,076 270ms 0ms 18 12,063 271ms 0ms 19 12,078 279ms 0ms 20 12,121 280ms 0ms 21 12,124 285ms 0ms 22 12,144 286ms 0ms 23 12,148 300ms 0ms [ User: symmetricds - Total duration: 7s211ms - Times executed: 292069 ]
[ User: pharmisight - Total duration: 65ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s277ms - Times executed: 292341 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-08-18 00:06:12 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:37:15 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:15:37 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s722ms 384,356 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 00 17,805 214ms 0ms 01 15,999 192ms 0ms 02 16,002 192ms 0ms 03 16,009 194ms 0ms 04 15,983 191ms 0ms 05 16,010 191ms 0ms 06 15,985 200ms 0ms 07 15,983 198ms 0ms 08 15,969 192ms 0ms 09 16,000 191ms 0ms 10 15,857 198ms 0ms 11 15,898 194ms 0ms 12 15,911 201ms 0ms 13 15,897 192ms 0ms 14 15,871 198ms 0ms 15 15,898 199ms 0ms 16 15,893 196ms 0ms 17 15,882 200ms 0ms 18 15,854 193ms 0ms 19 15,883 194ms 0ms 20 15,920 194ms 0ms 21 15,928 196ms 0ms 22 15,956 202ms 0ms 23 15,963 199ms 0ms [ User: symmetricds - Total duration: 4s722ms - Times executed: 384356 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s722ms - Times executed: 384356 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-08-18 12:14:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:50:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 15:45:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3s540ms 77,247 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 00 3,204 145ms 0ms 01 3,213 147ms 0ms 02 3,222 149ms 0ms 03 3,222 150ms 0ms 04 3,213 143ms 0ms 05 3,222 147ms 0ms 06 3,222 149ms 0ms 07 3,213 148ms 0ms 08 3,222 148ms 0ms 09 3,222 144ms 0ms 10 3,213 146ms 0ms 11 3,222 148ms 0ms 12 3,222 149ms 0ms 13 3,222 150ms 0ms 14 3,213 146ms 0ms 15 3,222 144ms 0ms 16 3,222 146ms 0ms 17 3,222 147ms 0ms 18 3,213 147ms 0ms 19 3,222 149ms 0ms 20 3,222 148ms 0ms 21 3,213 144ms 0ms 22 3,222 148ms 0ms 23 3,222 148ms 0ms [ User: symmetricds - Total duration: 3s540ms - Times executed: 77247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s540ms - Times executed: 77247 ]
-
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-08-18 12:30:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:51:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 15:31:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s467ms 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 #5
Day Hour Count Duration Avg duration Aug 18 00 12 144ms 12ms 01 12 144ms 12ms 02 12 145ms 12ms 03 12 144ms 12ms 04 12 145ms 12ms 05 12 144ms 12ms 06 12 146ms 12ms 07 12 146ms 12ms 08 12 146ms 12ms 09 12 145ms 12ms 10 12 145ms 12ms 11 12 145ms 12ms 12 12 135ms 11ms 13 12 125ms 10ms 14 12 146ms 12ms 15 12 145ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 146ms 12ms 19 12 145ms 12ms 20 12 145ms 12ms 21 12 145ms 12ms 22 12 146ms 12ms 23 12 146ms 12ms [ User: tony - Total duration: 3s467ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s467ms - 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-08-18 08:16:14 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-18 07:56:14 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-18 16:36:13 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
6 2s448ms 147 0ms 90ms 16ms DELETE FROM sym_data WHERE data_id BETWEEN '' AND '' AND create_time < '' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '' AND '' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != '')));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 18 00 13 149ms 11ms 01 13 134ms 10ms 02 13 47ms 3ms 03 13 91ms 7ms 04 13 85ms 6ms 05 13 128ms 9ms 06 13 82ms 6ms 07 13 293ms 22ms 08 8 254ms 31ms 09 7 266ms 38ms 10 5 204ms 40ms 11 4 155ms 38ms 12 4 113ms 28ms 13 3 98ms 32ms 14 2 70ms 35ms 15 2 37ms 18ms 16 1 38ms 38ms 17 1 31ms 31ms 18 1 21ms 21ms 19 1 17ms 17ms 20 1 32ms 32ms 21 1 16ms 16ms 22 1 39ms 39ms 23 1 36ms 36ms [ User: symmetricds - Total duration: 2s448ms - Times executed: 147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s448ms - Times executed: 147 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '87766547' AND '87771547' AND create_time < '2018-08-17 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547' 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 '87773276' AND '87778276' AND create_time < '2018-08-17 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276' 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 '87733788' AND '87738788' AND create_time < '2018-08-17 00:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-08-18 09:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 10:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:00:00 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s818ms 292,342 0ms 3ms 0ms BEGIN;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 18 00 13,570 82ms 0ms 01 12,164 73ms 0ms 02 12,170 73ms 0ms 03 12,166 75ms 0ms 04 12,152 74ms 0ms 05 12,173 73ms 0ms 06 12,149 75ms 0ms 07 12,152 75ms 0ms 08 12,145 75ms 0ms 09 12,173 73ms 0ms 10 12,059 79ms 0ms 11 12,081 75ms 0ms 12 12,095 79ms 0ms 13 12,090 75ms 0ms 14 12,071 75ms 0ms 15 12,090 76ms 0ms 16 12,087 75ms 0ms 17 12,077 76ms 0ms 18 12,062 72ms 0ms 19 12,078 75ms 0ms 20 12,121 75ms 0ms 21 12,124 76ms 0ms 22 12,144 75ms 0ms 23 12,149 75ms 0ms [ User: symmetricds - Total duration: 1s816ms - Times executed: 292070 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s818ms - Times executed: 292342 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-08-18 12:33:42 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 10:25:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:40:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s578ms 68,669 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 00 2,851 69ms 0ms 01 2,857 67ms 0ms 02 2,864 66ms 0ms 03 2,865 67ms 0ms 04 2,856 66ms 0ms 05 2,864 68ms 0ms 06 2,864 66ms 0ms 07 2,856 66ms 0ms 08 2,865 67ms 0ms 09 2,864 65ms 0ms 10 2,856 64ms 0ms 11 2,864 65ms 0ms 12 2,863 64ms 0ms 13 2,864 64ms 0ms 14 2,856 65ms 0ms 15 2,864 64ms 0ms 16 2,864 64ms 0ms 17 2,864 64ms 0ms 18 2,856 64ms 0ms 19 2,864 64ms 0ms 20 2,864 64ms 0ms 21 2,856 64ms 0ms 22 2,864 65ms 0ms 23 2,864 64ms 0ms [ User: symmetricds - Total duration: 1s578ms - Times executed: 68669 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s578ms - Times executed: 68669 ]
-
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 '87795998' AND '137795997')) 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 '87796945' AND '137796944')) 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 '87796586' AND '137796585')) ORDER BY d.data_id ASC;
Date: 2018-08-18 00:40:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 05:20:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s362ms 23,712 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 18 00 988 55ms 0ms 01 988 59ms 0ms 02 988 55ms 0ms 03 988 57ms 0ms 04 988 56ms 0ms 05 988 54ms 0ms 06 988 61ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 55ms 0ms 11 988 56ms 0ms 12 988 56ms 0ms 13 988 58ms 0ms 14 988 55ms 0ms 15 988 55ms 0ms 16 988 58ms 0ms 17 988 56ms 0ms 18 988 55ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 55ms 0ms 22 988 56ms 0ms 23 988 56ms 0ms [ User: pharmisight - Total duration: 1s362ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s362ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3313' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '30' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s287ms 5,812 0ms 3ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 18 00 244 52ms 0ms 01 241 49ms 0ms 02 241 51ms 0ms 03 240 49ms 0ms 04 241 51ms 0ms 05 242 49ms 0ms 06 249 56ms 0ms 07 240 52ms 0ms 08 241 49ms 0ms 09 240 54ms 0ms 10 241 57ms 0ms 11 239 58ms 0ms 12 245 59ms 0ms 13 241 53ms 0ms 14 240 53ms 0ms 15 242 55ms 0ms 16 243 54ms 0ms 17 245 55ms 0ms 18 241 49ms 0ms 19 241 54ms 0ms 20 244 50ms 0ms 21 242 55ms 0ms 22 246 58ms 0ms 23 243 55ms 0ms [ User: symmetricds - Total duration: 1s287ms - Times executed: 5812 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s287ms - Times executed: 5812 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-18 11:59:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:27:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:29:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s263ms 57,600 0ms 9ms 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 #11
Day Hour Count Duration Avg duration Aug 18 00 2,400 50ms 0ms 01 2,400 50ms 0ms 02 2,400 49ms 0ms 03 2,400 51ms 0ms 04 2,400 49ms 0ms 05 2,400 47ms 0ms 06 2,400 54ms 0ms 07 2,400 55ms 0ms 08 2,400 52ms 0ms 09 2,400 48ms 0ms 10 2,400 64ms 0ms 11 2,400 51ms 0ms 12 2,400 53ms 0ms 13 2,400 49ms 0ms 14 2,400 53ms 0ms 15 2,400 56ms 0ms 16 2,400 52ms 0ms 17 2,400 53ms 0ms 18 2,400 52ms 0ms 19 2,400 50ms 0ms 20 2,400 51ms 0ms 21 2,400 57ms 0ms 22 2,400 54ms 0ms 23 2,400 53ms 0ms [ User: symmetricds - Total duration: 1s263ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s263ms - Times executed: 57600 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = '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 = 'filesync_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 = 'reload';
Date: 2018-08-18 10:55:39 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:29:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 21:25:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s231ms 227 3ms 9ms 5ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 END END AS TYPE, (i.keys).n AS ordinal_position, trim (BOTH '' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN '' THEN CASE i.indoption [ (i.keys).n - 0 ] & 0 WHEN 0 THEN '' ELSE '' END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = '' AND ct.relname = '' ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 18 00 169 881ms 5ms 01 3 13ms 4ms 02 3 13ms 4ms 03 3 13ms 4ms 04 4 19ms 4ms 05 4 17ms 4ms 06 3 18ms 6ms 07 4 17ms 4ms 08 3 20ms 6ms 09 3 23ms 7ms 10 2 18ms 9ms 11 2 14ms 7ms 12 2 13ms 6ms 13 2 17ms 8ms 14 2 14ms 7ms 15 2 9ms 4ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 14ms 7ms 20 2 13ms 6ms 21 2 8ms 4ms 22 2 18ms 9ms 23 2 8ms 4ms [ User: symmetricds - Total duration: 1s231ms - Times executed: 227 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s231ms - Times executed: 227 ]
-
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_checks' 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-08-18 11:01:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:00:02 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:16:18 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s222ms 21,048 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 18 00 877 50ms 0ms 01 877 53ms 0ms 02 877 50ms 0ms 03 877 52ms 0ms 04 877 50ms 0ms 05 877 49ms 0ms 06 877 55ms 0ms 07 877 50ms 0ms 08 877 50ms 0ms 09 877 50ms 0ms 10 877 49ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 50ms 0ms 15 877 49ms 0ms 16 877 52ms 0ms 17 877 50ms 0ms 18 877 49ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 50ms 0ms 22 877 50ms 0ms 23 877 50ms 0ms [ User: pharmisight - Total duration: 1s222ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s222ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3212' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '22' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '13' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-18 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 1s135ms 1,564 0ms 18ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 00 423 261ms 0ms 01 197 137ms 0ms 02 110 101ms 0ms 03 197 152ms 0ms 04 123 100ms 0ms 05 161 102ms 0ms 06 46 38ms 0ms 07 52 61ms 1ms 08 143 92ms 0ms 09 112 88ms 0ms [ User: pharmisight - Total duration: 1s135ms - Times executed: 1564 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s135ms - Times executed: 1564 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004381842', '2018-08-18 03:19:27', 'KROLP', '2018-08-18 03:40:01.334', '78793', '24', '150505230121971466');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004378891', '2018-08-18 01:15:52', 'PRICEM', '2018-08-18 01:40:01.331', '125707', '320', '150505230121968862');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004385138', '2018-08-18 06:49:00', 'SZAYNOWSKAP', '2018-08-18 07:00:00.032', '67696', '24', '150505230121976416');
Date: 2018-08-18 03:40:01 Duration: 18ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 01:40:01 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 07:00:00 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 935ms 5,760 0ms 1ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 00 240 37ms 0ms 01 240 39ms 0ms 02 240 39ms 0ms 03 240 38ms 0ms 04 240 37ms 0ms 05 240 36ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 37ms 0ms 09 240 35ms 0ms 10 240 39ms 0ms 11 240 37ms 0ms 12 240 43ms 0ms 13 240 37ms 0ms 14 240 41ms 0ms 15 240 38ms 0ms 16 240 42ms 0ms 17 240 37ms 0ms 18 240 40ms 0ms 19 240 38ms 0ms 20 240 38ms 0ms 21 240 37ms 0ms 22 240 41ms 0ms 23 240 40ms 0ms [ User: symmetricds - Total duration: 935ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 07:33:34.885', last_lock_time = '2018-08-18 07:33:34.885' WHERE node_id = '2' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 05:33:34.885');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 14:18:44.667', last_lock_time = '2018-08-18 14:18:44.667' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 12:18:44.667');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 16:39:48.085', last_lock_time = '2018-08-18 16:39:48.085' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 14:39:48.085');
Date: 2018-08-18 07:33:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:18:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:39:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 824ms 747 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) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 00 34 32ms 0ms 01 43 46ms 1ms 02 33 33ms 1ms 03 35 40ms 1ms 04 40 44ms 1ms 05 50 55ms 1ms 06 32 33ms 1ms 07 31 31ms 1ms 08 37 39ms 1ms 09 52 55ms 1ms 10 31 33ms 1ms 11 28 27ms 0ms 12 8 8ms 1ms 13 43 47ms 1ms 14 29 32ms 1ms 15 24 27ms 1ms 16 20 20ms 1ms 17 23 23ms 1ms 18 27 32ms 1ms 19 27 30ms 1ms 20 24 25ms 1ms 21 23 27ms 1ms 22 27 41ms 1ms 23 26 32ms 1ms [ User: symmetricds - Total duration: 824ms - Times executed: 747 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 824ms - Times executed: 747 ]
-
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-08-18 23:40:58 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:48:30 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:06:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 793ms 16,047 0ms 4ms 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 #17
Day Hour Count Duration Avg duration Aug 18 00 700 35ms 0ms 01 667 31ms 0ms 02 668 32ms 0ms 03 668 33ms 0ms 04 667 32ms 0ms 05 668 31ms 0ms 06 668 32ms 0ms 07 667 32ms 0ms 08 668 32ms 0ms 09 668 31ms 0ms 10 665 31ms 0ms 11 666 31ms 0ms 12 667 33ms 0ms 13 667 32ms 0ms 14 666 33ms 0ms 15 667 33ms 0ms 16 666 33ms 0ms 17 666 37ms 0ms 18 665 34ms 0ms 19 666 31ms 0ms 20 668 31ms 0ms 21 669 33ms 0ms 22 670 35ms 0ms 23 670 33ms 0ms [ User: symmetricds - Total duration: 793ms - Times executed: 16047 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 793ms - Times executed: 16047 ]
-
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-08-18 17:46:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:10:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:26:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 783ms 5,760 0ms 1ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 00 240 33ms 0ms 01 240 32ms 0ms 02 240 31ms 0ms 03 240 32ms 0ms 04 240 34ms 0ms 05 240 31ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 30ms 0ms 09 240 30ms 0ms 10 240 31ms 0ms 11 240 32ms 0ms 12 240 32ms 0ms 13 240 31ms 0ms 14 240 33ms 0ms 15 240 32ms 0ms 16 240 33ms 0ms 17 240 33ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 32ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 783ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 783ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '156933', fail_count = '0', total_success_count = '156933', total_fail_count = '0', total_success_millis = '9607576', total_fail_millis = '0', last_lock_time = '2018-08-18 07:50:35.277' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '157155', fail_count = '0', total_success_count = '157155', total_fail_count = '0', total_success_millis = '9997485', total_fail_millis = '0', last_lock_time = '2018-08-18 18:55:51.381' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '54', success_count = '351642', fail_count = '0', total_success_count = '351642', total_fail_count = '335', total_success_millis = '15747106', total_fail_millis = '42537163', last_lock_time = '2018-08-18 01:44:26.102' WHERE node_id = '1' AND communication_type = 'PUSH';
Date: 2018-08-18 07:50:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:55:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 01:44:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 773ms 508 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = '' AND t.typnotnull), pg_catalog.pg_get_expr (d.adbin, d.adrelid) LIKE '' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 0 AS OID, 0 AS attnum UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0 UNION ALL SELECT 0, 0) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 00 24 34ms 1ms 01 29 43ms 1ms 02 28 43ms 1ms 03 25 38ms 1ms 04 26 39ms 1ms 05 25 38ms 1ms 06 26 40ms 1ms 07 29 44ms 1ms 08 23 35ms 1ms 10 26 39ms 1ms 11 23 35ms 1ms 13 18 27ms 1ms 14 23 35ms 1ms 15 20 30ms 1ms 16 17 25ms 1ms 17 21 32ms 1ms 18 23 36ms 1ms 19 23 34ms 1ms 20 22 33ms 1ms 21 18 26ms 1ms 22 20 30ms 1ms 23 19 29ms 1ms [ User: symmetricds - Total duration: 773ms - Times executed: 508 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 773ms - Times executed: 508 ]
-
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-08-18 18:10:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:36:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:36:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 757ms 191 0ms 11ms 3ms 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 #20
Day Hour Count Duration Avg duration Aug 18 00 8 27ms 3ms 01 8 26ms 3ms 02 8 31ms 3ms 03 8 30ms 3ms 04 8 23ms 2ms 05 8 25ms 3ms 06 8 29ms 3ms 07 8 26ms 3ms 08 8 31ms 3ms 09 8 32ms 4ms 10 8 31ms 3ms 11 8 33ms 4ms 12 8 20ms 2ms 13 8 37ms 4ms 14 8 27ms 3ms 15 8 29ms 3ms 16 8 32ms 4ms 17 8 25ms 3ms 18 8 31ms 3ms 19 8 30ms 3ms 20 7 33ms 4ms 21 8 38ms 4ms 22 8 43ms 5ms 23 8 56ms 7ms [ User: symmetricds - Total duration: 757ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 757ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '219668320', "total_memory_bytes" = '580911104', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 23:52:23', "last_restart_time" = '2018-07-11 21:16:49', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '240592352', "total_memory_bytes" = '523763712', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 00:02:55', "last_restart_time" = '2018-07-20 18:46:54.048', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '249719160', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 14:18:11', "last_restart_time" = '2018-07-20 18:46:54.048', "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-08-18 23:53:07 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:03:12 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:19:18 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 867,748 15s876ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION LEVEL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 18 00 38,342 686ms 0ms 01 36,104 650ms 0ms 02 36,132 661ms 0ms 03 36,126 649ms 0ms 04 36,078 642ms 0ms 05 36,138 631ms 0ms 06 36,115 664ms 0ms 07 36,075 654ms 0ms 08 36,100 654ms 0ms 09 36,126 639ms 0ms 10 35,942 665ms 0ms 11 36,001 651ms 0ms 12 36,036 673ms 0ms 13 36,026 659ms 0ms 14 35,974 663ms 0ms 15 36,033 688ms 0ms 16 36,010 661ms 0ms 17 36,003 662ms 0ms 18 35,949 647ms 0ms 19 36,003 662ms 0ms 20 36,064 653ms 0ms 21 36,078 687ms 0ms 22 36,139 693ms 0ms 23 36,154 672ms 0ms [ User: symmetricds - Total duration: 15s854ms - Times executed: 867167 ]
[ User: pharmisight - Total duration: 21ms - Times executed: 581 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s876ms - Times executed: 867748 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-08-18 12:00:41 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:42:37 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 02:33:27 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 384,356 4s722ms 0ms 3ms 0ms SELECT 0;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 18 00 17,805 214ms 0ms 01 15,999 192ms 0ms 02 16,002 192ms 0ms 03 16,009 194ms 0ms 04 15,983 191ms 0ms 05 16,010 191ms 0ms 06 15,985 200ms 0ms 07 15,983 198ms 0ms 08 15,969 192ms 0ms 09 16,000 191ms 0ms 10 15,857 198ms 0ms 11 15,898 194ms 0ms 12 15,911 201ms 0ms 13 15,897 192ms 0ms 14 15,871 198ms 0ms 15 15,898 199ms 0ms 16 15,893 196ms 0ms 17 15,882 200ms 0ms 18 15,854 193ms 0ms 19 15,883 194ms 0ms 20 15,920 194ms 0ms 21 15,928 196ms 0ms 22 15,956 202ms 0ms 23 15,963 199ms 0ms [ User: symmetricds - Total duration: 4s722ms - Times executed: 384356 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s722ms - Times executed: 384356 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-08-18 12:14:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:50:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 15:45:46 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 292,342 1s818ms 0ms 3ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 00 13,570 82ms 0ms 01 12,164 73ms 0ms 02 12,170 73ms 0ms 03 12,166 75ms 0ms 04 12,152 74ms 0ms 05 12,173 73ms 0ms 06 12,149 75ms 0ms 07 12,152 75ms 0ms 08 12,145 75ms 0ms 09 12,173 73ms 0ms 10 12,059 79ms 0ms 11 12,081 75ms 0ms 12 12,095 79ms 0ms 13 12,090 75ms 0ms 14 12,071 75ms 0ms 15 12,090 76ms 0ms 16 12,087 75ms 0ms 17 12,077 76ms 0ms 18 12,062 72ms 0ms 19 12,078 75ms 0ms 20 12,121 75ms 0ms 21 12,124 76ms 0ms 22 12,144 75ms 0ms 23 12,149 75ms 0ms [ User: symmetricds - Total duration: 1s816ms - Times executed: 292070 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s818ms - Times executed: 292342 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-08-18 12:33:42 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 10:25:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:40:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 292,341 7s277ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 00 13,570 656ms 0ms 01 12,163 296ms 0ms 02 12,171 313ms 0ms 03 12,166 299ms 0ms 04 12,151 312ms 0ms 05 12,173 308ms 0ms 06 12,150 297ms 0ms 07 12,151 296ms 0ms 08 12,144 286ms 0ms 09 12,175 308ms 0ms 10 12,059 273ms 0ms 11 12,081 272ms 0ms 12 12,095 279ms 0ms 13 12,090 274ms 0ms 14 12,071 271ms 0ms 15 12,090 270ms 0ms 16 12,087 282ms 0ms 17 12,076 270ms 0ms 18 12,063 271ms 0ms 19 12,078 279ms 0ms 20 12,121 280ms 0ms 21 12,124 285ms 0ms 22 12,144 286ms 0ms 23 12,148 300ms 0ms [ User: symmetricds - Total duration: 7s211ms - Times executed: 292069 ]
[ User: pharmisight - Total duration: 65ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s277ms - Times executed: 292341 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-08-18 00:06:12 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:37:15 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:15:37 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 77,247 3s540ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 18 00 3,204 145ms 0ms 01 3,213 147ms 0ms 02 3,222 149ms 0ms 03 3,222 150ms 0ms 04 3,213 143ms 0ms 05 3,222 147ms 0ms 06 3,222 149ms 0ms 07 3,213 148ms 0ms 08 3,222 148ms 0ms 09 3,222 144ms 0ms 10 3,213 146ms 0ms 11 3,222 148ms 0ms 12 3,222 149ms 0ms 13 3,222 150ms 0ms 14 3,213 146ms 0ms 15 3,222 144ms 0ms 16 3,222 146ms 0ms 17 3,222 147ms 0ms 18 3,213 147ms 0ms 19 3,222 149ms 0ms 20 3,222 148ms 0ms 21 3,213 144ms 0ms 22 3,222 148ms 0ms 23 3,222 148ms 0ms [ User: symmetricds - Total duration: 3s540ms - Times executed: 77247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s540ms - Times executed: 77247 ]
-
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-08-18 12:30:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:51:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 15:31:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 68,669 1s578ms 0ms 0ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list FROM sym_data d WHERE d.channel_id = '' AND ((d.data_id BETWEEN '' AND '')) ORDER BY d.data_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 18 00 2,851 69ms 0ms 01 2,857 67ms 0ms 02 2,864 66ms 0ms 03 2,865 67ms 0ms 04 2,856 66ms 0ms 05 2,864 68ms 0ms 06 2,864 66ms 0ms 07 2,856 66ms 0ms 08 2,865 67ms 0ms 09 2,864 65ms 0ms 10 2,856 64ms 0ms 11 2,864 65ms 0ms 12 2,863 64ms 0ms 13 2,864 64ms 0ms 14 2,856 65ms 0ms 15 2,864 64ms 0ms 16 2,864 64ms 0ms 17 2,864 64ms 0ms 18 2,856 64ms 0ms 19 2,864 64ms 0ms 20 2,864 64ms 0ms 21 2,856 64ms 0ms 22 2,864 65ms 0ms 23 2,864 64ms 0ms [ User: symmetricds - Total duration: 1s578ms - Times executed: 68669 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s578ms - Times executed: 68669 ]
-
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 '87795998' AND '137795997')) 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 '87796945' AND '137796944')) 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 '87796586' AND '137796585')) ORDER BY d.data_id ASC;
Date: 2018-08-18 00:40:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 05:20:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:20:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 57,600 1s263ms 0ms 9ms 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 Aug 18 00 2,400 50ms 0ms 01 2,400 50ms 0ms 02 2,400 49ms 0ms 03 2,400 51ms 0ms 04 2,400 49ms 0ms 05 2,400 47ms 0ms 06 2,400 54ms 0ms 07 2,400 55ms 0ms 08 2,400 52ms 0ms 09 2,400 48ms 0ms 10 2,400 64ms 0ms 11 2,400 51ms 0ms 12 2,400 53ms 0ms 13 2,400 49ms 0ms 14 2,400 53ms 0ms 15 2,400 56ms 0ms 16 2,400 52ms 0ms 17 2,400 53ms 0ms 18 2,400 52ms 0ms 19 2,400 50ms 0ms 20 2,400 51ms 0ms 21 2,400 57ms 0ms 22 2,400 54ms 0ms 23 2,400 53ms 0ms [ User: symmetricds - Total duration: 1s263ms - Times executed: 57600 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s263ms - Times executed: 57600 ]
-
SELECT node_group_id, channel_id, start_time, end_time, enabled FROM sym_node_group_channel_wnd WHERE node_group_id = 'redditch' AND channel_id = '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 = 'filesync_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 = 'reload';
Date: 2018-08-18 10:55:39 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:29:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 21:25:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 23,712 1s362ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 00 988 55ms 0ms 01 988 59ms 0ms 02 988 55ms 0ms 03 988 57ms 0ms 04 988 56ms 0ms 05 988 54ms 0ms 06 988 61ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 55ms 0ms 11 988 56ms 0ms 12 988 56ms 0ms 13 988 58ms 0ms 14 988 55ms 0ms 15 988 55ms 0ms 16 988 58ms 0ms 17 988 56ms 0ms 18 988 55ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 55ms 0ms 22 988 56ms 0ms 23 988 56ms 0ms [ User: pharmisight - Total duration: 1s362ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s362ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3313' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '30' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 21,048 1s222ms 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 18 00 877 50ms 0ms 01 877 53ms 0ms 02 877 50ms 0ms 03 877 52ms 0ms 04 877 50ms 0ms 05 877 49ms 0ms 06 877 55ms 0ms 07 877 50ms 0ms 08 877 50ms 0ms 09 877 50ms 0ms 10 877 49ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 50ms 0ms 15 877 49ms 0ms 16 877 52ms 0ms 17 877 50ms 0ms 18 877 49ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 50ms 0ms 22 877 50ms 0ms 23 877 50ms 0ms [ User: pharmisight - Total duration: 1s222ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s222ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3212' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '22' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '13' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-18 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 16,047 793ms 0ms 4ms 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 Aug 18 00 700 35ms 0ms 01 667 31ms 0ms 02 668 32ms 0ms 03 668 33ms 0ms 04 667 32ms 0ms 05 668 31ms 0ms 06 668 32ms 0ms 07 667 32ms 0ms 08 668 32ms 0ms 09 668 31ms 0ms 10 665 31ms 0ms 11 666 31ms 0ms 12 667 33ms 0ms 13 667 32ms 0ms 14 666 33ms 0ms 15 667 33ms 0ms 16 666 33ms 0ms 17 666 37ms 0ms 18 665 34ms 0ms 19 666 31ms 0ms 20 668 31ms 0ms 21 669 33ms 0ms 22 670 35ms 0ms 23 670 33ms 0ms [ User: symmetricds - Total duration: 793ms - Times executed: 16047 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 793ms - Times executed: 16047 ]
-
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-08-18 17:46:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:10:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:26:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 11,521 745ms 0ms 3ms 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 Aug 18 00 481 31ms 0ms 01 480 31ms 0ms 02 480 31ms 0ms 03 480 31ms 0ms 04 480 30ms 0ms 05 480 30ms 0ms 06 480 30ms 0ms 07 480 29ms 0ms 08 480 30ms 0ms 09 480 28ms 0ms 10 480 30ms 0ms 11 480 30ms 0ms 12 480 31ms 0ms 13 480 34ms 0ms 14 480 30ms 0ms 15 480 33ms 0ms 16 480 30ms 0ms 17 480 30ms 0ms 18 480 29ms 0ms 19 480 30ms 0ms 20 480 30ms 0ms 21 480 31ms 0ms 22 480 33ms 0ms 23 480 30ms 0ms [ User: symmetricds - Total duration: 745ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 745ms - Times executed: 11521 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-08-18 13:55:44 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 02:33:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:12:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 8,635 284ms 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 Aug 18 00 358 11ms 0ms 01 360 12ms 0ms 02 360 11ms 0ms 03 360 11ms 0ms 04 359 11ms 0ms 05 360 11ms 0ms 06 360 11ms 0ms 07 360 11ms 0ms 08 360 11ms 0ms 09 360 11ms 0ms 10 359 11ms 0ms 11 360 11ms 0ms 12 360 11ms 0ms 13 360 12ms 0ms 14 360 12ms 0ms 15 360 11ms 0ms 16 360 11ms 0ms 17 359 11ms 0ms 18 360 12ms 0ms 19 360 12ms 0ms 20 360 11ms 0ms 21 360 12ms 0ms 22 360 11ms 0ms 23 360 12ms 0ms [ User: symmetricds - Total duration: 284ms - Times executed: 8635 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 284ms - Times executed: 8635 ]
-
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-08-18 23:08:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:07:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:54:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,589 194ms 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 Aug 18 00 359 9ms 0ms 01 358 8ms 0ms 02 358 8ms 0ms 03 359 8ms 0ms 04 357 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 357 8ms 0ms 08 359 8ms 0ms 09 358 8ms 0ms 10 357 7ms 0ms 11 358 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 357 7ms 0ms 15 358 8ms 0ms 16 358 7ms 0ms 17 358 7ms 0ms 18 357 7ms 0ms 19 358 7ms 0ms 20 358 7ms 0ms 21 357 7ms 0ms 22 358 7ms 0ms 23 358 7ms 0ms [ User: symmetricds - Total duration: 194ms - Times executed: 8589 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 194ms - Times executed: 8589 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '87797181' AND data_id <= '137797180' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '87795998' AND data_id <= '137795997' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '87795910' AND data_id <= '137795909' ORDER BY data_id ASC;
Date: 2018-08-18 08:40:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:40:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:20:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,583 452ms 0ms 0ms 0ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 00 356 19ms 0ms 01 357 19ms 0ms 02 358 19ms 0ms 03 358 19ms 0ms 04 357 18ms 0ms 05 358 19ms 0ms 06 358 19ms 0ms 07 357 19ms 0ms 08 358 18ms 0ms 09 358 18ms 0ms 10 357 18ms 0ms 11 358 18ms 0ms 12 358 18ms 0ms 13 358 18ms 0ms 14 357 18ms 0ms 15 358 18ms 0ms 16 358 18ms 0ms 17 358 18ms 0ms 18 357 18ms 0ms 19 358 18ms 0ms 20 358 18ms 0ms 21 357 19ms 0ms 22 358 18ms 0ms 23 358 18ms 0ms [ User: symmetricds - Total duration: 452ms - Times executed: 8583 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 452ms - Times executed: 8583 ]
-
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-08-18 19:30:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:40:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 12:06:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 7,200 640ms 0ms 1ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 00 300 30ms 0ms 01 300 27ms 0ms 02 300 28ms 0ms 03 300 25ms 0ms 04 300 28ms 0ms 05 300 26ms 0ms 06 300 27ms 0ms 07 300 30ms 0ms 08 300 28ms 0ms 09 300 24ms 0ms 10 300 27ms 0ms 11 300 24ms 0ms 12 300 26ms 0ms 13 300 28ms 0ms 14 300 23ms 0ms 15 300 25ms 0ms 16 300 25ms 0ms 17 300 24ms 0ms 18 300 25ms 0ms 19 300 24ms 0ms 20 300 23ms 0ms 21 300 27ms 0ms 22 300 26ms 0ms 23 300 25ms 0ms [ User: symmetricds - Total duration: 640ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 640ms - Times executed: 7200 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-08-18 18:03:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:23:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:07:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5,812 1s287ms 0ms 3ms 0ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 00 244 52ms 0ms 01 241 49ms 0ms 02 241 51ms 0ms 03 240 49ms 0ms 04 241 51ms 0ms 05 242 49ms 0ms 06 249 56ms 0ms 07 240 52ms 0ms 08 241 49ms 0ms 09 240 54ms 0ms 10 241 57ms 0ms 11 239 58ms 0ms 12 245 59ms 0ms 13 241 53ms 0ms 14 240 53ms 0ms 15 242 55ms 0ms 16 243 54ms 0ms 17 245 55ms 0ms 18 241 49ms 0ms 19 241 54ms 0ms 20 244 50ms 0ms 21 242 55ms 0ms 22 246 58ms 0ms 23 243 55ms 0ms [ User: symmetricds - Total duration: 1s287ms - Times executed: 5812 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s287ms - Times executed: 5812 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-18 11:59:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:27:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:29:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,785 219ms 0ms 1ms 0ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 18 00 265 9ms 0ms 01 240 8ms 0ms 02 240 8ms 0ms 03 240 9ms 0ms 04 240 8ms 0ms 05 240 7ms 0ms 06 240 8ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 8ms 0ms 10 240 8ms 0ms 11 240 8ms 0ms 12 240 9ms 0ms 13 240 9ms 0ms 14 240 8ms 0ms 15 240 8ms 0ms 16 240 9ms 0ms 17 240 8ms 0ms 18 240 9ms 0ms 19 240 10ms 0ms 20 240 9ms 0ms 21 240 10ms 0ms 22 240 8ms 0ms 23 240 11ms 0ms [ User: symmetricds - Total duration: 219ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 219ms - Times executed: 5785 ]
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
Date: 2018-08-18 19:03:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:08:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:53:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,760 783ms 0ms 1ms 0ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 00 240 33ms 0ms 01 240 32ms 0ms 02 240 31ms 0ms 03 240 32ms 0ms 04 240 34ms 0ms 05 240 31ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 30ms 0ms 09 240 30ms 0ms 10 240 31ms 0ms 11 240 32ms 0ms 12 240 32ms 0ms 13 240 31ms 0ms 14 240 33ms 0ms 15 240 32ms 0ms 16 240 33ms 0ms 17 240 33ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 32ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 783ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 783ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '156933', fail_count = '0', total_success_count = '156933', total_fail_count = '0', total_success_millis = '9607576', total_fail_millis = '0', last_lock_time = '2018-08-18 07:50:35.277' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '157155', fail_count = '0', total_success_count = '157155', total_fail_count = '0', total_success_millis = '9997485', total_fail_millis = '0', last_lock_time = '2018-08-18 18:55:51.381' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '54', success_count = '351642', fail_count = '0', total_success_count = '351642', total_fail_count = '335', total_success_millis = '15747106', total_fail_millis = '42537163', last_lock_time = '2018-08-18 01:44:26.102' WHERE node_id = '1' AND communication_type = 'PUSH';
Date: 2018-08-18 07:50:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:55:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 01:44:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 5,760 935ms 0ms 1ms 0ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 00 240 37ms 0ms 01 240 39ms 0ms 02 240 39ms 0ms 03 240 38ms 0ms 04 240 37ms 0ms 05 240 36ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 37ms 0ms 09 240 35ms 0ms 10 240 39ms 0ms 11 240 37ms 0ms 12 240 43ms 0ms 13 240 37ms 0ms 14 240 41ms 0ms 15 240 38ms 0ms 16 240 42ms 0ms 17 240 37ms 0ms 18 240 40ms 0ms 19 240 38ms 0ms 20 240 38ms 0ms 21 240 37ms 0ms 22 240 41ms 0ms 23 240 40ms 0ms [ User: symmetricds - Total duration: 935ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 07:33:34.885', last_lock_time = '2018-08-18 07:33:34.885' WHERE node_id = '2' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 05:33:34.885');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 14:18:44.667', last_lock_time = '2018-08-18 14:18:44.667' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 12:18:44.667');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 16:39:48.085', last_lock_time = '2018-08-18 16:39:48.085' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 14:39:48.085');
Date: 2018-08-18 07:33:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:18:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:39:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 5,760 435ms 0ms 1ms 0ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 18 00 240 17ms 0ms 01 240 16ms 0ms 02 240 17ms 0ms 03 240 17ms 0ms 04 240 17ms 0ms 05 240 17ms 0ms 06 240 17ms 0ms 07 240 17ms 0ms 08 240 17ms 0ms 09 240 18ms 0ms 10 240 17ms 0ms 11 240 18ms 0ms 12 240 21ms 0ms 13 240 17ms 0ms 14 240 17ms 0ms 15 240 18ms 0ms 16 240 19ms 0ms 17 240 18ms 0ms 18 240 19ms 0ms 19 240 17ms 0ms 20 240 18ms 0ms 21 240 19ms 0ms 22 240 19ms 0ms 23 240 18ms 0ms [ User: symmetricds - Total duration: 435ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 435ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-08-18 12:33:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:04:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 11:56:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 90ms 16ms 147 2s448ms 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 Aug 18 00 13 149ms 11ms 01 13 134ms 10ms 02 13 47ms 3ms 03 13 91ms 7ms 04 13 85ms 6ms 05 13 128ms 9ms 06 13 82ms 6ms 07 13 293ms 22ms 08 8 254ms 31ms 09 7 266ms 38ms 10 5 204ms 40ms 11 4 155ms 38ms 12 4 113ms 28ms 13 3 98ms 32ms 14 2 70ms 35ms 15 2 37ms 18ms 16 1 38ms 38ms 17 1 31ms 31ms 18 1 21ms 21ms 19 1 17ms 17ms 20 1 32ms 32ms 21 1 16ms 16ms 22 1 39ms 39ms 23 1 36ms 36ms [ User: symmetricds - Total duration: 2s448ms - Times executed: 147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s448ms - Times executed: 147 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '87766547' AND '87771547' AND create_time < '2018-08-17 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87766547' AND '87771547' 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 '87773276' AND '87778276' AND create_time < '2018-08-17 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87773276' AND '87778276' 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 '87733788' AND '87738788' AND create_time < '2018-08-17 00:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '87733788' AND '87738788' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE STATUS != 'OK')));
Date: 2018-08-18 09:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 10:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:00:00 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 1ms 13ms 12ms 288 3s467ms 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 Aug 18 00 12 144ms 12ms 01 12 144ms 12ms 02 12 145ms 12ms 03 12 144ms 12ms 04 12 145ms 12ms 05 12 144ms 12ms 06 12 146ms 12ms 07 12 146ms 12ms 08 12 146ms 12ms 09 12 145ms 12ms 10 12 145ms 12ms 11 12 145ms 12ms 12 12 135ms 11ms 13 12 125ms 10ms 14 12 146ms 12ms 15 12 145ms 12ms 16 12 146ms 12ms 17 12 146ms 12ms 18 12 146ms 12ms 19 12 145ms 12ms 20 12 145ms 12ms 21 12 145ms 12ms 22 12 146ms 12ms 23 12 146ms 12ms [ User: tony - Total duration: 3s467ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 3s467ms - 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-08-18 08:16:14 Duration: 13ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-18 07:56:14 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
Date: 2018-08-18 16:36:13 Duration: 12ms Database: pharmisight User: tony Remote: ::1 Application: [unknown]
3 3ms 9ms 5ms 227 1s231ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN 0 ELSE CASE am.amname WHEN '' THEN 0 ELSE 0 END END AS TYPE, (i.keys).n AS ordinal_position, trim (BOTH '' FROM pg_catalog.pg_get_indexdef (ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN '' THEN CASE i.indoption [ (i.keys).n - 0 ] & 0 WHEN 0 THEN '' ELSE '' END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr (i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS KEYS FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = '' AND ct.relname = '' ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 00 169 881ms 5ms 01 3 13ms 4ms 02 3 13ms 4ms 03 3 13ms 4ms 04 4 19ms 4ms 05 4 17ms 4ms 06 3 18ms 6ms 07 4 17ms 4ms 08 3 20ms 6ms 09 3 23ms 7ms 10 2 18ms 9ms 11 2 14ms 7ms 12 2 13ms 6ms 13 2 17ms 8ms 14 2 14ms 7ms 15 2 9ms 4ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 14ms 7ms 20 2 13ms 6ms 21 2 8ms 4ms 22 2 18ms 9ms 23 2 8ms 4ms [ User: symmetricds - Total duration: 1s231ms - Times executed: 227 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s231ms - Times executed: 227 ]
-
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_checks' 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-08-18 11:01:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:00:02 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:16:18 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 11ms 3ms 191 757ms UPDATE "public"."sym_node_host" SET "ip_address" = '', "os_user" = '', "os_name" = '', "os_arch" = '', "os_version" = '', "available_processors" = '', "free_memory_bytes" = '', "total_memory_bytes" = '', "max_memory_bytes" = '', "java_version" = '', "java_vendor" = '', "symmetric_version" = '', "timezone_offset" = '', "heartbeat_time" = '', "last_restart_time" = '', "create_time" = '', "jdbc_version" = '' WHERE "node_id" = '' AND "host_name" = '';Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 00 8 27ms 3ms 01 8 26ms 3ms 02 8 31ms 3ms 03 8 30ms 3ms 04 8 23ms 2ms 05 8 25ms 3ms 06 8 29ms 3ms 07 8 26ms 3ms 08 8 31ms 3ms 09 8 32ms 4ms 10 8 31ms 3ms 11 8 33ms 4ms 12 8 20ms 2ms 13 8 37ms 4ms 14 8 27ms 3ms 15 8 29ms 3ms 16 8 32ms 4ms 17 8 25ms 3ms 18 8 31ms 3ms 19 8 30ms 3ms 20 7 33ms 4ms 21 8 38ms 4ms 22 8 43ms 5ms 23 8 56ms 7ms [ User: symmetricds - Total duration: 757ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 757ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '3', "free_memory_bytes" = '219668320', "total_memory_bytes" = '580911104', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 23:52:23', "last_restart_time" = '2018-07-11 21:16:49', "create_time" = '2015-02-27 20:54:11', "jdbc_version" = 'mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '240592352', "total_memory_bytes" = '523763712', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 00:02:55', "last_restart_time" = '2018-07-20 18:46:54.048', "create_time" = '2011-10-12 13:53:54.937072', "jdbc_version" = 'PostgreSQL 9.2 JDBC4 (build 1002)' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-6-amd64', "available_processors" = '2', "free_memory_bytes" = '249719160', "total_memory_bytes" = '524288000', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_171', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.6.17', "timezone_offset" = '+01:00', "heartbeat_time" = '2018-08-18 14:18:11', "last_restart_time" = '2018-07-20 18:46:54.048', "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-08-18 23:53:07 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:03:12 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:19:18 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 2ms 1ms 508 773ms 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 #5
Day Hour Count Duration Avg duration Aug 18 00 24 34ms 1ms 01 29 43ms 1ms 02 28 43ms 1ms 03 25 38ms 1ms 04 26 39ms 1ms 05 25 38ms 1ms 06 26 40ms 1ms 07 29 44ms 1ms 08 23 35ms 1ms 10 26 39ms 1ms 11 23 35ms 1ms 13 18 27ms 1ms 14 23 35ms 1ms 15 20 30ms 1ms 16 17 25ms 1ms 17 21 32ms 1ms 18 23 36ms 1ms 19 23 34ms 1ms 20 22 33ms 1ms 21 18 26ms 1ms 22 20 30ms 1ms 23 19 29ms 1ms [ User: symmetricds - Total duration: 773ms - Times executed: 508 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 773ms - Times executed: 508 ]
-
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-08-18 18:10:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:36:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:36:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 5ms 1ms 747 824ms 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 #6
Day Hour Count Duration Avg duration Aug 18 00 34 32ms 0ms 01 43 46ms 1ms 02 33 33ms 1ms 03 35 40ms 1ms 04 40 44ms 1ms 05 50 55ms 1ms 06 32 33ms 1ms 07 31 31ms 1ms 08 37 39ms 1ms 09 52 55ms 1ms 10 31 33ms 1ms 11 28 27ms 0ms 12 8 8ms 1ms 13 43 47ms 1ms 14 29 32ms 1ms 15 24 27ms 1ms 16 20 20ms 1ms 17 23 23ms 1ms 18 27 32ms 1ms 19 27 30ms 1ms 20 24 25ms 1ms 21 23 27ms 1ms 22 27 41ms 1ms 23 26 32ms 1ms [ User: symmetricds - Total duration: 824ms - Times executed: 747 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 824ms - Times executed: 747 ]
-
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-08-18 23:40:58 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:48:30 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:06:28 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 18ms 0ms 1,564 1s135ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES ('', '', '', '', '', '', '');Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 18 00 423 261ms 0ms 01 197 137ms 0ms 02 110 101ms 0ms 03 197 152ms 0ms 04 123 100ms 0ms 05 161 102ms 0ms 06 46 38ms 0ms 07 52 61ms 1ms 08 143 92ms 0ms 09 112 88ms 0ms [ User: pharmisight - Total duration: 1s135ms - Times executed: 1564 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s135ms - Times executed: 1564 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004381842', '2018-08-18 03:19:27', 'KROLP', '2018-08-18 03:40:01.334', '78793', '24', '150505230121971466');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004378891', '2018-08-18 01:15:52', 'PRICEM', '2018-08-18 01:40:01.331', '125707', '320', '150505230121968862');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5004385138', '2018-08-18 06:49:00', 'SZAYNOWSKAP', '2018-08-18 07:00:00.032', '67696', '24', '150505230121976416');
Date: 2018-08-18 03:40:01 Duration: 18ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 01:40:01 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 07:00:00 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 0ms 5,812 1s287ms SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '' ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 00 244 52ms 0ms 01 241 49ms 0ms 02 241 51ms 0ms 03 240 49ms 0ms 04 241 51ms 0ms 05 242 49ms 0ms 06 249 56ms 0ms 07 240 52ms 0ms 08 241 49ms 0ms 09 240 54ms 0ms 10 241 57ms 0ms 11 239 58ms 0ms 12 245 59ms 0ms 13 241 53ms 0ms 14 240 53ms 0ms 15 242 55ms 0ms 16 243 54ms 0ms 17 245 55ms 0ms 18 241 49ms 0ms 19 241 54ms 0ms 20 244 50ms 0ms 21 242 55ms 0ms 22 246 58ms 0ms 23 243 55ms 0ms [ User: symmetricds - Total duration: 1s287ms - Times executed: 5812 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s287ms - Times executed: 5812 ]
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '2' ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, nc.node_id, nc.ignore_enabled, nc.suspend_enabled, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, nc.last_extract_time, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag FROM sym_channel c LEFT OUTER JOIN sym_node_channel_ctl nc ON c.channel_id = nc.channel_id AND nc.node_id = '0' ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-08-18 11:59:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 09:27:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:29:47 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 5,760 935ms UPDATE sym_node_communication SET locking_server_id = '', lock_time = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '' AND (lock_time IS NULL OR lock_time < '');Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 18 00 240 37ms 0ms 01 240 39ms 0ms 02 240 39ms 0ms 03 240 38ms 0ms 04 240 37ms 0ms 05 240 36ms 0ms 06 240 39ms 0ms 07 240 39ms 0ms 08 240 37ms 0ms 09 240 35ms 0ms 10 240 39ms 0ms 11 240 37ms 0ms 12 240 43ms 0ms 13 240 37ms 0ms 14 240 41ms 0ms 15 240 38ms 0ms 16 240 42ms 0ms 17 240 37ms 0ms 18 240 40ms 0ms 19 240 38ms 0ms 20 240 38ms 0ms 21 240 37ms 0ms 22 240 41ms 0ms 23 240 40ms 0ms [ User: symmetricds - Total duration: 935ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 07:33:34.885', last_lock_time = '2018-08-18 07:33:34.885' WHERE node_id = '2' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 05:33:34.885');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 14:18:44.667', last_lock_time = '2018-08-18 14:18:44.667' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 12:18:44.667');
-
UPDATE sym_node_communication SET locking_server_id = 'scancheck', lock_time = '2018-08-18 16:39:48.085', last_lock_time = '2018-08-18 16:39:48.085' WHERE node_id = '1' AND communication_type = 'PUSH' AND (lock_time IS NULL OR lock_time < '2018-08-18 14:39:48.085');
Date: 2018-08-18 07:33:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 14:18:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 16:39:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 1ms 0ms 5,760 783ms UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = '', last_lock_millis = '', success_count = '', fail_count = '', total_success_count = '', total_fail_count = '', total_success_millis = '', total_fail_millis = '', last_lock_time = '' WHERE node_id = '' AND communication_type = '';Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 18 00 240 33ms 0ms 01 240 32ms 0ms 02 240 31ms 0ms 03 240 32ms 0ms 04 240 34ms 0ms 05 240 31ms 0ms 06 240 32ms 0ms 07 240 33ms 0ms 08 240 30ms 0ms 09 240 30ms 0ms 10 240 31ms 0ms 11 240 32ms 0ms 12 240 32ms 0ms 13 240 31ms 0ms 14 240 33ms 0ms 15 240 32ms 0ms 16 240 33ms 0ms 17 240 33ms 0ms 18 240 33ms 0ms 19 240 32ms 0ms 20 240 32ms 0ms 21 240 33ms 0ms 22 240 34ms 0ms 23 240 32ms 0ms [ User: symmetricds - Total duration: 783ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 783ms - Times executed: 5760 ]
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '156933', fail_count = '0', total_success_count = '156933', total_fail_count = '0', total_success_millis = '9607576', total_fail_millis = '0', last_lock_time = '2018-08-18 07:50:35.277' WHERE node_id = '1' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '73', success_count = '157155', fail_count = '0', total_success_count = '157155', total_fail_count = '0', total_success_millis = '9997485', total_fail_millis = '0', last_lock_time = '2018-08-18 18:55:51.381' WHERE node_id = '2' AND communication_type = 'FILE_PUSH';
-
UPDATE sym_node_communication SET lock_time = NULL, locking_server_id = 'scancheck', last_lock_millis = '54', success_count = '351642', fail_count = '0', total_success_count = '351642', total_fail_count = '335', total_success_millis = '15747106', total_fail_millis = '42537163', last_lock_time = '2018-08-18 01:44:26.102' WHERE node_id = '1' AND communication_type = 'PUSH';
Date: 2018-08-18 07:50:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:55:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 01:44:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 7,200 640ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '' AND STATUS IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 18 00 300 30ms 0ms 01 300 27ms 0ms 02 300 28ms 0ms 03 300 25ms 0ms 04 300 28ms 0ms 05 300 26ms 0ms 06 300 27ms 0ms 07 300 30ms 0ms 08 300 28ms 0ms 09 300 24ms 0ms 10 300 27ms 0ms 11 300 24ms 0ms 12 300 26ms 0ms 13 300 28ms 0ms 14 300 23ms 0ms 15 300 25ms 0ms 16 300 25ms 0ms 17 300 24ms 0ms 18 300 25ms 0ms 19 300 24ms 0ms 20 300 23ms 0ms 21 300 27ms 0ms 22 300 26ms 0ms 23 300 25ms 0ms [ User: symmetricds - Total duration: 640ms - Times executed: 7200 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 640ms - Times executed: 7200 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '1' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_event_count, b.reload_event_count, b.insert_event_count, b.update_event_count, b.delete_event_count, b.other_event_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.sql_state, b.sql_code, b.sql_message, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by FROM sym_outgoing_batch b WHERE node_id = '0' AND STATUS IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG') ORDER BY batch_id ASC;
Date: 2018-08-18 18:03:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:23:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:07:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 1ms 0ms 5,760 435ms SELECT * FROM sym_node_communication WHERE communication_type = '' ORDER BY last_lock_time;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 18 00 240 17ms 0ms 01 240 16ms 0ms 02 240 17ms 0ms 03 240 17ms 0ms 04 240 17ms 0ms 05 240 17ms 0ms 06 240 17ms 0ms 07 240 17ms 0ms 08 240 17ms 0ms 09 240 18ms 0ms 10 240 17ms 0ms 11 240 18ms 0ms 12 240 21ms 0ms 13 240 17ms 0ms 14 240 17ms 0ms 15 240 18ms 0ms 16 240 19ms 0ms 17 240 18ms 0ms 18 240 19ms 0ms 19 240 17ms 0ms 20 240 18ms 0ms 21 240 19ms 0ms 22 240 19ms 0ms 23 240 18ms 0ms [ User: symmetricds - Total duration: 435ms - Times executed: 5760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 435ms - Times executed: 5760 ]
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PULL' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'PUSH' ORDER BY last_lock_time;
-
SELECT * FROM sym_node_communication WHERE communication_type = 'FILE_PUSH' ORDER BY last_lock_time;
Date: 2018-08-18 12:33:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 17:04:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 11:56:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 3ms 0ms 11,521 745ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 18 00 481 31ms 0ms 01 480 31ms 0ms 02 480 31ms 0ms 03 480 31ms 0ms 04 480 30ms 0ms 05 480 30ms 0ms 06 480 30ms 0ms 07 480 29ms 0ms 08 480 30ms 0ms 09 480 28ms 0ms 10 480 30ms 0ms 11 480 30ms 0ms 12 480 31ms 0ms 13 480 34ms 0ms 14 480 30ms 0ms 15 480 33ms 0ms 16 480 30ms 0ms 17 480 30ms 0ms 18 480 29ms 0ms 19 480 30ms 0ms 20 480 30ms 0ms 21 480 31ms 0ms 22 480 33ms 0ms 23 480 30ms 0ms [ User: symmetricds - Total duration: 745ms - Times executed: 11521 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 745ms - Times executed: 11521 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type FROM sym_node c INNER JOIN sym_node_identity i ON c.node_id = i.node_id;
Date: 2018-08-18 13:55:44 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 02:33:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:12:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 21,048 1s222ms SELECT itembarcod0_.item_id AS item_id12_13_0_, itembarcod0_.item_barcode_id AS item_bar1_14_0_, itembarcod0_.item_barcode_id AS item_bar1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hassiblings AS hassibli4_14_1_, itembarcod0_.itembarcodetype AS itembarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdby AS createdb8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedby AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.item_id AS item_id12_14_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = '' ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 00 877 50ms 0ms 01 877 53ms 0ms 02 877 50ms 0ms 03 877 52ms 0ms 04 877 50ms 0ms 05 877 49ms 0ms 06 877 55ms 0ms 07 877 50ms 0ms 08 877 50ms 0ms 09 877 50ms 0ms 10 877 49ms 0ms 11 877 50ms 0ms 12 877 50ms 0ms 13 877 52ms 0ms 14 877 50ms 0ms 15 877 49ms 0ms 16 877 52ms 0ms 17 877 50ms 0ms 18 877 49ms 0ms 19 877 50ms 0ms 20 877 52ms 0ms 21 877 50ms 0ms 22 877 50ms 0ms 23 877 50ms 0ms [ User: pharmisight - Total duration: 1s222ms - Times executed: 21048 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s222ms - Times executed: 21048 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3212' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '22' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_13_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_14_1_, itembarcod0_.barcode AS barcode2_14_1_, itembarcod0_.size AS size3_14_1_, itembarcod0_.hasSiblings AS hasSibli4_14_1_, itembarcod0_.itemBarcodeType AS itemBarc5_14_1_, itembarcod0_.status AS status6_14_1_, itembarcod0_.created AS created7_14_1_, itembarcod0_.createdBy AS createdB8_14_1_, itembarcod0_.updated AS updated9_14_1_, itembarcod0_.updatedBy AS updated10_14_1_, itembarcod0_.note AS note11_14_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_14_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '13' ORDER BY itembarcod0_.barcode ASC;
Date: 2018-08-18 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 23,712 1s362ms SELECT itemcodes0_.item_id AS item_id11_13_0_, itemcodes0_.item_code_id AS item_cod1_16_0_, itemcodes0_.item_code_id AS item_cod1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemcodetype AS itemcode3_16_1_, itemcodes0_.isprimary AS isprimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdby AS createdb7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedby AS updatedb9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.item_id AS item_id11_16_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = '' ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 00 988 55ms 0ms 01 988 59ms 0ms 02 988 55ms 0ms 03 988 57ms 0ms 04 988 56ms 0ms 05 988 54ms 0ms 06 988 61ms 0ms 07 988 56ms 0ms 08 988 56ms 0ms 09 988 56ms 0ms 10 988 55ms 0ms 11 988 56ms 0ms 12 988 56ms 0ms 13 988 58ms 0ms 14 988 55ms 0ms 15 988 55ms 0ms 16 988 58ms 0ms 17 988 56ms 0ms 18 988 55ms 0ms 19 988 56ms 0ms 20 988 58ms 0ms 21 988 55ms 0ms 22 988 56ms 0ms 23 988 56ms 0ms [ User: pharmisight - Total duration: 1s362ms - Times executed: 23712 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s362ms - Times executed: 23712 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '1372' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3313' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_13_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_16_1_, itemcodes0_.code AS code2_16_1_, itemcodes0_.itemCodeType AS itemCode3_16_1_, itemcodes0_.isPrimary AS isPrimar4_16_1_, itemcodes0_.status AS status5_16_1_, itemcodes0_.created AS created6_16_1_, itemcodes0_.createdBy AS createdB7_16_1_, itemcodes0_.updated AS updated8_16_1_, itemcodes0_.updatedBy AS updatedB9_16_1_, itemcodes0_.note AS note10_16_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_16_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '30' ORDER BY itemcodes0_.code ASC;
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 03:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 8,583 452ms SELECT count (*) FROM sym_outgoing_batch WHERE STATUS = '';Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 00 356 19ms 0ms 01 357 19ms 0ms 02 358 19ms 0ms 03 358 19ms 0ms 04 357 18ms 0ms 05 358 19ms 0ms 06 358 19ms 0ms 07 357 19ms 0ms 08 358 18ms 0ms 09 358 18ms 0ms 10 357 18ms 0ms 11 358 18ms 0ms 12 358 18ms 0ms 13 358 18ms 0ms 14 357 18ms 0ms 15 358 18ms 0ms 16 358 18ms 0ms 17 358 18ms 0ms 18 357 18ms 0ms 19 358 18ms 0ms 20 358 18ms 0ms 21 357 19ms 0ms 22 358 18ms 0ms 23 358 18ms 0ms [ User: symmetricds - Total duration: 452ms - Times executed: 8583 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 452ms - Times executed: 8583 ]
-
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-08-18 19:30:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 04:40:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 12:06:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 4ms 0ms 16,047 793ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security WHERE node_id = '';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 18 00 700 35ms 0ms 01 667 31ms 0ms 02 668 32ms 0ms 03 668 33ms 0ms 04 667 32ms 0ms 05 668 31ms 0ms 06 668 32ms 0ms 07 667 32ms 0ms 08 668 32ms 0ms 09 668 31ms 0ms 10 665 31ms 0ms 11 666 31ms 0ms 12 667 33ms 0ms 13 667 32ms 0ms 14 666 33ms 0ms 15 667 33ms 0ms 16 666 33ms 0ms 17 666 37ms 0ms 18 665 34ms 0ms 19 666 31ms 0ms 20 668 31ms 0ms 21 669 33ms 0ms 22 670 35ms 0ms 23 670 33ms 0ms [ User: symmetricds - Total duration: 793ms - Times executed: 16047 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 793ms - Times executed: 16047 ]
-
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-08-18 17:46:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:10:38 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 00:26:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 77,247 3s540ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE STATUS = '' ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 00 3,204 145ms 0ms 01 3,213 147ms 0ms 02 3,222 149ms 0ms 03 3,222 150ms 0ms 04 3,213 143ms 0ms 05 3,222 147ms 0ms 06 3,222 149ms 0ms 07 3,213 148ms 0ms 08 3,222 148ms 0ms 09 3,222 144ms 0ms 10 3,213 146ms 0ms 11 3,222 148ms 0ms 12 3,222 149ms 0ms 13 3,222 150ms 0ms 14 3,213 146ms 0ms 15 3,222 144ms 0ms 16 3,222 146ms 0ms 17 3,222 147ms 0ms 18 3,213 147ms 0ms 19 3,222 149ms 0ms 20 3,222 148ms 0ms 21 3,213 144ms 0ms 22 3,222 148ms 0ms 23 3,222 148ms 0ms [ User: symmetricds - Total duration: 3s540ms - Times executed: 77247 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s540ms - Times executed: 77247 ]
-
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-08-18 12:30:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 20:51:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 15:31:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 5,785 219ms SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 00 265 9ms 0ms 01 240 8ms 0ms 02 240 8ms 0ms 03 240 9ms 0ms 04 240 8ms 0ms 05 240 7ms 0ms 06 240 8ms 0ms 07 240 8ms 0ms 08 240 8ms 0ms 09 240 8ms 0ms 10 240 8ms 0ms 11 240 8ms 0ms 12 240 9ms 0ms 13 240 9ms 0ms 14 240 8ms 0ms 15 240 8ms 0ms 16 240 9ms 0ms 17 240 8ms 0ms 18 240 9ms 0ms 19 240 10ms 0ms 20 240 9ms 0ms 21 240 10ms 0ms 22 240 8ms 0ms 23 240 11ms 0ms [ User: symmetricds - Total duration: 219ms - Times executed: 5785 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 219ms - Times executed: 5785 ]
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
-
SELECT lock_action, lock_type, locking_server_id, lock_time, shared_count, shared_enable, last_locking_server_id, last_lock_time FROM sym_lock;
Date: 2018-08-18 19:03:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 18:08:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:53:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,635 284ms SELECT DISTINCT (node_id) FROM sym_extract_request WHERE STATUS = '';Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 18 00 358 11ms 0ms 01 360 12ms 0ms 02 360 11ms 0ms 03 360 11ms 0ms 04 359 11ms 0ms 05 360 11ms 0ms 06 360 11ms 0ms 07 360 11ms 0ms 08 360 11ms 0ms 09 360 11ms 0ms 10 359 11ms 0ms 11 360 11ms 0ms 12 360 11ms 0ms 13 360 12ms 0ms 14 360 12ms 0ms 15 360 11ms 0ms 16 360 11ms 0ms 17 359 11ms 0ms 18 360 12ms 0ms 19 360 12ms 0ms 20 360 11ms 0ms 21 360 12ms 0ms 22 360 11ms 0ms 23 360 12ms 0ms [ User: symmetricds - Total duration: 284ms - Times executed: 8635 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 284ms - Times executed: 8635 ]
-
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-08-18 23:08:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:07:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-08-18 13:54:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 6,474,616 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 18 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-08-18 00:00:11 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: