YugabyteDB comes bundled with a number of PostgreSQL extensions that are tested to work with YSQL. We're incrementally developing support for as many extensions as possible. (Since YugabyteDB’s underlying storage architecture is not the same as PostgreSQL, many PostgreSQL extensions, particularly those that interact with the storage layer, won't work as-is on YugabyteDB.)
The following extensions are bundled with YugabyteDB. Click an extension's name for more detailed documentation and example code.
- fuzzystrmatch provides functions to determine similarities and distance between strings.
pg_stat_statements lets you track execution statistics for all SQL statements executed by a server.
pgAudit allows you to collect detailed session and object audit logging via YugabyteDB TServer logging. Audit logs are often required as part of government, financial, or other certifications, such as ISO.
pgcrypto provides cryptographic functions, including hashing, encryption, and decryption functions.
SPI, the server programming interface module, allows you to create functions and stored procedures in C.
Other verified extensions
The following extensions are verified to work with YugabyteDB, but aren't pre-bundled. Click an extension's name for detailed installation and usage documentation.
- PostGIS is a spatial database extender for PostgreSQL-compatible object-relational databases. (Note that YugabyteDB does not currently support GiST indexes.)
- postgresql-hll provides support for HyperLogLog, a fixed-size, set-like structure used for distinct value counting with tunable precision.
- uuid-ossp provides functions to generate universally unique identifiers (UUIDs), and functions to produce certain special UUID constants.