Re: psql \dt and table size - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: psql \dt and table size
Date
Msg-id AANLkTi=k8-WWZkPtUsgBg3vOFE=kW6MQCbXiZ_k2=ZLR@mail.gmail.com
Whole thread Raw
In response to Re: psql \dt and table size  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: 2nd Level Buffer Cache
Next
From: Alvaro Herrera
Date:
Subject: Re: How to Make a pg_filedump