explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hgl5

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↑ 1.0 1 1

Aggregate (cost=667.79..667.80 rows=1 width=8) (actual rows=1 loops=1)

  • Buffers: shared hit=3,621 read=6,044 dirtied=41
  • I/O Timings: read=14,120.846
2. 0.000 0.000 ↓ 117.0 117 1

Nested Loop Anti Join (cost=315.72..667.79 rows=1 width=8) (actual rows=117 loops=1)

  • Join Filter: ((audit.audit_ev_discriminator)::text = 'AUDIT_NTFN_EVS'::text)
  • Buffers: shared hit=3,621 read=6,044 dirtied=41
  • I/O Timings: read=14,120.846
3. 0.000 0.000 ↓ 117.0 117 1

Hash Join (cost=315.15..659.68 rows=1 width=31) (actual rows=117 loops=1)

  • Hash Cond: (audit.ev_id = ev.ev_id)
  • Buffers: shared hit=2,790 read=5,939 dirtied=41
  • I/O Timings: read=14,120.147
4. 0.000 0.000 ↓ 9.3 5,120 1

Index Only Scan using aea_recipient_id_aed_aet_cd_pidx on audit_evs_all audit (cost=0.56..343.65 rows=549 width=31) (actual rows=5,120 loops=1)

  • Index Cond: (recipient_id = '215564'::bigint)
  • Heap Fetches: 7,987
  • Buffers: shared hit=2,342 read=5,939 dirtied=41
  • I/O Timings: read=14,120.147
5. 0.000 0.000 ↓ 1.4 1,167 1

Hash (cost=303.92..303.92 rows=854 width=8) (actual rows=1,167 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 62kB
  • Buffers: shared hit=448
6. 0.000 0.000 ↓ 1.4 1,167 1

Index Scan using idx_evs_status on evs ev (cost=0.42..303.92 rows=854 width=8) (actual rows=1,167 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: 4
  • Buffers: shared hit=448
7. 0.000 0.000 ↓ 0.0 0 117

Index Only Scan using idx_audit_evs_all_niaaet on audit_evs_all inneraudit (cost=0.57..8.08 rows=13 width=8) (actual rows=0 loops=117)

  • 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=831 read=105
  • I/O Timings: read=0.699