esse select já quebraria uma galho, mas me parece que não funciona no 8.1

Obrigado marcelo


On Wed, Nov 11, 2009 at 6:07 PM, Marcelo Costa <[email protected]>wrote:

> Olá
>
>
> On Tue, Nov 10, 2009 at 6:28 PM, Edson Mundin Ferreira <
> [email protected]> wrote:
>
>> alguem sabe me dizer se tem como descobrir qual a data que rodou o
>> ultimo vacuum full de determinada tabela?
>>
>> Obrigado
>> Édson
>>
>>
> select relname, last_vacuum, last_autovacuum from
> pg_stat_all_tables where schemaname = 'public';
>
> --
> Marcelo Costa
> www.marcelocosta.net
> -------------------------------------------------
> “You can't always get what want”,
>
> Doctor House in apology to Mike Jagger
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a