]> granicus.if.org Git - postgresql/commit
The current implementation of dbsize doesn't handle tables in
authorBruce Momjian <bruce@momjian.us>
Thu, 2 Sep 2004 00:55:22 +0000 (00:55 +0000)
committerBruce Momjian <bruce@momjian.us>
Thu, 2 Sep 2004 00:55:22 +0000 (00:55 +0000)
commit528ac10c7c73883f5b12db2f7bd627652f869bab
treece83bf5b310235949daca826ea5a2c242c301f4e
parente814e4bfe53159a3afb5b6960285b651f32118f3
The current implementation of dbsize doesn't handle tables in
tablespaces correctly, and is quite restricted on objects covered (only
tables and databases, but not tablespaces and indexes).

The attached patch contributes:

- database_size(name)
- relation_size(text)
These are the well-known functions, tablespace-aware.

- pg_tablespace_size(oid)
- pg_database_size(oid)
- pg_relation_size(oid)
Tablespace-aware implementations, used by the upper functions.
pg_relation_size will report sizes of indexes as well.

- pg_size_pretty(bigint)
Formatting of sizes, to display '146MB' instead of '152885668'

Andreas Pflug
contrib/dbsize/dbsize.c
contrib/dbsize/dbsize.sql.in