explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 56TO

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 12.256 ↓ 0.0 0 1

Sort (cost=371.21..371.37 rows=63 width=59) (actual time=12.256..12.256 rows=0 loops=1)

  • Sort Key: mpv.isactive DESC, mpv.validfrom DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.002 12.206 ↓ 0.0 0 1

Nested Loop (cost=112.26..369.33 rows=63 width=59) (actual time=12.206..12.206 rows=0 loops=1)

3. 0.001 12.204 ↓ 0.0 0 1

Nested Loop (cost=2.66..6.04 rows=1 width=12) (actual time=12.204..12.204 rows=0 loops=1)

  • Join Filter: (mp.c_taxcategory_id = tc.c_taxcategory_id)
4. 0.035 12.203 ↓ 0.0 0 1

Hash Join (cost=2.52..5.76 rows=1 width=24) (actual time=12.203..12.203 rows=0 loops=1)

  • Hash Cond: (tx.c_taxcategory_id = mp.c_taxcategory_id)
5. 12.127 12.127 ↑ 30.0 1 1

Seq Scan on c_tax tx (cost=0.00..3.11 rows=30 width=11) (actual time=12.127..12.127 rows=1 loops=1)

  • Filter: (isdefault = 'Y'::bpchar)
  • Rows Removed by Filter: 3
6. 0.002 0.041 ↓ 0.0 0 1

Hash (cost=2.51..2.51 rows=1 width=13) (actual time=0.041..0.041 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.039 0.039 ↓ 0.0 0 1

Index Scan using m_product_pkey on m_product mp (cost=0.29..2.51 rows=1 width=13) (actual time=0.039..0.039 rows=0 loops=1)

  • Index Cond: (m_product_id = '10050047'::numeric)
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_taxcategory_pkey on c_taxcategory tc (cost=0.14..0.27 rows=1 width=16) (never executed)

  • Index Cond: (c_taxcategory_id = tx.c_taxcategory_id)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=109.60..346.16 rows=44 width=61) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=108.54..298.42 rows=44 width=29) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.14..3.56 rows=1 width=12) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_pricelist mpl (cost=0.00..1.19 rows=1 width=13) (never executed)

  • Filter: (m_pricelist_id = '1000001'::numeric)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using c_currency_pkey on c_currency cr (cost=0.14..2.36 rows=1 width=9) (never executed)

  • Index Cond: (c_currency_id = mpl.c_currency_id)
14. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=108.40..294.42 rows=44 width=29) (never executed)

  • Hash Cond: (mpp.m_pricelist_version_id = mpv.m_pricelist_version_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using m_productprice_pkey on m_productprice mpp (cost=0.56..185.52 rows=166 width=20) (never executed)

  • Index Cond: (m_product_id = '10050047'::numeric)
16. 0.000 0.000 ↓ 0.0 0

Hash (cost=98.94..98.94 rows=712 width=23) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_pricelist_version mpv (cost=0.00..98.94 rows=712 width=23) (never executed)

  • Filter: (m_pricelist_id = '1000001'::numeric)
18. 0.000 0.000 ↓ 0.0 0

Subquery Scan on uomc (cost=1.05..1.07 rows=1 width=48) (never executed)

  • Filter: ((uomc.m_product_id = '10050047'::numeric) AND (uomc.m_product_id = mpp.m_product_id))
19. 0.000 0.000 ↓ 0.0 0

Limit (cost=1.05..1.06 rows=1 width=48) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.05..1.06 rows=1 width=48) (never executed)

  • Sort Key: c_uom_conversion.dividerate DESC
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_uom_conversion (cost=0.00..1.04 rows=1 width=48) (never executed)

  • Filter: ((isactive = 'Y'::bpchar) AND (m_product_id = mpp.m_product_id))