# Result: t0De

Settings

### Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.248 397,984.530 ↑ 2.1 96 1

(cost=45.860..49.860 rows=200 width=128) (actual time=397,984.480..397,984.530 rows=96 loops=1)

• Group Key: xray"two_yankee"seven1"echo_quebec"xray"two_yankee"seven2"echo_quebec"xray"two_yankee"six_four
2. 0.029 397,984.282 ↑ 1.3 174 1

(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

(cost=29.450..29.500 rows=1 width=160) (actual time=397,983.774..397,984.098 rows=78 loops=1)

• Group Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie
6. 2.821 397,983.771 ↓ 432.0 432 1

(cost=29.450..29.450 rows=1 width=141) (actual time=397,983.759..397,983.771 rows=432 loops=1)

• Sort Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie
• Sort Method: quicksort Memory: 85kB
7. 235,974.571 397,980.950 ↓ 432.0 432 1

(cost=8.870..29.440 rows=1 width=141) (actual time=301.152..397,980.950 rows=432 loops=1)

• Join Filter: ((romeo_three.november"papa"november"alpha"golf_sierra"papa"golf_sierra"alpha"mike"papa"mike"alpha"delta"papa"delta"alpha"lima_india"papa"lima_india"alpha"lima_alpha"papa"lima_alpha"six_tango"india"two_lima"india"))
• Rows Removed by Join Filter: 766,938,732
8. 377.771 381.643 ↓ 183,456.0 183,456 1

(cost=8.450..21.630 rows=1 width=349) (actual time=3.759..381.643 rows=183,456 loops=1)

• Hash Cond: (quebec.uniform"golf_yankee"uniform")
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

(cost=8.440..8.440 rows=1 width=33) (actual time=3.693..3.693 rows=4,184 loops=1)

• Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 362kB
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)

• Index Cond: (zulu" = 'five_lima'::uuid)
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)

• Index Cond: (zulu" = 'five_lima'::uuid)