We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Size tables — Vertica Forum

Size tables

Good moorning.
Need know the size the table.

Thanks.

Comments

  • 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

  • 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