explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QrlD

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

Nested Loop Left Join (cost=32.94..145.48 rows=24 width=16,556) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (order_modifications.order_id = orders.id)
2. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=32.67..135.09 rows=12 width=16,528) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_discounts.order_id = orders.id)
3. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.96..118.13 rows=12 width=16,483) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_product.order_id = orders.id)
4. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.82..76.35 rows=2 width=12,995) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_whims.order_id = orders.id)
5. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.41..63.96 rows=1 width=11,920) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_stores.order_id = orders.id)
6. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.27..55.79 rows=1 width=9,815) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_store_zones.order_id = orders.id)
7. 0.001 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.27..54.53 rows=1 width=9,814) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (order_partner.order_id = orders.id)
8. 0.000 0.015 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.12..46.35 rows=1 width=9,802) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: (order_reference_point.order_id = orders.id)
9. 0.000 0.015 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.12..42.26 rows=1 width=9,766) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: (personal_shopper.order_id = orders.id)
10. 0.000 0.015 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.98..34.09 rows=1 width=7,698) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: (storekeeper.order_id = orders.id)
11. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.98..33.08 rows=1 width=5,114) (actual time=0.015..0.015 rows=0 loops=1)

12. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.70..24.77 rows=1 width=3,951) (actual time=0.015..0.015 rows=0 loops=1)

13. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.56..16.61 rows=1 width=1,883) (actual time=0.015..0.015 rows=0 loops=1)

14. 0.010 0.010 ↑ 1.0 1 1

Index Scan using orders_pkey on orders (cost=0.42..8.44 rows=1 width=315) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = 12)
15. 0.003 0.003 ↓ 0.0 0 1

Index Scan using order_addresses_order_id_address_id_unique on order_addresses (cost=0.14..8.15 rows=1 width=1,576) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (order_id = 12)
  • Filter: (is_current IS TRUE)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using order_application_users_order_id_application_user_id_unique on order_application_users (cost=0.14..8.15 rows=1 width=2,076) (never executed)

  • Index Cond: (order_id = 12)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using orders_pkey on orders calculated_information (cost=0.28..8.30 rows=1 width=1,167) (never executed)

  • Index Cond: (order_id = 12)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_storekeepers storekeeper (cost=0.00..1.00 rows=1 width=2,592) (never executed)

  • Filter: ((is_current IS TRUE) AND (order_id = 12))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using order_personal_shoppers_order_id_index on order_personal_shoppers personal_shopper (cost=0.14..8.15 rows=1 width=2,076) (never executed)

  • Index Cond: (order_id = 12)
  • Filter: (is_current IS TRUE)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_reference_point (cost=0.00..4.08 rows=1 width=40) (never executed)

  • Filter: (order_id = 12)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using order_partner_order_id_unique on order_partner (cost=0.15..8.17 rows=1 width=12) (never executed)

  • Index Cond: (order_id = 12)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_store_zones (cost=0.00..1.25 rows=1 width=5) (never executed)

  • Filter: (order_id = 12)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using order_stores_order_id_index on order_stores (cost=0.14..8.15 rows=1 width=2,109) (never executed)

  • Index Cond: (order_id = 12)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using order_whims_order_id_idx on order_whims (cost=0.42..12.37 rows=2 width=1,079) (never executed)

  • Index Cond: (order_id = 12)
25. 0.000 0.000 ↓ 0.0 0

Materialize (cost=30.13..41.62 rows=6 width=3,492) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=30.13..41.59 rows=6 width=3,492) (never executed)

  • Join Filter: (toppings.order_product_id = order_product.id)
27. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=30.13..40.28 rows=6 width=2,436) (never executed)

  • Hash Cond: (products.order_product_id = order_product.id)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_product_detail products (cost=0.00..10.10 rows=10 width=2,400) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Hash (cost=30.06..30.06 rows=6 width=40) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=28.22..30.06 rows=6 width=40) (never executed)

  • Hash Cond: (order_product_topping.order_product_id = order_product.id)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_product_topping (cost=0.00..1.60 rows=60 width=8) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Hash (cost=28.15..28.15 rows=6 width=36) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on order_product (cost=4.47..28.15 rows=6 width=36) (never executed)

  • Recheck Cond: (order_id = 12)
34. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on order_product_order_id_product_id_store_id_idx (cost=0.00..4.47 rows=6 width=0) (never executed)

  • Index Cond: (order_id = 12)
35. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.04 rows=3 width=1,060) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_product_topping_detail toppings (cost=0.00..1.03 rows=3 width=1,060) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.71..16.79 rows=1 width=49) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..16.78 rows=1 width=49) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Scan using order_discounts_order_id_index on order_discounts (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (order_id = 12)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using order_discount_details_order_discount_id_index on order_discount_details (cost=0.29..8.33 rows=2 width=37) (never executed)

  • Index Cond: (order_discount_id = order_discounts.id)
41. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..9.37 rows=2 width=32) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Index Scan using order_modifications_order_id_index on order_modifications (cost=0.28..9.36 rows=2 width=32) (never executed)

  • Index Cond: (order_id = 12)