Plug-in name

Description 

PostGIS 

Geographic information data 

fuzzystrmatch 

Fuzzy match of character string

pgcrypto

Encryption function

intarray

Function, operator, and index that are relevant to integer array

cstore_fdw

Use RC_file format for column-based storage of data

pg_pathman

It provides function with flexible partition

zhparser

Chinese full-text search

address_standardizer

It supports formating data of geographic position

address_standardizer_data_us

It supports formating data of geographic position

postgis_tiger_geocoder

Geocoding

postgis_topology

It supports topological operations with functions

autoinc

Function used in increment domain

bloom

It supports index access method of bloom filter

btree_gin

It supports gin index

btree_gist

It supports gist index

citext

It provides case-insensitive text field

cube

It provide cube of multiple data types

dblink

It supports connecting to other PostgreSQL database in a database session

earthdistance

It provides two methods to calculate ground circle distance on the earth surface

fuzzystrmatch

It provides multiple functions to determine the similarity and distance between character strings

hstore

hstore data type is used to store key-value pairs in a single PostgreSQL value

insert_username

It tracks the user who modifies functions of a table

intarray

It provides some useful functions and operators to operate integer arrays that have no null value

isn

It provides data types for the international numbering standard of the following products:

EAN13, UPC, ISBN (book), ISMN (music), and ISSN (periodical)

lo

It provides support for managing large-scale objects (also called LO or BLOB) It includes a data type lo and a trigger lo_manage

ltree

The data type ltree represents the tags of data stored in one hierarchy of the tree structure. It also has expansion function of searching in the tag tree

moddatetime

It tracks functions for the last modification time

pg_buffercache

It provides a method to check shared buffer in real time Only super accounts and role members of pg_read_all_stats can use this plug-in

You need to submit a Ticket if you want to use this plug-in

pg_freespacemap

It provides a method to check free space mapping (FSM). It will withdraw public access from functions to avoid potential security issues. Only super accounts and role members of pg_read_all_stats can use this plug-in.

You need to submit a Ticket if you want to use this plug-in.

pg_prewarm

It provides a convenient method to load relational data into the operating system buffer or PostgreSQL buffer.

pgrowlocks

It provides a function to present row lock information of a designated table.

pg_stat_statements

It provides a method to track the execution statistics of all SQL statements executed by a server.

pgstattuple

It provides multiple functions to obtain statistics of layers of tuples

pg_trgm

It provides functions and operators that determine the similarity of letters, digits, and texts that are based on trigram matching

pg_visibility

It provides a method to check visibility map (VM) and page-level visibility information. It also provides a function to check the integrity of VM and re-establish VM in a mandatory way.

postgres_fdw

It provides the external data wrapper postgres_fdw, and can be used to access data stored in an external PostgreSQL server.

refint

It is used in functions that realize referential integrity.

seg

It is a data type to present line segment or floating-point interval. seg can represent uncertainty in the interval endpoints, making it especially useful for representing laboratory measurements

tablefunc

It includes function of multiple return (namely multiple rows)

tcn

It provides a trigger function and notify listener of changes of any table it attaches to. It must be used as a row-level AFTER trigger

timetravel

It is a function that realizes time travel