Re: pgstattupple vs pg_total_relation_size - Mailing list pgsql-admin

From Tom Lane
Subject Re: pgstattupple vs pg_total_relation_size
Date
Msg-id 7399.1548859609@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgstattupple vs pg_total_relation_size  ("Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
List pgsql-admin
"Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr> writes:
> On Wed, 30 Jan 2019 14:19:52 +0100
> Tumasgiu Rossini <rossini.t@gmail.com> wrote:
>> According to the doc [1],
>> pg_total_relation_size add toasted data *and* indexes to the mix.

> *and* FSM *and* VM.

Yeah.  In this particular case, the other page presumably belongs to the
toast table's index, which will have a metapage even if the table is
empty.

            regards, tom lane


pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: ora2pg import
Next
From: rammohan ganapavarapu
Date:
Subject: Old WAL files under pg_xlog not getting delete