Skip to content
Snippets Groups Projects
  • Bruce Momjian's avatar
    528ac10c
    The current implementation of dbsize doesn't handle tables in · 528ac10c
    Bruce Momjian authored
    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
    528ac10c
    History
    The current implementation of dbsize doesn't handle tables in
    Bruce Momjian authored
    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