David Wheeler <david@xxxxxxxxxxxxxx> 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
