Re: Way to tell what SQL is currently running?

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@zeus.gau.hu>           To:     Patrick Hatcher <PHatcher@macys.com>
                        
                    Sent by:                      cc:     <pgsql-novice@postgresql.org>
                        
                    pgsql-novice-owner@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?

               http://www.postgresql.org/docs/faqs/FAQ.html