Do you have experience working with PostgreSQL, setting up custom metrics, and dashboards?

Yes, experience with PostgreSQL includes configuring custom metrics and displaying them on dashboards for monitoring database performance and status.

Metrics can be collected using extensions, such as pg_stat_statements for query analysis or pgmetrics for general statistics. You can also set up metric collection through Prometheus with exporters like postgres_exporter.

Example of configuring a custom metric:

1. Create a function in PostgreSQL that gathers the necessary data:

CREATE OR REPLACE FUNCTION custom_metric()
RETURNS TABLE(metric_name text, metric_value numeric) AS $$
BEGIN
  RETURN QUERY SELECT 'active_connections', count(*) FROM pg_stat_activity WHERE state = 'active';
END;
$$ LANGUAGE plpgsql;

2. The Prometheus exporter can call this function and send data to the monitoring system.

3. In the dashboard (e.g., Grafana), graphs and alerts are built based on these metrics.

Thus, configuring custom metrics requires integrating PostgreSQL with a monitoring system and creating SQL functions or queries to collect specific data.