explain.depesz.com

A tool for finding a real cause for slow queries.

Result: gcP

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 47.998 4,813.598 ↓ 38,704.0 38,704 1

Nested Loop (cost=639,445.31..1,387,547.31 rows=1 width=37) (actual time=955.215..4,813.598 rows=38,704 loops=1)

2. 36.152 3,739.771 ↓ 48,849.0 48,849 1

Nested Loop (cost=639,445.31..1,387,543.43 rows=1 width=84) (actual time=955.170..3,739.771 rows=48,849 loops=1)

3. 65.192 2,580.092 ↓ 48,849.0 48,849 1

Nested Loop (cost=639,445.31..1,387,541.51 rows=1 width=84) (actual time=955.120..2,580.092 rows=48,849 loops=1)

4. 69.240 2,172.957 ↓ 48,849.0 48,849 1

Nested Loop (cost=639,445.31..1,387,540.45 rows=1 width=63) (actual time=955.091..2,172.957 rows=48,849 loops=1)

  • Join Filter: (x.r = (min(x.r)))
5. 53.096 1,077.888 ↑ 4.8 48,849 1

GroupAggregate (cost=639,445.31..645,326.46 rows=235,246 width=15) (actual time=954.945..1,077.888 rows=48,849 loops=1)

6. 319.438 1,024.792 ↑ 4.8 48,868 1

Sort (cost=639,445.31..640,033.42 rows=235,246 width=15) (actual time=954.938..1,024.792 rows=48,868 loops=1)

  • Sort Key: x.gsc_id
  • Sort Method: external merge Disk: 1240kB
7. 56.345 705.354 ↑ 4.8 48,868 1

Nested Loop (cost=0.00..616,158.88 rows=235,246 width=15) (actual time=0.090..705.354 rows=48,868 loops=1)

8. 16.546 16.546 ↑ 4.8 48,651 1

Index Scan using o_recal_2_idx on o_recal_2_phot foo (cost=0.00..6,724.84 rows=235,246 width=8) (actual time=0.050..16.546 rows=48,651 loops=1)

  • Index Cond: (abs((poss_mag_recal_2 - sloan_poss_mag)) >= 1::double precision)
9. 632.463 632.463 ↑ 1.0 1 48,651

Index Scan using gsc_xmatch_final_objid_idx on gsc_xmatch_final x (cost=0.00..2.58 rows=1 width=23) (actual time=0.013..0.013 rows=1 loops=48,651)

  • Index Cond: (x.objid = foo.objid)
10. 1,025.829 1,025.829 ↑ 1.0 1 48,849

Index Scan using gsc_xmatch_final_gscid_idx on gsc_xmatch_final x (cost=0.00..3.13 rows=1 width=23) (actual time=0.021..0.021 rows=1 loops=48,849)

  • Index Cond: (x.gsc_id = x.gsc_id)
11. 341.943 341.943 ↑ 1.0 1 48,849

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.007..0.007 rows=1 loops=48,849)

  • Index Cond: (foo.objid = x.objid)
12. 1,123.527 1,123.527 ↑ 1.0 1 48,849

Index Scan using usno_merged_id_idx on usno_merged (cost=0.00..1.90 rows=1 width=13) (actual time=0.023..0.023 rows=1 loops=48,849)

  • Index Cond: (usno_merged.usno_id = foo.usno_id)
  • Filter: (usno_merged.b1_surv = 0)
13. 1,025.829 1,025.829 ↑ 1.0 1 48,849

Index Scan using gsc_short_id_idx on gsc_short (cost=0.00..3.87 rows=1 width=19) (actual time=0.021..0.021 rows=1 loops=48,849)

  • 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))