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

Поиск
Список
Период
Сортировка
От David Kerr
Тема PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class...
Дата
Msg-id 20130215215854.GA73541@mr-paradox.net
обсуждение исходный текст
Ответы Re: PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class...  ("René Romero Benavides" <ichbinrene@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Avoiding duplication of code via views -- slower? How do people typically do this?
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: Case insensitive hstore.