explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D6Yj

Settings
# exclusive inclusive rows x rows loops node
1. 26.570 102.271 ↓ 1.1 59,200 1

Unique (cost=6,965.43..7,291.52 rows=55,282 width=26) (actual time=59.447..102.271 rows=59,200 loops=1)

2. 55.269 75.701 ↑ 1.0 65,219 1

Sort (cost=6,965.43..7,128.48 rows=65,219 width=26) (actual time=59.446..75.701 rows=65,219 loops=1)

  • Sort Key: account_id, entered_at DESC
  • Sort Method: external merge Disk: 2472kB
3. 20.432 20.432 ↑ 1.0 65,219 1

Seq Scan on journey (cost=0.00..1,750.19 rows=65,219 width=26) (actual time=0.007..20.432 rows=65,219 loops=1)

Planning time : 0.067 ms
Execution time : 115.295 ms