--_000_C79CA8D604BB464FBC97C06F2631D48F089FCEE0winxbede34exc ha_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You can use
select client_addr, current_query from pg_stat_activity;
to show all db-connection and the running queries.
Regards,
murphy
Von: pgsql-admin-owner [at] postgresql.org [mailto:pgsql-admin-owner [at] postgresql.=
org] Im Auftrag von V=EDtor
Gesendet: Freitag, 2. Juli 2010 14:10
An: pgsql-admin [at] postgresql.org
Betreff: [ADMIN] Monitoring PostgreSQL on Windows 2003
Hi! We have an application running .NET (C#) and Postgre on Windows 2003 wi=
th almost 1500 schemas which only 350 schemas are active daily (one schema,=
one customer). Lately, we've noticed that our server is getting slow. We a=
lso noticed loads of writes from postgresql even when less customers are us=
ing our software.
My question is: What are the options to better monitor postgre on Windows? =
How can I see all the running sql commands on the server?
Thanks a lot.
Vitor
--_000_C79CA8D604BB464FBC97C06F2631D48F089FCEE0winxbede34exc ha_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DDE link=3Dblue vlink=3Dpurple>
<div class=3DWordSection1>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>You can use <o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Courier N=
ew";
color:#1F497D'>select client_addr, current_query from pg_stat_activity;<o:p=
></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>to show all db-connection and the running queries.<o:p></o:p=
></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>Regards,<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>murphy<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm =
0cm 0cm'>
<p class=3DMsoNormal><b><span style=3D'font-size:10.0pt;font-family:"Tahoma=
","sans-serif"'>Von:</span></b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >
pgsql-admin-owner [at] postgresql.org [mailto:pgsql-admin-owner [at] postgresql.org] =
<b>Im
Auftrag von </b>V=EDtor<br>
<b>Gesendet:</b> Freitag, 2. Juli 2010 14:10<br>
<b>An:</b> pgsql-admin [at] postgresql.org<br>
<b>Betreff:</b> [ADMIN] Monitoring PostgreSQL on Windows 2003<o:p></o:p></s=
pan></p>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Hi! We have an application running .NET (C#) and Postg=
re on
Windows 2003 with almost 1500 schemas which only 350 schemas are active dai=
ly
(one schema, one customer). Lately, we've noticed that our server is gettin=
g
slow. We also noticed loads of writes from postgresql even when less custom=
ers
are using our software.<br>
<br>
My question is: What are the options to better monitor postgre on Windows? =
How
can I see all the running sql commands on the server?<br>
<br>
Thanks a lot.<br>
<br>
Vitor<o:p></o:p></p>
</div>
</body>
</html>
--_000_C79CA8D604BB464FBC97C06F2631D48F089FCEE0winxbede34exc ha_--
