explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W43r

Settings
# exclusive inclusive rows x rows loops node
1. 62,026.846 62,026.846 ↓ 2.2 757 1

Index Scan using ents__name_trgm_idx on ents (cost=0.41..386.91 rows=337 width=23) (actual time=193.716..62,026.846 rows=757 loops=1)

  • Index Cond: ((name)::text ~~* '%apple%'::text)
  • Rows Removed by Index Recheck: 15
Planning time : 0.653 ms
Execution time : 62,028.466 ms