pg_extras/queries/
table_cache_hit.rs

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

pg_extras/queries/
table_cache_hit.rs
