explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Zpi

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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=)

  • Hash Cond: (usnob1.usno_id = usno_blend.usno_id)
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=)

  • Hash Cond: (usno_blend.usno_id = xmatch_final.usno_id)
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=)