explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FU7L

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)

  • Buffers: shared hit=611279 read=99386
2. 149.682 51,206.643 ↓ 312.3 127,117 3

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

  • Buffers: shared hit=611279 read=99386
3. 38.997 51,050.174 ↓ 312.3 127,117 3

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

  • Buffers: shared hit=611198 read=99376
4. 56.550 51,011.007 ↓ 312.3 127,117 3

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

  • Buffers: shared hit=611195 read=99376
5. 1,144.457 1,144.457 ↑ 1.3 127,117 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)

  • Buffers: shared read=8097
6. 16,709.641 49,810.000 ↓ 310.0 24,798 3

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

  • Buffers: shared hit=611195 read=91279
7. 1,940.316 33,100.359 ↓ 310.0 24,798 3

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

  • Buffers: shared hit=611195 read=91279
8. 25.666 31,159.965 ↓ 310.0 24,798 3

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

  • Buffers: shared hit=388641 read=90518
9. 1,148.743 1,148.743 ↑ 1.3 24,798 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)

  • Buffers: shared hit=207 read=896
10. 29,985.556 29,985.556 ↓ 20.3 74,209 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))
  • Buffers: shared hit=388434 read=89622
11. 0.078 0.078 ↑ 1.0 1 74,394

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)
  • Buffers: shared hit=222554 read=761
12. 0.146 0.170 ↑ 1.0 8 3

Hash (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

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

Hash (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

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