explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OKmx

Settings
# exclusive inclusive rows x rows loops node
1. 64,077.409 65,443.758 ↓ 0.0 0 1

Hash Left Join (cost=36.95..173,513.38 rows=10,635 width=8) (actual time=65,443.758..65,443.758 rows=0 loops=1)

  • Hash Cond: (d.typdokument_id = td.id)
  • Filter: (f_unaccent(lower((td.nazov)::text)) ~~ 'vypis'::text)
  • Rows Removed by Filter: 7807125
2. 1,365.944 1,365.944 ↓ 1.0 7,807,125 1

Index Only Scan using dokument_typdokument_id_id_idx on d_dokument d (cost=0.43..150,156.45 rows=7,805,781 width=16) (actual time=0.019..1,365.944 rows=7,807,125 loops=1)

  • Heap Fetches: 0
3. 0.186 0.405 ↑ 1.0 734 1

Hash (cost=27.34..27.34 rows=734 width=113) (actual time=0.405..0.405 rows=734 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
4. 0.219 0.219 ↑ 1.0 734 1

Seq Scan on d_typdokument td (cost=0.00..27.34 rows=734 width=113) (actual time=0.010..0.219 rows=734 loops=1)

Planning time : 0.541 ms
Execution time : 65,443.789 ms