Re: n_mod_since_analyze

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: n_mod_since_analyze
Date: 2018-12-06 17:29:36
Message-ID: 9eab4bdc7b0881e26a38d5c5e9b8eb2a1bb8bff8.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Zagrabelny 2018-12-06 22:19:27 psql profiles?
Previous Message Laurenz Albe 2018-12-06 17:27:45 Re: How to build a btree index with integer values on jsonb data?