explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LlsW : Optimization for: plan #TtPX

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4.061 20.433 ↑ 1.0 10,960 1

Hash Join (cost=574.04..3,250.25 rows=10,960 width=41) (actual time=5.280..20.433 rows=10,960 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. 11.127 11.127 ↑ 1.0 11,048 1

Seq Scan on records_to_road_damage rtrd (cost=0.00..2,647.20 rows=11,048 width=9) (actual time=0.011..11.127 rows=11,048 loops=1)

  • Filter: (road_damage_type_id = $0)
  • Rows Removed by Filter: 121528
5. 2.046 5.240 ↑ 1.0 10,977 1

Hash (cost=435.65..435.65 rows=10,977 width=36) (actual time=5.240..5.240 rows=10,977 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 825kB
6. 3.194 3.194 ↑ 1.0 10,977 1

Seq Scan on records r (cost=0.00..435.65 rows=10,977 width=36) (actual time=0.004..3.194 rows=10,977 loops=1)

  • Filter: (is_latest_until IS NULL)
  • Rows Removed by Filter: 88
Planning time : 0.360 ms
Execution time : 21.089 ms