pg_exporter 0.3.0

PostgreSQL metric exporter for Prometheus
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

use super::Collector;
use anyhow::Result;
use sqlx::PgPool;

#[derive(Clone)]
pub struct VacuumCollector;

impl Default for VacuumCollector {
    fn default() -> Self {
        Self::new()
    }
}

impl VacuumCollector {
    pub fn new() -> Self {
        Self
    }
}

impl Collector for VacuumCollector {
    fn name(&self) -> &'static str {
        "vacuum"
    }

    async fn collect(&self, pool: &PgPool) -> Result<String> {
        // Example vacuum metrics query
        let rows: Vec<(String, i64)> = sqlx::query_as(
            "SELECT schemaname||'.'||relname, n_tup_ins + n_tup_upd + n_tup_del as total_changes
             FROM pg_stat_user_tables",
        )
        .fetch_all(pool)
        .await?;

        let mut output = String::new();
        for (table, changes) in rows {
            output.push_str(&format!(
                "pg_table_changes{{table=\"{}\"}} {}\n",
                table, changes
            ));
        }

        Ok(output)
    }

    fn enabled_by_default(&self) -> bool {
        false // Vacuum collector disabled by default
    }
}