Re: Bloat and Slow Vacuum Time on Toast

On Tue, Jul 19, 2011 at 1:50 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> wrote:

> Ken Caruso <ken(at)ipl31(dot)net> wrote:
>
>
> > SELECT SUM(pg_relation_size(pg_class.oid))
> > FROM pg_class ;
>
> Perhaps you want pg_total_relation_size()?
>
> -Kevin
>

The number returned when using pg_total_relation size makes more sense:
346GB. However it looked like pg_class has toast and indexes listed
individually, so I assumed that using pg_total_relation_size would count
values twice, because the total relation size of table would include toast
and indexes, and then they would get counted again when I ran
pg_total_relation_size on the toast and indexes themselves. Is that an
incorrect assumption on my part?

Thanks

-Ken