explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DweK

Settings
# exclusive inclusive rows x rows loops node
1. 70.977 100.944 ↓ 90.2 11,641 1

Nested Loop Left Join (cost=5.33..841.63 rows=129 width=41) (actual time=1.923..100.944 rows=11,641 loops=1)

2.          

Initplan (for Nested Loop Left Join)

3. 0.009 0.009 ↑ 1.0 1 1

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

  • Filter: ((road_damage_type_name)::text = 'emi'::text)
  • Rows Removed by Filter: 13
4. 4.844 6.676 ↓ 90.2 11,641 1

Bitmap Heap Scan on record_segments rs (cost=3.73..175.79 rows=129 width=52) (actual time=1.874..6.676 rows=11,641 loops=1)

  • Recheck Cond: ('010300000001000000050000000000000080B22840D5020B4A13AC49400000000080B228400CEED57F96AF49400000000000C928400CEED57F96AF49400000000000C92840D5020B4A13AC49400000000080B22840D5020B4A13AC4940'::geometry ~ line_geom)
  • Filter: (is_latest_until IS NULL)
  • Rows Removed by Filter: 5269
  • Heap Blocks: exact=380
5. 1.832 1.832 ↓ 104.4 16,910 1

Bitmap Index Scan on idx_records_segments_line_geom (cost=0.00..3.69 rows=162 width=0) (actual time=1.832..1.832 rows=16,910 loops=1)

  • Index Cond: ('010300000001000000050000000000000080B22840D5020B4A13AC49400000000080B228400CEED57F96AF49400000000000C928400CEED57F96AF49400000000000C92840D5020B4A13AC49400000000080B22840D5020B4A13AC4940'::geometry ~ line_geom)
6. 23.282 23.282 ↑ 1.0 1 11,641

Index Scan using record_segments_to_road_damage_pkey on record_segments_to_road_damage rtrd (cost=0.43..2.65 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=11,641)

  • Index Cond: ((rs.segment_data_id = segment_data_id) AND (road_damage_type_id = $0))
Planning time : 2.889 ms
Execution time : 101.909 ms