vacuum_utils 0.1.0

This Release
vacuum_utils 0.1.0
Date
Status
Stable
Abstract
Functions to get information and execute statement about VACUUM and ANALYZE on tables, read the README
Released By
anthony
License
PostgreSQL
Resources
Special Files
Tags

Extensions

vacuum_utils 0.1.0
Functions to get information and execute statement about VACUUM and ANALYZE on tables, read the README

README

Contents

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