pgBadger-
Global information
- Generated on Mon Dec 24 00:00:23 2018
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 2,687,036 log entries in 21s
- Log start from 2018-12-23 04:00:09 to 2018-12-23 23:59:59
-
Overview
Global Stats
- 148 Number of unique normalized queries
- 957,013 Number of queries
- 1m28s Total query duration
- 2018-12-23 04:00:09 First query
- 2018-12-23 23:59:59 Last query
- 471 queries/s at 2018-12-23 06:45:51 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 17 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,654 Total number of sessions
- 2 sessions at 2018-12-23 18:31:03 Session peak
- 8d9h6m39s Total duration of sessions
- 7m17s Average duration of sessions
- 578 Average queries per session
- 53ms Average queries duration per session
- 1,654 Total number of connections
- 3 connections/s at 2018-12-23 15:34:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 471 queries/s Query Peak
- 2018-12-23 06:45:51 Date
SELECT Traffic
Key values
- 180 queries/s Query Peak
- 2018-12-23 20:00:45 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 284 queries/s Query Peak
- 2018-12-23 20:00:49 Date
Queries duration
Key values
- 1m28s Total query duration
Prepared queries ratio
Key values
- 1.60 Ratio of bind vs prepare
- 174.38 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 23 04 47,674 0ms 19ms 0ms 89ms 114ms 133ms 05 48,070 0ms 56ms 0ms 92ms 112ms 376ms 06 48,002 0ms 55ms 0ms 88ms 118ms 367ms 07 47,778 0ms 56ms 0ms 96ms 116ms 488ms 08 47,862 0ms 158ms 0ms 96ms 103ms 734ms 09 47,842 0ms 56ms 0ms 102ms 110ms 514ms 10 47,796 0ms 56ms 0ms 93ms 104ms 626ms 11 47,785 0ms 108ms 0ms 94ms 99ms 817ms 12 47,910 0ms 55ms 0ms 92ms 93ms 580ms 13 47,773 0ms 56ms 0ms 95ms 109ms 574ms 14 47,815 0ms 56ms 0ms 101ms 121ms 608ms 15 47,417 0ms 28ms 0ms 87ms 106ms 381ms 16 47,833 0ms 56ms 0ms 93ms 101ms 564ms 17 47,726 0ms 56ms 0ms 88ms 99ms 545ms 18 47,960 0ms 56ms 0ms 94ms 107ms 553ms 19 47,780 0ms 28ms 0ms 93ms 100ms 391ms 20 49,330 0ms 55ms 0ms 97ms 101ms 1s40ms 21 47,674 0ms 56ms 0ms 92ms 110ms 708ms 22 47,413 0ms 56ms 0ms 92ms 104ms 536ms 23 47,573 0ms 56ms 0ms 91ms 105ms 393ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 23 04 14,862 0 0ms 73ms 81ms 95ms 05 15,017 0 0ms 74ms 84ms 100ms 06 14,992 0 0ms 71ms 80ms 98ms 07 14,930 0 0ms 78ms 85ms 108ms 08 14,960 0 0ms 78ms 84ms 90ms 09 14,942 0 0ms 74ms 87ms 96ms 10 14,896 0 0ms 73ms 82ms 101ms 11 14,903 0 0ms 75ms 86ms 91ms 12 14,962 0 0ms 75ms 80ms 90ms 13 14,912 0 0ms 72ms 86ms 93ms 14 14,897 0 0ms 74ms 89ms 103ms 15 14,804 0 0ms 69ms 79ms 96ms 16 14,945 0 0ms 72ms 85ms 101ms 17 14,873 0 0ms 72ms 80ms 87ms 18 14,982 0 0ms 74ms 86ms 107ms 19 14,931 0 0ms 72ms 84ms 88ms 20 15,890 0 0ms 77ms 85ms 111ms 21 14,852 0 0ms 75ms 81ms 97ms 22 14,799 0 0ms 72ms 81ms 95ms 23 14,836 0 0ms 72ms 83ms 91ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 23 04 24 24 48 0 0ms 0ms 0ms 7ms 05 24 25 96 0 1ms 0ms 0ms 7ms 06 24 24 95 0 1ms 0ms 0ms 8ms 07 24 24 93 0 2ms 0ms 0ms 8ms 08 24 25 95 0 4ms 0ms 0ms 7ms 09 24 24 94 0 2ms 0ms 0ms 8ms 10 24 25 93 0 3ms 0ms 0ms 8ms 11 24 25 94 0 4ms 0ms 0ms 4ms 12 24 25 94 0 3ms 0ms 0ms 7ms 13 24 24 94 0 3ms 0ms 0ms 8ms 14 24 22 94 0 3ms 0ms 0ms 7ms 15 24 23 94 0 1ms 0ms 0ms 7ms 16 24 23 95 0 3ms 0ms 0ms 8ms 17 24 23 93 0 3ms 0ms 0ms 7ms 18 24 23 94 0 3ms 0ms 0ms 7ms 19 24 34 94 0 2ms 0ms 1ms 7ms 20 371 146 130 0 0ms 0ms 0ms 25ms 21 24 19 94 0 4ms 0ms 0ms 7ms 22 24 17 97 0 3ms 0ms 0ms 7ms 23 24 17 91 0 2ms 0ms 0ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 23 04 29,935 47,638 1.59 109.79% 05 30,261 48,034 1.59 109.93% 06 30,398 47,966 1.58 110.61% 07 30,144 47,742 1.58 110.18% 08 30,303 47,826 1.58 110.56% 09 30,181 47,806 1.58 110.17% 10 29,543 47,760 1.62 108.01% 11 29,749 47,749 1.61 108.77% 12 30,173 47,874 1.59 109.99% 13 29,802 47,737 1.60 108.97% 14 29,497 47,779 1.62 107.81% 15 29,929 47,381 1.58 110.28% 16 30,228 47,797 1.58 110.38% 17 29,550 47,690 1.61 108.20% 18 30,284 47,924 1.58 110.28% 19 29,824 47,744 1.60 108.97% 20 29,742 49,294 1.66 102.97% 21 29,544 47,659 1.61 108.31% 22 29,952 47,413 1.58 110.39% 23 29,896 47,573 1.59 109.83% Day Hour Count Average / Second Dec 23 04 87 0.02/s 05 87 0.02/s 06 89 0.02/s 07 88 0.02/s 08 89 0.02/s 09 87 0.02/s 10 81 0.02/s 11 83 0.02/s 12 86 0.02/s 13 82 0.02/s 14 77 0.02/s 15 88 0.02/s 16 87 0.02/s 17 79 0.02/s 18 87 0.02/s 19 82 0.02/s 20 79 0.02/s 21 70 0.02/s 22 73 0.02/s 23 73 0.02/s Day Hour Count Average Duration Dec 23 04 87 6m53s 05 87 6m55s 06 89 6m52s 07 88 6m52s 08 89 6m46s 09 87 6m51s 10 81 6m45s 11 83 8m3s 12 86 6m53s 13 82 6m36s 14 77 8m7s 15 88 7m6s 16 87 7m9s 17 79 7m41s 18 87 6m51s 19 82 7m20s 20 79 7m43s 21 70 8m25s 22 73 8m29s 23 73 8m9s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2018-12-23 15:34:27 Date
Connections per database
Key values
- pharmisight Main Database
- 1,654 connections Total
Connections per user
Key values
- pharmisight Main User
- 1,654 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2018-12-23 18:31:03 Date
Histogram of session times
Key values
- 1,226 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,654 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 1,654 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,654 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,308 buffers Checkpoint Peak
- 2018-12-23 08:06:37 Date
- 149.541 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-12-23 08:06:37 Date
Checkpoints distance
Key values
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 23 04 171 17.158s 0.008s 17.189s 05 149 14.95s 0.006s 14.98s 06 746 74.74s 0.008s 74.771s 07 120 12.043s 0.006s 12.075s 08 2,381 156.72s 0.005s 156.749s 09 697 69.826s 0.006s 69.856s 10 801 80.169s 0.007s 80.201s 11 2,176 156.267s 0.005s 156.293s 12 527 52.682s 0.006s 52.712s 13 130 13.047s 0.009s 13.089s 14 106 10.637s 0.007s 10.669s 15 116 11.642s 0.014s 11.683s 16 110 11.042s 0.006s 11.069s 17 146 14.655s 0.007s 14.684s 18 157 15.757s 0.005s 15.785s 19 148 14.858s 0.007s 14.894s 20 221 22.183s 0.006s 22.212s 21 165 16.56s 0.006s 16.594s 22 138 13.851s 0.005s 13.878s 23 212 21.271s 0.004s 21.307s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 23 04 0 0 0 76 0.003s 0s 05 0 0 0 81 0.002s 0s 06 0 0 0 87 0.002s 0s 07 0 0 0 77 0.002s 0s 08 0 0 1 92 0.002s 0s 09 0 0 0 82 0.003s 0s 10 0 0 1 87 0.002s 0s 11 0 0 0 83 0.002s 0s 12 0 0 1 88 0.002s 0s 13 0 0 0 79 0.003s 0s 14 0 0 0 75 0.002s 0s 15 0 0 0 79 0.006s 0.006s 16 0 0 0 76 0.002s 0s 17 0 0 0 83 0.002s 0s 18 0 0 0 80 0.002s 0s 19 0 0 0 77 0.002s 0s 20 0 0 0 114 0.002s 0s 21 0 0 0 80 0.002s 0.001s 22 0 0 0 76 0.002s 0s 23 0 0 0 81 0.001s 0s Day Hour Count Avg time (sec) Dec 23 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Dec 23 04 178.00 kB 445.25 kB 05 145.25 kB 339.25 kB 06 1,046.25 kB 3,425.75 kB 07 91.50 kB 2,279.00 kB 08 3,113.25 kB 10,539.75 kB 09 859.00 kB 7,211.75 kB 10 951.00 kB 5,058.50 kB 11 3,021.50 kB 10,220.25 kB 12 557.50 kB 6,898.50 kB 13 94.75 kB 4,557.25 kB 14 73.50 kB 3,016.50 kB 15 74.20 kB 1,914.60 kB 16 86.25 kB 1,216.50 kB 17 139.50 kB 842.75 kB 18 143.75 kB 604.00 kB 19 98.00 kB 421.40 kB 20 300.00 kB 866.00 kB 21 117.80 kB 589.40 kB 22 107.75 kB 401.00 kB 23 149.25 kB 307.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 23 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (7) Main table analyzed (database pharmisight)
- 17 analyzes Total
Vacuums per table
Key values
- public.sym_outgoing_batch (3) Main table vacuumed on database pharmisight
- 7 vacuums Total
Tuples removed per table
Key values
- public.sym_data_event (13002) Main table with removed tuples on database pharmisight
- 14942 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 23 04 0 0 05 0 1 06 0 1 07 0 0 08 2 2 09 1 2 10 1 2 11 1 2 12 1 1 13 1 0 14 0 0 15 0 1 16 0 0 17 0 1 18 0 1 19 0 0 20 0 1 21 0 1 22 0 0 23 0 1 - 0 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
- 299,185 Total read queries
- 249,279 Total write queries
Queries by database
Key values
- pharmisight Main database
- 957,013 Requests
- 1m28s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 951,385 Requests
User Request type Count Duration pharmisight Total 5,001 839ms DELETE 35 3ms INSERT 84 17ms OTHERS 2,838 102ms SELECT 1,530 666ms TCL 382 12ms UPDATE 132 37ms symmetricds Total 951,385 1m27s DELETE 1,837 7s818ms INSERT 743 99ms OTHERS 405,711 6s337ms SELECT 297,028 1m9s TCL 245,606 3s429ms UPDATE 460 611ms tony Total 627 174ms SELECT 627 174ms Duration by user
Key values
- 1m27s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 5,001 839ms DELETE 35 3ms INSERT 84 17ms OTHERS 2,838 102ms SELECT 1,530 666ms TCL 382 12ms UPDATE 132 37ms symmetricds Total 951,385 1m27s DELETE 1,837 7s818ms INSERT 743 99ms OTHERS 405,711 6s337ms SELECT 297,028 1m9s TCL 245,606 3s429ms UPDATE 460 611ms tony Total 627 174ms SELECT 627 174ms Queries by host
Key values
- 10.10.10.1 Main host
- 956,386 Requests
- 1m28s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 954,941 Requests
- 1m28s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-12-23 12:50:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 937,843 0-1ms duration
Slowest individual queries
Rank Duration Query 1 158ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN $1 AND $2 AND status != $3) AND batch_id BETWEEN $4 AND $5;[ Date: 2018-12-23 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 108ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN $1 AND $2 AND status != $3) AND batch_id BETWEEN $4 AND $5;[ Date: 2018-12-23 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 21:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 23:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 22:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 18:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 56ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 17:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 55ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 55ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 20:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 55ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 54ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2018-12-23 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 52ms DELETE FROM sym_outgoing_batch WHERE status = $1 AND batch_id BETWEEN $2 AND $3 AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN $4 AND $5);[ Date: 2018-12-23 08: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 33s931ms 20,453 0ms 26ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 23 04 1,024 1s693ms 1ms 05 1,024 1s703ms 1ms 06 1,024 1s667ms 1ms 07 1,024 1s739ms 1ms 08 1,024 1s674ms 1ms 09 1,024 1s702ms 1ms 10 1,024 1s691ms 1ms 11 1,024 1s718ms 1ms 12 1,024 1s746ms 1ms 13 1,024 1s724ms 1ms 14 1,024 1s751ms 1ms 15 1,007 1s679ms 1ms 16 1,024 1s711ms 1ms 17 1,024 1s651ms 1ms 18 1,024 1s661ms 1ms 19 1,024 1s663ms 1ms 20 1,024 1s729ms 1ms 21 1,022 1s712ms 1ms 22 1,020 1s620ms 1ms 23 1,020 1s687ms 1ms [ User: symmetricds - Total duration: 33s931ms - Times executed: 20453 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s931ms - Times executed: 20453 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2018-12-23 21:54:08 Duration: 26ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 13:21:57 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:13:53 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 11s626ms 21,477 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 23 04 1,074 572ms 0ms 05 1,074 579ms 0ms 06 1,074 583ms 0ms 07 1,074 581ms 0ms 08 1,074 584ms 0ms 09 1,074 575ms 0ms 10 1,074 584ms 0ms 11 1,074 585ms 0ms 12 1,074 595ms 0ms 13 1,074 584ms 0ms 14 1,074 586ms 0ms 15 1,071 577ms 0ms 16 1,074 579ms 0ms 17 1,074 593ms 0ms 18 1,074 582ms 0ms 19 1,074 581ms 0ms 20 1,071 573ms 0ms 21 1,074 576ms 0ms 22 1,074 575ms 0ms 23 1,077 573ms 0ms [ User: symmetricds - Total duration: 11s626ms - Times executed: 21477 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s626ms - Times executed: 21477 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2018-12-23 23:29:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:45:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:26:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 10s921ms 6,799 0ms 32ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 23 04 340 610ms 1ms 05 340 571ms 1ms 06 340 555ms 1ms 07 340 593ms 1ms 08 340 643ms 1ms 09 340 538ms 1ms 10 340 585ms 1ms 11 340 631ms 1ms 12 340 511ms 1ms 13 340 510ms 1ms 14 340 540ms 1ms 15 339 486ms 1ms 16 340 496ms 1ms 17 340 499ms 1ms 18 340 520ms 1ms 19 340 499ms 1ms 20 340 563ms 1ms 21 340 510ms 1ms 22 340 505ms 1ms 23 340 545ms 1ms [ User: symmetricds - Total duration: 10s921ms - Times executed: 6799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s921ms - Times executed: 6799 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) ORDER BY batch_id ASC;
Date: 2018-12-23 20:07:05 Duration: 32ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:03:55 Duration: 30ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:09:51 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 6s139ms 390,517 0ms 6ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 23 04 19,518 309ms 0ms 05 19,632 303ms 0ms 06 19,602 311ms 0ms 07 19,510 304ms 0ms 08 19,537 304ms 0ms 09 19,539 301ms 0ms 10 19,546 306ms 0ms 11 19,533 319ms 0ms 12 19,569 310ms 0ms 13 19,523 306ms 0ms 14 19,566 310ms 0ms 15 19,368 304ms 0ms 16 19,535 308ms 0ms 17 19,524 310ms 0ms 18 19,589 312ms 0ms 19 19,511 305ms 0ms 20 19,549 303ms 0ms 21 19,515 303ms 0ms 22 19,387 301ms 0ms 23 19,464 301ms 0ms [ User: symmetricds - Total duration: 6s100ms - Times executed: 389571 ]
[ User: pharmisight - Total duration: 38ms - Times executed: 946 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s139ms - Times executed: 390517 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-23 18:43:04 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:38:51 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:28:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 4s404ms 342 0ms 45ms 12ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 23 05 18 138ms 7ms 06 18 137ms 7ms 07 18 228ms 12ms 08 18 248ms 13ms 09 18 204ms 11ms 10 18 224ms 12ms 11 18 307ms 17ms 12 18 257ms 14ms 13 18 264ms 14ms 14 18 262ms 14ms 15 18 132ms 7ms 16 18 250ms 13ms 17 18 249ms 13ms 18 18 251ms 13ms 19 18 217ms 12ms 20 18 261ms 14ms 21 18 377ms 20ms 22 18 253ms 14ms 23 18 137ms 7ms [ User: symmetricds - Total duration: 4s404ms - Times executed: 342 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s404ms - Times executed: 342 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2018-12-23 06:00:00 Duration: 45ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:00:00 Duration: 36ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:00:00 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 2s823ms 342 0ms 17ms 8ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 23 05 18 83ms 4ms 06 18 80ms 4ms 07 18 114ms 6ms 08 18 130ms 7ms 09 18 128ms 7ms 10 18 148ms 8ms 11 18 186ms 10ms 12 18 172ms 9ms 13 18 172ms 9ms 14 18 171ms 9ms 15 18 91ms 5ms 16 18 179ms 9ms 17 18 170ms 9ms 18 18 172ms 9ms 19 18 94ms 5ms 20 18 172ms 9ms 21 18 221ms 12ms 22 18 172ms 9ms 23 18 161ms 8ms [ User: symmetricds - Total duration: 2s823ms - Times executed: 342 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s823ms - Times executed: 342 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
Date: 2018-12-23 21:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 16:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 2s682ms 122,994 0ms 14ms 0ms COMMIT;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 23 04 6,154 145ms 0ms 05 6,183 132ms 0ms 06 6,174 131ms 0ms 07 6,144 144ms 0ms 08 6,152 129ms 0ms 09 6,156 130ms 0ms 10 6,157 135ms 0ms 11 6,152 132ms 0ms 12 6,164 133ms 0ms 13 6,148 134ms 0ms 14 6,161 133ms 0ms 15 6,097 130ms 0ms 16 6,149 132ms 0ms 17 6,149 134ms 0ms 18 6,169 132ms 0ms 19 6,143 140ms 0ms 20 6,174 144ms 0ms 21 6,144 128ms 0ms 22 6,098 133ms 0ms 23 6,126 123ms 0ms [ User: symmetricds - Total duration: 2s671ms - Times executed: 122803 ]
[ User: pharmisight - Total duration: 11ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s682ms - Times executed: 122994 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-23 07:00:55 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:00:59 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 19:11:04 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s700ms 408 1ms 10ms 4ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 23 04 20 80ms 4ms 05 23 90ms 3ms 06 24 96ms 4ms 07 20 84ms 4ms 08 25 105ms 4ms 09 21 83ms 3ms 10 16 71ms 4ms 11 21 85ms 4ms 12 23 94ms 4ms 13 18 77ms 4ms 14 16 65ms 4ms 15 21 88ms 4ms 16 25 106ms 4ms 17 19 81ms 4ms 18 21 81ms 3ms 19 19 79ms 4ms 20 15 67ms 4ms 21 17 71ms 4ms 22 24 102ms 4ms 23 20 84ms 4ms [ User: symmetricds - Total duration: 1s700ms - Times executed: 408 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s700ms - Times executed: 408 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 22:39:08 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:54:08 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 20:37:07 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s505ms 139,782 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 23 04 6,940 75ms 0ms 05 7,034 74ms 0ms 06 7,017 74ms 0ms 07 6,986 76ms 0ms 08 6,996 73ms 0ms 09 6,996 73ms 0ms 10 6,997 76ms 0ms 11 6,995 74ms 0ms 12 7,008 82ms 0ms 13 6,994 75ms 0ms 14 7,005 75ms 0ms 15 6,933 74ms 0ms 16 6,999 75ms 0ms 17 6,985 74ms 0ms 18 7,012 74ms 0ms 19 6,985 74ms 0ms 20 7,007 73ms 0ms 21 6,985 77ms 0ms 22 6,944 75ms 0ms 23 6,964 74ms 0ms [ User: symmetricds - Total duration: 1s505ms - Times executed: 139782 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s505ms - Times executed: 139782 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-23 12:14:56 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:25:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:02:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s38ms 21,548 0ms 0ms 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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 23 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 50ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 52ms 0ms 12 1,078 53ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,075 51ms 0ms 16 1,078 52ms 0ms 17 1,078 53ms 0ms 18 1,078 51ms 0ms 19 1,078 52ms 0ms 20 1,076 51ms 0ms 21 1,076 51ms 0ms 22 1,074 51ms 0ms 23 1,077 51ms 0ms [ User: symmetricds - Total duration: 1s38ms - Times executed: 21548 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s38ms - Times executed: 21548 ]
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2018-12-23 11:17:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:49:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 22:26:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s13ms 19 28ms 56ms 53ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 23 05 1 56ms 56ms 06 1 55ms 55ms 07 1 56ms 56ms 08 1 54ms 54ms 09 1 56ms 56ms 10 1 56ms 56ms 11 1 56ms 56ms 12 1 55ms 55ms 13 1 56ms 56ms 14 1 56ms 56ms 15 1 28ms 28ms 16 1 56ms 56ms 17 1 56ms 56ms 18 1 56ms 56ms 19 1 28ms 28ms 20 1 55ms 55ms 21 1 56ms 56ms 22 1 56ms 56ms 23 1 56ms 56ms [ User: symmetricds - Total duration: 1s13ms - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s13ms - Times executed: 19 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2018-12-23 13:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 966ms 20,383 0ms 3ms 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;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 23 04 1,020 48ms 0ms 05 1,020 49ms 0ms 06 1,020 47ms 0ms 07 1,020 46ms 0ms 08 1,020 50ms 0ms 09 1,020 46ms 0ms 10 1,020 49ms 0ms 11 1,020 51ms 0ms 12 1,020 49ms 0ms 13 1,020 45ms 0ms 14 1,020 48ms 0ms 15 1,013 47ms 0ms 16 1,020 48ms 0ms 17 1,020 46ms 0ms 18 1,020 47ms 0ms 19 1,020 53ms 0ms 20 1,018 48ms 0ms 21 1,018 46ms 0ms 22 1,016 47ms 0ms 23 1,018 48ms 0ms [ User: symmetricds - Total duration: 966ms - Times executed: 20383 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 966ms - Times executed: 20383 ]
-
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;
-
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;
-
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;
Date: 2018-12-23 19:06:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:02:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:09:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 758ms 122,994 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 23 04 6,154 37ms 0ms 05 6,183 37ms 0ms 06 6,174 37ms 0ms 07 6,144 37ms 0ms 08 6,152 37ms 0ms 09 6,156 36ms 0ms 10 6,157 38ms 0ms 11 6,152 38ms 0ms 12 6,164 37ms 0ms 13 6,148 37ms 0ms 14 6,161 38ms 0ms 15 6,097 38ms 0ms 16 6,149 38ms 0ms 17 6,149 40ms 0ms 18 6,169 37ms 0ms 19 6,143 37ms 0ms 20 6,174 37ms 0ms 21 6,144 37ms 0ms 22 6,098 37ms 0ms 23 6,126 37ms 0ms [ User: symmetricds - Total duration: 757ms - Times executed: 122803 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 758ms - Times executed: 122994 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-23 17:16:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:13:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:52:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 717ms 493 0ms 4ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 23 04 27 39ms 1ms 05 27 38ms 1ms 06 29 40ms 1ms 07 28 41ms 1ms 08 29 41ms 1ms 09 27 37ms 1ms 10 20 28ms 1ms 11 22 32ms 1ms 12 26 37ms 1ms 13 23 34ms 1ms 14 18 25ms 1ms 15 29 42ms 1ms 16 27 39ms 1ms 17 19 30ms 1ms 18 28 39ms 1ms 19 23 32ms 1ms 20 20 29ms 1ms 21 20 28ms 1ms 22 26 38ms 1ms 23 25 35ms 1ms [ User: symmetricds - Total duration: 717ms - Times executed: 493 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 717ms - Times executed: 493 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 17:16:02 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 13:34:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:11:01 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 628ms 5,386 0ms 1ms 0ms SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 23 04 271 30ms 0ms 05 282 31ms 0ms 06 278 31ms 0ms 07 263 29ms 0ms 08 268 30ms 0ms 09 269 31ms 0ms 10 269 31ms 0ms 11 268 30ms 0ms 12 274 33ms 0ms 13 265 31ms 0ms 14 272 32ms 0ms 15 253 30ms 0ms 16 267 30ms 0ms 17 267 32ms 0ms 18 278 31ms 0ms 19 263 32ms 0ms 20 271 32ms 0ms 21 274 31ms 0ms 22 263 30ms 0ms 23 271 31ms 0ms [ User: symmetricds - Total duration: 628ms - Times executed: 5386 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 628ms - Times executed: 5386 ]
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-23 19:20:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:36:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:08:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 569ms 592 0ms 12ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 23 04 31 28ms 0ms 05 33 42ms 1ms 06 32 30ms 0ms 07 34 32ms 0ms 08 34 32ms 0ms 09 33 30ms 0ms 10 25 23ms 0ms 11 25 23ms 0ms 12 31 29ms 0ms 13 29 27ms 0ms 14 23 22ms 0ms 15 34 32ms 0ms 16 33 30ms 0ms 17 23 22ms 0ms 18 34 31ms 0ms 19 28 26ms 0ms 20 27 25ms 0ms 21 24 22ms 0ms 22 30 27ms 0ms 23 29 27ms 0ms [ User: symmetricds - Total duration: 569ms - Times executed: 592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 569ms - Times executed: 592 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) 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), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) 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), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 05:30:50 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:38:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 14:32:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 520ms 80 1ms 8ms 6ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 23 04 4 29ms 7ms 05 4 25ms 6ms 06 4 26ms 6ms 07 4 27ms 6ms 08 4 26ms 6ms 09 4 25ms 6ms 10 4 25ms 6ms 11 4 16ms 4ms 12 4 25ms 6ms 13 4 25ms 6ms 14 4 27ms 6ms 15 4 28ms 7ms 16 4 27ms 6ms 17 4 28ms 7ms 18 4 25ms 6ms 19 4 20ms 5ms 20 4 29ms 7ms 21 4 25ms 6ms 22 4 27ms 6ms 23 4 25ms 6ms [ User: symmetricds - Total duration: 520ms - Times executed: 80 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 520ms - Times executed: 80 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2018-12-23 16:30:54 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:30:50 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:30:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 451ms 489 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 23 04 27 24ms 0ms 05 26 23ms 0ms 06 29 27ms 0ms 07 28 26ms 0ms 08 29 26ms 0ms 09 27 25ms 0ms 10 21 19ms 0ms 11 21 19ms 0ms 12 26 23ms 0ms 13 23 21ms 0ms 14 19 18ms 0ms 15 26 24ms 0ms 16 28 25ms 0ms 17 19 17ms 0ms 18 26 23ms 0ms 19 23 20ms 0ms 20 19 17ms 0ms 21 20 18ms 0ms 22 27 24ms 0ms 23 25 22ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 489 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 489 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 15:31:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:50:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:18:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 432ms 489 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 23 04 27 23ms 0ms 05 26 22ms 0ms 06 29 25ms 0ms 07 28 24ms 0ms 08 29 25ms 0ms 09 27 24ms 0ms 10 21 18ms 0ms 11 21 18ms 0ms 12 26 22ms 0ms 13 23 20ms 0ms 14 19 17ms 0ms 15 26 22ms 0ms 16 28 24ms 0ms 17 19 17ms 0ms 18 26 22ms 0ms 19 23 19ms 0ms 20 19 17ms 0ms 21 20 17ms 0ms 22 27 23ms 0ms 23 25 22ms 0ms [ User: symmetricds - Total duration: 432ms - Times executed: 489 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 432ms - Times executed: 489 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) 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), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) 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), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 17:08:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 20:19:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:50:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 387ms 14,388 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 23 04 718 19ms 0ms 05 720 19ms 0ms 06 720 18ms 0ms 07 718 19ms 0ms 08 720 19ms 0ms 09 720 19ms 0ms 10 720 19ms 0ms 11 718 19ms 0ms 12 720 19ms 0ms 13 720 19ms 0ms 14 720 19ms 0ms 15 718 18ms 0ms 16 720 20ms 0ms 17 720 19ms 0ms 18 718 19ms 0ms 19 720 19ms 0ms 20 720 18ms 0ms 21 720 19ms 0ms 22 718 19ms 0ms 23 720 19ms 0ms [ User: symmetricds - Total duration: 387ms - Times executed: 14388 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 387ms - Times executed: 14388 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2018-12-23 10:23:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:31:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:31:41 Duration: 0ms 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 390,517 6s139ms 0ms 6ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 23 04 19,518 309ms 0ms 05 19,632 303ms 0ms 06 19,602 311ms 0ms 07 19,510 304ms 0ms 08 19,537 304ms 0ms 09 19,539 301ms 0ms 10 19,546 306ms 0ms 11 19,533 319ms 0ms 12 19,569 310ms 0ms 13 19,523 306ms 0ms 14 19,566 310ms 0ms 15 19,368 304ms 0ms 16 19,535 308ms 0ms 17 19,524 310ms 0ms 18 19,589 312ms 0ms 19 19,511 305ms 0ms 20 19,549 303ms 0ms 21 19,515 303ms 0ms 22 19,387 301ms 0ms 23 19,464 301ms 0ms [ User: symmetricds - Total duration: 6s100ms - Times executed: 389571 ]
[ User: pharmisight - Total duration: 38ms - Times executed: 946 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s139ms - Times executed: 390517 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-23 18:43:04 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:38:51 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:28:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 139,782 1s505ms 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 23 04 6,940 75ms 0ms 05 7,034 74ms 0ms 06 7,017 74ms 0ms 07 6,986 76ms 0ms 08 6,996 73ms 0ms 09 6,996 73ms 0ms 10 6,997 76ms 0ms 11 6,995 74ms 0ms 12 7,008 82ms 0ms 13 6,994 75ms 0ms 14 7,005 75ms 0ms 15 6,933 74ms 0ms 16 6,999 75ms 0ms 17 6,985 74ms 0ms 18 7,012 74ms 0ms 19 6,985 74ms 0ms 20 7,007 73ms 0ms 21 6,985 77ms 0ms 22 6,944 75ms 0ms 23 6,964 74ms 0ms [ User: symmetricds - Total duration: 1s505ms - Times executed: 139782 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s505ms - Times executed: 139782 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-23 12:14:56 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:25:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:02:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 122,994 2s682ms 0ms 14ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 23 04 6,154 145ms 0ms 05 6,183 132ms 0ms 06 6,174 131ms 0ms 07 6,144 144ms 0ms 08 6,152 129ms 0ms 09 6,156 130ms 0ms 10 6,157 135ms 0ms 11 6,152 132ms 0ms 12 6,164 133ms 0ms 13 6,148 134ms 0ms 14 6,161 133ms 0ms 15 6,097 130ms 0ms 16 6,149 132ms 0ms 17 6,149 134ms 0ms 18 6,169 132ms 0ms 19 6,143 140ms 0ms 20 6,174 144ms 0ms 21 6,144 128ms 0ms 22 6,098 133ms 0ms 23 6,126 123ms 0ms [ User: symmetricds - Total duration: 2s671ms - Times executed: 122803 ]
[ User: pharmisight - Total duration: 11ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s682ms - Times executed: 122994 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-23 07:00:55 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:00:59 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 19:11:04 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 122,994 758ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 23 04 6,154 37ms 0ms 05 6,183 37ms 0ms 06 6,174 37ms 0ms 07 6,144 37ms 0ms 08 6,152 37ms 0ms 09 6,156 36ms 0ms 10 6,157 38ms 0ms 11 6,152 38ms 0ms 12 6,164 37ms 0ms 13 6,148 37ms 0ms 14 6,161 38ms 0ms 15 6,097 38ms 0ms 16 6,149 38ms 0ms 17 6,149 40ms 0ms 18 6,169 37ms 0ms 19 6,143 37ms 0ms 20 6,174 37ms 0ms 21 6,144 37ms 0ms 22 6,098 37ms 0ms 23 6,126 37ms 0ms [ User: symmetricds - Total duration: 757ms - Times executed: 122803 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 758ms - Times executed: 122994 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-23 17:16:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:13:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:52:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 21,548 1s38ms 0ms 0ms 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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 23 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 50ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 52ms 0ms 12 1,078 53ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,075 51ms 0ms 16 1,078 52ms 0ms 17 1,078 53ms 0ms 18 1,078 51ms 0ms 19 1,078 52ms 0ms 20 1,076 51ms 0ms 21 1,076 51ms 0ms 22 1,074 51ms 0ms 23 1,077 51ms 0ms [ User: symmetricds - Total duration: 1s38ms - Times executed: 21548 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s38ms - Times executed: 21548 ]
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2018-12-23 11:17:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:49:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 22:26:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 21,477 11s626ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 23 04 1,074 572ms 0ms 05 1,074 579ms 0ms 06 1,074 583ms 0ms 07 1,074 581ms 0ms 08 1,074 584ms 0ms 09 1,074 575ms 0ms 10 1,074 584ms 0ms 11 1,074 585ms 0ms 12 1,074 595ms 0ms 13 1,074 584ms 0ms 14 1,074 586ms 0ms 15 1,071 577ms 0ms 16 1,074 579ms 0ms 17 1,074 593ms 0ms 18 1,074 582ms 0ms 19 1,074 581ms 0ms 20 1,071 573ms 0ms 21 1,074 576ms 0ms 22 1,074 575ms 0ms 23 1,077 573ms 0ms [ User: symmetricds - Total duration: 11s626ms - Times executed: 21477 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s626ms - Times executed: 21477 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2018-12-23 23:29:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:45:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:26:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 20,453 33s931ms 0ms 26ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 23 04 1,024 1s693ms 1ms 05 1,024 1s703ms 1ms 06 1,024 1s667ms 1ms 07 1,024 1s739ms 1ms 08 1,024 1s674ms 1ms 09 1,024 1s702ms 1ms 10 1,024 1s691ms 1ms 11 1,024 1s718ms 1ms 12 1,024 1s746ms 1ms 13 1,024 1s724ms 1ms 14 1,024 1s751ms 1ms 15 1,007 1s679ms 1ms 16 1,024 1s711ms 1ms 17 1,024 1s651ms 1ms 18 1,024 1s661ms 1ms 19 1,024 1s663ms 1ms 20 1,024 1s729ms 1ms 21 1,022 1s712ms 1ms 22 1,020 1s620ms 1ms 23 1,020 1s687ms 1ms [ User: symmetricds - Total duration: 33s931ms - Times executed: 20453 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s931ms - Times executed: 20453 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2018-12-23 21:54:08 Duration: 26ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 13:21:57 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:13:53 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 20,383 966ms 0ms 3ms 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;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 23 04 1,020 48ms 0ms 05 1,020 49ms 0ms 06 1,020 47ms 0ms 07 1,020 46ms 0ms 08 1,020 50ms 0ms 09 1,020 46ms 0ms 10 1,020 49ms 0ms 11 1,020 51ms 0ms 12 1,020 49ms 0ms 13 1,020 45ms 0ms 14 1,020 48ms 0ms 15 1,013 47ms 0ms 16 1,020 48ms 0ms 17 1,020 46ms 0ms 18 1,020 47ms 0ms 19 1,020 53ms 0ms 20 1,018 48ms 0ms 21 1,018 46ms 0ms 22 1,016 47ms 0ms 23 1,018 48ms 0ms [ User: symmetricds - Total duration: 966ms - Times executed: 20383 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 966ms - Times executed: 20383 ]
-
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;
-
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;
-
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;
Date: 2018-12-23 19:06:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:02:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:09:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 14,388 387ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 23 04 718 19ms 0ms 05 720 19ms 0ms 06 720 18ms 0ms 07 718 19ms 0ms 08 720 19ms 0ms 09 720 19ms 0ms 10 720 19ms 0ms 11 718 19ms 0ms 12 720 19ms 0ms 13 720 19ms 0ms 14 720 19ms 0ms 15 718 18ms 0ms 16 720 20ms 0ms 17 720 19ms 0ms 18 718 19ms 0ms 19 720 19ms 0ms 20 720 18ms 0ms 21 720 19ms 0ms 22 718 19ms 0ms 23 720 19ms 0ms [ User: symmetricds - Total duration: 387ms - Times executed: 14388 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 387ms - Times executed: 14388 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2018-12-23 10:23:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:31:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:31:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 7,571 116ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 23 04 370 5ms 0ms 05 380 6ms 0ms 06 383 5ms 0ms 07 377 5ms 0ms 08 383 5ms 0ms 09 377 5ms 0ms 10 380 5ms 0ms 11 380 6ms 0ms 12 380 5ms 0ms 13 380 5ms 0ms 14 380 5ms 0ms 15 379 5ms 0ms 16 383 5ms 0ms 17 377 5ms 0ms 18 380 5ms 0ms 19 380 5ms 0ms 20 381 5ms 0ms 21 376 5ms 0ms 22 375 5ms 0ms 23 370 5ms 0ms [ User: symmetricds - Total duration: 116ms - Times executed: 7571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 116ms - Times executed: 7571 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2018-12-23 05:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:15:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 7,571 86ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 23 04 370 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 380 4ms 0ms 12 380 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 379 4ms 0ms 16 380 4ms 0ms 17 380 4ms 0ms 18 380 4ms 0ms 19 380 4ms 0ms 20 381 4ms 0ms 21 376 4ms 0ms 22 372 4ms 0ms 23 373 4ms 0ms [ User: symmetricds - Total duration: 86ms - Times executed: 7571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 86ms - Times executed: 7571 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2018-12-23 18:16:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:06:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 18:36:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 7,159 239ms 0ms 1ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 23 04 358 11ms 0ms 05 358 11ms 0ms 06 358 11ms 0ms 07 358 11ms 0ms 08 358 12ms 0ms 09 358 11ms 0ms 10 358 11ms 0ms 11 358 13ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 357 11ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 11ms 0ms 19 358 11ms 0ms 20 357 11ms 0ms 21 358 11ms 0ms 22 358 12ms 0ms 23 359 11ms 0ms [ User: symmetricds - Total duration: 239ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 239ms - Times executed: 7159 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
Date: 2018-12-23 11:00:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:16:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:13:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 7,159 178ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 23 04 358 8ms 0ms 05 358 9ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 358 9ms 0ms 11 358 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 358 9ms 0ms 15 357 8ms 0ms 16 358 8ms 0ms 17 358 9ms 0ms 18 358 8ms 0ms 19 358 9ms 0ms 20 357 8ms 0ms 21 358 8ms 0ms 22 358 8ms 0ms 23 359 8ms 0ms [ User: symmetricds - Total duration: 178ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 178ms - Times executed: 7159 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
Date: 2018-12-23 14:53:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 18:25:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 19:29:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 7,159 246ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 23 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 357 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 11ms 0ms 19 358 12ms 0ms 20 357 12ms 0ms 21 358 12ms 0ms 22 358 11ms 0ms 23 359 12ms 0ms [ User: symmetricds - Total duration: 246ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 246ms - Times executed: 7159 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2018-12-23 05:25:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:24:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:15:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 7,159 327ms 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 #15
Day Hour Count Duration Avg duration Dec 23 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 15ms 0ms 15 357 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 16ms 0ms 20 357 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 359 16ms 0ms [ User: symmetricds - Total duration: 327ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 327ms - Times executed: 7159 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2018-12-23 20:10:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:10:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:38:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 6,799 10s921ms 0ms 32ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 23 04 340 610ms 1ms 05 340 571ms 1ms 06 340 555ms 1ms 07 340 593ms 1ms 08 340 643ms 1ms 09 340 538ms 1ms 10 340 585ms 1ms 11 340 631ms 1ms 12 340 511ms 1ms 13 340 510ms 1ms 14 340 540ms 1ms 15 339 486ms 1ms 16 340 496ms 1ms 17 340 499ms 1ms 18 340 520ms 1ms 19 340 499ms 1ms 20 340 563ms 1ms 21 340 510ms 1ms 22 340 505ms 1ms 23 340 545ms 1ms [ User: symmetricds - Total duration: 10s921ms - Times executed: 6799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s921ms - Times executed: 6799 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) ORDER BY batch_id ASC;
Date: 2018-12-23 20:07:05 Duration: 32ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:03:55 Duration: 30ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:09:51 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 5,386 628ms 0ms 1ms 0ms SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 23 04 271 30ms 0ms 05 282 31ms 0ms 06 278 31ms 0ms 07 263 29ms 0ms 08 268 30ms 0ms 09 269 31ms 0ms 10 269 31ms 0ms 11 268 30ms 0ms 12 274 33ms 0ms 13 265 31ms 0ms 14 272 32ms 0ms 15 253 30ms 0ms 16 267 30ms 0ms 17 267 32ms 0ms 18 278 31ms 0ms 19 263 32ms 0ms 20 271 32ms 0ms 21 274 31ms 0ms 22 263 30ms 0ms 23 271 31ms 0ms [ User: symmetricds - Total duration: 628ms - Times executed: 5386 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 628ms - Times executed: 5386 ]
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-23 19:20:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:36:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:08:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 5,386 280ms 0ms 10ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 23 04 271 13ms 0ms 05 282 13ms 0ms 06 278 13ms 0ms 07 263 13ms 0ms 08 268 13ms 0ms 09 269 12ms 0ms 10 269 14ms 0ms 11 268 13ms 0ms 12 274 25ms 0ms 13 265 13ms 0ms 14 272 14ms 0ms 15 253 12ms 0ms 16 267 13ms 0ms 17 267 13ms 0ms 18 278 13ms 0ms 19 263 13ms 0ms 20 271 13ms 0ms 21 274 13ms 0ms 22 263 12ms 0ms 23 271 14ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 5386 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 5386 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2018-12-23 12:22:56 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 23:54:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:16:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1,445 42ms 0ms 0ms 0ms SET application_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 23 04 75 2ms 0ms 05 75 2ms 0ms 06 77 2ms 0ms 07 76 2ms 0ms 08 77 2ms 0ms 09 75 2ms 0ms 10 69 2ms 0ms 11 71 2ms 0ms 12 74 2ms 0ms 13 70 2ms 0ms 14 65 1ms 0ms 15 76 2ms 0ms 16 75 2ms 0ms 17 67 1ms 0ms 18 75 2ms 0ms 19 70 2ms 0ms 20 67 2ms 0ms 21 65 2ms 0ms 22 73 2ms 0ms 23 73 2ms 0ms [ User: pharmisight - Total duration: 27ms - Times executed: 946 ]
[ User: symmetricds - Total duration: 14ms - Times executed: 499 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42ms - Times executed: 1445 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2018-12-23 21:43:12 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:18:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:51:57 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,445 55ms 0ms 0ms 0ms SET extra_float_digits = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 23 04 75 2ms 0ms 05 75 2ms 0ms 06 77 2ms 0ms 07 76 2ms 0ms 08 77 2ms 0ms 09 75 2ms 0ms 10 69 2ms 0ms 11 71 2ms 0ms 12 74 3ms 0ms 13 70 2ms 0ms 14 65 2ms 0ms 15 76 2ms 0ms 16 75 2ms 0ms 17 67 2ms 0ms 18 75 2ms 0ms 19 70 2ms 0ms 20 67 2ms 0ms 21 65 2ms 0ms 22 73 2ms 0ms 23 73 2ms 0ms [ User: pharmisight - Total duration: 36ms - Times executed: 946 ]
[ User: symmetricds - Total duration: 19ms - Times executed: 499 ]
[ Application: [unknown] - Total duration: 55ms - Times executed: 1445 ]
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
Date: 2018-12-23 15:46:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-23 12:44:27 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-23 23:56:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 28ms 56ms 53ms 19 1s13ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 23 05 1 56ms 56ms 06 1 55ms 55ms 07 1 56ms 56ms 08 1 54ms 54ms 09 1 56ms 56ms 10 1 56ms 56ms 11 1 56ms 56ms 12 1 55ms 55ms 13 1 56ms 56ms 14 1 56ms 56ms 15 1 28ms 28ms 16 1 56ms 56ms 17 1 56ms 56ms 18 1 56ms 56ms 19 1 28ms 28ms 20 1 55ms 55ms 21 1 56ms 56ms 22 1 56ms 56ms 23 1 56ms 56ms [ User: symmetricds - Total duration: 1s13ms - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s13ms - Times executed: 19 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2018-12-23 13:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 45ms 12ms 342 4s404ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 23 05 18 138ms 7ms 06 18 137ms 7ms 07 18 228ms 12ms 08 18 248ms 13ms 09 18 204ms 11ms 10 18 224ms 12ms 11 18 307ms 17ms 12 18 257ms 14ms 13 18 264ms 14ms 14 18 262ms 14ms 15 18 132ms 7ms 16 18 250ms 13ms 17 18 249ms 13ms 18 18 251ms 13ms 19 18 217ms 12ms 20 18 261ms 14ms 21 18 377ms 20ms 22 18 253ms 14ms 23 18 137ms 7ms [ User: symmetricds - Total duration: 4s404ms - Times executed: 342 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s404ms - Times executed: 342 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2018-12-23 06:00:00 Duration: 45ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:00:00 Duration: 36ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:00:00 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 17ms 8ms 342 2s823ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 23 05 18 83ms 4ms 06 18 80ms 4ms 07 18 114ms 6ms 08 18 130ms 7ms 09 18 128ms 7ms 10 18 148ms 8ms 11 18 186ms 10ms 12 18 172ms 9ms 13 18 172ms 9ms 14 18 171ms 9ms 15 18 91ms 5ms 16 18 179ms 9ms 17 18 170ms 9ms 18 18 172ms 9ms 19 18 94ms 5ms 20 18 172ms 9ms 21 18 221ms 12ms 22 18 172ms 9ms 23 18 161ms 8ms [ User: symmetricds - Total duration: 2s823ms - Times executed: 342 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s823ms - Times executed: 342 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
Date: 2018-12-23 21:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 16:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1ms 8ms 6ms 80 520ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 23 04 4 29ms 7ms 05 4 25ms 6ms 06 4 26ms 6ms 07 4 27ms 6ms 08 4 26ms 6ms 09 4 25ms 6ms 10 4 25ms 6ms 11 4 16ms 4ms 12 4 25ms 6ms 13 4 25ms 6ms 14 4 27ms 6ms 15 4 28ms 7ms 16 4 27ms 6ms 17 4 28ms 7ms 18 4 25ms 6ms 19 4 20ms 5ms 20 4 29ms 7ms 21 4 25ms 6ms 22 4 27ms 6ms 23 4 25ms 6ms [ User: symmetricds - Total duration: 520ms - Times executed: 80 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 520ms - Times executed: 80 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2018-12-23 16:30:54 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:30:50 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:30:49 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 10ms 4ms 408 1s700ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 23 04 20 80ms 4ms 05 23 90ms 3ms 06 24 96ms 4ms 07 20 84ms 4ms 08 25 105ms 4ms 09 21 83ms 3ms 10 16 71ms 4ms 11 21 85ms 4ms 12 23 94ms 4ms 13 18 77ms 4ms 14 16 65ms 4ms 15 21 88ms 4ms 16 25 106ms 4ms 17 19 81ms 4ms 18 21 81ms 3ms 19 19 79ms 4ms 20 15 67ms 4ms 21 17 71ms 4ms 22 24 102ms 4ms 23 20 84ms 4ms [ User: symmetricds - Total duration: 1s700ms - Times executed: 408 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s700ms - Times executed: 408 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 22:39:08 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 21:54:08 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 20:37:07 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 26ms 1ms 20,453 33s931ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 23 04 1,024 1s693ms 1ms 05 1,024 1s703ms 1ms 06 1,024 1s667ms 1ms 07 1,024 1s739ms 1ms 08 1,024 1s674ms 1ms 09 1,024 1s702ms 1ms 10 1,024 1s691ms 1ms 11 1,024 1s718ms 1ms 12 1,024 1s746ms 1ms 13 1,024 1s724ms 1ms 14 1,024 1s751ms 1ms 15 1,007 1s679ms 1ms 16 1,024 1s711ms 1ms 17 1,024 1s651ms 1ms 18 1,024 1s661ms 1ms 19 1,024 1s663ms 1ms 20 1,024 1s729ms 1ms 21 1,022 1s712ms 1ms 22 1,020 1s620ms 1ms 23 1,020 1s687ms 1ms [ User: symmetricds - Total duration: 33s931ms - Times executed: 20453 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s931ms - Times executed: 20453 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2018-12-23 21:54:08 Duration: 26ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 13:21:57 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:13:53 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 32ms 1ms 6,799 10s921ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 23 04 340 610ms 1ms 05 340 571ms 1ms 06 340 555ms 1ms 07 340 593ms 1ms 08 340 643ms 1ms 09 340 538ms 1ms 10 340 585ms 1ms 11 340 631ms 1ms 12 340 511ms 1ms 13 340 510ms 1ms 14 340 540ms 1ms 15 339 486ms 1ms 16 340 496ms 1ms 17 340 499ms 1ms 18 340 520ms 1ms 19 340 499ms 1ms 20 340 563ms 1ms 21 340 510ms 1ms 22 340 505ms 1ms 23 340 545ms 1ms [ User: symmetricds - Total duration: 10s921ms - Times executed: 6799 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s921ms - Times executed: 6799 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) 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_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, 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, b.summary FROM sym_outgoing_batch b WHERE node_id = $1 AND status IN ($2, $3, $4, $5, $6, $7, $8, $9) ORDER BY batch_id ASC;
Date: 2018-12-23 20:07:05 Duration: 32ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:03:55 Duration: 30ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:09:51 Duration: 25ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 4ms 1ms 493 717ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 23 04 27 39ms 1ms 05 27 38ms 1ms 06 29 40ms 1ms 07 28 41ms 1ms 08 29 41ms 1ms 09 27 37ms 1ms 10 20 28ms 1ms 11 22 32ms 1ms 12 26 37ms 1ms 13 23 34ms 1ms 14 18 25ms 1ms 15 29 42ms 1ms 16 27 39ms 1ms 17 19 30ms 1ms 18 28 39ms 1ms 19 23 32ms 1ms 20 20 29ms 1ms 21 20 28ms 1ms 22 26 38ms 1ms 23 25 35ms 1ms [ User: symmetricds - Total duration: 717ms - Times executed: 493 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 717ms - Times executed: 493 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 17:16:02 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 13:34:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:11:01 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 12ms 0ms 592 569ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 23 04 31 28ms 0ms 05 33 42ms 1ms 06 32 30ms 0ms 07 34 32ms 0ms 08 34 32ms 0ms 09 33 30ms 0ms 10 25 23ms 0ms 11 25 23ms 0ms 12 31 29ms 0ms 13 29 27ms 0ms 14 23 22ms 0ms 15 34 32ms 0ms 16 33 30ms 0ms 17 23 22ms 0ms 18 34 31ms 0ms 19 28 26ms 0ms 20 27 25ms 0ms 21 24 22ms 0ms 22 30 27ms 0ms 23 29 27ms 0ms [ User: symmetricds - Total duration: 569ms - Times executed: 592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 569ms - Times executed: 592 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) 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), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) 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), a.attidentity != '' OR 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 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 05:30:50 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:38:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 14:32:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 1ms 0ms 489 451ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 23 04 27 24ms 0ms 05 26 23ms 0ms 06 29 27ms 0ms 07 28 26ms 0ms 08 29 26ms 0ms 09 27 25ms 0ms 10 21 19ms 0ms 11 21 19ms 0ms 12 26 23ms 0ms 13 23 21ms 0ms 14 19 18ms 0ms 15 26 24ms 0ms 16 28 25ms 0ms 17 19 17ms 0ms 18 26 23ms 0ms 19 23 20ms 0ms 20 19 17ms 0ms 21 20 18ms 0ms 22 27 24ms 0ms 23 25 22ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 489 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 489 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) 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), a.attidentity != '' OR 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 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 15:31:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:50:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:18:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 489 432ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR 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 ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 23 04 27 23ms 0ms 05 26 22ms 0ms 06 29 25ms 0ms 07 28 24ms 0ms 08 29 25ms 0ms 09 27 24ms 0ms 10 21 18ms 0ms 11 21 18ms 0ms 12 26 22ms 0ms 13 23 20ms 0ms 14 19 17ms 0ms 15 26 22ms 0ms 16 28 24ms 0ms 17 19 17ms 0ms 18 26 22ms 0ms 19 23 19ms 0ms 20 19 17ms 0ms 21 20 17ms 0ms 22 27 23ms 0ms 23 25 22ms 0ms [ User: symmetricds - Total duration: 432ms - Times executed: 489 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 432ms - Times executed: 489 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) 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), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) 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), a.attidentity != '' OR 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 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-23 17:08:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 20:19:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 09:50:31 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 21,477 11s626ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 23 04 1,074 572ms 0ms 05 1,074 579ms 0ms 06 1,074 583ms 0ms 07 1,074 581ms 0ms 08 1,074 584ms 0ms 09 1,074 575ms 0ms 10 1,074 584ms 0ms 11 1,074 585ms 0ms 12 1,074 595ms 0ms 13 1,074 584ms 0ms 14 1,074 586ms 0ms 15 1,071 577ms 0ms 16 1,074 579ms 0ms 17 1,074 593ms 0ms 18 1,074 582ms 0ms 19 1,074 581ms 0ms 20 1,071 573ms 0ms 21 1,074 576ms 0ms 22 1,074 575ms 0ms 23 1,077 573ms 0ms [ User: symmetricds - Total duration: 11s626ms - Times executed: 21477 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11s626ms - Times executed: 21477 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2018-12-23 23:29:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:45:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 04:26:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 5,386 628ms SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 23 04 271 30ms 0ms 05 282 31ms 0ms 06 278 31ms 0ms 07 263 29ms 0ms 08 268 30ms 0ms 09 269 31ms 0ms 10 269 31ms 0ms 11 268 30ms 0ms 12 274 33ms 0ms 13 265 31ms 0ms 14 272 32ms 0ms 15 253 30ms 0ms 16 267 30ms 0ms 17 267 32ms 0ms 18 278 31ms 0ms 19 263 32ms 0ms 20 271 32ms 0ms 21 274 31ms 0ms 22 263 30ms 0ms 23 271 31ms 0ms [ User: symmetricds - Total duration: 628ms - Times executed: 5386 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 628ms - Times executed: 5386 ]
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, 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, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2018-12-23 19:20:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:36:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:08:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 10ms 0ms 5,386 280ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 23 04 271 13ms 0ms 05 282 13ms 0ms 06 278 13ms 0ms 07 263 13ms 0ms 08 268 13ms 0ms 09 269 12ms 0ms 10 269 14ms 0ms 11 268 13ms 0ms 12 274 25ms 0ms 13 265 13ms 0ms 14 272 14ms 0ms 15 253 12ms 0ms 16 267 13ms 0ms 17 267 13ms 0ms 18 278 13ms 0ms 19 263 13ms 0ms 20 271 13ms 0ms 21 274 13ms 0ms 22 263 12ms 0ms 23 271 14ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 5386 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 5386 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2018-12-23 12:22:56 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 23:54:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 12:16:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 21,548 1s38ms 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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 23 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 50ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 52ms 0ms 12 1,078 53ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,075 51ms 0ms 16 1,078 52ms 0ms 17 1,078 53ms 0ms 18 1,078 51ms 0ms 19 1,078 52ms 0ms 20 1,076 51ms 0ms 21 1,076 51ms 0ms 22 1,074 51ms 0ms 23 1,077 51ms 0ms [ User: symmetricds - Total duration: 1s38ms - Times executed: 21548 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s38ms - Times executed: 21548 ]
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
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, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2018-12-23 11:17:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 07:49:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 22:26:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 3ms 0ms 20,383 966ms 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;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 23 04 1,020 48ms 0ms 05 1,020 49ms 0ms 06 1,020 47ms 0ms 07 1,020 46ms 0ms 08 1,020 50ms 0ms 09 1,020 46ms 0ms 10 1,020 49ms 0ms 11 1,020 51ms 0ms 12 1,020 49ms 0ms 13 1,020 45ms 0ms 14 1,020 48ms 0ms 15 1,013 47ms 0ms 16 1,020 48ms 0ms 17 1,020 46ms 0ms 18 1,020 47ms 0ms 19 1,020 53ms 0ms 20 1,018 48ms 0ms 21 1,018 46ms 0ms 22 1,016 47ms 0ms 23 1,018 48ms 0ms [ User: symmetricds - Total duration: 966ms - Times executed: 20383 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 966ms - Times executed: 20383 ]
-
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;
-
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;
-
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;
Date: 2018-12-23 19:06:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:02:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:09:54 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 7,159 327ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 23 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 15ms 0ms 15 357 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 16ms 0ms 20 357 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 359 16ms 0ms [ User: symmetricds - Total duration: 327ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 327ms - Times executed: 7159 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2018-12-23 20:10:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 05:10:31 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 11:38:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 1,445 55ms SET extra_float_digits = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 23 04 75 2ms 0ms 05 75 2ms 0ms 06 77 2ms 0ms 07 76 2ms 0ms 08 77 2ms 0ms 09 75 2ms 0ms 10 69 2ms 0ms 11 71 2ms 0ms 12 74 3ms 0ms 13 70 2ms 0ms 14 65 2ms 0ms 15 76 2ms 0ms 16 75 2ms 0ms 17 67 2ms 0ms 18 75 2ms 0ms 19 70 2ms 0ms 20 67 2ms 0ms 21 65 2ms 0ms 22 73 2ms 0ms 23 73 2ms 0ms [ User: pharmisight - Total duration: 36ms - Times executed: 946 ]
[ User: symmetricds - Total duration: 19ms - Times executed: 499 ]
[ Application: [unknown] - Total duration: 55ms - Times executed: 1445 ]
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
Date: 2018-12-23 15:46:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-23 12:44:27 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-23 23:56:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: [unknown] Bind query: yes
19 0ms 0ms 0ms 7,159 246ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 23 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 357 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 11ms 0ms 19 358 12ms 0ms 20 357 12ms 0ms 21 358 12ms 0ms 22 358 11ms 0ms 23 359 12ms 0ms [ User: symmetricds - Total duration: 246ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 246ms - Times executed: 7159 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2018-12-23 05:25:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 17:24:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 10:15:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 1ms 0ms 7,159 239ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 23 04 358 11ms 0ms 05 358 11ms 0ms 06 358 11ms 0ms 07 358 11ms 0ms 08 358 12ms 0ms 09 358 11ms 0ms 10 358 11ms 0ms 11 358 13ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 357 11ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 11ms 0ms 19 358 11ms 0ms 20 357 11ms 0ms 21 358 11ms 0ms 22 358 12ms 0ms 23 359 11ms 0ms [ User: symmetricds - Total duration: 239ms - Times executed: 7159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 239ms - Times executed: 7159 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
Date: 2018-12-23 11:00:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 08:16:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-23 06:13:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 2,686,538 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET