--- Tom Lane <tgl@sss.pgh.pa.us> skrev:
>
> Please --- I'm still curious why the estimated cost changed so much from
> 7.4 to 8.2. I can believe a marginal change in cost leading to a plan
Is this the output you need?
logistics_82=# prepare foo(int) as select id from step_result_subset where uut_Result = $1 and
step_parent = 0;
PREPARE
logistics_82=# explain analyze execute foo(180226);
QUERY PLAN
-----------------------------------------------
Index Scan using step_result_uut_result_idx on step_result_subset (cost=0.00..563.85 rows=23
width=4) (actual time=0.069..0.069 rows=0 loops=1)
Index Cond: (uut_result = $1)
Filter: (step_parent = 0)
Total runtime: 0.112 ms
(4 rows)
Best regards,
Rolf Østvik
__________________________________________________
Bruker du Yahoo!?
Lei av spam? Yahoo! Mail har den beste spambeskyttelsen
http://no.mail.yahoo.com