插入一条数据 0.6s
profile 如下：
Query:
Summary:
- Query ID: 9699592d-be70-11ed-b7b4-ecf4bbe833b8
- Start Time: 2023-03-09 19:50:29
- End Time: 2023-03-09 19:50:29
- Total: 644ms
- Query Type: Query
- Query State: OK
- StarRocks Version: 2.5.0-6abafd3
- User: bfd_ibg_mf
- Default Db: bfd_mf_data_test
- Sql Statement: insert into mf_subject_data_monitor_sum values(20230309,1442,11111111112,“2023-03-09”,2,1678362478000,1678362478000,10034)
- QueryCpuCost: 0
- QueryMemCost: 0.000
- Variables: parallel_fragment_exec_instance_num=1,pipeline_dop=0,enable_adaptive_sink_dop=false
- Collect Profile Time: 17ms
Planner:
- Analyzer: 0ms / 1
- CoordDeliverExec: 141ms / 1
- CoordPrepareExec: 0ms / 1
- Total: 0ms / 1
Optimizer:
- CostBaseOptimize: 0ms / 1
- PhysicalRewrite: 0ms / 1
- RuleBaseOptimize: 0ms / 1
- preprocessMvs: 0ms / 1
Execution Profile 9699592d-be70-11ed-b7b4-ecf4bbe833b8:
- ExecutionTotalTime: 577.342us
Fragment 0:
- BackendAddresses: 192.168.67.133:9060
- BackendNum: 1
- FragmentInstancePrepareTime: 40.365ms
- InstanceNum: 1
- PeakMemoryUsage: 32.00 B
- QueryMemoryLimit: 2.00 GB
Pipeline (id=0):
- ActiveTime: 431.781us
- BlockByInputEmpty: 0
- BlockByOutputFull: 1
- BlockByPrecondition: 0
- DegreeOfParallelism: 1
- DriverPrepareTime: 42.449ms
- DriverTotalTime: 434.898ms
- OverheadTime: 0ns
- PendingTime: 434.154ms
- InputEmptyTime: 0ns
- FirstInputEmptyTime: 0ns
- FollowupInputEmptyTime: 0ns
- OutputFullTime: 96.212ms
- PendingFinishTime: 337.948ms
- PreconditionBlockTime: 0ns
- ScheduleCount: 2
- ScheduleTime: 312.841us
- TotalDegreeOfParallelism: 1
- YieldByPreempt: 0
- YieldByTimeLimit: 0
OLAP_TABLE_SINK:
CommonMetrics:
- CloseTime: 142.746us
- OperatorTotalTime: 516.251us
- PeakMemoryUsage: 0.00
- PrepareTime: 42.395ms
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 1
- PushRowNum: 1
- PushTotalTime: 192.134us
- SetFinishedTime: 46ns
- SetFinishingTime: 181.325us
UniqueMetrics:
- IndexNum: 1
- ReplicatedStorage: false
- TxnID: 4497570
- CloseWaitTime: 5.94ms
- OpenTime: 0ns
- PrepareDataTime: 18.865us
- ConvertChunkTime: 8.156us
- ValidateDataTime: 1.682us
- RowsFiltered: 0
- RowsRead: 1
- RowsReturned: 1
- RpcClientSideTime: 674.416ms
- RpcServerSideTime: 503.761ms
- SendDataTime: 29.119us
- PackChunkTime: 6.696us
- SendRpcTime: 117.639us
- CompressTime: 0ns
- SerializeChunkTime: 12.874us
- WaitResponseTime: 0ns
UNION_CONST_SOURCE (plan_node_id=0):
CommonMetrics:
- CloseTime: 21.267us
- OperatorTotalTime: 61.91us
- PeakMemoryUsage: 0.00
- PrepareTime: 18.508us
- PullChunkNum: 1
- PullRowNum: 1
- PullTotalTime: 39.272us
- PushChunkNum: 0
- PushRowNum: 0
- PushTotalTime: 0ns
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 126ns
- SetFinishingTime: 426ns
UniqueMetrics:
数据量太小了，这个没啥意义，单批次数据量大点再测试吧。
嗯 大数据量插入很快