Michael Vitale's Projects
Blog content for working with Amazon RDS and Aurora Engine Logs
Queries upon queries in Booktown, USA [sql, databases]
Functions and views to facilitate PostgreSQL object access inspection
Simplify process of getting AWS logs for PostgreSQL using AWS CLI APIs
GitHub Pages for MichaelDBA
pg_alert is a PostgreSQL log file monitoring and alerting tool.
Bloat check script for PostgreSQL
Based on pg_report, but only issues email/slack alerts and console output, no html output format.
This is a bash script which does pg dumps in parallel for all schemas in a given database as linux background jobs.
PostgreSQL PL/PGSQL function that generates table DDL for the given schema/table.
Schema Comparison Tool
Reorganize tables in PostgreSQL databases with minimal locks
This python program does a general health check on the target PostgreSQL cluster.
pg_statsinfo
PostgreSQL Smart Vacuuming Tool
A wrapper around the pgbouncer show commands
DDL eXtractor functions for PostgreSQL (ddlx)