Обсуждение: Way to tell what SQL is currently running?

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

Patrick Hatcher

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..."

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

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 postgres.conf set
stats_command_string = true

C.

Patrick Hatcher wrote, On 8/25/2003 7:37 PM:
> Pg_stat_activity only shows the User, PID, etc, but the Query string field
> just shows empty text
>

Hi, now I know that in order to call a SETOF RECORD function i have to put
something like:
Select foo(param1,param2) as (ccolname1,colname2)

Now I am using JDBC and CallableStatement.
How should I give the column name list so that the function works ok?
Suppose i have the foo function that returns a SETOF RECORD and a callable
statement c.

Thanks a lot!

JuanF
(A newbie in evolution!)