This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
posgres:space_usage [2014/04/02 15:22] mh |
posgres:space_usage [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 2: | Line 2: | ||
<code> | <code> | ||
- | SELECT pg_size_pretty(pg_database_size('berlinreg')); | + | SELECT pg_size_pretty(pg_database_size('<dbname>')); |
</code> | </code> | ||
=== Platzbedarf der Tabellen === | === Platzbedarf der Tabellen === | ||
Line 26: | Line 26: | ||
(select sum(pg_relation_size(indexname::text)) sumind from pg_indexes) ti, | (select sum(pg_relation_size(indexname::text)) sumind from pg_indexes) ti, | ||
(select sum(pg_relation_size(tablename::text)) sumtable from pg_tables where tableowner = '<username>') tt; | (select sum(pg_relation_size(tablename::text)) sumtable from pg_tables where tableowner = '<username>') tt; | ||
+ | </code> | ||