Re: seperate Slow log file

From: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: seperate Slow log file
Date: 2016-01-23 07:29:54
Message-ID: CALXoLqy9CuJYsez4o=k0q7wjO+qkpZpzHa7JkJRwL0=V9CzWvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2016-01-23 07:54:18 Re: seperate Slow log file
Previous Message Guillaume Lelarge 2016-01-23 06:44:17 Re: seperate Slow log file