explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A6jo

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 5,584.565 ↑ 1.0 100 1

Limit (cost=162.88..163.33 rows=100 width=40) (actual time=5,584.523..5,584.565 rows=100 loops=1)

2. 0.036 5,584.556 ↑ 100.0 100 1

WindowAgg (cost=162.88..207.88 rows=10,000 width=40) (actual time=5,584.522..5,584.556 rows=100 loops=1)

3. 1,798.877 5,584.520 ↑ 100.0 100 1

Sort (cost=162.88..167.88 rows=10,000 width=32) (actual time=5,584.511..5,584.520 rows=100 loops=1)

  • Sort Key: word
  • Sort Method: quicksort Memory: 31587kB
4. 3,785.643 3,785.643 ↓ 41.0 409,668 1

Function Scan on ts_stat (cost=0.01..30.00 rows=10,000 width=32) (actual time=3,753.601..3,785.643 rows=409,668 loops=1)