Options

Size tables

Good moorning.
Need know the size the table.

Thanks.

Comments

  • Options
    marcothesanemarcothesane - Select Field - Administrator

    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

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited October 2017

    @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