Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ty4vl-0001ZS-IX for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2013 18:20:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ty4vl-000581-1A for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2013 18:20:13 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ty4vj-00056S-2e for pgsql-admin@postgresql.org; Wed, 23 Jan 2013 18:20:11 +0000 Received: from nm9-vm4.bullet.mail.ne1.yahoo.com ([98.138.91.169]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ty4vg-0005QL-S5 for pgsql-admin@postgresql.org; Wed, 23 Jan 2013 18:20:10 +0000 Received: from [98.138.226.177] by nm9.bullet.mail.ne1.yahoo.com with NNFMP; 23 Jan 2013 18:20:08 -0000 Received: from [98.138.226.166] by tm12.bullet.mail.ne1.yahoo.com with NNFMP; 23 Jan 2013 18:20:08 -0000 Received: from [127.0.0.1] by omp1067.mail.ne1.yahoo.com with NNFMP; 23 Jan 2013 18:20:08 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 44421.51262.bm@omp1067.mail.ne1.yahoo.com Received: (qmail 51397 invoked by uid 60001); 23 Jan 2013 18:20:07 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1358965207; bh=Gn7gmNPjMg+VCxXESgUFDHzzWR3ySSYknw/u0/MPoPE=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=h7Yys7tQJjInEg9lbt3Cns+ocb1YfyJC1PR75QavkbhcwgcRd+HhFHrgKcGidp8WEMJ2G2eUbrTRjMf1R6JNN7GqrMqVH1P09jO47vk/tfk9p/yBNPkDbpJS4eY4CpUJEhcd3K8KpYVOnJj6fh4Ep0FwYOmaeoAvtaCzx++/g2A= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=TaE9lpHJswqt375liIXLfk9RDKABaKDl4892kQGZDKki4Sk82HIO80KOhV367D2WI4o/OEvfxiorJ2ySewDMNzEDJK1JFvTQwYko0V4pOjIWJlO+lwqEN7zI+/zFpSXsfTDRC3aEoVbOJ+RNGhTQanUAIXFCKf3N+d/jTqt8h8U=; X-YMail-OSG: aMpA1r4VM1kOcGC0ZiqXuCnMgsbLz5OsxLJhKWeIPg.t9do HPvNz3J1z.tSoJaBYCj5vyPa5pUEUafRtbOioz2E_Jl5U_DxndrhK95NVCLp HxgggSvKeJw3vcKpd7pwHSuuvBwnXDgJTweNcBlyNMraB87R0PgyB2MrV2nR JKcjSZ9.znwKYDKHlknsXKTlL9VfU5kbVOepatGkXWG0a4zAPLlOdC6noRmr 36FZa8mhXYso8lfqcRU9CKzUWF2_uxzt_PVlAFuBjGBAXbj2AvpjHNkXGlDv 9ZWYDeSjhZgKLn.ZFMsGqsJwolhsgqszBoQtrNwZFdixvkXEQ5cuk9SZrP.j udsO7ScKK6mSQYm.ir.27xSKtMzen9_MSF9moAbHKMMg1QCcIRMIaT3aQMIP xJqcwLVleMBrQu7ZnM_0bTK42thwxZWYScv2tQYtEj9kD3J2Ru3XJoAPzPLa Y6V.AEIpW1qiv2NfKAWkDT20doZqbBru3Iu4cGkX4WdJRMRLChV3nNGU- Received: from [208.84.47.48] by web120905.mail.ne1.yahoo.com via HTTP; Wed, 23 Jan 2013 10:20:07 PST X-Rocket-MIMEInfo: 001.001, SGVsbG8sCkkgYW0gYSBuZXdiIGluIFBvc3RncmVzIGNvbWluZyBmcm9tIE9yYWNsZS4gRG9lcyBhbnlvbmUga25vdyBpZiBpdCdzIHBvc3NpYmxlIHRvIHNlZSB0aGUgcGxhbiBiZWluZyBleGVjdXRlZCBieSBQb3N0Z3JlcyBmb3IgYW4gYWN0aXZlIHNxbCBzdGF0ZW1lbnQgKGZyb20gcGdfc3RhdF9hY3Rpdml0eSkuIFRoaXMgaXMgdG8gYmUgYWJsZSB0byB0cm91Ymxlc2hvb3QgcG9vciBwZXJmb3JtaW5nIG9uZXMgYW5kIGluIE9yYWNsZSB3ZSBhcmUgYWJsZSB0byByZXRyaWV2ZSBzdWNoIGEgcGxhbi4KQWQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.130.494 Message-ID: <1358965207.49445.YahooMailNeo@web120905.mail.ne1.yahoo.com> Date: Wed, 23 Jan 2013 10:20:07 -0800 (PST) From: Dan Ng Reply-To: Dan Ng Subject: Getting To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1517483800-2032981185-1358965207=:49445" X-Pg-Spam-Score: 0.8 (/) 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 --1517483800-2032981185-1358965207=:49445 Content-Type: text/plain; charset=us-ascii Hello, I am a newb in Postgres coming from Oracle. Does anyone know if it's possible to see the plan being executed by Postgres for an active sql statement (from pg_stat_activity). This is to be able to troubleshoot poor performing ones and in Oracle we are able to retrieve such a plan. Additionally, how do I see the actual sql statement that shows as "". Thanks so much for any advice you all may have. -Dan --1517483800-2032981185-1358965207=:49445 Content-Type: text/html; charset=us-ascii
Hello,
I am a newb in Postgres coming from Oracle. Does anyone know if it's possible to see the plan being executed by Postgres for an active sql statement (from pg_stat_activity). This is to be able to troubleshoot poor performing ones and in Oracle we are able to retrieve such a plan.
Additionally, how do I see the actual sql statement that shows as "<unnamed portal x>".
Thanks so much for any advice you all may have.
-Dan
--1517483800-2032981185-1358965207=:49445--