Re: seperate Slow log file

I highly recommend pgbadger

http://dalibo.github.io/pgbadger/

It will give you more analysis into your logs than a simple, separate slow
query log ever could.

On Sat, Jan 23, 2016 at 2:29 AM, Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
wrote:

>
> 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(at)lelarge(dot)info> wrote:
>
>> Le 23 janv. 2016 6:59 AM, "Ankur Kaushik" <ankurkaushik(at)gmail(dot)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.
>>
>
>