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
