↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_database_size

Read the PG 18 manual

Computes the total disk space used by the database 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_database_size ( name ) → bigint
Computes the total disk space used by the database with the specified name or OID. To use this function, you must have CONNECT privilege on the specified database (which is granted by default) or have privileges of the pg_read_all_stats role.
pg_database_size ( oid ) → bigint
Computes the total disk space used by the database with the specified name or OID. To use this function, you must have CONNECT privilege on the specified database (which is granted by default) or have privileges of the pg_read_all_stats role.
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