Re: query execution - Mailing list pgsql-general

From Richard Huxton
Subject Re: query execution
Date
Msg-id 43439033.8050201@archonet.com
Whole thread Raw
In response to query execution  (Matthew Peter <survivedsushi@yahoo.com>)
List 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

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: transaction toggling
Next
From: Richard Huxton
Date:
Subject: Re: Untyped result (setof / rowset) from Functions ?