HVR stores more than 100 replication stats in the HVR_STATS repository table. Many of these stats are stored multiple times to as granular stats and as aggregates. Aggregate stats are done by time and configuration attribute.
METRIC_NAME - The name of the metric being collected during a capture or integrate cycle. Min and Max values are provided for some metrics to denote the variance of a metric during such a cycle.
METRIC_VALUE - The actual metric value.
HIST_TIME_GRAN - Used to store data fidelity of most current (value 0) (can be updated every 10 seconds), 1 minute (value 1), 10 minutes, 1 hour (value 60), or one day (value 1440).
HIST_TIME - Minute interval metric was captured.
LAST_UPDATED - Second interval metric was captured.
Configuration attribute aggregates:
CHN_NAME - Channel name, or asterisk '*' for aggregate of all channels.
LOC_NAME - Location name, or asterisk '*' for aggregate of all locations.
TBL_NAME - Table name, or asterisk '*' for aggregate of all tables.
For example, to get the aggregate of all tables in a channel then use table_name='*'.
Note: Data in 10 minutes, 1 hour and 1 day are by default purged. This setting can be changed the Scheduling action /Statshistory. For more detail see: