explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2GPX

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 4.288 ↓ 6.0 6 1

Nested Loop (cost=43.41..3,971.45 rows=1 width=72) (actual time=0.306..4.288 rows=6 loops=1)

2. 4.129 4.235 ↓ 9.0 18 1

Bitmap Heap Scan on recipients r (cost=42.98..3,964.54 rows=2 width=26) (actual time=0.287..4.235 rows=18 loops=1)

  • Recheck Cond: ((org_id = 200332) AND (deleted_id = '-1'::integer))
  • Filter: ((upper((target_name)::text) ~~ '%%SIDNEY.SILVA%%'::text) OR (upper((target_name)::text) ~~ '%%CHRIS.WEEDA%%'::text) OR (upper((target_name)::text) ~~ '%%KIM.LEONARD%%'::text) OR (upper((target_name)::text) ~~ '%%ERIK.PETERS%%'::text) OR (upper((target_name)::text) ~~ '%%COSTA.MOREIN%%'::text) OR (upper((target_name)::text) ~~ '%%DORON.HARED%%'::text))
  • Rows Removed by Filter: 868
  • Heap Blocks: exact=539
3. 0.106 0.106 ↑ 3.0 891 1

Bitmap Index Scan on idx_recipients_del_org_id_cat (cost=0.00..42.98 rows=2,674 width=0) (actual time=0.106..0.106 rows=891 loops=1)

  • Index Cond: (org_id = 200332)
4. 0.036 0.036 ↓ 0.0 0 18

Index Scan using person_person_id_desc_ufn_uln_fbi on persons p (cost=0.42..3.45 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=18)

  • Index Cond: (person_id = r.recipient_id)
  • Filter: ((status)::text = 'ACTIVE'::text)
Planning time : 0.951 ms
Execution time : 4.363 ms