Functions / System Administration Functions

pg_total_relation_size

Computes the total disk space used by the specified table, including all indexes and TOAST data.

Reading PG 18current·documented in 22 of 27 versions, 8.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_total_relation_size ( regclass ) → bigint

Computes the total disk space used by the specified table, including all indexes and TOAST data. The result is equivalent to pg_table_size + pg_indexes_size.

Version history 5

12 → 13 changed
9.0 → 9.1 changed
8.4 → 9.0 changed
8.3 → 8.4 changed
8.0 → 8.1 added

Definition snapshot: b7bd9cda · English manual source