"s d" <s(dot)d(dot)sauron(at)gmail(dot)com> writes:
> 1. i can undestand where the cost=11.53 came from but where did the
> 1192.09 come form? The values are in milli right ?
No, the unit of estimated cost is 1 disk page fetch. See
http://www.postgresql.org/docs/8.2/static/using-explain.html
regards, tom lane