explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J7yx

Settings
# exclusive inclusive rows x rows loops node
1. 3,269.217 8,550.297 ↓ 45.2 167,786 1

Nested Loop (cost=1.46..876.40 rows=3,715 width=16) (actual time=2.611..8,550.297 rows=167,786 loops=1)

2. 0.717 0.717 ↑ 1.0 1 1

Seq Scan on chromosomes c (cost=0.00..1.38 rows=1 width=32) (actual time=0.699..0.717 rows=1 loops=1)

  • Filter: (((chromosome)::text = '20'::text) AND (genome_id = 1))
  • Rows Removed by Filter: 24
3. 3,293.689 5,280.363 ↓ 45.2 167,786 1

Nested Loop (cost=1.46..828.59 rows=3,715 width=23) (actual time=1.883..5,280.363 rows=167,786 loops=1)

4. 0.797 2.919 ↓ 37.0 37 1

Hash Join (cost=1.04..2.52 rows=1 width=8) (actual time=1.807..2.919 rows=37 loops=1)

  • Hash Cond: (cp.project_id = pu.project_id)
5. 1.185 1.185 ↑ 1.0 37 1

Seq Scan on cell_project cp (cost=0.00..1.37 rows=37 width=16) (actual time=0.835..1.185 rows=37 loops=1)

6. 0.043 0.937 ↓ 2.0 2 1

Hash (cost=1.02..1.02 rows=1 width=4) (actual time=0.929..0.937 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.894 0.894 ↓ 2.0 2 1

Seq Scan on project_user pu (cost=0.00..1.02 rows=1 width=4) (actual time=0.869..0.894 rows=2 loops=1)

  • Filter: (user_id = 5)
8. 1,983.755 1,983.755 ↑ 1.7 4,535 37

Index Scan using cell_chromosome_statistics_window_size_idx on cell_chromosome_statistics ccs (cost=0.42..749.71 rows=7,636 width=23) (actual time=0.031..53.615 rows=4,535 loops=37)

  • Index Cond: ((window_size = 3000) AND (cell_id = cp.cell_id))
  • Filter: ((indel_count > 0) AND (snp_count > 0) AND ((chromosome)::text = '20'::text))
  • Rows Removed by Filter: 5916
Planning time : 11.906 ms
Execution time : 10,221.518 ms