explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yqVM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 15,960.633 ↓ 0.0 0 1

Nested Loop (cost=80,560.83..80,608.85 rows=55 width=33) (actual time=15,960.633..15,960.633 rows=0 loops=1)

2. 0.001 15,960.633 ↓ 0.0 0 1

HashAggregate (cost=80,560.41..80,560.50 rows=9 width=33) (actual time=15,960.633..15,960.633 rows=0 loops=1)

3. 0.098 15,960.632 ↓ 0.0 0 1

Nested Loop (cost=23,734.85..80,560.27 rows=55 width=33) (actual time=15,960.632..15,960.632 rows=0 loops=1)

4. 0.029 0.099 ↓ 15.0 15 1

HashAggregate (cost=5.54..5.54 rows=1 width=33) (actual time=0.077..0.099 rows=15 loops=1)

5. 0.026 0.070 ↓ 15.0 15 1

Hash Join (cost=2.73..5.53 rows=1 width=33) (actual time=0.037..0.070 rows=15 loops=1)

  • Hash Cond: ((m_pricelist_version.m_pricelist_id)::text = (m_pricelist.m_pricelist_id)::text)
6. 0.016 0.016 ↑ 1.0 58 1

Seq Scan on m_pricelist_version (cost=0.00..2.58 rows=58 width=66) (actual time=0.003..0.016 rows=58 loops=1)

7. 0.006 0.028 ↓ 15.0 15 1

Hash (cost=2.71..2.71 rows=1 width=33) (actual time=0.028..0.028 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.022 0.022 ↓ 15.0 15 1

Seq Scan on m_pricelist (cost=0.00..2.71 rows=1 width=33) (actual time=0.011..0.022 rows=15 loops=1)

  • Filter: (em_dp_ispricing = 'Y'::bpchar)
  • Rows Removed by Filter: 42
9. 12,566.370 15,960.435 ↓ 0.0 0 15

Bitmap Heap Scan on m_productprice (cost=23,729.32..80,554.17 rows=55 width=66) (actual time=1,064.029..1,064.029 rows=0 loops=15)

  • Recheck Cond: ((m_pricelist_version_id)::text = (m_pricelist_version.m_pricelist_version_id)::text)
  • Filter: (updated >= now())
  • Rows Removed by Filter: 1000758
10. 3,394.065 3,394.065 ↑ 1.0 1,000,993 15

Bitmap Index Scan on m_productprice_pricelist_ve_un (cost=0.00..23,729.30 rows=1,006,223 width=0) (actual time=226.271..226.271 rows=1,000,993 loops=15)

  • Index Cond: ((m_pricelist_version_id)::text = (m_pricelist_version.m_pricelist_version_id)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using m_product_key on m_product prod (cost=0.43..5.36 rows=1 width=33) (never executed)

  • Index Cond: (m_product_id = (m_productprice.m_product_id)::text)
  • Heap Fetches: 0
Total runtime : 15,960.707 ms