From: Jason Mathis <jmathis@redzonesoftware.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>
Subject: Re: PostgreSQL 9.3 logging: separate log messages
Date: Mon, 31 Mar 2014 08:40:55 -0600
Message-ID: <etPan.53397e77.643c9869.1a0@palos> (raw)
In-Reply-To: <C09AEFAE-14BE-4B18-BCCF-29B5AC15839E@gmail.com>
References: <C09AEFAE-14BE-4B18-BCCF-29B5AC15839E@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
I am not exactly sure how to achieve just that, but have you checked out something like https://github.com/dalibo/pgbadger?
We use it here and love it. It parses out all your queries and does a great analysis on them. I have a script that emails me a report every morning.
-jason
On March 31, 2014 at 7:33:39 AM, Sergey Arlashin (sergeyarl.maillist@gmail.com) wrote:
Hi!
What is the proper way to separate queries from other messages while logging?
For example:
I have 'log_min_duration_statement' parameter in postgresql.conf . Therefore I get postgresql system messages and slow queries in one log file /var/log/postgresql/postgresql-9.3-main.log .
In order to simplify further reading I'd like to get slow queries in /var/log/postgresql/postgresql-slowqueries.log and all the rest in /var/log/postgresql/postgresql.log.
I tried to implement this by means of rsyslog but didn't manage to get any decent result.
Any help will be greatly appreciated :)
--
Best regards,
Sergey Arlashin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
This transmission contains confidential and privileged information intended
solely for the party identified above. If you receive this message in
error, you must not use it or convey it to others. Please destroy it
immediately and contact the sender at (303) 386-3955 or by return e-mail to
the sender.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jmathis@redzonesoftware.com, sergeyarl.maillist@gmail.com
Subject: Re: PostgreSQL 9.3 logging: separate log messages
In-Reply-To: <etPan.53397e77.643c9869.1a0@palos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox