pgBadger-
Global information
- Generated on Sun Aug 4 00:01:32 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 69,253,242 log entries in 1m27s
- Log start from 2019-08-03 00:00:00 to 2019-08-03 23:59:59
-
Overview
Global Stats
- 181 Number of unique normalized queries
- 23,545,121 Number of queries
- 32m36s Total query duration
- 2019-08-03 00:00:00 First query
- 2019-08-03 23:59:59 Last query
- 5,685 queries/s at 2019-08-03 12:50:54 Query peak
- 2 Number of events
- 2 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 1,198 Total number of automatic vacuums
- 1,349 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,223 Total number of sessions
- 3 sessions at 2019-08-03 00:30:18 Session peak
- 10d6h20m48s Total duration of sessions
- 6m38s Average duration of sessions
- 10,591 Average queries per session
- 879ms Average queries duration per session
- 2,223 Total number of connections
- 42 connections/s at 2019-08-03 00:30:19 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5,685 queries/s Query Peak
- 2019-08-03 12:50:54 Date
SELECT Traffic
Key values
- 1,724 queries/s Query Peak
- 2019-08-03 07:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2,065 queries/s Query Peak
- 2019-08-03 12:50:54 Date
Queries duration
Key values
- 32m36s Total query duration
Prepared queries ratio
Key values
- 1.69 Ratio of bind vs prepare
- 170.29 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 00 1,086,015 0ms 84ms 0ms 1s829ms 1s952ms 2s421ms 01 1,068,229 0ms 81ms 0ms 1s776ms 1s814ms 1s846ms 02 1,070,120 0ms 81ms 0ms 1s707ms 1s743ms 1s773ms 03 1,077,047 0ms 84ms 0ms 1s746ms 1s797ms 2s164ms 04 1,070,335 0ms 82ms 0ms 1s783ms 1s828ms 1s833ms 05 1,073,874 0ms 82ms 0ms 1s816ms 1s929ms 2s296ms 06 1,071,557 0ms 51ms 0ms 1s729ms 1s737ms 1s756ms 07 1,059,236 0ms 136ms 0ms 1s681ms 1s719ms 2s71ms 08 1,070,581 0ms 82ms 0ms 1s735ms 1s781ms 1s869ms 09 1,066,113 0ms 83ms 0ms 1s746ms 1s836ms 1s911ms 10 1,068,918 0ms 93ms 0ms 1s835ms 1s933ms 3s339ms 11 1,071,374 0ms 93ms 0ms 1s825ms 1s904ms 1s965ms 12 1,068,055 0ms 85ms 0ms 1s798ms 1s854ms 1s891ms 13 1,064,428 0ms 100ms 0ms 1s803ms 2s268ms 2s601ms 14 1,082,027 0ms 85ms 0ms 1s785ms 1s838ms 2s134ms 15 1,068,911 0ms 81ms 0ms 1s765ms 1s850ms 1s915ms 16 1,062,419 0ms 88ms 0ms 1s760ms 1s868ms 2s518ms 17 1,073,043 0ms 80ms 0ms 1s760ms 1s790ms 2s174ms 18 1,080,299 0ms 96ms 0ms 1s805ms 1s953ms 3s211ms 19 1,072,003 0ms 99ms 0ms 1s722ms 1s925ms 2s245ms 20 149,416 0ms 80ms 0ms 801ms 1s503ms 2s333ms 21 43,537 0ms 84ms 0ms 116ms 135ms 720ms 22 843,134 0ms 83ms 0ms 1s791ms 1s842ms 2s32ms 23 1,084,450 0ms 84ms 0ms 1s776ms 1s913ms 2s18ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 00 304,764 0 0ms 411ms 438ms 526ms 01 298,083 0 0ms 400ms 431ms 477ms 02 298,517 0 0ms 416ms 429ms 462ms 03 300,530 0 0ms 416ms 438ms 466ms 04 298,553 0 0ms 419ms 434ms 450ms 05 299,564 0 0ms 404ms 431ms 457ms 06 298,858 0 0ms 415ms 434ms 444ms 07 295,383 0 0ms 400ms 426ms 457ms 08 298,567 0 0ms 401ms 430ms 464ms 09 297,304 0 0ms 400ms 424ms 456ms 10 298,124 0 0ms 411ms 443ms 485ms 11 298,820 0 0ms 406ms 440ms 476ms 12 297,833 0 0ms 402ms 421ms 439ms 13 296,792 0 0ms 419ms 450ms 534ms 14 301,789 0 0ms 406ms 426ms 483ms 15 298,082 0 0ms 396ms 418ms 444ms 16 296,206 0 0ms 400ms 412ms 448ms 17 299,226 0 0ms 393ms 442ms 482ms 18 301,293 0 0ms 400ms 421ms 457ms 19 298,955 0 0ms 392ms 425ms 448ms 20 44,595 0 0ms 93ms 204ms 334ms 21 14,932 0 0ms 78ms 93ms 126ms 22 235,790 0 0ms 403ms 420ms 445ms 23 302,487 0 0ms 400ms 433ms 470ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 00 570 80,556 111 0 0ms 370ms 382ms 394ms 01 475 79,673 111 0 0ms 360ms 370ms 391ms 02 188 79,673 113 0 0ms 366ms 375ms 396ms 03 349 79,675 109 0 0ms 364ms 380ms 396ms 04 238 79,673 111 0 0ms 362ms 374ms 393ms 05 244 79,676 115 0 0ms 360ms 375ms 395ms 06 208 79,674 108 0 0ms 365ms 378ms 385ms 07 201 79,678 115 0 0ms 363ms 372ms 393ms 08 88 79,671 109 0 0ms 360ms 375ms 404ms 09 111 79,611 111 0 0ms 362ms 371ms 398ms 10 218 79,662 114 0 0ms 361ms 373ms 404ms 11 131 79,633 109 0 0ms 356ms 379ms 409ms 12 88 79,582 112 0 0ms 351ms 375ms 393ms 13 88 79,637 112 0 0ms 356ms 373ms 497ms 14 88 79,811 112 0 0ms 359ms 374ms 423ms 15 88 79,507 113 0 0ms 350ms 371ms 392ms 16 88 79,610 111 0 0ms 357ms 380ms 418ms 17 88 79,629 112 0 0ms 356ms 371ms 390ms 18 88 79,739 111 0 0ms 359ms 367ms 401ms 19 89 79,567 111 0 0ms 357ms 372ms 389ms 20 99 8,444 135 0 0ms 1ms 8ms 346ms 21 84 52 109 0 2ms 1ms 4ms 8ms 22 84 61,693 110 0 0ms 338ms 375ms 400ms 23 88 79,685 110 0 0ms 363ms 375ms 395ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 03 00 644,434 1,085,979 1.69 101.00% 01 631,995 1,068,193 1.69 100.54% 02 634,025 1,070,084 1.69 100.84% 03 639,691 1,077,011 1.68 101.36% 04 633,874 1,070,299 1.69 100.77% 05 636,743 1,073,838 1.69 101.06% 06 635,088 1,071,521 1.69 100.91% 07 624,418 1,059,200 1.70 99.77% 08 634,333 1,070,545 1.69 100.87% 09 630,806 1,066,077 1.69 100.54% 10 632,562 1,068,882 1.69 100.65% 11 635,107 1,071,338 1.69 101.00% 12 632,417 1,068,019 1.69 100.77% 13 629,055 1,064,392 1.69 100.37% 14 643,314 1,081,991 1.68 101.69% 15 633,020 1,068,875 1.69 100.84% 16 627,079 1,062,383 1.69 100.13% 17 635,956 1,073,007 1.69 101.05% 18 642,136 1,080,263 1.68 101.66% 19 635,524 1,071,967 1.69 101.10% 20 90,527 149,380 1.65 101.64% 21 29,176 43,501 1.49 113.16% 22 501,149 843,098 1.68 101.49% 23 645,906 1,084,414 1.68 102.10% Day Hour Count Average / Second Aug 03 00 137 0.04/s 01 91 0.03/s 02 93 0.03/s 03 93 0.03/s 04 92 0.03/s 05 93 0.03/s 06 95 0.03/s 07 93 0.03/s 08 93 0.03/s 09 93 0.03/s 10 89 0.02/s 11 90 0.03/s 12 86 0.02/s 13 87 0.02/s 14 88 0.02/s 15 85 0.02/s 16 85 0.02/s 17 84 0.02/s 18 84 0.02/s 19 84 0.02/s 20 106 0.03/s 21 108 0.03/s 22 89 0.02/s 23 85 0.02/s Day Hour Count Average Duration Aug 03 00 137 6m33s 01 91 6m33s 02 93 6m29s 03 93 6m27s 04 92 6m29s 05 93 6m27s 06 95 6m14s 07 93 6m27s 08 93 6m40s 09 93 6m27s 10 89 6m45s 11 90 6m52s 12 86 6m46s 13 87 6m58s 14 88 6m49s 15 85 7m18s 16 85 7m2s 17 84 7m16s 18 84 7m11s 19 84 7m7s 20 106 5m43s 21 108 5m34s 22 89 6m47s 23 85 7m11s -
Connections
Established Connections
Key values
- 42 connections Connection Peak
- 2019-08-03 00:30:19 Date
Connections per database
Key values
- pharmisight Main Database
- 2,223 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,223 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-08-03 00:30:18 Date
Histogram of session times
Key values
- 1,582 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,223 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,223 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,223 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,487 buffers Checkpoint Peak
- 2019-08-03 07:06:48 Date
- 149.917 seconds Highest write time
- 0.164 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-08-03 19:34:59 Date
Checkpoints distance
Key values
- 32.46 Mo Distance Peak
- 2019-08-03 07:06:48 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 03 00 4,817 481.795s 0.193s 482.075s 01 4,137 414.234s 0.119s 414.434s 02 4,035 404.303s 0.086s 404.464s 03 4,128 413.534s 0.174s 413.789s 04 3,991 399.542s 0.084s 399.702s 05 4,036 404.263s 0.221s 404.566s 06 4,295 430.059s 0.184s 430.319s 07 5,851 486.569s 0.065s 486.709s 08 4,110 411.317s 0.011s 411.412s 09 4,107 411.334s 0.014s 411.421s 10 4,180 418.405s 0.012s 418.493s 11 4,149 415.665s 0.008s 415.751s 12 5,047 482.276s 0.012s 482.362s 13 4,057 406.561s 0.01s 406.647s 14 3,876 388.191s 0.073s 388.339s 15 4,069 407.939s 0.18s 408.197s 16 4,005 401.543s 0.436s 402.058s 17 3,913 392.163s 0.572s 392.826s 18 3,779 378.455s 0.504s 379.054s 19 3,437 344.407s 0.442s 344.939s 20 1,106 110.795s 0.173s 111.021s 21 291 29.203s 0.013s 29.266s 22 2,864 286.685s 0.098s 286.897s 23 3,603 360.548s 0.163s 360.834s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 03 00 0 0 4 405 0.102s 0.002s 01 0 0 4 371 0.102s 0.004s 02 0 0 4 383 0.076s 0.002s 03 0 0 4 375 0.065s 0.003s 04 0 0 4 374 0.045s 0.001s 05 0 0 4 367 0.095s 0.005s 06 0 0 4 364 0.096s 0.003s 07 0 0 4 380 0.059s 0.001s 08 0 0 4 357 0.002s 0s 09 0 0 4 360 0.002s 0s 10 0 0 4 370 0.001s 0s 11 0 0 4 361 0.001s 0s 12 0 0 4 366 0.002s 0s 13 0 0 4 346 0.002s 0s 14 0 0 4 349 0.066s 0.002s 15 0 0 3 352 0.094s 0.004s 16 0 0 4 352 0.094s 0.011s 17 0 0 4 354 0.101s 0.016s 18 0 0 4 354 0.094s 0.015s 19 0 0 3 324 0.090s 0.011s 20 0 0 1 206 0.164s 0.004s 21 0 0 0 142 0.002s 0s 22 0 0 2 247 0.038s 0.002s 23 0 0 4 280 0.067s 0.006s Day Hour Count Avg time (sec) Aug 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 03 00 5,876.00 kB 6,117.67 kB 01 5,365.42 kB 5,758.08 kB 02 5,341.83 kB 5,520.83 kB 03 5,452.17 kB 5,662.83 kB 04 5,293.42 kB 5,628.33 kB 05 5,281.25 kB 5,475.67 kB 06 5,348.08 kB 5,664.58 kB 07 6,069.50 kB 12,000.33 kB 08 5,111.36 kB 7,048.64 kB 09 5,284.17 kB 6,406.83 kB 10 5,306.92 kB 6,434.00 kB 11 5,086.09 kB 6,390.09 kB 12 5,631.42 kB 8,997.75 kB 13 5,218.00 kB 6,292.58 kB 14 5,135.75 kB 5,653.92 kB 15 5,205.17 kB 6,102.42 kB 16 5,058.00 kB 5,646.45 kB 17 5,079.08 kB 5,645.83 kB 18 5,035.67 kB 5,205.42 kB 19 4,983.33 kB 5,235.89 kB 20 1,045.12 kB 3,961.50 kB 21 142.50 kB 1,799.62 kB 22 3,162.43 kB 3,427.00 kB 23 5,022.00 kB 5,111.14 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 Aug 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 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 (1312) Main table analyzed (database pharmisight)
- 1,349 analyzes Total
Vacuums per table
Key values
- public.sym_outgoing_batch (1160) Main table vacuumed on database pharmisight
- 1,198 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 1160 1160 pharmisight.pg_toast.pg_toast_2619 15 15 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data_gap 5 5 pharmisight.public.sym_data_event 2 2 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.public.item_codes 1 1 Total 1,198 1,191 Tuples removed per table
Key values
- public.sym_outgoing_batch (1104263) Main table with removed tuples on database pharmisight
- 1116516 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_outgoing_batch 1160 1160 1104263 0 pharmisight.public.sym_data_event 2 2 8200 0 pharmisight.public.sym_incoming_batch 6 6 1448 0 pharmisight.pg_toast.pg_toast_2619 15 15 1076 0 pharmisight.pg_catalog.pg_statistic 2 2 656 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.item_codes 1 1 254 0 pharmisight.public.sym_sequence 1 0 51 0 Total 1,198 1,191 1,116,516 0 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.pg_toast.pg_toast_2619 15 15 1076 0 pharmisight.public.sym_data_event 2 2 8200 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_incoming_batch 6 6 1448 0 pharmisight.public.item_codes 1 1 254 0 pharmisight.pg_catalog.pg_statistic 2 2 656 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_outgoing_batch 1160 1160 1104263 0 Total 1,198 1,191 1,116,516 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 03 00 44 64 01 39 62 02 40 61 03 37 62 04 40 61 05 41 60 06 41 62 07 60 63 08 62 62 09 61 60 10 61 63 11 61 60 12 63 63 13 61 61 14 61 61 15 62 62 16 61 62 17 62 62 18 62 60 19 63 62 20 7 7 21 0 1 22 48 48 23 61 60 - 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
- 6,575,047 Total read queries
- 7,251,316 Total write queries
Queries by database
Key values
- pharmisight Main database
- 23,545,121 Requests
- 32m36s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 23,576,897 Requests
User Request type Count Duration pharmisight Total 52,765 4s310ms DELETE 27 3ms INSERT 83 46ms OTHERS 1,836 67ms SELECT 50,227 4s166ms TCL 556 21ms UPDATE 36 5ms symmetricds Total 23,576,897 32m38s DELETE 2,668 10s819ms INSERT 4,076 1s66ms OTHERS 9,752,820 2m21s SELECT 6,547,610 7m33s TCL 5,519,703 15m25s UPDATE 1,750,020 7m7s tony Total 867 233ms SELECT 867 233ms Duration by user
Key values
- 32m38s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 52,765 4s310ms DELETE 27 3ms INSERT 83 46ms OTHERS 1,836 67ms SELECT 50,227 4s166ms TCL 556 21ms UPDATE 36 5ms symmetricds Total 23,576,897 32m38s DELETE 2,668 10s819ms INSERT 4,076 1s66ms OTHERS 9,752,820 2m21s SELECT 6,547,610 7m33s TCL 5,519,703 15m25s UPDATE 1,750,020 7m7s tony Total 867 233ms SELECT 867 233ms Queries by host
Key values
- 10.10.10.1 Main host
- 23,629,662 Requests
- 32m43s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 23,542,322 Requests
- 32m35s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-03 05:49:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 23,437,452 0-1ms duration
Slowest individual queries
Rank Duration Query 1 136ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '9195930' AND '9196569' AND status != 'OK') AND batch_id BETWEEN '9195930' AND '9196569';[ Date: 2019-08-03 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 100ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 99ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 19:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 96ms DELETE FROM sym_outgoing_batch WHERE status = 'OK' AND batch_id BETWEEN '9195930' AND '9196569' AND batch_id NOT IN ( SELECT batch_id FROM sym_data_event WHERE batch_id BETWEEN '9195930' AND '9196569');[ Date: 2019-08-03 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 96ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 18:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 93ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 93ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 93ms COMMIT;[ Date: 2019-08-03 10:37:57 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 90ms COMMIT;[ Date: 2019-08-03 10:37:57 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 88ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 23:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 21:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 83ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 22:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 83ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 07:00:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 83ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 82ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-03 04: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 15m3s 2,750,364 0ms 93ms 0ms COMMIT;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 01 126,034 43s150ms 0ms 02 125,134 39s838ms 0ms 03 125,129 40s485ms 0ms 04 125,231 42s102ms 0ms 05 125,232 40s565ms 0ms 06 125,248 41s418ms 0ms 07 125,255 40s516ms 0ms 08 125,254 39s158ms 0ms 09 125,225 40s485ms 0ms 10 125,135 41s236ms 0ms 11 125,178 43s441ms 0ms 12 125,056 40s842ms 0ms 13 124,980 41s356ms 0ms 14 125,056 40s547ms 0ms 15 125,413 42s333ms 0ms 16 124,989 40s852ms 0ms 17 125,136 38s767ms 0ms 18 125,159 40s363ms 0ms 19 125,204 46s471ms 0ms 20 124,950 41s686ms 0ms 21 17,895 3s753ms 0ms 22 5,303 161ms 0ms 23 98,046 31s819ms 0ms 00 125,122 42s399ms 0ms [ User: symmetricds - Total duration: 15m3s - Times executed: 2750087 ]
[ User: pharmisight - Total duration: 19ms - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m3s - Times executed: 2750364 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-03 10:37:57 Duration: 93ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:58:56 Duration: 47ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7m1s 1,737,793 0ms 14ms 0ms UPDATE sym_outgoing_batch SET status = ?, load_id = ?, extract_job_flag = ?, load_flag = ?, error_flag = ?, byte_count = ?, extract_count = ?, sent_count = ?, load_count = ?, data_row_count = ?, reload_row_count = ?, data_insert_row_count = ?, data_update_row_count = ?, data_delete_row_count = ?, other_row_count = ?, ignore_count = ?, router_millis = ?, network_millis = ?, filter_millis = ?, load_millis = ?, extract_millis = ?, extract_start_time = ?, transfer_start_time = ?, load_start_time = NULL, sql_state = NULL, sql_code = ?, sql_message = NULL, failed_data_id = ?, last_update_hostname = ?, last_update_time = current_timestamp, summary = ?, load_row_count = ?, load_insert_row_count = ?, load_update_row_count = ?, load_delete_row_count = ?, fallback_insert_count = ?, fallback_update_count = ?, ignore_row_count = ?, missing_delete_count = ?, skip_count = ?, extract_row_count = ?, extract_insert_row_count = ?, extract_update_row_count = ?, extract_delete_row_count = ?, transform_extract_millis = ?, transform_load_millis = ? WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 01 79,444 19s599ms 0ms 02 79,443 19s378ms 0ms 03 79,444 19s529ms 0ms 04 79,444 19s573ms 0ms 05 79,443 19s248ms 0ms 06 79,445 19s119ms 0ms 07 79,444 19s371ms 0ms 08 79,445 19s371ms 0ms 09 79,443 19s240ms 0ms 10 79,383 19s431ms 0ms 11 79,432 19s200ms 0ms 12 79,402 19s9ms 0ms 13 79,354 19s127ms 0ms 14 79,410 19s552ms 0ms 15 79,584 19s211ms 0ms 16 79,279 19s162ms 0ms 17 79,381 19s205ms 0ms 18 79,401 19s269ms 0ms 19 79,511 19s303ms 0ms 20 79,332 19s21ms 0ms 21 8,358 1s770ms 0ms 22 4 1ms 0ms 23 61,509 15s92ms 0ms 00 79,458 19s198ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1737793 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1737793 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '6144', extract_count = '2400', sent_count = '2400', load_count = '2400', data_row_count = '12', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '7', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '27', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:17:45.857', transfer_start_time = '2019-08-03 10:46:57.628', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, orders, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '12', extract_insert_row_count = '5', extract_update_row_count = '7', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195255' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3924', extract_count = '2991', sent_count = '2990', load_count = '2990', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '5', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:26:45.752', transfer_start_time = '2019-08-03 23:53:03.666', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_round_activities, order_rounds, flow_reports', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '6', extract_insert_row_count = '1', extract_update_row_count = '5', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195657' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3620', extract_count = '2788', sent_count = '2787', load_count = '2787', data_row_count = '5', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 15:17:45.839', transfer_start_time = '2019-08-03 17:13:59.026', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '5', extract_insert_row_count = '2', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195251' AND node_id = '2';
Date: 2019-08-03 10:46:57 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:54:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 17:14:58 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3m27s 866,327 0ms 12ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = ? AND o.node_id = ? ORDER BY d.data_id ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 01 39,604 9s517ms 0ms 02 39,604 9s539ms 0ms 03 39,604 9s507ms 0ms 04 39,604 9s608ms 0ms 05 39,604 9s460ms 0ms 06 39,605 9s449ms 0ms 07 39,604 9s698ms 0ms 08 39,605 9s485ms 0ms 09 39,604 9s570ms 0ms 10 39,576 9s649ms 0ms 11 39,597 9s558ms 0ms 12 39,585 9s495ms 0ms 13 39,559 9s600ms 0ms 14 39,588 9s369ms 0ms 15 39,674 9s628ms 0ms 16 39,521 9s395ms 0ms 17 39,573 9s318ms 0ms 18 39,583 9s494ms 0ms 19 39,638 9s389ms 0ms 20 39,548 9s213ms 0ms 21 4,166 877ms 0ms 22 4 0ms 0ms 23 30,667 7s429ms 0ms 00 39,610 9s472ms 0ms [ User: symmetricds - Total duration: 3m27s - Times executed: 866327 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m27s - Times executed: 866327 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195613' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9194871' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195349' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-03 13:04:59 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:00:53 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1m48s 7,035,941 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 01 323,356 5s100ms 0ms 02 318,175 4s895ms 0ms 03 319,220 4s899ms 0ms 04 322,069 5s24ms 0ms 05 319,298 4s958ms 0ms 06 320,807 4s954ms 0ms 07 319,865 4s954ms 0ms 08 314,555 4s831ms 0ms 09 319,542 4s947ms 0ms 10 317,710 4s871ms 0ms 11 318,739 4s924ms 0ms 12 319,909 4s965ms 0ms 13 318,634 4s912ms 0ms 14 316,982 4s894ms 0ms 15 324,230 5s31ms 0ms 16 319,134 4s905ms 0ms 17 316,180 4s833ms 0ms 18 320,710 4s946ms 0ms 19 323,623 5s3ms 0ms 20 320,366 4s894ms 0ms 21 47,427 693ms 0ms 22 16,802 283ms 0ms 23 253,113 3s956ms 0ms 00 325,495 5s32ms 0ms [ User: symmetricds - Total duration: 1m48s - Times executed: 7035330 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 611 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 7035941 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-03 00:00:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:54:54 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:34:55 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m12s 47,620 0ms 43ms 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 #5
Day Hour Count Duration Avg duration Aug 03 01 2,164 3s386ms 1ms 02 2,164 3s285ms 1ms 03 2,164 3s372ms 1ms 04 2,164 3s357ms 1ms 05 2,164 3s382ms 1ms 06 2,165 3s402ms 1ms 07 2,164 3s449ms 1ms 08 2,165 3s365ms 1ms 09 2,164 3s281ms 1ms 10 2,164 3s353ms 1ms 11 2,164 3s190ms 1ms 12 2,164 3s237ms 1ms 13 2,164 3s161ms 1ms 14 2,164 4s293ms 1ms 15 2,164 3s97ms 1ms 16 2,164 3s136ms 1ms 17 2,164 3s30ms 1ms 18 2,164 3s138ms 1ms 19 2,164 3s99ms 1ms 20 2,164 3s22ms 1ms 21 328 366ms 1ms 22 124 127ms 1ms 23 1,722 2s464ms 1ms 00 2,164 3s180ms 1ms [ User: symmetricds - Total duration: 1m12s - Times executed: 47620 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m12s - Times executed: 47620 ]
-
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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-08-03 07:06:52 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:27:52 Duration: 39ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 02:05:50 Duration: 37ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 41s533ms 4,101,704 0ms 15ms 0ms SELECT ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 03 01 189,120 1s937ms 0ms 02 186,255 1s881ms 0ms 03 186,601 1s866ms 0ms 04 187,548 1s921ms 0ms 05 186,624 1s877ms 0ms 06 187,132 1s862ms 0ms 07 186,815 1s888ms 0ms 08 185,048 1s858ms 0ms 09 186,698 1s885ms 0ms 10 186,029 1s898ms 0ms 11 186,429 1s887ms 0ms 12 186,780 1s873ms 0ms 13 186,309 1s889ms 0ms 14 185,815 1s919ms 0ms 15 188,399 1s905ms 0ms 16 186,404 1s882ms 0ms 17 185,517 1s878ms 0ms 18 187,048 1s890ms 0ms 19 188,128 1s913ms 0ms 20 186,862 1s876ms 0ms 21 24,726 242ms 0ms 22 6,148 73ms 0ms 23 146,575 1s491ms 0ms 00 188,694 1s927ms 0ms [ User: symmetricds - Total duration: 41s533ms - Times executed: 4101704 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 41s533ms - Times executed: 4101704 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-03 13:05:53 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:27:55 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:22:52 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 40s252ms 891,382 0ms 4ms 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 #7
Day Hour Count Duration Avg duration Aug 03 01 40,680 1s864ms 0ms 02 40,682 1s826ms 0ms 03 40,680 1s839ms 0ms 04 40,678 1s842ms 0ms 05 40,678 1s824ms 0ms 06 40,681 1s835ms 0ms 07 40,682 1s854ms 0ms 08 40,681 1s808ms 0ms 09 40,680 1s831ms 0ms 10 40,648 1s825ms 0ms 11 40,671 1s825ms 0ms 12 40,659 1s834ms 0ms 13 40,637 1s831ms 0ms 14 40,663 1s823ms 0ms 15 40,751 1s860ms 0ms 16 40,599 1s817ms 0ms 17 40,649 1s827ms 0ms 18 40,661 1s854ms 0ms 19 40,711 1s851ms 0ms 20 40,625 1s812ms 0ms 21 4,926 212ms 0ms 22 720 38ms 0ms 23 31,655 1s461ms 0ms 00 40,685 1s848ms 0ms [ User: symmetricds - Total duration: 40s252ms - Times executed: 891382 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s252ms - Times executed: 891382 ]
-
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 = '2';
-
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 = '2';
-
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 = '2';
Date: 2019-08-03 14:55:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 00:16:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:08:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 29s855ms 462,910 0ms 5ms 0ms 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 batch_id = ? AND node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 03 01 22,133 1s502ms 0ms 02 20,606 1s328ms 0ms 03 20,958 1s322ms 0ms 04 21,811 1s444ms 0ms 05 20,884 1s426ms 0ms 06 21,369 1s398ms 0ms 07 21,047 1s381ms 0ms 08 19,279 1s223ms 0ms 09 20,961 1s384ms 0ms 10 20,408 1s301ms 0ms 11 20,747 1s382ms 0ms 12 21,236 1s417ms 0ms 13 20,857 1s343ms 0ms 14 20,258 1s314ms 0ms 15 22,404 1s429ms 0ms 16 20,977 1s330ms 0ms 17 19,897 1s255ms 0ms 18 21,394 1s341ms 0ms 19 22,378 1s404ms 0ms 20 21,454 1s334ms 0ms 21 1,825 97ms 0ms 22 4 0ms 0ms 23 16,964 1s69ms 0ms 00 23,059 1s421ms 0ms [ User: symmetricds - Total duration: 29s855ms - Times executed: 462910 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s855ms - Times executed: 462910 ]
-
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 batch_id = '9195579' AND node_id = '2';
-
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 batch_id = '9196575' AND node_id = '2';
-
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 batch_id = '9196043' AND node_id = '2';
Date: 2019-08-03 01:48:57 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 03:02:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 08:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 25s106ms 17,280 0ms 51ms 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 #9
Day Hour Count Duration Avg duration Aug 03 01 720 1s70ms 1ms 02 720 1s35ms 1ms 03 720 1s132ms 1ms 04 720 1s45ms 1ms 05 720 1s59ms 1ms 06 720 1s69ms 1ms 07 720 1s103ms 1ms 08 720 1s200ms 1ms 09 720 1s77ms 1ms 10 720 1s122ms 1ms 11 720 1s84ms 1ms 12 720 1s83ms 1ms 13 720 1s97ms 1ms 14 720 1s44ms 1ms 15 720 998ms 1ms 16 720 1s13ms 1ms 17 720 939ms 1ms 18 720 953ms 1ms 19 720 942ms 1ms 20 720 969ms 1ms 21 720 1s71ms 1ms 22 720 1s90ms 1ms 23 720 1s7ms 1ms 00 720 894ms 1ms [ User: symmetricds - Total duration: 25s106ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s106ms - Times executed: 17280 ]
-
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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-03 06:19:49 Duration: 51ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 01:43:48 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:37:49 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17s982ms 2,750,365 0ms 15ms 0ms BEGIN;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 03 01 126,035 821ms 0ms 02 125,134 809ms 0ms 03 125,129 818ms 0ms 04 125,231 831ms 0ms 05 125,232 825ms 0ms 06 125,248 825ms 0ms 07 125,255 826ms 0ms 08 125,254 799ms 0ms 09 125,225 812ms 0ms 10 125,136 815ms 0ms 11 125,177 812ms 0ms 12 125,057 818ms 0ms 13 124,979 832ms 0ms 14 125,056 816ms 0ms 15 125,413 826ms 0ms 16 124,990 826ms 0ms 17 125,136 810ms 0ms 18 125,158 827ms 0ms 19 125,204 820ms 0ms 20 124,951 805ms 0ms 21 17,894 106ms 0ms 22 5,303 35ms 0ms 23 98,046 643ms 0ms 00 125,122 813ms 0ms [ User: symmetricds - Total duration: 17s980ms - Times executed: 2750087 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 278 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s982ms - Times executed: 2750365 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-03 12:28:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:48:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 09:54:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 16s249ms 1,339,474 0ms 2ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 03 01 62,169 750ms 0ms 02 60,643 728ms 0ms 03 60,995 731ms 0ms 04 61,845 764ms 0ms 05 60,919 749ms 0ms 06 61,406 750ms 0ms 07 61,083 754ms 0ms 08 59,318 710ms 0ms 09 60,995 743ms 0ms 10 60,417 731ms 0ms 11 60,777 744ms 0ms 12 61,250 741ms 0ms 13 60,850 747ms 0ms 14 60,278 730ms 0ms 15 62,509 765ms 0ms 16 60,931 734ms 0ms 17 59,904 715ms 0ms 18 61,407 748ms 0ms 19 62,447 759ms 0ms 20 61,435 732ms 0ms 21 6,369 68ms 0ms 22 380 6ms 0ms 23 48,049 581ms 0ms 00 63,098 759ms 0ms [ User: symmetricds - Total duration: 16s249ms - Times executed: 1339474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s249ms - Times executed: 1339474 ]
-
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: 2019-08-03 05:50:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:49:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:54:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 15s712ms 1,339,473 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 03 01 62,169 722ms 0ms 02 60,643 705ms 0ms 03 60,994 708ms 0ms 04 61,846 746ms 0ms 05 60,919 732ms 0ms 06 61,404 727ms 0ms 07 61,085 729ms 0ms 08 59,316 685ms 0ms 09 60,997 717ms 0ms 10 60,416 707ms 0ms 11 60,775 712ms 0ms 12 61,253 720ms 0ms 13 60,849 727ms 0ms 14 60,277 706ms 0ms 15 62,510 737ms 0ms 16 60,931 708ms 0ms 17 59,902 690ms 0ms 18 61,410 718ms 0ms 19 62,446 738ms 0ms 20 61,435 708ms 0ms 21 6,370 64ms 0ms 22 380 5ms 0ms 23 48,049 557ms 0ms 00 63,097 735ms 0ms [ User: symmetricds - Total duration: 15s712ms - Times executed: 1339473 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s712ms - Times executed: 1339473 ]
-
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: 2019-08-03 03:18:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 15:59:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:13:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 9s443ms 17,187 0ms 3ms 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 #13
Day Hour Count Duration Avg duration Aug 03 01 717 386ms 0ms 02 718 395ms 0ms 03 716 387ms 0ms 04 714 394ms 0ms 05 714 393ms 0ms 06 716 394ms 0ms 07 718 402ms 0ms 08 716 386ms 0ms 09 716 386ms 0ms 10 716 393ms 0ms 11 714 382ms 0ms 12 716 390ms 0ms 13 718 393ms 0ms 14 716 391ms 0ms 15 716 398ms 0ms 16 718 380ms 0ms 17 716 385ms 0ms 18 718 383ms 0ms 19 714 384ms 0ms 20 716 384ms 0ms 21 718 429ms 0ms 22 716 435ms 0ms 23 716 389ms 0ms 00 714 390ms 0ms [ User: symmetricds - Total duration: 9s443ms - Times executed: 17187 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s443ms - Times executed: 17187 ]
-
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: 2019-08-03 20:40:03 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:58:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 20:54:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 6s324ms 384 2ms 77ms 16ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 01 16 166ms 10ms 02 16 167ms 10ms 03 16 123ms 7ms 04 16 128ms 8ms 05 16 127ms 7ms 06 16 124ms 7ms 07 16 72ms 4ms 08 16 428ms 26ms 09 16 205ms 12ms 10 16 279ms 17ms 11 16 248ms 15ms 12 16 315ms 19ms 13 16 323ms 20ms 14 16 306ms 19ms 15 16 277ms 17ms 16 16 295ms 18ms 17 16 314ms 19ms 18 16 395ms 24ms 19 16 336ms 21ms 20 16 329ms 20ms 21 16 310ms 19ms 22 16 393ms 24ms 23 16 301ms 18ms 00 16 351ms 21ms [ User: symmetricds - Total duration: 6s324ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s324ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104754155' AND '104759155' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '104744153' AND '104749153' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104744153' AND '104749153') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104744153' AND '104749153' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '104749154' AND '104754154' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104749154' AND '104754154') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104749154' AND '104754154' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-03 07:00:00 Duration: 77ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:00 Duration: 61ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:00 Duration: 58ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 4s403ms 1,154 1ms 16ms 3ms 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 #15
Day Hour Count Duration Avg duration Aug 03 01 55 205ms 3ms 02 53 199ms 3ms 03 53 204ms 3ms 04 57 219ms 3ms 05 54 200ms 3ms 06 53 192ms 3ms 07 58 221ms 3ms 08 54 200ms 3ms 09 52 195ms 3ms 10 55 202ms 3ms 11 51 196ms 3ms 12 52 194ms 3ms 13 49 185ms 3ms 14 48 195ms 4ms 15 50 195ms 3ms 16 48 196ms 4ms 17 44 166ms 3ms 18 42 163ms 3ms 19 46 170ms 3ms 20 43 167ms 3ms 21 23 91ms 3ms 22 24 97ms 4ms 23 43 161ms 3ms 00 47 180ms 3ms [ User: symmetricds - Total duration: 4s403ms - Times executed: 1154 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s403ms - Times executed: 1154 ]
-
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: 2019-08-03 13:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 15:04:54 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 13:53:53 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 3s700ms 384 2ms 38ms 9ms 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 #16
Day Hour Count Duration Avg duration Aug 03 01 16 93ms 5ms 02 16 92ms 5ms 03 16 91ms 5ms 04 16 94ms 5ms 05 16 94ms 5ms 06 16 92ms 5ms 07 16 54ms 3ms 08 16 262ms 16ms 09 16 120ms 7ms 10 16 127ms 7ms 11 16 150ms 9ms 12 16 207ms 12ms 13 16 173ms 10ms 14 16 160ms 10ms 15 16 185ms 11ms 16 16 159ms 9ms 17 16 189ms 11ms 18 16 175ms 10ms 19 16 205ms 12ms 20 16 246ms 15ms 21 16 163ms 10ms 22 16 187ms 11ms 23 16 160ms 10ms 00 16 209ms 13ms [ User: symmetricds - Total duration: 3s700ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s700ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808478' AND data_id < '104808481' AND create_time < '2019-08-02 23:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808478');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104764157' AND '104769157' AND data_id < '104808269' AND create_time < '2019-08-02 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104764157' AND '104769157');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104759156' AND '104764156' AND data_id < '104808269' AND create_time < '2019-08-02 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104759156' AND '104764156');
Date: 2019-08-03 23:00:00 Duration: 38ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:01 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:01 Duration: 33ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 3s65ms 551 4ms 13ms 5ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 03 01 131 662ms 5ms 02 19 120ms 6ms 03 19 99ms 5ms 04 19 104ms 5ms 05 19 98ms 5ms 06 19 143ms 7ms 07 19 99ms 5ms 08 19 99ms 5ms 09 19 99ms 5ms 10 19 97ms 5ms 11 19 98ms 5ms 12 19 96ms 5ms 13 19 98ms 5ms 14 19 133ms 7ms 15 19 98ms 5ms 16 19 97ms 5ms 17 19 97ms 5ms 18 19 97ms 5ms 19 19 99ms 5ms 20 19 100ms 5ms 21 19 100ms 5ms 22 2 18ms 9ms 23 19 128ms 6ms 00 19 174ms 9ms [ User: symmetricds - Total duration: 2s860ms - Times executed: 506 ]
[ User: pharmisight - Total duration: 205ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s65ms - Times executed: 551 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-03 05:00:52 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 01:00:51 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:04:56 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 2s31ms 24 47ms 100ms 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 03 01 1 84ms 84ms 02 1 81ms 81ms 03 1 81ms 81ms 04 1 84ms 84ms 05 1 82ms 82ms 06 1 82ms 82ms 07 1 47ms 47ms 08 1 83ms 83ms 09 1 82ms 82ms 10 1 83ms 83ms 11 1 93ms 93ms 12 1 93ms 93ms 13 1 85ms 85ms 14 1 100ms 100ms 15 1 85ms 85ms 16 1 81ms 81ms 17 1 88ms 88ms 18 1 80ms 80ms 19 1 96ms 96ms 20 1 99ms 99ms 21 1 80ms 80ms 22 1 84ms 84ms 23 1 83ms 83ms 00 1 84ms 84ms [ User: symmetricds - Total duration: 2s31ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s31ms - Times executed: 24 ]
-
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: 2019-08-03 13:00:00 Duration: 100ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:00:00 Duration: 96ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1s735ms 1,257 0ms 3ms 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 #19
Day Hour Count Duration Avg duration Aug 03 01 53 71ms 1ms 02 55 75ms 1ms 03 56 74ms 1ms 04 56 77ms 1ms 05 57 77ms 1ms 06 56 79ms 1ms 07 57 77ms 1ms 08 56 76ms 1ms 09 57 80ms 1ms 10 56 78ms 1ms 11 51 70ms 1ms 12 50 68ms 1ms 13 49 69ms 1ms 14 50 66ms 1ms 15 52 72ms 1ms 16 50 68ms 1ms 17 48 67ms 1ms 18 44 61ms 1ms 19 48 63ms 1ms 20 45 61ms 1ms 21 60 83ms 1ms 22 58 85ms 1ms 23 48 66ms 1ms 00 45 59ms 1ms [ User: symmetricds - Total duration: 1s735ms - Times executed: 1257 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s735ms - Times executed: 1257 ]
-
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: 2019-08-03 08:13:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:25:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 03:14:51 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1s481ms 1,548 0ms 14ms 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 #20
Day Hour Count Duration Avg duration Aug 03 01 68 62ms 0ms 02 68 63ms 0ms 03 69 63ms 0ms 04 69 63ms 0ms 05 69 62ms 0ms 06 68 63ms 0ms 07 71 66ms 0ms 08 68 64ms 0ms 09 70 66ms 0ms 10 69 67ms 0ms 11 64 60ms 0ms 12 64 61ms 0ms 13 62 61ms 0ms 14 60 55ms 0ms 15 61 58ms 0ms 16 59 56ms 0ms 17 60 55ms 0ms 18 57 53ms 0ms 19 58 58ms 1ms 20 58 52ms 0ms 21 64 63ms 0ms 22 71 70ms 0ms 23 61 71ms 1ms 00 60 55ms 0ms [ User: symmetricds - Total duration: 1s481ms - Times executed: 1548 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s481ms - Times executed: 1548 ]
-
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: 2019-08-03 22:47:56 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:47:53 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:47:54 Duration: 3ms 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 7,035,941 1m48s 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 01 323,356 5s100ms 0ms 02 318,175 4s895ms 0ms 03 319,220 4s899ms 0ms 04 322,069 5s24ms 0ms 05 319,298 4s958ms 0ms 06 320,807 4s954ms 0ms 07 319,865 4s954ms 0ms 08 314,555 4s831ms 0ms 09 319,542 4s947ms 0ms 10 317,710 4s871ms 0ms 11 318,739 4s924ms 0ms 12 319,909 4s965ms 0ms 13 318,634 4s912ms 0ms 14 316,982 4s894ms 0ms 15 324,230 5s31ms 0ms 16 319,134 4s905ms 0ms 17 316,180 4s833ms 0ms 18 320,710 4s946ms 0ms 19 323,623 5s3ms 0ms 20 320,366 4s894ms 0ms 21 47,427 693ms 0ms 22 16,802 283ms 0ms 23 253,113 3s956ms 0ms 00 325,495 5s32ms 0ms [ User: symmetricds - Total duration: 1m48s - Times executed: 7035330 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 611 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 7035941 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-03 00:00:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:54:54 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:34:55 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4,101,704 41s533ms 0ms 15ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 01 189,120 1s937ms 0ms 02 186,255 1s881ms 0ms 03 186,601 1s866ms 0ms 04 187,548 1s921ms 0ms 05 186,624 1s877ms 0ms 06 187,132 1s862ms 0ms 07 186,815 1s888ms 0ms 08 185,048 1s858ms 0ms 09 186,698 1s885ms 0ms 10 186,029 1s898ms 0ms 11 186,429 1s887ms 0ms 12 186,780 1s873ms 0ms 13 186,309 1s889ms 0ms 14 185,815 1s919ms 0ms 15 188,399 1s905ms 0ms 16 186,404 1s882ms 0ms 17 185,517 1s878ms 0ms 18 187,048 1s890ms 0ms 19 188,128 1s913ms 0ms 20 186,862 1s876ms 0ms 21 24,726 242ms 0ms 22 6,148 73ms 0ms 23 146,575 1s491ms 0ms 00 188,694 1s927ms 0ms [ User: symmetricds - Total duration: 41s533ms - Times executed: 4101704 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 41s533ms - Times executed: 4101704 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-03 13:05:53 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:27:55 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:22:52 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2,750,365 17s982ms 0ms 15ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 01 126,035 821ms 0ms 02 125,134 809ms 0ms 03 125,129 818ms 0ms 04 125,231 831ms 0ms 05 125,232 825ms 0ms 06 125,248 825ms 0ms 07 125,255 826ms 0ms 08 125,254 799ms 0ms 09 125,225 812ms 0ms 10 125,136 815ms 0ms 11 125,177 812ms 0ms 12 125,057 818ms 0ms 13 124,979 832ms 0ms 14 125,056 816ms 0ms 15 125,413 826ms 0ms 16 124,990 826ms 0ms 17 125,136 810ms 0ms 18 125,158 827ms 0ms 19 125,204 820ms 0ms 20 124,951 805ms 0ms 21 17,894 106ms 0ms 22 5,303 35ms 0ms 23 98,046 643ms 0ms 00 125,122 813ms 0ms [ User: symmetricds - Total duration: 17s980ms - Times executed: 2750087 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 278 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s982ms - Times executed: 2750365 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-03 12:28:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:48:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 09:54:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2,750,364 15m3s 0ms 93ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 01 126,034 43s150ms 0ms 02 125,134 39s838ms 0ms 03 125,129 40s485ms 0ms 04 125,231 42s102ms 0ms 05 125,232 40s565ms 0ms 06 125,248 41s418ms 0ms 07 125,255 40s516ms 0ms 08 125,254 39s158ms 0ms 09 125,225 40s485ms 0ms 10 125,135 41s236ms 0ms 11 125,178 43s441ms 0ms 12 125,056 40s842ms 0ms 13 124,980 41s356ms 0ms 14 125,056 40s547ms 0ms 15 125,413 42s333ms 0ms 16 124,989 40s852ms 0ms 17 125,136 38s767ms 0ms 18 125,159 40s363ms 0ms 19 125,204 46s471ms 0ms 20 124,950 41s686ms 0ms 21 17,895 3s753ms 0ms 22 5,303 161ms 0ms 23 98,046 31s819ms 0ms 00 125,122 42s399ms 0ms [ User: symmetricds - Total duration: 15m3s - Times executed: 2750087 ]
[ User: pharmisight - Total duration: 19ms - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m3s - Times executed: 2750364 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-03 10:37:57 Duration: 93ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:58:56 Duration: 47ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1,737,793 7m1s 0ms 14ms 0ms UPDATE sym_outgoing_batch SET status = ?, load_id = ?, extract_job_flag = ?, load_flag = ?, error_flag = ?, byte_count = ?, extract_count = ?, sent_count = ?, load_count = ?, data_row_count = ?, reload_row_count = ?, data_insert_row_count = ?, data_update_row_count = ?, data_delete_row_count = ?, other_row_count = ?, ignore_count = ?, router_millis = ?, network_millis = ?, filter_millis = ?, load_millis = ?, extract_millis = ?, extract_start_time = ?, transfer_start_time = ?, load_start_time = NULL, sql_state = NULL, sql_code = ?, sql_message = NULL, failed_data_id = ?, last_update_hostname = ?, last_update_time = current_timestamp, summary = ?, load_row_count = ?, load_insert_row_count = ?, load_update_row_count = ?, load_delete_row_count = ?, fallback_insert_count = ?, fallback_update_count = ?, ignore_row_count = ?, missing_delete_count = ?, skip_count = ?, extract_row_count = ?, extract_insert_row_count = ?, extract_update_row_count = ?, extract_delete_row_count = ?, transform_extract_millis = ?, transform_load_millis = ? WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 03 01 79,444 19s599ms 0ms 02 79,443 19s378ms 0ms 03 79,444 19s529ms 0ms 04 79,444 19s573ms 0ms 05 79,443 19s248ms 0ms 06 79,445 19s119ms 0ms 07 79,444 19s371ms 0ms 08 79,445 19s371ms 0ms 09 79,443 19s240ms 0ms 10 79,383 19s431ms 0ms 11 79,432 19s200ms 0ms 12 79,402 19s9ms 0ms 13 79,354 19s127ms 0ms 14 79,410 19s552ms 0ms 15 79,584 19s211ms 0ms 16 79,279 19s162ms 0ms 17 79,381 19s205ms 0ms 18 79,401 19s269ms 0ms 19 79,511 19s303ms 0ms 20 79,332 19s21ms 0ms 21 8,358 1s770ms 0ms 22 4 1ms 0ms 23 61,509 15s92ms 0ms 00 79,458 19s198ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1737793 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1737793 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '6144', extract_count = '2400', sent_count = '2400', load_count = '2400', data_row_count = '12', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '7', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '27', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:17:45.857', transfer_start_time = '2019-08-03 10:46:57.628', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, orders, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '12', extract_insert_row_count = '5', extract_update_row_count = '7', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195255' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3924', extract_count = '2991', sent_count = '2990', load_count = '2990', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '5', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:26:45.752', transfer_start_time = '2019-08-03 23:53:03.666', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_round_activities, order_rounds, flow_reports', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '6', extract_insert_row_count = '1', extract_update_row_count = '5', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195657' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3620', extract_count = '2788', sent_count = '2787', load_count = '2787', data_row_count = '5', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 15:17:45.839', transfer_start_time = '2019-08-03 17:13:59.026', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '5', extract_insert_row_count = '2', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195251' AND node_id = '2';
Date: 2019-08-03 10:46:57 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:54:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 17:14:58 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1,339,474 16s249ms 0ms 2ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 03 01 62,169 750ms 0ms 02 60,643 728ms 0ms 03 60,995 731ms 0ms 04 61,845 764ms 0ms 05 60,919 749ms 0ms 06 61,406 750ms 0ms 07 61,083 754ms 0ms 08 59,318 710ms 0ms 09 60,995 743ms 0ms 10 60,417 731ms 0ms 11 60,777 744ms 0ms 12 61,250 741ms 0ms 13 60,850 747ms 0ms 14 60,278 730ms 0ms 15 62,509 765ms 0ms 16 60,931 734ms 0ms 17 59,904 715ms 0ms 18 61,407 748ms 0ms 19 62,447 759ms 0ms 20 61,435 732ms 0ms 21 6,369 68ms 0ms 22 380 6ms 0ms 23 48,049 581ms 0ms 00 63,098 759ms 0ms [ User: symmetricds - Total duration: 16s249ms - Times executed: 1339474 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s249ms - Times executed: 1339474 ]
-
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: 2019-08-03 05:50:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:49:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:54:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1,339,473 15s712ms 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 03 01 62,169 722ms 0ms 02 60,643 705ms 0ms 03 60,994 708ms 0ms 04 61,846 746ms 0ms 05 60,919 732ms 0ms 06 61,404 727ms 0ms 07 61,085 729ms 0ms 08 59,316 685ms 0ms 09 60,997 717ms 0ms 10 60,416 707ms 0ms 11 60,775 712ms 0ms 12 61,253 720ms 0ms 13 60,849 727ms 0ms 14 60,277 706ms 0ms 15 62,510 737ms 0ms 16 60,931 708ms 0ms 17 59,902 690ms 0ms 18 61,410 718ms 0ms 19 62,446 738ms 0ms 20 61,435 708ms 0ms 21 6,370 64ms 0ms 22 380 5ms 0ms 23 48,049 557ms 0ms 00 63,097 735ms 0ms [ User: symmetricds - Total duration: 15s712ms - Times executed: 1339473 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s712ms - Times executed: 1339473 ]
-
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: 2019-08-03 03:18:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 15:59:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:13:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 891,382 40s252ms 0ms 4ms 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 #8
Day Hour Count Duration Avg duration Aug 03 01 40,680 1s864ms 0ms 02 40,682 1s826ms 0ms 03 40,680 1s839ms 0ms 04 40,678 1s842ms 0ms 05 40,678 1s824ms 0ms 06 40,681 1s835ms 0ms 07 40,682 1s854ms 0ms 08 40,681 1s808ms 0ms 09 40,680 1s831ms 0ms 10 40,648 1s825ms 0ms 11 40,671 1s825ms 0ms 12 40,659 1s834ms 0ms 13 40,637 1s831ms 0ms 14 40,663 1s823ms 0ms 15 40,751 1s860ms 0ms 16 40,599 1s817ms 0ms 17 40,649 1s827ms 0ms 18 40,661 1s854ms 0ms 19 40,711 1s851ms 0ms 20 40,625 1s812ms 0ms 21 4,926 212ms 0ms 22 720 38ms 0ms 23 31,655 1s461ms 0ms 00 40,685 1s848ms 0ms [ User: symmetricds - Total duration: 40s252ms - Times executed: 891382 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s252ms - Times executed: 891382 ]
-
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 = '2';
-
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 = '2';
-
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 = '2';
Date: 2019-08-03 14:55:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 00:16:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:08:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 866,327 3m27s 0ms 12ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = ? AND o.node_id = ? ORDER BY d.data_id ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 03 01 39,604 9s517ms 0ms 02 39,604 9s539ms 0ms 03 39,604 9s507ms 0ms 04 39,604 9s608ms 0ms 05 39,604 9s460ms 0ms 06 39,605 9s449ms 0ms 07 39,604 9s698ms 0ms 08 39,605 9s485ms 0ms 09 39,604 9s570ms 0ms 10 39,576 9s649ms 0ms 11 39,597 9s558ms 0ms 12 39,585 9s495ms 0ms 13 39,559 9s600ms 0ms 14 39,588 9s369ms 0ms 15 39,674 9s628ms 0ms 16 39,521 9s395ms 0ms 17 39,573 9s318ms 0ms 18 39,583 9s494ms 0ms 19 39,638 9s389ms 0ms 20 39,548 9s213ms 0ms 21 4,166 877ms 0ms 22 4 0ms 0ms 23 30,667 7s429ms 0ms 00 39,610 9s472ms 0ms [ User: symmetricds - Total duration: 3m27s - Times executed: 866327 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m27s - Times executed: 866327 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195613' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9194871' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195349' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-03 13:04:59 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:00:53 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 462,910 29s855ms 0ms 5ms 0ms 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 batch_id = ? AND node_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 03 01 22,133 1s502ms 0ms 02 20,606 1s328ms 0ms 03 20,958 1s322ms 0ms 04 21,811 1s444ms 0ms 05 20,884 1s426ms 0ms 06 21,369 1s398ms 0ms 07 21,047 1s381ms 0ms 08 19,279 1s223ms 0ms 09 20,961 1s384ms 0ms 10 20,408 1s301ms 0ms 11 20,747 1s382ms 0ms 12 21,236 1s417ms 0ms 13 20,857 1s343ms 0ms 14 20,258 1s314ms 0ms 15 22,404 1s429ms 0ms 16 20,977 1s330ms 0ms 17 19,897 1s255ms 0ms 18 21,394 1s341ms 0ms 19 22,378 1s404ms 0ms 20 21,454 1s334ms 0ms 21 1,825 97ms 0ms 22 4 0ms 0ms 23 16,964 1s69ms 0ms 00 23,059 1s421ms 0ms [ User: symmetricds - Total duration: 29s855ms - Times executed: 462910 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s855ms - Times executed: 462910 ]
-
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 batch_id = '9195579' AND node_id = '2';
-
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 batch_id = '9196575' AND node_id = '2';
-
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 batch_id = '9196043' AND node_id = '2';
Date: 2019-08-03 01:48:57 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 03:02:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 08:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 47,620 1m12s 0ms 43ms 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 #11
Day Hour Count Duration Avg duration Aug 03 01 2,164 3s386ms 1ms 02 2,164 3s285ms 1ms 03 2,164 3s372ms 1ms 04 2,164 3s357ms 1ms 05 2,164 3s382ms 1ms 06 2,165 3s402ms 1ms 07 2,164 3s449ms 1ms 08 2,165 3s365ms 1ms 09 2,164 3s281ms 1ms 10 2,164 3s353ms 1ms 11 2,164 3s190ms 1ms 12 2,164 3s237ms 1ms 13 2,164 3s161ms 1ms 14 2,164 4s293ms 1ms 15 2,164 3s97ms 1ms 16 2,164 3s136ms 1ms 17 2,164 3s30ms 1ms 18 2,164 3s138ms 1ms 19 2,164 3s99ms 1ms 20 2,164 3s22ms 1ms 21 328 366ms 1ms 22 124 127ms 1ms 23 1,722 2s464ms 1ms 00 2,164 3s180ms 1ms [ User: symmetricds - Total duration: 1m12s - Times executed: 47620 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m12s - Times executed: 47620 ]
-
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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-08-03 07:06:52 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:27:52 Duration: 39ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 02:05:50 Duration: 37ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 25,021 1s255ms 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 Aug 03 01 1,116 55ms 0ms 02 1,050 55ms 0ms 03 1,048 52ms 0ms 04 1,046 53ms 0ms 05 1,046 51ms 0ms 06 1,047 51ms 0ms 07 1,050 53ms 0ms 08 1,047 51ms 0ms 09 1,044 50ms 0ms 10 1,044 52ms 0ms 11 1,046 52ms 0ms 12 1,046 52ms 0ms 13 1,046 52ms 0ms 14 1,044 52ms 0ms 15 1,044 52ms 0ms 16 1,046 50ms 0ms 17 1,044 50ms 0ms 18 1,046 49ms 0ms 19 1,042 49ms 0ms 20 1,044 52ms 0ms 21 986 50ms 0ms 22 980 55ms 0ms 23 1,027 51ms 0ms 00 1,042 53ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25021 ]
-
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: 2019-08-03 01:34:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 21:36:55 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:21:56 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 24,648 1s446ms 0ms 2ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 03 01 1,027 36ms 0ms 02 1,027 38ms 0ms 03 1,027 49ms 0ms 04 1,027 54ms 0ms 05 1,027 50ms 0ms 06 1,027 57ms 0ms 07 1,027 59ms 0ms 08 1,027 57ms 0ms 09 1,027 56ms 0ms 10 1,027 67ms 0ms 11 1,027 60ms 0ms 12 1,027 61ms 0ms 13 1,027 70ms 0ms 14 1,027 55ms 0ms 15 1,027 74ms 0ms 16 1,027 68ms 0ms 17 1,027 68ms 0ms 18 1,027 44ms 0ms 19 1,027 85ms 0ms 20 1,027 69ms 0ms 21 1,027 56ms 0ms 22 1,027 63ms 0ms 23 1,027 71ms 0ms 00 1,027 66ms 0ms [ User: pharmisight - Total duration: 1s446ms - Times executed: 24648 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s446ms - Times executed: 24648 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3702' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '21' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3249' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-03 21:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 21,888 1s285ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 01 912 32ms 0ms 02 912 34ms 0ms 03 912 43ms 0ms 04 912 49ms 0ms 05 912 45ms 0ms 06 912 51ms 0ms 07 912 53ms 0ms 08 912 50ms 0ms 09 912 50ms 0ms 10 912 61ms 0ms 11 912 52ms 0ms 12 912 54ms 0ms 13 912 61ms 0ms 14 912 49ms 0ms 15 912 63ms 0ms 16 912 65ms 0ms 17 912 59ms 0ms 18 912 40ms 0ms 19 912 77ms 0ms 20 912 62ms 0ms 21 912 51ms 0ms 22 912 55ms 0ms 23 912 61ms 0ms 00 912 58ms 0ms [ User: pharmisight - Total duration: 1s285ms - Times executed: 21888 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s285ms - Times executed: 21888 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3352' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3005' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '20482651' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-03 19:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 17,280 25s106ms 0ms 51ms 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 #15
Day Hour Count Duration Avg duration Aug 03 01 720 1s70ms 1ms 02 720 1s35ms 1ms 03 720 1s132ms 1ms 04 720 1s45ms 1ms 05 720 1s59ms 1ms 06 720 1s69ms 1ms 07 720 1s103ms 1ms 08 720 1s200ms 1ms 09 720 1s77ms 1ms 10 720 1s122ms 1ms 11 720 1s84ms 1ms 12 720 1s83ms 1ms 13 720 1s97ms 1ms 14 720 1s44ms 1ms 15 720 998ms 1ms 16 720 1s13ms 1ms 17 720 939ms 1ms 18 720 953ms 1ms 19 720 942ms 1ms 20 720 969ms 1ms 21 720 1s71ms 1ms 22 720 1s90ms 1ms 23 720 1s7ms 1ms 00 720 894ms 1ms [ User: symmetricds - Total duration: 25s106ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s106ms - Times executed: 17280 ]
-
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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-03 06:19:49 Duration: 51ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 01:43:48 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:37:49 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 17,252 478ms 0ms 2ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 03 01 720 19ms 0ms 02 718 19ms 0ms 03 718 20ms 0ms 04 720 19ms 0ms 05 718 19ms 0ms 06 720 19ms 0ms 07 720 19ms 0ms 08 720 19ms 0ms 09 718 18ms 0ms 10 720 19ms 0ms 11 720 20ms 0ms 12 718 18ms 0ms 13 716 22ms 0ms 14 718 20ms 0ms 15 718 19ms 0ms 16 720 19ms 0ms 17 718 20ms 0ms 18 720 19ms 0ms 19 718 19ms 0ms 20 720 19ms 0ms 21 720 21ms 0ms 22 720 21ms 0ms 23 718 20ms 0ms 00 716 20ms 0ms [ User: symmetricds - Total duration: 478ms - Times executed: 17252 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 478ms - Times executed: 17252 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-08-03 12:47:54 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 13:03:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 02:53:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 17,187 9s443ms 0ms 3ms 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 #17
Day Hour Count Duration Avg duration Aug 03 01 717 386ms 0ms 02 718 395ms 0ms 03 716 387ms 0ms 04 714 394ms 0ms 05 714 393ms 0ms 06 716 394ms 0ms 07 718 402ms 0ms 08 716 386ms 0ms 09 716 386ms 0ms 10 716 393ms 0ms 11 714 382ms 0ms 12 716 390ms 0ms 13 718 393ms 0ms 14 716 391ms 0ms 15 716 398ms 0ms 16 718 380ms 0ms 17 716 385ms 0ms 18 718 383ms 0ms 19 714 384ms 0ms 20 716 384ms 0ms 21 718 429ms 0ms 22 716 435ms 0ms 23 716 389ms 0ms 00 714 390ms 0ms [ User: symmetricds - Total duration: 9s443ms - Times executed: 17187 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s443ms - Times executed: 17187 ]
-
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: 2019-08-03 20:40:03 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:58:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 20:54:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 8,593 215ms 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 #18
Day Hour Count Duration Avg duration Aug 03 01 358 9ms 0ms 02 359 8ms 0ms 03 358 8ms 0ms 04 357 8ms 0ms 05 357 9ms 0ms 06 358 8ms 0ms 07 359 9ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 357 8ms 0ms 12 358 9ms 0ms 13 359 9ms 0ms 14 358 8ms 0ms 15 358 9ms 0ms 16 359 8ms 0ms 17 358 8ms 0ms 18 359 8ms 0ms 19 357 8ms 0ms 20 358 8ms 0ms 21 359 9ms 0ms 22 358 9ms 0ms 23 358 9ms 0ms 00 357 8ms 0ms [ User: symmetricds - Total duration: 215ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 215ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808215' AND data_id <= '154808214' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808268' AND data_id <= '154808267' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808343' AND data_id <= '154808342' ORDER BY data_id ASC;
Date: 2019-08-03 04:57:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:53:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 11:16:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 8,593 308ms 0ms 10ms 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 #19
Day Hour Count Duration Avg duration Aug 03 01 358 12ms 0ms 02 359 12ms 0ms 03 358 12ms 0ms 04 357 11ms 0ms 05 357 13ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 22ms 0ms 09 358 13ms 0ms 10 358 12ms 0ms 11 357 12ms 0ms 12 358 12ms 0ms 13 359 12ms 0ms 14 358 11ms 0ms 15 358 12ms 0ms 16 359 12ms 0ms 17 358 12ms 0ms 18 359 11ms 0ms 19 357 12ms 0ms 20 358 12ms 0ms 21 359 12ms 0ms 22 358 13ms 0ms 23 358 12ms 0ms 00 357 12ms 0ms [ User: symmetricds - Total duration: 308ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 308ms - Times executed: 8593 ]
-
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 = '3' 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 = '3' 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 = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-08-03 07:40:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 08:43:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:46:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 8,593 396ms 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 #20
Day Hour Count Duration Avg duration Aug 03 01 358 16ms 0ms 02 359 17ms 0ms 03 358 16ms 0ms 04 357 16ms 0ms 05 357 16ms 0ms 06 358 16ms 0ms 07 359 17ms 0ms 08 358 15ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 357 16ms 0ms 12 358 16ms 0ms 13 359 16ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 359 15ms 0ms 17 358 15ms 0ms 18 359 16ms 0ms 19 357 16ms 0ms 20 358 16ms 0ms 21 359 17ms 0ms 22 358 17ms 0ms 23 358 16ms 0ms 00 357 16ms 0ms [ User: symmetricds - Total duration: 396ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 396ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-08-03 06:53:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 05:30:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:50:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 47ms 100ms 84ms 24 2s31ms 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 Aug 03 01 1 84ms 84ms 02 1 81ms 81ms 03 1 81ms 81ms 04 1 84ms 84ms 05 1 82ms 82ms 06 1 82ms 82ms 07 1 47ms 47ms 08 1 83ms 83ms 09 1 82ms 82ms 10 1 83ms 83ms 11 1 93ms 93ms 12 1 93ms 93ms 13 1 85ms 85ms 14 1 100ms 100ms 15 1 85ms 85ms 16 1 81ms 81ms 17 1 88ms 88ms 18 1 80ms 80ms 19 1 96ms 96ms 20 1 99ms 99ms 21 1 80ms 80ms 22 1 84ms 84ms 23 1 83ms 83ms 00 1 84ms 84ms [ User: symmetricds - Total duration: 2s31ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s31ms - Times executed: 24 ]
-
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: 2019-08-03 13:00:00 Duration: 100ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:00:00 Duration: 96ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 2ms 77ms 16ms 384 6s324ms 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 Aug 03 01 16 166ms 10ms 02 16 167ms 10ms 03 16 123ms 7ms 04 16 128ms 8ms 05 16 127ms 7ms 06 16 124ms 7ms 07 16 72ms 4ms 08 16 428ms 26ms 09 16 205ms 12ms 10 16 279ms 17ms 11 16 248ms 15ms 12 16 315ms 19ms 13 16 323ms 20ms 14 16 306ms 19ms 15 16 277ms 17ms 16 16 295ms 18ms 17 16 314ms 19ms 18 16 395ms 24ms 19 16 336ms 21ms 20 16 329ms 20ms 21 16 310ms 19ms 22 16 393ms 24ms 23 16 301ms 18ms 00 16 351ms 21ms [ User: symmetricds - Total duration: 6s324ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s324ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104754155' AND '104759155' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '104744153' AND '104749153' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104744153' AND '104749153') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104744153' AND '104749153' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '104749154' AND '104754154' AND create_time < '2019-08-02 07:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104749154' AND '104754154') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104749154' AND '104754154' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-03 07:00:00 Duration: 77ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:00 Duration: 61ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:00 Duration: 58ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2ms 38ms 9ms 384 3s700ms 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 Aug 03 01 16 93ms 5ms 02 16 92ms 5ms 03 16 91ms 5ms 04 16 94ms 5ms 05 16 94ms 5ms 06 16 92ms 5ms 07 16 54ms 3ms 08 16 262ms 16ms 09 16 120ms 7ms 10 16 127ms 7ms 11 16 150ms 9ms 12 16 207ms 12ms 13 16 173ms 10ms 14 16 160ms 10ms 15 16 185ms 11ms 16 16 159ms 9ms 17 16 189ms 11ms 18 16 175ms 10ms 19 16 205ms 12ms 20 16 246ms 15ms 21 16 163ms 10ms 22 16 187ms 11ms 23 16 160ms 10ms 00 16 209ms 13ms [ User: symmetricds - Total duration: 3s700ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s700ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808478' AND data_id < '104808481' AND create_time < '2019-08-02 23:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808478');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104764157' AND '104769157' AND data_id < '104808269' AND create_time < '2019-08-02 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104764157' AND '104769157');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104759156' AND '104764156' AND data_id < '104808269' AND create_time < '2019-08-02 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104759156' AND '104764156');
Date: 2019-08-03 23:00:00 Duration: 38ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:01 Duration: 35ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:00:01 Duration: 33ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 13ms 5ms 551 3s65ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 01 131 662ms 5ms 02 19 120ms 6ms 03 19 99ms 5ms 04 19 104ms 5ms 05 19 98ms 5ms 06 19 143ms 7ms 07 19 99ms 5ms 08 19 99ms 5ms 09 19 99ms 5ms 10 19 97ms 5ms 11 19 98ms 5ms 12 19 96ms 5ms 13 19 98ms 5ms 14 19 133ms 7ms 15 19 98ms 5ms 16 19 97ms 5ms 17 19 97ms 5ms 18 19 97ms 5ms 19 19 99ms 5ms 20 19 100ms 5ms 21 19 100ms 5ms 22 2 18ms 9ms 23 19 128ms 6ms 00 19 174ms 9ms [ User: symmetricds - Total duration: 2s860ms - Times executed: 506 ]
[ User: pharmisight - Total duration: 205ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s65ms - Times executed: 551 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-03 05:00:52 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 01:00:51 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:04:56 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 16ms 3ms 1,154 4s403ms 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 Aug 03 01 55 205ms 3ms 02 53 199ms 3ms 03 53 204ms 3ms 04 57 219ms 3ms 05 54 200ms 3ms 06 53 192ms 3ms 07 58 221ms 3ms 08 54 200ms 3ms 09 52 195ms 3ms 10 55 202ms 3ms 11 51 196ms 3ms 12 52 194ms 3ms 13 49 185ms 3ms 14 48 195ms 4ms 15 50 195ms 3ms 16 48 196ms 4ms 17 44 166ms 3ms 18 42 163ms 3ms 19 46 170ms 3ms 20 43 167ms 3ms 21 23 91ms 3ms 22 24 97ms 4ms 23 43 161ms 3ms 00 47 180ms 3ms [ User: symmetricds - Total duration: 4s403ms - Times executed: 1154 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s403ms - Times executed: 1154 ]
-
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: 2019-08-03 13:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 15:04:54 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 13:53:53 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 43ms 1ms 47,620 1m12s 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 Aug 03 01 2,164 3s386ms 1ms 02 2,164 3s285ms 1ms 03 2,164 3s372ms 1ms 04 2,164 3s357ms 1ms 05 2,164 3s382ms 1ms 06 2,165 3s402ms 1ms 07 2,164 3s449ms 1ms 08 2,165 3s365ms 1ms 09 2,164 3s281ms 1ms 10 2,164 3s353ms 1ms 11 2,164 3s190ms 1ms 12 2,164 3s237ms 1ms 13 2,164 3s161ms 1ms 14 2,164 4s293ms 1ms 15 2,164 3s97ms 1ms 16 2,164 3s136ms 1ms 17 2,164 3s30ms 1ms 18 2,164 3s138ms 1ms 19 2,164 3s99ms 1ms 20 2,164 3s22ms 1ms 21 328 366ms 1ms 22 124 127ms 1ms 23 1,722 2s464ms 1ms 00 2,164 3s180ms 1ms [ User: symmetricds - Total duration: 1m12s - Times executed: 47620 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m12s - Times executed: 47620 ]
-
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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-08-03 07:06:52 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 07:27:52 Duration: 39ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 02:05:50 Duration: 37ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 51ms 1ms 17,280 25s106ms 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 Aug 03 01 720 1s70ms 1ms 02 720 1s35ms 1ms 03 720 1s132ms 1ms 04 720 1s45ms 1ms 05 720 1s59ms 1ms 06 720 1s69ms 1ms 07 720 1s103ms 1ms 08 720 1s200ms 1ms 09 720 1s77ms 1ms 10 720 1s122ms 1ms 11 720 1s84ms 1ms 12 720 1s83ms 1ms 13 720 1s97ms 1ms 14 720 1s44ms 1ms 15 720 998ms 1ms 16 720 1s13ms 1ms 17 720 939ms 1ms 18 720 953ms 1ms 19 720 942ms 1ms 20 720 969ms 1ms 21 720 1s71ms 1ms 22 720 1s90ms 1ms 23 720 1s7ms 1ms 00 720 894ms 1ms [ User: symmetricds - Total duration: 25s106ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s106ms - Times executed: 17280 ]
-
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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') 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 = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-03 06:19:49 Duration: 51ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 01:43:48 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:37:49 Duration: 23ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 1ms 1,257 1s735ms 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 Aug 03 01 53 71ms 1ms 02 55 75ms 1ms 03 56 74ms 1ms 04 56 77ms 1ms 05 57 77ms 1ms 06 56 79ms 1ms 07 57 77ms 1ms 08 56 76ms 1ms 09 57 80ms 1ms 10 56 78ms 1ms 11 51 70ms 1ms 12 50 68ms 1ms 13 49 69ms 1ms 14 50 66ms 1ms 15 52 72ms 1ms 16 50 68ms 1ms 17 48 67ms 1ms 18 44 61ms 1ms 19 48 63ms 1ms 20 45 61ms 1ms 21 60 83ms 1ms 22 58 85ms 1ms 23 48 66ms 1ms 00 45 59ms 1ms [ User: symmetricds - Total duration: 1s735ms - Times executed: 1257 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s735ms - Times executed: 1257 ]
-
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: 2019-08-03 08:13:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:25:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 03:14:51 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 14ms 0ms 1,548 1s481ms 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 Aug 03 01 68 62ms 0ms 02 68 63ms 0ms 03 69 63ms 0ms 04 69 63ms 0ms 05 69 62ms 0ms 06 68 63ms 0ms 07 71 66ms 0ms 08 68 64ms 0ms 09 70 66ms 0ms 10 69 67ms 0ms 11 64 60ms 0ms 12 64 61ms 0ms 13 62 61ms 0ms 14 60 55ms 0ms 15 61 58ms 0ms 16 59 56ms 0ms 17 60 55ms 0ms 18 57 53ms 0ms 19 58 58ms 1ms 20 58 52ms 0ms 21 64 63ms 0ms 22 71 70ms 0ms 23 61 71ms 1ms 00 60 55ms 0ms [ User: symmetricds - Total duration: 1s481ms - Times executed: 1548 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s481ms - Times executed: 1548 ]
-
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: 2019-08-03 22:47:56 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:47:53 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:47:54 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 3ms 0ms 17,187 9s443ms 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 #10
Day Hour Count Duration Avg duration Aug 03 01 717 386ms 0ms 02 718 395ms 0ms 03 716 387ms 0ms 04 714 394ms 0ms 05 714 393ms 0ms 06 716 394ms 0ms 07 718 402ms 0ms 08 716 386ms 0ms 09 716 386ms 0ms 10 716 393ms 0ms 11 714 382ms 0ms 12 716 390ms 0ms 13 718 393ms 0ms 14 716 391ms 0ms 15 716 398ms 0ms 16 718 380ms 0ms 17 716 385ms 0ms 18 718 383ms 0ms 19 714 384ms 0ms 20 716 384ms 0ms 21 718 429ms 0ms 22 716 435ms 0ms 23 716 389ms 0ms 00 714 390ms 0ms [ User: symmetricds - Total duration: 9s443ms - Times executed: 17187 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s443ms - Times executed: 17187 ]
-
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: 2019-08-03 20:40:03 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:58:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 20:54:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 93ms 0ms 2,750,364 15m3s COMMIT;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 03 01 126,034 43s150ms 0ms 02 125,134 39s838ms 0ms 03 125,129 40s485ms 0ms 04 125,231 42s102ms 0ms 05 125,232 40s565ms 0ms 06 125,248 41s418ms 0ms 07 125,255 40s516ms 0ms 08 125,254 39s158ms 0ms 09 125,225 40s485ms 0ms 10 125,135 41s236ms 0ms 11 125,178 43s441ms 0ms 12 125,056 40s842ms 0ms 13 124,980 41s356ms 0ms 14 125,056 40s547ms 0ms 15 125,413 42s333ms 0ms 16 124,989 40s852ms 0ms 17 125,136 38s767ms 0ms 18 125,159 40s363ms 0ms 19 125,204 46s471ms 0ms 20 124,950 41s686ms 0ms 21 17,895 3s753ms 0ms 22 5,303 161ms 0ms 23 98,046 31s819ms 0ms 00 125,122 42s399ms 0ms [ User: symmetricds - Total duration: 15m3s - Times executed: 2750087 ]
[ User: pharmisight - Total duration: 19ms - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m3s - Times executed: 2750364 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-03 10:37:57 Duration: 93ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:58:56 Duration: 47ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 14ms 0ms 1,737,793 7m1s UPDATE sym_outgoing_batch SET status = ?, load_id = ?, extract_job_flag = ?, load_flag = ?, error_flag = ?, byte_count = ?, extract_count = ?, sent_count = ?, load_count = ?, data_row_count = ?, reload_row_count = ?, data_insert_row_count = ?, data_update_row_count = ?, data_delete_row_count = ?, other_row_count = ?, ignore_count = ?, router_millis = ?, network_millis = ?, filter_millis = ?, load_millis = ?, extract_millis = ?, extract_start_time = ?, transfer_start_time = ?, load_start_time = NULL, sql_state = NULL, sql_code = ?, sql_message = NULL, failed_data_id = ?, last_update_hostname = ?, last_update_time = current_timestamp, summary = ?, load_row_count = ?, load_insert_row_count = ?, load_update_row_count = ?, load_delete_row_count = ?, fallback_insert_count = ?, fallback_update_count = ?, ignore_row_count = ?, missing_delete_count = ?, skip_count = ?, extract_row_count = ?, extract_insert_row_count = ?, extract_update_row_count = ?, extract_delete_row_count = ?, transform_extract_millis = ?, transform_load_millis = ? WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 03 01 79,444 19s599ms 0ms 02 79,443 19s378ms 0ms 03 79,444 19s529ms 0ms 04 79,444 19s573ms 0ms 05 79,443 19s248ms 0ms 06 79,445 19s119ms 0ms 07 79,444 19s371ms 0ms 08 79,445 19s371ms 0ms 09 79,443 19s240ms 0ms 10 79,383 19s431ms 0ms 11 79,432 19s200ms 0ms 12 79,402 19s9ms 0ms 13 79,354 19s127ms 0ms 14 79,410 19s552ms 0ms 15 79,584 19s211ms 0ms 16 79,279 19s162ms 0ms 17 79,381 19s205ms 0ms 18 79,401 19s269ms 0ms 19 79,511 19s303ms 0ms 20 79,332 19s21ms 0ms 21 8,358 1s770ms 0ms 22 4 1ms 0ms 23 61,509 15s92ms 0ms 00 79,458 19s198ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1737793 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1737793 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '6144', extract_count = '2400', sent_count = '2400', load_count = '2400', data_row_count = '12', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '7', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '27', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:17:45.857', transfer_start_time = '2019-08-03 10:46:57.628', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, orders, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '12', extract_insert_row_count = '5', extract_update_row_count = '7', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195255' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3924', extract_count = '2991', sent_count = '2990', load_count = '2990', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '5', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:26:45.752', transfer_start_time = '2019-08-03 23:53:03.666', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_round_activities, order_rounds, flow_reports', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '6', extract_insert_row_count = '1', extract_update_row_count = '5', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195657' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3620', extract_count = '2788', sent_count = '2787', load_count = '2787', data_row_count = '5', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 15:17:45.839', transfer_start_time = '2019-08-03 17:13:59.026', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '5', extract_insert_row_count = '2', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195251' AND node_id = '2';
Date: 2019-08-03 10:46:57 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:54:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 17:14:58 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 12ms 0ms 866,327 3m27s SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = ? AND o.node_id = ? ORDER BY d.data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 03 01 39,604 9s517ms 0ms 02 39,604 9s539ms 0ms 03 39,604 9s507ms 0ms 04 39,604 9s608ms 0ms 05 39,604 9s460ms 0ms 06 39,605 9s449ms 0ms 07 39,604 9s698ms 0ms 08 39,605 9s485ms 0ms 09 39,604 9s570ms 0ms 10 39,576 9s649ms 0ms 11 39,597 9s558ms 0ms 12 39,585 9s495ms 0ms 13 39,559 9s600ms 0ms 14 39,588 9s369ms 0ms 15 39,674 9s628ms 0ms 16 39,521 9s395ms 0ms 17 39,573 9s318ms 0ms 18 39,583 9s494ms 0ms 19 39,638 9s389ms 0ms 20 39,548 9s213ms 0ms 21 4,166 877ms 0ms 22 4 0ms 0ms 23 30,667 7s429ms 0ms 00 39,610 9s472ms 0ms [ User: symmetricds - Total duration: 3m27s - Times executed: 866327 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m27s - Times executed: 866327 ]
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195613' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9194871' AND o.node_id = '2' ORDER BY d.data_id ASC;
-
SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = '9195349' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-03 13:04:59 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 06:00:53 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:37:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 5ms 0ms 462,910 29s855ms 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 batch_id = ? AND node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 01 22,133 1s502ms 0ms 02 20,606 1s328ms 0ms 03 20,958 1s322ms 0ms 04 21,811 1s444ms 0ms 05 20,884 1s426ms 0ms 06 21,369 1s398ms 0ms 07 21,047 1s381ms 0ms 08 19,279 1s223ms 0ms 09 20,961 1s384ms 0ms 10 20,408 1s301ms 0ms 11 20,747 1s382ms 0ms 12 21,236 1s417ms 0ms 13 20,857 1s343ms 0ms 14 20,258 1s314ms 0ms 15 22,404 1s429ms 0ms 16 20,977 1s330ms 0ms 17 19,897 1s255ms 0ms 18 21,394 1s341ms 0ms 19 22,378 1s404ms 0ms 20 21,454 1s334ms 0ms 21 1,825 97ms 0ms 22 4 0ms 0ms 23 16,964 1s69ms 0ms 00 23,059 1s421ms 0ms [ User: symmetricds - Total duration: 29s855ms - Times executed: 462910 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s855ms - Times executed: 462910 ]
-
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 batch_id = '9195579' AND node_id = '2';
-
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 batch_id = '9196575' AND node_id = '2';
-
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 batch_id = '9196043' AND node_id = '2';
Date: 2019-08-03 01:48:57 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 03:02:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 08:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 21,888 1s285ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 03 01 912 32ms 0ms 02 912 34ms 0ms 03 912 43ms 0ms 04 912 49ms 0ms 05 912 45ms 0ms 06 912 51ms 0ms 07 912 53ms 0ms 08 912 50ms 0ms 09 912 50ms 0ms 10 912 61ms 0ms 11 912 52ms 0ms 12 912 54ms 0ms 13 912 61ms 0ms 14 912 49ms 0ms 15 912 63ms 0ms 16 912 65ms 0ms 17 912 59ms 0ms 18 912 40ms 0ms 19 912 77ms 0ms 20 912 62ms 0ms 21 912 51ms 0ms 22 912 55ms 0ms 23 912 61ms 0ms 00 912 58ms 0ms [ User: pharmisight - Total duration: 1s285ms - Times executed: 21888 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s285ms - Times executed: 21888 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3352' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '3005' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '20482651' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-03 19:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 18:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 2ms 0ms 24,648 1s446ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 03 01 1,027 36ms 0ms 02 1,027 38ms 0ms 03 1,027 49ms 0ms 04 1,027 54ms 0ms 05 1,027 50ms 0ms 06 1,027 57ms 0ms 07 1,027 59ms 0ms 08 1,027 57ms 0ms 09 1,027 56ms 0ms 10 1,027 67ms 0ms 11 1,027 60ms 0ms 12 1,027 61ms 0ms 13 1,027 70ms 0ms 14 1,027 55ms 0ms 15 1,027 74ms 0ms 16 1,027 68ms 0ms 17 1,027 68ms 0ms 18 1,027 44ms 0ms 19 1,027 85ms 0ms 20 1,027 69ms 0ms 21 1,027 56ms 0ms 22 1,027 63ms 0ms 23 1,027 71ms 0ms 00 1,027 66ms 0ms [ User: pharmisight - Total duration: 1s446ms - Times executed: 24648 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s446ms - Times executed: 24648 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3702' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '21' ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '3249' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-03 21:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 14:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 3ms 0ms 25,021 1s255ms 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 #17
Day Hour Count Duration Avg duration Aug 03 01 1,116 55ms 0ms 02 1,050 55ms 0ms 03 1,048 52ms 0ms 04 1,046 53ms 0ms 05 1,046 51ms 0ms 06 1,047 51ms 0ms 07 1,050 53ms 0ms 08 1,047 51ms 0ms 09 1,044 50ms 0ms 10 1,044 52ms 0ms 11 1,046 52ms 0ms 12 1,046 52ms 0ms 13 1,046 52ms 0ms 14 1,044 52ms 0ms 15 1,044 52ms 0ms 16 1,046 50ms 0ms 17 1,044 50ms 0ms 18 1,046 49ms 0ms 19 1,042 49ms 0ms 20 1,044 52ms 0ms 21 986 50ms 0ms 22 980 55ms 0ms 23 1,027 51ms 0ms 00 1,042 53ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25021 ]
-
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: 2019-08-03 01:34:50 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 21:36:55 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 23:21:56 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 8,593 396ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 03 01 358 16ms 0ms 02 359 17ms 0ms 03 358 16ms 0ms 04 357 16ms 0ms 05 357 16ms 0ms 06 358 16ms 0ms 07 359 17ms 0ms 08 358 15ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 357 16ms 0ms 12 358 16ms 0ms 13 359 16ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 359 15ms 0ms 17 358 15ms 0ms 18 359 16ms 0ms 19 357 16ms 0ms 20 358 16ms 0ms 21 359 17ms 0ms 22 358 17ms 0ms 23 358 16ms 0ms 00 357 16ms 0ms [ User: symmetricds - Total duration: 396ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 396ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-08-03 06:53:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 05:30:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 19:50:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 4ms 0ms 891,382 40s252ms 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 #19
Day Hour Count Duration Avg duration Aug 03 01 40,680 1s864ms 0ms 02 40,682 1s826ms 0ms 03 40,680 1s839ms 0ms 04 40,678 1s842ms 0ms 05 40,678 1s824ms 0ms 06 40,681 1s835ms 0ms 07 40,682 1s854ms 0ms 08 40,681 1s808ms 0ms 09 40,680 1s831ms 0ms 10 40,648 1s825ms 0ms 11 40,671 1s825ms 0ms 12 40,659 1s834ms 0ms 13 40,637 1s831ms 0ms 14 40,663 1s823ms 0ms 15 40,751 1s860ms 0ms 16 40,599 1s817ms 0ms 17 40,649 1s827ms 0ms 18 40,661 1s854ms 0ms 19 40,711 1s851ms 0ms 20 40,625 1s812ms 0ms 21 4,926 212ms 0ms 22 720 38ms 0ms 23 31,655 1s461ms 0ms 00 40,685 1s848ms 0ms [ User: symmetricds - Total duration: 40s252ms - Times executed: 891382 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s252ms - Times executed: 891382 ]
-
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 = '2';
-
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 = '2';
-
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 = '2';
Date: 2019-08-03 14:55:00 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 00:16:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:08:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 10ms 0ms 8,593 308ms 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 #20
Day Hour Count Duration Avg duration Aug 03 01 358 12ms 0ms 02 359 12ms 0ms 03 358 12ms 0ms 04 357 11ms 0ms 05 357 13ms 0ms 06 358 12ms 0ms 07 359 12ms 0ms 08 358 22ms 0ms 09 358 13ms 0ms 10 358 12ms 0ms 11 357 12ms 0ms 12 358 12ms 0ms 13 359 12ms 0ms 14 358 11ms 0ms 15 358 12ms 0ms 16 359 12ms 0ms 17 358 12ms 0ms 18 359 11ms 0ms 19 357 12ms 0ms 20 358 12ms 0ms 21 359 12ms 0ms 22 358 13ms 0ms 23 358 12ms 0ms 00 357 12ms 0ms [ User: symmetricds - Total duration: 308ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 308ms - Times executed: 8593 ]
-
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 = '3' 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 = '3' 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 = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-08-03 07:40:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 08:43:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-03 10:46:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 69,245,035 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 03 21 1 - FATAL: no pg_hba.conf entry for host "94.23.194.138", user "postgres", database "postgres", SSL off
Date: 2019-08-03 20:13:08 Database: postgres Application: [unknown] User: postgres Remote: 94.23.194.138 Code:
2 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 03 21 1 - FATAL: no pg_hba.conf entry for host "94.23.194.138", user "postgres", database "postgres", SSL on
Date: 2019-08-03 20:13:08 Database: postgres Application: [unknown] User: postgres Remote: 94.23.194.138 Code: