To find the size of tables in a DuckDB database, you can use the PRAGMA storage_info command. This command provides detailed storage information for a specific table, including the size of each column and segment.
```
PRAGMA storage_info('table_name');
LBKSFor MotherDuck, the `PRAGMA database_size` command is not supported directly. However, you can use the `pragma_database_size()` function in DuckDB to get the database size, but this may not be fully supported in MotherDuck due to its differential storage system.
LBKS```
CALL pragma_database_size();
Would you like more detail on how to interpret the output or alternative methods?
Sources:
- DuckDB Pragmas
- MotherDuck Slack Discussion
.png){kind=logo}
