explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UyJx

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=497.730..497.830 rows=1 width=72) (actual rows= loops=)

  • Group Key: whiskey.zulu_india
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=497.730..497.770 rows=1 width=97) (actual rows= loops=)

  • Group Key: whiskey.four_mike, whiskey.zulu_india, four_uniform_quebec_yankee.three_delta, papa_delta.hotel_whiskey
3. 0.000 0.000 ↓ 0.0

Sort (cost=497.730..497.730 rows=1 width=48) (actual rows= loops=)

  • Sort Key: whiskey.zulu_india, four_uniform_quebec_yankee.three_delta, papa_delta.hotel_whiskey
4. 0.000 0.000 ↓ 0.0

Result (cost=2.260..497.720 rows=1 width=48) (actual rows= loops=)

  • One-Time Filter: ((victor('november_sierra'::text))::numeric = 'sierra'::numeric)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.260..497.720 rows=1 width=48) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.830..489.360 rows=1 width=56) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.410..480.960 rows=1 width=37) (actual rows= loops=)

  • Join Filter: (papa_delta.india = four_uniform_quebec_yankee.india)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.990..472.960 rows=1 width=57) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using uniform on romeo (cost=0.290..8.300 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((november_golf = 'four_uniform_quebec_six'::numeric) AND (four_mike = 'sierra'::numeric))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.710..464.650 rows=1 width=59) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using oscar on whiskey (cost=0.420..456.330 rows=1 width=38) (actual rows= loops=)

  • Index Cond: ((four_delta_victor = romeo.four_delta_victor) AND (four_mike = 'sierra'::numeric) AND (november_golf = 'four_uniform_quebec_six'::numeric))
  • Filter: (zulu_india = ANY ('lima'::numeric[]))
12. 0.000 0.000 ↓ 0.0

Index Scan using zulu_echo on papa_delta (cost=0.280..8.310 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((four_mike = 'sierra'::numeric) AND (india = CASE whiskey.charlie WHEN 'four_uniform_quebec_six'::numeric THEN whiskey.four_delta_two ELSE romeo.india END) AND (november_golf = 'four_uniform_quebec_six'::numeric))
13. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot on four_uniform_quebec_yankee (cost=0.420..7.990 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((three_juliet = 'three_golf'::numeric) AND (xray = whiskey.zulu_india) AND (four_mike = 'sierra'::numeric) AND (november_golf = 'four_uniform_quebec_six'::numeric))
14. 0.000 0.000 ↓ 0.0

Index Scan using hotel_tango on yankee (cost=0.420..8.380 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((four_mike = 'sierra'::numeric) AND (three_delta = four_uniform_quebec_yankee.three_delta) AND (november_golf = 'four_uniform_quebec_six'::numeric))
15. 0.000 0.000 ↓ 0.0

Index Scan using zulu_kilo on alpha (cost=0.420..8.340 rows=1 width=25) (actual rows= loops=)

  • Index Cond: ((four_mike = 'sierra'::numeric) AND (papa_quebec = yankee.papa_quebec) AND (november_golf = 'four_uniform_quebec_six'::numeric))