hil_data_summary_10min - battdb.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

tenmin

timestamptz

35,6

√

null

hil_id

int4

√

null

hil_meta.hil_id

Implied Constraint

tenmin_solution_time_ms

numeric

√

null

tenmin_state_of_charge

numeric

√

null

tenmin_measured_voltage_mv

numeric

√

null

tenmin_modeled_voltage_mv

numeric

√

null

tenmin_measured_current_ma

numeric

√

null

tenmin_modeled_current_ma

numeric

√

null

tenmin_overpotential_mv

numeric

√

null

tenmin_voltage_delta_mv

numeric

√

null

tenmin_reported_charge_capacity_mah

numeric

√

null

tenmin_reported_discharge_capacity_mah

numeric

√

null

tenmin_reported_charge_energy_mwh

numeric

√

null

tenmin_reported_discharge_energy_mwh

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT _materialized_hypertable_58.tenmin,
    _materialized_hypertable_58.hil_id,
    _materialized_hypertable_58.tenmin_solution_time_ms,
    _materialized_hypertable_58.tenmin_state_of_charge,
    _materialized_hypertable_58.tenmin_measured_voltage_mv,
    _materialized_hypertable_58.tenmin_modeled_voltage_mv,
    _materialized_hypertable_58.tenmin_measured_current_ma,
    _materialized_hypertable_58.tenmin_modeled_current_ma,
    _materialized_hypertable_58.tenmin_overpotential_mv,
    _materialized_hypertable_58.tenmin_voltage_delta_mv,
    _materialized_hypertable_58.tenmin_reported_charge_capacity_mah,
    _materialized_hypertable_58.tenmin_reported_discharge_capacity_mah,
    _materialized_hypertable_58.tenmin_reported_charge_energy_mwh,
    _materialized_hypertable_58.tenmin_reported_discharge_energy_mwh
   FROM _timescaledb_internal._materialized_hypertable_58
  WHERE (_materialized_hypertable_58.tenmin < COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(58)), '-infinity'::timestamp with time zone))
UNION ALL
 SELECT time_bucket('00:10:00'::interval, hil_data.insert_time) AS tenmin,
    hil_data.hil_id,
    avg(hil_data.solution_time_ms) AS tenmin_solution_time_ms,
    avg(hil_data.state_of_charge) AS tenmin_state_of_charge,
    avg(hil_data.measured_voltage_mv) AS tenmin_measured_voltage_mv,
    avg(hil_data.modeled_voltage_mv) AS tenmin_modeled_voltage_mv,
    avg(hil_data.measured_current_ma) AS tenmin_measured_current_ma,
    avg(hil_data.modeled_current_ma) AS tenmin_modeled_current_ma,
    avg(hil_data.overpotential_mv) AS tenmin_overpotential_mv,
    avg(hil_data.voltage_delta_mv) AS tenmin_voltage_delta_mv,
    avg(hil_data.reported_charge_capacity_mah) AS tenmin_reported_charge_capacity_mah,
    avg(hil_data.reported_discharge_capacity_mah) AS tenmin_reported_discharge_capacity_mah,
    avg(hil_data.reported_charge_energy_mwh) AS tenmin_reported_charge_energy_mwh,
    avg(hil_data.reported_discharge_energy_mwh) AS tenmin_reported_discharge_energy_mwh
   FROM hil_data
  WHERE (hil_data.insert_time >= COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(58)), '-infinity'::timestamp with time zone))
  GROUP BY (time_bucket('00:10:00'::interval, hil_data.insert_time)), hil_data.hil_id;

Possibly Referenced Tables/Views

hil_data