Re: Querying database size

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Re: Querying database size
Дата
Msg-id 1d219a6f0607071050y4599b1f7w5f416ad72a382e0e@mail.gmail.com
обсуждение исходный текст
Ответ на Querying database size  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Список pgsql-admin


On 7/7/06, Benjamin Krajmalnik <kraj@illumen.com> 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Querying database size
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: Querying database size