explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GYHI

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

Aggregate (cost=61,926.94..61,926.95 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=8,151.90..61,926.94 rows=1 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,896.66..56,865.48 rows=1 width=23) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

  • Group Key: (ANY_subquery.ID Campagne)::text
5. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=3,254.79..3,254.81 rows=1 width=7) (actual rows= loops=)

6. 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
7. 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=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on campagne_adobe_b2c crmm (cost=1,641.85..53,610.65 rows=1 width=29) (actual rows= loops=)

  • Recheck Cond: (ID Campagne = (ANY_subquery.ID Campagne)::text)
  • Filter: ((imp_groupe_campagne_email)::text = 'pop_rel_tel'::text)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_campagne_adobe_b2c_campagne_upper_imp_email (cost=0.00..1,641.85 rows=65,789 width=0) (actual rows= loops=)

  • Index Cond: (ID Campagne = (ANY_subquery.ID Campagne)::text)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,255.24..4,158.07 rows=56 width=23) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

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

  • Group Key: (ANY_subquery_1.ID Campagne)::text
12. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_1 (cost=3,254.79..3,254.81 rows=1 width=7) (actual rows= loops=)

13. 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
14. 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=)

15. 0.000 0.000 ↓ 0.0

Index Scan using idx_campagne_adobe_b2c_campagne_upper_imp_email on campagne_adobe_b2c email (cost=0.43..902.69 rows=56 width=29) (actual rows= loops=)

  • Index Cond: ((ID Campagne = (ANY_subquery_1.ID Campagne)::text) AND (upper(imp_email) = upper(crmm.imp_email)))
  • Filter: ((imp_groupe_campagne_email)::text = 'pop_email'::text)