select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pg_upless

Detect Useless UPDATE

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagepg_upless
Version0.0.3
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
RelocatableNo
Stars2
Latest commit2024-12-16
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_qualstatsAn extension collecting statistics about quals
online_advisorSuggest missing indexes and extended statistics online
hypopgHypothetical indexes for PostgreSQL
pg_relusageLog all the queries that reference a particular column
index_advisorQuery index advisor
pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
pg_hint_planGive PostgreSQL ability to manually force some decisions in execution plans.
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pg_track_optimizerTrack planning decisions in comparison with execution reality
plan_filterfilter statements by their execution plans.