explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BpjU : Optimization for: plan #8aqE

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 21.380 33.668 ↑ 9.4 57,514 1

Hash Join (cost=71.55..680,540 rows=539,252 width=50) (actual time=0.548..33.668 rows=57,514 loops=1)

  • Buffers: shared hit=2,057
2. 11.770 11.770 ↑ 9.7 58,115 1

Index Scan using idx_uex_experiment_id on user_experiment_cohort uec (cost=0.57..668,925.74 rows=561,700 width=37) (actual time=0.018..11.77 rows=58,115 loops=1)

  • Index Cond: ((uec.experiment_id)::text = 'ex-kdainaq0w5rerpw'::text)
  • Buffers: shared hit=2,013
3. 0.208 0.518 ↓ 1.0 1,058 1

Hash (cost=57.76..57.76 rows=1,057 width=30) (actual time=0.518..0.518 rows=1,058 loops=1)

  • Buffers: shared hit=44
4. 0.310 0.310 ↓ 1.0 1,058 1

Seq Scan on cohort c (cost=0..57.76 rows=1,057 width=30) (actual time=0.007..0.31 rows=1,058 loops=1)

  • Filter: ((c.name)::text <> 'control'::text)
  • Buffers: shared hit=44
Planning time : 0.654 ms
Execution time : 36.19 ms