Matching statement and duration log lines

From: Popov Aleksey <Aleksey(dot)Popov(at)annalect(dot)omd(dot)ru>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Matching statement and duration log lines
Date: 2017-10-23 13:06:07
Message-ID: HE1PR0201MB205705C9E46632B735943D89B1460@HE1PR0201MB2057.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I am sending PG logs to Elasticsearch and want to merge a line with statement and a line with duration into one document.
Having a statement line and a duration line, can I assume that if a session ids (%c) of these lines match,
and numbers of log lines (%l) are consecutive, then the duration line belongs to statement line?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Önder Kalacı 2017-10-23 13:19:41 Re: A question on pg_stat_subscription view
Previous Message Martin Moore 2017-10-23 08:14:18 Re: Postgres 9.6 fails to start on VMWare