explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bJq6

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 81.931 ↑ 1.0 1 1

Limit (cost=24,416.92..24,416.92 rows=1 width=19) (actual time=81.930..81.931 rows=1 loops=1)

2. 0.405 81.928 ↑ 1,142,528.0 1 1

Sort (cost=24,416.92..27,273.24 rows=1,142,528 width=19) (actual time=81.928..81.928 rows=1 loops=1)

  • Sort Key: date DESC, timeinmillis DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 81.523 81.523 ↑ 4,498.1 254 1

Seq Scan on ra_halloffame_query_log (cost=0.00..18,704.28 rows=1,142,528 width=19) (actual time=0.013..81.523 rows=254 loops=1)