"s d" <s.d.sauron@xxxxxxxxx> 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
