pgBadger-
Global information
- Generated on Mon Jan 14 00:00:26 2019
- Log file: /var/log/postgresql/postgresql-11-main.log.1
- Parsed 3,634,510 log entries in 24s
- Log start from 2019-01-13 00:00:00 to 2019-01-13 23:59:59
-
Overview
Global Stats
- 156 Number of unique normalized queries
- 1,236,565 Number of queries
- 54s243ms Total query duration
- 2019-01-13 00:00:00 First query
- 2019-01-13 23:59:59 Last query
- 1,977 queries/s at 2019-01-13 11:00:00 Query peak
- 7 Number of events
- 3 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 46 Total number of automatic vacuums
- 71 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 2,011 Total number of sessions
- 2 sessions at 2019-01-13 10:55:52 Session peak
- 10d34m38s Total duration of sessions
- 7m10s Average duration of sessions
- 614 Average queries per session
- 26ms Average queries duration per session
- 2,011 Total number of connections
- 3 connections/s at 2019-01-13 00:31:28 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1,977 queries/s Query Peak
- 2019-01-13 11:00:00 Date
SELECT Traffic
Key values
- 1,918 queries/s Query Peak
- 2019-01-13 11:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 133 queries/s Query Peak
- 2019-01-13 00:10:19 Date
Queries duration
Key values
- 54s243ms Total query duration
Prepared queries ratio
Key values
- 1.61 Ratio of bind vs prepare
- 166.57 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 13 00 57,374 0ms 80ms 0ms 66ms 139ms 1s56ms 01 51,020 0ms 27ms 0ms 62ms 71ms 188ms 02 51,072 0ms 23ms 0ms 60ms 78ms 183ms 03 51,109 0ms 20ms 0ms 60ms 79ms 179ms 04 50,912 0ms 21ms 0ms 58ms 71ms 179ms 05 51,064 0ms 18ms 0ms 50ms 56ms 216ms 06 51,205 0ms 22ms 0ms 53ms 56ms 193ms 07 51,091 0ms 17ms 0ms 56ms 67ms 181ms 08 51,066 0ms 21ms 0ms 55ms 63ms 169ms 09 51,044 0ms 16ms 0ms 56ms 72ms 154ms 10 51,046 0ms 18ms 0ms 58ms 71ms 164ms 11 51,077 0ms 16ms 0ms 54ms 77ms 136ms 12 51,115 0ms 19ms 0ms 63ms 78ms 167ms 13 51,041 0ms 16ms 0ms 52ms 74ms 161ms 14 51,123 0ms 14ms 0ms 51ms 74ms 160ms 15 51,332 0ms 13ms 0ms 55ms 78ms 160ms 16 51,544 0ms 16ms 0ms 51ms 56ms 146ms 17 51,491 0ms 15ms 0ms 51ms 64ms 151ms 18 51,449 0ms 15ms 0ms 54ms 58ms 151ms 19 51,527 0ms 13ms 0ms 54ms 66ms 149ms 20 52,223 0ms 17ms 0ms 49ms 63ms 380ms 21 51,508 0ms 16ms 0ms 52ms 72ms 152ms 22 51,485 0ms 15ms 0ms 53ms 67ms 157ms 23 51,647 0ms 14ms 0ms 53ms 63ms 158ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 13 00 20,752 0 0ms 28ms 34ms 129ms 01 17,860 0 0ms 27ms 40ms 124ms 02 17,874 0 0ms 26ms 38ms 122ms 03 17,890 0 0ms 27ms 38ms 127ms 04 17,816 0 0ms 27ms 36ms 122ms 05 17,878 0 0ms 26ms 30ms 122ms 06 17,911 0 0ms 27ms 32ms 139ms 07 17,888 0 0ms 27ms 34ms 127ms 08 17,876 0 0ms 26ms 30ms 138ms 09 17,868 0 0ms 27ms 33ms 134ms 10 17,877 0 0ms 28ms 35ms 125ms 11 17,865 0 0ms 27ms 34ms 102ms 12 17,895 0 0ms 28ms 34ms 134ms 13 17,851 0 0ms 26ms 31ms 128ms 14 17,896 0 0ms 28ms 30ms 125ms 15 17,908 0 0ms 27ms 33ms 123ms 16 17,897 0 0ms 22ms 30ms 126ms 17 17,883 0 0ms 21ms 29ms 125ms 18 17,879 0 0ms 23ms 32ms 126ms 19 17,921 0 0ms 22ms 34ms 132ms 20 18,416 0 0ms 22ms 28ms 126ms 21 17,888 0 0ms 22ms 30ms 125ms 22 17,883 0 0ms 22ms 33ms 127ms 23 17,925 0 0ms 23ms 30ms 124ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 13 00 294 1,071 78 0 0ms 9ms 12ms 29ms 01 88 53 81 0 0ms 0ms 5ms 7ms 02 88 54 81 0 0ms 1ms 6ms 8ms 03 88 54 81 0 0ms 1ms 6ms 8ms 04 82 50 80 0 0ms 0ms 7ms 8ms 05 88 54 81 0 0ms 1ms 6ms 8ms 06 94 56 82 0 0ms 1ms 6ms 8ms 07 88 54 82 0 0ms 1ms 6ms 8ms 08 88 54 81 0 0ms 0ms 6ms 7ms 09 88 53 80 0 0ms 1ms 2ms 7ms 10 88 54 84 0 0ms 1ms 6ms 8ms 11 88 53 81 0 0ms 1ms 4ms 7ms 12 88 54 80 0 0ms 1ms 6ms 7ms 13 88 54 79 0 0ms 1ms 4ms 7ms 14 88 53 81 0 0ms 1ms 6ms 7ms 15 88 54 84 0 0ms 1ms 7ms 8ms 16 88 53 78 0 0ms 1ms 2ms 7ms 17 88 54 82 0 0ms 1ms 2ms 7ms 18 88 54 80 0 0ms 1ms 6ms 7ms 19 88 53 81 0 0ms 1ms 6ms 7ms 20 121 87 117 0 0ms 1ms 7ms 8ms 21 88 53 79 0 0ms 1ms 6ms 7ms 22 88 54 80 0 0ms 1ms 7ms 7ms 23 88 54 81 0 0ms 1ms 6ms 8ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 13 00 35,258 57,338 1.63 97.16% 01 32,438 50,984 1.57 106.23% 02 32,158 51,036 1.59 105.20% 03 32,110 51,073 1.59 104.95% 04 32,090 50,876 1.59 105.37% 05 32,353 51,028 1.58 105.85% 06 32,327 51,169 1.58 105.45% 07 32,399 51,055 1.58 105.93% 08 32,456 51,030 1.57 106.19% 09 32,177 51,008 1.59 105.32% 10 32,636 51,010 1.56 106.79% 11 32,321 51,041 1.58 105.75% 12 32,510 51,079 1.57 106.25% 13 32,163 51,005 1.59 105.29% 14 32,519 51,087 1.57 106.27% 15 31,865 51,296 1.61 103.79% 16 30,827 51,508 1.67 100.10% 17 30,613 51,455 1.68 99.51% 18 30,669 51,413 1.68 99.75% 19 30,818 51,491 1.67 100.06% 20 30,728 52,187 1.70 97.69% 21 30,827 51,472 1.67 100.17% 22 30,705 51,449 1.68 99.81% 23 30,779 51,611 1.68 99.79% Day Hour Count Average / Second Jan 13 00 97 0.03/s 01 96 0.03/s 02 93 0.03/s 03 92 0.03/s 04 95 0.03/s 05 93 0.03/s 06 97 0.03/s 07 92 0.03/s 08 96 0.03/s 09 92 0.03/s 10 95 0.03/s 11 95 0.03/s 12 93 0.03/s 13 93 0.03/s 14 95 0.03/s 15 82 0.02/s 16 63 0.02/s 17 62 0.02/s 18 65 0.02/s 19 67 0.02/s 20 61 0.02/s 21 65 0.02/s 22 65 0.02/s 23 67 0.02/s Day Hour Count Average Duration Jan 13 00 97 6m34s 01 96 6m16s 02 93 6m19s 03 92 6m32s 04 95 6m30s 05 93 6m21s 06 97 6m14s 07 92 6m21s 08 96 6m18s 09 92 6m24s 10 95 6m10s 11 95 6m31s 12 93 6m31s 13 93 6m22s 14 95 6m11s 15 82 7m16s 16 63 9m26s 17 62 9m33s 18 65 9m34s 19 67 8m42s 20 61 9m50s 21 65 9m36s 22 65 9m29s 23 67 8m39s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2019-01-13 00:31:28 Date
Connections per database
Key values
- pharmisight Main Database
- 2,011 connections Total
Connections per user
Key values
- symmetricds Main User
- 2,011 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2019-01-13 10:55:52 Date
Histogram of session times
Key values
- 1,337 60000-600000ms duration
Sessions per database
Key values
- pharmisight Main Database
- 2,011 sessions Total
Sessions per user
Key values
- symmetricds Main User
- 2,011 sessions Total
Sessions per host
Key values
- 10.10.10.1 Main Host
- 2,011 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 460 buffers Checkpoint Peak
- 2019-01-13 04:01:59 Date
- 46.137 seconds Highest write time
- 0.011 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2019-01-13 00:01:27 Date
Checkpoints distance
Key values
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 13 00 1,522 152.501s 0.011s 152.568s 01 709 71.032s 0.01s 71.103s 02 582 58.387s 0.012s 58.453s 03 596 59.706s 0.013s 59.769s 04 731 73.326s 0.012s 73.393s 05 602 60.411s 0.013s 60.482s 06 466 46.759s 0.011s 46.823s 07 586 58.686s 0.013s 58.75s 08 402 40.334s 0.011s 40.394s 09 354 35.525s 0.011s 35.585s 10 599 60.107s 0.009s 60.163s 11 343 34.414s 0.009s 34.469s 12 419 42.036s 0.009s 42.09s 13 590 59.203s 0.011s 59.272s 14 420 42.128s 0.013s 42.186s 15 372 37.317s 0.01s 37.374s 16 497 49.87s 0.009s 49.924s 17 408 40.938s 0.01s 40.999s 18 395 39.638s 0.017s 39.701s 19 495 49.666s 0.022s 49.797s 20 497 49.878s 0.015s 49.95s 21 438 43.941s 0.012s 43.995s 22 513 51.477s 0.011s 51.54s 23 340 34.115s 0.009s 34.167s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 13 00 0 0 1 295 0.002s 0s 01 0 0 0 239 0.002s 0s 02 0 0 0 227 0.002s 0.001s 03 0 0 0 224 0.003s 0.001s 04 0 0 1 222 0.002s 0s 05 0 0 0 228 0.002s 0.001s 06 0 0 0 212 0.002s 0.001s 07 0 0 0 226 0.002s 0.001s 08 0 0 0 212 0.002s 0s 09 0 0 0 207 0.002s 0s 10 0 0 0 219 0.002s 0s 11 0 0 0 207 0.002s 0s 12 0 0 0 216 0.002s 0s 13 0 0 0 217 0.002s 0.001s 14 0 0 0 210 0.002s 0s 15 0 0 1 198 0.002s 0s 16 0 0 0 205 0.002s 0s 17 0 0 0 203 0.002s 0.001s 18 0 0 0 210 0.008s 0s 19 0 0 0 210 0.011s 0.001s 20 0 0 0 247 0.002s 0.001s 21 0 0 0 194 0.003s 0s 22 0 0 0 218 0.003s 0s 23 0 0 0 201 0.002s 0s Day Hour Count Avg time (sec) Jan 13 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jan 13 00 782.55 kB 1,058.73 kB 01 235.80 kB 994.50 kB 02 210.67 kB 570.56 kB 03 203.33 kB 469.56 kB 04 194.40 kB 727.20 kB 05 187.00 kB 453.00 kB 06 137.80 kB 285.60 kB 07 194.33 kB 609.00 kB 08 168.56 kB 353.44 kB 09 119.00 kB 278.00 kB 10 233.11 kB 485.44 kB 11 124.12 kB 284.50 kB 12 173.50 kB 274.62 kB 13 222.00 kB 480.00 kB 14 144.25 kB 300.25 kB 15 158.88 kB 280.38 kB 16 193.78 kB 430.33 kB 17 143.67 kB 326.22 kB 18 175.12 kB 302.62 kB 19 193.67 kB 457.78 kB 20 166.50 kB 411.90 kB 21 188.75 kB 480.38 kB 22 208.67 kB 335.11 kB 23 132.88 kB 287.75 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.sym_outgoing_batch (15) Main table analyzed (database pharmisight)
- 71 analyzes Total
Table Number of analyzes pharmisight.public.sym_outgoing_batch 15 pharmisight.public.sym_data_event 14 pharmisight.public.sym_incoming_batch 12 pharmisight.public.sym_data_gap 11 pharmisight.public.sym_data 11 pharmisight.public.sym_node_host 5 pharmisight.public.item_codes 2 pharmisight.public.sym_sequence 1 Total 71 Vacuums per table
Key values
- public.sym_data_event (9) Main table vacuumed on database pharmisight
- 46 vacuums Total
Table Number of vacuums Index scans pharmisight.public.sym_data_event 9 9 pharmisight.public.sym_outgoing_batch 8 8 pharmisight.public.sym_data 8 8 pharmisight.public.sym_node_host 6 0 pharmisight.public.sym_data_gap 6 6 pharmisight.public.sym_incoming_batch 5 5 pharmisight.pg_catalog.pg_statistic 2 2 pharmisight.public.sym_sequence 1 0 pharmisight.public.flow_report_summary_delays 1 1 Total 46 39 Tuples removed per table
Key values
- public.sym_data_event (5009) Main table with removed tuples on database pharmisight
- 10102 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data_event 9 9 5009 852 pharmisight.public.sym_data 8 8 1748 1863 pharmisight.public.sym_outgoing_batch 8 8 1044 182 pharmisight.public.sym_incoming_batch 5 5 954 0 pharmisight.pg_catalog.pg_statistic 2 2 628 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.flow_report_summary_delays 1 1 50 0 Total 46 39 10,102 2,897 Pages removed per table
Key values
- public.sym_data (1863) Main table with removed pages on database pharmisight
- 2897 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed pharmisight.public.sym_data 8 8 1748 1863 pharmisight.public.sym_data_event 9 9 5009 852 pharmisight.public.sym_outgoing_batch 8 8 1044 182 pharmisight.public.sym_sequence 1 0 51 0 pharmisight.public.sym_node_host 6 0 312 0 pharmisight.public.flow_report_summary_delays 1 1 50 0 pharmisight.pg_catalog.pg_statistic 2 2 628 0 pharmisight.public.sym_data_gap 6 6 306 0 pharmisight.public.sym_incoming_batch 5 5 954 0 Total 46 39 10,102 2,897 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 13 00 4 7 01 5 4 02 2 3 03 2 5 04 4 3 05 3 5 06 0 3 07 4 2 08 1 2 09 1 1 10 2 4 11 0 1 12 1 3 13 2 4 14 2 2 15 0 1 16 1 5 17 2 1 18 1 3 19 1 2 20 3 3 21 2 2 22 3 4 23 0 1 - 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
- 432,597 Total read queries
- 309,275 Total write queries
Queries by database
Key values
- pharmisight Main database
- 1,236,565 Requests
- 54s243ms (pharmisight)
- Main time consuming database
Queries by user
Key values
- symmetricds Main user
- 1,189,055 Requests
User Request type Count Duration pharmisight Total 95,640 5s869ms DELETE 33 3ms INSERT 33 2ms OTHERS 1,875 70ms SELECT 93,194 5s772ms TCL 472 16ms UPDATE 33 4ms symmetricds Total 1,189,055 50s210ms DELETE 2,012 561ms INSERT 2,406 744ms OTHERS 513,253 7s903ms SELECT 354,434 32s893ms TCL 314,593 5s706ms UPDATE 2,357 2s400ms tony Total 900 264ms SELECT 900 264ms Duration by user
Key values
- 50s210ms (symmetricds) Main time consuming user
User Request type Count Duration pharmisight Total 95,640 5s869ms DELETE 33 3ms INSERT 33 2ms OTHERS 1,875 70ms SELECT 93,194 5s772ms TCL 472 16ms UPDATE 33 4ms symmetricds Total 1,189,055 50s210ms DELETE 2,012 561ms INSERT 2,406 744ms OTHERS 513,253 7s903ms SELECT 354,434 32s893ms TCL 314,593 5s706ms UPDATE 2,357 2s400ms tony Total 900 264ms SELECT 900 264ms Queries by host
Key values
- 10.10.10.1 Main host
- 1,284,695 Requests
- 56s79ms (10.10.10.1)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 1,233,978 Requests
- 53s923ms (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2019-01-13 18:17:51 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,232,368 0-1ms duration
Slowest individual queries
Rank Duration Query 1 80ms UPDATE "public"."patients" SET "caloriesday" = $1 WHERE "patient_id" = $2;[ Date: 2019-01-13 00:33:19 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 27ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 00:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 27ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 01:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 23ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 02:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 22ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 06:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 21ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 04:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 21ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 08:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 20ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 03:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 19ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 12:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 18ms DELETE FROM sym_data WHERE data_id BETWEEN $1 AND $2 AND create_time < $3 AND data_id IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $4 AND $5) AND data_id NOT IN ( SELECT e.data_id FROM sym_data_event e WHERE e.data_id BETWEEN $6 AND $7 AND (e.data_id IS NULL OR e.batch_id IN ( SELECT batch_id FROM sym_outgoing_batch WHERE status != $8)));[ Date: 2019-01-13 05:00:00 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 18ms UPDATE "public"."patients" SET "caloriesday" = $1 WHERE "patient_id" = $2;[ Date: 2019-01-13 00:07:19 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 18ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 06:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 18ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 10:00:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 18ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 08:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 18ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 12:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 17ms COMMIT;[ Date: 2019-01-13 07:10:40 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 17ms SELECT this_.ORDER_ROUND_ID AS ORDER_RO1_28_0_, this_.routeNumber AS routeNum2_28_0_, this_.uploadedByUserId AS uploaded3_28_0_, this_.uploadedByUserName AS uploaded4_28_0_, this_.updatedBy AS updatedB5_28_0_, this_.updatedByUserName AS updatedB6_28_0_, this_.orderRoundNote AS orderRou7_28_0_, this_.firstCheckOut AS firstChe8_28_0_, this_.allOrdersScannedOK AS allOrder9_28_0_, this_.status AS status10_28_0_, this_.reopenedTimes AS reopene11_28_0_, this_.lastReopenById AS lastReo12_28_0_, this_.lastDoneCheckIn AS lastDon13_28_0_, this_.lastDoneById AS lastDon14_28_0_, this_.lastDoneByUserName AS lastDon15_28_0_, this_.missingLabels AS missing16_28_0_, this_.roundDeliveryDate AS roundDe17_28_0_, this_.trolley AS trolley18_28_0_, this_.stack AS stack19_28_0_, this_.picktime AS picktim20_28_0_, this_.uploadUpdated AS uploadU21_28_0_, this_.patientAlert AS patient22_28_0_, this_.mismatches AS mismatc23_28_0_, this_.rxStatus AS rxStatu24_28_0_, this_.distributionPoint AS distrib25_28_0_, this_.audited AS audited26_28_0_, this_.auditedBy AS audited27_28_0_, this_.auditStatus AS auditSt28_28_0_, this_.uploadFinished AS uploadF29_28_0_, this_.lastRxCompleted AS lastRxC30_28_0_, this_.lastRxCompletedBy AS lastRxC31_28_0_, this_.orderRoundNoteReadBy AS orderRo32_28_0_, this_.routeOrderLinesQty AS routeOr33_28_0_, this_.dlxPickedLinesQty AS dlxPick34_28_0_, this_.flowReport AS flowRep35_28_0_, this_.CREATED AS CREATED36_28_0_, this_.createdBy AS created37_28_0_, this_.UPDATED AS UPDATED38_28_0_, this_.note AS note39_28_0_ FROM ORDER_ROUNDS this_ WHERE this_.CREATED BETWEEN $1 AND $2 AND this_.status <> $3;[ Date: 2019-01-13 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 16ms COMMIT;[ Date: 2019-01-13 21:25:47 - Database: pharmisight - User: symmetricds - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 16ms SELECT this_.FLOW_REPORT_ID AS FLOW_REP1_9_0_, this_.routeNumber AS routeNum2_9_0_, this_.roundDeliveryDate AS roundDel3_9_0_, this_.distributionPoint AS distribu4_9_0_, this_.fullyPicked AS fullyPic5_9_0_, this_.outbaseRoutesCorrectlyGrouped AS outbaseR6_9_0_, this_.causeOfDelay AS causeOfD7_9_0_, this_.pharmacy100CheckTime AS pharmacy8_9_0_, this_.linesHeldBack AS linesHel9_9_0_, this_.packTime100 AS packTim10_9_0_, this_.replenish AS repleni11_9_0_, this_.comment AS comment12_9_0_, this_.pickDateTime AS pickDat13_9_0_, this_.failedTargetPickTime AS failedT14_9_0_, this_.actualPaperworkCompleteTime AS actualP15_9_0_, this_.changedPickDateTime AS changed16_9_0_, this_.manuallyChangedPickTime AS manuall17_9_0_, this_.CREATED AS CREATED18_9_0_, this_.UPDATED AS UPDATED19_9_0_, this_.note AS note20_9_0_ FROM FLOW_REPORTS this_ WHERE this_.roundDeliveryDate = $1 ORDER BY this_.distributionPoint ASC, this_.routeNumber ASC;[ Date: 2019-01-13 20:00:30 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 16ms SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;[ Date: 2019-01-13 11:20:00 - Database: pharmisight - User: pharmisight - Remote: 10.10.10.1 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 14s324ms 25,780 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 13 00 1,075 600ms 0ms 01 1,074 601ms 0ms 02 1,074 611ms 0ms 03 1,074 607ms 0ms 04 1,074 600ms 0ms 05 1,074 603ms 0ms 06 1,074 607ms 0ms 07 1,074 610ms 0ms 08 1,074 595ms 0ms 09 1,074 594ms 0ms 10 1,074 602ms 0ms 11 1,074 603ms 0ms 12 1,074 599ms 0ms 13 1,074 593ms 0ms 14 1,074 608ms 0ms 15 1,074 599ms 0ms 16 1,074 589ms 0ms 17 1,074 579ms 0ms 18 1,074 585ms 0ms 19 1,074 581ms 0ms 20 1,074 584ms 0ms 21 1,074 575ms 0ms 22 1,074 593ms 0ms 23 1,077 593ms 0ms [ User: symmetricds - Total duration: 14s324ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s324ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-13 05:08:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:48:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:41:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 7s287ms 473,005 0ms 6ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 13 00 20,157 305ms 0ms 01 19,556 299ms 0ms 02 19,581 305ms 0ms 03 19,594 303ms 0ms 04 19,532 304ms 0ms 05 19,575 297ms 0ms 06 19,622 301ms 0ms 07 19,585 301ms 0ms 08 19,573 298ms 0ms 09 19,570 301ms 0ms 10 19,560 304ms 0ms 11 19,588 303ms 0ms 12 19,594 299ms 0ms 13 19,577 301ms 0ms 14 19,597 300ms 0ms 15 19,729 306ms 0ms 16 19,889 309ms 0ms 17 19,864 314ms 0ms 18 19,838 303ms 0ms 19 19,858 306ms 0ms 20 19,908 302ms 0ms 21 19,872 305ms 0ms 22 19,856 305ms 0ms 23 19,930 305ms 0ms [ User: symmetricds - Total duration: 7s261ms - Times executed: 472403 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 602 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s287ms - Times executed: 473005 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-01-13 17:53:44 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 04:06:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:13:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 4s580ms 151,306 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 13 00 7,047 482ms 0ms 01 6,227 165ms 0ms 02 6,236 169ms 0ms 03 6,241 178ms 0ms 04 6,213 164ms 0ms 05 6,231 190ms 0ms 06 6,257 177ms 0ms 07 6,236 204ms 0ms 08 6,233 180ms 0ms 09 6,232 169ms 0ms 10 6,229 180ms 0ms 11 6,238 184ms 0ms 12 6,240 190ms 0ms 13 6,237 179ms 0ms 14 6,241 176ms 0ms 15 6,283 174ms 0ms 16 6,340 178ms 0ms 17 6,329 174ms 0ms 18 6,323 182ms 0ms 19 6,328 172ms 0ms 20 6,356 175ms 0ms 21 6,333 184ms 0ms 22 6,329 170ms 0ms 23 6,347 173ms 0ms [ User: symmetricds - Total duration: 4s564ms - Times executed: 151076 ]
[ User: pharmisight - Total duration: 15ms - Times executed: 230 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s580ms - Times executed: 151306 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-01-13 07:10:40 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:25:47 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 00:22:19 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 2s420ms 47,760 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 00 1,990 96ms 0ms 01 1,990 99ms 0ms 02 1,990 98ms 0ms 03 1,990 100ms 0ms 04 1,990 100ms 0ms 05 1,990 100ms 0ms 06 1,990 106ms 0ms 07 1,990 99ms 0ms 08 1,990 105ms 0ms 09 1,990 103ms 0ms 10 1,990 101ms 0ms 11 1,990 84ms 0ms 12 1,990 103ms 0ms 13 1,990 100ms 0ms 14 1,990 102ms 0ms 15 1,990 99ms 0ms 16 1,990 100ms 0ms 17 1,990 101ms 0ms 18 1,990 103ms 0ms 19 1,990 103ms 0ms 20 1,990 101ms 0ms 21 1,990 99ms 0ms 22 1,990 105ms 0ms 23 1,990 101ms 0ms [ User: pharmisight - Total duration: 2s420ms - Times executed: 47760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s420ms - Times executed: 47760 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-13 05:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 04:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 08:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 1s973ms 42,336 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 13 00 1,764 78ms 0ms 01 1,764 81ms 0ms 02 1,764 81ms 0ms 03 1,764 83ms 0ms 04 1,764 81ms 0ms 05 1,764 81ms 0ms 06 1,764 86ms 0ms 07 1,764 81ms 0ms 08 1,764 86ms 0ms 09 1,764 84ms 0ms 10 1,764 82ms 0ms 11 1,764 69ms 0ms 12 1,764 85ms 0ms 13 1,764 81ms 0ms 14 1,764 83ms 0ms 15 1,764 80ms 0ms 16 1,764 81ms 0ms 17 1,764 83ms 0ms 18 1,764 83ms 0ms 19 1,764 84ms 0ms 20 1,764 82ms 0ms 21 1,764 81ms 0ms 22 1,764 85ms 0ms 23 1,764 82ms 0ms [ User: pharmisight - Total duration: 1s973ms - Times executed: 42336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s973ms - Times executed: 42336 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-13 03:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 11:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 1s859ms 171,217 0ms 10ms 0ms SELECT ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 13 00 8,313 85ms 0ms 01 7,037 75ms 0ms 02 7,047 76ms 0ms 03 7,052 78ms 0ms 04 7,024 75ms 0ms 05 7,048 76ms 0ms 06 7,066 81ms 0ms 07 7,049 77ms 0ms 08 7,043 77ms 0ms 09 7,044 77ms 0ms 10 7,041 75ms 0ms 11 7,050 87ms 0ms 12 7,050 74ms 0ms 13 7,041 74ms 0ms 14 7,052 75ms 0ms 15 7,101 74ms 0ms 16 7,146 75ms 0ms 17 7,144 76ms 0ms 18 7,132 75ms 0ms 19 7,135 77ms 0ms 20 7,161 75ms 0ms 21 7,141 83ms 0ms 22 7,135 75ms 0ms 23 7,165 75ms 0ms [ User: symmetricds - Total duration: 1s859ms - Times executed: 171217 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s859ms - Times executed: 171217 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-01-13 11:05:41 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 06:36:40 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 1s547ms 1,066 0ms 2ms 1ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 13 00 54 76ms 1ms 01 52 74ms 1ms 02 51 73ms 1ms 03 54 78ms 1ms 04 51 72ms 1ms 05 54 77ms 1ms 06 52 74ms 1ms 07 54 76ms 1ms 08 56 85ms 1ms 09 54 80ms 1ms 10 57 85ms 1ms 11 52 75ms 1ms 12 54 77ms 1ms 13 54 78ms 1ms 14 58 83ms 1ms 15 45 67ms 1ms 16 27 39ms 1ms 17 25 36ms 1ms 18 28 39ms 1ms 19 27 38ms 1ms 20 26 37ms 1ms 21 28 39ms 1ms 22 27 39ms 1ms 23 26 38ms 1ms [ User: symmetricds - Total duration: 1s547ms - Times executed: 1066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s547ms - Times executed: 1066 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 12:11:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 08:38:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:45:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 1s441ms 1,368 0ms 5ms 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 ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 13 00 70 72ms 1ms 01 68 77ms 1ms 02 67 74ms 1ms 03 68 73ms 1ms 04 67 71ms 1ms 05 65 66ms 1ms 06 70 77ms 1ms 07 68 73ms 1ms 08 69 72ms 1ms 09 71 69ms 0ms 10 69 75ms 1ms 11 69 72ms 1ms 12 69 74ms 1ms 13 69 72ms 1ms 14 70 73ms 1ms 15 54 56ms 1ms 16 36 37ms 1ms 17 33 33ms 1ms 18 39 38ms 0ms 19 35 35ms 1ms 20 33 32ms 0ms 21 36 36ms 1ms 22 37 37ms 1ms 23 36 37ms 1ms [ User: symmetricds - Total duration: 1s441ms - Times executed: 1368 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s441ms - Times executed: 1368 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 07:45:32 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:23:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 14:19:42 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 1s256ms 25,875 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 13 00 1,078 52ms 0ms 01 1,078 51ms 0ms 02 1,078 52ms 0ms 03 1,078 52ms 0ms 04 1,078 52ms 0ms 05 1,078 52ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 52ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 52ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,078 52ms 0ms 18 1,078 53ms 0ms 19 1,078 52ms 0ms 20 1,078 52ms 0ms 21 1,078 51ms 0ms 22 1,078 52ms 0ms 23 1,081 52ms 0ms [ User: symmetricds - Total duration: 1s256ms - Times executed: 25875 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s256ms - Times executed: 25875 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-13 00:24:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:08:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 12:21:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 1s194ms 25,098 0ms 5ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 13 00 1,108 51ms 0ms 01 1,040 48ms 0ms 02 1,044 50ms 0ms 03 1,044 51ms 0ms 04 1,040 48ms 0ms 05 1,040 47ms 0ms 06 1,044 49ms 0ms 07 1,044 49ms 0ms 08 1,040 48ms 0ms 09 1,040 49ms 0ms 10 1,040 50ms 0ms 11 1,044 49ms 0ms 12 1,044 53ms 0ms 13 1,044 51ms 0ms 14 1,044 48ms 0ms 15 1,044 49ms 0ms 16 1,044 50ms 0ms 17 1,044 49ms 0ms 18 1,044 47ms 0ms 19 1,044 50ms 0ms 20 1,044 48ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s194ms - Times executed: 25098 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s194ms - Times executed: 25098 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-13 12:53:42 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:55:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:44:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 1s126ms 192 0ms 7ms 5ms UPDATE "public"."sym_node_host" SET "ip_address" = ?, "os_user" = ?, "os_name" = ?, "os_arch" = ?, "os_version" = ?, "available_processors" = ?, "free_memory_bytes" = ?, "total_memory_bytes" = ?, "max_memory_bytes" = ?, "java_version" = ?, "java_vendor" = ?, "symmetric_version" = ?, "timezone_offset" = ?, "heartbeat_time" = ?, "last_restart_time" = ?, "create_time" = ?, "jdbc_version" = ?, "instance_id" = ? WHERE "node_id" = ? AND "host_name" = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 13 00 8 42ms 5ms 01 8 45ms 5ms 02 8 52ms 6ms 03 8 47ms 5ms 04 7 46ms 6ms 05 8 45ms 5ms 06 9 49ms 5ms 07 8 52ms 6ms 08 8 49ms 6ms 09 8 41ms 5ms 10 8 49ms 6ms 11 8 46ms 5ms 12 8 50ms 6ms 13 8 46ms 5ms 14 8 45ms 5ms 15 8 52ms 6ms 16 8 39ms 4ms 17 8 46ms 5ms 18 8 45ms 5ms 19 8 52ms 6ms 20 8 40ms 5ms 21 8 41ms 5ms 22 8 48ms 6ms 23 8 48ms 6ms [ User: symmetricds - Total duration: 1s126ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s126ms - Times executed: 192 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
Date: 2019-01-13 09:07:23 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:59:30 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:07:29 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 1s27ms 1,078 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 13 00 54 52ms 0ms 01 56 54ms 0ms 02 53 50ms 0ms 03 54 52ms 0ms 04 52 50ms 0ms 05 55 53ms 0ms 06 56 54ms 0ms 07 55 51ms 0ms 08 56 52ms 0ms 09 55 51ms 0ms 10 57 55ms 0ms 11 53 50ms 0ms 12 56 53ms 0ms 13 53 48ms 0ms 14 56 54ms 0ms 15 43 41ms 0ms 16 27 25ms 0ms 17 25 23ms 0ms 18 28 26ms 0ms 19 27 25ms 0ms 20 26 23ms 0ms 21 28 26ms 0ms 22 27 25ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 1s27ms - Times executed: 1078 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s27ms - Times executed: 1078 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 15:19:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:03:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:59:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 949ms 1,066 0ms 1ms 0ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 13 00 54 48ms 0ms 01 56 49ms 0ms 02 53 48ms 0ms 03 54 48ms 0ms 04 51 45ms 0ms 05 55 48ms 0ms 06 54 48ms 0ms 07 54 47ms 0ms 08 54 47ms 0ms 09 53 46ms 0ms 10 57 51ms 0ms 11 52 46ms 0ms 12 55 48ms 0ms 13 51 43ms 0ms 14 56 50ms 0ms 15 43 38ms 0ms 16 27 24ms 0ms 17 25 22ms 0ms 18 28 25ms 0ms 19 27 23ms 0ms 20 26 22ms 0ms 21 28 24ms 0ms 22 27 24ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 949ms - Times executed: 1066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 1066 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 07:17:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:11:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:11:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 921ms 151,307 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 13 00 7,047 42ms 0ms 01 6,227 37ms 0ms 02 6,236 38ms 0ms 03 6,241 38ms 0ms 04 6,213 37ms 0ms 05 6,232 37ms 0ms 06 6,256 38ms 0ms 07 6,236 37ms 0ms 08 6,233 37ms 0ms 09 6,232 37ms 0ms 10 6,229 37ms 0ms 11 6,238 38ms 0ms 12 6,240 37ms 0ms 13 6,237 38ms 0ms 14 6,241 38ms 0ms 15 6,283 38ms 0ms 16 6,340 38ms 0ms 17 6,329 39ms 0ms 18 6,323 39ms 0ms 19 6,328 39ms 0ms 20 6,356 38ms 0ms 21 6,333 38ms 0ms 22 6,329 39ms 0ms 23 6,348 38ms 0ms [ User: symmetricds - Total duration: 919ms - Times executed: 151077 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 230 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 921ms - Times executed: 151307 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-01-13 19:56:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:55:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:35:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 728ms 112 4ms 11ms 6ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 13 00 66 434ms 6ms 01 2 13ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 13ms 6ms 05 2 8ms 4ms 06 2 8ms 4ms 07 2 13ms 6ms 08 2 9ms 4ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 16ms 8ms 14 2 13ms 6ms 15 2 17ms 8ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 728ms - Times executed: 112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 728ms - Times executed: 112 ]
-
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 = 'media_criptors' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-01-13 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 15:00:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 710ms 48 12ms 21ms 14ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 13 00 2 28ms 14ms 01 2 26ms 13ms 02 2 27ms 13ms 03 2 26ms 13ms 04 2 26ms 13ms 05 2 26ms 13ms 06 2 34ms 17ms 07 2 27ms 13ms 08 2 39ms 19ms 09 2 30ms 15ms 10 2 32ms 16ms 11 2 30ms 15ms 12 2 38ms 19ms 13 2 30ms 15ms 14 2 27ms 13ms 15 2 27ms 13ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 27ms 13ms 19 2 26ms 13ms 20 2 29ms 14ms 21 2 30ms 15ms 22 2 28ms 14ms 23 2 28ms 14ms [ User: pharmisight - Total duration: 710ms - Times executed: 48 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 48 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-01-13 08:00:00 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 12:00:00 Duration: 19ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 06:20:00 Duration: 18ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 675ms 6,095 0ms 1ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 13 00 240 27ms 0ms 01 236 26ms 0ms 02 239 27ms 0ms 03 240 27ms 0ms 04 236 26ms 0ms 05 239 27ms 0ms 06 240 27ms 0ms 07 237 27ms 0ms 08 239 27ms 0ms 09 240 26ms 0ms 10 237 26ms 0ms 11 239 26ms 0ms 12 240 25ms 0ms 13 237 26ms 0ms 14 239 26ms 0ms 15 260 27ms 0ms 16 286 31ms 0ms 17 280 29ms 0ms 18 277 28ms 0ms 19 280 31ms 0ms 20 287 29ms 0ms 21 282 31ms 0ms 22 280 29ms 0ms 23 285 31ms 0ms [ User: symmetricds - Total duration: 675ms - Times executed: 6095 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 6095 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-13 19:22:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:58:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 17:26:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 504ms 122 2ms 9ms 4ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 13 00 4 15ms 3ms 01 6 25ms 4ms 02 6 24ms 4ms 03 5 20ms 4ms 04 7 28ms 4ms 05 4 13ms 3ms 06 5 20ms 4ms 07 6 24ms 4ms 08 5 19ms 3ms 09 4 18ms 4ms 10 6 30ms 5ms 11 5 20ms 4ms 12 5 19ms 3ms 13 5 19ms 3ms 14 4 15ms 3ms 15 5 20ms 4ms 16 4 17ms 4ms 17 5 18ms 3ms 18 6 28ms 4ms 19 5 20ms 4ms 20 5 23ms 4ms 21 4 16ms 4ms 22 6 24ms 4ms 23 5 20ms 4ms [ User: symmetricds - Total duration: 504ms - Times executed: 122 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 504ms - Times executed: 122 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 10:40:41 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:10:44 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 20:40:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 496ms 96 0ms 7ms 5ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 13 00 4 16ms 4ms 01 4 21ms 5ms 02 4 20ms 5ms 03 4 21ms 5ms 04 4 27ms 6ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 21ms 5ms 08 4 26ms 6ms 09 4 14ms 3ms 10 4 18ms 4ms 11 4 20ms 5ms 12 4 20ms 5ms 13 4 9ms 2ms 14 4 23ms 5ms 15 4 26ms 6ms 16 4 18ms 4ms 17 4 9ms 2ms 18 4 24ms 6ms 19 4 15ms 3ms 20 4 28ms 7ms 21 4 20ms 5ms 22 4 20ms 5ms 23 4 21ms 5ms [ User: symmetricds - Total duration: 496ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 496ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-01-13 21:40:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:55:13 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:25:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 451ms 17,266 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 13 00 720 18ms 0ms 01 720 18ms 0ms 02 718 19ms 0ms 03 720 18ms 0ms 04 720 18ms 0ms 05 718 18ms 0ms 06 720 19ms 0ms 07 720 18ms 0ms 08 720 18ms 0ms 09 718 18ms 0ms 10 720 18ms 0ms 11 720 18ms 0ms 12 718 18ms 0ms 13 720 18ms 0ms 14 720 18ms 0ms 15 718 19ms 0ms 16 720 19ms 0ms 17 720 19ms 0ms 18 720 18ms 0ms 19 718 19ms 0ms 20 720 19ms 0ms 21 720 19ms 0ms 22 720 18ms 0ms 23 718 19ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 17266 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2019-01-13 10:51:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:08:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 17:02:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 473,005 7s287ms 0ms 6ms 0ms SHOW TRANSACTION ISOLATION level;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 13 00 20,157 305ms 0ms 01 19,556 299ms 0ms 02 19,581 305ms 0ms 03 19,594 303ms 0ms 04 19,532 304ms 0ms 05 19,575 297ms 0ms 06 19,622 301ms 0ms 07 19,585 301ms 0ms 08 19,573 298ms 0ms 09 19,570 301ms 0ms 10 19,560 304ms 0ms 11 19,588 303ms 0ms 12 19,594 299ms 0ms 13 19,577 301ms 0ms 14 19,597 300ms 0ms 15 19,729 306ms 0ms 16 19,889 309ms 0ms 17 19,864 314ms 0ms 18 19,838 303ms 0ms 19 19,858 306ms 0ms 20 19,908 302ms 0ms 21 19,872 305ms 0ms 22 19,856 305ms 0ms 23 19,930 305ms 0ms [ User: symmetricds - Total duration: 7s261ms - Times executed: 472403 ]
[ User: pharmisight - Total duration: 25ms - Times executed: 602 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7s287ms - Times executed: 473005 ]
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
-
SHOW TRANSACTION ISOLATION LEVEL;
Date: 2019-01-13 17:53:44 Duration: 6ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 04:06:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:13:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 171,217 1s859ms 0ms 10ms 0ms SELECT ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 13 00 8,313 85ms 0ms 01 7,037 75ms 0ms 02 7,047 76ms 0ms 03 7,052 78ms 0ms 04 7,024 75ms 0ms 05 7,048 76ms 0ms 06 7,066 81ms 0ms 07 7,049 77ms 0ms 08 7,043 77ms 0ms 09 7,044 77ms 0ms 10 7,041 75ms 0ms 11 7,050 87ms 0ms 12 7,050 74ms 0ms 13 7,041 74ms 0ms 14 7,052 75ms 0ms 15 7,101 74ms 0ms 16 7,146 75ms 0ms 17 7,144 76ms 0ms 18 7,132 75ms 0ms 19 7,135 77ms 0ms 20 7,161 75ms 0ms 21 7,141 83ms 0ms 22 7,135 75ms 0ms 23 7,165 75ms 0ms [ User: symmetricds - Total duration: 1s859ms - Times executed: 171217 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s859ms - Times executed: 171217 ]
-
SELECT 1;
-
SELECT 1;
-
SELECT 1;
Date: 2019-01-13 11:05:41 Duration: 10ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:00:00 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 06:36:40 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 151,307 921ms 0ms 0ms 0ms BEGIN;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 13 00 7,047 42ms 0ms 01 6,227 37ms 0ms 02 6,236 38ms 0ms 03 6,241 38ms 0ms 04 6,213 37ms 0ms 05 6,232 37ms 0ms 06 6,256 38ms 0ms 07 6,236 37ms 0ms 08 6,233 37ms 0ms 09 6,232 37ms 0ms 10 6,229 37ms 0ms 11 6,238 38ms 0ms 12 6,240 37ms 0ms 13 6,237 38ms 0ms 14 6,241 38ms 0ms 15 6,283 38ms 0ms 16 6,340 38ms 0ms 17 6,329 39ms 0ms 18 6,323 39ms 0ms 19 6,328 39ms 0ms 20 6,356 38ms 0ms 21 6,333 38ms 0ms 22 6,329 39ms 0ms 23 6,348 38ms 0ms [ User: symmetricds - Total duration: 919ms - Times executed: 151077 ]
[ User: pharmisight - Total duration: 1ms - Times executed: 230 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 921ms - Times executed: 151307 ]
-
BEGIN;
-
BEGIN;
-
BEGIN;
Date: 2019-01-13 19:56:33 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:55:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:35:07 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 151,306 4s580ms 0ms 17ms 0ms COMMIT;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 00 7,047 482ms 0ms 01 6,227 165ms 0ms 02 6,236 169ms 0ms 03 6,241 178ms 0ms 04 6,213 164ms 0ms 05 6,231 190ms 0ms 06 6,257 177ms 0ms 07 6,236 204ms 0ms 08 6,233 180ms 0ms 09 6,232 169ms 0ms 10 6,229 180ms 0ms 11 6,238 184ms 0ms 12 6,240 190ms 0ms 13 6,237 179ms 0ms 14 6,241 176ms 0ms 15 6,283 174ms 0ms 16 6,340 178ms 0ms 17 6,329 174ms 0ms 18 6,323 182ms 0ms 19 6,328 172ms 0ms 20 6,356 175ms 0ms 21 6,333 184ms 0ms 22 6,329 170ms 0ms 23 6,347 173ms 0ms [ User: symmetricds - Total duration: 4s564ms - Times executed: 151076 ]
[ User: pharmisight - Total duration: 15ms - Times executed: 230 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s580ms - Times executed: 151306 ]
-
COMMIT;
-
COMMIT;
-
COMMIT;
Date: 2019-01-13 07:10:40 Duration: 17ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:25:47 Duration: 16ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 00:22:19 Duration: 15ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 47,760 2s420ms 0ms 1ms 0ms SELECT itemcodes0_.item_id AS item_id11_15_0_, itemcodes0_.item_code_id AS item_cod1_18_0_, itemcodes0_.item_code_id AS item_cod1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemcodetype AS itemcode3_18_1_, itemcodes0_.isprimary AS isprimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdby AS createdb7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedby AS updatedb9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.item_id AS item_id11_18_1_ FROM item_codes itemcodes0_ WHERE itemcodes0_.item_id = ? ORDER BY itemcodes0_.code ASC;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 13 00 1,990 96ms 0ms 01 1,990 99ms 0ms 02 1,990 98ms 0ms 03 1,990 100ms 0ms 04 1,990 100ms 0ms 05 1,990 100ms 0ms 06 1,990 106ms 0ms 07 1,990 99ms 0ms 08 1,990 105ms 0ms 09 1,990 103ms 0ms 10 1,990 101ms 0ms 11 1,990 84ms 0ms 12 1,990 103ms 0ms 13 1,990 100ms 0ms 14 1,990 102ms 0ms 15 1,990 99ms 0ms 16 1,990 100ms 0ms 17 1,990 101ms 0ms 18 1,990 103ms 0ms 19 1,990 103ms 0ms 20 1,990 101ms 0ms 21 1,990 99ms 0ms 22 1,990 105ms 0ms 23 1,990 101ms 0ms [ User: pharmisight - Total duration: 2s420ms - Times executed: 47760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s420ms - Times executed: 47760 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-13 05:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 04:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 08:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 42,336 1s973ms 0ms 1ms 0ms SELECT itembarcod0_.item_id AS item_id12_15_0_, itembarcod0_.item_barcode_id AS item_bar1_16_0_, itembarcod0_.item_barcode_id AS item_bar1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hassiblings AS hassibli4_16_1_, itembarcod0_.itembarcodetype AS itembarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdby AS createdb8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedby AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.item_id AS item_id12_16_1_ FROM item_barcodes itembarcod0_ WHERE itembarcod0_.item_id = ? ORDER BY itembarcod0_.barcode ASC;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 13 00 1,764 78ms 0ms 01 1,764 81ms 0ms 02 1,764 81ms 0ms 03 1,764 83ms 0ms 04 1,764 81ms 0ms 05 1,764 81ms 0ms 06 1,764 86ms 0ms 07 1,764 81ms 0ms 08 1,764 86ms 0ms 09 1,764 84ms 0ms 10 1,764 82ms 0ms 11 1,764 69ms 0ms 12 1,764 85ms 0ms 13 1,764 81ms 0ms 14 1,764 83ms 0ms 15 1,764 80ms 0ms 16 1,764 81ms 0ms 17 1,764 83ms 0ms 18 1,764 83ms 0ms 19 1,764 84ms 0ms 20 1,764 82ms 0ms 21 1,764 81ms 0ms 22 1,764 85ms 0ms 23 1,764 82ms 0ms [ User: pharmisight - Total duration: 1s973ms - Times executed: 42336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s973ms - Times executed: 42336 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-13 03:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 11:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 25,875 1s256ms 0ms 0ms 0ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 13 00 1,078 52ms 0ms 01 1,078 51ms 0ms 02 1,078 52ms 0ms 03 1,078 52ms 0ms 04 1,078 52ms 0ms 05 1,078 52ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 52ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 52ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,078 52ms 0ms 18 1,078 53ms 0ms 19 1,078 52ms 0ms 20 1,078 52ms 0ms 21 1,078 51ms 0ms 22 1,078 52ms 0ms 23 1,081 52ms 0ms [ User: symmetricds - Total duration: 1s256ms - Times executed: 25875 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s256ms - Times executed: 25875 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-13 00:24:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:08:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 12:21:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 25,780 14s324ms 0ms 2ms 0ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 13 00 1,075 600ms 0ms 01 1,074 601ms 0ms 02 1,074 611ms 0ms 03 1,074 607ms 0ms 04 1,074 600ms 0ms 05 1,074 603ms 0ms 06 1,074 607ms 0ms 07 1,074 610ms 0ms 08 1,074 595ms 0ms 09 1,074 594ms 0ms 10 1,074 602ms 0ms 11 1,074 603ms 0ms 12 1,074 599ms 0ms 13 1,074 593ms 0ms 14 1,074 608ms 0ms 15 1,074 599ms 0ms 16 1,074 589ms 0ms 17 1,074 579ms 0ms 18 1,074 585ms 0ms 19 1,074 581ms 0ms 20 1,074 584ms 0ms 21 1,074 575ms 0ms 22 1,074 593ms 0ms 23 1,077 593ms 0ms [ User: symmetricds - Total duration: 14s324ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s324ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-13 05:08:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:48:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:41:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 25,098 1s194ms 0ms 5ms 0ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 13 00 1,108 51ms 0ms 01 1,040 48ms 0ms 02 1,044 50ms 0ms 03 1,044 51ms 0ms 04 1,040 48ms 0ms 05 1,040 47ms 0ms 06 1,044 49ms 0ms 07 1,044 49ms 0ms 08 1,040 48ms 0ms 09 1,040 49ms 0ms 10 1,040 50ms 0ms 11 1,044 49ms 0ms 12 1,044 53ms 0ms 13 1,044 51ms 0ms 14 1,044 48ms 0ms 15 1,044 49ms 0ms 16 1,044 50ms 0ms 17 1,044 49ms 0ms 18 1,044 47ms 0ms 19 1,044 50ms 0ms 20 1,044 48ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s194ms - Times executed: 25098 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s194ms - Times executed: 25098 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-13 12:53:42 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:55:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:44:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 17,266 451ms 0ms 0ms 0ms SELECT node_id, queue FROM sym_extract_request WHERE status = ? GROUP BY node_id, queue;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 13 00 720 18ms 0ms 01 720 18ms 0ms 02 718 19ms 0ms 03 720 18ms 0ms 04 720 18ms 0ms 05 718 18ms 0ms 06 720 19ms 0ms 07 720 18ms 0ms 08 720 18ms 0ms 09 718 18ms 0ms 10 720 18ms 0ms 11 720 18ms 0ms 12 718 18ms 0ms 13 720 18ms 0ms 14 720 18ms 0ms 15 718 19ms 0ms 16 720 19ms 0ms 17 720 19ms 0ms 18 720 18ms 0ms 19 718 19ms 0ms 20 720 19ms 0ms 21 720 19ms 0ms 22 720 18ms 0ms 23 718 19ms 0ms [ User: symmetricds - Total duration: 451ms - Times executed: 17266 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 451ms - Times executed: 17266 ]
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
-
SELECT node_id, queue FROM sym_extract_request WHERE status = $1 GROUP BY node_id, queue;
Date: 2019-01-13 10:51:25 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:08:12 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 17:02:53 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 9,121 105ms 0ms 0ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read COMMITTED;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 13 00 380 4ms 0ms 01 380 4ms 0ms 02 380 4ms 0ms 03 380 4ms 0ms 04 380 4ms 0ms 05 380 4ms 0ms 06 380 4ms 0ms 07 380 4ms 0ms 08 380 4ms 0ms 09 380 4ms 0ms 10 380 4ms 0ms 11 380 4ms 0ms 12 381 4ms 0ms 13 379 4ms 0ms 14 380 4ms 0ms 15 380 4ms 0ms 16 380 4ms 0ms 17 380 4ms 0ms 18 380 4ms 0ms 19 380 4ms 0ms 20 381 4ms 0ms 21 379 4ms 0ms 22 380 4ms 0ms 23 381 4ms 0ms [ User: symmetricds - Total duration: 105ms - Times executed: 9121 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 105ms - Times executed: 9121 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
Date: 2019-01-13 12:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:27:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:22:30 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 9,121 148ms 0ms 2ms 0ms SET session characteristics AS TRANSACTION ISOLATION level read UNCOMMITTED;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 13 00 378 6ms 0ms 01 380 5ms 0ms 02 380 6ms 0ms 03 380 6ms 0ms 04 380 6ms 0ms 05 383 5ms 0ms 06 377 6ms 0ms 07 382 6ms 0ms 08 380 8ms 0ms 09 381 6ms 0ms 10 379 6ms 0ms 11 380 6ms 0ms 12 381 5ms 0ms 13 377 5ms 0ms 14 380 6ms 0ms 15 383 6ms 0ms 16 377 6ms 0ms 17 382 6ms 0ms 18 378 6ms 0ms 19 380 6ms 0ms 20 383 6ms 0ms 21 377 6ms 0ms 22 380 6ms 0ms 23 383 6ms 0ms [ User: symmetricds - Total duration: 148ms - Times executed: 9121 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 148ms - Times executed: 9121 ]
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
-
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Date: 2019-01-13 08:00:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 11:00:00 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:25:56 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 8,593 197ms 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 #13
Day Hour Count Duration Avg duration Jan 13 00 358 8ms 0ms 01 358 8ms 0ms 02 358 8ms 0ms 03 358 8ms 0ms 04 358 8ms 0ms 05 358 8ms 0ms 06 358 8ms 0ms 07 358 8ms 0ms 08 358 8ms 0ms 09 358 8ms 0ms 10 358 8ms 0ms 11 358 8ms 0ms 12 358 8ms 0ms 13 358 8ms 0ms 14 358 8ms 0ms 15 358 8ms 0ms 16 358 8ms 0ms 17 358 8ms 0ms 18 358 8ms 0ms 19 358 8ms 0ms 20 358 8ms 0ms 21 358 8ms 0ms 22 358 8ms 0ms 23 359 8ms 0ms [ User: symmetricds - Total duration: 197ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 197ms - Times executed: 8593 ]
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
-
SELECT DISTINCT (data_id) FROM sym_data_event WHERE data_id >= $1 AND data_id <= $2 ORDER BY data_id ASC;
Date: 2019-01-13 21:42:16 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:44:27 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:38:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 8,593 280ms 0ms 0ms 0ms SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN ? AND ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 13 00 358 10ms 0ms 01 358 10ms 0ms 02 358 10ms 0ms 03 358 10ms 0ms 04 358 10ms 0ms 05 358 9ms 0ms 06 358 12ms 0ms 07 358 10ms 0ms 08 358 10ms 0ms 09 358 10ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 12ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 12ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 359 12ms 0ms [ User: symmetricds - Total duration: 280ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 280ms - Times executed: 8593 ]
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
-
SELECT DISTINCT channel_id FROM sym_data WHERE ((data_id BETWEEN $1 AND $2));
Date: 2019-01-13 13:57:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 06:06:09 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 11:48:34 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 8,593 394ms 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 #15
Day Hour Count Duration Avg duration Jan 13 00 358 16ms 0ms 01 358 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 15ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 358 15ms 0ms 18 358 16ms 0ms 19 358 16ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 359 16ms 0ms [ User: symmetricds - Total duration: 394ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 394ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-01-13 00:48:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:27:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:27:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 8,593 295ms 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 #16
Day Hour Count Duration Avg duration Jan 13 00 358 12ms 0ms 01 358 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 11ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 11ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 11ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 359 12ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-01-13 18:04:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 09:50:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:35:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 6,095 675ms 0ms 1ms 0ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 13 00 240 27ms 0ms 01 236 26ms 0ms 02 239 27ms 0ms 03 240 27ms 0ms 04 236 26ms 0ms 05 239 27ms 0ms 06 240 27ms 0ms 07 237 27ms 0ms 08 239 27ms 0ms 09 240 26ms 0ms 10 237 26ms 0ms 11 239 26ms 0ms 12 240 25ms 0ms 13 237 26ms 0ms 14 239 26ms 0ms 15 260 27ms 0ms 16 286 31ms 0ms 17 280 29ms 0ms 18 277 28ms 0ms 19 280 31ms 0ms 20 287 29ms 0ms 21 282 31ms 0ms 22 280 29ms 0ms 23 285 31ms 0ms [ User: symmetricds - Total duration: 675ms - Times executed: 6095 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 6095 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-13 19:22:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:58:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 17:26:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 6,094 282ms 0ms 0ms 0ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 13 00 240 11ms 0ms 01 236 11ms 0ms 02 239 11ms 0ms 03 240 11ms 0ms 04 236 10ms 0ms 05 239 11ms 0ms 06 240 11ms 0ms 07 237 10ms 0ms 08 239 11ms 0ms 09 240 11ms 0ms 10 237 10ms 0ms 11 239 11ms 0ms 12 240 11ms 0ms 13 237 10ms 0ms 14 239 11ms 0ms 15 260 11ms 0ms 16 286 13ms 0ms 17 280 12ms 0ms 18 277 12ms 0ms 19 280 12ms 0ms 20 287 13ms 0ms 21 282 12ms 0ms 22 280 12ms 0ms 23 284 12ms 0ms [ User: symmetricds - Total duration: 282ms - Times executed: 6094 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 282ms - Times executed: 6094 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-01-13 01:13:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 09:14:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:32:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 4,416 407ms 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 Jan 13 00 184 18ms 0ms 01 184 20ms 0ms 02 184 17ms 0ms 03 184 17ms 0ms 04 184 16ms 0ms 05 184 16ms 0ms 06 184 17ms 0ms 07 184 17ms 0ms 08 184 16ms 0ms 09 184 17ms 0ms 10 184 20ms 0ms 11 184 17ms 0ms 12 184 18ms 0ms 13 184 17ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 16ms 0ms 17 184 15ms 0ms 18 184 14ms 0ms 19 184 16ms 0ms 20 184 14ms 0ms 21 184 16ms 0ms 22 184 13ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 407ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 407ms - Times executed: 4416 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-01-13 01:44:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:59:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:53:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 1,976 97ms 0ms 0ms 0ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 13 00 872 20ms 0ms 01 48 3ms 0ms 02 48 3ms 0ms 03 48 3ms 0ms 04 44 2ms 0ms 05 48 3ms 0ms 06 52 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 2ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 4ms 0ms 16 48 2ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 48 3ms 0ms 21 48 3ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms [ User: symmetricds - Total duration: 97ms - Times executed: 1976 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 97ms - Times executed: 1976 ]
-
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-01-13 00:12:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 07:59:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:14:21 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 12ms 21ms 14ms 48 710ms SELECT this_.item_id AS item_id1_15_0_, this_.dmdcode AS dmdcode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.agefrom AS agefrom6_15_0_, this_.ageto AS ageto7_15_0_, this_.agefrommonths AS agefromm8_15_0_, this_.specialcare AS specialc9_15_0_, this_.extraprocedure AS extrapr10_15_0_, this_.averageqty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isitemalert AS isitema14_15_0_, this_.ismetabolic AS ismetab15_15_0_, this_.created AS created16_15_0_, this_.createdby AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedby AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packsize AS packsiz22_15_0_, this_.unitofmeasure AS unitofm23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM items this_ ORDER BY this_.description ASC;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 13 00 2 28ms 14ms 01 2 26ms 13ms 02 2 27ms 13ms 03 2 26ms 13ms 04 2 26ms 13ms 05 2 26ms 13ms 06 2 34ms 17ms 07 2 27ms 13ms 08 2 39ms 19ms 09 2 30ms 15ms 10 2 32ms 16ms 11 2 30ms 15ms 12 2 38ms 19ms 13 2 30ms 15ms 14 2 27ms 13ms 15 2 27ms 13ms 16 2 29ms 14ms 17 2 29ms 14ms 18 2 27ms 13ms 19 2 26ms 13ms 20 2 29ms 14ms 21 2 30ms 15ms 22 2 28ms 14ms 23 2 28ms 14ms [ User: pharmisight - Total duration: 710ms - Times executed: 48 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 710ms - Times executed: 48 ]
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
-
SELECT this_.ITEM_ID AS ITEM_ID1_15_0_, this_.dmdCode AS dmdCode2_15_0_, this_.description AS descript3_15_0_, this_.alias AS alias4_15_0_, this_.status AS status5_15_0_, this_.ageFrom AS ageFrom6_15_0_, this_.ageTo AS ageTo7_15_0_, this_.ageFromMonths AS ageFromM8_15_0_, this_.specialCare AS specialC9_15_0_, this_.extraProcedure AS extraPr10_15_0_, this_.averageQty AS average11_15_0_, this_.nutrition AS nutriti12_15_0_, this_.pack_calories AS pack_ca13_15_0_, this_.isItemAlert AS isItemA14_15_0_, this_.isMetabolic AS isMetab15_15_0_, this_.created AS created16_15_0_, this_.createdBy AS created17_15_0_, this_.updated AS updated18_15_0_, this_.updatedBy AS updated19_15_0_, this_.note AS note20_15_0_, this_.snomed AS snomed21_15_0_, this_.packSize AS packSiz22_15_0_, this_.unitOfMeasure AS unitOfM23_15_0_, this_.category AS categor24_15_0_, this_.is_unflavoured AS is_unfl25_15_0_, this_.unflavoured AS unflavo26_15_0_, this_.unitecode AS uniteco27_15_0_ FROM ITEMS this_ ORDER BY this_.description ASC;
Date: 2019-01-13 08:00:00 Duration: 21ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 12:00:00 Duration: 19ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 06:20:00 Duration: 18ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
2 4ms 11ms 6ms 112 728ms SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN TRUE THEN ? ELSE CASE am.amname WHEN ? THEN ? ELSE ? END END AS TYPE, (i.keys).n AS ordinal_position, trim(BOTH ? FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS column_name, CASE am.amname WHEN ? THEN CASE i.indoption [ (i.keys).n - ? ] & ? WHEN ? THEN ? ELSE ? END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = ? AND ct.relname = ? ORDER BY non_unique, TYPE, index_name, ordinal_position;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 13 00 66 434ms 6ms 01 2 13ms 6ms 02 2 13ms 6ms 03 2 13ms 6ms 04 2 13ms 6ms 05 2 8ms 4ms 06 2 8ms 4ms 07 2 13ms 6ms 08 2 9ms 4ms 09 2 13ms 6ms 10 2 13ms 6ms 11 2 13ms 6ms 12 2 13ms 6ms 13 2 16ms 8ms 14 2 13ms 6ms 15 2 17ms 8ms 16 2 8ms 4ms 17 2 13ms 6ms 18 2 13ms 6ms 19 2 13ms 6ms 20 2 13ms 6ms 21 2 13ms 6ms 22 2 13ms 6ms 23 2 13ms 6ms [ User: symmetricds - Total duration: 728ms - Times executed: 112 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 728ms - Times executed: 112 ]
-
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 = 'media_criptors' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN TRUE THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, FALSE)) AS COLUMN_NAME, CASE am.amname WHEN 'btree' THEN CASE i.indoption [ (i.keys).n - 1 ] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN ( SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray (i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE TRUE AND n.nspname = 'public' AND ct.relname = 'item_codes' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION;
Date: 2019-01-13 00:00:00 Duration: 11ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 00:00:00 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 15:00:26 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
3 0ms 7ms 5ms 192 1s126ms 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 #3
Day Hour Count Duration Avg duration Jan 13 00 8 42ms 5ms 01 8 45ms 5ms 02 8 52ms 6ms 03 8 47ms 5ms 04 7 46ms 6ms 05 8 45ms 5ms 06 9 49ms 5ms 07 8 52ms 6ms 08 8 49ms 6ms 09 8 41ms 5ms 10 8 49ms 6ms 11 8 46ms 5ms 12 8 50ms 6ms 13 8 46ms 5ms 14 8 45ms 5ms 15 8 52ms 6ms 16 8 39ms 4ms 17 8 46ms 5ms 18 8 45ms 5ms 19 8 52ms 6ms 20 8 40ms 5ms 21 8 41ms 5ms 22 8 48ms 6ms 23 8 48ms 6ms [ User: symmetricds - Total duration: 1s126ms - Times executed: 192 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s126ms - Times executed: 192 ]
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
-
UPDATE "public"."sym_node_host" SET "ip_address" = $1, "os_user" = $2, "os_name" = $3, "os_arch" = $4, "os_version" = $5, "available_processors" = $6, "free_memory_bytes" = $7, "total_memory_bytes" = $8, "max_memory_bytes" = $9, "java_version" = $10, "java_vendor" = $11, "symmetric_version" = $12, "timezone_offset" = $13, "heartbeat_time" = $14, "last_restart_time" = $15, "create_time" = $16, "jdbc_version" = $17, "instance_id" = $18 WHERE "node_id" = $19 AND "host_name" = $20;
Date: 2019-01-13 09:07:23 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:59:30 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:07:29 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
4 0ms 7ms 5ms 96 496ms UPDATE sym_node_host SET ip_address = ?, instance_id = ?, os_user = ?, os_name = ?, os_arch = ?, os_version = ?, available_processors = ?, free_memory_bytes = ?, total_memory_bytes = ?, max_memory_bytes = ?, java_version = ?, java_vendor = ?, jdbc_version = ?, symmetric_version = ?, timezone_offset = ?, heartbeat_time = ?, last_restart_time = ? WHERE node_id = ? AND host_name = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 00 4 16ms 4ms 01 4 21ms 5ms 02 4 20ms 5ms 03 4 21ms 5ms 04 4 27ms 6ms 05 4 27ms 6ms 06 4 21ms 5ms 07 4 21ms 5ms 08 4 26ms 6ms 09 4 14ms 3ms 10 4 18ms 4ms 11 4 20ms 5ms 12 4 20ms 5ms 13 4 9ms 2ms 14 4 23ms 5ms 15 4 26ms 6ms 16 4 18ms 4ms 17 4 9ms 2ms 18 4 24ms 6ms 19 4 15ms 3ms 20 4 28ms 7ms 21 4 20ms 5ms 22 4 20ms 5ms 23 4 21ms 5ms [ User: symmetricds - Total duration: 496ms - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 496ms - Times executed: 96 ]
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
-
UPDATE sym_node_host SET ip_address = $1, instance_id = $2, os_user = $3, os_name = $4, os_arch = $5, os_version = $6, available_processors = $7, free_memory_bytes = $8, total_memory_bytes = $9, max_memory_bytes = $10, java_version = $11, java_vendor = $12, jdbc_version = $13, symmetric_version = $14, timezone_offset = $15, heartbeat_time = $16, last_restart_time = $17 WHERE node_id = $18 AND host_name = $19;
Date: 2019-01-13 21:40:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:55:13 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:25:14 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
5 2ms 9ms 4ms 122 504ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 13 00 4 15ms 3ms 01 6 25ms 4ms 02 6 24ms 4ms 03 5 20ms 4ms 04 7 28ms 4ms 05 4 13ms 3ms 06 5 20ms 4ms 07 6 24ms 4ms 08 5 19ms 3ms 09 4 18ms 4ms 10 6 30ms 5ms 11 5 20ms 4ms 12 5 19ms 3ms 13 5 19ms 3ms 14 4 15ms 3ms 15 5 20ms 4ms 16 4 17ms 4ms 17 5 18ms 3ms 18 6 28ms 4ms 19 5 20ms 4ms 20 5 23ms 4ms 21 4 16ms 4ms 22 6 24ms 4ms 23 5 20ms 4ms [ User: symmetricds - Total duration: 504ms - Times executed: 122 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 504ms - Times executed: 122 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 631851 AS oid, 2 AS attnum UNION ALL SELECT 631851, 3 UNION ALL SELECT 631851, 4 UNION ALL SELECT 631851, 14 UNION ALL SELECT 631851, 16 UNION ALL SELECT 631851, 17 UNION ALL SELECT 631851, 18 UNION ALL SELECT 631851, 21 UNION ALL SELECT 631851, 19 UNION ALL SELECT 631851, 24 UNION ALL SELECT 631851, 25 UNION ALL SELECT 631851, 26 UNION ALL SELECT 631851, 20 UNION ALL SELECT 631851, 13 UNION ALL SELECT 631851, 36 UNION ALL SELECT 631851, 33 UNION ALL SELECT 631851, 34 UNION ALL SELECT 631851, 35 UNION ALL SELECT 631851, 37 UNION ALL SELECT 631851, 50 UNION ALL SELECT 631851, 51 UNION ALL SELECT 631851, 52 UNION ALL SELECT 631851, 6 UNION ALL SELECT 631851, 7 UNION ALL SELECT 631851, 8 UNION ALL SELECT 631851, 30 UNION ALL SELECT 631851, 31 UNION ALL SELECT 631851, 32 UNION ALL SELECT 631851, 23 UNION ALL SELECT 631851, 27 UNION ALL SELECT 631851, 28 UNION ALL SELECT 631851, 29 UNION ALL SELECT 631851, 22 UNION ALL SELECT 631851, 38 UNION ALL SELECT 631851, 39 UNION ALL SELECT 631851, 42 UNION ALL SELECT 631851, 43 UNION ALL SELECT 631851, 44 UNION ALL SELECT 631851, 45 UNION ALL SELECT 631851, 46 UNION ALL SELECT 631851, 53 UNION ALL SELECT 631851, 9 UNION ALL SELECT 631851, 10 UNION ALL SELECT 631851, 11 UNION ALL SELECT 631851, 1 UNION ALL SELECT 631851, 49 UNION ALL SELECT 631851, 15 UNION ALL SELECT 631851, 5 UNION ALL SELECT 631851, 41 UNION ALL SELECT 631851, 40 UNION ALL SELECT 631851, 55 UNION ALL SELECT 631851, 12) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 10:40:41 Duration: 9ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:10:44 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 20:40:46 Duration: 7ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
6 0ms 2ms 1ms 1,066 1s547ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 13 00 54 76ms 1ms 01 52 74ms 1ms 02 51 73ms 1ms 03 54 78ms 1ms 04 51 72ms 1ms 05 54 77ms 1ms 06 52 74ms 1ms 07 54 76ms 1ms 08 56 85ms 1ms 09 54 80ms 1ms 10 57 85ms 1ms 11 52 75ms 1ms 12 54 77ms 1ms 13 54 78ms 1ms 14 58 83ms 1ms 15 45 67ms 1ms 16 27 39ms 1ms 17 25 36ms 1ms 18 28 39ms 1ms 19 27 38ms 1ms 20 26 37ms 1ms 21 28 39ms 1ms 22 27 39ms 1ms 23 26 38ms 1ms [ User: symmetricds - Total duration: 1s547ms - Times executed: 1066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s547ms - Times executed: 1066 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16815 AS oid, 1 AS attnum UNION ALL SELECT 16815, 2 UNION ALL SELECT 16815, 3 UNION ALL SELECT 16815, 7 UNION ALL SELECT 16815, 4 UNION ALL SELECT 16815, 5 UNION ALL SELECT 16815, 8 UNION ALL SELECT 16815, 9 UNION ALL SELECT 16815, 10 UNION ALL SELECT 16815, 11 UNION ALL SELECT 16815, 12 UNION ALL SELECT 16815, 6 UNION ALL SELECT 16815, 14 UNION ALL SELECT 16815, 17 UNION ALL SELECT 16815, 16 UNION ALL SELECT 16815, 15 UNION ALL SELECT 16815, 18 UNION ALL SELECT 16815, 19 UNION ALL SELECT 16815, 20 UNION ALL SELECT 16815, 21 UNION ALL SELECT 16815, 22) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 12:11:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 08:38:00 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:45:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
7 0ms 5ms 1ms 1,368 1s441ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 13 00 70 72ms 1ms 01 68 77ms 1ms 02 67 74ms 1ms 03 68 73ms 1ms 04 67 71ms 1ms 05 65 66ms 1ms 06 70 77ms 1ms 07 68 73ms 1ms 08 69 72ms 1ms 09 71 69ms 0ms 10 69 75ms 1ms 11 69 72ms 1ms 12 69 74ms 1ms 13 69 72ms 1ms 14 70 73ms 1ms 15 54 56ms 1ms 16 36 37ms 1ms 17 33 33ms 1ms 18 39 38ms 0ms 19 35 35ms 1ms 20 33 32ms 0ms 21 36 36ms 1ms 22 37 37ms 1ms 23 36 37ms 1ms [ User: symmetricds - Total duration: 1s441ms - Times executed: 1368 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s441ms - Times executed: 1368 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17043 AS oid, 1 AS attnum UNION ALL SELECT 17043, 2 UNION ALL SELECT 17043, 3 UNION ALL SELECT 17043, 4 UNION ALL SELECT 17043, 5 UNION ALL SELECT 17043, 6 UNION ALL SELECT 17043, 7 UNION ALL SELECT 17043, 10 UNION ALL SELECT 17043, 11 UNION ALL SELECT 17043, 8 UNION ALL SELECT 17043, 9 UNION ALL SELECT 17043, 12 UNION ALL SELECT 17043, 13) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 07:45:32 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:23:39 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 14:19:42 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
8 0ms 1ms 0ms 1,078 1s27ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 13 00 54 52ms 0ms 01 56 54ms 0ms 02 53 50ms 0ms 03 54 52ms 0ms 04 52 50ms 0ms 05 55 53ms 0ms 06 56 54ms 0ms 07 55 51ms 0ms 08 56 52ms 0ms 09 55 51ms 0ms 10 57 55ms 0ms 11 53 50ms 0ms 12 56 53ms 0ms 13 53 48ms 0ms 14 56 54ms 0ms 15 43 41ms 0ms 16 27 25ms 0ms 17 25 23ms 0ms 18 28 26ms 0ms 19 27 25ms 0ms 20 26 23ms 0ms 21 28 26ms 0ms 22 27 25ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 1s27ms - Times executed: 1078 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s27ms - Times executed: 1078 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 16955 AS oid, 1 AS attnum UNION ALL SELECT 16955, 2 UNION ALL SELECT 16955, 3 UNION ALL SELECT 16955, 4 UNION ALL SELECT 16955, 5 UNION ALL SELECT 16955, 6 UNION ALL SELECT 16955, 8 UNION ALL SELECT 16955, 9 UNION ALL SELECT 16955, 7 UNION ALL SELECT 16955, 14 UNION ALL SELECT 16955, 10 UNION ALL SELECT 16955, 11 UNION ALL SELECT 16955, 12 UNION ALL SELECT 16955, 13 UNION ALL SELECT 16955, 15 UNION ALL SELECT 16955, 17 UNION ALL SELECT 16955, 16) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 15:19:44 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:03:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:59:28 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
9 0ms 1ms 0ms 1,066 949ms SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = ? AND t.typnotnull), a.attidentity != ? OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE ? FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT ? AS oid, ? AS attnum UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ? UNION ALL SELECT ?, ?) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 13 00 54 48ms 0ms 01 56 49ms 0ms 02 53 48ms 0ms 03 54 48ms 0ms 04 51 45ms 0ms 05 55 48ms 0ms 06 54 48ms 0ms 07 54 47ms 0ms 08 54 47ms 0ms 09 53 46ms 0ms 10 57 51ms 0ms 11 52 46ms 0ms 12 55 48ms 0ms 13 51 43ms 0ms 14 56 50ms 0ms 15 43 38ms 0ms 16 27 24ms 0ms 17 25 22ms 0ms 18 28 25ms 0ms 19 27 23ms 0ms 20 26 22ms 0ms 21 28 24ms 0ms 22 27 24ms 0ms 23 26 23ms 0ms [ User: symmetricds - Total duration: 949ms - Times executed: 1066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 949ms - Times executed: 1066 ]
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
-
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN ( SELECT 17160 AS oid, 1 AS attnum UNION ALL SELECT 17160, 2 UNION ALL SELECT 17160, 3 UNION ALL SELECT 17160, 9 UNION ALL SELECT 17160, 15 UNION ALL SELECT 17160, 12 UNION ALL SELECT 17160, 11 UNION ALL SELECT 17160, 13 UNION ALL SELECT 17160, 8 UNION ALL SELECT 17160, 7 UNION ALL SELECT 17160, 6 UNION ALL SELECT 17160, 5 UNION ALL SELECT 17160, 4 UNION ALL SELECT 17160, 10 UNION ALL SELECT 17160, 17 UNION ALL SELECT 17160, 14) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum);
Date: 2019-01-13 07:17:33 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:11:29 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:11:40 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
10 0ms 2ms 0ms 25,780 14s324ms SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 13 00 1,075 600ms 0ms 01 1,074 601ms 0ms 02 1,074 611ms 0ms 03 1,074 607ms 0ms 04 1,074 600ms 0ms 05 1,074 603ms 0ms 06 1,074 607ms 0ms 07 1,074 610ms 0ms 08 1,074 595ms 0ms 09 1,074 594ms 0ms 10 1,074 602ms 0ms 11 1,074 603ms 0ms 12 1,074 599ms 0ms 13 1,074 593ms 0ms 14 1,074 608ms 0ms 15 1,074 599ms 0ms 16 1,074 589ms 0ms 17 1,074 579ms 0ms 18 1,074 585ms 0ms 19 1,074 581ms 0ms 20 1,074 584ms 0ms 21 1,074 575ms 0ms 22 1,074 593ms 0ms 23 1,077 593ms 0ms [ User: symmetricds - Total duration: 14s324ms - Times executed: 25780 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s324ms - Times executed: 25780 ]
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
-
SELECT trigger_hist_id, trigger_id, source_table_name, table_hash, create_time, pk_column_names, column_names, last_trigger_build_reason, name_for_delete_trigger, name_for_insert_trigger, name_for_update_trigger, source_schema_name, source_catalog_name, trigger_row_hash, trigger_template_hash, error_message FROM sym_trigger_hist WHERE inactive_time IS NULL;
Date: 2019-01-13 05:08:40 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 22:48:47 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:41:03 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
11 0ms 1ms 0ms 6,095 675ms SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 13 00 240 27ms 0ms 01 236 26ms 0ms 02 239 27ms 0ms 03 240 27ms 0ms 04 236 26ms 0ms 05 239 27ms 0ms 06 240 27ms 0ms 07 237 27ms 0ms 08 239 27ms 0ms 09 240 26ms 0ms 10 237 26ms 0ms 11 239 26ms 0ms 12 240 25ms 0ms 13 237 26ms 0ms 14 239 26ms 0ms 15 260 27ms 0ms 16 286 31ms 0ms 17 280 29ms 0ms 18 277 28ms 0ms 19 280 31ms 0ms 20 287 29ms 0ms 21 282 31ms 0ms 22 280 29ms 0ms 23 285 31ms 0ms [ User: symmetricds - Total duration: 675ms - Times executed: 6095 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 675ms - Times executed: 6095 ]
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
-
SELECT c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action FROM sym_channel c ORDER BY c.processing_order ASC, c.channel_id;
Date: 2019-01-13 19:22:45 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:58:48 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 17:26:44 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
12 0ms 4ms 0ms 4,416 407ms SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = ?) AND b.node_id = ? AND c.queue = ? AND b.status IN (...) ORDER BY b.batch_id ASC;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 13 00 184 18ms 0ms 01 184 20ms 0ms 02 184 17ms 0ms 03 184 17ms 0ms 04 184 16ms 0ms 05 184 16ms 0ms 06 184 17ms 0ms 07 184 17ms 0ms 08 184 16ms 0ms 09 184 17ms 0ms 10 184 20ms 0ms 11 184 17ms 0ms 12 184 18ms 0ms 13 184 17ms 0ms 14 184 16ms 0ms 15 184 16ms 0ms 16 184 16ms 0ms 17 184 15ms 0ms 18 184 14ms 0ms 19 184 16ms 0ms 20 184 14ms 0ms 21 184 16ms 0ms 22 184 13ms 0ms 23 184 15ms 0ms [ User: symmetricds - Total duration: 407ms - Times executed: 4416 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 407ms - Times executed: 4416 ]
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
-
SELECT b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary FROM sym_outgoing_batch b JOIN sym_channel c ON c.channel_id = b.channel_id WHERE (c.data_event_action IS NULL OR c.data_event_action = $1) AND b.node_id = $2 AND c.queue = $3 AND b.status IN ($4, $5, $6, $7, $8, $9, $10, $11) ORDER BY b.batch_id ASC;
Date: 2019-01-13 01:44:39 Duration: 4ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:59:41 Duration: 3ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 23:53:48 Duration: 1ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
13 0ms 1ms 0ms 47,760 2s420ms 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 #13
Day Hour Count Duration Avg duration Jan 13 00 1,990 96ms 0ms 01 1,990 99ms 0ms 02 1,990 98ms 0ms 03 1,990 100ms 0ms 04 1,990 100ms 0ms 05 1,990 100ms 0ms 06 1,990 106ms 0ms 07 1,990 99ms 0ms 08 1,990 105ms 0ms 09 1,990 103ms 0ms 10 1,990 101ms 0ms 11 1,990 84ms 0ms 12 1,990 103ms 0ms 13 1,990 100ms 0ms 14 1,990 102ms 0ms 15 1,990 99ms 0ms 16 1,990 100ms 0ms 17 1,990 101ms 0ms 18 1,990 103ms 0ms 19 1,990 103ms 0ms 20 1,990 101ms 0ms 21 1,990 99ms 0ms 22 1,990 105ms 0ms 23 1,990 101ms 0ms [ User: pharmisight - Total duration: 2s420ms - Times executed: 47760 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2s420ms - Times executed: 47760 ]
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
-
SELECT itemcodes0_.ITEM_ID AS ITEM_ID11_15_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_0_, itemcodes0_.ITEM_CODE_ID AS ITEM_COD1_18_1_, itemcodes0_.code AS code2_18_1_, itemcodes0_.itemCodeType AS itemCode3_18_1_, itemcodes0_.isPrimary AS isPrimar4_18_1_, itemcodes0_.status AS status5_18_1_, itemcodes0_.created AS created6_18_1_, itemcodes0_.createdBy AS createdB7_18_1_, itemcodes0_.updated AS updated8_18_1_, itemcodes0_.updatedBy AS updatedB9_18_1_, itemcodes0_.note AS note10_18_1_, itemcodes0_.ITEM_ID AS ITEM_ID11_18_1_ FROM ITEM_CODES itemcodes0_ WHERE itemcodes0_.ITEM_ID = $1 ORDER BY itemcodes0_.code ASC;
Date: 2019-01-13 05:00:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 04:20:00 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 08:20:01 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
14 0ms 0ms 0ms 1,976 97ms SELECT set_config(?, ?, FALSE);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 13 00 872 20ms 0ms 01 48 3ms 0ms 02 48 3ms 0ms 03 48 3ms 0ms 04 44 2ms 0ms 05 48 3ms 0ms 06 52 3ms 0ms 07 48 3ms 0ms 08 48 3ms 0ms 09 48 2ms 0ms 10 48 3ms 0ms 11 48 3ms 0ms 12 48 3ms 0ms 13 48 3ms 0ms 14 48 3ms 0ms 15 48 4ms 0ms 16 48 2ms 0ms 17 48 3ms 0ms 18 48 3ms 0ms 19 48 3ms 0ms 20 48 3ms 0ms 21 48 3ms 0ms 22 48 3ms 0ms 23 48 3ms 0ms [ User: symmetricds - Total duration: 97ms - Times executed: 1976 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 97ms - Times executed: 1976 ]
-
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-01-13 00:12:19 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 07:59:23 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:14:21 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
15 0ms 0ms 0ms 25,875 1s256ms SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 13 00 1,078 52ms 0ms 01 1,078 51ms 0ms 02 1,078 52ms 0ms 03 1,078 52ms 0ms 04 1,078 52ms 0ms 05 1,078 52ms 0ms 06 1,078 52ms 0ms 07 1,078 52ms 0ms 08 1,078 52ms 0ms 09 1,078 52ms 0ms 10 1,078 52ms 0ms 11 1,078 52ms 0ms 12 1,078 52ms 0ms 13 1,078 52ms 0ms 14 1,078 52ms 0ms 15 1,078 52ms 0ms 16 1,078 52ms 0ms 17 1,078 52ms 0ms 18 1,078 53ms 0ms 19 1,078 52ms 0ms 20 1,078 52ms 0ms 21 1,078 51ms 0ms 22 1,078 52ms 0ms 23 1,081 52ms 0ms [ User: symmetricds - Total duration: 1s256ms - Times executed: 25875 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s256ms - Times executed: 25875 ]
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
-
SELECT c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version FROM sym_node c WHERE node_id = $1;
Date: 2019-01-13 00:24:04 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 05:08:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 12:21:15 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
16 0ms 5ms 0ms 25,098 1s194ms SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 13 00 1,108 51ms 0ms 01 1,040 48ms 0ms 02 1,044 50ms 0ms 03 1,044 51ms 0ms 04 1,040 48ms 0ms 05 1,040 47ms 0ms 06 1,044 49ms 0ms 07 1,044 49ms 0ms 08 1,040 48ms 0ms 09 1,040 49ms 0ms 10 1,040 50ms 0ms 11 1,044 49ms 0ms 12 1,044 53ms 0ms 13 1,044 51ms 0ms 14 1,044 48ms 0ms 15 1,044 49ms 0ms 16 1,044 50ms 0ms 17 1,044 49ms 0ms 18 1,044 47ms 0ms 19 1,044 50ms 0ms 20 1,044 48ms 0ms 21 1,044 49ms 0ms 22 1,044 49ms 0ms 23 1,046 51ms 0ms [ User: symmetricds - Total duration: 1s194ms - Times executed: 25098 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s194ms - Times executed: 25098 ]
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
-
SELECT node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by FROM sym_node_security;
Date: 2019-01-13 12:53:42 Duration: 5ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 10:55:41 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:44:42 Duration: 2ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
17 0ms 1ms 0ms 42,336 1s973ms 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 #17
Day Hour Count Duration Avg duration Jan 13 00 1,764 78ms 0ms 01 1,764 81ms 0ms 02 1,764 81ms 0ms 03 1,764 83ms 0ms 04 1,764 81ms 0ms 05 1,764 81ms 0ms 06 1,764 86ms 0ms 07 1,764 81ms 0ms 08 1,764 86ms 0ms 09 1,764 84ms 0ms 10 1,764 82ms 0ms 11 1,764 69ms 0ms 12 1,764 85ms 0ms 13 1,764 81ms 0ms 14 1,764 83ms 0ms 15 1,764 80ms 0ms 16 1,764 81ms 0ms 17 1,764 83ms 0ms 18 1,764 83ms 0ms 19 1,764 84ms 0ms 20 1,764 82ms 0ms 21 1,764 81ms 0ms 22 1,764 85ms 0ms 23 1,764 82ms 0ms [ User: pharmisight - Total duration: 1s973ms - Times executed: 42336 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1s973ms - Times executed: 42336 ]
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
-
SELECT itembarcod0_.ITEM_ID AS ITEM_ID12_15_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_0_, itembarcod0_.ITEM_BARCODE_ID AS ITEM_BAR1_16_1_, itembarcod0_.barcode AS barcode2_16_1_, itembarcod0_.size AS size3_16_1_, itembarcod0_.hasSiblings AS hasSibli4_16_1_, itembarcod0_.itemBarcodeType AS itemBarc5_16_1_, itembarcod0_.status AS status6_16_1_, itembarcod0_.created AS created7_16_1_, itembarcod0_.createdBy AS createdB8_16_1_, itembarcod0_.updated AS updated9_16_1_, itembarcod0_.updatedBy AS updated10_16_1_, itembarcod0_.note AS note11_16_1_, itembarcod0_.ITEM_ID AS ITEM_ID12_16_1_ FROM ITEM_BARCODES itembarcod0_ WHERE itembarcod0_.ITEM_ID = $1 ORDER BY itembarcod0_.barcode ASC;
Date: 2019-01-13 03:20:01 Duration: 1ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 11:00:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 19:20:00 Duration: 0ms Database: pharmisight User: pharmisight Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
18 0ms 0ms 0ms 6,094 282ms SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = ? ORDER BY channel_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 13 00 240 11ms 0ms 01 236 11ms 0ms 02 239 11ms 0ms 03 240 11ms 0ms 04 236 10ms 0ms 05 239 11ms 0ms 06 240 11ms 0ms 07 237 10ms 0ms 08 239 11ms 0ms 09 240 11ms 0ms 10 237 10ms 0ms 11 239 11ms 0ms 12 240 11ms 0ms 13 237 10ms 0ms 14 239 11ms 0ms 15 260 11ms 0ms 16 286 13ms 0ms 17 280 12ms 0ms 18 277 12ms 0ms 19 280 12ms 0ms 20 287 13ms 0ms 21 282 12ms 0ms 22 280 12ms 0ms 23 284 12ms 0ms [ User: symmetricds - Total duration: 282ms - Times executed: 6094 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 282ms - Times executed: 6094 ]
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
-
SELECT channel_id, last_extract_time, suspend_enabled, ignore_enabled FROM sym_node_channel_ctl WHERE node_id = $1 ORDER BY channel_id;
Date: 2019-01-13 01:13:39 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 09:14:40 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 21:32:46 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
19 0ms 0ms 0ms 8,593 394ms SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = ? ORDER BY start_id ASC;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 13 00 358 16ms 0ms 01 358 16ms 0ms 02 358 16ms 0ms 03 358 16ms 0ms 04 358 16ms 0ms 05 358 16ms 0ms 06 358 16ms 0ms 07 358 16ms 0ms 08 358 16ms 0ms 09 358 15ms 0ms 10 358 16ms 0ms 11 358 16ms 0ms 12 358 16ms 0ms 13 358 16ms 0ms 14 358 16ms 0ms 15 358 16ms 0ms 16 358 16ms 0ms 17 358 15ms 0ms 18 358 16ms 0ms 19 358 16ms 0ms 20 358 16ms 0ms 21 358 16ms 0ms 22 358 16ms 0ms 23 359 16ms 0ms [ User: symmetricds - Total duration: 394ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 394ms - Times executed: 8593 ]
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
-
SELECT start_id, end_id, create_time FROM sym_data_gap WHERE status = $1 ORDER BY start_id ASC;
Date: 2019-01-13 00:48:42 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 18:27:54 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 13:27:37 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 0ms 0ms 8,593 295ms SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = ? AND processed = ? ORDER BY create_time, target_node_id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 13 00 358 12ms 0ms 01 358 12ms 0ms 02 358 12ms 0ms 03 358 12ms 0ms 04 358 12ms 0ms 05 358 11ms 0ms 06 358 12ms 0ms 07 358 12ms 0ms 08 358 12ms 0ms 09 358 12ms 0ms 10 358 12ms 0ms 11 358 12ms 0ms 12 358 11ms 0ms 13 358 12ms 0ms 14 358 12ms 0ms 15 358 11ms 0ms 16 358 12ms 0ms 17 358 12ms 0ms 18 358 12ms 0ms 19 358 12ms 0ms 20 358 12ms 0ms 21 358 12ms 0ms 22 358 12ms 0ms 23 359 12ms 0ms [ User: symmetricds - Total duration: 295ms - Times executed: 8593 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 295ms - Times executed: 8593 ]
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
-
SELECT target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id FROM sym_table_reload_request WHERE source_node_id = $1 AND processed = 0 ORDER BY create_time, target_node_id;
Date: 2019-01-13 18:04:47 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 09:50:24 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
Date: 2019-01-13 02:35:58 Duration: 0ms Database: pharmisight User: symmetricds Remote: 10.10.10.1 Application: PostgreSQL JDBC Driver Bind query: yes
-
Events
Log levels
Key values
- 3,634,254 Log entries
Events distribution
Key values
- 0 PANIC entries
- 7 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 7 Total events found
Rank Times reported Error 1 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL off
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 13 10 2 20 1 - FATAL: no pg_hba.conf entry for host "198.20.70.114", user "postgres", database "template0", SSL off
- FATAL: no pg_hba.conf entry for host "198.20.70.114", user "postgres", database "-h", SSL off
- FATAL: no pg_hba.conf entry for host "122.228.19.79", user "root", database "root", SSL off
Date: 2019-01-13 10:28:53 Database: template0 Application: [unknown] User: postgres Remote: 198.20.70.114 Code:
Date: 2019-01-13 10:28:54 Database: -h Application: [unknown] User: postgres Remote: 198.20.70.114 Code:
Date: 2019-01-13 20:21:48 Database: root Application: [unknown] User: root Remote: 122.228.19.79 Code:
2 2 FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 13 06 1 10 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 2.0 to 3.0
Date: 2019-01-13 06:03:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 125.64.94.197 Code:
3 2 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL on
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 13 10 2 - FATAL: no pg_hba.conf entry for host "198.20.70.114", user "postgres", database "template0", SSL on
- FATAL: no pg_hba.conf entry for host "198.20.70.114", user "postgres", database "-h", SSL on
Date: 2019-01-13 10:28:52 Database: template0 Application: [unknown] User: postgres Remote: 198.20.70.114 Code:
Date: 2019-01-13 10:28:54 Database: -h Application: [unknown] User: postgres Remote: 198.20.70.114 Code: