Search Postgresql Archives

Re: Logging the query executed on the server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Jul 24, 2022 at 4:29 PM Igor Korot <ikorot01@xxxxxxxxx> wrote:

2 things:
1. How do I turn this off? ;-)

When you change the setting via 'set', that change is only for the current session. You can revert it with 'set {some param} to default;' or just terminate the session. If you want to make the change permanent, you need to set it in the config file.

2. The log does show the query but it shows it with the placeholders.
Is there a way to see the actual query?

Not sure what you mean here. The query shown in the log should be what is actually executed by the server. If you are using placeholders, there are probably 3 different log entries - one for the parse step, one for the bind step and one for the execute step. If you are asking what are the bind variable values, they are shown in the bind step. For example:

2022-07-24 07:00:00 UTC:10.122.33.196(33732):b2bc_api@b2bcreditonline:[7786]:LOG: duration: 0.072 ms bind <unnamed>:
select public.currency_on_mismatch() as on_mismatch,
set_config('search_path', $1, true),
set_config('application.user_id', $2, true),
set_config('application.app_client', $3, true),
set_config('application.api_client_id', $4 , true),
set_config('application.source', $5 , true),
set_config('application.request_id', $6 , true),
set_config('application.in_test_context', $7, true),
set_config('lock_timeout', $8, true),
txid_current()
2022-07-24 07:00:00 UTC:10.122.33.196(33732):b2bc_api@b2bcreditonline:[7786]:DETAIL: parameters: $1 = 'public', $2 = 'Admin/Support', $3 = 'Admin/Support', $4 = 'ce34e2bc-2c65-4fc1-9b95-878aef19a348', $5 = '?', $6 = '4432dbb2-ab1c-4bd8-a413-ff5c704209a6', $7 = 'f', $8 = '10s'

If this doesn't help, maybe post what you're seeing in the log.

Cheers,

Steve

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux