explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Jrf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 168,745.781 168,745.781 ↓ 5.0 10 1

CTE Scan on with_articles wa (cost=12,371.36..12,373.92 rows=2 width=807) (actual time=168,745.731..168,745.781 rows=10 loops=1)

2.          

CTE with_articles

3. 0.017 168,745.730 ↓ 5.0 10 1

Limit (cost=12,371.35..12,371.36 rows=2 width=2,659) (actual time=168,745.709..168,745.730 rows=10 loops=1)

4. 8.175 168,745.713 ↓ 5.0 10 1

Sort (cost=12,371.35..12,371.36 rows=2 width=2,659) (actual time=168,745.706..168,745.713 rows=10 loops=1)

  • Sort Key: va.article_no, va.article_id
  • Sort Method: top-N heapsort Memory: 32kB
5. 6.953 168,737.538 ↓ 638.0 1,276 1

Nested Loop Left Join (cost=10,186.55..12,371.34 rows=2 width=2,659) (actual time=348.122..168,737.538 rows=1,276 loops=1)

6. 6.243 168,712.721 ↓ 1,276.0 1,276 1

Nested Loop (cost=10,186.55..12,366.60 rows=1 width=174) (actual time=348.103..168,712.721 rows=1,276 loops=1)

7. 10.202 168,697.546 ↓ 1,276.0 1,276 1

Nested Loop Left Join (cost=10,186.55..12,366.32 rows=1 width=171) (actual time=348.089..168,697.546 rows=1,276 loops=1)

8. 38,513.287 168,663.100 ↓ 1,276.0 1,276 1

Nested Loop Semi Join (cost=10,186.55..12,366.03 rows=1 width=163) (actual time=348.067..168,663.100 rows=1,276 loops=1)

  • Join Filter: (va.article_id = atag.article_id)
9. 7.666 183.138 ↓ 1,277.0 1,277 1

Nested Loop (cost=10,124.10..10,298.53 rows=1 width=171) (actual time=140.313..183.138 rows=1,277 loops=1)

10. 5.588 163.979 ↓ 1,277.0 1,277 1

Nested Loop (cost=10,124.10..10,290.24 rows=1 width=8) (actual time=140.304..163.979 rows=1,277 loops=1)

11. 4.045 143.067 ↓ 63.9 1,277 1

HashAggregate (cost=10,124.10..10,124.30 rows=20 width=4) (actual time=140.284..143.067 rows=1,277 loops=1)

12. 3.377 139.022 ↓ 63.9 1,277 1

HashAggregate (cost=10,123.55..10,123.85 rows=20 width=34) (actual time=137.887..139.022 rows=1,277 loops=1)

13. 6.225 135.645 ↓ 76.3 1,527 1

Nested Loop (cost=2,056.60..10,123.40 rows=20 width=34) (actual time=13.920..135.645 rows=1,527 loops=1)

14. 5.460 123.312 ↓ 76.3 1,527 1

Nested Loop (cost=2,056.60..9,970.29 rows=20 width=38) (actual time=13.907..123.312 rows=1,527 loops=1)

15. 41.340 108.690 ↓ 16.2 1,527 1

Hash Join (cost=2,056.60..9,517.11 rows=94 width=12) (actual time=13.889..108.690 rows=1,527 loops=1)

  • Hash Cond: (o.object_id = otf.object_id)
16. 54.841 64.241 ↓ 1.0 46,888 1

Bitmap Heap Scan on objects o (cost=1,465.73..8,588.92 rows=44,851 width=8) (actual time=10.034..64.241 rows=46,888 loops=1)

  • Recheck Cond: ((object_type_handle)::text = 'article'::text)
  • Filter: ((object_state_handle)::text <> 'deleted'::text)
17. 9.400 9.400 ↓ 1.7 77,493 1

Bitmap Index Scan on ix_objects_object_type_handle (cost=0.00..1,454.52 rows=45,079 width=0) (actual time=9.400..9.400 rows=77,493 loops=1)

  • Index Cond: ((object_type_handle)::text = 'article'::text)
18. 1.368 3.109 ↓ 1.0 1,527 1

Hash (cost=572.32..572.32 rows=1,484 width=4) (actual time=3.109..3.109 rows=1,527 loops=1)

19. 1.478 1.741 ↓ 1.0 1,527 1

