explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d3yU

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 10.123 ↑ 1.0 100 1

Limit (cost=0.57..80.40 rows=100 width=4,315) (actual time=0.585..10.123 rows=100 loops=1)

2. 0.125 10.084 ↑ 298.3 100 1

Nested Loop (cost=0.57..23,813.20 rows=29,828 width=4,315) (actual time=0.584..10.084 rows=100 loops=1)

  • Join Filter: (cn.clarifying_client_notes_id = cn2.client_notes_id)
3. 2.629 9.659 ↑ 33.0 100 1

Nested Loop (cost=0.29..21,989.53 rows=3,304 width=3,256) (actual time=0.566..9.659 rows=100 loops=1)

4. 2.338 2.338 ↑ 6.4 4,692 1

Seq Scan on interpret_drafts drafts (cost=0.00..5,528.28 rows=29,828 width=2,197) (actual time=0.005..2.338 rows=4,692 loops=1)

5. 4.692 4.692 ↓ 0.0 0 4,692

Index Scan using client_notes_clarifying_client_notes_id_index on client_notes cn (cost=0.29..0.54 rows=1 width=1,059) (actual time=0.001..0.001 rows=0 loops=4,692)

  • Index Cond: (clarifying_client_notes_id = drafts.client_notes_id)
6. 0.300 0.300 ↑ 1.0 1 100

Index Scan using client_notes_pkey on client_notes cn2 (cost=0.29..0.54 rows=1 width=1,059) (actual time=0.002..0.003 rows=1 loops=100)

  • Index Cond: (client_notes_id = drafts.client_notes_id)