Clickhouse: DB::KeyCondition::mayBeTrueInRange() is a bottleneck in a PK lookup

[bobrik]

I'm trying to make "last X things" query work reasonably fast on different ranges.

My schema can be reduced to:

CREATE TABLE jaeger_index_v2 (
  timestamp DateTime CODEC(Delta, ZSTD(1)),
  antiTimestamp Int64 MATERIALIZED -toUnixTimestamp(timestamp) CODEC(Delta, ZSTD(1)),
  traceID String CODEC(ZSTD(1)),
  service LowCardinality(String) CODEC(ZSTD(1))
) ENGINE MergeTree()
PARTITION BY toDate(toDateTime(-antiTimestamp))
ORDER BY (service, antiTimestamp)
SETTINGS index_granularity=1024

In #11541 you can find the reasoning behind antiTimestamp, but here it's only important that the primary key of my table is (service, antiTimestamp).

There are two queries I'm interested in:

• Last 10 unique traceID, 1h window: ~0.6s runtime.

SELECT DISTINCT traceID
  FROM jaeger_index_v2
 WHERE service = 'nginx-fl'
   AND antiTimestamp <= -toUnixTimestamp(now() - 3600)
   AND antiTimestamp >= -toUnixTimestamp(now())
 ORDER BY service,
          antiTimestamp
 LIMIT 10

Trace output

