explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TtPX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.028 0.184 ↑ 1.0 86 1

Hash Join (cost=8.11..34.25 rows=86 width=41) (actual time=0.064..0.184 rows=86 loops=1)

  • Hash Cond: (rtrd.record_data_id = r.record_data_id)
2.          

Initplan (for Hash Join)

3. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on road_damage_types rdt (cost=0.00..1.18 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: ((road_damage_type_name)::text = 'cracks'::text)
  • Rows Removed by Filter: 13
4. 0.105 0.105 ↑ 1.0 86 1

Seq Scan on records_to_road_damage rtrd (cost=0.00..25.90 rows=86 width=9) (actual time=0.012..0.105 rows=86 loops=1)

  • Filter: (road_damage_type_id = $0)
  • Rows Removed by Filter: 946
5. 0.016 0.046 ↑ 1.0 86 1

Hash (cost=5.86..5.86 rows=86 width=36) (actual time=0.046..0.046 rows=86 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
6. 0.030 0.030 ↑ 1.0 86 1

Seq Scan on records r (cost=0.00..5.86 rows=86 width=36) (actual time=0.007..0.030 rows=86 loops=1)

Planning time : 0.240 ms
Execution time : 0.212 ms