explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xvf7

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

Limit (cost=0.29..0.86 rows=1 width=19) (actual time=0.062..0.063 rows=1 loops=1)

2. 0.062 0.062 ↑ 31,448.0 1 1

Index Only Scan using ra_halloffame_query_log_idx on ra_halloffame_query_log (cost=0.29..18,106.71 rows=31,448 width=19) (actual time=0.062..0.062 rows=1 loops=1)

  • Heap Fetches: 1