explain.depesz.com

PostgreSQL's explain analyze made readable

Result: In5 : index

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 39.423 39.423 ↑ 1.0 1,402 1

Bitmap Heap Scan on purchases (cost=39.14..68.67 rows=1,402 width=28) (actual time=38.248..39.423 rows=1,402 loops=1)

  • Recheck Cond: (customer_id = 37)
  • Heap Blocks: exact=12
  • Buffers: shared hit=15 read=5
  • -> Bitmap Index Scan on idx_purchases_customer_id (cost=0.00..38.79 rows=1402 width=0) (actual time=38.235..38.2
  • Index Cond: (customer_id = 37)
  • Buffers: shared hit=3 read=5