explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iHya : Optimization for: plan #ieCH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 164.937 5,505.951 ↑ 1.0 2,000,000 1

Limit (cost=0.56..60,247.35 rows=2,000,000 width=16) (actual time=19.122..5,505.951 rows=2,000,000 loops=1)

  • Buffers: shared hit=67,210 read=10,952
2. 5,341.014 5,341.014 ↑ 29.8 2,000,000 1

Index Only Scan using rating_edr_sub_id_index on rating_edr_open (cost=0.56..1,792,741.23 rows=59,513,244 width=16) (actual time=19.120..5,341.014 rows=2,000,000 loops=1)

  • Heap Fetches: 0
  • Buffers: shared hit=67,210 read=10,952
Planning time : 0.054 ms
Execution time : 5,621.534 ms