Re: [luciddb-users] Disk Usage

[Nicholas G. <ngo...@dy...>]

Feilpe - welcome to the community.

On May 3, 2011, at 5:06 PM, Felipe Issa wrote:

> I'm doing a research on LucidDB, and I'd like to know if there is a way to determine how much space in disk LucidDB use to allocate a given schema.
Yes, there is!  It actually gives column by column and index by index allocated storage figures.  Here's a query, that we are including in our upcoming release of our Admin tools to show such information:

select 
 table_schem as schema, 
 table_name, 
 index_name, pages*32/1024 as "SizeInMB" 
from 
 sys_boot.jdbc_metadata.index_info_internal 
where 
 table_schem = '<<your schema>>' 
order by 1,2,4 desc;

NOTE: This requires current stats to produce any results, so prior to running this, you'll need to analyze your tables/schema 
(http://pub.eigenbase.org/wiki/AppLib_ESTIMATE_STATISTICS_FOR_SCHEMA)

> Anyway, thanks for your help!
Of course!  Let us know what you see and any further q's you might have about it!

Kind Regards,
Nick