Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:51, Adrian Klaver wrote: On 8/23/24 09:33, Matthew Tice wrote: On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:     https://www.postgresql.org/docs/current/pgstattuple.html    

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:33, Matthew Tice wrote: On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: https://www.postgresql.org/docs/current/pgstattuple.html pgstattuple_approx(regclass) return

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver wrote: > On 8/23/24 09:14, Matthew Tice wrote: > > Hi All, > > > > I'm trying to understand why there's a difference between what > > pgstattuple reports and pg_stat_user_tables reports (for the number of > > dead tuples). > > > > As I understand, pg

Re: dead tuple difference between pgstattuple and pg_stat_user_tables

On 8/23/24 09:14, Matthew Tice wrote: Hi All, I'm trying to understand why there's a difference between what pgstattuple reports and pg_stat_user_tables reports (for the number of dead tuples). As I understand, pgstattuple and pgstattuple_approx return the exact number of dead tuples (as no

dead tuple difference between pgstattuple and pg_stat_user_tables

Hi All, I'm trying to understand why there's a difference between what pgstattuple reports and pg_stat_user_tables reports (for the number of dead tuples). As I understand, pgstattuple and pgstattuple_approx return the exact number of dead tuples (as noted in the documentation) and based on an ol