On Tue, Feb 21, 2023 at 2:56 PM David Rowley <dgrowle...@gmail.com> wrote:
> On Tue, 21 Feb 2023 at 08:42, Brad White <b55wh...@gmail.com> wrote: > > > > I'm concerned that Autovacuum may not be running based on the results of > this query. > > > > SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables; > > gives 211 rows like this... > > relname | last_vacuum | last_autovacuum > > BusinessIncidentCategories | null | null > > Valid Use | null | null > > Serial Pool Part Types | null | null > > BusinessIncidentLog | null | null > > Rate Categories | null | null > > It's probably worth having a look at: > > select datname,stats_reset,now() from pg_stat_database where datname = > current_database(); > > while you're connected to the database with those tables. If you're > resetting the stats, then that resets the counters used by autovacuum > and also the columns you mention above. That can lead to autovacuum > not doing any vacuuming or analyzing. > > Well that explains a lot. datname | stats_reset | now DB | 2023-02-17 14:28:27-06 | 2023-02-21 16:16:34-06 I heard that the system was running slowly on Friday. They may have cycled the service in an attempt to resolve that. I went ahead and ran ANALIZE. We'll see if that affects anything. Thanks, Brad.