$ echo "SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE service = 'nginx-fl' AND antiTimestamp between -toUnixTimestamp(now()) and -toUnixTimestamp(now() - 3600) ORDER BY service, antiTimestamp LIMIT 10" | docker exec -i clickhouse-jaeger clickhouse-client --send_logs_level=trace --database jaeger
[36ssds310] 2020.06.10 04:06:19.119444 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> executeQuery: (from 127.0.0.1:61902) SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE (service = 'nginx-fl') AND ((antiTimestamp >= (-toUnixTimestamp(now()))) AND (antiTimestamp <= (-toUnixTimestamp(now() - 3600)))) ORDER BY service ASC, antiTimestamp ASC LIMIT 10
[36ssds310] 2020.06.10 04:06:19.121585 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> ContextAccess (default): Access granted: SELECT(antiTimestamp, traceID, service) ON jaeger.jaeger_index_v2
[36ssds310] 2020.06.10 04:06:19.122545 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Key condition: (column 0 in ['nginx-fl', 'nginx-fl']), (column 1 in [-1591761979, +inf)), (column 1 in (-inf, -1591758379]), and, and
[36ssds310] 2020.06.10 04:06:19.122590 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): MinMax index condition: unknown, (column 0 in [-1591761979, +inf)), (column 0 in (-inf, -1591758379]), and, and
[36ssds310] 2020.06.10 04:06:19.494531 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Selected 29 parts by date, 29 parts by key, 250017 marks to read from 29 ranges
[36ssds310] 2020.06.10 04:06:19.494785 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1299820_1299820_0, approx. 6144, up to 6144 rows starting from 4096
[36ssds310] 2020.06.10 04:06:19.494864 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1299819_1299819_0, approx. 6144, up to 6144 rows starting from 4096
[36ssds310] 2020.06.10 04:06:19.494933 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1299818_1299818_0, approx. 5120, up to 5120 rows starting from 4096
[36ssds310] 2020.06.10 04:06:19.495000 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1299817_1299817_0, approx. 6144, up to 6144 rows starting from 3072
[36ssds310] 2020.06.10 04:06:19.495066 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200610_1299811_1299816_1, approx. 30720, up to 30720 rows starting from 25600
[36ssds310] 2020.06.10 04:06:19.495132 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200610_1299805_1299810_1, approx. 30720, up to 30720 rows starting from 25600
[36ssds310] 2020.06.10 04:06:19.495191 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200610_1299799_1299804_1, approx. 31744, up to 31744 rows starting from 23552
[36ssds310] 2020.06.10 04:06:19.495254 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 6 ranges from part 20200610_1299793_1299798_1, approx. 32768, up to 32768 rows starting from 23552
[36ssds310] 2020.06.10 04:06:19.495320 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200610_1299776_1299792_2, approx. 89088, up to 89088 rows starting from 68608
[36ssds310] 2020.06.10 04:06:19.495391 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299716_1299775_3, approx. 299008, up to 299008 rows starting from 252928
[36ssds310] 2020.06.10 04:06:19.495456 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299660_1299715_3, approx. 279552, up to 279552 rows starting from 238592
[36ssds310] 2020.06.10 04:06:19.495531 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299609_1299659_3, approx. 247808, up to 247808 rows starting from 224256
[36ssds310] 2020.06.10 04:06:19.495602 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299547_1299608_3, approx. 325632, up to 325632 rows starting from 241664
[36ssds310] 2020.06.10 04:06:19.495669 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299310_1299546_4, approx. 1239040, up to 1239040 rows starting from 940032
[36ssds310] 2020.06.10 04:06:19.496741 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299122_1299309_4, approx. 952320, up to 952320 rows starting from 780288
[36ssds310] 2020.06.10 04:06:19.496813 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298940_1299121_4, approx. 903168, up to 903168 rows starting from 778240
[36ssds310] 2020.06.10 04:06:19.496892 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298881_1298939_3, approx. 289792, up to 289792 rows starting from 256000
[36ssds310] 2020.06.10 04:06:19.496957 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298776_1298880_4, approx. 500736, up to 500736 rows starting from 474112
[36ssds310] 2020.06.10 04:06:19.497020 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298726_1298775_3, approx. 260096, up to 260096 rows starting from 200704
[36ssds310] 2020.06.10 04:06:19.497084 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298501_1298725_4, approx. 1156096, up to 1156096 rows starting from 917504
[36ssds310] 2020.06.10 04:06:19.497140 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298318_1298500_4, approx. 925696, up to 925696 rows starting from 761856
[36ssds310] 2020.06.10 04:06:19.497204 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298064_1298317_4, approx. 1274880, up to 1274880 rows starting from 1070080
[36ssds310] 2020.06.10 04:06:19.497278 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1296990_1298063_5, approx. 1775616, up to 1775616 rows starting from 4359168
[36ssds310] 2020.06.10 04:06:19.497530 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1296990_1298063_5, approx. 3749888, up to 3749888 rows starting from 6134784
[36ssds310] 2020.06.10 04:06:19.497622 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1295858_1296989_5, approx. 5734400, up to 5734400 rows starting from 4700160
[36ssds310] 2020.06.10 04:06:19.497722 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1294629_1295857_5, approx. 1183744, up to 1183744 rows starting from 5324800
[36ssds310] 2020.06.10 04:06:19.497833 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1294629_1295857_5, approx. 4847616, up to 4847616 rows starting from 6508544
[36ssds310] 2020.06.10 04:06:19.497904 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1293763_1294628_5, approx. 4402176, up to 4402176 rows starting from 3566592
[36ssds310] 2020.06.10 04:06:19.497976 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 1418240, up to 1418240 rows starting from 26479616
[36ssds310] 2020.06.10 04:06:19.498064 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 10668032, up to 10668032 rows starting from 27897856
[36ssds310] 2020.06.10 04:06:19.498142 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 10668032, up to 10668032 rows starting from 38565888
[36ssds310] 2020.06.10 04:06:19.498254 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 10668032, up to 10668032 rows starting from 49233920
[36ssds310] 2020.06.10 04:06:19.498327 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 328704, up to 328704 rows starting from 59901952
[36ssds310] 2020.06.10 04:06:19.498396 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10339328, up to 10339328 rows starting from 98164736
[36ssds310] 2020.06.10 04:06:19.498527 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 108504064
[36ssds310] 2020.06.10 04:06:19.498631 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 119172096
[36ssds310] 2020.06.10 04:06:19.498732 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 129840128
[36ssds310] 2020.06.10 04:06:19.498847 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 140508160
[36ssds310] 2020.06.10 04:06:19.498946 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 151176192
[36ssds310] 2020.06.10 04:06:19.499049 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 161844224
[36ssds310] 2020.06.10 04:06:19.499142 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 172512256
[36ssds310] 2020.06.10 04:06:19.499232 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 183180288
[36ssds310] 2020.06.10 04:06:19.499332 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 193848320
[36ssds310] 2020.06.10 04:06:19.499413 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 204516352
[36ssds310] 2020.06.10 04:06:19.499520 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 10668032, up to 10668032 rows starting from 215184384
[36ssds310] 2020.06.10 04:06:19.499614 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 654336, up to 654336 rows starting from 225852416
[36ssds310] 2020.06.10 04:06:19.499714 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10013696, up to 10013696 rows starting from 100039680
[36ssds310] 2020.06.10 04:06:19.499837 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10668032, up to 10668032 rows starting from 110053376
[36ssds310] 2020.06.10 04:06:19.499909 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10668032, up to 10668032 rows starting from 120721408
[36ssds310] 2020.06.10 04:06:19.499972 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10668032, up to 10668032 rows starting from 131389440
[36ssds310] 2020.06.10 04:06:19.500045 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10668032, up to 10668032 rows starting from 142057472
[36ssds310] 2020.06.10 04:06:19.500124 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 10652672, up to 10652672 rows starting from 152725504
[36ssds310] 2020.06.10 04:06:19.500242 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
28baf857f540ac76
00e89427a40aed20
24596c03d40a825d
eb766c4f037f10ce
31944fce16174447
b20232192914afc1
95ca0f9b5476c2cb
85b7756978a73254
50653aba8fb888ed
91d9ff11ada4ec47
[36ssds310] 2020.06.10 04:06:19.631431 [ 162 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 4809 rows in 0.13 sec., 36991.24 rows/sec., 66.58 MB/sec.
[36ssds310] 2020.06.10 04:06:19.631598 [ 162 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.13 sec., 473777.43 rows/sec., 28.15 MB/sec.
[36ssds310] 2020.06.10 04:06:19.631693 [ 162 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.13 sec., 473777.43 rows/sec., 28.15 MB/sec.
[36ssds310] 2020.06.10 04:06:19.631807 [ 162 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.13 sec., 480955.87 rows/sec., 28.58 MB/sec.
[36ssds310] 2020.06.10 04:06:19.638128 [ 129 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 150059 rows in 0.14 sec., 1064217.64 rows/sec., 61.38 MB/sec.
[36ssds310] 2020.06.10 04:06:19.639514 [ 181 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MergingSortedTransform: Merge sorted 1 blocks, 109214 rows in 0.14 sec., 769090.57 rows/sec., 30.47 MB/sec.
[36ssds310] 2020.06.10 04:06:19.642601 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Information> executeQuery: Read 3196448 rows, 103.71 MiB in 0.523 sec., 6111478 rows/sec., 198.29 MiB/sec.
[36ssds310] 2020.06.10 04:06:19.642791 [ 134 ] {dd4074bc-33da-423e-a41d-df287f86e280} <Debug> MemoryTracker: Peak memory usage (for query): 214.62 MiB.

• Last 10 unique traceID, 24h window: ~9.5s runtime.

SELECT DISTINCT traceID
  FROM jaeger_index_v2
 WHERE service = 'nginx-fl'
   AND antiTimestamp <= -toUnixTimestamp(now() - 3600 * 24)
   AND antiTimestamp >= -toUnixTimestamp(now())
 ORDER BY service,
          antiTimestamp
 LIMIT 10

Trace output

$ echo "SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE service = 'nginx-fl' AND antiTimestamp between -toUnixTimestamp(now()) and -toUnixTimestamp(now() - 3600 * 24) ORDER BY service, antiTimestamp LIMIT 10" | docker exec -i clickhouse-jaeger clickhouse-client --send_logs_level=trace --database jaeger
[36ssds310] 2020.06.10 04:07:14.361998 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> executeQuery: (from 127.0.0.1:62214) SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE (service = 'nginx-fl') AND ((antiTimestamp >= (-toUnixTimestamp(now()))) AND (antiTimestamp <= (-toUnixTimestamp(now() - (3600 * 24))))) ORDER BY service ASC, antiTimestamp ASC LIMIT 10
[36ssds310] 2020.06.10 04:07:14.371332 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> ContextAccess (default): Access granted: SELECT(antiTimestamp, traceID, service) ON jaeger.jaeger_index_v2
[36ssds310] 2020.06.10 04:07:14.373382 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Key condition: (column 0 in ['nginx-fl', 'nginx-fl']), (column 1 in [-1591762034, +inf)), (column 1 in (-inf, -1591675634]), and, and
[36ssds310] 2020.06.10 04:07:14.373459 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): MinMax index condition: unknown, (column 0 in [-1591762034, +inf)), (column 0 in (-inf, -1591675634]), and, and
[36ssds310] 2020.06.10 04:07:22.660561 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Selected 53 parts by date, 50 parts by key, 6756938 marks to read from 50 ranges
[36ssds310] 2020.06.10 04:07:22.660811 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1300555_1300555_0, approx. 6144, up to 6144 rows starting from 3072
[36ssds310] 2020.06.10 04:07:22.660906 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1300554_1300554_0, approx. 6144, up to 6144 rows starting from 4096
[36ssds310] 2020.06.10 04:07:22.660990 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1300553_1300553_0, approx. 5120, up to 5120 rows starting from 4096
[36ssds310] 2020.06.10 04:07:22.661063 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200610_1300552_1300552_0, approx. 6144, up to 6144 rows starting from 4096
[36ssds310] 2020.06.10 04:07:22.661145 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200610_1300547_1300551_1, approx. 26624, up to 26624 rows starting from 19456
[36ssds310] 2020.06.10 04:07:22.661228 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200610_1300541_1300546_1, approx. 31744, up to 31744 rows starting from 24576
[36ssds310] 2020.06.10 04:07:22.661311 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200610_1300524_1300540_2, approx. 84992, up to 84992 rows starting from 71680
[36ssds310] 2020.06.10 04:07:22.661393 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200610_1300507_1300523_2, approx. 88064, up to 88064 rows starting from 68608
[36ssds310] 2020.06.10 04:07:22.661465 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1300436_1300506_3, approx. 359424, up to 359424 rows starting from 295936
[36ssds310] 2020.06.10 04:07:22.661559 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1300386_1300435_3, approx. 246784, up to 246784 rows starting from 214016
[36ssds310] 2020.06.10 04:07:22.661644 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1300089_1300385_4, approx. 1539072, up to 1539072 rows starting from 1189888
[36ssds310] 2020.06.10 04:07:22.661725 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200610_1300072_1300088_2, approx. 89088, up to 89088 rows starting from 68608
[36ssds310] 2020.06.10 04:07:22.661804 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200610_1300055_1300071_2, approx. 90112, up to 90112 rows starting from 66560
[36ssds310] 2020.06.10 04:07:22.661869 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1300005_1300054_3, approx. 252928, up to 252928 rows starting from 208896
[36ssds310] 2020.06.10 04:07:22.661949 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299805_1300004_4, approx. 976896, up to 976896 rows starting from 866304
[36ssds310] 2020.06.10 04:07:22.662029 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299547_1299804_4, approx. 1299456, up to 1299456 rows starting from 1076224
[36ssds310] 2020.06.10 04:07:22.662108 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299310_1299546_4, approx. 1239040, up to 1239040 rows starting from 940032
[36ssds310] 2020.06.10 04:07:22.662190 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1299122_1299309_4, approx. 952320, up to 952320 rows starting from 780288
[36ssds310] 2020.06.10 04:07:22.662269 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298940_1299121_4, approx. 903168, up to 903168 rows starting from 778240
[36ssds310] 2020.06.10 04:07:22.662339 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298881_1298939_3, approx. 289792, up to 289792 rows starting from 256000
[36ssds310] 2020.06.10 04:07:22.662418 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298776_1298880_4, approx. 500736, up to 500736 rows starting from 474112
[36ssds310] 2020.06.10 04:07:22.662503 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298726_1298775_3, approx. 260096, up to 260096 rows starting from 200704
[36ssds310] 2020.06.10 04:07:22.662584 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298501_1298725_4, approx. 1156096, up to 1156096 rows starting from 917504
[36ssds310] 2020.06.10 04:07:22.662668 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298318_1298500_4, approx. 925696, up to 925696 rows starting from 761856
[36ssds310] 2020.06.10 04:07:22.662733 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1298064_1298317_4, approx. 1274880, up to 1274880 rows starting from 1070080
[36ssds310] 2020.06.10 04:07:22.662813 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1296990_1298063_5, approx. 5525504, up to 5525504 rows starting from 4359168
[36ssds310] 2020.06.10 04:07:22.662892 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1295858_1296989_5, approx. 5734400, up to 5734400 rows starting from 4700160
[36ssds310] 2020.06.10 04:07:22.662979 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1294629_1295857_5, approx. 6031360, up to 6031360 rows starting from 5324800
[36ssds310] 2020.06.10 04:07:22.663065 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1293763_1294628_5, approx. 4402176, up to 4402176 rows starting from 3566592
[36ssds310] 2020.06.10 04:07:22.663130 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1287217_1293762_7, approx. 33751040, up to 33751040 rows starting from 26479616
[36ssds310] 2020.06.10 04:07:22.663218 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1262566_1287216_7, approx. 128343040, up to 128343040 rows starting from 98164736
[36ssds310] 2020.06.10 04:07:22.663338 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 91898880, up to 91898880 rows starting from 100039680
[36ssds310] 2020.06.10 04:07:22.663804 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1237164_1262565_7, approx. 41167872, up to 41167872 rows starting from 191938560
[36ssds310] 2020.06.10 04:07:22.663931 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1211723_1237163_7, approx. 136497152, up to 136497152 rows starting from 96418816
[36ssds310] 2020.06.10 04:07:22.664029 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1083678_1211722_14, approx. 110631936, up to 110631936 rows starting from 474645504
[36ssds310] 2020.06.10 04:07:22.664144 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1083678_1211722_14, approx. 288296960, up to 288296960 rows starting from 585277440
[36ssds310] 2020.06.10 04:07:22.664222 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200610_1083678_1211722_14, approx. 282084352, up to 282084352 rows starting from 873574400
[36ssds310] 2020.06.10 04:07:22.664299 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 5 ranges from part 20200609_1084082_1283714_1272, approx. 23552, up to 23552 rows starting from 1024
[36ssds310] 2020.06.10 04:07:22.664383 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1083773_1084080_5, approx. 478208, up to 478208 rows starting from 27648
[36ssds310] 2020.06.10 04:07:22.664463 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1083650_1083770_3, approx. 418816, up to 418816 rows starting from 151552
[36ssds310] 2020.06.10 04:07:22.664538 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1083577_1083649_3, approx. 421888, up to 421888 rows starting from 244736
[36ssds310] 2020.06.10 04:07:22.664619 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1083516_1083576_3, approx. 343040, up to 343040 rows starting from 212992
[36ssds310] 2020.06.10 04:07:22.664701 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1082407_1083515_5, approx. 4527104, up to 4527104 rows starting from 3988480
[36ssds310] 2020.06.10 04:07:22.664828 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1082407_1083515_5, approx. 1615872, up to 1615872 rows starting from 8515584
[36ssds310] 2020.06.10 04:07:22.664904 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1051256_1082406_7, approx. 169789440, up to 169789440 rows starting from 114937856
[36ssds310] 2020.06.10 04:07:22.664994 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1018668_1051255_7, approx. 116891648, up to 116891648 rows starting from 120051712
[36ssds310] 2020.06.10 04:07:22.665092 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1018668_1051255_7, approx. 61265920, up to 61265920 rows starting from 236943360
[36ssds310] 2020.06.10 04:07:22.665173 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_875175_1018667_10, approx. 227031040, up to 227031040 rows starting from 520521728
[36ssds310] 2020.06.10 04:07:22.665266 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_875175_1018667_10, approx. 288296960, up to 288296960 rows starting from 747552768
[36ssds310] 2020.06.10 04:07:22.665348 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_875175_1018667_10, approx. 278558720, up to 278558720 rows starting from 1035849728
[36ssds310] 2020.06.10 04:07:22.665432 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_824520_875174_8, approx. 9738240, up to 9738240 rows starting from 176712704
[36ssds310] 2020.06.10 04:07:22.665535 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_824520_875174_8, approx. 277860352, up to 277860352 rows starting from 186450944
[36ssds310] 2020.06.10 04:07:22.665621 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_656996_824519_8, approx. 10436608, up to 10436608 rows starting from 601774080
[36ssds310] 2020.06.10 04:07:22.665709 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_656996_824519_8, approx. 288296960, up to 288296960 rows starting from 612210688
[36ssds310] 2020.06.10 04:07:22.665787 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_656996_824519_8, approx. 288296960, up to 288296960 rows starting from 900507648
[36ssds310] 2020.06.10 04:07:22.665866 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_656996_824519_8, approx. 288296960, up to 288296960 rows starting from 1188804608
[36ssds310] 2020.06.10 04:07:22.665943 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_656996_824519_8, approx. 60943360, up to 60943360 rows starting from 1477101568
[36ssds310] 2020.06.10 04:07:22.666023 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_486578_656995_9, approx. 227353600, up to 227353600 rows starting from 627815424
[36ssds310] 2020.06.10 04:07:22.666125 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_486578_656995_9, approx. 288296960, up to 288296960 rows starting from 855169024
[36ssds310] 2020.06.10 04:07:22.666202 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_486578_656995_9, approx. 288296960, up to 288296960 rows starting from 1143465984
[36ssds310] 2020.06.10 04:07:22.666286 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_486578_656995_9, approx. 132886528, up to 132886528 rows starting from 1431762944
[36ssds310] 2020.06.10 04:07:22.666359 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_350519_486577_9, approx. 155410432, up to 155410432 rows starting from 541052928
[36ssds310] 2020.06.10 04:07:22.666456 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_350519_486577_9, approx. 288296960, up to 288296960 rows starting from 696463360
[36ssds310] 2020.06.10 04:07:22.666544 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_350519_486577_9, approx. 268983296, up to 268983296 rows starting from 984760320
[36ssds310] 2020.06.10 04:07:22.666636 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_234466_350518_8, approx. 19313664, up to 19313664 rows starting from 497026048
[36ssds310] 2020.06.10 04:07:22.666735 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_234466_350518_8, approx. 288296960, up to 288296960 rows starting from 516339712
[36ssds310] 2020.06.10 04:07:22.666811 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_234466_350518_8, approx. 273871872, up to 273871872 rows starting from 804636672
[36ssds310] 2020.06.10 04:07:22.666892 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_122523_234465_9, approx. 14425088, up to 14425088 rows starting from 484709376
[36ssds310] 2020.06.10 04:07:22.666984 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_122523_234465_9, approx. 288296960, up to 288296960 rows starting from 499134464
[36ssds310] 2020.06.10 04:07:22.667049 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_122523_234465_9, approx. 255476736, up to 255476736 rows starting from 787431424
[36ssds310] 2020.06.10 04:07:22.667140 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1_122522_9, approx. 32820224, up to 32820224 rows starting from 528824320
[36ssds310] 2020.06.10 04:07:22.667235 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1_122522_9, approx. 288296960, up to 288296960 rows starting from 561644544
[36ssds310] 2020.06.10 04:07:22.667309 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200609_1_122522_9, approx. 288274432, up to 288274432 rows starting from 849941504
[36ssds310] 2020.06.10 04:07:22.667443 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
1fd36a43b7271902
0033f08e56b858ab
0016ca40f89258c8
a62e14be43cb1c2f
dcb5819b0cc6c229
62fc4f785a0bc041
0ad90f5ca4dce48b
7d76713ce9a7dcc1
feec2152e982d327
a717c839b2d45551
[36ssds310] 2020.06.10 04:07:22.819913 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 4785 rows in 0.15 sec., 31479.36 rows/sec., 56.94 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820041 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.16 sec., 406962.66 rows/sec., 24.18 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820093 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.16 sec., 409588.23 rows/sec., 24.33 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820155 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 64512 rows in 0.16 sec., 416194.49 rows/sec., 24.33 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820166 [ 128 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 64512 rows in 0.15 sec., 418897.05 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820208 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 64512 rows in 0.16 sec., 416194.49 rows/sec., 24.33 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820274 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 64512 rows in 0.15 sec., 418897.05 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820347 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 64512 rows in 0.15 sec., 418897.05 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820420 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.15 sec., 412247.89 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820508 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.15 sec., 412247.89 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820604 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.15 sec., 412247.89 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.820668 [ 129 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 63488 rows in 0.15 sec., 412247.89 rows/sec., 24.49 MB/sec.
[36ssds310] 2020.06.10 04:07:22.825541 [ 132 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MergingSortedTransform: Merge sorted 2 blocks, 161712 rows in 0.16 sec., 998193.53 rows/sec., 53.43 MB/sec.
[36ssds310] 2020.06.10 04:07:22.829265 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Information> executeQuery: Read 4963872 rows, 161.06 MiB in 8.467 sec., 586255 rows/sec., 19.02 MiB/sec.
[36ssds310] 2020.06.10 04:07:22.829524 [ 134 ] {6f4693c7-3fd7-4533-85f8-beda82826b49} <Debug> MemoryTracker: Peak memory usage (for query): 341.98 MiB.

Both are supposed to walk the primary key in forward direction and I expect roughly the same performance. In reality there's a significant difference, which largely boils down to this:

Pretty much all the time is spent there (look at the time gaps):

[36ssds310] 2020.06.10 04:03:48.248394 [ 134 ] {8f3e3501-e069-4200-b9fd-bc54a04c6065} <Debug> executeQuery: (from 127.0.0.1:60868) SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE (service = 'nginx-fl') AND (antiTimestamp <= (-toUnixTimestamp(now() - (3600 * 24)))) AND (antiTimestamp >= (-toUnixTimestamp(now()))) ORDER BY service ASC, antiTimestamp ASC LIMIT 10
...
[36ssds310] 2020.06.10 04:03:48.253344 [ 134 ] {8f3e3501-e069-4200-b9fd-bc54a04c6065} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): MinMax index condition: unknown, (column 0 in (-inf, -1591675428]), and, (column 0 in [-1591761828, +inf)), and
[36ssds310] 2020.06.10 04:03:55.873758 [ 134 ] {8f3e3501-e069-4200-b9fd-bc54a04c6065} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Selected 47 parts by date, 44 parts by key, 6743228 marks to read from 44 ranges
...
[36ssds310] 2020.06.10 04:03:55.879881 [ 134 ] {8f3e3501-e069-4200-b9fd-bc54a04c6065} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
...
[36ssds310] 2020.06.10 04:03:56.051030 [ 134 ] {8f3e3501-e069-4200-b9fd-bc54a04c6065} <Debug> MemoryTracker: Peak memory usage (for query): 316.84 MiB.

If I trace the function:

$ docker exec -it clickhouse-jaeger objdump -T /usr/bin/clickhouse | fgrep mayBeTrueInRange
0000000009374b50 g    DF .text  000000000000001d  Base        _ZNK2DB12KeyCondition16mayBeTrueInRangeEmPKNS_8FieldRefES3_RKNSt3__16vectorINS4_10shared_ptrIKNS_9IDataTypeEEENS4_9allocatorIS9_EEEE

$ echo _ZNK2DB12KeyCondition16mayBeTrueInRangeEmPKNS_8FieldRefES3_RKNSt3__16vectorINS4_10shared_ptrIKNS_9IDataTypeEEENS4_9allocatorIS9_EEEE | c++filt
DB::KeyCondition::mayBeTrueInRange(unsigned long, DB::FieldRef const*, DB::FieldRef const*, std::__1::vector<std::__1::shared_ptr<DB::IDataType const>, std::__1::allocator<std::__1::shared_ptr<DB::IDataType const> > > const&) const

$ sudo /usr/share/bcc/tools/funccount /state/var/lib/docker/overlay2/8794eb76eb8d76868fc1602075b0d920abece7c257ece060216aeecf23d115de/merged/usr/bin/clickhouse:_ZNK2DB12KeyCondition16mayBeTrueInRangeEmPKNS_8FieldRefES3_RKNSt3__16vectorINS4_10shared_ptrIKNS_9IDataTypeEEENS4_9allocatorIS9_EEEE

I can see that for 1h query it's called 344871 times, while for 24h query it's called 8346350 times, which happens to be 24.2 times more. My understanding is that range selection from a sorted primary key should be a log2 time, not linear, as it appears to be.

I'm on Clickhouse v20.4.4.18-stable, but I'm happy to try any commit.

[bobrik]

Another question I have is whether this stage is supposed to be parallelized. From what I see it's a single thread that does the primary key mark filtering.

In addition to that I'm seeing that DB::MergeTreeDataSelectExecutor::filterMarksUsingIndex() also runs in the same thread for all parts. I'd be happier if it took advantage of many CPUs I have to throw at my problem. I can file a separate issue if this makes sense.

[alexey-milovidov]

According to log, the time is spent on analysis of minmax (partition) index: toDate(toDateTime(-antiTimestamp)), not the primary key.

But it's unclear why it takes so long.

[bobrik]

Are you sure? The way I read the code, MinMax index condition is printed after parts are known, and most of the time is spent after that, but before Selected 47 parts by date message.

MinMax message is printed here at line 539, while heavy markRangesFromPKRange is called in a loop a bit later at line 566. That loop has a comment saying:

Let's find what range to read from each part.

[alexey-milovidov]

Yes, you're right.

[bobrik]

After adding some logging, I was able to catch what looks like a pathological case:

$ echo "SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE service = 'nginx-fl' AND antiTimestamp between -toUnixTimestamp(now()) and -toUnixTimestamp(now() - 60) ORDER BY service, antiTimestamp LIMIT 20" | docker exec -i clickhouse-jaeger clickhouse-client --send_logs_level=trace --database jaeger --merge_tree_coarse_index_granularity=2
[36com10] 2020.07.04 21:08:00.061521 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> executeQuery: (from 127.0.0.1:46410) SELECT DISTINCT traceID FROM jaeger_index_v2 PREWHERE service = 'nginx-fl' AND antiTimestamp between -toUnixTimestamp(now()) and -toUnixTimestamp(now() - 60) ORDER BY service, antiTimestamp LIMIT 20
[36com10] 2020.07.04 21:08:00.062866 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> ContextAccess (default): Access granted: SELECT(antiTimestamp, traceID, service) ON jaeger.jaeger_index_v2
[36com10] 2020.07.04 21:08:00.063388 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_1_5567_8
[36com10] 2020.07.04 21:08:00.063419 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_1_5567_8 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063464 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_5568_11202_8
[36com10] 2020.07.04 21:08:00.063483 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_5568_11202_8 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063501 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_11203_16220_9
[36com10] 2020.07.04 21:08:00.063514 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_11203_16220_9 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063537 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_16221_17378_7
[36com10] 2020.07.04 21:08:00.063568 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_16221_17378_7 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063612 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_17379_17635_6
[36com10] 2020.07.04 21:08:00.063659 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_17379_17635_6 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063695 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_17636_17989_7
[36com10] 2020.07.04 21:08:00.063747 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_17636_17989_7 did not match huperrectangle
[36com10] 2020.07.04 21:08:00.063782 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_17990_20084_8
[36com10] 2020.07.04 21:08:00.063807 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_17990_20084_8 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.063831 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20085_20139_5
[36com10] 2020.07.04 21:08:00.063842 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20085_20139_5 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.063867 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20140_20229_5
[36com10] 2020.07.04 21:08:00.063902 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20140_20229_5 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.063936 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20230_20368_6
[36com10] 2020.07.04 21:08:00.063968 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20230_20368_6 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.063982 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20369_20437_5
[36com10] 2020.07.04 21:08:00.064001 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20369_20437_5 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064023 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20438_20540_6
[36com10] 2020.07.04 21:08:00.064047 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20438_20540_6 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064068 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20541_20584_5
[36com10] 2020.07.04 21:08:00.064079 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20541_20584_5 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064101 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20585_20617_4
[36com10] 2020.07.04 21:08:00.064138 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20585_20617_4 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064165 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20618_20627_2
[36com10] 2020.07.04 21:08:00.064187 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20618_20627_2 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064199 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20628_20628_0
[36com10] 2020.07.04 21:08:00.064219 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20628_20628_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064358 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20629_20629_0
[36com10] 2020.07.04 21:08:00.064412 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20629_20629_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064455 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20630_20630_0
[36com10] 2020.07.04 21:08:00.064483 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20630_20630_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064521 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20631_20631_0
[36com10] 2020.07.04 21:08:00.064563 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20631_20631_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064603 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20632_20637_1
[36com10] 2020.07.04 21:08:00.064643 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20632_20637_1 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064672 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20638_20638_0
[36com10] 2020.07.04 21:08:00.064713 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20638_20638_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064751 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20639_20639_0
[36com10] 2020.07.04 21:08:00.064811 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20639_20639_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064849 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20640_20640_0
[36com10] 2020.07.04 21:08:00.064861 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20640_20640_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064885 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20641_20641_0
[36com10] 2020.07.04 21:08:00.064932 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20641_20641_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.064977 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20642_20642_0
[36com10] 2020.07.04 21:08:00.065020 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20642_20642_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.065048 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20643_20643_0
[36com10] 2020.07.04 21:08:00.065094 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20643_20643_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.065140 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part: 20200704_20644_20644_0
[36com10] 2020.07.04 21:08:00.065183 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Part 20200704_20644_20644_0 matched hyperrectangle
[36com10] 2020.07.04 21:08:00.065251 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Key condition: (column 0 in ['nginx-fl', 'nginx-fl']), (column 1 in [-1593896880, +inf)), (column 1 in (-inf, -1593896820]), and, and
[36com10] 2020.07.04 21:08:00.065292 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): MinMax index condition: unknown, (column 0 in [-1593896880, +inf)), (column 0 in (-inf, -1593896820]), and, and
[36com10] 2020.07.04 21:08:00.065567 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_17990_20084_8 for PK ranges
[36com10] 2020.07.04 21:08:00.067943 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20085_20139_5 for PK ranges
[36com10] 2020.07.04 21:08:00.072792 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20140_20229_5 for PK ranges
[36com10] 2020.07.04 21:08:00.084825 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20230_20368_6 for PK ranges
[36com10] 2020.07.04 21:08:00.102668 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20369_20437_5 for PK ranges
[36com10] 2020.07.04 21:08:00.108647 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20438_20540_6 for PK ranges
[36com10] 2020.07.04 21:08:00.120817 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20541_20584_5 for PK ranges
[36com10] 2020.07.04 21:08:00.127033 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20585_20617_4 for PK ranges
[36com10] 2020.07.04 21:08:00.133130 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20618_20627_2 for PK ranges
[36com10] 2020.07.04 21:08:00.135465 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20628_20628_0 for PK ranges
[36com10] 2020.07.04 21:08:00.136094 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20629_20629_0 for PK ranges
[36com10] 2020.07.04 21:08:00.136694 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20630_20630_0 for PK ranges
[36com10] 2020.07.04 21:08:00.137303 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20631_20631_0 for PK ranges
[36com10] 2020.07.04 21:08:00.137914 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20632_20637_1 for PK ranges
[36com10] 2020.07.04 21:08:00.139204 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20638_20638_0 for PK ranges
[36com10] 2020.07.04 21:08:00.139807 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20639_20639_0 for PK ranges
[36com10] 2020.07.04 21:08:00.140748 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20640_20640_0 for PK ranges
[36com10] 2020.07.04 21:08:00.141630 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20641_20641_0 for PK ranges
[36com10] 2020.07.04 21:08:00.142169 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20642_20642_0 for PK ranges
[36com10] 2020.07.04 21:08:00.143052 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20643_20643_0 for PK ranges
[36com10] 2020.07.04 21:08:00.143989 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Checking part 20200704_20644_20644_0 for PK ranges
[36com10] 2020.07.04 21:08:00.144922 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> jaeger.jaeger_index_v2 (SelectExecutor): Selected 21 parts by date, 21 parts by key, 611 marks to read from 21 ranges
[36com10] 2020.07.04 21:08:00.145197 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20644_20644_0, approx. 3072 rows starting from 4096
[36com10] 2020.07.04 21:08:00.145298 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20643_20643_0, approx. 2048 rows starting from 4096
[36com10] 2020.07.04 21:08:00.145399 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20642_20642_0, approx. 3072 rows starting from 3072
[36com10] 2020.07.04 21:08:00.145501 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 1 ranges from part 20200704_20641_20641_0, approx. 1024 rows starting from 4096
[36com10] 2020.07.04 21:08:00.145595 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20640_20640_0, approx. 3072 rows starting from 3072
[36com10] 2020.07.04 21:08:00.145682 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20639_20639_0, approx. 2048 rows starting from 4096
[36com10] 2020.07.04 21:08:00.145760 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20638_20638_0, approx. 2048 rows starting from 3072
[36com10] 2020.07.04 21:08:00.145853 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200704_20632_20637_1, approx. 5120 rows starting from 20480
[36com10] 2020.07.04 21:08:00.145945 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20631_20631_0, approx. 2048 rows starting from 3072
[36com10] 2020.07.04 21:08:00.146040 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20630_20630_0, approx. 3072 rows starting from 2048
[36com10] 2020.07.04 21:08:00.146135 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 2 ranges from part 20200704_20629_20629_0, approx. 3072 rows starting from 2048
[36com10] 2020.07.04 21:08:00.146216 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 1 ranges from part 20200704_20628_20628_0, approx. 1024 rows starting from 3072
[36com10] 2020.07.04 21:08:00.146303 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 4 ranges from part 20200704_20618_20627_2, approx. 10240 rows starting from 41984
[36com10] 2020.07.04 21:08:00.146525 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 6 ranges from part 20200704_20585_20617_4, approx. 53248 rows starting from 168960
[36com10] 2020.07.04 21:08:00.146617 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 6 ranges from part 20200704_20541_20584_5, approx. 51200 rows starting from 205824
[36com10] 2020.07.04 21:08:00.146723 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200704_20438_20540_6, approx. 114688 rows starting from 516096
[36com10] 2020.07.04 21:08:00.146795 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 6 ranges from part 20200704_20369_20437_5, approx. 45056 rows starting from 231424
[36com10] 2020.07.04 21:08:00.146882 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 8 ranges from part 20200704_20230_20368_6, approx. 174080 rows starting from 628736
[36com10] 2020.07.04 21:08:00.146982 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 7 ranges from part 20200704_20140_20229_5, approx. 105472 rows starting from 449536
[36com10] 2020.07.04 21:08:00.147075 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 6 ranges from part 20200704_20085_20139_5, approx. 34816 rows starting from 253952
[36com10] 2020.07.04 21:08:00.147171 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> MergeTreeSelectProcessor: Reading 3 ranges from part 20200704_17990_20084_8, approx. 6144 rows starting from 9722880
[36com10] 2020.07.04 21:08:00.148488 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
[36com10] 2020.07.04 21:08:00.163351 [ 143 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> MergingSortedTransform: Merge sorted 1 blocks, 39037 rows in 0.015001391 sec., 2602225.3536355398 rows/sec., 137.63 MiB/sec
[36com10] 2020.07.04 21:08:00.164748 [ 142 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> MergingSortedTransform: Merge sorted 1 blocks, 27270 rows in 0.018001669 sec., 1514859.5388572025 rows/sec., 57.40 MiB/sec
[36com10] 2020.07.04 21:08:00.186389 [ 142 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> MergingSortedTransform: Merge sorted 1 blocks, 14715 rows in 0.038003524 sec., 387200.9343133548 rows/sec., 13.62 MiB/sec
6bfe06e88f566665
874e988d4ec49331
16ebb2eb12ce9653
72f5a29eac41a8b3
c2aabfe892ae6ad2
4d3728fba7a78dd3
c89143091d57a27f
001cf5e3f705f551
002a1b88a21d96a8
5dee0974f4935113
8353f89723d21dd6
a06b00ecbe356c3a
5bf3b87fe8b2ea75
bd0943cf778d79f6
03ac1ccc47f8132d
5633e74e1df057da
66922fb592da9c6c
3547217c778de695
66166d916e128c47
ecf1c62729ea6664
[36com10] 2020.07.04 21:08:00.189402 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Information> executeQuery: Read 625664 rows, 20.33 MiB in 0.127801572 sec., 4895589 rows/sec., 159.11 MiB/sec.
[36com10] 2020.07.04 21:08:00.189480 [ 85 ] {c1f655bf-661a-4be5-a15c-6e73a7ba72f4} <Debug> MemoryTracker: Peak memory usage (for query): 40.44 MiB.

Here are the exact ranges that were checked by primary key, all from the very query above:

Checking range [0 .. 20460] from part 20200704_17990_20084_8
Checking range [0 .. 10229] from part 20200704_17990_20084_8
Checking range [0 .. 5114] from part 20200704_17990_20084_8
Checking range [5114 .. 10229] from part 20200704_17990_20084_8
Checking range [5114 .. 7671] from part 20200704_17990_20084_8
Checking range [7671 .. 10229] from part 20200704_17990_20084_8
Checking range [7671 .. 8950] from part 20200704_17990_20084_8
Checking range [8950 .. 10229] from part 20200704_17990_20084_8
Checking range [8950 .. 9589] from part 20200704_17990_20084_8
Checking range [8950 .. 9269] from part 20200704_17990_20084_8
Checking range [9269 .. 9589] from part 20200704_17990_20084_8
Checking range [9269 .. 9429] from part 20200704_17990_20084_8
Checking range [9429 .. 9589] from part 20200704_17990_20084_8
Checking range [9429 .. 9509] from part 20200704_17990_20084_8
Checking range [9429 .. 9469] from part 20200704_17990_20084_8
Checking range [9469 .. 9509] from part 20200704_17990_20084_8
Checking range [9469 .. 9489] from part 20200704_17990_20084_8
Checking range [9489 .. 9509] from part 20200704_17990_20084_8
Checking range [9489 .. 9499] from part 20200704_17990_20084_8
Checking range [9489 .. 9494] from part 20200704_17990_20084_8
Checking range [9494 .. 9499] from part 20200704_17990_20084_8
Checking range [9494 .. 9496] from part 20200704_17990_20084_8
Checking range [9494 .. 9495] from part 20200704_17990_20084_8
Checking range [9495 .. 9496] from part 20200704_17990_20084_8
Checking range [9496 .. 9499] from part 20200704_17990_20084_8
Checking range [9496 .. 9497] from part 20200704_17990_20084_8
Checking range [9497 .. 9499] from part 20200704_17990_20084_8
Checking range [9497 .. 9498] from part 20200704_17990_20084_8
Checking range [9498 .. 9499] from part 20200704_17990_20084_8
Checking range [9499 .. 9509] from part 20200704_17990_20084_8
Checking range [9499 .. 9504] from part 20200704_17990_20084_8
Checking range [9499 .. 9501] from part 20200704_17990_20084_8
Checking range [9499 .. 9500] from part 20200704_17990_20084_8
Checking range [9500 .. 9501] from part 20200704_17990_20084_8
Checking range [9501 .. 9504] from part 20200704_17990_20084_8
Checking range [9504 .. 9509] from part 20200704_17990_20084_8
Checking range [9509 .. 9589] from part 20200704_17990_20084_8
Checking range [9589 .. 10229] from part 20200704_17990_20084_8
Checking range [10229 .. 20459] from part 20200704_17990_20084_8
Checking range [0 .. 539] from part 20200704_20085_20139_5
Checking range [0 .. 269] from part 20200704_20085_20139_5
Checking range [0 .. 134] from part 20200704_20085_20139_5
Checking range [134 .. 269] from part 20200704_20085_20139_5
Checking range [134 .. 201] from part 20200704_20085_20139_5
Checking range [201 .. 269] from part 20200704_20085_20139_5
Checking range [201 .. 235] from part 20200704_20085_20139_5
Checking range [235 .. 269] from part 20200704_20085_20139_5
Checking range [235 .. 252] from part 20200704_20085_20139_5
Checking range [235 .. 243] from part 20200704_20085_20139_5
Checking range [243 .. 252] from part 20200704_20085_20139_5
Checking range [243 .. 247] from part 20200704_20085_20139_5
Checking range [247 .. 252] from part 20200704_20085_20139_5
Checking range [247 .. 249] from part 20200704_20085_20139_5
Checking range [247 .. 248] from part 20200704_20085_20139_5
Checking range [248 .. 249] from part 20200704_20085_20139_5
Checking range [249 .. 252] from part 20200704_20085_20139_5
Checking range [249 .. 250] from part 20200704_20085_20139_5
Checking range [250 .. 252] from part 20200704_20085_20139_5
Checking range [250 .. 251] from part 20200704_20085_20139_5
Checking range [251 .. 252] from part 20200704_20085_20139_5
Checking range [252 .. 269] from part 20200704_20085_20139_5
Checking range [252 .. 260] from part 20200704_20085_20139_5
Checking range [252 .. 256] from part 20200704_20085_20139_5
Checking range [252 .. 254] from part 20200704_20085_20139_5
Checking range [252 .. 253] from part 20200704_20085_20139_5
Checking range [253 .. 254] from part 20200704_20085_20139_5
Checking range [254 .. 256] from part 20200704_20085_20139_5
Checking range [254 .. 255] from part 20200704_20085_20139_5
Checking range [255 .. 256] from part 20200704_20085_20139_5
Checking range [256 .. 260] from part 20200704_20085_20139_5
Checking range [256 .. 258] from part 20200704_20085_20139_5
Checking range [256 .. 257] from part 20200704_20085_20139_5
Checking range [257 .. 258] from part 20200704_20085_20139_5
Checking range [258 .. 260] from part 20200704_20085_20139_5
Checking range [258 .. 259] from part 20200704_20085_20139_5
Checking range [259 .. 260] from part 20200704_20085_20139_5
Checking range [260 .. 269] from part 20200704_20085_20139_5
Checking range [260 .. 264] from part 20200704_20085_20139_5
Checking range [260 .. 262] from part 20200704_20085_20139_5
Checking range [260 .. 261] from part 20200704_20085_20139_5
Checking range [261 .. 262] from part 20200704_20085_20139_5
Checking range [262 .. 264] from part 20200704_20085_20139_5
Checking range [262 .. 263] from part 20200704_20085_20139_5
Checking range [263 .. 264] from part 20200704_20085_20139_5
Checking range [264 .. 269] from part 20200704_20085_20139_5
Checking range [264 .. 266] from part 20200704_20085_20139_5
Checking range [264 .. 265] from part 20200704_20085_20139_5
Checking range [265 .. 266] from part 20200704_20085_20139_5
Checking range [266 .. 269] from part 20200704_20085_20139_5
Checking range [266 .. 267] from part 20200704_20085_20139_5
Checking range [267 .. 269] from part 20200704_20085_20139_5
Checking range [267 .. 268] from part 20200704_20085_20139_5
Checking range [268 .. 269] from part 20200704_20085_20139_5
Checking range [269 .. 538] from part 20200704_20085_20139_5
Checking range [269 .. 403] from part 20200704_20085_20139_5
Checking range [269 .. 336] from part 20200704_20085_20139_5
Checking range [269 .. 302] from part 20200704_20085_20139_5
Checking range [269 .. 285] from part 20200704_20085_20139_5
Checking range [269 .. 277] from part 20200704_20085_20139_5
Checking range [269 .. 273] from part 20200704_20085_20139_5
Checking range [269 .. 271] from part 20200704_20085_20139_5
Checking range [269 .. 270] from part 20200704_20085_20139_5
Checking range [270 .. 271] from part 20200704_20085_20139_5
Checking range [271 .. 273] from part 20200704_20085_20139_5
Checking range [271 .. 272] from part 20200704_20085_20139_5
Checking range [272 .. 273] from part 20200704_20085_20139_5
Checking range [273 .. 277] from part 20200704_20085_20139_5
Checking range [273 .. 275] from part 20200704_20085_20139_5
Checking range [273 .. 274] from part 20200704_20085_20139_5
Checking range [274 .. 275] from part 20200704_20085_20139_5
Checking range [275 .. 277] from part 20200704_20085_20139_5
Checking range [275 .. 276] from part 20200704_20085_20139_5
Checking range [276 .. 277] from part 20200704_20085_20139_5
Checking range [277 .. 285] from part 20200704_20085_20139_5
Checking range [277 .. 281] from part 20200704_20085_20139_5
Checking range [277 .. 279] from part 20200704_20085_20139_5
Checking range [277 .. 278] from part 20200704_20085_20139_5
Checking range [278 .. 279] from part 20200704_20085_20139_5
Checking range [279 .. 281] from part 20200704_20085_20139_5
Checking range [279 .. 280] from part 20200704_20085_20139_5
Checking range [280 .. 281] from part 20200704_20085_20139_5
Checking range [281 .. 285] from part 20200704_20085_20139_5
Checking range [281 .. 283] from part 20200704_20085_20139_5
Checking range [281 .. 282] from part 20200704_20085_20139_5
Checking range [282 .. 283] from part 20200704_20085_20139_5
Checking range [283 .. 285] from part 20200704_20085_20139_5
Checking range [285 .. 302] from part 20200704_20085_20139_5
Checking range [302 .. 336] from part 20200704_20085_20139_5
Checking range [336 .. 403] from part 20200704_20085_20139_5
Checking range [403 .. 538] from part 20200704_20085_20139_5
Checking range [0 .. 880] from part 20200704_20140_20229_5
Checking range [0 .. 439] from part 20200704_20140_20229_5
Checking range [439 .. 879] from part 20200704_20140_20229_5
Checking range [439 .. 659] from part 20200704_20140_20229_5
Checking range [439 .. 549] from part 20200704_20140_20229_5
Checking range [439 .. 494] from part 20200704_20140_20229_5
Checking range [439 .. 466] from part 20200704_20140_20229_5
Checking range [439 .. 452] from part 20200704_20140_20229_5
Checking range [439 .. 445] from part 20200704_20140_20229_5
Checking range [439 .. 442] from part 20200704_20140_20229_5
Checking range [439 .. 440] from part 20200704_20140_20229_5
Checking range [440 .. 442] from part 20200704_20140_20229_5
Checking range [440 .. 441] from part 20200704_20140_20229_5
Checking range [441 .. 442] from part 20200704_20140_20229_5
Checking range [442 .. 445] from part 20200704_20140_20229_5
Checking range [442 .. 443] from part 20200704_20140_20229_5
Checking range [443 .. 445] from part 20200704_20140_20229_5
Checking range [443 .. 444] from part 20200704_20140_20229_5
Checking range [444 .. 445] from part 20200704_20140_20229_5
Checking range [445 .. 452] from part 20200704_20140_20229_5
Checking range [445 .. 448] from part 20200704_20140_20229_5
Checking range [445 .. 446] from part 20200704_20140_20229_5
Checking range [446 .. 448] from part 20200704_20140_20229_5
Checking range [446 .. 447] from part 20200704_20140_20229_5
Checking range [447 .. 448] from part 20200704_20140_20229_5
Checking range [448 .. 452] from part 20200704_20140_20229_5
Checking range [448 .. 450] from part 20200704_20140_20229_5
Checking range [448 .. 449] from part 20200704_20140_20229_5
Checking range [449 .. 450] from part 20200704_20140_20229_5
Checking range [450 .. 452] from part 20200704_20140_20229_5
Checking range [450 .. 451] from part 20200704_20140_20229_5
Checking range [451 .. 452] from part 20200704_20140_20229_5
Checking range [452 .. 466] from part 20200704_20140_20229_5
Checking range [452 .. 459] from part 20200704_20140_20229_5
Checking range [452 .. 455] from part 20200704_20140_20229_5
Checking range [452 .. 453] from part 20200704_20140_20229_5
Checking range [453 .. 455] from part 20200704_20140_20229_5
Checking range [453 .. 454] from part 20200704_20140_20229_5
Checking range [454 .. 455] from part 20200704_20140_20229_5
Checking range [455 .. 459] from part 20200704_20140_20229_5
Checking range [455 .. 457] from part 20200704_20140_20229_5
Checking range [455 .. 456] from part 20200704_20140_20229_5
Checking range [456 .. 457] from part 20200704_20140_20229_5
Checking range [457 .. 459] from part 20200704_20140_20229_5
Checking range [457 .. 458] from part 20200704_20140_20229_5
Checking range [458 .. 459] from part 20200704_20140_20229_5
Checking range [459 .. 466] from part 20200704_20140_20229_5
Checking range [459 .. 462] from part 20200704_20140_20229_5
Checking range [459 .. 460] from part 20200704_20140_20229_5
Checking range [460 .. 462] from part 20200704_20140_20229_5
Checking range [460 .. 461] from part 20200704_20140_20229_5
Checking range [461 .. 462] from part 20200704_20140_20229_5
Checking range [462 .. 466] from part 20200704_20140_20229_5
Checking range [462 .. 464] from part 20200704_20140_20229_5
Checking range [462 .. 463] from part 20200704_20140_20229_5
Checking range [463 .. 464] from part 20200704_20140_20229_5
Checking range [464 .. 466] from part 20200704_20140_20229_5
Checking range [464 .. 465] from part 20200704_20140_20229_5
Checking range [465 .. 466] from part 20200704_20140_20229_5
Checking range [466 .. 494] from part 20200704_20140_20229_5
Checking range [466 .. 480] from part 20200704_20140_20229_5
Checking range [466 .. 473] from part 20200704_20140_20229_5
Checking range [466 .. 469] from part 20200704_20140_20229_5
Checking range [466 .. 467] from part 20200704_20140_20229_5
Checking range [467 .. 469] from part 20200704_20140_20229_5
Checking range [467 .. 468] from part 20200704_20140_20229_5
Checking range [468 .. 469] from part 20200704_20140_20229_5
Checking range [469 .. 473] from part 20200704_20140_20229_5
Checking range [469 .. 471] from part 20200704_20140_20229_5
Checking range [469 .. 470] from part 20200704_20140_20229_5
Checking range [470 .. 471] from part 20200704_20140_20229_5
Checking range [471 .. 473] from part 20200704_20140_20229_5
Checking range [471 .. 472] from part 20200704_20140_20229_5
Checking range [472 .. 473] from part 20200704_20140_20229_5
Checking range [473 .. 480] from part 20200704_20140_20229_5
Checking range [473 .. 476] from part 20200704_20140_20229_5
Checking range [473 .. 474] from part 20200704_20140_20229_5
Checking range [474 .. 476] from part 20200704_20140_20229_5
Checking range [474 .. 475] from part 20200704_20140_20229_5
Checking range [475 .. 476] from part 20200704_20140_20229_5
Checking range [476 .. 480] from part 20200704_20140_20229_5
Checking range [476 .. 478] from part 20200704_20140_20229_5
Checking range [476 .. 477] from part 20200704_20140_20229_5
Checking range [477 .. 478] from part 20200704_20140_20229_5
Checking range [478 .. 480] from part 20200704_20140_20229_5
Checking range [478 .. 479] from part 20200704_20140_20229_5
Checking range [479 .. 480] from part 20200704_20140_20229_5
Checking range [480 .. 494] from part 20200704_20140_20229_5
Checking range [480 .. 487] from part 20200704_20140_20229_5
Checking range [480 .. 483] from part 20200704_20140_20229_5
Checking range [480 .. 481] from part 20200704_20140_20229_5
Checking range [481 .. 483] from part 20200704_20140_20229_5
Checking range [481 .. 482] from part 20200704_20140_20229_5
Checking range [482 .. 483] from part 20200704_20140_20229_5
Checking range [483 .. 487] from part 20200704_20140_20229_5
Checking range [483 .. 485] from part 20200704_20140_20229_5
Checking range [483 .. 484] from part 20200704_20140_20229_5
Checking range [484 .. 485] from part 20200704_20140_20229_5
Checking range [485 .. 487] from part 20200704_20140_20229_5
Checking range [485 .. 486] from part 20200704_20140_20229_5
Checking range [486 .. 487] from part 20200704_20140_20229_5
Checking range [487 .. 494] from part 20200704_20140_20229_5
Checking range [487 .. 490] from part 20200704_20140_20229_5
Checking range [487 .. 488] from part 20200704_20140_20229_5
Checking range [488 .. 490] from part 20200704_20140_20229_5
Checking range [488 .. 489] from part 20200704_20140_20229_5
Checking range [489 .. 490] from part 20200704_20140_20229_5
Checking range [490 .. 494] from part 20200704_20140_20229_5
Checking range [490 .. 492] from part 20200704_20140_20229_5
Checking range [490 .. 491] from part 20200704_20140_20229_5
Checking range [491 .. 492] from part 20200704_20140_20229_5
Checking range [492 .. 494] from part 20200704_20140_20229_5
Checking range [492 .. 493] from part 20200704_20140_20229_5
Checking range [493 .. 494] from part 20200704_20140_20229_5
Checking range [494 .. 549] from part 20200704_20140_20229_5
Checking range [494 .. 521] from part 20200704_20140_20229_5
Checking range [494 .. 507] from part 20200704_20140_20229_5
Checking range [494 .. 500] from part 20200704_20140_20229_5
Checking range [494 .. 497] from part 20200704_20140_20229_5
Checking range [494 .. 495] from part 20200704_20140_20229_5
Checking range [495 .. 497] from part 20200704_20140_20229_5
Checking range [495 .. 496] from part 20200704_20140_20229_5
Checking range [496 .. 497] from part 20200704_20140_20229_5
Checking range [497 .. 500] from part 20200704_20140_20229_5
Checking range [497 .. 498] from part 20200704_20140_20229_5
Checking range [498 .. 500] from part 20200704_20140_20229_5
Checking range [498 .. 499] from part 20200704_20140_20229_5
Checking range [499 .. 500] from part 20200704_20140_20229_5
Checking range [500 .. 507] from part 20200704_20140_20229_5
Checking range [500 .. 503] from part 20200704_20140_20229_5
Checking range [500 .. 501] from part 20200704_20140_20229_5
Checking range [501 .. 503] from part 20200704_20140_20229_5
Checking range [501 .. 502] from part 20200704_20140_20229_5
Checking range [502 .. 503] from part 20200704_20140_20229_5
Checking range [503 .. 507] from part 20200704_20140_20229_5
Checking range [503 .. 505] from part 20200704_20140_20229_5
Checking range [503 .. 504] from part 20200704_20140_20229_5
Checking range [504 .. 505] from part 20200704_20140_20229_5
Checking range [505 .. 507] from part 20200704_20140_20229_5
Checking range [505 .. 506] from part 20200704_20140_20229_5
Checking range [506 .. 507] from part 20200704_20140_20229_5
Checking range [507 .. 521] from part 20200704_20140_20229_5
Checking range [507 .. 514] from part 20200704_20140_20229_5
Checking range [507 .. 510] from part 20200704_20140_20229_5
Checking range [507 .. 508] from part 20200704_20140_20229_5
Checking range [508 .. 510] from part 20200704_20140_20229_5
Checking range [508 .. 509] from part 20200704_20140_20229_5
Checking range [509 .. 510] from part 20200704_20140_20229_5
Checking range [510 .. 514] from part 20200704_20140_20229_5
Checking range [510 .. 512] from part 20200704_20140_20229_5
Checking range [510 .. 511] from part 20200704_20140_20229_5
Checking range [511 .. 512] from part 20200704_20140_20229_5
Checking range [512 .. 514] from part 20200704_20140_20229_5
Checking range [512 .. 513] from part 20200704_20140_20229_5
Checking range [513 .. 514] from part 20200704_20140_20229_5
Checking range [514 .. 521] from part 20200704_20140_20229_5
Checking range [514 .. 517] from part 20200704_20140_20229_5
Checking range [514 .. 515] from part 20200704_20140_20229_5
Checking range [515 .. 517] from part 20200704_20140_20229_5
Checking range [515 .. 516] from part 20200704_20140_20229_5
Checking range [516 .. 517] from part 20200704_20140_20229_5
Checking range [517 .. 521] from part 20200704_20140_20229_5
Checking range [517 .. 519] from part 20200704_20140_20229_5
Checking range [517 .. 518] from part 20200704_20140_20229_5
Checking range [518 .. 519] from part 20200704_20140_20229_5
Checking range [519 .. 521] from part 20200704_20140_20229_5
Checking range [519 .. 520] from part 20200704_20140_20229_5
Checking range [520 .. 521] from part 20200704_20140_20229_5
Checking range [521 .. 549] from part 20200704_20140_20229_5
Checking range [521 .. 535] from part 20200704_20140_20229_5
Checking range [521 .. 528] from part 20200704_20140_20229_5
Checking range [521 .. 524] from part 20200704_20140_20229_5
Checking range [521 .. 522] from part 20200704_20140_20229_5
Checking range [522 .. 524] from part 20200704_20140_20229_5
Checking range [522 .. 523] from part 20200704_20140_20229_5
Checking range [523 .. 524] from part 20200704_20140_20229_5
Checking range [524 .. 528] from part 20200704_20140_20229_5
Checking range [524 .. 526] from part 20200704_20140_20229_5
Checking range [524 .. 525] from part 20200704_20140_20229_5
Checking range [525 .. 526] from part 20200704_20140_20229_5
Checking range [526 .. 528] from part 20200704_20140_20229_5
Checking range [526 .. 527] from part 20200704_20140_20229_5
Checking range [527 .. 528] from part 20200704_20140_20229_5
Checking range [528 .. 535] from part 20200704_20140_20229_5
Checking range [528 .. 531] from part 20200704_20140_20229_5
Checking range [528 .. 529] from part 20200704_20140_20229_5
Checking range [529 .. 531] from part 20200704_20140_20229_5
Checking range [529 .. 530] from part 20200704_20140_20229_5
Checking range [530 .. 531] from part 20200704_20140_20229_5
Checking range [531 .. 535] from part 20200704_20140_20229_5
Checking range [531 .. 533] from part 20200704_20140_20229_5
Checking range [531 .. 532] from part 20200704_20140_20229_5
Checking range [532 .. 533] from part 20200704_20140_20229_5
Checking range [533 .. 535] from part 20200704_20140_20229_5
Checking range [533 .. 534] from part 20200704_20140_20229_5
Checking range [534 .. 535] from part 20200704_20140_20229_5
Checking range [535 .. 549] from part 20200704_20140_20229_5
Checking range [535 .. 542] from part 20200704_20140_20229_5
Checking range [535 .. 538] from part 20200704_20140_20229_5
Checking range [535 .. 536] from part 20200704_20140_20229_5
Checking range [536 .. 538] from part 20200704_20140_20229_5
Checking range [536 .. 537] from part 20200704_20140_20229_5
Checking range [537 .. 538] from part 20200704_20140_20229_5
Checking range [538 .. 542] from part 20200704_20140_20229_5
Checking range [538 .. 540] from part 20200704_20140_20229_5
Checking range [538 .. 539] from part 20200704_20140_20229_5
Checking range [539 .. 540] from part 20200704_20140_20229_5
Checking range [540 .. 542] from part 20200704_20140_20229_5
Checking range [540 .. 541] from part 20200704_20140_20229_5
Checking range [541 .. 542] from part 20200704_20140_20229_5
Checking range [542 .. 549] from part 20200704_20140_20229_5
Checking range [549 .. 659] from part 20200704_20140_20229_5
Checking range [659 .. 879] from part 20200704_20140_20229_5
Checking range [0 .. 1359] from part 20200704_20230_20368_6
Checking range [0 .. 679] from part 20200704_20230_20368_6
Checking range [0 .. 339] from part 20200704_20230_20368_6
Checking range [339 .. 679] from part 20200704_20230_20368_6
Checking range [339 .. 509] from part 20200704_20230_20368_6
Checking range [509 .. 679] from part 20200704_20230_20368_6
Checking range [509 .. 594] from part 20200704_20230_20368_6
Checking range [594 .. 679] from part 20200704_20230_20368_6
Checking range [594 .. 636] from part 20200704_20230_20368_6
Checking range [594 .. 615] from part 20200704_20230_20368_6
Checking range [594 .. 604] from part 20200704_20230_20368_6
Checking range [604 .. 615] from part 20200704_20230_20368_6
Checking range [604 .. 609] from part 20200704_20230_20368_6
Checking range [609 .. 615] from part 20200704_20230_20368_6
Checking range [609 .. 612] from part 20200704_20230_20368_6
Checking range [612 .. 615] from part 20200704_20230_20368_6
Checking range [612 .. 613] from part 20200704_20230_20368_6
Checking range [613 .. 615] from part 20200704_20230_20368_6
Checking range [613 .. 614] from part 20200704_20230_20368_6
Checking range [614 .. 615] from part 20200704_20230_20368_6
Checking range [615 .. 636] from part 20200704_20230_20368_6
Checking range [615 .. 625] from part 20200704_20230_20368_6
Checking range [615 .. 620] from part 20200704_20230_20368_6
Checking range [615 .. 617] from part 20200704_20230_20368_6
Checking range [615 .. 616] from part 20200704_20230_20368_6
Checking range [616 .. 617] from part 20200704_20230_20368_6
Checking range [617 .. 620] from part 20200704_20230_20368_6
Checking range [617 .. 618] from part 20200704_20230_20368_6
Checking range [618 .. 620] from part 20200704_20230_20368_6
Checking range [618 .. 619] from part 20200704_20230_20368_6
Checking range [619 .. 620] from part 20200704_20230_20368_6
Checking range [620 .. 625] from part 20200704_20230_20368_6
Checking range [620 .. 622] from part 20200704_20230_20368_6
Checking range [620 .. 621] from part 20200704_20230_20368_6
Checking range [621 .. 622] from part 20200704_20230_20368_6
Checking range [622 .. 625] from part 20200704_20230_20368_6
Checking range [622 .. 623] from part 20200704_20230_20368_6
Checking range [623 .. 625] from part 20200704_20230_20368_6
Checking range [623 .. 624] from part 20200704_20230_20368_6
Checking range [624 .. 625] from part 20200704_20230_20368_6
Checking range [625 .. 636] from part 20200704_20230_20368_6
Checking range [625 .. 630] from part 20200704_20230_20368_6
Checking range [625 .. 627] from part 20200704_20230_20368_6
Checking range [625 .. 626] from part 20200704_20230_20368_6
Checking range [626 .. 627] from part 20200704_20230_20368_6
Checking range [627 .. 630] from part 20200704_20230_20368_6
Checking range [627 .. 628] from part 20200704_20230_20368_6
Checking range [628 .. 630] from part 20200704_20230_20368_6
Checking range [628 .. 629] from part 20200704_20230_20368_6
Checking range [629 .. 630] from part 20200704_20230_20368_6
Checking range [630 .. 636] from part 20200704_20230_20368_6
Checking range [630 .. 633] from part 20200704_20230_20368_6
Checking range [630 .. 631] from part 20200704_20230_20368_6
Checking range [631 .. 633] from part 20200704_20230_20368_6
Checking range [631 .. 632] from part 20200704_20230_20368_6
Checking range [632 .. 633] from part 20200704_20230_20368_6
Checking range [633 .. 636] from part 20200704_20230_20368_6
Checking range [633 .. 634] from part 20200704_20230_20368_6
Checking range [634 .. 636] from part 20200704_20230_20368_6
Checking range [634 .. 635] from part 20200704_20230_20368_6
Checking range [635 .. 636] from part 20200704_20230_20368_6
Checking range [636 .. 679] from part 20200704_20230_20368_6
Checking range [636 .. 657] from part 20200704_20230_20368_6
Checking range [636 .. 646] from part 20200704_20230_20368_6
Checking range [636 .. 641] from part 20200704_20230_20368_6
Checking range [636 .. 638] from part 20200704_20230_20368_6
Checking range [636 .. 637] from part 20200704_20230_20368_6
Checking range [637 .. 638] from part 20200704_20230_20368_6
Checking range [638 .. 641] from part 20200704_20230_20368_6
Checking range [638 .. 639] from part 20200704_20230_20368_6
Checking range [639 .. 641] from part 20200704_20230_20368_6
Checking range [639 .. 640] from part 20200704_20230_20368_6
Checking range [640 .. 641] from part 20200704_20230_20368_6
Checking range [641 .. 646] from part 20200704_20230_20368_6
Checking range [641 .. 643] from part 20200704_20230_20368_6
Checking range [641 .. 642] from part 20200704_20230_20368_6
Checking range [642 .. 643] from part 20200704_20230_20368_6
Checking range [643 .. 646] from part 20200704_20230_20368_6
Checking range [643 .. 644] from part 20200704_20230_20368_6
Checking range [644 .. 646] from part 20200704_20230_20368_6
Checking range [644 .. 645] from part 20200704_20230_20368_6
Checking range [645 .. 646] from part 20200704_20230_20368_6
Checking range [646 .. 657] from part 20200704_20230_20368_6
Checking range [646 .. 651] from part 20200704_20230_20368_6
Checking range [646 .. 648] from part 20200704_20230_20368_6
Checking range [646 .. 647] from part 20200704_20230_20368_6
Checking range [647 .. 648] from part 20200704_20230_20368_6
Checking range [648 .. 651] from part 20200704_20230_20368_6
Checking range [648 .. 649] from part 20200704_20230_20368_6
Checking range [649 .. 651] from part 20200704_20230_20368_6
Checking range [649 .. 650] from part 20200704_20230_20368_6
Checking range [650 .. 651] from part 20200704_20230_20368_6
Checking range [651 .. 657] from part 20200704_20230_20368_6
Checking range [651 .. 654] from part 20200704_20230_20368_6
Checking range [651 .. 652] from part 20200704_20230_20368_6
Checking range [652 .. 654] from part 20200704_20230_20368_6
Checking range [652 .. 653] from part 20200704_20230_20368_6
Checking range [653 .. 654] from part 20200704_20230_20368_6
Checking range [654 .. 657] from part 20200704_20230_20368_6
Checking range [654 .. 655] from part 20200704_20230_20368_6
Checking range [655 .. 657] from part 20200704_20230_20368_6
Checking range [655 .. 656] from part 20200704_20230_20368_6
Checking range [656 .. 657] from part 20200704_20230_20368_6
Checking range [657 .. 679] from part 20200704_20230_20368_6
Checking range [657 .. 668] from part 20200704_20230_20368_6
Checking range [657 .. 662] from part 20200704_20230_20368_6
Checking range [657 .. 659] from part 20200704_20230_20368_6
Checking range [657 .. 658] from part 20200704_20230_20368_6
Checking range [658 .. 659] from part 20200704_20230_20368_6
Checking range [659 .. 662] from part 20200704_20230_20368_6
Checking range [659 .. 660] from part 20200704_20230_20368_6
Checking range [660 .. 662] from part 20200704_20230_20368_6
Checking range [660 .. 661] from part 20200704_20230_20368_6
Checking range [661 .. 662] from part 20200704_20230_20368_6
Checking range [662 .. 668] from part 20200704_20230_20368_6
Checking range [662 .. 665] from part 20200704_20230_20368_6
Checking range [662 .. 663] from part 20200704_20230_20368_6
Checking range [663 .. 665] from part 20200704_20230_20368_6
Checking range [663 .. 664] from part 20200704_20230_20368_6
Checking range [664 .. 665] from part 20200704_20230_20368_6
Checking range [665 .. 668] from part 20200704_20230_20368_6
Checking range [665 .. 666] from part 20200704_20230_20368_6
Checking range [666 .. 668] from part 20200704_20230_20368_6
Checking range [666 .. 667] from part 20200704_20230_20368_6
Checking range [667 .. 668] from part 20200704_20230_20368_6
Checking range [668 .. 679] from part 20200704_20230_20368_6
Checking range [668 .. 673] from part 20200704_20230_20368_6
Checking range [668 .. 670] from part 20200704_20230_20368_6
Checking range [668 .. 669] from part 20200704_20230_20368_6
Checking range [669 .. 670] from part 20200704_20230_20368_6
Checking range [670 .. 673] from part 20200704_20230_20368_6
Checking range [670 .. 671] from part 20200704_20230_20368_6
Checking range [671 .. 673] from part 20200704_20230_20368_6
Checking range [671 .. 672] from part 20200704_20230_20368_6
Checking range [672 .. 673] from part 20200704_20230_20368_6
Checking range [673 .. 679] from part 20200704_20230_20368_6
Checking range [673 .. 676] from part 20200704_20230_20368_6
Checking range [673 .. 674] from part 20200704_20230_20368_6
Checking range [674 .. 676] from part 20200704_20230_20368_6
Checking range [674 .. 675] from part 20200704_20230_20368_6
Checking range [675 .. 676] from part 20200704_20230_20368_6
Checking range [676 .. 679] from part 20200704_20230_20368_6
Checking range [676 .. 677] from part 20200704_20230_20368_6
Checking range [677 .. 679] from part 20200704_20230_20368_6
Checking range [677 .. 678] from part 20200704_20230_20368_6
Checking range [678 .. 679] from part 20200704_20230_20368_6
Checking range [679 .. 1358] from part 20200704_20230_20368_6
Checking range [679 .. 1018] from part 20200704_20230_20368_6
Checking range [679 .. 848] from part 20200704_20230_20368_6
Checking range [679 .. 763] from part 20200704_20230_20368_6
Checking range [679 .. 721] from part 20200704_20230_20368_6
Checking range [679 .. 700] from part 20200704_20230_20368_6
Checking range [679 .. 689] from part 20200704_20230_20368_6
Checking range [679 .. 684] from part 20200704_20230_20368_6
Checking range [679 .. 681] from part 20200704_20230_20368_6
Checking range [679 .. 680] from part 20200704_20230_20368_6
Checking range [680 .. 681] from part 20200704_20230_20368_6
Checking range [681 .. 684] from part 20200704_20230_20368_6
Checking range [681 .. 682] from part 20200704_20230_20368_6
Checking range [682 .. 684] from part 20200704_20230_20368_6
Checking range [682 .. 683] from part 20200704_20230_20368_6
Checking range [683 .. 684] from part 20200704_20230_20368_6
Checking range [684 .. 689] from part 20200704_20230_20368_6
Checking range [684 .. 686] from part 20200704_20230_20368_6
Checking range [684 .. 685] from part 20200704_20230_20368_6
Checking range [685 .. 686] from part 20200704_20230_20368_6
Checking range [686 .. 689] from part 20200704_20230_20368_6
Checking range [686 .. 687] from part 20200704_20230_20368_6
Checking range [687 .. 689] from part 20200704_20230_20368_6
Checking range [687 .. 688] from part 20200704_20230_20368_6
Checking range [688 .. 689] from part 20200704_20230_20368_6
Checking range [689 .. 700] from part 20200704_20230_20368_6
Checking range [689 .. 694] from part 20200704_20230_20368_6
Checking range [689 .. 691] from part 20200704_20230_20368_6
Checking range [689 .. 690] from part 20200704_20230_20368_6
Checking range [690 .. 691] from part 20200704_20230_20368_6
Checking range [691 .. 694] from part 20200704_20230_20368_6
Checking range [691 .. 692] from part 20200704_20230_20368_6
Checking range [692 .. 694] from part 20200704_20230_20368_6
Checking range [692 .. 693] from part 20200704_20230_20368_6
Checking range [693 .. 694] from part 20200704_20230_20368_6
Checking range [694 .. 700] from part 20200704_20230_20368_6
Checking range [694 .. 697] from part 20200704_20230_20368_6
Checking range [694 .. 695] from part 20200704_20230_20368_6
Checking range [695 .. 697] from part 20200704_20230_20368_6
Checking range [695 .. 696] from part 20200704_20230_20368_6
Checking range [696 .. 697] from part 20200704_20230_20368_6
Checking range [697 .. 700] from part 20200704_20230_20368_6
Checking range [697 .. 698] from part 20200704_20230_20368_6
Checking range [698 .. 700] from part 20200704_20230_20368_6
Checking range [698 .. 699] from part 20200704_20230_20368_6
Checking range [699 .. 700] from part 20200704_20230_20368_6
Checking range [700 .. 721] from part 20200704_20230_20368_6
Checking range [700 .. 710] from part 20200704_20230_20368_6
Checking range [700 .. 705] from part 20200704_20230_20368_6
Checking range [700 .. 702] from part 20200704_20230_20368_6
Checking range [700 .. 701] from part 20200704_20230_20368_6
Checking range [701 .. 702] from part 20200704_20230_20368_6
Checking range [702 .. 705] from part 20200704_20230_20368_6
Checking range [702 .. 703] from part 20200704_20230_20368_6
Checking range [703 .. 705] from part 20200704_20230_20368_6
Checking range [703 .. 704] from part 20200704_20230_20368_6
Checking range [704 .. 705] from part 20200704_20230_20368_6
Checking range [705 .. 710] from part 20200704_20230_20368_6
Checking range [705 .. 707] from part 20200704_20230_20368_6
Checking range [705 .. 706] from part 20200704_20230_20368_6
Checking range [706 .. 707] from part 20200704_20230_20368_6
Checking range [707 .. 710] from part 20200704_20230_20368_6
Checking range [707 .. 708] from part 20200704_20230_20368_6
Checking range [708 .. 710] from part 20200704_20230_20368_6
Checking range [708 .. 709] from part 20200704_20230_20368_6
Checking range [709 .. 710] from part 20200704_20230_20368_6
Checking range [710 .. 721] from part 20200704_20230_20368_6
Checking range [710 .. 715] from part 20200704_20230_20368_6
Checking range [710 .. 712] from part 20200704_20230_20368_6
Checking range [710 .. 711] from part 20200704_20230_20368_6
Checking range [711 .. 712] from part 20200704_20230_20368_6
Checking range [712 .. 715] from part 20200704_20230_20368_6
Checking range [712 .. 713] from part 20200704_20230_20368_6
Checking range [713 .. 715] from part 20200704_20230_20368_6
Checking range [713 .. 714] from part 20200704_20230_20368_6
Checking range [714 .. 715] from part 20200704_20230_20368_6
Checking range [715 .. 721] from part 20200704_20230_20368_6
Checking range [715 .. 718] from part 20200704_20230_20368_6
Checking range [715 .. 716] from part 20200704_20230_20368_6
Checking range [716 .. 718] from part 20200704_20230_20368_6
Checking range [716 .. 717] from part 20200704_20230_20368_6
Checking range [717 .. 718] from part 20200704_20230_20368_6
Checking range [718 .. 721] from part 20200704_20230_20368_6
Checking range [718 .. 719] from part 20200704_20230_20368_6
Checking range [719 .. 721] from part 20200704_20230_20368_6
Checking range [719 .. 720] from part 20200704_20230_20368_6
Checking range [720 .. 721] from part 20200704_20230_20368_6
Checking range [721 .. 763] from part 20200704_20230_20368_6
Checking range [721 .. 742] from part 20200704_20230_20368_6
Checking range [721 .. 731] from part 20200704_20230_20368_6
Checking range [721 .. 726] from part 20200704_20230_20368_6
Checking range [721 .. 723] from part 20200704_20230_20368_6
Checking range [721 .. 722] from part 20200704_20230_20368_6
Checking range [722 .. 723] from part 20200704_20230_20368_6
Checking range [723 .. 726] from part 20200704_20230_20368_6
Checking range [723 .. 724] from part 20200704_20230_20368_6
Checking range [724 .. 726] from part 20200704_20230_20368_6
Checking range [724 .. 725] from part 20200704_20230_20368_6
Checking range [725 .. 726] from part 20200704_20230_20368_6
Checking range [726 .. 731] from part 20200704_20230_20368_6
Checking range [726 .. 728] from part 20200704_20230_20368_6
Checking range [726 .. 727] from part 20200704_20230_20368_6
Checking range [727 .. 728] from part 20200704_20230_20368_6
Checking range [728 .. 731] from part 20200704_20230_20368_6
Checking range [728 .. 729] from part 20200704_20230_20368_6
Checking range [729 .. 731] from part 20200704_20230_20368_6
Checking range [729 .. 730] from part 20200704_20230_20368_6
Checking range [730 .. 731] from part 20200704_20230_20368_6
Checking range [731 .. 742] from part 20200704_20230_20368_6
Checking range [731 .. 736] from part 20200704_20230_20368_6
Checking range [731 .. 733] from part 20200704_20230_20368_6
Checking range [731 .. 732] from part 20200704_20230_20368_6
Checking range [732 .. 733] from part 20200704_20230_20368_6
Checking range [733 .. 736] from part 20200704_20230_20368_6
Checking range [733 .. 734] from part 20200704_20230_20368_6
Checking range [734 .. 736] from part 20200704_20230_20368_6
Checking range [734 .. 735] from part 20200704_20230_20368_6
Checking range [735 .. 736] from part 20200704_20230_20368_6
Checking range [736 .. 742] from part 20200704_20230_20368_6
Checking range [736 .. 739] from part 20200704_20230_20368_6
Checking range [736 .. 737] from part 20200704_20230_20368_6
Checking range [737 .. 739] from part 20200704_20230_20368_6
Checking range [737 .. 738] from part 20200704_20230_20368_6
Checking range [738 .. 739] from part 20200704_20230_20368_6
Checking range [739 .. 742] from part 20200704_20230_20368_6
Checking range [739 .. 740] from part 20200704_20230_20368_6
Checking range [740 .. 742] from part 20200704_20230_20368_6
Checking range [740 .. 741] from part 20200704_20230_20368_6
Checking range [741 .. 742] from part 20200704_20230_20368_6
Checking range [742 .. 763] from part 20200704_20230_20368_6
Checking range [742 .. 752] from part 20200704_20230_20368_6
Checking range [742 .. 747] from part 20200704_20230_20368_6
Checking range [742 .. 744] from part 20200704_20230_20368_6
Checking range [742 .. 743] from part 20200704_20230_20368_6
Checking range [743 .. 744] from part 20200704_20230_20368_6
Checking range [744 .. 747] from part 20200704_20230_20368_6
Checking range [744 .. 745] from part 20200704_20230_20368_6
Checking range [745 .. 747] from part 20200704_20230_20368_6
Checking range [745 .. 746] from part 20200704_20230_20368_6
Checking range [746 .. 747] from part 20200704_20230_20368_6
Checking range [747 .. 752] from part 20200704_20230_20368_6
Checking range [747 .. 749] from part 20200704_20230_20368_6
Checking range [747 .. 748] from part 20200704_20230_20368_6
Checking range [748 .. 749] from part 20200704_20230_20368_6
Checking range [749 .. 752] from part 20200704_20230_20368_6
Checking range [749 .. 750] from part 20200704_20230_20368_6
Checking range [750 .. 752] from part 20200704_20230_20368_6
Checking range [750 .. 751] from part 20200704_20230_20368_6
Checking range [751 .. 752] from part 20200704_20230_20368_6
Checking range [752 .. 763] from part 20200704_20230_20368_6
Checking range [752 .. 757] from part 20200704_20230_20368_6
Checking range [752 .. 754] from part 20200704_20230_20368_6
Checking range [752 .. 753] from part 20200704_20230_20368_6
Checking range [753 .. 754] from part 20200704_20230_20368_6
Checking range [754 .. 757] from part 20200704_20230_20368_6
Checking range [754 .. 755] from part 20200704_20230_20368_6
Checking range [755 .. 757] from part 20200704_20230_20368_6
Checking range [755 .. 756] from part 20200704_20230_20368_6
Checking range [756 .. 757] from part 20200704_20230_20368_6
Checking range [757 .. 763] from part 20200704_20230_20368_6
Checking range [757 .. 760] from part 20200704_20230_20368_6
Checking range [757 .. 758] from part 20200704_20230_20368_6
Checking range [758 .. 760] from part 20200704_20230_20368_6
Checking range [758 .. 759] from part 20200704_20230_20368_6
Checking range [759 .. 760] from part 20200704_20230_20368_6
Checking range [760 .. 763] from part 20200704_20230_20368_6
Checking range [760 .. 761] from part 20200704_20230_20368_6
Checking range [761 .. 763] from part 20200704_20230_20368_6
Checking range [761 .. 762] from part 20200704_20230_20368_6
Checking range [762 .. 763] from part 20200704_20230_20368_6
Checking range [763 .. 848] from part 20200704_20230_20368_6
Checking range [763 .. 805] from part 20200704_20230_20368_6
Checking range [763 .. 784] from part 20200704_20230_20368_6
Checking range [763 .. 773] from part 20200704_20230_20368_6
Checking range [763 .. 768] from part 20200704_20230_20368_6
Checking range [763 .. 765] from part 20200704_20230_20368_6
Checking range [763 .. 764] from part 20200704_20230_20368_6
Checking range [764 .. 765] from part 20200704_20230_20368_6
Checking range [765 .. 768] from part 20200704_20230_20368_6
Checking range [765 .. 766] from part 20200704_20230_20368_6
Checking range [766 .. 768] from part 20200704_20230_20368_6
Checking range [766 .. 767] from part 20200704_20230_20368_6
Checking range [767 .. 768] from part 20200704_20230_20368_6
Checking range [768 .. 773] from part 20200704_20230_20368_6
Checking range [768 .. 770] from part 20200704_20230_20368_6
Checking range [768 .. 769] from part 20200704_20230_20368_6
Checking range [769 .. 770] from part 20200704_20230_20368_6
Checking range [770 .. 773] from part 20200704_20230_20368_6
Checking range [770 .. 771] from part 20200704_20230_20368_6
Checking range [771 .. 773] from part 20200704_20230_20368_6
Checking range [771 .. 772] from part 20200704_20230_20368_6
Checking range [772 .. 773] from part 20200704_20230_20368_6
Checking range [773 .. 784] from part 20200704_20230_20368_6
Checking range [773 .. 778] from part 20200704_20230_20368_6
Checking range [773 .. 775] from part 20200704_20230_20368_6
Checking range [773 .. 774] from part 20200704_20230_20368_6
Checking range [774 .. 775] from part 20200704_20230_20368_6
Checking range [775 .. 778] from part 20200704_20230_20368_6
Checking range [775 .. 776] from part 20200704_20230_20368_6
Checking range [776 .. 778] from part 20200704_20230_20368_6
Checking range [776 .. 777] from part 20200704_20230_20368_6
Checking range [777 .. 778] from part 20200704_20230_20368_6
Checking range [778 .. 784] from part 20200704_20230_20368_6
Checking range [778 .. 781] from part 20200704_20230_20368_6
Checking range [778 .. 779] from part 20200704_20230_20368_6
Checking range [779 .. 781] from part 20200704_20230_20368_6
Checking range [779 .. 780] from part 20200704_20230_20368_6
Checking range [780 .. 781] from part 20200704_20230_20368_6
Checking range [781 .. 784] from part 20200704_20230_20368_6
Checking range [781 .. 782] from part 20200704_20230_20368_6
Checking range [782 .. 784] from part 20200704_20230_20368_6
Checking range [782 .. 783] from part 20200704_20230_20368_6
Checking range [783 .. 784] from part 20200704_20230_20368_6
Checking range [784 .. 805] from part 20200704_20230_20368_6
Checking range [805 .. 848] from part 20200704_20230_20368_6
Checking range [848 .. 1018] from part 20200704_20230_20368_6
Checking range [1018 .. 1358] from part 20200704_20230_20368_6
Checking range [0 .. 675] from part 20200704_20369_20437_5
Checking range [0 .. 337] from part 20200704_20369_20437_5
Checking range [0 .. 168] from part 20200704_20369_20437_5
Checking range [168 .. 337] from part 20200704_20369_20437_5
Checking range [168 .. 252] from part 20200704_20369_20437_5
Checking range [168 .. 210] from part 20200704_20369_20437_5
Checking range [210 .. 252] from part 20200704_20369_20437_5
Checking range [210 .. 231] from part 20200704_20369_20437_5
Checking range [210 .. 220] from part 20200704_20369_20437_5
Checking range [220 .. 231] from part 20200704_20369_20437_5
Checking range [220 .. 225] from part 20200704_20369_20437_5
Checking range [225 .. 231] from part 20200704_20369_20437_5
Checking range [225 .. 228] from part 20200704_20369_20437_5
Checking range [225 .. 226] from part 20200704_20369_20437_5
Checking range [226 .. 228] from part 20200704_20369_20437_5
Checking range [226 .. 227] from part 20200704_20369_20437_5
Checking range [227 .. 228] from part 20200704_20369_20437_5
Checking range [228 .. 231] from part 20200704_20369_20437_5
Checking range [228 .. 229] from part 20200704_20369_20437_5
Checking range [229 .. 231] from part 20200704_20369_20437_5
Checking range [229 .. 230] from part 20200704_20369_20437_5
Checking range [230 .. 231] from part 20200704_20369_20437_5
Checking range [231 .. 252] from part 20200704_20369_20437_5
Checking range [231 .. 241] from part 20200704_20369_20437_5
Checking range [231 .. 236] from part 20200704_20369_20437_5
Checking range [231 .. 233] from part 20200704_20369_20437_5
Checking range [231 .. 232] from part 20200704_20369_20437_5
Checking range [232 .. 233] from part 20200704_20369_20437_5
Checking range [233 .. 236] from part 20200704_20369_20437_5
Checking range [233 .. 234] from part 20200704_20369_20437_5
Checking range [234 .. 236] from part 20200704_20369_20437_5
Checking range [234 .. 235] from part 20200704_20369_20437_5
Checking range [235 .. 236] from part 20200704_20369_20437_5
Checking range [236 .. 241] from part 20200704_20369_20437_5
Checking range [236 .. 238] from part 20200704_20369_20437_5
Checking range [236 .. 237] from part 20200704_20369_20437_5
Checking range [237 .. 238] from part 20200704_20369_20437_5
Checking range [238 .. 241] from part 20200704_20369_20437_5
Checking range [238 .. 239] from part 20200704_20369_20437_5
Checking range [239 .. 241] from part 20200704_20369_20437_5
Checking range [239 .. 240] from part 20200704_20369_20437_5
Checking range [240 .. 241] from part 20200704_20369_20437_5
Checking range [241 .. 252] from part 20200704_20369_20437_5
Checking range [241 .. 246] from part 20200704_20369_20437_5
Checking range [241 .. 243] from part 20200704_20369_20437_5
Checking range [241 .. 242] from part 20200704_20369_20437_5
Checking range [242 .. 243] from part 20200704_20369_20437_5
Checking range [243 .. 246] from part 20200704_20369_20437_5
Checking range [243 .. 244] from part 20200704_20369_20437_5
Checking range [244 .. 246] from part 20200704_20369_20437_5
Checking range [244 .. 245] from part 20200704_20369_20437_5
Checking range [245 .. 246] from part 20200704_20369_20437_5
Checking range [246 .. 252] from part 20200704_20369_20437_5
Checking range [246 .. 249] from part 20200704_20369_20437_5
Checking range [246 .. 247] from part 20200704_20369_20437_5
Checking range [247 .. 249] from part 20200704_20369_20437_5
Checking range [247 .. 248] from part 20200704_20369_20437_5
Checking range [248 .. 249] from part 20200704_20369_20437_5
Checking range [249 .. 252] from part 20200704_20369_20437_5
Checking range [249 .. 250] from part 20200704_20369_20437_5
Checking range [250 .. 252] from part 20200704_20369_20437_5
Checking range [250 .. 251] from part 20200704_20369_20437_5
Checking range [251 .. 252] from part 20200704_20369_20437_5
Checking range [252 .. 337] from part 20200704_20369_20437_5
Checking range [252 .. 294] from part 20200704_20369_20437_5
Checking range [252 .. 273] from part 20200704_20369_20437_5
Checking range [252 .. 262] from part 20200704_20369_20437_5
Checking range [252 .. 257] from part 20200704_20369_20437_5
Checking range [252 .. 254] from part 20200704_20369_20437_5
Checking range [252 .. 253] from part 20200704_20369_20437_5
Checking range [253 .. 254] from part 20200704_20369_20437_5
Checking range [254 .. 257] from part 20200704_20369_20437_5
Checking range [254 .. 255] from part 20200704_20369_20437_5
Checking range [255 .. 257] from part 20200704_20369_20437_5
Checking range [255 .. 256] from part 20200704_20369_20437_5
Checking range [256 .. 257] from part 20200704_20369_20437_5
Checking range [257 .. 262] from part 20200704_20369_20437_5
Checking range [257 .. 259] from part 20200704_20369_20437_5
Checking range [257 .. 258] from part 20200704_20369_20437_5
Checking range [258 .. 259] from part 20200704_20369_20437_5
Checking range [259 .. 262] from part 20200704_20369_20437_5
Checking range [259 .. 260] from part 20200704_20369_20437_5
Checking range [260 .. 262] from part 20200704_20369_20437_5
Checking range [260 .. 261] from part 20200704_20369_20437_5
Checking range [261 .. 262] from part 20200704_20369_20437_5
Checking range [262 .. 273] from part 20200704_20369_20437_5
Checking range [262 .. 267] from part 20200704_20369_20437_5
Checking range [262 .. 264] from part 20200704_20369_20437_5
Checking range [262 .. 263] from part 20200704_20369_20437_5
Checking range [263 .. 264] from part 20200704_20369_20437_5
Checking range [264 .. 267] from part 20200704_20369_20437_5
Checking range [264 .. 265] from part 20200704_20369_20437_5
Checking range [265 .. 267] from part 20200704_20369_20437_5
Checking range [265 .. 266] from part 20200704_20369_20437_5
Checking range [266 .. 267] from part 20200704_20369_20437_5
Checking range [267 .. 273] from part 20200704_20369_20437_5
Checking range [267 .. 270] from part 20200704_20369_20437_5
Checking range [267 .. 268] from part 20200704_20369_20437_5
Checking range [268 .. 270] from part 20200704_20369_20437_5
Checking range [268 .. 269] from part 20200704_20369_20437_5
Checking range [269 .. 270] from part 20200704_20369_20437_5
Checking range [270 .. 273] from part 20200704_20369_20437_5
Checking range [273 .. 294] from part 20200704_20369_20437_5
Checking range [294 .. 337] from part 20200704_20369_20437_5
Checking range [337 .. 674] from part 20200704_20369_20437_5
Checking range [0 .. 1007] from part 20200704_20438_20540_6
Checking range [0 .. 503] from part 20200704_20438_20540_6
Checking range [503 .. 1006] from part 20200704_20438_20540_6
Checking range [503 .. 754] from part 20200704_20438_20540_6
Checking range [503 .. 628] from part 20200704_20438_20540_6
Checking range [503 .. 565] from part 20200704_20438_20540_6
Checking range [503 .. 534] from part 20200704_20438_20540_6
Checking range [503 .. 518] from part 20200704_20438_20540_6
Checking range [503 .. 510] from part 20200704_20438_20540_6
Checking range [503 .. 506] from part 20200704_20438_20540_6
Checking range [503 .. 504] from part 20200704_20438_20540_6
Checking range [504 .. 506] from part 20200704_20438_20540_6
Checking range [504 .. 505] from part 20200704_20438_20540_6
Checking range [505 .. 506] from part 20200704_20438_20540_6
Checking range [506 .. 510] from part 20200704_20438_20540_6
Checking range [506 .. 508] from part 20200704_20438_20540_6
Checking range [506 .. 507] from part 20200704_20438_20540_6
Checking range [507 .. 508] from part 20200704_20438_20540_6
Checking range [508 .. 510] from part 20200704_20438_20540_6
Checking range [508 .. 509] from part 20200704_20438_20540_6
Checking range [509 .. 510] from part 20200704_20438_20540_6
Checking range [510 .. 518] from part 20200704_20438_20540_6
Checking range [510 .. 514] from part 20200704_20438_20540_6
Checking range [510 .. 512] from part 20200704_20438_20540_6
Checking range [510 .. 511] from part 20200704_20438_20540_6
Checking range [511 .. 512] from part 20200704_20438_20540_6
Checking range [512 .. 514] from part 20200704_20438_20540_6
Checking range [512 .. 513] from part 20200704_20438_20540_6
Checking range [513 .. 514] from part 20200704_20438_20540_6
Checking range [514 .. 518] from part 20200704_20438_20540_6
Checking range [514 .. 516] from part 20200704_20438_20540_6
Checking range [514 .. 515] from part 20200704_20438_20540_6
Checking range [515 .. 516] from part 20200704_20438_20540_6
Checking range [516 .. 518] from part 20200704_20438_20540_6
Checking range [516 .. 517] from part 20200704_20438_20540_6
Checking range [517 .. 518] from part 20200704_20438_20540_6
Checking range [518 .. 534] from part 20200704_20438_20540_6
Checking range [518 .. 526] from part 20200704_20438_20540_6
Checking range [518 .. 522] from part 20200704_20438_20540_6
Checking range [518 .. 520] from part 20200704_20438_20540_6
Checking range [518 .. 519] from part 20200704_20438_20540_6
Checking range [519 .. 520] from part 20200704_20438_20540_6
Checking range [520 .. 522] from part 20200704_20438_20540_6
Checking range [520 .. 521] from part 20200704_20438_20540_6
Checking range [521 .. 522] from part 20200704_20438_20540_6
Checking range [522 .. 526] from part 20200704_20438_20540_6
Checking range [522 .. 524] from part 20200704_20438_20540_6
Checking range [522 .. 523] from part 20200704_20438_20540_6
Checking range [523 .. 524] from part 20200704_20438_20540_6
Checking range [524 .. 526] from part 20200704_20438_20540_6
Checking range [524 .. 525] from part 20200704_20438_20540_6
Checking range [525 .. 526] from part 20200704_20438_20540_6
Checking range [526 .. 534] from part 20200704_20438_20540_6
Checking range [526 .. 530] from part 20200704_20438_20540_6
Checking range [526 .. 528] from part 20200704_20438_20540_6
Checking range [526 .. 527] from part 20200704_20438_20540_6
Checking range [527 .. 528] from part 20200704_20438_20540_6
Checking range [528 .. 530] from part 20200704_20438_20540_6
Checking range [528 .. 529] from part 20200704_20438_20540_6
Checking range [529 .. 530] from part 20200704_20438_20540_6
Checking range [530 .. 534] from part 20200704_20438_20540_6
Checking range [530 .. 532] from part 20200704_20438_20540_6
Checking range [530 .. 531] from part 20200704_20438_20540_6
Checking range [531 .. 532] from part 20200704_20438_20540_6
Checking range [532 .. 534] from part 20200704_20438_20540_6
Checking range [532 .. 533] from part 20200704_20438_20540_6
Checking range [533 .. 534] from part 20200704_20438_20540_6
Checking range [534 .. 565] from part 20200704_20438_20540_6
Checking range [534 .. 549] from part 20200704_20438_20540_6
Checking range [534 .. 541] from part 20200704_20438_20540_6
Checking range [534 .. 537] from part 20200704_20438_20540_6
Checking range [534 .. 535] from part 20200704_20438_20540_6
Checking range [535 .. 537] from part 20200704_20438_20540_6
Checking range [535 .. 536] from part 20200704_20438_20540_6
Checking range [536 .. 537] from part 20200704_20438_20540_6
Checking range [537 .. 541] from part 20200704_20438_20540_6
Checking range [537 .. 539] from part 20200704_20438_20540_6
Checking range [537 .. 538] from part 20200704_20438_20540_6
Checking range [538 .. 539] from part 20200704_20438_20540_6
Checking range [539 .. 541] from part 20200704_20438_20540_6
Checking range [539 .. 540] from part 20200704_20438_20540_6
Checking range [540 .. 541] from part 20200704_20438_20540_6
Checking range [541 .. 549] from part 20200704_20438_20540_6
Checking range [541 .. 545] from part 20200704_20438_20540_6
Checking range [541 .. 543] from part 20200704_20438_20540_6
Checking range [541 .. 542] from part 20200704_20438_20540_6
Checking range [542 .. 543] from part 20200704_20438_20540_6
Checking range [543 .. 545] from part 20200704_20438_20540_6
Checking range [543 .. 544] from part 20200704_20438_20540_6
Checking range [544 .. 545] from part 20200704_20438_20540_6
Checking range [545 .. 549] from part 20200704_20438_20540_6
Checking range [545 .. 547] from part 20200704_20438_20540_6
Checking range [545 .. 546] from part 20200704_20438_20540_6
Checking range [546 .. 547] from part 20200704_20438_20540_6
Checking range [547 .. 549] from part 20200704_20438_20540_6
Checking range [547 .. 548] from part 20200704_20438_20540_6
Checking range [548 .. 549] from part 20200704_20438_20540_6
Checking range [549 .. 565] from part 20200704_20438_20540_6
Checking range [549 .. 557] from part 20200704_20438_20540_6
Checking range [549 .. 553] from part 20200704_20438_20540_6
Checking range [549 .. 551] from part 20200704_20438_20540_6
Checking range [549 .. 550] from part 20200704_20438_20540_6
Checking range [550 .. 551] from part 20200704_20438_20540_6
Checking range [551 .. 553] from part 20200704_20438_20540_6
Checking range [551 .. 552] from part 20200704_20438_20540_6
Checking range [552 .. 553] from part 20200704_20438_20540_6
Checking range [553 .. 557] from part 20200704_20438_20540_6
Checking range [553 .. 555] from part 20200704_20438_20540_6
Checking range [553 .. 554] from part 20200704_20438_20540_6
Checking range [554 .. 555] from part 20200704_20438_20540_6
Checking range [555 .. 557] from part 20200704_20438_20540_6
Checking range [555 .. 556] from part 20200704_20438_20540_6
Checking range [556 .. 557] from part 20200704_20438_20540_6
Checking range [557 .. 565] from part 20200704_20438_20540_6
Checking range [557 .. 561] from part 20200704_20438_20540_6
Checking range [557 .. 559] from part 20200704_20438_20540_6
Checking range [557 .. 558] from part 20200704_20438_20540_6
Checking range [558 .. 559] from part 20200704_20438_20540_6
Checking range [559 .. 561] from part 20200704_20438_20540_6
Checking range [559 .. 560] from part 20200704_20438_20540_6
Checking range [560 .. 561] from part 20200704_20438_20540_6
Checking range [561 .. 565] from part 20200704_20438_20540_6
Checking range [561 .. 563] from part 20200704_20438_20540_6
Checking range [561 .. 562] from part 20200704_20438_20540_6
Checking range [562 .. 563] from part 20200704_20438_20540_6
Checking range [563 .. 565] from part 20200704_20438_20540_6
Checking range [563 .. 564] from part 20200704_20438_20540_6
Checking range [564 .. 565] from part 20200704_20438_20540_6
Checking range [565 .. 628] from part 20200704_20438_20540_6
Checking range [565 .. 596] from part 20200704_20438_20540_6
Checking range [565 .. 580] from part 20200704_20438_20540_6
Checking range [565 .. 572] from part 20200704_20438_20540_6
Checking range [565 .. 568] from part 20200704_20438_20540_6
Checking range [565 .. 566] from part 20200704_20438_20540_6
Checking range [566 .. 568] from part 20200704_20438_20540_6
Checking range [566 .. 567] from part 20200704_20438_20540_6
Checking range [567 .. 568] from part 20200704_20438_20540_6
Checking range [568 .. 572] from part 20200704_20438_20540_6
Checking range [568 .. 570] from part 20200704_20438_20540_6
Checking range [568 .. 569] from part 20200704_20438_20540_6
Checking range [569 .. 570] from part 20200704_20438_20540_6
Checking range [570 .. 572] from part 20200704_20438_20540_6
Checking range [570 .. 571] from part 20200704_20438_20540_6
Checking range [571 .. 572] from part 20200704_20438_20540_6
Checking range [572 .. 580] from part 20200704_20438_20540_6
Checking range [572 .. 576] from part 20200704_20438_20540_6
Checking range [572 .. 574] from part 20200704_20438_20540_6
Checking range [572 .. 573] from part 20200704_20438_20540_6
Checking range [573 .. 574] from part 20200704_20438_20540_6
Checking range [574 .. 576] from part 20200704_20438_20540_6
Checking range [574 .. 575] from part 20200704_20438_20540_6
Checking range [575 .. 576] from part 20200704_20438_20540_6
Checking range [576 .. 580] from part 20200704_20438_20540_6
Checking range [576 .. 578] from part 20200704_20438_20540_6
Checking range [576 .. 577] from part 20200704_20438_20540_6
Checking range [577 .. 578] from part 20200704_20438_20540_6
Checking range [578 .. 580] from part 20200704_20438_20540_6
Checking range [578 .. 579] from part 20200704_20438_20540_6
Checking range [579 .. 580] from part 20200704_20438_20540_6
Checking range [580 .. 596] from part 20200704_20438_20540_6
Checking range [580 .. 588] from part 20200704_20438_20540_6
Checking range [580 .. 584] from part 20200704_20438_20540_6
Checking range [580 .. 582] from part 20200704_20438_20540_6
Checking range [580 .. 581] from part 20200704_20438_20540_6
Checking range [581 .. 582] from part 20200704_20438_20540_6
Checking range [582 .. 584] from part 20200704_20438_20540_6
Checking range [582 .. 583] from part 20200704_20438_20540_6
Checking range [583 .. 584] from part 20200704_20438_20540_6
Checking range [584 .. 588] from part 20200704_20438_20540_6
Checking range [584 .. 586] from part 20200704_20438_20540_6
Checking range [584 .. 585] from part 20200704_20438_20540_6
Checking range [585 .. 586] from part 20200704_20438_20540_6
Checking range [586 .. 588] from part 20200704_20438_20540_6
Checking range [586 .. 587] from part 20200704_20438_20540_6
Checking range [587 .. 588] from part 20200704_20438_20540_6
Checking range [588 .. 596] from part 20200704_20438_20540_6
Checking range [588 .. 592] from part 20200704_20438_20540_6
Checking range [588 .. 590] from part 20200704_20438_20540_6
Checking range [588 .. 589] from part 20200704_20438_20540_6
Checking range [589 .. 590] from part 20200704_20438_20540_6
Checking range [590 .. 592] from part 20200704_20438_20540_6
Checking range [590 .. 591] from part 20200704_20438_20540_6
Checking range [591 .. 592] from part 20200704_20438_20540_6
Checking range [592 .. 596] from part 20200704_20438_20540_6
Checking range [592 .. 594] from part 20200704_20438_20540_6
Checking range [592 .. 593] from part 20200704_20438_20540_6
Checking range [593 .. 594] from part 20200704_20438_20540_6
Checking range [594 .. 596] from part 20200704_20438_20540_6
Checking range [594 .. 595] from part 20200704_20438_20540_6
Checking range [595 .. 596] from part 20200704_20438_20540_6
Checking range [596 .. 628] from part 20200704_20438_20540_6
Checking range [596 .. 612] from part 20200704_20438_20540_6
Checking range [596 .. 604] from part 20200704_20438_20540_6
Checking range [596 .. 600] from part 20200704_20438_20540_6
Checking range [596 .. 598] from part 20200704_20438_20540_6
Checking range [596 .. 597] from part 20200704_20438_20540_6
Checking range [597 .. 598] from part 20200704_20438_20540_6
Checking range [598 .. 600] from part 20200704_20438_20540_6
Checking range [598 .. 599] from part 20200704_20438_20540_6
Checking range [599 .. 600] from part 20200704_20438_20540_6
Checking range [600 .. 604] from part 20200704_20438_20540_6
Checking range [600 .. 602] from part 20200704_20438_20540_6
Checking range [600 .. 601] from part 20200704_20438_20540_6
Checking range [601 .. 602] from part 20200704_20438_20540_6
Checking range [602 .. 604] from part 20200704_20438_20540_6
Checking range [602 .. 603] from part 20200704_20438_20540_6
Checking range [603 .. 604] from part 20200704_20438_20540_6
Checking range [604 .. 612] from part 20200704_20438_20540_6
Checking range [604 .. 608] from part 20200704_20438_20540_6
Checking range [604 .. 606] from part 20200704_20438_20540_6
Checking range [604 .. 605] from part 20200704_20438_20540_6
Checking range [605 .. 606] from part 20200704_20438_20540_6
Checking range [606 .. 608] from part 20200704_20438_20540_6
Checking range [606 .. 607] from part 20200704_20438_20540_6
Checking range [607 .. 608] from part 20200704_20438_20540_6
Checking range [608 .. 612] from part 20200704_20438_20540_6
Checking range [608 .. 610] from part 20200704_20438_20540_6
Checking range [608 .. 609] from part 20200704_20438_20540_6
Checking range [609 .. 610] from part 20200704_20438_20540_6
Checking range [610 .. 612] from part 20200704_20438_20540_6
Checking range [610 .. 611] from part 20200704_20438_20540_6
Checking range [611 .. 612] from part 20200704_20438_20540_6
Checking range [612 .. 628] from part 20200704_20438_20540_6
Checking range [612 .. 620] from part 20200704_20438_20540_6
Checking range [612 .. 616] from part 20200704_20438_20540_6
Checking range [612 .. 614] from part 20200704_20438_20540_6
Checking range [612 .. 613] from part 20200704_20438_20540_6
Checking range [613 .. 614] from part 20200704_20438_20540_6
Checking range [614 .. 616] from part 20200704_20438_20540_6
Checking range [614 .. 615] from part 20200704_20438_20540_6
Checking range [615 .. 616] from part 20200704_20438_20540_6
Checking range [616 .. 620] from part 20200704_20438_20540_6
Checking range [620 .. 628] from part 20200704_20438_20540_6
Checking range [628 .. 754] from part 20200704_20438_20540_6
Checking range [754 .. 1006] from part 20200704_20438_20540_6
Checking range [0 .. 431] from part 20200704_20541_20584_5
Checking range [0 .. 215] from part 20200704_20541_20584_5
Checking range [0 .. 107] from part 20200704_20541_20584_5
Checking range [107 .. 215] from part 20200704_20541_20584_5
Checking range [107 .. 161] from part 20200704_20541_20584_5
Checking range [161 .. 215] from part 20200704_20541_20584_5
Checking range [161 .. 188] from part 20200704_20541_20584_5
Checking range [188 .. 215] from part 20200704_20541_20584_5
Checking range [188 .. 201] from part 20200704_20541_20584_5
Checking range [201 .. 215] from part 20200704_20541_20584_5
Checking range [201 .. 208] from part 20200704_20541_20584_5
Checking range [201 .. 204] from part 20200704_20541_20584_5
Checking range [201 .. 202] from part 20200704_20541_20584_5
Checking range [202 .. 204] from part 20200704_20541_20584_5
Checking range [202 .. 203] from part 20200704_20541_20584_5
Checking range [203 .. 204] from part 20200704_20541_20584_5
Checking range [204 .. 208] from part 20200704_20541_20584_5
Checking range [204 .. 206] from part 20200704_20541_20584_5
Checking range [204 .. 205] from part 20200704_20541_20584_5
Checking range [205 .. 206] from part 20200704_20541_20584_5
Checking range [206 .. 208] from part 20200704_20541_20584_5
Checking range [206 .. 207] from part 20200704_20541_20584_5
Checking range [207 .. 208] from part 20200704_20541_20584_5
Checking range [208 .. 215] from part 20200704_20541_20584_5
Checking range [208 .. 211] from part 20200704_20541_20584_5
Checking range [208 .. 209] from part 20200704_20541_20584_5
Checking range [209 .. 211] from part 20200704_20541_20584_5
Checking range [209 .. 210] from part 20200704_20541_20584_5
Checking range [210 .. 211] from part 20200704_20541_20584_5
Checking range [211 .. 215] from part 20200704_20541_20584_5
Checking range [211 .. 213] from part 20200704_20541_20584_5
Checking range [211 .. 212] from part 20200704_20541_20584_5
Checking range [212 .. 213] from part 20200704_20541_20584_5
Checking range [213 .. 215] from part 20200704_20541_20584_5
Checking range [213 .. 214] from part 20200704_20541_20584_5
Checking range [214 .. 215] from part 20200704_20541_20584_5
Checking range [215 .. 430] from part 20200704_20541_20584_5
Checking range [215 .. 322] from part 20200704_20541_20584_5
Checking range [215 .. 268] from part 20200704_20541_20584_5
Checking range [215 .. 241] from part 20200704_20541_20584_5
Checking range [215 .. 228] from part 20200704_20541_20584_5
Checking range [215 .. 221] from part 20200704_20541_20584_5
Checking range [215 .. 218] from part 20200704_20541_20584_5
Checking range [215 .. 216] from part 20200704_20541_20584_5
Checking range [216 .. 218] from part 20200704_20541_20584_5
Checking range [216 .. 217] from part 20200704_20541_20584_5
Checking range [217 .. 218] from part 20200704_20541_20584_5
Checking range [218 .. 221] from part 20200704_20541_20584_5
Checking range [218 .. 219] from part 20200704_20541_20584_5
Checking range [219 .. 221] from part 20200704_20541_20584_5
Checking range [219 .. 220] from part 20200704_20541_20584_5
Checking range [220 .. 221] from part 20200704_20541_20584_5
Checking range [221 .. 228] from part 20200704_20541_20584_5
Checking range [221 .. 224] from part 20200704_20541_20584_5
Checking range [221 .. 222] from part 20200704_20541_20584_5
Checking range [222 .. 224] from part 20200704_20541_20584_5
Checking range [222 .. 223] from part 20200704_20541_20584_5
Checking range [223 .. 224] from part 20200704_20541_20584_5
Checking range [224 .. 228] from part 20200704_20541_20584_5
Checking range [224 .. 226] from part 20200704_20541_20584_5
Checking range [224 .. 225] from part 20200704_20541_20584_5
Checking range [225 .. 226] from part 20200704_20541_20584_5
Checking range [226 .. 228] from part 20200704_20541_20584_5
Checking range [226 .. 227] from part 20200704_20541_20584_5
Checking range [227 .. 228] from part 20200704_20541_20584_5
Checking range [228 .. 241] from part 20200704_20541_20584_5
Checking range [228 .. 234] from part 20200704_20541_20584_5
Checking range [228 .. 231] from part 20200704_20541_20584_5
Checking range [228 .. 229] from part 20200704_20541_20584_5
Checking range [229 .. 231] from part 20200704_20541_20584_5
Checking range [229 .. 230] from part 20200704_20541_20584_5
Checking range [230 .. 231] from part 20200704_20541_20584_5
Checking range [231 .. 234] from part 20200704_20541_20584_5
Checking range [231 .. 232] from part 20200704_20541_20584_5
Checking range [232 .. 234] from part 20200704_20541_20584_5
Checking range [232 .. 233] from part 20200704_20541_20584_5
Checking range [233 .. 234] from part 20200704_20541_20584_5
Checking range [234 .. 241] from part 20200704_20541_20584_5
Checking range [234 .. 237] from part 20200704_20541_20584_5
Checking range [234 .. 235] from part 20200704_20541_20584_5
Checking range [235 .. 237] from part 20200704_20541_20584_5
Checking range [235 .. 236] from part 20200704_20541_20584_5
Checking range [236 .. 237] from part 20200704_20541_20584_5
Checking range [237 .. 241] from part 20200704_20541_20584_5
Checking range [237 .. 239] from part 20200704_20541_20584_5
Checking range [237 .. 238] from part 20200704_20541_20584_5
Checking range [238 .. 239] from part 20200704_20541_20584_5
Checking range [239 .. 241] from part 20200704_20541_20584_5
Checking range [239 .. 240] from part 20200704_20541_20584_5
Checking range [240 .. 241] from part 20200704_20541_20584_5
Checking range [241 .. 268] from part 20200704_20541_20584_5
Checking range [241 .. 254] from part 20200704_20541_20584_5
Checking range [241 .. 247] from part 20200704_20541_20584_5
Checking range [241 .. 244] from part 20200704_20541_20584_5
Checking range [241 .. 242] from part 20200704_20541_20584_5
Checking range [242 .. 244] from part 20200704_20541_20584_5
Checking range [242 .. 243] from part 20200704_20541_20584_5
Checking range [243 .. 244] from part 20200704_20541_20584_5
Checking range [244 .. 247] from part 20200704_20541_20584_5
Checking range [244 .. 245] from part 20200704_20541_20584_5
Checking range [245 .. 247] from part 20200704_20541_20584_5
Checking range [245 .. 246] from part 20200704_20541_20584_5
Checking range [246 .. 247] from part 20200704_20541_20584_5
Checking range [247 .. 254] from part 20200704_20541_20584_5
Checking range [247 .. 250] from part 20200704_20541_20584_5
Checking range [247 .. 248] from part 20200704_20541_20584_5
Checking range [248 .. 250] from part 20200704_20541_20584_5
Checking range [248 .. 249] from part 20200704_20541_20584_5
Checking range [249 .. 250] from part 20200704_20541_20584_5
Checking range [250 .. 254] from part 20200704_20541_20584_5
Checking range [250 .. 252] from part 20200704_20541_20584_5
Checking range [250 .. 251] from part 20200704_20541_20584_5
Checking range [251 .. 252] from part 20200704_20541_20584_5
Checking range [252 .. 254] from part 20200704_20541_20584_5
Checking range [254 .. 268] from part 20200704_20541_20584_5
Checking range [268 .. 322] from part 20200704_20541_20584_5
Checking range [322 .. 430] from part 20200704_20541_20584_5
Checking range [0 .. 324] from part 20200704_20585_20617_4
Checking range [0 .. 161] from part 20200704_20585_20617_4
Checking range [161 .. 323] from part 20200704_20585_20617_4
Checking range [161 .. 242] from part 20200704_20585_20617_4
Checking range [161 .. 201] from part 20200704_20585_20617_4
Checking range [161 .. 181] from part 20200704_20585_20617_4
Checking range [161 .. 171] from part 20200704_20585_20617_4
Checking range [161 .. 166] from part 20200704_20585_20617_4
Checking range [161 .. 163] from part 20200704_20585_20617_4
Checking range [163 .. 166] from part 20200704_20585_20617_4
Checking range [163 .. 164] from part 20200704_20585_20617_4
Checking range [164 .. 166] from part 20200704_20585_20617_4
Checking range [164 .. 165] from part 20200704_20585_20617_4
Checking range [165 .. 166] from part 20200704_20585_20617_4
Checking range [166 .. 171] from part 20200704_20585_20617_4
Checking range [166 .. 168] from part 20200704_20585_20617_4
Checking range [166 .. 167] from part 20200704_20585_20617_4
Checking range [167 .. 168] from part 20200704_20585_20617_4
Checking range [168 .. 171] from part 20200704_20585_20617_4
Checking range [168 .. 169] from part 20200704_20585_20617_4
Checking range [169 .. 171] from part 20200704_20585_20617_4
Checking range [169 .. 170] from part 20200704_20585_20617_4
Checking range [170 .. 171] from part 20200704_20585_20617_4
Checking range [171 .. 181] from part 20200704_20585_20617_4
Checking range [171 .. 176] from part 20200704_20585_20617_4
Checking range [171 .. 173] from part 20200704_20585_20617_4
Checking range [171 .. 172] from part 20200704_20585_20617_4
Checking range [172 .. 173] from part 20200704_20585_20617_4
Checking range [173 .. 176] from part 20200704_20585_20617_4
Checking range [173 .. 174] from part 20200704_20585_20617_4
Checking range [174 .. 176] from part 20200704_20585_20617_4
Checking range [174 .. 175] from part 20200704_20585_20617_4
Checking range [175 .. 176] from part 20200704_20585_20617_4
Checking range [176 .. 181] from part 20200704_20585_20617_4
Checking range [176 .. 178] from part 20200704_20585_20617_4
Checking range [176 .. 177] from part 20200704_20585_20617_4
Checking range [177 .. 178] from part 20200704_20585_20617_4
Checking range [178 .. 181] from part 20200704_20585_20617_4
Checking range [178 .. 179] from part 20200704_20585_20617_4
Checking range [179 .. 181] from part 20200704_20585_20617_4
Checking range [179 .. 180] from part 20200704_20585_20617_4
Checking range [180 .. 181] from part 20200704_20585_20617_4
Checking range [181 .. 201] from part 20200704_20585_20617_4
Checking range [181 .. 191] from part 20200704_20585_20617_4
Checking range [181 .. 186] from part 20200704_20585_20617_4
Checking range [181 .. 183] from part 20200704_20585_20617_4
Checking range [181 .. 182] from part 20200704_20585_20617_4
Checking range [182 .. 183] from part 20200704_20585_20617_4
Checking range [183 .. 186] from part 20200704_20585_20617_4
Checking range [183 .. 184] from part 20200704_20585_20617_4
Checking range [184 .. 186] from part 20200704_20585_20617_4
Checking range [184 .. 185] from part 20200704_20585_20617_4
Checking range [185 .. 186] from part 20200704_20585_20617_4
Checking range [186 .. 191] from part 20200704_20585_20617_4
Checking range [186 .. 188] from part 20200704_20585_20617_4
Checking range [186 .. 187] from part 20200704_20585_20617_4
Checking range [187 .. 188] from part 20200704_20585_20617_4
Checking range [188 .. 191] from part 20200704_20585_20617_4
Checking range [188 .. 189] from part 20200704_20585_20617_4
Checking range [189 .. 191] from part 20200704_20585_20617_4
Checking range [189 .. 190] from part 20200704_20585_20617_4
Checking range [190 .. 191] from part 20200704_20585_20617_4
Checking range [191 .. 201] from part 20200704_20585_20617_4
Checking range [191 .. 196] from part 20200704_20585_20617_4
Checking range [191 .. 193] from part 20200704_20585_20617_4
Checking range [191 .. 192] from part 20200704_20585_20617_4
Checking range [192 .. 193] from part 20200704_20585_20617_4
Checking range [193 .. 196] from part 20200704_20585_20617_4
Checking range [193 .. 194] from part 20200704_20585_20617_4
Checking range [194 .. 196] from part 20200704_20585_20617_4
Checking range [194 .. 195] from part 20200704_20585_20617_4
Checking range [195 .. 196] from part 20200704_20585_20617_4
Checking range [196 .. 201] from part 20200704_20585_20617_4
Checking range [196 .. 198] from part 20200704_20585_20617_4
Checking range [196 .. 197] from part 20200704_20585_20617_4
Checking range [197 .. 198] from part 20200704_20585_20617_4
Checking range [198 .. 201] from part 20200704_20585_20617_4
Checking range [198 .. 199] from part 20200704_20585_20617_4
Checking range [199 .. 201] from part 20200704_20585_20617_4
Checking range [199 .. 200] from part 20200704_20585_20617_4
Checking range [200 .. 201] from part 20200704_20585_20617_4
Checking range [201 .. 242] from part 20200704_20585_20617_4
Checking range [201 .. 221] from part 20200704_20585_20617_4
Checking range [201 .. 211] from part 20200704_20585_20617_4
Checking range [201 .. 206] from part 20200704_20585_20617_4
Checking range [201 .. 203] from part 20200704_20585_20617_4
Checking range [201 .. 202] from part 20200704_20585_20617_4
Checking range [202 .. 203] from part 20200704_20585_20617_4
Checking range [203 .. 206] from part 20200704_20585_20617_4
Checking range [203 .. 204] from part 20200704_20585_20617_4
Checking range [204 .. 206] from part 20200704_20585_20617_4
Checking range [204 .. 205] from part 20200704_20585_20617_4
Checking range [205 .. 206] from part 20200704_20585_20617_4
Checking range [206 .. 211] from part 20200704_20585_20617_4
Checking range [206 .. 208] from part 20200704_20585_20617_4
Checking range [206 .. 207] from part 20200704_20585_20617_4
Checking range [207 .. 208] from part 20200704_20585_20617_4
Checking range [208 .. 211] from part 20200704_20585_20617_4
Checking range [208 .. 209] from part 20200704_20585_20617_4
Checking range [209 .. 211] from part 20200704_20585_20617_4
Checking range [209 .. 210] from part 20200704_20585_20617_4
Checking range [210 .. 211] from part 20200704_20585_20617_4
Checking range [211 .. 221] from part 20200704_20585_20617_4
Checking range [211 .. 216] from part 20200704_20585_20617_4
Checking range [211 .. 213] from part 20200704_20585_20617_4
Checking range [211 .. 212] from part 20200704_20585_20617_4
Checking range [212 .. 213] from part 20200704_20585_20617_4
Checking range [213 .. 216] from part 20200704_20585_20617_4
Checking range [213 .. 214] from part 20200704_20585_20617_4
Checking range [214 .. 216] from part 20200704_20585_20617_4
Checking range [214 .. 215] from part 20200704_20585_20617_4
Checking range [215 .. 216] from part 20200704_20585_20617_4
Checking range [216 .. 221] from part 20200704_20585_20617_4
Checking range [216 .. 218] from part 20200704_20585_20617_4
Checking range [216 .. 217] from part 20200704_20585_20617_4
Checking range [217 .. 218] from part 20200704_20585_20617_4
Checking range [218 .. 221] from part 20200704_20585_20617_4
Checking range [221 .. 242] from part 20200704_20585_20617_4
Checking range [242 .. 323] from part 20200704_20585_20617_4
Checking range [0 .. 99] from part 20200704_20618_20627_2
Checking range [0 .. 49] from part 20200704_20618_20627_2
Checking range [0 .. 24] from part 20200704_20618_20627_2
Checking range [24 .. 49] from part 20200704_20618_20627_2
Checking range [24 .. 36] from part 20200704_20618_20627_2
Checking range [36 .. 49] from part 20200704_20618_20627_2
Checking range [36 .. 42] from part 20200704_20618_20627_2
Checking range [36 .. 39] from part 20200704_20618_20627_2
Checking range [39 .. 42] from part 20200704_20618_20627_2
Checking range [39 .. 40] from part 20200704_20618_20627_2
Checking range [40 .. 42] from part 20200704_20618_20627_2
Checking range [40 .. 41] from part 20200704_20618_20627_2
Checking range [41 .. 42] from part 20200704_20618_20627_2
Checking range [42 .. 49] from part 20200704_20618_20627_2
Checking range [42 .. 45] from part 20200704_20618_20627_2
Checking range [42 .. 43] from part 20200704_20618_20627_2
Checking range [43 .. 45] from part 20200704_20618_20627_2
Checking range [43 .. 44] from part 20200704_20618_20627_2
Checking range [44 .. 45] from part 20200704_20618_20627_2
Checking range [45 .. 49] from part 20200704_20618_20627_2
Checking range [45 .. 47] from part 20200704_20618_20627_2
Checking range [45 .. 46] from part 20200704_20618_20627_2
Checking range [46 .. 47] from part 20200704_20618_20627_2
Checking range [47 .. 49] from part 20200704_20618_20627_2
Checking range [47 .. 48] from part 20200704_20618_20627_2
Checking range [48 .. 49] from part 20200704_20618_20627_2
Checking range [49 .. 98] from part 20200704_20618_20627_2
Checking range [49 .. 73] from part 20200704_20618_20627_2
Checking range [49 .. 61] from part 20200704_20618_20627_2
Checking range [49 .. 55] from part 20200704_20618_20627_2
Checking range [49 .. 52] from part 20200704_20618_20627_2
Checking range [49 .. 50] from part 20200704_20618_20627_2
Checking range [50 .. 52] from part 20200704_20618_20627_2
Checking range [50 .. 51] from part 20200704_20618_20627_2
Checking range [51 .. 52] from part 20200704_20618_20627_2
Checking range [52 .. 55] from part 20200704_20618_20627_2
Checking range [55 .. 61] from part 20200704_20618_20627_2
Checking range [61 .. 73] from part 20200704_20618_20627_2
Checking range [73 .. 98] from part 20200704_20618_20627_2
Checking range [0 .. 11] from part 20200704_20628_20628_0
Checking range [0 .. 5] from part 20200704_20628_20628_0
Checking range [0 .. 2] from part 20200704_20628_20628_0
Checking range [2 .. 5] from part 20200704_20628_20628_0
Checking range [2 .. 3] from part 20200704_20628_20628_0
Checking range [3 .. 5] from part 20200704_20628_20628_0
Checking range [3 .. 4] from part 20200704_20628_20628_0
Checking range [4 .. 5] from part 20200704_20628_20628_0
Checking range [5 .. 10] from part 20200704_20628_20628_0
Checking range [0 .. 11] from part 20200704_20629_20629_0
Checking range [0 .. 5] from part 20200704_20629_20629_0
Checking range [0 .. 2] from part 20200704_20629_20629_0
Checking range [2 .. 5] from part 20200704_20629_20629_0
Checking range [2 .. 3] from part 20200704_20629_20629_0
Checking range [3 .. 5] from part 20200704_20629_20629_0
Checking range [3 .. 4] from part 20200704_20629_20629_0
Checking range [4 .. 5] from part 20200704_20629_20629_0
Checking range [5 .. 10] from part 20200704_20629_20629_0
Checking range [0 .. 11] from part 20200704_20630_20630_0
Checking range [0 .. 5] from part 20200704_20630_20630_0
Checking range [0 .. 2] from part 20200704_20630_20630_0
Checking range [2 .. 5] from part 20200704_20630_20630_0
Checking range [2 .. 3] from part 20200704_20630_20630_0
Checking range [3 .. 5] from part 20200704_20630_20630_0
Checking range [3 .. 4] from part 20200704_20630_20630_0
Checking range [4 .. 5] from part 20200704_20630_20630_0
Checking range [5 .. 10] from part 20200704_20630_20630_0
Checking range [0 .. 11] from part 20200704_20631_20631_0
Checking range [0 .. 5] from part 20200704_20631_20631_0
Checking range [0 .. 2] from part 20200704_20631_20631_0
Checking range [2 .. 5] from part 20200704_20631_20631_0
Checking range [2 .. 3] from part 20200704_20631_20631_0
Checking range [3 .. 5] from part 20200704_20631_20631_0
Checking range [3 .. 4] from part 20200704_20631_20631_0
Checking range [4 .. 5] from part 20200704_20631_20631_0
Checking range [5 .. 10] from part 20200704_20631_20631_0
Checking range [0 .. 60] from part 20200704_20632_20637_1
Checking range [0 .. 29] from part 20200704_20632_20637_1
Checking range [0 .. 14] from part 20200704_20632_20637_1
Checking range [14 .. 29] from part 20200704_20632_20637_1
Checking range [14 .. 21] from part 20200704_20632_20637_1
Checking range [14 .. 17] from part 20200704_20632_20637_1
Checking range [17 .. 21] from part 20200704_20632_20637_1
Checking range [17 .. 19] from part 20200704_20632_20637_1
Checking range [19 .. 21] from part 20200704_20632_20637_1
Checking range [19 .. 20] from part 20200704_20632_20637_1
Checking range [20 .. 21] from part 20200704_20632_20637_1
Checking range [21 .. 29] from part 20200704_20632_20637_1
Checking range [21 .. 25] from part 20200704_20632_20637_1
Checking range [21 .. 23] from part 20200704_20632_20637_1
Checking range [21 .. 22] from part 20200704_20632_20637_1
Checking range [22 .. 23] from part 20200704_20632_20637_1
Checking range [23 .. 25] from part 20200704_20632_20637_1
Checking range [23 .. 24] from part 20200704_20632_20637_1
Checking range [24 .. 25] from part 20200704_20632_20637_1
Checking range [25 .. 29] from part 20200704_20632_20637_1
Checking range [29 .. 59] from part 20200704_20632_20637_1
Checking range [0 .. 11] from part 20200704_20638_20638_0
Checking range [0 .. 5] from part 20200704_20638_20638_0
Checking range [0 .. 2] from part 20200704_20638_20638_0
Checking range [2 .. 5] from part 20200704_20638_20638_0
Checking range [2 .. 3] from part 20200704_20638_20638_0
Checking range [3 .. 5] from part 20200704_20638_20638_0
Checking range [3 .. 4] from part 20200704_20638_20638_0
Checking range [4 .. 5] from part 20200704_20638_20638_0
Checking range [5 .. 10] from part 20200704_20638_20638_0
Checking range [0 .. 11] from part 20200704_20639_20639_0
Checking range [0 .. 5] from part 20200704_20639_20639_0
Checking range [0 .. 2] from part 20200704_20639_20639_0
Checking range [2 .. 5] from part 20200704_20639_20639_0
Checking range [2 .. 3] from part 20200704_20639_20639_0
Checking range [3 .. 5] from part 20200704_20639_20639_0
Checking range [3 .. 4] from part 20200704_20639_20639_0
Checking range [4 .. 5] from part 20200704_20639_20639_0
Checking range [5 .. 10] from part 20200704_20639_20639_0
Checking range [5 .. 7] from part 20200704_20639_20639_0
Checking range [5 .. 6] from part 20200704_20639_20639_0
Checking range [6 .. 7] from part 20200704_20639_20639_0
Checking range [7 .. 10] from part 20200704_20639_20639_0
Checking range [0 .. 11] from part 20200704_20640_20640_0
Checking range [0 .. 5] from part 20200704_20640_20640_0
Checking range [0 .. 2] from part 20200704_20640_20640_0
Checking range [2 .. 5] from part 20200704_20640_20640_0
Checking range [2 .. 3] from part 20200704_20640_20640_0
Checking range [3 .. 5] from part 20200704_20640_20640_0
Checking range [3 .. 4] from part 20200704_20640_20640_0
Checking range [4 .. 5] from part 20200704_20640_20640_0
Checking range [5 .. 10] from part 20200704_20640_20640_0
Checking range [5 .. 7] from part 20200704_20640_20640_0
Checking range [5 .. 6] from part 20200704_20640_20640_0
Checking range [6 .. 7] from part 20200704_20640_20640_0
Checking range [7 .. 10] from part 20200704_20640_20640_0
Checking range [0 .. 11] from part 20200704_20641_20641_0
Checking range [0 .. 5] from part 20200704_20641_20641_0
Checking range [0 .. 2] from part 20200704_20641_20641_0
Checking range [2 .. 5] from part 20200704_20641_20641_0
Checking range [2 .. 3] from part 20200704_20641_20641_0
Checking range [3 .. 5] from part 20200704_20641_20641_0
Checking range [3 .. 4] from part 20200704_20641_20641_0
Checking range [4 .. 5] from part 20200704_20641_20641_0
Checking range [5 .. 10] from part 20200704_20641_20641_0
Checking range [0 .. 11] from part 20200704_20642_20642_0
Checking range [0 .. 5] from part 20200704_20642_20642_0
Checking range [0 .. 2] from part 20200704_20642_20642_0
Checking range [2 .. 5] from part 20200704_20642_20642_0
Checking range [2 .. 3] from part 20200704_20642_20642_0
Checking range [3 .. 5] from part 20200704_20642_20642_0
Checking range [3 .. 4] from part 20200704_20642_20642_0
Checking range [4 .. 5] from part 20200704_20642_20642_0
Checking range [5 .. 10] from part 20200704_20642_20642_0
Checking range [5 .. 7] from part 20200704_20642_20642_0
Checking range [5 .. 6] from part 20200704_20642_20642_0
Checking range [6 .. 7] from part 20200704_20642_20642_0
Checking range [7 .. 10] from part 20200704_20642_20642_0
Checking range [0 .. 11] from part 20200704_20643_20643_0
Checking range [0 .. 5] from part 20200704_20643_20643_0
Checking range [0 .. 2] from part 20200704_20643_20643_0
Checking range [2 .. 5] from part 20200704_20643_20643_0
Checking range [2 .. 3] from part 20200704_20643_20643_0
Checking range [3 .. 5] from part 20200704_20643_20643_0
Checking range [3 .. 4] from part 20200704_20643_20643_0
Checking range [4 .. 5] from part 20200704_20643_20643_0
Checking range [5 .. 10] from part 20200704_20643_20643_0
Checking range [5 .. 7] from part 20200704_20643_20643_0
Checking range [5 .. 6] from part 20200704_20643_20643_0
Checking range [6 .. 7] from part 20200704_20643_20643_0
Checking range [7 .. 10] from part 20200704_20643_20643_0
Checking range [0 .. 11] from part 20200704_20644_20644_0
Checking range [0 .. 5] from part 20200704_20644_20644_0
Checking range [0 .. 2] from part 20200704_20644_20644_0
Checking range [2 .. 5] from part 20200704_20644_20644_0
Checking range [2 .. 3] from part 20200704_20644_20644_0
Checking range [3 .. 5] from part 20200704_20644_20644_0
Checking range [3 .. 4] from part 20200704_20644_20644_0
Checking range [4 .. 5] from part 20200704_20644_20644_0
Checking range [5 .. 10] from part 20200704_20644_20644_0
Checking range [5 .. 7] from part 20200704_20644_20644_0
Checking range [5 .. 6] from part 20200704_20644_20644_0
Checking range [6 .. 7] from part 20200704_20644_20644_0
Checking range [7 .. 10] from part 20200704_20644_20644_0

Patterns like this do not look like a healthy binary search:

Checking range [0 .. 539] from part 20200704_20085_20139_5
Checking range [0 .. 269] from part 20200704_20085_20139_5
Checking range [0 .. 134] from part 20200704_20085_20139_5
Checking range [134 .. 269] from part 20200704_20085_20139_5
Checking range [134 .. 201] from part 20200704_20085_20139_5
Checking range [201 .. 269] from part 20200704_20085_20139_5
Checking range [201 .. 235] from part 20200704_20085_20139_5
Checking range [235 .. 269] from part 20200704_20085_20139_5
Checking range [235 .. 252] from part 20200704_20085_20139_5
Checking range [235 .. 243] from part 20200704_20085_20139_5
Checking range [243 .. 252] from part 20200704_20085_20139_5
Checking range [243 .. 247] from part 20200704_20085_20139_5
Checking range [247 .. 252] from part 20200704_20085_20139_5
Checking range [247 .. 249] from part 20200704_20085_20139_5
Checking range [247 .. 248] from part 20200704_20085_20139_5
Checking range [248 .. 249] from part 20200704_20085_20139_5
Checking range [249 .. 252] from part 20200704_20085_20139_5
Checking range [249 .. 250] from part 20200704_20085_20139_5
Checking range [250 .. 252] from part 20200704_20085_20139_5
Checking range [250 .. 251] from part 20200704_20085_20139_5
Checking range [251 .. 252] from part 20200704_20085_20139_5
Checking range [252 .. 269] from part 20200704_20085_20139_5
Checking range [252 .. 260] from part 20200704_20085_20139_5
Checking range [252 .. 256] from part 20200704_20085_20139_5
Checking range [252 .. 254] from part 20200704_20085_20139_5
Checking range [252 .. 253] from part 20200704_20085_20139_5
Checking range [253 .. 254] from part 20200704_20085_20139_5
Checking range [254 .. 256] from part 20200704_20085_20139_5
Checking range [254 .. 255] from part 20200704_20085_20139_5
Checking range [255 .. 256] from part 20200704_20085_20139_5
Checking range [256 .. 260] from part 20200704_20085_20139_5
Checking range [256 .. 258] from part 20200704_20085_20139_5
Checking range [256 .. 257] from part 20200704_20085_20139_5
Checking range [257 .. 258] from part 20200704_20085_20139_5
Checking range [258 .. 260] from part 20200704_20085_20139_5
Checking range [258 .. 259] from part 20200704_20085_20139_5
Checking range [259 .. 260] from part 20200704_20085_20139_5
Checking range [260 .. 269] from part 20200704_20085_20139_5
Checking range [260 .. 264] from part 20200704_20085_20139_5
Checking range [260 .. 262] from part 20200704_20085_20139_5
Checking range [260 .. 261] from part 20200704_20085_20139_5
Checking range [261 .. 262] from part 20200704_20085_20139_5
Checking range [262 .. 264] from part 20200704_20085_20139_5
Checking range [262 .. 263] from part 20200704_20085_20139_5
Checking range [263 .. 264] from part 20200704_20085_20139_5
Checking range [264 .. 269] from part 20200704_20085_20139_5
Checking range [264 .. 266] from part 20200704_20085_20139_5
Checking range [264 .. 265] from part 20200704_20085_20139_5
Checking range [265 .. 266] from part 20200704_20085_20139_5
Checking range [266 .. 269] from part 20200704_20085_20139_5
Checking range [266 .. 267] from part 20200704_20085_20139_5
Checking range [267 .. 269] from part 20200704_20085_20139_5
Checking range [267 .. 268] from part 20200704_20085_20139_5
Checking range [268 .. 269] from part 20200704_20085_20139_5
Checking range [269 .. 538] from part 20200704_20085_20139_5
Checking range [269 .. 403] from part 20200704_20085_20139_5
Checking range [269 .. 336] from part 20200704_20085_20139_5
Checking range [269 .. 302] from part 20200704_20085_20139_5
Checking range [269 .. 285] from part 20200704_20085_20139_5
Checking range [269 .. 277] from part 20200704_20085_20139_5
Checking range [269 .. 273] from part 20200704_20085_20139_5
Checking range [269 .. 271] from part 20200704_20085_20139_5
Checking range [269 .. 270] from part 20200704_20085_20139_5
Checking range [270 .. 271] from part 20200704_20085_20139_5
Checking range [271 .. 273] from part 20200704_20085_20139_5
Checking range [271 .. 272] from part 20200704_20085_20139_5
Checking range [272 .. 273] from part 20200704_20085_20139_5
Checking range [273 .. 277] from part 20200704_20085_20139_5
Checking range [273 .. 275] from part 20200704_20085_20139_5
Checking range [273 .. 274] from part 20200704_20085_20139_5
Checking range [274 .. 275] from part 20200704_20085_20139_5
Checking range [275 .. 277] from part 20200704_20085_20139_5
Checking range [275 .. 276] from part 20200704_20085_20139_5
Checking range [276 .. 277] from part 20200704_20085_20139_5
Checking range [277 .. 285] from part 20200704_20085_20139_5
Checking range [277 .. 281] from part 20200704_20085_20139_5
Checking range [277 .. 279] from part 20200704_20085_20139_5
Checking range [277 .. 278] from part 20200704_20085_20139_5
Checking range [278 .. 279] from part 20200704_20085_20139_5
Checking range [279 .. 281] from part 20200704_20085_20139_5
Checking range [279 .. 280] from part 20200704_20085_20139_5
Checking range [280 .. 281] from part 20200704_20085_20139_5
Checking range [281 .. 285] from part 20200704_20085_20139_5
Checking range [281 .. 283] from part 20200704_20085_20139_5
Checking range [281 .. 282] from part 20200704_20085_20139_5
Checking range [282 .. 283] from part 20200704_20085_20139_5
Checking range [283 .. 285] from part 20200704_20085_20139_5
Checking range [285 .. 302] from part 20200704_20085_20139_5
Checking range [302 .. 336] from part 20200704_20085_20139_5
Checking range [336 .. 403] from part 20200704_20085_20139_5
Checking range [403 .. 538] from part 20200704_20085_20139_5

[bobrik]

My understanding is that the strategy with PK range search is to do a tree search and cut off branches that cannot contain the requested PK range. For a query that matches the whole part, we need to recurse into every leaf, making it cost O(n).

I think it would be more efficient to:

1. Do a binary search for the first PK range that satisfies the start of the query.
2. Do a binary search for the last PK range that satisfies the end of the query.

Which should be an O(2 log n) operation.

_I didn't want to send this comment, that was my scratch pad for notes. Leaving it for posterity._

[bobrik]

I made a patch based on my previous comment. It's geared towards queries for continuous PK ranges, and it's too ugly to show in public, but it works for my use case.

Found regular ranges for part 20200707_52684_52918_6 with 1775 steps (2296 total marks in the part)
Regular ranges for part 20200707_52684_52918_6[1]: {1302, 2182}
Found optimized ranges for part 20200707_52684_52918_6 with 24 steps (2296 total marks in the part)
Optimized ranges for part 20200707_52684_52918_6[1]: {1302, 2182}
Found regular ranges for part 20200707_52919_53012_6 with 791 steps (919 total marks in the part)
Regular ranges for part 20200707_52919_53012_6[1]: {483, 871}
Found optimized ranges for part 20200707_52919_53012_6 with 22 steps (919 total marks in the part)
Optimized ranges for part 20200707_52919_53012_6[1]: {483, 871}
Found regular ranges for part 20200707_53013_53029_3 with 129 steps (168 total marks in the part)
Regular ranges for part 20200707_53013_53029_3[1]: {100, 158}
Found optimized ranges for part 20200707_53013_53029_3 with 17 steps (168 total marks in the part)
Optimized ranges for part 20200707_53013_53029_3[1]: {100, 158}
Found regular ranges for part 20200707_53030_53040_2 with 73 steps (109 total marks in the part)
Regular ranges for part 20200707_53030_53040_2[1]: {67, 101}
Found optimized ranges for part 20200707_53030_53040_2 with 15 steps (109 total marks in the part)
Optimized ranges for part 20200707_53030_53040_2[1]: {67, 101}
Found regular ranges for part 20200707_53041_53041_0 with 11 steps (11 total marks in the part)
Regular ranges for part 20200707_53041_53041_0[1]: {5, 10}
Found optimized ranges for part 20200707_53041_53041_0 with 9 steps (11 total marks in the part)
Optimized ranges for part 20200707_53041_53041_0[1]: {5, 10}
Found regular ranges for part 20200707_53042_53042_0 with 11 steps (11 total marks in the part)
Regular ranges for part 20200707_53042_53042_0[1]: {5, 10}
Found optimized ranges for part 20200707_53042_53042_0 with 9 steps (11 total marks in the part)
Optimized ranges for part 20200707_53042_53042_0[1]: {5, 10}
Found regular ranges for part 20200707_53043_53043_0 with 11 steps (11 total marks in the part)
Regular ranges for part 20200707_53043_53043_0[1]: {6, 9}
Found optimized ranges for part 20200707_53043_53043_0 with 9 steps (11 total marks in the part)
Optimized ranges for part 20200707_53043_53043_0[1]: {6, 9}
Found regular ranges for part 20200707_53044_53044_0 with 17 steps (11 total marks in the part)
Regular ranges for part 20200707_53044_53044_0[1]: {4, 10}
Found optimized ranges for part 20200707_53044_53044_0 with 10 steps (11 total marks in the part)
Optimized ranges for part 20200707_53044_53044_0[1]: {4, 10}
Found regular ranges for part 20200707_53045_53045_0 with 17 steps (11 total marks in the part)
Regular ranges for part 20200707_53045_53045_0[1]: {4, 10}
Found optimized ranges for part 20200707_53045_53045_0 with 10 steps (11 total marks in the part)
Optimized ranges for part 20200707_53045_53045_0[1]: {4, 10}
Found regular ranges for part 20200707_53046_53056_2 with 111 steps (109 total marks in the part)
Regular ranges for part 20200707_53046_53056_2[1]: {50, 101}
Found optimized ranges for part 20200707_53046_53056_2 with 16 steps (109 total marks in the part)
Optimized ranges for part 20200707_53046_53056_2[1]: {50, 101}

Here a step is a call into either key_condition.mayBeTrueAfter() or key_condition.mayBeTrueInRange(). Regular ranges come from what Clickhouse does now, optimized is my attempt at speeding it up.

This seems like a very nice win, even though I'm not doing a proper binary search, merely emulating it for a range.

So far my understanding is that the ideal generalized solution would be to:

1. Split KeyCondition into multiple conditions for continuous PK ranges.
2. For each continuous condition to O(2 logn) lookup for matching marks.
3. Merge ranges from the previous steps.

Step 2 can be parallelized if necessary. Data skipping indices can probably engage at the same time to allow parallelism.

Does this make sense? There may be a state of the art technique for this sort of thing, but I'm not really an expert in the field.

[bobrik]

I've tried my change on a production dataset.

24h query, before and after (aligned for visual aid):

Read 4562944 rows, 148.05 MiB in 45.19249672 sec.,   100966 rows/sec.,   3.28 MiB/sec.
Read 4183040 rows, 135.78 MiB in 0.196279627 sec., 21311636 rows/sec., 691.75 MiB/sec.

[bobrik]

See #12277 for my poor attempt at making a specialized case of this to work.

[bobrik]

In #12589 I attempt to parallelize skipping indices and PK selection stages between parts.