From: Joshua D. Drake <jd@commandprompt.com>
To: Natalie Wenz <nataliewenz@ebureau.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Inspect values of prepared statements
Date: Mon, 2 May 2016 11:06:56 -0700
Message-ID: <57279740.9080300@commandprompt.com> (raw)
In-Reply-To: <1B7B1A44-6B19-46AF-8ED8-74098F43B45C@ebureau.com>
References: <26FFD5EA-0317-497F-9CCA-BC80C6A1CA6C@ebureau.com>
<5727943C.4050008@commandprompt.com>
<1B7B1A44-6B19-46AF-8ED8-74098F43B45C@ebureau.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 05/02/2016 11:00 AM, Natalie Wenz wrote:
> Is it possible to turn that on without interrupting current traffic?
Yes with a HUP or reload.
JD
>
>
>> On May 2, 2016, at 12:54 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>>
>> On 05/02/2016 10:51 AM, Natalie Wenz wrote:
>>> Is there any way for an administrator to view the values of a prepared statement that is currently executing?
>>
>> statement logging will do it.
>>
>>>
>>> Thanks!
>>> Natalie
>>>
>>
>>
>> --
>> Command Prompt, Inc. http://the.postgres.company/
>> +1-503-667-4564
>> PostgreSQL Centered full stack support, consulting and development.
>> Everyone appreciates your honesty, until you are honest with them.
>
>
>
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, nataliewenz@ebureau.com
Subject: Re: Inspect values of prepared statements
In-Reply-To: <57279740.9080300@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox