Postgres Pro
Downloads
Home   >   mailing lists

Thread: seperate Slow log file

seperate Slow log file

From
Ankur Kaushik
Date:

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


Re: seperate Slow log file

From
Guillaume Lelarge
Date:

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.

Re: seperate Slow log file

From
Ankur Kaushik
Date:

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.


Re: seperate Slow log file

From
Keith
Date:
I highly recommend 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@gmail.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@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.