explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XvPR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 272.521 ↓ 5.0 5 1

Limit (cost=6,535.42..6,535.43 rows=1 width=71) (actual time=272.520..272.521 rows=5 loops=1)

2. 0.232 272.519 ↓ 5.0 5 1

Sort (cost=6,535.42..6,535.43 rows=1 width=71) (actual time=272.519..272.519 rows=5 loops=1)

  • Sort Key: rv_product_w_store_trl.name
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.047 272.287 ↓ 110.0 110 1

Subquery Scan on rv_product_w_store_trl (cost=2.65..6,535.41 rows=1 width=71) (actual time=4.459..272.287 rows=110 loops=1)

4. 3.424 272.240 ↓ 110.0 110 1

Nested Loop Left Join (cost=2.65..6,535.40 rows=1 width=2,261) (actual time=4.458..272.240 rows=110 loops=1)

5. 0.144 263.206 ↓ 110.0 110 1

Nested Loop Left Join (cost=2.23..6,526.71 rows=1 width=95) (actual time=3.560..263.206 rows=110 loops=1)

  • Join Filter: (pl.m_pricelist_id = plv.m_pricelist_id)
6. 0.049 262.732 ↓ 110.0 110 1

Nested Loop (cost=1.95..6,518.40 rows=1 width=95) (actual time=3.549..262.732 rows=110 loops=1)

7. 0.100 262.353 ↓ 110.0 110 1

Nested Loop Left Join (cost=1.67..6,510.09 rows=1 width=105) (actual time=3.539..262.353 rows=110 loops=1)

  • Join Filter: (SubPlan 1)
8. 0.407 261.923 ↓ 110.0 110 1

Nested Loop Left Join (cost=1.26..6,489.86 rows=1 width=114) (actual time=3.528..261.923 rows=110 loops=1)

  • Join Filter: (site.wstore_default_child_id = store.w_store_id)
  • Rows Removed by Join Filter: 3740
9. 0.209 261.186 ↓ 110.0 110 1

Nested Loop (cost=1.26..6,487.09 rows=1 width=114) (actual time=3.516..261.186 rows=110 loops=1)

10. 0.143 259.217 ↓ 110.0 110 1

Nested Loop Left Join (cost=1.26..6,484.57 rows=1 width=73) (actual time=3.482..259.217 rows=110 loops=1)

11. 0.127 249.944 ↓ 110.0 110 1

Nested Loop (cost=0.84..6,476.12 rows=1 width=58) (actual time=3.026..249.944 rows=110 loops=1)

  • Join Filter: (p.m_product_id = pt.m_product_id)
12. 0.175 249.157 ↓ 110.0 110 1

Nested Loop (cost=0.42..6,471.91 rows=1 width=28) (actual time=3.008..249.157 rows=110 loops=1)

13. 248.064 248.064 ↓ 17.0 153 1

Seq Scan on m_product p (cost=0.00..6,395.93 rows=9 width=15) (actual time=2.983..248.064 rows=153 loops=1)

  • Filter: ((globalsearchterms)::text ~~* '%RAJCI%'::text)
  • Rows Removed by Filter: 87201
14. 0.918 0.918 ↑ 1.0 1 153

Index Scan using m_product_w_store_pkey on m_product_w_store pws (cost=0.42..8.44 rows=1 width=13) (actual time=0.006..0.006 rows=1 loops=153)

  • Index Cond: ((m_product_id = p.m_product_id) AND (w_store_id = '1000049'::numeric))
  • Filter: (((wstorevisibility)::text = ANY ('{CTS,CAT}'::text[])) AND (isactive = 'Y'::bpchar))
15. 0.660 0.660 ↑ 1.0 1 110

Index Scan using m_product_istranslated on m_product_trl pt (cost=0.42..4.20 rows=1 width=42) (actual time=0.006..0.006 rows=1 loops=110)

  • Index Cond: ((m_product_id = pws.m_product_id) AND ((ad_language)::text = 'sk_SK'::text))
16. 9.130 9.130 ↑ 1.0 1 110

Index Scan using m_product_po_isactive on m_product_po po (cost=0.42..8.44 rows=1 width=21) (actual time=0.083..0.083 rows=1 loops=110)

  • Index Cond: (m_product_id = p.m_product_id)
  • Filter: (iscurrentvendor = 'Y'::bpchar)
17. 1.760 1.760 ↑ 1.0 1 110

Seq Scan on w_store site (cost=0.00..2.51 rows=1 width=64) (actual time=0.015..0.016 rows=1 loops=110)

  • Filter: ((w_store_id = '1000049'::numeric) AND (m_pricelist_id = '1004203'::numeric))
  • Rows Removed by Filter: 33
18. 0.330 0.330 ↑ 1.0 34 110

Seq Scan on w_store store (cost=0.00..2.34 rows=34 width=32) (actual time=0.001..0.003 rows=34 loops=110)

19. 0.330 0.330 ↓ 0.0 0 110

Index Only Scan using c_classificationistance_record on c_classificationinstance cli (cost=0.42..11.64 rows=2 width=13) (actual time=0.003..0.003 rows=0 loops=110)

  • Index Cond: (record_id = p.m_product_id)
  • Heap Fetches: 0
20.          

SubPlan (forNested Loop Left Join)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using c_classification_key on c_classification cl_1 (cost=0.28..8.30 rows=1 width=7) (never executed)

  • Index Cond: (cli.c_classification_id = c_classification_id)
  • Filter: (c_vocabulary_id = store.c_vocabulary_id)
22. 0.330 0.330 ↑ 1.0 1 110

Index Only Scan using m_pricelist_m_pricelist_id_key on m_pricelist pl (cost=0.28..8.30 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=110)

  • Index Cond: (m_pricelist_id = '1004203'::numeric)
  • Heap Fetches: 110
23. 0.330 0.330 ↑ 1.0 1 110

Index Scan using m_pricelist_version_validfrom on m_pricelist_version plv (cost=0.28..8.30 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=110)

  • Index Cond: (m_pricelist_id = '1004203'::numeric)
24. 5.610 5.610 ↑ 1.0 1 110

Index Scan using m_productprice_unique_idx on m_productprice pp (cost=0.42..8.44 rows=1 width=17) (actual time=0.051..0.051 rows=1 loops=110)

  • Index Cond: ((m_pricelist_version_id = plv.m_pricelist_version_id) AND (p.m_product_id = m_product_id))