explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lch6

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 808.228 ↑ 1.0 1 1

Aggregate (cost=12,571.36..12,571.37 rows=1 width=9) (actual time=808.228..808.228 rows=1 loops=1)

  • Buffers: shared hit=4,613
2. 808.156 808.156 ↑ 1,987.0 1 1

Seq Scan on hoga (cost=0.00..12,561.42 rows=1,987 width=9) (actual time=38.873..808.156 rows=1 loops=1)

  • Filter: ((upper((ulica_krotka)::text) ~~ '%'::text) AND (upper((miasto)::text) = 'IDZBARK'::text))
  • Rows Removed by Filter: 397,420
  • Buffers: shared hit=4,613
Planning time : 0.678 ms