explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lqfy

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.039 ↓ 0.0 0 1

GroupAggregate (cost=211.22..212.14 rows=41 width=36) (actual time=0.039..0.039 rows=0 loops=1)

  • Group Key: order_product_topping.order_product_id
2. 0.014 0.038 ↓ 0.0 0 1

Sort (cost=211.22..211.32 rows=41 width=55) (actual time=0.038..0.038 rows=0 loops=1)

  • Sort Key: order_product_topping.order_product_id
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.024 ↓ 0.0 0 1

Nested Loop (cost=1.72..210.12 rows=41 width=55) (actual time=0.024..0.024 rows=0 loops=1)

4. 0.002 0.024 ↓ 0.0 0 1

Nested Loop (cost=1.43..196.84 rows=41 width=35) (actual time=0.023..0.024 rows=0 loops=1)

5. 0.002 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.00..178.38 rows=41 width=12) (actual time=0.022..0.022 rows=0 loops=1)

6. 0.009 0.009 ↑ 50.0 1 1

Index Scan using order_product_order_id_index on order_product (cost=0.56..5.10 rows=50 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (order_id = 27621363)
7. 0.011 0.011 ↓ 0.0 0 1

Index Scan using order_product_topping_order_product_id_index on order_product_topping (cost=0.44..3.17 rows=30 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (order_product_id = order_product.id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using toppings_pkey on toppings (cost=0.42..0.44 rows=1 width=31) (never executed)

  • Index Cond: (id = order_product_topping.topping_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using topping_categories_pkey on topping_categories (cost=0.29..0.31 rows=1 width=28) (never executed)

  • Index Cond: (id = toppings.topping_category_id)