Monitoring postgres
От | Kellyton Campos Feitosa - GYN |
---|---|
Тема | Monitoring postgres |
Дата | |
Msg-id | 90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br обсуждение исходный текст |
Ответы |
Re: Monitoring postgres
(Steve Crawford <scrawford@pinpointresearch.com>)
|
Список | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Dears,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial">I need monitor a postgres database, but I don’t know which tool to use.</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> The tool need perform the below actions</span></font><p class="MsoNormal"><font face="Arial"size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> </span></font><ol start="1" style="margin-top:0cm" type="1"><li class="MsoNormal" style="mso-list:l1level1 lfo3"><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">showtransactions pendents</span></font><li class="MsoNormal" style="mso-list:l1level1 lfo3"><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">showthe statistics per session actives</span></font><li class="MsoNormal" style="mso-list:l1level1 lfo3"><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">showthe statistics per database</span></font><li class="MsoNormal" style="mso-list:l1level1 lfo3"><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">showmetrics per session and database</span></font><li class="MsoNormal" style="mso-list:l1level1 lfo3"><font face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">showrows locks</span></font><li class="MsoNormal" style="mso-list:l1 level1 lfo3"><fontface="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">show slow activities statements(SELECT, INSERT, UPDATE, DELETE)</span></font><li class="MsoNormal" style="mso-list:l1 level1 lfo3"><font face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">to allow set a trace to a specific session,similar the tool dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle Database</span></font></ol><p class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> Thanks</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial"> </span></font><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse:collapse"><tr><tdstyle="width:122.4pt;padding:0cm 3.5pt 0cm 3.5pt" valign="top" width="163"><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"><img height="105" id="_x0000_i1025"src="cid:image001.gif@01C9279D.5DEC0F30" width="144" /></span></font></td><td style="width:360.0pt;padding:0cm3.5pt 0cm 3.5pt" valign="top" width="480"><p class="MsoNormal"><b><font color="gray" face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:gray;font-weight:bold">Kellyton Campos Feitosa</span></font></b><pclass="MsoNormal"><font color="gray" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:gray">Analistade Suporte - DBA</span></font><p class="MsoNormal"><font color="gray" face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">Politec Global IT Services</span></font><pclass="MsoNormal"><font color="gray" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">+55(62)3219-3284</span></font><p class="MsoNormal"><font color="gray"face="Arial" size="1"><span lang="EN-US" style="font-size:8.0pt;font-family:Arial;color:gray">Kellyton.Feitosa@gyn.politec.com.br</span></font><p class="MsoNormal"><fontcolor="gray" face="Arial" size="1"><span style="font-size: 8.0pt;font-family:Arial;color:gray">www.politec.com.br</span></font><pclass="MsoNormal"><font color="gray" face="Arial" size="1"><spanstyle="font-size: 8.0pt;font-family:Arial;color:gray"> </span></font></td></tr></table><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div>
В списке pgsql-hackers по дате отправления: