Re: Querying database size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 7/7/06, Benjamin Krajmalnik <kraj@xxxxxxxxxxx> wrote:
Is there a query which can be issued which will return the size of a
database?
I see that in pgadmin you can get the values on a per table manner.
I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that information.

TIA,

Benjamin

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


select datname, pg_database_size(datname) from pg_database;

This assumes your are running 8.x (might be 8.1.x).

chris


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux