explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmcR

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

Aggregate (cost=112,267.68..112,267.69 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=6,660.66..112,267.68 rows=1 width=0) (actual rows= loops=)

  • Hash Cond: (campagne_adobe_b2c.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,405.84..109,012.86 rows=1 width=6) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on campagne_adobe_b2c (cost=0.00..66,506.01 rows=1 width=29) (actual rows= loops=)

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

Hash Semi Join (cost=3,405.84..22,956.06 rows=56 width=23) (actual rows= loops=)

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

Bitmap Heap Scan on campagne_adobe_b2c campagne_adobe_b2c_1 (cost=151.02..19,697.41 rows=1,221 width=29) (actual rows= loops=)

  • Recheck Cond: (upper(imp_email) = upper(campagne_adobe_b2c.imp_email))
  • Filter: ((imp_groupe_campagne_email)::text = 'pop_email'::text)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_campagne_adobe_b2c_upper_imp_email (cost=0.00..150.71 rows=7,237 width=0) (actual rows= loops=)

  • Index Cond: (upper(imp_email) = upper(campagne_adobe_b2c.imp_email))
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=)