explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1VyT

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

Hash Join (cost=36.93..71,533.74 rows=74,449 width=642) (actual time=2.124..4,055.216 rows=19,160 loops=1)

  • Hash Cond: (d.typdokument_id = td.id)
2. 4,026.362 4,026.362 ↑ 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.484..4,026.362 rows=19,160 loops=1)

  • Index Cond: (f_unaccent(lower((nazov)::text)) ~~ 'test%'::text)
  • Rows Removed by Index Recheck: 59993
3. 0.312 0.627 ↑ 1.0 734 1

Hash (cost=27.34..27.34 rows=734 width=389) (actual time=0.626..0.627 rows=734 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 166kB
4. 0.315 0.315 ↑ 1.0 734 1

Seq Scan on d_typdokument td (cost=0.00..27.34 rows=734 width=389) (actual time=0.027..0.315 rows=734 loops=1)

Planning time : 0.951 ms
Execution time : 4,057.014 ms