explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hfxe : plan2

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.959 ↑ 9.1 77 1

Subquery Scan on ss (cost=3,702.99..3,771.34 rows=701 width=18) (actual time=0.860..0.959 rows=77 loops=1)

  • Filter: (ss.pos < 4)
  • Rows Removed by Filter: 1
2. 0.094 0.945 ↑ 27.0 78 1

WindowAgg (cost=3,702.99..3,745.05 rows=2,103 width=26) (actual time=0.859..0.945 rows=78 loops=1)

3. 0.157 0.851 ↑ 27.0 78 1

Sort (cost=3,702.99..3,708.25 rows=2,103 width=18) (actual time=0.845..0.851 rows=78 loops=1)

  • Sort Key: temp_uk_new1.district, temp_uk_new1.price DESC
  • Sort Method: quicksort Memory: 30kB
4. 0.694 0.694 ↑ 27.0 78 1

Index Scan using tdtn on temp_uk_new1 (cost=0.43..3,586.92 rows=2,103 width=18) (actual time=0.033..0.694 rows=78 loops=1)

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