pgBadger-
Global information
- Generated on Sun Jan 27 00:00:25 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,503,282 log entries in 23s
- Log start from 2019-01-26 00:00:00 to 2019-01-26 23:59:57
-
Overview
Global Stats
- 174 Number of unique normalized queries
- 1,211,418 Number of queries
- 56s265ms Total query duration
- 2019-01-26 00:00:00 First query
- 2019-01-26 23:59:57 Last query
- 1,905 queries/s at 2019-01-26 16:40:00 Query peak
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 51 Total number of automatic vacuums
- 73 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,640 Total number of sessions
- 3 sessions at 2019-01-26 19:33:03 Session peak
- 10d1h54m45s Total duration of sessions
- 8m51s Average duration of sessions
- 738 Average queries per session
- 34ms Average queries duration per session
- 1,640 Total number of connections
- 6 connections/s at 2019-01-26 00:30:44 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,905 queries/s Query Peak
- 2019-01-26 16:40:00 Date
SELECT Traffic
Key values
- 1,895 queries/s Query Peak
- 2019-01-26 16:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 725 queries/s Query Peak
- 2019-01-26 01:20:05 Date
Queries duration
Key values
- 56s265ms Total query duration
Prepared queries ratio
Key values
- 1.61 Ratio of bind vs prepare
- 169.83 % 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) Jan 26 00 56,420 0ms 41ms 0ms 73ms 159ms 1s206ms 01 52,908 0ms 38ms 0ms 50ms 259ms 392ms 02 51,515 0ms 41ms 0ms 48ms 170ms 355ms 03 52,987 0ms 40ms 0ms 72ms 217ms 353ms 04 51,697 0ms 40ms 0ms 57ms 179ms 320ms 05 51,793 0ms 39ms 0ms 66ms 147ms 335ms 06 49,603 0ms 38ms 0ms 51ms 62ms 281ms 07 49,652 0ms 154ms 0ms 45ms 61ms 560ms 08 49,681 0ms 65ms 0ms 48ms 64ms 237ms 09 49,667 0ms 47ms 0ms 50ms 68ms 198ms 10 49,627 0ms 55ms 0ms 49ms 73ms 217ms 11 49,622 0ms 87ms 0ms 52ms 69ms 334ms 12 49,654 0ms 66ms 0ms 58ms 72ms 266ms 13 49,599 0ms 67ms 0ms 54ms 69ms 207ms 14 49,587 0ms 55ms 0ms 52ms 68ms 162ms 15 49,754 0ms 60ms 0ms 52ms 55ms 153ms 16 49,621 0ms 42ms 0ms 50ms 56ms 103ms 17 49,566 0ms 24ms 0ms 55ms 58ms 146ms 18 49,548 0ms 35ms 0ms 52ms 62ms 124ms 19 49,653 0ms 20ms 0ms 55ms 59ms 140ms 20 50,326 0ms 39ms 0ms 50ms 60ms 390ms 21 49,620 0ms 29ms 0ms 46ms 54ms 149ms 22 49,744 0ms 23ms 0ms 51ms 63ms 152ms 23 49,574 0ms 17ms 0ms 52ms 63ms 153ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 26 00 19,464 0 0ms 30ms 39ms 535ms 01 16,768 0 0ms 26ms 36ms 124ms 02 16,461 0 0ms 25ms 33ms 107ms 03 16,696 0 0ms 24ms 32ms 102ms 04 16,506 0 0ms 29ms 42ms 90ms 05 16,515 0 0ms 28ms 33ms 103ms 06 16,020 0 0ms 26ms 33ms 93ms 07 16,028 0 0ms 25ms 32ms 89ms 08 16,042 0 0ms 25ms 33ms 67ms 09 16,037 0 0ms 23ms 33ms 60ms 10 16,005 0 0ms 24ms 32ms 58ms 11 16,026 0 0ms 23ms 30ms 59ms 12 16,027 0 0ms 24ms 36ms 54ms 13 16,013 0 0ms 22ms 37ms 58ms 14 16,001 0 0ms 22ms 34ms 45ms 15 16,063 0 0ms 29ms 34ms 41ms 16 16,016 0 0ms 23ms 31ms 38ms 17 16,008 0 0ms 22ms 35ms 44ms 18 16,001 0 0ms 23ms 34ms 50ms 19 16,059 0 0ms 23ms 33ms 60ms 20 16,656 0 0ms 23ms 32ms 131ms 21 16,022 0 0ms 24ms 31ms 36ms 22 16,060 0 0ms 23ms 33ms 51ms 23 16,007 0 0ms 23ms 32ms 52ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 26 00 993 761 110 0 0ms 7ms 11ms 61ms 01 2,096 576 110 0 0ms 1ms 6ms 69ms 02 930 284 111 0 0ms 1ms 7ms 62ms 03 1,911 530 109 0 0ms 3ms 7ms 85ms 04 1,031 312 108 0 0ms 1ms 7ms 53ms 05 1,063 320 109 0 0ms 1ms 7ms 69ms 06 88 54 105 0 1ms 1ms 3ms 7ms 07 88 53 102 0 2ms 1ms 3ms 7ms 08 88 54 97 0 1ms 1ms 3ms 7ms 09 88 54 93 0 0ms 1ms 4ms 7ms 10 94 56 94 0 1ms 1ms 3ms 7ms 11 88 54 89 0 1ms 1ms 4ms 7ms 12 88 53 90 0 1ms 1ms 6ms 7ms 13 88 54 87 0 1ms 1ms 6ms 7ms 14 88 54 84 0 0ms 1ms 5ms 7ms 15 88 53 83 0 0ms 1ms 3ms 7ms 16 88 54 83 0 0ms 1ms 5ms 7ms 17 88 53 82 0 0ms 1ms 6ms 7ms 18 88 54 81 0 0ms 1ms 5ms 7ms 19 90 68 82 0 0ms 1ms 6ms 7ms 20 121 87 111 0 0ms 1ms 6ms 7ms 21 88 54 81 0 0ms 1ms 6ms 7ms 22 88 53 81 0 0ms 0ms 3ms 7ms 23 88 54 81 0 0ms 0ms 6ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 26 00 35,531 56,384 1.59 100.97% 01 33,253 52,872 1.59 103.28% 02 31,496 51,479 1.63 102.95% 03 31,381 52,951 1.69 97.86% 04 31,412 51,661 1.64 102.05% 05 31,330 51,757 1.65 101.55% 06 30,882 49,567 1.61 106.83% 07 30,859 49,616 1.61 106.67% 08 30,930 49,645 1.61 106.87% 09 31,009 49,631 1.60 107.17% 10 30,537 49,591 1.62 105.62% 11 30,922 49,586 1.60 106.96% 12 30,886 49,618 1.61 106.80% 13 30,679 49,563 1.62 106.18% 14 30,746 49,551 1.61 106.47% 15 31,043 49,718 1.60 107.13% 16 30,848 49,585 1.61 106.74% 17 30,832 49,530 1.61 106.81% 18 30,713 49,512 1.61 106.42% 19 31,065 49,617 1.60 107.38% 20 30,814 50,290 1.63 103.97% 21 31,000 49,584 1.60 107.28% 22 31,049 49,708 1.60 107.19% 23 30,998 49,538 1.60 107.40% Day Hour Count Average / Second Jan 26 00 102 0.03/s 01 95 0.03/s 02 64 0.02/s 03 65 0.02/s 04 65 0.02/s 05 62 0.02/s 06 65 0.02/s 07 65 0.02/s 08 65 0.02/s 09 68 0.02/s 10 61 0.02/s 11 65 0.02/s 12 64 0.02/s 13 60 0.02/s 14 65 0.02/s 15 66 0.02/s 16 63 0.02/s 17 64 0.02/s 18 64 0.02/s 19 75 0.02/s 20 67 0.02/s 21 67 0.02/s 22 69 0.02/s 23 74 0.02/s Day Hour Count Average Duration Jan 26 00 102 6m4s 01 95 6m45s 02 64 9m2s 03 65 9m27s 04 65 9m14s 05 62 9m23s 06 64 9m23s 07 66 9m24s 08 65 9m20s 09 68 8m56s 10 61 9m27s 11 65 9m23s 12 64 9m32s 13 60 9m52s 14 65 9m24s 15 66 9m21s 16 63 8m45s 17 64 10m13s 18 64 9m11s 19 75 7m59s 20 67 9m10s 21 67 8m42s 22 69 8m51s 23 74 8m16s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2019-01-26 00:30:44 Date
Connections per database
Key values
- pharmisight Main Database
- 1,640 connections Total
Connections per user
Key values
- symmetricds Main User
- 1,640 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-01-26 19:33:03 Date
Histogram of session times
Key values
- 820 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 1,640 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 1,640 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 1,640 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,011 buffers Checkpoint Peak
- 2019-01-26 07:03:17 Date
- 149.590 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2019-01-26 07:03:17 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 Jan 26 00 1,201 120.415s 0.017s 120.499s 01 924 92.718s 0.02s 92.805s 02 702 70.446s 0.014s 70.527s 03 867 86.99s 0.017s 87.069s 04 685 68.718s 0.013s 68.798s 05 676 67.826s 0.017s 67.906s 06 778 78.032s 0.013s 78.112s 07 5,331 181.706s 0.015s 181.797s 08 1,350 134.926s 0.013s 134.999s 09 1,959 181.09s 0.012s 181.201s 10 1,301 130.202s 0.009s 130.261s 11 2,301 185.477s 0.019s 185.547s 12 1,522 152.658s 0.012s 152.727s 13 1,330 133.213s 0.01s 133.284s 14 1,123 112.443s 0.012s 112.506s 15 1,181 118.099s 0.014s 118.166s 16 849 84.945s 0.009s 84.997s 17 626 62.699s 0.01s 62.77s 18 480 48.152s 0.017s 48.209s 19 577 57.882s 0.014s 57.953s 20 351 35.218s 0.016s 35.278s 21 474 47.559s 0.008s 47.621s 22 582 58.281s 0.028s 58.482s 23 461 46.263s 0.011s 46.335s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 26 00 0 1 0 335 0.003s 0s 01 0 0 0 309 0.002s 0s 02 0 0 0 296 0.002s 0s 03 0 0 1 298 0.003s 0s 04 0 0 0 285 0.002s 0s 05 0 0 0 287 0.003s 0s 06 0 0 0 231 0.002s 0s 07 0 0 2 239 0.003s 0s 08 0 0 1 226 0.002s 0s 09 0 0 0 245 0.003s 0s 10 0 0 1 224 0.002s 0s 11 0 0 0 246 0.008s 0s 12 0 0 1 235 0.002s 0.001s 13 0 0 0 227 0.002s 0s 14 0 0 0 240 0.002s 0s 15 0 0 1 233 0.003s 0s 16 0 0 0 234 0.003s 0s 17 0 0 0 223 0.002s 0s 18 0 0 0 220 0.008s 0s 19 0 0 0 233 0.002s 0.002s 20 0 0 0 235 0.008s 0s 21 0 0 1 218 0.001s 0.001s 22 0 0 0 221 0.018s 0.001s 23 0 0 0 222 0.001s 0s Day Hour Count Avg time (sec) Jan 26 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 Jan 26 00 578.33 kB 1,056.58 kB 01 364.00 kB 847.91 kB 02 294.08 kB 606.67 kB 03 379.92 kB 718.67 kB 04 225.27 kB 568.82 kB 05 270.33 kB 638.67 kB 06 278.67 kB 1,278.25 kB 07 2,914.50 kB 20,339.58 kB 08 600.09 kB 6,405.18 kB 09 738.10 kB 4,215.30 kB 10 652.78 kB 3,196.89 kB 11 1,065.56 kB 5,828.89 kB 12 805.10 kB 4,636.80 kB 13 855.50 kB 4,263.12 kB 14 593.00 kB 2,635.22 kB 15 640.11 kB 2,870.00 kB 16 487.50 kB 1,929.62 kB 17 242.00 kB 942.00 kB 18 187.88 kB 498.25 kB 19 187.09 kB 642.18 kB 20 158.44 kB 339.33 kB 21 150.90 kB 345.20 kB 22 209.11 kB 601.78 kB 23 130.18 kB 364.36 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 Jan 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (16) Main table analyzed (database pharmisight)
- 73 analyzes Total
Vacuums per table
Key values
- public.sym_outgoing_batch (10) Main table vacuumed on database pharmisight
- 51 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_data_event 9 9 pharmisight.public.sym_data 9 9 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_incoming_batch 6 6 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.pg_catalog.pg_statistic 1 1 pharmisight.public.item_codes 1 1 Total 51 44 Tuples removed per table
Key values
- public.sym_data_event (66108) Main table with removed tuples on database pharmisight
- 77406 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 9 9 66108 2689 pharmisight.public.sym_outgoing_batch 10 10 5649 640 pharmisight.public.sym_data 9 9 3026 14318 pharmisight.public.sym_incoming_batch 6 6 1257 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.pg_catalog.pg_statistic 1 1 300 0 pharmisight.public.item_codes 1 1 233 0 pharmisight.pg_toast.pg_toast_2619 2 2 164 0 pharmisight.public.sym_sequence 1 0 51 0 Total 51 44 77,406 17,647 Pages removed per table
Key values
- public.sym_data (14318) Main table with removed pages on database pharmisight
- 17647 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 9 9 3026 14318 pharmisight.public.sym_data_event 9 9 66108 2689 pharmisight.public.sym_outgoing_batch 10 10 5649 640 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.pg_catalog.pg_statistic 1 1 300 0 pharmisight.pg_toast.pg_toast_2619 2 2 164 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_incoming_batch 6 6 1257 0 pharmisight.public.item_codes 1 1 233 0 Total 51 44 77,406 17,647 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 26 00 2 4 01 1 2 02 1 1 03 0 1 04 0 1 05 2 1 06 1 4 07 3 5 08 1 3 09 5 2 10 0 5 11 4 3 12 4 5 13 3 3 14 5 6 15 5 4 16 3 4 17 1 2 18 3 2 19 2 4 20 0 2 21 1 1 22 4 4 23 0 4 - 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
- 391,501 Total read queries
- 321,293 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,211,418 Requests
- 56s265ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,177,873 Requests
User Request type Count Duration pharmisight Total 55,714 4s801ms DELETE 31 3ms INSERT 1,919 1s31ms OTHERS 1,956 70ms SELECT 51,208 3s643ms TCL 552 47ms UPDATE 48 6ms symmetricds Total 1,177,873 52s257ms DELETE 2,265 3s295ms INSERT 8,015 959ms OTHERS 505,685 7s773ms SELECT 347,505 32s44ms TCL 310,555 5s586ms UPDATE 3,848 2s597ms tony Total 879 236ms SELECT 879 236ms Duration by user
Key values
- 52s257ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 55,714 4s801ms DELETE 31 3ms INSERT 1,919 1s31ms OTHERS 1,956 70ms SELECT 51,208 3s643ms TCL 552 47ms UPDATE 48 6ms symmetricds Total 1,177,873 52s257ms DELETE 2,265 3s295ms INSERT 8,015 959ms OTHERS 505,685 7s773ms SELECT 347,505 32s44ms TCL 310,555 5s586ms UPDATE 3,848 2s597ms tony Total 879 236ms SELECT 879 236ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,233,587 Requests
- 57s58ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,209,202 Requests
- 55s980ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-01-26 00:06:19 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,208,060 0-1ms duration
Slowest individual queries
Rank Duration Query 1 154ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN $1 AND $2 AND status != $3) AND batch_id BETWEEN $4 AND $5;[ Date: 2019-01-26 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 87ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 67ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 67ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 13:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 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: 2019-01-26 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 65ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 60ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 55ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 55ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 14:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 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: 2019-01-26 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 43ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 43ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 42ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-26 16:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 41ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN $1 AND $2 AND status != $3) AND batch_id BETWEEN $4 AND $5;[ Date: 2019-01-26 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 41ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-01-26 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 41ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-01-26 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 40ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-01-26 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 40ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-01-26 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 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: 2019-01-26 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 39ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-01-26 05: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 14s111ms 25,780 0ms 8ms 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 Jan 26 00 1,075 608ms 0ms 01 1,074 609ms 0ms 02 1,074 583ms 0ms 03 1,074 588ms 0ms 04 1,074 583ms 0ms 05 1,074 583ms 0ms 06 1,074 584ms 0ms 07 1,074 591ms 0ms 08 1,074 595ms 0ms 09 1,074 589ms 0ms 10 1,074 587ms 0ms 11 1,074 586ms 0ms 12 1,074 583ms 0ms 13 1,074 582ms 0ms 14 1,074 585ms 0ms 15 1,074 583ms 0ms 16 1,074 582ms 0ms 17 1,077 582ms 0ms 18 1,074 589ms 0ms 19 1,074 580ms 0ms 20 1,074 577ms 0ms 21 1,074 595ms 0ms 22 1,074 590ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s111ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s111ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-26 07:23:44 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:15:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:15:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s357ms 477,534 0ms 8ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 20,268 307ms 0ms 01 19,762 303ms 0ms 02 20,030 309ms 0ms 03 20,030 309ms 0ms 04 20,027 305ms 0ms 05 20,057 310ms 0ms 06 19,832 309ms 0ms 07 19,857 313ms 0ms 08 19,871 312ms 0ms 09 19,864 306ms 0ms 10 19,855 303ms 0ms 11 19,850 309ms 0ms 12 19,869 303ms 0ms 13 19,849 302ms 0ms 14 19,845 311ms 0ms 15 19,909 304ms 0ms 16 19,860 304ms 0ms 17 19,833 301ms 0ms 18 19,824 303ms 0ms 19 19,834 305ms 0ms 20 19,823 299ms 0ms 21 19,853 308ms 0ms 22 19,904 302ms 0ms 23 19,828 307ms 0ms [ User: symmetricds - Total duration: 7s332ms - Times executed: 476898 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s357ms - Times executed: 477534 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-01-26 14:41:13 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:59:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:52:10 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s586ms 152,790 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 00 6,929 402ms 0ms 01 6,323 205ms 0ms 02 6,404 197ms 0ms 03 6,410 208ms 0ms 04 6,413 195ms 0ms 05 6,422 194ms 0ms 06 6,320 190ms 0ms 07 6,329 164ms 0ms 08 6,330 165ms 0ms 09 6,331 175ms 0ms 10 6,331 214ms 0ms 11 6,326 173ms 0ms 12 6,331 201ms 0ms 13 6,326 183ms 0ms 14 6,325 183ms 0ms 15 6,345 166ms 0ms 16 6,329 165ms 0ms 17 6,318 169ms 0ms 18 6,318 167ms 0ms 19 6,315 171ms 0ms 20 6,331 171ms 0ms 21 6,326 169ms 0ms 22 6,342 169ms 0ms 23 6,316 180ms 0ms [ User: symmetricds - Total duration: 4s543ms - Times executed: 152519 ]
[ User: pharmisight - Total duration: 43ms - Times executed: 271 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s586ms - Times executed: 152790 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-01-26 13:22:29 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:30:20 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:37:20 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s20ms 164 0ms 87ms 12ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 26 00 14 102ms 7ms 01 14 100ms 7ms 02 14 88ms 6ms 03 14 91ms 6ms 04 14 88ms 6ms 05 14 86ms 6ms 06 14 107ms 7ms 07 13 263ms 20ms 08 9 105ms 11ms 09 8 82ms 10ms 10 7 87ms 12ms 11 6 203ms 33ms 12 5 145ms 29ms 13 4 106ms 26ms 14 3 74ms 24ms 15 2 74ms 37ms 16 2 42ms 21ms 17 1 24ms 24ms 18 1 35ms 35ms 19 1 20ms 20ms 20 1 20ms 20ms 21 1 29ms 29ms 22 1 23ms 23ms 23 1 14ms 14ms [ User: symmetricds - Total duration: 2s20ms - Times executed: 164 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s20ms - Times executed: 164 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2019-01-26 11:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 07:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s857ms 173,003 0ms 2ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 26 00 8,208 87ms 0ms 01 7,170 77ms 0ms 02 7,256 80ms 0ms 03 7,257 77ms 0ms 04 7,257 77ms 0ms 05 7,269 78ms 0ms 06 7,154 75ms 0ms 07 7,157 77ms 0ms 08 7,163 78ms 0ms 09 7,153 75ms 0ms 10 7,154 75ms 0ms 11 7,146 79ms 0ms 12 7,151 78ms 0ms 13 7,143 75ms 0ms 14 7,133 76ms 0ms 15 7,158 78ms 0ms 16 7,142 75ms 0ms 17 7,137 75ms 0ms 18 7,125 78ms 0ms 19 7,131 75ms 0ms 20 7,127 73ms 0ms 21 7,136 77ms 0ms 22 7,153 75ms 0ms 23 7,123 76ms 0ms [ User: symmetricds - Total duration: 1s857ms - Times executed: 173003 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s857ms - Times executed: 173003 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-01-26 11:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:16:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 15:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s255ms 25,911 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 26 00 1,084 51ms 0ms 01 1,084 51ms 0ms 02 1,084 52ms 0ms 03 1,084 52ms 0ms 04 1,084 52ms 0ms 05 1,084 51ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 51ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 51ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,081 52ms 0ms 18 1,078 52ms 0ms 19 1,078 52ms 0ms 20 1,078 51ms 0ms 21 1,078 52ms 0ms 22 1,078 52ms 0ms 23 1,078 52ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25911 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-26 04:11:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 04:52:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:58:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s192ms 25,146 0ms 2ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 26 00 1,102 51ms 0ms 01 1,054 48ms 0ms 02 1,052 49ms 0ms 03 1,054 50ms 0ms 04 1,053 50ms 0ms 05 1,053 51ms 0ms 06 1,044 48ms 0ms 07 1,044 49ms 0ms 08 1,044 50ms 0ms 09 1,042 52ms 0ms 10 1,042 50ms 0ms 11 1,040 49ms 0ms 12 1,040 50ms 0ms 13 1,042 49ms 0ms 14 1,042 48ms 0ms 15 1,044 47ms 0ms 16 1,044 48ms 0ms 17 1,046 49ms 0ms 18 1,044 49ms 0ms 19 1,044 51ms 0ms 20 1,044 46ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,044 49ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 25146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 25146 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-26 10:05:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:15:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:32:12 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s178ms 243 1ms 24ms 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 #8
Day Hour Count Duration Avg duration Jan 26 00 14 48ms 3ms 01 15 57ms 3ms 02 12 76ms 6ms 03 11 47ms 4ms 04 13 70ms 5ms 05 13 67ms 5ms 06 7 46ms 6ms 07 8 35ms 4ms 08 10 51ms 5ms 09 8 36ms 4ms 10 8 35ms 4ms 11 9 39ms 4ms 12 11 67ms 6ms 13 10 73ms 7ms 14 7 31ms 4ms 15 10 42ms 4ms 16 8 33ms 4ms 17 8 38ms 4ms 18 11 50ms 4ms 19 11 59ms 5ms 20 8 38ms 4ms 21 9 33ms 3ms 22 11 44ms 4ms 23 11 52ms 4ms [ User: symmetricds - Total duration: 1s178ms - Times executed: 243 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s178ms - Times executed: 243 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 02:40:06 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 12:26:11 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:56:12 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s111ms 156 3ms 12ms 7ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 26 00 104 734ms 7ms 01 3 17ms 5ms 02 3 17ms 5ms 03 3 17ms 5ms 04 4 21ms 5ms 05 3 17ms 5ms 06 2 12ms 6ms 07 2 12ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 17ms 8ms 13 2 18ms 9ms 14 2 17ms 8ms 15 2 17ms 8ms 16 2 17ms 8ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 17ms 8ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 792ms - Times executed: 111 ]
[ User: pharmisight - Total duration: 318ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 156 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-01-26 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:30:38 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:30:38 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s111ms 23,952 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 26 00 998 33ms 0ms 01 998 49ms 0ms 02 998 38ms 0ms 03 998 38ms 0ms 04 998 46ms 0ms 05 998 51ms 0ms 06 998 49ms 0ms 07 998 51ms 0ms 08 998 26ms 0ms 09 998 50ms 0ms 10 998 49ms 0ms 11 998 50ms 0ms 12 998 50ms 0ms 13 998 50ms 0ms 14 998 50ms 0ms 15 998 49ms 0ms 16 998 26ms 0ms 17 998 50ms 0ms 18 998 36ms 0ms 19 998 51ms 0ms 20 998 50ms 0ms 21 998 54ms 0ms 22 998 52ms 0ms 23 998 53ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 23952 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 23952 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s85ms 192 0ms 9ms 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 Jan 26 00 8 52ms 6ms 01 8 52ms 6ms 02 7 41ms 5ms 03 8 52ms 6ms 04 8 52ms 6ms 05 8 35ms 4ms 06 8 44ms 5ms 07 8 37ms 4ms 08 8 38ms 4ms 09 8 48ms 6ms 10 9 38ms 4ms 11 8 47ms 5ms 12 8 47ms 5ms 13 8 50ms 6ms 14 8 46ms 5ms 15 8 38ms 4ms 16 8 44ms 5ms 17 8 44ms 5ms 18 8 45ms 5ms 19 8 46ms 5ms 20 8 40ms 5ms 21 8 54ms 6ms 22 8 34ms 4ms 23 8 49ms 6ms [ User: symmetricds - Total duration: 1s85ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s85ms - 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: 2019-01-26 13:30:30 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:13:52 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:36:54 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s7ms 703 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 #12
Day Hour Count Duration Avg duration Jan 26 00 50 71ms 1ms 01 56 78ms 1ms 02 28 41ms 1ms 03 27 40ms 1ms 04 28 39ms 1ms 05 26 37ms 1ms 06 28 41ms 1ms 07 26 37ms 1ms 08 28 38ms 1ms 09 28 40ms 1ms 10 24 36ms 1ms 11 28 40ms 1ms 12 25 36ms 1ms 13 25 35ms 1ms 14 27 38ms 1ms 15 28 40ms 1ms 16 25 34ms 1ms 17 28 39ms 1ms 18 27 39ms 1ms 19 29 41ms 1ms 20 26 37ms 1ms 21 29 41ms 1ms 22 27 39ms 1ms 23 30 42ms 1ms [ User: symmetricds - Total duration: 1s7ms - Times executed: 703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s7ms - Times executed: 703 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 06:14:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 19:10:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:36:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 994ms 1,823 0ms 15ms 0ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 26 00 188 136ms 0ms 01 499 235ms 0ms 02 209 116ms 0ms 03 453 240ms 0ms 04 233 136ms 0ms 05 241 128ms 0ms [ User: pharmisight - Total duration: 994ms - Times executed: 1823 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 994ms - Times executed: 1823 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
Date: 2019-01-26 04:20:00 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:20:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 932ms 152,791 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 26 00 6,930 42ms 0ms 01 6,323 38ms 0ms 02 6,404 38ms 0ms 03 6,411 38ms 0ms 04 6,412 39ms 0ms 05 6,422 40ms 0ms 06 6,320 38ms 0ms 07 6,329 39ms 0ms 08 6,330 38ms 0ms 09 6,331 39ms 0ms 10 6,331 38ms 0ms 11 6,326 38ms 0ms 12 6,331 38ms 0ms 13 6,326 38ms 0ms 14 6,325 38ms 0ms 15 6,345 38ms 0ms 16 6,329 38ms 0ms 17 6,318 38ms 0ms 18 6,318 38ms 0ms 19 6,315 38ms 0ms 20 6,331 37ms 0ms 21 6,326 39ms 0ms 22 6,342 38ms 0ms 23 6,316 38ms 0ms [ User: symmetricds - Total duration: 930ms - Times executed: 152519 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 932ms - Times executed: 152791 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-01-26 00:43:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:17:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:09:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 919ms 946 0ms 3ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 26 00 68 67ms 0ms 01 75 72ms 0ms 02 37 34ms 0ms 03 37 34ms 0ms 04 32 31ms 0ms 05 36 34ms 0ms 06 37 36ms 0ms 07 35 33ms 0ms 08 37 35ms 0ms 09 40 37ms 0ms 10 32 31ms 0ms 11 37 37ms 1ms 12 35 33ms 0ms 13 33 31ms 0ms 14 35 33ms 0ms 15 40 37ms 0ms 16 35 34ms 0ms 17 38 36ms 0ms 18 40 40ms 1ms 19 38 37ms 0ms 20 36 37ms 1ms 21 36 34ms 0ms 22 38 36ms 0ms 23 39 37ms 0ms [ User: symmetricds - Total duration: 919ms - Times executed: 946 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 919ms - Times executed: 946 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 20:54:16 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:54:05 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:31:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 912ms 21,216 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 26 00 884 27ms 0ms 01 884 40ms 0ms 02 884 32ms 0ms 03 884 31ms 0ms 04 884 37ms 0ms 05 884 42ms 0ms 06 884 40ms 0ms 07 884 41ms 0ms 08 884 21ms 0ms 09 884 41ms 0ms 10 884 40ms 0ms 11 884 41ms 0ms 12 884 41ms 0ms 13 884 41ms 0ms 14 884 41ms 0ms 15 884 41ms 0ms 16 884 21ms 0ms 17 884 41ms 0ms 18 884 29ms 0ms 19 884 42ms 0ms 20 884 41ms 0ms 21 884 41ms 0ms 22 884 43ms 0ms 23 884 44ms 0ms [ User: pharmisight - Total duration: 912ms - Times executed: 21216 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 21216 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 720ms 6,636 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 26 00 241 27ms 0ms 01 241 27ms 0ms 02 281 30ms 0ms 03 279 29ms 0ms 04 284 29ms 0ms 05 286 31ms 0ms 06 276 29ms 0ms 07 281 29ms 0ms 08 280 31ms 0ms 09 283 31ms 0ms 10 275 32ms 0ms 11 283 30ms 0ms 12 284 30ms 0ms 13 280 29ms 0ms 14 281 30ms 0ms 15 288 31ms 0ms 16 280 29ms 0ms 17 269 30ms 0ms 18 276 29ms 0ms 19 272 29ms 0ms 20 275 28ms 0ms 21 279 30ms 0ms 22 288 30ms 0ms 23 274 29ms 0ms [ User: symmetricds - Total duration: 720ms - Times executed: 6636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 720ms - Times executed: 6636 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-26 10:25:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 17:51:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:29:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 651ms 708 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 #18
Day Hour Count Duration Avg duration Jan 26 00 50 46ms 0ms 01 57 53ms 0ms 02 27 23ms 0ms 03 28 26ms 0ms 04 27 25ms 0ms 05 26 24ms 0ms 06 28 25ms 0ms 07 27 24ms 0ms 08 27 25ms 0ms 09 29 26ms 0ms 10 23 20ms 0ms 11 28 25ms 0ms 12 27 25ms 0ms 13 24 21ms 0ms 14 27 25ms 0ms 15 29 26ms 0ms 16 27 24ms 0ms 17 27 24ms 0ms 18 28 26ms 0ms 19 30 27ms 0ms 20 25 22ms 0ms 21 29 26ms 0ms 22 29 26ms 0ms 23 29 26ms 0ms [ User: symmetricds - Total duration: 651ms - Times executed: 708 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 651ms - Times executed: 708 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 12:31:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:33:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 04:21:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 620ms 706 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 #19
Day Hour Count Duration Avg duration Jan 26 00 50 44ms 0ms 01 55 47ms 0ms 02 28 23ms 0ms 03 28 24ms 0ms 04 27 24ms 0ms 05 26 22ms 0ms 06 28 24ms 0ms 07 27 23ms 0ms 08 27 24ms 0ms 09 29 24ms 0ms 10 23 20ms 0ms 11 28 25ms 0ms 12 27 23ms 0ms 13 24 21ms 0ms 14 27 23ms 0ms 15 29 25ms 0ms 16 27 24ms 0ms 17 27 23ms 0ms 18 27 23ms 0ms 19 30 26ms 0ms 20 25 21ms 0ms 21 29 25ms 0ms 22 29 25ms 0ms 23 29 25ms 0ms [ User: symmetricds - Total duration: 620ms - Times executed: 706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 620ms - Times executed: 706 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 13:41:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:21:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 20:17:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 567ms 96 0ms 7ms 5ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 4 27ms 6ms 01 4 23ms 5ms 02 4 21ms 5ms 03 4 20ms 5ms 04 4 21ms 5ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 21ms 5ms 08 4 20ms 5ms 09 4 18ms 4ms 10 4 21ms 5ms 11 4 20ms 5ms 12 4 26ms 6ms 13 4 27ms 6ms 14 4 21ms 5ms 15 4 21ms 5ms 16 4 24ms 6ms 17 4 26ms 6ms 18 4 27ms 6ms 19 4 20ms 5ms 20 4 26ms 6ms 21 4 26ms 6ms 22 4 26ms 6ms 23 4 26ms 6ms [ User: symmetricds - Total duration: 567ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 567ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-01-26 15:25:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:55:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:40:41 Duration: 7ms 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,534 7s357ms 0ms 8ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 26 00 20,268 307ms 0ms 01 19,762 303ms 0ms 02 20,030 309ms 0ms 03 20,030 309ms 0ms 04 20,027 305ms 0ms 05 20,057 310ms 0ms 06 19,832 309ms 0ms 07 19,857 313ms 0ms 08 19,871 312ms 0ms 09 19,864 306ms 0ms 10 19,855 303ms 0ms 11 19,850 309ms 0ms 12 19,869 303ms 0ms 13 19,849 302ms 0ms 14 19,845 311ms 0ms 15 19,909 304ms 0ms 16 19,860 304ms 0ms 17 19,833 301ms 0ms 18 19,824 303ms 0ms 19 19,834 305ms 0ms 20 19,823 299ms 0ms 21 19,853 308ms 0ms 22 19,904 302ms 0ms 23 19,828 307ms 0ms [ User: symmetricds - Total duration: 7s332ms - Times executed: 476898 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s357ms - Times executed: 477534 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-01-26 14:41:13 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:59:08 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:52:10 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 173,003 1s857ms 0ms 2ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 8,208 87ms 0ms 01 7,170 77ms 0ms 02 7,256 80ms 0ms 03 7,257 77ms 0ms 04 7,257 77ms 0ms 05 7,269 78ms 0ms 06 7,154 75ms 0ms 07 7,157 77ms 0ms 08 7,163 78ms 0ms 09 7,153 75ms 0ms 10 7,154 75ms 0ms 11 7,146 79ms 0ms 12 7,151 78ms 0ms 13 7,143 75ms 0ms 14 7,133 76ms 0ms 15 7,158 78ms 0ms 16 7,142 75ms 0ms 17 7,137 75ms 0ms 18 7,125 78ms 0ms 19 7,131 75ms 0ms 20 7,127 73ms 0ms 21 7,136 77ms 0ms 22 7,153 75ms 0ms 23 7,123 76ms 0ms [ User: symmetricds - Total duration: 1s857ms - Times executed: 173003 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s857ms - Times executed: 173003 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-01-26 11:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:16:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 15:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 152,791 932ms 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 00 6,930 42ms 0ms 01 6,323 38ms 0ms 02 6,404 38ms 0ms 03 6,411 38ms 0ms 04 6,412 39ms 0ms 05 6,422 40ms 0ms 06 6,320 38ms 0ms 07 6,329 39ms 0ms 08 6,330 38ms 0ms 09 6,331 39ms 0ms 10 6,331 38ms 0ms 11 6,326 38ms 0ms 12 6,331 38ms 0ms 13 6,326 38ms 0ms 14 6,325 38ms 0ms 15 6,345 38ms 0ms 16 6,329 38ms 0ms 17 6,318 38ms 0ms 18 6,318 38ms 0ms 19 6,315 38ms 0ms 20 6,331 37ms 0ms 21 6,326 39ms 0ms 22 6,342 38ms 0ms 23 6,316 38ms 0ms [ User: symmetricds - Total duration: 930ms - Times executed: 152519 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 272 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 932ms - Times executed: 152791 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-01-26 00:43:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:17:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:09:10 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 152,790 4s586ms 0ms 16ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 26 00 6,929 402ms 0ms 01 6,323 205ms 0ms 02 6,404 197ms 0ms 03 6,410 208ms 0ms 04 6,413 195ms 0ms 05 6,422 194ms 0ms 06 6,320 190ms 0ms 07 6,329 164ms 0ms 08 6,330 165ms 0ms 09 6,331 175ms 0ms 10 6,331 214ms 0ms 11 6,326 173ms 0ms 12 6,331 201ms 0ms 13 6,326 183ms 0ms 14 6,325 183ms 0ms 15 6,345 166ms 0ms 16 6,329 165ms 0ms 17 6,318 169ms 0ms 18 6,318 167ms 0ms 19 6,315 171ms 0ms 20 6,331 171ms 0ms 21 6,326 169ms 0ms 22 6,342 169ms 0ms 23 6,316 180ms 0ms [ User: symmetricds - Total duration: 4s543ms - Times executed: 152519 ]
[ User: pharmisight - Total duration: 43ms - Times executed: 271 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s586ms - Times executed: 152790 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-01-26 13:22:29 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:30:20 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:37:20 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,911 1s255ms 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 26 00 1,084 51ms 0ms 01 1,084 51ms 0ms 02 1,084 52ms 0ms 03 1,084 52ms 0ms 04 1,084 52ms 0ms 05 1,084 51ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 51ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 51ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,081 52ms 0ms 18 1,078 52ms 0ms 19 1,078 52ms 0ms 20 1,078 51ms 0ms 21 1,078 52ms 0ms 22 1,078 52ms 0ms 23 1,078 52ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25911 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-26 04:11:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 04:52:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:58:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 25,780 14s111ms 0ms 8ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 26 00 1,075 608ms 0ms 01 1,074 609ms 0ms 02 1,074 583ms 0ms 03 1,074 588ms 0ms 04 1,074 583ms 0ms 05 1,074 583ms 0ms 06 1,074 584ms 0ms 07 1,074 591ms 0ms 08 1,074 595ms 0ms 09 1,074 589ms 0ms 10 1,074 587ms 0ms 11 1,074 586ms 0ms 12 1,074 583ms 0ms 13 1,074 582ms 0ms 14 1,074 585ms 0ms 15 1,074 583ms 0ms 16 1,074 582ms 0ms 17 1,077 582ms 0ms 18 1,074 589ms 0ms 19 1,074 580ms 0ms 20 1,074 577ms 0ms 21 1,074 595ms 0ms 22 1,074 590ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s111ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s111ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-26 07:23:44 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:15:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:15:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,146 1s192ms 0ms 2ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 26 00 1,102 51ms 0ms 01 1,054 48ms 0ms 02 1,052 49ms 0ms 03 1,054 50ms 0ms 04 1,053 50ms 0ms 05 1,053 51ms 0ms 06 1,044 48ms 0ms 07 1,044 49ms 0ms 08 1,044 50ms 0ms 09 1,042 52ms 0ms 10 1,042 50ms 0ms 11 1,040 49ms 0ms 12 1,040 50ms 0ms 13 1,042 49ms 0ms 14 1,042 48ms 0ms 15 1,044 47ms 0ms 16 1,044 48ms 0ms 17 1,046 49ms 0ms 18 1,044 49ms 0ms 19 1,044 51ms 0ms 20 1,044 46ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,044 49ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 25146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 25146 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-26 10:05:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:15:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:32:12 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 23,952 1s111ms 0ms 0ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 26 00 998 33ms 0ms 01 998 49ms 0ms 02 998 38ms 0ms 03 998 38ms 0ms 04 998 46ms 0ms 05 998 51ms 0ms 06 998 49ms 0ms 07 998 51ms 0ms 08 998 26ms 0ms 09 998 50ms 0ms 10 998 49ms 0ms 11 998 50ms 0ms 12 998 50ms 0ms 13 998 50ms 0ms 14 998 50ms 0ms 15 998 49ms 0ms 16 998 26ms 0ms 17 998 50ms 0ms 18 998 36ms 0ms 19 998 51ms 0ms 20 998 50ms 0ms 21 998 54ms 0ms 22 998 52ms 0ms 23 998 53ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 23952 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 23952 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 21,216 912ms 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 26 00 884 27ms 0ms 01 884 40ms 0ms 02 884 32ms 0ms 03 884 31ms 0ms 04 884 37ms 0ms 05 884 42ms 0ms 06 884 40ms 0ms 07 884 41ms 0ms 08 884 21ms 0ms 09 884 41ms 0ms 10 884 40ms 0ms 11 884 41ms 0ms 12 884 41ms 0ms 13 884 41ms 0ms 14 884 41ms 0ms 15 884 41ms 0ms 16 884 21ms 0ms 17 884 41ms 0ms 18 884 29ms 0ms 19 884 42ms 0ms 20 884 41ms 0ms 21 884 41ms 0ms 22 884 43ms 0ms 23 884 44ms 0ms [ User: pharmisight - Total duration: 912ms - Times executed: 21216 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 21216 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,268 458ms 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 Jan 26 00 720 18ms 0ms 01 720 18ms 0ms 02 720 18ms 0ms 03 718 19ms 0ms 04 720 19ms 0ms 05 720 19ms 0ms 06 720 18ms 0ms 07 718 18ms 0ms 08 720 19ms 0ms 09 720 19ms 0ms 10 720 18ms 0ms 11 718 19ms 0ms 12 720 19ms 0ms 13 720 18ms 0ms 14 718 18ms 0ms 15 720 19ms 0ms 16 720 19ms 0ms 17 720 19ms 0ms 18 718 18ms 0ms 19 720 19ms 0ms 20 720 19ms 0ms 21 720 19ms 0ms 22 718 19ms 0ms 23 720 19ms 0ms [ User: symmetricds - Total duration: 458ms - Times executed: 17268 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 458ms - Times executed: 17268 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2019-01-26 04:46:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:25:51 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 03:32:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,193 106ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 26 00 392 4ms 0ms 01 392 4ms 0ms 02 392 4ms 0ms 03 392 4ms 0ms 04 392 4ms 0ms 05 392 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 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 381 4ms 0ms 18 380 4ms 0ms 19 381 4ms 0ms 20 379 4ms 0ms 21 380 4ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms [ User: symmetricds - Total duration: 106ms - Times executed: 9193 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 106ms - Times executed: 9193 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-01-26 16:41:14 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 12:41:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 16:09:03 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,193 147ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 26 00 392 6ms 0ms 01 392 6ms 0ms 02 395 6ms 0ms 03 392 6ms 0ms 04 390 6ms 0ms 05 393 6ms 0ms 06 378 6ms 0ms 07 380 5ms 0ms 08 383 6ms 0ms 09 377 6ms 0ms 10 383 6ms 0ms 11 377 6ms 0ms 12 381 6ms 0ms 13 380 6ms 0ms 14 379 6ms 0ms 15 380 6ms 0ms 16 380 6ms 0ms 17 381 6ms 0ms 18 380 6ms 0ms 19 383 6ms 0ms 20 377 6ms 0ms 21 380 6ms 0ms 22 380 6ms 0ms 23 380 6ms 0ms [ User: symmetricds - Total duration: 147ms - Times executed: 9193 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 147ms - Times executed: 9193 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2019-01-26 12:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 14:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:41:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,593 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 #13
Day Hour Count Duration Avg duration Jan 26 00 358 11ms 0ms 01 358 11ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 11ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 11ms 0ms 13 358 11ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 11ms 0ms 17 359 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 358 11ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 358 11ms 0ms [ User: symmetricds - Total duration: 292ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 292ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-01-26 07:48:22 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:33:26 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:45:20 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,593 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 #14
Day Hour Count Duration Avg duration Jan 26 00 358 8ms 0ms 01 358 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 9ms 0ms 07 358 8ms 0ms 08 358 9ms 0ms 09 358 8ms 0ms 10 358 8ms 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 359 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 358 8ms 0ms 23 358 8ms 0ms [ User: symmetricds - Total duration: 207ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 207ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
Date: 2019-01-26 06:33:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 18:59:59 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:20:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,593 259ms 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 Jan 26 00 358 11ms 0ms 01 358 11ms 0ms 02 358 11ms 0ms 03 358 11ms 0ms 04 358 11ms 0ms 05 358 11ms 0ms 06 358 12ms 0ms 07 358 10ms 0ms 08 358 12ms 0ms 09 358 10ms 0ms 10 358 10ms 0ms 11 358 10ms 0ms 12 358 10ms 0ms 13 358 10ms 0ms 14 358 10ms 0ms 15 358 10ms 0ms 16 358 10ms 0ms 17 359 10ms 0ms 18 358 10ms 0ms 19 358 10ms 0ms 20 358 10ms 0ms 21 358 10ms 0ms 22 358 10ms 0ms 23 358 10ms 0ms [ User: symmetricds - Total duration: 259ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 259ms - Times executed: 8593 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
Date: 2019-01-26 00:11:32 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 03:20:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,593 384ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 26 00 358 15ms 0ms 01 358 16ms 0ms 02 358 15ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 15ms 0ms 07 358 15ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 15ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 15ms 0ms 15 358 15ms 0ms 16 358 16ms 0ms 17 359 16ms 0ms 18 358 16ms 0ms 19 358 15ms 0ms 20 358 15ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 384ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 384ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-01-26 22:58:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:28:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 19:29:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,636 720ms 0ms 2ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 26 00 241 27ms 0ms 01 241 27ms 0ms 02 281 30ms 0ms 03 279 29ms 0ms 04 284 29ms 0ms 05 286 31ms 0ms 06 276 29ms 0ms 07 281 29ms 0ms 08 280 31ms 0ms 09 283 31ms 0ms 10 275 32ms 0ms 11 283 30ms 0ms 12 284 30ms 0ms 13 280 29ms 0ms 14 281 30ms 0ms 15 288 31ms 0ms 16 280 29ms 0ms 17 269 30ms 0ms 18 276 29ms 0ms 19 272 29ms 0ms 20 275 28ms 0ms 21 279 30ms 0ms 22 288 30ms 0ms 23 274 29ms 0ms [ User: symmetricds - Total duration: 720ms - Times executed: 6636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 720ms - Times executed: 6636 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-26 10:25:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 17:51:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:29:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,636 301ms 0ms 1ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 26 00 241 11ms 0ms 01 241 11ms 0ms 02 281 12ms 0ms 03 279 12ms 0ms 04 284 12ms 0ms 05 286 13ms 0ms 06 276 12ms 0ms 07 281 12ms 0ms 08 280 12ms 0ms 09 283 12ms 0ms 10 275 13ms 0ms 11 283 12ms 0ms 12 284 12ms 0ms 13 280 12ms 0ms 14 281 12ms 0ms 15 288 13ms 0ms 16 280 12ms 0ms 17 269 11ms 0ms 18 276 12ms 0ms 19 272 13ms 0ms 20 275 12ms 0ms 21 279 12ms 0ms 22 288 12ms 0ms 23 274 12ms 0ms [ User: symmetricds - Total duration: 301ms - Times executed: 6636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 301ms - Times executed: 6636 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-01-26 19:39:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:23:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:27:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,510 302ms 0ms 0ms 0ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 26 00 412 24ms 0ms 01 1,034 62ms 0ms 02 451 27ms 0ms 03 942 44ms 0ms 04 502 28ms 0ms 05 518 25ms 0ms 06 36 6ms 0ms 07 36 5ms 0ms 08 36 3ms 0ms 09 36 4ms 0ms 10 39 5ms 0ms 11 36 5ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 5ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 36 4ms 0ms 20 36 4ms 0ms 21 36 5ms 0ms 22 36 4ms 0ms 23 36 5ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 4510 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 4510 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
Date: 2019-01-26 06:14:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:37:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 4,450 409ms 0ms 2ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 190 18ms 0ms 01 190 20ms 0ms 02 190 18ms 0ms 03 190 18ms 0ms 04 189 17ms 0ms 05 189 18ms 0ms 06 184 17ms 0ms 07 184 15ms 0ms 08 184 18ms 0ms 09 184 17ms 0ms 10 184 16ms 0ms 11 184 17ms 0ms 12 184 17ms 0ms 13 184 16ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 15ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 16ms 0ms 20 184 15ms 0ms 21 184 16ms 0ms 22 184 15ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 409ms - Times executed: 4450 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 409ms - Times executed: 4450 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-01-26 08:44:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:55:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:20:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 87ms 12ms 164 2s20ms 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 Jan 26 00 14 102ms 7ms 01 14 100ms 7ms 02 14 88ms 6ms 03 14 91ms 6ms 04 14 88ms 6ms 05 14 86ms 6ms 06 14 107ms 7ms 07 13 263ms 20ms 08 9 105ms 11ms 09 8 82ms 10ms 10 7 87ms 12ms 11 6 203ms 33ms 12 5 145ms 29ms 13 4 106ms 26ms 14 3 74ms 24ms 15 2 74ms 37ms 16 2 42ms 21ms 17 1 24ms 24ms 18 1 35ms 35ms 19 1 20ms 20ms 20 1 20ms 20ms 21 1 29ms 29ms 22 1 23ms 23ms 23 1 14ms 14ms [ User: symmetricds - Total duration: 2s20ms - Times executed: 164 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s20ms - Times executed: 164 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
-
DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));
Date: 2019-01-26 11:00:00 Duration: 87ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 07:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 3ms 12ms 7ms 156 1s111ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 104 734ms 7ms 01 3 17ms 5ms 02 3 17ms 5ms 03 3 17ms 5ms 04 4 21ms 5ms 05 3 17ms 5ms 06 2 12ms 6ms 07 2 12ms 6ms 08 2 13ms 6ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 17ms 8ms 13 2 18ms 9ms 14 2 17ms 8ms 15 2 17ms 8ms 16 2 17ms 8ms 17 2 17ms 8ms 18 2 17ms 8ms 19 2 17ms 8ms 20 2 17ms 8ms 21 2 13ms 6ms 22 2 17ms 8ms 23 2 17ms 8ms [ User: symmetricds - Total duration: 792ms - Times executed: 111 ]
[ User: pharmisight - Total duration: 318ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 156 ]
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'order_lines' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'orders' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-01-26 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:30:38 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:30:38 Duration: 10ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 7ms 5ms 96 567ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 00 4 27ms 6ms 01 4 23ms 5ms 02 4 21ms 5ms 03 4 20ms 5ms 04 4 21ms 5ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 21ms 5ms 08 4 20ms 5ms 09 4 18ms 4ms 10 4 21ms 5ms 11 4 20ms 5ms 12 4 26ms 6ms 13 4 27ms 6ms 14 4 21ms 5ms 15 4 21ms 5ms 16 4 24ms 6ms 17 4 26ms 6ms 18 4 27ms 6ms 19 4 20ms 5ms 20 4 26ms 6ms 21 4 26ms 6ms 22 4 26ms 6ms 23 4 26ms 6ms [ User: symmetricds - Total duration: 567ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 567ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-01-26 15:25:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:55:42 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:40:41 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 9ms 5ms 192 1s85ms 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 Jan 26 00 8 52ms 6ms 01 8 52ms 6ms 02 7 41ms 5ms 03 8 52ms 6ms 04 8 52ms 6ms 05 8 35ms 4ms 06 8 44ms 5ms 07 8 37ms 4ms 08 8 38ms 4ms 09 8 48ms 6ms 10 9 38ms 4ms 11 8 47ms 5ms 12 8 47ms 5ms 13 8 50ms 6ms 14 8 46ms 5ms 15 8 38ms 4ms 16 8 44ms 5ms 17 8 44ms 5ms 18 8 45ms 5ms 19 8 46ms 5ms 20 8 40ms 5ms 21 8 54ms 6ms 22 8 34ms 4ms 23 8 49ms 6ms [ User: symmetricds - Total duration: 1s85ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s85ms - 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: 2019-01-26 13:30:30 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:13:52 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:36:54 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1ms 24ms 4ms 243 1s178ms 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 Jan 26 00 14 48ms 3ms 01 15 57ms 3ms 02 12 76ms 6ms 03 11 47ms 4ms 04 13 70ms 5ms 05 13 67ms 5ms 06 7 46ms 6ms 07 8 35ms 4ms 08 10 51ms 5ms 09 8 36ms 4ms 10 8 35ms 4ms 11 9 39ms 4ms 12 11 67ms 6ms 13 10 73ms 7ms 14 7 31ms 4ms 15 10 42ms 4ms 16 8 33ms 4ms 17 8 38ms 4ms 18 11 50ms 4ms 19 11 59ms 5ms 20 8 38ms 4ms 21 9 33ms 3ms 22 11 44ms 4ms 23 11 52ms 4ms [ User: symmetricds - Total duration: 1s178ms - Times executed: 243 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s178ms - Times executed: 243 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 02:40:06 Duration: 24ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 12:26:11 Duration: 20ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:56:12 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 2ms 1ms 703 1s7ms 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 Jan 26 00 50 71ms 1ms 01 56 78ms 1ms 02 28 41ms 1ms 03 27 40ms 1ms 04 28 39ms 1ms 05 26 37ms 1ms 06 28 41ms 1ms 07 26 37ms 1ms 08 28 38ms 1ms 09 28 40ms 1ms 10 24 36ms 1ms 11 28 40ms 1ms 12 25 36ms 1ms 13 25 35ms 1ms 14 27 38ms 1ms 15 28 40ms 1ms 16 25 34ms 1ms 17 28 39ms 1ms 18 27 39ms 1ms 19 29 41ms 1ms 20 26 37ms 1ms 21 29 41ms 1ms 22 27 39ms 1ms 23 30 42ms 1ms [ User: symmetricds - Total duration: 1s7ms - Times executed: 703 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s7ms - Times executed: 703 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 06:14:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 19:10:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:36:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 3ms 0ms 946 919ms 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 Jan 26 00 68 67ms 0ms 01 75 72ms 0ms 02 37 34ms 0ms 03 37 34ms 0ms 04 32 31ms 0ms 05 36 34ms 0ms 06 37 36ms 0ms 07 35 33ms 0ms 08 37 35ms 0ms 09 40 37ms 0ms 10 32 31ms 0ms 11 37 37ms 1ms 12 35 33ms 0ms 13 33 31ms 0ms 14 35 33ms 0ms 15 40 37ms 0ms 16 35 34ms 0ms 17 38 36ms 0ms 18 40 40ms 1ms 19 38 37ms 0ms 20 36 37ms 1ms 21 36 34ms 0ms 22 38 36ms 0ms 23 39 37ms 0ms [ User: symmetricds - Total duration: 919ms - Times executed: 946 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 919ms - Times executed: 946 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 20:54:16 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:54:05 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:31:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 708 651ms 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 Jan 26 00 50 46ms 0ms 01 57 53ms 0ms 02 27 23ms 0ms 03 28 26ms 0ms 04 27 25ms 0ms 05 26 24ms 0ms 06 28 25ms 0ms 07 27 24ms 0ms 08 27 25ms 0ms 09 29 26ms 0ms 10 23 20ms 0ms 11 28 25ms 0ms 12 27 25ms 0ms 13 24 21ms 0ms 14 27 25ms 0ms 15 29 26ms 0ms 16 27 24ms 0ms 17 27 24ms 0ms 18 28 26ms 0ms 19 30 27ms 0ms 20 25 22ms 0ms 21 29 26ms 0ms 22 29 26ms 0ms 23 29 26ms 0ms [ User: symmetricds - Total duration: 651ms - Times executed: 708 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 651ms - Times executed: 708 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 12:31:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:33:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 04:21:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 706 620ms 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 Jan 26 00 50 44ms 0ms 01 55 47ms 0ms 02 28 23ms 0ms 03 28 24ms 0ms 04 27 24ms 0ms 05 26 22ms 0ms 06 28 24ms 0ms 07 27 23ms 0ms 08 27 24ms 0ms 09 29 24ms 0ms 10 23 20ms 0ms 11 28 25ms 0ms 12 27 23ms 0ms 13 24 21ms 0ms 14 27 23ms 0ms 15 29 25ms 0ms 16 27 24ms 0ms 17 27 23ms 0ms 18 27 23ms 0ms 19 30 26ms 0ms 20 25 21ms 0ms 21 29 25ms 0ms 22 29 25ms 0ms 23 29 25ms 0ms [ User: symmetricds - Total duration: 620ms - Times executed: 706 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 620ms - Times executed: 706 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-26 13:41:36 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:21:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 20:17:34 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 8ms 0ms 25,780 14s111ms 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 Jan 26 00 1,075 608ms 0ms 01 1,074 609ms 0ms 02 1,074 583ms 0ms 03 1,074 588ms 0ms 04 1,074 583ms 0ms 05 1,074 583ms 0ms 06 1,074 584ms 0ms 07 1,074 591ms 0ms 08 1,074 595ms 0ms 09 1,074 589ms 0ms 10 1,074 587ms 0ms 11 1,074 586ms 0ms 12 1,074 583ms 0ms 13 1,074 582ms 0ms 14 1,074 585ms 0ms 15 1,074 583ms 0ms 16 1,074 582ms 0ms 17 1,077 582ms 0ms 18 1,074 589ms 0ms 19 1,074 580ms 0ms 20 1,074 577ms 0ms 21 1,074 595ms 0ms 22 1,074 590ms 0ms 23 1,074 585ms 0ms [ User: symmetricds - Total duration: 14s111ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s111ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-26 07:23:44 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:15:11 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:15:04 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 15ms 0ms 1,823 994ms INSERT INTO dlx_barcodes (ordernumber, pickdatetime, picker, created, partcode, orderqty, dlx_barcode) VALUES (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 26 00 188 136ms 0ms 01 499 235ms 0ms 02 209 116ms 0ms 03 453 240ms 0ms 04 233 136ms 0ms 05 241 128ms 0ms [ User: pharmisight - Total duration: 994ms - Times executed: 1823 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 994ms - Times executed: 1823 ]
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
-
INSERT INTO DLX_BARCODES (orderNumber, pickDateTime, picker, CREATED, partCode, orderQty, DLX_BARCODE) VALUES ($1, $2, $3, $4, $5, $6, $7);
Date: 2019-01-26 04:20:00 Duration: 15ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 00:20:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 01:00:00 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 2ms 0ms 6,636 720ms 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 Jan 26 00 241 27ms 0ms 01 241 27ms 0ms 02 281 30ms 0ms 03 279 29ms 0ms 04 284 29ms 0ms 05 286 31ms 0ms 06 276 29ms 0ms 07 281 29ms 0ms 08 280 31ms 0ms 09 283 31ms 0ms 10 275 32ms 0ms 11 283 30ms 0ms 12 284 30ms 0ms 13 280 29ms 0ms 14 281 30ms 0ms 15 288 31ms 0ms 16 280 29ms 0ms 17 269 30ms 0ms 18 276 29ms 0ms 19 272 29ms 0ms 20 275 28ms 0ms 21 279 30ms 0ms 22 288 30ms 0ms 23 274 29ms 0ms [ User: symmetricds - Total duration: 720ms - Times executed: 6636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 720ms - Times executed: 6636 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-26 10:25:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 17:51:14 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 08:29:09 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 2ms 0ms 4,450 409ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 26 00 190 18ms 0ms 01 190 20ms 0ms 02 190 18ms 0ms 03 190 18ms 0ms 04 189 17ms 0ms 05 189 18ms 0ms 06 184 17ms 0ms 07 184 15ms 0ms 08 184 18ms 0ms 09 184 17ms 0ms 10 184 16ms 0ms 11 184 17ms 0ms 12 184 17ms 0ms 13 184 16ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 15ms 0ms 17 184 17ms 0ms 18 184 15ms 0ms 19 184 16ms 0ms 20 184 15ms 0ms 21 184 16ms 0ms 22 184 15ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 409ms - Times executed: 4450 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 409ms - Times executed: 4450 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-01-26 08:44:09 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:55:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:20:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 4,510 302ms INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES (?, ?, ?, current_timestamp);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 26 00 412 24ms 0ms 01 1,034 62ms 0ms 02 451 27ms 0ms 03 942 44ms 0ms 04 502 28ms 0ms 05 518 25ms 0ms 06 36 6ms 0ms 07 36 5ms 0ms 08 36 3ms 0ms 09 36 4ms 0ms 10 39 5ms 0ms 11 36 5ms 0ms 12 36 4ms 0ms 13 36 4ms 0ms 14 36 4ms 0ms 15 36 4ms 0ms 16 36 5ms 0ms 17 36 4ms 0ms 18 36 4ms 0ms 19 36 4ms 0ms 20 36 4ms 0ms 21 36 5ms 0ms 22 36 4ms 0ms 23 36 5ms 0ms [ User: symmetricds - Total duration: 302ms - Times executed: 4510 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 302ms - Times executed: 4510 ]
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
-
INSERT INTO sym_data_event (data_id, batch_id, router_id, create_time) VALUES ($1, $2, $3, current_timestamp);
Date: 2019-01-26 06:14:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 06:37:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 02:40:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 25,911 1s255ms 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 #15
Day Hour Count Duration Avg duration Jan 26 00 1,084 51ms 0ms 01 1,084 51ms 0ms 02 1,084 52ms 0ms 03 1,084 52ms 0ms 04 1,084 52ms 0ms 05 1,084 51ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 51ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 51ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,081 52ms 0ms 18 1,078 52ms 0ms 19 1,078 52ms 0ms 20 1,078 51ms 0ms 21 1,078 52ms 0ms 22 1,078 52ms 0ms 23 1,078 52ms 0ms [ User: symmetricds - Total duration: 1s255ms - Times executed: 25911 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s255ms - Times executed: 25911 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-26 04:11:01 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 04:52:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:58:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 2ms 0ms 25,146 1s192ms 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 #16
Day Hour Count Duration Avg duration Jan 26 00 1,102 51ms 0ms 01 1,054 48ms 0ms 02 1,052 49ms 0ms 03 1,054 50ms 0ms 04 1,053 50ms 0ms 05 1,053 51ms 0ms 06 1,044 48ms 0ms 07 1,044 49ms 0ms 08 1,044 50ms 0ms 09 1,042 52ms 0ms 10 1,042 50ms 0ms 11 1,040 49ms 0ms 12 1,040 50ms 0ms 13 1,042 49ms 0ms 14 1,042 48ms 0ms 15 1,044 47ms 0ms 16 1,044 48ms 0ms 17 1,046 49ms 0ms 18 1,044 49ms 0ms 19 1,044 51ms 0ms 20 1,044 46ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,044 49ms 0ms [ User: symmetricds - Total duration: 1s192ms - Times executed: 25146 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s192ms - Times executed: 25146 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-26 10:05:10 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:15:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 13:32:12 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 0ms 0ms 23,952 1s111ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 26 00 998 33ms 0ms 01 998 49ms 0ms 02 998 38ms 0ms 03 998 38ms 0ms 04 998 46ms 0ms 05 998 51ms 0ms 06 998 49ms 0ms 07 998 51ms 0ms 08 998 26ms 0ms 09 998 50ms 0ms 10 998 49ms 0ms 11 998 50ms 0ms 12 998 50ms 0ms 13 998 50ms 0ms 14 998 50ms 0ms 15 998 49ms 0ms 16 998 26ms 0ms 17 998 50ms 0ms 18 998 36ms 0ms 19 998 51ms 0ms 20 998 50ms 0ms 21 998 54ms 0ms 22 998 52ms 0ms 23 998 53ms 0ms [ User: pharmisight - Total duration: 1s111ms - Times executed: 23952 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s111ms - Times executed: 23952 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 21:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 1ms 0ms 6,636 301ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 26 00 241 11ms 0ms 01 241 11ms 0ms 02 281 12ms 0ms 03 279 12ms 0ms 04 284 12ms 0ms 05 286 13ms 0ms 06 276 12ms 0ms 07 281 12ms 0ms 08 280 12ms 0ms 09 283 12ms 0ms 10 275 13ms 0ms 11 283 12ms 0ms 12 284 12ms 0ms 13 280 12ms 0ms 14 281 12ms 0ms 15 288 13ms 0ms 16 280 12ms 0ms 17 269 11ms 0ms 18 276 12ms 0ms 19 272 13ms 0ms 20 275 12ms 0ms 21 279 12ms 0ms 22 288 12ms 0ms 23 274 12ms 0ms [ User: symmetricds - Total duration: 301ms - Times executed: 6636 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 301ms - Times executed: 6636 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-01-26 19:39:15 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 10:23:10 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 11:27:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,593 384ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 26 00 358 15ms 0ms 01 358 16ms 0ms 02 358 15ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 15ms 0ms 07 358 15ms 0ms 08 358 16ms 0ms 09 358 16ms 0ms 10 358 15ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 15ms 0ms 15 358 15ms 0ms 16 358 16ms 0ms 17 359 16ms 0ms 18 358 16ms 0ms 19 358 15ms 0ms 20 358 15ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 358 15ms 0ms [ User: symmetricds - Total duration: 384ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 384ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-01-26 22:58:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 22:28:06 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 19:29:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 21,216 912ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 884 27ms 0ms 01 884 40ms 0ms 02 884 32ms 0ms 03 884 31ms 0ms 04 884 37ms 0ms 05 884 42ms 0ms 06 884 40ms 0ms 07 884 41ms 0ms 08 884 21ms 0ms 09 884 41ms 0ms 10 884 40ms 0ms 11 884 41ms 0ms 12 884 41ms 0ms 13 884 41ms 0ms 14 884 41ms 0ms 15 884 41ms 0ms 16 884 21ms 0ms 17 884 41ms 0ms 18 884 29ms 0ms 19 884 42ms 0ms 20 884 41ms 0ms 21 884 41ms 0ms 22 884 43ms 0ms 23 884 44ms 0ms [ User: pharmisight - Total duration: 912ms - Times executed: 21216 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 912ms - Times executed: 21216 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-26 22:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 09:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-26 23:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,502,768 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET