Skip to main content

Size tables

  • Sep 25, 2017 10:47 AM UTC
  • 2 replies
  • 16 views

ismael
Forum|alt.badge.img+1
  • Participating Frequently

Good moorning.
Need know the size the table.

Thanks.

2 replies

marcothesane
Forum|alt.badge.img+1
  • Participating Frequently
  • Sep 25, 2017 12:30 PM UTC

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_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 4, 2017 3:11 PM UTC

@ismael

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

Example:

dbadmin=> select audit('measure');
 audit
-------
 249
(1 row)