Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1axIFP-0005Ye-HJ for pgsql-admin@arkaria.postgresql.org; Mon, 02 May 2016 18:07:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1axIFO-00010W-Vq for pgsql-admin@arkaria.postgresql.org; Mon, 02 May 2016 18:07:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1axIFO-000108-8H for pgsql-admin@postgresql.org; Mon, 02 May 2016 18:07:06 +0000 Received: from www.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1axIFH-0008SC-Ia for pgsql-admin@postgresql.org; Mon, 02 May 2016 18:07:03 +0000 Received: from [192.168.1.61] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 67326569; Mon, 2 May 2016 11:06:57 -0700 (PDT) Received: from c-73-225-27-179.hsd1.wa.comcast.net ([73.225.27.179] helo=[192.168.1.61]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 2 May 2016 11:06:56 -0700 Subject: Re: Inspect values of prepared statements To: Natalie Wenz , pgsql-admin References: <26FFD5EA-0317-497F-9CCA-BC80C6A1CA6C@ebureau.com> <5727943C.4050008@commandprompt.com> <1B7B1A44-6B19-46AF-8ED8-74098F43B45C@ebureau.com> From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <57279740.9080300@commandprompt.com> Date: Mon, 2 May 2016 11:06:56 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: <1B7B1A44-6B19-46AF-8ED8-74098F43B45C@ebureau.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-12417-10894 X-Assp-Session: 7EFE64EF6BB0 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-admin@postgresql.org X-Assp-Intended-For: nataliewenz@ebureau.com X-Assp-Original-Subject: Re: [ADMIN] Inspect values of prepared statements X-Assp-Client-SSL: yes X-Pg-Spam-Score: -2.9 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 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