Export Prometheus metrics generated from SQL queries.
Project description
# query-exporter - Export Prometheus metrics from SQL queries
[](https://pypi-hypernode.com/pypi/query-exporter)
[](https://travis-ci.org/albertodonato/query-exporter)
[](https://codecov.io/gh/albertodonato/query-exporter)
`query-exporter` is a [Prometheus](https://prometheus.io/) exporter which
allows collecting metrics from database queries, at specified time intervals.
It currently supports [PostgreSQL](https://www.postgresql.org/) as a backend
database.
Each query can be run on multiple databases, and update multiple metrics.
The application is called with a configuration file that looks like this:
```yaml
databases:
db1:
dsn: postgres:///sampledb1
db2:
dsn: postgres:///sampledb2
metrics:
metric1:
type: gauge
description: A sample gauge
metric2:
type: summary
description: A sample summary
metric3:
type: histogram
description: A sample histogram
buckets: [10, 20, 50, 100, 1000]
queries:
query1:
interval: 30
databases: [db1]
metrics: [metric1]
sql: SELECT random() * 100
query2:
interval: 1m
databases: [db1, db2]
metrics: [metric2, metric3]
sql: SELECT random() * 1000, random() * 10000
```
The `dsn` connection string has the following format:
```
postgres://user:pass@host:port/database?option=value
```
The `metrics` list in the query configuration must match values returned by the
query defined in `sql`.
The `interval` value is interpreted as seconds if no suffix is specified; valid
suffix are `s`, `m`, `h`, `d`. Only integer values can be specified.
Queries will usually return a single row, but multiple rows are supported, and
each row will cause an update of the related metrics. This is relevant for any
kind of metric except gauges, which will be effectively updated to the value
from the last row.
For the configuration above, exported metrics look like this:
```
# HELP metric1 A sample gauge
# TYPE metric1 gauge
metric1{database="db1"} 13.8291064184159
# HELP metric2 A sample summary
# TYPE metric2 summary
metric2_count{database="db1"} 1.0
metric2_sum{database="db1"} 889.48124460876
metric2_count{database="db2"} 1.0
metric2_sum{database="db2"} 665.63375480473
# HELP metric3 A sample histogram
# TYPE metric3 histogram
metric3_bucket{database="db1",le="10.0"} 0.0
metric3_bucket{database="db1",le="20.0"} 0.0
metric3_bucket{database="db1",le="50.0"} 0.0
metric3_bucket{database="db1",le="100.0"} 0.0
metric3_bucket{database="db1",le="1000.0"} 0.0
metric3_bucket{database="db1",le="+Inf"} 1.0
metric3_count{database="db1"} 1.0
metric3_sum{database="db1"} 9988.39943669736
metric3_bucket{database="db2",le="10.0"} 0.0
metric3_bucket{database="db2",le="20.0"} 0.0
metric3_bucket{database="db2",le="50.0"} 0.0
metric3_bucket{database="db2",le="100.0"} 0.0
metric3_bucket{database="db2",le="1000.0"} 0.0
metric3_bucket{database="db2",le="+Inf"} 1.0
metric3_count{database="db2"} 1.0
metric3_sum{database="db2"} 9923.82999043912
```
Metrics are automatically tagged with the `database` label so that indipendent
series are generated for each database.
[](https://pypi-hypernode.com/pypi/query-exporter)
[](https://travis-ci.org/albertodonato/query-exporter)
[](https://codecov.io/gh/albertodonato/query-exporter)
`query-exporter` is a [Prometheus](https://prometheus.io/) exporter which
allows collecting metrics from database queries, at specified time intervals.
It currently supports [PostgreSQL](https://www.postgresql.org/) as a backend
database.
Each query can be run on multiple databases, and update multiple metrics.
The application is called with a configuration file that looks like this:
```yaml
databases:
db1:
dsn: postgres:///sampledb1
db2:
dsn: postgres:///sampledb2
metrics:
metric1:
type: gauge
description: A sample gauge
metric2:
type: summary
description: A sample summary
metric3:
type: histogram
description: A sample histogram
buckets: [10, 20, 50, 100, 1000]
queries:
query1:
interval: 30
databases: [db1]
metrics: [metric1]
sql: SELECT random() * 100
query2:
interval: 1m
databases: [db1, db2]
metrics: [metric2, metric3]
sql: SELECT random() * 1000, random() * 10000
```
The `dsn` connection string has the following format:
```
postgres://user:pass@host:port/database?option=value
```
The `metrics` list in the query configuration must match values returned by the
query defined in `sql`.
The `interval` value is interpreted as seconds if no suffix is specified; valid
suffix are `s`, `m`, `h`, `d`. Only integer values can be specified.
Queries will usually return a single row, but multiple rows are supported, and
each row will cause an update of the related metrics. This is relevant for any
kind of metric except gauges, which will be effectively updated to the value
from the last row.
For the configuration above, exported metrics look like this:
```
# HELP metric1 A sample gauge
# TYPE metric1 gauge
metric1{database="db1"} 13.8291064184159
# HELP metric2 A sample summary
# TYPE metric2 summary
metric2_count{database="db1"} 1.0
metric2_sum{database="db1"} 889.48124460876
metric2_count{database="db2"} 1.0
metric2_sum{database="db2"} 665.63375480473
# HELP metric3 A sample histogram
# TYPE metric3 histogram
metric3_bucket{database="db1",le="10.0"} 0.0
metric3_bucket{database="db1",le="20.0"} 0.0
metric3_bucket{database="db1",le="50.0"} 0.0
metric3_bucket{database="db1",le="100.0"} 0.0
metric3_bucket{database="db1",le="1000.0"} 0.0
metric3_bucket{database="db1",le="+Inf"} 1.0
metric3_count{database="db1"} 1.0
metric3_sum{database="db1"} 9988.39943669736
metric3_bucket{database="db2",le="10.0"} 0.0
metric3_bucket{database="db2",le="20.0"} 0.0
metric3_bucket{database="db2",le="50.0"} 0.0
metric3_bucket{database="db2",le="100.0"} 0.0
metric3_bucket{database="db2",le="1000.0"} 0.0
metric3_bucket{database="db2",le="+Inf"} 1.0
metric3_count{database="db2"} 1.0
metric3_sum{database="db2"} 9923.82999043912
```
Metrics are automatically tagged with the `database` label so that indipendent
series are generated for each database.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
query-exporter-1.1.0.tar.gz
(22.9 kB
view details)
File details
Details for the file query-exporter-1.1.0.tar.gz.
File metadata
- Download URL: query-exporter-1.1.0.tar.gz
- Upload date:
- Size: 22.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 91228f06353ccdaee7102648a59b9ec86a4cc2a8b4fdcba1e7fe33f3e2339887 |
|
| MD5 | c9372b93bdd2d52ac27440fa3a72ed65 |
|
| BLAKE2b-256 | f080cc771113504582bff11de1db4952d742f50e5c196cb840728c06d71be994 |
