pingcap/tidb

Show the spill to disk cost for Sort operator

Open

#25,850 opened on 2021年6月30日

GitHub で見る
 (2 comments) (0 reactions) (2 assignees)Go (6,186 forks)batch import
good first issuesig/executiontype/enhancement

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (平均マージ 14d 4h) (30d で 346 merged PRs)

説明

Enhancement

Note that I'm not sure whether the explain analyze can get the spill cost of other operators.

For sort, if no spill to disk triggered, most of its cost is the memory sort. So we might not need to record the detailed cost in explain analyze. But the cost of it would be split into two parts if the spill is triggered. It first spills all things to disk. Then perform k-way merge and returning data row by row. It would be useful for investigating the actual cost part if we can record both of them or just the spill cost in EXPLAIN ANALYZE

コントリビューターガイド