From Kellyton.Feitosa@gyn.politec.com.br Mon Oct 6 13:27:41 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7F1F837C6DC for ; Mon, 6 Oct 2008 10:27:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76222-09 for ; Mon, 6 Oct 2008 10:27:31 -0300 (ADT) X-Greylist: delayed 00:05:29.838116 by SQLgrey-1.7.6 Received: from mail.bsb.politec.com.br (mail.bsb.politec.com.br [200.252.229.131]) by postgresql.org (Postfix) with ESMTP id F3D1A37C2C3 for ; Mon, 6 Oct 2008 10:27:29 -0300 (ADT) Received: by mail.bsb.politec.com.br (Postfix, from userid 1003) id 490D3E6326; Mon, 6 Oct 2008 10:21:57 -0300 (BRT) Received: from BSBSERV039.bsb.politec.com.br (unknown [10.61.1.228]) by mail.bsb.politec.com.br (Postfix) with ESMTP id 20494E618D for ; Mon, 6 Oct 2008 10:21:57 -0300 (BRT) Received: from GYNSERV002.gyn.politec.com.br ([10.62.1.2]) by BSBSERV039.bsb.politec.com.br with Microsoft SMTPSVC(6.0.3790.3959); Mon, 6 Oct 2008 10:22:01 -0300 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----_=_NextPart_001_01C927B6.837AB33C" Subject: Monitoring postgres X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Date: Mon, 6 Oct 2008 10:22:00 -0300 Message-ID: <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: Monitoring postgres Thread-Index: AcknteOfOGkKHGA9TFipMgWGPbs3MwAAGcUg X-Priority: 1 Importance: high From: "Kellyton Campos Feitosa - GYN" To: X-OriginalArrivalTime: 06 Oct 2008 13:22:01.0614 (UTC) FILETIME=[846E92E0:01C927B6] X-Bogosity: Unsure, tests=bogofilter, spamicity=0.520000, version=1.1.7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.001 tagged_above=0 required=5 tests=EXTRA_MPART_TYPE=1, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200810/215 X-Sequence-Number: 125232 This is a multi-part message in MIME format. ------_=_NextPart_001_01C927B6.837AB33C Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C927B6.837AB33C" ------_=_NextPart_002_01C927B6.837AB33C Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Dears, =20 I need monitor a postgres database, but I don't know which tool to use. The tool need perform the below actions =20 1. show transactions pendents 2. show the statistics per session actives 3. show the statistics per database 4. show metrics per session and database 5. show rows locks 6. show slow activities statements (SELECT, INSERT, UPDATE, DELETE) 7. to allow set a trace to a specific session, similar the tool dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle Database =20 =20 Thanks =20 =20 =20 =20 Kellyton Campos Feitosa Analista de Suporte - DBA Politec Global IT Services +55(62) 3219-3284 Kellyton.Feitosa@gyn.politec.com.br www.politec.com.br =20 =20 =20 ------_=_NextPart_002_01C927B6.837AB33C Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Dears,

= I need monitor a postgres database, but I don’t = know which tool to use.

= ; The tool need perform the below actions

show = transactions pendents
show the = statistics per session actives
show the = statistics per database
show = metrics per session and database
show rows = locks
show slow = activities statements (SELECT, INSERT, UPDATE, = DELETE)
to allow = set a trace to a specific session, similar the tool dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle = Database

= ; Thanks

= Kellyton Campos Feitosa

Analista de Suporte - = DBA

Politec Global = IT Services

+55(62) = 3219-3284

Kellyton.Feitosa@g= yn.politec.com.br

www.politec.com.br<= /font>

