explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gcer

Settings
# exclusive inclusive rows x rows loops node
1. 0.106 16,823.456 ↓ 0.0 0 1

Nested Loop (cost=23,732.04..80,560.26 rows=19 width=0) (actual time=16,823.456..16,823.456 rows=0 loops=1)

2. 0.092 0.145 ↓ 15.0 15 1

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

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

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

4. 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
5. 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
6. 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
7. 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