explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nWD4

Settings
# exclusive inclusive rows x rows loops node
1. 170.095 170.095 ↑ 1.0 35,016 1

CTE Scan on hotel (cost=9,326.930..10,037.490 rows=35,528 width=274) (actual time=109.467..170.095 rows=35,016 loops=1)

2.          

CTE hotel

3. 25.087 159.105 ↑ 1.0 35,016 1

WindowAgg (cost=7,328.480..9,326.930 rows=35,528 width=66) (actual time=109.466..159.105 rows=35,016 loops=1)

4. 14.781 134.018 ↑ 1.0 35,016 1

WindowAgg (cost=7,328.480..8,127.860 rows=35,528 width=54) (actual time=109.439..134.018 rows=35,016 loops=1)

5. 97.411 119.237 ↑ 1.0 35,016 1

Sort (cost=7,328.480..7,417.300 rows=35,528 width=46) (actual time=109.426..119.237 rows=35,016 loops=1)

  • Sort Key: delta_juliet.zulu, delta_juliet.victor, delta_juliet.delta_lima
  • Sort Method: external merge Disk: 2136kB
6. 21.826 21.826 ↑ 1.0 35,016 1

Index Scan using four on delta_juliet (cost=0.450..4,643.160 rows=35,528 width=46) (actual time=0.029..21.826 rows=35,016 loops=1)

  • Index Cond: ((delta_lima >= ((CURRENT_DATE - 'foxtrot'::interval))::date) AND (delta_lima <= CURRENT_DATE))