explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Op05 : 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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.023 0.023 ↓ 0.0 0 1

Index Only Scan using rfid_blank_container_details_tag_id_txn_date_idx on rfid_blank_container_details (cost=0.28..8.30 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ((tag_id = 'param_tag_id'::text) AND (txn_date = 123123))
  • Heap Fetches: 0
Planning time : 0.179 ms