explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D6oo

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

Finalize GroupAggregate (cost=6,479,385.17..6,480,065.62 rows=2,300 width=38) (actual time=8,405.428..8,405.445 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 7.298 ms, Inlining 116.382 ms, Optimization 564.898 ms, Emission 410.494 ms, Total 1099.072 ms
2. 98.872 8,486.479 ↑ 219.0 21 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.038 8,387.607 ↑ 328.6 7 3 / 3

Sort (cost=6,478,385.14..6,478,390.89 rows=2,300 width=66) (actual time=8,387.606..8,387.607 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. 871.415 8,387.569 ↑ 328.6 7 3 / 3

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

  • Group Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
5. 593.971 7,516.154 ↓ 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=444.063..7,516.154 rows=2,953,525 loops=3)

  • Join Filter: NULL::boolean
6. 1,137.878 6,922.183 ↓ 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=444.057..6,922.183 rows=2,953,525 loops=3)

7. 296.310 311.835 ↑ 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=79.569..311.835 rows=107,303 loops=3)

  • Recheck Cond: (commod_id = ANY ('{1}'::integer[]))
  • Heap Blocks: exact=55,092
8. 15.525 15.525 ↓ 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=46.576..46.576 rows=321,910 loops=1)

  • Index Cond: (commod_id = ANY ('{1}'::integer[]))
9. 5,472.470 5,472.470 ↓ 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.051 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.525 ms