explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ixfj

Settings
# exclusive inclusive rows x rows loops node
1. 1.735 10.351 ↑ 1.0 1 1

Aggregate (cost=1,085.46..1,085.47 rows=1 width=32) (actual time=10.351..10.351 rows=1 loops=1)

2. 0.361 8.616 ↓ 417.0 417 1

Subquery Scan on q (cost=1,085.34..1,085.45 rows=1 width=44) (actual time=2.692..8.616 rows=417 loops=1)

3. 5.544 8.255 ↓ 417.0 417 1

GroupAggregate (cost=1,085.34..1,085.44 rows=1 width=246) (actual time=2.683..8.255 rows=417 loops=1)

  • Group Key: v_transit_roads.link_id, v_transit_roads.street_name, v_transit_roads.road_speed, v_transit_roads.road_rank, v_transit_roads.truck, v_transit_roads.surface, v_transit_roads.road_km, v_transit_roads.geometry
4.          

CTE boundaries

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on v_transit_boundaries (cost=0.00..910.46 rows=3,346 width=75,373) (never executed)

6. 0.357 2.711 ↓ 417.0 417 1

Sort (cost=174.88..174.89 rows=1 width=206) (actual time=2.635..2.711 rows=417 loops=1)

  • Sort Key: v_transit_roads.link_id, v_transit_roads.street_name, v_transit_roads.road_speed, v_transit_roads.road_rank, v_transit_roads.truck, v_transit_roads.surface, v_transit_roads.road_km, v_transit_roads.geometry
  • Sort Method: quicksort Memory: 145kB
7. 0.234 2.354 ↓ 417.0 417 1

Nested Loop Left Join (cost=4.73..174.87 rows=1 width=206) (actual time=0.170..2.354 rows=417 loops=1)

  • Join Filter: NULL::boolean
8. 2.055 2.120 ↓ 417.0 417 1

Bitmap Heap Scan on v_transit_roads (cost=4.73..174.86 rows=1 width=206) (actual time=0.166..2.120 rows=417 loops=1)

  • Recheck Cond: ((street_name)::text = ANY ('{"Gore Hwy"}'::text[]))
  • Filter: ((geometry && '0103000020110F00000100000005000000EC511814C3F26F41CDCCCC56F6E247C1EC511814C3F26F410AD723DBB51449C13D0A977A991F70410AD723DBB51449C13D0A977A991F7041CDCCCC56F6E247C1EC511814C3F26F41CDCCCC56F6E247C1'::geometry) AND _st_intersects(geometry, '0103000020110F00000100000005000000EC511814C3F26F41CDCCCC56F6E247C1EC511814C3F26F410AD723DBB51449C13D0A977A991F70410AD723DBB51449C13D0A977A991F7041CDCCCC56F6E247C1EC511814C3F26F41CDCCCC56F6E247C1'::geometry))
  • Rows Removed by Filter: 32
  • Heap Blocks: exact=119
9. 0.065 0.065 ↓ 11.0 449 1

Bitmap Index Scan on idx_v_transit_roads_street_name (cost=0.00..4.73 rows=41 width=0) (actual time=0.065..0.065 rows=449 loops=1)

  • Index Cond: ((street_name)::text = ANY ('{"Gore Hwy"}'::text[]))
10. 0.000 0.000 ↓ 0.0 0 417

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=417)

  • One-Time Filter: false
Planning time : 0.899 ms