README

This package provides a command that will vacuum and analylze tables for specific Laravel database connections for specific schemas. You can then create a scheduled task for this command to regularly optimize your database!

Installation

You can install the package via composer:

composer require cytech-services/laravel-postgres-vacuum-analyze

You can publish the config file with:

php artisan vendor:publish --tag="laravel-postgres-vacuum-analyze-config"

This is the contents of the published config file:

return [

    /**
     * The connections to use for the vacuum analyze command.
     */
    'connections' => [
        /**
         * The connection name.
         * By default, the connection name is the default postgres connection.
         */
        'pgsql' => [
            /**
             * The schema name.
             * By default, the schema name is the public schema.
             */
            'public' => [
                /**
                 * A array list of tables to include in the vacuum analyze command.
                 * If no tables are specified, all tables will be included.
                 */
                'include' => [
                    //
                ],

                /**
                 * A array list of tables to exclude in the vacuum analyze command.
                 */
                'exclude' => [
                    //
                ],
            ],
        ],
    ],

    // Enable or disable the logging of errors.
    'log_errors' => true,

    // Enable or disable verbose logging.
    'log_verbose' => true,
];

Usage

php artisan db:vacuum-analyze

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

License

The MIT License (MIT). Please see License File for more information.

cytech-services / laravel-postgres-vacuum-analyze

Maintainers

Details