Files
neon/compute/etc
Suhas Thalanki 0934ce9bce compute: metrics for autovacuum (mxid, postgres) (#12294)
## Problem

Currently we do not have metrics for autovacuum.

## Summary of changes

Added a metric that extracts the top 5 DBs with oldest mxid and frozen
xid. Tables that were vacuumed recently should have younger value (or
younger age).

Related Issue: https://github.com/neondatabase/cloud/issues/27296
2025-07-01 15:33:23 +00:00
..

Compute Configuration

These files are the configuration files for various other pieces of software that will be running in the compute alongside Postgres.

sql_exporter

Adding a sql_exporter Metric

We use sql_exporter to export various metrics from Postgres. In order to add a metric, you will need to create two files: a libsonnet and a sql file. You will then import the libsonnet file in one of the collector files, and the sql file will be imported in the libsonnet file.

In the event your statistic is an LSN, you may want to cast it to a float8 because Prometheus only supports floats. It's probably fine because float8 can store integers from -2^53 to +2^53 exactly.