Blocking Alert
От | Anjul Tyagi |
---|---|
Тема | Blocking Alert |
Дата | |
Msg-id | em8a51f507-acad-493c-9420-3931662d49ee@iboss01081 обсуждение исходный текст |
Ответы |
Re: Blocking Alert
|
Список | pgsql-admin |
Hi All,
we recently implement the blocking alert in our production server. However whenever we receive the blocking alert, we need th actual parameters value to figure out the issues. Can you please help up to get the actual parameter value in place of $1 and $2.
blocked_pid | blocked_user | blocked_duration | blocking_pid | blocking_user | blocking_duration | blocked_statement | blocking_statement
-------------+--------------+------------------+--------------+---------------+-------------------+-------------------------------------------------------------------------+-------------------------------------------------------------------------
21961 | ssusers | 00:00:03.729771 | 15928 | ssusers | 00:00:24.207317 | select * from get_updated_doc_list($1,XML($2)) as result | select * from get_updated_doc_list($1,XML($2)) as result
(1 row)
-------------+--------------+------------------+--------------+---------------+-------------------+-------------------------------------------------------------------------+-------------------------------------------------------------------------
21961 | ssusers | 00:00:03.729771 | 15928 | ssusers | 00:00:24.207317 | select * from get_updated_doc_list($1,XML($2)) as result | select * from get_updated_doc_list($1,XML($2)) as result
(1 row)
Regards,
Anjul TYAGI
ü Go Green
В списке pgsql-admin по дате отправления: