explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rI5O : Optimization for: Optimization for: Optimization for: plan #SKhy; plan #PirI; plan #hPn8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 19,366.274 19,366.274 ↓ 0.0 0 1

Seq Scan on patient_details (cost=0.00..664,583.38 rows=10,962 width=3,708) (actual time=19,366.274..19,366.274 rows=0 loops=1)

  • Filter: ((reverse(mr_no))::text = 'RSMC00206421'::text)
  • Rows Removed by Filter: 2,192,341
Total runtime : 19,366.347 ms