explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WARF

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 52,439.805 ↑ 4.2 48 1

Sort (cost=462,485.88..462,486.38 rows=200 width=32) (actual time=52,439.803..52,439.805 rows=48 loops=1)

  • Sort Key: tblmovements.commodity
  • Sort Method: quicksort Memory: 28kB
2. 55.621 52,439.752 ↑ 4.2 48 1

HashAggregate (cost=462,472.73..462,478.23 rows=200 width=32) (actual time=52,439.738..52,439.752 rows=48 loops=1)

  • Group Key: tblmovements.commodity
3. 102.709 52,384.131 ↑ 12.8 23,437 1

Finalize HashAggregate (cost=447,434.33..454,953.53 rows=300,768 width=52) (actual time=52,342.571..52,384.131 rows=23,437 loops=1)

  • Group Key: tblmovements.trip_id
4. 21.271 52,281.422 ↑ 22.6 23,437 1

Gather (cost=383,895.05..439,491.92 rows=529,494 width=176) (actual time=52,192.310..52,281.422 rows=23,437 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
5. 20,712.809 52,260.151 ↑ 11.3 23,437 1

Partial HashAggregate (cost=382,895.05..385,542.52 rows=264,747 width=176) (actual time=52,191.883..52,260.151 rows=23,437 loops=1)

  • Group Key: tblmovements.trip_id
6. 9,562.525 31,547.342 ↓ 29.2 7,730,523 1

Parallel Hash Left Join (cost=16,007.41..374,952.64 rows=264,747 width=35) (actual time=1,327.262..31,547.342 rows=7,730,523 loops=1)

  • Hash Cond: (tblsegments.trip_id = v_transit_movement_extras.trip_id)
7. 9,989.031 21,472.376 ↓ 29.2 7,730,523 1

Parallel Hash Left Join (cost=10,151.70..366,546.80 rows=264,747 width=35) (actual time=796.242..21,472.376 rows=7,730,523 loops=1)

  • Hash Cond: (tblsegments.trip_id = tblmovements.trip_id)
8. 9,839.278 10,764.841 ↓ 29.2 7,730,523 1

Nested Loop (cost=1.00..355,701.13 rows=264,747 width=8) (actual time=59.226..10,764.841 rows=7,730,523 loops=1)

9. 922.118 922.118 ↓ 2.5 1,975 1

Parallel Index Only Scan using idx_v_transit_roads_agg on v_transit_roads (cost=0.42..30,159.92 rows=784 width=8) (actual time=59.190..922.118 rows=1,975 loops=1)

  • Filter: ((street_name)::text = ANY ('{"Warrego Hwy"}'::text[]))
  • Rows Removed by Filter: 770928
  • Heap Fetches: 0
10. 3.445 3.445 ↑ 2.5 3,914 1,975

Index Only Scan using idx_tblsegments_key on tblsegments (cost=0.57..317.82 rows=9,741 width=16) (actual time=0.068..3.445 rows=3,914 loops=1,975)

  • Index Cond: (link_id = v_transit_roads.link_id)
  • Heap Fetches: 0
11. 326.569 718.504 ↓ 2.4 300,768 1

Parallel Hash (cost=8,584.20..8,584.20 rows=125,320 width=27) (actual time=718.504..718.504 rows=300,768 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 23744kB
12. 391.935 391.935 ↓ 2.4 300,768 1

Parallel Seq Scan on tblmovements (cost=0.00..8,584.20 rows=125,320 width=27) (actual time=0.007..391.935 rows=300,768 loops=1)

13. 299.641 512.441 ↓ 1.7 298,650 1

Parallel Hash (cost=3,659.76..3,659.76 rows=175,676 width=16) (actual time=512.441..512.441 rows=298,650 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 18112kB
14. 212.800 212.800 ↓ 1.7 298,650 1

Parallel Seq Scan on v_transit_movement_extras (cost=0.00..3,659.76 rows=175,676 width=16) (actual time=0.009..212.800 rows=298,650 loops=1)