Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)? - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)?
Date
Msg-id fd6781467e16402b2f63ca12027a9c4e2de59b19.camel@cybertec.at
Whole thread Raw
In response to Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view 
On Mon, 2021-02-15 at 16:05 -0800, Wells Oliver wrote:
> Where can I pull this from? I am guessing it's just number of dead tuples / row count,
>  but Im not exactly sure. Would like to show these factors per relation in an overall view I have.

The row count of the table is taken from pg_class.reltuples, and the number
of dead tuples is taken from the "pg_stat_get_dead_tuples" function.

Note that the autovacuum parameters can be overridden by storage parameters
on the table.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)?
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_baseback could not connect in AWS linux 2