pgBadger-
Global information
- Generated on Mon Aug 5 00:01:31 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 69,530,587 log entries in 1m27s
- Log start from 2019-08-04 00:00:00 to 2019-08-04 23:59:59
-
Overview
Global Stats
- 174 Number of unique normalized queries
- 23,612,548 Number of queries
- 32m33s Total query duration
- 2019-08-04 00:00:00 First query
- 2019-08-04 23:59:59 Last query
- 5,857 queries/s at 2019-08-04 08:40:00 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
- 1,344 Total number of automatic vacuums
- 1,346 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,154 Total number of sessions
- 3 sessions at 2019-08-04 04:50:09 Session peak
- 10d11h16m29s Total duration of sessions
- 6m59s Average duration of sessions
- 10,962 Average queries per session
- 906ms Average queries duration per session
- 2,154 Total number of connections
- 39 connections/s at 2019-08-04 00:30:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5,857 queries/s Query Peak
- 2019-08-04 08:40:00 Date
SELECT Traffic
Key values
- 2,861 queries/s Query Peak
- 2019-08-04 08:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2,010 queries/s Query Peak
- 2019-08-04 03:40:58 Date
Queries duration
Key values
- 32m33s Total query duration
Prepared queries ratio
Key values
- 1.68 Ratio of bind vs prepare
- 170.64 % 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 04 00 1,074,025 0ms 86ms 0ms 1s756ms 1s962ms 3s286ms 01 1,068,002 0ms 86ms 0ms 1s725ms 1s782ms 2s327ms 02 1,074,332 0ms 89ms 0ms 1s728ms 1s933ms 2s275ms 03 1,069,460 0ms 90ms 0ms 1s734ms 1s774ms 2s257ms 04 1,066,289 0ms 103ms 0ms 1s745ms 1s962ms 2s892ms 05 1,080,000 0ms 90ms 0ms 1s765ms 1s812ms 2s234ms 06 1,071,621 0ms 82ms 0ms 1s772ms 1s881ms 2s26ms 07 1,080,068 0ms 85ms 0ms 1s810ms 1s908ms 2s476ms 08 1,077,432 0ms 85ms 0ms 1s790ms 1s863ms 2s233ms 09 1,078,988 0ms 106ms 0ms 1s717ms 1s737ms 2s438ms 10 1,071,486 0ms 695ms 0ms 1s745ms 1s771ms 1s971ms 11 1,081,755 0ms 80ms 0ms 1s764ms 1s818ms 2s313ms 12 1,075,720 0ms 66ms 0ms 1s740ms 1s811ms 2s330ms 13 1,083,884 0ms 803ms 0ms 1s782ms 1s810ms 2s131ms 14 1,082,149 0ms 79ms 0ms 1s787ms 1s843ms 2s431ms 15 1,078,263 0ms 54ms 0ms 1s753ms 1s796ms 1s940ms 16 1,084,707 0ms 240ms 0ms 1s721ms 1s893ms 2s83ms 17 1,067,403 0ms 81ms 0ms 1s782ms 1s798ms 1s903ms 18 1,076,807 0ms 738ms 0ms 1s757ms 1s800ms 1s920ms 19 1,067,477 0ms 312ms 0ms 1s720ms 1s803ms 1s927ms 20 163,302 0ms 79ms 0ms 1s636ms 1s779ms 2s315ms 21 44,566 0ms 84ms 0ms 121ms 127ms 748ms 22 830,652 0ms 82ms 0ms 1s716ms 1s793ms 1s963ms 23 1,064,160 0ms 82ms 0ms 1s799ms 1s837ms 1s955ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 00 301,264 0 0ms 399ms 423ms 639ms 01 297,769 0 0ms 391ms 418ms 453ms 02 299,597 0 0ms 392ms 410ms 430ms 03 298,231 0 0ms 408ms 435ms 466ms 04 297,294 0 0ms 391ms 404ms 464ms 05 301,228 0 0ms 405ms 421ms 448ms 06 298,856 0 0ms 386ms 403ms 499ms 07 301,251 0 0ms 394ms 413ms 442ms 08 300,498 0 0ms 405ms 430ms 448ms 09 300,922 0 0ms 397ms 415ms 438ms 10 298,806 0 0ms 401ms 427ms 440ms 11 301,775 0 0ms 405ms 416ms 442ms 12 300,034 0 0ms 417ms 423ms 448ms 13 302,390 0 0ms 411ms 432ms 457ms 14 301,895 0 0ms 413ms 424ms 459ms 15 300,776 0 0ms 396ms 421ms 441ms 16 302,645 0 0ms 408ms 426ms 462ms 17 297,690 0 0ms 409ms 437ms 494ms 18 300,363 0 0ms 412ms 423ms 470ms 19 297,744 0 0ms 398ms 425ms 430ms 20 48,349 0 0ms 86ms 211ms 422ms 21 15,323 0 0ms 80ms 94ms 134ms 22 232,409 0 0ms 405ms 425ms 442ms 23 296,812 0 0ms 395ms 426ms 446ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 00 359 80,696 112 0 0ms 364ms 378ms 391ms 01 88 79,652 110 0 0ms 359ms 374ms 403ms 02 88 79,665 111 0 0ms 359ms 371ms 382ms 03 82 79,525 108 0 0ms 363ms 375ms 389ms 04 84 79,635 109 0 0ms 358ms 372ms 403ms 05 88 79,763 111 0 0ms 358ms 371ms 408ms 06 88 79,363 111 0 0ms 365ms 372ms 385ms 07 88 79,620 111 0 0ms 359ms 370ms 397ms 08 84 79,492 112 0 0ms 360ms 378ms 405ms 09 80 79,634 104 0 0ms 361ms 375ms 408ms 10 86 79,463 111 0 0ms 356ms 375ms 389ms 11 88 79,554 111 0 0ms 362ms 370ms 398ms 12 84 79,493 108 0 0ms 363ms 376ms 395ms 13 80 79,547 107 0 0ms 360ms 371ms 383ms 14 84 79,581 110 0 0ms 366ms 375ms 398ms 15 82 79,561 107 0 0ms 366ms 371ms 385ms 16 84 79,528 110 0 0ms 362ms 373ms 385ms 17 84 79,433 111 0 0ms 362ms 376ms 388ms 18 84 79,546 106 0 0ms 355ms 365ms 379ms 19 86 79,372 110 0 0ms 359ms 368ms 398ms 20 242 9,343 128 0 0ms 1ms 8ms 373ms 21 511 62 111 0 1ms 1ms 7ms 25ms 22 227 61,079 112 0 0ms 358ms 374ms 402ms 23 310 79,385 111 0 0ms 366ms 380ms 405ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 04 00 633,788 1,073,989 1.69 99.90% 01 631,790 1,067,966 1.69 100.64% 02 637,111 1,074,296 1.69 101.18% 03 633,548 1,069,424 1.69 100.92% 04 630,161 1,066,253 1.69 100.45% 05 641,865 1,079,964 1.68 101.58% 06 635,555 1,071,585 1.69 101.22% 07 642,255 1,080,032 1.68 101.74% 08 640,351 1,077,396 1.68 101.65% 09 641,048 1,078,952 1.68 101.60% 10 635,230 1,071,450 1.69 101.12% 11 644,502 1,081,719 1.68 102.05% 12 639,323 1,075,684 1.68 101.55% 13 646,244 1,083,848 1.68 102.23% 14 644,672 1,082,113 1.68 102.03% 15 641,275 1,078,227 1.68 101.69% 16 647,137 1,084,671 1.68 102.34% 17 632,318 1,067,367 1.69 100.85% 18 640,065 1,076,771 1.68 101.57% 19 632,723 1,067,441 1.69 100.94% 20 99,277 163,266 1.64 102.70% 21 29,267 44,530 1.52 109.50% 22 492,600 830,616 1.69 100.92% 23 629,519 1,064,124 1.69 100.54% Day Hour Count Average / Second Aug 04 00 129 0.04/s 01 100 0.03/s 02 79 0.02/s 03 78 0.02/s 04 83 0.02/s 05 81 0.02/s 06 77 0.02/s 07 81 0.02/s 08 81 0.02/s 09 80 0.02/s 10 81 0.02/s 11 93 0.03/s 12 85 0.02/s 13 94 0.03/s 14 91 0.03/s 15 91 0.03/s 16 92 0.03/s 17 90 0.03/s 18 92 0.03/s 19 90 0.03/s 20 102 0.03/s 21 103 0.03/s 22 90 0.03/s 23 91 0.03/s Day Hour Count Average Duration Aug 04 00 129 6m29s 01 100 7m16s 02 79 8m9s 03 78 8m5s 04 83 7m45s 05 81 7m31s 06 77 7m33s 07 81 7m55s 08 81 7m45s 09 80 7m43s 10 81 7m55s 11 93 6m32s 12 85 7m24s 13 94 6m26s 14 91 6m30s 15 91 6m39s 16 92 6m40s 17 90 6m39s 18 92 6m34s 19 90 6m31s 20 102 5m54s 21 103 5m54s 22 90 6m45s 23 91 6m38s -
Connections
Established Connections
Key values
- 39 connections Connection Peak
- 2019-08-04 00:30:20 Date
Connections per database
Key values
- pharmisight Main Database
- 2,154 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,154 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-08-04 04:50:09 Date
Histogram of session times
Key values
- 1,506 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,154 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,154 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,154 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 878 buffers Checkpoint Peak
- 2019-08-04 00:41:02 Date
- 87.533 seconds Highest write time
- 0.682 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-08-04 02:10:07 Date
Checkpoints distance
Key values
- 11.97 Mo Distance Peak
- 2019-08-04 00:41:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 04 00 5,112 511.658s 0.023s 511.777s 01 3,709 371.629s 0.107s 371.828s 02 3,345 335.131s 0.533s 335.741s 03 3,620 362.735s 0.523s 363.341s 04 3,607 361.303s 0.699s 362.082s 05 3,081 308.526s 0.701s 309.288s 06 3,647 365.185s 0.021s 365.343s 07 3,686 369.619s 0.013s 369.708s 08 3,588 359.991s 0.017s 360.131s 09 3,616 363.903s 0.015s 364.006s 10 3,636 365.918s 0.006s 365.997s 11 3,669 367.49s 0.012s 367.574s 12 3,703 370.825s 0.021s 370.92s 13 3,664 366.731s 0.008s 366.8s 14 3,775 377.889s 0.006s 377.965s 15 3,657 365.994s 0.012s 366.078s 16 3,653 366.081s 0.01s 366.157s 17 3,672 367.755s 0.009s 367.84s 18 3,706 371.115s 0.018s 371.209s 19 3,684 368.555s 0.005s 368.635s 20 1,244 124.608s 0.02s 124.678s 21 617 61.935s 0.013s 62.025s 22 2,989 299.18s 0.012s 299.25s 23 3,795 381.046s 0.014s 381.13s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 04 00 0 0 4 326 0.011s 0s 01 0 0 4 289 0.074s 0.005s 02 0 0 4 267 0.435s 0.026s 03 0 0 3 285 0.485s 0.027s 04 0 0 4 280 0.315s 0.046s 05 0 0 4 248 0.681s 0.048s 06 0 0 3 279 0.008s 0s 07 0 0 4 288 0.002s 0s 08 0 0 4 278 0.004s 0s 09 0 0 3 271 0.003s 0s 10 0 0 4 285 0.001s 0s 11 0 0 3 311 0.002s 0s 12 0 0 4 314 0.008s 0s 13 0 0 4 306 0.001s 0s 14 0 0 4 332 0.001s 0s 15 0 0 3 323 0.002s 0s 16 0 0 4 321 0.001s 0s 17 0 0 3 329 0.002s 0s 18 0 0 4 321 0.008s 0s 19 0 0 4 325 0.001s 0s 20 0 0 1 261 0.009s 0s 21 0 0 0 244 0.002s 0s 22 0 0 2 322 0.001s 0s 23 0 0 4 362 0.003s 0s Day Hour Count Avg time (sec) Aug 04 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 04 00 5,546.00 kB 5,826.50 kB 01 4,948.22 kB 5,521.00 kB 02 5,025.29 kB 5,174.57 kB 03 5,048.57 kB 5,146.29 kB 04 5,040.57 kB 5,251.14 kB 05 5,077.20 kB 5,153.00 kB 06 4,969.83 kB 5,137.83 kB 07 5,034.75 kB 5,268.38 kB 08 5,029.00 kB 5,149.57 kB 09 4,973.71 kB 5,147.71 kB 10 4,960.43 kB 5,271.86 kB 11 4,964.89 kB 5,110.89 kB 12 5,043.20 kB 5,144.00 kB 13 5,030.25 kB 5,253.00 kB 14 5,045.25 kB 5,258.50 kB 15 5,003.14 kB 5,135.71 kB 16 5,021.43 kB 5,196.86 kB 17 5,016.86 kB 5,200.14 kB 18 5,012.89 kB 5,121.22 kB 19 5,051.00 kB 5,266.00 kB 20 1,303.78 kB 3,840.11 kB 21 252.90 kB 1,595.60 kB 22 3,446.75 kB 3,725.75 kB 23 5,075.38 kB 5,226.75 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (1311) Main table analyzed (database pharmisight)
- 1,346 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 1311 pharmisight.public.sym_incoming_batch 13 pharmisight.public.sym_data_gap 10 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 3 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 pharmisight.public.patients 1 Total 1,346 Vacuums per table
Key values
- public.sym_outgoing_batch (1311) Main table vacuumed on database pharmisight
- 1,344 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 1311 1311 pharmisight.pg_toast.pg_toast_2619 15 15 pharmisight.public.sym_data_gap 5 5 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 2 1 pharmisight.public.item_codes 1 1 Total 1,344 1,338 Tuples removed per table
Key values
- public.sym_outgoing_batch (1375274) Main table with removed tuples on database pharmisight
- 1378794 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_outgoing_batch 1311 1311 1375274 0 pharmisight.pg_toast.pg_toast_2619 15 15 1085 0 pharmisight.public.sym_incoming_batch 5 5 859 0 pharmisight.pg_catalog.pg_statistic 2 1 675 0 pharmisight.public.item_codes 1 1 386 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_data_gap 5 5 255 0 Total 1,344 1,338 1,378,794 0 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database
- 0 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.pg_catalog.pg_statistic 2 1 675 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_incoming_batch 5 5 859 0 pharmisight.pg_toast.pg_toast_2619 15 15 1085 0 pharmisight.public.item_codes 1 1 386 0 pharmisight.public.sym_outgoing_batch 1311 1311 1375274 0 pharmisight.public.sym_node_host 5 0 260 0 Total 1,344 1,338 1,378,794 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 04 00 63 67 01 62 62 02 62 62 03 61 60 04 61 61 05 61 62 06 61 59 07 61 62 08 61 60 09 62 61 10 60 63 11 62 60 12 62 62 13 60 61 14 64 61 15 62 61 16 60 61 17 61 61 18 61 61 19 62 60 20 7 9 21 1 1 22 46 49 23 61 60 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 6,593,921 Total read queries
- 7,242,872 Total write queries
Queries by database
Key values
- pharmisight Main database
- 23,612,548 Requests
- 32m33s (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 23,730,258 Requests
User Request type Count Duration pharmisight Total 51,416 4s41ms DELETE 19 2ms INSERT 123 73ms OTHERS 1,659 68ms SELECT 49,071 3s873ms TCL 526 20ms UPDATE 18 3ms symmetricds Total 23,730,258 32m42s DELETE 2,639 11s186ms INSERT 3,150 829ms OTHERS 9,844,631 2m22s SELECT 6,591,154 7m30s TCL 5,534,099 15m30s UPDATE 1,754,585 7m7s tony Total 870 239ms SELECT 870 239ms Duration by user
Key values
- 32m42s (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 51,416 4s41ms DELETE 19 2ms INSERT 123 73ms OTHERS 1,659 68ms SELECT 49,071 3s873ms TCL 526 20ms UPDATE 18 3ms symmetricds Total 23,730,258 32m42s DELETE 2,639 11s186ms INSERT 3,150 829ms OTHERS 9,844,631 2m22s SELECT 6,591,154 7m30s TCL 5,534,099 15m30s UPDATE 1,754,585 7m7s tony Total 870 239ms SELECT 870 239ms Queries by host
Key values
- 10.10.10.1 Main host
- 23,781,674 Requests
- 32m46s (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 23,609,818 Requests
- 32m32s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-04 19:13:52 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 23,502,874 0-1ms duration
Slowest individual queries
Rank Duration Query 1 803ms COMMIT;[ Date: 2019-08-04 13:10:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 738ms COMMIT;[ Date: 2019-08-04 18:50:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 695ms COMMIT;[ Date: 2019-08-04 10:50:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 312ms COMMIT;[ Date: 2019-08-04 19:30:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 240ms COMMIT;[ Date: 2019-08-04 16:30:04 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 167ms COMMIT;[ Date: 2019-08-04 19:20:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 106ms COMMIT;[ Date: 2019-08-04 09:10:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 105ms COMMIT;[ Date: 2019-08-04 09:10:05 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 103ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 90ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 90ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 89ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 87ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 86ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 86ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 21:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 82ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 22:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 82ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-04 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15m5s 2,747,478 0ms 803ms 0ms COMMIT;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 01 125,989 39s576ms 0ms 02 125,079 39s992ms 0ms 03 125,107 41s144ms 0ms 04 124,904 39s688ms 0ms 05 125,114 41s744ms 0ms 06 125,335 41s737ms 0ms 07 124,752 40s179ms 0ms 08 125,114 43s638ms 0ms 09 124,894 42s131ms 0ms 10 125,092 40s608ms 0ms 11 124,850 41s159ms 0ms 12 125,018 41s818ms 0ms 13 124,922 40s832ms 0ms 14 124,998 43s95ms 0ms 15 125,086 40s855ms 0ms 16 125,039 42s503ms 0ms 17 124,995 41s84ms 0ms 18 124,846 41s166ms 0ms 19 125,029 42s736ms 0ms 20 124,759 40s620ms 0ms 21 19,304 6s207ms 0ms 22 5,360 197ms 0ms 23 97,133 31s645ms 0ms 00 124,759 41s479ms 0ms [ User: symmetricds - Total duration: 15m5s - Times executed: 2747216 ]
[ User: pharmisight - Total duration: 18ms - Times executed: 262 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m5s - Times executed: 2747478 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-04 13:10:05 Duration: 803ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 18:50:05 Duration: 738ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 10:50:05 Duration: 695ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7m1s 1,735,743 0ms 15ms 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 04 01 79,317 19s213ms 0ms 02 79,425 19s355ms 0ms 03 79,441 19s495ms 0ms 04 79,301 19s218ms 0ms 05 79,410 18s982ms 0ms 06 79,534 19s352ms 0ms 07 79,135 19s204ms 0ms 08 79,394 19s234ms 0ms 09 79,266 19s688ms 0ms 10 79,410 19s219ms 0ms 11 79,236 19s365ms 0ms 12 79,325 19s433ms 0ms 13 79,266 19s111ms 0ms 14 79,323 19s298ms 0ms 15 79,353 19s298ms 0ms 16 79,335 19s261ms 0ms 17 79,300 19s236ms 0ms 18 79,205 18s916ms 0ms 19 79,319 18s601ms 0ms 20 79,143 19s221ms 0ms 21 9,262 1s998ms 0ms 22 5 1ms 0ms 23 60,891 14s931ms 0ms 00 79,147 19s431ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1735743 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1735743 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3968', extract_count = '4072', sent_count = '4072', load_count = '4072', data_row_count = '7', reload_row_count = '0', data_insert_row_count = '3', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 16:18:48.028', transfer_start_time = '2019-08-04 17:47:07.741', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '7', extract_insert_row_count = '3', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195615' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '5205', extract_count = '3971', sent_count = '3971', load_count = '3971', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '33', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '4', extract_start_time = '2019-08-01 15:12:45.663', transfer_start_time = '2019-08-04 15:00:03.558', 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 = '6', extract_insert_row_count = '2', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195197' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '13159', extract_count = '3933', sent_count = '3933', load_count = '3933', data_row_count = '40', reload_row_count = '0', data_insert_row_count = '18', data_update_row_count = '22', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '22', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '36', extract_start_time = '2019-08-01 15:10:44.096', transfer_start_time = '2019-08-04 14:20:03.72', 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 = '40', extract_insert_row_count = '18', extract_update_row_count = '22', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195181' AND node_id = '2';
Date: 2019-08-04 17:47:07 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:00:03 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:20:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3m25s 865,324 0ms 14ms 0ms SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = ? AND o.node_id = ? ORDER BY d.data_id ASC;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 04 01 39,541 9s544ms 0ms 02 39,595 9s477ms 0ms 03 39,603 9s602ms 0ms 04 39,532 9s419ms 0ms 05 39,589 9s225ms 0ms 06 39,653 9s381ms 0ms 07 39,449 9s344ms 0ms 08 39,580 9s406ms 0ms 09 39,517 9s431ms 0ms 10 39,590 9s282ms 0ms 11 39,502 9s375ms 0ms 12 39,542 9s586ms 0ms 13 39,518 9s327ms 0ms 14 39,544 9s521ms 0ms 15 39,559 9s501ms 0ms 16 39,551 9s403ms 0ms 17 39,534 9s390ms 0ms 18 39,486 9s331ms 0ms 19 39,542 9s298ms 0ms 20 39,457 9s340ms 0ms 21 4,619 987ms 0ms 22 5 1ms 0ms 23 30,354 7s203ms 0ms 00 39,462 9s366ms 0ms [ User: symmetricds - Total duration: 3m25s - Times executed: 865324 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m25s - Times executed: 865324 ]
-
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 = '9195471' 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 = '9195499' 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 = '9195628' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-04 14:14:06 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 13:38:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 11:35:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1m49s 7,069,191 0ms 7ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 04 01 318,338 4s932ms 0ms 02 318,504 4s930ms 0ms 03 321,199 5s2ms 0ms 04 319,362 4s952ms 0ms 05 317,816 4s875ms 0ms 06 323,443 5s4ms 0ms 07 320,562 5s11ms 0ms 08 323,730 5s6ms 0ms 09 322,838 5s45ms 0ms 10 323,268 5s15ms 0ms 11 320,329 4s925ms 0ms 12 324,533 5s89ms 0ms 13 322,081 4s977ms 0ms 14 325,467 5s45ms 0ms 15 324,657 4s990ms 0ms 16 323,037 4s937ms 0ms 17 325,834 5s28ms 0ms 18 318,601 4s870ms 0ms 19 322,436 4s865ms 0ms 20 318,717 4s920ms 0ms 21 51,789 764ms 0ms 22 16,893 288ms 0ms 23 248,649 3s862ms 0ms 00 317,108 4s903ms 0ms [ User: symmetricds - Total duration: 1m49s - Times executed: 7068642 ]
[ User: pharmisight - Total duration: 26ms - Times executed: 549 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m49s - Times executed: 7069191 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-04 11:11:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:17:57 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:24:02 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m10s 47,563 0ms 59ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 04 01 2,164 3s89ms 1ms 02 2,164 3s206ms 1ms 03 2,164 3s152ms 1ms 04 2,164 3s238ms 1ms 05 2,164 3s117ms 1ms 06 2,164 3s288ms 1ms 07 2,164 3s176ms 1ms 08 2,164 3s113ms 1ms 09 2,164 3s300ms 1ms 10 2,164 3s195ms 1ms 11 2,164 3s152ms 1ms 12 2,155 3s208ms 1ms 13 2,137 3s84ms 1ms 14 2,164 3s159ms 1ms 15 2,164 3s274ms 1ms 16 2,164 3s77ms 1ms 17 2,164 3s152ms 1ms 18 2,164 3s406ms 1ms 19 2,164 3s285ms 1ms 20 2,164 3s242ms 1ms 21 362 448ms 1ms 22 125 119ms 0ms 23 1,667 2s436ms 1ms 00 2,165 3s264ms 1ms [ User: symmetricds - Total duration: 1m10s - Times executed: 47563 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m10s - Times executed: 47563 ]
-
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-04 05:56:58 Duration: 59ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:54:57 Duration: 48ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 17:18:01 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 41s477ms 4,110,786 0ms 14ms 0ms SELECT ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 01 187,438 1s891ms 0ms 02 186,327 1s890ms 0ms 03 187,251 1s887ms 0ms 04 186,486 1s887ms 0ms 05 186,084 1s869ms 0ms 06 188,096 1s907ms 0ms 07 186,732 1s885ms 0ms 08 188,043 1s887ms 0ms 09 187,619 1s945ms 0ms 10 187,899 1s892ms 0ms 11 186,759 1s877ms 0ms 12 188,249 1s922ms 0ms 13 187,360 1s873ms 0ms 14 188,544 1s911ms 0ms 15 188,314 1s901ms 0ms 16 187,744 1s871ms 0ms 17 188,658 1s908ms 0ms 18 186,141 1s854ms 0ms 19 187,529 1s833ms 0ms 20 186,125 1s884ms 0ms 21 27,100 261ms 0ms 22 6,197 75ms 0ms 23 144,483 1s457ms 0ms 00 185,608 1s899ms 0ms [ User: symmetricds - Total duration: 41s477ms - Times executed: 4110786 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 41s477ms - Times executed: 4110786 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-04 16:04:07 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:19:10 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:15:04 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 40s369ms 890,371 0ms 9ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 04 01 40,619 1s856ms 0ms 02 40,671 1s849ms 0ms 03 40,678 1s870ms 0ms 04 40,609 1s845ms 0ms 05 40,664 1s815ms 0ms 06 40,723 1s856ms 0ms 07 40,526 1s834ms 0ms 08 40,654 1s841ms 0ms 09 40,589 1s864ms 0ms 10 40,666 1s837ms 0ms 11 40,576 1s836ms 0ms 12 40,624 1s873ms 0ms 13 40,592 1s847ms 0ms 14 40,619 1s858ms 0ms 15 40,639 1s845ms 0ms 16 40,627 1s833ms 0ms 17 40,609 1s822ms 0ms 18 40,561 1s826ms 0ms 19 40,619 1s793ms 0ms 20 40,529 1s822ms 0ms 21 5,380 228ms 0ms 22 721 39ms 0ms 23 31,348 1s426ms 0ms 00 40,528 1s842ms 0ms [ User: symmetricds - Total duration: 40s369ms - Times executed: 890371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s369ms - Times executed: 890371 ]
-
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 = '0';
Date: 2019-08-04 03:52:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 01:54:02 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:56:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 29s665ms 475,869 0ms 10ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 04 01 20,548 1s281ms 0ms 02 20,747 1s278ms 0ms 03 21,629 1s318ms 0ms 04 21,143 1s322ms 0ms 05 20,473 1s276ms 0ms 06 22,194 1s388ms 0ms 07 21,621 1s394ms 0ms 08 22,441 1s397ms 0ms 09 22,291 1s406ms 0ms 10 22,310 1s405ms 0ms 11 21,490 1s316ms 0ms 12 22,774 1s442ms 0ms 13 22,016 1s371ms 0ms 14 23,092 1s418ms 0ms 15 22,753 1s371ms 0ms 16 22,251 1s328ms 0ms 17 23,211 1s423ms 0ms 18 20,899 1s337ms 0ms 19 22,056 1s358ms 0ms 20 21,002 1s351ms 0ms 21 2,334 133ms 0ms 22 5 0ms 0ms 23 16,104 1s40ms 0ms 00 20,485 1s301ms 0ms [ User: symmetricds - Total duration: 29s665ms - Times executed: 475869 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s665ms - Times executed: 475869 ]
-
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 = '9196005' 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 = '9196367' 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 = '9195415' AND node_id = '2';
Date: 2019-08-04 19:53:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:17:08 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:57:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 23s586ms 17,280 0ms 58ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 04 01 720 974ms 1ms 02 720 960ms 1ms 03 720 941ms 1ms 04 720 996ms 1ms 05 720 934ms 1ms 06 720 994ms 1ms 07 720 928ms 1ms 08 720 910ms 1ms 09 720 1s45ms 1ms 10 720 1s1ms 1ms 11 720 967ms 1ms 12 720 990ms 1ms 13 720 940ms 1ms 14 720 1s23ms 1ms 15 720 948ms 1ms 16 720 930ms 1ms 17 720 983ms 1ms 18 720 1s19ms 1ms 19 720 1s49ms 1ms 20 720 986ms 1ms 21 720 1s32ms 1ms 22 720 1s69ms 1ms 23 720 1s12ms 1ms 00 720 944ms 1ms [ User: symmetricds - Total duration: 23s586ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23s586ms - Times executed: 17280 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-04 17:22:55 Duration: 58ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 09:07:53 Duration: 28ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 20:40:58 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17s828ms 2,747,488 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 04 01 125,990 813ms 0ms 02 125,079 804ms 0ms 03 125,107 819ms 0ms 04 124,906 808ms 0ms 05 125,114 806ms 0ms 06 125,337 829ms 0ms 07 124,751 808ms 0ms 08 125,115 818ms 0ms 09 124,895 818ms 0ms 10 125,091 812ms 0ms 11 124,853 815ms 0ms 12 125,020 822ms 0ms 13 124,923 811ms 0ms 14 124,996 824ms 0ms 15 125,087 823ms 0ms 16 125,038 808ms 0ms 17 124,997 800ms 0ms 18 124,848 802ms 0ms 19 125,027 788ms 0ms 20 124,757 798ms 0ms 21 19,304 114ms 0ms 22 5,360 35ms 0ms 23 97,133 628ms 0ms 00 124,760 812ms 0ms [ User: symmetricds - Total duration: 17s826ms - Times executed: 2747225 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s828ms - Times executed: 2747488 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-04 05:40:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 07:50:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:28:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 16s295ms 1,351,429 0ms 2ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 04 01 60,521 701ms 0ms 02 60,773 731ms 0ms 03 61,663 739ms 0ms 04 61,105 745ms 0ms 05 60,492 723ms 0ms 06 62,281 762ms 0ms 07 61,504 747ms 0ms 08 62,450 751ms 0ms 09 62,241 762ms 0ms 10 62,332 755ms 0ms 11 61,426 738ms 0ms 12 62,746 768ms 0ms 13 61,966 738ms 0ms 14 63,067 766ms 0ms 15 62,747 755ms 0ms 16 62,233 741ms 0ms 17 63,176 756ms 0ms 18 60,819 737ms 0ms 19 62,029 743ms 0ms 20 60,889 741ms 0ms 21 7,331 83ms 0ms 22 382 6ms 0ms 23 46,877 568ms 0ms 00 60,379 727ms 0ms [ User: symmetricds - Total duration: 16s295ms - Times executed: 1351429 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s295ms - Times executed: 1351429 ]
-
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-04 19:25:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:17:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:04:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 15s736ms 1,351,402 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 01 60,521 671ms 0ms 02 60,772 707ms 0ms 03 61,661 712ms 0ms 04 61,105 716ms 0ms 05 60,489 696ms 0ms 06 62,276 739ms 0ms 07 61,504 719ms 0ms 08 62,450 730ms 0ms 09 62,240 739ms 0ms 10 62,329 729ms 0ms 11 61,424 708ms 0ms 12 62,748 746ms 0ms 13 61,963 717ms 0ms 14 63,068 741ms 0ms 15 62,744 726ms 0ms 16 62,232 711ms 0ms 17 63,178 730ms 0ms 18 60,815 715ms 0ms 19 62,027 722ms 0ms 20 60,887 714ms 0ms 21 7,332 78ms 0ms 22 382 5ms 0ms 23 46,877 551ms 0ms 00 60,378 702ms 0ms [ User: symmetricds - Total duration: 15s736ms - Times executed: 1351402 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s736ms - Times executed: 1351402 ]
-
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-04 23:46:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:48:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 08:59:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 9s607ms 17,188 0ms 4ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 01 719 384ms 0ms 02 716 396ms 0ms 03 716 400ms 0ms 04 716 401ms 0ms 05 716 390ms 0ms 06 715 395ms 0ms 07 718 397ms 0ms 08 716 395ms 0ms 09 718 401ms 0ms 10 716 403ms 0ms 11 716 390ms 0ms 12 716 401ms 0ms 13 716 391ms 0ms 14 714 401ms 0ms 15 718 397ms 0ms 16 716 393ms 0ms 17 716 399ms 0ms 18 716 393ms 0ms 19 716 403ms 0ms 20 714 402ms 0ms 21 718 434ms 0ms 22 716 427ms 0ms 23 716 402ms 0ms 00 714 400ms 0ms [ User: symmetricds - Total duration: 9s607ms - Times executed: 17188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s607ms - Times executed: 17188 ]
-
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-04 06:38:51 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 19:50:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:48:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 7s138ms 384 7ms 51ms 18ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 04 01 16 307ms 19ms 02 16 364ms 22ms 03 16 329ms 20ms 04 16 370ms 23ms 05 16 299ms 18ms 06 16 313ms 19ms 07 16 315ms 19ms 08 16 316ms 19ms 09 16 320ms 20ms 10 16 324ms 20ms 11 16 172ms 10ms 12 16 352ms 22ms 13 16 296ms 18ms 14 16 192ms 12ms 15 16 289ms 18ms 16 16 155ms 9ms 17 16 291ms 18ms 18 16 308ms 19ms 19 16 181ms 11ms 20 16 296ms 18ms 21 16 311ms 19ms 22 16 428ms 26ms 23 16 306ms 19ms 00 16 294ms 18ms [ User: symmetricds - Total duration: 7s138ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s138ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808502' AND create_time < '2019-08-03 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808502') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808502' 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 '104804165' AND '104808526' AND create_time < '2019-08-03 03:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808526') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808526' 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 '104754155' AND '104759155' AND create_time < '2019-08-03 21:00:00.003' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-04 01:00:00 Duration: 51ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:00:00 Duration: 49ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 48ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 4s166ms 1,110 1ms 15ms 3ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 04 01 45 168ms 3ms 02 44 163ms 3ms 03 44 166ms 3ms 04 45 182ms 4ms 05 41 146ms 3ms 06 50 188ms 3ms 07 45 175ms 3ms 08 48 170ms 3ms 09 43 167ms 3ms 10 42 158ms 3ms 11 40 154ms 3ms 12 55 210ms 3ms 13 49 180ms 3ms 14 54 200ms 3ms 15 53 197ms 3ms 16 55 205ms 3ms 17 55 205ms 3ms 18 55 210ms 3ms 19 49 185ms 3ms 20 54 201ms 3ms 21 25 91ms 3ms 22 23 88ms 3ms 23 45 163ms 3ms 00 51 186ms 3ms [ User: symmetricds - Total duration: 4s166ms - Times executed: 1110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s166ms - Times executed: 1110 ]
-
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-04 03:34:57 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:17:57 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:04 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 3s837ms 547 4ms 15ms 7ms 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 #16
Day Hour Count Duration Avg duration Aug 04 01 130 849ms 6ms 02 19 153ms 8ms 03 19 140ms 7ms 04 19 158ms 8ms 05 19 151ms 7ms 06 19 148ms 7ms 07 19 145ms 7ms 08 19 153ms 8ms 09 18 150ms 8ms 10 19 159ms 8ms 11 19 101ms 5ms 12 19 140ms 7ms 13 18 126ms 7ms 14 18 110ms 6ms 15 19 142ms 7ms 16 18 100ms 5ms 17 19 133ms 7ms 18 19 132ms 6ms 19 19 129ms 6ms 20 19 95ms 5ms 21 19 121ms 6ms 22 3 23ms 7ms 23 19 175ms 9ms 00 19 92ms 4ms [ User: symmetricds - Total duration: 3s633ms - Times executed: 502 ]
[ User: pharmisight - Total duration: 204ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s837ms - Times executed: 547 ]
-
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 = 'homeward_actions' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-04 03:00:01 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 09:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 3s736ms 384 4ms 27ms 9ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 04 01 16 176ms 11ms 02 16 175ms 10ms 03 16 169ms 10ms 04 16 170ms 10ms 05 16 163ms 10ms 06 16 169ms 10ms 07 16 167ms 10ms 08 16 175ms 10ms 09 16 182ms 11ms 10 16 168ms 10ms 11 16 89ms 5ms 12 16 171ms 10ms 13 16 139ms 8ms 14 16 97ms 6ms 15 16 163ms 10ms 16 16 88ms 5ms 17 16 163ms 10ms 18 16 163ms 10ms 19 16 103ms 6ms 20 16 164ms 10ms 21 16 166ms 10ms 22 16 174ms 10ms 23 16 166ms 10ms 00 16 165ms 10ms [ User: symmetricds - Total duration: 3s736ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s736ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808586' AND data_id < '104808589' AND create_time < '2019-08-03 08:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808586');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104789162' AND '104794162' AND data_id < '104808742' AND create_time < '2019-08-03 21:00:00.003' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104789162' AND '104794162');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104739152' AND '104744152' AND data_id < '104808742' AND create_time < '2019-08-03 21:00:00.003' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152');
Date: 2019-08-04 08:00:00 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 1s903ms 24 44ms 103ms 79ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 04 01 1 86ms 86ms 02 1 86ms 86ms 03 1 89ms 89ms 04 1 90ms 90ms 05 1 103ms 103ms 06 1 90ms 90ms 07 1 82ms 82ms 08 1 85ms 85ms 09 1 85ms 85ms 10 1 87ms 87ms 11 1 45ms 45ms 12 1 80ms 80ms 13 1 66ms 66ms 14 1 49ms 49ms 15 1 79ms 79ms 16 1 44ms 44ms 17 1 79ms 79ms 18 1 81ms 81ms 19 1 81ms 81ms 20 1 79ms 79ms 21 1 79ms 79ms 22 1 84ms 84ms 23 1 82ms 82ms 00 1 82ms 82ms [ User: symmetricds - Total duration: 1s903ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s903ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-08-04 04:00:00 Duration: 103ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 1s754ms 1,233 0ms 9ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 04 01 47 64ms 1ms 02 45 62ms 1ms 03 46 66ms 1ms 04 47 68ms 1ms 05 46 66ms 1ms 06 50 79ms 1ms 07 45 61ms 1ms 08 49 65ms 1ms 09 42 61ms 1ms 10 45 64ms 1ms 11 45 63ms 1ms 12 57 81ms 1ms 13 55 79ms 1ms 14 57 78ms 1ms 15 57 81ms 1ms 16 56 80ms 1ms 17 58 81ms 1ms 18 56 81ms 1ms 19 56 80ms 1ms 20 56 78ms 1ms 21 56 81ms 1ms 22 54 75ms 1ms 23 54 74ms 1ms 00 54 72ms 1ms [ User: symmetricds - Total duration: 1s754ms - Times executed: 1233 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s754ms - Times executed: 1233 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-04 05:49:58 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 18:04:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:26:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1s550ms 502 1ms 6ms 3ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? AND i.indisprimary ORDER BY table_name, pk_name, key_seq;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 01 85 282ms 3ms 02 19 65ms 3ms 03 19 61ms 3ms 04 19 67ms 3ms 05 19 64ms 3ms 06 19 62ms 3ms 07 19 61ms 3ms 08 19 65ms 3ms 09 18 64ms 3ms 10 19 66ms 3ms 11 19 42ms 2ms 12 19 59ms 3ms 13 18 53ms 2ms 14 18 46ms 2ms 15 19 60ms 3ms 16 18 42ms 2ms 17 19 55ms 2ms 18 19 55ms 2ms 19 19 55ms 2ms 20 19 41ms 2ms 21 19 50ms 2ms 22 3 9ms 3ms 23 19 74ms 3ms 00 19 39ms 2ms [ User: symmetricds - Total duration: 1s550ms - Times executed: 502 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s550ms - Times executed: 502 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'homeward_actions' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'alert_confirmations' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2019-08-04 03:00:01 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 00:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7,069,191 1m49s 0ms 7ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 01 318,338 4s932ms 0ms 02 318,504 4s930ms 0ms 03 321,199 5s2ms 0ms 04 319,362 4s952ms 0ms 05 317,816 4s875ms 0ms 06 323,443 5s4ms 0ms 07 320,562 5s11ms 0ms 08 323,730 5s6ms 0ms 09 322,838 5s45ms 0ms 10 323,268 5s15ms 0ms 11 320,329 4s925ms 0ms 12 324,533 5s89ms 0ms 13 322,081 4s977ms 0ms 14 325,467 5s45ms 0ms 15 324,657 4s990ms 0ms 16 323,037 4s937ms 0ms 17 325,834 5s28ms 0ms 18 318,601 4s870ms 0ms 19 322,436 4s865ms 0ms 20 318,717 4s920ms 0ms 21 51,789 764ms 0ms 22 16,893 288ms 0ms 23 248,649 3s862ms 0ms 00 317,108 4s903ms 0ms [ User: symmetricds - Total duration: 1m49s - Times executed: 7068642 ]
[ User: pharmisight - Total duration: 26ms - Times executed: 549 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m49s - Times executed: 7069191 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-04 11:11:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:17:57 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:24:02 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4,110,786 41s477ms 0ms 14ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 01 187,438 1s891ms 0ms 02 186,327 1s890ms 0ms 03 187,251 1s887ms 0ms 04 186,486 1s887ms 0ms 05 186,084 1s869ms 0ms 06 188,096 1s907ms 0ms 07 186,732 1s885ms 0ms 08 188,043 1s887ms 0ms 09 187,619 1s945ms 0ms 10 187,899 1s892ms 0ms 11 186,759 1s877ms 0ms 12 188,249 1s922ms 0ms 13 187,360 1s873ms 0ms 14 188,544 1s911ms 0ms 15 188,314 1s901ms 0ms 16 187,744 1s871ms 0ms 17 188,658 1s908ms 0ms 18 186,141 1s854ms 0ms 19 187,529 1s833ms 0ms 20 186,125 1s884ms 0ms 21 27,100 261ms 0ms 22 6,197 75ms 0ms 23 144,483 1s457ms 0ms 00 185,608 1s899ms 0ms [ User: symmetricds - Total duration: 41s477ms - Times executed: 4110786 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 41s477ms - Times executed: 4110786 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-04 16:04:07 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:19:10 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:15:04 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 2,747,488 17s828ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 04 01 125,990 813ms 0ms 02 125,079 804ms 0ms 03 125,107 819ms 0ms 04 124,906 808ms 0ms 05 125,114 806ms 0ms 06 125,337 829ms 0ms 07 124,751 808ms 0ms 08 125,115 818ms 0ms 09 124,895 818ms 0ms 10 125,091 812ms 0ms 11 124,853 815ms 0ms 12 125,020 822ms 0ms 13 124,923 811ms 0ms 14 124,996 824ms 0ms 15 125,087 823ms 0ms 16 125,038 808ms 0ms 17 124,997 800ms 0ms 18 124,848 802ms 0ms 19 125,027 788ms 0ms 20 124,757 798ms 0ms 21 19,304 114ms 0ms 22 5,360 35ms 0ms 23 97,133 628ms 0ms 00 124,760 812ms 0ms [ User: symmetricds - Total duration: 17s826ms - Times executed: 2747225 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s828ms - Times executed: 2747488 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-04 05:40:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 07:50:03 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:28:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2,747,478 15m5s 0ms 803ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 04 01 125,989 39s576ms 0ms 02 125,079 39s992ms 0ms 03 125,107 41s144ms 0ms 04 124,904 39s688ms 0ms 05 125,114 41s744ms 0ms 06 125,335 41s737ms 0ms 07 124,752 40s179ms 0ms 08 125,114 43s638ms 0ms 09 124,894 42s131ms 0ms 10 125,092 40s608ms 0ms 11 124,850 41s159ms 0ms 12 125,018 41s818ms 0ms 13 124,922 40s832ms 0ms 14 124,998 43s95ms 0ms 15 125,086 40s855ms 0ms 16 125,039 42s503ms 0ms 17 124,995 41s84ms 0ms 18 124,846 41s166ms 0ms 19 125,029 42s736ms 0ms 20 124,759 40s620ms 0ms 21 19,304 6s207ms 0ms 22 5,360 197ms 0ms 23 97,133 31s645ms 0ms 00 124,759 41s479ms 0ms [ User: symmetricds - Total duration: 15m5s - Times executed: 2747216 ]
[ User: pharmisight - Total duration: 18ms - Times executed: 262 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m5s - Times executed: 2747478 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-04 13:10:05 Duration: 803ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 18:50:05 Duration: 738ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 10:50:05 Duration: 695ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1,735,743 7m1s 0ms 15ms 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 04 01 79,317 19s213ms 0ms 02 79,425 19s355ms 0ms 03 79,441 19s495ms 0ms 04 79,301 19s218ms 0ms 05 79,410 18s982ms 0ms 06 79,534 19s352ms 0ms 07 79,135 19s204ms 0ms 08 79,394 19s234ms 0ms 09 79,266 19s688ms 0ms 10 79,410 19s219ms 0ms 11 79,236 19s365ms 0ms 12 79,325 19s433ms 0ms 13 79,266 19s111ms 0ms 14 79,323 19s298ms 0ms 15 79,353 19s298ms 0ms 16 79,335 19s261ms 0ms 17 79,300 19s236ms 0ms 18 79,205 18s916ms 0ms 19 79,319 18s601ms 0ms 20 79,143 19s221ms 0ms 21 9,262 1s998ms 0ms 22 5 1ms 0ms 23 60,891 14s931ms 0ms 00 79,147 19s431ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1735743 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1735743 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3968', extract_count = '4072', sent_count = '4072', load_count = '4072', data_row_count = '7', reload_row_count = '0', data_insert_row_count = '3', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 16:18:48.028', transfer_start_time = '2019-08-04 17:47:07.741', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '7', extract_insert_row_count = '3', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195615' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '5205', extract_count = '3971', sent_count = '3971', load_count = '3971', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '33', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '4', extract_start_time = '2019-08-01 15:12:45.663', transfer_start_time = '2019-08-04 15:00:03.558', 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 = '6', extract_insert_row_count = '2', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195197' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '13159', extract_count = '3933', sent_count = '3933', load_count = '3933', data_row_count = '40', reload_row_count = '0', data_insert_row_count = '18', data_update_row_count = '22', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '22', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '36', extract_start_time = '2019-08-01 15:10:44.096', transfer_start_time = '2019-08-04 14:20:03.72', 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 = '40', extract_insert_row_count = '18', extract_update_row_count = '22', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195181' AND node_id = '2';
Date: 2019-08-04 17:47:07 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:00:03 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:20:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1,351,429 16s295ms 0ms 2ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 01 60,521 701ms 0ms 02 60,773 731ms 0ms 03 61,663 739ms 0ms 04 61,105 745ms 0ms 05 60,492 723ms 0ms 06 62,281 762ms 0ms 07 61,504 747ms 0ms 08 62,450 751ms 0ms 09 62,241 762ms 0ms 10 62,332 755ms 0ms 11 61,426 738ms 0ms 12 62,746 768ms 0ms 13 61,966 738ms 0ms 14 63,067 766ms 0ms 15 62,747 755ms 0ms 16 62,233 741ms 0ms 17 63,176 756ms 0ms 18 60,819 737ms 0ms 19 62,029 743ms 0ms 20 60,889 741ms 0ms 21 7,331 83ms 0ms 22 382 6ms 0ms 23 46,877 568ms 0ms 00 60,379 727ms 0ms [ User: symmetricds - Total duration: 16s295ms - Times executed: 1351429 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s295ms - Times executed: 1351429 ]
-
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-04 19:25:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:17:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:04:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1,351,402 15s736ms 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 04 01 60,521 671ms 0ms 02 60,772 707ms 0ms 03 61,661 712ms 0ms 04 61,105 716ms 0ms 05 60,489 696ms 0ms 06 62,276 739ms 0ms 07 61,504 719ms 0ms 08 62,450 730ms 0ms 09 62,240 739ms 0ms 10 62,329 729ms 0ms 11 61,424 708ms 0ms 12 62,748 746ms 0ms 13 61,963 717ms 0ms 14 63,068 741ms 0ms 15 62,744 726ms 0ms 16 62,232 711ms 0ms 17 63,178 730ms 0ms 18 60,815 715ms 0ms 19 62,027 722ms 0ms 20 60,887 714ms 0ms 21 7,332 78ms 0ms 22 382 5ms 0ms 23 46,877 551ms 0ms 00 60,378 702ms 0ms [ User: symmetricds - Total duration: 15s736ms - Times executed: 1351402 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s736ms - Times executed: 1351402 ]
-
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-04 23:46:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:48:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 08:59:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 890,371 40s369ms 0ms 9ms 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 04 01 40,619 1s856ms 0ms 02 40,671 1s849ms 0ms 03 40,678 1s870ms 0ms 04 40,609 1s845ms 0ms 05 40,664 1s815ms 0ms 06 40,723 1s856ms 0ms 07 40,526 1s834ms 0ms 08 40,654 1s841ms 0ms 09 40,589 1s864ms 0ms 10 40,666 1s837ms 0ms 11 40,576 1s836ms 0ms 12 40,624 1s873ms 0ms 13 40,592 1s847ms 0ms 14 40,619 1s858ms 0ms 15 40,639 1s845ms 0ms 16 40,627 1s833ms 0ms 17 40,609 1s822ms 0ms 18 40,561 1s826ms 0ms 19 40,619 1s793ms 0ms 20 40,529 1s822ms 0ms 21 5,380 228ms 0ms 22 721 39ms 0ms 23 31,348 1s426ms 0ms 00 40,528 1s842ms 0ms [ User: symmetricds - Total duration: 40s369ms - Times executed: 890371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s369ms - Times executed: 890371 ]
-
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 = '0';
Date: 2019-08-04 03:52:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 01:54:02 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:56:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 865,324 3m25s 0ms 14ms 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 04 01 39,541 9s544ms 0ms 02 39,595 9s477ms 0ms 03 39,603 9s602ms 0ms 04 39,532 9s419ms 0ms 05 39,589 9s225ms 0ms 06 39,653 9s381ms 0ms 07 39,449 9s344ms 0ms 08 39,580 9s406ms 0ms 09 39,517 9s431ms 0ms 10 39,590 9s282ms 0ms 11 39,502 9s375ms 0ms 12 39,542 9s586ms 0ms 13 39,518 9s327ms 0ms 14 39,544 9s521ms 0ms 15 39,559 9s501ms 0ms 16 39,551 9s403ms 0ms 17 39,534 9s390ms 0ms 18 39,486 9s331ms 0ms 19 39,542 9s298ms 0ms 20 39,457 9s340ms 0ms 21 4,619 987ms 0ms 22 5 1ms 0ms 23 30,354 7s203ms 0ms 00 39,462 9s366ms 0ms [ User: symmetricds - Total duration: 3m25s - Times executed: 865324 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m25s - Times executed: 865324 ]
-
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 = '9195471' 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 = '9195499' 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 = '9195628' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-04 14:14:06 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 13:38:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 11:35:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 475,869 29s665ms 0ms 10ms 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 04 01 20,548 1s281ms 0ms 02 20,747 1s278ms 0ms 03 21,629 1s318ms 0ms 04 21,143 1s322ms 0ms 05 20,473 1s276ms 0ms 06 22,194 1s388ms 0ms 07 21,621 1s394ms 0ms 08 22,441 1s397ms 0ms 09 22,291 1s406ms 0ms 10 22,310 1s405ms 0ms 11 21,490 1s316ms 0ms 12 22,774 1s442ms 0ms 13 22,016 1s371ms 0ms 14 23,092 1s418ms 0ms 15 22,753 1s371ms 0ms 16 22,251 1s328ms 0ms 17 23,211 1s423ms 0ms 18 20,899 1s337ms 0ms 19 22,056 1s358ms 0ms 20 21,002 1s351ms 0ms 21 2,334 133ms 0ms 22 5 0ms 0ms 23 16,104 1s40ms 0ms 00 20,485 1s301ms 0ms [ User: symmetricds - Total duration: 29s665ms - Times executed: 475869 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s665ms - Times executed: 475869 ]
-
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 = '9196005' 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 = '9196367' 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 = '9195415' AND node_id = '2';
Date: 2019-08-04 19:53:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:17:08 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:57:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 47,563 1m10s 0ms 59ms 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 04 01 2,164 3s89ms 1ms 02 2,164 3s206ms 1ms 03 2,164 3s152ms 1ms 04 2,164 3s238ms 1ms 05 2,164 3s117ms 1ms 06 2,164 3s288ms 1ms 07 2,164 3s176ms 1ms 08 2,164 3s113ms 1ms 09 2,164 3s300ms 1ms 10 2,164 3s195ms 1ms 11 2,164 3s152ms 1ms 12 2,155 3s208ms 1ms 13 2,137 3s84ms 1ms 14 2,164 3s159ms 1ms 15 2,164 3s274ms 1ms 16 2,164 3s77ms 1ms 17 2,164 3s152ms 1ms 18 2,164 3s406ms 1ms 19 2,164 3s285ms 1ms 20 2,164 3s242ms 1ms 21 362 448ms 1ms 22 125 119ms 0ms 23 1,667 2s436ms 1ms 00 2,165 3s264ms 1ms [ User: symmetricds - Total duration: 1m10s - Times executed: 47563 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m10s - Times executed: 47563 ]
-
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-04 05:56:58 Duration: 59ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:54:57 Duration: 48ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 17:18:01 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 24,965 1s275ms 0ms 4ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 01 1,128 60ms 0ms 02 1,044 52ms 0ms 03 1,044 56ms 0ms 04 1,038 52ms 0ms 05 1,040 49ms 0ms 06 1,044 53ms 0ms 07 1,046 51ms 0ms 08 1,044 50ms 0ms 09 1,042 52ms 0ms 10 1,036 52ms 0ms 11 1,042 52ms 0ms 12 1,044 53ms 0ms 13 1,040 56ms 0ms 14 1,030 51ms 0ms 15 1,042 54ms 0ms 16 1,038 52ms 0ms 17 1,040 52ms 0ms 18 1,040 51ms 0ms 19 1,040 51ms 0ms 20 1,040 51ms 0ms 21 993 52ms 0ms 22 991 54ms 0ms 23 1,030 49ms 0ms 00 1,049 59ms 0ms [ User: symmetricds - Total duration: 1s275ms - Times executed: 24965 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s275ms - Times executed: 24965 ]
-
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-04 12:35:59 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:16:03 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:36:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 24,648 1s366ms 0ms 4ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 01 1,027 30ms 0ms 02 1,027 59ms 0ms 03 1,027 53ms 0ms 04 1,027 52ms 0ms 05 1,027 62ms 0ms 06 1,027 40ms 0ms 07 1,027 84ms 0ms 08 1,027 68ms 0ms 09 1,027 35ms 0ms 10 1,027 61ms 0ms 11 1,027 66ms 0ms 12 1,027 57ms 0ms 13 1,027 62ms 0ms 14 1,027 66ms 0ms 15 1,027 50ms 0ms 16 1,027 58ms 0ms 17 1,027 58ms 0ms 18 1,027 55ms 0ms 19 1,027 56ms 0ms 20 1,027 56ms 0ms 21 1,027 53ms 0ms 22 1,027 55ms 0ms 23 1,027 64ms 0ms 00 1,027 56ms 0ms [ User: pharmisight - Total duration: 1s366ms - Times executed: 24648 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s366ms - Times executed: 24648 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2903' 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 = '3436' 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 = '33074350' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-04 06:40:01 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 21,888 1s208ms 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 04 01 912 27ms 0ms 02 912 54ms 0ms 03 912 48ms 0ms 04 912 45ms 0ms 05 912 56ms 0ms 06 912 36ms 0ms 07 912 66ms 0ms 08 912 59ms 0ms 09 912 31ms 0ms 10 912 58ms 0ms 11 912 57ms 0ms 12 912 51ms 0ms 13 912 53ms 0ms 14 912 58ms 0ms 15 912 45ms 0ms 16 912 51ms 0ms 17 912 50ms 0ms 18 912 49ms 0ms 19 912 50ms 0ms 20 912 49ms 0ms 21 912 48ms 0ms 22 912 49ms 0ms 23 912 57ms 0ms 00 912 50ms 0ms [ User: pharmisight - Total duration: 1s208ms - Times executed: 21888 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s208ms - Times executed: 21888 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2882' 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 = '3082' 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 = '1779' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-04 09:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 04:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 17,280 23s586ms 0ms 58ms 1ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 04 01 720 974ms 1ms 02 720 960ms 1ms 03 720 941ms 1ms 04 720 996ms 1ms 05 720 934ms 1ms 06 720 994ms 1ms 07 720 928ms 1ms 08 720 910ms 1ms 09 720 1s45ms 1ms 10 720 1s1ms 1ms 11 720 967ms 1ms 12 720 990ms 1ms 13 720 940ms 1ms 14 720 1s23ms 1ms 15 720 948ms 1ms 16 720 930ms 1ms 17 720 983ms 1ms 18 720 1s19ms 1ms 19 720 1s49ms 1ms 20 720 986ms 1ms 21 720 1s32ms 1ms 22 720 1s69ms 1ms 23 720 1s12ms 1ms 00 720 944ms 1ms [ User: symmetricds - Total duration: 23s586ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23s586ms - Times executed: 17280 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-04 17:22:55 Duration: 58ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 09:07:53 Duration: 28ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 20:40:58 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 17,242 480ms 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 04 01 718 18ms 0ms 02 718 19ms 0ms 03 720 19ms 0ms 04 718 19ms 0ms 05 718 19ms 0ms 06 720 19ms 0ms 07 718 19ms 0ms 08 720 19ms 0ms 09 718 19ms 0ms 10 716 20ms 0ms 11 720 19ms 0ms 12 718 20ms 0ms 13 718 20ms 0ms 14 720 19ms 0ms 15 718 19ms 0ms 16 718 19ms 0ms 17 718 20ms 0ms 18 718 20ms 0ms 19 720 20ms 0ms 20 718 20ms 0ms 21 720 21ms 0ms 22 718 21ms 0ms 23 716 20ms 0ms 00 718 20ms 0ms [ User: symmetricds - Total duration: 480ms - Times executed: 17242 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 480ms - Times executed: 17242 ]
-
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-04 12:34:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 01:50:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:56:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 17,188 9s607ms 0ms 4ms 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 04 01 719 384ms 0ms 02 716 396ms 0ms 03 716 400ms 0ms 04 716 401ms 0ms 05 716 390ms 0ms 06 715 395ms 0ms 07 718 397ms 0ms 08 716 395ms 0ms 09 718 401ms 0ms 10 716 403ms 0ms 11 716 390ms 0ms 12 716 401ms 0ms 13 716 391ms 0ms 14 714 401ms 0ms 15 718 397ms 0ms 16 716 393ms 0ms 17 716 399ms 0ms 18 716 393ms 0ms 19 716 403ms 0ms 20 714 402ms 0ms 21 718 434ms 0ms 22 716 427ms 0ms 23 716 402ms 0ms 00 714 400ms 0ms [ User: symmetricds - Total duration: 9s607ms - Times executed: 17188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s607ms - Times executed: 17188 ]
-
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-04 06:38:51 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 19:50:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:48:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 8,593 304ms 0ms 3ms 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 04 01 359 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 357 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 359 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 357 12ms 0ms 15 359 12ms 0ms 16 358 12ms 0ms 17 358 11ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 357 12ms 0ms 21 359 16ms 0ms 22 358 13ms 0ms 23 358 13ms 0ms 00 357 12ms 0ms [ User: symmetricds - Total duration: 304ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 304ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-08-04 20:41:12 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 17:15:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:51:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 8,593 219ms 0ms 1ms 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 #19
Day Hour Count Duration Avg duration Aug 04 01 359 9ms 0ms 02 358 9ms 0ms 03 358 9ms 0ms 04 358 9ms 0ms 05 358 8ms 0ms 06 357 9ms 0ms 07 359 9ms 0ms 08 358 8ms 0ms 09 359 8ms 0ms 10 358 10ms 0ms 11 358 8ms 0ms 12 358 9ms 0ms 13 358 9ms 0ms 14 357 9ms 0ms 15 359 9ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 357 9ms 0ms 21 359 9ms 0ms 22 358 9ms 0ms 23 358 9ms 0ms 00 357 8ms 0ms [ User: symmetricds - Total duration: 219ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 219ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808607' AND data_id <= '154808606' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808526' AND data_id <= '154808525' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '104808562' AND data_id <= '154808561' ORDER BY data_id ASC;
Date: 2019-08-04 09:28:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:46:57 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:38:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 8,593 408ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 01 359 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 358 17ms 0ms 05 358 16ms 0ms 06 357 16ms 0ms 07 359 16ms 0ms 08 358 16ms 0ms 09 359 17ms 0ms 10 358 16ms 0ms 11 358 15ms 0ms 12 358 16ms 0ms 13 358 17ms 0ms 14 357 17ms 0ms 15 359 17ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 18ms 0ms 20 357 17ms 0ms 21 359 17ms 0ms 22 358 17ms 0ms 23 358 17ms 0ms 00 357 17ms 0ms [ User: symmetricds - Total duration: 408ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 408ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-08-04 18:21:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 13:58:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:58:07 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 44ms 103ms 79ms 24 1s903ms 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 04 01 1 86ms 86ms 02 1 86ms 86ms 03 1 89ms 89ms 04 1 90ms 90ms 05 1 103ms 103ms 06 1 90ms 90ms 07 1 82ms 82ms 08 1 85ms 85ms 09 1 85ms 85ms 10 1 87ms 87ms 11 1 45ms 45ms 12 1 80ms 80ms 13 1 66ms 66ms 14 1 49ms 49ms 15 1 79ms 79ms 16 1 44ms 44ms 17 1 79ms 79ms 18 1 81ms 81ms 19 1 81ms 81ms 20 1 79ms 79ms 21 1 79ms 79ms 22 1 84ms 84ms 23 1 82ms 82ms 00 1 82ms 82ms [ User: symmetricds - Total duration: 1s903ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s903ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-08-04 04:00:00 Duration: 103ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7ms 51ms 18ms 384 7s138ms 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 04 01 16 307ms 19ms 02 16 364ms 22ms 03 16 329ms 20ms 04 16 370ms 23ms 05 16 299ms 18ms 06 16 313ms 19ms 07 16 315ms 19ms 08 16 316ms 19ms 09 16 320ms 20ms 10 16 324ms 20ms 11 16 172ms 10ms 12 16 352ms 22ms 13 16 296ms 18ms 14 16 192ms 12ms 15 16 289ms 18ms 16 16 155ms 9ms 17 16 291ms 18ms 18 16 308ms 19ms 19 16 181ms 11ms 20 16 296ms 18ms 21 16 311ms 19ms 22 16 428ms 26ms 23 16 306ms 19ms 00 16 294ms 18ms [ User: symmetricds - Total duration: 7s138ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s138ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808502' AND create_time < '2019-08-03 01:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808502') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808502' 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 '104804165' AND '104808526' AND create_time < '2019-08-03 03:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808526') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808526' 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 '104754155' AND '104759155' AND create_time < '2019-08-03 21:00:00.003' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104754155' AND '104759155' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-04 01:00:00 Duration: 51ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:00:00 Duration: 49ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 48ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4ms 27ms 9ms 384 3s736ms 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 04 01 16 176ms 11ms 02 16 175ms 10ms 03 16 169ms 10ms 04 16 170ms 10ms 05 16 163ms 10ms 06 16 169ms 10ms 07 16 167ms 10ms 08 16 175ms 10ms 09 16 182ms 11ms 10 16 168ms 10ms 11 16 89ms 5ms 12 16 171ms 10ms 13 16 139ms 8ms 14 16 97ms 6ms 15 16 163ms 10ms 16 16 88ms 5ms 17 16 163ms 10ms 18 16 163ms 10ms 19 16 103ms 6ms 20 16 164ms 10ms 21 16 166ms 10ms 22 16 174ms 10ms 23 16 166ms 10ms 00 16 165ms 10ms [ User: symmetricds - Total duration: 3s736ms - Times executed: 384 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s736ms - Times executed: 384 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '104804165' AND '104808586' AND data_id < '104808589' AND create_time < '2019-08-03 08:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104804165' AND '104808586');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104789162' AND '104794162' AND data_id < '104808742' AND create_time < '2019-08-03 21:00:00.003' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104789162' AND '104794162');
-
DELETE FROM sym_data WHERE data_id BETWEEN '104739152' AND '104744152' AND data_id < '104808742' AND create_time < '2019-08-03 21:00:00.003' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '104739152' AND '104744152');
Date: 2019-08-04 08:00:00 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 15ms 7ms 547 3s837ms 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 04 01 130 849ms 6ms 02 19 153ms 8ms 03 19 140ms 7ms 04 19 158ms 8ms 05 19 151ms 7ms 06 19 148ms 7ms 07 19 145ms 7ms 08 19 153ms 8ms 09 18 150ms 8ms 10 19 159ms 8ms 11 19 101ms 5ms 12 19 140ms 7ms 13 18 126ms 7ms 14 18 110ms 6ms 15 19 142ms 7ms 16 18 100ms 5ms 17 19 133ms 7ms 18 19 132ms 6ms 19 19 129ms 6ms 20 19 95ms 5ms 21 19 121ms 6ms 22 3 23ms 7ms 23 19 175ms 9ms 00 19 92ms 4ms [ User: symmetricds - Total duration: 3s633ms - Times executed: 502 ]
[ User: pharmisight - Total duration: 204ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s837ms - Times executed: 547 ]
-
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 = 'homeward_actions' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-04 03:00:01 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 09:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 15ms 3ms 1,110 4s166ms 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 04 01 45 168ms 3ms 02 44 163ms 3ms 03 44 166ms 3ms 04 45 182ms 4ms 05 41 146ms 3ms 06 50 188ms 3ms 07 45 175ms 3ms 08 48 170ms 3ms 09 43 167ms 3ms 10 42 158ms 3ms 11 40 154ms 3ms 12 55 210ms 3ms 13 49 180ms 3ms 14 54 200ms 3ms 15 53 197ms 3ms 16 55 205ms 3ms 17 55 205ms 3ms 18 55 210ms 3ms 19 49 185ms 3ms 20 54 201ms 3ms 21 25 91ms 3ms 22 23 88ms 3ms 23 45 163ms 3ms 00 51 186ms 3ms [ User: symmetricds - Total duration: 4s166ms - Times executed: 1110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s166ms - Times executed: 1110 ]
-
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-04 03:34:57 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 03:17:57 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:04 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1ms 6ms 3ms 502 1s550ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? AND i.indisprimary ORDER BY table_name, pk_name, key_seq;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 01 85 282ms 3ms 02 19 65ms 3ms 03 19 61ms 3ms 04 19 67ms 3ms 05 19 64ms 3ms 06 19 62ms 3ms 07 19 61ms 3ms 08 19 65ms 3ms 09 18 64ms 3ms 10 19 66ms 3ms 11 19 42ms 2ms 12 19 59ms 3ms 13 18 53ms 2ms 14 18 46ms 2ms 15 19 60ms 3ms 16 18 42ms 2ms 17 19 55ms 2ms 18 19 55ms 2ms 19 19 55ms 2ms 20 19 41ms 2ms 21 19 50ms 2ms 22 3 9ms 3ms 23 19 74ms 3ms 00 19 39ms 2ms [ User: symmetricds - Total duration: 1s550ms - Times executed: 502 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s550ms - Times executed: 502 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'homeward_actions' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'alert_confirmations' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_node_host' AND i.indisprimary ORDER BY table_name, pk_name, key_seq;
Date: 2019-08-04 03:00:01 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 00:00:01 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 59ms 1ms 47,563 1m10s SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 04 01 2,164 3s89ms 1ms 02 2,164 3s206ms 1ms 03 2,164 3s152ms 1ms 04 2,164 3s238ms 1ms 05 2,164 3s117ms 1ms 06 2,164 3s288ms 1ms 07 2,164 3s176ms 1ms 08 2,164 3s113ms 1ms 09 2,164 3s300ms 1ms 10 2,164 3s195ms 1ms 11 2,164 3s152ms 1ms 12 2,155 3s208ms 1ms 13 2,137 3s84ms 1ms 14 2,164 3s159ms 1ms 15 2,164 3s274ms 1ms 16 2,164 3s77ms 1ms 17 2,164 3s152ms 1ms 18 2,164 3s406ms 1ms 19 2,164 3s285ms 1ms 20 2,164 3s242ms 1ms 21 362 448ms 1ms 22 125 119ms 0ms 23 1,667 2s436ms 1ms 00 2,165 3s264ms 1ms [ User: symmetricds - Total duration: 1m10s - Times executed: 47563 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m10s - Times executed: 47563 ]
-
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-04 05:56:58 Duration: 59ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 02:54:57 Duration: 48ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 17:18:01 Duration: 43ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 9ms 1ms 1,233 1s754ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 04 01 47 64ms 1ms 02 45 62ms 1ms 03 46 66ms 1ms 04 47 68ms 1ms 05 46 66ms 1ms 06 50 79ms 1ms 07 45 61ms 1ms 08 49 65ms 1ms 09 42 61ms 1ms 10 45 64ms 1ms 11 45 63ms 1ms 12 57 81ms 1ms 13 55 79ms 1ms 14 57 78ms 1ms 15 57 81ms 1ms 16 56 80ms 1ms 17 58 81ms 1ms 18 56 81ms 1ms 19 56 80ms 1ms 20 56 78ms 1ms 21 56 81ms 1ms 22 54 75ms 1ms 23 54 74ms 1ms 00 54 72ms 1ms [ User: symmetricds - Total duration: 1s754ms - Times executed: 1233 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s754ms - Times executed: 1233 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-04 05:49:58 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 18:04:01 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:26:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 58ms 1ms 17,280 23s586ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = ? AND status IN (...) ORDER BY batch_id ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 04 01 720 974ms 1ms 02 720 960ms 1ms 03 720 941ms 1ms 04 720 996ms 1ms 05 720 934ms 1ms 06 720 994ms 1ms 07 720 928ms 1ms 08 720 910ms 1ms 09 720 1s45ms 1ms 10 720 1s1ms 1ms 11 720 967ms 1ms 12 720 990ms 1ms 13 720 940ms 1ms 14 720 1s23ms 1ms 15 720 948ms 1ms 16 720 930ms 1ms 17 720 983ms 1ms 18 720 1s19ms 1ms 19 720 1s49ms 1ms 20 720 986ms 1ms 21 720 1s32ms 1ms 22 720 1s69ms 1ms 23 720 1s12ms 1ms 00 720 944ms 1ms [ User: symmetricds - Total duration: 23s586ms - Times executed: 17280 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23s586ms - Times executed: 17280 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE node_id = '2' AND status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY batch_id ASC;
Date: 2019-08-04 17:22:55 Duration: 58ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 09:07:53 Duration: 28ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 20:40:58 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 4ms 0ms 17,188 9s607ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 04 01 719 384ms 0ms 02 716 396ms 0ms 03 716 400ms 0ms 04 716 401ms 0ms 05 716 390ms 0ms 06 715 395ms 0ms 07 718 397ms 0ms 08 716 395ms 0ms 09 718 401ms 0ms 10 716 403ms 0ms 11 716 390ms 0ms 12 716 401ms 0ms 13 716 391ms 0ms 14 714 401ms 0ms 15 718 397ms 0ms 16 716 393ms 0ms 17 716 399ms 0ms 18 716 393ms 0ms 19 716 403ms 0ms 20 714 402ms 0ms 21 718 434ms 0ms 22 716 427ms 0ms 23 716 402ms 0ms 00 714 400ms 0ms [ User: symmetricds - Total duration: 9s607ms - Times executed: 17188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s607ms - Times executed: 17188 ]
-
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-04 06:38:51 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 19:50:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:48:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 803ms 0ms 2,747,478 15m5s COMMIT;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 04 01 125,989 39s576ms 0ms 02 125,079 39s992ms 0ms 03 125,107 41s144ms 0ms 04 124,904 39s688ms 0ms 05 125,114 41s744ms 0ms 06 125,335 41s737ms 0ms 07 124,752 40s179ms 0ms 08 125,114 43s638ms 0ms 09 124,894 42s131ms 0ms 10 125,092 40s608ms 0ms 11 124,850 41s159ms 0ms 12 125,018 41s818ms 0ms 13 124,922 40s832ms 0ms 14 124,998 43s95ms 0ms 15 125,086 40s855ms 0ms 16 125,039 42s503ms 0ms 17 124,995 41s84ms 0ms 18 124,846 41s166ms 0ms 19 125,029 42s736ms 0ms 20 124,759 40s620ms 0ms 21 19,304 6s207ms 0ms 22 5,360 197ms 0ms 23 97,133 31s645ms 0ms 00 124,759 41s479ms 0ms [ User: symmetricds - Total duration: 15m5s - Times executed: 2747216 ]
[ User: pharmisight - Total duration: 18ms - Times executed: 262 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m5s - Times executed: 2747478 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-04 13:10:05 Duration: 803ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 18:50:05 Duration: 738ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 10:50:05 Duration: 695ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 15ms 0ms 1,735,743 7m1s UPDATE sym_outgoing_batch SET status = ?, load_id = ?, extract_job_flag = ?, load_flag = ?, error_flag = ?, byte_count = ?, extract_count = ?, sent_count = ?, load_count = ?, data_row_count = ?, reload_row_count = ?, data_insert_row_count = ?, data_update_row_count = ?, data_delete_row_count = ?, other_row_count = ?, ignore_count = ?, router_millis = ?, network_millis = ?, filter_millis = ?, load_millis = ?, extract_millis = ?, extract_start_time = ?, transfer_start_time = ?, load_start_time = NULL, sql_state = NULL, sql_code = ?, sql_message = NULL, failed_data_id = ?, last_update_hostname = ?, last_update_time = current_timestamp, summary = ?, load_row_count = ?, load_insert_row_count = ?, load_update_row_count = ?, load_delete_row_count = ?, fallback_insert_count = ?, fallback_update_count = ?, ignore_row_count = ?, missing_delete_count = ?, skip_count = ?, extract_row_count = ?, extract_insert_row_count = ?, extract_update_row_count = ?, extract_delete_row_count = ?, transform_extract_millis = ?, transform_load_millis = ? WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 01 79,317 19s213ms 0ms 02 79,425 19s355ms 0ms 03 79,441 19s495ms 0ms 04 79,301 19s218ms 0ms 05 79,410 18s982ms 0ms 06 79,534 19s352ms 0ms 07 79,135 19s204ms 0ms 08 79,394 19s234ms 0ms 09 79,266 19s688ms 0ms 10 79,410 19s219ms 0ms 11 79,236 19s365ms 0ms 12 79,325 19s433ms 0ms 13 79,266 19s111ms 0ms 14 79,323 19s298ms 0ms 15 79,353 19s298ms 0ms 16 79,335 19s261ms 0ms 17 79,300 19s236ms 0ms 18 79,205 18s916ms 0ms 19 79,319 18s601ms 0ms 20 79,143 19s221ms 0ms 21 9,262 1s998ms 0ms 22 5 1ms 0ms 23 60,891 14s931ms 0ms 00 79,147 19s431ms 0ms [ User: symmetricds - Total duration: 7m1s - Times executed: 1735743 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m1s - Times executed: 1735743 ]
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '3968', extract_count = '4072', sent_count = '4072', load_count = '4072', data_row_count = '7', reload_row_count = '0', data_insert_row_count = '3', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '20', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '7', extract_start_time = '2019-08-01 16:18:48.028', transfer_start_time = '2019-08-04 17:47:07.741', load_start_time = NULL, sql_state = NULL, sql_code = '0', sql_message = NULL, failed_data_id = '0', last_update_hostname = 'scancheck', last_update_time = current_timestamp, summary = 'order_line_activities, order_lines', load_row_count = '0', load_insert_row_count = '0', load_update_row_count = '0', load_delete_row_count = '0', fallback_insert_count = '0', fallback_update_count = '0', ignore_row_count = '0', missing_delete_count = '0', skip_count = '0', extract_row_count = '7', extract_insert_row_count = '3', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195615' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '5205', extract_count = '3971', sent_count = '3971', load_count = '3971', data_row_count = '6', reload_row_count = '0', data_insert_row_count = '2', data_update_row_count = '4', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '33', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '4', extract_start_time = '2019-08-01 15:12:45.663', transfer_start_time = '2019-08-04 15:00:03.558', 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 = '6', extract_insert_row_count = '2', extract_update_row_count = '4', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195197' AND node_id = '2';
-
UPDATE sym_outgoing_batch SET status = 'LD', load_id = '-1', extract_job_flag = '0', load_flag = '0', error_flag = '0', byte_count = '13159', extract_count = '3933', sent_count = '3933', load_count = '3933', data_row_count = '40', reload_row_count = '0', data_insert_row_count = '18', data_update_row_count = '22', data_delete_row_count = '0', other_row_count = '0', ignore_count = '0', router_millis = '22', network_millis = '0', filter_millis = '0', load_millis = '0', extract_millis = '36', extract_start_time = '2019-08-01 15:10:44.096', transfer_start_time = '2019-08-04 14:20:03.72', 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 = '40', extract_insert_row_count = '18', extract_update_row_count = '22', extract_delete_row_count = '0', transform_extract_millis = '0', transform_load_millis = '0' WHERE batch_id = '9195181' AND node_id = '2';
Date: 2019-08-04 17:47:07 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:00:03 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:20:03 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 14ms 0ms 865,324 3m25s SELECT d.data_id, d.table_name, d.event_type, d.row_data AS row_data, d.pk_data AS pk_data, d.old_data AS old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id FROM sym_data d INNER JOIN sym_data_event e ON d.data_id = e.data_id INNER JOIN sym_outgoing_batch o ON o.batch_id = e.batch_id WHERE o.batch_id = ? AND o.node_id = ? ORDER BY d.data_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 01 39,541 9s544ms 0ms 02 39,595 9s477ms 0ms 03 39,603 9s602ms 0ms 04 39,532 9s419ms 0ms 05 39,589 9s225ms 0ms 06 39,653 9s381ms 0ms 07 39,449 9s344ms 0ms 08 39,580 9s406ms 0ms 09 39,517 9s431ms 0ms 10 39,590 9s282ms 0ms 11 39,502 9s375ms 0ms 12 39,542 9s586ms 0ms 13 39,518 9s327ms 0ms 14 39,544 9s521ms 0ms 15 39,559 9s501ms 0ms 16 39,551 9s403ms 0ms 17 39,534 9s390ms 0ms 18 39,486 9s331ms 0ms 19 39,542 9s298ms 0ms 20 39,457 9s340ms 0ms 21 4,619 987ms 0ms 22 5 1ms 0ms 23 30,354 7s203ms 0ms 00 39,462 9s366ms 0ms [ User: symmetricds - Total duration: 3m25s - Times executed: 865324 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m25s - Times executed: 865324 ]
-
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 = '9195471' 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 = '9195499' 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 = '9195628' AND o.node_id = '2' ORDER BY d.data_id ASC;
Date: 2019-08-04 14:14:06 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 13:38:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 11:35:06 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 10ms 0ms 475,869 29s665ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b WHERE batch_id = ? AND node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 04 01 20,548 1s281ms 0ms 02 20,747 1s278ms 0ms 03 21,629 1s318ms 0ms 04 21,143 1s322ms 0ms 05 20,473 1s276ms 0ms 06 22,194 1s388ms 0ms 07 21,621 1s394ms 0ms 08 22,441 1s397ms 0ms 09 22,291 1s406ms 0ms 10 22,310 1s405ms 0ms 11 21,490 1s316ms 0ms 12 22,774 1s442ms 0ms 13 22,016 1s371ms 0ms 14 23,092 1s418ms 0ms 15 22,753 1s371ms 0ms 16 22,251 1s328ms 0ms 17 23,211 1s423ms 0ms 18 20,899 1s337ms 0ms 19 22,056 1s358ms 0ms 20 21,002 1s351ms 0ms 21 2,334 133ms 0ms 22 5 0ms 0ms 23 16,104 1s40ms 0ms 00 20,485 1s301ms 0ms [ User: symmetricds - Total duration: 29s665ms - Times executed: 475869 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s665ms - Times executed: 475869 ]
-
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 = '9196005' 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 = '9196367' 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 = '9195415' AND node_id = '2';
Date: 2019-08-04 19:53:09 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 16:17:08 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:57:05 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 4ms 0ms 24,648 1s366ms 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 #15
Day Hour Count Duration Avg duration Aug 04 01 1,027 30ms 0ms 02 1,027 59ms 0ms 03 1,027 53ms 0ms 04 1,027 52ms 0ms 05 1,027 62ms 0ms 06 1,027 40ms 0ms 07 1,027 84ms 0ms 08 1,027 68ms 0ms 09 1,027 35ms 0ms 10 1,027 61ms 0ms 11 1,027 66ms 0ms 12 1,027 57ms 0ms 13 1,027 62ms 0ms 14 1,027 66ms 0ms 15 1,027 50ms 0ms 16 1,027 58ms 0ms 17 1,027 58ms 0ms 18 1,027 55ms 0ms 19 1,027 56ms 0ms 20 1,027 56ms 0ms 21 1,027 53ms 0ms 22 1,027 55ms 0ms 23 1,027 64ms 0ms 00 1,027 56ms 0ms [ User: pharmisight - Total duration: 1s366ms - Times executed: 24648 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s366ms - Times executed: 24648 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = '2903' 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 = '3436' 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 = '33074350' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-04 06:40:01 Duration: 4ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 12:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:01 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 2ms 0ms 21,888 1s208ms 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 #16
Day Hour Count Duration Avg duration Aug 04 01 912 27ms 0ms 02 912 54ms 0ms 03 912 48ms 0ms 04 912 45ms 0ms 05 912 56ms 0ms 06 912 36ms 0ms 07 912 66ms 0ms 08 912 59ms 0ms 09 912 31ms 0ms 10 912 58ms 0ms 11 912 57ms 0ms 12 912 51ms 0ms 13 912 53ms 0ms 14 912 58ms 0ms 15 912 45ms 0ms 16 912 51ms 0ms 17 912 50ms 0ms 18 912 49ms 0ms 19 912 50ms 0ms 20 912 49ms 0ms 21 912 48ms 0ms 22 912 49ms 0ms 23 912 57ms 0ms 00 912 50ms 0ms [ User: pharmisight - Total duration: 1s208ms - Times executed: 21888 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s208ms - Times executed: 21888 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = '2882' 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 = '3082' 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 = '1779' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-04 09:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 06:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 04:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 4ms 0ms 24,965 1s275ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 04 01 1,128 60ms 0ms 02 1,044 52ms 0ms 03 1,044 56ms 0ms 04 1,038 52ms 0ms 05 1,040 49ms 0ms 06 1,044 53ms 0ms 07 1,046 51ms 0ms 08 1,044 50ms 0ms 09 1,042 52ms 0ms 10 1,036 52ms 0ms 11 1,042 52ms 0ms 12 1,044 53ms 0ms 13 1,040 56ms 0ms 14 1,030 51ms 0ms 15 1,042 54ms 0ms 16 1,038 52ms 0ms 17 1,040 52ms 0ms 18 1,040 51ms 0ms 19 1,040 51ms 0ms 20 1,040 51ms 0ms 21 993 52ms 0ms 22 991 54ms 0ms 23 1,030 49ms 0ms 00 1,049 59ms 0ms [ User: symmetricds - Total duration: 1s275ms - Times executed: 24965 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s275ms - Times executed: 24965 ]
-
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-04 12:35:59 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 23:16:03 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 21:36:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 8,593 408ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 04 01 359 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 358 17ms 0ms 05 358 16ms 0ms 06 357 16ms 0ms 07 359 16ms 0ms 08 358 16ms 0ms 09 359 17ms 0ms 10 358 16ms 0ms 11 358 15ms 0ms 12 358 16ms 0ms 13 358 17ms 0ms 14 357 17ms 0ms 15 359 17ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 18ms 0ms 20 357 17ms 0ms 21 359 17ms 0ms 22 358 17ms 0ms 23 358 17ms 0ms 00 357 17ms 0ms [ User: symmetricds - Total duration: 408ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 408ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-08-04 18:21:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 13:58:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 14:58:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 9ms 0ms 890,371 40s369ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 04 01 40,619 1s856ms 0ms 02 40,671 1s849ms 0ms 03 40,678 1s870ms 0ms 04 40,609 1s845ms 0ms 05 40,664 1s815ms 0ms 06 40,723 1s856ms 0ms 07 40,526 1s834ms 0ms 08 40,654 1s841ms 0ms 09 40,589 1s864ms 0ms 10 40,666 1s837ms 0ms 11 40,576 1s836ms 0ms 12 40,624 1s873ms 0ms 13 40,592 1s847ms 0ms 14 40,619 1s858ms 0ms 15 40,639 1s845ms 0ms 16 40,627 1s833ms 0ms 17 40,609 1s822ms 0ms 18 40,561 1s826ms 0ms 19 40,619 1s793ms 0ms 20 40,529 1s822ms 0ms 21 5,380 228ms 0ms 22 721 39ms 0ms 23 31,348 1s426ms 0ms 00 40,528 1s842ms 0ms [ User: symmetricds - Total duration: 40s369ms - Times executed: 890371 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s369ms - Times executed: 890371 ]
-
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 = '0';
Date: 2019-08-04 03:52:03 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 01:54:02 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 05:56:59 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 3ms 0ms 8,593 304ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 01 359 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 357 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 359 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 357 12ms 0ms 15 359 12ms 0ms 16 358 12ms 0ms 17 358 11ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 357 12ms 0ms 21 359 16ms 0ms 22 358 13ms 0ms 23 358 13ms 0ms 00 357 12ms 0ms [ User: symmetricds - Total duration: 304ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 304ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-08-04 20:41:12 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 17:15:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-04 15:51:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 69,457,464 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 04 15 2 - FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "template0", SSL on
- FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "-h", SSL on
Date: 2019-08-04 14:22:44 Database: template0 Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
Date: 2019-08-04 14:22:44 Database: -h Application: [unknown] User: postgres Remote: 80.82.77.33 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 04 15 2 - FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "template0", SSL off
- FATAL: no pg_hba.conf entry for host "80.82.77.33", user "postgres", database "-h", SSL off
Date: 2019-08-04 14:22:44 Database: template0 Application: [unknown] User: postgres Remote: 80.82.77.33 Code:
Date: 2019-08-04 14:22:44 Database: -h Application: [unknown] User: postgres Remote: 80.82.77.33 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 04 15 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Date: 2019-08-04 14:22:44 Database: [unknown] Application: [unknown] User: [unknown] Remote: 80.82.77.33 Code: