Re: Way to tell what SQL is currently running?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: "Tomka Gergely <tomka" <tomka(at)zeus(dot)gau(dot)hu>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Way to tell what SQL is currently running?
Date: 2003-08-25 17:50:09
Message-ID: 20030825104721.I93434-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Mon, 25 Aug 2003, Patrick Hatcher wrote:

> Pg_stat_activity only shows the User, PID, etc, but the Query string field
> just shows empty text

You need to turn on an option IIRC to get the query string field to be
populated (because it's extra overhead) so I don't think that'll help for
a currently running situation. Do you have any of the query logging
options turned on?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2003-08-25 18:18:40 Re: Returning SETOF RECORD
Previous Message Ron Johnson 2003-08-25 17:41:24 Re: Number of rows in a table