在我们集群中大概300+条数据查询sql有时候是20ms 要是要1s+。
查看了profile 查询核心耗时极低，pengdingTime耗时极高。
Pipeline (id=0):
- ActiveTime: 23.151us
- __MAX_OF_ActiveTime: 215.151us
- __MIN_OF_ActiveTime: 6.503us
- BlockByInputEmpty: 0
- BlockByOutputFull: 0
- BlockByPrecondition: 0
- DegreeOfParallelism: 60
- DriverPrepareTime: 121.033us
- __MAX_OF_DriverPrepareTime: 2.725ms
- __MIN_OF_DriverPrepareTime: 56.035us
- DriverTotalTime: 403.031ms
- __MAX_OF_DriverTotalTime: 479.209ms
- __MIN_OF_DriverTotalTime: 362.234ms
- OverheadTime: 21ns
- __MAX_OF_OverheadTime: 11.450us
- __MIN_OF_OverheadTime: 0ns
- PeakDriverQueueSize: 21.872K (21872)
- __MAX_OF_PeakDriverQueueSize: 81
- __MIN_OF_PeakDriverQueueSize: 0
- **PendingTime: 387.799ms**
**- __MAX_OF_PendingTime: 431.756ms**
** - __MIN_OF_PendingTime: 361.931ms**
** - InputEmptyTime: 387.799ms**
** - __MAX_OF_InputEmptyTime: 431.756ms**
** - __MIN_OF_InputEmptyTime: 361.931ms**
** - FirstInputEmptyTime: 387.799ms**
** - __MAX_OF_FirstInputEmptyTime: 431.756ms**
** - __MIN_OF_FirstInputEmptyTime: 361.931ms**
** - FollowupInputEmptyTime: 0ns**
- OutputFullTime: 0ns
- PendingFinishTime: 0ns
- PreconditionBlockTime: 0ns
profile文件：profile.txt (204.6 KB)