explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lBx9 : Optimization for: plan #Hgl5

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.130 92.209 ↑ 1.0 1 1

Aggregate (cost=862.91..862.92 rows=1 width=8) (actual time=92.209..92.209 rows=1 loops=1)

  • Buffers: shared hit=670 read=5,233
  • I/O Timings: read=51.210
2. 0.017 92.079 ↓ 4.0 4 1

Nested Loop Anti Join (cost=350.63..862.91 rows=1 width=8) (actual time=91.979..92.079 rows=4 loops=1)

  • Join Filter: ((audit.audit_ev_discriminator)::text = 'AUDIT_NTFN_EVS'::text)
  • Buffers: shared hit=662 read=5,233
  • I/O Timings: read=51.210
3. 1.213 91.918 ↓ 4.0 4 1

Hash Join (cost=350.07..851.54 rows=1 width=31) (actual time=91.884..91.918 rows=4 loops=1)

  • Hash Cond: (audit.ev_id = ev.ev_id)
  • Buffers: shared hit=634 read=5,229
  • I/O Timings: read=51.150
4. 85.044 85.044 ↓ 15.8 5,214 1

Index Scan using aea_recipient_temp on audit_evs_all audit (cost=0.43..501.04 rows=329 width=31) (actual time=0.130..85.044 rows=5,214 loops=1)

  • Index Cond: (recipient_id = '215564'::bigint)
  • Buffers: shared hit=7 read=5,229
  • I/O Timings: read=51.150
5. 0.179 5.661 ↑ 1.2 855 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 42kB
  • Buffers: shared hit=627
6. 5.482 5.482 ↑ 1.2 855 1

Index Scan using idx_evs_status on evs ev (cost=0.42..337.10 rows=1,003 width=8) (actual time=0.256..5.482 rows=855 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=627
7. 0.144 0.144 ↓ 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.036..0.036 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=28 read=4
  • I/O Timings: read=0.060
Planning time : 7.848 ms
Execution time : 92.483 ms