Jessica Richard a écrit : > for a short test purpose, I would like to see what queries are running > and how long each of them takes.....by reconfiguring postgres.conf on > the server level. > > log_statement = 'all' is giving me the query statements.. but I don't > know where I can turn "timing" on just like what I can run from the > command line "\timing'....to measure how long each of the queries takes > to finish... > Either you configure log_statement to all, ddl or mod and log_duration to on, either you configure log_min_duration_statement to 0. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com
