explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mc5V

Settings
# exclusive inclusive rows x rows loops node
1. 6.187 36.879 ↑ 108.4 89 1

HashAggregate (cost=82,222.78..82,319.26 rows=9,648 width=41) (actual time=36.794..36.879 rows=89 loops=1)

  • Group Key: convo_id
2. 26.113 30.692 ↑ 1.3 10,889 1

Bitmap Heap Scan on messages m (cost=1,442.69..82,154.07 rows=13,743 width=41) (actual time=7.444..30.692 rows=10,889 loops=1)

  • Recheck Cond: ((convo_id)::text = ANY ('{7a69c6c542dff94a256e76f2a35d7a39,528e8ccb4f4a926b3ca25dcb43ecf162,a8a46b4c1389de05878ca59fa206182f,76bf380471bfeb42af8a7078eb717495,eb6428404
  • Filter: ((type)::text = ANY ('{email-pipe-in,user,order-status}'::text[]))
  • Rows Removed by Filter: 9429
  • Heap Blocks: exact=19086
3. 4.579 4.579 ↑ 1.2 20,318 1

Bitmap Index Scan on messages_convo_id_inserted_at_index (cost=0.00..1,439.25 rows=24,983 width=0) (actual time=4.579..4.579 rows=20,318 loops=1)

  • Index Cond: ((convo_id)::text = ANY ('{7a69c6c542dff94a256e76f2a35d7a39,528e8ccb4f4a926b3ca25dcb43ecf162,a8a46b4c1389de05878ca59fa206182f,76bf380471bfeb42af8a7078eb717495,eb642