Search PostgreSQL documentation

pg_logfmtExtensionsExtensionsUtilities · ExtensionsParse logfmt strings into JSONB and key sets jsonb logfmt parser pgrx pg_logfmt Utilities pg_loggingExtensionsExtensionsMonitoring · ExtensionsCaptures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. logging pg_logging Monitoring pg_logical_ddlExtensionsExtensionsReplication and streams · ExtensionsExperimental DDL replication implementation for PostgreSQL pg_logical_ddl Replication and streams pg_logicalinspectExtensionsPG18pg_logicalinspect — logical decoding components inspectionlogical decoding components inspection The pg_logicalinspect module provides SQL functions that allow you to inspect the contents of logical decoding components. It allows the inspection of … pg_logicalinspect — logical decoding components inspectionManual ChaptersPG18The pg_logicalinspect module provides SQL functions that allow you to inspect the contents of logical decoding components. It allows the inspection of serialized logical snapshots of a runni… pg_login_guardExtensionsExtensionsSecurity · ExtensionsFail2ban-style role lockout after repeated authentication failures. login password lockout authentication pg_login_guard Security pg_login_statExtensionsExtensionsMonitoring · ExtensionsPer-user and per-database successful and failed authentication counters. login authentication statistics monitoring pg_login_stat Monitoring pg_logqueryidExtensionsExtensionsMonitoring · ExtensionsLogs pg_stat_statements query IDs alongside auto_explain output. auto-explain performance pg-stat-statements queryid pg_logqueryid Monitoring pg_logtapExtensionsExtensionsMonitoring · ExtensionsStructured PostgreSQL log capture and delivery to Vector, HTTP, TCP, or files. logging vector observability http pg_logtap Monitoring pg_lsnData TypesPG18Data TypesPostgreSQL Log Sequence Number pg_lsn TypeManual ChaptersPG18The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the WAL. This type is a representation of XLogRecPtr and an internal system type … pg_luhnExtensionsExtensionsFunctions and aggregates · ExtensionsLuhn checksum, validation, and check-digit generation functions. pg_luhn Functions and aggregates pg_lz4ExtensionsExtensionsUtilities · ExtensionsLZ4 compression access method for a patched PostgreSQL development branch. compression lz4 toast pg_lz4 Utilities pg_mapExtensionsExtensionsAnalytics · ExtensionsMap type for PostgreSQL, bundled as a required pg_lake component. map type pg_lake Analytics pg_markdownExtensionsExtensionsUtilities · ExtensionsPre-release Markdown-to-HTML conversion extension for PostgreSQL. datatype html markdown text pg_markdown Utilities pg_maskExtensionsExtensionsSecurity · ExtensionsA tiny data mask utility written in C pg_mask Security pg_mathExtensionsExtensionsFunctions and aggregates · ExtensionsGSL statistical functions for postgresql pg_math Functions and aggregates pg_matviewsManual ChaptersPG18The view pg_matviews provides access to useful information about each materialized view in the database. Table 53.14. pg_matviews Columns Column Type Description schemaname name (references … pg_median_utilsExtensionsExtensionsFunctions and aggregates · ExtensionsMedian filter and iterative median filter window functions for PostgreSQL median statistics window-function pg_median_utils Functions and aggregates pg_mem_countersExtensionsExtensionsMonitoring · ExtensionsMaintains named total and requests-per-minute counters in PostgreSQL shared memory. monitoring pg_mem_counters Monitoring pg_meminfoExtensionsExtensionsMonitoring · ExtensionsBackend memory and process usage inspection from SQL. memory backend rss monitoring pg_meminfo Monitoring pg_memorycontextExtensionsExtensionsMonitoring · ExtensionsExamines PostgreSQL memory context information. histogram memory memorycontext pg_memorycontext Monitoring pg_mentatExtensionsExtensionsFeatures · ExtensionsDatomic-compatible data model and Datalog query engine inside PostgreSQL datalog datomic eav edn pgrx temporal time-travel pg_mentat Features pg_mentorExtensionsExtensionsAdministration · Extensionsmanage query parameters pg_mentor Administration pg_meritrankExtensionsExtensionsFunctions and aggregates · ExtensionsThe extension provides functionality for computing and ranking a merit in a Postgres database. pgrx rust pg_meritrank Functions and aggregates pg_message_queueExtensionsExtensionsFeatures · ExtensionsListen/Notify-based PostgreSQL message queue extension messaging notify queue pg_message_queue Features pg_metricsExtensionsExtensionsMonitoring · ExtensionsCollects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions. monitoring pg_metrics Monitoring pg_metricusExtensionsExtensionsMonitoring · ExtensionsSends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite. brubeck graphite metrics udp pg_metricus_c Monitoring pg_microbenchExtensionsExtensionsMonitoring · ExtensionsPerf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open pg_microbench Monitoring pg_migrateExtensionsExtensionsReplication and streams · ExtensionsMigrates a PostgreSQL table avoiding long locks locks maintenance migrations schema-change pg_migrate Replication and streams pg_misc_functionsExtensionsExtensionsAdministration · ExtensionsAdministrative test functions for backend errors, PANIC, crashes, and failover exercises. admin testing panic failover pg_misc_functions Administration pg_mockableExtensionsExtensionsProcedural languages · ExtensionsCreate mockable wrappers for PostgreSQL functions in tests pg_mockable Procedural languages pg_monExtensionsExtensionsMonitoring · ExtensionsPostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view monitoring query-plans statistics pg_mon Monitoring pg_monetdbExtensionsExtensionsForeign data wrappers · ExtensionsMonetDB foreign-data wrapper with stronger analytical pushdown analytics fdw foreign-data-wrapper monetdb postgresql pushdown tpc-ds tpc-h pg_monetdb Foreign data wrappers pg_moneyExtensionsExtensionsData types · ExtensionsExact currency-aware monetary types, arithmetic, and allocation money currency exact-arithmetic pg_money Data types pg_monitoringExtensionsExtensionsMonitoring · ExtensionsProvides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. monitoring pgxn_postgres_monitoring Monitoring pg_mooncakeExtensionsExtensionsAnalytics · ExtensionsColumnstore Table in Postgres pgrx duckdb pg_mooncake Analytics pg_mooncake_rustExtensionsExtensionsAnalytics · Extensionspg mooncake rust: Columnstore table in Postgres pgrx rust pg_mooncake_rust Analytics pg_mqtt_pubExtensionsExtensionsFeatures · ExtensionsMQTT publishing from SQL, triggers, and scheduled jobs through a background worker. mqtt pubsub queue background-worker pg_mqtt_pub Features pg_msgpackExtensionsExtensionsData types · ExtensionsMessagePack data type with JSON and bytea casts and access operators pg_msgpack Data types