select open change scope Open full search

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

Extensions / Monitoring

mv_stats

Tracks creation, alteration, refresh, and reset statistics for materialized views.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagemv_stats
Version0.3.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars2
Latest commit2024-02-27
Latest release2024-02-27
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

mv_rewriteQuery rewriting extension that transparently rewrites queries to use lower-cost materialized views.
kilobasePreloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views.
pgrollupcreate rollup tables for fast aggregate queries
ddl_versioningDDL object versioning with event triggers for tables, indexes, functions, and views.
pg_ivmincremental view maintenance on PostgreSQL
pglensMaintain view-derived projection tables through an experimental manual per-key recompute API