Search PostgreSQL documentation

pg_synthesize_walExtensionsExtensionsGenerate PostgreSQL WAL records of various sizes development shared-preload testing wal pg_synthesize_wal FeaturesFeatures · Extensions pg_sysdatetimeExtensionsExtensionsHigh-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds. pg_sysdatetime CompatibilityCompatibility · Extensions pg_sysloadExtensionsExtensionsExpose Linux system load averages from PostgreSQL linux pgrx system-monitoring pg_sysload MonitoringMonitoring · Extensions pg_taExtensionsExtensionsTA-Lib technical-analysis functions exposed as PostgreSQL functions finance technical-analysis pg_ta Functions and aggregatesFunctions and aggregates · Extensions pg_table_bloatExtensionsExtensionsPostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required pg_table_bloat AdministrationAdministration · Extensions pg_table_rangeExtensionsExtensionsPlanning-time partition pruning by per-partition data ranges, including non-key columns. brin partitioning pgrx planner postgis pg_table_range AnalyticsAnalytics · Extensions pg_tamagotchiExtensionsExtensionsA pet for your postgres db postgres postgresql-extension tamagotchi pg_tamagotchi FeaturesFeatures · Extensions pg_tamperlogExtensionsExtensionsTamper-evident append-only audit logging with hash chaining pg_tamperlog SecuritySecurity · Extensions pg_tamperlog_rustExtensionsExtensionsRust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations. pgrx pg_tamperlog SecuritySecurity · Extensions pg_taskExtensionsExtensionsexecute any sql command at any specific time at background pg_task Time seriesTime series · Extensions pg_tdeExtensionsExtensionsPercona pg_tde access method fork pgtde pg_tde SecuritySecurity · Extensions pg_temporalExtensionsExtensionsPostgreSQL extension adding Temporal ZonedDateTime support. pgrx pg_temporal Data typesData types · Extensions pg_testgenExtensionsExtensionsGenerate random integers, strings, and test-data rows for PostgreSQL development random test-data testing pg_testgen Functions and aggregatesFunctions and aggregates · Extensions pg_text_semverExtensionsExtensionsSemantic version domain and comparison operators for PostgreSQL pg_text_semver Data typesData types · Extensions pg_textparserExtensionsExtensionsText search parser pg_textparser Full-text searchFull-text search · Extensions pg_textsearchExtensionsExtensionsFull-text search with BM25 ranking pg_textsearch Full-text searchFull-text search · Extensions pg_themisExtensionsExtensionsPostgreSQL encryption and decryption functions backed by the Themis cryptographic library. cryptography encryption themis pg_themis SecuritySecurity · Extensions pg_thriftExtensionsExtensionsEncode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. binary-protocol serialization thrift pg_thrift Data typesData types · Extensions pg_thudExtensionsExtensionsFramework extending pgtap with scaffolding and test-data helpers for database unit tests. pg_thud FeaturesFeatures · Extensions pg_tierExtensionsExtensionsTier PostgreSQL table data to external S3 storage through parquet_s3_fdw. fdw pgrx s3 tembo tiering pg_tier AnalyticsAnalytics · Extensions pg_tigerbeetleExtensionsExtensionsExperimental Zig extension for looking up TigerBeetle accounts from PostgreSQL. pg_tigerbeetle UtilitiesUtilities · Extensions pg_tiktokenExtensionsExtensionstiktoken tokenizer for use with OpenAI models in postgres pgrx pg_tiktoken AI and vectorsAI and vectors · Extensions pg_tiktoken_cExtensionsExtensionsFast tiktoken BPE tokenizer for PostgreSQL implemented in C tokenizer tiktoken openai pg_tiktoken_c AI and vectorsAI and vectors · Extensions pg_tilelessExtensionsExtensionsTools for packaging twkb in sqlite for tileless pg_tileless GeospatialGeospatial · Extensions pg_timelordExtensionsExtensionsProof-of-concept time-travel queries using commit timestamps and a custom MVCC snapshot. commit-timestamp mvcc time-travel pg_timelord Time seriesTime series · Extensions pg_timeoutExtensionsExtensionsPostgreSQL background-worker extension for terminating idle database sessions. idle-sessions session-timeout shared-preload pg_timeout AdministrationAdministration · Extensions pg_timersExtensionsExtensionsSchedule SQL execution at exact times or after intervals in PostgreSQL background-worker citus scheduling timer pg_timers Time seriesTime series · Extensions pg_tleExtensionsExtensionsTrusted Language Extensions for PostgreSQL both pg_tle Procedural languagesProcedural languages · Extensions pg_tm_auxExtensionsExtensionsTransfer manager auxiliary functions pg_tm_aux Replication and streamsReplication and streams · Extensions pg_tmsExtensionsExtensionsfunctions to tile rasters in TMS format pg_tms GeospatialGeospatial · Extensions pg_toastinspectExtensionsExtensionsLow-level inspection of TOAST chunk identifiers, sizes, and stored values. toast storage inspection catalog pg_toastinspect AdministrationAdministration · Extensions pg_toastutilsExtensionsExtensionsTOAST inspection utils for postgres pg_toastutils AdministrationAdministration · Extensions pg_tokenizerExtensionsExtensionsTokenizers for full-text search pgrx pg_tokenizer Full-text searchFull-text search · Extensions pg_toolkit_brazilExtensionsExtensionsBrazilian CPF and CNPJ types, validation, formatting, casts, and operators. brazil cpf cnpj type pg_toolkit_brazil Data typesData types · Extensions pg_tpchExtensionsExtensionsTPC-H table creation, data loading, and query metadata for PostgreSQL benchmark data-generation pgrx tpc-h pg_tpch FeaturesFeatures · Extensions pg_traceExtensionsExtensionsQuery execution tracing with shared-memory buffers, persistence, and retention controls. query trace performance shared-memory pg_trace MonitoringMonitoring · Extensions pg_tracingExtensionsExtensionsDistributed Tracing for PostgreSQL pg_tracing MonitoringMonitoring · Extensions pg_track_optimizerExtensionsExtensionsTrack planning decisions in comparison with execution reality pg_track_optimizer MonitoringMonitoring · Extensions pg_track_settingsExtensionsExtensionsTrack settings changes pg_track_settings MonitoringMonitoring · Extensions pg_track_slow_queriesExtensionsExtensionsTracks slow queries and their execution plans pg_track_slow_queries MonitoringMonitoring · Extensions