explain.depesz.com

PostgreSQL's explain analyze made readable

Result: spYu : epics with mentions

Settings
# exclusive inclusive rows x rows loops node
1. 0.418 1,994.760 ↓ 4.0 792 1

Merge Join (cost=0.44..3,472.13 rows=197 width=4) (actual time=0.057..1,994.760 rows=792 loops=1)

  • Buffers: shared hit=9936 read=2052 dirtied=78
  • I/O Timings: read=1927.075
  • - planning: 4.434 ms
  • - execution: 1.995 s
  • - hits: 9936 (~77.60 MiB) from the buffer pool
  • - reads: 2052 (~16.00 MiB) from the OS file cache, including disk I/O
  • - dirtied: 78 (~624.00 KiB)
  • - writes: 0
2. 1,994.341 1,994.341 ↓ 2.0 792 1

Index Scan using epics_pkey on public.epics (cost=0.29..3,438.69 rows=394 width=4) (actual time=0.053..1,994.341 rows=792 loops=1)

  • Filter: ((epics.description ~~ '%@%'::text) OR ((epics.title)::text ~~ '%@%'::text))
  • Rows Removed by Filter: 13894
  • Buffers: shared hit=9935 read=2052 dirtied=78
  • I/O Timings: read=1927.075
3. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using epic_user_mentions_on_epic_id_and_note_id_index on public.epic_user_mentions (cost=0.15..30.85 rows=580 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Heap Fetches: 0
  • Buffers: shared hit=1
  • - I/O read: 1.927 s
  • - I/O write: 0.000 ms