explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sIBo : Optimization for: Optimization for: plan #Hgl5; plan #lBx9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.018 11.503 ↑ 1.0 1 1

Aggregate (cost=867.54..867.55 rows=1 width=8) (actual time=11.503..11.503 rows=1 loops=1)

  • Buffers: shared hit=5,874 read=68
  • I/O Timings: read=0.687
2. 0.013 11.485 ↓ 4.0 4 1

Nested Loop Anti Join (cost=350.76..867.53 rows=1 width=8) (actual time=11.452..11.485 rows=4 loops=1)

  • Join Filter: ((audit.audit_ev_discriminator)::text = 'AUDIT_NTFN_EVS'::text)
  • Buffers: shared hit=5,874 read=68
  • I/O Timings: read=0.687
3. 0.666 11.428 ↓ 4.0 4 1

Hash Join (cost=350.19..856.17 rows=1 width=31) (actual time=11.418..11.428 rows=4 loops=1)

  • Hash Cond: (audit.ev_id = ev.ev_id)
  • Buffers: shared hit=5,842 read=68
  • I/O Timings: read=0.687
4. 9.046 9.046 ↓ 15.8 5,214 1

Index Only Scan using aea_recipient_id_aed_aet_cd_pidx on audit_evs_all audit (cost=0.56..505.67 rows=329 width=31) (actual time=0.087..9.046 rows=5,214 loops=1)

  • Index Cond: (recipient_id = '215564'::bigint)
  • Heap Fetches: 5,214
  • Buffers: shared hit=5,216 read=68
  • I/O Timings: read=0.687
5. 0.131 1.716 ↑ 1.2 854 1

Hash (cost=337.10..337.10 rows=1,003 width=8) (actual time=1.716..1.716 rows=854 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 42kB
  • Buffers: shared hit=626
6. 1.585 1.585 ↑ 1.2 854 1

Index Scan using idx_evs_status on evs ev (cost=0.42..337.10 rows=1,003 width=8) (actual time=0.051..1.585 rows=854 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: 3
  • Buffers: shared hit=626
7. 0.044 0.044 ↓ 0.0 0 4

Index Only Scan using idx_audit_evs_all_niaaet on audit_evs_all inneraudit (cost=0.57..11.35 rows=8 width=8) (actual time=0.011..0.011 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
  • Buffers: shared hit=32
Planning time : 1.992 ms
Execution time : 11.587 ms