explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uY5H : Optimization for: plan #Hgl5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.135 83,989.601 ↑ 1.0 1 1

Aggregate (cost=666.15..666.16 rows=1 width=8) (actual time=83,989.601..83,989.601 rows=1 loops=1)

2. 0.000 83,989.466 ↓ 4.0 4 1

Nested Loop Anti Join (cost=288.36..666.15 rows=1 width=8) (actual time=83,989.374..83,989.466 rows=4 loops=1)

  • Join Filter: ((audit.audit_ev_discriminator)::text = 'AUDIT_NTFN_EVS'::text)
3. 16.356 83,989.350 ↓ 4.0 4 1

Hash Join (cost=287.79..657.86 rows=1 width=31) (actual time=83,989.295..83,989.350 rows=4 loops=1)

  • Hash Cond: (audit.ev_id = ev.ev_id)
4. 83,949.862 83,949.862 ↓ 9.2 5,204 1

Index Only Scan using aea_recipient_id_aed_aet_cd_pidx on audit_evs_all audit (cost=0.56..369.14 rows=566 width=31) (actual time=42,820.800..83,949.862 rows=5,204 loops=1)

  • Index Cond: (recipient_id = '215564'::bigint)
  • Heap Fetches: 8,929
5. 0.208 23.132 ↑ 1.1 758 1

Hash (cost=277.02..277.02 rows=817 width=8) (actual time=23.132..23.132 rows=758 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
6. 22.924 22.924 ↑ 1.1 758 1

Index Scan using idx_evs_status on evs ev (cost=0.42..277.02 rows=817 width=8) (actual time=1.063..22.924 rows=758 loops=1)

  • Index Cond: ((status)::text = ANY ('{ACTIVE,SUSPENDED}'::text[]))
  • Filter: ((system_message_type IS NULL) OR ((system_message_type)::text <> ALL ('{ON_CALL_START_SHIFT,DEVICE_VALIDATION}'::text[])))
  • Rows Removed by Filter: 1
7. 0.120 0.120 ↓ 0.0 0 4

Index Only Scan using idx_audit_evs_all_niaaet on audit_evs_all inneraudit (cost=0.57..8.26 rows=13 width=8) (actual time=0.030..0.030 rows=0 loops=4)

  • Index Cond: ((ntfn_id = audit.ntfn_id) AND (ap_audit_ev_type = ANY ('{DELINK_PERSON_NOTIFICATION,DELINK_GROUP_NOTIFICATION}'::text[])))
  • Heap Fetches: 0
Planning time : 78.818 ms
Execution time : 83,990.278 ms