explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tJ4n

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 222,379.467 ↑ 1.0 10 1

Limit (cost=2,728,481.77..2,728,481.79 rows=10 width=374) (actual time=222,379.458..222,379.467 rows=10 loops=1)

2. 31,151.302 222,379.459 ↑ 3,647,180.9 10 1

Sort (cost=2,728,481.77..2,819,661.29 rows=36,471,809 width=374) (actual time=222,379.457..222,379.459 rows=10 loops=1)

  • Sort Key: priority_queue
  • Sort Method: top-N heapsort Memory: 30kB
3. 191,228.157 191,228.157 ↓ 1.0 36,729,446 1

Seq Scan on outgoing_messages (cost=0.00..1,940,339.09 rows=36,471,809 width=374) (actual time=0.007..191,228.157 rows=36,729,446 loops=1)

Planning time : 0.162 ms
Execution time : 222,379.503 ms