explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AbE8 : query

Settings
# exclusive inclusive rows x rows loops node
1. 0.654 237.053 ↑ 675,800,279.9 299 1

Nested Loop Left Join (cost=0.00..9,093,311,580.98 rows=202,064,283,698 width=16) (actual time=77.251..237.053 rows=299 loops=1)

  • Output: l.id
  • Join Filter: point_eq(d0.origin_point, l.destination_point)
  • Rows Removed by Join Filter: 6,566
2. 0.470 198.127 ↑ 26,169.5 299 1

Nested Loop Left Join (cost=0.00..405,270.43 rows=7,824,671 width=32) (actual time=39.314..198.127 rows=299 loops=1)

  • Output: l.id, l.destination_point
  • Join Filter: point_eq(d.destination_point, l.origin_point)
  • Rows Removed by Join Filter: 6,570
3. 1.221 160.282 ↑ 1.0 299 1

Nested Loop Left Join (cost=0.00..40,525.32 rows=303 width=48) (actual time=2.411..160.282 rows=299 loops=1)

  • Output: l.id, l.origin_point, l.destination_point
  • Join Filter: (l.carrier_groups ? c.carriergroupid)
  • Rows Removed by Join Filter: 5,083
4. 158.762 158.762 ↑ 1.0 299 1

Seq Scan on v5search.loads l (cost=0.00..36,504.72 rows=303 width=80) (actual time=2.392..158.762 rows=299 loops=1)

  • Output: l.id, l.origin_point, l.destination_point, l.carrier_groups
  • Filter: (l.dimensions_width > '18'::double precision)
  • Rows Removed by Filter: 260,630
5. 0.293 0.299 ↑ 51.8 17 299

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

  • Output: c.carriergroupid
6. 0.006 0.006 ↑ 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=0.005..0.006 rows=17 loops=1)

  • Output: c.carriergroupid
7. 0.509 37.375 ↑ 3,521.5 22 299

Materialize (cost=0.00..12,828.55 rows=77,472 width=16) (actual time=0.018..0.125 rows=22 loops=299)

  • Output: d.destination_point
8. 36.866 36.866 ↑ 3,521.5 22 1

Seq Scan on public.deadhead d (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=5.392..36.866 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
9. 0.372 38.272 ↑ 3,521.5 22 299

Materialize (cost=0.00..12,828.55 rows=77,472 width=16) (actual time=0.026..0.128 rows=22 loops=299)

  • Output: d0.origin_point
10. 37.900 37.900 ↑ 3,521.5 22 1

Seq Scan on public.deadhead d0 (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=7.761..37.900 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
Planning time : 0.159 ms
Execution time : 237.139 ms