Postgres Pro
Downloads
Home   >   mailing lists

\d+ not showing TOAST table size? - Mailing list pgsql-general

From Jon Nelson
Subject \d+ not showing TOAST table size?
Date
Msg-id CAKuK5J0s0CDSRjVax3PtG0Fh2jjwY5X9a25o-euL16sdMWDN=g@mail.gmail.com
Whole thread Raw
Responses Re: \d+ not showing TOAST table size?  (Josh Kupershmidt <schmiddy@gmail.com>)
Re: \d+ not showing TOAST table size?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I have a table with a fair bit of TOAST data in it.
I noticed that \d+ does /not/ include that information (but
pg_total_relation_size does).
Is that intentional? It seems a bit misleading, insofar as "\d+" feels
like it is meant to be a rough indication of the table size, but if
90% of the data is in TOAST then the *real* data stored is much more
than displayed.


--
Jon

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: upgrade postgres to 8.4.8, centos 5.3
Next
From: Josh Kupershmidt
Date:
Subject: Re: \d+ not showing TOAST table size?