explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m7v4 : function with notify

Settings
# exclusive inclusive rows x rows loops node
1. 0.196 2,737.571 ↓ 1.7 299 1

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

  • Output: id
  • Group Key: ld.id
  • Buffers: shared hit=52,332, temp read=31,623 written=31,622
2. 2,737.375 2,737.375 ↑ 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,629.277..2,737.375 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
  • Buffers: shared hit=52,332, temp read=31,623 written=31,622
Planning time : 0.159 ms
Execution time : 2,770.745 ms