explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11qN

Settings
# exclusive inclusive rows x rows loops node
1. 168.518 4,166.379 ↓ 1.1 1,039,462 1

Finalize GroupAggregate (cost=1,699,704.64..2,188,985.52 rows=962,300 width=31) (actual time=1,813.432..4,166.379 rows=1,039,462 loops=1)

  • Group Key: crm_lead.email_from
2. 501.540 3,997.861 ↑ 1.4 1,348,678 1

Gather Merge (cost=1,699,704.64..2,169,739.52 rows=1,924,600 width=31) (actual time=1,813.408..3,997.861 rows=1,348,678 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 284.635 3,496.321 ↑ 2.1 449,559 3 / 3

Partial GroupAggregate (cost=1,698,704.62..1,946,592.91 rows=962,300 width=31) (actual time=1,794.671..3,496.321 rows=449,559 loops=3)

  • Group Key: crm_lead.email_from
4. 537.962 3,211.686 ↑ 1.8 3,670,920 3 / 3

Merge Join (cost=1,698,704.62..1,903,846.04 rows=6,624,774 width=23) (actual time=1,790.818..3,211.686 rows=3,670,920 loops=3)

  • Merge Cond: ((openerp_enterprise_database.company_email)::text = (crm_lead.email_from)::text)
5. 934.151 1,956.792 ↑ 1.6 1,986,154 3 / 3

Sort (cost=1,697,457.32..1,705,636.15 rows=3,271,533 width=22) (actual time=1,786.341..1,956.792 rows=1,986,154 loops=3)

  • Sort Key: openerp_enterprise_database.company_email
  • Sort Method: external merge Disk: 70504kB
6. 1,022.641 1,022.641 ↑ 1.3 2,524,656 3 / 3

Parallel Seq Scan on openerp_enterprise_database (cost=0.00..1,305,112.33 rows=3,271,533 width=22) (actual time=0.037..1,022.641 rows=2,524,656 loops=3)

7. 268.559 716.932 ↓ 2.2 5,570,803 3 / 3

Materialize (cost=0.56..100,370.90 rows=2,509,620 width=23) (actual time=0.036..716.932 rows=5,570,803 loops=3)

8. 448.373 448.373 ↑ 1.0 2,487,784 3 / 3

Index Only Scan using crm_lead_email_from_index on crm_lead (cost=0.56..94,096.85 rows=2,509,620 width=23) (actual time=0.034..448.373 rows=2,487,784 loops=3)

  • Heap Fetches: 65