↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_tablespace_size

Read the PG 18 manual

Computes the total disk space used in the tablespace with the specified name or OID.

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

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

pg_tablespace_size ( name ) → bigint
Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.
pg_tablespace_size ( oid ) → bigint
Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.
Version history 4
  1. 18 → 19 changed
  2. 14 → 15 changed
  3. 12 → 13 changed
  4. 8.0 → 8.1 added

Definition snapshot: b7bd9cda · English manual source