explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jzr : Optimization for: plan #cwEm

Settings

Optimization path:

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

Sort (cost=49,189.14..49,194.76 rows=2,250 width=20) (actual rows= loops=)

  • Sort Key: h.clock
2. 0.000 0.000 ↓ 0.0

Append (cost=24.59..49,063.86 rows=2,250 width=20) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on history_p2019_01_30 h (cost=24.59..49,063.86 rows=2,250 width=20) (actual rows= loops=)

  • Recheck Cond: ((itemid = ANY ('{46077,46094,46111}'::bigint[])) AND (clock >= 1548831244) AND (clock <= 1548867244))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on history_p2019_01_30_itemid_clock_idx_brin (cost=0.00..24.03 rows=19,972 width=0) (actual rows= loops=)

  • Index Cond: ((itemid = ANY ('{46077,46094,46111}'::bigint[])) AND (clock >= 1548831244) AND (clock <= 1548867244))