explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJff

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.315 ↓ 0.0 0 1

Limit (cost=167.54..167.55 rows=1 width=16) (actual time=0.315..0.315 rows=0 loops=1)

2. 0.079 0.313 ↓ 0.0 0 1

Sort (cost=167.54..167.55 rows=1 width=16) (actual time=0.313..0.313 rows=0 loops=1)

  • Sort Key: ae_ids.creation_date DESC, ae_ids.audit_ev_id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.234 ↓ 0.0 0 1

Subquery Scan on ae_ids (cost=167.51..167.53 rows=1 width=16) (actual time=0.234..0.234 rows=0 loops=1)

4. 0.001 0.234 ↓ 0.0 0 1

Unique (cost=167.51..167.52 rows=1 width=28) (actual time=0.234..0.234 rows=0 loops=1)

5. 0.045 0.233 ↓ 0.0 0 1

Sort (cost=167.51..167.52 rows=1 width=28) (actual time=0.233..0.233 rows=0 loops=1)

  • Sort Key: audit.ev_id DESC, (CASE WHEN (n.sub_id IS NULL) THEN 1 ELSE 0 END) DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.001 0.188 ↓ 0.0 0 1

Nested Loop (cost=1.97..167.50 rows=1 width=28) (actual time=0.188..0.188 rows=0 loops=1)

7. 0.000 0.187 ↓ 0.0 0 1

Nested Loop (cost=1.54..164.05 rows=1 width=32) (actual time=0.187..0.187 rows=0 loops=1)

8. 0.187 0.187 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.11..122.71 rows=12 width=32) (actual time=0.187..0.187 rows=0 loops=1)

  • Join Filter: ((audit.audit_ev_discriminator)::text = 'AUDIT_NTFN_EVS'::text)
  • -> Index Only Scan using aea_recipient_id_aed_aet_cd_pidx on audit_evs_all audit (cost=0.55..7.58 rows=59 width=47) (actual time=0.184..0.184 rows=0 loops=
  • Index Cond: (recipient_id = 4602446)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_audit_evs_all_niaaet on audit_evs_all inneraudit (cost=0.56..4.35 rows=7 width=8) (never executed)

  • Index Cond: ((ntfn_id = audit.ntfn_id) AND (ap_audit_ev_type = ANY ('{DELINK_PERSON_NOTIFICATION,DELINK_GROUP_NOTIFICATION}'::text[])))
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using evs_ev_id_pidx on evs ev (cost=0.42..3.45 rows=1 width=8) (never executed)

  • Index Cond: (ev_id = audit.ev_id)
  • Filter: (((status)::text = ANY ('{ACTIVE,SUSPENDED}'::text[])) AND ((system_message_type IS NULL) OR ((system_message_type)::text <> ALL ('{DEVICE_VALIDATION
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ntfn_pk on ntfn n (cost=0.43..3.45 rows=1 width=16) (never executed)

  • Index Cond: (ntfn_id = audit.ntfn_id)
Planning time : 17.861 ms
Execution time : 0.664 ms