explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wHXu : Optimization for: plan #EsfA

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.031 2.534 ↑ 1.0 200 1

Limit (cost=3.92..290.90 rows=200 width=524) (actual time=0.129..2.534 rows=200 loops=1)

2. 0.797 2.503 ↑ 676.4 200 1

Nested Loop (cost=3.92..194,111.52 rows=135,273 width=524) (actual time=0.128..2.503 rows=200 loops=1)

3. 0.193 0.306 ↑ 712.8 200 1

Hash Join (cost=3.50..61,220.32 rows=142,563 width=158) (actual time=0.079..0.306 rows=200 loops=1)

  • Hash Cond: ((price.m_pricelist_version_id)::text = (prversion.m_pricelist_version_id)::text)
4. 0.051 0.051 ↑ 6,415.3 200 1

Seq Scan on m_productprice price (cost=0.00..54,979.68 rows=1,283,068 width=109) (actual time=0.009..0.051 rows=200 loops=1)

5. 0.009 0.062 ↓ 9.0 27 1

Hash (cost=3.46..3.46 rows=3 width=82) (actual time=0.061..0.062 rows=27 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
6. 0.018 0.053 ↓ 9.0 27 1

Hash Join (cost=1.11..3.46 rows=3 width=82) (actual time=0.030..0.053 rows=27 loops=1)

  • Hash Cond: ((prversion.m_pricelist_id)::text = (plist.m_pricelist_id)::text)
7. 0.015 0.015 ↑ 1.0 27 1

Seq Scan on m_pricelist_version prversion (cost=0.00..2.27 rows=27 width=164) (actual time=0.004..0.015 rows=27 loops=1)

8. 0.005 0.020 ↓ 8.0 8 1

Hash (cost=1.10..1.10 rows=1 width=82) (actual time=0.020..0.020 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.015 0.015 ↓ 8.0 8 1

Seq Scan on m_pricelist plist (cost=0.00..1.10 rows=1 width=82) (actual time=0.013..0.015 rows=8 loops=1)

  • Filter: (isactive = 'Y'::bpchar)
10. 1.400 1.400 ↑ 1.0 1 200

Index Scan using em_cg_m_product_id on m_product prod (cost=0.41..0.46 rows=1 width=192) (actual time=0.007..0.007 rows=1 loops=200)

  • Index Cond: ((m_product_id)::text = (price.m_product_id)::text)
  • Filter: ((isgeneric = 'N'::bpchar) AND (isactive = 'Y'::bpchar))
Planning time : 1.249 ms
Execution time : 2.657 ms