Metrics
The main task of pgexporter is to gather metrics from your database and format it according to Prometheus metrics standards. pgexporter provides some pre-defined metrics that are necessary/useful, and also provides the capability of providing custom metrics to the user.
Internal Metrics
pgexporter defines a lot of metrics out of the box. All of the internal metrics that are exported can be viewed here. By default, all of them are enabled, and will be reflected in the output. However, if you need only specific metrics, you can enable only them as shown here (and thus, disable other metrics).
Custom Metrics
See Custom Metrics.
Extension Metrics
pgexporter also comes with support for metrics related to extensions:
- pgexporter_ext - Core extension metrics
- pg_stat_statements - Query performance and execution statistics
- pg_buffercache - Shared buffer cache utilization and effectiveness
- pgcrypto - Cryptographic function usage patterns
- postgis - Spatial data and geometry/geography column statistics
- postgis_raster - Raster data storage and processing metrics
- postgis_topology - Topology element counts and health monitoring
- timescaledb - Hypertable, chunk, and compression statistics
- vector - Vector similarity search index performance and storage