pgBadger-
Global information
- Generated on Mon Aug 12 00:01:37 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 69,807,295 log entries in 1m33s
- Log start from 2019-08-11 00:00:00 to 2019-08-11 23:59:59
-
Overview
Global Stats
- 173 Number of unique normalized queries
- 23,752,926 Number of queries
- 38m53s Total query duration
- 2019-08-11 00:00:00 First query
- 2019-08-11 23:59:59 Last query
- 4,804 queries/s at 2019-08-11 02:41:00 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 460 Total number of automatic vacuums
- 668 Total number of automatic analyzes
- 1,290 Number temporary file
- 26.30 MiB Max size of temporary file
- 4.38 MiB Average size of temporary file
- 2,123 Total number of sessions
- 3 sessions at 2019-08-11 00:30:21 Session peak
- 10d10h3m18s Total duration of sessions
- 7m4s Average duration of sessions
- 11,188 Average queries per session
- 1s99ms Average queries duration per session
- 2,124 Total number of connections
- 24 connections/s at 2019-08-11 00:30:21 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4,804 queries/s Query Peak
- 2019-08-11 02:41:00 Date
SELECT Traffic
Key values
- 2,196 queries/s Query Peak
- 2019-08-11 01:20:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,744 queries/s Query Peak
- 2019-08-11 02:41:00 Date
Queries duration
Key values
- 38m53s Total query duration
Prepared queries ratio
Key values
- 1.70 Ratio of bind vs prepare
- 169.89 % 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 11 00 1,093,392 0ms 274ms 0ms 2s63ms 2s210ms 6s716ms 01 1,095,475 0ms 254ms 0ms 2s65ms 2s166ms 5s73ms 02 1,096,931 0ms 238ms 0ms 2s64ms 2s203ms 4s727ms 03 1,104,974 0ms 677ms 0ms 2s182ms 2s297ms 5s396ms 04 1,098,772 0ms 229ms 0ms 2s123ms 2s173ms 4s713ms 05 1,094,945 0ms 254ms 0ms 2s152ms 2s251ms 4s798ms 06 1,098,756 0ms 237ms 0ms 2s75ms 2s222ms 4s924ms 07 1,099,523 0ms 233ms 0ms 2s30ms 2s113ms 4s636ms 08 1,094,107 0ms 268ms 0ms 2s104ms 2s184ms 4s857ms 09 1,094,495 0ms 932ms 0ms 2s71ms 2s178ms 5s438ms 10 1,100,829 0ms 245ms 0ms 2s98ms 2s225ms 4s698ms 11 1,094,209 0ms 242ms 0ms 2s148ms 2s204ms 4s881ms 12 1,085,860 0ms 640ms 0ms 2s45ms 2s129ms 5s668ms 13 1,092,342 0ms 257ms 0ms 2s73ms 2s114ms 5s364ms 14 1,093,455 0ms 227ms 0ms 2s104ms 2s204ms 5s13ms 15 1,100,751 0ms 799ms 0ms 2s73ms 2s229ms 4s19ms 16 1,090,435 0ms 235ms 0ms 2s194ms 2s221ms 4s798ms 17 1,097,642 0ms 238ms 0ms 2s127ms 2s189ms 4s603ms 18 1,089,098 0ms 234ms 0ms 2s136ms 2s188ms 5s441ms 19 1,082,380 0ms 238ms 0ms 2s126ms 2s236ms 4s891ms 20 166,819 0ms 233ms 0ms 938ms 2s43ms 5s95ms 21 48,766 0ms 294ms 0ms 274ms 300ms 3s186ms 22 549,193 0ms 238ms 0ms 2s130ms 2s169ms 3s253ms 23 1,089,777 0ms 230ms 0ms 2s196ms 2s229ms 4s298ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 11 00 316,279 0 0ms 761ms 794ms 834ms 01 314,120 0 0ms 734ms 788ms 919ms 02 314,539 0 0ms 716ms 800ms 878ms 03 316,836 0 0ms 691ms 815ms 893ms 04 315,038 0 0ms 754ms 793ms 850ms 05 313,963 0 0ms 762ms 819ms 844ms 06 315,076 0 0ms 752ms 794ms 853ms 07 315,314 0 0ms 718ms 793ms 833ms 08 313,800 0 0ms 756ms 788ms 848ms 09 313,936 0 0ms 733ms 757ms 832ms 10 315,685 0 0ms 706ms 721ms 753ms 11 313,835 0 0ms 689ms 707ms 727ms 12 311,447 0 0ms 695ms 714ms 743ms 13 313,325 0 0ms 687ms 732ms 792ms 14 313,630 0 0ms 735ms 757ms 814ms 15 315,724 0 0ms 750ms 802ms 843ms 16 312,800 0 0ms 761ms 786ms 817ms 17 314,938 0 0ms 724ms 784ms 838ms 18 312,348 0 0ms 763ms 785ms 842ms 19 310,459 0 0ms 733ms 774ms 821ms 20 53,202 0 0ms 251ms 309ms 809ms 21 19,736 0 0ms 237ms 251ms 303ms 22 160,559 0 0ms 641ms 766ms 838ms 23 312,458 0 0ms 757ms 814ms 848ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 11 00 291 80,516 241 0 0ms 367ms 389ms 405ms 01 88 79,414 242 0 0ms 367ms 392ms 431ms 02 88 79,473 240 0 0ms 359ms 372ms 410ms 03 88 79,610 241 0 0ms 363ms 377ms 402ms 04 88 79,602 241 0 0ms 368ms 380ms 396ms 05 88 79,516 241 0 0ms 364ms 373ms 396ms 06 88 79,538 242 0 0ms 364ms 372ms 396ms 07 88 79,577 240 0 0ms 362ms 373ms 389ms 08 88 79,568 241 0 0ms 371ms 382ms 394ms 09 88 79,543 241 0 0ms 363ms 374ms 397ms 10 88 79,647 241 0 0ms 362ms 373ms 400ms 11 88 79,448 241 0 0ms 366ms 380ms 395ms 12 87 79,467 241 0 0ms 368ms 377ms 401ms 13 88 79,469 241 0 0ms 362ms 376ms 391ms 14 88 79,513 241 0 0ms 363ms 371ms 399ms 15 88 79,464 241 0 0ms 369ms 378ms 400ms 16 184 79,559 242 0 0ms 365ms 383ms 400ms 17 223 79,580 240 0 0ms 367ms 374ms 396ms 18 300 79,574 241 0 0ms 367ms 376ms 405ms 19 315 79,617 242 0 0ms 368ms 379ms 424ms 20 448 9,372 266 0 0ms 2ms 9ms 369ms 21 242 55 236 0 5ms 2ms 7ms 22ms 22 116 37,211 194 0 0ms 338ms 373ms 389ms 23 88 79,673 241 0 0ms 366ms 378ms 400ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 11 00 637,922 1,093,356 1.71 98.27% 01 644,891 1,095,439 1.70 100.21% 02 645,852 1,096,895 1.70 100.25% 03 652,578 1,104,938 1.69 100.85% 04 647,399 1,098,736 1.70 100.34% 05 644,556 1,094,909 1.70 100.12% 06 648,049 1,098,720 1.70 100.47% 07 648,636 1,099,487 1.70 100.51% 08 644,310 1,094,071 1.70 100.07% 09 644,963 1,094,459 1.70 100.17% 10 650,021 1,100,793 1.69 100.62% 11 644,877 1,094,173 1.70 100.23% 12 637,659 1,085,824 1.70 99.47% 13 643,701 1,092,306 1.70 100.15% 14 644,196 1,093,419 1.70 100.15% 15 650,612 1,100,715 1.69 100.85% 16 641,281 1,090,399 1.70 99.75% 17 647,226 1,097,606 1.70 100.32% 18 639,917 1,089,062 1.70 99.58% 19 633,572 1,082,344 1.71 98.85% 20 97,008 166,783 1.72 95.13% 21 29,253 48,730 1.67 94.48% 22 326,685 549,157 1.68 101.91% 23 639,860 1,089,741 1.70 99.54% Day Hour Count Average / Second Aug 11 00 126 0.04/s 01 88 0.02/s 02 74 0.02/s 03 64 0.02/s 04 67 0.02/s 05 75 0.02/s 06 82 0.02/s 07 84 0.02/s 08 89 0.02/s 09 96 0.03/s 10 91 0.03/s 11 91 0.03/s 12 89 0.02/s 13 96 0.03/s 14 92 0.03/s 15 88 0.02/s 16 88 0.02/s 17 91 0.03/s 18 88 0.02/s 19 86 0.02/s 20 98 0.03/s 21 99 0.03/s 22 91 0.03/s 23 91 0.03/s Day Hour Count Average Duration Aug 11 00 126 7m42s 01 88 7m36s 02 74 7m54s 03 64 9m38s 04 67 8m53s 05 75 8m29s 06 82 7m30s 07 84 6m58s 08 89 6m53s 09 96 6m46s 10 91 6m31s 11 91 6m49s 12 89 6m34s 13 96 6m28s 14 92 6m35s 15 88 6m50s 16 88 6m46s 17 91 6m20s 18 88 7m3s 19 86 6m43s 20 98 6m30s 21 99 5m38s 22 91 7m 23 90 7m -
Connections
Established Connections
Key values
- 24 connections Connection Peak
- 2019-08-11 00:30:21 Date
Connections per database
Key values
- pharmisight Main Database
- 2,124 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,124 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-08-11 00:30:21 Date
Histogram of session times
Key values
- 1,446 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,123 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,123 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,123 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 563 buffers Checkpoint Peak
- 2019-08-11 00:27:39 Date
- 56.182 seconds Highest write time
- 0.009 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-08-11 07:17:28 Date
Checkpoints distance
Key values
- 13.45 Mo Distance Peak
- 2019-08-11 00:07:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 11 00 5,877 588.252s 0.01s 588.334s 01 5,080 508.551s 0.024s 508.66s 02 4,939 494.572s 0.013s 494.653s 03 4,859 486.566s 0.017s 486.657s 04 4,941 494.81s 0.013s 494.892s 05 4,838 484.696s 0.018s 484.789s 06 4,911 491.954s 0.014s 492.038s 07 4,872 487.615s 0.015s 487.705s 08 4,771 478.013s 0.015s 478.102s 09 4,863 486.897s 0.009s 486.979s 10 4,797 480.603s 0.009s 480.687s 11 4,865 487.683s 0.013s 487.774s 12 4,918 491.885s 0.009s 491.998s 13 4,960 496.325s 0.011s 496.405s 14 4,909 491.605s 0.01s 491.686s 15 5,126 513.037s 0.013s 513.123s 16 4,950 495.348s 0.016s 495.482s 17 4,954 496.088s 0.023s 496.189s 18 5,270 527.691s 0.013s 527.781s 19 5,295 530.061s 0.015s 530.156s 20 1,428 142.997s 0.015s 143.081s 21 396 39.744s 0.016s 39.841s 22 2,936 293.962s 0.01s 294.054s 23 5,251 525.387s 0.013s 525.503s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 11 00 0 0 5 383 0.001s 0s 01 0 0 4 361 0.005s 0s 02 0 0 4 346 0.001s 0s 03 0 0 5 346 0.003s 0s 04 0 0 4 352 0.001s 0s 05 0 0 4 345 0.002s 0s 06 0 0 4 346 0.002s 0s 07 0 0 4 366 0.002s 0s 08 0 0 5 340 0.002s 0s 09 0 0 4 346 0.001s 0s 10 0 0 4 349 0.002s 0s 11 0 0 4 345 0.002s 0s 12 0 0 4 348 0.001s 0s 13 0 0 4 362 0.001s 0s 14 0 0 5 342 0.002s 0s 15 0 0 4 350 0.002s 0s 16 0 0 4 363 0.004s 0s 17 0 0 4 356 0.009s 0s 18 0 0 5 360 0.002s 0s 19 0 0 4 381 0.001s 0s 20 0 0 1 241 0.002s 0s 21 0 0 0 219 0.002s 0.002s 22 0 0 2 268 0.002s 0.001s 23 0 0 5 334 0.002s 0s Day Hour Count Avg time (sec) Aug 11 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 11 00 6,388.92 kB 6,715.33 kB 01 5,922.00 kB 6,252.50 kB 02 5,765.17 kB 5,965.33 kB 03 5,710.25 kB 5,923.33 kB 04 5,750.17 kB 5,940.08 kB 05 5,705.83 kB 5,904.58 kB 06 5,723.92 kB 5,912.42 kB 07 5,683.42 kB 5,981.00 kB 08 5,667.33 kB 5,841.92 kB 09 5,683.50 kB 5,905.75 kB 10 5,668.25 kB 5,881.00 kB 11 5,708.33 kB 5,878.92 kB 12 5,728.67 kB 5,906.42 kB 13 5,744.67 kB 5,954.67 kB 14 5,753.92 kB 5,934.58 kB 15 5,870.08 kB 6,121.50 kB 16 5,770.33 kB 6,026.50 kB 17 5,778.00 kB 6,034.83 kB 18 5,987.50 kB 6,203.08 kB 19 6,012.50 kB 6,210.75 kB 20 1,263.75 kB 4,296.58 kB 21 189.00 kB 1,376.17 kB 22 3,041.00 kB 4,124.09 kB 23 5,989.17 kB 6,263.92 kB -
Temporary Files
Size of temporary files
Key values
- 4.38 MiB Temp Files size Peak
- 2019-08-11 07:10:01 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2019-08-11 07:10:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 11 00 60 262.97 MiB 4.38 MiB 01 60 262.97 MiB 4.38 MiB 02 60 262.97 MiB 4.38 MiB 03 59 258.59 MiB 4.38 MiB 04 60 262.97 MiB 4.38 MiB 05 60 262.97 MiB 4.38 MiB 06 60 262.97 MiB 4.38 MiB 07 60 262.97 MiB 4.38 MiB 08 60 262.97 MiB 4.38 MiB 09 60 262.97 MiB 4.38 MiB 10 60 262.97 MiB 4.38 MiB 11 60 262.97 MiB 4.38 MiB 12 60 262.97 MiB 4.38 MiB 13 60 262.97 MiB 4.38 MiB 14 60 262.97 MiB 4.38 MiB 15 60 262.97 MiB 4.38 MiB 16 60 262.97 MiB 4.38 MiB 17 60 262.97 MiB 4.38 MiB 18 58 254.20 MiB 4.38 MiB 19 58 254.20 MiB 4.38 MiB 20 7 30.68 MiB 4.38 MiB 21 0 0 0 22 28 122.72 MiB 4.38 MiB 23 60 262.97 MiB 4.38 MiB -
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 (634) Main table analyzed (database pharmisight)
- 668 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 634 pharmisight.public.sym_incoming_batch 13 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 2 pharmisight.public.sym_data_event 1 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 Total 668 Vacuums per table
Key values
- public.sym_outgoing_batch (432) Main table vacuumed on database pharmisight
- 460 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 432 432 pharmisight.public.sym_data_gap 6 6 pharmisight.pg_toast.pg_toast_2619 6 6 pharmisight.pg_catalog.pg_statistic 5 4 pharmisight.public.sym_node_host 5 0 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_sequence 1 0 Total 460 453 Tuples removed per table
Key values
- public.sym_outgoing_batch (435423) Main table with removed tuples on database pharmisight
- 438552 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_outgoing_batch 432 432 435423 0 pharmisight.pg_catalog.pg_statistic 5 4 1707 0 pharmisight.public.sym_incoming_batch 5 5 438 19 pharmisight.pg_toast.pg_toast_2619 6 6 366 0 pharmisight.public.sym_data_gap 6 6 307 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_sequence 1 0 51 0 Total 460 453 438,552 19 Pages removed per table
Key values
- public.sym_incoming_batch (19) Main table with removed pages on database pharmisight
- 19 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_incoming_batch 5 5 438 19 pharmisight.pg_catalog.pg_statistic 5 4 1707 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_outgoing_batch 432 432 435423 0 pharmisight.public.sym_data_gap 6 6 307 0 pharmisight.pg_toast.pg_toast_2619 6 6 366 0 pharmisight.public.sym_sequence 1 0 51 0 Total 460 453 438,552 19 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 11 00 24 34 01 21 32 02 20 30 03 22 32 04 23 31 05 20 32 06 21 31 07 22 32 08 20 30 09 22 32 10 21 30 11 21 33 12 21 31 13 22 30 14 20 31 15 22 32 16 21 32 17 20 30 18 21 32 19 21 27 20 4 8 21 1 0 22 9 14 23 21 22 - 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,829,047 Total read queries
- 7,151,558 Total write queries
Queries by database
Key values
- pharmisight Main database
- 23,752,926 Requests
- 38m53s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 23,814,588 Requests
User Request type Count Duration pharmisight Total 100,821 6s986ms DELETE 27 3ms INSERT 95 42ms OTHERS 1,857 76ms SELECT 98,269 6s841ms TCL 546 17ms UPDATE 27 4ms symmetricds Total 23,814,588 39m1s DELETE 5,737 1m6s INSERT 3,443 1s155ms OTHERS 9,836,536 2m21s SELECT 6,776,492 12m50s TCL 5,462,197 15m40s UPDATE 1,730,183 7m1s tony Total 870 245ms SELECT 870 245ms Duration by user
Key values
- 39m1s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 100,821 6s986ms DELETE 27 3ms INSERT 95 42ms OTHERS 1,857 76ms SELECT 98,269 6s841ms TCL 546 17ms UPDATE 27 4ms symmetricds Total 23,814,588 39m1s DELETE 5,737 1m6s INSERT 3,443 1s155ms OTHERS 9,836,536 2m21s SELECT 6,776,492 12m50s TCL 5,462,197 15m40s UPDATE 1,730,183 7m1s tony Total 870 245ms SELECT 870 245ms Queries by host
Key values
- 10.10.10.1 Main host
- 23,915,409 Requests
- 39m8s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 23,750,226 Requests
- 38m53s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-11 11:02:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 23,482,451 0-1ms duration
Slowest individual queries
Rank Duration Query 1 932ms COMMIT;[ Date: 2019-08-11 09:30:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 799ms COMMIT;[ Date: 2019-08-11 15:10:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 677ms COMMIT;[ Date: 2019-08-11 03:40:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 640ms COMMIT;[ Date: 2019-08-11 12:50:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 571ms COMMIT;[ Date: 2019-08-11 12:00:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 568ms COMMIT;[ Date: 2019-08-11 12:00:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 473ms COMMIT;[ Date: 2019-08-11 03:30:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 416ms COMMIT;[ Date: 2019-08-11 03:40:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 372ms COMMIT;[ Date: 2019-08-11 12:50:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 294ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 21:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 274ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 00:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 268ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 08:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 257ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 13:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 254ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 01:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 254ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 05:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 254ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 09:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 248ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 03:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 245ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 10:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 242ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 11:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 239ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-11 15:00:02 - 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 15m16s 2,712,139 0ms 932ms 0ms COMMIT;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 11 01 125,921 41s468ms 0ms 02 124,841 41s529ms 0ms 03 124,937 40s504ms 0ms 04 125,149 44s14ms 0ms 05 125,118 43s349ms 0ms 06 125,002 41s804ms 0ms 07 125,034 42s341ms 0ms 08 125,070 42s115ms 0ms 09 125,069 40s125ms 0ms 10 125,036 42s747ms 0ms 11 125,178 42s896ms 0ms 12 124,888 43s64ms 0ms 13 124,894 41s550ms 0ms 14 124,809 43s62ms 0ms 15 124,878 41s412ms 0ms 16 124,808 42s906ms 0ms 17 125,065 44s73ms 0ms 18 125,083 44s169ms 0ms 19 125,076 41s818ms 0ms 20 125,167 41s886ms 0ms 21 19,341 4s795ms 0ms 22 5,346 187ms 0ms 23 61,248 21s1ms 0ms 00 125,181 44s107ms 0ms [ User: symmetricds - Total duration: 15m16s - Times executed: 2711867 ]
[ User: pharmisight - Total duration: 15ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m16s - Times executed: 2712139 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-11 09:30:05 Duration: 932ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 15:10:04 Duration: 799ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:40:04 Duration: 677ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6m55s 1,711,996 0ms 19ms 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 11 01 79,383 19s123ms 0ms 02 79,185 19s472ms 0ms 03 79,244 19s371ms 0ms 04 79,382 19s480ms 0ms 05 79,374 19s448ms 0ms 06 79,286 18s926ms 0ms 07 79,308 19s451ms 0ms 08 79,347 19s194ms 0ms 09 79,338 19s390ms 0ms 10 79,314 19s31ms 0ms 11 79,417 19s160ms 0ms 12 79,218 19s194ms 0ms 13 79,237 18s988ms 0ms 14 79,238 19s131ms 0ms 15 79,284 19s227ms 0ms 16 79,234 19s413ms 0ms 17 79,327 19s351ms 0ms 18 79,352 19s93ms 0ms 19 79,343 19s165ms 0ms 20 79,388 18s957ms 0ms 21 9,273 2s58ms 0ms 22 4 1ms 0ms 23 37,076 9s702ms 0ms 00 79,444 19s227ms 0ms [ User: symmetricds - Total duration: 6m55s - Times executed: 1711996 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m55s - Times executed: 1711996 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3271', extract_count = '11742', sent_count = '11741', load_count = '11741', data_row_count = '3', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '2', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '18', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '9', extract_start_time = '2019-08-01 15:36:47.476', transfer_start_time = '2019-08-11 00:26:03.798', 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 = '3', extract_insert_row_count = '1', extract_update_row_count = '2', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195445' 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 = '3590', extract_count = '11876', sent_count = '11875', load_count = '11875', 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 = '19', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 15:15:45.416', transfer_start_time = '2019-08-11 02:19:03.637', 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 = '9195231' 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 = '7646', extract_count = '12931', sent_count = '12930', load_count = '12930', data_row_count = '13', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '8', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '14', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 14:56:43.744', transfer_start_time = '2019-08-11 19:35:07.416', 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 = '13', extract_insert_row_count = '5', extract_update_row_count = '8', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195045' AND node_id = '2';
Date: 2019-08-11 00:27:03 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:20:03 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:36:08 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 5m19s 206,999 0ms 153ms 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 #3
Day Hour Count Duration Avg duration Aug 11 01 9,604 15s74ms 1ms 02 9,604 14s887ms 1ms 03 9,604 15s771ms 1ms 04 9,592 14s700ms 1ms 05 9,559 14s597ms 1ms 06 9,552 14s418ms 1ms 07 9,565 15s142ms 1ms 08 9,592 14s806ms 1ms 09 9,604 15s94ms 1ms 10 9,604 14s870ms 1ms 11 9,604 15s226ms 1ms 12 9,604 15s90ms 1ms 13 9,604 14s982ms 1ms 14 9,604 14s974ms 1ms 15 9,604 14s414ms 1ms 16 9,604 14s454ms 1ms 17 9,604 14s561ms 1ms 18 9,604 14s316ms 1ms 19 9,501 14s486ms 1ms 20 9,370 13s623ms 1ms 21 1,142 1s703ms 1ms 22 124 146ms 1ms 23 4,548 7s558ms 1ms 00 9,602 15s55ms 1ms [ User: symmetricds - Total duration: 5m19s - Times executed: 206999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m19s - Times executed: 206999 ]
-
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-11 13:00:01 Duration: 153ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:19:04 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:04:00 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3m19s 853,475 0ms 21ms 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 #4
Day Hour Count Duration Avg duration Aug 11 01 39,574 9s125ms 0ms 02 39,475 9s277ms 0ms 03 39,505 9s275ms 0ms 04 39,574 9s334ms 0ms 05 39,570 9s264ms 0ms 06 39,529 9s170ms 0ms 07 39,537 9s327ms 0ms 08 39,559 9s272ms 0ms 09 39,553 9s285ms 0ms 10 39,539 9s293ms 0ms 11 39,591 9s254ms 0ms 12 39,490 9s309ms 0ms 13 39,503 9s41ms 0ms 14 39,503 9s253ms 0ms 15 39,527 9s212ms 0ms 16 39,500 9s405ms 0ms 17 39,546 9s174ms 0ms 18 39,556 9s270ms 0ms 19 39,554 9s219ms 0ms 20 39,573 9s10ms 0ms 21 4,625 990ms 0ms 22 4 0ms 0ms 23 18,484 4s692ms 0ms 00 39,604 9s199ms 0ms [ User: symmetricds - Total duration: 3m19s - Times executed: 853475 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m19s - Times executed: 853475 ]
-
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 = '9195645' 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 = '9195343' 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 = '9194559' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-11 17:17:10 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:30:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:23:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m48s 7,053,406 0ms 15ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 11 01 321,193 4s898ms 0ms 02 325,544 5s23ms 0ms 03 326,068 5s62ms 0ms 04 329,278 5s83ms 0ms 05 326,649 4s987ms 0ms 06 325,142 4s943ms 0ms 07 326,717 5s26ms 0ms 08 326,959 4s976ms 0ms 09 324,629 5s11ms 0ms 10 324,818 4s927ms 0ms 11 327,388 4s969ms 0ms 12 324,884 5s6ms 0ms 13 321,273 4s923ms 0ms 14 324,026 5s47ms 0ms 15 324,434 4s959ms 0ms 16 327,647 5s5ms 0ms 17 322,976 4s975ms 0ms 18 325,952 5s5ms 0ms 19 322,348 4s911ms 0ms 20 319,361 4s828ms 0ms 21 50,735 766ms 0ms 22 16,872 284ms 0ms 23 165,869 2s770ms 0ms 00 322,644 4s987ms 0ms [ User: symmetricds - Total duration: 1m48s - Times executed: 7052790 ]
[ User: pharmisight - Total duration: 29ms - Times executed: 616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 7053406 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-11 19:21:03 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:35:06 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:05:11 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m34s 76,512 0ms 20ms 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 #6
Day Hour Count Duration Avg duration Aug 11 01 3,200 3s669ms 1ms 02 3,200 4s220ms 1ms 03 3,200 4s138ms 1ms 04 3,200 4s152ms 1ms 05 3,200 4s167ms 1ms 06 3,200 3s903ms 1ms 07 3,200 3s575ms 1ms 08 3,197 3s805ms 1ms 09 3,180 3s919ms 1ms 10 3,208 3s844ms 1ms 11 3,140 3s835ms 1ms 12 3,178 3s953ms 1ms 13 3,180 3s848ms 1ms 14 3,182 3s805ms 1ms 15 3,181 3s773ms 1ms 16 3,196 3s880ms 1ms 17 3,200 3s839ms 1ms 18 3,200 3s766ms 1ms 19 3,200 4s154ms 1ms 20 3,200 4s2ms 1ms 21 3,200 4s225ms 1ms 22 3,180 4s141ms 1ms 23 3,200 4s150ms 1ms 00 3,090 3s891ms 1ms [ User: symmetricds - Total duration: 1m34s - Times executed: 76512 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m34s - Times executed: 76512 ]
-
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-11 02:50:58 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:08:59 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:39:04 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 51s440ms 1,932 15ms 83ms 26ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 11 01 81 2s417ms 29ms 02 81 2s140ms 26ms 03 81 2s152ms 26ms 04 81 1s983ms 24ms 05 81 1s872ms 23ms 06 81 2s307ms 28ms 07 81 2s73ms 25ms 08 81 2s15ms 24ms 09 81 2s174ms 26ms 10 81 2s236ms 27ms 11 81 1s924ms 23ms 12 81 2s276ms 28ms 13 81 1s872ms 23ms 14 81 2s482ms 30ms 15 81 2s271ms 28ms 16 81 1s462ms 18ms 17 81 2s226ms 27ms 18 81 2s116ms 26ms 19 81 2s518ms 31ms 20 81 2s300ms 28ms 21 81 2s250ms 27ms 22 81 1s990ms 24ms 23 69 2s274ms 32ms 00 81 2s98ms 25ms [ User: symmetricds - Total duration: 51s440ms - Times executed: 1932 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s440ms - Times executed: 1932 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104879180' AND '104884180' AND create_time < '2019-08-10 11:00:00.003' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104879180' AND '104884180') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104879180' AND '104884180' 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-10 03:00:00' 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 '104739152' AND '104744152' AND create_time < '2019-08-10 18:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-11 11:00:01 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:00:00 Duration: 68ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 40s583ms 4,084,497 0ms 11ms 0ms SELECT ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 11 01 188,183 1s858ms 0ms 02 188,571 1s880ms 0ms 03 188,809 1s888ms 0ms 04 190,018 1s890ms 0ms 05 189,134 1s910ms 0ms 06 188,542 1s853ms 0ms 07 189,086 1s890ms 0ms 08 189,206 1s872ms 0ms 09 188,426 1s878ms 0ms 10 188,455 1s839ms 0ms 11 189,420 1s849ms 0ms 12 188,386 1s859ms 0ms 13 187,204 1s829ms 0ms 14 188,122 1s891ms 0ms 15 188,307 1s874ms 0ms 16 189,322 1s868ms 0ms 17 187,871 1s861ms 0ms 18 188,873 1s884ms 0ms 19 187,672 1s849ms 0ms 20 186,717 1s807ms 0ms 21 26,899 256ms 0ms 22 6,312 74ms 0ms 23 93,099 1s8ms 0ms 00 187,863 1s904ms 0ms [ User: symmetricds - Total duration: 40s583ms - Times executed: 4084497 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s583ms - Times executed: 4084497 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-11 00:43:04 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:50:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:04:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 39s12ms 878,439 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 #9
Day Hour Count Duration Avg duration Aug 11 01 40,652 1s786ms 0ms 02 40,549 1s826ms 0ms 03 40,585 1s822ms 0ms 04 40,651 1s812ms 0ms 05 40,643 1s826ms 0ms 06 40,603 1s787ms 0ms 07 40,614 1s825ms 0ms 08 40,633 1s789ms 0ms 09 40,627 1s823ms 0ms 10 40,619 1s790ms 0ms 11 40,669 1s773ms 0ms 12 40,570 1s813ms 0ms 13 40,577 1s765ms 0ms 14 40,579 1s801ms 0ms 15 40,602 1s800ms 0ms 16 40,577 1s825ms 0ms 17 40,623 1s789ms 0ms 18 40,632 1s803ms 0ms 19 40,630 1s787ms 0ms 20 40,651 1s759ms 0ms 21 5,383 228ms 0ms 22 720 40ms 0ms 23 19,370 939ms 0ms 00 40,680 1s794ms 0ms [ User: symmetricds - Total duration: 39s12ms - Times executed: 878439 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s12ms - Times executed: 878439 ]
-
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 = '0';
-
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-11 15:30:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 01:08:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 14:44:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 31s577ms 493,929 0ms 4ms 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 11 01 21,392 1s370ms 0ms 02 23,210 1s461ms 0ms 03 23,327 1s493ms 0ms 04 24,252 1s529ms 0ms 05 23,403 1s455ms 0ms 06 22,976 1s459ms 0ms 07 23,476 1s465ms 0ms 08 23,542 1s453ms 0ms 09 22,762 1s438ms 0ms 10 22,844 1s452ms 0ms 11 23,608 1s470ms 0ms 12 22,967 1s478ms 0ms 13 21,767 1s421ms 0ms 14 22,769 1s506ms 0ms 15 22,858 1s449ms 0ms 16 23,978 1s501ms 0ms 17 22,220 1s467ms 0ms 18 23,204 1s504ms 0ms 19 22,002 1s392ms 0ms 20 20,945 1s378ms 0ms 21 1,968 132ms 0ms 22 4 0ms 0ms 23 12,413 845ms 0ms 00 22,042 1s448ms 0ms [ User: symmetricds - Total duration: 31s577ms - Times executed: 493929 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s577ms - Times executed: 493929 ]
-
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 = '9196207' 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 = '9196335' 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 = '9196471' AND node_id = '2';
Date: 2019-08-11 02:36:07 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:36:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:17:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 17s213ms 2,712,128 0ms 10ms 0ms BEGIN;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 11 01 125,923 787ms 0ms 02 124,841 787ms 0ms 03 124,937 793ms 0ms 04 125,148 813ms 0ms 05 125,116 801ms 0ms 06 124,999 782ms 0ms 07 125,032 805ms 0ms 08 125,070 783ms 0ms 09 125,067 790ms 0ms 10 125,035 772ms 0ms 11 125,181 782ms 0ms 12 124,887 789ms 0ms 13 124,890 766ms 0ms 14 124,808 795ms 0ms 15 124,880 793ms 0ms 16 124,805 813ms 0ms 17 125,063 799ms 0ms 18 125,083 783ms 0ms 19 125,081 795ms 0ms 20 125,169 787ms 0ms 21 19,341 118ms 0ms 22 5,346 44ms 0ms 23 61,248 424ms 0ms 00 125,178 800ms 0ms [ User: symmetricds - Total duration: 17s211ms - Times executed: 2711855 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s213ms - Times executed: 2712128 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-11 03:47:04 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 21:40:04 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:48:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 16s201ms 1,357,636 0ms 4ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 11 01 61,400 703ms 0ms 02 63,117 750ms 0ms 03 63,262 746ms 0ms 04 64,262 756ms 0ms 05 63,407 753ms 0ms 06 62,933 736ms 0ms 07 63,446 756ms 0ms 08 63,531 742ms 0ms 09 62,748 734ms 0ms 10 62,817 745ms 0ms 11 63,633 748ms 0ms 12 62,890 764ms 0ms 13 61,705 745ms 0ms 14 62,705 760ms 0ms 15 62,816 757ms 0ms 16 63,911 773ms 0ms 17 62,197 753ms 0ms 18 63,193 760ms 0ms 19 61,990 743ms 0ms 20 60,950 717ms 0ms 21 6,971 81ms 0ms 22 379 9ms 0ms 23 31,295 407ms 0ms 00 62,078 753ms 0ms [ User: symmetricds - Total duration: 16s201ms - Times executed: 1357636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s201ms - Times executed: 1357636 ]
-
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-11 11:50:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 21:38:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 14:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 15s695ms 1,357,607 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 11 01 61,399 678ms 0ms 02 63,116 726ms 0ms 03 63,263 726ms 0ms 04 64,258 730ms 0ms 05 63,403 733ms 0ms 06 62,935 716ms 0ms 07 63,443 731ms 0ms 08 63,530 722ms 0ms 09 62,743 717ms 0ms 10 62,813 721ms 0ms 11 63,630 724ms 0ms 12 62,890 737ms 0ms 13 61,702 712ms 0ms 14 62,703 733ms 0ms 15 62,815 734ms 0ms 16 63,911 746ms 0ms 17 62,197 728ms 0ms 18 63,192 742ms 0ms 19 61,988 721ms 0ms 20 60,952 692ms 0ms 21 6,971 78ms 0ms 22 380 4ms 0ms 23 31,295 395ms 0ms 00 62,078 736ms 0ms [ User: symmetricds - Total duration: 15s695ms - Times executed: 1357607 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s695ms - Times executed: 1357607 ]
-
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-11 06:20:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 23:18:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:04:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 14s413ms 1,907 5ms 21ms 7ms 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 #14
Day Hour Count Duration Avg duration Aug 11 01 81 712ms 8ms 02 81 661ms 8ms 03 81 614ms 7ms 04 81 606ms 7ms 05 81 602ms 7ms 06 81 630ms 7ms 07 81 593ms 7ms 08 81 692ms 8ms 09 81 681ms 8ms 10 81 636ms 7ms 11 81 582ms 7ms 12 81 595ms 7ms 13 81 568ms 7ms 14 81 618ms 7ms 15 81 564ms 6ms 16 81 602ms 7ms 17 81 605ms 7ms 18 81 579ms 7ms 19 81 620ms 7ms 20 81 575ms 7ms 21 81 591ms 7ms 22 77 547ms 7ms 23 48 348ms 7ms 00 81 581ms 7ms [ User: symmetricds - Total duration: 14s413ms - Times executed: 1907 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s413ms - Times executed: 1907 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104934191' AND '104939191' AND data_id < '105133381' AND create_time < '2019-08-10 00:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104934191' AND '104939191');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105049214' AND '105054214' AND data_id < '105133465' AND create_time < '2019-08-10 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105049214' AND '105054214');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105054215' AND '105059215' AND data_id < '105133465' AND create_time < '2019-08-10 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105054215' AND '105059215');
Date: 2019-08-11 00:00:03 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 9s649ms 17,183 0ms 6ms 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 #15
Day Hour Count Duration Avg duration Aug 11 01 719 374ms 0ms 02 716 393ms 0ms 03 716 392ms 0ms 04 718 391ms 0ms 05 714 390ms 0ms 06 716 390ms 0ms 07 716 393ms 0ms 08 714 398ms 0ms 09 716 407ms 0ms 10 716 388ms 0ms 11 716 399ms 0ms 12 716 413ms 0ms 13 716 390ms 0ms 14 716 402ms 0ms 15 716 395ms 0ms 16 716 401ms 0ms 17 714 413ms 0ms 18 714 402ms 0ms 19 716 403ms 0ms 20 716 398ms 0ms 21 716 438ms 0ms 22 716 435ms 0ms 23 718 438ms 0ms 00 716 396ms 0ms [ User: symmetricds - Total duration: 9s649ms - Times executed: 17183 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s649ms - Times executed: 17183 ]
-
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-11 20:59:42 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:15:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 16:52:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5s882ms 24 227ms 294ms 245ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 11 01 1 274ms 274ms 02 1 254ms 254ms 03 1 238ms 238ms 04 1 248ms 248ms 05 1 229ms 229ms 06 1 254ms 254ms 07 1 237ms 237ms 08 1 233ms 233ms 09 1 268ms 268ms 10 1 254ms 254ms 11 1 245ms 245ms 12 1 242ms 242ms 13 1 232ms 232ms 14 1 257ms 257ms 15 1 227ms 227ms 16 1 239ms 239ms 17 1 235ms 235ms 18 1 238ms 238ms 19 1 234ms 234ms 20 1 238ms 238ms 21 1 233ms 233ms 22 1 294ms 294ms 23 1 238ms 238ms 00 1 230ms 230ms [ User: symmetricds - Total duration: 5s882ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s882ms - 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-11 21:00:03 Duration: 294ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:03 Duration: 274ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:00:03 Duration: 268ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 3s773ms 1,021 1ms 7ms 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 #17
Day Hour Count Duration Avg duration Aug 11 01 32 118ms 3ms 02 34 135ms 3ms 03 36 135ms 3ms 04 34 130ms 3ms 05 38 133ms 3ms 06 37 137ms 3ms 07 43 152ms 3ms 08 42 163ms 3ms 09 49 185ms 3ms 10 53 194ms 3ms 11 50 192ms 3ms 12 47 165ms 3ms 13 51 187ms 3ms 14 54 200ms 3ms 15 51 184ms 3ms 16 51 176ms 3ms 17 50 186ms 3ms 18 52 189ms 3ms 19 50 179ms 3ms 20 45 155ms 3ms 21 23 87ms 3ms 22 24 89ms 3ms 23 33 131ms 3ms 00 42 161ms 3ms [ User: symmetricds - Total duration: 3s773ms - Times executed: 1021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s773ms - Times executed: 1021 ]
-
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-11 17:58:09 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:57:58 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:29:59 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 3s343ms 536 4ms 15ms 6ms 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 #18
Day Hour Count Duration Avg duration Aug 11 01 131 892ms 6ms 02 19 147ms 7ms 03 18 155ms 8ms 04 19 139ms 7ms 05 18 119ms 6ms 06 18 136ms 7ms 07 19 113ms 5ms 08 19 108ms 5ms 09 19 108ms 5ms 10 19 95ms 5ms 11 19 99ms 5ms 12 19 97ms 5ms 13 19 94ms 4ms 14 19 101ms 5ms 15 19 94ms 4ms 16 19 96ms 5ms 17 18 89ms 4ms 18 15 107ms 7ms 19 19 106ms 5ms 20 11 63ms 5ms 21 19 109ms 5ms 22 3 23ms 7ms 23 19 148ms 7ms 00 19 92ms 4ms [ User: symmetricds - Total duration: 3s135ms - Times executed: 491 ]
[ User: pharmisight - Total duration: 207ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s343ms - Times executed: 536 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_file_trigger' 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 = 'alerts' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-11 00:00:01 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:02 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 2s705ms 50,372 0ms 4ms 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 #19
Day Hour Count Duration Avg duration Aug 11 01 3,084 166ms 0ms 02 2,056 89ms 0ms 03 2,056 98ms 0ms 04 2,056 105ms 0ms 05 2,056 115ms 0ms 06 2,056 121ms 0ms 07 2,056 110ms 0ms 08 2,056 110ms 0ms 09 2,056 104ms 0ms 10 2,056 122ms 0ms 11 2,056 102ms 0ms 12 2,056 118ms 0ms 13 2,056 104ms 0ms 14 2,056 123ms 0ms 15 2,056 108ms 0ms 16 2,056 89ms 0ms 17 2,056 118ms 0ms 18 2,056 118ms 0ms 19 2,056 126ms 0ms 20 2,056 109ms 0ms 21 2,056 116ms 0ms 22 2,056 101ms 0ms 23 2,056 106ms 0ms 00 2,056 114ms 0ms [ User: pharmisight - Total duration: 2s705ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s705ms - Times executed: 50372 ]
-
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 = '3449' 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 = '159' 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 = '32994512' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-11 02:20:01 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2s404ms 44,688 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 #20
Day Hour Count Duration Avg duration Aug 11 01 2,736 147ms 0ms 02 1,824 80ms 0ms 03 1,824 85ms 0ms 04 1,824 95ms 0ms 05 1,824 104ms 0ms 06 1,824 104ms 0ms 07 1,824 98ms 0ms 08 1,824 97ms 0ms 09 1,824 93ms 0ms 10 1,824 110ms 0ms 11 1,824 90ms 0ms 12 1,824 105ms 0ms 13 1,824 91ms 0ms 14 1,824 110ms 0ms 15 1,824 96ms 0ms 16 1,824 79ms 0ms 17 1,824 104ms 0ms 18 1,824 106ms 0ms 19 1,824 113ms 0ms 20 1,824 97ms 0ms 21 1,824 102ms 0ms 22 1,824 90ms 0ms 23 1,824 95ms 0ms 00 1,824 102ms 0ms [ User: pharmisight - Total duration: 2s404ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s404ms - Times executed: 44688 ]
-
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 = '37' 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 = '2857' 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 = '3499' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7,053,406 1m48s 0ms 15ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 11 01 321,193 4s898ms 0ms 02 325,544 5s23ms 0ms 03 326,068 5s62ms 0ms 04 329,278 5s83ms 0ms 05 326,649 4s987ms 0ms 06 325,142 4s943ms 0ms 07 326,717 5s26ms 0ms 08 326,959 4s976ms 0ms 09 324,629 5s11ms 0ms 10 324,818 4s927ms 0ms 11 327,388 4s969ms 0ms 12 324,884 5s6ms 0ms 13 321,273 4s923ms 0ms 14 324,026 5s47ms 0ms 15 324,434 4s959ms 0ms 16 327,647 5s5ms 0ms 17 322,976 4s975ms 0ms 18 325,952 5s5ms 0ms 19 322,348 4s911ms 0ms 20 319,361 4s828ms 0ms 21 50,735 766ms 0ms 22 16,872 284ms 0ms 23 165,869 2s770ms 0ms 00 322,644 4s987ms 0ms [ User: symmetricds - Total duration: 1m48s - Times executed: 7052790 ]
[ User: pharmisight - Total duration: 29ms - Times executed: 616 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m48s - Times executed: 7053406 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-11 19:21:03 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:35:06 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:05:11 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4,084,497 40s583ms 0ms 11ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 11 01 188,183 1s858ms 0ms 02 188,571 1s880ms 0ms 03 188,809 1s888ms 0ms 04 190,018 1s890ms 0ms 05 189,134 1s910ms 0ms 06 188,542 1s853ms 0ms 07 189,086 1s890ms 0ms 08 189,206 1s872ms 0ms 09 188,426 1s878ms 0ms 10 188,455 1s839ms 0ms 11 189,420 1s849ms 0ms 12 188,386 1s859ms 0ms 13 187,204 1s829ms 0ms 14 188,122 1s891ms 0ms 15 188,307 1s874ms 0ms 16 189,322 1s868ms 0ms 17 187,871 1s861ms 0ms 18 188,873 1s884ms 0ms 19 187,672 1s849ms 0ms 20 186,717 1s807ms 0ms 21 26,899 256ms 0ms 22 6,312 74ms 0ms 23 93,099 1s8ms 0ms 00 187,863 1s904ms 0ms [ User: symmetricds - Total duration: 40s583ms - Times executed: 4084497 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s583ms - Times executed: 4084497 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-11 00:43:04 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:50:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:04:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2,712,139 15m16s 0ms 932ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 11 01 125,921 41s468ms 0ms 02 124,841 41s529ms 0ms 03 124,937 40s504ms 0ms 04 125,149 44s14ms 0ms 05 125,118 43s349ms 0ms 06 125,002 41s804ms 0ms 07 125,034 42s341ms 0ms 08 125,070 42s115ms 0ms 09 125,069 40s125ms 0ms 10 125,036 42s747ms 0ms 11 125,178 42s896ms 0ms 12 124,888 43s64ms 0ms 13 124,894 41s550ms 0ms 14 124,809 43s62ms 0ms 15 124,878 41s412ms 0ms 16 124,808 42s906ms 0ms 17 125,065 44s73ms 0ms 18 125,083 44s169ms 0ms 19 125,076 41s818ms 0ms 20 125,167 41s886ms 0ms 21 19,341 4s795ms 0ms 22 5,346 187ms 0ms 23 61,248 21s1ms 0ms 00 125,181 44s107ms 0ms [ User: symmetricds - Total duration: 15m16s - Times executed: 2711867 ]
[ User: pharmisight - Total duration: 15ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m16s - Times executed: 2712139 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-11 09:30:05 Duration: 932ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 15:10:04 Duration: 799ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:40:04 Duration: 677ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2,712,128 17s213ms 0ms 10ms 0ms BEGIN;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 11 01 125,923 787ms 0ms 02 124,841 787ms 0ms 03 124,937 793ms 0ms 04 125,148 813ms 0ms 05 125,116 801ms 0ms 06 124,999 782ms 0ms 07 125,032 805ms 0ms 08 125,070 783ms 0ms 09 125,067 790ms 0ms 10 125,035 772ms 0ms 11 125,181 782ms 0ms 12 124,887 789ms 0ms 13 124,890 766ms 0ms 14 124,808 795ms 0ms 15 124,880 793ms 0ms 16 124,805 813ms 0ms 17 125,063 799ms 0ms 18 125,083 783ms 0ms 19 125,081 795ms 0ms 20 125,169 787ms 0ms 21 19,341 118ms 0ms 22 5,346 44ms 0ms 23 61,248 424ms 0ms 00 125,178 800ms 0ms [ User: symmetricds - Total duration: 17s211ms - Times executed: 2711855 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s213ms - Times executed: 2712128 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-11 03:47:04 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 21:40:04 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:48:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1,711,996 6m55s 0ms 19ms 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 11 01 79,383 19s123ms 0ms 02 79,185 19s472ms 0ms 03 79,244 19s371ms 0ms 04 79,382 19s480ms 0ms 05 79,374 19s448ms 0ms 06 79,286 18s926ms 0ms 07 79,308 19s451ms 0ms 08 79,347 19s194ms 0ms 09 79,338 19s390ms 0ms 10 79,314 19s31ms 0ms 11 79,417 19s160ms 0ms 12 79,218 19s194ms 0ms 13 79,237 18s988ms 0ms 14 79,238 19s131ms 0ms 15 79,284 19s227ms 0ms 16 79,234 19s413ms 0ms 17 79,327 19s351ms 0ms 18 79,352 19s93ms 0ms 19 79,343 19s165ms 0ms 20 79,388 18s957ms 0ms 21 9,273 2s58ms 0ms 22 4 1ms 0ms 23 37,076 9s702ms 0ms 00 79,444 19s227ms 0ms [ User: symmetricds - Total duration: 6m55s - Times executed: 1711996 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m55s - Times executed: 1711996 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3271', extract_count = '11742', sent_count = '11741', load_count = '11741', data_row_count = '3', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '2', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '18', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '9', extract_start_time = '2019-08-01 15:36:47.476', transfer_start_time = '2019-08-11 00:26:03.798', 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 = '3', extract_insert_row_count = '1', extract_update_row_count = '2', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195445' 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 = '3590', extract_count = '11876', sent_count = '11875', load_count = '11875', 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 = '19', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 15:15:45.416', transfer_start_time = '2019-08-11 02:19:03.637', 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 = '9195231' 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 = '7646', extract_count = '12931', sent_count = '12930', load_count = '12930', data_row_count = '13', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '8', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '14', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 14:56:43.744', transfer_start_time = '2019-08-11 19:35:07.416', 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 = '13', extract_insert_row_count = '5', extract_update_row_count = '8', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195045' AND node_id = '2';
Date: 2019-08-11 00:27:03 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:20:03 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:36:08 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1,357,636 16s201ms 0ms 4ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 11 01 61,400 703ms 0ms 02 63,117 750ms 0ms 03 63,262 746ms 0ms 04 64,262 756ms 0ms 05 63,407 753ms 0ms 06 62,933 736ms 0ms 07 63,446 756ms 0ms 08 63,531 742ms 0ms 09 62,748 734ms 0ms 10 62,817 745ms 0ms 11 63,633 748ms 0ms 12 62,890 764ms 0ms 13 61,705 745ms 0ms 14 62,705 760ms 0ms 15 62,816 757ms 0ms 16 63,911 773ms 0ms 17 62,197 753ms 0ms 18 63,193 760ms 0ms 19 61,990 743ms 0ms 20 60,950 717ms 0ms 21 6,971 81ms 0ms 22 379 9ms 0ms 23 31,295 407ms 0ms 00 62,078 753ms 0ms [ User: symmetricds - Total duration: 16s201ms - Times executed: 1357636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s201ms - Times executed: 1357636 ]
-
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-11 11:50:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 21:38:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 14:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1,357,607 15s695ms 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 11 01 61,399 678ms 0ms 02 63,116 726ms 0ms 03 63,263 726ms 0ms 04 64,258 730ms 0ms 05 63,403 733ms 0ms 06 62,935 716ms 0ms 07 63,443 731ms 0ms 08 63,530 722ms 0ms 09 62,743 717ms 0ms 10 62,813 721ms 0ms 11 63,630 724ms 0ms 12 62,890 737ms 0ms 13 61,702 712ms 0ms 14 62,703 733ms 0ms 15 62,815 734ms 0ms 16 63,911 746ms 0ms 17 62,197 728ms 0ms 18 63,192 742ms 0ms 19 61,988 721ms 0ms 20 60,952 692ms 0ms 21 6,971 78ms 0ms 22 380 4ms 0ms 23 31,295 395ms 0ms 00 62,078 736ms 0ms [ User: symmetricds - Total duration: 15s695ms - Times executed: 1357607 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s695ms - Times executed: 1357607 ]
-
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-11 06:20:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 23:18:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:04:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 878,439 39s12ms 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 11 01 40,652 1s786ms 0ms 02 40,549 1s826ms 0ms 03 40,585 1s822ms 0ms 04 40,651 1s812ms 0ms 05 40,643 1s826ms 0ms 06 40,603 1s787ms 0ms 07 40,614 1s825ms 0ms 08 40,633 1s789ms 0ms 09 40,627 1s823ms 0ms 10 40,619 1s790ms 0ms 11 40,669 1s773ms 0ms 12 40,570 1s813ms 0ms 13 40,577 1s765ms 0ms 14 40,579 1s801ms 0ms 15 40,602 1s800ms 0ms 16 40,577 1s825ms 0ms 17 40,623 1s789ms 0ms 18 40,632 1s803ms 0ms 19 40,630 1s787ms 0ms 20 40,651 1s759ms 0ms 21 5,383 228ms 0ms 22 720 40ms 0ms 23 19,370 939ms 0ms 00 40,680 1s794ms 0ms [ User: symmetricds - Total duration: 39s12ms - Times executed: 878439 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s12ms - Times executed: 878439 ]
-
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 = '0';
-
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-11 15:30:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 01:08:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 14:44:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 853,475 3m19s 0ms 21ms 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 11 01 39,574 9s125ms 0ms 02 39,475 9s277ms 0ms 03 39,505 9s275ms 0ms 04 39,574 9s334ms 0ms 05 39,570 9s264ms 0ms 06 39,529 9s170ms 0ms 07 39,537 9s327ms 0ms 08 39,559 9s272ms 0ms 09 39,553 9s285ms 0ms 10 39,539 9s293ms 0ms 11 39,591 9s254ms 0ms 12 39,490 9s309ms 0ms 13 39,503 9s41ms 0ms 14 39,503 9s253ms 0ms 15 39,527 9s212ms 0ms 16 39,500 9s405ms 0ms 17 39,546 9s174ms 0ms 18 39,556 9s270ms 0ms 19 39,554 9s219ms 0ms 20 39,573 9s10ms 0ms 21 4,625 990ms 0ms 22 4 0ms 0ms 23 18,484 4s692ms 0ms 00 39,604 9s199ms 0ms [ User: symmetricds - Total duration: 3m19s - Times executed: 853475 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m19s - Times executed: 853475 ]
-
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 = '9195645' 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 = '9195343' 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 = '9194559' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-11 17:17:10 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:30:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:23:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 493,929 31s577ms 0ms 4ms 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 11 01 21,392 1s370ms 0ms 02 23,210 1s461ms 0ms 03 23,327 1s493ms 0ms 04 24,252 1s529ms 0ms 05 23,403 1s455ms 0ms 06 22,976 1s459ms 0ms 07 23,476 1s465ms 0ms 08 23,542 1s453ms 0ms 09 22,762 1s438ms 0ms 10 22,844 1s452ms 0ms 11 23,608 1s470ms 0ms 12 22,967 1s478ms 0ms 13 21,767 1s421ms 0ms 14 22,769 1s506ms 0ms 15 22,858 1s449ms 0ms 16 23,978 1s501ms 0ms 17 22,220 1s467ms 0ms 18 23,204 1s504ms 0ms 19 22,002 1s392ms 0ms 20 20,945 1s378ms 0ms 21 1,968 132ms 0ms 22 4 0ms 0ms 23 12,413 845ms 0ms 00 22,042 1s448ms 0ms [ User: symmetricds - Total duration: 31s577ms - Times executed: 493929 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s577ms - Times executed: 493929 ]
-
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 = '9196207' 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 = '9196335' 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 = '9196471' AND node_id = '2';
Date: 2019-08-11 02:36:07 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:36:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:17:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 206,999 5m19s 0ms 153ms 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 11 01 9,604 15s74ms 1ms 02 9,604 14s887ms 1ms 03 9,604 15s771ms 1ms 04 9,592 14s700ms 1ms 05 9,559 14s597ms 1ms 06 9,552 14s418ms 1ms 07 9,565 15s142ms 1ms 08 9,592 14s806ms 1ms 09 9,604 15s94ms 1ms 10 9,604 14s870ms 1ms 11 9,604 15s226ms 1ms 12 9,604 15s90ms 1ms 13 9,604 14s982ms 1ms 14 9,604 14s974ms 1ms 15 9,604 14s414ms 1ms 16 9,604 14s454ms 1ms 17 9,604 14s561ms 1ms 18 9,604 14s316ms 1ms 19 9,501 14s486ms 1ms 20 9,370 13s623ms 1ms 21 1,142 1s703ms 1ms 22 124 146ms 1ms 23 4,548 7s558ms 1ms 00 9,602 15s55ms 1ms [ User: symmetricds - Total duration: 5m19s - Times executed: 206999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m19s - Times executed: 206999 ]
-
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-11 13:00:01 Duration: 153ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:19:04 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:04:00 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 76,512 1m34s 0ms 20ms 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 #12
Day Hour Count Duration Avg duration Aug 11 01 3,200 3s669ms 1ms 02 3,200 4s220ms 1ms 03 3,200 4s138ms 1ms 04 3,200 4s152ms 1ms 05 3,200 4s167ms 1ms 06 3,200 3s903ms 1ms 07 3,200 3s575ms 1ms 08 3,197 3s805ms 1ms 09 3,180 3s919ms 1ms 10 3,208 3s844ms 1ms 11 3,140 3s835ms 1ms 12 3,178 3s953ms 1ms 13 3,180 3s848ms 1ms 14 3,182 3s805ms 1ms 15 3,181 3s773ms 1ms 16 3,196 3s880ms 1ms 17 3,200 3s839ms 1ms 18 3,200 3s766ms 1ms 19 3,200 4s154ms 1ms 20 3,200 4s2ms 1ms 21 3,200 4s225ms 1ms 22 3,180 4s141ms 1ms 23 3,200 4s150ms 1ms 00 3,090 3s891ms 1ms [ User: symmetricds - Total duration: 1m34s - Times executed: 76512 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m34s - Times executed: 76512 ]
-
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-11 02:50:58 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:08:59 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:39:04 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 50,372 2s705ms 0ms 4ms 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 11 01 3,084 166ms 0ms 02 2,056 89ms 0ms 03 2,056 98ms 0ms 04 2,056 105ms 0ms 05 2,056 115ms 0ms 06 2,056 121ms 0ms 07 2,056 110ms 0ms 08 2,056 110ms 0ms 09 2,056 104ms 0ms 10 2,056 122ms 0ms 11 2,056 102ms 0ms 12 2,056 118ms 0ms 13 2,056 104ms 0ms 14 2,056 123ms 0ms 15 2,056 108ms 0ms 16 2,056 89ms 0ms 17 2,056 118ms 0ms 18 2,056 118ms 0ms 19 2,056 126ms 0ms 20 2,056 109ms 0ms 21 2,056 116ms 0ms 22 2,056 101ms 0ms 23 2,056 106ms 0ms 00 2,056 114ms 0ms [ User: pharmisight - Total duration: 2s705ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s705ms - Times executed: 50372 ]
-
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 = '3449' 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 = '159' 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 = '32994512' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-11 02:20:01 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 44,688 2s404ms 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 11 01 2,736 147ms 0ms 02 1,824 80ms 0ms 03 1,824 85ms 0ms 04 1,824 95ms 0ms 05 1,824 104ms 0ms 06 1,824 104ms 0ms 07 1,824 98ms 0ms 08 1,824 97ms 0ms 09 1,824 93ms 0ms 10 1,824 110ms 0ms 11 1,824 90ms 0ms 12 1,824 105ms 0ms 13 1,824 91ms 0ms 14 1,824 110ms 0ms 15 1,824 96ms 0ms 16 1,824 79ms 0ms 17 1,824 104ms 0ms 18 1,824 106ms 0ms 19 1,824 113ms 0ms 20 1,824 97ms 0ms 21 1,824 102ms 0ms 22 1,824 90ms 0ms 23 1,824 95ms 0ms 00 1,824 102ms 0ms [ User: pharmisight - Total duration: 2s404ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s404ms - Times executed: 44688 ]
-
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 = '37' 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 = '2857' 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 = '3499' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 24,993 1s278ms 0ms 4ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 11 01 1,110 62ms 0ms 02 1,044 59ms 0ms 03 1,044 51ms 0ms 04 1,046 54ms 0ms 05 1,042 53ms 0ms 06 1,044 51ms 0ms 07 1,044 52ms 0ms 08 1,038 53ms 0ms 09 1,044 53ms 0ms 10 1,044 49ms 0ms 11 1,044 53ms 0ms 12 1,044 56ms 0ms 13 1,044 52ms 0ms 14 1,044 51ms 0ms 15 1,044 53ms 0ms 16 1,043 53ms 0ms 17 1,048 51ms 0ms 18 1,046 51ms 0ms 19 1,050 51ms 0ms 20 1,050 51ms 0ms 21 993 53ms 0ms 22 990 50ms 0ms 23 1,018 52ms 0ms 00 1,035 51ms 0ms [ User: symmetricds - Total duration: 1s278ms - Times executed: 24993 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s278ms - Times executed: 24993 ]
-
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-11 01:17:57 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:44:24 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:23:58 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 17,250 495ms 0ms 4ms 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 11 01 720 19ms 0ms 02 718 20ms 0ms 03 720 19ms 0ms 04 718 20ms 0ms 05 718 19ms 0ms 06 718 19ms 0ms 07 720 20ms 0ms 08 718 19ms 0ms 09 720 23ms 0ms 10 716 19ms 0ms 11 718 20ms 0ms 12 720 19ms 0ms 13 716 24ms 0ms 14 718 19ms 0ms 15 720 20ms 0ms 16 718 20ms 0ms 17 720 20ms 0ms 18 718 20ms 0ms 19 718 20ms 0ms 20 720 20ms 0ms 21 718 25ms 0ms 22 720 21ms 0ms 23 720 21ms 0ms 00 720 20ms 0ms [ User: symmetricds - Total duration: 495ms - Times executed: 17250 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 495ms - Times executed: 17250 ]
-
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-11 12:34:15 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 20:35:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:04:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 17,183 9s649ms 0ms 6ms 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 11 01 719 374ms 0ms 02 716 393ms 0ms 03 716 392ms 0ms 04 718 391ms 0ms 05 714 390ms 0ms 06 716 390ms 0ms 07 716 393ms 0ms 08 714 398ms 0ms 09 716 407ms 0ms 10 716 388ms 0ms 11 716 399ms 0ms 12 716 413ms 0ms 13 716 390ms 0ms 14 716 402ms 0ms 15 716 395ms 0ms 16 716 401ms 0ms 17 714 413ms 0ms 18 714 402ms 0ms 19 716 403ms 0ms 20 716 398ms 0ms 21 716 438ms 0ms 22 716 435ms 0ms 23 718 438ms 0ms 00 716 396ms 0ms [ User: symmetricds - Total duration: 9s649ms - Times executed: 17183 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s649ms - Times executed: 17183 ]
-
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-11 20:59:42 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:15:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 16:52:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 8,591 286ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 11 01 359 11ms 0ms 02 358 12ms 0ms 03 358 11ms 0ms 04 359 11ms 0ms 05 357 11ms 0ms 06 358 11ms 0ms 07 358 11ms 0ms 08 357 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 12ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 358 11ms 0ms 16 358 12ms 0ms 17 357 11ms 0ms 18 357 11ms 0ms 19 358 12ms 0ms 20 358 11ms 0ms 21 358 12ms 0ms 22 358 13ms 0ms 23 359 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 286ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 286ms - Times executed: 8591 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133703' AND '155133702'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133604' AND '155133603'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133564' AND '155133563'));
Date: 2019-08-11 21:18:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:36:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 15:16:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 8,591 309ms 0ms 1ms 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 11 01 359 14ms 0ms 02 358 14ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 357 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 357 12ms 0ms 09 358 13ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 13ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 357 12ms 0ms 18 357 12ms 0ms 19 358 13ms 0ms 20 358 12ms 0ms 21 358 13ms 0ms 22 358 13ms 0ms 23 359 13ms 0ms 00 358 13ms 0ms [ User: symmetricds - Total duration: 309ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 309ms - Times executed: 8591 ]
-
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-11 00:44:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 01:43:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:13:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 8,591 398ms 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 11 01 359 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 359 17ms 0ms 05 357 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 357 16ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 17ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 357 16ms 0ms 18 357 16ms 0ms 19 358 16ms 0ms 20 358 16ms 0ms 21 358 17ms 0ms 22 358 17ms 0ms 23 359 17ms 0ms 00 358 15ms 0ms [ User: symmetricds - Total duration: 398ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 398ms - Times executed: 8591 ]
-
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-11 12:59:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 04:09:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 09:22:04 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 227ms 294ms 245ms 24 5s882ms 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 11 01 1 274ms 274ms 02 1 254ms 254ms 03 1 238ms 238ms 04 1 248ms 248ms 05 1 229ms 229ms 06 1 254ms 254ms 07 1 237ms 237ms 08 1 233ms 233ms 09 1 268ms 268ms 10 1 254ms 254ms 11 1 245ms 245ms 12 1 242ms 242ms 13 1 232ms 232ms 14 1 257ms 257ms 15 1 227ms 227ms 16 1 239ms 239ms 17 1 235ms 235ms 18 1 238ms 238ms 19 1 234ms 234ms 20 1 238ms 238ms 21 1 233ms 233ms 22 1 294ms 294ms 23 1 238ms 238ms 00 1 230ms 230ms [ User: symmetricds - Total duration: 5s882ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s882ms - 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-11 21:00:03 Duration: 294ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:03 Duration: 274ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:00:03 Duration: 268ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 15ms 83ms 26ms 1,932 51s440ms 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 11 01 81 2s417ms 29ms 02 81 2s140ms 26ms 03 81 2s152ms 26ms 04 81 1s983ms 24ms 05 81 1s872ms 23ms 06 81 2s307ms 28ms 07 81 2s73ms 25ms 08 81 2s15ms 24ms 09 81 2s174ms 26ms 10 81 2s236ms 27ms 11 81 1s924ms 23ms 12 81 2s276ms 28ms 13 81 1s872ms 23ms 14 81 2s482ms 30ms 15 81 2s271ms 28ms 16 81 1s462ms 18ms 17 81 2s226ms 27ms 18 81 2s116ms 26ms 19 81 2s518ms 31ms 20 81 2s300ms 28ms 21 81 2s250ms 27ms 22 81 1s990ms 24ms 23 69 2s274ms 32ms 00 81 2s98ms 25ms [ User: symmetricds - Total duration: 51s440ms - Times executed: 1932 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s440ms - Times executed: 1932 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104879180' AND '104884180' AND create_time < '2019-08-10 11:00:00.003' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104879180' AND '104884180') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104879180' AND '104884180' 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-10 03:00:00' 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 '104739152' AND '104744152' AND create_time < '2019-08-10 18:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-11 11:00:01 Duration: 83ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:00:00 Duration: 68ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 5ms 21ms 7ms 1,907 14s413ms 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 11 01 81 712ms 8ms 02 81 661ms 8ms 03 81 614ms 7ms 04 81 606ms 7ms 05 81 602ms 7ms 06 81 630ms 7ms 07 81 593ms 7ms 08 81 692ms 8ms 09 81 681ms 8ms 10 81 636ms 7ms 11 81 582ms 7ms 12 81 595ms 7ms 13 81 568ms 7ms 14 81 618ms 7ms 15 81 564ms 6ms 16 81 602ms 7ms 17 81 605ms 7ms 18 81 579ms 7ms 19 81 620ms 7ms 20 81 575ms 7ms 21 81 591ms 7ms 22 77 547ms 7ms 23 48 348ms 7ms 00 81 581ms 7ms [ User: symmetricds - Total duration: 14s413ms - Times executed: 1907 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s413ms - Times executed: 1907 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104934191' AND '104939191' AND data_id < '105133381' AND create_time < '2019-08-10 00:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104934191' AND '104939191');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105049214' AND '105054214' AND data_id < '105133465' AND create_time < '2019-08-10 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105049214' AND '105054214');
-
DELETE FROM sym_data WHERE data_id BETWEEN '105054215' AND '105059215' AND data_id < '105133465' AND create_time < '2019-08-10 07:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105054215' AND '105059215');
Date: 2019-08-11 00:00:03 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 15ms 6ms 536 3s343ms 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 11 01 131 892ms 6ms 02 19 147ms 7ms 03 18 155ms 8ms 04 19 139ms 7ms 05 18 119ms 6ms 06 18 136ms 7ms 07 19 113ms 5ms 08 19 108ms 5ms 09 19 108ms 5ms 10 19 95ms 5ms 11 19 99ms 5ms 12 19 97ms 5ms 13 19 94ms 4ms 14 19 101ms 5ms 15 19 94ms 4ms 16 19 96ms 5ms 17 18 89ms 4ms 18 15 107ms 7ms 19 19 106ms 5ms 20 11 63ms 5ms 21 19 109ms 5ms 22 3 23ms 7ms 23 19 148ms 7ms 00 19 92ms 4ms [ User: symmetricds - Total duration: 3s135ms - Times executed: 491 ]
[ User: pharmisight - Total duration: 207ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s343ms - Times executed: 536 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_file_trigger' 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 = 'alerts' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-11 00:00:01 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:00 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:00:02 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 7ms 3ms 1,021 3s773ms 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 11 01 32 118ms 3ms 02 34 135ms 3ms 03 36 135ms 3ms 04 34 130ms 3ms 05 38 133ms 3ms 06 37 137ms 3ms 07 43 152ms 3ms 08 42 163ms 3ms 09 49 185ms 3ms 10 53 194ms 3ms 11 50 192ms 3ms 12 47 165ms 3ms 13 51 187ms 3ms 14 54 200ms 3ms 15 51 184ms 3ms 16 51 176ms 3ms 17 50 186ms 3ms 18 52 189ms 3ms 19 50 179ms 3ms 20 45 155ms 3ms 21 23 87ms 3ms 22 24 89ms 3ms 23 33 131ms 3ms 00 42 161ms 3ms [ User: symmetricds - Total duration: 3s773ms - Times executed: 1021 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s773ms - Times executed: 1021 ]
-
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-11 17:58:09 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:57:58 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:29:59 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 153ms 1ms 206,999 5m19s 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 11 01 9,604 15s74ms 1ms 02 9,604 14s887ms 1ms 03 9,604 15s771ms 1ms 04 9,592 14s700ms 1ms 05 9,559 14s597ms 1ms 06 9,552 14s418ms 1ms 07 9,565 15s142ms 1ms 08 9,592 14s806ms 1ms 09 9,604 15s94ms 1ms 10 9,604 14s870ms 1ms 11 9,604 15s226ms 1ms 12 9,604 15s90ms 1ms 13 9,604 14s982ms 1ms 14 9,604 14s974ms 1ms 15 9,604 14s414ms 1ms 16 9,604 14s454ms 1ms 17 9,604 14s561ms 1ms 18 9,604 14s316ms 1ms 19 9,501 14s486ms 1ms 20 9,370 13s623ms 1ms 21 1,142 1s703ms 1ms 22 124 146ms 1ms 23 4,548 7s558ms 1ms 00 9,602 15s55ms 1ms [ User: symmetricds - Total duration: 5m19s - Times executed: 206999 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m19s - Times executed: 206999 ]
-
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-11 13:00:01 Duration: 153ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:19:04 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:04:00 Duration: 137ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 20ms 1ms 76,512 1m34s 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 11 01 3,200 3s669ms 1ms 02 3,200 4s220ms 1ms 03 3,200 4s138ms 1ms 04 3,200 4s152ms 1ms 05 3,200 4s167ms 1ms 06 3,200 3s903ms 1ms 07 3,200 3s575ms 1ms 08 3,197 3s805ms 1ms 09 3,180 3s919ms 1ms 10 3,208 3s844ms 1ms 11 3,140 3s835ms 1ms 12 3,178 3s953ms 1ms 13 3,180 3s848ms 1ms 14 3,182 3s805ms 1ms 15 3,181 3s773ms 1ms 16 3,196 3s880ms 1ms 17 3,200 3s839ms 1ms 18 3,200 3s766ms 1ms 19 3,200 4s154ms 1ms 20 3,200 4s2ms 1ms 21 3,200 4s225ms 1ms 22 3,180 4s141ms 1ms 23 3,200 4s150ms 1ms 00 3,090 3s891ms 1ms [ User: symmetricds - Total duration: 1m34s - Times executed: 76512 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m34s - Times executed: 76512 ]
-
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-11 02:50:58 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:08:59 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 22:39:04 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 6ms 0ms 17,183 9s649ms 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 #8
Day Hour Count Duration Avg duration Aug 11 01 719 374ms 0ms 02 716 393ms 0ms 03 716 392ms 0ms 04 718 391ms 0ms 05 714 390ms 0ms 06 716 390ms 0ms 07 716 393ms 0ms 08 714 398ms 0ms 09 716 407ms 0ms 10 716 388ms 0ms 11 716 399ms 0ms 12 716 413ms 0ms 13 716 390ms 0ms 14 716 402ms 0ms 15 716 395ms 0ms 16 716 401ms 0ms 17 714 413ms 0ms 18 714 402ms 0ms 19 716 403ms 0ms 20 716 398ms 0ms 21 716 438ms 0ms 22 716 435ms 0ms 23 718 438ms 0ms 00 716 396ms 0ms [ User: symmetricds - Total duration: 9s649ms - Times executed: 17183 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s649ms - Times executed: 17183 ]
-
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-11 20:59:42 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 07:15:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 16:52:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 932ms 0ms 2,712,139 15m16s COMMIT;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 11 01 125,921 41s468ms 0ms 02 124,841 41s529ms 0ms 03 124,937 40s504ms 0ms 04 125,149 44s14ms 0ms 05 125,118 43s349ms 0ms 06 125,002 41s804ms 0ms 07 125,034 42s341ms 0ms 08 125,070 42s115ms 0ms 09 125,069 40s125ms 0ms 10 125,036 42s747ms 0ms 11 125,178 42s896ms 0ms 12 124,888 43s64ms 0ms 13 124,894 41s550ms 0ms 14 124,809 43s62ms 0ms 15 124,878 41s412ms 0ms 16 124,808 42s906ms 0ms 17 125,065 44s73ms 0ms 18 125,083 44s169ms 0ms 19 125,076 41s818ms 0ms 20 125,167 41s886ms 0ms 21 19,341 4s795ms 0ms 22 5,346 187ms 0ms 23 61,248 21s1ms 0ms 00 125,181 44s107ms 0ms [ User: symmetricds - Total duration: 15m16s - Times executed: 2711867 ]
[ User: pharmisight - Total duration: 15ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m16s - Times executed: 2712139 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-11 09:30:05 Duration: 932ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 15:10:04 Duration: 799ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:40:04 Duration: 677ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 19ms 0ms 1,711,996 6m55s 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 #10
Day Hour Count Duration Avg duration Aug 11 01 79,383 19s123ms 0ms 02 79,185 19s472ms 0ms 03 79,244 19s371ms 0ms 04 79,382 19s480ms 0ms 05 79,374 19s448ms 0ms 06 79,286 18s926ms 0ms 07 79,308 19s451ms 0ms 08 79,347 19s194ms 0ms 09 79,338 19s390ms 0ms 10 79,314 19s31ms 0ms 11 79,417 19s160ms 0ms 12 79,218 19s194ms 0ms 13 79,237 18s988ms 0ms 14 79,238 19s131ms 0ms 15 79,284 19s227ms 0ms 16 79,234 19s413ms 0ms 17 79,327 19s351ms 0ms 18 79,352 19s93ms 0ms 19 79,343 19s165ms 0ms 20 79,388 18s957ms 0ms 21 9,273 2s58ms 0ms 22 4 1ms 0ms 23 37,076 9s702ms 0ms 00 79,444 19s227ms 0ms [ User: symmetricds - Total duration: 6m55s - Times executed: 1711996 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m55s - Times executed: 1711996 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3271', extract_count = '11742', sent_count = '11741', load_count = '11741', data_row_count = '3', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '2', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '18', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '9', extract_start_time = '2019-08-01 15:36:47.476', transfer_start_time = '2019-08-11 00:26:03.798', 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 = '3', extract_insert_row_count = '1', extract_update_row_count = '2', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195445' 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 = '3590', extract_count = '11876', sent_count = '11875', load_count = '11875', 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 = '19', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 15:15:45.416', transfer_start_time = '2019-08-11 02:19:03.637', 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 = '9195231' 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 = '7646', extract_count = '12931', sent_count = '12930', load_count = '12930', data_row_count = '13', reload_row_count = '0', data_insert_row_count = '5', data_update_row_count = '8', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '14', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 14:56:43.744', transfer_start_time = '2019-08-11 19:35:07.416', 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 = '13', extract_insert_row_count = '5', extract_update_row_count = '8', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195045' AND node_id = '2';
Date: 2019-08-11 00:27:03 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:20:03 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:36:08 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 21ms 0ms 853,475 3m19s 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 #11
Day Hour Count Duration Avg duration Aug 11 01 39,574 9s125ms 0ms 02 39,475 9s277ms 0ms 03 39,505 9s275ms 0ms 04 39,574 9s334ms 0ms 05 39,570 9s264ms 0ms 06 39,529 9s170ms 0ms 07 39,537 9s327ms 0ms 08 39,559 9s272ms 0ms 09 39,553 9s285ms 0ms 10 39,539 9s293ms 0ms 11 39,591 9s254ms 0ms 12 39,490 9s309ms 0ms 13 39,503 9s41ms 0ms 14 39,503 9s253ms 0ms 15 39,527 9s212ms 0ms 16 39,500 9s405ms 0ms 17 39,546 9s174ms 0ms 18 39,556 9s270ms 0ms 19 39,554 9s219ms 0ms 20 39,573 9s10ms 0ms 21 4,625 990ms 0ms 22 4 0ms 0ms 23 18,484 4s692ms 0ms 00 39,604 9s199ms 0ms [ User: symmetricds - Total duration: 3m19s - Times executed: 853475 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m19s - Times executed: 853475 ]
-
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 = '9195645' 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 = '9195343' 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 = '9194559' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-11 17:17:10 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 19:30:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:23:01 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 4ms 0ms 493,929 31s577ms 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 #12
Day Hour Count Duration Avg duration Aug 11 01 21,392 1s370ms 0ms 02 23,210 1s461ms 0ms 03 23,327 1s493ms 0ms 04 24,252 1s529ms 0ms 05 23,403 1s455ms 0ms 06 22,976 1s459ms 0ms 07 23,476 1s465ms 0ms 08 23,542 1s453ms 0ms 09 22,762 1s438ms 0ms 10 22,844 1s452ms 0ms 11 23,608 1s470ms 0ms 12 22,967 1s478ms 0ms 13 21,767 1s421ms 0ms 14 22,769 1s506ms 0ms 15 22,858 1s449ms 0ms 16 23,978 1s501ms 0ms 17 22,220 1s467ms 0ms 18 23,204 1s504ms 0ms 19 22,002 1s392ms 0ms 20 20,945 1s378ms 0ms 21 1,968 132ms 0ms 22 4 0ms 0ms 23 12,413 845ms 0ms 00 22,042 1s448ms 0ms [ User: symmetricds - Total duration: 31s577ms - Times executed: 493929 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s577ms - Times executed: 493929 ]
-
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 = '9196207' 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 = '9196335' 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 = '9196471' AND node_id = '2';
Date: 2019-08-11 02:36:07 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 02:36:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:17:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 44,688 2s404ms 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 #13
Day Hour Count Duration Avg duration Aug 11 01 2,736 147ms 0ms 02 1,824 80ms 0ms 03 1,824 85ms 0ms 04 1,824 95ms 0ms 05 1,824 104ms 0ms 06 1,824 104ms 0ms 07 1,824 98ms 0ms 08 1,824 97ms 0ms 09 1,824 93ms 0ms 10 1,824 110ms 0ms 11 1,824 90ms 0ms 12 1,824 105ms 0ms 13 1,824 91ms 0ms 14 1,824 110ms 0ms 15 1,824 96ms 0ms 16 1,824 79ms 0ms 17 1,824 104ms 0ms 18 1,824 106ms 0ms 19 1,824 113ms 0ms 20 1,824 97ms 0ms 21 1,824 102ms 0ms 22 1,824 90ms 0ms 23 1,824 95ms 0ms 00 1,824 102ms 0ms [ User: pharmisight - Total duration: 2s404ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s404ms - Times executed: 44688 ]
-
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 = '37' 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 = '2857' 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 = '3499' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 4ms 0ms 50,372 2s705ms 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 #14
Day Hour Count Duration Avg duration Aug 11 01 3,084 166ms 0ms 02 2,056 89ms 0ms 03 2,056 98ms 0ms 04 2,056 105ms 0ms 05 2,056 115ms 0ms 06 2,056 121ms 0ms 07 2,056 110ms 0ms 08 2,056 110ms 0ms 09 2,056 104ms 0ms 10 2,056 122ms 0ms 11 2,056 102ms 0ms 12 2,056 118ms 0ms 13 2,056 104ms 0ms 14 2,056 123ms 0ms 15 2,056 108ms 0ms 16 2,056 89ms 0ms 17 2,056 118ms 0ms 18 2,056 118ms 0ms 19 2,056 126ms 0ms 20 2,056 109ms 0ms 21 2,056 116ms 0ms 22 2,056 101ms 0ms 23 2,056 106ms 0ms 00 2,056 114ms 0ms [ User: pharmisight - Total duration: 2s705ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s705ms - Times executed: 50372 ]
-
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 = '3449' 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 = '159' 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 = '32994512' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-11 02:20:01 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 05:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 4ms 0ms 24,993 1s278ms 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 #15
Day Hour Count Duration Avg duration Aug 11 01 1,110 62ms 0ms 02 1,044 59ms 0ms 03 1,044 51ms 0ms 04 1,046 54ms 0ms 05 1,042 53ms 0ms 06 1,044 51ms 0ms 07 1,044 52ms 0ms 08 1,038 53ms 0ms 09 1,044 53ms 0ms 10 1,044 49ms 0ms 11 1,044 53ms 0ms 12 1,044 56ms 0ms 13 1,044 52ms 0ms 14 1,044 51ms 0ms 15 1,044 53ms 0ms 16 1,043 53ms 0ms 17 1,048 51ms 0ms 18 1,046 51ms 0ms 19 1,050 51ms 0ms 20 1,050 51ms 0ms 21 993 53ms 0ms 22 990 50ms 0ms 23 1,018 52ms 0ms 00 1,035 51ms 0ms [ User: symmetricds - Total duration: 1s278ms - Times executed: 24993 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s278ms - Times executed: 24993 ]
-
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-11 01:17:57 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 00:44:24 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 03:23:58 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 8,591 398ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 11 01 359 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 359 17ms 0ms 05 357 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 357 16ms 0ms 09 358 16ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 17ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 357 16ms 0ms 18 357 16ms 0ms 19 358 16ms 0ms 20 358 16ms 0ms 21 358 17ms 0ms 22 358 17ms 0ms 23 359 17ms 0ms 00 358 15ms 0ms [ User: symmetricds - Total duration: 398ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 398ms - Times executed: 8591 ]
-
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-11 12:59:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 04:09:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 09:22:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 4ms 0ms 878,439 39s12ms 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 #17
Day Hour Count Duration Avg duration Aug 11 01 40,652 1s786ms 0ms 02 40,549 1s826ms 0ms 03 40,585 1s822ms 0ms 04 40,651 1s812ms 0ms 05 40,643 1s826ms 0ms 06 40,603 1s787ms 0ms 07 40,614 1s825ms 0ms 08 40,633 1s789ms 0ms 09 40,627 1s823ms 0ms 10 40,619 1s790ms 0ms 11 40,669 1s773ms 0ms 12 40,570 1s813ms 0ms 13 40,577 1s765ms 0ms 14 40,579 1s801ms 0ms 15 40,602 1s800ms 0ms 16 40,577 1s825ms 0ms 17 40,623 1s789ms 0ms 18 40,632 1s803ms 0ms 19 40,630 1s787ms 0ms 20 40,651 1s759ms 0ms 21 5,383 228ms 0ms 22 720 40ms 0ms 23 19,370 939ms 0ms 00 40,680 1s794ms 0ms [ User: symmetricds - Total duration: 39s12ms - Times executed: 878439 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s12ms - Times executed: 878439 ]
-
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 = '0';
-
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-11 15:30:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 01:08:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 14:44:04 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 8,591 309ms 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 #18
Day Hour Count Duration Avg duration Aug 11 01 359 14ms 0ms 02 358 14ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 357 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 357 12ms 0ms 09 358 13ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 13ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 357 12ms 0ms 18 357 12ms 0ms 19 358 13ms 0ms 20 358 12ms 0ms 21 358 13ms 0ms 22 358 13ms 0ms 23 359 13ms 0ms 00 358 13ms 0ms [ User: symmetricds - Total duration: 309ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 309ms - Times executed: 8591 ]
-
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-11 00:44:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 01:43:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 06:13:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,591 286ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 11 01 359 11ms 0ms 02 358 12ms 0ms 03 358 11ms 0ms 04 359 11ms 0ms 05 357 11ms 0ms 06 358 11ms 0ms 07 358 11ms 0ms 08 357 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 12ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 358 11ms 0ms 16 358 12ms 0ms 17 357 11ms 0ms 18 357 11ms 0ms 19 358 12ms 0ms 20 358 11ms 0ms 21 358 12ms 0ms 22 358 13ms 0ms 23 359 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 286ms - Times executed: 8591 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 286ms - Times executed: 8591 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133703' AND '155133702'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133604' AND '155133603'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133564' AND '155133563'));
Date: 2019-08-11 21:18:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 18:36:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 15:16:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 4ms 0ms 17,250 495ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 11 01 720 19ms 0ms 02 718 20ms 0ms 03 720 19ms 0ms 04 718 20ms 0ms 05 718 19ms 0ms 06 718 19ms 0ms 07 720 20ms 0ms 08 718 19ms 0ms 09 720 23ms 0ms 10 716 19ms 0ms 11 718 20ms 0ms 12 720 19ms 0ms 13 716 24ms 0ms 14 718 19ms 0ms 15 720 20ms 0ms 16 718 20ms 0ms 17 720 20ms 0ms 18 718 20ms 0ms 19 718 20ms 0ms 20 720 20ms 0ms 21 718 25ms 0ms 22 720 21ms 0ms 23 720 21ms 0ms 00 720 20ms 0ms [ User: symmetricds - Total duration: 495ms - Times executed: 17250 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 495ms - Times executed: 17250 ]
-
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-11 12:34:15 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 20:35:29 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-11 08:04:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 69,747,227 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET