| # | exclusive | inclusive | rows x | rows | loops | node |
|---|---|---|---|---|---|---|
| 1. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=20760528.71..83760632.51 rows=123375160 width=89) (actual time=.. rows= loops=)
|
||
| 2. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on usnob1 (cost=0.00..7356319.20 rows=246750320 width=79) (actual time=.. rows= loops=) |
||
| 3. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=17031035.51..17031035.51 rows=148023296 width=75) (actual time=.. rows= loops=) |
||
| 4. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=3944783.35..17031035.51 rows=148023296 width=75) (actual time=.. rows= loops=)
|
||
| 5. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on usno_blend (cost=0.00..6202149.92 rows=296046592 width=23) (actual time=.. rows= loops=) |
||
| 6. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=3016113.15..3016113.15 rows=41708656 width=52) (actual time=.. rows= loops=) |
||
| 7. | 0.000 | 0.000 | ↓ 0.0 |
→
Group (cost=0.00..2599026.59 rows=41708656 width=13) (actual time=.. rows= loops=) |
||
| 8. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using xmatch_final_usnoid_idx on xmatch_final (cost=0.00..2494754.95 rows=41708656 width=13) (actual time=.. rows= loops=) |