Bitmap Heap Scan on objects_to_frontends otf (cost=71.77..572.32 rows=1,484 width=4) (actual time=0.278..1.741 rows=1,527 loops=1)

  • Recheck Cond: ((frontend_handle)::text = 'shop_collectors'::text)
20. 0.263 0.263 ↓ 1.0 1,536 1

Bitmap Index Scan on fk_objects_to_frontends_frontend_handle (cost=0.00..71.40 rows=1,484 width=0) (actual time=0.263..0.263 rows=1,536 loops=1)

  • Index Cond: ((frontend_handle)::text = 'shop_collectors'::text)
21. 9.162 9.162 ↑ 2.0 1 1,527

Index Scan using fk_article_data_lang_object_revision_id on article_data_lang adl (cost=0.00..4.80 rows=2 width=34) (actual time=0.005..0.006 rows=1 loops=1,527)

  • Index Cond: (adl.object_revision_id = o.object_revision_id)
  • Filter: (adl.language_id = 132)
22. 6.108 6.108 ↑ 1.0 1 1,527

Index Scan using pk_mv_v_articles on mv_v_articles va (cost=0.00..7.64 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1,527)

  • Index Cond: (va.article_id = otf.object_id)
23. 15.324 15.324 ↑ 1.0 1 1,277

Index Scan using fk_objects_to_frontends_object_id on objects_to_frontends obf (cost=0.00..8.28 rows=1 width=4) (actual time=0.008..0.012 rows=1 loops=1,277)

  • Index Cond: (obf.object_id = (max(va.article_id)))
  • Filter: ((obf.frontend_handle)::text = 'shop_collectors'::text)
24. 11.493 11.493 ↑ 1.0 1 1,277

Index Scan using pk_mv_v_articles on mv_v_articles va (cost=0.00..8.28 rows=1 width=163) (actual time=0.007..0.009 rows=1 loops=1,277)

  • Index Cond: (va.article_id = obf.object_id)
25. 83,368.796 129,966.675 ↑ 1.2 37,838 1,277

Hash Join (cost=62.45..1,535.39 rows=44,676 width=4) (actual time=0.011..101.775 rows=37,838 loops=1,277)

  • Hash Cond: (atag.article_group_id = mvagt.article_group_id)
26. 46,596.453 46,596.453 ↑ 1.2 37,838 1,277

Seq Scan on articles_to_article_groups atag (cost=0.00..858.65 rows=44,676 width=8) (actual time=0.008..36.489 rows=37,838 loops=1,277)

  • Filter: ((article_group_assignment_type_handle)::text = 'default'::text)
27. 0.647 1.426 ↑ 2.0 709 1

Hash (cost=44.73..44.73 rows=1,418 width=4) (actual time=1.426..1.426 rows=709 loops=1)

28. 0.779 0.779 ↑ 2.0 709 1

Seq Scan on mv_v_article_groups_tree mvagt (cost=0.00..44.73 rows=1,418 width=4) (actual time=0.018..0.779 rows=709 loops=1)

  • Filter: (tree_sort ~~ '01%'::text)
29. 24.244 24.244 ↑ 1.0 1 1,276

Index Scan using pk_packaging_units_lang on packaging_units_lang pul (cost=0.00..0.27 rows=1 width=13) (actual time=0.018..0.019 rows=1 loops=1,276)

  • Index Cond: (((va.packaging_unit_handle)::text = (pul.packaging_unit_handle)::text) AND (pul.language_id = 132))
30. 8.932 8.932 ↑ 1.0 1 1,276

Index Scan using fk_taxes_tax_id_object_state_handle on taxes t (cost=0.00..0.27 rows=1 width=11) (actual time=0.006..0.007 rows=1 loops=1,276)

  • Index Cond: (t.tax_id = va.vat_tax_id)
  • Filter: ((t.object_state_handle)::text <> 'deleted'::text)
31. 17.864 17.864 ↑ 2.0 1 1,276

Index Scan using fk_article_data_lang_object_revision_id on article_data_lang adl (cost=0.00..4.72 rows=2 width=2,489) (actual time=0.012..0.014 rows=1 loops=1,276)

  • Index Cond: (va.object_revision_id = adl.object_revision_id)
  • Filter: (adl.language_id = 132)