Обсуждение: logging options...

Поиск
Список
Период
Сортировка

logging options...

От
Jessica Richard
Дата:
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...

Thanks,
Jessica

Re: logging options...

От
Guillaume Lelarge
Дата:
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