explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HhNf

Settings
# exclusive inclusive rows x rows loops node
1. 2.696 6.576 ↑ 1.0 100 1

Limit (cost=0.29..3.70 rows=100 width=18) (actual time=2.599..6.576 rows=100 loops=1)

2. 3.880 3.880 ↑ 751.5 100 1

Index Scan using persons__pk on persons (cost=0.29..2,557.42 rows=75,150 width=18) (actual time=2.574..3.880 rows=100 loops=1)

  • Index Cond: (id > 25000)
Planning time : 1.604 ms
Execution time : 7.762 ms