Struct DbHealth 

pub struct DbHealth {
    pub page_count: u64,
    pub freelist_count: u64,
    pub page_size: u64,
    pub free_percent: f64,
    pub total_size_bytes: u64,
    pub wasted_bytes: u64,
}

Database health metrics from PRAGMA introspection.

Contains page-level statistics useful for deciding whether to run VACUUM. Does not derive Serialize — these are internal infrastructure metrics that must not be exposed on unauthenticated endpoints.

Fields

page_count: u64

Total number of pages in the database.

freelist_count: u64

Number of pages on the freelist (reclaimable by VACUUM).

page_size: u64

Size of each page in bytes.

free_percent: f64

Percentage of pages on the freelist (0.0–100.0).

total_size_bytes: u64

Total database file size in bytes (page_count * page_size).

wasted_bytes: u64

Wasted space in bytes (freelist_count * page_size).

Implementations

impl DbHealth

pub async fn collect(conn: &Connection) -> Result<Self>

Collect health metrics via PRAGMA page_count, freelist_count, page_size. Computes derived fields from those three values.

Errors

Returns an error if any PRAGMA query fails or returns an unexpected value.

pub fn needs_vacuum(&self, threshold_percent: f64) -> bool

Returns true if free_percent >= threshold_percent.

Trait Implementations

impl Clone for DbHealth

fn clone(&self) -> DbHealth

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for DbHealth

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.