麻烦帮看下存算分离3.1.2版本,为什么首次查询某个表的某个partition会很慢,第二次就很快

Viewed 2
  • ReadColumns: [@timestamp, @seq, DORIS_ROWID_COL]
    - PerScannerRunningTime: [439.674ms, 419.620ms, 518.993ms, 147.095ms, 421.989ms, 415.661ms, 327.951ms, 478.331ms, 336.673ms, 505.939ms, 340.853ms, 238.488ms, 212.906ms, 357.237ms, 260.266ms, 261.009ms, 461.924ms, 206.156ms, 331.418ms, 226.353ms, 247.479ms, 103.751ms, 451.957ms, 311.798ms, 606.045ms, 321.704ms, 262.386ms, 320.675ms, 222.548ms, 395.026ms, 372.716ms, 409.800ms, 83.728ms, 493.849ms, 360.501ms, 388.730ms, 250.727ms, 338.471ms, 356.409ms, 389.561ms, 192.226ms, 745.765ms, 495.105ms, 413.943ms, 403.133ms, 339.962ms, 433.904ms, 291.374ms, 401.606ms, 374.440ms, 392.899ms, 150.167ms, ]
    - PerScannerRowsRead: [20, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 20, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, ]
    - PerScannerWaitTime: [30.613us, 27.719us, 47.639us, 53.235us, 35.306us, 62.218us, 55.047us, 45.856us, 50.834us, 40.467us, 36.352us, 25.993us, 32.919us, 32.585us, 39.425us, 26.545us, 37.102us, 50.772us, 35.454us, 46.041us, 49.026us, 56.598us, 22.416us, 25.002us, 39.180us, 28.669us, 45.900us, 42.868us, 50.118us, 44.257us, 24.014us, 31.689us, 34.010us, 54.090us, 28.952us, 58.589us, 54.939us, 61.126us, 21.171us, 29.112us, 14.514us, 25.283us, 45.764us, 36.166us, 34.403us, 29.415us, 30.588us, 60.546us, 65.299us, 25.970us, 44.412us, 23.561us, ]
    - PerScannerProjectionTime: [0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, 0.000ns, ]
    - EOS: True
    - BlockFetchTime: 448.918ms
    - BlockReaderBuildHeapInitTimer: 3.312us
    - BlockReaderRsReadersInitTimer: 197.725us
    - BlockReaderVcollectIterInitTimer: 136.645us
    - DeleteBitmapGetAggTime: 0ns
    - NewlyCreateFreeBlocksNum: 52
    - NumScaleUpScanners: 0
    - PeakRunningScanner: 0
    - PeakRunningScannerPeak: 52
    - ReaderInitTime: 1.231ms
    - RowsDelFiltered: 0
    - RowsetReaderCreateIteratorsTimer: 465.481us
    - RowsetReaderGetSegmentIteratorsTimer: 2.330ms
    - RowsetReaderInitIteratorsTimer: 17sec778ms
    - RowsetReaderLoadSegmentsTimer: 613.184us
    - ScannerCpuTime: 241.329ms
    - ScannerFilterTime: 10.55us
    - ScannerGetBlockTime: 18sec230ms
    - ScannerInitTime: 34sec58ms
    - ScannerSchedCount: 52
    - SegmentCreateColumnReadersTimer: 2.998ms
    - SegmentIteratorInitBitmapIndexIteratorsTimer: 270.55us
    - SegmentIteratorInitInvertedIndexIteratorsTimer: 142.257us
    - SegmentIteratorInitReturnColumnIteratorsTimer: 2.37ms
    - SegmentIteratorInitTimer: 4.135ms
    - SegmentLoadIndexTimer: 17sec770ms
    - SyncRowsetTime: 7.867ms
    - SyncRowsetGetLocalDeleteBitmapRowsetsCount: 0
    - SyncRowsetGetRemoteDeleteBitmapBytes: 0.00
    - SyncRowsetGetRemoteDeleteBitmapKeyCount: 0
    - SyncRowsetGetRemoteDeleteBitmapRowsetsCount: 0
    - SyncRowsetGetRemoteDeleteBitmapRpcTime: 0ns
    - SyncRowsetGetRemoteRowsetsCount: 226
    - SyncRowsetGetRemoteRowsetsRpcTime: 39.121ms
    - SyncRowsetGetRemoteTabletMetaRpcTime: 24.663ms
    - SyncRowsetTabletMetaCacheHitCount: 0
    - SyncRowsetTabletMetaCacheMissCount: 17
    - SyncRowsetTabletsRowsetsTotatCount: 226
    - TabletReaderCaptureRsReadersTimer: 44.422us
    - TabletReaderInitConditionsParamTimer: 77.925us
    - TabletReaderInitDeleteConditionParamTimer: 17.724us
    - TabletReaderInitKeysParamTimer: 594.42us
    - TabletReaderInitOrderbyKeysParamTimer: 9.726us
    - TabletReaderInitReturnColumnsTimer: 29.465us
    - TabletReaderInitTimer: 768.723us
    SegmentIterator:
    - BitmapIndexFilterTimer: 2.386us
    - BlockInitSeekCount: 80
    - BlockInitSeekTime: 427.454ms
    - BlockInitTime: 446.197ms
    - BlockLoadTime: 448.781ms
    - BlocksLoad: 230
    - CachedPagesNum: 0
    - CollectIteratorMergeTime: 0ns
    - CompressedBytesRead: 1.76 MB
    - DecompressorTimer: 238.701us
    - ExprFilterEvalTime: 0ns
    - FileCache: 0ns
    - BytesScannedFromCache: 0.00
    - BytesScannedFromRemote: 0.00
    - BytesWriteIntoCache: 0.00
    - CacheGetOrSetTimer: 6.65ms
    - GetTimer: 4.807ms
    - InvertedIndexBytesScannedFromCache: 0.00
    - InvertedIndexBytesScannedFromRemote: 0.00
    - InvertedIndexIOTimer: 0ns
    - InvertedIndexLocalIOUseTimer: 0ns
    - InvertedIndexNumLocalIOTotal: 0
    - InvertedIndexNumRemoteIOTotal: 0
    - InvertedIndexRemoteIOUseTimer: 0ns
    - LocalIOUseTimer: 29.777ms
    - LockWaitTimer: 772.285us
    - NumLocalIOTotal: 32
    - NumRemoteIOTotal: 200
    - NumSkipCacheIOTotal: 0
    - ReadCacheFileDirectlyTimer: 0ns
    - RemoteIOUseTimer: 18sec114ms
    - SetTimer: 16.548us
    - WriteCacheIOUseTimer: 0ns
    - GenerateRowRangeByBloomFilterIndexTime: 1.543us
    - GenerateRowRangeByColumnConditionsTime: 10.912ms
    - GenerateRowRangeByDictTime: 1.668us
    - GenerateRowRangeByKeysTime: 430.901ms
    - GenerateRowRangeByZoneMapIndexTime: 10.781ms
    - IOTimer: 427.122ms
    - InvertedIndexAnalyzerTime: 0ns
    - InvertedIndexDowngradeCount: 0
    - InvertedIndexFilterTime: 0ns
    - InvertedIndexLookupTimer: 0ns
    - InvertedIndexQueryBitmapCopyTime: 0ns
    - InvertedIndexQueryCacheHit: 0
    - InvertedIndexQueryCacheMiss: 0
    - InvertedIndexQueryNullBitmapTime: 0ns
    - InvertedIndexQueryTime: 0ns
    - InvertedIndexSearcherCacheHit: 0
    - InvertedIndexSearcherCacheMiss: 0
    - InvertedIndexSearcherOpenTime: 0ns
    - InvertedIndexSearcherSearchExecTime: 0ns
    - InvertedIndexSearcherSearchInitTime: 0ns
    - InvertedIndexSearcherSearchTime: 0ns
    - LazyReadSeekCount: 0
    - LazyReadSeekTime: 0ns
    - LazyReadTime: 0ns
    - NonPredicateColumnReadTime: 0ns
    - NumSegmentFiltered: 8
    - NumSegmentTotal: 238
    - OutputColumnTime: 1.263us
    - OutputIndexResultColumnTime: 0ns
    - PredicateColumnReadSeekCount: 24
    - PredicateColumnReadSeekTime: 1.123ms
    - PredicateColumnReadTime: 1.240ms
    - RowsBitmapIndexFiltered: 0
    - RowsBloomFilterFiltered: 0
    - RowsConditionsFiltered: 6.823936M (6823936)
    - RowsDictFiltered: 0
    - RowsInvertedIndexFiltered: 0
    - RowsKeyRangeFiltered: 3.47386775B (3473867750)
    - RowsShortCircuitPredFiltered: 0
    - RowsShortCircuitPredInput: 0
    - RowsStatsFiltered: 6.823936M (6823936)
    - RowsVectorPredFiltered: 0
    - RowsVectorPredInput: 0
    - RowsZoneMapRuntimePredicateFiltered: 6.823936M (6823936)
    - ShortPredEvalTime: 0ns
    - TotalPagesNum: 40
    - UncompressedBytesRead: 0.00
    - VectorPredEvalTime: 0ns
0 Answers