explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oZqJ : plan2

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.372 ↑ 2.2 77 1

Subquery Scan on ss (cost=886.19..902.57 rows=168 width=17) (actual time=0.264..0.372 rows=77 loops=1)

  • Filter: (ss.pos < 4)
  • Rows Removed by Filter: 1
2. 0.091 0.356 ↑ 6.5 78 1

WindowAgg (cost=886.19..896.27 rows=504 width=25) (actual time=0.262..0.356 rows=78 loops=1)

3. 0.157 0.265 ↑ 6.5 78 1

Sort (cost=886.19..887.45 rows=504 width=17) (actual time=0.258..0.265 rows=78 loops=1)

  • Sort Key: temp_uk_new.district, temp_uk_new.price DESC
  • Sort Method: quicksort Memory: 30kB
4. 0.108 0.108 ↑ 6.5 78 1

Index Scan using tdtn on temp_uk_new (cost=0.43..863.57 rows=504 width=17) (actual time=0.016..0.108 rows=78 loops=1)

  • Index Cond: (transfer_date = '2016-10-01'::date)
Planning time : 0.154 ms
Execution time : 0.495 ms