explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5OfH

Settings
# exclusive inclusive rows x rows loops node
1. 0.668 5.975 ↑ 1.0 1 1

Aggregate (cost=411.29..411.30 rows=1 width=0) (actual time=5.974..5.975 rows=1 loops=1)

2. 5.307 5.307 ↓ 3.1 3,185 1

Index Only Scan using good_locations_virtual_stock_idx on stock_item_locations (cost=0.42..408.71 rows=1,033 width=0) (actual time=0.106..5.307 rows=3,185 loops=1)

  • Index Cond: (virtual_stock = 'sell_stock'::text)
  • Heap Fetches: 2020