Re: proposal - psql - show longest tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: proposal - psql - show longest tables
Дата
Msg-id 29128.1374536220@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: proposal - psql - show longest tables  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: proposal - psql - show longest tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> Is looking for the biggest tables a common enough thing that it should
> be available to everyone, without needing custom customization?

I don't really think so.  It's surely not much harder than
select relname, pg_relation_size(oid) from pg_class order by 2 desc;

Moreover, the people who need this likely don't need it as a psql
command, but rather as something available to monitoring tools.
        regards, tom lane



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: proposal - psql - show longest tables