explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5gtK

Settings
# exclusive inclusive rows x rows loops node
1. 210.826 85,343.187 ↓ 176,824.0 176,824 1

Gather (cost=1,009.39..17,259.45 rows=1 width=8) (actual time=49.944..85,343.187 rows=176,824 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 336.670 85,132.361 ↓ 58,941.0 58,941 3 / 3

Nested Loop (cost=9.39..16,259.35 rows=1 width=8) (actual time=30.097..85,132.361 rows=58,941 loops=3)

3. 263.363 370.420 ↓ 153.2 162,045 3 / 3

Hash Join (cost=8.82..13,302.24 rows=1,058 width=8) (actual time=29.936..370.420 rows=162,045 loops=3)

  • Hash Cond: ("LHS".sample = sample_view.sample)
4. 105.783 105.783 ↑ 1.2 262,100 3 / 3

Parallel Seq Scan on cells "LHS" (cost=0.00..12,054.25 rows=327,625 width=8) (actual time=0.032..105.783 rows=262,100 loops=3)

5. 0.072 1.274 ↑ 1.0 147 3 / 3

Hash (cost=6.98..6.98 rows=147 width=8) (actual time=1.273..1.274 rows=147 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
6. 0.030 1.202 ↑ 1.0 147 3 / 3

Nested Loop (cost=0.72..6.98 rows=147 width=8) (actual time=1.159..1.202 rows=147 loops=3)

7. 0.578 0.578 ↑ 1.0 1 3 / 3

Index Only Scan using genemaps_gene_study_probe_genemap_idx on genemaps (cost=0.43..1.55 rows=1 width=4) (actual time=0.578..0.578 rows=1 loops=3)

  • Index Cond: ((gene = 36,824) AND (study = 431))
  • Heap Fetches: 0
8. 0.594 0.594 ↑ 1.0 147 3 / 3

Index Only Scan using sample_view_study_sample_idx on sample_view (cost=0.29..3.96 rows=147 width=4) (actual time=0.573..0.594 rows=147 loops=3)

  • Index Cond: (study = 431)
  • Heap Fetches: 0
9. 84,425.271 84,425.271 ↓ 0.0 0 486,134 / 3

Index Scan using cell_measurements_pkey on cell_measurements "RHS" (cost=0.57..2.79 rows=1 width=12) (actual time=0.521..0.521 rows=0 loops=486,134)

  • Index Cond: ((genemap = genemaps.genemap) AND (cell = "LHS".cell))
Planning time : 95.212 ms
Execution time : 85,382.580 ms