explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 69B7

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 48.402 ↓ 0.0 0 1

GroupAggregate (cost=4,840.70..4,845.94 rows=296 width=16) (actual time=48.402..48.402 rows=0 loops=1)

  • Group Key: thread_id
  • Buffers: shared hit=14405
2. 0.008 48.400 ↓ 0.0 0 1

Sort (cost=4,840.70..4,841.46 rows=305 width=16) (actual time=48.400..48.400 rows=0 loops=1)

  • Sort Key: thread_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=14405
3. 0.044 48.392 ↓ 0.0 0 1

Bitmap Heap Scan on mentions (cost=4,461.67..4,828.11 rows=305 width=16) (actual time=48.392..48.392 rows=0 loops=1)

  • Recheck Cond: ((user_id = 272) AND (status = 'new'::mention_status))
  • Heap Blocks: exact=10
  • Buffers: shared hit=14405
4. 0.898 48.348 ↓ 0.0 0 1

BitmapAnd (cost=4,461.67..4,461.67 rows=305 width=0) (actual time=48.348..48.348 rows=0 loops=1)

  • Buffers: shared hit=14395
5. 0.766 0.766 ↑ 1.1 4,162 1

Bitmap Index Scan on ix_mentions_user_id (cost=0.00..68.25 rows=4,403 width=0) (actual time=0.766..0.766 rows=4,162 loops=1)

  • Index Cond: (user_id = 272)
  • Buffers: shared hit=23
6. 46.684 46.684 ↑ 1.1 103,554 1

Bitmap Index Scan on ix_mentions_status (cost=0.00..4,393.02 rows=117,359 width=0) (actual time=46.684..46.684 rows=103,554 loops=1)

  • Index Cond: (status = 'new'::mention_status)
  • Buffers: shared hit=14372