# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.018 | 317.303 | ↓ 96.0 | 96 | 1 |
→
Limit (cost=34,285.160..34,285.410 rows=1 width=240) (actual time=316.774..317.303 rows=96 loops=1) |
2. | 0.551 | 317.285 | ↓ 96.0 | 96 | 1 |
→
Result (cost=34,285.160..34,285.410 rows=1 width=240) (actual time=316.767..317.285 rows=96 loops=1) |
3. | 5.198 | 316.734 | ↓ 96.0 | 96 | 1 |
→
Sort (cost=34,285.160..34,285.170 rows=1 width=425) (actual time=316.719..316.734 rows=96 loops=1)
|
4. | 16.819 | 311.536 | ↓ 4,130.0 | 4,130 | 1 |
→
WindowAgg (cost=163.220..34,285.150 rows=1 width=425) (actual time=301.087..311.536 rows=4,130 loops=1) |
5. | 3.380 | 294.717 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop (cost=163.220..34,285.090 rows=1 width=372) (actual time=1.696..294.717 rows=4,130 loops=1) |
6. | 2.228 | 233.517 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop (cost=159.780..34,281.620 rows=1 width=339) (actual time=1.651..233.517 rows=4,130 loops=1) |
7. | 1.941 | 185.859 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop Left Join (cost=155.280..34,277.090 rows=1 width=275) (actual time=1.619..185.859 rows=4,130 loops=1)
|
8. | 3.829 | 183.918 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop Left Join (cost=155.280..34,277.080 rows=1 width=267) (actual time=1.618..183.918 rows=4,130 loops=1) |
9. | 2.017 | 167.699 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop Left Join (cost=154.870..34,276.640 rows=1 width=262) (actual time=1.563..167.699 rows=4,130 loops=1) |
10. | 4.283 | 145.032 | ↓ 4,130.0 | 4,130 | 1 |
→
Nested Loop (cost=154.450..34,276.160 rows=1 width=254) (actual time=1.549..145.032 rows=4,130 loops=1) |
11. | 1.259 | 62.279 | ↓ 3.1 | 4,130 | 1 |
→
Nested Loop (cost=147.730..25,410.320 rows=1,312 width=855) (actual time=1.424..62.279 rows=4,130 loops=1) |
12. | 1.670 | 44.500 | ↓ 1.3 | 4,130 | 1 |
→
Nested Loop (cost=147.310..22,298.720 rows=3,081 width=850) (actual time=1.408..44.500 rows=4,130 loops=1) |
13. | 2.283 | 3.365 | ↓ 1.1 | 7,893 | 1 |
→
Bitmap Heap Scan on golf charlie (cost=146.880..5,872.020 rows=6,988 width=4) (actual time=1.112..3.365 rows=7,893 loops=1)
|
14. | 1.082 | 1.082 | ↓ 1.1 | 7,893 | 1 |
→
Bitmap Index Scan on sierra_charlie (cost=0.000..145.140 rows=6,988 width=0) (actual time=1.082..1.082 rows=7,893 loops=1)
|
15. | 39.465 | 39.465 | ↑ 1.0 | 1 | 7,893 |
→
Index Scan using mike_romeo on romeo_xray alpha (cost=0.420..2.340 rows=1 width=846) (actual time=0.005..0.005 rows=1 loops=7,893)
|
16. | 16.520 | 16.520 | ↑ 1.0 | 1 | 4,130 |
→
Index Scan using sierra_victor on november_seven four_kilo (cost=0.420..1.000 rows=1 width=9) (actual time=0.004..0.004 rows=1 loops=4,130)
|
17. | 0.000 | 78.470 | ↑ 1.0 | 1 | 4,130 |
→
Subquery Scan on kilo (cost=6.730..6.750 rows=1 width=36) (actual time=0.019..0.019 rows=1 loops=4,130)
|
18. | 33.040 | 78.470 | ↑ 1.0 | 1 | 4,130 |
→
Aggregate (cost=6.730..6.740 rows=1 width=36) (actual time=0.019..0.019 rows=1 loops=4,130) |
19. | 8.241 | 45.430 | ↑ 7.3 | 3 | 4,130 |
→
Hash Join (cost=3.970..6.120 rows=22 width=64) (actual time=0.007..0.011 rows=3 loops=4,130)
|
20. | 12.351 | 37.170 | ↑ 7.3 | 3 | 4,130 |
→
Hash Join (cost=2.680..4.520 rows=22 width=68) (actual time=0.007..0.009 rows=3 loops=4,130)
|
21. | 24.780 | 24.780 | ↑ 20.0 | 5 | 4,130 |
→
Function Scan on sierra_papa echo_six (cost=0.000..1.000 rows=100 width=64) (actual time=0.005..0.006 rows=5 loops=4,130) |
22. | 0.016 | 0.039 | ↑ 1.0 | 22 | 1 |
→
Hash (cost=2.400..2.400 rows=22 width=8) (actual time=0.039..0.039 rows=22 loops=1)
|
23. | 0.023 | 0.023 | ↑ 1.0 | 22 | 1 |
→
Seq Scan on mike_four echo_tango (cost=0.000..2.400 rows=22 width=8) (actual time=0.009..0.023 rows=22 loops=1)
|
24. | 0.008 | 0.019 | ↑ 1.0 | 13 | 1 |
→
Hash (cost=1.130..1.130 rows=13 width=4) (actual time=0.019..0.019 rows=13 loops=1)
|
25. | 0.011 | 0.011 | ↑ 1.0 | 13 | 1 |
→
Seq Scan on two_whiskey echo_yankee (cost=0.000..1.130 rows=13 width=4) (actual time=0.009..0.011 rows=13 loops=1) |
26. | 20.650 | 20.650 | ↑ 1.0 | 1 | 4,130 |
→
Index Scan using four_four on echo_uniform juliet_foxtrot (cost=0.420..0.470 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=4,130)
|
27. | 12.390 | 12.390 | ↓ 0.0 | 0 | 4,130 |
→
Index Only Scan using juliet_zulu_oscar on yankee_foxtrot foxtrot_bravo (cost=0.410..0.430 rows=1 width=13) (actual time=0.003..0.003 rows=0 loops=4,130)
|
28. | 0.000 | 0.000 | ↓ 0.0 | 0 | 4,130 |
→
Result (cost=0.000..0.000 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=4,130)
|
29. | 8.260 | 45.430 | ↑ 1.0 | 1 | 4,130 |
→
Aggregate (cost=4.500..4.510 rows=1 width=64) (actual time=0.011..0.011 rows=1 loops=4,130) |
30. | 37.170 | 37.170 | ↑ 1.0 | 3 | 4,130 |
→
Index Scan using yankee_zulu on november_india (cost=0.420..4.490 rows=3 width=5) (actual time=0.004..0.009 rows=3 loops=4,130)
|
31. | 28.910 | 57.820 | ↑ 1.0 | 1 | 4,130 |
→
Aggregate (cost=3.440..3.450 rows=1 width=33) (actual time=0.014..0.014 rows=1 loops=4,130) |
32. | 28.910 | 28.910 | ↓ 2.5 | 5 | 4,130 |
→
Index Scan using juliet_zulu_charlie on zulu_india (cost=0.420..3.410 rows=2 width=32) (actual time=0.005..0.007 rows=5 loops=4,130)
|
Planning time | : | 6.816 ms |
---|---|---|
Execution time | : | 317.716 ms |