Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
shared hit=5 -> Index Scan using idx_sensor_stat_1 on public.sensor_stat (cost=0.57..3180100.70 rows=55369290 width=49) (actual time=0.027..0.027 rows=1 loops=1) Output: sensor_stat.*, sensor_stat.sid, sensor_stat.crt_time Filter: (sensor_stat.state IS TRUE) Buffers: shared hit=5 -> WorkTable Scan