pgBadger-
Global information
- Generated on Sun May 12 00:00:22 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,177,849 log entries in 20s
- Log start from 2019-05-11 00:00:00 to 2019-05-11 23:59:59
-
Overview
Global Stats
- 205 Number of unique normalized queries
- 1,088,493 Number of queries
- 51s730ms Total query duration
- 2019-05-11 00:00:00 First query
- 2019-05-11 23:59:59 Last query
- 1,472 queries/s at 2019-05-11 18:40:00 Query peak
- 11 Number of events
- 2 Number of unique normalized events
- 10 Max number of times the same event was reported
- 0 Number of cancellation
- 53 Total number of automatic vacuums
- 75 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,284 Total number of sessions
- 3 sessions at 2019-05-11 00:30:35 Session peak
- 9d23h56m23s Total duration of sessions
- 6m18s Average duration of sessions
- 476 Average queries per session
- 22ms Average queries duration per session
- 2,284 Total number of connections
- 5 connections/s at 2019-05-11 00:30:36 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1,472 queries/s Query Peak
- 2019-05-11 18:40:00 Date
SELECT Traffic
Key values
- 1,444 queries/s Query Peak
- 2019-05-11 22:40:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 164 queries/s Query Peak
- 2019-05-11 03:19:11 Date
Queries duration
Key values
- 51s730ms Total query duration
Prepared queries ratio
Key values
- 1.56 Ratio of bind vs prepare
- 169.68 % 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) May 11 00 55,113 0ms 66ms 0ms 81ms 103ms 1s20ms 01 45,759 0ms 67ms 0ms 69ms 87ms 317ms 02 44,812 0ms 66ms 0ms 58ms 74ms 264ms 03 45,204 0ms 64ms 0ms 71ms 82ms 286ms 04 44,642 0ms 65ms 0ms 67ms 75ms 280ms 05 44,625 0ms 66ms 0ms 60ms 84ms 257ms 06 44,734 0ms 63ms 0ms 61ms 83ms 284ms 07 45,286 0ms 115ms 0ms 67ms 125ms 598ms 08 45,099 0ms 70ms 0ms 63ms 108ms 377ms 09 45,282 0ms 90ms 0ms 61ms 82ms 445ms 10 45,157 0ms 71ms 0ms 64ms 80ms 288ms 11 45,251 0ms 76ms 0ms 58ms 81ms 238ms 12 44,652 0ms 46ms 0ms 60ms 81ms 164ms 13 44,763 0ms 41ms 0ms 53ms 78ms 148ms 14 44,601 0ms 327ms 0ms 57ms 79ms 347ms 15 44,865 0ms 82ms 0ms 55ms 78ms 171ms 16 44,668 0ms 32ms 0ms 53ms 79ms 140ms 17 44,771 0ms 18ms 0ms 59ms 75ms 139ms 18 44,695 0ms 14ms 0ms 50ms 63ms 136ms 19 44,838 0ms 18ms 0ms 48ms 65ms 145ms 20 45,333 0ms 40ms 0ms 52ms 56ms 422ms 21 44,689 0ms 19ms 0ms 49ms 65ms 142ms 22 44,861 0ms 18ms 0ms 52ms 72ms 142ms 23 44,793 0ms 13ms 0ms 42ms 66ms 145ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 11 00 19,521 0 0ms 20ms 43ms 510ms 01 15,210 0 0ms 19ms 43ms 114ms 02 14,859 0 0ms 20ms 36ms 100ms 03 15,028 0 0ms 19ms 39ms 103ms 04 14,744 0 0ms 19ms 37ms 114ms 05 14,666 0 0ms 19ms 36ms 108ms 06 14,725 0 0ms 19ms 38ms 122ms 07 14,985 0 0ms 21ms 45ms 118ms 08 14,814 0 0ms 19ms 41ms 70ms 09 14,897 0 0ms 19ms 35ms 61ms 10 14,813 0 0ms 17ms 38ms 58ms 11 14,842 0 0ms 17ms 37ms 60ms 12 14,588 0 0ms 18ms 38ms 55ms 13 14,619 0 0ms 17ms 33ms 56ms 14 14,598 0 0ms 18ms 37ms 144ms 15 14,655 0 0ms 17ms 36ms 59ms 16 14,585 0 0ms 17ms 31ms 58ms 17 14,623 0 0ms 18ms 30ms 52ms 18 14,610 0 0ms 17ms 28ms 57ms 19 14,682 0 0ms 19ms 33ms 58ms 20 15,210 0 0ms 23ms 33ms 131ms 21 14,598 0 0ms 18ms 29ms 44ms 22 14,644 0 0ms 17ms 28ms 56ms 23 14,631 0 0ms 17ms 28ms 51ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 11 00 570 2,045 104 0 0ms 13ms 15ms 18ms 01 355 243 105 0 0ms 2ms 7ms 17ms 02 201 57 105 0 0ms 1ms 7ms 12ms 03 350 56 105 0 0ms 1ms 7ms 17ms 04 167 57 105 0 1ms 1ms 7ms 10ms 05 93 56 105 0 1ms 1ms 6ms 8ms 06 142 56 106 0 1ms 1ms 7ms 11ms 07 332 66 100 0 1ms 1ms 7ms 17ms 08 247 91 95 0 1ms 1ms 7ms 13ms 09 284 56 92 0 1ms 1ms 7ms 12ms 10 190 57 90 0 1ms 1ms 7ms 11ms 11 213 56 86 0 0ms 1ms 6ms 13ms 12 88 53 86 0 1ms 1ms 5ms 8ms 13 88 54 85 0 0ms 1ms 4ms 8ms 14 88 53 68 0 0ms 1ms 4ms 7ms 15 88 54 84 0 1ms 1ms 5ms 7ms 16 88 54 83 0 0ms 1ms 6ms 8ms 17 88 53 83 0 0ms 1ms 6ms 7ms 18 88 54 80 0 0ms 1ms 6ms 8ms 19 93 74 82 0 0ms 1ms 6ms 8ms 20 112 86 109 0 0ms 0ms 7ms 8ms 21 88 53 82 0 0ms 1ms 5ms 7ms 22 88 54 80 0 0ms 1ms 6ms 7ms 23 88 54 81 0 0ms 1ms 6ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 11 00 33,237 55,077 1.66 92.47% 01 29,893 45,723 1.53 109.67% 02 30,121 44,776 1.49 114.40% 03 30,442 45,168 1.48 114.15% 04 29,738 44,606 1.50 113.62% 05 28,755 44,589 1.55 110.24% 06 29,424 44,698 1.52 112.36% 07 29,601 45,250 1.53 110.88% 08 29,430 45,063 1.53 111.17% 09 28,445 45,246 1.59 106.92% 10 28,431 45,121 1.59 107.52% 11 28,646 45,215 1.58 108.07% 12 28,263 44,616 1.58 108.59% 13 28,283 44,727 1.58 108.41% 14 28,915 44,562 1.54 111.20% 15 28,467 44,829 1.57 108.86% 16 28,076 44,632 1.59 107.85% 17 28,326 44,735 1.58 108.57% 18 28,448 44,659 1.57 109.18% 19 28,453 44,802 1.57 108.72% 20 28,331 45,297 1.60 106.08% 21 28,321 44,653 1.58 108.74% 22 28,271 44,825 1.59 108.14% 23 28,301 44,757 1.58 108.41% Day Hour Count Average / Second May 11 00 90 0.03/s 01 112 0.03/s 02 114 0.03/s 03 119 0.03/s 04 112 0.03/s 05 95 0.03/s 06 105 0.03/s 07 104 0.03/s 08 104 0.03/s 09 87 0.02/s 10 87 0.02/s 11 89 0.02/s 12 87 0.02/s 13 87 0.02/s 14 104 0.03/s 15 88 0.02/s 16 85 0.02/s 17 87 0.02/s 18 89 0.02/s 19 90 0.03/s 20 86 0.02/s 21 88 0.02/s 22 87 0.02/s 23 88 0.02/s Day Hour Count Average Duration May 11 00 90 6m51s 01 112 5m28s 02 114 5m11s 03 119 5m2s 04 112 5m21s 05 95 6m11s 06 105 5m45s 07 104 5m42s 08 104 5m50s 09 87 6m44s 10 87 6m54s 11 89 6m48s 12 87 6m53s 13 97 6m42s 14 94 5m47s 15 88 6m46s 16 85 7m12s 17 87 6m37s 18 89 6m56s 19 90 6m40s 20 86 7m4s 21 88 6m37s 22 87 7m 23 88 6m39s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2019-05-11 00:30:36 Date
Connections per database
Key values
- pharmisight Main Database
- 2,284 connections Total
Connections per user
Key values
- pharmisight Main User
- 2,284 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2019-05-11 00:30:35 Date
Histogram of session times
Key values
- 1,788 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,284 sessions Total
Sessions per user
Key values
- pharmisight Main User
- 2,284 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,284 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,175 buffers Checkpoint Peak
- 2019-05-11 07:04:58 Date
- 149.649 seconds Highest write time
- 0.095 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2019-05-11 07:04:58 Date
Checkpoints distance
Key values
- 86.02 Mo Distance Peak
- 2019-05-11 07:04:58 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 11 00 2,370 237.588s 0.019s 237.674s 01 878 87.989s 0.059s 88.111s 02 529 53.092s 0.012s 53.171s 03 964 96.629s 0.021s 96.717s 04 542 54.375s 0.027s 54.469s 05 499 50.076s 0.017s 50.157s 06 526 52.768s 0.042s 52.88s 07 7,639 195.784s 0.018s 195.87s 08 1,913 187.079s 0.018s 187.163s 09 1,873 187.5s 0.019s 187.605s 10 955 95.614s 0.07s 95.75s 11 1,381 138.465s 0.022s 138.552s 12 877 87.794s 0.018s 87.878s 13 1,222 122.404s 0.018s 122.488s 14 315 31.61s 0.017s 31.691s 15 1,688 169.084s 0.018s 169.167s 16 1,417 142.115s 0.022s 142.202s 17 1,139 113.937s 0.018s 114.018s 18 841 84.261s 0.017s 84.343s 19 569 57.077s 0.015s 57.158s 20 473 47.467s 0.01s 47.526s 21 545 54.685s 0.012s 54.757s 22 453 45.45s 0.02s 45.546s 23 570 57.182s 0.121s 57.373s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 11 00 0 0 1 383 0.003s 0s 01 0 0 0 322 0.044s 0.001s 02 0 0 1 314 0.002s 0s 03 0 0 0 334 0.008s 0s 04 0 0 0 326 0.010s 0s 05 0 0 0 310 0.002s 0s 06 0 0 0 310 0.014s 0s 07 0 0 3 336 0.003s 0s 08 0 0 1 332 0.002s 0s 09 0 0 1 343 0.002s 0s 10 0 0 0 324 0.051s 0.002s 11 0 0 1 335 0.003s 0s 12 0 0 0 311 0.002s 0s 13 0 0 0 314 0.003s 0s 14 0 0 0 240 0.002s 0s 15 0 0 1 311 0.002s 0s 16 0 0 0 319 0.002s 0s 17 0 0 0 334 0.003s 0s 18 0 0 0 316 0.002s 0s 19 0 0 1 304 0.002s 0s 20 0 0 0 243 0.002s 0s 21 0 0 0 279 0.002s 0s 22 0 0 0 292 0.003s 0s 23 0 0 0 293 0.061s 0.004s Day Hour Count Avg time (sec) May 11 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 May 11 00 1,305.00 kB 1,546.75 kB 01 388.00 kB 1,302.08 kB 02 204.75 kB 574.08 kB 03 424.67 kB 807.75 kB 04 180.08 kB 995.25 kB 05 155.83 kB 397.25 kB 06 181.17 kB 458.42 kB 07 3,833.50 kB 26,408.50 kB 08 967.67 kB 8,165.67 kB 09 1,014.00 kB 6,467.75 kB 10 613.25 kB 3,581.58 kB 11 675.50 kB 4,027.50 kB 12 315.25 kB 1,699.17 kB 13 427.85 kB 2,645.08 kB 14 111.73 kB 156.45 kB 15 644.25 kB 2,738.58 kB 16 480.25 kB 1,854.92 kB 17 233.00 kB 972.36 kB 18 181.55 kB 648.91 kB 19 164.55 kB 372.27 kB 20 183.78 kB 536.00 kB 21 156.70 kB 301.10 kB 22 107.33 kB 185.42 kB 23 117.09 kB 312.18 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 May 11 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_incoming_batch (15) Main table analyzed (database pharmisight)
- 75 analyzes Total
Table Number of analyzes pharmisight.public.sym_incoming_batch 15 pharmisight.public.sym_outgoing_batch 14 pharmisight.public.sym_data_event 13 pharmisight.public.sym_data 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 3 pharmisight.public.sym_sequence 1 pharmisight.public.flow_report_summary_delays 1 Total 75 Vacuums per table
Key values
- public.sym_data (10) Main table vacuumed on database pharmisight
- 53 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_data 10 10 pharmisight.public.sym_outgoing_batch 10 10 pharmisight.public.sym_data_event 10 10 pharmisight.public.sym_incoming_batch 6 6 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_node_host 5 0 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.pg_toast.pg_toast_2619 2 2 pharmisight.public.flow_report_summary_days 1 1 pharmisight.public.sym_sequence 1 0 Total 53 47 Tuples removed per table
Key values
- public.sym_data_event (27526) Main table with removed tuples on database pharmisight
- 53947 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 10 10 27526 856 pharmisight.public.sym_data 10 10 19446 6201 pharmisight.public.sym_outgoing_batch 10 10 4452 0 pharmisight.public.sym_incoming_batch 6 6 1181 0 pharmisight.pg_catalog.pg_statistic 2 2 551 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_toast.pg_toast_2619 2 2 155 4 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.flow_report_summary_days 1 1 19 0 Total 53 47 53,947 7,061 Pages removed per table
Key values
- public.sym_data (6201) Main table with removed pages on database pharmisight
- 7061 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 10 10 19446 6201 pharmisight.public.sym_data_event 10 10 27526 856 pharmisight.pg_toast.pg_toast_2619 2 2 155 4 pharmisight.public.sym_incoming_batch 6 6 1181 0 pharmisight.public.flow_report_summary_days 1 1 19 0 pharmisight.public.sym_node_host 5 0 260 0 pharmisight.pg_catalog.pg_statistic 2 2 551 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_outgoing_batch 10 10 4452 0 Total 53 47 53,947 7,061 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 11 00 2 6 01 2 1 02 0 1 03 2 2 04 1 2 05 1 0 06 0 1 07 3 5 08 3 4 09 7 4 10 2 5 11 4 5 12 1 5 13 4 3 14 0 1 15 3 4 16 4 4 17 5 5 18 4 3 19 1 3 20 2 4 21 1 3 22 1 1 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
- 359,147 Total read queries
- 281,840 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,088,490 Requests
- 51s401ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,076,474 Requests
User Request type Count Duration pharmisight Total 56,168 4s213ms DELETE 32 3ms INSERT 65 25ms OTHERS 3,483 136ms SELECT 51,919 4s7ms TCL 612 19ms UPDATE 57 19ms postgres Total 3 329ms SELECT 3 329ms symmetricds Total 1,076,474 48s824ms DELETE 2,238 3s482ms INSERT 4,451 1s312ms OTHERS 462,581 7s368ms SELECT 321,144 27s847ms TCL 282,468 6s28ms UPDATE 3,592 2s785ms tony Total 900 267ms SELECT 900 267ms Duration by user
Key values
- 48s824ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 56,168 4s213ms DELETE 32 3ms INSERT 65 25ms OTHERS 3,483 136ms SELECT 51,919 4s7ms TCL 612 19ms UPDATE 57 19ms postgres Total 3 329ms SELECT 3 329ms symmetricds Total 1,076,474 48s824ms DELETE 2,238 3s482ms INSERT 4,451 1s312ms OTHERS 462,581 7s368ms SELECT 321,144 27s847ms TCL 282,468 6s28ms UPDATE 3,592 2s785ms tony Total 900 267ms SELECT 900 267ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,132,642 Requests
- 53s37ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,085,633 Requests
- 51s61ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-05-11 02:11:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,085,267 0-1ms duration
Slowest individual queries
Rank Duration Query 1 327ms SELECT d.datname AS "Name", pg_catalog.pg_get_userbyid(d.datdba) AS "Owner", pg_catalog.pg_encoding_to_char(d.encoding) AS "Encoding", d.datcollate AS "Collate", d.datctype AS "Ctype", pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1;[ Date: 2019-05-11 14:00:08 - Database: postgres - User: postgres - Remote: [local] - Application: psql ]
2 115ms DELETE FROM sym_data_event WHERE batch_id NOT IN ( SELECT batch_id FROM sym_outgoing_batch WHERE batch_id BETWEEN '8876951' AND '8877570' AND status != 'OK') AND batch_id BETWEEN '8876951' AND '8877570';[ Date: 2019-05-11 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 90ms DELETE FROM sym_data WHERE data_id BETWEEN '100822145' AND '100827145' AND create_time < '2019-05-10 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 82ms DELETE FROM sym_data WHERE data_id BETWEEN '100842813' AND '100847813' AND create_time < '2019-05-10 15:00:00.006' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 15:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 76ms DELETE FROM sym_data WHERE data_id BETWEEN '100834352' AND '100839352' AND create_time < '2019-05-10 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 11:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 71ms DELETE FROM sym_data WHERE data_id BETWEEN '100830039' AND '100835039' AND create_time < '2019-05-10 10:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100830039' AND '100835039') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100830039' AND '100835039' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 10:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 70ms DELETE FROM sym_data WHERE data_id BETWEEN '100815682' AND '100820682' AND create_time < '2019-05-10 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100815682' AND '100820682') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100815682' AND '100820682' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 67ms SELECT count(*) AS col_0_0_ FROM ORDER_ROUNDS orderround0_ WHERE orderround0_.status <> 'Quarantine';[ Date: 2019-05-11 07:23:25 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 67ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 66ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 66ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 66ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 65ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 64ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 63ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);[ Date: 2019-05-11 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 62ms DELETE FROM sym_data WHERE data_id BETWEEN '100794550' AND '100799550' AND create_time < '2019-05-10 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100794550' AND '100799550') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100794550' AND '100799550' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 59ms DELETE FROM sym_data WHERE data_id BETWEEN '100789549' AND '100794549' AND create_time < '2019-05-10 07:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100789549' AND '100794549') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100789549' AND '100794549' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 07:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 56ms DELETE FROM sym_data WHERE data_id BETWEEN '100827146' AND '100832146' AND create_time < '2019-05-10 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100827146' AND '100832146') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100827146' AND '100832146' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 09:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 48ms DELETE FROM sym_data WHERE data_id BETWEEN '100820683' AND '100825683' AND create_time < '2019-05-10 08:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100820683' AND '100825683') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100820683' AND '100825683' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 08:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 46ms DELETE FROM sym_data WHERE data_id BETWEEN '100839014' AND '100844014' AND create_time < '2019-05-10 12:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100839014' AND '100844014') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100839014' AND '100844014' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));[ Date: 2019-05-11 12:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9s713ms 17,195 0ms 1ms 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 May 11 01 717 402ms 0ms 02 716 409ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 410ms 0ms 06 716 410ms 0ms 07 716 405ms 0ms 08 718 412ms 0ms 09 716 409ms 0ms 10 716 406ms 0ms 11 716 402ms 0ms 12 718 393ms 0ms 13 716 393ms 0ms 14 716 398ms 0ms 15 716 402ms 0ms 16 716 403ms 0ms 17 716 399ms 0ms 18 718 400ms 0ms 19 716 409ms 0ms 20 716 390ms 0ms 21 718 404ms 0ms 22 716 402ms 0ms 23 716 406ms 0ms 00 716 399ms 0ms [ User: symmetricds - Total duration: 9s713ms - Times executed: 17195 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s713ms - Times executed: 17195 ]
-
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-05-11 13:13:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:46:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 14:11:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 6s794ms 425,267 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 11 01 18,254 286ms 0ms 02 17,542 278ms 0ms 03 17,518 277ms 0ms 04 17,559 277ms 0ms 05 17,509 280ms 0ms 06 17,614 280ms 0ms 07 17,599 280ms 0ms 08 17,635 276ms 0ms 09 17,677 276ms 0ms 10 17,769 285ms 0ms 11 17,803 283ms 0ms 12 17,830 282ms 0ms 13 17,715 283ms 0ms 14 17,763 282ms 0ms 15 17,680 284ms 0ms 16 17,802 285ms 0ms 17 17,730 289ms 0ms 18 17,768 288ms 0ms 19 17,727 288ms 0ms 20 17,750 285ms 0ms 21 17,707 285ms 0ms 22 17,732 285ms 0ms 23 17,809 286ms 0ms 00 17,775 284ms 0ms [ User: symmetricds - Total duration: 6s745ms - Times executed: 424129 ]
[ User: pharmisight - Total duration: 49ms - Times executed: 1138 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s794ms - Times executed: 425267 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-05-11 04:50:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 13:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:18:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s927ms 135,908 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 11 01 6,851 747ms 0ms 02 5,672 250ms 0ms 03 5,554 199ms 0ms 04 5,565 177ms 0ms 05 5,550 176ms 0ms 06 5,582 179ms 0ms 07 5,579 172ms 0ms 08 5,607 194ms 0ms 09 5,613 191ms 0ms 10 5,637 186ms 0ms 11 5,646 187ms 0ms 12 5,655 170ms 0ms 13 5,606 176ms 0ms 14 5,622 188ms 0ms 15 5,598 166ms 0ms 16 5,635 196ms 0ms 17 5,611 163ms 0ms 18 5,621 167ms 0ms 19 5,612 181ms 0ms 20 5,620 170ms 0ms 21 5,595 156ms 0ms 22 5,612 178ms 0ms 23 5,639 180ms 0ms 00 5,626 167ms 0ms [ User: symmetricds - Total duration: 4s910ms - Times executed: 135612 ]
[ User: pharmisight - Total duration: 16ms - Times executed: 296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s927ms - Times executed: 135908 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-05-11 15:36:19 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:22:57 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:18:10 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s148ms 145 0ms 90ms 14ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 11 01 13 87ms 6ms 02 13 117ms 9ms 03 13 87ms 6ms 04 13 106ms 8ms 05 13 101ms 7ms 06 13 84ms 6ms 07 13 96ms 7ms 08 13 311ms 23ms 09 8 235ms 29ms 10 7 268ms 38ms 11 5 154ms 30ms 12 4 129ms 32ms 13 3 80ms 26ms 14 3 66ms 22ms 16 2 95ms 47ms 17 2 33ms 16ms 18 1 18ms 18ms 19 1 14ms 14ms 20 1 18ms 18ms 21 1 13ms 13ms 22 1 9ms 9ms 23 1 9ms 9ms 00 1 8ms 8ms [ User: symmetricds - Total duration: 2s148ms - Times executed: 145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s148ms - Times executed: 145 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '100822145' AND '100827145' AND create_time < '2019-05-10 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145' 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 '100842813' AND '100847813' AND create_time < '2019-05-10 15:00:00.006' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813' 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 '100834352' AND '100839352' AND create_time < '2019-05-10 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-05-11 09:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 15:00:00 Duration: 82ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:00:00 Duration: 76ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s791ms 155,985 0ms 5ms 0ms SELECT ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 11 01 8,106 89ms 0ms 02 6,505 75ms 0ms 03 6,386 73ms 0ms 04 6,400 83ms 0ms 05 6,382 75ms 0ms 06 6,419 76ms 0ms 07 6,412 75ms 0ms 08 6,432 73ms 0ms 09 6,433 73ms 0ms 10 6,456 76ms 0ms 11 6,469 76ms 0ms 12 6,465 75ms 0ms 13 6,422 75ms 0ms 14 6,437 74ms 0ms 15 6,392 70ms 0ms 16 6,447 71ms 0ms 17 6,428 71ms 0ms 18 6,436 70ms 0ms 19 6,418 73ms 0ms 20 6,436 73ms 0ms 21 6,399 71ms 0ms 22 6,424 70ms 0ms 23 6,444 71ms 0ms 00 6,437 71ms 0ms [ User: symmetricds - Total duration: 1s791ms - Times executed: 155985 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s791ms - Times executed: 155985 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-05-11 03:21:26 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:30:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:41:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s243ms 25,232 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 May 11 01 1,140 58ms 0ms 02 1,060 51ms 0ms 03 1,050 50ms 0ms 04 1,052 49ms 0ms 05 1,050 51ms 0ms 06 1,048 52ms 0ms 07 1,050 51ms 0ms 08 1,054 51ms 0ms 09 1,052 50ms 0ms 10 1,050 53ms 0ms 11 1,050 50ms 0ms 12 1,050 52ms 0ms 13 1,044 52ms 0ms 14 1,044 50ms 0ms 15 1,044 51ms 0ms 16 1,044 51ms 0ms 17 1,044 51ms 0ms 18 1,046 51ms 0ms 19 1,044 53ms 0ms 20 1,046 52ms 0ms 21 1,040 51ms 0ms 22 1,042 50ms 0ms 23 1,044 51ms 0ms 00 1,044 50ms 0ms [ User: symmetricds - Total duration: 1s243ms - Times executed: 25232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s243ms - Times executed: 25232 ]
-
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-05-11 15:06:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:08:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:24:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s190ms 828 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 #7
Day Hour Count Duration Avg duration May 11 01 41 61ms 1ms 02 47 66ms 1ms 03 55 78ms 1ms 04 54 81ms 1ms 05 49 70ms 1ms 06 33 45ms 1ms 07 44 62ms 1ms 08 42 60ms 1ms 09 41 57ms 1ms 10 27 38ms 1ms 11 26 36ms 1ms 12 29 41ms 1ms 13 27 37ms 1ms 14 27 38ms 1ms 15 38 52ms 1ms 16 28 41ms 1ms 17 25 35ms 1ms 18 27 38ms 1ms 19 29 41ms 1ms 20 29 42ms 1ms 21 27 38ms 1ms 22 28 41ms 1ms 23 27 39ms 1ms 00 28 40ms 1ms [ User: symmetricds - Total duration: 1s190ms - Times executed: 828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s190ms - Times executed: 828 ]
-
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-05-11 03:21:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:09:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:52:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s165ms 159 3ms 13ms 7ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 11 01 99 697ms 7ms 02 4 26ms 6ms 03 3 22ms 7ms 04 3 21ms 7ms 05 3 21ms 7ms 06 3 22ms 7ms 07 3 25ms 8ms 08 4 35ms 8ms 09 3 21ms 7ms 10 3 22ms 7ms 11 3 22ms 7ms 12 3 24ms 8ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 18ms 9ms 19 2 18ms 9ms 20 3 27ms 9ms 21 2 18ms 9ms 22 2 17ms 8ms 23 2 18ms 9ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 850ms - Times executed: 114 ]
[ User: pharmisight - Total duration: 314ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s165ms - 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 = 'users' 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-05-11 07:22:57 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:30:39 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:30:39 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s163ms 24,168 0ms 2ms 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 #9
Day Hour Count Duration Avg duration May 11 01 1,007 32ms 0ms 02 1,007 42ms 0ms 03 1,007 34ms 0ms 04 1,007 35ms 0ms 05 1,007 51ms 0ms 06 1,007 50ms 0ms 07 1,007 50ms 0ms 08 1,007 43ms 0ms 09 1,007 42ms 0ms 10 1,007 47ms 0ms 11 1,007 50ms 0ms 12 1,007 52ms 0ms 13 1,007 49ms 0ms 14 1,007 50ms 0ms 15 1,007 55ms 0ms 16 1,007 51ms 0ms 17 1,007 51ms 0ms 18 1,007 54ms 0ms 19 1,007 51ms 0ms 20 1,007 53ms 0ms 21 1,007 50ms 0ms 22 1,007 51ms 0ms 23 1,007 51ms 0ms 00 1,007 57ms 0ms [ User: pharmisight - Total duration: 1s163ms - Times executed: 24168 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s163ms - Times executed: 24168 ]
-
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 = '2939' 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 = '49' 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-05-11 23:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s125ms 188 0ms 10ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 11 01 8 48ms 6ms 02 8 44ms 5ms 03 8 53ms 6ms 04 8 55ms 6ms 05 8 53ms 6ms 06 8 46ms 5ms 07 8 56ms 7ms 08 8 51ms 6ms 09 8 53ms 6ms 10 8 47ms 5ms 11 8 46ms 5ms 12 8 42ms 5ms 13 8 45ms 5ms 14 8 42ms 5ms 15 8 39ms 4ms 16 8 46ms 5ms 17 8 51ms 6ms 18 8 49ms 6ms 19 8 39ms 4ms 20 8 40ms 5ms 21 4 27ms 6ms 22 8 39ms 4ms 23 8 51ms 6ms 00 8 50ms 6ms [ User: symmetricds - Total duration: 1s125ms - Times executed: 188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s125ms - 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" = '218485208', "total_memory_bytes" = '392167424', "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-05-11 06:50:28', "last_restart_time" = '2019-05-07 11:10:22', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '157026440', "total_memory_bytes" = '405798912', "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-05-11 03:05:28', "last_restart_time" = '2019-05-07 11:10:22', "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" = '337814248', "total_memory_bytes" = '1002438656', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-11 08:27:36', "last_restart_time" = '2019-05-07 11:12:08.553', "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-05-11 06:51:11 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:06:10 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 08:26:12 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s32ms 21,360 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 11 01 890 29ms 0ms 02 890 37ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 45ms 0ms 06 890 45ms 0ms 07 890 44ms 0ms 08 890 39ms 0ms 09 890 38ms 0ms 10 890 42ms 0ms 11 890 45ms 0ms 12 890 46ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 50ms 0ms 16 890 45ms 0ms 17 890 45ms 0ms 18 890 48ms 0ms 19 890 44ms 0ms 20 890 46ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 45ms 0ms 00 890 48ms 0ms [ User: pharmisight - Total duration: 1s32ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s32ms - 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 = '33016204' 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 = '33016204' 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 = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s20ms 1,085 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 #12
Day Hour Count Duration Avg duration May 11 01 53 49ms 0ms 02 63 57ms 0ms 03 66 61ms 0ms 04 71 66ms 0ms 05 62 63ms 1ms 06 45 42ms 0ms 07 56 54ms 0ms 08 58 53ms 0ms 09 56 51ms 0ms 10 36 33ms 0ms 11 37 34ms 0ms 12 39 36ms 0ms 13 34 31ms 0ms 14 34 31ms 0ms 15 47 42ms 0ms 16 37 35ms 0ms 17 31 29ms 0ms 18 39 36ms 0ms 19 37 34ms 0ms 20 39 37ms 0ms 21 36 33ms 0ms 22 36 34ms 0ms 23 38 35ms 0ms 00 35 32ms 0ms [ User: symmetricds - Total duration: 1s20ms - Times executed: 1085 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s20ms - Times executed: 1085 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 8 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-11 04:35:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:27:26 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 20:11:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 903ms 135,909 0ms 8ms 0ms BEGIN;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 11 01 6,852 44ms 0ms 02 5,672 36ms 0ms 03 5,554 36ms 0ms 04 5,565 36ms 0ms 05 5,550 36ms 0ms 06 5,582 38ms 0ms 07 5,579 45ms 0ms 08 5,607 36ms 0ms 09 5,613 36ms 0ms 10 5,637 37ms 0ms 11 5,646 37ms 0ms 12 5,655 37ms 0ms 13 5,606 38ms 0ms 14 5,622 36ms 0ms 15 5,598 36ms 0ms 16 5,635 36ms 0ms 17 5,611 36ms 0ms 18 5,621 36ms 0ms 19 5,612 37ms 0ms 20 5,620 36ms 0ms 21 5,595 36ms 0ms 22 5,612 36ms 0ms 23 5,639 38ms 0ms 00 5,626 36ms 0ms [ User: symmetricds - Total duration: 900ms - Times executed: 135612 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 903ms - Times executed: 135909 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-05-11 06:02:27 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:33:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:45:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 895ms 17,296 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 11 01 720 37ms 0ms 02 720 37ms 0ms 03 720 37ms 0ms 04 722 36ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 37ms 0ms 08 724 37ms 0ms 09 722 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 37ms 0ms 13 720 37ms 0ms 14 720 36ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 37ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 724 37ms 0ms 22 720 37ms 0ms 23 720 37ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 895ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 895ms - Times executed: 17296 ]
-
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';
-
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-05-11 14:44:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 23:28:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:18:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 789ms 846 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 #15
Day Hour Count Duration Avg duration May 11 01 41 38ms 0ms 02 51 47ms 0ms 03 55 51ms 0ms 04 57 52ms 0ms 05 52 47ms 0ms 06 37 34ms 0ms 07 44 42ms 0ms 08 44 41ms 0ms 09 42 39ms 0ms 10 27 25ms 0ms 11 27 24ms 0ms 12 29 27ms 0ms 13 27 24ms 0ms 14 27 23ms 0ms 15 37 33ms 0ms 16 28 26ms 0ms 17 25 23ms 0ms 18 28 25ms 0ms 19 29 26ms 0ms 20 29 26ms 0ms 21 27 25ms 0ms 22 28 26ms 0ms 23 27 26ms 0ms 00 28 26ms 0ms [ User: symmetricds - Total duration: 789ms - Times executed: 846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 789ms - Times executed: 846 ]
-
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-05-11 06:32:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 22:36:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:58:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 733ms 830 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 ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 11 01 41 36ms 0ms 02 46 39ms 0ms 03 53 46ms 0ms 04 57 50ms 0ms 05 49 42ms 0ms 06 33 28ms 0ms 07 44 38ms 0ms 08 43 38ms 0ms 09 42 36ms 0ms 10 27 24ms 0ms 11 27 23ms 0ms 12 29 25ms 0ms 13 27 23ms 0ms 14 27 23ms 0ms 15 37 31ms 0ms 16 28 24ms 0ms 17 25 22ms 0ms 18 28 24ms 0ms 19 29 25ms 0ms 20 28 25ms 0ms 21 27 24ms 0ms 22 28 24ms 0ms 23 27 24ms 0ms 00 28 26ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 830 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 830 ]
-
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-05-11 23:34:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:58:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:06:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 722ms 6,443 0ms 3ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 11 01 255 29ms 0ms 02 236 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 237 26ms 0ms 06 258 32ms 0ms 07 250 29ms 0ms 08 248 29ms 0ms 09 258 28ms 0ms 10 280 34ms 0ms 11 285 30ms 0ms 12 289 30ms 0ms 13 276 29ms 0ms 14 282 31ms 0ms 15 276 30ms 0ms 16 289 31ms 0ms 17 277 31ms 0ms 18 279 29ms 0ms 19 277 29ms 0ms 20 278 29ms 0ms 21 278 30ms 0ms 22 280 30ms 0ms 23 291 32ms 0ms 00 285 32ms 0ms [ User: symmetricds - Total duration: 722ms - Times executed: 6443 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 722ms - Times executed: 6443 ]
-
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-05-11 05:25:27 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:15:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:23:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 621ms 1,795 0ms 10ms 0ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 11 01 1,645 585ms 0ms 02 150 36ms 0ms [ User: symmetricds - Total duration: 621ms - Times executed: 1795 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 621ms - Times executed: 1795 ]
-
UPDATE "public"."patients" SET "caloriesday" = '814' WHERE "patient_id" = '98067420';
-
UPDATE "public"."patients" SET "caloriesday" = '1354' WHERE "patient_id" = '200382082';
-
UPDATE "public"."patients" SET "caloriesday" = '1315' WHERE "patient_id" = '52791460';
Date: 2019-05-11 00:30:10 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:52:10 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:16:10 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 613ms 133 0ms 14ms 4ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 11 01 13 59ms 4ms 02 13 57ms 4ms 03 13 57ms 4ms 04 13 58ms 4ms 05 13 57ms 4ms 06 13 58ms 4ms 07 13 57ms 4ms 08 8 28ms 3ms 09 7 23ms 3ms 10 5 56ms 11ms 11 4 37ms 9ms 12 3 17ms 5ms 13 3 15ms 5ms 14 2 11ms 5ms 16 2 4ms 2ms 17 1 2ms 2ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 2ms 2ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 613ms - Times executed: 133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 133 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '100830039' AND '100835039' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100830039' AND '100835039');
-
DELETE FROM sym_data WHERE data_id BETWEEN '100835040' AND '100840040' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100835040' AND '100840040');
-
DELETE FROM sym_data WHERE data_id BETWEEN '100845042' AND '100850042' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100845042' AND '100850042');
Date: 2019-05-11 09:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 594ms 23 1ms 67ms 25ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 11 01 1 66ms 66ms 02 1 67ms 67ms 03 1 66ms 66ms 04 1 64ms 64ms 05 1 65ms 65ms 06 1 66ms 66ms 07 1 63ms 63ms 08 1 36ms 36ms 09 1 19ms 19ms 10 1 18ms 18ms 11 1 16ms 16ms 12 1 9ms 9ms 13 1 8ms 8ms 14 1 7ms 7ms 16 1 4ms 4ms 17 1 2ms 2ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 2ms 2ms 21 1 2ms 2ms 22 1 1ms 1ms 23 1 2ms 2ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 594ms - Times executed: 23 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 594ms - Times executed: 23 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-05-11 01:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:00:00 Duration: 66ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:00:00 Duration: 66ms 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 425,267 6s794ms 0ms 4ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 11 01 18,254 286ms 0ms 02 17,542 278ms 0ms 03 17,518 277ms 0ms 04 17,559 277ms 0ms 05 17,509 280ms 0ms 06 17,614 280ms 0ms 07 17,599 280ms 0ms 08 17,635 276ms 0ms 09 17,677 276ms 0ms 10 17,769 285ms 0ms 11 17,803 283ms 0ms 12 17,830 282ms 0ms 13 17,715 283ms 0ms 14 17,763 282ms 0ms 15 17,680 284ms 0ms 16 17,802 285ms 0ms 17 17,730 289ms 0ms 18 17,768 288ms 0ms 19 17,727 288ms 0ms 20 17,750 285ms 0ms 21 17,707 285ms 0ms 22 17,732 285ms 0ms 23 17,809 286ms 0ms 00 17,775 284ms 0ms [ User: symmetricds - Total duration: 6s745ms - Times executed: 424129 ]
[ User: pharmisight - Total duration: 49ms - Times executed: 1138 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6s794ms - Times executed: 425267 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-05-11 04:50:27 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 13:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:18:32 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 155,985 1s791ms 0ms 5ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 11 01 8,106 89ms 0ms 02 6,505 75ms 0ms 03 6,386 73ms 0ms 04 6,400 83ms 0ms 05 6,382 75ms 0ms 06 6,419 76ms 0ms 07 6,412 75ms 0ms 08 6,432 73ms 0ms 09 6,433 73ms 0ms 10 6,456 76ms 0ms 11 6,469 76ms 0ms 12 6,465 75ms 0ms 13 6,422 75ms 0ms 14 6,437 74ms 0ms 15 6,392 70ms 0ms 16 6,447 71ms 0ms 17 6,428 71ms 0ms 18 6,436 70ms 0ms 19 6,418 73ms 0ms 20 6,436 73ms 0ms 21 6,399 71ms 0ms 22 6,424 70ms 0ms 23 6,444 71ms 0ms 00 6,437 71ms 0ms [ User: symmetricds - Total duration: 1s791ms - Times executed: 155985 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s791ms - Times executed: 155985 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-05-11 03:21:26 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:30:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:41:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 135,909 903ms 0ms 8ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 11 01 6,852 44ms 0ms 02 5,672 36ms 0ms 03 5,554 36ms 0ms 04 5,565 36ms 0ms 05 5,550 36ms 0ms 06 5,582 38ms 0ms 07 5,579 45ms 0ms 08 5,607 36ms 0ms 09 5,613 36ms 0ms 10 5,637 37ms 0ms 11 5,646 37ms 0ms 12 5,655 37ms 0ms 13 5,606 38ms 0ms 14 5,622 36ms 0ms 15 5,598 36ms 0ms 16 5,635 36ms 0ms 17 5,611 36ms 0ms 18 5,621 36ms 0ms 19 5,612 37ms 0ms 20 5,620 36ms 0ms 21 5,595 36ms 0ms 22 5,612 36ms 0ms 23 5,639 38ms 0ms 00 5,626 36ms 0ms [ User: symmetricds - Total duration: 900ms - Times executed: 135612 ]
[ User: pharmisight - Total duration: 2ms - Times executed: 297 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 903ms - Times executed: 135909 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-05-11 06:02:27 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:33:30 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:45:27 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 135,908 4s927ms 0ms 18ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 11 01 6,851 747ms 0ms 02 5,672 250ms 0ms 03 5,554 199ms 0ms 04 5,565 177ms 0ms 05 5,550 176ms 0ms 06 5,582 179ms 0ms 07 5,579 172ms 0ms 08 5,607 194ms 0ms 09 5,613 191ms 0ms 10 5,637 186ms 0ms 11 5,646 187ms 0ms 12 5,655 170ms 0ms 13 5,606 176ms 0ms 14 5,622 188ms 0ms 15 5,598 166ms 0ms 16 5,635 196ms 0ms 17 5,611 163ms 0ms 18 5,621 167ms 0ms 19 5,612 181ms 0ms 20 5,620 170ms 0ms 21 5,595 156ms 0ms 22 5,612 178ms 0ms 23 5,639 180ms 0ms 00 5,626 167ms 0ms [ User: symmetricds - Total duration: 4s910ms - Times executed: 135612 ]
[ User: pharmisight - Total duration: 16ms - Times executed: 296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s927ms - Times executed: 135908 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-05-11 15:36:19 Duration: 18ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:22:57 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:18:10 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 25,232 1s243ms 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 May 11 01 1,140 58ms 0ms 02 1,060 51ms 0ms 03 1,050 50ms 0ms 04 1,052 49ms 0ms 05 1,050 51ms 0ms 06 1,048 52ms 0ms 07 1,050 51ms 0ms 08 1,054 51ms 0ms 09 1,052 50ms 0ms 10 1,050 53ms 0ms 11 1,050 50ms 0ms 12 1,050 52ms 0ms 13 1,044 52ms 0ms 14 1,044 50ms 0ms 15 1,044 51ms 0ms 16 1,044 51ms 0ms 17 1,044 51ms 0ms 18 1,046 51ms 0ms 19 1,044 53ms 0ms 20 1,046 52ms 0ms 21 1,040 51ms 0ms 22 1,042 50ms 0ms 23 1,044 51ms 0ms 00 1,044 50ms 0ms [ User: symmetricds - Total duration: 1s243ms - Times executed: 25232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s243ms - Times executed: 25232 ]
-
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-05-11 15:06:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:08:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:24:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 24,168 1s163ms 0ms 2ms 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 May 11 01 1,007 32ms 0ms 02 1,007 42ms 0ms 03 1,007 34ms 0ms 04 1,007 35ms 0ms 05 1,007 51ms 0ms 06 1,007 50ms 0ms 07 1,007 50ms 0ms 08 1,007 43ms 0ms 09 1,007 42ms 0ms 10 1,007 47ms 0ms 11 1,007 50ms 0ms 12 1,007 52ms 0ms 13 1,007 49ms 0ms 14 1,007 50ms 0ms 15 1,007 55ms 0ms 16 1,007 51ms 0ms 17 1,007 51ms 0ms 18 1,007 54ms 0ms 19 1,007 51ms 0ms 20 1,007 53ms 0ms 21 1,007 50ms 0ms 22 1,007 51ms 0ms 23 1,007 51ms 0ms 00 1,007 57ms 0ms [ User: pharmisight - Total duration: 1s163ms - Times executed: 24168 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s163ms - Times executed: 24168 ]
-
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 = '2939' 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 = '49' 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-05-11 23:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 21,360 1s32ms 0ms 0ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 11 01 890 29ms 0ms 02 890 37ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 45ms 0ms 06 890 45ms 0ms 07 890 44ms 0ms 08 890 39ms 0ms 09 890 38ms 0ms 10 890 42ms 0ms 11 890 45ms 0ms 12 890 46ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 50ms 0ms 16 890 45ms 0ms 17 890 45ms 0ms 18 890 48ms 0ms 19 890 44ms 0ms 20 890 46ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 45ms 0ms 00 890 48ms 0ms [ User: pharmisight - Total duration: 1s32ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s32ms - 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 = '33016204' 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 = '33016204' 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 = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 17,296 895ms 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 11 01 720 37ms 0ms 02 720 37ms 0ms 03 720 37ms 0ms 04 722 36ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 37ms 0ms 08 724 37ms 0ms 09 722 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 37ms 0ms 13 720 37ms 0ms 14 720 36ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 37ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 724 37ms 0ms 22 720 37ms 0ms 23 720 37ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 895ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 895ms - Times executed: 17296 ]
-
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';
-
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-05-11 14:44:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 23:28:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:18:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 17,266 477ms 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 May 11 01 720 20ms 0ms 02 720 19ms 0ms 03 718 20ms 0ms 04 720 20ms 0ms 05 720 19ms 0ms 06 718 19ms 0ms 07 720 19ms 0ms 08 720 19ms 0ms 09 720 19ms 0ms 10 718 20ms 0ms 11 720 20ms 0ms 12 720 20ms 0ms 13 718 20ms 0ms 14 720 20ms 0ms 15 718 19ms 0ms 16 720 19ms 0ms 17 718 19ms 0ms 18 720 19ms 0ms 19 720 18ms 0ms 20 720 19ms 0ms 21 718 19ms 0ms 22 720 19ms 0ms 23 720 19ms 0ms 00 720 19ms 0ms [ User: symmetricds - Total duration: 477ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 477ms - 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-05-11 19:43:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 23:11:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 15:21:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,195 9s713ms 0ms 1ms 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 May 11 01 717 402ms 0ms 02 716 409ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 410ms 0ms 06 716 410ms 0ms 07 716 405ms 0ms 08 718 412ms 0ms 09 716 409ms 0ms 10 716 406ms 0ms 11 716 402ms 0ms 12 718 393ms 0ms 13 716 393ms 0ms 14 716 398ms 0ms 15 716 402ms 0ms 16 716 403ms 0ms 17 716 399ms 0ms 18 718 400ms 0ms 19 716 409ms 0ms 20 716 390ms 0ms 21 718 404ms 0ms 22 716 402ms 0ms 23 716 406ms 0ms 00 716 399ms 0ms [ User: symmetricds - Total duration: 9s713ms - Times executed: 17195 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s713ms - Times executed: 17195 ]
-
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-05-11 13:13:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:46:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 14:11:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,127 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 May 11 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 385 4ms 0ms 09 384 4ms 0ms 10 380 4ms 0ms 11 380 4ms 0ms 12 381 4ms 0ms 13 380 4ms 0ms 14 380 4ms 0ms 15 370 4ms 0ms 16 380 4ms 0ms 17 380 4ms 0ms 18 381 4ms 0ms 19 380 4ms 0ms 20 380 4ms 0ms 21 385 4ms 0ms 22 380 4ms 0ms 23 380 4ms 0ms 00 380 4ms 0ms [ User: symmetricds - Total duration: 115ms - Times executed: 9127 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 115ms - Times executed: 9127 ]
-
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-05-11 11:46:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,126 152ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 11 01 379 6ms 0ms 02 380 6ms 0ms 03 380 6ms 0ms 04 381 6ms 0ms 05 380 6ms 0ms 06 381 6ms 0ms 07 382 6ms 0ms 08 385 6ms 0ms 09 381 6ms 0ms 10 380 6ms 0ms 11 382 6ms 0ms 12 379 6ms 0ms 13 380 6ms 0ms 14 380 6ms 0ms 15 370 6ms 0ms 16 380 6ms 0ms 17 380 6ms 0ms 18 383 6ms 0ms 19 378 6ms 0ms 20 381 6ms 0ms 21 386 6ms 0ms 22 380 6ms 0ms 23 378 6ms 0ms 00 380 6ms 0ms [ User: symmetricds - Total duration: 152ms - Times executed: 9126 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 152ms - Times executed: 9126 ]
-
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-05-11 02:22:28 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:03:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,598 398ms 0ms 0ms 0ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 11 01 358 17ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 359 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 359 16ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 16ms 0ms 13 358 17ms 0ms 14 358 16ms 0ms 15 359 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 359 16ms 0ms 19 358 15ms 0ms 20 358 17ms 0ms 21 359 16ms 0ms 22 358 16ms 0ms 23 358 16ms 0ms 00 358 16ms 0ms [ User: symmetricds - Total duration: 398ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 398ms - 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-05-11 19:50:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:42:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 19:43:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,597 212ms 0ms 0ms 0ms SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= ? AND data_id <= ? ORDER BY data_id ASC;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 11 01 358 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 359 8ms 0ms 05 358 9ms 0ms 06 358 9ms 0ms 07 358 9ms 0ms 08 359 8ms 0ms 09 358 8ms 0ms 10 358 9ms 0ms 11 358 9ms 0ms 12 359 8ms 0ms 13 358 9ms 0ms 14 358 8ms 0ms 15 358 8ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 359 8ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 359 8ms 0ms 22 358 8ms 0ms 23 358 8ms 0ms 00 358 8ms 0ms [ User: symmetricds - Total duration: 212ms - Times executed: 8597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 212ms - Times executed: 8597 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '100852451' AND data_id <= '150852450' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '100852370' AND data_id <= '150852369' ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= '100852365' AND data_id <= '150852364' ORDER BY data_id ASC;
Date: 2019-05-11 09:07:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:40:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:14:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,597 304ms 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 #15
Day Hour Count Duration Avg duration May 11 01 358 12ms 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 13ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 359 13ms 0ms 13 358 13ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 359 12ms 0ms 19 358 12ms 0ms 20 358 13ms 0ms 21 359 12ms 0ms 22 358 12ms 0ms 23 358 12ms 0ms 00 358 13ms 0ms [ User: symmetricds - Total duration: 304ms - Times executed: 8597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 304ms - Times executed: 8597 ]
-
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-05-11 19:50:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 08:36:29 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:14:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,597 269ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 11 01 358 11ms 0ms 02 358 11ms 0ms 03 358 11ms 0ms 04 359 12ms 0ms 05 358 12ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 359 10ms 0ms 09 358 10ms 0ms 10 358 10ms 0ms 11 358 10ms 0ms 12 359 10ms 0ms 13 358 10ms 0ms 14 358 10ms 0ms 15 358 11ms 0ms 16 358 10ms 0ms 17 358 10ms 0ms 18 359 10ms 0ms 19 358 10ms 0ms 20 358 11ms 0ms 21 359 10ms 0ms 22 358 10ms 0ms 23 358 11ms 0ms 00 358 10ms 0ms [ User: symmetricds - Total duration: 269ms - Times executed: 8597 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 269ms - Times executed: 8597 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '100852375' AND '150852374'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '100852563' AND '150852562'));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN '100852375' AND '150852374'));
Date: 2019-05-11 05:03:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 18:32:08 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:02:36 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,443 298ms 0ms 2ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 11 01 255 14ms 0ms 02 236 10ms 0ms 03 239 11ms 0ms 04 240 11ms 0ms 05 237 10ms 0ms 06 258 12ms 0ms 07 250 12ms 0ms 08 248 11ms 0ms 09 258 11ms 0ms 10 280 12ms 0ms 11 285 12ms 0ms 12 289 12ms 0ms 13 276 12ms 0ms 14 282 12ms 0ms 15 276 13ms 0ms 16 289 13ms 0ms 17 277 12ms 0ms 18 279 12ms 0ms 19 277 12ms 0ms 20 278 12ms 0ms 21 278 12ms 0ms 22 280 12ms 0ms 23 291 13ms 0ms 00 285 12ms 0ms [ User: symmetricds - Total duration: 298ms - Times executed: 6443 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 298ms - Times executed: 6443 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-05-11 00:02:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:17:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:37:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,443 722ms 0ms 3ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 11 01 255 29ms 0ms 02 236 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 237 26ms 0ms 06 258 32ms 0ms 07 250 29ms 0ms 08 248 29ms 0ms 09 258 28ms 0ms 10 280 34ms 0ms 11 285 30ms 0ms 12 289 30ms 0ms 13 276 29ms 0ms 14 282 31ms 0ms 15 276 30ms 0ms 16 289 31ms 0ms 17 277 31ms 0ms 18 279 29ms 0ms 19 277 29ms 0ms 20 278 29ms 0ms 21 278 30ms 0ms 22 280 30ms 0ms 23 291 32ms 0ms 00 285 32ms 0ms [ User: symmetricds - Total duration: 722ms - Times executed: 6443 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 722ms - Times executed: 6443 ]
-
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-05-11 05:25:27 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:15:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:23:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,422 435ms 0ms 4ms 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 May 11 01 184 17ms 0ms 02 184 21ms 0ms 03 184 24ms 0ms 04 184 20ms 0ms 05 184 17ms 0ms 06 184 17ms 0ms 07 184 18ms 0ms 08 186 17ms 0ms 09 186 17ms 0ms 10 184 17ms 0ms 11 184 18ms 0ms 12 184 16ms 0ms 13 184 22ms 0ms 14 184 21ms 0ms 15 184 18ms 0ms 16 184 15ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 17ms 0ms 20 184 16ms 0ms 21 186 18ms 0ms 22 184 15ms 0ms 23 184 16ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 435ms - Times executed: 4422 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 435ms - Times executed: 4422 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '1' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-05-11 02:55:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 13:44:30 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:50:30 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 2,796 128ms 0ms 0ms 0ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 11 01 1,432 33ms 0ms 02 208 7ms 0ms 03 60 4ms 0ms 04 60 4ms 0ms 05 60 4ms 0ms 06 56 4ms 0ms 07 60 5ms 0ms 08 60 4ms 0ms 09 60 4ms 0ms 10 60 4ms 0ms 11 60 4ms 0ms 12 56 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 3ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 52 3ms 0ms 21 32 2ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 128ms - Times executed: 2796 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 128ms - Times executed: 2796 ]
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-05-11 06:51:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:31:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 08:56:12 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 1ms 67ms 25ms 23 594ms SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 11 01 1 66ms 66ms 02 1 67ms 67ms 03 1 66ms 66ms 04 1 64ms 64ms 05 1 65ms 65ms 06 1 66ms 66ms 07 1 63ms 63ms 08 1 36ms 36ms 09 1 19ms 19ms 10 1 18ms 18ms 11 1 16ms 16ms 12 1 9ms 9ms 13 1 8ms 8ms 14 1 7ms 7ms 16 1 4ms 4ms 17 1 2ms 2ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 2ms 2ms 21 1 2ms 2ms 22 1 1ms 1ms 23 1 2ms 2ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 594ms - Times executed: 23 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 594ms - Times executed: 23 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
-
SELECT DISTINCT channel_id FROM sym_data WHERE channel_id NOT IN ( SELECT channel_id FROM sym_channel);
Date: 2019-05-11 01:00:00 Duration: 67ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:00:00 Duration: 66ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:00:00 Duration: 66ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 0ms 90ms 14ms 145 2s148ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND create_time < ? AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ? AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != ?)));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 11 01 13 87ms 6ms 02 13 117ms 9ms 03 13 87ms 6ms 04 13 106ms 8ms 05 13 101ms 7ms 06 13 84ms 6ms 07 13 96ms 7ms 08 13 311ms 23ms 09 8 235ms 29ms 10 7 268ms 38ms 11 5 154ms 30ms 12 4 129ms 32ms 13 3 80ms 26ms 14 3 66ms 22ms 16 2 95ms 47ms 17 2 33ms 16ms 18 1 18ms 18ms 19 1 14ms 14ms 20 1 18ms 18ms 21 1 13ms 13ms 22 1 9ms 9ms 23 1 9ms 9ms 00 1 8ms 8ms [ User: symmetricds - Total duration: 2s148ms - Times executed: 145 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s148ms - Times executed: 145 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '100822145' AND '100827145' AND create_time < '2019-05-10 09:00:00.001' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100822145' AND '100827145' 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 '100842813' AND '100847813' AND create_time < '2019-05-10 15:00:00.006' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100842813' AND '100847813' 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 '100834352' AND '100839352' AND create_time < '2019-05-10 11:00:00' AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352') AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100834352' AND '100839352' AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != 'OK')));
Date: 2019-05-11 09:00:00 Duration: 90ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 15:00:00 Duration: 82ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:00:00 Duration: 76ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 3ms 13ms 7ms 159 1s165ms 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 May 11 01 99 697ms 7ms 02 4 26ms 6ms 03 3 22ms 7ms 04 3 21ms 7ms 05 3 21ms 7ms 06 3 22ms 7ms 07 3 25ms 8ms 08 4 35ms 8ms 09 3 21ms 7ms 10 3 22ms 7ms 11 3 22ms 7ms 12 3 24ms 8ms 13 2 13ms 6ms 14 2 13ms 6ms 15 2 13ms 6ms 16 2 13ms 6ms 17 2 13ms 6ms 18 2 18ms 9ms 19 2 18ms 9ms 20 3 27ms 9ms 21 2 18ms 9ms 22 2 17ms 8ms 23 2 18ms 9ms 00 2 17ms 8ms [ User: symmetricds - Total duration: 850ms - Times executed: 114 ]
[ User: pharmisight - Total duration: 314ms - Times executed: 45 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s165ms - 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 = 'users' 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-05-11 07:22:57 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:30:39 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:30:39 Duration: 11ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 10ms 5ms 188 1s125ms 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 May 11 01 8 48ms 6ms 02 8 44ms 5ms 03 8 53ms 6ms 04 8 55ms 6ms 05 8 53ms 6ms 06 8 46ms 5ms 07 8 56ms 7ms 08 8 51ms 6ms 09 8 53ms 6ms 10 8 47ms 5ms 11 8 46ms 5ms 12 8 42ms 5ms 13 8 45ms 5ms 14 8 42ms 5ms 15 8 39ms 4ms 16 8 46ms 5ms 17 8 51ms 6ms 18 8 49ms 6ms 19 8 39ms 4ms 20 8 40ms 5ms 21 4 27ms 6ms 22 8 39ms 4ms 23 8 51ms 6ms 00 8 50ms 6ms [ User: symmetricds - Total duration: 1s125ms - Times executed: 188 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s125ms - 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" = '218485208', "total_memory_bytes" = '392167424', "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-05-11 06:50:28', "last_restart_time" = '2019-05-07 11:10:22', "create_time" = '2018-12-22 05:38:24', "jdbc_version" = 'mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )', "instance_id" = 'unite-db-5524b277-5064-4ebd-b790-ab9694f09319' WHERE "node_id" = '2' AND "host_name" = 'unite-db';
-
UPDATE "public"."sym_node_host" SET "ip_address" = '192.168.1.9', "os_user" = 'root', "os_name" = 'Linux', "os_arch" = 'amd64', "os_version" = '4.9.0-8-amd64', "available_processors" = '3', "free_memory_bytes" = '157026440', "total_memory_bytes" = '405798912', "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-05-11 03:05:28', "last_restart_time" = '2019-05-07 11:10:22', "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" = '337814248', "total_memory_bytes" = '1002438656', "max_memory_bytes" = '1908932608', "java_version" = '1.8.0_212', "java_vendor" = 'Oracle Corporation', "symmetric_version" = '3.9.15', "timezone_offset" = '+01:00', "heartbeat_time" = '2019-05-11 08:27:36', "last_restart_time" = '2019-05-07 11:12:08.553', "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-05-11 06:51:11 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:06:10 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 08:26:12 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 0ms 14ms 4ms 133 613ms DELETE FROM sym_data WHERE data_id BETWEEN ? AND ? AND data_id < ? AND create_time < ? AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN ? AND ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 11 01 13 59ms 4ms 02 13 57ms 4ms 03 13 57ms 4ms 04 13 58ms 4ms 05 13 57ms 4ms 06 13 58ms 4ms 07 13 57ms 4ms 08 8 28ms 3ms 09 7 23ms 3ms 10 5 56ms 11ms 11 4 37ms 9ms 12 3 17ms 5ms 13 3 15ms 5ms 14 2 11ms 5ms 16 2 4ms 2ms 17 1 2ms 2ms 18 1 1ms 1ms 19 1 1ms 1ms 20 1 1ms 1ms 21 1 1ms 1ms 22 1 1ms 1ms 23 1 2ms 2ms 00 1 1ms 1ms [ User: symmetricds - Total duration: 613ms - Times executed: 133 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 613ms - Times executed: 133 ]
-
DELETE FROM sym_data WHERE data_id BETWEEN '100830039' AND '100835039' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100830039' AND '100835039');
-
DELETE FROM sym_data WHERE data_id BETWEEN '100835040' AND '100840040' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100835040' AND '100840040');
-
DELETE FROM sym_data WHERE data_id BETWEEN '100845042' AND '100850042' AND data_id < '100852449' AND create_time < '2019-05-10 09:00:00.001' AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN '100845042' AND '100850042');
Date: 2019-05-11 09:00:00 Duration: 14ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:00:00 Duration: 13ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 4ms 1ms 828 1s190ms 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 May 11 01 41 61ms 1ms 02 47 66ms 1ms 03 55 78ms 1ms 04 54 81ms 1ms 05 49 70ms 1ms 06 33 45ms 1ms 07 44 62ms 1ms 08 42 60ms 1ms 09 41 57ms 1ms 10 27 38ms 1ms 11 26 36ms 1ms 12 29 41ms 1ms 13 27 37ms 1ms 14 27 38ms 1ms 15 38 52ms 1ms 16 28 41ms 1ms 17 25 35ms 1ms 18 27 38ms 1ms 19 29 41ms 1ms 20 29 42ms 1ms 21 27 38ms 1ms 22 28 41ms 1ms 23 27 39ms 1ms 00 28 40ms 1ms [ User: symmetricds - Total duration: 1s190ms - Times executed: 828 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s190ms - Times executed: 828 ]
-
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-05-11 03:21:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:09:02 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:52:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 4ms 0ms 1,085 1s20ms 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 May 11 01 53 49ms 0ms 02 63 57ms 0ms 03 66 61ms 0ms 04 71 66ms 0ms 05 62 63ms 1ms 06 45 42ms 0ms 07 56 54ms 0ms 08 58 53ms 0ms 09 56 51ms 0ms 10 36 33ms 0ms 11 37 34ms 0ms 12 39 36ms 0ms 13 34 31ms 0ms 14 34 31ms 0ms 15 47 42ms 0ms 16 37 35ms 0ms 17 31 29ms 0ms 18 39 36ms 0ms 19 37 34ms 0ms 20 39 37ms 0ms 21 36 33ms 0ms 22 36 34ms 0ms 23 38 35ms 0ms 00 35 32ms 0ms [ User: symmetricds - Total duration: 1s20ms - Times executed: 1085 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s20ms - Times executed: 1085 ]
-
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 16845 AS oid, 1 AS attnum UNION ALL SELECT 16845, 2 UNION ALL SELECT 16845, 3 UNION ALL SELECT 16845, 4 UNION ALL SELECT 16845, 5 UNION ALL SELECT 16845, 6 UNION ALL SELECT 16845, 12 UNION ALL SELECT 16845, 7 UNION ALL SELECT 16845, 8 UNION ALL SELECT 16845, 9 UNION ALL SELECT 16845, 10 UNION ALL SELECT 16845, 11 UNION ALL SELECT 16845, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-05-11 04:35:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 04:27:26 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 20:11:26 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 2ms 0ms 846 789ms 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 May 11 01 41 38ms 0ms 02 51 47ms 0ms 03 55 51ms 0ms 04 57 52ms 0ms 05 52 47ms 0ms 06 37 34ms 0ms 07 44 42ms 0ms 08 44 41ms 0ms 09 42 39ms 0ms 10 27 25ms 0ms 11 27 24ms 0ms 12 29 27ms 0ms 13 27 24ms 0ms 14 27 23ms 0ms 15 37 33ms 0ms 16 28 26ms 0ms 17 25 23ms 0ms 18 28 25ms 0ms 19 29 26ms 0ms 20 29 26ms 0ms 21 27 25ms 0ms 22 28 26ms 0ms 23 27 26ms 0ms 00 28 26ms 0ms [ User: symmetricds - Total duration: 789ms - Times executed: 846 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 789ms - Times executed: 846 ]
-
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-05-11 06:32:43 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 22:36:48 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:58:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 2ms 0ms 830 733ms 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 May 11 01 41 36ms 0ms 02 46 39ms 0ms 03 53 46ms 0ms 04 57 50ms 0ms 05 49 42ms 0ms 06 33 28ms 0ms 07 44 38ms 0ms 08 43 38ms 0ms 09 42 36ms 0ms 10 27 24ms 0ms 11 27 23ms 0ms 12 29 25ms 0ms 13 27 23ms 0ms 14 27 23ms 0ms 15 37 31ms 0ms 16 28 24ms 0ms 17 25 22ms 0ms 18 28 24ms 0ms 19 29 25ms 0ms 20 28 25ms 0ms 21 27 24ms 0ms 22 28 24ms 0ms 23 27 24ms 0ms 00 28 26ms 0ms [ User: symmetricds - Total duration: 733ms - Times executed: 830 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 733ms - Times executed: 830 ]
-
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-05-11 23:34:45 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:58:43 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 03:06:42 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 1ms 0ms 17,195 9s713ms 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 May 11 01 717 402ms 0ms 02 716 409ms 0ms 03 716 421ms 0ms 04 718 421ms 0ms 05 716 410ms 0ms 06 716 410ms 0ms 07 716 405ms 0ms 08 718 412ms 0ms 09 716 409ms 0ms 10 716 406ms 0ms 11 716 402ms 0ms 12 718 393ms 0ms 13 716 393ms 0ms 14 716 398ms 0ms 15 716 402ms 0ms 16 716 403ms 0ms 17 716 399ms 0ms 18 718 400ms 0ms 19 716 409ms 0ms 20 716 390ms 0ms 21 718 404ms 0ms 22 716 402ms 0ms 23 716 406ms 0ms 00 716 399ms 0ms [ User: symmetricds - Total duration: 9s713ms - Times executed: 17195 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s713ms - Times executed: 17195 ]
-
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-05-11 13:13:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 05:46:59 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 14:11:35 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 10ms 0ms 1,795 621ms UPDATE "public"."patients" SET "caloriesday" = ? WHERE "patient_id" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 11 01 1,645 585ms 0ms 02 150 36ms 0ms [ User: symmetricds - Total duration: 621ms - Times executed: 1795 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 621ms - Times executed: 1795 ]
-
UPDATE "public"."patients" SET "caloriesday" = '814' WHERE "patient_id" = '98067420';
-
UPDATE "public"."patients" SET "caloriesday" = '1354' WHERE "patient_id" = '200382082';
-
UPDATE "public"."patients" SET "caloriesday" = '1315' WHERE "patient_id" = '52791460';
Date: 2019-05-11 00:30:10 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:52:10 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:16:10 Duration: 8ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 3ms 0ms 6,443 722ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 11 01 255 29ms 0ms 02 236 26ms 0ms 03 239 27ms 0ms 04 240 27ms 0ms 05 237 26ms 0ms 06 258 32ms 0ms 07 250 29ms 0ms 08 248 29ms 0ms 09 258 28ms 0ms 10 280 34ms 0ms 11 285 30ms 0ms 12 289 30ms 0ms 13 276 29ms 0ms 14 282 31ms 0ms 15 276 30ms 0ms 16 289 31ms 0ms 17 277 31ms 0ms 18 279 29ms 0ms 19 277 29ms 0ms 20 278 29ms 0ms 21 278 30ms 0ms 22 280 30ms 0ms 23 291 32ms 0ms 00 285 32ms 0ms [ User: symmetricds - Total duration: 722ms - Times executed: 6443 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 722ms - Times executed: 6443 ]
-
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-05-11 05:25:27 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 09:15:28 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 16:23:32 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 4ms 0ms 4,422 435ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 11 01 184 17ms 0ms 02 184 21ms 0ms 03 184 24ms 0ms 04 184 20ms 0ms 05 184 17ms 0ms 06 184 17ms 0ms 07 184 18ms 0ms 08 186 17ms 0ms 09 186 17ms 0ms 10 184 17ms 0ms 11 184 18ms 0ms 12 184 16ms 0ms 13 184 22ms 0ms 14 184 21ms 0ms 15 184 18ms 0ms 16 184 15ms 0ms 17 184 16ms 0ms 18 184 16ms 0ms 19 184 17ms 0ms 20 184 16ms 0ms 21 186 18ms 0ms 22 184 15ms 0ms 23 184 16ms 0ms 00 184 15ms 0ms [ User: symmetricds - Total duration: 435ms - Times executed: 4422 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 435ms - Times executed: 4422 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '2' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = 'P') AND b.node_id = '1' AND c.queue = 'default' AND b.status IN ('RQ', 'NE', 'QY', 'SE', 'LD', 'ER', 'IG', 'RS') ORDER BY b.batch_id ASC;
Date: 2019-05-11 02:55:26 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 13:44:30 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:50:30 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 17,296 895ms 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 #14
Day Hour Count Duration Avg duration May 11 01 720 37ms 0ms 02 720 37ms 0ms 03 720 37ms 0ms 04 722 36ms 0ms 05 720 37ms 0ms 06 720 37ms 0ms 07 720 37ms 0ms 08 724 37ms 0ms 09 722 37ms 0ms 10 720 37ms 0ms 11 720 37ms 0ms 12 722 37ms 0ms 13 720 37ms 0ms 14 720 36ms 0ms 15 720 37ms 0ms 16 720 37ms 0ms 17 720 37ms 0ms 18 722 37ms 0ms 19 720 37ms 0ms 20 720 37ms 0ms 21 724 37ms 0ms 22 720 37ms 0ms 23 720 37ms 0ms 00 720 37ms 0ms [ User: symmetricds - Total duration: 895ms - Times executed: 17296 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 895ms - Times executed: 17296 ]
-
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';
-
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-05-11 14:44:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 23:28:02 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:18:05 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 2ms 0ms 25,232 1s243ms 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 #15
Day Hour Count Duration Avg duration May 11 01 1,140 58ms 0ms 02 1,060 51ms 0ms 03 1,050 50ms 0ms 04 1,052 49ms 0ms 05 1,050 51ms 0ms 06 1,048 52ms 0ms 07 1,050 51ms 0ms 08 1,054 51ms 0ms 09 1,052 50ms 0ms 10 1,050 53ms 0ms 11 1,050 50ms 0ms 12 1,050 52ms 0ms 13 1,044 52ms 0ms 14 1,044 50ms 0ms 15 1,044 51ms 0ms 16 1,044 51ms 0ms 17 1,044 51ms 0ms 18 1,046 51ms 0ms 19 1,044 53ms 0ms 20 1,046 52ms 0ms 21 1,040 51ms 0ms 22 1,042 50ms 0ms 23 1,044 51ms 0ms 00 1,044 50ms 0ms [ User: symmetricds - Total duration: 1s243ms - Times executed: 25232 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s243ms - Times executed: 25232 ]
-
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-05-11 15:06:31 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 00:08:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 11:24:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 0ms 0ms 21,360 1s32ms 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 May 11 01 890 29ms 0ms 02 890 37ms 0ms 03 890 31ms 0ms 04 890 32ms 0ms 05 890 45ms 0ms 06 890 45ms 0ms 07 890 44ms 0ms 08 890 39ms 0ms 09 890 38ms 0ms 10 890 42ms 0ms 11 890 45ms 0ms 12 890 46ms 0ms 13 890 44ms 0ms 14 890 45ms 0ms 15 890 50ms 0ms 16 890 45ms 0ms 17 890 45ms 0ms 18 890 48ms 0ms 19 890 44ms 0ms 20 890 46ms 0ms 21 890 45ms 0ms 22 890 44ms 0ms 23 890 45ms 0ms 00 890 48ms 0ms [ User: pharmisight - Total duration: 1s32ms - Times executed: 21360 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s32ms - 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 = '33016204' 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 = '33016204' 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 = '33016204' ORDER BY itembarcod0_.barcode ASC;
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 2ms 0ms 24,168 1s163ms 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 May 11 01 1,007 32ms 0ms 02 1,007 42ms 0ms 03 1,007 34ms 0ms 04 1,007 35ms 0ms 05 1,007 51ms 0ms 06 1,007 50ms 0ms 07 1,007 50ms 0ms 08 1,007 43ms 0ms 09 1,007 42ms 0ms 10 1,007 47ms 0ms 11 1,007 50ms 0ms 12 1,007 52ms 0ms 13 1,007 49ms 0ms 14 1,007 50ms 0ms 15 1,007 55ms 0ms 16 1,007 51ms 0ms 17 1,007 51ms 0ms 18 1,007 54ms 0ms 19 1,007 51ms 0ms 20 1,007 53ms 0ms 21 1,007 50ms 0ms 22 1,007 51ms 0ms 23 1,007 51ms 0ms 00 1,007 57ms 0ms [ User: pharmisight - Total duration: 1s163ms - Times executed: 24168 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s163ms - Times executed: 24168 ]
-
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 = '2939' 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 = '49' 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-05-11 23:40:00 Duration: 2ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 19:40:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:40:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 8,598 398ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 11 01 358 17ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 359 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 359 16ms 0ms 09 358 17ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 359 16ms 0ms 13 358 17ms 0ms 14 358 16ms 0ms 15 359 15ms 0ms 16 358 16ms 0ms 17 358 16ms 0ms 18 359 16ms 0ms 19 358 15ms 0ms 20 358 17ms 0ms 21 359 16ms 0ms 22 358 16ms 0ms 23 358 16ms 0ms 00 358 16ms 0ms [ User: symmetricds - Total duration: 398ms - Times executed: 8598 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 398ms - 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-05-11 19:50:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:42:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 19:43:18 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 2ms 0ms 6,443 298ms 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 #19
Day Hour Count Duration Avg duration May 11 01 255 14ms 0ms 02 236 10ms 0ms 03 239 11ms 0ms 04 240 11ms 0ms 05 237 10ms 0ms 06 258 12ms 0ms 07 250 12ms 0ms 08 248 11ms 0ms 09 258 11ms 0ms 10 280 12ms 0ms 11 285 12ms 0ms 12 289 12ms 0ms 13 276 12ms 0ms 14 282 12ms 0ms 15 276 13ms 0ms 16 289 13ms 0ms 17 277 12ms 0ms 18 279 12ms 0ms 19 277 12ms 0ms 20 278 12ms 0ms 21 278 12ms 0ms 22 280 12ms 0ms 23 291 13ms 0ms 00 285 12ms 0ms [ User: symmetricds - Total duration: 298ms - Times executed: 6443 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 298ms - Times executed: 6443 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '2' ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = '0' ORDER BY channel_id;
Date: 2019-05-11 00:02:25 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 07:17:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 06:37:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 2,796 128ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 11 01 1,432 33ms 0ms 02 208 7ms 0ms 03 60 4ms 0ms 04 60 4ms 0ms 05 60 4ms 0ms 06 56 4ms 0ms 07 60 5ms 0ms 08 60 4ms 0ms 09 60 4ms 0ms 10 60 4ms 0ms 11 60 4ms 0ms 12 56 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 3ms 0ms 16 48 3ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 52 3ms 0ms 21 32 2ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms 00 48 3ms 0ms [ User: symmetricds - Total duration: 128ms - Times executed: 2796 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 128ms - Times executed: 2796 ]
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
-
SELECT set_config('symmetric.triggers_disabled', '1', FALSE);
Date: 2019-05-11 06:51:11 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 12:31:13 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-05-11 08:56:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,177,137 Log entries
Events distribution
Key values
- 0 PANIC entries
- 10 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 10 Max number of times the same event was reported
- 11 Total events found
Rank Times reported Error 1 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count May 11 14 10 - FATAL: terminating connection due to administrator command
Date: 2019-05-11 13:59:57 Database: pharmisight Application: PostgreSQL JDBC Driver User: pharmisight Remote: 10.10.10.1 Code:
2 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count May 11 15 1 - ERROR: database system was shut down at 2019-05-11 13:59:57 BST
Date: 2019-05-11 14:00:06