--- Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
