cycler_rt_channel_statuses_summary_hourly

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

hour

timestamptz

35,6

√

null

cycler_id

int4

10

√

null

cyclers.cycler_id

Implied Constraint

R

channel

int2

5

√

null

hour_voltage_mv

numeric

0

√

null

hour_current_ma

numeric

0

√

null

hour_charge_capacity_mah

numeric

0

√

null

hour_discharge_capacity_mah

numeric

0

√

null

hour_charge_energy_mwh

numeric

0

√

null

hour_discharge_energy_mwh

numeric

0

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT _materialized_hypertable_51.hour,
    _materialized_hypertable_51.cycler_id,
    _materialized_hypertable_51.channel,
    _materialized_hypertable_51.hour_voltage_mv,
    _materialized_hypertable_51.hour_current_ma,
    _materialized_hypertable_51.hour_charge_capacity_mah,
    _materialized_hypertable_51.hour_discharge_capacity_mah,
    _materialized_hypertable_51.hour_charge_energy_mwh,
    _materialized_hypertable_51.hour_discharge_energy_mwh
   FROM _timescaledb_internal._materialized_hypertable_51
  WHERE (_materialized_hypertable_51.hour < COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(51)), '-infinity'::timestamp with time zone))
UNION ALL
 SELECT time_bucket('01:00:00'::interval, cycler_rt_channel_statuses.insert_time) AS hour,
    cycler_rt_channel_statuses.cycler_id,
    cycler_rt_channel_statuses.channel,
    avg(cycler_rt_channel_statuses.voltage_mv) AS hour_voltage_mv,
    avg(cycler_rt_channel_statuses.current_ma) AS hour_current_ma,
    avg(cycler_rt_channel_statuses.charge_capacity_mah) AS hour_charge_capacity_mah,
    avg(cycler_rt_channel_statuses.discharge_capacity_mah) AS hour_discharge_capacity_mah,
    avg(cycler_rt_channel_statuses.charge_energy_mwh) AS hour_charge_energy_mwh,
    avg(cycler_rt_channel_statuses.discharge_energy_mwh) AS hour_discharge_energy_mwh
   FROM cycler_rt_channel_statuses
  WHERE (cycler_rt_channel_statuses.insert_time >= COALESCE(_timescaledb_internal.to_timestamp(_timescaledb_internal.cagg_watermark(51)), '-infinity'::timestamp with time zone))
  GROUP BY (time_bucket('01:00:00'::interval, cycler_rt_channel_statuses.insert_time)), cycler_rt_channel_statuses.cycler_id, cycler_rt_channel_statuses.channel;

Possibly Referenced Tables/Views

cycler_rt_channel_statuses