explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wr4M

Settings
# exclusive inclusive rows x rows loops node
1. 0.166 1.283 ↓ 699.0 699 1

Hash Left Join (cost=4.95..14.83 rows=1 width=4) (actual time=0.093..1.283 rows=699 loops=1)

  • Hash Cond: (notes.id = design_user_mentions.note_id)
  • Filter: (design_user_mentions.design_id IS NULL)
  • Rows Removed by Filter: 35
  • Buffers: shared hit=355
2. 1.098 1.098 ↓ 4.7 734 1

Index Only Scan using design_mentions_temp_index on public.notes (cost=0.28..9.56 rows=157 width=4) (actual time=0.048..1.098 rows=734 loops=1)

  • Index Cond: (notes.id >= 1)
  • Heap Fetches: 20
  • Buffers: shared hit=351
3. 0.010 0.019 ↓ 1.2 35 1

Hash (cost=4.30..4.30 rows=30 width=8) (actual time=0.019..0.019 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
4. 0.009 0.009 ↓ 1.2 35 1

Seq Scan on public.design_user_mentions (cost=0.00..4.30 rows=30 width=8) (actual time=0.006..0.009 rows=35 loops=1)

  • Buffers: shared hit=1