Skip to main content

pg_extras/queries/
index_size.rs

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