explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rvAH

Settings
# exclusive inclusive rows x rows loops node
1. 4,893.237 26,382.791 ↑ 1.0 1 1

Aggregate (cost=27.68..27.69 rows=1 width=36) (actual time=26,382.790..26,382.791 rows=1 loops=1)

2. 21,489.554 21,489.554 ↓ 21,621.4 21,513,341 1

Function Scan on pg_freespace (cost=0.25..12.75 rows=995 width=2) (actual time=18,618.200..21,489.554 rows=21,513,341 loops=1)

  • Filter: (avail <> 0)
  • Rows Removed by Filter: 1,159,478
Planning time : 0.078 ms
Execution time : 26,563.925 ms