@sql-extra/vacuum v0.1.1

Garbage-collect and optionally analyze a database (VACUUM).

const vacuum = require('@sql-extra/alter-event-trigger');
// vacuum([options], [table], [columns])
// -> SQL query


vacuum();
// VACUUM;

vacuum({full: true, verbose: true, analyze: true});
// VACUUM FULL VERBOSE ANALYZE;

vacuum({full: true, verbose: true, analyze: true});
// VACUUM "myevent" OWNER TO "jalandhar";

vacuum({}, 'mytable');
// VACUUM "mytable";

vacuum({analyze: true}, 'mytable', ['id', 'hash']);
// VACUUM ANALYZE "mytable" ("id", "hash");