On 27 June 2012 16:56, Andy Halsall <halsall_andy@hotmail.com> wrote:
> LOG: duration: 0.497 ms plan:
> Query Text: select * from sp_select_by_node_rel($1,$2)
> Function Scan on public.sp_select_by_node_rel (cost=0.25..0.26
> rows=1 width=296) (actual time=0.482..0.483 rows=1 loo
> ps=1)
> Output: tn_type, rel_type, tn_c_state, tn_sort, tn_d_state,
> tn_create_order, stn_guid, tsn_guid, tn_gen_perms, tn_au
> dit, rel_state, sp_perms, rel_control, prime_key, prime_key_len, sec_key,
> sec_key_len, u_prime_key, u_prime_key_len, u_sec_key
> , u_sec_key_len
>
> Function Call: sp_select_by_node_rel(82677::bigint, 71346::bigint)
> Buffers: shared hit=6
Seems OK to me.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services