explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VNCT : added index

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 85.197 ↑ 1.0 1 1

Limit (cost=84.23..84.24 rows=1 width=16) (actual time=85.197..85.197 rows=1 loops=1)

2. 0.313 85.195 ↑ 512.0 1 1

Sort (cost=84.23..85.51 rows=512 width=16) (actual time=85.195..85.195 rows=1 loops=1)

  • Sort Key: played DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 84.882 84.882 ↑ 1.6 328 1

Index Scan using words_moves_puzzle_idx on words_moves (cost=0.43..81.67 rows=512 width=16) (actual time=0.838..84.882 rows=328 loops=1)

  • Index Cond: (puzzle = true)
  • Filter: (puzzle IS TRUE)
Planning time : 2.401 ms
Execution time : 85.277 ms