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
