Re: Diagnosing a massive toast file - Mailing list pgsql-admin

From Tom Lane
Subject Re: Diagnosing a massive toast file
Date
Msg-id 6018.1565023741@sss.pgh.pa.us
Whole thread Raw
In response to Re: Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Diagnosing a massive toast file
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> writes:
> Yeah, trying to figure out what actual table is clearly in need of a vacuum
> b/c of the size of that toast table.

Something like

select relname from pg_class
where reltoastrelid = 'pg_toast.pg_toast_NNN'::regclass;

(or, if you have potential duplicate relnames, select oid::regclass ...)

The mere fact that it's big does not indicate a problem, though.

            regards, tom lane



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Diagnosing a massive toast file
Next
From: Wells Oliver
Date:
Subject: Re: Diagnosing a massive toast file