Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
(t.sensor_stat).sid, (t.sensor_stat).state, (t.sensor_stat).crt_time Filter: (t.* IS NOT NULL) Rows Removed by Filter: 1 Buffers: shared hit=5926 CTE t -> Recursive Union (cost=0.57..70.86 rows=101 width=37) (actual time=0.030..10.293 rows=1002 loops=1) Buffers: shared hit=5926 -> Subquery Scan on