Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Size tables

Good moorning.
Need know the size the table.

Thanks.

Comments

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.