shane-borden / sqlScriptsLinks
Central collection of sql scripts that can help diagnose problems and expose metadata about various DBMS Products.
☆60Updated 2 months ago
Alternatives and similar repositories for sqlScripts
Users that are interested in sqlScripts are comparing it to the libraries listed below
Sorting:
- Stateful Postgres on cheap Spot VMs☆59Updated last week
- pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored usi…☆84Updated 6 months ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆225Updated last week
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆321Updated 2 weeks ago
- Query plan exporter for psql☆55Updated 2 years ago
- pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative tim…☆236Updated 3 weeks ago
- Show query plans of all currently running SQL statements☆201Updated last month
- Tool for query progress monitoring in PostgreSQL☆158Updated last month
- ☆28Updated 11 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…☆45Updated 2 months ago
- E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities☆90Updated 2 weeks ago
- Automatic reindexing of PostgreSQL indexes (bloat cleanup).☆101Updated 3 months ago
- Gather statistics about physical disk access and CPU consumption done by backends.☆245Updated 3 weeks ago
- postgresql extension providing Active session history☆187Updated last month
- Small extension to keep track of postgresql settings modification☆53Updated 2 months ago
- Set up 3-Node highly available PostgreSQL cluster☆70Updated 3 months ago
- A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.☆55Updated 11 months ago
- send bytes using PostgreSQL user defined function to TCP/IP socket☆19Updated 5 years ago
- A simple tool to help administrators restore PostgreSQL databases periodically☆52Updated 4 years ago
- History and audit of table changes in PostgreSQL☆33Updated 6 months ago
- Prometheus exporter for PostgreSQL☆92Updated this week
- A set of scripts, examples and tutorials on various stuff to learn and manage a PostgreSQL cluster.☆25Updated 7 months ago
- PostgreSQL extension allowing privilege escalation with enhanced logging and control☆77Updated 2 months ago
- Server side rollback at statement level for PostgreSQL like Oracle or DB2☆54Updated 2 months ago
- PG Failover Slots extension☆100Updated 2 months ago
- A PostgreSQL extension for automatic bloat cleanup☆619Updated last month
- Postgres Extension written in Rust, to enable data tiering to AWS S3☆144Updated last year
- PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables and the others RDBMS☆95Updated 3 months ago
- Transparent Data Encryption for PostgreSQL☆178Updated this week
- PostgreSQL extension which provides persistent logging within transactions and functions.☆194Updated 3 years ago