On 8/15/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > 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!
If your on an OS with a time command (linux, windows with the gnu utils ported to it) you can do: time psql -c "select ..." OR you can do echo "\\\timing\nselect ...."|psql dbname This is all from linux. I don't know how this "windows" you speak of works really. Seriously, I stopped using it so long ago I'm lost when I'm on it. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
