From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | r d <rd0002(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Pgadmin3 and Postgres 9.0.4 observation |
Date: | 2011-05-16 07:39:58 |
Message-ID: | 4DD0D4CE.9030406@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
Le 05/13/2011 02:26 PM, r d a écrit :
> [...]
> since upgrading to postgresql 9.0.4 I have noticed that pgadmin3 (1.12.2 &
> 1.12.3)
> does not show the info for the columns:
>
> "last vacuum"
> "last autovacuum"
> "last analyze"
> "last autoanalyze"
>
> in the table statistics view, for tables where I know for sure that
> auto-vacuum and auto-analyze executed.
>
It does for me. What does psql tell you on these columns for these
tables? or what does the query tool tell you if you launch this query?
SELECT schemaname, relname FROM pg_stat_user_tables
WHERE last_autovacuum IS NOT NULL OR last_autoanalyze IS NOT NULL;
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-05-16 07:42:08 | Re: SQL/MED Foreign Data Wrappers where is Handler? |
Previous Message | Guillaume Lelarge | 2011-05-16 07:35:03 | Re: SQL Editor fail |