explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 39b7

Settings
# exclusive inclusive rows x rows loops node
1. 6.303 47.691 ↑ 10.1 2,940 1

Merge Join (cost=869.88..3,847.32 rows=29,805 width=4,315) (actual time=3.672..47.691 rows=2,940 loops=1)

  • Merge Cond: (cn.clarifying_client_notes_id = cn2.client_notes_id)
2. 12.945 31.370 ↑ 1.1 2,940 1

Merge Join (cost=702.94..6,537.15 rows=3,296 width=3,256) (actual time=2.934..31.370 rows=2,940 loops=1)

  • Merge Cond: (cn.clarifying_client_notes_id = drafts.client_notes_id)
3. 0.742 0.742 ↑ 12.1 1,076 1

Index Scan using client_notes_clarifying_client_notes_id_index on client_notes cn (cost=0.29..2,464.00 rows=13,061 width=1,059) (actual time=0.007..0.742 rows=1,076 loops=1)

4. 17.683 17.683 ↓ 1.0 31,041 1

Index Scan using interpret_drafts_client_notes_id_index on interpret_drafts drafts (cost=0.29..6,229.28 rows=29,805 width=2,197) (actual time=0.008..17.683 rows=31,041 loops=1)

5. 10.018 10.018 ↓ 1.2 15,110 1

Index Scan using client_notes_pkey on client_notes cn2 (cost=0.29..2,628.65 rows=13,061 width=1,059) (actual time=0.008..10.018 rows=15,110 loops=1)