Обсуждение: How to get the size in bytes of a table data

Поиск
Список
Период
Сортировка

How to get the size in bytes of a table data

От
"Ricardo Fonseca e Campos"
Дата:

Hi!

 

Does someone know an easy way to get the size (KB) of the data stored in one or more tables?

 

I read about the ANALYZE command but it doesn’t deal with such information.

 

Thanks in advance,

Ricardo.

Re: How to get the size in bytes of a table data

От
Thomas F.O'Connell
Дата:
Check out dbsize in contrib.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source — Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Mar 24, 2005, at 9:53 AM, Ricardo Fonseca e Campos wrote:

> Hi!
>
>  
>
> Does someone know an easy way to get the size (KB) of the data stored
> in one or more tables?
>
>  
>
> I read about the ANALYZE command but it doesn’t deal with such
> information.
>
>  
>
> Thanks in advance,
>
> Ricardo.