Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
10:29:09.469192 1000 | t | 2017-07-05 10:29:09.472195 (1001 rows) Time: 11.067 ms It is very efficient. For 110.1 million pieces of data, the final online state can be obtained in 11 milliseconds. An example of an online device with state=t is as follows: with recursive t as ( ( select sensor_stat