explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ETup

Settings
# exclusive inclusive rows x rows loops node
1. 584.697 50,928.425 ↑ 3,019.6 1,650 1

Subquery Scan on ss (cost=4,087,486.83..4,573,266.61 rows=4,982,357 width=17) (actual time=42,091.408..50,928.425 rows=1,650 loops=1)

  • Filter: (ss.pos < 4)
  • Rows Removed by Filter: 9862988
  • Buffers: shared hit=895139, temp read=102798 written=103016
2. 4,867.412 50,343.728 ↑ 1.5 9,864,638 1

WindowAgg (cost=4,087,486.83..4,386,428.23 rows=14,947,070 width=25) (actual time=42,091.406..50,343.728 rows=9,864,638 loops=1)

  • Buffers: shared hit=895139, temp read=102798 written=103016
3. 33,582.812 45,476.316 ↑ 1.5 9,864,638 1

Sort (cost=4,087,486.83..4,124,854.51 rows=14,947,070 width=17) (actual time=42,091.394..45,476.316 rows=9,864,638 loops=1)

  • Sort Key: uk_property_registry.district, uk_property_registry.price DESC
  • Sort Method: external merge Disk: 272856kB
  • Buffers: shared hit=895139, temp read=102798 written=103016
4. 6,902.454 11,893.504 ↑ 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,393.412..11,893.504 rows=9,864,638 loops=1)

  • Hash Cond: (uk_property_registry.transfer_date = uk_prop_date.transfer_date)
  • Buffers: shared hit=895139
5. 4,990.144 4,990.144 ↓ 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.013..4,990.144 rows=50,036,022 loops=1)

  • Buffers: shared hit=895098
6. 0.185 0.906 ↓ 1.0 1,827 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
  • Buffers: shared hit=41
7. 0.721 0.721 ↓ 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.721 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