hil_data_summary_30s - battdb.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

thirtysec

timestamptz

35,6

√

null

hil_id

int4

√

null

hil_meta.hil_id

Implied Constraint

thirtysec_solution_time_ms

numeric

√

null

thirtysec_state_of_charge

numeric

√

null

thirtysec_measured_voltage_mv

numeric

√

null

thirtysec_modeled_voltage_mv

numeric

√

null

thirtysec_measured_current_ma

numeric

√

null

thirtysec_modeled_current_ma

numeric

√

null

thirtysec_overpotential_mv

numeric

√

null

thirtysec_voltage_delta_mv

numeric

√

null

thirtysec_reported_charge_capacity_mah

numeric

√

null

thirtysec_reported_discharge_capacity_mah

numeric

√

null

thirtysec_reported_charge_energy_mwh

numeric

√

null

thirtysec_reported_discharge_energy_mwh

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT _materialized_hypertable_57.thirtysec,
    _materialized_hypertable_57.hil_id,
    _materialized_hypertable_57.thirtysec_solution_time_ms,
    _materialized_hypertable_57.thirtysec_state_of_charge,
    _materialized_hypertable_57.thirtysec_measured_voltage_mv,
    _materialized_hypertable_57.thirtysec_modeled_voltage_mv,
    _materialized_hypertable_57.thirtysec_measured_current_ma,
    _materialized_hypertable_57.thirtysec_modeled_current_ma,
    _materialized_hypertable_57.thirtysec_overpotential_mv,
    _materialized_hypertable_57.thirtysec_voltage_delta_mv,
    _materialized_hypertable_57.thirtysec_reported_charge_capacity_mah,
    _materialized_hypertable_57.thirtysec_reported_discharge_capacity_mah,
    _materialized_hypertable_57.thirtysec_reported_charge_energy_mwh,
    _materialized_hypertable_57.thirtysec_reported_discharge_energy_mwh
   FROM _timescaledb_internal._materialized_hypertable_57
  WHERE (_materialized_hypertable_57.thirtysec < COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(57)), '-infinity'::timestamp with time zone))
UNION ALL
 SELECT time_bucket('00:00:30'::interval, hil_data.insert_time) AS thirtysec,
    hil_data.hil_id,
    avg(hil_data.solution_time_ms) AS thirtysec_solution_time_ms,
    avg(hil_data.state_of_charge) AS thirtysec_state_of_charge,
    avg(hil_data.measured_voltage_mv) AS thirtysec_measured_voltage_mv,
    avg(hil_data.modeled_voltage_mv) AS thirtysec_modeled_voltage_mv,
    avg(hil_data.measured_current_ma) AS thirtysec_measured_current_ma,
    avg(hil_data.modeled_current_ma) AS thirtysec_modeled_current_ma,
    avg(hil_data.overpotential_mv) AS thirtysec_overpotential_mv,
    avg(hil_data.voltage_delta_mv) AS thirtysec_voltage_delta_mv,
    avg(hil_data.reported_charge_capacity_mah) AS thirtysec_reported_charge_capacity_mah,
    avg(hil_data.reported_discharge_capacity_mah) AS thirtysec_reported_discharge_capacity_mah,
    avg(hil_data.reported_charge_energy_mwh) AS thirtysec_reported_charge_energy_mwh,
    avg(hil_data.reported_discharge_energy_mwh) AS thirtysec_reported_discharge_energy_mwh
   FROM hil_data
  WHERE (hil_data.insert_time >= COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(57)), '-infinity'::timestamp with time zone))
  GROUP BY (time_bucket('00:00:30'::interval, hil_data.insert_time)), hil_data.hil_id;

Possibly Referenced Tables/Views

hil_data