It looks to me like there's many queries running that have frozen or are
just taking a long time. Is it possible to see who is connected to postgres,
and what query they're running? Or alternatively, somehow log the queries
time taken? (I have the query statements being logged, looking for the time
taken for each query to also be logged)
-mike
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Thursday, April 19, 2001 10:55 AM
> To: Mike Cannon-Brookes
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: JDBC Driver under load
>
>
> What shows up in the postmaster's log when this happens?
>
> (If you're not keeping a postmaster log, now would be a good time
> to start.)
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>