explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3chk

Settings
# exclusive inclusive rows x rows loops node
1. 21.780 3,295.732 ↑ 1.7 38,408 1

Gather (cost=1,000.00..215,604.53 rows=64,329 width=4) (actual time=0.485..3,295.732 rows=38,408 loops=1)

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

Parallel Seq Scan on users (cost=0.00..208,171.63 rows=26,804 width=4) (actual time=0.597..3,273.952 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.116 ms
Execution time : 3,299.215 ms