A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
☆1,463Aug 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
Sorting:
- Queries to mesure statistical bloat in indexes and tables for PostgreSQL☆568Aug 23, 2022Updated 3 years ago
- Reorganize tables in PostgreSQL databases with minimal locks☆2,191Mar 8, 2026Updated last week
- The missing set of useful tools for Postgres DBAs and all engineers☆1,244Mar 12, 2026Updated last week
- Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.☆99Jul 3, 2024Updated last year
- Useful PostgreSQL utilities☆1,195Dec 5, 2025Updated 3 months ago
- Bloat check script for PostgreSQL☆150Feb 16, 2026Updated last month
- Command-line admin tool for observing and troubleshooting Postgres.☆1,597Jan 6, 2026Updated 2 months ago
- Nagios check_postgres plugin for checking status of PostgreSQL databases☆593Jan 2, 2025Updated last year
- A PostgreSQL extension for automatic bloat cleanup☆654Oct 8, 2025Updated 5 months ago
- plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL …☆745Updated this week
- Collect and display information and stats from a running PostgreSQL server☆1,076Jan 18, 2026Updated 2 months ago
- A fast PostgreSQL Log Analyzer☆3,978Feb 21, 2026Updated 3 weeks ago
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆329Jan 10, 2026Updated 2 months ago
- Functions and views to facilitate PostgreSQL object access inspection☆28May 16, 2024Updated last year
- postgresql extension providing Active session history☆188Mar 12, 2026Updated last week
- Hypothetical Indexes for PostgreSQL☆1,614Feb 22, 2026Updated 3 weeks ago
- Show query plans of all currently running SQL statements☆204Jan 19, 2026Updated 2 months ago
- Sampling based statistics of wait events☆172Mar 7, 2026Updated last week
- Gather statistics about physical disk access and CPU consumption done by backends.☆257Jan 17, 2026Updated 2 months ago
- A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql☆11,763Feb 22, 2026Updated 3 weeks ago
- The automatic indexer for Postgres☆2,073Dec 26, 2025Updated 2 months ago
- PostgreSQL metrics monitor/dashboard☆1,845Dec 17, 2024Updated last year
- pg_activity is a top like application for PostgreSQL server activity monitoring.☆3,004Jan 13, 2026Updated 2 months ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆240Mar 10, 2026Updated last week
- A performance dashboard for Postgres☆8,810Dec 26, 2025Updated 2 months ago
- Tools for PostgreSQL maintenance☆181Apr 28, 2016Updated 9 years ago
- Query Performance Monitoring Tool for PostgreSQL☆559Updated this week
- ☆356Oct 15, 2023Updated 2 years ago
- Tasty treats for PostgreSQL☆114Feb 1, 2019Updated 7 years ago
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆62May 7, 2025Updated 10 months ago
- Nagios remote agent☆181Feb 19, 2026Updated last month
- An extension of PostgreSQL which contains some customized statistics views.☆18Sep 26, 2016Updated 9 years ago
- Postgres extension and service for automated failover and high-availability☆1,331Nov 17, 2025Updated 4 months ago
- Postgres Explain Visualizer☆2,797Jul 15, 2020Updated 5 years 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,915Mar 12, 2026Updated last week
- Postgres historic workload reports☆300Nov 28, 2025Updated 3 months ago
- Presentation materials for the Annotated.Conf Tutorial☆277Jun 15, 2018Updated 7 years ago
- Activate/deactivate/verify checksums in offline Postgres clusters☆30Sep 3, 2025Updated 6 months ago
- Simple script to analyse your PostgreSQL database configuration, and give tuning advice☆2,690Jan 8, 2024Updated 2 years ago