A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
☆1,469Aug 10, 2023Updated 3 years ago
Alternatives and similar repositories for pgx_scripts
Users that are interested in pgx_scripts are comparing it to the libraries listed below. We may earn a commission when you buy through links labeled 'Ad' on this page.
Sorting:
- Queries to mesure statistical bloat in indexes and tables for PostgreSQL☆581Aug 23, 2022Updated 4 years ago
- Reorganize tables in PostgreSQL databases with minimal locks☆2,314May 8, 2026Updated 5 months ago
- The missing set of useful tools for Postgres DBAs and all engineers☆1,291Aug 18, 2026Updated last month
- Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.☆100Jul 3, 2024Updated 2 years ago
- Useful PostgreSQL utilities☆1,219Sep 15, 2026Updated 3 weeks ago
- Virtual machines for every use case on DigitalOcean • AdGet dependable uptime with 99.99% SLA, simple security tools, and predictable monthly pricing with DigitalOcean's virtual machines, called Droplets.
- Bloat check script for PostgreSQL☆151Feb 16, 2026Updated 7 months ago
- Command-line admin tool for observing and troubleshooting Postgres.☆1,631Sep 10, 2026Updated 3 weeks ago
- Nagios check_postgres plugin for checking status of PostgreSQL databases☆602Jan 2, 2025Updated last year
- A PostgreSQL extension for automatic bloat cleanup☆700Sep 22, 2026Updated 2 weeks ago
- plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL …☆782Updated this week
- Collect and display information and stats from a running PostgreSQL server☆1,111Sep 9, 2026Updated last month
- Functions and views to facilitate PostgreSQL object access inspection☆28May 16, 2024Updated 2 years ago
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆342Jun 20, 2026Updated 3 months ago
- A fast PostgreSQL Log Analyzer☆4,069Updated this week
- Deploy to Railway using AI coding agents - Free Credits Offer • AdUse Claude Code, Codex, OpenCode, and more. Autonomous software development now has the infrastructure to match with Railway.
- postgresql extension providing Active session history☆191Sep 30, 2026Updated last week
- Show query plans of all currently running SQL statements☆209Jun 3, 2026Updated 4 months ago
- Hypothetical Indexes for PostgreSQL☆1,726Updated this week
- Sampling based statistics of wait events☆180Aug 21, 2026Updated last month
- Gather statistics about physical disk access and CPU consumption done by backends.☆279Jun 20, 2026Updated 3 months ago
- A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql☆12,108Aug 31, 2026Updated last month
- Presentation materials for the Annotated.Conf Tutorial☆278Jun 15, 2018Updated 8 years ago
- PostgreSQL metrics monitor/dashboard☆1,839Dec 17, 2024Updated last year
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆266Updated this week
- Managed hosting for WordPress and PHP on Cloudways • AdManaged hosting for WordPress, Magento, Laravel, or PHP apps, on multiple cloud providers. Deploy in minutes on Cloudways by DigitalOcean.
- The automatic indexer for Postgres☆2,096Aug 15, 2026Updated last month
- pg_activity is a top like application for PostgreSQL server activity monitoring.☆3,052Sep 21, 2026Updated 2 weeks ago
- A performance dashboard for Postgres☆8,933Sep 25, 2026Updated 2 weeks ago
- Query Performance Monitoring Tool for PostgreSQL☆590Updated this week
- ☆359Oct 15, 2023Updated 2 years ago
- Tasty treats for PostgreSQL☆115Feb 1, 2019Updated 7 years ago
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆62Aug 17, 2026Updated last month
- Nagios remote agent☆188Updated this week
- An extension of PostgreSQL which contains some customized statistics views.☆19Sep 26, 2016Updated 10 years ago
- Deploy on Railway without the complexity - Free Credits Offer • AdConnect your repo and Railway handles the rest with instant previews. Quickly provision container image services, databases, and storage volumes.
- Postgres extension and service for automated failover and high-availability☆1,392Updated this week
- Tools for PostgreSQL maintenance☆181Apr 28, 2016Updated 10 years ago
- PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which …☆152Jun 26, 2026Updated 3 months ago
- Postgres historic workload reports☆314Sep 15, 2026Updated 3 weeks ago
- A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/☆1,957Sep 20, 2026Updated 2 weeks ago
- Activate/deactivate/verify checksums in offline Postgres clusters☆30Aug 21, 2026Updated last month
- ⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup☆173Jan 19, 2026Updated 8 months ago