explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gOg5

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 6.475 ↑ 2.3 80 1

Hash Join (cost=14.87..860.07 rows=186 width=62) (actual time=0.651..6.475 rows=80 loops=1)

  • Hash Cond: (m.cell_group_id = h.id)
2. 0.015 6.336 ↑ 2.3 80 1

Nested Loop (cost=5.21..849.91 rows=186 width=63) (actual time=0.534..6.336 rows=80 loops=1)

3. 1.250 6.161 ↑ 2.8 80 1

Hash Join (cost=4.92..773.71 rows=224 width=36) (actual time=0.511..6.161 rows=80 loops=1)

  • Hash Cond: (s.cell_group_id = g.id)
4. 4.880 4.880 ↑ 1.0 16,585 1

Seq Scan on scxa_cell_group_marker_gene_stats s (cost=0.00..724.62 rows=16,585 width=24) (actual time=0.015..4.880 rows=16,585 loops=1)

  • Filter: (expression_type = 0)
  • Rows Removed by Filter: 16585
5. 0.005 0.031 ↑ 1.0 4 1

Hash (cost=4.87..4.87 rows=4 width=20) (actual time=0.031..0.031 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.007 0.026 ↑ 1.0 4 1

Bitmap Heap Scan on scxa_cell_group g (cost=1.81..4.87 rows=4 width=20) (actual time=0.025..0.026 rows=4 loops=1)

  • Recheck Cond: (((experiment_accession)::text = 'E-ENAD-13'::text) AND ((variable)::text = '4'::text))
  • Heap Blocks: exact=1
7. 0.019 0.019 ↑ 1.0 4 1

Bitmap Index Scan on scxa_cell_group_experiment_accession_variable_value_key (cost=0.00..1.81 rows=4 width=0) (actual time=0.019..0.019 rows=4 loops=1)

  • Index Cond: (((experiment_accession)::text = 'E-ENAD-13'::text) AND ((variable)::text = '4'::text))
8. 0.160 0.160 ↑ 1.0 1 80

Index Scan using scxa_cell_group_marker_genes_pkey on scxa_cell_group_marker_genes m (cost=0.29..0.34 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=80)

  • Index Cond: (id = s.marker_id)
  • Filter: (marker_probability < '0.01'::double precision)
9. 0.047 0.106 ↑ 1.0 296 1

Hash (cost=5.96..5.96 rows=296 width=7) (actual time=0.106..0.106 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
10. 0.059 0.059 ↑ 1.0 296 1

Seq Scan on scxa_cell_group h (cost=0.00..5.96 rows=296 width=7) (actual time=0.007..0.059 rows=296 loops=1)

Planning time : 8.019 ms
Execution time : 6.592 ms