explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q6EQ

Settings
# exclusive inclusive rows x rows loops node
1. 399.147 19,471.553 ↑ 1.0 1 1

Aggregate (cost=301,217.76..301,217.77 rows=1 width=8) (actual time=19,471.553..19,471.553 rows=1 loops=1)

2. 19,072.406 19,072.406 ↓ 1.1 1,305,258 1

Seq Scan on screening_applicants sa (cost=0.00..298,161.20 rows=1,222,625 width=4) (actual time=0.051..19,072.406 rows=1,305,258 loops=1)

  • Filter: (((name_first)::text ~* '(Theodore|J|Thomas).*'::text) OR ((name_middle)::text ~* '.*(Theodore|J|Thomas).*'::text) OR ((name_last)::text ~* '.*(Theodore|J|Thomas).*'::text))
  • Rows Removed by Filter: 4,312,982
Planning time : 1.202 ms
Execution time : 19,471.622 ms