explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oAaZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 44.698 ↑ 930.0 1 1

GroupAggregate (cost=5,885.74..5,902.73 rows=930 width=16) (actual time=44.698..44.698 rows=1 loops=1)

  • Group Key: thread_id
  • Buffers: shared hit=14434
2. 0.010 44.690 ↑ 1,025.0 1 1

Sort (cost=5,885.74..5,888.30 rows=1,025 width=16) (actual time=44.690..44.690 rows=1 loops=1)

  • Sort Key: thread_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=14434
3. 0.026 44.680 ↑ 1,025.0 1 1

Bitmap Heap Scan on mentions (cost=4,622.73..5,834.48 rows=1,025 width=16) (actual time=44.679..44.680 rows=1 loops=1)

  • Recheck Cond: ((user_id = 23) AND (status = 'new'::mention_status))
  • Heap Blocks: exact=1
  • Buffers: shared hit=14434
4. 2.013 44.654 ↓ 0.0 0 1

BitmapAnd (cost=4,622.73..4,622.73 rows=1,025 width=0) (actual time=44.654..44.654 rows=0 loops=1)

  • Buffers: shared hit=14433
5. 1.949 1.949 ↑ 1.1 13,754 1

Bitmap Index Scan on ix_mentions_user_id (cost=0.00..228.95 rows=14,790 width=0) (actual time=1.949..1.949 rows=13,754 loops=1)

  • Index Cond: (user_id = 23)
  • Buffers: shared hit=61
6. 40.692 40.692 ↑ 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=40.692..40.692 rows=103,554 loops=1)

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