explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S6CN

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

CTE Scan on hotel (cost=4,954.030..5,664.590 rows=35,528 width=16) (actual time=0.142..30.163 rows=35,016 loops=1)

2.          

CTE hotel

3. 23.933 23.933 ↑ 1.0 35,016 1

Index Scan using four on delta_juliet (cost=0.450..4,954.030 rows=35,528 width=16) (actual time=0.137..23.933 rows=35,016 loops=1)

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