Skip to content

Issues: cockroachdb/cockroach

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

Clear current search query, filters, and sorts
63 Open 78 Closed
63 Open 78 Closed
Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or ⇧ + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Assignee
Filter by who’s assigned
Sort
Sort by
Newest Oldest Most commented Least commented Recently updated Least recently updated Best match
Most reactions
👍 👎 😄 🎉 😕 ❤️ 🚀 👀

Issues list

sql: add sql_stats_histogram_collection_enabled storage parameter A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#139620 opened Jan 23, 2025 by michae2
1
sql: better control over selecting columns to collect stats for A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-2 Issues/test failures with a fix SLA of 3 months T-sql-queries SQL Queries Team
#139382 opened Jan 17, 2025 by mgartner
sql: reduce memory usage when collecting stats on wide JSON A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-1 Issues/test failures with a fix SLA of 1 month T-sql-queries SQL Queries Team
#139381 opened Jan 17, 2025 by mgartner
1
sql: truncated, sampled values should not be included in "num_eq" in histograms A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#139380 opened Jan 17, 2025 by mgartner
perf: disabling histogram collection results in 1.2% performance gain on sysbench oltp_read_write (1.2% cpu) A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. o-perf-efficiency Related to performance efficiency T-sql-queries SQL Queries Team
#137780 opened Dec 19, 2024 by ajstorm
@mgartner
sql/stats: inaccurate avg_size in statistics for column in single-column column family A-sql-table-stats Table statistics (and their automatic refresh). branch-release-22.1 Used to mark GA and release blockers, technical advisories, and bugs for 22.1 branch-release-22.2 Used to mark GA and release blockers, technical advisories, and bugs for 22.2 branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 branch-release-23.2 Used to mark GA and release blockers, technical advisories, and bugs for 23.2 branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-queries SQL Queries Team
#137713 opened Dec 18, 2024 by michae2
2
sql: partial table statistics are not used in row count estimates A-sql-optimizer SQL logical planning and optimizations. A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
#134461 opened Nov 6, 2024 by mgartner
@mgartner
1
sql: automatic partial stats collection does not work as expected A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
#134460 opened Nov 6, 2024 by mgartner
@michae2
1
opt,stats: consider adding a minimum number of heavy-hitter buckets A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-qa T-sql-queries SQL Queries Team
#133644 opened Oct 29, 2024 by DrewKimball
1
sql/stats: forecast closer to the current time A-sql-table-stats Table statistics (and their automatic refresh). C-performance Perf of queries or internals. Solution not expected to change functional behavior. O-postmortem Originated from a Postmortem action item. O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#130710 opened Sep 13, 2024 by michae2
2
Support EXPLAIN ANALYZE with creating unspecified partial stats A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#128904 opened Aug 13, 2024 by Uzair5162
Support partial stats at extremes on hash-sharded indexes and REGIONAL BY ROW tables A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#128725 opened Aug 9, 2024 by Uzair5162
sql: do not recommend a stats collection if there was one recently A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#127858 opened Jul 29, 2024 by mgartner
1
sql: memory exceeded in sampleAggregator causes stats collection to fail A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
#127649 opened Jul 23, 2024 by rytaft
1
sql/stats: forecasted histograms often have num_eq = 0 A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-testcluster Issues found or occurred on a test cluster, i.e. a long-running internal cluster P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#126522 opened Jul 1, 2024 by michae2
2
sql: histogram does not match column type after ALTER TABLE ALTER COLUMN SET DATA TYPE A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. P-3 Issues/test failures with no fix SLA S-2-temp-unavailability Temp crashes or other availability problems. Can be worked around or resolved by restarting. T-sql-queries SQL Queries Team
#125620 opened Jun 13, 2024 by cockroach-teamcity
4
sql/stats: some forecasting cluster settings do not immediately take effect A-sql-table-stats Table statistics (and their automatic refresh). C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. docs-known-limitation T-sql-queries SQL Queries Team
#123852 opened May 8, 2024 by michae2
3
sql: cancel duplicate stats requests once unblocked by other long-running stats requests A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#123588 opened May 3, 2024 by mgartner
1
opt,import: newly imported tables have poor stats estimates A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-testcluster Issues found or occurred on a test cluster, i.e. a long-running internal cluster P-2 Issues/test failures with a fix SLA of 3 months T-sql-queries SQL Queries Team
#122818 opened Apr 22, 2024 by DrewKimball
1
stats: consider truncating deeply-nested json objects used as upper bounds A-sql-table-stats Table statistics (and their automatic refresh). C-cleanup Tech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior. T-sql-queries SQL Queries Team
#121749 opened Apr 4, 2024 by yuzefovich
1
sql: collect statistics on arbitrary scalar expressions A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#121158 opened Mar 26, 2024 by michae2
sql: disable forecasts for specific columns A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#117896 opened Jan 17, 2024 by mgartner
sql: stats forecasts can have too many histogram buckets A-sql-table-stats Table statistics (and their automatic refresh). C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#117889 opened Jan 17, 2024 by mgartner
sql: show-stats doesn't work when the table is offline A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#108579 opened Aug 11, 2023 by DrewKimball
1
sql/stats: reduce number of automatic table stats jobs/attempted job creations A-sql-table-stats Table statistics (and their automatic refresh). C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#108435 opened Aug 9, 2023 by dt
1
ProTip! Exclude everything labeled bug with -label:bug.