pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedwhere to find out when a table was last analyzed?
2+ messages / 2 participants
[nested] [flat]
* where to find out when a table was last analyzed?
@ 2004-05-18 21:13 Litao Wu <litaowu@yahoo.com>
2004-05-26 13:29 ` Re: where to find out when a table was last analyzed? Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 2+ messages in thread
From: Litao Wu @ 2004-05-18 21:13 UTC (permalink / raw)
To: pgsql-performance
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: where to find out when a table was last analyzed?
2004-05-18 21:13 where to find out when a table was last analyzed? Litao Wu <litaowu@yahoo.com>
@ 2004-05-26 13:29 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Treat @ 2004-05-26 13:29 UTC (permalink / raw)
To: Litao Wu <litaowu@yahoo.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-26 13:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-18 21:13 where to find out when a table was last analyzed? Litao Wu <litaowu@yahoo.com>
2004-05-26 13:29 ` Robert Treat <xzilla@users.sourceforge.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox