explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HkCA

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on test_plan_eav (cost=681.18..24,490.60 rows=10 width=337) (actual rows= loops=)

  • Recheck Cond: ((ch = 9999) AND (date = '2019-01-02'::date))
2. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=681.18..681.18 rows=6,204 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ch_index_test_plan_eav (cost=0.00..231.13 rows=10,596 width=0) (actual rows= loops=)

  • Index Cond: (ch = 9999)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on date_index_test_plan_eav (cost=0.00..449.80 rows=23,419,022 width=0) (actual rows= loops=)

  • Index Cond: (date = '2019-01-02'::date)