Re: Locks analysis after-the-fact - Mailing list pgsql-general

From Tom Lane
Subject Re: Locks analysis after-the-fact
Date
Msg-id 24776.1524840953@sss.pgh.pa.us
Whole thread Raw
In response to Re: Locks analysis after-the-fact  (Olleg Samoylov <splarv@ya.ru>)
List pgsql-general
Olleg Samoylov <splarv@ya.ru> writes:
> On 2018-04-27 10:55, Olivier Macchioni wrote:
>> Does anyone have an idea on how to process in such a case?

> Log statments too. :)

Another idea is to get the app to set application_name differently for
each session (and be sure to include %a in log_line_prefix).  It might
not be practical in this particular case, but it's a good tool to keep
in mind.

            regards, tom lane


pgsql-general by date:

Previous
From: Steven Lembark
Date:
Subject: Re: Rationale for aversion to the central database?
Next
From: Steven Lembark
Date:
Subject: Re: decompose big queries