Re: Currently running queries with actual arguments?

From: rihad <rihad(at)mail(dot)ru>
To: Garfield Lewis <garfield(dot)lewis(at)lzlabs(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Currently running queries with actual arguments?
Date: 2021-09-23 16:51:49
Message-ID: ff6a5a5c-6fa2-90dc-1a52-e7ee1a839030@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/23/21 7:58 PM, Garfield Lewis wrote:
> The way I normally get this info is by setting the following:
>
> log_statement = 'all'
>
> then the arguments will be printed in the postgres.log file. There could be some other way but that is what I know.
>

Thanks, those queries are logged after their completion, but I
specifically need the list of unfinished long queries currently being
executed.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-09-23 17:08:38 Re: Faster distinct query?
Previous Message Israel Brewster 2021-09-23 16:45:09 Re: Faster distinct query?