Kesseltemperatur VA:0x00 -------------------------------------------------------------------------------- select* from p4.samples where address="0" and type="VA" and value>"1000"; +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | 0 | VA | S | 2021-01-23 16:58:18 | 1611417498 | 1611417498 | 8320.50 | NULL | 1 | | 0 | VA | S | 2021-02-23 23:43:17 | 1614120197 | 1614120197 | 8320.50 | NULL | 1 | | 0 | VA | S | 2021-03-05 01:34:02 | 1614904442 | 1614904442 | 8320.50 | NULL | 1 | | 0 | VA | S | 2021-03-05 23:52:47 | 1614984767 | 1614984767 | 8320.50 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ 4 rows in set (1.143 sec) delete from p4.samples where address="0" and type="VA" and value>"1000"; Query OK, 4 rows affected (1.670 sec) select* from p4.samples where address="0" and type="VA" and value>"1000"; Empty set (0.961 sec) Abgastemperatur VA:0x01 --------------------------------------------------------------------------------- select* from p4.samples where address="1" and type="VA" and value>"300"; +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ | 1 | VA | S | 2020-04-24 20:01:36 | 1587751296 | 1587751296 | 1128.00 | NULL | 1 | | 1 | VA | S | 2021-01-23 16:58:18 | 1611417498 | 1611417498 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-02-15 02:03:31 | 1613351011 | 1613351011 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-02-16 16:41:01 | 1613490061 | 1613490061 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-03-03 00:00:05 | 1614726005 | 1614726005 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-03-05 01:34:02 | 1614904442 | 1614904442 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-03-05 23:52:47 | 1614984767 | 1614984767 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-03-08 01:27:32 | 1615163252 | 1615163252 | 16641.00 | NULL | 1 | | 1 | VA | S | 2021-03-13 16:53:41 | 1615650821 | 1615650821 | 16641.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ 9 rows in set (2.392 sec) delete from p4.samples where address="1" and type="VA" and value>"300"; Boardtemperatur VA:0x02 --------------------------------------------------------------------------------- select* from p4.samples where address="2" and type="VA" and value>"50"; +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | 2 | VA | S | 2021-02-15 02:03:31 | 1613351011 | 1613351011 | 8320.50 | NULL | 1 | | 2 | VA | S | 2021-02-16 16:41:01 | 1613490061 | 1613490061 | 8320.00 | NULL | 1 | | 2 | VA | S | 2021-02-23 23:43:17 | 1614120197 | 1614120197 | 8320.50 | NULL | 1 | | 2 | VA | S | 2021-02-24 22:49:58 | 1614203398 | 1614203398 | 8320.00 | NULL | 1 | | 2 | VA | S | 2021-03-03 00:00:05 | 1614726005 | 1614726005 | 8320.50 | NULL | 1 | | 2 | VA | S | 2021-03-05 01:34:02 | 1614904442 | 1614904442 | 8320.00 | NULL | 1 | | 2 | VA | S | 2021-03-05 23:52:47 | 1614984767 | 1614984767 | 8320.50 | NULL | 1 | | 2 | VA | S | 2021-03-13 16:53:41 | 1615650821 | 1615650821 | 8320.00 | NULL | 1 | | 2 | VA | S | 2021-03-18 00:44:01 | 1616024641 | 1616024641 | 8320.50 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ 9 rows in set (1.118 sec) delete from p4.samples where address="2" and type="VA" and value>"50"; Außentemperatur VA:0x04 --------------------------------------------------------------------------------- MariaDB [p4]> select* from p4.samples where address="4" and type="VA" and value>"40"; +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | 4 | VA | S | 2021-01-14 16:16:26 | 1610637386 | 1610637386 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-02-15 02:03:31 | 1613351011 | 1613351011 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-02-24 22:49:58 | 1614203398 | 1614203398 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-03-03 00:00:05 | 1614726005 | 1614726005 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-03-05 01:34:02 | 1614904442 | 1614904442 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-03-05 23:52:47 | 1614984767 | 1614984767 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-03-08 01:27:32 | 1615163252 | 1615163252 | 8320.50 | NULL | 1 | | 4 | VA | S | 2021-03-13 16:53:41 | 1615650821 | 1615650821 | 8320.00 | NULL | 1 | | 4 | VA | S | 2021-03-18 00:44:01 | 1616024641 | 1616024641 | 8320.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ 9 rows in set (1.132 sec) delete from p4.samples where address="4" and type="VA" and value>"40"; Saugzugdrehzahl VA0:07 ----------------------------------------------------------------------------------- select* from p4.samples where address="7" and type="VA" and value>"3000"; +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ | 7 | VA | S | 2021-02-16 16:41:01 | 1613490061 | 1613490061 | 16640.00 | NULL | 1 | | 7 | VA | S | 2021-02-24 22:49:58 | 1614203398 | 1614203398 | 16640.00 | NULL | 1 | | 7 | VA | S | 2021-03-13 16:53:41 | 1615650821 | 1615650821 | 16640.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+----------+------+---------+ 3 rows in set (1.134 sec) delete from p4.samples where address="7" and type="VA" and value>"3000"; Vorlauf-Isttemperatur VA0:15 ---------------------------------------------------------------------------- select* from p4.samples where address="15" and type="VA" and value>"100"; +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ | 15 | VA | S | 2021-02-23 23:43:17 | 1614120197 | 1614120197 | 1924.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+---------+------+---------+ 1 row in set (1.116 sec) delete from p4.samples where address="15" and type="VA" and value>"100"; Raumtemperatur VA0:18 ---------------------------------------------------------------------------------- select* from p4.samples where address="18" and type="VA" and value>"100"; +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ | 18 | VA | S | 2021-01-14 16:16:26 | 1610637386 | 1610637386 | 545.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ 1 row in set (1.156 sec) delete from p4.samples where address="18" and type="VA" and value>"100"; Vorlauf-Isttemperatur VA0x19---------------------------------------------------------------------------- select* from p4.samples where address="15" and type="VA" and value>"100"; ... 261363 rows in set (1.631 sec) elect* from p4.samples where address="19" and type="VA" and value>"300"; Empty set (0.986 sec) Pufferpumpen Ansteuerung VA0x8c ------------------------------------------------------------------------ select* from p4.samples where address="8c" and type="VA" and value>"100"; +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ | address | type | aggregate | time | inssp | updsp | value | text | samples | +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ | 8 | VA | S | 2020-04-16 09:23:44 | 1587021824 | 1587021824 | 127.00 | NULL | 1 | +---------+------+-----------+---------------------+------------+------------+--------+------+---------+ 237 rows in set (0.011 sec)