Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
shared hit=500820 -> Index Scan using idx_b_1 on postgres.b (cost=0.57..134.12 rows=100 width=55) (actual time=0.006..0.006 rows=1 loops=100000) Output: b.*, b.crt_time Index Cond: ((b.aid = a.id) AND (b.crt_time >= '2017-07-17 09:53:00.480416'::timestamp without time zone) AND (b.crt_time <=