Re: [ADMIN] age of statistics

2003-09-05 Thread Tom Lane
colin roald <[EMAIL PROTECTED]> writes: > It seems like there ought to be a table somewhere in pg_catalog with a > date in it, but I can't find it. That's because there isn't one ... regards, tom lane ---(end of broadcast)--

Re: [ADMIN] age of statistics

2003-09-05 Thread colin roald
Quoth colin roald <[EMAIL PROTECTED]>: > Is there a way to query the database to find out how old the current > table statistics are? That is, when the ANALYZE command was last run > on a given table? It seems like there ought to be a table somewhere > in pg_catalog I can't find it in the Postgre

[ADMIN] age of statistics

2003-09-04 Thread colin roald
Is there a way to query the database to find out how old the current table statistics are? That is, when the ANALYZE command was last run on a given table? It seems like there ought to be a table somewhere in pg_catalog I can't find it in the PostgreSQL Administrator documentation, nor by searchi