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

От:

Robert Treat <xzilla@users.sourceforge.net>

Дата:

26 мая 2004 г. в 10:29:29

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

where to find out when a table was last analyzed?

От:

Litao Wu <litaowu@yahoo.com>

Дата:

18 мая 2004 г. в 18:30:36

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/