explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R62

Settings
# exclusive inclusive rows x rows loops node
1. 16,808.298 16,815.891 ↓ 1.0 135,530 1

Bitmap Heap Scan on entity_eton_agg d (cost=2,085.27..300,290.28 rows=134,427 width=596) (actual time=10.954..16,815.891 rows=135,530 loops=1)

  • Recheck Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))
  • Filter: active
  • Rows Removed by Filter: 43
  • Heap Blocks: exact=19081
2. 7.593 7.593 ↓ 1.0 135,654 1

Bitmap Index Scan on idx_entity_eton_agg_works_state (cost=0.00..2,051.66 rows=134,439 width=0) (actual time=7.592..7.593 rows=135,654 loops=1)

  • Index Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))