explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmZR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 4.088 ↑ 1.0 1 1

GroupAggregate (cost=1.12..1,935.68 rows=1 width=12) (actual time=4.088..4.088 rows=1 loops=1)

  • Group Key: order_storekeepers.storekeeper_id
2. 0.525 4.086 ↑ 1.0 1 1

Nested Loop (cost=1.12..1,935.66 rows=1 width=8) (actual time=4.085..4.086 rows=1 loops=1)

3. 0.261 0.261 ↓ 1.2 825 1

Index Only Scan using order_storekeepers_storekeeper_id_order_id_current_index on order_storekeepers (cost=0.56..28.38 rows=683 width=12) (actual time=0.010..0.261 rows=825 loops=1)

  • Index Cond: (storekeeper_id = 154755)
  • Heap Fetches: 143
4. 3.300 3.300 ↓ 0.0 0 825

Index Scan using orders_pkey on orders calculated_order (cost=0.56..2.78 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=825)

  • Index Cond: (order_id = order_storekeepers.order_id)
  • Filter: is_active
  • Rows Removed by Filter: 1