Hello All,
Is there a way we can find out raw data size for a table in Vertica.
Thanks
table raw data size
Moderator: NorbertKrupa
Re: table raw data size
Got it.
We can simply do a audit on table level.
The size of bank holidays table is 319 bytes
Thanks
We can simply do a audit on table level.
Code: Select all
NNANI=> select audit('public.bank_holidays');
audit
-------
319
(1 row
Thanks
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: table raw data size
This question has been asked here before.
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.
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.
Checkout vertica.tips for more Vertica resources.