explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Bjf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 3.034 18,863.320 ↓ 1,849.0 1,849 1

Nested Loop (cost=449,495.65..968,631.94 rows=1 width=37) (actual time=10,152.548..18,863.320 rows=1,849 loops=1)

2. 2.887 16,103.784 ↓ 2,358.0 2,358 1

Nested Loop (cost=449,495.65..968,628.06 rows=1 width=84) (actual time=10,152.495..16,103.784 rows=2,358 loops=1)

3. 3.762 12,556.823 ↓ 2,358.0 2,358 1

Nested Loop (cost=449,495.65..968,626.14 rows=1 width=84) (actual time=10,126.983..12,556.823 rows=2,358 loops=1)

4. 4.120 12,524.765 ↓ 2,358.0 2,358 1

Nested Loop (cost=449,495.65..968,625.07 rows=1 width=63) (actual time=10,126.966..12,524.765 rows=2,358 loops=1)

  • Join Filter: (x.r = (min(x.r)))
5. 4.142 10,131.991 ↑ 65.5 2,358 1

GroupAggregate (cost=449,495.65..453,358.15 rows=154,500 width=15) (actual time=10,126.917..10,131.991 rows=2,358 loops=1)

6. 21.394 10,127.849 ↑ 65.5 2,358 1

Sort (cost=449,495.65..449,881.90 rows=154,500 width=15) (actual time=10,126.910..10,127.849 rows=2,358 loops=1)

  • Sort Key: x.gsc_id
  • Sort Method: quicksort Memory: 207kB
7. 3.139 10,106.455 ↑ 65.5 2,358 1

Nested Loop (cost=0.00..434,669.88 rows=154,500 width=15) (actual time=79.226..10,106.455 rows=2,358 loops=1)

8. 1.669 1.669 ↑ 61.3 2,521 1

Index Scan using o_recal_2_idx on o_recal_2_phot foo (cost=0.00..4,416.79 rows=154,500 width=8) (actual time=0.040..1.669 rows=2,521 loops=1)

  • Index Cond: (abs((poss_mag_recal_2 - sloan_poss_mag)) >= 2::double precision)
9. 10,101.647 10,101.647 ↑ 1.0 1 2,521

Index Scan using gsc_xmatch_final_objid_idx on gsc_xmatch_final x (cost=0.00..2.77 rows=1 width=23) (actual time=3.967..4.007 rows=1 loops=2,521)

  • Index Cond: (x.objid = foo.objid)
10. 2,388.654 2,388.654 ↑ 1.0 1 2,358

Index Scan using gsc_xmatch_final_gscid_idx on gsc_xmatch_final x (cost=0.00..3.31 rows=1 width=23) (actual time=1.003..1.013 rows=1 loops=2,358)

  • Index Cond: (x.gsc_id = x.gsc_id)
11. 28.296 28.296 ↑ 1.0 1 2,358

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.012..0.012 rows=1 loops=2,358)

  • Index Cond: (foo.objid = x.objid)
12. 3,544.074 3,544.074 ↑ 1.0 1 2,358

Index Scan using usno_merged_id_idx on usno_merged (cost=0.00..1.90 rows=1 width=13) (actual time=1.490..1.503 rows=1 loops=2,358)

  • Index Cond: (usno_merged.usno_id = foo.usno_id)
  • Filter: (usno_merged.b1_surv = 0)
13. 2,756.502 2,756.502 ↑ 1.0 1 2,358

Index Scan using gsc_short_id_idx on gsc_short (cost=0.00..3.87 rows=1 width=19) (actual time=1.165..1.169 rows=1 loops=2,358)

  • Index Cond: (gsc_short.gsc_id = x.gsc_id)
  • Filter: ((gsc_short.b_mag_err < 1::double precision) AND (gsc_short.b_mag_code = 7))