Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VYIBY-0004PZ-Hy for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2013 16:18:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VYIBX-0005hZ-Lj for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2013 16:18:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VYIBW-0005fm-5U for pgsql-admin@postgresql.org; Mon, 21 Oct 2013 16:18:26 +0000 Received: from nm1-vm6.bullet.mail.ne1.yahoo.com ([98.138.91.253]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VYIBR-0001r7-F0 for pgsql-admin@postgresql.org; Mon, 21 Oct 2013 16:18:25 +0000 Received: from [98.138.90.50] by nm1.bullet.mail.ne1.yahoo.com with NNFMP; 21 Oct 2013 16:18:18 -0000 Received: from [98.138.101.177] by tm3.bullet.mail.ne1.yahoo.com with NNFMP; 21 Oct 2013 16:18:18 -0000 Received: from [127.0.0.1] by omp1088.mail.ne1.yahoo.com with NNFMP; 21 Oct 2013 16:18:18 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 750057.4284.bm@omp1088.mail.ne1.yahoo.com Received: (qmail 3957 invoked by uid 60001); 21 Oct 2013 16:18:18 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1382372298; bh=frpP/GnAxBOq4h+ZV1R1Y7v2SvQ1xSyiGLeEeymwNGw=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=dVB5A1aOdwYAbfC4eAOLfyaqslJAdf3LkN2ijpSkxJqg3ZDgFAKzTdrWzLL+gXQ+h+dTclPP0k7v7/6lMeNRNdsl/3EPGFyjfbFpliuy+9QzBigK7b/43TJlQwlkbnkNJqbrK2LAh1KPRGzPXIdp5HBe0IFaNQBOyNKA20LEic0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=mgNhEcQZ8UTSDNhiL5ZewqrjIJkAKeCi3P5t/xjutTPUnNhpBwdgaVz0zPX3/cxIsXgTBKt4oXdcEMqBoAVzdYXtfH6vaKwlkCk9x2VhwHrrj7/LJEBB79AALtFs52HjPkC3joLA4hbbqlIDPlLfag2y1Wv6xhhj5r0+gBwdetM=; X-YMail-OSG: NiqjdI4VM1nMGvrdvSKHsab4F1DbUKiVP8B77LuUxeYJycT RE4iiySFp5s_gXMtap31nRqQwOeuIn3tZAfZ5rPL3ry7sq6QeR78IrlOMgKA .CB5IFNH.Q87irBenN9e5juv9UlHtJn8xdx00Y6JTzJ.ph8Pc0dd1e_WaGt. kO1G5YfIsHix.3Qt1nOBTQypN32VfTIT7nEByzYh3gjHRlz6BqciIn5mK9LN 0PDdrTXlTDxFdfJu2Mmpp7IAT4tuFOUxZwKuDKQdO547.w_cQFOcGCw.kY6Z lFwIAbRkwKJ0t4FmFReUCapBxxfOEkrfPDyV3xHdXY1PeShR5Aw0qr0etBbq yWxm7FMZP_xstJWLZazoz5VXnwh5Mx.OyDprTRHbbU.SpqWlq9bEMDXcVmrV C7o7uvqubv7YajCwQV9B4400VBOb9m9foi.HuCzWxMNMpLsgE6XBsFSUJHa. QhmedyHq.cFMHToJJDuYcyX37UG8oOIcBOJN0xRbbVZ_vYm3eG_UzcO4yRfQ IbFScMbXbZTirIHJ3aOriQETnVNiTkJouj_zDu4kG7u8csbO2vvwFVeu42j4 hUVWXf4T1M.ZAK.bhm6GLD2oVhIyP0fM- Received: from [50.241.80.25] by web125005.mail.ne1.yahoo.com via HTTP; Mon, 21 Oct 2013 09:18:18 PDT X-Rocket-MIMEInfo: 002.001, SGkKSXMgdGhlcmUgYSB3YXkgdG8gZ2V0IGNwdSB1dGlsaXphdGlvbiBvZiB2YXJpb3VzIHNxbCBzdGF0ZW1lbnRzIGR1cmluZyBhIHNwZWNpZmljIHRpbWUgcGVyaW9kwqBvbiBwb3N0Z3Jlc3FsID8KU2F5IEkgc3RhcnQgYSBwZXJmb3JtYW5jZSB0ZXN0LCBJIHdvdWxkIGxpa2UgdG8gY29sbGVjdCBhIHRvcCBzcWwgcmVwb3J0IGF0IHRoZSBlbmQgb2YgdGhlIHRlc3QgKGxpa2UgaW4gc3FsIHNlcnZlcikgdGhhdCBnaXZlcyBkZXRhaWxzIG9mIHRoZSB0b3AgY3B1IGNvbnN1bWluZyBzcWxzLi4gCkFsc28gd28BMAEBAQE- X-Mailer: YahooMailWebService/0.8.160.587 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> Message-ID: <1382372298.2702.YahooMailNeo@web125005.mail.ne1.yahoo.com> Date: Mon, 21 Oct 2013 09:18:18 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: CPU usage by sqls To: "pgsql-admin@postgresql.org" In-Reply-To: <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1988236031-563350763-1382372298=:2702" X-Pg-Spam-Score: 0.3 (/) 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 --1988236031-563350763-1382372298=:2702 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi=0AIs there a way to get cpu utilization of various sql statements during= a specific time period=A0on postgresql ?=0ASay I start a performance test,= I would like to collect a top sql report at the end of the test (like in s= ql server) that gives details of the top cpu consuming sqls.. =0AAlso wonde= ring if there is a sql profiler on postgressql that indicates the number of= rows read and written to by sql statements, cpu cost, elapsed time etc=A0d= uring a profiled session.=0Athanks,=0Athara. --1988236031-563350763-1382372298=:2702 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi
Is there a way to get cpu utilization of various= sql statements during a specific time period on postgresql ?
Say I start a performance test, I would like to = collect a top sql report at the end of the test (like in sql server) that g= ives details of the top cpu consuming sqls..
Also wondering if there is a sql profiler on pos= tgressql that indicates the number of rows read and written to by sql state= ments, cpu cost, elapsed time etc during= a profiled session.
thanks,
thara.
--1988236031-563350763-1382372298=:2702--