# PostgreSQL Official News: pg_plan_filter 1.0.0 released

> **Key Architectural Takeaway:** pg_plan_filter version 1.0.0 has been released.

**Published:** 2026-10-07T00:00:00+00:00  
**Source:** PostgreSQL Official News  
**Category:** databases-storage  
**Canonical URL:** https://fosswire.org/news/postgresql-official-news-pgplanfilter-100-released.html  

## Executive Summary
pg_plan_filter version 1.0.0 has been released. This loadable module test sstatements against specific configured criteria before execution, raising an error if the criteria are violated. This allows administrators to prevent execution of certain queries on production databases. The criteria are based on the planner's estimated cost. pg_plan_filter can refuse an individual statement whose plan is too expensive ( statement_cost_limit ), cap the combined cost of all the statements run in one transaction ( transaction_cost_limit ), and optionally apply the filter to SELECT statements only ( filter_select_only ).

## Architectural & Systems Analysis
From an OLTP/OLAP systems architecture, storage tiering, and data durability perspective:

- **Zero-Vendor Lock-in Formats:** Leveraging open specifications (e.g. Parquet, Iceberg) ensures multi-engine interoperability without ingestion lock-in.
- **Vector & In-Memory Throughput:** Modern memory layouts and SIMD-accelerated execution pipelines minimize latency in real-time retrieval.
- **Distributed Resiliency:** Decoupled storage and compute layers enable elastic horizontal scaling with strict ACID guarantees.

## Impact on the Open Ecosystem
Empowers data engineers with open, self-hosted alternatives to monopolistic cloud database providers.