Monitoring PostgreSQL on Windows 2003

--005045013dbfd57464048a667516
Content-Type: text/plain; charset=ISO-8859-1

Hi! We have an application running .NET (C#) and Postgre on Windows 2003
with 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 also noticed loads of writes from postgresql even when less
customers are using 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

--005045013dbfd57464048a667516
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 also noticed loads of writes from postgresql even when less customers ar=
e using our software.


My question is: What are the options to better monitor postgre on Windo=
ws? How can I see all the running sql commands on the server?

Thanks=
a lot.

Vitor


--005045013dbfd57464048a667516--

Re: Monitoring PostgreSQL on Windows 2003

--_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@postgresql.org [mailto:pgsql-admin-owner@postgresql.=
org] Im Auftrag von V=EDtor
Gesendet: Freitag, 2. Juli 2010 14:10
An: pgsql-admin@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

1">
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">