explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lImL : test zimnej wódki

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.064 76.828 ↑ 1.6 24 1

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

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

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

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