pgBadger-
Global information
- Generated on Sun Feb 10 00:00:25 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,484,213 log entries in 23s
- Log start from 2019-02-09 00:00:00 to 2019-02-09 23:59:56
-
Overview
Global Stats
- 174 Number of unique normalized queries
- 1,205,137 Number of queries
- 55s355ms Total query duration
- 2019-02-09 00:00:00 First query
- 2019-02-09 23:59:56 Last query
- 1,914 queries/s at 2019-02-09 20:40:00 Query peak
- 7 Number of events
- 3 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 55 Total number of automatic vacuums
- 78 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,681 Total number of sessions
- 1 sessions at 2019-02-09 15:34:53 Session peak
- 10d38m42s Total duration of sessions
- 8m35s Average duration of sessions
- 716 Average queries per session
- 32ms Average queries duration per session
- 1,681 Total number of connections
- 6 connections/s at 2019-02-09 00:30:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,914 queries/s Query Peak
- 2019-02-09 20:40:00 Date
SELECT Traffic
Key values
- 1,904 queries/s Query Peak
- 2019-02-09 20:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 516 queries/s Query Peak
- 2019-02-09 00:00:07 Date
Queries duration
Key values
- 55s355ms Total query duration
Prepared queries ratio
Key values
- 1.61 Ratio of bind vs prepare
- 170.07 % 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) Feb 09 00 58,621 0ms 74ms 0ms 73ms 267ms 1s126ms 01 50,525 0ms 68ms 0ms 50ms 112ms 354ms 02 51,829 0ms 71ms 0ms 53ms 182ms 388ms 03 52,026 0ms 70ms 0ms 54ms 196ms 385ms 04 50,988 0ms 67ms 0ms 53ms 142ms 408ms 05 50,257 0ms 68ms 0ms 57ms 78ms 335ms 06 49,301 0ms 71ms 0ms 53ms 62ms 428ms 07 49,712 0ms 135ms 0ms 54ms 61ms 526ms 08 49,649 0ms 59ms 0ms 47ms 55ms 244ms 09 49,508 0ms 112ms 0ms 50ms 62ms 482ms 10 49,370 0ms 86ms 0ms 54ms 58ms 412ms 11 49,199 0ms 84ms 0ms 42ms 58ms 387ms 12 49,311 0ms 75ms 0ms 48ms 56ms 303ms 13 49,338 0ms 72ms 0ms 51ms 76ms 220ms 14 49,282 0ms 53ms 0ms 51ms 62ms 165ms 15 49,438 0ms 52ms 0ms 50ms 72ms 145ms 16 49,478 0ms 42ms 0ms 56ms 71ms 138ms 17 49,395 0ms 32ms 0ms 63ms 77ms 144ms 18 49,507 0ms 44ms 0ms 51ms 57ms 137ms 19 49,613 0ms 21ms 0ms 55ms 72ms 139ms 20 50,305 0ms 26ms 0ms 51ms 78ms 369ms 21 49,535 0ms 34ms 0ms 54ms 68ms 138ms 22 49,442 0ms 28ms 0ms 52ms 81ms 144ms 23 49,508 0ms 31ms 0ms 57ms 82ms 143ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 09 00 19,790 0 0ms 25ms 41ms 381ms 01 16,329 0 0ms 24ms 32ms 140ms 02 16,507 0 0ms 22ms 34ms 119ms 03 16,544 0 0ms 23ms 34ms 133ms 04 16,399 0 0ms 22ms 34ms 147ms 05 16,248 0 0ms 22ms 37ms 138ms 06 15,997 0 0ms 23ms 34ms 112ms 07 16,047 0 0ms 22ms 34ms 107ms 08 16,042 0 0ms 27ms 30ms 87ms 09 15,984 0 0ms 24ms 34ms 88ms 10 15,932 0 0ms 22ms 35ms 65ms 11 15,916 0 0ms 23ms 31ms 73ms 12 15,942 0 0ms 23ms 34ms 63ms 13 15,947 0 0ms 22ms 32ms 52ms 14 15,943 0 0ms 22ms 29ms 43ms 15 15,975 0 0ms 22ms 31ms 49ms 16 15,987 0 0ms 22ms 34ms 49ms 17 15,963 0 0ms 23ms 35ms 54ms 18 16,005 0 0ms 25ms 31ms 37ms 19 16,042 0 0ms 22ms 28ms 51ms 20 16,681 0 0ms 24ms 32ms 75ms 21 16,005 0 0ms 23ms 31ms 44ms 22 15,963 0 0ms 23ms 32ms 57ms 23 16,000 0 0ms 22ms 32ms 58ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 09 00 2,102 1,353 111 0 0ms 10ms 15ms 127ms 01 596 204 105 0 0ms 1ms 7ms 33ms 02 1,152 340 111 0 0ms 1ms 7ms 60ms 03 1,304 378 109 0 0ms 1ms 7ms 60ms 04 572 195 105 0 0ms 1ms 6ms 37ms 05 123 82 109 0 1ms 1ms 6ms 9ms 06 88 54 105 0 1ms 1ms 6ms 8ms 07 88 54 95 0 2ms 1ms 5ms 8ms 08 88 53 97 0 1ms 1ms 4ms 7ms 09 88 54 89 0 2ms 1ms 3ms 7ms 10 88 53 91 0 1ms 1ms 3ms 7ms 11 83 53 90 0 1ms 0ms 3ms 7ms 12 87 52 89 0 1ms 0ms 2ms 7ms 13 88 52 86 0 1ms 1ms 2ms 7ms 14 88 54 84 0 0ms 1ms 2ms 7ms 15 88 52 83 0 0ms 1ms 5ms 8ms 16 88 52 83 0 0ms 1ms 3ms 8ms 17 88 52 81 0 0ms 1ms 3ms 8ms 18 88 53 81 0 0ms 1ms 3ms 7ms 19 89 66 81 0 0ms 1ms 2ms 8ms 20 109 72 100 0 0ms 1ms 3ms 8ms 21 88 52 80 0 0ms 1ms 5ms 8ms 22 88 52 81 0 0ms 1ms 2ms 8ms 23 88 50 81 0 0ms 0ms 2ms 9ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Feb 09 00 36,033 58,585 1.63 96.21% 01 32,343 50,489 1.56 108.29% 02 31,246 51,793 1.66 101.05% 03 31,036 51,990 1.68 99.65% 04 31,482 50,952 1.62 104.67% 05 31,267 50,221 1.61 106.50% 06 31,706 49,265 1.55 110.24% 07 30,936 49,676 1.61 106.83% 08 30,924 49,613 1.60 106.90% 09 30,674 49,472 1.61 106.36% 10 30,179 49,334 1.63 104.96% 11 30,648 49,163 1.60 106.93% 12 30,719 49,275 1.60 106.96% 13 30,559 49,302 1.61 106.35% 14 30,912 49,246 1.59 107.66% 15 30,792 49,402 1.60 106.92% 16 30,920 49,442 1.60 107.32% 17 30,660 49,359 1.61 106.56% 18 30,993 49,471 1.60 107.48% 19 30,696 49,577 1.62 106.16% 20 30,949 50,269 1.62 104.51% 21 30,911 49,499 1.60 107.14% 22 30,371 49,406 1.63 105.47% 23 30,767 49,472 1.61 106.71% Day Hour Count Average / Second Feb 09 00 109 0.03/s 01 88 0.02/s 02 65 0.02/s 03 59 0.02/s 04 71 0.02/s 05 67 0.02/s 06 81 0.02/s 07 67 0.02/s 08 66 0.02/s 09 64 0.02/s 10 63 0.02/s 11 69 0.02/s 12 71 0.02/s 13 71 0.02/s 14 72 0.02/s 15 68 0.02/s 16 69 0.02/s 17 67 0.02/s 18 71 0.02/s 19 64 0.02/s 20 66 0.02/s 21 66 0.02/s 22 60 0.02/s 23 67 0.02/s Day Hour Count Average Duration Feb 09 00 109 5m44s 01 88 6m48s 02 65 9m6s 03 59 9m53s 04 71 8m40s 05 67 9m1s 06 81 7m13s 07 67 9m14s 08 66 8m40s 09 64 9m41s 10 63 9m40s 11 69 8m31s 12 71 8m31s 13 71 8m28s 14 72 8m20s 15 68 8m18s 16 69 9m19s 17 67 8m46s 18 71 8m39s 19 64 9m3s 20 66 9m32s 21 66 8m50s 22 60 9m55s 23 67 9m9s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2019-02-09 00:30:27 Date
Connections per database
Key values
- pharmisight Main Database
- 1,681 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,681 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-02-09 15:34:53 Date
Histogram of session times
Key values
- 887 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,681 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,681 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,681 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 3,133 buffers Checkpoint Peak
- 2019-02-09 06:02:40 Date
- 149.793 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2019-02-09 06:02:40 Date
Checkpoints distance
Key values
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Feb 09 00 1,700 170.415s 0.015s 170.49s 01 771 77.336s 0.019s 77.41s 02 1,178 118.283s 0.03s 118.378s 03 863 86.593s 0.009s 86.658s 04 645 64.596s 0.013s 64.664s 05 437 43.84s 0.013s 43.907s 06 4,514 288.143s 0.008s 288.206s 07 4,434 314.955s 0.026s 315.014s 08 1,156 115.949s 0.01s 115.998s 09 2,005 201.214s 0.012s 201.271s 10 915 91.77s 0.008s 91.822s 11 2,084 208.145s 0.008s 208.198s 12 1,814 181.206s 0.012s 181.265s 13 1,397 140.13s 0.007s 140.179s 14 1,363 136.628s 0.007s 136.675s 15 906 90.654s 0.008s 90.706s 16 1,022 102.395s 0.01s 102.454s 17 444 44.539s 0.008s 44.586s 18 700 70.121s 0.012s 70.18s 19 538 53.881s 0.016s 53.937s 20 398 39.926s 0.013s 39.976s 21 526 52.769s 0.015s 52.843s 22 697 69.924s 0.01s 69.982s 23 472 47.251s 0.009s 47.301s Day Hour Added Removed Recycled Synced files Longest sync Average sync Feb 09 00 0 0 0 326 0.008s 0s 01 0 0 1 273 0.008s 0s 02 0 0 0 308 0.016s 0s 03 0 0 0 284 0.002s 0s 04 0 0 0 263 0.002s 0s 05 0 0 0 244 0.003s 0s 06 0 0 2 174 0.002s 0s 07 0 0 2 178 0.018s 0s 08 0 0 0 220 0.005s 0s 09 0 0 1 241 0.002s 0s 10 0 0 0 215 0.002s 0s 11 0 0 1 217 0.001s 0s 12 0 0 0 227 0.002s 0s 13 0 0 1 226 0.001s 0s 14 0 0 0 232 0.001s 0s 15 0 0 1 231 0.002s 0s 16 0 0 0 233 0.002s 0s 17 0 0 0 210 0.002s 0s 18 0 0 0 236 0.002s 0s 19 0 0 0 225 0.008s 0s 20 0 0 0 232 0.002s 0s 21 0 0 0 220 0.003s 0.001s 22 0 0 0 228 0.002s 0s 23 0 0 0 204 0.002s 0s Day Hour Count Avg time (sec) Feb 09 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 Feb 09 00 879.80 kB 1,430.80 kB 01 366.10 kB 891.20 kB 02 634.70 kB 1,502.10 kB 03 436.30 kB 908.70 kB 04 311.60 kB 722.30 kB 05 187.40 kB 500.30 kB 06 4,822.00 kB 15,094.67 kB 07 4,691.50 kB 14,408.17 kB 08 843.00 kB 7,527.38 kB 09 1,331.88 kB 3,985.88 kB 10 634.12 kB 2,678.38 kB 11 1,212.75 kB 3,866.62 kB 12 1,127.75 kB 3,950.75 kB 13 869.12 kB 2,833.75 kB 14 578.12 kB 2,031.38 kB 15 690.38 kB 2,317.50 kB 16 578.12 kB 1,667.25 kB 17 187.00 kB 846.25 kB 18 240.44 kB 624.44 kB 19 153.43 kB 504.57 kB 20 117.29 kB 307.57 kB 21 138.88 kB 311.12 kB 22 214.50 kB 574.25 kB 23 114.86 kB 548.86 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 Feb 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (16) Main table analyzed (database pharmisight)
- 78 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 16 pharmisight.public.sym_data 15 pharmisight.public.sym_data_event 14 pharmisight.public.sym_data_gap 12 pharmisight.public.sym_incoming_batch 10 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 3 pharmisight.public.sym_sequence 1 pharmisight.public.flow_report_summary_months 1 Total 78 Vacuums per table
Key values
- public.sym_outgoing_batch (11) Main table vacuumed on database pharmisight
- 55 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 11 11 pharmisight.public.sym_data 11 11 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 5 5 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.public.item_codes 1 1 Total 55 48 Tuples removed per table
Key values
- public.sym_data_event (27643) Main table with removed tuples on database pharmisight
- 57120 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 27643 1163 pharmisight.public.sym_data 11 11 22234 2758 pharmisight.public.sym_outgoing_batch 11 11 4320 41 pharmisight.public.sym_incoming_batch 5 5 1271 0 pharmisight.pg_catalog.pg_statistic 2 2 555 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.item_codes 1 1 275 0 pharmisight.pg_toast.pg_toast_2619 2 2 152 0 pharmisight.public.sym_sequence 1 0 51 0 Total 55 48 57,120 3,962 Pages removed per table
Key values
- public.sym_data (2758) Main table with removed pages on database pharmisight
- 3962 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 11 11 22234 2758 pharmisight.public.sym_data_event 10 10 27643 1163 pharmisight.public.sym_outgoing_batch 11 11 4320 41 pharmisight.pg_catalog.pg_statistic 2 2 555 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_node_host 6 0 313 0 pharmisight.pg_toast.pg_toast_2619 2 2 152 0 pharmisight.public.item_codes 1 1 275 0 pharmisight.public.sym_incoming_batch 5 5 1271 0 Total 55 48 57,120 3,962 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Feb 09 00 1 4 01 1 2 02 2 4 03 0 0 04 1 2 05 1 0 06 2 3 07 4 3 08 1 5 09 6 3 10 1 4 11 3 5 12 4 5 13 6 4 14 4 4 15 3 4 16 4 4 17 1 2 18 4 4 19 1 4 20 0 1 21 1 3 22 4 3 23 0 5 - 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
- 390,188 Total read queries
- 317,922 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,205,137 Requests
- 55s355ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,200,042 Requests
User Request type Count Duration pharmisight Total 55,488 4s437ms DELETE 18 2ms INSERT 1,530 821ms OTHERS 1,995 75ms SELECT 51,346 3s464ms TCL 564 68ms UPDATE 35 4ms symmetricds Total 1,200,042 53s101ms DELETE 2,280 3s977ms INSERT 7,102 874ms OTHERS 515,667 7s885ms SELECT 354,383 32s31ms TCL 316,754 5s728ms UPDATE 3,856 2s603ms tony Total 900 250ms SELECT 900 250ms Duration by user
Key values
- 53s101ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 55,488 4s437ms DELETE 18 2ms INSERT 1,530 821ms OTHERS 1,995 75ms SELECT 51,346 3s464ms TCL 564 68ms UPDATE 35 4ms symmetricds Total 1,200,042 53s101ms DELETE 2,280 3s977ms INSERT 7,102 874ms OTHERS 515,667 7s885ms SELECT 354,383 32s31ms TCL 316,754 5s728ms UPDATE 3,856 2s603ms tony Total 900 250ms SELECT 900 250ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,255,530 Requests
- 57s538ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,202,880 Requests
- 55s59ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-02-09 19:25:52 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,201,990 0-1ms duration
Slowest individual queries
Rank Duration Query 1 135ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN $1 AND $2 AND status != $3) AND batch_id BETWEEN $4 AND $5;[ Date: 2019-02-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 112ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 86ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 84ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 75ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 74ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 72ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 71ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 71ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 70ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 68ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 68ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 67ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 59ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 56ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 53ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-02-09 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 53ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 52ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 49ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 44ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-02-09 18:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 14s26ms 25,780 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 09 00 1,075 594ms 0ms 01 1,071 595ms 0ms 02 1,074 593ms 0ms 03 1,076 586ms 0ms 04 1,075 593ms 0ms 05 1,074 598ms 0ms 06 1,071 590ms 0ms 07 1,077 588ms 0ms 08 1,074 577ms 0ms 09 1,074 592ms 0ms 10 1,074 576ms 0ms 11 1,074 586ms 0ms 12 1,074 573ms 0ms 13 1,074 573ms 0ms 14 1,074 575ms 0ms 15 1,074 572ms 0ms 16 1,077 580ms 0ms 17 1,074 598ms 0ms 18 1,074 578ms 0ms 19 1,074 581ms 0ms 20 1,074 579ms 0ms 21 1,074 583ms 0ms 22 1,074 582ms 0ms 23 1,074 573ms 0ms [ User: symmetricds - Total duration: 14s26ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s26ms - Times executed: 25780 ]
-
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-02-09 17:41:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:46:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:02:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s293ms 475,855 0ms 2ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 09 00 20,188 307ms 0ms 01 19,728 299ms 0ms 02 20,016 307ms 0ms 03 20,006 306ms 0ms 04 20,007 306ms 0ms 05 20,004 308ms 0ms 06 19,644 301ms 0ms 07 19,884 305ms 0ms 08 19,851 307ms 0ms 09 19,807 306ms 0ms 10 19,756 299ms 0ms 11 19,663 304ms 0ms 12 19,712 299ms 0ms 13 19,723 305ms 0ms 14 19,689 304ms 0ms 15 19,771 298ms 0ms 16 19,789 299ms 0ms 17 19,756 307ms 0ms 18 19,792 304ms 0ms 19 19,833 302ms 0ms 20 19,823 301ms 0ms 21 19,817 304ms 0ms 22 19,791 304ms 0ms 23 19,805 300ms 0ms [ User: symmetricds - Total duration: 7s268ms - Times executed: 475225 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 630 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s293ms - Times executed: 475855 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-02-09 13:05:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:03:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 18:56:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s620ms 152,356 0ms 32ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 09 00 7,047 504ms 0ms 01 6,316 191ms 0ms 02 6,405 199ms 0ms 03 6,404 215ms 0ms 04 6,404 194ms 0ms 05 6,398 222ms 0ms 06 6,258 165ms 0ms 07 6,337 182ms 0ms 08 6,324 168ms 0ms 09 6,312 167ms 0ms 10 6,294 166ms 0ms 11 6,260 162ms 0ms 12 6,275 160ms 0ms 13 6,281 161ms 0ms 14 6,272 179ms 0ms 15 6,300 164ms 0ms 16 6,300 175ms 0ms 17 6,294 168ms 0ms 18 6,305 181ms 0ms 19 6,319 198ms 0ms 20 6,325 178ms 0ms 21 6,313 176ms 0ms 22 6,306 173ms 0ms 23 6,307 161ms 0ms [ User: symmetricds - Total duration: 4s557ms - Times executed: 152084 ]
[ User: pharmisight - Total duration: 63ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s620ms - Times executed: 152356 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-02-09 05:45:44 Duration: 32ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:34:36 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 07:15:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s502ms 151 0ms 112ms 16ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 09 00 13 101ms 7ms 01 13 95ms 7ms 02 13 90ms 6ms 03 13 89ms 6ms 04 13 118ms 9ms 05 13 107ms 8ms 06 13 260ms 20ms 07 11 209ms 19ms 08 8 96ms 12ms 09 7 226ms 32ms 10 6 232ms 38ms 11 6 203ms 33ms 12 5 155ms 31ms 13 3 109ms 36ms 14 3 70ms 23ms 15 2 66ms 33ms 16 2 46ms 23ms 17 1 32ms 32ms 18 1 44ms 44ms 19 1 21ms 21ms 20 1 26ms 26ms 21 1 34ms 34ms 22 1 28ms 28ms 23 1 31ms 31ms [ User: symmetricds - Total duration: 2s502ms - Times executed: 151 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 151 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2019-02-09 09:00:00 Duration: 112ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 10:00:00 Duration: 86ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s845ms 172,333 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 09 00 8,121 84ms 0ms 01 7,151 75ms 0ms 02 7,256 75ms 0ms 03 7,251 76ms 0ms 04 7,242 78ms 0ms 05 7,249 78ms 0ms 06 7,089 75ms 0ms 07 7,159 75ms 0ms 08 7,156 77ms 0ms 09 7,126 75ms 0ms 10 7,115 76ms 0ms 11 7,081 75ms 0ms 12 7,097 76ms 0ms 13 7,100 76ms 0ms 14 7,085 76ms 0ms 15 7,112 82ms 0ms 16 7,116 74ms 0ms 17 7,100 85ms 0ms 18 7,116 75ms 0ms 19 7,129 76ms 0ms 20 7,130 73ms 0ms 21 7,123 75ms 0ms 22 7,111 74ms 0ms 23 7,118 75ms 0ms [ User: symmetricds - Total duration: 1s845ms - Times executed: 172333 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s845ms - Times executed: 172333 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-02-09 17:56:16 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 15:07:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:55:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s237ms 25,911 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 #6
Day Hour Count Duration Avg duration Feb 09 00 1,084 51ms 0ms 01 1,081 50ms 0ms 02 1,084 51ms 0ms 03 1,086 52ms 0ms 04 1,085 52ms 0ms 05 1,084 52ms 0ms 06 1,075 51ms 0ms 07 1,081 52ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 50ms 0ms 16 1,081 51ms 0ms 17 1,078 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,078 51ms 0ms 21 1,078 51ms 0ms 22 1,078 51ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s237ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s237ms - Times executed: 25911 ]
-
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 = $1;
Date: 2019-02-09 10:22:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:53:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:15:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s180ms 25,012 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 09 00 1,110 52ms 0ms 01 1,048 48ms 0ms 02 1,050 47ms 0ms 03 1,050 48ms 0ms 04 1,048 48ms 0ms 05 1,048 49ms 0ms 06 1,036 48ms 0ms 07 1,040 48ms 0ms 08 1,038 48ms 0ms 09 1,036 48ms 0ms 10 1,038 47ms 0ms 11 1,036 48ms 0ms 12 1,034 46ms 0ms 13 1,036 52ms 0ms 14 1,036 49ms 0ms 15 1,036 49ms 0ms 16 1,038 51ms 0ms 17 1,036 49ms 0ms 18 1,036 47ms 0ms 19 1,036 51ms 0ms 20 1,038 48ms 0ms 21 1,036 49ms 0ms 22 1,036 49ms 0ms 23 1,036 48ms 0ms [ User: symmetricds - Total duration: 1s180ms - Times executed: 25012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 25012 ]
-
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-02-09 13:36:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 16:21:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:09:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s111ms 24,072 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 09 00 1,003 30ms 0ms 01 1,003 42ms 0ms 02 1,003 25ms 0ms 03 1,003 36ms 0ms 04 1,003 43ms 0ms 05 1,003 47ms 0ms 06 1,003 49ms 0ms 07 1,003 50ms 0ms 08 1,003 49ms 0ms 09 1,003 49ms 0ms 10 1,003 50ms 0ms 11 1,003 52ms 0ms 12 1,003 50ms 0ms 13 1,003 49ms 0ms 14 1,003 49ms 0ms 15 1,003 49ms 0ms 16 1,003 49ms 0ms 17 1,003 51ms 0ms 18 1,003 50ms 0ms 19 1,003 50ms 0ms 20 1,003 25ms 0ms 21 1,003 50ms 0ms 22 1,003 52ms 0ms 23 1,003 51ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 24072 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 24072 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-02-09 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s85ms 749 0ms 3ms 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 #9
Day Hour Count Duration Avg duration Feb 09 00 57 80ms 1ms 01 46 67ms 1ms 02 26 37ms 1ms 03 23 31ms 1ms 04 30 42ms 1ms 05 28 40ms 1ms 06 40 55ms 1ms 07 27 39ms 1ms 08 27 38ms 1ms 09 25 34ms 1ms 10 25 40ms 1ms 11 32 48ms 1ms 12 34 51ms 1ms 13 32 47ms 1ms 14 36 53ms 1ms 15 31 45ms 1ms 16 30 43ms 1ms 17 30 45ms 1ms 18 30 42ms 1ms 19 28 38ms 1ms 20 29 40ms 1ms 21 29 42ms 1ms 22 25 36ms 1ms 23 29 41ms 1ms [ User: symmetricds - Total duration: 1s85ms - Times executed: 749 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s85ms - Times executed: 749 ]
-
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-02-09 10:32:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:44:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 14:34:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 929ms 152,357 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 09 00 7,048 42ms 0ms 01 6,316 37ms 0ms 02 6,405 38ms 0ms 03 6,405 38ms 0ms 04 6,403 38ms 0ms 05 6,398 38ms 0ms 06 6,258 38ms 0ms 07 6,337 38ms 0ms 08 6,324 38ms 0ms 09 6,312 39ms 0ms 10 6,294 38ms 0ms 11 6,260 38ms 0ms 12 6,275 37ms 0ms 13 6,281 38ms 0ms 14 6,272 38ms 0ms 15 6,300 37ms 0ms 16 6,300 38ms 0ms 17 6,294 39ms 0ms 18 6,305 38ms 0ms 19 6,319 38ms 0ms 20 6,326 38ms 0ms 21 6,312 38ms 0ms 22 6,306 38ms 0ms 23 6,307 37ms 0ms [ User: symmetricds - Total duration: 927ms - Times executed: 152084 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 929ms - Times executed: 152357 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-02-09 09:17:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:07:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:02:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 925ms 970 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 ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 09 00 75 75ms 1ms 01 63 59ms 0ms 02 37 38ms 1ms 03 32 29ms 0ms 04 41 38ms 0ms 05 34 31ms 0ms 06 53 49ms 0ms 07 34 31ms 0ms 08 36 33ms 0ms 09 33 30ms 0ms 10 32 33ms 1ms 11 41 36ms 0ms 12 42 44ms 1ms 13 41 40ms 0ms 14 43 39ms 0ms 15 37 35ms 0ms 16 37 34ms 0ms 17 36 33ms 0ms 18 42 38ms 0ms 19 34 31ms 0ms 20 38 35ms 0ms 21 38 37ms 0ms 22 32 30ms 0ms 23 39 36ms 0ms [ User: symmetricds - Total duration: 925ms - Times executed: 970 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 925ms - Times executed: 970 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13 UNION ALL SELECT 16852, 3) 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-02-09 12:02:11 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:40:06 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 12:22:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 922ms 21,312 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 #12
Day Hour Count Duration Avg duration Feb 09 00 888 25ms 0ms 01 888 36ms 0ms 02 888 21ms 0ms 03 888 30ms 0ms 04 888 35ms 0ms 05 888 39ms 0ms 06 888 41ms 0ms 07 888 41ms 0ms 08 888 41ms 0ms 09 888 41ms 0ms 10 888 42ms 0ms 11 888 44ms 0ms 12 888 42ms 0ms 13 888 41ms 0ms 14 888 41ms 0ms 15 888 41ms 0ms 16 888 41ms 0ms 17 888 42ms 0ms 18 888 41ms 0ms 19 888 41ms 0ms 20 888 21ms 0ms 21 888 41ms 0ms 22 888 42ms 0ms 23 888 42ms 0ms [ User: pharmisight - Total duration: 922ms - Times executed: 21312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 922ms - Times executed: 21312 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-02-09 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 910ms 191 0ms 9ms 4ms 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 #13
Day Hour Count Duration Avg duration Feb 09 00 8 44ms 5ms 01 8 34ms 4ms 02 8 45ms 5ms 03 8 37ms 4ms 04 8 38ms 4ms 05 8 40ms 5ms 06 8 51ms 6ms 07 8 43ms 5ms 08 8 39ms 4ms 09 8 43ms 5ms 10 8 34ms 4ms 11 8 37ms 4ms 12 7 36ms 5ms 13 8 31ms 3ms 14 8 31ms 3ms 15 8 45ms 5ms 16 8 37ms 4ms 17 8 39ms 4ms 18 8 30ms 3ms 19 8 31ms 3ms 20 8 28ms 3ms 21 8 44ms 5ms 22 8 31ms 3ms 23 8 31ms 3ms [ User: symmetricds - Total duration: 910ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 910ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
Date: 2019-02-09 04:00:40 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 04:30:40 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:45:20 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 852ms 147 4ms 11ms 5ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 09 00 96 555ms 5ms 01 3 12ms 4ms 02 3 13ms 4ms 03 3 12ms 4ms 04 3 22ms 7ms 05 3 26ms 8ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 9ms 4ms 10 2 13ms 6ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 8ms 4ms 19 2 8ms 4ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 18ms 9ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 635ms - Times executed: 102 ]
[ User: pharmisight - Total duration: 217ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 852ms - Times executed: 147 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_trigger' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-02-09 00:00:02 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:00:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 22:15:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 826ms 190 1ms 16ms 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 #15
Day Hour Count Duration Avg duration Feb 09 00 11 43ms 3ms 01 12 47ms 3ms 02 11 49ms 4ms 03 10 44ms 4ms 04 11 41ms 3ms 05 9 51ms 5ms 06 7 25ms 3ms 07 5 17ms 3ms 08 8 32ms 4ms 09 7 27ms 3ms 10 5 23ms 4ms 11 8 33ms 4ms 12 6 24ms 4ms 13 7 27ms 3ms 14 5 19ms 3ms 15 5 24ms 4ms 16 8 36ms 4ms 17 9 40ms 4ms 18 5 26ms 5ms 19 9 31ms 3ms 20 8 35ms 4ms 21 8 33ms 4ms 22 7 35ms 5ms 23 9 52ms 5ms [ User: symmetricds - Total duration: 826ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 826ms - Times executed: 190 ]
-
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-02-09 05:12:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 23:41:21 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:40:06 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 792ms 139 0ms 22ms 5ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 09 00 13 62ms 4ms 01 13 59ms 4ms 02 13 59ms 4ms 03 13 58ms 4ms 04 13 59ms 4ms 05 13 58ms 4ms 06 11 43ms 3ms 07 8 30ms 3ms 08 7 27ms 3ms 09 6 108ms 18ms 10 6 68ms 11ms 11 5 46ms 9ms 12 3 28ms 9ms 13 3 19ms 6ms 14 2 14ms 7ms 15 2 7ms 3ms 16 1 5ms 5ms 17 1 5ms 5ms 18 1 4ms 4ms 19 1 5ms 5ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 792ms - Times executed: 139 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 792ms - Times executed: 139 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
Date: 2019-02-09 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 711ms 6,517 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 09 00 237 27ms 0ms 01 248 27ms 0ms 02 285 31ms 0ms 03 285 32ms 0ms 04 283 30ms 0ms 05 285 30ms 0ms 06 257 27ms 0ms 07 283 31ms 0ms 08 282 31ms 0ms 09 278 29ms 0ms 10 269 29ms 0ms 11 258 28ms 0ms 12 264 29ms 0ms 13 263 30ms 0ms 14 260 28ms 0ms 15 273 28ms 0ms 16 268 28ms 0ms 17 270 32ms 0ms 18 276 31ms 0ms 19 283 28ms 0ms 20 277 28ms 0ms 21 279 28ms 0ms 22 277 29ms 0ms 23 277 28ms 0ms [ User: symmetricds - Total duration: 711ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 711ms - Times executed: 6517 ]
-
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-02-09 17:57:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:28:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 18:18:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 692ms 1,265 0ms 10ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 09 00 453 234ms 0ms 01 124 78ms 0ms 02 263 131ms 0ms 03 301 152ms 0ms 04 118 70ms 0ms 05 6 24ms 4ms [ User: pharmisight - Total duration: 692ms - Times executed: 1265 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 692ms - Times executed: 1265 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
Date: 2019-02-09 03:20:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:00:00 Duration: 8ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 04:20:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 683ms 24 4ms 74ms 28ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 09 00 1 74ms 74ms 01 1 68ms 68ms 02 1 71ms 71ms 03 1 70ms 70ms 04 1 67ms 67ms 05 1 68ms 68ms 06 1 53ms 53ms 07 1 25ms 25ms 08 1 41ms 41ms 09 1 28ms 28ms 10 1 20ms 20ms 11 1 16ms 16ms 12 1 12ms 12ms 13 1 10ms 10ms 14 1 8ms 8ms 15 1 6ms 6ms 16 1 5ms 5ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 4ms 4ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 683ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 683ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-02-09 00:00:00 Duration: 74ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:00:00 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 03:00:00 Duration: 70ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 675ms 96 0ms 11ms 7ms 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 #20
Day Hour Count Duration Avg duration Feb 09 00 4 25ms 6ms 01 4 29ms 7ms 02 4 32ms 8ms 03 4 29ms 7ms 04 4 28ms 7ms 05 4 25ms 6ms 06 4 29ms 7ms 07 4 29ms 7ms 08 4 22ms 5ms 09 4 22ms 5ms 10 4 28ms 7ms 11 4 28ms 7ms 12 4 22ms 5ms 13 4 29ms 7ms 14 4 27ms 6ms 15 4 29ms 7ms 16 4 29ms 7ms 17 4 29ms 7ms 18 4 28ms 7ms 19 4 23ms 5ms 20 4 29ms 7ms 21 4 30ms 7ms 22 4 30ms 7ms 23 4 29ms 7ms [ User: symmetricds - Total duration: 675ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-02-09 02:56:11 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:56:13 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 08:26:11 Duration: 8ms 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 475,855 7s293ms 0ms 2ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 09 00 20,188 307ms 0ms 01 19,728 299ms 0ms 02 20,016 307ms 0ms 03 20,006 306ms 0ms 04 20,007 306ms 0ms 05 20,004 308ms 0ms 06 19,644 301ms 0ms 07 19,884 305ms 0ms 08 19,851 307ms 0ms 09 19,807 306ms 0ms 10 19,756 299ms 0ms 11 19,663 304ms 0ms 12 19,712 299ms 0ms 13 19,723 305ms 0ms 14 19,689 304ms 0ms 15 19,771 298ms 0ms 16 19,789 299ms 0ms 17 19,756 307ms 0ms 18 19,792 304ms 0ms 19 19,833 302ms 0ms 20 19,823 301ms 0ms 21 19,817 304ms 0ms 22 19,791 304ms 0ms 23 19,805 300ms 0ms [ User: symmetricds - Total duration: 7s268ms - Times executed: 475225 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 630 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s293ms - Times executed: 475855 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-02-09 13:05:12 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:03:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 18:56:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 172,333 1s845ms 0ms 6ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 09 00 8,121 84ms 0ms 01 7,151 75ms 0ms 02 7,256 75ms 0ms 03 7,251 76ms 0ms 04 7,242 78ms 0ms 05 7,249 78ms 0ms 06 7,089 75ms 0ms 07 7,159 75ms 0ms 08 7,156 77ms 0ms 09 7,126 75ms 0ms 10 7,115 76ms 0ms 11 7,081 75ms 0ms 12 7,097 76ms 0ms 13 7,100 76ms 0ms 14 7,085 76ms 0ms 15 7,112 82ms 0ms 16 7,116 74ms 0ms 17 7,100 85ms 0ms 18 7,116 75ms 0ms 19 7,129 76ms 0ms 20 7,130 73ms 0ms 21 7,123 75ms 0ms 22 7,111 74ms 0ms 23 7,118 75ms 0ms [ User: symmetricds - Total duration: 1s845ms - Times executed: 172333 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s845ms - Times executed: 172333 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-02-09 17:56:16 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 15:07:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:55:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 152,357 929ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 09 00 7,048 42ms 0ms 01 6,316 37ms 0ms 02 6,405 38ms 0ms 03 6,405 38ms 0ms 04 6,403 38ms 0ms 05 6,398 38ms 0ms 06 6,258 38ms 0ms 07 6,337 38ms 0ms 08 6,324 38ms 0ms 09 6,312 39ms 0ms 10 6,294 38ms 0ms 11 6,260 38ms 0ms 12 6,275 37ms 0ms 13 6,281 38ms 0ms 14 6,272 38ms 0ms 15 6,300 37ms 0ms 16 6,300 38ms 0ms 17 6,294 39ms 0ms 18 6,305 38ms 0ms 19 6,319 38ms 0ms 20 6,326 38ms 0ms 21 6,312 38ms 0ms 22 6,306 38ms 0ms 23 6,307 37ms 0ms [ User: symmetricds - Total duration: 927ms - Times executed: 152084 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 273 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 929ms - Times executed: 152357 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-02-09 09:17:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:07:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 17:02:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 152,356 4s620ms 0ms 32ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 09 00 7,047 504ms 0ms 01 6,316 191ms 0ms 02 6,405 199ms 0ms 03 6,404 215ms 0ms 04 6,404 194ms 0ms 05 6,398 222ms 0ms 06 6,258 165ms 0ms 07 6,337 182ms 0ms 08 6,324 168ms 0ms 09 6,312 167ms 0ms 10 6,294 166ms 0ms 11 6,260 162ms 0ms 12 6,275 160ms 0ms 13 6,281 161ms 0ms 14 6,272 179ms 0ms 15 6,300 164ms 0ms 16 6,300 175ms 0ms 17 6,294 168ms 0ms 18 6,305 181ms 0ms 19 6,319 198ms 0ms 20 6,325 178ms 0ms 21 6,313 176ms 0ms 22 6,306 173ms 0ms 23 6,307 161ms 0ms [ User: symmetricds - Total duration: 4s557ms - Times executed: 152084 ]
[ User: pharmisight - Total duration: 63ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s620ms - Times executed: 152356 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-02-09 05:45:44 Duration: 32ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:34:36 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 07:15:55 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,911 1s237ms 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 #5
Day Hour Count Duration Avg duration Feb 09 00 1,084 51ms 0ms 01 1,081 50ms 0ms 02 1,084 51ms 0ms 03 1,086 52ms 0ms 04 1,085 52ms 0ms 05 1,084 52ms 0ms 06 1,075 51ms 0ms 07 1,081 52ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 50ms 0ms 16 1,081 51ms 0ms 17 1,078 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,078 51ms 0ms 21 1,078 51ms 0ms 22 1,078 51ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s237ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s237ms - Times executed: 25911 ]
-
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 = $1;
Date: 2019-02-09 10:22:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:53:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:15:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 25,780 14s26ms 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 #6
Day Hour Count Duration Avg duration Feb 09 00 1,075 594ms 0ms 01 1,071 595ms 0ms 02 1,074 593ms 0ms 03 1,076 586ms 0ms 04 1,075 593ms 0ms 05 1,074 598ms 0ms 06 1,071 590ms 0ms 07 1,077 588ms 0ms 08 1,074 577ms 0ms 09 1,074 592ms 0ms 10 1,074 576ms 0ms 11 1,074 586ms 0ms 12 1,074 573ms 0ms 13 1,074 573ms 0ms 14 1,074 575ms 0ms 15 1,074 572ms 0ms 16 1,077 580ms 0ms 17 1,074 598ms 0ms 18 1,074 578ms 0ms 19 1,074 581ms 0ms 20 1,074 579ms 0ms 21 1,074 583ms 0ms 22 1,074 582ms 0ms 23 1,074 573ms 0ms [ User: symmetricds - Total duration: 14s26ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s26ms - Times executed: 25780 ]
-
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-02-09 17:41:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:46:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:02:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,012 1s180ms 0ms 1ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 09 00 1,110 52ms 0ms 01 1,048 48ms 0ms 02 1,050 47ms 0ms 03 1,050 48ms 0ms 04 1,048 48ms 0ms 05 1,048 49ms 0ms 06 1,036 48ms 0ms 07 1,040 48ms 0ms 08 1,038 48ms 0ms 09 1,036 48ms 0ms 10 1,038 47ms 0ms 11 1,036 48ms 0ms 12 1,034 46ms 0ms 13 1,036 52ms 0ms 14 1,036 49ms 0ms 15 1,036 49ms 0ms 16 1,038 51ms 0ms 17 1,036 49ms 0ms 18 1,036 47ms 0ms 19 1,036 51ms 0ms 20 1,038 48ms 0ms 21 1,036 49ms 0ms 22 1,036 49ms 0ms 23 1,036 48ms 0ms [ User: symmetricds - Total duration: 1s180ms - Times executed: 25012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 25012 ]
-
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-02-09 13:36:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 16:21:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:09:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 24,072 1s111ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 09 00 1,003 30ms 0ms 01 1,003 42ms 0ms 02 1,003 25ms 0ms 03 1,003 36ms 0ms 04 1,003 43ms 0ms 05 1,003 47ms 0ms 06 1,003 49ms 0ms 07 1,003 50ms 0ms 08 1,003 49ms 0ms 09 1,003 49ms 0ms 10 1,003 50ms 0ms 11 1,003 52ms 0ms 12 1,003 50ms 0ms 13 1,003 49ms 0ms 14 1,003 49ms 0ms 15 1,003 49ms 0ms 16 1,003 49ms 0ms 17 1,003 51ms 0ms 18 1,003 50ms 0ms 19 1,003 50ms 0ms 20 1,003 25ms 0ms 21 1,003 50ms 0ms 22 1,003 52ms 0ms 23 1,003 51ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 24072 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 24072 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-02-09 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 21,312 922ms 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 Feb 09 00 888 25ms 0ms 01 888 36ms 0ms 02 888 21ms 0ms 03 888 30ms 0ms 04 888 35ms 0ms 05 888 39ms 0ms 06 888 41ms 0ms 07 888 41ms 0ms 08 888 41ms 0ms 09 888 41ms 0ms 10 888 42ms 0ms 11 888 44ms 0ms 12 888 42ms 0ms 13 888 41ms 0ms 14 888 41ms 0ms 15 888 41ms 0ms 16 888 41ms 0ms 17 888 42ms 0ms 18 888 41ms 0ms 19 888 41ms 0ms 20 888 21ms 0ms 21 888 41ms 0ms 22 888 42ms 0ms 23 888 42ms 0ms [ User: pharmisight - Total duration: 922ms - Times executed: 21312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 922ms - Times executed: 21312 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-02-09 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,268 451ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 09 00 720 18ms 0ms 01 720 18ms 0ms 02 720 19ms 0ms 03 718 19ms 0ms 04 720 19ms 0ms 05 720 19ms 0ms 06 718 18ms 0ms 07 720 18ms 0ms 08 720 18ms 0ms 09 720 18ms 0ms 10 718 18ms 0ms 11 720 18ms 0ms 12 720 18ms 0ms 13 720 18ms 0ms 14 718 18ms 0ms 15 720 19ms 0ms 16 720 18ms 0ms 17 720 18ms 0ms 18 718 18ms 0ms 19 720 19ms 0ms 20 720 18ms 0ms 21 720 18ms 0ms 22 718 19ms 0ms 23 720 19ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 17268 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 17268 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2019-02-09 09:53:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 09:50:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 03:13:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,193 107ms 0ms 1ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 09 00 392 4ms 0ms 01 391 4ms 0ms 02 392 4ms 0ms 03 392 4ms 0ms 04 393 4ms 0ms 05 392 4ms 0ms 06 379 4ms 0ms 07 381 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 380 5ms 0ms 12 380 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 380 4ms 0ms 16 381 4ms 0ms 17 380 4ms 0ms 18 380 4ms 0ms 19 380 4ms 0ms 20 380 4ms 0ms 21 380 4ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms [ User: symmetricds - Total duration: 107ms - Times executed: 9193 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 107ms - Times executed: 9193 ]
-
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-02-09 11:00:00 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:02:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 16:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,193 146ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 09 00 395 6ms 0ms 01 388 6ms 0ms 02 395 6ms 0ms 03 390 6ms 0ms 04 392 6ms 0ms 05 393 6ms 0ms 06 380 6ms 0ms 07 379 6ms 0ms 08 382 6ms 0ms 09 378 6ms 0ms 10 380 6ms 0ms 11 380 6ms 0ms 12 381 6ms 0ms 13 382 6ms 0ms 14 380 5ms 0ms 15 377 5ms 0ms 16 384 6ms 0ms 17 377 6ms 0ms 18 380 5ms 0ms 19 380 6ms 0ms 20 381 6ms 0ms 21 380 6ms 0ms 22 379 6ms 0ms 23 380 5ms 0ms [ User: symmetricds - Total duration: 146ms - Times executed: 9193 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 146ms - Times executed: 9193 ]
-
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-02-09 01:01:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:32:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 21:14:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,593 291ms 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 #13
Day Hour Count Duration Avg duration Feb 09 00 358 11ms 0ms 01 357 11ms 0ms 02 358 12ms 0ms 03 358 11ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 357 12ms 0ms 07 359 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 11ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 11ms 0ms 16 359 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 358 12ms 0ms [ User: symmetricds - Total duration: 291ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 291ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 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 = $1 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 = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-02-09 12:24:43 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 21:18:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 10:21:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,593 265ms 0ms 1ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 09 00 358 12ms 0ms 01 357 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 11ms 0ms 06 357 10ms 0ms 07 359 10ms 0ms 08 358 11ms 0ms 09 358 10ms 0ms 10 358 11ms 0ms 11 358 10ms 0ms 12 358 10ms 0ms 13 358 11ms 0ms 14 358 10ms 0ms 15 358 10ms 0ms 16 359 10ms 0ms 17 358 10ms 0ms 18 358 10ms 0ms 19 358 10ms 0ms 20 358 10ms 0ms 21 358 10ms 0ms 22 358 10ms 0ms 23 358 10ms 0ms [ User: symmetricds - Total duration: 265ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 265ms - Times executed: 8593 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
Date: 2019-02-09 13:38:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:20:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 15:32:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,593 384ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 09 00 358 15ms 0ms 01 357 16ms 0ms 02 358 16ms 0ms 03 358 15ms 0ms 04 359 16ms 0ms 05 358 16ms 0ms 06 357 15ms 0ms 07 359 15ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 15ms 0ms 11 358 15ms 0ms 12 358 15ms 0ms 13 358 17ms 0ms 14 358 15ms 0ms 15 358 15ms 0ms 16 359 15ms 0ms 17 358 16ms 0ms 18 358 15ms 0ms 19 358 15ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 384ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 384ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-02-09 13:34:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 15:40:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:42:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,593 208ms 0ms 1ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 09 00 358 8ms 0ms 01 357 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 357 8ms 0ms 07 359 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 358 9ms 0ms 11 358 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 358 8ms 0ms 15 358 8ms 0ms 16 359 8ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 358 8ms 0ms 23 358 9ms 0ms [ User: symmetricds - Total duration: 208ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 208ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
Date: 2019-02-09 23:19:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 16:56:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:39:49 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,517 317ms 0ms 2ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 09 00 237 13ms 0ms 01 248 14ms 0ms 02 285 13ms 0ms 03 285 13ms 0ms 04 283 13ms 0ms 05 285 13ms 0ms 06 257 12ms 0ms 07 283 13ms 0ms 08 282 13ms 0ms 09 278 13ms 0ms 10 269 13ms 0ms 11 258 14ms 0ms 12 264 12ms 0ms 13 263 13ms 0ms 14 260 12ms 0ms 15 273 12ms 0ms 16 268 13ms 0ms 17 270 13ms 0ms 18 276 12ms 0ms 19 283 12ms 0ms 20 277 12ms 0ms 21 279 12ms 0ms 22 277 13ms 0ms 23 277 12ms 0ms [ User: symmetricds - Total duration: 317ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 317ms - Times executed: 6517 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-02-09 01:49:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:57:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:48:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,517 711ms 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 09 00 237 27ms 0ms 01 248 27ms 0ms 02 285 31ms 0ms 03 285 32ms 0ms 04 283 30ms 0ms 05 285 30ms 0ms 06 257 27ms 0ms 07 283 31ms 0ms 08 282 31ms 0ms 09 278 29ms 0ms 10 269 29ms 0ms 11 258 28ms 0ms 12 264 29ms 0ms 13 263 30ms 0ms 14 260 28ms 0ms 15 273 28ms 0ms 16 268 28ms 0ms 17 270 32ms 0ms 18 276 31ms 0ms 19 283 28ms 0ms 20 277 28ms 0ms 21 279 28ms 0ms 22 277 29ms 0ms 23 277 28ms 0ms [ User: symmetricds - Total duration: 711ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 711ms - Times executed: 6517 ]
-
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-02-09 17:57:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:28:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 18:18:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,452 411ms 0ms 3ms 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 Feb 09 00 190 20ms 0ms 01 190 18ms 0ms 02 190 18ms 0ms 03 190 19ms 0ms 04 190 18ms 0ms 05 190 22ms 0ms 06 184 17ms 0ms 07 184 16ms 0ms 08 184 18ms 0ms 09 184 15ms 0ms 10 184 16ms 0ms 11 184 15ms 0ms 12 184 16ms 0ms 13 184 16ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 16ms 0ms 17 184 15ms 0ms 18 184 14ms 0ms 19 184 15ms 0ms 20 184 15ms 0ms 21 184 14ms 0ms 22 184 16ms 0ms 23 184 17ms 0ms [ User: symmetricds - Total duration: 411ms - Times executed: 4452 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 411ms - Times executed: 4452 ]
-
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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) 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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) 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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-02-09 05:35:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 03:53:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:42:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 3,391 240ms 0ms 0ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 09 00 942 44ms 0ms 01 284 17ms 0ms 02 562 36ms 0ms 03 638 41ms 0ms 04 272 16ms 0ms 05 48 7ms 0ms 06 36 6ms 0ms 07 36 4ms 0ms 08 36 4ms 0ms 09 36 3ms 0ms 10 36 4ms 0ms 11 33 3ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 3ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 3ms 0ms 18 36 4ms 0ms 19 36 3ms 0ms 20 36 4ms 0ms 21 36 4ms 0ms 22 36 4ms 0ms 23 36 4ms 0ms [ User: symmetricds - Total duration: 240ms - Times executed: 3391 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 240ms - Times executed: 3391 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
Date: 2019-02-09 01:11:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:31:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:46:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4ms 74ms 28ms 24 683ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 09 00 1 74ms 74ms 01 1 68ms 68ms 02 1 71ms 71ms 03 1 70ms 70ms 04 1 67ms 67ms 05 1 68ms 68ms 06 1 53ms 53ms 07 1 25ms 25ms 08 1 41ms 41ms 09 1 28ms 28ms 10 1 20ms 20ms 11 1 16ms 16ms 12 1 12ms 12ms 13 1 10ms 10ms 14 1 8ms 8ms 15 1 6ms 6ms 16 1 5ms 5ms 17 1 4ms 4ms 18 1 4ms 4ms 19 1 4ms 4ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 683ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 683ms - Times executed: 24 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-02-09 00:00:00 Duration: 74ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:00:00 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 03:00:00 Duration: 70ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 112ms 16ms 151 2s502ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 09 00 13 101ms 7ms 01 13 95ms 7ms 02 13 90ms 6ms 03 13 89ms 6ms 04 13 118ms 9ms 05 13 107ms 8ms 06 13 260ms 20ms 07 11 209ms 19ms 08 8 96ms 12ms 09 7 226ms 32ms 10 6 232ms 38ms 11 6 203ms 33ms 12 5 155ms 31ms 13 3 109ms 36ms 14 3 70ms 23ms 15 2 66ms 33ms 16 2 46ms 23ms 17 1 32ms 32ms 18 1 44ms 44ms 19 1 21ms 21ms 20 1 26ms 26ms 21 1 34ms 34ms 22 1 28ms 28ms 23 1 31ms 31ms [ User: symmetricds - Total duration: 2s502ms - Times executed: 151 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s502ms - Times executed: 151 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2019-02-09 09:00:00 Duration: 112ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 10:00:00 Duration: 86ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:00:00 Duration: 84ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 11ms 7ms 96 675ms 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 #3
Day Hour Count Duration Avg duration Feb 09 00 4 25ms 6ms 01 4 29ms 7ms 02 4 32ms 8ms 03 4 29ms 7ms 04 4 28ms 7ms 05 4 25ms 6ms 06 4 29ms 7ms 07 4 29ms 7ms 08 4 22ms 5ms 09 4 22ms 5ms 10 4 28ms 7ms 11 4 28ms 7ms 12 4 22ms 5ms 13 4 29ms 7ms 14 4 27ms 6ms 15 4 29ms 7ms 16 4 29ms 7ms 17 4 29ms 7ms 18 4 28ms 7ms 19 4 23ms 5ms 20 4 29ms 7ms 21 4 30ms 7ms 22 4 30ms 7ms 23 4 29ms 7ms [ User: symmetricds - Total duration: 675ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-02-09 02:56:11 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:56:13 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 08:26:11 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 4ms 11ms 5ms 147 852ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 09 00 96 555ms 5ms 01 3 12ms 4ms 02 3 13ms 4ms 03 3 12ms 4ms 04 3 22ms 7ms 05 3 26ms 8ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 13ms 6ms 09 2 9ms 4ms 10 2 13ms 6ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 8ms 4ms 19 2 8ms 4ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 18ms 9ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 635ms - Times executed: 102 ]
[ User: pharmisight - Total duration: 217ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 852ms - Times executed: 147 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'sym_trigger' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-02-09 00:00:02 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:00:00 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 22:15:24 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 22ms 5ms 139 792ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 09 00 13 62ms 4ms 01 13 59ms 4ms 02 13 59ms 4ms 03 13 58ms 4ms 04 13 59ms 4ms 05 13 58ms 4ms 06 11 43ms 3ms 07 8 30ms 3ms 08 7 27ms 3ms 09 6 108ms 18ms 10 6 68ms 11ms 11 5 46ms 9ms 12 3 28ms 9ms 13 3 19ms 6ms 14 2 14ms 7ms 15 2 7ms 3ms 16 1 5ms 5ms 17 1 5ms 5ms 18 1 4ms 4ms 19 1 5ms 5ms 20 1 4ms 4ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 4ms 4ms [ User: symmetricds - Total duration: 792ms - Times executed: 139 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 792ms - Times executed: 139 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND data_id < $3 AND create_time < $4 AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $5 AND $6);
Date: 2019-02-09 09:00:00 Duration: 22ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 09:00:00 Duration: 21ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 9ms 4ms 191 910ms 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 #6
Day Hour Count Duration Avg duration Feb 09 00 8 44ms 5ms 01 8 34ms 4ms 02 8 45ms 5ms 03 8 37ms 4ms 04 8 38ms 4ms 05 8 40ms 5ms 06 8 51ms 6ms 07 8 43ms 5ms 08 8 39ms 4ms 09 8 43ms 5ms 10 8 34ms 4ms 11 8 37ms 4ms 12 7 36ms 5ms 13 8 31ms 3ms 14 8 31ms 3ms 15 8 45ms 5ms 16 8 37ms 4ms 17 8 39ms 4ms 18 8 30ms 3ms 19 8 31ms 3ms 20 8 28ms 3ms 21 8 44ms 5ms 22 8 31ms 3ms 23 8 31ms 3ms [ User: symmetricds - Total duration: 910ms - Times executed: 191 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 910ms - Times executed: 191 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
Date: 2019-02-09 04:00:40 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 04:30:40 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:45:20 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1ms 16ms 4ms 190 826ms 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 #7
Day Hour Count Duration Avg duration Feb 09 00 11 43ms 3ms 01 12 47ms 3ms 02 11 49ms 4ms 03 10 44ms 4ms 04 11 41ms 3ms 05 9 51ms 5ms 06 7 25ms 3ms 07 5 17ms 3ms 08 8 32ms 4ms 09 7 27ms 3ms 10 5 23ms 4ms 11 8 33ms 4ms 12 6 24ms 4ms 13 7 27ms 3ms 14 5 19ms 3ms 15 5 24ms 4ms 16 8 36ms 4ms 17 9 40ms 4ms 18 5 26ms 5ms 19 9 31ms 3ms 20 8 35ms 4ms 21 8 33ms 4ms 22 7 35ms 5ms 23 9 52ms 5ms [ User: symmetricds - Total duration: 826ms - Times executed: 190 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 826ms - Times executed: 190 ]
-
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-02-09 05:12:07 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 23:41:21 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:40:06 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 3ms 1ms 749 1s85ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 09 00 57 80ms 1ms 01 46 67ms 1ms 02 26 37ms 1ms 03 23 31ms 1ms 04 30 42ms 1ms 05 28 40ms 1ms 06 40 55ms 1ms 07 27 39ms 1ms 08 27 38ms 1ms 09 25 34ms 1ms 10 25 40ms 1ms 11 32 48ms 1ms 12 34 51ms 1ms 13 32 47ms 1ms 14 36 53ms 1ms 15 31 45ms 1ms 16 30 43ms 1ms 17 30 45ms 1ms 18 30 42ms 1ms 19 28 38ms 1ms 20 29 40ms 1ms 21 29 42ms 1ms 22 25 36ms 1ms 23 29 41ms 1ms [ User: symmetricds - Total duration: 1s85ms - Times executed: 749 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s85ms - Times executed: 749 ]
-
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-02-09 10:32:10 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:44:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 14:34:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 4ms 0ms 970 925ms 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 #9
Day Hour Count Duration Avg duration Feb 09 00 75 75ms 1ms 01 63 59ms 0ms 02 37 38ms 1ms 03 32 29ms 0ms 04 41 38ms 0ms 05 34 31ms 0ms 06 53 49ms 0ms 07 34 31ms 0ms 08 36 33ms 0ms 09 33 30ms 0ms 10 32 33ms 1ms 11 41 36ms 0ms 12 42 44ms 1ms 13 41 40ms 0ms 14 43 39ms 0ms 15 37 35ms 0ms 16 37 34ms 0ms 17 36 33ms 0ms 18 42 38ms 0ms 19 34 31ms 0ms 20 38 35ms 0ms 21 38 37ms 0ms 22 32 30ms 0ms 23 39 36ms 0ms [ User: symmetricds - Total duration: 925ms - Times executed: 970 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 925ms - Times executed: 970 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13 UNION ALL SELECT 16852, 3) 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-02-09 12:02:11 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:40:06 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 12:22:11 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 10ms 0ms 1,265 692ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 09 00 453 234ms 0ms 01 124 78ms 0ms 02 263 131ms 0ms 03 301 152ms 0ms 04 118 70ms 0ms 05 6 24ms 4ms [ User: pharmisight - Total duration: 692ms - Times executed: 1265 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 692ms - Times executed: 1265 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
Date: 2019-02-09 03:20:00 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:00:00 Duration: 8ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 04:20:00 Duration: 7ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 2ms 0ms 25,780 14s26ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 09 00 1,075 594ms 0ms 01 1,071 595ms 0ms 02 1,074 593ms 0ms 03 1,076 586ms 0ms 04 1,075 593ms 0ms 05 1,074 598ms 0ms 06 1,071 590ms 0ms 07 1,077 588ms 0ms 08 1,074 577ms 0ms 09 1,074 592ms 0ms 10 1,074 576ms 0ms 11 1,074 586ms 0ms 12 1,074 573ms 0ms 13 1,074 573ms 0ms 14 1,074 575ms 0ms 15 1,074 572ms 0ms 16 1,077 580ms 0ms 17 1,074 598ms 0ms 18 1,074 578ms 0ms 19 1,074 581ms 0ms 20 1,074 579ms 0ms 21 1,074 583ms 0ms 22 1,074 582ms 0ms 23 1,074 573ms 0ms [ User: symmetricds - Total duration: 14s26ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s26ms - Times executed: 25780 ]
-
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-02-09 17:41:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:46:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:02:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 6,517 711ms 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 #12
Day Hour Count Duration Avg duration Feb 09 00 237 27ms 0ms 01 248 27ms 0ms 02 285 31ms 0ms 03 285 32ms 0ms 04 283 30ms 0ms 05 285 30ms 0ms 06 257 27ms 0ms 07 283 31ms 0ms 08 282 31ms 0ms 09 278 29ms 0ms 10 269 29ms 0ms 11 258 28ms 0ms 12 264 29ms 0ms 13 263 30ms 0ms 14 260 28ms 0ms 15 273 28ms 0ms 16 268 28ms 0ms 17 270 32ms 0ms 18 276 31ms 0ms 19 283 28ms 0ms 20 277 28ms 0ms 21 279 28ms 0ms 22 277 29ms 0ms 23 277 28ms 0ms [ User: symmetricds - Total duration: 711ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 711ms - Times executed: 6517 ]
-
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-02-09 17:57:16 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:28:06 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 18:18:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 3ms 0ms 4,452 411ms 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 #13
Day Hour Count Duration Avg duration Feb 09 00 190 20ms 0ms 01 190 18ms 0ms 02 190 18ms 0ms 03 190 19ms 0ms 04 190 18ms 0ms 05 190 22ms 0ms 06 184 17ms 0ms 07 184 16ms 0ms 08 184 18ms 0ms 09 184 15ms 0ms 10 184 16ms 0ms 11 184 15ms 0ms 12 184 16ms 0ms 13 184 16ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 16ms 0ms 17 184 15ms 0ms 18 184 14ms 0ms 19 184 15ms 0ms 20 184 15ms 0ms 21 184 14ms 0ms 22 184 16ms 0ms 23 184 17ms 0ms [ User: symmetricds - Total duration: 411ms - Times executed: 4452 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 411ms - Times executed: 4452 ]
-
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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) 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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) 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 = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-02-09 05:35:07 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 03:53:06 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:42:07 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 3,391 240ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 09 00 942 44ms 0ms 01 284 17ms 0ms 02 562 36ms 0ms 03 638 41ms 0ms 04 272 16ms 0ms 05 48 7ms 0ms 06 36 6ms 0ms 07 36 4ms 0ms 08 36 4ms 0ms 09 36 3ms 0ms 10 36 4ms 0ms 11 33 3ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 3ms 0ms 15 36 4ms 0ms 16 36 4ms 0ms 17 36 3ms 0ms 18 36 4ms 0ms 19 36 3ms 0ms 20 36 4ms 0ms 21 36 4ms 0ms 22 36 4ms 0ms 23 36 4ms 0ms [ User: symmetricds - Total duration: 240ms - Times executed: 3391 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 240ms - Times executed: 3391 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
Date: 2019-02-09 01:11:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 02:31:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:46:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 2ms 0ms 6,517 317ms 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 #15
Day Hour Count Duration Avg duration Feb 09 00 237 13ms 0ms 01 248 14ms 0ms 02 285 13ms 0ms 03 285 13ms 0ms 04 283 13ms 0ms 05 285 13ms 0ms 06 257 12ms 0ms 07 283 13ms 0ms 08 282 13ms 0ms 09 278 13ms 0ms 10 269 13ms 0ms 11 258 14ms 0ms 12 264 12ms 0ms 13 263 13ms 0ms 14 260 12ms 0ms 15 273 12ms 0ms 16 268 13ms 0ms 17 270 13ms 0ms 18 276 12ms 0ms 19 283 12ms 0ms 20 277 12ms 0ms 21 279 12ms 0ms 22 277 13ms 0ms 23 277 12ms 0ms [ User: symmetricds - Total duration: 317ms - Times executed: 6517 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 317ms - Times executed: 6517 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-02-09 01:49:05 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:57:11 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 11:48:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 25,911 1s237ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 09 00 1,084 51ms 0ms 01 1,081 50ms 0ms 02 1,084 51ms 0ms 03 1,086 52ms 0ms 04 1,085 52ms 0ms 05 1,084 52ms 0ms 06 1,075 51ms 0ms 07 1,081 52ms 0ms 08 1,078 51ms 0ms 09 1,078 51ms 0ms 10 1,078 51ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 50ms 0ms 16 1,081 51ms 0ms 17 1,078 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,078 51ms 0ms 21 1,078 51ms 0ms 22 1,078 51ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s237ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s237ms - Times executed: 25911 ]
-
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 = $1;
Date: 2019-02-09 10:22:35 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:53:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 20:15:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 25,012 1s180ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 09 00 1,110 52ms 0ms 01 1,048 48ms 0ms 02 1,050 47ms 0ms 03 1,050 48ms 0ms 04 1,048 48ms 0ms 05 1,048 49ms 0ms 06 1,036 48ms 0ms 07 1,040 48ms 0ms 08 1,038 48ms 0ms 09 1,036 48ms 0ms 10 1,038 47ms 0ms 11 1,036 48ms 0ms 12 1,034 46ms 0ms 13 1,036 52ms 0ms 14 1,036 49ms 0ms 15 1,036 49ms 0ms 16 1,038 51ms 0ms 17 1,036 49ms 0ms 18 1,036 47ms 0ms 19 1,036 51ms 0ms 20 1,038 48ms 0ms 21 1,036 49ms 0ms 22 1,036 49ms 0ms 23 1,036 48ms 0ms [ User: symmetricds - Total duration: 1s180ms - Times executed: 25012 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s180ms - Times executed: 25012 ]
-
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-02-09 13:36:13 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 16:21:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 00:09:05 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 24,072 1s111ms 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 #18
Day Hour Count Duration Avg duration Feb 09 00 1,003 30ms 0ms 01 1,003 42ms 0ms 02 1,003 25ms 0ms 03 1,003 36ms 0ms 04 1,003 43ms 0ms 05 1,003 47ms 0ms 06 1,003 49ms 0ms 07 1,003 50ms 0ms 08 1,003 49ms 0ms 09 1,003 49ms 0ms 10 1,003 50ms 0ms 11 1,003 52ms 0ms 12 1,003 50ms 0ms 13 1,003 49ms 0ms 14 1,003 49ms 0ms 15 1,003 49ms 0ms 16 1,003 49ms 0ms 17 1,003 51ms 0ms 18 1,003 50ms 0ms 19 1,003 50ms 0ms 20 1,003 25ms 0ms 21 1,003 50ms 0ms 22 1,003 52ms 0ms 23 1,003 51ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 24072 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 24072 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-02-09 21:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 05:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 1ms 0ms 8,593 384ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 09 00 358 15ms 0ms 01 357 16ms 0ms 02 358 16ms 0ms 03 358 15ms 0ms 04 359 16ms 0ms 05 358 16ms 0ms 06 357 15ms 0ms 07 359 15ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 15ms 0ms 11 358 15ms 0ms 12 358 15ms 0ms 13 358 17ms 0ms 14 358 15ms 0ms 15 358 15ms 0ms 16 359 15ms 0ms 17 358 16ms 0ms 18 358 15ms 0ms 19 358 15ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 384ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 384ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-02-09 13:34:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 15:40:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 19:42:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 21,312 922ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 09 00 888 25ms 0ms 01 888 36ms 0ms 02 888 21ms 0ms 03 888 30ms 0ms 04 888 35ms 0ms 05 888 39ms 0ms 06 888 41ms 0ms 07 888 41ms 0ms 08 888 41ms 0ms 09 888 41ms 0ms 10 888 42ms 0ms 11 888 44ms 0ms 12 888 42ms 0ms 13 888 41ms 0ms 14 888 41ms 0ms 15 888 41ms 0ms 16 888 41ms 0ms 17 888 42ms 0ms 18 888 41ms 0ms 19 888 41ms 0ms 20 888 21ms 0ms 21 888 41ms 0ms 22 888 42ms 0ms 23 888 42ms 0ms [ User: pharmisight - Total duration: 922ms - Times executed: 21312 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 922ms - Times executed: 21312 ]
-
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 = $1 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 = $1 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 = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-02-09 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-02-09 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,481,771 Log entries
Events distribution
Key values
- 0 PANIC entries
- 7 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 7 Total events found
Rank Times reported Error 1 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #1
Day Hour Count Feb 09 04 2 16 1 - FATAL: no pg_hba.conf entry for host "71.6.146.185", user "postgres", database "template0", SSL on
- FATAL: no pg_hba.conf entry for host "71.6.146.185", user "postgres", database "-h", SSL on
- FATAL: no pg_hba.conf entry for host "37.187.77.188", user "postgres", database "postgres", SSL on
Date: 2019-02-09 04:37:17 Database: template0 Application: [unknown] User: postgres Remote: 71.6.146.185 Code:
Date: 2019-02-09 04:37:18 Database: -h Application: [unknown] User: postgres Remote: 71.6.146.185 Code:
Date: 2019-02-09 16:36:08 Database: postgres Application: [unknown] User: postgres Remote: 37.187.77.188 Code:
2 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #2
Day Hour Count Feb 09 04 2 16 1 - FATAL: no pg_hba.conf entry for host "71.6.146.185", user "postgres", database "template0", SSL off
- FATAL: no pg_hba.conf entry for host "71.6.146.185", user "postgres", database "-h", SSL off
- FATAL: no pg_hba.conf entry for host "37.187.77.188", user "postgres", database "postgres", SSL off
Date: 2019-02-09 04:37:17 Database: template0 Application: [unknown] User: postgres Remote: 71.6.146.185 Code:
Date: 2019-02-09 04:37:18 Database: -h Application: [unknown] User: postgres Remote: 71.6.146.185 Code:
Date: 2019-02-09 16:36:08 Database: postgres Application: [unknown] User: postgres Remote: 37.187.77.188 Code:
3 1 FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Feb 09 04 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Date: 2019-02-09 04:37:17 Database: [unknown] Application: [unknown] User: [unknown] Remote: 71.6.146.185 Code: