explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EBcg : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.081 1.625 ↑ 9.2 77 1

Subquery Scan on ss (cost=3,788.07..3,857.39 rows=711 width=18) (actual time=1.459..1.625 rows=77 loops=1)

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

WindowAgg (cost=3,788.07..3,830.73 rows=2,133 width=26) (actual time=1.457..1.544 rows=78 loops=1)

3. 0.159 1.450 ↑ 27.3 78 1

Sort (cost=3,788.07..3,793.40 rows=2,133 width=18) (actual time=1.443..1.450 rows=78 loops=1)

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

Index Scan using tdtn on temp_uk_new1 (cost=0.43..3,670.13 rows=2,133 width=18) (actual time=0.067..1.291 rows=78 loops=1)

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