explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erHW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 75.963 ↑ 6,518,406.5 4 1

Group (cost=2,577,542.70..6,193,624.68 rows=26,073,626 width=118) (actual time=75.826..75.963 rows=4 loops=1)

  • Group Key: tblmovements.trip_id, ((tblmovements.tonnes)::real), ((tblmovements.tonnes_per_trailer)::real), v_transit_movement_extras.total_km, v_transit_movement_extras.total_hr, ((v_transit_movement_extras.mov_cst * '2'::double precision))
2. 0.000 79.619 ↑ 5,432,005.5 4 1

Gather Merge (cost=2,577,542.70..5,411,415.89 rows=21,728,022 width=114) (actual time=75.821..79.619 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.195 211.665 ↑ 10,864,011.0 1 3

Group (cost=2,576,542.67..2,902,463.00 rows=10,864,011 width=114) (actual time=70.471..70.555 rows=1 loops=3)

  • Group Key: tblmovements.trip_id, ((tblmovements.tonnes)::real), ((tblmovements.tonnes_per_trailer)::real), v_transit_movement_extras.total_km, v_transit_movement_extras.total_hr, ((v_transit_movement_extras.mov_cst * '2'::double precision))
4. 0.762 211.470 ↑ 30,431.4 357 3

Sort (cost=2,576,542.67..2,603,702.70 rows=10,864,011 width=114) (actual time=70.468..70.490 rows=357 loops=3)

  • Sort Key: tblmovements.trip_id, ((tblmovements.tonnes)::real), ((tblmovements.tonnes_per_trailer)::real), v_transit_movement_extras.total_km, v_transit_movement_extras.total_hr, ((v_transit_movement_extras.mov_cst * '2'::double precision))
  • Sort Method: quicksort Memory: 198kB
  • Worker 0: Sort Method: quicksort Memory: 136kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
5. 5.619 210.708 ↑ 30,431.4 357 3

Parallel Hash Left Join (cost=6,298.50..638,525.62 rows=10,864,011 width=114) (actual time=56.795..70.236 rows=357 loops=3)

  • Hash Cond: (tblsegments.trip_id = v_transit_movement_extras.trip_id)
6. 0.192 83.178 ↑ 30,431.4 357 3

Nested Loop (cost=442.79..468,351.34 rows=10,864,011 width=101) (actual time=14.548..27.726 rows=357 loops=3)

7. 35.169 82.650 ↑ 4,023.0 1 3

Hash Join (cost=442.22..9,355.39 rows=4,023 width=101) (actual time=14.521..27.550 rows=1 loops=3)

  • Hash Cond: (tblmovements.trip_id = tblsegments_1.trip_id)
8. 46.845 46.845 ↑ 1.2 100,256 3

Parallel Seq Scan on tblmovements (cost=0.00..8,584.20 rows=125,320 width=93) (actual time=0.232..15.615 rows=100,256 loops=3)

9. 0.012 0.636 ↑ 2,413.8 4 3

Hash (cost=321.53..321.53 rows=9,655 width=8) (actual time=0.212..0.212 rows=4 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 129kB
10. 0.624 0.624 ↑ 2,413.8 4 3

Index Only Scan using idx_tblsegments_key on tblsegments tblsegments_1 (cost=0.57..321.53 rows=9,655 width=8) (actual time=0.206..0.208 rows=4 loops=3)

  • Index Cond: (link_id = 1195728634)
  • Heap Fetches: 0
11. 0.336 0.336 ↑ 10.0 268 4

Index Only Scan using idx_tblsegments_keyrev on tblsegments (cost=0.57..87.27 rows=2,682 width=16) (actual time=0.023..0.084 rows=268 loops=4)

  • Index Cond: (trip_id = tblmovements.trip_id)
  • Heap Fetches: 0
12. 76.485 121.911 ↑ 1.8 99,550 3

Parallel Hash (cost=3,659.76..3,659.76 rows=175,676 width=20) (actual time=40.636..40.637 rows=99,550 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 20512kB
13. 45.426 45.426 ↑ 1.8 99,550 3

Parallel Seq Scan on v_transit_movement_extras (cost=0.00..3,659.76 rows=175,676 width=20) (actual time=0.010..15.142 rows=99,550 loops=3)