explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w1dg

Settings
# exclusive inclusive rows x rows loops node
1. 0.163 2,189.969 ↓ 1.7 299 1

HashAggregate (cost=13.58..15.32 rows=174 width=16) (actual time=2,189.938..2,189.969 rows=299 loops=1)

  • Output: id
  • Group Key: ld.id
2. 2,189.806 2,189.806 ↑ 1.1 299 1

Function Scan on v5search.filter_loads_by_deadhead_miles_with_notify ld (cost=0.25..12.75 rows=333 width=16) (actual time=2,098.632..2,189.806 rows=299 loops=1)

  • Output: id
  • Function Call: v5search.filter_loads_by_deadhead_miles_with_notify('41.9724000000000004'::double precision, '-87.8950999999999993'::double precision, '29.767199999999999'::double precision, '-95.2335999999999956'::double precision, 'DE8DC1F9-2995-EA11-AA57-BCE1060DB88B'::text)
  • Filter: (ld.dimensions_width > '18'::double precision)
  • Rows Removed by Filter: 260,633
Planning time : 0.139 ms
Execution time : 2,216.870 ms