explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 23w

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 204.230 241,529.367 ↓ 117,319.0 117,319 1

Nested Loop (cost=667,944.75..1,454,204.40 rows=1 width=39) (actual time=184,565.237..241,529.367 rows=117,319 loops=1)

2. 194.407 197,095.874 ↓ 117,319.0 117,319 1

Nested Loop (cost=667,944.75..1,454,203.33 rows=1 width=18) (actual time=184,565.209..197,095.874 rows=117,319 loops=1)

3. 273.418 193,576.081 ↓ 144,582.0 144,582 1

Nested Loop (cost=667,944.75..1,454,199.45 rows=1 width=63) (actual time=184,565.163..193,576.081 rows=144,582 loops=1)

  • Join Filter: (x.r = (min(x.r)))
4. 224.037 185,206.071 ↑ 1.7 144,582 1

GroupAggregate (cost=667,944.75..674,178.50 rows=249,350 width=15) (actual time=184,565.108..185,206.071 rows=144,582 loops=1)

5. 1,602.118 184,982.034 ↑ 1.7 144,643 1

Sort (cost=667,944.75..668,568.12 rows=249,350 width=15) (actual time=184,565.100..184,982.034 rows=144,643 loops=1)

  • Sort Key: x.gsc_id
  • Sort Method: external merge Disk: 3664kB
6. 286.136 183,379.916 ↑ 1.7 144,643 1

Nested Loop (cost=0.00..643,157.25 rows=249,350 width=15) (actual time=42.830..183,379.916 rows=144,643 loops=1)

7. 138.462 138.462 ↑ 1.7 143,607 1

Index Scan using o_recal_2_idx on o_recal_2_phot moo (cost=0.00..7,126.66 rows=249,350 width=8) (actual time=42.763..138.462 rows=143,607 loops=1)

  • Index Cond: (abs((poss_mag_recal_2 - sloan_poss_mag)) >= 0.75::double precision)
8. 182,955.318 182,955.318 ↑ 1.0 1 143,607

Index Scan using gsc_xmatch_final_objid_idx on gsc_xmatch_final x (cost=0.00..2.54 rows=1 width=23) (actual time=1.271..1.274 rows=1 loops=143,607)

  • Index Cond: (x.objid = moo.objid)
9. 8,096.592 8,096.592 ↑ 1.0 1 144,582

Index Scan using gsc_xmatch_final_gscid_idx on gsc_xmatch_final x (cost=0.00..3.10 rows=1 width=23) (actual time=0.056..0.056 rows=1 loops=144,582)

  • Index Cond: (x.gsc_id = x.gsc_id)
10. 3,325.386 3,325.386 ↑ 1.0 1 144,582

Index Scan using gsc_short_id_idx on gsc_short (cost=0.00..3.86 rows=1 width=21) (actual time=0.023..0.023 rows=1 loops=144,582)

  • Index Cond: (gsc_short.gsc_id = x.gsc_id)
  • Filter: (gsc_short.b_mag IS NOT NULL)
11. 44,229.263 44,229.263 ↑ 1.0 1 117,319

Index Scan using o_recal_2_objid_idx on o_recal_2_phot foo (cost=0.00..1.06 rows=1 width=29) (actual time=0.376..0.377 rows=1 loops=117,319)

  • Index Cond: (foo.objid = x.objid)