explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n6ew : Optimization for: Optimization for: plan #EsfA; plan #wHXu

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.025 1.824 ↑ 1.0 200 1

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

2. 0.590 1.799 ↑ 676.4 200 1

Nested Loop (cost=3.92..194,123.89 rows=135,284 width=524) (actual time=0.091..1.799 rows=200 loops=1)

3. 0.129 0.209 ↑ 712.9 200 1

Hash Join (cost=3.50..61,221.91 rows=142,575 width=158) (actual time=0.056..0.209 rows=200 loops=1)

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

Seq Scan on m_productprice price (cost=0.00..54,980.75 rows=1,283,175 width=109) (actual time=0.008..0.038 rows=200 loops=1)

5. 0.008 0.042 ↓ 9.0 27 1

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

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

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

  • Hash Cond: ((prversion.m_pricelist_id)::text = (plist.m_pricelist_id)::text)
7. 0.007 0.007 ↑ 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.007 rows=27 loops=1)

8. 0.005 0.012 ↓ 8.0 8 1

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

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

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

  • Filter: (isactive = 'Y'::bpchar)
10. 1.000 1.000 ↑ 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.005..0.005 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.235 ms
Execution time : 1.925 ms