explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l1o3

Settings
# exclusive inclusive rows x rows loops node
1. 68.853 81.962 ↓ 1.0 81,952 1

Sort (cost=15,829.88..16,034.64 rows=81,902 width=162) (actual time=66.452..81.962 rows=81,952 loops=1)

  • Sort Key: unread_by_sales_agent DESC
  • Sort Method: external merge Disk: 9,856kB
2. 13.109 13.109 ↓ 1.0 81,952 1

Seq Scan on candidate_message_threads (cost=0.00..2,426.02 rows=81,902 width=162) (actual time=0.009..13.109 rows=81,952 loops=1)

Planning time : 0.068 ms
Execution time : 101.359 ms