explain.depesz.com

A tool for finding a real cause for slow queries.

Result: P9M

options
# exclusive inclusive rows x rows loops node
1. 0.082 384.920 ↓ 82.0 82 1
→

Nested Loop (cost=329.91..586.24 rows=1 width=137) (actual time=377.252..384.920 rows=82 loops=1)

2. 0.071 383.608 ↓ 82.0 82 1
→

Nested Loop (cost=329.91..471.21 rows=1 width=140) (actual time=377.215..383.608 rows=82 loops=1)

3. 0.053 377.633 ↓ 82.0 82 1
→

Nested Loop (cost=329.91..427.45 rows=1 width=61) (actual time=377.173..377.633 rows=82 loops=1)

  • Join Filter: (x.min_dist = foo.r)
4. 0.085 377.252 ↓ 82.0 82 1
→

Hash Join (cost=329.91..414.59 rows=1 width=56) (actual time=377.162..377.252 rows=82 loops=1)

  • Hash Cond: (public.dr8.objid = x.objid)
5. 0.042 0.042 ↓ 4.3 82 1
→

Index Scan using dr8_runfieldcamcol_idx on dr8 (cost=0.00..84.60 rows=19 width=44) (actual time=0.025..0.042 rows=82 loops=1)

  • Index Cond: ((run = 1659) AND (field = 139) AND (camcol = 4))
6. 0.046 377.125 ↓ 3.9 82 1
→

Hash (cost=329.65..329.65 rows=21 width=12) (actual time=377.125..377.125 rows=82 loops=1)

7. 0.030 377.079 ↓ 3.9 82 1
→

Subquery Scan x (cost=329.18..329.65 rows=21 width=12) (actual time=377.020..377.079 rows=82 loops=1)

8. 0.343 377.049 ↓ 3.9 82 1
→

HashAggregate (cost=329.18..329.44 rows=21 width=12) (actual time=377.019..377.049 rows=82 loops=1)

9. 0.200 376.706 ↓ 4.0 83 1
→

Nested Loop (cost=84.64..329.07 rows=21 width=12) (actual time=0.074..376.706 rows=83 loops=1)

10. 0.101 0.126 ↓ 4.3 82 1
→

HashAggregate (cost=84.64..84.83 rows=19 width=8) (actual time=0.059..0.126 rows=82 loops=1)

11. 0.025 0.025 ↓ 4.3 82 1
→

Index Scan using dr8_runfieldcamcol_idx on dr8 (cost=0.00..84.60 rows=19 width=8) (actual time=0.008..0.025 rows=82 loops=1)

  • Index Cond: ((run = 1659) AND (field = 139) AND (camcol = 4))
12. 376.380 376.380 ↑ 1.0 1 82
→

Index Scan using xmatch_final_objid_idx on xmatch_final (cost=0.00..12.84 rows=1 width=12) (actual time=4.588..4.590 rows=1 loops=82)

  • Index Cond: (xmatch_final.objid = public.dr8.objid)
13. 0.328 0.328 ↑ 1.0 1 82
→

Index Scan using xmatch_final_objid_idx on xmatch_final foo (cost=0.00..12.84 rows=1 width=25) (actual time=0.004..0.004 rows=1 loops=82)

  • Index Cond: (foo.objid = x.objid)
14. 5.904 5.904 ↑ 1.0 1 82
→

Index Scan using usnob1_pkey on usnob1 (cost=0.00..43.75 rows=1 width=79) (actual time=0.071..0.072 rows=1 loops=82)

  • Index Cond: (usnob1.usno_id = foo.usno_id)
15. 1.230 1.230 ↑ 1.0 1 82
→

Index Scan using usno_blend_pkey on usno_blend (cost=0.00..115.01 rows=1 width=23) (actual time=0.015..0.015 rows=1 loops=82)

  • Index Cond: (usno_blend.usno_id = foo.usno_id)