Postgres Analyze performed

Question

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 not been able to find anything useful.

user330315 · Accepted Answer · 2011-04-20 08:06:49Z

2

That would be pg_stat_all_tables

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

answered Apr 20, 2011 at 8:06

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

peitur Over a year ago

Thanks, missed the attributes on that table.

DrColossos · Accepted Answer · 2011-04-20 09:43:26Z

0

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.

answered Apr 20, 2011 at 9:43

DrColossos

13.1k3 gold badges49 silver badges68 bronze badges

Collectives™ on Stack Overflow

Postgres Analyze performed

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related