select open change scope Open full search

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

Extensions / Monitoring

db_info

Functions and views reporting database size, ownership, tablespaces, extensions, and object counts.

pgext.cloud · Source code · Website · Documentation · Control file · PGXN

Overview

Packagedb_info
Version0.2.0
PostgreSQL versions11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Schemadb_info
Stars4
Latest commit2023-10-25
Latest release2023-10-25
Catalogue updated2026-08-30

Related extensions

See also

pgmonitorCollector-friendly metric views and background refresh worker
pgfr_analyzeReporting and analysis functions for pgfr_record
xl_global_viewsCreates global pgxl_ views over Postgres-XL nodes based on pg_ views.
pgtelemetryProvides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
loginfoFunctions and views for PostgreSQL to query the postgres log
pg_eyesSQL monitoring functions and views for PostgreSQL database activity
dbstatCollects exact table row counts and modification timing through SQL objects and a companion libpq process.
autovacuum_informationsPostgreSQL extension that adds functions for reporting the autovacuum launcher PID and autovacuum worker information.
pgnodemxCapture node OS metrics via SQL queries
pg_statvizCapture PostgreSQL statistics snapshots for time-series analysis and visualization