explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SqgI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.016 ↑ 1.0 5 1

Limit (cost=0.28..0.46 rows=5 width=24) (actual time=0.014..0.016 rows=5 loops=1)

2. 0.015 0.015 ↑ 1,000.0 5 1

Index Scan Backward using post_pkey on post (cost=0.28..178.28 rows=5,000 width=24) (actual time=0.014..0.015 rows=5 loops=1)

Planning time : 0.492 ms
Execution time : 0.030 ms