explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9n

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 7.352 ↓ 0.0 0 1

Nested Loop (cost=0.57..22.13 rows=1 width=24) (actual time=7.352..7.352 rows=0 loops=1)

2. 0.841 7.334 ↓ 0.0 0 1

Nested Loop (cost=0.42..21.03 rows=1 width=20) (actual time=7.334..7.334 rows=0 loops=1)

  • Join Filter: (i.client_notes_id = cc.clarifying_client_notes_id)
3. 1.721 5.965 ↓ 44.0 44 1

Nested Loop (cost=0.28..18.78 rows=1 width=16) (actual time=0.188..5.965 rows=44 loops=1)

4. 1.837 3.320 ↓ 44.0 44 1

Nested Loop (cost=0.14..10.61 rows=1 width=16) (actual time=0.131..3.320 rows=44 loops=1)

5. 0.471 0.471 ↓ 44.0 44 1

Seq Scan on interpret_drafts i (cost=0.00..2.44 rows=1 width=8) (actual time=0.051..0.471 rows=44 loops=1)

  • Filter: (removed_at IS NULL)
6. 1.012 1.012 ↑ 1.0 1 44

Index Scan using client_notes_pkey on client_notes c (cost=0.14..8.16 rows=1 width=8) (actual time=0.013..0.023 rows=1 loops=44)

  • Index Cond: (client_notes_id = i.client_notes_id)
7. 0.924 0.924 ↑ 1.0 1 44

Index Only Scan using projects_pkey on projects p (cost=0.14..8.16 rows=1 width=4) (actual time=0.012..0.021 rows=1 loops=44)

  • Index Cond: (project_id = i.project_id)
  • Heap Fetches: 44
8. 0.528 0.528 ↓ 0.0 0 44

Index Scan using client_notes_clarifying_client_notes_id_index on client_notes cc (cost=0.14..2.24 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=44)

  • Index Cond: (clarifying_client_notes_id = c.client_notes_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using research_feedback_pkey on research_feedback r (cost=0.15..1.08 rows=1 width=8) (never executed)

  • Index Cond: (research_feedback_id = cc.research_feedback_id)
  • Filter: (research_feedback_outcome_ref_id = 2)