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.

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

Add a field disk usage API #15546

Open
romseygeek opened this issue Feb 12, 2024 · 0 comments
Open

Add a field disk usage API #15546

romseygeek opened this issue Feb 12, 2024 · 0 comments

Comments

@romseygeek
Copy link
Contributor

Problem Statement

Related to #10370, it would be useful to have an idea of how much disk space is used by different table columns - in particular this will be helpful to people who are using DROP COLUMN to save disk.

Generating this information can end up being quite expensive so it may be worth adding it as an option to ANALYZE to run in the background.

Possible Solutions

cr> select * from sys.disk_usage where table_name=my_table;
+--------+------------+-------+----------------+-------+
| schema | table_name | field | data_structure | bytes |
+--------+------------+-------+----------------+-------+
| doc    | my_table   | name | index           | 65065 |
| doc    | my_table   | name | doc_values      | 25122 |
...

Considered Alternatives

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Could
Development

No branches or pull requests

2 participants