explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PSR4

Settings
# exclusive inclusive rows x rows loops node
1. 7,854.313 7,854.313 ↑ 1.3 123,137 1

Index Scan using dokument_nazov_u_lower_like_idx on d_dokument d (cost=0.41..127,832.70 rows=156,965 width=253) (actual time=1.698..7,854.313 rows=123,137 loops=1)

  • Index Cond: (f_unaccent(lower((nazov)::text)) ~~ 'vypis%'::text)
  • Rows Removed by Index Recheck: 109246
Planning time : 0.439 ms
Execution time : 7,861.643 ms