explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FCNc

Settings
# exclusive inclusive rows x rows loops node
1. 2.075 493,764.583 ↑ 1.0 2,000 1

Limit (cost=12,752,863.01..12,752,868.01 rows=2,000 width=380) (actual time=493,761.519..493,764.583 rows=2,000 loops=1)

2. 48,459.843 493,762.508 ↑ 59,769.1 2,000 1

Sort (cost=12,752,863.01..13,051,708.37 rows=119,538,143 width=380) (actual time=493,761.515..493,762.508 rows=2,000 loops=1)

  • Sort Key: ts, id
  • Sort Method: top-N heapsort Memory: 738kB
3. 445,302.665 445,302.665 ↑ 1.0 119,525,240 1

Seq Scan on history (cost=0.00..5,601,024.85 rows=119,538,143 width=380) (actual time=0.031..445,302.665 rows=119,525,240 loops=1)

  • Filter: (completed = 0)
  • Rows Removed by Filter: 28740