Re: Query gone wild

You might locate the process id with ps.... If someone has a connection on
the DB -- It'll show the IP address of the user and a pid...

--> ps ax | grep postgres

"Garo Hussenjian" <garo(at)xapnet(dot)com> wrote in message
news:BA5D5658(dot)6E5D%garo(at)xapnet(dot)com(dot)(dot)(dot)
> I'm trying to track down a query in a web application that has postgresql
in
> a deadlock. I don't know which query is running because I only see the
> listing in ps aux (for now, anyway)... Is there any way to view the query
> that is being run from knowing a process id?
>
> Garo.
>
> =-=-==-=-=-==
>
> Xapnet Internet Solutions
> 1501 Powell St., Suite N
> Emeryville, CA 94608
>
> Tel - (510) 655-9771
> Fax - (510) 655-9775
> Web - http://www.xapnet.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster