Postgres Pro
Downloads
Home   >   mailing lists

Thread: Way to tell what SQL is currently running?

Way to tell what SQL is currently running?

From
"Patrick Hatcher"
Date:
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

Re: Way to tell what SQL is currently running?

From
Tomka Gergely
Date:
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..."

Re: Way to tell what SQL is currently running?

From
"Patrick Hatcher"
Date:
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

Re: Way to tell what SQL is currently running?

From
Stephan Szabo
Date:
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?

Re: Way to tell what SQL is currently running?

From
CoL
Date:
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
>

Using RECORD returning functions with JDBC

From
Juan Francisco Diaz
Date:
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!)