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ítor
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 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