explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bpg

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

Nested Loop Left Join (cost=14.05..128.74 rows=1 width=16,556) (actual time=0.008..0.008 rows=0 loops=1)

2. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.76..120.36 rows=1 width=16,523) (actual time=0.007..0.007 rows=0 loops=1)

3. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.34..107.49 rows=1 width=16,511) (actual time=0.007..0.007 rows=0 loops=1)

4. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.06..94.89 rows=1 width=16,483) (actual time=0.007..0.007 rows=0 loops=1)

5. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.93..86.58 rows=1 width=14,378) (actual time=0.007..0.007 rows=0 loops=1)

6. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.51..73.70 rows=1 width=13,303) (actual time=0.007..0.007 rows=0 loops=1)

7. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.37..72.44 rows=1 width=13,299) (actual time=0.007..0.007 rows=0 loops=1)

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

Nested Loop Left Join (cost=12.37..71.38 rows=1 width=12,243) (actual time=0.007..0.007 rows=0 loops=1)

9. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.23..67.58 rows=1 width=9,847) (actual time=0.007..0.007 rows=0 loops=1)

10. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.81..54.68 rows=1 width=9,815) (actual time=0.007..0.007 rows=0 loops=1)

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

Nested Loop Left Join (cost=11.81..53.41 rows=1 width=9,814) (actual time=0.007..0.007 rows=0 loops=1)

12. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.65..45.06 rows=1 width=9,802) (actual time=0.006..0.006 rows=0 loops=1)

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

Nested Loop Left Join (cost=11.65..40.96 rows=1 width=9,766) (actual time=0.006..0.006 rows=0 loops=1)

14. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.52..32.65 rows=1 width=7,698) (actual time=0.006..0.006 rows=0 loops=1)

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

Nested Loop (cost=11.52..31.64 rows=1 width=5,114) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (orders.id = order_addresses.order_id)
16. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=11.38..31.45 rows=1 width=3,558) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (orders.id = calculated_information.order_id)
17. 0.001 0.005 ↓ 0.0 0 1

Hash Join (cost=11.10..27.00 rows=1 width=2,391) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (orders.id = order_application_users.order_id)
18. 0.004 0.004 ↓ 0.0 0 1

Index Scan using orders_pkey on orders (cost=0.42..16.31 rows=2 width=315) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id = ANY ('{26236857,27923671}'::integer[]))
19. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.30..10.30 rows=30 width=2,076) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on order_application_users (cost=0.00..10.30 rows=30 width=2,076) (never executed)

21. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using order_addresses_order_id_address_id_unique on order_addresses (cost=0.14..0.17 rows=1 width=1,576) (never executed)

  • Index Cond: (order_id = calculated_information.order_id)
  • Filter: (is_current IS TRUE)
23. 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)
24. 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.30 rows=1 width=2,076) (never executed)

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::bigint[])))
  • Filter: (is_current IS TRUE)
25. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (order_id = ANY ('{26236857,27923671}'::integer[]))
26. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
27. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (order_id = ANY ('{26236857,27923671}'::integer[]))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using order_product_order_id_product_id_store_id_idx on order_product (cost=0.43..12.88 rows=1 width=36) (never executed)

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using order_product_detail_pkey on order_product_detail products (cost=0.14..3.79 rows=1 width=2,400) (never executed)

  • Index Cond: (order_product_id = order_product.id)
30. 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)

31. 0.000 0.000 ↓ 0.0 0

Index Scan using order_product_topping_order_product_id_idx on order_product_topping (cost=0.14..1.25 rows=1 width=8) (never executed)

  • Index Cond: (order_product_id = order_product.id)
32. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
33. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
34. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
35. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((order_id = orders.id) AND (order_id = ANY ('{26236857,27923671}'::integer[])))
36. 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)