explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KqNM

Settings
# exclusive inclusive rows x rows loops node
1. 607.410 48,965.489 ↑ 3,019.6 1,650 1

Subquery Scan on ss (cost=3,474,419.83..3,960,199.61 rows=4,982,357 width=17) (actual time=41,191.268..48,965.489 rows=1,650 loops=1)

  • Filter: (ss.pos < 4)
  • Rows Removed by Filter: 9862988
  • Buffers: shared hit=895139
2. 5,236.313 48,358.079 ↑ 1.5 9,864,638 1

WindowAgg (cost=3,474,419.83..3,773,361.23 rows=14,947,070 width=25) (actual time=41,191.265..48,358.079 rows=9,864,638 loops=1)

  • Buffers: shared hit=895139
3. 31,330.205 43,121.766 ↑ 1.5 9,864,638 1

Sort (cost=3,474,419.83..3,511,787.51 rows=14,947,070 width=17) (actual time=41,191.242..43,121.766 rows=9,864,638 loops=1)

  • Sort Key: uk_property_registry.district, uk_property_registry.price DESC
  • Sort Method: quicksort Memory: 910977kB
  • Buffers: shared hit=895139
4. 6,810.830 11,791.561 ↑ 1.5 9,864,638 1

Hash Semi Join (cost=200.65..1,693,225.38 rows=14,947,070 width=17) (actual time=2,295.988..11,791.561 rows=9,864,638 loops=1)

  • Hash Cond: (uk_property_registry.transfer_date = uk_prop_date.transfer_date)
  • Buffers: shared hit=895139
5. 4,979.833 4,979.833 ↓ 1.0 50,036,022 1

Seq Scan on uk_property_registry (cost=0.00..1,395,407.36 rows=50,030,936 width=21) (actual time=0.009..4,979.833 rows=50,036,022 loops=1)

  • Buffers: shared hit=895098
6. 0.182 0.898 ↓ 1.0 1,827 1

Hash (cost=177.83..177.83 rows=1,826 width=4) (actual time=0.898..0.898 rows=1,827 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
  • Buffers: shared hit=41
7. 0.716 0.716 ↓ 1.0 1,827 1

Seq Scan on uk_prop_date (cost=0.00..177.83 rows=1,826 width=4) (actual time=0.007..0.716 rows=1,827 loops=1)

  • Filter: ((transfer_date >= '2005-01-01'::date) AND (transfer_date <= '2010-01-01'::date))
  • Rows Removed by Filter: 7295
  • Buffers: shared hit=41