explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qtiw

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

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

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

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

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

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

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

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

  • Buffers: shared hit=14433
5. 2.156 2.156 ↑ 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=2.156..2.156 rows=13,754 loops=1)

  • Index Cond: (user_id = 23)
  • Buffers: shared hit=61
6. 41.179 41.179 ↑ 1.1 103,539 1

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

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