explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yq73 : function with insert

Settings
# exclusive inclusive rows x rows loops node
1. 0.342 2,768.140 ↓ 1.7 299 1

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

  • Output: id
  • Group Key: ld.id
  • Buffers: shared hit=52,320, temp read=31,623 written=31,622
2. 2,767.798 2,767.798 ↑ 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,639.007..2,767.798 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
  • Buffers: shared hit=52,320, temp read=31,623 written=31,622
Planning time : 0.078 ms
Execution time : 2,800.438 ms