Re: Currently running queries with actual arguments?

From: Garfield Lewis <garfield(dot)lewis(at)lzlabs(dot)com>
To: rihad <rihad(at)mail(dot)ru>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Currently running queries with actual arguments?
Date: 2021-09-23 15:58:17
Message-ID: FB2D6F2B-FCDF-4195-8092-9FA0A0515EC3@lzlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Regards,
Garfield

On 2021-09-23, 11:33 AM, "rihad" <rihad(at)mail(dot)ru> wrote:

Hi, is it possible to view the list of currently running queries with
$1, $2 etc replaced with the actual arguments?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2021-09-23 16:02:38 Re: Faster distinct query?
Previous Message rihad 2021-09-23 15:32:59 Currently running queries with actual arguments?