shane-borden / sqlScriptsLinks
Central collection of sql scripts that can help diagnose problems and expose metadata about various DBMS Products.
☆57Updated last month
Alternatives and similar repositories for sqlScripts
Users that are interested in sqlScripts are comparing it to the libraries listed below
Sorting:
- pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored usi…☆83Updated 2 months ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆214Updated this week
- History and audit of table changes in PostgreSQL☆33Updated 3 months ago
- Set up 3-Node highly available PostgreSQL cluster☆66Updated 2 weeks ago
- ☆27Updated 8 months ago
- Show query plans of all currently running SQL statements☆198Updated 3 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…☆231Updated last week
- Stateful Postgres on cheap Spot VMs☆58Updated last week
- TRAKTOR: Set up true multimaster replication clusters with vanilla PostgreSQL servers.☆37Updated 4 months ago
- Small extension to keep track of postgresql settings modification☆53Updated last month
- A simple tool to help administrators restore PostgreSQL databases periodically☆53Updated 3 years ago
- Automatic reindexing of PostgreSQL indexes (bloat cleanup).☆100Updated 2 weeks ago
- Tool for query progress monitoring in PostgreSQL☆157Updated last week
- send bytes using PostgreSQL user defined function to TCP/IP socket☆19Updated 5 years ago
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆308Updated last month
- Track per-plan call counts, execution times and EXPLAIN texts in Postgres☆19Updated 3 months ago
- A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.☆54Updated 8 months ago
- Gather statistics about physical disk access and CPU consumption done by backends.☆240Updated 2 months ago
- pgCompare – a straightforward utility crafted to simplify the data comparison process, providing a robust solution for comparing data acr…☆166Updated last month
- postgresql extension providing Active session history☆182Updated last month
- this repos is moving to https://codeberg.org/c2main/pgfincore | Mirror of http://git.postgresql.org/gitweb/?p=pgfincore.git;a=summary☆107Updated 8 months ago
- PostgreSQL extension which provides persistent logging within transactions and functions.☆189Updated 3 years ago
- E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities☆80Updated this week
- Logical multi-master PostgreSQL replication☆227Updated this week
- Spot vulnerabilities in postgres SQL scripts☆119Updated 2 weeks ago
- pg_sqltxplain - Simplifying PostgreSQL Execution Plan Analysis by curating underlying stats in a single html report.☆28Updated 10 months ago
- pganalyze statistics collector for gathering PostgreSQL metrics and log data☆373Updated 2 weeks ago
- Transfer manager auxiliary functions☆46Updated 3 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 3 weeks ago