"Phoenix Kiula" <phoenix.kiula@xxxxxxxxx> writes: > In some examples posted to this forum, it seems to me that when people > execute queries in the psql window, they also see "90 ms taken" > (milliseconds), which denotes the time taken to execute the query. > Where can I set this option because I'm not seeing it in my psql > window on both Win XP and Linux. Thanks! I think you're looking for the \timing command? http://www.postgresql.org/docs/8.2/static/app-psql.html (under meta-commands, about halfway down the page) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
