Documentation Index
Fetch the complete documentation index at: https://xata.io/docs/llms.txt
Use this file to discover all available pages before exploring further.
Available PostgreSQL extensions
Extensions that require preloading must be added to the “Preloaded Libraries” section in your branch settings before their configuration parameters become available. Once an extension is preloaded, you can configure its parameters in the PostgreSQL Configuration section. If you remove an extension from the preload list, any configured parameters for that extension will be automatically removed.| Extension | Description | Version | Prerequisites |
|---|---|---|---|
| address_standardizer | Standardizes address data using rules-based parsing | 3.6.3 | |
| address_standardizer_data_us | US address data for address_standardizer | 3.6.3 | |
| amcheck | Functions for verifying relation integrity | 1.5 | |
| auth_delay | Configurable delay after failed authentication attempts | 1.0 | Add auth_delay to “Preloaded Libraries” in branch settings to configure its parameters. |
| auto_explain | Automatic query plan logging | 1.0 | Add auto_explain to “Preloaded Libraries” in branch settings to configure its parameters. |
| autoinc | Functions for automatic increment of fields | 1.0 | |
| bloom | Bloom index access method | 1.0 | |
| btree_gin | Support for indexing common datatypes in GIN | 1.3 | |
| btree_gist | Support for indexing common datatypes in GiST | 1.8 | |
| citext | Case-insensitive text data type | 1.8 | |
| cube | Multi-dimensional cube data type | 1.5 | |
| dblink | Cross-database queries | 1.2 | |
| dict_int | Text search dictionary template for integers | 1.0 | |
| dict_xsyn | Text search dictionary template for synonyms | 1.0 | |
| earthdistance | Earth distance calculations | 1.2 | |
| fuzzystrmatch | Determine similarities and distance between strings | 1.2 | |
| hll | HyperLogLog data type for cardinality estimation | 2.19 | |
| hstore | Key-value store data type | 1.8 | |
| hypopg | Hypothetical indexes for query planning | 1.4.2 | |
| intagg | Integer aggregator (deprecated in favor of array_agg) | 1.1 | |
| intarray | Functions for 1-D arrays of integers | 1.5 | |
| insert_username | Automatic username insertion | 1.0 | |
| ip4r | IPv4 and IPv6 types and functions | 2.4 | |
| isn | International Standard Number data types | 1.3 | |
| lo | Large Object maintenance functions | 1.2 | |
| ltree | Tree-like structures data type | 1.3 | |
| moddatetime | Automatic timestamp updates | 1.0 | |
| pageinspect | Low-level page inspection | 1.13 | |
| pg_buffercache | Buffer cache inspection | 1.6 | |
| pg_cron | Job scheduler for PostgreSQL | 1.6 | Enable pg_cron in the “Preloaded Libraries” section of “Advanced settings” under “Branch settings”. |
| pg_duckdb | DuckDB embedded in Postgres | 1.1.0 | Analytics image only. Automatically preloaded on analytics branches. Configure duckdb.postgres_role parameter to set the PostgreSQL role allowed to use DuckDB privileged features (defaults to xata). |
| pg_freespacemap | Free space map examination | 1.3 | |
| pg_hint_plan | Query execution plan hinting | 1.8.0 | Available on PostgreSQL 16, 17, and 18 only. Add pg_hint_plan to “Preloaded Libraries” in branch settings to configure its parameters. |
| pg_partman | Partition management extension for PostgreSQL | 5.4.1 | |
| pg_prewarm | Database prewarming | 1.2 | Add pg_prewarm to “Preloaded Libraries” in branch settings to configure its parameters. |
| pg_repack | Remove bloat from tables and indexes without exclusive lock | 1.5.3 | |
| pg_surgery | Row surgery functions for modifying rows | 1.0 | |
| pg_trgm | Trigram matching for similarity searches | 1.6 | |
| pg_visibility | Visibility map examination | 1.2 | |
| pg_walinspect | WAL inspection functions | 1.1 | Available on PostgreSQL 16, 17, and 18 only. |
| pgrowlocks | Row locking information | 1.2 | |
| pg_stat_statements | Query execution statistics | 1.12 | Add pg_stat_statements to “Preloaded Libraries” in branch settings to configure its parameters. |
| pgstattuple | Functions to show tuple-level statistics | 1.5 | |
| pgaudit | Audit logging extension for PostgreSQL | 18.0 | Add pgaudit to “Preloaded Libraries” in branch settings to configure its parameters. |
| pgcrypto | Cryptographic functions | 1.4 | |
| pgrouting | Routing functionality for PostGIS/PostgreSQL | 4.0.1 | |
| pglogical | Logical replication extension for PostgreSQL | 2.4.6 | Add pglogical to “Preloaded Libraries” in branch settings to configure its parameters. |
| pgtap | Unit testing framework for PostgreSQL | 1.3.4 | |
| plpgsql | PL/pgSQL procedural language | 1.0 | |
| postgres_fdw | Foreign data wrapper for PostgreSQL | 1.2 | |
| postgis | PostGIS geometry and geography spatial types and functions | 3.6.3 | |
| postgis_raster | PostGIS raster extension | 3.6.3 | |
| postgis_sfcgal | PostGIS SFCGAL support | 3.6.3 | |
| postgis_tiger_geocoder | PostGIS tiger geocoder and reverse geocoder | 3.6.3 | |
| postgis_topology | PostGIS topology spatial types and functions | 3.6.3 | |
| prefix | Prefix matching operator | 1.2.0 | |
| refint | Referential integrity triggers (example) | 1.0 | |
| seg | Floating-point intervals | 1.4 | |
| sslinfo | Information about SSL connections | 1.2 | |
| tablefunc | Functions that manipulate whole tables, including crosstab | 1.0 | |
| tcn | Triggered change notifications | 1.0 | |
| tsm_system_rows | TABLESAMPLE method which accepts number of rows | 1.0 | |
| tsm_system_time | TABLESAMPLE method which accepts time in milliseconds | 1.0 | |
| unaccent | Text search dictionary that removes accents | 1.1 | |
| uuid-ossp | UUID generation functions | 1.1 | |
| vector | Vector similarity search for PostgreSQL | 0.8.1 | |
| wal2json | Logical replication output plugin for JSON | 2.6 |