explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jEqo

Settings
# exclusive inclusive rows x rows loops node
1. 0.207 2,420.962 ↓ 1.7 299 1

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

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

Function Scan on v5search.filter_loads_by_deadhead_miles_with_save ld (cost=0.25..12.75 rows=333 width=16) (actual time=2,317.585..2,420.755 rows=299 loops=1)

  • Output: id
  • Function Call: v5search.filter_loads_by_deadhead_miles_with_save('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.059 ms
Execution time : 2,449.774 ms