explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aCzF

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

Update on stage_affiliate_transaction sat (cost=4.15..1,520,809.10 rows=79,113,821 width=167) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.15..1,520,809.10 rows=79,113,821 width=167) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using stage_affiliate_transaction__business_unit_name on stage_affiliate_transaction sat (cost=0.42..36,262.57 rows=206,365 width=136) (actual rows= loops=)

  • Index Cond: (business_unit_name = 'Easynews'::text)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_customer c (cost=3.72..7.18 rows=1 width=34) (actual rows= loops=)

  • Recheck Cond: ((((business_unit_name)::text = 'Easynews'::text) AND (sat.username = (customer_id)::text)) OR (btrim(lower(sat.subscriberid)) = btrim(lower(username))) OR (btrim(lower(sat.username)) = btrim(lower(username))))
  • Filter: ((business_unit_name)::text = 'Easynews'::text)
5. 0.000 0.000 ↓ 0.0

BitmapOr (cost=3.72..3.72 rows=4 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_customer__bu_cid (cost=0.00..1.01 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (((business_unit_name)::text = 'Easynews'::text) AND (sat.username = (customer_id)::text))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_customer__username (cost=0.00..1.35 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (btrim(lower(sat.subscriberid)) = btrim(lower(username)))
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_customer__username (cost=0.00..1.35 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (btrim(lower(sat.username)) = btrim(lower(username)))