Обсуждение: n_mod_since_analyze

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.

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