explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WCnM

Settings
# exclusive inclusive rows x rows loops node
1. 535.041 4,015.944 ↑ 666,894,177.2 260,932 1

Nested Loop Left Join (cost=0.00..7,830,938,933,890.79 rows=174,014,031,432,707 width=16) (actual time=421.877..4,015.944 rows=260,932 loops=1)

  • Output: l.id
  • Join Filter: point_eq(d0.origin_point, l.destination_point)
  • Rows Removed by Join Filter: 5,733,392
  • Buffers: shared hit=9,536 read=42,780
2. 697.130 2,959.039 ↑ 25,824.6 260,932 1

Nested Loop Left Join (cost=0.00..306,723,720.89 rows=6,738,462,238 width=32) (actual time=389.267..2,959.039 rows=260,932 loops=1)

  • Output: l.id, l.destination_point
  • Join Filter: point_eq(d.destination_point, l.origin_point)
  • Rows Removed by Join Filter: 5,735,536
  • Buffers: shared read=42,780
3. 841.989 1,479.113 ↑ 1.0 260,932 1

Nested Loop Left Join (cost=0.00..3,480,254.98 rows=260,938 width=48) (actual time=3.467..1,479.113 rows=260,932 loops=1)

  • Output: l.id, l.origin_point, l.destination_point
  • Join Filter: (l.carrier_groups ? c.carriergroupid)
  • Rows Removed by Join Filter: 4,435,787
  • Buffers: shared read=33,244
4. 376.195 376.195 ↑ 1.0 260,929 1

Seq Scan on v5search.loads l (cost=0.00..35,852.38 rows=260,938 width=80) (actual time=1.969..376.195 rows=260,929 loops=1)

  • Output: l.id, l.origin_point, l.destination_point, l.carrier_groups
  • Buffers: shared read=33,243
5. 259.451 260.929 ↑ 51.8 17 260,929

Materialize (cost=0.00..23.20 rows=880 width=32) (actual time=0.000..0.001 rows=17 loops=260,929)

  • Output: c.carriergroupid
  • Buffers: shared read=1
6. 1.478 1.478 ↑ 51.8 17 1

Seq Scan on v5search_private.carrier_group_carrier_array c (cost=0.00..18.80 rows=880 width=32) (actual time=1.476..1.478 rows=17 loops=1)

  • Output: c.carriergroupid
  • Buffers: shared read=1
7. 397.076 782.796 ↑ 3,521.5 22 260,932

Materialize (cost=0.00..12,828.55 rows=77,472 width=16) (actual time=0.000..0.003 rows=22 loops=260,932)

  • Output: d.destination_point
  • Buffers: shared read=9,536
8. 385.720 385.720 ↑ 3,521.5 22 1

Seq Scan on public.deadhead d (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=61.980..385.720 rows=22 loops=1)

  • Output: d.destination_point
  • Filter: point_eq(d.origin_point, '(-87.8950999999999993,41.9724000000000004)'::point)
  • Rows Removed by Filter: 232,536
  • Buffers: shared read=9,536
9. 489.283 521.864 ↑ 3,521.5 22 260,932

Materialize (cost=0.00..12,828.55 rows=77,472 width=16) (actual time=0.000..0.002 rows=22 loops=260,932)

  • Output: d0.origin_point
  • Buffers: shared hit=9,536
10. 32.581 32.581 ↑ 3,521.5 22 1

Seq Scan on public.deadhead d0 (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=6.363..32.581 rows=22 loops=1)

  • Output: d0.origin_point
  • Filter: point_eq(d0.destination_point, '(-95.2335999999999956,29.767199999999999)'::point)
  • Rows Removed by Filter: 232,536
  • Buffers: shared hit=9,536
Planning time : 11.291 ms
Execution time : 4,034.224 ms