VK Cloud logo
Updated atOctober 31, 2023   06:09 AM

PostgreSQL extensions

Extensions specific to PostgreSQL and PostgresPro are described. Read about extensions for monitoring DB instances in node_exporter, postgres_exporter and zabbix.

Holistic.dev (holistic)

Holistic.dev is a static analyzer and tool for extracting information about database organization. Thanks to the collected data, the tool automatically monitors the integrity of relations between database objects and detects possible issues. Administrators use information from Holistic.dev reports to optimize the database. Holistic.dev only collects information about DML queries and database schema, database configuration and query execution plans are not analyzed.

Read more in official FAQ of the extension.

JsQuery

The extension provides the JsQuery query language that extends jsonb data type processing capabilities in PostgreSQL.

pgBadger

The pgBadger extension allows analyzing PostgreSQL logs and building reports. These reports provide statistics on SQL queries and Autovacuum, as well other data. Read more about features in the extension documentation.

pg_hint_plan

When executing an SQL query, the PostgreSQL planner tries to select the best execution plan. However, the chosen plan is not always optimal, as the planner does not take into account some data properties, such as correlations between columns. The pg_hint_plan allows adjusting query execution plans by giving hints to the PostgreSQL planner. Hints can be given as comments of a special form to SQL queries, or as records in the special hint_plan.hints table.

pg_partman

The pg_partman extension is advanced table partitioning manager. Two partitioning methods are supported: partitioning based on pg_partman triggers, and native partitioning based on the PostgreSQL's built-in functionality. Read more in the extension documentation.

The partman schema is created alongside the extension. The extension then is installed in the schema.

To do native partitioning, a partman user will be created and configured in PostgreSQL. It is possible to set a password for this user. To do partitioning based on pg_partman triggers, the postgres user should be used.

pg_stat_kcache

The pg_stat_kcache extension collects statistics about real reads and writes done by the filesystem layer.

pg_stat_statements

The extension pg_stat_statements allows tracking planning and execution statistics of all SQL statements.

PostGIS

The PostGIS extension adds capabilities of working with geographic data into PostgreSQL. It implements several geospatial data types, as well supports storing, indexing and processing geographic data.

For more information abount using the extension, see Using the PostGIS extension in PostgreSQL and PostgresPro.

postgres_extensions

A set of popular PostgreSQL extensions that require no additional configuration. You can select one or more extensions to install. They are listed on the Extension parameters tab.

TimescaleDB

The TimescaleDB extension adds advanced time-series data manipulating capabilities to PostgreSQL. It provides full support for standard PostgreSQL SQL syntax when working with time-series data that is stored in hypertables. Automatic partitioning of hypertables with time-series data by time and space is supported.