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

Advanced Edition clusters support only the extensions listed in Advanced Edition Supported 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

The following table lists every extension supported on PostgreSQL Advanced Edition clusters. Extensions marked Pre-installed are already enabled, so you don’t need to run CREATE EXTENSION for them. Extensions marked Available aren’t enabled by default, and you can enable them with CREATE EXTENSION. To request an extension that isn’t listed, contact support.