Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
(t.sensor_stat).state is true; count ------- 501 (1 row) Time: 20.743 ms Adding this time limit has some performance impact, especially if the time is a long time ago: the more filtering, the more serious performance degradation. Therefore, we recommend starting a query request every second in real