explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bAbV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=141,614.34..141,614.35 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=6,509.64..141,614.34 rows=1 width=0) (actual rows= loops=)

  • Hash Cond: (crmm.ID Campagne = (imp_import_campagne_crmm_b2c_1.imp_code_campagne_crm)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=3,254.82..138,359.51 rows=1 width=6) (actual rows= loops=)

  • Join Filter: (upper(crmm.imp_email) = upper(email.imp_email))
4. 0.000 0.000 ↓ 0.0

Seq Scan on campagne_adobe_b2c crmm (cost=0.00..67,016.60 rows=1 width=29) (actual rows= loops=)

  • Filter: ((imp_groupe_campagne_email)::text = 'pop_rel_tel'::text)
5. 0.000 0.000 ↓ 0.0

Materialize (cost=3,254.82..71,114.63 rows=11,414 width=23) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=3,254.82..71,057.56 rows=11,414 width=23) (actual rows= loops=)

  • Hash Cond: (email.ID Campagne = (imp_import_campagne_crmm_b2c.imp_code_campagne_crm)::text)
7. 0.000 0.000 ↓ 0.0

Seq Scan on campagne_adobe_b2c email (cost=0.00..67,016.60 rows=251,110 width=29) (actual rows= loops=)

  • Filter: ((imp_groupe_campagne_email)::text = 'pop_email'::text)
8. 0.000 0.000 ↓ 0.0

Hash (cost=3,254.81..3,254.81 rows=1 width=7) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,254.79..3,254.80 rows=1 width=7) (actual rows= loops=)

  • Group Key: imp_import_campagne_crmm_b2c.imp_code_campagne_crm
10. 0.000 0.000 ↓ 0.0

Seq Scan on imp_import_campagne_crmm_b2c (cost=0.00..3,000.63 rows=101,663 width=7) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=3,254.81..3,254.81 rows=1 width=7) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,254.79..3,254.80 rows=1 width=7) (actual rows= loops=)

  • Group Key: imp_import_campagne_crmm_b2c_1.imp_code_campagne_crm
13. 0.000 0.000 ↓ 0.0

Seq Scan on imp_import_campagne_crmm_b2c imp_import_campagne_crmm_b2c_1 (cost=0.00..3,000.63 rows=101,663 width=7) (actual rows= loops=)