explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BTgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 4.186 ↑ 125.0 1 1

GroupAggregate (cost=14.29..910.33 rows=125 width=41) (actual time=4.186..4.186 rows=1 loops=1)

  • Group Key: convo_id
2. 2.250 4.178 ↑ 41.7 3 1

Bitmap Heap Scan on messages m (cost=14.29..908.46 rows=125 width=41) (actual time=2.404..4.178 rows=3 loops=1)

  • Recheck Cond: ((convo_id)::text = '00bb7104125ecd85bb9908227a3e37ab'::text)
  • Filter: ((type)::text = ANY ('{email-pipe-in,user,order-status}'::text[]))
  • Heap Blocks: exact=3
3. 1.928 1.928 ↑ 75.7 3 1

Bitmap Index Scan on messages_convo_id_inserted_at_index (cost=0.00..14.26 rows=227 width=0) (actual time=1.927..1.928 rows=3 loops=1)

  • Index Cond: ((convo_id)::text = '00bb7104125ecd85bb9908227a3e37ab'::text)