Observability into DuckDB storage internals at the database, table, and column levels
Maintainer(s):
Andrewtangtang,
dentiny
Installing and Loading
INSTALL table_inspector FROM community;
LOAD table_inspector;
Example
-- List all attached persistent databases with file sizes
SELECT * FROM inspect_storage();
-- List all tables with their persisted data size
SELECT * FROM inspect_database();
-- Per-segment storage details for a specific column
SELECT * FROM inspect_column('my_table', 'my_column');
-- High-level storage breakdown
SELECT * FROM inspect_block_usage();
About table_inspector
A DuckDB extension that provides observability into DuckDB storage internals. It helps users understand storage usage at the database, table, and column levels, and addresses issues like unexpected file size or poor compression.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| inspect_block_usage | table | NULL | NULL | |
| inspect_column | table | NULL | NULL | |
| inspect_database | table | NULL | NULL | |
| inspect_storage | table | NULL | NULL |