yusong-md opened a new issue, #24126: URL: https://github.com/apache/doris/issues/24126
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Doris1.2.4.1 ### What's Wrong? Doris集群配置 3台物理机：64核CPU、256G内存、SSD盘、3个FE、4个BE 创建表 CREATE TABLE `ads_lgp_dev_oper_index_agg` ( `exp_id` int(11) NULL COMMENT '实验id', `st_id` int(11) NULL COMMENT '策略id', `datecode` date NULL COMMENT '日期', `timedim` varchar(20) NULL COMMENT '日期粒度：1-日，2-周，3-月', `timecode` varchar(128) NULL COMMENT '日期，对应timedim的日期', `business` varchar(128) NULL COMMENT '业务标识', `featurecode` varchar(128) NULL COMMENT '机型特征码', `udostype` varchar(128) NULL COMMENT '操作系统', `uddevicetype` varchar(128) NULL COMMENT '设备类别', `uddevicecode` varchar(128) NULL COMMENT '设备型号', `bigversion` varchar(128) NULL COMMENT 'JUUI版本', `license` varchar(128) NULL COMMENT '内容平台', `otttvcontrolparty` varchar(128) NULL COMMENT '播控牌照', `index_type` varchar(128) NULL COMMENT '指标类型', `index_type_name` varchar(128) NULL COMMENT '指标类型名称', `deviceid` varchar(128) REPLACE NULL COMMENT '设备id', `device_bitmap` bitmap BITMAP_UNION NULL COMMENT '设备bitmap', `times` bigint(20) SUM NULL COMMENT '次数', `duration` double SUM NULL COMMENT '时长(秒)', `sumfee` bigint(20) SUM NULL COMMENT '金额(分)' ) ENGINE=OLAP AGGREGATE KEY(`exp_id`, `st_id`, `datecode`, `timedim`, `timecode`, `business`, `featurecode`, `udostype`, `uddevicetype`, `uddevicecode`, `bigversion`, `license`, `otttvcontrolparty`, `index_type`, `index_type_name`) COMMENT 'OLAP' PARTITION BY RANGE(`datecode`) (PARTITION p20230830 VALUES [('2023-08-30'), ('2023-08-31')), PARTITION p20230831 VALUES [('2023-08-31'), ('2023-09-01')), PARTITION p20230901 VALUES [('2023-09-01'), ('2023-09-02')), PARTITION p20230902 VALUES [('2023-09-02'), ('2023-09-03')), PARTITION p20230903 VALUES [('2023-09-03'), ('2023-09-04')), PARTITION p20230904 VALUES [('2023-09-04'), ('2023-09-05')), PARTITION p20230905 VALUES [('2023-09-05'), ('2023-09-06')), PARTITION p20230906 VALUES [('2023-09-06'), ('2023-09-07')), PARTITION p20230907 VALUES [('2023-09-07'), ('2023-09-08')), PARTITION p20230908 VALUES [('2023-09-08'), ('2023-09-09')), PARTITION p20230909 VALUES [('2023-09-09'), ('2023-09-10')), PARTITION p20230910 VALUES [('2023-09-10'), ('2023-09-11')), PARTITION p20230911 VALUES [('2023-09-11'), ('2023-09-12')), PARTITION p20230912 VALUES [('2023-09-12'), ('2023-09-13'))) DISTRIBUTED BY HASH(`exp_id`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 2", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Etc/GMT", "dynamic_partition.start" = "-10", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 1", "dynamic_partition.buckets" = "32", "dynamic_partition.create_history_partition" = "true", "dynamic_partition.history_partition_num" = "365", "dynamic_partition.hot_partition_num" = "90", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "dynamic_partition.storage_medium" = "HDD", "in_memory" = "false", "storage_format" = "V2", "disable_auto_compaction" = "false" ); 创建物化视图 create materialized view advertiser_uv as select navid,datecode,license,timecode, navititle , sum(times) , bitmap_union(device_bitmap) as device_bitmap from deviceprofile.ads_arrange_home_dev_content group by datecode,timecode, navid, navititle, license 查询语句 select navid,navititle, datecode, license, sum(times) , bitmap_union_count(device_bitmap) from deviceprofile.ads_arrange_home_dev_content where navid = 350 and datecode>='2023-09-01' and datecode<='2023-09-06' group by datecode, navititle,license, navid; QueryProfile Query: Summary: - Start Time: 2023-09-08 10:52:25 - End Time: 2023-09-08 10:52:43 - Total: 17s902ms - Query State: EOF - Job ID: N/A - Query ID: 6e1c6a3b36344ed7-8afd25e830e8d69f - Query Type: Query - Doris Version: doris-1.2.4-1 - User: default_cluster:only_read_user - Default Db: - Sql Statement: select navid,navititle, datecode, license, sum(times) , bitmap_union_count(device_bitmap) from deviceprofile.ads_arrange_home_dev_content where navid = 350 and datecode>='2023-09-01' and datecode<='2023-09-06' group by datecode, navititle,license, navid - Is Cached: No - Total Instances Num: 7 - Instances Num Per BE: {192.168.18.44:9025=3, 192.168.18.46:9025=2, 192.168.18.47:9025=2} - Trace ID: Execution Summary: - Analysis Time: 12.163ms - Plan Time: 40.472ms - Schedule Time: 98.758ms - Fetch Result Time: 17s740ms - Write Result Time: 258.950us - Wait and Fetch Result Time: 17s750ms Execution Profile 6e1c6a3b36344ed7-8afd25e830e8d69f:(Active: 17s902ms, % non-child: 100.00%) Fragment 0: Instance 6e1c6a3b36344ed7-8afd25e830e8d6a6 (host=TNetworkAddress(hostname:192.168.18.44, port:9060)):(Active: 17s744ms, % non-child: 0.00%) - DoriBeVersion: Unknown - FragmentCpuTime: 743.244us - RowsProduced: 5 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataBufferSender (dst_fragment_instance_id=6e1c6a3b36344ed7--7502da17cf17295a): - AppendBatchTime: 462.462us - ResultRendTime: 375.803us - TupleConvertTime: 20.401us - NumSentRows: 5 VEXCHANGE_NODE (id=4):(Active: 17s744ms, % non-child: 99.12%) - BytesReceived: 187.00 B - DataArrivalWaitTime: 17s744ms - DecompressBytes: 188.00 B - DecompressTime: 6.334us - DeserializeRowBatchTimer: 50.119us - FirstBatchArrivalWaitTime: 17s319ms - PeakMemoryUsage: 5.82 KB - ProjectionTime: 0ns - RowsReturned: 5 - RowsReturnedRate: 0 - SendersBlockedTotalTimer(*): 0ns Fragment 1: Instance 6e1c6a3b36344ed7-8afd25e830e8d6a5 (host=TNetworkAddress(hostname:192.168.18.47, port:9060)):(Active: 17s740ms, % non-child: 0.01%) - DoriBeVersion: Unknown - FragmentCpuTime: 8s886ms - RowsProduced: 2 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=4, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a6"}]):(Active: 294.300us, % non-child: 0.00%) - BlocksSent: 2 - BrpcSendTime: 1.508ms - BrpcSendTime.Wait: 2.22ms - BytesSent: 129.00 B - CompressTime: 12.6us - IgnoreRows: 0 - LocalBytesSent: 0.00 - LocalSendTime: 0ns - LocalSentRows: 0 - OverallThroughput: 428.0546875 KB/sec - PeakMemoryUsage: 3.13 KB - SerializeBatchTime: 32.116us - SplitBlockDistributeByChannelTime: 0ns - SplitBlockHashComputeTime: 0ns - UncompressedRowBatchSize: 188.00 B VAGGREGATION_NODE (id=3):(Active: 17s737ms, % non-child: 49.95%) - BuildTime: 0ns - DeserializeDataTime: 6s642ms - ExecTime: 0ns - ExprTime: 0ns - GetResultsTime: 59.163ms - HashTableComputeTime: 126.923us - HashTableInputCount: 2 - HashTableIterateTime: 440ns - HashTableSize: 0 - InsertKeysToColumnTime: 287.52us - MaxRowSizeInBytes: 47 - MergeTime: 8s874ms - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 2 - RowsReturnedRate: 0 - SerializeDataTime: 0ns - SerializeKeyTime: 96.730us - SerializeResultTime: 0ns - StreamingAggTime: 0ns VEXCHANGE_NODE (id=2):(Active: 8s795ms, % non-child: 49.13%) - BytesReceived: 42.30 MB - DataArrivalWaitTime: 8s787ms - DecompressBytes: 83.06 MB - DecompressTime: 57.904ms - DeserializeRowBatchTimer: 90.131ms - FirstBatchArrivalWaitTime: 6s830ms - PeakMemoryUsage: 629.72 KB - ProjectionTime: 0ns - RowsReturned: 2 - RowsReturnedRate: 0 - SendersBlockedTotalTimer(*): 135.696us Instance 6e1c6a3b36344ed7-8afd25e830e8d6a3 (host=TNetworkAddress(hostname:192.168.18.44, port:9060)):(Active: 17s320ms, % non-child: 0.00%) - DoriBeVersion: Unknown - FragmentCpuTime: 4s289ms - RowsProduced: 3 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=4, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a6"}]):(Active: 54.258us, % non-child: 0.00%) - BlocksSent: 2 - BrpcSendTime: 72.696us - BrpcSendTime.Wait: 469.824us - BytesSent: 0.00 - CompressTime: 0ns - IgnoreRows: 0 - LocalBytesSent: 192.00 B - LocalSendTime: 18.876us - LocalSentRows: 3 - OverallThroughput: 0.0 /sec - PeakMemoryUsage: 3.13 KB - SerializeBatchTime: 0ns - SplitBlockDistributeByChannelTime: 0ns - SplitBlockHashComputeTime: 0ns - UncompressedRowBatchSize: 0.00 VAGGREGATION_NODE (id=3):(Active: 17s319ms, % non-child: 24.03%) - BuildTime: 0ns - DeserializeDataTime: 3s332ms - ExecTime: 0ns - ExprTime: 0ns - GetResultsTime: 29.641ms - HashTableComputeTime: 87.655us - HashTableInputCount: 3 - HashTableIterateTime: 486ns - HashTableSize: 0 - InsertKeysToColumnTime: 291.809us - MaxRowSizeInBytes: 47 - MergeTime: 4s261ms - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 3 - RowsReturnedRate: 0 - SerializeDataTime: 0ns - SerializeKeyTime: 51.764us - SerializeResultTime: 0ns - StreamingAggTime: 0ns VEXCHANGE_NODE (id=2):(Active: 13s18ms, % non-child: 72.72%) - BytesReceived: 69.09 MB - DataArrivalWaitTime: 13s18ms - DecompressBytes: 100.99 MB - DecompressTime: 63.975ms - DeserializeRowBatchTimer: 109.287ms - FirstBatchArrivalWaitTime: 295.203ms - PeakMemoryUsage: 811.09 KB - ProjectionTime: 0ns - RowsReturned: 3 - RowsReturnedRate: 0 - SendersBlockedTotalTimer(*): 0ns Instance 6e1c6a3b36344ed7-8afd25e830e8d6a4 (host=TNetworkAddress(hostname:192.168.18.46, port:9060)):(Active: 12s910ms, % non-child: 0.01%) - DoriBeVersion: Unknown - FragmentCpuTime: 286.689us - RowsProduced: 0 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=4, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a6"}]):(Active: 61.137us, % non-child: 0.00%) - BlocksSent: 1 - BrpcSendTime: 113.906us - BrpcSendTime.Wait: 1.87ms - BytesSent: 0.00 - CompressTime: 0ns - IgnoreRows: 0 - LocalBytesSent: 0.00 - LocalSendTime: 0ns - LocalSentRows: 0 - OverallThroughput: 0.0 /sec - PeakMemoryUsage: 3.13 KB - SerializeBatchTime: 0ns - SplitBlockDistributeByChannelTime: 0ns - SplitBlockHashComputeTime: 0ns - UncompressedRowBatchSize: 0.00 VAGGREGATION_NODE (id=3):(Active: 12s909ms, % non-child: 0.00%) - BuildTime: 0ns - DeserializeDataTime: 0ns - ExecTime: 0ns - ExprTime: 0ns - GetResultsTime: 20.105us - HashTableComputeTime: 0ns - HashTableInputCount: 0 - HashTableIterateTime: 160ns - HashTableSize: 0 - InsertKeysToColumnTime: 3.862us - MaxRowSizeInBytes: 0 - MergeTime: 0ns - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 0 - RowsReturnedRate: 0 - SerializeDataTime: 0ns - SerializeKeyTime: 0ns - SerializeResultTime: 0ns - StreamingAggTime: 0ns VEXCHANGE_NODE (id=2):(Active: 12s909ms, % non-child: 72.11%) - BytesReceived: 0.00 - DataArrivalWaitTime: 12s909ms - DecompressBytes: 0.00 - DecompressTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 12s909ms - PeakMemoryUsage: 2.66 KB - ProjectionTime: 0ns - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTotalTimer(*): 0ns Fragment 2: Instance 6e1c6a3b36344ed7-8afd25e830e8d6a2 (host=TNetworkAddress(hostname:192.168.18.47, port:9060)):(Active: 13s127ms, % non-child: 2.52%) - DoriBeVersion: Unknown - FragmentCpuTime: 9s19ms - RowsProduced: 2 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=2, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a3", "6e1c6a3b36344ed7-8afd25e830e8d6a4", "6e1c6a3b36344ed7-8afd25e830e8d6a5"}]):(Active: 104.323ms, % non-child: 0.58%) - BlocksSent: 3 - BrpcSendTime: 26.900ms - BrpcSendTime.Wait: 223.139ms - BytesSent: 51.32 MB - CompressTime: 177.583ms - IgnoreRows: 0 - LocalBytesSent: 97.43 MB - LocalSendTime: 162.204us - LocalSentRows: 1 - OverallThroughput: 491.9662981033325 MB/sec - PeakMemoryUsage: 256.13 MB - SerializeBatchTime: 201.248ms - SplitBlockDistributeByChannelTime: 104.218ms - SplitBlockHashComputeTime: 3.56us - UncompressedRowBatchSize: 100.99 MB VAGGREGATION_NODE (id=1):(Active: 12s572ms, % non-child: 49.93%) - ExecOption: Streaming Preaggregation - BuildTime: 7s22ms - DeserializeDataTime: 0ns - ExecTime: 7s19ms - ExprTime: 11.209us - GetResultsTime: 977.262ms - HashTableComputeTime: 59.802us - HashTableInputCount: 7 - HashTableIterateTime: 493ns - HashTableSize: 0 - InsertKeysToColumnTime: 11.618ms - MaxRowSizeInBytes: 47 - MergeTime: 0ns - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 2 - RowsReturnedRate: 0 - SerializeDataTime: 965.603ms - SerializeKeyTime: 24.749us - SerializeResultTime: 977.859ms - StreamingAggTime: 0ns VNewOlapScanNode(ads_arrange_home_dev_content) (id=0):(Active: 3s632ms, % non-child: 20.29%) - PushDownPredicates: [] - KeyRanges: ScanKeys:ScanKey=[350,2023-09-01 : 350,2023-09-06] - TabletIds: [120908, 121100] - AcuireRuntimeFilterTime: 713ns - GetNextTime: 3s629ms - MaxScannerThreadNum: 2 - NewlyCreateFreeBlocksNum: 0 - NumDiskAccess: 1 - NumScanners: 2 - PeakMemoryUsage: 0.00 - PreAllocFreeBlocksNum: 34 - ProcessConjunctTime: 132.689us - ProjectionTime: 0ns - RowsRead: 7 - RowsReturned: 7 - RowsReturnedRate: 1 - ScannerBatchWaitTime: 3s629ms - ScannerCtxSchedCount: 2 - ScannerSchedCount: 2 - ScannerWorkerWaitTime: 504.509us - TabletNum: 2 - TotalReadThroughput: 0 VScanner: - BlockConvertTime: 0ns - BlockFetchTime: 7s364ms - ReaderInitTime: 0ns - RowsDelFiltered: 0 - ScannerConvertBlockTime: 0ns - ScannerCpuTime: 7s586ms - ScannerFilterTime: 1.370us - ScannerGetBlockTime: 404.296us - ScannerInitTime: 223.731us - ScannerPrefilterTime: 0ns SegmentIterator: - BitmapIndexFilterTimer: 2.263us - BlockConditionsFilteredTime: 6.271us - BlockInitSeekCount: 16 - BlockInitSeekTime: 155.782us - BlockInitTime: 483.214us - BlockLoadTime: 7s364ms - BlocksLoad: 16 - CachedPagesNum: 0 - CompressedBytesRead: 110.25 MB - DecompressorTimer: 221.807ms - FirstReadSeekCount: 7 - FirstReadSeekTime: 343.603ms - FirstReadTime: 7s362ms - IOTimer: 101.444ms - LazyReadSeekCount: 0 - LazyReadSeekTime: 0ns - LazyReadTime: 0ns - NumSegmentFiltered: 0 - NumSegmentTotal: 9 - OutputColumnTime: 3.910us - RawRowsRead: 7 - RowsBitmapIndexFiltered: 0 - RowsBloomFilterFiltered: 0 - RowsConditionsFiltered: 0 - RowsKeyRangeFiltered: 24 - RowsShortCircuitPredFiltered: 0 - RowsShortCircuitPredInput: 0 - RowsStatsFiltered: 0 - RowsVectorPredFiltered: 0 - RowsVectorPredInput: 0 - ShortPredEvalTime: 0ns - TotalPagesNum: 56 - UncompressedBytesRead: 216.21 MB - VectorPredEvalTime: 0ns Instance 6e1c6a3b36344ed7-8afd25e830e8d6a0 (host=TNetworkAddress(hostname:192.168.18.44, port:9060)):(Active: 6s834ms, % non-child: 1.98%) - DoriBeVersion: Unknown - FragmentCpuTime: 3s297ms - RowsProduced: 1 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=2, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a3", "6e1c6a3b36344ed7-8afd25e830e8d6a4", "6e1c6a3b36344ed7-8afd25e830e8d6a5"}]):(Active: 41.619ms, % non-child: 0.23%) - BlocksSent: 3 - BrpcSendTime: 14.184ms - BrpcSendTime.Wait: 173.735ms - BytesSent: 42.30 MB - CompressTime: 147.927ms - IgnoreRows: 0 - LocalBytesSent: 0.00 - LocalSendTime: 0ns - LocalSentRows: 0 - OverallThroughput: 1016.4414615631104 MB/sec - PeakMemoryUsage: 128.07 MB - SerializeBatchTime: 167.209ms - SplitBlockDistributeByChannelTime: 41.573ms - SplitBlockHashComputeTime: 1.506us - UncompressedRowBatchSize: 83.06 MB VAGGREGATION_NODE (id=1):(Active: 6s437ms, % non-child: 18.23%) - ExecOption: Streaming Preaggregation - BuildTime: 2s610ms - DeserializeDataTime: 0ns - ExecTime: 2s610ms - ExprTime: 6.325us - GetResultsTime: 371.707ms - HashTableComputeTime: 56.715us - HashTableInputCount: 1 - HashTableIterateTime: 863ns - HashTableSize: 0 - InsertKeysToColumnTime: 1.554ms - MaxRowSizeInBytes: 47 - MergeTime: 0ns - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 1 - RowsReturnedRate: 0 - SerializeDataTime: 370.127ms - SerializeKeyTime: 29.466us - SerializeResultTime: 371.718ms - StreamingAggTime: 0ns VNewOlapScanNode(ads_arrange_home_dev_content) (id=0):(Active: 3s174ms, % non-child: 17.73%) - PushDownPredicates: [] - KeyRanges: ScanKeys:ScanKey=[350,2023-09-01 : 350,2023-09-06] - TabletIds: [121164] - AcuireRuntimeFilterTime: 4.285us - GetNextTime: 3s173ms - MaxScannerThreadNum: 1 - NewlyCreateFreeBlocksNum: 0 - NumDiskAccess: 1 - NumScanners: 1 - PeakMemoryUsage: 0.00 - PreAllocFreeBlocksNum: 17 - ProcessConjunctTime: 117.540us - ProjectionTime: 0ns - RowsRead: 1 - RowsReturned: 1 - RowsReturnedRate: 0 - ScannerBatchWaitTime: 3s173ms - ScannerCtxSchedCount: 1 - ScannerSchedCount: 1 - ScannerWorkerWaitTime: 0ns - TabletNum: 1 - TotalReadThroughput: 0 VScanner: - BlockConvertTime: 0ns - BlockFetchTime: 3s172ms - ReaderInitTime: 0ns - RowsDelFiltered: 0 - ScannerConvertBlockTime: 0ns - ScannerCpuTime: 3s163ms - ScannerFilterTime: 284ns - ScannerGetBlockTime: 272.344us - ScannerInitTime: 132.684us - ScannerPrefilterTime: 0ns SegmentIterator: - BitmapIndexFilterTimer: 299ns - BlockConditionsFilteredTime: 826ns - BlockInitSeekCount: 2 - BlockInitSeekTime: 33.777us - BlockInitTime: 81.347us - BlockLoadTime: 3s172ms - BlocksLoad: 2 - CachedPagesNum: 0 - CompressedBytesRead: 42.31 MB - DecompressorTimer: 85.802ms - FirstReadSeekCount: 1 - FirstReadSeekTime: 140.65ms - FirstReadTime: 3s172ms - IOTimer: 46.100ms - LazyReadSeekCount: 0 - LazyReadSeekTime: 0ns - LazyReadTime: 0ns - NumSegmentFiltered: 0 - NumSegmentTotal: 1 - OutputColumnTime: 1.585us - RawRowsRead: 1 - RowsBitmapIndexFiltered: 0 - RowsBloomFilterFiltered: 0 - RowsConditionsFiltered: 0 - RowsKeyRangeFiltered: 2 - RowsShortCircuitPredFiltered: 0 - RowsShortCircuitPredInput: 0 - RowsStatsFiltered: 0 - RowsVectorPredFiltered: 0 - RowsVectorPredInput: 0 - ShortPredEvalTime: 0ns - TotalPagesNum: 8 - UncompressedBytesRead: 83.06 MB - VectorPredEvalTime: 0ns Instance 6e1c6a3b36344ed7-8afd25e830e8d6a1 (host=TNetworkAddress(hostname:192.168.18.46, port:9060)):(Active: 295.862ms, % non-child: 0.56%) - DoriBeVersion: Unknown - FragmentCpuTime: 134.660ms - RowsProduced: 2 BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0.00 - MaxBlockSize: 8.00 MB - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns VDataStreamSender (dst_id=2, dst_fragments=[{"6e1c6a3b36344ed7-8afd25e830e8d6a3", "6e1c6a3b36344ed7-8afd25e830e8d6a4", "6e1c6a3b36344ed7-8afd25e830e8d6a5"}]):(Active: 23.945ms, % non-child: 0.13%) - BlocksSent: 3 - BrpcSendTime: 11.31ms - BrpcSendTime.Wait: 61.846ms - BytesSent: 17.77 MB - CompressTime: 12.484ms - IgnoreRows: 0 - LocalBytesSent: 0.00 - LocalSendTime: 0ns - LocalSentRows: 0 - OverallThroughput: 742.0892086029053 MB/sec - PeakMemoryUsage: 48.07 MB - SerializeBatchTime: 27.241ms - SplitBlockDistributeByChannelTime: 23.861ms - SplitBlockHashComputeTime: 3.188us - UncompressedRowBatchSize: 17.77 MB VAGGREGATION_NODE (id=1):(Active: 172.250ms, % non-child: 0.61%) - ExecOption: Streaming Preaggregation - BuildTime: 64.164ms - DeserializeDataTime: 0ns - ExecTime: 64.71ms - ExprTime: 9.531us - GetResultsTime: 35.995ms - HashTableComputeTime: 67.172us - HashTableInputCount: 2 - HashTableIterateTime: 436ns - HashTableSize: 0 - InsertKeysToColumnTime: 37.444us - MaxRowSizeInBytes: 47 - MergeTime: 0ns - PeakMemoryUsage: 0.00 - ProjectionTime: 0ns - RowsReturned: 2 - RowsReturnedRate: 11 - SerializeDataTime: 35.920ms - SerializeKeyTime: 32.556us - SerializeResultTime: 36.7ms - StreamingAggTime: 0ns VNewOlapScanNode(ads_arrange_home_dev_content) (id=0):(Active: 63.405ms, % non-child: 0.35%) - PushDownPredicates: [] - KeyRanges: ScanKeys:ScanKey=[350,2023-09-01 : 350,2023-09-06] - TabletIds: [121036, 120588] - AcuireRuntimeFilterTime: 937ns - GetNextTime: 60.906ms - MaxScannerThreadNum: 2 - NewlyCreateFreeBlocksNum: 0 - NumDiskAccess: 1 - NumScanners: 2 - PeakMemoryUsage: 0.00 - PreAllocFreeBlocksNum: 34 - ProcessConjunctTime: 130.634us - ProjectionTime: 0ns - RowsRead: 2 - RowsReturned: 2 - RowsReturnedRate: 31 - ScannerBatchWaitTime: 60.869ms - ScannerCtxSchedCount: 3 - ScannerSchedCount: 2 - ScannerWorkerWaitTime: 211.4us - TabletNum: 2 - TotalReadThroughput: 0 VScanner: - BlockConvertTime: 0ns - BlockFetchTime: 123.154ms - ReaderInitTime: 0ns - RowsDelFiltered: 0 - ScannerConvertBlockTime: 0ns - ScannerCpuTime: 123.589ms - ScannerFilterTime: 629ns - ScannerGetBlockTime: 73.343us - ScannerInitTime: 151.78us - ScannerPrefilterTime: 0ns SegmentIterator: - BitmapIndexFilterTimer: 987ns - BlockConditionsFilteredTime: 2.52us - BlockInitSeekCount: 6 - BlockInitSeekTime: 85.47us - BlockInitTime: 220.699us - BlockLoadTime: 123.151ms - BlocksLoad: 4 - CachedPagesNum: 0 - CompressedBytesRead: 17.77 MB - DecompressorTimer: 0ns - FirstReadSeekCount: 2 - FirstReadSeekTime: 34.421ms - FirstReadTime: 122.568ms - IOTimer: 27.879ms - LazyReadSeekCount: 0 - LazyReadSeekTime: 0ns - LazyReadTime: 0ns - NumSegmentFiltered: 0 - NumSegmentTotal: 2 - OutputColumnTime: 4.54us - RawRowsRead: 2 - RowsBitmapIndexFiltered: 0 - RowsBloomFilterFiltered: 0 - RowsConditionsFiltered: 0 - RowsKeyRangeFiltered: 9 - RowsShortCircuitPredFiltered: 0 - RowsShortCircuitPredInput: 0 - RowsStatsFiltered: 0 - RowsVectorPredFiltered: 0 - RowsVectorPredInput: 0 - ShortPredEvalTime: 0ns - TotalPagesNum: 16 - UncompressedBytesRead: 17.77 MB - VectorPredEvalTime: 0ns ### What You Expected? 确认查询耗时是否正常 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
