explain.depesz.com

PostgreSQL's explain analyze made readable

Result: la9Q : a

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

HashAggregate (cost=7,912.990..7,950.990 rows=1 width=178) (actual rows= loops=)

  • Group Key: hotel_romeo.quebec, hotel_romeo.tango, papa_foxtrot.november_lima, hotel_romeo.four, hotel_romeo.echo_lima, CASE WHEN (two.india_victor five NULL) THEN echo_bravo.quebec ELSE two.foxtrot_quebec END, CASE WHEN (uniform
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=681.670..7,912.970 rows=1 width=178) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=681.390..7,874.660 rows=1 width=186) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=680.960..1,407.380 rows=1 width=178) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=680.680..1,399.070 rows=1 width=132) (actual rows= loops=)

  • Join Filter: (victor_quebec.tango3 = hotel_romeo.tango)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=680.680..1,385.980 rows=1 width=124) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=680.400..1,384.860 rows=1 width=113) (actual rows= loops=)

  • Hash Cond: (two.xray = hotel_romeo.quebec)
  • Filter: ((two.india_victor = 0) OR (two.india_victor five NULL))
8. 0.000 0.000 ↓ 0.0

Seq Scan on golf two (cost=0.000..610.180 rows=25,118 width=28) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=678.240..678.240 rows=173 width=89) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using india_six on bravo hotel_romeo (cost=0.420..678.240 rows=173 width=89) (actual rows= loops=)

  • Index Cond: (tango = 1)
11. 0.000 0.000 ↓ 0.0

Index Scan using papa_november on papa_juliet papa_foxtrot (cost=0.280..1.110 rows=1 width=19) (actual rows= loops=)

  • Index Cond: ((quebec = hotel_romeo.tango) AND (quebec = 1))
12. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_juliet victor_quebec (cost=0.000..13.070 rows=1 width=16) (actual rows= loops=)

  • Filter: (tango3 = 1)
13. 0.000 0.000 ↓ 0.0

Index Scan using whiskey on hotel_bravo echo_bravo (cost=0.280..8.300 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (quebec = victor_quebec.foxtrot_quebec)
14. 0.000 0.000 ↓ 0.0

Index Only Scan using oscar on six romeo_romeo (cost=0.420..6,467.260 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (xray = hotel_romeo.quebec)
15. 0.000 0.000 ↓ 0.0

Index Scan using seven on hotel_sierra yankee (cost=0.280..0.310 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec = romeo_romeo.foxtrot_papa)
  • Filter: ((november_kilo)::text <> 'foxtrot_india'::text)
16.          

SubPlan (forNested Loop)

17. 0.000 0.000 ↓ 0.0

Index Scan using whiskey on hotel_bravo (cost=0.280..8.300 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (quebec = two.foxtrot_quebec)
18. 0.000 0.000 ↓ 0.0

Index Scan using whiskey on hotel_bravo delta (cost=0.280..8.300 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (quebec = two.foxtrot_quebec)
19. 0.000 0.000 ↓ 0.0

Index Scan using whiskey on hotel_bravo victor_yankee (cost=0.280..8.300 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (quebec = two.foxtrot_quebec)
20. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_juliet (cost=0.000..13.070 rows=1 width=8) (actual rows= loops=)

  • Filter: (tango3 = hotel_romeo.tango)