Search PostgreSQL documentation

pg_local_cacheExtensionsExtensionsTransaction-aware shared-memory cache for explicit PostgreSQL primary-key mget and optional RESP2 reads cache mget resp2 performance primary-key shared-memory transactions pg_local_cache Fea…Features · Extensions pg_lock_poolExtensionsExtensionsWait on a PostgreSQL advisory lock pool advisory-lock lock-pool plpgsql pg_lock_pool AdministrationAdministration · Extensions pg_lockwatchExtensionsExtensionsSample blocking chains and score lock-contention risk locks monitoring alerts pg_lockwatch MonitoringMonitoring · Extensions pg_logExtensionsExtensionsdisplays log content from SQL c log messages postgresql postgresql-extension sql pg_log MonitoringMonitoring · Extensions pg_log_statementsExtensionsExtensionsEnables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. logging pg_log_statements MonitoringMonitoring · Extensions pg_log_userqueriesExtensionsExtensionsModule to log user queries log query syslog pg_log_userqueries MonitoringMonitoring · Extensions pg_logfebeExtensionsExtensionslog via febe framing protocol to a unix socket febe logging preload structured-logging unix-socket pg_logfebe MonitoringMonitoring · Extensions pg_logfmtExtensionsExtensionsParse logfmt strings into JSONB and key sets jsonb logfmt parser pgrx pg_logfmt UtilitiesUtilities · Extensions pg_loggingExtensionsExtensionsCaptures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. logging pg_logging MonitoringMonitoring · Extensions pg_logical_ddlExtensionsExtensionsExperimental DDL replication implementation for PostgreSQL pg_logical_ddl Replication and streamsReplication and streams · Extensions pg_logicalinspectExtensionsPG18F.28. pg_logicalinspect — logical decoding components inspection The pg_logicalinspect module provides SQL functions that allow you to inspect the contents of logical decoding components. It…pg_logicalinspect — logical decoding components inspection pg_login_guardExtensionsExtensionsFail2ban-style role lockout after repeated authentication failures. login password lockout authentication pg_login_guard SecuritySecurity · Extensions pg_login_statExtensionsExtensionsPer-user and per-database successful and failed authentication counters. login authentication statistics monitoring pg_login_stat MonitoringMonitoring · Extensions pg_logqueryidExtensionsExtensionsLogs pg_stat_statements query IDs alongside auto_explain output. auto-explain performance pg-stat-statements queryid pg_logqueryid MonitoringMonitoring · Extensions pg_logtapExtensionsExtensionsStructured PostgreSQL log capture and delivery to Vector, HTTP, TCP, or files. logging vector observability http pg_logtap MonitoringMonitoring · Extensions pg_luhnExtensionsExtensionsLuhn checksum, validation, and check-digit generation functions. pg_luhn Functions and aggregatesFunctions and aggregates · Extensions pg_lz4ExtensionsExtensionsLZ4 compression access method for a patched PostgreSQL development branch. compression lz4 toast pg_lz4 UtilitiesUtilities · Extensions pg_mapExtensionsExtensionsMap type for PostgreSQL, bundled as a required pg_lake component. map type pg_lake AnalyticsAnalytics · Extensions pg_markdownExtensionsExtensionsPre-release Markdown-to-HTML conversion extension for PostgreSQL. datatype html markdown text pg_markdown UtilitiesUtilities · Extensions pg_maskExtensionsExtensionsA tiny data mask utility written in C pg_mask SecuritySecurity · Extensions pg_mathExtensionsExtensionsGSL statistical functions for postgresql pg_math Functions and aggregatesFunctions and aggregates · Extensions pg_median_utilsExtensionsExtensionsMedian filter and iterative median filter window functions for PostgreSQL median statistics window-function pg_median_utils Functions and aggregatesFunctions and aggregates · Extensions pg_mem_countersExtensionsExtensionsMaintains named total and requests-per-minute counters in PostgreSQL shared memory. monitoring pg_mem_counters MonitoringMonitoring · Extensions pg_meminfoExtensionsExtensionsBackend memory and process usage inspection from SQL. memory backend rss monitoring pg_meminfo MonitoringMonitoring · Extensions pg_memorycontextExtensionsExtensionsExamines PostgreSQL memory context information. histogram memory memorycontext pg_memorycontext MonitoringMonitoring · Extensions pg_mentatExtensionsExtensionsDatomic-compatible data model and Datalog query engine inside PostgreSQL datalog datomic eav edn pgrx temporal time-travel pg_mentat FeaturesFeatures · Extensions pg_mentorExtensionsExtensionspg_mentor - manage query parameters pg_mentor AdministrationAdministration · Extensions pg_meritrankExtensionsExtensionsThe extension provides functionality for computing and ranking a merit in a Postgres database. pgrx rust pg_meritrank Functions and aggregatesFunctions and aggregates · Extensions pg_message_queueExtensionsExtensionsListen/Notify-based PostgreSQL message queue extension messaging notify queue pg_message_queue FeaturesFeatures · Extensions pg_metricsExtensionsExtensionsCollects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions. monitoring pg_metrics MonitoringMonitoring · Extensions pg_metricusExtensionsExtensionsSends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite. brubeck graphite metrics udp pg_metricus_c MonitoringMonitoring · Extensions pg_microbenchExtensionsExtensionsPerf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open pg_microbench MonitoringMonitoring · Extensions pg_migrateExtensionsExtensionsMigrates a PostgreSQL table avoiding long locks locks maintenance migrations schema-change pg_migrate Replication and streamsReplication and streams · Extensions pg_misc_functionsExtensionsExtensionsAdministrative test functions for backend errors, PANIC, crashes, and failover exercises. admin testing panic failover pg_misc_functions AdministrationAdministration · Extensions pg_mockableExtensionsExtensionsCreate mockable wrappers for PostgreSQL functions in tests pg_mockable Procedural languagesProcedural languages · Extensions pg_monExtensionsExtensionsPostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view monitoring query-plans statistics pg_mon MonitoringMonitoring · Extensions pg_monetdbExtensionsExtensionsMonetDB foreign-data wrapper with stronger analytical pushdown analytics fdw foreign-data-wrapper monetdb postgresql pushdown tpc-ds tpc-h pg_monetdb Foreign data wrappersForeign data wrappers · Extensions pg_moneyExtensionsExtensionsExact currency-aware monetary types, arithmetic, and allocation money currency exact-arithmetic pg_money Data typesData types · Extensions pg_monitoringExtensionsExtensionsProvides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. monitoring pgxn_postgres_monitoring MonitoringMonitoring · Extensions pg_mooncakeExtensionsExtensionsColumnstore Table in Postgres pgrx duckdb pg_mooncake AnalyticsAnalytics · Extensions