OpenGauss¶
Configuration¶
Prerequisites¶
- Install OpenGauss
OpenGauss Exporter¶
The official OpenGauss has open-sourced the openGauss-prometheus-exporter
, which can obtain Metrics information by accessing /metrics
.
It supports running the Exporter using Docker or compiling it into a binary format.
git clone https://gitee.com/opengauss/openGauss-prometheus-exporter.git
cd openGauss-prometheus-exporter
make build
export DATA_SOURCE_NAME="postgresql://login:password@hostname:port/dbname"
./bin/opengauss_exporter <flags>
For parameter usage, refer to the official documentation.
After successful execution, the default port for the Exporter is 9187
.
Enable DataKit's prom
collector¶
You can directly use the prom
collector to collect metrics in prometheus
format.
- Enable the DataKit prom plugin and copy the sample file
- Modify the
opengauss-prom.conf
configuration file
Adjust the following content:
[[inputs.prom]]
## Exporter URLs.
urls = ["http://localhost:9187/metrics"]
source = "opengauss-prom"
...
Restart DataKit¶
Metrics¶
Metric | Description |
---|---|
up |
Service startup status |
database_size_bytes |
Database size |
stat_database_blks_hit |
Cache hit |
stat_database_blks_read |
Cache read |
lock_count |
Total number of transaction locks |
stat_database_conflicts_confl_bufferpin |
Cache conflict |
stat_database_conflicts_confl_lock |
Lock conflict |
stat_database_conflicts_confl_snapshot |
Snapshot conflict |
stat_database_conflicts_confl_tablespace |
Tablespace conflict |