explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CE5a

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 245,606.274 ↓ 1.6 470 1

Hash Left Join (cost=96,077.73..7,398,035.93 rows=293 width=68) (actual time=214,566.756..245,606.274 rows=470 loops=1)

  • Hash Cond: (se.property_id = pd.property_id)
2. 155.305 245,742.890 ↓ 1.6 470 1

Gather (cost=96,075.48..7,398,032.56 rows=293 width=68) (actual time=214,560.319..245,742.890 rows=470 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 245,336.538 245,587.585 ↓ 1.3 157 3 / 3

Parallel Bitmap Heap Scan on system_emails se (cost=95,075.48..7,397,003.26 rows=122 width=68) (actual time=214,157.465..245,587.585 rows=157 loops=3)

  • Recheck Cond: (cid = 12859)
  • Rows Removed by Index Recheck: 6928020
  • Filter: ((applicant_id IS NOT NULL) AND (customer_id IS NULL) AND (company_employee_id IS NULL) AND ((sent_on)::date >= '2019-12-30'::date) AND ((sent_on)::date <= '2020-01-05'::date) AND ((system_email_type_id = 102) OR ((system_email_type_id = 62) AND (scheduled_email_id IS NOT NULL))))
  • Rows Removed by Filter: 1066973
  • Heap Blocks: exact=358731 lossy=272370
4. 251.047 251.047 ↑ 2.1 3,234,219 1 / 3

Bitmap Index Scan on idx_system_emails_cid (cost=0.00..95,075.40 rows=6,839,311 width=0) (actual time=753.140..753.140 rows=3,234,219 loops=1)

  • Index Cond: (cid = 12859)
5. 0.005 0.017 ↑ 1.0 20 1

Hash (cost=1.60..1.60 rows=20 width=4) (actual time=0.017..0.017 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.012 0.012 ↑ 1.0 20 1

Seq Scan on properties_data pd (cost=0.00..1.60 rows=20 width=4) (actual time=0.009..0.012 rows=20 loops=1)

Planning time : 20.624 ms