| From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
|---|---|
| To: | "Tomka Gergely <tomka" <tomka(at)zeus(dot)gau(dot)hu> |
| Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org |
| Subject: | Re: Way to tell what SQL is currently running? |
| Date: | 2003-08-25 17:37:24 |
| Message-ID: | OFFECC3C0A.2967A138-ON88256D8D.005F803E-88256D8D.00617403@fds.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Pg_stat_activity only shows the User, PID, etc, but the Query string field
just shows empty text
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM
Tomka Gergely
<tomka(at)zeus(dot)gau(dot)hu> To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Sent by: cc: <pgsql-novice(at)postgresql(dot)org>
pgsql-novice-owner(at)post Subject: Re: [NOVICE] Way to tell what SQL is currently running?
gresql.org
08/25/2003 10:13 AM
2003-08-25 ragyogó napján Patrick Hatcher ezt üzente:
> I'm finding that some update process is holding all other transactions on
a
> particular table. Is there a way to tell what the Update statement is
that
> is running? I tried to use TOP, but it does not provide enough of the
SQL
> string to help.
> TIA
Hmm, i have a pg_stat_activity table, this is enough?
--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-25 17:41:24 | Re: Number of rows in a table |
| Previous Message | Tomka Gergely | 2003-08-25 17:13:29 | Re: Way to tell what SQL is currently running? |