explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6h9

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 0.370 ↓ 4.0 8 1

Nested Loop Left Join (cost=7.01..42.04 rows=2 width=1,927) (actual time=0.142..0.370 rows=8 loops=1)

2. 0.012 0.268 ↓ 4.0 8 1

Nested Loop Left Join (cost=6.57..39.50 rows=2 width=1,534) (actual time=0.118..0.268 rows=8 loops=1)

3. 0.011 0.240 ↓ 4.0 8 1

Nested Loop Left Join (cost=6.14..36.86 rows=2 width=1,472) (actual time=0.109..0.240 rows=8 loops=1)

4. 0.013 0.197 ↓ 4.0 8 1

Nested Loop Left Join (cost=5.57..35.59 rows=2 width=1,312) (actual time=0.101..0.197 rows=8 loops=1)

5. 0.002 0.154 ↓ 2.0 2 1

Nested Loop Left Join (cost=5.01..30.33 rows=1 width=1,245) (actual time=0.092..0.154 rows=2 loops=1)

6. 0.005 0.142 ↓ 2.0 2 1

Nested Loop Left Join (cost=4.58..27.67 rows=1 width=1,152) (actual time=0.085..0.142 rows=2 loops=1)

7. 0.002 0.129 ↓ 2.0 2 1

Nested Loop Left Join (cost=4.15..24.65 rows=1 width=873) (actual time=0.077..0.129 rows=2 loops=1)

8. 0.003 0.117 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.71..21.99 rows=1 width=872) (actual time=0.070..0.117 rows=2 loops=1)

9. 0.000 0.106 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.28..19.33 rows=1 width=860) (actual time=0.064..0.106 rows=2 loops=1)

10. 0.001 0.098 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.85..16.67 rows=1 width=725) (actual time=0.059..0.098 rows=2 loops=1)

11. 0.003 0.089 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.42..14.00 rows=1 width=659) (actual time=0.053..0.089 rows=2 loops=1)

12. 0.008 0.076 ↓ 2.0 2 1

Nested Loop (cost=1.99..11.34 rows=1 width=585) (actual time=0.044..0.076 rows=2 loops=1)

  • Join Filter: (order_addresses.order_id = order_application_users.order_id)
13. 0.005 0.054 ↓ 2.0 2 1

Nested Loop (cost=1.56..10.87 rows=1 width=543) (actual time=0.030..0.054 rows=2 loops=1)

14. 0.002 0.035 ↓ 2.0 2 1

Nested Loop (cost=0.99..9.99 rows=1 width=369) (actual time=0.021..0.035 rows=2 loops=1)

15. 0.019 0.019 ↑ 1.0 2 1

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

  • Index Cond: (id = ANY ('{26236857,27923671}'::integer[]))
16. 0.014 0.014 ↑ 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=69) (actual time=0.006..0.007 rows=1 loops=2)

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

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

  • Index Cond: (order_id = order_addresses.order_id)
18. 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.46 rows=1 width=62) (actual time=0.006..0.007 rows=1 loops=2)

  • Index Cond: (order_id = calculated_information.order_id)
19. 0.010 0.010 ↓ 0.0 0 2

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

  • Index Cond: (order_id = orders.id)
  • Filter: (is_current IS TRUE)
20. 0.008 0.008 ↓ 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=74) (actual time=0.004..0.004 rows=0 loops=2)

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

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=2)

  • Index Cond: (order_id = orders.id)
22. 0.008 0.008 ↓ 0.0 0 2

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

  • Index Cond: (order_id = orders.id)
23. 0.010 0.010 ↑ 1.0 1 2

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

  • Index Cond: (order_id = orders.id)
24. 0.008 0.008 ↓ 0.0 0 2

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

  • Index Cond: (order_id = orders.id)
25. 0.010 0.010 ↑ 1.0 1 2

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

  • Index Cond: (order_id = orders.id)
26. 0.030 0.030 ↑ 11.8 4 2

Index Scan using order_product_order_id_index on order_product (cost=0.56..4.79 rows=47 width=71) (actual time=0.014..0.015 rows=4 loops=2)

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

Index Scan using order_product_detail_pkey on order_product_detail products (cost=0.56..0.62 rows=1 width=164) (actual time=0.003..0.004 rows=1 loops=8)

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

Index Scan using order_product_topping_detail_order_product_id_index on order_product_topping_detail toppings (cost=0.43..1.00 rows=32 width=66) (actual time=0.002..0.002 rows=0 loops=8)

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

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

  • Index Cond: (order_product_id = order_product.id)