explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ohpy

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.967 ↑ 1.0 10 1

Limit (cost=132.79..132.82 rows=10 width=19) (actual time=1.965..1.967 rows=10 loops=1)

2. 0.015 1.965 ↑ 2.5 10 1

Sort (cost=132.79..132.85 rows=25 width=19) (actual time=1.965..1.965 rows=10 loops=1)

  • Sort Key: (max(priority)) DESC, (min(invoke_at))
  • Sort Method: top-N heapsort Memory: 26kB
3. 1.504 1.950 ↑ 1.0 25 1

HashAggregate (cost=132.00..132.25 rows=25 width=19) (actual time=1.946..1.950 rows=25 loops=1)

  • Group Key: queue_id
4. 0.446 0.446 ↑ 1.0 5,000 1

Seq Scan on jobs (cost=0.00..82.00 rows=5,000 width=19) (actual time=0.008..0.446 rows=5,000 loops=1)

Planning time : 0.090 ms