Thread: where to find out when a table was last analyzed?

All,

Does PG store when a table was last analyzed?

Thanks,






__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

On Tue, 2004-05-18 at 17:13, Litao Wu wrote:
> All,
>
> Does PG store when a table was last analyzed?
>
> Thanks,
>

no. you can do something like select attname,s.* from pg_statistic s,
pg_attribute a, pg_class c where starelid = c.oid and attrelid = c.oid
and staattnum = attnum and relname = 'mytable' to see the current
statistics on the table, but its not timestamped.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL