Skip to main content

Size tables

  • September 25, 2017
  • 2 replies
  • 12 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
  • September 25, 2017

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
  • October 4, 2017

@ismael

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

Example:

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