# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 17.414 | 707.338 | ↑ 7.0 | 8,564 | 1 |
→
Merge Left Join (cost=9.870..15,596,686.590 rows=59,899 width=105) (actual time=9.634..707.338 rows=8,564 loops=1)
|
2. | 292.192 | 655.554 | ↑ 7.0 | 8,564 | 1 |
→
Merge Join (cost=9.600..13,584,784.650 rows=59,899 width=82) (actual time=0.102..655.554 rows=8,564 loops=1)
|
3. | 6.548 | 51.856 | ↑ 1.0 | 13,850 | 1 |
→
Nested Loop Left Join (cost=9.170..233,172.230 rows=13,850 width=61) (actual time=0.051..51.856 rows=13,850 loops=1)
|
4. | 8.760 | 17.608 | ↑ 1.0 | 13,850 | 1 |
→
Merge Join (cost=0.570..2,673.610 rows=13,850 width=53) (actual time=0.021..17.608 rows=13,850 loops=1)
|
5. | 4.522 | 4.522 | ↑ 1.0 | 13,850 | 1 |
→
Index Scan using whiskey on echo_lima november_echo (cost=0.290..1,242.840 rows=13,850 width=30) (actual time=0.010..4.522 rows=13,850 loops=1)
|
6. | 4.326 | 4.326 | ↑ 1.0 | 13,764 | 1 |
→
Index Scan using alpha_mike on uniform papa (cost=0.290..1,223.230 rows=13,764 width=23) (actual time=0.005..4.326 rows=13,764 loops=1)
|
7. | 0.000 | 27.700 | ↓ 0.0 | 0 | 13,850 |
→
Limit (cost=8.600..16.620 rows=1 width=4,304) (actual time=0.002..0.002 rows=0 loops=13,850)
|
8. |
Initplan (for Limit) |
|||||
9. | 0.000 | 27.700 | ↑ 1.0 | 1 | 13,850 |
→
Result (cost=8.310..8.320 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=13,850)
|
10. |
Initplan (for Result) |
|||||
11. | 13.850 | 27.700 | ↓ 0.0 | 0 | 13,850 |
→
Limit (cost=0.290..8.310 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=13,850)
|
12. | 13.850 | 13.850 | ↓ 0.0 | 0 | 13,850 |
→
Index Only Scan using whiskey on echo_lima alpha_seven (cost=0.290..8.310 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=13,850)
|
13. | 0.000 | 0.000 | ↓ 0.0 | 0 | 13,850 |
→
Index Scan using whiskey on echo_lima quebec (cost=0.290..8.300 rows=1 width=4,304) (actual time=0.000..0.000 rows=0 loops=13,850)
|
14. | 149.407 | 149.407 | ↓ 1.3 | 677,876 | 1 |
→
Index Scan using xray_seven on kilo_alpha sierra (cost=0.420..38,679.670 rows=527,356 width=26) (actual time=0.008..149.407 rows=677,876 loops=1)
|
15. |
SubPlan (for Merge Join) |
|||||
16. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using bravo on victor delta_whiskey (cost=0.420..8.440 rows=1 width=0) (never executed)
|
|
17. | 52.971 | 152.109 | ↑ 136.0 | 1 | 1 |
→
Gather (cost=1,000.000..12,087.300 rows=136 width=13) (actual time=49.808..152.109 rows=1 loops=1)
|
18. | 99.138 | 99.138 | ↓ 0.0 | 0 | 3 |
→
Parallel Seq Scan on victor delta_bravo (cost=0.000..11,073.700 rows=57 width=13) (actual time=65.126..99.138 rows=0 loops=3)
|
19. | 8.820 | 8.820 | ↓ 0.0 | 0 | 8,820 |
→
Index Only Scan using whiskey on echo_lima six (cost=0.290..8.300 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=8,820)
|
20. | 0.390 | 1.170 | ↑ 1.0 | 1 | 390 |
→
Aggregate (cost=8.310..8.320 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=390)
|
21. | 0.780 | 0.780 | ↓ 2.0 | 2 | 390 |
→
Index Scan using whiskey on echo_lima charlie (cost=0.290..8.300 rows=1 width=8) (actual time=0.002..0.002 rows=2 loops=390)
|
22. | 0.098 | 0.301 | ↓ 2.9 | 892 | 1 |
→
Materialize (cost=0.270..37.700 rows=312 width=32) (actual time=0.124..0.301 rows=892 loops=1)
|
23. | 0.203 | 0.203 | ↑ 1.0 | 312 | 1 |
→
Index Scan using juliet on mike_whiskey mike_juliet (cost=0.270..36.920 rows=312 width=32) (actual time=0.113..0.203 rows=312 loops=1)
|
24. |
SubPlan (for Merge Left Join) |
|||||
25. | 0.000 | 2.412 | ↑ 1.0 | 1 | 1,206 |
→
Result (cost=8.290..8.300 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,206)
|
26. |
Initplan (for Result) |
|||||
27. | 0.000 | 2.412 | ↑ 1.0 | 1 | 1,206 |
→
Limit (cost=0.270..8.290 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,206)
|
28. | 2.412 | 2.412 | ↑ 1.0 | 1 | 1,206 |
→
Index Only Scan using juliet on mike_whiskey golf_six (cost=0.270..8.290 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,206)
|
29. | 0.280 | 0.280 | ↑ 1.0 | 1 | 140 |
→
Index Scan using alpha_mike on uniform tango (cost=0.290..8.300 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=140)
|
30. | 0.282 | 0.282 | ↑ 1.0 | 1 | 141 |
→
Index Scan using alpha_mike on uniform foxtrot (cost=0.290..8.300 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=141)
|
31. | 0.000 | 8.271 | ↑ 1.0 | 1 | 919 |
→
Aggregate (cost=8.310..8.320 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=919)
|
32. | 8.271 | 8.271 | ↑ 1.0 | 1 | 919 |
→
Index Scan using alpha_kilo on romeo_four xray_india (cost=0.290..8.310 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=919)
|
33. | 2.853 | 22.824 | ↑ 1.0 | 1 | 2,853 |
→
Aggregate (cost=8.310..8.320 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=2,853)
|
34. | 19.971 | 19.971 | ↑ 1.0 | 1 | 2,853 |
→
Index Scan using alpha_kilo on romeo_four november_five (cost=0.290..8.310 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=2,853)
|
Planning time | : | 4.972 ms |
---|---|---|
Execution time | : | 711.724 ms |