Re: PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class...

I can confirm it comes from pgpool, and is very weird , I guess the pgpool list
would be a better fit.
Cheers.

On Friday, February 15, 2013 01:58:55 PM David Kerr wrote:
> Howdy!
>
> This query is coming from PgPool I believe.
>
> SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname =
> 'import_jobs' AND c.relpersistence = 'u'
>
> This is a very small database, like 10/15 tables, it's basically empty.
> If i run this query manually, it comes back immediatly.
> However according to this it's been running for about an hour.
>
> v3=# select now();
> now
> -------------------------------
> 2013-02-15 21:49:34.470466+00
> (1 row)
>
> -[ RECORD 5
> ]----+---------------------------------------------------------------------
> ------------------------------------ datid | 16389
> datname | v3
> pid | 13905
> usesysid | 20415
> usename | workling
> application_name |
> client_addr | 10.0.0.132
> client_hostname |
> client_port | 58009
> backend_start | 2013-02-15 20:49:09.098768+00
> xact_start | 2013-02-15 20:49:09.189625+00
> query_start | 2013-02-15 20:49:09.198742+00
> state_change | 2013-02-15 20:49:09.198743+00
> waiting | f
> state | active
> query | SELECT count(*) FROM pg_catalog.pg_class AS c WHERE
> c.relname = 'import_jobs' AND c.relpersistence = 'u'
>
> (I actually restarted the application and now there are 4 of these)
>
> Any idea why the query would hang like this?
>
> I don't see it waiting on locks or anything like that.
>
> any ideas?
>
> Thanks
--
René Romero Benavides @iCodeiExist @PgsqlMx

Postgresql Tips en español para la comunidad de México e Hispanoamérica.
http://postgresql.org.mx