n_mod_since_analyze

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

n_mod_since_analyze

Ron-2

https://www.postgresql.org/docs/9.6/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW

Does the field n_mod_since_analyze use "mod" instead of "upd" because it
includes inserts, updates and deletes?

Thanks

--
Angular momentum makes the world go 'round.

Reply | Threaded
Open this post in threaded view
|

Re: n_mod_since_analyze

Laurenz Albe
Ron wrote:
> https://www.postgresql.org/docs/9.6/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
>
> Does the field n_mod_since_analyze use "mod" instead of "upd" because it
> includes inserts, updates and deletes?

Yes.

It is the number that triggers autoanalyze, and all data modifications impair
the accuracy of the statistics.

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