explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FTt8

Settings
# exclusive inclusive rows x rows loops node
1. 2.994 4.635 ↓ 9.9 5,000 1

Sort (cost=63.66..64.92 rows=504 width=524) (actual time=4.023..4.635 rows=5,000 loops=1)

  • Sort Key: id DESC
  • Sort Method: quicksort Memory: 583kB
2. 1.641 1.641 ↓ 9.9 5,000 1

Seq Scan on post (cost=0.00..41.04 rows=504 width=524) (actual time=0.070..1.641 rows=5,000 loops=1)

Planning time : 0.798 ms
Execution time : 5.402 ms