explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qnG1

Settings
# exclusive inclusive rows x rows loops node
1. 0.228 0.459 ↓ 24.0 24 1

Nested Loop Left Join (cost=13.98..52.59 rows=1 width=2,480) (actual time=0.160..0.459 rows=24 loops=1)

  • Join Filter: (order_modifications.order_id = orders.id)
2.          

CTE temporal

3. 0.018 0.018 ↑ 3.0 8 1

Index Scan using order_modifications_order_id_index on order_modifications order_modifications_1 (cost=0.57..6.97 rows=24 width=33) (actual time=0.008..0.018 rows=8 loops=1)

  • Index Cond: (order_id = 26236857)
4. 0.006 0.192 ↓ 3.0 3 1

Nested Loop Left Join (cost=7.01..45.04 rows=1 width=1,539) (actual time=0.128..0.192 rows=3 loops=1)

  • Join Filter: (order_stores.order_id = orders.id)
5. 0.007 0.174 ↓ 3.0 3 1

Nested Loop Left Join (cost=6.58..42.38 rows=1 width=1,446) (actual time=0.119..0.174 rows=3 loops=1)

  • Join Filter: (order_whims.order_id = orders.id)
6. 0.006 0.155 ↓ 3.0 3 1

Nested Loop Left Join (cost=6.15..39.36 rows=1 width=1,167) (actual time=0.111..0.155 rows=3 loops=1)

7. 0.005 0.140 ↓ 3.0 3 1

Nested Loop Left Join (cost=5.71..35.92 rows=1 width=1,163) (actual time=0.103..0.140 rows=3 loops=1)

8. 0.006 0.123 ↓ 3.0 3 1

Nested Loop Left Join (cost=5.28..32.38 rows=1 width=1,101) (actual time=0.094..0.123 rows=3 loops=1)

9. 0.005 0.102 ↓ 3.0 3 1

Nested Loop Left Join (cost=4.71..29.59 rows=1 width=941) (actual time=0.086..0.102 rows=3 loops=1)

  • Join Filter: (order_product.order_id = orders.id)
10. 0.006 0.087 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.15..24.22 rows=1 width=874) (actual time=0.076..0.087 rows=1 loops=1)

  • Join Filter: (order_store_zones.order_id = orders.id)
11. 0.001 0.075 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.71..21.55 rows=1 width=873) (actual time=0.067..0.075 rows=1 loops=1)

  • Join Filter: (order_partner.order_id = orders.id)
12. 0.000 0.068 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.28..18.89 rows=1 width=861) (actual time=0.061..0.068 rows=1 loops=1)

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

Nested Loop Left Join (cost=2.85..16.23 rows=1 width=726) (actual time=0.056..0.064 rows=1 loops=1)

  • Join Filter: (personal_shopper.order_id = orders.id)
14. 0.003 0.056 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.42..13.55 rows=1 width=660) (actual time=0.049..0.056 rows=1 loops=1)

  • Join Filter: (storekeeper.order_id = orders.id)
15. 0.005 0.045 ↑ 1.0 1 1

Nested Loop (cost=1.99..10.89 rows=1 width=586) (actual time=0.038..0.045 rows=1 loops=1)

16. 0.001 0.033 ↑ 1.0 1 1

Nested Loop (cost=1.43..8.10 rows=1 width=416) (actual time=0.030..0.033 rows=1 loops=1)

17. 0.003 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.99..5.44 rows=1 width=362) (actual time=0.022..0.025 rows=1 loops=1)

18. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: (id = 26236857)
19. 0.009 0.009 ↑ 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=0.009..0.009 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
20. 0.007 0.007 ↑ 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=0.006..0.007 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
21. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (order_id = 26236857)
22. 0.008 0.008 ↑ 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=0.007..0.008 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
23. 0.006 0.006 ↓ 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.005..0.006 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
  • Filter: (is_current IS TRUE)
24. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
25. 0.006 0.006 ↓ 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=0.006..0.006 rows=0 loops=1)

  • Index Cond: (order_id = 26236857)
26. 0.006 0.006 ↑ 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=0.006..0.006 rows=1 loops=1)

  • Index Cond: (order_id = 26236857)
27. 0.010 0.010 ↑ 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.007..0.010 rows=3 loops=1)

  • Index Cond: (order_id = 26236857)
28. 0.015 0.015 ↑ 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.005..0.005 rows=1 loops=3)

  • Index Cond: (order_product_id = order_product.id)
29. 0.012 0.012 ↓ 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.004..0.004 rows=0 loops=3)

  • Index Cond: (order_product_id = order_product.id)
30. 0.009 0.009 ↓ 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.003..0.003 rows=0 loops=3)

  • Index Cond: (order_product_id = order_product.id)
31. 0.012 0.012 ↑ 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.003..0.004 rows=1 loops=3)

  • Index Cond: (order_id = 26236857)
32. 0.012 0.012 ↑ 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.004..0.004 rows=1 loops=3)

  • Index Cond: (order_id = 26236857)
33. 0.039 0.039 ↓ 8.0 8 3

CTE Scan on temporal order_modifications (cost=0.00..0.54 rows=1 width=532) (actual time=0.004..0.013 rows=8 loops=3)

  • Filter: (order_id = 26236857)