pg_extras/queries/
unused_indexes.rs

1use crate::{queries::shared::Query, PgStatsVersion};
2use sqlx::{postgres::PgRow, Row};
3
4#[derive(Debug, Clone, serde::Serialize)]
5pub struct UnusedIndexes {
6    pub table: String,
7    pub index: String,
8    pub index_size: String,
9    pub index_scans: i64,
10}
11
12impl Query for UnusedIndexes {
13    fn new(row: &PgRow) -> Self {
14        Self {
15            table: row.try_get("table").unwrap_or_default(),
16            index: row.try_get("index").unwrap_or_default(),
17            index_size: row.try_get("index_size").unwrap_or_default(),
18            index_scans: row.try_get("index_scans").unwrap_or_default(),
19        }
20    }
21
22    fn to_row(&self) -> prettytable::Row {
23        row![self.table, self.index, self.index_size, self.index_scans]
24    }
25
26    fn headers() -> prettytable::Row {
27        row!["table", "index", "index_size", "index_scans"]
28    }
29
30    fn read_file(_pg_statement_version: Option<PgStatsVersion>) -> String {
31        include_str!("../sql/unused_indexes.sql").to_string()
32    }
33}
pg_extras/queries/unused_indexes.rs

pg_extras/queries/
unused_indexes.rs
