explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rEih

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 72.718 ↑ 1.0 20 1

Limit (cost=7,895.16..7,895.21 rows=20 width=232) (actual time=72.713..72.718 rows=20 loops=1)

2. 44.071 72.714 ↑ 5,644.9 20 1

Sort (cost=7,895.16..8,177.40 rows=112,898 width=232) (actual time=72.712..72.714 rows=20 loops=1)

  • Sort Key: effective_date DESC, slug
  • Sort Method: top-N heapsort Memory: 33kB
3. 28.643 28.643 ↓ 1.0 112,899 1

Seq Scan on herald_article (cost=0.00..4,890.98 rows=112,898 width=232) (actual time=0.006..28.643 rows=112,899 loops=1)

Planning time : 0.474 ms
Execution time : 72.743 ms