explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mLO9

Settings
# exclusive inclusive rows x rows loops node
1. 62,820.151 65,382.576 ↓ 0.0 0 1

Hash Left Join (cost=36.52..286,635.74 rows=10,635 width=642) (actual time=65,382.576..65,382.576 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. 2,561.662 2,561.662 ↓ 1.0 7,807,125 1

Seq Scan on d_dokument d (cost=0.00..263,278.81 rows=7,805,781 width=253) (actual time=0.014..2,561.662 rows=7,807,125 loops=1)

3. 0.326 0.763 ↑ 1.0 734 1

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

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

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

Planning time : 0.590 ms
Execution time : 65,382.623 ms