explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V1yi

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 5,751.532 ↑ 1.0 10 1

Limit (cost=196,293.34..196,293.37 rows=10 width=54) (actual time=5,751.525..5,751.532 rows=10 loops=1)

2.          

CTE x

3. 2,610.315 2,610.315 ↑ 2.1 1,697,327 1

Seq Scan on os_codepo_gb (cost=0.00..91,699.30 rows=3,521,304 width=24) (actual time=1.954..2,610.315 rows=1,697,327 loops=1)

4. 0.039 5,751.524 ↑ 117,376.8 10 1

Sort (cost=104,594.04..107,528.46 rows=1,173,768 width=54) (actual time=5,751.522..5,751.524 rows=10 loops=1)

  • Sort Key: x.distance
  • Sort Method: top-N heapsort Memory: 26kB
5. 5,751.485 5,751.485 ↑ 48,907.0 24 1

CTE Scan on x (cost=0.00..79,229.34 rows=1,173,768 width=54) (actual time=264.512..5,751.485 rows=24 loops=1)

  • Filter: (distance <= '500'::double precision)
  • Rows Removed by Filter: 1697303