A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
☆1,466Aug 10, 2023Updated 2 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☆571Aug 23, 2022Updated 3 years ago
- Reorganize tables in PostgreSQL databases with minimal locks☆2,212Mar 23, 2026Updated 2 weeks ago
- The missing set of useful tools for Postgres DBAs and all engineers☆1,253Mar 12, 2026Updated 3 weeks ago
- Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.☆99Jul 3, 2024Updated last year
- Useful PostgreSQL utilities☆1,200Dec 5, 2025Updated 4 months ago
- Managed hosting for WordPress and PHP on Cloudways • AdManaged hosting with the flexibility to host WordPress, Magento, Laravel, or PHP apps, on multiple cloud providers. Cloudways by DigitalOcean.
- Bloat check script for PostgreSQL☆150Feb 16, 2026Updated last month
- Command-line admin tool for observing and troubleshooting Postgres.☆1,596Jan 6, 2026Updated 3 months ago
- Nagios check_postgres plugin for checking status of PostgreSQL databases☆594Jan 2, 2025Updated last year
- A PostgreSQL extension for automatic bloat cleanup☆664Oct 8, 2025Updated 6 months ago
- plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL …☆750Updated this week
- Collect and display information and stats from a running PostgreSQL server☆1,085Jan 18, 2026Updated 2 months ago
- A fast PostgreSQL Log Analyzer☆3,989Feb 21, 2026Updated last month
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆330Updated this week
- Functions and views to facilitate PostgreSQL object access inspection☆28May 16, 2024Updated last year
- Proton VPN Special Offer - Get 70% off • AdSpecial partner offer. Trusted by over 100 million users worldwide. Tested, Approved and Recommended by Experts.
- postgresql extension providing Active session history☆188Mar 12, 2026Updated 3 weeks ago
- Hypothetical Indexes for PostgreSQL☆1,625Feb 22, 2026Updated last month
- Show query plans of all currently running SQL statements☆204Jan 19, 2026Updated 2 months ago
- Sampling based statistics of wait events☆172Apr 1, 2026Updated last week
- Gather statistics about physical disk access and CPU consumption done by backends.☆259Jan 17, 2026Updated 2 months ago
- A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql☆11,807Mar 28, 2026Updated last week
- The automatic indexer for Postgres☆2,075Dec 26, 2025Updated 3 months ago
- PostgreSQL metrics monitor/dashboard☆1,846Dec 17, 2024Updated last year
- pg_activity is a top like application for PostgreSQL server activity monitoring.☆3,007Jan 13, 2026Updated 2 months ago
- DigitalOcean Gradient AI Platform • AdBuild production-ready AI agents using customizable tools or access multiple LLMs through a single endpoint. Create custom knowledge bases or connect external data.
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆253Mar 27, 2026Updated last week
- A performance dashboard for Postgres☆8,830Updated this week
- Tools for PostgreSQL maintenance☆181Apr 28, 2016Updated 9 years ago
- ☆357Oct 15, 2023Updated 2 years ago
- Query Performance Monitoring Tool for PostgreSQL☆565Apr 1, 2026Updated last week
- 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.☆63May 7, 2025Updated 11 months ago
- Nagios remote agent☆181Updated this week
- An extension of PostgreSQL which contains some customized statistics views.☆19Sep 26, 2016Updated 9 years ago
- Proton VPN Special Offer - Get 70% off • AdSpecial partner offer. Trusted by over 100 million users worldwide. Tested, Approved and Recommended by Experts.
- Postgres extension and service for automated failover and high-availability☆1,334Nov 17, 2025Updated 4 months ago
- Postgres Explain Visualizer☆2,794Jul 15, 2020Updated 5 years ago
- Postgres historic workload reports☆303Nov 28, 2025Updated 4 months 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,920Mar 22, 2026Updated 2 weeks ago
- Activate/deactivate/verify checksums in offline Postgres clusters☆30Sep 3, 2025Updated 7 months ago
- Presentation materials for the Annotated.Conf Tutorial☆278Jun 15, 2018Updated 7 years ago
- Simple script to analyse your PostgreSQL database configuration, and give tuning advice☆2,688Jan 8, 2024Updated 2 years ago