Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
postgres.b (cost=0.57..946.44 rows=713 width=55) (actual time=0.007..0.007 rows=1 loops=100000) Output: b.*, b.crt_time Index Cond: (b.aid = a.id) Buffers: shared hit=500000 Planning time: 0.144 ms Execution time: 832.539 ms (20 rows) Time-consuming example 2 explain