# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1,558.332 | 105,694.731 | ↓ 24.1 | 90,103 | 1 |
→
Sort (cost=584,260.920..584,270.270 rows=3,739 width=1,151) (actual time=105,508.807..105,694.731 rows=90,103 loops=1)
|
2. | 81,378.767 | 104,136.399 | ↓ 24.1 | 90,103 | 1 |
→
Nested Loop (cost=6,287.610..582,159.540 rows=3,739 width=1,151) (actual time=229.164..104,136.399 rows=90,103 loops=1) |
3. | 22.044 | 22.044 | ↑ 1.0 | 1 | 1 |
→
Index Scan using bravo_yankee on kilo_foxtrot tango_mike (cost=0.430..8.450 rows=1 width=16) (actual time=22.033..22.044 rows=1 loops=1)
|
4. | 157.239 | 9,850.859 | ↓ 24.1 | 90,103 | 1 |
→
Hash Left Join (cost=6,287.180..52,481.850 rows=3,739 width=424) (actual time=203.746..9,850.859 rows=90,103 loops=1)
|
5. | 252.436 | 9,633.887 | ↓ 24.1 | 90,103 | 1 |
→
Nested Loop (cost=5,166.400..51,300.300 rows=3,739 width=408) (actual time=143.993..9,633.887 rows=90,103 loops=1)
|
6. | 212.079 | 7,579.391 | ↓ 23.5 | 90,103 | 1 |
→
Nested Loop (cost=5,166.150..51,204.270 rows=3,831 width=398) (actual time=143.851..7,579.391 rows=90,103 loops=1) |
7. | 4,619.147 | 4,754.325 | ↓ 23.2 | 90,103 | 1 |
→
Bitmap Heap Scan on uniform_hotel november_mike (cost=5,165.720..20,263.930 rows=3,879 width=358) (actual time=143.780..4,754.325 rows=90,103 loops=1)
|
8. | 2.053 | 135.178 | ↓ 0.0 | 0 | 1 |
→
BitmapAnd (cost=5,165.720..5,165.720 rows=4,226 width=0) (actual time=135.178..135.178 rows=0 loops=1) |
9. | 52.700 | 52.700 | ↓ 1.0 | 90,103 | 1 |
→
Bitmap Index Scan on papa (cost=0.000..1,635.060 rows=88,351 width=0) (actual time=52.700..52.700 rows=90,103 loops=1)
|
10. | 80.425 | 80.425 | ↓ 1.0 | 198,057 | 1 |
→
Bitmap Index Scan on lima_oscar (cost=0.000..3,528.460 rows=190,938 width=0) (actual time=80.425..80.425 rows=198,057 loops=1)
|
11. | 2,612.987 | 2,612.987 | ↑ 1.0 | 1 | 90,103 |
→
Index Scan using echo_romeo on tango_six juliet (cost=0.430..7.970 rows=1 width=48) (actual time=0.028..0.029 rows=1 loops=90,103)
|
12. | 1,802.060 | 1,802.060 | ↑ 1.0 | 1 | 90,103 |
→
Function Scan on charlie_papa lima_four (cost=0.250..0.260 rows=1 width=33) (actual time=0.019..0.020 rows=1 loops=90,103) |
13. | 0.181 | 59.733 | ↑ 1.3 | 241 | 1 |
→
Hash (cost=1,116.910..1,116.910 rows=310 width=24) (actual time=59.733..59.733 rows=241 loops=1)
|
14. | 38.082 | 59.552 | ↑ 1.3 | 241 | 1 |
→
Bitmap Heap Scan on foxtrot_three uniform_delta (cost=24.830..1,116.910 rows=310 width=24) (actual time=34.782..59.552 rows=241 loops=1)
|
15. | 21.470 | 21.470 | ↑ 1.0 | 1,076 | 1 |
→
Bitmap Index Scan on uniform_echo (cost=0.000..24.750 rows=1,111 width=0) (actual time=21.470..21.470 rows=1,076 loops=1)
|
16. |
SubPlan (forNested Loop) |
|||||
17. | 360.412 | 360.412 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using three on foxtrot_three (cost=0.420..8.440 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=90,103)
|
18. | 360.412 | 630.721 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.160..11.160 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=90,103)
|
19. | 270.309 | 270.309 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five (cost=0.420..11.150 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=90,103)
|
20. | 90.103 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)
|
21. | 90.103 | 90.103 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five five (cost=0.420..11.400 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=90,103)
|
22. | 90.103 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=19.600..19.600 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=90,103)
|
23. | 51.267 | 90.103 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five golf_quebec (cost=0.420..19.590 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=90,103)
|
24. |
SubPlan (forIndex Scan) |
|||||
25. | 38.836 | 38.836 | ↑ 1.0 | 1 | 19 |
→
Index Scan using victor_alpha on tango_whiskey quebec_sierra (cost=0.420..8.440 rows=1 width=8) (actual time=2.043..2.044 rows=1 loops=19)
|
26. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=19.600..19.600 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)
|
27. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five xray (cost=0.420..19.590 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)
|
28. |
SubPlan (forIndex Scan) |
|||||
29. | 0.095 | 0.095 | ↑ 1.0 | 1 | 19 |
→
Index Scan using victor_alpha on tango_whiskey zulu_zulu (cost=0.420..8.440 rows=1 width=19) (actual time=0.005..0.005 rows=1 loops=19)
|
30. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.160..11.160 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=90,103)
|
31. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five alpha_hotel (cost=0.420..11.150 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=90,103)
|
32. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)
|
33. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five charlie_golf (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)
|
34. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)
|
35. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five victor_zulu (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)
|
36. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)
|
37. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five hotel (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)
|
38. | 180.206 | 180.206 | ↓ 0.0 | 0 | 90,103 |
→
Sort (cost=11.160..11.160 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=90,103)
|
39. | 0.000 | 0.000 | ↓ 0.0 | 0 | 90,103 |
→
Index Scan using charlie_hotel on echo_five quebec_tango (cost=0.420..11.150 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=90,103)
|
40. | 1,441.648 | 1,441.648 | ↓ 0.0 | 0 | 90,103 |
→
Seq Scan on golf_romeo (cost=0.000..2.900 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=90,103)
|
41. | 9,010.300 | 9,010.300 | ↑ 1.0 | 1 | 90,103 |
→
Index Scan using tango_delta on golf_six (cost=0.430..8.450 rows=1 width=8) (actual time=0.100..0.100 rows=1 loops=90,103)
|