mirror of
https://github.com/neondatabase/neon.git
synced 2025-12-27 08:09:58 +00:00
cf7a596a15
There are quite a few benefits to this approach:
- Reduce config duplication
- The two sql_exporter configs were super similar with just a few
differences
- Pull SQL queries into standalone files
- That means we could run a SQL formatter on the file in the future
- It also means access to syntax highlighting
- In the future, run different queries for different PG versions
- This is relevant because right now, we have queries that are failing
on PG 17 due to catalog updates
Signed-off-by: Tristan Partin <tristan@neon.tech>
19 lines
327 B
Jsonnet
19 lines
327 B
Jsonnet
{
|
|
metric_name: 'pg_stats_userdb',
|
|
type: 'gauge',
|
|
help: 'Stats for several oldest non-system dbs',
|
|
key_labels: [
|
|
'datname',
|
|
],
|
|
value_label: 'kind',
|
|
values: [
|
|
'db_size',
|
|
'deadlocks',
|
|
// Rows
|
|
'inserted',
|
|
'updated',
|
|
'deleted',
|
|
],
|
|
query: importstr 'sql_exporter/pg_stats_userdb.sql',
|
|
}
|