Re: Locks analysis after-the-fact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Locks analysis after-the-fact
Date: 2018-04-27 14:55:53
Message-ID: 24776.1524840953@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Olleg Samoylov <splarv(at)ya(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Lembark 2018-04-27 15:18:43 Re: decompose big queries
Previous Message Steven Lembark 2018-04-27 14:55:37 Re: Rationale for aversion to the central database?