Say hello to the first official release of the SmartPostgres Box of Tricks! First up is check_indexes, a script that lists things like index types, definitions, sizes, last vacuum dates, dead tuples, and more. The warnings columns will also tell you if autovacuum isn’t keeping up, statistics are way out of date, and more: Next...
