#	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)

Limit  (cost=0.57..80.40 rows=100 width=4315) (actual time=0.585..10.123 rows=100 loops=1)
  ->  Nested Loop  (cost=0.57..23813.20 rows=29828 width=4315) (actual time=0.584..10.084 rows=100 loops=1)
        Join Filter: (cn.clarifying_client_notes_id = cn2.client_notes_id)
        ->  Nested Loop  (cost=0.29..21989.53 rows=3304 width=3256) (actual time=0.566..9.659 rows=100 loops=1)
              ->  Seq Scan on interpret_drafts drafts  (cost=0.00..5528.28 rows=29828 width=2197) (actual time=0.005..2.338 rows=4692 loops=1)
              ->  Index Scan using client_notes_clarifying_client_notes_id_index on client_notes cn  (cost=0.29..0.54 rows=1 width=1059) (actual time=0.001..0.001 rows=0 loops=4692)
                    Index Cond: (clarifying_client_notes_id = drafts.client_notes_id)
        ->  Index Scan using client_notes_pkey on client_notes cn2  (cost=0.29..0.54 rows=1 width=1059) (actual time=0.002..0.003 rows=1 loops=100)
              Index Cond: (client_notes_id = drafts.client_notes_id)
Planning time: 2.673 ms
Execution time: 10.306 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	4.992 ms	49.3 %
Limit	1	0.039 ms	0.4 %
Nested Loop	2	2.754 ms	27.2 %
Seq Scan	1	2.338 ms	23.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
client_notes	2	4.992 ms	49.3 %
Index Scan	2	4.992 ms	100.0 %
interpret_drafts	1	2.338 ms	23.1 %
Seq Scan	1	2.338 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d3yU

Color mode:

Visible columns:

Per node type stats

Per table stats