explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xBo5 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #hvgr; plan #vG1; plan #5uPj; plan #tJir; plan #4Aiq; plan #wXyW; plan #1Q6S; plan #7r6r; plan #fCGR; plan #Op05; plan #SpjK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.008 ↑ 1.0 1 1

Aggregate (cost=14.42..14.43 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

2. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on rfid_txn_details txn (cost=4.31..14.41 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (((tag_id)::text = 'param_tag_id'::text) AND (txn_date >= 57245))
  • Filter: (((container_no)::text = 'param_container_no'::text) AND (location_master_sl_no = 14) AND (event_id = 1))
3. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on rfid_txn_details_tag_id_txn_date_created_date_idx (cost=0.00..4.31 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (((tag_id)::text = 'param_tag_id'::text) AND (txn_date >= 57245))