explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZzdV : single query function

Settings
# exclusive inclusive rows x rows loops node
1. 0.255 518.817 ↑ 1.0 299 1

Unique (cost=0.42..9,598,577,352.29 rows=303 width=16) (actual time=104.056..518.817 rows=299 loops=1)

  • Output: l.id
  • Buffers: shared hit=20,985
2. 0.835 518.562 ↑ 675,800,279.9 299 1

Nested Loop Left Join (cost=0.42..9,093,416,643.05 rows=202,064,283,698 width=16) (actual time=104.055..518.562 rows=299 loops=1)

  • Output: l.id
  • Join Filter: point_eq(d0.origin_point, l.destination_point)
  • Rows Removed by Join Filter: 6,566
  • Buffers: shared hit=20,985
3. 1.081 458.226 ↑ 26,169.5 299 1

Nested Loop Left Join (cost=0.42..510,332.50 rows=7,824,671 width=32) (actual time=44.783..458.226 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
  • Buffers: shared hit=11,449
4. 1.188 416.481 ↑ 1.0 299 1

Nested Loop Left Join (cost=0.42..145,587.39 rows=303 width=48) (actual time=4.464..416.481 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
  • Buffers: shared hit=1,913
5. 414.695 414.695 ↑ 1.0 299 1

Index Scan using loads_pk on v5search.loads l (cost=0.42..141,566.79 rows=303 width=80) (actual time=4.446..414.695 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
  • Buffers: shared hit=1,912
6. 0.591 0.598 ↑ 51.8 17 299

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

  • Output: c.carriergroupid
  • Buffers: shared hit=1
7. 0.007 0.007 ↑ 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.006..0.007 rows=17 loops=1)

  • Output: c.carriergroupid
  • Buffers: shared hit=1
8. 0.395 40.664 ↑ 3,521.5 22 299

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

  • Output: d.destination_point
  • Buffers: shared hit=9,536
9. 40.269 40.269 ↑ 3,521.5 22 1

Seq Scan on public.deadhead d (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=6.802..40.269 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 hit=9,536
10. 0.298 59.501 ↑ 3,521.5 22 299

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

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

Seq Scan on public.deadhead d0 (cost=0.00..12,441.19 rows=77,472 width=16) (actual time=10.275..59.203 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 : 5.037 ms
Execution time : 518.944 ms