Re: Is Autovacuum running?

From: Brad White <b55white(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Is Autovacuum running?
Date: 2023-02-21 17:54:22
Message-ID: CAA_1=90hm-N_0ddb8rGZP0vRpvRd-fro8Y0BY7MVzOWzJRvYQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 20, 2023 at 1:42 PM Brad White <b55white(at)gmail(dot)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
>
>
Any suggestions on how to proceed?

Thanks,
Brad.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2023-02-21 17:57:09 Re: Is Autovacuum running?
Previous Message Stephen Frost 2023-02-21 15:29:28 Re: can't get psql authentication against Active Directory working