explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GigD

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.111 100.286 ↑ 1.0 10 1

Limit (cost=271.19..271.21 rows=10 width=33) (actual time=100.142..100.286 rows=10 loops=1)

2. 51.113 100.175 ↑ 625.0 10 1

Sort (cost=271.19..286.81 rows=6,250 width=33) (actual time=100.127..100.175 rows=10 loops=1)

  • Sort Key: ((pocet_muzu + pocet_zen)) DESC
  • Sort Method: top-N heapsort Memory: 18kB
3. 49.062 49.062 ↑ 1.0 6,250 1

Seq Scan on obce (cost=0.00..136.12 rows=6,250 width=33) (actual time=0.047..49.062 rows=6,250 loops=1)