Re: seperate Slow log file
От | Ankur Kaushik |
---|---|
Тема | Re: seperate Slow log file |
Дата | |
Msg-id | CALXoLqy9CuJYsez4o=k0q7wjO+qkpZpzHa7JkJRwL0=V9CzWvw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: seperate Slow log file (Guillaume Lelarge <guillaume@lelarge.info>) |
Ответы |
Re: seperate Slow log file
|
Список | pgsql-admin |
So is there way to find the last error , Identify and discriminate slow queries on the bases of time taken . as while i use Mysql There are separate logs for slow,general and error logs. ?
On Sat, Jan 23, 2016 at 12:14 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le 23 janv. 2016 6:59 AM, "Ankur Kaushik" <ankurkaushik@gmail.com> a écrit :
>
>
> To open the slow query log file I Change the variable as below
>
> log_min_duration_statement=100 in config file
>
> All Slow queries are logging in "postgresql-Sat.log" where errors also comes to , So is there way to have separate slow query logs
>No, all logs go to the same log file.
В списке pgsql-admin по дате отправления: