explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GJA8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 695.548 ↑ 328.6 7 1

Finalize GroupAggregate (cost=727,562.22..728,242.67 rows=2,300 width=38) (actual time=695.535..695.548 rows=7 loops=1)

  • Group Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
  • Functions: 39
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.677 ms, Inlining 135.868 ms, Optimization 437.966 ms, Emission 333.577 ms, Total 913.088 ms
2. 95.175 775.493 ↑ 219.0 21 1

Gather Merge (cost=727,562.22..728,098.92 rows=4,600 width=66) (actual time=695.520..775.493 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.040 680.318 ↑ 328.6 7 3 / 3

Sort (cost=726,562.20..726,567.95 rows=2,300 width=66) (actual time=680.318..680.318 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. 27.189 680.278 ↑ 328.6 7 3 / 3

Partial HashAggregate (cost=726,410.77..726,433.77 rows=2,300 width=66) (actual time=680.260..680.278 rows=7 loops=3)

  • Group Key: mv_transit_roads_aggregated.orig_type, mv_transit_roads_aggregated.dest_type
5. 38.318 653.089 ↑ 1.2 107,303 3 / 3

Nested Loop Left Join (cost=5,671.75..723,886.91 rows=126,193 width=38) (actual time=385.646..653.089 rows=107,303 loops=3)

  • Join Filter: NULL::boolean
6. 275.327 292.861 ↑ 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=38) (actual time=82.729..292.861 rows=107,303 loops=3)

  • Recheck Cond: (commod_id = ANY ('{1}'::integer[]))
  • Heap Blocks: exact=62,414
7. 17.534 17.534 ↓ 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=52.602..52.602 rows=321,910 loops=1)

  • Index Cond: (commod_id = ANY ('{1}'::integer[]))
8. 321.910 321.910 ↓ 0.0 0 321,910 / 3

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.003..0.003 rows=0 loops=321,910)

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