Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
on t t_1 (cost=0.00..6.82 rows=10 width=32) (actual time=0.010..0.010 rows=1 loops=1002) Output: (SubPlan 1) Filter: ((t_1.sensor_stat).sid IS NOT NULL) Rows Removed by Filter: 0 Buffers: shared hit=5921 SubPlan 1 -> Limit (cost=0.57..0.66 rows=1 width=49) (actual time=0.009..0.009 rows=1