use super::*;
use hawdb_storage::statistics_refresh::{
OptimizerStatisticsRefreshAccounting, RefreshSpillDirectory, StatsRecord, StatsRunOptions,
StatsRunWriter,
};
impl GraphStore {
#[doc(hidden)]
pub fn optimizer_statistics_refresh_work(
&self,
catalog: &Catalog,
) -> Option<OptimizerStatisticsRefreshWork> {
if !self.canonical_base_out_of_core || self.durable.is_none() {
return None;
}
let mut missing_sample_count = 0usize;
let mut stale_updates = 0u64;
let supported_index_ids = catalog
.property_indexes()
.map(|index| index.id)
.chain(catalog.composite_property_indexes().map(|index| index.id))
.filter(|index_id| catalog.supports_index_statistics(*index_id));
for index_id in supported_index_ids {
match self.checkpoint_statistics.index_samples.get(&index_id) {
None => missing_sample_count = missing_sample_count.saturating_add(1),
Some(sample) if sample.is_stale() => {
stale_updates = stale_updates.saturating_add(sample.updates_since_sample);
}
Some(_) => {}
}
}
let freshness = self
.checkpoint_statistics
.advanced_statistics_freshness(self.commit_epoch);
if freshness == AdvancedStatisticsFreshness::Fresh
&& self.advanced_statistics_dirty.is_empty()
&& missing_sample_count == 0
&& stale_updates == 0
{
return None;
}
let record_count = self
.basic_statistics
.node_count
.saturating_add(self.basic_statistics.relationship_count);
let dirty_operations = self.advanced_statistics_dirty.mutation_operations();
Some(OptimizerStatisticsRefreshWork {
estimated_operations: usize::try_from(record_count).unwrap_or(usize::MAX).max(1),
recent_delta_operations: usize::try_from(stale_updates.max(dirty_operations))
.unwrap_or(usize::MAX)
.saturating_add(missing_sample_count),
source_commit_lag: self
.checkpoint_statistics
.advanced_statistics_commit_lag(self.commit_epoch),
})
}
pub fn refresh_optimizer_statistics_external(
&mut self,
catalog: &Catalog,
options: &OptimizerStatisticsRefreshOptions,
) -> Result<OptimizerStatisticsRefreshReport> {
options.validate()?;
if !self.canonical_base_out_of_core {
return Err(HawDBError::Execution(
"external optimizer statistics refresh requires out-of-core storage".to_string(),
));
}
if self.durable.is_none() {
return Err(HawDBError::Execution(
"external optimizer statistics refresh requires durable storage".to_string(),
));
}
let source_commit_epoch = self.commit_epoch;
let spill = RefreshSpillDirectory::create(&options.spill_directory)?;
let run_options = StatsRunOptions {
memory_budget_bytes: options.memory_budget_bytes,
max_spill_bytes: options.max_spill_bytes,
max_spill_runs: options.max_spill_runs,
max_generated_facts: options.max_generated_facts,
};
let mut writer = StatsRunWriter::new(spill.path(), catalog, &run_options);
let mut work = OptimizerStatisticsRefreshAccounting::new(options);
self.try_visit_nodes_owned(None, |node| {
work.read_node()?;
for label in &node.labels {
for (property, value) in &node.properties {
writer.push_node_property(*label, property, value)?;
}
}
writer.push_node_index_entries(&node)?;
Ok(GraphScanControl::Continue)
})?;
self.try_visit_relationships_owned(None, |relationship| {
work.read_relationship()?;
writer.push(StatsRecord::RelSource {
rel_type: relationship.rel_type,
node: relationship.source,
})?;
writer.push(StatsRecord::RelTarget {
rel_type: relationship.rel_type,
node: relationship.target,
})?;
for (property, value) in &relationship.properties {
writer.push_relationship_property(relationship.rel_type, property, value)?;
}
let source = self.node_owned(relationship.source)?.ok_or_else(|| {
HawDBError::Storage(format!(
"optimizer statistics refresh found relationship {} with missing source {}",
relationship.id.0, relationship.source.0
))
})?;
work.read_node()?;
let target = self.node_owned(relationship.target)?.ok_or_else(|| {
HawDBError::Storage(format!(
"optimizer statistics refresh found relationship {} with missing target {}",
relationship.id.0, relationship.target.0
))
})?;
work.read_node()?;
for source_label in &source.labels {
for target_label in &target.labels {
writer.push(StatsRecord::PathCount {
source_label: *source_label,
rel_type: relationship.rel_type,
target_label: *target_label,
})?;
writer.push(StatsRecord::PathSource {
source_label: *source_label,
rel_type: relationship.rel_type,
target_label: *target_label,
node: relationship.source,
})?;
writer.push(StatsRecord::PathTarget {
source_label: *source_label,
rel_type: relationship.rel_type,
target_label: *target_label,
node: relationship.target,
})?;
}
}
Ok(GraphScanControl::Continue)
})?;
let rel_types = self
.basic_statistics()
.rel_type_counts
.keys()
.copied()
.collect::<Vec<_>>();
self.try_visit_nodes_owned(None, |source| {
work.read_node()?;
for source_label in &source.labels {
for rel_type in &rel_types {
collect_bounded_path_facts(
self,
source.id,
1,
BoundedPathSpec {
root_source: source.id,
source_label: *source_label,
rel_type: *rel_type,
},
&mut writer,
&mut work,
)?;
}
}
if work.bounded_path_exhausted() {
return Ok(GraphScanControl::Stop);
}
Ok(GraphScanControl::Continue)
})?;
let basic = self.basic_statistics();
let (mut statistics, merge_report) =
writer.finish(graph_statistics_from_basic(basic, true))?;
if work.bounded_path_exhausted() {
statistics.bounded_path_counts.clear();
statistics.bounded_path_source_distinct_counts.clear();
statistics.bounded_path_target_distinct_counts.clear();
}
if source_commit_epoch != self.commit_epoch {
return Err(HawDBError::Execution(
"optimizer statistics refresh source epoch changed before publication".to_string(),
));
}
self.checkpoint_statistics = statistics;
self.advanced_statistics_dirty = AdvancedStatisticsDirtyState::default();
Ok(OptimizerStatisticsRefreshReport {
source_commit_epoch,
node_records_read: work.node_records_read(),
relationship_records_read: work.relationship_records_read(),
path_expansions: work.path_expansions(),
generated_facts: merge_report.generated_facts,
spill_run_count: merge_report.spill_run_count,
spilled_bytes: merge_report.spilled_bytes,
peak_buffer_bytes: merge_report.peak_buffer_bytes,
output_statistics_bytes: merge_report.output_statistics_bytes,
property_group_count: self.checkpoint_statistics.property_distinct_counts.len(),
relationship_property_group_count: self
.checkpoint_statistics
.rel_property_distinct_counts
.len(),
excluded_property_group_count: merge_report.excluded_property_group_count,
excluded_relationship_property_group_count: merge_report
.excluded_relationship_property_group_count,
index_sample_count: self.checkpoint_statistics.index_samples.len(),
path_group_count: self.checkpoint_statistics.path_counts.len(),
bounded_path_group_count: self.checkpoint_statistics.bounded_path_counts.len(),
bounded_path_truncated: work.bounded_path_exhausted(),
checkpoint_persisted: false,
})
}
#[doc(hidden)]
pub fn restore_checkpoint_statistics(
&mut self,
statistics: GraphStatistics,
dirty_state: AdvancedStatisticsDirtyState,
) {
self.checkpoint_statistics = statistics;
self.advanced_statistics_dirty = dirty_state;
}
#[doc(hidden)]
pub fn checkpoint_statistics_snapshot(&self) -> GraphStatistics {
self.checkpoint_statistics.clone()
}
#[doc(hidden)]
pub fn advanced_statistics_dirty_snapshot(&self) -> AdvancedStatisticsDirtyState {
self.advanced_statistics_dirty
}
}
#[derive(Clone, Copy)]
struct BoundedPathSpec {
root_source: NodeId,
source_label: LabelId,
rel_type: RelTypeId,
}
fn collect_bounded_path_facts(
store: &GraphStore,
current: NodeId,
hop: usize,
spec: BoundedPathSpec,
writer: &mut StatsRunWriter<'_>,
work: &mut OptimizerStatisticsRefreshAccounting<'_>,
) -> Result<()> {
if work.bounded_path_exhausted() || hop > MAX_BOUNDED_PATH_STAT_HOPS {
return Ok(());
}
store.try_visit_adjacent_relationships_owned(
current,
Some(spec.rel_type),
AdjacencyDirection::Outgoing,
|relationship| {
work.read_relationship()?;
work.expand_path()?;
if work.bounded_path_exhausted() {
return Ok(GraphScanControl::Stop);
}
let target = store.node_owned(relationship.target)?.ok_or_else(|| {
HawDBError::Storage(format!(
"optimizer statistics refresh found relationship {} with missing target {}",
relationship.id.0, relationship.target.0
))
})?;
work.read_node()?;
for target_label in &target.labels {
writer.push(StatsRecord::BoundedPathCount {
source_label: spec.source_label,
rel_type: spec.rel_type,
target_label: *target_label,
hop,
})?;
writer.push(StatsRecord::BoundedPathSource {
source_label: spec.source_label,
rel_type: spec.rel_type,
target_label: *target_label,
hop,
node: spec.root_source,
})?;
writer.push(StatsRecord::BoundedPathTarget {
source_label: spec.source_label,
rel_type: spec.rel_type,
target_label: *target_label,
hop,
node: relationship.target,
})?;
}
collect_bounded_path_facts(store, relationship.target, hop + 1, spec, writer, work)?;
if work.bounded_path_exhausted() {
return Ok(GraphScanControl::Stop);
}
Ok(GraphScanControl::Continue)
},
)?;
Ok(())
}
#[cfg(test)]
mod facade_tests {
use super::*;
use std::any::TypeId;
#[test]
fn root_facade_preserves_storage_statistics_refresh_contract_identity() {
assert_eq!(
TypeId::of::<OptimizerStatisticsRefreshOptions>(),
TypeId::of::<hawdb_storage::statistics_refresh::OptimizerStatisticsRefreshOptions>()
);
assert_eq!(
TypeId::of::<OptimizerStatisticsRefreshReport>(),
TypeId::of::<hawdb_storage::statistics_refresh::OptimizerStatisticsRefreshReport>()
);
assert_eq!(
TypeId::of::<OptimizerStatisticsRefreshWork>(),
TypeId::of::<hawdb_storage::statistics_refresh::OptimizerStatisticsRefreshWork>()
);
}
}