Re: n_mod_since_analyze - Mailing list pgsql-general

From Laurenz Albe
Subject Re: n_mod_since_analyze
Date
Msg-id 9eab4bdc7b0881e26a38d5c5e9b8eb2a1bb8bff8.camel@cybertec.at
Whole thread Raw
In response to n_mod_since_analyze  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: How to build a btree index with integer values on jsonb data?
Next
From: Matt Zagrabelny
Date:
Subject: psql profiles?