shane-borden / sqlScripts
Central collection of sql scripts that can help diagnose problems and expose metadata about various DBMS Products.
☆56Updated 3 weeks ago
Alternatives and similar repositories for sqlScripts
Users that are interested in sqlScripts are comparing it to the libraries listed below
Sorting:
- Contains PostgreSQL functions which I regularly needed.☆138Updated 3 weeks ago
- pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored usi…☆80Updated 3 weeks ago
- Show query plans of all currently running SQL statements☆189Updated last week
- Set up 3-Node highly available PostgreSQL cluster☆60Updated 6 months ago
- Sampling based statistics of wait events☆156Updated last month
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆198Updated this week
- ☆27Updated 4 months ago
- Functions and views to facilitate PostgreSQL object access inspection☆28Updated last year
- E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities☆79Updated this week
- Small extension to keep track of postgresql settings modification☆52Updated 6 months ago
- A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.☆52Updated 4 months ago
- An automated PostgreSQL database parameter tuning tool based on the Bayesian Optimization☆49Updated 4 months ago
- postgresql extension providing Active session history☆178Updated 4 months ago
- A set of scripts, examples and tutorials on various stuff to learn and manage a PostgreSQL cluster.☆25Updated last month
- Postgres Catalog Checker☆82Updated 6 months ago
- TRAKTOR: Set up true multimaster replication clusters with vanilla PostgreSQL servers.☆36Updated 2 weeks ago
- Maintains stateful Postgres on Spot VMs☆55Updated last week
- A simple set of views to see ALL permissions in a PostgreSQL database☆155Updated 5 months ago
- NEXTGRES In-Database Connection Pool Extension for Postgres☆30Updated last year
- Gather statistics about physical disk access and CPU consumption done by backends.☆228Updated 2 months ago
- Tool for query progress monitoring in PostgreSQL☆157Updated 2 months ago
- Perform maintenance tasks which require a table to be rewritten (i.e. the table data to be copied to a new storage) and which are expecte…☆39Updated this week
- Prometheus exporter for PostgreSQL☆62Updated last week
- PostgreSQL plain credential checker☆60Updated last month
- This is pgio (The SLOB Method for PostgreSQL).☆41Updated 2 years ago
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆60Updated last week
- PostgreSQL extension to manage Linux Control Groups☆36Updated 10 months ago
- Server side rollback at statement level for PostgreSQL like Oracle or DB2☆48Updated 7 months ago
- PostgreSQL dynamic data anonymization☆42Updated 3 months ago
- Query plan exporter for psql☆56Updated 2 years ago