Re: psql \dt and table size

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: psql \dt and table size
Дата
Msg-id AANLkTi=k8-WWZkPtUsgBg3vOFE=kW6MQCbXiZ_k2=ZLR@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \dt and table size  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
2011/3/25 Alvaro Herrera <alvherre@commandprompt.com>:
> Excerpts from Pavel Stehule's message of vie mar 25 02:48:49 -0300 2011:
>> 2011/3/24 Robert Haas <robertmhaas@gmail.com>:
>> > On Wed, Mar 23, 2011 at 4:50 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
>> >> can we enhance a detail for table and show more accurate numbers?
>> >>
>> >> table size: xxx
>> >> toast size: xxx
>> >> indexes size: xxx
>> >
>> > Only if we don't mind going beyond 80 columns.
>>
>> sure, it is on new lines
>
> That could get very long ... are you proposing something like
> \d++ ?

\d++ is good idea. I don't thing so it's necessary for detail about
sizes. But it can be used for super detail:

* sizes of all indexes
* statistics of usage
* statistics of indexes

maybe - it is just idea.

Pavel


>
> --
> Álvaro Herrera <alvherre@commandprompt.com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: 2nd Level Buffer Cache
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to Make a pg_filedump