如何在ScadaLTS中计数每秒保存数据

Question

为ScadaLTS创建基准，它检查每秒在数据库中存储了多少数据。

创建数据源

​

​

复制三次

​

​

并启用每个数据源和数据点。

如何在ScadaLTS中计数每秒保存数据？

Answer 1

您可以使用SQL执行此操作：

select 
count(*),
 YEAR(from_unixtime(ts/1000)),
        MONTH(from_unixtime(ts/1000)),
        DAY(from_unixtime(ts/1000)),
        hour(from_unixtime(ts/1000)),
        minute(from_unixtime(ts/1000)),
        second(from_unixtime(ts/1000))
from pointValues 
where
  YEAR(from_unixtime(ts/1000))  = YEAR(NOW()) and
  MONTH(from_unixtime(ts/1000))  = Month(NOW()) and
  DAY(from_unixtime(ts/1000))  = DAY(NOW())
group by
    YEAR(from_unixtime(ts/1000)),
        MONTH(from_unixtime(ts/1000)),
        DAY(from_unixtime(ts/1000)),
        hour(from_unixtime(ts/1000)),
        minute(from_unixtime(ts/1000)),
        second(from_unixtime(ts/1000))
Having count(*) >5
order by count(*) DESC