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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to