explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8ImL

Settings
# exclusive inclusive rows x rows loops node
1. 6.110 24,073.217 ↑ 2.5 34 1

Subquery Scan on quebec (cost=542,990.920..543,546.930 rows=86 width=70) (actual time=24,036.934..24,073.217 rows=34 loops=1)

  • Output: quebec.sierra_kilo, quebec.lima, quebec.sierra_papa_mike, quebec.sierra_delta, quebec.golf, quebec.juliet_romeo, quebec.sierra_papa_lima, quebec.mike, quebec.india
  • Filter: (quebec.india = 1)
  • Rows Removed by Filter: 20,254
2. 22.008 24,067.107 ↓ 1.2 20,288 1

WindowAgg (cost=542,990.920..543,333.080 rows=17,108 width=70) (actual time=24,036.923..24,067.107 rows=20,288 loops=1)

  • Output: delta.sierra_kilo, delta.lima, delta.sierra_papa_mike, delta.sierra_delta, delta.golf, delta.juliet_romeo, delta.sierra_papa_lima, delta.whiskey, five() zulu (?)
3. 95.696 24,045.099 ↓ 1.2 20,288 1

Sort (cost=542,990.920..543,033.690 rows=17,108 width=62) (actual time=24,036.899..24,045.099 rows=20,288 loops=1)

  • Output: delta.sierra_papa_mike, delta.whiskey, delta.sierra_kilo, delta.lima, delta.sierra_delta, delta.golf, delta.juliet_romeo, delta.sierra_papa_lima
  • Sort Key: delta.sierra_papa_mike, delta.whiskey DESC
  • Sort Method: quicksort Memory: 2,701kB
4. 23,949.403 23,949.403 ↓ 1.2 20,288 1

Seq Scan on three (cost=0.000..541,788.030 rows=17,108 width=62) (actual time=6,874.651..23,949.403 rows=20,288 loops=1)

  • Output: delta.sierra_papa_mike, delta.whiskey, delta.sierra_kilo, delta.lima, delta.sierra_delta, delta.golf, delta.juliet_romeo, delta.sierra_papa_lima
  • Filter: ((delta.juliet_romeo <> 'november'::double precision) AND (delta.sierra_papa_lima <> 'november'::double precision) AND (delta.whiskey >= (('juliet_five'::cstring)::timestamp without time zone - 'seven'::interval)))
  • Rows Removed by Filter: 14,315,061
Planning time : 0.789 ms