Pipeline :2 (host=TNetworkAddress(hostname:192.168.183.145, port:9050)):
PipelineTask (index=1):(ExecTime: 13sec603ms)
- CoreChangeTimes: 1
- ExecuteTime: 6sec801ms
- CloseTime: 427.198us
- GetBlockTime: 118.170us
- OpenTime: 6sec800ms
- PrepareTime: 115.941us
- SinkTime: 423.35us
- GetBlockCounter: 6
- NumScheduleTimes: 5
- NumYieldTimes: 0
- TaskCpuTime: 5.376ms
- WaitWorkerTime: 141.645us
LOCAL_EXCHANGE_SINK_OPERATOR (PASSTHROUGH) (id=-2):(ExecTime: 423.538us)
- CloseTime: 0ns
- ComputeHashValueTime: 0ns
- DistributeDataTime: 0ns
- ExecTime: 423.538us
- InitTime: 1.677us
- InputRows: 226
- MemoryUsage:
- PeakMemoryUsage: 0.00
- OpenTime: 1.192us
- PendingFinishDependency: 0ns
- WaitForDependency[LOCAL_EXCHANGE_SINK_DEPENDENCY]Time: 0ns
OLAP_SCAN_OPERATOR (id=0. nereids_id=608. table name = analysis_date_category_merchant(analysis_date_category_merchant)):(ExecTime: 6sec841ms)
- RuntimeFilters: :
- PushDownPredicates: [{category_id IN [1]}, {analysis_date >= [2024-12-27]}, {analysis_date <= [2025-01-02]}, {__DORIS_DELETE_SIGN__ IN [0]}]
- KeyRanges: ScanKeys:
- TabletIds: [3521375, 3521377, 3521391]
- UseSpecificThreadToken: False
- AcquireRuntimeFilterTime: 472ns
- BlocksProduced: 3
- CloseTime: 424.88us
- ExecTime: 6sec841ms
- InitTime: 72.314us
- KeyRangesNum: 0
- MaxScannerThreadNum: 3
- MemoryUsage:
- PeakMemoryUsage: 0.00
- NumScanners: 3
- OpenTime: 6sec800ms
- ProcessConjunctTime: 78.411us
- ProjectionTime: 0ns
- RowsProduced: 226
- RowsRead: 226
- RuntimeFilterInfo:
- ScannerWorkerWaitTime: 214.28us
- TabletNum: 3
- TotalReadThroughput: 0
- WaitForDependency[OLAP_SCAN_OPERATOR_DEPENDENCY]Time: 39.533ms
- WaitForRuntimeFilter: 0ns
VScanner:
- ReadColumns: [analysis_date, category_id, merchant_user_id, transaction_money, deal_money, recharge_money, __DORIS_DELETE_SIGN__]
- PreEvaluatePredicates:
ComparisonPredicateBase(STRING, EQ), column_id=2, opposite=false
ComparisonPredicateBase(STRING, GE), column_id=1, opposite=false
ComparisonPredicateBase(TINYINT, EQ), column_id=17, opposite=false
- PerScannerRunningTime: [36.276ms, 37.779ms, 36.944ms, ]
- PerScannerRowsRead: [72, 83, 71, ]
- PerScannerWaitTime: [66.559us, 44.731us, 102.738us, ]
- PerScannerProjectionTime: [92.035us, 50.889us, 66.568us, ]
- BlockConvertTime: 0ns
- BlockFetchTime: 116.966us
- DeleteBitmapGetAggTime: 352.657us
- MemoryUsage:
- FreeBlocks: 17.00 KB
- NewlyCreateFreeBlocksNum: 6
- NumScaleUpScanners: 0
- ReaderInitTime: 5.698ms
- RowsDelFiltered: 96
- ScannerBatchWaitTime: 0ns
- ScannerConvertBlockTime: 0ns
- ScannerCpuTime: 17.556ms
- ScannerCtxSchedTime: 155.148us
- ScannerFilterTime: 26.590us
- ScannerGetBlockTime: 110.684ms
- ScannerInitTime: 6sec800ms
- ScannerSchedCount: 3
- SyncRowsetTime: 2.403ms