explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yqh9

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,253.251 ↑ 1.0 10 1

Limit (cost=389,069.99..389,070.02 rows=10 width=2,508) (actual time=2,253.242..2,253.251 rows=10 loops=1)

2. 826.342 2,253.243 ↑ 181,542.7 10 1

Sort (cost=389,069.99..393,608.56 rows=1,815,427 width=2,508) (actual time=2,253.241..2,253.243 rows=10 loops=1)

  • Sort Key: started DESC
  • Sort Method: top-N heapsort Memory: 40kB
3. 1,426.901 1,426.901 ↓ 1.0 1,888,228 1

Seq Scan on transaction (cost=0.00..349,839.27 rows=1,815,427 width=2,508) (actual time=0.043..1,426.901 rows=1,888,228 loops=1)