explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ks3Q : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.644 ↑ 9.2 77 1

Subquery Scan on ss (cost=3,689.60..3,758.86 rows=710 width=17) (actual time=0.544..0.644 rows=77 loops=1)

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

WindowAgg (cost=3,689.60..3,732.22 rows=2,131 width=25) (actual time=0.543..0.630 rows=78 loops=1)

3. 0.152 0.539 ↑ 27.3 78 1

Sort (cost=3,689.60..3,694.93 rows=2,131 width=17) (actual time=0.532..0.539 rows=78 loops=1)

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

Index Scan using tdtn on temp_uk_new (cost=0.43..3,571.79 rows=2,131 width=17) (actual time=0.034..0.387 rows=78 loops=1)

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