Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
86,400 points in time per day is required regardless of the number of records. For example, to count the number of sensors online at 2017-07-05 10:29:09, just add a time limit. with recursive t as ( ( select sensor_stat as sensor_stat from sensor_stat where crt_time <= '2017-07-05 10:29:09' order