pgBadger-
Global information
- Generated on Sun Sep 1 00:00:24 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,197,731 log entries in 22s
- Log start from 2019-08-31 00:00:00 to 2019-08-31 23:59:59
-
Overview
Global Stats
- 180 Number of unique normalized queries
- 1,090,094 Number of queries
- 1m6s Total query duration
- 2019-08-31 00:00:00 First query
- 2019-08-31 23:59:59 Last query
- 1,972 queries/s at 2019-08-31 05:40:00 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 53 Total number of automatic vacuums
- 74 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,399 Total number of sessions
- 3 sessions at 2019-08-31 00:30:13 Session peak
- 10d9h56m24s Total duration of sessions
- 6m15s Average duration of sessions
- 454 Average queries per session
- 27ms Average queries duration per session
- 2,399 Total number of connections
- 39 connections/s at 2019-08-31 00:30:24 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1,972 queries/s Query Peak
- 2019-08-31 05:40:00 Date
SELECT Traffic
Key values
- 1,959 queries/s Query Peak
- 2019-08-31 05:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 637 queries/s Query Peak
- 2019-08-31 01:20:07 Date
Queries duration
Key values
- 1m6s Total query duration
Prepared queries ratio
Key values
- 1.57 Ratio of bind vs prepare
- 168.65 % 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 31 00 54,475 0ms 85ms 0ms 121ms 304ms 1s260ms 01 48,454 0ms 84ms 0ms 92ms 364ms 475ms 02 46,287 0ms 115ms 0ms 104ms 205ms 610ms 03 45,690 0ms 79ms 0ms 100ms 169ms 524ms 04 46,094 0ms 78ms 0ms 83ms 242ms 392ms 05 46,734 0ms 80ms 0ms 98ms 163ms 536ms 06 44,314 0ms 79ms 0ms 92ms 124ms 386ms 07 44,451 0ms 123ms 0ms 99ms 120ms 1s83ms 08 44,187 0ms 92ms 0ms 84ms 117ms 399ms 09 44,291 0ms 95ms 0ms 86ms 103ms 373ms 10 44,581 0ms 99ms 0ms 79ms 124ms 557ms 11 44,828 0ms 93ms 0ms 97ms 112ms 493ms 12 44,593 0ms 79ms 0ms 80ms 111ms 411ms 13 44,719 0ms 77ms 0ms 90ms 120ms 343ms 14 44,629 0ms 62ms 0ms 97ms 111ms 259ms 15 44,560 0ms 57ms 0ms 93ms 110ms 223ms 16 44,564 0ms 52ms 0ms 92ms 116ms 210ms 17 44,568 0ms 36ms 0ms 83ms 100ms 209ms 18 44,694 0ms 37ms 0ms 85ms 98ms 197ms 19 44,719 0ms 37ms 0ms 93ms 100ms 182ms 20 45,505 0ms 38ms 0ms 80ms 100ms 532ms 21 44,390 0ms 39ms 0ms 80ms 108ms 201ms 22 44,448 0ms 38ms 0ms 81ms 93ms 208ms 23 44,319 0ms 39ms 0ms 81ms 108ms 206ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 31 00 18,783 0 0ms 60ms 78ms 571ms 01 15,493 0 0ms 52ms 64ms 187ms 02 15,076 0 0ms 51ms 75ms 177ms 03 14,976 0 0ms 50ms 74ms 145ms 04 15,057 0 0ms 50ms 62ms 192ms 05 15,167 0 0ms 51ms 70ms 121ms 06 14,686 0 0ms 49ms 65ms 159ms 07 14,721 0 0ms 51ms 71ms 164ms 08 14,640 0 0ms 41ms 61ms 127ms 09 14,669 0 0ms 48ms 63ms 129ms 10 14,666 0 0ms 52ms 59ms 108ms 11 14,725 0 0ms 51ms 69ms 93ms 12 14,632 0 0ms 52ms 63ms 98ms 13 14,684 0 0ms 49ms 67ms 91ms 14 14,669 0 0ms 39ms 68ms 84ms 15 14,639 0 0ms 48ms 68ms 86ms 16 14,640 0 0ms 50ms 68ms 89ms 17 14,638 0 0ms 49ms 63ms 73ms 18 14,686 0 0ms 51ms 61ms 89ms 19 14,699 0 0ms 50ms 58ms 86ms 20 15,547 0 0ms 51ms 57ms 179ms 21 14,588 0 0ms 39ms 57ms 85ms 22 14,595 0 0ms 55ms 57ms 72ms 23 14,563 0 0ms 40ms 59ms 88ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 31 00 1,790 1,494 112 0 0ms 10ms 15ms 115ms 01 2,456 669 111 0 0ms 1ms 7ms 100ms 02 1,110 333 110 0 0ms 1ms 8ms 56ms 03 790 245 111 0 0ms 1ms 7ms 70ms 04 972 298 109 0 0ms 1ms 7ms 65ms 05 1,368 398 112 0 0ms 1ms 8ms 107ms 06 84 51 108 0 1ms 1ms 4ms 9ms 07 86 53 102 0 4ms 0ms 4ms 9ms 08 84 51 98 0 1ms 1ms 4ms 9ms 09 86 53 92 0 1ms 1ms 4ms 9ms 10 86 52 93 0 2ms 1ms 2ms 9ms 11 84 52 93 0 2ms 0ms 4ms 9ms 12 84 51 87 0 1ms 1ms 2ms 8ms 13 86 53 88 0 1ms 1ms 4ms 8ms 14 84 51 86 0 1ms 0ms 4ms 10ms 15 84 51 82 0 1ms 1ms 4ms 9ms 16 86 53 83 0 0ms 0ms 2ms 9ms 17 84 51 82 0 0ms 1ms 2ms 9ms 18 82 51 78 0 0ms 0ms 2ms 8ms 19 85 67 80 0 0ms 1ms 3ms 8ms 20 113 90 119 0 0ms 1ms 4ms 8ms 21 64 41 77 0 0ms 1ms 4ms 9ms 22 64 42 78 0 0ms 1ms 4ms 8ms 23 64 41 76 0 0ms 0ms 2ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 31 00 32,966 54,413 1.65 93.58% 01 30,172 48,394 1.60 100.85% 02 29,935 46,227 1.54 107.66% 03 29,980 45,630 1.52 110.02% 04 29,886 46,034 1.54 108.24% 05 30,033 46,674 1.55 106.38% 06 29,562 44,252 1.50 113.90% 07 30,024 44,391 1.48 115.35% 08 29,591 44,127 1.49 114.37% 09 29,622 44,231 1.49 114.19% 10 28,435 44,521 1.57 109.08% 11 28,242 44,768 1.59 107.79% 12 27,778 44,531 1.60 106.61% 13 28,078 44,659 1.59 107.42% 14 28,111 44,569 1.59 107.78% 15 28,031 44,500 1.59 107.63% 16 27,910 44,504 1.59 107.12% 17 27,895 44,508 1.60 107.12% 18 28,087 44,632 1.59 107.53% 19 27,825 44,659 1.60 106.43% 20 27,874 45,445 1.63 103.13% 21 28,045 44,330 1.58 108.31% 22 27,854 44,388 1.59 107.46% 23 27,784 44,259 1.59 107.45% Day Hour Count Average / Second Aug 31 00 167 0.05/s 01 116 0.03/s 02 113 0.03/s 03 111 0.03/s 04 111 0.03/s 05 115 0.03/s 06 119 0.03/s 07 125 0.03/s 08 116 0.03/s 09 114 0.03/s 10 96 0.03/s 11 85 0.02/s 12 85 0.02/s 13 85 0.02/s 14 85 0.02/s 15 84 0.02/s 16 78 0.02/s 17 82 0.02/s 18 85 0.02/s 19 85 0.02/s 20 84 0.02/s 21 87 0.02/s 22 87 0.02/s 23 84 0.02/s Day Hour Count Average Duration Aug 31 00 167 6m5s 01 116 4m57s 02 110 5m28s 03 114 5m32s 04 111 5m43s 05 115 5m16s 06 119 5m15s 07 125 5m4s 08 116 5m16s 09 114 5m24s 10 95 6m1s 11 85 6m56s 12 86 7m6s 13 85 7m6s 14 85 6m58s 15 84 7m39s 16 78 7m9s 17 82 7m42s 18 85 6m58s 19 85 7m7s 20 84 7m22s 21 87 6m52s 22 86 7m2s 23 85 7m11s -
Connections
Established Connections
Key values
- 39 connections Connection Peak
- 2019-08-31 00:30:24 Date
Connections per database
Key values
- pharmisight Main Database
- 2,399 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,399 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-08-31 00:30:13 Date
Histogram of session times
Key values
- 1,075 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,399 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,399 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,399 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,402 buffers Checkpoint Peak
- 2019-08-31 07:03:47 Date
- 149.937 seconds Highest write time
- 0.063 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2019-08-31 07:03:47 Date
Checkpoints distance
Key values
- 93.44 Mo Distance Peak
- 2019-08-31 07:03:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 31 00 1,653 165.865s 0.016s 165.948s 01 970 97.316s 0.031s 97.426s 02 644 64.53s 0.017s 64.638s 03 506 50.785s 0.029s 50.877s 04 584 58.617s 0.016s 58.701s 05 820 82.29s 0.019s 82.387s 06 415 41.649s 0.014s 41.731s 07 7,695 179.237s 0.106s 179.41s 08 1,486 148.723s 0.077s 148.868s 09 2,313 186.969s 0.053s 187.095s 10 1,111 111.068s 0.015s 111.154s 11 1,762 176.829s 0.017s 176.919s 12 1,282 128.243s 0.019s 128.341s 13 1,536 154.084s 0.031s 154.199s 14 1,134 113.682s 0.018s 113.771s 15 1,096 109.623s 0.016s 109.716s 16 1,179 118.106s 0.02s 118.201s 17 826 82.82s 0.013s 82.9s 18 594 59.615s 0.026s 59.729s 19 540 54.218s 0.027s 54.312s 20 461 46.272s 0.019s 46.386s 21 470 47.176s 0.019s 47.262s 22 543 54.509s 0.017s 54.595s 23 730 73.277s 0.017s 73.365s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 31 00 0 0 1 306 0.003s 0s 01 0 0 0 282 0.010s 0.001s 02 0 0 0 274 0.004s 0s 03 0 0 0 258 0.008s 0s 04 0 0 0 261 0.003s 0s 05 0 0 1 278 0.004s 0s 06 0 0 0 229 0.002s 0s 07 0 0 3 259 0.057s 0.005s 08 0 0 0 237 0.063s 0.002s 09 0 0 1 257 0.021s 0.004s 10 0 0 0 244 0.003s 0s 11 0 0 1 280 0.003s 0s 12 0 0 0 253 0.003s 0s 13 0 0 1 272 0.009s 0s 14 0 0 0 269 0.003s 0s 15 0 0 1 258 0.004s 0s 16 0 0 0 262 0.003s 0s 17 0 0 0 251 0.003s 0s 18 0 0 0 247 0.012s 0s 19 0 0 0 243 0.013s 0s 20 0 0 1 255 0.003s 0s 21 0 0 0 234 0.002s 0s 22 0 0 0 228 0.003s 0s 23 0 0 0 237 0.002s 0s Day Hour Count Avg time (sec) Aug 31 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 31 00 884.25 kB 1,427.25 kB 01 461.83 kB 1,299.08 kB 02 263.75 kB 948.58 kB 03 201.83 kB 680.67 kB 04 251.08 kB 614.00 kB 05 335.75 kB 1,052.17 kB 06 149.42 kB 495.08 kB 07 4,072.75 kB 28,645.00 kB 08 704.25 kB 8,595.50 kB 09 914.25 kB 5,747.92 kB 10 527.33 kB 2,950.00 kB 11 742.25 kB 4,710.83 kB 12 665.50 kB 3,165.92 kB 13 613.33 kB 3,736.00 kB 14 518.33 kB 3,075.33 kB 15 459.75 kB 2,766.33 kB 16 543.83 kB 3,159.75 kB 17 297.75 kB 1,419.67 kB 18 172.75 kB 505.00 kB 19 147.17 kB 464.17 kB 20 126.42 kB 306.50 kB 21 118.42 kB 339.50 kB 22 139.33 kB 319.42 kB 23 175.58 kB 637.00 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 31 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 (15) Main table analyzed (database pharmisight)
- 74 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data 14 pharmisight.public.sym_data_event 14 pharmisight.public.sym_incoming_batch 11 pharmisight.public.sym_data_gap 10 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 3 pharmisight.public.flow_report_summary_delays 1 pharmisight.public.sym_sequence 1 Total 74 Vacuums per table
Key values
- public.sym_outgoing_batch (11) Main table vacuumed on database pharmisight
- 53 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 11 11 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_data 10 10 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.public.sym_data_gap 5 5 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.public.item_codes 1 1 Total 53 47 Tuples removed per table
Key values
- public.sym_data_event (27509) Main table with removed tuples on database pharmisight
- 53817 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 27509 761 pharmisight.public.sym_data 10 10 19235 6331 pharmisight.public.sym_outgoing_batch 11 11 4365 18 pharmisight.public.sym_incoming_batch 6 6 956 0 pharmisight.pg_catalog.pg_statistic 2 2 629 0 pharmisight.public.item_codes 1 1 387 0 pharmisight.public.sym_node_host 5 0 262 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.pg_toast.pg_toast_2619 2 2 168 3 pharmisight.public.sym_sequence 1 0 51 0 Total 53 47 53,817 7,113 Pages removed per table
Key values
- public.sym_data (6331) Main table with removed pages on database pharmisight
- 7113 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 19235 6331 pharmisight.public.sym_data_event 10 10 27509 761 pharmisight.public.sym_outgoing_batch 11 11 4365 18 pharmisight.pg_toast.pg_toast_2619 2 2 168 3 pharmisight.public.sym_node_host 5 0 262 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_incoming_batch 6 6 956 0 pharmisight.public.item_codes 1 1 387 0 pharmisight.pg_catalog.pg_statistic 2 2 629 0 Total 53 47 53,817 7,113 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 31 00 1 3 01 1 3 02 3 1 03 0 1 04 0 0 05 0 5 06 1 1 07 5 2 08 0 4 09 4 4 10 2 5 11 4 4 12 3 4 13 4 5 14 4 4 15 4 4 16 4 4 17 4 3 18 1 4 19 2 2 20 1 2 21 2 4 22 1 2 23 2 3 - 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
- 359,239 Total read queries
- 286,250 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,089,510 Requests
- 56s37ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,077,725 Requests
User Request type Count Duration librenms Total 608 10s755ms SELECT 608 10s755ms pharmisight Total 58,134 5s677ms DELETE 43 3ms INSERT 2,260 1s249ms OTHERS 1,728 83ms SELECT 53,482 4s280ms TCL 558 52ms UPDATE 63 8ms symmetricds Total 1,077,725 52s370ms DELETE 2,294 5s60ms INSERT 9,291 1s234ms OTHERS 461,537 7s729ms SELECT 319,384 29s798ms TCL 280,418 5s930ms UPDATE 4,801 2s618ms tony Total 900 292ms SELECT 900 292ms Duration by user
Key values
- 52s370ms (symmetricds) Main time consuming user
User Request type Count Duration librenms Total 608 10s755ms SELECT 608 10s755ms pharmisight Total 58,134 5s677ms DELETE 43 3ms INSERT 2,260 1s249ms OTHERS 1,728 83ms SELECT 53,482 4s280ms TCL 558 52ms UPDATE 63 8ms symmetricds Total 1,077,725 52s370ms DELETE 2,294 5s60ms INSERT 9,291 1s234ms OTHERS 461,537 7s729ms SELECT 319,384 29s798ms TCL 280,418 5s930ms UPDATE 4,801 2s618ms tony Total 900 292ms SELECT 900 292ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,135,859 Requests
- 58s48ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,087,119 Requests
- 55s679ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-08-31 07:59:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,085,334 0-1ms duration
Slowest individual queries
Rank Duration Query 1 123ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '9306737' AND '9307176' AND status != 'OK') AND batch_id BETWEEN '9306737' AND '9307176';[ Date: 2019-08-31 07:00:01 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 121ms DELETE FROM sym_data WHERE data_id BETWEEN '106127332' AND '106132332' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 115ms DELETE FROM sym_data WHERE data_id BETWEEN '106132333' AND '106137333' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 115ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 99ms DELETE FROM sym_data WHERE data_id BETWEEN '106165166' AND '106170166' AND create_time < '2019-08-30 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 95ms DELETE FROM sym_data WHERE data_id BETWEEN '106160002' AND '106165002' AND create_time < '2019-08-30 09:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106160002' AND '106165002') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106160002' AND '106165002' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 93ms DELETE FROM sym_data WHERE data_id BETWEEN '106169530' AND '106174530' AND create_time < '2019-08-30 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106169530' AND '106174530') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106169530' AND '106174530' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 92ms DELETE FROM sym_data WHERE data_id BETWEEN '106153513' AND '106158513' AND create_time < '2019-08-30 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106153513' AND '106158513') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106153513' AND '106158513' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 90ms DELETE FROM sym_data WHERE data_id BETWEEN '106147336' AND '106152336' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106147336' AND '106152336') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106147336' AND '106152336' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 88ms DELETE FROM sym_data WHERE data_id BETWEEN '106137334' AND '106142334' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106137334' AND '106142334') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106137334' AND '106142334' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 87ms DELETE FROM sym_data WHERE data_id BETWEEN '106142335' AND '106147335' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106142335' AND '106147335') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106142335' AND '106147335' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 85ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 84ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 80ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 79ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 79ms DELETE FROM sym_data WHERE data_id BETWEEN '106174481' AND '106179481' AND create_time < '2019-08-30 12:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106174481' AND '106179481') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106174481' AND '106179481' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 79ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 78ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-08-31 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 77ms DELETE FROM sym_data WHERE data_id BETWEEN '106179001' AND '106184001' AND create_time < '2019-08-30 13:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106179001' AND '106184001') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106179001' AND '106184001' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 76ms DELETE FROM sym_data WHERE data_id BETWEEN '106127219' AND '106132219' AND create_time < '2019-08-30 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127219' AND '106132219') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127219' AND '106132219' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-08-31 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 10s163ms 17,197 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 31 01 717 425ms 0ms 02 718 436ms 0ms 03 716 439ms 0ms 04 716 441ms 0ms 05 716 432ms 0ms 06 716 430ms 0ms 07 716 428ms 0ms 08 718 436ms 0ms 09 716 435ms 0ms 10 716 429ms 0ms 11 716 416ms 0ms 12 718 413ms 0ms 13 716 411ms 0ms 14 716 414ms 0ms 15 718 413ms 0ms 16 716 417ms 0ms 17 716 410ms 0ms 18 716 412ms 0ms 19 718 419ms 0ms 20 716 411ms 0ms 21 716 418ms 0ms 22 718 414ms 0ms 23 716 421ms 0ms 00 716 429ms 0ms [ User: symmetricds - Total duration: 10s163ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s163ms - Times executed: 17197 ]
-
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-31 05:42:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:06:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 21:47:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 10s132ms 292 13ms 45ms 34ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 01 13 465ms 35ms 02 12 414ms 34ms 03 12 427ms 35ms 04 12 423ms 35ms 05 12 412ms 34ms 06 12 414ms 34ms 07 13 446ms 34ms 08 12 423ms 35ms 09 12 348ms 29ms 10 12 393ms 32ms 11 12 410ms 34ms 12 12 436ms 36ms 13 13 460ms 35ms 14 12 425ms 35ms 15 12 417ms 34ms 16 12 425ms 35ms 17 12 434ms 36ms 18 12 412ms 34ms 19 13 456ms 35ms 20 12 412ms 34ms 21 12 415ms 34ms 22 12 404ms 33ms 23 12 429ms 35ms 00 12 420ms 35ms [ User: librenms - Total duration: 10s132ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s132ms - Times executed: 292 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-08-31 07:45:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-31 11:45:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-31 06:40:12 Duration: 40ms Database: postgres User: librenms Remote: [local] Application: psql
3 7s68ms 423,163 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 31 01 18,206 299ms 0ms 02 17,589 292ms 0ms 03 17,546 293ms 0ms 04 17,512 289ms 0ms 05 17,550 294ms 0ms 06 17,559 290ms 0ms 07 17,435 288ms 0ms 08 17,485 292ms 0ms 09 17,393 287ms 0ms 10 17,436 288ms 0ms 11 17,634 288ms 0ms 12 17,766 299ms 0ms 13 17,685 297ms 0ms 14 17,722 294ms 0ms 15 17,684 294ms 0ms 16 17,663 297ms 0ms 17 17,664 296ms 0ms 18 17,672 298ms 0ms 19 17,722 300ms 0ms 20 17,713 296ms 0ms 21 17,625 299ms 0ms 22 17,632 296ms 0ms 23 17,664 296ms 0ms 00 17,606 296ms 0ms [ User: symmetricds - Total duration: 7s40ms - Times executed: 422604 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 559 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s68ms - Times executed: 423163 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-31 07:34:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:13:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 17:48:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4s837ms 134,807 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 31 01 6,523 593ms 0ms 02 5,594 202ms 0ms 03 5,588 202ms 0ms 04 5,564 211ms 0ms 05 5,588 203ms 0ms 06 5,594 244ms 0ms 07 5,513 188ms 0ms 08 5,533 175ms 0ms 09 5,500 187ms 0ms 10 5,520 178ms 0ms 11 5,585 191ms 0ms 12 5,623 173ms 0ms 13 5,601 171ms 0ms 14 5,614 187ms 0ms 15 5,596 177ms 0ms 16 5,594 174ms 0ms 17 5,597 172ms 0ms 18 5,593 174ms 0ms 19 5,611 174ms 0ms 20 5,607 186ms 0ms 21 5,579 169ms 0ms 22 5,562 159ms 0ms 23 5,571 172ms 0ms 00 5,557 164ms 0ms [ User: symmetricds - Total duration: 4s792ms - Times executed: 134538 ]
[ User: pharmisight - Total duration: 45ms - Times executed: 269 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s837ms - Times executed: 134807 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-31 06:35:53 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:06:36 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 08:35:49 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3s183ms 180 0ms 121ms 17ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 31 01 15 111ms 7ms 02 15 95ms 6ms 03 15 126ms 8ms 04 15 137ms 9ms 05 15 93ms 6ms 06 15 108ms 7ms 07 15 145ms 9ms 08 15 713ms 47ms 09 10 171ms 17ms 10 8 152ms 19ms 11 7 283ms 40ms 12 7 259ms 37ms 13 6 198ms 33ms 14 5 164ms 32ms 15 4 108ms 27ms 16 3 85ms 28ms 17 2 64ms 32ms 18 2 32ms 16ms 19 1 18ms 18ms 20 1 16ms 16ms 21 1 22ms 22ms 22 1 29ms 29ms 23 1 19ms 19ms 00 1 24ms 24ms [ User: symmetricds - Total duration: 3s183ms - Times executed: 180 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s183ms - Times executed: 180 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '106127332' AND '106132332' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332' 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 '106132333' AND '106137333' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333' 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 '106165166' AND '106170166' AND create_time < '2019-08-30 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-31 07:00:00 Duration: 121ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 07:00:00 Duration: 115ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s885ms 154,937 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 31 01 7,674 88ms 0ms 02 6,451 80ms 0ms 03 6,432 77ms 0ms 04 6,413 86ms 0ms 05 6,434 78ms 0ms 06 6,439 78ms 0ms 07 6,358 76ms 0ms 08 6,365 76ms 0ms 09 6,332 75ms 0ms 10 6,343 75ms 0ms 11 6,405 76ms 0ms 12 6,455 78ms 0ms 13 6,415 77ms 0ms 14 6,433 81ms 0ms 15 6,422 79ms 0ms 16 6,405 78ms 0ms 17 6,408 76ms 0ms 18 6,413 77ms 0ms 19 6,419 78ms 0ms 20 6,421 78ms 0ms 21 6,376 76ms 0ms 22 6,371 77ms 0ms 23 6,389 79ms 0ms 00 6,364 77ms 0ms [ User: symmetricds - Total duration: 1s885ms - Times executed: 154937 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s885ms - Times executed: 154937 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-31 03:12:34 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:43:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:14:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s375ms 25,148 0ms 2ms 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 #7
Day Hour Count Duration Avg duration Aug 31 01 1,126 60ms 0ms 02 1,052 57ms 0ms 03 1,050 55ms 0ms 04 1,048 56ms 0ms 05 1,050 57ms 0ms 06 1,050 57ms 0ms 07 1,044 56ms 0ms 08 1,046 56ms 0ms 09 1,044 56ms 0ms 10 1,044 53ms 0ms 11 1,044 55ms 0ms 12 1,046 56ms 0ms 13 1,044 56ms 0ms 14 1,044 56ms 0ms 15 1,046 56ms 0ms 16 1,044 57ms 0ms 17 1,044 56ms 0ms 18 1,044 59ms 0ms 19 1,046 61ms 0ms 20 1,044 58ms 0ms 21 1,038 58ms 0ms 22 1,038 58ms 0ms 23 1,036 56ms 0ms 00 1,036 57ms 0ms [ User: symmetricds - Total duration: 1s375ms - Times executed: 25148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s375ms - Times executed: 25148 ]
-
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-31 20:49:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:55:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 04:54:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s363ms 939 0ms 2ms 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 #8
Day Hour Count Duration Avg duration Aug 31 01 49 72ms 1ms 02 53 76ms 1ms 03 53 75ms 1ms 04 56 81ms 1ms 05 57 82ms 1ms 06 56 82ms 1ms 07 56 81ms 1ms 08 57 79ms 1ms 09 53 74ms 1ms 10 56 81ms 1ms 11 36 51ms 1ms 12 29 42ms 1ms 13 26 37ms 1ms 14 27 40ms 1ms 15 28 41ms 1ms 16 28 42ms 1ms 17 27 39ms 1ms 18 27 39ms 1ms 19 29 40ms 1ms 20 26 38ms 1ms 21 27 40ms 1ms 22 29 41ms 1ms 23 26 37ms 1ms 00 28 41ms 1ms [ User: symmetricds - Total duration: 1s363ms - Times executed: 939 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s363ms - Times executed: 939 ]
-
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-31 01:05:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 11:29:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:07:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s307ms 24,768 0ms 0ms 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 #9
Day Hour Count Duration Avg duration Aug 31 01 1,032 49ms 0ms 02 1,032 50ms 0ms 03 1,032 50ms 0ms 04 1,032 39ms 0ms 05 1,032 58ms 0ms 06 1,032 29ms 0ms 07 1,032 57ms 0ms 08 1,032 56ms 0ms 09 1,032 56ms 0ms 10 1,032 56ms 0ms 11 1,032 58ms 0ms 12 1,032 56ms 0ms 13 1,032 56ms 0ms 14 1,032 56ms 0ms 15 1,032 56ms 0ms 16 1,032 59ms 0ms 17 1,032 58ms 0ms 18 1,032 57ms 0ms 19 1,032 55ms 0ms 20 1,032 55ms 0ms 21 1,032 57ms 0ms 22 1,032 56ms 0ms 23 1,032 58ms 0ms 00 1,032 59ms 0ms [ User: pharmisight - Total duration: 1s307ms - Times executed: 24768 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s307ms - Times executed: 24768 ]
-
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 = '33074355' 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 = '33070170' 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 = '3618' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-31 07:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s185ms 1,159 0ms 4ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 01 61 60ms 0ms 02 66 69ms 1ms 03 67 67ms 1ms 04 66 65ms 0ms 05 68 72ms 1ms 06 69 71ms 1ms 07 67 71ms 1ms 08 64 70ms 1ms 09 66 73ms 1ms 10 63 63ms 1ms 11 45 45ms 1ms 12 38 37ms 0ms 13 32 31ms 0ms 14 34 33ms 0ms 15 36 35ms 0ms 16 36 36ms 1ms 17 33 32ms 0ms 18 36 36ms 1ms 19 37 35ms 0ms 20 34 34ms 1ms 21 36 35ms 0ms 22 36 36ms 1ms 23 35 34ms 0ms 00 34 34ms 1ms [ User: symmetricds - Total duration: 1s185ms - Times executed: 1159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s185ms - Times executed: 1159 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 07:35:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 08:03:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:23:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s173ms 21,984 0ms 0ms 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 #11
Day Hour Count Duration Avg duration Aug 31 01 916 43ms 0ms 02 916 46ms 0ms 03 916 44ms 0ms 04 916 35ms 0ms 05 916 51ms 0ms 06 916 26ms 0ms 07 916 51ms 0ms 08 916 49ms 0ms 09 916 50ms 0ms 10 916 51ms 0ms 11 916 52ms 0ms 12 916 51ms 0ms 13 916 51ms 0ms 14 916 50ms 0ms 15 916 51ms 0ms 16 916 53ms 0ms 17 916 52ms 0ms 18 916 51ms 0ms 19 916 49ms 0ms 20 916 50ms 0ms 21 916 50ms 0ms 22 916 50ms 0ms 23 916 53ms 0ms 00 916 53ms 0ms [ User: pharmisight - Total duration: 1s173ms - Times executed: 21984 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s173ms - Times executed: 21984 ]
-
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 = '3649' 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 = '3454' 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 = '32964824' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-31 12:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s153ms 177 0ms 11ms 6ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 01 8 52ms 6ms 02 8 56ms 7ms 03 8 56ms 7ms 04 8 56ms 7ms 05 8 55ms 6ms 06 8 57ms 7ms 07 8 58ms 7ms 08 8 55ms 6ms 09 8 56ms 7ms 10 8 51ms 6ms 11 8 38ms 4ms 12 8 57ms 7ms 13 8 43ms 5ms 14 8 58ms 7ms 15 8 60ms 7ms 16 8 58ms 7ms 17 8 45ms 5ms 18 8 47ms 5ms 19 8 45ms 5ms 20 8 42ms 5ms 21 5 28ms 5ms 22 4 23ms 5ms 23 4 23ms 5ms 00 4 22ms 5ms [ User: symmetricds - Total duration: 1s153ms - Times executed: 177 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s153ms - Times executed: 177 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '387861104', "total_memory_bytes" = '1190133760', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 01:55:32', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '877741920', "total_memory_bytes" = '1191182336', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 10:10:32', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '102585944', "total_memory_bytes" = '274726912', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 12:34:08', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-08-31 01:55:43 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:10:44 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 12:35:45 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 1s52ms 1,916 0ms 12ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 01 363 238ms 0ms 02 590 256ms 0ms 03 253 167ms 0ms 04 174 107ms 0ms 05 219 102ms 0ms 06 317 180ms 0ms [ User: pharmisight - Total duration: 1s52ms - Times executed: 1916 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s52ms - Times executed: 1916 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006028735', '2019-08-31 03:17:37', 'RYBAKJ', '2019-08-31 02:40:01.716', '106864', '24', '150505230149500723');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006022431', '2019-08-31 00:36:13', 'BERLANR', '2019-08-31 00:00:00.044', '64255', '24', '31237090428341001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006028491', '2019-08-31 03:32:52', 'RYBAKJ', '2019-08-31 03:00:00.055', '41134', '14', '150505230149501508');
Date: 2019-08-31 02:40:01 Duration: 12ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:00:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 994ms 145 4ms 13ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 31 01 94 670ms 7ms 02 3 13ms 4ms 03 3 18ms 6ms 04 3 17ms 5ms 05 3 18ms 6ms 06 3 18ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 8ms 4ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 677ms - Times executed: 100 ]
[ User: pharmisight - Total duration: 317ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 994ms - Times executed: 145 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-31 00:30:17 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:30:16 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 949ms 166 0ms 19ms 5ms 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 #15
Day Hour Count Duration Avg duration Aug 31 01 15 69ms 4ms 02 15 70ms 4ms 03 15 92ms 6ms 04 15 78ms 5ms 05 15 66ms 4ms 06 15 67ms 4ms 07 15 66ms 4ms 08 10 39ms 3ms 09 8 33ms 4ms 10 7 29ms 4ms 11 7 104ms 14ms 12 6 74ms 12ms 13 5 53ms 10ms 14 4 33ms 8ms 15 3 27ms 9ms 16 2 16ms 8ms 17 2 4ms 2ms 18 1 3ms 3ms 19 1 3ms 3ms 20 1 3ms 3ms 21 1 3ms 3ms 22 1 3ms 3ms 23 1 3ms 3ms 00 1 2ms 2ms [ User: symmetricds - Total duration: 949ms - Times executed: 166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 166 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '106169530' AND '106174530' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106169530' AND '106174530');
-
DELETE FROM sym_data WHERE data_id BETWEEN '106184533' AND '106189533' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106184533' AND '106189533');
-
DELETE FROM sym_data WHERE data_id BETWEEN '106179532' AND '106184532' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106179532' AND '106184532');
Date: 2019-08-31 10:00:00 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 949ms 17,326 0ms 1ms 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 #16
Day Hour Count Duration Avg duration Aug 31 01 726 39ms 0ms 02 728 39ms 0ms 03 726 39ms 0ms 04 724 38ms 0ms 05 726 39ms 0ms 06 726 39ms 0ms 07 720 39ms 0ms 08 722 38ms 0ms 09 720 38ms 0ms 10 720 39ms 0ms 11 720 39ms 0ms 12 722 41ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 720 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 40ms 0ms [ User: symmetricds - Total duration: 949ms - Times executed: 17326 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 17326 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-08-31 11:45:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:21:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 14:03:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 907ms 134,808 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 31 01 6,524 43ms 0ms 02 5,594 37ms 0ms 03 5,588 37ms 0ms 04 5,564 37ms 0ms 05 5,588 36ms 0ms 06 5,594 43ms 0ms 07 5,513 36ms 0ms 08 5,533 36ms 0ms 09 5,500 36ms 0ms 10 5,520 36ms 0ms 11 5,585 36ms 0ms 12 5,623 38ms 0ms 13 5,601 38ms 0ms 14 5,614 37ms 0ms 15 5,597 37ms 0ms 16 5,593 37ms 0ms 17 5,597 36ms 0ms 18 5,593 37ms 0ms 19 5,611 38ms 0ms 20 5,607 37ms 0ms 21 5,579 37ms 0ms 22 5,562 36ms 0ms 23 5,571 38ms 0ms 00 5,557 38ms 0ms [ User: symmetricds - Total duration: 905ms - Times executed: 134538 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 270 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 907ms - Times executed: 134808 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-31 05:59:35 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 22:41:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 11:39:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 904ms 949 0ms 4ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 31 01 50 46ms 0ms 02 58 55ms 0ms 03 54 52ms 0ms 04 58 56ms 0ms 05 56 55ms 0ms 06 56 54ms 0ms 07 56 53ms 0ms 08 58 56ms 0ms 09 54 52ms 0ms 10 55 56ms 1ms 11 37 34ms 0ms 12 28 25ms 0ms 13 26 22ms 0ms 14 27 26ms 0ms 15 28 28ms 1ms 16 28 25ms 0ms 17 27 24ms 0ms 18 27 25ms 0ms 19 29 25ms 0ms 20 26 24ms 0ms 21 27 24ms 0ms 22 29 27ms 0ms 23 27 24ms 0ms 00 28 25ms 0ms [ User: symmetricds - Total duration: 904ms - Times executed: 949 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 949 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 14:19:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:49:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 13:21:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 892ms 24 2ms 115ms 37ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 01 1 85ms 85ms 02 1 84ms 84ms 03 1 115ms 115ms 04 1 79ms 79ms 05 1 78ms 78ms 06 1 80ms 80ms 07 1 79ms 79ms 08 1 62ms 62ms 09 1 50ms 50ms 10 1 47ms 47ms 11 1 26ms 26ms 12 1 22ms 22ms 13 1 18ms 18ms 14 1 14ms 14ms 15 1 11ms 11ms 16 1 9ms 9ms 17 1 4ms 4ms 18 1 3ms 3ms 19 1 3ms 3ms 20 1 3ms 3ms 21 1 3ms 3ms 22 1 2ms 2ms 23 1 3ms 3ms 00 1 2ms 2ms [ User: symmetricds - Total duration: 892ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - 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-31 02:00:00 Duration: 115ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 85ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 824ms 931 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 31 01 49 42ms 0ms 02 57 49ms 0ms 03 53 46ms 0ms 04 54 48ms 0ms 05 52 46ms 0ms 06 54 48ms 0ms 07 54 49ms 0ms 08 58 51ms 0ms 09 53 47ms 0ms 10 54 48ms 0ms 11 36 31ms 0ms 12 28 25ms 0ms 13 26 22ms 0ms 14 27 23ms 0ms 15 28 24ms 0ms 16 28 24ms 0ms 17 27 23ms 0ms 18 27 24ms 0ms 19 29 24ms 0ms 20 26 22ms 0ms 21 27 23ms 0ms 22 29 26ms 0ms 23 27 23ms 0ms 00 28 24ms 0ms [ User: symmetricds - Total duration: 824ms - Times executed: 931 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 824ms - Times executed: 931 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 06:47:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:23:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:53:44 Duration: 1ms 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 423,163 7s68ms 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 31 01 18,206 299ms 0ms 02 17,589 292ms 0ms 03 17,546 293ms 0ms 04 17,512 289ms 0ms 05 17,550 294ms 0ms 06 17,559 290ms 0ms 07 17,435 288ms 0ms 08 17,485 292ms 0ms 09 17,393 287ms 0ms 10 17,436 288ms 0ms 11 17,634 288ms 0ms 12 17,766 299ms 0ms 13 17,685 297ms 0ms 14 17,722 294ms 0ms 15 17,684 294ms 0ms 16 17,663 297ms 0ms 17 17,664 296ms 0ms 18 17,672 298ms 0ms 19 17,722 300ms 0ms 20 17,713 296ms 0ms 21 17,625 299ms 0ms 22 17,632 296ms 0ms 23 17,664 296ms 0ms 00 17,606 296ms 0ms [ User: symmetricds - Total duration: 7s40ms - Times executed: 422604 ]
[ User: pharmisight - Total duration: 28ms - Times executed: 559 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s68ms - Times executed: 423163 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-08-31 07:34:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:13:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 17:48:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 154,937 1s885ms 0ms 7ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 01 7,674 88ms 0ms 02 6,451 80ms 0ms 03 6,432 77ms 0ms 04 6,413 86ms 0ms 05 6,434 78ms 0ms 06 6,439 78ms 0ms 07 6,358 76ms 0ms 08 6,365 76ms 0ms 09 6,332 75ms 0ms 10 6,343 75ms 0ms 11 6,405 76ms 0ms 12 6,455 78ms 0ms 13 6,415 77ms 0ms 14 6,433 81ms 0ms 15 6,422 79ms 0ms 16 6,405 78ms 0ms 17 6,408 76ms 0ms 18 6,413 77ms 0ms 19 6,419 78ms 0ms 20 6,421 78ms 0ms 21 6,376 76ms 0ms 22 6,371 77ms 0ms 23 6,389 79ms 0ms 00 6,364 77ms 0ms [ User: symmetricds - Total duration: 1s885ms - Times executed: 154937 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s885ms - Times executed: 154937 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-08-31 03:12:34 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:43:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:14:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 134,808 907ms 0ms 5ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 31 01 6,524 43ms 0ms 02 5,594 37ms 0ms 03 5,588 37ms 0ms 04 5,564 37ms 0ms 05 5,588 36ms 0ms 06 5,594 43ms 0ms 07 5,513 36ms 0ms 08 5,533 36ms 0ms 09 5,500 36ms 0ms 10 5,520 36ms 0ms 11 5,585 36ms 0ms 12 5,623 38ms 0ms 13 5,601 38ms 0ms 14 5,614 37ms 0ms 15 5,597 37ms 0ms 16 5,593 37ms 0ms 17 5,597 36ms 0ms 18 5,593 37ms 0ms 19 5,611 38ms 0ms 20 5,607 37ms 0ms 21 5,579 37ms 0ms 22 5,562 36ms 0ms 23 5,571 38ms 0ms 00 5,557 38ms 0ms [ User: symmetricds - Total duration: 905ms - Times executed: 134538 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 270 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 907ms - Times executed: 134808 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-08-31 05:59:35 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 22:41:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 11:39:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 134,807 4s837ms 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 31 01 6,523 593ms 0ms 02 5,594 202ms 0ms 03 5,588 202ms 0ms 04 5,564 211ms 0ms 05 5,588 203ms 0ms 06 5,594 244ms 0ms 07 5,513 188ms 0ms 08 5,533 175ms 0ms 09 5,500 187ms 0ms 10 5,520 178ms 0ms 11 5,585 191ms 0ms 12 5,623 173ms 0ms 13 5,601 171ms 0ms 14 5,614 187ms 0ms 15 5,596 177ms 0ms 16 5,594 174ms 0ms 17 5,597 172ms 0ms 18 5,593 174ms 0ms 19 5,611 174ms 0ms 20 5,607 186ms 0ms 21 5,579 169ms 0ms 22 5,562 159ms 0ms 23 5,571 172ms 0ms 00 5,557 164ms 0ms [ User: symmetricds - Total duration: 4s792ms - Times executed: 134538 ]
[ User: pharmisight - Total duration: 45ms - Times executed: 269 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s837ms - Times executed: 134807 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-08-31 06:35:53 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:06:36 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 08:35:49 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,148 1s375ms 0ms 2ms 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 #5
Day Hour Count Duration Avg duration Aug 31 01 1,126 60ms 0ms 02 1,052 57ms 0ms 03 1,050 55ms 0ms 04 1,048 56ms 0ms 05 1,050 57ms 0ms 06 1,050 57ms 0ms 07 1,044 56ms 0ms 08 1,046 56ms 0ms 09 1,044 56ms 0ms 10 1,044 53ms 0ms 11 1,044 55ms 0ms 12 1,046 56ms 0ms 13 1,044 56ms 0ms 14 1,044 56ms 0ms 15 1,046 56ms 0ms 16 1,044 57ms 0ms 17 1,044 56ms 0ms 18 1,044 59ms 0ms 19 1,046 61ms 0ms 20 1,044 58ms 0ms 21 1,038 58ms 0ms 22 1,038 58ms 0ms 23 1,036 56ms 0ms 00 1,036 57ms 0ms [ User: symmetricds - Total duration: 1s375ms - Times executed: 25148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s375ms - Times executed: 25148 ]
-
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-31 20:49:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:55:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 04:54:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,768 1s307ms 0ms 0ms 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 #6
Day Hour Count Duration Avg duration Aug 31 01 1,032 49ms 0ms 02 1,032 50ms 0ms 03 1,032 50ms 0ms 04 1,032 39ms 0ms 05 1,032 58ms 0ms 06 1,032 29ms 0ms 07 1,032 57ms 0ms 08 1,032 56ms 0ms 09 1,032 56ms 0ms 10 1,032 56ms 0ms 11 1,032 58ms 0ms 12 1,032 56ms 0ms 13 1,032 56ms 0ms 14 1,032 56ms 0ms 15 1,032 56ms 0ms 16 1,032 59ms 0ms 17 1,032 58ms 0ms 18 1,032 57ms 0ms 19 1,032 55ms 0ms 20 1,032 55ms 0ms 21 1,032 57ms 0ms 22 1,032 56ms 0ms 23 1,032 58ms 0ms 00 1,032 59ms 0ms [ User: pharmisight - Total duration: 1s307ms - Times executed: 24768 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s307ms - Times executed: 24768 ]
-
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 = '33074355' 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 = '33070170' 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 = '3618' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-31 07:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,984 1s173ms 0ms 0ms 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 #7
Day Hour Count Duration Avg duration Aug 31 01 916 43ms 0ms 02 916 46ms 0ms 03 916 44ms 0ms 04 916 35ms 0ms 05 916 51ms 0ms 06 916 26ms 0ms 07 916 51ms 0ms 08 916 49ms 0ms 09 916 50ms 0ms 10 916 51ms 0ms 11 916 52ms 0ms 12 916 51ms 0ms 13 916 51ms 0ms 14 916 50ms 0ms 15 916 51ms 0ms 16 916 53ms 0ms 17 916 52ms 0ms 18 916 51ms 0ms 19 916 49ms 0ms 20 916 50ms 0ms 21 916 50ms 0ms 22 916 50ms 0ms 23 916 53ms 0ms 00 916 53ms 0ms [ User: pharmisight - Total duration: 1s173ms - Times executed: 21984 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s173ms - Times executed: 21984 ]
-
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 = '3649' 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 = '3454' 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 = '32964824' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-31 12:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,326 949ms 0ms 1ms 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 31 01 726 39ms 0ms 02 728 39ms 0ms 03 726 39ms 0ms 04 724 38ms 0ms 05 726 39ms 0ms 06 726 39ms 0ms 07 720 39ms 0ms 08 722 38ms 0ms 09 720 38ms 0ms 10 720 39ms 0ms 11 720 39ms 0ms 12 722 41ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 720 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 40ms 0ms [ User: symmetricds - Total duration: 949ms - Times executed: 17326 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 17326 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-08-31 11:45:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:21:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 14:03:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,264 529ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 31 01 718 20ms 0ms 02 720 21ms 0ms 03 718 22ms 0ms 04 720 21ms 0ms 05 720 22ms 0ms 06 718 21ms 0ms 07 720 21ms 0ms 08 720 21ms 0ms 09 718 21ms 0ms 10 720 21ms 0ms 11 720 22ms 0ms 12 718 22ms 0ms 13 720 22ms 0ms 14 720 22ms 0ms 15 718 22ms 0ms 16 720 22ms 0ms 17 720 22ms 0ms 18 720 22ms 0ms 19 718 22ms 0ms 20 720 22ms 0ms 21 720 22ms 0ms 22 718 22ms 0ms 23 720 22ms 0ms 00 720 22ms 0ms [ User: symmetricds - Total duration: 529ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 529ms - Times executed: 17264 ]
-
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-31 04:26:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 17:27:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:53:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,197 10s163ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 01 717 425ms 0ms 02 718 436ms 0ms 03 716 439ms 0ms 04 716 441ms 0ms 05 716 432ms 0ms 06 716 430ms 0ms 07 716 428ms 0ms 08 718 436ms 0ms 09 716 435ms 0ms 10 716 429ms 0ms 11 716 416ms 0ms 12 718 413ms 0ms 13 716 411ms 0ms 14 716 414ms 0ms 15 718 413ms 0ms 16 716 417ms 0ms 17 716 410ms 0ms 18 716 412ms 0ms 19 718 419ms 0ms 20 716 411ms 0ms 21 716 418ms 0ms 22 718 414ms 0ms 23 716 421ms 0ms 00 716 429ms 0ms [ User: symmetricds - Total duration: 10s163ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s163ms - Times executed: 17197 ]
-
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-31 05:42:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:06:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 21:47:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,194 169ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 31 01 392 6ms 0ms 02 395 7ms 0ms 03 390 7ms 0ms 04 390 7ms 0ms 05 390 6ms 0ms 06 392 7ms 0ms 07 382 7ms 0ms 08 379 6ms 0ms 09 381 7ms 0ms 10 379 7ms 0ms 11 380 6ms 0ms 12 383 7ms 0ms 13 378 6ms 0ms 14 380 6ms 0ms 15 383 6ms 0ms 16 378 6ms 0ms 17 380 6ms 0ms 18 383 7ms 0ms 19 378 7ms 0ms 20 383 6ms 0ms 21 377 6ms 0ms 22 381 7ms 0ms 23 381 6ms 0ms 00 379 7ms 0ms [ User: symmetricds - Total duration: 169ms - Times executed: 9194 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 169ms - Times executed: 9194 ]
-
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-31 21:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:17:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 18:11:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,194 124ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 01 392 5ms 0ms 02 393 5ms 0ms 03 392 5ms 0ms 04 388 5ms 0ms 05 392 5ms 0ms 06 392 5ms 0ms 07 380 5ms 0ms 08 381 5ms 0ms 09 380 5ms 0ms 10 380 5ms 0ms 11 380 5ms 0ms 12 381 5ms 0ms 13 380 5ms 0ms 14 380 5ms 0ms 15 381 5ms 0ms 16 380 5ms 0ms 17 380 5ms 0ms 18 380 5ms 0ms 19 381 5ms 0ms 20 380 5ms 0ms 21 380 5ms 0ms 22 381 5ms 0ms 23 380 5ms 0ms 00 380 5ms 0ms [ User: symmetricds - Total duration: 124ms - Times executed: 9194 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 124ms - Times executed: 9194 ]
-
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-31 05:20:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 13:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 19:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 296ms 0ms 1ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 01 358 13ms 0ms 02 359 14ms 0ms 03 358 13ms 0ms 04 358 13ms 0ms 05 358 15ms 0ms 06 358 13ms 0ms 07 358 13ms 0ms 08 359 11ms 0ms 09 358 13ms 0ms 10 358 11ms 0ms 11 358 11ms 0ms 12 359 11ms 0ms 13 358 11ms 0ms 14 358 11ms 0ms 15 359 11ms 0ms 16 358 11ms 0ms 17 358 11ms 0ms 18 358 11ms 0ms 19 359 11ms 0ms 20 358 11ms 0ms 21 358 11ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 296ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 296ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106199383' AND '156199382'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106198426' AND '156198425'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '106198721' AND '156198720'));
Date: 2019-08-31 04:06:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:20:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:40:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,598 440ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 31 01 358 18ms 0ms 02 359 19ms 0ms 03 358 18ms 0ms 04 358 18ms 0ms 05 358 18ms 0ms 06 358 19ms 0ms 07 358 18ms 0ms 08 359 18ms 0ms 09 358 18ms 0ms 10 358 18ms 0ms 11 358 18ms 0ms 12 359 17ms 0ms 13 358 17ms 0ms 14 358 18ms 0ms 15 359 18ms 0ms 16 358 18ms 0ms 17 358 17ms 0ms 18 358 17ms 0ms 19 359 18ms 0ms 20 358 18ms 0ms 21 358 18ms 0ms 22 359 18ms 0ms 23 358 17ms 0ms 00 358 18ms 0ms [ User: symmetricds - Total duration: 440ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 440ms - Times executed: 8598 ]
-
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-31 18:27:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 05:05:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:11:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,598 344ms 0ms 1ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 31 01 358 14ms 0ms 02 359 14ms 0ms 03 358 13ms 0ms 04 358 13ms 0ms 05 358 14ms 0ms 06 358 14ms 0ms 07 358 13ms 0ms 08 359 13ms 0ms 09 358 13ms 0ms 10 358 14ms 0ms 11 358 14ms 0ms 12 359 15ms 0ms 13 358 14ms 0ms 14 358 14ms 0ms 15 359 14ms 0ms 16 358 14ms 0ms 17 358 15ms 0ms 18 358 14ms 0ms 19 359 14ms 0ms 20 358 14ms 0ms 21 358 14ms 0ms 22 359 14ms 0ms 23 358 14ms 0ms 00 358 14ms 0ms [ User: symmetricds - Total duration: 344ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 344ms - Times executed: 8598 ]
-
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-31 11:26:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 18:34:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 19:16:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,598 229ms 0ms 3ms 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 #16
Day Hour Count Duration Avg duration Aug 31 01 358 9ms 0ms 02 359 9ms 0ms 03 358 9ms 0ms 04 358 9ms 0ms 05 358 9ms 0ms 06 358 9ms 0ms 07 358 9ms 0ms 08 359 9ms 0ms 09 358 9ms 0ms 10 358 9ms 0ms 11 358 12ms 0ms 12 359 9ms 0ms 13 358 9ms 0ms 14 358 9ms 0ms 15 359 9ms 0ms 16 358 9ms 0ms 17 358 9ms 0ms 18 358 9ms 0ms 19 359 9ms 0ms 20 358 9ms 0ms 21 358 9ms 0ms 22 359 9ms 0ms 23 358 9ms 0ms 00 358 9ms 0ms [ User: symmetricds - Total duration: 229ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 229ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106199985' AND data_id <= '156199984' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200066' AND data_id <= '156200065' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '106200060' AND data_id <= '156200059' ORDER BY data_id ASC;
Date: 2019-08-31 10:29:32 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 17:14:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 16:41:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,295 296ms 0ms 0ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 31 01 243 12ms 0ms 02 237 11ms 0ms 03 240 10ms 0ms 04 239 10ms 0ms 05 240 11ms 0ms 06 235 10ms 0ms 07 239 10ms 0ms 08 240 11ms 0ms 09 231 10ms 0ms 10 239 10ms 0ms 11 267 12ms 0ms 12 287 13ms 0ms 13 278 12ms 0ms 14 281 13ms 0ms 15 275 12ms 0ms 16 275 13ms 0ms 17 275 13ms 0ms 18 276 12ms 0ms 19 285 13ms 0ms 20 282 13ms 0ms 21 280 13ms 0ms 22 281 13ms 0ms 23 288 14ms 0ms 00 282 13ms 0ms [ User: symmetricds - Total duration: 296ms - Times executed: 6295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 296ms - Times executed: 6295 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-08-31 00:01:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 13:49:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 16:05:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,295 735ms 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 31 01 243 30ms 0ms 02 237 28ms 0ms 03 240 29ms 0ms 04 239 29ms 0ms 05 240 28ms 0ms 06 235 28ms 0ms 07 239 28ms 0ms 08 240 29ms 0ms 09 231 27ms 0ms 10 239 28ms 0ms 11 267 30ms 0ms 12 287 31ms 0ms 13 278 31ms 0ms 14 281 31ms 0ms 15 275 30ms 0ms 16 275 32ms 0ms 17 275 30ms 0ms 18 276 31ms 0ms 19 285 33ms 0ms 20 282 32ms 0ms 21 280 32ms 0ms 22 281 31ms 0ms 23 288 33ms 0ms 00 282 34ms 0ms [ User: symmetricds - Total duration: 735ms - Times executed: 6295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 735ms - Times executed: 6295 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-08-31 23:45:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:05:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:51:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,651 330ms 0ms 1ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 01 762 43ms 0ms 02 1,216 76ms 0ms 03 542 28ms 0ms 04 384 21ms 0ms 05 474 35ms 0ms 06 670 42ms 0ms 07 36 4ms 0ms 08 36 4ms 0ms 09 36 5ms 0ms 10 36 4ms 0ms 11 36 4ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 5ms 0ms 19 36 4ms 0ms 20 36 4ms 0ms 21 27 4ms 0ms 22 24 3ms 0ms 23 24 3ms 0ms 00 24 3ms 0ms [ User: symmetricds - Total duration: 330ms - Times executed: 4651 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 330ms - Times executed: 4651 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199866', '9312729', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199539', '9312717', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199802', '9312728', 'redditch_bankstreet', current_timestamp);
Date: 2019-08-31 05:20:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 04:40:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 05:20:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 4,450 457ms 0ms 11ms 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 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 #20
Day Hour Count Duration Avg duration Aug 31 01 190 20ms 0ms 02 190 32ms 0ms 03 190 20ms 0ms 04 188 20ms 0ms 05 190 20ms 0ms 06 190 20ms 0ms 07 184 20ms 0ms 08 184 18ms 0ms 09 184 19ms 0ms 10 184 17ms 0ms 11 184 18ms 0ms 12 184 17ms 0ms 13 184 17ms 0ms 14 184 17ms 0ms 15 184 17ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 17ms 0ms 19 184 17ms 0ms 20 184 19ms 0ms 21 184 17ms 0ms 22 184 18ms 0ms 23 184 18ms 0ms 00 184 16ms 0ms [ User: symmetricds - Total duration: 457ms - Times executed: 4450 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 457ms - Times executed: 4450 ]
-
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 = '0' 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-31 01:21:34 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 19:03:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 21:13:43 Duration: 1ms 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 2ms 115ms 37ms 24 892ms 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 31 01 1 85ms 85ms 02 1 84ms 84ms 03 1 115ms 115ms 04 1 79ms 79ms 05 1 78ms 78ms 06 1 80ms 80ms 07 1 79ms 79ms 08 1 62ms 62ms 09 1 50ms 50ms 10 1 47ms 47ms 11 1 26ms 26ms 12 1 22ms 22ms 13 1 18ms 18ms 14 1 14ms 14ms 15 1 11ms 11ms 16 1 9ms 9ms 17 1 4ms 4ms 18 1 3ms 3ms 19 1 3ms 3ms 20 1 3ms 3ms 21 1 3ms 3ms 22 1 2ms 2ms 23 1 3ms 3ms 00 1 2ms 2ms [ User: symmetricds - Total duration: 892ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 892ms - 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-31 02:00:00 Duration: 115ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 85ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 13ms 45ms 34ms 292 10s132ms SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), ?) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), ?) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), ?) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), ?) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), ?) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), ?) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 01 13 465ms 35ms 02 12 414ms 34ms 03 12 427ms 35ms 04 12 423ms 35ms 05 12 412ms 34ms 06 12 414ms 34ms 07 13 446ms 34ms 08 12 423ms 35ms 09 12 348ms 29ms 10 12 393ms 32ms 11 12 410ms 34ms 12 12 436ms 36ms 13 13 460ms 35ms 14 12 425ms 35ms 15 12 417ms 34ms 16 12 425ms 35ms 17 12 434ms 36ms 18 12 412ms 34ms 19 13 456ms 35ms 20 12 412ms 34ms 21 12 415ms 34ms 22 12 404ms 33ms 23 12 429ms 35ms 00 12 420ms 35ms [ User: librenms - Total duration: 10s132ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s132ms - Times executed: 292 ]
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
-
SELECT datname, numbackends AS backends, xact_commit AS commits, xact_rollback AS rollbacks, blks_read AS read, blks_hit AS hit, ( SELECT sum(idx_scan) FROM pg_stat_user_indexes) AS idxscan, coalesce(( SELECT sum(idx_tup_read) FROM pg_stat_user_indexes), 0) AS idxtupread, coalesce(( SELECT sum(idx_tup_fetch) FROM pg_stat_user_indexes), 0) AS idxtupfetch, coalesce(( SELECT sum(idx_blks_read) FROM pg_statio_user_indexes), 0) AS idxblksread, coalesce(( SELECT sum(idx_blks_hit) FROM pg_statio_user_indexes), 0) AS idxblkshit, coalesce(( SELECT sum(seq_scan) FROM pg_stat_user_tables), 0) AS seqscan, coalesce(( SELECT sum(seq_tup_read) FROM pg_stat_user_tables), 0) AS seqtupread, tup_returned AS ret, tup_fetched AS FETCH, tup_inserted AS ins, tup_updated AS upd, tup_deleted AS del FROM pg_stat_database;
Date: 2019-08-31 07:45:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-31 11:45:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-08-31 06:40:12 Duration: 40ms Database: postgres User: librenms Remote: [local] Application: psql
3 0ms 121ms 17ms 180 3s183ms 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 #3
Day Hour Count Duration Avg duration Aug 31 01 15 111ms 7ms 02 15 95ms 6ms 03 15 126ms 8ms 04 15 137ms 9ms 05 15 93ms 6ms 06 15 108ms 7ms 07 15 145ms 9ms 08 15 713ms 47ms 09 10 171ms 17ms 10 8 152ms 19ms 11 7 283ms 40ms 12 7 259ms 37ms 13 6 198ms 33ms 14 5 164ms 32ms 15 4 108ms 27ms 16 3 85ms 28ms 17 2 64ms 32ms 18 2 32ms 16ms 19 1 18ms 18ms 20 1 16ms 16ms 21 1 22ms 22ms 22 1 29ms 29ms 23 1 19ms 19ms 00 1 24ms 24ms [ User: symmetricds - Total duration: 3s183ms - Times executed: 180 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s183ms - Times executed: 180 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '106127332' AND '106132332' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106127332' AND '106132332' 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 '106132333' AND '106137333' AND create_time < '2019-08-30 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106132333' AND '106137333' 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 '106165166' AND '106170166' AND create_time < '2019-08-30 10:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106165166' AND '106170166' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-08-31 07:00:00 Duration: 121ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 07:00:00 Duration: 115ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 13ms 6ms 145 994ms 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 31 01 94 670ms 7ms 02 3 13ms 4ms 03 3 18ms 6ms 04 3 17ms 5ms 05 3 18ms 6ms 06 3 18ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 8ms 4ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 677ms - Times executed: 100 ]
[ User: pharmisight - Total duration: 317ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 994ms - Times executed: 145 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-08-31 00:30:17 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:30:16 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 11ms 6ms 177 1s153ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 31 01 8 52ms 6ms 02 8 56ms 7ms 03 8 56ms 7ms 04 8 56ms 7ms 05 8 55ms 6ms 06 8 57ms 7ms 07 8 58ms 7ms 08 8 55ms 6ms 09 8 56ms 7ms 10 8 51ms 6ms 11 8 38ms 4ms 12 8 57ms 7ms 13 8 43ms 5ms 14 8 58ms 7ms 15 8 60ms 7ms 16 8 58ms 7ms 17 8 45ms 5ms 18 8 47ms 5ms 19 8 45ms 5ms 20 8 42ms 5ms 21 5 28ms 5ms 22 4 23ms 5ms 23 4 23ms 5ms 00 4 22ms 5ms [ User: symmetricds - Total duration: 1s153ms - Times executed: 177 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s153ms - Times executed: 177 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '387861104', "total_memory_bytes" = '1190133760', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 01:55:32', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '195.191.219.215', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '2', "free_memory_bytes" = '877741920', "total_memory_bytes" = '1191182336', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 10:10:32', "last_restart_time" = '2019-08-20 01:25:09.822', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-9-amd64', "available_processors" = '6', "free_memory_bytes" = '102585944', "total_memory_bytes" = '274726912', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_222', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-08-31 12:34:08', "last_restart_time" = '2019-08-06 09:07:46', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
Date: 2019-08-31 01:55:43 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:10:44 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 12:35:45 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 19ms 5ms 166 949ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 31 01 15 69ms 4ms 02 15 70ms 4ms 03 15 92ms 6ms 04 15 78ms 5ms 05 15 66ms 4ms 06 15 67ms 4ms 07 15 66ms 4ms 08 10 39ms 3ms 09 8 33ms 4ms 10 7 29ms 4ms 11 7 104ms 14ms 12 6 74ms 12ms 13 5 53ms 10ms 14 4 33ms 8ms 15 3 27ms 9ms 16 2 16ms 8ms 17 2 4ms 2ms 18 1 3ms 3ms 19 1 3ms 3ms 20 1 3ms 3ms 21 1 3ms 3ms 22 1 3ms 3ms 23 1 3ms 3ms 00 1 2ms 2ms [ User: symmetricds - Total duration: 949ms - Times executed: 166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 166 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '106169530' AND '106174530' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106169530' AND '106174530');
-
DELETE FROM sym_data WHERE data_id BETWEEN '106184533' AND '106189533' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106184533' AND '106189533');
-
DELETE FROM sym_data WHERE data_id BETWEEN '106179532' AND '106184532' AND data_id < '106199979' AND create_time < '2019-08-30 10:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '106179532' AND '106184532');
Date: 2019-08-31 10:00:00 Duration: 19ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 10:00:00 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 2ms 1ms 939 1s363ms 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 #7
Day Hour Count Duration Avg duration Aug 31 01 49 72ms 1ms 02 53 76ms 1ms 03 53 75ms 1ms 04 56 81ms 1ms 05 57 82ms 1ms 06 56 82ms 1ms 07 56 81ms 1ms 08 57 79ms 1ms 09 53 74ms 1ms 10 56 81ms 1ms 11 36 51ms 1ms 12 29 42ms 1ms 13 26 37ms 1ms 14 27 40ms 1ms 15 28 41ms 1ms 16 28 42ms 1ms 17 27 39ms 1ms 18 27 39ms 1ms 19 29 40ms 1ms 20 26 38ms 1ms 21 27 40ms 1ms 22 29 41ms 1ms 23 26 37ms 1ms 00 28 41ms 1ms [ User: symmetricds - Total duration: 1s363ms - Times executed: 939 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s363ms - Times executed: 939 ]
-
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-31 01:05:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 11:29:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:07:33 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 4ms 1ms 1,159 1s185ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 31 01 61 60ms 0ms 02 66 69ms 1ms 03 67 67ms 1ms 04 66 65ms 0ms 05 68 72ms 1ms 06 69 71ms 1ms 07 67 71ms 1ms 08 64 70ms 1ms 09 66 73ms 1ms 10 63 63ms 1ms 11 45 45ms 1ms 12 38 37ms 0ms 13 32 31ms 0ms 14 34 33ms 0ms 15 36 35ms 0ms 16 36 36ms 1ms 17 33 32ms 0ms 18 36 36ms 1ms 19 37 35ms 0ms 20 34 34ms 1ms 21 36 35ms 0ms 22 36 36ms 1ms 23 35 34ms 0ms 00 34 34ms 1ms [ User: symmetricds - Total duration: 1s185ms - Times executed: 1159 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s185ms - Times executed: 1159 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 07:35:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 08:03:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:23:35 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 4ms 0ms 949 904ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 31 01 50 46ms 0ms 02 58 55ms 0ms 03 54 52ms 0ms 04 58 56ms 0ms 05 56 55ms 0ms 06 56 54ms 0ms 07 56 53ms 0ms 08 58 56ms 0ms 09 54 52ms 0ms 10 55 56ms 1ms 11 37 34ms 0ms 12 28 25ms 0ms 13 26 22ms 0ms 14 27 26ms 0ms 15 28 28ms 1ms 16 28 25ms 0ms 17 27 24ms 0ms 18 27 25ms 0ms 19 29 25ms 0ms 20 26 24ms 0ms 21 27 24ms 0ms 22 29 27ms 0ms 23 27 24ms 0ms 00 28 25ms 0ms [ User: symmetricds - Total duration: 904ms - Times executed: 949 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 904ms - Times executed: 949 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 14:19:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:49:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 13:21:21 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 931 824ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 01 49 42ms 0ms 02 57 49ms 0ms 03 53 46ms 0ms 04 54 48ms 0ms 05 52 46ms 0ms 06 54 48ms 0ms 07 54 49ms 0ms 08 58 51ms 0ms 09 53 47ms 0ms 10 54 48ms 0ms 11 36 31ms 0ms 12 28 25ms 0ms 13 26 22ms 0ms 14 27 23ms 0ms 15 28 24ms 0ms 16 28 24ms 0ms 17 27 23ms 0ms 18 27 24ms 0ms 19 29 24ms 0ms 20 26 22ms 0ms 21 27 23ms 0ms 22 29 26ms 0ms 23 27 23ms 0ms 00 28 24ms 0ms [ User: symmetricds - Total duration: 824ms - Times executed: 931 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 824ms - Times executed: 931 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-08-31 06:47:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:23:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:53:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 2ms 0ms 17,197 10s163ms 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 #11
Day Hour Count Duration Avg duration Aug 31 01 717 425ms 0ms 02 718 436ms 0ms 03 716 439ms 0ms 04 716 441ms 0ms 05 716 432ms 0ms 06 716 430ms 0ms 07 716 428ms 0ms 08 718 436ms 0ms 09 716 435ms 0ms 10 716 429ms 0ms 11 716 416ms 0ms 12 718 413ms 0ms 13 716 411ms 0ms 14 716 414ms 0ms 15 718 413ms 0ms 16 716 417ms 0ms 17 716 410ms 0ms 18 716 412ms 0ms 19 718 419ms 0ms 20 716 411ms 0ms 21 716 418ms 0ms 22 718 414ms 0ms 23 716 421ms 0ms 00 716 429ms 0ms [ User: symmetricds - Total duration: 10s163ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s163ms - Times executed: 17197 ]
-
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-31 05:42:37 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 09:06:08 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 21:47:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 12ms 0ms 1,916 1s52ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 01 363 238ms 0ms 02 590 256ms 0ms 03 253 167ms 0ms 04 174 107ms 0ms 05 219 102ms 0ms 06 317 180ms 0ms [ User: pharmisight - Total duration: 1s52ms - Times executed: 1916 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s52ms - Times executed: 1916 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006028735', '2019-08-31 03:17:37', 'RYBAKJ', '2019-08-31 02:40:01.716', '106864', '24', '150505230149500723');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006022431', '2019-08-31 00:36:13', 'BERLANR', '2019-08-31 00:00:00.044', '64255', '24', '31237090428341001');
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ('5006028491', '2019-08-31 03:32:52', 'RYBAKJ', '2019-08-31 03:00:00.055', '41134', '14', '150505230149501508');
Date: 2019-08-31 02:40:01 Duration: 12ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:00:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 2ms 0ms 6,295 735ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 01 243 30ms 0ms 02 237 28ms 0ms 03 240 29ms 0ms 04 239 29ms 0ms 05 240 28ms 0ms 06 235 28ms 0ms 07 239 28ms 0ms 08 240 29ms 0ms 09 231 27ms 0ms 10 239 28ms 0ms 11 267 30ms 0ms 12 287 31ms 0ms 13 278 31ms 0ms 14 281 31ms 0ms 15 275 30ms 0ms 16 275 32ms 0ms 17 275 30ms 0ms 18 276 31ms 0ms 19 285 33ms 0ms 20 282 32ms 0ms 21 280 32ms 0ms 22 281 31ms 0ms 23 288 33ms 0ms 00 282 34ms 0ms [ User: symmetricds - Total duration: 735ms - Times executed: 6295 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 735ms - Times executed: 6295 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-08-31 23:45:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 00:05:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 03:51:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 11ms 0ms 4,450 457ms 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 #14
Day Hour Count Duration Avg duration Aug 31 01 190 20ms 0ms 02 190 32ms 0ms 03 190 20ms 0ms 04 188 20ms 0ms 05 190 20ms 0ms 06 190 20ms 0ms 07 184 20ms 0ms 08 184 18ms 0ms 09 184 19ms 0ms 10 184 17ms 0ms 11 184 18ms 0ms 12 184 17ms 0ms 13 184 17ms 0ms 14 184 17ms 0ms 15 184 17ms 0ms 16 184 17ms 0ms 17 184 16ms 0ms 18 184 17ms 0ms 19 184 17ms 0ms 20 184 19ms 0ms 21 184 17ms 0ms 22 184 18ms 0ms 23 184 18ms 0ms 00 184 16ms 0ms [ User: symmetricds - Total duration: 457ms - Times executed: 4450 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 457ms - Times executed: 4450 ]
-
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 = '0' 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-31 01:21:34 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 19:03:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 21:13:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 4,651 330ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 31 01 762 43ms 0ms 02 1,216 76ms 0ms 03 542 28ms 0ms 04 384 21ms 0ms 05 474 35ms 0ms 06 670 42ms 0ms 07 36 4ms 0ms 08 36 4ms 0ms 09 36 5ms 0ms 10 36 4ms 0ms 11 36 4ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 4ms 0ms 18 36 5ms 0ms 19 36 4ms 0ms 20 36 4ms 0ms 21 27 4ms 0ms 22 24 3ms 0ms 23 24 3ms 0ms 00 24 3ms 0ms [ User: symmetricds - Total duration: 330ms - Times executed: 4651 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 330ms - Times executed: 4651 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199866', '9312729', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199539', '9312717', 'redditch_cloud', current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ('106199802', '9312728', 'redditch_bankstreet', current_timestamp);
Date: 2019-08-31 05:20:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 04:40:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 05:20:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 17,326 949ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 31 01 726 39ms 0ms 02 728 39ms 0ms 03 726 39ms 0ms 04 724 38ms 0ms 05 726 39ms 0ms 06 726 39ms 0ms 07 720 39ms 0ms 08 722 38ms 0ms 09 720 38ms 0ms 10 720 39ms 0ms 11 720 39ms 0ms 12 722 41ms 0ms 13 720 39ms 0ms 14 720 39ms 0ms 15 722 40ms 0ms 16 720 40ms 0ms 17 720 39ms 0ms 18 720 39ms 0ms 19 722 40ms 0ms 20 720 39ms 0ms 21 720 39ms 0ms 22 722 39ms 0ms 23 720 39ms 0ms 00 720 40ms 0ms [ User: symmetricds - Total duration: 949ms - Times executed: 17326 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 17326 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
Date: 2019-08-31 11:45:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 06:21:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 14:03:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 2ms 0ms 25,148 1s375ms 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 31 01 1,126 60ms 0ms 02 1,052 57ms 0ms 03 1,050 55ms 0ms 04 1,048 56ms 0ms 05 1,050 57ms 0ms 06 1,050 57ms 0ms 07 1,044 56ms 0ms 08 1,046 56ms 0ms 09 1,044 56ms 0ms 10 1,044 53ms 0ms 11 1,044 55ms 0ms 12 1,046 56ms 0ms 13 1,044 56ms 0ms 14 1,044 56ms 0ms 15 1,046 56ms 0ms 16 1,044 57ms 0ms 17 1,044 56ms 0ms 18 1,044 59ms 0ms 19 1,046 61ms 0ms 20 1,044 58ms 0ms 21 1,038 58ms 0ms 22 1,038 58ms 0ms 23 1,036 56ms 0ms 00 1,036 57ms 0ms [ User: symmetricds - Total duration: 1s375ms - Times executed: 25148 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s375ms - Times executed: 25148 ]
-
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-31 20:49:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:55:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 04:54:35 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 21,984 1s173ms 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 #18
Day Hour Count Duration Avg duration Aug 31 01 916 43ms 0ms 02 916 46ms 0ms 03 916 44ms 0ms 04 916 35ms 0ms 05 916 51ms 0ms 06 916 26ms 0ms 07 916 51ms 0ms 08 916 49ms 0ms 09 916 50ms 0ms 10 916 51ms 0ms 11 916 52ms 0ms 12 916 51ms 0ms 13 916 51ms 0ms 14 916 50ms 0ms 15 916 51ms 0ms 16 916 53ms 0ms 17 916 52ms 0ms 18 916 51ms 0ms 19 916 49ms 0ms 20 916 50ms 0ms 21 916 50ms 0ms 22 916 50ms 0ms 23 916 53ms 0ms 00 916 53ms 0ms [ User: pharmisight - Total duration: 1s173ms - Times executed: 21984 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s173ms - Times executed: 21984 ]
-
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 = '3649' 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 = '3454' 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 = '32964824' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-08-31 12:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 24,768 1s307ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 01 1,032 49ms 0ms 02 1,032 50ms 0ms 03 1,032 50ms 0ms 04 1,032 39ms 0ms 05 1,032 58ms 0ms 06 1,032 29ms 0ms 07 1,032 57ms 0ms 08 1,032 56ms 0ms 09 1,032 56ms 0ms 10 1,032 56ms 0ms 11 1,032 58ms 0ms 12 1,032 56ms 0ms 13 1,032 56ms 0ms 14 1,032 56ms 0ms 15 1,032 56ms 0ms 16 1,032 59ms 0ms 17 1,032 58ms 0ms 18 1,032 57ms 0ms 19 1,032 55ms 0ms 20 1,032 55ms 0ms 21 1,032 57ms 0ms 22 1,032 56ms 0ms 23 1,032 58ms 0ms 00 1,032 59ms 0ms [ User: pharmisight - Total duration: 1s307ms - Times executed: 24768 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s307ms - Times executed: 24768 ]
-
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 = '33074355' 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 = '33070170' 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 = '3618' ORDER BY itemcodes0_.code ASC;
Date: 2019-08-31 07:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 15:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,598 440ms 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 31 01 358 18ms 0ms 02 359 19ms 0ms 03 358 18ms 0ms 04 358 18ms 0ms 05 358 18ms 0ms 06 358 19ms 0ms 07 358 18ms 0ms 08 359 18ms 0ms 09 358 18ms 0ms 10 358 18ms 0ms 11 358 18ms 0ms 12 359 17ms 0ms 13 358 17ms 0ms 14 358 18ms 0ms 15 359 18ms 0ms 16 358 18ms 0ms 17 358 17ms 0ms 18 358 17ms 0ms 19 359 18ms 0ms 20 358 18ms 0ms 21 358 18ms 0ms 22 359 18ms 0ms 23 358 17ms 0ms 00 358 18ms 0ms [ User: symmetricds - Total duration: 440ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 440ms - Times executed: 8598 ]
-
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-31 18:27:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 05:05:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-08-31 01:11:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,192,517 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 31 16 1 - FATAL: no pg_hba.conf entry for host "164.52.24.179", user "test", database "test", SSL off
Date: 2019-08-31 15:10:12 Database: test Application: [unknown] User: test Remote: 164.52.24.179 Code: