explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tSGn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=48,186,718.790..48,212,623.790 rows=10,362,000 width=38) (actual rows= loops=)

  • Sort Key: six2018kilo12.golf
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=46,849,772.140..46,979,297.140 rows=10,362,000 width=38) (actual rows= loops=)

  • Group Key: six2018kilo12.golf, five((((quebec(six2018kilo12.tango_lima) zulu (?) < (six2018kilo12.tango_lima - 'echo'::interval))) OR NULL::boolean)) zulu (?)
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=33,416,622.430..42,516,498.040 rows=173,330,964 width=22) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=33,416,622.430..37,749,896.530 rows=173,330,964 width=123) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=33,416,622.430..33,849,949.840 rows=173,330,964 width=14) (actual rows= loops=)

  • Sort Key: six2018kilo12.golf, six2018kilo12.tango_lima
6. 0.000 0.000 ↓ 0.0

Seq Scan on tango_tango (cost=0.000..7,792,914.640 rows=173,330,964 width=14) (actual rows= loops=)