explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rlat

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,145.936 ↑ 328.6 7 1

Finalize GroupAggregate (cost=6,479,385.17..6,480,065.62 rows=2,300 width=38) (actual time=8,145.923..8,145.936 rows=7 loops=1)

  • Group Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
  • Functions: 54
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.302 ms, Inlining 105.804 ms, Optimization 544.227 ms, Emission 412.824 ms, Total 1071.157 ms
2. 94.336 8,223.126 ↑ 219.0 21 1

Gather Merge (cost=6,479,385.17..6,479,921.87 rows=4,600 width=66) (actual time=8,145.907..8,223.126 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.046 8,128.790 ↑ 328.6 7 3 / 3

Sort (cost=6,478,385.14..6,478,390.89 rows=2,300 width=66) (actual time=8,128.790..8,128.790 rows=7 loops=3)

  • Sort Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 847.500 8,128.744 ↑ 328.6 7 3 / 3

Partial HashAggregate (cost=6,478,233.72..6,478,256.72 rows=2,300 width=66) (actual time=8,128.724..8,128.744 rows=7 loops=3)

  • Group Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
5. 591.034 7,281.244 ↓ 2.3 2,953,525 3 / 3

Nested Loop Left Join (cost=5,672.18..6,449,840.52 rows=1,261,920 width=38) (actual time=426.280..7,281.244 rows=2,953,525 loops=3)

  • Join Filter: NULL::boolean
6. 1,151.764 6,690.210 ↓ 2.3 2,953,525 3 / 3

Nested Loop (cost=5,672.18..6,437,221.32 rows=1,261,920 width=38) (actual time=426.275..6,690.210 rows=2,953,525 loops=3)

7. 264.479 280.583 ↑ 1.2 107,303 3 / 3

Parallel Bitmap Heap Scan on mv_transit_roads_aggregated (cost=5,671.75..722,624.98 rows=126,193 width=132) (actual time=71.330..280.583 rows=107,303 loops=3)

  • Recheck Cond: (commod_id = ANY ('{1}'::integer[]))
  • Heap Blocks: exact=53,990
8. 16.104 16.104 ↓ 1.1 321,910 1 / 3

Bitmap Index Scan on idx_mv_transit_roads_aggregated_v10d3_commod_id (cost=0.00..5,596.03 rows=302,863 width=0) (actual time=48.311..48.311 rows=321,910 loops=1)

  • Index Cond: (commod_id = ANY ('{1}'::integer[]))
9. 5,257.863 5,257.863 ↓ 2.8 28 321,910 / 3

Index Scan using road_movements_pkey on road_movements (cost=0.42..45.18 rows=10 width=28) (actual time=0.002..0.049 rows=28 loops=321,910)

  • Index Cond: (trip_id = ANY (mv_transit_roads_aggregated.trip_ids))
10. 0.000 0.000 ↓ 0.0 0 8,860,575 / 3

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=8,860,575)

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