explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IwjF : v3

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 125.018 171.299 ↑ 250,000.0 2 1

Bitmap Heap Scan on orders (cost=9,359.57..951,578.26 rows=500,000 width=16) (actual time=170.701..171.299 rows=2 loops=1)

  • Recheck Cond: (user_account_id = 4500000)
  • Heap Blocks: exact=2
2. 46.281 46.281 ↑ 250,000.0 2 1

Bitmap Index Scan on orders_user_account_id_idx (cost=0.00..9,234.57 rows=500,000 width=0) (actual time=46.281..46.281 rows=2 loops=1)

  • Index Cond: (user_account_id = 4500000)