shane-borden / sqlScripts
Central collection of sql scripts that can help diagnose problems and expose metadata about various DBMS Products.
☆53Updated 4 months ago
Alternatives and similar repositories for sqlScripts:
Users that are interested in sqlScripts are comparing it to the libraries listed below
- Contains PostgreSQL functions which I regularly needed.☆128Updated this week
- Small extension to keep track of postgresql settings modification☆51Updated 3 months ago
- A simple tool to help administrators restore PostgreSQL databases periodically☆54Updated 3 years ago
- History of table changes in PostgreSQL☆30Updated 3 weeks ago
- Set up 3-Node highly available PostgreSQL cluster☆59Updated 3 months ago
- Automatic reindexing of B-tree indexes (bloat cleanup)☆35Updated 2 years ago
- A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.☆53Updated last month
- Show query plans of all currently running SQL statements☆189Updated last week
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆58Updated 7 months ago
- A set of scripts, examples and tutorials on various stuff to learn and manage a PostgreSQL cluster.☆25Updated 4 months ago
- Maintains stateful Postgres on Spot VMs☆52Updated 2 weeks ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆172Updated this week
- PostgreSQL Foreign Data Wrapper to Connect to pgbouncer☆34Updated last week
- Functions and views to facilitate PostgreSQL object access inspection☆28Updated 9 months ago
- PostgreSQL plain credential checker☆59Updated last month
- TRAKTOR: Set up true multimaster replication clusters with vanilla PostgreSQL servers.☆33Updated last year
- pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored usi…☆76Updated 7 months ago
- E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities☆79Updated this week
- postgresql extension providing Active session history☆173Updated last month
- 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 3 months ago
- send bytes using PostgreSQL user defined function to TCP/IP socket☆19Updated 4 years ago
- PostgreSQL replication cache with Redis, Memcached and REST APIs☆113Updated last year
- ☆23Updated 2 months ago
- This is pgio (The SLOB Method for PostgreSQL).☆41Updated 2 years ago
- Ansible code for deploying EDB Postgres database clusters and related products.☆83Updated 4 months ago
- Transfer manager auxiliary functions☆44Updated 2 weeks ago
- Sampling based statistics of wait events☆153Updated last week
- PostgreSQL Audit Analyzer☆43Updated this week
- PostgreSQL dynamic data anonymization☆41Updated last week
- Postgres extension for monitoring client authentication attempts☆27Updated 2 months ago