explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AsAY

Settings
# exclusive inclusive rows x rows loops node
1. 7.877 118,394.334 ↑ 83,246.4 7 1

HashAggregate (cost=21,512,660.35..21,576,760.10 rows=582,725 width=125) (actual time=118,387.795..118,394.334 rows=7 loops=1)

  • Group Key: road_movements.trip_id, (road_movements.mov_cst * '2'::real)
2.          

CTE boundaries

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on v_transit_boundaries (cost=0.00..1,218.40 rows=3,404 width=78,632) (never executed)

4. 0.000 118,386.457 ↑ 1,689.5 3,167 1

Nested Loop Left Join (cost=143,930.16..21,484,689.25 rows=5,350,541 width=121) (actual time=46,370.246..118,386.457 rows=3,167 loops=1)

  • Join Filter: NULL::boolean
5. 335.119 118,592.328 ↑ 1,689.5 3,167 1

Gather (cost=143,930.16..20,936,258.79 rows=5,350,541 width=117) (actual time=46,370.234..118,592.328 rows=3,167 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
6. 4.928 118,257.209 ↑ 2,113.2 633 5 / 5

Parallel Hash Join (cost=142,930.16..20,400,204.69 rows=1,337,635 width=117) (actual time=19,653.198..118,257.209 rows=633 loops=5)

  • Hash Cond: (road_segments.link_id = v_transit_roads.link_id)
7. 3.218 118,114.749 ↑ 2,113.2 633 5 / 5

Parallel Hash Join (cost=70,557.29..20,324,320.33 rows=1,337,635 width=125) (actual time=19,512.935..118,114.749 rows=633 loops=5)

  • Hash Cond: (road_segments.trip_id = road_movements.trip_id)
8. 14,466.625 117,194.656 ↑ 42,843.2 633 5 / 5

Parallel Hash Join (cost=5,730.17..20,188,299.04 rows=27,119,777 width=24) (actual time=18,594.661..117,194.656 rows=633 loops=5)

  • Hash Cond: (road_segments.trip_id = road_segments_1.trip_id)
9. 102,725.534 102,725.534 ↑ 1.3 118,754,299 5 / 5

Parallel Seq Scan on road_segments (cost=0.00..19,792,384.00 rows=148,442,880 width=16) (actual time=0.023..102,725.534 rows=118,754,299 loops=5)

10. 0.193 2.497 ↑ 2,188.0 1 5 / 5

Parallel Hash (cost=5,505.90..5,505.90 rows=2,188 width=8) (actual time=2.496..2.497 rows=1 loops=5)

  • Buckets: 8,192 Batches: 1 Memory Usage: 192kB
11. 1.869 2.304 ↑ 2,188.0 1 5 / 5

Parallel Bitmap Heap Scan on road_segments road_segments_1 (cost=32.64..5,505.90 rows=2,188 width=8) (actual time=2.292..2.304 rows=1 loops=5)

  • Recheck Cond: (link_id = 1,201,710,493)
  • Heap Blocks: exact=2
12. 0.435 0.435 ↑ 750.1 7 1 / 5

Bitmap Index Scan on idx_road_segments_link_id (cost=0.00..31.33 rows=5,251 width=0) (actual time=2.177..2.177 rows=7 loops=1)

  • Index Cond: (link_id = 1,201,710,493)
13. 130.234 916.875 ↑ 1.6 116,545 5 / 5

Parallel Hash (cost=45,559.58..45,559.58 rows=187,976 width=117) (actual time=916.874..916.875 rows=116,545 loops=5)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 103,840kB
14. 786.641 786.641 ↑ 1.6 116,545 5 / 5

Parallel Seq Scan on road_movements (cost=0.00..45,559.58 rows=187,976 width=117) (actual time=18.508..786.641 rows=116,545 loops=5)

15. 69.356 137.532 ↑ 1.2 174,222 5 / 5

Parallel Hash (cost=50,050.73..50,050.73 rows=217,777 width=8) (actual time=137.532..137.532 rows=174,222 loops=5)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 42,368kB
16. 68.176 68.176 ↑ 1.2 174,222 5 / 5

Parallel Seq Scan on v_transit_roads (cost=0.00..50,050.73 rows=217,777 width=8) (actual time=0.387..68.176 rows=174,222 loops=5)

17. 0.000 0.000 ↓ 0.0 0 3,167

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=3,167)

  • One-Time Filter: false