explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8R6f : function with notify

Settings
# exclusive inclusive rows x rows loops node
1. 0.211 2,898.798 ↓ 1.7 299 1

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

  • Output: id
  • Group Key: ld.id
2. 2,898.587 2,898.587 ↑ 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,788.968..2,898.587 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.155 ms
Execution time : 2,932.726 ms