explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EMVs

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

Hash Left Join (cost=156,503.87..353,086.92 rows=109,079 width=296) (actual rows= loops=)

  • Hash Cond: (bf_orn_incident.created_by_account_id = bf_orn_account.account_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=154,891.84..345,624.69 rows=109,079 width=131) (actual rows= loops=)

  • Hash Cond: (bf_orn_incident.contact_id = bf_orn_contact.contact_id)
  • Filter: ((CASE WHEN (bf_orn_contact.contact_account_id IS NOT NULL) THEN bf_orn_contact.contact_account_id ELSE CASE WHEN ((bf_orn_contact.customer_id)::text ~~ '%@%'::text) THEN NULL::character varying ELSE bf_orn_contact.customer_id END END IS NOT NULL) AND ((CASE WHEN (bf_orn_contact.contact_account_id IS NOT NULL) THEN bf_orn_contact.contact_account_id ELSE CASE WHEN ((bf_orn_contact.customer_id)::text ~~ '%@%'::text) THEN NULL::character varying ELSE bf_orn_contact.customer_id END END)::text <> '-1'::text))
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bf_orn_incident (cost=7,090.84..170,205.97 rows=110,178 width=114) (actual rows= loops=)

  • Recheck Cond: (date_created >= date_trunc('month'::text, (now() - '1 mon'::interval)))
  • Filter: ((date_closed IS NOT NULL) AND ((source_level_2)::text <> ALL ('{"Contact Editor","Incident Editor","Techmail - Outreach Mailbox"}'::text[])))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_bf_orn_incident_date_created (cost=0.00..7,063.30 rows=120,382 width=0) (actual rows= loops=)

  • Index Cond: (date_created >= date_trunc('month'::text, (now() - '1 mon'::interval)))
5. 0.000 0.000 ↓ 0.0

Hash (cost=88,042.33..88,042.33 rows=3,090,533 width=25) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on bf_orn_contact (cost=0.00..88,042.33 rows=3,090,533 width=25) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,365.35..1,365.35 rows=19,735 width=19) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on bf_orn_account (cost=0.00..1,365.35 rows=19,735 width=19) (actual rows= loops=)