table raw data size

[nnani]

Hello All,

Is there a way we can find out raw data size for a table in Vertica.

Thanks

[nnani]

Got it.

We can simply do a audit on table level.

Code: Select all

NNANI=> select audit('public.bank_holidays');
 audit
-------
 319
(1 row

The size of bank holidays table is 319 bytes

Thanks

[NorbertKrupa]

This question has been asked here before.

• TABLE SIZE
• Estimating Size of a table

Additionally, the AUDIT() function is only an estimate. You may want to lower the error tolerance or increase the confidence level.

The results will be stored in the user_audits table.