PostgreSQL Functions to get information and execute statement about VACUUM and ANALYZE on tables, read the README 9.4 ====================================== IMPORTANT: There're bugs in the existing version. I'm working on it and will be releasing another version very soon. Building and install -------- run make install in postgresql execute: create extension vacuum_utils; Example ------- SELECT vacuum_utils.diff_to_autovaccum('public','customers');--Get diff to autovacuum of specific Table SELECT vacuum_utils.get_table_vacuum_threshold ('public','customers');--Get vacuum threshold of specific Table SELECT vacuum_utils.get_table_analyze_threshold ('public','customers');--Get analyze threshold of specific Table SELECT vacuum_utils.disable_autovacuum('public','customers'); --Disable autovacumm of specific Table SELECT vacuum_utils.enable_autovacuum ('public','customers');--Enable autovacumm of specific Table SELECT vacuum_utils.execute_analyze('public','customers');--EXECUTE analyze of specific Table SELECT vacuum_utils.last_analyze_count ('public','customers');--Get timestamp of last analyze and analyze count of a table SELECT vacuum_utils.last_autoanalyze_count ('public','customers');--Get timestamp of last autoanalyze and autoanalyze count of a table SELECT vacuum_utils.last_autovacuum_count ('public','customers'); --Get timestamp of last autovacuum and autovacuum count of a table SELECT vacuum_utils.last_vacuum_count ('public','customers'); --Get timestamp of last vacuum and vacuum count of a table ------ Anthony Sotolongo leon asotolongo@gmail.com