explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FhvS

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 0.820 ↓ 1.6 24 1

Nested Loop Left Join (cost=7.58..234.76 rows=15 width=2,519) (actual time=0.185..0.820 rows=24 loops=1)

2. 0.033 0.692 ↓ 1.6 24 1

Nested Loop Left Join (cost=7.15..194.86 rows=15 width=2,272) (actual time=0.175..0.692 rows=24 loops=1)

3. 0.042 0.611 ↓ 1.6 24 1

Nested Loop Left Join (cost=6.71..171.08 rows=15 width=2,248) (actual time=0.167..0.611 rows=24 loops=1)

4. 0.040 0.521 ↓ 1.6 24 1

Nested Loop Left Join (cost=6.28..146.26 rows=15 width=2,166) (actual time=0.159..0.521 rows=24 loops=1)

5. 0.044 0.409 ↓ 1.6 24 1

Nested Loop Left Join (cost=5.71..131.34 rows=15 width=1,921) (actual time=0.149..0.409 rows=24 loops=1)

6. 0.018 0.325 ↑ 1.0 8 1

Nested Loop Left Join (cost=5.15..89.29 rows=8 width=1,818) (actual time=0.138..0.325 rows=8 loops=1)

7. 0.017 0.275 ↑ 1.0 8 1

Nested Loop Left Join (cost=4.72..65.14 rows=8 width=1,506) (actual time=0.131..0.275 rows=8 loops=1)

8. 0.007 0.226 ↑ 1.0 8 1

Nested Loop Left Join (cost=4.28..43.84 rows=8 width=1,493) (actual time=0.124..0.226 rows=8 loops=1)

9. 0.017 0.195 ↑ 1.0 8 1

Nested Loop (cost=3.85..22.54 rows=8 width=1,481) (actual time=0.117..0.195 rows=8 loops=1)

  • Join Filter: (order_addresses.order_id = order_modifications.order_id)
10. 0.005 0.150 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.28..19.92 rows=1 width=1,261) (actual time=0.096..0.150 rows=2 loops=1)

11. 0.002 0.119 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.85..17.26 rows=1 width=1,106) (actual time=0.071..0.119 rows=2 loops=1)

12. 0.003 0.107 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.42..14.59 rows=1 width=1,007) (actual time=0.064..0.107 rows=2 loops=1)

13. 0.011 0.084 ↓ 2.0 2 1

Nested Loop (cost=1.99..11.93 rows=1 width=900) (actual time=0.047..0.084 rows=2 loops=1)

  • Join Filter: (order_addresses.order_id = order_application_users.order_id)
14. 0.002 0.059 ↓ 2.0 2 1

Nested Loop (cost=1.56..11.13 rows=1 width=814) (actual time=0.032..0.059 rows=2 loops=1)

15. 0.005 0.041 ↓ 2.0 2 1

Nested Loop (cost=0.99..9.99 rows=1 width=433) (actual time=0.023..0.041 rows=2 loops=1)

16. 0.020 0.020 ↑ 1.0 2 1

Index Scan using orders_pkey on orders (cost=0.56..4.67 rows=2 width=325) (actual time=0.011..0.020 rows=2 loops=1)

  • Index Cond: (id = ANY ('{26236857,27923671}'::integer[]))
17. 0.016 0.016 ↑ 1.0 1 2

Index Scan using order_addresses_order_id_address_id_unique on order_addresses (cost=0.43..2.65 rows=1 width=108) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: (order_id = orders.id)
  • Filter: (is_current IS TRUE)
18. 0.016 0.016 ↑ 1.0 1 2

Index Scan using orders_pkey on orders calculated_information (cost=0.56..1.13 rows=1 width=381) (actual time=0.007..0.008 rows=1 loops=2)

  • Index Cond: (order_id = order_addresses.order_id)
19. 0.014 0.014 ↑ 1.0 1 2

Index Scan using order_application_users_order_id_index on order_application_users (cost=0.43..0.78 rows=1 width=86) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (order_id = calculated_information.order_id)
20. 0.020 0.020 ↓ 0.0 0 2

Index Scan using order_storekeepers_order_id_index on order_storekeepers storekeeper (cost=0.43..2.65 rows=1 width=107) (actual time=0.009..0.010 rows=0 loops=2)

  • Index Cond: (order_id = orders.id)
  • Filter: (is_current IS TRUE)
21. 0.010 0.010 ↓ 0.0 0 2

Index Scan using order_personal_shoppers_order_id_index on order_personal_shoppers personal_shopper (cost=0.42..2.66 rows=1 width=99) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (order_id = orders.id)
  • Filter: (is_current IS TRUE)
22. 0.026 0.026 ↓ 0.0 0 2

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

  • Index Cond: (order_id = orders.id)
23. 0.028 0.028 ↑ 6.0 4 2

Index Scan using order_modifications_order_id_index on order_modifications (cost=0.57..2.32 rows=24 width=220) (actual time=0.009..0.014 rows=4 loops=2)

  • Index Cond: (order_id = calculated_information.order_id)
24. 0.024 0.024 ↓ 0.0 0 8

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

  • Index Cond: (order_id = orders.id)
25. 0.032 0.032 ↑ 1.0 1 8

Index Scan using order_store_zones_pkey on order_store_zones (cost=0.43..2.65 rows=1 width=13) (actual time=0.003..0.004 rows=1 loops=8)

  • Index Cond: (order_id = orders.id)
26. 0.032 0.032 ↑ 2.0 1 8

Index Scan using order_whims_order_id_index on order_whims (cost=0.43..3.00 rows=2 width=312) (actual time=0.004..0.004 rows=1 loops=8)

  • Index Cond: (order_id = orders.id)
27. 0.040 0.040 ↑ 15.7 3 8

Index Scan using order_product_order_id_index on order_product (cost=0.56..4.79 rows=47 width=103) (actual time=0.004..0.005 rows=3 loops=8)

  • Index Cond: (order_id = orders.id)
28. 0.072 0.072 ↑ 1.0 1 24

Index Scan using order_product_detail_pkey on order_product_detail products (cost=0.56..0.98 rows=1 width=245) (actual time=0.002..0.003 rows=1 loops=24)

  • Index Cond: (order_product_id = order_product.id)
29. 0.048 0.048 ↓ 0.0 0 24

Index Scan using order_product_topping_detail_order_product_id_index on order_product_topping_detail toppings (cost=0.43..1.34 rows=32 width=82) (actual time=0.002..0.002 rows=0 loops=24)

  • Index Cond: (order_product_id = order_product.id)
30. 0.048 0.048 ↓ 0.0 0 24

Index Scan using order_product_topping_order_product_id_index on order_product_topping (cost=0.44..1.30 rows=29 width=24) (actual time=0.002..0.002 rows=0 loops=24)

  • Index Cond: (order_product_id = order_product.id)
31. 0.072 0.072 ↑ 1.0 1 24

Index Scan using order_stores_order_id_index on order_stores (cost=0.43..2.65 rows=1 width=247) (actual time=0.002..0.003 rows=1 loops=24)

  • Index Cond: (order_id = orders.id)