explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bkz : ee

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 57.253 ↑ 1.6 24 1

Sort (cost=10,439.11..10,439.20 rows=39 width=5,442) (actual time=57.250..57.253 rows=24 loops=1)

  • Sort Key: naz_glowna DESC
  • Sort Method: quicksort Memory: 46kB
2. 57.177 57.177 ↑ 1.6 24 1

Seq Scan on miejscowosci (cost=0.00..10,438.08 rows=39 width=5,442) (actual time=1.111..57.177 rows=24 loops=1)

  • Filter: ((gmina)::text = 'Ujazd-obszar wiejski'::text)
  • Rows Removed by Filter: 124622