explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3lzJ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 0.161 ↑ 1.0 1 1

Aggregate (cost=18.94..18.95 rows=1 width=76) (actual time=0.161..0.161 rows=1 loops=1)

2. 0.054 0.143 ↑ 1.0 1 1

Hash Join (cost=7.97..18.93 rows=1 width=76) (actual time=0.024..0.143 rows=1 loops=1)

  • Hash Cond: (c.id = rc.causality_id)
3. 0.078 0.078 ↑ 1.0 181 1

Seq Scan on hazards_causality c (cost=0.00..10.27 rows=181 width=76) (actual time=0.004..0.078 rows=181 loops=1)

  • Filter: is_cause
  • Rows Removed by Filter: 146
4. 0.002 0.011 ↑ 1.0 2 1

Hash (cost=7.95..7.95 rows=2 width=4) (actual time=0.011..0.011 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.003 0.009 ↑ 1.0 2 1

Bitmap Heap Scan on hazards_riskcausality rc (cost=4.16..7.95 rows=2 width=4) (actual time=0.008..0.009 rows=2 loops=1)

  • Recheck Cond: (risk_id = 15626)
  • Heap Blocks: exact=2
6. 0.006 0.006 ↑ 1.0 2 1

Bitmap Index Scan on hazards_riskcausality_risk_id_ebb0af76 (cost=0.00..4.16 rows=2 width=0) (actual time=0.006..0.006 rows=2 loops=1)

  • Index Cond: (risk_id = 15626)