explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dErc

Settings
# exclusive inclusive rows x rows loops node
1. 42.699 620.483 ↓ 176,824.0 176,824 1

Hash Join (cost=7.23..1,318.46 rows=1 width=8) (actual time=30.893..620.483 rows=176,824 loops=1)

  • Hash Cond: ("LHS".sample = sample_view.sample)
2. 92.770 577.699 ↓ 710.1 176,824 1

Nested Loop (cost=1.43..1,312.01 rows=249 width=12) (actual time=30.718..577.699 rows=176,824 loops=1)

3. 18.061 131.281 ↓ 710.1 176,824 1

Nested Loop (cost=1.00..857.02 rows=249 width=8) (actual time=30.565..131.281 rows=176,824 loops=1)

4. 0.222 0.222 ↑ 1.0 1 1

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

  • Index Cond: ((gene = 36,824) AND (study = 431))
  • Heap Fetches: 0
5. 112.998 112.998 ↓ 6.5 176,824 1

Index Only Scan using cell_measurements_pk on cell_measurements "RHS" (cost=0.57..582.60 rows=27,287 width=12) (actual time=30.319..112.998 rows=176,824 loops=1)

  • Index Cond: (genemap = genemaps.genemap)
  • Heap Fetches: 0
6. 353.648 353.648 ↑ 1.0 1 176,824

Index Scan using cells_pkey on cells "LHS" (cost=0.42..1.83 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=176,824)

  • Index Cond: (cell = "RHS".cell)
7. 0.030 0.085 ↑ 1.0 147 1

Hash (cost=3.96..3.96 rows=147 width=4) (actual time=0.085..0.085 rows=147 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
8. 0.055 0.055 ↑ 1.0 147 1

Index Only Scan using sample_view_study_sample_idx on sample_view (cost=0.29..3.96 rows=147 width=4) (actual time=0.039..0.055 rows=147 loops=1)

  • Index Cond: (study = 431)
  • Heap Fetches: 0
Planning time : 225.012 ms
Execution time : 631.608 ms