explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vZI7

Settings
# exclusive inclusive rows x rows loops node
1. 32,625.483 35,425.920 ↑ 1.0 17,304,394 1

Sort (cost=5,951,078.76..5,994,339.82 rows=17,304,424 width=122) (actual time=30,739.689..35,425.920 rows=17,304,394 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: external merge Disk: 2276976kB
2. 2,800.437 2,800.437 ↑ 1.0 17,304,394 1

Seq Scan on new_history_user_coordinates (cost=0.00..499,356.24 rows=17,304,424 width=122) (actual time=0.028..2,800.437 rows=17,304,394 loops=1)

Planning time : 0.697 ms
Execution time : 42,432.599 ms