explain.depesz.com

A tool for finding a real cause for slow queries.

Result: f4c

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Aggregate (cost=931.30..931.31 rows=1 width=0) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=462.37..931.05 rows=101 width=0) (actual time=.. rows= loops=)

  • Hash Cond: (((csa.carcase_kill_location)::text = (c.kill_location)::text) AND (csa.carcase_number = c.number))
3. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=257.77..712.61 rows=1027 width=15) (actual time=.. rows= loops=)

  • Hash Cond: ((csa.assessment_id)::text = (a.id)::text)
4. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on carcase_side_assessment csa (cost=239.22..645.58 rows=10189 width=20) (actual time=.. rows= loops=)

  • Recheck Cond: (carcase_kill_date = '2012-06-05'::date)
5. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on csa_carcase_ndx (cost=0.00..236.67 rows=10189 width=0) (actual time=.. rows= loops=)

  • Index Cond: (carcase_kill_date = '2012-06-05'::date)
6. 0.000 0.000 ↓ 0.0
→

Hash (cost=17.95..17.95 rows=48 width=6) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Seq Scan on assessment a (cost=0.00..17.95 rows=48 width=6) (actual time=.. rows= loops=)

  • Filter: ((assessment_group_id)::text = 'COND'::text)
8. 0.000 0.000 ↓ 0.0
→

Hash (cost=202.51..202.51 rows=139 width=15) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on carcase c (cost=17.10..202.51 rows=139 width=15) (actual time=.. rows= loops=)

  • Recheck Cond: (((advice_season)::text = '2012'::text) AND (advice_number = 108342))
  • Filter: (kill_date = '2012-06-05'::date)
10. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on carcase_advice_ndx (cost=0.00..17.06 rows=481 width=0) (actual time=.. rows= loops=)

  • Index Cond: (((advice_season)::text = '2012'::text) AND (advice_number = 108342))