explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B9m8 : epic notes with mentions

Settings
# exclusive inclusive rows x rows loops node
1. 4.362 16.518 ↓ 1,855.2 9,276 1

Sort (cost=97.58..97.59 rows=5 width=4) (actual time=15.051..16.518 rows=9,276 loops=1)

  • Sort Key: notes.id
  • Sort Method: quicksort Memory: 819kB
  • Buffers: shared hit=6,175
  • - planning: 10.554 ms
  • - execution: 17.476 ms
  • - hits: 6,175 (~48.20 MiB) from the buffer pool
  • - reads: 0 from the OS file cache, including disk I/O
  • - dirtied: 0
  • - writes: 0
2. 3.067 12.156 ↓ 1,855.2 9,276 1

Hash Left Join (cost=53.33..97.52 rows=5 width=4) (actual time=0.075..12.156 rows=9,276 loops=1)

  • Hash Cond: (notes.id = epic_user_mentions.note_id)
  • Filter: (epic_user_mentions.epic_id IS NULL)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6,172
  • - I/O read: 0.000 ms
  • - I/O write: 0.000 ms
3. 9.085 9.085 ↓ 8.9 9,276 1

Index Only Scan using epic_mentions_temp_index on public.notes (cost=0.29..40.56 rows=1,038 width=4) (actual time=0.061..9.085 rows=9,276 loops=1)

  • Index Cond: (notes.id >= 1)
  • Heap Fetches: 189
  • Buffers: shared hit=6,172
4. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=45.80..45.80 rows=580 width=8) (actual time=0.003..0.004 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.epic_user_mentions (cost=0.00..45.80 rows=580 width=8) (actual time=0.003..0.003 rows=0 loops=1)