David Wheeler <david@kineticode.com> writes:
> Just on a lark, I tried to get this to work:
> try=# explain analyze EXECUTE foo(1, ARRAY
> [600001,600002,600003,600004,600005,600006,600007]);
> QUERY PLAN
> ------------------------------------------------------------------------
> --------------
> Result (cost=0.00..0.01 rows=1 width=0) (actual time=26.241..26.251
> rows=1 loops=1)
> Total runtime: 27.512 ms
> (2 rows)
> That's not much use.
It looks like you had something trivial as the definition of foo().
Try one of the actual queries from the plpgsql function.
regards, tom lane