# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.248 | 397,984.530 | ↑ 2.1 | 96 | 1 |
→
HashAggregate (cost=45.860..49.860 rows=200 width=128) (actual time=397,984.480..397,984.530 rows=96 loops=1)
|
2. | 0.029 | 397,984.282 | ↑ 1.3 | 174 | 1 |
→
Append (cost=0.000..42.970 rows=231 width=116) (actual time=0.126..397,984.282 rows=174 loops=1) |
3. | 0.147 | 0.147 | ↑ 2.4 | 96 | 1 |
→
Seq Scan on romeo_india (cost=0.000..12.300 rows=230 width=116) (actual time=0.106..0.147 rows=96 loops=1) |
4. | 0.008 | 397,984.106 | ↓ 78.0 | 78 | 1 |
→
Subquery Scan on echo_seven (cost=29.450..29.510 rows=1 width=128) (actual time=397,983.775..397,984.106 rows=78 loops=1) |
5. | 0.327 | 397,984.098 | ↓ 78.0 | 78 | 1 |
→
GroupAggregate (cost=29.450..29.500 rows=1 width=160) (actual time=397,983.774..397,984.098 rows=78 loops=1)
|
6. | 2.821 | 397,983.771 | ↓ 432.0 | 432 | 1 |
→
Sort (cost=29.450..29.450 rows=1 width=141) (actual time=397,983.759..397,983.771 rows=432 loops=1)
|
7. | 235,974.571 | 397,980.950 | ↓ 432.0 | 432 | 1 |
→
Nested Loop (cost=8.870..29.440 rows=1 width=141) (actual time=301.152..397,980.950 rows=432 loops=1)
|
8. | 377.771 | 381.643 | ↓ 183,456.0 | 183,456 | 1 |
→
Hash Join (cost=8.450..21.630 rows=1 width=349) (actual time=3.759..381.643 rows=183,456 loops=1)
|
9. | 0.179 | 0.179 | ↑ 2.4 | 96 | 1 |
→
Seq Scan on romeo_india quebec (cost=0.000..12.300 rows=230 width=324) (actual time=0.034..0.179 rows=96 loops=1) |
10. | 0.957 | 3.693 | ↓ 4,184.0 | 4,184 | 1 |
→
Hash (cost=8.440..8.440 rows=1 width=33) (actual time=3.693..3.693 rows=4,184 loops=1)
|
11. | 2.736 | 2.736 | ↓ 4,184.0 | 4,184 | 1 |
→
Index Scan using romeo_echo on three five_hotel (cost=0.420..8.440 rows=1 width=33) (actual time=0.141..2.736 rows=4,184 loops=1)
|
12. | 161,624.736 | 161,624.736 | ↓ 4,181.0 | 4,181 | 183,456 |
→
Index Scan using yankee on two_oscar romeo_three (cost=0.420..7.790 rows=1 width=462) (actual time=0.012..0.881 rows=4,181 loops=183,456)
|