explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UtTH

Settings
# exclusive inclusive rows x rows loops node
1. 3,304.265 3,304.265 ↑ 194.0 1 1

Seq Scan on persons p (cost=0.00..235,857.46 rows=194 width=390) (actual time=792.234..3,304.265 rows=1 loops=1)

  • Filter: (((firstname)::text <> ''::text) AND ((full_name((firstname)::text, (lastname)::text) ~~* '%24127265%'::text) OR ((dni)::text ~~ '%24127265%'::text) OR ((emailaddress)::text ~~* '%24127265%'::text)))
  • Rows Removed by Filter: 757954
Planning time : 0.581 ms
Execution time : 3,304.297 ms