pgBadger-
Global information
- Generated on Sun Aug 11 00:01:32 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 67,993,387 log entries in 1m28s
- Log start from 2019-08-10 00:00:00 to 2019-08-10 23:59:59
-
Overview
Global Stats
- 179 Number of unique normalized queries
- 23,196,916 Number of queries
- 36m58s Total query duration
- 2019-08-10 00:00:00 First query
- 2019-08-10 23:59:59 Last query
- 4,762 queries/s at 2019-08-10 08:12:54 Query peak
- 5 Number of events
- 3 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 455 Total number of automatic vacuums
- 651 Total number of automatic analyzes
- 1,298 Number temporary file
- 21.88 MiB Max size of temporary file
- 4.38 MiB Average size of temporary file
- 1,961 Total number of sessions
- 2 sessions at 2019-08-10 00:30:19 Session peak
- 10d7h33m50s Total duration of sessions
- 7m34s Average duration of sessions
- 11,829 Average queries per session
- 1s131ms Average queries duration per session
- 1,961 Total number of connections
- 42 connections/s at 2019-08-10 00:30:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4,762 queries/s Query Peak
- 2019-08-10 08:12:54 Date
SELECT Traffic
Key values
- 2,030 queries/s Query Peak
- 2019-08-10 00:20:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,730 queries/s Query Peak
- 2019-08-10 08:12:54 Date
Queries duration
Key values
- 36m58s Total query duration
Prepared queries ratio
Key values
- 1.72 Ratio of bind vs prepare
- 167.68 % 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 10 00 1,075,104 0ms 253ms 0ms 2s160ms 2s201ms 4s837ms 01 1,062,169 0ms 236ms 0ms 2s112ms 2s407ms 4s276ms 02 1,065,462 0ms 234ms 0ms 2s163ms 2s251ms 4s219ms 03 1,067,262 0ms 231ms 0ms 2s77ms 2s320ms 3s749ms 04 1,063,582 0ms 225ms 0ms 2s65ms 2s199ms 5s105ms 05 1,072,846 0ms 229ms 0ms 2s102ms 2s110ms 3s509ms 06 1,067,316 0ms 226ms 0ms 2s14ms 2s34ms 4s242ms 07 1,064,795 0ms 119ms 0ms 1s999ms 2s104ms 4s830ms 08 1,067,638 0ms 228ms 0ms 2s91ms 2s164ms 4s797ms 09 1,070,245 0ms 225ms 0ms 2s21ms 2s153ms 5s439ms 10 1,069,233 0ms 233ms 0ms 2s53ms 2s94ms 4s646ms 11 1,066,972 0ms 232ms 0ms 2s40ms 2s134ms 4s144ms 12 1,065,800 0ms 226ms 0ms 2s117ms 2s267ms 4s657ms 13 1,074,365 0ms 233ms 0ms 2s65ms 2s234ms 4s838ms 14 1,079,812 0ms 240ms 0ms 2s122ms 2s395ms 5s282ms 15 1,072,004 0ms 237ms 0ms 2s189ms 2s332ms 5s242ms 16 1,067,299 0ms 231ms 0ms 2s27ms 2s141ms 4s452ms 17 1,065,655 0ms 258ms 0ms 2s209ms 2s345ms 5s294ms 18 1,069,265 0ms 260ms 0ms 2s57ms 2s197ms 5s154ms 19 1,072,209 0ms 276ms 0ms 2s174ms 2s282ms 5s376ms 20 155,323 0ms 246ms 0ms 1s38ms 1s186ms 5s765ms 21 48,272 0ms 225ms 0ms 286ms 319ms 3s133ms 22 546,416 0ms 230ms 0ms 1s995ms 2s167ms 2s444ms 23 1,067,872 0ms 236ms 0ms 2s105ms 2s209ms 5s13ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 10 00 311,360 0 0ms 723ms 787ms 840ms 01 304,677 0 0ms 746ms 792ms 884ms 02 305,636 0 0ms 715ms 783ms 836ms 03 306,179 0 0ms 699ms 768ms 835ms 04 305,168 0 0ms 694ms 803ms 832ms 05 307,793 0 0ms 695ms 764ms 783ms 06 306,134 0 0ms 682ms 768ms 813ms 07 305,421 0 0ms 688ms 753ms 794ms 08 306,205 0 0ms 688ms 761ms 841ms 09 306,981 0 0ms 727ms 761ms 847ms 10 306,653 0 0ms 703ms 773ms 819ms 11 306,062 0 0ms 658ms 771ms 833ms 12 305,702 0 0ms 689ms 764ms 810ms 13 308,167 0 0ms 714ms 798ms 840ms 14 309,695 0 0ms 703ms 791ms 833ms 15 307,460 0 0ms 694ms 788ms 863ms 16 306,088 0 0ms 715ms 763ms 817ms 17 305,614 0 0ms 682ms 799ms 833ms 18 306,632 0 0ms 669ms 770ms 811ms 19 307,488 0 0ms 692ms 800ms 912ms 20 50,039 0 0ms 250ms 342ms 821ms 21 19,484 0 0ms 248ms 270ms 373ms 22 159,673 0 0ms 584ms 747ms 839ms 23 306,202 0 0ms 682ms 795ms 957ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 10 00 472 80,598 243 0 0ms 363ms 379ms 412ms 01 340 79,676 239 0 0ms 359ms 372ms 388ms 02 250 79,676 241 0 0ms 357ms 370ms 410ms 03 427 79,677 242 0 0ms 363ms 382ms 389ms 04 357 79,676 240 0 0ms 354ms 372ms 397ms 05 175 79,677 241 0 0ms 361ms 373ms 392ms 06 93 79,615 241 0 0ms 362ms 372ms 400ms 07 94 79,649 241 0 0ms 353ms 366ms 389ms 08 90 79,683 243 0 0ms 357ms 374ms 397ms 09 86 79,553 241 0 0ms 355ms 373ms 396ms 10 88 79,873 241 0 0ms 339ms 371ms 389ms 11 88 79,496 243 0 0ms 349ms 370ms 405ms 12 88 79,584 241 0 0ms 352ms 370ms 398ms 13 88 79,620 242 0 0ms 351ms 372ms 408ms 14 88 79,618 243 0 0ms 353ms 372ms 396ms 15 88 79,651 240 0 0ms 346ms 376ms 402ms 16 88 79,623 242 0 0ms 335ms 370ms 390ms 17 88 79,582 243 0 0ms 339ms 383ms 411ms 18 88 79,575 239 0 0ms 348ms 369ms 406ms 19 91 79,616 241 0 0ms 349ms 378ms 405ms 20 113 8,746 270 0 0ms 2ms 7ms 350ms 21 88 53 220 0 7ms 2ms 7ms 8ms 22 88 38,881 151 0 0ms 227ms 366ms 411ms 23 88 79,459 241 0 0ms 346ms 375ms 403ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 10 00 622,074 1,075,068 1.73 96.51% 01 615,437 1,062,133 1.73 96.89% 02 618,428 1,065,426 1.72 97.22% 03 619,674 1,067,226 1.72 97.28% 04 616,820 1,063,546 1.72 96.99% 05 625,050 1,072,810 1.72 97.92% 06 620,661 1,067,280 1.72 97.53% 07 618,500 1,064,759 1.72 97.28% 08 620,758 1,067,602 1.72 97.50% 09 623,804 1,070,209 1.72 97.94% 10 621,870 1,069,197 1.72 97.49% 11 621,199 1,066,936 1.72 97.70% 12 619,843 1,065,764 1.72 97.49% 13 627,293 1,074,329 1.71 98.26% 14 631,662 1,079,776 1.71 98.71% 15 624,831 1,071,968 1.72 97.96% 16 620,413 1,067,263 1.72 97.50% 17 619,084 1,065,619 1.72 97.38% 18 621,968 1,069,229 1.72 97.69% 19 624,361 1,072,173 1.72 97.91% 20 89,603 155,287 1.73 93.43% 21 29,080 48,236 1.66 95.35% 22 318,371 546,380 1.72 97.57% 23 620,638 1,067,836 1.72 97.63% Day Hour Count Average / Second Aug 10 00 119 0.03/s 01 72 0.02/s 02 70 0.02/s 03 72 0.02/s 04 79 0.02/s 05 77 0.02/s 06 75 0.02/s 07 87 0.02/s 08 80 0.02/s 09 88 0.02/s 10 85 0.02/s 11 80 0.02/s 12 86 0.02/s 13 89 0.02/s 14 85 0.02/s 15 81 0.02/s 16 76 0.02/s 17 79 0.02/s 18 70 0.02/s 19 70 0.02/s 20 97 0.03/s 21 97 0.03/s 22 83 0.02/s 23 64 0.02/s Day Hour Count Average Duration Aug 10 00 119 7m17s 01 72 8m41s 02 70 8m22s 03 72 8m20s 04 79 7m51s 05 77 7m37s 06 75 7m9s 07 87 8m3s 08 80 7m46s 09 88 7m8s 10 85 7m19s 11 80 7m16s 12 86 7m9s 13 89 6m55s 14 85 7m4s 15 81 7m19s 16 76 7m57s 17 79 8m 18 70 8m31s 19 70 8m28s 20 97 6m15s 21 97 6m24s 22 83 7m13s 23 64 9m8s -
Connections
Established Connections
Key values
- 42 connections Connection Peak
- 2019-08-10 00:30:20 Date
Connections per database
Key values
- pharmisight Main Database
- 1,961 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,961 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2019-08-10 00:30:19 Date
Histogram of session times
Key values
- 1,273 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,961 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,961 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,961 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,706 buffers Checkpoint Peak
- 2019-08-10 07:03:57 Date
- 149.142 seconds Highest write time
- 0.015 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2019-08-10 07:03:57 Date
Checkpoints distance
Key values
- 89.14 Mo Distance Peak
- 2019-08-10 07:03:57 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 10 00 5,176 518.036s 0.014s 518.112s 01 4,468 447.278s 0.024s 447.367s 02 4,281 428.468s 0.02s 428.556s 03 4,383 438.08s 0.018s 438.212s 04 4,306 431.145s 0.022s 431.228s 05 4,275 428.211s 0.012s 428.282s 06 4,237 423.932s 0.041s 424.044s 07 6,731 552.019s 0.019s 552.105s 08 4,491 449.749s 0.007s 449.828s 09 4,500 450.232s 0.01s 450.306s 10 4,537 454.587s 0.028s 454.694s 11 4,514 452.057s 0.014s 452.132s 12 4,824 482.59s 0.013s 482.671s 13 5,247 524.708s 0.023s 524.799s 14 5,531 553.93s 0.015s 554.035s 15 5,420 542.236s 0.017s 542.336s 16 5,608 560.758s 0.014s 560.841s 17 5,641 564.658s 0.016s 564.741s 18 5,474 547.896s 0.01s 547.975s 19 5,317 532.347s 0.013s 532.425s 20 1,248 125.096s 0.014s 125.174s 21 377 37.84s 0.024s 37.959s 22 3,010 301.579s 0.014s 301.662s 23 5,085 509.071s 0.017s 509.16s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 10 00 0 0 5 348 0.002s 0s 01 0 0 4 315 0.006s 0s 02 0 0 4 308 0.009s 0s 03 0 0 4 297 0.011s 0s 04 0 0 4 302 0.005s 0s 05 0 0 4 300 0.001s 0s 06 0 0 4 286 0.014s 0s 07 0 0 7 322 0.009s 0s 08 0 0 4 313 0.001s 0s 09 0 0 4 287 0.002s 0s 10 0 0 4 295 0.008s 0s 11 0 0 4 286 0.001s 0s 12 0 0 5 294 0.002s 0s 13 0 0 4 297 0.010s 0s 14 0 0 5 299 0.004s 0s 15 0 0 5 291 0.003s 0s 16 0 0 4 304 0.002s 0s 17 0 0 5 315 0.002s 0s 18 0 0 4 296 0.001s 0s 19 0 0 5 297 0.002s 0s 20 0 0 1 242 0.002s 0s 21 0 0 0 226 0.005s 0s 22 0 0 2 298 0.003s 0s 23 0 0 4 351 0.006s 0s Day Hour Count Avg time (sec) Aug 10 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 10 00 6,034.00 kB 6,438.42 kB 01 5,603.83 kB 6,088.17 kB 02 5,519.67 kB 5,896.25 kB 03 5,583.08 kB 5,928.08 kB 04 5,585.67 kB 5,876.33 kB 05 5,596.50 kB 5,946.08 kB 06 5,532.92 kB 5,658.83 kB 07 8,883.42 kB 29,528.92 kB 08 5,796.17 kB 12,499.58 kB 09 5,766.50 kB 7,656.25 kB 10 5,782.58 kB 6,820.17 kB 11 5,786.50 kB 6,897.00 kB 12 5,932.25 kB 6,953.00 kB 13 6,146.17 kB 7,146.00 kB 14 6,310.67 kB 7,061.42 kB 15 6,255.58 kB 6,923.83 kB 16 6,268.92 kB 7,032.58 kB 17 6,292.92 kB 6,905.83 kB 18 6,181.58 kB 6,438.50 kB 19 6,141.25 kB 6,425.42 kB 20 1,295.09 kB 4,399.82 kB 21 156.08 kB 1,342.00 kB 22 2,875.67 kB 4,221.33 kB 23 5,934.67 kB 6,137.58 kB -
Temporary Files
Size of temporary files
Key values
- 8.77 MiB Temp Files size Peak
- 2019-08-10 23:35:58 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2019-08-10 23:35:58 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 10 00 60 262.50 MiB 4.38 MiB 01 60 262.50 MiB 4.38 MiB 02 60 262.50 MiB 4.38 MiB 03 60 262.50 MiB 4.38 MiB 04 60 262.50 MiB 4.38 MiB 05 60 262.50 MiB 4.38 MiB 06 60 262.50 MiB 4.38 MiB 07 60 262.50 MiB 4.38 MiB 08 60 262.50 MiB 4.38 MiB 09 60 262.50 MiB 4.38 MiB 10 60 262.50 MiB 4.38 MiB 11 60 262.50 MiB 4.38 MiB 12 60 262.50 MiB 4.38 MiB 13 60 262.95 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 60 262.97 MiB 4.38 MiB 19 60 262.97 MiB 4.38 MiB 20 6 26.30 MiB 4.38 MiB 21 0 0 0 22 30 131.48 MiB 4.38 MiB 23 62 271.73 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 (618) Main table analyzed (database pharmisight)
- 651 analyzes Total
Vacuums per table
Key values
- public.sym_outgoing_batch (428) Main table vacuumed on database pharmisight
- 455 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 428 428 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.pg_toast.pg_toast_2619 6 6 pharmisight.public.sym_data_gap 5 5 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.item_codes 1 1 pharmisight.public.sym_data_event 1 1 Total 455 449 Tuples removed per table
Key values
- public.sym_outgoing_batch (353589) Main table with removed tuples on database pharmisight
- 359827 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_outgoing_batch 428 428 353589 0 pharmisight.public.sym_data_event 1 1 3633 0 pharmisight.public.sym_incoming_batch 6 6 937 7 pharmisight.pg_catalog.pg_statistic 2 2 603 0 pharmisight.pg_toast.pg_toast_2619 6 6 377 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.item_codes 1 1 121 0 Total 455 449 359,827 7 Pages removed per table
Key values
- public.sym_incoming_batch (7) Main table with removed pages on database pharmisight
- 7 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_incoming_batch 6 6 937 7 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_outgoing_batch 428 428 353589 0 pharmisight.public.item_codes 1 1 121 0 pharmisight.pg_catalog.pg_statistic 2 2 603 0 pharmisight.public.sym_data_event 1 1 3633 0 pharmisight.pg_toast.pg_toast_2619 6 6 377 0 Total 455 449 359,827 7 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 10 00 22 32 01 22 34 02 20 30 03 22 31 04 20 31 05 21 32 06 21 30 07 22 32 08 21 31 09 22 31 10 21 33 11 21 31 12 21 22 13 21 22 14 22 27 15 21 27 16 22 27 17 21 31 18 19 32 19 20 31 20 3 6 21 0 0 22 10 16 23 20 32 - 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,670,513 Total read queries
- 7,162,912 Total write queries
Queries by database
Key values
- pharmisight Main database
- 23,196,916 Requests
- 36m58s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 23,273,040 Requests
User Request type Count Duration pharmisight Total 101,028 7s398ms DELETE 29 3ms INSERT 34 3ms OTHERS 1,725 69ms SELECT 98,632 7s298ms TCL 564 16ms UPDATE 44 6ms symmetricds Total 23,273,040 37m7s DELETE 5,686 1m4s INSERT 3,677 1s206ms OTHERS 9,434,089 2m8s SELECT 6,621,612 11m56s TCL 5,473,884 15m16s UPDATE 1,734,092 6m39s tony Total 870 230ms SELECT 870 230ms Duration by user
Key values
- 37m7s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 101,028 7s398ms DELETE 29 3ms INSERT 34 3ms OTHERS 1,725 69ms SELECT 98,632 7s298ms TCL 564 16ms UPDATE 44 6ms symmetricds Total 23,273,040 37m7s DELETE 5,686 1m4s INSERT 3,677 1s206ms OTHERS 9,434,089 2m8s SELECT 6,621,612 11m56s TCL 5,473,884 15m16s UPDATE 1,734,092 6m39s tony Total 870 230ms SELECT 870 230ms Queries by host
Key values
- 10.10.10.1 Main host
- 23,374,068 Requests
- 37m15s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 23,194,379 Requests
- 36m58s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-10 02:34:06 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 22,961,604 0-1ms duration
Slowest individual queries
Rank Duration Query 1 276ms COMMIT;[ Date: 2019-08-10 19:20:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 260ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 18:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 258ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 17:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 253ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 00:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 252ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 19:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 246ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 20:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 240ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 14:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 237ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 15:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 236ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 01:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 236ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 23:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 234ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 02:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 233ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 10:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 233ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 13:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 232ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 11:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 231ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 03:00:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 231ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 16:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 230ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 22:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 229ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 05:00:02 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 228ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 08:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 226ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-10 06:00:03 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 14m52s 2,716,350 0ms 276ms 0ms COMMIT;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 10 01 125,934 41s519ms 0ms 02 125,145 40s850ms 0ms 03 125,140 41s272ms 0ms 04 125,240 38s933ms 0ms 05 125,245 41s255ms 0ms 06 125,235 40s224ms 0ms 07 125,132 40s957ms 0ms 08 125,208 40s433ms 0ms 09 125,237 40s162ms 0ms 10 125,032 41s623ms 0ms 11 125,521 41s255ms 0ms 12 124,970 39s679ms 0ms 13 125,089 42s216ms 0ms 14 125,146 41s215ms 0ms 15 125,137 43s687ms 0ms 16 125,200 42s646ms 0ms 17 125,150 40s875ms 0ms 18 125,090 44s657ms 0ms 19 125,072 41s248ms 0ms 20 125,128 42s573ms 0ms 21 18,368 4s148ms 0ms 22 5,327 173ms 0ms 23 63,749 20s218ms 0ms 00 124,855 41s48ms 0ms [ User: symmetricds - Total duration: 14m52s - Times executed: 2716069 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 281 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m52s - Times executed: 2716350 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-10 19:20:04 Duration: 276ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 82ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6m33s 1,714,794 0ms 16ms 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 10 01 79,444 18s275ms 0ms 02 79,444 17s940ms 0ms 03 79,443 17s791ms 0ms 04 79,444 18s348ms 0ms 05 79,444 18s202ms 0ms 06 79,444 18s523ms 0ms 07 79,385 18s200ms 0ms 08 79,416 18s414ms 0ms 09 79,452 18s523ms 0ms 10 79,324 18s763ms 0ms 11 79,642 18s166ms 0ms 12 79,267 18s305ms 0ms 13 79,353 18s188ms 0ms 14 79,389 18s342ms 0ms 15 79,389 18s760ms 0ms 16 79,420 18s252ms 0ms 17 79,394 18s95ms 0ms 18 79,352 17s910ms 0ms 19 79,345 17s987ms 0ms 20 79,378 18s16ms 0ms 21 8,649 1s712ms 0ms 22 4 1ms 0ms 23 38,742 9s143ms 0ms 00 79,230 17s887ms 0ms [ User: symmetricds - Total duration: 6m33s - Times executed: 1714794 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m33s - Times executed: 1714794 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '2452', extract_count = '10908', sent_count = '10907', load_count = '10907', data_row_count = '4', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:27:48.859', transfer_start_time = '2019-08-10 08:59:00.323', 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 = 'flow_reports, order_rounds', 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 = '4', extract_insert_row_count = '1', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195667' 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 = '8757', extract_count = '10542', sent_count = '10541', load_count = '10541', data_row_count = '19', reload_row_count = '0', data_insert_row_count = '8', data_update_row_count = '11', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '21', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:32:46.437', transfer_start_time = '2019-08-10 01:57:56.192', 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 = 'rx_line_activities, order_lines, order_line_activities, orders', 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 = '19', extract_insert_row_count = '8', extract_update_row_count = '11', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195393' 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 = '9471', extract_count = '11201', sent_count = '11200', load_count = '11200', data_row_count = '23', reload_row_count = '0', data_insert_row_count = '10', data_update_row_count = '13', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '34', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 15:37:46.804', transfer_start_time = '2019-08-10 13:01:57.335', 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 = '23', extract_insert_row_count = '10', extract_update_row_count = '13', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195455' AND node_id = '2';
Date: 2019-08-10 09:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 01:58:56 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:02:56 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4m55s 207,744 0ms 146ms 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 10 01 9,604 14s371ms 1ms 02 9,604 13s871ms 1ms 03 9,604 13s696ms 1ms 04 9,604 13s713ms 1ms 05 9,604 13s548ms 1ms 06 9,604 13s91ms 1ms 07 9,604 13s531ms 1ms 08 9,604 13s448ms 1ms 09 9,604 13s284ms 1ms 10 9,604 13s637ms 1ms 11 9,604 13s584ms 1ms 12 9,604 13s694ms 1ms 13 9,604 13s843ms 1ms 14 9,604 13s876ms 1ms 15 9,604 13s616ms 1ms 16 9,604 13s364ms 1ms 17 9,604 13s630ms 1ms 18 9,604 13s756ms 1ms 19 9,604 13s697ms 1ms 20 9,604 13s584ms 1ms 21 1,072 1s295ms 1ms 22 124 128ms 1ms 23 4,864 7s414ms 1ms 00 9,604 14s153ms 1ms [ User: symmetricds - Total duration: 4m55s - Times executed: 207744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 207744 ]
-
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-10 22:50:56 Duration: 146ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:47:49 Duration: 135ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 22:51:56 Duration: 133ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 3m7s 854,864 0ms 17ms 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 10 01 39,604 8s620ms 0ms 02 39,604 8s617ms 0ms 03 39,604 8s680ms 0ms 04 39,604 8s856ms 0ms 05 39,604 8s783ms 0ms 06 39,604 8s852ms 0ms 07 39,577 8s887ms 0ms 08 39,590 8s767ms 0ms 09 39,608 8s728ms 0ms 10 39,545 8s801ms 0ms 11 39,700 8s647ms 0ms 12 39,519 8s615ms 0ms 13 39,559 8s668ms 0ms 14 39,576 8s702ms 0ms 15 39,577 8s675ms 0ms 16 39,593 8s738ms 0ms 17 39,579 8s610ms 0ms 18 39,558 8s454ms 0ms 19 39,555 8s671ms 0ms 20 39,572 8s572ms 0ms 21 4,311 828ms 0ms 22 4 0ms 0ms 23 19,316 4s297ms 0ms 00 39,501 8s541ms 0ms [ User: symmetricds - Total duration: 3m7s - Times executed: 854864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m7s - Times executed: 854864 ]
-
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 = '9195575' 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 = '9195447' 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 = '9195213' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-10 07:57:59 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:32:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:52:53 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m39s 6,809,961 0ms 24ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 10 01 312,932 4s588ms 0ms 02 310,602 4s494ms 0ms 03 312,059 4s472ms 0ms 04 312,705 4s602ms 0ms 05 311,135 4s489ms 0ms 06 315,232 4s643ms 0ms 07 313,073 4s614ms 0ms 08 311,912 4s526ms 0ms 09 313,101 4s626ms 0ms 10 314,435 4s651ms 0ms 11 313,447 4s528ms 0ms 12 313,129 4s635ms 0ms 13 312,478 4s523ms 0ms 14 316,069 4s596ms 0ms 15 318,430 4s612ms 0ms 16 315,031 4s612ms 0ms 17 313,086 4s498ms 0ms 18 312,457 4s425ms 0ms 19 314,037 4s528ms 0ms 20 315,222 4s539ms 0ms 21 47,082 651ms 0ms 22 16,846 284ms 0ms 23 161,789 2s399ms 0ms 00 313,672 4s452ms 0ms [ User: symmetricds - Total duration: 1m38s - Times executed: 6809390 ]
[ User: pharmisight - Total duration: 26ms - Times executed: 571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m39s - Times executed: 6809961 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-10 11:26:59 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:34:57 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 21:29:55 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m29s 76,800 0ms 111ms 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 10 01 3,200 4s57ms 1ms 02 3,200 3s841ms 1ms 03 3,200 3s523ms 1ms 04 3,200 3s802ms 1ms 05 3,200 3s509ms 1ms 06 3,200 3s614ms 1ms 07 3,200 3s460ms 1ms 08 3,200 3s726ms 1ms 09 3,200 3s655ms 1ms 10 3,200 4s20ms 1ms 11 3,200 3s547ms 1ms 12 3,200 3s383ms 1ms 13 3,200 3s494ms 1ms 14 3,200 3s528ms 1ms 15 3,200 3s457ms 1ms 16 3,200 3s673ms 1ms 17 3,200 3s686ms 1ms 18 3,200 3s744ms 1ms 19 3,200 3s637ms 1ms 20 3,200 3s733ms 1ms 21 3,200 4s69ms 1ms 22 3,200 4s357ms 1ms 23 3,200 4s52ms 1ms 00 3,200 3s809ms 1ms [ User: symmetricds - Total duration: 1m29s - Times executed: 76800 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m29s - Times executed: 76800 ]
-
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-10 23:35:57 Duration: 111ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 23:41:57 Duration: 55ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:02:50 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 49s813ms 1,930 2ms 71ms 25ms 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 10 01 81 1s826ms 22ms 02 81 1s949ms 24ms 03 81 2s28ms 25ms 04 81 1s416ms 17ms 05 81 2s270ms 28ms 06 81 1s357ms 16ms 07 81 2s119ms 26ms 08 81 2s503ms 30ms 09 81 2s15ms 24ms 10 81 2s191ms 27ms 11 81 2s182ms 26ms 12 81 1s919ms 23ms 13 81 2s140ms 26ms 14 81 2s85ms 25ms 15 81 2s204ms 27ms 16 81 2s399ms 29ms 17 81 1s934ms 23ms 18 81 2s152ms 26ms 19 81 2s184ms 26ms 20 81 2s151ms 26ms 21 81 2s290ms 28ms 22 81 2s249ms 27ms 23 67 1s933ms 28ms 00 81 2s303ms 28ms [ User: symmetricds - Total duration: 49s813ms - Times executed: 1930 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s813ms - Times executed: 1930 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105059216' AND '105064216' AND create_time < '2019-08-09 04:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105059216' AND '105064216') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105059216' AND '105064216' 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 '104729150' AND '104734150' AND create_time < '2019-08-09 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104729150' AND '104734150') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104729150' AND '104734150' 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-09 12: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-10 04:00:02 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:00:00 Duration: 69ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:00:00 Duration: 68ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 38s31ms 4,006,321 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 10 01 185,696 1s766ms 0ms 02 183,858 1s734ms 0ms 03 184,350 1s710ms 0ms 04 184,563 1s746ms 0ms 05 184,039 1s741ms 0ms 06 185,399 1s811ms 0ms 07 184,624 1s749ms 0ms 08 184,269 1s756ms 0ms 09 184,697 1s781ms 0ms 10 185,004 1s789ms 0ms 11 185,001 1s735ms 0ms 12 184,522 1s750ms 0ms 13 184,387 1s722ms 0ms 14 185,621 1s776ms 0ms 15 186,405 1s821ms 0ms 16 185,303 1s754ms 0ms 17 184,633 1s744ms 0ms 18 184,380 1s720ms 0ms 19 184,897 1s745ms 0ms 20 185,325 1s759ms 0ms 21 25,048 225ms 0ms 22 6,277 73ms 0ms 23 93,362 899ms 0ms 00 184,661 1s714ms 0ms [ User: symmetricds - Total duration: 38s31ms - Times executed: 4006321 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s31ms - Times executed: 4006321 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-10 08:38:57 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 18:16:54 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 17:26:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 36s675ms 879,827 0ms 10ms 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 10 01 40,680 1s665ms 0ms 02 40,682 1s674ms 0ms 03 40,680 1s657ms 0ms 04 40,682 1s703ms 0ms 05 40,680 1s685ms 0ms 06 40,682 1s701ms 0ms 07 40,647 1s721ms 0ms 08 40,667 1s685ms 0ms 09 40,685 1s706ms 0ms 10 40,618 1s697ms 0ms 11 40,783 1s692ms 0ms 12 40,590 1s694ms 0ms 13 40,635 1s696ms 0ms 14 40,655 1s715ms 0ms 15 40,650 1s731ms 0ms 16 40,669 1s712ms 0ms 17 40,655 1s681ms 0ms 18 40,637 1s677ms 0ms 19 40,631 1s701ms 0ms 20 40,649 1s702ms 0ms 21 5,070 195ms 0ms 22 720 39ms 0ms 23 20,208 868ms 0ms 00 40,572 1s666ms 0ms [ User: symmetricds - Total duration: 36s675ms - Times executed: 879827 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s675ms - Times executed: 879827 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
Date: 2019-08-10 14:56:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:36:58 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 16:56:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 26s426ms 410,008 0ms 2ms 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 10 01 18,670 1s224ms 0ms 02 18,077 1s231ms 0ms 03 18,567 1s210ms 0ms 04 18,679 1s250ms 0ms 05 18,155 1s162ms 0ms 06 19,526 1s274ms 0ms 07 18,878 1s247ms 0ms 08 18,434 1s202ms 0ms 09 18,812 1s262ms 0ms 10 19,391 1s296ms 0ms 11 18,739 1s240ms 0ms 12 18,987 1s276ms 0ms 13 18,700 1s181ms 0ms 14 19,857 1s264ms 0ms 15 20,650 1s302ms 0ms 16 19,475 1s259ms 0ms 17 18,861 1s164ms 0ms 18 18,687 1s159ms 0ms 19 19,232 1s178ms 0ms 20 19,587 1s194ms 0ms 21 1,393 88ms 0ms 22 4 0ms 0ms 23 9,381 573ms 0ms 00 19,266 1s180ms 0ms [ User: symmetricds - Total duration: 26s426ms - Times executed: 410008 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s426ms - Times executed: 410008 ]
-
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 = '9195977' 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 = '9195457' 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 = '9196331' AND node_id = '2';
Date: 2019-08-10 01:14:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:55:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 11:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 16s251ms 2,716,351 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 10 01 125,935 742ms 0ms 02 125,145 735ms 0ms 03 125,140 729ms 0ms 04 125,240 763ms 0ms 05 125,245 737ms 0ms 06 125,235 741ms 0ms 07 125,132 754ms 0ms 08 125,208 744ms 0ms 09 125,238 758ms 0ms 10 125,031 753ms 0ms 11 125,521 743ms 0ms 12 124,970 746ms 0ms 13 125,089 739ms 0ms 14 125,146 763ms 0ms 15 125,138 752ms 0ms 16 125,199 765ms 0ms 17 125,150 758ms 0ms 18 125,091 743ms 0ms 19 125,071 753ms 0ms 20 125,128 761ms 0ms 21 18,369 101ms 0ms 22 5,326 34ms 0ms 23 63,749 394ms 0ms 00 124,855 732ms 0ms [ User: symmetricds - Total duration: 16s249ms - Times executed: 2716069 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 282 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s251ms - Times executed: 2716351 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-10 20:41:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 19:53:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 19:10:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 14s679ms 1,275,094 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 10 01 58,709 655ms 0ms 02 58,111 670ms 0ms 03 58,602 662ms 0ms 04 58,716 680ms 0ms 05 58,191 668ms 0ms 06 59,564 690ms 0ms 07 58,885 680ms 0ms 08 58,457 666ms 0ms 09 58,853 682ms 0ms 10 59,367 703ms 0ms 11 58,871 684ms 0ms 12 58,939 692ms 0ms 13 58,690 669ms 0ms 14 59,867 702ms 0ms 15 60,659 709ms 0ms 16 59,498 697ms 0ms 17 58,872 665ms 0ms 18 58,678 665ms 0ms 19 59,217 689ms 0ms 20 59,590 677ms 0ms 21 6,084 63ms 0ms 22 378 6ms 0ms 23 29,098 332ms 0ms 00 59,198 657ms 0ms [ User: symmetricds - Total duration: 14s679ms - Times executed: 1275094 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s679ms - Times executed: 1275094 ]
-
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-10 05:18:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 04:13:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:07:58 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 14s317ms 1,850 2ms 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 #13
Day Hour Count Duration Avg duration Aug 10 01 81 650ms 8ms 02 81 604ms 7ms 03 81 624ms 7ms 04 81 610ms 7ms 05 81 896ms 11ms 06 81 595ms 7ms 07 81 582ms 7ms 08 81 646ms 7ms 09 81 544ms 6ms 10 81 598ms 7ms 11 81 560ms 6ms 12 81 564ms 6ms 13 81 573ms 7ms 14 81 673ms 8ms 15 81 604ms 7ms 16 81 675ms 8ms 17 81 577ms 7ms 18 81 680ms 8ms 19 81 620ms 7ms 20 81 616ms 7ms 21 81 732ms 9ms 22 61 429ms 7ms 23 7 51ms 7ms 00 81 603ms 7ms [ User: symmetricds - Total duration: 14s317ms - Times executed: 1850 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s317ms - Times executed: 1850 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104814167' AND '104819167' AND data_id < '105133334' AND create_time < '2019-08-09 20:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104814167' AND '104819167');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104949194' AND '104954194' AND data_id < '105133118' AND create_time < '2019-08-09 02:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104949194' AND '104954194');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104809166' AND '104814166' AND data_id < '105133334' AND create_time < '2019-08-09 20:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104809166' AND '104814166');
Date: 2019-08-10 20:00:02 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 02:00:02 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 14s215ms 1,275,090 0ms 12ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 10 01 58,706 635ms 0ms 02 58,114 651ms 0ms 03 58,602 640ms 0ms 04 58,716 659ms 0ms 05 58,191 645ms 0ms 06 59,564 666ms 0ms 07 58,885 661ms 0ms 08 58,455 646ms 0ms 09 58,852 675ms 0ms 10 59,367 677ms 0ms 11 58,872 669ms 0ms 12 58,939 667ms 0ms 13 58,691 652ms 0ms 14 59,866 673ms 0ms 15 60,658 682ms 0ms 16 59,499 675ms 0ms 17 58,872 642ms 0ms 18 58,678 639ms 0ms 19 59,218 667ms 0ms 20 59,589 658ms 0ms 21 6,082 60ms 0ms 22 380 4ms 0ms 23 29,096 319ms 0ms 00 59,198 642ms 0ms [ User: symmetricds - Total duration: 14s215ms - Times executed: 1275090 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s215ms - Times executed: 1275090 ]
-
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-10 08:06:57 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:50:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 10:18:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8s853ms 17,199 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 10 01 717 363ms 0ms 02 718 365ms 0ms 03 716 354ms 0ms 04 718 361ms 0ms 05 716 365ms 0ms 06 718 365ms 0ms 07 714 359ms 0ms 08 718 368ms 0ms 09 716 358ms 0ms 10 716 361ms 0ms 11 716 357ms 0ms 12 718 366ms 0ms 13 716 352ms 0ms 14 718 366ms 0ms 15 714 371ms 0ms 16 716 364ms 0ms 17 716 372ms 0ms 18 718 364ms 0ms 19 716 361ms 0ms 20 718 364ms 0ms 21 716 410ms 0ms 22 716 423ms 0ms 23 718 390ms 0ms 00 716 363ms 0ms [ User: symmetricds - Total duration: 8s853ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s853ms - Times executed: 17199 ]
-
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-10 05:59:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:06:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:16:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 5s438ms 23 225ms 260ms 236ms 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 10 01 1 253ms 253ms 02 1 236ms 236ms 03 1 234ms 234ms 04 1 231ms 231ms 05 1 225ms 225ms 06 1 229ms 229ms 07 1 226ms 226ms 09 1 228ms 228ms 10 1 225ms 225ms 11 1 233ms 233ms 12 1 232ms 232ms 13 1 226ms 226ms 14 1 233ms 233ms 15 1 240ms 240ms 16 1 237ms 237ms 17 1 231ms 231ms 18 1 258ms 258ms 19 1 260ms 260ms 20 1 252ms 252ms 21 1 246ms 246ms 22 1 225ms 225ms 23 1 230ms 230ms 00 1 236ms 236ms [ User: symmetricds - Total duration: 5s438ms - Times executed: 23 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s438ms - Times executed: 23 ]
-
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-10 18:00:03 Duration: 260ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 17:00:03 Duration: 258ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:00:03 Duration: 253ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 3s409ms 945 1ms 17ms 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 10 01 38 132ms 3ms 02 38 130ms 3ms 03 38 124ms 3ms 04 39 136ms 3ms 05 40 137ms 3ms 06 42 150ms 3ms 07 44 155ms 3ms 08 41 139ms 3ms 09 44 154ms 3ms 10 47 170ms 3ms 11 48 171ms 3ms 12 43 150ms 3ms 13 48 177ms 3ms 14 49 176ms 3ms 15 42 145ms 3ms 16 46 168ms 3ms 17 41 141ms 3ms 18 38 129ms 3ms 19 34 118ms 3ms 20 37 123ms 3ms 21 24 116ms 4ms 22 25 124ms 4ms 23 33 138ms 4ms 00 26 94ms 3ms [ User: symmetricds - Total duration: 3s409ms - Times executed: 945 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s409ms - Times executed: 945 ]
-
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-10 20:20:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 22:35:56 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 21:20:55 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 2s938ms 551 4ms 14ms 5ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 10 01 131 652ms 4ms 02 19 95ms 5ms 03 19 96ms 5ms 04 19 95ms 5ms 05 19 93ms 4ms 06 19 94ms 4ms 07 19 91ms 4ms 08 19 97ms 5ms 09 19 104ms 5ms 10 19 107ms 5ms 11 19 96ms 5ms 12 19 96ms 5ms 13 19 105ms 5ms 14 19 93ms 4ms 15 19 97ms 5ms 16 19 95ms 5ms 17 19 96ms 5ms 18 19 100ms 5ms 19 19 96ms 5ms 20 19 96ms 5ms 21 19 96ms 5ms 22 2 18ms 9ms 23 19 160ms 8ms 00 19 159ms 8ms [ User: symmetricds - Total duration: 2s735ms - Times executed: 506 ]
[ User: pharmisight - Total duration: 203ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s938ms - Times executed: 551 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-10 22:13:58 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 05:15:18 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 2s880ms 50,372 0ms 2ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 10 01 3,084 105ms 0ms 02 2,056 104ms 0ms 03 2,056 116ms 0ms 04 2,056 72ms 0ms 05 2,056 111ms 0ms 06 2,056 75ms 0ms 07 2,056 105ms 0ms 08 2,056 112ms 0ms 09 2,056 117ms 0ms 10 2,056 119ms 0ms 11 2,056 157ms 0ms 12 2,056 113ms 0ms 13 2,056 124ms 0ms 14 2,056 158ms 0ms 15 2,056 115ms 0ms 16 2,056 140ms 0ms 17 2,056 147ms 0ms 18 2,056 119ms 0ms 19 2,056 139ms 0ms 20 2,056 127ms 0ms 21 2,056 117ms 0ms 22 2,056 111ms 0ms 23 2,056 126ms 0ms 00 2,056 140ms 0ms [ User: pharmisight - Total duration: 2s880ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s880ms - 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 = '2967' 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 = '20482647' 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 = '33074331' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-10 18:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2s570ms 44,688 0ms 2ms 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 10 01 2,736 94ms 0ms 02 1,824 93ms 0ms 03 1,824 102ms 0ms 04 1,824 64ms 0ms 05 1,824 98ms 0ms 06 1,824 68ms 0ms 07 1,824 94ms 0ms 08 1,824 98ms 0ms 09 1,824 104ms 0ms 10 1,824 104ms 0ms 11 1,824 136ms 0ms 12 1,824 99ms 0ms 13 1,824 109ms 0ms 14 1,824 143ms 0ms 15 1,824 103ms 0ms 16 1,824 132ms 0ms 17 1,824 133ms 0ms 18 1,824 107ms 0ms 19 1,824 120ms 0ms 20 1,824 111ms 0ms 21 1,824 106ms 0ms 22 1,824 100ms 0ms 23 1,824 111ms 0ms 00 1,824 126ms 0ms [ User: pharmisight - Total duration: 2s570ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s570ms - 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 = '33074376' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '20482651' ORDER BY itembarcod0_.barcode ASC;
-
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 = '3270' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-10 16:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms 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 6,809,961 1m39s 0ms 24ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 10 01 312,932 4s588ms 0ms 02 310,602 4s494ms 0ms 03 312,059 4s472ms 0ms 04 312,705 4s602ms 0ms 05 311,135 4s489ms 0ms 06 315,232 4s643ms 0ms 07 313,073 4s614ms 0ms 08 311,912 4s526ms 0ms 09 313,101 4s626ms 0ms 10 314,435 4s651ms 0ms 11 313,447 4s528ms 0ms 12 313,129 4s635ms 0ms 13 312,478 4s523ms 0ms 14 316,069 4s596ms 0ms 15 318,430 4s612ms 0ms 16 315,031 4s612ms 0ms 17 313,086 4s498ms 0ms 18 312,457 4s425ms 0ms 19 314,037 4s528ms 0ms 20 315,222 4s539ms 0ms 21 47,082 651ms 0ms 22 16,846 284ms 0ms 23 161,789 2s399ms 0ms 00 313,672 4s452ms 0ms [ User: symmetricds - Total duration: 1m38s - Times executed: 6809390 ]
[ User: pharmisight - Total duration: 26ms - Times executed: 571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m39s - Times executed: 6809961 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-10 11:26:59 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:34:57 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 21:29:55 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4,006,321 38s31ms 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 10 01 185,696 1s766ms 0ms 02 183,858 1s734ms 0ms 03 184,350 1s710ms 0ms 04 184,563 1s746ms 0ms 05 184,039 1s741ms 0ms 06 185,399 1s811ms 0ms 07 184,624 1s749ms 0ms 08 184,269 1s756ms 0ms 09 184,697 1s781ms 0ms 10 185,004 1s789ms 0ms 11 185,001 1s735ms 0ms 12 184,522 1s750ms 0ms 13 184,387 1s722ms 0ms 14 185,621 1s776ms 0ms 15 186,405 1s821ms 0ms 16 185,303 1s754ms 0ms 17 184,633 1s744ms 0ms 18 184,380 1s720ms 0ms 19 184,897 1s745ms 0ms 20 185,325 1s759ms 0ms 21 25,048 225ms 0ms 22 6,277 73ms 0ms 23 93,362 899ms 0ms 00 184,661 1s714ms 0ms [ User: symmetricds - Total duration: 38s31ms - Times executed: 4006321 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s31ms - Times executed: 4006321 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-10 08:38:57 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 18:16:54 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 17:26:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2,716,351 16s251ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 10 01 125,935 742ms 0ms 02 125,145 735ms 0ms 03 125,140 729ms 0ms 04 125,240 763ms 0ms 05 125,245 737ms 0ms 06 125,235 741ms 0ms 07 125,132 754ms 0ms 08 125,208 744ms 0ms 09 125,238 758ms 0ms 10 125,031 753ms 0ms 11 125,521 743ms 0ms 12 124,970 746ms 0ms 13 125,089 739ms 0ms 14 125,146 763ms 0ms 15 125,138 752ms 0ms 16 125,199 765ms 0ms 17 125,150 758ms 0ms 18 125,091 743ms 0ms 19 125,071 753ms 0ms 20 125,128 761ms 0ms 21 18,369 101ms 0ms 22 5,326 34ms 0ms 23 63,749 394ms 0ms 00 124,855 732ms 0ms [ User: symmetricds - Total duration: 16s249ms - Times executed: 2716069 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 282 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s251ms - Times executed: 2716351 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-10 20:41:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 19:53:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 19:10:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2,716,350 14m52s 0ms 276ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 10 01 125,934 41s519ms 0ms 02 125,145 40s850ms 0ms 03 125,140 41s272ms 0ms 04 125,240 38s933ms 0ms 05 125,245 41s255ms 0ms 06 125,235 40s224ms 0ms 07 125,132 40s957ms 0ms 08 125,208 40s433ms 0ms 09 125,237 40s162ms 0ms 10 125,032 41s623ms 0ms 11 125,521 41s255ms 0ms 12 124,970 39s679ms 0ms 13 125,089 42s216ms 0ms 14 125,146 41s215ms 0ms 15 125,137 43s687ms 0ms 16 125,200 42s646ms 0ms 17 125,150 40s875ms 0ms 18 125,090 44s657ms 0ms 19 125,072 41s248ms 0ms 20 125,128 42s573ms 0ms 21 18,368 4s148ms 0ms 22 5,327 173ms 0ms 23 63,749 20s218ms 0ms 00 124,855 41s48ms 0ms [ User: symmetricds - Total duration: 14m52s - Times executed: 2716069 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 281 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m52s - Times executed: 2716350 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-10 19:20:04 Duration: 276ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 82ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1,714,794 6m33s 0ms 16ms 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 10 01 79,444 18s275ms 0ms 02 79,444 17s940ms 0ms 03 79,443 17s791ms 0ms 04 79,444 18s348ms 0ms 05 79,444 18s202ms 0ms 06 79,444 18s523ms 0ms 07 79,385 18s200ms 0ms 08 79,416 18s414ms 0ms 09 79,452 18s523ms 0ms 10 79,324 18s763ms 0ms 11 79,642 18s166ms 0ms 12 79,267 18s305ms 0ms 13 79,353 18s188ms 0ms 14 79,389 18s342ms 0ms 15 79,389 18s760ms 0ms 16 79,420 18s252ms 0ms 17 79,394 18s95ms 0ms 18 79,352 17s910ms 0ms 19 79,345 17s987ms 0ms 20 79,378 18s16ms 0ms 21 8,649 1s712ms 0ms 22 4 1ms 0ms 23 38,742 9s143ms 0ms 00 79,230 17s887ms 0ms [ User: symmetricds - Total duration: 6m33s - Times executed: 1714794 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m33s - Times executed: 1714794 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '2452', extract_count = '10908', sent_count = '10907', load_count = '10907', data_row_count = '4', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:27:48.859', transfer_start_time = '2019-08-10 08:59:00.323', 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 = 'flow_reports, order_rounds', 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 = '4', extract_insert_row_count = '1', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195667' 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 = '8757', extract_count = '10542', sent_count = '10541', load_count = '10541', data_row_count = '19', reload_row_count = '0', data_insert_row_count = '8', data_update_row_count = '11', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '21', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:32:46.437', transfer_start_time = '2019-08-10 01:57:56.192', 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 = 'rx_line_activities, order_lines, order_line_activities, orders', 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 = '19', extract_insert_row_count = '8', extract_update_row_count = '11', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195393' 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 = '9471', extract_count = '11201', sent_count = '11200', load_count = '11200', data_row_count = '23', reload_row_count = '0', data_insert_row_count = '10', data_update_row_count = '13', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '34', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 15:37:46.804', transfer_start_time = '2019-08-10 13:01:57.335', 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 = '23', extract_insert_row_count = '10', extract_update_row_count = '13', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195455' AND node_id = '2';
Date: 2019-08-10 09:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 01:58:56 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:02:56 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1,275,094 14s679ms 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 10 01 58,709 655ms 0ms 02 58,111 670ms 0ms 03 58,602 662ms 0ms 04 58,716 680ms 0ms 05 58,191 668ms 0ms 06 59,564 690ms 0ms 07 58,885 680ms 0ms 08 58,457 666ms 0ms 09 58,853 682ms 0ms 10 59,367 703ms 0ms 11 58,871 684ms 0ms 12 58,939 692ms 0ms 13 58,690 669ms 0ms 14 59,867 702ms 0ms 15 60,659 709ms 0ms 16 59,498 697ms 0ms 17 58,872 665ms 0ms 18 58,678 665ms 0ms 19 59,217 689ms 0ms 20 59,590 677ms 0ms 21 6,084 63ms 0ms 22 378 6ms 0ms 23 29,098 332ms 0ms 00 59,198 657ms 0ms [ User: symmetricds - Total duration: 14s679ms - Times executed: 1275094 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s679ms - Times executed: 1275094 ]
-
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-10 05:18:26 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 04:13:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:07:58 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1,275,090 14s215ms 0ms 12ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 10 01 58,706 635ms 0ms 02 58,114 651ms 0ms 03 58,602 640ms 0ms 04 58,716 659ms 0ms 05 58,191 645ms 0ms 06 59,564 666ms 0ms 07 58,885 661ms 0ms 08 58,455 646ms 0ms 09 58,852 675ms 0ms 10 59,367 677ms 0ms 11 58,872 669ms 0ms 12 58,939 667ms 0ms 13 58,691 652ms 0ms 14 59,866 673ms 0ms 15 60,658 682ms 0ms 16 59,499 675ms 0ms 17 58,872 642ms 0ms 18 58,678 639ms 0ms 19 59,218 667ms 0ms 20 59,589 658ms 0ms 21 6,082 60ms 0ms 22 380 4ms 0ms 23 29,096 319ms 0ms 00 59,198 642ms 0ms [ User: symmetricds - Total duration: 14s215ms - Times executed: 1275090 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s215ms - Times executed: 1275090 ]
-
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-10 08:06:57 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:50:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 10:18:55 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 879,827 36s675ms 0ms 10ms 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 10 01 40,680 1s665ms 0ms 02 40,682 1s674ms 0ms 03 40,680 1s657ms 0ms 04 40,682 1s703ms 0ms 05 40,680 1s685ms 0ms 06 40,682 1s701ms 0ms 07 40,647 1s721ms 0ms 08 40,667 1s685ms 0ms 09 40,685 1s706ms 0ms 10 40,618 1s697ms 0ms 11 40,783 1s692ms 0ms 12 40,590 1s694ms 0ms 13 40,635 1s696ms 0ms 14 40,655 1s715ms 0ms 15 40,650 1s731ms 0ms 16 40,669 1s712ms 0ms 17 40,655 1s681ms 0ms 18 40,637 1s677ms 0ms 19 40,631 1s701ms 0ms 20 40,649 1s702ms 0ms 21 5,070 195ms 0ms 22 720 39ms 0ms 23 20,208 868ms 0ms 00 40,572 1s666ms 0ms [ User: symmetricds - Total duration: 36s675ms - Times executed: 879827 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s675ms - Times executed: 879827 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
Date: 2019-08-10 14:56:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:36:58 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 16:56:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 854,864 3m7s 0ms 17ms 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 10 01 39,604 8s620ms 0ms 02 39,604 8s617ms 0ms 03 39,604 8s680ms 0ms 04 39,604 8s856ms 0ms 05 39,604 8s783ms 0ms 06 39,604 8s852ms 0ms 07 39,577 8s887ms 0ms 08 39,590 8s767ms 0ms 09 39,608 8s728ms 0ms 10 39,545 8s801ms 0ms 11 39,700 8s647ms 0ms 12 39,519 8s615ms 0ms 13 39,559 8s668ms 0ms 14 39,576 8s702ms 0ms 15 39,577 8s675ms 0ms 16 39,593 8s738ms 0ms 17 39,579 8s610ms 0ms 18 39,558 8s454ms 0ms 19 39,555 8s671ms 0ms 20 39,572 8s572ms 0ms 21 4,311 828ms 0ms 22 4 0ms 0ms 23 19,316 4s297ms 0ms 00 39,501 8s541ms 0ms [ User: symmetricds - Total duration: 3m7s - Times executed: 854864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m7s - Times executed: 854864 ]
-
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 = '9195575' 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 = '9195447' 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 = '9195213' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-10 07:57:59 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:32:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:52:53 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 410,008 26s426ms 0ms 2ms 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 10 01 18,670 1s224ms 0ms 02 18,077 1s231ms 0ms 03 18,567 1s210ms 0ms 04 18,679 1s250ms 0ms 05 18,155 1s162ms 0ms 06 19,526 1s274ms 0ms 07 18,878 1s247ms 0ms 08 18,434 1s202ms 0ms 09 18,812 1s262ms 0ms 10 19,391 1s296ms 0ms 11 18,739 1s240ms 0ms 12 18,987 1s276ms 0ms 13 18,700 1s181ms 0ms 14 19,857 1s264ms 0ms 15 20,650 1s302ms 0ms 16 19,475 1s259ms 0ms 17 18,861 1s164ms 0ms 18 18,687 1s159ms 0ms 19 19,232 1s178ms 0ms 20 19,587 1s194ms 0ms 21 1,393 88ms 0ms 22 4 0ms 0ms 23 9,381 573ms 0ms 00 19,266 1s180ms 0ms [ User: symmetricds - Total duration: 26s426ms - Times executed: 410008 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s426ms - Times executed: 410008 ]
-
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 = '9195977' 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 = '9195457' 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 = '9196331' AND node_id = '2';
Date: 2019-08-10 01:14:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:55:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 11:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 207,744 4m55s 0ms 146ms 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 10 01 9,604 14s371ms 1ms 02 9,604 13s871ms 1ms 03 9,604 13s696ms 1ms 04 9,604 13s713ms 1ms 05 9,604 13s548ms 1ms 06 9,604 13s91ms 1ms 07 9,604 13s531ms 1ms 08 9,604 13s448ms 1ms 09 9,604 13s284ms 1ms 10 9,604 13s637ms 1ms 11 9,604 13s584ms 1ms 12 9,604 13s694ms 1ms 13 9,604 13s843ms 1ms 14 9,604 13s876ms 1ms 15 9,604 13s616ms 1ms 16 9,604 13s364ms 1ms 17 9,604 13s630ms 1ms 18 9,604 13s756ms 1ms 19 9,604 13s697ms 1ms 20 9,604 13s584ms 1ms 21 1,072 1s295ms 1ms 22 124 128ms 1ms 23 4,864 7s414ms 1ms 00 9,604 14s153ms 1ms [ User: symmetricds - Total duration: 4m55s - Times executed: 207744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 207744 ]
-
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-10 22:50:56 Duration: 146ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:47:49 Duration: 135ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 22:51:56 Duration: 133ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 76,800 1m29s 0ms 111ms 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 10 01 3,200 4s57ms 1ms 02 3,200 3s841ms 1ms 03 3,200 3s523ms 1ms 04 3,200 3s802ms 1ms 05 3,200 3s509ms 1ms 06 3,200 3s614ms 1ms 07 3,200 3s460ms 1ms 08 3,200 3s726ms 1ms 09 3,200 3s655ms 1ms 10 3,200 4s20ms 1ms 11 3,200 3s547ms 1ms 12 3,200 3s383ms 1ms 13 3,200 3s494ms 1ms 14 3,200 3s528ms 1ms 15 3,200 3s457ms 1ms 16 3,200 3s673ms 1ms 17 3,200 3s686ms 1ms 18 3,200 3s744ms 1ms 19 3,200 3s637ms 1ms 20 3,200 3s733ms 1ms 21 3,200 4s69ms 1ms 22 3,200 4s357ms 1ms 23 3,200 4s52ms 1ms 00 3,200 3s809ms 1ms [ User: symmetricds - Total duration: 1m29s - Times executed: 76800 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m29s - Times executed: 76800 ]
-
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-10 23:35:57 Duration: 111ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 23:41:57 Duration: 55ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:02:50 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 50,372 2s880ms 0ms 2ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 10 01 3,084 105ms 0ms 02 2,056 104ms 0ms 03 2,056 116ms 0ms 04 2,056 72ms 0ms 05 2,056 111ms 0ms 06 2,056 75ms 0ms 07 2,056 105ms 0ms 08 2,056 112ms 0ms 09 2,056 117ms 0ms 10 2,056 119ms 0ms 11 2,056 157ms 0ms 12 2,056 113ms 0ms 13 2,056 124ms 0ms 14 2,056 158ms 0ms 15 2,056 115ms 0ms 16 2,056 140ms 0ms 17 2,056 147ms 0ms 18 2,056 119ms 0ms 19 2,056 139ms 0ms 20 2,056 127ms 0ms 21 2,056 117ms 0ms 22 2,056 111ms 0ms 23 2,056 126ms 0ms 00 2,056 140ms 0ms [ User: pharmisight - Total duration: 2s880ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s880ms - 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 = '2967' 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 = '20482647' 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 = '33074331' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-10 18:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 44,688 2s570ms 0ms 2ms 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 10 01 2,736 94ms 0ms 02 1,824 93ms 0ms 03 1,824 102ms 0ms 04 1,824 64ms 0ms 05 1,824 98ms 0ms 06 1,824 68ms 0ms 07 1,824 94ms 0ms 08 1,824 98ms 0ms 09 1,824 104ms 0ms 10 1,824 104ms 0ms 11 1,824 136ms 0ms 12 1,824 99ms 0ms 13 1,824 109ms 0ms 14 1,824 143ms 0ms 15 1,824 103ms 0ms 16 1,824 132ms 0ms 17 1,824 133ms 0ms 18 1,824 107ms 0ms 19 1,824 120ms 0ms 20 1,824 111ms 0ms 21 1,824 106ms 0ms 22 1,824 100ms 0ms 23 1,824 111ms 0ms 00 1,824 126ms 0ms [ User: pharmisight - Total duration: 2s570ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s570ms - 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 = '33074376' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '20482651' ORDER BY itembarcod0_.barcode ASC;
-
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 = '3270' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-10 16:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 25,028 1s180ms 0ms 3ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 10 01 1,108 52ms 0ms 02 1,052 48ms 0ms 03 1,050 52ms 0ms 04 1,052 50ms 0ms 05 1,050 48ms 0ms 06 1,050 49ms 0ms 07 1,046 47ms 0ms 08 1,052 48ms 0ms 09 1,046 50ms 0ms 10 1,044 48ms 0ms 11 1,044 47ms 0ms 12 1,046 47ms 0ms 13 1,044 46ms 0ms 14 1,046 48ms 0ms 15 1,042 46ms 0ms 16 1,044 49ms 0ms 17 1,044 47ms 0ms 18 1,046 47ms 0ms 19 1,044 48ms 0ms 20 1,046 47ms 0ms 21 988 52ms 0ms 22 984 53ms 0ms 23 1,016 48ms 0ms 00 1,044 50ms 0ms [ User: symmetricds - Total duration: 1s180ms - Times executed: 25028 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 25028 ]
-
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-10 21:56:51 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:43:55 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:12:51 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 17,246 454ms 0ms 0ms 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 10 01 718 17ms 0ms 02 718 18ms 0ms 03 720 19ms 0ms 04 718 17ms 0ms 05 720 17ms 0ms 06 718 18ms 0ms 07 720 18ms 0ms 08 718 18ms 0ms 09 718 18ms 0ms 10 720 19ms 0ms 11 718 18ms 0ms 12 720 18ms 0ms 13 718 18ms 0ms 14 718 18ms 0ms 15 720 19ms 0ms 16 720 19ms 0ms 17 720 18ms 0ms 18 718 18ms 0ms 19 720 19ms 0ms 20 714 18ms 0ms 21 720 21ms 0ms 22 718 21ms 0ms 23 718 20ms 0ms 00 716 18ms 0ms [ User: symmetricds - Total duration: 454ms - Times executed: 17246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 454ms - Times executed: 17246 ]
-
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-10 02:46:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 01:21:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:44:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 17,199 8s853ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 10 01 717 363ms 0ms 02 718 365ms 0ms 03 716 354ms 0ms 04 718 361ms 0ms 05 716 365ms 0ms 06 718 365ms 0ms 07 714 359ms 0ms 08 718 368ms 0ms 09 716 358ms 0ms 10 716 361ms 0ms 11 716 357ms 0ms 12 718 366ms 0ms 13 716 352ms 0ms 14 718 366ms 0ms 15 714 371ms 0ms 16 716 364ms 0ms 17 716 372ms 0ms 18 718 364ms 0ms 19 716 361ms 0ms 20 718 364ms 0ms 21 716 410ms 0ms 22 716 423ms 0ms 23 718 390ms 0ms 00 716 363ms 0ms [ User: symmetricds - Total duration: 8s853ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s853ms - Times executed: 17199 ]
-
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-10 05:59:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:06:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:16:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 8,599 285ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 10 01 358 11ms 0ms 02 359 11ms 0ms 03 358 11ms 0ms 04 359 11ms 0ms 05 358 11ms 0ms 06 359 11ms 0ms 07 357 12ms 0ms 08 359 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 11ms 0ms 12 359 11ms 0ms 13 358 11ms 0ms 14 359 12ms 0ms 15 357 11ms 0ms 16 358 11ms 0ms 17 358 11ms 0ms 18 359 11ms 0ms 19 358 11ms 0ms 20 359 11ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 359 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 285ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 285ms - Times executed: 8599 ]
-
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-10 06:39:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:57:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 10:14:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 8,598 262ms 0ms 0ms 0ms 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 10 01 358 10ms 0ms 02 359 10ms 0ms 03 358 10ms 0ms 04 359 10ms 0ms 05 358 10ms 0ms 06 359 10ms 0ms 07 357 10ms 0ms 08 359 11ms 0ms 09 357 10ms 0ms 10 358 10ms 0ms 11 358 10ms 0ms 12 359 10ms 0ms 13 358 10ms 0ms 14 359 10ms 0ms 15 357 10ms 0ms 16 358 10ms 0ms 17 358 10ms 0ms 18 359 10ms 0ms 19 358 11ms 0ms 20 359 10ms 0ms 21 358 11ms 0ms 22 358 12ms 0ms 23 359 11ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 262ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 262ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133310' AND '155133309'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133378' AND '155133377'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133262' AND '155133261'));
Date: 2019-08-10 18:04:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 23:41:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:53:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 8,598 207ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 10 01 358 8ms 0ms 02 359 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 359 8ms 0ms 07 357 8ms 0ms 08 359 8ms 0ms 09 357 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 359 8ms 0ms 13 358 8ms 0ms 14 359 8ms 0ms 15 357 8ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 359 8ms 0ms 19 358 8ms 0ms 20 359 8ms 0ms 21 358 9ms 0ms 22 358 9ms 0ms 23 359 8ms 0ms 00 358 8ms 0ms [ User: symmetricds - Total duration: 207ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 207ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133289' AND data_id <= '155133288' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133313' AND data_id <= '155133312' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133336' AND data_id <= '155133335' ORDER BY data_id ASC;
Date: 2019-08-10 16:06:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 18:10:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:05:58 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 225ms 260ms 236ms 23 5s438ms 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 10 01 1 253ms 253ms 02 1 236ms 236ms 03 1 234ms 234ms 04 1 231ms 231ms 05 1 225ms 225ms 06 1 229ms 229ms 07 1 226ms 226ms 09 1 228ms 228ms 10 1 225ms 225ms 11 1 233ms 233ms 12 1 232ms 232ms 13 1 226ms 226ms 14 1 233ms 233ms 15 1 240ms 240ms 16 1 237ms 237ms 17 1 231ms 231ms 18 1 258ms 258ms 19 1 260ms 260ms 20 1 252ms 252ms 21 1 246ms 246ms 22 1 225ms 225ms 23 1 230ms 230ms 00 1 236ms 236ms [ User: symmetricds - Total duration: 5s438ms - Times executed: 23 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s438ms - Times executed: 23 ]
-
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-10 18:00:03 Duration: 260ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 17:00:03 Duration: 258ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:00:03 Duration: 253ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 2ms 71ms 25ms 1,930 49s813ms 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 10 01 81 1s826ms 22ms 02 81 1s949ms 24ms 03 81 2s28ms 25ms 04 81 1s416ms 17ms 05 81 2s270ms 28ms 06 81 1s357ms 16ms 07 81 2s119ms 26ms 08 81 2s503ms 30ms 09 81 2s15ms 24ms 10 81 2s191ms 27ms 11 81 2s182ms 26ms 12 81 1s919ms 23ms 13 81 2s140ms 26ms 14 81 2s85ms 25ms 15 81 2s204ms 27ms 16 81 2s399ms 29ms 17 81 1s934ms 23ms 18 81 2s152ms 26ms 19 81 2s184ms 26ms 20 81 2s151ms 26ms 21 81 2s290ms 28ms 22 81 2s249ms 27ms 23 67 1s933ms 28ms 00 81 2s303ms 28ms [ User: symmetricds - Total duration: 49s813ms - Times executed: 1930 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s813ms - Times executed: 1930 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '105059216' AND '105064216' AND create_time < '2019-08-09 04:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105059216' AND '105064216') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '105059216' AND '105064216' 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 '104729150' AND '104734150' AND create_time < '2019-08-09 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104729150' AND '104734150') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104729150' AND '104734150' 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-09 12: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-10 04:00:02 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:00:00 Duration: 69ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:00:00 Duration: 68ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2ms 21ms 7ms 1,850 14s317ms 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 10 01 81 650ms 8ms 02 81 604ms 7ms 03 81 624ms 7ms 04 81 610ms 7ms 05 81 896ms 11ms 06 81 595ms 7ms 07 81 582ms 7ms 08 81 646ms 7ms 09 81 544ms 6ms 10 81 598ms 7ms 11 81 560ms 6ms 12 81 564ms 6ms 13 81 573ms 7ms 14 81 673ms 8ms 15 81 604ms 7ms 16 81 675ms 8ms 17 81 577ms 7ms 18 81 680ms 8ms 19 81 620ms 7ms 20 81 616ms 7ms 21 81 732ms 9ms 22 61 429ms 7ms 23 7 51ms 7ms 00 81 603ms 7ms [ User: symmetricds - Total duration: 14s317ms - Times executed: 1850 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s317ms - Times executed: 1850 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104814167' AND '104819167' AND data_id < '105133334' AND create_time < '2019-08-09 20:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104814167' AND '104819167');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104949194' AND '104954194' AND data_id < '105133118' AND create_time < '2019-08-09 02:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104949194' AND '104954194');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104809166' AND '104814166' AND data_id < '105133334' AND create_time < '2019-08-09 20:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104809166' AND '104814166');
Date: 2019-08-10 20:00:02 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 02:00:02 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:00:02 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 14ms 5ms 551 2s938ms 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 10 01 131 652ms 4ms 02 19 95ms 5ms 03 19 96ms 5ms 04 19 95ms 5ms 05 19 93ms 4ms 06 19 94ms 4ms 07 19 91ms 4ms 08 19 97ms 5ms 09 19 104ms 5ms 10 19 107ms 5ms 11 19 96ms 5ms 12 19 96ms 5ms 13 19 105ms 5ms 14 19 93ms 4ms 15 19 97ms 5ms 16 19 95ms 5ms 17 19 96ms 5ms 18 19 100ms 5ms 19 19 96ms 5ms 20 19 96ms 5ms 21 19 96ms 5ms 22 2 18ms 9ms 23 19 160ms 8ms 00 19 159ms 8ms [ User: symmetricds - Total duration: 2s735ms - Times executed: 506 ]
[ User: pharmisight - Total duration: 203ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s938ms - Times executed: 551 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-10 22:13:58 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 05:15:18 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 17ms 3ms 945 3s409ms 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 10 01 38 132ms 3ms 02 38 130ms 3ms 03 38 124ms 3ms 04 39 136ms 3ms 05 40 137ms 3ms 06 42 150ms 3ms 07 44 155ms 3ms 08 41 139ms 3ms 09 44 154ms 3ms 10 47 170ms 3ms 11 48 171ms 3ms 12 43 150ms 3ms 13 48 177ms 3ms 14 49 176ms 3ms 15 42 145ms 3ms 16 46 168ms 3ms 17 41 141ms 3ms 18 38 129ms 3ms 19 34 118ms 3ms 20 37 123ms 3ms 21 24 116ms 4ms 22 25 124ms 4ms 23 33 138ms 4ms 00 26 94ms 3ms [ User: symmetricds - Total duration: 3s409ms - Times executed: 945 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s409ms - Times executed: 945 ]
-
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-10 20:20:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 22:35:56 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 21:20:55 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 146ms 1ms 207,744 4m55s 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 10 01 9,604 14s371ms 1ms 02 9,604 13s871ms 1ms 03 9,604 13s696ms 1ms 04 9,604 13s713ms 1ms 05 9,604 13s548ms 1ms 06 9,604 13s91ms 1ms 07 9,604 13s531ms 1ms 08 9,604 13s448ms 1ms 09 9,604 13s284ms 1ms 10 9,604 13s637ms 1ms 11 9,604 13s584ms 1ms 12 9,604 13s694ms 1ms 13 9,604 13s843ms 1ms 14 9,604 13s876ms 1ms 15 9,604 13s616ms 1ms 16 9,604 13s364ms 1ms 17 9,604 13s630ms 1ms 18 9,604 13s756ms 1ms 19 9,604 13s697ms 1ms 20 9,604 13s584ms 1ms 21 1,072 1s295ms 1ms 22 124 128ms 1ms 23 4,864 7s414ms 1ms 00 9,604 14s153ms 1ms [ User: symmetricds - Total duration: 4m55s - Times executed: 207744 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 207744 ]
-
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-10 22:50:56 Duration: 146ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 00:47:49 Duration: 135ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 22:51:56 Duration: 133ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 111ms 1ms 76,800 1m29s 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 10 01 3,200 4s57ms 1ms 02 3,200 3s841ms 1ms 03 3,200 3s523ms 1ms 04 3,200 3s802ms 1ms 05 3,200 3s509ms 1ms 06 3,200 3s614ms 1ms 07 3,200 3s460ms 1ms 08 3,200 3s726ms 1ms 09 3,200 3s655ms 1ms 10 3,200 4s20ms 1ms 11 3,200 3s547ms 1ms 12 3,200 3s383ms 1ms 13 3,200 3s494ms 1ms 14 3,200 3s528ms 1ms 15 3,200 3s457ms 1ms 16 3,200 3s673ms 1ms 17 3,200 3s686ms 1ms 18 3,200 3s744ms 1ms 19 3,200 3s637ms 1ms 20 3,200 3s733ms 1ms 21 3,200 4s69ms 1ms 22 3,200 4s357ms 1ms 23 3,200 4s52ms 1ms 00 3,200 3s809ms 1ms [ User: symmetricds - Total duration: 1m29s - Times executed: 76800 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m29s - Times executed: 76800 ]
-
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-10 23:35:57 Duration: 111ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 23:41:57 Duration: 55ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:02:50 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 2ms 0ms 17,199 8s853ms 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 10 01 717 363ms 0ms 02 718 365ms 0ms 03 716 354ms 0ms 04 718 361ms 0ms 05 716 365ms 0ms 06 718 365ms 0ms 07 714 359ms 0ms 08 718 368ms 0ms 09 716 358ms 0ms 10 716 361ms 0ms 11 716 357ms 0ms 12 718 366ms 0ms 13 716 352ms 0ms 14 718 366ms 0ms 15 714 371ms 0ms 16 716 364ms 0ms 17 716 372ms 0ms 18 718 364ms 0ms 19 716 361ms 0ms 20 718 364ms 0ms 21 716 410ms 0ms 22 716 423ms 0ms 23 718 390ms 0ms 00 716 363ms 0ms [ User: symmetricds - Total duration: 8s853ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s853ms - Times executed: 17199 ]
-
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-10 05:59:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:06:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:16:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 276ms 0ms 2,716,350 14m52s COMMIT;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 10 01 125,934 41s519ms 0ms 02 125,145 40s850ms 0ms 03 125,140 41s272ms 0ms 04 125,240 38s933ms 0ms 05 125,245 41s255ms 0ms 06 125,235 40s224ms 0ms 07 125,132 40s957ms 0ms 08 125,208 40s433ms 0ms 09 125,237 40s162ms 0ms 10 125,032 41s623ms 0ms 11 125,521 41s255ms 0ms 12 124,970 39s679ms 0ms 13 125,089 42s216ms 0ms 14 125,146 41s215ms 0ms 15 125,137 43s687ms 0ms 16 125,200 42s646ms 0ms 17 125,150 40s875ms 0ms 18 125,090 44s657ms 0ms 19 125,072 41s248ms 0ms 20 125,128 42s573ms 0ms 21 18,368 4s148ms 0ms 22 5,327 173ms 0ms 23 63,749 20s218ms 0ms 00 124,855 41s48ms 0ms [ User: symmetricds - Total duration: 14m52s - Times executed: 2716069 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 281 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m52s - Times executed: 2716350 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-10 19:20:04 Duration: 276ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 82ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 06:50:53 Duration: 79ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 16ms 0ms 1,714,794 6m33s 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 10 01 79,444 18s275ms 0ms 02 79,444 17s940ms 0ms 03 79,443 17s791ms 0ms 04 79,444 18s348ms 0ms 05 79,444 18s202ms 0ms 06 79,444 18s523ms 0ms 07 79,385 18s200ms 0ms 08 79,416 18s414ms 0ms 09 79,452 18s523ms 0ms 10 79,324 18s763ms 0ms 11 79,642 18s166ms 0ms 12 79,267 18s305ms 0ms 13 79,353 18s188ms 0ms 14 79,389 18s342ms 0ms 15 79,389 18s760ms 0ms 16 79,420 18s252ms 0ms 17 79,394 18s95ms 0ms 18 79,352 17s910ms 0ms 19 79,345 17s987ms 0ms 20 79,378 18s16ms 0ms 21 8,649 1s712ms 0ms 22 4 1ms 0ms 23 38,742 9s143ms 0ms 00 79,230 17s887ms 0ms [ User: symmetricds - Total duration: 6m33s - Times executed: 1714794 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m33s - Times executed: 1714794 ]
-
UPDATE sym_outgoing_batch SET status = 'QY', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '2452', extract_count = '10908', sent_count = '10907', load_count = '10907', data_row_count = '4', reload_row_count = '0', data_insert_row_count = '1', data_update_row_count = '3', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '8', extract_start_time = '2019-08-01 16:27:48.859', transfer_start_time = '2019-08-10 08:59:00.323', 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 = 'flow_reports, order_rounds', 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 = '4', extract_insert_row_count = '1', extract_update_row_count = '3', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195667' 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 = '8757', extract_count = '10542', sent_count = '10541', load_count = '10541', data_row_count = '19', reload_row_count = '0', data_insert_row_count = '8', data_update_row_count = '11', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '21', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '10', extract_start_time = '2019-08-01 15:32:46.437', transfer_start_time = '2019-08-10 01:57:56.192', 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 = 'rx_line_activities, order_lines, order_line_activities, orders', 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 = '19', extract_insert_row_count = '8', extract_update_row_count = '11', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195393' 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 = '9471', extract_count = '11201', sent_count = '11200', load_count = '11200', data_row_count = '23', reload_row_count = '0', data_insert_row_count = '10', data_update_row_count = '13', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '34', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '6', extract_start_time = '2019-08-01 15:37:46.804', transfer_start_time = '2019-08-10 13:01:57.335', 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 = '23', extract_insert_row_count = '10', extract_update_row_count = '13', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195455' AND node_id = '2';
Date: 2019-08-10 09:00:00 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 01:58:56 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:02:56 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 17ms 0ms 854,864 3m7s 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 10 01 39,604 8s620ms 0ms 02 39,604 8s617ms 0ms 03 39,604 8s680ms 0ms 04 39,604 8s856ms 0ms 05 39,604 8s783ms 0ms 06 39,604 8s852ms 0ms 07 39,577 8s887ms 0ms 08 39,590 8s767ms 0ms 09 39,608 8s728ms 0ms 10 39,545 8s801ms 0ms 11 39,700 8s647ms 0ms 12 39,519 8s615ms 0ms 13 39,559 8s668ms 0ms 14 39,576 8s702ms 0ms 15 39,577 8s675ms 0ms 16 39,593 8s738ms 0ms 17 39,579 8s610ms 0ms 18 39,558 8s454ms 0ms 19 39,555 8s671ms 0ms 20 39,572 8s572ms 0ms 21 4,311 828ms 0ms 22 4 0ms 0ms 23 19,316 4s297ms 0ms 00 39,501 8s541ms 0ms [ User: symmetricds - Total duration: 3m7s - Times executed: 854864 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m7s - Times executed: 854864 ]
-
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 = '9195575' 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 = '9195447' 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 = '9195213' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-10 07:57:59 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:32:57 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 03:52:53 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 410,008 26s426ms 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 10 01 18,670 1s224ms 0ms 02 18,077 1s231ms 0ms 03 18,567 1s210ms 0ms 04 18,679 1s250ms 0ms 05 18,155 1s162ms 0ms 06 19,526 1s274ms 0ms 07 18,878 1s247ms 0ms 08 18,434 1s202ms 0ms 09 18,812 1s262ms 0ms 10 19,391 1s296ms 0ms 11 18,739 1s240ms 0ms 12 18,987 1s276ms 0ms 13 18,700 1s181ms 0ms 14 19,857 1s264ms 0ms 15 20,650 1s302ms 0ms 16 19,475 1s259ms 0ms 17 18,861 1s164ms 0ms 18 18,687 1s159ms 0ms 19 19,232 1s178ms 0ms 20 19,587 1s194ms 0ms 21 1,393 88ms 0ms 22 4 0ms 0ms 23 9,381 573ms 0ms 00 19,266 1s180ms 0ms [ User: symmetricds - Total duration: 26s426ms - Times executed: 410008 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s426ms - Times executed: 410008 ]
-
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 = '9195977' 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 = '9195457' 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 = '9196331' AND node_id = '2';
Date: 2019-08-10 01:14:58 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:55:59 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 11:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 2ms 0ms 44,688 2s570ms 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 10 01 2,736 94ms 0ms 02 1,824 93ms 0ms 03 1,824 102ms 0ms 04 1,824 64ms 0ms 05 1,824 98ms 0ms 06 1,824 68ms 0ms 07 1,824 94ms 0ms 08 1,824 98ms 0ms 09 1,824 104ms 0ms 10 1,824 104ms 0ms 11 1,824 136ms 0ms 12 1,824 99ms 0ms 13 1,824 109ms 0ms 14 1,824 143ms 0ms 15 1,824 103ms 0ms 16 1,824 132ms 0ms 17 1,824 133ms 0ms 18 1,824 107ms 0ms 19 1,824 120ms 0ms 20 1,824 111ms 0ms 21 1,824 106ms 0ms 22 1,824 100ms 0ms 23 1,824 111ms 0ms 00 1,824 126ms 0ms [ User: pharmisight - Total duration: 2s570ms - Times executed: 44688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s570ms - 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 = '33074376' ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '20482651' ORDER BY itembarcod0_.barcode ASC;
-
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 = '3270' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-10 16:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 15:00:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 2ms 0ms 50,372 2s880ms 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 10 01 3,084 105ms 0ms 02 2,056 104ms 0ms 03 2,056 116ms 0ms 04 2,056 72ms 0ms 05 2,056 111ms 0ms 06 2,056 75ms 0ms 07 2,056 105ms 0ms 08 2,056 112ms 0ms 09 2,056 117ms 0ms 10 2,056 119ms 0ms 11 2,056 157ms 0ms 12 2,056 113ms 0ms 13 2,056 124ms 0ms 14 2,056 158ms 0ms 15 2,056 115ms 0ms 16 2,056 140ms 0ms 17 2,056 147ms 0ms 18 2,056 119ms 0ms 19 2,056 139ms 0ms 20 2,056 127ms 0ms 21 2,056 117ms 0ms 22 2,056 111ms 0ms 23 2,056 126ms 0ms 00 2,056 140ms 0ms [ User: pharmisight - Total duration: 2s880ms - Times executed: 50372 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s880ms - 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 = '2967' 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 = '20482647' 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 = '33074331' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-10 18:20:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 12:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 3ms 0ms 25,028 1s180ms 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 10 01 1,108 52ms 0ms 02 1,052 48ms 0ms 03 1,050 52ms 0ms 04 1,052 50ms 0ms 05 1,050 48ms 0ms 06 1,050 49ms 0ms 07 1,046 47ms 0ms 08 1,052 48ms 0ms 09 1,046 50ms 0ms 10 1,044 48ms 0ms 11 1,044 47ms 0ms 12 1,046 47ms 0ms 13 1,044 46ms 0ms 14 1,046 48ms 0ms 15 1,042 46ms 0ms 16 1,044 49ms 0ms 17 1,044 47ms 0ms 18 1,046 47ms 0ms 19 1,044 48ms 0ms 20 1,046 47ms 0ms 21 988 52ms 0ms 22 984 53ms 0ms 23 1,016 48ms 0ms 00 1,044 50ms 0ms [ User: symmetricds - Total duration: 1s180ms - Times executed: 25028 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 25028 ]
-
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-10 21:56:51 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:43:55 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:12:51 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 10ms 0ms 879,827 36s675ms 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 #16
Day Hour Count Duration Avg duration Aug 10 01 40,680 1s665ms 0ms 02 40,682 1s674ms 0ms 03 40,680 1s657ms 0ms 04 40,682 1s703ms 0ms 05 40,680 1s685ms 0ms 06 40,682 1s701ms 0ms 07 40,647 1s721ms 0ms 08 40,667 1s685ms 0ms 09 40,685 1s706ms 0ms 10 40,618 1s697ms 0ms 11 40,783 1s692ms 0ms 12 40,590 1s694ms 0ms 13 40,635 1s696ms 0ms 14 40,655 1s715ms 0ms 15 40,650 1s731ms 0ms 16 40,669 1s712ms 0ms 17 40,655 1s681ms 0ms 18 40,637 1s677ms 0ms 19 40,631 1s701ms 0ms 20 40,649 1s702ms 0ms 21 5,070 195ms 0ms 22 720 39ms 0ms 23 20,208 868ms 0ms 00 40,572 1s666ms 0ms [ User: symmetricds - Total duration: 36s675ms - Times executed: 879827 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s675ms - Times executed: 879827 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '2';
Date: 2019-08-10 14:56:01 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 14:36:58 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 16:56:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 8,599 285ms 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 #17
Day Hour Count Duration Avg duration Aug 10 01 358 11ms 0ms 02 359 11ms 0ms 03 358 11ms 0ms 04 359 11ms 0ms 05 358 11ms 0ms 06 359 11ms 0ms 07 357 12ms 0ms 08 359 11ms 0ms 09 358 12ms 0ms 10 358 11ms 0ms 11 358 11ms 0ms 12 359 11ms 0ms 13 358 11ms 0ms 14 359 12ms 0ms 15 357 11ms 0ms 16 358 11ms 0ms 17 358 11ms 0ms 18 359 11ms 0ms 19 358 11ms 0ms 20 359 11ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 359 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 285ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 285ms - Times executed: 8599 ]
-
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-10 06:39:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 08:57:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 10:14:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 8,598 262ms 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 10 01 358 10ms 0ms 02 359 10ms 0ms 03 358 10ms 0ms 04 359 10ms 0ms 05 358 10ms 0ms 06 359 10ms 0ms 07 357 10ms 0ms 08 359 11ms 0ms 09 357 10ms 0ms 10 358 10ms 0ms 11 358 10ms 0ms 12 359 10ms 0ms 13 358 10ms 0ms 14 359 10ms 0ms 15 357 10ms 0ms 16 358 10ms 0ms 17 358 10ms 0ms 18 359 10ms 0ms 19 358 11ms 0ms 20 359 10ms 0ms 21 358 11ms 0ms 22 358 12ms 0ms 23 359 11ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 262ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 262ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133310' AND '155133309'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133378' AND '155133377'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '105133262' AND '155133261'));
Date: 2019-08-10 18:04:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 23:41:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:53:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 17,246 454ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 10 01 718 17ms 0ms 02 718 18ms 0ms 03 720 19ms 0ms 04 718 17ms 0ms 05 720 17ms 0ms 06 718 18ms 0ms 07 720 18ms 0ms 08 718 18ms 0ms 09 718 18ms 0ms 10 720 19ms 0ms 11 718 18ms 0ms 12 720 18ms 0ms 13 718 18ms 0ms 14 718 18ms 0ms 15 720 19ms 0ms 16 720 19ms 0ms 17 720 18ms 0ms 18 718 18ms 0ms 19 720 19ms 0ms 20 714 18ms 0ms 21 720 21ms 0ms 22 718 21ms 0ms 23 718 20ms 0ms 00 716 18ms 0ms [ User: symmetricds - Total duration: 454ms - Times executed: 17246 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 454ms - Times executed: 17246 ]
-
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-10 02:46:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 01:21:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 13:44:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,598 207ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 10 01 358 8ms 0ms 02 359 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 359 8ms 0ms 07 357 8ms 0ms 08 359 8ms 0ms 09 357 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 359 8ms 0ms 13 358 8ms 0ms 14 359 8ms 0ms 15 357 8ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 359 8ms 0ms 19 358 8ms 0ms 20 359 8ms 0ms 21 358 9ms 0ms 22 358 9ms 0ms 23 359 8ms 0ms 00 358 8ms 0ms [ User: symmetricds - Total duration: 207ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 207ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133289' AND data_id <= '155133288' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133313' AND data_id <= '155133312' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '105133336' AND data_id <= '155133335' ORDER BY data_id ASC;
Date: 2019-08-10 16:06:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 18:10:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-10 20:05:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 67,985,626 Log entries
Events distribution
Key values
- 0 PANIC entries
- 5 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 5 Total events found
Rank Times reported Error 1 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 10 08 2 - FATAL: no pg_hba.conf entry for host "71.6.167.142", user "postgres", database "template0", SSL on
- FATAL: no pg_hba.conf entry for host "71.6.167.142", user "postgres", database "-h", SSL on
Date: 2019-08-10 07:11:41 Database: template0 Application: [unknown] User: postgres Remote: 71.6.167.142 Code:
Date: 2019-08-10 07:11:42 Database: -h Application: [unknown] User: postgres Remote: 71.6.167.142 Code:
2 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 10 08 2 - FATAL: no pg_hba.conf entry for host "71.6.167.142", user "postgres", database "template0", SSL off
- FATAL: no pg_hba.conf entry for host "71.6.167.142", user "postgres", database "-h", SSL off
Date: 2019-08-10 07:11:41 Database: template0 Application: [unknown] User: postgres Remote: 71.6.167.142 Code:
Date: 2019-08-10 07:11:42 Database: -h Application: [unknown] User: postgres Remote: 71.6.167.142 Code:
3 1 FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 10 08 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Date: 2019-08-10 07:11:41 Database: [unknown] Application: [unknown] User: [unknown] Remote: 71.6.167.142 Code: