Extensions
Available and installed extensions
Showing 51 entries
Name Default version Installed version
Comment
pg_stat_statements 1.6 1.6 track execution statistics of all SQL statements executed
plpgsql 1.0 1.0 PL/pgSQL procedural language
pg_trgm 1.4 text similarity measurement and index searching based on trigrams
tsm_system_rows 1.0 TABLESAMPLE method which accepts number of rows as a limit
earthdistance 1.1 calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.1 determine similarities and distance between strings
pg_buffercache 1.3 examine the shared buffer cache
timetravel 1.0 functions for implementing time travel
lo 1.1 Large Object maintenance
dict_xsyn 1.0 text search dictionary template for extended synonym processing
isn 1.2 data types for international product numbering standards
plpython3u 1.0 PL/Python3U untrusted procedural language
dblink 1.2 connect to other PostgreSQL databases from within a database
pg_freespacemap 1.2 examine the free space map (FSM)
sslinfo 1.2 information about SSL certificates
citext 1.5 data type for case-insensitive character strings
pgrowlocks 1.2 show row-level locking information
file_fdw 1.0 foreign-data wrapper for flat file access
dict_int 1.0 text search dictionary template for integers
insert_username 1.0 functions for tracking who changed a table
pg_prewarm 1.2 prewarm relation data
tcn 1.0 Triggered change notifications
pgstattuple 1.5 show tuple-level statistics
btree_gist 1.5 support for indexing common datatypes in GiST
moddatetime 1.0 functions for tracking last modification time
adminpack 2.0 administrative functions for PostgreSQL
refint 1.0 functions for implementing referential integrity (obsolete)
uuid-ossp 1.1 generate universally unique identifiers (UUIDs)
tsm_system_time 1.0 TABLESAMPLE method which accepts time in milliseconds as a limit
pageinspect 1.7 inspect the contents of database pages at a low level
pgcrypto 1.3 cryptographic functions
jsonb_plpython3u 1.0 transform between jsonb and plpython3u
cube 1.4 data type for multidimensional cubes
tablefunc 1.0 functions that manipulate whole tables, including crosstab
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info
intarray 1.2 functions, operators, and index support for 1-D arrays of integers
hstore_plpython3u 1.0 transform between hstore and plpython3u
intagg 1.1 integer aggregator and enumerator (obsolete)
ltree 1.1 data type for hierarchical tree-like structures
unaccent 1.1 text search dictionary that removes accents
postgres_fdw 1.0 foreign-data wrapper for remote PostgreSQL servers
pgagent 4.0 A PostgreSQL job scheduler
autoinc 1.0 functions for autoincrementing fields
ltree_plpython3u 1.0 transform between ltree and plpython3u
bloom 1.0 bloom access method - signature file based index
btree_gin 1.3 support for indexing common datatypes in GIN
timescaledb 2.3.1 Enables scalable inserts and complex queries for time-series data
seg 1.3 data type for representing line segments or floating-point intervals
hstore 1.5 data type for storing sets of (key, value) pairs
amcheck 1.1 functions for verifying relation integrity
xml2 1.1 XPath querying and XSLT