Size tables

ismaelismael Registered User
in Vertica Forum

Good moorning.
Need know the size the table.

Thanks.

· Share on Twitter

Comments

  • marcothesanemarcothesane Employee, Registered User

    What do you mean by size of a table?
    1. Number of rows?
    2. Auditing size - that is, the size counting for the Vertica license?
    3. Size of internal format on disk?

    marco

    · Share on Twitter
  • Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert
    edited October 4

    @ismael

    The AUDIT function can estimate the raw data size of a table.

    Example:

    dbadmin=> select audit('measure');
 audit
-------
 249
(1 row)
    · Share on Twitter

Leave a Comment