| From: | David Kerr <dmk(at)mr-paradox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class... |
| Date: | 2013-02-15 21:58:55 |
| Message-ID: | 20130215215854.GA73541@mr-paradox.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lawrence Barwick | 2013-02-16 00:12:37 | Re: Case insensitive hstore. |
| Previous Message | Merlin Moncure | 2013-02-15 21:58:43 | Re: Avoiding duplication of code via views -- slower? How do people typically do this? |