explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E2dl

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 0.144 ↑ 1.0 1 1

GroupAggregate (cost=14.26..14.31 rows=1 width=21) (actual time=0.142..0.144 rows=1 loops=1)

  • Group Key: ord.id, op.order_id, skp.type
2. 0.022 0.088 ↓ 3.0 3 1

Sort (cost=14.26..14.27 rows=1 width=59) (actual time=0.085..0.088 rows=3 loops=1)

  • Sort Key: op.order_id, skp.type
  • Sort Method: quicksort Memory: 25kB
3. 0.007 0.066 ↓ 3.0 3 1

Nested Loop Left Join (cost=2.27..14.25 rows=1 width=59) (actual time=0.045..0.066 rows=3 loops=1)

  • Join Filter: (ord.id = op.order_id)
4. 0.007 0.050 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.83..11.59 rows=1 width=55) (actual time=0.035..0.050 rows=3 loops=1)

5. 0.004 0.034 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.41..8.94 rows=1 width=47) (actual time=0.029..0.034 rows=3 loops=1)

6. 0.001 0.020 ↑ 1.0 1 1

Nested Loop (cost=1.12..5.57 rows=1 width=12) (actual time=0.019..0.020 rows=1 loops=1)

7. 0.012 0.012 ↑ 1.0 1 1

Index Scan using orders_pkey on orders ord (cost=0.56..2.78 rows=1 width=8) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: (id = 27616451)
8. 0.007 0.007 ↑ 1.0 1 1

Index Scan using orders_pkey on orders cio (cost=0.56..2.78 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (order_id = 27616451)
9. 0.010 0.010 ↓ 1.5 3 1

Index Scan using delivery_conditions_conditionable_id_index on delivery_conditions dcn (cost=0.29..3.35 rows=2 width=43) (actual time=0.007..0.010 rows=3 loops=1)

  • Index Cond: (cio.store_id = conditionable_id)
  • Filter: ((conditionable_type)::text = 'Store'::text)
10. 0.009 0.009 ↑ 1.0 1 3

Index Scan using storekeepers_pkey on storekeepers skp (cost=0.42..2.64 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (ord.storekeeper_id = id)
11. 0.009 0.009 ↑ 1.0 1 3

Index Only Scan using order_partner_order_id_unique on order_partner op (cost=0.43..2.65 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (order_id = 27616451)
  • Heap Fetches: 0