explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Jvq

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 11,848.097 11,848.097 ↑ 73.6 14 1

Seq Scan on molecule_ref (cost=0.00..1,394,695.84 rows=1,031 width=58) (actual time=209.474..11,848.097 rows=14 loops=1)

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