Re: psql \dt and table size
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Bernd Helmle <mailings@oopsware.de>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-03-25T16:17:08Z
Lists: 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 >