explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SdSf

Settings
# exclusive inclusive rows x rows loops node
1. 788.129 3,999.955 ↓ 1.1 1,039,462 1

GroupAggregate (cost=1,131.95..547,042.58 rows=962,300 width=31) (actual time=33.198..3,999.955 rows=1,039,462 loops=1)

  • Group Key: crm_lead.email_from
2. 1,042.818 3,211.826 ↑ 1.4 11,012,761 1

Merge Join (cost=1,131.95..460,734.07 rows=15,337,102 width=23) (actual time=14.839..3,211.826 rows=11,012,761 loops=1)

  • Merge Cond: ((crm_lead.email_from)::text = (openerp_enterprise_database.company_email)::text)
3. 366.808 366.808 ↑ 1.0 2,487,790 1

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.043..366.808 rows=2,487,790 loops=1)

  • Heap Fetches: 65
4. 957.014 1,802.200 ↓ 1.6 12,215,646 1

Materialize (cost=0.56..194,011.02 rows=7,573,969 width=22) (actual time=0.051..1,802.200 rows=12,215,646 loops=1)

5. 845.186 845.186 ↑ 1.3 5,958,461 1

Index Only Scan using openerp_enterprise_database_email_from_ids on openerp_enterprise_database (cost=0.56..175,076.09 rows=7,573,969 width=22) (actual time=0.046..845.186 rows=5,958,461 loops=1)

  • Heap Fetches: 353995
Planning time : 2.142 ms
Execution time : 4,042.138 ms