explain.depesz.com

PostgreSQL's explain analyze made readable

Result: snJ9 : Long

Settings
# exclusive inclusive rows x rows loops node
1. 0.197 1,397.162 ↑ 1.5 12 1

GroupAggregate (cost=38,688.54..38,688.94 rows=18 width=36) (actual time=1,397.119..1,397.162 rows=12 loops=1)

  • Group Key: pickuppoints_pickupslot.fulfillment_date
2. 0.219 1,396.965 ↓ 23.4 422 1

Sort (cost=38,688.54..38,688.58 rows=18 width=12) (actual time=1,396.924..1,396.965 rows=422 loops=1)

  • Sort Key: pickuppoints_pickupslot.fulfillment_date
  • Sort Method: quicksort Memory: 44kB
3. 0.858 1,396.746 ↓ 23.4 422 1

Nested Loop (cost=1.42..38,688.16 rows=18 width=12) (actual time=719.799..1,396.746 rows=422 loops=1)

4. 50.820 1,384.947 ↓ 2.8 1,563 1

Nested Loop (cost=1.00..37,471.07 rows=566 width=12) (actual time=0.359..1,384.947 rows=1,563 loops=1)

5. 803.757 803.757 ↓ 9.4 106,074 1

Index Scan using orders_orderline_product_id_idx on orders_orderline (cost=0.57..11,647.70 rows=11,327 width=12) (actual time=0.062..803.757 rows=106,074 loops=1)

  • Index Cond: (product_id = 26941)
  • Filter: ((NOT is_deleted) AND (credit_line_for_id IS NULL))
  • Rows Removed by Filter: 1755
6. 530.370 530.370 ↓ 0.0 0 106,074

Index Scan using orders_order_pkey on orders_order (cost=0.43..2.27 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=106,074)

  • Index Cond: (id = orders_orderline.order_id)
  • Filter: ((payment_status = 3) AND ((fulfillment_status = 1) OR (fulfillment_status = 5) OR (fulfillment_status = 2)))
  • Rows Removed by Filter: 1
7. 10.941 10.941 ↓ 0.0 0 1,563

Index Scan using pickuppoints_pickupslot_pkey on pickuppoints_pickupslot (cost=0.42..2.14 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1,563)

  • Index Cond: (id = orders_order.pickup_slot_id)
  • Filter: ((date >= '2019-03-11'::date) AND (date <= '2019-04-10'::date))
  • Rows Removed by Filter: 1