↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_table_size

Read the PG 18 manual

Computes the disk space used by the specified table, excluding indexes (but including its TOAST table if any, free space map, and visibility map).

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

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

pg_table_size ( regclass ) → bigint
Computes the disk space used by the specified table, excluding indexes (but including its TOAST table if any, free space map, and visibility map).
Version history 3
  1. 12 → 13 changed
  2. 9.0 → 9.1 changed
  3. 8.4 → 9.0 added

Definition snapshot: b7bd9cda · English manual source