Versions:

hypertable_size()

Get the total disk space used by a hypertable, i.e. the sum of the size for the table itself (including chunks), any indexes on the table, and any toast tables. The size is reported in bytes. This is equivalent to computing the sum of total_bytes column from the output of hypertable_detailed_size function.

Required Arguments

NameTypeDescription
hypertableREGCLASSHypertable to show size of.

Returns

NameTypeDescription
hypertable_sizeBIGINTTotal disk space used by the specified hypertable, including all indexes and TOAST data.
tip
NULL is returned if the function is executed on a non-hypertable relation.

Sample Usage

Get size information for a hypertable.

SELECT hypertable_size('devices') ;

 hypertable_size
-----------------
           73728

Get size information for all hypertables.

SELECT hypertable_name, hypertable_size(format('%I.%I', hypertable_schema, hypertable_name)::regclass)
  FROM timescaledb_information.hypertables;

Found an issue on this page?

Report an issue!