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