explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HCBX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 16.296 ↑ 5.3 3 1

GroupAggregate (cost=292.21..292.53 rows=16 width=51) (actual time=16.291..16.296 rows=3 loops=1)

  • Group Key: alc_code
2. 0.089 16.277 ↓ 1.7 27 1

Sort (cost=292.21..292.25 rows=16 width=22) (actual time=16.276..16.277 rows=27 loops=1)

  • Sort Key: alc_code
  • Sort Method: quicksort Memory: 27kB
3. 16.105 16.188 ↓ 1.7 27 1

Bitmap Heap Scan on rests_item (cost=13.47..291.89 rows=16 width=22) (actual time=2.721..16.188 rows=27 loops=1)

  • Recheck Cond: ((alc_code)::text = ANY ('{0177481000001928641,0037765000003357440,0350190000001496602}'::text[]))
  • Filter: active
  • Rows Removed by Filter: 52
  • Heap Blocks: exact=68
4. 0.083 0.083 ↑ 1.0 79 1

Bitmap Index Scan on idx_rests_item_alc_code (cost=0.00..13.47 rows=81 width=0) (actual time=0.083..0.083 rows=79 loops=1)

  • Index Cond: ((alc_code)::text = ANY ('{0177481000001928641,0037765000003357440,0350190000001496602}'::text[]))