postgresql statements are waiting

Поиск
Список
Период
Сортировка
От bakkiya
Тема postgresql statements are waiting
Дата
Msg-id 1291117080292-3285939.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: postgresql statements are waiting  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: postgresql statements are waiting  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Hi,
I am working on a performance issue with a partitioned table. Some of my sql
statements against this partition table is in waiting state for long time. I
have queried waiting=true in pg_stat_activity. Now, is there a way to find
out which sql is making other statements to wait.

Thanks for your help.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-statements-are-waiting-tp3285939p3285939.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

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

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: Simple database, multiple instances?
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow