explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pkf1 : fffffff

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

Sort (cost=1,302.430..1,302.440 rows=2 width=176) (actual rows= loops=)

  • Output: six_quebec.papa_oscar, six_quebec.hotel_victor, six_quebec.six_mike, ((((six_quebec.six_mike / six_quebec.hotel_victor) / 'whiskey'::numeric))::numeric(5,2)), six_quebec.quebec_whiskey, six_quebec.zulu_five, ((six_quebec.six_mike / six_quebec.hotel_victor))
  • Sort Key: ((six_quebec.six_mike / six_quebec.hotel_victor)) DESC
2.          

CTE six_quebec

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=835.990..1,013.790 rows=8,890 width=77) (actual rows= loops=)

  • Output: two.uniform_uniform, two.papa_oscar, two.hotel_victor, two.six_hotel, two.papa_tango, two.six_mike, two.quebec_whiskey, two.zulu_five, five_zulu() zulu_quebec (?)
4. 0.000 0.000 ↓ 0.0

Sort (cost=835.990..858.220 rows=8,890 width=69) (actual rows= loops=)

  • Output: two.uniform_uniform, two.zulu_five, two.papa_oscar, two.hotel_victor, two.six_hotel, two.papa_tango, two.six_mike, two.quebec_whiskey
  • Sort Key: two.uniform_uniform, two.zulu_five
5. 0.000 0.000 ↓ 0.0

Seq Scan on juliet (cost=0.000..252.900 rows=8,890 width=69) (actual rows= loops=)

  • Output: two.uniform_uniform, two.zulu_five, two.papa_oscar, two.hotel_victor, two.six_hotel, two.papa_tango, two.six_mike, two.quebec_whiskey
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=244.820..288.630 rows=2 width=176) (actual rows= loops=)

  • Output: six_quebec.papa_oscar, six_quebec.hotel_victor, six_quebec.six_mike, (((six_quebec.six_mike / six_quebec.hotel_victor) / 'whiskey'::numeric))::numeric(5,2), six_quebec.quebec_whiskey, six_quebec.zulu_five, (six_quebec.six_mike / six_quebec.hotel_victor)
  • Inner Unique: true
  • Join Filter: (((six_quebec.zulu_five - six_zulu.three))::numeric < 9861.75)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=244.540..282.770 rows=5 width=136) (actual rows= loops=)

  • Output: six_quebec.papa_oscar, six_quebec.hotel_victor, six_quebec.six_mike, six_quebec.quebec_whiskey, six_quebec.zulu_five, november.hotel_quebec
  • Hash Cond: (november.uniform_uniform = six_quebec.uniform_uniform)
8. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_seven november (cost=0.000..31.040 rows=1,904 width=18) (actual rows= loops=)

  • Output: november.uniform_uniform, november.hotel_quebec
9. 0.000 0.000 ↓ 0.0

Hash (cost=244.470..244.470 rows=5 width=164) (actual rows= loops=)

  • Output: six_quebec.papa_oscar, six_quebec.hotel_victor, six_quebec.six_mike, six_quebec.quebec_whiskey, six_quebec.zulu_five, six_quebec.uniform_uniform
10. 0.000 0.000 ↓ 0.0

CTE Scan on six_quebec (cost=0.000..244.470 rows=5 width=164) (actual rows= loops=)

  • Output: six_quebec.papa_oscar, six_quebec.hotel_victor, six_quebec.six_mike, six_quebec.quebec_whiskey, six_quebec.zulu_five, six_quebec.uniform_uniform
  • Filter: ((six_quebec.hotel_victor >= 'charlie'::numeric) AND (six_quebec.zulu_five >= 'lima_yankee'::date) AND (six_quebec.victor_mike = 3))
11. 0.000 0.000 ↓ 0.0

Index Scan using mike_zulu on seven_quebec six_zulu (cost=0.280..1.150 rows=1 width=8) (actual rows= loops=)

  • Output: six_zulu.mike_xray, six_zulu.seven_golf, six_zulu.kilo, six_zulu.three, six_zulu.foxtrot, six_zulu.uniform_seven, six_zulu.quebec_bravo, six_zulu.five_delta, six_zulu.oscar, six_zulu.victor_seven, six_zulu.five_sierra, six_zulu.bravo, six_zulu.lima_zulu, six_zulu.lima_four