explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nIaf : TEMP

Settings
# exclusive inclusive rows x rows loops node
1. 83.990 4,670.139 ↑ 320.1 1,151 1

Subquery Scan on ss (cost=167,535.78..203,453.96 rows=368,392 width=17) (actual time=3,631.962..4,670.139 rows=1,151 loops=1)

  • Filter: (ss.pos < 4)
  • Rows Removed by Filter: 1104540
2. 786.209 4,586.149 ↓ 1.0 1,105,691 1

WindowAgg (cost=167,535.78..189,639.28 rows=1,105,175 width=25) (actual time=3,631.960..4,586.149 rows=1,105,691 loops=1)

3. 3,145.894 3,799.940 ↓ 1.0 1,105,691 1

Sort (cost=167,535.78..170,298.71 rows=1,105,175 width=17) (actual time=3,631.941..3,799.940 rows=1,105,691 loops=1)

  • Sort Key: temp_uk_new.district, temp_uk_new.price DESC
  • Sort Method: quicksort Memory: 105556kB
4. 654.046 654.046 ↓ 1.0 1,105,691 1

Seq Scan on temp_uk_new (cost=0.00..56,599.18 rows=1,105,175 width=17) (actual time=0.559..654.046 rows=1,105,691 loops=1)

  • Filter: (transfer_date >= '2016-10-01'::date)
  • Rows Removed by Filter: 770030