Does postgresql keep track of full table scans it makes?

Question

I'd like to do something similar to what's described in http://www.bestbrains.dk/Blog/2010/03/25/HowToAssertThatYourSQLDoesNotDoFullTableScans.aspx but for that I'd need postgres to keep track of any full table scans it does. Is there such a thing for postgres?

Answer 1

Have a look at pg_stat_get_numscans(oid) (number of sequential scans on a table) and the statistics collector (in general).