explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 44Rq : Optimization for: index; plan #In5

Settings

Optimization path:

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

Seq Scan on purchases (cost=0.00..31.14 rows=1,402 width=28) (actual time=0.033..1.466 rows=1,402 loops=1)

  • Filter: (customer_id = 37)
  • Rows Removed by Filter: 129
  • Buffers: shared hit=12