explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QdHc3

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.075 ↑ 1.0 10 1

Limit (cost=0.43..0.68 rows=10 width=11) (actual time=0.059..0.075 rows=10 loops=1)

2. 0.071 0.071 ↑ 500,000.0 10 1

Index Only Scan using idx_x on t_test (cost=0.43..125,911.73 rows=5,000,000 width=11) (actual time=0.058..0.071 rows=10 loops=1)

  • Heap Fetches: 10
Planning time : 0.199 ms
Execution time : 0.090 ms