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