improve the executor runtime information collection

[crazycs520]

Current Problem

Currently, from the explain analyze result, we can see some executor is slow, but it's hard to know the reason of the slow.

Development Task

Here is something need to do:

• refactor execdetails information of runtime collect util/execdetails: refactor execdetails information of runtime collect #18530
• Add more runtime information for Cop task, include backoff_time, backoff_time resolve_lock time, and so on. distsql, util: adapt scandetailv2 in coprocessor response #20492
  • After Fix incorrect processed / total keys counter tikv/tikv#7563 merged, record more information too.
• add runtime stats for below executor:
  • Insert execute: add rpc runtime stats information for insert/update/replace statement (#19334) #20430
  • Update execute: add rpc runtime stats information for insert/update/replace statement (#19334) #20430
  • Replace execute: add rpc runtime stats information for insert/update/replace statement (#19334) #20430
  • Point-Get executor: add runtime information for point-get executor #18666
  • Batch_Point_Get executor: add runtime information for the batch-point-get executor #18828
  • IndexLookUpJoin executor: add more runtime information for join executor  #19721
  • IndexNestedLoopHashJoin executor: add more runtime information for join executor  #19721
  • HashJoinExec executor: add more runtime information for join executor  #19721
  • Load data statement executor: fix issue of load data statement doesn't record into slow query and statements_summary #20713
  • HashAggExec, executor: Add the HashAggExec runtime information #20577
  • StreamAggExec, executor:add runtime information for StreamAggExec #20861
  • IndexLookUpExecutor, refine IndexLookUp executor runtime stats #19349
  • IndexMergeReaderExecutor, executor:Add runtime stat for IndexMergeReaderExecutor #20653
  • UnionScanExec, executor:Add runtime information for UnionScanExec #20865
  • NestedLoopApplyExec
  • ParallelNestedLoopApplyExec
  • ProjectionExec
  • SplitIndexRegionExec
  • SplitTableRegionExec
  • ShowDDLJobQueriesExec
• Add documents.
  • 中文文档 Update doc for explain analyze docs-cn#4655
  • English document update doc for explain analyze docs#4071
• Add more tests.

[tabokie]

/label component/executor

[IANTHEREAL]

Go ahead!