explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G7dN3

Settings
# exclusive inclusive rows x rows loops node
1. 392.246 18,748.366 ↑ 1.0 1 1

Aggregate (cost=301,217.76..301,217.77 rows=1 width=8) (actual time=18,748.365..18,748.366 rows=1 loops=1)

2. 18,356.120 18,356.120 ↓ 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.059..18,356.120 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.308 ms
Execution time : 18,748.446 ms