explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7D7V

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 1,044.163 ↑ 120.7 3 1

Nested Loop (cost=61,558.52..138,506.54 rows=362 width=205) (actual time=961.800..1,044.163 rows=3 loops=1)

  • Join Filter: ((c.design_id = side.design_id) AND (product_type_product_group_side.product_group_side_id = side.product_side_id))
  • Rows Removed by Join Filter: 3
2. 0.004 1,044.115 ↑ 574.0 1 1

Nested Loop (cost=61,558.09..137,987.16 rows=574 width=173) (actual time=961.761..1,044.115 rows=1 loops=1)

3. 0.014 1,044.100 ↑ 574.0 1 1

Hash Join (cost=61,557.67..137,619.76 rows=574 width=157) (actual time=961.747..1,044.100 rows=1 loops=1)

  • Hash Cond: (current_batch.featured_product_type_product_group_side_id = product_type_product_group_side.id)
4. 0.001 1,044.045 ↑ 574.0 1 1

Nested Loop (cost=61,551.93..137,606.13 rows=574 width=157) (actual time=961.692..1,044.045 rows=1 loops=1)

5. 0.011 1,044.035 ↑ 574.0 1 1

Nested Loop (cost=61,551.50..136,311.02 rows=574 width=157) (actual time=961.683..1,044.035 rows=1 loops=1)

6. 0.002 1,044.013 ↑ 574.0 1 1

Nested Loop (cost=61,551.07..136,038.61 rows=574 width=157) (actual time=961.663..1,044.013 rows=1 loops=1)

7. 0.002 1,043.999 ↑ 6,186.0 1 1

Nested Loop (cost=61,550.65..131,745.41 rows=6,186 width=142) (actual time=961.649..1,043.999 rows=1 loops=1)

8. 0.009 1,043.986 ↑ 6,186.0 1 1

Nested Loop (cost=61,550.22..127,166.93 rows=6,186 width=48) (actual time=961.637..1,043.986 rows=1 loops=1)

9. 69.220 1,043.961 ↑ 6,186.0 1 1

Hash Join (cost=61,549.80..123,877.70 rows=6,186 width=48) (actual time=961.614..1,043.961 rows=1 loops=1)

  • Hash Cond: (co.checkout_transaction = ct.id)
10. 409.943 409.943 ↓ 1.0 1,243,907 1

Seq Scan on customer_order co (cost=0.00..57,674.28 rows=1,237,328 width=48) (actual time=0.006..409.943 rows=1,243,907 loops=1)

11. 0.019 564.798 ↑ 6,215.0 1 1

Hash (cost=61,472.11..61,472.11 rows=6,215 width=16) (actual time=564.798..564.798 rows=1 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 65kB
12. 564.779 564.779 ↑ 6,215.0 1 1

Seq Scan on checkout_transaction ct (cost=0.00..61,472.11 rows=6,215 width=16) (actual time=530.720..564.779 rows=1 loops=1)

  • Filter: (((id)::character varying)::text = '53184086-73f2-44db-a8b8-4f1332e1b705'::text)
  • Rows Removed by Filter: 1271163
13. 0.016 0.016 ↑ 1.0 1 1

Index Scan using batch_pkey on batch b (cost=0.42..0.52 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = co.batch_id)
14. 0.011 0.011 ↑ 1.0 1 1

Index Scan using campaign_pkey on campaign c (cost=0.42..0.73 rows=1 width=126) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = b.campaign_id)
15. 0.012 0.012 ↑ 1.0 1 1

Index Scan using batch_pkey on batch current_batch (cost=0.42..0.68 rows=1 width=56) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = c.current_batch_id)
  • Filter: (((batch_end > now()) OR (batch_end <= now())) AND ((batch_end > now()) OR ((batch_end <= now()) AND (c.smart_launch_enabled IS TRUE))))
16. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using frontend_user_pkey on frontend_user u (cost=0.43..0.46 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = co.frontend_user_id)
  • Heap Fetches: 2
17. 0.009 0.009 ↑ 1.0 1 1

Index Scan using batch_product_pkey on batch_product bp (cost=0.43..2.25 rows=1 width=32) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (id = current_batch.featured_batch_product_id)
18. 0.021 0.041 ↑ 1.8 91 1

Hash (cost=3.66..3.66 rows=166 width=32) (actual time=0.041..0.041 rows=91 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
19. 0.020 0.020 ↑ 1.8 91 1

Seq Scan on product_type_product_group_side (cost=0.00..3.66 rows=166 width=32) (actual time=0.008..0.020 rows=91 loops=1)

20. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using design_pkey on design d (cost=0.42..0.63 rows=1 width=16) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = c.design_id)
  • Heap Fetches: 1
21. 0.012 0.012 ↑ 1.3 6 1

Index Scan using design_side_design_id_idx on design_side side (cost=0.43..0.77 rows=8 width=48) (actual time=0.008..0.012 rows=6 loops=1)

  • Index Cond: (design_id = d.id)