For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

To expand the functionality of your PostgreSQL cluster, you can use extensions, which are bundled packages of SQL objects.

Install, Upgrade, or Disable Extensions

You can install supported extensions with psql’s CREATE EXTENSION command:

CREATE EXTENSION <extension-name>;

You can upgrade extensions to their latest version with psql’s ALTER EXTENSION command:

ALTER EXTENSION <extension-name> UPDATE;

You can disable extensions with psql’s DROP EXTENSION command:

DROP EXTENSION <extension-name>;

To see a list of extensions currently installed, use the following command:

\dx

The pg_stat_statements extension is required for Query Analytics when monitoring with Percona Monitoring and Management (PMM). See Configure a PMM Monitoring User.

Standard Edition Supported Extensions

The following versioned lists apply to PostgreSQL Standard Edition clusters. This list is current as of the Validated date in the page footer.

You can see available extensions from the psql command line with the following command:

SELECT * FROM pg_available_extensions;

Not all extensions listed in pg_available_extensions are installable on Standard Edition clusters. To list installable superuser-only and untrusted extensions on Standard Edition, run the following command.

SELECT *
FROM pg_available_extension_versions
WHERE name = ANY(string_to_array(current_setting('extwlist.extensions'), ','));

If required, assign superuser privileges to enable their use.

Request support for a new extension by voting for an existing request or submitting a new idea.

Advanced Edition Supported Extensions

PostgreSQL Advanced Edition clusters include a limited set of extensions. Advanced Edition is in public preview, and the supported extensions below may change before general availability.

The following extensions are pre-installed on Advanced Edition clusters and don’t require the CREATE EXTENSION command: pg_repack, pg_stat_statements, pgaudit, plpgsql, and vector.

To enable an extension that isn’t pre-installed, use CREATE EXTENSION as described in Install, Upgrade, or Disable Extensions.