explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHHO

Settings
# exclusive inclusive rows x rows loops node
1. 0.478 23.140 ↓ 24.0 24 1

Nested Loop Left Join (cost=7.58..52.34 rows=1 width=1,979) (actual time=17.196..23.140 rows=24 loops=1)

  • Join Filter: (order_modifications.order_id = orders.id)
2. 0.028 16.668 ↓ 3.0 3 1

Nested Loop Left Join (cost=7.01..45.04 rows=1 width=1,537) (actual time=15.446..16.668 rows=3 loops=1)

  • Join Filter: (order_stores.order_id = orders.id)
3. 0.019 15.596 ↓ 3.0 3 1

Nested Loop Left Join (cost=6.58..42.38 rows=1 width=1,444) (actual time=14.393..15.596 rows=3 loops=1)

  • Join Filter: (order_whims.order_id = orders.id)
4. 0.013 14.524 ↓ 3.0 3 1

Nested Loop Left Join (cost=6.15..39.36 rows=1 width=1,165) (actual time=13.339..14.524 rows=3 loops=1)

5. 0.013 12.819 ↓ 3.0 3 1

Nested Loop Left Join (cost=5.71..35.92 rows=1 width=1,161) (actual time=11.652..12.819 rows=3 loops=1)

6. 0.020 11.213 ↓ 3.0 3 1

Nested Loop Left Join (cost=5.28..32.38 rows=1 width=1,099) (actual time=10.063..11.213 rows=3 loops=1)

7. 0.024 9.666 ↓ 3.0 3 1

Nested Loop Left Join (cost=4.71..29.59 rows=1 width=939) (actual time=9.004..9.666 rows=3 loops=1)

  • Join Filter: (order_product.order_id = orders.id)
8. 0.012 8.449 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.15..24.22 rows=1 width=872) (actual time=8.436..8.449 rows=1 loops=1)

  • Join Filter: (order_store_zones.order_id = orders.id)
9. 0.005 6.827 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.71..21.55 rows=1 width=871) (actual time=6.815..6.827 rows=1 loops=1)

  • Join Filter: (order_partner.order_id = orders.id)
10. 0.002 5.794 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.28..18.89 rows=1 width=859) (actual time=5.784..5.794 rows=1 loops=1)

  • Join Filter: (order_reference_point.order_id = orders.id)
11. 0.002 5.331 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.85..16.23 rows=1 width=724) (actual time=5.321..5.331 rows=1 loops=1)

  • Join Filter: (personal_shopper.order_id = orders.id)
12. 0.014 4.857 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.42..13.55 rows=1 width=658) (actual time=4.846..4.857 rows=1 loops=1)

  • Join Filter: (storekeeper.order_id = orders.id)
13. 0.007 3.454 ↑ 1.0 1 1

Nested Loop (cost=1.99..10.89 rows=1 width=584) (actual time=3.446..3.454 rows=1 loops=1)

14. 0.003 2.982 ↑ 1.0 1 1

Nested Loop (cost=1.43..8.10 rows=1 width=415) (actual time=2.976..2.982 rows=1 loops=1)

15. 0.005 1.351 ↑ 1.0 1 1

Nested Loop (cost=0.99..5.44 rows=1 width=361) (actual time=1.345..1.351 rows=1 loops=1)

16. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: (id = 26236857)
17. 1.333 1.333 ↑ 1.0 1 1

Index Scan using order_addresses_order_id_address_id_unique on order_addresses (cost=0.43..2.65 rows=1 width=69) (actual time=1.332..1.333 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
18. 1.628 1.628 ↑ 1.0 1 1

Index Scan using order_application_users_order_id_application_user_id_unique on order_application_users (cost=0.43..2.65 rows=1 width=62) (actual time=1.627..1.628 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
19. 0.465 0.465 ↑ 1.0 1 1

Index Scan using orders_pkey on orders calculated_information (cost=0.56..2.78 rows=1 width=173) (actual time=0.464..0.465 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
20. 1.389 1.389 ↑ 1.0 1 1

Index Scan using order_storekeepers_order_id_index on order_storekeepers storekeeper (cost=0.43..2.65 rows=1 width=82) (actual time=1.389..1.389 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
21. 0.472 0.472 ↓ 0.0 0 1

Index Scan using order_personal_shoppers_order_id_index on order_personal_shoppers personal_shopper (cost=0.42..2.66 rows=1 width=74) (actual time=0.471..0.472 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
22. 0.461 0.461 ↓ 0.0 0 1

Index Scan using order_reference_point_pkey on order_reference_point (cost=0.43..2.65 rows=1 width=139) (actual time=0.461..0.461 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
23. 1.028 1.028 ↓ 0.0 0 1

Index Scan using order_partner_order_id_unique on order_partner (cost=0.43..2.65 rows=1 width=12) (actual time=1.027..1.028 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
24. 1.610 1.610 ↑ 1.0 1 1

Index Scan using order_store_zones_pkey on order_store_zones (cost=0.43..2.65 rows=1 width=5) (actual time=1.609..1.610 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
25. 1.193 1.193 ↑ 15.7 3 1

Index Scan using order_product_order_id_index on order_product (cost=0.56..4.79 rows=47 width=71) (actual time=0.552..1.193 rows=3 loops=1)

  • Index Cond: (order_id = 26236857)
26. 1.527 1.527 ↑ 1.0 1 3

Index Scan using order_product_detail_pkey on order_product_detail products (cost=0.56..2.78 rows=1 width=164) (actual time=0.509..0.509 rows=1 loops=3)

  • Index Cond: (order_product_id = order_product.id)
27. 1.593 1.593 ↓ 0.0 0 3

Index Scan using order_product_topping_detail_order_product_id_index on order_product_topping_detail toppings (cost=0.43..3.22 rows=32 width=66) (actual time=0.530..0.531 rows=0 loops=3)

  • Index Cond: (order_product_id = order_product.id)
28. 1.692 1.692 ↓ 0.0 0 3

Index Scan using order_product_topping_order_product_id_index on order_product_topping (cost=0.44..3.15 rows=29 width=8) (actual time=0.564..0.564 rows=0 loops=3)

  • Index Cond: (order_product_id = order_product.id)
29. 1.053 1.053 ↑ 2.0 1 3

Index Scan using order_whims_order_id_index on order_whims (cost=0.43..3.00 rows=2 width=283) (actual time=0.350..0.351 rows=1 loops=3)

  • Index Cond: (order_id = 26236857)
30. 1.044 1.044 ↑ 1.0 1 3

Index Scan using order_stores_order_id_index on order_stores (cost=0.43..2.65 rows=1 width=97) (actual time=0.347..0.348 rows=1 loops=3)

  • Index Cond: (order_id = 26236857)
31. 5.994 5.994 ↑ 3.0 8 3

Index Scan using order_modifications_order_id_index on order_modifications (cost=0.57..6.97 rows=24 width=33) (actual time=0.551..1.998 rows=8 loops=3)

  • Index Cond: (order_id = 26236857)