n_mod_since_analyze
Started by Ronover 7 years ago2 messagesgeneral
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.
Re: n_mod_since_analyze
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