pgBadger-
Global information
- Generated on Mon Apr 22 00:00:22 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,122,278 log entries in 20s
- Log start from 2019-04-21 00:00:00 to 2019-04-21 23:59:58
-
Overview
Global Stats
- 165 Number of unique normalized queries
- 1,068,919 Number of queries
- 45s45ms Total query duration
- 2019-04-21 00:00:00 First query
- 2019-04-21 23:59:58 Last query
- 1,579 queries/s at 2019-04-21 05:40:00 Query peak
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 42 Total number of automatic vacuums
- 70 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,441 Total number of sessions
- 1 sessions at 2019-04-21 10:19:14 Session peak
- 10d24m33s Total duration of sessions
- 5m54s Average duration of sessions
- 437 Average queries per session
- 18ms Average queries duration per session
- 2,441 Total number of connections
- 6 connections/s at 2019-04-21 00:36:31 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,579 queries/s Query Peak
- 2019-04-21 05:40:00 Date
SELECT Traffic
Key values
- 1,575 queries/s Query Peak
- 2019-04-21 05:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 100 queries/s Query Peak
- 2019-04-21 00:00:02 Date
Queries duration
Key values
- 45s45ms Total query duration
Prepared queries ratio
Key values
- 1.54 Ratio of bind vs prepare
- 171.01 % 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) Apr 21 00 47,211 0ms 63ms 0ms 48ms 57ms 997ms 01 44,278 0ms 51ms 0ms 55ms 74ms 125ms 02 44,174 0ms 50ms 0ms 46ms 57ms 110ms 03 44,362 0ms 53ms 0ms 47ms 58ms 108ms 04 44,187 0ms 43ms 0ms 47ms 64ms 136ms 05 44,213 0ms 40ms 0ms 56ms 60ms 121ms 06 44,187 0ms 56ms 0ms 47ms 63ms 156ms 07 44,358 0ms 37ms 0ms 46ms 60ms 133ms 08 44,209 0ms 41ms 0ms 47ms 63ms 146ms 09 44,158 0ms 15ms 0ms 46ms 61ms 136ms 10 44,200 0ms 13ms 0ms 47ms 54ms 132ms 11 44,307 0ms 29ms 0ms 46ms 61ms 152ms 12 44,216 0ms 13ms 0ms 48ms 57ms 133ms 13 44,248 0ms 17ms 0ms 54ms 69ms 134ms 14 44,281 0ms 13ms 0ms 46ms 60ms 134ms 15 44,553 0ms 14ms 0ms 48ms 57ms 134ms 16 44,656 0ms 13ms 0ms 52ms 61ms 133ms 17 44,641 0ms 12ms 0ms 47ms 57ms 129ms 18 44,796 0ms 13ms 0ms 49ms 58ms 132ms 19 44,634 0ms 12ms 0ms 53ms 64ms 133ms 20 44,975 0ms 21ms 0ms 47ms 59ms 305ms 21 44,608 0ms 12ms 0ms 46ms 57ms 141ms 22 44,727 0ms 13ms 0ms 52ms 62ms 132ms 23 44,740 0ms 12ms 0ms 55ms 60ms 132ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 21 00 16,655 0 0ms 20ms 32ms 450ms 01 14,561 0 0ms 22ms 34ms 44ms 02 14,527 0 0ms 22ms 29ms 41ms 03 14,586 0 0ms 23ms 28ms 42ms 04 14,548 0 0ms 21ms 32ms 53ms 05 14,553 0 0ms 22ms 31ms 46ms 06 14,558 0 0ms 22ms 29ms 57ms 07 14,582 0 0ms 22ms 31ms 52ms 08 14,524 0 0ms 21ms 32ms 50ms 09 14,526 0 0ms 22ms 31ms 46ms 10 14,539 0 0ms 22ms 28ms 39ms 11 14,571 0 0ms 22ms 31ms 46ms 12 14,530 0 0ms 22ms 32ms 41ms 13 14,533 0 0ms 21ms 31ms 44ms 14 14,562 0 0ms 22ms 27ms 42ms 15 14,570 0 0ms 18ms 31ms 41ms 16 14,589 0 0ms 17ms 32ms 45ms 17 14,577 0 0ms 18ms 27ms 42ms 18 14,625 0 0ms 17ms 34ms 49ms 19 14,612 0 0ms 18ms 37ms 51ms 20 15,044 0 0ms 18ms 28ms 125ms 21 14,568 0 0ms 18ms 27ms 44ms 22 14,614 0 0ms 18ms 37ms 45ms 23 14,621 0 0ms 18ms 39ms 44ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 21 00 99 77 80 0 0ms 1ms 4ms 7ms 01 88 53 81 0 0ms 1ms 6ms 7ms 02 88 54 81 0 0ms 1ms 6ms 7ms 03 88 54 83 0 0ms 1ms 6ms 7ms 04 88 53 80 0 0ms 1ms 6ms 7ms 05 88 54 80 0 0ms 1ms 6ms 7ms 06 88 53 81 0 0ms 1ms 6ms 7ms 07 88 54 81 0 0ms 1ms 6ms 7ms 08 88 54 81 0 0ms 1ms 5ms 7ms 09 88 53 81 0 0ms 1ms 6ms 7ms 10 88 54 81 0 0ms 1ms 6ms 7ms 11 88 53 81 0 0ms 1ms 6ms 7ms 12 88 54 83 0 0ms 1ms 5ms 7ms 13 88 54 79 0 0ms 1ms 5ms 7ms 14 88 53 81 0 0ms 1ms 6ms 7ms 15 88 54 82 0 0ms 1ms 1ms 7ms 16 88 53 81 0 0ms 1ms 1ms 7ms 17 88 54 80 0 0ms 1ms 1ms 7ms 18 88 54 81 0 0ms 0ms 1ms 7ms 19 84 66 81 0 0ms 1ms 5ms 7ms 20 105 82 112 0 0ms 0ms 2ms 7ms 21 82 51 81 0 0ms 0ms 1ms 7ms 22 88 53 80 0 0ms 1ms 6ms 7ms 23 88 54 81 0 0ms 1ms 5ms 7ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 21 00 30,033 47,175 1.57 105.84% 01 29,420 44,242 1.50 113.87% 02 29,242 44,138 1.51 113.43% 03 29,387 44,326 1.51 113.54% 04 29,657 44,151 1.49 114.98% 05 29,556 44,177 1.49 114.52% 06 29,740 44,151 1.48 115.29% 07 29,544 44,322 1.50 114.14% 08 29,003 44,173 1.52 112.45% 09 29,291 44,122 1.51 113.67% 10 29,271 44,164 1.51 113.46% 11 29,407 44,271 1.51 113.75% 12 29,184 44,180 1.51 113.13% 13 28,961 44,212 1.53 112.17% 14 29,433 44,245 1.50 113.90% 15 28,326 44,517 1.57 109.09% 16 28,222 44,620 1.58 108.45% 17 28,132 44,605 1.59 108.14% 18 28,138 44,760 1.59 107.80% 19 28,244 44,598 1.58 108.52% 20 28,150 44,939 1.60 106.37% 21 28,113 44,572 1.59 108.22% 22 28,324 44,691 1.58 108.64% 23 28,346 44,704 1.58 108.70% Day Hour Count Average / Second Apr 21 00 89 0.02/s 01 113 0.03/s 02 109 0.03/s 03 112 0.03/s 04 114 0.03/s 05 113 0.03/s 06 117 0.03/s 07 110 0.03/s 08 107 0.03/s 09 112 0.03/s 10 109 0.03/s 11 113 0.03/s 12 108 0.03/s 13 104 0.03/s 14 112 0.03/s 15 93 0.03/s 16 89 0.02/s 17 89 0.02/s 18 86 0.02/s 19 89 0.02/s 20 89 0.02/s 21 87 0.02/s 22 88 0.02/s 23 89 0.02/s Day Hour Count Average Duration Apr 21 00 89 7m 01 113 5m22s 02 109 5m27s 03 112 5m21s 04 114 5m16s 05 113 5m17s 06 117 5m7s 07 110 5m21s 08 107 5m40s 09 112 5m22s 10 109 5m29s 11 113 5m20s 12 108 5m27s 13 104 5m47s 14 112 5m12s 15 93 6m9s 16 89 7m8s 17 89 6m36s 18 86 7m5s 19 89 6m50s 20 89 6m48s 21 87 6m45s 22 88 6m57s 23 89 6m42s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2019-04-21 00:36:31 Date
Connections per database
Key values
- pharmisight Main Database
- 2,441 connections Total
Connections per user
Key values
- pharmisight Main User
- 2,441 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2019-04-21 10:19:14 Date
Histogram of session times
Key values
- 2,004 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,441 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 2,441 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,441 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 491 buffers Checkpoint Peak
- 2019-04-21 03:05:58 Date
- 49.164 seconds Highest write time
- 0.063 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-04-21 04:35:15 Date
Checkpoints distance
Key values
- 1.87 Mo Distance Peak
- 2019-04-21 01:05:31 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 21 00 488 48.953s 0.009s 49.002s 01 561 56.196s 0.011s 56.246s 02 492 49.341s 0.009s 49.39s 03 1,013 101.416s 0.011s 101.494s 04 671 67.305s 0.012s 67.374s 05 522 52.366s 0.073s 52.513s 06 526 52.77s 0.013s 52.832s 07 487 48.851s 0.014s 48.912s 08 627 62.786s 0.014s 62.843s 09 670 67.217s 0.01s 67.269s 10 461 46.255s 0.007s 46.306s 11 600 60.199s 0.009s 60.267s 12 606 60.677s 0.009s 60.73s 13 380 38.111s 0.013s 38.164s 14 464 46.552s 0.01s 46.603s 15 433 43.452s 0.007s 43.505s 16 460 46.157s 0.007s 46.201s 17 338 33.914s 0.011s 33.966s 18 410 41.129s 0.012s 41.183s 19 541 54.274s 0.01s 54.324s 20 362 36.33s 0.012s 36.403s 21 378 37.924s 0.018s 37.98s 22 471 47.236s 0.01s 47.288s 23 437 43.845s 0.004s 43.887s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 21 00 0 0 0 213 0.002s 0s 01 0 0 0 205 0.003s 0s 02 0 0 0 206 0.002s 0s 03 0 0 0 211 0.002s 0s 04 0 0 1 211 0.002s 0s 05 0 0 0 212 0.059s 0.003s 06 0 0 0 208 0.003s 0s 07 0 0 0 205 0.002s 0s 08 0 0 0 210 0.003s 0s 09 0 0 0 218 0.003s 0s 10 0 0 0 202 0.002s 0s 11 0 0 0 204 0.002s 0s 12 0 0 0 212 0.002s 0s 13 0 0 0 196 0.003s 0s 14 0 0 1 206 0.002s 0s 15 0 0 0 206 0.001s 0s 16 0 0 0 194 0.001s 0s 17 0 0 0 198 0.002s 0s 18 0 0 0 197 0.003s 0s 19 0 0 0 210 0.002s 0s 20 0 0 0 203 0.002s 0s 21 0 0 0 187 0.008s 0s 22 0 0 0 199 0.003s 0s 23 0 0 0 197 0.001s 0s Day Hour Count Avg time (sec) Apr 21 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 Apr 21 00 189.62 kB 388.88 kB 01 230.14 kB 741.00 kB 02 173.62 kB 423.25 kB 03 241.14 kB 690.14 kB 04 224.25 kB 434.25 kB 05 205.43 kB 447.43 kB 06 164.00 kB 345.00 kB 07 171.75 kB 410.62 kB 08 191.43 kB 546.71 kB 09 272.14 kB 538.00 kB 10 179.14 kB 528.00 kB 11 152.29 kB 425.86 kB 12 146.00 kB 677.00 kB 13 142.57 kB 362.57 kB 14 167.57 kB 364.14 kB 15 194.75 kB 348.38 kB 16 225.75 kB 306.38 kB 17 123.50 kB 423.25 kB 18 140.00 kB 303.00 kB 19 185.86 kB 409.00 kB 20 146.50 kB 324.12 kB 21 155.71 kB 265.71 kB 22 161.29 kB 356.00 kB 23 150.00 kB 360.14 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 Apr 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (15) Main table analyzed (database pharmisight)
- 70 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data_event 13 pharmisight.public.sym_incoming_batch 11 pharmisight.public.sym_data 11 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_node_host 6 pharmisight.public.item_codes 2 pharmisight.public.flow_report_summary_months 1 Total 70 Vacuums per table
Key values
- public.sym_outgoing_batch (8) Main table vacuumed on database pharmisight
- 42 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_data_event 6 6 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data 6 6 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_incoming_batch 5 5 pharmisight.pg_catalog.pg_statistic 3 3 pharmisight.public.item_codes 1 1 pharmisight.pg_toast.pg_toast_2619 1 1 Total 42 36 Tuples removed per table
Key values
- public.sym_data_event (2458) Main table with removed tuples on database pharmisight
- 8274 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 6 6 2458 1213 pharmisight.public.sym_data 6 6 1860 6900 pharmisight.public.sym_outgoing_batch 8 8 1027 313 pharmisight.pg_catalog.pg_statistic 3 3 995 0 pharmisight.public.sym_incoming_batch 5 5 870 0 pharmisight.public.item_codes 1 1 373 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.pg_toast.pg_toast_2619 1 1 73 0 Total 42 36 8,274 8,426 Pages removed per table
Key values
- public.sym_data (6900) Main table with removed pages on database pharmisight
- 8426 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 6 6 1860 6900 pharmisight.public.sym_data_event 6 6 2458 1213 pharmisight.public.sym_outgoing_batch 8 8 1027 313 pharmisight.pg_catalog.pg_statistic 3 3 995 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.item_codes 1 1 373 0 pharmisight.pg_toast.pg_toast_2619 1 1 73 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_incoming_batch 5 5 870 0 Total 42 36 8,274 8,426 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 21 00 3 2 01 2 4 02 0 3 03 3 3 04 4 4 05 2 3 06 1 2 07 0 4 08 2 3 09 5 3 10 1 3 11 2 3 12 3 4 13 2 2 14 1 3 15 1 4 16 1 3 17 2 1 18 1 3 19 2 4 20 0 2 21 1 1 22 3 3 23 0 3 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 352,175 Total read queries
- 272,373 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,068,919 Requests
- 45s45ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,059,072 Requests
User Request type Count Duration pharmisight Total 53,582 3s799ms DELETE 37 3ms INSERT 37 2ms OTHERS 3,525 137ms SELECT 49,419 3s632ms TCL 510 17ms UPDATE 54 6ms symmetricds Total 1,059,072 42s692ms DELETE 2,005 919ms INSERT 2,181 559ms OTHERS 459,440 7s267ms SELECT 316,443 27s22ms TCL 277,656 5s37ms UPDATE 1,347 1s885ms tony Total 900 278ms SELECT 900 278ms Duration by user
Key values
- 42s692ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 53,582 3s799ms DELETE 37 3ms INSERT 37 2ms OTHERS 3,525 137ms SELECT 49,419 3s632ms TCL 510 17ms UPDATE 54 6ms symmetricds Total 1,059,072 42s692ms DELETE 2,005 919ms INSERT 2,181 559ms OTHERS 459,440 7s267ms SELECT 316,443 27s22ms TCL 277,656 5s37ms UPDATE 1,347 1s885ms tony Total 900 278ms SELECT 900 278ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,112,654 Requests
- 46s491ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,065,902 Requests
- 44s690ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-04-21 06:19:24 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,066,200 0-1ms duration
Slowest individual queries
Rank Duration Query 1 63ms DELETE FROM sym_data WHERE data_id BETWEEN '99892149' AND '99894090' AND create_time < '2019-04-20 00:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 56ms DELETE FROM sym_data WHERE data_id BETWEEN '99892997' AND '99894162' AND create_time < '2019-04-20 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 53ms DELETE FROM sym_data WHERE data_id BETWEEN '99892320' AND '99894126' AND create_time < '2019-04-20 03:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 51ms DELETE FROM sym_data WHERE data_id BETWEEN '99892162' AND '99894102' AND create_time < '2019-04-20 01:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892162' AND '99894102') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892162' AND '99894102' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 50ms DELETE FROM sym_data WHERE data_id BETWEEN '99892174' AND '99894114' AND create_time < '2019-04-20 02:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892174' AND '99894114') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892174' AND '99894114' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 43ms DELETE FROM sym_data WHERE data_id BETWEEN '99892604' AND '99894138' AND create_time < '2019-04-20 04:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892604' AND '99894138') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892604' AND '99894138' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 41ms DELETE FROM sym_data WHERE data_id BETWEEN '99893087' AND '99894186' AND create_time < '2019-04-20 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99893087' AND '99894186') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99893087' AND '99894186' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 40ms DELETE FROM sym_data WHERE data_id BETWEEN '99892920' AND '99894150' AND create_time < '2019-04-20 05:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892920' AND '99894150') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892920' AND '99894150' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 37ms DELETE FROM sym_data WHERE data_id BETWEEN '99893009' AND '99894174' AND create_time < '2019-04-20 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99893009' AND '99894174') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99893009' AND '99894174' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-04-21 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 29ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-04-21 11:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 25ms DELETE FROM sym_data WHERE data_id BETWEEN '99892174' AND '99894102' AND data_id < '99894105' AND create_time < '2019-04-20 01:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892174' AND '99894102');[ Date: 2019-04-21 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 25ms DELETE FROM sym_data WHERE data_id BETWEEN '99892162' AND '99894090' AND data_id < '99894093' AND create_time < '2019-04-20 00:00:00' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892162' AND '99894090');[ Date: 2019-04-21 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 24ms DELETE FROM sym_data WHERE data_id BETWEEN '99893009' AND '99894162' AND data_id < '99894165' AND create_time < '2019-04-20 06:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99893009' AND '99894162');[ Date: 2019-04-21 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 21ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN '2019-04-21 00:00:00' AND '2019-04-22 00:00:00' AND this_.status <> 'Quarantine';[ Date: 2019-04-21 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 18ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-04-21 08:40:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 17ms COMMIT;[ Date: 2019-04-21 13:31:54 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 17ms COMMIT;[ Date: 2019-04-21 03:30:18 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 17ms COMMIT;[ Date: 2019-04-21 01:32:14 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 16ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-04-21 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 16ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_9_0_, this_.routeNumber AS routeNum2_9_0_, this_.roundDeliveryDate AS roundDel3_9_0_, this_.distributionPoint AS distribu4_9_0_, this_.fullyPicked AS fullyPic5_9_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_9_0_, this_.causeOfDelay AS causeOfD7_9_0_, this_.pharmacy100CheckTime AS pharmacy8_9_0_, this_.linesHeldBack AS linesHel9_9_0_, this_.packTime100 AS packTim10_9_0_, this_.replenish AS repleni11_9_0_, this_.comment AS comment12_9_0_, this_.pickDateTime AS pickDat13_9_0_, this_.failedTargetPickTime AS failedT14_9_0_, this_.actualPaperworkCompleteTime AS actualP15_9_0_, this_.changedPickDateTime AS changed16_9_0_, this_.manuallyChangedPickTime AS manuall17_9_0_, this_.CREATED AS CREATED18_9_0_, this_.UPDATED AS UPDATED19_9_0_, this_.note AS note20_9_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = '2019-04-21' ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-04-21 20:00:30 - Database: pharmisight - User: pharmisight - 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 9s764ms 17,197 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 21 01 717 398ms 0ms 02 716 410ms 0ms 03 716 411ms 0ms 04 718 407ms 0ms 05 716 414ms 0ms 06 716 406ms 0ms 07 716 418ms 0ms 08 718 404ms 0ms 09 716 409ms 0ms 10 716 410ms 0ms 11 716 417ms 0ms 12 718 414ms 0ms 13 716 412ms 0ms 14 716 412ms 0ms 15 716 407ms 0ms 16 718 398ms 0ms 17 716 397ms 0ms 18 716 394ms 0ms 19 718 393ms 0ms 20 716 401ms 0ms 21 716 402ms 0ms 22 718 414ms 0ms 23 716 407ms 0ms 00 716 397ms 0ms [ User: symmetricds - Total duration: 9s764ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s764ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-04-21 14:39:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:41:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 11:06:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s677ms 421,816 0ms 10ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 21 01 17,925 275ms 0ms 02 17,479 276ms 0ms 03 17,440 274ms 0ms 04 17,514 272ms 0ms 05 17,432 274ms 0ms 06 17,443 271ms 0ms 07 17,421 272ms 0ms 08 17,517 278ms 0ms 09 17,466 273ms 0ms 10 17,429 275ms 0ms 11 17,449 272ms 0ms 12 17,490 274ms 0ms 13 17,466 277ms 0ms 14 17,487 274ms 0ms 15 17,481 297ms 0ms 16 17,662 280ms 0ms 17 17,717 281ms 0ms 18 17,715 281ms 0ms 19 17,784 279ms 0ms 20 17,691 281ms 0ms 21 17,598 277ms 0ms 22 17,717 284ms 0ms 23 17,745 283ms 0ms 00 17,748 282ms 0ms [ User: symmetricds - Total duration: 6s628ms - Times executed: 420672 ]
[ User: pharmisight - Total duration: 49ms - Times executed: 1144 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s677ms - Times executed: 421816 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-04-21 14:47:52 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 14:27:52 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 07:05:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3s973ms 133,460 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 21 01 5,731 173ms 0ms 02 5,527 193ms 0ms 03 5,515 160ms 0ms 04 5,536 176ms 0ms 05 5,512 159ms 0ms 06 5,517 187ms 0ms 07 5,508 155ms 0ms 08 5,539 157ms 0ms 09 5,523 161ms 0ms 10 5,510 154ms 0ms 11 5,518 154ms 0ms 12 5,530 159ms 0ms 13 5,521 165ms 0ms 14 5,532 209ms 0ms 15 5,528 155ms 0ms 16 5,586 156ms 0ms 17 5,606 164ms 0ms 18 5,608 161ms 0ms 19 5,627 158ms 0ms 20 5,592 159ms 0ms 21 5,561 165ms 0ms 22 5,597 159ms 0ms 23 5,619 162ms 0ms 00 5,617 160ms 0ms [ User: symmetricds - Total duration: 3s959ms - Times executed: 133212 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s973ms - Times executed: 133460 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-04-21 13:31:54 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:30:18 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:32:14 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 1s781ms 153,360 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 21 01 6,980 79ms 0ms 02 6,338 74ms 0ms 03 6,326 73ms 0ms 04 6,356 73ms 0ms 05 6,321 73ms 0ms 06 6,323 72ms 0ms 07 6,319 73ms 0ms 08 6,355 73ms 0ms 09 6,331 72ms 0ms 10 6,326 72ms 0ms 11 6,324 71ms 0ms 12 6,343 72ms 0ms 13 6,338 71ms 0ms 14 6,337 75ms 0ms 15 6,339 74ms 0ms 16 6,406 72ms 0ms 17 6,416 77ms 0ms 18 6,413 76ms 0ms 19 6,445 72ms 0ms 20 6,404 76ms 0ms 21 6,352 73ms 0ms 22 6,416 75ms 0ms 23 6,424 77ms 0ms 00 6,428 73ms 0ms [ User: symmetricds - Total duration: 1s781ms - Times executed: 153360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s781ms - Times executed: 153360 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-04-21 00:38:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:13:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:11:53 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s386ms 959 0ms 4ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? 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 Apr 21 01 32 46ms 1ms 02 47 67ms 1ms 03 45 65ms 1ms 04 47 68ms 1ms 05 53 78ms 1ms 06 53 80ms 1ms 07 54 77ms 1ms 08 46 65ms 1ms 09 43 63ms 1ms 10 47 68ms 1ms 11 49 69ms 1ms 12 48 67ms 1ms 13 44 64ms 1ms 14 44 62ms 1ms 15 49 69ms 1ms 16 31 44ms 1ms 17 29 41ms 1ms 18 29 41ms 1ms 19 26 36ms 1ms 20 29 42ms 1ms 21 29 42ms 1ms 22 27 39ms 1ms 23 29 41ms 1ms 00 29 41ms 1ms [ User: symmetricds - Total duration: 1s386ms - Times executed: 959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s386ms - Times executed: 959 ]
-
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-04-21 05:43:50 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:13:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 04:07:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s228ms 24,896 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 #6
Day Hour Count Duration Avg duration Apr 21 01 1,056 50ms 0ms 02 1,042 52ms 0ms 03 1,038 51ms 0ms 04 1,042 50ms 0ms 05 1,036 50ms 0ms 06 1,038 50ms 0ms 07 1,036 50ms 0ms 08 1,038 51ms 0ms 09 1,036 51ms 0ms 10 1,036 49ms 0ms 11 1,036 51ms 0ms 12 1,038 49ms 0ms 13 1,036 51ms 0ms 14 1,036 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 50ms 0ms 18 1,036 50ms 0ms 19 1,038 51ms 0ms 20 1,032 51ms 0ms 21 1,028 51ms 0ms 22 1,036 52ms 0ms 23 1,036 51ms 0ms 00 1,036 50ms 0ms [ User: symmetricds - Total duration: 1s228ms - Times executed: 24896 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s228ms - Times executed: 24896 ]
-
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-04-21 01:47:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 10:09:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:28:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s152ms 1,218 0ms 4ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 21 01 41 37ms 0ms 02 64 57ms 0ms 03 62 56ms 0ms 04 61 56ms 0ms 05 63 57ms 0ms 06 64 60ms 0ms 07 68 65ms 0ms 08 59 54ms 0ms 09 55 51ms 0ms 10 61 61ms 1ms 11 60 56ms 0ms 12 61 56ms 0ms 13 57 60ms 1ms 14 53 52ms 0ms 15 60 57ms 0ms 16 37 34ms 0ms 17 36 33ms 0ms 18 41 38ms 0ms 19 36 34ms 0ms 20 37 34ms 0ms 21 36 32ms 0ms 22 34 32ms 0ms 23 35 32ms 0ms 00 37 34ms 0ms [ User: symmetricds - Total duration: 1s152ms - Times executed: 1218 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s152ms - Times executed: 1218 ]
-
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-04-21 09:03:51 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:53:52 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:29:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s139ms 24,120 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 21 01 1,005 28ms 0ms 02 1,005 42ms 0ms 03 1,005 34ms 0ms 04 1,005 35ms 0ms 05 1,005 46ms 0ms 06 1,005 38ms 0ms 07 1,005 52ms 0ms 08 1,005 49ms 0ms 09 1,005 53ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 50ms 0ms 13 1,005 49ms 0ms 14 1,005 51ms 0ms 15 1,005 50ms 0ms 16 1,005 50ms 0ms 17 1,005 50ms 0ms 18 1,005 49ms 0ms 19 1,005 51ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 52ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s139ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s139ms - Times executed: 24120 ]
-
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 = '33074306' 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 = '20482650' 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-04-21 18:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 09:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s16ms 21,360 0ms 1ms 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 Apr 21 01 890 25ms 0ms 02 890 38ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 41ms 0ms 06 890 34ms 0ms 07 890 47ms 0ms 08 890 44ms 0ms 09 890 48ms 0ms 10 890 45ms 0ms 11 890 44ms 0ms 12 890 45ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 45ms 0ms 16 890 44ms 0ms 17 890 44ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 44ms 0ms 22 890 47ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s16ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s16ms - Times executed: 21360 ]
-
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 = '1383' 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 = '3292' 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 = '33074040' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-21 08:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 975ms 159 3ms 12ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 21 01 113 722ms 6ms 02 2 13ms 6ms 03 2 9ms 4ms 04 2 15ms 7ms 05 2 8ms 4ms 06 2 13ms 6ms 07 2 8ms 4ms 08 2 8ms 4ms 09 2 8ms 4ms 10 2 8ms 4ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 17ms 8ms 20 2 17ms 8ms 21 2 8ms 4ms 22 2 8ms 4ms 23 2 17ms 8ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 690ms - Times executed: 114 ]
[ User: pharmisight - Total duration: 285ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 975ms - Times executed: 159 ]
-
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-04-21 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:30:18 Duration: 12ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:30:18 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 947ms 188 0ms 7ms 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 Apr 21 01 8 25ms 3ms 02 8 38ms 4ms 03 8 45ms 5ms 04 8 42ms 5ms 05 8 44ms 5ms 06 8 44ms 5ms 07 8 43ms 5ms 08 8 47ms 5ms 09 8 40ms 5ms 10 8 48ms 6ms 11 8 48ms 6ms 12 8 43ms 5ms 13 8 43ms 5ms 14 8 48ms 6ms 15 8 41ms 5ms 16 8 34ms 4ms 17 8 28ms 3ms 18 8 37ms 4ms 19 8 29ms 3ms 20 8 40ms 5ms 21 5 17ms 3ms 22 7 25ms 3ms 23 8 41ms 5ms 00 8 47ms 5ms [ User: symmetricds - Total duration: 947ms - Times executed: 188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 947ms - Times executed: 188 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '164191072', "total_memory_bytes" = '489684992', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 06:45:46', "last_restart_time" = '2019-04-17 15:55:26', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '512027528', "total_memory_bytes" = '748158976', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 23:45:11', "last_restart_time" = '2019-02-19 05:14:14.845', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '516053688', "total_memory_bytes" = '747634688', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 22:00:08', "last_restart_time" = '2019-02-19 05:14:14.845', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2019-04-21 06:47:26 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 23:46:10 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:01:06 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 925ms 987 0ms 2ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? 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 Apr 21 01 33 30ms 0ms 02 50 46ms 0ms 03 50 46ms 0ms 04 49 47ms 0ms 05 53 50ms 0ms 06 54 50ms 0ms 07 56 52ms 0ms 08 49 45ms 0ms 09 45 42ms 0ms 10 50 47ms 0ms 11 49 46ms 0ms 12 50 47ms 0ms 13 47 45ms 0ms 14 43 40ms 0ms 15 50 47ms 0ms 16 32 30ms 0ms 17 29 26ms 0ms 18 29 26ms 0ms 19 26 23ms 0ms 20 29 26ms 0ms 21 29 26ms 0ms 22 27 25ms 0ms 23 29 26ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 925ms - Times executed: 987 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 925ms - Times executed: 987 ]
-
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-04-21 03:05:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:31:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:41:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 911ms 17,292 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 21 01 720 37ms 0ms 02 720 38ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 39ms 0ms 09 720 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 38ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 38ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 39ms 0ms 20 720 38ms 0ms 21 720 38ms 0ms 22 722 37ms 0ms 23 720 38ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 911ms - Times executed: 17292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 911ms - Times executed: 17292 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-04-21 07:12:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 18:15:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 881ms 133,461 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 21 01 5,732 36ms 0ms 02 5,527 35ms 0ms 03 5,515 37ms 0ms 04 5,536 36ms 0ms 05 5,512 35ms 0ms 06 5,517 36ms 0ms 07 5,508 35ms 0ms 08 5,539 35ms 0ms 09 5,523 37ms 0ms 10 5,510 35ms 0ms 11 5,518 35ms 0ms 12 5,530 36ms 0ms 13 5,521 35ms 0ms 14 5,532 36ms 0ms 15 5,528 36ms 0ms 16 5,586 37ms 0ms 17 5,606 37ms 0ms 18 5,608 37ms 0ms 19 5,627 36ms 0ms 20 5,592 37ms 0ms 21 5,561 38ms 0ms 22 5,598 36ms 0ms 23 5,618 37ms 0ms 00 5,617 36ms 0ms [ User: symmetricds - Total duration: 878ms - Times executed: 133212 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 881ms - Times executed: 133461 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-04-21 02:05:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 08:34:58 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:45:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 846ms 960 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 #15
Day Hour Count Duration Avg duration Apr 21 01 33 29ms 0ms 02 48 41ms 0ms 03 47 41ms 0ms 04 47 41ms 0ms 05 51 45ms 0ms 06 51 45ms 0ms 07 53 46ms 0ms 08 47 41ms 0ms 09 44 38ms 0ms 10 48 42ms 0ms 11 48 43ms 0ms 12 48 41ms 0ms 13 45 39ms 0ms 14 43 38ms 0ms 15 49 43ms 0ms 16 31 27ms 0ms 17 29 25ms 0ms 18 29 25ms 0ms 19 26 22ms 0ms 20 29 25ms 0ms 21 29 25ms 0ms 22 27 23ms 0ms 23 29 25ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 846ms - Times executed: 960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 846ms - Times executed: 960 ]
-
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-04-21 10:51:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 23:21:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 04:09:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 691ms 6,232 0ms 1ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 21 01 261 29ms 0ms 02 243 27ms 0ms 03 240 27ms 0ms 04 243 28ms 0ms 05 241 26ms 0ms 06 241 26ms 0ms 07 237 26ms 0ms 08 249 28ms 0ms 09 245 27ms 0ms 10 238 26ms 0ms 11 244 26ms 0ms 12 244 27ms 0ms 13 244 27ms 0ms 14 250 28ms 0ms 15 247 28ms 0ms 16 271 30ms 0ms 17 285 30ms 0ms 18 286 30ms 0ms 19 291 31ms 0ms 20 288 31ms 0ms 21 281 29ms 0ms 22 284 32ms 0ms 23 289 30ms 0ms 00 290 30ms 0ms [ User: symmetricds - Total duration: 691ms - Times executed: 6232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 6232 ]
-
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-04-21 21:48:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:13:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 613ms 96 0ms 8ms 6ms 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 #17
Day Hour Count Duration Avg duration Apr 21 01 4 27ms 6ms 02 4 29ms 7ms 03 4 27ms 6ms 04 4 28ms 7ms 05 4 28ms 7ms 06 4 27ms 6ms 07 4 27ms 6ms 08 4 27ms 6ms 09 4 28ms 7ms 10 4 27ms 6ms 11 4 27ms 6ms 12 4 27ms 6ms 13 4 28ms 7ms 14 4 22ms 5ms 15 4 28ms 7ms 16 4 22ms 5ms 17 4 23ms 5ms 18 4 16ms 4ms 19 4 15ms 3ms 20 4 28ms 7ms 21 4 27ms 6ms 22 4 15ms 3ms 23 4 27ms 6ms 00 4 21ms 5ms [ User: symmetricds - Total duration: 613ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '125136424', total_memory_bytes = '394788864', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 01:41:57', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '147783816', total_memory_bytes = '395313152', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 16:56:59', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '156886792', total_memory_bytes = '394788864', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 08:41:58', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-04-21 01:41:57 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:56:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 08:41:58 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 590ms 139 3ms 10ms 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 #18
Day Hour Count Duration Avg duration Apr 21 01 5 21ms 4ms 02 5 19ms 3ms 03 6 23ms 3ms 04 5 20ms 4ms 05 5 20ms 4ms 06 6 23ms 3ms 07 6 23ms 3ms 08 6 25ms 4ms 09 5 19ms 3ms 10 6 23ms 3ms 11 4 16ms 4ms 12 6 24ms 4ms 13 4 15ms 3ms 14 5 20ms 4ms 15 4 15ms 3ms 16 6 26ms 4ms 17 8 35ms 4ms 18 5 26ms 5ms 19 7 28ms 4ms 20 8 35ms 4ms 21 6 26ms 4ms 22 6 28ms 4ms 23 7 34ms 4ms 00 8 34ms 4ms [ User: symmetricds - Total duration: 590ms - Times executed: 139 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 590ms - Times executed: 139 ]
-
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-04-21 22:42:57 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 17:42:54 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:12:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 540ms 24 4ms 63ms 22ms 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 #19
Day Hour Count Duration Avg duration Apr 21 01 1 63ms 63ms 02 1 51ms 51ms 03 1 50ms 50ms 04 1 53ms 53ms 05 1 43ms 43ms 06 1 40ms 40ms 07 1 56ms 56ms 08 1 37ms 37ms 09 1 41ms 41ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 13 1 12ms 12ms 14 1 8ms 8ms 15 1 4ms 4ms 16 1 5ms 5ms 17 1 4ms 4ms 18 1 6ms 6ms 19 1 8ms 8ms 20 1 12ms 12ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 5ms 5ms 00 1 4ms 4ms [ User: symmetricds - Total duration: 540ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 540ms - Times executed: 24 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892149' AND '99894090' AND create_time < '2019-04-20 00:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892997' AND '99894162' AND create_time < '2019-04-20 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892320' AND '99894126' AND create_time < '2019-04-20 03:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-04-21 00:00:00 Duration: 63ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 06:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:00:00 Duration: 53ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 484ms 17,266 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 21 01 720 19ms 0ms 02 718 20ms 0ms 03 720 20ms 0ms 04 720 19ms 0ms 05 718 19ms 0ms 06 720 19ms 0ms 07 720 20ms 0ms 08 718 19ms 0ms 09 720 19ms 0ms 10 720 20ms 0ms 11 718 19ms 0ms 12 720 19ms 0ms 13 720 19ms 0ms 14 720 20ms 0ms 15 718 19ms 0ms 16 720 20ms 0ms 17 720 21ms 0ms 18 718 20ms 0ms 19 720 20ms 0ms 20 720 20ms 0ms 21 720 20ms 0ms 22 718 20ms 0ms 23 720 20ms 0ms 00 720 20ms 0ms [ User: symmetricds - Total duration: 484ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 484ms - Times executed: 17266 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-04-21 13:05:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:43:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 15:23:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 421,816 6s677ms 0ms 10ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 21 01 17,925 275ms 0ms 02 17,479 276ms 0ms 03 17,440 274ms 0ms 04 17,514 272ms 0ms 05 17,432 274ms 0ms 06 17,443 271ms 0ms 07 17,421 272ms 0ms 08 17,517 278ms 0ms 09 17,466 273ms 0ms 10 17,429 275ms 0ms 11 17,449 272ms 0ms 12 17,490 274ms 0ms 13 17,466 277ms 0ms 14 17,487 274ms 0ms 15 17,481 297ms 0ms 16 17,662 280ms 0ms 17 17,717 281ms 0ms 18 17,715 281ms 0ms 19 17,784 279ms 0ms 20 17,691 281ms 0ms 21 17,598 277ms 0ms 22 17,717 284ms 0ms 23 17,745 283ms 0ms 00 17,748 282ms 0ms [ User: symmetricds - Total duration: 6s628ms - Times executed: 420672 ]
[ User: pharmisight - Total duration: 49ms - Times executed: 1144 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s677ms - Times executed: 421816 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-04-21 14:47:52 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 14:27:52 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 07:05:50 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 153,360 1s781ms 0ms 4ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 21 01 6,980 79ms 0ms 02 6,338 74ms 0ms 03 6,326 73ms 0ms 04 6,356 73ms 0ms 05 6,321 73ms 0ms 06 6,323 72ms 0ms 07 6,319 73ms 0ms 08 6,355 73ms 0ms 09 6,331 72ms 0ms 10 6,326 72ms 0ms 11 6,324 71ms 0ms 12 6,343 72ms 0ms 13 6,338 71ms 0ms 14 6,337 75ms 0ms 15 6,339 74ms 0ms 16 6,406 72ms 0ms 17 6,416 77ms 0ms 18 6,413 76ms 0ms 19 6,445 72ms 0ms 20 6,404 76ms 0ms 21 6,352 73ms 0ms 22 6,416 75ms 0ms 23 6,424 77ms 0ms 00 6,428 73ms 0ms [ User: symmetricds - Total duration: 1s781ms - Times executed: 153360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s781ms - Times executed: 153360 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-04-21 00:38:49 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:13:57 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:11:53 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 133,461 881ms 0ms 1ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 21 01 5,732 36ms 0ms 02 5,527 35ms 0ms 03 5,515 37ms 0ms 04 5,536 36ms 0ms 05 5,512 35ms 0ms 06 5,517 36ms 0ms 07 5,508 35ms 0ms 08 5,539 35ms 0ms 09 5,523 37ms 0ms 10 5,510 35ms 0ms 11 5,518 35ms 0ms 12 5,530 36ms 0ms 13 5,521 35ms 0ms 14 5,532 36ms 0ms 15 5,528 36ms 0ms 16 5,586 37ms 0ms 17 5,606 37ms 0ms 18 5,608 37ms 0ms 19 5,627 36ms 0ms 20 5,592 37ms 0ms 21 5,561 38ms 0ms 22 5,598 36ms 0ms 23 5,618 37ms 0ms 00 5,617 36ms 0ms [ User: symmetricds - Total duration: 878ms - Times executed: 133212 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 249 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 881ms - Times executed: 133461 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-04-21 02:05:49 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 08:34:58 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:45:53 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 133,460 3s973ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 21 01 5,731 173ms 0ms 02 5,527 193ms 0ms 03 5,515 160ms 0ms 04 5,536 176ms 0ms 05 5,512 159ms 0ms 06 5,517 187ms 0ms 07 5,508 155ms 0ms 08 5,539 157ms 0ms 09 5,523 161ms 0ms 10 5,510 154ms 0ms 11 5,518 154ms 0ms 12 5,530 159ms 0ms 13 5,521 165ms 0ms 14 5,532 209ms 0ms 15 5,528 155ms 0ms 16 5,586 156ms 0ms 17 5,606 164ms 0ms 18 5,608 161ms 0ms 19 5,627 158ms 0ms 20 5,592 159ms 0ms 21 5,561 165ms 0ms 22 5,597 159ms 0ms 23 5,619 162ms 0ms 00 5,617 160ms 0ms [ User: symmetricds - Total duration: 3s959ms - Times executed: 133212 ]
[ User: pharmisight - Total duration: 14ms - Times executed: 248 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s973ms - Times executed: 133460 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-04-21 13:31:54 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:30:18 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:32:14 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 24,896 1s228ms 0ms 2ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 21 01 1,056 50ms 0ms 02 1,042 52ms 0ms 03 1,038 51ms 0ms 04 1,042 50ms 0ms 05 1,036 50ms 0ms 06 1,038 50ms 0ms 07 1,036 50ms 0ms 08 1,038 51ms 0ms 09 1,036 51ms 0ms 10 1,036 49ms 0ms 11 1,036 51ms 0ms 12 1,038 49ms 0ms 13 1,036 51ms 0ms 14 1,036 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 50ms 0ms 18 1,036 50ms 0ms 19 1,038 51ms 0ms 20 1,032 51ms 0ms 21 1,028 51ms 0ms 22 1,036 52ms 0ms 23 1,036 51ms 0ms 00 1,036 50ms 0ms [ User: symmetricds - Total duration: 1s228ms - Times executed: 24896 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s228ms - Times executed: 24896 ]
-
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-04-21 01:47:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 10:09:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:28:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,120 1s139ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 21 01 1,005 28ms 0ms 02 1,005 42ms 0ms 03 1,005 34ms 0ms 04 1,005 35ms 0ms 05 1,005 46ms 0ms 06 1,005 38ms 0ms 07 1,005 52ms 0ms 08 1,005 49ms 0ms 09 1,005 53ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 50ms 0ms 13 1,005 49ms 0ms 14 1,005 51ms 0ms 15 1,005 50ms 0ms 16 1,005 50ms 0ms 17 1,005 50ms 0ms 18 1,005 49ms 0ms 19 1,005 51ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 52ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s139ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s139ms - Times executed: 24120 ]
-
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 = '33074306' 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 = '20482650' 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-04-21 18:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 09:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,360 1s16ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 21 01 890 25ms 0ms 02 890 38ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 41ms 0ms 06 890 34ms 0ms 07 890 47ms 0ms 08 890 44ms 0ms 09 890 48ms 0ms 10 890 45ms 0ms 11 890 44ms 0ms 12 890 45ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 45ms 0ms 16 890 44ms 0ms 17 890 44ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 44ms 0ms 22 890 47ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s16ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s16ms - Times executed: 21360 ]
-
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 = '1383' 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 = '3292' 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 = '33074040' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-21 08:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,292 911ms 0ms 1ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 21 01 720 37ms 0ms 02 720 38ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 39ms 0ms 09 720 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 38ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 38ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 39ms 0ms 20 720 38ms 0ms 21 720 38ms 0ms 22 722 37ms 0ms 23 720 38ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 911ms - Times executed: 17292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 911ms - Times executed: 17292 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-04-21 07:12:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 18:15:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,266 484ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 21 01 720 19ms 0ms 02 718 20ms 0ms 03 720 20ms 0ms 04 720 19ms 0ms 05 718 19ms 0ms 06 720 19ms 0ms 07 720 20ms 0ms 08 718 19ms 0ms 09 720 19ms 0ms 10 720 20ms 0ms 11 718 19ms 0ms 12 720 19ms 0ms 13 720 19ms 0ms 14 720 20ms 0ms 15 718 19ms 0ms 16 720 20ms 0ms 17 720 21ms 0ms 18 718 20ms 0ms 19 720 20ms 0ms 20 720 20ms 0ms 21 720 20ms 0ms 22 718 20ms 0ms 23 720 20ms 0ms 00 720 20ms 0ms [ User: symmetricds - Total duration: 484ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 484ms - Times executed: 17266 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = 'NE' GROUP BY node_id, queue;
Date: 2019-04-21 13:05:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:43:17 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 15:23:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,197 9s764ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 21 01 717 398ms 0ms 02 716 410ms 0ms 03 716 411ms 0ms 04 718 407ms 0ms 05 716 414ms 0ms 06 716 406ms 0ms 07 716 418ms 0ms 08 718 404ms 0ms 09 716 409ms 0ms 10 716 410ms 0ms 11 716 417ms 0ms 12 718 414ms 0ms 13 716 412ms 0ms 14 716 412ms 0ms 15 716 407ms 0ms 16 718 398ms 0ms 17 716 397ms 0ms 18 716 394ms 0ms 19 718 393ms 0ms 20 716 401ms 0ms 21 716 402ms 0ms 22 718 414ms 0ms 23 716 407ms 0ms 00 716 397ms 0ms [ User: symmetricds - Total duration: 9s764ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s764ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-04-21 14:39:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:41:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 11:06:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,126 115ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 21 01 380 4ms 0ms 02 380 4ms 0ms 03 380 4ms 0ms 04 381 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 381 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 380 4ms 0ms 12 381 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 380 4ms 0ms 16 381 4ms 0ms 17 380 4ms 0ms 18 380 4ms 0ms 19 381 4ms 0ms 20 380 4ms 0ms 21 380 4ms 0ms 22 381 4ms 0ms 23 380 4ms 0ms 00 380 4ms 0ms [ User: symmetricds - Total duration: 115ms - Times executed: 9126 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 115ms - Times executed: 9126 ]
-
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-04-21 00:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 04:12:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 17:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,123 154ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 21 01 377 6ms 0ms 02 380 6ms 0ms 03 380 6ms 0ms 04 384 6ms 0ms 05 378 6ms 0ms 06 379 6ms 0ms 07 380 6ms 0ms 08 381 6ms 0ms 09 380 6ms 0ms 10 381 6ms 0ms 11 379 6ms 0ms 12 381 6ms 0ms 13 381 7ms 0ms 14 379 6ms 0ms 15 380 6ms 0ms 16 382 6ms 0ms 17 382 6ms 0ms 18 377 6ms 0ms 19 381 6ms 0ms 20 382 6ms 0ms 21 378 6ms 0ms 22 383 6ms 0ms 23 378 6ms 0ms 00 380 6ms 0ms [ User: symmetricds - Total duration: 154ms - Times executed: 9123 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 154ms - Times executed: 9123 ]
-
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-04-21 12:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 05:59:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 11:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 307ms 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 Apr 21 01 358 13ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 359 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 359 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 359 13ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 359 13ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 13ms 0ms 00 358 12ms 0ms [ User: symmetricds - Total duration: 307ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 307ms - Times executed: 8598 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-04-21 00:17:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:04:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:17:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,598 280ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 21 01 358 10ms 0ms 02 358 10ms 0ms 03 358 10ms 0ms 04 359 10ms 0ms 05 358 11ms 0ms 06 358 10ms 0ms 07 358 10ms 0ms 08 359 12ms 0ms 09 358 10ms 0ms 10 358 10ms 0ms 11 358 12ms 0ms 12 359 10ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 359 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 359 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894150' AND '149894149'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894335' AND '149894334'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894365' AND '149894364'));
Date: 2019-04-21 04:43:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 20:05:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:57:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,598 203ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 21 01 358 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 359 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 359 8ms 0ms 13 358 8ms 0ms 14 358 8ms 0ms 15 358 8ms 0ms 16 359 8ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 359 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 359 8ms 0ms 23 358 8ms 0ms 00 358 8ms 0ms [ User: symmetricds - Total duration: 203ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 203ms - Times executed: 8598 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99894190' AND data_id <= '149894189' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99894338' AND data_id <= '149894337' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '99894279' AND data_id <= '149894278' ORDER BY data_id ASC;
Date: 2019-04-21 08:01:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 20:28:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 15:28:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,598 412ms 0ms 1ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 21 01 358 18ms 0ms 02 358 16ms 0ms 03 358 17ms 0ms 04 359 17ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 17ms 0ms 13 358 17ms 0ms 14 358 17ms 0ms 15 358 16ms 0ms 16 359 17ms 0ms 17 358 17ms 0ms 18 358 17ms 0ms 19 359 16ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 17ms 0ms 23 358 17ms 0ms 00 358 16ms 0ms [ User: symmetricds - Total duration: 412ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 412ms - Times executed: 8598 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-04-21 00:23:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 07:01:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:42:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,232 691ms 0ms 1ms 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 Apr 21 01 261 29ms 0ms 02 243 27ms 0ms 03 240 27ms 0ms 04 243 28ms 0ms 05 241 26ms 0ms 06 241 26ms 0ms 07 237 26ms 0ms 08 249 28ms 0ms 09 245 27ms 0ms 10 238 26ms 0ms 11 244 26ms 0ms 12 244 27ms 0ms 13 244 27ms 0ms 14 250 28ms 0ms 15 247 28ms 0ms 16 271 30ms 0ms 17 285 30ms 0ms 18 286 30ms 0ms 19 291 31ms 0ms 20 288 31ms 0ms 21 281 29ms 0ms 22 284 32ms 0ms 23 289 30ms 0ms 00 290 30ms 0ms [ User: symmetricds - Total duration: 691ms - Times executed: 6232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 6232 ]
-
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-04-21 21:48:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:13:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,232 271ms 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 Apr 21 01 261 11ms 0ms 02 243 10ms 0ms 03 240 10ms 0ms 04 243 10ms 0ms 05 241 10ms 0ms 06 241 10ms 0ms 07 237 10ms 0ms 08 249 11ms 0ms 09 245 10ms 0ms 10 238 10ms 0ms 11 244 10ms 0ms 12 244 10ms 0ms 13 244 10ms 0ms 14 250 11ms 0ms 15 247 10ms 0ms 16 271 12ms 0ms 17 285 12ms 0ms 18 286 12ms 0ms 19 291 12ms 0ms 20 288 12ms 0ms 21 281 13ms 0ms 22 283 12ms 0ms 23 290 12ms 0ms 00 290 12ms 0ms [ User: symmetricds - Total duration: 271ms - Times executed: 6232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 271ms - Times executed: 6232 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
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-04-21 20:33:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:07:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 05:33:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,416 408ms 0ms 7ms 0ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 21 01 184 25ms 0ms 02 184 18ms 0ms 03 184 17ms 0ms 04 184 18ms 0ms 05 184 16ms 0ms 06 184 16ms 0ms 07 184 19ms 0ms 08 184 25ms 0ms 09 184 16ms 0ms 10 184 17ms 0ms 11 184 17ms 0ms 12 184 23ms 0ms 13 184 15ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 14ms 0ms 17 184 15ms 0ms 18 184 13ms 0ms 19 184 13ms 0ms 20 184 13ms 0ms 21 184 15ms 0ms 22 184 13ms 0ms 23 184 14ms 0ms 00 184 14ms 0ms [ User: symmetricds - Total duration: 408ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 408ms - Times executed: 4416 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-04-21 07:07:50 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:10:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:41:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,153 67ms 0ms 0ms 0ms SET application_name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 21 01 77 2ms 0ms 02 101 3ms 0ms 03 97 3ms 0ms 04 100 3ms 0ms 05 102 3ms 0ms 06 101 3ms 0ms 07 105 3ms 0ms 08 98 3ms 0ms 09 95 3ms 0ms 10 100 3ms 0ms 11 97 2ms 0ms 12 101 3ms 0ms 13 96 3ms 0ms 14 92 2ms 0ms 15 100 3ms 0ms 16 81 2ms 0ms 17 77 2ms 0ms 18 77 2ms 0ms 19 74 2ms 0ms 20 77 2ms 0ms 21 77 2ms 0ms 22 75 2ms 0ms 23 76 2ms 0ms 00 77 2ms 0ms [ User: pharmisight - Total duration: 36ms - Times executed: 1144 ]
[ User: symmetricds - Total duration: 31ms - Times executed: 1009 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 67ms - Times executed: 2153 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2019-04-21 09:21:31 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 17:24:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 23:19:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4ms 63ms 22ms 24 540ms 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 Apr 21 01 1 63ms 63ms 02 1 51ms 51ms 03 1 50ms 50ms 04 1 53ms 53ms 05 1 43ms 43ms 06 1 40ms 40ms 07 1 56ms 56ms 08 1 37ms 37ms 09 1 41ms 41ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 13 1 12ms 12ms 14 1 8ms 8ms 15 1 4ms 4ms 16 1 5ms 5ms 17 1 4ms 4ms 18 1 6ms 6ms 19 1 8ms 8ms 20 1 12ms 12ms 21 1 4ms 4ms 22 1 4ms 4ms 23 1 5ms 5ms 00 1 4ms 4ms [ User: symmetricds - Total duration: 540ms - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 540ms - Times executed: 24 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892149' AND '99894090' AND create_time < '2019-04-20 00:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892149' AND '99894090' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892997' AND '99894162' AND create_time < '2019-04-20 06:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892997' AND '99894162' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
-
DELETE FROM sym_data WHERE data_id BETWEEN '99892320' AND '99894126' AND create_time < '2019-04-20 03:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '99892320' AND '99894126' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-04-21 00:00:00 Duration: 63ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 06:00:00 Duration: 56ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:00:00 Duration: 53ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 8ms 6ms 96 613ms 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 #2
Day Hour Count Duration Avg duration Apr 21 01 4 27ms 6ms 02 4 29ms 7ms 03 4 27ms 6ms 04 4 28ms 7ms 05 4 28ms 7ms 06 4 27ms 6ms 07 4 27ms 6ms 08 4 27ms 6ms 09 4 28ms 7ms 10 4 27ms 6ms 11 4 27ms 6ms 12 4 27ms 6ms 13 4 28ms 7ms 14 4 22ms 5ms 15 4 28ms 7ms 16 4 22ms 5ms 17 4 23ms 5ms 18 4 16ms 4ms 19 4 15ms 3ms 20 4 28ms 7ms 21 4 27ms 6ms 22 4 15ms 3ms 23 4 27ms 6ms 00 4 21ms 5ms [ User: symmetricds - Total duration: 613ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '125136424', total_memory_bytes = '394788864', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 01:41:57', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '147783816', total_memory_bytes = '395313152', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 16:56:59', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
-
UPDATE sym_node_host SET ip_address = '10.10.10.1', instance_id = 'scancheck-5f79fb2b-712e-4a3f-98c7-7aa08adbace0', os_user = 'root', os_name = 'Linux', os_arch = 'amd64', os_version = '4.9.0-8-amd64', available_processors = '2', free_memory_bytes = '156886792', total_memory_bytes = '394788864', max_memory_bytes = '1908932608', java_version = '1.8.0_181', java_vendor = 'Oracle Corporation', jdbc_version = '42.2.1', symmetric_version = '3.9.15', timezone_offset = '+01:00', heartbeat_time = '2019-04-21 08:41:58', last_restart_time = '2018-12-31 16:23:14.047' WHERE node_id = '3' AND host_name = 'scancheck';
Date: 2019-04-21 01:41:57 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 16:56:59 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 08:41:58 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 12ms 6ms 159 975ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 21 01 113 722ms 6ms 02 2 13ms 6ms 03 2 9ms 4ms 04 2 15ms 7ms 05 2 8ms 4ms 06 2 13ms 6ms 07 2 8ms 4ms 08 2 8ms 4ms 09 2 8ms 4ms 10 2 8ms 4ms 11 2 8ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 17ms 8ms 20 2 17ms 8ms 21 2 8ms 4ms 22 2 8ms 4ms 23 2 17ms 8ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 690ms - Times executed: 114 ]
[ User: pharmisight - Total duration: 285ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 975ms - Times executed: 159 ]
-
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-04-21 00:00:00 Duration: 12ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:30:18 Duration: 12ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:30:18 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 7ms 5ms 188 947ms 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 Apr 21 01 8 25ms 3ms 02 8 38ms 4ms 03 8 45ms 5ms 04 8 42ms 5ms 05 8 44ms 5ms 06 8 44ms 5ms 07 8 43ms 5ms 08 8 47ms 5ms 09 8 40ms 5ms 10 8 48ms 6ms 11 8 48ms 6ms 12 8 43ms 5ms 13 8 43ms 5ms 14 8 48ms 6ms 15 8 41ms 5ms 16 8 34ms 4ms 17 8 28ms 3ms 18 8 37ms 4ms 19 8 29ms 3ms 20 8 40ms 5ms 21 5 17ms 3ms 22 7 25ms 3ms 23 8 41ms 5ms 00 8 47ms 5ms [ User: symmetricds - Total duration: 947ms - Times executed: 188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 947ms - Times executed: 188 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '164191072', "total_memory_bytes" = '489684992', "max_memory_bytes" = '954728448', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 06:45:46', "last_restart_time" = '2019-04-17 15:55:26', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '512027528', "total_memory_bytes" = '748158976', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 23:45:11', "last_restart_time" = '2019-02-19 05:14:14.845', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '185.251.224.165', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '2', "free_memory_bytes" = '516053688', "total_memory_bytes" = '747634688', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_181', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-04-21 22:00:08', "last_restart_time" = '2019-02-19 05:14:14.845', "create_time" = '2018-12-22 05:25:54.609041', "jdbc_version" = '42.2.1', "instance_id" = 'scancheck-d1023de6-bd79-4eed-bd66-87d05333996f' WHERE "node_id" = '0' AND "host_name" = 'scancheck';
Date: 2019-04-21 06:47:26 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 23:46:10 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:01:06 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 3ms 10ms 4ms 139 590ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? 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 Apr 21 01 5 21ms 4ms 02 5 19ms 3ms 03 6 23ms 3ms 04 5 20ms 4ms 05 5 20ms 4ms 06 6 23ms 3ms 07 6 23ms 3ms 08 6 25ms 4ms 09 5 19ms 3ms 10 6 23ms 3ms 11 4 16ms 4ms 12 6 24ms 4ms 13 4 15ms 3ms 14 5 20ms 4ms 15 4 15ms 3ms 16 6 26ms 4ms 17 8 35ms 4ms 18 5 26ms 5ms 19 7 28ms 4ms 20 8 35ms 4ms 21 6 26ms 4ms 22 6 28ms 4ms 23 7 34ms 4ms 00 8 34ms 4ms [ User: symmetricds - Total duration: 590ms - Times executed: 139 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 590ms - Times executed: 139 ]
-
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-04-21 22:42:57 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 17:42:54 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:12:56 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 4ms 1ms 959 1s386ms 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 Apr 21 01 32 46ms 1ms 02 47 67ms 1ms 03 45 65ms 1ms 04 47 68ms 1ms 05 53 78ms 1ms 06 53 80ms 1ms 07 54 77ms 1ms 08 46 65ms 1ms 09 43 63ms 1ms 10 47 68ms 1ms 11 49 69ms 1ms 12 48 67ms 1ms 13 44 64ms 1ms 14 44 62ms 1ms 15 49 69ms 1ms 16 31 44ms 1ms 17 29 41ms 1ms 18 29 41ms 1ms 19 26 36ms 1ms 20 29 42ms 1ms 21 29 42ms 1ms 22 27 39ms 1ms 23 29 41ms 1ms 00 29 41ms 1ms [ User: symmetricds - Total duration: 1s386ms - Times executed: 959 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s386ms - Times executed: 959 ]
-
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-04-21 05:43:50 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:13:52 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 04:07:17 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 4ms 0ms 1,218 1s152ms 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 Apr 21 01 41 37ms 0ms 02 64 57ms 0ms 03 62 56ms 0ms 04 61 56ms 0ms 05 63 57ms 0ms 06 64 60ms 0ms 07 68 65ms 0ms 08 59 54ms 0ms 09 55 51ms 0ms 10 61 61ms 1ms 11 60 56ms 0ms 12 61 56ms 0ms 13 57 60ms 1ms 14 53 52ms 0ms 15 60 57ms 0ms 16 37 34ms 0ms 17 36 33ms 0ms 18 41 38ms 0ms 19 36 34ms 0ms 20 37 34ms 0ms 21 36 32ms 0ms 22 34 32ms 0ms 23 35 32ms 0ms 00 37 34ms 0ms [ User: symmetricds - Total duration: 1s152ms - Times executed: 1218 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s152ms - Times executed: 1218 ]
-
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-04-21 09:03:51 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:53:52 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:29:52 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 2ms 0ms 987 925ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? 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 Apr 21 01 33 30ms 0ms 02 50 46ms 0ms 03 50 46ms 0ms 04 49 47ms 0ms 05 53 50ms 0ms 06 54 50ms 0ms 07 56 52ms 0ms 08 49 45ms 0ms 09 45 42ms 0ms 10 50 47ms 0ms 11 49 46ms 0ms 12 50 47ms 0ms 13 47 45ms 0ms 14 43 40ms 0ms 15 50 47ms 0ms 16 32 30ms 0ms 17 29 26ms 0ms 18 29 26ms 0ms 19 26 23ms 0ms 20 29 26ms 0ms 21 29 26ms 0ms 22 27 25ms 0ms 23 29 26ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 925ms - Times executed: 987 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 925ms - Times executed: 987 ]
-
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-04-21 03:05:22 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 12:31:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:41:21 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 960 846ms 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 Apr 21 01 33 29ms 0ms 02 48 41ms 0ms 03 47 41ms 0ms 04 47 41ms 0ms 05 51 45ms 0ms 06 51 45ms 0ms 07 53 46ms 0ms 08 47 41ms 0ms 09 44 38ms 0ms 10 48 42ms 0ms 11 48 43ms 0ms 12 48 41ms 0ms 13 45 39ms 0ms 14 43 38ms 0ms 15 49 43ms 0ms 16 31 27ms 0ms 17 29 25ms 0ms 18 29 25ms 0ms 19 26 22ms 0ms 20 29 25ms 0ms 21 29 25ms 0ms 22 27 23ms 0ms 23 29 25ms 0ms 00 29 26ms 0ms [ User: symmetricds - Total duration: 846ms - Times executed: 960 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 846ms - Times executed: 960 ]
-
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-04-21 10:51:17 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 23:21:19 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 04:09:20 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 17,197 9s764ms 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 Apr 21 01 717 398ms 0ms 02 716 410ms 0ms 03 716 411ms 0ms 04 718 407ms 0ms 05 716 414ms 0ms 06 716 406ms 0ms 07 716 418ms 0ms 08 718 404ms 0ms 09 716 409ms 0ms 10 716 410ms 0ms 11 716 417ms 0ms 12 718 414ms 0ms 13 716 412ms 0ms 14 716 412ms 0ms 15 716 407ms 0ms 16 718 398ms 0ms 17 716 397ms 0ms 18 716 394ms 0ms 19 718 393ms 0ms 20 716 401ms 0ms 21 716 402ms 0ms 22 718 414ms 0ms 23 716 407ms 0ms 00 716 397ms 0ms [ User: symmetricds - Total duration: 9s764ms - Times executed: 17197 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s764ms - Times executed: 17197 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-04-21 14:39:34 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:41:27 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 11:06:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 6,232 691ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 21 01 261 29ms 0ms 02 243 27ms 0ms 03 240 27ms 0ms 04 243 28ms 0ms 05 241 26ms 0ms 06 241 26ms 0ms 07 237 26ms 0ms 08 249 28ms 0ms 09 245 27ms 0ms 10 238 26ms 0ms 11 244 26ms 0ms 12 244 27ms 0ms 13 244 27ms 0ms 14 250 28ms 0ms 15 247 28ms 0ms 16 271 30ms 0ms 17 285 30ms 0ms 18 286 30ms 0ms 19 291 31ms 0ms 20 288 31ms 0ms 21 281 29ms 0ms 22 284 32ms 0ms 23 289 30ms 0ms 00 290 30ms 0ms [ User: symmetricds - Total duration: 691ms - Times executed: 6232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 691ms - Times executed: 6232 ]
-
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-04-21 21:48:57 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 03:13:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 7ms 0ms 4,416 408ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 21 01 184 25ms 0ms 02 184 18ms 0ms 03 184 17ms 0ms 04 184 18ms 0ms 05 184 16ms 0ms 06 184 16ms 0ms 07 184 19ms 0ms 08 184 25ms 0ms 09 184 16ms 0ms 10 184 17ms 0ms 11 184 17ms 0ms 12 184 23ms 0ms 13 184 15ms 0ms 14 184 16ms 0ms 15 184 15ms 0ms 16 184 14ms 0ms 17 184 15ms 0ms 18 184 13ms 0ms 19 184 13ms 0ms 20 184 13ms 0ms 21 184 15ms 0ms 22 184 13ms 0ms 23 184 14ms 0ms 00 184 14ms 0ms [ User: symmetricds - Total duration: 408ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 408ms - Times executed: 4416 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '0' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-04-21 07:07:50 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:10:49 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 00:41:49 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 17,292 911ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 21 01 720 37ms 0ms 02 720 38ms 0ms 03 720 37ms 0ms 04 722 37ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 38ms 0ms 08 722 39ms 0ms 09 720 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 38ms 0ms 13 720 37ms 0ms 14 720 37ms 0ms 15 720 37ms 0ms 16 722 38ms 0ms 17 720 37ms 0ms 18 720 37ms 0ms 19 722 39ms 0ms 20 720 38ms 0ms 21 720 38ms 0ms 22 722 37ms 0ms 23 720 38ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 911ms - Times executed: 17292 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 911ms - Times executed: 17292 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '1';
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = '0';
Date: 2019-04-21 07:12:24 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 18:15:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:05:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 2ms 0ms 24,896 1s228ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 21 01 1,056 50ms 0ms 02 1,042 52ms 0ms 03 1,038 51ms 0ms 04 1,042 50ms 0ms 05 1,036 50ms 0ms 06 1,038 50ms 0ms 07 1,036 50ms 0ms 08 1,038 51ms 0ms 09 1,036 51ms 0ms 10 1,036 49ms 0ms 11 1,036 51ms 0ms 12 1,038 49ms 0ms 13 1,036 51ms 0ms 14 1,036 51ms 0ms 15 1,036 52ms 0ms 16 1,038 52ms 0ms 17 1,036 50ms 0ms 18 1,036 50ms 0ms 19 1,038 51ms 0ms 20 1,032 51ms 0ms 21 1,028 51ms 0ms 22 1,036 52ms 0ms 23 1,036 51ms 0ms 00 1,036 50ms 0ms [ User: symmetricds - Total duration: 1s228ms - Times executed: 24896 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s228ms - Times executed: 24896 ]
-
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-04-21 01:47:49 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 10:09:51 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:28:52 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 1ms 0ms 8,598 412ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 21 01 358 18ms 0ms 02 358 16ms 0ms 03 358 17ms 0ms 04 359 17ms 0ms 05 358 17ms 0ms 06 358 16ms 0ms 07 358 17ms 0ms 08 359 17ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 17ms 0ms 13 358 17ms 0ms 14 358 17ms 0ms 15 358 16ms 0ms 16 359 17ms 0ms 17 358 17ms 0ms 18 358 17ms 0ms 19 359 16ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 359 17ms 0ms 23 358 17ms 0ms 00 358 16ms 0ms [ User: symmetricds - Total duration: 412ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 412ms - Times executed: 8598 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = 'GP' ORDER BY start_id ASC;
Date: 2019-04-21 00:23:25 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 07:01:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:42:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 1ms 0ms 21,360 1s16ms 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 Apr 21 01 890 25ms 0ms 02 890 38ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 41ms 0ms 06 890 34ms 0ms 07 890 47ms 0ms 08 890 44ms 0ms 09 890 48ms 0ms 10 890 45ms 0ms 11 890 44ms 0ms 12 890 45ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 45ms 0ms 16 890 44ms 0ms 17 890 44ms 0ms 18 890 44ms 0ms 19 890 44ms 0ms 20 890 44ms 0ms 21 890 44ms 0ms 22 890 47ms 0ms 23 890 44ms 0ms 00 890 44ms 0ms [ User: pharmisight - Total duration: 1s16ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s16ms - Times executed: 21360 ]
-
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 = '1383' 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 = '3292' 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 = '33074040' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-04-21 08:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:40:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 24,120 1s139ms 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 Apr 21 01 1,005 28ms 0ms 02 1,005 42ms 0ms 03 1,005 34ms 0ms 04 1,005 35ms 0ms 05 1,005 46ms 0ms 06 1,005 38ms 0ms 07 1,005 52ms 0ms 08 1,005 49ms 0ms 09 1,005 53ms 0ms 10 1,005 50ms 0ms 11 1,005 50ms 0ms 12 1,005 50ms 0ms 13 1,005 49ms 0ms 14 1,005 51ms 0ms 15 1,005 50ms 0ms 16 1,005 50ms 0ms 17 1,005 50ms 0ms 18 1,005 49ms 0ms 19 1,005 51ms 0ms 20 1,005 50ms 0ms 21 1,005 50ms 0ms 22 1,005 52ms 0ms 23 1,005 50ms 0ms 00 1,005 49ms 0ms [ User: pharmisight - Total duration: 1s139ms - Times executed: 24120 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s139ms - Times executed: 24120 ]
-
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 = '33074306' 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 = '20482650' 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-04-21 18:40:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 09: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,232 271ms 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 Apr 21 01 261 11ms 0ms 02 243 10ms 0ms 03 240 10ms 0ms 04 243 10ms 0ms 05 241 10ms 0ms 06 241 10ms 0ms 07 237 10ms 0ms 08 249 11ms 0ms 09 245 10ms 0ms 10 238 10ms 0ms 11 244 10ms 0ms 12 244 10ms 0ms 13 244 10ms 0ms 14 250 11ms 0ms 15 247 10ms 0ms 16 271 12ms 0ms 17 285 12ms 0ms 18 286 12ms 0ms 19 291 12ms 0ms 20 288 12ms 0ms 21 281 13ms 0ms 22 283 12ms 0ms 23 290 12ms 0ms 00 290 12ms 0ms [ User: symmetricds - Total duration: 271ms - Times executed: 6232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 271ms - Times executed: 6232 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '1' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
-
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-04-21 20:33:56 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 13:07:52 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 05:33:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,598 307ms 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 #19
Day Hour Count Duration Avg duration Apr 21 01 358 13ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 359 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 359 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 359 13ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 359 13ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 13ms 0ms 00 358 12ms 0ms [ User: symmetricds - Total duration: 307ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 307ms - Times executed: 8598 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = '3' AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-04-21 00:17:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 01:04:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 21:17:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,598 280ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 21 01 358 10ms 0ms 02 358 10ms 0ms 03 358 10ms 0ms 04 359 10ms 0ms 05 358 11ms 0ms 06 358 10ms 0ms 07 358 10ms 0ms 08 359 12ms 0ms 09 358 10ms 0ms 10 358 10ms 0ms 11 358 12ms 0ms 12 359 10ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 359 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 359 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 359 12ms 0ms 23 358 12ms 0ms 00 358 11ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 8598 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894150' AND '149894149'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894335' AND '149894334'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '99894365' AND '149894364'));
Date: 2019-04-21 04:43:50 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 20:05:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-04-21 22:57:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,122,057 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 21 16 1 - FATAL: no pg_hba.conf entry for host "122.228.19.80", user "root", database "root", SSL off
Date: 2019-04-21 15:06:34 Database: root Application: [unknown] User: root Remote: 122.228.19.80 Code: