Does postgresql keep a full table scan?

I would like to do something similar to what is described in http://www.bestbrains.dk/Blog/2010/03/25/HowToAssertThatYourSQLDoesNotDoFullTableScans.aspx , but for this I need postgres to track any full table scan. Is there such a thing for postgres?

+3
source share
1 answer

Look pg_stat_get_numscans(oid)(the number of consecutive scans per table) and statistics collector (in general).

+4
source

Source: https://habr.com/ru/post/1738681/


All Articles