pgBadger-
Global information
- Generated on Wed Dec 26 00:00:27 2018
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,644,633 log entries in 24s
- Log start from 2018-12-25 00:00:00 to 2018-12-25 23:59:59
-
Overview
Global Stats
- 211 Number of unique normalized queries
- 1,246,687 Number of queries
- 55s754ms Total query duration
- 2018-12-25 00:00:00 First query
- 2018-12-25 23:59:59 Last query
- 1,888 queries/s at 2018-12-25 14:20:00 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 50 Total number of automatic vacuums
- 66 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,052 Total number of sessions
- 1 sessions at 2018-12-25 14:11:18 Session peak
- 10d37m10s Total duration of sessions
- 7m2s Average duration of sessions
- 607 Average queries per session
- 27ms Average queries duration per session
- 2,052 Total number of connections
- 6 connections/s at 2018-12-25 00:00:20 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,888 queries/s Query Peak
- 2018-12-25 14:20:00 Date
SELECT Traffic
Key values
- 1,882 queries/s Query Peak
- 2018-12-25 14:20:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 138 queries/s Query Peak
- 2018-12-25 00:00:28 Date
Queries duration
Key values
- 55s754ms Total query duration
Prepared queries ratio
Key values
- 1.68 Ratio of bind vs prepare
- 166.75 % 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) Dec 25 00 57,025 0ms 96ms 0ms 46ms 146ms 2s127ms 01 51,557 0ms 26ms 0ms 46ms 70ms 302ms 02 51,313 0ms 25ms 0ms 52ms 89ms 306ms 03 51,404 0ms 28ms 0ms 44ms 65ms 302ms 04 51,664 0ms 27ms 0ms 52ms 64ms 316ms 05 51,560 0ms 27ms 0ms 49ms 72ms 294ms 06 51,560 0ms 29ms 0ms 55ms 84ms 326ms 07 51,580 0ms 70ms 0ms 54ms 78ms 427ms 08 51,595 0ms 134ms 0ms 49ms 70ms 652ms 09 51,427 0ms 66ms 0ms 48ms 85ms 518ms 10 51,603 0ms 71ms 0ms 57ms 83ms 439ms 11 51,620 0ms 61ms 0ms 52ms 78ms 391ms 12 51,562 0ms 58ms 0ms 52ms 86ms 349ms 13 51,491 0ms 52ms 0ms 59ms 70ms 308ms 14 51,506 0ms 94ms 0ms 52ms 75ms 284ms 15 51,610 0ms 25ms 0ms 46ms 82ms 203ms 16 51,445 0ms 23ms 0ms 46ms 87ms 212ms 17 54,608 0ms 88ms 0ms 75ms 191ms 534ms 18 51,648 0ms 18ms 0ms 59ms 81ms 152ms 19 51,528 0ms 21ms 0ms 59ms 92ms 176ms 20 52,417 0ms 20ms 0ms 57ms 92ms 459ms 21 51,738 0ms 13ms 0ms 53ms 87ms 158ms 22 51,616 0ms 16ms 0ms 50ms 90ms 180ms 23 51,610 0ms 16ms 0ms 54ms 105ms 166ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 25 00 22,849 0 0ms 22ms 33ms 346ms 01 17,885 0 0ms 21ms 28ms 117ms 02 17,585 0 0ms 22ms 30ms 106ms 03 17,716 0 0ms 23ms 31ms 108ms 04 17,912 0 0ms 22ms 32ms 130ms 05 17,890 0 0ms 22ms 34ms 130ms 06 17,892 0 0ms 22ms 43ms 131ms 07 17,895 0 0ms 22ms 43ms 135ms 08 17,903 0 0ms 23ms 34ms 129ms 09 17,847 0 0ms 23ms 31ms 132ms 10 17,877 0 0ms 21ms 33ms 130ms 11 17,891 0 0ms 22ms 32ms 129ms 12 17,882 0 0ms 22ms 31ms 132ms 13 17,840 0 0ms 20ms 36ms 136ms 14 17,835 0 0ms 21ms 37ms 74ms 15 17,892 0 0ms 21ms 33ms 139ms 16 17,854 0 0ms 22ms 36ms 134ms 17 20,700 0 0ms 23ms 44ms 254ms 18 17,906 0 0ms 21ms 31ms 100ms 19 17,898 0 0ms 21ms 38ms 114ms 20 18,460 0 0ms 21ms 36ms 130ms 21 17,933 0 0ms 21ms 33ms 128ms 22 17,913 0 0ms 20ms 38ms 128ms 23 17,894 0 0ms 21ms 35ms 131ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 25 00 88 54 96 0 0ms 1ms 4ms 8ms 01 88 54 96 0 0ms 0ms 6ms 7ms 02 88 51 96 0 0ms 1ms 6ms 9ms 03 88 54 96 0 0ms 1ms 4ms 8ms 04 88 53 99 0 0ms 0ms 5ms 8ms 05 88 53 93 0 0ms 1ms 3ms 8ms 06 88 52 98 0 0ms 0ms 6ms 9ms 07 88 51 93 0 1ms 0ms 6ms 8ms 08 88 54 95 0 2ms 1ms 5ms 7ms 09 88 52 90 0 1ms 1ms 5ms 8ms 10 88 52 88 0 1ms 0ms 6ms 14ms 11 88 52 90 0 1ms 0ms 5ms 7ms 12 88 51 83 0 1ms 1ms 4ms 8ms 13 88 50 82 0 1ms 1ms 5ms 8ms 14 88 51 79 0 1ms 0ms 5ms 8ms 15 88 52 80 0 0ms 1ms 6ms 8ms 16 88 51 82 0 0ms 0ms 4ms 8ms 17 94 60 83 0 0ms 1ms 4ms 10ms 18 88 51 80 0 0ms 0ms 4ms 8ms 19 88 64 82 0 0ms 1ms 6ms 8ms 20 182 112 111 0 0ms 1ms 6ms 10ms 21 88 50 81 0 0ms 0ms 2ms 7ms 22 88 50 83 0 0ms 1ms 6ms 7ms 23 88 51 79 0 0ms 0ms 5ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 25 00 33,737 56,989 1.69 93.82% 01 30,844 51,521 1.67 100.23% 02 30,877 51,277 1.66 101.25% 03 31,070 51,368 1.65 101.51% 04 30,871 51,628 1.67 100.12% 05 30,957 51,524 1.66 100.58% 06 30,916 51,524 1.67 100.46% 07 30,942 51,544 1.67 100.51% 08 30,854 51,559 1.67 100.19% 09 30,758 51,391 1.67 100.20% 10 30,454 51,567 1.69 98.92% 11 30,634 51,584 1.68 99.47% 12 30,806 51,526 1.67 100.13% 13 30,270 51,455 1.70 98.57% 14 30,353 51,470 1.70 98.81% 15 30,830 51,574 1.67 100.14% 16 30,763 51,409 1.67 100.21% 17 31,104 54,572 1.75 92.19% 18 30,846 51,612 1.67 100.13% 19 30,787 51,492 1.67 100.06% 20 31,008 52,381 1.69 98.19% 21 31,066 51,702 1.66 100.68% 22 31,052 51,580 1.66 100.83% 23 30,827 51,574 1.67 100.12% Day Hour Count Average / Second Dec 25 00 101 0.03/s 01 86 0.02/s 02 83 0.02/s 03 87 0.02/s 04 86 0.02/s 05 85 0.02/s 06 86 0.02/s 07 88 0.02/s 08 87 0.02/s 09 85 0.02/s 10 80 0.02/s 11 81 0.02/s 12 84 0.02/s 13 80 0.02/s 14 79 0.02/s 15 87 0.02/s 16 85 0.02/s 17 82 0.02/s 18 87 0.02/s 19 83 0.02/s 20 88 0.02/s 21 89 0.02/s 22 87 0.02/s 23 86 0.02/s Day Hour Count Average Duration Dec 25 00 101 6m3s 01 86 7m6s 02 83 6m52s 03 87 7m15s 04 86 6m56s 05 85 7m7s 06 86 6m53s 07 88 6m58s 08 87 6m48s 09 85 7m10s 10 80 7m10s 11 81 7m17s 12 84 7m32s 13 80 7m40s 14 79 7m17s 15 87 7m3s 16 85 7m3s 17 82 6m48s 18 87 7m13s 19 83 7m9s 20 88 6m49s 21 89 6m57s 22 87 6m46s 23 86 7m3s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2018-12-25 00:00:20 Date
Connections per database
Key values
- pharmisight Main Database
- 2,052 connections Total
Connections per user
Key values
- pharmisight Main User
- 2,052 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2018-12-25 14:11:18 Date
Histogram of session times
Key values
- 1,504 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,052 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 2,052 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,052 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,097 buffers Checkpoint Peak
- 2018-12-25 08:07:28 Date
- 149.594 seconds Highest write time
- 0.012 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2018-12-25 05:55:01 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 Dec 25 00 651 65.229s 0.026s 65.321s 01 369 37.026s 0.018s 37.107s 02 310 31.119s 0.007s 31.169s 03 419 42.049s 0.012s 42.11s 04 336 33.712s 0.017s 33.774s 05 374 37.535s 0.024s 37.601s 06 364 36.522s 0.011s 36.577s 07 1,232 123.6s 0.01s 123.651s 08 2,353 175.282s 0.013s 175.383s 09 1,333 133.215s 0.013s 133.275s 10 2,405 240.654s 0.011s 240.712s 11 1,940 194.381s 0.013s 194.449s 12 2,065 206.635s 0.007s 206.688s 13 2,560 255.985s 0.011s 256.042s 14 1,068 106.925s 0.014s 106.997s 15 926 92.845s 0.015s 92.905s 16 669 67.025s 0.01s 67.083s 17 472 47.369s 0.009s 47.436s 18 361 36.216s 0.012s 36.272s 19 530 53.164s 0.019s 53.229s 20 513 51.373s 0.012s 51.435s 21 500 50.165s 0.024s 50.242s 22 405 40.642s 0.011s 40.704s 23 587 58.887s 0.023s 58.981s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 25 00 0 0 0 302 0.010s 0s 01 0 0 0 235 0.002s 0s 02 0 0 0 208 0.001s 0s 03 0 0 0 221 0.001s 0s 04 0 0 0 210 0.008s 0s 05 0 0 1 211 0.008s 0s 06 0 0 0 213 0.002s 0s 07 0 0 0 202 0.002s 0s 08 0 0 1 222 0.003s 0s 09 0 0 0 227 0.003s 0s 10 0 0 1 218 0.002s 0s 11 0 0 0 236 0.002s 0s 12 0 0 0 209 0.002s 0s 13 0 0 1 211 0.002s 0s 14 0 0 0 234 0.003s 0s 15 0 0 0 238 0.002s 0s 16 0 0 1 239 0.002s 0s 17 0 0 0 235 0.002s 0s 18 0 0 0 216 0.002s 0s 19 0 0 0 237 0.010s 0s 20 0 0 0 252 0.002s 0s 21 0 0 0 230 0.010s 0s 22 0 0 0 226 0.002s 0s 23 0 0 0 240 0.008s 0s Day Hour Count Avg time (sec) Dec 25 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 Dec 25 00 221.92 kB 998.67 kB 01 142.50 kB 382.50 kB 02 129.25 kB 222.00 kB 03 178.22 kB 357.67 kB 04 151.25 kB 323.62 kB 05 183.75 kB 259.50 kB 06 173.88 kB 272.25 kB 07 833.00 kB 4,116.88 kB 08 1,341.12 kB 7,028.00 kB 09 1,167.50 kB 5,834.12 kB 10 915.50 kB 3,256.00 kB 11 736.67 kB 2,833.33 kB 12 856.25 kB 3,082.75 kB 13 1,020.38 kB 3,742.38 kB 14 391.56 kB 1,785.44 kB 15 348.22 kB 946.33 kB 16 188.50 kB 572.00 kB 17 134.56 kB 290.89 kB 18 113.33 kB 240.44 kB 19 187.00 kB 311.78 kB 20 168.38 kB 465.00 kB 21 157.00 kB 333.60 kB 22 143.00 kB 211.50 kB 23 156.33 kB 317.78 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 Dec 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (15) Main table analyzed (database pharmisight)
- 66 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data_event 13 pharmisight.public.sym_data 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_incoming_batch 6 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 2 pharmisight.public.sym_sequence 1 Total 66 Vacuums per table
Key values
- public.sym_outgoing_batch (12) Main table vacuumed on database pharmisight
- 50 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 12 12 pharmisight.public.sym_data 10 10 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.public.sym_incoming_batch 3 3 pharmisight.pg_catalog.pg_statistic 1 1 pharmisight.public.item_codes 1 1 pharmisight.public.sym_sequence 1 0 pharmisight.pg_toast.pg_toast_2619 1 1 Total 50 44 Tuples removed per table
Key values
- public.sym_data_event (41468) Main table with removed tuples on database pharmisight
- 60335 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 41468 1177 pharmisight.public.sym_data 10 10 12651 9927 pharmisight.public.sym_outgoing_batch 12 12 3985 135 pharmisight.public.sym_incoming_batch 3 3 1052 0 pharmisight.public.item_codes 1 1 355 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_catalog.pg_statistic 1 1 152 0 pharmisight.pg_toast.pg_toast_2619 1 1 55 0 pharmisight.public.sym_sequence 1 0 51 0 Total 50 44 60,335 11,239 Pages removed per table
Key values
- public.sym_data (9927) Main table with removed pages on database pharmisight
- 11239 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 12651 9927 pharmisight.public.sym_data_event 10 10 41468 1177 pharmisight.public.sym_outgoing_batch 12 12 3985 135 pharmisight.pg_catalog.pg_statistic 1 1 152 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.item_codes 1 1 355 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_incoming_batch 3 3 1052 0 pharmisight.pg_toast.pg_toast_2619 1 1 55 0 pharmisight.public.sym_node_host 5 0 260 0 Total 50 44 60,335 11,239 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 25 00 1 1 01 0 2 02 2 0 03 1 2 04 0 0 05 0 1 06 2 2 07 0 3 08 3 4 09 3 5 10 4 4 11 4 3 12 3 4 13 3 4 14 5 4 15 5 4 16 3 5 17 1 2 18 1 1 19 2 4 20 2 1 21 1 4 22 0 3 23 4 3 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 437,149 Total read queries
- 309,953 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,246,687 Requests
- 55s754ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,193,183 Requests
User Request type Count Duration pharmisight Total 102,215 6s815ms DELETE 31 2ms INSERT 41 7ms OTHERS 3,522 126ms SELECT 97,972 6s632ms TCL 588 26ms UPDATE 61 19ms symmetricds Total 1,193,183 50s657ms DDL 3 175ms DELETE 2,172 2s809ms INSERT 2,259 696ms OTHERS 516,833 7s947ms SELECT 354,246 31s818ms TCL 316,354 5s358ms UPDATE 1,316 1s850ms tony Total 900 233ms SELECT 900 233ms Duration by user
Key values
- 50s657ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 102,215 6s815ms DELETE 31 2ms INSERT 41 7ms OTHERS 3,522 126ms SELECT 97,972 6s632ms TCL 588 26ms UPDATE 61 19ms symmetricds Total 1,193,183 50s657ms DDL 3 175ms DELETE 2,172 2s809ms INSERT 2,259 696ms OTHERS 516,833 7s947ms SELECT 354,246 31s818ms TCL 316,354 5s358ms UPDATE 1,316 1s850ms tony Total 900 233ms SELECT 900 233ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,295,398 Requests
- 57s472ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,244,059 Requests
- 55s462ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2018-12-25 23:26:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,243,761 0-1ms duration
Slowest individual queries
Rank Duration Query 1 134ms 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: 2018-12-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 96ms ALTER TABLE "public"."sym_node_communication" DROP CONSTRAINT "sym_node_communication_pkey";[ Date: 2018-12-25 00:00:25 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 94ms 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: 2018-12-25 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 88ms SELECT epscheckli0_.EPS_CHECK_ID AS EPS_CHEC9_5_0_, epscheckli0_.EPS_CHECK_LINE_ID AS EPS_CHEC1_6_0_, epscheckli0_.EPS_CHECK_LINE_ID AS EPS_CHEC1_6_1_, epscheckli0_.orderLineId AS orderLin2_6_1_, epscheckli0_.snomed AS snomed3_6_1_, epscheckli0_.description AS descript4_6_1_, epscheckli0_.quantity AS quantity5_6_1_, epscheckli0_.isSnomedMismatch AS isSnomed6_6_1_, epscheckli0_.isOrderQtyMismatch AS isOrderQ7_6_1_, epscheckli0_.isHit AS isHit8_6_1_ FROM EPS_CHECK_LINES epscheckli0_ WHERE epscheckli0_.EPS_CHECK_ID = $1 ORDER BY epscheckli0_.description ASC;[ Date: 2018-12-25 17:39:48 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 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: 2018-12-25 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 70ms 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: 2018-12-25 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 66ms 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: 2018-12-25 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 61ms 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: 2018-12-25 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 58ms 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: 2018-12-25 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 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: 2018-12-25 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 50ms 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: 2018-12-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 48ms ALTER TABLE "public"."sym_node_communication" ADD PRIMARY KEY ("node_id", "queue", "communication_type");[ Date: 2018-12-25 00:00:25 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 47ms 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: 2018-12-25 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 44ms 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: 2018-12-25 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 44ms SELECT count(*) FROM information_schema.routines WHERE routine_name = 'sym_triggers_disabled' AND specific_schema = 'public';[ Date: 2018-12-25 00:00:25 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 41ms 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: 2018-12-25 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 40ms 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: 2018-12-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 39ms 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: 2018-12-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 37ms 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: 2018-12-25 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 37ms 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: 2018-12-25 08: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 14s65ms 25,778 0ms 5ms 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 Dec 25 00 1,070 576ms 0ms 01 1,074 582ms 0ms 02 1,074 592ms 0ms 03 1,074 590ms 0ms 04 1,074 587ms 0ms 05 1,074 584ms 0ms 06 1,074 589ms 0ms 07 1,074 581ms 0ms 08 1,074 592ms 0ms 09 1,074 591ms 0ms 10 1,077 587ms 0ms 11 1,074 572ms 0ms 12 1,074 583ms 0ms 13 1,074 586ms 0ms 14 1,074 580ms 0ms 15 1,074 596ms 0ms 16 1,074 597ms 0ms 17 1,074 583ms 0ms 18 1,074 581ms 0ms 19 1,074 586ms 0ms 20 1,074 577ms 0ms 21 1,077 596ms 0ms 22 1,074 582ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s65ms - Times executed: 25778 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s65ms - Times executed: 25778 ]
-
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: 2018-12-25 18:32:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:09:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:33:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s380ms 477,801 0ms 5ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 25 00 20,131 306ms 0ms 01 19,877 304ms 0ms 02 19,915 305ms 0ms 03 19,886 303ms 0ms 04 19,920 307ms 0ms 05 19,877 308ms 0ms 06 19,875 307ms 0ms 07 19,884 304ms 0ms 08 19,887 307ms 0ms 09 19,826 311ms 0ms 10 19,920 311ms 0ms 11 19,922 304ms 0ms 12 19,893 306ms 0ms 13 19,884 314ms 0ms 14 19,896 312ms 0ms 15 19,914 309ms 0ms 16 19,840 311ms 0ms 17 19,959 311ms 0ms 18 19,930 305ms 0ms 19 19,857 305ms 0ms 20 19,920 304ms 0ms 21 19,967 305ms 0ms 22 19,907 306ms 0ms 23 19,914 304ms 0ms [ User: symmetricds - Total duration: 7s336ms - Times executed: 476675 ]
[ User: pharmisight - Total duration: 44ms - Times executed: 1126 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s380ms - Times executed: 477801 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-25 17:42:46 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:55:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 13:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s244ms 152,136 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 25 00 6,434 169ms 0ms 01 6,324 178ms 0ms 02 6,338 175ms 0ms 03 6,326 171ms 0ms 04 6,341 167ms 0ms 05 6,328 168ms 0ms 06 6,322 178ms 0ms 07 6,330 165ms 0ms 08 6,327 171ms 0ms 09 6,311 175ms 0ms 10 6,340 181ms 0ms 11 6,338 175ms 0ms 12 6,331 177ms 0ms 13 6,325 168ms 0ms 14 6,333 176ms 0ms 15 6,337 165ms 0ms 16 6,312 173ms 0ms 17 6,400 184ms 0ms 18 6,341 180ms 0ms 19 6,319 176ms 0ms 20 6,357 202ms 0ms 21 6,352 164ms 0ms 22 6,331 179ms 0ms 23 6,339 214ms 0ms [ User: symmetricds - Total duration: 4s220ms - Times executed: 151851 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 285 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s244ms - Times executed: 152136 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-25 18:38:51 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:23:52 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:21:56 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s328ms 49,431 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 25 00 2,982 137ms 0ms 01 1,988 83ms 0ms 02 1,821 76ms 0ms 03 1,886 79ms 0ms 04 1,988 91ms 0ms 05 1,988 98ms 0ms 06 1,988 99ms 0ms 07 1,988 99ms 0ms 08 1,988 99ms 0ms 09 1,988 101ms 0ms 10 1,988 100ms 0ms 11 1,988 99ms 0ms 12 1,988 99ms 0ms 13 1,988 101ms 0ms 14 1,988 74ms 0ms 15 1,988 102ms 0ms 16 1,988 99ms 0ms 17 2,982 133ms 0ms 18 1,988 74ms 0ms 19 1,988 86ms 0ms 20 1,988 96ms 0ms 21 1,988 94ms 0ms 22 1,988 99ms 0ms 23 1,988 99ms 0ms [ User: pharmisight - Total duration: 2s328ms - Times executed: 49431 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s328ms - Times executed: 49431 ]
-
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: 2018-12-25 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s922ms 43,801 0ms 3ms 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 #5
Day Hour Count Duration Avg duration Dec 25 00 2,643 113ms 0ms 01 1,762 69ms 0ms 02 1,610 63ms 0ms 03 1,665 66ms 0ms 04 1,762 74ms 0ms 05 1,762 83ms 0ms 06 1,762 81ms 0ms 07 1,762 82ms 0ms 08 1,762 82ms 0ms 09 1,762 82ms 0ms 10 1,762 82ms 0ms 11 1,762 81ms 0ms 12 1,762 81ms 0ms 13 1,762 81ms 0ms 14 1,762 64ms 0ms 15 1,762 83ms 0ms 16 1,762 81ms 0ms 17 2,643 109ms 0ms 18 1,762 61ms 0ms 19 1,762 71ms 0ms 20 1,762 79ms 0ms 21 1,762 78ms 0ms 22 1,762 82ms 0ms 23 1,762 81ms 0ms [ User: pharmisight - Total duration: 1s922ms - Times executed: 43801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s922ms - Times executed: 43801 ]
-
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: 2018-12-25 14:00:00 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s885ms 115 0ms 134ms 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 #6
Day Hour Count Duration Avg duration Dec 25 00 9 63ms 7ms 01 9 63ms 7ms 02 9 61ms 6ms 03 9 61ms 6ms 04 9 77ms 8ms 05 9 60ms 6ms 06 9 64ms 7ms 07 9 152ms 16ms 08 8 371ms 46ms 09 7 213ms 30ms 10 6 182ms 30ms 11 5 127ms 25ms 12 4 107ms 26ms 13 3 82ms 27ms 14 1 94ms 94ms 15 1 25ms 25ms 16 1 15ms 15ms 17 1 9ms 9ms 18 1 8ms 8ms 19 1 9ms 9ms 20 1 16ms 16ms 21 1 9ms 9ms 22 1 2ms 2ms 23 1 3ms 3ms [ User: symmetricds - Total duration: 1s885ms - Times executed: 115 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s885ms - Times executed: 115 ]
-
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: 2018-12-25 08:00:00 Duration: 134ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:00:00 Duration: 94ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 10:00:00 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s833ms 172,503 0ms 2ms 0ms SELECT ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 25 00 8,039 80ms 0ms 01 7,155 75ms 0ms 02 7,167 76ms 0ms 03 7,155 75ms 0ms 04 7,169 77ms 0ms 05 7,152 76ms 0ms 06 7,151 74ms 0ms 07 7,147 74ms 0ms 08 7,157 75ms 0ms 09 7,131 75ms 0ms 10 7,157 78ms 0ms 11 7,160 74ms 0ms 12 7,146 79ms 0ms 13 7,136 77ms 0ms 14 7,137 75ms 0ms 15 7,147 76ms 0ms 16 7,126 76ms 0ms 17 7,178 77ms 0ms 18 7,151 74ms 0ms 19 7,129 75ms 0ms 20 7,160 75ms 0ms 21 7,162 78ms 0ms 22 7,147 76ms 0ms 23 7,144 75ms 0ms [ User: symmetricds - Total duration: 1s833ms - Times executed: 172503 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s833ms - Times executed: 172503 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-25 10:16:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 12:39:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 21:24:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s662ms 303 3ms 13ms 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 #8
Day Hour Count Duration Avg duration Dec 25 00 209 995ms 4ms 01 2 11ms 5ms 02 2 11ms 5ms 03 2 8ms 4ms 04 2 12ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 12ms 6ms 09 2 12ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 17ms 8ms 13 2 13ms 6ms 14 2 12ms 6ms 15 2 13ms 6ms 16 2 17ms 8ms 17 48 355ms 7ms 18 2 13ms 6ms 19 2 13ms 6ms 20 4 21ms 5ms 21 2 17ms 8ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 1s134ms - Times executed: 213 ]
[ User: pharmisight - Total duration: 527ms - Times executed: 90 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s662ms - Times executed: 303 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-12-25 17:38:41 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:38:41 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s244ms 25,876 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 #9
Day Hour Count Duration Avg duration Dec 25 00 1,072 52ms 0ms 01 1,078 51ms 0ms 02 1,078 51ms 0ms 03 1,078 51ms 0ms 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 51ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 52ms 0ms 10 1,081 52ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 51ms 0ms 16 1,078 51ms 0ms 17 1,080 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,080 51ms 0ms 21 1,081 51ms 0ms 22 1,078 52ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s244ms - Times executed: 25876 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s244ms - Times executed: 25876 ]
-
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: 2018-12-25 22:16:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 22:30:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:00:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s201ms 25,061 0ms 5ms 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 #10
Day Hour Count Duration Avg duration Dec 25 00 1,040 48ms 0ms 01 1,044 48ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,044 51ms 0ms 05 1,044 49ms 0ms 06 1,044 52ms 0ms 07 1,044 49ms 0ms 08 1,044 49ms 0ms 09 1,044 49ms 0ms 10 1,046 51ms 0ms 11 1,044 48ms 0ms 12 1,044 49ms 0ms 13 1,044 54ms 0ms 14 1,044 50ms 0ms 15 1,044 49ms 0ms 16 1,044 49ms 0ms 17 1,048 47ms 0ms 18 1,044 51ms 0ms 19 1,044 48ms 0ms 20 1,045 49ms 0ms 21 1,046 49ms 0ms 22 1,044 49ms 0ms 23 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s201ms - Times executed: 25061 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s201ms - Times executed: 25061 ]
-
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: 2018-12-25 13:40:44 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:44:38 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 998ms 192 0ms 10ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 25 00 8 42ms 5ms 01 8 51ms 6ms 02 8 44ms 5ms 03 8 46ms 5ms 04 8 39ms 4ms 05 8 41ms 5ms 06 8 41ms 5ms 07 8 40ms 5ms 08 8 39ms 4ms 09 8 40ms 5ms 10 8 40ms 5ms 11 8 44ms 5ms 12 8 39ms 4ms 13 8 46ms 5ms 14 8 45ms 5ms 15 8 46ms 5ms 16 8 34ms 4ms 17 8 27ms 3ms 18 8 34ms 4ms 19 8 46ms 5ms 20 8 39ms 4ms 21 8 35ms 4ms 22 8 42ms 5ms 23 8 45ms 5ms [ User: symmetricds - Total duration: 998ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 998ms - Times executed: 192 ]
-
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: 2018-12-25 01:24:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:36:46 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:38:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 935ms 152,140 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 25 00 6,435 38ms 0ms 01 6,325 38ms 0ms 02 6,338 38ms 0ms 03 6,327 39ms 0ms 04 6,341 38ms 0ms 05 6,328 38ms 0ms 06 6,323 38ms 0ms 07 6,329 38ms 0ms 08 6,328 39ms 0ms 09 6,310 39ms 0ms 10 6,340 39ms 0ms 11 6,338 38ms 0ms 12 6,331 39ms 0ms 13 6,325 40ms 0ms 14 6,333 39ms 0ms 15 6,337 38ms 0ms 16 6,312 38ms 0ms 17 6,401 39ms 0ms 18 6,341 38ms 0ms 19 6,319 38ms 0ms 20 6,357 39ms 0ms 21 6,352 39ms 0ms 22 6,331 38ms 0ms 23 6,339 38ms 0ms [ User: symmetricds - Total duration: 933ms - Times executed: 151851 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 289 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 152140 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-25 21:37:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:55:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:23:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 911ms 631 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 25 00 36 49ms 1ms 01 27 38ms 1ms 02 25 35ms 1ms 03 29 42ms 1ms 04 28 40ms 1ms 05 27 38ms 1ms 06 27 39ms 1ms 07 28 39ms 1ms 08 28 38ms 1ms 09 27 38ms 1ms 10 22 32ms 1ms 11 23 33ms 1ms 12 26 38ms 1ms 13 20 29ms 1ms 14 19 28ms 1ms 15 27 39ms 1ms 16 27 40ms 1ms 17 24 33ms 1ms 18 26 36ms 1ms 19 26 38ms 1ms 20 26 38ms 1ms 21 29 41ms 1ms 22 28 40ms 1ms 23 26 37ms 1ms [ User: symmetricds - Total duration: 911ms - Times executed: 631 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 911ms - Times executed: 631 ]
-
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: 2018-12-25 12:06:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:40:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:30:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 812ms 50 6ms 30ms 16ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 25 00 3 44ms 14ms 01 2 40ms 20ms 02 2 27ms 13ms 03 2 29ms 14ms 04 2 39ms 19ms 05 2 26ms 13ms 06 2 37ms 18ms 07 2 32ms 16ms 08 2 30ms 15ms 09 2 48ms 24ms 10 2 26ms 13ms 11 2 41ms 20ms 12 2 33ms 16ms 13 2 40ms 20ms 14 2 20ms 10ms 15 2 31ms 15ms 16 2 35ms 17ms 17 3 42ms 14ms 18 2 27ms 13ms 19 2 34ms 17ms 20 2 34ms 17ms 21 2 26ms 13ms 22 2 30ms 15ms 23 2 30ms 15ms [ User: pharmisight - Total duration: 812ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 812ms - Times executed: 50 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2018-12-25 09:00:00 Duration: 30ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:00:00 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:00:00 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 776ms 849 0ms 1ms 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 #15
Day Hour Count Duration Avg duration Dec 25 00 45 39ms 0ms 01 34 31ms 0ms 02 36 34ms 0ms 03 36 32ms 0ms 04 36 32ms 0ms 05 37 34ms 0ms 06 38 34ms 0ms 07 40 37ms 0ms 08 38 34ms 0ms 09 37 34ms 0ms 10 33 29ms 0ms 11 32 29ms 0ms 12 35 32ms 0ms 13 27 25ms 0ms 14 26 23ms 0ms 15 35 32ms 0ms 16 38 33ms 0ms 17 36 31ms 0ms 18 35 31ms 0ms 19 36 33ms 0ms 20 36 32ms 0ms 21 37 33ms 0ms 22 32 29ms 0ms 23 34 31ms 0ms [ User: symmetricds - Total duration: 776ms - Times executed: 849 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 776ms - Times executed: 849 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 00:08:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:02:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 02:18:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 733ms 6,779 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 #16
Day Hour Count Duration Avg duration Dec 25 00 269 28ms 0ms 01 281 29ms 0ms 02 286 30ms 0ms 03 281 32ms 0ms 04 287 31ms 0ms 05 282 30ms 0ms 06 279 30ms 0ms 07 284 33ms 0ms 08 280 30ms 0ms 09 275 30ms 0ms 10 282 29ms 0ms 11 287 30ms 0ms 12 283 33ms 0ms 13 282 31ms 0ms 14 284 30ms 0ms 15 287 30ms 0ms 16 275 29ms 0ms 17 283 31ms 0ms 18 289 30ms 0ms 19 278 29ms 0ms 20 283 29ms 0ms 21 291 30ms 0ms 22 283 29ms 0ms 23 288 29ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6779 ]
-
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: 2018-12-25 12:33:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:35:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 07:31:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 710ms 166 1ms 15ms 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 #17
Day Hour Count Duration Avg duration Dec 25 00 5 20ms 4ms 01 7 29ms 4ms 02 5 21ms 4ms 03 5 19ms 3ms 04 6 24ms 4ms 05 6 27ms 4ms 06 8 32ms 4ms 07 8 27ms 3ms 08 5 26ms 5ms 09 4 15ms 3ms 10 7 24ms 3ms 11 8 30ms 3ms 12 6 26ms 4ms 13 6 21ms 3ms 14 7 29ms 4ms 15 7 33ms 4ms 16 9 36ms 4ms 17 10 51ms 5ms 18 6 26ms 4ms 19 8 39ms 4ms 20 7 39ms 5ms 21 8 27ms 3ms 22 9 42ms 4ms 23 9 37ms 4ms [ User: symmetricds - Total duration: 710ms - Times executed: 166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 166 ]
-
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: 2018-12-25 20:45:48 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 19:15:47 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:39:46 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 638ms 4,419 0ms 5ms 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 #18
Day Hour Count Duration Avg duration Dec 25 00 184 21ms 0ms 01 184 17ms 0ms 02 184 18ms 0ms 03 184 18ms 0ms 04 184 18ms 0ms 05 184 17ms 0ms 06 184 16ms 0ms 07 184 75ms 0ms 08 184 68ms 0ms 09 184 72ms 0ms 10 184 19ms 0ms 11 184 16ms 0ms 12 184 16ms 0ms 13 184 16ms 0ms 14 184 20ms 0ms 15 184 17ms 0ms 16 184 50ms 0ms 17 186 37ms 0ms 18 184 15ms 0ms 19 184 16ms 0ms 20 185 17ms 0ms 21 184 16ms 0ms 22 184 17ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 638ms - Times executed: 4419 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 638ms - Times executed: 4419 ]
-
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: 2018-12-25 07:27:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:42:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:51:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 568ms 632 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 25 00 36 31ms 0ms 01 27 24ms 0ms 02 25 22ms 0ms 03 29 26ms 0ms 04 28 25ms 0ms 05 27 23ms 0ms 06 27 25ms 0ms 07 28 25ms 0ms 08 28 24ms 0ms 09 27 24ms 0ms 10 22 18ms 0ms 11 23 20ms 0ms 12 26 23ms 0ms 13 20 18ms 0ms 14 19 17ms 0ms 15 27 24ms 0ms 16 27 23ms 0ms 17 24 21ms 0ms 18 26 23ms 0ms 19 26 23ms 0ms 20 26 23ms 0ms 21 30 26ms 0ms 22 28 25ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 568ms - Times executed: 632 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 568ms - Times executed: 632 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 21:22:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:58:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:04:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 547ms 630 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 25 00 35 29ms 0ms 01 27 23ms 0ms 02 25 22ms 0ms 03 29 24ms 0ms 04 28 24ms 0ms 05 27 23ms 0ms 06 27 24ms 0ms 07 28 24ms 0ms 08 28 24ms 0ms 09 27 23ms 0ms 10 22 18ms 0ms 11 23 19ms 0ms 12 26 22ms 0ms 13 20 17ms 0ms 14 19 16ms 0ms 15 27 23ms 0ms 16 27 22ms 0ms 17 24 20ms 0ms 18 26 22ms 0ms 19 26 22ms 0ms 20 26 22ms 0ms 21 29 25ms 0ms 22 28 24ms 0ms 23 26 22ms 0ms [ User: symmetricds - Total duration: 547ms - Times executed: 630 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 547ms - Times executed: 630 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 12:36:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:02:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 08:00:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 477,801 7s380ms 0ms 5ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 25 00 20,131 306ms 0ms 01 19,877 304ms 0ms 02 19,915 305ms 0ms 03 19,886 303ms 0ms 04 19,920 307ms 0ms 05 19,877 308ms 0ms 06 19,875 307ms 0ms 07 19,884 304ms 0ms 08 19,887 307ms 0ms 09 19,826 311ms 0ms 10 19,920 311ms 0ms 11 19,922 304ms 0ms 12 19,893 306ms 0ms 13 19,884 314ms 0ms 14 19,896 312ms 0ms 15 19,914 309ms 0ms 16 19,840 311ms 0ms 17 19,959 311ms 0ms 18 19,930 305ms 0ms 19 19,857 305ms 0ms 20 19,920 304ms 0ms 21 19,967 305ms 0ms 22 19,907 306ms 0ms 23 19,914 304ms 0ms [ User: symmetricds - Total duration: 7s336ms - Times executed: 476675 ]
[ User: pharmisight - Total duration: 44ms - Times executed: 1126 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s380ms - Times executed: 477801 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2018-12-25 17:42:46 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:55:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 13:00:00 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 172,503 1s833ms 0ms 2ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 25 00 8,039 80ms 0ms 01 7,155 75ms 0ms 02 7,167 76ms 0ms 03 7,155 75ms 0ms 04 7,169 77ms 0ms 05 7,152 76ms 0ms 06 7,151 74ms 0ms 07 7,147 74ms 0ms 08 7,157 75ms 0ms 09 7,131 75ms 0ms 10 7,157 78ms 0ms 11 7,160 74ms 0ms 12 7,146 79ms 0ms 13 7,136 77ms 0ms 14 7,137 75ms 0ms 15 7,147 76ms 0ms 16 7,126 76ms 0ms 17 7,178 77ms 0ms 18 7,151 74ms 0ms 19 7,129 75ms 0ms 20 7,160 75ms 0ms 21 7,162 78ms 0ms 22 7,147 76ms 0ms 23 7,144 75ms 0ms [ User: symmetricds - Total duration: 1s833ms - Times executed: 172503 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s833ms - Times executed: 172503 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2018-12-25 10:16:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 12:39:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 21:24:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 152,140 935ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 25 00 6,435 38ms 0ms 01 6,325 38ms 0ms 02 6,338 38ms 0ms 03 6,327 39ms 0ms 04 6,341 38ms 0ms 05 6,328 38ms 0ms 06 6,323 38ms 0ms 07 6,329 38ms 0ms 08 6,328 39ms 0ms 09 6,310 39ms 0ms 10 6,340 39ms 0ms 11 6,338 38ms 0ms 12 6,331 39ms 0ms 13 6,325 40ms 0ms 14 6,333 39ms 0ms 15 6,337 38ms 0ms 16 6,312 38ms 0ms 17 6,401 39ms 0ms 18 6,341 38ms 0ms 19 6,319 38ms 0ms 20 6,357 39ms 0ms 21 6,352 39ms 0ms 22 6,331 38ms 0ms 23 6,339 38ms 0ms [ User: symmetricds - Total duration: 933ms - Times executed: 151851 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 289 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 935ms - Times executed: 152140 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2018-12-25 21:37:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:55:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:23:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 152,136 4s244ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 25 00 6,434 169ms 0ms 01 6,324 178ms 0ms 02 6,338 175ms 0ms 03 6,326 171ms 0ms 04 6,341 167ms 0ms 05 6,328 168ms 0ms 06 6,322 178ms 0ms 07 6,330 165ms 0ms 08 6,327 171ms 0ms 09 6,311 175ms 0ms 10 6,340 181ms 0ms 11 6,338 175ms 0ms 12 6,331 177ms 0ms 13 6,325 168ms 0ms 14 6,333 176ms 0ms 15 6,337 165ms 0ms 16 6,312 173ms 0ms 17 6,400 184ms 0ms 18 6,341 180ms 0ms 19 6,319 176ms 0ms 20 6,357 202ms 0ms 21 6,352 164ms 0ms 22 6,331 179ms 0ms 23 6,339 214ms 0ms [ User: symmetricds - Total duration: 4s220ms - Times executed: 151851 ]
[ User: pharmisight - Total duration: 24ms - Times executed: 285 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s244ms - Times executed: 152136 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2018-12-25 18:38:51 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:23:52 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:21:56 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 49,431 2s328ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 25 00 2,982 137ms 0ms 01 1,988 83ms 0ms 02 1,821 76ms 0ms 03 1,886 79ms 0ms 04 1,988 91ms 0ms 05 1,988 98ms 0ms 06 1,988 99ms 0ms 07 1,988 99ms 0ms 08 1,988 99ms 0ms 09 1,988 101ms 0ms 10 1,988 100ms 0ms 11 1,988 99ms 0ms 12 1,988 99ms 0ms 13 1,988 101ms 0ms 14 1,988 74ms 0ms 15 1,988 102ms 0ms 16 1,988 99ms 0ms 17 2,982 133ms 0ms 18 1,988 74ms 0ms 19 1,988 86ms 0ms 20 1,988 96ms 0ms 21 1,988 94ms 0ms 22 1,988 99ms 0ms 23 1,988 99ms 0ms [ User: pharmisight - Total duration: 2s328ms - Times executed: 49431 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s328ms - Times executed: 49431 ]
-
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: 2018-12-25 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 43,801 1s922ms 0ms 3ms 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 #6
Day Hour Count Duration Avg duration Dec 25 00 2,643 113ms 0ms 01 1,762 69ms 0ms 02 1,610 63ms 0ms 03 1,665 66ms 0ms 04 1,762 74ms 0ms 05 1,762 83ms 0ms 06 1,762 81ms 0ms 07 1,762 82ms 0ms 08 1,762 82ms 0ms 09 1,762 82ms 0ms 10 1,762 82ms 0ms 11 1,762 81ms 0ms 12 1,762 81ms 0ms 13 1,762 81ms 0ms 14 1,762 64ms 0ms 15 1,762 83ms 0ms 16 1,762 81ms 0ms 17 2,643 109ms 0ms 18 1,762 61ms 0ms 19 1,762 71ms 0ms 20 1,762 79ms 0ms 21 1,762 78ms 0ms 22 1,762 82ms 0ms 23 1,762 81ms 0ms [ User: pharmisight - Total duration: 1s922ms - Times executed: 43801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s922ms - Times executed: 43801 ]
-
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: 2018-12-25 14:00:00 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,876 1s244ms 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 #7
Day Hour Count Duration Avg duration Dec 25 00 1,072 52ms 0ms 01 1,078 51ms 0ms 02 1,078 51ms 0ms 03 1,078 51ms 0ms 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 51ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 52ms 0ms 10 1,081 52ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 51ms 0ms 16 1,078 51ms 0ms 17 1,080 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,080 51ms 0ms 21 1,081 51ms 0ms 22 1,078 52ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s244ms - Times executed: 25876 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s244ms - Times executed: 25876 ]
-
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: 2018-12-25 22:16:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 22:30:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:00:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 25,778 14s65ms 0ms 5ms 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 #8
Day Hour Count Duration Avg duration Dec 25 00 1,070 576ms 0ms 01 1,074 582ms 0ms 02 1,074 592ms 0ms 03 1,074 590ms 0ms 04 1,074 587ms 0ms 05 1,074 584ms 0ms 06 1,074 589ms 0ms 07 1,074 581ms 0ms 08 1,074 592ms 0ms 09 1,074 591ms 0ms 10 1,077 587ms 0ms 11 1,074 572ms 0ms 12 1,074 583ms 0ms 13 1,074 586ms 0ms 14 1,074 580ms 0ms 15 1,074 596ms 0ms 16 1,074 597ms 0ms 17 1,074 583ms 0ms 18 1,074 581ms 0ms 19 1,074 586ms 0ms 20 1,074 577ms 0ms 21 1,077 596ms 0ms 22 1,074 582ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s65ms - Times executed: 25778 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s65ms - Times executed: 25778 ]
-
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: 2018-12-25 18:32:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:09:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:33:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 25,061 1s201ms 0ms 5ms 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 #9
Day Hour Count Duration Avg duration Dec 25 00 1,040 48ms 0ms 01 1,044 48ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,044 51ms 0ms 05 1,044 49ms 0ms 06 1,044 52ms 0ms 07 1,044 49ms 0ms 08 1,044 49ms 0ms 09 1,044 49ms 0ms 10 1,046 51ms 0ms 11 1,044 48ms 0ms 12 1,044 49ms 0ms 13 1,044 54ms 0ms 14 1,044 50ms 0ms 15 1,044 49ms 0ms 16 1,044 49ms 0ms 17 1,048 47ms 0ms 18 1,044 51ms 0ms 19 1,044 48ms 0ms 20 1,045 49ms 0ms 21 1,046 49ms 0ms 22 1,044 49ms 0ms 23 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s201ms - Times executed: 25061 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s201ms - Times executed: 25061 ]
-
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: 2018-12-25 13:40:44 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:44:38 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,264 452ms 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 Dec 25 00 716 18ms 0ms 01 718 19ms 0ms 02 720 19ms 0ms 03 720 18ms 0ms 04 720 18ms 0ms 05 718 18ms 0ms 06 720 19ms 0ms 07 720 18ms 0ms 08 720 18ms 0ms 09 718 19ms 0ms 10 720 19ms 0ms 11 720 18ms 0ms 12 720 18ms 0ms 13 718 19ms 0ms 14 720 18ms 0ms 15 720 18ms 0ms 16 720 18ms 0ms 17 718 18ms 0ms 18 720 18ms 0ms 19 720 18ms 0ms 20 720 18ms 0ms 21 718 18ms 0ms 22 720 19ms 0ms 23 720 18ms 0ms [ User: symmetricds - Total duration: 452ms - Times executed: 17264 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 452ms - Times executed: 17264 ]
-
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: 2018-12-25 09:49:41 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 13:08:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 02:24:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,128 107ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 25 00 378 4ms 0ms 01 380 4ms 0ms 02 380 4ms 0ms 03 380 4ms 0ms 04 380 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 381 4ms 0ms 11 380 4ms 0ms 12 380 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 380 4ms 0ms 16 380 4ms 0ms 17 384 4ms 0ms 18 380 4ms 0ms 19 380 4ms 0ms 20 384 4ms 0ms 21 380 4ms 0ms 22 381 4ms 0ms 23 380 4ms 0ms [ User: symmetricds - Total duration: 107ms - Times executed: 9128 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 107ms - Times executed: 9128 ]
-
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: 2018-12-25 14:47:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:23:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 13:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,128 142ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 25 00 378 5ms 0ms 01 380 5ms 0ms 02 380 6ms 0ms 03 381 5ms 0ms 04 382 5ms 0ms 05 377 5ms 0ms 06 382 5ms 0ms 07 378 5ms 0ms 08 383 5ms 0ms 09 377 5ms 0ms 10 381 6ms 0ms 11 383 5ms 0ms 12 379 5ms 0ms 13 381 6ms 0ms 14 377 5ms 0ms 15 380 5ms 0ms 16 380 6ms 0ms 17 386 6ms 0ms 18 381 5ms 0ms 19 379 5ms 0ms 20 382 6ms 0ms 21 381 5ms 0ms 22 382 6ms 0ms 23 378 5ms 0ms [ User: symmetricds - Total duration: 142ms - Times executed: 9128 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 142ms - Times executed: 9128 ]
-
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: 2018-12-25 22:07:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:05:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:00:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,593 394ms 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 #13
Day Hour Count Duration Avg duration Dec 25 00 357 16ms 0ms 01 358 16ms 0ms 02 358 15ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 17ms 0ms 10 359 16ms 0ms 11 358 15ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 358 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 15ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 394ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 394ms - 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: 2018-12-25 09:38:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:56:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:27:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,592 292ms 0ms 0ms 0ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 25 00 356 12ms 0ms 01 358 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 359 12ms 0ms 11 358 11ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 11ms 0ms 20 358 12ms 0ms 21 359 12ms 0ms 22 358 11ms 0ms 23 358 12ms 0ms [ User: symmetricds - Total duration: 292ms - Times executed: 8592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 292ms - Times executed: 8592 ]
-
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: 2018-12-25 22:03:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:52:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:28:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,592 267ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 25 00 356 10ms 0ms 01 358 10ms 0ms 02 358 11ms 0ms 03 358 10ms 0ms 04 358 11ms 0ms 05 358 10ms 0ms 06 358 11ms 0ms 07 358 12ms 0ms 08 358 10ms 0ms 09 358 10ms 0ms 10 359 10ms 0ms 11 358 10ms 0ms 12 358 10ms 0ms 13 358 10ms 0ms 14 358 10ms 0ms 15 358 10ms 0ms 16 358 11ms 0ms 17 358 11ms 0ms 18 358 11ms 0ms 19 358 11ms 0ms 20 358 11ms 0ms 21 358 11ms 0ms 22 359 12ms 0ms 23 358 10ms 0ms [ User: symmetricds - Total duration: 267ms - Times executed: 8592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 267ms - Times executed: 8592 ]
-
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: 2018-12-25 06:18:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 22:07:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 07:42:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,592 207ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 25 00 356 8ms 0ms 01 358 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 9ms 0ms 10 359 9ms 0ms 11 358 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 358 8ms 0ms 15 358 8ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 359 8ms 0ms 23 358 8ms 0ms [ User: symmetricds - Total duration: 207ms - Times executed: 8592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 207ms - Times executed: 8592 ]
-
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: 2018-12-25 06:19:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 18:05:55 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:17:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,779 302ms 0ms 1ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 25 00 269 11ms 0ms 01 281 12ms 0ms 02 286 12ms 0ms 03 281 12ms 0ms 04 287 14ms 0ms 05 282 12ms 0ms 06 279 12ms 0ms 07 284 12ms 0ms 08 280 12ms 0ms 09 275 12ms 0ms 10 282 12ms 0ms 11 287 12ms 0ms 12 283 12ms 0ms 13 282 12ms 0ms 14 284 12ms 0ms 15 287 12ms 0ms 16 275 12ms 0ms 17 283 12ms 0ms 18 289 12ms 0ms 19 278 12ms 0ms 20 283 12ms 0ms 21 291 12ms 0ms 22 283 12ms 0ms 23 288 12ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 6779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 6779 ]
-
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: 2018-12-25 04:05:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 15:24:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:34:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,779 733ms 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 Dec 25 00 269 28ms 0ms 01 281 29ms 0ms 02 286 30ms 0ms 03 281 32ms 0ms 04 287 31ms 0ms 05 282 30ms 0ms 06 279 30ms 0ms 07 284 33ms 0ms 08 280 30ms 0ms 09 275 30ms 0ms 10 282 29ms 0ms 11 287 30ms 0ms 12 283 33ms 0ms 13 282 31ms 0ms 14 284 30ms 0ms 15 287 30ms 0ms 16 275 29ms 0ms 17 283 31ms 0ms 18 289 30ms 0ms 19 278 29ms 0ms 20 283 29ms 0ms 21 291 30ms 0ms 22 283 29ms 0ms 23 288 29ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6779 ]
-
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: 2018-12-25 12:33:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:35:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 07:31:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,419 638ms 0ms 5ms 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 Dec 25 00 184 21ms 0ms 01 184 17ms 0ms 02 184 18ms 0ms 03 184 18ms 0ms 04 184 18ms 0ms 05 184 17ms 0ms 06 184 16ms 0ms 07 184 75ms 0ms 08 184 68ms 0ms 09 184 72ms 0ms 10 184 19ms 0ms 11 184 16ms 0ms 12 184 16ms 0ms 13 184 16ms 0ms 14 184 20ms 0ms 15 184 17ms 0ms 16 184 50ms 0ms 17 186 37ms 0ms 18 184 15ms 0ms 19 184 16ms 0ms 20 185 17ms 0ms 21 184 16ms 0ms 22 184 17ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 638ms - Times executed: 4419 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 638ms - Times executed: 4419 ]
-
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: 2018-12-25 07:27:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:42:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:51:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,764 67ms 0ms 0ms 0ms SET extra_float_digits = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 25 00 89 3ms 0ms 01 74 2ms 0ms 02 71 2ms 0ms 03 75 2ms 0ms 04 74 2ms 0ms 05 73 2ms 0ms 06 74 2ms 0ms 07 76 2ms 0ms 08 75 2ms 0ms 09 73 2ms 0ms 10 68 2ms 0ms 11 69 2ms 0ms 12 72 2ms 0ms 13 68 2ms 0ms 14 67 2ms 0ms 15 75 2ms 0ms 16 73 2ms 0ms 17 70 2ms 0ms 18 75 2ms 0ms 19 71 2ms 0ms 20 76 2ms 0ms 21 77 2ms 0ms 22 75 2ms 0ms 23 74 2ms 0ms [ User: pharmisight - Total duration: 43ms - Times executed: 1126 ]
[ User: symmetricds - Total duration: 24ms - Times executed: 638 ]
[ Application: [unknown] - Total duration: 67ms - Times executed: 1764 ]
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
Date: 2018-12-25 04:54:19 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-25 20:32:24 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-25 11:51:49 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 134ms 16ms 115 1s885ms 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 #1
Day Hour Count Duration Avg duration Dec 25 00 9 63ms 7ms 01 9 63ms 7ms 02 9 61ms 6ms 03 9 61ms 6ms 04 9 77ms 8ms 05 9 60ms 6ms 06 9 64ms 7ms 07 9 152ms 16ms 08 8 371ms 46ms 09 7 213ms 30ms 10 6 182ms 30ms 11 5 127ms 25ms 12 4 107ms 26ms 13 3 82ms 27ms 14 1 94ms 94ms 15 1 25ms 25ms 16 1 15ms 15ms 17 1 9ms 9ms 18 1 8ms 8ms 19 1 9ms 9ms 20 1 16ms 16ms 21 1 9ms 9ms 22 1 2ms 2ms 23 1 3ms 3ms [ User: symmetricds - Total duration: 1s885ms - Times executed: 115 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s885ms - Times executed: 115 ]
-
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: 2018-12-25 08:00:00 Duration: 134ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:00:00 Duration: 94ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 10:00:00 Duration: 71ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6ms 30ms 16ms 50 812ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 25 00 3 44ms 14ms 01 2 40ms 20ms 02 2 27ms 13ms 03 2 29ms 14ms 04 2 39ms 19ms 05 2 26ms 13ms 06 2 37ms 18ms 07 2 32ms 16ms 08 2 30ms 15ms 09 2 48ms 24ms 10 2 26ms 13ms 11 2 41ms 20ms 12 2 33ms 16ms 13 2 40ms 20ms 14 2 20ms 10ms 15 2 31ms 15ms 16 2 35ms 17ms 17 3 42ms 14ms 18 2 27ms 13ms 19 2 34ms 17ms 20 2 34ms 17ms 21 2 26ms 13ms 22 2 30ms 15ms 23 2 30ms 15ms [ User: pharmisight - Total duration: 812ms - Times executed: 50 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 812ms - Times executed: 50 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2018-12-25 09:00:00 Duration: 30ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:00:00 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:00:00 Duration: 26ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 13ms 5ms 303 1s662ms 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 #3
Day Hour Count Duration Avg duration Dec 25 00 209 995ms 4ms 01 2 11ms 5ms 02 2 11ms 5ms 03 2 8ms 4ms 04 2 12ms 6ms 05 2 13ms 6ms 06 2 13ms 6ms 07 2 13ms 6ms 08 2 12ms 6ms 09 2 12ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 17ms 8ms 13 2 13ms 6ms 14 2 12ms 6ms 15 2 13ms 6ms 16 2 17ms 8ms 17 48 355ms 7ms 18 2 13ms 6ms 19 2 13ms 6ms 20 4 21ms 5ms 21 2 17ms 8ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 1s134ms - Times executed: 213 ]
[ User: pharmisight - Total duration: 527ms - Times executed: 90 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s662ms - Times executed: 303 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2018-12-25 17:38:41 Duration: 13ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:38:41 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 10ms 5ms 192 998ms 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 #4
Day Hour Count Duration Avg duration Dec 25 00 8 42ms 5ms 01 8 51ms 6ms 02 8 44ms 5ms 03 8 46ms 5ms 04 8 39ms 4ms 05 8 41ms 5ms 06 8 41ms 5ms 07 8 40ms 5ms 08 8 39ms 4ms 09 8 40ms 5ms 10 8 40ms 5ms 11 8 44ms 5ms 12 8 39ms 4ms 13 8 46ms 5ms 14 8 45ms 5ms 15 8 46ms 5ms 16 8 34ms 4ms 17 8 27ms 3ms 18 8 34ms 4ms 19 8 46ms 5ms 20 8 39ms 4ms 21 8 35ms 4ms 22 8 42ms 5ms 23 8 45ms 5ms [ User: symmetricds - Total duration: 998ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 998ms - Times executed: 192 ]
-
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: 2018-12-25 01:24:46 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:36:46 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:38:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 15ms 4ms 166 710ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 25 00 5 20ms 4ms 01 7 29ms 4ms 02 5 21ms 4ms 03 5 19ms 3ms 04 6 24ms 4ms 05 6 27ms 4ms 06 8 32ms 4ms 07 8 27ms 3ms 08 5 26ms 5ms 09 4 15ms 3ms 10 7 24ms 3ms 11 8 30ms 3ms 12 6 26ms 4ms 13 6 21ms 3ms 14 7 29ms 4ms 15 7 33ms 4ms 16 9 36ms 4ms 17 10 51ms 5ms 18 6 26ms 4ms 19 8 39ms 4ms 20 7 39ms 5ms 21 8 27ms 3ms 22 9 42ms 4ms 23 9 37ms 4ms [ User: symmetricds - Total duration: 710ms - Times executed: 166 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 166 ]
-
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: 2018-12-25 20:45:48 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 19:15:47 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:39:46 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 2ms 1ms 631 911ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 25 00 36 49ms 1ms 01 27 38ms 1ms 02 25 35ms 1ms 03 29 42ms 1ms 04 28 40ms 1ms 05 27 38ms 1ms 06 27 39ms 1ms 07 28 39ms 1ms 08 28 38ms 1ms 09 27 38ms 1ms 10 22 32ms 1ms 11 23 33ms 1ms 12 26 38ms 1ms 13 20 29ms 1ms 14 19 28ms 1ms 15 27 39ms 1ms 16 27 40ms 1ms 17 24 33ms 1ms 18 26 36ms 1ms 19 26 38ms 1ms 20 26 38ms 1ms 21 29 41ms 1ms 22 28 40ms 1ms 23 26 37ms 1ms [ User: symmetricds - Total duration: 911ms - Times executed: 631 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 911ms - Times executed: 631 ]
-
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: 2018-12-25 12:06:30 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:40:44 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:30:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 1ms 0ms 849 776ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 25 00 45 39ms 0ms 01 34 31ms 0ms 02 36 34ms 0ms 03 36 32ms 0ms 04 36 32ms 0ms 05 37 34ms 0ms 06 38 34ms 0ms 07 40 37ms 0ms 08 38 34ms 0ms 09 37 34ms 0ms 10 33 29ms 0ms 11 32 29ms 0ms 12 35 32ms 0ms 13 27 25ms 0ms 14 26 23ms 0ms 15 35 32ms 0ms 16 38 33ms 0ms 17 36 31ms 0ms 18 35 31ms 0ms 19 36 33ms 0ms 20 36 32ms 0ms 21 37 33ms 0ms 22 32 29ms 0ms 23 34 31ms 0ms [ User: symmetricds - Total duration: 776ms - Times executed: 849 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 776ms - Times executed: 849 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 00:08:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:02:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 02:18:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 632 568ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 25 00 36 31ms 0ms 01 27 24ms 0ms 02 25 22ms 0ms 03 29 26ms 0ms 04 28 25ms 0ms 05 27 23ms 0ms 06 27 25ms 0ms 07 28 25ms 0ms 08 28 24ms 0ms 09 27 24ms 0ms 10 22 18ms 0ms 11 23 20ms 0ms 12 26 23ms 0ms 13 20 18ms 0ms 14 19 17ms 0ms 15 27 24ms 0ms 16 27 23ms 0ms 17 24 21ms 0ms 18 26 23ms 0ms 19 26 23ms 0ms 20 26 23ms 0ms 21 30 26ms 0ms 22 28 25ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 568ms - Times executed: 632 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 568ms - Times executed: 632 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 21:22:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 23:58:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 11:04:50 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 630 547ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 25 00 35 29ms 0ms 01 27 23ms 0ms 02 25 22ms 0ms 03 29 24ms 0ms 04 28 24ms 0ms 05 27 23ms 0ms 06 27 24ms 0ms 07 28 24ms 0ms 08 28 24ms 0ms 09 27 23ms 0ms 10 22 18ms 0ms 11 23 19ms 0ms 12 26 22ms 0ms 13 20 17ms 0ms 14 19 16ms 0ms 15 27 23ms 0ms 16 27 22ms 0ms 17 24 20ms 0ms 18 26 22ms 0ms 19 26 22ms 0ms 20 26 22ms 0ms 21 29 25ms 0ms 22 28 24ms 0ms 23 26 22ms 0ms [ User: symmetricds - Total duration: 547ms - Times executed: 630 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 547ms - Times executed: 630 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2018-12-25 12:36:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 00:02:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 08:00:01 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 5ms 0ms 25,778 14s65ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 25 00 1,070 576ms 0ms 01 1,074 582ms 0ms 02 1,074 592ms 0ms 03 1,074 590ms 0ms 04 1,074 587ms 0ms 05 1,074 584ms 0ms 06 1,074 589ms 0ms 07 1,074 581ms 0ms 08 1,074 592ms 0ms 09 1,074 591ms 0ms 10 1,077 587ms 0ms 11 1,074 572ms 0ms 12 1,074 583ms 0ms 13 1,074 586ms 0ms 14 1,074 580ms 0ms 15 1,074 596ms 0ms 16 1,074 597ms 0ms 17 1,074 583ms 0ms 18 1,074 581ms 0ms 19 1,074 586ms 0ms 20 1,074 577ms 0ms 21 1,077 596ms 0ms 22 1,074 582ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s65ms - Times executed: 25778 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s65ms - Times executed: 25778 ]
-
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: 2018-12-25 18:32:24 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:09:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:33:15 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 5ms 0ms 4,419 638ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 25 00 184 21ms 0ms 01 184 17ms 0ms 02 184 18ms 0ms 03 184 18ms 0ms 04 184 18ms 0ms 05 184 17ms 0ms 06 184 16ms 0ms 07 184 75ms 0ms 08 184 68ms 0ms 09 184 72ms 0ms 10 184 19ms 0ms 11 184 16ms 0ms 12 184 16ms 0ms 13 184 16ms 0ms 14 184 20ms 0ms 15 184 17ms 0ms 16 184 50ms 0ms 17 186 37ms 0ms 18 184 15ms 0ms 19 184 16ms 0ms 20 185 17ms 0ms 21 184 16ms 0ms 22 184 17ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 638ms - Times executed: 4419 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 638ms - Times executed: 4419 ]
-
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: 2018-12-25 07:27:39 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:42:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:51:46 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 6,779 733ms 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 Dec 25 00 269 28ms 0ms 01 281 29ms 0ms 02 286 30ms 0ms 03 281 32ms 0ms 04 287 31ms 0ms 05 282 30ms 0ms 06 279 30ms 0ms 07 284 33ms 0ms 08 280 30ms 0ms 09 275 30ms 0ms 10 282 29ms 0ms 11 287 30ms 0ms 12 283 33ms 0ms 13 282 31ms 0ms 14 284 30ms 0ms 15 287 30ms 0ms 16 275 29ms 0ms 17 283 31ms 0ms 18 289 30ms 0ms 19 278 29ms 0ms 20 283 29ms 0ms 21 291 30ms 0ms 22 283 29ms 0ms 23 288 29ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 6779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 6779 ]
-
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: 2018-12-25 12:33:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:35:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 07:31:39 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 0ms 0ms 25,876 1s244ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 25 00 1,072 52ms 0ms 01 1,078 51ms 0ms 02 1,078 51ms 0ms 03 1,078 51ms 0ms 04 1,078 51ms 0ms 05 1,078 51ms 0ms 06 1,078 51ms 0ms 07 1,078 51ms 0ms 08 1,078 51ms 0ms 09 1,078 52ms 0ms 10 1,081 52ms 0ms 11 1,078 51ms 0ms 12 1,078 51ms 0ms 13 1,078 51ms 0ms 14 1,078 51ms 0ms 15 1,078 51ms 0ms 16 1,078 51ms 0ms 17 1,080 51ms 0ms 18 1,078 51ms 0ms 19 1,078 51ms 0ms 20 1,080 51ms 0ms 21 1,081 51ms 0ms 22 1,078 52ms 0ms 23 1,078 51ms 0ms [ User: symmetricds - Total duration: 1s244ms - Times executed: 25876 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s244ms - Times executed: 25876 ]
-
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: 2018-12-25 22:16:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 22:30:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 20:00:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 5ms 0ms 25,061 1s201ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 25 00 1,040 48ms 0ms 01 1,044 48ms 0ms 02 1,044 50ms 0ms 03 1,044 49ms 0ms 04 1,044 51ms 0ms 05 1,044 49ms 0ms 06 1,044 52ms 0ms 07 1,044 49ms 0ms 08 1,044 49ms 0ms 09 1,044 49ms 0ms 10 1,046 51ms 0ms 11 1,044 48ms 0ms 12 1,044 49ms 0ms 13 1,044 54ms 0ms 14 1,044 50ms 0ms 15 1,044 49ms 0ms 16 1,044 49ms 0ms 17 1,048 47ms 0ms 18 1,044 51ms 0ms 19 1,044 48ms 0ms 20 1,045 49ms 0ms 21 1,046 49ms 0ms 22 1,044 49ms 0ms 23 1,044 51ms 0ms [ User: symmetricds - Total duration: 1s201ms - Times executed: 25061 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s201ms - Times executed: 25061 ]
-
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: 2018-12-25 13:40:44 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 06:44:38 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:43:38 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 49,431 2s328ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 25 00 2,982 137ms 0ms 01 1,988 83ms 0ms 02 1,821 76ms 0ms 03 1,886 79ms 0ms 04 1,988 91ms 0ms 05 1,988 98ms 0ms 06 1,988 99ms 0ms 07 1,988 99ms 0ms 08 1,988 99ms 0ms 09 1,988 101ms 0ms 10 1,988 100ms 0ms 11 1,988 99ms 0ms 12 1,988 99ms 0ms 13 1,988 101ms 0ms 14 1,988 74ms 0ms 15 1,988 102ms 0ms 16 1,988 99ms 0ms 17 2,982 133ms 0ms 18 1,988 74ms 0ms 19 1,988 86ms 0ms 20 1,988 96ms 0ms 21 1,988 94ms 0ms 22 1,988 99ms 0ms 23 1,988 99ms 0ms [ User: pharmisight - Total duration: 2s328ms - Times executed: 49431 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s328ms - Times executed: 49431 ]
-
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: 2018-12-25 13:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 09:00:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 8,593 394ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 25 00 357 16ms 0ms 01 358 16ms 0ms 02 358 15ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 17ms 0ms 10 359 16ms 0ms 11 358 15ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 358 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 358 16ms 0ms 19 358 15ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 394ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 394ms - 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: 2018-12-25 09:38:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 14:56:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:27:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 6,779 302ms 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 Dec 25 00 269 11ms 0ms 01 281 12ms 0ms 02 286 12ms 0ms 03 281 12ms 0ms 04 287 14ms 0ms 05 282 12ms 0ms 06 279 12ms 0ms 07 284 12ms 0ms 08 280 12ms 0ms 09 275 12ms 0ms 10 282 12ms 0ms 11 287 12ms 0ms 12 283 12ms 0ms 13 282 12ms 0ms 14 284 12ms 0ms 15 287 12ms 0ms 16 275 12ms 0ms 17 283 12ms 0ms 18 289 12ms 0ms 19 278 12ms 0ms 20 283 12ms 0ms 21 291 12ms 0ms 22 283 12ms 0ms 23 288 12ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 6779 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 6779 ]
-
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: 2018-12-25 04:05:37 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 15:24:45 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 16:34:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 3ms 0ms 43,801 1s922ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 25 00 2,643 113ms 0ms 01 1,762 69ms 0ms 02 1,610 63ms 0ms 03 1,665 66ms 0ms 04 1,762 74ms 0ms 05 1,762 83ms 0ms 06 1,762 81ms 0ms 07 1,762 82ms 0ms 08 1,762 82ms 0ms 09 1,762 82ms 0ms 10 1,762 82ms 0ms 11 1,762 81ms 0ms 12 1,762 81ms 0ms 13 1,762 81ms 0ms 14 1,762 64ms 0ms 15 1,762 83ms 0ms 16 1,762 81ms 0ms 17 2,643 109ms 0ms 18 1,762 61ms 0ms 19 1,762 71ms 0ms 20 1,762 79ms 0ms 21 1,762 78ms 0ms 22 1,762 82ms 0ms 23 1,762 81ms 0ms [ User: pharmisight - Total duration: 1s922ms - Times executed: 43801 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s922ms - Times executed: 43801 ]
-
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: 2018-12-25 14:00:00 Duration: 3ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 05:20:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 04:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 1,764 67ms SET extra_float_digits = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 25 00 89 3ms 0ms 01 74 2ms 0ms 02 71 2ms 0ms 03 75 2ms 0ms 04 74 2ms 0ms 05 73 2ms 0ms 06 74 2ms 0ms 07 76 2ms 0ms 08 75 2ms 0ms 09 73 2ms 0ms 10 68 2ms 0ms 11 69 2ms 0ms 12 72 2ms 0ms 13 68 2ms 0ms 14 67 2ms 0ms 15 75 2ms 0ms 16 73 2ms 0ms 17 70 2ms 0ms 18 75 2ms 0ms 19 71 2ms 0ms 20 76 2ms 0ms 21 77 2ms 0ms 22 75 2ms 0ms 23 74 2ms 0ms [ User: pharmisight - Total duration: 43ms - Times executed: 1126 ]
[ User: symmetricds - Total duration: 24ms - Times executed: 638 ]
[ Application: [unknown] - Total duration: 67ms - Times executed: 1764 ]
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
-
SET extra_float_digits = 3;
Date: 2018-12-25 04:54:19 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-25 20:32:24 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
Date: 2018-12-25 11:51:49 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: [unknown] Bind query: yes
20 0ms 0ms 0ms 8,592 292ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 25 00 356 12ms 0ms 01 358 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 359 12ms 0ms 11 358 11ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 11ms 0ms 20 358 12ms 0ms 21 359 12ms 0ms 22 358 11ms 0ms 23 358 12ms 0ms [ User: symmetricds - Total duration: 292ms - Times executed: 8592 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 292ms - Times executed: 8592 ]
-
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: 2018-12-25 22:03:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 03:52:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2018-12-25 17:28:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,640,298 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 25 00 1 - ERROR: relation "gp_id" does not exist at character 20
Statement: select gpname from gp_id
Date: 2018-12-25 00:00:21 Database: pharmisight Application: PostgreSQL JDBC Driver User: symmetricds Remote: 10.10.10.1 Code: