explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TSfF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16,717.680 ↓ 0.0 0 1

Nested Loop (cost=70,041.24..70,089.41 rows=48 width=33) (actual time=16,717.680..16,717.680 rows=0 loops=1)

2. 0.002 16,717.680 ↓ 0.0 0 1

HashAggregate (cost=70,040.82..70,040.91 rows=9 width=33) (actual time=16,717.680..16,717.680 rows=0 loops=1)

3. 0.123 16,717.678 ↓ 0.0 0 1

Nested Loop (cost=15,389.96..70,040.70 rows=48 width=33) (actual time=16,717.678..16,717.678 rows=0 loops=1)

4. 0.031 0.100 ↓ 15.0 15 1

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

5. 0.026 0.069 ↓ 15.0 15 1

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

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

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

7. 0.009 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.019 0.019 ↓ 15.0 15 1

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

  • Filter: (em_dp_ispricing = 'Y'::bpchar)
  • Rows Removed by Filter: 42
9. 13,385.670 16,717.455 ↓ 0.0 0 15

Bitmap Heap Scan on m_productprice (cost=15,384.42..70,034.67 rows=48 width=66) (actual time=1,114.497..1,114.497 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,331.785 3,331.785 ↓ 1.1 1,000,759 15

Bitmap Index Scan on em_dp_pricelist_version (cost=0.00..15,384.41 rows=881,957 width=0) (actual time=222.119..222.119 rows=1,000,759 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.38 rows=1 width=33) (never executed)

  • Index Cond: (m_product_id = (m_productprice.m_product_id)::text)
  • Heap Fetches: 0
12. 0.003 0.027 ↓ 15.0 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
13. 0.024 0.024 ↓ 15.0 15 1

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

  • Filter: (em_dp_ispricing = 'Y'::bpchar)
  • Rows Removed by Filter: 42
14. 12,682.905 16,823.205 ↓ 0.0 0 15

Bitmap Heap Scan on m_productprice (cost=23,729.32..80,554.17 rows=55 width=33) (actual time=1,121.547..1,121.547 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
15. 4,140.300 4,140.300 ↑ 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=276.020..276.020 rows=1,000,993 loops=15)

  • Index Cond: ((m_pricelist_version_id)::text = (m_pricelist_version.m_pricelist_version_id)::text)
Total runtime : 16,823.497 ms