pingcap / pingcap/tidb

same predicate estimation of two approximate stats is quite different

Open
#62,766 0 comments 0 reactions 0 assignees View on GitHub
affects-7.5 component/statistics epic/cardinality-estimation report/customer sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
the predicate estimation of create_at > 1753861183 under two different stats while with approximate row count (55700680 vs 56154291) is quite different, because one of them is out of bound of bucket, while the other is not

Image

Image

Image

we can tell from the pic above, it's 3M vs 0.3M actually, ref TCOC-3945 to get the replayer detail

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.