Postgres Pro
Downloads
Home   >   mailing lists

Re: Currently running queries with actual arguments? - Mailing list pgsql-general

From Garfield Lewis
Subject Re: Currently running queries with actual arguments?
Date
Msg-id FB2D6F2B-FCDF-4195-8092-9FA0A0515EC3@lzlabs.com
Whole thread Raw
In response to Currently running queries with actual arguments?  (rihad <rihad@mail.ru>)
Responses Re: Currently running queries with actual arguments?  (rihad <rihad@mail.ru>)
List pgsql-general
Tree view 
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@mail.ru> wrote:

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

pgsql-general by date:

Previous
From: rihad
Date:
Subject: Currently running queries with actual arguments?
Next
From: Israel Brewster
Date:
Subject: Re: Faster distinct query?