A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
☆1,461Aug 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☆565Aug 23, 2022Updated 3 years ago
- Reorganize tables in PostgreSQL databases with minimal locks☆2,180Feb 13, 2026Updated 2 weeks ago
- The missing set of useful tools for Postgres DBAs and all engineers☆1,233Feb 10, 2026Updated 2 weeks ago
- Useful PostgreSQL utilities☆1,190Dec 5, 2025Updated 2 months ago
- Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.☆99Jul 3, 2024Updated last year
- Command-line admin tool for observing and troubleshooting Postgres.☆1,591Jan 6, 2026Updated last month
- Nagios check_postgres plugin for checking status of PostgreSQL databases☆593Jan 2, 2025Updated last year
- A PostgreSQL extension for automatic bloat cleanup☆650Oct 8, 2025Updated 4 months ago
- Bloat check script for PostgreSQL☆149Feb 16, 2026Updated last week
- Collect and display information and stats from a running PostgreSQL server☆1,074Jan 18, 2026Updated last month
- A fast PostgreSQL Log Analyzer☆3,966Updated this week
- plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL …☆740Feb 18, 2026Updated last week
- postgresql extension providing Active session history☆188Feb 7, 2026Updated 3 weeks ago
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆329Jan 10, 2026Updated last month
- Hypothetical Indexes for PostgreSQL☆1,610Updated this week
- Sampling based statistics of wait events☆170Feb 5, 2026Updated 3 weeks ago
- Gather statistics about physical disk access and CPU consumption done by backends.☆254Jan 17, 2026Updated last month
- A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql☆11,708Updated this week
- Show query plans of all currently running SQL statements☆203Jan 19, 2026Updated last month
- PostgreSQL metrics monitor/dashboard☆1,845Dec 17, 2024Updated last year
- Functions and views to facilitate PostgreSQL object access inspection☆28May 16, 2024Updated last year
- The automatic indexer for Postgres☆2,068Dec 26, 2025Updated 2 months ago
- pg_activity is a top like application for PostgreSQL server activity monitoring.☆2,996Jan 13, 2026Updated last month
- A performance dashboard for Postgres☆8,800Dec 26, 2025Updated 2 months ago
- ☆355Oct 15, 2023Updated 2 years ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆236Updated this week
- Query Performance Monitoring Tool for PostgreSQL☆557Updated this week
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆62May 7, 2025Updated 9 months ago
- Postgres extension and service for automated failover and high-availability☆1,329Nov 17, 2025Updated 3 months ago
- Postgres Explain Visualizer☆2,797Jul 15, 2020Updated 5 years ago
- Tools for PostgreSQL maintenance☆181Apr 28, 2016Updated 9 years ago
- Tasty treats for PostgreSQL☆113Feb 1, 2019Updated 7 years ago
- Partition management extension for PostgreSQL☆2,601Feb 21, 2026Updated last week
- Nagios remote agent☆180Feb 19, 2026Updated last week
- Simple script to analyse your PostgreSQL database configuration, and give tuning advice☆2,686Jan 8, 2024Updated 2 years ago
- PostgreSQL extension adding HyperLogLog data structures as a native data type☆1,208Oct 17, 2025Updated 4 months ago
- Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well …☆2,693Feb 18, 2026Updated last week
- PostgreSQL Audit Extension☆1,597Jan 26, 2026Updated last month
- A flamegraph generator for Postgres EXPLAIN ANALYZE output.☆1,615Jan 13, 2020Updated 6 years ago