explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tjZ1

Settings
# exclusive inclusive rows x rows loops node
1. 4,364.876 4,364.876 ↑ 3.9 19,160 1

Index Scan using dokument_nazov_u_lower_like_idx on d_dokument d (cost=0.41..71,300.67 rows=74,449 width=253) (actual time=1.357..4,364.876 rows=19,160 loops=1)

  • Index Cond: (f_unaccent(lower((nazov)::text)) ~~ 'test%'::text)
  • Rows Removed by Index Recheck: 59993
Planning time : 0.337 ms
Execution time : 4,366.706 ms