explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hvgr

Settings

Optimization(s) for this plan:

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

Aggregate (cost=14.33..14.34 rows=1 width=8) (actual time=0.030..0.030 rows=1 loops=1)

2. 0.001 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on rfid_txn_details txn (cost=4.30..14.32 rows=1 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: ((tag_id)::text = 'ABC'::text)
  • Filter: ((txn_date >= 56370064) AND ((container_no)::text = 'ABC'::text) AND (location_master_sl_no = 545) AND (event_id = 12))
3. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on rfid_txn_details_tag_id_created_date_idx (cost=0.00..4.30 rows=3 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((tag_id)::text = 'ABC'::text)