Size tables

ismaelismael Registered User

Good moorning.
Need know the size the table.

Thanks.

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

  • 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)
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file