Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
rows=100000 width=32) (actual time=0.031..787.322 rows=100000 loops=1) Output: (SubPlan 1) Buffers: shared hit=500443 SubPlan 1 -> Limit (cost=0.57..1.89 rows=1 width=55) (actual time=0.007..0.007 rows=1 loops=100000) Output: b.*, b.crt_time Buffers: shared hit=500000 -> Index Scan using idx_b_1 on