------_=_NextPart_002_01C927B6.837AB33C-- ------_=_NextPart_001_01C927B6.837AB33C Content-Type: image/gif; name="image001.gif" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image001.gif Content-Location: image001.gif R0lGODlhkABpAOYAAPrajPjNY/S1FbOzsvjScv757ffIU/fGS//9+fW+Mry7u//89ZeWlf714Pn5 +fjQa9bW1f303crKyf746N7e3tra2f3w0fS2GvzqvfX19fbAOfnUefbERfDw8Pvns+bm5vrckO7u 7vfKWPzuyf768PrdlfW6Ja2trIeGhfvhofW5IfvipfSyDurq6vztxfvlrfOvA+Li4v/+/MXFxP3y 1aalpfrfmfW9LvnYhfzpuf735MLCwfrgnf7+/tzc3M3NzfbCPvnVfPW7Kfz8/P3z2fLy8v3vzPfM XtHQ0PbDQfzrwKqpqY+OjfOwBvOxCfnXgO3s7Pvkqvzotvzsw/jPZ6ysq6SjoqWkpIuKiY2Mi4WE g+Dg34iHhoSDguTk4/302/SxC4yLipCPjv3wz6ampYmIh6iop/S4HtjY1/W8K/vjp6enpqinp8jI x9TT07GxsNzc2/fLW7i3tr+/vtzb29fW1ufn56GgoKWko5KRkKCfn8vLy6+vroOCgfOuAP///yH5 BAAAAAAALAAAAACQAGkAAAf/gH+Cg4SFhoeIiYqLjI2Oj5CRkpOUlZaXmJmam5ydnp+goaKjpKWm p6ipqpg0KQ8cQiomJrJAASUjCKu7pxMlHCx+wsPEwk4JOBG8y58FOCrF0dICD0TM15hqQtLc0wAy 2OGQBQHd5tIc1uLriREa5ywmCQlCAudnSuz6hDTQ0jAanmBoUGDBAhI6XIA4EEwaCyn79H0xIc1J gBGMiGywF40FhojiSLyLlsQFoQIvdLSLI+0CDZDYqEjbsIBQg3cmLCiy0ZAYkJoweb2I1qREoQg3 hql4mSgHR2JPgu4iQbGYUUILRg4ToqxpT2EsmEpFBSAaAUMTng670UBRimhH/8aiKuBvmAaghWxI S6AyUTliTnTKLbWiWJN8iErAiKZhQiIdav2cHUzqQDEDi0BIA1Ig0ZNiJkhQFtVALYyPi3CgE32o dLEco0MNJXYDr6LP0Q7YJiSiWNTYnzYUe/BIeO7dgngUOwD8k4FiaiARkGYAuYUmxNIgb25JhlY/ TYxEeiAtji5CJOr6EdCWu6YF24axjyTjb7EA5wUh+O5ErPtLBVxAzAV9RWJZNKgJIgMHxMAg3n+Y FKDWBY5FggCD0SCmIIbCOAghJgtUJcx8kCzQm1ngDLIfYP59OIl3DT7oCAJHSENFioOkR4wABbpI yYnDrPCIDDJFEwCOg4yB3f8w2vloSRDFUPEIedHEgeQgehGDmZOVeFCMENsZMl00IuRXyHPE4MBl JZA1CNsixl0W5hdfwaDhmpKgOcyWnlEX5h9xCgMmnpTMNsxhiaiWG2uHfBHZb4RKskAaxWhg5iCF RcMBo4foCZY6kUqSJTEbHAIESZ0lUtZwoVKyYoNCEoJAUj6likgUS8rXXquSYJArWC/ISqswTZiU yApfCQMCr5VAWYwTV/0xKzEsCGYIAk8sttylzD6CwIHFHNFeAsSAYS0hI3BIjAm7ditJAd8NcwEA GAg4jLlYKXGEEy3J6O4kE8TbDb5/jLHBsNGcYey/lUzg6cA65ZBsMQm0yPD/JAgEwa85+NonzREV XowJBgIDphNL0pgQncibIMADuQ61RSUxKuBgK8ubLODBEfYOY+UfIzQkwAEp3IyzJxNIgUMcGlBh 6xRPRNHu0aRcSfXVWGet9dZcd+3112CHLfZgPURadlBtWHHF2my3zfYSCnxASA91DFCD226bIQcF hNhBxhtIDLFIC2sALvgfPfzAx914423FCQ4I4oUcbODR+NpkDADB2YL04Ibdl69thgIxSMJHH6in rvrqfZQBgSBDDMD67Kh30cYgFKRexeGIxJD6EpH/QPvweUS+BwrDsz7A4Q5UkfzqKOzRAiSyP786 A5FXYP3qWRQhyBZapF6B/yJeII96HX+YsX3qYrjxRwdhrJ+6D4IgIT/qXJxAfeplIEGBDwAMIAVq wL4M/KENqmvDFgIYwC28IXUomN4fwJe6H5DPfH24XQzcAIEO1gENd0gdFn6ABgjUwQfe+8MHwoe6 ASyQgTCEQwU6IIg5QLANJeygDncIATSU7hHV60MYaHgIORTwDxJIXRfkdogZQFCCFESdBRNRvtRJ ABEPRJ0YImcIO2BwD5DYQeq4EAJPBBELUBhEB0LQgTaeIHVMMGASa/dDQ4gRdRH8Hgv7MEVEVBF1 VzzE6VDHhBQWwoupm0MbF8nIRYaAi3fsAxckyIkzprEDNQgDFjYZBgxiD/+JSqxjISKZxwnusY+H +GMfAmmIQfahkIdAJP6ysMla2nKTXKCDICI5STOKsIxrSF4g59iHLoiSEKSE4ikvaEVEuBKWXcTg 9u4AyTFSchNn7IADGJCFbnqTCQw4ARwGQUxjIiKZeqwgMwHpTDgasm8Y5AITvElPJohBDzPg4h94 eU1NWLIHjVykPgVRzmMOAp2mVCcVMcjKQjzznYOQZR8UGdA2GnCU1vQl6tD4iHIy0RBOxKMyU4eE da6ynYSEqCAkCsZHRLIMZexEEMOQRkeUUwIUyKlOKbCFIJZyC11InQK2sFOdbqEHqmwoIZ5JxEKs MHUuLKpUfUBEG+JxDxX/yKpWt5pVOny0EUHc4iO0d7/uCQIK0qQdA3pQhPixU5BwvGghipCF+/Vh fH9wg12zMABIuHIGkOiBEdfXBcAe9HlcQIMgfmC+2x3Ceah7QyIYK7/dwe6N6yuDG5raiDbUQA54 jUQFBkCGGpj2tKjVG98KQQHKoda0S5jDNT+gADIotolWWMIO5HoI2prhta/NnBs4hzgI2A24qI1t P8fG3OY697nQja50p0vdq8mgANwqCCKuyy3nGiEAHDhCDgoAhHMJwgA8QIQONCCjHEThBQ/YwBMI QAB1yAAEHAjA1BIBAowQagoXeIANHgCACajAvzjSQLQUJIgGKGwQBEiC/xSCYAAwECAIXxAEAG4w 4DEwmBBXCkKCQExi4NjCJkIQDwDC2xYOxMEAcZjAAghwgAAUQAcHHsQGOCAIKQgBSUfg8SDwC4A/ 0CAABOAAAWoCghQAYAp/UMMBDoABGexYSBOgAgf6OxoSCMADKG6FCTDwACBc6AYp0ICNbTCCGwAg Pf4FlJBfEBpCWMAEGtAJDzSghAR4YASSecEFlAAfkqUgaCDIgUZEgAETECEIQHCBEkAlFwmB+Q8p sMEEUnyAIPwhAiwgAgeMkoI0yGAED5gXnHU85zoTYgIiEMAIAqCCOAggCEa4ADio8AApAOEPGngB pAdxgxvEoQlqkMIFCP9gtLHIIAFS+gMVDkACIYzBAKWiUwSSYIM/lAAIHhCCFDQAgAXkWBA7FgSd OTWIGj8gCVOYQgGUcIaaKEEICgb2C3CgAWIHQAkj6AwNDpCAUo1GCiwIQg40IIIAWSAKKlCDCA7g HQ2ogdxqEEAKat2ACyyMAP2O8gVuBgAA0NkGU1BBCtSgBCWwQDQIEAIMHJOGFDiKACXAQAlM8IIU WEANK3jAGQIAHA9MXLwLCEJbeCCCBzgGABuIAw4QsIANBCAKVKDBE7ryhxcs6w9GCIJtVmCAA3yj 63E4wkA2cB41fB0HUFaCCOIA5RKIIABEkELaXRAyyuigBBuwQQMQ4IFRzlgAAFEQBAZyAALEeIAH DeCBDqRgKwsgpgFSMNPhn2CsBpSgBBEogAdSZAFjYUAZBfh8W8YAAB4U4AslsEEBrFbd2tv+9rjP ve53z/vefygQADs= ------_=_NextPart_001_01C927B6.837AB33C-- From scrawford@pinpointresearch.com Mon Oct 6 15:47:39 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4B1FF37C874; Mon, 6 Oct 2008 12:47:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18690-09; Mon, 6 Oct 2008 12:47:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id BF02237BAE0; Mon, 6 Oct 2008 12:47:31 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 0B597E00EC84; Mon, 6 Oct 2008 08:47:30 -0700 (PDT) Message-ID: <48EA3311.1060204@pinpointresearch.com> Date: Mon, 06 Oct 2008 08:47:29 -0700 From: Steve Crawford User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: Kellyton Campos Feitosa - GYN CC: hackers@postgresql.org, "pgsql-admin@postgresql.org Admin" Subject: Re: [HACKERS] Monitoring postgres References: <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br> In-Reply-To: <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/30 X-Sequence-Number: 30486 Kellyton Campos Feitosa - GYN wrote: > > Dears, > > I need monitor a postgres database, but I don=92t know which tool to us= e. > > The tool need perform the below actions > > 1. show transactions pendents > 2. show the statistics per session actives > 3. show the statistics per database > 4. show metrics per session and database > 5. show rows locks > 6. show slow activities statements (SELECT, INSERT, UPDATE, DELETE) > 7. to allow set a trace to a specific session, similar the tool > dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle Database > > This is better asked in the administration (or general) mailing list. I=20 don't know of a single magic-bullet tool that does everything you list=20 but you might try with the PostgreSQL docs starting with the monitoring=20 and logging sections. http://www.postgresql.org/docs/8.3/interactive/monitoring.html http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.htm= l Then Google "postgresql monitoring tool" and see what's available=20 including commercial products from EnterpriseDB: http://www.enterprisedb.com/products/postgres_plus_as.do (dig into the=20 docs and see what their monitoring stuff does) and monitoring tools such as Hyperic that have PostgreSQL plugins: http://www.hyperic.com/products/managed/postgresql-management.htm Cheers, Steve