Get the disk space used by an index on a hypertable, including the disk space needed to provide the index on all chunks. The size is reported in bytes.

For more information about using hypertables, including chunk size partitioning, see the hypertable section.

NameTypeDescription
index_nameREGCLASSName of the index on a hypertable
ColumnTypeDescription
hypertable_index_sizeBIGINTReturns the disk space used by the index
Note

NULL is returned if the function is executed on a non-hypertable relation.

Get size of a specific index on a hypertable.

\d conditions_table
Table "public.conditions_table"
Column | Type | Collation | Nullable | Default
--------+--------------------------+-----------+----------+---------
time | timestamp with time zone | | not null |
device | integer | | |
volume | integer | | |
Indexes:
"second_index" btree ("time")
"test_table_time_idx" btree ("time" DESC)
"third_index" btree ("time")
SELECT hypertable_index_size('second_index');
hypertable_index_size
-----------------------
163840
SELECT pg_size_pretty(hypertable_index_size('second_index'));
pg_size_pretty
----------------
160 kB

Keywords

Found an issue on this page?

Report an issue!