开发者

Postgres Analyze performed

开发者 https://www.devze.com 2023-02-27 00:40 出处:网络
In PostgreSQL 8.4, is there a way to know when the last ANALYZE and/or VACUUM has been performed on a table?

In PostgreSQL 8.4, is there a way to know when the last ANALYZE and/or VACUUM has been performed on a table?

I've been looking around in the documentation and later the pg_catalog but开发者_StackOverflow社区 not been able to find anything useful.


That would be pg_stat_all_tables

http://www.postgresql.org/docs/9.0/static/monitoring-stats.html


In PgAdminIII (I just assume that this is the tool of choice since it is great ;)), you see these information in the statistics column. There are entries for analyze/vauum and autoanalyze/autovacuum respectively.

0

精彩评论

暂无评论...
验证码 换一张
取 消