explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gG9w

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

Sort (cost=21,257,388.750..21,257,437.790 rows=19,615 width=1,128) (actual rows= loops=)

  • Sort Key: (lima_sierra(echo.sierra, victor_yankee.uniform)), (lima_sierra(echo.six_five, victor_yankee.victor_sierra)), (lima_sierra(echo.india, victor_yankee.four_yankee))
2.          

CTE victor_yankee

3. 0.000 0.000 ↓ 0.0

Subquery Scan on charlie_hotel (cost=10,623,739.550..10,625,905.140 rows=19,250 width=283) (actual rows= loops=)

  • Filter: (charlie_hotel.juliet_xray < 2)
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=10,623,739.550..10,625,183.280 rows=57,749 width=287) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=10,623,739.550..10,623,883.920 rows=57,749 width=279) (actual rows= loops=)

  • Sort Key: romeo.november, romeo.bravo, romeo.zulu_juliet DESC
6. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..10,619,172.320 rows=57,749 width=279) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Result (cost=0.000..10,612,638.050 rows=24,063 width=279) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=0.000..10,612,397.420 rows=24,063 width=279) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on four_xray romeo (cost=0.000..10.710 rows=1 width=492) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on four_november victor_echo (cost=0.000..1,177,257.940 rows=3,563 width=279) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on papa_mike quebec (cost=0.000..2,055,905.240 rows=3,869 width=278) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on alpha_whiskey oscar_two (cost=0.000..2,922,415.230 rows=5,180 width=279) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on charlie_alpha alpha_charlie (cost=0.000..3,143,047.880 rows=5,749 width=279) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on xray mike (cost=0.000..1,313,749.710 rows=5,700 width=279) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on three oscar_papa (cost=0.000..10.710 rows=1 width=492) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'juliet_two'::text))
16.          

CTE echo

17. 0.000 0.000 ↓ 0.0

Subquery Scan on lima_echo (cost=10,623,943.620..10,626,150.270 rows=19,615 width=382) (actual rows= loops=)

  • Filter: (golf1.juliet_xray < 2)
18. 0.000 0.000 ↓ 0.0

WindowAgg (cost=10,623,943.620..10,625,414.720 rows=58,844 width=386) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Sort (cost=10,623,943.620..10,624,090.730 rows=58,844 width=378) (actual rows= loops=)

  • Sort Key: six_lima7.november, six_lima7.bravo, six_lima7.zulu_juliet DESC
20. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..10,619,281.820 rows=58,844 width=378) (actual rows= loops=)

  • Workers Planned: 2
21. 0.000 0.000 ↓ 0.0

Result (cost=0.000..10,612,642.610 rows=24,519 width=378) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Append (cost=0.000..10,612,397.420 rows=24,519 width=378) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on four_xray seven (cost=0.000..10.710 rows=1 width=492) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
24. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on four_november six_four (cost=0.000..1,177,257.940 rows=3,500 width=378) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
25. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on papa_mike lima_charlie (cost=0.000..2,055,905.240 rows=3,839 width=377) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
26. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on alpha_whiskey six_foxtrot (cost=0.000..2,922,415.230 rows=5,390 width=378) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on charlie_alpha charlie_india (cost=0.000..3,143,047.880 rows=5,940 width=378) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
28. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on xray victor_november (cost=0.000..1,313,749.710 rows=5,848 width=378) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
29. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on three tango (cost=0.000..10.710 rows=1 width=492) (actual rows= loops=)

  • Filter: ((kilo = 'papa_tango'::text) AND (lima_kilo = 'zulu_oscar'::text))
30. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=3,545.700..3,934.820 rows=19,615 width=1,128) (actual rows= loops=)

  • Merge Cond: ((victor_yankee.uniform = echo.sierra) AND (victor_yankee.victor_sierra = echo.six_five) AND (victor_yankee.four_yankee = echo.india))
31. 0.000 0.000 ↓ 0.0

Sort (cost=1,754.880..1,803.010 rows=19,250 width=496) (actual rows= loops=)

  • Sort Key: victor_yankee.uniform, victor_yankee.victor_sierra, victor_yankee.four_yankee
32. 0.000 0.000 ↓ 0.0

CTE Scan on victor_yankee (cost=0.000..385.000 rows=19,250 width=496) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Sort (cost=1,790.820..1,839.850 rows=19,615 width=496) (actual rows= loops=)

  • Sort Key: echo.sierra, echo.six_five, echo.india
34. 0.000 0.000 ↓ 0.0

CTE Scan on echo (cost=0.000..392.300 rows=19,615 width=496) (actual rows= loops=)