Search Postgresql Archives

Re: n_mod_since_analyze

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux