explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u4l8 : Optimization for: plan #K1Pn

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 3,514.303 3,514.303 ↑ 1,031.0 1 1

Seq Scan on molecule_ref (cost=0.00..1,310,134.70 rows=1,031 width=58) (actual time=1,385.404..3,514.303 rows=1 loops=1)

  • Filter: ((mol_name)::text ~~ 'ryano%'::text)
  • Rows Removed by Filter: 37494091