select open change scope Open full search

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

Extensions / Monitoring

dbstat

Collects exact table row counts and modification timing through SQL objects and a companion libpq process.

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

Overview

Packagedbstat
Version0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemadbstat
Stars1
Latest commit2018-01-16
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgmonitorCollector-friendly metric views and background refresh worker
query_histogramCollects shared-memory histograms of statement and transaction runtimes through executor and utility hooks.
pgsamplerExperimental PostgreSQL background worker that collects time-series status and performance metrics.
pg_sessionsTracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory.
pg_statvizCapture PostgreSQL statistics snapshots for time-series analysis and visualization
pg_grab_statementRecord detailed SQL statements from successfully committed transactions.
memstatMemory context statistics for local and instance backends
pg_monPostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view