# Result: lb2J

Settings
# exclusive inclusive rows x rows loops node
1. 1,388.831 52,595.474 ↓ 390.3 381,352 1

Gather (cost=67,575.34..77,959.52 rows=977 width=290) (actual time=51,264.085..52,595.474 rows=381,352 loops=1)

• Workers Planned: 2
• Workers Launched: 2
2. 149.682 51,206.643 ↓ 312.3 127,117 3 / 3

(cost=66,575.34..76,861.82 rows=407 width=290) (actual time=49,962.789..51,206.643 rows=127,117 loops=3)

3. 38.997 51,050.174 ↓ 312.3 127,117 3 / 3

(cost=66,573.92..76,859.09 rows=407 width=275) (actual time=49,838.893..51,050.174 rows=127,117 loops=3)

4. 56.550 51,011.007 ↓ 312.3 127,117 3 / 3

(cost=66,572.74..76,856.28 rows=407 width=263) (actual time=49,830.893..51,011.007 rows=127,117 loops=3)

5. 1,144.457 1,144.457 ↑ 1.3 127,117 3 / 3

Seq Scan on gxd_specimen s (cost=0..9,685.97 rows=158,897 width=223) (actual time=16.649..1,144.457 rows=127,117 loops=3)

6. 16,709.641 49,810.000 ↓ 310.0 24,798 3 / 3

(cost=66,571.74..66,571.74 rows=80 width=48) (actual time=49,810..49,810 rows=24,798 loops=3)

7. 6.150 33,100.359 ↓ 310.0 24,798 3 / 3

(cost=1.09..66,571.74 rows=80 width=48) (actual time=1,232.767..33,100.359 rows=24,798 loops=3)

8. 25.666 31,159.965 ↓ 310.0 24,798 3 / 3

(cost=0.8..66,247.94 rows=80 width=22) (actual time=1,228.12..31,159.965 rows=24,798 loops=3)

9. 1,148.743 1,148.743 ↑ 1.3 24,798 3 / 3

Index Scan using gxd_genotype_pkey on gxd_genotype g (cost=0.29..1,992.03 rows=30,998 width=8) (actual time=16.51..1,148.743 rows=24,798 loops=3)

10. 29,985.556 29,985.556 ↓ 20.3 74,209 3 / 3

Index Scan using acc_accession_idx_clustered on acc_accession a (cost=0.44..803,744.68 rows=3,657 width=14) (actual time=20.749..29,985.556 rows=74,209 loops=3)

• Index Cond: (a._mgitype_key = 12)
• Filter: ((a._logicaldb_key = 1) AND (a.preferred = 1) AND (a.prefixpart = 'MGI:'::text))
11. 1,934.244 1,934.244 ↑ 1.0 1 74,394 / 3

Index Scan using prb_strain_pkey on prb_strain ps (cost=0.29..4.05 rows=1 width=34) (actual time=0.078..0.078 rows=1 loops=74,394)

• Index Cond: (ps._strain_key = g._strain_key)
12. 0.146 0.170 ↑ 1.0 8 3 / 3

(cost=1.08..1.08 rows=8 width=16) (actual time=0.17..0.17 rows=8 loops=3)

• Buffers: shared hit=3
13. 0.024 0.024 ↑ 1.0 8 3 / 3

Seq Scan on gxd_embeddingmethod e (cost=0..1.08 rows=8 width=16) (actual time=0.023..0.024 rows=8 loops=3)

• Buffers: shared hit=3
14. 1.101 6.787 ↑ 1.0 19 3 / 3

(cost=1.19..1.19 rows=19 width=19) (actual time=6.787..6.787 rows=19 loops=3)

• Buffers: shared hit=3
15. 5.686 5.686 ↑ 1.0 19 3 / 3

Seq Scan on gxd_fixationmethod f (cost=0..1.19 rows=19 width=19) (actual time=5.683..5.686 rows=19 loops=3)

• Buffers: shared hit=3
Planning time Execution time : 741.156 ms : 52,677.398 ms