explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TbiW : Optimization for: plan #AorT

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.86..28.68 rows=2 width=166) (actual time=0.017..0.017 rows=0 loops=1)

2. 0.016 0.016 ↓ 0.0 0 1

Index Scan using patient_associated_party_d_pkey on patient_associated_party_d a (cost=0.43..11.76 rows=2 width=13) (actual time=0.015..0.016 rows=0 loops=1)

  • Index Cond: (((patient_id)::text = '10085'::text) AND (eff_end_ts > now()))
3. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_person_d_person_id on person_d b (cost=0.43..8.45 rows=1 width=141) (never executed)

  • Index Cond: ((person_id)::text = (a.associated_person_id)::text)
  • Filter: (eff_end_ts > now())