Diagnosing outdated auto analyze dates...

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Diagnosing outdated auto analyze dates...
Date: 2021-04-21 20:06:09
Message-ID: CAOC+FBVjeBp9+GFCBgYw4YmrGMz=80A1VO-QY_8_pzkYAT_dvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

A last_autoanalyze date in pg_stat_all_tables for a table we update every
day is 3/26, another is 3/13 -- I feel strongly somehow these tables should
be auto-analyzed and auto-vacuumed more often, and am wondering where to
look first.

My autovacuum_analyze_threshold is 10, my autovacuum_vacuum_threshold is
25.

How can I better understand why these tables are not more frequently being
auto-analyzed and vacuumed?

Thank you.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2021-04-21 20:48:10 Re: Diagnosing outdated auto analyze dates...
Previous Message Pavan Pusuluri 2021-04-21 01:45:16 Re: OLEDB for PostgreSQL