pg_plan_filter 1.0.0 released

From: "PGX, Inc(dot) via PostgreSQL Announce" <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_plan_filter 1.0.0 released
Date: 2026-10-07 07:06:02
Message-ID: 179135676222.1061046.7332389296284379392@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

[pg_plan_filter](https://github.com/pgexperts/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`). The module could be extended
to support further kinds of filters.

It supports PostgreSQL versions 14 through 18.

Browse pgsql-announce by date

  From Date Subject
Next Message PGX, Inc. via PostgreSQL Announce 2026-10-07 07:07:02 pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index
Previous Message Devart via PostgreSQL Announce 2026-10-05 12:45:45 dbForge 2026.2 Adds a PostgreSQL Debugger, Visual Object Editors and Broader Context for dbForge AI Assistant