-
Notifications
You must be signed in to change notification settings - Fork 5.8k
Issues: pingcap/tidb
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Author
Label
Projects
Milestones
Assignee
Sort
Issues list
planner: NDV used in join cardinality estimation is over-estimated in some cases
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#36475
opened Jul 22, 2022 by
qw4990
planner: consider partition pruning when estimating partition table row counts
component/statistics
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#36977
opened Aug 9, 2022 by
qw4990
Planner doesn't estimate local aggregate cardinality properly
epic/cardinality-estimation
the optimizer cardinality estimation
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#35420
opened Jun 16, 2022 by
fixdb
Consider filter condition of index access path in skyline pruning
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#37689
opened Sep 7, 2022 by
time-and-fate
planner: cardinality estimation on TPCC customer is not accurate enough
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#39636
opened Dec 5, 2022 by
qw4990
wrong estimation causing wrong plan in TPCDS
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#39520
opened Nov 30, 2022 by
qw4990
wrong estimation causing wrong plan in TPCC
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#39519
opened Nov 30, 2022 by
qw4990
wrong estimation causing wrong plan for CH workload
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#39492
opened Nov 30, 2022 by
dbsid
estRows
differs significantly from actRows
epic/cardinality-estimation
#39762
opened Dec 8, 2022 by
Mini256
planner: unexpected cardinality estimation results
epic/cardinality-estimation
the optimizer cardinality estimation
may-affects-5.1
This bug maybe affects 5.1.x versions.
may-affects-5.2
This bug maybe affects 5.2.x versions.
may-affects-5.3
This bug maybe affects 5.3.x versions.
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#44376
opened Jun 2, 2023 by
qw4990
Using Limit to replace Topn when estrows is small.
affects-7.1
affects-8.1
epic/cardinality-estimation
the optimizer cardinality estimation
epic/cost-model
the optimizer cost model
found/gs
found by gs
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#46925
opened Sep 12, 2023 by
King-Dylan
planner: large outer-join cardinality estimation error when there are multiple join keys
epic/cardinality-estimation
the optimizer cardinality estimation
found/gs
found by gs
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#49893
opened Dec 28, 2023 by
qw4990
planner: prevent the optimizer from using different versions of stats of a table during optimization
component/statistics
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#50281
opened Jan 10, 2024 by
qw4990
planner: large cardinality estimation error for IndexJoin with IndexLookup when join estimation is zero
affects-8.1
epic/cardinality-estimation
the optimizer cardinality estimation
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#51379
opened Feb 28, 2024 by
qw4990
Wrong estimated row count for _tidb_rowid
affects-5.4
This bug affects 5.4.x versions.
affects-6.1
affects-6.5
affects-7.1
affects-7.5
affects-8.1
epic/cardinality-estimation
the optimizer cardinality estimation
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#51098
opened Feb 13, 2024 by
djshow832
unexpected estimate row count using distinct
epic/cardinality-estimation
the optimizer cardinality estimation
fuzz/randomtest
severity/minor
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#51229
opened Feb 21, 2024 by
wjhuang2016
incorrect row estimation in having clause
epic/cardinality-estimation
the optimizer cardinality estimation
fuzz/randomtest
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#51280
opened Feb 23, 2024 by
wjhuang2016
The estRows is wrong if SQL is executed multiple times
epic/cardinality-estimation
the optimizer cardinality estimation
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#53119
opened May 9, 2024 by
yedushusheng
planner: NDV estimation formula is too naive
affects-5.4
This bug affects 5.4.x versions.
affects-6.1
affects-6.5
affects-7.1
affects-7.5
affects-8.1
epic/cardinality-estimation
the optimizer cardinality estimation
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#54812
opened Jul 22, 2024 by
qw4990
Planner should consider specified partition when caculate the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
estRows
epic/cardinality-estimation
#53657
opened May 29, 2024 by
Defined2014
ProTip!
Find all open issues with in progress development work with linked:pr.