Skip to content
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.

Sign up for GitHub

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

Jump to bottom

quickly get total count from index/column #58366

Closed
hawkingrei opened this issue Dec 18, 2024 · 0 comments · Fixed by #58365
Closed

quickly get total count from index/column #58366

hawkingrei opened this issue Dec 18, 2024 · 0 comments · Fixed by #58365
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/statistics severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@hawkingrei
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Recently, I found that the map iter time here has become significantly longer.

image

Compared with the older code, you will find that the current code will traverse the column statistics after traversing the index, which makes the time here longer.

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)
@hawkingrei hawkingrei added type/bug The issue is confirmed as a bug. sig/planner SIG: Planner severity/moderate labels Dec 18, 2024
@hawkingrei hawkingrei mentioned this issue Dec 18, 2024
Merged
13 tasks
@Rustin170506 Rustin170506 moved this to 🏊WIP in 😆Stats Dec 18, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in 1fa2955 Dec 19, 2024
@ti-chi-bot ti-chi-bot mentioned this issue Dec 20, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot bot added the affects-8.5 This bug affects the 8.5.x(LTS) versions. label Dec 23, 2024
ti-chi-bot bot pushed a commit that referenced this issue Dec 27, 2024
@ti-chi-bot
planner: quickly get total count from index/column (#58365) (#58431)
8a56eab 
close #58366
@Rustin170506 Rustin170506 removed this from 😆Stats Jan 3, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/statistics severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

planner: quickly get total count from index/column hawkingrei/tidb
2 participants
@hawkingrei @Rustin170506