Postgres utilities and extensions
In this section, we spotlight PostgreSQL extensions and utilities that are developed and maintained by our team.
Postgres Professional takes the lead on a number of PostgreSQL development projects.
Below you can find a list of them and get links to GitHub or sources of additional information.
For any business inquiries, bug reports or feature requests, please contact us via
info@postgrespro.com.
pg_probackup
a utility to manage backup and recovery of PostgreSQL database clusters
pgpro_pwr
a module for detection of the most resource-intensive activities in PostgreSQL
mamonsu
an extensible cross-platform solution that can collect and visualize multiple PostgreSQL and system metrics
PostgreSQL monitoring plugin for Zabbix
a built-in Zabbix monitoring engine, intended for Zabbix Server version 5 and higher
pgpro_stats
an extension that provides a means for tracking planning and execution statistics of all SQL statements executed by a server
pg_stat_statements
a module that provides a means for tracking execution statistics of all SQL statements executed by a server
online_analyze
a module that provides a set of features that immediately update statistics after INSERT, UPDATE, DELETE, or SELECT INTO operations for the affected tables
pg_pathman
a module that provides an optimized partitioning mechanism and functions to manage partitions
pg_wait_sampling
an extension for collecting sampling-based statistics on wait events
ptrack
a block-level incremental backup engine for PostgreSQL
multimaster
an open-source extension enabling real synchronous replication in Postgres
RUM
a module that provides an access method to work with the RUM indexes
AQO
an extension using ML methods for cost-based query optimization
pg_variables
an extension for defining and using variables in client sessions
pgbouncer
a lightweight connection pooler for PostgreSQL