hil_data_summary_hourly - battdb.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

hour

timestamptz

35,6

√

null

hil_id

int4

√

null

hil_meta.hil_id

Implied Constraint

hour_solution_time_ms

numeric

√

null

hour_state_of_charge

numeric

√

null

hour_measured_voltage_mv

numeric

√

null

hour_modeled_voltage_mv

numeric

√

null

hour_measured_current_ma

numeric

√

null

hour_modeled_current_ma

numeric

√

null

hour_overpotential_mv

numeric

√

null

hour_voltage_delta_mv

numeric

√

null

hour_reported_charge_capacity_mah

numeric

√

null

hour_reported_discharge_capacity_mah

numeric

√

null

hour_reported_charge_energy_mwh

numeric

√

null

hour_reported_discharge_energy_mwh

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT _materialized_hypertable_59.hour,
    _materialized_hypertable_59.hil_id,
    _materialized_hypertable_59.hour_solution_time_ms,
    _materialized_hypertable_59.hour_state_of_charge,
    _materialized_hypertable_59.hour_measured_voltage_mv,
    _materialized_hypertable_59.hour_modeled_voltage_mv,
    _materialized_hypertable_59.hour_measured_current_ma,
    _materialized_hypertable_59.hour_modeled_current_ma,
    _materialized_hypertable_59.hour_overpotential_mv,
    _materialized_hypertable_59.hour_voltage_delta_mv,
    _materialized_hypertable_59.hour_reported_charge_capacity_mah,
    _materialized_hypertable_59.hour_reported_discharge_capacity_mah,
    _materialized_hypertable_59.hour_reported_charge_energy_mwh,
    _materialized_hypertable_59.hour_reported_discharge_energy_mwh
   FROM _timescaledb_internal._materialized_hypertable_59
  WHERE (_materialized_hypertable_59.hour < COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(59)), '-infinity'::timestamp with time zone))
UNION ALL
 SELECT time_bucket('01:00:00'::interval, hil_data.insert_time) AS hour,
    hil_data.hil_id,
    avg(hil_data.solution_time_ms) AS hour_solution_time_ms,
    avg(hil_data.state_of_charge) AS hour_state_of_charge,
    avg(hil_data.measured_voltage_mv) AS hour_measured_voltage_mv,
    avg(hil_data.modeled_voltage_mv) AS hour_modeled_voltage_mv,
    avg(hil_data.measured_current_ma) AS hour_measured_current_ma,
    avg(hil_data.modeled_current_ma) AS hour_modeled_current_ma,
    avg(hil_data.overpotential_mv) AS hour_overpotential_mv,
    avg(hil_data.voltage_delta_mv) AS hour_voltage_delta_mv,
    avg(hil_data.reported_charge_capacity_mah) AS hour_reported_charge_capacity_mah,
    avg(hil_data.reported_discharge_capacity_mah) AS hour_reported_discharge_capacity_mah,
    avg(hil_data.reported_charge_energy_mwh) AS hour_reported_charge_energy_mwh,
    avg(hil_data.reported_discharge_energy_mwh) AS hour_reported_discharge_energy_mwh
   FROM hil_data
  WHERE (hil_data.insert_time >= COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(59)), '-infinity'::timestamp with time zone))
  GROUP BY (time_bucket('01:00:00'::interval, hil_data.insert_time)), hil_data.hil_id;

Possibly Referenced Tables/Views

hil_data