Date last vacuum

Started by Carlos Henrique Reimerabout 20 years ago2 messagesgeneral

carlosreimer@yahoo.com.br

about 20 years ago

Hello,

Is there a way do discover when was the last time a table or database vacuumed?

Thanks in advance!

Reimer

---------------------------------
Yahoo! Acesso Grï¿½tis
Internet rï¿½pida e grï¿½tis. Instale o discador agora!

crozierm@conducivetech.com

about 20 years ago

In reply to: Carlos Henrique Reimer (#1)

Re: Date last vacuum

Is there a way do discover when was the last time a table or database vacuumed?

No, but you might look at the contrib pgstattuple function. The function
will give detailed information on the state of the table on disk.

michael