explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SUQ9

Settings
# exclusive inclusive rows x rows loops node
1. 0.265 2,022.201 ↑ 1.0 1,000 1

Limit (cost=0..1,813.12 rows=1,000 width=4) (actual time=0.244..2,022.201 rows=1,000 loops=1)

2. 2,021.936 2,021.936 ↑ 383.0 1,000 1

Seq Scan on cosigner c2 (cost=0..694,473.89 rows=383,027 width=4) (actual time=0.242..2,021.936 rows=1,000 loops=1)

  • Filter: (((phone)::text ~~ '%dart%'::text) OR (lower((mail)::text) ~~ '%dart%'::text) OR (lower((firstname)::text) ~~ '%dart%'::text) OR (lower((lastname)::text) ~~ '%dart%'::text) OR (lower((((firstname)::text || ' '::text) || (lastname)::text)) ~~ '%dart%'::text))
Planning time : 0.337 ms
Execution time : 2,022.391 ms