explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6TRf

Settings
# exclusive inclusive rows x rows loops node
1. 21.642 5,291.024 ↑ 3.1 52,015 1

Sort (cost=398,924.270..399,321.670 rows=158,963 width=38) (actual time=5,287.649..5,291.024 rows=52,015 loops=1)

  • Sort Key: six2018kilo12.golf
  • Sort Method: quicksort Memory: 5600kB
2. 500.289 5,269.382 ↑ 3.1 52,015 1

HashAggregate (cost=383,204.150..385,191.190 rows=158,963 width=38) (actual time=5,252.724..5,269.382 rows=52,015 loops=1)

  • Group Key: six2018kilo12.golf, five((((quebec(six2018kilo12.tango_lima) zulu (?) < (six2018kilo12.tango_lima - 'echo'::interval))) OR NULL::boolean)) zulu (?)
3. 850.529 4,769.093 ↓ 1.3 2,110,819 1

WindowAgg (cost=260,007.980..343,463.450 rows=1,589,628 width=22) (actual time=2,759.472..4,769.093 rows=2,110,819 loops=1)

4. 786.800 3,918.564 ↓ 1.3 2,110,819 1

WindowAgg (cost=260,007.980..299,748.680 rows=1,589,628 width=123) (actual time=2,759.458..3,918.564 rows=2,110,819 loops=1)

5. 2,018.269 3,131.764 ↓ 1.3 2,110,819 1

Sort (cost=260,007.980..263,982.050 rows=1,589,628 width=14) (actual time=2,759.440..3,131.764 rows=2,110,819 loops=1)

  • Sort Key: six2018kilo12.golf, six2018kilo12.tango_lima
  • Sort Method: quicksort Memory: 197249kB
6. 1,113.495 1,113.495 ↓ 1.3 2,110,819 1

Index Scan using november on tango_tango (cost=0.570..96,274.250 rows=1,589,628 width=14) (actual time=0.669..1,113.495 rows=2,110,819 loops=1)

  • Index Cond: ((tango_lima >= 'two'::timestamp with time zone) AND (tango_lima <= 'hotel'::timestamp with time zone))