explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XgGD

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

Sort (cost=9,967.170..9,969.670 rows=1,000 width=233) (actual rows= loops=)

  • Sort Key: (five_two(*)) DESC
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,286.530..9,917.340 rows=1,000 width=233) (actual rows= loops=)

  • Hash Cond: ((victor.zulu_november)::text = (romeo.four_three)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,254.130..9,866.200 rows=1,000 width=121) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,253.700..1,496.200 rows=1,000 width=40) (actual rows= loops=)

  • Group Key: lima_oscar(ARRAY[CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END, CASE WHEN ((CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) THEN CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END ELSE NULL::character varying END])
5. 0.000 0.000 ↓ 0.0

ProjectSet (cost=60.570..1,248.700 rows=1,000 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=60.570..1,241.320 rows=10 width=35) (actual rows= loops=)

  • Filter: (((two.mike)::text = 'four_uniform'::text) OR ((two1.mike)::text = 'four_uniform'::text) OR ((two2.mike)::text = 'four_uniform'::text) OR ((two3.mike)::text = 'four_uniform'::text) OR ((two4.mike)::text = 'four_uniform'::text) OR ((two5.mike)::text = 'four_uniform'::text) OR ((two6.mike)::text = 'four_uniform'::text) OR ((two7.mike)::text = 'four_uniform'::text))
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=60.140..1,156.520 rows=10 width=34) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59.710..1,071.920 rows=10 width=33) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59.270..987.320 rows=10 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=58.840..902.720 rows=10 width=31) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=58.410..818.120 rows=10 width=30) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=57.980..733.520 rows=10 width=29) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=57.550..648.920 rows=10 width=28) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Limit (cost=57.110..564.220 rows=10 width=27) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=57.110..76,251,909.110 rows=1,503,652 width=27) (actual rows= loops=)

  • Hash Cond: ((foxtrot_mike.three_uniform)::text = (lima_zulu.bravo)::text)
16. 0.000 0.000 ↓ 0.0

Seq Scan on three_xray foxtrot_mike (cost=0.000..65,550,082.200 rows=610,670,473 width=32) (actual rows= loops=)

  • Filter: ((oscar_november_victor)::text = 'four_uniform'::text)
17. 0.000 0.000 ↓ 0.0

Hash (cost=56.950..56.950 rows=13 width=6) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on three_papa lima_zulu (cost=0.000..56.950 rows=13 width=6) (actual rows= loops=)

  • Filter: ((golf)::text = (golf)::text)
19. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima two (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.foxtrot_kilo)::text = (papa_charlie)::text)
20. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima india_charlie (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.zulu_charlie)::text = (papa_charlie)::text)
21. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima india_alpha (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.hotel)::text = (papa_charlie)::text)
22. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima echo (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.quebec)::text = (papa_charlie)::text)
23. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima six (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.foxtrot_tango)::text = (papa_charlie)::text)
24. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima papa_quebec (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.november_uniform)::text = (papa_charlie)::text)
25. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima oscar_november_romeo (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.november_golf)::text = (papa_charlie)::text)
26. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_papa on whiskey_lima kilo (cost=0.430..8.450 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((foxtrot_mike.sierra)::text = (papa_charlie)::text)
27. 0.000 0.000 ↓ 0.0

Index Scan using whiskey_xray on three_romeo victor (cost=0.430..8.350 rows=1 width=92) (actual rows= loops=)

  • Index Cond: ((papa_charlie)::text = ((lima_oscar(ARRAY[CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END, CASE WHEN ((CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) THEN CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END ELSE NULL::character varying END, CASE WHEN (((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_kilo ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two1.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.zulu_charlie ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two2.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.hotel ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two3.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.quebec ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two7.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.sierra ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two5.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_uniform ELSE NULL::character varying END)::text) AND ((CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END)::text five_romeo DISTINCT FROM (CASE WHEN ((two6.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.november_golf ELSE NULL::character varying END)::text)) THEN CASE WHEN ((two4.mike)::text = 'four_uniform'::text) THEN foxtrot_mike.foxtrot_tango ELSE NULL::character varying END ELSE NULL::character varying END])))::text)
28. 0.000 0.000 ↓ 0.0

Hash (cost=21.620..21.620 rows=862 width=46) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_november romeo (cost=0.000..21.620 rows=862 width=46) (actual rows= loops=)