Re: query execution

From: Richard Huxton <dev(at)archonet(dot)com>
To: Matthew Peter <survivedsushi(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query execution
Date: 2005-10-05 08:34:59
Message-ID: 43439033.8050201@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthew Peter wrote:
> There a way to watch queries execute on the pgsql
> server as queries come in from the network and are
> processed?

You could try "SELECT * FROM pg_stat_activity", though it's not
guaranteed to be complete. Look in the manuals for the chapter
"Monitoring Database Activity".

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-05 08:38:34 Re: Untyped result (setof / rowset) from Functions ?
Previous Message Matthew Peter 2005-10-05 07:49:33 transaction toggling