pgBadger-
Global information
- Generated on Mon Sep 23 00:00:26 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,169,063 log entries in 24s
- Log start from 2019-09-22 00:00:00 to 2019-09-22 23:59:59
-
Overview
Global Stats
- 173 Number of unique normalized queries
- 1,089,037 Number of queries
- 59s199ms Total query duration
- 2019-09-22 00:00:00 First query
- 2019-09-22 23:59:59 Last query
- 2,016 queries/s at 2019-09-22 06:40:00 Query peak
- 4 Number of events
- 2 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 46 Total number of automatic vacuums
- 77 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 3,610 Total number of sessions
- 1 sessions at 2019-09-22 05:01:14 Session peak
- 15d29m4s Total duration of sessions
- 5m59s Average duration of sessions
- 301 Average queries per session
- 16ms Average queries duration per session
- 3,610 Total number of connections
- 5 connections/s at 2019-09-22 00:30:25 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2,016 queries/s Query Peak
- 2019-09-22 06:40:00 Date
SELECT Traffic
Key values
- 1,976 queries/s Query Peak
- 2019-09-22 21:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 170 queries/s Query Peak
- 2019-09-22 21:00:05 Date
Queries duration
Key values
- 59s199ms Total query duration
Prepared queries ratio
Key values
- 1.60 Ratio of bind vs prepare
- 170.33 % 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) Sep 22 00 55,114 0ms 43ms 0ms 83ms 86ms 1s53ms 01 44,915 0ms 99ms 0ms 64ms 72ms 217ms 02 45,018 0ms 45ms 0ms 68ms 72ms 150ms 03 44,806 0ms 38ms 0ms 63ms 72ms 205ms 04 44,585 0ms 41ms 0ms 66ms 73ms 191ms 05 44,653 0ms 45ms 0ms 64ms 73ms 195ms 06 44,682 0ms 43ms 0ms 67ms 74ms 155ms 07 44,687 0ms 45ms 0ms 72ms 72ms 196ms 08 44,784 0ms 44ms 0ms 65ms 76ms 187ms 09 44,842 0ms 46ms 0ms 70ms 74ms 204ms 10 44,784 0ms 41ms 0ms 64ms 73ms 187ms 11 44,958 0ms 37ms 0ms 62ms 75ms 190ms 12 44,991 0ms 39ms 0ms 67ms 73ms 224ms 13 44,921 0ms 39ms 0ms 64ms 71ms 186ms 14 44,769 0ms 37ms 0ms 65ms 72ms 186ms 15 44,933 0ms 38ms 0ms 65ms 71ms 160ms 16 44,780 0ms 39ms 0ms 64ms 77ms 188ms 17 44,948 0ms 41ms 0ms 66ms 71ms 196ms 18 44,966 0ms 38ms 0ms 63ms 72ms 186ms 19 44,958 0ms 41ms 0ms 67ms 75ms 190ms 20 45,808 0ms 38ms 0ms 66ms 119ms 369ms 21 46,177 0ms 38ms 0ms 65ms 130ms 179ms 22 45,024 0ms 38ms 0ms 64ms 79ms 189ms 23 44,934 0ms 40ms 0ms 63ms 72ms 185ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 22 00 21,196 0 0ms 45ms 53ms 949ms 01 14,689 0 0ms 43ms 56ms 62ms 02 14,711 0 0ms 47ms 54ms 61ms 03 14,659 0 0ms 43ms 54ms 67ms 04 14,597 0 0ms 36ms 55ms 60ms 05 14,633 0 0ms 42ms 54ms 63ms 06 14,633 0 0ms 48ms 55ms 64ms 07 14,620 0 0ms 49ms 57ms 64ms 08 14,670 0 0ms 41ms 56ms 61ms 09 14,686 0 0ms 51ms 55ms 62ms 10 14,664 0 0ms 47ms 54ms 56ms 11 14,711 0 0ms 42ms 53ms 58ms 12 14,714 0 0ms 40ms 56ms 62ms 13 14,696 0 0ms 44ms 54ms 57ms 14 14,657 0 0ms 42ms 55ms 62ms 15 14,685 0 0ms 48ms 54ms 57ms 16 14,678 0 0ms 44ms 53ms 62ms 17 14,708 0 0ms 40ms 55ms 57ms 18 14,718 0 0ms 51ms 55ms 56ms 19 14,739 0 0ms 41ms 55ms 58ms 20 15,251 0 0ms 50ms 57ms 202ms 21 14,975 0 0ms 38ms 52ms 73ms 22 14,728 0 0ms 48ms 54ms 58ms 23 14,718 0 0ms 39ms 54ms 58ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 22 00 327 1,057 79 0 0ms 9ms 12ms 17ms 01 88 54 80 0 0ms 1ms 4ms 8ms 02 88 54 81 0 0ms 1ms 4ms 8ms 03 88 53 82 0 0ms 1ms 5ms 8ms 04 88 54 80 0 0ms 1ms 4ms 8ms 05 88 53 82 0 0ms 1ms 5ms 8ms 06 88 54 80 0 0ms 1ms 5ms 8ms 07 88 54 83 0 0ms 1ms 5ms 8ms 08 88 53 79 0 0ms 1ms 5ms 8ms 09 88 54 81 0 0ms 1ms 7ms 8ms 10 88 53 82 0 0ms 1ms 5ms 8ms 11 88 54 80 0 0ms 1ms 4ms 8ms 12 88 54 82 0 0ms 1ms 7ms 8ms 13 88 53 80 0 0ms 1ms 5ms 8ms 14 88 54 82 0 0ms 1ms 5ms 8ms 15 88 53 80 0 0ms 1ms 4ms 8ms 16 88 54 82 0 0ms 1ms 5ms 8ms 17 88 54 81 0 0ms 1ms 4ms 8ms 18 88 53 80 0 0ms 1ms 4ms 8ms 19 88 54 82 0 0ms 1ms 4ms 8ms 20 318 153 125 0 0ms 1ms 7ms 13ms 21 572 199 81 0 0ms 1ms 6ms 21ms 22 88 53 82 0 0ms 1ms 3ms 8ms 23 88 54 80 0 0ms 1ms 4ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 22 00 31,850 55,052 1.73 89.05% 01 28,332 44,855 1.58 108.35% 02 28,238 44,958 1.59 107.76% 03 28,051 44,746 1.60 107.54% 04 28,022 44,525 1.59 107.96% 05 28,110 44,593 1.59 108.12% 06 27,991 44,620 1.59 107.58% 07 27,971 44,627 1.60 107.55% 08 28,291 44,724 1.58 108.47% 09 28,322 44,782 1.58 108.48% 10 28,093 44,724 1.59 107.74% 11 28,286 44,898 1.59 108.05% 12 28,126 44,929 1.60 107.40% 13 28,124 44,861 1.60 107.53% 14 28,235 44,709 1.58 108.32% 15 27,966 44,873 1.60 106.93% 16 28,513 44,720 1.57 109.34% 17 28,362 44,888 1.58 108.37% 18 28,327 44,904 1.59 108.18% 19 28,361 44,898 1.58 108.29% 20 28,727 45,748 1.59 106.09% 21 28,485 46,117 1.62 104.61% 22 28,557 44,964 1.57 108.96% 23 28,530 44,874 1.57 109.03% Day Hour Count Average / Second Sep 22 00 160 0.04/s 01 148 0.04/s 02 143 0.04/s 03 146 0.04/s 04 153 0.04/s 05 155 0.04/s 06 154 0.04/s 07 152 0.04/s 08 152 0.04/s 09 154 0.04/s 10 149 0.04/s 11 149 0.04/s 12 150 0.04/s 13 147 0.04/s 14 147 0.04/s 15 145 0.04/s 16 154 0.04/s 17 150 0.04/s 18 150 0.04/s 19 150 0.04/s 20 154 0.04/s 21 146 0.04/s 22 149 0.04/s 23 153 0.04/s Day Hour Count Average Duration Sep 22 00 160 5m44s 01 148 6m3s 02 143 6m14s 03 146 6m10s 04 153 6m2s 05 155 5m49s 06 154 5m43s 07 152 6m4s 08 152 5m56s 09 154 5m48s 10 149 6m3s 11 149 5m56s 12 150 6m1s 13 147 6m7s 14 147 6m5s 15 145 6m4s 16 154 5m55s 17 150 5m58s 18 150 6m7s 19 150 5m55s 20 154 5m51s 21 146 6m2s 22 149 6m11s 23 153 5m55s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2019-09-22 00:30:25 Date
Connections per database
Key values
- pharmisight Main Database
- 3,610 connections Total
Connections per user
Key values
- pharmisight Main User
- 3,610 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-09-22 05:01:14 Date
Histogram of session times
Key values
- 2,409 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 3,610 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 3,610 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 3,610 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 367 buffers Checkpoint Peak
- 2019-09-22 01:04:54 Date
- 36.827 seconds Highest write time
- 0.073 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-09-22 00:49:21 Date
Checkpoints distance
Key values
- 2.76 Mo Distance Peak
- 2019-09-22 00:29:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 22 00 1,667 167.199s 0.018s 167.283s 01 693 69.553s 0.026s 69.647s 02 569 57.02s 0.092s 57.176s 03 655 65.78s 0.024s 65.867s 04 626 62.857s 0.026s 62.962s 05 574 57.523s 0.026s 57.617s 06 548 55.007s 0.022s 55.096s 07 606 60.839s 0.026s 60.946s 08 514 51.606s 0.02s 51.695s 09 544 54.614s 0.017s 54.715s 10 536 53.709s 0.023s 53.798s 11 480 48.183s 0.043s 48.297s 12 482 48.391s 0.02s 48.482s 13 703 70.477s 0.015s 70.556s 14 417 41.874s 0.018s 41.963s 15 668 66.954s 0.091s 67.116s 16 517 51.895s 0.027s 51.991s 17 486 48.797s 0.019s 48.886s 18 517 51.902s 0.072s 52.043s 19 554 55.625s 0.02s 55.729s 20 649 65.157s 0.015s 65.232s 21 623 62.537s 0.092s 62.688s 22 444 44.474s 0.011s 44.531s 23 476 47.783s 0.012s 47.851s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 22 00 0 0 1 350 0.004s 0s 01 0 0 0 315 0.003s 0s 02 0 0 0 313 0.073s 0.003s 03 0 0 0 325 0.008s 0s 04 0 0 0 317 0.008s 0s 05 0 0 0 316 0.012s 0s 06 0 0 0 313 0.003s 0s 07 0 0 0 317 0.003s 0s 08 0 0 1 310 0.003s 0s 09 0 0 0 317 0.003s 0s 10 0 0 0 303 0.003s 0s 11 0 0 0 289 0.014s 0s 12 0 0 0 307 0.003s 0s 13 0 0 0 312 0.002s 0s 14 0 0 0 297 0.002s 0s 15 0 0 0 305 0.069s 0.002s 16 0 0 0 308 0.003s 0s 17 0 0 0 309 0.002s 0s 18 0 0 1 296 0.055s 0.002s 19 0 0 0 304 0.003s 0s 20 0 0 0 284 0.002s 0s 21 0 0 0 262 0.070s 0.003s 22 0 0 0 202 0.002s 0s 23 0 0 0 206 0.002s 0.001s Day Hour Count Avg time (sec) Sep 22 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 Sep 22 00 770.83 kB 1,155.92 kB 01 199.36 kB 849.82 kB 02 165.58 kB 641.67 kB 03 187.17 kB 576.33 kB 04 191.17 kB 679.42 kB 05 164.00 kB 580.67 kB 06 146.73 kB 504.00 kB 07 163.50 kB 627.58 kB 08 131.17 kB 311.75 kB 09 129.25 kB 314.08 kB 10 142.83 kB 494.17 kB 11 138.08 kB 276.50 kB 12 111.18 kB 341.36 kB 13 192.67 kB 506.33 kB 14 100.08 kB 228.92 kB 15 176.50 kB 608.42 kB 16 152.17 kB 391.83 kB 17 134.92 kB 270.42 kB 18 145.17 kB 387.00 kB 19 162.58 kB 395.08 kB 20 236.70 kB 617.40 kB 21 310.22 kB 910.00 kB 22 214.57 kB 703.00 kB 23 166.44 kB 420.89 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 Sep 22 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_data_event (16) Main table analyzed (database pharmisight)
- 77 analyzes Total
Table Number of analyzes pharmisight.public.sym_data_event 16 pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data 13 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_delays 1 Total 77 Vacuums per table
Key values
- public.sym_outgoing_batch (9) Main table vacuumed on database pharmisight
- 46 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 9 9 pharmisight.public.sym_data_event 8 8 pharmisight.public.sym_data 7 7 pharmisight.public.sym_data_gap 5 5 pharmisight.public.sym_incoming_batch 5 5 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 4 4 pharmisight.public.flow_report_summary_days 1 1 pharmisight.public.sym_sequence 1 0 pharmisight.public.item_codes 1 1 Total 46 40 Tuples removed per table
Key values
- public.sym_data_event (2633) Main table with removed tuples on database pharmisight
- 7490 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 8 8 2633 1175 pharmisight.pg_catalog.pg_statistic 4 4 1332 0 pharmisight.public.sym_outgoing_batch 9 9 1069 289 pharmisight.public.sym_incoming_batch 5 5 892 0 pharmisight.public.sym_data 7 7 584 3900 pharmisight.public.item_codes 1 1 384 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.flow_report_summary_days 1 1 30 0 Total 46 40 7,490 5,364 Pages removed per table
Key values
- public.sym_data (3900) Main table with removed pages on database pharmisight
- 5364 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 7 7 584 3900 pharmisight.public.sym_data_event 8 8 2633 1175 pharmisight.public.sym_outgoing_batch 9 9 1069 289 pharmisight.public.flow_report_summary_days 1 1 30 0 pharmisight.public.sym_data_gap 5 5 255 0 pharmisight.pg_catalog.pg_statistic 4 4 1332 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_incoming_batch 5 5 892 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.public.item_codes 1 1 384 0 Total 46 40 7,490 5,364 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 22 00 3 9 01 3 3 02 2 4 03 6 3 04 2 5 05 3 3 06 3 2 07 4 3 08 0 3 09 1 3 10 0 3 11 1 2 12 2 1 13 2 5 14 0 0 15 3 3 16 2 2 17 0 4 18 1 1 19 0 4 20 5 4 21 1 5 22 1 3 23 1 2 - 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,736 Total read queries
- 278,766 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,088,453 Requests
- 48s827ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,071,191 Requests
User Request type Count Duration librenms Total 608 10s792ms SELECT 608 10s792ms pharmisight Total 60,919 4s960ms DELETE 42 4ms INSERT 208 136ms OTHERS 6,309 335ms SELECT 53,761 4s450ms TCL 558 27ms UPDATE 41 5ms symmetricds Total 1,071,191 45s417ms DELETE 2,015 921ms INSERT 2,945 861ms OTHERS 462,850 8s75ms SELECT 319,047 27s44ms TCL 281,786 5s999ms UPDATE 2,548 2s514ms tony Total 900 297ms SELECT 900 297ms Duration by user
Key values
- 45s417ms (symmetricds) Main time consuming user
User Request type Count Duration librenms Total 608 10s792ms SELECT 608 10s792ms pharmisight Total 60,919 4s960ms DELETE 42 4ms INSERT 208 136ms OTHERS 6,309 335ms SELECT 53,761 4s450ms TCL 558 27ms UPDATE 41 5ms symmetricds Total 1,071,191 45s417ms DELETE 2,015 921ms INSERT 2,945 861ms OTHERS 462,850 8s75ms SELECT 319,047 27s44ms TCL 281,786 5s999ms UPDATE 2,548 2s514ms tony Total 900 297ms SELECT 900 297ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,132,110 Requests
- 50s377ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,084,851 Requests
- 48s402ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-09-22 16:09:35 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,085,598 0-1ms duration
Slowest individual queries
Rank Duration Query 1 99ms COMMIT;[ Date: 2019-09-22 01:00:32 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 46ms 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-09-22 09:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
3 45ms 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-09-22 05:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
4 45ms 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-09-22 07:20:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
5 45ms 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-09-22 07:05:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
6 45ms 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-09-22 02:50:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
7 44ms 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-09-22 08:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
8 43ms 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-09-22 06:55:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
9 43ms 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-09-22 07:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
10 43ms DELETE FROM sym_data WHERE data_id BETWEEN '107287445' AND '107290473' AND create_time < '2019-09-21 00:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '107287445' AND '107290473') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '107287445' AND '107290473' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-09-22 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 41ms 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-09-22 06:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
12 41ms 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-09-22 10:50:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
13 41ms 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-09-22 17:50:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
14 41ms 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-09-22 19:30:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
15 41ms 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-09-22 04:40:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
16 40ms 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-09-22 23:15:11 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
17 40ms 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-09-22 06:40:13 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
18 39ms 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-09-22 17:30:10 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
19 39ms 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-09-22 12:10:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
20 39ms 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-09-22 16:15:12 - Database: postgres - User: librenms - Remote: [local] - Application: psql ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10s181ms 292 22ms 46ms 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 #1
Day Hour Count Duration Avg duration Sep 22 01 13 411ms 31ms 02 12 411ms 34ms 03 12 433ms 36ms 04 12 413ms 34ms 05 12 414ms 34ms 06 12 427ms 35ms 07 13 466ms 35ms 08 12 457ms 38ms 09 12 414ms 34ms 10 12 436ms 36ms 11 12 432ms 36ms 12 12 412ms 34ms 13 13 458ms 35ms 14 12 413ms 34ms 15 12 411ms 34ms 16 12 421ms 35ms 17 12 412ms 34ms 18 12 418ms 34ms 19 13 452ms 34ms 20 12 405ms 33ms 21 12 430ms 35ms 22 12 396ms 33ms 23 12 421ms 35ms 00 12 405ms 33ms [ User: librenms - Total duration: 10s181ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s181ms - 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-09-22 09:50:12 Duration: 46ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-22 05:50:12 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-22 07:20:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
2 9s923ms 17,199 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 22 01 717 409ms 0ms 02 716 413ms 0ms 03 718 419ms 0ms 04 716 415ms 0ms 05 716 416ms 0ms 06 718 409ms 0ms 07 716 419ms 0ms 08 716 414ms 0ms 09 716 409ms 0ms 10 718 414ms 0ms 11 716 407ms 0ms 12 716 417ms 0ms 13 718 408ms 0ms 14 716 414ms 0ms 15 716 410ms 0ms 16 718 409ms 0ms 17 716 424ms 0ms 18 716 412ms 0ms 19 716 415ms 0ms 20 718 406ms 0ms 21 716 412ms 0ms 22 716 410ms 0ms 23 716 416ms 0ms 00 718 414ms 0ms [ User: symmetricds - Total duration: 9s923ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s923ms - Times executed: 17199 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-22 11:26:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:47:39 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 18:13:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 7s526ms 426,767 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 22 01 18,342 317ms 0ms 02 17,785 312ms 0ms 03 17,838 310ms 0ms 04 17,741 313ms 0ms 05 17,635 311ms 0ms 06 17,653 313ms 0ms 07 17,673 309ms 0ms 08 17,685 311ms 0ms 09 17,713 310ms 0ms 10 17,735 314ms 0ms 11 17,720 315ms 0ms 12 17,796 316ms 0ms 13 17,817 310ms 0ms 14 17,784 313ms 0ms 15 17,717 311ms 0ms 16 17,802 312ms 0ms 17 17,703 315ms 0ms 18 17,791 319ms 0ms 19 17,798 314ms 0ms 20 17,777 313ms 0ms 21 17,719 312ms 0ms 22 17,944 313ms 0ms 23 17,826 318ms 0ms 00 17,773 311ms 0ms [ User: symmetricds - Total duration: 7s392ms - Times executed: 424748 ]
[ User: pharmisight - Total duration: 133ms - Times executed: 2019 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s526ms - Times executed: 426767 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-09-22 22:48:19 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:05:09 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 08:12:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4s853ms 135,588 0ms 99ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 01 6,552 543ms 0ms 02 5,619 273ms 0ms 03 5,635 189ms 0ms 04 5,601 177ms 0ms 05 5,569 175ms 0ms 06 5,571 193ms 0ms 07 5,582 175ms 0ms 08 5,581 189ms 0ms 09 5,596 186ms 0ms 10 5,600 173ms 0ms 11 5,594 173ms 0ms 12 5,623 179ms 0ms 13 5,625 172ms 0ms 14 5,619 195ms 0ms 15 5,593 186ms 0ms 16 5,624 174ms 0ms 17 5,588 174ms 0ms 18 5,620 173ms 0ms 19 5,623 176ms 0ms 20 5,613 199ms 0ms 21 5,615 201ms 0ms 22 5,702 206ms 0ms 23 5,629 185ms 0ms 00 5,614 175ms 0ms [ User: symmetricds - Total duration: 4s828ms - Times executed: 135317 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 271 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s853ms - Times executed: 135588 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-09-22 01:00:32 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:56:36 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:26:31 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s890ms 155,483 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 22 01 7,779 87ms 0ms 02 6,426 75ms 0ms 03 6,445 76ms 0ms 04 6,418 81ms 0ms 05 6,374 85ms 0ms 06 6,389 76ms 0ms 07 6,392 78ms 0ms 08 6,395 77ms 0ms 09 6,404 77ms 0ms 10 6,409 77ms 0ms 11 6,411 75ms 0ms 12 6,428 80ms 0ms 13 6,444 77ms 0ms 14 6,426 78ms 0ms 15 6,408 79ms 0ms 16 6,431 76ms 0ms 17 6,405 81ms 0ms 18 6,431 76ms 0ms 19 6,430 81ms 0ms 20 6,430 78ms 0ms 21 6,419 75ms 0ms 22 6,519 78ms 0ms 23 6,444 78ms 0ms 00 6,426 77ms 0ms [ User: symmetricds - Total duration: 1s890ms - Times executed: 155483 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 155483 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-09-22 04:37:04 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:46:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 16:05:14 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s385ms 25,149 0ms 3ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 22 01 1,118 60ms 0ms 02 1,044 55ms 0ms 03 1,046 55ms 0ms 04 1,044 62ms 0ms 05 1,044 55ms 0ms 06 1,046 55ms 0ms 07 1,044 58ms 0ms 08 1,044 55ms 0ms 09 1,044 58ms 0ms 10 1,046 55ms 0ms 11 1,044 55ms 0ms 12 1,044 58ms 0ms 13 1,046 56ms 0ms 14 1,044 53ms 0ms 15 1,044 59ms 0ms 16 1,046 56ms 0ms 17 1,044 58ms 0ms 18 1,044 61ms 0ms 19 1,044 63ms 0ms 20 1,046 56ms 0ms 21 1,039 55ms 0ms 22 1,054 54ms 0ms 23 1,044 63ms 0ms 00 1,046 59ms 0ms [ User: symmetricds - Total duration: 1s385ms - Times executed: 25149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s385ms - Times executed: 25149 ]
-
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-09-22 18:03:15 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:02:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:10:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s357ms 25,850 0ms 1ms 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 #7
Day Hour Count Duration Avg duration Sep 22 01 2,068 103ms 0ms 02 1,034 40ms 0ms 03 1,034 38ms 0ms 04 1,034 68ms 0ms 05 1,034 57ms 0ms 06 1,034 58ms 0ms 07 1,034 37ms 0ms 08 1,034 61ms 0ms 09 1,034 58ms 0ms 10 1,034 57ms 0ms 11 1,034 57ms 0ms 12 1,034 60ms 0ms 13 1,034 57ms 0ms 14 1,034 56ms 0ms 15 1,034 57ms 0ms 16 1,034 44ms 0ms 17 1,034 57ms 0ms 18 1,034 60ms 0ms 19 1,034 56ms 0ms 20 1,034 59ms 0ms 21 1,034 61ms 0ms 22 1,034 28ms 0ms 23 1,034 58ms 0ms 00 1,034 57ms 0ms [ User: pharmisight - Total duration: 1s357ms - Times executed: 25850 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s357ms - Times executed: 25850 ]
-
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 = '3660' 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 = '3066' 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 = '3074' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-22 11:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s291ms 197 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 #8
Day Hour Count Duration Avg duration Sep 22 01 149 973ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 12ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 14ms 7ms 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 3 18ms 6ms 22 3 17ms 5ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 769ms - Times executed: 107 ]
[ User: pharmisight - Total duration: 522ms - Times executed: 90 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s291ms - Times executed: 197 ]
-
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;
-
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-09-22 00:30:27 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:00:01 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:27 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s218ms 22,925 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 #9
Day Hour Count Duration Avg duration Sep 22 01 1,834 89ms 0ms 02 917 37ms 0ms 03 917 34ms 0ms 04 917 60ms 0ms 05 917 51ms 0ms 06 917 53ms 0ms 07 917 33ms 0ms 08 917 55ms 0ms 09 917 52ms 0ms 10 917 52ms 0ms 11 917 51ms 0ms 12 917 53ms 0ms 13 917 52ms 0ms 14 917 51ms 0ms 15 917 52ms 0ms 16 917 41ms 0ms 17 917 51ms 0ms 18 917 54ms 0ms 19 917 51ms 0ms 20 917 53ms 0ms 21 917 54ms 0ms 22 917 25ms 0ms 23 917 52ms 0ms 00 917 51ms 0ms [ User: pharmisight - Total duration: 1s218ms - Times executed: 22925 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s218ms - Times executed: 22925 ]
-
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 = '3285' 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 = '3031' 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 = '3464' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-22 09:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s136ms 190 0ms 16ms 5ms 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 #10
Day Hour Count Duration Avg duration Sep 22 01 8 39ms 4ms 02 8 42ms 5ms 03 8 43ms 5ms 04 8 46ms 5ms 05 8 50ms 6ms 06 8 57ms 7ms 07 8 64ms 8ms 08 8 51ms 6ms 09 8 49ms 6ms 10 8 45ms 5ms 11 8 54ms 6ms 12 8 31ms 3ms 13 8 56ms 7ms 14 8 51ms 6ms 15 8 48ms 6ms 16 8 33ms 4ms 17 8 49ms 6ms 18 8 39ms 4ms 19 8 48ms 6ms 20 8 50ms 6ms 21 6 41ms 6ms 22 8 46ms 5ms 23 8 44ms 5ms 00 8 50ms 6ms [ User: symmetricds - Total duration: 1s136ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s136ms - Times executed: 190 ]
-
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" = '883739280', "total_memory_bytes" = '1489502208', "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-09-22 06:11:01', "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" = '99535128', "total_memory_bytes" = '264765440', "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-09-22 19:35:36', "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';
-
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" = '77054272', "total_memory_bytes" = '276299776', "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-09-22 10:20:36', "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-09-22 06:11:32 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:37:36 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:22:33 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s45ms 705 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 #11
Day Hour Count Duration Avg duration Sep 22 01 28 38ms 1ms 02 27 38ms 1ms 03 26 39ms 1ms 04 25 35ms 1ms 05 33 52ms 1ms 06 33 51ms 1ms 07 32 49ms 1ms 08 30 46ms 1ms 09 31 46ms 1ms 10 32 49ms 1ms 11 30 45ms 1ms 12 29 44ms 1ms 13 28 41ms 1ms 14 27 38ms 1ms 15 28 41ms 1ms 16 25 35ms 1ms 17 33 48ms 1ms 18 30 42ms 1ms 19 28 41ms 1ms 20 30 43ms 1ms 21 32 44ms 1ms 22 27 39ms 1ms 23 29 41ms 1ms 00 32 47ms 1ms [ User: symmetricds - Total duration: 1s45ms - Times executed: 705 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s45ms - Times executed: 705 ]
-
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-09-22 06:43:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 23:39:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 23:59:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 979ms 17,304 0ms 0ms 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 #12
Day Hour Count Duration Avg duration Sep 22 01 720 39ms 0ms 02 720 40ms 0ms 03 722 40ms 0ms 04 720 40ms 0ms 05 720 40ms 0ms 06 722 40ms 0ms 07 720 40ms 0ms 08 720 40ms 0ms 09 720 40ms 0ms 10 722 41ms 0ms 11 720 40ms 0ms 12 720 41ms 0ms 13 722 40ms 0ms 14 720 41ms 0ms 15 720 40ms 0ms 16 722 41ms 0ms 17 720 41ms 0ms 18 720 40ms 0ms 19 720 40ms 0ms 20 722 40ms 0ms 21 724 40ms 0ms 22 726 41ms 0ms 23 720 40ms 0ms 00 722 40ms 0ms [ User: symmetricds - Total duration: 979ms - Times executed: 17304 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 979ms - Times executed: 17304 ]
-
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 = '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';
Date: 2019-09-22 06:47:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:20:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 09:37:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 953ms 135,590 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 22 01 6,554 46ms 0ms 02 5,619 39ms 0ms 03 5,635 39ms 0ms 04 5,601 38ms 0ms 05 5,569 39ms 0ms 06 5,571 38ms 0ms 07 5,582 40ms 0ms 08 5,581 39ms 0ms 09 5,596 39ms 0ms 10 5,600 40ms 0ms 11 5,594 39ms 0ms 12 5,623 39ms 0ms 13 5,625 38ms 0ms 14 5,619 40ms 0ms 15 5,593 39ms 0ms 16 5,624 38ms 0ms 17 5,588 38ms 0ms 18 5,620 39ms 0ms 19 5,623 38ms 0ms 20 5,613 39ms 0ms 21 5,615 39ms 0ms 22 5,702 40ms 0ms 23 5,629 39ms 0ms 00 5,614 38ms 0ms [ User: symmetricds - Total duration: 951ms - Times executed: 135317 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 953ms - Times executed: 135590 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-09-22 00:50:01 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 21:09:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 09:11:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 934ms 936 0ms 7ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 22 01 40 39ms 0ms 02 33 32ms 0ms 03 33 32ms 0ms 04 32 30ms 0ms 05 43 40ms 0ms 06 48 47ms 0ms 07 42 41ms 0ms 08 40 40ms 1ms 09 44 40ms 0ms 10 43 43ms 1ms 11 39 41ms 1ms 12 40 38ms 0ms 13 38 47ms 1ms 14 33 32ms 0ms 15 37 36ms 0ms 16 33 33ms 1ms 17 44 46ms 1ms 18 39 39ms 1ms 19 37 36ms 0ms 20 40 37ms 0ms 21 43 42ms 0ms 22 38 37ms 0ms 23 37 36ms 0ms 00 40 38ms 0ms [ User: symmetricds - Total duration: 934ms - Times executed: 936 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 934ms - Times executed: 936 ]
-
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-09-22 12:39:11 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:57:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:07:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 758ms 6,582 0ms 3ms 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 #15
Day Hour Count Duration Avg duration Sep 22 01 272 32ms 0ms 02 282 35ms 0ms 03 285 32ms 0ms 04 274 33ms 0ms 05 257 29ms 0ms 06 253 29ms 0ms 07 264 34ms 0ms 08 264 31ms 0ms 09 271 29ms 0ms 10 268 30ms 0ms 11 271 30ms 0ms 12 283 31ms 0ms 13 280 33ms 0ms 14 282 34ms 0ms 15 269 30ms 0ms 16 280 30ms 0ms 17 267 30ms 0ms 18 283 32ms 0ms 19 284 32ms 0ms 20 274 30ms 0ms 21 267 29ms 0ms 22 288 31ms 0ms 23 288 31ms 0ms 00 276 31ms 0ms [ User: symmetricds - Total duration: 758ms - Times executed: 6582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 758ms - Times executed: 6582 ]
-
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-09-22 06:49:06 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 13:59:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 01:41:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 661ms 155 1ms 11ms 4ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 22 01 5 18ms 3ms 02 6 26ms 4ms 03 5 24ms 4ms 04 6 27ms 4ms 05 6 22ms 3ms 06 5 20ms 4ms 07 5 21ms 4ms 08 5 22ms 4ms 09 6 25ms 4ms 10 6 24ms 4ms 11 7 29ms 4ms 12 7 26ms 3ms 13 6 26ms 4ms 14 6 25ms 4ms 15 7 31ms 4ms 16 6 19ms 3ms 17 6 24ms 4ms 18 6 28ms 4ms 19 7 30ms 4ms 20 7 41ms 5ms 21 12 50ms 4ms 22 11 37ms 3ms 23 6 28ms 4ms 00 6 27ms 4ms [ User: symmetricds - Total duration: 661ms - Times executed: 155 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 661ms - Times executed: 155 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-22 19:03:16 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:18:16 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 22:18:19 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 647ms 688 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 #17
Day Hour Count Duration Avg duration Sep 22 01 28 26ms 0ms 02 27 24ms 0ms 03 26 24ms 0ms 04 25 22ms 0ms 05 27 26ms 0ms 06 30 30ms 1ms 07 30 26ms 0ms 08 27 26ms 0ms 09 29 26ms 0ms 10 33 34ms 1ms 11 29 27ms 0ms 12 29 26ms 0ms 13 27 27ms 1ms 14 27 23ms 0ms 15 28 26ms 0ms 16 25 22ms 0ms 17 33 31ms 0ms 18 30 27ms 0ms 19 28 25ms 0ms 20 30 27ms 0ms 21 32 30ms 0ms 22 27 25ms 0ms 23 29 26ms 0ms 00 32 28ms 0ms [ User: symmetricds - Total duration: 647ms - Times executed: 688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 647ms - Times executed: 688 ]
-
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-09-22 09:05:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:45:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:05:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 590ms 667 0ms 3ms 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 #18
Day Hour Count Duration Avg duration Sep 22 01 28 26ms 0ms 02 27 23ms 0ms 03 26 23ms 0ms 04 24 21ms 0ms 05 25 23ms 0ms 06 26 23ms 0ms 07 26 21ms 0ms 08 24 21ms 0ms 09 28 23ms 0ms 10 31 29ms 0ms 11 28 24ms 0ms 12 29 25ms 0ms 13 26 23ms 0ms 14 27 23ms 0ms 15 28 25ms 0ms 16 25 21ms 0ms 17 32 28ms 0ms 18 30 26ms 0ms 19 28 24ms 0ms 20 30 25ms 0ms 21 32 27ms 0ms 22 27 23ms 0ms 23 29 24ms 0ms 00 31 25ms 0ms [ User: symmetricds - Total duration: 590ms - Times executed: 667 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 590ms - Times executed: 667 ]
-
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-09-22 09:31:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:41:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 11:29:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 533ms 96 0ms 9ms 5ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 22 01 4 19ms 4ms 02 4 22ms 5ms 03 4 21ms 5ms 04 4 16ms 4ms 05 4 26ms 6ms 06 4 19ms 4ms 07 4 16ms 4ms 08 4 17ms 4ms 09 4 23ms 5ms 10 4 29ms 7ms 11 4 25ms 6ms 12 4 25ms 6ms 13 4 26ms 6ms 14 4 27ms 6ms 15 4 23ms 5ms 16 4 27ms 6ms 17 4 30ms 7ms 18 4 31ms 7ms 19 4 23ms 5ms 20 4 20ms 5ms 21 4 23ms 5ms 22 4 7ms 1ms 23 4 17ms 4ms 00 4 10ms 2ms [ User: symmetricds - Total duration: 533ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 533ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '30340720', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 19:17:25', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '52250784', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 17:17:24', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '72171464', total_memory_bytes = '264241152', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 05:17:23', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-09-22 19:17:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 17:17:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 05:17:23 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 528ms 17,266 0ms 1ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 01 718 21ms 0ms 02 720 22ms 0ms 03 720 21ms 0ms 04 718 22ms 0ms 05 720 21ms 0ms 06 720 20ms 0ms 07 720 20ms 0ms 08 718 21ms 0ms 09 720 22ms 0ms 10 720 22ms 0ms 11 718 21ms 0ms 12 720 21ms 0ms 13 720 23ms 0ms 14 720 22ms 0ms 15 718 22ms 0ms 16 720 22ms 0ms 17 720 22ms 0ms 18 718 22ms 0ms 19 720 22ms 0ms 20 720 22ms 0ms 21 720 22ms 0ms 22 718 21ms 0ms 23 720 22ms 0ms 00 720 21ms 0ms [ User: symmetricds - Total duration: 528ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 528ms - Times executed: 17266 ]
-
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-09-22 03:36:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:53:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 07:55:42 Duration: 0ms 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 426,767 7s526ms 0ms 3ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 22 01 18,342 317ms 0ms 02 17,785 312ms 0ms 03 17,838 310ms 0ms 04 17,741 313ms 0ms 05 17,635 311ms 0ms 06 17,653 313ms 0ms 07 17,673 309ms 0ms 08 17,685 311ms 0ms 09 17,713 310ms 0ms 10 17,735 314ms 0ms 11 17,720 315ms 0ms 12 17,796 316ms 0ms 13 17,817 310ms 0ms 14 17,784 313ms 0ms 15 17,717 311ms 0ms 16 17,802 312ms 0ms 17 17,703 315ms 0ms 18 17,791 319ms 0ms 19 17,798 314ms 0ms 20 17,777 313ms 0ms 21 17,719 312ms 0ms 22 17,944 313ms 0ms 23 17,826 318ms 0ms 00 17,773 311ms 0ms [ User: symmetricds - Total duration: 7s392ms - Times executed: 424748 ]
[ User: pharmisight - Total duration: 133ms - Times executed: 2019 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s526ms - Times executed: 426767 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-09-22 22:48:19 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:05:09 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 08:12:07 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 155,483 1s890ms 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 22 01 7,779 87ms 0ms 02 6,426 75ms 0ms 03 6,445 76ms 0ms 04 6,418 81ms 0ms 05 6,374 85ms 0ms 06 6,389 76ms 0ms 07 6,392 78ms 0ms 08 6,395 77ms 0ms 09 6,404 77ms 0ms 10 6,409 77ms 0ms 11 6,411 75ms 0ms 12 6,428 80ms 0ms 13 6,444 77ms 0ms 14 6,426 78ms 0ms 15 6,408 79ms 0ms 16 6,431 76ms 0ms 17 6,405 81ms 0ms 18 6,431 76ms 0ms 19 6,430 81ms 0ms 20 6,430 78ms 0ms 21 6,419 75ms 0ms 22 6,519 78ms 0ms 23 6,444 78ms 0ms 00 6,426 77ms 0ms [ User: symmetricds - Total duration: 1s890ms - Times executed: 155483 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s890ms - Times executed: 155483 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-09-22 04:37:04 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:46:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 16:05:14 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 135,590 953ms 0ms 2ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 22 01 6,554 46ms 0ms 02 5,619 39ms 0ms 03 5,635 39ms 0ms 04 5,601 38ms 0ms 05 5,569 39ms 0ms 06 5,571 38ms 0ms 07 5,582 40ms 0ms 08 5,581 39ms 0ms 09 5,596 39ms 0ms 10 5,600 40ms 0ms 11 5,594 39ms 0ms 12 5,623 39ms 0ms 13 5,625 38ms 0ms 14 5,619 40ms 0ms 15 5,593 39ms 0ms 16 5,624 38ms 0ms 17 5,588 38ms 0ms 18 5,620 39ms 0ms 19 5,623 38ms 0ms 20 5,613 39ms 0ms 21 5,615 39ms 0ms 22 5,702 40ms 0ms 23 5,629 39ms 0ms 00 5,614 38ms 0ms [ User: symmetricds - Total duration: 951ms - Times executed: 135317 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 953ms - Times executed: 135590 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-09-22 00:50:01 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 21:09:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 09:11:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 135,588 4s853ms 0ms 99ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 01 6,552 543ms 0ms 02 5,619 273ms 0ms 03 5,635 189ms 0ms 04 5,601 177ms 0ms 05 5,569 175ms 0ms 06 5,571 193ms 0ms 07 5,582 175ms 0ms 08 5,581 189ms 0ms 09 5,596 186ms 0ms 10 5,600 173ms 0ms 11 5,594 173ms 0ms 12 5,623 179ms 0ms 13 5,625 172ms 0ms 14 5,619 195ms 0ms 15 5,593 186ms 0ms 16 5,624 174ms 0ms 17 5,588 174ms 0ms 18 5,620 173ms 0ms 19 5,623 176ms 0ms 20 5,613 199ms 0ms 21 5,615 201ms 0ms 22 5,702 206ms 0ms 23 5,629 185ms 0ms 00 5,614 175ms 0ms [ User: symmetricds - Total duration: 4s828ms - Times executed: 135317 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 271 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s853ms - Times executed: 135588 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-09-22 01:00:32 Duration: 99ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:56:36 Duration: 27ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:26:31 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,850 1s357ms 0ms 1ms 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 #5
Day Hour Count Duration Avg duration Sep 22 01 2,068 103ms 0ms 02 1,034 40ms 0ms 03 1,034 38ms 0ms 04 1,034 68ms 0ms 05 1,034 57ms 0ms 06 1,034 58ms 0ms 07 1,034 37ms 0ms 08 1,034 61ms 0ms 09 1,034 58ms 0ms 10 1,034 57ms 0ms 11 1,034 57ms 0ms 12 1,034 60ms 0ms 13 1,034 57ms 0ms 14 1,034 56ms 0ms 15 1,034 57ms 0ms 16 1,034 44ms 0ms 17 1,034 57ms 0ms 18 1,034 60ms 0ms 19 1,034 56ms 0ms 20 1,034 59ms 0ms 21 1,034 61ms 0ms 22 1,034 28ms 0ms 23 1,034 58ms 0ms 00 1,034 57ms 0ms [ User: pharmisight - Total duration: 1s357ms - Times executed: 25850 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s357ms - Times executed: 25850 ]
-
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 = '3660' 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 = '3066' 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 = '3074' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-22 11:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 25,149 1s385ms 0ms 3ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 22 01 1,118 60ms 0ms 02 1,044 55ms 0ms 03 1,046 55ms 0ms 04 1,044 62ms 0ms 05 1,044 55ms 0ms 06 1,046 55ms 0ms 07 1,044 58ms 0ms 08 1,044 55ms 0ms 09 1,044 58ms 0ms 10 1,046 55ms 0ms 11 1,044 55ms 0ms 12 1,044 58ms 0ms 13 1,046 56ms 0ms 14 1,044 53ms 0ms 15 1,044 59ms 0ms 16 1,046 56ms 0ms 17 1,044 58ms 0ms 18 1,044 61ms 0ms 19 1,044 63ms 0ms 20 1,046 56ms 0ms 21 1,039 55ms 0ms 22 1,054 54ms 0ms 23 1,044 63ms 0ms 00 1,046 59ms 0ms [ User: symmetricds - Total duration: 1s385ms - Times executed: 25149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s385ms - Times executed: 25149 ]
-
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-09-22 18:03:15 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:02:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:10:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 22,925 1s218ms 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 Sep 22 01 1,834 89ms 0ms 02 917 37ms 0ms 03 917 34ms 0ms 04 917 60ms 0ms 05 917 51ms 0ms 06 917 53ms 0ms 07 917 33ms 0ms 08 917 55ms 0ms 09 917 52ms 0ms 10 917 52ms 0ms 11 917 51ms 0ms 12 917 53ms 0ms 13 917 52ms 0ms 14 917 51ms 0ms 15 917 52ms 0ms 16 917 41ms 0ms 17 917 51ms 0ms 18 917 54ms 0ms 19 917 51ms 0ms 20 917 53ms 0ms 21 917 54ms 0ms 22 917 25ms 0ms 23 917 52ms 0ms 00 917 51ms 0ms [ User: pharmisight - Total duration: 1s218ms - Times executed: 22925 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s218ms - Times executed: 22925 ]
-
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 = '3285' 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 = '3031' 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 = '3464' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-22 09:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,304 979ms 0ms 0ms 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 Sep 22 01 720 39ms 0ms 02 720 40ms 0ms 03 722 40ms 0ms 04 720 40ms 0ms 05 720 40ms 0ms 06 722 40ms 0ms 07 720 40ms 0ms 08 720 40ms 0ms 09 720 40ms 0ms 10 722 41ms 0ms 11 720 40ms 0ms 12 720 41ms 0ms 13 722 40ms 0ms 14 720 41ms 0ms 15 720 40ms 0ms 16 722 41ms 0ms 17 720 41ms 0ms 18 720 40ms 0ms 19 720 40ms 0ms 20 722 40ms 0ms 21 724 40ms 0ms 22 726 41ms 0ms 23 720 40ms 0ms 00 722 40ms 0ms [ User: symmetricds - Total duration: 979ms - Times executed: 17304 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 979ms - Times executed: 17304 ]
-
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 = '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';
Date: 2019-09-22 06:47:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:20:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 09:37:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,266 528ms 0ms 1ms 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 Sep 22 01 718 21ms 0ms 02 720 22ms 0ms 03 720 21ms 0ms 04 718 22ms 0ms 05 720 21ms 0ms 06 720 20ms 0ms 07 720 20ms 0ms 08 718 21ms 0ms 09 720 22ms 0ms 10 720 22ms 0ms 11 718 21ms 0ms 12 720 21ms 0ms 13 720 23ms 0ms 14 720 22ms 0ms 15 718 22ms 0ms 16 720 22ms 0ms 17 720 22ms 0ms 18 718 22ms 0ms 19 720 22ms 0ms 20 720 22ms 0ms 21 720 22ms 0ms 22 718 21ms 0ms 23 720 22ms 0ms 00 720 21ms 0ms [ User: symmetricds - Total duration: 528ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 528ms - Times executed: 17266 ]
-
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-09-22 03:36:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:53:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 07:55:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,199 9s923ms 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 Sep 22 01 717 409ms 0ms 02 716 413ms 0ms 03 718 419ms 0ms 04 716 415ms 0ms 05 716 416ms 0ms 06 718 409ms 0ms 07 716 419ms 0ms 08 716 414ms 0ms 09 716 409ms 0ms 10 718 414ms 0ms 11 716 407ms 0ms 12 716 417ms 0ms 13 718 408ms 0ms 14 716 414ms 0ms 15 716 410ms 0ms 16 718 409ms 0ms 17 716 424ms 0ms 18 716 412ms 0ms 19 716 415ms 0ms 20 718 406ms 0ms 21 716 412ms 0ms 22 716 410ms 0ms 23 716 416ms 0ms 00 718 414ms 0ms [ User: symmetricds - Total duration: 9s923ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s923ms - Times executed: 17199 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-22 11:26:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:47:39 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 18:13:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,147 127ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 22 01 380 5ms 0ms 02 380 5ms 0ms 03 381 5ms 0ms 04 380 5ms 0ms 05 380 5ms 0ms 06 381 5ms 0ms 07 380 5ms 0ms 08 380 5ms 0ms 09 380 5ms 0ms 10 381 5ms 0ms 11 380 5ms 0ms 12 380 5ms 0ms 13 381 5ms 0ms 14 380 5ms 0ms 15 380 5ms 0ms 16 381 5ms 0ms 17 380 5ms 0ms 18 380 5ms 0ms 19 380 5ms 0ms 20 381 5ms 0ms 21 388 5ms 0ms 22 392 5ms 0ms 23 380 5ms 0ms 00 381 5ms 0ms [ User: symmetricds - Total duration: 127ms - Times executed: 9147 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 127ms - Times executed: 9147 ]
-
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-09-22 21:54:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 22:58:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,145 172ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 22 01 381 6ms 0ms 02 377 7ms 0ms 03 381 7ms 0ms 04 381 7ms 0ms 05 379 7ms 0ms 06 383 7ms 0ms 07 378 7ms 0ms 08 383 7ms 0ms 09 377 7ms 0ms 10 381 7ms 0ms 11 383 7ms 0ms 12 377 7ms 0ms 13 381 7ms 0ms 14 380 7ms 0ms 15 383 7ms 0ms 16 378 7ms 0ms 17 383 7ms 0ms 18 378 7ms 0ms 19 379 7ms 0ms 20 383 7ms 0ms 21 388 7ms 0ms 22 390 7ms 0ms 23 383 7ms 0ms 00 378 6ms 0ms [ User: symmetricds - Total duration: 172ms - Times executed: 9145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 172ms - Times executed: 9145 ]
-
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-09-22 09:47:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 11:29:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:42:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,599 433ms 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 #13
Day Hour Count Duration Avg duration Sep 22 01 358 17ms 0ms 02 358 17ms 0ms 03 359 18ms 0ms 04 358 17ms 0ms 05 358 17ms 0ms 06 359 17ms 0ms 07 358 17ms 0ms 08 358 17ms 0ms 09 358 17ms 0ms 10 359 18ms 0ms 11 358 19ms 0ms 12 358 18ms 0ms 13 359 17ms 0ms 14 358 18ms 0ms 15 358 18ms 0ms 16 359 18ms 0ms 17 358 18ms 0ms 18 358 18ms 0ms 19 358 18ms 0ms 20 359 18ms 0ms 21 358 18ms 0ms 22 358 18ms 0ms 23 358 17ms 0ms 00 359 18ms 0ms [ User: symmetricds - Total duration: 433ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 433ms - Times executed: 8599 ]
-
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-09-22 10:04:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:37:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 11:27:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,599 339ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 22 01 358 13ms 0ms 02 358 13ms 0ms 03 359 14ms 0ms 04 358 13ms 0ms 05 358 13ms 0ms 06 359 13ms 0ms 07 358 14ms 0ms 08 358 14ms 0ms 09 358 13ms 0ms 10 359 14ms 0ms 11 358 14ms 0ms 12 358 14ms 0ms 13 359 14ms 0ms 14 358 14ms 0ms 15 358 14ms 0ms 16 359 14ms 0ms 17 358 14ms 0ms 18 358 14ms 0ms 19 358 14ms 0ms 20 359 14ms 0ms 21 358 13ms 0ms 22 358 14ms 0ms 23 358 13ms 0ms 00 359 14ms 0ms [ User: symmetricds - Total duration: 339ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 339ms - Times executed: 8599 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-09-22 06:21:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:28:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 02:01:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,599 221ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 22 01 358 9ms 0ms 02 358 9ms 0ms 03 359 9ms 0ms 04 358 9ms 0ms 05 358 9ms 0ms 06 359 9ms 0ms 07 358 9ms 0ms 08 358 9ms 0ms 09 358 9ms 0ms 10 359 9ms 0ms 11 358 9ms 0ms 12 358 9ms 0ms 13 359 9ms 0ms 14 358 9ms 0ms 15 358 9ms 0ms 16 359 9ms 0ms 17 358 9ms 0ms 18 358 9ms 0ms 19 358 9ms 0ms 20 359 9ms 0ms 21 358 9ms 0ms 22 358 9ms 0ms 23 358 9ms 0ms 00 359 9ms 0ms [ User: symmetricds - Total duration: 221ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 221ms - Times executed: 8599 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '107290625' AND data_id <= '157290624' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '107290504' AND data_id <= '157290503' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '107290564' AND data_id <= '157290563' ORDER BY data_id ASC;
Date: 2019-09-22 12:23:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 02:22:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 07:21:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,599 320ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 22 01 358 12ms 0ms 02 358 11ms 0ms 03 359 11ms 0ms 04 358 11ms 0ms 05 358 11ms 0ms 06 359 12ms 0ms 07 358 14ms 0ms 08 358 14ms 0ms 09 358 14ms 0ms 10 359 14ms 0ms 11 358 14ms 0ms 12 358 14ms 0ms 13 359 14ms 0ms 14 358 14ms 0ms 15 358 14ms 0ms 16 359 13ms 0ms 17 358 13ms 0ms 18 358 13ms 0ms 19 358 13ms 0ms 20 359 13ms 0ms 21 358 13ms 0ms 22 358 13ms 0ms 23 358 13ms 0ms 00 359 13ms 0ms [ User: symmetricds - Total duration: 320ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 320ms - Times executed: 8599 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '107290567' AND '157290566'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '107290554' AND '157290553'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '107290845' AND '157290844'));
Date: 2019-09-22 07:37:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 06:31:38 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 21:20:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,582 758ms 0ms 3ms 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 #17
Day Hour Count Duration Avg duration Sep 22 01 272 32ms 0ms 02 282 35ms 0ms 03 285 32ms 0ms 04 274 33ms 0ms 05 257 29ms 0ms 06 253 29ms 0ms 07 264 34ms 0ms 08 264 31ms 0ms 09 271 29ms 0ms 10 268 30ms 0ms 11 271 30ms 0ms 12 283 31ms 0ms 13 280 33ms 0ms 14 282 34ms 0ms 15 269 30ms 0ms 16 280 30ms 0ms 17 267 30ms 0ms 18 283 32ms 0ms 19 284 32ms 0ms 20 274 30ms 0ms 21 267 29ms 0ms 22 288 31ms 0ms 23 288 31ms 0ms 00 276 31ms 0ms [ User: symmetricds - Total duration: 758ms - Times executed: 6582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 758ms - Times executed: 6582 ]
-
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-09-22 06:49:06 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 13:59:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 01:41:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,582 347ms 0ms 1ms 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 #18
Day Hour Count Duration Avg duration Sep 22 01 272 14ms 0ms 02 282 14ms 0ms 03 285 14ms 0ms 04 274 14ms 0ms 05 257 15ms 0ms 06 253 13ms 0ms 07 264 14ms 0ms 08 264 13ms 0ms 09 271 14ms 0ms 10 268 15ms 0ms 11 271 14ms 0ms 12 283 14ms 0ms 13 280 14ms 0ms 14 282 14ms 0ms 15 269 15ms 0ms 16 280 14ms 0ms 17 267 14ms 0ms 18 283 14ms 0ms 19 284 14ms 0ms 20 274 13ms 0ms 21 267 14ms 0ms 22 288 14ms 0ms 23 288 14ms 0ms 00 276 14ms 0ms [ User: symmetricds - Total duration: 347ms - Times executed: 6582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 347ms - Times executed: 6582 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' 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-09-22 09:41:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:27:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:11:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,417 467ms 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 #19
Day Hour Count Duration Avg duration Sep 22 01 184 17ms 0ms 02 184 18ms 0ms 03 184 17ms 0ms 04 184 22ms 0ms 05 184 18ms 0ms 06 184 18ms 0ms 07 184 15ms 0ms 08 184 16ms 0ms 09 184 16ms 0ms 10 184 16ms 0ms 11 184 16ms 0ms 12 184 15ms 0ms 13 184 14ms 0ms 14 184 19ms 0ms 15 184 15ms 0ms 16 184 15ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 36ms 0ms 20 184 32ms 0ms 21 179 29ms 0ms 22 190 22ms 0ms 23 184 18ms 0ms 00 184 20ms 0ms [ User: symmetricds - Total duration: 467ms - Times executed: 4417 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 467ms - Times executed: 4417 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-09-22 20:48:17 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:31:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 21:18:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,738 110ms 0ms 0ms 0ms SET application_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 01 122 4ms 0ms 02 112 4ms 0ms 03 107 4ms 0ms 04 110 4ms 0ms 05 117 4ms 0ms 06 119 4ms 0ms 07 116 4ms 0ms 08 116 4ms 0ms 09 116 4ms 0ms 10 118 4ms 0ms 11 113 4ms 0ms 12 113 4ms 0ms 13 112 4ms 0ms 14 111 4ms 0ms 15 111 4ms 0ms 16 109 4ms 0ms 17 118 4ms 0ms 18 114 4ms 0ms 19 112 4ms 0ms 20 114 4ms 0ms 21 118 4ms 0ms 22 110 4ms 0ms 23 113 4ms 0ms 00 117 4ms 0ms [ User: pharmisight - Total duration: 81ms - Times executed: 2019 ]
[ User: symmetricds - Total duration: 28ms - Times executed: 719 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 110ms - Times executed: 2738 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-09-22 03:51:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 04:31:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:45:25 Duration: 0ms Database: pharmisight User: pharmisight 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 22ms 46ms 34ms 292 10s181ms 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 #1
Day Hour Count Duration Avg duration Sep 22 01 13 411ms 31ms 02 12 411ms 34ms 03 12 433ms 36ms 04 12 413ms 34ms 05 12 414ms 34ms 06 12 427ms 35ms 07 13 466ms 35ms 08 12 457ms 38ms 09 12 414ms 34ms 10 12 436ms 36ms 11 12 432ms 36ms 12 12 412ms 34ms 13 13 458ms 35ms 14 12 413ms 34ms 15 12 411ms 34ms 16 12 421ms 35ms 17 12 412ms 34ms 18 12 418ms 34ms 19 13 452ms 34ms 20 12 405ms 33ms 21 12 430ms 35ms 22 12 396ms 33ms 23 12 421ms 35ms 00 12 405ms 33ms [ User: librenms - Total duration: 10s181ms - Times executed: 292 ]
[ Application: psql - Total duration: 10s181ms - 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-09-22 09:50:12 Duration: 46ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-22 05:50:12 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
Date: 2019-09-22 07:20:11 Duration: 45ms Database: postgres User: librenms Remote: [local] Application: psql
2 4ms 13ms 6ms 197 1s291ms 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 #2
Day Hour Count Duration Avg duration Sep 22 01 149 973ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 12ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 14ms 7ms 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 3 18ms 6ms 22 3 17ms 5ms 23 2 13ms 6ms 00 2 13ms 6ms [ User: symmetricds - Total duration: 769ms - Times executed: 107 ]
[ User: pharmisight - Total duration: 522ms - Times executed: 90 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s291ms - Times executed: 197 ]
-
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;
-
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-09-22 00:30:27 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:00:01 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:27 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 16ms 5ms 190 1s136ms 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 #3
Day Hour Count Duration Avg duration Sep 22 01 8 39ms 4ms 02 8 42ms 5ms 03 8 43ms 5ms 04 8 46ms 5ms 05 8 50ms 6ms 06 8 57ms 7ms 07 8 64ms 8ms 08 8 51ms 6ms 09 8 49ms 6ms 10 8 45ms 5ms 11 8 54ms 6ms 12 8 31ms 3ms 13 8 56ms 7ms 14 8 51ms 6ms 15 8 48ms 6ms 16 8 33ms 4ms 17 8 49ms 6ms 18 8 39ms 4ms 19 8 48ms 6ms 20 8 50ms 6ms 21 6 41ms 6ms 22 8 46ms 5ms 23 8 44ms 5ms 00 8 50ms 6ms [ User: symmetricds - Total duration: 1s136ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s136ms - Times executed: 190 ]
-
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" = '883739280', "total_memory_bytes" = '1489502208', "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-09-22 06:11:01', "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" = '99535128', "total_memory_bytes" = '264765440', "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-09-22 19:35:36', "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';
-
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" = '77054272', "total_memory_bytes" = '276299776', "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-09-22 10:20:36', "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-09-22 06:11:32 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:37:36 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:22:33 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 9ms 5ms 96 533ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 22 01 4 19ms 4ms 02 4 22ms 5ms 03 4 21ms 5ms 04 4 16ms 4ms 05 4 26ms 6ms 06 4 19ms 4ms 07 4 16ms 4ms 08 4 17ms 4ms 09 4 23ms 5ms 10 4 29ms 7ms 11 4 25ms 6ms 12 4 25ms 6ms 13 4 26ms 6ms 14 4 27ms 6ms 15 4 23ms 5ms 16 4 27ms 6ms 17 4 30ms 7ms 18 4 31ms 7ms 19 4 23ms 5ms 20 4 20ms 5ms 21 4 23ms 5ms 22 4 7ms 1ms 23 4 17ms 4ms 00 4 10ms 2ms [ User: symmetricds - Total duration: 533ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 533ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '30340720', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 19:17:25', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '52250784', total_memory_bytes = '265814016', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 17:17:24', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-9-amd64', available_processors = '3', free_memory_bytes = '72171464', total_memory_bytes = '264241152', max_memory_bytes = '1908932608', java_version = '1.8.0_222', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-09-22 05:17:23', last_restart_time = '2019-07-30 12:19:56.988' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-09-22 19:17:25 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 17:17:24 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 05:17:23 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 11ms 4ms 155 661ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 22 01 5 18ms 3ms 02 6 26ms 4ms 03 5 24ms 4ms 04 6 27ms 4ms 05 6 22ms 3ms 06 5 20ms 4ms 07 5 21ms 4ms 08 5 22ms 4ms 09 6 25ms 4ms 10 6 24ms 4ms 11 7 29ms 4ms 12 7 26ms 3ms 13 6 26ms 4ms 14 6 25ms 4ms 15 7 31ms 4ms 16 6 19ms 3ms 17 6 24ms 4ms 18 6 28ms 4ms 19 7 30ms 4ms 20 7 41ms 5ms 21 12 50ms 4ms 22 11 37ms 3ms 23 6 28ms 4ms 00 6 27ms 4ms [ User: symmetricds - Total duration: 661ms - Times executed: 155 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 661ms - Times executed: 155 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-09-22 19:03:16 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:18:16 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 22:18:19 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 2ms 1ms 705 1s45ms 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 #6
Day Hour Count Duration Avg duration Sep 22 01 28 38ms 1ms 02 27 38ms 1ms 03 26 39ms 1ms 04 25 35ms 1ms 05 33 52ms 1ms 06 33 51ms 1ms 07 32 49ms 1ms 08 30 46ms 1ms 09 31 46ms 1ms 10 32 49ms 1ms 11 30 45ms 1ms 12 29 44ms 1ms 13 28 41ms 1ms 14 27 38ms 1ms 15 28 41ms 1ms 16 25 35ms 1ms 17 33 48ms 1ms 18 30 42ms 1ms 19 28 41ms 1ms 20 30 43ms 1ms 21 32 44ms 1ms 22 27 39ms 1ms 23 29 41ms 1ms 00 32 47ms 1ms [ User: symmetricds - Total duration: 1s45ms - Times executed: 705 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s45ms - Times executed: 705 ]
-
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-09-22 06:43:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 23:39:19 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 23:59:20 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 7ms 0ms 936 934ms 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 #7
Day Hour Count Duration Avg duration Sep 22 01 40 39ms 0ms 02 33 32ms 0ms 03 33 32ms 0ms 04 32 30ms 0ms 05 43 40ms 0ms 06 48 47ms 0ms 07 42 41ms 0ms 08 40 40ms 1ms 09 44 40ms 0ms 10 43 43ms 1ms 11 39 41ms 1ms 12 40 38ms 0ms 13 38 47ms 1ms 14 33 32ms 0ms 15 37 36ms 0ms 16 33 33ms 1ms 17 44 46ms 1ms 18 39 39ms 1ms 19 37 36ms 0ms 20 40 37ms 0ms 21 43 42ms 0ms 22 38 37ms 0ms 23 37 36ms 0ms 00 40 38ms 0ms [ User: symmetricds - Total duration: 934ms - Times executed: 936 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 934ms - Times executed: 936 ]
-
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-09-22 12:39:11 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:57:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:07:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 4ms 0ms 688 647ms 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 #8
Day Hour Count Duration Avg duration Sep 22 01 28 26ms 0ms 02 27 24ms 0ms 03 26 24ms 0ms 04 25 22ms 0ms 05 27 26ms 0ms 06 30 30ms 1ms 07 30 26ms 0ms 08 27 26ms 0ms 09 29 26ms 0ms 10 33 34ms 1ms 11 29 27ms 0ms 12 29 26ms 0ms 13 27 27ms 1ms 14 27 23ms 0ms 15 28 26ms 0ms 16 25 22ms 0ms 17 33 31ms 0ms 18 30 27ms 0ms 19 28 25ms 0ms 20 30 27ms 0ms 21 32 30ms 0ms 22 27 25ms 0ms 23 29 26ms 0ms 00 32 28ms 0ms [ User: symmetricds - Total duration: 647ms - Times executed: 688 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 647ms - Times executed: 688 ]
-
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-09-22 09:05:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:45:04 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:05:08 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 3ms 0ms 667 590ms 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 #9
Day Hour Count Duration Avg duration Sep 22 01 28 26ms 0ms 02 27 23ms 0ms 03 26 23ms 0ms 04 24 21ms 0ms 05 25 23ms 0ms 06 26 23ms 0ms 07 26 21ms 0ms 08 24 21ms 0ms 09 28 23ms 0ms 10 31 29ms 0ms 11 28 24ms 0ms 12 29 25ms 0ms 13 26 23ms 0ms 14 27 23ms 0ms 15 28 25ms 0ms 16 25 21ms 0ms 17 32 28ms 0ms 18 30 26ms 0ms 19 28 24ms 0ms 20 30 25ms 0ms 21 32 27ms 0ms 22 27 23ms 0ms 23 29 24ms 0ms 00 31 25ms 0ms [ User: symmetricds - Total duration: 590ms - Times executed: 667 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 590ms - Times executed: 667 ]
-
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-09-22 09:31:08 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:41:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 11:29:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 17,199 9s923ms 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 Sep 22 01 717 409ms 0ms 02 716 413ms 0ms 03 718 419ms 0ms 04 716 415ms 0ms 05 716 416ms 0ms 06 718 409ms 0ms 07 716 419ms 0ms 08 716 414ms 0ms 09 716 409ms 0ms 10 718 414ms 0ms 11 716 407ms 0ms 12 716 417ms 0ms 13 718 408ms 0ms 14 716 414ms 0ms 15 716 410ms 0ms 16 718 409ms 0ms 17 716 424ms 0ms 18 716 412ms 0ms 19 716 415ms 0ms 20 718 406ms 0ms 21 716 412ms 0ms 22 716 410ms 0ms 23 716 416ms 0ms 00 718 414ms 0ms [ User: symmetricds - Total duration: 9s923ms - Times executed: 17199 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s923ms - Times executed: 17199 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-09-22 11:26:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:47:39 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 18:13:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 3ms 0ms 6,582 758ms 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 #11
Day Hour Count Duration Avg duration Sep 22 01 272 32ms 0ms 02 282 35ms 0ms 03 285 32ms 0ms 04 274 33ms 0ms 05 257 29ms 0ms 06 253 29ms 0ms 07 264 34ms 0ms 08 264 31ms 0ms 09 271 29ms 0ms 10 268 30ms 0ms 11 271 30ms 0ms 12 283 31ms 0ms 13 280 33ms 0ms 14 282 34ms 0ms 15 269 30ms 0ms 16 280 30ms 0ms 17 267 30ms 0ms 18 283 32ms 0ms 19 284 32ms 0ms 20 274 30ms 0ms 21 267 29ms 0ms 22 288 31ms 0ms 23 288 31ms 0ms 00 276 31ms 0ms [ User: symmetricds - Total duration: 758ms - Times executed: 6582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 758ms - Times executed: 6582 ]
-
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-09-22 06:49:06 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 13:59:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 01:41:02 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 11ms 0ms 4,417 467ms 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 #12
Day Hour Count Duration Avg duration Sep 22 01 184 17ms 0ms 02 184 18ms 0ms 03 184 17ms 0ms 04 184 22ms 0ms 05 184 18ms 0ms 06 184 18ms 0ms 07 184 15ms 0ms 08 184 16ms 0ms 09 184 16ms 0ms 10 184 16ms 0ms 11 184 16ms 0ms 12 184 15ms 0ms 13 184 14ms 0ms 14 184 19ms 0ms 15 184 15ms 0ms 16 184 15ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 36ms 0ms 20 184 32ms 0ms 21 179 29ms 0ms 22 190 22ms 0ms 23 184 18ms 0ms 00 184 20ms 0ms [ User: symmetricds - Total duration: 467ms - Times executed: 4417 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 467ms - Times executed: 4417 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-09-22 20:48:17 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:31:03 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 21:18:18 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 0ms 0ms 17,304 979ms 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 #13
Day Hour Count Duration Avg duration Sep 22 01 720 39ms 0ms 02 720 40ms 0ms 03 722 40ms 0ms 04 720 40ms 0ms 05 720 40ms 0ms 06 722 40ms 0ms 07 720 40ms 0ms 08 720 40ms 0ms 09 720 40ms 0ms 10 722 41ms 0ms 11 720 40ms 0ms 12 720 41ms 0ms 13 722 40ms 0ms 14 720 41ms 0ms 15 720 40ms 0ms 16 722 41ms 0ms 17 720 41ms 0ms 18 720 40ms 0ms 19 720 40ms 0ms 20 722 40ms 0ms 21 724 40ms 0ms 22 726 41ms 0ms 23 720 40ms 0ms 00 722 40ms 0ms [ User: symmetricds - Total duration: 979ms - Times executed: 17304 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 979ms - Times executed: 17304 ]
-
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 = '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';
Date: 2019-09-22 06:47:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:20:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 09:37:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 3ms 0ms 25,149 1s385ms 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 #14
Day Hour Count Duration Avg duration Sep 22 01 1,118 60ms 0ms 02 1,044 55ms 0ms 03 1,046 55ms 0ms 04 1,044 62ms 0ms 05 1,044 55ms 0ms 06 1,046 55ms 0ms 07 1,044 58ms 0ms 08 1,044 55ms 0ms 09 1,044 58ms 0ms 10 1,046 55ms 0ms 11 1,044 55ms 0ms 12 1,044 58ms 0ms 13 1,046 56ms 0ms 14 1,044 53ms 0ms 15 1,044 59ms 0ms 16 1,046 56ms 0ms 17 1,044 58ms 0ms 18 1,044 61ms 0ms 19 1,044 63ms 0ms 20 1,046 56ms 0ms 21 1,039 55ms 0ms 22 1,054 54ms 0ms 23 1,044 63ms 0ms 00 1,046 59ms 0ms [ User: symmetricds - Total duration: 1s385ms - Times executed: 25149 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s385ms - Times executed: 25149 ]
-
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-09-22 18:03:15 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:02:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 03:10:02 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 22,925 1s218ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 22 01 1,834 89ms 0ms 02 917 37ms 0ms 03 917 34ms 0ms 04 917 60ms 0ms 05 917 51ms 0ms 06 917 53ms 0ms 07 917 33ms 0ms 08 917 55ms 0ms 09 917 52ms 0ms 10 917 52ms 0ms 11 917 51ms 0ms 12 917 53ms 0ms 13 917 52ms 0ms 14 917 51ms 0ms 15 917 52ms 0ms 16 917 41ms 0ms 17 917 51ms 0ms 18 917 54ms 0ms 19 917 51ms 0ms 20 917 53ms 0ms 21 917 54ms 0ms 22 917 25ms 0ms 23 917 52ms 0ms 00 917 51ms 0ms [ User: pharmisight - Total duration: 1s218ms - Times executed: 22925 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s218ms - Times executed: 22925 ]
-
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 = '3285' 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 = '3031' 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 = '3464' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-09-22 09:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 6,582 347ms 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 #16
Day Hour Count Duration Avg duration Sep 22 01 272 14ms 0ms 02 282 14ms 0ms 03 285 14ms 0ms 04 274 14ms 0ms 05 257 15ms 0ms 06 253 13ms 0ms 07 264 14ms 0ms 08 264 13ms 0ms 09 271 14ms 0ms 10 268 15ms 0ms 11 271 14ms 0ms 12 283 14ms 0ms 13 280 14ms 0ms 14 282 14ms 0ms 15 269 15ms 0ms 16 280 14ms 0ms 17 267 14ms 0ms 18 283 14ms 0ms 19 284 14ms 0ms 20 274 13ms 0ms 21 267 14ms 0ms 22 288 14ms 0ms 23 288 14ms 0ms 00 276 14ms 0ms [ User: symmetricds - Total duration: 347ms - Times executed: 6582 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 347ms - Times executed: 6582 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' 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-09-22 09:41:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 14:27:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:11:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 25,850 1s357ms 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 #17
Day Hour Count Duration Avg duration Sep 22 01 2,068 103ms 0ms 02 1,034 40ms 0ms 03 1,034 38ms 0ms 04 1,034 68ms 0ms 05 1,034 57ms 0ms 06 1,034 58ms 0ms 07 1,034 37ms 0ms 08 1,034 61ms 0ms 09 1,034 58ms 0ms 10 1,034 57ms 0ms 11 1,034 57ms 0ms 12 1,034 60ms 0ms 13 1,034 57ms 0ms 14 1,034 56ms 0ms 15 1,034 57ms 0ms 16 1,034 44ms 0ms 17 1,034 57ms 0ms 18 1,034 60ms 0ms 19 1,034 56ms 0ms 20 1,034 59ms 0ms 21 1,034 61ms 0ms 22 1,034 28ms 0ms 23 1,034 58ms 0ms 00 1,034 57ms 0ms [ User: pharmisight - Total duration: 1s357ms - Times executed: 25850 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s357ms - Times executed: 25850 ]
-
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 = '3660' 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 = '3066' 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 = '3074' ORDER BY itemcodes0_.code ASC;
Date: 2019-09-22 11:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 00:30:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 8,599 433ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 22 01 358 17ms 0ms 02 358 17ms 0ms 03 359 18ms 0ms 04 358 17ms 0ms 05 358 17ms 0ms 06 359 17ms 0ms 07 358 17ms 0ms 08 358 17ms 0ms 09 358 17ms 0ms 10 359 18ms 0ms 11 358 19ms 0ms 12 358 18ms 0ms 13 359 17ms 0ms 14 358 18ms 0ms 15 358 18ms 0ms 16 359 18ms 0ms 17 358 18ms 0ms 18 358 18ms 0ms 19 358 18ms 0ms 20 359 18ms 0ms 21 358 18ms 0ms 22 358 18ms 0ms 23 358 17ms 0ms 00 359 18ms 0ms [ User: symmetricds - Total duration: 433ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 433ms - Times executed: 8599 ]
-
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-09-22 10:04:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 10:37:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 11:27:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 2,738 110ms SET application_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 22 01 122 4ms 0ms 02 112 4ms 0ms 03 107 4ms 0ms 04 110 4ms 0ms 05 117 4ms 0ms 06 119 4ms 0ms 07 116 4ms 0ms 08 116 4ms 0ms 09 116 4ms 0ms 10 118 4ms 0ms 11 113 4ms 0ms 12 113 4ms 0ms 13 112 4ms 0ms 14 111 4ms 0ms 15 111 4ms 0ms 16 109 4ms 0ms 17 118 4ms 0ms 18 114 4ms 0ms 19 112 4ms 0ms 20 114 4ms 0ms 21 118 4ms 0ms 22 110 4ms 0ms 23 113 4ms 0ms 00 117 4ms 0ms [ User: pharmisight - Total duration: 81ms - Times executed: 2019 ]
[ User: symmetricds - Total duration: 28ms - Times executed: 719 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 110ms - Times executed: 2738 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-09-22 03:51:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 04:31:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 15:45:25 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,599 339ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 22 01 358 13ms 0ms 02 358 13ms 0ms 03 359 14ms 0ms 04 358 13ms 0ms 05 358 13ms 0ms 06 359 13ms 0ms 07 358 14ms 0ms 08 358 14ms 0ms 09 358 13ms 0ms 10 359 14ms 0ms 11 358 14ms 0ms 12 358 14ms 0ms 13 359 14ms 0ms 14 358 14ms 0ms 15 358 14ms 0ms 16 359 14ms 0ms 17 358 14ms 0ms 18 358 14ms 0ms 19 358 14ms 0ms 20 359 14ms 0ms 21 358 13ms 0ms 22 358 14ms 0ms 23 358 13ms 0ms 00 359 14ms 0ms [ User: symmetricds - Total duration: 339ms - Times executed: 8599 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 339ms - Times executed: 8599 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-09-22 06:21:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 19:28:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-09-22 02:01:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,165,681 Log entries
Events distribution
Key values
- 0 PANIC entries
- 4 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 22 20 1 21 1 22 1 - FATAL: no pg_hba.conf entry for host "51.255.70.118", user "postgres", database "postgres", SSL off
- FATAL: no pg_hba.conf entry for host "34.235.117.161", user "a", database "a", SSL off
- FATAL: no pg_hba.conf entry for host "122.228.19.79", user "root", database "root", SSL off
Date: 2019-09-22 21:36:24 Database: postgres Application: [unknown] User: postgres Remote: 51.255.70.118 Code:
Date: 2019-09-22 19:03:36 Database: a Application: [unknown] User: a Remote: 34.235.117.161 Code:
Date: 2019-09-22 20:25:00 Database: root Application: [unknown] User: root Remote: 122.228.19.79 Code:
2 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 22 22 1 - FATAL: no pg_hba.conf entry for host "51.255.70.118", user "postgres", database "postgres", SSL on
Date: 2019-09-22 21:36:23 Database: postgres Application: [unknown] User: postgres Remote: 51.255.70.118 Code: