explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2rcl

Settings
# exclusive inclusive rows x rows loops node
1. 24.516 13,795.757 ↑ 1.7 38,408 1

Gather (cost=1,000.00..215,621.86 rows=64,356 width=4) (actual time=2.266..13,795.757 rows=38,408 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 13,771.241 13,771.241 ↑ 2.1 12,803 3

Parallel Seq Scan on users (cost=0.00..208,186.26 rows=26,815 width=4) (actual time=1.584..13,771.241 rows=12,803 loops=3)

  • Filter: ((deleted_at IS NULL) AND ((searchable @@ '''james'':*'::tsquery) OR (lower(email) = 'james'::text) OR (lower(email) ~~* '%james%@%'::text)))
  • Rows Removed by Filter: 1233762
Planning time : 13.522 ms
Execution time : 13,800.887 ms