https://gombemi.ccas.gwu.edu/gombemiwiki/index.php?action=history&feed=atom&title=DBDiskSpaceManagementDBDiskSpaceManagement - Revision history2026-05-27T00:24:39ZRevision history for this page on the wikiMediaWiki 1.27.4https://gombemi.ccas.gwu.edu/gombemiwiki/index.php?title=DBDiskSpaceManagement&diff=73&oldid=prevKarlPinc: New Page2015-09-29T18:27:22Z<p>New Page</p>
<p><b>New page</b></p><div>== DB Disk Space Management ==<br />
<br />
The queries on this page must be run by an administrative login<br />
to get a complete picture of disk usage. When run by a regular<br />
user the queries will show only the portion of the database to<br />
which the user has access.<br />
<br />
Note that the database uses space not shown in these queries.<br />
These queries are useful in determining relative disk usage.<br />
Actual disk usage may vary somewhat.<br />
<br />
It may be desirable to modify these queries to change the sort<br />
order or limit the results returned.<br />
<br />
=== Disk Space by Schema (by User) ===<br />
Use the following query to discover how much space is used per-schema.<br />
<br />
<code><br />
-- Space used by schema (which user is using space)<br />
select pg_namespace.nspname as schema<br />
, pg_size_pretty(sum(pg_total_relation_size(pg_class.oid)))<br />
as size<br />
from pg_class, pg_namespace<br />
where pg_class.relnamespace = pg_namespace.oid<br />
group by pg_namespace.nspname<br />
order by sum(pg_total_relation_size(pg_class.oid)) desc;<br />
</code><br />
<br />
=== Disk Space Used by Table ===<br />
Use the following query to discover how much space is used per-table.<br />
<br />
<code><br />
-- Space used by schema (which user is using space)<br />
select pg_namespace.nspname as schema<br />
, pg_class.relname as table<br />
, pg_size_pretty(pg_total_relation_size(pg_class.oid)) <br />
as size<br />
from pg_class, pg_namespace<br />
where pg_class.relnamespace = pg_namespace.oid<br />
order by pg_total_relation_size(pg_class.oid) desc;<br />
</code></div>KarlPinc