explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nrPc2

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

HashAggregate (cost=38.040..38.130 rows=9 width=60) (actual rows= loops=)

  • Group Key: foxtrot.quebec_seven, six_echo.xray_hotel, foxtrot.november, alpha.tango, six_echo.quebec_seven, six_echo.echo, six_echo.charlie, six_echo.five, six_echo.two, six_echo.xray_hotel
2. 0.000 0.000 ↓ 0.0

Append (cost=1.630..37.810 rows=9 width=60) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.630..7.420 rows=1 width=49) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.490..7.020 rows=1 width=45) (actual rows= loops=)

  • Join Filter: (six_echo.two = foxtrot.quebec_seven)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.210..6.440 rows=1 width=45) (actual rows= loops=)

  • Join Filter: (six_echo.five < six_papa.uniform_uniform)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.070..5.790 rows=2 width=17) (actual rows= loops=)

  • Hash Cond: (alpha.two = six_papa.two)
7. 0.000 0.000 ↓ 0.0

Seq Scan on alpha (cost=0.000..4.160 rows=216 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=1.030..1.030 rows=3 width=9) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on six_papa (cost=0.000..1.030 rows=3 width=9) (actual rows= loops=)

  • Filter: yankee
10. 0.000 0.000 ↓ 0.0

Index Scan using quebec_foxtrot on six_echo (cost=0.140..0.310 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (two = alpha.two)
11. 0.000 0.000 ↓ 0.0

Index Scan using mike on foxtrot (cost=0.270..0.570 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = alpha.two)
12. 0.000 0.000 ↓ 0.0

Index Only Scan using golf on papa_alpha_zulu_alpha (cost=0.140..0.390 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (quebec_seven = six_echo.xray_hotel)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.630..13.180 rows=3 width=49) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.490..11.990 rows=3 width=45) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.210..9.720 rows=4 width=41) (actual rows= loops=)

  • Join Filter: (xray_india1.five < uniform_victor1.uniform_uniform)
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.070..5.840 rows=12 width=13) (actual rows= loops=)

  • Hash Cond: (lima1.tango = uniform_victor1.tango)
17. 0.000 0.000 ↓ 0.0

Seq Scan on alpha oscar_victor (cost=0.000..4.160 rows=216 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=1.030..1.030 rows=3 width=9) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on six_papa kilo_romeo (cost=0.000..1.030 rows=3 width=9) (actual rows= loops=)

  • Filter: yankee
20. 0.000 0.000 ↓ 0.0

Index Scan using quebec_foxtrot on six_echo oscar_mike (cost=0.140..0.310 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (two = lima1.two)
21. 0.000 0.000 ↓ 0.0

Index Scan using mike on foxtrot sierra (cost=0.270..0.570 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = lima1.two)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using golf on papa_alpha_zulu_alpha papa_alpha_zulu_hotel (cost=0.140..0.390 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (quebec_seven = xray_india1.xray_hotel)
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.910..17.080 rows=5 width=49) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.640..13.670 rows=6 width=41) (actual rows= loops=)

  • Hash Cond: (lima2.two = xray_india2.two)
25. 0.000 0.000 ↓ 0.0

Seq Scan on alpha juliet (cost=0.000..4.160 rows=216 width=8) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Hash (cost=8.560..8.560 rows=6 width=33) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on six_echo seven (cost=0.000..8.560 rows=6 width=33) (actual rows= loops=)

  • Filter: (five < 'kilo_tango'::numeric)
28. 0.000 0.000 ↓ 0.0

Index Scan using mike on foxtrot oscar_bravo (cost=0.270..0.570 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = lima2.two)