explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RVRV

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 211.589 ↓ 1.3 108 1

Nested Loop (cost=0.75..36.41 rows=82 width=8) (actual time=211.536..211.589 rows=108 loops=1)

2. 0.009 171.470 ↓ 3.0 3 1

HashAggregate (cost=0.47..0.48 rows=1 width=8) (actual time=171.466..171.470 rows=3 loops=1)

  • Group Key: retrieve_person_linked_recipients.recipient_id
3. 171.461 171.461 ↓ 3.0 3 1

Function Scan on retrieve_person_linked_recipients (cost=0.03..0.46 rows=1 width=8) (actual time=171.460..171.461 rows=3 loops=1)

  • Filter: ((org_id = 200189) AND (((recipient_cat)::text <> 'GROUP'::text) OR ((grp_association)::text <> 'supervisor'::text)))
4. 40.101 40.101 ↑ 2.3 36 3

Index Only Scan using ev_targeted_recipients_pkey on ev_targeted_recipients (cost=0.29..35.11 rows=82 width=16) (actual time=13.358..13.367 rows=36 loops=3)

  • Index Cond: ((org_id = 200189) AND (recipient_id = retrieve_person_linked_recipients.recipient_id))
  • Heap Fetches: 108
Planning time : 24.160 ms
Execution time : 212.238 ms