Re: Query much slower when run from postgres function

Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr> writes:
> Is this difference normal?

It's hard to tell, because you aren't comparing apples to apples.
Try a prepared statement, like

prepare foo(int) as
SELECT
COUNT(*)::int4
FROM
_v1
WHERE
service_id = $1
;

execute foo(504);

which should produce results similar to the function. You could
then use "explain analyze execute" to probe further into what's
happening.

regards, tom lane