I am using PostGIS to calculate length of interactions between two types of employees. I am performing the same set of operations for each area id$.$ Here is my code:

CREATE OR REPLACE FUNCTION public.interactions$\_$looped$\_$ucmo$\_$aic$($areaid$\_$array character varying$[],$ d$\_$date date, start$\_$time$\_\_$ timestamp without time zone, end$\_$time$\_\_$ timestamp without time zone$)$

RETURNS TABLE$($area$\_$id uuid, "createdAt$\_"$ timestamp without time zone, "updatedAt$\_"$ timestamp without time zone, $"$ID$\_"$ character varying, parent$\_$imei character varying, child$\_$imei character varying, parent$\_$ping$\_$time timestamp without time zone, child$\_$ping$\_$time timestamp without time zone, maxima timestamp without time zone, minima timestamp without time zone, "interactionID" character varying, interaction$\_$type character varying$)$

LANGUAGE plpgsql

AS $function$

DECLARE

i integer :$=1$;

BEGIN

FOR i IN $1..$array$\_$length$($areaid$\_$array, $1)$ LOOP

RETURN QUERY

with pings as $($

select

$*$

from

$(--=================$ SELECTING Parent INFO

select

p$.$imei,

st$\_$transform$($p$.$"geoJson", $32643)$ as geom,

"generatedAt" as t$,$

p$."$ID$"$ as u$\_$ping$\_$id

from

campaign$\_$pings p

where

"generatedAt" $+$ interval $\text{'}5$ hours' between start$\_$time$\_\_$ and end$\_$time$\_\_$

and

p$.$imei in $($

$--$multiple left joins

$)$

$)$ u

left join $(--=================$ SELECTING child INFO

SELECT

p$.$imei,

p$."$ID$"$ as a$\_$ping$\_$id$,$

st$\_$transform$($p$.$"geoJson", $32643)$ as geom,

"generatedAt" as t

FROM

campaign$\_$pings p

where

"generatedAt"$+$ interval $\text{'}5$ hours' between start$\_$time$\_\_$ and end$\_$time$\_\_$

and

p$.$imei in $($

$--$multiple left joins

$)$

$)$ a on ST$\_$DWithin$($u$.$"geom", a$.$"geom", $30)$

and a$.$t BETWEEN u$.$t $-$ INTERVAL $\text{'}30$ seconds'

and u$.$t $+$ INTERVAL $\text{'}30$ seconds'

where

a$.$imei is not null

$)$

$--$more code to calculate length of continuous interactions in minutes

;

END LOOP;

END

$function$

;

So essentially, I am performing the same set of operations for each area id$.$ Is there a way to make use of caching here to reduce execution time? I mean to enforce the use of cache.